Идет загрузка...
Журнал приложения
Время Уровень Категория Сообщение
10:34:34.684514 trace system.CModule
Loading "log" application component
10:34:34.684592 trace system.CModule
Loading "request" application component
10:34:34.684643 trace system.CModule
Loading "urlManager" application component
10:34:34.684664 trace system.CModule
Loading "cache" application component
10:34:34.685662 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
10:34:34.686227 trace system.caching.CMemCache
Saving "Yii.CUrlManager.rules" to cache
10:34:34.687511 trace system.CModule
Loading "session" application component
10:34:34.688038 trace system.web.filters.CFilterChain
Running filter SiteController.filterrights()
10:34:34.688055 trace system.CModule
Loading "user" application component
10:34:34.688112 trace system.CModule
Loading "securityManager" application component
10:34:34.688199 trace system.db.ar.CActiveRecord
Project.findByPk()
10:34:34.688205 trace system.CModule
Loading "db" application component
10:34:34.688222 trace system.db.CDbConnection
Opening DB connection
10:34:34.688838 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{project}}"
from cache
10:34:34.688909 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tbl_project` `t` WHERE `t`.`id`='1' LIMIT 1
10:34:34.688911 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
10:34:34.688996 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
10:34:34.689141 trace system.caching.CMemCache
Serving "Informers_2021-10-26" from cache
10:34:34.689147 trace system.CModule
Loading "themeManager" application component
10:34:34.689238 trace system.CModule
Loading "widgetFactory" application component
10:34:34.689405 trace system.caching.CMemCache
Serving "MainNews_1" from cache
10:34:34.689744 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
10:34:34.689950 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
10:34:34.689992 trace system.CModule
Loading "messages" application component
10:34:34.690232 trace system.caching.CMemCache
Serving "MainNews_1" from cache
10:34:34.690423 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
10:34:34.690610 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
10:34:34.690949 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
10:34:34.690951 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)
10:34:34.691832 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)
10:34:34.691870 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='369288'
10:34:34.691871 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='369288')
10:34:34.691937 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='369288')
10:34:34.691972 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='369286'
10:34:34.691972 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='369286')
10:34:34.692168 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='369286')
10:34:34.692202 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='369285'
10:34:34.692203 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='369285')
10:34:34.692261 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='369285')
10:34:34.692295 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='369284'
10:34:34.692296 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='369284')
10:34:34.692351 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='369284')
10:34:34.692382 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='369283'
10:34:34.692383 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='369283')
10:34:34.692440 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='369283')
10:34:34.692471 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='369282'
10:34:34.692472 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='369282')
10:34:34.692528 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='369282')
10:34:34.692559 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='369280'
10:34:34.692559 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='369280')
10:34:34.692612 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='369280')
10:34:34.692643 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='369279'
10:34:34.692646 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='369279')
10:34:34.692698 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='369279')
10:34:34.692729 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='369278'
10:34:34.692730 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='369278')
10:34:34.692787 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='369278')
10:34:34.693319 trace system.caching.CMemCache
Saving "PublicationMain19" to cache
10:34:34.693485 trace system.caching.CMemCache
Serving "PublicationMain19" from cache
10:34:34.693542 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
10:34:34.693543 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)
10:34:34.693617 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)
10:34:34.693662 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
10:34:34.693665 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)
10:34:34.693732 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)
10:34:34.693778 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
10:34:34.693780 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)
10:34:34.693836 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)
10:34:34.693878 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
10:34:34.693880 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)
10:34:34.693944 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)
10:34:34.693985 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
10:34:34.693988 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)
10:34:34.694045 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)
10:34:34.694083 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
10:34:34.694084 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)
10:34:34.694149 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)
10:34:34.694189 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
10:34:34.694190 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)
10:34:34.694247 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)
10:34:34.694284 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
10:34:34.694286 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)
10:34:34.694348 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)
10:34:34.694387 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
10:34:34.694389 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)
10:34:34.694444 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)
10:34:34.694483 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
10:34:34.694484 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)
10:34:34.694554 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)
10:34:34.694598 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
10:34:34.694600 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)
10:34:34.694657 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)
10:34:34.694695 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
10:34:34.694696 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)
10:34:34.694757 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)
10:34:34.694797 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
10:34:34.694799 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)
10:34:34.694852 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)
10:34:34.694890 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
10:34:34.694890 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)
10:34:34.694951 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)
10:34:34.694991 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
10:34:34.694992 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)
10:34:34.695044 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)
10:34:34.695081 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
10:34:34.695082 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)
10:34:34.695143 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)
10:34:34.695183 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
10:34:34.695183 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)
10:34:34.695235 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)
10:34:34.695272 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
10:34:34.695274 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)
10:34:34.695334 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)
10:34:34.695466 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
10:34:34.695468 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)
10:34:34.695554 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)
10:34:34.695969 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
10:34:34.695971 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)
10:34:34.696048 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)
10:34:34.696542 trace system.caching.CMemCache
Serving "Commercial_51" from cache
10:34:34.696615 trace system.CModule
Loading "clientScript" application component
10:34:34.696736 trace system.caching.CMemCache
Serving "Commercial_21" from cache
10:34:34.696893 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
10:34:34.697007 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
10:34:34.697009 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)
10:34:34.697072 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)
10:34:34.697104 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='26243'
10:34:34.697105 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='26243')
10:34:34.697169 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='26243')
10:34:34.697230 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
10:34:34.697312 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
10:34:34.697314 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)
10:34:34.697371 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)
10:34:34.697401 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='26243'
10:34:34.697402 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='26243')
10:34:34.697453 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='26243')
10:34:34.697551 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
10:34:34.697649 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
10:34:34.697649 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)
10:34:34.697737 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)
10:34:34.697815 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
10:34:34.697906 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
10:34:34.697907 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)
10:34:34.697968 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)
10:34:34.698107 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
10:34:34.698205 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
10:34:34.698208 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)
10:34:34.698323 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)
10:34:34.698385 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
10:34:34.698476 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
10:34:34.698477 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)
10:34:34.698542 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)
10:34:34.698677 trace system.caching.CMemCache
Serving "Commercial_31" from cache
10:34:34.699209 trace system.caching.CMemCache
Deleting "Yii.COutputCache.projectThemes_1......." from cache
10:34:34.699305 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
10:34:34.699306 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)
10:34:34.699419 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)
10:34:34.699718 trace system.CModule
Loading "assetManager" application component