Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `EventType`.`slug_hr`, `EventType`.`naslov_hr`, `EventType`.`id` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`izbrisano` = 0 | 16 | 16 | 0 | |
SELECT `Audience`.`id`, `Audience`.`naslov_hr`, `Audience`.`slug_hr`, `Audience`.`spec_tip_vrsta_grade`, `Audience`.`izbrisano`, `Audience`.`created`, `Audience`.`modified` FROM `gkmmhr_cakedb873`.`audiences` AS `Audience` WHERE `izbrisano` = 0 AND `Audience`.`spec_tip_vrsta_grade` = 0 ORDER BY `Audience`.`spec_tip_vrsta_grade` ASC | 3 | 3 | 0 | |
SELECT `Tag`.`id`, `Tag`.`page`, `Tag`.`name`, `Tag`.`meta_title_hr`, `Tag`.`meta_keywords_hr`, `Tag`.`meta_description_hr`, `Tag`.`created`, `Tag`.`modified` FROM `gkmmhr_cakedb873`.`tags` AS `Tag` WHERE `page` = 'kalendar' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Date`.`id`, `Date`.`event_id`, `Date`.`date_type_id`, `Date`.`datetime`, `Date`.`all_day`, `Date`.`priority`, `Date`.`online`, `Date`.`izbrisano`, `Date`.`created`, `Date`.`modified`, `Event`.`id`, `Event`.`event_type_id`, `Event`.`subcategory_lokacija_id`, `Event`.`slug_hr`, `Event`.`naslov_hr`, `Event`.`dodatak_lokaciji`, `Event`.`tekst_hr`, `Event`.`img`, `Event`.`img_thumb`, `Event`.`img_path`, `Event`.`img_dir`, `Event`.`meta_title_hr`, `Event`.`meta_keywords_hr`, `Event`.`meta_description_hr`, `Event`.`redosljed`, `Event`.`istaknuto`, `Event`.`online`, `Event`.`izbrisano`, `Event`.`created`, `Event`.`modified` FROM `gkmmhr_cakedb873`.`dates` AS `Date` LEFT JOIN `gkmmhr_cakedb873`.`events` AS `Event` ON (`Date`.`event_id` = `Event`.`id`) WHERE `Date`.`izbrisano` = 0 AND `Event`.`izbrisano` = 0 AND `Event`.`online` = 1 AND `Date`.`datetime` >= "2022-06-30 00:00:00" ORDER BY `Date`.`datetime` asc LIMIT 10 | 3 | 3 | 0 | |
SELECT `EventType`.`id`, `EventType`.`spec_tip_radionice`, `EventType`.`spec_tip_izlozbe`, `EventType`.`slug_hr`, `EventType`.`naslov_hr`, `EventType`.`izbrisano`, `EventType`.`created`, `EventType`.`modified` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`id` = 13 | 1 | 1 | 0 | |
SELECT `Lokacija`.`id`, `Lokacija`.`spec_tip_preporuke`, `Lokacija`.`spec_tip_novosti`, `Lokacija`.`category_id`, `Lokacija`.`slug_hr`, `Lokacija`.`naslov_hr`, `Lokacija`.`tekst_hr`, `Lokacija`.`lat`, `Lokacija`.`long`, `Lokacija`.`img`, `Lokacija`.`img_thumb`, `Lokacija`.`img_path`, `Lokacija`.`img_dir`, `Lokacija`.`meta_title_hr`, `Lokacija`.`meta_keywords_hr`, `Lokacija`.`meta_description_hr`, `Lokacija`.`izbrisano`, `Lokacija`.`redosljed`, `Lokacija`.`menu_visible`, `Lokacija`.`menu_redosljed`, `Lokacija`.`fmenu_visible`, `Lokacija`.`fmenu_redosljed`, `Lokacija`.`nodelete`, `Lokacija`.`created`, `Lokacija`.`modified` FROM `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` WHERE `Lokacija`.`id` = 4 | 1 | 1 | 0 | |
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`img`, `EventImage`.`img_thumb`, `EventImage`.`img_path`, `EventImage`.`img_dir`, `EventImage`.`naslov_hr`, `EventImage`.`redosljed`, `EventImage`.`online`, `EventImage`.`izbrisano`, `EventImage`.`created`, `EventImage`.`modified` FROM `gkmmhr_cakedb873`.`event_images` AS `EventImage` WHERE `izbrisano` = 0 AND `EventImage`.`event_id` = (2098) ORDER BY `redosljed` ASC | 0 | 0 | 0 | |
SELECT `Date`.`id`, `Date`.`event_id`, `Date`.`date_type_id`, `Date`.`datetime`, `Date`.`all_day`, `Date`.`priority`, `Date`.`online`, `Date`.`izbrisano`, `Date`.`created`, `Date`.`modified` FROM `gkmmhr_cakedb873`.`dates` AS `Date` WHERE `izbrisano` = 0 AND `Date`.`event_id` = (2098) | 1 | 1 | 0 | |
SELECT `Audience`.`id`, `Audience`.`naslov_hr`, `Audience`.`slug_hr`, `Audience`.`spec_tip_vrsta_grade`, `Audience`.`izbrisano`, `Audience`.`created`, `Audience`.`modified`, `AudiencesLink`.`id`, `AudiencesLink`.`id_audience`, `AudiencesLink`.`id_event`, `AudiencesLink`.`id_article` FROM `gkmmhr_cakedb873`.`audiences` AS `Audience` JOIN `gkmmhr_cakedb873`.`audiences_links` AS `AudiencesLink` ON (`AudiencesLink`.`id_event` = 2098 AND `AudiencesLink`.`id_audience` = `Audience`.`id`) ORDER BY `spec_tip_vrsta_grade` ASC | 1 | 1 | 0 | |
SELECT `EventType`.`id`, `EventType`.`spec_tip_radionice`, `EventType`.`spec_tip_izlozbe`, `EventType`.`slug_hr`, `EventType`.`naslov_hr`, `EventType`.`izbrisano`, `EventType`.`created`, `EventType`.`modified` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`id` = 8 | 1 | 1 | 0 | |
SELECT `Lokacija`.`id`, `Lokacija`.`spec_tip_preporuke`, `Lokacija`.`spec_tip_novosti`, `Lokacija`.`category_id`, `Lokacija`.`slug_hr`, `Lokacija`.`naslov_hr`, `Lokacija`.`tekst_hr`, `Lokacija`.`lat`, `Lokacija`.`long`, `Lokacija`.`img`, `Lokacija`.`img_thumb`, `Lokacija`.`img_path`, `Lokacija`.`img_dir`, `Lokacija`.`meta_title_hr`, `Lokacija`.`meta_keywords_hr`, `Lokacija`.`meta_description_hr`, `Lokacija`.`izbrisano`, `Lokacija`.`redosljed`, `Lokacija`.`menu_visible`, `Lokacija`.`menu_redosljed`, `Lokacija`.`fmenu_visible`, `Lokacija`.`fmenu_redosljed`, `Lokacija`.`nodelete`, `Lokacija`.`created`, `Lokacija`.`modified` FROM `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` WHERE `Lokacija`.`id` = 4 | 1 | 1 | 0 | |
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`img`, `EventImage`.`img_thumb`, `EventImage`.`img_path`, `EventImage`.`img_dir`, `EventImage`.`naslov_hr`, `EventImage`.`redosljed`, `EventImage`.`online`, `EventImage`.`izbrisano`, `EventImage`.`created`, `EventImage`.`modified` FROM `gkmmhr_cakedb873`.`event_images` AS `EventImage` WHERE `izbrisano` = 0 AND `EventImage`.`event_id` = (2100) ORDER BY `redosljed` ASC | 0 | 0 | 0 | |
SELECT `Date`.`id`, `Date`.`event_id`, `Date`.`date_type_id`, `Date`.`datetime`, `Date`.`all_day`, `Date`.`priority`, `Date`.`online`, `Date`.`izbrisano`, `Date`.`created`, `Date`.`modified` FROM `gkmmhr_cakedb873`.`dates` AS `Date` WHERE `izbrisano` = 0 AND `Date`.`event_id` = (2100) | 1 | 1 | 0 | |
SELECT `Audience`.`id`, `Audience`.`naslov_hr`, `Audience`.`slug_hr`, `Audience`.`spec_tip_vrsta_grade`, `Audience`.`izbrisano`, `Audience`.`created`, `Audience`.`modified`, `AudiencesLink`.`id`, `AudiencesLink`.`id_audience`, `AudiencesLink`.`id_event`, `AudiencesLink`.`id_article` FROM `gkmmhr_cakedb873`.`audiences` AS `Audience` JOIN `gkmmhr_cakedb873`.`audiences_links` AS `AudiencesLink` ON (`AudiencesLink`.`id_event` = 2100 AND `AudiencesLink`.`id_audience` = `Audience`.`id`) ORDER BY `spec_tip_vrsta_grade` ASC | 1 | 1 | 0 | |
SELECT `EventType`.`id`, `EventType`.`spec_tip_radionice`, `EventType`.`spec_tip_izlozbe`, `EventType`.`slug_hr`, `EventType`.`naslov_hr`, `EventType`.`izbrisano`, `EventType`.`created`, `EventType`.`modified` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`id` = 8 | 1 | 1 | 0 | |
SELECT `Lokacija`.`id`, `Lokacija`.`spec_tip_preporuke`, `Lokacija`.`spec_tip_novosti`, `Lokacija`.`category_id`, `Lokacija`.`slug_hr`, `Lokacija`.`naslov_hr`, `Lokacija`.`tekst_hr`, `Lokacija`.`lat`, `Lokacija`.`long`, `Lokacija`.`img`, `Lokacija`.`img_thumb`, `Lokacija`.`img_path`, `Lokacija`.`img_dir`, `Lokacija`.`meta_title_hr`, `Lokacija`.`meta_keywords_hr`, `Lokacija`.`meta_description_hr`, `Lokacija`.`izbrisano`, `Lokacija`.`redosljed`, `Lokacija`.`menu_visible`, `Lokacija`.`menu_redosljed`, `Lokacija`.`fmenu_visible`, `Lokacija`.`fmenu_redosljed`, `Lokacija`.`nodelete`, `Lokacija`.`created`, `Lokacija`.`modified` FROM `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` WHERE `Lokacija`.`id` = 4 | 1 | 1 | 0 | |
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`img`, `EventImage`.`img_thumb`, `EventImage`.`img_path`, `EventImage`.`img_dir`, `EventImage`.`naslov_hr`, `EventImage`.`redosljed`, `EventImage`.`online`, `EventImage`.`izbrisano`, `EventImage`.`created`, `EventImage`.`modified` FROM `gkmmhr_cakedb873`.`event_images` AS `EventImage` WHERE `izbrisano` = 0 AND `EventImage`.`event_id` = (2099) ORDER BY `redosljed` ASC | 0 | 0 | 0 | |
SELECT `Date`.`id`, `Date`.`event_id`, `Date`.`date_type_id`, `Date`.`datetime`, `Date`.`all_day`, `Date`.`priority`, `Date`.`online`, `Date`.`izbrisano`, `Date`.`created`, `Date`.`modified` FROM `gkmmhr_cakedb873`.`dates` AS `Date` WHERE `izbrisano` = 0 AND `Date`.`event_id` = (2099) | 1 | 1 | 0 | |
SELECT `Audience`.`id`, `Audience`.`naslov_hr`, `Audience`.`slug_hr`, `Audience`.`spec_tip_vrsta_grade`, `Audience`.`izbrisano`, `Audience`.`created`, `Audience`.`modified`, `AudiencesLink`.`id`, `AudiencesLink`.`id_audience`, `AudiencesLink`.`id_event`, `AudiencesLink`.`id_article` FROM `gkmmhr_cakedb873`.`audiences` AS `Audience` JOIN `gkmmhr_cakedb873`.`audiences_links` AS `AudiencesLink` ON (`AudiencesLink`.`id_event` = 2099 AND `AudiencesLink`.`id_audience` = `Audience`.`id`) ORDER BY `spec_tip_vrsta_grade` ASC | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `gkmmhr_cakedb873`.`dates` AS `Date` LEFT JOIN `gkmmhr_cakedb873`.`events` AS `Event` ON (`Date`.`event_id` = `Event`.`id`) WHERE `Date`.`izbrisano` = 0 AND `Event`.`izbrisano` = 0 AND `Event`.`online` = 1 AND `Date`.`datetime` >= "2022-06-30 00:00:00" | 1 | 1 | 0 | |
SELECT `Config`.`id`, `Config`.`skraceni_naziv`, `Config`.`naziv_ispostave`, `Config`.`naziv_ustanove`, `Config`.`adresa_txt`, `Config`.`info_pult_box`, `Config`.`radno_vrijeme_box`, `Config`.`newsletter_script`, `Config`.`footer_script`, `Config`.`footer_css`, `Config`.`cookie-bar-tekst`, `Config`.`moj_gkmm`, `Config`.`moj_gkmm_naziv`, `Config`.`facebook`, `Config`.`instagram`, `Config`.`twitter`, `Config`.`youtube`, `Config`.`soundcloud`, `Config`.`issuu`, `Config`.`vimeo`, `Config`.`lat`, `Config`.`long`, `Config`.`adresa`, `Config`.`menu_dogadaji_redosljed`, `Config`.`boja_vodic`, `Config`.`boja_dogadanja`, `Config`.`boja_djeca`, `Config`.`boja_mladi`, `Config`.`boja_odrasli`, `Config`.`boja_preporuke`, `Config`.`boja_novosti`, `Config`.`boja_ostalo`, `Config`.`boja_main_menu`, `Config`.`boja_footer_up`, `Config`.`boja_footer_down`, `Config`.`boja_right_menu`, `Config`.`img_path`, `Config`.`img_logo_header`, `Config`.`img_logo_footer`, `Config`.`img_top_menu_bg`, `Config`.`img_naslovna_preporuke_bg`, `Config`.`img_naslovna_dogadanja_banner`, `Config`.`img_rmenu_preporuke_bg`, `Config`.`img_rmenu_novosti_filter_bg`, `Config`.`img_rmenu_radionice`, `Config`.`img_rmenu_katalog`, `Config`.`img_rmenu_djeca`, `Config`.`img_rmenu_mladi`, `Config`.`img_rmenu_arhiva`, `Config`.`img_rmenu_izlozbe`, `Config`.`created`, `Config`.`modified` FROM `gkmmhr_cakedb873`.`configs` AS `Config` WHERE `id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`naslov_hr`, `Category`.`slug_hr`, `Category`.`spec_tip_vodic`, `Category`.`spec_tip_za_djecu`, `Category`.`spec_tip_za_mlade`, `Category`.`id` FROM `gkmmhr_cakedb873`.`categories` AS `Category` WHERE `Category`.`izbrisano` = 0 AND `Category`.`menu_visible` = 1 ORDER BY `Category`.`menu_redosljed` ASC | 9 | 9 | 0 | |
SELECT `Article`.`id`, `Article`.`slug_hr`, `Article`.`naslov_hr`, `Article`.`menu_redosljed`, `Article`.`category_id` FROM `gkmmhr_cakedb873`.`articles` AS `Article` WHERE `izbrisano` = 0 AND `online` = 1 AND `menu_visible` = 1 AND `subcategory_id` = 0 AND `subsubcategory_id` = 0 AND `Article`.`category_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 11) ORDER BY `Article`.`redosljed` ASC | 10 | 10 | 1 | maybe slow |
SELECT `Subcategory`.`id`, `Subcategory`.`slug_hr`, `Subcategory`.`naslov_hr`, `Subcategory`.`menu_redosljed`, `Subcategory`.`category_id` FROM `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` WHERE `izbrisano` = 0 AND `menu_visible` = 1 AND `Subcategory`.`category_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 11) ORDER BY `Subcategory`.`redosljed` ASC | 36 | 36 | 0 | |
SELECT `Subsubcategory`.`id`, `Subsubcategory`.`slug_hr`, `Subsubcategory`.`naslov_hr`, `Subsubcategory`.`menu_redosljed`, `Subsubcategory`.`category_id` FROM `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` WHERE `izbrisano` = 0 AND `online` = 1 AND `menu_visible` = 1 AND `Subsubcategory`.`category_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 11) ORDER BY `Subsubcategory`.`redosljed` ASC | 0 | 0 | 0 | |
SELECT `Article`.`naslov_hr`, `Article`.`slug_hr`, `Article`.`id` FROM `gkmmhr_cakedb873`.`articles` AS `Article` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` ON (`Article`.`subsubcategory_id` = `Subsubcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`authors` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` ON (`Article`.`subcategory_lokacija_id` = `Lokacija`.`id`) WHERE `Article`.`izbrisano` = 0 AND `Article`.`online` = 1 AND `Article`.`fmenu_visible` = 1 ORDER BY `Article`.`fmenu_redosljed` ASC | 2 | 2 | 2 | |
SELECT `Article`.`id`, `Article`.`slug_hr`, `Article`.`naslov_hr`, `Article`.`img`, `Article`.`img_path`, `Article`.`img_dir`, `Article`.`autor_djela`, `Subcategory`.`spec_tip_preporuke` FROM `gkmmhr_cakedb873`.`articles` AS `Article` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` ON (`Article`.`subsubcategory_id` = `Subsubcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`authors` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` ON (`Article`.`subcategory_lokacija_id` = `Lokacija`.`id`) WHERE `Subcategory`.`spec_tip_preporuke` = 1 AND `Article`.`izbrisano` = 0 AND `Article`.`online` = 1 ORDER BY `Article`.`redosljed` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `EventType`.`slug_hr`, `EventType`.`naslov_hr`, `EventType`.`id` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`izbrisano` = 0 | 16 | 16 | 0 | |
SELECT `Banner`.`naslov_hr`, `Banner`.`url_hr`, `Banner`.`img`, `Banner`.`img_path`, `Banner`.`img_dir` FROM `gkmmhr_cakedb873`.`banners` AS `Banner` WHERE `Banner`.`online` = 1 AND `Banner`.`izbrisano` = 0 ORDER BY `Banner`.`redosljed` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`slug_hr`, `Article`.`naslov_hr`, `Article`.`tekst_hr` FROM `gkmmhr_cakedb873`.`articles` AS `Article` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` ON (`Article`.`subsubcategory_id` = `Subsubcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`authors` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` ON (`Article`.`subcategory_lokacija_id` = `Lokacija`.`id`) WHERE `Article`.`id` = 50 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`slug_hr`, `Article`.`naslov_hr`, `Article`.`tekst_hr` FROM `gkmmhr_cakedb873`.`articles` AS `Article` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` ON (`Article`.`subsubcategory_id` = `Subsubcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`authors` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` ON (`Article`.`subcategory_lokacija_id` = `Lokacija`.`id`) WHERE `Article`.`id` = 51 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`slug_hr`, `Article`.`naslov_hr`, `Article`.`tekst_hr` FROM `gkmmhr_cakedb873`.`articles` AS `Article` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` ON (`Article`.`subsubcategory_id` = `Subsubcategory`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`authors` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` ON (`Article`.`subcategory_lokacija_id` = `Lokacija`.`id`) WHERE `Article`.`id` = 52 LIMIT 1 | 1 | 1 | 0 | |
SELECT `EventType`.`slug_hr`, `EventType`.`naslov_hr`, `EventType`.`id` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`spec_tip_radionice` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `EventType`.`slug_hr`, `EventType`.`naslov_hr`, `EventType`.`id` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`spec_tip_izlozbe` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`naslov_hr`, `Category`.`slug_hr` FROM `gkmmhr_cakedb873`.`categories` AS `Category` WHERE `Category`.`spec_tip_za_djecu` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`naslov_hr`, `Category`.`slug_hr` FROM `gkmmhr_cakedb873`.`categories` AS `Category` WHERE `Category`.`spec_tip_za_mlade` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`naslov_hr`, `Category`.`slug_hr` FROM `gkmmhr_cakedb873`.`categories` AS `Category` WHERE `Category`.`spec_tip_katalog` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`naslov_hr`, `Category`.`slug_hr` FROM `gkmmhr_cakedb873`.`categories` AS `Category` WHERE `Category`.`spec_tip_arhiva` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`naslov_hr`, `Subcategory`.`slug_hr` FROM `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Subcategory`.`category_id` = `Category`.`id`) WHERE `Subcategory`.`spec_tip_preporuke` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`naslov_hr`, `Subcategory`.`slug_hr` FROM `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Subcategory`.`category_id` = `Category`.`id`) WHERE `Subcategory`.`spec_tip_novosti` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Date`.`id`, `Date`.`event_id`, `Date`.`date_type_id`, `Date`.`datetime`, `Date`.`all_day`, `Date`.`priority`, `Date`.`online`, `Date`.`izbrisano`, `Date`.`created`, `Date`.`modified`, `Event`.`slug_hr`, `Event`.`naslov_hr`, `Event`.`dodatak_lokaciji`, `Event`.`event_type_id`, `Event`.`subcategory_lokacija_id` FROM `gkmmhr_cakedb873`.`dates` AS `Date` LEFT JOIN `gkmmhr_cakedb873`.`events` AS `Event` ON (`Date`.`event_id` = `Event`.`id`) WHERE `Date`.`izbrisano` = 0 AND `Event`.`izbrisano` = 0 AND `Event`.`online` = 1 AND `Date`.`datetime` >= "2022-06-30 00:00:00" AND `Date`.`datetime` <= "2022-07-07 23:59:00" ORDER BY `Date`.`datetime` ASC | 3 | 3 | 1 | maybe slow |
SELECT `EventType`.`naslov_hr` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`id` = 13 | 1 | 1 | 0 | |
SELECT `Lokacija`.`naslov_hr` FROM `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` WHERE `Lokacija`.`id` = 4 | 1 | 1 | 0 | |
SELECT `EventType`.`naslov_hr` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`id` = 8 | 1 | 1 | 0 | |
SELECT `Lokacija`.`naslov_hr` FROM `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` WHERE `Lokacija`.`id` = 4 | 1 | 1 | 0 | |
SELECT `EventType`.`naslov_hr` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`id` = 8 | 1 | 1 | 0 | |
SELECT `Lokacija`.`naslov_hr` FROM `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` WHERE `Lokacija`.`id` = 4 | 1 | 1 | 0 | |