Идет загрузка...
Журнал приложения
Время Уровень Категория Сообщение
02:33:36.616941 trace system.CModule
Loading "log" application component
02:33:36.617101 trace system.CModule
Loading "request" application component
02:33:36.617227 trace system.CModule
Loading "urlManager" application component
02:33:36.617270 trace system.CModule
Loading "cache" application component
02:33:36.619448 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
02:33:36.620815 trace system.caching.CMemCache
Saving "Yii.CUrlManager.rules" to cache
02:33:36.623683 trace system.CModule
Loading "session" application component
02:33:36.624918 trace system.web.filters.CFilterChain
Running filter SiteController.filterrights()
02:33:36.624954 trace system.CModule
Loading "user" application component
02:33:36.625063 trace system.CModule
Loading "securityManager" application component
02:33:36.625252 trace system.db.ar.CActiveRecord
Project.findByPk()
02:33:36.625262 trace system.CModule
Loading "db" application component
02:33:36.625298 trace system.db.CDbConnection
Opening DB connection
02:33:36.626643 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{project}}"
from cache
02:33:36.626781 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tbl_project` `t` WHERE `t`.`id`='1' LIMIT 1
02:33:36.626787 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
02:33:36.627026 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
02:33:36.627357 trace system.caching.CMemCache
Serving "Informers_2022-01-23" from cache
02:33:36.627376 trace system.CModule
Loading "themeManager" application component
02:33:36.627556 trace system.CModule
Loading "widgetFactory" application component
02:33:36.627897 trace system.caching.CMemCache
Serving "MainNews_1" from cache
02:33:36.628611 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
02:33:36.628849 trace system.CModule
Loading "messages" application component
02:33:36.629173 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
02:33:36.629379 trace system.caching.CMemCache
Serving "MainNews_1" from cache
02:33:36.629575 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
02:33:36.629769 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
02:33:36.630091 trace system.db.CDbCommand
Querying SQL: SELECT p.id, p.name, p.create_time,
DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%H:%i") as tm, p.main,
p.main_project, p.content, p.comments, p.thumbnail, p.media_clone, f.id as
fid, f.name as filename, f.filepath, ps.section_id
FROM `tbl_publication` `p`
LEFT JOIN `tbl_files` `f` ON f.object_id = p.id AND f.object_name =
"Publication"
LEFT JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.id AND
ps.section_id = :infografika
WHERE p.status = :status AND p.hide_main = 0
ORDER BY `p`.`create_time` DESC LIMIT 9. Bound with :status=1,
:infografika=101
02:33:36.630094 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT p.id, p.name, p.create_time,
DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%H:%i") as tm, p.main,
p.main_project, p.content, p.comments, p.thumbnail, p.media_clone, f.id as
fid, f.name as filename, f.filepath, ps.section_id
FROM `tbl_publication` `p`
LEFT JOIN `tbl_files` `f` ON f.object_id = p.id AND f.object_name =
"Publication"
LEFT JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.id AND
ps.section_id = :infografika
WHERE p.status = :status AND p.hide_main = 0
ORDER BY `p`.`create_time` DESC LIMIT 9. Bound with :status=1,
:infografika=101)
02:33:36.630237 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT p.id, p.name, p.create_time,
DATE_FORMAT(FROM_UNIXTIME(p.create_time),"%H:%i") as tm, p.main,
p.main_project, p.content, p.comments, p.thumbnail, p.media_clone, f.id as
fid, f.name as filename, f.filepath, ps.section_id
FROM `tbl_publication` `p`
LEFT JOIN `tbl_files` `f` ON f.object_id = p.id AND f.object_name =
"Publication"
LEFT JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.id AND
ps.section_id = :infografika
WHERE p.status = :status AND p.hide_main = 0
ORDER BY `p`.`create_time` DESC LIMIT 9. Bound with :status=1,
:infografika=101)
02:33:36.630275 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377914'
02:33:36.630276 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377914')
02:33:36.630340 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377914')
02:33:36.630373 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377913'
02:33:36.630374 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377913')
02:33:36.630431 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377913')
02:33:36.630464 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377912'
02:33:36.630465 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377912')
02:33:36.630521 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377912')
02:33:36.630552 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377910'
02:33:36.630553 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377910')
02:33:36.630609 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377910')
02:33:36.630639 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377906'
02:33:36.630640 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377906')
02:33:36.630693 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377906')
02:33:36.630722 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377900'
02:33:36.630723 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377900')
02:33:36.630778 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377900')
02:33:36.630806 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377898'
02:33:36.630808 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377898')
02:33:36.630861 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377898')
02:33:36.630888 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377897'
02:33:36.630889 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377897')
02:33:36.630948 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377897')
02:33:36.630975 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377896'
02:33:36.630978 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377896')
02:33:36.631031 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`project_id`, `pr`.`urlname`
FROM `tbl_publication_project` `p`
JOIN `tbl_project` `pr` ON pr.id = p.project_id
WHERE p.pub_id = :id
ORDER BY `p`.`project_id` DESC LIMIT 1. Bound with :id='377896')
02:33:36.631594 trace system.caching.CMemCache
Saving "PublicationMain19" to cache
02:33:36.631794 trace system.caching.CMemCache
Serving "PublicationMain19" from cache
02:33:36.631851 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=2
02:33:36.631854 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=2)
02:33:36.631916 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=2)
02:33:36.631963 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=2,
:main=1
02:33:36.631964 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=2,
:main=1)
02:33:36.632031 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=2,
:main=1)
02:33:36.632080 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=8
02:33:36.632081 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=8)
02:33:36.632141 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=8)
02:33:36.632184 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=8,
:main=1
02:33:36.632184 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=8,
:main=1)
02:33:36.632246 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=8,
:main=1)
02:33:36.632289 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=6
02:33:36.632291 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=6)
02:33:36.632347 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=6)
02:33:36.632388 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=6,
:main=1
02:33:36.632390 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=6,
:main=1)
02:33:36.632858 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=6,
:main=1)
02:33:36.632900 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=4
02:33:36.632901 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=4)
02:33:36.632962 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=4)
02:33:36.633002 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=4,
:main=1
02:33:36.633003 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=4,
:main=1)
02:33:36.633069 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=4,
:main=1)
02:33:36.633110 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=5
02:33:36.633111 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=5)
02:33:36.633174 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=5)
02:33:36.633215 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=5,
:main=1
02:33:36.633217 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=5,
:main=1)
02:33:36.633279 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=5,
:main=1)
02:33:36.633318 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=7
02:33:36.633321 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=7)
02:33:36.633377 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=7)
02:33:36.633415 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=7,
:main=1
02:33:36.633418 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=7,
:main=1)
02:33:36.633480 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=7,
:main=1)
02:33:36.633521 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=99
02:33:36.633522 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=99)
02:33:36.633575 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=99)
02:33:36.633615 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=99,
:main=1
02:33:36.633615 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=99,
:main=1)
02:33:36.633677 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=99,
:main=1)
02:33:36.633718 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=98
02:33:36.633718 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=98)
02:33:36.633773 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=98)
02:33:36.633811 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=98,
:main=1
02:33:36.633815 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=98,
:main=1)
02:33:36.633879 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=98,
:main=1)
02:33:36.633919 trace system.db.CDbCommand
Querying SQL: SELECT `s`.`name` AS `sname`, `s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=277
02:33:36.633920 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`,
`s`.`urlname` AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=277)
02:33:36.633971 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `s`.`name` AS `sname`, `s`.`urlname`
AS `surl`
FROM `tbl_section` `s`
WHERE s.id = :sid. Bound with :sid=277)
02:33:36.634011 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`,
`p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=277,
:main=1
02:33:36.634011 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=277,
:main=1)
02:33:36.634073 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`content`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`, `p`.`comments`
FROM `tbl_publication` `p`
JOIN `tbl_publication_section` `ps` ON ps.pub_id = p.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.main = :main
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=277,
:main=1)
02:33:36.634203 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`quote` AS `content`,
`p`.`create_time`, `p`.`article`, `p`.`announce`, `p`.`comments`,
`p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath` AS `filepath`, `ff`.`id` AS `ffid`, `ff`.`name` AS
`ffilename`, `ff`.`filepath` AS `ffilepath`, `a`.`id` AS `aid`,
`a`.`username`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON p.id = pp.pub_id
LEFT JOIN `tbl_author` `a` ON p.authorid = a.id
LEFT JOIN `tbl_files` `f` ON f.object_id = a.id AND f.object_name =
"Author"
LEFT JOIN `tbl_files` `ff` ON ff.object_id = p.id AND ff.object_name =
"Publication"
WHERE p.status = :status AND p.hide_main = 0 AND (pp.project_id =
:blog_project OR p.article = :article)
GROUP BY `p`.`id`
ORDER BY `p`.`create_time` DESC LIMIT 7. Bound with :status=1,
:blog_project=4, :article=1
02:33:36.634206 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`quote`
AS `content`, `p`.`create_time`, `p`.`article`, `p`.`announce`,
`p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath` AS `filepath`, `ff`.`id` AS `ffid`, `ff`.`name`
AS `ffilename`, `ff`.`filepath` AS `ffilepath`, `a`.`id` AS `aid`,
`a`.`username`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON p.id = pp.pub_id
LEFT JOIN `tbl_author` `a` ON p.authorid = a.id
LEFT JOIN `tbl_files` `f` ON f.object_id = a.id AND f.object_name =
"Author"
LEFT JOIN `tbl_files` `ff` ON ff.object_id = p.id AND ff.object_name =
"Publication"
WHERE p.status = :status AND p.hide_main = 0 AND (pp.project_id =
:blog_project OR p.article = :article)
GROUP BY `p`.`id`
ORDER BY `p`.`create_time` DESC LIMIT 7. Bound with :status=1,
:blog_project=4, :article=1)
02:33:36.634293 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`quote` AS
`content`, `p`.`create_time`, `p`.`article`, `p`.`announce`,
`p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath` AS `filepath`, `ff`.`id` AS `ffid`, `ff`.`name`
AS `ffilename`, `ff`.`filepath` AS `ffilepath`, `a`.`id` AS `aid`,
`a`.`username`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON p.id = pp.pub_id
LEFT JOIN `tbl_author` `a` ON p.authorid = a.id
LEFT JOIN `tbl_files` `f` ON f.object_id = a.id AND f.object_name =
"Author"
LEFT JOIN `tbl_files` `ff` ON ff.object_id = p.id AND ff.object_name =
"Publication"
WHERE p.status = :status AND p.hide_main = 0 AND (pp.project_id =
:blog_project OR p.article = :article)
GROUP BY `p`.`id`
ORDER BY `p`.`create_time` DESC LIMIT 7. Bound with :status=1,
:blog_project=4, :article=1)
02:33:36.634721 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`quote` AS `content`,
`p`.`create_time`, `p`.`article`, `p`.`announce`, `p`.`comments`,
`p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath` AS `filepath`, `ff`.`id` AS `ffid`, `ff`.`name` AS
`ffilename`, `ff`.`filepath` AS `ffilepath`, `a`.`id` AS `aid`,
`a`.`username`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON p.id = pp.pub_id
LEFT JOIN `tbl_author` `a` ON p.authorid = a.id
LEFT JOIN `tbl_files` `f` ON f.object_id = a.id AND f.object_name =
"Author"
LEFT JOIN `tbl_files` `ff` ON ff.object_id = p.id AND ff.object_name =
"Publication"
WHERE p.status = :status AND p.hide_main = 0 AND (pp.project_id =
:blog_project OR p.article = :article)
GROUP BY `p`.`id`
ORDER BY `p`.`create_time` DESC LIMIT 7. Bound with :status=1,
:blog_project=4, :article=1
02:33:36.634722 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`quote`
AS `content`, `p`.`create_time`, `p`.`article`, `p`.`announce`,
`p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath` AS `filepath`, `ff`.`id` AS `ffid`, `ff`.`name`
AS `ffilename`, `ff`.`filepath` AS `ffilepath`, `a`.`id` AS `aid`,
`a`.`username`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON p.id = pp.pub_id
LEFT JOIN `tbl_author` `a` ON p.authorid = a.id
LEFT JOIN `tbl_files` `f` ON f.object_id = a.id AND f.object_name =
"Author"
LEFT JOIN `tbl_files` `ff` ON ff.object_id = p.id AND ff.object_name =
"Publication"
WHERE p.status = :status AND p.hide_main = 0 AND (pp.project_id =
:blog_project OR p.article = :article)
GROUP BY `p`.`id`
ORDER BY `p`.`create_time` DESC LIMIT 7. Bound with :status=1,
:blog_project=4, :article=1)
02:33:36.634802 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`quote` AS
`content`, `p`.`create_time`, `p`.`article`, `p`.`announce`,
`p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath` AS `filepath`, `ff`.`id` AS `ffid`, `ff`.`name`
AS `ffilename`, `ff`.`filepath` AS `ffilepath`, `a`.`id` AS `aid`,
`a`.`username`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON p.id = pp.pub_id
LEFT JOIN `tbl_author` `a` ON p.authorid = a.id
LEFT JOIN `tbl_files` `f` ON f.object_id = a.id AND f.object_name =
"Author"
LEFT JOIN `tbl_files` `ff` ON ff.object_id = p.id AND ff.object_name =
"Publication"
WHERE p.status = :status AND p.hide_main = 0 AND (pp.project_id =
:blog_project OR p.article = :article)
GROUP BY `p`.`id`
ORDER BY `p`.`create_time` DESC LIMIT 7. Bound with :status=1,
:blog_project=4, :article=1)
02:33:36.635413 trace system.db.CDbCommand
Querying SQL: SELECT b.id, b.urlname, b.name, b.hide_main, b.rotate,
b.sort, b.iframe, b.test, b.script, f.id as fid, f.filepath as filepath,
f.name as fname FROM tbl_commercial b LEFT JOIN tbl_files f ON b.id =
f.object_id AND f.object_name = "Commercial" WHERE b.place = :place AND
b.status = :status AND b.project_id LIKE :pid ORDER BY b.sort ASC LIMIT 20.
Bound with :place=5, :status=1, :pid='%1%'
02:33:36.635416 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT b.id, b.urlname, b.name,
b.hide_main, b.rotate, b.sort, b.iframe, b.test, b.script, f.id as fid,
f.filepath as filepath, f.name as fname FROM tbl_commercial b LEFT JOIN
tbl_files f ON b.id = f.object_id AND f.object_name = "Commercial" WHERE
b.place = :place AND b.status = :status AND b.project_id LIKE :pid ORDER BY
b.sort ASC LIMIT 20. Bound with :place=5, :status=1, :pid='%1%')
02:33:36.635481 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT b.id, b.urlname, b.name, b.hide_main,
b.rotate, b.sort, b.iframe, b.test, b.script, f.id as fid, f.filepath as
filepath, f.name as fname FROM tbl_commercial b LEFT JOIN tbl_files f ON
b.id = f.object_id AND f.object_name = "Commercial" WHERE b.place = :place
AND b.status = :status AND b.project_id LIKE :pid ORDER BY b.sort ASC LIMIT
20. Bound with :place=5, :status=1, :pid='%1%')
02:33:36.635498 trace system.db.CDbCommand
Querying SQL: SELECT * FROM tbl_commercial_section WHERE commercial_id =
:id. Bound with :id='230'
02:33:36.635499 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='230')
02:33:36.635550 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='230')
02:33:36.635555 trace system.caching.CMemCache
Saving "Commercial_51" to cache
02:33:36.635700 trace system.CModule
Loading "clientScript" application component
02:33:36.635821 trace system.caching.CMemCache
Serving "Commercial_21" from cache
02:33:36.635952 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
02:33:36.636068 trace system.db.CDbCommand
Querying SQL: SELECT `m`.`id`, `m`.`name`, `m`.`author`
FROM `tbl_media` `m`
WHERE m.status = :status AND hide_main = 0 AND type = :type AND
in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 1. Bound with :status=1, :type=5
02:33:36.636069 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`
FROM `tbl_media` `m`
WHERE m.status = :status AND hide_main = 0 AND type = :type AND
in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 1. Bound with :status=1, :type=5)
02:33:36.636147 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`
FROM `tbl_media` `m`
WHERE m.status = :status AND hide_main = 0 AND type = :type AND
in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 1. Bound with :status=1, :type=5)
02:33:36.636183 trace system.db.CDbCommand
Querying SQL: SELECT `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_files` `f`
WHERE f.object_id = :id AND f.object_name = "Media"
ORDER BY `f`.`main` DESC LIMIT 1. Bound with :id='26695'
02:33:36.636183 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_files` `f`
WHERE f.object_id = :id AND f.object_name = "Media"
ORDER BY `f`.`main` DESC LIMIT 1. Bound with :id='26695')
02:33:36.636236 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_files` `f`
WHERE f.object_id = :id AND f.object_name = "Media"
ORDER BY `f`.`main` DESC LIMIT 1. Bound with :id='26695')
02:33:36.636296 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
02:33:36.636384 trace system.db.CDbCommand
Querying SQL: SELECT `m`.`id`, `m`.`name`, `m`.`author`
FROM `tbl_media` `m`
WHERE m.status = :status AND hide_main = 0 AND type = :type AND
in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 1. Bound with :status=1, :type=5
02:33:36.636385 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`
FROM `tbl_media` `m`
WHERE m.status = :status AND hide_main = 0 AND type = :type AND
in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 1. Bound with :status=1, :type=5)
02:33:36.636441 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`
FROM `tbl_media` `m`
WHERE m.status = :status AND hide_main = 0 AND type = :type AND
in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 1. Bound with :status=1, :type=5)
02:33:36.636472 trace system.db.CDbCommand
Querying SQL: SELECT `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_files` `f`
WHERE f.object_id = :id AND f.object_name = "Media"
ORDER BY `f`.`main` DESC LIMIT 1. Bound with :id='26695'
02:33:36.636475 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_files` `f`
WHERE f.object_id = :id AND f.object_name = "Media"
ORDER BY `f`.`main` DESC LIMIT 1. Bound with :id='26695')
02:33:36.636524 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_files` `f`
WHERE f.object_id = :id AND f.object_name = "Media"
ORDER BY `f`.`main` DESC LIMIT 1. Bound with :id='26695')
02:33:36.636621 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
02:33:36.636728 trace system.db.CDbCommand
Querying SQL: SELECT `m`.`id`, `m`.`name`, `m`.`author`, `m`.`thumbnail`,
`f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_media` `m`
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Video"
WHERE m.status = :status AND hide_main = 0 AND (type = :type OR type =
:type2) AND in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 2. Bound with :status=1, :type=1,
:type2=7
02:33:36.636729 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`,
`m`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_media` `m`
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Video"
WHERE m.status = :status AND hide_main = 0 AND (type = :type OR type =
:type2) AND in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 2. Bound with :status=1, :type=1,
:type2=7)
02:33:36.636810 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`,
`m`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_media` `m`
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Video"
WHERE m.status = :status AND hide_main = 0 AND (type = :type OR type =
:type2) AND in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 2. Bound with :status=1, :type=1,
:type2=7)
02:33:36.636888 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
02:33:36.636980 trace system.db.CDbCommand
Querying SQL: SELECT `m`.`id`, `m`.`name`, `m`.`author`, `m`.`thumbnail`,
`f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_media` `m`
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Video"
WHERE m.status = :status AND hide_main = 0 AND (type = :type OR type =
:type2) AND in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 2. Bound with :status=1, :type=1,
:type2=7
02:33:36.636981 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`,
`m`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_media` `m`
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Video"
WHERE m.status = :status AND hide_main = 0 AND (type = :type OR type =
:type2) AND in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 2. Bound with :status=1, :type=1,
:type2=7)
02:33:36.637445 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `m`.`id`, `m`.`name`, `m`.`author`,
`m`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_media` `m`
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Video"
WHERE m.status = :status AND hide_main = 0 AND (type = :type OR type =
:type2) AND in_publication = 0
GROUP BY `m`.`id`
ORDER BY `m`.`create_time` DESC LIMIT 2. Bound with :status=1, :type=1,
:type2=7)
02:33:36.637665 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
02:33:36.637911 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`announce`, `p`.`content`,
`f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`, `s`.`urlname`
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
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=101
02:33:36.637914 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`announce`, `p`.`content`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`, `s`.`urlname`
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
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=101)
02:33:36.638117 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`announce`,
`p`.`content`, `f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`,
`s`.`urlname`
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
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=101)
02:33:36.638196 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
02:33:36.638359 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`announce`, `p`.`content`,
`f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`, `s`.`urlname`
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
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=101
02:33:36.638361 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`announce`, `p`.`content`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`, `s`.`urlname`
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
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=101)
02:33:36.638533 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`announce`,
`p`.`content`, `f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`,
`s`.`urlname`
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
ORDER BY `p`.`create_time` DESC LIMIT 1. Bound with :status=1, :sid=101)
02:33:36.638755 trace system.caching.CMemCache
Serving "Commercial_31" from cache
02:33:36.639386 trace system.caching.CMemCache
Deleting "Yii.COutputCache.projectThemes_1......." from cache
02:33:36.639542 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
02:33:36.639544 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)
02:33:36.639719 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)
02:33:36.640175 trace system.CModule
Loading "assetManager" application component