Log Messages

ทั้งหมด 22 ผลลัพธ์

Time	Level	Category	Message

21:25:06.922	info	yii\db\Command::query	SELECT 1 AS `name`, SUM(IF(h.inn1='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:06.922	info	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;port=3306;dbname=dohdashboard
21:25:07.075	info	yii\db\Command::query	SELECT 2 AS `name`, SUM(IF(h.inn2='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.081	info	yii\db\Command::query	SELECT 3 AS `name`, SUM(IF(h.inn3='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.091	info	yii\db\Command::query	SELECT 4 AS `name`, SUM(IF(h.inn4='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.103	info	yii\db\Command::query	SELECT 5 AS `name`, SUM(IF(h.inn5='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.109	info	yii\db\Command::query	SELECT 6 AS `name`, SUM(IF(h.inn6='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.116	info	yii\db\Command::query	SELECT 7 AS `name`, SUM(IF(h.inn7='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.122	info	yii\db\Command::query	SELECT 8 AS `name`, SUM(IF(h.inn8='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.129	info	yii\db\Command::query	SELECT 9 AS `name`, SUM(IF(h.inn9='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.135	info	yii\db\Command::query	SELECT 10 AS `name`, SUM(IF(h.inn10='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode
21:25:07.142	info	yii\db\Command::query	SELECT IFNULL(z.region_code,'TOTAL') AS areacode, t.target AS `value`, t.target2 AS `value2`, z.region_name AS areaname_new, COUNT(z.region_code) AS total, -- SUM(IF(IFNULL(h.result_S,0)='N',1,0)) AS noeval, s.tpass AS tpass, h.apass AS apass FROM env_com_region z LEFT JOIN (SELECT COUNT(DISTINCT areacode) AS tpass,regionBy AS sregion FROM env_com_report WHERE ryear = '2568' AND regionBy NOT IN ('00','20') GROUP BY regionBy) s ON z.region_code = s.sregion LEFT JOIN (SELECT SUM(target) AS target ,SUM(target2) AS target2 ,areacode FROM env_com_result WHERE b_year='2568' GROUP BY areacode) t ON z.region_code=t.areacode LEFT JOIN (SELECT e.id,e.areacode, SUM(IF(e.result_S='1',1,0)) AS apass,e.regionBy AS regioncode FROM env_com_report e WHERE e.id IN (SELECT MAX(id) FROM env_com_report WHERE ryear = '2568' AND result_S = '1' AND regionBy IN ('01','02','03','04','05','06','07','08','09','10','11','12','20') GROUP BY areacode,regionBy )GROUP BY e.regionBy) h ON z.region_code = h.regioncode WHERE z.region_code NOT IN ('13','00','99') GROUP BY h.regioncode order by z.region_code
21:25:07.544	info	yii\db\Command::query	select * from geojson where areatype=1
21:25:07.639	info	yii\db\Command::query	SELECT z.region_code AS cname, COUNT(z.region_code) AS total, t.target AS `value`, t.target2 AS `value2`, (SELECT SUM(target) FROM env_com_result WHERE b_year='2568' AND areacode NOT IN ('13','00','20','99') ) AS target, (SELECT result1 FROM env_com_result WHERE b_year='2568' AND areacode='01' ) AS result1, z.region_name AS areaname, s.tpass AS tpass, h.apass AS apass FROM env_com_region z LEFT JOIN (SELECT COUNT(DISTINCT areacode) AS tpass,regionBy AS sregion FROM env_com_report WHERE ryear = '2568' AND regionBy NOT IN ('00','20') GROUP BY regionBy) s ON z.region_code = s.sregion LEFT JOIN (SELECT SUM(target) AS target ,SUM(target2) AS target2 ,areacode FROM env_com_result WHERE b_year='2568' GROUP BY areacode) t ON z.region_code=t.areacode LEFT JOIN (SELECT e.id,e.areacode, SUM(IF(e.result_S='1',1,0)) AS apass,e.regionBy AS regioncode FROM env_com_report e WHERE e.id IN (SELECT MAX(id) FROM env_com_report WHERE ryear = '2568' AND result_S = '1' AND regionBy IN ('01','02','03','04','05','06','07','08','09','10','11','12','20') GROUP BY areacode,regionBy )GROUP BY e.regionBy) h ON z.region_code = h.regioncode WHERE z.region_code NOT IN ('13','00','20','99') GROUP BY h.regioncode
21:25:07.692	info	yii\db\Command::query	SELECT z.region_name AS cname, COUNT(z.region_code) AS total, t.target AS `value`, h.npass AS npass, h.apass AS apass, h.inno1 AS inno1, h.inno2 AS inno2, h.inno3 AS inno3, h.inno4 AS inno4, h.inno5 AS inno5, h.inno6 AS inno6, h.inno7 AS inno7, h.inno8 AS inno8, h.inno9 AS inno9, h.inno10 AS inno10, (SELECT SUM(target) FROM env_com_result WHERE b_year='2568') AS target FROM env_com_region z LEFT JOIN (SELECT e.areacode , SUM(IF(e.result_S='0',1,0)) AS npass, SUM(IF(e.result_S='1',1,0)) AS apass, SUM(IF(e.inno1='1',1,0)) AS inno1, SUM(IF(e.inno2='1',1,0)) AS inno2, SUM(IF(e.inno3='1',1,0)) AS inno3, SUM(IF(e.inno4='1',1,0)) AS inno4, SUM(IF(e.inno5='1',1,0)) AS inno5, SUM(IF(e.inno6='1',1,0)) AS inno6, SUM(IF(e.inno7='1',1,0)) AS inno7, SUM(IF(e.inno8='1',1,0)) AS inno8, SUM(IF(e.inno9='1',1,0)) AS inno9, SUM(IF(e.inno10='1',1,0)) AS inno10, e.regionBy AS regioncode,e.regionBy AS regionBy FROM env_com_report e WHERE e.id IN (SELECT MAX(id) FROM env_com_report WHERE ryear = '2568' AND regionBy NOT IN ('00','20') GROUP BY areacode )GROUP BY e.regionBy) h ON z.region_code = h.regionBy LEFT JOIN (SELECT SUM(target) AS target ,areacode FROM env_com_result WHERE b_year='2568' GROUP BY areacode) t ON h.regionBy=t.areacode WHERE z.region_code NOT IN ('00','13','99') GROUP BY z.region_code
21:25:07.737	info	yii\db\Command::query	SELECT `data` FROM `session` WHERE `expire`>1754317507 AND `id`='ce4h01r4nj9o5spas0lc6gjuq6'
21:25:07.738	info	yii\web\Session::open	Session started
21:25:07.743	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `session`
21:25:07.745	info	yii\db\Command::query	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 = 'session' AND kcu.table_name = 'session'
21:25:07.746	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `name`, `kcu`.`COLUMN_NAME` AS `column_name`, `tc`.`CONSTRAINT_TYPE` AS `type`, CASE WHEN NULL IS NULL AND `kcu`.`REFERENCED_TABLE_SCHEMA` = DATABASE() THEN NULL ELSE `kcu`.`REFERENCED_TABLE_SCHEMA` END AS `foreign_table_schema`, `kcu`.`REFERENCED_TABLE_NAME` AS `foreign_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `foreign_column_name`, `rc`.`UPDATE_RULE` AS `on_update`, `rc`.`DELETE_RULE` AS `on_delete`, `kcu`.`ORDINAL_POSITION` AS `position` FROM `information_schema`.`KEY_COLUMN_USAGE` AS `kcu`, `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`, `information_schema`.`TABLE_CONSTRAINTS` AS `tc` WHERE `kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `kcu`.`TABLE_NAME` = 'session' AND `rc`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `rc`.`TABLE_NAME` = 'session' AND `rc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = 'session' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` = 'FOREIGN KEY' UNION SELECT `kcu`.`CONSTRAINT_NAME` AS `name`, `kcu`.`COLUMN_NAME` AS `column_name`, `tc`.`CONSTRAINT_TYPE` AS `type`, NULL AS `foreign_table_schema`, NULL AS `foreign_table_name`, NULL AS `foreign_column_name`, NULL AS `on_update`, NULL AS `on_delete`, `kcu`.`ORDINAL_POSITION` AS `position` FROM `information_schema`.`KEY_COLUMN_USAGE` AS `kcu`, `information_schema`.`TABLE_CONSTRAINTS` AS `tc` WHERE `kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`TABLE_NAME` = 'session' AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = 'session' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` IN ('PRIMARY KEY', 'UNIQUE') ORDER BY `position` ASC
21:25:07.750	info	yii\db\Command::query	SELECT `s`.`INDEX_NAME` AS `name`, `s`.`COLUMN_NAME` AS `column_name`, `s`.`NON_UNIQUE` ^ 1 AS `index_is_unique`, `s`.`INDEX_NAME` = 'PRIMARY' AS `index_is_primary` FROM `information_schema`.`STATISTICS` AS `s` WHERE `s`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `s`.`INDEX_SCHEMA` = `s`.`TABLE_SCHEMA` AND `s`.`TABLE_NAME` = 'session' ORDER BY `s`.`SEQ_IN_INDEX` ASC
21:25:07.752	info	yii\db\Command::execute	INSERT INTO `session` (`data`, `id`, `expire`) VALUES ('__flash\|a:0:{}', 'ce4h01r4nj9o5spas0lc6gjuq6', 1754318947) ON DUPLICATE KEY UPDATE `data`=VALUES(`data`), `expire`=VALUES(`expire`)