{
"query_block": {
"select_id": 1,
"cost": 0.04573149,
"nested_loop": [
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"loops": 1,
"rows": 23,
"cost": 0.04573149,
"filtered": 100,
"attached_condition": "cscart_seo_names.object_id in (13916,13919,13929,13932,13902,13931,13939,13913,13909,13924,13921,13908,13930,13938,13917,13926,13905,13906,13936,13904,13933,13912,13928) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
]
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 13902 | dipliner | 313/357/575 |
| 13904 | precision-liner | 313/357/575 |
| 13905 | matte-liquid-liner | 313/357/575 |
| 13906 | me-racle-liquid-eyeliner | 313/357/575 |
| 13908 | gel-eyeliner | 313/357/575 |
| 13909 | eyeliner-pencil | 313/357/575 |
| 13912 | stay-24hours-pro-longwear-eyeliner | 313/357/575 |
| 13913 | eye-styler-khol-kajal-eyeliner | 313/357/575 |
| 13916 | color-me-eyeliner | 313/357/575 |
| 13917 | matic-eyeshaper | 313/357/575 |
| 13919 | color-me-matic-eyeshaper | 313/357/575 |
| 13921 | eyeshadow-palette-6-shades | 313/357/575 |
| 13924 | eyeshadow-palette-16-shades | 313/357/575 |
| 13926 | matte-eyeshadow-powder | 313/357/575 |
| 13928 | volume-mascara-black | 313/357/575 |
| 13929 | color-me-super-intelligent-mascara-black | 313/357/575 |
| 13930 | luxi-lashes-mascara-black | 313/357/575 |
| 13931 | extreme-waterproof-mascara-black | 313/357/575 |
| 13932 | color-me-ultra-volume-mascara-black | 313/357/575 |
| 13933 | shine-eyeshadow-powder-duo | 313/357/575 |
| 13936 | mono-shine-eyeshadow | 313/357/575 |
| 13938 | luxi-lashes-mascara-eye-styler-pencil-kit | 313/357/575 |
| 13939 | extreme-waterproof-mascara-stay-pencil-kit | 313/357/575 |