{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "77.61"
},
"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": 34,
"rows_produced_per_join": 34,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (34264,34265,34266,34267,34268,34269,34271,34272,34273,34274,34275,34276,34277,34278,34279,34280,34281,34282,34283,34284,34285,34286,34287,34288,34289,34290,34291,34293,34294,34295)) 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": "70.81",
"eval_cost": "6.80",
"prefix_cost": "77.61",
"data_read_per_join": "57K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
34264 | loreal-paris-white-perfect-day-cream-whitening-and-even-tone-spf17-pa-50ml-en | 2/10/134 |
34265 | ponds-clear-solutions-facial-scrub-anti-bacterial-plusclarity-with-herbal-clay-100-g | 2/144/100/117 |
34266 | sensodyne-original-red-toothpaste-100ml | 2/138/140 |
34267 | schick-quattro-razor-extra-control-grip | 2/144/145 |
34268 | qv-repair-dry-skin-cream-100-gm | 2/10 |
34269 | active-power-toilet-cleaning-blocks-4-pack | 6/7/147/154 |
34271 | dr-mist-hygiene-deodorant-spray | 2/144/400 |
34272 | dove-soft-feel-48h-antiperspirant-stick-40ml-en | 2/144/400 |
34273 | dove-stick-deodorant-for-women-40-ml | 2/144/400 |
34274 | 1m-flat-wide-knit-fabric-braided-data-charger-charging-cable | 190/202 |
34275 | 4gb-usb-rechargeable-digital-voice-recorder-dictaphone-with-usb-flash-drive | 299/383/384 |
34276 | 8gb-usb-rechargeable-digital-voice-recorder-dictaphone-with-usb-flash-drive | 299/401 |
34277 | bt-007-portable-bluetooth-speaker | 190/424 |
34278 | air-purifier-with-negative-ion-generator | 6/184/378 |
34279 | room-ionizer-uv-humidifier-air-purification-portable-home-hepa-filter-air-purifier | 6/184/378 |
34280 | all-in-one-air-purifier-humidifier-uv-sterilizer-ion-generator-air-quality | 6/184/378 |
34281 | k01b-silent-negative-ion-portable-air-purifier | 6/184/378 |
34282 | leather-fast-wireless-charger-2-coils-qi-wireless-charging-stand | 190/193 |
34283 | universal-2-coils-quick-fast-charging-for-iphone-x-8-8-plus-and-for-samsung-galaxy-note8-s8-qi-wireless-charger-en-2 | 190/193 |
34284 | txd-g1-rc-wi-fi-360-foldable-high-speed-drone | 299/412/565 |
34285 | 3-in-1-usb-sync-and-charging-nylon-braided-data-cable-with-8-pin-lightning-micro-usb-and-type-c-connectors-1-meter | 190/202 |
34286 | anti-snoring-solution-air-purifier-filter-snore-stopper-device-chin-strap-nose-vent-solution-for-comfortable-sleep-en-2 | 2/405 |
34287 | snore-reduction-stopper-vents-maximize-airflow-for-sleep-breath-aid | 2/405 |
34288 | 4-sizes-relieve-anti-snoring-stopper-guard-easy-sleeping-nose-vents | 2/405 |
34289 | 2-in-1-steam-brush-steam-iron-dry-and-spread-steam-and-hang-en | 6/168/181 |
34290 | extendable-selfie-stick-with-bluetooth-remote | 190/196 |
34291 | magnetic-auto-360-degrees-car-mount-phone-holder | 190/199 |
34293 | dalesh-3in1-hi-speed-cable-ios-android-and-type-c-1250mm | 190/202 |
34294 | multi-connector-120cm-high-speed-3in1-data-cable-type-c-ios-android-en | 190/202 |
34295 | hdmi-female-to-female-coupler-extender-adapter-connector-f-f-for-hdtv-hdcp-1080p | 299/383/402 |