{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "140.11"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"rows_examined_per_scan": 100,
"rows_produced_per_join": 100,
"filtered": "100.00",
"cost_info": {
"read_cost": "120.11",
"eval_cost": "20.00",
"prefix_cost": "140.11",
"data_read_per_join": "169K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (431325,381712,339825,431042,430845,430885,430976,431200,431316,381711,430756,430801,430865,430887,430904,430939,430992,431003,431393,430661,430936,431238,431251,339855,430753,430836,431011,431046,431061,431333,430810,430866,431029,431072,431171,431193,430932,431052,430788,430809,430905,430927,430999,431192,431205,431463,430634,430749,430862,430910,431062,430870,430923,431039,339726,430794,431024,431091,431314,431326,431327,430708,430714,431315,430677,430704,430853,430888,430895,431028,431098,431242,430675,430687,430707,430811,431339,430641,430713,430851,431112,431365,430694,430738,430782,430827,430861,430874,430937,431077,431308,339838,430947,431245,339841,430800,430852,430855,431054,431129)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
339726 | filtro-kaysimoy-muller-filter-fn160-en | 266/394/395 |
339825 | filtro-ladioy-mann-hu1297x-en | 266/394/395 |
339838 | filtro-ksirantira-mann-tb-1394-6x-en | 266/394/395 |
339841 | filtro-aeros-anathymiaseon-filtron-ak-360-2-mann-c811-en | 266/394/395 |
339855 | filtro-ladioy-mann-hu-1381x-en | 266/394/395 |
381711 | dhome-dopio-en-2 | 266/2577/2578 |
381712 | double-room-en | 266/2577/2578 |
430634 | product-430634 | 266/1936/2601 |
430641 | product-430641 | 266/1936/2601 |
430661 | product-430661 | 266/1936/2601 |
430675 | product-430675 | 266/1936/2601 |
430677 | product-430677 | 266/1936/2601 |
430687 | product-430687 | 266/1936/2601 |
430694 | product-430694 | 266/1936/2601 |
430704 | product-430704 | 266/1936/2601 |
430707 | product-430707 | 266/1936/2601 |
430708 | product-430708 | 266/1936/2601 |
430713 | product-430713 | 266/1936/2601 |
430714 | product-430714 | 266/1936/2601 |
430738 | product-430738 | 266/1936/2601 |
430749 | product-430749 | 266/1936/2601 |
430753 | product-430753 | 266/1936/2601 |
430756 | product-430756 | 266/1936/2601 |
430782 | product-430782 | 266/1936/2601 |
430788 | product-430788 | 266/1936/2601 |
430794 | product-430794 | 266/1936/2601 |
430800 | product-430800 | 266/1936/2601 |
430801 | product-430801 | 266/1936/2601 |
430809 | product-430809 | 266/1936/2601 |
430810 | product-430810 | 266/1936/2601 |
430811 | product-430811 | 266/1936/2601 |
430827 | product-430827 | 266/1936/2601 |
430836 | product-430836 | 266/1936/2601 |
430845 | product-430845 | 266/1936/2601 |
430851 | product-430851 | 266/1936/2601 |
430852 | product-430852 | 266/1936/2601 |
430853 | product-430853 | 266/1936/2601 |
430855 | product-430855 | 266/1936/2601 |
430861 | product-430861 | 266/1936/2601 |
430862 | product-430862 | 266/1936/2601 |
430865 | product-430865 | 266/1936/2601 |
430866 | product-430866 | 266/1936/2601 |
430870 | product-430870 | 266/1936/2601 |
430874 | product-430874 | 266/1936/2601 |
430885 | product-430885 | 266/1936/2601 |
430887 | product-430887 | 266/1936/2601 |
430888 | product-430888 | 266/1936/2601 |
430895 | product-430895 | 266/1936/2601 |
430904 | product-430904 | 266/1936/2601 |
430905 | product-430905 | 266/1936/2601 |
430910 | product-430910 | 266/1936/2601 |
430923 | product-430923 | 266/1936/2601 |
430927 | product-430927 | 266/1936/2601 |
430932 | product-430932 | 266/1936/2601 |
430936 | product-430936 | 266/1936/2601 |
430937 | product-430937 | 266/1936/2601 |
430939 | product-430939 | 266/1936/2601 |
430947 | product-430947 | 266/1936/2601 |
430976 | product-430976 | 266/1936/2601 |
430992 | product-430992 | 266/1936/2601 |
430999 | product-430999 | 266/1936/2601 |
431003 | product-431003 | 266/1936/2601 |
431011 | product-431011 | 266/1936/2601 |
431024 | product-431024 | 266/1936/2601 |
431028 | product-431028 | 266/1936/2601 |
431029 | product-431029 | 266/1936/2601 |
431039 | product-431039 | 266/1936/2601 |
431042 | product-431042 | 266/1936/2601 |
431046 | product-431046 | 266/1936/2601 |
431052 | product-431052 | 266/1936/2601 |
431054 | product-431054 | 266/1936/2601 |
431061 | product-431061 | 266/1936/2601 |
431062 | product-431062 | 266/1936/2601 |
431072 | product-431072 | 266/1936/2601 |
431077 | product-431077 | 266/1936/2601 |
431091 | product-431091 | 266/1936/2601 |
431098 | product-431098 | 266/1936/2601 |
431112 | product-431112 | 266/1936/2601 |
431129 | product-431129 | 266/1936/2601 |
431171 | product-431171 | 266/1936/2601 |
431192 | product-431192 | 266/1936/2601 |
431193 | product-431193 | 266/1936/2601 |
431200 | product-431200 | 266/1936/2601 |
431205 | product-431205 | 266/1936/2601 |
431238 | product-431238 | 266/1936/2601 |
431242 | product-431242 | 266/1936/2601 |
431245 | product-431245 | 266/1936/2601 |
431251 | product-431251 | 266/1936/2601 |
431308 | product-431308 | 266/1936/2601 |
431314 | product-431314 | 266/1936/2601 |
431315 | product-431315 | 266/1936/2601 |
431316 | product-431316 | 266/1936/2601 |
431325 | product-431325 | 266/1936/2601 |
431326 | product-431326 | 266/1936/2601 |
431327 | product-431327 | 266/1936/2601 |
431333 | product-431333 | 266/1936/2601 |
431339 | product-431339 | 266/1936/2601 |
431365 | product-431365 | 266/1936/2601 |
431393 | product-431393 | 266/1936/2601 |
431463 | product-431463 | 266/1936/2601 |