{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "13.52"
},
"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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "10.52",
"eval_cost": "3.00",
"prefix_cost": "13.52",
"data_read_per_join": "50K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (97266,97267,97268,97269,97270,97271,97272,97273,97274,97275,97276,97277,97278,97279,97280,97281,97282,97283,97284,97285,97286,97287,97288,97289,97290,97291,97292,97293,97294,97295)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 97266 | bab055pgs-m | 7195/7254 |
| 97267 | bab055r-p | 7195/7254 |
| 97268 | bab055rs-m | 7195/7254 |
| 97269 | bab055s-m | 7195/7254 |
| 97270 | bab056-p | 7195/7254 |
| 97271 | bab056s-m | 7195/7254 |
| 97272 | bab057-p | 7195/7254 |
| 97273 | bab057s-m | 7195/7254 |
| 97274 | bab058-p | 7195/7254 |
| 97275 | bab058s-m | 7195/7254 |
| 97276 | bab062-p | 7195/7254 |
| 97277 | bab062b-p | 7195/7254 |
| 97278 | bab062bs-m | 7195/7254 |
| 97279 | bab062f-p | 7195/7254 |
| 97280 | bab062fs-m | 7195/7254 |
| 97281 | bab062gm-p | 7195/7254 |
| 97282 | bab062gms-m | 7195/7254 |
| 97283 | bab062ig-p | 7195/7254 |
| 97284 | bab062igs-m | 7195/7254 |
| 97285 | bab062kg-p | 7195/7254 |
| 97286 | bab062kgs-m | 7195/7254 |
| 97287 | bab062m-p | 7195/7254 |
| 97288 | bab062ms-m | 7195/7254 |
| 97289 | bab062mw-p | 7195/7254 |
| 97290 | bab062mws-m | 7195/7254 |
| 97291 | bab062pg-p | 7195/7254 |
| 97292 | bab062pgs-m | 7195/7254 |
| 97293 | bab062r-p | 7195/7254 |
| 97294 | bab062rs-m | 7195/7254 |
| 97295 | bab062s-m | 7195/7254 |