Array
(
)

Array
(
)

Array
(
    [before] => Closure Object
        (
        )

    [segment] => Array
        (
            [0] => urunler
            [1] => kahve-rengi-pencere-pimapen
        )

    [route] => /urunler/kahve-rengi-pencere-pimapen
    [Bootstrap::Autoloader[1]] => registered path "autoloaded class "/home/xx2elcom/domains/ikincielotelmalzemeleri.com/public_html/view/admin/modules_/blog/
    [Bootstrap::Autoloader[2]] => autoload registered
    [Bootstrap::Autoloader[3]] => autoloaded class "/home/xx2elcom/domains/ikincielotelmalzemeleri.com/public_html/view/admin/modules_/blog/Blog.class.php
    [template] => admin/error.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: 14 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;

4. SELECT | total: 1 . SELECT 
			a.*,
			a.slug_en as slug,
			c.slug_en as catslug,
			c.name_en as catname,
			CONCAT(u.fname,' ',u.lname) as user,
			u.username,
			GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships
		  FROM
			`mod_blog` AS a
			LEFT JOIN `users` AS u 
			  ON u.id = a.user_id
			LEFT JOIN `mod_blog_categories` AS c 
			  ON c.id = a.category_id
			LEFT JOIN `memberships` AS m 
			  ON FIND_IN_SET(m.id, a.membership_id)
		  WHERE a.slug_en = "db-02-havlu-askisi"
		  AND a.active = 1 
		  GROUP BY a.id;

5. UPDATE | total: 1 . UPDATE `mod_blog` 
			  SET `hits` = `hits` + 1 
			  WHERE id = 32;

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

7. SELECT | total: 30 . 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
		  ORDER BY parent_id, sorting;

4. SELECT | total: 0 . SELECT 
			a.*,
			a.slug_en as slug,
			c.slug_en as catslug,
			c.name_en as catname,
			CONCAT(u.fname,' ',u.lname) as user,
			u.username,
			GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships
		  FROM
			`mod_blog` AS a
			LEFT JOIN `users` AS u 
			  ON u.id = a.user_id
			LEFT JOIN `mod_blog_categories` AS c 
			  ON c.id = a.category_id
			LEFT JOIN `memberships` AS m 
			  ON FIND_IN_SET(m.id, a.membership_id)
		  WHERE a.slug_en = "kahve-rengi-pencere-pimapen"
		  AND a.active = 1 
		  GROUP BY a.id;