{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "10.82"
},
"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": 24,
"rows_produced_per_join": 24,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.42",
"eval_cost": "2.40",
"prefix_cost": "10.82",
"data_read_per_join": "40K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (101311,101312,101313,101314,101315,101316,101317,101318,101319,101320,101321,101322,101323,101324,101325,101326,101327,101328,101329,101330,101331,101332,101333,101334)) 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 |
|---|---|---|
| 101311 | ffhr1804l | 7170/7200 |
| 101312 | ffhr1804r | 7170/7200 |
| 101313 | ffhr1805l | 7170/7200 |
| 101314 | ffhr1805r | 7170/7200 |
| 101315 | ffhr1806l | 7170/7200 |
| 101316 | ffhr1806r | 7170/7200 |
| 101317 | ffhr1807l | 7170/7200 |
| 101318 | ffhr1807r | 7170/7200 |
| 101319 | ffhr1808l | 7170/7200 |
| 101320 | ffhr1808r | 7170/7200 |
| 101321 | ffhr1809l | 7170/7200 |
| 101322 | ffhr1809r | 7170/7200 |
| 101323 | ffhr1810l | 7170/7200 |
| 101324 | ffhr1810r | 7170/7200 |
| 101325 | ffhr1811l | 7170/7200 |
| 101326 | ffhr1811r | 7170/7200 |
| 101327 | ffhr1812l | 7170/7200 |
| 101328 | ffhr1812r | 7170/7200 |
| 101329 | ffhr1813 | 7170/7200 |
| 101330 | ffhr1814 | 7170/7200 |
| 101331 | ffhr1815 | 7170/7200 |
| 101332 | ffhr1816 | 7170/7200 |
| 101333 | ffhr3101 | 7170/7200 |
| 101334 | ffhr3102 | 7170/7200 |