{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "53.81"
},
"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": 27,
"rows_produced_per_join": 27,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30685,30686,30687,30688,30689,30690,30691,30692,30693,30694,30695,30696,30697,30699,30700,30701)) 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": "48.41",
"eval_cost": "5.40",
"prefix_cost": "53.81",
"data_read_per_join": "45K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30685 | p9-head-up-display-car-styling-hud-car-obd-smart-digital-meter-auto-two-display-on-the-windshield-digital-speedometer | 300/606 |
30686 | i11-ifans-tws-air-pods-1-1-wireless-bluetooth-5.0-super-bass-earbud-pk-i10-i12-i13-tws-for-ear-pod | 190/201 |
30687 | external-usb-3.0-dl-dvd-rw-burner-cd-writer-slim-portable-optical-drive-for-asus-samsung-acer-dell-universal-sony-hp | 299/383 |
30688 | caden-k1-army-green-camera-bag-case-triangle-crossbody-shoulder-bag-video-for-canon-nikon-dslr-camera | 299/412/413 |
30689 | usb-to-3.5mm-microphone-mic-adapter-transfer-cable-wire-for-gopro-hero-3-3-4-for-digital-camera | 299/412/413 |
30690 | camouflage-pattern-shockproof-waterproof-portable-case-for-gopro-hero4-3-3-2-1-m | 299/412/413 |
30691 | mini-hdmi2av-support-ntsc-and-pal-output-hd-video-converter-box-hdmi-to-av-cvbs-l-r-video-adapter | 299/431 |
30692 | sunnylife-dji-osmo-pocket-handheld-gimbal-camera-waterproof-portable-protective-storage-bag-case | 299/412/413 |
30693 | dji-osmo-mobile-2-carrying-bag-handbag-nylon-carrying-case-for-osmo-mobile-2-handheld-gimbal-camera-stabilizer-protector-bag | 299/412/413 |
30694 | vipeco-universal-car-dashboard-holder-stand-bracket-mount-for-mobile-cell-phone-120.00-110.00-80.00-mm | 190/199 |
30695 | iskil-i12-tws-bluetooth-5.0-earphone-true-wireless-sports-touch-earbuds-sweatproof-headset-3d-stereo-air-pod-white | 190/201 |
30696 | women-underwear-lace-t-back-g-string-lovely-nightwear-panties-pearl-open-crotch-in-free-size-black | 12/13/14/27 |
30697 | quartz-wrist-watch-turntable-black-dial-clock-hours-mens-womens-wristwatches-gift | 12/95 |
30699 | leather-case-for-huawei-mediapad-t5-10inch-tablet-stand-smart-cover-auto-sleep-wake-blue | 190/191/419 |
30700 | cool-mat-for-pet-mat-is-fresh-and-breathable-washable-straw-mat-is-easy-to-clean-in-summer-dog-and-cat-sleep-nest | 6/367 |
30701 | slim-magnetic-pu-leather-case-for-lenovo-tab-m10-tb-x605f-tb-x605-tablet-cover-for-lenovo-tab-m10 | 190/191/419 |