PvERS: the Pharmacovigilance Electronic Reporting System: Reports

County

County	PQMPs
	15
Baringo	2
Bomet	4
Bung'oma	11
Busia	8
Elgeyo/Marakwet	2
Embu	4
Garissa	1
Homa Bay	3
Isiolo	7
Kajiado	16
Kakamega	18
Kericho	1
Kiambu	46
Kilifi	38
Kirinyaga	14
Kisii	6
Kisumu	17
Kitui	5
Laikipia	10
Lamu	1
Machakos	18
Makueni	5
Mandera	1
Meru	10
Migori	6
Mombasa	50
Murang'a	2
Nairobi County	96
Nakuru	13
Narok	2
Nyeri	15
Samburu	2
Siaya	14
Taita Taveta	9
Tharaka Nithi	4
Trans Nzoia	6
Turkana	8
Uasin Gishu	10
Vihiga	9
West Pokot	2

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

Cake Params
- plugin(null)
- controllerreports
- actionpqmps_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: 4 ms
Total Queries: 1 queries

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 5.43 MB

Message	Memory use
Component initialization	2.50 MB
Controller action start	2.91 MB
Controller render start	3.61 MB
View render complete	4.08 MB

Timers

Total Request Time: 45 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	9.88
Event: Controller.initialize	2.95
Event: Controller.startup	0.73
Controller action	10.59
Event: Controller.beforeRender	5.78
» Processing toolbar data	5.64
Rendering View	7.86
» Event: View.beforeRender	0.03
» Rendering APP/View/Reports/pqmps_by_county.ctp	0.18
» Rendering APP/View/Reports/reports.ctp	5.60
» » Rendering APP/View/Elements/menus/report_public_sidebar.ctp	4.61
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.09
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)
  cnt15
  1(array)
  County(array)
  county_nameBaringo
  id30
  0(array)
  cnt2
  2(array)
  County(array)
  county_nameBomet
  id36
  0(array)
  cnt4
  3(array)
  County(array)
  county_nameBung'oma
  id39
  0(array)
  cnt11
  4(array)
  County(array)
  county_nameBusia
  id40
  0(array)
  cnt8
  5(array)
  County(array)
  county_nameElgeyo/Marakwet
  id28
  0(array)
  cnt2
  6(array)
  County(array)
  county_nameEmbu
  id14
  0(array)
  cnt4
  7(array)
  County(array)
  county_nameGarissa
  id7
  0(array)
  cnt1
  8(array)
  County(array)
  county_nameHoma Bay
  id43
  0(array)
  cnt3
  9(array)
  County(array)
  county_nameIsiolo
  id11
  0(array)
  cnt7
  10(array)
  County(array)
  county_nameKajiado
  id34
  0(array)
  cnt16
  11(array)
  County(array)
  county_nameKakamega
  id37
  0(array)
  cnt18
  12(array)
  County(array)
  county_nameKericho
  id35
  0(array)
  cnt1
  13(array)
  County(array)
  county_nameKiambu
  id22
  0(array)
  cnt46
  14(array)
  County(array)
  county_nameKilifi
  id3
  0(array)
  cnt38
  15(array)
  County(array)
  county_nameKirinyaga
  id20
  0(array)
  cnt14
  16(array)
  County(array)
  county_nameKisii
  id45
  0(array)
  cnt6
  17(array)
  County(array)
  county_nameKisumu
  id42
  0(array)
  cnt17
  18(array)
  County(array)
  county_nameKitui
  id15
  0(array)
  cnt5
  19(array)
  County(array)
  county_nameLaikipia
  id31
  0(array)
  cnt10
  20(array)
  County(array)
  county_nameLamu
  id5
  0(array)
  cnt1
  21(array)
  County(array)
  county_nameMachakos
  id16
  0(array)
  cnt18
  22(array)
  County(array)
  county_nameMakueni
  id17
  0(array)
  cnt5
  23(array)
  County(array)
  county_nameMandera
  id9
  0(array)
  cnt1
  24(array)
  County(array)
  county_nameMeru
  id12
  0(array)
  cnt10
  25(array)
  County(array)
  county_nameMigori
  id44
  0(array)
  cnt6
  26(array)
  County(array)
  county_nameMombasa
  id1
  0(array)
  cnt50
  27(array)
  County(array)
  county_nameMurang'a
  id21
  0(array)
  cnt2
  28(array)
  County(array)
  county_nameNairobi County
  id47
  0(array)
  cnt96
  29(array)
  County(array)
  county_nameNakuru
  id32
  0(array)
  cnt13
  30(array)
  County(array)
  county_nameNarok
  id33
  0(array)
  cnt2
  31(array)
  County(array)
  county_nameNyeri
  id19
  0(array)
  cnt15
  32(array)
  County(array)
  county_nameSamburu
  id25
  0(array)
  cnt2
  33(array)
  County(array)
  county_nameSiaya
  id41
  0(array)
  cnt14
  34(array)
  County(array)
  county_nameTaita Taveta
  id6
  0(array)
  cnt9
  35(array)
  County(array)
  county_nameTharaka Nithi
  id13
  0(array)
  cnt4
  36(array)
  County(array)
  county_nameTrans Nzoia
  id26
  0(array)
  cnt6
  37(array)
  County(array)
  county_nameTurkana
  id23
  0(array)
  cnt8
  38(array)
  County(array)
  county_nameUasin Gishu
  id27
  0(array)
  cnt10
  39(array)
  County(array)
  county_nameVihiga
  id38
  0(array)
  cnt9
  40(array)
  County(array)
  county_nameWest Pokot
  id24
  0(array)
  cnt2
- is_mobile(false)
- root/
- redirdefault
- $request->data(empty)
- $this->validationErrors(array)
  Permission(empty)
  Aro(empty)
  Aco(empty)
  Sadr(empty)
  Pqmp(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/pqmps_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, 29 Jan 2023 21:34:50 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	'52842'
Redirect Url	'/app/webroot/reports/pqmps_by_county'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/reports/pqmps_by_county'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1686100922.471
Request Time	(int) 1686100922

====

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/Pqmp.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: 4 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: 4 ms
Total Queries: 1 queries