Автор статей: Резчиков Андрей

Андрей Резчиков: Сгорела одна из лучших в России библиотек (31.01.2015) Здание одного из лучших в России, а может быть, и в мире собрания книг - фундаментальная библиотека Института научной информации по общественным наукам (ИНИОН) РАН - сгорело. «Потери огромны», говорят сотрудники библиотеки, а ее директор уже назвал произошедшее «драмой для российск...
Просмотров: 1615 Комментариев: 1
Вверх
Полная версия сайта
Мобильная версия сайта
Array
(
    [0] => Array
        (
            [REQUEST_17] => 0.018758
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Время генерации: 0,382 сек.
Пиковое значение 2 622Kb
Количество запросов: 76 шт. за 0,315649 сек.
4   0,133091
SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = 'd71e14c370db4866974b23a5ba24995b'
							LIMIT 1
 0,000016 starting
 0,000003 Waiting for query cache lock
 0,000051 checking query cache for query
 0,000008 checking permissions
 0,000023 Opening tables
 0,000008 System lock
 0,000024 Waiting for query cache lock
 0,000017 init
 0,000008 optimizing
 0,000011 statistics
 0,000007 preparing
 0,000002 executing
 0,131139 Sending data
 0,000020 end
 0,000004 query end
 0,000014 closing tables
 0,000012 freeing items
 0,000003 Waiting for query cache lock
 0,000036 freeing items
 0,000003 Waiting for query cache lock
 0,000002 freeing items
 0,001669 storing result in query cache
 0,000008 logging slow query
 0,000005 cleaning up