Performance Profiling

Total processing time: 636 ms; Peak memory: 2.501 MB. Show Profiling Timeline

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

Time	Duration	Category	Info

21:23:26.158	0.8 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;port=3306;dbname=dohdashboard
21:23:26.159	0.7 ms	yii\db\Command::query	select * from kpi_hdc k left join kpi_template i on i.id=k.kpi_template_id left join kpi_template_to_year y on y.kpi_template_id=k.kpi_template_id where y.year='2020' and k.kpi_template_id='78'
21:23:26.160	0.6 ms	yii\db\Command::query	SELECT IF(X.areacode!="TOTAL",areaname,"รวมทั้งหมด")as areaname_new, X.* FROM (SELECT IFNULL(A.ampurcodefull,"TOTAL") as areacode, A.ampurname as areaname, MAX(K.date_com) AS report_date, SUM(K.target) as target, (SUM(K.target)-SUM(K.result)) as result, SUM(K.total) as total, ROUND((SUM(IFNULL(K.target,0))-SUM(IFNULL(K.result,0)))/SUM(IFNULL(K.target,0))*100,2 ) as total_ratio FROM s_kpi_dental36 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) INNER JOIN campur a ON a.ampurcodefull=LEFT(K.areacode,4) WHERE K.id = 'e9f3192f523c79cbbbcf7b405e879384' AND K.b_year = 2563 AND LEFT(K.areacode,2) = '84' GROUP BY A.ampurcodefull WITH ROLLUP) X