/system/core/core.php => 1314 => cmsCore->connectDB()
Database connection
Время выполнения 0.00035 секунд
/system/core/database.php => 154 => cmsDatabase->connect()
SET `time_zone` = '+03:00'
Время выполнения 0.00007 секунд
/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 = '147-proehali')
LIMIT 1
Время выполнения 0.00079 секунд
/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.00011 секунд
/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.00010 секунд
/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.00008 секунд
/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 = 147 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.00635 секунд
/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.00070 секунд
/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 = 147 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.00346 секунд
/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 = 147 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.09139 секунд
/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 = 22118 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.00222 секунд
/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 = 20375 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.00398 секунд
/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 = 20193 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.00184 секунд
/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 = 19856 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.00267 секунд
/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 = 19732 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.00195 секунд
/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 = 19670 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.00560 секунд
/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 = 19448 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.00680 секунд
/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 = 19447 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.00551 секунд
/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 = 19255 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.00281 секунд
/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 = 19216 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.00693 секунд
/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 = 19149 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.00215 секунд
/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 = 18771 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.00357 секунд
/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 = 18619 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.00201 секунд
/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 = 18373 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.00321 секунд
/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 = 18154 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.00288 секунд
/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 = '147') AND (i.is_approved = '1')
Время выполнения 0.00147 секунд
/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 = '147') AND (i.is_approved = '1')
ORDER BY i.ordering
LIMIT 1000
Время выполнения 0.00378 секунд
/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 = '147') AND (i.user_id = '0')
LIMIT 1
Время выполнения 0.00065 секунд
/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.00783 секунд
/system/core/model.php => 1753 => cmsModel->getItemById()
SELECT i.*
FROM cms_wysiwygs_presets i
WHERE (i.id = '4')
LIMIT 1
Время выполнения 0.00029 секунд
/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 = '147')
Время выполнения 0.00273 секунд
/system/core/model.php => 1758 => cmsModel->getItemByField()
SELECT i.*
FROM cms_amp_pages i
WHERE (i.ctype_name = 'blogs')
LIMIT 1
Время выполнения 0.00016 секунд
/system/controllers/content/model.php => 2734 => modelContent->incrementHitsCounter()
UPDATE cms_con_blogs i
SET i.hits_count = i.hits_count + 1
WHERE (i.id = '147')
Время выполнения 0.06081 секунд