Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Partner`.`id`, `Partner`.`name`, `Partner`.`description`, `Partner`.`image`, `Partner`.`url`, `Partner`.`type`, `Partner`.`enable`, `Partner`.`created`, `Partner`.`modified` FROM `masterre_reinventdev`.`companies` AS `Partner` WHERE `enable` = '1' AND `Partner`.`type` = 1 | 3 | 3 | 0 | |
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 `Event`.`end_date` >= '2015-09-10' AND `enable` = '1' ORDER BY `Event`.`feature` DESC, `Event`.`start_date` ASC, `Event`.`end_date` ASC LIMIT 3 | 3 | 3 | 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 `News`.`type` = 3 AND `enable` = '1' ORDER BY `News`.`date` DESC LIMIT 3 | 3 | 3 | 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) AND `NewsTag`.`tag_id` = `Tag`.`id`) | 3 | 3 | 0 | |