{
"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 (30386,30387,30388,30389,30390,30391,30392,30393,30394,30395,30396,30398,30399,30400,30401,30402)) 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 |
---|---|---|
30386 | head-up-speedometer-display-hud-gps-obd-computer-car-speed-digital-display | 300/606 |
30387 | for-lenovo-tab-4-10-tb-x304f-tb-x304n-coverking-tablet-10.1-inch-case-cover-black | 190/191/419 |
30388 | razer-taipan-gaming-mouse-black | 299/383/560 |
30389 | baby-car-mirror-for-rear-view-facing-back-seat-for-infant-toddler-child-in-car-seat-360-adjustable-and-double-straps | 300/410 |
30390 | p12-obd2-hud-computer-car-digital-obd-driving-speedometer-en | 300/606 |
30391 | usb-to-3d-external-sound-card-audio-adapter-virtual-7.1-channel-ch-sound-mic-speaker-adapter | 299/383 |
30392 | universal-car-gps-hud-head-up-display-support-for-iphone-samsung-smart-mobile-phone-mobile-phone-navigation-holder-black | 190/199 |
30393 | 360-degree-rotating-ipad-air-2-case-stand-case-with-smart-cover-auto-sleep-wake-feature-black | 190/191/419 |
30394 | tap-toys-baby-sleeping-shaping-pillow-baby-neck-protection-pillows-memory-nursing-pillow | 248/249/254/507 |
30395 | wireless-keyboard-and-mouse-combo-2.4ghz-cordless-cute-round-key-set-smart-power-saving-whisper-quiet-slim-combo-for-laptop-computer-tv-and-mac-en | 299/383/560 |
30396 | dji-spark-drone-remote-controller-signal-booster-fold-antenna-signal-enhance-specular-surface-with-film-protection | 299/412/565 |
30398 | broadlink-rm-mini-3-smart-home-universal-intelligent-wifi-ir-4g-wireless-remote-control-switch-rm-mini3-via-phone-android-and-iphone-ios | 299/385 |
30399 | portable-magnetic-finger-charger-power-bank-5000mah-charging-station-and-4-charging-packs-each-1000mah-easy-to-carry-in-pocket-fit-for-iphone-android-and-type-c-phones-black | 190/193 |
30400 | hdmi-splitter-switcher-switch-1x4-connector-hub-with-adpater | 299/383 |
30401 | lightning-hdtv-cable-apple-iphone-x-8-plus-2m-lightning-to-hdmi-av-tv-cable-adapter-1080p-for-apple-iphone-7-6-6s-plus-5s-ipad-air-ipad-mobile | 190/202 |
30402 | for-garmin-fenix-3-hr-watch-regentech-usb-charger-charging-dock | 190/193 |