{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "67.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": 28,
"rows_produced_per_join": 28,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (3799,3800,3801,3802,3803,3805,3806,3566,3567,3568,3569,3747,3748,3749,3750,3751,3752,3753,3755,3756,3757,3758,3759,3760,3761,3762,3764,3772)) 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": "61.61",
"eval_cost": "5.60",
"prefix_cost": "67.21",
"data_read_per_join": "47K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
3566 | lock-and-lock-microfiber-premium-car-cleaner-blue | 6/445/446/451 |
3567 | lock-and-lock-microfiber-glass-polishing-cleaner-blue | 6/445/446/451 |
3568 | lock-and-lock-microfiber-waffle-weave-cleaner-yellow | 6/445/446/451 |
3569 | lock-and-lock-microfiberhousehold-cleaner-yellow | 6/445/446/451 |
3747 | lock-and-lock-premium-dish-cloth-33x40cm-blue | 6/445/446/451 |
3748 | lock-and-lock-microfiber-absorption-cloth-40x40cm-yellow | 6/445/446/451 |
3749 | lock-and-lock-microfiber-cleaning-cloth-32x32cm-blue | 6/445/446/451 |
3750 | lock-and-lock-microfiber-multipurpose-cloth-40x40cm-green | 6/445/446/451 |
3751 | lock-and-lock-microfiber-hi-performance-dusting-cloth-30x32cm-pink | 6/445/446/451 |
3752 | lock-and-lock-microfiber-multipurpose-cloth-40x38cm-green | 6/445/446/451 |
3753 | lock-and-lock-microfiber-multipurpose-cloth-32x32cm-pink | 6/445/446/451 |
3755 | lock-and-lock-microfiber-ultimate-performance-cloth-40x40cm-blue | 6/445/446/451 |
3756 | lock-and-lock-microfiber-flr-cleaning-cloth-50x40cm-blue | 6/445/446/451 |
3757 | lock-and-lock-microfiber-abrasive-cloth-40x60cm-purple | 6/445/446/451 |
3758 | lock-and-lock-microfiber-2n1-cleaning-cloth-32x32cm-purple | 6/445/446/451 |
3759 | lock-and-lock-microfiber-eco-kitchen-cleaning-cloth-32x32cm-grey | 6/445/446/451 |
3760 | lock-and-lock-microfiber-anti-bacterial-microfiber-cloth-30x35cm-yellow | 6/445/446/451 |
3761 | lock-and-lock-microfiber-hi-performance-cleaning-cloth-30x32cm-green | 6/445/446/451 |
3762 | lock-and-lock-microfiber-hypoallergenic-spng-9x14cm-yellow | 6/445/446/451 |
3764 | lock-and-lock-special-microfiber-cloth-37x39cm-blue | 6/445/446/451 |
3772 | lock-and-lock-food-waste-dustbin-4.8-liter | 6/445/446/482 |
3799 | lock-and-lock-rubber-gloves-39cm-pink | 6/445/446/448 |
3800 | lock-and-lock-rubber-gloves-37cm-pink | 6/445/446/448 |
3801 | lock-and-lock-rubber-gloves-32cm-yellow | 6/445/446/448 |
3802 | lock-and-lock-rubber-gloves-26cm-yellow | 6/445/446/448 |
3803 | lock-and-lock-rubber-gloves-35cm-pink | 6/445/446/448 |
3805 | lock-and-lock-microfiber-premium-kitchen-cloth-green | 6/438/454/455/456 |
3806 | lock-and-lock-soft-microfiber-cloth-3pc | 6/438/454/455/456 |