{
"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 (29730,29731,29732,29733,29734,29735,29736,29737,29738,29739,29740,29741,29742,29743,29744,29745)) 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 |
---|---|---|
29730 | eyewear-glasses-box-sunglasses-storage-box-and-organizer-for-8-glasses-pu-leather-black | 6/184/189 |
29731 | case-for-microsoft-surface-go-10-inch-cover-funda-tablet-laptop-folding-stand-pu-leather-shell | 299/383/561 |
29732 | for-apple-ipad-pro-10.5-2017-ultra-thin-fashion-flip-magnetic-smart-sleep-pu-leather-stand-case-cover | 190/191/419 |
29733 | big-eyes-slim-pu-leather-case-for-apple-ipad-pro-11-inch-2018-tablet-auto-sleep-stand-tpu-back-cover-en | 190/191/419 |
29734 | soft-dog-shark-house | 6/367 |
29735 | the-tower-slim-pu-leather-case-for-apple-ipad-pro-11-inch-tablet-auto-sleep-stand-tpu-back-cover | 190/191/419 |
29736 | polly-leather-intelligent-sleep-folding-stand-painted-leather-case-cover-for-apple-ipad-9.7inch-2017-tablet | 190/191/419 |
29737 | for-huawei-mediapad-m5-10.8-holster-flip-pu-leather-smart-stand-case | 190/191/419 |
29738 | hand-repair-tools-screwdriver-disassemble-kit-bag-wallet-set-for-rc-drone-fpv-dji-phantom-3-4 | 6/184/186 |
29739 | oled-128x64-usb-tester-dc-voltmeter-current-voltage-meters-power-bank-battery-capacity-monitor-qc3.0-phone-charger-detector | 2/432 |
29740 | 3.5m-6-led-2.0-megapixel-hd-wifi-waterproof-endoscope-boroscope-inspection-camera-for-ios-android-phone-tablet-windows-system | 299/412 |
29741 | angel-pet-carrier-backpack-dog-cat-airline-approved-carrier-bubble-puppy-shoulder-bag-innovative-traveler-handbag-front-back-pack-space-pet-basket-breathable-mesh-window | 6/367 |
29742 | vintage-printing-top-handle-bag-for-women-european-style-shoulder-bag-canvas-shell-crossbody-bag-en | 12/13/38 |
29743 | multi-function-charger-for-fitbit-blaze-smart-watch-usb-charging-cable-cradle-charger-dock-station-1m-length | 190/193 |
29744 | 25-in-1-torx-screwdriver-set-mini-repair-tool-kit-precision-screwdriver-tool-set-for-pc-glasses-mobile-phone-watch | 300/581 |
29745 | 3pcs-webcam-cover-shutter-magnet-slider-plastic-camera-cover-for-webcam-iphone-pc-laptops-mobile-smart-phone-privacy-sticker | 299/412/413 |