a:14:{s:6:"config";s:2883:"a:5:{s:10:"phpVersion";s:6:"8.2.33";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.2.33";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:64:"/home/appselectionsear/public_html/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:69:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}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:62:"/home/appselectionsear/public_html/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:"2.0.4.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:72:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-symfonymailer/src";}}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:64:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-debug/src";}}s:18:"yiisoft/yii2-queue";a:3:{s:4:"name";s:18:"yiisoft/yii2-queue";s:7:"version";s:7:"2.3.8.0";s:5:"alias";a:11:{s:10:"@yii/queue";s:64:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src";s:13:"@yii/queue/db";s:75:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/db";s:14:"@yii/queue/sqs";s:76:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/sqs";s:15:"@yii/queue/amqp";s:77:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/amqp";s:15:"@yii/queue/file";s:77:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/file";s:15:"@yii/queue/sync";s:77:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/sync";s:16:"@yii/queue/redis";s:78:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/redis";s:16:"@yii/queue/stomp";s:78:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/stomp";s:18:"@yii/queue/gearman";s:80:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/gearman";s:20:"@yii/queue/beanstalk";s:82:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/beanstalk";s:23:"@yii/queue/amqp_interop";s:85:"/home/appselectionsear/public_html/vendor/yiisoft/yii2-queue/src/drivers/amqp_interop";}}}}";s:3:"log";s:39347:"a:1:{s:8:"messages";a:59:{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:1788871367.7737929821014404296875;i:4;a:0:{}i:5;i:3292136;}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:1788871367.7739880084991455078125;i:4;a:0:{}i:5;i:3317000;}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:1788871367.7759640216827392578125;i:4;a:0:{}i:5;i:3947560;}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:1788871367.7759830951690673828125;i:4;a:0:{}i:5;i:3948200;}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:1788871367.77878093719482421875;i:4;a:0:{}i:5;i:4741960;}i:5;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.782866954803466796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6077448;}i:6;a:6:{i:0;s:71:"Opening DB connection: mysql:host=localhost;dbname=appselectionsear_app";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1788871367.7828910350799560546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6079568;}i:11;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.784039974212646484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6139352;}i:14;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7844750881195068359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6159144;}i:17;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=3) AND (`status`=10)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78629207611083984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6603272;}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:1788871367.7892820835113525390625;i:4;a:0:{}i:5;i:7305464;}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:1788871367.7897551059722900390625;i:4;a:0:{}i:5;i:7420992;}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:1788871367.78987407684326171875;i:4;a:0:{}i:5;i:7510960;}i:24;a:6:{i:0;s:59:"Route requested: 'shortlisting/default/submit-for-approval'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1788871367.7899000644683837890625;i:4;a:0:{}i:5;i:7510536;}i:25;a:6:{i:0;s:28:"Loading module: shortlisting";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1788871367.789904117584228515625;i:4;a:0:{}i:5;i:7512032;}i:26;a:6:{i:0;s:54:"Route to run: shortlisting/default/submit-for-approval";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1788871367.7918910980224609375;i:4;a:0:{}i:5;i:8009208;}i:27;a:6:{i:0;s:101:"Running action: backend\modules\shortlisting\controllers\DefaultController::actionSubmitForApproval()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1788871367.7927749156951904296875;i:4;a:0:{}i:5;i:8231184;}i:28;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `positions`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7929210662841796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8280712;}i:31;a:6:{i:0;s:29:"SHOW CREATE TABLE `positions`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7934639453887939453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8306592;}i:34;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` = 'positions' AND `kcu`.`TABLE_NAME` = 'positions'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.793675899505615234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8301952;}i:37;a:6:{i:0;s:40:"SELECT * FROM `positions` WHERE `id`='7'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79401493072509765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8304288;}i:40;a:6:{i:0;s:91:"SELECT * FROM `candidate_position_scores` WHERE (`position_id`='7') AND (`status`='scored')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7945148944854736328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8359600;}i:43;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `candidate_position_scores`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.794827938079833984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8384440;}i:46;a:6:{i:0;s:45:"SHOW CREATE TABLE `candidate_position_scores`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.795486927032470703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8400744;}i:49;a:6:{i:0;s:806:"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` = 'candidate_position_scores' AND `kcu`.`TABLE_NAME` = 'candidate_position_scores'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.795650005340576171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8399152;}i:52;a:6:{i:0;s:83:"SELECT * FROM `candidates` WHERE `id` IN (25369, 25370, 25371, 25372, 25559, 26035)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7964398860931396484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8576040;}i:55;a:6:{i:0;s:35:"SHOW FULL COLUMNS FROM `candidates`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7966969013214111328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8629056;}i:58;a:6:{i:0;s:30:"SHOW CREATE TABLE `candidates`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7970979213714599609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8651120;}i:61;a:6:{i:0;s:776:"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` = 'candidates' AND `kcu`.`TABLE_NAME` = 'candidates'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.797267913818359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8646440;}i:64;a:6:{i:0;s:80:"SELECT * FROM `shortlist_submissions` WHERE `position_id`='7' ORDER BY `id` DESC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79796695709228515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:591;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8689552;}i:67;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlist_submissions`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.798583984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8694032;}i:70;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlist_submissions`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7989909648895263671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8703760;}i:73;a:6:{i:0;s:798:"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` = 'shortlist_submissions' AND `kcu`.`TABLE_NAME` = 'shortlist_submissions'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7991259098052978515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8704424;}i:76;a:6:{i:0;s:215:"INSERT INTO `shortlist_submissions` (`position_id`, `submitted_by`, `submitted_at`, `status`, `created_at`, `updated_at`) VALUES (7, 3, '2026-09-08 18:12:47', 'pending', '2026-09-08 18:12:47', '2026-09-08 18:12:47')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.79979705810546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:607;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8777392;}i:79;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25369)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.801681041717529296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8805992;}i:82;a:6:{i:0;s:56:"SHOW FULL COLUMNS FROM `shortlist_submission_candidates`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.802134990692138671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8809328;}i:85;a:6:{i:0;s:51:"SHOW CREATE TABLE `shortlist_submission_candidates`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.802548885345458984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8821928;}i:88;a:6:{i:0;s:818:"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` = 'shortlist_submission_candidates' AND `kcu`.`TABLE_NAME` = 'shortlist_submission_candidates'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8030369281768798828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8821216;}i:91;a:6:{i:0;s:1861:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25369, 'pending', '2026-09-08 18:12:47', 'maybe', '52.20', 'The candidate meets the education hard filter through a B.Sc. in Mathematics and Education and a Bachelor of Education from recognised institutions. He also has relevant Mathematics and Physics teaching experience and academic coordination exposure. However, the location criterion is a hard filter requiring Dwarka, New Delhi, while the candidate is located in Jhansi, Uttar Pradesh. Although the job description permits relocation, the candidate profile does not explicitly confirm willingness to relocate. Therefore, the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in Mathematics and Education, a Bachelor of Education, and postgraduate qualifications in Mathematics and Business Administration. This satisfies the required bachelor\'s degree in Education, Mathematics, or a related field.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Jhansi, Uttar Pradesh, whereas the hard-filter location requirement is Dwarka, New Delhi. The profile does not explicitly state willingness to relocate.\"},\"Experience\":{\"score\":8,\"comment\":\"The candidate has eight years of documented teaching experience in Mathematics and Physics, including roles at St. Stephen\\u2019s Global School, M.P.S. Group, and Little Flower International School. This is relevant to STEM teaching, although it exceeds the preferred 2-to-5-year range and does not demonstrate specific interdisciplinary STEM, Atal Innovation Mission, project-based, or inquiry-based programme experience.\"}}', '2026-09-08 18:12:47')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8035209178924560546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8831856;}i:94;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25370)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8066051006317138671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8833448;}i:97;a:6:{i:0;s:1769:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25370, 'pending', '2026-09-08 18:12:47', 'maybe', '49.60', 'Deepak meets the educational hard filter through a B.Ed. and science qualifications including an M.Sc. and B.Sc. in Chemistry. His current PGT Chemistry role and school internship provide relevant subject-teaching exposure, although the profile does not clearly demonstrate interdisciplinary STEM curriculum design, Atal Innovation Mission alignment, project-based learning, or hands-on innovation programme leadership. The location hard filter is not fully verifiable: the profile states Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate. Recruiter verification is required before proceeding.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a Bachelor of Education from Gurugram University, an M.Sc. in Chemistry, and a B.Sc. in Chemistry from listed institutions, which satisfies the requirement for a recognised education or science-related bachelor\'s degree.\"},\"Location\":{\"score\":0,\"comment\":\"The profile lists the candidate\'s city as Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate there. The hard-filter location requirement therefore remains unverified.\"},\"Experience\":{\"score\":7,\"comment\":\"The candidate reports 4 years of total experience and currently works as a PGT Chemistry Teacher. Chemistry is a relevant science\\/STEM subject, but the profile does not clearly establish 2 to 5 years of dedicated STEM teaching or experience with interdisciplinary STEM programmes.\"}}', '2026-09-08 18:12:47')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8069489002227783203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8841136;}i:100;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25371)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.809864044189453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8842728;}i:103;a:6:{i:0;s:1440:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25371, 'pending', '2026-09-08 18:12:47', 'maybe', '47.00', 'The candidate meets the education hard filter through a Bachelor of Technology in Electronics and Communication and has relevant STEM mentoring, training, and event leadership experience. However, the candidate is located in Noida, while Dwarka, New Delhi is specified as a hard-filter location requirement. Willingness to relocate is not stated, so the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"Meets the hard-filter requirement with a Bachelor of Technology in Electronics and Communication from the National Institute of Science & Technology, a recognised engineering qualification.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Noida, not Dwarka, New Delhi. The criterion is a hard filter, and willingness to relocate is not explicitly stated.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 2 years of experience as a Sr. Innovation Engineer, including mentoring students and teachers, delivering STEM training, and leading STEM events. However, direct school-based teaching experience and curriculum implementation are not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.810350894927978515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8849904;}i:106;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25372)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8109490871429443359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8851496;}i:109;a:6:{i:0;s:1734:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25372, 'pending', '2026-09-08 18:12:47', 'maybe', '59.60', 'Arzoo Khan meets the education requirement through a B.Ed. from Mahatma Gandhi Kashi Vidyapith and has substantial school administration and academic coordination experience. However, the profile does not demonstrate 2–5 years of relevant STEM teaching experience; the documented subject background is Social Studies/Social Science. The candidate is based in New Delhi, but residence specifically in Dwarka is not confirmed, and willingness to relocate is not stated. The hard location requirement therefore requires verification before shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed. from Mahatma Gandhi Kashi Vidyapith, Varanasi, which is a bachelor\'s degree in Education and aligns with the stated education requirement.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as New Delhi, but the profile does not confirm residence in Dwarka specifically and does not state willingness to relocate. The hard location requirement remains unverified.\"},\"Experience\":{\"score\":2,\"comment\":\"The candidate has 8 years as an Academic Coordinator with responsibilities including academic coordination, faculty supervision, examination coordination, and school operations management. However, the profile does not demonstrate relevant STEM teaching experience; subjects listed are Social Studies and Social Science, and the total experience also exceeds the preferred 2\\u20135 year range.\"}}', '2026-09-08 18:12:47')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8112409114837646484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8860208;}i:112;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25559)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8121941089630126953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8861800;}i:115;a:6:{i:0;s:1946:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25559, 'pending', '2026-09-08 18:12:47', 'maybe', '66.50', 'The candidate meets the hard education filter through a B.Sc. in PCM and a B.Ed. from listed institutions. She has approximately two years of documented PGT Chemistry experience, along with broader Science and teaching experience, which is relevant to a STEM role. However, her profile does not demonstrate direct experience designing interdisciplinary STEM programmes, Atal Innovation Mission alignment, project-based or inquiry-based learning, emerging technologies, or STEM-specific innovation projects. Her location is listed as Banda/Sagar, Madhya Pradesh, and willingness to relocate to Dwarka, New Delhi is not stated; recruiter confirmation is required.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in PCM and a B.Ed. in All Subjects, satisfying the stated bachelor\'s degree requirement in Science and Education. The institutions are listed in the profile, although formal recognition is not independently verified.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s listed locations are Banda and Sagar, Madhya Pradesh, not Dwarka, New Delhi. The job permits relocation, but the profile does not state willingness to relocate, so recruiter confirmation is required.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 10 years of total teaching experience and documented PGT Chemistry experience from 01\\/11\\/2023 to 27\\/03\\/2024 and 27\\/06\\/2024 to 10\\/02\\/2026, broadly aligning with the preferred 2 to 5 years of relevant subject experience. However, direct STEM teaching, interdisciplinary programme development, project-based learning, and Atal Innovation Mission experience are not demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8125400543212890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8869488;}i:118;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=26035)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.813107013702392578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8871080;}i:121;a:6:{i:0;s:2002:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 26035, 'pending', '2026-09-08 18:12:47', 'maybe', '72.60', 'Gourav satisfies the hard education requirement with a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions. He has approximately three years of relevant STEM exposure, including Science teaching for Classes IX-XII, science communication, STEM workshops, robotics and programming activities, curriculum support, and science-fair organization. Direct school teaching experience is documented from July 2023 to December 2024, while the current Science Communicator role adds relevant practical STEM experience. Current residence is listed as Delhi, but relocation willingness to Dwarka is not stated and should be confirmed. Based on the weighted score and the non-mandatory nature of the location and experience preferences, he is suitable for shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions, satisfying the hard-filter requirement for a recognised degree in Education or Science-related fields.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as Delhi, but residence specifically in Dwarka is not demonstrated. Willingness to relocate to Dwarka, New Delhi is also not stated, so recruiter confirmation is required.\"},\"Experience\":{\"score\":7,\"comment\":\"The profile states approximately three years of total experience and documents Science teaching for Classes IX-XII from July 2023 to December 2024, followed by Science Communicator work from January 2025. STEM workshops, robotics and programming, curriculum support, teacher training, and science-fair organization strengthen relevance, although two full years of direct school teaching is not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8134059906005859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8878768;}i:124;a:6:{i:0;s:94:"Rendering view file: /home/appselectionsear/public_html/common/mail/shortlistApproval-html.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1788871367.81602191925048828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:706;s:8:"function";s:7:"compose";s:5:"class";s:19:"yii\mail\BaseMailer";s:4:"type";s:2:"->";}}i:5;i:9259896;}i:125;a:6:{i:0;s:84:"Rendering view file: /home/appselectionsear/public_html/common/mail/layouts/html.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1788871367.817368984222412109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:706;s:8:"function";s:7:"compose";s:5:"class";s:19:"yii\mail\BaseMailer";s:4:"type";s:2:"->";}}i:5;i:9601880;}i:126;a:6:{i:0;s:94:"Rendering view file: /home/appselectionsear/public_html/common/mail/shortlistApproval-text.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1788871367.81750392913818359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:706;s:8:"function";s:7:"compose";s:5:"class";s:19:"yii\mail\BaseMailer";s:4:"type";s:2:"->";}}i:5;i:9605280;}i:127;a:6:{i:0;s:84:"Rendering view file: /home/appselectionsear/public_html/common/mail/layouts/text.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1788871367.817636013031005859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:706;s:8:"function";s:7:"compose";s:5:"class";s:19:"yii\mail\BaseMailer";s:4:"type";s:2:"->";}}i:5;i:9620704;}i:128;a:6:{i:0;s:80:"Sending email "Shortlist submitted for approval" to "sanskarawasthi03@gmail.com"";i:1;i:4;i:2;s:25:"yii\mail\BaseMailer::send";i:3;d:1788871367.8197081089019775390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:724;s:8:"function";s:4:"send";s:5:"class";s:20:"yii\mail\BaseMessage";s:4:"type";s:2:"->";}}i:5;i:9947456;}i:129;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `audit_log`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9703400135040283203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10206032;}i:132;a:6:{i:0;s:29:"SHOW CREATE TABLE `audit_log`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9712760448455810546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10219048;}i:135;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` = 'audit_log' AND `kcu`.`TABLE_NAME` = 'audit_log'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9715259075164794921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10219880;}i:138;a:6:{i:0;s:229:"INSERT INTO `audit_log` (`user_id`, `action`, `entity_type`, `entity_id`, `old_value`, `new_value`, `ip_address`, `created_at`) VALUES (3, 'shortlisting.submitted_for_approval', 'position', 7, NULL, NULL, '223.181.46.216', NOW())";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871373.9722559452056884765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:51;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10226976;}i:141;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 223.181.46.216";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1788871373.97527599334716796875;i:4;a:0:{}i:5;i:10176680;}}}";s:9:"profiling";s:69513:"a:3:{s:6:"memory";i:10334216;s:4:"time";d:6.20608806610107421875;s:8:"messages";a:82:{i:7;a:6:{i:0;s:71:"Opening DB connection: mysql:host=localhost;dbname=appselectionsear_app";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1788871367.7828960418701171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6080376;}i:8;a:6:{i:0;s:71:"Opening DB connection: mysql:host=localhost;dbname=appselectionsear_app";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1788871367.78335094451904296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6123672;}i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78337192535400390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6123616;}i:10;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78401088714599609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6138064;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78404903411865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6140264;}i:13;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78415203094482421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6142456;}i:15;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.784491062164306640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6160184;}i:16;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7848360538482666015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6162040;}i:18;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=3) AND (`status`=10)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.786303043365478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6603656;}i:19;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=3) AND (`status`=10)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7865569591522216796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6606224;}i:29;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `positions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7929298877716064453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8282000;}i:30;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `positions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7934329509735107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8304928;}i:32;a:6:{i:0;s:29:"SHOW CREATE TABLE `positions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7934710979461669921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8307880;}i:33;a:6:{i:0;s:29:"SHOW CREATE TABLE `positions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7935578823089599609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8311704;}i:35;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` = 'positions' AND `kcu`.`TABLE_NAME` = 'positions'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79368495941162109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8303368;}i:36;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` = 'positions' AND `kcu`.`TABLE_NAME` = 'positions'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7939510345458984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305600;}i:38;a:6:{i:0;s:40:"SELECT * FROM `positions` WHERE `id`='7'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.794022083282470703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305792;}i:39;a:6:{i:0;s:40:"SELECT * FROM `positions` WHERE `id`='7'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7941989898681640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8315392;}i:41;a:6:{i:0;s:91:"SELECT * FROM `candidate_position_scores` WHERE (`position_id`='7') AND (`status`='scored')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7945249080657958984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8360624;}i:42;a:6:{i:0;s:91:"SELECT * FROM `candidate_position_scores` WHERE (`position_id`='7') AND (`status`='scored')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.794765949249267578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8378360;}i:44;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `candidate_position_scores`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79483890533447265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8385352;}i:45;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `candidate_position_scores`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.795445919036865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8399432;}i:47;a:6:{i:0;s:45:"SHOW CREATE TABLE `candidate_position_scores`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79549503326416015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8401656;}i:48;a:6:{i:0;s:45:"SHOW CREATE TABLE `candidate_position_scores`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7955799102783203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8404480;}i:50;a:6:{i:0;s:806:"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` = 'candidate_position_scores' AND `kcu`.`TABLE_NAME` = 'candidate_position_scores'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7956559658050537109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8400192;}i:51;a:6:{i:0;s:806:"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` = 'candidate_position_scores' AND `kcu`.`TABLE_NAME` = 'candidate_position_scores'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7958500385284423828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8403272;}i:53;a:6:{i:0;s:83:"SELECT * FROM `candidates` WHERE `id` IN (25369, 25370, 25371, 25372, 25559, 26035)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7964479923248291015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8576648;}i:54;a:6:{i:0;s:83:"SELECT * FROM `candidates` WHERE `id` IN (25369, 25370, 25371, 25372, 25559, 26035)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.796649932861328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8621944;}i:56;a:6:{i:0;s:35:"SHOW FULL COLUMNS FROM `candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7967040538787841796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8629968;}i:57;a:6:{i:0;s:35:"SHOW FULL COLUMNS FROM `candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.797070980072021484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8649832;}i:59;a:6:{i:0;s:30:"SHOW CREATE TABLE `candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7971069812774658203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8652032;}i:60;a:6:{i:0;s:30:"SHOW CREATE TABLE `candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.797194004058837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8654840;}i:62;a:6:{i:0;s:776:"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` = 'candidates' AND `kcu`.`TABLE_NAME` = 'candidates'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.797274112701416015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8647480;}i:63;a:6:{i:0;s:776:"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` = 'candidates' AND `kcu`.`TABLE_NAME` = 'candidates'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7974889278411865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8649336;}i:65;a:6:{i:0;s:80:"SELECT * FROM `shortlist_submissions` WHERE `position_id`='7' ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7980010509490966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:591;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8691960;}i:66;a:6:{i:0;s:80:"SELECT * FROM `shortlist_submissions` WHERE `position_id`='7' ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7985370159149169921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:591;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8693072;}i:68;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlist_submissions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7985908985137939453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8694944;}i:69;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlist_submissions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7989590167999267578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8702448;}i:71;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlist_submissions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7989981174468994140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8704672;}i:72;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlist_submissions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.799067020416259765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8706592;}i:74;a:6:{i:0;s:798:"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` = 'shortlist_submissions' AND `kcu`.`TABLE_NAME` = 'shortlist_submissions'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7991330623626708984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8705464;}i:75;a:6:{i:0;s:798:"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` = 'shortlist_submissions' AND `kcu`.`TABLE_NAME` = 'shortlist_submissions'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7992599010467529296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8707320;}i:77;a:6:{i:0;s:215:"INSERT INTO `shortlist_submissions` (`position_id`, `submitted_by`, `submitted_at`, `status`, `created_at`, `updated_at`) VALUES (7, 3, '2026-09-08 18:12:47', 'pending', '2026-09-08 18:12:47', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.799808025360107421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:607;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8778000;}i:78;a:6:{i:0;s:215:"INSERT INTO `shortlist_submissions` (`position_id`, `submitted_by`, `submitted_at`, `status`, `created_at`, `updated_at`) VALUES (7, 3, '2026-09-08 18:12:47', 'pending', '2026-09-08 18:12:47', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8014709949493408203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:607;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8779136;}i:80;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25369)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.80169010162353515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8807016;}i:81;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25369)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8020908832550048828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8808240;}i:83;a:6:{i:0;s:56:"SHOW FULL COLUMNS FROM `shortlist_submission_candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8021450042724609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8810240;}i:84;a:6:{i:0;s:56:"SHOW FULL COLUMNS FROM `shortlist_submission_candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.802524089813232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8820616;}i:86;a:6:{i:0;s:51:"SHOW CREATE TABLE `shortlist_submission_candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8025600910186767578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8822840;}i:87;a:6:{i:0;s:51:"SHOW CREATE TABLE `shortlist_submission_candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.80292797088623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8825024;}i:89;a:6:{i:0;s:818:"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` = 'shortlist_submission_candidates' AND `kcu`.`TABLE_NAME` = 'shortlist_submission_candidates'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8030469417572021484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8822256;}i:90;a:6:{i:0;s:818:"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` = 'shortlist_submission_candidates' AND `kcu`.`TABLE_NAME` = 'shortlist_submission_candidates'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8032529354095458984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8824112;}i:92;a:6:{i:0;s:1861:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25369, 'pending', '2026-09-08 18:12:47', 'maybe', '52.20', 'The candidate meets the education hard filter through a B.Sc. in Mathematics and Education and a Bachelor of Education from recognised institutions. He also has relevant Mathematics and Physics teaching experience and academic coordination exposure. However, the location criterion is a hard filter requiring Dwarka, New Delhi, while the candidate is located in Jhansi, Uttar Pradesh. Although the job description permits relocation, the candidate profile does not explicitly confirm willingness to relocate. Therefore, the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in Mathematics and Education, a Bachelor of Education, and postgraduate qualifications in Mathematics and Business Administration. This satisfies the required bachelor\'s degree in Education, Mathematics, or a related field.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Jhansi, Uttar Pradesh, whereas the hard-filter location requirement is Dwarka, New Delhi. The profile does not explicitly state willingness to relocate.\"},\"Experience\":{\"score\":8,\"comment\":\"The candidate has eight years of documented teaching experience in Mathematics and Physics, including roles at St. Stephen\\u2019s Global School, M.P.S. Group, and Little Flower International School. This is relevant to STEM teaching, although it exceeds the preferred 2-to-5-year range and does not demonstrate specific interdisciplinary STEM, Atal Innovation Mission, project-based, or inquiry-based programme experience.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8035309314727783203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8831832;}i:93;a:6:{i:0;s:1861:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25369, 'pending', '2026-09-08 18:12:47', 'maybe', '52.20', 'The candidate meets the education hard filter through a B.Sc. in Mathematics and Education and a Bachelor of Education from recognised institutions. He also has relevant Mathematics and Physics teaching experience and academic coordination exposure. However, the location criterion is a hard filter requiring Dwarka, New Delhi, while the candidate is located in Jhansi, Uttar Pradesh. Although the job description permits relocation, the candidate profile does not explicitly confirm willingness to relocate. Therefore, the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in Mathematics and Education, a Bachelor of Education, and postgraduate qualifications in Mathematics and Business Administration. This satisfies the required bachelor\'s degree in Education, Mathematics, or a related field.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Jhansi, Uttar Pradesh, whereas the hard-filter location requirement is Dwarka, New Delhi. The profile does not explicitly state willingness to relocate.\"},\"Experience\":{\"score\":8,\"comment\":\"The candidate has eight years of documented teaching experience in Mathematics and Physics, including roles at St. Stephen\\u2019s Global School, M.P.S. Group, and Little Flower International School. This is relevant to STEM teaching, although it exceeds the preferred 2-to-5-year range and does not demonstrate specific interdisciplinary STEM, Atal Innovation Mission, project-based, or inquiry-based programme experience.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8065168857574462890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8834696;}i:95;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25370)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.80661296844482421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8834472;}i:96;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25370)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.806766986846923828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8835696;}i:98;a:6:{i:0;s:1769:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25370, 'pending', '2026-09-08 18:12:47', 'maybe', '49.60', 'Deepak meets the educational hard filter through a B.Ed. and science qualifications including an M.Sc. and B.Sc. in Chemistry. His current PGT Chemistry role and school internship provide relevant subject-teaching exposure, although the profile does not clearly demonstrate interdisciplinary STEM curriculum design, Atal Innovation Mission alignment, project-based learning, or hands-on innovation programme leadership. The location hard filter is not fully verifiable: the profile states Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate. Recruiter verification is required before proceeding.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a Bachelor of Education from Gurugram University, an M.Sc. in Chemistry, and a B.Sc. in Chemistry from listed institutions, which satisfies the requirement for a recognised education or science-related bachelor\'s degree.\"},\"Location\":{\"score\":0,\"comment\":\"The profile lists the candidate\'s city as Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate there. The hard-filter location requirement therefore remains unverified.\"},\"Experience\":{\"score\":7,\"comment\":\"The candidate reports 4 years of total experience and currently works as a PGT Chemistry Teacher. Chemistry is a relevant science\\/STEM subject, but the profile does not clearly establish 2 to 5 years of dedicated STEM teaching or experience with interdisciplinary STEM programmes.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8069570064544677734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8841112;}i:99;a:6:{i:0;s:1769:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25370, 'pending', '2026-09-08 18:12:47', 'maybe', '49.60', 'Deepak meets the educational hard filter through a B.Ed. and science qualifications including an M.Sc. and B.Sc. in Chemistry. His current PGT Chemistry role and school internship provide relevant subject-teaching exposure, although the profile does not clearly demonstrate interdisciplinary STEM curriculum design, Atal Innovation Mission alignment, project-based learning, or hands-on innovation programme leadership. The location hard filter is not fully verifiable: the profile states Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate. Recruiter verification is required before proceeding.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a Bachelor of Education from Gurugram University, an M.Sc. in Chemistry, and a B.Sc. in Chemistry from listed institutions, which satisfies the requirement for a recognised education or science-related bachelor\'s degree.\"},\"Location\":{\"score\":0,\"comment\":\"The profile lists the candidate\'s city as Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate there. The hard-filter location requirement therefore remains unverified.\"},\"Experience\":{\"score\":7,\"comment\":\"The candidate reports 4 years of total experience and currently works as a PGT Chemistry Teacher. Chemistry is a relevant science\\/STEM subject, but the profile does not clearly establish 2 to 5 years of dedicated STEM teaching or experience with interdisciplinary STEM programmes.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8097651004791259765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8843976;}i:101;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25371)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.809873104095458984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8843752;}i:102;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25371)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.81017398834228515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8844976;}i:104;a:6:{i:0;s:1440:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25371, 'pending', '2026-09-08 18:12:47', 'maybe', '47.00', 'The candidate meets the education hard filter through a Bachelor of Technology in Electronics and Communication and has relevant STEM mentoring, training, and event leadership experience. However, the candidate is located in Noida, while Dwarka, New Delhi is specified as a hard-filter location requirement. Willingness to relocate is not stated, so the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"Meets the hard-filter requirement with a Bachelor of Technology in Electronics and Communication from the National Institute of Science & Technology, a recognised engineering qualification.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Noida, not Dwarka, New Delhi. The criterion is a hard filter, and willingness to relocate is not explicitly stated.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 2 years of experience as a Sr. Innovation Engineer, including mentoring students and teachers, delivering STEM training, and leading STEM events. However, direct school-based teaching experience and curriculum implementation are not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.81035900115966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8849880;}i:105;a:6:{i:0;s:1440:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25371, 'pending', '2026-09-08 18:12:47', 'maybe', '47.00', 'The candidate meets the education hard filter through a Bachelor of Technology in Electronics and Communication and has relevant STEM mentoring, training, and event leadership experience. However, the candidate is located in Noida, while Dwarka, New Delhi is specified as a hard-filter location requirement. Willingness to relocate is not stated, so the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"Meets the hard-filter requirement with a Bachelor of Technology in Electronics and Communication from the National Institute of Science & Technology, a recognised engineering qualification.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Noida, not Dwarka, New Delhi. The criterion is a hard filter, and willingness to relocate is not explicitly stated.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 2 years of experience as a Sr. Innovation Engineer, including mentoring students and teachers, delivering STEM training, and leading STEM events. However, direct school-based teaching experience and curriculum implementation are not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8108670711517333984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8852232;}i:107;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25372)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8109569549560546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8852520;}i:108;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25372)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8111140727996826171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8853744;}i:110;a:6:{i:0;s:1734:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25372, 'pending', '2026-09-08 18:12:47', 'maybe', '59.60', 'Arzoo Khan meets the education requirement through a B.Ed. from Mahatma Gandhi Kashi Vidyapith and has substantial school administration and academic coordination experience. However, the profile does not demonstrate 2–5 years of relevant STEM teaching experience; the documented subject background is Social Studies/Social Science. The candidate is based in New Delhi, but residence specifically in Dwarka is not confirmed, and willingness to relocate is not stated. The hard location requirement therefore requires verification before shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed. from Mahatma Gandhi Kashi Vidyapith, Varanasi, which is a bachelor\'s degree in Education and aligns with the stated education requirement.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as New Delhi, but the profile does not confirm residence in Dwarka specifically and does not state willingness to relocate. The hard location requirement remains unverified.\"},\"Experience\":{\"score\":2,\"comment\":\"The candidate has 8 years as an Academic Coordinator with responsibilities including academic coordination, faculty supervision, examination coordination, and school operations management. However, the profile does not demonstrate relevant STEM teaching experience; subjects listed are Social Studies and Social Science, and the total experience also exceeds the preferred 2\\u20135 year range.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8112471103668212890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8860184;}i:111;a:6:{i:0;s:1734:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25372, 'pending', '2026-09-08 18:12:47', 'maybe', '59.60', 'Arzoo Khan meets the education requirement through a B.Ed. from Mahatma Gandhi Kashi Vidyapith and has substantial school administration and academic coordination experience. However, the profile does not demonstrate 2–5 years of relevant STEM teaching experience; the documented subject background is Social Studies/Social Science. The candidate is based in New Delhi, but residence specifically in Dwarka is not confirmed, and willingness to relocate is not stated. The hard location requirement therefore requires verification before shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed. from Mahatma Gandhi Kashi Vidyapith, Varanasi, which is a bachelor\'s degree in Education and aligns with the stated education requirement.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as New Delhi, but the profile does not confirm residence in Dwarka specifically and does not state willingness to relocate. The hard location requirement remains unverified.\"},\"Experience\":{\"score\":2,\"comment\":\"The candidate has 8 years as an Academic Coordinator with responsibilities including academic coordination, faculty supervision, examination coordination, and school operations management. However, the profile does not demonstrate relevant STEM teaching experience; subjects listed are Social Studies and Social Science, and the total experience also exceeds the preferred 2\\u20135 year range.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.812117099761962890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8863048;}i:113;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25559)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.812201976776123046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8862824;}i:114;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25559)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.812345027923583984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8864048;}i:116;a:6:{i:0;s:1946:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25559, 'pending', '2026-09-08 18:12:47', 'maybe', '66.50', 'The candidate meets the hard education filter through a B.Sc. in PCM and a B.Ed. from listed institutions. She has approximately two years of documented PGT Chemistry experience, along with broader Science and teaching experience, which is relevant to a STEM role. However, her profile does not demonstrate direct experience designing interdisciplinary STEM programmes, Atal Innovation Mission alignment, project-based or inquiry-based learning, emerging technologies, or STEM-specific innovation projects. Her location is listed as Banda/Sagar, Madhya Pradesh, and willingness to relocate to Dwarka, New Delhi is not stated; recruiter confirmation is required.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in PCM and a B.Ed. in All Subjects, satisfying the stated bachelor\'s degree requirement in Science and Education. The institutions are listed in the profile, although formal recognition is not independently verified.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s listed locations are Banda and Sagar, Madhya Pradesh, not Dwarka, New Delhi. The job permits relocation, but the profile does not state willingness to relocate, so recruiter confirmation is required.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 10 years of total teaching experience and documented PGT Chemistry experience from 01\\/11\\/2023 to 27\\/03\\/2024 and 27\\/06\\/2024 to 10\\/02\\/2026, broadly aligning with the preferred 2 to 5 years of relevant subject experience. However, direct STEM teaching, interdisciplinary programme development, project-based learning, and Atal Innovation Mission experience are not demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8125479221343994140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8869464;}i:117;a:6:{i:0;s:1946:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25559, 'pending', '2026-09-08 18:12:47', 'maybe', '66.50', 'The candidate meets the hard education filter through a B.Sc. in PCM and a B.Ed. from listed institutions. She has approximately two years of documented PGT Chemistry experience, along with broader Science and teaching experience, which is relevant to a STEM role. However, her profile does not demonstrate direct experience designing interdisciplinary STEM programmes, Atal Innovation Mission alignment, project-based or inquiry-based learning, emerging technologies, or STEM-specific innovation projects. Her location is listed as Banda/Sagar, Madhya Pradesh, and willingness to relocate to Dwarka, New Delhi is not stated; recruiter confirmation is required.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in PCM and a B.Ed. in All Subjects, satisfying the stated bachelor\'s degree requirement in Science and Education. The institutions are listed in the profile, although formal recognition is not independently verified.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s listed locations are Banda and Sagar, Madhya Pradesh, not Dwarka, New Delhi. The job permits relocation, but the profile does not state willingness to relocate, so recruiter confirmation is required.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 10 years of total teaching experience and documented PGT Chemistry experience from 01\\/11\\/2023 to 27\\/03\\/2024 and 27\\/06\\/2024 to 10\\/02\\/2026, broadly aligning with the preferred 2 to 5 years of relevant subject experience. However, direct STEM teaching, interdisciplinary programme development, project-based learning, and Atal Innovation Mission experience are not demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8130300045013427734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8872328;}i:119;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=26035)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8131160736083984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8872104;}i:120;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=26035)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8132610321044921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8873328;}i:122;a:6:{i:0;s:2002:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 26035, 'pending', '2026-09-08 18:12:47', 'maybe', '72.60', 'Gourav satisfies the hard education requirement with a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions. He has approximately three years of relevant STEM exposure, including Science teaching for Classes IX-XII, science communication, STEM workshops, robotics and programming activities, curriculum support, and science-fair organization. Direct school teaching experience is documented from July 2023 to December 2024, while the current Science Communicator role adds relevant practical STEM experience. Current residence is listed as Delhi, but relocation willingness to Dwarka is not stated and should be confirmed. Based on the weighted score and the non-mandatory nature of the location and experience preferences, he is suitable for shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions, satisfying the hard-filter requirement for a recognised degree in Education or Science-related fields.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as Delhi, but residence specifically in Dwarka is not demonstrated. Willingness to relocate to Dwarka, New Delhi is also not stated, so recruiter confirmation is required.\"},\"Experience\":{\"score\":7,\"comment\":\"The profile states approximately three years of total experience and documents Science teaching for Classes IX-XII from July 2023 to December 2024, followed by Science Communicator work from January 2025. STEM workshops, robotics and programming, curriculum support, teacher training, and science-fair organization strengthen relevance, although two full years of direct school teaching is not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8134109973907470703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8878744;}i:123;a:6:{i:0;s:2002:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 26035, 'pending', '2026-09-08 18:12:47', 'maybe', '72.60', 'Gourav satisfies the hard education requirement with a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions. He has approximately three years of relevant STEM exposure, including Science teaching for Classes IX-XII, science communication, STEM workshops, robotics and programming activities, curriculum support, and science-fair organization. Direct school teaching experience is documented from July 2023 to December 2024, while the current Science Communicator role adds relevant practical STEM experience. Current residence is listed as Delhi, but relocation willingness to Dwarka is not stated and should be confirmed. Based on the weighted score and the non-mandatory nature of the location and experience preferences, he is suitable for shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions, satisfying the hard-filter requirement for a recognised degree in Education or Science-related fields.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as Delhi, but residence specifically in Dwarka is not demonstrated. Willingness to relocate to Dwarka, New Delhi is also not stated, so recruiter confirmation is required.\"},\"Experience\":{\"score\":7,\"comment\":\"The profile states approximately three years of total experience and documents Science teaching for Classes IX-XII from July 2023 to December 2024, followed by Science Communicator work from January 2025. STEM workshops, robotics and programming, curriculum support, teacher training, and science-fair organization strengthen relevance, although two full years of direct school teaching is not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.814259052276611328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8882120;}i:130;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `audit_log`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9703729152679443359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10207320;}i:131;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `audit_log`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.971231937408447265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10217384;}i:133;a:6:{i:0;s:29:"SHOW CREATE TABLE `audit_log`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.971291065216064453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10220336;}i:134;a:6:{i:0;s:29:"SHOW CREATE TABLE `audit_log`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9714000225067138671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10222752;}i:136;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` = 'audit_log' AND `kcu`.`TABLE_NAME` = 'audit_log'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9715359210968017578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10221296;}i:137;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` = 'audit_log' AND `kcu`.`TABLE_NAME` = 'audit_log'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.97187900543212890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10223528;}i:139;a:6:{i:0;s:229:"INSERT INTO `audit_log` (`user_id`, `action`, `entity_type`, `entity_id`, `old_value`, `new_value`, `ip_address`, `created_at`) VALUES (3, 'shortlisting.submitted_for_approval', 'position', 7, NULL, NULL, '223.181.46.216', NOW())";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871373.97227001190185546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:51;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10227856;}i:140;a:6:{i:0;s:229:"INSERT INTO `audit_log` (`user_id`, `action`, `entity_type`, `entity_id`, `old_value`, `new_value`, `ip_address`, `created_at`) VALUES (3, 'shortlisting.submitted_for_approval', 'position', 7, NULL, NULL, '223.181.46.216', NOW())";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871373.974914073944091796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:51;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10229368;}}}";s:2:"db";s:68666:"a:1:{s:8:"messages";a:80:{i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78337192535400390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6123616;}i:10;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78401088714599609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6138064;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78404903411865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6140264;}i:13;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.78415203094482421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6142456;}i:15;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.784491062164306640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6160184;}i:16;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7848360538482666015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6162040;}i:18;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=3) AND (`status`=10)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.786303043365478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6603656;}i:19;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=3) AND (`status`=10)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7865569591522216796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/home/appselectionsear/public_html/common/models/User.php";s:4:"line";i:113;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6606224;}i:29;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `positions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7929298877716064453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8282000;}i:30;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `positions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7934329509735107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8304928;}i:32;a:6:{i:0;s:29:"SHOW CREATE TABLE `positions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7934710979461669921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8307880;}i:33;a:6:{i:0;s:29:"SHOW CREATE TABLE `positions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7935578823089599609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8311704;}i:35;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` = 'positions' AND `kcu`.`TABLE_NAME` = 'positions'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79368495941162109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8303368;}i:36;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` = 'positions' AND `kcu`.`TABLE_NAME` = 'positions'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7939510345458984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305600;}i:38;a:6:{i:0;s:40:"SELECT * FROM `positions` WHERE `id`='7'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.794022083282470703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305792;}i:39;a:6:{i:0;s:40:"SELECT * FROM `positions` WHERE `id`='7'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7941989898681640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:829;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:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:557;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8315392;}i:41;a:6:{i:0;s:91:"SELECT * FROM `candidate_position_scores` WHERE (`position_id`='7') AND (`status`='scored')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7945249080657958984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8360624;}i:42;a:6:{i:0;s:91:"SELECT * FROM `candidate_position_scores` WHERE (`position_id`='7') AND (`status`='scored')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.794765949249267578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8378360;}i:44;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `candidate_position_scores`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79483890533447265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8385352;}i:45;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `candidate_position_scores`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.795445919036865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8399432;}i:47;a:6:{i:0;s:45:"SHOW CREATE TABLE `candidate_position_scores`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.79549503326416015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8401656;}i:48;a:6:{i:0;s:45:"SHOW CREATE TABLE `candidate_position_scores`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7955799102783203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8404480;}i:50;a:6:{i:0;s:806:"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` = 'candidate_position_scores' AND `kcu`.`TABLE_NAME` = 'candidate_position_scores'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7956559658050537109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8400192;}i:51;a:6:{i:0;s:806:"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` = 'candidate_position_scores' AND `kcu`.`TABLE_NAME` = 'candidate_position_scores'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7958500385284423828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8403272;}i:53;a:6:{i:0;s:83:"SELECT * FROM `candidates` WHERE `id` IN (25369, 25370, 25371, 25372, 25559, 26035)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7964479923248291015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8576648;}i:54;a:6:{i:0;s:83:"SELECT * FROM `candidates` WHERE `id` IN (25369, 25370, 25371, 25372, 25559, 26035)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.796649932861328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8621944;}i:56;a:6:{i:0;s:35:"SHOW FULL COLUMNS FROM `candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7967040538787841796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8629968;}i:57;a:6:{i:0;s:35:"SHOW FULL COLUMNS FROM `candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.797070980072021484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8649832;}i:59;a:6:{i:0;s:30:"SHOW CREATE TABLE `candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7971069812774658203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8652032;}i:60;a:6:{i:0;s:30:"SHOW CREATE TABLE `candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.797194004058837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8654840;}i:62;a:6:{i:0;s:776:"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` = 'candidates' AND `kcu`.`TABLE_NAME` = 'candidates'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.797274112701416015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8647480;}i:63;a:6:{i:0;s:776:"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` = 'candidates' AND `kcu`.`TABLE_NAME` = 'candidates'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7974889278411865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:566;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8649336;}i:65;a:6:{i:0;s:80:"SELECT * FROM `shortlist_submissions` WHERE `position_id`='7' ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7980010509490966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:591;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8691960;}i:66;a:6:{i:0;s:80:"SELECT * FROM `shortlist_submissions` WHERE `position_id`='7' ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7985370159149169921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:591;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8693072;}i:68;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlist_submissions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7985908985137939453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8694944;}i:69;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlist_submissions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7989590167999267578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8702448;}i:71;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlist_submissions`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7989981174468994140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8704672;}i:72;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlist_submissions`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.799067020416259765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8706592;}i:74;a:6:{i:0;s:798:"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` = 'shortlist_submissions' AND `kcu`.`TABLE_NAME` = 'shortlist_submissions'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7991330623626708984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8705464;}i:75;a:6:{i:0;s:798:"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` = 'shortlist_submissions' AND `kcu`.`TABLE_NAME` = 'shortlist_submissions'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.7992599010467529296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:600;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8707320;}i:77;a:6:{i:0;s:215:"INSERT INTO `shortlist_submissions` (`position_id`, `submitted_by`, `submitted_at`, `status`, `created_at`, `updated_at`) VALUES (7, 3, '2026-09-08 18:12:47', 'pending', '2026-09-08 18:12:47', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.799808025360107421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:607;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8778000;}i:78;a:6:{i:0;s:215:"INSERT INTO `shortlist_submissions` (`position_id`, `submitted_by`, `submitted_at`, `status`, `created_at`, `updated_at`) VALUES (7, 3, '2026-09-08 18:12:47', 'pending', '2026-09-08 18:12:47', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8014709949493408203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:607;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8779136;}i:80;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25369)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.80169010162353515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8807016;}i:81;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25369)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8020908832550048828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8808240;}i:83;a:6:{i:0;s:56:"SHOW FULL COLUMNS FROM `shortlist_submission_candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8021450042724609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8810240;}i:84;a:6:{i:0;s:56:"SHOW FULL COLUMNS FROM `shortlist_submission_candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.802524089813232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8820616;}i:86;a:6:{i:0;s:51:"SHOW CREATE TABLE `shortlist_submission_candidates`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8025600910186767578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8822840;}i:87;a:6:{i:0;s:51:"SHOW CREATE TABLE `shortlist_submission_candidates`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.80292797088623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8825024;}i:89;a:6:{i:0;s:818:"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` = 'shortlist_submission_candidates' AND `kcu`.`TABLE_NAME` = 'shortlist_submission_candidates'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8030469417572021484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8822256;}i:90;a:6:{i:0;s:818:"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` = 'shortlist_submission_candidates' AND `kcu`.`TABLE_NAME` = 'shortlist_submission_candidates'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8032529354095458984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:670;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8824112;}i:92;a:6:{i:0;s:1861:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25369, 'pending', '2026-09-08 18:12:47', 'maybe', '52.20', 'The candidate meets the education hard filter through a B.Sc. in Mathematics and Education and a Bachelor of Education from recognised institutions. He also has relevant Mathematics and Physics teaching experience and academic coordination exposure. However, the location criterion is a hard filter requiring Dwarka, New Delhi, while the candidate is located in Jhansi, Uttar Pradesh. Although the job description permits relocation, the candidate profile does not explicitly confirm willingness to relocate. Therefore, the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in Mathematics and Education, a Bachelor of Education, and postgraduate qualifications in Mathematics and Business Administration. This satisfies the required bachelor\'s degree in Education, Mathematics, or a related field.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Jhansi, Uttar Pradesh, whereas the hard-filter location requirement is Dwarka, New Delhi. The profile does not explicitly state willingness to relocate.\"},\"Experience\":{\"score\":8,\"comment\":\"The candidate has eight years of documented teaching experience in Mathematics and Physics, including roles at St. Stephen\\u2019s Global School, M.P.S. Group, and Little Flower International School. This is relevant to STEM teaching, although it exceeds the preferred 2-to-5-year range and does not demonstrate specific interdisciplinary STEM, Atal Innovation Mission, project-based, or inquiry-based programme experience.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8035309314727783203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8831832;}i:93;a:6:{i:0;s:1861:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25369, 'pending', '2026-09-08 18:12:47', 'maybe', '52.20', 'The candidate meets the education hard filter through a B.Sc. in Mathematics and Education and a Bachelor of Education from recognised institutions. He also has relevant Mathematics and Physics teaching experience and academic coordination exposure. However, the location criterion is a hard filter requiring Dwarka, New Delhi, while the candidate is located in Jhansi, Uttar Pradesh. Although the job description permits relocation, the candidate profile does not explicitly confirm willingness to relocate. Therefore, the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in Mathematics and Education, a Bachelor of Education, and postgraduate qualifications in Mathematics and Business Administration. This satisfies the required bachelor\'s degree in Education, Mathematics, or a related field.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Jhansi, Uttar Pradesh, whereas the hard-filter location requirement is Dwarka, New Delhi. The profile does not explicitly state willingness to relocate.\"},\"Experience\":{\"score\":8,\"comment\":\"The candidate has eight years of documented teaching experience in Mathematics and Physics, including roles at St. Stephen\\u2019s Global School, M.P.S. Group, and Little Flower International School. This is relevant to STEM teaching, although it exceeds the preferred 2-to-5-year range and does not demonstrate specific interdisciplinary STEM, Atal Innovation Mission, project-based, or inquiry-based programme experience.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8065168857574462890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8834696;}i:95;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25370)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.80661296844482421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8834472;}i:96;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25370)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.806766986846923828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8835696;}i:98;a:6:{i:0;s:1769:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25370, 'pending', '2026-09-08 18:12:47', 'maybe', '49.60', 'Deepak meets the educational hard filter through a B.Ed. and science qualifications including an M.Sc. and B.Sc. in Chemistry. His current PGT Chemistry role and school internship provide relevant subject-teaching exposure, although the profile does not clearly demonstrate interdisciplinary STEM curriculum design, Atal Innovation Mission alignment, project-based learning, or hands-on innovation programme leadership. The location hard filter is not fully verifiable: the profile states Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate. Recruiter verification is required before proceeding.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a Bachelor of Education from Gurugram University, an M.Sc. in Chemistry, and a B.Sc. in Chemistry from listed institutions, which satisfies the requirement for a recognised education or science-related bachelor\'s degree.\"},\"Location\":{\"score\":0,\"comment\":\"The profile lists the candidate\'s city as Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate there. The hard-filter location requirement therefore remains unverified.\"},\"Experience\":{\"score\":7,\"comment\":\"The candidate reports 4 years of total experience and currently works as a PGT Chemistry Teacher. Chemistry is a relevant science\\/STEM subject, but the profile does not clearly establish 2 to 5 years of dedicated STEM teaching or experience with interdisciplinary STEM programmes.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8069570064544677734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8841112;}i:99;a:6:{i:0;s:1769:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25370, 'pending', '2026-09-08 18:12:47', 'maybe', '49.60', 'Deepak meets the educational hard filter through a B.Ed. and science qualifications including an M.Sc. and B.Sc. in Chemistry. His current PGT Chemistry role and school internship provide relevant subject-teaching exposure, although the profile does not clearly demonstrate interdisciplinary STEM curriculum design, Atal Innovation Mission alignment, project-based learning, or hands-on innovation programme leadership. The location hard filter is not fully verifiable: the profile states Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate. Recruiter verification is required before proceeding.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a Bachelor of Education from Gurugram University, an M.Sc. in Chemistry, and a B.Sc. in Chemistry from listed institutions, which satisfies the requirement for a recognised education or science-related bachelor\'s degree.\"},\"Location\":{\"score\":0,\"comment\":\"The profile lists the candidate\'s city as Delhi but does not confirm residence in Dwarka, New Delhi, or willingness to relocate there. The hard-filter location requirement therefore remains unverified.\"},\"Experience\":{\"score\":7,\"comment\":\"The candidate reports 4 years of total experience and currently works as a PGT Chemistry Teacher. Chemistry is a relevant science\\/STEM subject, but the profile does not clearly establish 2 to 5 years of dedicated STEM teaching or experience with interdisciplinary STEM programmes.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8097651004791259765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8843976;}i:101;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25371)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.809873104095458984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8843752;}i:102;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25371)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.81017398834228515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8844976;}i:104;a:6:{i:0;s:1440:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25371, 'pending', '2026-09-08 18:12:47', 'maybe', '47.00', 'The candidate meets the education hard filter through a Bachelor of Technology in Electronics and Communication and has relevant STEM mentoring, training, and event leadership experience. However, the candidate is located in Noida, while Dwarka, New Delhi is specified as a hard-filter location requirement. Willingness to relocate is not stated, so the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"Meets the hard-filter requirement with a Bachelor of Technology in Electronics and Communication from the National Institute of Science & Technology, a recognised engineering qualification.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Noida, not Dwarka, New Delhi. The criterion is a hard filter, and willingness to relocate is not explicitly stated.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 2 years of experience as a Sr. Innovation Engineer, including mentoring students and teachers, delivering STEM training, and leading STEM events. However, direct school-based teaching experience and curriculum implementation are not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.81035900115966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8849880;}i:105;a:6:{i:0;s:1440:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25371, 'pending', '2026-09-08 18:12:47', 'maybe', '47.00', 'The candidate meets the education hard filter through a Bachelor of Technology in Electronics and Communication and has relevant STEM mentoring, training, and event leadership experience. However, the candidate is located in Noida, while Dwarka, New Delhi is specified as a hard-filter location requirement. Willingness to relocate is not stated, so the confirmed location mismatch results in a no_fit classification.', '{\"Education\":{\"score\":9,\"comment\":\"Meets the hard-filter requirement with a Bachelor of Technology in Electronics and Communication from the National Institute of Science & Technology, a recognised engineering qualification.\"},\"Location\":{\"score\":0,\"comment\":\"The candidate\'s stated city is Noida, not Dwarka, New Delhi. The criterion is a hard filter, and willingness to relocate is not explicitly stated.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 2 years of experience as a Sr. Innovation Engineer, including mentoring students and teachers, delivering STEM training, and leading STEM events. However, direct school-based teaching experience and curriculum implementation are not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8108670711517333984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8852232;}i:107;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25372)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8109569549560546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8852520;}i:108;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25372)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8111140727996826171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8853744;}i:110;a:6:{i:0;s:1734:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25372, 'pending', '2026-09-08 18:12:47', 'maybe', '59.60', 'Arzoo Khan meets the education requirement through a B.Ed. from Mahatma Gandhi Kashi Vidyapith and has substantial school administration and academic coordination experience. However, the profile does not demonstrate 2–5 years of relevant STEM teaching experience; the documented subject background is Social Studies/Social Science. The candidate is based in New Delhi, but residence specifically in Dwarka is not confirmed, and willingness to relocate is not stated. The hard location requirement therefore requires verification before shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed. from Mahatma Gandhi Kashi Vidyapith, Varanasi, which is a bachelor\'s degree in Education and aligns with the stated education requirement.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as New Delhi, but the profile does not confirm residence in Dwarka specifically and does not state willingness to relocate. The hard location requirement remains unverified.\"},\"Experience\":{\"score\":2,\"comment\":\"The candidate has 8 years as an Academic Coordinator with responsibilities including academic coordination, faculty supervision, examination coordination, and school operations management. However, the profile does not demonstrate relevant STEM teaching experience; subjects listed are Social Studies and Social Science, and the total experience also exceeds the preferred 2\\u20135 year range.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8112471103668212890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8860184;}i:111;a:6:{i:0;s:1734:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25372, 'pending', '2026-09-08 18:12:47', 'maybe', '59.60', 'Arzoo Khan meets the education requirement through a B.Ed. from Mahatma Gandhi Kashi Vidyapith and has substantial school administration and academic coordination experience. However, the profile does not demonstrate 2–5 years of relevant STEM teaching experience; the documented subject background is Social Studies/Social Science. The candidate is based in New Delhi, but residence specifically in Dwarka is not confirmed, and willingness to relocate is not stated. The hard location requirement therefore requires verification before shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed. from Mahatma Gandhi Kashi Vidyapith, Varanasi, which is a bachelor\'s degree in Education and aligns with the stated education requirement.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as New Delhi, but the profile does not confirm residence in Dwarka specifically and does not state willingness to relocate. The hard location requirement remains unverified.\"},\"Experience\":{\"score\":2,\"comment\":\"The candidate has 8 years as an Academic Coordinator with responsibilities including academic coordination, faculty supervision, examination coordination, and school operations management. However, the profile does not demonstrate relevant STEM teaching experience; subjects listed are Social Studies and Social Science, and the total experience also exceeds the preferred 2\\u20135 year range.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.812117099761962890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8863048;}i:113;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25559)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.812201976776123046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8862824;}i:114;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=25559)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.812345027923583984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8864048;}i:116;a:6:{i:0;s:1946:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25559, 'pending', '2026-09-08 18:12:47', 'maybe', '66.50', 'The candidate meets the hard education filter through a B.Sc. in PCM and a B.Ed. from listed institutions. She has approximately two years of documented PGT Chemistry experience, along with broader Science and teaching experience, which is relevant to a STEM role. However, her profile does not demonstrate direct experience designing interdisciplinary STEM programmes, Atal Innovation Mission alignment, project-based or inquiry-based learning, emerging technologies, or STEM-specific innovation projects. Her location is listed as Banda/Sagar, Madhya Pradesh, and willingness to relocate to Dwarka, New Delhi is not stated; recruiter confirmation is required.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in PCM and a B.Ed. in All Subjects, satisfying the stated bachelor\'s degree requirement in Science and Education. The institutions are listed in the profile, although formal recognition is not independently verified.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s listed locations are Banda and Sagar, Madhya Pradesh, not Dwarka, New Delhi. The job permits relocation, but the profile does not state willingness to relocate, so recruiter confirmation is required.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 10 years of total teaching experience and documented PGT Chemistry experience from 01\\/11\\/2023 to 27\\/03\\/2024 and 27\\/06\\/2024 to 10\\/02\\/2026, broadly aligning with the preferred 2 to 5 years of relevant subject experience. However, direct STEM teaching, interdisciplinary programme development, project-based learning, and Atal Innovation Mission experience are not demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8125479221343994140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8869464;}i:117;a:6:{i:0;s:1946:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 25559, 'pending', '2026-09-08 18:12:47', 'maybe', '66.50', 'The candidate meets the hard education filter through a B.Sc. in PCM and a B.Ed. from listed institutions. She has approximately two years of documented PGT Chemistry experience, along with broader Science and teaching experience, which is relevant to a STEM role. However, her profile does not demonstrate direct experience designing interdisciplinary STEM programmes, Atal Innovation Mission alignment, project-based or inquiry-based learning, emerging technologies, or STEM-specific innovation projects. Her location is listed as Banda/Sagar, Madhya Pradesh, and willingness to relocate to Dwarka, New Delhi is not stated; recruiter confirmation is required.', '{\"Education\":{\"score\":9,\"comment\":\"The candidate holds a B.Sc. in PCM and a B.Ed. in All Subjects, satisfying the stated bachelor\'s degree requirement in Science and Education. The institutions are listed in the profile, although formal recognition is not independently verified.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s listed locations are Banda and Sagar, Madhya Pradesh, not Dwarka, New Delhi. The job permits relocation, but the profile does not state willingness to relocate, so recruiter confirmation is required.\"},\"Experience\":{\"score\":6,\"comment\":\"The candidate has 10 years of total teaching experience and documented PGT Chemistry experience from 01\\/11\\/2023 to 27\\/03\\/2024 and 27\\/06\\/2024 to 10\\/02\\/2026, broadly aligning with the preferred 2 to 5 years of relevant subject experience. However, direct STEM teaching, interdisciplinary programme development, project-based learning, and Atal Innovation Mission experience are not demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8130300045013427734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8872328;}i:119;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=26035)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8131160736083984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8872104;}i:120;a:6:{i:0;s:100:"SELECT * FROM `shortlist_submission_candidates` WHERE (`submission_id`=3) AND (`candidate_id`=26035)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871367.8132610321044921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:663;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8873328;}i:122;a:6:{i:0;s:2002:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 26035, 'pending', '2026-09-08 18:12:47', 'maybe', '72.60', 'Gourav satisfies the hard education requirement with a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions. He has approximately three years of relevant STEM exposure, including Science teaching for Classes IX-XII, science communication, STEM workshops, robotics and programming activities, curriculum support, and science-fair organization. Direct school teaching experience is documented from July 2023 to December 2024, while the current Science Communicator role adds relevant practical STEM experience. Current residence is listed as Delhi, but relocation willingness to Dwarka is not stated and should be confirmed. Based on the weighted score and the non-mandatory nature of the location and experience preferences, he is suitable for shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions, satisfying the hard-filter requirement for a recognised degree in Education or Science-related fields.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as Delhi, but residence specifically in Dwarka is not demonstrated. Willingness to relocate to Dwarka, New Delhi is also not stated, so recruiter confirmation is required.\"},\"Experience\":{\"score\":7,\"comment\":\"The profile states approximately three years of total experience and documents Science teaching for Classes IX-XII from July 2023 to December 2024, followed by Science Communicator work from January 2025. STEM workshops, robotics and programming, curriculum support, teacher training, and science-fair organization strengthen relevance, although two full years of direct school teaching is not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.8134109973907470703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8878744;}i:123;a:6:{i:0;s:2002:"INSERT INTO `shortlist_submission_candidates` (`submission_id`, `candidate_id`, `approval_status`, `created_at`, `tier`, `score`, `ai_rationale`, `score_breakdown`, `updated_at`) VALUES (3, 26035, 'pending', '2026-09-08 18:12:47', 'maybe', '72.60', 'Gourav satisfies the hard education requirement with a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions. He has approximately three years of relevant STEM exposure, including Science teaching for Classes IX-XII, science communication, STEM workshops, robotics and programming activities, curriculum support, and science-fair organization. Direct school teaching experience is documented from July 2023 to December 2024, while the current Science Communicator role adds relevant practical STEM experience. Current residence is listed as Delhi, but relocation willingness to Dwarka is not stated and should be confirmed. Based on the weighted score and the non-mandatory nature of the location and experience preferences, he is suitable for shortlisting.', '{\"Education\":{\"score\":10,\"comment\":\"The candidate holds a B.Ed., B.Sc. in Physics, and M.Sc. in Physics from named institutions, satisfying the hard-filter requirement for a recognised degree in Education or Science-related fields.\"},\"Location\":{\"score\":5,\"comment\":\"The candidate\'s city is listed as Delhi, but residence specifically in Dwarka is not demonstrated. Willingness to relocate to Dwarka, New Delhi is also not stated, so recruiter confirmation is required.\"},\"Experience\":{\"score\":7,\"comment\":\"The profile states approximately three years of total experience and documents Science teaching for Classes IX-XII from July 2023 to December 2024, followed by Science Communicator work from January 2025. STEM workshops, robotics and programming, curriculum support, teacher training, and science-fair organization strengthen relevance, although two full years of direct school teaching is not clearly demonstrated.\"}}', '2026-09-08 18:12:47')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871367.814259052276611328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:685;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:8882120;}i:130;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `audit_log`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9703729152679443359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10207320;}i:131;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `audit_log`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.971231937408447265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10217384;}i:133;a:6:{i:0;s:29:"SHOW CREATE TABLE `audit_log`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.971291065216064453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10220336;}i:134;a:6:{i:0;s:29:"SHOW CREATE TABLE `audit_log`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9714000225067138671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10222752;}i:136;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` = 'audit_log' AND `kcu`.`TABLE_NAME` = 'audit_log'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.9715359210968017578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10221296;}i:137;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` = 'audit_log' AND `kcu`.`TABLE_NAME` = 'audit_log'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871373.97187900543212890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:44;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10223528;}i:139;a:6:{i:0;s:229:"INSERT INTO `audit_log` (`user_id`, `action`, `entity_type`, `entity_id`, `old_value`, `new_value`, `ip_address`, `created_at`) VALUES (3, 'shortlisting.submitted_for_approval', 'position', 7, NULL, NULL, '223.181.46.216', NOW())";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871373.97227001190185546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:51;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10227856;}i:140;a:6:{i:0;s:229:"INSERT INTO `audit_log` (`user_id`, `action`, `entity_type`, `entity_id`, `old_value`, `new_value`, `ip_address`, `created_at`) VALUES (3, 'shortlisting.submitted_for_approval', 'position', 7, NULL, NULL, '223.181.46.216', NOW())";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788871373.974914073944091796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:61:"/home/appselectionsear/public_html/common/models/AuditLog.php";s:4:"line";i:51;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:739;s:8:"function";s:6:"record";s:5:"class";s:22:"common\models\AuditLog";s:4:"type";s:2:"::";}}i:5;i:10229368;}}}";s:5:"event";s:21467:"a:108:{i:0;a:5:{s:4:"time";d:1788871367.7815990447998046875;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:1788871367.7833449840545654296875;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:1788871367.7867820262908935546875;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:1788871367.7868139743804931640625;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:1788871367.7883689403533935546875;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:1788871367.7898900508880615234375;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:1788871367.791922092437744140625;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:1788871367.791925907135009765625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"backend\modules\shortlisting\ShortlistingModule";}i:8;a:5:{s:4:"time";d:1788871367.7927610874176025390625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:58:"backend\modules\shortlisting\controllers\DefaultController";}i:9;a:5:{s:4:"time";d:1788871367.79290103912353515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:10;a:5:{s:4:"time";d:1788871367.794352054595947265625;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\Position";}i:11;a:5:{s:4:"time";d:1788871367.794373989105224609375;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\Position";}i:12;a:5:{s:4:"time";d:1788871367.79446697235107421875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:13;a:5:{s:4:"time";d:1788871367.7948019504547119140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:14;a:5:{s:4:"time";d:1788871367.79588794708251953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:15;a:5:{s:4:"time";d:1788871367.7959020137786865234375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:16;a:5:{s:4:"time";d:1788871367.7959120273590087890625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:17;a:5:{s:4:"time";d:1788871367.7959220409393310546875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:18;a:5:{s:4:"time";d:1788871367.7959311008453369140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:19;a:5:{s:4:"time";d:1788871367.796165943145751953125;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:1788871367.796681880950927734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:21;a:5:{s:4:"time";d:1788871367.797545909881591796875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:22;a:5:{s:4:"time";d:1788871367.797566890716552734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:23;a:5:{s:4:"time";d:1788871367.797583103179931640625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:24;a:5:{s:4:"time";d:1788871367.7976000308990478515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:25;a:5:{s:4:"time";d:1788871367.79761600494384765625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:26;a:5:{s:4:"time";d:1788871367.797627925872802734375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:27;a:5:{s:4:"time";d:1788871367.7976291179656982421875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:28;a:5:{s:4:"time";d:1788871367.7976300716400146484375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:29;a:5:{s:4:"time";d:1788871367.7976310253143310546875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:30;a:5:{s:4:"time";d:1788871367.7976319789886474609375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:31;a:5:{s:4:"time";d:1788871367.7976338863372802734375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"common\models\Candidate";}i:32;a:5:{s:4:"time";d:1788871367.7977468967437744140625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:33;a:5:{s:4:"time";d:1788871367.797750949859619140625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:34;a:5:{s:4:"time";d:1788871367.7977540493011474609375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:35;a:5:{s:4:"time";d:1788871367.7977559566497802734375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:36;a:5:{s:4:"time";d:1788871367.7977581024169921875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:37;a:5:{s:4:"time";d:1788871367.797760009765625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:36:"common\models\CandidatePositionScore";}i:38;a:5:{s:4:"time";d:1788871367.7979180812835693359375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:39;a:5:{s:4:"time";d:1788871367.7985579967498779296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"common\models\ShortlistSubmission";}i:40;a:5:{s:4:"time";d:1788871367.799333095550537109375;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"common\models\ShortlistSubmission";}i:41;a:5:{s:4:"time";d:1788871367.79973697662353515625;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"common\models\ShortlistSubmission";}i:42;a:5:{s:4:"time";d:1788871367.7997438907623291015625;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"common\models\ShortlistSubmission";}i:43;a:5:{s:4:"time";d:1788871367.801570892333984375;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"common\models\ShortlistSubmission";}i:44;a:5:{s:4:"time";d:1788871367.8016369342803955078125;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:45;a:5:{s:4:"time";d:1788871367.8021080493927001953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:46;a:5:{s:4:"time";d:1788871367.8032939434051513671875;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:47;a:5:{s:4:"time";d:1788871367.8034379482269287109375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:48;a:5:{s:4:"time";d:1788871367.80344390869140625;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:49;a:5:{s:4:"time";d:1788871367.8065569400787353515625;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:50;a:5:{s:4:"time";d:1788871367.8065679073333740234375;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:51;a:5:{s:4:"time";d:1788871367.8067829608917236328125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:52;a:5:{s:4:"time";d:1788871367.8068048954010009765625;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:53;a:5:{s:4:"time";d:1788871367.8068959712982177734375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:54;a:5:{s:4:"time";d:1788871367.8069019317626953125;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:55;a:5:{s:4:"time";d:1788871367.8098070621490478515625;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:56;a:5:{s:4:"time";d:1788871367.80982208251953125;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:57;a:5:{s:4:"time";d:1788871367.81019496917724609375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:58;a:5:{s:4:"time";d:1788871367.810224056243896484375;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:59;a:5:{s:4:"time";d:1788871367.8103010654449462890625;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:60;a:5:{s:4:"time";d:1788871367.810306072235107421875;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:61;a:5:{s:4:"time";d:1788871367.8109009265899658203125;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:62;a:5:{s:4:"time";d:1788871367.8109130859375;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:63;a:5:{s:4:"time";d:1788871367.81112194061279296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:64;a:5:{s:4:"time";d:1788871367.8111379146575927734375;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:65;a:5:{s:4:"time";d:1788871367.811193943023681640625;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:66;a:5:{s:4:"time";d:1788871367.8111970424652099609375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:67;a:5:{s:4:"time";d:1788871367.8121490478515625;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:68;a:5:{s:4:"time";d:1788871367.812160968780517578125;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:69;a:5:{s:4:"time";d:1788871367.8123619556427001953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:70;a:5:{s:4:"time";d:1788871367.812386989593505859375;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:71;a:5:{s:4:"time";d:1788871367.8124790191650390625;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:72;a:5:{s:4:"time";d:1788871367.8124840259552001953125;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:73;a:5:{s:4:"time";d:1788871367.8130619525909423828125;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:74;a:5:{s:4:"time";d:1788871367.8130729198455810546875;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:75;a:5:{s:4:"time";d:1788871367.813271045684814453125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:76;a:5:{s:4:"time";d:1788871367.813292026519775390625;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:77;a:5:{s:4:"time";d:1788871367.8133580684661865234375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:78;a:5:{s:4:"time";d:1788871367.8133618831634521484375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:79;a:5:{s:4:"time";d:1788871367.8142869472503662109375;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"common\models\ShortlistSubmissionCandidate";}i:80;a:5:{s:4:"time";d:1788871367.8160169124603271484375;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:81;a:5:{s:4:"time";d:1788871367.817349910736083984375;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:82;a:5:{s:4:"time";d:1788871367.817368030548095703125;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:83;a:5:{s:4:"time";d:1788871367.8174030780792236328125;s:4:"name";s:9:"beginPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:84;a:5:{s:4:"time";d:1788871367.817408084869384765625;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:85;a:5:{s:4:"time";d:1788871367.817410945892333984375;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:86;a:5:{s:4:"time";d:1788871367.8174240589141845703125;s:4:"name";s:7:"endPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:87;a:5:{s:4:"time";d:1788871367.8174889087677001953125;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:88;a:5:{s:4:"time";d:1788871367.81750202178955078125;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:89;a:5:{s:4:"time";d:1788871367.81762599945068359375;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:90;a:5:{s:4:"time";d:1788871367.817635059356689453125;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:91;a:5:{s:4:"time";d:1788871367.8176600933074951171875;s:4:"name";s:9:"beginPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:92;a:5:{s:4:"time";d:1788871367.8176620006561279296875;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:93;a:5:{s:4:"time";d:1788871367.8176629543304443359375;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:94;a:5:{s:4:"time";d:1788871367.81766510009765625;s:4:"name";s:7:"endPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:95;a:5:{s:4:"time";d:1788871367.8176739215850830078125;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:96;a:5:{s:4:"time";d:1788871367.819696903228759765625;s:4:"name";s:10:"beforeSend";s:5:"class";s:18:"yii\mail\MailEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"yii\symfonymailer\Mailer";}i:97;a:5:{s:4:"time";d:1788871373.96858501434326171875;s:4:"name";s:9:"afterSend";s:5:"class";s:18:"yii\mail\MailEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"yii\symfonymailer\Mailer";}i:98;a:5:{s:4:"time";d:1788871373.97027492523193359375;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\AuditLog";}i:99;a:5:{s:4:"time";d:1788871373.9719541072845458984375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\AuditLog";}i:100;a:5:{s:4:"time";d:1788871373.9749610424041748046875;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\AuditLog";}i:101;a:5:{s:4:"time";d:1788871373.9751069545745849609375;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:58:"backend\modules\shortlisting\controllers\DefaultController";}i:102;a:5:{s:4:"time";d:1788871373.9751150608062744140625;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"backend\modules\shortlisting\ShortlistingModule";}i:103;a:5:{s:4:"time";d:1788871373.975120067596435546875;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:104;a:5:{s:4:"time";d:1788871373.9751260280609130859375;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:105;a:5:{s:4:"time";d:1788871373.97513103485107421875;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:106;a:5:{s:4:"time";d:1788871373.9752829074859619140625;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:107;a:5:{s:4:"time";d:1788871373.97533893585205078125;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:413:"a:1:{i:0;a:12:{s:12:"isSuccessful";b:1;s:4:"from";s:26:"sanskarawasthi03@gmail.com";s:2:"to";s:26:"sanskarawasthi03@gmail.com";s:5:"reply";s:0:"";s:2:"cc";s:0:"";s:3:"bcc";s:0:"";s:7:"subject";s:32:"Shortlist submitted for approval";s:7:"charset";s:5:"utf-8";s:4:"body";N;s:7:"headers";s:56:"Content-Type: multipart/alternative; boundary=Lc8mGQJj ";s:4:"time";N;s:4:"file";s:29:"20260908-181253-9687-0723.eml";}}";s:8:"timeline";s:124:"a:3:{s:5:"start";d:1788871367.7700760364532470703125;s:3:"end";d:1788871373.9763739109039306640625;s:6:"memory";i:10334216;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:383:"a:3:{s:8:"messages";a:1:{i:23;a:6:{i:0;s:56:"Pretty URL not enabled. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788871367.78989410400390625;i:4;a:0:{}i:5;i:7510600;}}s:5:"route";s:40:"shortlisting/default/submit-for-approval";s:6:"action";s:85:"backend\modules\shortlisting\controllers\DefaultController::actionSubmitForApproval()";}";s:7:"request";s:7797:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:302;s:14:"requestHeaders";a:18:{s:7:"x-https";s:1:"1";s:6:"cookie";s:603:"_fbp=fb.1.1787635091908.1126328022.AQECAQIB; _ga=GA1.1.93808140.1787689161; _ga_BEEKLPPBE9=GS2.1.s1787689160$o1$g0$t1787689166$j54$l0$h0; _identity-backend=1c3925492ab43da9e72a5463e03a3beca485b57016fc236a801abc5eb80efd42a%3A2%3A%7Bi%3A0%3Bs%3A17%3A%22_identity-backend%22%3Bi%3A1%3Bs%3A46%3A%22%5B3%2C%22bAYc81Ko7Q-MawhyuBmaQu915qZxAD1P%22%2C2592000%5D%22%3B%7D; _csrf-backend=0aa269972371ee0901f9cb362e4740cb73a192a0dcc5c9aa23c487f5adbbf901a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22Wl78oRQ-GdEnH0We3yDsKlDqMg8QQ7qx%22%3B%7D; advanced-backend=012744e688ee19d4dc94607ae2930aaf";s:15:"accept-language";s:14:"en-US,en;q=0.9";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:7:"referer";s:101:"https://app.selectionsearch.in/backend/web/index.php?r=shortlisting%2Fdefault%2Fresults&position_id=7";s:14:"sec-fetch-dest";s:8:"document";s:14:"sec-fetch-user";s:2:"?1";s:14:"sec-fetch-mode";s:8:"navigate";s:14:"sec-fetch-site";s:11:"same-origin";s:6:"accept";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:10:"user-agent";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36";s:25:"upgrade-insecure-requests";s:1:"1";s:18:"sec-ch-ua-platform";s:9:""Windows"";s:16:"sec-ch-ua-mobile";s:2:"?0";s:9:"sec-ch-ua";s:65:""Not=A?Brand";v="99", "Google Chrome";v="151", "Chromium";v="151"";s:10:"connection";s:10:"keep-alive";s:4:"host";s:22:"app.selectionsearch.in";s:13:"authorization";s:0:"";}s:15:"responseHeaders";a:6:{s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:8:"Location";s:94:"https://app.selectionsearch.in/backend/web/index.php?r=shortlisting%2Fdefault%2Fsubmitted&id=3";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:10:"Set-Cookie";s:311:"_identity-backend=1c3925492ab43da9e72a5463e03a3beca485b57016fc236a801abc5eb80efd42a%3A2%3A%7Bi%3A0%3Bs%3A17%3A%22_identity-backend%22%3Bi%3A1%3Bs%3A46%3A%22%5B3%2C%22bAYc81Ko7Q-MawhyuBmaQu915qZxAD1P%22%2C2592000%5D%22%3B%7D; expires=Thu, 08 Oct 2026 12:42:47 GMT; Max-Age=2591994; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:40:"shortlisting/default/submit-for-approval";s:6:"action";s:85:"backend\modules\shortlisting\controllers\DefaultController::actionSubmitForApproval()";s:12:"actionParams";a:1:{s:11:"position_id";s:1:"7";}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:58:{s:4:"USER";s:16:"appselectionsear";s:4:"HOME";s:22:"/home/appselectionsear";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:11:"REQUEST_URI";s:83:"/backend/web/index.php?r=shortlisting%2Fdefault%2Fsubmit-for-approval&position_id=7";s:12:"QUERY_STRING";s:60:"r=shortlisting%2Fdefault%2Fsubmit-for-approval&position_id=7";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:11:"REMOTE_PORT";s:5:"24620";s:15:"SCRIPT_FILENAME";s:56:"/home/appselectionsear/public_html/backend/web/index.php";s:12:"SERVER_ADMIN";s:32:"webmaster@app.selectionsearch.in";s:21:"CONTEXT_DOCUMENT_ROOT";s:34:"/home/appselectionsear/public_html";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:34:"/home/appselectionsear/public_html";s:11:"REMOTE_ADDR";s:14:"223.181.46.216";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:14:"187.127.143.72";s:11:"SERVER_NAME";s:22:"app.selectionsearch.in";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:12:"HTTP_X_HTTPS";s:1:"1";s:11:"HTTP_COOKIE";s:603:"_fbp=fb.1.1787635091908.1126328022.AQECAQIB; _ga=GA1.1.93808140.1787689161; _ga_BEEKLPPBE9=GS2.1.s1787689160$o1$g0$t1787689166$j54$l0$h0; _identity-backend=1c3925492ab43da9e72a5463e03a3beca485b57016fc236a801abc5eb80efd42a%3A2%3A%7Bi%3A0%3Bs%3A17%3A%22_identity-backend%22%3Bi%3A1%3Bs%3A46%3A%22%5B3%2C%22bAYc81Ko7Q-MawhyuBmaQu915qZxAD1P%22%2C2592000%5D%22%3B%7D; _csrf-backend=0aa269972371ee0901f9cb362e4740cb73a192a0dcc5c9aa23c487f5adbbf901a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22Wl78oRQ-GdEnH0We3yDsKlDqMg8QQ7qx%22%3B%7D; advanced-backend=012744e688ee19d4dc94607ae2930aaf";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:12:"HTTP_REFERER";s:101:"https://app.selectionsearch.in/backend/web/index.php?r=shortlisting%2Fdefault%2Fresults&position_id=7";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:19:"HTTP_SEC_FETCH_USER";s:2:"?1";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:11:"HTTP_ACCEPT";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:15:"HTTP_USER_AGENT";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Windows"";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:14:"HTTP_SEC_CH_UA";s:65:""Not=A?Brand";v="99", "Google Chrome";v="151", "Chromium";v="151"";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:9:"HTTP_HOST";s:22:"app.selectionsearch.in";s:17:"proxy-nokeepalive";s:1:"1";s:11:"SSL_TLS_SNI";s:22:"app.selectionsearch.in";s:5:"HTTPS";s:2:"on";s:18:"HTTP_AUTHORIZATION";s:0:"";s:10:"SCRIPT_URI";s:52:"https://app.selectionsearch.in/backend/web/index.php";s:10:"SCRIPT_URL";s:22:"/backend/web/index.php";s:9:"UNIQUE_ID";s:27:"aqACx2Pl6njbfjgkvpVjNwAAAAo";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1788871367.7641270160675048828125;s:12:"REQUEST_TIME";i:1788871367;s:4:"argv";a:1:{i:0;s:60:"r=shortlisting%2Fdefault%2Fsubmit-for-approval&position_id=7";}s:4:"argc";i:1;s:12:"GROQ_API_KEY";s:56:"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";s:13:"BOLNA_API_KEY";s:23:"your_bolna_api_key_here";s:14:"BOLNA_BASE_URL";s:21:"https://api.bolna.dev";s:14:"GEMINI_API_KEY";s:53:"AQ.Ab8RN6JdMDnm-0Y2A5guHT8RuFxESebi1HMmeipoh4agoUs7jA";s:11:"XAI_API_KEY";s:84:"xai-Nbuw9Qz96Qk68uxVlwq8F9hpwRHvwQJnz00dwc5f0kz3jh401XTQ0P2QavTkzmUx3CrOSfadxJsNf1zs";s:14:"OPENAI_API_KEY";s:164:"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";}s:3:"GET";a:2:{s:1:"r";s:40:"shortlisting/default/submit-for-approval";s:11:"position_id";s:1:"7";}s:4:"POST";a:0:{}s:6:"COOKIE";a:6:{s:4:"_fbp";s:38:"fb.1.1787635091908.1126328022.AQECAQIB";s:3:"_ga";s:25:"GA1.1.93808140.1787689161";s:14:"_ga_BEEKLPPBE9";s:45:"GS2.1.s1787689160$o1$g0$t1787689166$j54$l0$h0";s:17:"_identity-backend";s:157:"1c3925492ab43da9e72a5463e03a3beca485b57016fc236a801abc5eb80efd42a:2:{i:0;s:17:"_identity-backend";i:1;s:46:"[3,"bAYc81Ko7Q-MawhyuBmaQu915qZxAD1P",2592000]";}";s:13:"_csrf-backend";s:139:"0aa269972371ee0901f9cb362e4740cb73a192a0dcc5c9aa23c487f5adbbf901a:2:{i:0;s:13:"_csrf-backend";i:1;s:32:"Wl78oRQ-GdEnH0We3yDsKlDqMg8QQ7qx";}";s:16:"advanced-backend";s:32:"012744e688ee19d4dc94607ae2930aaf";}s:5:"FILES";a:0:{}s:7:"SESSION";a:4:{s:7:"__flash";a:1:{s:7:"success";i:-1;}s:4:"__id";i:3;s:9:"__authKey";s:32:"bAYc81Ko7Q-MawhyuBmaQu915qZxAD1P";s:7:"success";s:42:"Shortlist submitted for management review.";}}";s:4:"user";s:1631:"a:5:{s:2:"id";i:3;s:8:"identity";a:14:{s:2:"id";s:1:"3";s:8:"username";s:13:"'consultant1'";s:4:"role";s:7:"'admin'";s:9:"full_name";s:7:"'Swati'";s:5:"phone";s:12:"'8003283484'";s:9:"is_active";s:1:"1";s:8:"auth_key";s:34:"'bAYc81Ko7Q-MawhyuBmaQu915qZxAD1P'";s:13:"password_hash";s:62:"'$2y$13$3K5Sz9BlDQoX.hba0vz76OMeLn6A655SmqE9SyO4sPRlf2OIXunV2'";s:20:"password_reset_token";s:4:"null";s:5:"email";s:26:"'swati@selectionsearch.in'";s:6:"status";s:2:"10";s:10:"created_at";s:10:"1785128751";s:10:"updated_at";s:10:"1788345110";s:18:"verification_token";s:4:"null";}s:10:"attributes";a:14:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"ID";}i:1;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:8:"Username";}i:2;a:2:{s:9:"attribute";s:4:"role";s:5:"label";s:4:"Role";}i:3;a:2:{s:9:"attribute";s:9:"full_name";s:5:"label";s:9:"Full Name";}i:4;a:2:{s:9:"attribute";s:5:"phone";s:5:"label";s:5:"Phone";}i:5;a:2:{s:9:"attribute";s:9:"is_active";s:5:"label";s:6:"Active";}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:"password_hash";s:5:"label";s:13:"Password Hash";}i:8;a:2:{s:9:"attribute";s:20:"password_reset_token";s:5:"label";s:20:"Password Reset Token";}i:9;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:10;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:6:"Status";}i:11;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:7:"Created";}i:12;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:7:"Updated";}i:13;a:2:{s:9:"attribute";s:18:"verification_token";s:5:"label";s:18:"Verification Token";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6aa002c7c0bc2";s:3:"url";s:113:"https://app.selectionsearch.in/backend/web/index.php?r=shortlisting%2Fdefault%2Fsubmit-for-approval&position_id=7";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:14:"223.181.46.216";s:4:"time";d:1788871367.7641270160675048828125;s:10:"statusCode";i:302;s:8:"sqlCount";i:40;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:1;s:9:"mailFiles";a:1:{i:0;s:29:"20260908-181253-9687-0723.eml";}s:10:"peakMemory";i:10334216;s:14:"processingTime";d:6.20608806610107421875;}s:10:"exceptions";a:0:{}}