{
"query_block": {
"select_id": 1,
"cost": 0.06270008,
"nested_loop": [
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "dispatch",
"key_length": "194",
"used_key_parts": ["dispatch"],
"ref": ["const"],
"loops": 1,
"rows": 54,
"cost": 0.06270008,
"filtered": 59.25925827,
"index_condition": "cscart_seo_names.object_id in (18508,18509,18510,18511,18513,18514,18515,18516,18517,18518,18519,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18532,18533,18534,19936,19937,19938,19939,19940,19941) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
]
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 18508 | chaz-kangeroo-hoodie | 317/319 |
| 18509 | chaz-kangeroo-hoodie-en-5 | 317/319 |
| 18510 | chaz-kangeroo-hoodie-en-10 | 317/319 |
| 18511 | chaz-kangeroo-hoodie-en-4 | 317/319 |
| 18513 | chaz-kangeroo-hoodie-en-2 | 317/319 |
| 18514 | chaz-kangeroo-hoodie-en-8 | 317/319 |
| 18516 | chaz-kangeroo-hoodie-en-3 | 317/319 |
| 18517 | chaz-kangeroo-hoodie-en-6 | 317/319 |
| 18520 | chaz-kangeroo-hoodie-en | 317/319 |
| 18528 | chaz-kangeroo-hoodie-en-9 | 317/319 |
| 18530 | chaz-kangeroo-hoodie-en-7 | 317/319 |
| 19936 | test-product-101 | 317/325/484 |
| 19937 | test-product-101-en | 317/325/484 |
| 19938 | test-product-101-en-2 | 317/325/484 |
| 19939 | test-product-101-en-3 | 317/325/484 |
| 19940 | test-product-101-en-4 | 317/325/484 |
| 19941 | test-product-101-en-5 | 317/325/484 |