{
"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 (14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529)) 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 |
---|---|---|
14514 | zalman-reiss-and-associates-inc.-microsdhc-high-capacity-8gb-class10-ultra-speed-133x-with-sd-adapter-full-hd-recording-capability | 299/412/413 |
14515 | alpine-innovations-spudz-classic-microfiber-cloth-screen-cleaner-and-lens-cleaner-nautical-stripes-large-10-x-10-inches | 6/445 |
14516 | purosol-all-natural-lens-cleaner-4oz. | 6/445 |
14517 | 250-sheets-5-booklets-altura-photo-lens-cleaning-paper-tissue-magicfiber-microfiber-cleaning-cloth | 6/445 |
14518 | xit-xtsp3-3-piece-universal-screen-protector-kit-clear | 299/412/413 |
14519 | neewer-77mm-nd-filter-set-nd2-nd4-nd8-for-canon-ef-24-15mm-f-4-l-is-usm-zoom-lens-the-nikon-28-3mm-f-3.5-5.6g-ed-vr-ii-af-s-lens | 299/412/413 |
14520 | polar-pro-filters-p5064-dji-phantom-3-nd64-filter-nd64 | 299/412/413 |
14521 | 72mm-x1-uv-mrc4-ultra-slim-weather-sealed-25-year-support-lens-cloth-included | 299/412/413 |
14522 | sigma-em-14-macro-flash-adaptor-ring-55mm | 299/412/413 |
14523 | celestron-93709-neximage-solar-system-imager-black-silver | 299/412/413 |
14524 | domke-1.5-inch-web-strap-with-swivel-742-1bk | 299/412/413 |
14525 | tarion-camera-shoulder-neck-strap-vintage-belt-for-all-dslr-camera-nikon-canon-sony-pentax-classic-white-and-brown-weave | 299/412/413 |
14526 | smatreeaa-smacase-g160-medium-case-for-gopro-hero-hero-4-3-3-2-and-accessories-8.6-x6.7-x2.7-inches-travel-and-household-case-with-excellent-cut-foam-interior-perfect-protection-for-gopro-camera-full-black | 299/412/413 |
14527 | selfie-stick-foneso-yunteng-3-in-1-extendable-self-portrait-monopod-handheld-tripod-with-removable-bluetooth-remote-shutter | 190/195 |
14528 | perini-day-night-60x50-military-army-binoculars-camouflage-w-pouch-hunting-camping | 207/469/470 |
14529 | pentax-up-8-16x21-green-binoculars | 299/412 |