{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "dispatch",
"key_length": "210",
"used_key_parts": [
"dispatch",
"object_id",
"type",
"lang_code",
"company_id"
],
"rows": 24,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (60899,64363,64355,60980,63513,61698,61490,60979,62975,61699,64854,61620) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 60899 | outback-gooseneck-light | 1887/1896/1897 |
| 60979 | union-gooseneck-double-vanity-light | 1887/1896/1902 |
| 60980 | wilcox-gooseneck-double-vanity-light | 1887/1896/1902 |
| 61490 | the-fluted-shade-gooseneck-light | 1887/1896/1897 |
| 61620 | primary-2-light-schoolhouse-vanity-light | 1887/1896/1902 |
| 61698 | tuscany-gooseneck-light | 1887/1896/1897 |
| 61699 | chateau-gooseneck-light | 1887/1896/1897 |
| 62975 | kao-wall-sconce | 1887/1896/1899 |
| 63513 | downtown-minimalist-adjustable-sconce | 1887/1896/1899 |
| 64355 | downtown-swing-arm-plug-in-sconce | 1887/1896/1900 |
| 64363 | the-bullet-flush-mount-led-sign-light | 1920/1927/1931 |
| 64854 | lovell-plug-in-wall-sconce | 1887/1896/1900 |