| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| UPDATE `ip`.`feeds` AS `Feed` SET `Feed`.`counter` = Feed.counter + 1 WHERE `Feed`.`url` = 'avansy_za_nvos_predlagayut_vremenno_sdelat_dobrovol_nymi' | 1 | 1 | 17 | maybe slow |
| SELECT `Feed`.`id`, `Feed`.`url`, `Feed`.`name`, `Feed`.`meta_title`, `Feed`.`meta_keywords`, `Feed`.`meta_descriptions`, `Feed`.`active`, `Feed`.`counter`, `Feed`.`created`, `Feed`.`anons`, `Feed`.`text`, `Feed`.`consultant_link`, `Feed`.`link_title`, `Feed`.`link_header`, `Feed`.`schetchik_posewenij_ext`, `Feed`.`like`, `Feed`.`dislike`, `Feed`.`hit`, `Feed`.`og_title`, `Feed`.`og_description`, `Feed`.`og_img`, `Feed`.`category`, `Feed`.`tematika`, `Feed`.`pexpress`, `Feed`.`pe_recommend` FROM `ip`.`feeds` AS `Feed` WHERE `Feed`.`url` = 'avansy_za_nvos_predlagayut_vremenno_sdelat_dobrovol_nymi' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Publication`.`id`, `Publication`.`publicationtype_id`, `Publication`.`page_id`, `Publication`.`model`, `Publication`.`text`, `Publication`.`position`, `Publication`.`texttitle`, `Publication`.`quote`, `Publication`.`bannertext`, `Publication`.`img`, `Publication`.`imgalt`, `Publication`.`imgtitle`, `Publication`.`linktext`, `Publication`.`link`, `Publication`.`pdf`, `Publication`.`color`, `Publication`.`reason`, `Publication`.`table`, `Publication`.`video`, `Publication`.`lector`, `Publication`.`regalii`, `Publication`.`foto` FROM `ip`.`publications` AS `Publication` WHERE `Publication`.`model` = 'Feed' AND `Publication`.`page_id` = (31737) ORDER BY `Publication`.`position` asc | 0 | 0 | 3 | maybe slow |
| SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`model`, `Favorite`.`page_id`, `Favorite`.`publicdate`, `Favorite`.`created` FROM `ip`.`favorites` AS `Favorite` WHERE `Favorite`.`user_id` IS NULL AND `Favorite`.`page_id` = (31737) ORDER BY `Favorite`.`publicdate` asc | 0 | 0 | 1 | maybe slow |
| SELECT `Navigatorfeedback`.`id`, `Navigatorfeedback`.`user_id`, `Navigatorfeedback`.`model`, `Navigatorfeedback`.`page_id`, `Navigatorfeedback`.`like`, `Navigatorfeedback`.`dislike`, `Navigatorfeedback`.`created` FROM `ip`.`navigatorfeedbacks` AS `Navigatorfeedback` WHERE `Navigatorfeedback`.`model` = 'Feed' AND `Navigatorfeedback`.`page_id` = (31737) | 25 | 25 | 31 | maybe slow |
| SELECT `Theme`.`id`, `Theme`.`category_id`, `Theme`.`name`, `Theme`.`public`, `Theme`.`user_id`, `Theme`.`name_translit`, `Theme`.`cpr`, `Theme`.`lk`, `Theme`.`umc`, `Theme`.`icon`, `Theme`.`icon_dir`, `Theme`.`sort`, `Theme`.`navigator`, `FeedsTheme`.`id`, `FeedsTheme`.`feed_id`, `FeedsTheme`.`theme_id` FROM `ip`.`themes` AS `Theme` JOIN `ip`.`feeds_themes` AS `FeedsTheme` ON (`FeedsTheme`.`feed_id` = 31737 AND `FeedsTheme`.`theme_id` = `Theme`.`id`) | 2 | 2 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`name_translit`, `Category`.`lk_name`, `Category`.`1C_id`, `Category`.`1C_name`, `Category`.`lk`, `Category`.`cpr`, `Category`.`umc`, `Category`.`main_events`, `Category`.`main_section`, `Category`.`name_main_events`, `Category`.`name_main_section`, `Category`.`link_main_section`, `Category`.`conf`, `Category`.`navigator`, `Category`.`navigator_name`, `Category`.`navigator_icon`, `Category`.`bitrix24_id`, `CategoriesFeed`.`id`, `CategoriesFeed`.`feed_id`, `CategoriesFeed`.`category_id` FROM `ip`.`categories` AS `Category` JOIN `ip`.`categories_feeds` AS `CategoriesFeed` ON (`CategoriesFeed`.`feed_id` = 31737 AND `CategoriesFeed`.`category_id` = `Category`.`id`) | 3 | 3 | 1 | maybe slow |
| SELECT `Navigator`.`id`, `Navigator`.`active`, `Navigator`.`name`, `Navigator`.`url`, `Navigator`.`anons`, `Navigator`.`created`, `Navigator`.`hit`, `Navigator`.`schetchik_posewenij`, `Navigator`.`schetchik_posewenij_ext`, `Navigator`.`anons_pic`, `Navigator`.`doctheme_id`, `Navigator`.`model`, `Navigator`.`uid` FROM `ip`.`navigators` AS `Navigator` INNER JOIN `ip`.`navigators_themes` AS `NavigatorsTheme` ON (`NavigatorsTheme`.`theme_id` IN ('99', '39426') AND `NavigatorsTheme`.`publication_id` = `Navigator`.`id` AND `NavigatorsTheme`.`model` = `Navigator`.`model`) WHERE `Navigator`.`active` = 1 AND `Navigator`.`created` <= '2021-07-27 23:59:59' AND NOT (`Navigator`.`uid` = ('Feed31737')) GROUP BY `Navigator`.`uid` ORDER BY `Navigator`.`created` desc, `Navigator`.`schetchik_posewenij` ASC LIMIT 2 | 2 | 2 | 164 | maybe slow |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`categories_feeds` AS `CategoriesFeed` ON (`CategoriesFeed`.`category_id` = `Category`.`id` AND `CategoriesFeed`.`feed_id` = '32975') WHERE `Category`.`lk` = '1' | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`categories_feeds` AS `CategoriesFeed` ON (`CategoriesFeed`.`category_id` = `Category`.`id` AND `CategoriesFeed`.`feed_id` = '32976') WHERE `Category`.`lk` = '1' | 2 | 2 | 1 | maybe slow |
| SELECT `Navigator`.*, COUNT(*) as Total FROM `ip`.`navigators` AS `Navigator` INNER JOIN `ip`.`categories_navigators` AS `CategoriesNavigator` ON (`CategoriesNavigator`.`category_id` IN ('1', '2', '15') AND `CategoriesNavigator`.`publication_id` = `Navigator`.`id` AND `CategoriesNavigator`.`model` = `Navigator`.`model`) WHERE `Navigator`.`active` = 1 AND `Navigator`.`created` <= '2021-07-27 23:59:59' AND `Navigator`.`model` NOT IN ('Checklist', 'Feed') AND NOT (`Navigator`.`uid` IN ('Feed31737', 'Feed32975', 'Feed32976')) GROUP BY `Navigator`.`uid` HAVING Total = 3 ORDER BY `Navigator`.`created` desc, `Navigator`.`schetchik_posewenij` ASC LIMIT 4 | 4 | 4 | 241 | maybe slow |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`categories_kplusfeeds` AS `CategoriesKplusfeed` ON (`CategoriesKplusfeed`.`category_id` = `Category`.`id` AND `CategoriesKplusfeed`.`kplusfeed_id` = '31994') WHERE `Category`.`lk` = '1' | 4 | 4 | 0 | |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`categories_kplusfeeds` AS `CategoriesKplusfeed` ON (`CategoriesKplusfeed`.`category_id` = `Category`.`id` AND `CategoriesKplusfeed`.`kplusfeed_id` = '31985') WHERE `Category`.`lk` = '1' | 4 | 4 | 0 | |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`articles_categories` AS `ArticlesCategory` ON (`ArticlesCategory`.`category_id` = `Category`.`id` AND `ArticlesCategory`.`article_id` = '22189') WHERE `Category`.`lk` = '1' | 4 | 4 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`categories_kplusfaqs` AS `CategoriesKplusfaq` ON (`CategoriesKplusfaq`.`category_id` = `Category`.`id` AND `CategoriesKplusfaq`.`kplusfaq_id` = '25035') WHERE `Category`.`lk` = '1' | 5 | 5 | 2 | maybe slow |
| SELECT `Navigator`.`id`, `Navigator`.`active`, `Navigator`.`name`, `Navigator`.`url`, `Navigator`.`anons`, `Navigator`.`created`, `Navigator`.`hit`, `Navigator`.`schetchik_posewenij`, `Navigator`.`schetchik_posewenij_ext`, `Navigator`.`anons_pic`, `Navigator`.`doctheme_id`, `Navigator`.`model`, `Navigator`.`uid` FROM `ip`.`navigators` AS `Navigator` INNER JOIN `ip`.`categories_navigators` AS `CategoriesNavigator` ON (`CategoriesNavigator`.`category_id` IN ('1', '2', '15') AND `CategoriesNavigator`.`publication_id` = `Navigator`.`id` AND `CategoriesNavigator`.`model` = `Navigator`.`model`) WHERE `Navigator`.`active` = 1 AND `Navigator`.`created` <= '2021-07-27 23:59:59' AND `Navigator`.`model` = ('Checklist') AND NOT (`Navigator`.`uid` IN ('Feed31737', 'Feed32975', 'Feed32976', 'Kplusfeed31994', 'Kplusfeed31985', 'Article22189', 'Kplusfaq25035')) GROUP BY `Navigator`.`uid` ORDER BY `Navigator`.`created` desc, `Navigator`.`schetchik_posewenij` ASC LIMIT 2 | 2 | 2 | 103 | maybe slow |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`categories_checklists` AS `CategoriesChecklist` ON (`CategoriesChecklist`.`category_id` = `Category`.`id` AND `CategoriesChecklist`.`checklist_id` = '36') WHERE `Category`.`lk` = '1' | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`navigator_name` FROM `ip`.`categories` AS `Category` INNER JOIN `ip`.`categories_checklists` AS `CategoriesChecklist` ON (`CategoriesChecklist`.`category_id` = `Category`.`id` AND `CategoriesChecklist`.`checklist_id` = '34') WHERE `Category`.`lk` = '1' | 1 | 1 | 0 | |
| SELECT `Package`.`clientfree`, `Package`.`id`, `Package`.`name`, `Package`.`start`, `Package`.`end`, `PackagesTariff`.`cost`, `Package`.`navigator`, `Pformat`.`name`, `Pformat`.`id` FROM `ip`.`packages` AS `Package` LEFT JOIN `ip`.`pformats` AS `Pformat` ON (`Package`.`pformat_id` = `Pformat`.`id`) INNER JOIN `ip`.`categories_packages` AS `CategoriesPackage` ON (`CategoriesPackage`.`package_id` = `Package`.`id` AND `CategoriesPackage`.`category_id` IN ('1', '2', '15')) INNER JOIN `ip`.`packages_tariffs` AS `PackagesTariff` ON (`PackagesTariff`.`package_id` = `Package`.`id`) INNER JOIN `ip`.`tariffs` AS `Tariff` ON (`PackagesTariff`.`tariff_id` = `Tariff`.`id` AND `Tariff`.`basic` = 1) WHERE `Package`.`active` = '1' AND `Package`.`start` >= '2021-08-01' AND `Package`.`cpr` = '1' GROUP BY `Package`.`id` ORDER BY `Package`.`start` asc LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `Schedule`.`id`, `Schedule`.`oevent_id`, `Schedule`.`oform_id`, `PackagesService`.`id`, `PackagesService`.`package_id`, `PackagesService`.`service_id`, `PackagesService`.`part`, `PackagesService`.`servicetype_id`, `PackagesService`.`service_name` FROM `ip`.`schedules` AS `Schedule` JOIN `ip`.`packages_services` AS `PackagesService` ON (`PackagesService`.`package_id` = 2573 AND `PackagesService`.`service_id` = `Schedule`.`id`) WHERE `PackagesService`.`servicetype_id` = 13 ORDER BY `Schedule`.`start` ASC | 1 | 1 | 0 | |
| SELECT `Oevent`.`id`, `Oevent`.`format_id` FROM `ip`.`events` AS `Oevent` WHERE `Oevent`.`id` = 1354 | 1 | 1 | 0 | |
| SELECT `Format`.`name` FROM `ip`.`formats` AS `Format` WHERE `Format`.`id` = 20 | 1 | 1 | 0 | |
| SELECT `Oform`.`name` FROM `ip`.`oforms` AS `Oform` WHERE `Oform`.`id` = 13 | 1 | 1 | 0 | |
| SELECT `Lector`.`name`, `LectorsSchedule`.`id`, `LectorsSchedule`.`schedule_id`, `LectorsSchedule`.`lector_id` FROM `ip`.`lectors` AS `Lector` JOIN `ip`.`lectors_schedules` AS `LectorsSchedule` ON (`LectorsSchedule`.`schedule_id` = 2302 AND `LectorsSchedule`.`lector_id` = `Lector`.`id`) | 1 | 1 | 0 | |
| SELECT `Cond`.`id`, `Cond`.`name`, `Cond`.`icon`, `Cond`.`icon_dir`, `CondsSchedule`.`id`, `CondsSchedule`.`schedule_id`, `CondsSchedule`.`cond_id` FROM `ip`.`conds` AS `Cond` JOIN `ip`.`conds_schedules` AS `CondsSchedule` ON (`CondsSchedule`.`schedule_id` = 2302 AND `CondsSchedule`.`cond_id` = `Cond`.`id`) | 0 | 0 | 0 | |
| SELECT `Category`.`navigator_name`, `Category`.`name`, `Category`.`navigator_icon`, `Category`.`id`, `CategoriesPackage`.`id`, `CategoriesPackage`.`package_id`, `CategoriesPackage`.`category_id` FROM `ip`.`categories` AS `Category` JOIN `ip`.`categories_packages` AS `CategoriesPackage` ON (`CategoriesPackage`.`package_id` = 2573 AND `CategoriesPackage`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
| SELECT `Cond`.`id`, `Cond`.`name`, `Cond`.`icon`, `Cond`.`icon_dir`, `CondsPackage`.`id`, `CondsPackage`.`package_id`, `CondsPackage`.`cond_id` FROM `ip`.`conds` AS `Cond` JOIN `ip`.`conds_packages` AS `CondsPackage` ON (`CondsPackage`.`package_id` = 2573 AND `CondsPackage`.`cond_id` = `Cond`.`id`) | 0 | 0 | 0 | |
| SELECT `Package`.`clientfree`, `Package`.`id`, `Package`.`name`, `Package`.`start`, `Package`.`end`, `PackagesTariff`.`cost`, `Package`.`navigator`, `Pformat`.`name`, `Pformat`.`id` FROM `ip`.`packages` AS `Package` LEFT JOIN `ip`.`pformats` AS `Pformat` ON (`Package`.`pformat_id` = `Pformat`.`id`) INNER JOIN `ip`.`categories_packages` AS `CategoriesPackage` ON (`CategoriesPackage`.`package_id` = `Package`.`id` AND `CategoriesPackage`.`category_id` IN ('1', '2', '15')) INNER JOIN `ip`.`packages_tariffs` AS `PackagesTariff` ON (`PackagesTariff`.`package_id` = `Package`.`id`) INNER JOIN `ip`.`tariffs` AS `Tariff` ON (`PackagesTariff`.`tariff_id` = `Tariff`.`id` AND `Tariff`.`basic` = 1) WHERE `Package`.`active` = '1' AND `Package`.`start` IS NULL AND `Package`.`cpr` = '1' GROUP BY `Package`.`id` ORDER BY `Package`.`created` desc LIMIT 1 | 1 | 1 | 6 | maybe slow |
| SELECT `Schedule`.`id`, `Schedule`.`oevent_id`, `Schedule`.`oform_id`, `PackagesService`.`id`, `PackagesService`.`package_id`, `PackagesService`.`service_id`, `PackagesService`.`part`, `PackagesService`.`servicetype_id`, `PackagesService`.`service_name` FROM `ip`.`schedules` AS `Schedule` JOIN `ip`.`packages_services` AS `PackagesService` ON (`PackagesService`.`package_id` = 2564 AND `PackagesService`.`service_id` = `Schedule`.`id`) WHERE `PackagesService`.`servicetype_id` = 13 ORDER BY `Schedule`.`start` ASC | 1 | 1 | 0 | |
| SELECT `Oevent`.`id`, `Oevent`.`format_id` FROM `ip`.`events` AS `Oevent` WHERE `Oevent`.`id` = 1371 | 1 | 1 | 0 | |
| SELECT `Format`.`name` FROM `ip`.`formats` AS `Format` WHERE `Format`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `Oform`.`name` FROM `ip`.`oforms` AS `Oform` WHERE `Oform`.`id` = 9 | 1 | 1 | 0 | |
| SELECT `Lector`.`name`, `LectorsSchedule`.`id`, `LectorsSchedule`.`schedule_id`, `LectorsSchedule`.`lector_id` FROM `ip`.`lectors` AS `Lector` JOIN `ip`.`lectors_schedules` AS `LectorsSchedule` ON (`LectorsSchedule`.`schedule_id` = 2296 AND `LectorsSchedule`.`lector_id` = `Lector`.`id`) | 1 | 1 | 0 | |
| SELECT `Cond`.`id`, `Cond`.`name`, `Cond`.`icon`, `Cond`.`icon_dir`, `CondsSchedule`.`id`, `CondsSchedule`.`schedule_id`, `CondsSchedule`.`cond_id` FROM `ip`.`conds` AS `Cond` JOIN `ip`.`conds_schedules` AS `CondsSchedule` ON (`CondsSchedule`.`schedule_id` = 2296 AND `CondsSchedule`.`cond_id` = `Cond`.`id`) | 0 | 0 | 0 | |
| SELECT `Category`.`navigator_name`, `Category`.`name`, `Category`.`navigator_icon`, `Category`.`id`, `CategoriesPackage`.`id`, `CategoriesPackage`.`package_id`, `CategoriesPackage`.`category_id` FROM `ip`.`categories` AS `Category` JOIN `ip`.`categories_packages` AS `CategoriesPackage` ON (`CategoriesPackage`.`package_id` = 2564 AND `CategoriesPackage`.`category_id` = `Category`.`id`) | 2 | 2 | 0 | |
| SELECT `Cond`.`id`, `Cond`.`name`, `Cond`.`icon`, `Cond`.`icon_dir`, `CondsPackage`.`id`, `CondsPackage`.`package_id`, `CondsPackage`.`cond_id` FROM `ip`.`conds` AS `Cond` JOIN `ip`.`conds_packages` AS `CondsPackage` ON (`CondsPackage`.`package_id` = 2564 AND `CondsPackage`.`cond_id` = `Cond`.`id`) | 1 | 1 | 0 | |
