{
"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 (31089,31090,31091,31092,31093,31094,31095,31096,31097,31098,31099,31100,31101,31102,31103,31104)) 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 |
---|---|---|
31089 | spiral-vegetable-fruit-slicer-cutter-grater-twister-peeler-kitchen-gadgets-tools | 6/168/183 |
31090 | 100x-candle-wicks-cotton-core-pre-waxed-with-sustainers-candle-making | 248/273/276 |
31091 | mini-heater-mini-heater-mini-electric-heater-electric-heater-electric-fan | 6/168/179 |
31092 | home-decors-buddha-printed-tapestry-wall-hanging-beach-throw-towel | 6/7/147/148 |
31093 | visually-impaired-blind-walking-stick-4-section-folding-aluminum-cane-124cm-long | 2 |
31094 | 2pcs-foil-curtains-backdrop-tinsel-backdrop-wedding-birthday-party-stage-decor | 6/159 |
31095 | 10-pack-bulk-extra-thick-emergency-waterproof-rain-poncho-with-drawstring-hood-raincoat-for-men-women-plastic-clear-rain-gea | 207/469/470/471 |
31096 | 12pcs-colorful-umbrella-wall-hook-key-hair-pin-holder-organizer-decorative | 6/159/166 |
31097 | gu10-smart-led-bulb-5w-dimmable-wifi-light-bulb-colorful-wireless-app-controlled | 6/159/167 |
31098 | 4pc-happy-valentines-day-throw-pillow-case-sweet-love-square-cushion-cover | 6/7/61/64 |
31099 | marble-diatom-mud-moisture-proof-anti-scalding-insulation-coaster-absorbent-pad | 6/159/166 |
31100 | pack-100-pre-waxed-candle-wicks-for-candle-making-with-sustainers-12cm-long | 248/273/276 |
31101 | reusable-glass-smoothie-straws-drinking-straws-for-milkshakes-frozen-drinks | 6/438/454 |
31102 | fridge-can-beer-wine-bottle-rack-organiser-holder-mat-stacking-tidy-tool | 6/438/454/455 |
31103 | ring-gauges-finger-sizer-measuring-ring-tool-size-1-13-with-half-size-27-piece | 12/13/44/46/296 |
31104 | diy-digital-oil-painting-kit-paint-by-numbers-on-canvas-unframed-home-decor | 6/159/166 |