Announcements

Here you will find the latest Stellarity news and announcements

Home/Announcements/
Archive
Shape1
Shape2

Archive 2024, October

Sample
28

Total execution time: 1765052528.6473 sec.

Framework 1.50 v6.20

Cpu Usage 17066 sec.

Memory Usage 848.28kB

POST: 
Array
(
)
GET: 
Array
(
)

                         
Array
(
    [route] => blog/archive/2024-10
    [path] => /blog/archive/([0-9]+)-([0-9]+)
    [segments] => Array
        (
            [0] => blog
            [1] => archive
            [2] => 2024-10
        )

    [closure] => Array
        (
            [0] => Wojo\Controller\Front\Module\Blog\BlogController
            [1] => archive
        )

    [template] => /var/www/community_st_usr/data/www/community.stellaritygroup.com/view/front/plugins/blog/blogcats/index.tpl.php
)

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

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

3. SELECT | total: 1
SELECT a.*, a.slug_en as slug, a.title_en as title FROM mod_blog as a WHERE a.active = 1 AND YEAR(a.created) = 2024 AND MONTH(a.created) = 10 GROUP BY a.id ORDER BY a.created DESC ;

4. SELECT | total: 2
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 ;

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

6. SELECT | total: 2
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: 2
SELECT title_en as title, slug_en as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;

8. SELECT | total: 1
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 ;

9. SELECT | total: 2
SELECT c.id, c.parent_id, c.name_en as name, c.slug_en as slug, (SELECT COUNT(p.id) FROM mod_blog p INNER JOIN `mod_blog_related_categories` rc ON p.id = rc.item_id WHERE rc.category_id = c.id AND p.active = 1) as items FROM `mod_blog_categories` as c GROUP BY c.id, parent_id, sorting ORDER BY parent_id, sorting ;

10. SELECT | total: 2
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 ;

11. SELECT | total: 2
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 title_en as title, info_en, keywords_en, description_en FROM `modules` WHERE (`modalias` = "blog") ;
3. count | total: 2. SELECT COUNT(*) AS items FROM `mod_blog` WHERE active = 1 LIMIT 1;
4. SELECT | total: 2.  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 ;
5. SELECT | total: 2.  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 ;
6. SELECT | total: 16. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
7. SELECT | total: 2.  SELECT title_en as title, slug_en as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;
8. SELECT | total: 2.  SELECT title_en as title, slug_en as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;
9. SELECT | total: 1.  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 ;
10. SELECT | total: 2.  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 ;
11. SELECT | total: 2.  SELECT title_en as title, slug_en as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;
12. SELECT | total: 2.  SELECT title_en as title, slug_en as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;
3. SELECT | total: 1.  SELECT a.*, a.slug_en as slug, a.title_en as title FROM mod_blog as a WHERE a.active = 1 AND YEAR(a.created) = 2024 AND MONTH(a.created) = 10 GROUP BY a.id ORDER BY a.created DESC ;
5. SELECT | total: 16. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
6. SELECT | total: 2.  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 ;
8. SELECT | total: 1.  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 ;
9. SELECT | total: 2.  SELECT c.id, c.parent_id, c.name_en as name, c.slug_en as slug, (SELECT COUNT(p.id) FROM mod_blog p INNER JOIN `mod_blog_related_categories` rc ON p.id = rc.item_id WHERE rc.category_id = c.id AND p.active = 1) as items FROM `mod_blog_categories` as c GROUP BY c.id, parent_id, sorting ORDER BY parent_id, sorting ;