{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "76.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": 43,
"rows_produced_per_join": 43,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30403,30404,30405,30406,30407,30408,30659,30660,30661,30662,30663,30664,30665,30666,30667,30668)) 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": "67.61",
"eval_cost": "8.60",
"prefix_cost": "76.21",
"data_read_per_join": "72K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30403 | for-samsung-s3-frontier-s3-frontier-lte-smart-watch-wireless-power-charging-charger-dock | 190/193 |
30404 | yw-001-3.5mm-mini-portable-tie-microphone-mic-with-clip-black | 299/383 |
30405 | female-g-string-free-size-pink | 12/13/14/27 |
30406 | broad-link-rm-mini-3-black | 299/431 |
30407 | 2m-fs-an01-android-endoscope-2m-black | 190/429 |
30408 | lace-g-string-for-women | 12/13/14/27 |
30659 | black-for-huawei-watch-gt-plated-tpu-case-cover-slim-soft-bumper-protective-case | 12/95/597 |
30660 | fujifilm-instax-mini-50-sheets-white-film-photo-paper-snapshot-album-instant-print-for-fujifilm-instax-mini-7s-8-25-90-9-en | 299/412 |
30661 | dji-mavic-pro-backpack-carry-case-mavic-pro-hardshell-drone-bag-mavic-carbon-storage-box | 299/412/565 |
30662 | caden-backpacks-big-black-camera-photo-shoulders-bags-polyester-men-women-digital-camera-case-backpack-for-canon-nikon-k7 | 299/412/413 |
30663 | hand-held-metel-detector-industrial-metal-detectors-sensitive-inspection-tester-security-checks | 2/432 |
30664 | electronic-roll-up-drum-pad-set-9-silicon-pads-built-in-speakers-with-drumsticks-foot-pedals | 299/401/576 |
30665 | mens-battlefield-backpack-camouflage-travel-rucksack-usb-headphone-jack-game-level-3-bag-pubgs | 12/50/77/79 |
30666 | big-holes-barber-hair-brush-sponge-dreads-locking-twist-afro-curl-coil-wave-hair-care-tool-random-color | 2/11/523 |
30667 | pgytech-pole-extension-stick-rod-scalable-holder-for-dji-osmo-pocket-camera-mobile-2-zhiyun-smooth-4-stabilizer-accessories | 299/412/414 |
30668 | black-gear-s3-frontier-case-cover-for-samsung-galaxy-watch-46mm-band-soft-tpu-plated-all-around-protective-cases-shell-frame | 190/204 |