/core/cms.php => loadMenuStruct()
SELECT * FROM xt_menu ORDER BY id ASC
Запрос занял 0.00065 с.
/core/cms.php => getAllComponents()
SELECT id, title, link, config, internal, published, version, system FROM xt_components ORDER BY title
Запрос занял 0.00049 с.
/core/cms.php => loadPluginsData()
SELECT p.id, p.plugin, p.config, e.event FROM xt_event_hooks e LEFT JOIN xt_plugins p ON e.plugin_id = p.id WHERE p.published = 1
Запрос занял 0.00050 с.
/core/classes/user.class.php => get_fields()
SELECT id, access FROM xt_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1
Запрос занял 0.00030 с.
/core/classes/user.class.php => get_fields()
SELECT int_num, int_period, autodelete, id, status, bandate, user_id, cause FROM xt_banlist WHERE ip = '18.188.55.184' AND status=1 ORDER BY id ASC LIMIT 1
Запрос занял 0.00034 с.
/core/classes/user.class.php => get_field()
SELECT title as getfield FROM xt_user_groups WHERE id='1' LIMIT 1
Запрос занял 0.00032 с.
/components/users/frontend.php => getUsersCount()
SELECT u.id
FROM xt_users u
INNER JOIN xt_user_profiles p ON p.user_id = u.id
WHERE u.is_locked = 0 AND u.is_deleted = 0
AND (u.group_id = '1')
Запрос занял 0.07476 с.
/components/users/frontend.php => getUsers()
SELECT
u.id,
u.login,
u.nickname,
u.icq,
u.logdate as flogdate,
u.rating,
u.is_deleted as is_deleted,
u.birthdate, u.rating,
u.status as microstatus,
p.city, p.karma, p.imageurl,
p.gender as gender
FROM xt_users u
INNER JOIN xt_user_profiles p ON p.user_id = u.id
WHERE u.is_locked = 0 AND u.is_deleted = 0
AND (u.group_id = '1')
ORDER BY regdate desc
LIMIT 3790, 10
Запрос занял 0.06331 с.
/core/classes/page.class.php => loadModulesForMenuItem()
SELECT m.*, mb.position as mb_position
FROM xt_modules m
INNER JOIN xt_modules_bind mb ON mb.module_id = m.id AND mb.menu_id IN (0, 0)
WHERE m.published = 1 AND (m.is_strict_bind = 0)
ORDER BY m.ordering ASC
Запрос занял 0.00104 с.
