{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.41"
},
"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": 21,
"rows_produced_per_join": 21,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (50214,45834,45835,45836,45837,45838,45839,45840,45844,45845,45846,45847,45849,45850,45851,45852)) 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": "41.21",
"eval_cost": "4.20",
"prefix_cost": "45.41",
"data_read_per_join": "35K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
45834 | zoook-bluetooth-headphone-with-aux-fm-tf-aux-mic-green | 190/200 |
45835 | zoook-wireless-bluetooth-speaker-headphone-2-in-1-supports-tf-fm-radio-aux-music-sharing-hands-free-calls-black | 190/200 |
45836 | zoook-soul-premium-bluetooth-headphone-with-tf-fm-radio-aux-in-and-microphone-black | 190/200 |
45837 | zoook-aura-premium-bluetooth-headphone-with-tf-fm-aux-in-and-microphone-black | 190/200 |
45838 | zoook-wireless-bluetooth-neckband-style-earphones-with-20-hour-playing-time-and-magnetic-latch-design-black | 190/201 |
45839 | zoook-premium-bluetooth-headphone-with-tf-aux-in-and-microphone-black | 190/200 |
45840 | zoook-x1000-wired-wireless-headphones-supporting-bluetooth-play-fm-radio-aux-input-micro-sd-card-handsfree-calls-black | 190/200 |
45844 | zoook-halo-bluetooth-headset-with-charging-dock-black | 190/201 |
45845 | zoook-in-style-ultra-slim-bluetooth-headset-black | 190/201 |
45846 | zoook-true-wireless-stereo-earbuds-with-long-playing-time-in-anodized-aluminimum-body-black | 190/201 |
45847 | zoook-bluetooth-metal-earphones-with-mic-zb-be1-silver-black | 190/201 |
45849 | zoook-stereo-bluetooth-headset-black | 190/201 |
45850 | zoook-blue-bluetooth-mono-headset-500mah-90db-bluetooth-white-zb-btx5 | 190/201 |
45851 | zoook-blue-bluetooth-mono-headset-500mah-90db-bluetooth-black-zb-btx5 | 190/201 |
45852 | zoook-zb-btx6-bluetooth-mono-headset-black | 190/201 |
50214 | vodome-bumper-for-iphone-5c-blue | 190/191/418 |