{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "41.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": 18,
"rows_produced_per_join": 18,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (29698,29699,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29711,29712,29713)) 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": "37.61",
"eval_cost": "3.60",
"prefix_cost": "41.21",
"data_read_per_join": "30K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
29698 | 8-set-travel-organizers-packing-cubes-lightweight-luggage-accessories-clothes-shoes-toiletry-bag-en | 12/555/564 |
29699 | heart-photo-locket-necklace-silver-plated-en | 12/13/44/46/293 |
29700 | ap-1-laptop-cooling-stand-aluminum-alloy-ergonomic-18-degree-viewing-angle-holder-support-11-17-inch-notebook-design-for-macbook | 299/383 |
29701 | bm-800-3.5mm-wired-sound-recording-condenser-microphone-with-nb-35-microphone-stand-for-radio-braodcasting-computer | 299/401 |
29702 | mini-2-gear-speed-usb-fan-computer-portable-mute-usb-charge-cooling-fan-desk-laptop-fan-sslp91-black | 6/168 |
29703 | 2-pcs-toilet-seat-cover-set-diamond-velvet-cashmere-lace-printed-home-decoration-with-back-waterproof-leather-toilet-cover-seat-toilet-seat-grey | 6/7/147/154 |
29704 | gold-case-with-pencil-holder-for-apple-ipad-9.7-inch-pu-leather-smart-cover-auto-sleep-wake | 190/191/419 |
29705 | diamond-selector-ii-moissanite-gemstone-tester-tool | 2/432 |
29706 | 925-silver-bracelet-glass-beads-pandora-style-charm-bracelets-for-women-en | 12/13/44/46/294 |
29707 | colourful-case-for-ipad-9.7-2018-a1893-a1954-cover-for-ipad-9.7-2017-a1822-a1823-9.7-inch-with-stand-function-auto-sleep | 190/191/419 |
29708 | pet-dog-cat-nail-grooming-grinder-trimmer-clipper-electric-nail-file-kit-en | 6/367 |
29709 | magic-cube-kindle-paperwhite-1-2-3-case-6-ereader-leather-case-for-kindle-paperwhite-cover | 190/191/419 |
29710 | tri-fold-stand-flip-case-for-samsung-galaxy-tab-s4-10.5-inch-smart-cover-for-samsung-sm-t835-sm-t830-funda-capa-auto-sleep-wake | 301 |
29711 | wifi-sd-card-adapter-micro-sd-microsd-tf-converter-for-sony-canon-nikon-cameras-photos-wirelessly-to-phone-tablets | 299/383 |
29712 | for-samsung-galaxy-tab-a-t580n-t585n-10.1-phone-case-armor-silicone-hard-plastic-shock-absorbing-cover-stand-case | 190/191/419 |
29713 | wireless-2.4g-air-mouse-handheld-trackball-mouse-thumb-controlled-handheld-trackball-mice-mouse | 299/383/560 |