Domů | Kulturní zařízení Valašského Meziříčí

Core:

Infomrace o jádře
CORE
Úroveň DEBUG režimu:	2	IP:	18.97.14.86
Exec time jádra:	0,0772	SQL dotazů:	63
Aktuální uživatel:	anonym - ID:-1	Verze jádra:	8.5.3
Název webu (VVE_WEB_NAME):	Kulturní zařízení...	Název vzhledu (face):	kzvalmez
Modul:	kzmainpage	Akce:	main
Kategorie:	Domů	ID kategorie:	2
XDEBUG
Paměť:	18 870 648 B	Spuštěno funkcí:	3 218 827
Paměť (špička):	42 454 808 B	Index time (s kompilací css/js):	1,717734783
Optimalizace
Používá se cache:	Ne	Typ cache:	Cache_Provider_NoCache

SQL: (celkem: 63, čas: 0.013813 s)

QUERY: 1, čas: 0.000563 s, počet: 1

SQL: [1711] SELECT  `t_ph_imgs`.`id_image`, `t_ph_imgs`.`id_category`, `t_ph_imgs`.`image_label_cs` , `t_ph_imgs`.`image_link_cs` , `t_ph_imgs`.`image_order`, `t_ph_imgs`.`image_active`, `t_ph_imgs`.`image_file`, `t_ph_imgs`.`valid_from`, `t_ph_imgs`.`valid_to`, `t_ph_imgs`.`slogan_background`, `Model_Category_1`.`id_owner_user` AS `id_owner_user`, `Model_Category_1`.`label_cs` AS label_cs, `Model_Category_1`.`alt_cs` AS alt_cs, `Model_Category_1`.`urlkey_cs` AS urlkey_cs, `Model_Category_1`.`disable_cs` AS disable_cs, `Model_Category_1`.`module` AS `module`, `Model_Category_1`.`data_dir` AS `data_dir`, `Model_Category_1`.`individual_panels` AS `individual_panels`, `Model_Category_1`.`visibility` AS `visibility`, `Model_Category_1`.`ser_params` AS `ser_params`, `Model_Category_1`.`priority` AS `priority`, `Model_Category_1`.`default_right` AS `default_right`, `Model_Category_1`.`active` AS `active`, `Model_Category_1`.`keywords_cs` AS keywords_cs, `Model_Category_1`.`description_cs` AS description_cs, `Model_Category_1`.`changed` AS `changed`, `Model_Category_1`.`created` AS `created`, `Model_Category_1`.`feeds` AS `feeds`, `Model_Category_1`.`icon` AS `icon`, `Model_Category_1`.`background` AS `background`, `Model_Category_1`.`sitemap_changefreq` AS `sitemap_changefreq`, `Model_Category_1`.`sitemap_priority` AS `sitemap_priority` FROM `kzvalmez_dev_221024`.`kz_hpslideshow_images` AS t_ph_imgs LEFT JOIN kz_categories AS Model_Category_1 ON (`Model_Category_1`.`id_category` = `t_ph_imgs`.`id_category`)
 WHERE (`t_ph_imgs`.`image_active` = 1  AND `t_ph_imgs`.`valid_from` <=  NOW()  AND ( `t_ph_imgs`.`valid_to` IS NULL OR `t_ph_imgs`.`valid_to` >=  NOW()) )
 ORDER BY `t_ph_imgs`.`image_order` ASC

Params:  0

;

QUERY: 2, čas: 0.000401 s, počet: 1

SQL: [5743] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`id_event` NOT IN(:key_0) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d395c4_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  7
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d395c4_arr_0
paramno=-1
name=[15] ":22d395c4_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 3, čas: 0.000390 s, počet: 1

SQL: [5703] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d34827_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  6
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d34827_arr_0
paramno=-1
name=[15] ":22d34827_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 4, čas: 0.000373 s, počet: 1

SQL: [156] SELECT COUNT(`t_ipblocks`.`ip_address`) AS cnt  FROM `kzvalmez_dev_221024`.`cubecms_global_ipblock` AS t_ipblocks WHERE (`t_ipblocks`.`ip_address` = :idb )

Params:  1
Key: Name: [4] :idb
paramno=-1
name=[4] ":idb"
is_param=1
param_type=2

;

QUERY: 5, čas: 0.000318 s, počet: 21

SQL: [932] SELECT  `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
 WHERE (  ( SUBSTRING(`right`, 1, 1) = 'r' OR  ( `right` IS NULL AND SUBSTRING(`default_right`, 1, 1) = 'r' ))   AND disable_cs = 0  AND 1 = 1 AND `t_cats`.`disable_cs` = 0 AND `t_cats`.`module` = :module )

Params:  1
Key: Name: [7] :module
paramno=-1
name=[7] ":module"
is_param=1
param_type=2

;

QUERY: 6, čas: 0.000260 s, počet: 1

SQL: [5750] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`id_event` NOT IN(:key_0,:key_1) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d3c50c_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  8
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=1
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d3c50c_arr_0
paramno=-1
name=[15] ":22d3c50c_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 7, čas: 0.000245 s, počet: 1

SQL: [5743] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`id_event` NOT IN(:key_0) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d3a653_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  7
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d3a653_arr_0
paramno=-1
name=[15] ":22d3a653_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 8, čas: 0.000245 s, počet: 1

SQL: [5703] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d36867_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  6
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d36867_arr_0
paramno=-1
name=[15] ":22d36867_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 9, čas: 0.000238 s, počet: 1

SQL: [5703] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d358a6_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  6
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d358a6_arr_0
paramno=-1
name=[15] ":22d358a6_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 10, čas: 0.000237 s, počet: 1

SQL: [863] SELECT  `t_partners`.`id_partner`, `t_partners`.`id_group`, `t_partners`.`partner_name`, `t_partners`.`partner_text`, `t_partners`.`partner_note`, `t_partners`.`partner_url`, `t_partners`.`partner_image`, `t_partners`.`partner_order`, `t_partners`.`partner_disabled`, `Partners_Model_Groups_1`.`id_partners_group` AS `id_partners_group`, `Partners_Model_Groups_1`.`id_category` AS `id_category`, `Partners_Model_Groups_1`.`partner_group_name_cs` AS partner_group_name_cs, `Partners_Model_Groups_1`.`partner_group_order` AS `partner_group_order` FROM `kzvalmez_dev_221024`.`kz_partners` AS t_partners LEFT JOIN kz_partners_groups AS Partners_Model_Groups_1 ON (`Partners_Model_Groups_1`.`id_partners_group` = `t_partners`.`id_group`)
 WHERE (id_category = :idc )
 ORDER BY `partner_group_order` ASC,`t_partners`.`partner_order` ASC,`t_partners`.`partner_name` ASC

Params:  1
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1

;

QUERY: 11, čas: 0.000205 s, počet: 2

SQL: [3786] SELECT `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT 
            GROUP_CONCAT(IFNULL(id_event_time, ""),';', 
                IFNULL(event_date_begin, ""),';', 
                IFNULL(event_date_end, ""), ';',
                IFNULL(event_time_begin, ""), ';',
                IFNULL(event_time_end, ""), ';',
                IFNULL(event_time_text, ""), ';'
                ORDER BY event_date_begin, event_time_begin SEPARATOR '|')
			FROM kz_adv_events_times AS t WHERE t.id_event = t_event.id_event  GROUP BY t.id_event ) AS `times`, `AdvEventsBase_Model_Organizers_2`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_2`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_2`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_3`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_3`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_3`.`ev_category_data` AS `ev_category_data`, `images`.`event_image_file` AS `title_image`, `images`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event LEFT JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_2 ON (`AdvEventsBase_Model_Organizers_2`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_3 ON (`AdvEventsBase_Model_Categories_3`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS images ON (`images`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (`t_event`.`id_event` = :col )
 GROUP BY `t_event`.`id_event`
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  3
Key: Name: [4] :col
paramno=-1
name=[4] ":col"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1

;

QUERY: 12, čas: 0.000204 s, počet: 1

SQL: [247] SELECT `t_ses`.`session_key`, `t_ses`.`value`, `t_ses`.`ip`, `t_ses`.`created`, `t_ses`.`updated`, `t_ses`.`id_user` FROM `kzvalmez_dev_221024`.`kz_sessions` AS t_ses WHERE (`t_ses`.`session_key` = :key  )
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  3
Key: Name: [4] :key
paramno=-1
name=[4] ":key"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1

;

QUERY: 13, čas: 0.000163 s, počet: 1

SQL: [5778] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`id_event` NOT IN(:key_0,:key_1,:key_2,:key_3,:key_4,:key_5) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d402ec_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  12
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=1
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=1
Key: Name: [6] :key_3
paramno=-1
name=[6] ":key_3"
is_param=1
param_type=1
Key: Name: [6] :key_4
paramno=-1
name=[6] ":key_4"
is_param=1
param_type=1
Key: Name: [6] :key_5
paramno=-1
name=[6] ":key_5"
is_param=1
param_type=1
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d402ec_arr_0
paramno=-1
name=[15] ":22d402ec_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 14, čas: 0.000157 s, počet: 1

SQL: [5764] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`id_event` NOT IN(:key_0,:key_1,:key_2,:key_3) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d3ea48_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  10
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=1
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=1
Key: Name: [6] :key_3
paramno=-1
name=[6] ":key_3"
is_param=1
param_type=1
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d3ea48_arr_0
paramno=-1
name=[15] ":22d3ea48_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 15, čas: 0.000154 s, počet: 1

SQL: [5785] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`id_event` NOT IN(:key_0,:key_1,:key_2,:key_3,:key_4,:key_5,:key_6) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d40f66_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  13
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=1
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=1
Key: Name: [6] :key_3
paramno=-1
name=[6] ":key_3"
is_param=1
param_type=1
Key: Name: [6] :key_4
paramno=-1
name=[6] ":key_4"
is_param=1
param_type=1
Key: Name: [6] :key_5
paramno=-1
name=[6] ":key_5"
is_param=1
param_type=1
Key: Name: [6] :key_6
paramno=-1
name=[6] ":key_6"
is_param=1
param_type=1
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d40f66_arr_0
paramno=-1
name=[15] ":22d40f66_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 16, čas: 0.000151 s, počet: 1

SQL: [310] SELECT  `t_cats`.`id_category`, `t_cats`.`label_cs` AS label, `t_cats`.`urlkey_cs` AS urlkey, `t_r`.`id_group`, `t_r`.`right` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
 WHERE (`t_cats`.`feeds` = 1 )

Params:  0

;

QUERY: 17, čas: 0.000149 s, počet: 8

SQL: [638] SELECT  `t_event_times`.`id_event_time`, `t_event_times`.`id_event`, `t_event_times`.`event_time_text`, `t_event_times`.`event_date_begin`, `t_event_times`.`event_date_end`, `t_event_times`.`event_time_begin`, `t_event_times`.`event_time_end`, `t_event_times`.`event_time_price`, `t_event_times`.`event_time_price_reduced`, `t_event_times`.`event_time_language`, `t_event_times`.`event_time_format`, `t_event_times`.`event_time_coloseum_id` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE (`t_event_times`.`id_event` = :ide )
 ORDER BY `t_event_times`.`event_date_begin` ASC,`t_event_times`.`event_time_begin` ASC

Params:  1
Key: Name: [4] :ide
paramno=-1
name=[4] ":ide"
is_param=1
param_type=2

;

QUERY: 18, čas: 0.000142 s, počet: 1

SQL: [5771] SELECT  `t_event`.`id_event`, `t_event`.`id_event`, `t_event`.`id_parent_event`, `t_event`.`id_ev_category`, `t_event`.`id_place`, `t_event`.`id_ev_organizer`, `t_event`.`event_name`, `t_event`.`event_subname`, `t_event`.`event_urlkey`, `t_event`.`event_text`, `t_event`.`event_text_clear`, `t_event`.`event_perex`, `t_event`.`event_author`, `t_event`.`event_website`, `t_event`.`event_active`, `t_event`.`event_recommended`, `t_event`.`event_canceled`, `t_event`.`event_moved`, `t_event`.`event_sell_out`, `t_event`.`event_show_hp`, `t_event`.`event_approved`, `t_event`.`event_place_alt`, `t_event`.`event_url_facebook`, `t_event`.`event_url_youtube`, `t_event`.`event_url_buy`, `t_event`.`event_coloseum_id`, `t_event`.`event_buy_end_days_before`, `t_event`.`event_price`, `t_event`.`event_price_reduced`, `t_event`.`event_price_advance`, `t_event`.`event_price_advance_reduced`, `t_event`.`event_price_second_row`, `t_event`.`event_time_edit`, `t_event`.`event_source`, `t_event`.`event_source_id`, `t_event`.`event_data`, `t_event`.`event_type`, `t_event`.`event_allow_import`, `t_event`.`event_accessibility`, `t_event`.`event_map_url`, `t_event`.`event_image`, ( SELECT GROUP_CONCAT(id_ev_place, ':',place_name SEPARATOR ';') AS `placesstr` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = `t_event`.`id_event`)
 GROUP BY `events_id_event`
 ORDER BY `t_advevent_places`.`place_name` ASC
 ) AS `places_short`, IF(MIN(ttimes1.event_date_begin) IS NULL, 10000,  (ABS(DATEDIFF(MIN(ttimes1.event_date_begin), :ordDate))  -  IF(event_organizer_priority > 0 , event_organizer_priority/ 1000, 0) - IF(event_time_begin IS NULL, 0, 0.001) ) ) AS `ordered`, IF(MIN(ttimes1.event_time_begin) IS NULL, '23:59:59', MIN(ttimes1.event_time_begin)) AS `orderedTimes`, `ttimes1`.`id_event_time` AS `id_event_time`, `ttimes1`.`event_time_text` AS `event_time_text`, `ttimes1`.`event_date_begin` AS `event_date_begin`, `ttimes1`.`event_date_end` AS `event_date_end`, `ttimes1`.`event_time_begin` AS `event_time_begin`, `ttimes1`.`event_time_end` AS `event_time_end`, `ttimes1`.`event_time_price` AS `event_time_price`, `ttimes1`.`event_time_price_reduced` AS `event_time_price_reduced`, `ttimes1`.`event_time_language` AS `event_time_language`, `ttimes1`.`event_time_format` AS `event_time_format`, `ttimes1`.`event_time_coloseum_id` AS `event_time_coloseum_id`, `AdvEventsBase_Model_Organizers_5`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_5`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_5`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_6`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_6`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_6`.`ev_category_data` AS `ev_category_data`, `iamges`.`event_image_file` AS `title_image`, `iamges`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event 
 INNER JOIN (SELECT MIN(TIMESTAMP(event_date_begin,  IF(event_time_begin IS NOT NULL, event_time_begin, '23:59:59')) )  AS `min_date`, `t_event_times`.`id_event_time`, `t_event_times`.`id_event` FROM `kzvalmez_dev_221024`.`kz_adv_events_times` AS t_event_times WHERE ( (event_date_begin BETWEEN :dateFrom AND :dateTo)  OR (event_date_end BETWEEN :dateFrom AND :dateTo)  OR (event_date_begin <= :dateFrom AND `t_event_times`.`event_date_end` IS NOT NULL  AND `t_event_times`.`event_date_end` >= :dateTo )  )
 GROUP BY `t_event_times`.`id_event`,`t_event_times`.`id_event_time`
) AS ttimes_min ON (`ttimes_min`.`id_event` = `t_event`.`id_event`)
 INNER JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event_time` = `ttimes_min`.`id_event_time`)
 LEFT JOIN kz_adv_events_has_places AS tplaces1 ON (`tplaces1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_has_tags AS ttags1 ON (`ttags1`.`events_id_event` = `t_event`.`id_event`)
 LEFT JOIN kz_adv_events_organizers AS AdvEventsBase_Model_Organizers_5 ON (`AdvEventsBase_Model_Organizers_5`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
 LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_6 ON (`AdvEventsBase_Model_Categories_6`.`id_ev_category` = `t_event`.`id_ev_category`)
 LEFT JOIN kz_adv_events_images AS iamges ON (`iamges`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
 WHERE (1 = 1 AND `t_event`.`id_event` NOT IN(:key_0,:key_1,:key_2,:key_3,:key_4) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND id_event_organizer IN (:22d3f6a3_arr_0) )
 GROUP BY `t_event`.`id_event`
 ORDER BY `ordered` ASC,`orderedTimes` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  11
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=1
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=1
Key: Name: [6] :key_3
paramno=-1
name=[6] ":key_3"
is_param=1
param_type=1
Key: Name: [6] :key_4
paramno=-1
name=[6] ":key_4"
is_param=1
param_type=1
Key: Name: [9] :dateFrom
paramno=-1
name=[9] ":dateFrom"
is_param=1
param_type=2
Key: Name: [7] :dateTo
paramno=-1
name=[7] ":dateTo"
is_param=1
param_type=2
Key: Name: [15] :22d3f6a3_arr_0
paramno=-1
name=[15] ":22d3f6a3_arr_0"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2

;

QUERY: 19, čas: 0.000136 s, počet: 1

SQL: [1007] SELECT  `t_cats`.`id_category`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`description_cs` , `t_cats`.`keywords_cs` , `t_cats`.`default_right`, `t_cats`.`id_owner_user`, `t_cats`.`feeds`, `t_cats`.`individual_panels`, `t_cats`.`module`, `t_cats`.`urlkey_cs` , `t_cats`.`visibility`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`priority`, `t_cats`.`disable_cs` , `t_cats`.`ser_params`, `t_cats`.`data_dir`, `t_cats`.`created`, `t_cats`.`changed`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
 LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
 WHERE (`t_cats`.`disable_cs` = 0 )

Params:  0

;

QUERY: 20, čas: 0.000122 s, počet: 1

SQL: [1752] SELECT  `t_panels`.`id_panel`, `t_panels`.`id_cat`, `t_panels`.`id_show_cat`, `t_panels`.`pname_cs` AS pname, `t_panels`.`porder`, `t_panels`.`position`, `t_panels`.`pparams`, `t_panels`.`icon` AS `picon`, `t_panels`.`background` AS `pbackground`, `t_panels`.`panel_force_global`, `t_panels`.`is_admin_cat`, `t_cat`.`id_category` AS `id_category`, `t_cat`.`id_owner_user` AS `id_owner_user`, `t_cat`.`label_cs` AS label, `t_cat`.`alt_cs` AS alt, `t_cat`.`urlkey_cs` AS urlkey, `t_cat`.`disable_cs` AS disable, `t_cat`.`module` AS `module`, `t_cat`.`data_dir` AS `data_dir`, `t_cat`.`individual_panels` AS `individual_panels`, `t_cat`.`visibility` AS `visibility`, `t_cat`.`ser_params` AS `ser_params`, `t_cat`.`priority` AS `priority`, `t_cat`.`default_right` AS `default_right`, `t_cat`.`active` AS `active`, `t_cat`.`keywords_cs` AS keywords, `t_cat`.`description_cs` AS description, `t_cat`.`changed` AS `changed`, `t_cat`.`created` AS `created`, `t_cat`.`feeds` AS `feeds`, `t_cat`.`icon` AS `icon`, `t_cat`.`background` AS `background`, `t_cat`.`sitemap_changefreq` AS `sitemap_changefreq`, `t_cat`.`sitemap_priority` AS `sitemap_priority`, `t_r`.`id_group`, `t_r`.`right` FROM `kzvalmez_dev_221024`.`kz_panels` AS t_panels LEFT JOIN kz_categories AS t_cat ON (`t_cat`.`id_category` = `t_panels`.`id_cat`)
 LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cat`.`id_category` AND t_r.id_group = '2')
 WHERE (  ( SUBSTRING(`right`, 1, 1) = 'r' OR  ( `right` IS NULL AND SUBSTRING(`default_right`, 1, 1) = 'r' ))   AND (id_show_cat = :idc OR `t_panels`.`panel_force_global` = 1 ) AND module IS NOT NULL  OR (is_admin_cat = 1 AND ( `t_panels`.`id_show_cat` = :idc2 OR `t_panels`.`panel_force_global` = 1 )) )
 ORDER BY `t_panels`.`porder` DESC

Params:  2
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1
Key: Name: [5] :idc2
paramno=-1
name=[5] ":idc2"
is_param=1
param_type=1

;

QUERY: 21, čas: 0.000114 s, počet: 1

SQL: [845] SELECT `t_cats`.`id_category`, `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_cats`.`urlkey_cs` , TRIM(LEADING urlkey_cs FROM :urlpartfull) AS `urlpart` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats WHERE (`t_cats`.`disable_cs` = 0 AND INSTR(:url, urlkey_cs) = 1 )
 ORDER BY LENGTH(`t_cats`.`urlkey_cs`) DESC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  4
Key: Name: [4] :url
paramno=-1
name=[4] ":url"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [12] :urlpartfull
paramno=-1
name=[12] ":urlpartfull"
is_param=1
param_type=2

;

QUERY: 22, čas: 0.000107 s, počet: 1

SQL: [176] SELECT  `t_mods`.`id_module`, `t_mods`.`name`, `t_mods`.`version`, `t_mods`.`version_major`, `t_mods`.`version_minor` FROM `kzvalmez_dev_221024`.`kz_modules_instaled` AS t_mods
Params:  0

;

QUERY: 23, čas: 0.000102 s, počet: 1

SQL: [1129] SELECT `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
 LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
 WHERE (`t_cats`.`id_category` = :id )
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  3
Key: Name: [3] :id
paramno=-1
name=[3] ":id"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1

;

QUERY: 24, čas: 0.000100 s, počet: 1

SQL: [336] SELECT  `t_texts`.`id_text`, `t_texts`.`id_user`, `t_texts`.`id_item`, `t_texts`.`subkey`, `t_texts`.`text_cs` , `t_texts`.`text_clear_cs` , `t_texts`.`label_cs` , `t_texts`.`changed`, `t_texts`.`data` FROM `kzvalmez_dev_221024`.`kz_texts` AS t_texts WHERE (`t_texts`.`id_item` = :idc AND `t_texts`.`subkey` IN (:key_0,:key_1,:key_2) )

Params:  4
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=2
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=2
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=2
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1

;

QUERY: 25, čas: 0.000100 s, počet: 1

SQL: [201] SELECT `key`, `value` FROM `kz_config`
         UNION ALL
         SELECT `key`, `value` FROM `cubecms_global_config`
         WHERE `key` NOT IN (SELECT `key` FROM `kz_config`)
         ORDER BY `key`
Params:  0

;

QUERY: 26, čas: 0.000097 s, počet: 2

SQL: [784] SELECT  `t_advevent_places`.`id_ev_place`, `t_advevent_places`.`id_place_location`, `t_advevent_places`.`place_name`, `t_advevent_places`.`place_description`, `t_advevent_places`.`place_address`, `t_advevent_places`.`place_map_url`, `t_advevent_places`.`place_url`, `t_advevent_places`.`place_external_id`, `t_advevent_places`.`place_opening_hours`, `t_advevent_places`.`place_lat`, `t_advevent_places`.`place_lng`, `t_advevent_places`.`place_data` FROM `kzvalmez_dev_221024`.`kz_adv_events_places` AS t_advevent_places LEFT JOIN kz_adv_events_has_places AS AdvEventsBase_Model_PLacesConnection_0 ON (`AdvEventsBase_Model_PLacesConnection_0`.`events_places_id_place` = `t_advevent_places`.`id_ev_place`)
 WHERE (events_id_event = :ide )
 ORDER BY `t_advevent_places`.`place_name` ASC

Params:  1
Key: Name: [4] :ide
paramno=-1
name=[4] ":ide"
is_param=1
param_type=2

;

QUERY: 27, čas: 0.000094 s, počet: 1

SQL: [343] SELECT  `t_texts`.`id_text`, `t_texts`.`id_user`, `t_texts`.`id_item`, `t_texts`.`subkey`, `t_texts`.`text_cs` , `t_texts`.`text_clear_cs` , `t_texts`.`label_cs` , `t_texts`.`changed`, `t_texts`.`data` FROM `kzvalmez_dev_221024`.`kz_texts` AS t_texts WHERE (`t_texts`.`id_item` = :idc AND `t_texts`.`subkey` IN (:key_0,:key_1,:key_2,:key_3) )

Params:  5
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=2
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=2
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=2
Key: Name: [6] :key_3
paramno=-1
name=[6] ":key_3"
is_param=1
param_type=2
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1

;

QUERY: 28, čas: 0.000093 s, počet: 1

SQL: [258] SELECT  `t_kzmp`.`id_kz_mainpage`, `t_kzmp`.`item_source`, `t_kzmp`.`item_source_type`, `t_kzmp`.`item_source_id`, `t_kzmp`.`item_source_item_id`, `t_kzmp`.`item_order` FROM `kzvalmez_dev_221024`.`kz_kz_mainpage` AS t_kzmp ORDER BY `t_kzmp`.`item_order` ASC

Params:  0

;

QUERY: 29, čas: 0.000092 s, počet: 1

SQL: [192] SELECT  `t_uss`.`id_user_setting`, `t_uss`.`id_user`, `t_uss`.`setting_name`, `t_uss`.`setting_value` FROM `kzvalmez_dev_221024`.`kz_users_settings` AS t_uss WHERE (`t_uss`.`id_user` = :idu )

Params:  1
Key: Name: [4] :idu
paramno=-1
name=[4] ":idu"
is_param=1
param_type=1

;

QUERY: 30, čas: 0.000085 s, počet: 1

SQL: [1809] SELECT  `t_cm_items`.`id_custom_menu_item`, `t_cm_items`.`id_category`, `t_cm_items`.`menu_item_box`, `t_cm_items`.`menu_item_name_cs` , `t_cm_items`.`menu_item_link`, `t_cm_items`.`menu_item_new_window`, `t_cm_items`.`menu_item_active`, `t_cm_items`.`is_tpl_menu`, `t_cm_items`.`menu_item_order`, `t_cm_items`.`id_lft`, `t_cm_items`.`id_rgt`, `t_cm_items`.`level`, `Model_Category_1`.`id_owner_user` AS `id_owner_user`, `Model_Category_1`.`label_cs` AS label_cs, `Model_Category_1`.`alt_cs` AS alt_cs, `Model_Category_1`.`urlkey_cs` AS urlkey_cs, `Model_Category_1`.`disable_cs` AS disable_cs, `Model_Category_1`.`module` AS `module`, `Model_Category_1`.`data_dir` AS `data_dir`, `Model_Category_1`.`individual_panels` AS `individual_panels`, `Model_Category_1`.`visibility` AS `visibility`, `Model_Category_1`.`ser_params` AS `ser_params`, `Model_Category_1`.`priority` AS `priority`, `Model_Category_1`.`default_right` AS `default_right`, `Model_Category_1`.`active` AS `active`, `Model_Category_1`.`keywords_cs` AS keywords_cs, `Model_Category_1`.`description_cs` AS description_cs, `Model_Category_1`.`changed` AS `changed`, `Model_Category_1`.`created` AS `created`, `Model_Category_1`.`feeds` AS `feeds`, `Model_Category_1`.`icon` AS `icon`, `Model_Category_1`.`background` AS `background`, `Model_Category_1`.`sitemap_changefreq` AS `sitemap_changefreq`, `Model_Category_1`.`sitemap_priority` AS `sitemap_priority` FROM `kzvalmez_dev_221024`.`kz_custom_menu_items` AS t_cm_items LEFT JOIN kz_categories AS Model_Category_1 ON (`Model_Category_1`.`id_category` = `t_cm_items`.`id_category`)
 WHERE (`t_cm_items`.`menu_item_box` = :box AND `t_cm_items`.`menu_item_active` = 1 AND `t_cm_items`.`id_lft` != 1  AND ( disable_cs = 0 OR `t_cm_items`.`id_category` = 0 ) )
 ORDER BY `t_cm_items`.`id_lft` ASC

Params:  1
Key: Name: [4] :box
paramno=-1
name=[4] ":box"
is_param=1
param_type=2

;

QUERY: 31, čas: 0.000070 s, počet: 1

SQL: [1131] SELECT `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
 LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
 WHERE (`t_cats`.`urlkey_cs` = :urlkey )
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  3
Key: Name: [7] :urlkey
paramno=-1
name=[7] ":urlkey"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1

;

QUERY: 32, čas: 0.000070 s, počet: 1

SQL: [1751] SELECT `t_cm_items`.`id_custom_menu_item`, `t_cm_items`.`id_category`, `t_cm_items`.`menu_item_box`, `t_cm_items`.`menu_item_name_cs` , `t_cm_items`.`menu_item_link`, `t_cm_items`.`menu_item_new_window`, `t_cm_items`.`menu_item_active`, `t_cm_items`.`is_tpl_menu`, `t_cm_items`.`menu_item_order`, `t_cm_items`.`id_lft`, `t_cm_items`.`id_rgt`, `t_cm_items`.`level`, `Model_Category_1`.`id_owner_user` AS `id_owner_user`, `Model_Category_1`.`label_cs` AS label_cs, `Model_Category_1`.`alt_cs` AS alt_cs, `Model_Category_1`.`urlkey_cs` AS urlkey_cs, `Model_Category_1`.`disable_cs` AS disable_cs, `Model_Category_1`.`module` AS `module`, `Model_Category_1`.`data_dir` AS `data_dir`, `Model_Category_1`.`individual_panels` AS `individual_panels`, `Model_Category_1`.`visibility` AS `visibility`, `Model_Category_1`.`ser_params` AS `ser_params`, `Model_Category_1`.`priority` AS `priority`, `Model_Category_1`.`default_right` AS `default_right`, `Model_Category_1`.`active` AS `active`, `Model_Category_1`.`keywords_cs` AS keywords_cs, `Model_Category_1`.`description_cs` AS description_cs, `Model_Category_1`.`changed` AS `changed`, `Model_Category_1`.`created` AS `created`, `Model_Category_1`.`feeds` AS `feeds`, `Model_Category_1`.`icon` AS `icon`, `Model_Category_1`.`background` AS `background`, `Model_Category_1`.`sitemap_changefreq` AS `sitemap_changefreq`, `Model_Category_1`.`sitemap_priority` AS `sitemap_priority` FROM `kzvalmez_dev_221024`.`kz_custom_menu_items` AS t_cm_items LEFT JOIN kz_categories AS Model_Category_1 ON (`Model_Category_1`.`id_category` = `t_cm_items`.`id_category`)
 WHERE (`t_cm_items`.`menu_item_box` = :box  AND `t_cm_items`.`id_lft` = 1 )
 ORDER BY `t_cm_items`.`id_lft` ASC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  3
Key: Name: [4] :box
paramno=-1
name=[4] ":box"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1

;

QUERY: 33, čas: 0.000066 s, počet: 1

SQL: [346] SELECT `t_jounals`.`id_journal`, `t_jounals`.`journal_number`, `t_jounals`.`journal_year`, `t_jounals`.`journal_viewed`, `t_jounals`.`journal_text`, `t_jounals`.`journal_file` FROM `kzvalmez_dev_221024`.`kz_journals` AS t_jounals ORDER BY `t_jounals`.`journal_year` DESC,`t_jounals`.`journal_number` DESC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1

;

QUERY: 34, čas: 0.000063 s, počet: 1

SQL: [1168] SELECT `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
 LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
 WHERE (`t_cats`.`urlkey_cs` IS NOT NULL )
 ORDER BY `t_cats`.`priority` DESC
 LIMIT :cube_cms_fromrow, :cube_cms_rows

Params:  2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1

;

Runtime VARS:

SCSS

Compiling: /var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/style.scss (456d45b95dbcf99ea27f8c05f90bd2f2-559410c378b140d6269f6896858a4dd9-_var_www_webdev_kzvalmez_dev_faces_kzvalmez_stylesheets_style.scss.css)

/var/www/webdev/kzvalmez/dev/templates/parts/debug.phtml:8:
array (size=168)
  0 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_variables.scss' (length=71)
  1 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_mixins.scss' (length=68)
  2 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_functions.scss' (length=71)
  3 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_site_variables.scss' (length=76)
  4 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_animations.scss' (length=72)
  5 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_base.scss' (length=59)
  6 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_variables.scss' (length=64)
  7 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_functions.scss' (length=66)
  8 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_variables.scss' (length=66)
  9 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/bootstrap.scss' (length=65)
  10 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_mixins.scss' (length=63)
  11 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/vendor/_rfs.scss' (length=67)
  12 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_deprecate.scss' (length=73)
  13 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_breakpoints.scss' (length=75)
  14 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_hover.scss' (length=69)
  15 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_image.scss' (length=69)
  16 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_badge.scss' (length=69)
  17 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_resize.scss' (length=70)
  18 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_screen-reader.scss' (length=77)
  19 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_size.scss' (length=68)
  20 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_reset-text.scss' (length=74)
  21 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_text-emphasis.scss' (length=77)
  22 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_text-hide.scss' (length=73)
  23 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_text-truncate.scss' (length=77)
  24 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_visibility.scss' (length=74)
  25 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_alert.scss' (length=69)
  26 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_buttons.scss' (length=71)
  27 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_caret.scss' (length=69)
  28 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_pagination.scss' (length=74)
  29 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_lists.scss' (length=69)
  30 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_list-group.scss' (length=74)
  31 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_nav-divider.scss' (length=75)
  32 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_forms.scss' (length=69)
  33 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_table-row.scss' (length=73)
  34 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_background-variant.scss' (length=82)
  35 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_border-radius.scss' (length=77)
  36 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_box-shadow.scss' (length=74)
  37 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_gradients.scss' (length=73)
  38 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_transition.scss' (length=74)
  39 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_clearfix.scss' (length=72)
  40 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_grid-framework.scss' (length=78)
  41 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_grid.scss' (length=68)
  42 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/mixins/_float.scss' (length=69)
  43 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_root.scss' (length=61)
  44 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_reboot.scss' (length=63)
  45 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_type.scss' (length=61)
  46 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_images.scss' (length=63)
  47 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_code.scss' (length=61)
  48 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_grid.scss' (length=61)
  49 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_tables.scss' (length=63)
  50 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_forms.scss' (length=62)
  51 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_buttons.scss' (length=64)
  52 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_transitions.scss' (length=68)
  53 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_dropdown.scss' (length=65)
  54 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_button-group.scss' (length=69)
  55 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_input-group.scss' (length=68)
  56 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_custom-forms.scss' (length=69)
  57 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_nav.scss' (length=60)
  58 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_navbar.scss' (length=63)
  59 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_card.scss' (length=61)
  60 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_breadcrumb.scss' (length=67)
  61 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_pagination.scss' (length=67)
  62 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_badge.scss' (length=62)
  63 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_jumbotron.scss' (length=66)
  64 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_alert.scss' (length=62)
  65 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_progress.scss' (length=65)
  66 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_media.scss' (length=62)
  67 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_list-group.scss' (length=67)
  68 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_close.scss' (length=62)
  69 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_toasts.scss' (length=63)
  70 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_modal.scss' (length=62)
  71 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_tooltip.scss' (length=64)
  72 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_popover.scss' (length=64)
  73 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_carousel.scss' (length=65)
  74 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_spinners.scss' (length=65)
  75 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_utilities.scss' (length=66)
  76 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_align.scss' (length=72)
  77 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_background.scss' (length=77)
  78 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_borders.scss' (length=74)
  79 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_clearfix.scss' (length=75)
  80 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_display.scss' (length=74)
  81 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_embed.scss' (length=72)
  82 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_flex.scss' (length=71)
  83 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_float.scss' (length=72)
  84 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_overflow.scss' (length=75)
  85 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_position.scss' (length=75)
  86 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_screenreaders.scss' (length=80)
  87 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_shadows.scss' (length=74)
  88 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_sizing.scss' (length=73)
  89 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_stretched-link.scss' (length=81)
  90 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_spacing.scss' (length=74)
  91 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_text.scss' (length=71)
  92 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/utilities/_visibility.scss' (length=77)
  93 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_print.scss' (length=62)
  94 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/fontawesome.scss' (length=69)
  95 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_variables.scss' (length=68)
  96 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_mixins.scss' (length=65)
  97 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_core.scss' (length=63)
  98 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_larger.scss' (length=65)
  99 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_fixed-width.scss' (length=70)
  100 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_list.scss' (length=63)
  101 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_bordered-pulled.scss' (length=74)
  102 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_animated.scss' (length=67)
  103 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_rotated-flipped.scss' (length=74)
  104 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_stacked.scss' (length=66)
  105 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_icons.scss' (length=64)
  106 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/_screen-reader.scss' (length=72)
  107 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/solid.scss' (length=63)
  108 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/brands.scss' (length=64)
  109 => string '/var/www/webdev/kzvalmez/dev/stylesheets/fontawesome/regular.scss' (length=65)
  110 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_utils.scss' (length=60)
  111 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_cookieinfo.scss' (length=65)
  112 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_forms.scss' (length=60)
  113 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_jstree.scss' (length=61)
  114 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_mce.scss' (length=58)
  115 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_tabs.scss' (length=59)
  116 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_tables.scss' (length=61)
  117 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_navs.scss' (length=59)
  118 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_modal.scss' (length=60)
  119 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_widgets.scss' (length=62)
  120 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_toolbox.scss' (length=62)
  121 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_card.scss' (length=59)
  122 => string '/var/www/webdev/kzvalmez/dev/stylesheets/datetimepicker/_bootstrap-datetimepicker.scss' (length=86)
  123 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_help-box.scss' (length=63)
  124 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_datatables.scss' (length=65)
  125 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_layout.scss' (length=68)
  126 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_theme.scss' (length=67)
  127 => string '/var/www/webdev/kzvalmez/dev/faces/kzvalmez/stylesheets/_menu.scss' (length=66)
  more elements...

Compiling: /var/www/webdev/kzvalmez/dev/stylesheets/cubecms/debug.scss (22d3706e4ca948cf4b34363ceb129784-559410c378b140d6269f6896858a4dd9-_var_www_webdev_kzvalmez_dev_stylesheets_cubecms_debug.scss.css)

/var/www/webdev/kzvalmez/dev/templates/parts/debug.phtml:8:
array (size=3)
  0 => string '/var/www/webdev/kzvalmez/dev/stylesheets/cubecms/_variables.scss' (length=64)
  1 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_functions.scss' (length=66)
  2 => string '/var/www/webdev/kzvalmez/dev/stylesheets/bootstrap/_variables.scss' (length=66)

Enviroment:

$_GET

/var/www/webdev/kzvalmez/dev/templates/parts/debug.phtml:157:
array (size=0)
  empty

$_POST

/var/www/webdev/kzvalmez/dev/templates/parts/debug.phtml:161:
array (size=0)
  empty

$_SESSION

/var/www/webdev/kzvalmez/dev/templates/parts/debug.phtml:165:
array (size=2)
  '_expire' => int 1746041141
  'lang' => string 'cs' (length=2)

$_SERVER

/var/www/webdev/kzvalmez/dev/templates/parts/debug.phtml:169:
array (size=36)
  'USER' => string 'webdev' (length=6)
  'HOME' => string '/home/webdev' (length=12)
  'SCRIPT_NAME' => string '/index.php' (length=10)
  'REQUEST_URI' => string '/domu/' (length=6)
  'QUERY_STRING' => string '' (length=0)
  'REQUEST_METHOD' => string 'GET' (length=3)
  'SERVER_PROTOCOL' => string 'HTTP/1.1' (length=8)
  'GATEWAY_INTERFACE' => string 'CGI/1.1' (length=7)
  'REDIRECT_URL' => string '/domu/' (length=6)
  'REMOTE_PORT' => string '35800' (length=5)
  'SCRIPT_FILENAME' => string '/var/www/webdev/kzvalmez/dev/index.php' (length=38)
  'SERVER_ADMIN' => string '[no address given]' (length=18)
  'CONTEXT_DOCUMENT_ROOT' => string '/var/www/webdev/kzvalmez/dev/' (length=29)
  'CONTEXT_PREFIX' => string '' (length=0)
  'REQUEST_SCHEME' => string 'http' (length=4)
  'DOCUMENT_ROOT' => string '/var/www/webdev/kzvalmez/dev/' (length=29)
  'REMOTE_ADDR' => string '18.97.14.86' (length=11)
  'SERVER_PORT' => string '80' (length=2)
  'SERVER_ADDR' => string '192.168.11.10' (length=13)
  'SERVER_NAME' => string 'kzvalmez.dev.cube-studio.cz' (length=27)
  'SERVER_SOFTWARE' => string 'Apache/2.4.63 (Ubuntu)' (length=22)
  'SERVER_SIGNATURE' => string '<address>Apache/2.4.63 (Ubuntu) Server at kzvalmez.dev.cube-studio.cz Port 80</address>
' (length=88)
  'PATH' => string '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin' (length=59)
  'HTTP_CONNECTION' => string 'Keep-Alive' (length=10)
  'HTTP_HOST' => string 'kzvalmez.dev.cube-studio.cz' (length=27)
  'HTTP_ACCEPT_ENCODING' => string 'br,gzip' (length=7)
  'HTTP_IF_MODIFIED_SINCE' => string 'Sun, 13 Oct 2024 21:58:25 GMT' (length=29)
  'HTTP_ACCEPT_LANGUAGE' => string 'en-US,en;q=0.5' (length=14)
  'HTTP_ACCEPT' => string 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' (length=63)
  'HTTP_USER_AGENT' => string 'CCBot/2.0 (https://commoncrawl.org/faq/)' (length=40)
  'proxy-nokeepalive' => string '1' (length=1)
  'REDIRECT_STATUS' => string '200' (length=3)
  'FCGI_ROLE' => string 'RESPONDER' (length=9)
  'PHP_SELF' => string '/index.php' (length=10)
  'REQUEST_TIME_FLOAT' => float 1746039341,2013
  'REQUEST_TIME' => int 1746039341

$_ENV

/var/www/webdev/kzvalmez/dev/templates/parts/debug.phtml:173:
array (size=0)
  empty

Vítejte v MEZOPOTÁMII

Jiřina Marešová (varhany) Jan Verner (trubka, křídlovka)

MADE IN VALMEZ

Pavel Lasztovicza: Poslední Žerotínové a jejich svět

Barbora Mikudová

Zbyněk Sedlecký

Velký finále PSO

The Surfer

Tel:	571 684 558, 775 109 809
Fax:	571 684 684
E-mail:	info@info-vm.cz

Po–pá	9.00–17.00
So	9.00–13.00