Проханов Александр: все материалы

[Статья] Александр Проханов: К счастью среди нас есть не только полковники Захарченко, но и Владиславы Тетюхины (15.09.2016) Я не раз бывал в Нижнем Тагиле. Этот уральский город для меня — город танков, город "Арматы" и Т-90, город лязгающих конвейеров и полигонов, где только что вышедшие из цехов танки грохочут своими пушками и танцуют чудовищный и восхитительный балет среди рвов, оврагов и гор. Но н...
Просмотров: 740 Комментариев: 0
[Статья] Александр Проханов: Крым обетованный (20.08.2016) ​Я только что из Крыма. Там не смолкают разговоры о киевских диверсантах, которые стремились прорваться на территорию полуострова, обстреляли военный пост, убили русских военных, но были захвачены, как тати в ночи. Об этом — разговоры в такси, в ресторанах, на улицах и даже на пляжах. Хотя по-...
Просмотров: 954 Комментариев: 0
[Статья] Александр Проханов: Вырождение элит (05.07.2016) По престижу ФСБ нанесён серьёзный удар. Мы полагали и справедливо полагали, что наши спецслужбы, облачённые в бронежилеты, воюют на Кавказе с терроризмом, участвуют в сложнейших операциях на Ближнем Востоке и в среднеазиатском подбрюшье России. И образ ФСБ, мучительно восстанавливая себя после перес...
Просмотров: 843 Комментариев: 0
[Статья] Александр Проханов: Простите нас, скотоложцы! (28.06.2016) Папа Римский призвал католиков, да и нас всех, грешных христиан, покаяться перед геями. Мне кажется, что следующим шагом в этой череде бесконечных покаяний, к которым призывает нас понтифик, должно быть наше покаянием перед скотоложца...
Просмотров: 1149 Комментариев: 0
[Видео] 8.02.2016 А.Проханов, В.Семенко, В. Шурыгин: Сирия, Иран, Всеправославный собор, Архиерейский собор, встреча Патриарха с папой
Наиболее интересные моменты редакционного совещания газеты «Завтра». Обсуждение материалов свежего номера газеты, а также актуальные комментарии наших авторов. Владислав Шурыгин о том, решится ли Турция на открытые военные действия в Сирии, том, что мешает осуществлению "плана Эрдог...
Опубликовано: 09.02.2016 Просмотров: 1317
[Видео] Сергей Глазьев. Презентация книги "Последняя мировая война. США начинают и проигрывают".
"Если мы не научимся воевать, последняя война рискует стать перманентной". Репортаж с презентации книги экономиста, советника президента РФ Сергея Глазьева "Последняя мировая война. США начинают и проигрывают". Приобрести книгу вы можете здесь  Опубликовано: 27.01.2016 Просмотров: 1704
[Видео] 20.01.2016 Сергей Глазьев о монетаристском курсе правительства и угрозах новой мировой войны
В Изборском клубе поздравляли с 55-летием Сергея Глазьева, а заодно представляли публике его новую книгу. Название у книги алармистское («Последняя Мировая Война»), однако нельзя сказать, чтобы для этого не было совсем никаких оснований.   Вот чуть сокращенная версия выступления Гла...
Опубликовано: 21.01.2016 Просмотров: 1498
[Статья] Александр Проханов: Русский - значит одухотворённый (22.12.2015) В Курске я познакомился с удивительными молодыми мужчинами. Необычное сообщество, какого я прежде не наблюдал. Они называют себя "Русской улицей", их вдохновитель — Валерий Акиньшин. Это не политическое объединение, не рабочая артель, не военный клуб. ...
Просмотров: 1228 Комментариев: 0
Все персоналии
Вверх
Полная версия сайта
Мобильная версия сайта
Array
(
    [0] => Array
        (
            [REQUEST_2] => 0.061333
        )

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

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

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

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

    [5] => Array
        (
            [REQUEST_2] => -0.966855
        )

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

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

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

    [9] => Array
        (
            [SYSBLOCK_5] => -0.865772
        )

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

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

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

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

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

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

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

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

)
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/prohanov-aleksandr'
			LIMIT 1
		
    [3] => 
						SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = '77afb1583c9341c82b51db94fa04cd11'
							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 != '3528') 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 != '3528') 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 != '3528') 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 != '3528') 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 != '3528') 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 != '3528') 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 != '3528') 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 != '3528') 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 != '3528') 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('%|3528|%'))) 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('%|3528|%'))) 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('%|3528|%'))) 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 != '3528') 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('%|3528|%'))) 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('%|3528|%'))) 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('%|3528|%'))) 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 = 3528
			AND (
				nav.navi_item_link = 'index.php?id=3528'
			OR nav.document_alias = 'person/prohanov-aleksandr'
			OR nav.document_alias = '/person/prohanov-aleksandr'
			OR nav.document_alias = 'person/prohanov-aleksandr.html'
			OR nav.document_alias = '/person/prohanov-aleksandr.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/k-schastyu-sredi-nas-est-ne.html' AND `moder` = 0
    [99] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/krym-obetovannyj.html' AND `moder` = 0
    [100] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/vyrozhdenie-elit.html' AND `moder` = 0
    [101] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/prostite-nas-skotolozhcy.html' AND `moder` = 0
    [102] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = '2HYegm6Qsds' AND
                status = 'success'
        
    [103] => 
                    SELECT sysblock_text
                    FROM ave_sysblocks
                    WHERE id = 25
                
    [104] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = '32l02kUhJec' AND
                status = 'success'
        
    [105] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = 'zn2GKhQAxNs' AND
                status = 'success'
        
    [106] => SELECT COUNT(*) FROM `comments` WHERE `url` = '/articles/russkij-znachit.html' AND `moder` = 0
    [107] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = '8P8V1-BP6JE' AND
                status = 'success'
        
    [108] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = 'hYuA-i4unpI' AND
                status = 'success'
        
    [109] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = 'LaT7pFqAzp4' AND
                status = 'success'
        
    [110] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = 'lPuHO-GOfxk' AND
                status = 'success'
        
    [111] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = 'z7mgEaOyUgY' AND
                status = 'success'
        
    [112] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = '1iLB3AxUmys' AND
                status = 'success'
        
    [113] => 
            SELECT 1
            FROM ave_videos
            WHERE
                id = '5yPGw2mU6w4' AND
                status = 'success'
        
    [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 '%|21817|%'
	
    [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 '%|1761|%'
	
    [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 '%|2997|%'
	
    [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 '%|1412|%'
	
    [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 '%|12092|%'
	
    [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 '%|9912|%'
	
    [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 '%|1414|%'
	
    [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 '%|1410|%'
	
    [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 '%|8382|%'
	
    [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 '%|21419|%'
	
    [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 '%|5085|%'
	
    [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 '%|1413|%'
	
    [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 '%|17869|%'
	
    [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 '%|8996|%'
	
    [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 '%|1760|%'
	
    [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 '%|1411|%'
	
    [130] => 
		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|%'
	
    [131] => 
		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|%'
	
    [132] => 
		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|%'
	
    [133] => 
		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|%'
	
    [134] => 
		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|%'
	
    [135] => 
		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|%'
	
    [136] => 
		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|%'
	
    [137] => 
		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|%'
	
    [138] => 
		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|%'
	
    [139] => 
		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,636 сек.
Пиковое значение 3 125Kb
Количество запросов: 100 шт. за 0,315402 сек.
84   0,141432
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,000013 starting
 0,000004 Waiting for query cache lock
 0,000287 checking query cache for query
 0,000008 checking permissions
 0,000002 checking permissions
 0,000003 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000003 checking permissions
 0,000006 checking permissions
 0,000070 Opening tables
 0,002473 System lock
 0,000049 optimizing
 0,000395 statistics
 0,000055 preparing
 0,000479 Creating tmp table
 0,000009 executing
 0,017382 Copying to tmp table
 0,000083 Sorting result
 0,000302 Sending data
 0,000052 optimizing
 0,000563 statistics
 0,000051 preparing
 0,000537 Creating tmp table
 0,000009 executing
 0,101071 Copying to tmp table
 0,000057 Sorting result
 0,000013 Sending data
 0,000058 optimizing
 0,000387 statistics
 0,000053 preparing
 0,000006 executing
 0,015113 Sending data
 0,000018 optimizing
 0,000011 statistics
 0,000010 preparing
 0,000003 executing
 0,000390 Sending data
 0,000519 removing tmp table
 0,000010 Sending data
 0,000180 removing tmp table
 0,000010 Sending data
 0,000083 removing tmp table
 0,000023 Sending data
 0,000035 init
 0,000005 optimizing
 0,000011 statistics
 0,000006 preparing
 0,000002 executing
 0,000037 Sorting result
 0,000088 Sending data
 0,000005 end
 0,000003 query end
 0,000002 closing tables
 0,000110 removing tmp table
 0,000022 closing tables
 0,000236 freeing items
 0,000004 logging slow query
 0,000023 cleaning up