SELECT sql_no_cache * FROM lis_languages     
executed on: 0.0003819465637207 sec.

SELECT sql_no_cache `path`  FROM lis_routes   WHERE 1 AND path="search" OR path LIKE("search/:%")   
executed on: 0.00045180320739746 sec.

SELECT sql_no_cache * FROM lis_routes as r LEFT JOIN lis_routes_to_modules as r2m ON r2m.route_id=r.id LEFT JOIN lis_modules as m ON m.id=r2m.module_id OR (m.broadcast=1 AND m.type="user")  WHERE 1 AND `m`.`status` ="1" AND r.path = "search" OR r.path LIKE("search:%")  GROUP BY `m`.`id`   ORDER BY LENGTH(path)  DESC,`m`.`ordering`  ASC 
executed on: 0.020105123519897 sec.

SELECT sql_no_cache `layout`  FROM lis_routes   WHERE 1 AND `path` ="search"   
executed on: 0.00037312507629395 sec.

SELECT sql_no_cache * FROM lis_menu_types   WHERE 1 AND `id` ="6"   
executed on: 0.00038504600524902 sec.

SELECT sql_no_cache MAX(depth)  FROM lis_menu   WHERE 1 AND `type` ="top_line"   
executed on: 0.00043416023254395 sec.

SELECT sql_no_cache `m0`.`name` as menu0Name,`m0`.`id` as menu0Id,`r0`.`path` as menu0Link,`r0`.`layout` as menu0Layout,`m0`.`params` as menu0Params,`m0`.`image` as menu0Image,`m0`.`page_title`  as menu0Page_title,`m0`.`banners`  as menu0Banners,`m0`.`parent_id` as menu0Parent,`m0`.`menu_type_id` as menu0Type_id,`m0`.`status` as menu0Status,`m0`.`ordering` as menu0Ordering,`m0`.`meta_description` as menu0Meta_description,`m0`.`meta_keywords` as menu0Meta_keywords FROM lis_menu as m0 LEFT JOIN lis_routes as r0 ON r0.id=m0.route_id  WHERE 1 AND `m0`.`type` ="top_line" AND `m0`.`depth` ="0"   ORDER BY `m0`.`ordering`  ASC,`m0`.`id`  ASC 
executed on: 0.00050497055053711 sec.

SELECT sql_no_cache * FROM lis_languages   WHERE 1 AND `status` ="1"   ORDER BY `id`  ASC 
executed on: 0.0003199577331543 sec.

SELECT sql_no_cache `art`.* ,`cat`.`name` as category_name FROM lis_content as art LEFT JOIN lis_content_category as cat ON art.category_id = cat.id  WHERE 1 AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:49' AND `art`.`id` ="297"   
executed on: 0.00040888786315918 sec.

SELECT sql_no_cache `c0`.`id` as cat0Id,`c0`.`name` as cat0Name,`c0`.`page` as cat0Page,`c0`.`status` as cat0Status,`c0`.`parent_id` as cat0Parent,`c0`.`has_articles` as cat0Has_articles,`c1`.`id` as cat1Id,`c1`.`name` as cat1Name,`c1`.`page` as cat1Page,`c1`.`status` as cat1Status,`c1`.`parent_id` as cat1Parent,`c1`.`has_articles` as cat1Has_articles,`c2`.`id` as cat2Id,`c2`.`name` as cat2Name,`c2`.`page` as cat2Page,`c2`.`status` as cat2Status,`c2`.`parent_id` as cat2Parent,`c2`.`has_articles` as cat2Has_articles,`c3`.`id` as cat3Id,`c3`.`name` as cat3Name,`c3`.`page` as cat3Page,`c3`.`status` as cat3Status,`c3`.`parent_id` as cat3Parent,`c3`.`has_articles` as cat3Has_articles,`c4`.`id` as cat4Id,`c4`.`name` as cat4Name,`c4`.`page` as cat4Page,`c4`.`status` as cat4Status,`c4`.`parent_id` as cat4Parent,`c4`.`has_articles` as cat4Has_articles,`c5`.`id` as cat5Id,`c5`.`name` as cat5Name,`c5`.`page` as cat5Page,`c5`.`status` as cat5Status,`c5`.`parent_id` as cat5Parent,`c5`.`has_articles` as cat5Has_articles,`c6`.`id` as cat6Id,`c6`.`name` as cat6Name,`c6`.`page` as cat6Page,`c6`.`status` as cat6Status,`c6`.`parent_id` as cat6Parent,`c6`.`has_articles` as cat6Has_articles,`c7`.`id` as cat7Id,`c7`.`name` as cat7Name,`c7`.`page` as cat7Page,`c7`.`status` as cat7Status,`c7`.`parent_id` as cat7Parent,`c7`.`has_articles` as cat7Has_articles FROM lis_content_category as c0 LEFT JOIN lis_content_category as c1 ON c1.parent_id=c0.id LEFT JOIN lis_content_category as c2 ON c2.parent_id=c1.id LEFT JOIN lis_content_category as c3 ON c3.parent_id=c2.id LEFT JOIN lis_content_category as c4 ON c4.parent_id=c3.id LEFT JOIN lis_content_category as c5 ON c5.parent_id=c4.id LEFT JOIN lis_content_category as c6 ON c6.parent_id=c5.id LEFT JOIN lis_content_category as c7 ON c7.parent_id=c6.id  WHERE 1 AND `c0`.`parent_id` ="0"   ORDER BY `c0`.`id`  ASC,`c1`.`id`  ASC,`c2`.`id`  ASC,`c3`.`id`  ASC,`c4`.`id`  ASC,`c5`.`id`  ASC,`c6`.`id`  ASC,`c7`.`id`  ASC 
executed on: 0.044037103652954 sec.

SELECT m.params as params, r.path as link FROM `lis_menu` as m join `lis_routes` as r ON m.route_id = r.id WHERE m.params LIKE '%type=article%' 
executed on: 0.00039815902709961 sec.

SELECT m.params as params, r.path as link FROM `lis_menu` as m join `lis_routes` as r ON m.route_id = r.id WHERE m.params LIKE '%type=category%' 
executed on: 0.00028800964355469 sec.

SELECT sql_no_cache MIN(c.date)  FROM lis_content as c LEFT JOIN lis_content_category as cat ON cat.id = c.category_id  WHERE 1 AND `c`.`search` ="1" AND c.date>0   
executed on: 0.050220012664795 sec.

SELECT sql_no_cache MAX(c.date)  FROM lis_content as c LEFT JOIN lis_content_category as cat ON cat.id = c.category_id  WHERE 1 AND `c`.`search` ="1"   
executed on: 0.046791076660156 sec.

SELECT DISTINCT d.id,d.name FROM `lis_content_to_departments` as c_to_d LEFT JOIN lis_departments as d on d.id=c_to_d.department_id WHERE d.status=1 ORDER BY d.ordering DESC,d.id DESC
executed on: 0.00017976760864258 sec.

SELECT sql_no_cache * FROM lis_menu_types   WHERE 1 AND `id` ="1"   
executed on: 0.00031900405883789 sec.

SELECT sql_no_cache MAX(depth)  FROM lis_menu   WHERE 1 AND `type` ="top_menu"   
executed on: 0.00041890144348145 sec.

SELECT sql_no_cache `m0`.`name` as menu0Name,`m0`.`id` as menu0Id,`r0`.`path` as menu0Link,`r0`.`layout` as menu0Layout,`m0`.`params` as menu0Params,`m0`.`image` as menu0Image,`m0`.`page_title`  as menu0Page_title,`m0`.`banners`  as menu0Banners,`m0`.`parent_id` as menu0Parent,`m0`.`menu_type_id` as menu0Type_id,`m0`.`status` as menu0Status,`m0`.`ordering` as menu0Ordering,`m0`.`meta_description` as menu0Meta_description,`m0`.`meta_keywords` as menu0Meta_keywords,`m1`.`name` as menu1Name,`m1`.`id` as menu1Id,`r1`.`path` as menu1Link,`r1`.`layout` as menu1Layout,`m1`.`params` as menu1Params,`m1`.`page_title` as menu1Page_title,`m1`.`banners` as menu1Banners,`m1`.`image` as menu1Image,`m1`.`parent_id` as menu1Parent,`m1`.`menu_type_id` as menu1Type_id,`m1`.`status` as menu1Status,`m1`.`ordering` as menu1Ordering,`m1`.`meta_description` as menu1Meta_description,`m1`.`meta_keywords` as menu1Meta_keywords,`m2`.`name` as menu2Name,`m2`.`id` as menu2Id,`r2`.`path` as menu2Link,`r2`.`layout` as menu2Layout,`m2`.`params` as menu2Params,`m2`.`page_title` as menu2Page_title,`m2`.`banners` as menu2Banners,`m2`.`image` as menu2Image,`m2`.`parent_id` as menu2Parent,`m2`.`menu_type_id` as menu2Type_id,`m2`.`status` as menu2Status,`m2`.`ordering` as menu2Ordering,`m2`.`meta_description` as menu2Meta_description,`m2`.`meta_keywords` as menu2Meta_keywords,`m3`.`name` as menu3Name,`m3`.`id` as menu3Id,`r3`.`path` as menu3Link,`r3`.`layout` as menu3Layout,`m3`.`params` as menu3Params,`m3`.`page_title` as menu3Page_title,`m3`.`banners` as menu3Banners,`m3`.`image` as menu3Image,`m3`.`parent_id` as menu3Parent,`m3`.`menu_type_id` as menu3Type_id,`m3`.`status` as menu3Status,`m3`.`ordering` as menu3Ordering,`m3`.`meta_description` as menu3Meta_description,`m3`.`meta_keywords` as menu3Meta_keywords FROM lis_menu as m0 LEFT JOIN lis_routes as r0 ON r0.id=m0.route_id LEFT JOIN lis_menu as m1 ON m1.parent_id=m0.id LEFT JOIN lis_routes as r1 ON r1.id=m1.route_id LEFT JOIN lis_menu as m2 ON m2.parent_id=m1.id LEFT JOIN lis_routes as r2 ON r2.id=m2.route_id LEFT JOIN lis_menu as m3 ON m3.parent_id=m2.id LEFT JOIN lis_routes as r3 ON r3.id=m3.route_id  WHERE 1 AND `m0`.`type` ="top_menu" AND `m0`.`depth` ="0"   ORDER BY `m0`.`ordering`  ASC,`m0`.`id`  ASC,`m1`.`ordering`  ASC,`m2`.`ordering`  ASC,`m3`.`ordering`  ASC 
executed on: 0.030564069747925 sec.

SELECT sql_no_cache `m`.`type`  FROM lis_routes as r LEFT JOIN lis_menu as m ON r.id=m.route_id  WHERE 1 AND `r`.`path` ="search"   
executed on: 0.00042390823364258 sec.

SELECT sql_no_cache `m`.* ,`r`.`layout` ,`r`.`path` as link,`m`.`parent_id` as parent FROM lis_routes as r LEFT JOIN lis_menu as m ON r.id=m.route_id  WHERE 1 AND `r`.`path` ="search"   
executed on: 0.00038385391235352 sec.

SELECT sql_no_cache MAX(depth)  FROM lis_menu   WHERE 1 AND `type` ="hidden"   
executed on: 0.00032377243041992 sec.

SELECT sql_no_cache `m0`.`name` as menu0Name,`m0`.`id` as menu0Id,`r0`.`path` as menu0Link,`r0`.`layout` as menu0Layout,`m0`.`params` as menu0Params,`m0`.`image` as menu0Image,`m0`.`page_title`  as menu0Page_title,`m0`.`banners`  as menu0Banners,`m0`.`parent_id` as menu0Parent,`m0`.`menu_type_id` as menu0Type_id,`m0`.`status` as menu0Status,`m0`.`ordering` as menu0Ordering,`m0`.`meta_description` as menu0Meta_description,`m0`.`meta_keywords` as menu0Meta_keywords,`m1`.`name` as menu1Name,`m1`.`id` as menu1Id,`r1`.`path` as menu1Link,`r1`.`layout` as menu1Layout,`m1`.`params` as menu1Params,`m1`.`page_title` as menu1Page_title,`m1`.`banners` as menu1Banners,`m1`.`image` as menu1Image,`m1`.`parent_id` as menu1Parent,`m1`.`menu_type_id` as menu1Type_id,`m1`.`status` as menu1Status,`m1`.`ordering` as menu1Ordering,`m1`.`meta_description` as menu1Meta_description,`m1`.`meta_keywords` as menu1Meta_keywords FROM lis_menu as m0 LEFT JOIN lis_routes as r0 ON r0.id=m0.route_id LEFT JOIN lis_menu as m1 ON m1.parent_id=m0.id LEFT JOIN lis_routes as r1 ON r1.id=m1.route_id  WHERE 1 AND `m0`.`type` ="hidden" AND `m0`.`depth` ="0"   ORDER BY `m0`.`ordering`  ASC,`m0`.`id`  ASC,`m1`.`ordering`  ASC 
executed on: 0.019156932830811 sec.

SELECT sql_no_cache COUNT(DISTINCT c.id) FROM lis_content as c LEFT JOIN lis_keywords_to_content as k_to_c ON c.id = k_to_c.content_id  WHERE 1 AND `c`.`category_id`  IN (0,1,59,61,77,78,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,135,136,137,138,139,140,141,142,143,144,145,146,147,222,225,103,172,104,106,148,149,216,154,62,63,65,66,105,109,110,67,183,70,107,108,111,129,130,131,132,133,134,150,152,153,151,155,156,157,158,159,160,161,162,163,204,215,112,113,114,115,116,117,118,119,120,121,208,122,167,168,169,170,171,224,123,173,174,175,176,124,125,164,165,166,128,177,178,179,180,181,182,184,185,186,187,192,189,196,190,201,191,197,193,198,194,199,195,200,202,203,209,210,211,212,213,214,217,218,219,60,79,220,221) AND `c`.`status` ="1" AND c.active_from<='2021-04-22 23:49' AND `c`.`search` ="1" AND k_to_c.keywords_id='192'   
executed on: 0.001492977142334 sec.

SELECT sql_no_cache `c`.* ,`cat`.`name` as category_name FROM lis_content as c LEFT JOIN lis_content_category as cat ON cat.id = c.category_id LEFT JOIN lis_keywords_to_content as k_to_c ON c.id = k_to_c.content_id  WHERE 1 AND `c`.`category_id`  IN (0,1,59,61,77,78,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,135,136,137,138,139,140,141,142,143,144,145,146,147,222,225,103,172,104,106,148,149,216,154,62,63,65,66,105,109,110,67,183,70,107,108,111,129,130,131,132,133,134,150,152,153,151,155,156,157,158,159,160,161,162,163,204,215,112,113,114,115,116,117,118,119,120,121,208,122,167,168,169,170,171,224,123,173,174,175,176,124,125,164,165,166,128,177,178,179,180,181,182,184,185,186,187,192,189,196,190,201,191,197,193,198,194,199,195,200,202,203,209,210,211,212,213,214,217,218,219,60,79,220,221) AND `c`.`search` ="1" AND `c`.`status` ="1" AND c.active_from<='2021-04-22 23:49' AND k_to_c.keywords_id='192'  GROUP BY `c`.`id`   ORDER BY `c`.`date`  DESC  LIMIT 0, 16
executed on: 0.029443979263306 sec.

PREPARE dp_query FROM "SELECT DISTINCT `d`.`id` ,`d`.`name`  
                FROM lis_content_to_departments as c_to_d 
                LEFT JOIN lis_departments as d 
                ON d.id = c_to_d.department_id  
                WHERE 1 AND d.status=1 AND `c_to_d`.`content_id` =?"
executed on: 0.00026607513427734 sec.

SET @id=4634
executed on: 0.00019598007202148 sec.

EXECUTE dp_query USING @id
executed on: 0.0015659332275391 sec.

SET @id=4633
executed on: 0.00023508071899414 sec.

EXECUTE dp_query USING @id
executed on: 0.00035285949707031 sec.

SET @id=4631
executed on: 0.00012016296386719 sec.

EXECUTE dp_query USING @id
executed on: 0.0001380443572998 sec.

SET @id=4626
executed on: 0.00011301040649414 sec.

EXECUTE dp_query USING @id
executed on: 0.0001070499420166 sec.

SET @id=4620
executed on: 0.00010085105895996 sec.

EXECUTE dp_query USING @id
executed on: 0.00010085105895996 sec.

SET @id=4618
executed on: 9.918212890625E-5 sec.

EXECUTE dp_query USING @id
executed on: 8.7976455688477E-5 sec.

SET @id=4387
executed on: 0.00011801719665527 sec.

EXECUTE dp_query USING @id
executed on: 9.3936920166016E-5 sec.

SET @id=4367
executed on: 8.5830688476562E-5 sec.

EXECUTE dp_query USING @id
executed on: 9.2029571533203E-5 sec.

SET @id=4342
executed on: 9.2029571533203E-5 sec.

EXECUTE dp_query USING @id
executed on: 9.2029571533203E-5 sec.

SET @id=4244
executed on: 8.6069107055664E-5 sec.

EXECUTE dp_query USING @id
executed on: 9.1075897216797E-5 sec.

SET @id=4242
executed on: 8.702278137207E-5 sec.

EXECUTE dp_query USING @id
executed on: 9.1075897216797E-5 sec.

SET @id=4241
executed on: 8.702278137207E-5 sec.

EXECUTE dp_query USING @id
executed on: 8.5830688476562E-5 sec.

SET @id=4240
executed on: 8.702278137207E-5 sec.

EXECUTE dp_query USING @id
executed on: 8.9883804321289E-5 sec.

SET @id=4237
executed on: 8.9883804321289E-5 sec.

EXECUTE dp_query USING @id
executed on: 8.6784362792969E-5 sec.

SET @id=4234
executed on: 8.082389831543E-5 sec.

EXECUTE dp_query USING @id
executed on: 8.2969665527344E-5 sec.

SET @id=4231
executed on: 8.2015991210938E-5 sec.

EXECUTE dp_query USING @id
executed on: 8.2969665527344E-5 sec.

DEALLOCATE PREPARE dp_query
executed on: 8.3208084106445E-5 sec.

SELECT sql_no_cache `art`.* ,`cat`.`name` as category_name FROM lis_content as art LEFT JOIN lis_content_category as cat ON art.category_id = cat.id  WHERE 1 AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:49' AND `art`.`id` ="29892" AND art.date>='2021-04-22'   
executed on: 0.00027203559875488 sec.

SELECT sql_no_cache `art`.* ,`cat`.`name` as category_name,`cat`.`id` as category_id FROM lis_content as art LEFT JOIN lis_content_category as cat ON cat.id = art.category_id  WHERE 1 AND `art`.`category_id`  IN (128,128) AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:49'  GROUP BY `art`.`id`   ORDER BY `art`.`date`  ASC,`art`.`ordering`  ASC,`art`.`date`  DESC,`art`.`id`  DESC 
executed on: 0.055645942687988 sec.

PREPARE dp_query FROM "SELECT DISTINCT `d`.`id` ,`d`.`name`  
                FROM lis_content_to_departments as c_to_d 
                LEFT JOIN lis_departments as d 
                ON d.id = c_to_d.department_id  
                WHERE 1 AND `c_to_d`.`content_id` =? AND d.status=1"
executed on: 0.00020122528076172 sec.

SET @id=1098
executed on: 0.0001680850982666 sec.

EXECUTE dp_query USING @id
executed on: 0.00016403198242188 sec.

SET @id=1335
executed on: 0.00015687942504883 sec.

EXECUTE dp_query USING @id
executed on: 0.00016212463378906 sec.

SET @id=4182
executed on: 0.00011301040649414 sec.

EXECUTE dp_query USING @id
executed on: 0.00011587142944336 sec.

SET @id=4184
executed on: 0.00011205673217773 sec.

EXECUTE dp_query USING @id
executed on: 0.00011110305786133 sec.

SET @id=4235
executed on: 9.8943710327148E-5 sec.

EXECUTE dp_query USING @id
executed on: 0.00010490417480469 sec.

SET @id=4604
executed on: 0.00010585784912109 sec.

EXECUTE dp_query USING @id
executed on: 0.00010585784912109 sec.

DEALLOCATE PREPARE dp_query
executed on: 0.00010085105895996 sec.

SELECT sql_no_cache `k`.`id` ,`k`.`name` ,COUNT(k_to_c.id) as count FROM lis_keywords as k LEFT JOIN lis_keywords_to_content as k_to_c ON k_to_c.keywords_id=k.id  WHERE 1 AND `k`.`language_abbr` ="ua" AND k.id not in(312,180,20,219,208,588,363,559)  GROUP BY `k`.`id`   ORDER BY `count`  DESC  LIMIT 0, 20
executed on: 0.047615766525269 sec.

SELECT sql_no_cache `art`.* ,`cat`.`name` as category_name FROM lis_content as art LEFT JOIN lis_content_category as cat ON art.category_id = cat.id  WHERE 1 AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:49' AND `art`.`id` ="10306"   
executed on: 0.00038814544677734 sec.

SELECT sql_no_cache `art`.* ,`cat`.`name` as category_name FROM lis_content as art LEFT JOIN lis_content_category as cat ON art.category_id = cat.id  WHERE 1 AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:49' AND `art`.`id` ="3263"   
executed on: 0.00034403800964355 sec.

SELECT sql_no_cache `d`.`id` as id,`d`.`name` as name FROM lis_content_to_departments as c_to_d LEFT JOIN lis_departments as d ON d.id = c_to_d.department_id  WHERE 1 AND `c_to_d`.`content_id` ="3263"  GROUP BY `d`.`id`   
executed on: 0.0004580020904541 sec.

SELECT sql_no_cache * FROM lis_banners   WHERE 1 AND `position` ="left" AND `status` ="1"   ORDER BY `ordering`  ASC,`id`  DESC 
executed on: 0.00033092498779297 sec.

SELECT sql_no_cache * FROM lis_banners   WHERE 1 AND `position` ="bottom" AND `status` ="1"   ORDER BY `ordering`  ASC,`id`  DESC 
executed on: 0.00053691864013672 sec.

SELECT sql_no_cache `art`.* ,`cat`.`name` as category_name,`cat`.`id` as category_id FROM lis_content as art LEFT JOIN lis_content_category as cat ON cat.id = art.category_id  WHERE 1 AND `art`.`category_id`  IN () AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:49' AND art.date>='2021-04-22'  GROUP BY `art`.`id`   ORDER BY `art`.`date`  ASC,`art`.`ordering`  ASC,`art`.`date`  DESC,`art`.`id`  DESC 
executed on: 0.00019001960754395 sec.

PREPARE dp_query FROM "SELECT DISTINCT `d`.`id` ,`d`.`name`  
                FROM lis_content_to_departments as c_to_d 
                LEFT JOIN lis_departments as d 
                ON d.id = c_to_d.department_id  
                WHERE 1 AND `c_to_d`.`content_id` =? AND d.status=1"
executed on: 0.00025606155395508 sec.

DEALLOCATE PREPARE dp_query
executed on: 0.00017189979553223 sec.

SELECT sql_no_cache * FROM lis_settings     
executed on: 0.00027608871459961 sec.

SELECT sql_no_cache * FROM lis_settings     
executed on: 0.00025391578674316 sec.

SELECT sql_no_cache * FROM lis_settings     
executed on: 0.00030303001403809 sec.

Application
executed on: 0.41481614112854 sec.