Встречаем 2020-й: Лучшие места для новогодних вечеров в Псковской области

До Нового Года осталось не так уж и много времени. Пора выбирать место, где можно будет отлично проводить 2019-й в компании коллег на корпоративе и где можно встреть 2020-й в кругу семьи и друзей. В нашей подборке - именно такие места.

ОТКРЫТЬ КАТАЛОГ >>>

Версия для печати

Как часто пользуетесь онлайн магазинами?

Проголосовать >>>


Идет загрузка...
Журнал приложения
Время Уровень Категория Сообщение
21:55:57.127772 trace system.CModule
Loading "log" application component
21:55:57.128179 trace system.CModule
Loading "request" application component
21:55:57.128408 trace system.CModule
Loading "urlManager" application component
21:55:57.128532 trace system.CModule
Loading "cache" application component
21:55:57.132066 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
21:55:57.138438 trace system.caching.CMemCache
Saving "Yii.CUrlManager.rules" to cache
21:55:57.142496 trace system.base.CModule
Loading "publication" module
21:55:57.143042 trace system.CModule
Loading "session" application component
21:55:57.147177 trace system.web.filters.CFilterChain
Running filter PublicationController.filterrights()
21:55:57.147248 trace system.CModule
Loading "user" application component
21:55:57.147463 trace system.CModule
Loading "securityManager" application component
21:55:57.147955 trace system.db.ar.CActiveRecord
Publication.findByPk()
21:55:57.147973 trace system.CModule
Loading "db" application component
21:55:57.148086 trace system.db.CDbConnection
Opening DB connection
21:55:57.150381 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{publication}}"
from cache
21:55:57.150654 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tbl_publication` `t` WHERE `t`.`id`='308421'
AND (status = :status AND media_clone = 0) LIMIT 1. Bound with :status=1
21:55:57.150665 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tbl_publication` `t` WHERE
`t`.`id`='308421' AND (status = :status AND media_clone = 0) LIMIT 1. Bound
with :status=1)
21:55:57.151495 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tbl_publication` `t` WHERE
`t`.`id`='308421' AND (status = :status AND media_clone = 0) LIMIT 1. Bound
with :status=1)
21:55:57.151824 trace system.db.CDbCommand
Querying SQL: SELECT `id`
FROM `tbl_publication_counter`
WHERE publication_id = :id AND DATE(FROM_UNIXTIME(cdate)) = DATE(NOW())
LIMIT 1. Bound with :id='308421'
21:55:57.151832 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `id`
FROM `tbl_publication_counter`
WHERE publication_id = :id AND DATE(FROM_UNIXTIME(cdate)) = DATE(NOW())
LIMIT 1. Bound with :id='308421')
21:55:57.154875 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `id`
FROM `tbl_publication_counter`
WHERE publication_id = :id AND DATE(FROM_UNIXTIME(cdate)) = DATE(NOW())
LIMIT 1. Bound with :id='308421')
21:55:57.155035 trace system.db.CDbCommand
Executing SQL: UPDATE `tbl_publication_counter` SET `viewed`=(viewed+1)
WHERE publication_id = :id AND DATE(FROM_UNIXTIME(cdate)) = DATE(NOW()).
Bound with :id='308421'
21:55:57.155042 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(UPDATE `tbl_publication_counter` SET
`viewed`=(viewed+1) WHERE publication_id = :id AND
DATE(FROM_UNIXTIME(cdate)) = DATE(NOW()). Bound with :id='308421')
21:55:57.158046 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(UPDATE `tbl_publication_counter` SET
`viewed`=(viewed+1) WHERE publication_id = :id AND
DATE(FROM_UNIXTIME(cdate)) = DATE(NOW()). Bound with :id='308421')
21:55:57.158288 trace system.db.CDbCommand
Querying SQL: SELECT image FROM tbl_publication_image WHERE pub_id = :id.
Bound with :id='308421'
21:55:57.158293 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT image FROM tbl_publication_image
WHERE pub_id = :id. Bound with :id='308421')
21:55:57.158464 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT image FROM tbl_publication_image
WHERE pub_id = :id. Bound with :id='308421')
21:55:57.158591 trace system.db.ar.CActiveRecord
Files.find()
21:55:57.159106 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:tbl_files"
from cache
21:55:57.159183 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tbl_files` `t` WHERE object_id = :id AND
object_name = "Publication" LIMIT 1. Bound with :id='308421'
21:55:57.159188 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tbl_files` `t` WHERE
object_id = :id AND object_name = "Publication" LIMIT 1. Bound with
:id='308421')
21:55:57.159786 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tbl_files` `t` WHERE
object_id = :id AND object_name = "Publication" LIMIT 1. Bound with
:id='308421')
21:55:57.160278 trace system.db.CDbCommand
Querying SQL: SELECT s.id, s.name, s.urlname FROM tbl_section s JOIN
tbl_publication_section ps ON ps.section_id = s.id WHERE ps.pub_id = :pId
AND s.project_id = :projectId. Bound with :pId='308421', :projectId=1
21:55:57.160291 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT s.id, s.name, s.urlname FROM
tbl_section s JOIN tbl_publication_section ps ON ps.section_id = s.id WHERE
ps.pub_id = :pId AND s.project_id = :projectId. Bound with :pId='308421',
:projectId=1)
21:55:57.164721 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT s.id, s.name, s.urlname FROM
tbl_section s JOIN tbl_publication_section ps ON ps.section_id = s.id WHERE
ps.pub_id = :pId AND s.project_id = :projectId. Bound with :pId='308421',
:projectId=1)
21:55:57.164964 trace system.db.CDbCommand
Querying SQL: SELECT t.id, t.name FROM tbl_theme t JOIN
tbl_publication_theme pt ON pt.theme_id = t.id WHERE pt.pub_id = :pId.
Bound with :pId='308421'
21:55:57.164973 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT t.id, t.name FROM tbl_theme t JOIN
tbl_publication_theme pt ON pt.theme_id = t.id WHERE pt.pub_id = :pId.
Bound with :pId='308421')
21:55:57.166035 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT t.id, t.name FROM tbl_theme t JOIN
tbl_publication_theme pt ON pt.theme_id = t.id WHERE pt.pub_id = :pId.
Bound with :pId='308421')
21:55:57.166439 trace system.db.CDbCommand
Querying SQL: SELECT `f`.`id` AS `fid`, `f`.`name` AS `filename`,
`f`.`filepath`, `f`.`title`, `f`.`author`, `m`.`name`, `m`.`author` AS
`mauthor`
FROM `tbl_publication_media` `pm`
JOIN `tbl_media` `m` ON pm.media_id = m.id
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Media"
WHERE pm.pub_id = :pid AND m.in_publication = 1 AND (m.type = :mtype OR
m.type = :itype)
ORDER BY `f`.`id` ASC. Bound with :pid='308421', :mtype=5, :itype=3
21:55:57.166446 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `f`.`title`, `f`.`author`, `m`.`name`,
`m`.`author` AS `mauthor`
FROM `tbl_publication_media` `pm`
JOIN `tbl_media` `m` ON pm.media_id = m.id
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Media"
WHERE pm.pub_id = :pid AND m.in_publication = 1 AND (m.type = :mtype OR
m.type = :itype)
ORDER BY `f`.`id` ASC. Bound with :pid='308421', :mtype=5, :itype=3)
21:55:57.167288 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `f`.`id` AS `fid`, `f`.`name` AS
`filename`, `f`.`filepath`, `f`.`title`, `f`.`author`, `m`.`name`,
`m`.`author` AS `mauthor`
FROM `tbl_publication_media` `pm`
JOIN `tbl_media` `m` ON pm.media_id = m.id
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Media"
WHERE pm.pub_id = :pid AND m.in_publication = 1 AND (m.type = :mtype OR
m.type = :itype)
ORDER BY `f`.`id` ASC. Bound with :pid='308421', :mtype=5, :itype=3)
21:55:57.167495 trace system.db.CDbCommand
Querying SQL: SELECT
CONCAT("http://media.informpskov.ru/",f.filepath,f.name) as file,
CONCAT("http://media.informpskov.ru/",fv.filepath,fv.name) as poster,
m.name as comment
FROM `tbl_publication_media` `pm`
JOIN `tbl_media` `m` ON pm.media_id = m.id
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Media"
LEFT JOIN `tbl_files` `fv` ON fv.object_id = m.id AND fv.object_name =
"Video"
WHERE pm.pub_id = :pid AND m.type = :mtype. Bound with :pid='308421',
:mtype=1
21:55:57.167503 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
CONCAT("http://media.informpskov.ru/",f.filepath,f.name) as file,
CONCAT("http://media.informpskov.ru/",fv.filepath,fv.name) as poster,
m.name as comment
FROM `tbl_publication_media` `pm`
JOIN `tbl_media` `m` ON pm.media_id = m.id
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Media"
LEFT JOIN `tbl_files` `fv` ON fv.object_id = m.id AND fv.object_name =
"Video"
WHERE pm.pub_id = :pid AND m.type = :mtype. Bound with :pid='308421',
:mtype=1)
21:55:57.168380 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
CONCAT("http://media.informpskov.ru/",f.filepath,f.name) as file,
CONCAT("http://media.informpskov.ru/",fv.filepath,fv.name) as poster,
m.name as comment
FROM `tbl_publication_media` `pm`
JOIN `tbl_media` `m` ON pm.media_id = m.id
LEFT JOIN `tbl_files` `f` ON f.object_id = m.id AND f.object_name = "Media"
LEFT JOIN `tbl_files` `fv` ON fv.object_id = m.id AND fv.object_name =
"Video"
WHERE pm.pub_id = :pid AND m.type = :mtype. Bound with :pid='308421',
:mtype=1)
21:55:57.168415 trace system.CModule
Loading "clientScript" application component
21:55:57.168741 trace system.CModule
Loading "statePersister" application component
21:55:57.169265 trace system.caching.CMemCache
Serving
"Yii.CStatePersister./test.informpskov.ru/htdocs/protected/runtime/state.bin"
from cache
21:55:57.169804 trace system.caching.CMemCache
Serving "Informers_2021-07-29" from cache
21:55:57.169837 trace system.CModule
Loading "themeManager" application component
21:55:57.171055 trace system.CModule
Loading "widgetFactory" application component
21:55:57.171582 trace system.caching.CMemCache
Serving "Commercial_131" from cache
21:55:57.172399 trace system.CModule
Loading "messages" application component
21:55:57.173130 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=25, :status=1, :pid='%1%'
21:55:57.173140 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=25, :status=1, :pid='%1%')
21:55:57.173365 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=25, :status=1, :pid='%1%')
21:55:57.173398 trace system.caching.CMemCache
Saving "Commercial_251" to cache
21:55:57.174165 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=17, :status=1, :pid='%1%'
21:55:57.174175 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=17, :status=1, :pid='%1%')
21:55:57.174340 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=17, :status=1, :pid='%1%')
21:55:57.174408 trace system.db.CDbCommand
Querying SQL: SELECT * FROM tbl_commercial_section WHERE commercial_id =
:id. Bound with :id='540'
21:55:57.174416 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='540')
21:55:57.174570 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM tbl_commercial_section WHERE
commercial_id = :id. Bound with :id='540')
21:55:57.174601 trace system.caching.CMemCache
Saving "Commercial_171" to cache
21:55:57.175188 trace system.CModule
Loading "assetManager" application component
21:55:57.175724 trace system.caching.CMemCache
Serving "LastPoll_1" from cache
21:55:57.176127 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{poll}}"
from cache
21:55:57.176183 trace system.db.ar.CActiveRecord
lazy loading Poll.choices
21:55:57.176642 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{poll_choice}}"
from cache
21:55:57.176837 trace system.db.CDbCommand
Querying SQL: SELECT `choices`.`id` AS `t1_c0`, `choices`.`poll_id` AS
`t1_c1`, `choices`.`label` AS `t1_c2`, `choices`.`votes` AS `t1_c3`,
`choices`.`weight` AS `t1_c4` FROM `tbl_poll_choice` `choices`  WHERE
(`choices`.`poll_id`=:ypl0) ORDER BY weight ASC, label ASC. Bound with
:ypl0='564'
21:55:57.176845 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `choices`.`id` AS `t1_c0`,
`choices`.`poll_id` AS `t1_c1`, `choices`.`label` AS `t1_c2`,
`choices`.`votes` AS `t1_c3`, `choices`.`weight` AS `t1_c4` FROM
`tbl_poll_choice` `choices`  WHERE (`choices`.`poll_id`=:ypl0) ORDER BY
weight ASC, label ASC. Bound with :ypl0='564')
21:55:57.177120 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `choices`.`id` AS `t1_c0`,
`choices`.`poll_id` AS `t1_c1`, `choices`.`label` AS `t1_c2`,
`choices`.`votes` AS `t1_c3`, `choices`.`weight` AS `t1_c4` FROM
`tbl_poll_choice` `choices`  WHERE (`choices`.`poll_id`=:ypl0) ORDER BY
weight ASC, label ASC. Bound with :ypl0='564')
21:55:57.177347 trace system.base.CModule
Loading "poll" module
21:55:57.177624 trace system.caching.CMemCache
Deleting "userCanVote_564_0" from cache
21:55:57.177932 trace system.db.ar.CActiveRecord
lazy loading Poll.votes
21:55:57.178473 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=127.0.0.1;dbname=new_informpskov:w_informpskov:{{poll_vote}}"
from cache
21:55:57.178644 trace system.db.CDbCommand
Querying SQL: SELECT `votes`.`id` AS `t1_c0`, `votes`.`poll_id` AS `t1_c1`,
`votes`.`choice_id` AS `t1_c2`, `votes`.`user_id` AS `t1_c3`,
`votes`.`ip_address` AS `t1_c4`, `votes`.`ip_real` AS `t1_c5`,
`votes`.`timestamp` AS `t1_c6`, `votes`.`register` AS `t1_c7` FROM
`tbl_poll_vote` `votes`  WHERE (`votes`.`poll_id`=:ypl0). Bound with
:ypl0='564'
21:55:57.178651 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `votes`.`id` AS `t1_c0`,
`votes`.`poll_id` AS `t1_c1`, `votes`.`choice_id` AS `t1_c2`,
`votes`.`user_id` AS `t1_c3`, `votes`.`ip_address` AS `t1_c4`,
`votes`.`ip_real` AS `t1_c5`, `votes`.`timestamp` AS `t1_c6`,
`votes`.`register` AS `t1_c7` FROM `tbl_poll_vote` `votes`  WHERE
(`votes`.`poll_id`=:ypl0). Bound with :ypl0='564')
21:55:57.179354 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `votes`.`id` AS `t1_c0`,
`votes`.`poll_id` AS `t1_c1`, `votes`.`choice_id` AS `t1_c2`,
`votes`.`user_id` AS `t1_c3`, `votes`.`ip_address` AS `t1_c4`,
`votes`.`ip_real` AS `t1_c5`, `votes`.`timestamp` AS `t1_c6`,
`votes`.`register` AS `t1_c7` FROM `tbl_poll_vote` `votes`  WHERE
(`votes`.`poll_id`=:ypl0). Bound with :ypl0='564')
21:55:57.186403 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`content`,
`p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
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 AND p.article = 0 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid='4'
21:55:57.186413 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`content`, `p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id`
AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`
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 AND p.article = 0 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid='4')
21:55:57.186644 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`content`,
`p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
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 AND p.article = 0 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid='4')
21:55:57.190874 trace system.db.CDbCommand
Querying SQL: SELECT `p`.`id`, `p`.`name`, `p`.`content`,
`p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
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 AND p.article = 0 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid='4'
21:55:57.190881 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`,
`p`.`content`, `p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id`
AS `fid`, `f`.`name` AS `filename`, `f`.`filepath`
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 AND p.article = 0 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid='4')
21:55:57.191271 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `p`.`id`, `p`.`name`, `p`.`content`,
`p`.`create_time`, `p`.`comments`, `p`.`thumbnail`, `f`.`id` AS `fid`,
`f`.`name` AS `filename`, `f`.`filepath`
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 AND p.article = 0 AND
p.main = 1
ORDER BY `p`.`create_time` DESC LIMIT 8. Bound with :status=1, :sid='4')
21:55:57.195314 trace system.db.CDbCommand
Querying SQL: SELECT `fio`
FROM `tbl_admin` `u`
WHERE id = :id LIMIT 1. Bound with :id='83'
21:55:57.195322 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `fio`
FROM `tbl_admin` `u`
WHERE id = :id LIMIT 1. Bound with :id='83')
21:55:57.195568 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `fio`
FROM `tbl_admin` `u`
WHERE id = :id LIMIT 1. Bound with :id='83')
21:55:57.195971 trace system.caching.CMemCache
Serving "Commercial_141" from cache
21:55:57.196279 trace system.caching.CMemCache
Serving "Commercial_151" from cache
21:55:57.196568 trace system.caching.CMemCache
Serving "Commercial_161" from cache
21:55:57.196814 trace system.caching.CMemCache
Serving "Commercial_181" from cache
21:55:57.197088 trace system.caching.CMemCache
Serving "Commercial_191" from cache
21:55:57.197386 trace system.caching.CMemCache
Serving "Commercial_201" from cache
21:55:57.197705 trace system.caching.CMemCache
Serving "Commercial_211" from cache
21:55:57.198088 trace system.caching.CMemCache
Serving "Commercial_31" from cache
21:55:57.198612 trace system.caching.CMemCache
Serving "Commercial_61" from cache
21:55:57.200172 trace system.caching.CMemCache
Deleting "Yii.COutputCache.projectThemes_1......." from cache
21:55:57.200383 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:55:57.200390 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:55:57.200565 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)