{
"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 (97296,97297,97298,97299,97300,97301,97302,97303,97304,97305,97306,97307,97308,97309,97310,97311,97312,97313,97314,97315,97316,97317,97318,97319,97320,97321,97322,97323,97324,97325)) 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 |
|---|---|---|
| 97296 | bab063-p | 7195/7254 |
| 97297 | bab063s-m | 7195/7254 |
| 97298 | bab064-p | 7195/7254 |
| 97299 | bab064b-p | 7195/7254 |
| 97300 | bab064bs-m | 7195/7254 |
| 97301 | bab064f-p | 7195/7254 |
| 97302 | bab064fs-m | 7195/7254 |
| 97303 | bab064gm-p | 7195/7254 |
| 97304 | bab064gms-m | 7195/7254 |
| 97305 | bab064ig-p | 7195/7254 |
| 97306 | bab064igs-m | 7195/7254 |
| 97307 | bab064kg-p | 7195/7254 |
| 97308 | bab064kgs-m | 7195/7254 |
| 97309 | bab064m-p | 7195/7254 |
| 97310 | bab064ms-m | 7195/7254 |
| 97311 | bab064pg-p | 7195/7254 |
| 97312 | bab064pgs-m | 7195/7254 |
| 97313 | bab064r-p | 7195/7254 |
| 97314 | bab064rs-m | 7195/7254 |
| 97315 | bab064s-m | 7195/7254 |
| 97316 | bab070-p | 7195/7254 |
| 97317 | bab070b-p | 7195/7254 |
| 97318 | bab070bs-m | 7195/7254 |
| 97319 | bab070f-p | 7195/7254 |
| 97320 | bab070fs-m | 7195/7254 |
| 97321 | bab070gm-p | 7195/7254 |
| 97322 | bab070gms-m | 7195/7254 |
| 97323 | bab070ig-p | 7195/7254 |
| 97324 | bab070igs-m | 7195/7254 |
| 97325 | bab070kg-p | 7195/7254 |