/system/core/core.php => 1314 => cmsCore->connectDB()
Database connection
Время выполнения 0.00057 секунд
/system/core/database.php => 154 => cmsDatabase->connect()
SET `time_zone` = '+03:00'
Время выполнения 0.00012 секунд
/system/core/model.php => 1753 => cmsModel->getItemById()
SELECT i.*, u.nickname as `inviter_nickname`, u.slug as `inviter_slug`, u.is_deleted as `inviter_is_deleted`, u.avatar as `inviter_avatar`, IF(online.date_created IS NOT NULL AND TIMESTAMPDIFF(SECOND, online.date_created, NOW()) <= 180, 1, 0) as `is_online`
FROM cms_users i
LEFT JOIN cms_users as u ON u.id = i.inviter_id
LEFT JOIN cms_sessions_online as online ON online.user_id = i.id
WHERE (i.id = '3689')
LIMIT 1
Время выполнения 0.00090 секунд
/system/controllers/users/model.php => 900 => modelUsers->getFriends()
SELECT i.*, u.id as `id`, u.*, IF(online.date_created IS NOT NULL AND TIMESTAMPDIFF(SECOND, online.date_created, NOW()) <= 180, 1, 0) as `is_online`
FROM cms_users_friends i
INNER JOIN cms_users as u ON u.id = i.friend_id
LEFT JOIN cms_sessions_online as online ON online.user_id = u.id
WHERE (i.user_id = '3689') AND (i.is_mutual = '1')
ORDER BY u.date_log desc
Время выполнения 0.00183 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'anec')
LIMIT 1000
Время выполнения 0.00017 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT SUM(1) as count
FROM cms_con_anec i
WHERE (i.user_id = '3689') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
Время выполнения 0.17292 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'posts')
LIMIT 1000
Время выполнения 0.00226 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT SUM(1) as count
FROM cms_con_posts i
WHERE (i.user_id = '3689') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
Время выполнения 0.00102 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'blogs')
LIMIT 1000
Время выполнения 0.00164 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT SUM(1) as count
FROM cms_con_blogs i
WHERE (i.user_id = '3689') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
Время выполнения 0.00040 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'news')
LIMIT 1000
Время выполнения 0.00058 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT SUM(1) as count
FROM cms_con_news i
WHERE (i.user_id = '3689') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
Время выполнения 0.00042 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'albums')
LIMIT 1000
Время выполнения 0.00016 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT SUM(1) as count
FROM cms_con_albums i
WHERE (i.user_id = '3689') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
Время выполнения 0.00050 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'articles')
LIMIT 1000
Время выполнения 0.00017 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT SUM(1) as count
FROM cms_con_articles i
WHERE (i.user_id = '3689') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
Время выполнения 0.00045 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'board')
LIMIT 1000
Время выполнения 0.00013 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT SUM(1) as count
FROM cms_con_board i
WHERE (i.user_id = '3689') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
Время выполнения 0.00180 секунд
/system/core/permissions.php => 132 => cmsPermissions::getPermissionsData()
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'pages')
LIMIT 1000
Время выполнения 0.00023 секунд
/system/controllers/groups/model.php => 478 => modelGroups->getUserMemberships()
SELECT i.*
FROM cms_groups_members i
WHERE (i.user_id = '0')
LIMIT 1000
Время выполнения 0.00033 секунд
/system/controllers/comments/model.php => 259 => modelComments->getCommentsCount()
SELECT SUM(1) as count
FROM cms_comments i
WHERE (i.user_id = '3689') AND (i.is_deleted IS NULL) AND (i.is_approved = '1')
Время выполнения 0.00257 секунд
/system/controllers/groups/model.php => 226 => modelGroups->getGroupsCount()
SELECT SUM(1) as count
FROM cms_groups i
INNER JOIN cms_groups_members as m ON i.id = m.group_id
WHERE (m.user_id = '3689') AND (i.is_approved = '1')
Время выполнения 0.00210 секунд
/system/controllers/subscriptions/hooks/user_tab_info.php => 9 => onSubscriptionsUserTabInfo->run()
SELECT SUM(1) as count
FROM cms_subscriptions_bind i
WHERE (i.user_id = '3689')
Время выполнения 0.00012 секунд
/system/controllers/forum/model.php => 338 => modelForum->getPostsCount()
SELECT SUM(1) as count
FROM cms_forum_posts i
WHERE (i.is_deleted IS NULL) AND (i.category_id <> '5') AND (i.category_id <> '1008') AND (i.category_id <> '1008') AND (i.user_id = '3689')
Время выполнения 0.00015 секунд
/system/controllers/wall/model.php => 9 => modelWall->getEntriesCount()
SELECT SUM(1) as count
FROM cms_wall_entries i
WHERE (i.profile_id = '3689') AND (i.parent_id = '0') AND (i.profile_type = 'user')
Время выполнения 0.00287 секунд
/system/controllers/wall/model.php => 38 => modelWall->getEntries()
SELECT i.*, COUNT(e.id) as `replies_count`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.is_deleted as `user_is_deleted`, u.groups as `user_groups`, u.avatar as `user_avatar`, IF(online.date_created IS NOT NULL AND TIMESTAMPDIFF(SECOND, online.date_created, NOW()) <= 180, 1, 0) as `is_online`
FROM cms_wall_entries i
LEFT JOIN cms_wall_entries as e ON e.parent_id = i.id
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_sessions_online as online ON online.user_id = u.id
WHERE (i.profile_id = '3689') AND (i.parent_id = '0') AND (i.profile_type = 'user')
GROUP BY i.id
ORDER BY i.date_last_reply desc
LIMIT 0, 15
Время выполнения 0.00152 секунд
