Смотреть все новости

Идет загрузка...
Журнал приложения
Время Уровень Категория Сообщение
21:20:34.145534 trace system.CModule
Loading "log" application component
21:20:34.145663 trace system.CModule
Loading "request" application component
21:20:34.145735 trace system.CModule
Loading "urlManager" application component
21:20:34.145764 trace system.CModule
Loading "cache" application component
21:20:34.147917 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
21:20:34.149455 trace system.caching.CMemCache
Saving "Yii.CUrlManager.rules" to cache
21:20:34.153063 trace system.CModule
Loading "session" application component
21:20:34.154448 trace system.web.filters.CFilterChain
Running filter SiteController.filterrights()
21:20:34.154558 trace system.CModule
Loading "user" application component
21:20:34.154831 trace system.CModule
Loading "securityManager" application component
21:20:34.155100 trace system.db.ar.CActiveRecord
Project.findByPk()
21:20:34.155109 trace system.CModule
Loading "db" application component
21:20:34.155159 trace system.db.CDbConnection
Opening DB connection
21:20:34.156658 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{project}}"
from cache
21:20:34.156821 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tbl_project` `t` WHERE `t`.`id`='1' LIMIT 1
21:20:34.156827 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
21:20:34.157063 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
21:20:34.157547 trace system.caching.CMemCache
Serving "Informers_2021-12-07" from cache
21:20:34.157562 trace system.CModule
Loading "themeManager" application component
21:20:34.157759 trace system.CModule
Loading "widgetFactory" application component
21:20:34.158153 trace system.caching.CMemCache
Serving "MainNews_1" from cache
21:20:34.158938 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
21:20:34.159456 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
21:20:34.159545 trace system.CModule
Loading "messages" application component
21:20:34.160082 trace system.caching.CMemCache
Serving "MainNews_1" from cache
21:20:34.160262 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
21:20:34.160440 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
21:20:34.160871 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
21:20:34.160873 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)
21:20:34.162281 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)
21:20:34.162328 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='373617'
21:20:34.162329 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='373617')
21:20:34.162396 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='373617')
21:20:34.162431 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='373616'
21:20:34.162432 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='373616')
21:20:34.162489 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='373616')
21:20:34.162520 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='373615'
21:20:34.162522 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='373615')
21:20:34.162575 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='373615')
21:20:34.162605 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='373614'
21:20:34.162606 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='373614')
21:20:34.162658 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='373614')
21:20:34.162687 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='373613'
21:20:34.162688 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='373613')
21:20:34.162740 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='373613')
21:20:34.162770 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='373612'
21:20:34.162770 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='373612')
21:20:34.168726 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='373612')
21:20:34.168772 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='373611'
21:20:34.168773 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='373611')
21:20:34.169356 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='373611')
21:20:34.169390 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='373610'
21:20:34.169392 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='373610')
21:20:34.170696 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='373610')
21:20:34.170742 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='373609'
21:20:34.170743 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='373609')
21:20:34.171084 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='373609')
21:20:34.171699 trace system.caching.CMemCache
Saving "PublicationMain19" to cache
21:20:34.172002 trace system.caching.CMemCache
Serving "PublicationMain19" from cache
21:20:34.172086 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
21:20:34.172090 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)
21:20:34.172245 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)
21:20:34.172322 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
21:20:34.172323 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)
21:20:34.172473 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)
21:20:34.172548 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
21:20:34.172549 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)
21:20:34.172641 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)
21:20:34.172708 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
21:20:34.172709 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)
21:20:34.172810 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)
21:20:34.172907 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
21:20:34.172909 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)
21:20:34.172995 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)
21:20:34.173053 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
21:20:34.173053 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)
21:20:34.173147 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)
21:20:34.173206 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
21:20:34.173207 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)
21:20:34.173286 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)
21:20:34.173342 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
21:20:34.173345 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)
21:20:34.173429 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)
21:20:34.173485 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
21:20:34.173487 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)
21:20:34.173568 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)
21:20:34.173623 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
21:20:34.173624 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)
21:20:34.173710 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)
21:20:34.173764 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
21:20:34.173767 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)
21:20:34.173844 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)
21:20:34.173898 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
21:20:34.173899 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)
21:20:34.173984 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)
21:20:34.174038 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
21:20:34.174041 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)
21:20:34.174115 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)
21:20:34.174170 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
21:20:34.174173 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)
21:20:34.174263 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)
21:20:34.174318 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
21:20:34.174319 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)
21:20:34.174391 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)
21:20:34.174447 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
21:20:34.174448 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)
21:20:34.174532 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)
21:20:34.174587 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
21:20:34.174588 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)
21:20:34.174659 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)
21:20:34.174714 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
21:20:34.174715 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)
21:20:34.174799 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)
21:20:34.174994 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
21:20:34.174997 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)
21:20:34.175112 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)
21:20:34.175693 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
21:20:34.175694 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)
21:20:34.175800 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)
21:20:34.176700 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%'
21:20:34.176701 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%')
21:20:34.177409 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%')
21:20:34.177434 trace system.db.CDbCommand
Querying SQL: SELECT * FROM tbl_commercial_section WHERE commercial_id =
:id. Bound with :id='230'
21:20:34.177437 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='230')
21:20:34.179985 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='230')
21:20:34.179994 trace system.caching.CMemCache
Saving "Commercial_51" to cache
21:20:34.180224 trace system.CModule
Loading "clientScript" application component
21:20:34.180365 trace system.caching.CMemCache
Serving "Commercial_21" from cache
21:20:34.180521 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
21:20:34.180658 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
21:20:34.180661 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)
21:20:34.180768 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)
21:20:34.180821 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='26466'
21:20:34.180824 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='26466')
21:20:34.180932 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='26466')
21:20:34.181020 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
21:20:34.181179 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
21:20:34.181180 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)
21:20:34.181278 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)
21:20:34.181309 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='26466'
21:20:34.181310 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='26466')
21:20:34.181366 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='26466')
21:20:34.181524 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
21:20:34.181689 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
21:20:34.181690 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)
21:20:34.181797 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)
21:20:34.181896 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
21:20:34.182054 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
21:20:34.182055 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)
21:20:34.182157 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)
21:20:34.182336 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
21:20:34.182498 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
21:20:34.182502 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)
21:20:34.182609 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)
21:20:34.182661 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
21:20:34.182847 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
21:20:34.182851 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)
21:20:34.183002 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)
21:20:34.183274 trace system.caching.CMemCache
Serving "Commercial_31" from cache
21:20:34.184149 trace system.caching.CMemCache
Deleting "Yii.COutputCache.projectThemes_1......." from cache
21:20:34.184340 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
21:20:34.184341 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)
21:20:34.184457 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)
21:20:34.184782 trace system.CModule
Loading "assetManager" application component