Total execution time: 0.059079 sec.
Framework 1.20 v5.10
Memory Usage 5.9MB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => urunler
[1] => aynalar
)
[route] => /urunler/aynalar
[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: 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 = "aynalar"
AND a.active = 1
GROUP BY a.id;
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: 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 = "aynalar"
AND a.active = 1
GROUP BY a.id;