{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.46"
},
"table": {
"table_name": "cscart_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": 11,
"rows_produced_per_join": 11,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (10793,10822,10734,10791,10859,10612,10735,10799,10895,10831)) and (`cscartdb`.`cscart_seo_names`.`type` = 'p') and (`cscartdb`.`cscart_seo_names`.`dispatch` = '') and (`cscartdb`.`cscart_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "6.36",
"eval_cost": "1.10",
"prefix_cost": "7.46",
"data_read_per_join": "18K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
10612 | organic-baby-soft-body-oil-softens-nourishes-moisturizes-usda-organic-baby-oil-massage-oil-reduces-fussiness-and-calms-chaotic-skin | 5/22/429 |
10734 | gift-set-of-5-crystals-essential-oil-blend-roller-all-natural-roll-on-perfume-set-of-5-aromatherapy-perfume-anxiety-relief | 5/409/446 |
10735 | crystals-essential-oils-roll-on-set-five-roll-on-essential-oils-with-crystals-pure-natural-scents-perfum-set-of-5-essential-oils | 5/409/446 |
10791 | shower-steamers-gift-set-of-4-aromatherapy-spa-bath-fizzy-gift-for-beauty-guru-natural-pampering-shower-bombs-spa-gift-box-for-valentines | 5/409/446 |
10793 | aromatherapy-shower-steamers-aromatherapy-shower-bombs-stocking-stuffers-fresh-scents-stocking-stuffers-for-stocking-stuffers | 5/409/446 |
10799 | sore-muscle-bath-salts-grapefruit-bath-salts-with-dead-sea-himalayan-epsom-relaxation-bath-gift-bath-salts-soak-relaxing-bath-salts | 5/409/21 |
10822 | spa-gift-set-gift-for-her-shower-steamers-gift-set-gift-for-mom-luxury-gift-for-women-relaxation-gift-bath-gift-box-by-lizush | 5/409/446 |
10831 | artesian-gift-set-of-3-soaps-soap-gift-set-soaps-in-a-gift-box-natural-soaps-natural-soap-set-of-3-bath-gift-set-soap-for-mom-bff-soap | 5/22/20 |
10859 | lavender-bath-salts-with-dead-sea-himalayan-epsom-bath-salts-relaxation-bath-gift-ath-salts-soak-relaxing-bath-salts-sore-muscle-soak | 5/409/21 |
10895 | natural-soaps-gift-set-teacher-holiday-gift-mothers-day-gift-set-co-worker-small-gift-natural-soap-set-bath-set-gift-for-her | 5/22/20 |