Non-Tariff Barriers :: Toolbar Access

{"session":"

Session<\/h2>\n
Config<\/strong>
userAgent<\/strong>1219db9bd1d6c8d98d3787f090c6f46f<\/li>
time<\/strong>1725940497<\/li>
timeout<\/strong>10<\/li>
language<\/strong>en<\/li><\/ul><\/li><\/ul>","request":"
Request<\/h2>\n
Cake Params<\/h4>\n
controller<\/strong>pages<\/li>
action<\/strong>display<\/li>
named<\/strong>(empty)<\/li>
pass<\/strong>
0<\/strong>home<\/li><\/ul><\/li>
plugin<\/strong>(null)<\/li>
url<\/strong>
ext<\/strong>html<\/li>
url<\/strong>\/<\/li><\/ul><\/li>
form<\/strong>(empty)<\/li>
useJsonNative<\/strong>(true)<\/li>
isAjax<\/strong>(false)<\/li><\/ul>\n
$_GET<\/h4>\n
url<\/strong>\/<\/li><\/ul>\n
Cookie<\/h4>\n\t
To view Cookies, add CookieComponent to Controller<\/p>\n\n
Current Route<\/h4>\n
keys<\/strong>(empty)<\/li>
options<\/strong>(empty)<\/li>
defaults<\/strong>
controller<\/strong>pages<\/li>
action<\/strong>display<\/li>
0<\/strong>home<\/li>
plugin<\/strong>(null)<\/li><\/ul><\/li>
template<\/strong>\/<\/li>
_greedy<\/strong>(false)<\/li>
**_compiledRoute<\/strong>#^\/*$#<\/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 `aros`<\/td> <\/td> 7<\/td> 7<\/td> 1<\/td> maybe slow<\/span><\/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 `acos`<\/td> <\/td> 7<\/td> 7<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `aros_acos`<\/td> <\/td> 9<\/td> 9<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints`<\/td> <\/td> 35<\/td> 35<\/td> 1<\/td> <\/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> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `focal_points`<\/td> <\/td> 8<\/td> 8<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `regions`<\/td> <\/td> 2<\/td> 2<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_regions`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `regions_users`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `focal_points_regions`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `focal_points_users`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_focal_points`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `towns`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';<\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `sectors`<\/td> <\/td> 2<\/td> 2<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `sectors_locales`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `roles`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/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> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `location_types`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `locations`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `location_types_locales`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `ntb_types`<\/td> <\/td> 10<\/td> 10<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `ntb_types_locales`<\/td> <\/td> 5<\/td> 5<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `statuses`<\/td> <\/td> 7<\/td> 7<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `statuses_locales`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `ntm_codes`<\/td> <\/td> 5<\/td> 5<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_locales`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/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> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `complaints_tariff_codes`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `tariff_codes_locales`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `emails`<\/td> <\/td> 4<\/td> 4<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `notifications`<\/td> <\/td> 8<\/td> 8<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `notifications_regions`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `countries_notifications`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SELECT `Notification`.`id`, `Notification`.`region_id`, `Notification`.`country_id`, `Notification`.`title`, `Notification`.`description`, `Notification`.`filename`, `Notification`.`created`, `Notification`.`modified` FROM `notifications` AS `Notification` WHERE 1 = 1 ORDER BY `Notification`.`created` DESC, `Notification`.`title` ASC LIMIT 5<\/td> <\/td> 5<\/td> 5<\/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` = 'Notification' AND `Attachment`.`foreign_key` IN ('55117a49-26c0-4974-9fd9-df16c5bdc882', '551179fc-23d0-4149-950c-dd9fc5bdc882', '551178c6-6ef4-4144-bf09-dc9bc5bdc882', '54d4e89e-c0bc-4e5f-b4ab-1c38c5bdc882', '54d245ce-125c-40c3-9f0e-4c68c5bdc882') <\/td> <\/td> 5<\/td> 5<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Region`.`id`, `Region`.`name`, `NotificationsRegion`.`id`, `NotificationsRegion`.`notification_id`, `NotificationsRegion`.`region_id` FROM `regions` AS `Region` JOIN `notifications_regions` AS `NotificationsRegion` ON (`NotificationsRegion`.`notification_id` IN ('55117a49-26c0-4974-9fd9-df16c5bdc882', '551179fc-23d0-4149-950c-dd9fc5bdc882', '551178c6-6ef4-4144-bf09-dc9bc5bdc882', '54d4e89e-c0bc-4e5f-b4ab-1c38c5bdc882', '54d245ce-125c-40c3-9f0e-4c68c5bdc882') AND `NotificationsRegion`.`region_id` = `Region`.`id`) <\/td> <\/td> 10<\/td> 10<\/td> 0<\/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`, `CountriesNotification`.`id`, `CountriesNotification`.`country_id`, `CountriesNotification`.`notification_id` FROM `countries` AS `Country` JOIN `countries_notifications` AS `CountriesNotification` ON (`CountriesNotification`.`notification_id` IN ('55117a49-26c0-4974-9fd9-df16c5bdc882', '551179fc-23d0-4149-950c-dd9fc5bdc882', '551178c6-6ef4-4144-bf09-dc9bc5bdc882', '54d4e89e-c0bc-4e5f-b4ab-1c38c5bdc882', '54d245ce-125c-40c3-9f0e-4c68c5bdc882') AND `CountriesNotification`.`country_id` = `Country`.`id`) <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT (sum(if(`Status`.`nonactionable` = 0, 1, 0))) AS `Complainttotal`, (sum(if(`Status`.`resolved` = 1, 1, 0))) AS `Complaintresolved`, (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<\/td> <\/td> 1<\/td> 1<\/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