Лента новостей: Культура

Вверх
Полная версия сайта
Мобильная версия сайта
Array
(
    [0] => Array
        (
            [REQUEST_2] => 0.041598
        )

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

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

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

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

    [5] => Array
        (
            [SYSBLOCK_6] => 0.00020200000000004
        )

    [6] => Array
        (
            [SYSBLOCK_7] => 0.00017699999999998
        )

    [7] => Array
        (
            [REQUEST_2] => 0.047774
        )

    [8] => Array
        (
            [REQUEST_3] => 0.01978
        )

    [9] => Array
        (
            [REQUEST_4] => 0.023631
        )

    [10] => Array
        (
            [REQUEST_5] => 0.014262
        )

    [11] => Array
        (
            [SYSBLOCK_5] => 0.10904
        )

    [12] => Array
        (
            [SYSBLOCK_6] => 0.00013600000000002
        )

    [13] => Array
        (
            [SYSBLOCK_7] => 0.00017900000000004
        )

    [14] => Array
        (
            [SYSBLOCK_3] => 0.00011300000000003
        )

    [15] => Array
        (
            [SYSBLOCK_4] => 0.00016300000000002
        )

    [16] => Array
        (
            [REQUEST_22] => 0.005088
        )

    [17] => Array
        (
            [REQUEST_66] => -0.220287
        )

    [18] => Array
        (
            [REQUEST_40] => 0.067869
        )

    [19] => Array
        (
            [REQUEST_44] => 0.036944
        )

    [20] => Array
        (
            [REQUEST_9] => 0.004
        )

    [21] => Array
        (
            [REQUEST_9] => 0.0025500000000001
        )

    [22] => Array
        (
            [REQUEST_8] => 0.002907
        )

    [23] => Array
        (
            [REQUEST_66] => -0.234748
        )

    [24] => Array
        (
            [REQUEST_40] => 0.139055
        )

    [25] => Array
        (
            [REQUEST_44] => 0.049702
        )

    [26] => Array
        (
            [REQUEST_9] => 0.004455
        )

    [27] => Array
        (
            [REQUEST_9] => 0.003904
        )

    [28] => Array
        (
            [REQUEST_8] => 0.0038229999999999
        )

    [29] => Array
        (
            [NAVIGATION_1] => 0.008575
        )

    [30] => Array
        (
            [REQUEST_16] => -0.220561
        )

)
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 = 'news/kultura'
			LIMIT 1
		
    [3] => 
						SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = '9183d34d80d2688f8419a269933c7f5f'
							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 != '7752') 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 != '7752') 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 != '7752') 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 != '7752') 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 != '7752') 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 != '7752') 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 != '7752') 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 != '7752') 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 = '66'
	
    [60] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '66' AND condition_status = '1'
	
    [61] => SET max_heap_table_size = 1024 * 1024 * 64;
    [62] => SET tmp_table_size = 1024 * 1024 * 32;
    [63] => 		# req=66
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t34,			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 ((t47.document_id = a.id AND (t47.rubric_field_id = '47' AND UPPER(t47.field_value) != UPPER('1'))) AND (t34.document_id = a.id AND (t34.rubric_field_id = '34' AND UPPER(t34.field_value) = UPPER('6'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,100
	
    [64] => SELECT FOUND_ROWS()
    [65] => SELECT rubric_field_alias FROM ave_rubric_fields WHERE Id=54
    [66] => 
		SELECT *
		FROM ave_request
		WHERE Id = '40'
	
    [67] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '40' AND condition_status = '1'
	
    [68] => SET max_heap_table_size = 1024 * 1024 * 64;
    [69] => SET tmp_table_size = 1024 * 1024 * 32;
    [70] => 		# req=40
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t43, ave_document_fields AS t55,			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.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t43.document_id = a.id AND (t43.rubric_field_id = '43' AND UPPER(t43.field_value) != UPPER('0'))) AND (t55.document_id = a.id AND (t55.rubric_field_id = '55' AND UPPER(t55.field_value) = UPPER('1'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_changed DESC
		LIMIT 0,4
	
    [71] => SELECT FOUND_ROWS()
    [72] => 
		SELECT *
		FROM ave_request
		WHERE Id = '44'
	
    [73] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '44' AND condition_status = '1'
	
    [74] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '44' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [75] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '44'
		
    [76] => SET max_heap_table_size = 1024 * 1024 * 64;
    [77] => SET tmp_table_size = 1024 * 1024 * 32;
    [78] => 		# req=44
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '14' 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
		
	
    [79] => SELECT FOUND_ROWS()
    [80] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [81] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [82] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [83] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [84] => SET max_heap_table_size = 1024 * 1024 * 64;
    [85] => SET tmp_table_size = 1024 * 1024 * 32;
    [86] => 		# req=9
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '5' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '7752') 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_published DESC
		LIMIT 0,1
	
    [87] => SELECT FOUND_ROWS()
    [88] => SELECT rubric_field_alias FROM ave_rubric_fields WHERE Id=18
    [89] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [90] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [91] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [92] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [93] => SET max_heap_table_size = 1024 * 1024 * 64;
    [94] => SET tmp_table_size = 1024 * 1024 * 32;
    [95] => 		# req=9
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '5' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '7752') 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_published DESC
		LIMIT 0,1
	
    [96] => SELECT FOUND_ROWS()
    [97] => 
		SELECT *
		FROM ave_request
		WHERE Id = '8'
	
    [98] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
	
    [99] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [100] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '8'
		
    [101] => SET max_heap_table_size = 1024 * 1024 * 64;
    [102] => SET tmp_table_size = 1024 * 1024 * 32;
    [103] => 		# req=8
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '5' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '7752') 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_published DESC
		LIMIT 0,1
	
    [104] => SELECT FOUND_ROWS()
    [105] => SELECT rubric_field_alias FROM ave_rubric_fields WHERE Id=17
    [106] => 
		SELECT *
		FROM ave_request
		WHERE Id = '66'
	
    [107] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '66' AND condition_status = '1'
	
    [108] => SET max_heap_table_size = 1024 * 1024 * 64;
    [109] => SET tmp_table_size = 1024 * 1024 * 32;
    [110] => 		# req=66
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t34,			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 ((t47.document_id = a.id AND (t47.rubric_field_id = '47' AND UPPER(t47.field_value) != UPPER('1'))) AND (t34.document_id = a.id AND (t34.rubric_field_id = '34' AND UPPER(t34.field_value) = UPPER('6'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,100
	
    [111] => SELECT FOUND_ROWS()
    [112] => 
		SELECT *
		FROM ave_request
		WHERE Id = '40'
	
    [113] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '40' AND condition_status = '1'
	
    [114] => SET max_heap_table_size = 1024 * 1024 * 64;
    [115] => SET tmp_table_size = 1024 * 1024 * 32;
    [116] => 		# req=40
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t43, ave_document_fields AS t55,			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.document_published <= UNIX_TIMESTAMP() AND (a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())) AND ((t43.document_id = a.id AND (t43.rubric_field_id = '43' AND UPPER(t43.field_value) != UPPER('0'))) AND (t55.document_id = a.id AND (t55.rubric_field_id = '55' AND UPPER(t55.field_value) = UPPER('1'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_changed DESC
		LIMIT 0,4
	
    [117] => SELECT FOUND_ROWS()
    [118] => 
		SELECT *
		FROM ave_request
		WHERE Id = '44'
	
    [119] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '44' AND condition_status = '1'
	
    [120] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '44' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [121] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '44'
		
    [122] => SET max_heap_table_size = 1024 * 1024 * 64;
    [123] => SET tmp_table_size = 1024 * 1024 * 32;
    [124] => 		# req=44
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '14' 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
		
	
    [125] => SELECT FOUND_ROWS()
    [126] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [127] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [128] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [129] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [130] => SET max_heap_table_size = 1024 * 1024 * 64;
    [131] => SET tmp_table_size = 1024 * 1024 * 32;
    [132] => 		# req=9
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '5' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '7752') 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_published DESC
		LIMIT 0,1
	
    [133] => SELECT FOUND_ROWS()
    [134] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [135] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [136] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [137] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [138] => SET max_heap_table_size = 1024 * 1024 * 64;
    [139] => SET tmp_table_size = 1024 * 1024 * 32;
    [140] => 		# req=9
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '5' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '7752') 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_published DESC
		LIMIT 0,1
	
    [141] => SELECT FOUND_ROWS()
    [142] => 
		SELECT *
		FROM ave_request
		WHERE Id = '8'
	
    [143] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
	
    [144] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [145] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '8'
		
    [146] => SET max_heap_table_size = 1024 * 1024 * 64;
    [147] => SET tmp_table_size = 1024 * 1024 * 32;
    [148] => 		# req=8
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			
			ave_documents AS a
			
			
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '5' AND
		a.document_deleted != '1') AND (a.document_status = '1') AND (a.Id != '7752') 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_published DESC
		LIMIT 0,1
	
    [149] => SELECT FOUND_ROWS()
    [150] => SELECT * FROM ave_navigation
    [151] => 
		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 = 7752
			AND (
				nav.navi_item_link = 'index.php?id=7752'
			OR nav.document_alias = 'news/kultura'
			OR nav.document_alias = '/news/kultura'
			OR nav.document_alias = 'news/kultura.html'
			OR nav.document_alias = '/news/kultura.html'
		
				OR nav.Id = doc.document_linked_navi_id
			)
	
    [152] => 
		SELECT *
		FROM ave_navigation_items
		WHERE navi_item_status = '1'
		AND navi_id = '1'
		ORDER BY navi_item_position ASC
	
    [153] => 
		SELECT *
		FROM ave_request
		WHERE Id = '16'
	
    [154] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '16' AND condition_status = '1'
	
    [155] => SET max_heap_table_size = 1024 * 1024 * 64;
    [156] => SET tmp_table_size = 1024 * 1024 * 32;
    [157] => 		# req=16
		SELECT STRAIGHT_JOIN
			a.*
			, COUNT(df.Id) AS count 
			
		FROM
			ave_document_fields AS t33,			ave_documents AS a
			
			 LEFT JOIN ave_document_fields AS df ON (df.rubric_field_id = '31' AND df.field_value = a.Id)
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '8' 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 ((t33.document_id = a.id AND (t33.rubric_field_id = '33' AND UPPER(t33.field_value) != UPPER('Автор неизвестен'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_title ASC
		
	
    [158] => SELECT FOUND_ROWS()
)

Время генерации: 2,985 сек.
Пиковое значение 9 749Kb
Количество запросов: 100 шт. за 2,260890 сек.
64   0,624782
# req=66
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t34,			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 <=
 0,000078 starting
 0,000004 checking permissions
 0,000001 checking permissions
 0,000002 checking permissions
 0,000018 Opening tables
 0,000009 System lock
 0,000041 init
 0,000021 optimizing
 0,000286 statistics
 0,000028 preparing
 0,000274 Creating tmp table
 0,000005 executing
 0,622585 Copying to tmp table
 0,000716 Sorting result
 0,000361 Sending data
 0,000007 end
 0,000233 removing tmp table
 0,000009 end
 0,000008 query end
 0,000030 closing tables
 0,000053 freeing items
 0,000003 logging slow query
 0,000009 cleaning up
111   0,632184
# req=66
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t34,			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 <=
 0,000083 starting
 0,000003 checking permissions
 0,000001 checking permissions
 0,000003 checking permissions
 0,000019 Opening tables
 0,000010 System lock
 0,000044 init
 0,000023 optimizing
 0,000319 statistics
 0,000032 preparing
 0,000354 Creating tmp table
 0,000005 executing
 0,629952 Copying to tmp table
 0,000696 Sorting result
 0,000365 Sending data
 0,000008 end
 0,000170 removing tmp table
 0,000007 end
 0,000003 query end
 0,000033 closing tables
 0,000042 freeing items
 0,000004 logging slow query
 0,000010 cleaning up
117   0,136362
# req=40
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t43, ave_document_fields AS t55,			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.document_published <
 0,000103 starting
 0,000005 checking permissions
 0,000001 checking permissions
 0,000003 checking permissions
 0,000025 Opening tables
 0,000012 System lock
 0,000055 init
 0,000028 optimizing
 0,000381 statistics
 0,000035 preparing
 0,000605 Creating tmp table
 0,000008 executing
 0,133272 Copying to tmp table
 0,001174 Sorting result
 0,000067 Sending data
 0,000008 end
 0,000279 removing tmp table
 0,000011 end
 0,000005 query end
 0,000024 closing tables
 0,000249 freeing items
 0,000007 logging slow query
 0,000008 cleaning up
158   0,775017
# req=16
		SELECT STRAIGHT_JOIN
			a.*
			, COUNT(df.Id) AS count 
			
		FROM
			ave_document_fields AS t33,			ave_documents AS a
			
			 LEFT JOIN ave_document_fields AS df ON (df.rubric_field_id = '31' AND df.field_value = a.Id)
		WHERE
			(
		a.Id != '1' AND a.Id != '2' AND
		a.rubric_id = '8' AN
 0,000130 starting
 0,000005 checking permissions
 0,000002 checking permissions
 0,000004 checking permissions
 0,000041 Opening tables
 0,000015 System lock
 0,000084 init
 0,000036 optimizing
 0,000357 statistics
 0,000045 preparing
 0,000423 Creating tmp table
 0,000008 executing
 0,772685 Copying to tmp table
 0,000435 Sending data
 0,000008 end
 0,000655 removing tmp table
 0,000007 end
 0,000003 query end
 0,000016 closing tables
 0,000052 freeing items
 0,000003 logging slow query
 0,000004 cleaning up