{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "38.41"
},
"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": 16,
"rows_produced_per_join": 16,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (2988,2992,2997,3002,3007,3012,2802,2807,2808,2384,2385,2386,2388,2389,2390,2391)) 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": "35.21",
"eval_cost": "3.20",
"prefix_cost": "38.41",
"data_read_per_join": "27K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2384 | y-and-d-bodycon-workwear-dress-for-women | 12/13/14/16 |
2385 | y-and-d-bodycon-dress-for-women-workwear-dress | 12/13/14/16 |
2386 | y-and-d-bodycon-dress-for-women | 12/13/14/16 |
2388 | y-and-d-workwear-bodycon-dress-for-women-en | 12/13/14/16 |
2389 | y-and-d-v-neck-maxi-long-dress-for-women | 12/13/14/16 |
2390 | y-and-d-evening-dress-deep-v-long-sleeve-skirt | 12/13/14/16 |
2391 | y-and-d-v-neck-long-sleeve-elegant-dress | 12/13/14/16 |
2802 | y-and-d-fashion-floral-pattern-maxi-long-dress-for-women-black-color | 12/13/14/16 |
2807 | womens-aline-dress-v-neck-short-knee-sleeve-floral-pattern-pastoral-style-midi-blue-dress | 12/13/14/16 |
2808 | womens-aline-dress-round-neck-half-sleeve-hollow-out-decor-floral-pattern-lace-mid-calf-dress | 12/13/14/16 |
2988 | y-and-d-maxi-round-neck-solid-damask-pattern-three-quarter-sleeve-straight-dress-for-women-white-color | 12/13/14/16 |
2992 | y-and-d-mid-calf-shirt-neck-floral-pattern-full-sleeve-dress-for-women-multi-color | 12/13/14/16 |
2997 | y-and-d-maxi-shirt-neck-animal-print-pattern-full-sleeve-straight-dress-for-women-multi-color | 12/13/14/16 |
3002 | y-and-d-maxi-length-shirt-neck-print-pattern-full-sleeve-casual-dress-for-women-multi-color | 12/13/14/16 |
3007 | y-and-d-mid-calf-round-neck-solid-pattern-full-sleeve-dress-for-women-black-color | 12/13/14/16 |
3012 | y-and-d-mid-calf-shirt-neck-solid-pattern-full-sleeve-dress-for-women-gold-color-en | 12/13/14/16 |