| County | ADRs |
|---|---|
| Baringo | 4 |
| Bomet | 4 |
| Bung'oma | 90 |
| Busia | 14 |
| Embu | 53 |
| Homa Bay | 23 |
| Kajiado | 19 |
| Kakamega | 90 |
| Kericho | 7 |
| Kiambu | 117 |
| Kilifi | 18 |
| Kirinyaga | 109 |
| Kisii | 50 |
| Kisumu | 69 |
| Kitui | 22 |
| Kwale | 9 |
| Laikipia | 8 |
| Machakos | 45 |
| Makueni | 40 |
| Mandera | 1 |
| Marsabit | 1 |
| Meru | 34 |
| Migori | 88 |
| Mombasa | 122 |
| Murang'a | 25 |
| Nairobi County | 596 |
| Nakuru | 26 |
| Nandi | 12 |
| Nyamira | 3 |
| Nyandarua | 7 |
| Nyeri | 19 |
| Samburu | 6 |
| Siaya | 161 |
| Taita Taveta | 13 |
| Tana River | 4 |
| Tharaka Nithi | 14 |
| Trans Nzoia | 2 |
| Turkana | 30 |
| Uasin Gishu | 8 |
| Vihiga | 22 |
| West Pokot | 10 |
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `County`.`county_name`, COUNT(*) as cnt, `County`.`id` FROM `pvers`.`sadrs` AS `Sadr` LEFT JOIN `pvers`.`counties` AS `County` ON (`Sadr`.`county_id` = `County`.`id`) WHERE `Sadr`.`submitted` IN (1, 2) AND `Sadr`.`copied` != 1 GROUP BY `County`.`county_name` HAVING COUNT(*) > 0 | 41 | 41 | 132 | maybe slow |
Peak Memory Use 5.25 MB
| Message | Memory use |
|---|---|
| Component initialization | 2.50 MB |
| Controller action start | 2.92 MB |
| Controller render start | 3.48 MB |
| View render complete | 3.97 MB |
Total Request Time: 178 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 10.92 | |
| Event: Controller.initialize | 3.27 | |
| Event: Controller.startup | 1.04 | |
| Controller action | 140.29 | |
| Event: Controller.beforeRender | 6.75 | |
| » Processing toolbar data | 6.59 | |
| Rendering View | 8.08 | |
| » Event: View.beforeRender | 0.03 | |
| » Rendering APP/View/Reports/sadrs_by_county.ctp | 0.14 | |
| » Rendering APP/View/Reports/reports.ctp | 5.83 | |
| » » Rendering APP/View/Elements/menus/report_public_sidebar.ctp | 4.74 | |
| » Event: View.afterRender | 0.02 | |
| » Event: View.beforeLayout | 0.02 | |
| » Rendering APP/View/Layouts/default.ctp | 1.39 | |
| Event: View.afterLayout | 0.00 |
| 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/sadrs_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 | '″' |
| 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/' |
| 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 05:32:04 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 | '3.239.117.1' |
| 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 | '55058' |
| Redirect Url | '/app/webroot/reports/sadrs_by_county' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | '' |
| Request Uri | '/reports/sadrs_by_county' |
| Script Name | '/app/webroot/index.php' |
| Php Self | '/app/webroot/index.php' |
| Request Time Float | (float) 1679639648.005 |
| Request Time | (int) 1679639648 |
