{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "39.81"
},
"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": 17,
"rows_produced_per_join": 17,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30766,30767,30769,30770,30771,30772,30773,30774,30775,30776,30777,30778,30779,30781,30782,30783)) 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": "36.41",
"eval_cost": "3.40",
"prefix_cost": "39.81",
"data_read_per_join": "28K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30766 | folio-cover-for-samsung-galaxy-tab-s5e-2019-t720-725-released-galaxy-tab-s5e-10.5-2019-tablet-funda-slim-case | 190/191/419 |
30767 | creative-world-map-computer-mousepad-mouse-pad-mouse-mat-matt-pad-anti-slip-gaming | 299/383/560 |
30769 | women-circular-handwoven-retro-rattan-straw-weave-beach-bag-crossbody-bag | 12/13/38 |
30770 | lazy-neck-hanging-style-dual-cooling-fan-portable-with-usb-rechargeable-neckband-battery-operated-quiet-for-office-room-sports-running-fitness-personal-fan-black | 6/168/179 |
30771 | pet-nail-file-grinder-layopo-electric-pet-nail-trimmer-for-paw-grooming-trimming-shaping-smoothing-rechargeable-ultra-silence-2-speed-usb-charging-pet-nail-clippers-for-small-medium-large-dogs-cats | 6/367/368 |
30772 | logitech-mx518-classic-gaming-mouse-upgraded-version-16000dpi-comfortable-grip | 299/383/560 |
30773 | dux-ducis-samsung-galaxy-tab-a-10.1-case-slim-folding-cover-with-auto-wake-sleep-for-samsung-galaxy-tab-a-10.1-2019-model-sm-t510-sm-t515-blue | 190/191/419 |
30774 | slim-folio-cover-case-for-samsung-galaxy-tab-s5e-2019-t720-725-new-released-galaxy-tab-s5e-10.5-2019-tablet-funda | 301 |
30775 | folio-cover-for-samsung-galaxy-tab-s5e-2019-t720-725-released-galaxy-tab-s5e-10.5-2019-tablet-funda-slim-case-en | 190/191/419 |
30776 | 10pcs-3inch-paper-photo-flim-diy-wall-picture-hanging-frame-albumropeclips-set | 6 |
30777 | 100ml-graduated-beaker-clear-plastic-measuring-cup-for-lab-2-pcs | 2/432 |
30778 | portable-shoes-travel-storage-bag-organizer-tote-luggage-carry-pouch-holder-bk | 12/50/68/76 |
30779 | expandable-pain-relief-neck-pillow-collar-cervical-traction-brace-support-pillow | 6/7/61/64 |
30781 | kitchen-bathroom-wall-storage-shelf-hanging-rack-corner-basket-holder-organizer | 6/168/183 |
30782 | 5pcs-disposable-fly-trap-catcher-fly-catcher-insect-trap-hanging-style-pest-control | 6/168/529 |
30783 | a-pair-refrigerator-handle-cover-kitchen-appliance-refrigerator-cover | 6/168/183 |