a:14:{s:6:"config";s:2084:"a:5:{s:10:"phpVersion";s:6:"8.4.19";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:6:"8.4.19";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:6:{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:111:"/home/u618794172/domains/theconnecthub.in/public_html/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:116:"/home/u618794172/domains/theconnecthub.in/public_html/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:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/yiisoft/yii2-debug/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:109:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/yiisoft/yii2-gii/src";}}s:26:"yiisoft/yii2-symfonymailer";a:3:{s:4:"name";s:26:"yiisoft/yii2-symfonymailer";s:7:"version";s:7:"3.0.0.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:119:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/yiisoft/yii2-symfonymailer/src";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:117:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/yiisoft/yii2-swiftmailer/src";}}}}";s:3:"log";s:22896:"a:1:{s:8:"messages";a:39:{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:1779277369.964401;i:4;a:0:{}i:5;i:754360;}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:1779277369.964487;i:4;a:0:{}i:5;i:761968;}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:1779277369.965697;i:4;a:0:{}i:5;i:771752;}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:1779277369.965718;i:4;a:0:{}i:5;i:772392;}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:1779277369.966575;i:4;a:0:{}i:5;i:803976;}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:1779277369.96727;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:821000;}i:6;a:6:{i:0;s:73:"Opening DB connection: mysql:host=127.0.0.1;dbname=u618794172_appointment";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1779277369.967322;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:823136;}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:1779277369.969491;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:879600;}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:1779277369.969971;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:879960;}i:17;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=2) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.97131;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:888000;}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:1779277369.972482;i:4;a:0:{}i:5;i:893056;}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:1779277369.972929;i:4;a:0:{}i:5;i:923024;}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:1779277369.972999;i:4;a:0:{}i:5;i:924024;}i:37;a:6:{i:0;s:35:"Route requested: 'appointment/book'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1779277369.973411;i:4;a:0:{}i:5;i:945376;}i:38;a:6:{i:0;s:30:"Route to run: appointment/book";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1779277369.973585;i:4;a:0:{}i:5;i:947920;}i:39;a:6:{i:0;s:72:"Running action: frontend\controllers\AppointmentController::actionBook()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1779277369.97403;i:4;a:0:{}i:5;i:958192;}i:40;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:1779277369.974195;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:967872;}i:43;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:1779277369.97621;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:983648;}i:46;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:1779277369.976624;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:982904;}i:49;a:6:{i:0;s:55:"SELECT * FROM `doctors` WHERE (`id`=1) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.977448;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:987528;}i:52;a:6:{i:0;s:121:"SELECT * FROM `doctor_availability` WHERE (`doctor_id`=1) AND (`day_of_week`=4) AND (`is_active`=1) ORDER BY `start_time`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.97816;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:998472;}i:55;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:1779277369.978697;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1008688;}i:58;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:1779277369.980445;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1022520;}i:61;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:1779277369.980912;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1022992;}i:64;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.981884;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1030928;}i:67;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `locations`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.982241;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1042064;}i:70;a:6:{i:0;s:29:"SHOW CREATE TABLE `locations`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.983681;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1054056;}i:73;a:6:{i:0;s:774:"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` = 'locations' AND `kcu`.`TABLE_NAME` = 'locations'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984063;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1055136;}i:76;a:6:{i:0;s:135:"SELECT EXISTS(SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21') AND (`is_full_day`=TRUE)) AS `result`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984893;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:135;s:8:"function";s:6:"exists";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:41;s:8:"function";s:14:"isFullDayLeave";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1054232;}i:79;a:6:{i:0;s:83:"SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985391;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:125;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:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:52;s:8:"function";s:15:"forDoctorOnDate";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1059120;}i:82;a:6:{i:0;s:152:"SELECT `appointment_time` FROM `appointments` WHERE ((`doctor_id`=1) AND (`appointment_date`='2026-05-21')) AND (`status` IN ('confirmed', 'completed'))";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985962;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/Appointment.php";s:4:"line";i:190;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:58;s:8:"function";s:14:"bookedTimesFor";s:5:"class";s:25:"common\models\Appointment";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1065360;}i:85;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `appointments`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.986465;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1091416;}i:88;a:6:{i:0;s:32:"SHOW CREATE TABLE `appointments`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988071;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1112056;}i:91;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` = 'appointments' AND `kcu`.`TABLE_NAME` = 'appointments'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988569;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1107496;}i:94;a:6:{i:0;s:138:"Rendering view file: /home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/appointment/book.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1779277369.989451;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1113296;}i:95;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.989878;i:4;a:2:{i:0;a:5:{s:4:"file";s:117:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/appointment/book.php";s:4:"line";i:49;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1143056;}i:98;a:6:{i:0;s:134:"Rendering view file: /home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1779277369.996447;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1170664;}i:99;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 223.188.69.27";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1779277369.996727;i:4;a:2:{i:0;a:5:{s:4:"file";s:113:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/layouts/main.php";s:4:"line";i:397;s:8:"function";s:7:"endBody";s:5:"class";s:12:"yii\web\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1211504;}i:100;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 223.188.69.27";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1779277369.997073;i:4;a:0:{}i:5;i:1231424;}}}";s:9:"profiling";s:38413:"a:3:{s:6:"memory";i:1246488;s:4:"time";d:0.03504180908203125;s:8:"messages";a:48:{i:7;a:6:{i:0;s:73:"Opening DB connection: mysql:host=127.0.0.1;dbname=u618794172_appointment";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1779277369.967338;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:823944;}i:8;a:6:{i:0;s:73:"Opening DB connection: mysql:host=127.0.0.1;dbname=u618794172_appointment";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1779277369.968148;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:867504;}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:1779277369.968208;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:867448;}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:1779277369.969399;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:878312;}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:1779277369.969511;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:880512;}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:1779277369.969671;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:882672;}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:1779277369.969995;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:881000;}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:1779277369.970554;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:882856;}i:18;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=2) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.971357;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:888384;}i:19;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=2) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.971746;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:890480;}i:41;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:1779277369.97423;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:969160;}i:42;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:1779277369.976133;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:981984;}i:44;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:1779277369.976229;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:984936;}i:45;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:1779277369.976485;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:987856;}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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.976637;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:984320;}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:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.977264;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:987776;}i:50;a:6:{i:0;s:55:"SELECT * FROM `doctors` WHERE (`id`=1) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.977465;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:988928;}i:51;a:6:{i:0;s:55:"SELECT * FROM `doctors` WHERE (`id`=1) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.977731;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:991984;}i:53;a:6:{i:0;s:121:"SELECT * FROM `doctor_availability` WHERE (`doctor_id`=1) AND (`day_of_week`=4) AND (`is_active`=1) ORDER BY `start_time`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.978184;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:999768;}i:54;a:6:{i:0;s:121:"SELECT * FROM `doctor_availability` WHERE (`doctor_id`=1) AND (`day_of_week`=4) AND (`is_active`=1) ORDER BY `start_time`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.978603;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1002360;}i:56;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:1779277369.978715;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1009976;}i:57;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:1779277369.980383;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1020848;}i:59;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:1779277369.980466;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1023808;}i:60;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:1779277369.980699;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1026744;}i:62;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:1779277369.980933;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1024408;}i:63;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:1779277369.981434;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1027856;}i:65;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.981912;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1033712;}i:66;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.982141;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1035728;}i:68;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `locations`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.982261;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1043352;}i:69;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `locations`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.983607;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1052392;}i:71;a:6:{i:0;s:29:"SHOW CREATE TABLE `locations`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.983705;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1055344;}i:72;a:6:{i:0;s:29:"SHOW CREATE TABLE `locations`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.98388;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1057632;}i:74;a:6:{i:0;s:774:"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` = 'locations' AND `kcu`.`TABLE_NAME` = 'locations'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984084;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1056552;}i:75;a:6:{i:0;s:774:"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` = 'locations' AND `kcu`.`TABLE_NAME` = 'locations'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984567;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1058784;}i:77;a:6:{i:0;s:135:"SELECT EXISTS(SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21') AND (`is_full_day`=TRUE)) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984913;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:135;s:8:"function";s:6:"exists";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:41;s:8:"function";s:14:"isFullDayLeave";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1055904;}i:78;a:6:{i:0;s:135:"SELECT EXISTS(SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21') AND (`is_full_day`=TRUE)) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985282;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:135;s:8:"function";s:6:"exists";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:41;s:8:"function";s:14:"isFullDayLeave";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1057680;}i:80;a:6:{i:0;s:83:"SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985403;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:125;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:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:52;s:8:"function";s:15:"forDoctorOnDate";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1060896;}i:81;a:6:{i:0;s:83:"SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985617;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:125;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:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:52;s:8:"function";s:15:"forDoctorOnDate";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1062896;}i:83;a:6:{i:0;s:152:"SELECT `appointment_time` FROM `appointments` WHERE ((`doctor_id`=1) AND (`appointment_date`='2026-05-21')) AND (`status` IN ('confirmed', 'completed'))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985977;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/Appointment.php";s:4:"line";i:190;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:58;s:8:"function";s:14:"bookedTimesFor";s:5:"class";s:25:"common\models\Appointment";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1066928;}i:84;a:6:{i:0;s:152:"SELECT `appointment_time` FROM `appointments` WHERE ((`doctor_id`=1) AND (`appointment_date`='2026-05-21')) AND (`status` IN ('confirmed', 'completed'))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.986235;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/Appointment.php";s:4:"line";i:190;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:58;s:8:"function";s:14:"bookedTimesFor";s:5:"class";s:25:"common\models\Appointment";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1068992;}i:86;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `appointments`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.986486;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1092328;}i:87;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `appointments`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988014;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1110760;}i:89;a:6:{i:0;s:32:"SHOW CREATE TABLE `appointments`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988087;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1112968;}i:90;a:6:{i:0;s:32:"SHOW CREATE TABLE `appointments`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988326;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1116288;}i:92;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` = 'appointments' AND `kcu`.`TABLE_NAME` = 'appointments'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.98859;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1108536;}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` = 'appointments' AND `kcu`.`TABLE_NAME` = 'appointments'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.989132;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1112136;}i:96;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.989908;i:4;a:2:{i:0;a:5:{s:4:"file";s:117:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/appointment/book.php";s:4:"line";i:49;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1144560;}i:97;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.990128;i:4;a:2:{i:0;a:5:{s:4:"file";s:117:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/appointment/book.php";s:4:"line";i:49;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1146576;}}}";s:2:"db";s:37501:"a:1:{s:8:"messages";a:46:{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:1779277369.968208;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:867448;}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:1779277369.969399;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:878312;}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:1779277369.969511;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:880512;}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:1779277369.969671;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:882672;}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:1779277369.969995;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:881000;}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:1779277369.970554;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:882856;}i:18;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=2) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.971357;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:888384;}i:19;a:6:{i:0;s:53:"SELECT * FROM `users` WHERE (`id`=2) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.971746;i:4;a:1:{i:0;a:5:{s:4:"file";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/User.php";s:4:"line";i:73;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:890480;}i:41;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:1779277369.97423;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:969160;}i:42;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:1779277369.976133;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:981984;}i:44;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:1779277369.976229;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:984936;}i:45;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:1779277369.976485;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:987856;}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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.976637;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:984320;}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:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.977264;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:987776;}i:50;a:6:{i:0;s:55:"SELECT * FROM `doctors` WHERE (`id`=1) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.977465;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:988928;}i:51;a:6:{i:0;s:55:"SELECT * FROM `doctors` WHERE (`id`=1) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.977731;i:4;a:2:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:259;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:135;s:8:"function";s:10:"findDoctor";s:5:"class";s:42:"frontend\controllers\AppointmentController";s:4:"type";s:2:"->";}}i:5;i:991984;}i:53;a:6:{i:0;s:121:"SELECT * FROM `doctor_availability` WHERE (`doctor_id`=1) AND (`day_of_week`=4) AND (`is_active`=1) ORDER BY `start_time`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.978184;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:999768;}i:54;a:6:{i:0;s:121:"SELECT * FROM `doctor_availability` WHERE (`doctor_id`=1) AND (`day_of_week`=4) AND (`is_active`=1) ORDER BY `start_time`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.978603;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1002360;}i:56;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:1779277369.978715;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1009976;}i:57;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:1779277369.980383;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1020848;}i:59;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:1779277369.980466;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1023808;}i:60;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:1779277369.980699;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1026744;}i:62;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:1779277369.980933;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1024408;}i:63;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:1779277369.981434;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1027856;}i:65;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.981912;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1033712;}i:66;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.982141;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1035728;}i:68;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `locations`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.982261;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1043352;}i:69;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `locations`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.983607;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1052392;}i:71;a:6:{i:0;s:29:"SHOW CREATE TABLE `locations`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.983705;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1055344;}i:72;a:6:{i:0;s:29:"SHOW CREATE TABLE `locations`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.98388;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1057632;}i:74;a:6:{i:0;s:774:"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` = 'locations' AND `kcu`.`TABLE_NAME` = 'locations'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984084;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1056552;}i:75;a:6:{i:0;s:774:"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` = 'locations' AND `kcu`.`TABLE_NAME` = 'locations'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984567;i:4;a:2:{i:0;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:34;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:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1058784;}i:77;a:6:{i:0;s:135:"SELECT EXISTS(SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21') AND (`is_full_day`=TRUE)) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.984913;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:135;s:8:"function";s:6:"exists";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:41;s:8:"function";s:14:"isFullDayLeave";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1055904;}i:78;a:6:{i:0;s:135:"SELECT EXISTS(SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21') AND (`is_full_day`=TRUE)) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985282;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:135;s:8:"function";s:6:"exists";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:41;s:8:"function";s:14:"isFullDayLeave";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1057680;}i:80;a:6:{i:0;s:83:"SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985403;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:125;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:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:52;s:8:"function";s:15:"forDoctorOnDate";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1060896;}i:81;a:6:{i:0;s:83:"SELECT * FROM `doctor_leaves` WHERE (`doctor_id`=1) AND (`leave_date`='2026-05-21')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985617;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/DoctorLeave.php";s:4:"line";i:125;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:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:52;s:8:"function";s:15:"forDoctorOnDate";s:5:"class";s:25:"common\models\DoctorLeave";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1062896;}i:83;a:6:{i:0;s:152:"SELECT `appointment_time` FROM `appointments` WHERE ((`doctor_id`=1) AND (`appointment_date`='2026-05-21')) AND (`status` IN ('confirmed', 'completed'))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.985977;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/Appointment.php";s:4:"line";i:190;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:58;s:8:"function";s:14:"bookedTimesFor";s:5:"class";s:25:"common\models\Appointment";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1066928;}i:84;a:6:{i:0;s:152:"SELECT `appointment_time` FROM `appointments` WHERE ((`doctor_id`=1) AND (`appointment_date`='2026-05-21')) AND (`status` IN ('confirmed', 'completed'))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.986235;i:4;a:3:{i:0;a:5:{s:4:"file";s:111:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/models/Appointment.php";s:4:"line";i:190;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:123:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/common/components/AvailabilityService.php";s:4:"line";i:58;s:8:"function";s:14:"bookedTimesFor";s:5:"class";s:25:"common\models\Appointment";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:140;s:8:"function";s:15:"getSlotsForDate";s:5:"class";s:37:"common\components\AvailabilityService";s:4:"type";s:2:"->";}}i:5;i:1068992;}i:86;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `appointments`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.986486;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1092328;}i:87;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `appointments`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988014;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1110760;}i:89;a:6:{i:0;s:32:"SHOW CREATE TABLE `appointments`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988087;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1112968;}i:90;a:6:{i:0;s:32:"SHOW CREATE TABLE `appointments`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.988326;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1116288;}i:92;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` = 'appointments' AND `kcu`.`TABLE_NAME` = 'appointments'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.98859;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1108536;}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` = 'appointments' AND `kcu`.`TABLE_NAME` = 'appointments'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.989132;i:4;a:1:{i:0;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:149;s:8:"function";s:11:"__construct";s:5:"class";s:19:"yii\base\BaseObject";s:4:"type";s:2:"->";}}i:5;i:1112136;}i:96;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.989908;i:4;a:2:{i:0;a:5:{s:4:"file";s:117:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/appointment/book.php";s:4:"line";i:49;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1144560;}i:97;a:6:{i:0;s:38:"SELECT * FROM `locations` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779277369.990128;i:4;a:2:{i:0;a:5:{s:4:"file";s:117:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/views/appointment/book.php";s:4:"line";i:49;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:128:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/controllers/AppointmentController.php";s:4:"line";i:163;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1146576;}}}";s:5:"event";s:6751:"a:39:{i:0;a:5:{s:4:"time";d:1779277369.967002;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:1779277369.968133;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:1779277369.971934;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:1779277369.971997;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:1779277369.972307;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:1779277369.973178;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:1779277369.973639;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:1779277369.973975;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"frontend\controllers\AppointmentController";}i:8;a:5:{s:4:"time";d:1779277369.974103;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:1779277369.977819;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:1779277369.977875;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:1779277369.978039;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:1779277369.978653;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:13;a:5:{s:4:"time";d:1779277369.981629;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:1779277369.982198;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\Location";}i:15;a:5:{s:4:"time";d:1779277369.984639;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\Location";}i:16;a:5:{s:4:"time";d:1779277369.984658;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"common\models\DoctorAvailability";}i:17;a:5:{s:4:"time";d:1779277369.984737;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:1779277369.985322;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:1779277369.985714;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:1779277369.989245;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"common\models\Appointment";}i:21;a:5:{s:4:"time";d:1779277369.989444;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:22;a:5:{s:4:"time";d:1779277369.989749;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:23;a:5:{s:4:"time";d:1779277369.990185;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\Location";}i:24;a:5:{s:4:"time";d:1779277369.990224;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\Location";}i:25;a:5:{s:4:"time";d:1779277369.990398;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:26;a:5:{s:4:"time";d:1779277369.995893;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:27;a:5:{s:4:"time";d:1779277369.996345;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:28;a:5:{s:4:"time";d:1779277369.996386;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:29;a:5:{s:4:"time";d:1779277369.996442;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:30;a:5:{s:4:"time";d:1779277369.996528;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:31;a:5:{s:4:"time";d:1779277369.996751;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:32;a:5:{s:4:"time";d:1779277369.996886;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:33;a:5:{s:4:"time";d:1779277369.996926;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"frontend\controllers\AppointmentController";}i:34;a:5:{s:4:"time";d:1779277369.996938;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:35;a:5:{s:4:"time";d:1779277369.99695;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:36;a:5:{s:4:"time";d:1779277369.99696;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:37;a:5:{s:4:"time";d:1779277369.997085;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:38;a:5:{s:4:"time";d:1779277369.99715;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:1779277369.963303;s:3:"end";d:1779277369.998647;s:6:"memory";i:1246488;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:2703:"a:3:{s:8:"messages";a:14:{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:1779277369.973311;i:4;a:0:{}i:5;i:937112;}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:1779277369.973322;i:4;a:0:{}i:5;i:937760;}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:1779277369.973328;i:4;a:0:{}i:5;i:938456;}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:1779277369.973333;i:4;a:0:{}i:5;i:939048;}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:1779277369.973338;i:4;a:0:{}i:5;i:939744;}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:1779277369.973343;i:4;a:0:{}i:5;i:940336;}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:1779277369.973348;i:4;a:0:{}i:5;i:940928;}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:1779277369.973352;i:4;a:0:{}i:5;i:941520;}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:1779277369.973357;i:4;a:0:{}i:5;i:942112;}i:32;a:6:{i:0;a:3:{s:4:"rule";s:11:"appointment";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779277369.973362;i:4;a:0:{}i:5;i:942704;}i:33;a:6:{i:0;a:3:{s:4:"rule";s:27:"appointment/doctor/<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:1779277369.973366;i:4;a:0:{}i:5;i:943992;}i:34;a:6:{i:0;a:3:{s:4:"rule";s:17:"appointment/slots";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779277369.973371;i:4;a:0:{}i:5;i:944584;}i:35;a:6:{i:0;s:46:"Request parsed with URL rule: appointment/book";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1779277369.973394;i:4;a:0:{}i:5;i:945552;}i:36;a:6:{i:0;a:3:{s:4:"rule";s:16:"appointment/book";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779277369.973398;i:4;a:0:{}i:5;i:945688;}}s:5:"route";s:16:"appointment/book";s:6:"action";s:56:"frontend\controllers\AppointmentController::actionBook()";}";s:7:"request";s:5069:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:11:{s:4:"host";s:16:"theconnecthub.in";s:14:"sec-fetch-dest";s:8:"document";s:10:"user-agent";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.1 Safari/605.1.15";s:6:"accept";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:7:"referer";s:86:"https://theconnecthub.in/forbaxy-appointment-booking/frontend/web/appointment/doctor/1";s:14:"sec-fetch-site";s:11:"same-origin";s:14:"sec-fetch-mode";s:8:"navigate";s:15:"accept-language";s:26:"en-IN,en-GB;q=0.9,en;q=0.8";s:8:"priority";s:6:"u=0, i";s:15:"accept-encoding";s:17:"gzip, deflate, br";s:6:"cookie";s:223:"_csrf=d494469996b2bfb6c5adb76012c2841b56888519ff794a439f343913132181d8a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22FlVHNVRFabUy-IYzU19ryIcVYmMwqYRt%22%3B%7D; frontend_session=b701ab27f7daabb9afce868576965391";}s:15:"responseHeaders";a:5:{s:12:"X-Powered-By";s:10:"PHP/8.4.19";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:5:"route";s:16:"appointment/book";s:6:"action";s:56:"frontend\controllers\AppointmentController::actionBook()";s:12:"actionParams";a:4:{s:9:"doctor_id";i:1;s:4:"date";s:10:"2026-05-21";s:4:"time";s:5:"10:30";s:11:"location_id";i:1;}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:51:{s:18:"LSPHP_ProcessGroup";s:2:"on";s:4:"PATH";s:28:"/usr/local/bin:/bin:/usr/bin";s:11:"HTTP_ACCEPT";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:20:"HTTP_ACCEPT_ENCODING";s:17:"gzip, deflate, br";s:20:"HTTP_ACCEPT_LANGUAGE";s:26:"en-IN,en-GB;q=0.9,en;q=0.8";s:11:"HTTP_COOKIE";s:223:"_csrf=d494469996b2bfb6c5adb76012c2841b56888519ff794a439f343913132181d8a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22FlVHNVRFabUy-IYzU19ryIcVYmMwqYRt%22%3B%7D; frontend_session=b701ab27f7daabb9afce868576965391";s:9:"HTTP_HOST";s:16:"theconnecthub.in";s:12:"HTTP_REFERER";s:86:"https://theconnecthub.in/forbaxy-appointment-booking/frontend/web/appointment/doctor/1";s:15:"HTTP_USER_AGENT";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.1 Safari/605.1.15";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:13:"HTTP_PRIORITY";s:6:"u=0, i";s:13:"DOCUMENT_ROOT";s:53:"/home/u618794172/domains/theconnecthub.in/public_html";s:11:"REMOTE_ADDR";s:13:"223.188.69.27";s:11:"REMOTE_PORT";s:5:"25804";s:11:"SERVER_ADDR";s:14:"194.163.35.238";s:11:"SERVER_NAME";s:16:"theconnecthub.in";s:12:"SERVER_ADMIN";s:0:"";s:11:"SERVER_PORT";s:3:"443";s:14:"REQUEST_SCHEME";s:5:"https";s:11:"REQUEST_URI";s:113:"/forbaxy-appointment-booking/frontend/web/appointment/book?doctor_id=1&date=2026-05-21&time=10%3A30&location_id=1";s:12:"REDIRECT_URL";s:58:"/forbaxy-appointment-booking/frontend/web/appointment/book";s:21:"REDIRECT_QUERY_STRING";s:54:"doctor_id=1&date=2026-05-21&time=10%3A30&location_id=1";s:23:"REDIRECT_REQUEST_METHOD";s:3:"GET";s:5:"HTTPS";s:2:"on";s:14:"CRAWLER_USLEEP";s:4:"1000";s:26:"CRAWLER_LOAD_LIMIT_ENFORCE";s:2:"25";s:10:"H_PLATFORM";s:9:"Hostinger";s:6:"H_TYPE";s:6:"shared";s:8:"H_CANARY";s:5:"false";s:9:"H_STAGING";s:5:"false";s:15:"REDIRECT_STATUS";s:3:"200";s:30:"ratelimited_meta_externalagent";s:1:"1";s:6:"X_SPDY";s:5:"HTTP3";s:12:"SSL_PROTOCOL";s:4:"QUIC";s:10:"SSL_CIPHER";s:22:"TLS_AES_256_GCM_SHA384";s:21:"SSL_CIPHER_USEKEYSIZE";s:3:"256";s:21:"SSL_CIPHER_ALGKEYSIZE";s:3:"256";s:15:"SCRIPT_FILENAME";s:104:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/web/index.php";s:12:"QUERY_STRING";s:54:"doctor_id=1&date=2026-05-21&time=10%3A30&location_id=1";s:10:"SCRIPT_URI";s:82:"https://theconnecthub.in/forbaxy-appointment-booking/frontend/web/appointment/book";s:10:"SCRIPT_URL";s:58:"/forbaxy-appointment-booking/frontend/web/appointment/book";s:11:"SCRIPT_NAME";s:51:"/forbaxy-appointment-booking/frontend/web/index.php";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:15:"SERVER_SOFTWARE";s:9:"LiteSpeed";s:14:"REQUEST_METHOD";s:3:"GET";s:9:"X-LSCACHE";s:22:"on,crawler,esi,combine";s:8:"PHP_SELF";s:51:"/forbaxy-appointment-booking/frontend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1779277369.962384;s:12:"REQUEST_TIME";i:1779277369;}s:3:"GET";a:4:{s:9:"doctor_id";s:1:"1";s:4:"date";s:10:"2026-05-21";s:4:"time";s:5:"10:30";s:11:"location_id";s:1:"1";}s:4:"POST";a:0:{}s:6:"COOKIE";a:2:{s:5:"_csrf";s:130:"d494469996b2bfb6c5adb76012c2841b56888519ff794a439f343913132181d8a:2:{i:0;s:5:"_csrf";i:1;s:32:"FlVHNVRFabUy-IYzU19ryIcVYmMwqYRt";}";s:16:"frontend_session";s:32:"b701ab27f7daabb9afce868576965391";}s:5:"FILES";a:0:{}s:7:"SESSION";a:3:{s:7:"__flash";a:0:{}s:4:"__id";i:2;s:9:"__authKey";s:32:"hPtxpJerOUBgnKFRQXPnfjeBQQUZVsle";}}";s:4:"user";s:1146:"a:5:{s:2:"id";i:2;s:8:"identity";a:10:{s:2:"id";s:1:"2";s:4:"name";s:15:"'Pulkit Pareek'";s:5:"phone";s:12:"'6367832529'";s:5:"email";s:33:"'pulkit.pareek@theconnecthub.com'";s:4:"role";s:10:"'app_user'";s:6:"status";s:1:"1";s:8:"auth_key";s:34:"'hPtxpJerOUBgnKFRQXPnfjeBQQUZVsle'";s:13:"last_login_at";s:10:"1779108082";s:10:"created_at";s:10:"1778583724";s:10:"updated_at";s:10:"1779108082";}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:2232:"a:4:{s:30:"yii\validators\ValidationAsset";a:9:{s:10:"sourcePath";s:108:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/yiisoft/yii2/assets";s:8:"basePath";s:110:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/web/assets/1702a76f";s:7:"baseUrl";s:57:"/forbaxy-appointment-booking/frontend/web/assets/1702a76f";s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:2:"js";a:1:{i:0;s:17:"yii.validation.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\web\YiiAsset";a:9:{s:10:"sourcePath";s:108:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/yiisoft/yii2/assets";s:8:"basePath";s:110:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/web/assets/1702a76f";s:7:"baseUrl";s:57:"/forbaxy-appointment-booking/frontend/web/assets/1702a76f";s:7:"depends";a:1:{i:0;s:19:"yii\web\JqueryAsset";}s:2:"js";a:1:{i:0;s:6:"yii.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:19:"yii\web\JqueryAsset";a:9:{s:10:"sourcePath";s:112:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/bower-asset/jquery/dist";s:8:"basePath";s:110:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/web/assets/ca2317c6";s:7:"baseUrl";s:57:"/forbaxy-appointment-booking/frontend/web/assets/ca2317c6";s:7:"depends";a:0:{}s:2:"js";a:1:{i:0;s:9:"jquery.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:27:"yii\widgets\ActiveFormAsset";a:9:{s:10:"sourcePath";s:108:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/vendor/yiisoft/yii2/assets";s:8:"basePath";s:110:"/home/u618794172/domains/theconnecthub.in/public_html/forbaxy-appointment-booking/frontend/web/assets/1702a76f";s:7:"baseUrl";s:57:"/forbaxy-appointment-booking/frontend/web/assets/1702a76f";s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:2:"js";a:1:{i:0;s:17:"yii.activeForm.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a0d9e39ed6f7";s:3:"url";s:137:"https://theconnecthub.in/forbaxy-appointment-booking/frontend/web/appointment/book?doctor_id=1&date=2026-05-21&time=10%3A30&location_id=1";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:13:"223.188.69.27";s:4:"time";d:1779277369.962384;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1246488;s:14:"processingTime";d:0.03504180908203125;}s:10:"exceptions";a:0:{}}