Home/
Customer Support

Total execution time: 1737560575.0258 sec.

Framework 1.00 v5.50

Cpu Usage 6690 sec.

Memory Usage 0.93MB

POST: 
Array
(
)
GET: 
Array
(
)

                         
Array
(
    [before] => Closure Object
        (
        )

    [segment] => Array
        (
            [0] => category
            [1] => customer-support
        )

    [route] => /category/customer-support
    [template] => /home/wataw11/public_html/view/front/themes/modern/category.tpl.php
)

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

2. select | total: 1
SELECT * FROM `categories` WHERE (`slug` = "customer-support") ;

3. SELECT | total: 1
SELECT COUNT(p.id) as items FROM `products` as p INNER JOIN `categories_related` as rc ON p.id = rc.product_id WHERE rc.category_id = 7 AND p.active = 1 LIMIT 1;

4. SELECT | total: 0
SELECT p.id, p.created, p.price, p.sprice, p.is_sale, p.title, p.slug, p.thumb, p.audio, p.token, p.likes, p.body, p.type, p.token, p.affiliate, p.membership_id, 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) as comments FROM `products` as p LEFT JOIN `categories` as c ON c.id = p.category_id INNER JOIN `categories_related` as rc ON p.id = rc.product_id LEFT JOIN `memberships` as m ON FIND_IN_SET(m.id, p.membership_id) WHERE rc.category_id = 7 AND p.active = 1 AND c.active = 1 GROUP BY p.id ORDER BY created DESC ;

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 = "3ec3c3ba97aabac630d20155e003062d42fa3797" AND membership_id = "" GROUP BY user_id;

1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select | total: 1. SELECT * FROM `categories` WHERE (`slug` = "customer-support") ;
3. SELECT | total: 1.  SELECT COUNT(p.id) as items FROM `products` as p INNER JOIN `categories_related` as rc ON p.id = rc.product_id WHERE rc.category_id = 7 AND p.active = 1 LIMIT 1;
4. SELECT | total: 0.  SELECT p.id, p.created, p.price, p.sprice, p.is_sale, p.title, p.slug, p.thumb, p.audio, p.token, p.likes, p.body, p.type, p.token, p.affiliate, p.membership_id, 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) as comments FROM `products` as p LEFT JOIN `categories` as c ON c.id = p.category_id INNER JOIN `categories_related` as rc ON p.id = rc.product_id LEFT JOIN `memberships` as m ON FIND_IN_SET(m.id, p.membership_id) WHERE rc.category_id = 7 AND p.active = 1 AND c.active = 1 GROUP BY p.id ORDER BY created DESC ;
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 = "3ec3c3ba97aabac630d20155e003062d42fa3797" AND membership_id = "" GROUP BY user_id;