{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "41.21"
},
"table": {
"table_name": "q_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": 18,
"rows_produced_per_join": 18,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (9709,9710,9711,9712,9713,9714,9715,9716,9717,9718,9719,9720,9721,9722,9723,9724)) and (`portal`.`q_seo_names`.`type` = 'p') and (`portal`.`q_seo_names`.`dispatch` = '') and (`portal`.`q_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "37.61",
"eval_cost": "3.60",
"prefix_cost": "41.21",
"data_read_per_join": "30K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
9709 | moshi-iphone-xs-max-stealthcover-champagne-pink | 190/191/418 |
9710 | moshi-vitros-gunmetal-gray-for-iphone-8-7-6s-6-plus | 190/191/418 |
9711 | moshi-vitros-golden-rose-for-iphone-xs-x | 190/191/418 |
9712 | moshi-vitros-golden-rose-for-iphone-8-7-6s-6-plus | 190/191/418 |
9713 | moshi-vitros-crimson-red-for-iphone-xs-x | 190/191/418 |
9714 | moshi-iphone-xs-x-vitros-clear | 190/191/418 |
9715 | moshi-iphone-8-7-6s-6-vitros-clear | 190/191/418 |
9716 | moshi-iphone-xs-max-vitros-crystal-clear | 190/191/418 |
9717 | moshi-macbook-pro-13-pluma-sleeve-herringbone-gray | 299/383/512 |
9718 | moshi-superskin-stealth-black-for-iphone-8-7-6s-6 | 190/191/418 |
9719 | moshi-superskin-stealth-black-for-iphone-8-7-6s-6-plus | 190/191/418 |
9720 | moshi-superskin-stealth-black-for-iphone-xs-x | 190/191/418 |
9721 | moshi-superskin-crystal-clear-for-iphone-8-7-6s-6 | 190/191/418 |
9722 | moshi-superskin-crystal-clear-for-iphone-8-7-6s-6-plus | 190/191/418 |
9723 | moshi-superskin-crystal-clear-for-iphone-xs-x | 190/191/418 |
9724 | moshi-iphone-xs-max-iglaze-emerald-green | 190/191 |