Showing posts tagged with: Software, Show all

(default) 4 queries took 2 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 `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` FROM `1337iot`.`blog_post_tags` AS `BlogPostTag` WHERE `BlogPostTag`.`slug` = 'softwre' LIMIT 1110
3SELECT `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` INNER JOIN `1337iot`.`blog_post_tags_blog_posts` AS `BlogPostTagsBlogPost` ON (`BlogPost`.`id` = `BlogPostTagsBlogPost`.`blog_post_id`) INNER JOIN `1337iot`.`blog_post_tags` AS `BlogPostTag` ON (`BlogPostTagsBlogPost`.`blog_post_tag_id` = `BlogPostTag`.`id`) WHERE ((`BlogPost`.`published` = '1') AND (`BlogPostTagsBlogPost`.`blog_post_tag_id` = 5)) AND `BlogPost`.`published` = '1' GROUP BY `BlogPost`.`id` ORDER BY `BlogPost`.`sticky` desc, `BlogPost`.`created` desc LIMIT 10111
4SELECT COUNT(DISTINCT BlogPost.id) FROM `1337iot`.`blog_posts` AS `BlogPost` INNER JOIN `1337iot`.`blog_post_tags_blog_posts` AS `BlogPostTagsBlogPost` ON (`BlogPost`.`id` = `BlogPostTagsBlogPost`.`blog_post_id`) INNER JOIN `1337iot`.`blog_post_tags` AS `BlogPostTag` ON (`BlogPostTagsBlogPost`.`blog_post_tag_id` = `BlogPostTag`.`id`) WHERE ((`BlogPost`.`published` = '1') AND (`BlogPostTagsBlogPost`.`blog_post_tag_id` = 5)) AND `BlogPost`.`published` = '1' ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`created` DESC LIMIT 10110