(default) 63 queries took 61 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`772
2DESCRIBE `acos`772
3DESCRIBE `aros_acos`772
4DESCRIBE `page_links`10103
5DESCRIBE `page_pages`12125
6DESCRIBE `page_templates`772
7DESCRIBE `page_subtemplates`662
8DESCRIBE `page_elements`771
9DESCRIBE `page_plugins`662
10SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`deleted` IS NULL ORDER BY `Page`.`lft` ASC 11111
11SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` IN (1, 2, 8, 9, 10, 3, 11, 4, 5, 6, 7) ORDER BY `PageLinks`.`lft` ASC 46461
12SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`slug` = 'home' AND `Page`.`deleted` IS NULL ORDER BY `Page`.`lft` ASC LIMIT 1110
13SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` = (2) ORDER BY `PageLinks`.`lft` ASC 881
14SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`parent_id` = 2 AND `Page`.`deleted` IS NULL AND `Page`.`hidden` = 0 ORDER BY `Page`.`lft` ASC 331
15SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` IN (8, 9, 10) ORDER BY `PageLinks`.`lft` ASC 441
16SELECT `PageTemplate`.`id`, `PageTemplate`.`title`, `PageTemplate`.`layout_file`, `PageTemplate`.`html`, `PageTemplate`.`preview_img`, `PageTemplate`.`created`, `PageTemplate`.`modified` FROM `page_templates` AS `PageTemplate` WHERE `PageTemplate`.`id` = 2 LIMIT 1111
17SELECT `PageLink`.`id`, `PageLink`.`parent_id`, `PageLink`.`lft`, `PageLink`.`rght`, `PageLink`.`page_id`, `PageLink`.`element_id`, `PageLink`.`subtemplate_id`, `PageLink`.`field`, `PageLink`.`created`, `PageLink`.`modified` FROM `page_links` AS `PageLink` WHERE `PageLink`.`page_id` = 2 880
18SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 1 AND `PageElement`.`deleted` IS NULL LIMIT 1111
19SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 1 LIMIT 1111
20DESCRIBE `media_rollers`10103
21DESCRIBE `media_files_rollers`771
22DESCRIBE `media_files`10101
23DESCRIBE `media_types`442
24DESCRIBE `tags`552
25DESCRIBE `media_galleries`441
26DESCRIBE `media_files_galleries`771
27DESCRIBE `media_files_tags`552
28SELECT `MediaRoller`.`id`, `MediaRoller`.`title`, `MediaRoller`.`animation`, `MediaRoller`.`type`, `MediaRoller`.`speed`, `MediaRoller`.`height`, `MediaRoller`.`width`, `MediaRoller`.`timeout`, `MediaRoller`.`created`, `MediaRoller`.`modified` FROM `media_rollers` AS `MediaRoller` WHERE `id` = 1 LIMIT 1111
29SELECT `MediaFilesRoller`.`id`, `MediaFilesRoller`.`media_id`, `MediaFilesRoller`.`media_roller_id`, `MediaFilesRoller`.`order`, `MediaFilesRoller`.`link`, `MediaFilesRoller`.`created`, `MediaFilesRoller`.`modified` FROM `media_files_rollers` AS `MediaFilesRoller` WHERE `MediaFilesRoller`.`media_roller_id` = (1) 10100
30SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified`, `MediaFilesRoller`.`id`, `MediaFilesRoller`.`media_id`, `MediaFilesRoller`.`media_roller_id`, `MediaFilesRoller`.`order`, `MediaFilesRoller`.`link`, `MediaFilesRoller`.`created`, `MediaFilesRoller`.`modified` FROM `media_files` AS `Media` JOIN `media_files_rollers` AS `MediaFilesRoller` ON (`MediaFilesRoller`.`media_roller_id` = 1 AND `MediaFilesRoller`.`media_id` = `Media`.`id`) WHERE 1 = 1 ORDER BY `MediaFilesRoller`.`order` ASC 10100
31SELECT `PageSubtemplate`.`id`, `PageSubtemplate`.`title`, `PageSubtemplate`.`preview_img`, `PageSubtemplate`.`html`, `PageSubtemplate`.`created`, `PageSubtemplate`.`modified` FROM `page_subtemplates` AS `PageSubtemplate` WHERE `PageSubtemplate`.`id` = 1 LIMIT 1110
32SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 2 AND `PageElement`.`deleted` IS NULL LIMIT 1110
33SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 3 AND `PageElement`.`deleted` IS NULL LIMIT 1111
34SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 11 LIMIT 1110
35DESCRIBE `announcement_articles`13132
36DESCRIBE `user_users`991
37DESCRIBE `user_groups`441
38SELECT COUNT(*) AS `count` FROM `announcement_articles` AS `Announcement` LEFT JOIN `user_users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Announcement`.`media_id` = `Media`.`id`) WHERE `Announcement`.`deleted` IS NULL AND `Announcement`.`start` < '2012-05-21 05:33:00' 111
39SELECT `Announcement`.`id`, `Announcement`.`title`, `Announcement`.`slug`, `Announcement`.`link`, `Announcement`.`facebox`, `Announcement`.`homepage`, `Announcement`.`body`, `Announcement`.`user_id`, `Announcement`.`media_id`, `Announcement`.`start`, `Announcement`.`deleted`, `Announcement`.`created`, `Announcement`.`modified`, `User`.`id`, `User`.`username`, `User`.`display`, `User`.`password`, `User`.`email`, `User`.`group_id`, `User`.`disabled`, `User`.`created`, `User`.`modified`, `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `announcement_articles` AS `Announcement` LEFT JOIN `user_users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Announcement`.`media_id` = `Media`.`id`) WHERE `Announcement`.`deleted` IS NULL AND `Announcement`.`start` < '2012-05-21 05:33:00' ORDER BY `Announcement`.`start` DESC LIMIT 3331
40SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 4 AND `PageElement`.`deleted` IS NULL LIMIT 1110
41SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 5 AND `PageElement`.`deleted` IS NULL LIMIT 1110
42SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 14 LIMIT 1110
43DESCRIBE `contact_contacts`771
44SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 6 AND `PageElement`.`deleted` IS NULL LIMIT 1111
45SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 29 AND `PageElement`.`deleted` IS NULL LIMIT 1111
46SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 9 LIMIT 1111
47SELECT `MediaGallery`.`id`, `MediaGallery`.`title`, `MediaGallery`.`created`, `MediaGallery`.`modified` FROM `media_galleries` AS `MediaGallery` WHERE `id` = 1 LIMIT 1111
48SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified`, `MediaFilesGallery`.`id`, `MediaFilesGallery`.`media_id`, `MediaFilesGallery`.`media_gallery_id`, `MediaFilesGallery`.`order`, `MediaFilesGallery`.`link`, `MediaFilesGallery`.`created`, `MediaFilesGallery`.`modified` FROM `media_files` AS `Media` JOIN `media_files_galleries` AS `MediaFilesGallery` ON (`MediaFilesGallery`.`media_gallery_id` = 1 AND `MediaFilesGallery`.`media_id` = `Media`.`id`) WHERE 1 = 1 ORDER BY `MediaFilesGallery`.`order` ASC 11110
49SELECT `PageTemplate`.`id`, `PageTemplate`.`title`, `PageTemplate`.`layout_file`, `PageTemplate`.`html`, `PageTemplate`.`preview_img`, `PageTemplate`.`created`, `PageTemplate`.`modified` FROM `page_templates` AS `PageTemplate` WHERE `PageTemplate`.`id` = 3 LIMIT 1111
50SELECT `PageLink`.`id`, `PageLink`.`parent_id`, `PageLink`.`lft`, `PageLink`.`rght`, `PageLink`.`page_id`, `PageLink`.`element_id`, `PageLink`.`subtemplate_id`, `PageLink`.`field`, `PageLink`.`created`, `PageLink`.`modified` FROM `page_links` AS `PageLink` WHERE `PageLink`.`page_id` = 8 111
51SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 8 AND `PageElement`.`deleted` IS NULL LIMIT 1111
52SELECT `PageTemplate`.`id`, `PageTemplate`.`title`, `PageTemplate`.`layout_file`, `PageTemplate`.`html`, `PageTemplate`.`preview_img`, `PageTemplate`.`created`, `PageTemplate`.`modified` FROM `page_templates` AS `PageTemplate` WHERE `PageTemplate`.`id` = 3 LIMIT 1110
53SELECT `PageLink`.`id`, `PageLink`.`parent_id`, `PageLink`.`lft`, `PageLink`.`rght`, `PageLink`.`page_id`, `PageLink`.`element_id`, `PageLink`.`subtemplate_id`, `PageLink`.`field`, `PageLink`.`created`, `PageLink`.`modified` FROM `page_links` AS `PageLink` WHERE `PageLink`.`page_id` = 9 221
54SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 9 AND `PageElement`.`deleted` IS NULL LIMIT 1111
55SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 7 LIMIT 1111
56SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 30 AND `PageElement`.`deleted` IS NULL LIMIT 1110
57SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 9 LIMIT 1110
58SELECT `MediaGallery`.`id`, `MediaGallery`.`title`, `MediaGallery`.`created`, `MediaGallery`.`modified` FROM `media_galleries` AS `MediaGallery` WHERE `id` = NULL LIMIT 1000
59SELECT `PageTemplate`.`id`, `PageTemplate`.`title`, `PageTemplate`.`layout_file`, `PageTemplate`.`html`, `PageTemplate`.`preview_img`, `PageTemplate`.`created`, `PageTemplate`.`modified` FROM `page_templates` AS `PageTemplate` WHERE `PageTemplate`.`id` = 3 LIMIT 1110
60SELECT `PageLink`.`id`, `PageLink`.`parent_id`, `PageLink`.`lft`, `PageLink`.`rght`, `PageLink`.`page_id`, `PageLink`.`element_id`, `PageLink`.`subtemplate_id`, `PageLink`.`field`, `PageLink`.`created`, `PageLink`.`modified` FROM `page_links` AS `PageLink` WHERE `PageLink`.`page_id` = 10 110
61SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 10 AND `PageElement`.`deleted` IS NULL LIMIT 1110
62SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`deleted` IS NULL AND `Page`.`hidden` = 0 ORDER BY `Page`.`lft` ASC 10100
63SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` IN (1, 2, 8, 9, 10, 3, 11, 4, 6, 7) ORDER BY `PageLinks`.`lft` ASC 42420