/system/core/core.php => 1314 => cmsCore->connectDB()
Database connection
Время выполнения
0.00028
секунд
/system/core/database.php => 154 => cmsDatabase->connect()
SET `time_zone` = '+03:00'
Время выполнения
0.00006
секунд
/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 = '113')
LIMIT 1
Время выполнения
0.00039
секунд
/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 = '113') 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.00006
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_anec i
WHERE (i.user_id = '113') 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.15781
секунд
/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.00009
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_posts i
WHERE (i.user_id = '113') 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 = 'blogs')
LIMIT 1000
Время выполнения
0.00008
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_blogs i
WHERE (i.user_id = '113') 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 = 'news')
LIMIT 1000
Время выполнения
0.00004
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_news i
WHERE (i.user_id = '113') 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.00014
секунд
/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 = '113') 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.00004
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_articles i
WHERE (i.user_id = '113') 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.00012
секунд
/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.00005
секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_board i
WHERE (i.user_id = '113') 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 = 'pages')
LIMIT 1000
Время выполнения
0.00004
секунд
/system/controllers/wall/model.php => 9 => modelWall->getEntriesCount()
SELECT COUNT( i.id ) as count
FROM cms_wall_entries i
WHERE (i.profile_id = '113') AND (i.parent_id = '0') AND (i.profile_type = 'user')
Время выполнения
0.00066
секунд
/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 = '113') 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.00064
секунд
/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.00008
секунд
