Showing posts created in December 2014, Show all

(default) 3 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Advertiser`.`id`, `Advertiser`.`title`, `Advertiser`.`description`, `Advertiser`.`link`, `Advertiser`.`button_title`, `Advertiser`.`logo`, `Advertiser`.`logo_blob`, `Advertiser`.`status`, `Advertiser`.`created`, `Advertiser`.`modified` FROM `1337iot`.`advertisers` AS `Advertiser` WHERE `status` = 1 ORDER BY rand() ASC LIMIT 1001
2SELECT `BlogPost`.`id`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`published`, `BlogPost`.`sticky`, `BlogPost`.`in_rss`, `BlogPost`.`meta_title`, `BlogPost`.`meta_description`, `BlogPost`.`meta_keywords`, `BlogPost`.`created`, `BlogPost`.`modified` FROM `1337iot`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`published` = '1' AND DATE_FORMAT(`BlogPost`.`created`, '%Y%m') = '201412' ORDER BY `BlogPost`.`sticky` desc, `BlogPost`.`created` desc LIMIT 10110
3SELECT COUNT(*) AS `count` FROM `1337iot`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`published` = '1' AND DATE_FORMAT(`BlogPost`.`created`, '%Y%m') = '201412'110