{
"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 (30948,30949,30950,30952,30953,30954,30955,30956,30957,30958,30960,30961,30962,30963,30964,30965)) 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 |
---|---|---|
30948 | 5m-d-e-p-i-type-foam-weather-draught-excluder-self-adhesive-window-door-seal-str | 6/184 |
30949 | automatic-watering-device-houseplant-plant-pot-bulb-globe-garden-house-waterer | 6/184/187 |
30950 | plastic-smoke-smoking-pipe-rack-cigar-pipe-holder-portable-foldable-holder | 6/445 |
30952 | 6pcs-heart-scented-bath-body-petal-rose-flower-soap-wedding-decoration-gift-blue | 6/7/147/584 |
30953 | wall-mounted-mop-organizer-holder-brush-broom-hanger-storage-rack-kitchen-tool-en | 6/184 |
30954 | pack-of-8-large-bright-colour-plastic-beach-towel-pegs-clips-to-sunbed | 6/184 |
30955 | handmade-dreamcatcher-feathers-night-light-car-wall-hanging-room-home-decor-gn | 207/469/470/473 |
30956 | 3d-big-skull-ice-tray-mold-bar-party-wine-ice-cube-maker-mold-ice-tray-tool | 6/438/454 |
30957 | c-est-la-vie-collection-of-rabbit-ear-manual-bottle-opener | 6/168/183 |
30958 | sleeping-baby-door-sign-black-painted-wood-letter-design-wall-hanging-ornament | 6/159/166 |
30960 | curtain-stripe-lights-300led-8-modes-warm-white-fairy-string-lights-decoration | 6/159/166 |
30961 | 90w-led-solar-street-light-pir-motion-sensor-wall-timing-lamp | 6/159/167 |
30962 | clear-plastic-craft-beads-jewellery-storage-organizer-tool-box-case | 6/184/189 |
30963 | 2-pack-wifi-smart-plug-timing-switch-voice-control-work-with-amazon-alexa-echo | 6/184/185 |
30964 | 2pc-rope-window-curtain-tiebacks-tassel-binding-rope-tie-backs-home-decor | 6/159/166 |
30965 | coffee-filter-reusable-capsule-fit-for-illy-coffee-capsule-dripper | 6/438/454 |