{
"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 (30800,30801,30802,30803,30804,30805,30806,30807,30808,30809,30810,30811,30812,30813,30814,30815)) 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 |
---|---|---|
30800 | bag-clip-pour-food-sealing-storage-seal-sealer-freezer-fridge-clamp-cover-fresh | 6/184/189 |
30801 | 4-inch-mini-springform-pan-carbon-steel-baking-pan-non-stick-mini-cake-pan | 6/438/460/462 |
30802 | usb-baby-bottle-warmer-portable-travel-milk-warmer-infant-feeding-bottle-heated | 248/566 |
30803 | slim-folio-cover-case-for-samsung-galaxy-tab-s5e-2019-t720-725-new-released-galaxy-tab-s5e-10.5-2019-tablet-funda-en | 190/191/419 |
30804 | makeup-handmade-5pairs-natural-long-false-eyelashes-extension-exquisite | 2/144/100/106/111 |
30805 | led-dream-catcher-cloud-feather-dreamcatcher-girl-birthday-gift-baby-room-decor | 6/159/166 |
30806 | automatic-infrared-pir-motion-sensor-switch-for-home-office-led-light | 6/159/167 |
30807 | 6pc-set-home-decorative-pillowcase-cotton-linen-sofa-cushion-throw-pillow-cover | 6/7/61/64 |
30808 | strong-adhesive-hook-wall-door-sticky-hanger-holder-kitchen-bathroom-white-12pcs | 6/184 |
30809 | exercise-fitness-yoga-blocks-foam-bolster-pillow-cushion-eva-gym-training | 207/233 |
30810 | 6pc-set-home-decorative-pillowcase-cotton-linen-sofa-cushion-throw-pillow-cover-en | 6/7/61/64 |
30811 | adhesive-paper-towel-holder-under-cabinet-for-kitchen-bathroom | 6/184/536/539 |
30812 | music-note-alloy-bookmark-novelty-ducument-book-marker-label-stationery | 248/544/545 |
30813 | seagrass-wicker-basket-wicker-basket-flower-pot-folding-basket-dirty-basket-wh | 6/159 |
30814 | pineapple-leaf-yellow-pillow-case-sofa-car-waist-throw-cushion-cover-home-decor | 6/7/61/64 |
30815 | solar-powered-portable-electric-mosquito-lamp-mosquito-killer-lamps-solar-bug-za | 6/168/529 |