Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
session_start - [internal], line ??
CakeSession::__startSession() - CORE/cake/libs/cake_session.php, line 587
CakeSession::start() - CORE/cake/libs/cake_session.php, line 219
SessionComponent::__start() - CORE/cake/libs/controller/components/session.php, line 287
SessionComponent::read() - CORE/cake/libs/controller/components/session.php, line 137
ToolbarComponent::initialize() - CORE/plugins/debug_kit/controllers/components/toolbar.php, line 116
Component::initialize() - CORE/cake/libs/controller/component.php, line 98
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 521
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Non-Tariff Barriers (NTBs) refer to restrictions that result from prohibitions, conditions, or specific market requirements that make importation or exportation of products difficult and/or costly.
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
0
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
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
SHOW FULL COLUMNS FROM `notifications`
8
8
1
maybe slow
SHOW FULL COLUMNS FROM `notifications_regions`
3
3
0
SHOW FULL COLUMNS FROM `countries_notifications`
3
3
1
maybe slow
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
5
5
0
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')
5
5
0
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`)
10
10
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`, `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`)
1
1
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
Query Explain:
Click an "Explain" link above, to see the query explanation.
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
[main] - [internal], line ??
Warning: Illegal string offset 'file' in /var/www/common/frameworks/cake1.3/plugins/debug_kit/vendors/debug_kit_debugger.php on line 358
Warning: Illegal string offset 'line' in /var/www/common/frameworks/cake1.3/plugins/debug_kit/vendors/debug_kit_debugger.php on line 358
Warning (2): Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/opt/remi/php56/root/var/lib/php/session) [Unknown, line ??]