Информация об выполнении показателей экономической и социальной эффективности реализации краевой целевой программы «Культура Алтайского края» на 2011 -2015 годы Панкрушихинский район 3 квартал 2014 г.

  • **Печать**
**Подробности**
**Категория: Культурно-библиотечный центр**
**Опубликовано **31.10.2014 04:33****
**Автор: Администратор**
**Просмотров: 614**

Информация о выполнении показателей экономической и социальной эффективности реализации краевой целевой программы «Культура Алтайского края»

на 2011 -2015 годы

Панкрушихинский район, 3 квартал 2014 г.

 

№

Целевые показатели

Единица

измерения

2013 год

2014год

1.

Количество новых изданий, поступивших в библиотечные фонды

тыс. экз.

561

420

 

Доля новых поступлений в общем фонде библиотек

%

0,37

0,28

2.

Количество экземпляров библиотечного фонда на 1000 чел. населения

тыс. экз.

11,63

11,63

3.

Объем собственных электронных баз данных с нарастанием

тыс. записей

8418

8760

 

Увеличение к уровню прошлого года

%

13,5

4,06

4.

Число посещений муниципальных библиотек

тыс. чел.

70120

57456

 

Увеличение числа посещений к уровню прошлого года

%

-5,2

-18,06

5.

Число детей в городе до 14 лет

тыс. чел.

2289

2287

6.

Число читателей в возрасте до 14 лет

тыс. чел.

1676

1313

7.

Их доля в общей численности детей

%

71,9

57,4

8.

Число жителей

тыс. чел.

12774

12744

9.

Число читателей

тыс. чел.

4802

4593

10.

Книговыдача

тыс. чел.

156646

129882

11.

Книжный фонд

тыс. чел.

148581

147845

12.

Количество списанных документов

тыс. экз.

390

225

 

 

Зам.директора по библиотечной работе

МКУК «Культурно-библиотечный центр»

Панкрушихинского района Алтайского края                                                С.В.Гончарова

**Результаты профилирования**

Application 0.000 seconds (+0.000); 0.34 MB (+0.344) - afterLoad
Application 0.571 seconds (+0.571); 1.46 MB (+1.117) - afterInitialise
Application 1.723 seconds (+1.152); 7.05 MB (+5.592) - afterRoute
Application 2.359 seconds (+0.636); 8.36 MB (+1.307) - afterDispatch
Application 2.372 seconds (+0.014); 8.45 MB (+0.086) - afterRender

**Использование памяти**

8.48 MB (8,890,560 Bytes)

**26 SQL-запросов зафиксировано**

  1. SELECT `data`
      FROM `eiw83_session`
      WHERE `session_id` = '91b7c64035b48578fa0457496c85675a'
  2. DELETE
      FROM `eiw83_session`
      WHERE `time` < 1749440133
  3. SELECT folder AS type, element AS name, params
      FROM eiw83_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kunena'
  6. select id, title, alias
      from eiw83_jumi
      where published = 1
  7. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM eiw83_menu AS m
      LEFT JOIN eiw83_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      AND m.access IN (1,1)
      ORDER BY m.lft
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  9. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM eiw83_categories as c
      LEFT JOIN eiw83_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM eiw83_categories AS cat JOIN eiw83_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=2643
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  10. SELECT alias, catid
      FROM eiw83_content
      WHERE id = 2643
  11. SELECT b.rules
      FROM eiw83_assets AS a
      LEFT JOIN eiw83_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
      ORDER BY b.lft
  12. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  13. SELECT *
      FROM eiw83_jcomments_settings
  14. SELECT id, home, template, s.params
      FROM eiw83_template_styles as s
      LEFT JOIN eiw83_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
  15. SELECT *
      FROM eiw83_languages
      WHERE published=1
      ORDER BY ordering ASC
  16. SELECT b.rules
      FROM eiw83_assets AS a
      LEFT JOIN eiw83_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  17. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM eiw83_content AS a
      LEFT JOIN eiw83_categories AS c
      on c.id = a.catid
      LEFT JOIN eiw83_users AS u
      on u.id = a.created_by
      LEFT JOIN eiw83_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN eiw83_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN eiw83_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM eiw83_categories AS cat JOIN eiw83_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 2643
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-09 03:50:34')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-09 03:50:34')
      AND (a.state = 1 OR a.state =2)
  18. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM eiw83_categories as c
      LEFT JOIN eiw83_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM eiw83_categories AS cat JOIN eiw83_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=103
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  19. SHOW FULL COLUMNS
      FROM `eiw83_users`
  20. SELECT *
      FROM eiw83_users
      WHERE id = 42
  21. SELECT g.id, g.title
      FROM eiw83_usergroups AS g JOIN eiw83_user_usergroup_map AS m
      ON m.group_id = g.id
      WHERE m.user_id = 42
  22. SELECT b.id
      FROM eiw83_user_usergroup_map AS map
      LEFT JOIN eiw83_usergroups AS a
      ON a.id = map.group_id
      LEFT JOIN eiw83_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE map.user_id = 42
  23. SELECT *
      FROM eiw83_fsj_plg_plugin
      WHERE type = 'include'
  24. SELECT *
      FROM eiw83_fsj_includes_alias
      WHERE state = 1
  25. UPDATE eiw83_content
      SET hits = hits + 1
      WHERE id = 2643
  26. UPDATE `eiw83_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1749441002;s:18:\"session.timer.last\";i:1749441028;s:17:\"session.timer.now\";i:1749441033;s:24:\"session.client.forwarded\";s:12:\"10.1.115.107\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:2:{s:40:\"3b6c140d4d915bcd799b0fbe9f407c6f90ffbcbd\";O:8:\"stdClass\":2:{s:4:\"link\";s:316:\"http://old.pankrushiha22.ru/index.php/strukturnye-podrazdeleniya-administratsii-pankrushikhinskogo-rajona/sotsialnaya-politika/sport/kultura/1431-altajskaya-gosudarstvennaya-akademiya-kultury-i-iskusstv-obyavlyaet-priem-dokumentov-dlya-postupleniya-na-napravlenie-podgotovki-bibliotechno-informatsionnaya-deyatelnost\";s:6:\"expiry\";i:1749441003;}s:40:\"41e5d27041baec1933a54511f8cfdafce21d0870\";O:8:\"stdClass\":2:{s:4:\"link\";s:258:\"http://old.pankrushiha22.ru/index.php/strukturnye-podrazdeleniya-administratsii-pankrushikhinskogo-rajona/sotsialnaya-politika/sport/kultura/1940-informatsiya-o-provedennykh-meropriyatiyakh-v-mini-muzee-zdes-vse-moe-i-ya-otsyuda-rodom-pankrushikhinskij-rajon\";s:6:\"expiry\";i:1749441030;}}}', `time` = 1749441035
      WHERE `session_id` = '91b7c64035b48578fa0457496c85675a'

**21 типов SQL-запросов зафиксировано, отсортировано по вхождениям**

**Запросы типа SELECT:**
  1. **4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM eiw83_extensions**
  2. **2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM eiw83_categories as c LEFT JOIN eiw83_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM eiw83_categories AS cat JOIN eiw83_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt**
  3. **2 × SELECT b.rules FROM eiw83_assets AS a LEFT JOIN eiw83_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt**
  4. **1 × SELECT * FROM eiw83_users**
  5. **1 × SELECT g.id, g.title FROM eiw83_usergroups AS g JOIN eiw83_user_usergroup_map AS m ON m.group_id = g.id**
  6. **1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM eiw83_content AS a LEFT JOIN eiw83_categories AS c on c.id = a.catid LEFT JOIN eiw83_users AS u on u.id = a.created_by LEFT JOIN eiw83_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN eiw83_categories as parent ON parent.id = c.parent_id LEFT JOIN eiw83_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM eiw83_categories AS cat JOIN eiw83_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt**
  7. **1 × SELECT b.id FROM eiw83_user_usergroup_map AS map LEFT JOIN eiw83_usergroups AS a ON a.id = map.group_id LEFT JOIN eiw83_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt**
  8. **1 × SELECT * FROM eiw83_fsj_includes_alias**
  9. **1 × SELECT * FROM eiw83_fsj_plg_plugin**
  10. **1 × SELECT * FROM eiw83_languages**
  11. **1 × SELECT * FROM eiw83_jcomments_setting**
  12. **1 × select id, title, alias from eiw83_jumi**
  13. **1 × SELECT folder AS type, element AS name, params FROM eiw83_extensions**
  14. **1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM eiw83_menu AS m LEFT JOIN eiw83_extensions AS e ON m.component_id = e.extension_id**
  15. **1 × SELECT alias, catid FROM eiw83_content**
  16. **1 × SELECT `data` FROM `eiw83_session`**
  17. **1 × SELECT id, home, template, s.params FROM eiw83_template_styles as s LEFT JOIN eiw83_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id**
**Прочие SQL-запросы:**
  1. **1 × UPDATE `eiw83_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1749441002;s:18:\"session.timer.last\";i:1749441028;s:17:\"session.timer.now\";i:1749441033;s:24:\"session.client.forwarded\";s:12:\"10.1.115.107\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:2:{s:40:\"3b6c140d4d915bcd799b0fbe9f407c6f90ffbcbd\";O:8:\"stdClass\":2:{s:4:\"link\";s:316:\"http://old.pankrushiha22.ru/index.php/strukturnye-podrazdeleniya-administratsii-pankrushikhinskogo-rajona/sotsialnaya-politika/sport/kultura/1431-altajskaya-gosudarstvennaya-akademiya-kultury-i-iskusstv-obyavlyaet-priem-dokumentov-dlya-postupleniya-na-napravlenie-podgotovki-bibliotechno-informatsionnaya-deyatelnost\";s:6:\"expiry\";i:1749441003;}s:40:\"41e5d27041baec1933a54511f8cfdafce21d0870\";O:8:\"stdClass\":2:{s:4:\"link\";s:258:\"http://old.pankrushiha22.ru/index.php/strukturnye-podrazdeleniya-administratsii-pankrushikhinskogo-rajona/sotsialnaya-politika/sport/kultura/1940-informatsiya-o-provedennykh-meropriyatiyakh-v-mini-muzee-zdes-vse-moe-i-ya-otsyuda-rodom-pankrushikhinskij-rajon\";s:6:\"expiry\";i:1749441030;}}}', `time` = 1749441035**
  2. **1 × UPDATE eiw83_content SET hits = hits + 1**
  3. **1 × SHOW FULL COLUMNS FROM `eiw83_users**
  4. **1 × DELETE FROM `eiw83_session`**

**Ошибки в языковых файлах**

**Не найдено**

**Загруженные языковые файлы**

**Непереведенные строки**

**Не найдено**