{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "42.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": 19,
"rows_produced_per_join": 19,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (29746,29747,29748,29749,29750,29751,29752,29753,29754,29755,29756,29757,29758,29759,29760,29761)) 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": "38.81",
"eval_cost": "3.80",
"prefix_cost": "42.61",
"data_read_per_join": "32K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
29746 | bracelet-flask-bangle-flask-creative-stainless-304-steeland-hip-flask-funnel-set-for-women-3.5-oz-rose-red-with-rhinestones-lid-en | 12/13/44/46/297 |
29747 | smart-case-cover-by-ineix-for-apple-ipad-pro-10.5-inch-black | 190/191/419 |
29748 | 2018-2017-apple-ipad-9.7-inch-leather-case-flip-smart-auto-sleep-wake-cover-tri-adjust-stand-anti-fall-shell-with-pen-slot-en | 190/191/419 |
29749 | logitech-wireless-combo-mk270-with-keyboard-and-mouse | 299/383/560 |
29750 | wireless-keyboard-and-mouse-combo-set-2.4g-wireless-keyboard-moues-combo-for-apple-mac-windows-xp-7-10-ios-white | 299/383/560 |
29751 | dog-clicker-cat-training-trainer-with-key-ring-and-wrist-strap-blue | 6/367 |
29752 | coolcold-notebook-pc-cooler-laptop-cooling-pad-air-cooled-5-led-fans-2-usb-ports-adjustable-holder-for-12-17-inch-laptop | 299/383 |
29753 | funny-corrugated-paper-pet-cat-scratch-board-toy-kitten-claw-scratching-pad-mat-scratcher-cats-training-tools-with-two-bells | 6/367 |
29754 | the-tower-pu-leather-case-cover-10.1-inch-slim-print-smart-tablet-pc-funda-for-huawei-mediapad-m5-lite-10-shockproof-skin | 190/191/419 |
29755 | telesin-3-way-3-port-battery-charger-for-gopro-hero-5-6-accessories-storage-box-case-charger | 190/193 |
29756 | 2-set-dji-osmo-pocket-tempered-glass-screen-protector-filmtpu-lens-film-for-osmo-pocket-handheld-gimbal-accessories | 299/412/413 |
29757 | coolcold-ice-magic-3-mini-laptop-cooling-fan-usb-plug-exhaust-fan-speed-adjustable-notebook-cooler-lighted | 299/383 |
29758 | 9h-full-cover-tempered-glass-film-for-apple-ipad-pro-11-inch-2018-screen-protector-protective-glass-for-ipad-pro-11-safety-guard | 190/192 |
29759 | usb-keyboard-for-pc-and-laptop-g21 | 299/383/560 |
29760 | dog-beds-mats-pet-products-warm-soft-dog-house-pet-sleeping-bag-shark-dog-kennel-cat-bed-cat-house-cama-perro-kennels-pens | 6/367 |
29761 | telesin-3-way-battery-charger-charging-dock-storage-case-charging-box-2-in-1-for-gopro-hero-5-hero-6-accessories | 190/193 |