{
"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 (14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,14865,14866)) 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 |
---|---|---|
14851 | alfa-awus036nh-2w-2000mw-long-rang-usb-wireless-n-802.11n-wifi-network-adaptermount5dbi-antenna | 299/383 |
14852 | urant-35dbi-ts9-dual-lte-4g-antenna-booster-plug-aerial-long-range-signai-amplifier-receiver-outdoor-high-gain-network-ethernet-for-4g-wifi-router-mobile-broadband-ts9-ts9 | 299/383 |
14853 | ubiquiti-powerbeam-pbe-5ac-500-2units-pre-conf-5ghz-airmax-bridge-25km-450mbps | 299/383 |
14854 | terrawave-lightning-arrestor-0-6-ghz-smaj-smabhj | 299 |
14855 | tp-link-re580d-ieee-802.11ac-1.86-gbit-s-wireless-range-extender-2.40-ghz-5-ghz-3-x-external-antenna-s-beamforming-technology-5-x-network-rj-45-ac-adapter-desktop | 299/383 |
14856 | hootoo-wireless-travel-router-usb-port-high-performance-10400mah-external-battery-pack-travel-charger-tripmate-titan-not-a-hotspot | 301 |
14857 | fintie-microsoft-surface-3-case-premium-pu-leather-folio-cover-with-cards-slots-and-stylus-holder-for-microsoft-surface-3-10.8-inch-windows-tablet-not-fit-surface-pro-3-12-inch-green-white | 190/191 |
14858 | jam-sleeve-for-13-13.3-laptops-macbook-chromebook-inspiron-notebook-zenbook-aspire-ativ-book-xps-yoga-and-others | 299/383 |
14859 | alaska2you-tablet-yoga-tab-3-rose-red | 6/360 |
14860 | phenas-laptop-canvas-zipper-sleeve-bag-green-briefcase-for-12.9-ipad-pro-13.3-inch-laptop-notebook-computer-macbook-air-macbook-pro | 299/383/561 |
14861 | sumaclife-micro-suede-carrying-sleeve-with-rear-pocket-for-13-13.3-inches-laptops-slmsuede13bblk | 299/383/561 |
14862 | vangoddy-arthur-microsoft-surface-pro-4-12.3-and-surface-pro-3-12-rotatable-vegan-leather-portfolio-stand-case-sky-blue | 299/383/561 |
14863 | khomo-ipad-pro-10.5-inch-black-case-with-pen-holder-companion-cover-perfect-match-for-smart-keyboard-and-cover | 190/191/419 |
14864 | ipad-pro-9.7-case-ipad-pro-9.7-inch-case-esr-pu-leather-smart-cover-folio-stand-case-with-auto-sleep-wake-function-for-9.7-inch-ipad-pro-2016-releasesilhouette | 190/191/418 |
14865 | ipad-pro-9.7-case-ipad-pro-9.7-inch-case-esr-oxford-cloth-smart-cover-folio-stand-case-with-auto-sleep-wake-function-for-9.7-inch-ipad-pro-2016-releasede-nimes | 190/191 |
14866 | ipad-pro-9.7-inch-case-esr-ipad-pro-9.7-slim-fit-shell-case-perfect-match-with-smart-keyboard-soft-tpu-bumper-corner-protection-back-cover-for-ipad-pro-9.7-inch-2016charcoal-gray | 190/191/418 |