{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "13.21"
},
"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": 21,
"rows_produced_per_join": 21,
"filtered": "100.00",
"index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (6208,6209,6210,6214,6216,6217,6205,6527,6528,6529,6530,6242,6540,6541,6542)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`type` = 'p') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`dispatch` = '') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`lang_code` = 'ar'))",
"cost_info": {
"read_cost": "11.11",
"eval_cost": "2.10",
"prefix_cost": "13.21",
"data_read_per_join": "35K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 6205 | smeg-white-toaster-2-slice-ar | 372/466/573 |
| 6208 | smeg-kettle-ar | 372/466/575 |
| 6209 | غلاية-كهربائية-من-smeg | 372/466/575 |
| 6210 | غلاية-كهربائية-من-smeg-ar | 372/466/575 |
| 6214 | smeg-50s-style-retro-kbsf02-7-piece-knife-block-set-ar | 372/466 |
| 6216 | طقم-سكاكين-مطبخ-smeg-kbsf02-على-الطراز-الرجعي-لخمسينيات-القرن-الماضي-مكون-من-7-قطع-ar | 372/466 |
| 6217 | طقم-سكاكين-مطبخ-smeg-kbsf02-على-الطراز-الرجعي-لخمسينيات-القرن-الماضي-مكون-من-7-قطع | 372/466 |
| 6242 | smeg-cream-electric-kettle-ar | 372/466/575 |
| 6527 | محمصة-خبز-بيضاء-من-smeg-لشريحتين-ar-2 | 372/466/573 |
| 6528 | محمصة-خبز-بيضاء-من-smeg-لشريحتين-ar | 372/466/573 |
| 6529 | محمصة-خبز-بيضاء-من-smeg-لشريحتين | 372/466/573 |
| 6530 | محمصة-خبز-بيضاء-من-smeg-لشريحتين-ar-3 | 372/466/573 |
| 6540 | غلاية-كهربائية-باللون-الكريمي-من-سميج | 372/466/575 |
| 6541 | غلاية-كهربائية-باللون-الكريمي-من-سميج-ar-2 | 372/466/575 |
| 6542 | غلاية-كهربائية-باللون-الكريمي-من-سميج-ar | 372/466/575 |