1. select |
total: 1SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select |
total: 1SELECT title_tr as title, info_tr, keywords_tr, description_tr FROM `modules` WHERE (`modalias` = "blog") ;
3. select |
total: 1SELECT * FROM `mod_blog_categories` WHERE (`slug_tr` = "teknoloji") ;
4. SELECT |
total: 1 SELECT COUNT(a.id) as items FROM `mod_blog` as a INNER JOIN `mod_blog_related_categories` as rc ON a.id = rc.item_id WHERE rc.category_id = 3 AND a.active = 1 LIMIT 1 ;
5. SELECT |
total: 4 SELECT a.id, a.created, a.title_tr as title, a.slug_tr as slug, a.body_tr as body, a.thumb, a.rating, a.membership_id, c.slug_tr as cslug, c.name_tr as ctitle, GROUP_CONCAT(m.title_tr SEPARATOR ', ') as memberships, (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 INNER JOIN `mod_blog_related_categories` as rc ON a.id = rc.item_id LEFT JOIN `memberships` as m ON FIND_IN_SET(m.id, a.membership_id) WHERE rc.category_id = 3 AND a.active = 1 AND c.active = 1 GROUP BY a.id ORDER BY created DESC LIMIT 0,10;
6. SELECT |
total: 0 SELECT p.id, l.plug_id, l.space, l.place, p.system, p.alt_class, p.plugalias, p.plugin_id, p.title_tr as title, p.body_tr 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: 32SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
8. SELECT |
total: 0 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 ;
9. SELECT |
total: 4 SELECT title_tr as title, slug_tr 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: 32. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
3. SELECT | total: 0. 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 ;
4. SELECT | total: 4. SELECT title_tr as title, slug_tr as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;
2. select | total: 1. SELECT title_tr as title, info_tr, keywords_tr, description_tr FROM `modules` WHERE (`modalias` = "blog") ;
3. select | total: 1. SELECT * FROM `mod_blog_categories` WHERE (`slug_tr` = "teknoloji") ;
4. SELECT | total: 1. SELECT COUNT(a.id) as items FROM `mod_blog` as a INNER JOIN `mod_blog_related_categories` as rc ON a.id = rc.item_id WHERE rc.category_id = 3 AND a.active = 1 LIMIT 1 ;
5. SELECT | total: 4. SELECT a.id, a.created, a.title_tr as title, a.slug_tr as slug, a.body_tr as body, a.thumb, a.rating, a.membership_id, c.slug_tr as cslug, c.name_tr as ctitle, GROUP_CONCAT(m.title_tr SEPARATOR ', ') as memberships, (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 INNER JOIN `mod_blog_related_categories` as rc ON a.id = rc.item_id LEFT JOIN `memberships` as m ON FIND_IN_SET(m.id, a.membership_id) WHERE rc.category_id = 3 AND a.active = 1 AND c.active = 1 GROUP BY a.id ORDER BY created DESC LIMIT 0,10;
6. SELECT | total: 0. SELECT p.id, l.plug_id, l.space, l.place, p.system, p.alt_class, p.plugalias, p.plugin_id, p.title_tr as title, p.body_tr 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: 32. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
8. SELECT | total: 0. 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 ;
9. SELECT | total: 4. SELECT title_tr as title, slug_tr as slug, thumb, created, id FROM `mod_blog` WHERE active = 1 ORDER BY hits DESC LIMIT 5 ;