Made in China
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 |
---|---|---|---|---|---|
SHOW FULL COLUMNS FROM `products` | 19 | 19 | 1 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `criteria` | 3 | 3 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `products_criteria` | 2 | 2 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `types` | 5 | 5 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `products_types` | 2 | 2 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `options` | 5 | 5 | 1 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `administrators` | 4 | 4 | 1 | maybe slow | |
SELECT COUNT(*) AS `count` FROM `products` AS `Product` WHERE `Product`.`types` LIKE '%\"53\"%' AND `Product`.`language` = 'en' | 1 | 1 | 7 | maybe slow | |
SELECT `Product`.`slug`, `Product`.`title`, `Product`.`summary`, `Product`.`dir`, `Product`.`filename` FROM `products` AS `Product` WHERE `Product`.`types` LIKE '%\"53\"%' AND `Product`.`language` = 'en' ORDER BY `Product`.`created` DESC LIMIT 24 | 24 | 24 | 5 | maybe slow | |
SELECT `Type`.`title` FROM `types` AS `Type` WHERE `Type`.`id` = 53 AND `Type`.`language` = 'en' LIMIT 1 | 1 | 1 | 0 | ||
SHOW FULL COLUMNS FROM `groups` | 3 | 3 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `companies` | 14 | 14 | 1 | 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`.`types` LIKE '%\"53\"%' AND `Product`.`language` = 'en' | 206 | 206 | 4 | ||
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 (427, 428, 429, 430, 431, 432, 433, 460, 470, 471, 472, 615, 616, 617, 618, 619, 620, 621, 622, 623, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 809, 810, 811, 812, 813, 874, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1296, 1297, 1298, 1299, 1300, 1301, 1302, 1303, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1489, 1490, 1500, 1501, 1502, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1511, 1512, 1513, 1537, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1558, 1559, 1560, 1561, 1562, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1571, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1621, 1622, 1623, 1624, 1634) AND `ProductsType`.`type_id` = `Type`.`id`) | 488 | 488 | 4 | ||
SHOW FULL COLUMNS FROM `sites` | 2 | 2 | 1 | maybe slow | |
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 | ||
SHOW FULL COLUMNS FROM `blocks` | 3 | 3 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `block_contents` | 4 | 4 | 1 | maybe slow | |
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 | ||
SHOW FULL COLUMNS FROM `company_categories` | 3 | 3 | 1 | maybe slow | |
SELECT `CompanyCategory`.`id`, `CompanyCategory`.`title` FROM `company_categories` AS `CompanyCategory` WHERE `CompanyCategory`.`language` = 'en' ORDER BY `title` ASC | 12 | 12 | 0 | ||
SHOW FULL COLUMNS FROM `links` | 10 | 10 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `navigations` | 3 | 3 | 1 | maybe slow | |
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` = 'right_sidebar' 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.49 MB
Message | Memory use |
---|---|
Component initialization | 10.57 MB |
Controller action start | 10.92 MB |
Controller render start | 11.32 MB |
Component initialization #2 | 14.54 MB |
Controller action start #2 | 14.56 MB |
Component initialization #3 | 15.28 MB |
Controller action start #3 | 15.30 MB |
Component initialization #4 | 15.53 MB |
Controller action start #4 | 15.55 MB |
Component initialization #5 | 15.51 MB |
Controller action start #5 | 15.53 MB |
Component initialization #6 | 15.56 MB |
Controller action start #6 | 15.58 MB |
Component initialization #7 | 15.62 MB |
Controller action start #7 | 15.64 MB |
Component initialization #8 | 15.71 MB |
Controller action start #8 | 15.73 MB |
View render complete | 15.59 MB |
Total Request Time: 821 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 184.13 | |
Component initialization and startup | 24.05 | |
Controller action | 203.46 | |
Render Controller Action | 311.50 | |
» Rendering View | 304.20 | |
» » Rendering APP/views/products/index.ctp | 165.55 | |
» » » Rendering APP/views/elements/search.ctp | 68.63 | |
» » » » Rendering APP/views/elements/block.ctp | 38.62 | |
» » » » » Component initialization and startup #2 | 2.38 | |
Controller action #2 | 0.00 | |
» » » » Rendering APP/views/elements/pagination.ctp | 11.07 | |
» » » Rendering APP/views/layouts/default.ctp | 138.21 | |
» » » » Rendering APP/views/elements/navigation.ctp | 57.00 | |
» » » » » Component initialization and startup #3 | 2.42 | |
Controller action #3 | 0.00 | |
» » » » » » Rendering APP/views/elements/link.ctp | 0.59 | |
» » » » » » Rendering APP/views/elements/link.ctp #2 | 0.65 | |
» » » » » » Rendering APP/views/elements/link.ctp #3 | 0.59 | |
» » » » » » Rendering APP/views/elements/link.ctp #4 | 0.45 | |
» » » » » » Rendering APP/views/elements/link.ctp #5 | 1.33 | |
» » » » » » Rendering APP/views/elements/link.ctp #6 | 1.28 | |
» » » » » » Rendering APP/views/elements/link.ctp #7 | 0.44 | |
» » » » » » Rendering APP/views/elements/link.ctp #8 | 0.47 | |
» » » » » Rendering APP/views/elements/sidebars/root.ctp | 51.61 | |
» » » » » » Rendering APP/views/elements/sidebars/partials/search.ctp #2 | 5.38 | |
» » » » » » Rendering APP/views/elements/block.ctp #2 | 6.65 | |
» » » » » » » Component initialization and startup #4 | 3.23 | |
Controller action #4 | 0.00 | |
» » » » » » Rendering APP/views/elements/block.ctp #3 | 5.69 | |
» » » » » » » Component initialization and startup #5 | 2.18 | |
Controller action #5 | 0.00 | |
» » » » » » » Rendering APP/views/elements/block.ctp #4 | 5.37 | |
» » » » » » » » Component initialization and startup #6 | 2.13 | |
Controller action #6 | 0.00 | |
» » » » » » » » Rendering APP/views/elements/navigation.ctp #2 | 11.56 | |
» » » » » » » » » Component initialization and startup #7 | 2.05 | |
Controller action #7 | 0.00 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #9 | 0.70 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #10 | 0.61 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #11 | 0.55 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #12 | 0.40 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #13 | 0.40 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #14 | 0.39 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #15 | 0.40 | |
» » » » » » » » » » Rendering APP/views/elements/link.ctp #16 | 0.42 | |
» » » » » » » » » Rendering APP/views/elements/block.ctp #5 | 5.15 | |
» » » » » » » » » » Component initialization and startup #8 | 2.00 | |
Controller action #8 | 0.00 |