| 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` = 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` = 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` = 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` = 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` = 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 `EuLegislatoryDocument`.`id`, `EuLegislatoryDocument`.`created`, `EuLegislatoryDocument`.`modified`, `EuLegislatoryDocument`.`title`, `EuLegislatoryDocument`.`description`, `EuLegislatoryDocument`.`type`, `EuLegislatoryDocument`.`reference_number`, `EuLegislatoryDocument`.`issue_date`, `EuLegislatoryDocument`.`official_journal`, `EuLegislatoryDocument`.`link`, `EuLegislatoryDocument`.`keywords`, `EuLegislatoryDocument`.`slug`, `EuLegislatoryDocument`.`approved`, `EuLegislatoryDocument`.`online`, `EuLegislatoryDocument`.`old_id`, (CASE WHEN `EuLegislatoryDocument`.`approved` = 1 and `EuLegislatoryDocument`.`online` = 1 THEN 1 ELSE 0 END) AS `EuLegislatoryDocument__approved_online` FROM `db13262`.`eu_legislatory_documents` AS `EuLegislatoryDocument` WHERE `EuLegislatoryDocument`.`online` = '1' AND `EuLegislatoryDocument`.`approved` = '1' ORDER BY `EuLegislatoryDocument`.`issue_date` desc LIMIT 168, 7 | 7 | 7 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `db13262`.`eu_legislatory_documents` AS `EuLegislatoryDocument` WHERE `EuLegislatoryDocument`.`online` = '1' AND `EuLegislatoryDocument`.`approved` = '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` = 12 LIMIT 1 | 1 | 1 | 0 | |