| 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 `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`.`slug` = 'conference-dedicated-to-the-100th-anniversary-of-the-university-of-latvia' AND `NewsItem`.`approved` = 1 ORDER BY `NewsItem`.`publish_date` desc, `NewsItem`.`launch_time` desc, `NewsItem`.`id` 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`, `AttachmentsNewsItem`.`id`, `AttachmentsNewsItem`.`attachment_id`, `AttachmentsNewsItem`.`news_item_id`, `AttachmentsNewsItem`.`sort` FROM `db13262`.`en_attachments` AS `Attachment` JOIN `db13262`.`attachments_news_items` AS `AttachmentsNewsItem` ON (`AttachmentsNewsItem`.`news_item_id` = 34 AND `AttachmentsNewsItem`.`attachment_id` = `Attachment`.`id`) ORDER BY `AttachmentsNewsItem`.`sort` asc | 1 | 1 | 2 | maybe slow |
| 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` FROM `db13262`.`en_news_items` AS `NewsItem` WHERE `NewsItem`.`id` != 34 AND (CONCAT(UNIX_TIMESTAMP(`NewsItem`.`publish_date`), `NewsItem`.`id`)) >= '157126320034' AND `NewsItem`.`approved` = 1 ORDER BY (CONCAT(UNIX_TIMESTAMP(`NewsItem`.`publish_date`), `NewsItem`.`id`)) asc LIMIT 1 | 0 | 0 | 1 | maybe slow |
| 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` FROM `db13262`.`en_news_items` AS `NewsItem` WHERE `NewsItem`.`id` != 34 AND (CONCAT(UNIX_TIMESTAMP(`NewsItem`.`publish_date`), `NewsItem`.`id`)) <= '157126320034' AND `NewsItem`.`approved` = 1 ORDER BY (CONCAT(UNIX_TIMESTAMP(`NewsItem`.`publish_date`), `NewsItem`.`id`)) desc LIMIT 1 | 1 | 1 | 1 | |
| SELECT MONTH(`NewsItem`.`publish_date`) AS month, YEAR(`NewsItem`.`publish_date`) AS year FROM `db13262`.`en_news_items` AS `NewsItem` WHERE `NewsItem`.`approved` = 1 GROUP BY year,month ORDER BY (YEAR(`NewsItem`.`publish_date`)) DESC, (MONTH(`NewsItem`.`publish_date`)) ASC | 22 | 22 | 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 | |