{
"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 '%743%' 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 |
---|---|---|
732 | 743 | |
743 | 744 | |
743 | 745 | |
743 | 746 | |
743 | 747 | |
743 | 748 | |
743 | 749 | |
743 | 750 | |
743 | 751 | |
743 | 752 | |
743 | 753 | |
743 | 754 | |
743 | 755 | |
743 | 756 | |
743 | 757 | |
743 | 758 | |
743 | 759 | |
743 | 760 | |
743 | 761 | |
743 | 762 | |
743 | 763 | |
743 | 764 | |
743 | 765 | |
743 | 766 | |
743 | 767 | |
743 | 768 | |
743 | 769 | |
743 | 770 | |
743 | 771 | |
743 | 772 | |
743 | 773 | |
743 | 774 | |
775 | 1294 |