{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "22.05"
},
"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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"index_condition": "((`s2cart`.`cscart_seo_names`.`object_id` in (276633,276634,276635,276636,276637,276638,276639,276640,276641,276642,276643,276644,276645,276646,276647,276648,276649,276650,276651,276652,276653,276654,276655,276656,276657,276658,276659,276660,276661,276662)) 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": "19.05",
"eval_cost": "3.00",
"prefix_cost": "22.05",
"data_read_per_join": "50K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
276633 | abb-miniature-circuit-breaker-sh203m-3p-c | 5188/4936 |
276634 | abb-miniature-circuit-breaker-sh203m-3p-c-276635 | 5188/4936 |
276635 | abb-miniature-circuit-breaker-sh203m-3p-c-276636 | 5188/4936 |
276636 | abb-miniature-circuit-breaker-sh203m-3p-c-276637 | 5188/4936 |
276637 | abb-miniature-circuit-breaker-sh203m-3p-c-276638 | 5188/4936 |
276638 | abb-miniature-circuit-breaker-sh203m-3p-c-276639 | 5188/4936 |
276639 | abb-miniature-circuit-breaker-sh203m-3p-c-276640 | 5188/4936 |
276640 | abb-miniature-circuit-breaker-sh203m-3p-c-276641 | 5188/4936 |
276641 | abb-miniature-circuit-breaker-sh203m-3p-c-276642 | 5188/4936 |
276642 | abb-miniature-circuit-breaker-sh203m-3p-c-276643 | 5188/4936 |
276643 | abb-miniature-circuit-breaker-sh203m-3p-c-276644 | 5188/4936 |
276644 | abb-miniature-circuit-breaker-sh203m-3p-c-276645 | 5188/4936 |
276645 | abb-miniature-circuit-breaker-sh203m-3p-c-276646 | 5188/4936 |
276646 | abb-miniature-circuit-breaker-sh203m-3p-c-276647 | 5188/4936 |
276647 | abb-miniature-circuit-breaker-sh203m-3p-c-276648 | 5188/4936 |
276648 | abb-miniature-circuit-breaker-sh203m-3p-c-276649 | 5188/4936 |
276649 | abb-miniature-circuit-breaker-sh203m-3p-c-276650 | 5188/4936 |
276650 | abb-miniature-circuit-breaker-sh203m-3p-c-276651 | 5188/4936 |
276651 | abb-miniature-circuit-breaker-sh203m-3p-c-276652 | 5188/4936 |
276652 | abb-miniature-circuit-breaker-sh203m-3p-c-276653 | 5188/4936 |
276653 | abb-miniature-circuit-breaker-sh203m-3p-c-276654 | 5188/4936 |
276654 | abb-miniature-circuit-breaker-sh203m-3p-c-276655 | 5188/4936 |
276655 | abb-miniature-circuit-breaker-sh203m-3p-c-276656 | 5188/4936 |
276656 | abb-miniature-circuit-breaker-sh203m-3p-c-276657 | 5188/4936 |
276657 | abb-miniature-circuit-breaker-sh203m-3p-c-276658 | 5188/4936 |
276658 | abb-miniature-circuit-breaker-sh203m-3p-c-276659 | 5188/4936 |
276659 | abb-miniature-circuit-breaker-sh203m-3p-c-276660 | 5188/4936 |
276660 | abb-miniature-circuit-breaker-sh203m-3p-c-276661 | 5188/4936 |
276661 | abb-miniature-circuit-breaker-sh203m-3p-c-276662 | 5188/4936 |
276662 | abb-miniature-circuit-breaker-sh203m-3p-c-276663 | 5188/4936 |