PvERS: the Pharmacovigilance Electronic Reporting System: Reports

County

County	AEFIs
	2
Baringo	3
Bung'oma	323
Busia	88
Embu	49
Garissa	5
Homa Bay	315
Isiolo	4
Kajiado	645
Kakamega	185
Kericho	5
Kiambu	119
Kilifi	650
Kirinyaga	36
Kisii	18
Kisumu	225
Kitui	14
Laikipia	4
Lamu	1
Machakos	208
Makueni	3
Meru	156
Migori	21
Mombasa	146
Murang'a	7
Nairobi County	282
Nakuru	39
Nandi	1
Narok	46
Nyamira	2
Nyandarua	1
Nyeri	261
Samburu	1
Siaya	19
Taita Taveta	2
Tana River	1
Tharaka Nithi	1
Trans Nzoia	2
Turkana	28
Uasin Gishu	993
Vihiga	6
Wajir	1
West Pokot	1

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerreports
- actionaefis_by_county
- named(empty)
- pass(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 0 ms
Total Queries: 1 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `County`.`county_name`, COUNT() as cnt, `County`.`id` FROM `pvers`.`aefis` AS `Aefi` LEFT JOIN `pvers`.`counties` AS `County` ON (`Aefi`.`county_id` = `County`.`id`) WHERE `Aefi`.`submitted` IN (1, 2) AND `Aefi`.`copied` != 1 GROUP BY `County`.`county_name` HAVING COUNT() > 0	43	43	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 5.48 MB

Message	Memory use
Component initialization	2.50 MB
Controller action start	2.91 MB
Controller render start	3.62 MB
View render complete	4.09 MB

Timers

Total Request Time: 40 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	9.67
Event: Controller.initialize	2.89
Event: Controller.startup	0.79
Controller action	6.72
Event: Controller.beforeRender	5.54
» Processing toolbar data	5.40
Rendering View	7.61
» Event: View.beforeRender	0.03
» Rendering APP/View/Reports/aefis_by_county.ctp	0.17
» Rendering APP/View/Reports/reports.ctp	5.63
» » Rendering APP/View/Elements/menus/report_public_sidebar.ctp	4.66
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.11
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- _serializedata
- data(array)
  0(array)
  County(array)
  county_name(null)
  id(null)
  0(array)
  cnt2
  1(array)
  County(array)
  county_nameBaringo
  id30
  0(array)
  cnt3
  2(array)
  County(array)
  county_nameBung'oma
  id39
  0(array)
  cnt323
  3(array)
  County(array)
  county_nameBusia
  id40
  0(array)
  cnt88
  4(array)
  County(array)
  county_nameEmbu
  id14
  0(array)
  cnt49
  5(array)
  County(array)
  county_nameGarissa
  id7
  0(array)
  cnt5
  6(array)
  County(array)
  county_nameHoma Bay
  id43
  0(array)
  cnt315
  7(array)
  County(array)
  county_nameIsiolo
  id11
  0(array)
  cnt4
  8(array)
  County(array)
  county_nameKajiado
  id34
  0(array)
  cnt645
  9(array)
  County(array)
  county_nameKakamega
  id37
  0(array)
  cnt185
  10(array)
  County(array)
  county_nameKericho
  id35
  0(array)
  cnt5
  11(array)
  County(array)
  county_nameKiambu
  id22
  0(array)
  cnt119
  12(array)
  County(array)
  county_nameKilifi
  id3
  0(array)
  cnt650
  13(array)
  County(array)
  county_nameKirinyaga
  id20
  0(array)
  cnt36
  14(array)
  County(array)
  county_nameKisii
  id45
  0(array)
  cnt18
  15(array)
  County(array)
  county_nameKisumu
  id42
  0(array)
  cnt225
  16(array)
  County(array)
  county_nameKitui
  id15
  0(array)
  cnt14
  17(array)
  County(array)
  county_nameLaikipia
  id31
  0(array)
  cnt4
  18(array)
  County(array)
  county_nameLamu
  id5
  0(array)
  cnt1
  19(array)
  County(array)
  county_nameMachakos
  id16
  0(array)
  cnt208
  20(array)
  County(array)
  county_nameMakueni
  id17
  0(array)
  cnt3
  21(array)
  County(array)
  county_nameMeru
  id12
  0(array)
  cnt156
  22(array)
  County(array)
  county_nameMigori
  id44
  0(array)
  cnt21
  23(array)
  County(array)
  county_nameMombasa
  id1
  0(array)
  cnt146
  24(array)
  County(array)
  county_nameMurang'a
  id21
  0(array)
  cnt7
  25(array)
  County(array)
  county_nameNairobi County
  id47
  0(array)
  cnt282
  26(array)
  County(array)
  county_nameNakuru
  id32
  0(array)
  cnt39
  27(array)
  County(array)
  county_nameNandi
  id29
  0(array)
  cnt1
  28(array)
  County(array)
  county_nameNarok
  id33
  0(array)
  cnt46
  29(array)
  County(array)
  county_nameNyamira
  id46
  0(array)
  cnt2
  30(array)
  County(array)
  county_nameNyandarua
  id18
  0(array)
  cnt1
  31(array)
  County(array)
  county_nameNyeri
  id19
  0(array)
  cnt261
  32(array)
  County(array)
  county_nameSamburu
  id25
  0(array)
  cnt1
  33(array)
  County(array)
  county_nameSiaya
  id41
  0(array)
  cnt19
  34(array)
  County(array)
  county_nameTaita Taveta
  id6
  0(array)
  cnt2
  35(array)
  County(array)
  county_nameTana River
  id4
  0(array)
  cnt1
  36(array)
  County(array)
  county_nameTharaka Nithi
  id13
  0(array)
  cnt1
  37(array)
  County(array)
  county_nameTrans Nzoia
  id26
  0(array)
  cnt2
  38(array)
  County(array)
  county_nameTurkana
  id23
  0(array)
  cnt28
  39(array)
  County(array)
  county_nameUasin Gishu
  id27
  0(array)
  cnt993
  40(array)
  County(array)
  county_nameVihiga
  id38
  0(array)
  cnt6
  41(array)
  County(array)
  county_nameWajir
  id8
  0(array)
  cnt1
  42(array)
  County(array)
  county_nameWest Pokot
  id24
  0(array)
  cnt1
- is_mobile(false)
- root/
- redirdefault
- $request->data(empty)
- $this->validationErrors(array)
  Permission(empty)
  Aro(empty)
  Aco(empty)
  Sadr(empty)
  Aefi(empty)
  County(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Session
  3Number
  4SimpleGraph
  5DebugTimer
  6Toolbar
  7Flash
  8HtmlToolbar
====

Environment

App Constants

Constant	Value
CONFIG	'/var/www/html/pvers/app/Config/'
MEDIA	'/var/www/html/pvers/app/webroot/media/'
MEDIA_STATIC	'/var/www/html/pvers/app/webroot/media/static/'
MEDIA_FILTER	'/var/www/html/pvers/app/webroot/media/filter/'
MEDIA_TRANSFER	'/var/www/html/pvers/app/webroot/media/transfer/'
MEDIA_UPLOAD_TMP_DIR	'/tmp'
MEDIA_URL	'media/'
MEDIA_STATIC_URL	'media/static/'
MEDIA_FILTER_URL	'media/filter/'
MEDIA_TRANSFER_URL	'media/transfer/'
HTTP_HOST	'pv.pharmacyboardkenya.org'
HTTP_BASE	'http://pv.pharmacyboardkenya.org'
HTTP_SELF	'/app/webroot/index.php'
HTTP_URI	'/reports/aefis_by_county'
CHOWN_PUBLIC	(int) 504
LF	''
NL	''
CR	''
TB	''
BR	' '
WINDOWS	false
FORMAT_DB_DATETIME	'Y-m-d H:i:s'
FORMAT_DB_DATE	'Y-m-d'
FORMAT_DB_TIME	'H:i:s'
DEFAULT_DATETIME	'0000-00-00 00:00:00'
DEFAULT_DATE	'0000-00-00'
DEFAULT_TIME	'00:00:00'
FILES	'/var/www/html/pvers/app/files/'
LOCALE	'/var/www/html/pvers/app/locale/'
CLASS_USER	'User'
VALID_ALPHA	'/^[a-zA-Z]+$/'
VALID_ALPHA_UNDERSCORES	'/^[a-zA-Z_]+$/'
VALID_ALPHA_MINUS_UNDERSCORES	'/^[a-zA-Z_-]+$/'
VALID_ALPHA_WHITESPACES	'/^[a-zA-Z ]+$/'
VALID_ALPHANUMERIC_UNDERSCORES	'/^[\da-zA-Z_]+$/'
VALID_ALPHANUMERIC_MINUS_UNDERSCORES	'/^[\da-zA-Z_-]+$/'
VALID_ALPHANUMERIC_WHITESPACES	'/^[\da-zA-Z ]+$/'
VALID_ALPHANUMERIC_WHITESPACES_UNDERSCORES	'/^[\da-zA-Z _]+$/'
VALID_NUMERIC_UNDERSCORES	'/^[\d_]+$/'
VALID_NUMERIC_WHITESPACES	'/^[\d ]+$/'
VALID_NUMERIC_WHITESPACES_UNDERSCORES	'/^[\d _]+$/'
VALID_INTEGERS	'/^[\d]+$/'
FORMAT_NICE_YMDHMS	'd.m.Y, H:i:s'
FORMAT_NICE_YMDHM	'd.m.Y, H:i'
FORMAT_NICE_YM	'm.Y'
FORMAT_NICE_YMD	'd.m.Y'
FORMAT_NICE_MD	'd.m.'
FORMAT_NICE_D	'd'
FORMAT_NICE_W_NUM	'w'
FORMAT_NICE_W_ABBR	'D'
FORMAT_NICE_W_FULL	'l'
FORMAT_NICE_M	'm'
FORMAT_NICE_M_ABBR	'M'
FORMAT_NICE_M_FULL	'F'
FORMAT_NICE_Y_ABBR	'y'
FORMAT_NICE_Y	'Y'
FORMAT_NICE_HM	'H:i'
FORMAT_NICE_HMS	'H:i:s'
FORMAT_LOCAL_WA_YMDHMS	'%a, %d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_WF_YMDHMS	'%A, %d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_WA_YMDHM	'%a, %d.%m.%Y, %H:%M'
FORMAT_LOCAL_WF_YMDHM	'%A, %d.%m.%Y, %H:%M'
FORMAT_LOCAL_YMDHMS	'%d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_YMDHM	'%d.%m.%Y, %H:%M'
FORMAT_LOCAL_YMD	'%d.%m.%Y'
FORMAT_LOCAL_MD	'%d.%m.'
FORMAT_LOCAL_D	'%d'
FORMAT_LOCAL_W_NUM	'%w'
FORMAT_LOCAL_W_ABBR	'%a'
FORMAT_LOCAL_W_FULL	'%A'
FORMAT_LOCAL_M	'%m'
FORMAT_LOCAL_M_ABBR	'%b'
FORMAT_LOCAL_M_FULL	'%B'
FORMAT_LOCAL_Y_ABBR	'%y'
FORMAT_LOCAL_YMS_ABBR	'%d.%m.%y'
FORMAT_LOCAL_Y	'%Y'
FORMAT_LOCAL_H	'%H'
FORMAT_LOCAL_S	'%S'
FORMAT_LOCAL_HM	'%H:%M'
FORMAT_LOCAL_HMS	'%H:%M:%S'
CHAR_LESS	'<'
CHAR_GREATER	'>'
CHAR_QUOTE	'"'
CHAR_APOSTROPHE	'''
CHAR_ARROWS	'»'
CHAR_ARROWS_R	'»'
CHAR_ARROWS_L	'«'
CHAR_AVERAGE	'Ø'
CHAR_INFIN	'∞'
CHAR_MILL	'‰'
CHAR_PLUSMN	'±'
CHAR_HELLIP	'…'
CHAR_CIRCA	'≈'
CHAR_CHECKBOX_EMPTY	'☐]'
CHAR_CHECKBOX_MAKRED	'☑'
CHAR_CHECKMARK	'✓'
CHAR_CHECKMARK_BOLD	'✔'
CHAR_BALLOT	'✗'
CHAR_BALLOT_BOLD	'✘'
CHAR_ABOUT	'≈'
CHAR_RPIME	'′'
CHAR_DOUBLE_RPIME	'″'

CakePHP Constants

Constant	Value
APP	'/var/www/html/pvers/app/'
APP_DIR	'app'
APPLIBS	'/var/www/html/pvers/app/Lib/'
CACHE	'/var/www/html/pvers/app/tmp/cache/'
CAKE	'/var/www/html/pvers/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/var/www/html/pvers/lib'
CORE_PATH	'/var/www/html/pvers/lib/'
CAKE_VERSION	'2.10.20'
CSS	'/var/www/html/pvers/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'https://pv.pharmacyboardkenya.org'
IMAGES	'/var/www/html/pvers/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/var/www/html/pvers/app/webroot/js/'
JS_URL	'js/'
LOGS	'/var/www/html/pvers/app/tmp/logs/'
ROOT	'/var/www/html/pvers'
TESTS	'/var/www/html/pvers/app/Test/'
TMP	'/var/www/html/pvers/app/tmp/'
VENDORS	'/var/www/html/pvers/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/var/www/html/pvers/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'5.5.9-1ubuntu4.26'
Redirect Redirect Https	'on'
Redirect Redirect Ssl Tls Sni	'pv.pharmacyboardkenya.org'
Redirect Redirect Status	'200'
Redirect Http Authorization	''
Redirect Https	'on'
Redirect Ssl Tls Sni	'pv.pharmacyboardkenya.org'
Redirect Status	'200'
Http Authorization	''
Https	'on'
Ssl Tls Sni	'pv.pharmacyboardkenya.org'
Http User Agent	'CCBot/2.0 (https://commoncrawl.org/faq/)'
Http Accept	'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'
Http Accept Language	'en-US,en;q=0.5'
Http If Modified Since	'Sun, 26 Jun 2022 04:39:58 GMT'
Http Accept Encoding	'br,gzip'
Http Host	'pv.pharmacyboardkenya.org'
Http Connection	'Keep-Alive'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
Server Signature	' Apache/2.4.7 (Ubuntu) Server at pv.pharmacyboardkenya.org Port 443 '
Server Software	'Apache/2.4.7 (Ubuntu)'
Server Name	'pv.pharmacyboardkenya.org'
Server Addr	'192.168.10.21'
Server Port	'443'
Remote Addr	'44.192.92.49'
Document Root	'/var/www/html/pvers'
Request Scheme	'https'
Context Prefix	''
Context Document Root	'/var/www/html/pvers'
Server Admin	'webmaster@localhost'
Script Filename	'/var/www/html/pvers/app/webroot/index.php'
Remote Port	'33902'
Redirect Url	'/app/webroot/reports/aefis_by_county'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/reports/aefis_by_county'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1686102233.869
Request Time	(int) 1686102233

====

Include
+
Included Files

Include Paths
- 0/var/www/html/pvers/app/Plugin/Media/Lib/mm/src
- 1/var/www/html/pvers/lib
- 3/usr/share/php
- 4/usr/share/pear
- 5-> /var/www/html/pvers/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/TreeBehavior.php
  1CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AclComponent.php
  1CORE/Controller/Component/Acl/DbAcl.php
  2CORE/Controller/Component/Acl/AclInterface.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/SessionComponent.php
  5CORE/Controller/Component/FlashComponent.php
  6CORE/Controller/Component/AuthComponent.php
  7CORE/Controller/Component/Auth/FormAuthenticate.php
  8CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Permission.php
  1CORE/Model/Model.php
  2CORE/Model/BehaviorCollection.php
  3CORE/Model/Aro.php
  4CORE/Model/AclNode.php
  5CORE/Model/Aco.php
  6CORE/Model/ModelBehavior.php
  7CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/ReportsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Sadr.php
  2APP/Model/Aefi.php
  3APP/Model/County.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  CakePdf(array)
  Config(array)
  0CakePdf/Config/bootstrap.php
  1CakePdf/Config/routes.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Media(array)
  Config(array)
  0Media/Config/bootstrap.php
  Plugin(array)
  0Media/Lib/mm/src/Mime/Type.php
  1Media/Lib/mm/src/Mime/Type/Magic/Adapter/Fileinfo.php
  2Media/Lib/mm/src/Mime/Type/Magic/Adapter.php
  3Media/Lib/mm/src/Mime/Type/Glob/Adapter/Memory.php
  4Media/Lib/mm/src/Mime/Type/Glob/Adapter.php
  5Media/Lib/mm/src/Media/Process.php
  6Media/Lib/mm/src/Media/Info.php
  Search(array)
  Component(array)
  0Search/Controller/Component/PrgComponent.php
  Behavior(array)
  0Search/Model/Behavior/SearchableBehavior.php
  Shim(array)
  Config(array)
  0Shim/Config/bootstrap.php
  Tools(array)
  Config(array)
  0Tools/Config/bootstrap.php
====

County

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 0 ms Total Queries: 1 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 0 ms
Total Queries: 1 queries