/system/core/core.php => 1314 => cmsCore->connectDB()
Database connection
Время выполнения
0.00030
секунд
/system/core/database.php => 154 => cmsDatabase->connect()
SET `time_zone` = '+03:00'
Время выполнения
0.00005
секунд
/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 = '2155')
LIMIT 1
Время выполнения
0.00038
секунд
/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 = '2155') AND (i.is_mutual = '1')
ORDER BY u.date_log desc
Время выполнения
0.00089
секунд
/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.00009
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_anec i
WHERE (i.user_id = '2155') 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.15508
секунд
/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.00019
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_posts i
WHERE (i.user_id = '2155') 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.00070
секунд
/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.00010
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_blogs i
WHERE (i.user_id = '2155') 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.00029
секунд
/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.00005
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_news i
WHERE (i.user_id = '2155') 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.00049
секунд
/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.00005
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_albums i
WHERE (i.user_id = '2155') 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.00005
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_articles i
WHERE (i.user_id = '2155') 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.00028
секунд
/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.00006
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_board i
WHERE (i.user_id = '2155') 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.00020
секунд
/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.00007
секунд
/system/controllers/groups/model.php => 478 => modelGroups->getUserMemberships()
SELECT i.*
FROM cms_groups_members i
WHERE (i.user_id = '0')
LIMIT 1000
Время выполнения
0.00006
секунд
/system/controllers/users/model.php => 1185 => modelUsers->getUsersProfilesTabs()
SELECT i.*
FROM cms_users_tabs i
WHERE (i.is_active = '1')
ORDER BY i.ordering
Время выполнения
0.00006
секунд
/system/controllers/comments/model.php => 259 => modelComments->getCommentsCount()
SELECT COUNT( i.id ) as count
FROM cms_comments i
WHERE (i.user_id = '2155') AND (i.is_deleted IS NULL) AND (i.is_approved = '1')
Время выполнения
0.00042
секунд
/system/controllers/groups/model.php => 226 => modelGroups->getGroupsCount()
SELECT COUNT( i.id ) as count
FROM cms_groups i
INNER JOIN cms_groups_members as m ON i.id = m.group_id
WHERE (m.user_id = '2155') AND (i.is_approved = '1')
Время выполнения
0.00035
секунд
/system/controllers/subscriptions/hooks/user_tab_info.php => 9 => onSubscriptionsUserTabInfo->run()
SELECT COUNT( i.id ) as count
FROM cms_subscriptions_bind i
WHERE (i.user_id = '2155')
Время выполнения
0.00023
секунд
/system/controllers/forum/model.php => 371 => modelForum->getPostsCount()
SELECT COUNT( i.id ) 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 = '2155')
Время выполнения
0.00041
секунд
/system/controllers/wall/model.php => 9 => modelWall->getEntriesCount()
SELECT COUNT( i.id ) as count
FROM cms_wall_entries i
WHERE (i.profile_id = '2155') AND (i.parent_id = '0') AND (i.profile_type = 'user')
Время выполнения
0.00115
секунд
/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 = '2155') 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.00103
секунд
/system/controllers/widgets/model.php => 738 => modelWidgets->getWidgetsForPages()
SELECT i.*, w.controller as `controller`, w.name as `name`, wb.*, i.id as `id`
FROM cms_widgets_bind_pages i
FORCE INDEX (page_id)
INNER JOIN cms_widgets_bind as wb ON wb.id = i.bind_id
INNER JOIN cms_widgets as w ON w.id = wb.widget_id
WHERE (i.template = 'modern') AND (i.is_enabled = '1') AND (i.page_id IN ('0','101'))
ORDER BY i.page_id, i.position, i.ordering
LIMIT 1000
Время выполнения
0.00010
секунд