Report
SCORE Armenia: Analysis & Recommendations
Armenia 2019
DOWNLOAD...
No post data.
| 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` = 'armenia' LIMIT 1 | 1 | 1 | 3 | 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` = (37) | 1 | 1 | 1 | |
| SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (37) | 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` = (37) ORDER BY `Dataset`.`year` DESC | 7 | 7 | 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` = 37 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` = 37 | 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 | 1 | maybe slow |
| 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` = 'armenia')) LIMIT 1 | 1 | 1 | 0 | |
| 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` = (37) | 1 | 1 | 0 | |
| SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (37) | 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` = (37) ORDER BY `Dataset`.`year` DESC | 7 | 7 | 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` = 37 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` = 37 AND `Source`.`type` = 'data_translations' ORDER BY `Source`.`id` DESC LIMIT 1 | 0 | 0 | 2 | maybe slow |
| SELECT `Country`.`id`, `Country`.`name`, `Country`.`url_param`, `Country`.`parent_id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`parent_id` = 37 | 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` = 'armenia' 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` = (37) | 1 | 1 | 0 | |
| SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (37) | 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` = (37) ORDER BY `Dataset`.`year` DESC | 7 | 7 | 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` = 37 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` = "37") OR (`Publication`.`country_id` IS NULL)) ORDER BY `Publication`.`year` desc, `Publication`.`created` desc LIMIT 1000 | 7 | 7 | 4 | maybe slow |
Peak Memory Use 8.79 MB
| Message | Memory use |
|---|---|
| Component initialization | 1.58 MB |
| Controller action start | 3.04 MB |
| Controller render start | 3.28 MB |
| View render complete | 3.77 MB |
Total Request Time: 156 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 16.91 | |
| Event: Controller.initialize | 45.06 | |
| Event: Controller.startup | 0.60 | |
| Controller action | 12.42 | |
| Event: Controller.beforeRender | 34.08 | |
| » Processing toolbar data | 33.93 | |
| Rendering View | 9.88 | |
| » Event: View.beforeRender | 0.03 | |
| » Rendering APP/View/Publications/index.ctp | 6.14 | |
| » » Rendering APP/View/Elements/publications_table.ctp | 0.34 | |
| » Event: View.afterRender | 0.02 | |
| » Event: View.beforeLayout | 0.03 | |
| » Rendering APP/View/Layouts/app.ctp | 2.77 | |
| 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/armenia/publications |
| Redirect Redirect Script Uri | https://scr1.scoreforpeace.org/en/armenia/publications |
| Redirect Redirect Status | 200 |
| Redirect Https | on |
| Redirect Script Url | /en/armenia/publications |
| Redirect Script Uri | https://scr1.scoreforpeace.org/en/armenia/publications |
| Redirect Status | 200 |
| Https | on |
| Script Url | /en/armenia/publications |
| Script Uri | https://scr1.scoreforpeace.org/en/armenia/publications |
| Http Host | scr1.scoreforpeace.org |
| Http X Forwarded For | 18.119.132.80 |
| 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.119.132.80 |
| 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 | 47712 |
| Redirect Url | /app/webroot/en/armenia/publications |
| Redirect Query String | url=en/armenia/publications |
| Gateway Interface | CGI/1.1 |
| Server Protocol | HTTP/1.0 |
| Request Method | GET |
| Query String | url=en/armenia/publications |
| Request Uri | /en/armenia/publications |
| Script Name | /app/webroot/index.php |
| Php Self | /app/webroot/index.php |
| Request Time Float | 1735480548.3141 |
| Request Time | 1735480548 |
| Argc | 1 |
