{
"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 (14755,14756,14757,14758,14759,14760,14761,14762,14763,14764,14765,14766,14767,14768,14769,14770)) 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 |
---|---|---|
14755 | wacom-intuos-pro-pen-and-touch-large-tablet-pth851 | 190/551 |
14756 | pasbuyaa-camo-black-faded-ombre-series-silicone-skin-keyboard-cover-for-macbook-pro-13-15-17-with-or-w-out-retina-display-imac-and-macbook-air-13-camo-black | 299/383/560 |
14757 | hrh-spanish-keyboard-cover-protector-for-apple-macbook-air-11-11.6-inch-european-iso-keyboard-layout-silicone-skin-black | 299/383/560 |
14758 | clear-ultra-thin-silicone-keyboard-cover-protector-for-acer-aspire-v5-122-v5-122p-v5-132-v5-132p-v3-111p-v3-112p-v13-v3-331-v3-371-v3-372t-e11-e3-111-e3-112-es1-111m-aspire-r-11-r3-131t-aspire-switch-11-sw5-171-sw5-173-11 | 299/383/560 |
14759 | proelife-clear-ultra-thin-silicone-keyboard-protector-cover-skin-for-new-microsoft-surface-laptop-2017-surface-book-2-13.5-15 | 299/383/560 |
14760 | iogear-keymander-keyboard-and-mouse-adapter-for-ps4-ps3-xbox-one-and-xbox-360-includes-wireless-keyboard-and-mouse | 299/383/560 |
14761 | rii-k12bt-ultra-slim-portable-mini-wireless-bluetooth-keyboard-with-large-size-touchpad-mouse-stainless-steel-back-cover-for-windows-8.1-10-surface-pro-2-3linux-android-os-tablet-pc-smart-tv-box | 299/383/560 |
14762 | omotona-ultra-slim-bluetooth-keyboard-for-apple-ipad-air-3-2-1-ipad-pro-ipad-mini-4-3-2-1-ipad-4-3-2-iphone-6-6s-iphone-6-plus-and-other-bluetooth-enabled-devices-for-apple-white | 190/420 |
14763 | caseflex-ultra-slim-wireless-bluetooth-keyboard-for-all-ios-ipad-android-mac-and-windows-devices-silver-and-white | 190/420 |
14764 | lenovo-y-gaming-mechanical-keyboard-gx30k04088 | 299/383/560 |
14765 | arteck-2.4g-wireless-keyboard-stainless-steel-ultra-slim-full-size-keyboard-for-computer-desktop-pc-laptop-surface-smart-tv-and-windows-10-8-7-vista-xp-built-in-rechargeable-battery | 299/383 |
14766 | zoweeteka-dod-military-usb-common-access-cac-smart-card-reader-for-sim-atm-ic-id-card-single-smart-card-reader | 299/383 |
14767 | odroid-8gb-emmc-module-c2-linux | 299/383 |
14768 | edge-flash-memory-card-64-mb-com | 299/383 |
14769 | pny-128gb-high-speed-microsdxc-memory-card-p-sdux128u165g-ge | 299/383 |
14770 | nikon-d3400-digital-camera-memory-card-64gb-secure-digital-class-10-extreme-capacity-sdxc-memory-card | 299/383 |