1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 1 SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "shop" LIMIT 1;
3. select |
total: 28 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select |
total: 1 SELECT * FROM `mod_shop_categories` WHERE slug_en = "tennis" LIMIT 1;
5. count |
total: 1 SELECT COUNT(p.id) FROM `mod_shop` AS p INNER JOIN `mod_shop_related_categories` AS rc ON p.id = rc.item_id WHERE rc.category_id = 38 AND p.active = 1 LIMIT 1;
6. SELECT |
total: 1 SELECT d.id, d.created, d.price, d.price_sale, d.quantity, d.subtract, d.label, d.ratings, d.variation_data, FORMAT((d.likes/d.ratings),0) as stars, d.title_en AS title, d.slug_en AS slug, d.thumb, d.likes, c.slug_en AS cslug, c.name_en AS name, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = d.id AND section = 'shop') as comments FROM `mod_shop` AS d LEFT JOIN `mod_shop_categories` AS c ON c.id = d.category_id INNER JOIN `mod_shop_related_categories` AS rc ON d.id = rc.item_id WHERE rc.category_id = 38 AND d.active = 1 AND c.active = 1 GROUP BY d.id ORDER BY created DESC LIMIT 0,10
7. SELECT |
total: 3 SELECT
p.id,
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en as title,
p.body_en 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 = "shop"
AND p.active = 1
ORDER BY l.sorting;
8. SELECT |
total: 0 SELECT c.totalprice, c.total, Max(c.tax) as tax, Max(c.id) as id, Max(c.variants) as variants, p.id AS pid, p.title_en AS title, p.slug_en AS slug, p.price, p.thumb, COUNT(*) AS items FROM `mod_shop_cart` AS c LEFT JOIN `mod_shop` AS p ON p.id = c.product_id WHERE c.user_id = "e4187f90a1bf27457f22b169accaacf7f16016a8" GROUP BY c.product_id, c.totalprice, c.total ORDER BY c.product_id DESC;
9. SELECT |
total: 4 SELECT c.id, c.parent_id, c.name_en AS name, c.slug_en AS slug, (SELECT COUNT(p.id) FROM mod_shop p INNER JOIN `mod_shop_related_categories` rc ON p.id = rc.item_id WHERE rc.category_id = c.id AND p.active = 1) AS items FROM `mod_shop_categories` AS c WHERE c.active = 1 GROUP BY c.id ORDER BY parent_id, sorting;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 1 . SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "shop" LIMIT 1;
3. select | total: 28 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select | total: 1 . SELECT * FROM `mod_shop_categories` WHERE slug_en = "tennis" LIMIT 1;
5. count | total: 1 . SELECT COUNT(p.id) FROM `mod_shop` AS p INNER JOIN `mod_shop_related_categories` AS rc ON p.id = rc.item_id WHERE rc.category_id = 38 AND p.active = 1 LIMIT 1;
6. SELECT | total: 1 . SELECT d.id, d.created, d.price, d.price_sale, d.quantity, d.subtract, d.label, d.ratings, d.variation_data, FORMAT((d.likes/d.ratings),0) as stars, d.title_en AS title, d.slug_en AS slug, d.thumb, d.likes, c.slug_en AS cslug, c.name_en AS name, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = d.id AND section = 'shop') as comments FROM `mod_shop` AS d LEFT JOIN `mod_shop_categories` AS c ON c.id = d.category_id INNER JOIN `mod_shop_related_categories` AS rc ON d.id = rc.item_id WHERE rc.category_id = 38 AND d.active = 1 AND c.active = 1 GROUP BY d.id ORDER BY created DESC LIMIT 0,10
7. SELECT | total: 3 . SELECT
p.id,
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en as title,
p.body_en 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 = "shop"
AND p.active = 1
ORDER BY l.sorting;
8. SELECT | total: 0 . SELECT c.totalprice, c.total, Max(c.tax) as tax, Max(c.id) as id, Max(c.variants) as variants, p.id AS pid, p.title_en AS title, p.slug_en AS slug, p.price, p.thumb, COUNT(*) AS items FROM `mod_shop_cart` AS c LEFT JOIN `mod_shop` AS p ON p.id = c.product_id WHERE c.user_id = "e4187f90a1bf27457f22b169accaacf7f16016a8" GROUP BY c.product_id, c.totalprice, c.total ORDER BY c.product_id DESC;
9. SELECT | total: 4 . SELECT c.id, c.parent_id, c.name_en AS name, c.slug_en AS slug, (SELECT COUNT(p.id) FROM mod_shop p INNER JOIN `mod_shop_related_categories` rc ON p.id = rc.item_id WHERE rc.category_id = c.id AND p.active = 1) AS items FROM `mod_shop_categories` AS c WHERE c.active = 1 GROUP BY c.id ORDER BY parent_id, sorting;
