{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.01"
},
"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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722)) 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": "40.01",
"eval_cost": "4.00",
"prefix_cost": "44.01",
"data_read_per_join": "33K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14707 | palm-centro-685-smartphone-unlocked | 190 |
14708 | apple-iphone-6s-factory-sealed-unlocked-phone-16gb-space-grey-international-version-no-warranty | 190 |
14709 | lenx-18-pipe-aluminum-heat-exchanger-radiator-for-pc-cpu-co2-laser-water-cool-system-computer-120mm-b | 299/383 |
14710 | yiynova-p2x-v3-premium-tablet-pen-w-kit-for-yiynova-u-series-tablets | 190/556 |
14711 | original-samsung-galaxy-note-4-black-touch-stylus-s-pen-replacement-new-usa | 190/556 |
14712 | uxcell-10-pcs-6mm-x-3.5mm-2-wire-cable-mic-capsule-electret-condenser-microphone | 299/383 |
14713 | valinksaa-plug-and-play-home-studio-adjustable-pc-desktop-laptop-notebook-omnidirectional-condenser-microphone-mic-with-3.5mm-plug-ideal-for-skype-facetime-microsoft-cortana-lol-youtube-black | 299/383 |
14714 | av-access-vgaaudio-to-hdmi-converter-1920x1200-60hz-1080p-plug-and-play-mounting-ear-supply-for-computer-laptop | 299/383 |
14715 | usb-c-type-c-to-3.0-usb-a-type-a-adapter-converter-connector-type-c-male-to-usb-3.0-type-a-female-compatible-with-the-new-2015-macbook-2-pack-silver | 299/383/384 |
14716 | adafruit-flex-cable-for-raspberry-pi-camera-1-meter-ada2143 | 299/383 |
14717 | fueran-dp-displayport-display-emulator-edid-emulator-plug-fit-headless-2560x160060hz | 299/383/384 |
14718 | sela-design-pcie-ver-007-6-pin-16x-to-1x-powered-riser-adapter-card-w-60cm-usb-3.0-extension-cable-and-6-pin-pci-e-to-sata-power-cable-highest-quality-gpu-riser-adapter-ethereum-mining-eth | 299/383 |
14719 | phobya-4-pin-molex-to-4-x-3-pin-fan-connector-cable-power-4-fans-from-1-molex-connection | 299/383/402 |
14720 | kptec-3-in-1-mini-displayport-thunderbolt-to-hdmi-dvi-i-vga-tv-hdtv-av-cable-adapter-for-apple-macbook-pro-macbook-air-imac-surface-pro-4-surface-pro-3-white | 299/383/402 |
14721 | hde-gold-plated-high-speed-hdmi-to-dvi-d-241-adapter-cable-with-braided-fabric-jacket-5ft | 299/383/402 |
14722 | cabletime-mini-displayport-cable-in-white-with-gold-plated-male-to-male-4k-32-awg-6.5-feet-2m | 299/383/402 |