Идет загрузка...
Журнал приложения
Время Уровень Категория Сообщение
21:10:39.662962 trace system.CModule
Loading "log" application component
21:10:39.663342 trace system.CModule
Loading "request" application component
21:10:39.663599 trace system.CModule
Loading "urlManager" application component
21:10:39.663724 trace system.CModule
Loading "cache" application component
21:10:39.666414 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
21:10:39.671776 trace system.caching.CMemCache
Saving "Yii.CUrlManager.rules" to cache
21:10:39.675637 trace system.CModule
Loading "session" application component
21:10:39.679241 trace system.web.filters.CFilterChain
Running filter SiteController.filterrights()
21:10:39.679301 trace system.CModule
Loading "user" application component
21:10:39.679485 trace system.CModule
Loading "securityManager" application component
21:10:39.679848 trace system.db.ar.CActiveRecord
Project.findByPk()
21:10:39.679862 trace system.CModule
Loading "db" application component
21:10:39.679928 trace system.db.CDbConnection
Opening DB connection
21:10:39.681874 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{project}}"
from cache
21:10:39.682070 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tbl_project` `t` WHERE `t`.`id`='1' LIMIT 1
21:10:39.682080 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
21:10:39.682424 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
21:10:39.682883 trace system.caching.CMemCache
Serving "Informers_2021-06-15" from cache
21:10:39.682913 trace system.CModule
Loading "themeManager" application component
21:10:39.683119 trace system.CModule
Loading "widgetFactory" application component
21:10:39.684010 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`, `p`.`main`,
`p`.`content`, `p`.`comments`, `p`.`thumbnail`, `p`.`fixed_on_main`,
`f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.fixed_on_main > 0 OR mainmain = :main) AND
pp.project_id = :projectId
ORDER BY `p`.`fixed_on_main` DESC, `p`.`main_prioritet` DESC,
`p`.`create_time` DESC LIMIT 4. Bound with :status=1, :main=1, :projectId=1
21:10:39.684016 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `p`.`fixed_on_main`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.fixed_on_main > 0 OR mainmain = :main) AND
pp.project_id = :projectId
ORDER BY `p`.`fixed_on_main` DESC, `p`.`main_prioritet` DESC,
`p`.`create_time` DESC LIMIT 4. Bound with :status=1, :main=1,
:projectId=1)
21:10:39.684364 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `p`.`fixed_on_main`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.fixed_on_main > 0 OR mainmain = :main) AND
pp.project_id = :projectId
ORDER BY `p`.`fixed_on_main` DESC, `p`.`main_prioritet` DESC,
`p`.`create_time` DESC LIMIT 4. Bound with :status=1, :main=1,
:projectId=1)
21:10:39.686036 trace system.caching.CMemCache
Saving "MainNews_1" to cache
21:10:39.687597 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
21:10:39.688762 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`, `p`.`main`,
`p`.`content`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.create_time >= UNIX_TIMESTAMP( DATE_SUB(
CURRENT_DATE, INTERVAL :days DAY ))) AND pp.project_id = :projectId
ORDER BY `p`.`comments` DESC, `p`.`create_time` DESC LIMIT 4. Bound with
:status=1, :days=5, :projectId=1
21:10:39.688771 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.create_time >= UNIX_TIMESTAMP( DATE_SUB(
CURRENT_DATE, INTERVAL :days DAY ))) AND pp.project_id = :projectId
ORDER BY `p`.`comments` DESC, `p`.`create_time` DESC LIMIT 4. Bound with
:status=1, :days=5, :projectId=1)
21:10:39.715262 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.create_time >= UNIX_TIMESTAMP( DATE_SUB(
CURRENT_DATE, INTERVAL :days DAY ))) AND pp.project_id = :projectId
ORDER BY `p`.`comments` DESC, `p`.`create_time` DESC LIMIT 4. Bound with
:status=1, :days=5, :projectId=1)
21:10:39.718302 trace system.caching.CMemCache
Saving "DiscussedNews_1" to cache
21:10:39.719022 trace system.CModule
Loading "messages" application component
21:10:39.720725 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`, `p`.`main`,
`p`.`content`, `p`.`comments`, `p`.`thumbnail`, `p`.`fixed_on_main`,
`f`.`id` AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.fixed_on_main > 0 OR mainmain = :main) AND
pp.project_id = :projectId
ORDER BY `p`.`fixed_on_main` DESC, `p`.`main_prioritet` DESC,
`p`.`create_time` DESC LIMIT 4. Bound with :status=1, :main=1, :projectId=1
21:10:39.720737 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `p`.`fixed_on_main`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.fixed_on_main > 0 OR mainmain = :main) AND
pp.project_id = :projectId
ORDER BY `p`.`fixed_on_main` DESC, `p`.`main_prioritet` DESC,
`p`.`create_time` DESC LIMIT 4. Bound with :status=1, :main=1,
:projectId=1)
21:10:39.721168 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `p`.`fixed_on_main`, `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.fixed_on_main > 0 OR mainmain = :main) AND
pp.project_id = :projectId
ORDER BY `p`.`fixed_on_main` DESC, `p`.`main_prioritet` DESC,
`p`.`create_time` DESC LIMIT 4. Bound with :status=1, :main=1,
:projectId=1)
21:10:39.723937 trace system.caching.CMemCache
Saving "MainNews_1" to cache
21:10:39.725294 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
21:10:39.726553 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`create_time`, `p`.`main`,
`p`.`content`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.create_time >= UNIX_TIMESTAMP( DATE_SUB(
CURRENT_DATE, INTERVAL :days DAY ))) AND pp.project_id = :projectId
ORDER BY `p`.`comments` DESC, `p`.`create_time` DESC LIMIT 4. Bound with
:status=1, :days=5, :projectId=1
21:10:39.726562 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.create_time >= UNIX_TIMESTAMP( DATE_SUB(
CURRENT_DATE, INTERVAL :days DAY ))) AND pp.project_id = :projectId
ORDER BY `p`.`comments` DESC, `p`.`create_time` DESC LIMIT 4. Bound with
:status=1, :days=5, :projectId=1)
21:10:39.747937 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`create_time`, `p`.`main`, `p`.`content`, `p`.`comments`,
`p`.`thumbnail`, `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`
FROM `tbl_publication` `p`
JOIN `tbl_publication_project` `pp` ON pp.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 (p.create_time >= UNIX_TIMESTAMP( DATE_SUB(
CURRENT_DATE, INTERVAL :days DAY ))) AND pp.project_id = :projectId
ORDER BY `p`.`comments` DESC, `p`.`create_time` DESC LIMIT 4. Bound with
:status=1, :days=5, :projectId=1)
21:10:39.750941 trace system.caching.CMemCache
Saving "DiscussedNews_1" to cache
21:10:39.753099 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:10:39.753113 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:10:39.755198 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:10:39.755444 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='357766'
21:10:39.755453 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='357766')
21:10:39.755798 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='357766')
21:10:39.756042 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='357765'
21:10:39.756052 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='357765')
21:10:39.756361 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='357765')
21:10:39.756606 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='357764'
21:10:39.756616 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='357764')
21:10:39.756954 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='357764')
21:10:39.757195 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='357763'
21:10:39.757205 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='357763')
21:10:39.757541 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='357763')
21:10:39.757782 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='357762'
21:10:39.757792 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='357762')
21:10:39.758065 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='357762')
21:10:39.758306 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='357761'
21:10:39.758316 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='357761')
21:10:39.758626 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='357761')
21:10:39.758867 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='357760'
21:10:39.758878 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='357760')
21:10:39.759247 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='357760')
21:10:39.759489 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='357759'
21:10:39.759499 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='357759')
21:10:39.759805 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='357759')
21:10:39.760047 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='357758'
21:10:39.760057 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='357758')
21:10:39.760329 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='357758')
21:10:39.767071 trace system.caching.CMemCache
Saving "PublicationMain19" to cache
21:10:39.768007 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:10:39.768021 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:10:39.768506 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:10:39.768738 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='357766'
21:10:39.768748 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='357766')
21:10:39.769013 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='357766')
21:10:39.769256 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='357765'
21:10:39.769265 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='357765')
21:10:39.769649 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='357765')
21:10:39.769890 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='357764'
21:10:39.769898 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='357764')
21:10:39.770231 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='357764')
21:10:39.770471 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='357763'
21:10:39.770479 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='357763')
21:10:39.770817 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='357763')
21:10:39.771056 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='357762'
21:10:39.771066 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='357762')
21:10:39.771342 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='357762')
21:10:39.771620 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='357761'
21:10:39.771630 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='357761')
21:10:39.771950 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='357761')
21:10:39.772134 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='357760'
21:10:39.772140 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='357760')
21:10:39.772399 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='357760')
21:10:39.772584 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='357759'
21:10:39.772592 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='357759')
21:10:39.772851 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='357759')
21:10:39.773039 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='357758'
21:10:39.773046 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='357758')
21:10:39.773230 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='357758')
21:10:39.777707 trace system.caching.CMemCache
Saving "PublicationMain19" to cache
21:10:39.778366 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:10:39.778373 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:10:39.778676 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:10:39.778956 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:10:39.778964 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:10:39.779272 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:10:39.779580 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:10:39.779586 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:10:39.779841 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:10:39.780102 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:10:39.780109 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:10:39.780396 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:10:39.780694 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:10:39.780700 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:10:39.780951 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:10:39.781214 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:10:39.781222 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:10:39.781446 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:10:39.781727 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:10:39.781733 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:10:39.781982 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:10:39.782243 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:10:39.782248 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:10:39.782516 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:10:39.782803 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:10:39.782809 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:10:39.783052 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:10:39.783314 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:10:39.783325 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:10:39.783591 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:10:39.783874 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:10:39.783880 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:10:39.784123 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:10:39.784382 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:10:39.784389 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:10:39.784650 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:10:39.784933 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:10:39.784939 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:10:39.785183 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:10:39.785443 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:10:39.785449 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:10:39.785712 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:10:39.785993 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:10:39.785999 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:10:39.786245 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:10:39.786504 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:10:39.786510 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:10:39.786772 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:10:39.787053 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:10:39.787060 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:10:39.787306 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:10:39.787594 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:10:39.787601 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:10:39.787862 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:10:39.788479 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:10:39.788487 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:10:39.788786 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:10:39.792568 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:10:39.792577 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:10:39.792773 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:10:39.796643 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:10:39.796650 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:10:39.797267 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:10:39.797319 trace system.db.CDbCommand
Querying SQL: SELECT * FROM tbl_commercial_section WHERE commercial_id =
:id. Bound with :id='230'
21:10:39.797326 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='230')
21:10:39.799705 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='230')
21:10:39.799722 trace system.caching.CMemCache
Saving "Commercial_51" to cache
21:10:39.800219 trace system.CModule
Loading "clientScript" application component
21:10:39.800682 trace system.caching.CMemCache
Serving "Commercial_21" from cache
21:10:39.801208 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
21:10:39.801724 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:10:39.801733 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:10:39.801999 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:10:39.802160 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='25269'
21:10:39.802166 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='25269')
21:10:39.802386 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='25269')
21:10:39.802716 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
21:10:39.803144 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:10:39.803150 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:10:39.803369 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:10:39.803548 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='25269'
21:10:39.803554 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='25269')
21:10:39.803684 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='25269')
21:10:39.804042 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
21:10:39.804522 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:10:39.804529 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:10:39.804797 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:10:39.805316 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
21:10:39.805802 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:10:39.805808 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:10:39.806041 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:10:39.806653 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
21:10:39.807178 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:10:39.807183 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:10:39.807420 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:10:39.807846 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
21:10:39.808381 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:10:39.808389 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:10:39.808623 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:10:39.809298 trace system.caching.CMemCache
Serving "Commercial_31" from cache
21:10:39.811374 trace system.caching.CMemCache
Deleting "Yii.COutputCache.projectThemes_1......." from cache
21:10:39.811732 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:10:39.811741 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:10:39.811978 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:10:39.813921 trace system.CModule
Loading "assetManager" application component