{
"query_block": {
"select_id": 1,
"table": {
"table_name": "c",
"access_type": "ALL",
"rows": 654,
"filtered": 100,
"attached_condition": "c.company_id = 0 and c.id_path like '%828%' and c.`status` = 'A'"
},
"table": {
"table_name": "sm",
"access_type": "ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["admin_test.c.category_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(sm.search_phrases <> 'NULL' or c.`level` = (subquery#2)) and trigcond(sm.lang_code = 'ru')"
},
"subqueries": [
{
"query_block": {
"select_id": 2,
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": ["PRIMARY", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
}
}
}
]
}
}
parent_id | search_phrases | category_id |
---|---|---|
799 | 828 | |
828 | 829 | |
828 | 830 | |
828 | 831 | |
828 | 832 | |
828 | 833 | |
828 | 834 | |
828 | 835 | |
828 | 836 | |
828 | 837 | |
828 | 842 | |
828 | 843 | |
828 | 844 | |
828 | 845 | |
828 | 846 | |
828 | 847 | |
828 | 1296 |