| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`slug_hr`, `Subcategory`.`naslov_hr`, `Subcategory`.`tekst_hr`, `Subcategory`.`img`, `Subcategory`.`img_path`, `Subcategory`.`img_dir`, `Subcategory`.`meta_title_hr`, `Subcategory`.`meta_keywords_hr`, `Subcategory`.`meta_description_hr`, `Subcategory`.`spec_tip_novosti`, `Subcategory`.`spec_tip_preporuke`, `Subcategory`.`lat`, `Subcategory`.`long`, `Category`.`spec_tip_lokacija`, `Category`.`spec_tip_arhiva`, `Category`.`spec_tip_za_djecu`, `Category`.`spec_tip_za_mlade`, `Category`.`slug_hr`, `Category`.`naslov_hr`, `Category`.`id` FROM `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` LEFT JOIN `gkmmhr_cakedb873`.`categories` AS `Category` ON (`Subcategory`.`category_id` = `Category`.`id`) WHERE `Subcategory`.`slug_hr` = 'novosti' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Subsubcategory`.`slug_hr`, `Subsubcategory`.`naslov_hr`, `Subsubcategory`.`subcategory_id` FROM `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` WHERE `Subsubcategory`.`izbrisano` = 0 AND `Subsubcategory`.`online` = 1 AND `Subsubcategory`.`subcategory_id` = (1) | 0 | 0 | 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` = 'kategorija' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`naslov_hr`, `Category`.`slug_hr`, `Category`.`spec_tip_lokacija` FROM `gkmmhr_cakedb873`.`categories` AS `Category` WHERE `Category`.`spec_tip_lokacija` = 1 ORDER BY `Category`.`redosljed` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Subcategory`.`id`, `Subcategory`.`slug_hr`, `Subcategory`.`naslov_hr`, `Subcategory`.`category_id` FROM `gkmmhr_cakedb873`.`subcategories` AS `Subcategory` WHERE `izbrisano` = 0 AND `Subcategory`.`category_id` = (3) ORDER BY `Subcategory`.`redosljed` ASC | 10 | 10 | 0 | |
| SELECT `Subsubcategory`.`id`, `Subsubcategory`.`slug_hr`, `Subsubcategory`.`naslov_hr`, `Subsubcategory`.`subcategory_id` FROM `gkmmhr_cakedb873`.`subsubcategories` AS `Subsubcategory` WHERE `izbrisano` = 0 AND `online` = 1 AND `Subsubcategory`.`subcategory_id` IN (4, 5, 6, 7, 8, 9, 10, 11, 12, 13) ORDER BY `Subsubcategory`.`redosljed` ASC | 23 | 23 | 0 | |
| SELECT `Article`.`slug_hr`, `Article`.`naslov_hr`, `Article`.`datum`, `Article`.`autor_djela`, `Article`.`img`, `Article`.`img_path`, `Article`.`img_dir`, `Lokacija`.`slug_hr`, `Lokacija`.`naslov_hr`, `Lokacija`.`id`, `Article`.`id` FROM `gkmmhr_cakedb873`.`articles` AS `Article` LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` ON (`Article`.`subcategory_lokacija_id` = `Lokacija`.`id`) WHERE `Article`.`izbrisano` = 0 AND `Article`.`online` = 1 AND `Article`.`subsubcategory_id` = 0 AND `Article`.`subcategory_id` = 1 ORDER BY `Article`.`redosljed` asc LIMIT 10 | 10 | 10 | 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_article` IN (1644, 1659, 1663, 1640, 1351, 1639, 1453, 1628, 1638, 1541) AND `AudiencesLink`.`id_audience` = `Audience`.`id`) ORDER BY `spec_tip_vrsta_grade` ASC | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `gkmmhr_cakedb873`.`articles` AS `Article` LEFT JOIN `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` ON (`Article`.`subcategory_lokacija_id` = `Lokacija`.`id`) WHERE `Article`.`izbrisano` = 0 AND `Article`.`online` = 1 AND `Article`.`subsubcategory_id` = 0 AND `Article`.`subcategory_id` = 1 | 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 | 1 | maybe slow |
| 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 | 14 | 14 | 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-01-17 00:00:00" AND `Date`.`datetime` <= "2022-01-24 23:59:00" ORDER BY `Date`.`datetime` ASC | 3 | 3 | 0 | |
| SELECT `EventType`.`naslov_hr` FROM `gkmmhr_cakedb873`.`event_types` AS `EventType` WHERE `EventType`.`id` = 9 | 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` = 21 | 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` = 2 | 1 | 1 | 0 | |
| SELECT `Lokacija`.`naslov_hr` FROM `gkmmhr_cakedb873`.`subcategories` AS `Lokacija` WHERE `Lokacija`.`id` = 4 | 1 | 1 | 0 | |
