English
FrançaisPolicy Related Complaints
Number of complaints
- 417 complaints registered
- 373 complaints resolved
- 44 complaints unresolved
To view Cookies, add CookieComponent to Controller
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `aros` | 7 | 7 | 1 | maybe slow | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 1 | ||
| SHOW FULL COLUMNS FROM `acos` | 7 | 7 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `aros_acos` | 9 | 9 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `complaints` | 35 | 35 | 1 | ||
| SHOW FULL COLUMNS FROM `users` | 23 | 23 | 1 | ||
| SHOW FULL COLUMNS FROM `countries` | 9 | 9 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `focal_points` | 8 | 8 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `regions` | 2 | 2 | 0 | ||
| SHOW FULL COLUMNS FROM `complaints_regions` | 3 | 3 | 0 | ||
| SHOW FULL COLUMNS FROM `regions_users` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `focal_points_regions` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `focal_points_users` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `complaints_focal_points` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `towns` | 3 | 3 | 1 | maybe slow | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 1 | ||
| SHOW FULL COLUMNS FROM `sectors` | 2 | 2 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `sectors_locales` | 4 | 4 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `roles` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `comments` | 7 | 7 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `attachments` | 8 | 8 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `location_types` | 4 | 4 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `locations` | 4 | 4 | 0 | ||
| SHOW FULL COLUMNS FROM `location_types_locales` | 4 | 4 | 0 | ||
| SHOW FULL COLUMNS FROM `ntb_types` | 10 | 10 | 0 | ||
| SHOW FULL COLUMNS FROM `ntb_types_locales` | 5 | 5 | 0 | ||
| SHOW FULL COLUMNS FROM `statuses` | 7 | 7 | 0 | ||
| SHOW FULL COLUMNS FROM `statuses_locales` | 4 | 4 | 0 | ||
| SHOW FULL COLUMNS FROM `ntm_codes` | 5 | 5 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `complaints_locales` | 4 | 4 | 0 | ||
| SHOW FULL COLUMNS FROM `sms` | 13 | 13 | 0 | ||
| SHOW FULL COLUMNS FROM `tariff_codes` | 6 | 6 | 0 | ||
| SHOW FULL COLUMNS FROM `complaints_tariff_codes` | 3 | 3 | 0 | ||
| SHOW FULL COLUMNS FROM `tariff_codes_locales` | 4 | 4 | 0 | ||
| SHOW FULL COLUMNS FROM `emails` | 4 | 4 | 0 | ||
| SELECT (sum(if(`Status`.`nonactionable` = 0, 1, 0))) AS `Complaint__total`, (sum(if(`Status`.`resolved` = 1, 1, 0))) AS `Complaint__resolved`, (sum(if(`Status`.`resolved` = 0 AND `Status`.`nonactionable` = 0, 1, 0))) AS `Complaint__progress` FROM `complaints` AS `Complaint` LEFT JOIN `statuses` AS `Status` ON (`Complaint`.`status_id` = `Status`.`id`) WHERE `Status`.`default` = 0 AND `Status`.`rejected` = 0 ORDER BY `Complaint`.`modified` DESC LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 14.70 MB
| Message | Memory use |
|---|---|
| Component initialization | 6.61 MB |
| Controller action start | 6.82 MB |
| Controller render start | 10.04 MB |
| View render complete | 11.27 MB |
Total Request Time: 277 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 89.91 | |
| Component initialization and startup | 14.84 | |
| Controller action | 124.25 | |
| Render Controller Action | 19.74 | |
| » Rendering View | 19.12 | |
| » » Rendering APP/views/pages/policy_rel.ctp | 8.00 | |
| » » » Rendering APP/views/elements/stats_summary.ctp | 1.43 | |
| » » » » Complaint->find() | 0.97 | |
| » » Rendering APP/views/layouts/default.ctp | 10.92 | |
| » » » Rendering APP/views/elements/dock_menu.ctp | 0.21 | |
| » » » Rendering APP/views/elements/ntbbanner.ctp | 4.71 | |
| » » » » Rendering APP/views/elements/login_banner.ctp | 3.15 | |
| » » » » » Rendering APP/views/elements/login.ctp | 2.86 | |
| » » » Rendering APP/views/elements/ntbmenu.ctp | 4.82 | |
| » » » Rendering APP/views/elements/ntbfooter.ctp | 0.08 |