{
"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": 28,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (61446,62843,63852,62839,62841,63853,63854,62840,61448,62845,62847,64947,64849,64850) 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 |
|---|---|---|
| 61446 | insider-2-light-chandelier | 1887/1888/1893 |
| 61448 | enterprise-3-light-chandelier | 1887/1888/1893 |
| 62839 | indy-industrial-multi-light-chandelier | 1887/1888/1893 |
| 62840 | ball-jar-multi-light-chandelier | 1887/1888/1893 |
| 62841 | indy-porcelain-socket-multi-light-chandelier | 1887/1888/1893 |
| 62843 | downtown-minimalist-multi-light-chandelier | 1887/1888/1893 |
| 62845 | the-atomic-topless-multi-light-chandelier | 1887/1888/1893 |
| 62847 | lafayette-multi-light-chandelier | 1887/1888/1893 |
| 63852 | downtown-3-light-pendant-chandelier | 1887/1888/1893 |
| 63853 | downtown-4-light-pendant-chandelier | 1887/1888/1893 |
| 63854 | downtown-5-light-pendant-chandelier | 1887/1888/1893 |
| 64849 | mig-multi-light-pendant | 1887/1888/1893 |
| 64850 | mig-2-light-linear-pendant | 1887/1888/1893 |
| 64947 | downtown-minimalist-wooden-socket-3-light-pendant | 1887/1888/1893 |