Общий отчет (Время: 0.16989с, Память: 1,930Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`categoryId` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`urlAlias` AS `t0_c3`, `t`.`author` AS `t0_c4`, `t`.`authorText` AS `t0_c5`, `t`.`photoId` AS `t0_c6`, `t`.`tagId` AS `t0_c7`, `t`.`photoUrl` AS `t0_c8`, `t`.`photoUrlParams` AS `t0_c9`, `t`.`alwaysOnTop` AS `t0_c10`, `t`.`contentShort` AS `t0_c11`, `t`.`content` AS `t0_c12`, `t`.`source` AS `t0_c13`, `t`.`sourceUrl` AS `t0_c14`, `t`.`authorshipUrl` AS `t0_c15`, `t`.`authorshipName` AS `t0_c16`, `t`.`yandexFeed` AS `t0_c17`, `t`.`vkontakteFeed` AS `t0_c18`, `t`.`vkontakteFeedStatusId` AS `t0_c19`, `t`.`facebookFeed` AS `t0_c20`, `t`.`facebookFeedStatusId` AS `t0_c21`, `t`.`newsletterFeed` AS `t0_c22`, `t`.`status` AS `t0_c23`, `t`.`statusDeferredId` AS `t0_c24`, `t`.`paid` AS `t0_c25`, `t`.`showComments` AS `t0_c26`, `t`.`photoGalleryId` AS `t0_c27`, `t`.`created` AS `t0_c28`, `t`.`creatorId` AS `t0_c29`, `t`.`modified` AS `t0_c30`, `t`.`modifierId` AS `t0_c31`, `titleImage`.`id` AS `t1_c0`, `titleImage`.`galleryId` AS `t1_c1`, `titleImage`.`path` AS `t1_c2`, `titleImage`.`name` AS `t1_c3`, `titleImage`.`position` AS `t1_c4`, `titleImage`.`created` AS `t1_c5`, `titleImage`.`creatorId` AS `t1_c6`, `titleImage`.`modified` AS `t1_c7`, `titleImage`.`modifierId` AS `t1_c8` FROM `yii_news` `t` LEFT OUTER JOIN `yii_photo` `titleImage` ON (`t`.`photoId`=`titleImage`.`id`) WHERE (status > 0 AND categoryId = :category) ORDER BY t.created DESC LIMIT 19. Bound with :category='2') 1 0.00386 0.00386 0.00386 0.00386
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `yii_news`) 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `yii_seoRule`) 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `yii_urlRule`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `yii_newsCategory`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `yii_photo`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.execute(DELETE FROM `yii_session` WHERE expire<:expire. Bound with :expire=1537852215) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT `data` FROM `yii_session` WHERE expire>:expire AND id=:id. Bound with :expire=1537852215, :id='ooqdtv4rke1kakcfqso61jg0et') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `yii_newsCategory`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `yii_news`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `yii_seoRule`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `yii_urlRule`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `yii_newsCategory` `t` WHERE id != 7 AND id !=8 ORDER BY position ASC) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `yii_photo`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT * FROM `yii_newsCategory` `t` WHERE id = :id LIMIT 1. Bound with :id=7) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT * FROM `yii_newsCategory` `t` WHERE `t`.`urlAlias`=:yp0 LIMIT 1. Bound with :yp0='architecture') 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT COUNT(DISTINCT `t`.`id`) FROM `yii_news` `t` LEFT OUTER JOIN `yii_photo` `titleImage` ON (`t`.`photoId`=`titleImage`.`id`) WHERE (status > 0 AND categoryId = :category). Bound with :category='2') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `yii_urlRule` `t` WHERE `isActive` = 1 ORDER BY `isUniqueRoute` DESC) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `yii_seoRule` `t` WHERE `t`.`siteUrl`=:yp0 LIMIT 1. Bound with :yp0='http://dizbook.com/news/architecture') 1 0.00008 0.00008 0.00008 0.00008
Журнал приложения
Время Уровень Категория Сообщение
08:10:15.609106 trace system.CModule
Loading "log" application component
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.609214 trace system.CModule
Loading "request" application component
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.609277 trace system.CModule
Loading "urlManager" application component
in /home/dizbook/sites/dizbook.com/protected/components/EHttpRequest.php
(456)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.609325 trace system.CModule
Loading "cache" application component
in /home/dizbook/sites/dizbook.com/protected/components/EHttpRequest.php
(456)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.610419 trace system.caching.CRedisCache
Serving "Yii.CUrlManager.rules" from cache
in /home/dizbook/sites/dizbook.com/protected/components/EHttpRequest.php
(456)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.610692 trace system.CModule
Loading "db" application component
in
/home/dizbook/sites/dizbook.com/protected/components/EDbUrlRuleBehavior.php
(18)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.610732 trace system.db.CDbConnection
Opening DB connection
in
/home/dizbook/sites/dizbook.com/protected/components/EDbUrlRuleBehavior.php
(18)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.611571 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `yii_urlRule`
in
/home/dizbook/sites/dizbook.com/protected/components/EDbUrlRuleBehavior.php
(18)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.612447 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `yii_urlRule`
in
/home/dizbook/sites/dizbook.com/protected/components/EDbUrlRuleBehavior.php
(18)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.612735 trace system.db.ar.CActiveRecord
EUrlRule.findAll()
in
/home/dizbook/sites/dizbook.com/protected/components/EDbUrlRuleBehavior.php
(18)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.612807 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `yii_urlRule` `t` WHERE `isActive` = 1 ORDER BY
`isUniqueRoute` DESC
in
/home/dizbook/sites/dizbook.com/protected/components/EDbUrlRuleBehavior.php
(18)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.613406 trace system.web.filters.CFilterChain
Running filter NewsController.filtermediaType()
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.613519 trace system.db.ar.CActiveRecord
NewsCategory.findByAttributes()
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(244)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(186)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.613563 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `yii_newsCategory`
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(244)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(186)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.614401 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `yii_newsCategory`
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(244)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(186)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.614800 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `yii_newsCategory` `t` WHERE
`t`.`urlAlias`=:yp0 LIMIT 1. Bound with :yp0='architecture'
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(244)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(186)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.615029 trace system.CModule
Loading "messages" application component
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(254)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(186)
in /home/dizbook/sites/dizbook.com/public_html/index.php (32)
08:10:15.615297 trace system.CModule
Loading "errorHandler" application component
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(179)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(222)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(350)
08:10:15.615394 trace system.db.ar.CActiveRecord
SeoRule.findByAttributes()
in /home/dizbook/sites/dizbook.com/protected/components/SeoHelper.php (11)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(180)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(222)
08:10:15.615437 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `yii_seoRule`
in /home/dizbook/sites/dizbook.com/protected/components/SeoHelper.php (11)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(180)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(222)
08:10:15.616358 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `yii_seoRule`
in /home/dizbook/sites/dizbook.com/protected/components/SeoHelper.php (11)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(180)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(222)
08:10:15.616694 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `yii_seoRule` `t` WHERE `t`.`siteUrl`=:yp0
LIMIT 1. Bound with :yp0='http://dizbook.com/news/architecture'
in /home/dizbook/sites/dizbook.com/protected/components/SeoHelper.php (11)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(180)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(222)
08:10:15.616816 trace system.db.ar.CActiveRecord
NewsCategory.findAll()
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(109)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(223)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(350)
08:10:15.616857 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `yii_newsCategory` `t` WHERE id != 7 AND id !=8
ORDER BY position ASC
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(109)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(223)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(350)
08:10:15.617150 trace system.db.ar.CActiveRecord
NewsCategory.find()
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(113)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(223)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(350)
08:10:15.617208 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `yii_newsCategory` `t` WHERE id = :id LIMIT 1.
Bound with :id=7
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(113)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(223)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(350)
08:10:15.617532 trace system.CModule
Loading "clientScript" application component
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(246)
in /home/dizbook/sites/dizbook.com/protected/components/Controller.php
(104)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(293)
08:10:15.617789 trace system.CModule
Loading "securityManager" application component
in
/home/dizbook/sites/dizbook.com/protected/views/layouts/partials/_right-column.php
(93)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (2)
08:10:15.617888 trace system.CModule
Loading "statePersister" application component
in
/home/dizbook/sites/dizbook.com/protected/views/layouts/partials/_right-column.php
(93)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (2)
08:10:15.618161 trace system.caching.CRedisCache
Serving
"Yii.CStatePersister./home/dizbook/sites/dizbook.com/protected/runtime/state.bin"
from cache
in
/home/dizbook/sites/dizbook.com/protected/views/layouts/partials/_right-column.php
(93)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (2)
08:10:15.618278 trace system.CModule
Loading "widgetFactory" application component
in
/home/dizbook/sites/dizbook.com/protected/views/layouts/partials/_right-column.php
(102)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (2)
08:10:15.618468 trace system.db.ar.CActiveRecord
News.count()
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.618542 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `yii_news`
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.619688 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `yii_news`
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.620126 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `yii_photo`
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.620796 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `yii_photo`
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.621067 trace system.db.ar.CActiveRecord
News.count() eagerly
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.621217 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(DISTINCT `t`.`id`) FROM `yii_news` `t`  LEFT
OUTER JOIN `yii_photo` `titleImage` ON (`t`.`photoId`=`titleImage`.`id`) 
WHERE (status > 0 AND categoryId = :category). Bound with :category='2'
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.621413 trace system.db.ar.CActiveRecord
News.findAll()
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.621604 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`categoryId` AS `t0_c1`,
`t`.`title` AS `t0_c2`, `t`.`urlAlias` AS `t0_c3`, `t`.`author` AS `t0_c4`,
`t`.`authorText` AS `t0_c5`, `t`.`photoId` AS `t0_c6`, `t`.`tagId` AS
`t0_c7`, `t`.`photoUrl` AS `t0_c8`, `t`.`photoUrlParams` AS `t0_c9`,
`t`.`alwaysOnTop` AS `t0_c10`, `t`.`contentShort` AS `t0_c11`,
`t`.`content` AS `t0_c12`, `t`.`source` AS `t0_c13`, `t`.`sourceUrl` AS
`t0_c14`, `t`.`authorshipUrl` AS `t0_c15`, `t`.`authorshipName` AS
`t0_c16`, `t`.`yandexFeed` AS `t0_c17`, `t`.`vkontakteFeed` AS `t0_c18`,
`t`.`vkontakteFeedStatusId` AS `t0_c19`, `t`.`facebookFeed` AS `t0_c20`,
`t`.`facebookFeedStatusId` AS `t0_c21`, `t`.`newsletterFeed` AS `t0_c22`,
`t`.`status` AS `t0_c23`, `t`.`statusDeferredId` AS `t0_c24`, `t`.`paid` AS
`t0_c25`, `t`.`showComments` AS `t0_c26`, `t`.`photoGalleryId` AS `t0_c27`,
`t`.`created` AS `t0_c28`, `t`.`creatorId` AS `t0_c29`, `t`.`modified` AS
`t0_c30`, `t`.`modifierId` AS `t0_c31`, `titleImage`.`id` AS `t1_c0`,
`titleImage`.`galleryId` AS `t1_c1`, `titleImage`.`path` AS `t1_c2`,
`titleImage`.`name` AS `t1_c3`, `titleImage`.`position` AS `t1_c4`,
`titleImage`.`created` AS `t1_c5`, `titleImage`.`creatorId` AS `t1_c6`,
`titleImage`.`modified` AS `t1_c7`, `titleImage`.`modifierId` AS `t1_c8`
FROM `yii_news` `t`  LEFT OUTER JOIN `yii_photo` `titleImage` ON
(`t`.`photoId`=`titleImage`.`id`)  WHERE (status > 0 AND categoryId =
:category) ORDER BY t.created DESC LIMIT 19. Bound with :category='2'
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.626514 trace system.CModule
Loading "assetManager" application component
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
08:10:15.774384 trace system.CModule
Loading "coreMessages" application component
in /home/dizbook/sites/dizbook.com/protected/components/ELinkPager.php (22)
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
08:10:15.774935 warning application
list count is 19 and split is 10
in /home/dizbook/sites/dizbook.com/protected/extensions/EDoubleListView.php
(93)
in /home/dizbook/sites/dizbook.com/protected/views/news/list.php (43)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(359)
08:10:15.775135 trace system.CModule
Loading "user" application component
in /home/dizbook/sites/dizbook.com/protected/views/layouts/main.php (82)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(295)
08:10:15.775202 trace system.CModule
Loading "session" application component
in /home/dizbook/sites/dizbook.com/protected/views/layouts/main.php (82)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(295)
08:10:15.775299 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_session` WHERE expire<:expire. Bound with
:expire=1537852215
in /home/dizbook/sites/dizbook.com/protected/views/layouts/main.php (82)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(295)
08:10:15.775937 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1537852215,
:id='ooqdtv4rke1kakcfqso61jg0et'
in /home/dizbook/sites/dizbook.com/protected/views/layouts/main.php (82)
in /home/dizbook/sites/dizbook.com/protected/components/EHttpController.php
(382)
in /home/dizbook/sites/dizbook.com/protected/controllers/NewsController.php
(295)