Степашин Сергей: все материалы

[Видео] 26.12.2015 Сергей Степашин. Сирия, ИППО и Россия
Ведущий - Борис Костенко. Тема: «Сирия, ИППО и Россия». Гость - Сергей Вадимович Степашин,  председатель Императорского Православного Палестинского Общества (ИППО)....
Опубликовано: 04.01.2016 Просмотров: 1008
Все персоналии
Вверх
Полная версия сайта
Мобильная версия сайта
Array
(
    [0] => Array
        (
            [REQUEST_2] => 0.215284
        )

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

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

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

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

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

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

    [7] => Array
        (
            [REQUEST_4] => -0.93901
        )

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

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

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

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

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

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

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

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

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

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

)
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/stepashin-sergej'
			LIMIT 1
		
    [3] => 
						SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = '34ed42e7ba8183480201d606d88b7099'
							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 != '20324') 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 != '20324') 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 != '20324') 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 != '20324') 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 != '20324') 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 != '20324') 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 != '20324') 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 != '20324') 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 != '20324') 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('%|20324|%'))) 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('%|20324|%'))) 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('%|20324|%'))) 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 != '20324') 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('%|20324|%'))) 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('%|20324|%'))) 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('%|20324|%'))) 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 = 20324
			AND (
				nav.navi_item_link = 'index.php?id=20324'
			OR nav.document_alias = 'person/stepashin-sergej'
			OR nav.document_alias = '/person/stepashin-sergej'
			OR nav.document_alias = 'person/stepashin-sergej.html'
			OR nav.document_alias = '/person/stepashin-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 1
            FROM ave_videos
            WHERE
                id = 'tECUqbnKTOc' AND
                status = 'success'
        
    [99] => 
                    SELECT sysblock_text
                    FROM ave_sysblocks
                    WHERE id = 25
                
    [100] => 
		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|%'
	
    [101] => 
		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|%'
	
    [102] => 
		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|%'
	
    [103] => 
		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|%'
	
    [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 '%|12092|%'
	
    [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 '%|9912|%'
	
    [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 '%|1414|%'
	
    [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 '%|1410|%'
	
    [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 '%|8382|%'
	
    [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 '%|21419|%'
	
    [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 '%|5085|%'
	
    [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 '%|1413|%'
	
    [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 '%|17869|%'
	
    [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 '%|8996|%'
	
    [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 '%|1760|%'
	
    [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 '%|1411|%'
	
    [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 '%|1416|%'
	
    [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 '%|32311|%'
	
    [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 '%|8441|%'
	
    [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 '%|1620|%'
	
    [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 '%|1812|%'
	
    [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 '%|1415|%'
	
    [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 '%|29518|%'
	
    [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 '%|3713|%'
	
    [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 '%|4684|%'
	
    [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 '%|15751|%'
	
)

Время генерации: 1,476 сек.
Пиковое значение 2 700Kb
Количество запросов: 100 шт. за 0,778057 сек.
52   0,108455
# 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 != '20324') AND (a.document_published <= UNIX_TI
 0,000104 starting
 0,000006 checking permissions
 0,000003 checking permissions
 0,000024 Opening tables
 0,000012 System lock
 0,000080 init
 0,000046 optimizing
 0,037506 statistics
 0,000073 preparing
 0,000462 Creating tmp table
 0,000007 executing
 0,053793 Copying to tmp table
 0,002454 Sorting result
 0,000087 Sending data
 0,000005 end
 0,000189 removing tmp table
 0,000007 end
 0,000004 query end
 0,000018 closing tables
 0,013542 freeing items
 0,000021 logging slow query
 0,000015 cleaning up
84   0,215994
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,000284 checking query cache for query
 0,000007 checking permissions
 0,000002 checking permissions
 0,000004 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000004 checking permissions
 0,000043 Opening tables
 0,001239 System lock
 0,000042 optimizing
 0,000427 statistics
 0,000044 preparing
 0,000354 Creating tmp table
 0,000008 executing
 0,019635 Copying to tmp table
 0,001729 Sorting result
 0,000098 Sending data
 0,000047 optimizing
 0,000461 statistics
 0,000054 preparing
 0,000503 Creating tmp table
 0,000007 executing
 0,178083 Copying to tmp table
 0,000040 Sorting result
 0,000013 Sending data
 0,000051 optimizing
 0,000286 statistics
 0,000031 preparing
 0,000003 executing
 0,011222 Sending data
 0,000018 optimizing
 0,000012 statistics
 0,000012 preparing
 0,000004 executing
 0,000168 Sending data
 0,000164 removing tmp table
 0,000012 Sending data
 0,000121 removing tmp table
 0,000012 Sending data
 0,000078 removing tmp table
 0,000092 Sending data
 0,000059 init
 0,000008 optimizing
 0,000015 statistics
 0,000008 preparing
 0,000003 executing
 0,000036 Sending data
 0,000008 end
 0,000003 query end
 0,000004 closing tables
 0,000097 removing tmp table
 0,000073 closing tables
 0,000242 freeing items
 0,000005 logging slow query
 0,000007 cleaning up
94   0,108374
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,000012 starting
 0,000004 Waiting for query cache lock
 0,000224 checking query cache for query
 0,000007 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000005 checking permissions
 0,000036 Opening tables
 0,001103 System lock
 0,000041 optimizing
 0,000321 statistics
 0,000038 preparing
 0,000275 Creating tmp table
 0,000006 executing
 0,005137 Copying to tmp table
 0,000041 Sorting result
 0,000070 Sending data
 0,000056 optimizing
 0,004314 statistics
 0,000067 preparing
 0,000422 Creating tmp table
 0,000006 executing
 0,066171 Copying to tmp table
 0,000049 Sorting result
 0,000014 Sending data
 0,000061 optimizing
 0,008310 statistics
 0,000056 preparing
 0,000005 executing
 0,020681 Sending data
 0,000017 optimizing
 0,000012 statistics
 0,000011 preparing
 0,000004 executing
 0,000094 Sending data
 0,000135 removing tmp table
 0,000011 Sending data
 0,000104 removing tmp table
 0,000010 Sending data
 0,000065 removing tmp table
 0,000032 Sending data
 0,000042 init
 0,000007 optimizing
 0,000014 statistics
 0,000006 preparing
 0,000002 executing
 0,000035 Sending data
 0,000006 end
 0,000004 query end
 0,000003 closing tables
 0,000094 removing tmp table
 0,000037 closing tables
 0,000082 freeing items
 0,000006 logging slow query
 0,000007 cleaning up