Идет загрузка...
Журнал приложения
Время Уровень Категория Сообщение
20:22:17.878456 trace system.CModule
Loading "log" application component
20:22:17.878711 trace system.CModule
Loading "request" application component
20:22:17.878844 trace system.CModule
Loading "urlManager" application component
20:22:17.878902 trace system.CModule
Loading "cache" application component
20:22:17.881186 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
20:22:17.882335 trace system.caching.CMemCache
Saving "Yii.CUrlManager.rules" to cache
20:22:17.885638 trace system.CModule
Loading "session" application component
20:22:17.887192 trace system.web.filters.CFilterChain
Running filter SiteController.filterrights()
20:22:17.887315 trace system.CModule
Loading "user" application component
20:22:17.887617 trace system.CModule
Loading "securityManager" application component
20:22:17.887922 trace system.db.ar.CActiveRecord
Project.findByPk()
20:22:17.887933 trace system.CModule
Loading "db" application component
20:22:17.887990 trace system.db.CDbConnection
Opening DB connection
20:22:17.889561 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{project}}"
from cache
20:22:17.889740 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tbl_project` `t` WHERE `t`.`id`='1' LIMIT 1
20:22:17.889746 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
20:22:17.889991 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tbl_project` `t` WHERE
`t`.`id`='1' LIMIT 1)
20:22:17.890439 trace system.caching.CMemCache
Serving "Informers_2021-12-07" from cache
20:22:17.890448 trace system.CModule
Loading "themeManager" application component
20:22:17.890553 trace system.CModule
Loading "widgetFactory" application component
20:22:17.890755 trace system.caching.CMemCache
Serving "MainNews_1" from cache
20:22:17.891160 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
20:22:17.891349 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
20:22:17.891386 trace system.CModule
Loading "messages" application component
20:22:17.891663 trace system.caching.CMemCache
Serving "MainNews_1" from cache
20:22:17.891846 trace system.caching.CMemCache
Serving "PopularNews_1" from cache
20:22:17.892026 trace system.caching.CMemCache
Serving "DiscussedNews_1" from cache
20:22:17.892442 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
20:22:17.892445 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)
20:22:17.893357 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)
20:22:17.893399 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'
20:22:17.893399 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')
20:22:17.893466 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')
20:22:17.893502 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'
20:22:17.893503 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')
20:22:17.893563 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')
20:22:17.893595 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'
20:22:17.893596 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')
20:22:17.893651 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')
20:22:17.893682 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'
20:22:17.893683 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')
20:22:17.893738 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')
20:22:17.893769 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'
20:22:17.893770 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')
20:22:17.893825 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')
20:22:17.893855 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'
20:22:17.893856 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')
20:22:17.893909 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')
20:22:17.893939 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='373608'
20:22:17.893940 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='373608')
20:22:17.893996 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='373608')
20:22:17.894026 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='373607'
20:22:17.894027 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='373607')
20:22:17.894084 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='373607')
20:22:17.894114 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='373606'
20:22:17.894115 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='373606')
20:22:17.894171 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='373606')
20:22:17.894782 trace system.caching.CMemCache
Saving "PublicationMain19" to cache
20:22:17.895004 trace system.caching.CMemCache
Serving "PublicationMain19" from cache
20:22:17.895061 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
20:22:17.895064 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)
20:22:17.895124 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)
20:22:17.895174 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
20:22:17.895175 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)
20:22:17.895239 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)
20:22:17.895287 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
20:22:17.895288 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)
20:22:17.895347 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)
20:22:17.895390 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
20:22:17.895390 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)
20:22:17.895454 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)
20:22:17.895498 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
20:22:17.895498 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)
20:22:17.895555 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)
20:22:17.895596 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
20:22:17.895597 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)
20:22:17.895674 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)
20:22:17.895716 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
20:22:17.895718 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)
20:22:17.895773 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)
20:22:17.895814 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
20:22:17.895816 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)
20:22:17.895878 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)
20:22:17.895919 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
20:22:17.895920 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)
20:22:17.895977 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)
20:22:17.896018 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
20:22:17.896019 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)
20:22:17.896079 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)
20:22:17.896120 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
20:22:17.896121 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)
20:22:17.896178 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)
20:22:17.896218 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
20:22:17.896219 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)
20:22:17.896281 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)
20:22:17.896322 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
20:22:17.896322 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)
20:22:17.896378 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)
20:22:17.896419 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
20:22:17.896420 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)
20:22:17.896488 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)
20:22:17.896528 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
20:22:17.896529 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)
20:22:17.896584 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)
20:22:17.896622 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
20:22:17.896624 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)
20:22:17.896684 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)
20:22:17.896724 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
20:22:17.896725 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)
20:22:17.896778 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)
20:22:17.896817 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
20:22:17.896819 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)
20:22:17.896886 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)
20:22:17.897020 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
20:22:17.897021 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)
20:22:17.897104 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)
20:22:17.897531 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
20:22:17.897532 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)
20:22:17.897610 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)
20:22:17.898212 trace system.caching.CMemCache
Serving "Commercial_51" from cache
20:22:17.898310 trace system.CModule
Loading "clientScript" application component
20:22:17.898498 trace system.caching.CMemCache
Serving "Commercial_21" from cache
20:22:17.898649 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
20:22:17.898785 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
20:22:17.898787 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)
20:22:17.898847 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)
20:22:17.898885 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'
20:22:17.898885 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')
20:22:17.898952 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')
20:22:17.899009 trace system.caching.CMemCache
Deleting "Yii.COutputCache.photoLenta_1......." from cache
20:22:17.899121 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
20:22:17.899121 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)
20:22:17.899195 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)
20:22:17.899226 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'
20:22:17.899228 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')
20:22:17.899281 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')
20:22:17.899374 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
20:22:17.899477 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
20:22:17.899480 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)
20:22:17.899559 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)
20:22:17.899638 trace system.caching.CMemCache
Deleting "Yii.COutputCache.videoLenta1......." from cache
20:22:17.899758 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
20:22:17.899760 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)
20:22:17.899837 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)
20:22:17.899976 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
20:22:17.900084 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
20:22:17.900085 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)
20:22:17.900175 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)
20:22:17.900226 trace system.caching.CMemCache
Deleting "Yii.COutputCache.Infografika......." from cache
20:22:17.900309 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
20:22:17.900310 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)
20:22:17.900372 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)
20:22:17.900511 trace system.caching.CMemCache
Serving "Commercial_31" from cache
20:22:17.901114 trace system.caching.CMemCache
Deleting "Yii.COutputCache.projectThemes_1......." from cache
20:22:17.901276 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
20:22:17.901278 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)
20:22:17.901387 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)
20:22:17.901721 trace system.CModule
Loading "assetManager" application component