/system/core/core.php => 1314 => cmsCore->connectDB()
Database connection
Время выполнения 0.00027 секунд
/system/core/database.php => 154 => cmsDatabase->connect()
SET `time_zone` = '+03:00'
Время выполнения 0.00007 секунд
/system/core/controller.php => 291 => cmsController::loadControllers()
SELECT i.id as `id`, i.is_enabled as `is_enabled`, i.options as `options`, i.name as `name`, i.slug as `slug`
FROM cms_controllers i
LIMIT 1000
Время выполнения 0.00028 секунд
/system/controllers/content/model.php => 320 => modelContent->getContentTypesFiltered()
SELECT i.*
FROM cms_content_types i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
LIMIT 1000
Время выполнения 0.00044 секунд
/system/controllers/widgets/model.php => 301 => modelWidgets->getPages()
SELECT i.*
FROM cms_widgets_pages i
LIMIT 1000
Время выполнения 0.00043 секунд
/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 = '2090')
LIMIT 1
Время выполнения 0.00046 секунд
/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.00035 секунд
/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 = '2090') AND (i.is_mutual = '1')
ORDER BY u.date_log desc
Время выполнения 0.00081 секунд
/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.00022 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_anec i
WHERE (i.user_id = '2090') 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.40627 секунд
/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.00029 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_posts i
WHERE (i.user_id = '2090') 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.00053 секунд
/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.00021 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_blogs i
WHERE (i.user_id = '2090') 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.00013 секунд
/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.00025 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_news i
WHERE (i.user_id = '2090') 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.00017 секунд
/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.00020 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_albums i
WHERE (i.user_id = '2090') 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.00013 секунд
/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.00021 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_articles i
WHERE (i.user_id = '2090') 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.00013 секунд
/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.00019 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_board i
WHERE (i.user_id = '2090') 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.00010 секунд
/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.00020 секунд
/system/controllers/groups/model.php => 478 => modelGroups->getUserMemberships()
SELECT i.*
FROM cms_groups_members i
WHERE (i.user_id = '0')
LIMIT 1000
Время выполнения 0.00021 секунд
/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.00034 секунд
/system/controllers/comments/model.php => 259 => modelComments->getCommentsCount()
SELECT COUNT( i.id ) as count
FROM cms_comments i
WHERE (i.user_id = '2090') AND (i.is_deleted IS NULL) AND (i.is_approved = '1')
Время выполнения 0.00127 секунд
/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 = '2090') AND (i.is_approved = '1')
Время выполнения 0.00047 секунд
/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 = '2090')
Время выполнения 0.00023 секунд
/system/controllers/forum/model.php => 109 => modelForum->getCategories()
SELECT i.*
FROM cms_forum_cats i
WHERE (i.is_pub = '1')
LIMIT 1000
Время выполнения 0.00035 секунд
/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 = '2090')
Время выполнения 0.00040 секунд
/system/controllers/wall/model.php => 9 => modelWall->getEntriesCount()
SELECT COUNT( i.id ) as count
FROM cms_wall_entries i
WHERE (i.profile_id = '2090') AND (i.parent_id = '0') AND (i.profile_type = 'user')
Время выполнения 0.00056 секунд
/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 = '2090') 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.00062 секунд
/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.00073 секунд
/system/controllers/menu/model.php => 136 => modelMenu->getMenuItems()
SELECT i.*, menu.name as `menu_name`, COUNT(childs.id) as `childs_count`
FROM cms_menu_items i
LEFT JOIN cms_menu as menu ON menu.id = i.menu_id
LEFT JOIN cms_menu_items as childs ON childs.parent_id = i.id AND childs.is_enabled = 1
WHERE (i.is_enabled = '1')
GROUP BY i.id
ORDER BY i.ordering asc
LIMIT 1000
Время выполнения 0.00086 секунд
/system/core/model.php => 345 => cmsModel->getCategoriesTree()
SELECT i.*
FROM cms_con_anec_cats i
WHERE (i.is_hidden IS NULL) AND (i.parent_id > '0')
ORDER BY i.ns_left
LIMIT 1000
Время выполнения 0.00031 секунд
/system/core/model.php => 345 => cmsModel->getCategoriesTree()
SELECT i.*
FROM cms_con_news_cats i
WHERE (i.is_hidden IS NULL) AND (i.parent_id > '0')
ORDER BY i.ns_left
LIMIT 1000
Время выполнения 0.00020 секунд
/system/controllers/widgets/model.php => 43 => modelWidgets->getLayoutRows()
SELECT i.*, r.nested_position as `nested_position`, r.parent_id as `parent_id`, r.title as `row_title`, r.options as `row_options`, r.class as `row_class`, r.tag as `row_tag`
FROM cms_layout_cols i
INNER JOIN cms_layout_rows as r ON r.id = i.row_id
WHERE (r.template = 'modern')
ORDER BY r.ordering asc, i.ordering asc
LIMIT 1000
Время выполнения 0.00060 секунд
