{
"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 (30896,30897,30898,30899,30900,30901,30902,30903,30904,30905,30906,30907,30908,30909,30910,30911)) 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 |
---|---|---|
30896 | wooden-cup-wood-coffee-tea-beer-juice-milk-water-mug-primitive-handmade-natural | 6/438/454 |
30897 | 100pcs-clear-disposable-plastic-shower-bath-caps-for-spa-hair-salon-wh | 6/7/147/584 |
30898 | waterproof-canvas-laundry-clothes-basket-storage-basket-folding-storage-box-b | 6/184/189 |
30899 | faucet-extender-sink-handle-extension-toddler-kid-bathroom-children-hand-wash | 6/168/183 |
30900 | 5-inch-deluxe-large-blue-and-white-floating-swimming-pool-chlorine-dispenser | 6/184/378 |
30901 | 2-pcs-large-bright-colour-plastic-beach-towel-pegs-clips-to-sunbed-quilt-clips | 6/445 |
30902 | activated-carbon-front-loading-water-clean-filter-tap-purifier-head-kitchen | 6/184/378 |
30903 | rose-gold-pink-cushion-cover-square-pillowcase-home-decoration-30cm-x-50cm | 6/7/61/64 |
30904 | nest-dox-nest-house-bird-house-bird-house-bird-box-bird-box-wooden-box-en | 6/367/371 |
30905 | steel-watch-bracelet-spring-bar-standard-plier-6825-remover-adjuster-tool | 12/95/597 |
30906 | 2pc-insulated-foam-lined-heavy-thick-blackout-grommet-window-curtain-panels | 6/184 |
30907 | neoprene-lunch-tote-bag-insulated-waterproof-lunch-box-for-women-adults-kids-bk | 6/438/476/478 |
30908 | pedicure-tools-2pcs-natural-pumice-stone-hard-skin-callus-remover-for-feet | 2/10/136 |
30909 | mini-butterfly-beetle-folding-hanger-holder-table-hook-for-purse-handbag-utility | 12/13/44 |
30910 | 3pcs-set-no.7404-series-watch-hand-setter-presser-setting-fitting-tool-0.9-1.4mm | 6/184 |
30911 | household-waterproof-microwave-oven-dust-cover-with-storage-bag-for-kitchen-b | 6/168/183 |