{
"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 (93314,93315,93316,93317,93318,93319,93320,93321,93322,93323,93324,93325,93326,93327,93328,93329,93330,93331,93332,93333,93334,93335,93336,93337,93896,93897,93898,93899,93900,93901)) 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 |
|---|---|---|
| 93314 | enqsl14 | 7165/7168 |
| 93315 | enqsl14bb | 7165/7168 |
| 93316 | enqsl14bp | 7165/7168 |
| 93317 | enqsp70 | 7165/7168 |
| 93318 | enqsp70bb | 7165/7168 |
| 93319 | enqsp70bp | 7165/7168 |
| 93320 | enqsp80 | 7165/7168 |
| 93321 | enqsp80bb | 7165/7168 |
| 93322 | enqsp80bp | 7165/7168 |
| 93323 | enqsp90 | 7165/7168 |
| 93324 | enqsp90bb | 7165/7168 |
| 93325 | enqsp90bp | 7165/7168 |
| 93326 | enqu108 | 7165/7168 |
| 93327 | enqu108bb | 7165/7168 |
| 93328 | enqu108bp | 7165/7168 |
| 93329 | enqu128 | 7165/7168 |
| 93330 | enqu128bb | 7165/7168 |
| 93331 | enqu128bp | 7165/7168 |
| 93332 | enqu8 | 7165/7168 |
| 93333 | enqu8bb | 7165/7168 |
| 93334 | enqu8bp | 7165/7168 |
| 93335 | enqu9 | 7165/7168 |
| 93336 | enqu9bb | 7165/7168 |
| 93337 | enqu9bp | 7165/7168 |
| 93896 | smbd10-e6 | 7165/7168 |
| 93897 | smbd10bb-e6 | 7165/7168 |
| 93898 | smbd10bp-e6 | 7165/7168 |
| 93899 | smbd11-e6 | 7165/7168 |
| 93900 | smbd12-e6 | 7165/7168 |
| 93901 | smbd7-e6 | 7165/7168 |