Array
(
[route] => page/faq
[path] => /page/([a-z0-9_-]+)
[segments] => Array
(
[0] => page
[1] => faq
)
[closure] => Array
(
[0] => Wojo\Controller\Front\IndexController
[1] => page
)
[template] => /home/cwwwkjgpqb/beetechnologybd.com/view/front/modules/faq/index.tpl.php
)
1. select |
total: 1SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select |
total: 1SELECT * FROM `pages` WHERE (`slug_en` = "faq") and (`active` = 1) ;
3. SELECT |
total: 25SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
4. SELECT |
total: 0 SELECT id, plugin_id, jscode, show_title, alt_class, plugalias, title_en as title, body_en as body FROM `plugins` WHERE id IN (0) AND active = 1 ;
5. SELECT |
total: 0 SELECT m.question_en as title, m.answer_en as answer, c.name_en as name FROM `mod_faq` as m LEFT JOIN `mod_faq_categories` AS c ON c.id = m.category_id ORDER BY c.sorting, m.sorting;
6. select |
total: 4SELECT id, name_en FROM `mod_faq_categories` ORDER BY `sorting` ASC;
7. SELECT |
total: 1SELECT COUNT(*) as items FROM `mod_comments` WHERE section = "page" AND comment_id = 0 AND parent_id = 20 AND active = 1 LIMIT 1;
8. SELECT |
total: 0 SELECT c.id, c.user_id, c.comment_id, c.parent_id, c.section, c.vote_down, c.vote_up, c.body, c.created, c.username as uname, u.username, CONCAT(u.fname, ' ', u.lname) as name, u.avatar FROM `mod_comments` as c INNER JOIN (SELECT id FROM `mod_comments` WHERE section = "page" AND parent_id = 20 AND comment_id = 0 AND active = 1 ORDER BY created DESC ) as ch ON ch.id IN (c.id, c.comment_id) LEFT JOIN `users` as u ON u.id = c.user_id WHERE section = "page" AND parent_id = 20 AND c.active = 1 ORDER BY created DESC ;
9. 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 ;
10. 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 (`slug_en` = "faq") and (`active` = 1) ;
3. SELECT | total: 25. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
4. SELECT | total: 0. SELECT id, plugin_id, jscode, show_title, alt_class, plugalias, title_en as title, body_en as body FROM `plugins` WHERE id IN (0) AND active = 1 ;
5. SELECT | total: 0. SELECT m.question_en as title, m.answer_en as answer, c.name_en as name FROM `mod_faq` as m LEFT JOIN `mod_faq_categories` AS c ON c.id = m.category_id ORDER BY c.sorting, m.sorting;
6. select | total: 4. SELECT id, name_en FROM `mod_faq_categories` ORDER BY `sorting` ASC;
7. SELECT | total: 1. SELECT COUNT(*) as items FROM `mod_comments` WHERE section = "page" AND comment_id = 0 AND parent_id = 20 AND active = 1 LIMIT 1;
8. SELECT | total: 0. SELECT c.id, c.user_id, c.comment_id, c.parent_id, c.section, c.vote_down, c.vote_up, c.body, c.created, c.username as uname, u.username, CONCAT(u.fname, ' ', u.lname) as name, u.avatar FROM `mod_comments` as c INNER JOIN (SELECT id FROM `mod_comments` WHERE section = "page" AND parent_id = 20 AND comment_id = 0 AND active = 1 ORDER BY created DESC ) as ch ON ch.id IN (c.id, c.comment_id) LEFT JOIN `users` as u ON u.id = c.user_id WHERE section = "page" AND parent_id = 20 AND c.active = 1 ORDER BY created DESC ;
9. 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 ;
10. 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 ;