{
"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 (92581,92582,92583,92584,92585,92586,92587,92588,92589,92590,92591,92592,93296,93297,93298,93299,93300,93301,93302,93303,93304,93305,93306,93307,93308,93309,93310,93311,93312,93313)) 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 |
|---|---|---|
| 92581 | aqsl17n-e8 | 7165/7168/7177 |
| 92582 | aqsl17nbb-e8 | 7165/7168/7177 |
| 92583 | aqsl17nbp-e8 | 7165/7168/7177 |
| 92584 | aqu10n-e8 | 7165/7168/7176 |
| 92585 | aqu10nbb-e8 | 7165/7168/7176 |
| 92586 | aqu10nbp-e8 | 7165/7168/7176 |
| 92587 | aqu128n-e8 | 7165/7168/7179 |
| 92588 | aqu128nbb-e8 | 7165/7168/7179 |
| 92589 | aqu128nbp-e8 | 7165/7168/7179 |
| 92590 | aqu9n-e8 | 7165/7168/7176 |
| 92591 | aqu9nbb-e8 | 7165/7168/7176 |
| 92592 | aqu9nbp-e8 | 7165/7168/7176 |
| 93296 | enqpd76 | 7165/7168 |
| 93297 | enqpd76bb | 7165/7168 |
| 93298 | enqpd76bp | 7165/7168 |
| 93299 | enqpd80 | 7165/7168 |
| 93300 | enqpd80bb | 7165/7168 |
| 93301 | enqpd80bp | 7165/7168 |
| 93302 | enqpd90 | 7165/7168 |
| 93303 | enqpd90bb | 7165/7168 |
| 93304 | enqpd90bp | 7165/7168 |
| 93305 | enqsl10 | 7165/7168 |
| 93306 | enqsl10bb | 7165/7168 |
| 93307 | enqsl10bp | 7165/7168 |
| 93308 | enqsl11 | 7165/7168 |
| 93309 | enqsl11bb | 7165/7168 |
| 93310 | enqsl11bp | 7165/7168 |
| 93311 | enqsl12 | 7165/7168 |
| 93312 | enqsl12bb | 7165/7168 |
| 93313 | enqsl12bp | 7165/7168 |