| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Menu`.`id`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`name`, `Menu`.`description` FROM `db13262`.`menus` AS `Menu` WHERE `Menu`.`name` = 'main' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MenuLink`.`id`, `MenuLink`.`menu_id`, `MenuLink`.`parent_id`, `MenuLink`.`working_title`, `MenuLink`.`resource_link`, `MenuLink`.`order`, `MenuLink`.`html_id`, `MenuLink`.`html_class`, `MenuLink`.`html_target`, `MenuLink`.`created`, `MenuLink`.`modified`, `MenuLink`.`name`, `MenuLink`.`description`, `MenuLink`.`link`, `MenuLink`.`meta_title`, `MenuLink`.`meta_description`, `MenuLink`.`online`, ((SELECT name FROM menus WHERE `menus`.`id` = `MenuLink`.`menu_id`)) AS `MenuLink__menu_name` FROM `db13262`.`en_menu_links` AS `MenuLink` WHERE `MenuLink`.`menu_id` = (1) ORDER BY `MenuLink`.`order` ASC | 25 | 25 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 5 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 14 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 3 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 6 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 10 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 15 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 11 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`name`, `Menu`.`description` FROM `db13262`.`menus` AS `Menu` WHERE `Menu`.`name` = 'footer' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MenuLink`.`id`, `MenuLink`.`menu_id`, `MenuLink`.`parent_id`, `MenuLink`.`working_title`, `MenuLink`.`resource_link`, `MenuLink`.`order`, `MenuLink`.`html_id`, `MenuLink`.`html_class`, `MenuLink`.`html_target`, `MenuLink`.`created`, `MenuLink`.`modified`, `MenuLink`.`name`, `MenuLink`.`description`, `MenuLink`.`link`, `MenuLink`.`meta_title`, `MenuLink`.`meta_description`, `MenuLink`.`online`, ((SELECT name FROM menus WHERE `menus`.`id` = `MenuLink`.`menu_id`)) AS `MenuLink__menu_name` FROM `db13262`.`en_menu_links` AS `MenuLink` WHERE `MenuLink`.`menu_id` = (2) ORDER BY `MenuLink`.`order` ASC | 5 | 5 | 0 | |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`name`, `Menu`.`description` FROM `db13262`.`menus` AS `Menu` WHERE `Menu`.`name` = 'main' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MenuLink`.`id`, `MenuLink`.`menu_id`, `MenuLink`.`parent_id`, `MenuLink`.`working_title`, `MenuLink`.`resource_link`, `MenuLink`.`order`, `MenuLink`.`html_id`, `MenuLink`.`html_class`, `MenuLink`.`html_target`, `MenuLink`.`created`, `MenuLink`.`modified`, `MenuLink`.`name`, `MenuLink`.`description`, `MenuLink`.`link`, `MenuLink`.`meta_title`, `MenuLink`.`meta_description`, `MenuLink`.`online`, ((SELECT name FROM menus WHERE `menus`.`id` = `MenuLink`.`menu_id`)) AS `MenuLink__menu_name` FROM `db13262`.`en_menu_links` AS `MenuLink` WHERE `MenuLink`.`menu_id` = (1) ORDER BY `MenuLink`.`order` ASC | 25 | 25 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`name`, `Menu`.`description` FROM `db13262`.`menus` AS `Menu` WHERE `Menu`.`name` = 'footer' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MenuLink`.`id`, `MenuLink`.`menu_id`, `MenuLink`.`parent_id`, `MenuLink`.`working_title`, `MenuLink`.`resource_link`, `MenuLink`.`order`, `MenuLink`.`html_id`, `MenuLink`.`html_class`, `MenuLink`.`html_target`, `MenuLink`.`created`, `MenuLink`.`modified`, `MenuLink`.`name`, `MenuLink`.`description`, `MenuLink`.`link`, `MenuLink`.`meta_title`, `MenuLink`.`meta_description`, `MenuLink`.`online`, ((SELECT name FROM menus WHERE `menus`.`id` = `MenuLink`.`menu_id`)) AS `MenuLink__menu_name` FROM `db13262`.`en_menu_links` AS `MenuLink` WHERE `MenuLink`.`menu_id` = (2) ORDER BY `MenuLink`.`order` ASC | 5 | 5 | 0 | |
| SELECT `Newsletter`.`id`, `Newsletter`.`working_title`, `Newsletter`.`publish_date`, `Newsletter`.`launch_time`, `Newsletter`.`document_id`, `Newsletter`.`created`, `Newsletter`.`modified`, `Newsletter`.`title`, `Newsletter`.`description`, `Newsletter`.`slug`, `Newsletter`.`online`, (CONCAT(UNIX_TIMESTAMP(`Newsletter`.`publish_date`), `Newsletter`.`id`)) AS `Newsletter__unixdate_id`, `Document`.`id`, `Document`.`name`, `Document`.`extension`, `Document`.`filename`, `Document`.`mimetype`, `Document`.`md5`, `Document`.`type`, `Document`.`size`, `Document`.`width`, `Document`.`height`, `Document`.`protected`, `Document`.`old_media_id`, `Document`.`created`, `Document`.`modified`, `Document`.`title`, `Document`.`online` FROM `db13262`.`en_newsletters` AS `Newsletter` LEFT JOIN `db13262`.`en_attachments` AS `Document` ON (`Newsletter`.`document_id` = `Document`.`id`) WHERE 1 = 1 ORDER BY `Newsletter`.`publish_date` desc, `Newsletter`.`launch_time` desc, `Newsletter`.`id` desc LIMIT 8, 8 | 8 | 8 | 17 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `db13262`.`en_newsletters` AS `Newsletter` LEFT JOIN `db13262`.`en_attachments` AS `Document` ON (`Newsletter`.`document_id` = `Document`.`id`) WHERE 1 = 1 | 1 | 1 | 11 | maybe slow |
| SELECT `Page`.`id`, `Page`.`working_title`, `Page`.`show_attachments`, `Page`.`videos`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`intro`, `Page`.`body`, `Page`.`slug`, `Page`.`design`, `Page`.`online` FROM `db13262`.`en_pages` AS `Page` WHERE `id` = 12 LIMIT 1 | 1 | 1 | 0 | |