{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "210",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"rows": 16,
"filtered": 75,
"index_condition": "cscart_seo_names.object_id in (5473,345,56,374,370,5476,382,92) 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)",
"attached_condition": "cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
56 | biotherapy-skincare-soap | 1 |
92 | tea-tree-green-tea-soap | 1 |
345 | biotherapy-black-soap | 1 |
370 | bottled-essential-oils-en | 6 |
374 | essential-oil-kits | 2/10 |
382 | shampoo-cutie-bundles | 23 |
5473 | big-bars-en-5 | 308/232/242 |
5476 | shampoo-bars-en-8 | 1 |