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:14669:"a:1:{s:8:"messages";a:33:{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:1778584492.433097;i:4;a:0:{}i:5;i:3194768;}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:1778584492.43488;i:4;a:0:{}i:5;i:3224992;}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:1778584492.442004;i:4;a:0:{}i:5;i:3449560;}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:1778584492.442044;i:4;a:0:{}i:5;i:3450200;}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:1778584492.465096;i:4;a:0:{}i:5;i:4252904;}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:1778584492.508311;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:5577944;}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:1778584492.5085;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:5580064;}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:1778584492.513774;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:5640680;}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:1778584492.516439;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:5727840;}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:1778584492.533566;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:6106592;}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:1778584492.547358;i:4;a:0:{}i:5;i:6459792;}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:1778584492.556109;i:4;a:0:{}i:5;i:6684152;}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:1778584492.557249;i:4;a:0:{}i:5;i:6708616;}i:38;a:6:{i:0;s:38:"Route requested: 'doctor/availability'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1778584492.565718;i:4;a:0:{}i:5;i:6947640;}i:39;a:6:{i:0;s:33:"Route to run: doctor/availability";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1778584492.570607;i:4;a:0:{}i:5;i:7057456;}i:40;a:6:{i:0;s:74:"Running action: backend\controllers\DoctorController::actionAvailability()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1778584492.583379;i:4;a:0:{}i:5;i:7351288;}i:41;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:1778584492.584779;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7402840;}i:44;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:1778584492.587518;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7418432;}i:47;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:1778584492.588699;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7417872;}i:50;a:6:{i:0;s:36:"SELECT * FROM `doctors` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.589864;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7422216;}i:53;a:6:{i:0;s:92:"SELECT * FROM `doctor_availability` WHERE `doctor_id`=1 ORDER BY `day_of_week`, `start_time`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.59223;i:4;a:2:{i:0;a:5:{s:4:"file";s:90:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/DoctorAvailability.php";s:4:"line";i:126;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:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:161;s:8:"function";s:12:"groupedByDay";s:5:"class";s:32:"common\models\DoctorAvailability";s:4:"type";s:2:"::";}}i:5;i:7463680;}i:56;a:6:{i:0;s:17:"Begin transaction";i:1;i:8;i:2;s:25:"yii\db\Transaction::begin";i:3;d:1778584492.595224;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:166;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:7550888;}i:57;a:6:{i:0;s:53:"DELETE FROM `doctor_availability` WHERE `doctor_id`=1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.595687;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:170;s:8:"function";s:9:"deleteAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7554320;}i:60;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `doctor_availability`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.596301;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7562600;}i:63;a:6:{i:0;s:39:"SHOW CREATE TABLE `doctor_availability`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.597323;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7574224;}i:66;a:6:{i:0;s:794:"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` = 'doctor_availability' AND `kcu`.`TABLE_NAME` = 'doctor_availability'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.598332;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7575480;}i:69;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 1, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.607532;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7679168;}i:72;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 2, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.612018;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7697208;}i:75;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 3, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.614257;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7713032;}i:78;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 4, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.61628;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7728856;}i:81;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 5, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.622171;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7745320;}i:84;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 6, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.624078;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7761144;}i:87;a:6:{i:0;s:18:"Commit transaction";i:1;i:8;i:2;s:26:"yii\db\Transaction::commit";i:3;d:1778584492.624604;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:194;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}}i:5;i:7759392;}}}";s:9:"profiling";s:24413:"a:3:{s:6:"memory";i:7856008;s:4:"time";d:0.27350497245788574;s:8:"messages";a:40:{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:1778584492.50858;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:5580872;}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:1778584492.512134;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:5628456;}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:1778584492.512251;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:5628400;}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:1778584492.513598;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:5639392;}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:1778584492.513869;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:5641592;}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:1778584492.514083;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:5643784;}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:1778584492.516547;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:5728880;}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:1778584492.517202;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:5730736;}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:1778584492.533678;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:6106976;}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:1778584492.534384;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:6109168;}i:42;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:1778584492.584858;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7404128;}i:43;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:1778584492.587405;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7416768;}i:45;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:1778584492.587586;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7419720;}i:46;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:1778584492.587977;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7422640;}i:48;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:1778584492.588765;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7419288;}i:49;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:1778584492.589306;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7422744;}i:51;a:6:{i:0;s:36:"SELECT * FROM `doctors` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.589921;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7423720;}i:52;a:6:{i:0;s:36:"SELECT * FROM `doctors` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.590373;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7426800;}i:54;a:6:{i:0;s:92:"SELECT * FROM `doctor_availability` WHERE `doctor_id`=1 ORDER BY `day_of_week`, `start_time`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.59229;i:4;a:2:{i:0;a:5:{s:4:"file";s:90:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/DoctorAvailability.php";s:4:"line";i:126;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:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:161;s:8:"function";s:12:"groupedByDay";s:5:"class";s:32:"common\models\DoctorAvailability";s:4:"type";s:2:"::";}}i:5;i:7465184;}i:55;a:6:{i:0;s:92:"SELECT * FROM `doctor_availability` WHERE `doctor_id`=1 ORDER BY `day_of_week`, `start_time`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.593521;i:4;a:2:{i:0;a:5:{s:4:"file";s:90:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/DoctorAvailability.php";s:4:"line";i:126;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:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:161;s:8:"function";s:12:"groupedByDay";s:5:"class";s:32:"common\models\DoctorAvailability";s:4:"type";s:2:"::";}}i:5;i:7466776;}i:58;a:6:{i:0;s:53:"DELETE FROM `doctor_availability` WHERE `doctor_id`=1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.595746;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:170;s:8:"function";s:9:"deleteAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7555448;}i:59;a:6:{i:0;s:53:"DELETE FROM `doctor_availability` WHERE `doctor_id`=1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.596055;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:170;s:8:"function";s:9:"deleteAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7556360;}i:61;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `doctor_availability`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.596366;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7563512;}i:62;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `doctor_availability`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.597235;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7572928;}i:64;a:6:{i:0;s:39:"SHOW CREATE TABLE `doctor_availability`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.597383;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7575136;}i:65;a:6:{i:0;s:39:"SHOW CREATE TABLE `doctor_availability`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.597715;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7578464;}i:67;a:6:{i:0;s:794:"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` = 'doctor_availability' AND `kcu`.`TABLE_NAME` = 'doctor_availability'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.598395;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7576520;}i:68;a:6:{i:0;s:794:"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` = 'doctor_availability' AND `kcu`.`TABLE_NAME` = 'doctor_availability'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.598886;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7579056;}i:70;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 1, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.607625;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7679568;}i:71;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 1, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.609392;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7680704;}i:73;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 2, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.612094;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7697608;}i:74;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 2, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.612595;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7698744;}i:76;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 3, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.614338;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7713432;}i:77;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 3, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.614553;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7714568;}i:79;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 4, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.616351;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7729256;}i:80;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 4, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.620305;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7730392;}i:82;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 5, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.622248;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7745720;}i:83;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 5, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.622456;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7746856;}i:85;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 6, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.624142;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7761544;}i:86;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 6, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.624451;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7762680;}}}";s:2:"db";s:23564:"a:1:{s:8:"messages";a:38:{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:1778584492.512251;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:5628400;}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:1778584492.513598;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:5639392;}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:1778584492.513869;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:5641592;}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:1778584492.514083;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:5643784;}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:1778584492.516547;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:5728880;}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:1778584492.517202;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:5730736;}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:1778584492.533678;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:6106976;}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:1778584492.534384;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:6109168;}i:42;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:1778584492.584858;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7404128;}i:43;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:1778584492.587405;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7416768;}i:45;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:1778584492.587586;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7419720;}i:46;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:1778584492.587977;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7422640;}i:48;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:1778584492.588765;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7419288;}i:49;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:1778584492.589306;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7422744;}i:51;a:6:{i:0;s:36:"SELECT * FROM `doctors` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.589921;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7423720;}i:52;a:6:{i:0;s:36:"SELECT * FROM `doctors` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.590373;i:4;a:2:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:245;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:160;s:8:"function";s:10:"findDoctor";s:5:"class";s:36:"backend\controllers\DoctorController";s:4:"type";s:2:"->";}}i:5;i:7426800;}i:54;a:6:{i:0;s:92:"SELECT * FROM `doctor_availability` WHERE `doctor_id`=1 ORDER BY `day_of_week`, `start_time`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.59229;i:4;a:2:{i:0;a:5:{s:4:"file";s:90:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/DoctorAvailability.php";s:4:"line";i:126;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:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:161;s:8:"function";s:12:"groupedByDay";s:5:"class";s:32:"common\models\DoctorAvailability";s:4:"type";s:2:"::";}}i:5;i:7465184;}i:55;a:6:{i:0;s:92:"SELECT * FROM `doctor_availability` WHERE `doctor_id`=1 ORDER BY `day_of_week`, `start_time`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.593521;i:4;a:2:{i:0;a:5:{s:4:"file";s:90:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/common/models/DoctorAvailability.php";s:4:"line";i:126;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:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:161;s:8:"function";s:12:"groupedByDay";s:5:"class";s:32:"common\models\DoctorAvailability";s:4:"type";s:2:"::";}}i:5;i:7466776;}i:58;a:6:{i:0;s:53:"DELETE FROM `doctor_availability` WHERE `doctor_id`=1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.595746;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:170;s:8:"function";s:9:"deleteAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7555448;}i:59;a:6:{i:0;s:53:"DELETE FROM `doctor_availability` WHERE `doctor_id`=1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.596055;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:170;s:8:"function";s:9:"deleteAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7556360;}i:61;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `doctor_availability`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.596366;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7563512;}i:62;a:6:{i:0;s:44:"SHOW FULL COLUMNS FROM `doctor_availability`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.597235;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7572928;}i:64;a:6:{i:0;s:39:"SHOW CREATE TABLE `doctor_availability`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.597383;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7575136;}i:65;a:6:{i:0;s:39:"SHOW CREATE TABLE `doctor_availability`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.597715;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7578464;}i:67;a:6:{i:0;s:794:"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` = 'doctor_availability' AND `kcu`.`TABLE_NAME` = 'doctor_availability'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.598395;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7576520;}i:68;a:6:{i:0;s:794:"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` = 'doctor_availability' AND `kcu`.`TABLE_NAME` = 'doctor_availability'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1778584492.598886;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:181;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7579056;}i:70;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 1, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.607625;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7679568;}i:71;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 1, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.609392;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7680704;}i:73;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 2, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.612094;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7697608;}i:74;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 2, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.612595;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7698744;}i:76;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 3, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.614338;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7713432;}i:77;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 3, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.614553;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7714568;}i:79;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 4, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.616351;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7729256;}i:80;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 4, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.620305;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7730392;}i:82;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 5, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.622248;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7745720;}i:83;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 5, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.622456;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7746856;}i:85;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 6, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.624142;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7761544;}i:86;a:6:{i:0;s:217:"INSERT INTO `doctor_availability` (`doctor_id`, `day_of_week`, `start_time`, `end_time`, `slot_duration_minutes`, `is_active`, `created_at`, `updated_at`) VALUES (1, 6, '10:00', '16:00', 15, 1, 1778584492, 1778584492)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1778584492.624451;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/MAMP/htdocs/forbaxy-appointment-booking/backend/controllers/DoctorController.php";s:4:"line";i:184;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7762680;}}}";s:5:"event";s:9213:"a:50:{i:0;a:5:{s:4:"time";d:1778584492.495338;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:1778584492.512116;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:1778584492.535904;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:1778584492.536057;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:1778584492.53826;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:1778584492.562404;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:1778584492.579063;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:1778584492.579965;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"backend\controllers\DoctorController";}i:8;a:5:{s:4:"time";d:1778584492.58461;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:1778584492.5905;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:10;a:5:{s:4:"time";d:1778584492.590632;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:11;a:5:{s:4:"time";d:1778584492.591989;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:1778584492.5953;s:4:"name";s:16:"beginTransaction";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:13;a:5:{s:4:"time";d:1778584492.596166;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:14;a:5:{s:4:"time";d:1778584492.604535;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:15;a:5:{s:4:"time";d:1778584492.606958;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:16;a:5:{s:4:"time";d:1778584492.607082;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:17;a:5:{s:4:"time";d:1778584492.610196;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:18;a:5:{s:4:"time";d:1778584492.610303;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:19;a:5:{s:4:"time";d:1778584492.610968;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:20;a:5:{s:4:"time";d:1778584492.61156;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:21;a:5:{s:4:"time";d:1778584492.611661;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:22;a:5:{s:4:"time";d:1778584492.612724;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:23;a:5:{s:4:"time";d:1778584492.612794;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:24;a:5:{s:4:"time";d:1778584492.613314;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:25;a:5:{s:4:"time";d:1778584492.613868;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:26;a:5:{s:4:"time";d:1778584492.613952;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:27;a:5:{s:4:"time";d:1778584492.614674;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:28;a:5:{s:4:"time";d:1778584492.614744;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:29;a:5:{s:4:"time";d:1778584492.615252;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:30;a:5:{s:4:"time";d:1778584492.615862;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:31;a:5:{s:4:"time";d:1778584492.61595;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:32;a:5:{s:4:"time";d:1778584492.620491;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:33;a:5:{s:4:"time";d:1778584492.620589;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:34;a:5:{s:4:"time";d:1778584492.621162;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:35;a:5:{s:4:"time";d:1778584492.621756;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:36;a:5:{s:4:"time";d:1778584492.621845;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:37;a:5:{s:4:"time";d:1778584492.622578;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:38;a:5:{s:4:"time";d:1778584492.622642;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:39;a:5:{s:4:"time";d:1778584492.623162;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:40;a:5:{s:4:"time";d:1778584492.623692;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:41;a:5:{s:4:"time";d:1778584492.623777;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:42;a:5:{s:4:"time";d:1778584492.62457;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:43;a:5:{s:4:"time";d:1778584492.625021;s:4:"name";s:17:"commitTransaction";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:44;a:5:{s:4:"time";d:1778584492.627413;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"backend\controllers\DoctorController";}i:45;a:5:{s:4:"time";d:1778584492.627465;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:46;a:5:{s:4:"time";d:1778584492.627499;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:47;a:5:{s:4:"time";d:1778584492.627527;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:48;a:5:{s:4:"time";d:1778584492.629332;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:49;a:5:{s:4:"time";d:1778584492.629462;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:1778584492.363396;s:3:"end";d:1778584492.638063;s:6:"memory";i:7856008;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:2914:"a:3:{s:8:"messages";a:15:{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:1778584492.563414;i:4;a:0:{}i:5;i:6939088;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778584492.56345;i:4;a:0:{}i:5;i:6939680;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778584492.563474;i:4;a:0:{}i:5;i:6940272;}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:1778584492.563498;i:4;a:0:{}i:5;i:6940864;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778584492.563521;i:4;a:0:{}i:5;i:6941456;}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:1778584492.563554;i:4;a:0:{}i:5;i:6942048;}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:1778584492.563576;i:4;a:0:{}i:5;i:6942640;}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:1778584492.563654;i:4;a:0:{}i:5;i:6943232;}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:1778584492.563681;i:4;a:0:{}i:5;i:6943824;}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:1778584492.563708;i:4;a:0:{}i:5;i:6944416;}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:1778584492.563737;i:4;a:0:{}i:5;i:6945648;}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:1778584492.563764;i:4;a:0:{}i:5;i:6946240;}i:35;a:6:{i:0;a:3:{s:4:"rule";s:23:"doctors/update/<id:\d+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778584492.565603;i:4;a:0:{}i:5;i:6946832;}i:36;a:6:{i:0;s:59:"Request parsed with URL rule: doctors/availability/<id:\d+>";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1778584492.565671;i:4;a:0:{}i:5;i:6948352;}i:37;a:6:{i:0;a:3:{s:4:"rule";s:29:"doctors/availability/<id:\d+>";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1778584492.565693;i:4;a:0:{}i:5;i:6948328;}}s:5:"route";s:19:"doctor/availability";s:6:"action";s:58:"backend\controllers\DoctorController::actionAvailability()";}";s:7:"request";s:9368:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:302;s:14:"requestHeaders";a:20:{s:4:"host";s:9:"localhost";s:10:"connection";s:10:"keep-alive";s:14:"content-length";s:4:"1292";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:6:"origin";s:16:"http://localhost";s:12:"content-type";s:33:"application/x-www-form-urlencoded";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:89:"http://localhost/forbaxy-appointment-booking/backend/web/index.php/doctors/availability/1";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=123b4b5bca576c8ce4668da9d2e6a06d5c2ff3f261c7e48dcfd34eca17a5abd3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22TbzETSf-G6GbF3_b6hnceH3EkB1yBeRD%22%3B%7D";}s:15:"responseHeaders";a:9:{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:8:"Location";s:74:"http://localhost/forbaxy-appointment-booking/backend/web/index.php/doctors";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:11:"X-Debug-Tag";s:13:"6a030bac8604d";s:16:"X-Debug-Duration";s:3:"266";s:12:"X-Debug-Link";s:87:"/forbaxy-appointment-booking/backend/web/index.php/debug/default/view?tag=6a030bac8604d";}s:5:"route";s:19:"doctor/availability";s:6:"action";s:58:"backend\controllers\DoctorController::actionAvailability()";s:12:"actionParams";a:1:{s:2:"id";i:1;}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:0;}s:11:"requestBody";a:3:{s:12:"Content Type";s:33:"application/x-www-form-urlencoded";s:3:"Raw";s:1292:"_csrf=9ZEHt1Bz-aar4a0SGpoMACXDjjKIBRFnT1sZKB6adlqh833yBCCfi-zX6nBcqVNiE6vgUe1NIiIkGShRXP8kHg%3D%3D&DoctorAvailability%5B0%5D%5Bday_of_week%5D=1&DoctorAvailability%5B0%5D%5Bstart_time%5D=10%3A00&DoctorAvailability%5B0%5D%5Bend_time%5D=16%3A00&DoctorAvailability%5B0%5D%5Bslot_duration_minutes%5D=15&DoctorAvailability%5B1%5D%5Bday_of_week%5D=2&DoctorAvailability%5B1%5D%5Bstart_time%5D=10%3A00&DoctorAvailability%5B1%5D%5Bend_time%5D=16%3A00&DoctorAvailability%5B1%5D%5Bslot_duration_minutes%5D=15&DoctorAvailability%5B2%5D%5Bday_of_week%5D=3&DoctorAvailability%5B2%5D%5Bstart_time%5D=10%3A00&DoctorAvailability%5B2%5D%5Bend_time%5D=16%3A00&DoctorAvailability%5B2%5D%5Bslot_duration_minutes%5D=15&DoctorAvailability%5B3%5D%5Bday_of_week%5D=4&DoctorAvailability%5B3%5D%5Bstart_time%5D=10%3A00&DoctorAvailability%5B3%5D%5Bend_time%5D=16%3A00&DoctorAvailability%5B3%5D%5Bslot_duration_minutes%5D=15&DoctorAvailability%5B4%5D%5Bday_of_week%5D=5&DoctorAvailability%5B4%5D%5Bstart_time%5D=10%3A00&DoctorAvailability%5B4%5D%5Bend_time%5D=16%3A00&DoctorAvailability%5B4%5D%5Bslot_duration_minutes%5D=15&DoctorAvailability%5B5%5D%5Bday_of_week%5D=6&DoctorAvailability%5B5%5D%5Bstart_time%5D=10%3A00&DoctorAvailability%5B5%5D%5Bend_time%5D=16%3A00&DoctorAvailability%5B5%5D%5Bslot_duration_minutes%5D=15";s:7:"Decoded";a:2:{s:5:"_csrf";s:88:"9ZEHt1Bz-aar4a0SGpoMACXDjjKIBRFnT1sZKB6adlqh833yBCCfi-zX6nBcqVNiE6vgUe1NIiIkGShRXP8kHg==";s:18:"DoctorAvailability";a:6:{i:0;a:4:{s:11:"day_of_week";s:1:"1";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:1;a:4:{s:11:"day_of_week";s:1:"2";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:2;a:4:{s:11:"day_of_week";s:1:"3";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:3;a:4:{s:11:"day_of_week";s:1:"4";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:4;a:4:{s:11:"day_of_week";s:1:"5";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:5;a:4:{s:11:"day_of_week";s:1:"6";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}}}}s:6:"SERVER";a:45:{s:9:"HTTP_HOST";s:9:"localhost";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:14:"CONTENT_LENGTH";s:4:"1292";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:11:"HTTP_ORIGIN";s:16:"http://localhost";s:12:"CONTENT_TYPE";s:33:"application/x-www-form-urlencoded";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:89:"http://localhost/forbaxy-appointment-booking/backend/web/index.php/doctors/availability/1";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=123b4b5bca576c8ce4668da9d2e6a06d5c2ff3f261c7e48dcfd34eca17a5abd3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22TbzETSf-G6GbF3_b6hnceH3EkB1yBeRD%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:"60170";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:4:"POST";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:73:"/forbaxy-appointment-booking/backend/web/index.php/doctors/availability/1";s:11:"SCRIPT_NAME";s:50:"/forbaxy-appointment-booking/backend/web/index.php";s:9:"PATH_INFO";s:23:"/doctors/availability/1";s:15:"PATH_TRANSLATED";s:48:"/Applications/MAMP/htdocs/doctors/availability/1";s:8:"PHP_SELF";s:73:"/forbaxy-appointment-booking/backend/web/index.php/doctors/availability/1";s:18:"REQUEST_TIME_FLOAT";d:1778584492.294159;s:12:"REQUEST_TIME";i:1778584492;}s:3:"GET";a:1:{s:2:"id";s:1:"1";}s:4:"POST";a:2:{s:5:"_csrf";s:88:"9ZEHt1Bz-aar4a0SGpoMACXDjjKIBRFnT1sZKB6adlqh833yBCCfi-zX6nBcqVNiE6vgUe1NIiIkGShRXP8kHg==";s:18:"DoctorAvailability";a:6:{i:0;a:4:{s:11:"day_of_week";s:1:"1";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:1;a:4:{s:11:"day_of_week";s:1:"2";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:2;a:4:{s:11:"day_of_week";s:1:"3";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:3;a:4:{s:11:"day_of_week";s:1:"4";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:4;a:4:{s:11:"day_of_week";s:1:"5";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}i:5;a:4:{s:11:"day_of_week";s:1:"6";s:10:"start_time";s:5:"10:00";s:8:"end_time";s:5:"16:00";s:21:"slot_duration_minutes";s:2:"15";}}}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:"123b4b5bca576c8ce4668da9d2e6a06d5c2ff3f261c7e48dcfd34eca17a5abd3a:2:{i:0;s:5:"_csrf";i:1;s:32:"TbzETSf-G6GbF3_b6hnceH3EkB1yBeRD";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:5:{s:7:"__flash";a:1:{s:7:"success";i:-1;}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:7:"success";s:50:"Availability updated for  Dr. Rajesh Kumar Pandey.";}}";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:"6a030bac8604d";s:3:"url";s:89:"http://localhost/forbaxy-appointment-booking/backend/web/index.php/doctors/availability/1";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:3:"::1";s:4:"time";d:1778584492.294159;s:10:"statusCode";i:302;s:8:"sqlCount";i:19;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:7856008;s:14:"processingTime";d:0.27350497245788574;}s:10:"exceptions";a:0:{}}