News

HVAC Latest News and Updates

May 25, 2023 08:12 a.m.

What does SEER2 Mean?

The Department of Energy (DOE) is changing the way HVAC...

Total: 1 / Current Page: 1 of 1

Debug General Params (6) Warnings (0) Errors (0) SQL Queries (10)

Total execution time: 0.004977 sec.
Framework 1.25 v5.80
Memory Usage 5.31MB
POST:

Array
(
)

GET:

Array
(
)

Array
(
    [before] => Closure Object
        (
        )

    [segment] => Array
        (
            [0] => blog
            [1] => category
            [2] => department-of-energy
        )

    [route] => /blog/category/department-of-energy
    [Bootstrap::Autoloader[1]] => registered path "autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/modules_/blog/
    [Bootstrap::Autoloader[2]] => autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/modules_/blog/Blog.class.php
    [template] => front/themes/laguna/mod_index.tpl.php
)

1. select | total: 1
SELECT * FROM `settings` WHERE id = 1 ;

2. select | total: 1
SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "blog" LIMIT 1;

3. select | total: 16
SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;

4. select | total: 1
SELECT * FROM `mod_blog_categories` WHERE slug_en = "department-of-energy" LIMIT 1;

5. count | total: 1
SELECT COUNT(a.id) FROM `mod_blog` AS a INNER JOIN `mod_blog_related_categories` AS rc ON a.id = rc.item_id WHERE rc.category_id = 23 AND a.active = 1 LIMIT 1;

6. SELECT | total: 1
SELECT a.id, a.created, a.title_en AS title, a.slug_en AS slug, a.body_en AS body, a.thumb, a.rating, a.membership_id, c.slug_en AS cslug, c.name_en AS ctitle, GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = a.id AND section = 'blog') as comments FROM `mod_blog` AS a LEFT JOIN `mod_blog_categories` AS c ON c.id = a.category_id INNER JOIN `mod_blog_related_categories` AS rc ON a.id = rc.item_id LEFT JOIN `memberships` AS m ON FIND_IN_SET(m.id, a.membership_id) WHERE rc.category_id = 23 AND a.active = 1 AND c.active = 1 GROUP BY a.id ORDER BY created DESC LIMIT 0,10

7. SELECT | total: 0
SELECT p.id, l.plug_id, l.space, l.place, p.system, p.alt_class, p.plugalias, p.plugin_id, p.title_en as title, p.body_en as body, p.jscode, p.show_title, p.cplugin FROM `layout` AS l LEFT JOIN plugins AS p ON p.id = l.plug_id WHERE l.modalias = "blog" AND p.active = 1 ORDER BY l.sorting;

8. SELECT | total: 1
SELECT YEAR(created) AS year, DATE_FORMAT(created, '%m') AS month, COUNT(id) AS total FROM `mod_blog` WHERE active = 1 AND created <= DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY year, month ORDER BY year DESC, month DESC;

9. SELECT | total: 3
SELECT title_en AS title, slug_en AS slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5;

10. SELECT | total: 0
SELECT c.body, a.title_en AS title, a.slug_en AS slug, c.created FROM `mod_comments` AS c LEFT JOIN `mod_blog` AS a ON a.id = c.parent_id WHERE c.section = "blog" AND c.active = 1 AND a.active = 1 ORDER BY c.created DESC LIMIT 5;

1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;

2. select | total: 1 . SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "blog" LIMIT 1;

3. select | total: 16 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;

4. select | total: 1 . SELECT * FROM `mod_blog_categories` WHERE slug_en = "department-of-energy" LIMIT 1;

5. count | total: 1 . 
			  SELECT 
				COUNT(a.id) 
			  FROM
				`mod_blog` AS a 
				INNER JOIN `mod_blog_related_categories` AS rc 
				  ON a.id = rc.item_id 
			  WHERE rc.category_id = 23 
				AND a.active = 1 
			  LIMIT 1;

6. SELECT | total: 1 . SELECT 
				a.id,
				a.created,
				a.title_en AS title,
				a.slug_en AS slug,
				a.body_en AS body,
				a.thumb,
				a.rating,
				a.membership_id,
				c.slug_en AS cslug,
				c.name_en AS ctitle,
				GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships,
				(SELECT 
				  COUNT(parent_id) 
				FROM
				  `mod_comments`
				WHERE `mod_comments`.parent_id = a.id 
				  AND section = 'blog') as comments
			  FROM
				`mod_blog` AS a
				LEFT JOIN `mod_blog_categories` AS c
				  ON c.id = a.category_id
				INNER JOIN `mod_blog_related_categories` AS rc 
				  ON a.id = rc.item_id
				LEFT JOIN `memberships` AS m 
				  ON FIND_IN_SET(m.id, a.membership_id)
			  WHERE rc.category_id = 23
			  AND a.active = 1 
			  AND c.active = 1  
			  GROUP BY a.id
			  ORDER BY  created DESC  LIMIT 0,10

7. SELECT | total: 0 . SELECT 
			p.id,
			l.plug_id,
			l.space,
			l.place,
			p.system,
			p.alt_class,
			p.plugalias,
			p.plugin_id,
			p.title_en as title,
			p.body_en as body,
			p.jscode,
			p.show_title,
			p.cplugin
		  FROM
			`layout` AS l
		  LEFT JOIN plugins AS p 
			ON p.id = l.plug_id 
		  WHERE l.modalias = "blog"
		  AND p.active = 1
		  ORDER BY l.sorting;

8. SELECT | total: 1 . SELECT 
			YEAR(created) AS year,
			DATE_FORMAT(created, '%m') AS month,
			COUNT(id) AS total 
		  FROM
			`mod_blog` 
		  WHERE active = 1 
			AND created <= DATE_SUB(NOW(), INTERVAL 1 MONTH)
		  GROUP BY year, month 
		  ORDER BY year DESC, month DESC;

9. SELECT | total: 3 . SELECT 
			title_en AS title,
			slug_en AS slug,
			thumb,
			created, 
			id 
		  FROM
			`mod_blog` 
		  WHERE active = 1 
		  ORDER BY hits DESC LIMIT 5;

10. SELECT | total: 0 . SELECT 
			c.body,
			a.title_en AS title,
			a.slug_en AS slug,
			c.created 
		  FROM
			`mod_comments` AS c 
			LEFT JOIN `mod_blog` AS a 
			  ON a.id = c.parent_id 
		  WHERE c.section = "blog" 
			AND c.active = 1 
			AND a.active = 1 
		  ORDER BY c.created DESC 
		  LIMIT 5;