/core/cms.php => loadMenuStruct()
SELECT * FROM xt_menu ORDER BY id ASC
Запрос занял 0.00072 с.
/core/cms.php => getAllComponents()
SELECT id, title, link, config, internal, published, version, system FROM xt_components ORDER BY title
Запрос занял 0.00055 с.
/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.00060 с.
/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.222.111.24' AND status=1 ORDER BY id ASC LIMIT 1
Запрос занял 0.00048 с.
/components/content/frontend.php => getArticle()
SELECT con.*,
cat.title cat_title, cat.id cat_id, cat.NSLeft as leftkey, cat.NSRight as rightkey, cat.modgrp_id,
cat.showtags as showtags, cat.seolink as catseolink, cat.cost, u.nickname as author, u.login as user_login
FROM xt_content con
INNER JOIN xt_category cat ON cat.id = con.category_id
LEFT JOIN xt_users u ON u.id = con.user_id
WHERE con.seolink = 'stati/recepty-i-hitrosti' LIMIT 1
Запрос занял 0.00097 с.
/plugins/p_morecontent/plugin.php => cmsTagLine()
SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='45'
ORDER BY tag DESC
Запрос занял 0.00046 с.
/plugins/p_morecontent/plugin.php => eventGetArticle()
SELECT item_id FROM xt_tags WHERE tag = '' AND item_id<>'45' AND target='content' LIMIT 5
Запрос занял 0.00035 с.
/core/cms.php => get_table()
SELECT group_id FROM xt_content_access WHERE content_type = 'material' AND content_id = '45'
Запрос занял 0.00028 с.
/components/content/frontend.php => setFlag()
UPDATE xt_content SET hits = '15627' WHERE id='45'
Запрос занял 0.00032 с.
/core/cms.php => getFilters()
SELECT * FROM xt_filters WHERE published = 1 ORDER BY id ASC
Запрос занял 0.00050 с.
/core/lib_karma.php => get_fields()
SELECT total_rating, total_votes FROM xt_ratings_total WHERE item_id = '45' AND target='content' ORDER BY id ASC LIMIT 1
Запрос занял 0.00051 с.
/core/lib_tags.php => cmsTagLine()
SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='45'
ORDER BY tag DESC
Запрос занял 0.00033 с.
/components/comments/frontend.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='article' AND c.target_id = '45')
ORDER BY c.pubdate ASC
LIMIT 1000
Запрос занял 0.00156 с.
/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.00119 с.
). Лучше уж ямаховской запастись.
