/core/cms.php => loadMenuStruct()
SELECT * FROM xt_menu ORDER BY id ASC
Запрос занял 0.00053 с.
/core/cms.php => getAllComponents()
SELECT id, title, link, config, internal, published, version, system FROM xt_components ORDER BY title
Запрос занял 0.00038 с.
/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.00031 с.
/core/classes/user.class.php => get_fields()
SELECT id, access FROM xt_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1
Запрос занял 0.00017 с.
/core/classes/user.class.php => get_fields()
SELECT int_num, int_period, autodelete, id, status, bandate, user_id, cause FROM xt_banlist WHERE ip = '3.145.60.166' AND status=1 ORDER BY id ASC LIMIT 1
Запрос занял 0.00022 с.
/components/forum/model.php => get_fields()
SELECT t.*, f.NSLeft, f.NSRight FROM xt_forum_threads t
INNER JOIN xt_forums f ON f.id = t.forum_id WHERE t.id = '85' ORDER BY id ASC LIMIT 1
Запрос занял 0.00060 с.
/core/classes/db.class.php => get_table()
SELECT id, title, access_list, moder_list FROM xt_forums WHERE NSLeft <= 4 AND NSRight >= 5 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft
Запрос занял 0.00024 с.
/components/forum/frontend.php => setFlag()
UPDATE xt_forum_threads SET hits = '27022' WHERE id='85'
Запрос занял 0.00022 с.
/components/forum/frontend.php => getPosts()
SELECT p.id, p.thread_id, p.user_id, p.pubdate, p.editdate, p.edittimes, p.rating, p.attach_count, p.content_html, p.pinned,
u.nickname, u.login, u.is_deleted, u.logdate, u.status,
up.imageurl, up.signature_html, up.city, up.karma, g.access as group_access, g.is_admin
FROM xt_forum_posts p
LEFT JOIN xt_users u ON u.id = p.user_id
LEFT JOIN xt_user_profiles up ON up.user_id = u.id
LEFT JOIN xt_user_groups g ON u.group_id = g.id
WHERE 1=1
AND (p.thread_id = '85')
ORDER BY p.pinned DESC, p.pubdate ASC
LIMIT 75, 15
Запрос занял 0.00244 с.
/components/forum/model.php => rows_count()
SELECT 1 FROM xt_forum_posts WHERE user_id = '348'
Запрос занял 0.00038 с.
/core/classes/user.class.php => get_table()
SELECT * FROM xt_user_awards WHERE user_id = '348'
Запрос занял 0.00026 с.
/components/forum/model.php => rows_count()
SELECT 1 FROM xt_forum_posts WHERE user_id = '67'
Запрос занял 0.00097 с.
/core/classes/user.class.php => get_table()
SELECT * FROM xt_user_awards WHERE user_id = '67'
Запрос занял 0.00018 с.
/components/forum/frontend.php => getForums()
SELECT f.*, cat.title as cat_title, cat.seolink as cat_seolink, cat.id as cat_id
FROM xt_forums f
LEFT JOIN xt_forum_cats cat ON cat.id = f.category_id
WHERE f.parent_id > 0 AND cat.published = 1 AND f.published = 1
ORDER BY cat.ordering, f.NSLeft
LIMIT 1000
Запрос занял 0.00105 с.
/components/forum/frontend.php => get_fields()
SELECT id, title FROM xt_forum_threads WHERE id < '85' AND forum_id = '1007' ORDER BY id DESC LIMIT 1
Запрос занял 0.00035 с.
/components/forum/frontend.php => get_fields()
SELECT id, title FROM xt_forum_threads WHERE id > '85' AND forum_id = '1007' ORDER BY id ASC LIMIT 1
Запрос занял 0.00023 с.
/components/forum/model.php => get_fields()
SELECT * FROM xt_forum_polls WHERE thread_id = '85' ORDER BY id ASC LIMIT 1
Запрос занял 0.00032 с.
/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 (46, 0)
WHERE m.published = 1 AND (m.is_strict_bind = 0)
ORDER BY m.ordering ASC
Запрос занял 0.00064 с.
( поставил его сразу после того вонючего случая).
