{
"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 (430644,430664,430988,431073,430730,431043,431083,431135,430628,431089,431167,431459,339831,430829,430842,431063,431183,430662,430844,431066,431313,430651,430869,430928,339762,430769,430880,430898,430899,430884,431035,339781,430653,430684,430712,430847,431140,431142,430631,430891,430962,430626,431185,381713,430893,431093,430881,430909,431031,339733,339691,431123,430797,430896,430900,430980,431197,431250,430633,430806,430873,430883,431226,339600,430837,431088,430645,430685,430787,430876,430930,431023,431064,430913,339488,430768,430841,431008,431078,431131,339804,339594,430676,430772,430802,430981,431119,430758,431032,431121,430760,430796,430846,431113,431159,430698,431198,431356,381712,431178)) 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 |
---|---|---|
339488 | mannol-ts-2-shpd-20w-50-20l-en | 266/394/9940 |
339594 | filtron-filtro-aera-ap-139-2-c-35154 | 266/394/395 |
339600 | filtro-ladioy-filtron-om-513-1-2x-hu-947-1z-2 | 266/394/395 |
339691 | bosch-0986452028-filtro-ladioy-toyota-en | 266/394/395 |
339733 | filtro-kampinas-fi.ba-cf157c-en | 266/394/395 |
339762 | amortiser-excel-g-kyb-332504-daewoo-chevrolet-en | 266/394/395 |
339781 | filtro-ydraylikoy-donaldson-p551324-en | 266/394/395 |
339804 | antiolisthitiko-pani-khionioy-aro-70-x-large-aro-2-tem.-en | 266/394/9943 |
339831 | filtro-aeros-purro-ha0108-c26024kit-en | 266/394/395 |
381712 | double-room-en | 266/2577/2578 |
381713 | dhome-familjare | 266/2577/2578 |
430626 | product-430626 | 266/1936/2601 |
430628 | product-430628 | 266/1936/2601 |
430631 | product-430631 | 266/1936/2601 |
430633 | product-430633 | 266/1936/2601 |
430644 | product-430644 | 266/1936/2601 |
430645 | product-430645 | 266/1936/2601 |
430651 | product-430651 | 266/1936/2601 |
430653 | product-430653 | 266/1936/2601 |
430662 | product-430662 | 266/1936/2601 |
430664 | product-430664 | 266/1936/2601 |
430676 | product-430676 | 266/1936/2601 |
430684 | product-430684 | 266/1936/2601 |
430685 | product-430685 | 266/1936/2601 |
430698 | product-430698 | 266/1936/2601 |
430712 | product-430712 | 266/1936/2601 |
430730 | product-430730 | 266/1936/2601 |
430758 | product-430758 | 266/1936/2601 |
430760 | product-430760 | 266/1936/2601 |
430768 | product-430768 | 266/1936/2601 |
430769 | product-430769 | 266/1936/2601 |
430772 | product-430772 | 266/1936/2601 |
430787 | product-430787 | 266/1936/2601 |
430796 | product-430796 | 266/1936/2601 |
430797 | product-430797 | 266/1936/2601 |
430802 | product-430802 | 266/1936/2601 |
430806 | product-430806 | 266/1936/2601 |
430829 | product-430829 | 266/1936/2601 |
430837 | product-430837 | 266/1936/2601 |
430841 | product-430841 | 266/1936/2601 |
430842 | product-430842 | 266/1936/2601 |
430844 | product-430844 | 266/1936/2601 |
430846 | product-430846 | 266/1936/2601 |
430847 | product-430847 | 266/1936/2601 |
430869 | product-430869 | 266/1936/2601 |
430873 | product-430873 | 266/1936/2601 |
430876 | product-430876 | 266/1936/2601 |
430880 | product-430880 | 266/1936/2601 |
430881 | product-430881 | 266/1936/2601 |
430883 | product-430883 | 266/1936/2601 |
430884 | product-430884 | 266/1936/2601 |
430891 | product-430891 | 266/1936/2601 |
430893 | product-430893 | 266/1936/2601 |
430896 | product-430896 | 266/1936/2601 |
430898 | product-430898 | 266/1936/2601 |
430899 | product-430899 | 266/1936/2601 |
430900 | product-430900 | 266/1936/2601 |
430909 | product-430909 | 266/1936/2601 |
430913 | product-430913 | 266/1936/2601 |
430928 | product-430928 | 266/1936/2601 |
430930 | product-430930 | 266/1936/2601 |
430962 | product-430962 | 266/1936/2601 |
430980 | product-430980 | 266/1936/2601 |
430981 | product-430981 | 266/1936/2601 |
430988 | product-430988 | 266/1936/2601 |
431008 | product-431008 | 266/1936/2601 |
431023 | product-431023 | 266/1936/2601 |
431031 | product-431031 | 266/1936/2601 |
431032 | product-431032 | 266/1936/2601 |
431035 | product-431035 | 266/1936/2601 |
431043 | product-431043 | 266/1936/2601 |
431063 | product-431063 | 266/1936/2601 |
431064 | product-431064 | 266/1936/2601 |
431066 | product-431066 | 266/1936/2601 |
431073 | product-431073 | 266/1936/2601 |
431078 | product-431078 | 266/1936/2601 |
431083 | product-431083 | 266/1936/2601 |
431088 | product-431088 | 266/1936/2601 |
431089 | product-431089 | 266/1936/2601 |
431093 | product-431093 | 266/1936/2601 |
431113 | product-431113 | 266/1936/2601 |
431119 | product-431119 | 266/1936/2601 |
431121 | product-431121 | 266/1936/2601 |
431123 | product-431123 | 266/1936/2601 |
431131 | product-431131 | 266/1936/2601 |
431135 | product-431135 | 266/1936/2601 |
431140 | product-431140 | 266/1936/2601 |
431142 | product-431142 | 266/1936/2601 |
431159 | product-431159 | 266/1936/2601 |
431167 | product-431167 | 266/1936/2601 |
431178 | product-431178 | 266/1936/2601 |
431183 | product-431183 | 266/1936/2601 |
431185 | product-431185 | 266/1936/2601 |
431197 | product-431197 | 266/1936/2601 |
431198 | product-431198 | 266/1936/2601 |
431226 | product-431226 | 266/1936/2601 |
431250 | product-431250 | 266/1936/2601 |
431313 | product-431313 | 266/1936/2601 |
431356 | product-431356 | 266/1936/2601 |
431459 | product-431459 | 266/1936/2601 |