a:14:{s:6:"config";s:1660:"a:5:{s:10:"phpVersion";s:5:"8.2.0";s:10:"yiiVersion";s:6:"2.0.55";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.55";s:4:"name";s:14:"My Application";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:5:"8.2.0";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:5:{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:83:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/vendor/yiisoft/yii2-faker/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:8:"2.0.51.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:88:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/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.28.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:83:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/vendor/yiisoft/yii2-debug/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:91:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/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:81:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/vendor/yiisoft/yii2-gii/src";}}}}";s:3:"log";s:18647:"a:1:{s:8:"messages";a:44:{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:1778585946.99526;i:4;a:0:{}i:5;i:3186200;}i:1;a:6:{i:0;s:60:"Bootstrap with common\bootstrap\MailerBootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1778585946.996999;i:4;a:0:{}i:5;i:3216424;}i:2;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:1778585947.004502;i:4;a:0:{}i:5;i:3440992;}i:3;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1778585947.004565;i:4;a:0:{}i:5;i:3441632;}i:4;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1778585947.033554;i:4;a:0:{}i:5;i:4244336;}i:5;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `users`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.083244;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5569408;}i:6;a:6:{i:0;s:70:"Opening DB connection: mysql:host=127.0.0.1;dbname=appointment_booking";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1778585947.083443;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5571528;}i:11;a:6:{i:0;s:25:"SHOW CREATE TABLE `users`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.116113;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5632144;}i:14;a:6:{i:0;s:766:"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` = 'users' AND `kcu`.`TABLE_NAME` = 'users'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.120033;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5719304;}i:17;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=1) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.14892;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6098056;}i:20;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:1778585947.162458;i:4;a:0:{}i:5;i:6451256;}i:21;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1778585947.171607;i:4;a:0:{}i:5;i:6675616;}i:22;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:1778585947.17281;i:4;a:0:{}i:5;i:6700080;}i:45;a:6:{i:0;s:33:"Route requested: 'analysis/index'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1778585947.183015;i:4;a:0:{}i:5;i:6941216;}i:46;a:6:{i:0;s:28:"Route to run: analysis/index";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1778585947.187877;i:4;a:0:{}i:5;i:7020424;}i:47;a:6:{i:0;s:69:"Running action: backend\controllers\AnalysisController::actionIndex()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1778585947.196752;i:4;a:0:{}i:5;i:7211096;}i:48;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=6) AND (YEAR(appointment_date)=2025)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.201752;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7277176;}i:51;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=7) AND (YEAR(appointment_date)=2025)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.20551;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7280864;}i:54;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=8) AND (YEAR(appointment_date)=2025)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.20619;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7284080;}i:57;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=9) AND (YEAR(appointment_date)=2025)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.206764;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7287296;}i:60;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=10) AND (YEAR(appointment_date)=2025)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207332;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7290512;}i:63;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=11) AND (YEAR(appointment_date)=2025)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207964;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7293728;}i:66;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=12) AND (YEAR(appointment_date)=2025)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.208569;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7298224;}i:69;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=1) AND (YEAR(appointment_date)=2026)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.20915;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7301440;}i:72;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=2) AND (YEAR(appointment_date)=2026)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.209828;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7304976;}i:75;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=3) AND (YEAR(appointment_date)=2026)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.210425;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7308512;}i:78;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=4) AND (YEAR(appointment_date)=2026)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211031;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7311728;}i:81;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=5) AND (YEAR(appointment_date)=2026)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211621;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7314944;}i:84;a:6:{i:0;s:75:"SELECT * FROM `specialities` WHERE `status`=1 ORDER BY `sort_order`, `name`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.21333;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7341584;}i:87;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `specialities`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.214532;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7354328;}i:90;a:6:{i:0;s:32:"SHOW CREATE TABLE `specialities`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.21586;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7365136;}i:93;a:6:{i:0;s:780:"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` = 'specialities' AND `kcu`.`TABLE_NAME` = 'specialities'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.216713;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7366960;}i:96;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=1) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.220439;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7430520;}i:99;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `doctors`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.22268;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7440664;}i:102;a:6:{i:0;s:27:"SHOW CREATE TABLE `doctors`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.223521;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7455128;}i:105;a:6:{i:0;s:770:"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` = 'doctors' AND `kcu`.`TABLE_NAME` = 'doctors'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.224822;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7453440;}i:108;a:6:{i:0;s:84:"SELECT COUNT(*) FROM `appointments` WHERE (`doctor_id`=1) AND (`status`='confirmed')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.228492;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.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:5;i:7487568;}i:111;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=2) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.229618;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7490856;}i:114;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=3) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230162;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7493912;}i:117;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=4) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230648;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7497184;}i:120;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=5) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231119;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7500456;}i:123;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=6) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231642;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7503728;}i:126;a:6:{i:0;s:107:"Rendering view file: /Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/views/analysis/index.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1778585947.237526;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:91;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:7698840;}i:127;a:6:{i:0;s:105:"Rendering view file: /Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1778585947.247162;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:91;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:7986216;}}}";s:9:"profiling";s:32079:"a:3:{s:6:"memory";i:8333832;s:4:"time";d:0.3278489112854004;s:8:"messages";a:62:{i:7;a:6:{i:0;s:70:"Opening DB connection: mysql:host=127.0.0.1;dbname=appointment_booking";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1778585947.083525;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5572336;}i:8;a:6:{i:0;s:70:"Opening DB connection: mysql:host=127.0.0.1;dbname=appointment_booking";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1778585947.10088;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5619920;}i:9;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `users`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.101047;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5619864;}i:10;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `users`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.115869;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5630856;}i:12;a:6:{i:0;s:25:"SHOW CREATE TABLE `users`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.116221;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5633056;}i:13;a:6:{i:0;s:25:"SHOW CREATE TABLE `users`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.116888;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5635248;}i:15;a:6:{i:0;s:766:"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` = 'users' AND `kcu`.`TABLE_NAME` = 'users'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.120132;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5720344;}i:16;a:6:{i:0;s:766:"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` = 'users' AND `kcu`.`TABLE_NAME` = 'users'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.129926;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5722200;}i:18;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=1) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.149039;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6098440;}i:19;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=1) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.150814;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6100632;}i:49;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=6) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.201828;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7278096;}i:50;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=6) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.204864;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7279160;}i:52;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=7) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.205572;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7281784;}i:53;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=7) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.205863;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7282808;}i:55;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=8) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.206241;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7285000;}i:56;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=8) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.206446;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7286024;}i:58;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=9) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.206836;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7288216;}i:59;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=9) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207025;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7289240;}i:61;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=10) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207387;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7291432;}i:62;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=10) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207579;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7292456;}i:64;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=11) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.208016;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7294648;}i:65;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=11) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.208247;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7296952;}i:67;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=12) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.20862;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7299144;}i:68;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=12) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.208812;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7300168;}i:70;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=1) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.209204;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7302360;}i:71;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=1) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.209485;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7303384;}i:73;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=2) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.20988;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7305896;}i:74;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=2) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.210083;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7306920;}i:76;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=3) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.210477;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7309432;}i:77;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=3) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.210687;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7310456;}i:79;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=4) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211084;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7312648;}i:80;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=4) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211285;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7313672;}i:82;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=5) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211688;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7315864;}i:83;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=5) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.21196;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7316888;}i:85;a:6:{i:0;s:75:"SELECT * FROM `specialities` WHERE `status`=1 ORDER BY `sort_order`, `name`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.213388;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7343088;}i:86;a:6:{i:0;s:75:"SELECT * FROM `specialities` WHERE `status`=1 ORDER BY `sort_order`, `name`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.214267;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7347576;}i:88;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `specialities`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.214599;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7355616;}i:89;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `specialities`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.215719;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7363464;}i:91;a:6:{i:0;s:32:"SHOW CREATE TABLE `specialities`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.215948;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7366424;}i:92;a:6:{i:0;s:32:"SHOW CREATE TABLE `specialities`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.216223;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7368584;}i:94;a:6:{i:0;s:780:"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` = 'specialities' AND `kcu`.`TABLE_NAME` = 'specialities'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.216782;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7368376;}i:95;a:6:{i:0;s:780:"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` = 'specialities' AND `kcu`.`TABLE_NAME` = 'specialities'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.217456;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7370608;}i:97;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=1) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.220516;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7431544;}i:98;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=1) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.222435;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7434536;}i:100;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `doctors`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.222742;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7441576;}i:101;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `doctors`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.223413;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7453840;}i:103;a:6:{i:0;s:27:"SHOW CREATE TABLE `doctors`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.223595;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7456040;}i:104;a:6:{i:0;s:27:"SHOW CREATE TABLE `doctors`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.224203;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7458584;}i:106;a:6:{i:0;s:770:"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` = 'doctors' AND `kcu`.`TABLE_NAME` = 'doctors'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.224895;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7454480;}i:107;a:6:{i:0;s:770:"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` = 'doctors' AND `kcu`.`TABLE_NAME` = 'doctors'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.225418;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7457560;}i:109;a:6:{i:0;s:84:"SELECT COUNT(*) FROM `appointments` WHERE (`doctor_id`=1) AND (`status`='confirmed')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.228563;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.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:5;i:7488592;}i:110;a:6:{i:0;s:84:"SELECT COUNT(*) FROM `appointments` WHERE (`doctor_id`=1) AND (`status`='confirmed')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.229031;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.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:5;i:7489552;}i:112;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=2) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.229669;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7491880;}i:113;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=2) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.229899;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7493176;}i:115;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=3) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230212;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7494936;}i:116;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=3) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230396;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7496232;}i:118;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=4) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230697;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7498208;}i:119;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=4) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230892;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7499504;}i:121;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=5) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231164;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7501480;}i:122;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=5) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231384;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7502776;}i:124;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=6) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.23169;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7504752;}i:125;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=6) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231878;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7506048;}}}";s:2:"db";s:31231:"a:1:{s:8:"messages";a:60:{i:9;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `users`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.101047;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5619864;}i:10;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `users`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.115869;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5630856;}i:12;a:6:{i:0;s:25:"SHOW CREATE TABLE `users`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.116221;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5633056;}i:13;a:6:{i:0;s:25:"SHOW CREATE TABLE `users`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.116888;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5635248;}i:15;a:6:{i:0;s:766:"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` = 'users' AND `kcu`.`TABLE_NAME` = 'users'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.120132;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5720344;}i:16;a:6:{i:0;s:766:"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` = 'users' AND `kcu`.`TABLE_NAME` = 'users'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.129926;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5722200;}i:18;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=1) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.149039;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6098440;}i:19;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=1) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.150814;i:4;a:1:{i:0;a:5:{s:4:"file";s:76:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:71;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6100632;}i:49;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=6) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.201828;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7278096;}i:50;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=6) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.204864;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7279160;}i:52;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=7) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.205572;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7281784;}i:53;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=7) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.205863;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7282808;}i:55;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=8) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.206241;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7285000;}i:56;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=8) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.206446;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7286024;}i:58;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=9) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.206836;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7288216;}i:59;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=9) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207025;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7289240;}i:61;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=10) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207387;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7291432;}i:62;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=10) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.207579;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7292456;}i:64;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=11) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.208016;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7294648;}i:65;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=11) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.208247;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7296952;}i:67;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=12) AND (YEAR(appointment_date)=2025)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.20862;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7299144;}i:68;a:6:{i:0;s:131:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=12) AND (YEAR(appointment_date)=2025)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.208812;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7300168;}i:70;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=1) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.209204;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7302360;}i:71;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=1) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.209485;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7303384;}i:73;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=2) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.20988;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7305896;}i:74;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=2) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.210083;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7306920;}i:76;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=3) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.210477;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7309432;}i:77;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=3) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.210687;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7310456;}i:79;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=4) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211084;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7312648;}i:80;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=4) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211285;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7313672;}i:82;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=5) AND (YEAR(appointment_date)=2026)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.211688;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7315864;}i:83;a:6:{i:0;s:130:"SELECT COUNT(*) FROM `appointments` WHERE (`status`='confirmed') AND (MONTH(appointment_date)=5) AND (YEAR(appointment_date)=2026)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.21196;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:54;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:7316888;}i:85;a:6:{i:0;s:75:"SELECT * FROM `specialities` WHERE `status`=1 ORDER BY `sort_order`, `name`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.213388;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7343088;}i:86;a:6:{i:0;s:75:"SELECT * FROM `specialities` WHERE `status`=1 ORDER BY `sort_order`, `name`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.214267;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7347576;}i:88;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `specialities`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.214599;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7355616;}i:89;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `specialities`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.215719;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7363464;}i:91;a:6:{i:0;s:32:"SHOW CREATE TABLE `specialities`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.215948;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7366424;}i:92;a:6:{i:0;s:32:"SHOW CREATE TABLE `specialities`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.216223;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7368584;}i:94;a:6:{i:0;s:780:"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` = 'specialities' AND `kcu`.`TABLE_NAME` = 'specialities'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.216782;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7368376;}i:95;a:6:{i:0;s:780:"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` = 'specialities' AND `kcu`.`TABLE_NAME` = 'specialities'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.217456;i:4;a:2:{i:0;a:5:{s:4:"file";s:82:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/Speciality.php";s:4:"line";i:82;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:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:61;s:8:"function";s:10:"listActive";s:5:"class";s:24:"common\models\Speciality";s:4:"type";s:2:"::";}}i:5;i:7370608;}i:97;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=1) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.220516;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7431544;}i:98;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=1) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.222435;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7434536;}i:100;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `doctors`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.222742;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7441576;}i:101;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `doctors`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.223413;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7453840;}i:103;a:6:{i:0;s:27:"SHOW CREATE TABLE `doctors`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.223595;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7456040;}i:104;a:6:{i:0;s:27:"SHOW CREATE TABLE `doctors`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.224203;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7458584;}i:106;a:6:{i:0;s:770:"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` = 'doctors' AND `kcu`.`TABLE_NAME` = 'doctors'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.224895;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7454480;}i:107;a:6:{i:0;s:770:"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` = 'doctors' AND `kcu`.`TABLE_NAME` = 'doctors'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.225418;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7457560;}i:109;a:6:{i:0;s:84:"SELECT COUNT(*) FROM `appointments` WHERE (`doctor_id`=1) AND (`status`='confirmed')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.228563;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.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:5;i:7488592;}i:110;a:6:{i:0;s:84:"SELECT COUNT(*) FROM `appointments` WHERE (`doctor_id`=1) AND (`status`='confirmed')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.229031;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.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:5;i:7489552;}i:112;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=2) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.229669;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7491880;}i:113;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=2) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.229899;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7493176;}i:115;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=3) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230212;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7494936;}i:116;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=3) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230396;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7496232;}i:118;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=4) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230697;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7498208;}i:119;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=4) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.230892;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7499504;}i:121;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=5) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231164;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7501480;}i:122;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=5) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231384;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7502776;}i:124;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=6) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.23169;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7504752;}i:125;a:6:{i:0;s:66:"SELECT * FROM `doctors` WHERE (`speciality_id`=6) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778585947.231878;i:4;a:1:{i:0;a:5:{s:4:"file";s:96:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/AnalysisController.php";s:4:"line";i:68;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7506048;}}}";s:5:"event";s:9236:"a:54:{i:0;a:5:{s:4:"time";d:1778585947.068175;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:1778585947.100853;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:1778585947.152594;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:"common\models\User";}i:3;a:5:{s:4:"time";d:1778585947.152755;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"common\models\User";}i:4;a:5:{s:4:"time";d:1778585947.154626;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:"common\models\User";}i:5;a:5:{s:4:"time";d:1778585947.177211;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:1778585947.196523;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:1778585947.196698;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:38:"backend\controllers\AnalysisController";}i:8;a:5:{s:4:"time";d:1778585947.199846;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:1778585947.205057;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:1778585947.205956;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:1778585947.206534;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:1778585947.207111;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:1778585947.207696;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:1778585947.208339;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:1778585947.208907;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:1778585947.209582;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:1778585947.210179;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:1778585947.210788;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:1778585947.211388;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:1778585947.213098;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:1778585947.214408;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:22;a:5:{s:4:"time";d:1778585947.217738;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:23;a:5:{s:4:"time";d:1778585947.217859;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:24;a:5:{s:4:"time";d:1778585947.217971;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:25;a:5:{s:4:"time";d:1778585947.21808;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:26;a:5:{s:4:"time";d:1778585947.218207;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:27;a:5:{s:4:"time";d:1778585947.218296;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:28;a:5:{s:4:"time";d:1778585947.218326;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:29;a:5:{s:4:"time";d:1778585947.218355;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:30;a:5:{s:4:"time";d:1778585947.218384;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:31;a:5:{s:4:"time";d:1778585947.218412;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:32;a:5:{s:4:"time";d:1778585947.218441;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\Speciality";}i:33;a:5:{s:4:"time";d:1778585947.22016;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:34;a:5:{s:4:"time";d:1778585947.222565;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"common\models\Doctor";}i:35;a:5:{s:4:"time";d:1778585947.225646;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"common\models\Doctor";}i:36;a:5:{s:4:"time";d:1778585947.225728;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:37;a:5:{s:4:"time";d:1778585947.229422;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:38;a:5:{s:4:"time";d:1778585947.229996;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:1778585947.230477;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:40;a:5:{s:4:"time";d:1778585947.230963;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:41;a:5:{s:4:"time";d:1778585947.231461;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:42;a:5:{s:4:"time";d:1778585947.237504;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:43;a:5:{s:4:"time";d:1778585947.246957;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:44;a:5:{s:4:"time";d:1778585947.247146;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:45;a:5:{s:4:"time";d:1778585947.248516;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:46;a:5:{s:4:"time";d:1778585947.256983;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:47;a:5:{s:4:"time";d:1778585947.257077;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:48;a:5:{s:4:"time";d:1778585947.257225;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:38:"backend\controllers\AnalysisController";}i:49;a:5:{s:4:"time";d:1778585947.257282;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:50;a:5:{s:4:"time";d:1778585947.25732;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:51;a:5:{s:4:"time";d:1778585947.257349;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:52;a:5:{s:4:"time";d:1778585947.258718;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:53;a:5:{s:4:"time";d:1778585947.260028;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:91:"a:3:{s:5:"start";d:1778585946.933826;s:3:"end";d:1778585947.263177;s:6:"memory";i:8333832;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:4208:"a:3:{s:8:"messages";a:22:{i:23;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:1778585947.179788;i:4;a:0:{}i:5;i:6928872;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:12:"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:1778585947.179968;i:4;a:0:{}i:5;i:6929464;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:41:"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:1778585947.181357;i:4;a:0:{}i:5;i:6930056;}i:26;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:1778585947.181407;i:4;a:0:{}i:5;i:6930648;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:43:"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:1778585947.181432;i:4;a:0:{}i:5;i:6931240;}i:28;a:6:{i:0;a:3:{s:4:"rule";s:1:"/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.181458;i:4;a:0:{}i:5;i:6931832;}i:29;a:6:{i:0;a:3:{s:4:"rule";s:5:"login";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.181521;i:4;a:0:{}i:5;i:6932424;}i:30;a:6:{i:0;a:3:{s:4:"rule";s:6:"verify";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.181572;i:4;a:0:{}i:5;i:6933016;}i:31;a:6:{i:0;a:3:{s:4:"rule";s:6:"logout";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.181595;i:4;a:0:{}i:5;i:6933608;}i:32;a:6:{i:0;a:3:{s:4:"rule";s:9:"dashboard";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182603;i:4;a:0:{}i:5;i:6934200;}i:33;a:6:{i:0;a:3:{s:4:"rule";s:7:"doctors";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182643;i:4;a:0:{}i:5;i:6935432;}i:34;a:6:{i:0;a:3:{s:4:"rule";s:14:"doctors/create";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182672;i:4;a:0:{}i:5;i:6936024;}i:35;a:6:{i:0;a:3:{s:4:"rule";s:23:"doctors/update/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182706;i:4;a:0:{}i:5;i:6936616;}i:36;a:6:{i:0;a:3:{s:4:"rule";s:29:"doctors/availability/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182739;i:4;a:0:{}i:5;i:6937208;}i:37;a:6:{i:0;a:3:{s:4:"rule";s:27:"doctors/deactivate/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182771;i:4;a:0:{}i:5;i:6937800;}i:38;a:6:{i:0;a:3:{s:4:"rule";s:25:"doctors/activate/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182803;i:4;a:0:{}i:5;i:6938392;}i:39;a:6:{i:0;a:3:{s:4:"rule";s:6:"leaves";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182831;i:4;a:0:{}i:5;i:6938984;}i:40;a:6:{i:0;a:3:{s:4:"rule";s:29:"leaves/doctor/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182862;i:4;a:0:{}i:5;i:6939576;}i:41;a:6:{i:0;a:3:{s:4:"rule";s:13:"leaves/create";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182891;i:4;a:0:{}i:5;i:6940168;}i:42;a:6:{i:0;a:3:{s:4:"rule";s:22:"leaves/delete/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.18292;i:4;a:0:{}i:5;i:6940760;}i:43;a:6:{i:0;s:38:"Request parsed with URL rule: analysis";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1778585947.182964;i:4;a:0:{}i:5;i:6941704;}i:44;a:6:{i:0;a:3:{s:4:"rule";s:8:"analysis";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778585947.182985;i:4;a:0:{}i:5;i:6941848;}}s:5:"route";s:14:"analysis/index";s:6:"action";s:53:"backend\controllers\AnalysisController::actionIndex()";}";s:7:"request";s:5548:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:17:{s:4:"host";s:9:"localhost";s:10:"connection";s:10:"keep-alive";s:13:"cache-control";s:9:"max-age=0";s:9:"sec-ch-ua";s:64:""Google Chrome";v="147", "Not.A/Brand";v="8", "Chromium";v="147"";s:16:"sec-ch-ua-mobile";s:2:"?0";s:18:"sec-ch-ua-platform";s:7:""macOS"";s:25:"upgrade-insecure-requests";s:1:"1";s:10:"user-agent";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36";s:6:"accept";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:14:"sec-fetch-site";s:11:"same-origin";s:14:"sec-fetch-mode";s:8:"navigate";s:14:"sec-fetch-user";s:2:"?1";s:14:"sec-fetch-dest";s:8:"document";s:7:"referer";s:85:"http://localhost/forbaxy-appointment-booking/backend/web/index.php/?month=5&year=2026";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:15:"accept-language";s:26:"en-GB,en-US;q=0.9,en;q=0.8";s:6:"cookie";s:355:"_ga_N1XD6SRDWJ=GS2.1.s1778234377$o1$g0$t1778234377$j60$l0$h0; _ga=GA1.1.943326478.1778234378; frontend_session=683spu3hbe0q5omrr53emrgnej; backend_session=2kg8o5vo4foqbtl1a9vg4n3r3e; _csrf=d00586c1f1d745ab85162071bd28a22d746e5630cca982343adcdeb70e0ce2c3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%2224qDuoWzgrBtxh11Ixq6skmaNnJT8vBT%22%3B%7D";}s:15:"responseHeaders";a:8:{s:12:"X-Powered-By";s:9:"PHP/8.2.0";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:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:11:"X-Debug-Tag";s:13:"6a03115b28157";s:16:"X-Debug-Duration";s:3:"326";s:12:"X-Debug-Link";s:87:"/forbaxy-appointment-booking/backend/web/index.php/debug/default/view?tag=6a03115b28157";}s:5:"route";s:14:"analysis/index";s:6:"action";s:53:"backend\controllers\AnalysisController::actionIndex()";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:0;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:42:{s:9:"HTTP_HOST";s:9:"localhost";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:18:"HTTP_CACHE_CONTROL";s:9:"max-age=0";s:14:"HTTP_SEC_CH_UA";s:64:""Google Chrome";v="147", "Not.A/Brand";v="8", "Chromium";v="147"";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:7:""macOS"";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:15:"HTTP_USER_AGENT";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36";s:11:"HTTP_ACCEPT";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_USER";s:2:"?1";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:12:"HTTP_REFERER";s:85:"http://localhost/forbaxy-appointment-booking/backend/web/index.php/?month=5&year=2026";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:20:"HTTP_ACCEPT_LANGUAGE";s:26:"en-GB,en-US;q=0.9,en;q=0.8";s:11:"HTTP_COOKIE";s:355:"_ga_N1XD6SRDWJ=GS2.1.s1778234377$o1$g0$t1778234377$j60$l0$h0; _ga=GA1.1.943326478.1778234378; frontend_session=683spu3hbe0q5omrr53emrgnej; backend_session=2kg8o5vo4foqbtl1a9vg4n3r3e; _csrf=d00586c1f1d745ab85162071bd28a22d746e5630cca982343adcdeb70e0ce2c3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%2224qDuoWzgrBtxh11Ixq6skmaNnJT8vBT%22%3B%7D";s:4:"PATH";s:29:"/usr/bin:/bin:/usr/sbin:/sbin";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:141:"Apache/2.4.54 (Unix) OpenSSL/1.0.2u PHP/8.2.0 mod_wsgi/3.5 Python/2.7.18 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_perl/2.0.11 Perl/v5.30.1";s:11:"SERVER_NAME";s:9:"localhost";s:11:"SERVER_ADDR";s:3:"::1";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:3:"::1";s:13:"DOCUMENT_ROOT";s:25:"/Applications/MAMP/htdocs";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:25:"/Applications/MAMP/htdocs";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:15:"SCRIPT_FILENAME";s:75:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"60507";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:59:"/forbaxy-appointment-booking/backend/web/index.php/analysis";s:11:"SCRIPT_NAME";s:50:"/forbaxy-appointment-booking/backend/web/index.php";s:9:"PATH_INFO";s:9:"/analysis";s:15:"PATH_TRANSLATED";s:34:"/Applications/MAMP/htdocs/analysis";s:8:"PHP_SELF";s:59:"/forbaxy-appointment-booking/backend/web/index.php/analysis";s:18:"REQUEST_TIME_FLOAT";d:1778585946.840164;s:12:"REQUEST_TIME";i:1778585946;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:5:{s:14:"_ga_N1XD6SRDWJ";s:45:"GS2.1.s1778234377$o1$g0$t1778234377$j60$l0$h0";s:3:"_ga";s:26:"GA1.1.943326478.1778234378";s:16:"frontend_session";s:26:"683spu3hbe0q5omrr53emrgnej";s:15:"backend_session";s:26:"2kg8o5vo4foqbtl1a9vg4n3r3e";s:5:"_csrf";s:130:"d00586c1f1d745ab85162071bd28a22d746e5630cca982343adcdeb70e0ce2c3a:2:{i:0;s:5:"_csrf";i:1;s:32:"24qDuoWzgrBtxh11Ixq6skmaNnJT8vBT";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:4:{s:7:"__flash";a:0:{}s:11:"__returnUrl";s:57:"http://localhost/forbaxy-appointment-booking/backend/web/";s:4:"__id";i:1;s:9:"__authKey";s:32:"-GNs_0AEH8f72OjySmmRY9cJTnMsS_Nv";}}";s:4:"user";s:1127:"a:5:{s:2:"id";i:1;s:8:"identity";a:10:{s:2:"id";s:1:"1";s:4:"name";s:15:"'Forbaxy Admin'";s:5:"phone";s:12:"'7877550099'";s:5:"email";s:18:"'admin@forbaxy.in'";s:4:"role";s:7:"'admin'";s:6:"status";s:1:"1";s:8:"auth_key";s:34:"'-GNs_0AEH8f72OjySmmRY9cJTnMsS_Nv'";s:13:"last_login_at";s:10:"1778584236";s:10:"created_at";s:10:"1778561242";s:10:"updated_at";s:10:"1778584236";}s:10:"attributes";a:10:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"Id";}i:1;a:2:{s:9:"attribute";s:4:"name";s:5:"label";s:9:"Full name";}i:2;a:2:{s:9:"attribute";s:5:"phone";s:5:"label";s:13:"Mobile number";}i:3;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:4;a:2:{s:9:"attribute";s:4:"role";s:5:"label";s:4:"Role";}i:5;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:6:"Status";}i:6;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:7;a:2:{s:9:"attribute";s:13:"last_login_at";s:5:"label";s:13:"Last Login At";}i:8;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:10:"Created At";}i:9;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:10:"Updated At";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a03115b28157";s:3:"url";s:75:"http://localhost/forbaxy-appointment-booking/backend/web/index.php/analysis";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:3:"::1";s:4:"time";d:1778585946.840164;s:10:"statusCode";i:200;s:8:"sqlCount";i:30;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8333832;s:14:"processingTime";d:0.3278489112854004;}s:10:"exceptions";a:0:{}}