1. select |
total: 1SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select |
total: 2SELECT title_en as title, info_en, keywords_en, description_en FROM `modules` WHERE (`modalias` = "shop") ;
3. SELECT |
total: 1 SELECT d.*, d.title_en as title, FORMAT((d.likes/d.ratings),0) as stars, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = d.id AND section = 'shop') as comments FROM `mod_shop` as d WHERE slug_en = "qqqqqq" AND d.active = 1 GROUP BY d.id;
4. SELECT |
total: 0SELECT SUM(totalprice) as grand, COUNT(id) as items FROM `mod_shop_cart` WHERE user_id = "a2c721ad82cf4149430f1c0b46c8efb5d5d3f539" GROUP BY user_id;
5. SELECT |
total: 27SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
6. SELECT |
total: 1SELECT COUNT(*) as items FROM `mod_comments` WHERE section = "shop" AND comment_id = 0 AND parent_id = 1 AND active = 1 LIMIT 1;
7. 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 = "shop" AND parent_id = 1 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 = "shop" AND parent_id = 1 AND c.active = 1 ORDER BY created DESC ;
8. 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 ;
9. 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: 27. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
3. SELECT | total: 1. SELECT d.*, d.title_en as title, FORMAT((d.likes/d.ratings),0) as stars, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = d.id AND section = 'shop') as comments FROM `mod_shop` as d WHERE slug_en = "qqqqqq" AND d.active = 1 GROUP BY d.id;
4. 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 ;
2. select | total: 2. SELECT title_en as title, info_en, keywords_en, description_en FROM `modules` WHERE (`modalias` = "shop") ;
4. SELECT | total: 0. SELECT SUM(totalprice) as grand, COUNT(id) as items FROM `mod_shop_cart` WHERE user_id = "a2c721ad82cf4149430f1c0b46c8efb5d5d3f539" GROUP BY user_id;
5. SELECT | total: 27. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
6. SELECT | total: 1. SELECT COUNT(*) as items FROM `mod_comments` WHERE section = "shop" AND comment_id = 0 AND parent_id = 1 AND active = 1 LIMIT 1;
7. 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 = "shop" AND parent_id = 1 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 = "shop" AND parent_id = 1 AND c.active = 1 ORDER BY created DESC ;
8. 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 ;
9. 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 ;