1. select |
total: 1SELECT * FROM `settings` WHERE (`id` = 1) ;
2. SELECT |
total: 1 SELECT p.id, p.created, p.price, p.sprice, p.is_sale, p.title, p.thumb, p.token, p.likes, p.ratings, FORMAT((likes/ratings),0) as stars, p.body, p.pbody, p.type, p.token, p.images, p.audio, p.youtube, p.affiliate, p.membership_id, p.keywords, p.description, c.slug as cslug, c.name, GROUP_CONCAT(m.title SEPARATOR ', ') as memberships, (SELECT COUNT(product_id) FROM `comments` WHERE `comments`.product_id = p.id AND `comments`.active = 1) as comments FROM `products` as p LEFT JOIN `categories` as c ON c.id = p.category_id LEFT JOIN `memberships` as m ON FIND_IN_SET(m.id, p.membership_id) WHERE p.slug = "yoastseopremium" AND p.active = 1 GROUP BY p.id ;
3. SELECT |
total: 2 SELECT p.id, p.price, p.sprice, p.is_sale, p.title, p.slug, p.category_id, p.thumb, p.type, p.token, p.affiliate, p.membership_id, c.name, c.slug as cslug FROM `products` as p LEFT JOIN `categories` as c ON c.id = p.category_id WHERE p.id NOT IN(10) AND p.is_sale = 1 AND p.active = 1 ORDER BY RAND() LIMIT 3;
4. SELECT |
total: 0 SELECT cf.*, cfd.field_value FROM `custom_fields` as cf LEFT JOIN `custom_fields_data` as cfd ON cfd.field_id = cf.id WHERE cfd.product_id = 10 AND cf.section = "product" ORDER BY cf.sorting ;
5. SELECT |
total: 7 SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.page_type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting ;
6. select |
total: 9SELECT id, parent_id, name, slug FROM `categories` ORDER BY `parent_id` ASC,`sorting` ASC;
7. SELECT |
total: 0 SELECT COUNT(id) as items FROM `cart` WHERE user_id = "dfad8025a525f65c17e181e20f5eec2a2495c7cb" AND membership_id = "" GROUP BY user_id;
8. count |
total: 0SELECT COUNT(*) AS items FROM `comments` WHERE parent_id = 0 AND product_id = 10 AND active = 1;
9. SELECT |
total: 0 SELECT c.id, c.user_id, c.product_id, c.parent_id, c.vote_down, c.vote_up, c.body, c.created, c.rating, c.username as uname, u.username, CONCAT(u.fname, ' ', u.lname) AS name, u.avatar FROM `comments` AS c INNER JOIN (SELECT id FROM `comments` WHERE product_id = 10 AND parent_id = 0 AND active = 1 ORDER BY created DESC ) AS ch ON ch.id IN (c.id, c.parent_id) LEFT JOIN `users` AS u ON u.id = c.user_id WHERE product_id = 10 AND c.active = 1 ORDER BY created DESC;
1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. SELECT | total: 1. SELECT p.id, p.created, p.price, p.sprice, p.is_sale, p.title, p.thumb, p.token, p.likes, p.ratings, FORMAT((likes/ratings),0) as stars, p.body, p.pbody, p.type, p.token, p.images, p.audio, p.youtube, p.affiliate, p.membership_id, p.keywords, p.description, c.slug as cslug, c.name, GROUP_CONCAT(m.title SEPARATOR ', ') as memberships, (SELECT COUNT(product_id) FROM `comments` WHERE `comments`.product_id = p.id AND `comments`.active = 1) as comments FROM `products` as p LEFT JOIN `categories` as c ON c.id = p.category_id LEFT JOIN `memberships` as m ON FIND_IN_SET(m.id, p.membership_id) WHERE p.slug = "yoastseopremium" AND p.active = 1 GROUP BY p.id ;
3. SELECT | total: 2. SELECT p.id, p.price, p.sprice, p.is_sale, p.title, p.slug, p.category_id, p.thumb, p.type, p.token, p.affiliate, p.membership_id, c.name, c.slug as cslug FROM `products` as p LEFT JOIN `categories` as c ON c.id = p.category_id WHERE p.id NOT IN(10) AND p.is_sale = 1 AND p.active = 1 ORDER BY RAND() LIMIT 3;
4. SELECT | total: 0. SELECT cf.*, cfd.field_value FROM `custom_fields` as cf LEFT JOIN `custom_fields_data` as cfd ON cfd.field_id = cf.id WHERE cfd.product_id = 10 AND cf.section = "product" ORDER BY cf.sorting ;
5. SELECT | total: 7. SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.page_type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting ;
6. select | total: 9. SELECT id, parent_id, name, slug FROM `categories` ORDER BY `parent_id` ASC,`sorting` ASC;
7. SELECT | total: 0. SELECT COUNT(id) as items FROM `cart` WHERE user_id = "dfad8025a525f65c17e181e20f5eec2a2495c7cb" AND membership_id = "" GROUP BY user_id;
8. count | total: 0. SELECT COUNT(*) AS items FROM `comments` WHERE parent_id = 0 AND product_id = 10 AND active = 1;
9. SELECT | total: 0. SELECT c.id, c.user_id, c.product_id, c.parent_id, c.vote_down, c.vote_up, c.body, c.created, c.rating, c.username as uname, u.username, CONCAT(u.fname, ' ', u.lname) AS name, u.avatar FROM `comments` AS c INNER JOIN (SELECT id FROM `comments` WHERE product_id = 10 AND parent_id = 0 AND active = 1 ORDER BY created DESC ) AS ch ON ch.id IN (c.id, c.parent_id) LEFT JOIN `users` AS u ON u.id = c.user_id WHERE product_id = 10 AND c.active = 1 ORDER BY created DESC;