| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| DESCRIBE `modules` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `menus` | | 6 | 6 | 1 | maybe slow |
| DESCRIBE `menus_items` | | 15 | 15 | 1 | maybe slow |
| DESCRIBE `modules_languages` | | 2 | 2 | 1 | maybe slow |
| DESCRIBE `modules_logins` | | 3 | 3 | 1 | maybe slow |
| DESCRIBE `modules_rights` | | 3 | 3 | 1 | maybe slow |
| DESCRIBE `contents` | | 14 | 14 | 1 | maybe slow |
| DESCRIBE `contents_modules` | | 3 | 3 | 1 | maybe slow |
| DESCRIBE `galleries` | | 8 | 8 | 1 | maybe slow |
| DESCRIBE `albums` | | 5 | 5 | 1 | maybe slow |
| DESCRIBE `photos` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `chronicles` | | 8 | 8 | 1 | maybe slow |
| DESCRIBE `news` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `modules_galleries` | | 4 | 4 | 1 | maybe slow |
| DESCRIBE `modules_chronicles` | | 4 | 4 | 1 | maybe slow |
| DESCRIBE `comments` | | 8 | 8 | 1 | maybe slow |
| DESCRIBE `groups` | | 6 | 6 | 1 | maybe slow |
| DESCRIBE `cake_plugins` | | 5 | 5 | 1 | maybe slow |
| DESCRIBE `collections` | | 6 | 6 | 1 | maybe slow |
| DESCRIBE `settings` | | 13 | 13 | 1 | maybe slow |
| DESCRIBE `languages` | | 5 | 5 | 1 | maybe slow |
| DESCRIBE `stats_enters` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `groups_rights` | | 3 | 3 | 1 | maybe slow |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`suffix`, `Setting`.`active`, `Setting`.`contact_email`, `Setting`.`mail_port`, `Setting`.`mail_timeout`, `Setting`.`mail_host`, `Setting`.`mail_username`, `Setting`.`mail_password`, `Setting`.`mail_from`, `Setting`.`mail_mail`, `Setting`.`restore_contents_id` FROM `settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Group`.`id`, `Group`.`title`, `Group`.`register_contents_id`, `Group`.`active_default`, `Group`.`email_activation`, `Group`.`edit_contents_id` FROM `groups` AS `Group` WHERE `Group`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Language`.`id`, `Language`.`title`, `Language`.`url`, `Language`.`shorttitle`, `Language`.`hidden` FROM `languages` AS `Language` WHERE 1 = 1 | | 2 | 2 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Language`.`id`, `Language`.`title`, `Language`.`url`, `Language`.`shorttitle`, `Language`.`hidden` FROM `languages` AS `Language` WHERE `hidden` = 0 | | 2 | 2 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `StatsEnter`.`id`, `StatsEnter`.`address`, `StatsEnter`.`host`, `StatsEnter`.`referer`, `StatsEnter`.`date`, `StatsEnter`.`ip`, `StatsEnter`.`browser`, `StatsEnter`.`referer_domain`, `StatsEnter`.`google_keywords` FROM `stats_enters` AS `StatsEnter` WHERE `StatsEnter`.`host` = '38.107.179.211' AND `StatsEnter`.`date` > '2012-02-22 12:35:02' LIMIT 1 | | 1 | 1 | 21 | maybe slow |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Content`.`id`, `Content`.`users_id`, `Content`.`title`, `Content`.`description`, `Content`.`start_site`, `Content`.`languages_id`, `Content`.`layout_file`, `Content`.`hide_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`comments`, `Content`.`comments_active`, `Content`.`access_restriction`, `Content`.`name` FROM `contents` AS `Content` WHERE `Content`.`id` = 50 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Module`.`id`, `Module`.`place`, `Module`.`title`, `Module`.`priority`, `Module`.`is_global`, `Module`.`description`, `Module`.`visible`, `Module`.`languages_id`, `Module`.`access_restriction`, `ContentsModule`.`id`, `ContentsModule`.`modules_id`, `ContentsModule`.`contents_id` FROM `modules` AS `Module` JOIN `contents_modules` AS `ContentsModule` ON (`ContentsModule`.`contents_id` = 50 AND `ContentsModule`.`modules_id` = `Module`.`id`) | | 1 | 1 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Group`.`id`, `Group`.`title`, `Group`.`register_contents_id`, `Group`.`active_default`, `Group`.`email_activation`, `Group`.`edit_contents_id` FROM `groups` AS `Group` WHERE `Group`.`register_contents_id` = 50 LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Group`.`id`, `Group`.`title`, `Group`.`register_contents_id`, `Group`.`active_default`, `Group`.`email_activation`, `Group`.`edit_contents_id` FROM `groups` AS `Group` WHERE `Group`.`edit_contents_id` = 50 LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `CakePlugin`.`id`, `CakePlugin`.`contents_id`, `CakePlugin`.`title`, `CakePlugin`.`controller`, `CakePlugin`.`action` FROM `cake_plugins` AS `CakePlugin` WHERE `CakePlugin`.`contents_id` = 50 LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`contents_id`, `Gallery`.`title`, `Gallery`.`languages_id`, `Gallery`.`gallery_type`, `Gallery`.`full_size`, `Gallery`.`thumb_size`, `Gallery`.`alias_id`, `Content`.`id`, `Content`.`users_id`, `Content`.`title`, `Content`.`description`, `Content`.`start_site`, `Content`.`languages_id`, `Content`.`layout_file`, `Content`.`hide_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`comments`, `Content`.`comments_active`, `Content`.`access_restriction`, `Content`.`name` FROM `galleries` AS `Gallery` LEFT JOIN `contents` AS `Content` ON (`Gallery`.`contents_id` = `Content`.`id`) WHERE `Gallery`.`contents_id` = 50 LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Chronicle`.`id`, `Chronicle`.`contents_id`, `Chronicle`.`title`, `Chronicle`.`languages_id`, `Chronicle`.`chronicles_type`, `Chronicle`.`date_visible`, `Chronicle`.`full_size`, `Chronicle`.`thumb_size`, `Content`.`id`, `Content`.`users_id`, `Content`.`title`, `Content`.`description`, `Content`.`start_site`, `Content`.`languages_id`, `Content`.`layout_file`, `Content`.`hide_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`comments`, `Content`.`comments_active`, `Content`.`access_restriction`, `Content`.`name` FROM `chronicles` AS `Chronicle` LEFT JOIN `contents` AS `Content` ON (`Chronicle`.`contents_id` = `Content`.`id`) WHERE `Chronicle`.`contents_id` = 50 LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Collection`.`id`, `Collection`.`contents_id`, `Collection`.`title`, `Collection`.`languages_id`, `Collection`.`full_size`, `Collection`.`thumb_size` FROM `collections` AS `Collection` WHERE `Collection`.`contents_id` = 50 LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Module`.`id`, `Module`.`place`, `Module`.`title`, `Module`.`priority`, `Module`.`is_global`, `Module`.`description`, `Module`.`visible`, `Module`.`languages_id`, `Module`.`access_restriction` FROM `modules` AS `Module` WHERE `Module`.`is_global` = 1 AND `Module`.`visible` = 0 AND `Module`.`languages_id` = 1 ORDER BY `Module`.`priority` asc | | 5 | 5 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`modules_id`, `Menu`.`title`, `Menu`.`html_before`, `Menu`.`html_after`, `Menu`.`languages_id` FROM `menus` AS `Menu` WHERE `Menu`.`modules_id` IN (2, 3, 31, 1, 39) | | 1 | 1 | 0 | |
| SELECT `MenusItem`.`id`, `MenusItem`.`menus_id`, `MenusItem`.`item_id`, `MenusItem`.`item_type`, `MenusItem`.`title`, `MenusItem`.`item_url`, `MenusItem`.`html_before`, `MenusItem`.`html_after`, `MenusItem`.`priority`, `MenusItem`.`lft`, `MenusItem`.`rght`, `MenusItem`.`parent_id`, `MenusItem`.`url`, `MenusItem`.`url2`, `MenusItem`.`url3` FROM `menus_items` AS `MenusItem` WHERE `MenusItem`.`menus_id` = (1) ORDER BY `MenusItem`.`lft` asc | | 4 | 4 | 0 | |
| SELECT `ModulesLanguage`.`id`, `ModulesLanguage`.`modules_id` FROM `modules_languages` AS `ModulesLanguage` WHERE `ModulesLanguage`.`modules_id` IN (2, 3, 31, 1, 39) | | 1 | 1 | 0 | |
| SELECT `ModulesLogin`.`id`, `ModulesLogin`.`modules_id`, `ModulesLogin`.`redirect_contents_id` FROM `modules_logins` AS `ModulesLogin` WHERE `ModulesLogin`.`modules_id` IN (2, 3, 31, 1, 39) | | 0 | 0 | 0 | |
| SELECT `ModulesRight`.`id`, `ModulesRight`.`groups_id`, `ModulesRight`.`modules_id` FROM `modules_rights` AS `ModulesRight` WHERE `ModulesRight`.`modules_id` IN (2, 3, 31, 1, 39) | | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`contents_id`, `Gallery`.`title`, `Gallery`.`languages_id`, `Gallery`.`gallery_type`, `Gallery`.`full_size`, `Gallery`.`thumb_size`, `Gallery`.`alias_id`, `ModulesGallery`.`id`, `ModulesGallery`.`galleries_id`, `ModulesGallery`.`modules_id`, `ModulesGallery`.`plugin_type` FROM `galleries` AS `Gallery` JOIN `modules_galleries` AS `ModulesGallery` ON (`ModulesGallery`.`modules_id` IN (2, 3, 31, 1, 39) AND `ModulesGallery`.`galleries_id` = `Gallery`.`id`) | | 0 | 0 | 0 | |
| SELECT `Chronicle`.`id`, `Chronicle`.`contents_id`, `Chronicle`.`title`, `Chronicle`.`languages_id`, `Chronicle`.`chronicles_type`, `Chronicle`.`date_visible`, `Chronicle`.`full_size`, `Chronicle`.`thumb_size`, `ModulesChronicle`.`id`, `ModulesChronicle`.`modules_id`, `ModulesChronicle`.`chronicles_id`, `ModulesChronicle`.`plugin_type` FROM `chronicles` AS `Chronicle` JOIN `modules_chronicles` AS `ModulesChronicle` ON (`ModulesChronicle`.`modules_id` IN (2, 3, 31, 1, 39) AND `ModulesChronicle`.`chronicles_id` = `Chronicle`.`id`) | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Content`.`id`, `Content`.`users_id`, `Content`.`title`, `Content`.`description`, `Content`.`start_site`, `Content`.`languages_id`, `Content`.`layout_file`, `Content`.`hide_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`comments`, `Content`.`comments_active`, `Content`.`access_restriction`, `Content`.`name` FROM `contents` AS `Content` WHERE `Content`.`id` = 50 AND `Content`.`languages_id` = 1 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Module`.`id`, `Module`.`place`, `Module`.`title`, `Module`.`priority`, `Module`.`is_global`, `Module`.`description`, `Module`.`visible`, `Module`.`languages_id`, `Module`.`access_restriction`, `ContentsModule`.`id`, `ContentsModule`.`modules_id`, `ContentsModule`.`contents_id` FROM `modules` AS `Module` JOIN `contents_modules` AS `ContentsModule` ON (`ContentsModule`.`contents_id` = 50 AND `ContentsModule`.`modules_id` = `Module`.`id`) ORDER BY `Module`.`priority` asc | | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`modules_id`, `Menu`.`title`, `Menu`.`html_before`, `Menu`.`html_after`, `Menu`.`languages_id` FROM `menus` AS `Menu` WHERE `Menu`.`modules_id` = (29) | | 1 | 1 | 0 | |
| SELECT `MenusItem`.`id`, `MenusItem`.`menus_id`, `MenusItem`.`item_id`, `MenusItem`.`item_type`, `MenusItem`.`title`, `MenusItem`.`item_url`, `MenusItem`.`html_before`, `MenusItem`.`html_after`, `MenusItem`.`priority`, `MenusItem`.`lft`, `MenusItem`.`rght`, `MenusItem`.`parent_id`, `MenusItem`.`url`, `MenusItem`.`url2`, `MenusItem`.`url3` FROM `menus_items` AS `MenusItem` WHERE `MenusItem`.`menus_id` = (14) ORDER BY `MenusItem`.`lft` asc | | 7 | 7 | 0 | |
| SELECT `ModulesLanguage`.`id`, `ModulesLanguage`.`modules_id` FROM `modules_languages` AS `ModulesLanguage` WHERE `ModulesLanguage`.`modules_id` = (29) | | 0 | 0 | 0 | |
| SELECT `ModulesLogin`.`id`, `ModulesLogin`.`modules_id`, `ModulesLogin`.`redirect_contents_id` FROM `modules_logins` AS `ModulesLogin` WHERE `ModulesLogin`.`modules_id` = (29) | | 0 | 0 | 0 | |
| SELECT `ModulesRight`.`id`, `ModulesRight`.`groups_id`, `ModulesRight`.`modules_id` FROM `modules_rights` AS `ModulesRight` WHERE `ModulesRight`.`modules_id` = (29) | | 0 | 0 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`contents_id`, `Gallery`.`title`, `Gallery`.`languages_id`, `Gallery`.`gallery_type`, `Gallery`.`full_size`, `Gallery`.`thumb_size`, `Gallery`.`alias_id`, `ModulesGallery`.`id`, `ModulesGallery`.`galleries_id`, `ModulesGallery`.`modules_id`, `ModulesGallery`.`plugin_type` FROM `galleries` AS `Gallery` JOIN `modules_galleries` AS `ModulesGallery` ON (`ModulesGallery`.`modules_id` = 29 AND `ModulesGallery`.`galleries_id` = `Gallery`.`id`) | | 0 | 0 | 0 | |
| SELECT `Chronicle`.`id`, `Chronicle`.`contents_id`, `Chronicle`.`title`, `Chronicle`.`languages_id`, `Chronicle`.`chronicles_type`, `Chronicle`.`date_visible`, `Chronicle`.`full_size`, `Chronicle`.`thumb_size`, `ModulesChronicle`.`id`, `ModulesChronicle`.`modules_id`, `ModulesChronicle`.`chronicles_id`, `ModulesChronicle`.`plugin_type` FROM `chronicles` AS `Chronicle` JOIN `modules_chronicles` AS `ModulesChronicle` ON (`ModulesChronicle`.`modules_id` = 29 AND `ModulesChronicle`.`chronicles_id` = `Chronicle`.`id`) | | 0 | 0 | 0 | |