Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Event`.`id`, `Event`.`title`, `Event`.`subtitle`, `Event`.`location`, `Event`.`venue`, `Event`.`listing_text`, `Event`.`full_text`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`image`, `Event`.`url`, `Event`.`feature`, `Event`.`enable`, `Event`.`created`, `Event`.`modified` FROM `masterre_reinventdev`.`events` AS `Event` WHERE `enable` = '1' AND `feature` = '1' ORDER BY `Event`.`start_date` ASC, `Event`.`end_date` ASC LIMIT 2 | 2 | 2 | 0 | |
SELECT `News`.`id`, `News`.`title`, `News`.`subtitle`, `News`.`publication`, `News`.`date`, `News`.`listing_text`, `News`.`full_text`, `News`.`image`, `News`.`url`, `News`.`type`, `News`.`feature`, `News`.`enable`, `News`.`created`, `News`.`modified` FROM `masterre_reinventdev`.`news` AS `News` WHERE `type` = 3 AND `enable` = '1' ORDER BY `News`.`date` DESC LIMIT 7 | 7 | 7 | 0 | |
SELECT `Tag`.`id`, `Tag`.`title`, `Tag`.`name`, `Tag`.`background_color`, `Tag`.`font_color`, `Tag`.`created`, `Tag`.`modified`, `NewsTag`.`id`, `NewsTag`.`tag_id`, `NewsTag`.`news_id`, `NewsTag`.`created`, `NewsTag`.`modified` FROM `masterre_reinventdev`.`tags` AS `Tag` JOIN `masterre_reinventdev`.`news_tags` AS `NewsTag` ON (`NewsTag`.`news_id` IN (229, 226, 227, 228, 215, 217, 216) AND `NewsTag`.`tag_id` = `Tag`.`id`) | 7 | 7 | 0 | |
SELECT `Website`.`id`, `Website`.`title`, `Website`.`listing_text`, `Website`.`image`, `Website`.`url`, `Website`.`type`, `Website`.`feature`, `Website`.`enable`, `Website`.`created`, `Website`.`modified` FROM `masterre_reinventdev`.`websites` AS `Website` WHERE `feature` = '1' AND `type` = 1 ORDER BY `feature` DESC, `modified` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Website`.`id`, `Website`.`title`, `Website`.`listing_text`, `Website`.`image`, `Website`.`url`, `Website`.`type`, `Website`.`feature`, `Website`.`enable`, `Website`.`created`, `Website`.`modified` FROM `masterre_reinventdev`.`websites` AS `Website` WHERE `feature` = '1' AND `type` = 2 ORDER BY `modified` ASC LIMIT 2 | 2 | 2 | 0 | |
SELECT `Publication`.`id`, `Publication`.`title`, `Publication`.`subtitle`, `Publication`.`listing_text`, `Publication`.`full_text`, `Publication`.`file`, `Publication`.`image`, `Publication`.`url`, `Publication`.`feature`, `Publication`.`enable`, `Publication`.`created`, `Publication`.`modified` FROM `masterre_reinventdev`.`publications` AS `Publication` WHERE `feature` = '1' AND `enable` = '1' LIMIT 4 | 2 | 2 | 0 | |