{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.46"
},
"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": 11,
"rows_produced_per_join": 11,
"filtered": "100.00",
"index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (8597,8280,8443,8596,8405,8584,8588,8437,8515,8542)) 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` = 'en'))",
"cost_info": {
"read_cost": "6.36",
"eval_cost": "1.10",
"prefix_cost": "7.46",
"data_read_per_join": "18K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 8280 | hama-119454-premium-screen-protection-glass-for-apple-ipad-pro-12-9-inch-clear | 166/423/448 |
| 8405 | hama-222788-extreme-pro-iphone-16-plus-transparent | 166/423/448 |
| 8437 | hama-216306-premium-screen-protection-glass-for-apple-ipad-air-10-9-2020-2022 | 166/423/448 |
| 8443 | hama-210925-premium-screen-protector-for-ipad-air-13-2024 | 166/423/448 |
| 8515 | hama-premium-display-protection-glass-for-apple-ipad-pro-13-2024-210931 | 166/423/448 |
| 8542 | hama-222785-extreme-protect-mobile-phone-protection-glass-for-apple-iphone-16-with-mounting-tool | 166/423/448 |
| 8584 | hama-210928-premium-display-protection-glass-for-apple-ipad-air-11-2024 | 166/423/448 |
| 8588 | hama-222786-extreme-protect-screen-glass-for-apple-iphone-16-pro-d3o-licensed | 166/423/448 |
| 8596 | hama-213005-premium-crystal-glass-screen-protector-for-apple-iphone-13-mini | 166/423/448 |
| 8597 | hama-213014-privacy-screen-protector-glass-for-apple-iphone-13-mini-pack-of-1 | 166/423/448 |