/system/core/core.php => 1314 => cmsCore->connectDB()
Database connection
Время выполнения 0.00049 секунд
/system/core/database.php => 154 => cmsDatabase->connect()
SET `time_zone` = '+03:00'
Время выполнения 0.00014 секунд
/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 = '3864')
LIMIT 1
Время выполнения 0.00047 секунд
/system/controllers/content/model.php => 595 => modelContent->getContentFields()
SELECT i.*
FROM cms_users_fields i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
LIMIT 1000
Время выполнения 0.00011 секунд
/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 = '3864') AND (i.is_mutual = '1')
ORDER BY u.date_log desc
Время выполнения 0.00101 секунд
/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.00007 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_anec i
WHERE (i.user_id = '3864') 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.15369 секунд
/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.00013 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_posts i
WHERE (i.user_id = '3864') 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.00080 секунд
/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.00220 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_blogs i
WHERE (i.user_id = '3864') 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.00034 секунд
/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.00019 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_news i
WHERE (i.user_id = '3864') 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.00011 секунд
/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.00007 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_albums i
WHERE (i.user_id = '3864') 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.00005 секунд
/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.00006 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_articles i
WHERE (i.user_id = '3864') 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.00007 секунд
/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.00008 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_board i
WHERE (i.user_id = '3864') 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.00007 секунд
/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.00011 секунд
/system/controllers/comments/model.php => 259 => modelComments->getCommentsCount()
SELECT COUNT( i.id ) as count
FROM cms_comments i
WHERE (i.user_id = '3864') AND (i.is_deleted IS NULL) AND (i.is_approved = '1')
Время выполнения 0.00348 секунд
/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 = '3864') AND (i.is_approved = '1')
Время выполнения 0.00017 секунд
/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 = '3864')
Время выполнения 0.00048 секунд
/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 = '3864')
Время выполнения 0.00012 секунд
/system/controllers/wall/model.php => 9 => modelWall->getEntriesCount()
SELECT COUNT( i.id ) as count
FROM cms_wall_entries i
WHERE (i.profile_id = '3864') AND (i.parent_id = '0') AND (i.profile_type = 'user')
Время выполнения 0.00243 секунд
/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 = '3864') 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.00097 секунд
