Non-Tariff Barriers :: Toolbar Access

{"session":"

Session<\/h2>\n
Config<\/strong>
userAgent<\/strong>1219db9bd1d6c8d98d3787f090c6f46f<\/li>
time<\/strong>1733356176<\/li>
timeout<\/strong>10<\/li>
language<\/strong>en<\/li><\/ul><\/li><\/ul>","request":"
Request<\/h2>\n
Cake Params<\/h4>\n
controller<\/strong>complaints<\/li>
action<\/strong>view<\/li>
uniqueNumber<\/strong>NTB-000-405<\/li>
named<\/strong>(empty)<\/li>
pass<\/strong>
id<\/strong>64070054-2518-47ef-8430-3f21c5bdc882<\/li><\/ul><\/li>
plugin<\/strong>(null)<\/li>
url<\/strong>
ext<\/strong>html<\/li>
url<\/strong>complaint\/NTB-000-405<\/li><\/ul><\/li>
form<\/strong>(empty)<\/li>
useJsonNative<\/strong>(true)<\/li>
isAjax<\/strong>(false)<\/li><\/ul>\n
$_GET<\/h4>\n
url<\/strong>complaint\/NTB-000-405<\/li><\/ul>\n
Cookie<\/h4>\n\t
To view Cookies, add CookieComponent to Controller<\/p>\n\n
Current Route<\/h4>\n
keys<\/strong>
0<\/strong>uniqueNumber<\/li><\/ul><\/li>
options<\/strong>(empty)<\/li>
defaults<\/strong>
controller<\/strong>complaints<\/li>
action<\/strong>view<\/li>
plugin<\/strong>(null)<\/li><\/ul><\/li>
template<\/strong>\/complaint\/:uniqueNumber<\/li>
_greedy<\/strong>(false)<\/li>
**_compiledRoute<\/strong>#^\/complaint\/(?:([^\/]+))[\/]*$#<\/li>
__headerMap<\/strong>
type<\/strong>content_type<\/li>
method<\/strong>request_method<\/li>**
server<\/strong>server_name<\/li><\/ul><\/li><\/ul>","sql_log":"
Sql Logs<\/h2>\n\t\t
\n\t\t
default<\/h4>\n\t\t
Query<\/th> Error<\/th> Affected<\/th> Num. rows<\/th> Took (ms)<\/th> Actions<\/th><\/tr>
SHOW FULL COLUMNS FROM `complaints`<\/td> <\/td> 35<\/td> 35<\/td> 1<\/td> <\/td><\/tr>\n
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';<\/td> <\/td> 1<\/td> 1<\/td> 1<\/td>
<\/div><\/form><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `users`<\/td> <\/td> 23<\/td> 23<\/td> 1<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `countries`<\/td> <\/td> 9<\/td> 9<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `focal_points`<\/td> <\/td> 8<\/td> 8<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `regions`<\/td> <\/td> 2<\/td> 2<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_regions`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `regions_users`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `focal_points_regions`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `focal_points_users`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_focal_points`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `towns`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';<\/td> <\/td> 1<\/td> 1<\/td> 1<\/td>
<\/div><\/form><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `sectors`<\/td> <\/td> 2<\/td> 2<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `sectors_locales`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `roles`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `comments`<\/td> <\/td> 7<\/td> 7<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `attachments`<\/td> <\/td> 8<\/td> 8<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `location_types`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `locations`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `location_types_locales`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `ntb_types`<\/td> <\/td> 10<\/td> 10<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `ntb_types_locales`<\/td> <\/td> 5<\/td> 5<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `statuses`<\/td> <\/td> 7<\/td> 7<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `statuses_locales`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `ntm_codes`<\/td> <\/td> 5<\/td> 5<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_locales`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `sms`<\/td> <\/td> 13<\/td> 13<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `tariff_codes`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_tariff_codes`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `tariff_codes_locales`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `emails`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
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`, `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `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`, `Town`.`id`, `Town`.`country_id`, `Town`.`name`, `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`, `Currency`.`id`, `Currency`.`name`, `Currency`.`short_name`, `Currency`.`fre_name`, `Currency`.`fre_short_name`, `Currency`.`por_name`, `Currency`.`por_short_name`, `Currency`.`currency`, `Currency`.`member`, `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`, `OriginatingCountry`.`id`, `OriginatingCountry`.`name`, `OriginatingCountry`.`short_name`, `OriginatingCountry`.`fre_name`, `OriginatingCountry`.`fre_short_name`, `OriginatingCountry`.`por_name`, `OriginatingCountry`.`por_short_name`, `OriginatingCountry`.`currency`, `OriginatingCountry`.`member`, `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 `users` AS `User` ON (`Complaint`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Complaint`.`country_id` = `Country`.`id`) LEFT JOIN `towns` AS `Town` ON (`Complaint`.`town_id` = `Town`.`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 `countries` AS `Currency` ON (`Complaint`.`currency_id` = `Currency`.`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 `countries` AS `OriginatingCountry` ON (`Complaint`.`country_origin_id` = `OriginatingCountry`.`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 `Complaint`.`id` = '64070054-2518-47ef-8430-3f21c5bdc882' ORDER BY `Complaint`.`modified` DESC LIMIT 1<\/td> <\/td> 1<\/td> 1<\/td> 1<\/td>
<\/div><\/form><\/td><\/tr>\n
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` FROM `countries` AS `Country` WHERE `Country`.`id` = 'GH' <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `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` FROM `countries` AS `ReportingCountry` WHERE `ReportingCountry`.`id` = 'BF' <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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`.`id` = 'other' <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LocationType`.`id`, `LocationType`.`name`, `LocationType`.`order`, `LocationType`.`select_box` FROM `location_types` AS `LocationType` WHERE `LocationType`.`id` = '4ca35901-cc64-46fe-bc12-1e79c0a80305' <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Status`.`id`, `Status`.`name`, `Status`.`order`, `Status`.`default`, `Status`.`rejected`, `Status`.`resolved`, `Status`.`nonactionable` FROM `statuses` AS `Status` WHERE `Status`.`id` = '4cc5a0e4-33ec-4f36-a85c-4278c0a80305' <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `ResolutionComment`.`id`, `ResolutionComment`.`complaint_id`, `ResolutionComment`.`user_id`, `ResolutionComment`.`comment`, `ResolutionComment`.`resolution`, `ResolutionComment`.`created`, `ResolutionComment`.`modified` FROM `comments` AS `ResolutionComment` WHERE `ResolutionComment`.`complaint_id` = '64070054-2518-47ef-8430-3f21c5bdc882' AND `ResolutionComment`.`resolution` = 1 <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `ComplaintsLocale`.`trans_id`, `ComplaintsLocale`.`id`, `ComplaintsLocale`.`complaint`, `ComplaintsLocale`.`locale` FROM `complaints_locales` AS `ComplaintsLocale` WHERE `ComplaintsLocale`.`id` = ('64070054-2518-47ef-8430-3f21c5bdc882') <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Comment`.`id`, `Comment`.`complaint_id`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`resolution`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`resolution` = 0 AND `Comment`.`complaint_id` = ('64070054-2518-47ef-8430-3f21c5bdc882') <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Sms`.`id`, `Sms`.`number`, `Sms`.`user_id`, `Sms`.`complaint_id`, `Sms`.`message`, `Sms`.`incoming`, `Sms`.`read`, `Sms`.`response`, `Sms`.`language`, `Sms`.`parent_id`, `Sms`.`thread_closed`, `Sms`.`created`, `Sms`.`modified` FROM `sms` AS `Sms` WHERE `Sms`.`parent_id` IS NULL AND `Sms`.`complaint_id` = ('64070054-2518-47ef-8430-3f21c5bdc882') <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`class` = 'Complaint' AND `Attachment`.`foreign_key` = ('64070054-2518-47ef-8430-3f21c5bdc882') <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = '64070054-2518-47ef-8430-3f21c5bdc882' AND `ComplaintsTariffCode`.`tariff_code_id` = `TariffCode`.`id`) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Region`.`id`, `Region`.`name`, `ComplaintsRegion`.`id`, `ComplaintsRegion`.`complaint_id`, `ComplaintsRegion`.`region_id` FROM `regions` AS `Region` JOIN `complaints_regions` AS `ComplaintsRegion` ON (`ComplaintsRegion`.`complaint_id` = '64070054-2518-47ef-8430-3f21c5bdc882' AND `ComplaintsRegion`.`region_id` = `Region`.`id`) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id`, `FocalPoint`.`national_address`, `FocalPoint`.`national_contact_number`, `FocalPoint`.`national_email_address`, `FocalPoint`.`private_address`, `FocalPoint`.`private_contact_number`, `FocalPoint`.`private_email_address`, `ComplaintsFocalPoint`.`id`, `ComplaintsFocalPoint`.`complaint_id`, `ComplaintsFocalPoint`.`focal_point_id` FROM `focal_points` AS `FocalPoint` JOIN `complaints_focal_points` AS `ComplaintsFocalPoint` ON (`ComplaintsFocalPoint`.`complaint_id` = '64070054-2518-47ef-8430-3f21c5bdc882' AND `ComplaintsFocalPoint`.`focal_point_id` = `FocalPoint`.`id`) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 <\/td> <\/td> 77<\/td> 77<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Status`.`id`, `Status`.`name` FROM `statuses` AS `Status` WHERE 1 = 1 ORDER BY `Status`.`order` ASC <\/td> <\/td> 7<\/td> 7<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr><\/table>\t\t
Query Explain:<\/h4>\n\t\t
\n\t\t\t <\/a>\n\t\t\t
Click an \"Explain\" link above, to see the query explanation.<\/p>\n\t\t<\/div>\n\t<\/div>\n\t\n