{
"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 (430995,431087,431290,431381,431004,431231,431405,430983,431071,431497,430762,431274,431411,431495,431017,431175,431182,431434,431465,430686,430974,431045,431403,430755,430765,430785,431001,431494,430965,431025,431457,381710,430963,430966,431002,431240,431329,431343,381707,430630,430964,431243,431304,431425,430752,430773,431284,431394,430711,430961,431328,431505,431235,431362,431408,431422,431498,430971,431079,431355,431383,431015,431152,431260,431283,431407,430669,430700,430705,430759,431105,431488,430943,430978,431018,431057,431069,431340,431352,431409,430944,431217,431337,431419,435510,430929,431030,431311,430717,430781,430938,430973,431346,431427,387046,430956,431302,431415,431482,431500)) 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 |
---|---|---|
381707 | dhome-teke-en | 266/2577/2578 |
381710 | dhome-dopio-en | 266/2577/2578 |
387046 | dhome-standarte-dyshe-x-m2 | 266/2577/2578 |
430630 | product-430630 | 266/1936/2601 |
430669 | product-430669 | 266/1936/2601 |
430686 | product-430686 | 266/1936/2601 |
430700 | product-430700 | 266/1936/2601 |
430705 | product-430705 | 266/1936/2601 |
430711 | product-430711 | 266/1936/2601 |
430717 | product-430717 | 266/1936/2601 |
430752 | product-430752 | 266/1936/2601 |
430755 | product-430755 | 266/1936/2601 |
430759 | product-430759 | 266/1936/2601 |
430762 | product-430762 | 266/1936/2601 |
430765 | product-430765 | 266/1936/2601 |
430773 | product-430773 | 266/1936/2601 |
430781 | product-430781 | 266/1936/2601 |
430785 | product-430785 | 266/1936/2601 |
430929 | product-430929 | 266/1936/2601 |
430938 | product-430938 | 266/1936/2601 |
430943 | product-430943 | 266/1936/2601 |
430944 | product-430944 | 266/1936/2601 |
430956 | product-430956 | 266/1936/2601 |
430961 | product-430961 | 266/1936/2601 |
430963 | product-430963 | 266/1936/2601 |
430964 | product-430964 | 266/1936/2601 |
430965 | product-430965 | 266/1936/2601 |
430966 | product-430966 | 266/1936/2601 |
430971 | product-430971 | 266/1936/2601 |
430973 | product-430973 | 266/1936/2601 |
430974 | product-430974 | 266/1936/2601 |
430978 | product-430978 | 266/1936/2601 |
430983 | product-430983 | 266/1936/2601 |
430995 | product-430995 | 266/1936/2601 |
431001 | product-431001 | 266/1936/2601 |
431002 | product-431002 | 266/1936/2601 |
431004 | product-431004 | 266/1936/2601 |
431015 | product-431015 | 266/1936/2601 |
431017 | product-431017 | 266/1936/2601 |
431018 | product-431018 | 266/1936/2601 |
431025 | product-431025 | 266/1936/2601 |
431030 | product-431030 | 266/1936/2601 |
431045 | product-431045 | 266/1936/2601 |
431057 | product-431057 | 266/1936/2601 |
431069 | product-431069 | 266/1936/2601 |
431071 | product-431071 | 266/1936/2601 |
431079 | product-431079 | 266/1936/2601 |
431087 | product-431087 | 266/1936/2601 |
431105 | product-431105 | 266/1936/2601 |
431152 | product-431152 | 266/1936/2601 |
431175 | product-431175 | 266/1936/2601 |
431182 | product-431182 | 266/1936/2601 |
431217 | product-431217 | 266/1936/2601 |
431231 | product-431231 | 266/1936/2601 |
431235 | product-431235 | 266/1936/2601 |
431240 | product-431240 | 266/1936/2601 |
431243 | product-431243 | 266/1936/2601 |
431260 | product-431260 | 266/1936/2601 |
431274 | product-431274 | 266/1936/2601 |
431283 | product-431283 | 266/1936/2601 |
431284 | product-431284 | 266/1936/2601 |
431290 | product-431290 | 266/1936/2601 |
431302 | product-431302 | 266/1936/2601 |
431304 | product-431304 | 266/1936/2601 |
431311 | product-431311 | 266/1936/2601 |
431328 | product-431328 | 266/1936/2601 |
431329 | product-431329 | 266/1936/2601 |
431337 | product-431337 | 266/1936/2601 |
431340 | product-431340 | 266/1936/2601 |
431343 | product-431343 | 266/1936/2601 |
431346 | product-431346 | 266/1936/2601 |
431352 | product-431352 | 266/1936/2601 |
431355 | product-431355 | 266/1936/2601 |
431362 | product-431362 | 266/1936/2601 |
431381 | product-431381 | 266/1936/2601 |
431383 | product-431383 | 266/1936/2601 |
431394 | product-431394 | 266/1936/2601 |
431403 | product-431403 | 266/1936/2601 |
431405 | product-431405 | 266/1936/2601 |
431407 | product-431407 | 266/1936/2601 |
431408 | product-431408 | 266/1936/2601 |
431409 | product-431409 | 266/1936/2601 |
431411 | product-431411 | 266/1936/2601 |
431415 | product-431415 | 266/1936/2601 |
431419 | product-431419 | 266/1936/2601 |
431422 | product-431422 | 266/1936/2601 |
431425 | product-431425 | 266/1936/2601 |
431427 | product-431427 | 266/1936/2601 |
431434 | product-431434 | 266/1936/2601 |
431457 | product-431457 | 266/1936/2601 |
431465 | product-431465 | 266/1936/2601 |
431482 | product-431482 | 266/1936/2601 |
431488 | product-431488 | 266/1936/2601 |
431494 | product-431494 | 266/1936/2601 |
431495 | product-431495 | 266/1936/2601 |
431497 | product-431497 | 266/1936/2601 |
431498 | product-431498 | 266/1936/2601 |
431500 | product-431500 | 266/1936/2601 |
431505 | product-431505 | 266/1936/2601 |
435510 | product-435510 | 266/10667 |