/core/cms.php => loadMenuStruct()
SELECT * FROM xt_menu ORDER BY id ASC
Запрос занял 0.00059 с.
/core/cms.php => getAllComponents()
SELECT id, title, link, config, internal, published, version, system FROM xt_components ORDER BY title
Запрос занял 0.00036 с.
/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.00038 с.
/core/classes/user.class.php => get_fields()
SELECT id, access FROM xt_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1
Запрос занял 0.00025 с.
/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.205.26.39' AND status=1 ORDER BY id ASC LIMIT 1
Запрос занял 0.00035 с.
/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 (1, 0)
WHERE m.published = 1
ORDER BY m.ordering ASC
Запрос занял 0.00121 с.
/core/cms.php => getFilters()
SELECT * FROM xt_filters WHERE published = 1 ORDER BY id ASC
Запрос занял 0.00033 с.
/components/search/model.php => getComponentsWithSupportSearch()
SELECT link, title FROM xt_components WHERE internal = 0 AND published = 1
Запрос занял 0.00017 с.
/core/cms.php => get_field()
SELECT cachefile as getfield FROM xt_cache WHERE target='module' AND target_id='19' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 DAY) LIMIT 1
Запрос занял 0.00045 с.
/core/cms.php => get_field()
SELECT cachefile as getfield FROM xt_cache WHERE target='module' AND target_id='19' LIMIT 1
Запрос занял 0.00011 с.
/core/cms.php => get_field()
SELECT cachefile as getfield FROM xt_cache WHERE target='module' AND target_id='62' AND cachedate >= DATE_SUB(NOW(), INTERVAL 3 HOUR) LIMIT 1
Запрос занял 0.00015 с.
/core/cms.php => get_field()
SELECT cachefile as getfield FROM xt_cache WHERE target='module' AND target_id='62' LIMIT 1
Запрос занял 0.00013 с.
/core/classes/page.class.php => mod_whoonline()
SELECT u.id as id, u.nickname as nickname, u.login as login, p.gender as gender
FROM xt_users u
LEFT JOIN xt_user_profiles p ON p.user_id = u.id
WHERE u.is_locked = 0 AND u.is_deleted = 0 AND DATE_FORMAT(u.logdate, '%Y-%m-%d')='2023-12-08'
ORDER BY u.logdate DESC
Запрос занял 0.00900 с.
/core/classes/user.class.php => get_field()
SELECT g.is_admin as getfield FROM xt_users u LEFT JOIN xt_user_groups g ON g.id = u.group_id WHERE u.id = '16471' LIMIT 1
Запрос занял 0.00026 с.
/core/classes/user.class.php => get_field()
SELECT group_id as getfield FROM xt_users WHERE id='16471' LIMIT 1
Запрос занял 0.00025 с.
/core/classes/user.class.php => get_table()
SELECT id FROM xt_category WHERE modgrp_id = '1'
Запрос занял 0.00055 с.
/core/classes/user.class.php => get_field()
SELECT g.is_admin as getfield FROM xt_users u LEFT JOIN xt_user_groups g ON g.id = u.group_id WHERE u.id = '16440' LIMIT 1
Запрос занял 0.00029 с.
/core/classes/user.class.php => get_field()
SELECT group_id as getfield FROM xt_users WHERE id='16440' LIMIT 1
Запрос занял 0.00018 с.
/core/classes/user.class.php => get_table()
SELECT id FROM xt_category WHERE modgrp_id = '1'
Запрос занял 0.00014 с.
/modules/mod_actions/module.php => getActionsLog()
SELECT log.*,
log.pubdate as orig_pubdate,
a.message,
a.name,
u.nickname as user_nickname,
u.login as user_login
FROM xt_actions_log log
LEFT JOIN xt_actions a ON a.id = log.action_id AND a.is_visible = 1
LEFT JOIN xt_users u ON u.id = log.user_id
WHERE 1=1 AND (a.id IN (16,10,29,23,2,17,8,18,7,26,27,19,11,9))
AND (log.is_friends_only = 0)
AND (log.is_users_only = 0)
ORDER BY log.id DESC
LIMIT 10
Запрос занял 0.00162 с.
/core/cms.php => get_field()
SELECT cachefile as getfield FROM xt_cache WHERE target='module' AND target_id='61' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1
Запрос занял 0.00019 с.
/core/cms.php => deleteCache()
DELETE FROM xt_cache WHERE target='module' AND target_id='61'
Запрос занял 0.00024 с.
/modules/mod_comments/module.php => getComments()
SELECT c.*,
IFNULL(u.nickname, 0) as nickname,
IFNULL(u.login, 0) as login,
IFNULL(u.is_deleted, 0) as is_deleted,
IFNULL(p.imageurl, 0) as imageurl,
IFNULL(p.gender, 0) as gender
FROM xt_comments c
LEFT JOIN xt_users u ON u.id = c.user_id
LEFT JOIN xt_user_profiles p ON p.user_id = u.id
WHERE c.published = 1
AND (c.target IN ('faq','catalog','boarditem','blog','article','palbum','photo','userphoto'))
AND (c.user_id > 0)
AND (c.is_hidden=0)
ORDER BY c.pubdate DESC
LIMIT 0, 10
Запрос занял 0.00407 с.
/core/classes/page.class.php => saveCache()
INSERT DELAYED INTO xt_cache (target, target_id, cachedate, cachefile)
VALUES ('module', 61, NOW(), '6abe57b696517b22b528b5daba29d558.html')
Запрос занял 0.00058 с.
/core/cms.php => get_field()
SELECT cachefile as getfield FROM xt_cache WHERE target='module' AND target_id='64' AND cachedate >= DATE_SUB(NOW(), INTERVAL 6 HOUR) LIMIT 1
Запрос занял 0.00016 с.
/core/cms.php => get_field()
SELECT cachefile as getfield FROM xt_cache WHERE target='module' AND target_id='64' LIMIT 1
Запрос занял 0.00011 с.