a:14:{s:6:"config";s:4125:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:6:"2.0.54";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.54";s:4:"name";s:12:"Axima Health";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:6:"8.0.30";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:1;}s:10:"extensions";a:17:{s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:8:"2.0.50.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:61:"/home/carebook/public_html/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.27.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:56:"/home/carebook/public_html/vendor/yiisoft/yii2-debug/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:56:"/home/carebook/public_html/vendor/yiisoft/yii2-faker/src";}}s:26:"yiisoft/yii2-symfonymailer";a:3:{s:4:"name";s:26:"yiisoft/yii2-symfonymailer";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:64:"/home/carebook/public_html/vendor/yiisoft/yii2-symfonymailer/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:54:"/home/carebook/public_html/vendor/yiisoft/yii2-gii/src";}}s:18:"kartik-v/yii2-mpdf";a:3:{s:4:"name";s:18:"kartik-v/yii2-mpdf";s:7:"version";s:7:"1.0.6.0";s:5:"alias";a:1:{s:12:"@kartik/mpdf";s:56:"/home/carebook/public_html/vendor/kartik-v/yii2-mpdf/src";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"3.0.5.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:63:"/home/carebook/public_html/vendor/kartik-v/yii2-krajee-base/src";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:7:"2.2.5.0";s:5:"alias";a:1:{s:15:"@kartik/select2";s:66:"/home/carebook/public_html/vendor/kartik-v/yii2-widget-select2/src";}}s:31:"kartik-v/yii2-widget-activeform";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-activeform";s:7:"version";s:7:"1.6.4.0";s:5:"alias";a:1:{s:12:"@kartik/form";s:69:"/home/carebook/public_html/vendor/kartik-v/yii2-widget-activeform/src";}}s:22:"kartik-v/yii2-sortable";a:3:{s:4:"name";s:22:"kartik-v/yii2-sortable";s:7:"version";s:7:"1.2.2.0";s:5:"alias";a:1:{s:16:"@kartik/sortable";s:60:"/home/carebook/public_html/vendor/kartik-v/yii2-sortable/src";}}s:20:"kartik-v/yii2-dialog";a:3:{s:4:"name";s:20:"kartik-v/yii2-dialog";s:7:"version";s:7:"1.0.6.0";s:5:"alias";a:1:{s:14:"@kartik/dialog";s:58:"/home/carebook/public_html/vendor/kartik-v/yii2-dialog/src";}}s:18:"kartik-v/yii2-grid";a:3:{s:4:"name";s:18:"kartik-v/yii2-grid";s:7:"version";s:7:"3.5.3.0";s:5:"alias";a:1:{s:12:"@kartik/grid";s:56:"/home/carebook/public_html/vendor/kartik-v/yii2-grid/src";}}s:22:"kartik-v/yii2-dynagrid";a:3:{s:4:"name";s:22:"kartik-v/yii2-dynagrid";s:7:"version";s:7:"1.5.5.0";s:5:"alias";a:1:{s:16:"@kartik/dynagrid";s:60:"/home/carebook/public_html/vendor/kartik-v/yii2-dynagrid/src";}}s:20:"kartik-v/yii2-export";a:3:{s:4:"name";s:20:"kartik-v/yii2-export";s:7:"version";s:7:"1.4.3.0";s:5:"alias";a:1:{s:14:"@kartik/export";s:58:"/home/carebook/public_html/vendor/kartik-v/yii2-export/src";}}s:16:"yiisoft/yii2-jui";a:3:{s:4:"name";s:16:"yiisoft/yii2-jui";s:7:"version";s:7:"2.0.7.0";s:5:"alias";a:1:{s:8:"@yii/jui";s:50:"/home/carebook/public_html/vendor/yiisoft/yii2-jui";}}s:24:"edofre/yii2-fullcalendar";a:3:{s:4:"name";s:24:"edofre/yii2-fullcalendar";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:20:"@edofre/fullcalendar";s:62:"/home/carebook/public_html/vendor/edofre/yii2-fullcalendar/src";}}s:35:"kartik-v/yii2-widget-datetimepicker";a:3:{s:4:"name";s:35:"kartik-v/yii2-widget-datetimepicker";s:7:"version";s:7:"1.5.1.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:73:"/home/carebook/public_html/vendor/kartik-v/yii2-widget-datetimepicker/src";}}}}";s:3:"log";s:25922:"a:1:{s:8:"messages";a:43:{i:0;a:6:{i:0;s:68:"Bootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780011262.7037830352783203125;i:4;a:0:{}i:5;i:2505384;}i:1;a:6:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780011262.70528697967529296875;i:4;a:0:{}i:5;i:2690784;}i:2;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780011262.7053210735321044921875;i:4;a:0:{}i:5;i:2691584;}i:3;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1780011262.713594913482666015625;i:4;a:0:{}i:5;i:3538160;}i:4;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7288100719451904296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5174264;}i:5;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=carebook";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1780011262.7288749217987060546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5176704;}i:10;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7306249141693115234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5246616;}i:13;a:6:{i:0;s:764:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7316100597381591796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5266792;}i:16;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7365820407867431640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5748000;}i:19;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780011262.75615596771240234375;i:4;a:0:{}i:5;i:6519728;}i:20;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780011262.760344028472900390625;i:4;a:0:{}i:5;i:6790568;}i:21;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780011262.7607939243316650390625;i:4;a:0:{}i:5;i:6817968;}i:31;a:6:{i:0;s:33:"Route requested: 'site/dashboard'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1780011262.761519908905029296875;i:4;a:0:{}i:5;i:6865696;}i:32;a:6:{i:0;s:28:"Route to run: site/dashboard";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1780011262.7633140087127685546875;i:4;a:0:{}i:5;i:6991640;}i:33;a:6:{i:0;s:65:"Running action: app\controllers\SiteController::actionDashboard()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1780011262.76661205291748046875;i:4;a:0:{}i:5;i:7277416;}i:34;a:6:{i:0;s:26:"SELECT COUNT(*) FROM `bed`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.77071094512939453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:59;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7409616;}i:37;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `bed` WHERE `is_occupied`=TRUE";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.778438091278076171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:60;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7416992;}i:40;a:6:{i:0;s:31:"SELECT COUNT(*) FROM `facility`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.779901981353759765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:64;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7444208;}i:43;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `room`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.785952091217041015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:65;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7471568;}i:46;a:6:{i:0;s:29:"SELECT COUNT(*) FROM `client`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8011329174041748046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:66;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7528176;}i:49;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `stay` WHERE `end_date` IS NULL";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.82071399688720703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:67;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7558904;}i:52;a:6:{i:0;s:28:"SELECT COUNT(*) FROM `shift`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8487370014190673828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:68;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7716816;}i:55;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `shift` WHERE `is_unassigned`=TRUE";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8574359416961669921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:69;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7724208;}i:58;a:6:{i:0;s:72:"SELECT COUNT(*) FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8652479648590087890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:72;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7742872;}i:61;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8667209148406982421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:74;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7747056;}i:64;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `user` WHERE `role`='Scheduler'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.86948394775390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:75;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7754424;}i:67;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `user` WHERE `role`='CareProvider'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8703010082244873046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:76;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7766152;}i:70;a:6:{i:0;s:56:"SELECT COUNT(*) FROM `user` WHERE `role`='ClientManager'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.870851993560791015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:77;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7772264;}i:73;a:6:{i:0;s:93:"SELECT `confirmation_status`, COUNT(*) AS `total` FROM `shift` GROUP BY `confirmation_status`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8735721111297607421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:389;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:34;s:8:"function";s:25:"buildShiftResponseSummary";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7782544;}i:76;a:6:{i:0;s:196:"SELECT DATE(start_time) AS `shift_date`, COUNT(*) AS `total` FROM `shift` WHERE `start_time` BETWEEN '2026-05-22 00:00:00' AND '2026-05-28 23:59:59' GROUP BY DATE(start_time) ORDER BY `shift_date`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.88675689697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:290;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:41;s:8:"function";s:22:"buildRecentShiftTrends";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7885056;}i:79;a:6:{i:0;s:292:"SELECT `a`.* FROM `attendance` `a` LEFT JOIN `shift` `s` ON `a`.`shift_id` = `s`.`id` LEFT JOIN `user` ON `s`.`staff_id` = `user`.`id` LEFT JOIN `client` ON `s`.`client_id` = `client`.`id` WHERE (NOT (`a`.`check_in` IS NULL)) AND (`a`.`check_out` IS NULL) ORDER BY `a`.`check_in` DESC LIMIT 5";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8963749408721923828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:316;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:42;s:8:"function";s:19:"buildActiveCheckIns";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7946296;}i:82;a:6:{i:0;s:95:"SELECT * FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22' ORDER BY `start_time` LIMIT 5";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9065959453582763671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:354;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:43;s:8:"function";s:24:"buildUpcomingAssignments";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7956048;}i:85;a:6:{i:0;s:511:"SELECT `u`.`id` AS `staff_id`, `u`.`first_name` AS `staff_first`, `u`.`last_name` AS `staff_last`, SUM(CASE WHEN s.confirmation_status = 'pending' THEN 1 ELSE 0 END) AS `pending`, SUM(CASE WHEN s.confirmation_status = 'confirmed' THEN 1 ELSE 0 END) AS `confirmed`, SUM(CASE WHEN s.confirmation_status = 'declined' THEN 1 ELSE 0 END) AS `declined`, COUNT(*) AS `total` FROM `shift` `s` INNER JOIN `user` `u` ON u.id = s.staff_id GROUP BY `u`.`id`, `u`.`first_name`, `u`.`last_name` ORDER BY `total` DESC LIMIT 10";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9099609851837158203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:443;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:45;s:8:"function";s:25:"buildShiftResponseByStaff";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7966080;}i:88;a:6:{i:0;s:72:"Rendering view file: /home/carebook/public_html/views/site/dashboard.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1780011262.9192450046539306640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8109648;}i:89;a:6:{i:0;s:70:"Rendering view file: /home/carebook/public_html/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1780011262.95627689361572265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8823440;}i:90;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9811038970947265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8975976;}i:93;a:6:{i:0;s:41:"SHOW FULL COLUMNS FROM `branding_setting`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.982163906097412109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9011016;}i:96;a:6:{i:0;s:36:"SHOW CREATE TABLE `branding_setting`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9830000400543212890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9024808;}i:99;a:6:{i:0;s:788:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'branding_setting' AND `kcu`.`TABLE_NAME` = 'branding_setting'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.983439922332763671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9028536;}i:102;a:6:{i:0;s:70:"Rendering view file: /home/carebook/public_html/views/layouts/_nav.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1780011262.98620891571044921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:52;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9092568;}i:103;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9992849826812744140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/_nav.php";s:4:"line";i:10;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:52;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}}i:5;i:9306928;}i:106;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 184.149.39.178";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1780011263.0488469600677490234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:78;s:8:"function";s:7:"endBody";s:5:"class";s:12:"yii\web\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9291712;}i:107;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 184.149.39.178";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1780011263.0497410297393798828125;i:4;a:0:{}i:5;i:9218024;}}}";s:9:"profiling";s:44073:"a:3:{s:6:"memory";i:9492216;s:4:"time";d:0.36269092559814453125;s:8:"messages";a:56:{i:6;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=carebook";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1780011262.728888988494873046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5177832;}i:7;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=carebook";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1780011262.7296760082244873046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5223032;}i:8;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7297270298004150390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5223256;}i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7305200099945068359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5245224;}i:11;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7306530475616455078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5247968;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7310678958892822265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5250624;}i:14;a:6:{i:0;s:764:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.73163509368896484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5269656;}i:15;a:6:{i:0;s:764:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7324008941650390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5272000;}i:17;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.736649990081787109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5748784;}i:18;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7373020648956298828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5752872;}i:35;a:6:{i:0;s:26:"SELECT COUNT(*) FROM `bed`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7707540988922119140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:59;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7411080;}i:36;a:6:{i:0;s:26:"SELECT COUNT(*) FROM `bed`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7781660556793212890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:59;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7413024;}i:38;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `bed` WHERE `is_occupied`=TRUE";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7784769535064697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:60;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7418560;}i:39;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `bed` WHERE `is_occupied`=TRUE";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7791879177093505859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:60;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7420560;}i:41;a:6:{i:0;s:31:"SELECT COUNT(*) FROM `facility`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.77993297576904296875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:64;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7445672;}i:42;a:6:{i:0;s:31:"SELECT COUNT(*) FROM `facility`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7846629619598388671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:64;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7447616;}i:44;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `room`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.785994052886962890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:65;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7473032;}i:45;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `room`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7933349609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:65;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7474976;}i:47;a:6:{i:0;s:29:"SELECT COUNT(*) FROM `client`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8011839389801025390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:66;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7529640;}i:48;a:6:{i:0;s:29:"SELECT COUNT(*) FROM `client`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.818375110626220703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:66;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7531584;}i:50;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `stay` WHERE `end_date` IS NULL";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.82079792022705078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:67;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7560416;}i:51;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `stay` WHERE `end_date` IS NULL";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8338739871978759765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:67;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7562360;}i:53;a:6:{i:0;s:28:"SELECT COUNT(*) FROM `shift`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.848824977874755859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:68;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7718280;}i:54;a:6:{i:0;s:28:"SELECT COUNT(*) FROM `shift`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.85715389251708984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:68;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7720224;}i:56;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `shift` WHERE `is_unassigned`=TRUE";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.857470989227294921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:69;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7725776;}i:57;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `shift` WHERE `is_unassigned`=TRUE";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8578269481658935546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:69;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7727784;}i:59;a:6:{i:0;s:72:"SELECT COUNT(*) FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.86530590057373046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:72;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7744440;}i:60;a:6:{i:0;s:72:"SELECT COUNT(*) FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.866466999053955078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:72;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7746464;}i:62;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.866755962371826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:74;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7748520;}i:63;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.869141101837158203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:74;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7750464;}i:65;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `user` WHERE `role`='Scheduler'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.86952495574951171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:75;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7761616;}i:66;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `user` WHERE `role`='Scheduler'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.870028018951416015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:75;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7763624;}i:68;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `user` WHERE `role`='CareProvider'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.870337009429931640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:76;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7767712;}i:69;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `user` WHERE `role`='CareProvider'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8706209659576416015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:76;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7769720;}i:71;a:6:{i:0;s:56:"SELECT COUNT(*) FROM `user` WHERE `role`='ClientManager'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8708789348602294921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:77;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7773824;}i:72;a:6:{i:0;s:56:"SELECT COUNT(*) FROM `user` WHERE `role`='ClientManager'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8711540699005126953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:77;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7775832;}i:74;a:6:{i:0;s:93:"SELECT `confirmation_status`, COUNT(*) AS `total` FROM `shift` GROUP BY `confirmation_status`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8736131191253662109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:389;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:34;s:8:"function";s:25:"buildShiftResponseSummary";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7784784;}i:75;a:6:{i:0;s:93:"SELECT `confirmation_status`, COUNT(*) AS `total` FROM `shift` GROUP BY `confirmation_status`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8754520416259765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:389;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:34;s:8:"function";s:25:"buildShiftResponseSummary";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7786832;}i:77;a:6:{i:0;s:196:"SELECT DATE(start_time) AS `shift_date`, COUNT(*) AS `total` FROM `shift` WHERE `start_time` BETWEEN '2026-05-22 00:00:00' AND '2026-05-28 23:59:59' GROUP BY DATE(start_time) ORDER BY `shift_date`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.886845111846923828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:290;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:41;s:8:"function";s:22:"buildRecentShiftTrends";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7887248;}i:78;a:6:{i:0;s:196:"SELECT DATE(start_time) AS `shift_date`, COUNT(*) AS `total` FROM `shift` WHERE `start_time` BETWEEN '2026-05-22 00:00:00' AND '2026-05-28 23:59:59' GROUP BY DATE(start_time) ORDER BY `shift_date`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.88866710662841796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:290;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:41;s:8:"function";s:22:"buildRecentShiftTrends";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7889512;}i:80;a:6:{i:0;s:292:"SELECT `a`.* FROM `attendance` `a` LEFT JOIN `shift` `s` ON `a`.`shift_id` = `s`.`id` LEFT JOIN `user` ON `s`.`staff_id` = `user`.`id` LEFT JOIN `client` ON `s`.`client_id` = `client`.`id` WHERE (NOT (`a`.`check_in` IS NULL)) AND (`a`.`check_out` IS NULL) ORDER BY `a`.`check_in` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.896440029144287109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:316;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:42;s:8:"function";s:19:"buildActiveCheckIns";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7948952;}i:81;a:6:{i:0;s:292:"SELECT `a`.* FROM `attendance` `a` LEFT JOIN `shift` `s` ON `a`.`shift_id` = `s`.`id` LEFT JOIN `user` ON `s`.`staff_id` = `user`.`id` LEFT JOIN `client` ON `s`.`client_id` = `client`.`id` WHERE (NOT (`a`.`check_in` IS NULL)) AND (`a`.`check_out` IS NULL) ORDER BY `a`.`check_in` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.906239986419677734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:316;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:42;s:8:"function";s:19:"buildActiveCheckIns";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7951312;}i:83;a:6:{i:0;s:95:"SELECT * FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22' ORDER BY `start_time` LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.906630039215087890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:354;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:43;s:8:"function";s:24:"buildUpcomingAssignments";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7958312;}i:84;a:6:{i:0;s:95:"SELECT * FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22' ORDER BY `start_time` LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.90958404541015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:354;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:43;s:8:"function";s:24:"buildUpcomingAssignments";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7961136;}i:86;a:6:{i:0;s:511:"SELECT `u`.`id` AS `staff_id`, `u`.`first_name` AS `staff_first`, `u`.`last_name` AS `staff_last`, SUM(CASE WHEN s.confirmation_status = 'pending' THEN 1 ELSE 0 END) AS `pending`, SUM(CASE WHEN s.confirmation_status = 'confirmed' THEN 1 ELSE 0 END) AS `confirmed`, SUM(CASE WHEN s.confirmation_status = 'declined' THEN 1 ELSE 0 END) AS `declined`, COUNT(*) AS `total` FROM `shift` `s` INNER JOIN `user` `u` ON u.id = s.staff_id GROUP BY `u`.`id`, `u`.`first_name`, `u`.`last_name` ORDER BY `total` DESC LIMIT 10";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9100039005279541015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:443;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:45;s:8:"function";s:25:"buildShiftResponseByStaff";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7968800;}i:87;a:6:{i:0;s:511:"SELECT `u`.`id` AS `staff_id`, `u`.`first_name` AS `staff_first`, `u`.`last_name` AS `staff_last`, SUM(CASE WHEN s.confirmation_status = 'pending' THEN 1 ELSE 0 END) AS `pending`, SUM(CASE WHEN s.confirmation_status = 'confirmed' THEN 1 ELSE 0 END) AS `confirmed`, SUM(CASE WHEN s.confirmation_status = 'declined' THEN 1 ELSE 0 END) AS `declined`, COUNT(*) AS `total` FROM `shift` `s` INNER JOIN `user` `u` ON u.id = s.staff_id GROUP BY `u`.`id`, `u`.`first_name`, `u`.`last_name` ORDER BY `total` DESC LIMIT 10";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.91065311431884765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:443;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:45;s:8:"function";s:25:"buildShiftResponseByStaff";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7971720;}i:91;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98116207122802734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8978120;}i:92;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98161411285400390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8981144;}i:94;a:6:{i:0;s:41:"SHOW FULL COLUMNS FROM `branding_setting`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98221492767333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9013160;}i:95;a:6:{i:0;s:41:"SHOW FULL COLUMNS FROM `branding_setting`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9829099178314208984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9022696;}i:97;a:6:{i:0;s:36:"SHOW CREATE TABLE `branding_setting`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.983046054840087890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9026928;}i:98;a:6:{i:0;s:36:"SHOW CREATE TABLE `branding_setting`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98324489593505859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9029776;}i:100;a:6:{i:0;s:788:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'branding_setting' AND `kcu`.`TABLE_NAME` = 'branding_setting'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98346710205078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9032152;}i:101;a:6:{i:0;s:788:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'branding_setting' AND `kcu`.`TABLE_NAME` = 'branding_setting'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98398590087890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9035248;}i:104;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011263.00107097625732421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/_nav.php";s:4:"line";i:10;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:52;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}}i:5;i:9309072;}i:105;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011263.00154590606689453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/_nav.php";s:4:"line";i:10;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:52;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}}i:5;i:9312096;}}}";s:2:"db";s:43277:"a:1:{s:8:"messages";a:54:{i:8;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7297270298004150390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5223256;}i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7305200099945068359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5245224;}i:11;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7306530475616455078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5247968;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7310678958892822265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5250624;}i:14;a:6:{i:0;s:764:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.73163509368896484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5269656;}i:15;a:6:{i:0;s:764:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7324008941650390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5272000;}i:17;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.736649990081787109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5748784;}i:18;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7373020648956298828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5752872;}i:35;a:6:{i:0;s:26:"SELECT COUNT(*) FROM `bed`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7707540988922119140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:59;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7411080;}i:36;a:6:{i:0;s:26:"SELECT COUNT(*) FROM `bed`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7781660556793212890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:59;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7413024;}i:38;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `bed` WHERE `is_occupied`=TRUE";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7784769535064697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:60;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7418560;}i:39;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `bed` WHERE `is_occupied`=TRUE";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7791879177093505859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:60;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7420560;}i:41;a:6:{i:0;s:31:"SELECT COUNT(*) FROM `facility`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.77993297576904296875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:64;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7445672;}i:42;a:6:{i:0;s:31:"SELECT COUNT(*) FROM `facility`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7846629619598388671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:64;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7447616;}i:44;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `room`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.785994052886962890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:65;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7473032;}i:45;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `room`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.7933349609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:65;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7474976;}i:47;a:6:{i:0;s:29:"SELECT COUNT(*) FROM `client`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8011839389801025390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:66;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7529640;}i:48;a:6:{i:0;s:29:"SELECT COUNT(*) FROM `client`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.818375110626220703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:66;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7531584;}i:50;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `stay` WHERE `end_date` IS NULL";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.82079792022705078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:67;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7560416;}i:51;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `stay` WHERE `end_date` IS NULL";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8338739871978759765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:67;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7562360;}i:53;a:6:{i:0;s:28:"SELECT COUNT(*) FROM `shift`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.848824977874755859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:68;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7718280;}i:54;a:6:{i:0;s:28:"SELECT COUNT(*) FROM `shift`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.85715389251708984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:68;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7720224;}i:56;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `shift` WHERE `is_unassigned`=TRUE";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.857470989227294921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:69;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7725776;}i:57;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `shift` WHERE `is_unassigned`=TRUE";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8578269481658935546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:69;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7727784;}i:59;a:6:{i:0;s:72:"SELECT COUNT(*) FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.86530590057373046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:72;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7744440;}i:60;a:6:{i:0;s:72:"SELECT COUNT(*) FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.866466999053955078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:72;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7746464;}i:62;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.866755962371826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:74;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7748520;}i:63;a:6:{i:0;s:27:"SELECT COUNT(*) FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.869141101837158203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:74;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7750464;}i:65;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `user` WHERE `role`='Scheduler'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.86952495574951171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:75;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7761616;}i:66;a:6:{i:0;s:52:"SELECT COUNT(*) FROM `user` WHERE `role`='Scheduler'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.870028018951416015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:75;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7763624;}i:68;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `user` WHERE `role`='CareProvider'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.870337009429931640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:76;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7767712;}i:69;a:6:{i:0;s:55:"SELECT COUNT(*) FROM `user` WHERE `role`='CareProvider'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8706209659576416015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:76;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7769720;}i:71;a:6:{i:0;s:56:"SELECT COUNT(*) FROM `user` WHERE `role`='ClientManager'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8708789348602294921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:77;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7773824;}i:72;a:6:{i:0;s:56:"SELECT COUNT(*) FROM `user` WHERE `role`='ClientManager'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8711540699005126953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:77;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:32;s:8:"function";s:15:"calculateTotals";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7775832;}i:74;a:6:{i:0;s:93:"SELECT `confirmation_status`, COUNT(*) AS `total` FROM `shift` GROUP BY `confirmation_status`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8736131191253662109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:389;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:34;s:8:"function";s:25:"buildShiftResponseSummary";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7784784;}i:75;a:6:{i:0;s:93:"SELECT `confirmation_status`, COUNT(*) AS `total` FROM `shift` GROUP BY `confirmation_status`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.8754520416259765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:389;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:34;s:8:"function";s:25:"buildShiftResponseSummary";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7786832;}i:77;a:6:{i:0;s:196:"SELECT DATE(start_time) AS `shift_date`, COUNT(*) AS `total` FROM `shift` WHERE `start_time` BETWEEN '2026-05-22 00:00:00' AND '2026-05-28 23:59:59' GROUP BY DATE(start_time) ORDER BY `shift_date`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.886845111846923828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:290;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:41;s:8:"function";s:22:"buildRecentShiftTrends";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7887248;}i:78;a:6:{i:0;s:196:"SELECT DATE(start_time) AS `shift_date`, COUNT(*) AS `total` FROM `shift` WHERE `start_time` BETWEEN '2026-05-22 00:00:00' AND '2026-05-28 23:59:59' GROUP BY DATE(start_time) ORDER BY `shift_date`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.88866710662841796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:290;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:41;s:8:"function";s:22:"buildRecentShiftTrends";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7889512;}i:80;a:6:{i:0;s:292:"SELECT `a`.* FROM `attendance` `a` LEFT JOIN `shift` `s` ON `a`.`shift_id` = `s`.`id` LEFT JOIN `user` ON `s`.`staff_id` = `user`.`id` LEFT JOIN `client` ON `s`.`client_id` = `client`.`id` WHERE (NOT (`a`.`check_in` IS NULL)) AND (`a`.`check_out` IS NULL) ORDER BY `a`.`check_in` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.896440029144287109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:316;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:42;s:8:"function";s:19:"buildActiveCheckIns";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7948952;}i:81;a:6:{i:0;s:292:"SELECT `a`.* FROM `attendance` `a` LEFT JOIN `shift` `s` ON `a`.`shift_id` = `s`.`id` LEFT JOIN `user` ON `s`.`staff_id` = `user`.`id` LEFT JOIN `client` ON `s`.`client_id` = `client`.`id` WHERE (NOT (`a`.`check_in` IS NULL)) AND (`a`.`check_out` IS NULL) ORDER BY `a`.`check_in` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.906239986419677734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:316;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:42;s:8:"function";s:19:"buildActiveCheckIns";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7951312;}i:83;a:6:{i:0;s:95:"SELECT * FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22' ORDER BY `start_time` LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.906630039215087890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:354;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:43;s:8:"function";s:24:"buildUpcomingAssignments";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7958312;}i:84;a:6:{i:0;s:95:"SELECT * FROM `shift` WHERE `start_time` >= '2026-05-28 23:34:22' ORDER BY `start_time` LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.90958404541015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:354;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:43;s:8:"function";s:24:"buildUpcomingAssignments";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7961136;}i:86;a:6:{i:0;s:511:"SELECT `u`.`id` AS `staff_id`, `u`.`first_name` AS `staff_first`, `u`.`last_name` AS `staff_last`, SUM(CASE WHEN s.confirmation_status = 'pending' THEN 1 ELSE 0 END) AS `pending`, SUM(CASE WHEN s.confirmation_status = 'confirmed' THEN 1 ELSE 0 END) AS `confirmed`, SUM(CASE WHEN s.confirmation_status = 'declined' THEN 1 ELSE 0 END) AS `declined`, COUNT(*) AS `total` FROM `shift` `s` INNER JOIN `user` `u` ON u.id = s.staff_id GROUP BY `u`.`id`, `u`.`first_name`, `u`.`last_name` ORDER BY `total` DESC LIMIT 10";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9100039005279541015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:443;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:45;s:8:"function";s:25:"buildShiftResponseByStaff";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7968800;}i:87;a:6:{i:0;s:511:"SELECT `u`.`id` AS `staff_id`, `u`.`first_name` AS `staff_first`, `u`.`last_name` AS `staff_last`, SUM(CASE WHEN s.confirmation_status = 'pending' THEN 1 ELSE 0 END) AS `pending`, SUM(CASE WHEN s.confirmation_status = 'confirmed' THEN 1 ELSE 0 END) AS `confirmed`, SUM(CASE WHEN s.confirmation_status = 'declined' THEN 1 ELSE 0 END) AS `declined`, COUNT(*) AS `total` FROM `shift` `s` INNER JOIN `user` `u` ON u.id = s.staff_id GROUP BY `u`.`id`, `u`.`first_name`, `u`.`last_name` ORDER BY `total` DESC LIMIT 10";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.91065311431884765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:443;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/home/carebook/public_html/services/AdminDashboardService.php";s:4:"line";i:45;s:8:"function";s:25:"buildShiftResponseByStaff";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:253;s:8:"function";s:10:"getMetrics";s:5:"class";s:34:"app\services\AdminDashboardService";s:4:"type";s:2:"->";}}i:5;i:7971720;}i:91;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98116207122802734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8978120;}i:92;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98161411285400390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8981144;}i:94;a:6:{i:0;s:41:"SHOW FULL COLUMNS FROM `branding_setting`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98221492767333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9013160;}i:95;a:6:{i:0;s:41:"SHOW FULL COLUMNS FROM `branding_setting`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.9829099178314208984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9022696;}i:97;a:6:{i:0;s:36:"SHOW CREATE TABLE `branding_setting`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.983046054840087890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9026928;}i:98;a:6:{i:0;s:36:"SHOW CREATE TABLE `branding_setting`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98324489593505859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9029776;}i:100;a:6:{i:0;s:788:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'branding_setting' AND `kcu`.`TABLE_NAME` = 'branding_setting'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98346710205078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9032152;}i:101;a:6:{i:0;s:788:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'branding_setting' AND `kcu`.`TABLE_NAME` = 'branding_setting'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011262.98398590087890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:14;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:57:"/home/carebook/public_html/controllers/SiteController.php";s:4:"line";i:256;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9035248;}i:104;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780011263.00107097625732421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/_nav.php";s:4:"line";i:10;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:52;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}}i:5;i:9309072;}i:105;a:6:{i:0;s:46:"SELECT * FROM `branding_setting` ORDER BY `id`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780011263.00154590606689453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/home/carebook/public_html/models/BrandingSetting.php";s:4:"line";i:80;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/_nav.php";s:4:"line";i:10;s:8:"function";s:11:"loadCurrent";s:5:"class";s:26:"app\models\BrandingSetting";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:49:"/home/carebook/public_html/views/layouts/main.php";s:4:"line";i:52;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}}i:5;i:9312096;}}}";s:5:"event";s:10581:"a:57:{i:0;a:5:{s:4:"time";d:1780011262.7241270542144775390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:1;a:5:{s:4:"time";d:1780011262.72965908050537109375;s:4:"name";s:9:"afterOpen";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:2;a:5:{s:4:"time";d:1780011262.7374169826507568359375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:3;a:5:{s:4:"time";d:1780011262.7375290393829345703125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:4;a:5:{s:4:"time";d:1780011262.7524740695953369140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:5;a:5:{s:4:"time";d:1780011262.7613430023193359375;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:6;a:5:{s:4:"time";d:1780011262.763454914093017578125;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:7;a:5:{s:4:"time";d:1780011262.7665669918060302734375;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:30:"app\controllers\SiteController";}i:8;a:5:{s:4:"time";d:1780011262.7705519199371337890625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:9;a:5:{s:4:"time";d:1780011262.778276920318603515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:10;a:5:{s:4:"time";d:1780011262.7798058986663818359375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:11;a:5:{s:4:"time";d:1780011262.7858479022979736328125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:12;a:5:{s:4:"time";d:1780011262.8010179996490478515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:13;a:5:{s:4:"time";d:1780011262.820558071136474609375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:14;a:5:{s:4:"time";d:1780011262.8485949039459228515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:15;a:5:{s:4:"time";d:1780011262.857273101806640625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:16;a:5:{s:4:"time";d:1780011262.8579061031341552734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:17;a:5:{s:4:"time";d:1780011262.86657810211181640625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:18;a:5:{s:4:"time";d:1780011262.8692600727081298828125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:19;a:5:{s:4:"time";d:1780011262.8701250553131103515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:20;a:5:{s:4:"time";d:1780011262.8706939220428466796875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:21;a:5:{s:4:"time";d:1780011262.8756620883941650390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:22;a:5:{s:4:"time";d:1780011262.890964984893798828125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:23;a:5:{s:4:"time";d:1780011262.8912351131439208984375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\models\Attendance";}i:24;a:5:{s:4:"time";d:1780011262.891274929046630859375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:25;a:5:{s:4:"time";d:1780011262.8913249969482421875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Shift";}i:26;a:5:{s:4:"time";d:1780011262.892527103424072265625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:27;a:5:{s:4:"time";d:1780011262.89260005950927734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:28;a:5:{s:4:"time";d:1780011262.9063799381256103515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:29;a:5:{s:4:"time";d:1780011262.919229030609130859375;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:30;a:5:{s:4:"time";d:1780011262.9561150074005126953125;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:31;a:5:{s:4:"time";d:1780011262.9562699794769287109375;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:32;a:5:{s:4:"time";d:1780011262.980967044830322265625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:33;a:5:{s:4:"time";d:1780011262.982081890106201171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"app\models\BrandingSetting";}i:34;a:5:{s:4:"time";d:1780011262.984076023101806640625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"app\models\BrandingSetting";}i:35;a:5:{s:4:"time";d:1780011262.9844119548797607421875;s:4:"name";s:9:"beginPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:36;a:5:{s:4:"time";d:1780011262.98610591888427734375;s:4:"name";s:9:"beginBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:37;a:5:{s:4:"time";d:1780011262.9862000942230224609375;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:38;a:5:{s:4:"time";d:1780011262.9991168975830078125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:39;a:5:{s:4:"time";d:1780011263.0016710758209228515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"app\models\BrandingSetting";}i:40;a:5:{s:4:"time";d:1780011263.0017459392547607421875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"app\models\BrandingSetting";}i:41;a:5:{s:4:"time";d:1780011263.0065500736236572265625;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:42;a:5:{s:4:"time";d:1780011263.0410339832305908203125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"yii\bootstrap5\Breadcrumbs";}i:43;a:5:{s:4:"time";d:1780011263.0434830188751220703125;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"yii\bootstrap5\Breadcrumbs";}i:44;a:5:{s:4:"time";d:1780011263.0437400341033935546875;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"yii\bootstrap5\Breadcrumbs";}i:45;a:5:{s:4:"time";d:1780011263.0486810207366943359375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\widgets\Alert";}i:46;a:5:{s:4:"time";d:1780011263.04870510101318359375;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\widgets\Alert";}i:47;a:5:{s:4:"time";d:1780011263.0487511157989501953125;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\widgets\Alert";}i:48;a:5:{s:4:"time";d:1780011263.04889202117919921875;s:4:"name";s:7:"endBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:49;a:5:{s:4:"time";d:1780011263.049076080322265625;s:4:"name";s:7:"endPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:50;a:5:{s:4:"time";d:1780011263.049335956573486328125;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:51;a:5:{s:4:"time";d:1780011263.049396991729736328125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:30:"app\controllers\SiteController";}i:52;a:5:{s:4:"time";d:1780011263.0494120121002197265625;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:53;a:5:{s:4:"time";d:1780011263.0494289398193359375;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:54;a:5:{s:4:"time";d:1780011263.0494709014892578125;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:55;a:5:{s:4:"time";d:1780011263.0497829914093017578125;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:56;a:5:{s:4:"time";d:1780011263.0523169040679931640625;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:121:"a:3:{s:5:"start";d:1780011262.6954810619354248046875;s:3:"end";d:1780011263.05867290496826171875;s:6:"memory";i:9492216;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1955:"a:3:{s:8:"messages";a:9:{i:22;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.76144504547119140625;i:4;a:0:{}i:5;i:6860312;}i:23;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.7614610195159912109375;i:4;a:0:{}i:5;i:6861064;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.76146793365478515625;i:4;a:0:{}i:5;i:6861816;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.7614738941192626953125;i:4;a:0:{}i:5;i:6862568;}i:26;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.7614800930023193359375;i:4;a:0:{}i:5;i:6863320;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:8:"m/shifts";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.76148509979248046875;i:4;a:0:{}i:5;i:6864072;}i:28;a:6:{i:0;a:3:{s:4:"rule";s:16:"m/shift/<id:\d+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.7614910602569580078125;i:4;a:0:{}i:5;i:6864824;}i:29;a:6:{i:0;a:3:{s:4:"rule";s:16:"yii\rest\UrlRule";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.761498928070068359375;i:4;a:0:{}i:5;i:6865576;}i:30;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780011262.7615020275115966796875;i:4;a:0:{}i:5;i:6865952;}}s:5:"route";s:14:"site/dashboard";s:6:"action";s:49:"app\controllers\SiteController::actionDashboard()";}";s:7:"request";s:6434:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:15:{s:7:"x-https";s:1:"1";s:8:"priority";s:6:"u=0, i";s:14:"sec-fetch-user";s:2:"?1";s:14:"sec-fetch-site";s:11:"same-origin";s:14:"sec-fetch-mode";s:8:"navigate";s:14:"sec-fetch-dest";s:8:"document";s:25:"upgrade-insecure-requests";s:1:"1";s:6:"cookie";s:519:"_ga_PHZV2RJFS3=GS2.1.s1778527525$o11$g0$t1778527525$j60$l0$h0; _ga=GA1.1.456317619.1750290372; _csrf=4d6a8514f8337c7734596f9f72e68e7b79dbb2505d98529afe2b1f186b48536da%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22YyouRvdFk0peWsLusy8ifBWA_mu3EOeq%22%3B%7D; PHPSESSID=337bce5a0e19838d6c68dfc36330cae2; _identity=50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr%22%2C2592000%5D%22%3B%7D";s:10:"connection";s:10:"keep-alive";s:7:"referer";s:47:"https://carebook.aximahealth.com/web/site/login";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:15:"accept-language";s:14:"en-US,en;q=0.9";s:6:"accept";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:10:"user-agent";s:80:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:151.0) Gecko/20100101 Firefox/151.0";s:4:"host";s:24:"carebook.aximahealth.com";}s:15:"responseHeaders";a:6:{s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:23:"Content-Security-Policy";s:378:"default-src 'self'; script-src 'self' https://cdn.jsdelivr.net https://unpkg.com 'unsafe-inline'; style-src 'self' https://cdn.jsdelivr.net https://unpkg.com https://fonts.googleapis.com 'unsafe-inline'; img-src 'self' https://aximahealth.com data:; font-src 'self' https://cdn.jsdelivr.net https://fonts.gstatic.com data:; connect-src 'self' https://nominatim.openstreetmap.org";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:10:"Set-Cookie";s:294:"_identity=50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr%22%2C2592000%5D%22%3B%7D; expires=Sat, 27-Jun-2026 23:34:22 GMT; Max-Age=2591999; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:14:"site/dashboard";s:6:"action";s:49:"app\controllers\SiteController::actionDashboard()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:56:{s:4:"USER";s:8:"carebook";s:4:"HOME";s:14:"/home/carebook";s:11:"SCRIPT_NAME";s:14:"/web/index.php";s:11:"REQUEST_URI";s:19:"/web/site/dashboard";s:12:"QUERY_STRING";s:0:"";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:12:"REDIRECT_URL";s:19:"/web/site/dashboard";s:11:"REMOTE_PORT";s:5:"49382";s:15:"SCRIPT_FILENAME";s:40:"/home/carebook/public_html/web/index.php";s:12:"SERVER_ADMIN";s:34:"webmaster@carebook.aximahealth.com";s:21:"CONTEXT_DOCUMENT_ROOT";s:26:"/home/carebook/public_html";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:26:"/home/carebook/public_html";s:11:"REMOTE_ADDR";s:14:"184.149.39.178";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:13:"208.87.134.53";s:11:"SERVER_NAME";s:24:"carebook.aximahealth.com";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:12:"HTTP_X_HTTPS";s:1:"1";s:13:"HTTP_PRIORITY";s:6:"u=0, i";s:19:"HTTP_SEC_FETCH_USER";s:2:"?1";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:11:"HTTP_COOKIE";s:519:"_ga_PHZV2RJFS3=GS2.1.s1778527525$o11$g0$t1778527525$j60$l0$h0; _ga=GA1.1.456317619.1750290372; _csrf=4d6a8514f8337c7734596f9f72e68e7b79dbb2505d98529afe2b1f186b48536da%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22YyouRvdFk0peWsLusy8ifBWA_mu3EOeq%22%3B%7D; PHPSESSID=337bce5a0e19838d6c68dfc36330cae2; _identity=50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr%22%2C2592000%5D%22%3B%7D";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:12:"HTTP_REFERER";s:47:"https://carebook.aximahealth.com/web/site/login";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:11:"HTTP_ACCEPT";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:15:"HTTP_USER_AGENT";s:80:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:151.0) Gecko/20100101 Firefox/151.0";s:9:"HTTP_HOST";s:24:"carebook.aximahealth.com";s:17:"proxy-nokeepalive";s:1:"1";s:11:"SSL_TLS_SNI";s:24:"carebook.aximahealth.com";s:5:"HTTPS";s:2:"on";s:10:"SCRIPT_URI";s:51:"https://carebook.aximahealth.com/web/site/dashboard";s:10:"SCRIPT_URL";s:19:"/web/site/dashboard";s:9:"UNIQUE_ID";s:27:"ahjQ_iJpX8UgOqaenDyhZAAAAE0";s:15:"REDIRECT_STATUS";s:3:"200";s:20:"REDIRECT_SSL_TLS_SNI";s:24:"carebook.aximahealth.com";s:14:"REDIRECT_HTTPS";s:2:"on";s:19:"REDIRECT_SCRIPT_URI";s:51:"https://carebook.aximahealth.com/web/site/dashboard";s:19:"REDIRECT_SCRIPT_URL";s:19:"/web/site/dashboard";s:18:"REDIRECT_UNIQUE_ID";s:27:"ahjQ_iJpX8UgOqaenDyhZAAAAE0";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:14:"/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1780011262.686953067779541015625;s:12:"REQUEST_TIME";i:1780011262;s:4:"argv";a:0:{}s:4:"argc";i:0;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:5:{s:14:"_ga_PHZV2RJFS3";s:46:"GS2.1.s1778527525$o11$g0$t1778527525$j60$l0$h0";s:3:"_ga";s:26:"GA1.1.456317619.1750290372";s:5:"_csrf";s:130:"4d6a8514f8337c7734596f9f72e68e7b79dbb2505d98529afe2b1f186b48536da:2:{i:0;s:5:"_csrf";i:1;s:32:"YyouRvdFk0peWsLusy8ifBWA_mu3EOeq";}";s:9:"PHPSESSID";s:32:"337bce5a0e19838d6c68dfc36330cae2";s:9:"_identity";s:148:"50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a:2:{i:0;s:9:"_identity";i:1;s:46:"[1,"rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr",2592000]";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:3:{s:7:"__flash";a:0:{}s:4:"__id";i:1;s:9:"__authKey";s:32:"rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr";}}";s:4:"user";s:2128:"a:5:{s:2:"id";i:1;s:8:"identity";a:19:{s:2:"id";s:1:"1";s:9:"legacy_id";s:4:"null";s:8:"username";s:7:"'admin'";s:13:"password_hash";s:62:"'$2a$12$W982fUIFEzH4KsJXsF0Y6O6IEluUb6eTttsxNpJm/.ctVOL3OJvvO'";s:8:"auth_key";s:34:"'rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr'";s:5:"email";s:19:"'admin@example.com'";s:10:"first_name";s:2:"''";s:9:"last_name";s:2:"''";s:5:"phone";s:2:"''";s:11:"avatar_path";s:55:"'/uploads/avatars/mABhkharf1K0VyKlbDaZhQIK98S97no5.png'";s:4:"role";s:12:"'SuperAdmin'";s:10:"created_at";s:10:"1757391733";s:10:"updated_at";s:10:"1758092193";s:7:"address";s:2:"''";s:13:"date_of_birth";s:4:"null";s:6:"gender";s:2:"''";s:9:"biography";s:2:"''";s:14:"certifications";s:2:"[]";s:8:"pay_rate";s:4:"null";}s:10:"attributes";a:19:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"Id";}i:1;a:2:{s:9:"attribute";s:9:"legacy_id";s:5:"label";s:9:"Legacy Id";}i:2;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:8:"Username";}i:3;a:2:{s:9:"attribute";s:13:"password_hash";s:5:"label";s:13:"Password Hash";}i:4;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:5;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:6;a:2:{s:9:"attribute";s:10:"first_name";s:5:"label";s:10:"First Name";}i:7;a:2:{s:9:"attribute";s:9:"last_name";s:5:"label";s:9:"Last Name";}i:8;a:2:{s:9:"attribute";s:5:"phone";s:5:"label";s:5:"Phone";}i:9;a:2:{s:9:"attribute";s:11:"avatar_path";s:5:"label";s:11:"Avatar Path";}i:10;a:2:{s:9:"attribute";s:4:"role";s:5:"label";s:4:"Role";}i:11;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:10:"Created At";}i:12;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:10:"Updated At";}i:13;a:2:{s:9:"attribute";s:7:"address";s:5:"label";s:7:"Address";}i:14;a:2:{s:9:"attribute";s:13:"date_of_birth";s:5:"label";s:13:"Date Of Birth";}i:15;a:2:{s:9:"attribute";s:6:"gender";s:5:"label";s:6:"Gender";}i:16;a:2:{s:9:"attribute";s:9:"biography";s:5:"label";s:9:"Biography";}i:17;a:2:{s:9:"attribute";s:14:"certifications";s:5:"label";s:14:"Certifications";}i:18;a:2:{s:9:"attribute";s:8:"pay_rate";s:5:"label";s:8:"Pay Rate";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:2115:"a:5:{s:19:"app\assets\AppAsset";a:9:{s:8:"basePath";s:30:"/home/carebook/public_html/web";s:7:"baseUrl";s:4:"/web";s:3:"css";a:2:{i:0;s:76:"https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.1/font/bootstrap-icons.css";i:1;s:12:"css/site.css";}s:2:"js";a:1:{i:0;s:9:"js/app.js";}s:7:"depends";a:3:{i:0;s:16:"yii\web\YiiAsset";i:1;s:29:"yii\bootstrap5\BootstrapAsset";i:2;s:35:"yii\bootstrap5\BootstrapPluginAsset";}s:10:"sourcePath";N;s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\web\YiiAsset";a:9:{s:10:"sourcePath";s:53:"/home/carebook/public_html/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:6:"yii.js";}s:7:"depends";a:1:{i:0;s:19:"yii\web\JqueryAsset";}s:8:"basePath";s:46:"/home/carebook/public_html/web/assets/2d23f4ab";s:7:"baseUrl";s:20:"/web/assets/2d23f4ab";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:19:"yii\web\JqueryAsset";a:9:{s:10:"sourcePath";s:57:"/home/carebook/public_html/vendor/bower-asset/jquery/dist";s:2:"js";a:1:{i:0;s:9:"jquery.js";}s:8:"basePath";s:46:"/home/carebook/public_html/web/assets/3d67f8e0";s:7:"baseUrl";s:20:"/web/assets/3d67f8e0";s:7:"depends";a:0:{}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:29:"yii\bootstrap5\BootstrapAsset";a:9:{s:10:"sourcePath";s:60:"/home/carebook/public_html/vendor/bower-asset/bootstrap/dist";s:3:"css";a:1:{i:0;s:17:"css/bootstrap.css";}s:8:"basePath";s:46:"/home/carebook/public_html/web/assets/3c66923d";s:7:"baseUrl";s:20:"/web/assets/3c66923d";s:7:"depends";a:0:{}s:2:"js";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:35:"yii\bootstrap5\BootstrapPluginAsset";a:9:{s:10:"sourcePath";s:60:"/home/carebook/public_html/vendor/bower-asset/bootstrap/dist";s:2:"js";a:1:{i:0;s:22:"js/bootstrap.bundle.js";}s:7:"depends";a:1:{i:0;s:29:"yii\bootstrap5\BootstrapAsset";}s:8:"basePath";s:46:"/home/carebook/public_html/web/assets/3c66923d";s:7:"baseUrl";s:20:"/web/assets/3c66923d";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a18d0feb8cba";s:3:"url";s:51:"https://carebook.aximahealth.com/web/site/dashboard";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:14:"184.149.39.178";s:4:"time";d:1780011262.686953067779541015625;s:10:"statusCode";i:200;s:8:"sqlCount";i:27;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:9492216;s:14:"processingTime";d:0.36269092559814453125;}s:10:"exceptions";a:0:{}}