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:18530:"a:1:{s:8:"messages";a:38:{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:1788871702.933350086212158203125;i:4;a:0:{}i:5;i:3291952;}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:1788871702.93352794647216796875;i:4;a:0:{}i:5;i:3316816;}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:1788871702.937107086181640625;i:4;a:0:{}i:5;i:3947376;}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:1788871702.937119960784912109375;i:4;a:0:{}i:5;i:3948016;}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:1788871702.9402179718017578125;i:4;a:0:{}i:5;i:4741776;}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:1788871702.9469959735870361328125;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:6077264;}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:1788871702.9470450878143310546875;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:6079384;}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:1788871702.9489400386810302734375;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:6139168;}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:1788871702.9495079517364501953125;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:6158960;}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:1788871702.951323986053466796875;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:6603088;}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:1788871702.9545829296112060546875;i:4;a:0:{}i:5;i:7305280;}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:1788871702.9552209377288818359375;i:4;a:0:{}i:5;i:7420808;}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:1788871702.9553430080413818359375;i:4;a:0:{}i:5;i:7510776;}i:24;a:6:{i:0;s:43:"Route requested: 'shortlisting/default/run'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1788871702.955377101898193359375;i:4;a:0:{}i:5;i:7510336;}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:1788871702.9553821086883544921875;i:4;a:0:{}i:5;i:7511816;}i:26;a:6:{i:0;s:38:"Route to run: shortlisting/default/run";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1788871702.956584930419921875;i:4;a:0:{}i:5;i:8008968;}i:27;a:6:{i:0;s:87:"Running action: backend\modules\shortlisting\controllers\DefaultController::actionRun()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1788871702.957705020904541015625;i:4;a:0:{}i:5;i:8230912;}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:1788871702.957848072052001953125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8280440;}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:1788871702.9588329792022705078125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8306320;}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:1788871702.95915699005126953125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8301680;}i:37;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.95957088470458984375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8304016;}i:40;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9601490497589111328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:69;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:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8361824;}i:43;a:6:{i:0;s:152:"SELECT * FROM `shortlisting_criteria` WHERE ((`position_id` IS NULL) AND (`is_active`=1)) AND (`role_type` IN ('teaching', 'all')) ORDER BY `sort_order`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9608380794525146484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:79;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8486968;}i:46;a:6:{i:0;s:106:"SELECT * FROM `shortlisting_criteria` WHERE (`position_id`='19') AND (`is_active`=1) ORDER BY `sort_order`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9618299007415771484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8490664;}i:49;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlisting_criteria`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9624729156494140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8506384;}i:52;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlisting_criteria`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9633300304412841796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8521848;}i:55;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` = 'shortlisting_criteria' AND `kcu`.`TABLE_NAME` = 'shortlisting_criteria'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.96358489990234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8521776;}i:58;a:6:{i:0;s:142:"SELECT `candidates`.* FROM `candidates` INNER JOIN `candidate_positions` `cp` ON cp.candidate_id = candidates.id WHERE `cp`.`position_id`='19'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.964684009552001953125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8585096;}i:61;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:1788871702.967256069183349609375;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8807664;}i:64;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:1788871702.9678289890289306640625;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8829728;}i:67;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:1788871702.96808910369873046875;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8826328;}i:70;a:6:{i:0;s:73:"SELECT `candidate_id` FROM `candidate_positions` WHERE `position_id`='19'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9692471027374267578125;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:82;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9005592;}i:73;a:6:{i:0;s:284:"SELECT COUNT(*) FROM `candidates` WHERE (NOT (`parsed_json` IS NULL)) AND (`id` NOT IN (25706, 25780, 25781, 25782, 25783, 25784, 25785, 25786, 25787, 25788, 25789, 25790, 25791, 25864, 25865, 25977, 26006, 26007, 26008, 26009, 26025, 26184, 26185, 26186, 26187, 26188, 26189, 26190))";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.969789981842041015625;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:91;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9025648;}i:76;a:6:{i:0;s:66:"SELECT * FROM `candidate_position_scores` WHERE `position_id`='19'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788871704.5050029754638671875;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:97;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9045136;}i:79;a:6:{i:0;s:106:"Rendering view file: /home/appselectionsear/public_html/backend/modules/shortlisting/views/default/run.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1788871704.50621891021728515625;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:99;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9174816;}i:80;a:6:{i:0;s:86:"Rendering view file: /home/appselectionsear/public_html/backend/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1788871704.5078680515289306640625;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:99;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9549184;}i:81;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:1788871704.5081870555877685546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:65:"/home/appselectionsear/public_html/backend/views/layouts/main.php";s:4:"line";i:363;s:8:"function";s:7:"endBody";s:5:"class";s:12:"yii\web\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:99;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9667528;}i:82;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:1788871704.508491039276123046875;i:4;a:0:{}i:5;i:9575208;}}}";s:9:"profiling";s:29285:"a:3:{s:6:"memory";i:9825640;s:4:"time";d:1.58078098297119140625;s:8:"messages";a:44:{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:1788871702.94705295562744140625;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:6080192;}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:1788871702.94822788238525390625;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:6123488;}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:1788871702.948257923126220703125;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:6123432;}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:1788871702.94890308380126953125;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:6137880;}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:1788871702.9489519596099853515625;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:6140080;}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:1788871702.9491059780120849609375;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:6142272;}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:1788871702.9495260715484619140625;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:6160000;}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:1788871702.9498341083526611328125;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:6161856;}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:1788871702.9513380527496337890625;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:6603472;}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:1788871702.9515469074249267578125;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:6606040;}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:1788871702.95786190032958984375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8281728;}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:1788871702.958797931671142578125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8304656;}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:1788871702.9588449001312255859375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8307608;}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:1788871702.959011077880859375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8311432;}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:1788871702.959167957305908203125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8303096;}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:1788871702.9594860076904296875;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305328;}i:38;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.959579944610595703125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305520;}i:39;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.959744930267333984375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8313816;}i:41;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.960156917572021484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:69;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:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8363328;}i:42;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9603049755096435546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:69;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:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8371072;}i:44;a:6:{i:0;s:152:"SELECT * FROM `shortlisting_criteria` WHERE ((`position_id` IS NULL) AND (`is_active`=1)) AND (`role_type` IN ('teaching', 'all')) ORDER BY `sort_order`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9608519077301025390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:79;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8488264;}i:45;a:6:{i:0;s:152:"SELECT * FROM `shortlisting_criteria` WHERE ((`position_id` IS NULL) AND (`is_active`=1)) AND (`role_type` IN ('teaching', 'all')) ORDER BY `sort_order`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9617569446563720703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:79;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8490016;}i:47;a:6:{i:0;s:106:"SELECT * FROM `shortlisting_criteria` WHERE (`position_id`='19') AND (`is_active`=1) ORDER BY `sort_order`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9618389606475830078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8492064;}i:48;a:6:{i:0;s:106:"SELECT * FROM `shortlisting_criteria` WHERE (`position_id`='19') AND (`is_active`=1) ORDER BY `sort_order`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.96240711212158203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8497872;}i:50;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlisting_criteria`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.962482929229736328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8507672;}i:51;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlisting_criteria`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9632298946380615234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8520160;}i:53;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlisting_criteria`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9633500576019287109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8523136;}i:54;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlisting_criteria`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.963471889495849609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8525688;}i:56;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` = 'shortlisting_criteria' AND `kcu`.`TABLE_NAME` = 'shortlisting_criteria'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.963593959808349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8523192;}i:57;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` = 'shortlisting_criteria' AND `kcu`.`TABLE_NAME` = 'shortlisting_criteria'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.96382808685302734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8525424;}i:59;a:6:{i:0;s:142:"SELECT `candidates`.* FROM `candidates` INNER JOIN `candidate_positions` `cp` ON cp.candidate_id = candidates.id WHERE `cp`.`position_id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9646980762481689453125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8586224;}i:60;a:6:{i:0;s:142:"SELECT `candidates`.* FROM `candidates` INNER JOIN `candidate_positions` `cp` ON cp.candidate_id = candidates.id WHERE `cp`.`position_id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9670779705047607421875;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8799624;}i:62;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:1788871702.967278003692626953125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8808576;}i:63;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:1788871702.9677879810333251953125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8828440;}i:65;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:1788871702.96784210205078125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8831920;}i:66;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:1788871702.9679539203643798828125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8834728;}i:68;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:1788871702.9680969715118408203125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8827368;}i:69;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:1788871702.9683248996734619140625;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8829224;}i:71;a:6:{i:0;s:73:"SELECT `candidate_id` FROM `candidate_positions` WHERE `position_id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.969255924224853515625;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:82;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9006720;}i:72;a:6:{i:0;s:73:"SELECT `candidate_id` FROM `candidate_positions` WHERE `position_id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.969480037689208984375;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:82;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9008360;}i:74;a:6:{i:0;s:284:"SELECT COUNT(*) FROM `candidates` WHERE (NOT (`parsed_json` IS NULL)) AND (`id` NOT IN (25706, 25780, 25781, 25782, 25783, 25784, 25785, 25786, 25787, 25788, 25789, 25790, 25791, 25864, 25865, 25977, 26006, 26007, 26008, 26009, 26025, 26184, 26185, 26186, 26187, 26188, 26189, 26190))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9698069095611572265625;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:91;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9023648;}i:75;a:6:{i:0;s:284:"SELECT COUNT(*) FROM `candidates` WHERE (NOT (`parsed_json` IS NULL)) AND (`id` NOT IN (25706, 25780, 25781, 25782, 25783, 25784, 25785, 25786, 25787, 25788, 25789, 25790, 25791, 25864, 25865, 25977, 26006, 26007, 26008, 26009, 26025, 26184, 26185, 26186, 26187, 26188, 26189, 26190))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871704.504560947418212890625;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:91;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9024968;}i:77;a:6:{i:0;s:66:"SELECT * FROM `candidate_position_scores` WHERE `position_id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871704.5050289630889892578125;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:97;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9046264;}i:78;a:6:{i:0;s:66:"SELECT * FROM `candidate_position_scores` WHERE `position_id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871704.505374908447265625;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:97;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9047648;}}}";s:2:"db";s:28438:"a:1:{s:8:"messages";a:42:{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:1788871702.948257923126220703125;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:6123432;}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:1788871702.94890308380126953125;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:6137880;}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:1788871702.9489519596099853515625;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:6140080;}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:1788871702.9491059780120849609375;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:6142272;}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:1788871702.9495260715484619140625;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:6160000;}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:1788871702.9498341083526611328125;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:6161856;}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:1788871702.9513380527496337890625;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:6603472;}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:1788871702.9515469074249267578125;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:6606040;}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:1788871702.95786190032958984375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8281728;}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:1788871702.958797931671142578125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8304656;}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:1788871702.9588449001312255859375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8307608;}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:1788871702.959011077880859375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8311432;}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:1788871702.959167957305908203125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8303096;}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:1788871702.9594860076904296875;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305328;}i:38;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.959579944610595703125;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8305520;}i:39;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.959744930267333984375;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:67;s:8:"function";s:12:"findPosition";s:5:"class";s:58:"backend\modules\shortlisting\controllers\DefaultController";s:4:"type";s:2:"->";}}i:5;i:8313816;}i:41;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.960156917572021484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:69;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:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8363328;}i:42;a:6:{i:0;s:41:"SELECT * FROM `positions` WHERE `id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9603049755096435546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:69;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:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8371072;}i:44;a:6:{i:0;s:152:"SELECT * FROM `shortlisting_criteria` WHERE ((`position_id` IS NULL) AND (`is_active`=1)) AND (`role_type` IN ('teaching', 'all')) ORDER BY `sort_order`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9608519077301025390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:79;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8488264;}i:45;a:6:{i:0;s:152:"SELECT * FROM `shortlisting_criteria` WHERE ((`position_id` IS NULL) AND (`is_active`=1)) AND (`role_type` IN ('teaching', 'all')) ORDER BY `sort_order`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9617569446563720703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:79;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8490016;}i:47;a:6:{i:0;s:106:"SELECT * FROM `shortlisting_criteria` WHERE (`position_id`='19') AND (`is_active`=1) ORDER BY `sort_order`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9618389606475830078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8492064;}i:48;a:6:{i:0;s:106:"SELECT * FROM `shortlisting_criteria` WHERE (`position_id`='19') AND (`is_active`=1) ORDER BY `sort_order`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.96240711212158203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8497872;}i:50;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlisting_criteria`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.962482929229736328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8507672;}i:51;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `shortlisting_criteria`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9632298946380615234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8520160;}i:53;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlisting_criteria`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9633500576019287109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8523136;}i:54;a:6:{i:0;s:41:"SHOW CREATE TABLE `shortlisting_criteria`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.963471889495849609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8525688;}i:56;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` = 'shortlisting_criteria' AND `kcu`.`TABLE_NAME` = 'shortlisting_criteria'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.963593959808349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8523192;}i:57;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` = 'shortlisting_criteria' AND `kcu`.`TABLE_NAME` = 'shortlisting_criteria'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.96382808685302734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/home/appselectionsear/public_html/common/models/ShortlistingCriteria.php";s:4:"line";i:86;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/appselectionsear/public_html/backend/modules/shortlisting/controllers/DefaultController.php";s:4:"line";i:70;s:8:"function";s:22:"getCriteriaForPosition";s:5:"class";s:34:"common\models\ShortlistingCriteria";s:4:"type";s:2:"::";}}i:5;i:8525424;}i:59;a:6:{i:0;s:142:"SELECT `candidates`.* FROM `candidates` INNER JOIN `candidate_positions` `cp` ON cp.candidate_id = candidates.id WHERE `cp`.`position_id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9646980762481689453125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8586224;}i:60;a:6:{i:0;s:142:"SELECT `candidates`.* FROM `candidates` INNER JOIN `candidate_positions` `cp` ON cp.candidate_id = candidates.id WHERE `cp`.`position_id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9670779705047607421875;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8799624;}i:62;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:1788871702.967278003692626953125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8808576;}i:63;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:1788871702.9677879810333251953125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8828440;}i:65;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:1788871702.96784210205078125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8831920;}i:66;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:1788871702.9679539203643798828125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8834728;}i:68;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:1788871702.9680969715118408203125;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8827368;}i:69;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:1788871702.9683248996734619140625;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:76;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8829224;}i:71;a:6:{i:0;s:73:"SELECT `candidate_id` FROM `candidate_positions` WHERE `position_id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.969255924224853515625;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:82;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9006720;}i:72;a:6:{i:0;s:73:"SELECT `candidate_id` FROM `candidate_positions` WHERE `position_id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.969480037689208984375;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:82;s:8:"function";s:6:"column";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9008360;}i:74;a:6:{i:0;s:284:"SELECT COUNT(*) FROM `candidates` WHERE (NOT (`parsed_json` IS NULL)) AND (`id` NOT IN (25706, 25780, 25781, 25782, 25783, 25784, 25785, 25786, 25787, 25788, 25789, 25790, 25791, 25864, 25865, 25977, 26006, 26007, 26008, 26009, 26025, 26184, 26185, 26186, 26187, 26188, 26189, 26190))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871702.9698069095611572265625;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:91;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9023648;}i:75;a:6:{i:0;s:284:"SELECT COUNT(*) FROM `candidates` WHERE (NOT (`parsed_json` IS NULL)) AND (`id` NOT IN (25706, 25780, 25781, 25782, 25783, 25784, 25785, 25786, 25787, 25788, 25789, 25790, 25791, 25864, 25865, 25977, 26006, 26007, 26008, 26009, 26025, 26184, 26185, 26186, 26187, 26188, 26189, 26190))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871704.504560947418212890625;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:91;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9024968;}i:77;a:6:{i:0;s:66:"SELECT * FROM `candidate_position_scores` WHERE `position_id`='19'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788871704.5050289630889892578125;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:97;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9046264;}i:78;a:6:{i:0;s:66:"SELECT * FROM `candidate_position_scores` WHERE `position_id`='19'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788871704.505374908447265625;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:97;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9047648;}}}";s:5:"event";s:18988:"a:100:{i:0;a:5:{s:4:"time";d:1788871702.9440319538116455078125;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:1788871702.948223114013671875;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:1788871702.951694011688232421875;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:1788871702.9517180919647216796875;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:1788871702.95351696014404296875;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:1788871702.9553630352020263671875;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:1788871702.9566218852996826171875;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:1788871702.95662689208984375;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:1788871702.9576900005340576171875;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:1788871702.9578230381011962890625;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:1788871702.9599330425262451171875;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:1788871702.9599590301513671875;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:1788871702.960113048553466796875;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:1788871702.9603230953216552734375;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:14;a:5:{s:4:"time";d:1788871702.960338115692138671875;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:15;a:5:{s:4:"time";d:1788871702.9603459835052490234375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:16;a:5:{s:4:"time";d:1788871702.961781978607177734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:17;a:5:{s:4:"time";d:1788871702.9624431133270263671875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:18;a:5:{s:4:"time";d:1788871702.9639151096343994140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:19;a:5:{s:4:"time";d:1788871702.9639379978179931640625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:20;a:5:{s:4:"time";d:1788871702.96395206451416015625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:21;a:5:{s:4:"time";d:1788871702.963963031768798828125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:22;a:5:{s:4:"time";d:1788871702.963964939117431640625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:23;a:5:{s:4:"time";d:1788871702.9639670848846435546875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:24;a:5:{s:4:"time";d:1788871702.9639799594879150390625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"common\models\ShortlistingCriteria";}i:25;a:5:{s:4:"time";d:1788871702.9644410610198974609375;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:26;a:5:{s:4:"time";d:1788871702.9672000408172607421875;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:27;a:5:{s:4:"time";d:1788871702.9683969020843505859375;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:28;a:5:{s:4:"time";d:1788871702.9684200286865234375;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:29;a:5:{s:4:"time";d:1788871702.9684369564056396484375;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:30;a:5:{s:4:"time";d:1788871702.96848392486572265625;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:31;a:5:{s:4:"time";d:1788871702.968513965606689453125;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:32;a:5:{s:4:"time";d:1788871702.9685308933258056640625;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:33;a:5:{s:4:"time";d:1788871702.968552112579345703125;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:34;a:5:{s:4:"time";d:1788871702.9685699939727783203125;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:35;a:5:{s:4:"time";d:1788871702.96858501434326171875;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:36;a:5:{s:4:"time";d:1788871702.968595981597900390625;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:37;a:5:{s:4:"time";d:1788871702.9686100482940673828125;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:38;a:5:{s:4:"time";d:1788871702.9686400890350341796875;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:39;a:5:{s:4:"time";d:1788871702.9686739444732666015625;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:40;a:5:{s:4:"time";d:1788871702.9686939716339111328125;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:41;a:5:{s:4:"time";d:1788871702.9687130451202392578125;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:42;a:5:{s:4:"time";d:1788871702.9687290191650390625;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:43;a:5:{s:4:"time";d:1788871702.9687459468841552734375;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:44;a:5:{s:4:"time";d:1788871702.968760013580322265625;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:45;a:5:{s:4:"time";d:1788871702.9687740802764892578125;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:46;a:5:{s:4:"time";d:1788871702.9687900543212890625;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:47;a:5:{s:4:"time";d:1788871702.968801975250244140625;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:48;a:5:{s:4:"time";d:1788871702.9688150882720947265625;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:49;a:5:{s:4:"time";d:1788871702.968830108642578125;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:50;a:5:{s:4:"time";d:1788871702.96887111663818359375;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:51;a:5:{s:4:"time";d:1788871702.96889400482177734375;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:52;a:5:{s:4:"time";d:1788871702.9689071178436279296875;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:53;a:5:{s:4:"time";d:1788871702.9689199924468994140625;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:54;a:5:{s:4:"time";d:1788871702.96895599365234375;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:55;a:5:{s:4:"time";d:1788871702.9689579010009765625;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:56;a:5:{s:4:"time";d:1788871702.9689590930938720703125;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:57;a:5:{s:4:"time";d:1788871702.9689600467681884765625;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:58;a:5:{s:4:"time";d:1788871702.9689610004425048828125;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:59;a:5:{s:4:"time";d:1788871702.9689619541168212890625;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:60;a:5:{s:4:"time";d:1788871702.9689629077911376953125;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:61;a:5:{s:4:"time";d:1788871702.968965053558349609375;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:62;a:5:{s:4:"time";d:1788871702.968966007232666015625;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:63;a:5:{s:4:"time";d:1788871702.968966960906982421875;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:64;a:5:{s:4:"time";d:1788871702.9689691066741943359375;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:65;a:5:{s:4:"time";d:1788871702.968986988067626953125;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:66;a:5:{s:4:"time";d:1788871702.968987941741943359375;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:67;a:5:{s:4:"time";d:1788871702.968988895416259765625;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:68;a:5:{s:4:"time";d:1788871702.9689900875091552734375;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:69;a:5:{s:4:"time";d:1788871702.9689910411834716796875;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:70;a:5:{s:4:"time";d:1788871702.9689919948577880859375;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:71;a:5:{s:4:"time";d:1788871702.9689939022064208984375;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:72;a:5:{s:4:"time";d:1788871702.96899509429931640625;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:73;a:5:{s:4:"time";d:1788871702.9689960479736328125;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:74;a:5:{s:4:"time";d:1788871702.96899700164794921875;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:75;a:5:{s:4:"time";d:1788871702.968997955322265625;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:76;a:5:{s:4:"time";d:1788871702.96899890899658203125;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:77;a:5:{s:4:"time";d:1788871702.9690001010894775390625;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:78;a:5:{s:4:"time";d:1788871702.9690020084381103515625;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:79;a:5:{s:4:"time";d:1788871702.9690029621124267578125;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:80;a:5:{s:4:"time";d:1788871702.9690039157867431640625;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:81;a:5:{s:4:"time";d:1788871702.969005107879638671875;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:82;a:5:{s:4:"time";d:1788871702.969172000885009765625;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:83;a:5:{s:4:"time";d:1788871702.9695069789886474609375;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:84;a:5:{s:4:"time";d:1788871704.504889011383056640625;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:85;a:5:{s:4:"time";d:1788871704.5062139034271240234375;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:86;a:5:{s:4:"time";d:1788871704.507843017578125;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:87;a:5:{s:4:"time";d:1788871704.50786590576171875;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:88;a:5:{s:4:"time";d:1788871704.5080139636993408203125;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:89;a:5:{s:4:"time";d:1788871704.5080230236053466796875;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:90;a:5:{s:4:"time";d:1788871704.5081999301910400390625;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:91;a:5:{s:4:"time";d:1788871704.508204936981201171875;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:92;a:5:{s:4:"time";d:1788871704.5082991123199462890625;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:93;a:5:{s:4:"time";d:1788871704.5083229541778564453125;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:94;a:5:{s:4:"time";d:1788871704.5083301067352294921875;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:95;a:5:{s:4:"time";d:1788871704.5083339214324951171875;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:96;a:5:{s:4:"time";d:1788871704.5083410739898681640625;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:97;a:5:{s:4:"time";d:1788871704.508347034454345703125;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:98;a:5:{s:4:"time";d:1788871704.50850009918212890625;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:99;a:5:{s:4:"time";d:1788871704.5086228847503662109375;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:123:"a:3:{s:5:"start";d:1788871702.9289410114288330078125;s:3:"end";d:1788871704.5098869800567626953125;s:6:"memory";i:9825640;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:356:"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:1788871702.95536899566650390625;i:4;a:0:{}i:5;i:7510416;}}s:5:"route";s:24:"shortlisting/default/run";s:6:"action";s:71:"backend\modules\shortlisting\controllers\DefaultController::actionRun()";}";s:7:"request";s:7474:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;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:85:"https://app.selectionsearch.in/backend/web/index.php?r=shortlisting%2Fdefault%2Findex";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:5:{s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s: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:48:22 GMT; Max-Age=2591998; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:24:"shortlisting/default/run";s:6:"action";s:71:"backend\modules\shortlisting\controllers\DefaultController::actionRun()";s:12:"actionParams";a:1:{s:11:"position_id";s:2:"19";}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:68:"/backend/web/index.php?r=shortlisting%2Fdefault%2Frun&position_id=19";s:12:"QUERY_STRING";s:45:"r=shortlisting%2Fdefault%2Frun&position_id=19";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:"21115";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:85:"https://app.selectionsearch.in/backend/web/index.php?r=shortlisting%2Fdefault%2Findex";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:"aqAEFuP03T7hNVyzlWxWLwAAAAI";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1788871702.9199359416961669921875;s:12:"REQUEST_TIME";i:1788871702;s:4:"argv";a:1:{i:0;s:45:"r=shortlisting%2Fdefault%2Frun&position_id=19";}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:24:"shortlisting/default/run";s:11:"position_id";s:2:"19";}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:3:{s:7:"__flash";a:0:{}s:4:"__id";i:3;s:9:"__authKey";s:32:"bAYc81Ko7Q-MawhyuBmaQu915qZxAD1P";}}";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:"6aa00416e91da";s:3:"url";s:98:"https://app.selectionsearch.in/backend/web/index.php?r=shortlisting%2Fdefault%2Frun&position_id=19";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:14:"223.181.46.216";s:4:"time";d:1788871702.9199359416961669921875;s:10:"statusCode";i:200;s:8:"sqlCount";i:21;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:9825640;s:14:"processingTime";d:1.58078098297119140625;}s:10:"exceptions";a:0:{}}