Descrição
Novo produto
Novo produto
Total execution time: 1720318471.76 sec.
Framework 1.00 v5.50
Cpu Usage 14460 sec.
Memory Usage 723.62kB
POST:Array ( )GET:
Array ( )
Array ( [before] => Closure Object ( ) [segment] => Array ( [0] => product [1] => outro-produto ) [route] => /product/outro-produto [template] => /home/osgigantes/www/view/front/themes/modern/product.tpl.php )
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 = "outro-produto" 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(9) 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 = 9 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 = "2b4c099c0983668880f46edd5841775ed2a50850" AND membership_id = "" GROUP BY user_id;
8. count | total: 0. SELECT COUNT(*) AS items FROM `comments` WHERE parent_id = 0 AND product_id = 9 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 = 9 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 = 9 AND c.active = 1 ORDER BY created DESC;