/system/core/core.php => 1314 => cmsCore->connectDB()
Database connection
Время выполнения 0.00111 секунд
/system/core/database.php => 154 => cmsDatabase->connect()
SET `time_zone` = '+03:00'
Время выполнения 0.00016 секунд
/system/core/model.php => 1758 => cmsModel->getItemByField()
SELECT i.*, IF(t.id IS NULL AND i.is_approved < 1, 1, NULL) as `is_draft`, t.is_new_item, f.title as `folder_title`, 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`
FROM cms_con_blogs i
LEFT JOIN cms_moderators_tasks as t ON t.item_id = i.id AND t.ctype_name = 'blogs'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.slug = '250-opjat')
LIMIT 1
Время выполнения 0.00184 секунд
/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 => 595 => modelContent->getContentFields()
SELECT i.*
FROM cms_con_blogs_fields i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
Время выполнения 0.00020 секунд
/system/controllers/content/model.php => 1360 => modelContent->getContentTypeChilds()
SELECT i.*, c.title as `child_title`, c.labels as `child_labels`, c.name as `child_ctype_name`
FROM cms_content_relations i
LEFT JOIN cms_content_types as c ON c.id = i.child_ctype_id
WHERE (i.ctype_id = '12')
ORDER BY i.ordering asc
Время выполнения 0.00014 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_posts i
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.parent_item_id = 250 AND r.child_ctype_id = 6 AND r.child_item_id = i.id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
Время выполнения 0.01214 секунд
/system/controllers/content/model.php => 595 => modelContent->getContentFields()
SELECT i.*
FROM cms_con_posts_fields i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
LIMIT 1000
Время выполнения 0.00104 секунд
/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.00028 секунд
/system/controllers/content/model.php => 2469 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) as count
FROM cms_con_posts i
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.parent_item_id = 250 AND r.child_ctype_id = 6 AND r.child_item_id = i.id
WHERE (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) AND (i.rating > '-20')
Время выполнения 0.00516 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.*, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_posts i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.parent_item_id = 250 AND r.child_ctype_id = 6 AND r.child_item_id = i.id
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (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) AND (i.rating > '-20')
ORDER BY i.date_pub desc
LIMIT 0, 15
Время выполнения 0.11279 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 27063 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00343 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 27049 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00627 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 27046 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00345 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 26972 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00376 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 26558 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.01968 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 26503 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00466 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 26472 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00367 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 22791 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00205 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 22504 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00340 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 21963 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00394 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 21941 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.01312 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 21940 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00338 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 21921 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.01055 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 21908 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00586 секунд
/system/controllers/content/model.php => 2538 => modelContent->getContentItems()
SELECT i.id as `id`, i.user_id as `user_id`, i.title as `title`, i.slug as `slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.avatar as `user_avatar`, u.groups as `user_groups`, f.title as `folder_title`
FROM cms_con_blogs i
FORCE INDEX (date_pub)
INNER JOIN cms_content_relations_bind as r ON r.parent_ctype_id = 12 AND r.child_item_id = 21849 AND r.child_ctype_id =6 AND r.parent_item_id = i.id AND r.target_controller = 'content'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 1000
Время выполнения 0.00227 секунд
/system/controllers/content/model.php => 595 => modelContent->getContentFields()
SELECT i.*
FROM cms_con_posts_fields i
WHERE (i.type IN ('text','html')) AND (i.is_enabled = '1')
ORDER BY i.ordering
LIMIT 1000
Время выполнения 0.00011 секунд
/system/controllers/comments/model.php => 259 => modelComments->getCommentsCount()
SELECT COUNT( i.id ) as count
FROM cms_comments i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'blogs') AND (i.target_id = '250') AND (i.is_approved = '1')
Время выполнения 0.00064 секунд
/system/controllers/comments/model.php => 296 => modelComments->getComments()
SELECT i.*, r.score as `is_rated`, 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_comments i
LEFT JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_sessions_online as online ON online.user_id = u.id
LEFT JOIN cms_comments_rating as r ON r.comment_id = i.id AND r.user_id='0'
WHERE (i.target_controller = 'content') AND (i.target_subject = 'blogs') AND (i.target_id = '250') AND (i.is_approved = '1')
ORDER BY i.ordering
LIMIT 1000
Время выполнения 0.00058 секунд
/system/controllers/comments/model.php => 370 => modelComments->getTracking()
SELECT i.*
FROM cms_comments_tracks i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'blogs') AND (i.target_id = '250') AND (i.user_id = '0')
LIMIT 1
Время выполнения 0.00040 секунд
/system/controllers/comments/model.php => 499 => modelComments->isRssFeedEnable()
SELECT i.is_enabled as is_enabled
FROM cms_rss_feeds i
WHERE (i.ctype_name = 'comments')
LIMIT 1
Время выполнения 0.00007 секунд
/system/core/model.php => 1753 => cmsModel->getItemById()
SELECT i.*
FROM cms_wysiwygs_presets i
WHERE (i.id = '4')
LIMIT 1
Время выполнения 0.00007 секунд
/system/controllers/rating/model.php => 86 => modelRating->getVotesCount()
SELECT COUNT( i.id ) as count
FROM cms_rating_log i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'blogs') AND (i.target_id = '250')
Время выполнения 0.00107 секунд
/system/core/model.php => 1758 => cmsModel->getItemByField()
SELECT i.*
FROM cms_amp_pages i
WHERE (i.ctype_name = 'blogs')
LIMIT 1
Время выполнения 0.00123 секунд
/system/controllers/content/model.php => 2734 => modelContent->incrementHitsCounter()
UPDATE cms_con_blogs i
SET i.hits_count = i.hits_count + 1
WHERE (i.id = '250')
Время выполнения 0.04437 секунд
/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'))
ORDER BY i.page_id, i.position, i.ordering
LIMIT 1000
Время выполнения 0.00013 секунд