/core/cms.php => loadMenuStruct()
SELECT * FROM xt_menu ORDER BY id ASC
Запрос занял 0.00092 с.
/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.00067 с.
/core/classes/user.class.php => get_fields()
SELECT id, access FROM xt_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1
Запрос занял 0.00048 с.
/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.118.9.7' AND status=1 ORDER BY id ASC LIMIT 1
Запрос занял 0.00062 с.
/core/classes/blog.class.php => get_fields()
SELECT * FROM xt_blogs WHERE seolink = 'yamaha-tt-600-r-belgarda-2001' AND owner = 'user' ORDER BY id ASC LIMIT 1
Запрос занял 0.00072 с.
/core/classes/user.class.php => get_field()
SELECT gender as getfield FROM xt_user_profiles WHERE user_id = '5836' LIMIT 1
Запрос занял 0.00050 с.
/core/classes/user.class.php => get_fields()
SELECT nickname, login FROM xt_users WHERE id = '5836' ORDER BY id ASC LIMIT 1
Запрос занял 0.00039 с.
/components/blogs/frontend.php => getPostsCount()
SELECT 1
FROM xt_blog_posts p
INNER JOIN xt_blogs b ON b.id = p.blog_id
WHERE p.published = 1 AND b.owner = 'user'
AND (p.blog_id = '185')
AND (b.allow_who = 'all')
AND (p.allow_who = 'all')
Запрос занял 0.00063 с.
/components/blogs/frontend.php => getPosts()
SELECT p.*,
u.nickname as author, u.login, u.is_deleted,
b.allow_who as blog_allow_who,
b.seolink as bloglink,
b.title as blog_title,
b.owner as owner
FROM xt_blog_posts p
INNER JOIN xt_blogs b ON b.id = p.blog_id
LEFT JOIN xt_users u ON u.id = p.user_id
WHERE p.published = 1 AND b.owner = 'user'
AND (p.blog_id = '185')
AND (b.allow_who = 'all')
AND (p.allow_who = 'all')
ORDER BY p.pubdate DESC
LIMIT 0, 10
Запрос занял 0.00078 с.
/core/classes/blog.class.php => cmsTagLine()
SELECT tag
FROM xt_tags
WHERE target='blogpost' AND item_id='23825'
ORDER BY tag DESC
Запрос занял 0.00062 с.
/core/classes/blog.class.php => cmsTagLine()
SELECT tag
FROM xt_tags
WHERE target='blogpost' AND item_id='23824'
ORDER BY tag DESC
Запрос занял 0.00040 с.
/core/classes/blog.class.php => cmsTagLine()
SELECT tag
FROM xt_tags
WHERE target='blogpost' AND item_id='23823'
ORDER BY tag DESC
Запрос занял 0.00036 с.
/core/classes/blog.class.php => cmsTagLine()
SELECT tag
FROM xt_tags
WHERE target='blogpost' AND item_id='23822'
ORDER BY tag DESC
Запрос занял 0.00035 с.
/components/blogs/frontend.php => getBlogCats()
SELECT cat.*, IFNULL(COUNT(p.id), 0) as post_count
FROM xt_blog_cats cat
LEFT JOIN xt_blog_posts p ON p.cat_id = cat.id AND p.published = 1
WHERE cat.blog_id = '185'
GROUP BY cat.id
Запрос занял 0.00064 с.
/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.00140 с.
