Habe nun mal die SQL-Statements von Admin-User (bei dem die Kategorien aufgelistet werden) mit denen eines normalen Users (keine Auflistung) verglichen:
Admin
19 Queries Logged
SELECT `data`
FROM `j16_session`
WHERE `session_id` = '274a43a91c5b9b58f35d22d93c500dbc'
SELECT template, s.params
FROM j16_template_styles as s
LEFT JOIN j16_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
SHOW FULL COLUMNS
FROM `j16_content`
[b]SELECT c.id AS id, a.name as asset_name
FROM j16_categories c
INNER JOIN j16_assets a
ON c.asset_id = a.id
WHERE c.extension = 'com_content'
AND c.published = 1[/b]
[...]
User
74 Queries Logged
SELECT `data`
FROM `j16_session`
WHERE `session_id` = '907e9d93e1318ad2ae8e273b76582ca0'
SELECT template, s.params
FROM j16_template_styles as s
LEFT JOIN j16_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
SELECT b.rules
FROM j16_assets AS a
LEFT JOIN j16_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.name = 'com_content'
ORDER BY b.lft
SELECT b.id
FROM j16_user_usergroup_map AS map
LEFT JOIN j16_usergroups AS a
ON a.id = map.group_id
LEFT JOIN j16_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 64
SHOW FULL COLUMNS
FROM `j16_content`
SELECT c.id AS id, a.name as asset_name
FROM j16_categories c
INNER JOIN j16_assets a
ON c.asset_id = a.id
WHERE c.extension = 'com_content'
AND c.published = 1
[...]
Beim normalen User werden einige Statements mehr vor dem Lesen der Kategorien ausgeführt. Gibt es eine Beschreibung der Tabellen usergroup und assets?