a:12:{s:6:"config";s:3488:"a:5:{s:10:"phpVersion";s:6:"5.4.42";s:10:"yiiVersion";s:8:"2.0.15.1";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.15.1";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:2:"th";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:"5.4.42";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:14:{s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:7:"2.0.8.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:60:"/var/www/html/laborproject/vendor/yiisoft/yii2-bootstrap/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:50:"/var/www/html/laborproject/vendor/yiisoft/yii2-gii";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.1.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:62:"/var/www/html/laborproject/vendor/yiisoft/yii2-swiftmailer/src";}}s:24:"yiisoft/yii2-codeception";a:3:{s:4:"name";s:24:"yiisoft/yii2-codeception";s:7:"version";s:7:"2.0.6.0";s:5:"alias";a:1:{s:16:"@yii/codeception";s:58:"/var/www/html/laborproject/vendor/yiisoft/yii2-codeception";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.0.12.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:52:"/var/www/html/laborproject/vendor/yiisoft/yii2-debug";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:52:"/var/www/html/laborproject/vendor/yiisoft/yii2-faker";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"1.8.9.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:59:"/var/www/html/laborproject/vendor/kartik-v/yii2-krajee-base";}}s:28:"kartik-v/yii2-widget-depdrop";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-depdrop";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:15:"@kartik/depdrop";s:62:"/var/www/html/laborproject/vendor/kartik-v/yii2-widget-depdrop";}}s:23:"yiisoft/yii2-httpclient";a:3:{s:4:"name";s:23:"yiisoft/yii2-httpclient";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:15:"@yii/httpclient";s:57:"/var/www/html/laborproject/vendor/yiisoft/yii2-httpclient";}}s:23:"yiisoft/yii2-authclient";a:3:{s:4:"name";s:23:"yiisoft/yii2-authclient";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:15:"@yii/authclient";s:57:"/var/www/html/laborproject/vendor/yiisoft/yii2-authclient";}}s:18:"dektrium/yii2-user";a:4:{s:4:"name";s:18:"dektrium/yii2-user";s:7:"version";s:8:"0.9.12.0";s:5:"alias";a:1:{s:14:"@dektrium/user";s:52:"/var/www/html/laborproject/vendor/dektrium/yii2-user";}s:9:"bootstrap";s:23:"dektrium\user\Bootstrap";}s:31:"kartik-v/yii2-widget-activeform";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-activeform";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:12:"@kartik/form";s:65:"/var/www/html/laborproject/vendor/kartik-v/yii2-widget-activeform";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:15:"@kartik/select2";s:62:"/var/www/html/laborproject/vendor/kartik-v/yii2-widget-select2";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:12:"@kartik/date";s:65:"/var/www/html/laborproject/vendor/kartik-v/yii2-widget-datepicker";}}}}";s:7:"request";s:3468:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:9:{s:4:"host";s:12:"172.17.250.9";s:10:"connection";s:10:"keep-alive";s:25:"upgrade-insecure-requests";s:1:"1";s:10:"user-agent";s:113:"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36";s:6:"accept";s:85:"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8";s:7:"referer";s:70:"http://172.17.250.9/laborproject/index.php?r=user%2Fsettings%2Faccount";s:15:"accept-encoding";s:13:"gzip, deflate";s:15:"accept-language";s:14:"th-TH,th;q=0.9";s:6:"cookie";s:210:"PHPSESSID=psl2hh6ujg0q3uk4cbbtelegu7; _csrf=7eb7b357eccfdd7eccc03fb375e0b7de133ed4cda0c944a3b60133ee0393d319a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22bmayP1oQkW0-d5F4VE2ONaIXtyZJ_7-i%22%3B%7D";}s:15:"responseHeaders";a:5:{s:12:"X-Powered-By";s:10:"PHP/5.4.42";s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:62:"no-store, no-cache, must-revalidate, post-check=0, pre-check=0";s:6:"Pragma";s:8:"no-cache";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";}s:5:"route";s:10:"site/index";s:6:"action";s:45:"app\controllers\SiteController::actionIndex()";s:12:"actionParams";a:1:{i:0;N;}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:0;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:29:{s:9:"HTTP_HOST";s:12:"172.17.250.9";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:15:"HTTP_USER_AGENT";s:113:"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36";s:11:"HTTP_ACCEPT";s:85:"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8";s:12:"HTTP_REFERER";s:70:"http://172.17.250.9/laborproject/index.php?r=user%2Fsettings%2Faccount";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"th-TH,th;q=0.9";s:11:"HTTP_COOKIE";s:210:"PHPSESSID=psl2hh6ujg0q3uk4cbbtelegu7; _csrf=7eb7b357eccfdd7eccc03fb375e0b7de133ed4cda0c944a3b60133ee0393d319a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22bmayP1oQkW0-d5F4VE2ONaIXtyZJ_7-i%22%3B%7D";s:4:"PATH";s:29:"/sbin:/usr/sbin:/bin:/usr/bin";s:16:"SERVER_SIGNATURE";s:73:"
Apache/2.2.15 (CentOS) Server at 172.17.250.9 Port 80
";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.2.15 (CentOS)";s:11:"SERVER_NAME";s:12:"172.17.250.9";s:11:"SERVER_ADDR";s:12:"172.17.250.9";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:11:"172.17.3.25";s:13:"DOCUMENT_ROOT";s:13:"/var/www/html";s:12:"SERVER_ADMIN";s:14:"root@localhost";s:15:"SCRIPT_FILENAME";s:36:"/var/www/html/laborproject/index.php";s:11:"REMOTE_PORT";s:5:"64716";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:23:"/laborproject/index.php";s:11:"SCRIPT_NAME";s:23:"/laborproject/index.php";s:8:"PHP_SELF";s:23:"/laborproject/index.php";s:18:"REQUEST_TIME_FLOAT";d:1533545581.2049999;s:12:"REQUEST_TIME";i:1533545581;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:2:{s:9:"PHPSESSID";s:26:"psl2hh6ujg0q3uk4cbbtelegu7";s:5:"_csrf";s:130:"7eb7b357eccfdd7eccc03fb375e0b7de133ed4cda0c944a3b60133ee0393d319a:2:{i:0;s:5:"_csrf";i:1;s:32:"bmayP1oQkW0-d5F4VE2ONaIXtyZJ_7-i";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:2:{s:7:"__flash";a:0:{}s:4:"__id";i:1;}}";s:3:"log";s:18335:"a:1:{s:8:"messages";a:32:{i:0;a:6:{i:0;s:51:"Bootstrap with dektrium\user\Bootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1533545581.218194;i:4;a:0:{}i:5;i:1967360;}i:1;a:6:{i:0;s:20:"Loading module: user";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1533545581.2182109;i:4;a:0:{}i:5;i:1970192;}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:1533545581.2358339;i:4;a:0:{}i:5;i:4333456;}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:1533545581.2358749;i:4;a:0:{}i:5;i:4336024;}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:1533545581.246737;i:4;a:0:{}i:5;i:5719200;}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:1533545581.252002;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6385440;}i:6;a:6:{i:0;s:61:"Opening DB connection: mysql:host=192.168.0.10;dbname=labordb";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1533545581.2521269;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6393760;}i:11;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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:1533545581.257647;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6469248;}i:14;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.262506;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6873808;}i:17;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:1533545581.2693231;i:4;a:0:{}i:5;i:7480480;}i:18;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1533545581.2699089;i:4;a:0:{}i:5;i:7538368;}i:19;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:1533545581.2703171;i:4;a:0:{}i:5;i:7591656;}i:21;a:6:{i:0;s:19:"Route requested: ''";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1533545581.2719021;i:4;a:0:{}i:5;i:7778000;}i:22;a:6:{i:0;s:24:"Route to run: site/index";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1533545581.2737091;i:4;a:0:{}i:5;i:8007416;}i:23;a:6:{i:0;s:61:"Running action: app\controllers\SiteController::actionIndex()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1533545581.274236;i:4;a:0:{}i:5;i:8048288;}i:24;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2746999;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8121488;}i:27;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `labortype`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.275507;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8144208;}i:30;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'labortype' AND kcu.table_name = 'labortype'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2774479;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8159104;}i:33;a:6:{i:0;s:68:"Rendering view file: /var/www/html/laborproject/views/site/index.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1533545581.280045;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8326816;}i:34;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.280709;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:19;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:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8390768;}i:37;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2817631;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8411064;}i:40;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.283093;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8427704;}i:43;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2841949;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8444168;}i:46;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.28529;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:28;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8459168;}i:49;a:6:{i:0;s:584:"SELECT Q1.month_th,IFNULL(Q2.TOTAL,0) AS TOTAL FROM ( SELECT m.id,m.month_th,m.orders FROM `month` m ) Q1 LEFT JOIN ( SELECT SUBSTR(p.create_date,'6','2') AS m,COUNT(*) TOTAL FROM register p WHERE p.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY SUBSTR(p.create_date,'6','2') ) Q2 ON Q1.id = Q2.m ORDER BY Q1.orders ASC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2860751;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:87;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:24;s:8:"function";s:17:"CountProjectMonth";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8467472;}i:52;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2878771;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8545736;}i:55;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.288986;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8562072;}i:58;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.290067;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8578480;}i:61;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.291028;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:87;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8593128;}i:64;a:6:{i:0;s:70:"Rendering view file: /var/www/html/laborproject/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1533545581.2928431;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8668752;}i:65;a:6:{i:0;s:100:"Access to debugger is denied due to IP address restriction. The requesting IP address is 172.17.3.25";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1533545581.3023479;i:4;a:2:{i:0;a:5:{s:4:"file";s:49:"/var/www/html/laborproject/views/layouts/main.php";s:4:"line";i:266;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:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9705072;}i:66;a:6:{i:0;s:100:"Access to debugger is denied due to IP address restriction. The requesting IP address is 172.17.3.25";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1533545581.3032849;i:4;a:0:{}i:5;i:9648072;}}}";s:9:"profiling";s:30272:"a:3:{s:6:"memory";i:9816832;s:4:"time";d:0.098009109497070312;s:8:"messages";a:34:{i:7;a:6:{i:0;s:61:"Opening DB connection: mysql:host=192.168.0.10;dbname=labordb";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1533545581.252203;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6396288;}i:8;a:6:{i:0;s:61:"Opening DB connection: mysql:host=192.168.0.10;dbname=labordb";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1533545581.2542181;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6400432;}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:1533545581.254384;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6398768;}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:1533545581.2562571;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6429712;}i:12;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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:1533545581.2577469;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6472120;}i:13;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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:1533545581.2585969;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6475072;}i:15;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2626519;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6875544;}i:16;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.263413;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6882000;}i:25;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2747669;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8123536;}i:26;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.275388;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8129640;}i:28;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2755721;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8146272;}i:29;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2771161;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8157496;}i:31;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'labortype' AND kcu.table_name = 'labortype'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2775099;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8162088;}i:32;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'labortype' AND kcu.table_name = 'labortype'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2783329;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8165032;}i:35;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2807741;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:19;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:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8395184;}i:36;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2814679;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:19;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:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8403696;}i:38;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.281817;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8416712;}i:39;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.282959;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8422048;}i:41;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.28315;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8433344;}i:42;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2840641;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8438680;}i:44;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.284246;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8449824;}i:45;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2851861;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8455160;}i:47;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2853391;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:28;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8463968;}i:48;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.285944;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:28;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8469296;}i:50;a:6:{i:0;s:584:"SELECT Q1.month_th,IFNULL(Q2.TOTAL,0) AS TOTAL FROM ( SELECT m.id,m.month_th,m.orders FROM `month` m ) Q1 LEFT JOIN ( SELECT SUBSTR(p.create_date,'6','2') AS m,COUNT(*) TOTAL FROM register p WHERE p.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY SUBSTR(p.create_date,'6','2') ) Q2 ON Q1.id = Q2.m ORDER BY Q1.orders ASC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2861209;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:87;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:24;s:8:"function";s:17:"CountProjectMonth";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8473040;}i:51;a:6:{i:0;s:584:"SELECT Q1.month_th,IFNULL(Q2.TOTAL,0) AS TOTAL FROM ( SELECT m.id,m.month_th,m.orders FROM `month` m ) Q1 LEFT JOIN ( SELECT SUBSTR(p.create_date,'6','2') AS m,COUNT(*) TOTAL FROM register p WHERE p.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY SUBSTR(p.create_date,'6','2') ) Q2 ON Q1.id = Q2.m ORDER BY Q1.orders ASC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2870729;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:87;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:24;s:8:"function";s:17:"CountProjectMonth";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8486440;}i:53;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2879291;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8551272;}i:54;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.288837;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8556616;}i:56;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.289036;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8567704;}i:57;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2899239;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8573048;}i:59;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.290118;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8584136;}i:60;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2909231;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8589480;}i:62;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.29108;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:87;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8597928;}i:63;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.291692;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:87;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8603264;}}}";s:2:"db";s:29452:"a:1:{s:8:"messages";a:32:{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:1533545581.254384;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6398768;}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:1533545581.2562571;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6429712;}i:12;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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:1533545581.2577469;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6472120;}i:13;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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:1533545581.2585969;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6475072;}i:15;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2626519;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6875544;}i:16;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.263413;i:4;a:1:{i:0;a:5:{s:4:"file";s:68:"/var/www/html/laborproject/vendor/dektrium/yii2-user/models/User.php";s:4:"line";i:529;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6882000;}i:25;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2747669;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8123536;}i:26;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.275388;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8129640;}i:28;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2755721;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8146272;}i:29;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2771161;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8157496;}i:31;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'labortype' AND kcu.table_name = 'labortype'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2775099;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8162088;}i:32;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'labortype' AND kcu.table_name = 'labortype'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2783329;i:4;a:1:{i:0;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:77;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8165032;}i:35;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2807741;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:19;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:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8395184;}i:36;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2814679;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:19;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:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8403696;}i:38;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.281817;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8416712;}i:39;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.282959;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8422048;}i:41;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.28315;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8433344;}i:42;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2840641;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8438680;}i:44;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.284246;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8449824;}i:45;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2851861;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:25;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8455160;}i:47;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2853391;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:28;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8463968;}i:48;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.285944;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:28;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:21;s:8:"function";s:16:"CountTypeProject";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}}i:5;i:8469296;}i:50;a:6:{i:0;s:584:"SELECT Q1.month_th,IFNULL(Q2.TOTAL,0) AS TOTAL FROM ( SELECT m.id,m.month_th,m.orders FROM `month` m ) Q1 LEFT JOIN ( SELECT SUBSTR(p.create_date,'6','2') AS m,COUNT(*) TOTAL FROM register p WHERE p.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY SUBSTR(p.create_date,'6','2') ) Q2 ON Q1.id = Q2.m ORDER BY Q1.orders ASC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2861209;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:87;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:24;s:8:"function";s:17:"CountProjectMonth";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8473040;}i:51;a:6:{i:0;s:584:"SELECT Q1.month_th,IFNULL(Q2.TOTAL,0) AS TOTAL FROM ( SELECT m.id,m.month_th,m.orders FROM `month` m ) Q1 LEFT JOIN ( SELECT SUBSTR(p.create_date,'6','2') AS m,COUNT(*) TOTAL FROM register p WHERE p.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY SUBSTR(p.create_date,'6','2') ) Q2 ON Q1.id = Q2.m ORDER BY Q1.orders ASC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2870729;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:87;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:24;s:8:"function";s:17:"CountProjectMonth";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8486440;}i:53;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2879291;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8551272;}i:54;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '1' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '1' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.288837;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8556616;}i:56;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.289036;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8567704;}i:57;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '2' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '2' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2899239;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8573048;}i:59;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.290118;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8584136;}i:60;a:6:{i:0;s:633:"SELECT COUNT(*) AS TOTAL FROM (SELECT l.patient FROM laborresult l INNER JOIN register r ON l.patient = r.id WHERE l.type = '3' AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31') GROUP BY l.patient ) Q1 INNER JOIN ( SELECT ls.patient,SUM(ls.score) AS val FROM laborresult ls WHERE type = '3' GROUP BY ls.patient ) Q2 ON Q1.patient = Q2.patient WHERE Q2.val = '0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.2909231;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:62;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:72;s:8:"function";s:18:"CountProjectSingle";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8589480;}i:62;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.29108;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:87;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8597928;}i:63;a:6:{i:0;s:211:"SELECT COUNT(*) AS total FROM register r WHERE (r.st5 BETWEEN '8' AND '15') OR (r.tmhi <= '26') AND r.create_date BETWEEN CONCAT('2017','-10-01') AND CONCAT('2018','-09-31')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545581.291692;i:4;a:3:{i:0;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/models/Dashboard.php";s:4:"line";i:107;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/laborproject/views/site/index.php";s:4:"line";i:87;s:8:"function";s:7:"GetRisk";s:5:"class";s:20:"app\models\Dashboard";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:57:"/var/www/html/laborproject/controllers/SiteController.php";s:4:"line";i:79;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8603264;}}}";s:6:"assets";s:2390:"a:5:{s:19:"yii\web\JqueryAsset";a:9:{s:10:"sourcePath";s:51:"/var/www/html/laborproject/vendor/bower/jquery/dist";s:2:"js";a:1:{i:0;s:9:"jquery.js";}s:8:"basePath";s:42:"/var/www/html/laborproject/assets/dd1a9c6a";s:7:"baseUrl";s:29:"/laborproject/assets/dd1a9c6a";s:7:"depends";a:0:{}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:19:"app\assets\AppAsset";a:9:{s:8:"basePath";s:26:"/var/www/html/laborproject";s:7:"baseUrl";s:17:"/laborproject/web";s:3:"css";a:5:{i:0;s:12:"css/site.css";i:1;s:34:"css/bootstrap/bootstrap-flatly.css";i:2;s:27:"lib/uploadify/uploadify.css";i:3;s:37:"lib/font-awesome/css/font-awesome.css";i:4;s:49:"lib/DataTables/media/css/dataTables.bootstrap.css";}s:2:"js";a:4:{i:0;s:33:"lib/uploadify/jquery.uploadify.js";i:1;s:44:"lib/DataTables/media/js/jquery.dataTables.js";i:2;s:47:"lib/DataTables/media/js/dataTables.bootstrap.js";i:3;s:31:"lib/Highcharts/js/highcharts.js";}s:7:"depends";a:2:{i:0;s:16:"yii\web\YiiAsset";i:1;s:28:"yii\bootstrap\BootstrapAsset";}s:10:"sourcePath";N;s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\web\YiiAsset";a:9:{s:10:"sourcePath";s:53:"/var/www/html/laborproject/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:6:"yii.js";}s:7:"depends";a:1:{i:0;s:19:"yii\web\JqueryAsset";}s:8:"basePath";s:42:"/var/www/html/laborproject/assets/f8c7ea19";s:7:"baseUrl";s:29:"/laborproject/assets/f8c7ea19";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:28:"yii\bootstrap\BootstrapAsset";a:9:{s:10:"sourcePath";s:54:"/var/www/html/laborproject/vendor/bower/bootstrap/dist";s:3:"css";a:1:{i:0;s:17:"css/bootstrap.css";}s:8:"basePath";s:42:"/var/www/html/laborproject/assets/74b3de72";s:7:"baseUrl";s:29:"/laborproject/assets/74b3de72";s:7:"depends";a:0:{}s:2:"js";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:34:"yii\bootstrap\BootstrapPluginAsset";a:9:{s:10:"sourcePath";s:54:"/var/www/html/laborproject/vendor/bower/bootstrap/dist";s:2:"js";a:1:{i:0;s:15:"js/bootstrap.js";}s:7:"depends";a:2:{i:0;s:19:"yii\web\JqueryAsset";i:1;s:28:"yii\bootstrap\BootstrapAsset";}s:8:"basePath";s:42:"/var/www/html/laborproject/assets/74b3de72";s:7:"baseUrl";s:29:"/laborproject/assets/74b3de72";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:93:"a:3:{s:5:"start";d:1533545581.2079079;s:3:"end";d:1533545581.3065441;s:6:"memory";i:9816832;}";s:4:"user";s:1800:"a:5:{s:2:"id";i:1;s:8:"identity";a:14:{s:2:"id";s:1:"1";s:8:"username";s:10:"'kimniyom'";s:5:"email";s:24:"'kimniyomclub@gmail.com'";s:13:"password_hash";s:62:"'$2y$12$ma3g3HtdPwBA8u4h5nTemurAEI86GstsAY183.77.xSS/J.7GnxMe'";s:8:"auth_key";s:34:"'NJka7-6ftpN6bPU0VRKmKIXxiS0UNfGg'";s:12:"confirmed_at";s:10:"1471492769";s:17:"unconfirmed_email";s:4:"null";s:10:"blocked_at";s:4:"null";s:15:"registration_ip";s:5:"'::1'";s:10:"created_at";s:10:"1471492769";s:10:"updated_at";s:10:"1471492769";s:5:"flags";s:1:"0";s:6:"status";s:3:"'s'";s:13:"last_login_at";s:12:"'1533545494'";}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:30:"ชื่อผู้ใช้";}i:2;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:15:"อีเมล";}i:3;a:2:{s:9:"attribute";s:13:"password_hash";s:5:"label";s:13:"Password Hash";}i:4;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:5;a:2:{s:9:"attribute";s:12:"confirmed_at";s:5:"label";s:39:"เวลาการยืนยัน";}i:6;a:2:{s:9:"attribute";s:17:"unconfirmed_email";s:5:"label";s:27:"อีเมลใหม่";}i:7;a:2:{s:9:"attribute";s:10:"blocked_at";s:5:"label";s:10:"Blocked At";}i:8;a:2:{s:9:"attribute";s:15:"registration_ip";s:5:"label";s:39:"IP ที่ลงทะเบียน";}i:9;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:45:"วันที่ลงทะเบียน";}i:10;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:10:"Updated At";}i:11;a:2:{s:9:"attribute";s:5:"flags";s:5:"label";s:5:"Flags";}i:12;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:6:"Status";}i:13;a:2:{s:9:"attribute";s:13:"last_login_at";s:5:"label";s:13:"Last Login At";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:6:"router";s:206:"a:1:{s:8:"messages";a:1:{i:20;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:1533545581.271862;i:4;a:0:{}i:5;i:7778912;}}}";s:7:"summary";a:9:{s:3:"tag";s:13:"5b680c6d41e27";s:3:"url";s:42:"http://172.17.250.9/laborproject/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:11:"172.17.3.25";s:4:"time";d:1533545581.2049999;s:10:"statusCode";i:200;s:8:"sqlCount";i:16;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}