{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "14.70"
},
"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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"index_condition": "((`s2cart`.`cscart_seo_names`.`object_id` in (276459,276460,276461,276462,276463,276464,276465,276466,276467,276468,276469,276470,276471,276472,276473,276474,276475,276476,276477,276478)) and (`s2cart`.`cscart_seo_names`.`type` = 'p') and (`s2cart`.`cscart_seo_names`.`dispatch` = '') and (`s2cart`.`cscart_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "12.70",
"eval_cost": "2.00",
"prefix_cost": "14.70",
"data_read_per_join": "33K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
276459 | abb-miniature-circuit-breaker-276460 | 5188/4936 |
276460 | abb-miniature-circuit-breaker-276461 | 5188/4936 |
276461 | abb-miniature-circuit-breaker-276462 | 5188/4936 |
276462 | abb-miniature-circuit-breaker-276463 | 5188/4936 |
276463 | abb-miniature-circuit-breaker-276464 | 5188/4936 |
276464 | abb-miniature-circuit-breaker-276465 | 5188/4936 |
276465 | abb-miniature-circuit-breaker-276466 | 5188/4936 |
276466 | abb-miniature-circuit-breaker-276467 | 5188/4936 |
276467 | abb-miniature-circuit-breaker-276468 | 5188/4936 |
276468 | abb-miniature-circuit-breaker-276469 | 5188/4936 |
276469 | abb-miniature-circuit-breaker-276470 | 5188/4936 |
276470 | abb-miniature-circuit-breaker-276471 | 5188/4936 |
276471 | abb-miniature-circuit-breaker-276472 | 5188/4936 |
276472 | abb-miniature-circuit-breaker-276473 | 5188/4936 |
276473 | abb-miniature-circuit-breaker-276474 | 5188/4936 |
276474 | abb-miniature-circuit-breaker-276475 | 5188/4936 |
276475 | abb-miniature-circuit-breaker-276476 | 5188/4936 |
276476 | abb-miniature-circuit-breaker-276477 | 5188/4936 |
276477 | abb-miniature-circuit-breaker-276478 | 5188/4936 |
276478 | abb-miniature-circuit-breaker-276479 | 5188/4936 |