Сюжеты

29 июля 2021
28 июля 2021
Архив:
Идет загрузка...
Журнал приложения
Время Уровень Категория Сообщение
22:23:03.670351 trace system.CModule
Loading "log" application component
22:23:03.670617 trace system.CModule
Loading "request" application component
22:23:03.670777 trace system.CModule
Loading "urlManager" application component
22:23:03.670860 trace system.CModule
Loading "cache" application component
22:23:03.672979 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
22:23:03.677895 trace system.caching.CMemCache
Saving "Yii.CUrlManager.rules" to cache
22:23:03.683254 trace system.base.CModule
Loading "publication" module
22:23:03.683739 trace system.CModule
Loading "session" application component
22:23:03.687417 trace system.web.filters.CFilterChain
Running filter ThemeController.filterrights()
22:23:03.687474 trace system.CModule
Loading "user" application component
22:23:03.687691 trace system.CModule
Loading "securityManager" application component
22:23:03.688067 trace system.CModule
Loading "messages" application component
22:23:03.688220 trace system.CModule
Loading "db" application component
22:23:03.688288 trace system.db.CDbConnection
Opening DB connection
22:23:03.689078 trace system.db.CDbCommand
Querying SQL: SELECT count(distinct(p.id)) FROM tbl_publication p JOIN
tbl_publication_theme pt ON pt.pub_id = p.id JOIN tbl_theme tm ON tm.id =
pt.theme_id WHERE tm.status = :status AND p.status = :status AND
tm.project_id = :projectId. Bound with :status=1, :projectId=1
22:23:03.689089 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT count(distinct(p.id)) FROM
tbl_publication p JOIN tbl_publication_theme pt ON pt.pub_id = p.id JOIN
tbl_theme tm ON tm.id = pt.theme_id WHERE tm.status = :status AND p.status
= :status AND tm.project_id = :projectId. Bound with :status=1,
:projectId=1)
22:23:03.689232 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT count(distinct(p.id)) FROM
tbl_publication p JOIN tbl_publication_theme pt ON pt.pub_id = p.id JOIN
tbl_theme tm ON tm.id = pt.theme_id WHERE tm.status = :status AND p.status
= :status AND tm.project_id = :projectId. Bound with :status=1,
:projectId=1)
22:23:03.689627 trace system.caching.CMemCache
Serving "Informers_2021-07-29" from cache
22:23:03.689646 trace system.CModule
Loading "themeManager" application component
22:23:03.689848 trace system.CModule
Loading "widgetFactory" application component
22:23:03.690865 trace system.db.CDbCommand
Querying SQL: SELECT p.id, p.name,
DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%H:%i") as tm, 
            DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%d %m %Y") as dt,
p.create_time, p.main, p.content, 
            f.id as fid, f.name as filename, f.filepath,
            tm.id as themeid, tm.name as theme 
            FROM tbl_publication p 
                LEFT JOIN tbl_files f ON f.object_id = p.id AND
f.object_name = "Publication" 
                JOIN tbl_publication_theme pt ON pt.pub_id = p.id
                JOIN tbl_theme tm ON tm.id = pt.theme_id                 
            WHERE tm.status = :status AND p.status = :status AND
tm.project_id = :projectId 
            GROUP by p.id ORDER BY p.create_time DESC LIMIT 30. Bound with
:status=1, :projectId=1
22:23:03.690872 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT p.id, p.name,
DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%H:%i") as tm, 
            DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%d %m %Y") as dt,
p.create_time, p.main, p.content, 
            f.id as fid, f.name as filename, f.filepath,
            tm.id as themeid, tm.name as theme 
            FROM tbl_publication p 
                LEFT JOIN tbl_files f ON f.object_id = p.id AND
f.object_name = "Publication" 
                JOIN tbl_publication_theme pt ON pt.pub_id = p.id
                JOIN tbl_theme tm ON tm.id = pt.theme_id                 
            WHERE tm.status = :status AND p.status = :status AND
tm.project_id = :projectId 
            GROUP by p.id ORDER BY p.create_time DESC LIMIT 30. Bound with
:status=1, :projectId=1)
22:23:03.691215 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT p.id, p.name,
DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%H:%i") as tm, 
            DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%d %m %Y") as dt,
p.create_time, p.main, p.content, 
            f.id as fid, f.name as filename, f.filepath,
            tm.id as themeid, tm.name as theme 
            FROM tbl_publication p 
                LEFT JOIN tbl_files f ON f.object_id = p.id AND
f.object_name = "Publication" 
                JOIN tbl_publication_theme pt ON pt.pub_id = p.id
                JOIN tbl_theme tm ON tm.id = pt.theme_id                 
            WHERE tm.status = :status AND p.status = :status AND
tm.project_id = :projectId 
            GROUP by p.id ORDER BY p.create_time DESC LIMIT 30. Bound with
:status=1, :projectId=1)
22:23:03.692276 trace system.CModule
Loading "assetManager" application component
22:23:03.692399 trace system.CModule
Loading "clientScript" application component
22:23:03.713202 trace system.caching.CMemCache
Serving "Commercial_21" from cache
22:23:03.713855 trace system.caching.CMemCache
Serving "Commercial_31" from cache
22:23:03.714585 trace system.db.CDbCommand
Querying SQL: SELECT `e`.`name`, `e`.`link`, `e`.`time_type`,
`e`.`date_start`, `e`.`time_start`, `e`.`date_end`, `e`.`times_start`,
`e`.`time_work`, `ep`.`name` AS `placename`, `e`.`main`
FROM `tbl_event` `e`
LEFT JOIN `tbl_event_place` `ep` ON ep.id = e.place_id
WHERE e.status = :status AND hide_main = 0 AND 
        	(date_start >= NOW(-3600) || (date_start = "2021-07-29" AND
time_start>NOW(-3600)) || (date_end > NOW(-3600))) AND (time_type = :type1
OR time_type = :type2)
ORDER BY `date_start` ASC LIMIT 5. Bound with :status=1, :type1=1, :type2=2
22:23:03.714595 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `e`.`name`, `e`.`link`,
`e`.`time_type`, `e`.`date_start`, `e`.`time_start`, `e`.`date_end`,
`e`.`times_start`, `e`.`time_work`, `ep`.`name` AS `placename`, `e`.`main`
FROM `tbl_event` `e`
LEFT JOIN `tbl_event_place` `ep` ON ep.id = e.place_id
WHERE e.status = :status AND hide_main = 0 AND 
        	(date_start >= NOW(-3600) || (date_start = "2021-07-29" AND
time_start>NOW(-3600)) || (date_end > NOW(-3600))) AND (time_type = :type1
OR time_type = :type2)
ORDER BY `date_start` ASC LIMIT 5. Bound with :status=1, :type1=1,
:type2=2)
22:23:03.716098 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `e`.`name`, `e`.`link`,
`e`.`time_type`, `e`.`date_start`, `e`.`time_start`, `e`.`date_end`,
`e`.`times_start`, `e`.`time_work`, `ep`.`name` AS `placename`, `e`.`main`
FROM `tbl_event` `e`
LEFT JOIN `tbl_event_place` `ep` ON ep.id = e.place_id
WHERE e.status = :status AND hide_main = 0 AND 
        	(date_start >= NOW(-3600) || (date_start = "2021-07-29" AND
time_start>NOW(-3600)) || (date_end > NOW(-3600))) AND (time_type = :type1
OR time_type = :type2)
ORDER BY `date_start` ASC LIMIT 5. Bound with :status=1, :type1=1,
:type2=2)
22:23:03.716434 trace system.caching.CMemCache
Serving "Commercial_71" from cache
22:23:03.716825 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`announce`,
`p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.id
JOIN `tbl_section` `s` ON s.id = ps.section_id
LEFT JOIN `tbl_files` `f` ON f.object_id = p.id AND f.object_name =
"Publication"
WHERE p.status = :status AND ps.section_id = :sid AND p.article = 1 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid=1
22:23:03.716831 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`announce`, `p`.`create_time`, `p`.`comments`, `p`.`thumbnail`,
`f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.id
JOIN `tbl_section` `s` ON s.id = ps.section_id
LEFT JOIN `tbl_files` `f` ON f.object_id = p.id AND f.object_name =
"Publication"
WHERE p.status = :status AND ps.section_id = :sid AND p.article = 1 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid=1)
22:23:03.717076 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`announce`,
`p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.id
JOIN `tbl_section` `s` ON s.id = ps.section_id
LEFT JOIN `tbl_files` `f` ON f.object_id = p.id AND f.object_name =
"Publication"
WHERE p.status = :status AND ps.section_id = :sid AND p.article = 1 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid=1)
22:23:03.718497 trace system.caching.CMemCache
Deleting "Yii.COutputCache.projectThemes_1......." from cache
22:23:03.718755 trace system.db.CDbCommand
Querying SQL: SELECT * FROM (SELECT t.id, t.name, p.urlname as project,
pu.theme_id, pu.pub_id FROM tbl_theme t LEFT JOIN tbl_project p ON p.id =
t.project_id JOIN tbl_publication_theme pu ON pu.theme_id = t.id WHERE
t.project_id = :pId AND t.status = :status AND t.hide <> 1 ORDER BY
pu.pub_id DESC LIMIT 100) AS ot GROUP by ot.id ORDER BY ot.pub_id DESC
LIMIT 5. Bound with :pId=1, :status=1
22:23:03.718765 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM (SELECT t.id, t.name,
p.urlname as project, pu.theme_id, pu.pub_id FROM tbl_theme t LEFT JOIN
tbl_project p ON p.id = t.project_id JOIN tbl_publication_theme pu ON
pu.theme_id = t.id WHERE t.project_id = :pId AND t.status = :status AND
t.hide <> 1 ORDER BY pu.pub_id DESC LIMIT 100) AS ot GROUP by ot.id ORDER
BY ot.pub_id DESC LIMIT 5. Bound with :pId=1, :status=1)
22:23:03.719033 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM (SELECT t.id, t.name,
p.urlname as project, pu.theme_id, pu.pub_id FROM tbl_theme t LEFT JOIN
tbl_project p ON p.id = t.project_id JOIN tbl_publication_theme pu ON
pu.theme_id = t.id WHERE t.project_id = :pId AND t.status = :status AND
t.hide <> 1 ORDER BY pu.pub_id DESC LIMIT 100) AS ot GROUP by ot.id ORDER
BY ot.pub_id DESC LIMIT 5. Bound with :pId=1, :status=1)