Лісогосподарська діяльність

Основні показники господарської діяльності Львівського ОУЛМГ

12 вересня 2010р, Лісогосподарська діяльність.
Прес-служба

Переглядів: 620

Рубки формування і оздоровлення лісів

12 вересня 2010р, Рубки формування і оздоровлення лісів.
Прес-служба

Переглядів: 3979

Рубки головного користування

12 вересня 2010р, Рубки головного користування.
Прес-служба

Переглядів: 1199

Оголошення
Ключові слова
Розпорядження від 01.12.2015р. N18

Ми у Facebook

Відео

Лісогосподарська діяльність
SELECT sql_no_cache * FROM lis_languages     
executed on: 0.00034189224243164 sec.

SELECT sql_no_cache `path` FROM lis_routes WHERE 1 AND path="lisogospodars_ka_diyalnist" OR path LIKE("lisogospodars_ka_diyalnist/:%")
executed on: 0.00044012069702148 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 = "lisogospodars_ka_diyalnist" OR r.path LIKE("lisogospodars_ka_diyalnist:%") GROUP BY `m`.`id` ORDER BY LENGTH(path) DESC,`m`.`ordering` ASC
executed on: 0.015220165252686 sec.

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

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

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

SELECT sql_no_cache * FROM lis_languages WHERE 1 AND `status` ="1" ORDER BY `id` ASC
executed on: 0.00034880638122559 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:09' AND `art`.`id` ="297"
executed on: 0.00064921379089355 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.029430866241455 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.00051593780517578 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.00046801567077637 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.048049926757812 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.047421932220459 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.0003349781036377 sec.

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

SELECT sql_no_cache MAX(depth) FROM lis_menu WHERE 1 AND `type` ="top_menu"
executed on: 0.00042009353637695 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` ="lisogospodars_ka_diyalnist"
executed on: 0.00056195259094238 sec.

SELECT sql_no_cache * FROM lis_content_category WHERE 1 AND `id` ="150"
executed on: 0.00037884712219238 sec.

SELECT MIN(`date`) as 'min',MAX(`date`) as 'max' FROM `lis_content` where `date`>0 AND `category_id` in(150,150,152,153)
executed on: 0.043699979782104 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.00018095970153809 sec.

SELECT sql_no_cache count( DISTINCT art.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 (150,150,152,153) AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:09' AND art.date>='2010-09-12 00:00' AND art.date<='2010-09-12 23:59'
executed on: 0.039957046508789 sec.

SELECT sql_no_cache `art`.* ,`cat`.`name` as category_name,`cat`.`id` as category_id,`visitors` 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 (150,150,152,153) AND `art`.`status` ="1" AND art.active_from<='2021-04-22 23:09' AND art.date>='2010-09-12 00:00' AND art.date<='2010-09-12 23:59' GROUP BY `art`.`id` ORDER BY `art`.`ordering` ASC,`art`.`date` DESC,`art`.`id` DESC LIMIT 0, 15
executed on: 0.054521083831787 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.00020503997802734 sec.

SET @id=401
executed on: 0.00016999244689941 sec.

EXECUTE dp_query USING @id
executed on: 0.00033998489379883 sec.

SET @id=400
executed on: 0.00014305114746094 sec.

EXECUTE dp_query USING @id
executed on: 0.00022792816162109 sec.

SET @id=399
executed on: 0.00014805793762207 sec.

EXECUTE dp_query USING @id
executed on: 0.00022196769714355 sec.

DEALLOCATE PREPARE dp_query
executed on: 0.00021195411682129 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:09' AND `art`.`id` ="29892" AND art.date>='2021-04-22'
executed on: 0.00051307678222656 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:09' GROUP BY `art`.`id` ORDER BY `art`.`date` ASC,`art`.`ordering` ASC,`art`.`date` DESC,`art`.`id` DESC
executed on: 0.054018020629883 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.00027704238891602 sec.

SET @id=1098
executed on: 0.00019311904907227 sec.

EXECUTE dp_query USING @id
executed on: 0.00020003318786621 sec.

SET @id=1335
executed on: 0.00023198127746582 sec.

EXECUTE dp_query USING @id
executed on: 0.00020813941955566 sec.

SET @id=4182
executed on: 0.00021910667419434 sec.

EXECUTE dp_query USING @id
executed on: 0.0001680850982666 sec.

SET @id=4184
executed on: 0.00012898445129395 sec.

EXECUTE dp_query USING @id
executed on: 0.00018596649169922 sec.

SET @id=4235
executed on: 0.00017499923706055 sec.

EXECUTE dp_query USING @id
executed on: 0.00017809867858887 sec.

SET @id=4604
executed on: 0.00012516975402832 sec.

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

DEALLOCATE PREPARE dp_query
executed on: 9.3936920166016E-5 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.047497987747192 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:09' AND `art`.`id` ="10306"
executed on: 0.00045895576477051 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:09' AND `art`.`id` ="3263"
executed on: 0.00045418739318848 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.00038599967956543 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.0004889965057373 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:09' 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.00025701522827148 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.00029110908508301 sec.

DEALLOCATE PREPARE dp_query
executed on: 0.00030803680419922 sec.

SELECT sql_no_cache * FROM lis_settings
executed on: 0.00035190582275391 sec.

SELECT sql_no_cache * FROM lis_settings
executed on: 0.00034809112548828 sec.

SELECT sql_no_cache * FROM lis_settings
executed on: 0.0003359317779541 sec.

Application
executed on: 0.48851704597473 sec.