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:3553:"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:80:"http://172.17.250.9/laborproject/index.php?r=user%2Fsettings%2Fprofileuser&id=25";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=b996558adbcf914fda4e22a6185194af92d3fa4d8798fc5e00e36cb43294690ca%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22tC_33kPbdG0tZ2MWgz0ELUlUWNnra1ZU%22%3B%7D; PHPSESSID=18m49k3ifavqqk5uq8npeo3mq7";}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:80:"http://172.17.250.9/laborproject/index.php?r=user%2Fsettings%2Fprofileuser&id=25";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=b996558adbcf914fda4e22a6185194af92d3fa4d8798fc5e00e36cb43294690ca%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22tC_33kPbdG0tZ2MWgz0ELUlUWNnra1ZU%22%3B%7D; PHPSESSID=18m49k3ifavqqk5uq8npeo3mq7";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:"64318";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:1533545476.6259999;s:12:"REQUEST_TIME";i:1533545476;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:2:{s:5:"_csrf";s:130:"b996558adbcf914fda4e22a6185194af92d3fa4d8798fc5e00e36cb43294690ca:2:{i:0;s:5:"_csrf";i:1;s:32:"tC_33kPbdG0tZ2MWgz0ELUlUWNnra1ZU";}";s:9:"PHPSESSID";s:26:"18m49k3ifavqqk5uq8npeo3mq7";}s:5:"FILES";a:0:{}s:7:"SESSION";a:1:{s:7:"__flash";a:0:{}}}";s:3:"log";s:16703:"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:1533545476.638694;i:4;a:0:{}i:5;i:1967848;}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:1533545476.6387119;i:4;a:0:{}i:5;i:1970680;}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:1533545476.656605;i:4;a:0:{}i:5;i:4333904;}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:1533545476.6566451;i:4;a:0:{}i:5;i:4336472;}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:1533545476.6677091;i:4;a:0:{}i:5;i:5719056;}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:1533545476.6704049;i:4;a:0:{}i:5;i:5977920;}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:1533545476.670958;i:4;a:0:{}i:5;i:6035744;}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:1533545476.6713409;i:4;a:0:{}i:5;i:6089048;}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:1533545476.6728899;i:4;a:0:{}i:5;i:6273824;}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:1533545476.6752851;i:4;a:0:{}i:5;i:6584488;}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:1533545476.6767759;i:4;a:0:{}i:5;i:6744008;}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:1533545476.6840439;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:7708768;}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:1533545476.684119;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:7717192;}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:1533545476.6869559;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:7760184;}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:1533545476.6894341;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:7822840;}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:1533545476.6919899;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:7990960;}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:1533545476.6926711;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:8057032;}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:1533545476.6936109;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:8077312;}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:1533545476.6950221;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:8093960;}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:1533545476.6962049;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:8110672;}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:1533545476.6973259;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:8125696;}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:1533545476.6980791;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:8133976;}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:1533545476.700002;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:8212312;}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:1533545476.701237;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:8228656;}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:1533545476.703156;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:8245064;}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:1533545476.7043519;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:8259712;}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:1533545476.7061319;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:8334720;}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:1533545476.71507;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:9440736;}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:1533545476.7159419;i:4;a:0:{}i:5;i:9389360;}}}";s:9:"profiling";s:27002:"a:3:{s:6:"memory";i:9548520;s:4:"time";d:0.089706897735595703;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:1533545476.6841609;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:7719712;}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:1533545476.6859701;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:7723848;}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:1533545476.6860349;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:7721984;}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:1533545476.686626;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:7728504;}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:1533545476.6870329;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:7762224;}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:1533545476.6886261;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:7773448;}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:1533545476.6895089;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:7825784;}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:1533545476.6903341;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:7828728;}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:1533545476.6927371;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:8061424;}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:1533545476.6933379;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:8069936;}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:1533545476.693666;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:8082960;}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:1533545476.6948891;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:8088296;}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:1533545476.695075;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:8099592;}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:1533545476.6960731;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:8105184;}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:1533545476.696281;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:8116328;}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:1533545476.6972079;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:8121664;}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:1533545476.6973751;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:8130472;}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:1533545476.6979451;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:8135800;}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:1533545476.698123;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:8139544;}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:1533545476.699224;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:8152944;}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:1533545476.700053;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:8217856;}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:1533545476.701088;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:8223200;}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:1533545476.701292;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:8234288;}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:1533545476.7030201;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:8239632;}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:1533545476.7032089;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:8250720;}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:1533545476.704247;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:8256064;}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:1533545476.704401;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:8264512;}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:1533545476.7050631;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:8269848;}}}";s:2:"db";s:26221:"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:1533545476.6860349;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:7721984;}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:1533545476.686626;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:7728504;}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:1533545476.6870329;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:7762224;}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:1533545476.6886261;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:7773448;}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:1533545476.6895089;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:7825784;}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:1533545476.6903341;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:7828728;}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:1533545476.6927371;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:8061424;}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:1533545476.6933379;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:8069936;}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:1533545476.693666;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:8082960;}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:1533545476.6948891;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:8088296;}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:1533545476.695075;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:8099592;}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:1533545476.6960731;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:8105184;}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:1533545476.696281;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:8116328;}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:1533545476.6972079;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:8121664;}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:1533545476.6973751;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:8130472;}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:1533545476.6979451;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:8135800;}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:1533545476.698123;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:8139544;}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:1533545476.699224;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:8152944;}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:1533545476.700053;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:8217856;}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:1533545476.701088;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:8223200;}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:1533545476.701292;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:8234288;}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:1533545476.7030201;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:8239632;}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:1533545476.7032089;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:8250720;}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:1533545476.704247;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:8256064;}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:1533545476.704401;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:8264512;}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:1533545476.7050631;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:8269848;}}}";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:91:"a:3:{s:5:"start";d:1533545476.628746;s:3:"end";d:1533545476.718998;s:6:"memory";i:9548520;}";s:4:"user";s:2:"N;";s:6:"router";s:206:"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:1533545476.6728511;i:4;a:0:{}i:5;i:6274680;}}}";s:7:"summary";a:9:{s:3:"tag";s:13:"5b680c04a3cc4";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:1533545476.6259999;s:10:"statusCode";i:200;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}