Shop

Shop enables you to sell items right from CMS pro!

Home/
Shop
Shape1
Shape2
Reset Category Name Price Date
Total: 1 / Current Page: 1 of 1

Total execution time: 1714293887.1968 sec.

Framework 1.50 v6.20

Cpu Usage 15962 sec.

Memory Usage 3.25MB

POST: 
Array
(
)
GET: 
Array
(
)

                         
Array
(
    [route] => shop
    [path] => /shop
    [segments] => Array
        (
            [0] => shop
        )

    [closure] => Array
        (
            [0] => Wojo\Controller\Front\Module\Shop\ShopController
            [1] => index
        )

    [template] => /home/theplugi/public_html/view/front/plugins/shop/categories/index.tpl.php
)

1. select | total: 1
SELECT * FROM `settings` WHERE (`id` = 1) ;

2. select | total: 2
SELECT title_en as title, info_en, keywords_en, description_en FROM `modules` WHERE (`modalias` = "shop") ;

3. count | total: 1
SELECT COUNT(*) AS items FROM `mod_shop` WHERE active = 1 LIMIT 1;

4. SELECT | total: 1
SELECT d.id, d.created, d.price, d.price_sale, d.subtract, d.label, d.ratings, d.quantity, d.variation_data, FORMAT((d.likes/d.ratings),0) as stars, d.title_en as title, d.slug_en as slug, d.body_en as body, d.thumb, 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 WHERE d.active = 1 GROUP BY d.id ORDER BY created DESC LIMIT 0,10;

5. SELECT | total: 2
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 ;

6. SELECT | total: 27
SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;

7. SELECT | total: 0
SELECT c.totalprice, c.total, MAX(c.tax) as tax, MAX(totaltax) as totaltax, 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 = "48c71e45496275507f97d58652a716a2503018ae" GROUP BY c.product_id, c.totalprice, c.variants ORDER BY c.product_id DESC ;

8. SELECT | total: 1
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, parent_id, sorting ORDER BY parent_id, sorting ;

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: 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: 2. SELECT title_en as title, info_en, keywords_en, description_en FROM `modules` WHERE (`modalias` = "shop") ;
3. count | total: 1. SELECT COUNT(*) AS items FROM `mod_shop` WHERE active = 1 LIMIT 1;
4. SELECT | total: 1.  SELECT d.id, d.created, d.price, d.price_sale, d.subtract, d.label, d.ratings, d.quantity, d.variation_data, FORMAT((d.likes/d.ratings),0) as stars, d.title_en as title, d.slug_en as slug, d.body_en as body, d.thumb, 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 WHERE d.active = 1 GROUP BY d.id ORDER BY created DESC LIMIT 0,10;
5. SELECT | total: 2.  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 ;
6. SELECT | total: 27. SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, sorting;
7. SELECT | total: 0.  SELECT c.totalprice, c.total, MAX(c.tax) as tax, MAX(totaltax) as totaltax, 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 = "48c71e45496275507f97d58652a716a2503018ae" GROUP BY c.product_id, c.totalprice, c.variants ORDER BY c.product_id DESC ;
8. SELECT | total: 1.  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, parent_id, sorting ORDER BY parent_id, sorting ;
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: 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 ;