Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = 'bosnia' LIMIT 1	1	1	5	maybe slow
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (15)	2	2	1	maybe slow
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (15)	1	1	1
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (15) ORDER BY `Dataset`.`year` DESC	27	27	2	maybe slow
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 15 AND `CountriesLanguage`.`language_id` = `Language`.`id`)	1	1	0
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id`, `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`countries_languages` AS `CountryLanguage` LEFT JOIN `score-1`.`languages` AS `Language` ON (`CountryLanguage`.`language_id` = `Language`.`id`) WHERE `CountryLanguage`.`country_id` = 15	1	1	0
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`languages` AS `Language` WHERE 1 = 1	6	6	0
SELECT `Language`.`code`, `Language`.`name` FROM `score-1`.`languages` AS `Language` WHERE 1 = 1	6	6	0
SELECT `Country`.`url_param`, `Country`.`name`, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`in_menu` = '1' AND `Country`.`is_published` = '1' ORDER BY `Country`.`weight` ASC	9	9	1	maybe slow
SELECT Country.id,Country.keywords,Country.description,Country.name,Country.title,Country.logos,Country.data_translations,Country.show_pages,Country.parent_id,Country.svg_map, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE ((`Country`.`id` IS NULL) OR (`Country`.`url_param` = 'bosnia')) LIMIT 1	1	1	1
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (15)	2	2	0
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (15)	1	1	0
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (15) ORDER BY `Dataset`.`year` DESC	27	27	0
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 15 AND `CountriesLanguage`.`language_id` = `Language`.`id`)	1	1	0
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards`, `Source`.`id`, `Source`.`url`, `Source`.`html`, `Source`.`source`, `Source`.`name`, `Source`.`type`, (url) AS `Source__source_path` FROM `score-1`.`datasets` AS `Dataset` LEFT JOIN `score-1`.`sources` AS `Source` ON (`Dataset`.`source_id` = `Source`.`id`) WHERE `country` = 15 AND `Source`.`type` = 'data_translations' ORDER BY `Source`.`id` DESC LIMIT 1	0	0	3	maybe slow
SELECT `Country`.`id`, `Country`.`name`, `Country`.`url_param`, `Country`.`parent_id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`parent_id` = 15	0	0	0
SELECT `Country`.`id`, `Country`.`name` FROM `score-1`.`countries` AS `Country` WHERE 1 = 1	18	18	0
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = 'bosnia' LIMIT 1	1	1	2	maybe slow
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (15)	2	2	0
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (15)	1	1	0
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (15) ORDER BY `Dataset`.`year` DESC	27	27	1
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 15 AND `CountriesLanguage`.`language_id` = `Language`.`id`)	1	1	0
SELECT `Country`.`id`, `Country`.`name` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`in_menu` = "1" AND `Country`.`is_published` = "1"	9	9	0
SELECT `Publication`.`id`, `Publication`.`country_id`, `Publication`.`year`, `Publication`.`group_id`, `Publication`.`type_id`, `Publication`.`dir`, `Publication`.`pub_file`, `Publication`.`pub_thumb`, `Publication`.`language_code`, `Publication`.`created`, `Publication`.`modified`, `Publication`.`is_published`, `Publication`.`title`, `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`publications` AS `Publication` LEFT JOIN `score-1`.`countries` AS `Country` ON (`Publication`.`country_id` = `Country`.`id`) WHERE `Publication`.`is_published` = 1 AND `Publication`.`language_code` = "en" AND ((`Publication`.`country_id` = "15") OR (`Publication`.`country_id` IS NULL)) ORDER BY `Publication`.`year` desc, `Publication`.`created` desc LIMIT 1000	7	7	8	maybe slow

Message	Memory use
Component initialization	1.58 MB
Controller action start	3.45 MB
Controller render start	4.05 MB
View render complete	4.54 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	23.66
Event: Controller.initialize	47.59
Event: Controller.startup	0.69
Controller action	18.10
Event: Controller.beforeRender	19.33
» Processing toolbar data	19.11
Rendering View	7.00
» Event: View.beforeRender	0.05
» Rendering APP/View/Publications/index.ctp	2.63
» » Rendering APP/View/Elements/publications_table.ctp	0.15
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/app.ctp	3.42
Event: View.afterLayout	0.00

Constant	Value
DB_HOST	localhost
DB_NAME	score-1
DB_USER	root
DB_PASS	e5503e0127d4cedda7681f04fb26f1f6

Constant	Value
APP	/srv/users/score/apps/score-1/public/app/
APP_DIR	app
APPLIBS	/srv/users/score/apps/score-1/public/app/Lib/
CACHE	/srv/users/score/apps/score-1/public/app/tmp/cache/
CAKE	/srv/users/score/apps/score-1/public/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/srv/users/score/apps/score-1/public/lib
CORE_PATH	/srv/users/score/apps/score-1/public/lib/
CAKE_VERSION	2.5.3
CSS	/srv/users/score/apps/score-1/public/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://scr1.scoreforpeace.org
IMAGES	/srv/users/score/apps/score-1/public/app/webroot/img/
IMAGES_URL	img/
JS	/srv/users/score/apps/score-1/public/app/webroot/js/
JS_URL	js/
LOGS	/srv/users/score/apps/score-1/public/app/tmp/logs/
ROOT	/srv/users/score/apps/score-1/public
TESTS	/srv/users/score/apps/score-1/public/app/Test/
TMP	/srv/users/score/apps/score-1/public/app/tmp/
VENDORS	/srv/users/score/apps/score-1/public/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/srv/users/score/apps/score-1/public/app/webroot/

Environment Variable	Value
Php Version	5.6.40
Tmp	/srv/users/score/tmp/score-1
Temp	/srv/users/score/tmp/score-1
Tmpdir	/srv/users/score/tmp/score-1
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
User	score
Home	/srv/users/score
Fcgi Role	RESPONDER
Redirect Redirect Https	on
Redirect Redirect Script Url	/en/bosnia/publications
Redirect Redirect Script Uri	https://scr1.scoreforpeace.org/en/bosnia/publications
Redirect Redirect Status	200
Redirect Https	on
Redirect Script Url	/en/bosnia/publications
Redirect Script Uri	https://scr1.scoreforpeace.org/en/bosnia/publications
Redirect Status	200
Https	on
Script Url	/en/bosnia/publications
Script Uri	https://scr1.scoreforpeace.org/en/bosnia/publications
Http Host	scr1.scoreforpeace.org
Http X Forwarded For	18.221.217.100
Http X Forwarded Ssl	on
Http X Forwarded Proto	https
Http Connection	close
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Ld Library Path	/opt/sp/apache/lib:/opt/sp/apache/lib
Server Signature
Server Software	Apache/2.4.62 (Unix) OpenSSL/1.1.1
Server Name	scr1.scoreforpeace.org
Server Addr	127.0.0.1
Server Port	443
Remote Addr	18.221.217.100
Document Root	/srv/users/score/apps/score-1/public
Request Scheme	https
Context Prefix
Context Document Root	/srv/users/score/apps/score-1/public
Server Admin	webmaster@
Script Filename	/srv/users/score/apps/score-1/public/app/webroot/index.php
Remote Port	21726
Redirect Url	/app/webroot/en/bosnia/publications
Redirect Query String	url=en/bosnia/publications
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String	url=en/bosnia/publications
Request Uri	/en/bosnia/publications
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1735480865.7266
Request Time	1735480865
Argc	1

Publications

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 25 ms Total Queries: 24 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 25 ms
Total Queries: 24 queries