1. select |
total: 1SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select |
total: 1SELECT * FROM `pages` WHERE (`page_type` = "home") and (`active` = 1) ;
3. SELECT |
total: 32SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
4. SELECT |
total: 32SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
5. SELECT |
total: 3 SELECT id, plugin_id, jscode, show_title, alt_class, plugalias, title_tr as title, body_tr as body FROM `plugins` WHERE id IN (60,61,62) AND active = 1 ;
6. SELECT |
total: 10SELECT n.*, c.name_tr as category_name, c.slug_tr as category_slug FROM mod_news n LEFT JOIN mod_news_categories c ON n.category_id = c.id WHERE n.active = 1 AND n.publish_date <= NOW() ORDER BY n.publish_date DESC LIMIT 10;
7. SELECT |
total: 10SELECT p.*, c.name_tr as category_name, c.slug_tr as category_slug FROM mod_portfolio p LEFT JOIN mod_portfolio_categories c ON p.category_id = c.id WHERE p.category_id = 2 ORDER BY p.created DESC LIMIT 10;
8. SELECT |
total: 4SELECT b.*, c.name_tr as category_name, c.slug_tr as category_slug FROM mod_blog b LEFT JOIN mod_blog_categories c ON b.category_id = c.id WHERE b.active = 1 ORDER BY b.created DESC LIMIT 10;
9. 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 ;
10. 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 * FROM `pages` WHERE (`page_type` = "home") and (`active` = 1) ;
3. SELECT | total: 32. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
4. SELECT | total: 32. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
5. SELECT | total: 3. SELECT id, plugin_id, jscode, show_title, alt_class, plugalias, title_tr as title, body_tr as body FROM `plugins` WHERE id IN (60,61,62) AND active = 1 ;
6. SELECT | total: 10. SELECT n.*, c.name_tr as category_name, c.slug_tr as category_slug FROM mod_news n LEFT JOIN mod_news_categories c ON n.category_id = c.id WHERE n.active = 1 AND n.publish_date <= NOW() ORDER BY n.publish_date DESC LIMIT 10;
7. SELECT | total: 10. SELECT p.*, c.name_tr as category_name, c.slug_tr as category_slug FROM mod_portfolio p LEFT JOIN mod_portfolio_categories c ON p.category_id = c.id WHERE p.category_id = 2 ORDER BY p.created DESC LIMIT 10;
8. SELECT | total: 4. SELECT b.*, c.name_tr as category_name, c.slug_tr as category_slug FROM mod_blog b LEFT JOIN mod_blog_categories c ON b.category_id = c.id WHERE b.active = 1 ORDER BY b.created DESC LIMIT 10;
9. 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 ;
10. 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 ;
