{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "17.57"
},
"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": 39,
"rows_produced_per_join": 39,
"filtered": "100.00",
"cost_info": {
"read_cost": "13.67",
"eval_cost": "3.90",
"prefix_cost": "17.57",
"data_read_per_join": "66K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (99086,99087,99088,99089,99090,99091,99092,99093,99094,99095,99096,99097,99098,99099,99100,99101,99102,99103,99104,99105,99106,99107,99108,99109,99114,99213,99214,99215,99234,99235,99236,99237,99238,99240,99264,99265,99266,99268,99269)) 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 |
|---|---|---|
| 99086 | nbv169-p | 7197/7204/7255 |
| 99087 | nbv171-p | 7197/7204/7255 |
| 99088 | nbv172-p | 7197/7204/7255 |
| 99089 | nbv173-p | 7197/7204/7255 |
| 99090 | nbv174-p | 7197/7204/7255 |
| 99091 | nbv178-p | 7197/7204/7255 |
| 99092 | nbv179-p | 7197/7204/7255 |
| 99093 | nbv180-p | 7197/7204/7255 |
| 99094 | nbv181-p | 7197/7204/7255 |
| 99095 | nbv258-p | 7197/7204/7255 |
| 99096 | nbv259-p | 7197/7204/7255 |
| 99097 | nbv262-p | 7197/7204/7255 |
| 99098 | nbv269-p | 7197/7204/7255 |
| 99099 | nbv279-p | 7197/7204/7255 |
| 99100 | nbv280-p | 7197/7204/7255 |
| 99101 | nbv358-p | 7197/7204/7255 |
| 99102 | nbv362-p | 7197/7204/7255 |
| 99103 | nbv379-p | 7197/7204/7255 |
| 99104 | nbv458-p | 7197/7204/7255 |
| 99105 | nbv459-p | 7197/7204/7255 |
| 99106 | nbv462-p | 7197/7204/7255 |
| 99107 | nbv469-p | 7197/7204/7255 |
| 99108 | nbv479-p | 7197/7204/7255 |
| 99109 | nbv480-p | 7197/7204/7255 |
| 99114 | nca104-p | 7197/7204/7256 |
| 99213 | ncs808-p | 7197/7204/7255 |
| 99214 | ncs809-p | 7197/7204/7256 |
| 99215 | ncs829a-p | 7197/7204/7256 |
| 99234 | ncs884-p | 7197/7204/7256 |
| 99235 | ncs884a-p | 7197/7204/7256 |
| 99236 | ncs884b-p | 7197/7204/7256 |
| 99237 | ncs885-p | 7197/7204/7256 |
| 99238 | ncs885a-p | 7197/7204/7256 |
| 99240 | nct102-p | 7197/7204/7256 |
| 99264 | ncu832-p | 7197/7204/7256 |
| 99265 | ncu842-p | 7197/7204/7256 |
| 99266 | ncu862-p | 7197/7204/7256 |
| 99268 | ncu932-p | 7197/7204/7256 |
| 99269 | ncu942-p | 7197/7204/7256 |