От профессиональных знаний к успешному бизнесу

+7 (343) 317-05-06

Вернуться назад

Технико-экономическое планирование на производственном предприятии

Программа: 

1 Планирование в системе управления предприятием

Планирование как функция менеджмента. Стратегическое, текущее и оперативное планирование: содержание, элементы, взаимосвязь форм и целевых показателей. Финансовое и производственное планирование: цели, принципы, взаимосвязь. Система целевых показателей эффективности для собственника и менеджера. Снижение затрат и временных циклов как ключевые направления повышения эффективности. Модель текущего плана машиностроительного предприятия.

2 Планирование сбыта и производства продукции

Этапы разработки плана. Методы прогнозирования объемов продаж: экстраполяционные (анализ временных рядов), имитационные (методы моделирования, корреляционно-регрессионный анализ), экспертная оценка (метод Дельфи, построение сценариев с учетом вероятности). Применение оптимизационной модели для структурирования программы выпуска. Основные объемные показатели продукции (валовая, товарная и реализуемая продукция, валовой и внутризаводской обороты), нормирование запасов готовой продукции и незавершенного производства, расчет коэффициента нарастания затрат

Практикум:

- прогнозирование продаж статистическими методами;

- расчет оптимальной производственной программы на основе подхода Голдратта.

3 Управление производственной мощностью

Понятие, виды и способы расчета производственной мощности, порядок планирования мощности предприятия «снизу-вверх», принципы выбора ведущего звена. Приведение к условным единицам продукции при многономенклатурном выпуске. Выравнивание мощности, подходы к расшивке узких мест. Управление производственной мощностью в краткосрочной и долгосрочной перспективе, Теория ограничений систем Голдратта (супер-маржинальный подход, TOC).

Практикум: планирование производственной мощности.

4 Ресурсное обеспечение производства

Планирование потребности в производственных фондах. Расчет фонда времени работы оборудования, диагностика и ликвидация потерь. Подходы к организации ТОиР.

Практикум: расчет коэффициента общей эффективности (КОЭ, OEE).

План по труду и кадрам: укрупненное планирование численности работающих и фонда оплаты труда по категориям. Современные системы материального стимулирования: грейдовая система, мотивация на основе системы сбалансированных показателей (ССП, BSC).

Планирование потребности в материальных ресурсах на основе ABC (xyz) – анализа, нормирование запасов материальных ресурсов.  Планирование потребности в оборотных средствах на основе оборачиваемости.

5 Планирование затрат на производство и реализацию продукции

Классификация затрат в целях управления. Методы укрупненного планирования себестоимости: по технико-экономическим факторам и через нормативы затрат. Формирование смет по центрам ответственности, составление свода затрат. Расчет стоимостных нормативов на основе ставок распределения  и через разделение издержек на переменную и постоянную части. Методы распределения затрат на переменную и постоянную части: расчетно-аналитический, визуальный, минимум-максимум.

Практикум:

- планирование снижения себестоимости по технико-экономическим факторам;

- расчет изменения показателей эффективности в результате увеличения объемов выпуска и сокращения производственного цикла.

6 Калькулирование себестоимости продукции

Калькулирование на основе метода с полным поглощением затрат (Absorbtion costing), метода переменных затрат (Direct costing) и супер-маржинального подхода: различия в показателях, эффективность применения в различных условиях.

Практикум: расчет себестоимости с применением различных систем учета.

Нормативное калькулирование себестоимости продукции (Standard costing): общий порядок нормирования и контроля затрат, схема анализа отклонений, условия эффективного применения.  Оценка плановых и операционных отклонений, распределение ответственности.

Практикум: расчет отклонений по материальным затратам (в т.ч. по расходу, структуре и цене), затратам на прямую заработную плату (в т.ч. по затратам и структуре труда, тарифной ставке), переменным и постоянным накладным расходам.

Основы попроцессного калькулирования себестоимости (Activity based costing, ABC).

Вернуться назад

Прилуцкая Мария Андреевна

К.э.н., эксперт в области экономики и управления производством, Член-корреспондент Международной академии науки и практики организаторов производства

Даты начала курса: 24.04.2019
Продолжительность обучения:16 академических часов
Время проведения:10.00-17.00
Место проведения:г. Екатеринбург, ул. Энгельса, 36
Форма обучения: Очная, возможен дистанционный формат
Стоимость участия: 12300 Р.
Вернуться назад
КОРПОРАТИВНОЕ ОБУЧЕНИЕ

На нашем сайте мы используем файлы сookie, чтобы сделать вашу работу наиболее комфортной. Продолжая пользоваться нашим сайтом, не меняя настроек, вы тем самым выражаете согласие на использование нами данных файлов. Более подробно вы можете почитать о них в разделе Политика конфиденциальности

Заказать звонок

*
*
*
Общий отчет (Время: 0.82460с, Память: 22,960Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24`, `eventInfo`.`id` AS `t2_c0`, `eventInfo`.`core_id` AS `t2_c1`, `eventInfo`.`teacher_id` AS `t2_c2`, `eventInfo`.`corporate_training` AS `t2_c3`, `eventInfo`.`training_direction_id` AS `t2_c4`, `eventInfo`.`detail_image` AS `t2_c5`, `eventInfo`.`start_date` AS `t2_c6`, `eventInfo`.`end_date` AS `t2_c7`, `eventInfo`.`duration_of_training` AS `t2_c8`, `eventInfo`.`time_spending` AS `t2_c9`, `eventInfo`.`location` AS `t2_c10`, `eventInfo`.`mode_of_study` AS `t2_c11`, `eventInfo`.`price` AS `t2_c12`, `eventInfo`.`new_price` AS `t2_c13`, `eventInfo`.`label` AS `t2_c14`, `eventInfo`.`schedule` AS `t2_c15`, `eventInfo`.`schedule_counter` AS `t2_c16`, `eventInfo`.`show_counter` AS `t2_c17`, `eventInfo`.`audience` AS `t2_c18`, `eventInfo`.`show_event` AS `t2_c19` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `EventPagePermission` ON (`EventPagePermission`.`table_id`=`t`.`id`) LEFT OUTER JOIN `tbl_event_info` `eventInfo` ON (`eventInfo`.`core_id`=`t`.`id`) WHERE (((t.act = 1) AND (`t`.`lft_margin`<681 AND `t`.`rgt_margin`>682)) AND (`t`.`root_id`=:ycp2)) AND ((EventPagePermission.table_name = 'core' AND EventPagePermission.group_id = '1') AND (EventPagePermission.read = 1)) ORDER BY `t`.`lft_margin`, eventInfo.start_date ASC, t.id DESC. Bound with :ycp2=1) 1 0.00748 0.00748 0.00748 0.00748
system.db.CDbCommand.query(SELECT * FROM `tbl_url_external` `t`) 1 0.00669 0.00669 0.00669 0.00669
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24`, `eventInfo`.`id` AS `t2_c0`, `eventInfo`.`core_id` AS `t2_c1`, `eventInfo`.`teacher_id` AS `t2_c2`, `eventInfo`.`corporate_training` AS `t2_c3`, `eventInfo`.`training_direction_id` AS `t2_c4`, `eventInfo`.`detail_image` AS `t2_c5`, `eventInfo`.`start_date` AS `t2_c6`, `eventInfo`.`end_date` AS `t2_c7`, `eventInfo`.`duration_of_training` AS `t2_c8`, `eventInfo`.`time_spending` AS `t2_c9`, `eventInfo`.`location` AS `t2_c10`, `eventInfo`.`mode_of_study` AS `t2_c11`, `eventInfo`.`price` AS `t2_c12`, `eventInfo`.`new_price` AS `t2_c13`, `eventInfo`.`label` AS `t2_c14`, `eventInfo`.`schedule` AS `t2_c15`, `eventInfo`.`schedule_counter` AS `t2_c16`, `eventInfo`.`show_counter` AS `t2_c17`, `eventInfo`.`audience` AS `t2_c18`, `eventInfo`.`show_event` AS `t2_c19` FROM `tbl_core` `t` LEFT OUTER JOIN tbl_filters_related AS fr ON t.id = fr.core_id LEFT OUTER JOIN tbl_event_info AS ei ON ei.core_id = t.id LEFT OUTER JOIN `tbl_permission` `EventPagePermission` ON (`EventPagePermission`.`table_id`=`t`.`id`) LEFT OUTER JOIN `tbl_event_info` `eventInfo` ON (`eventInfo`.`core_id`=`t`.`id`) WHERE (((t.act = 1) AND (`t`.model = :modelName)) AND (((fr.value=:ycp6) AND (t.id !=507)) AND (ei.start_date > CURDATE() AND ei.show_event = 0))) AND ((EventPagePermission.table_name = 'core' AND EventPagePermission.group_id = '1') AND (EventPagePermission.read = 1)) ORDER BY eventInfo.start_date ASC, t.id DESC LIMIT 4. Bound with :modelName='EventPage', :ycp6='19') 1 0.00598 0.00598 0.00598 0.00598
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24`, `eventInfo`.`id` AS `t2_c0`, `eventInfo`.`core_id` AS `t2_c1`, `eventInfo`.`teacher_id` AS `t2_c2`, `eventInfo`.`corporate_training` AS `t2_c3`, `eventInfo`.`training_direction_id` AS `t2_c4`, `eventInfo`.`detail_image` AS `t2_c5`, `eventInfo`.`start_date` AS `t2_c6`, `eventInfo`.`end_date` AS `t2_c7`, `eventInfo`.`duration_of_training` AS `t2_c8`, `eventInfo`.`time_spending` AS `t2_c9`, `eventInfo`.`location` AS `t2_c10`, `eventInfo`.`mode_of_study` AS `t2_c11`, `eventInfo`.`price` AS `t2_c12`, `eventInfo`.`new_price` AS `t2_c13`, `eventInfo`.`label` AS `t2_c14`, `eventInfo`.`schedule` AS `t2_c15`, `eventInfo`.`schedule_counter` AS `t2_c16`, `eventInfo`.`show_counter` AS `t2_c17`, `eventInfo`.`audience` AS `t2_c18`, `eventInfo`.`show_event` AS `t2_c19` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `EventPagePermission` ON (`EventPagePermission`.`table_id`=`t`.`id`) LEFT OUTER JOIN `tbl_event_info` `eventInfo` ON (`eventInfo`.`core_id`=`t`.`id`) WHERE (((t.act = 1) AND (`t`.`lft_margin`<681 AND `t`.`rgt_margin`>682)) AND (`t`.`root_id`=:ycp1)) AND ((EventPagePermission.table_name = 'core' AND EventPagePermission.group_id = '1') AND (EventPagePermission.read = 1)) ORDER BY `t`.`lft_margin`, eventInfo.start_date ASC, t.id DESC. Bound with :ycp1=1) 1 0.00555 0.00555 0.00555 0.00555
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24`, `eventInfo`.`id` AS `t1_c0`, `eventInfo`.`core_id` AS `t1_c1`, `eventInfo`.`teacher_id` AS `t1_c2`, `eventInfo`.`corporate_training` AS `t1_c3`, `eventInfo`.`training_direction_id` AS `t1_c4`, `eventInfo`.`detail_image` AS `t1_c5`, `eventInfo`.`start_date` AS `t1_c6`, `eventInfo`.`end_date` AS `t1_c7`, `eventInfo`.`duration_of_training` AS `t1_c8`, `eventInfo`.`time_spending` AS `t1_c9`, `eventInfo`.`location` AS `t1_c10`, `eventInfo`.`mode_of_study` AS `t1_c11`, `eventInfo`.`price` AS `t1_c12`, `eventInfo`.`new_price` AS `t1_c13`, `eventInfo`.`label` AS `t1_c14`, `eventInfo`.`schedule` AS `t1_c15`, `eventInfo`.`schedule_counter` AS `t1_c16`, `eventInfo`.`show_counter` AS `t1_c17`, `eventInfo`.`audience` AS `t1_c18`, `eventInfo`.`show_event` AS `t1_c19` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_event_info` `eventInfo` ON (`eventInfo`.`core_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.`id`=507)) ORDER BY eventInfo.start_date ASC, t.id DESC) 2 0.00433 0.00217 0.00186 0.00247
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24`, `eventInfo`.`id` AS `t2_c0`, `eventInfo`.`core_id` AS `t2_c1`, `eventInfo`.`teacher_id` AS `t2_c2`, `eventInfo`.`corporate_training` AS `t2_c3`, `eventInfo`.`training_direction_id` AS `t2_c4`, `eventInfo`.`detail_image` AS `t2_c5`, `eventInfo`.`start_date` AS `t2_c6`, `eventInfo`.`end_date` AS `t2_c7`, `eventInfo`.`duration_of_training` AS `t2_c8`, `eventInfo`.`time_spending` AS `t2_c9`, `eventInfo`.`location` AS `t2_c10`, `eventInfo`.`mode_of_study` AS `t2_c11`, `eventInfo`.`price` AS `t2_c12`, `eventInfo`.`new_price` AS `t2_c13`, `eventInfo`.`label` AS `t2_c14`, `eventInfo`.`schedule` AS `t2_c15`, `eventInfo`.`schedule_counter` AS `t2_c16`, `eventInfo`.`show_counter` AS `t2_c17`, `eventInfo`.`audience` AS `t2_c18`, `eventInfo`.`show_event` AS `t2_c19` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `EventPagePermission` ON (`EventPagePermission`.`table_id`=`t`.`id`) LEFT OUTER JOIN `tbl_event_info` `eventInfo` ON (`eventInfo`.`core_id`=`t`.`id`) WHERE ((((t.act = 1) AND (`t`.`lft_margin`>681 AND `t`.`rgt_margin`<682)) AND (`t`.`level`<=4)) AND (`t`.`root_id`=:ycp0)) AND ((EventPagePermission.table_name = 'core' AND EventPagePermission.group_id = '1') AND (EventPagePermission.read = 1)) ORDER BY t.ord, `t`.`lft_margin`, eventInfo.start_date ASC, t.id DESC. Bound with :ycp0=1) 1 0.00393 0.00393 0.00393 0.00393
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_url_external`) 1 0.00290 0.00290 0.00290 0.00290
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_core`) 1 0.00242 0.00242 0.00242 0.00242
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_event_info`) 1 0.00240 0.00240 0.00240 0.00240
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `TeacherPagePermission` ON (`TeacherPagePermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.`id`=:yp0)) AND ((TeacherPagePermission.table_name = 'core' AND TeacherPagePermission.group_id = '1') AND (TeacherPagePermission.read = 1)) ORDER BY t.ord. Bound with :yp0='425') 3 0.00237 0.00079 0.00070 0.00087
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `TeacherPagePermission` ON (`TeacherPagePermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.`id`=:yp0)) AND ((TeacherPagePermission.table_name = 'core' AND TeacherPagePermission.group_id = '1') AND (TeacherPagePermission.read = 1)) ORDER BY t.ord. Bound with :yp0='116') 3 0.00236 0.00079 0.00066 0.00092
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `TeacherPagePermission` ON (`TeacherPagePermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.`id`=:yp0)) AND ((TeacherPagePermission.table_name = 'core' AND TeacherPagePermission.group_id = '1') AND (TeacherPagePermission.read = 1)) ORDER BY t.ord. Bound with :yp0='462') 3 0.00229 0.00076 0.00060 0.00108
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `TeacherPagePermission` ON (`TeacherPagePermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.`id`=:yp0)) AND ((TeacherPagePermission.table_name = 'core' AND TeacherPagePermission.group_id = '1') AND (TeacherPagePermission.read = 1)) ORDER BY t.ord. Bound with :yp0='326') 3 0.00207 0.00069 0.00061 0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_permission`) 1 0.00207 0.00207 0.00207 0.00207
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_settings`) 1 0.00197 0.00197 0.00197 0.00197
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_event_images`) 1 0.00189 0.00189 0.00189 0.00189
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_menu`) 1 0.00187 0.00187 0.00187 0.00187
system.db.CDbCommand.query(SELECT `schedule`.`id` AS `t1_c0`, `schedule`.`core_id` AS `t1_c1`, `schedule`.`name` AS `t1_c2`, `schedule`.`content` AS `t1_c3` FROM `tbl_event_schedule` `schedule` WHERE (`schedule`.`core_id`=:ypl0). Bound with :ypl0=507) 1 0.00185 0.00185 0.00185 0.00185
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `PDProcessDataPermission` ON (`PDProcessDataPermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.model = :modelName)) AND ((PDProcessDataPermission.table_name = 'core' AND PDProcessDataPermission.group_id = '1') AND (PDProcessDataPermission.read = 1)) ORDER BY t.ord. Bound with :modelName='PDProcessData') 1 0.00184 0.00184 0.00184 0.00184
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_block`) 1 0.00171 0.00171 0.00171 0.00171
system.db.CDbCommand.query(SELECT `id`, `model` FROM `tbl_core` WHERE url = :url. Bound with :url='events/tehniko_ekonomicheskoe_planirovanie_na_proizvodstvennom_predpriyatii') 1 0.00169 0.00169 0.00169 0.00169
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_event_schedule`) 1 0.00168 0.00168 0.00168 0.00168
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tbl_filters_related`) 1 0.00158 0.00158 0.00158 0.00158
system.db.CDbCommand.query(SELECT * FROM `tbl_settings` `t`) 2 0.00152 0.00076 0.00073 0.00079
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `PDCatalogPermission` ON (`PDCatalogPermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.model = :modelName)) AND ((PDCatalogPermission.table_name = 'core' AND PDCatalogPermission.group_id = '1') AND (PDCatalogPermission.read = 1)) ORDER BY t.ord. Bound with :modelName='PDCatalog') 1 0.00143 0.00143 0.00143 0.00143
system.db.CDbCommand.query(SELECT * FROM `tbl_block` `t`) 2 0.00134 0.00067 0.00066 0.00067
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`link` AS `t0_c8`, `t`.`act` AS `t0_c9`, `t`.`ord` AS `t0_c10`, `t`.`core_id` AS `t0_c11`, `t`.`is_lock` AS `t0_c12`, `t`.`cat_id` AS `t0_c13` FROM `tbl_menu` `t` LEFT OUTER JOIN `tbl_permission` `MenuCategoryPermission` ON (`MenuCategoryPermission`.`table_id`=`t`.`id`) WHERE ((`t`.`act` = 1) AND (`t`.`id`=1)) AND ((MenuCategoryPermission.table_name = 'menu' AND MenuCategoryPermission.group_id = '1') AND (MenuCategoryPermission.read = 1)) ORDER BY t.ord) 1 0.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SELECT `EventPagePermission`.`id` AS `t1_c0`, `EventPagePermission`.`table_name` AS `t1_c1`, `EventPagePermission`.`table_id` AS `t1_c2`, `EventPagePermission`.`group_id` AS `t1_c3`, `EventPagePermission`.`create` AS `t1_c4`, `EventPagePermission`.`read` AS `t1_c5`, `EventPagePermission`.`update` AS `t1_c6`, `EventPagePermission`.`delete` AS `t1_c7` FROM `tbl_permission` `EventPagePermission` WHERE (EventPagePermission.table_name = 'core' AND EventPagePermission.group_id = '1') AND (EventPagePermission.table_name = 'core' AND EventPagePermission.group_id = '1') AND (`EventPagePermission`.`table_id`=:ypl0). Bound with :ypl0=507) 2 0.00117 0.00059 0.00056 0.00062
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `PDPrivacyPolicyPermission` ON (`PDPrivacyPolicyPermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.model = :modelName)) AND ((PDPrivacyPolicyPermission.table_name = 'core' AND PDPrivacyPolicyPermission.group_id = '1') AND (PDPrivacyPolicyPermission.read = 1)) ORDER BY t.ord. Bound with :modelName='PDPrivacyPolicy') 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`link` AS `t0_c8`, `t`.`act` AS `t0_c9`, `t`.`ord` AS `t0_c10`, `t`.`core_id` AS `t0_c11`, `t`.`is_lock` AS `t0_c12`, `t`.`cat_id` AS `t0_c13` FROM `tbl_menu` `t` LEFT OUTER JOIN `tbl_permission` `MenuCategoryTopPermission` ON (`MenuCategoryTopPermission`.`table_id`=`t`.`id`) WHERE ((((`t`.`act` = 1) AND (`t`.`lft_margin`>1 AND `t`.`rgt_margin`<10)) AND (`t`.`level`<=2)) AND (`t`.`root_id`=:ycp3)) AND ((MenuCategoryTopPermission.table_name = 'menu' AND MenuCategoryTopPermission.group_id = '1') AND (MenuCategoryTopPermission.read = 1)) ORDER BY t.ord ASC. Bound with :ycp3=1) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `TeacherPagePermission` ON (`TeacherPagePermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.`id`=:yp0)) AND ((TeacherPagePermission.table_name = 'core' AND TeacherPagePermission.group_id = '1') AND (TeacherPagePermission.read = 1)) ORDER BY t.ord. Bound with :yp0='92') 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`link` AS `t0_c8`, `t`.`act` AS `t0_c9`, `t`.`ord` AS `t0_c10`, `t`.`core_id` AS `t0_c11`, `t`.`is_lock` AS `t0_c12`, `t`.`cat_id` AS `t0_c13` FROM `tbl_menu` `t` LEFT OUTER JOIN `tbl_permission` `MenuCategoryTopPermission` ON (`MenuCategoryTopPermission`.`table_id`=`t`.`id`) WHERE ((`t`.`act` = 1) AND (`t`.model = :modelName)) AND ((MenuCategoryTopPermission.table_name = 'menu' AND MenuCategoryTopPermission.group_id = '1') AND (MenuCategoryTopPermission.read = 1)) ORDER BY t.ord. Bound with :modelName='MenuCategoryTop') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SELECT * FROM `tbl_settings` `t` WHERE `t`.`name`=:yp0 AND `t`.`category`=:yp1 LIMIT 1. Bound with :yp0='theme', :yp1='system') 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_core`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`root_id` AS `t0_c2`, `t`.`lft_margin` AS `t0_c3`, `t`.`rgt_margin` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`model` AS `t0_c6`, `t`.`name` AS `t0_c7`, `t`.`url` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`after_content` AS `t0_c10`, `t`.`anons` AS `t0_c11`, `t`.`title` AS `t0_c12`, `t`.`description` AS `t0_c13`, `t`.`keywords` AS `t0_c14`, `t`.`seo_priority` AS `t0_c15`, `t`.`seo_changefreq` AS `t0_c16`, `t`.`image` AS `t0_c17`, `t`.`act` AS `t0_c18`, `t`.`ord` AS `t0_c19`, `t`.`create_time` AS `t0_c20`, `t`.`update_time` AS `t0_c21`, `t`.`seo_content` AS `t0_c22`, `t`.`h1` AS `t0_c23`, `t`.`on_main` AS `t0_c24` FROM `tbl_core` `t` LEFT OUTER JOIN `tbl_permission` `PDPublicOfferPermission` ON (`PDPublicOfferPermission`.`table_id`=`t`.`id`) WHERE ((t.act = 1) AND (`t`.model = :modelName)) AND ((PDPublicOfferPermission.table_name = 'core' AND PDPublicOfferPermission.group_id = '1') AND (PDPublicOfferPermission.read = 1)) ORDER BY t.ord. Bound with :modelName='PDPublicOffer') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_event_schedule`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_permission`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_url_external`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT * FROM `tbl_settings` `t` WHERE `t`.`category`=:yp0 AND `t`.`name`=:yp1 LIMIT 1. Bound with :yp0='module#form', :yp1='use_recaptcha') 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT `images`.`id` AS `t1_c0`, `images`.`core_id` AS `t1_c1`, `images`.`image` AS `t1_c2`, `images`.`act` AS `t1_c3`, `images`.`ord` AS `t1_c4` FROM `tbl_event_images` `images` WHERE (`images`.`act` = 1) AND (`images`.`core_id`=:ypl0) ORDER BY `images`.`ord`. Bound with :ypl0=507) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT * FROM `tbl_filters_related` `t` WHERE (t.filter=:ycp4) AND (t.core_id=:ycp5) LIMIT 1. Bound with :ycp4='1', :ycp5='507') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_settings`) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_block`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_event_info`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_event_images`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_menu`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `tbl_filters_related`) 1 0.00039 0.00039 0.00039 0.00039