/core/cms.php => loadMenuStruct()
SELECT * FROM xt_menu ORDER BY id ASC
Запрос занял 0.00081 с.
/core/cms.php => getAllComponents()
SELECT id, title, link, config, internal, published, version, system FROM xt_components ORDER BY title
Запрос занял 0.00060 с.
/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.00053 с.
/core/classes/user.class.php => get_fields()
SELECT id, access FROM xt_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1
Запрос занял 0.00026 с.
/core/classes/user.class.php => get_fields()
SELECT int_num, int_period, autodelete, id, status, bandate, user_id, cause FROM xt_banlist WHERE ip = '52.14.130.13' AND status=1 ORDER BY id ASC LIMIT 1
Запрос занял 0.00037 с.
/core/classes/db.class.php => get_fields()
SELECT * FROM xt_photo_albums WHERE NSLevel = 0 AND NSDiffer = '' ORDER BY id ASC LIMIT 1
Запрос занял 0.00048 с.
/core/classes/db.class.php => get_fields()
SELECT * FROM xt_photo_albums WHERE id = '1038' ORDER BY id ASC LIMIT 1
Запрос занял 0.00037 с.
/core/classes/db.class.php => get_table()
SELECT id, title, NSLevel FROM xt_photo_albums WHERE NSLeft <= 4 AND NSRight >= 5 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft
Запрос занял 0.00044 с.
/components/photos/frontend.php => getAlbums()
SELECT a.id, a.title, a.description, a.pubdate, a.iconurl, a.thumb1, f.file, IFNULL(COUNT(f.id), 0) as content_count
FROM xt_photo_albums a
LEFT JOIN xt_photo_files f ON f.album_id = a.id AND f.published = 1
WHERE a.NSDiffer='' AND a.parent_id = '1038' AND a.published = 1
GROUP BY a.id
ORDER BY f.pubdate desc
LIMIT 1000
Запрос занял 0.00076 с.
/components/photos/frontend.php => getPhotosCount()
SELECT 1
FROM xt_photo_files f
WHERE f.published = 1
AND (f.album_id = '1038')
Запрос занял 0.00050 с.
/components/photos/frontend.php => getPhotos()
SELECT f.*
FROM xt_photo_files f
WHERE f.published = 1
AND (f.album_id = '1038')
ORDER BY f.pubdate desc
LIMIT 80, 20
Запрос занял 0.00108 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '116' AND published = 1
Запрос занял 0.00042 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '115' AND published = 1
Запрос занял 0.00036 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '114' AND published = 1
Запрос занял 0.00019 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '113' AND published = 1
Запрос занял 0.00017 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '112' AND published = 1
Запрос занял 0.00021 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '109' AND published = 1
Запрос занял 0.00028 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '108' AND published = 1
Запрос занял 0.00025 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '107' AND published = 1
Запрос занял 0.00018 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '106' AND published = 1
Запрос занял 0.00023 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '105' AND published = 1
Запрос занял 0.00026 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '104' AND published = 1
Запрос занял 0.00018 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '103' AND published = 1
Запрос занял 0.00019 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '99' AND published = 1
Запрос занял 0.00021 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '98' AND published = 1
Запрос занял 0.00018 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '97' AND published = 1
Запрос занял 0.00024 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '96' AND published = 1
Запрос занял 0.00027 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '95' AND published = 1
Запрос занял 0.00022 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '94' AND published = 1
Запрос занял 0.00042 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '93' AND published = 1
Запрос занял 0.00025 с.
/core/cms.php => rows_count()
SELECT 1 FROM xt_comments WHERE target = 'club_photo' AND target_id = '92' AND published = 1
Запрос занял 0.00019 с.
/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='palbum' AND c.target_id = '1038')
ORDER BY c.pubdate ASC
LIMIT 1000
Запрос занял 0.00051 с.
/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 (47, 0)
WHERE m.published = 1 AND (m.is_strict_bind = 0)
ORDER BY m.ordering ASC
Запрос занял 0.00221 с.
