{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "48.21"
},
"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": 23,
"rows_produced_per_join": 23,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (29666,29667,29668,29669,29670,29671,29672,29673,29674,29675,29676,29677,29678,29679,29680,29681)) 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": "43.61",
"eval_cost": "4.60",
"prefix_cost": "48.21",
"data_read_per_join": "38K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
29666 | 60-colors-graphic-professional-design-art-twin-tip-marker-pen-series-a-black | 248/544/545 |
29667 | f4-usb-mixing-console-3-channel-digital-mic-line-audio-mixer-console-with-48v-phantom-power-for-recording-dj-stage | 299/401 |
29668 | flannel-thickened-warm-striped-toilet-seat-pad-toilet-seat-cushion-with-hook-and-loops | 6/7/147/154 |
29669 | foldable-aluminum-laptop-stand-lapdesks-with-cooling-tablet-dock-holder-bracket-for-macbook-air-macbook-pro-ipad-pro | 299/383 |
29670 | ins-style-dirty-clothes-cotton-rope-storage-basket-hair-ball-storage-basket-laundry-basket-toy-storage-basket | 6/184/189 |
29671 | display-headphone-stand-headset-holder-earphone-bracket-earbud-hanger-metal-and-soft-tup-for-headphone-black | 190/195 |
29672 | coteetci-anti-fingerprint-4d-glass-screen-protector-for-apple-watch-series-4-44mm-black | 190/204 |
29673 | 3.5m-wireless-hd-720p-waterproof-smart-wifi-camera-inspection-endoscope-for-iphone-6-6s-7-7sfor-above-android-4.4 | 299/385 |
29674 | sk-012-8gb-spy-mini-usb-flash-digital-audio-voice-recorder | 299/401 |
29675 | ninebot-by-segway-es2-kick-scooter-high-performance-8-inch-front-and-7.5-inch-back-tires-up-to-15.5-mile-range-15.5mph-top-speed-cruise-control-mobile-app-connectivity-black | 248/257/258/261 |
29676 | elfinbook-2.0-smart-reusable-erasable-notebook-microwave-wave-cloud-erase-notepad-note-pad-lined-with-pen | 248/544/545 |
29677 | 68-pin-pcmcia-compact-flash-cf-card-reader-adapter-for-laptop | 299/383/402 |
29678 | tablet-stand-phone-holder-adjustable-lazy-bed-floor-desk-tripod-foldable-desktop-mount-for-iphone-ipad-kindle-galaxy-tab-support | 190/195 |
29679 | usb-wired-microphone-unidirectional-dynamic-handheld-recording-mic-for-switch-ps3-ps4-xbox-360-wii-karaoke-microphones | 299/401 |
29680 | nicer-quick-5-in-1-dicer-fruit-and-vegetable-cutter-set | 6/438/443 |
29681 | xiaomi-mi-air-purifier-2s-sterilizer-addition-to-formaldehyde-cleaning-intelligent-household-home-supplies | 6/184/378 |