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 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `complaints_regions` | 3 | 3 | 1 | maybe slow | |
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 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `location_types_locales` | 4 | 4 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `ntb_types` | 10 | 10 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `ntb_types_locales` | 5 | 5 | 1 | maybe slow | |
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 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `sms` | 13 | 13 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `tariff_codes` | 6 | 6 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `complaints_tariff_codes` | 3 | 3 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `tariff_codes_locales` | 4 | 4 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `emails` | 4 | 4 | 1 | maybe slow | |
SELECT COUNT(*) AS `count` FROM `complaints` AS `Complaint` LEFT JOIN `countries` AS `Country` ON (`Complaint`.`country_id` = `Country`.`id`) LEFT JOIN `regions` AS `ImposingRegion` ON (`Complaint`.`imposing_region_id` = `ImposingRegion`.`id`) LEFT JOIN `countries` AS `ReportingCountry` ON (`Complaint`.`reporting_country_id` = `ReportingCountry`.`id`) LEFT JOIN `regions` AS `ReportingRegion` ON (`Complaint`.`reporting_region_id` = `ReportingRegion`.`id`) LEFT JOIN `locations` AS `Location` ON (`Complaint`.`location_id` = `Location`.`id`) LEFT JOIN `ntb_types` AS `NtbType` ON (`Complaint`.`ntb_type_id` = `NtbType`.`id`) LEFT JOIN `ntm_codes` AS `NtmCode` ON (`Complaint`.`ntm_code_id` = `NtmCode`.`id`) LEFT JOIN `location_types` AS `LocationType` ON (`Complaint`.`location_type_id` = `LocationType`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Complaint`.`status_id` = `Status`.`id`) LEFT JOIN `comments` AS `ResolutionComment` ON (`ResolutionComment`.`complaint_id` = `Complaint`.`id` AND `ResolutionComment`.`resolution` = 1) WHERE `Status`.`default` = 0 AND `Status`.`rejected` = 0 AND `Status`.`resolved` = 1 AND `Status`.`nonactionable` = 0 | 1 | 1 | 0 | ||
SELECT `Complaint`.`id`, `Complaint`.`unique_number`, `Complaint`.`user_id`, `Complaint`.`user_details`, `Complaint`.`user_email`, `Complaint`.`complaint`, `Complaint`.`original_complaint`, `Complaint`.`country_id`, `Complaint`.`town_id`, `Complaint`.`imposing_region_id`, `Complaint`.`reporting_country_id`, `Complaint`.`reporting_region_id`, `Complaint`.`location_type_id`, `Complaint`.`location_id`, `Complaint`.`location_other`, `Complaint`.`date_of_incident`, `Complaint`.`ntb_type_id`, `Complaint`.`ntb_type_other`, `Complaint`.`ntm_code_id`, `Complaint`.`status_id`, `Complaint`.`product_description`, `Complaint`.`country_origin_id`, `Complaint`.`currency_id`, `Complaint`.`value`, `Complaint`.`original_locale`, `Complaint`.`is_spam`, `Complaint`.`resolved_date`, `Complaint`.`created`, `Complaint`.`created_by`, `Complaint`.`modified`, `Complaint`.`modified_by`, `Complaint`.`progress_update`, `Complaint`.`offline`, `Complaint`.`offline_comment`, `Complaint`.`policy`, `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member`, `ImposingRegion`.`id`, `ImposingRegion`.`name`, `ReportingCountry`.`id`, `ReportingCountry`.`name`, `ReportingCountry`.`short_name`, `ReportingCountry`.`fre_name`, `ReportingCountry`.`fre_short_name`, `ReportingCountry`.`por_name`, `ReportingCountry`.`por_short_name`, `ReportingCountry`.`currency`, `ReportingCountry`.`member`, `ReportingRegion`.`id`, `ReportingRegion`.`name`, `Location`.`id`, `Location`.`name`, `Location`.`location_type_id`, `Location`.`country_id`, `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName`, `NtmCode`.`id`, `NtmCode`.`level`, `NtmCode`.`code`, `NtmCode`.`description`, `NtmCode`.`parent_id`, `LocationType`.`id`, `LocationType`.`name`, `LocationType`.`order`, `LocationType`.`select_box`, `Status`.`id`, `Status`.`name`, `Status`.`order`, `Status`.`default`, `Status`.`rejected`, `Status`.`resolved`, `Status`.`nonactionable`, `ResolutionComment`.`id`, `ResolutionComment`.`complaint_id`, `ResolutionComment`.`user_id`, `ResolutionComment`.`comment`, `ResolutionComment`.`resolution`, `ResolutionComment`.`created`, `ResolutionComment`.`modified` FROM `complaints` AS `Complaint` LEFT JOIN `countries` AS `Country` ON (`Complaint`.`country_id` = `Country`.`id`) LEFT JOIN `regions` AS `ImposingRegion` ON (`Complaint`.`imposing_region_id` = `ImposingRegion`.`id`) LEFT JOIN `countries` AS `ReportingCountry` ON (`Complaint`.`reporting_country_id` = `ReportingCountry`.`id`) LEFT JOIN `regions` AS `ReportingRegion` ON (`Complaint`.`reporting_region_id` = `ReportingRegion`.`id`) LEFT JOIN `locations` AS `Location` ON (`Complaint`.`location_id` = `Location`.`id`) LEFT JOIN `ntb_types` AS `NtbType` ON (`Complaint`.`ntb_type_id` = `NtbType`.`id`) LEFT JOIN `ntm_codes` AS `NtmCode` ON (`Complaint`.`ntm_code_id` = `NtmCode`.`id`) LEFT JOIN `location_types` AS `LocationType` ON (`Complaint`.`location_type_id` = `LocationType`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Complaint`.`status_id` = `Status`.`id`) LEFT JOIN `comments` AS `ResolutionComment` ON (`ResolutionComment`.`complaint_id` = `Complaint`.`id` AND `ResolutionComment`.`resolution` = 1) WHERE `Status`.`default` = 0 AND `Status`.`rejected` = 0 AND `Status`.`resolved` = 1 AND `Status`.`nonactionable` = 0 ORDER BY `Complaint`.`unique_number` asc LIMIT 20, 20 | 20 | 20 | 0 | ||
SELECT `ComplaintsLocale`.`trans_id`, `ComplaintsLocale`.`id`, `ComplaintsLocale`.`complaint`, `ComplaintsLocale`.`locale` FROM `complaints_locales` AS `ComplaintsLocale` WHERE `ComplaintsLocale`.`id` IN ('5a7c4c98-bf38-458f-9f97-31e2c0a80304', '5a7c4dca-3198-47ab-9190-31e9c0a80304', '5a7c4ece-a734-4736-86a7-5673c0a80304', '5a7dabb0-d078-430a-848e-569ec0a80304', '5a815bdc-3ec8-4ac7-8813-6c91c0a80304', '5a815e32-57d4-4f25-b139-6c8cc0a80304', '5a815fd3-cc28-48b3-a0ca-7077c0a80304', '5a81632f-15d4-4f1e-97e9-6c90c0a80304', '5a817759-88e8-4b17-a769-6c91c0a80304', '5a817879-ecf0-4a51-a4db-6c92c0a80304', '5a817992-2178-4635-944d-6c8dc0a80304', '5a817a66-8884-4fc8-8d07-6c8fc0a80304', '5a817b0a-1bac-4774-9f62-6c92c0a80304', '5a817be3-6450-4d6e-a424-6c8dc0a80304', '5a817c99-86ac-4dcf-99b4-6c8fc0a80304', '5a817f0f-2158-4c9e-b8ef-6c92c0a80304', '5a817fd9-139c-4dee-a9eb-6c8dc0a80304', '5a8be65b-9f94-4d7c-bbb7-20e6c5bdc882', '5a8be9b7-49a8-4797-9312-0ac4c5bdc882', '5a8beee1-260c-4631-851d-35d6c5bdc882') | 2 | 2 | 0 | ||
SELECT `TariffCode`.`id`, `TariffCode`.`heading`, `TariffCode`.`description`, `TariffCode`.`parent_id`, `TariffCode`.`lft`, `TariffCode`.`rght`, (concat(`TariffCode`.`heading`, ": ", `TariffCode`.`description`)) AS `TariffCode__name`, `ComplaintsTariffCode`.`id`, `ComplaintsTariffCode`.`complaint_id`, `ComplaintsTariffCode`.`tariff_code_id` FROM `tariff_codes` AS `TariffCode` JOIN `complaints_tariff_codes` AS `ComplaintsTariffCode` ON (`ComplaintsTariffCode`.`complaint_id` IN ('5a7c4c98-bf38-458f-9f97-31e2c0a80304', '5a7c4dca-3198-47ab-9190-31e9c0a80304', '5a7c4ece-a734-4736-86a7-5673c0a80304', '5a7dabb0-d078-430a-848e-569ec0a80304', '5a815bdc-3ec8-4ac7-8813-6c91c0a80304', '5a815e32-57d4-4f25-b139-6c8cc0a80304', '5a815fd3-cc28-48b3-a0ca-7077c0a80304', '5a81632f-15d4-4f1e-97e9-6c90c0a80304', '5a817759-88e8-4b17-a769-6c91c0a80304', '5a817879-ecf0-4a51-a4db-6c92c0a80304', '5a817992-2178-4635-944d-6c8dc0a80304', '5a817a66-8884-4fc8-8d07-6c8fc0a80304', '5a817b0a-1bac-4774-9f62-6c92c0a80304', '5a817be3-6450-4d6e-a424-6c8dc0a80304', '5a817c99-86ac-4dcf-99b4-6c8fc0a80304', '5a817f0f-2158-4c9e-b8ef-6c92c0a80304', '5a817fd9-139c-4dee-a9eb-6c8dc0a80304', '5a8be65b-9f94-4d7c-bbb7-20e6c5bdc882', '5a8be9b7-49a8-4797-9312-0ac4c5bdc882', '5a8beee1-260c-4631-851d-35d6c5bdc882') AND `ComplaintsTariffCode`.`tariff_code_id` = `TariffCode`.`id`) | 0 | 0 | 0 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member`, `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `countries` AS `Country` LEFT JOIN `focal_points` AS `FocalPoint` ON (`FocalPoint`.`country_id` = `Country`.`id`) WHERE `Country`.`member` = 1 ORDER BY `name` ASC | 15 | 15 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'BJ' | 1 | 1 | 0 | ||
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da7b-3aac-4895-879c-3ac9c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`) | 1 | 1 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'BF' | 1 | 1 | 0 | ||
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5418fa29-b610-4f6a-bb28-0612c0a8e186' AND `FocalPointsRegion`.`region_id` = `Region`.`id`) | 1 | 1 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'CV' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'CI' | 1 | 1 | 0 | ||
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da84-7460-4ef7-9eb6-39fac0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`) | 1 | 1 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GM' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GH' | 1 | 1 | 0 | ||
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da69-13d8-49d0-ad22-3ac9c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`) | 1 | 1 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GN' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GW' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'LR' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'ML' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'NE' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'NG' | 1 | 1 | 0 | ||
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da8c-b374-4d89-96a0-39f9c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`) | 1 | 1 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'SN' | 1 | 1 | 0 | ||
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5418fa08-f9f0-4b67-9e2d-0545c0a8e186' AND `FocalPointsRegion`.`region_id` = `Region`.`id`) | 1 | 1 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'SL' | 0 | 0 | 0 | ||
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'TG' | 1 | 1 | 0 | ||
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da95-21e4-4eff-8899-39f8c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`) | 1 | 1 | 0 | ||
SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE 1 = 1 | 2 | 2 | 0 | ||
SELECT `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName` FROM `ntb_types` AS `NtbType` WHERE `NtbType`.`allow` = 1 ORDER BY `NtbType`.`position` ASC | 77 | 77 | 0 | ||
SELECT `Status`.`id`, `Status`.`name` FROM `statuses` AS `Status` WHERE `Status`.`default` = 0 AND `Status`.`rejected` = 0 ORDER BY `Status`.`order` ASC | 5 | 5 | 0 | ||
SELECT `Status`.`id`, `Status`.`name` FROM `statuses` AS `Status` WHERE 1 = 1 ORDER BY `Status`.`order` ASC | 7 | 7 | 0 |
Peak Memory Use 17.28 MB
Message | Memory use |
---|---|
Component initialization | 10.20 MB |
Controller action start | 10.26 MB |
Controller render start | 11.68 MB |
View render complete | 13.53 MB |
Total Request Time: 414 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 225.31 | |
Component initialization and startup | 1.33 | |
Controller action | 43.79 | |
» Complaint->find() | 4.21 | |
» Complaint->find() #2 | 15.02 | |
» Country->find() | 5.50 | |
» Region->find() | 0.21 | |
» NtbType->find() | 3.67 | |
» NtbType->find() #2 | 3.75 | |
» Status->find() | 0.36 | |
» Status->find() #2 | 0.23 | |
Render Controller Action | 61.61 | |
» Rendering View | 59.81 | |
» » Rendering APP/views/complaints/index.ctp | 49.21 | |
» » » Rendering CORE/plugins/octoplus/views/elements/paging.ctp | 3.54 | |
» » Rendering APP/views/layouts/default.ctp | 10.40 | |
» » » Rendering APP/views/elements/dock_menu.ctp | 0.22 | |
» » » Rendering APP/views/elements/ntbbanner.ctp | 4.43 | |
» » » » Rendering APP/views/elements/login_banner.ctp | 2.94 | |
» » » » » Rendering APP/views/elements/login.ctp | 2.67 | |
» » » Rendering APP/views/elements/ntbmenu.ctp | 4.63 | |
» » » Rendering APP/views/elements/ntbfooter.ctp | 0.07 |