Решаем вместе
Не убран мусор, яма на дороге, не горит фонарь? Столкнулись с проблемой — сообщите о ней!
Жалобы, предложения? Пишите – разберемся!
?
Направляемые сообщения не являются обращениями граждан, рассматриваемыми в порядке, установленном Федеральным законом от 2 мая 2006 г. № 59-ФЗ «О порядке рассмотрения обращений граждан Российской Федерации».

Основные показатели развития животноводства в сельхозорганизациях, крестьянских (фермерских) хозяйствах и ИП Панкрушихинского района Алтайского края по состоянию на 01.10.2012 года

Основные показатели развития животноводства в сельхозорганизациях, крестьянских (фермерских) хозяйствах и ИП Панкрушихинского  района Алтайского края по состоянию на 01.10.2012 года (ежемесячно)
     
№ строки Показатели Ед. изм. на 1.10.12 г. на 1.10.11 г.  2012г к 2011г
+/- %
  1 2 3 4 5 6
1 Поголовье:   x x x x
2 КРС, всего гол. 3177 2999 178 105,9
3 в т. ч. коров гол. 1267 1248 19 101,5
4 из них молочного направления гол.        
5 свиней гол. 387 506 -119 76,5
6 овец гол. 90 45 45 200
7 лошадей гол. 293 280 13 104,6
8 птицы гол.        
9 маралов (ежеквартально) гол.        
10 оленей (ежеквартально) гол.        
11 зверей: (ежеквартально) гол.        
12 норка гол.        
13 песец гол.        
14 лиса гол.        
15 пчелосемей на нач. года шт.        
16 Продуктивность:   x x x x
17 удой на корову кг 1811 1896 -85 95,5
18 среднесуточный прирост:                      x x x x
19 КРС гр. 268 240 28 111,7
20 свиней гр. 209 202 7 103,5
21 яйценоскость кур шт.        
22 Производство:   x x x x
23 молока тонн 2271,8 3213,5 -941,7 70,7
24 выращивание мяса всего: тонн 213 157,9 55,1 134,9
25 в т. ч. КРС тонн 187,4 142 45,4 132
26 свиней тонн 25,6 15,9 9,7 161
27 мяса на убой (живой вес) тонн 221,5 157,6 63,9 140,5
28 яиц тыс. шт.        
29 Среднее поголовье:   x x x x
30 коров молочного направления гол.        
31 молодняка КРС гол.        
32 свиней на  выращивании и откорме гол.        
33 Товарность молока % 79,7 77 2,7 103,5
34 Товарность мяса %        
35 Получено приплода:   x x x x
36 телят гол. 1128 1257 -29 89,7
37 поросят гол. 248 223 25 111,2
38 ягнят гол.        
39 Получено приплода на 100 маток:   x x x x
40 телят гол. 73 80 -7 91,2
41 поросят гол.        
42 ягнят гол.        
43 Пало:   x x x x
44 КРС всего гол. 7 70 -63 10
45 в т. ч. телят текущего года гол. 5 57 -52 8,8
46 свиней гол. 26 14 12 185,7
47 овец гол.        
48 Пало к обороту стада:   x x x x
49 КРС % 0,1 1,6 -1,5 6,2
50 свиней % 6 5,5 1,5 109,1
51 овец %        
52 телят к народившимся % 0,4 4,9 -4,5 8,2
53 Наличие кормов всего тонн к. ед. x x x x
54 в т. ч. конц. корма тонн 1497 2158 -661 69,4
55 кормов всего на 1 усл. гол. ц к. ед. 15,4 23,8 -8,4 64,7
56 Сред. закуп. цены без НДС:   x x   x
57 молоко руб/кг 11,6 10,7 0,9 108,4
58 мясо КРС (живой вес) руб/кг 72 66 6 109,1
59 мясо свиней (живой вес) руб/кг 54 58,5 -4,5 92,3
             
Расчёт среднего поголовья:          
За январь  среднее поголовье = п.01.01 +п.01.02          
                                                                    2*1          
За январь-февраль  среднее поголовье = п.01.01 +(п.01.02)*2+п.01.03      
                                                                    2*2          
За январь-март  среднее поголовье = п.01.01 +(п.01.02+п.01.03)*2+п.01.04      
                                                                    2*3          
За январь-апрель среднее поголовье =  п.01.01 +(п.01.02+п.01.03+п.01.04)*2+п.01.05    
                                                                    2*4          
За январь-май среднее поголовье =  п.01.01 +(п.01.02+п.01.03+п.01.04+п.01.05)*2+п.01.06    
                                                                    2*5          
За январь-июнь среднее поголовье =  п.01.01 +(п.01.02+п.01.03+п.01.04+п.01.05+п.01.06)*2+п.01.07  
                                                                    2*6          
И тому подобное за 7,8,9,10,11,12 месяцев, где п. - поголовье.        

**Комментарии**   

 
0 #1 Andrew **17.11.2012 11:08**
Вот это правильно, статистику надо периодически выкладывать в открытый доступ. Глядишь, начнут появляться исследовательск ие работы на эту тему :-)
**Цитировать** | **Сообщить модератору**
 

**Добавить комментарий**


**Защитный код**
**Обновить**

**Дополнительная информация**

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

Application 0.000 seconds (+0.000); 0.34 MB (+0.339) - afterLoad
Application 0.779 seconds (+0.779); 1.42 MB (+1.083) - afterInitialise
Application 1.647 seconds (+0.869); 7.01 MB (+5.583) - afterRoute
Application 2.571 seconds (+0.923); 8.35 MB (+1.345) - afterDispatch
Application 2.631 seconds (+0.060); 8.55 MB (+0.203) - beforeRenderModule mod_banners (Баннеры Панкрушихи)
Application 2.798 seconds (+0.167); 8.61 MB (+0.061) - afterRenderModule mod_banners (Баннеры Панкрушихи)
Application 2.799 seconds (+0.001); 8.61 MB (-0.005) - beforeRenderModule mod_banners (В позиции 10)
Application 3.020 seconds (+0.221); 8.62 MB (+0.011) - afterRenderModule mod_banners (В позиции 10)
Application 3.021 seconds (+0.001); 8.61 MB (-0.008) - beforeRenderModule mod_banners (В позиции 9)
Application 3.297 seconds (+0.276); 8.63 MB (+0.016) - afterRenderModule mod_banners (В позиции 9)
Application 3.298 seconds (+0.001); 8.62 MB (-0.007) - beforeRenderModule mod_articles_news (Основные события года)
Application 3.429 seconds (+0.131); 8.75 MB (+0.129) - afterRenderModule mod_articles_news (Основные события года)
Application 3.430 seconds (+0.001); 8.68 MB (-0.069) - beforeRenderModule mod_custom (https://www.altairegion22.ru/anketa2016/)
Application 3.431 seconds (+0.001); 8.69 MB (+0.009) - afterRenderModule mod_custom (https://www.altairegion22.ru/anketa2016/)
Application 3.431 seconds (+0.000); 8.67 MB (-0.020) - beforeRenderModule mod_menu (Меню сайта)
Application 3.443 seconds (+0.012); 8.74 MB (+0.075) - afterRenderModule mod_menu (Меню сайта)
Application 3.443 seconds (+0.000); 8.74 MB (-0.008) - beforeRenderModule mod_banners (В позиции 6)
Application 3.884 seconds (+0.441); 8.76 MB (+0.021) - afterRenderModule mod_banners (В позиции 6)
Application 3.884 seconds (+0.001); 8.76 MB (+0.005) - beforeRenderModule mod_breadcrumbs (Путь на сайте)
Application 3.886 seconds (+0.001); 8.79 MB (+0.024) - afterRenderModule mod_breadcrumbs (Путь на сайте)
Application 3.887 seconds (+0.001); 8.78 MB (-0.003) - beforeRenderModule mod_search (Поиск)
Application 3.888 seconds (+0.001); 8.82 MB (+0.035) - afterRenderModule mod_search (Поиск)
Application 3.889 seconds (+0.001); 8.81 MB (-0.006) - beforeRenderModule mod_menu (Верхнее меню)
Application 3.892 seconds (+0.003); 8.83 MB (+0.021) - afterRenderModule mod_menu (Верхнее меню)
Application 3.892 seconds (+0.001); 8.83 MB (-0.007) - beforeRenderModule mod_custom (Версия для слабовидящих)
Application 3.893 seconds (+0.000); 8.83 MB (+0.004) - afterRenderModule mod_custom (Версия для слабовидящих)
Application 3.905 seconds (+0.013); 8.88 MB (+0.053) - afterRender

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

8.94 MB (9,379,184 Bytes)

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

  1. SELECT `data`
      FROM `eiw83_session`
      WHERE `session_id` = '9c474e4f3c1c9871df7bd1976654f55d'
  2. SELECT `session_id`
      FROM `eiw83_session`
      WHERE `session_id` = '9c474e4f3c1c9871df7bd1976654f55d'
      LIMIT 0, 1
  3. INSERT INTO `eiw83_session` (`session_id`, `client_id`, `time`)
      VALUES ('9c474e4f3c1c9871df7bd1976654f55d', 0, 1753494138)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `eiw83_viewlevels`
  6. 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
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kunena'
  9. select id, title, alias
      from eiw83_jumi
      where published = 1
  10. 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
  11. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM eiw83_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  12. 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=1144
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  13. SELECT alias, catid
      FROM eiw83_content
      WHERE id = 1144
  14. SELECT a.rules
      FROM eiw83_assets AS a
      WHERE a.id = 1
  15. 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
  16. SELECT *
      FROM eiw83_jcomments_settings
  17. 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
  18. SELECT *
      FROM eiw83_languages
      WHERE published=1
      ORDER BY ordering ASC
  19. 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
  20. 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 = 1144
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-26 01:42:20')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-26 01:42:20')
      AND (a.state = 1 OR a.state =2)
  21. 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=77
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  22. SHOW FULL COLUMNS
      FROM `eiw83_users`
  23. SELECT *
      FROM eiw83_users
      WHERE id = 42
  24. 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
  25. 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
  26. SELECT *
      FROM eiw83_fsj_plg_plugin
      WHERE type = 'include'
  27. SELECT *
      FROM eiw83_fsj_includes_alias
      WHERE state = 1
  28. 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.article.1144'
      ORDER BY b.lft
  29. SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
      FROM eiw83_content AS a
      LEFT JOIN eiw83_categories AS cc
      ON cc.id = a.catid
      WHERE a.catid = 77
      AND a.state = 1
      AND a.access = 1
      AND (a.state = 1 OR a.state = -1)
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-07-26 01:42:20')
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-07-26 01:42:20')
      ORDER BY a.created DESC
  30. SELECT *
      FROM `eiw83_jcomments_objects`
      WHERE `object_id` = '1144'
      AND `object_group` = 'com_content'
      AND `lang` = 'ru-RU'
  31. SELECT count(*)
      FROM eiw83_jcomments AS c
      WHERE c.object_id = 1144
      AND c.object_group = 'com_content'
      AND c.published = 1
  32. SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted , case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
      FROM eiw83_jcomments AS c
      LEFT JOIN eiw83_jcomments_votes AS v
      ON c.id = v.commentid
      AND v.userid = 0
      AND v.ip = '216.73.216.139'
      WHERE c.object_id = 1144
      AND c.object_group = 'com_content'
      AND c.published = 1
      ORDER BY c.date DESC
      LIMIT 0, 10
  33. UPDATE eiw83_content
      SET hits = hits + 1
      WHERE id = 1144
  34. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM eiw83_modules AS m
      LEFT JOIN eiw83_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN eiw83_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-07-26 01:42:20')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-07-26 01:42:20')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 563 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  35. SELECT *
      FROM eiw83_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  36. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (10)
      ORDER BY a.sticky DESC,a.ordering
  37. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (10)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 1
  38. SELECT *
      FROM eiw83_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  39. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (155)
      ORDER BY a.sticky DESC,a.ordering
  40. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (155)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 1
  41. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 6
  42. SELECT *
      FROM eiw83_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  43. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (113)
      ORDER BY a.sticky DESC,a.ordering
  44. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (113)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  45. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 10
  46. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 25
  47. SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM eiw83_content AS a
      LEFT JOIN eiw83_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN eiw83_categories AS c
      ON c.id = a.catid
      LEFT JOIN eiw83_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN eiw83_users AS uam
      ON uam.id = a.modified_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 != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (177)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-26 01:42:21')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-26 01:42:21')
      GROUP BY a.id
      ORDER BY a.publish_up DESC
      LIMIT 0, 5
  48. 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=177
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  49. SELECT *
      FROM eiw83_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  50. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (114)
      ORDER BY a.sticky DESC,a.ordering
  51. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM eiw83_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (114)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  52. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 16
  53. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 22
  54. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 23
  55. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 18
  56. UPDATE eiw83_banners
      SET impmade = (impmade + 1)
      WHERE id = 30
  57. UPDATE `eiw83_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1753494138;s:18:\"session.timer.last\";i:1753494138;s:17:\"session.timer.now\";i:1753494138;s:24:\"session.client.forwarded\";s:12:\"10.1.115.161\";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:1:{s:40:\"44d6bcd2aeee8aaadfd748bc637865ab2909178d\";O:8:\"stdClass\":2:{s:4:\"link\";s:248:\"http://old.pankrushiha22.ru/index.php/novosti-rajona/1144-osnovnye-pokazateli-razvitiya-zhivotnovodstva-v-selkhozorganizatsiyakh-krestyanskikh-fermerskikh-khozyajstvakh-i-ip-pankrushikhinskogo-rajona-altajskogo-kraya-po-sostoyaniyu-na-01102012-goda\";s:6:\"expiry\";i:1753494140;}}}', `time` = 1753494142
      WHERE `session_id` = '9c474e4f3c1c9871df7bd1976654f55d'

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

**Запросы типа SELECT:**
  1. **8 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions FROM eiw83_banners as a**
  2. **4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM eiw83_extensions**
  3. **4 × SELECT * FROM eiw83_banners**
  4. **3 × SELECT b.rules FROM eiw83_assets AS a LEFT JOIN eiw83_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt**
  5. **3 × 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**
  6. **1 × SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM eiw83_content AS a LEFT JOIN eiw83_categories AS cc ON cc.id = a.catid**
  7. **1 × SELECT * FROM eiw83_fsj_includes_alias**
  8. **1 × SELECT * FROM eiw83_fsj_plg_plugin**
  9. **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**
  10. **1 × SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM eiw83_content AS a LEFT JOIN eiw83_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN eiw83_categories AS c ON c.id = a.catid LEFT JOIN eiw83_users AS ua ON ua.id = a.created_by LEFT JOIN eiw83_users AS uam ON uam.id = a.modified_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**
  11. **1 × SELECT * FROM `eiw83_jcomments_objects`**
  12. **1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted , case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner FROM eiw83_jcomments AS c LEFT JOIN eiw83_jcomments_votes AS v ON c.id = v.commentid AND v.userid = 0 AND v.ip = '216.73.216.139'**
  13. **1 × SELECT g.id, g.title FROM eiw83_usergroups AS g JOIN eiw83_user_usergroup_map AS m ON m.group_id = g.id**
  14. **1 × SELECT count(*) FROM eiw83_jcomments AS c**
  15. **1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM eiw83_modules AS m LEFT JOIN eiw83_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN eiw83_extensions AS e ON e.element = m.module AND e.client_id = m.client_id**
  16. **1 × SELECT * FROM eiw83_languages**
  17. **1 × select id, title, alias from eiw83_jumi**
  18. **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**
  19. **1 × SELECT folder AS type, element AS name, params FROM eiw83_extensions**
  20. **1 × SELECT id, rules FROM `eiw83_viewlevels**
  21. **1 × SELECT `session_id` FROM `eiw83_session`**
  22. **1 × SELECT alias, catid FROM eiw83_content**
  23. **1 × SELECT a.rules FROM eiw83_assets AS a**
  24. **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**
  25. **1 × SELECT `data` FROM `eiw83_session`**
  26. **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**
  27. **1 × SELECT * FROM eiw83_jcomments_setting**
  28. **1 × SELECT * FROM eiw83_users**
**Прочие SQL-запросы:**
  1. **8 × UPDATE eiw83_banners SET impmade = (impmade + 1)**
  2. **1 × UPDATE `eiw83_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1753494138;s:18:\"session.timer.last\";i:1753494138;s:17:\"session.timer.now\";i:1753494138;s:24:\"session.client.forwarded\";s:12:\"10.1.115.161\";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:1:{s:40:\"44d6bcd2aeee8aaadfd748bc637865ab2909178d\";O:8:\"stdClass\":2:{s:4:\"link\";s:248:\"http://old.pankrushiha22.ru/index.php/novosti-rajona/1144-osnovnye-pokazateli-razvitiya-zhivotnovodstva-v-selkhozorganizatsiyakh-krestyanskikh-fermerskikh-khozyajstvakh-i-ip-pankrushikhinskogo-rajona-altajskogo-kraya-po-sostoyaniyu-na-01102012-goda\";s:6:\"expiry\";i:1753494140;}}}', `time` = 1753494142**
  3. **1 × UPDATE eiw83_content SET hits = hits + 1**
  4. **1 × SHOW FULL COLUMNS FROM `eiw83_users**
  5. **1 × INSERT INTO `eiw83_session` (`session_id`, `client_id`, `time`) VALUES ('9c474e4f3c1c9871df7bd1976654f55d', 0, 1753494138**

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

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

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

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

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