Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Article`.`id`, `Article`.`category_id`, `Article`.`subcategory_id`, `Article`.`subsubcategory_id`, `Article`.`subcategory_lokacija_id`, `Article`.`author_id`, `Article`.`spec_tip_terms`, `Article`.`spec_tip_privacy`, `Article`.`spec_tip_cookie`, `Article`.`slug_hr`, `Article`.`naslov_hr`, `Article`.`autor_djela`, `Article`.`short_tekst_hr`, `Article`.`tekst_hr`, `Article`.`datum`, `Article`.`img`, `Article`.`img_thumb`, `Article`.`img_path`, `Article`.`img_dir`, `Article`.`meta_title_hr`, `Article`.`meta_keywords_hr`, `Article`.`meta_description_hr`, `Article`.`nodelete`, `Article`.`izbrisano`, `Article`.`online`, `Article`.`redosljed`, `Article`.`menu_visible`, `Article`.`menu_redosljed`, `Article`.`fmenu_visible`, `Article`.`fmenu_redosljed`, `Article`.`created`, `Article`.`modified`, `Category`.`spec_tip_lokacija`, `Category`.`spec_tip_arhiva`, `Category`.`spec_tip_za_djecu`, `Category`.`spec_tip_za_mlade`, `Category`.`slug_hr`, `Category`.`naslov_hr`, `Subcategory`.`slug_hr`, `Subcategory`.`naslov_hr`, `Subcategory`.`spec_tip_novosti`, `Subcategory`.`spec_tip_preporuke`, `Subsubcategory`.`slug_hr`, `Subsubcategory`.`naslov_hr`, `Author`.`ime`, `Author`.`slug_hr`, `Lokacija`.`slug_hr`, `Lokacija`.`naslov_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`.`slug_hr` = 'pet-naslova-s-tematikom-afganistana' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `ArticleImage`.`id`, `ArticleImage`.`article_id`, `ArticleImage`.`img`, `ArticleImage`.`img_thumb`, `ArticleImage`.`img_path`, `ArticleImage`.`img_dir`, `ArticleImage`.`naslov_hr`, `ArticleImage`.`redosljed`, `ArticleImage`.`online`, `ArticleImage`.`izbrisano`, `ArticleImage`.`created`, `ArticleImage`.`modified` FROM `gkmmhr_cakedb873`.`article_images` AS `ArticleImage` WHERE `izbrisano` = 0 AND `online` = 1 AND `ArticleImage`.`article_id` = (1617) ORDER BY `redosljed` ASC | 0 | 0 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`slug_hr`, `Subcategory`.`naslov_hr`, `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`.`id` = 0 LIMIT 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` = 'stranica' LIMIT 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 | 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-27 00:00:00" AND `Date`.`datetime` <= "2022-07-04 23:59:00" ORDER BY `Date`.`datetime` ASC | 4 | 4 | 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` = 23 | 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` = 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 | |