{
"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 (14530,14531,14532,14533,14534,14535,14536,14537,14538,14539,14540,14541,14542,14543,14544,14545)) 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 |
---|---|---|
14530 | portable-usb-digital-microscope-20x-800x-magnification-8-led-mini-microscope-endoscope-camera-magnifier-with-stand | 299/412 |
14531 | gskyer-telescope-instruments-infinity-60mm-az-refractor-telescope-german-technology-travel-scope | 299/412 |
14532 | reed-instruments-lm-81lx-compact-light-meter-20-000-lux-2-000-foot-candles-fc | 299/412 |
14533 | fovitec-studiopro-2x-76-classic-light-stand-kit-classic-for-photo-and-video-includes-carrying-bag | 300/377 |
14534 | shidianyi-4ftx6ft-fuchsia-pink-sequin-photo-backdrop-party-prom-photography-background-wedding-photo-booth-fuchsia-pink | 299/412/413 |
14535 | xmym-newborn-long-tail-hat-handmade-crochet-knitted-unisex-baby-cap-outfit-photo-props | 248/302 |
14536 | hidden-spy-pen-camera-conbrov-td88-720p-hd-portable-mini-body-camera-video-recorder-with-loop-recording-sd-card-not-included | 299/412 |
14537 | netgear-security-system-with-siren-2-rechargeable-wire-free-hd-cameras-night-vision-white-vms4230-100nas | 299/412/413 |
14538 | nest-cam-outdoor-security-camera-works-with-amazon-alexa | 299/389 |
14539 | monoprice-inc.-1x4-hdmi-amplifier-splitter-over-cat5e-cat6-complete-solution-kit-extend-upto-164ft | 299 |
14540 | jvc-kw-r920bts-double-din-bluetooth-in-dash-car-stereo-receiver-w-for-android-and-iphone-sxm-vario-2-pre-4.8v-and-flac-playback | 300/606 |
14541 | boss-bv9986bi-bluetooth-enabled-in-dash-dvd-mp3-cd-am-fm-receiver | 300/606 |
14542 | premium-single-din-marine-stereo-radio-headunit-receiver-in-dash-lcd-digital-display-with-am-fm-radio-and-multimedia-aux-3.5mm-mp3-input-usb-sd-memory-card-readers | 300/606 |
14543 | soundstream-bx-12-digital-bass-processor | 300/606 |
14544 | soundstream-pf.6-picasso-component-6.5-2-way-350w-speaker-set | 300/606 |
14545 | b-and-c-5fg44-speaker-200w-5-8 | 300/606 |