Архив выпусков


№65(69) от 09.09.2014

№64 (68) от 31.07.2014

№63(67) от 15.07.2014

№61(65) от 17.06.2014

№60(64) от 20.05.2014

№59(63) от 25.04.2014

№58 (62) от 08.04.2014

№57(61) от 28.03.2014

№56(60) от 18.03.2014

№54(58) от 28.02.2014

№53(57) от 14.02.2014

№52 (56) от 31/01/2014

№51(55) от 17.01.2014

№50(54) от 27.12.2013

№49(53) от 20.12.2013

№48(52) от 13.12.2013

№47(51) от 06.12.2013

№46(50) от 29.11.2013

№45(49) от 22.11.2013

№44(48) от 15.11.2013

№43(47) от 08.11.2013

№42 (46) от 01.11.2013

№41(45) от 25.10.2013

№40 (44) от 18.10.2013

№39 (43) от 11.10.2013

№38 (42) от 04.10.2013

№37 (41) от 27.09.2013

№36 (40) от 20.09.2013

№35 (39) от 13.09.2013

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

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

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

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

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

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

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

    [7] => Array
        (
            [REQUEST_2] => -0.945761
        )

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

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

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

    [11] => Array
        (
            [SYSBLOCK_5] => -0.849732
        )

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

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

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

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

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

    [17] => Array
        (
            [REQUEST_40] => 0.110346
        )

    [18] => Array
        (
            [REQUEST_9] => 0.006
        )

    [19] => Array
        (
            [REQUEST_9] => 0.003709
        )

    [20] => Array
        (
            [REQUEST_8] => 0.006533
        )

    [21] => Array
        (
            [REQUEST_10] => 0.101406
        )

    [22] => Array
        (
            [REQUEST_80] => -0.022567
        )

    [23] => Array
        (
            [REQUEST_40] => 0.083146
        )

    [24] => Array
        (
            [REQUEST_9] => 0.003576
        )

    [25] => Array
        (
            [REQUEST_9] => 0.00284
        )

    [26] => Array
        (
            [REQUEST_8] => 0.002431
        )

    [27] => Array
        (
            [REQUEST_10] => 0.071151
        )

    [28] => Array
        (
            [REQUEST_80] => -0.364659
        )

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

)
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 = 'archive'
			LIMIT 1
		
    [3] => 
						SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = '03313b40efab8c15bb93dff8229de5c5'
							LIMIT 1
					
    [4] => 
				SELECT rubric_start_code
				FROM ave_rubrics
				WHERE Id = '1'
				LIMIT 1
				
    [5] => 
							SELECT rubric_header_template
								FROM ave_rubrics
							WHERE Id = '1'
								LIMIT 1
						
    [6] => 
		SELECT *
		FROM ave_request
		WHERE Id = '2'
	
    [7] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '2' AND condition_status = '1'
	
    [8] => SET max_heap_table_size = 1024 * 1024 * 64;
    [9] => SET tmp_table_size = 1024 * 1024 * 32;
    [10] => 		# 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 != '31') 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
	
    [11] => SELECT FOUND_ROWS()
    [12] => 
				SELECT *
				FROM ave_module
				WHERE ModuleStatus = '1'
			
    [13] => 
		SELECT *
		FROM ave_request
		WHERE Id = '3'
	
    [14] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '3' AND condition_status = '1'
	
    [15] => SET max_heap_table_size = 1024 * 1024 * 64;
    [16] => SET tmp_table_size = 1024 * 1024 * 32;
    [17] => 		# 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 != '31') 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
	
    [18] => SELECT FOUND_ROWS()
    [19] => 
		SELECT *
		FROM ave_request
		WHERE Id = '4'
	
    [20] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '4' AND condition_status = '1'
	
    [21] => SET max_heap_table_size = 1024 * 1024 * 64;
    [22] => SET tmp_table_size = 1024 * 1024 * 32;
    [23] => 		# 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 != '31') 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
	
    [24] => SELECT FOUND_ROWS()
    [25] => 
		SELECT *
		FROM ave_request
		WHERE Id = '5'
	
    [26] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '5' AND condition_status = '1'
	
    [27] => SET max_heap_table_size = 1024 * 1024 * 64;
    [28] => SET tmp_table_size = 1024 * 1024 * 32;
    [29] => 		# 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 != '31') 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
	
    [30] => SELECT FOUND_ROWS()
    [31] => 
		SELECT *
		FROM ave_request
		WHERE Id = '2'
	
    [32] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '2' AND condition_status = '1'
	
    [33] => SET max_heap_table_size = 1024 * 1024 * 64;
    [34] => SET tmp_table_size = 1024 * 1024 * 32;
    [35] => 		# 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 != '31') 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
	
    [36] => SELECT FOUND_ROWS()
    [37] => 
		SELECT *
		FROM ave_request
		WHERE Id = '3'
	
    [38] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '3' AND condition_status = '1'
	
    [39] => SET max_heap_table_size = 1024 * 1024 * 64;
    [40] => SET tmp_table_size = 1024 * 1024 * 32;
    [41] => 		# 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 != '31') 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
	
    [42] => SELECT FOUND_ROWS()
    [43] => 
		SELECT *
		FROM ave_request
		WHERE Id = '4'
	
    [44] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '4' AND condition_status = '1'
	
    [45] => SET max_heap_table_size = 1024 * 1024 * 64;
    [46] => SET tmp_table_size = 1024 * 1024 * 32;
    [47] => 		# 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 != '31') 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
	
    [48] => SELECT FOUND_ROWS()
    [49] => 
		SELECT *
		FROM ave_request
		WHERE Id = '5'
	
    [50] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '5' AND condition_status = '1'
	
    [51] => SET max_heap_table_size = 1024 * 1024 * 64;
    [52] => SET tmp_table_size = 1024 * 1024 * 32;
    [53] => 		# 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 != '31') 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
	
    [54] => SELECT FOUND_ROWS()
    [55] => 
		SELECT *
		FROM ave_request
		WHERE Id = '22'
	
    [56] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '22' AND condition_status = '1'
	
    [57] => SET max_heap_table_size = 1024 * 1024 * 64;
    [58] => SET tmp_table_size = 1024 * 1024 * 32;
    [59] => 		# 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
		
	
    [60] => SELECT FOUND_ROWS()
    [61] => 
		SELECT *
		FROM ave_request
		WHERE Id = '40'
	
    [62] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '40' AND condition_status = '1'
	
    [63] => SET max_heap_table_size = 1024 * 1024 * 64;
    [64] => SET tmp_table_size = 1024 * 1024 * 32;
    [65] => 		# 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
	
    [66] => SELECT FOUND_ROWS()
    [67] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [68] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [69] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [70] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [71] => SET max_heap_table_size = 1024 * 1024 * 64;
    [72] => SET tmp_table_size = 1024 * 1024 * 32;
    [73] => 		# 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 != '31') 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
	
    [74] => SELECT FOUND_ROWS()
    [75] => SELECT rubric_field_alias FROM ave_rubric_fields WHERE Id=18
    [76] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [77] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [78] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [79] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [80] => SET max_heap_table_size = 1024 * 1024 * 64;
    [81] => SET tmp_table_size = 1024 * 1024 * 32;
    [82] => 		# 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 != '31') 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
	
    [83] => SELECT FOUND_ROWS()
    [84] => 
		SELECT *
		FROM ave_request
		WHERE Id = '8'
	
    [85] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
	
    [86] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [87] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '8'
		
    [88] => SET max_heap_table_size = 1024 * 1024 * 64;
    [89] => SET tmp_table_size = 1024 * 1024 * 32;
    [90] => 		# 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 != '31') 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
	
    [91] => SELECT FOUND_ROWS()
    [92] => SELECT rubric_field_alias FROM ave_rubric_fields WHERE Id=17
    [93] => 
		SELECT *
		FROM ave_request
		WHERE Id = '10'
	
    [94] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '10' AND condition_status = '1'
	
    [95] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '10' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [96] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '10'
		
    [97] => SET max_heap_table_size = 1024 * 1024 * 64;
    [98] => SET tmp_table_size = 1024 * 1024 * 32;
    [99] => 		# req=10
		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 != '31') 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,30
	
    [100] => SELECT FOUND_ROWS()
    [101] => SELECT rubric_field_alias FROM ave_rubric_fields WHERE Id=15
    [102] => SELECT rubric_field_alias FROM ave_rubric_fields WHERE Id=16
    [103] => 
		SELECT *
		FROM ave_request
		WHERE Id = '80'
	
    [104] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '80' AND condition_status = '1'
	
    [105] => SET max_heap_table_size = 1024 * 1024 * 64;
    [106] => SET tmp_table_size = 1024 * 1024 * 32;
    [107] => 		# req=80
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t97,			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 (t97.document_id = a.id AND (t97.rubric_field_id = '97' AND UPPER(t97.field_value) != UPPER('1'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,40
	
    [108] => SELECT FOUND_ROWS()
    [109] => 
		SELECT *
		FROM ave_request
		WHERE Id = '40'
	
    [110] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '40' AND condition_status = '1'
	
    [111] => SET max_heap_table_size = 1024 * 1024 * 64;
    [112] => SET tmp_table_size = 1024 * 1024 * 32;
    [113] => 		# 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
	
    [114] => SELECT FOUND_ROWS()
    [115] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [116] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [117] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [118] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [119] => SET max_heap_table_size = 1024 * 1024 * 64;
    [120] => SET tmp_table_size = 1024 * 1024 * 32;
    [121] => 		# 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 != '31') 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
	
    [122] => SELECT FOUND_ROWS()
    [123] => 
		SELECT *
		FROM ave_request
		WHERE Id = '9'
	
    [124] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
	
    [125] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '9' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [126] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '9'
		
    [127] => SET max_heap_table_size = 1024 * 1024 * 64;
    [128] => SET tmp_table_size = 1024 * 1024 * 32;
    [129] => 		# 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 != '31') 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
	
    [130] => SELECT FOUND_ROWS()
    [131] => 
		SELECT *
		FROM ave_request
		WHERE Id = '8'
	
    [132] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
	
    [133] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '8' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [134] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '8'
		
    [135] => SET max_heap_table_size = 1024 * 1024 * 64;
    [136] => SET tmp_table_size = 1024 * 1024 * 32;
    [137] => 		# 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 != '31') 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
	
    [138] => SELECT FOUND_ROWS()
    [139] => 
		SELECT *
		FROM ave_request
		WHERE Id = '10'
	
    [140] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '10' AND condition_status = '1'
	
    [141] => 
		SELECT *
		FROM ave_request_conditions
		WHERE request_id = '10' AND condition_status = '1'
		ORDER BY condition_position ASC
	
    [142] => 
			UPDATE ave_request
			SET	request_where_cond = ''
			WHERE Id = '10'
		
    [143] => SET max_heap_table_size = 1024 * 1024 * 64;
    [144] => SET tmp_table_size = 1024 * 1024 * 32;
    [145] => 		# req=10
		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 != '31') 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,30
	
    [146] => SELECT FOUND_ROWS()
    [147] => 
		SELECT *
		FROM ave_request
		WHERE Id = '80'
	
    [148] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '80' AND condition_status = '1'
	
    [149] => SET max_heap_table_size = 1024 * 1024 * 64;
    [150] => SET tmp_table_size = 1024 * 1024 * 32;
    [151] => 		# req=80
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t97,			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 (t97.document_id = a.id AND (t97.rubric_field_id = '97' AND UPPER(t97.field_value) != UPPER('1'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,40
	
    [152] => SELECT FOUND_ROWS()
    [153] => SELECT * FROM ave_navigation
    [154] => 
		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 = 31
			AND (
				nav.navi_item_link = 'index.php?id=31'
			OR nav.document_alias = 'archive'
			OR nav.document_alias = '/archive'
			OR nav.document_alias = 'archive.html'
			OR nav.document_alias = '/archive.html'
		
				OR nav.Id = doc.document_linked_navi_id
			)
	
    [155] => 
		SELECT *
		FROM ave_navigation_items
		WHERE navi_item_status = '1'
		AND navi_id = '1'
		ORDER BY navi_item_position ASC
	
)

Время генерации: 2,634 сек.
Пиковое значение 3 461Kb
Количество запросов: 100 шт. за 1,799365 сек.
66   0,108089
# 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,000081 starting
 0,000004 checking permissions
 0,000002 checking permissions
 0,000002 checking permissions
 0,000036 Opening tables
 0,000010 System lock
 0,000046 init
 0,000024 optimizing
 0,000312 statistics
 0,000032 preparing
 0,000296 Creating tmp table
 0,000006 executing
 0,105999 Copying to tmp table
 0,000870 Sorting result
 0,000074 Sending data
 0,000005 end
 0,000193 removing tmp table
 0,000008 end
 0,000003 query end
 0,000027 closing tables
 0,000052 freeing items
 0,000004 logging slow query
 0,000005 cleaning up
108   0,964706
# req=80
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t97,			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,000151 starting
 0,000006 checking permissions
 0,000002 checking permissions
 0,000003 checking permissions
 0,000031 Opening tables
 0,000016 System lock
 0,000068 init
 0,000032 optimizing
 0,000382 statistics
 0,000042 preparing
 0,000422 Creating tmp table
 0,000006 executing
 0,951625 Copying to tmp table
 0,010463 Sorting result
 0,000196 Sending data
 0,000015 end
 0,001150 removing tmp table
 0,000009 end
 0,000003 query end
 0,000018 closing tables
 0,000060 freeing items
 0,000003 logging slow query
 0,000005 cleaning up
152   0,628429
# req=80
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t47, ave_document_fields AS t97,			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,000142 starting
 0,000005 checking permissions
 0,000001 checking permissions
 0,000002 checking permissions
 0,000026 Opening tables
 0,000012 System lock
 0,000056 init
 0,000027 optimizing
 0,000358 statistics
 0,000037 preparing
 0,000458 Creating tmp table
 0,000009 executing
 0,615715 Copying to tmp table
 0,010089 Sorting result
 0,000159 Sending data
 0,000005 end
 0,001222 removing tmp table
 0,000008 end
 0,000003 query end
 0,000019 closing tables
 0,000067 freeing items
 0,000005 logging slow query
 0,000007 cleaning up