UPDATE `ip`.`kplusfaqs` AS `Kplusfaq` LEFT JOIN `ip`.`authors` AS `Author` ON (`Kplusfaq`.`author_id` = `Author`.`id`) SET `Kplusfaq`.`schetchik_posewenij` = Kplusfaq.schetchik_posewenij + 1 WHERE `Kplusfaq`.`url` = ‘vozmozhno_li_viplachivat__zarabotnuyu_platu_iz_kassi__esli_den_gi_postupili_po_dogovoru_zaima_s_uchreditelem_’
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` = ‘Kplusfaq’ AND `Publication`.`page_id` = (32173) ORDER BY `Publication`.`position` asc
3
3
2
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` = (32173) ORDER BY `Favorite`.`publicdate` asc
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` = ‘Kplusfaq’ AND `Navigatorfeedback`.`page_id` = (32173)
29
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`, `KplusfaqsTheme`.`id`, `KplusfaqsTheme`.`kplusfaq_id`, `KplusfaqsTheme`.`theme_id` FROM `ip`.`themes` AS `Theme` JOIN `ip`.`kplusfaqs_themes` AS `KplusfaqsTheme` ON (`KplusfaqsTheme`.`kplusfaq_id` = 32173 AND `KplusfaqsTheme`.`theme_id` = `Theme`.`id`)
2
2
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`, `CategoriesKplusfaq`.`id`, `CategoriesKplusfaq`.`kplusfaq_id`, `CategoriesKplusfaq`.`category_id` FROM `ip`.`categories` AS `Category` JOIN `ip`.`categories_kplusfaqs` AS `CategoriesKplusfaq` ON (`CategoriesKplusfaq`.`kplusfaq_id` = 32173 AND `CategoriesKplusfaq`.`category_id` = `Category`.`id`)
1
1
2
maybe slow
SELECT `Kplusfaq`.`id`, `Kplusfaq`.`name`, `Kplusfaq`.`url`, `Kplusfaq`.`active`, `Kplusfaq`.`created`, `Kplusfaq`.`meta_title`, `Kplusfaq`.`meta_keywords`, `Kplusfaq`.`meta_descriptions`, `Kplusfaq`.`anons`, `Kplusfaq`.`text`, `Kplusfaq`.`text2`, `Kplusfaq`.`foto_lektora`, `Kplusfaq`.`fio`, `Kplusfaq`.`regalii`, `Kplusfaq`.`tematika`, `Kplusfaq`.`category`, `Kplusfaq`.`counter`, `Kplusfaq`.`schetchik_posewenij`, `Kplusfaq`.`hit`, `Kplusfaq`.`background_pic`, `Kplusfaq`.`anons_pic`, `Kplusfaq`.`estk`, `Kplusfaq`.`bezk`, `Kplusfaq`.`tags`, `Kplusfaq`.`end_time`, `Kplusfaq`.`link_header`, `Kplusfaq`.`consultant_link`, `Kplusfaq`.`link_title`, `Kplusfaq`.`schetchik_posewenij_ext`, `Kplusfaq`.`like`, `Kplusfaq`.`dislike`, `Kplusfaq`.`og_title`, `Kplusfaq`.`og_description`, `Kplusfaq`.`og_img`, `Kplusfaq`.`author_id`, `Author`.`id`, `Author`.`name`, `Author`.`post`, `Author`.`img`, `Author`.`img_dir`, `Author`.`public` FROM `ip`.`kplusfaqs` AS `Kplusfaq` LEFT JOIN `ip`.`authors` AS `Author` ON (`Kplusfaq`.`author_id` = `Author`.`id`) INNER JOIN `ip`.`categories_kplusfaqs` AS `CategoriesKplusfaq` ON (`CategoriesKplusfaq`.`category_id` = (‘1’) AND `CategoriesKplusfaq`.`kplusfaq_id` = `Kplusfaq`.`id`) WHERE `Kplusfaq`.`active` = ‘1’ AND `Kplusfaq`.`created` <= ‘2021-01-15’ AND `Kplusfaq`.`url` <> ‘vozmozhno_li_viplachivat__zarabotnuyu_platu_iz_kassi__esli_den_gi_postupili_po_dogovoru_zaima_s_uchreditelem_’ ORDER BY `Kplusfaq`.`created` desc LIMIT 1
1
1
43
maybe slow
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` = ‘Kplusfaq’ AND `Publication`.`page_id` = (32315) ORDER BY `Publication`.`position` asc
3
3
2
maybe slow
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`model`, `Favorite`.`page_id`, `Favorite`.`publicdate`, `Favorite`.`created` FROM `ip`.`favorites` AS `Favorite` WHERE `Favorite`.`model` = ‘Kplusfaq’ AND `Favorite`.`page_id` = (32315) ORDER BY `Favorite`.`publicdate` asc
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` = ‘Kplusfaq’ AND `Navigatorfeedback`.`page_id` = (32315)
29
maybe slow
SELECT `CategoriesKplusfaq`.`id`, `CategoriesKplusfaq`.`kplusfaq_id`, `CategoriesKplusfaq`.`category_id` FROM `ip`.`categories_kplusfaqs` AS `CategoriesKplusfaq` WHERE `CategoriesKplusfaq`.`kplusfaq_id` = (32315)
1
1
2
maybe slow
SELECT `KplusfaqsTheme`.`id`, `KplusfaqsTheme`.`kplusfaq_id`, `KplusfaqsTheme`.`theme_id` FROM `ip`.`kplusfaqs_themes` AS `KplusfaqsTheme` WHERE `KplusfaqsTheme`.`kplusfaq_id` = (32315)
2
2
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`, `KplusfaqsTheme`.`id`, `KplusfaqsTheme`.`kplusfaq_id`, `KplusfaqsTheme`.`theme_id` FROM `ip`.`themes` AS `Theme` JOIN `ip`.`kplusfaqs_themes` AS `KplusfaqsTheme` ON (`KplusfaqsTheme`.`kplusfaq_id` = 32315 AND `KplusfaqsTheme`.`theme_id` = `Theme`.`id`)
2
2
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`, `CategoriesKplusfaq`.`id`, `CategoriesKplusfaq`.`kplusfaq_id`, `CategoriesKplusfaq`.`category_id` FROM `ip`.`categories` AS `Category` JOIN `ip`.`categories_kplusfaqs` AS `CategoriesKplusfaq` ON (`CategoriesKplusfaq`.`kplusfaq_id` = 32315 AND `CategoriesKplusfaq`.`category_id` = `Category`.`id`)
1
1
2
maybe slow
SELECT `Kplusfeed`.`id`, `Kplusfeed`.`name`, `Kplusfeed`.`url`, `Kplusfeed`.`active`, `Kplusfeed`.`created`, `Kplusfeed`.`meta_title`, `Kplusfeed`.`meta_keywords`, `Kplusfeed`.`meta_descriptions`, `Kplusfeed`.`anons`, `Kplusfeed`.`text`, `Kplusfeed`.`category`, `Kplusfeed`.`tematika`, `Kplusfeed`.`counter`, `Kplusfeed`.`schetchik_posewenij`, `Kplusfeed`.`hit`, `Kplusfeed`.`anons_pic`, `Kplusfeed`.`author_id`, `Kplusfeed`.`schetchik_posewenij_ext`, `Kplusfeed`.`like`, `Kplusfeed`.`dislike`, `Kplusfeed`.`og_title`, `Kplusfeed`.`og_description`, `Kplusfeed`.`og_img`, `Author`.`id`, `Author`.`name`, `Author`.`post`, `Author`.`img`, `Author`.`img_dir`, `Author`.`public` FROM `ip`.`kplusfeeds` AS `Kplusfeed` LEFT JOIN `ip`.`authors` AS `Author` ON (`Kplusfeed`.`author_id` = `Author`.`id`) WHERE `Kplusfeed`.`active` = ‘1’ AND `Kplusfeed`.`created` <= ‘2021-01-15’ ORDER BY `Kplusfeed`.`created` desc LIMIT 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` = ‘Kplusfeed’ AND `Publication`.`page_id` = (31985) ORDER BY `Publication`.`position` asc
6
6
2
maybe slow
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`model`, `Favorite`.`page_id`, `Favorite`.`publicdate`, `Favorite`.`created` FROM `ip`.`favorites` AS `Favorite` WHERE `Favorite`.`model` = ‘Kplusfeed’ AND `Favorite`.`page_id` = (31985) ORDER BY `Favorite`.`publicdate` asc
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` = ‘Kplusfeed’ AND `Navigatorfeedback`.`page_id` = (31985)
29
maybe slow
SELECT `CategoriesKplusfeed`.`id`, `CategoriesKplusfeed`.`kplusfeed_id`, `CategoriesKplusfeed`.`category_id` FROM `ip`.`categories_kplusfeeds` AS `CategoriesKplusfeed` WHERE `CategoriesKplusfeed`.`kplusfeed_id` = (31985)
4
4
SELECT `KplusfeedsTheme`.`id`, `KplusfeedsTheme`.`kplusfeed_id`, `KplusfeedsTheme`.`theme_id` FROM `ip`.`kplusfeeds_themes` AS `KplusfeedsTheme` WHERE `KplusfeedsTheme`.`kplusfeed_id` = (31985)
2
2
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`, `KplusfeedsTheme`.`id`, `KplusfeedsTheme`.`kplusfeed_id`, `KplusfeedsTheme`.`theme_id` FROM `ip`.`themes` AS `Theme` JOIN `ip`.`kplusfeeds_themes` AS `KplusfeedsTheme` ON (`KplusfeedsTheme`.`kplusfeed_id` = 31985 AND `KplusfeedsTheme`.`theme_id` = `Theme`.`id`)
2
2
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`, `CategoriesKplusfeed`.`id`, `CategoriesKplusfeed`.`kplusfeed_id`, `CategoriesKplusfeed`.`category_id` FROM `ip`.`categories` AS `Category` JOIN `ip`.`categories_kplusfeeds` AS `CategoriesKplusfeed` ON (`CategoriesKplusfeed`.`kplusfeed_id` = 31985 AND `CategoriesKplusfeed`.`category_id` = `Category`.`id`)
4
4
SELECT `Docreview`.`id`, `Docreview`.`name`, `Docreview`.`active`, `Docreview`.`doc_name`, `Docreview`.`doc_text`, `Docreview`.`infbank_id`, `Docreview`.`link`, `Docreview`.`created`, `Docreview`.`express`, `Docreview`.`special`, `Docreview`.`schetchik_poyavlenie_na_stranice`, `Docreview`.`schetchik_otkryt_v_k`, `Docreview`.`schetchik_zakazat`, `Docreview`.`schetchik_otpravka_zakazat`, `Docreview`.`schetchik_vopros`, `Docreview`.`doctheme_id`, `Docreview`.`doc_date`, `Docreview`.`avtorskii`, `Docreview`.`manager_id`, `Docreview`.`category`, `Docreview`.`orgtype`, `Infbank`.`id`, `Infbank`.`name`, `Doctheme`.`id`, `Doctheme`.`name`, `Doctheme`.`filter`, `Manager`.`id`, `Manager`.`name`, `Manager`.`email`, `Manager`.`phone`, `Manager`.`active`, `Manager`.`password`, `Manager`.`department_id`, `Manager`.`UIN_1C`, `Manager`.`Up_date`, `Manager`.`tab_number`, `Manager`.`is_admin`, `Manager`.`role`, `Manager`.`img`, `Manager`.`img_dir` FROM `ip`.`docreviews` AS `Docreview` LEFT JOIN `ip`.`infbanks` AS `Infbank` ON (`Docreview`.`infbank_id` = `Infbank`.`id`) LEFT JOIN `ip`.`docthemes` AS `Doctheme` ON (`Docreview`.`doctheme_id` = `Doctheme`.`id`) LEFT JOIN `ip`.`managers` AS `Manager` ON (`Docreview`.`manager_id` = `Manager`.`id`) INNER JOIN `ip`.`categories_docreviews` AS `CategoriesDocreview` ON (`CategoriesDocreview`.`category_id` = (‘1’) AND `CategoriesDocreview`.`docreview_id` = `Docreview`.`id`) WHERE `Docreview`.`active` = ‘1’ AND `Docreview`.`created` <= ‘2021-01-15’ ORDER BY `Docreview`.`created` desc LIMIT 2
2
2
8
maybe slow
SELECT `CategoriesDocreview`.`id`, `CategoriesDocreview`.`category_id`, `CategoriesDocreview`.`docreview_id` FROM `ip`.`categories_docreviews` AS `CategoriesDocreview` WHERE `CategoriesDocreview`.`docreview_id` IN (33595, 33618)
5
5
1
maybe slow
SELECT `DocreviewsOrgtype`.`id`, `DocreviewsOrgtype`.`orgtype_id`, `DocreviewsOrgtype`.`docreview_id` FROM `ip`.`docreviews_orgtypes` AS `DocreviewsOrgtype` WHERE `DocreviewsOrgtype`.`docreview_id` IN (33595, 33618)
3
3
1
maybe slow
SELECT `Orgtype`.`id`, `Orgtype`.`name`, `DocreviewsOrgtype`.`id`, `DocreviewsOrgtype`.`orgtype_id`, `DocreviewsOrgtype`.`docreview_id` FROM `ip`.`orgtypes` AS `Orgtype` JOIN `ip`.`docreviews_orgtypes` AS `DocreviewsOrgtype` ON (`DocreviewsOrgtype`.`docreview_id` IN (33595, 33618) AND `DocreviewsOrgtype`.`orgtype_id` = `Orgtype`.`id`)
3
3
2
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`, `CategoriesDocreview`.`id`, `CategoriesDocreview`.`category_id`, `CategoriesDocreview`.`docreview_id` FROM `ip`.`categories` AS `Category` JOIN `ip`.`categories_docreviews` AS `CategoriesDocreview` ON (`CategoriesDocreview`.`docreview_id` IN (33595, 33618) AND `CategoriesDocreview`.`category_id` = `Category`.`id`)
