© 2017 Pallada. Powered by Yii Framework.
Application Log
Timestamp Level Category Message
00:41:06.741187 trace system.CModule
Loading "log" application component
in /var/www/htdocs/index.php (13)
00:41:06.743151 trace system.CModule
Loading "request" application component
in /var/www/htdocs/index.php (13)
00:41:06.745425 trace system.CModule
Loading "urlManager" application component
in /var/www/htdocs/index.php (13)
00:41:06.750391 trace system.CModule
Loading "db" application component
in /var/www/htdocs/protected/models/sqlData.php (15)
in /var/www/htdocs/protected/controllers/SiteController.php (24)
in /var/www/htdocs/index.php (13)
00:41:06.751214 trace system.db.CDbConnection
Opening DB connection
in /var/www/htdocs/protected/models/sqlData.php (15)
in /var/www/htdocs/protected/controllers/SiteController.php (24)
in /var/www/htdocs/index.php (13)
00:41:06.759298 trace system.db.CDbCommand
Querying SQL: select count(1),* from (SELECT 
(SELECT date_trunc('hour', TIMESTAMP 'epoch' + round(wo.CREATEDTIME/1000) *
INTERVAL '1 second' + interval '4 hour')) CREATEDTIME
FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON
wo.WORKORDERID=wos.WORKORDERID 
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID 
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID 
LEFT JOIN SDOrganization sdo ON wo.SITEID=sdo.ORG_ID
LEFT JOIN workorderhistory woh ON wo.WORKORDERID=woh.workorderid
inner JOIN workorderhistorydiff wohd ON woh.historyid=wohd.historyid 
and ((wohd.columnname = 'STATUSID' and wohd.prev_value='301' and
wohd.current_value='302') OR (wohd.columnname = 'STATUSID' and
wohd.prev_value='301' and wohd.current_value='1'))
INNER JOIN AccountSiteMapping ON wo.SITEID=AccountSiteMapping.SITEID 
WHERE (((wo.CREATEDTIME >= 1488052800000) AND ((wo.CREATEDTIME != 0) 
    AND (wo.CREATEDTIME IS NOT NULL)) AND wo.CREATEDTIME <=
1488139200000))
and (woh.operationtime - wo.CREATEDTIME) >= 1800000
order by 1
) as data
group by CREATEDTIME
in /var/www/htdocs/protected/models/sqlData.php (39)
in /var/www/htdocs/protected/controllers/SiteController.php (28)
in /var/www/htdocs/index.php (13)
00:41:07.708204 trace system.db.CDbCommand
Querying SQL: select count(1),* from (SELECT 
(SELECT date_trunc('hour', TIMESTAMP 'epoch' + round(wo.CREATEDTIME/1000) *
INTERVAL '1 second' + interval '4 hour')) CREATEDTIME
FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON
wo.WORKORDERID=wos.WORKORDERID 
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID 
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID 
LEFT JOIN SDOrganization sdo ON wo.SITEID=sdo.ORG_ID
LEFT JOIN workorderhistory woh ON wo.WORKORDERID=woh.workorderid
inner JOIN workorderhistorydiff wohd ON woh.historyid=wohd.historyid 
and ((wohd.columnname = 'STATUSID' and wohd.prev_value='301' and
wohd.current_value='302') OR (wohd.columnname = 'STATUSID' and
wohd.prev_value='301' and wohd.current_value='1'))
--and ((wohd.columnname = 'STATUSID' and wohd.prev_value='301' and
wohd.current_value<>'302') AND (wohd.columnname = 'STATUSID' and
wohd.prev_value='301' and wohd.current_value<>'1'))
INNER JOIN AccountSiteMapping ON wo.SITEID=AccountSiteMapping.SITEID 
WHERE (((wo.CREATEDTIME >= 1488052800000) AND ((wo.CREATEDTIME != 0) 
    AND (wo.CREATEDTIME IS NOT NULL)) AND wo.CREATEDTIME <=
1488139200000))
--and wo.DUEBYTIME != (-1)
and wo.COMPLETEDTIME >= wo.DUEBYTIME
and (woh.operationtime - wo.CREATEDTIME) >= 1800000
order by 1
) as data
group by CREATEDTIME
in /var/www/htdocs/protected/models/sqlData.php (70)
in /var/www/htdocs/protected/controllers/SiteController.php (29)
in /var/www/htdocs/index.php (13)
00:41:08.620841 trace system.db.CDbCommand
Querying SQL: select count(1),"Оценка" from (seLECT
sadt.ANSVALUES "Оценка",
(SELECT TIMESTAMP 'epoch' + round(wo.COMPLETEDTIME/1000) * INTERVAL '1
second' + interval '4 hour') "Время выполнения"
FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON
spr.SURVEYID=spre.SURVEYID 
LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID 
LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID 
LEFT JOIN WorkOrder wo ON spr.WORKORDERID=wo.WORKORDERID 
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID 
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID 
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID 
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID 
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID 
LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID 
LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID 
WHERE  ((((wo.COMPLETEDTIME >=1488052800000) AND ((wo.COMPLETEDTIME != 0)
AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <=
1488139200000) AND (((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT
NULL)) AND (wo.COMPLETEDTIME != -1)))))
AND sadt.ANSVALUES ~ '(1|2|3|4|5)')as data
group by "Оценка"
in /var/www/htdocs/protected/models/sqlData.php (100)
in /var/www/htdocs/protected/controllers/SiteController.php (30)
in /var/www/htdocs/index.php (13)
00:41:08.736129 trace system.CModule
Loading "widgetFactory" application component
in /var/www/htdocs/protected/views/layouts/column1.php (2)
in /var/www/htdocs/protected/controllers/SiteController.php (31)
in /var/www/htdocs/index.php (13)
00:41:08.741261 trace system.CModule
Loading "user" application component
in /var/www/htdocs/protected/views/layouts/main.php (81)
in /var/www/htdocs/protected/views/layouts/column1.php (6)
in /var/www/htdocs/protected/controllers/SiteController.php (31)
00:41:08.742386 trace system.CModule
Loading "session" application component
in /var/www/htdocs/protected/views/layouts/main.php (81)
in /var/www/htdocs/protected/views/layouts/column1.php (6)
in /var/www/htdocs/protected/controllers/SiteController.php (31)
00:41:08.744662 trace system.CModule
Loading "coreMessages" application component
in /var/www/htdocs/protected/views/layouts/main.php (118)
in /var/www/htdocs/protected/views/layouts/column1.php (6)
in /var/www/htdocs/protected/controllers/SiteController.php (31)
00:41:08.746020 trace system.CModule
Loading "clientScript" application component
in /var/www/htdocs/protected/controllers/SiteController.php (31)
in /var/www/htdocs/index.php (13)