Автор статей: Мошкин Михаил

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

    [1] => Array
        (
            [SYSBLOCK_19] => 0.020952
        )

    [2] => Array
        (
            [REQUEST_2] => 0.030345
        )

    [3] => Array
        (
            [REQUEST_3] => 0.019973
        )

    [4] => Array
        (
            [REQUEST_4] => 0.01752
        )

    [5] => Array
        (
            [REQUEST_5] => 0.013805
        )

    [6] => Array
        (
            [SYSBLOCK_5] => 0.08339
        )

    [7] => Array
        (
            [REQUEST_17] => 0.008666
        )

    [8] => Array
        (
            [SYSBLOCK_19] => 0.009353
        )

    [9] => Array
        (
            [REQUEST_2] => 0.03273
        )

    [10] => Array
        (
            [REQUEST_3] => 0.037906
        )

    [11] => Array
        (
            [REQUEST_4] => 0.03046
        )

    [12] => Array
        (
            [REQUEST_5] => 0.025273
        )

    [13] => Array
        (
            [SYSBLOCK_5] => 0.128078
        )

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

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

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

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

)
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 = 'author/moshkin-mihail'
			LIMIT 1
		
    [3] => 
						SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = '9de244291506af258c9c45c3cdc0c207'
							LIMIT 1
					
    [4] => 
		SELECT *
		FROM ave_request
		WHERE Id = '17'
	
    [5] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '17' AND condition_status = '1'
	
    [6] => SET max_heap_table_size = 1024 * 1024 * 64;
    [7] => SET tmp_table_size = 1024 * 1024 * 32;
    [8] => 		# req=17
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t31,			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 ((t31.document_id = a.id AND (t31.rubric_field_id = '31' AND UPPER(t31.field_value) = UPPER('9265'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,20
	
    [9] => SELECT FOUND_ROWS()
    [10] => 
				SELECT *
				FROM ave_module
				WHERE ModuleStatus = '1'
			
    [11] => 
		SELECT *
		FROM ave_request
		WHERE Id = '2'
	
    [12] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '2' AND condition_status = '1'
	
    [13] => SET max_heap_table_size = 1024 * 1024 * 64;
    [14] => SET tmp_table_size = 1024 * 1024 * 32;
    [15] => 		# 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 != '9265') 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
	
    [16] => SELECT FOUND_ROWS()
    [17] => 
		SELECT *
		FROM ave_request
		WHERE Id = '3'
	
    [18] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '3' AND condition_status = '1'
	
    [19] => SET max_heap_table_size = 1024 * 1024 * 64;
    [20] => SET tmp_table_size = 1024 * 1024 * 32;
    [21] => 		# 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 != '9265') 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
	
    [22] => SELECT FOUND_ROWS()
    [23] => 
		SELECT *
		FROM ave_request
		WHERE Id = '4'
	
    [24] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '4' AND condition_status = '1'
	
    [25] => SET max_heap_table_size = 1024 * 1024 * 64;
    [26] => SET tmp_table_size = 1024 * 1024 * 32;
    [27] => 		# 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 != '9265') 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
	
    [28] => SELECT FOUND_ROWS()
    [29] => 
		SELECT *
		FROM ave_request
		WHERE Id = '5'
	
    [30] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '5' AND condition_status = '1'
	
    [31] => SET max_heap_table_size = 1024 * 1024 * 64;
    [32] => SET tmp_table_size = 1024 * 1024 * 32;
    [33] => 		# 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 != '9265') 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
	
    [34] => SELECT FOUND_ROWS()
    [35] => 
		SELECT *
		FROM ave_request
		WHERE Id = '17'
	
    [36] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '17' AND condition_status = '1'
	
    [37] => SET max_heap_table_size = 1024 * 1024 * 64;
    [38] => SET tmp_table_size = 1024 * 1024 * 32;
    [39] => 		# req=17
		SELECT STRAIGHT_JOIN
			a.*
			
			
		FROM
			ave_document_fields AS t31,			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 ((t31.document_id = a.id AND (t31.rubric_field_id = '31' AND UPPER(t31.field_value) = UPPER('9265'))) AND 1=1)
			
		#GROUP BY a.Id
		ORDER BY a.document_published DESC
		LIMIT 0,20
	
    [40] => SELECT FOUND_ROWS()
    [41] => 
		SELECT *
		FROM ave_request
		WHERE Id = '2'
	
    [42] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '2' AND condition_status = '1'
	
    [43] => SET max_heap_table_size = 1024 * 1024 * 64;
    [44] => SET tmp_table_size = 1024 * 1024 * 32;
    [45] => 		# 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 != '9265') 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
	
    [46] => SELECT FOUND_ROWS()
    [47] => 
		SELECT *
		FROM ave_request
		WHERE Id = '3'
	
    [48] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '3' AND condition_status = '1'
	
    [49] => SET max_heap_table_size = 1024 * 1024 * 64;
    [50] => SET tmp_table_size = 1024 * 1024 * 32;
    [51] => 		# 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 != '9265') 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
	
    [52] => SELECT FOUND_ROWS()
    [53] => 
		SELECT *
		FROM ave_request
		WHERE Id = '4'
	
    [54] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '4' AND condition_status = '1'
	
    [55] => SET max_heap_table_size = 1024 * 1024 * 64;
    [56] => SET tmp_table_size = 1024 * 1024 * 32;
    [57] => 		# 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 != '9265') 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
	
    [58] => SELECT FOUND_ROWS()
    [59] => 
		SELECT *
		FROM ave_request
		WHERE Id = '5'
	
    [60] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '5' AND condition_status = '1'
	
    [61] => SET max_heap_table_size = 1024 * 1024 * 64;
    [62] => SET tmp_table_size = 1024 * 1024 * 32;
    [63] => 		# 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 != '9265') 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
	
    [64] => SELECT FOUND_ROWS()
    [65] => 
		SELECT *
		FROM ave_request
		WHERE Id = '22'
	
    [66] => 
		SELECT DISTINCT(condition_field_id) AS fid
		FROM ave_request_conditions
		WHERE request_id = '22' AND condition_status = '1'
	
    [67] => SET max_heap_table_size = 1024 * 1024 * 64;
    [68] => SET tmp_table_size = 1024 * 1024 * 32;
    [69] => 		# 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
		
	
    [70] => SELECT FOUND_ROWS()
    [71] => SELECT * FROM ave_navigation
    [72] => 
		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 = 9265
			AND (
				nav.navi_item_link = 'index.php?id=9265'
			OR nav.document_alias = 'author/moshkin-mihail'
			OR nav.document_alias = '/author/moshkin-mihail'
			OR nav.document_alias = 'author/moshkin-mihail.html'
			OR nav.document_alias = '/author/moshkin-mihail.html'
		
				OR nav.Id = doc.document_linked_navi_id
			)
	
    [73] => 
		SELECT *
		FROM ave_navigation_items
		WHERE navi_item_status = '1'
		AND navi_id = '1'
		ORDER BY navi_item_position ASC
	
)

Время генерации: 0,359 сек.
Пиковое значение 2 517Kb
Количество запросов: 74 шт. за 0,292811 сек.