{
"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 (14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786)) 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 |
---|---|---|
14771 | season-ultra-64gb-micro-sdxc-uhs-i-card-class-10-with-adapter-up-to-80mb-s-high-speed-memory-card-tf-card | 299/383 |
14772 | monoprice-109196-outlet-power-surge-protector-slim-wall-tap-540-joules | 6/184/185 |
14773 | targus-c4-backpack-for-laptops-up-to-16-inch-tsb70902us-blue-black | 299/383/512 |
14774 | silverstone-tech-inc-sst-pm01br-w-black-with-red-led-window-plastic-outer-shell-steel-body | 299/383 |
14775 | shuttle-mini-computer-system-components-sh110r4-black | 299/383 |
14776 | ncsm2485.dk-movidius-neural-compute-stick-2-with-myriad-x-vision-processing-unit | 299/383 |
14777 | arctic-alpine-20-plus-co-cpu-cooler-intel-lga2011-92mm-pwm-fan-24-7-operation-at-24dba | 299/383 |
14778 | bigstone-tec1-12710-thermoelectric-cooler-peltier-154w | 299/383 |
14779 | monsoon-hardline-economy-compression-fittings-3-8-x-1-2-6-pack-blue | 299/383 |
14780 | bitspower-g1-4-temperature-sensor-stop-fitting-deep-blood-red | 299/383 |
14781 | pyle-standalone-video-recorder-pvrc43 | 299/401 |
14782 | new-cmos-rtc-battery-replacement-for-hp-g60-cq50-cq60-cmos-battery-by-pcrepair | 299/383 |
14783 | crucial-4gb-single-ddr3-1866-mt-s-pc3-14900-sodimm-204-pin-memory-ct51264bf186dj | 299/383 |
14784 | 2gb-ram-memory-for-compaq-presario-cq-series-cq40-cq60-210us-cq60-214dx-cq60-211dx-cq60-228us-black-diamond-memory-module-ddr2-so-dimm-200pin-pc2-5300-667mhz-upgrade | 299/383 |
14785 | nanya-1gb-pc2-6400-1-gb-nt1gt64u88d0by-ad-1gb-pc2-6400-desktop-ram-memory | 299/383 |
14786 | lattepanda-a-powerful-windows-10-mini-pc-4gb-64gb-with-enterprise-license | 299/383 |