Sitemap

Total execution time: 1745621547.164 sec.

Framework 1.50 v6.20

Cpu Usage 11237 sec.

Memory Usage 2.76MB

POST:
Array
(
)

                         
GET:
Array
(
)

                         
Array
(
    [route] => sitemap
    [path] => /sitemap
    [segments] => Array
        (
            [0] => sitemap
        )

    [closure] => Array
        (
            [0] => Wojo\Controller\Front\IndexController
            [1] => sitemap
        )

    [template] => view/front/themes/master/sitemap.tpl.php
)

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

2. select | total: 1
SELECT * FROM `pages` WHERE (`page_type` = "sitemap") and (`active` = 1) ;

3. select | total: 14
SELECT title_en AS title, slug_en AS slug FROM `pages` WHERE (`page_type` = "normal") and (`active` = 1) ;

4. SELECT | total: 25
SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;

5. select | total: 1
SELECT title_en AS title, slug_en AS slug FROM `mod_blog` WHERE (`active` = 1) ORDER BY `created` DESC;

6. 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 ;

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

1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select | total: 1. SELECT * FROM `pages` WHERE (`page_type` = "sitemap") and (`active` = 1) ;
3. select | total: 14. SELECT title_en AS title, slug_en AS slug FROM `pages` WHERE (`page_type` = "normal") and (`active` = 1) ;
4. SELECT | total: 25. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
5. select | total: 1. SELECT title_en AS title, slug_en AS slug FROM `mod_blog` WHERE (`active` = 1) ORDER BY `created` DESC;
6. 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 ;
7. SELECT | total: 1.  SELECT title_en as title, slug_en as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;