Performance Profiling

Total processing time: 908 ms; Peak memory: 7.107 MB. Show Profiling Timeline

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

Time	Duration	Category	Info

21:25:07.142	401.6 ms	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:06.923	151.8 ms	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:07.752	73.2 ms	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`)
21:25:07.639	53.1 ms	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	41.5 ms	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.544	11.0 ms	yii\db\Command::query	select * from geojson where areatype=1
21:25:07.091	11.0 ms	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.081	10.1 ms	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.129	6.7 ms	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.122	6.6 ms	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.103	6.6 ms	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.135	6.5 ms	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.109	6.4 ms	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.075	6.4 ms	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.116	6.2 ms	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.746	4.0 ms	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.743	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `session`
21:25:07.750	1.2 ms	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.745	1.1 ms	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:06.922	0.7 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;port=3306;dbname=dohdashboard
21:25:07.738	0.4 ms	yii\db\Command::query	SELECT `data` FROM `session` WHERE `expire`>1754317507 AND `id`='ce4h01r4nj9o5spas0lc6gjuq6'