{
"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 (29811,29812,29813,29814,29815,29816,29817,29818,29819,29820,29821,29822,29823,29824,29825,29826)) 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 |
---|---|---|
29811 | bluetooth-3.0-wireless-2.4ghz-keyboard-for-apple-ipad-1-1-2-3-4-mac-computer-pc-mac-tablets-laptops | 299/383/560 |
29812 | winter-essential-cat-dog-stuffed-square-bed-pet-cushion-size-l | 6/367 |
29813 | case-with-pencil-holder-for-samsung-galaxy-tab-s4-2018-10.5-t830-sm-t835-10.5-inch-tablet-stand-smart-cover-auto-sleep-wake | 190/191/419 |
29814 | orico-usb-3.0-to-sata-dual-bay-hard-drive-docking-station-for-2.5-3.5-inch-hdd-ssd | 299/383 |
29815 | gub-g-85-adjustable-universal-bike-phone-stand-for-3.5-6.2inch-smartphone-aluminum-bicycle-handlebar-holder-mount-bracket | 300/572 |
29816 | 2.4ghz-wireless-vertical-grip-ergonomic-optical-mouse-with-6-buttons | 299/383/560 |
29817 | usb-56k-external-dial-up-fax-data-modem-v.90-v.92-win7-32-64-bit-xp | 299/383 |
29818 | delux-t9-47-key-professional-one-single-hand-usb-wired-esport-gaming-keyboard | 190/420 |
29819 | kids-snorkel-diving-mask-set-children-size-swimming-training-full-face-mask-scuba-diving-equipment | 248/257/264/266 |
29820 | 6pcs-train-toy-set-children-educational-toys-railway-track-train-gift-for-kids | 248/249 |
29821 | black-7500lm-led-bike-lights-head-lamp-with-battery-charger-bicycle-accessories | 300/572 |
29822 | house-pet-dog-warm-soft-sleeping-bag-bed-shark-dog-kennel-cat-bed-cave-cushion-pillow-cute-nest-mat-pet-accessories | 6/367 |
29823 | 60-colors-touch-five-pens-and-markers-art-sketch-twin-marker-pens-broad-fine-point-interior-sketch-dedicated-white | 248/544/545 |
29824 | 6-pack-ems-unisex-en | 207/513 |
29825 | case-for-ipad-pro-11-2018-pu-leather-transparent-pc-back-slim-light-weight-trifold-smart-cover-case-2018 | 190/191/419 |
29826 | swimming-pool-float-hammock-inflatable-swimming-pools-lounger-blue | 207/217 |