Showing posts in category: Tech News, Show all

  • Welcome to the 1337 Institute of Technology Blog

    According to Salesforce, an important part of your business' marketing strategy should be the creation of content to share with your audience on social channels. If this content is useful, your community will more than likely freely and gladly bookmark it, download it, and pass it along to others.

(default) 8 queries took 3 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 `BlogSetting`.`setting`, `BlogSetting`.`value` FROM `1337iot`.`blog_settings` AS `BlogSetting` WHERE 1 = 118180
3SELECT `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` FROM `1337iot`.`blog_post_categories` AS `BlogPostCategory` WHERE `slug` = 'tech-news' LIMIT 1110
4SELECT `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_categories_blog_posts` AS `BlogPostCategoriesBlogPost` ON (`BlogPost`.`id` = `BlogPostCategoriesBlogPost`.`blog_post_id`) INNER JOIN `1337iot`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPostCategoriesBlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) WHERE ((`BlogPost`.`published` = '1') AND (`BlogPostCategory`.`lft` BETWEEN 1 AND 2)) AND `BlogPost`.`published` = '1' GROUP BY `BlogPost`.`id` ORDER BY `BlogPost`.`sticky` desc, `BlogPost`.`created` desc LIMIT 10111
5SELECT COUNT(DISTINCT BlogPost.id) FROM `1337iot`.`blog_posts` AS `BlogPost` INNER JOIN `1337iot`.`blog_post_categories_blog_posts` AS `BlogPostCategoriesBlogPost` ON (`BlogPost`.`id` = `BlogPostCategoriesBlogPost`.`blog_post_id`) INNER JOIN `1337iot`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPostCategoriesBlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) WHERE ((`BlogPost`.`published` = '1') AND (`BlogPostCategory`.`lft` BETWEEN 1 AND 2)) AND `BlogPost`.`published` = '1' ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`created` DESC LIMIT 10111
6SELECT 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` DESC440
7SELECT `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() ASC440
8SELECT `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` > 0330