{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "42.61"
},
"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": 19,
"rows_produced_per_join": 19,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14337,14338,14339,14340,14341,14342,14343,14344,14345,14346,14347,14348,14349,14350,14351,14352)) 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": "38.81",
"eval_cost": "3.80",
"prefix_cost": "42.61",
"data_read_per_join": "32K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14337 | x-doria-gel-jacket-case-iphone | 190/191/418 |
14338 | zizo-bolt-series-samsung-galaxy-s9-plus-case-full-curved-glass-screen-protector-with-holster-and-12ft-military-grade-drop-tested-black-and-black | 190/191/418 |
14339 | gp-battery-9-v-pp3-alkaline-battery-blister-packaging | 6/445 |
14340 | doro-7118-6520-easy-to-use-3g-uk-sim-free-mobile-phone-graphite-white | 190/191/418 |
14341 | invisibleshield-zagg-invisbleshield-glass-luxe-screen-protector-ross-gold-for-iphone-6-6s-retail-pack | 190/191/418 |
14342 | rayovac-type-312-hearing-aid-batteries-6-pack | 6/445 |
14343 | gp-batteries-cordless-nimh-aaa-650-2-120.65aahcc2 | 6/445 |
14344 | corsair-140-mm-premium-magnetic-levitation-rgb-led-fan-black-pack-of-2 | 6/168/179 |
14345 | parker-im-fountain-pen-light-blue-grey-fine-nib-with-blue-ink-refill-1931648 | 248/544 |
14346 | mens-unique-analog-quartz-leather-band-dress-wrist-watch-waterproof-classic-business-casual-fashion-design-scratch-resistant-face-calendar-date-window-phase-98ft-30m-3atm-water-resistant-black | 12/95/97 |
14347 | ingersoll-mens-quartz-stainless-steel-and-leather-casual-watch-color-brown-model-i03001 | 12/95/97 |
14348 | topwell-black-pocket-watch-roman-pattern-steampunk-retro-vintage-quartz-roman-numerals-pocket-watch | 12/95/97 |
14349 | sturmanskie-gagarin-automatic-russian-watch-2432-4571790 | 12/95/97 |
14350 | twin-pack-baofeng-pofung-gt-3-mark-ii-transceiver-fm-radio-dual-band-136-174-400-520-mhz-chipsets-upgraded-abs-frame-programming-cable | 299 |
14351 | 6in-sata-power-y-splitter-cable-adapter-m-f | 299 |
14352 | pyle-phlha32-hearing-amplifier-for-tv-talking-volume-adjustable | 299 |