With permissions: +----+-------------+---------------------------+--------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+-------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------------------+--------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+-------+----------------------------------------------+ | 1 | SIMPLE | ezcontentobject_tree | range | PRIMARY,ezcontentobject_tree_path,ezcontentobject_tree_co_id | ezcontentobject_tree_path | 767 | NULL | 1 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | ezcontentobject | eq_ref | PRIMARY,ezcontentobject_status,ezcontentobject_classid,ezcontentobject_currentversion | PRIMARY | 4 | mydb.ezcontentobject_tree.contentobject_id | 1 | Using where | | 1 | SIMPLE | ezkeyword | index | PRIMARY | ezkeyword_keyword | 768 | NULL | 27834 | Using index | | 1 | SIMPLE | ezkeyword_attribute_link | ref | ezkeyword_attr_link_kid_oaid,ezkeyword_attr_link_keyword_id | ezkeyword_attr_link_keyword_id | 4 | mydb.ezkeyword.id | 1 | | | 1 | SIMPLE | ezcontentobject_attribute | eq_ref | PRIMARY,ezcontentobject_attribute_contentobject_id,ezcontentobject_attribute_co_id_ver_lang_code,ezcontentobject_attr_id | PRIMARY | 8 | mydb.ezkeyword_attribute_link.objectattribute_id,mydb.ezcontentobject.current_version | 1 | Using where | +----+-------------+---------------------------+--------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+-------+----------------------------------------------+ 5 rows in set (0.00 sec) Without permissions: +----+-------------+---------------------------+--------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+-------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------------------+--------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+-------+----------------------------------------------+ | 1 | SIMPLE | ezcontentobject_tree | range | PRIMARY,ezcontentobject_tree_path,ezcontentobject_tree_co_id | ezcontentobject_tree_path | 767 | NULL | 1 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | ezcontentobject | eq_ref | PRIMARY,ezcontentobject_status,ezcontentobject_classid,ezcontentobject_currentversion | PRIMARY | 4 | mydb.ezcontentobject_tree.contentobject_id | 1 | Using where | | 1 | SIMPLE | ezkeyword | index | PRIMARY | ezkeyword_keyword | 768 | NULL | 27834 | Using index | | 1 | SIMPLE | ezkeyword_attribute_link | ref | ezkeyword_attr_link_kid_oaid,ezkeyword_attr_link_keyword_id | ezkeyword_attr_link_keyword_id | 4 | mydb.ezkeyword.id | 1 | | | 1 | SIMPLE | ezcontentobject_attribute | eq_ref | PRIMARY,ezcontentobject_attribute_contentobject_id,ezcontentobject_attribute_co_id_ver_lang_code,ezcontentobject_attr_id | PRIMARY | 8 | mydb.ezkeyword_attribute_link.objectattribute_id,mydb.ezcontentobject.current_version | 1 | Using where | +----+-------------+---------------------------+--------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+-------+----------------------------------------------+