Levererar data för dessa sajter:
To view Cookies, add CookieComponent to Controller
Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|---|
SHOW FULL COLUMNS FROM `suppliers` | 7 | 7 | 1 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `users` | 7 | 7 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `uploaded_xmls` | 12 | 12 | 1 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `uploaded_xml_data` | 26 | 26 | 1 | ||
SHOW FULL COLUMNS FROM `objectinfo` | 27 | 27 | 1 | ||
SHOW FULL COLUMNS FROM `detaillist` | 28 | 28 | 1 | ||
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`abbrname`, `Supplier`.`active`, `Supplier`.`ftp_folder`, `Supplier`.`memo`, `Supplier`.`information`, `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`role`, `User`.`supplier_id`, `User`.`active` FROM `suppliers` AS `Supplier` LEFT JOIN `users` AS `User` ON (`User`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`id` = 16 LIMIT 1 | 1 | 1 | 22 | maybe slow | |
SELECT `UploadedXml`.`id`, `UploadedXml`.`xml`, `UploadedXml`.`time`, `UploadedXml`.`upload_method`, `UploadedXml`.`supplier_id`, `UploadedXml`.`year`, `UploadedXml`.`week`, `UploadedXml`.`submitted`, `UploadedXml`.`parsed`, `UploadedXml`.`parse_message`, `UploadedXml`.`imported`, `UploadedXml`.`ignore` FROM `uploaded_xmls` AS `UploadedXml` WHERE `UploadedXml`.`supplier_id` = (16) | 437 | 437 | 209 | maybe slow | |
SELECT `Objectinfo`.`id`, `Objectinfo`.`name`, `Objectinfo`.`url`, `Objectinfo`.`active` FROM `objectinfo` AS `Objectinfo` WHERE `supplierid` = 16 ORDER BY `active` ASC, `name` ASC | 52 | 52 | 1 |
Peak Memory Use 23.37 MB
Message | Memory use |
---|---|
Component intitailization | 6.28 MB |
Controller action start | 6.33 MB |
Controller render start | 22.24 MB |
View render complete | 23.15 MB |
Total Request Time: 461 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 140.32 | |
Component initialization and startup | 2.84 | |
Controller action | 259.43 | |
Render Controller Action | 44.13 | |
» Rendering View | 42.71 | |
» » Rendering APP/views/suppliers/public_list_sites.ctp | 40.37 | |
» » Rendering APP/views/layouts/default.ctp | 1.85 | |
» » » Rendering APP/views/elements/backend/menu.ctp | 0.36 |