{
"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 (14546,14547,14548,14549,14550,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561)) 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 |
---|---|---|
14546 | potable-bluetooth-v4.0-speaker-with-viewing-stand-dock-for-smartphone-meidong-istage-mini-foldable-wireless-speaker-with-mic-10-hours-playtime-nfc-function-white | 299/382 |
14547 | nippon-hc-101-4-ohm-1-channel-400w-120-hz-low-pass-subwoofer-crossover | 300/410 |
14548 | pyle-pdiws10-in-wall-in-ceiling-10-high-power-subwoofer-system-dvc-flush-mount-white-single-speaker | 300/606 |
14549 | pyle-rugged-32gb-1080p-water-resistant-hd-police-body-camera-night-vision-ir-rechargeable-battery-remote-control | 299/412 |
14550 | besteker-wifi-camcorder-full-hd-1080p-30fps-portable-digital-video-camera-with-external-microphone-hdv-z20 | 299/412 |
14551 | toguard-backup-camera-7-mirror-dash-cam-touch-screen-1080p-rearview-front-and-rear-dual-lens-with-waterproof-reversing-camera | 299/412 |
14552 | bw-3.6mm-wide-angle-car-rear-view-reversing-backup-camera-with-night-vision | 299/412 |
14553 | oldshark-3-1080p-dash-cam-with-32gb-card-170-wide-angle-car-on-dash-video-g-sensor-night-vision-wdr-parking-guard-loop-recording-dashboard-camera-recorder | 299/412 |
14554 | kdlinksaa-x1-full-hd-19201080-165aa-wide-angle-car-dashboard-camcorder-with-gps-g-sensor-wdr-superior-quality-night-mode-6-glass-lens-2.7-screen-and-8gb-micro-sd-included | 299/412 |
14555 | ddpai-mini-full-1080p-hd-dash-camera-w-wifi-iphone-android-app-remote-control-free-16g-tf-card-and-installation-kit | 299/412 |
14556 | skullcandy-inkd-2-with-mic-earphones-earbuds-premium-headphone-rasta-one-size | 190/386 |
14557 | sis-cell-stands-with-clip-flexible-long-arms-for-phone-gps-devices-fit-on-desktop-bed-mobile-stand-for-bedroom-office-bathroom-kitchen-blue | 190/195 |
14558 | galaxy-s7-edge-case-ringke-onyx-resilient-strength-flexible-durability-durable-anti-slip-tpu-defensive-case-for-samsung-galaxy-s7-edge-black | 190/191/418 |
14559 | haweel-universal-car-steering-wheel-phone-mount-holder-for-iphone-7-plus-iphone-7-iphone-6-and-6-plus-width-of-5.5-8.6cm-smartphone-black-hwl-6440b | 190/195 |
14560 | for-lg-v20-bolt-cover-w-kickstand-holster-tempered-glass-screen-protector-lanyard-red-black-bolt | 190/192 |
14561 | zizo-bolt-cover-for-lg-k7-lg-k8-lg-tribute-5-ls675-lg-escape-3-.33mm-9h-full-curved-tempered-glass-screen-protector-dual-layered-military-grade-case-kickstand-holster-belt | 190/191/418 |