{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.41"
},
"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": 21,
"rows_produced_per_join": 21,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802)) 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": "41.21",
"eval_cost": "4.20",
"prefix_cost": "45.41",
"data_read_per_join": "35K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14787 | asus-rog-strix-b250i-socket-1151-ddr4-s-ata-600-mini-itx-gaming-motherboard-black | 299/422 |
14788 | supermicro-1u-700w-power-supply-pws-702a-1r | 299/383 |
14789 | apple-macbook-a1181-macbook4-1-mb402ll-a-2.4ghz-intel-core-2-duo-t8100-120gb-hard-drive-1gb-ram-memory-early-2008 | 299/383 |
14790 | dell-latitude-e6400-14.1-notebook-pc-intel-core-2-duo-2.24ghz-4gb-ddr2-160gb-sata-hdd-dvd-windows-professional-32bit-certified-refurbished | 299/557 |
14791 | acer-chromebook-cb3-131-c3sz-11.6-inch-laptop-intel-celeron-n2840-dual-core-processor-2-gb-ram-16-gb-solid-state-drive-chrome-white | 299/557 |
14792 | apple-macbook-mjy42ll-a-12-inch-laptop-with-retina-display-space-gray-512-gb | 299/557 |
14793 | monoprice-inc.-asus-chromebook-c202sa-ys02-11.6-intel-celeron-n3060-dual-core-2-core-1.60-ghz-4-gb-lpddr3-ram-16-flash-memory-capacity-hd-graphics-400-chrome-os-1366-x-768 | 299/557 |
14794 | envizen-v917g-cosmos-32-gb-9-inch-black | 190/551 |
14795 | all-new-fire-7-tablet-with-alexa-7-display-8-gb-canary-yellow-with-special-offers | 190/551 |
14796 | seagate-momentus-thin-st320lt020-320-gb-2.5-internal-hard-drive | 301 |
14797 | western-digital-wd1600bevt-160-gb-5400rpm-sata-8-mb-2.5-inch-notebook-hard-drive | 299/383 |
14798 | drevo-x1-series-60gb-ssd-2.5-inch-solid-state-drive-sata3-read-500mb-s-write-90mb-s | 299/383 |
14799 | norco-heavy-duty-industrial-standard-rackmount-chassis-rpc-450 | 299/383 |
14800 | patriot-32gb-supersonic-rage-series-usb-3.0-flash-drive-with-up-to-180mb-sec-pef32gsrusb | 299/383 |
14801 | imbaprice-0.5-ft-6-inch-cat6-ethernet-network-patch-cable-rj45-10-pack-blue | 299/383 |
14802 | 3ft-3-feet-ieee-1284-db25-m-m-male-to-male-parallel-serial-cable-ul-certified | 299/383 |