Eco Green Products
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 | 0 | ||
SHOW FULL COLUMNS FROM `products_types` | 2 | 2 | 0 | ||
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 | 0 | ||
SELECT COUNT(*) AS `count` FROM `products` AS `Product` WHERE `Product`.`category_id` = 21 AND `Product`.`language` = 'en' | 1 | 1 | 2 | maybe slow | |
SELECT `Product`.`slug`, `Product`.`title`, `Product`.`summary`, `Product`.`dir`, `Product`.`filename` FROM `products` AS `Product` WHERE `Product`.`category_id` = 21 AND `Product`.`language` = 'en' ORDER BY `Product`.`created` DESC LIMIT 24 | 24 | 24 | 4 | maybe slow | |
SHOW FULL COLUMNS FROM `categories` | 6 | 6 | 1 | maybe slow | |
SELECT `Category`.`title` FROM `categories` AS `Category` WHERE `Category`.`id` = 21 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` = 21 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 | 0 | ||
SHOW FULL COLUMNS FROM `groups` | 3 | 3 | 0 | ||
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`.`category_id` = 21 AND `Product`.`language` = 'en' | 553 | 553 | 6 | ||
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 (214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 713, 714, 719, 720, 721, 722, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 825, 826, 827, 828, 829, 830, 831, 832, 833, 834, 835, 837, 838, 839, 840, 841, 842, 843, 844, 845, 847, 848, 849, 851, 852, 853, 854, 855, 856, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 875, 876, 877, 910, 911, 912, 913, 914, 915, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 1023, 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, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1290, 1291, 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, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1463, 1464, 1465, 1466, 1467, 1472, 1491, 1500, 1501, 1502, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1511, 1512, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1572, 1573, 1574, 1575, 1577, 1624) AND `ProductsType`.`type_id` = `Type`.`id`) | 1192 | 1192 | 7 | ||
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 | 0 | ||
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 | 2 | 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` = '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.75 MB
Message | Memory use |
---|---|
Component initialization | 10.57 MB |
Controller action start | 10.92 MB |
Controller render start | 11.45 MB |
Component initialization #2 | 14.69 MB |
Controller action start #2 | 14.71 MB |
Component initialization #3 | 15.43 MB |
Controller action start #3 | 15.44 MB |
Component initialization #4 | 15.68 MB |
Controller action start #4 | 15.70 MB |
Component initialization #5 | 15.65 MB |
Controller action start #5 | 15.67 MB |
Component initialization #6 | 15.71 MB |
Controller action start #6 | 15.72 MB |
Component initialization #7 | 15.80 MB |
Controller action start #7 | 15.81 MB |
View render complete | 15.67 MB |
Total Request Time: 1143 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 81.40 | |
Component initialization and startup | 13.34 | |
Controller action | 725.93 | |
Render Controller Action | 223.14 | |
» Rendering View | 221.20 | |
» » Rendering APP/views/products/index.ctp | 87.54 | |
» » » Rendering APP/views/elements/search.ctp | 26.66 | |
» » » » Rendering APP/views/elements/block.ctp | 11.41 | |
» » » » » Component initialization and startup #2 | 2.17 | |
Controller action #2 | 0.00 | |
» » » » Rendering APP/views/elements/pagination.ctp | 10.63 | |
» » » Rendering APP/views/layouts/default.ctp | 133.22 | |
» » » » Rendering APP/views/elements/navigation.ctp | 23.32 | |
» » » » » Component initialization and startup #3 | 2.07 | |
Controller action #3 | 0.00 | |
» » » » » » Rendering APP/views/elements/link.ctp | 0.33 | |
» » » » » » Rendering APP/views/elements/link.ctp #2 | 0.43 | |
» » » » » » Rendering APP/views/elements/link.ctp #3 | 0.49 | |
» » » » » » Rendering APP/views/elements/link.ctp #4 | 0.35 | |
» » » » » » Rendering APP/views/elements/link.ctp #5 | 1.25 | |
» » » » » » Rendering APP/views/elements/link.ctp #6 | 1.20 | |
» » » » » » Rendering APP/views/elements/link.ctp #7 | 0.37 | |
» » » » » » Rendering APP/views/elements/link.ctp #8 | 0.34 | |
» » » » » Rendering APP/views/elements/sidebars/root.ctp | 86.86 | |
» » » » » » Rendering APP/views/elements/sidebars/partials/search.ctp #2 | 3.43 | |
» » » » » » Rendering APP/views/elements/block.ctp #2 | 5.43 | |
» » » » » » » Component initialization and startup #4 | 2.10 | |
Controller action #4 | 0.00 | |
» » » » » » Rendering APP/views/elements/block.ctp #3 | 5.13 | |
» » » » » » » Component initialization and startup #5 | 2.08 | |
Controller action #5 | 0.00 | |
» » » » » » » Rendering APP/views/elements/navigation.ctp #2 | 11.58 | |
» » » » » » » » Component initialization and startup #6 | 1.98 | |
Controller action #6 | 0.00 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #9 | 0.64 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #10 | 0.57 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #11 | 0.49 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #12 | 0.35 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #13 | 0.36 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #14 | 0.47 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #15 | 0.35 | |
» » » » » » » » » Rendering APP/views/elements/link.ctp #16 | 0.35 | |
» » » » » » » » Rendering APP/views/elements/block.ctp #4 | 4.93 | |
» » » » » » » » » Component initialization and startup #7 | 1.92 | |
Controller action #7 | 0.00 |