| 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 `Spotlight`.`id`, `Spotlight`.`working_title`, `Spotlight`.`image_id`, `Spotlight`.`sort_order`, `Spotlight`.`created`, `Spotlight`.`modified`, `Spotlight`.`title`, `Spotlight`.`caption`, `Spotlight`.`link`, `Spotlight`.`online`, `Image`.`id`, `Image`.`name`, `Image`.`extension`, `Image`.`filename`, `Image`.`mimetype`, `Image`.`md5`, `Image`.`type`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`protected`, `Image`.`old_media_id`, `Image`.`created`, `Image`.`modified`, `Image`.`title`, `Image`.`online` FROM `db13262`.`en_spotlights` AS `Spotlight` LEFT JOIN `db13262`.`en_attachments` AS `Image` ON (`Spotlight`.`image_id` = `Image`.`id`) WHERE 1 = 1 ORDER BY `Spotlight`.`sort_order` ASC | 2 | 2 | 0 | |
| SELECT `Event`.`id`, `Event`.`working_title`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`from`, `Event`.`to`, `Event`.`where`, `Event`.`languages`, `Event`.`fees`, `Event`.`organiser`, `Event`.`partnership`, `Event`.`website`, `Event`.`eclan_involvement`, `Event`.`type`, `Event`.`annual_conference`, `Event`.`podcasts`, `Event`.`contact_person`, `Event`.`approved`, `Event`.`old_id`, `Event`.`created`, `Event`.`modified`, `Event`.`title`, `Event`.`description`, `Event`.`slug`, `Event`.`online` FROM `db13262`.`en_events` AS `Event` WHERE `Event`.`start_date` >= '2025-12-09' ORDER BY `Event`.`start_date` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `NewsItem`.`id`, `NewsItem`.`working_title`, `NewsItem`.`publish_date`, `NewsItem`.`launch_time`, `NewsItem`.`image_id`, `NewsItem`.`contact_person`, `NewsItem`.`approved`, `NewsItem`.`created`, `NewsItem`.`modified`, `NewsItem`.`title`, `NewsItem`.`teaser`, `NewsItem`.`body`, `NewsItem`.`slug`, `NewsItem`.`online`, (CONCAT(UNIX_TIMESTAMP(`NewsItem`.`publish_date`), `NewsItem`.`id`)) AS `NewsItem__unixdate_id`, (YEAR(`NewsItem`.`publish_date`)) AS `NewsItem__year`, (MONTH(`NewsItem`.`publish_date`)) AS `NewsItem__month`, `Image`.`id`, `Image`.`name`, `Image`.`extension`, `Image`.`filename`, `Image`.`mimetype`, `Image`.`md5`, `Image`.`type`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`protected`, `Image`.`old_media_id`, `Image`.`created`, `Image`.`modified`, `Image`.`title`, `Image`.`online` FROM `db13262`.`en_news_items` AS `NewsItem` LEFT JOIN `db13262`.`en_attachments` AS `Image` ON (`NewsItem`.`image_id` = `Image`.`id`) WHERE `NewsItem`.`approved` = 1 ORDER BY `NewsItem`.`publish_date` desc, `NewsItem`.`launch_time` desc, `NewsItem`.`id` desc LIMIT 1 | 1 | 1 | 1 | |
| 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' ORDER BY `EuLegislatoryDocument`.`issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `EuCaseLawDocument`.`id`, `EuCaseLawDocument`.`created`, `EuCaseLawDocument`.`modified`, `EuCaseLawDocument`.`title`, `EuCaseLawDocument`.`description`, `EuCaseLawDocument`.`case_number`, `EuCaseLawDocument`.`party_name`, `EuCaseLawDocument`.`judgement_date`, `EuCaseLawDocument`.`court`, `EuCaseLawDocument`.`link`, `EuCaseLawDocument`.`keywords`, `EuCaseLawDocument`.`slug`, `EuCaseLawDocument`.`approved`, `EuCaseLawDocument`.`online`, `EuCaseLawDocument`.`old_id`, (CASE WHEN `EuCaseLawDocument`.`approved` = 1 and `EuCaseLawDocument`.`online` = 1 THEN 1 ELSE 0 END) AS `EuCaseLawDocument__approved_online` FROM `db13262`.`eu_case_law_documents` AS `EuCaseLawDocument` WHERE `EuCaseLawDocument`.`approved` = '1' AND `EuCaseLawDocument`.`online` = '1' ORDER BY `EuCaseLawDocument`.`judgement_date` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Publication`.`id`, `Publication`.`created`, `Publication`.`modified`, `Publication`.`publication_date`, `Publication`.`first_name`, `Publication`.`last_name`, `Publication`.`occupation`, `Publication`.`institution`, `Publication`.`address`, `Publication`.`postal_code`, `Publication`.`country`, `Publication`.`telephone`, `Publication`.`fax`, `Publication`.`email`, `Publication`.`title`, `Publication`.`author`, `Publication`.`co_author`, `Publication`.`publication_type`, `Publication`.`journal_publisher`, `Publication`.`pages`, `Publication`.`abstract`, `Publication`.`languages`, `Publication`.`keywords`, `Publication`.`slug`, `Publication`.`attachment_id`, `Publication`.`approved`, `Publication`.`online`, `Publication`.`old_id`, (CONCAT(`Publication`.`first_name`, " ", `Publication`.`last_name`)) AS `Publication__full_name`, (CASE WHEN `Publication`.`approved` = 1 and `Publication`.`online` = 1 THEN 1 ELSE 0 END) AS `Publication__approved_online` FROM `db13262`.`publications` AS `Publication` WHERE `Publication`.`approved` = '1' AND `Publication`.`online` = '1' ORDER BY `Publication`.`publication_date` desc 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` = 12 LIMIT 1 | 1 | 1 | 0 | |