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:3551:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:10:{s:4:"host";s:12:"172.17.250.9";s:10:"connection";s:10:"keep-alive";s:13:"cache-control";s:9:"max-age=0";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:79:"http://172.17.250.9/laborproject/index.php?r=user%2Fsettings%2Fprofileuser&id=2";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:"_csrf=7eb7b357eccfdd7eccc03fb375e0b7de133ed4cda0c944a3b60133ee0393d319a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22bmayP1oQkW0-d5F4VE2ONaIXtyZJ_7-i%22%3B%7D; PHPSESSID=i6p2p9ghq19eq84s2ril3a8ft2";}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:30:{s:9:"HTTP_HOST";s:12:"172.17.250.9";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:18:"HTTP_CACHE_CONTROL";s:9:"max-age=0";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:79:"http://172.17.250.9/laborproject/index.php?r=user%2Fsettings%2Fprofileuser&id=2";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:"_csrf=7eb7b357eccfdd7eccc03fb375e0b7de133ed4cda0c944a3b60133ee0393d319a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22bmayP1oQkW0-d5F4VE2ONaIXtyZJ_7-i%22%3B%7D; PHPSESSID=i6p2p9ghq19eq84s2ril3a8ft2";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:"65038";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:1533545618.5469999;s:12:"REQUEST_TIME";i:1533545618;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:2:{s:5:"_csrf";s:130:"7eb7b357eccfdd7eccc03fb375e0b7de133ed4cda0c944a3b60133ee0393d319a:2:{i:0;s:5:"_csrf";i:1;s:32:"bmayP1oQkW0-d5F4VE2ONaIXtyZJ_7-i";}";s:9:"PHPSESSID";s:26:"i6p2p9ghq19eq84s2ril3a8ft2";}s:5:"FILES";a:0:{}s:7:"SESSION";a:1:{s:7:"__flash";a:0:{}}}";s:3:"log";s:16700:"a:1:{s:8:"messages";a:29:{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:1533545618.5601721;i:4;a:0:{}i:5;i:1967864;}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:1533545618.560189;i:4;a:0:{}i:5;i:1970696;}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:1533545618.577328;i:4;a:0:{}i:5;i:4333968;}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:1533545618.5773671;i:4;a:0:{}i:5;i:4336536;}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:1533545618.5879641;i:4;a:0:{}i:5;i:5719232;}i:5;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:1533545618.590529;i:4;a:0:{}i:5;i:5978064;}i:6;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1533545618.5911031;i:4;a:0:{}i:5;i:6035952;}i:7;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:1533545618.5914609;i:4;a:0:{}i:5;i:6089240;}i:9;a:6:{i:0;s:19:"Route requested: ''";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1533545618.592921;i:4;a:0:{}i:5;i:6274040;}i:10;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:1533545618.5951829;i:4;a:0:{}i:5;i:6584736;}i:11;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:1533545618.5965879;i:4;a:0:{}i:5;i:6744272;}i:12;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6037591;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:7708992;}i:13;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:1533545618.6038311;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:7717424;}i:18;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:1533545618.6065669;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:7760416;}i:21;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:1533545618.608927;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:7823072;}i:24;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:1533545618.611387;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:7991152;}i:25;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.612047;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:8057120;}i:28;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:1533545618.612942;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:8077464;}i:31;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:1533545618.614145;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:8094104;}i:34;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:1533545618.6153941;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:8110840;}i:37;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:1533545618.6165371;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:8125832;}i:40;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:1533545618.6174021;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:8134128;}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 = '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:1533545618.6193819;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:8212464;}i:46;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:1533545618.620683;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:8228832;}i:49;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:1533545618.621896;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:8245240;}i:52;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:1533545618.6230271;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:8259888;}i:55;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:1533545618.624815;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:8334896;}i:56;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:1533545618.6337571;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:9440960;}i:57;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:1533545618.6345761;i:4;a:0:{}i:5;i:9389584;}}}";s:9:"profiling";s:27001:"a:3:{s:6:"memory";i:9549056;s:4:"time";d:0.086935043334960938;s:8:"messages";a:28:{i:14;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:1533545618.603874;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:7719944;}i:15;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:1533545618.605644;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:7724080;}i:16;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6057069;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:7722216;}i:17;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6062789;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:7728736;}i:19;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:1533545618.6066411;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:7762456;}i:20;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:1533545618.608176;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:7773680;}i:22;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:1533545618.6090009;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:7826016;}i:23;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:1533545618.6097529;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:7828960;}i:26;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6121149;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:8061552;}i:27;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6126561;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:8070064;}i:29;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:1533545618.612999;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:8083112;}i:30;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:1533545618.6140079;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:8088448;}i:32;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:1533545618.6141951;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:8099744;}i:33;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:1533545618.6152511;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:8105336;}i:35;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:1533545618.615443;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:8116480;}i:36;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:1533545618.6164069;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:8121816;}i:38;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:1533545618.616596;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:8130624;}i:39;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:1533545618.617244;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:8135952;}i:41;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:1533545618.6174531;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:8139696;}i:42;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:1533545618.6185141;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:8153096;}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 = '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:1533545618.619447;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:8218032;}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 = '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:1533545618.6205261;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:8223376;}i:47;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:1533545618.6207371;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:8234464;}i:48;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:1533545618.6217489;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:8239808;}i:50;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:1533545618.621948;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:8250896;}i:51;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:1533545618.622915;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:8256240;}i:53;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:1533545618.6230769;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:8264688;}i:54;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:1533545618.62375;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:8270024;}}}";s:2:"db";s:26222:"a:1:{s:8:"messages";a:26:{i:16;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6057069;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:7722216;}i:17;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6062789;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:7728736;}i:19;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:1533545618.6066411;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:7762456;}i:20;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:1533545618.608176;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:7773680;}i:22;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:1533545618.6090009;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:7826016;}i:23;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:1533545618.6097529;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:7828960;}i:26;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6121149;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:8061552;}i:27;a:6:{i:0;s:25:"SELECT * FROM `labortype`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1533545618.6126561;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:8070064;}i:29;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:1533545618.612999;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:8083112;}i:30;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:1533545618.6140079;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:8088448;}i:32;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:1533545618.6141951;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:8099744;}i:33;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:1533545618.6152511;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:8105336;}i:35;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:1533545618.615443;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:8116480;}i:36;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:1533545618.6164069;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:8121816;}i:38;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:1533545618.616596;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:8130624;}i:39;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:1533545618.617244;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:8135952;}i:41;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:1533545618.6174531;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:8139696;}i:42;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:1533545618.6185141;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:8153096;}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 = '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:1533545618.619447;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:8218032;}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 = '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:1533545618.6205261;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:8223376;}i:47;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:1533545618.6207371;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:8234464;}i:48;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:1533545618.6217489;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:8239808;}i:50;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:1533545618.621948;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:8250896;}i:51;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:1533545618.622915;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:8256240;}i:53;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:1533545618.6230769;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:8264688;}i:54;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:1533545618.62375;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:8270024;}}}";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:92:"a:3:{s:5:"start";d:1533545618.5500679;s:3:"end";d:1533545618.637526;s:6:"memory";i:9549056;}";s:4:"user";s:2:"N;";s:6:"router";s:205:"a:1:{s:8:"messages";a:1:{i:8;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:1533545618.592885;i:4;a:0:{}i:5;i:6274896;}}}";s:7:"summary";a:9:{s:3:"tag";s:13:"5b680c92904c4";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:1533545618.5469999;s:10:"statusCode";i:200;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}