Total execution time: 0.034159 sec.
Framework 1.20 v5.10
Memory Usage 3.99MB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => urunler
)
[route] => /urunler
[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] => front/themes/master/mod_index.tpl.php
[Bootstrap::Autoloader[4]] => autoload registered
[Bootstrap::Autoloader[5]] => autoload registered
)
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. count |
total: 88 SELECT COUNT(*) FROM `mod_blog` WHERE active = 1 LIMIT 1
4. SELECT |
total: 12 SELECT
a.id,
a.created,
a.title_en AS title,
a.slug_en AS slug,
a.body_en AS body,
a.thumb,
c.slug_en AS cslug,
c.name_en AS ctitle,
(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
LEFT JOIN `users` AS u
ON u.id = a.user_id
WHERE a.active = 1
ORDER BY a.created DESC LIMIT 0,12
5. select |
total: 14 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
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;
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. count | total: 88 . SELECT COUNT(*) FROM `mod_blog` WHERE active = 1 LIMIT 1
4. SELECT | total: 12 . SELECT
a.id,
a.created,
a.title_en AS title,
a.slug_en AS slug,
a.body_en AS body,
a.thumb,
c.slug_en AS cslug,
c.name_en AS ctitle,
(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
LEFT JOIN `users` AS u
ON u.id = a.user_id
WHERE a.active = 1
ORDER BY a.created DESC LIMIT 0,12
5. select | total: 14 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
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;
