После лекции для НР-специалистов одна из слушательниц спрашивает у докладчика: - Собеседования отнимают очень много времени. Скажите, как можно максимально быстро определить, что за человек перед тобой - идиот или нормальный? - Конечно. Задайте ему какой-нибудь простейший вопрос. Например: "Известно, что Кук совершил три путешествия, во время одного их них он погиб. Во время какого именно?" - А можно какой-нибудь другой пример? А то у меня в школе было плохо с географией.

/system/core/core.php => 1314 => cmsCore->connectDB()

Database connection

Время выполнения 0.00062 секунд

/system/core/database.php => 154 => cmsDatabase->connect()

SET `time_zone` = '+03:00'

Время выполнения 0.00012 секунд

/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_anec i
LEFT JOIN cms_moderators_tasks as t ON t.item_id = i.id AND t.ctype_name = 'anec'
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 = '168749-posle-lekcii-dlja')
LIMIT 1

Время выполнения 0.00092 секунд

/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.00030 секунд

/system/core/model.php => 1758 => cmsModel->getItemByField()

SELECT i.*
FROM cms_con_anec_cats i
WHERE (i.id = '3')
LIMIT 1

Время выполнения 0.00021 секунд

/system/core/model.php => 400 => cmsModel->getCategoryPath()

SELECT i.*
FROM cms_con_anec_cats i
WHERE (i.ns_left <= '2') AND (i.ns_right >= '3') AND (i.ns_level <= '1') AND (i.ns_level > '0')
ORDER BY i.ns_left

Время выполнения 0.00025 секунд

/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 = '11')
ORDER BY i.ordering asc

Время выполнения 0.00028 секунд

/system/controllers/content/model.php => 1013 => modelContent->getContentProps()

SELECT p.*, c.title as `cat_title`, i.cat_id
FROM cms_con_anec_props_bind i
INNER JOIN cms_con_anec_props as p ON p.id = i.prop_id
INNER JOIN cms_con_anec_cats as c ON c.id = i.cat_id
WHERE (i.cat_id IN ('3'))
ORDER BY i.ordering

Время выполнения 0.00033 секунд

/system/controllers/content/model.php => 1223 => modelContent->getPropsValues()

SELECT i.*
FROM cms_con_anec_props_values i
WHERE (i.item_id = '168749')

Время выполнения 0.00019 секунд

/system/controllers/comments/model.php => 259 => modelComments->getCommentsCount()

SELECT SUM(1) as count
FROM cms_comments i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'anec') AND (i.target_id = '168749') AND (i.is_approved = '1')

Время выполнения 0.00037 секунд

/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 = 'anec') AND (i.target_id = '168749') AND (i.is_approved = '1')
ORDER BY i.ordering
LIMIT 1000

Время выполнения 0.00061 секунд

/system/controllers/comments/model.php => 370 => modelComments->getTracking()

SELECT i.*
FROM cms_comments_tracks i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'anec') AND (i.target_id = '168749') AND (i.user_id = '0')
LIMIT 1

Время выполнения 0.00024 секунд

/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.00019 секунд

/system/core/model.php => 1753 => cmsModel->getItemById()

SELECT i.*
FROM cms_wysiwygs_presets i
WHERE (i.id = '4')
LIMIT 1

Время выполнения 0.00017 секунд

/system/controllers/rating/model.php => 86 => modelRating->getVotesCount()

SELECT SUM(1) as count
FROM cms_rating_log i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'anec') AND (i.target_id = '168749')

Время выполнения 0.00050 секунд

/system/core/model.php => 1758 => cmsModel->getItemByField()

SELECT i.*
FROM cms_amp_pages i
WHERE (i.ctype_name = 'anec')
LIMIT 1

Время выполнения 0.00024 секунд

/system/controllers/content/model.php => 2734 => modelContent->incrementHitsCounter()

UPDATE cms_con_anec i
SET i.hits_count = i.hits_count + 1
WHERE (i.id = '168749')

Время выполнения 0.00102 секунд

/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','205','207'))
ORDER BY i.page_id, i.position, i.ordering
LIMIT 1000

Время выполнения 0.00090 секунд

zero77 1 месяц назад #

Красная Шапка 1 месяц назад #

aviator 1 месяц назад #+1

Красная Шапка 1 месяц назад #