PvERS: the Pharmacovigilance Electronic Reporting System: Reports

REPORTS
SUSPECTED ADVERSE DRUG REACTIONS
SADR
ADVERSE EVENT FOLLOWING IMMUNIZATION
AEFI
POOR QUALITY HEALTH PRODUCTS AND TECHNOLOGIES
PQHPTs
Medical Devices
Medical devices
Medication Errors
Medications
Blood Transfusion
Transfusion
E2B
E2B

Generic (intended)

Generic (intended)	Medication Errors
-	3
-abc3tcdtg	1
3TC	3
Abacavir	19
Abacavir+lamivudine+dolutegravir	1
Abacavir, lavivudine,deglutegravir	1
Abacavir,Lamivudine,Dolutegravir	1
Abacavir/Lamivudine/Dolutegravir	3
Abacavir/lamovodine/dolutegravir	1
Abacavirxh,lamividine,delougatravir	1
ABC	16
ABC (Abacavir)	1
ABC ,3TC DTG	1
ABC /3TC/DTG	2
ABC 3TC DTG	1
ABC+3T	1
ABC+3TC+ DTG	1
Abc+3tc+dtg	20
ABC+3TC+DTG+	1
Abc,3tc,dtg	3
ABC/3T /DTG	1
ABC/3TC	4
ABC/3TC , DTG	1
ABC/3TC and DTG	1
ABC/3TC, DTG	1
ABC/3TC/DTG	50
Abc/3TC/Efv	1
ABC/3TC/TDG	2
ABC/3TC120/60mg DTG 50mg	1
ABC/3TCplus DTG	1
ABC/3TG/DTG	1
Abc3tcdtg	1
ABC\3TC\DTG	1
ABC_3TC/Dtg	1
ABZ 1tab	1
Acetazolamide	1
ART	1
artesunate	13
artesunate 60mg vial	1
Atenolol	1
Azithromycin	1
CF2G	1
Chlorpheniramine	1
correct low albumin levels	1
DEC	3
Deltagravir	1
Diclofenac	1
Dolutegraviramivufine/tenofovir	1
Dtg	11
G	1
G1	1
Gen I	1
Generic name I	2
Genx	1
H	1
Iv artesunate	1
measles rubella vaccine	1
metformin	1
Mionate	1
N/A	3
NA	1
Paracetamol	1
Sodium Valproate	3
Sodium Vaproate	1
TDF	5
TDF+3TC	1
TDF+3TC+	1
TDF+3TC+ABC	2
TDF+3TC+DTC+DTG	1
TDF+3TC+DTG	3
Tdf+3tc+dtg+	1
TDF, 3TC	1
Tdf,3tc dtg	1
Tdf,3tc,dtg	1
TDF/3TC/DTG	11
Tenofovir	4
Tenofovir/Lamivudine/Dolutegravir	2
Tenovir,lamuvidine dolutegravir	1
TLD	4
We	1

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

Cake Params
- plugin(null)
- controllerreports
- actionmedications_by_generici
- 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: 2 ms
Total Queries: 3 queries

Query	Affected	Num. rows	Took (ms)
SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup'	235	235	1
SELECT `MedicationProduct`.`generic_name_i` AS `generic_name_i`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`created` > '2020-04-01 08:08:08' AND `MedicationProduct`.`generic_name_i` > '' AND `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 341, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674, 680, 683, 741, 778, 780, 781, 783, 785, 786, 791, 792, 793, 794, 796, 805, 808, 811, 812, 813, 814, 817, 818, 819, 821, 824, 827, 828, 829, 831, 832, 833, 835, 838, 845, 847, 849, 852, 853, 855, 869, 870, 871, 873, 876, 882, 886, 900, 901, 911, 912, 913, 914, 915, 916, 917, 919, 921, 922, 939, 943, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 958, 960, 962, 963, 964, 968, 971, 974, 976, 980, 988, 989, 990, 991, 992, 993, 1002, 1004, 1005, 1016, 1017, 1021, 1022, 1056, 1058, 1060, 1075, 1078, 1079, 1080, 1081, 1085, 1089, 1092, 1094, 1096, 1097, 1106, 1107, 1113, 1115, 1116, 1117, 1126, 1127, 1128, 1131, 1132, 1133, 1134, 1135, 1136, 1137) GROUP BY `MedicationProduct`.`generic_name_i` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0	80	80	1
SELECT `County`.`id`, `County`.`county_name` FROM `pvers`.`counties` AS `County` WHERE 1 = 1 ORDER BY `County`.`county_name` ASC	47	47	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 6.05 MB

Message	Memory use
Component initialization	2.51 MB
Controller action start	2.96 MB
Controller render start	3.84 MB
View render complete	4.28 MB

Timers

Total Request Time: 45 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	6.90
Event: Controller.initialize	1.19
Event: Controller.startup	0.39
Controller action	12.30
Event: Controller.beforeRender	5.94
» Processing toolbar data	5.86
Rendering View	9.58
» Event: View.beforeRender	0.03
» Rendering APP/View/Reports/medications_by_generici.ctp	0.28
» Rendering APP/View/Reports/reports.ctp	7.06
» » Rendering APP/View/Elements/menus/report_public_sidebar.ctp	5.88
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.66
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- _serializedata
- data(array)
  0(array)
  MedicationProduct(array)
  generic_name_i-
  0(array)
  cnt3
  1(array)
  MedicationProduct(array)
  generic_name_i-abc3tcdtg
  0(array)
  cnt1
  2(array)
  MedicationProduct(array)
  generic_name_i3TC
  0(array)
  cnt3
  3(array)
  MedicationProduct(array)
  generic_name_iAbacavir
  0(array)
  cnt19
  4(array)
  MedicationProduct(array)
  generic_name_iAbacavir+lamivudine+dolutegravir
  0(array)
  cnt1
  5(array)
  MedicationProduct(array)
  generic_name_iAbacavir, lavivudine,deglutegravir
  0(array)
  cnt1
  6(array)
  MedicationProduct(array)
  generic_name_iAbacavir,Lamivudine,Dolutegravir
  0(array)
  cnt1
  7(array)
  MedicationProduct(array)
  generic_name_iAbacavir/Lamivudine/Dolutegravir
  0(array)
  cnt3
  8(array)
  MedicationProduct(array)
  generic_name_iAbacavir/lamovodine/dolutegravir
  0(array)
  cnt1
  9(array)
  MedicationProduct(array)
  generic_name_iAbacavirxh,lamividine,delougatravir
  0(array)
  cnt1
  10(array)
  MedicationProduct(array)
  generic_name_iABC
  0(array)
  cnt16
  11(array)
  MedicationProduct(array)
  generic_name_iABC (Abacavir)
  0(array)
  cnt1
  12(array)
  MedicationProduct(array)
  generic_name_iABC ,3TC DTG
  0(array)
  cnt1
  13(array)
  MedicationProduct(array)
  generic_name_iABC /3TC/DTG
  0(array)
  cnt2
  14(array)
  MedicationProduct(array)
  generic_name_iABC 3TC DTG
  0(array)
  cnt1
  15(array)
  MedicationProduct(array)
  generic_name_iABC+3T
  0(array)
  cnt1
  16(array)
  MedicationProduct(array)
  generic_name_iABC+3TC+ DTG
  0(array)
  cnt1
  17(array)
  MedicationProduct(array)
  generic_name_iAbc+3tc+dtg
  0(array)
  cnt20
  18(array)
  MedicationProduct(array)
  generic_name_iABC+3TC+DTG+
  0(array)
  cnt1
  19(array)
  MedicationProduct(array)
  generic_name_iAbc,3tc,dtg
  0(array)
  cnt3
  20(array)
  MedicationProduct(array)
  generic_name_iABC/3T /DTG
  0(array)
  cnt1
  21(array)
  MedicationProduct(array)
  generic_name_iABC/3TC
  0(array)
  cnt4
  22(array)
  MedicationProduct(array)
  generic_name_iABC/3TC , DTG
  0(array)
  cnt1
  23(array)
  MedicationProduct(array)
  generic_name_iABC/3TC and DTG
  0(array)
  cnt1
  24(array)
  MedicationProduct(array)
  generic_name_iABC/3TC, DTG
  0(array)
  cnt1
  25(array)
  MedicationProduct(array)
  generic_name_iABC/3TC/DTG
  0(array)
  cnt50
  26(array)
  MedicationProduct(array)
  generic_name_iAbc/3TC/Efv
  0(array)
  cnt1
  27(array)
  MedicationProduct(array)
  generic_name_iABC/3TC/TDG
  0(array)
  cnt2
  28(array)
  MedicationProduct(array)
  generic_name_iABC/3TC120/60mg DTG 50mg
  0(array)
  cnt1
  29(array)
  MedicationProduct(array)
  generic_name_iABC/3TCplus DTG
  0(array)
  cnt1
  30(array)
  MedicationProduct(array)
  generic_name_iABC/3TG/DTG
  0(array)
  cnt1
  31(array)
  MedicationProduct(array)
  generic_name_iAbc3tcdtg
  0(array)
  cnt1
  32(array)
  MedicationProduct(array)
  generic_name_iABC\3TC\DTG
  0(array)
  cnt1
  33(array)
  MedicationProduct(array)
  generic_name_iABC_3TC/Dtg
  0(array)
  cnt1
  34(array)
  MedicationProduct(array)
  generic_name_iABZ 1tab
  0(array)
  cnt1
  35(array)
  MedicationProduct(array)
  generic_name_iAcetazolamide
  0(array)
  cnt1
  36(array)
  MedicationProduct(array)
  generic_name_iART
  0(array)
  cnt1
  37(array)
  MedicationProduct(array)
  generic_name_iartesunate
  0(array)
  cnt13
  38(array)
  MedicationProduct(array)
  generic_name_iartesunate 60mg vial
  0(array)
  cnt1
  39(array)
  MedicationProduct(array)
  generic_name_iAtenolol
  0(array)
  cnt1
  40(array)
  MedicationProduct(array)
  generic_name_iAzithromycin
  0(array)
  cnt1
  41(array)
  MedicationProduct(array)
  generic_name_iCF2G
  0(array)
  cnt1
  42(array)
  MedicationProduct(array)
  generic_name_iChlorpheniramine
  0(array)
  cnt1
  43(array)
  MedicationProduct(array)
  generic_name_icorrect low albumin levels
  0(array)
  cnt1
  44(array)
  MedicationProduct(array)
  generic_name_iDEC
  0(array)
  cnt3
  45(array)
  MedicationProduct(array)
  generic_name_iDeltagravir
  0(array)
  cnt1
  46(array)
  MedicationProduct(array)
  generic_name_iDiclofenac
  0(array)
  cnt1
  47(array)
  MedicationProduct(array)
  generic_name_iDolutegraviramivufine/tenofovir
  0(array)
  cnt1
  48(array)
  MedicationProduct(array)
  generic_name_iDtg
  0(array)
  cnt11
  49(array)
  MedicationProduct(array)
  generic_name_iG
  0(array)
  cnt1
  50(array)
  MedicationProduct(array)
  generic_name_iG1
  0(array)
  cnt1
  51(array)
  MedicationProduct(array)
  generic_name_iGen I
  0(array)
  cnt1
  52(array)
  MedicationProduct(array)
  generic_name_iGeneric name I
  0(array)
  cnt2
  53(array)
  MedicationProduct(array)
  generic_name_iGenx
  0(array)
  cnt1
  54(array)
  MedicationProduct(array)
  generic_name_iH
  0(array)
  cnt1
  55(array)
  MedicationProduct(array)
  generic_name_iIv artesunate
  0(array)
  cnt1
  56(array)
  MedicationProduct(array)
  generic_name_imeasles rubella vaccine
  0(array)
  cnt1
  57(array)
  MedicationProduct(array)
  generic_name_imetformin
  0(array)
  cnt1
  58(array)
  MedicationProduct(array)
  generic_name_iMionate
  0(array)
  cnt1
  59(array)
  MedicationProduct(array)
  generic_name_iN/A
  0(array)
  cnt3
  60(array)
  MedicationProduct(array)
  generic_name_iNA
  0(array)
  cnt1
  61(array)
  MedicationProduct(array)
  generic_name_iParacetamol
  0(array)
  cnt1
  62(array)
  MedicationProduct(array)
  generic_name_iSodium Valproate
  0(array)
  cnt3
  63(array)
  MedicationProduct(array)
  generic_name_iSodium Vaproate
  0(array)
  cnt1
  64(array)
  MedicationProduct(array)
  generic_name_iTDF
  0(array)
  cnt5
  65(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC
  0(array)
  cnt1
  66(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC+
  0(array)
  cnt1
  67(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC+ABC
  0(array)
  cnt2
  68(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC+DTC+DTG
  0(array)
  cnt1
  69(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC+DTG
  0(array)
  cnt3
  70(array)
  MedicationProduct(array)
  generic_name_iTdf+3tc+dtg+
  0(array)
  cnt1
  71(array)
  MedicationProduct(array)
  generic_name_iTDF, 3TC
  0(array)
  cnt1
  72(array)
  MedicationProduct(array)
  generic_name_iTdf,3tc dtg
  0(array)
  cnt1
  73(array)
  MedicationProduct(array)
  generic_name_iTdf,3tc,dtg
  0(array)
  cnt1
  74(array)
  MedicationProduct(array)
  generic_name_iTDF/3TC/DTG
  0(array)
  cnt11
  75(array)
  MedicationProduct(array)
  generic_name_iTenofovir
  0(array)
  cnt4
  76(array)
  MedicationProduct(array)
  generic_name_iTenofovir/Lamivudine/Dolutegravir
  0(array)
  cnt2
  77(array)
  MedicationProduct(array)
  generic_name_iTenovir,lamuvidine dolutegravir
  0(array)
  cnt1
  78(array)
  MedicationProduct(array)
  generic_name_iTLD
  0(array)
  cnt4
  79(array)
  MedicationProduct(array)
  generic_name_iWe
  0(array)
  cnt1
- counties(array)
  30Baringo
  36Bomet
  39Bungoma
  40Busia
  28Elgeyo/Marakwet
  14Embu
  7Garissa
  43Homa Bay
  11Isiolo
  34Kajiado
  37Kakamega
  35Kericho
  22Kiambu
  3Kilifi
  20Kirinyaga
  45Kisii
  42Kisumu
  15Kitui
  2Kwale
  31Laikipia
  5Lamu
  16Machakos
  17Makueni
  9Mandera
  10Marsabit
  12Meru
  44Migori
  1Mombasa
  21Murang'a
  47Nairobi County
  32Nakuru
  29Nandi
  33Narok
  46Nyamira
  18Nyandarua
  19Nyeri
  25Samburu
  41Siaya
  6Taita Taveta
  4Tana River
  13Tharaka Nithi
  26Trans Nzoia
  23Turkana
  27Uasin Gishu
  38Vihiga
  8Wajir
  24West Pokot
- is_mobile(false)
- root/
- redirdefault
- $request->data(empty)
- $this->validationErrors(array)
  Permission(empty)
  Aro(empty)
  Aco(empty)
  Sadr(empty)
  Medication(empty)
  MedicationProduct(empty)
  County(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Session
  3Number
  4SimpleGraph
  5DebugTimer
  6Toolbar
  7Flash
  8HtmlToolbar
====

Environment

App Constants

Constant	Value
CONFIG	'/var/www/pvers/app/Config/'
MEDIA	'/var/www/pvers/app/webroot/media/'
MEDIA_STATIC	'/var/www/pvers/app/webroot/media/static/'
MEDIA_FILTER	'/var/www/pvers/app/webroot/media/filter/'
MEDIA_TRANSFER	'/var/www/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	'45.79.161.190'
HTTP_BASE	'http://45.79.161.190'
HTTP_SELF	'/app/webroot/index.php'
HTTP_URI	'/reports/medications_by_generici'
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/pvers/app/files/'
LOCALE	'/var/www/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/pvers/app/'
APP_DIR	'app'
APPLIBS	'/var/www/pvers/app/Lib/'
CACHE	'/var/www/pvers/app/tmp/cache/'
CAKE	'/var/www/pvers/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/var/www/pvers/lib'
CORE_PATH	'/var/www/pvers/lib/'
CAKE_VERSION	'2.10.20'
CSS	'/var/www/pvers/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'http://45.79.161.190'
IMAGES	'/var/www/pvers/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/var/www/pvers/app/webroot/js/'
JS_URL	'js/'
LOGS	'/var/www/pvers/app/tmp/logs/'
ROOT	'/var/www/pvers'
TESTS	'/var/www/pvers/app/Test/'
TMP	'/var/www/pvers/app/tmp/'
VENDORS	'/var/www/pvers/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/var/www/pvers/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'5.6.40-63+ubuntu18.04.1+deb.sury.org+2'
Redirect Redirect Status	'200'
Redirect Http Authorization	''
Redirect Status	'200'
Http Authorization	''
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'
Http Host	'45.79.161.190'
Http Via	'1.1 squid-proxy-75b5465b89-gkmvc (squid/6.10)'
Http X Forwarded For	'10.1.117.33'
Http Cache Control	'max-age=259200'
Http Connection	'keep-alive'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
Server Signature	' Apache/2.4.29 (Ubuntu) Server at 45.79.161.190 Port 80 '
Server Software	'Apache/2.4.29 (Ubuntu)'
Server Name	'45.79.161.190'
Server Addr	'45.79.161.190'
Server Port	'80'
Remote Addr	'216.73.216.89'
Document Root	'/var/www/pvers'
Request Scheme	'http'
Context Prefix	''
Context Document Root	'/var/www/pvers'
Server Admin	'webmaster@localhost'
Script Filename	'/var/www/pvers/app/webroot/index.php'
Remote Port	'41932'
Redirect Url	'/app/webroot/reports/medications_by_generici'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/reports/medications_by_generici'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1747982261.879
Request Time	(int) 1747982261

====

Include
+
Included Files

Include Paths
- 0/var/www/pvers/app/Plugin/Media/Lib/mm/src
- 1/var/www/pvers/lib
- 3/usr/share/php
- 4-> /var/www/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/Medication.php
  3APP/Model/MedicationProduct.php
  4APP/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
====

Generic (intended)

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 2 ms Total Queries: 3 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 2 ms
Total Queries: 3 queries