Technics
ECO-foryou.com is the international "Wholesale-Broker" for green companies, green products and environmental services...
To view Cookies, add CookieComponent to Controller
Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|---|
SELECT COUNT(*) AS `count` FROM `products` AS `Product` WHERE `Product`.`category_id` = 27 AND `Product`.`language` = 'en' | 1 | 1 | 0 | ||
SELECT `Product`.`slug`, `Product`.`title`, `Product`.`summary`, `Product`.`dir`, `Product`.`filename` FROM `products` AS `Product` WHERE `Product`.`category_id` = 27 AND `Product`.`language` = 'en' ORDER BY `Product`.`created` DESC LIMIT 24 | 11 | 11 | 1 | maybe slow | |
SELECT `Category`.`title` FROM `categories` AS `Category` WHERE `Category`.`id` = 27 AND `Category`.`language` = 'en' LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Category`.`id`, `Category`.`title`, `Category`.`filename`, `Category`.`dir`, `Category`.`language`, `Category`.`banners` FROM `categories` AS `Category` WHERE `Category`.`id` = 27 AND `Category`.`language` = 'en' LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Product`.`slug`, `Product`.`title` FROM `products` AS `Product` WHERE `Product`.`is_popular` = 1 AND `Product`.`language` = 'en' | 0 | 0 | 6 | maybe slow | |
SELECT `Product`.`group_id`, `Product`.`subgroup_id`, `Product`.`is_popular`, `Product`.`types`, `Product`.`criteria`, `Product`.`company_id`, `Company`.`slug`, `Company`.`name`, `Group`.`id`, `Group`.`title`, `Company`.`id`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `companies` AS `Company` ON (`Product`.`company_id` = `Company`.`id`) LEFT JOIN `groups` AS `Group` ON (`Product`.`group_id` = `Group`.`id`) WHERE `Product`.`category_id` = 27 AND `Product`.`language` = 'en' | 11 | 11 | 1 | maybe slow | |
SELECT `Type`.`id`, `Type`.`title`, `Type`.`dir`, `Type`.`filename`, `ProductsType`.`product_id`, `ProductsType`.`type_id` FROM `types` AS `Type` JOIN `products_types` AS `ProductsType` ON (`ProductsType`.`product_id` IN (422, 423, 424, 425, 426, 624, 625, 626, 917, 918, 919) AND `ProductsType`.`type_id` = `Type`.`id`) | 26 | 26 | 1 | ||
UPDATE `sites` AS `Site` SET `Site`.`view_count` = Site.view_count + 1 WHERE `Site`.`id` = 1 | 1 | 0 | |||
SELECT `Site`.`view_count` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | ||
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'after_blue_box' AND `BlockContent`.`language` = 'en' LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Type`.`id`, `Type`.`title` FROM `types` AS `Type` WHERE `Type`.`language` = 'en' ORDER BY `title` ASC | 37 | 37 | 0 | ||
SELECT `CompanyCategory`.`id`, `CompanyCategory`.`title` FROM `company_categories` AS `CompanyCategory` WHERE `CompanyCategory`.`language` = 'en' ORDER BY `title` ASC | 12 | 12 | 0 | ||
SELECT `Link`.`id`, `Link`.`title`, `Link`.`type`, `Link`.`object_id`, `Link`.`subject`, `Link`.`lft`, `Link`.`rght`, `Link`.`language`, `Link`.`navigation_id`, `Link`.`parent_id`, `Navigation`.`id`, `Navigation`.`name`, `Navigation`.`key` FROM `links` AS `Link` LEFT JOIN `navigations` AS `Navigation` ON (`Link`.`navigation_id` = `Navigation`.`id`) WHERE `Link`.`language` = 'en' AND `Navigation`.`key` = 'main' AND `Link`.`language` = 'en' ORDER BY `Link`.`lft` ASC | 8 | 8 | 0 | ||
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'partners' AND `BlockContent`.`language` = 'en' LIMIT 1 | 1 | 1 | 0 | ||
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'bottom' AND `BlockContent`.`language` = 'en' LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Link`.`id`, `Link`.`title`, `Link`.`type`, `Link`.`object_id`, `Link`.`subject`, `Link`.`lft`, `Link`.`rght`, `Link`.`language`, `Link`.`navigation_id`, `Link`.`parent_id`, `Navigation`.`id`, `Navigation`.`name`, `Navigation`.`key` FROM `links` AS `Link` LEFT JOIN `navigations` AS `Navigation` ON (`Link`.`navigation_id` = `Navigation`.`id`) WHERE `Link`.`language` = 'en' AND `Navigation`.`key` = 'footer' AND `Link`.`language` = 'en' ORDER BY `Link`.`lft` ASC | 8 | 8 | 0 | ||
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'footer' AND `BlockContent`.`language` = 'en' LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 17.44 MB
Message | Memory use |
---|---|
Component initialization | 10.58 MB |
Controller action start | 10.90 MB |
Controller render start | 11.37 MB |
Component initialization #2 | 14.58 MB |
Controller action start #2 | 14.60 MB |
Component initialization #3 | 15.30 MB |
Controller action start #3 | 15.32 MB |
Component initialization #4 | 15.57 MB |
Controller action start #4 | 15.58 MB |
Component initialization #5 | 15.54 MB |
Controller action start #5 | 15.56 MB |
Component initialization #6 | 15.60 MB |
Controller action start #6 | 15.61 MB |
Component initialization #7 | 15.69 MB |
Controller action start #7 | 15.70 MB |
View render complete | 15.57 MB |
Total Request Time: 324 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 60.59 | |
Component initialization and startup | 6.34 | |
Controller action | 25.47 | |
Render Controller Action | 143.85 | |
» Rendering View | 142.31 | |
» » Rendering APP/views/products/index.ctp | 74.89 | |
» » » Rendering APP/views/elements/search.ctp | 21.94 | |
» » » » Rendering APP/views/elements/block.ctp | 8.62 | |
» » » » » Component initialization and startup #2 | 2.21 | |
Controller action #2 | 0.00 | |
» » » » Rendering APP/views/elements/pagination.ctp | 0.30 | |
» » » Rendering APP/views/layouts/default.ctp | 66.96 | |
» » » » Rendering APP/views/elements/navigation.ctp | 19.15 | |
» » » » » Component initialization and startup #3 | 2.30 | |
Controller action #3 | 0.00 | |
» » » » » » Rendering APP/views/elements/link.ctp | 0.42 | |
» » » » » » Rendering APP/views/elements/link.ctp #2 | 0.49 | |
» » » » » » Rendering APP/views/elements/link.ctp #3 | 0.52 | |
» » » » » » Rendering APP/views/elements/link.ctp #4 | 0.36 | |
» » » » » » Rendering APP/views/elements/link.ctp #5 | 1.17 | |
» » » » » » Rendering APP/views/elements/link.ctp #6 | 1.15 | |
» » » » » » Rendering APP/views/elements/link.ctp #7 | 0.41 | |
» » » » » » Rendering APP/views/elements/link.ctp #8 | 0.36 | |
» » » » » Rendering APP/views/elements/sidebars/root.ctp | 23.69 | |
» » » » » » Rendering APP/views/elements/sidebars/partials/search.ctp #2 | 3.39 | |
» » » » » » Rendering APP/views/elements/block.ctp #2 | 5.68 | |
» » » » » » » Component initialization and startup #4 | 2.23 | |
Controller action #4 | 0.00 | |
» » » » » » Rendering APP/views/elements/block.ctp #3 | 5.42 | |
» » » » » » » Component initialization and startup #5 | 2.15 | |
Controller action #5 | 0.00 | |
» » » » » » » Rendering APP/views/elements/navigation.ctp #2 | 11.47 | |
» » » » » » » » Component initialization and startup #6 | 2.13 | |
Controller action #6 | 0.00 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #9 | 0.72 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #10 | 0.57 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #11 | 0.50 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #12 | 0.38 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #13 | 0.43 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #14 | 0.36 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #15 | 0.39 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #16 | 0.40 | |
» » » » » » » » Rendering APP/views/elements/block.ctp #4 | 5.66 | |
» » » » » » » » » Component initialization and startup #7 | 2.25 | |
Controller action #7 | 0.00 |