{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "66.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": 36,
"rows_produced_per_join": 36,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684)) 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": "59.21",
"eval_cost": "7.20",
"prefix_cost": "66.41",
"data_read_per_join": "61K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30669 | pineapple-tumbler-moscow-mule-mugs-500ml-beer-copper-mug-stainless-steel-cup-cocktail-cup-wine-glass-drinking-bar-tool | 6/438/439/442 |
30670 | 6l-mini-12v-car-refrigerator-heat-fridge-warming-and-cooling-vehicle-refrigerator-cooler-warmer-truck-car | 300/375 |
30671 | i10-tws-in-ear-air-pod-for-iphone-and-samsung-mobiles-bluetooth-wireless-ear-buds-auto-pairing | 190/201 |
30672 | 2pcs-screen-protector-film-for-samsung-galaxy-watch-46mm-smart-wacth-accessories-anti-shock-tempered-glass-protective | 190/204 |
30673 | dji-osmo-pocket-accessories-adapter-storage-board-holder-with-lanyard | 299/550 |
30674 | controller-grip-for-nintendo-switch-ns-left-and-right-joy-con-controller-gamepad-handle-stand-holder-protector-red-and-blue-2pcs-video-game | 299/422 |
30675 | 2pcs-tempered-glass-screen-protector-for-huawei-watch2-smart-watch-film-guard | 190/204 |
30676 | iphone-7-lightning-to-hdmi-adapter-stouch-lightning-digital-av-adapter-for-iphone-7-7-plus-iphone-6-and-ipad-pro-models | 190/202 |
30677 | massage-slippers-leg-foot-massager-44-to-45-cm-en | 2/144/549 |
30678 | full-hd-1080p-3d-hdmi-extender-by-cat5e-cat6-network-cable-extend-hdmi-signal-to-30m-for-hdtv-hdpc-ps3 | 299/383 |
30679 | digital-foldable-portable-7-drum-pad-musical-instrument-electronic-midi-drum-set-silicon-roll-up-drum-kit-sticks | 299/401/576 |
30680 | camera-bag-camera-case-bag-for-dslr-nikon-d4-d800-d7000-d5100-d5000-d3200-d3100-bags-for-photographer | 299/412/413 |
30681 | slim-external-cd-rw-drive-dvd-r-combo-burner-player-cd-drive-for-laptop-notebook-pc-desktop-computer | 299/383 |
30682 | metal-dust-guard-for-apple-airpods-case-shell-skin | 190/201 |
30683 | pgytech-dji-osmo-pocket-phone-holder-set-for-dji-osmo-pocket-handheld-gimbal-holder-bracket-accessories | 299/412/565 |
30684 | coolcold-air-cooled-laptop-cooler-usb-air-external-extracting-cooling-fan-radiator-notebook-ventilation-cooling-pad | 299/383 |