1 | SELECT `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 1 | | 0 | 0 | 1 |
2 | SELECT `BlogSetting`.`setting`, `BlogSetting`.`value` FROM `1337iot`.`blog_settings` AS `BlogSetting` WHERE 1 = 1 | | 18 | 18 | 0 |
3 | SELECT `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`.`slug` = 'introducing-the-1337-blog' | | 1 | 1 | 0 |
4 | SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`parent_id`, `BlogPostCategory`.`lft`, `BlogPostCategory`.`rght`, `BlogPostCategory`.`name`, `BlogPostCategory`.`slug`, `BlogPostCategory`.`meta_title`, `BlogPostCategory`.`meta_description`, `BlogPostCategory`.`meta_keywords`, `BlogPostCategory`.`rss_channel_title`, `BlogPostCategory`.`rss_channel_description`, `BlogPostCategory`.`blog_post_count`, `BlogPostCategory`.`under_blog_post_count`, `BlogPostCategory`.`created`, `BlogPostCategory`.`modified`, `BlogPostCategoriesBlogPost`.`blog_post_category_id`, `BlogPostCategoriesBlogPost`.`blog_post_id` FROM `1337iot`.`blog_post_categories` AS `BlogPostCategory` JOIN `1337iot`.`blog_post_categories_blog_posts` AS `BlogPostCategoriesBlogPost` ON (`BlogPostCategoriesBlogPost`.`blog_post_id` = 11 AND `BlogPostCategoriesBlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) | | 1 | 1 | 0 |
5 | SELECT `BlogPostTag`.`id`, `BlogPostTag`.`name`, `BlogPostTag`.`slug`, `BlogPostTag`.`meta_title`, `BlogPostTag`.`meta_description`, `BlogPostTag`.`meta_keywords`, `BlogPostTag`.`rss_channel_title`, `BlogPostTag`.`rss_channel_description`, `BlogPostTag`.`blog_post_count`, `BlogPostTag`.`created`, `BlogPostTag`.`modified`, `BlogPostTagsBlogPost`.`blog_post_tag_id`, `BlogPostTagsBlogPost`.`blog_post_id` FROM `1337iot`.`blog_post_tags` AS `BlogPostTag` JOIN `1337iot`.`blog_post_tags_blog_posts` AS `BlogPostTagsBlogPost` ON (`BlogPostTagsBlogPost`.`blog_post_id` = 11 AND `BlogPostTagsBlogPost`.`blog_post_tag_id` = `BlogPostTag`.`id`) | | 1 | 1 | 0 |
6 | SELECT YEAR(`BlogPost`.`created`) AS `year`, DATE_FORMAT(BlogPost.created, '%m') AS `month`, MONTHNAME(`BlogPost`.`created`) AS `monthname`, COUNT(*) AS `count` FROM `1337iot`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`published` = '1' GROUP BY DATE_FORMAT(`BlogPost`.`created`, '%Y%m') ORDER BY `BlogPost`.`created` DESC | | 4 | 4 | 0 |
7 | SELECT `BlogPostTag`.`id`, `BlogPostTag`.`name`, `BlogPostTag`.`slug`, `BlogPostTag`.`blog_post_count` FROM `1337iot`.`blog_post_tags` AS `BlogPostTag` WHERE `BlogPostTag`.`blog_post_count` > 0 ORDER BY RAND() ASC | | 4 | 4 | 0 |
8 | SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`parent_id`, `BlogPostCategory`.`name`, `BlogPostCategory`.`under_blog_post_count`, `BlogPostCategory`.`slug` FROM `1337iot`.`blog_post_categories` AS `BlogPostCategory` WHERE `under_blog_post_count` > 0 | | 3 | 3 | 0 |