Шаргунов Сергей: все материалы

[Статья] Сергей Шаргунов: Россия должна защитить русских людей на Украине (05.02.2018) Перспективы официального признания ДНР и ЛНР, необходимость облегчить выдачу российских паспортов соотечественникам из Донбасса и Украины, опасность меркантильного конформизма в общественном сознании – на эти и многие другие темы в интервью изданию Ukraina.ru высказался депутат Государственной...
Просмотров: 140 Комментариев: 0
[Статья] Сергей Шаргунов: Утилизация страны (17.08.2016) Недавно по просьбе жителей я побывал в селе Огни Алтайского края. Директор и учителя со слезами провели экскурсию по школе. В ней сейчас учится 114 ребят, в 1-й класс пойдет 12. Но как они учатся и будут учиться? Постоянно простывая, с риском в&...
Просмотров: 653 Комментариев: 0
[Видео] 13.06.2016 Является ли Германия угрозой для России? (Сивков, Шаргунов, Делягин и др)
Насколько самостоятельна Германия, объявляющая нас угрозой своей национальной безопасности? Кто толкает самую мощную европейскую страну на путь конфронтации с Россией? И как должна реагировать Москва на растущие геополитические амбиции Берлина, все более активные требования преодолеть комплекс истор...
Опубликовано: 16.06.2016 Просмотров: 1050
[Статья] Сергей Шаргунов, Сергей Глазьев, Владимир Полеванов: Возвращение хищника? (11.02.2016) Близится «новая волна приватизации». Акции стратегических госпредприятий хотят выставить на продажу, передать в частные руки. Чьи? И какова польза от этого стране, экономике, народу?...
Просмотров: 1604 Комментариев: 0
Все персоналии
Вверх
Полная версия сайта
Мобильная версия сайта
Array
(
    [0] => Array
        (
            [REQUEST_2] => 0.061789
        )

    [1] => Array
        (
            [REQUEST_3] => 0.034213
        )

    [2] => Array
        (
            [REQUEST_4] => 0.024046
        )

    [3] => Array
        (
            [REQUEST_5] => 0.015143
        )

    [4] => Array
        (
            [SYSBLOCK_5] => 0.137203
        )

    [5] => Array
        (
            [REQUEST_2] => 0.039929
        )

    [6] => Array
        (
            [REQUEST_3] => 0.034274
        )

    [7] => Array
        (
            [REQUEST_4] => 0.029919
        )

    [8] => Array
        (
            [REQUEST_5] => 0.025752
        )

    [9] => Array
        (
            [SYSBLOCK_5] => 0.132453
        )

    [10] => Array
        (
            [SYSBLOCK_3] => 0.00015399999999999
        )

    [11] => Array
        (
            [SYSBLOCK_4] => 0.00015199999999999
        )

    [12] => Array
        (
            [REQUEST_22] => 0.007
        )

    [13] => Array
        (
            [REQUEST_27] => 0.006691
        )

    [14] => Array
        (
            [REQUEST_27] => 0.005155
        )

    [15] => Array
        (
            [MULTIREQUEST_2] => 0.11225
        )

    [16] => Array
        (
            [MULTIREQUEST_2] => 0.050081
        )

    [17] => Array
        (
            [NAVIGATION_1] => 0.002867
        )

)
Queries
Array
(
    [0] => 
	SELECT * FROM ave_settings_lang
	WHERE lang_status='1'
	ORDER BY lang_default ASC

    [1] => SELECT * FROM ave_settings
    [2] => 
			SELECT
				doc.*,
				rubric_permission,
				rubric_template,
				rubric_meta_gen,
				template_text
			FROM
				ave_documents AS doc
			JOIN
				ave_rubrics AS rub
					ON rub.Id = doc.rubric_id
			JOIN
				ave_templates AS tpl
					ON tpl.Id = rubric_template_id
			JOIN
				ave_rubric_permissions AS prm
					ON doc.rubric_id = prm.rubric_id
			WHERE
				user_group_id = '2'
			AND
				document_alias = 'person/shargunov-sergej'
			LIMIT 1
		
    [3] => 
						SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = 'e5ab6839d54730c0201cb91760207d41'
							LIMIT 1
					
    [4] => 
		SELECT *
		FROM ave_request
		WHERE Id = '2'
	
    [5] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '2' AND condition_status = '1'
	
    [6] => SET max_heap_table_size = 1024 * 1024 * 64;
    [7] => SET tmp_table_size = 1024 * 1024 * 32;
    [8] => 		# req=2
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('3'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [9] => SELECT FOUND_ROWS()
    [10] => 
				SELECT *
				FROM ave_module
				WHERE ModuleStatus = '1'
			
    [11] => 
		SELECT *
		FROM ave_request
		WHERE Id = '3'
	
    [12] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '3' AND condition_status = '1'
	
    [13] => SET max_heap_table_size = 1024 * 1024 * 64;
    [14] => SET tmp_table_size = 1024 * 1024 * 32;
    [15] => 		# req=3
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('4'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [16] => SELECT FOUND_ROWS()
    [17] => 
		SELECT *
		FROM ave_request
		WHERE Id = '4'
	
    [18] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '4' AND condition_status = '1'
	
    [19] => SET max_heap_table_size = 1024 * 1024 * 64;
    [20] => SET tmp_table_size = 1024 * 1024 * 32;
    [21] => 		# req=4
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('6'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [22] => SELECT FOUND_ROWS()
    [23] => 
		SELECT *
		FROM ave_request
		WHERE Id = '5'
	
    [24] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '5' AND condition_status = '1'
	
    [25] => SET max_heap_table_size = 1024 * 1024 * 64;
    [26] => SET tmp_table_size = 1024 * 1024 * 32;
    [27] => 		# req=5
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('7'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [28] => SELECT FOUND_ROWS()
    [29] => 
		SELECT *
		FROM ave_request
		WHERE Id = '2'
	
    [30] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '2' AND condition_status = '1'
	
    [31] => SET max_heap_table_size = 1024 * 1024 * 64;
    [32] => SET tmp_table_size = 1024 * 1024 * 32;
    [33] => 		# req=2
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('3'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [34] => SELECT FOUND_ROWS()
    [35] => 
		SELECT *
		FROM ave_request
		WHERE Id = '3'
	
    [36] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '3' AND condition_status = '1'
	
    [37] => SET max_heap_table_size = 1024 * 1024 * 64;
    [38] => SET tmp_table_size = 1024 * 1024 * 32;
    [39] => 		# req=3
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('4'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [40] => SELECT FOUND_ROWS()
    [41] => 
		SELECT *
		FROM ave_request
		WHERE Id = '4'
	
    [42] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '4' AND condition_status = '1'
	
    [43] => SET max_heap_table_size = 1024 * 1024 * 64;
    [44] => SET tmp_table_size = 1024 * 1024 * 32;
    [45] => 		# req=4
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('6'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [46] => SELECT FOUND_ROWS()
    [47] => 
		SELECT *
		FROM ave_request
		WHERE Id = '5'
	
    [48] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '5' AND condition_status = '1'
	
    [49] => SET max_heap_table_size = 1024 * 1024 * 64;
    [50] => SET tmp_table_size = 1024 * 1024 * 32;
    [51] => 		# req=5
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t8,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t8.document_id = a.id AND (t8.rubric_field_id = '8' AND UPPER(t8.field_value) = UPPER('7'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,5
	
    [52] => SELECT FOUND_ROWS()
    [53] => 
		SELECT *
		FROM ave_request
		WHERE Id = '22'
	
    [54] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '22' AND condition_status = '1'
	
    [55] => SET max_heap_table_size = 1024 * 1024 * 64;
    [56] => SET tmp_table_size = 1024 * 1024 * 32;
    [57] => 		# req=22
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t95,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '10' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t95.document_id = a.id AND (t95.rubric_field_id = '95' AND UPPER(t95.field_value) = UPPER('1'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_title ASC
		
	
    [58] => SELECT FOUND_ROWS()
    [59] => 
		SELECT *
		FROM ave_request
		WHERE Id = '27'
	
    [60] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '27' AND condition_status = '1'
	
    [61] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '27' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [62] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '27'
		
    [63] => SET max_heap_table_size = 1024 * 1024 * 64;
    [64] => SET tmp_table_size = 1024 * 1024 * 32;
    [65] => 		# req=27
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '13' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP()))
			
		#GROUP BY a.Id
		ORDER BY a.document_title ASC
		
	
    [66] => SELECT FOUND_ROWS()
    [67] => 
		SELECT *
		FROM ave_request
		WHERE Id = '27'
	
    [68] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '27' AND condition_status = '1'
	
    [69] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '27' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [70] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '27'
		
    [71] => SET max_heap_table_size = 1024 * 1024 * 64;
    [72] => SET tmp_table_size = 1024 * 1024 * 32;
    [73] => 		# req=27
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '13' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP()))
			
		#GROUP BY a.Id
		ORDER BY a.document_title ASC
		
	
    [74] => SELECT FOUND_ROWS()
    [75] => 
			SELECT * FROM ave_module_export
			WHERE id = '2'
		
    [76] => 
			SELECT Id AS id, request_template_item AS tpl
			FROM ave_request
			WHERE Id IN (47,50,51)
		
    [77] => 
		SELECT *
		FROM ave_request
		WHERE Id = '47'
	
    [78] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '47' AND condition_status = '1'
	
    [79] => 
		SELECT *
		FROM ave_request
		WHERE Id = '50'
	
    [80] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '50' AND condition_status = '1'
	
    [81] => 
		SELECT *
		FROM ave_request
		WHERE Id = '51'
	
    [82] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '51' AND condition_status = '1'
	
    [83] => 
			SELECT SQL_CALC_FOUND_ROWS all_docs.*
			FROM ((		# req=47
		SELECT STRAIGHT_JOIN
			CONCAT('47') AS req_id, a.*
			
			
		FROM
			ave_document_fields AS t59,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '11' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t59.document_id = a.id AND (t59.rubric_field_id = '59' AND UPPER(t59.field_value) LIKE UPPER('%|33294|%'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,100
	) UNION (		# req=50
		SELECT STRAIGHT_JOIN
			CONCAT('50') AS req_id, a.*
			
			
		FROM
			ave_document_fields AS t60, ave_document_fields AS t47,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '9' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t60.document_id = a.id AND (t60.rubric_field_id = '60' AND UPPER(t60.field_value) LIKE UPPER('%|33294|%'))) AND (t47.document_id = a.id AND (t47.rubric_field_id = '47' AND UPPER(t47.field_value) != UPPER('1'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,50
	) UNION (		# req=51
		SELECT STRAIGHT_JOIN
			CONCAT('51') AS req_id, a.*
			
			
		FROM
			ave_document_fields AS t61,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t61.document_id = a.id AND (t61.rubric_field_id = '61' AND UPPER(t61.field_value) LIKE UPPER('%|33294|%'))) AND 1=1)
			
		#GROUP BY a.Id
		
		
	)) AS all_docs
			 ORDER BY all_docs.document_published DESC
			 LIMIT 0,1000
		
    [84] => SELECT FOUND_ROWS()
    [85] => 
			SELECT * FROM ave_module_export
			WHERE id = '2'
		
    [86] => 
			SELECT Id AS id, request_template_item AS tpl
			FROM ave_request
			WHERE Id IN (47,50,51)
		
    [87] => 
		SELECT *
		FROM ave_request
		WHERE Id = '47'
	
    [88] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '47' AND condition_status = '1'
	
    [89] => 
		SELECT *
		FROM ave_request
		WHERE Id = '50'
	
    [90] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '50' AND condition_status = '1'
	
    [91] => 
		SELECT *
		FROM ave_request
		WHERE Id = '51'
	
    [92] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '51' AND condition_status = '1'
	
    [93] => 
			SELECT SQL_CALC_FOUND_ROWS all_docs.*
			FROM ((		# req=47
		SELECT STRAIGHT_JOIN
			CONCAT('47') AS req_id, a.*
			
			
		FROM
			ave_document_fields AS t59,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '11' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '33294') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t59.document_id = a.id AND (t59.rubric_field_id = '59' AND UPPER(t59.field_value) LIKE UPPER('%|33294|%'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,100
	) UNION (		# req=50
		SELECT STRAIGHT_JOIN
			CONCAT('50') AS req_id, a.*
			
			
		FROM
			ave_document_fields AS t60, ave_document_fields AS t47,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '9' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t60.document_id = a.id AND (t60.rubric_field_id = '60' AND UPPER(t60.field_value) LIKE UPPER('%|33294|%'))) AND (t47.document_id = a.id AND (t47.rubric_field_id = '47' AND UPPER(t47.field_value) != UPPER('1'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,50
	) UNION (		# req=51
		SELECT STRAIGHT_JOIN
			CONCAT('51') AS req_id, a.*
			
			
		FROM
			ave_document_fields AS t61,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '3' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t61.document_id = a.id AND (t61.rubric_field_id = '61' AND UPPER(t61.field_value) LIKE UPPER('%|33294|%'))) AND 1=1)
			
		#GROUP BY a.Id
		
		
	)) AS all_docs
			 ORDER BY all_docs.document_published DESC
			 LIMIT 0,1000
		
    [94] => SELECT FOUND_ROWS()
    [95] => SELECT * FROM ave_navigation
    [96] => 
		SELECT CONCAT_WS(
				';',
				CONCAT_WS(',', nav.Id, nav.parent_id, nav2.parent_id),
				CONCAT_WS(',', nav.navi_item_level),
				nav.Id
			)
		FROM
			ave_navigation_items AS nav
		JOIN
			ave_documents AS doc
		LEFT JOIN
			ave_navigation_items AS nav2 ON nav2.Id = nav.parent_id
		WHERE nav.navi_item_status = 1
			AND nav.navi_id = 1
			AND doc.Id = 33294
			AND (
				nav.navi_item_link = 'index.php?id=33294'
			OR nav.document_alias = 'person/shargunov-sergej'
			OR nav.document_alias = '/person/shargunov-sergej'
			OR nav.document_alias = 'person/shargunov-sergej.html'
			OR nav.document_alias = '/person/shargunov-sergej.html'
		
				OR nav.Id = doc.document_linked_navi_id
			)
	
    [97] => 
		SELECT *
		FROM ave_navigation_items
		WHERE navi_item_status = '1'
		AND navi_id = '1'
		ORDER BY navi_item_position ASC
	
    [98] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/pozdravleniya-a.prohanovu-po.html' AND `moder` = 0
    [99] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/rossiya-dolzhna-zacshitit-russkih.html' AND `moder` = 0
    [100] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/utilizaciya-strany.html' AND `moder` = 0
    [101] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = 'LMHe8nk0Li8' AND
                status = 'success'
        
    [102] => 
                    SELECT sysblock_text
                    FROM ave_sysblocks
                    WHERE id = 25
                
    [103] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/vozvracshenie-hicshnika.html' AND `moder` = 0
    [104] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|21817|%'
	
    [105] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1761|%'
	
    [106] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|2997|%'
	
    [107] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1412|%'
	
    [108] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|12092|%'
	
    [109] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|9912|%'
	
    [110] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1414|%'
	
    [111] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1410|%'
	
    [112] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|8382|%'
	
    [113] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|21419|%'
	
    [114] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|5085|%'
	
    [115] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1413|%'
	
    [116] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|17869|%'
	
    [117] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|8996|%'
	
    [118] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1760|%'
	
    [119] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1411|%'
	
    [120] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1416|%'
	
    [121] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|32311|%'
	
    [122] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|8441|%'
	
    [123] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1620|%'
	
    [124] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1812|%'
	
    [125] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|1415|%'
	
    [126] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|29518|%'
	
    [127] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|3713|%'
	
    [128] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|4684|%'
	
    [129] => 
		SELECT COUNT(*)
		FROM ave_documents AS d
		LEFT JOIN ave_document_fields AS df ON d.Id = df.document_id
		WHERE
				d.rubric_id = '11'
			 AND d.document_status = '1' 
			 AND d.document_deleted = '0' 
			AND	df.rubric_field_id = '45'
			AND df.field_value LIKE '%|15751|%'
	
)

Время генерации: 0,669 сек.
Пиковое значение 3 256Kb
Количество запросов: 100 шт. за 0,289662 сек.
84   0,108243
SELECT SQL_CALC_FOUND_ROWS all_docs.*
			FROM ((		# req=47
		SELECT STRAIGHT_JOIN
			CONCAT('47') AS req_id, a.*
			
			
		FROM
			ave_document_fields AS t59,			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '11' AND
		a.document_deleted != '1') AND (a.docu
 0,000011 starting
 0,000003 Waiting for query cache lock
 0,000289 checking query cache for query
 0,000014 checking permissions
 0,000003 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000005 checking permissions
 0,000079 Opening tables
 0,001731 System lock
 0,000049 optimizing
 0,000481 statistics
 0,000056 preparing
 0,000527 Creating tmp table
 0,000009 executing
 0,012809 Copying to tmp table
 0,000058 Sorting result
 0,000075 Sending data
 0,000049 optimizing
 0,000552 statistics
 0,000059 preparing
 0,000501 Creating tmp table
 0,000007 executing
 0,077749 Copying to tmp table
 0,000060 Sorting result
 0,000016 Sending data
 0,000058 optimizing
 0,000352 statistics
 0,000074 preparing
 0,000008 executing
 0,011218 Sending data
 0,000016 optimizing
 0,000014 statistics
 0,000009 preparing
 0,000002 executing
 0,000109 Sending data
 0,000108 removing tmp table
 0,000007 Sending data
 0,000052 removing tmp table
 0,000007 Sending data
 0,000575 removing tmp table
 0,000045 Sending data
 0,000046 init
 0,000006 optimizing
 0,000013 statistics
 0,000007 preparing
 0,000003 executing
 0,000035 Sorting result
 0,000066 Sending data
 0,000007 end
 0,000004 query end
 0,000003 closing tables
 0,000096 removing tmp table
 0,000022 closing tables
 0,000070 freeing items
 0,000005 logging slow query
 0,000011 cleaning up