Total execution time: 1720085394.98 sec.
Framework 1.00 v5.50
Cpu Usage 10043 sec.
Memory Usage 717.42kB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => content
[1] => vip
)
[route] => /content/vip
[template] => /home/osgigantes/www/view/front/themes/modern/page.tpl.php
)
1. select |
total: 1SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select |
total: 1SELECT * FROM `pages` WHERE (`slug` = "vip") and (`active` = 1) ;
3. select |
total: 4SELECT * FROM `memberships` WHERE (`active` = 1) and (`private` < 1) ORDER BY `price` ASC;
4. 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 ;
5. select |
total: 9SELECT id, parent_id, name, slug FROM `categories` ORDER BY `parent_id` ASC,`sorting` ASC;
6. SELECT |
total: 0 SELECT COUNT(id) as items FROM `cart` WHERE user_id = "10760013cd5d39cb4d806edd010d303045ce00b6" AND membership_id = "" GROUP BY user_id;
1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. select | total: 1. SELECT * FROM `pages` WHERE (`slug` = "vip") and (`active` = 1) ;
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 = "10760013cd5d39cb4d806edd010d303045ce00b6" AND membership_id = "" GROUP BY user_id;
3. select | total: 4. SELECT * FROM `memberships` WHERE (`active` = 1) and (`private` < 1) ORDER BY `price` ASC;
4. 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 ;
5. select | total: 9. SELECT id, parent_id, name, slug FROM `categories` ORDER BY `parent_id` ASC,`sorting` ASC;
6. SELECT | total: 0. SELECT COUNT(id) as items FROM `cart` WHERE user_id = "10760013cd5d39cb4d806edd010d303045ce00b6" AND membership_id = "" GROUP BY user_id;