{
"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 (14449,14450,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464)) 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 |
---|---|---|
14449 | maxell-premium-grade-t-160-vhs-videotapes-10-pack | 299/401 |
14450 | maxell-ur-60-position-iec-type-i-normal-audio-cassette-5-pack | 299 |
14451 | 6ft-premier-series-xlr-male-to-1-4-in-trs-male-cable-16awg-gold-plated | 299/401 |
14452 | lindy-5m-usb-3.-active-extension-cable | 299/383 |
14453 | tnp-battery-pack-1000-mah-external-rechargeable-extended-power-bank-for-sony-playstation-4-ps4-wireless-controller-playstation-4 | 190/197 |
14454 | rechargeable-lithium-ion-battery-pack-for-sony-np-fp30-np-fp50-np-fp60-np-fp70-np-fp90-infolithium-p-series-and-sony-dcr-hc20-dcr-hc21-dcr-hc26-dcr-hc28-dcr-hc30-dcr-hc32-dcr-hc36-dcr-hc40-dcr-hc42-dcr-hc46-dcr-hc65-dcr-hc85-dcr-hc96-dcr | 299/383 |
14455 | varta-professional-litium-cr2-3v-battery-6206 | 299/383 |
14456 | 2-pack-battery-and-charger-kit-for-nikon-d5500-d5300-d3300-d5200-d5100-d3100-d3200-nikon-df-p7700-digital-slr-camera-includes-2-replacement-nikon-en-el14a-en-el14-batteries-fully-decoded | 299/383 |
14457 | top-max-lp-e6-lp-e6n-quick-dual-battery-charger-for-canon-eos-6d-7d-70d-60d-5d-mark-iii-5d-mark-ii-60da-dslr-cameras-lp-e6-battery-lc-e6-charger-with-car-charger | 190/194 |
14458 | kastar-battery-1-pack-charger-kit-for-nikon-en-el5-nikon-mh-61-work-with-nikon-coolpix-3700-4200-5200-5900-7900-p3-p4-p80-p90-p100-p500-p510-p520-p530-p5000-p5100-p6000-s10-cameras | 190/194 |
14459 | canon-eos-screen-protector-for-canon-eos-m100-eos-m6-powershot-g9-x-mark-ii-g7-x-mark-ii-g5-x-g9-x-lcd-tempered-glass-screen-protective-firm-for-canon-dslr-camera-m6-protector | 299/412/413 |
14460 | puluz-adjustable-elastic-head-strap-mount-for-gopro-hero6-5-5-session-4-session-4-3-3-2-1-xiaoyi-and-other-action-cameras | 299/412 |
14461 | luaaid-brass-52mm-to-77mm-step-up-filter-ring-adapter-52-77-luzid | 299/412/413 |
14462 | hoya-58mm-prond-nd-1000-neutral-density-filter-for-camera | 299/412/413 |
14463 | limostudio-3-section-double-articulated-arm-camera-mount-bracket-5-8-stud-with-3-8-screw-thread-hole-compatible-with-super-clamp-12-inch-long-each-section-angle-adjustable-agg2316v2 | 190/195 |
14464 | pixel-rc-201-e3-wired-shutter-release-control-for-canon-70d-450d-500d-650d-700d-1000d | 299/412/413 |