{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.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": 21,
"rows_produced_per_join": 21,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14562,14563,14564,14565,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,14576,14577)) 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": "41.21",
"eval_cost": "4.20",
"prefix_cost": "45.41",
"data_read_per_join": "35K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14562 | sound-storm-lopro10-10-inch-800-watt-amplified-subwoofer-system | 300/606 |
14563 | pyle-plcmtr26-dual-weatherproof-rearview-backup-camera-for-bus-truck-trailer-and-van-ir-night-vision-waterproof-commercial-grade-dc-12-24v | 299/412 |
14564 | suptech-0.2mm-real-apple-wtach-tempered-glass-with-full-cover-edge-screen-protector-for-apple-watch-42mm-black | 190/204 |
14565 | 2017-newest-version-huawei-watch-2-band-hoco-solid-stainless-steel-metal-watch-band-replacement-strap-wrist-band-with-butterfly-style-buckle-for-huawei-smart-watch2-not-huawei-watch-1-black | 190/204 |
14566 | moto-insta-share-projector | 190/429 |
14567 | e-lv-3-pack-anti-shatter-tempered-glass-screen-protector-ultra-clear-hd-screen-guard-for-nintendo-switch-2017 | 299/422 |
14568 | high-quality-3000-mah-external-battery-pack-portable-power-bank-case-charger-for-apple-iphone-6-black | 190/191/418 |
14569 | sony-cp-w5-wireless-portable-charging-pad-with-5000-mah-for-qi-compatible-devices | 190/193 |
14570 | vinsica-20000mah-smart-dual-usb-power-bank-portable-external-battery-charger-for-iphone-6-6plus-5-5s-ipad-samsung-galaxy-cell-phones-tablets. | 190/194 |
14571 | power-bank-20000mah-portable-charger-external-battery-pack-with-3-port-5.2a-for-iphone-6s-plus-5s-5c-5-4s-ipad-mini-samsung-galaxy-s6-s5-s4-note-more-phones-and-tablets-white | 190/194 |
14572 | mobility-10-000-mah-power-bank-black-w-dual-usb-output-portable-charger-lithium-polymer-battery-pack-designed-to-charge-cell-phones-tablets-and-other-mobile-devices-while-traveling-or-on-the-go | 190/194 |
14573 | mophie-powerstation-4000-purple | 6/184/185 |
14574 | clearsounds-qt4-quattro-4.0 | 299/383/402 |
14575 | ds18-hdpbt-noise-isolating-over-ear-foldable-bluetooth-headphone-with-mic-and-fm-radio | 190/201 |
14576 | uxcell-new-mini-wireless-bluetooth-4.0-in-ear-earbud-headphone-with-mic-for-iphone-smsung-nexus-lg-zte-and-other-smartphones-black-1-pc | 190/201 |
14577 | kinivo-bth220-bluetooth-stereo-headphone-supports-wireless-music-streaming-and-hands-free-calling | 190/201 |