| 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`.`approved` = '1' AND `EuLegislatoryDocument`.`online` = '1' AND `EuLegislatoryDocument`.`slug` = 'regulation-of-the-european-parliament-and-of-the-council-on-the-european-union-agency-for-criminal-justice-cooperation-eurojust-and-replacing-and-repealing-council-decision-2002-187-jha' ORDER BY `EuLegislatoryDocument`.`issue_date` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`extension`, `Attachment`.`filename`, `Attachment`.`mimetype`, `Attachment`.`md5`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`width`, `Attachment`.`height`, `Attachment`.`protected`, `Attachment`.`old_media_id`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`title`, `Attachment`.`online`, `AttachmentsEuLegislatoryDocument`.`id`, `AttachmentsEuLegislatoryDocument`.`attachment_id`, `AttachmentsEuLegislatoryDocument`.`eu_legislatory_document_id`, `AttachmentsEuLegislatoryDocument`.`sort` FROM `db13262`.`en_attachments` AS `Attachment` JOIN `db13262`.`attachments_eu_legislatory_documents` AS `AttachmentsEuLegislatoryDocument` ON (`AttachmentsEuLegislatoryDocument`.`eu_legislatory_document_id` = 61 AND `AttachmentsEuLegislatoryDocument`.`attachment_id` = `Attachment`.`id`) | 1 | 1 | 3 | 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 | |