{
"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 (14739,14740,14741,14742,14743,14744,14745,14746,14747,14748,14749,14750,14751,14752,14753,14754)) 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 |
---|---|---|
14739 | 10ft-cable-db9f-to-db9f-null-modem-beige | 299/383 |
14740 | monoprice-107638-2-port-internal-sata-to-esata-bracket-107638 | 299/383 |
14741 | 16inch-slim-sata-to-sata-data-and-power-combo-cable | 299/383 |
14742 | monoprice-6ft-hp-plt-las-db9f-db25m-cable | 299/383 |
14743 | monoprice-6ft-db15-m-m-1-1-molded-cable-beige | 299/383 |
14744 | diablo-cable-3ft-smart-serial-male-dce-to-lfh60-male-dte-crossover-cable-for-cisco-cab-ss-6026x-3 | 2/10/136 |
14745 | 6ft-usb-type-a-male-to-mini-b-5-pin-male-cable | 299/383 |
14746 | microsoft-band-2-usb-charging-cable | 190/193 |
14747 | usb-c-cable-ravpower-type-c-to-type-c-charging-and-sync-cable-usb-c-to-usb-c-6.6ft-cable-for-new-macbook-chromebook-pixel-nexus-6p-nexus-5x-oneplus-2-nokia-n1-tablet-and-more | 190/202 |
14748 | 31cm-long-2.54mm-pitch-14-pin-female-to-female-idc-connector-ribbon-cable-gray | 299/383 |
14749 | audioquest-cinnamon-micro-usb-cable-1.5-meter | 299/383 |
14750 | tnp-usb-3.0-cable-micro-b-to-type-a-15-ft-type-a-male-to-micro-b-male-adapter-converter-extension-gold-plated-superspeed-usb-connector-port-plug-wire-cord-blue | 299/383/402 |
14751 | sabrent-6-pack-22awg-premium-micro-usb-cables-x3-3ft-x3-1ft-high-speed-usb-2.0-a-male-to-micro-b-sync-and-charge-cables-black-cb-u631 | 299/383/402 |
14752 | samsung-ad39-00183a-usb-data-link-cable-20-pin-black | 299/383/402 |
14753 | enacfire-6-pack-1ft-33ft-6ft-10ft-4-lengths-premium-micro-usb-cable-high-speed-usb-2.0-a-male-to-micro-b-snyc-and-charging-cable-black | 299/383/402 |
14754 | monoprice-select-series-usb-a-to-micro-b-charge-and-sync-cable-6-inch-black | 299/383/402 |