QUERY: 1, čas: 0.003237 s, počet: 1
SQL: [6077] 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, 100, (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_4`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_4`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_5`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_5`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_5`.`ev_category_data` AS `ev_category_data`, `eimages`.`event_image_file` AS `title_image`, `eimages`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event RIGHT JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event` = `t_event`.`id_event`)
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_4 ON (`AdvEventsBase_Model_Organizers_4`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_5 ON (`AdvEventsBase_Model_Categories_5`.`id_ev_category` = `t_event`.`id_ev_category`)
LEFT JOIN kz_adv_events_images AS eimages ON (`eimages`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
WHERE (( (`ttimes1`.`event_date_begin`>= :dateFrom AND (`ttimes1`.`event_date_begin`<= :dateTo OR `ttimes1`.`event_date_begin` IS NULL)) OR (`ttimes1`.`event_date_begin` BETWEEN :dateFrom AND :dateTo) OR (`ttimes1`.`event_date_end` BETWEEN :dateFrom AND :dateTo) OR ( `ttimes1`.`event_date_begin`<= :dateFrom AND `ttimes1`.`event_date_end` IS NOT NULL AND `ttimes1`.`event_date_end` >= :dateTo ) ) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND ( id_event_organizer IN (:1921cf6d_arr_0,:1921cf6d_arr_1,:1921cf6d_arr_2) OR events_places_id_place IN (:1921cf75_arr_0,:1921cf75_arr_1,:1921cf75_arr_2) ) AND `t_event`.`id_ev_category` IN (:1921cf7d_arr_0,:1921cf7d_arr_1,:1921cf7d_arr_2,:1921cf7d_arr_3,:1921cf7d_arr_4,:1921cf7d_arr_5,:1921cf7d_arr_6,:1921cf7d_arr_7,:1921cf7d_arr_8,:1921cf7d_arr_9,:1921cf7d_arr_10,:1921cf7d_arr_11,:1921cf7d_arr_12,:1921cf7d_arr_13,:1921cf7d_arr_14,:1921cf7d_arr_15,:1921cf7d_arr_16,:1921cf7d_arr_17,:1921cf7d_arr_18,:1921cf7d_arr_19,:1921cf7d_arr_20,:1921cf7d_arr_21,:1921cf7d_arr_22,:1921cf7d_arr_23,:1921cf7d_arr_24,:1921cf7d_arr_25,:1921cf7d_arr_26,:1921cf7d_arr_27,:1921cf7d_arr_28,:1921cf7d_arr_29,:1921cf7d_arr_30,:1921cf7d_arr_31) )
GROUP BY `id_event_time`
ORDER BY `ordered` ASC,`orderedTimes` ASC
Params: 41
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] :1921cf6d_arr_0
paramno=-1
name=[15] ":1921cf6d_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921cf6d_arr_1
paramno=-1
name=[15] ":1921cf6d_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921cf6d_arr_2
paramno=-1
name=[15] ":1921cf6d_arr_2"
is_param=1
param_type=1
Key: Name: [15] :1921cf75_arr_0
paramno=-1
name=[15] ":1921cf75_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921cf75_arr_1
paramno=-1
name=[15] ":1921cf75_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921cf75_arr_2
paramno=-1
name=[15] ":1921cf75_arr_2"
is_param=1
param_type=1
Key: Name: [15] :1921cf7d_arr_0
paramno=-1
name=[15] ":1921cf7d_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_1
paramno=-1
name=[15] ":1921cf7d_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_2
paramno=-1
name=[15] ":1921cf7d_arr_2"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_3
paramno=-1
name=[15] ":1921cf7d_arr_3"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_4
paramno=-1
name=[15] ":1921cf7d_arr_4"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_5
paramno=-1
name=[15] ":1921cf7d_arr_5"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_6
paramno=-1
name=[15] ":1921cf7d_arr_6"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_7
paramno=-1
name=[15] ":1921cf7d_arr_7"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_8
paramno=-1
name=[15] ":1921cf7d_arr_8"
is_param=1
param_type=2
Key: Name: [15] :1921cf7d_arr_9
paramno=-1
name=[15] ":1921cf7d_arr_9"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_10
paramno=-1
name=[16] ":1921cf7d_arr_10"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_11
paramno=-1
name=[16] ":1921cf7d_arr_11"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_12
paramno=-1
name=[16] ":1921cf7d_arr_12"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_13
paramno=-1
name=[16] ":1921cf7d_arr_13"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_14
paramno=-1
name=[16] ":1921cf7d_arr_14"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_15
paramno=-1
name=[16] ":1921cf7d_arr_15"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_16
paramno=-1
name=[16] ":1921cf7d_arr_16"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_17
paramno=-1
name=[16] ":1921cf7d_arr_17"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_18
paramno=-1
name=[16] ":1921cf7d_arr_18"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_19
paramno=-1
name=[16] ":1921cf7d_arr_19"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_20
paramno=-1
name=[16] ":1921cf7d_arr_20"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_21
paramno=-1
name=[16] ":1921cf7d_arr_21"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_22
paramno=-1
name=[16] ":1921cf7d_arr_22"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_23
paramno=-1
name=[16] ":1921cf7d_arr_23"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_24
paramno=-1
name=[16] ":1921cf7d_arr_24"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_25
paramno=-1
name=[16] ":1921cf7d_arr_25"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_26
paramno=-1
name=[16] ":1921cf7d_arr_26"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_27
paramno=-1
name=[16] ":1921cf7d_arr_27"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_28
paramno=-1
name=[16] ":1921cf7d_arr_28"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_29
paramno=-1
name=[16] ":1921cf7d_arr_29"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_30
paramno=-1
name=[16] ":1921cf7d_arr_30"
is_param=1
param_type=2
Key: Name: [16] :1921cf7d_arr_31
paramno=-1
name=[16] ":1921cf7d_arr_31"
is_param=1
param_type=2
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2
;
QUERY: 2, čas: 0.002935 s, počet: 1
SQL: [6117] 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, 100, (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_4`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_4`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_5`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_5`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_5`.`ev_category_data` AS `ev_category_data`, `eimages`.`event_image_file` AS `title_image`, `eimages`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event RIGHT JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event` = `t_event`.`id_event`)
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_4 ON (`AdvEventsBase_Model_Organizers_4`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_5 ON (`AdvEventsBase_Model_Categories_5`.`id_ev_category` = `t_event`.`id_ev_category`)
LEFT JOIN kz_adv_events_images AS eimages ON (`eimages`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
WHERE (( (`ttimes1`.`event_date_begin`>= :dateFrom AND (`ttimes1`.`event_date_begin`<= :dateTo OR `ttimes1`.`event_date_begin` IS NULL)) OR (`ttimes1`.`event_date_begin` BETWEEN :dateFrom AND :dateTo) OR (`ttimes1`.`event_date_end` BETWEEN :dateFrom AND :dateTo) OR ( `ttimes1`.`event_date_begin`<= :dateFrom AND `ttimes1`.`event_date_end` IS NOT NULL AND `ttimes1`.`event_date_end` >= :dateTo ) ) 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 (:1921efdb_arr_0,:1921efdb_arr_1,:1921efdb_arr_2) OR events_places_id_place IN (:1921efe6_arr_0,:1921efe6_arr_1,:1921efe6_arr_2) ) AND `t_event`.`id_ev_category` IN (:1921efef_arr_0,:1921efef_arr_1,:1921efef_arr_2,:1921efef_arr_3,:1921efef_arr_4,:1921efef_arr_5,:1921efef_arr_6,:1921efef_arr_7,:1921efef_arr_8,:1921efef_arr_9,:1921efef_arr_10,:1921efef_arr_11,:1921efef_arr_12,:1921efef_arr_13,:1921efef_arr_14,:1921efef_arr_15,:1921efef_arr_16,:1921efef_arr_17,:1921efef_arr_18,:1921efef_arr_19,:1921efef_arr_20,:1921efef_arr_21,:1921efef_arr_22,:1921efef_arr_23,:1921efef_arr_24,:1921efef_arr_25,:1921efef_arr_26,:1921efef_arr_27,:1921efef_arr_28,:1921efef_arr_29,:1921efef_arr_30,:1921efef_arr_31) )
GROUP BY `id_event_time`
ORDER BY `ordered` ASC,`orderedTimes` ASC
Params: 42
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=2
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] :1921efdb_arr_0
paramno=-1
name=[15] ":1921efdb_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921efdb_arr_1
paramno=-1
name=[15] ":1921efdb_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921efdb_arr_2
paramno=-1
name=[15] ":1921efdb_arr_2"
is_param=1
param_type=1
Key: Name: [15] :1921efe6_arr_0
paramno=-1
name=[15] ":1921efe6_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921efe6_arr_1
paramno=-1
name=[15] ":1921efe6_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921efe6_arr_2
paramno=-1
name=[15] ":1921efe6_arr_2"
is_param=1
param_type=1
Key: Name: [15] :1921efef_arr_0
paramno=-1
name=[15] ":1921efef_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_1
paramno=-1
name=[15] ":1921efef_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_2
paramno=-1
name=[15] ":1921efef_arr_2"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_3
paramno=-1
name=[15] ":1921efef_arr_3"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_4
paramno=-1
name=[15] ":1921efef_arr_4"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_5
paramno=-1
name=[15] ":1921efef_arr_5"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_6
paramno=-1
name=[15] ":1921efef_arr_6"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_7
paramno=-1
name=[15] ":1921efef_arr_7"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_8
paramno=-1
name=[15] ":1921efef_arr_8"
is_param=1
param_type=2
Key: Name: [15] :1921efef_arr_9
paramno=-1
name=[15] ":1921efef_arr_9"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_10
paramno=-1
name=[16] ":1921efef_arr_10"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_11
paramno=-1
name=[16] ":1921efef_arr_11"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_12
paramno=-1
name=[16] ":1921efef_arr_12"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_13
paramno=-1
name=[16] ":1921efef_arr_13"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_14
paramno=-1
name=[16] ":1921efef_arr_14"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_15
paramno=-1
name=[16] ":1921efef_arr_15"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_16
paramno=-1
name=[16] ":1921efef_arr_16"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_17
paramno=-1
name=[16] ":1921efef_arr_17"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_18
paramno=-1
name=[16] ":1921efef_arr_18"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_19
paramno=-1
name=[16] ":1921efef_arr_19"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_20
paramno=-1
name=[16] ":1921efef_arr_20"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_21
paramno=-1
name=[16] ":1921efef_arr_21"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_22
paramno=-1
name=[16] ":1921efef_arr_22"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_23
paramno=-1
name=[16] ":1921efef_arr_23"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_24
paramno=-1
name=[16] ":1921efef_arr_24"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_25
paramno=-1
name=[16] ":1921efef_arr_25"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_26
paramno=-1
name=[16] ":1921efef_arr_26"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_27
paramno=-1
name=[16] ":1921efef_arr_27"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_28
paramno=-1
name=[16] ":1921efef_arr_28"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_29
paramno=-1
name=[16] ":1921efef_arr_29"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_30
paramno=-1
name=[16] ":1921efef_arr_30"
is_param=1
param_type=2
Key: Name: [16] :1921efef_arr_31
paramno=-1
name=[16] ":1921efef_arr_31"
is_param=1
param_type=2
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2
;
QUERY: 3, čas: 0.002637 s, počet: 1
SQL: [6077] 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, 100, (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_4`.`id_event_organizer` AS `id_event_organizer`, `AdvEventsBase_Model_Organizers_4`.`id_group` AS `id_group`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_priority` AS `event_organizer_priority`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_name` AS `event_organizer_name`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_address` AS `event_organizer_address`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_note` AS `event_organizer_note`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_url` AS `event_organizer_url`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_fcb` AS `event_organizer_fcb`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_twitter` AS `event_organizer_twitter`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_youtube` AS `event_organizer_youtube`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_phone` AS `event_organizer_phone`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_email` AS `event_organizer_email`, `AdvEventsBase_Model_Organizers_4`.`event_organizer_data` AS `event_organizer_data`, `AdvEventsBase_Model_Categories_5`.`ev_category_name` AS `ev_category_name`, `AdvEventsBase_Model_Categories_5`.`ev_category_desc` AS `ev_category_desc`, `AdvEventsBase_Model_Categories_5`.`ev_category_data` AS `ev_category_data`, `eimages`.`event_image_file` AS `title_image`, `eimages`.`event_image_name` AS `title_image_name` FROM `kzvalmez_dev_221024`.`kz_adv_events` AS t_event RIGHT JOIN kz_adv_events_times AS ttimes1 ON (`ttimes1`.`id_event` = `t_event`.`id_event`)
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_4 ON (`AdvEventsBase_Model_Organizers_4`.`id_event_organizer` = `t_event`.`id_ev_organizer`)
LEFT JOIN kz_adv_events_categories AS AdvEventsBase_Model_Categories_5 ON (`AdvEventsBase_Model_Categories_5`.`id_ev_category` = `t_event`.`id_ev_category`)
LEFT JOIN kz_adv_events_images AS eimages ON (`eimages`.`id_event` = `t_event`.`id_event` AND event_image_is_title = 1)
WHERE (( (`ttimes1`.`event_date_begin`>= :dateFrom AND (`ttimes1`.`event_date_begin`<= :dateTo OR `ttimes1`.`event_date_begin` IS NULL)) OR (`ttimes1`.`event_date_begin` BETWEEN :dateFrom AND :dateTo) OR (`ttimes1`.`event_date_end` BETWEEN :dateFrom AND :dateTo) OR ( `ttimes1`.`event_date_begin`<= :dateFrom AND `ttimes1`.`event_date_end` IS NOT NULL AND `ttimes1`.`event_date_end` >= :dateTo ) ) AND `t_event`.`event_active` = 1 AND `t_event`.`event_approved` = 1 AND ( id_event_organizer IN (:1921e05c_arr_0,:1921e05c_arr_1,:1921e05c_arr_2) OR events_places_id_place IN (:1921e068_arr_0,:1921e068_arr_1,:1921e068_arr_2) ) AND `t_event`.`id_ev_category` IN (:1921e072_arr_0,:1921e072_arr_1,:1921e072_arr_2,:1921e072_arr_3,:1921e072_arr_4,:1921e072_arr_5,:1921e072_arr_6,:1921e072_arr_7,:1921e072_arr_8,:1921e072_arr_9,:1921e072_arr_10,:1921e072_arr_11,:1921e072_arr_12,:1921e072_arr_13,:1921e072_arr_14,:1921e072_arr_15,:1921e072_arr_16,:1921e072_arr_17,:1921e072_arr_18,:1921e072_arr_19,:1921e072_arr_20,:1921e072_arr_21,:1921e072_arr_22,:1921e072_arr_23,:1921e072_arr_24,:1921e072_arr_25,:1921e072_arr_26,:1921e072_arr_27,:1921e072_arr_28,:1921e072_arr_29,:1921e072_arr_30,:1921e072_arr_31) )
GROUP BY `id_event_time`
ORDER BY `ordered` ASC,`orderedTimes` ASC
Params: 41
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] :1921e05c_arr_0
paramno=-1
name=[15] ":1921e05c_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921e05c_arr_1
paramno=-1
name=[15] ":1921e05c_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921e05c_arr_2
paramno=-1
name=[15] ":1921e05c_arr_2"
is_param=1
param_type=1
Key: Name: [15] :1921e068_arr_0
paramno=-1
name=[15] ":1921e068_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921e068_arr_1
paramno=-1
name=[15] ":1921e068_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921e068_arr_2
paramno=-1
name=[15] ":1921e068_arr_2"
is_param=1
param_type=1
Key: Name: [15] :1921e072_arr_0
paramno=-1
name=[15] ":1921e072_arr_0"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_1
paramno=-1
name=[15] ":1921e072_arr_1"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_2
paramno=-1
name=[15] ":1921e072_arr_2"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_3
paramno=-1
name=[15] ":1921e072_arr_3"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_4
paramno=-1
name=[15] ":1921e072_arr_4"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_5
paramno=-1
name=[15] ":1921e072_arr_5"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_6
paramno=-1
name=[15] ":1921e072_arr_6"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_7
paramno=-1
name=[15] ":1921e072_arr_7"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_8
paramno=-1
name=[15] ":1921e072_arr_8"
is_param=1
param_type=2
Key: Name: [15] :1921e072_arr_9
paramno=-1
name=[15] ":1921e072_arr_9"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_10
paramno=-1
name=[16] ":1921e072_arr_10"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_11
paramno=-1
name=[16] ":1921e072_arr_11"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_12
paramno=-1
name=[16] ":1921e072_arr_12"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_13
paramno=-1
name=[16] ":1921e072_arr_13"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_14
paramno=-1
name=[16] ":1921e072_arr_14"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_15
paramno=-1
name=[16] ":1921e072_arr_15"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_16
paramno=-1
name=[16] ":1921e072_arr_16"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_17
paramno=-1
name=[16] ":1921e072_arr_17"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_18
paramno=-1
name=[16] ":1921e072_arr_18"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_19
paramno=-1
name=[16] ":1921e072_arr_19"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_20
paramno=-1
name=[16] ":1921e072_arr_20"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_21
paramno=-1
name=[16] ":1921e072_arr_21"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_22
paramno=-1
name=[16] ":1921e072_arr_22"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_23
paramno=-1
name=[16] ":1921e072_arr_23"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_24
paramno=-1
name=[16] ":1921e072_arr_24"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_25
paramno=-1
name=[16] ":1921e072_arr_25"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_26
paramno=-1
name=[16] ":1921e072_arr_26"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_27
paramno=-1
name=[16] ":1921e072_arr_27"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_28
paramno=-1
name=[16] ":1921e072_arr_28"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_29
paramno=-1
name=[16] ":1921e072_arr_29"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_30
paramno=-1
name=[16] ":1921e072_arr_30"
is_param=1
param_type=2
Key: Name: [16] :1921e072_arr_31
paramno=-1
name=[16] ":1921e072_arr_31"
is_param=1
param_type=2
Key: Name: [8] :ordDate
paramno=-1
name=[8] ":ordDate"
is_param=1
param_type=2
;
QUERY: 4, čas: 0.000931 s, počet: 1
SQL: [215] SELECT `key`, `value` FROM `mklubfff8_config`
UNION ALL
SELECT `key`, `value` FROM `cubecms_global_config`
WHERE `key` NOT IN (SELECT `key` FROM `mklubfff8_config`)
ORDER BY `key`
Params: 0
;
QUERY: 5, čas: 0.000701 s, počet: 1
SQL: [324] 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`.`mklubfff8_categories` AS t_cats LEFT JOIN mklubfff8_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: 6, čas: 0.000653 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=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: 7, čas: 0.000434 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: 8, čas: 0.000426 s, počet: 1
SQL: [1780] 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`.`mklubfff8_panels` AS t_panels LEFT JOIN mklubfff8_categories AS t_cat ON (`t_cat`.`id_category` = `t_panels`.`id_cat`)
LEFT JOIN mklubfff8_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 ( `t_panels`.`id_show_cat` = 0 OR `t_panels`.`panel_force_global` = 1 ) AND module IS NOT NULL OR (is_admin_cat = 1 AND ( `t_panels`.`id_show_cat` = 0 OR `t_panels`.`panel_force_global` = 1 )) )
ORDER BY `t_panels`.`porder` DESC
Params: 0
;
QUERY: 9, čas: 0.000391 s, počet: 9
SQL: [946] 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`.`mklubfff8_categories` AS t_cats LEFT JOIN mklubfff8_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: 10, čas: 0.000371 s, počet: 1
SQL: [1028] 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`.`mklubfff8_categories` AS t_cats LEFT JOIN mklubfff8_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
LEFT JOIN mklubfff8_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
WHERE (`t_cats`.`disable_cs` = 0 )
Params: 0
;
QUERY: 11, čas: 0.000354 s, počet: 1
SQL: [350] 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`.`mklubfff8_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: 12, čas: 0.000345 s, počet: 1
SQL: [1152] 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`.`mklubfff8_categories` AS t_cats LEFT JOIN mklubfff8_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
LEFT JOIN mklubfff8_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: 13, čas: 0.000339 s, počet: 1
SQL: [852] 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`.`mklubfff8_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: 14, čas: 0.000335 s, počet: 1
SQL: [1823] 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`.`mklubfff8_custom_menu_items` AS t_cm_items LEFT JOIN mklubfff8_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: 15, čas: 0.000292 s, počet: 2
SQL: [426] SELECT `t_advevent_places`.`id_ev_tag`, `t_advevent_places`.`tag_name`, `t_advevent_places`.`tag_deleted` FROM `kzvalmez_dev_221024`.`kz_adv_events_tags` AS t_advevent_places LEFT JOIN kz_adv_events_has_tags AS AdvEventsBase_Model_TagsConnection_0 ON (`AdvEventsBase_Model_TagsConnection_0`.`events_tags_id_tag` = `t_advevent_places`.`id_ev_tag`)
WHERE (events_id_event = :ide )
ORDER BY `t_advevent_places`.`tag_name` ASC
Params: 1
Key: Name: [4] :ide
paramno=-1
name=[4] ":ide"
is_param=1
param_type=2
;
QUERY: 16, čas: 0.000231 s, počet: 2
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: 17, čas: 0.000228 s, počet: 1
SQL: [877] 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`.`mklubfff8_partners` AS t_partners LEFT JOIN mklubfff8_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: 18, čas: 0.000181 s, počet: 1
SQL: [183] SELECT `t_mods`.`id_module`, `t_mods`.`name`, `t_mods`.`version`, `t_mods`.`version_major`, `t_mods`.`version_minor` FROM `kzvalmez_dev_221024`.`mklubfff8_modules_instaled` AS t_mods
Params: 0
;
QUERY: 19, čas: 0.000171 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: 20, čas: 0.000171 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: 21, čas: 0.000165 s, počet: 1
SQL: [334] 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`.`mklubfff8_texts` AS t_texts WHERE (`t_texts`.`id_item` = :idc )
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 3
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
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: 22, čas: 0.000148 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
;
