{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "46.81"
},
"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": 22,
"rows_produced_per_join": 22,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (45932,45933,45934,45935,45938,45939,45940,45944,45945,45946,45947,45949,45950,45951,45952,45953)) 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": "42.41",
"eval_cost": "4.40",
"prefix_cost": "46.81",
"data_read_per_join": "37K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
45932 | zoook-fabric-pure-copper-cable-for-charge-and-sync-1m-2a-support-iphone-ipad-black-with-gold-connectors | 190/202 |
45933 | zoook-fabric-pure-copper-cable-for-charge-and-sync-1m-2a-support-type-c-usb-black-with-gold-connectors | 190/202 |
45934 | zoook-digital-optical-audio-toslink-cable-1.2m-black | 190/429 |
45935 | zoook-zf-cpill-type-c-to-type-c-f-music-adaptercharging-splitter-silver-black | 190/193 |
45938 | zoook-zf-c2mf-type-c-to-micro-usb-f-adapter-space-grey | 190/202 |
45939 | zoook-zf-cu3o-type-c-otg-to-usb-3.0-adapter-cable-black | 190/202 |
45940 | zoook-zf-comf-micro-usb-to-usb-c-adapter-otg-space-grey | 190/202 |
45944 | zoook-zf-l2ld-bk-lightning-to-dual-lightning-port-connector-cable-works-with-iphone-ipad-ipod-black | 190/202 |
45945 | zoook-zf-l2ld-sl-lightning-to-dual-lightning-port-connector-cable-works-with-iphone-ipad-ipod-silver | 190/202 |
45946 | zoook-zf-l2la-bk-lightning-to-dual-lightning-port-connector-dongle-works-with-iphone-ipad-ipod-black | 190/202 |
45947 | zoook-zf-l2la-sl-lightning-to-dual-lightning-port-connector-dongle-works-with-iphone-ipad-ipod-silver | 190/202 |
45949 | zoook-zf-l2fa-bk-lightning-to-aux-female-connector-works-with-iphone-ipad-iphone-black | 190/202 |
45950 | zoook-zf-l2fa-sl-lightning-to-aux-female-connector-works-with-iphone-ipad-iphone-silver | 190/202 |
45951 | zoook-smart-wireless-charger-with-3-input-options-micro-type-c-lightning-with-led-indicator-5w-output-universal-for-all-qi-enabled-devices-black | 190/193 |
45952 | zoook-smart-wireless-charger-with-3-input-options-micro-type-c-lightning-with-led-indicator-5w-output-universal-for-all-qi-enabled-devices-white | 190/202 |
45953 | zoook-smart-wireless-fast-charger-with-10w-outputuniversal-for-all-qi-enabled-devices-white | 190/193 |