Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`name`, `Setting`.`value` FROM `coki_demo`.`settings` AS `Setting` WHERE `view` = 'frontend' | 16 | 16 | 1 | maybe slow |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`position`, `Menu`.`lang`, `Menu`.`visible`, `Menu`.`freigabe`, `Menu`.`pagetyp`, `Menu`.`title`, `Menu`.`deforder`, `Menu`.`deftemplate`, `Menu`.`comment`, `Menu`.`slug_url`, `Menu`.`accesskey`, `Menu`.`description` FROM `coki_demo`.`menus` AS `Menu` WHERE `visible` = 1 AND `freigabe` = 1 ORDER BY `position` asc | 7 | 7 | 1 | maybe slow |
SELECT `Portlet`.`id`, `Portlet`.`created`, `Portlet`.`modified`, `Portlet`.`freigabe`, `Portlet`.`creator`, `Portlet`.`sprache`, `Portlet`.`position`, `Portlet`.`teaser`, `Portlet`.`article`, `Portlet`.`title`, `Portlet`.`flag_2`, `Portlet`.`flag_3`, `Portlet`.`flag_4`, `MenusPortlet`.`menu_id`, `MenusPortlet`.`portlet_id` FROM `coki_demo`.`portlets` AS `Portlet` JOIN `coki_demo`.`menus_portlets` AS `MenusPortlet` ON (`MenusPortlet`.`menu_id` IN (163, 164, 165, 166, 106, 107, 151) AND `MenusPortlet`.`portlet_id` = `Portlet`.`id`) | 3 | 3 | 1 | maybe slow |
SELECT `Menu`.`lft`, `Menu`.`rght` FROM `coki_demo`.`menus` AS `Menu` WHERE `Menu`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`position`, `Menu`.`lang`, `Menu`.`visible`, `Menu`.`freigabe`, `Menu`.`pagetyp`, `Menu`.`title`, `Menu`.`deforder`, `Menu`.`deftemplate`, `Menu`.`comment`, `Menu`.`slug_url`, `Menu`.`accesskey`, `Menu`.`description` FROM `coki_demo`.`menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`lft` <= 2 AND `Menu`.`rght` >= 17 ORDER BY `Menu`.`lft` asc | 1 | 1 | 1 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`position`, `Menu`.`lang`, `Menu`.`visible`, `Menu`.`freigabe`, `Menu`.`pagetyp`, `Menu`.`title`, `Menu`.`deforder`, `Menu`.`deftemplate`, `Menu`.`comment`, `Menu`.`slug_url`, `Menu`.`accesskey`, `Menu`.`description` FROM `coki_demo`.`menus` AS `Menu` WHERE `Menu`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Portlet`.`id`, `Portlet`.`created`, `Portlet`.`modified`, `Portlet`.`freigabe`, `Portlet`.`creator`, `Portlet`.`sprache`, `Portlet`.`position`, `Portlet`.`teaser`, `Portlet`.`article`, `Portlet`.`title`, `Portlet`.`flag_2`, `Portlet`.`flag_3`, `Portlet`.`flag_4`, `MenusPortlet`.`menu_id`, `MenusPortlet`.`portlet_id` FROM `coki_demo`.`portlets` AS `Portlet` JOIN `coki_demo`.`menus_portlets` AS `MenusPortlet` ON (`MenusPortlet`.`menu_id` = 99 AND `MenusPortlet`.`portlet_id` = `Portlet`.`id`) | 0 | 0 | 0 | |
SELECT `Article`.`id`, `Article`.`menu_id`, `Article`.`alben_id`, `Article`.`created`, `Article`.`modified`, `Article`.`freigabe`, `Article`.`creator`, `Article`.`start`, `Article`.`ende`, `Article`.`sprache`, `Article`.`position`, `Article`.`headline`, `Article`.`teaser`, `Article`.`article`, `Article`.`bilder`, `Article`.`template`, `Article`.`einleitung`, `Article`.`archiv`, `Article`.`menuvisible`, `Article`.`title`, `Article`.`metakeys`, `Article`.`metadesc`, `Article`.`flag_2`, `Article`.`flag_3`, `Article`.`flag_4`, `Article`.`flag_5`, `Article`.`scripts`, `Article`.`styles`, `Article`.`story`, `Article`.`akttab`, `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`position`, `Menu`.`lang`, `Menu`.`visible`, `Menu`.`freigabe`, `Menu`.`pagetyp`, `Menu`.`title`, `Menu`.`deforder`, `Menu`.`deftemplate`, `Menu`.`comment`, `Menu`.`slug_url`, `Menu`.`accesskey`, `Menu`.`description`, `Alben`.`id`, `Alben`.`freigabe`, `Alben`.`kategorie`, `Alben`.`foldername`, `Alben`.`titel`, `Alben`.`beschreibung`, `Alben`.`created`, `Alben`.`modified`, `Alben`.`creator`, `Alben`.`position` FROM `coki_demo`.`articles` AS `Article` LEFT JOIN `coki_demo`.`menus` AS `Menu` ON (`Article`.`menu_id` = `Menu`.`id`) LEFT JOIN `coki_demo`.`alben` AS `Alben` ON (`Article`.`alben_id` = `Alben`.`id`) WHERE `menu_id` = 99 AND `Article`.`freigabe` = 1 AND `start` <= '2024-03-29' AND ((`ende` IS NULL) OR (`ende` <= '0000-00-00') OR (`ende` > '2024-03-29')) ORDER BY `Article`.`position` asc, `Article`.`title` asc LIMIT 1 | 1 | 1 | 1 | |
SELECT `Portlet`.`id`, `Portlet`.`created`, `Portlet`.`modified`, `Portlet`.`freigabe`, `Portlet`.`creator`, `Portlet`.`sprache`, `Portlet`.`position`, `Portlet`.`teaser`, `Portlet`.`article`, `Portlet`.`title`, `Portlet`.`flag_2`, `Portlet`.`flag_3`, `Portlet`.`flag_4`, `ArticlesPortlet`.`article_id`, `ArticlesPortlet`.`portlet_id` FROM `coki_demo`.`portlets` AS `Portlet` JOIN `coki_demo`.`articles_portlets` AS `ArticlesPortlet` ON (`ArticlesPortlet`.`article_id` = 361 AND `ArticlesPortlet`.`portlet_id` = `Portlet`.`id`) | 0 | 0 | 0 | |
SELECT `Article`.`id`, `Article`.`title` FROM `coki_demo`.`articles` AS `Article` WHERE `menu_id` = 99 AND `Article`.`freigabe` = 1 AND `start` <= '2024-03-29' AND ((`ende` IS NULL) OR (`ende` <= '0000-00-00') OR (`ende` > '2024-03-29')) ORDER BY `Article`.`position` asc, `Article`.`title` asc | 1 | 1 | 1 | |
SELECT `Article`.`id`, `Article`.`menu_id`, `Article`.`alben_id`, `Article`.`created`, `Article`.`modified`, `Article`.`freigabe`, `Article`.`creator`, `Article`.`start`, `Article`.`ende`, `Article`.`sprache`, `Article`.`position`, `Article`.`headline`, `Article`.`teaser`, `Article`.`article`, `Article`.`bilder`, `Article`.`template`, `Article`.`einleitung`, `Article`.`archiv`, `Article`.`menuvisible`, `Article`.`title`, `Article`.`metakeys`, `Article`.`metadesc`, `Article`.`flag_2`, `Article`.`flag_3`, `Article`.`flag_4`, `Article`.`flag_5`, `Article`.`scripts`, `Article`.`styles`, `Article`.`story`, `Article`.`akttab`, `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`position`, `Menu`.`lang`, `Menu`.`visible`, `Menu`.`freigabe`, `Menu`.`pagetyp`, `Menu`.`title`, `Menu`.`deforder`, `Menu`.`deftemplate`, `Menu`.`comment`, `Menu`.`slug_url`, `Menu`.`accesskey`, `Menu`.`description`, `Alben`.`id`, `Alben`.`freigabe`, `Alben`.`kategorie`, `Alben`.`foldername`, `Alben`.`titel`, `Alben`.`beschreibung`, `Alben`.`created`, `Alben`.`modified`, `Alben`.`creator`, `Alben`.`position` FROM `coki_demo`.`articles` AS `Article` LEFT JOIN `coki_demo`.`menus` AS `Menu` ON (`Article`.`menu_id` = `Menu`.`id`) LEFT JOIN `coki_demo`.`alben` AS `Alben` ON (`Article`.`alben_id` = `Alben`.`id`) WHERE `menu_id` = 99 AND `Article`.`freigabe` = 1 AND `start` <= '2024-03-29' AND ((`ende` IS NULL) OR (`ende` <= '0000-00-00') OR (`ende` > '2024-03-29')) ORDER BY `Article`.`position` asc, `Article`.`title` asc | 1 | 1 | 1 | |
SELECT `Portlet`.`id`, `Portlet`.`created`, `Portlet`.`modified`, `Portlet`.`freigabe`, `Portlet`.`creator`, `Portlet`.`sprache`, `Portlet`.`position`, `Portlet`.`teaser`, `Portlet`.`article`, `Portlet`.`title`, `Portlet`.`flag_2`, `Portlet`.`flag_3`, `Portlet`.`flag_4`, `ArticlesPortlet`.`article_id`, `ArticlesPortlet`.`portlet_id` FROM `coki_demo`.`portlets` AS `Portlet` JOIN `coki_demo`.`articles_portlets` AS `ArticlesPortlet` ON (`ArticlesPortlet`.`article_id` = 361 AND `ArticlesPortlet`.`portlet_id` = `Portlet`.`id`) | 0 | 0 | 0 | |
SELECT `Alben`.`id`, `Alben`.`freigabe`, `Alben`.`kategorie`, `Alben`.`foldername`, `Alben`.`titel`, `Alben`.`beschreibung`, `Alben`.`created`, `Alben`.`modified`, `Alben`.`creator`, `Alben`.`position` FROM `coki_demo`.`alben` AS `Alben` WHERE `Alben`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `coki_demo`.`comments` AS `Comment` LEFT JOIN `coki_demo`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `article_id` = 361 AND `status` = 0 | 1 | 1 | 0 | |