Николич Томислав: все материалы

[Событие] Президент Сербии: ущерб от остановки "Южного потока" будет меньше, чем был бы от санкций
Ситуация с остановкой Россией реализации проекта строительства газопровода "Южный поток" неблагоприятна для Сербии. Об этом президент республики Томислав Николич заявил во вторник вечером в эфире телеканала РТС.При этом, уверен он, ущерб Сербии от такого шага будет меньше, чем был бы для н...
Опубликовано: 03.12.2014 Просмотров: 1092
[Событие] Владимир Путин в Сербии: Россия дружбой не торгует
Президент РФ Владимир Путин сегодня прибыл в столицу Сербии, где проводит переговоры с руководством страны. Российский лидер также примет участие в праздновании 70-летия освобождения Белграда от немецко-фашистских захватчиков в результате совместной операции советских и югославских войск. В ходе вст...
Опубликовано: 16.10.2014 Просмотров: 1441
Все персоналии
Вверх
Полная версия сайта
Мобильная версия сайта
Array
(
    [0] => Array
        (
            [REQUEST_2] => 0.053005
        )

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

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

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

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

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

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

    [7] => Array
        (
            [REQUEST_4] => 0.02134
        )

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

    [9] => Array
        (
            [SYSBLOCK_5] => 0.105259
        )

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

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

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

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

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

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

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

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

)
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/nikolich-tomislav'
			LIMIT 1
		
    [3] => 
						SELECT compiled
							FROM ave_rubric_template_cache
						WHERE hash  = 'dd00799ce5fabe870b208ca775a47bfc'
							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 != '3752') 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 != '3752') 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 != '3752') 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 != '3752') 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 != '3752') 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 != '3752') 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 != '3752') 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 != '3752') 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 != '3752') 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('%|3752|%'))) 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('%|3752|%'))) 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('%|3752|%'))) 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 != '3752') 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('%|3752|%'))) 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('%|3752|%'))) 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('%|3752|%'))) 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 = 3752
			AND (
				nav.navi_item_link = 'index.php?id=3752'
			OR nav.document_alias = 'person/nikolich-tomislav'
			OR nav.document_alias = '/person/nikolich-tomislav'
			OR nav.document_alias = 'person/nikolich-tomislav.html'
			OR nav.document_alias = '/person/nikolich-tomislav.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 rubric_field_alias FROM ave_rubric_fields WHERE Id=53
    [99] => 
		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|%'
	
    [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 '%|1761|%'
	
    [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 '%|2997|%'
	
    [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 '%|1412|%'
	
    [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 '%|12092|%'
	
    [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 '%|9912|%'
	
    [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 '%|1414|%'
	
    [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 '%|1410|%'
	
    [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 '%|8382|%'
	
    [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 '%|21419|%'
	
    [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 '%|5085|%'
	
    [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 '%|1413|%'
	
    [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 '%|17869|%'
	
    [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 '%|8996|%'
	
    [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 '%|1760|%'
	
    [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 '%|1411|%'
	
    [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 '%|1416|%'
	
    [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 '%|32311|%'
	
    [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 '%|8441|%'
	
    [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 '%|1620|%'
	
    [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 '%|1812|%'
	
    [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 '%|1415|%'
	
    [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 '%|29518|%'
	
    [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 '%|3713|%'
	
    [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 '%|4684|%'
	
    [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 '%|15751|%'
	
)

Время генерации: 0,539 сек.
Пиковое значение 2 831Kb
Количество запросов: 100 шт. за 0,322220 сек.
84   0,127858
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,000007 starting
 0,000002 Waiting for query cache lock
 0,000292 checking query cache for query
 0,000005 checking permissions
 0,000001 checking permissions
 0,000002 checking permissions
 0,000001 checking permissions
 0,000001 checking permissions
 0,000001 checking permissions
 0,000003 checking permissions
 0,000075 Opening tables
 0,001040 System lock
 0,000037 optimizing
 0,000510 statistics
 0,000039 preparing
 0,000278 Creating tmp table
 0,000011 executing
 0,013606 Copying to tmp table
 0,000089 Sorting result
 0,000018 Sending data
 0,000047 optimizing
 0,000437 statistics
 0,000060 preparing
 0,000836 Creating tmp table
 0,000009 executing
 0,095124 Copying to tmp table
 0,000065 Sorting result
 0,000138 Sending data
 0,000058 optimizing
 0,000329 statistics
 0,000059 preparing
 0,000007 executing
 0,013631 Sending data
 0,000019 optimizing
 0,000012 statistics
 0,000012 preparing
 0,000004 executing
 0,000132 Sending data
 0,000168 removing tmp table
 0,000011 Sending data
 0,000081 removing tmp table
 0,000012 Sending data
 0,000098 removing tmp table
 0,000092 Sending data
 0,000045 init
 0,000007 optimizing
 0,000012 statistics
 0,000008 preparing
 0,000002 executing
 0,000034 Sorting result
 0,000055 Sending data
 0,000008 end
 0,000003 query end
 0,000003 closing tables
 0,000101 removing tmp table
 0,000038 closing tables
 0,000077 freeing items
 0,000006 logging slow query
 0,000007 cleaning up