( ! ) Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /var/www/protected/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php on line 276
Call Stack
#TimeMemoryFunctionLocation
10.0001444376{main}( ).../index.php:0
20.0178877056CApplication->run( ).../index.php:22
30.0178877416CWebApplication->processRequest( ).../CApplication.php:185
40.01881637872CWebApplication->runController( $route = 'price/part' ).../CWebApplication.php:141
50.02371688680CController->run( $actionID = 'part' ).../CWebApplication.php:282
60.02381688904CController->runActionWithFilters( $action = class PricePartAction { private ${CComponent}_e = NULL; private ${CComponent}_m = NULL; private ${CAction}_id = 'part'; private ${CAction}_controller = class PriceController { private ${CComponent}_e = NULL; private ${CComponent}_m = [...]; private ${CBaseController}_widgetStack = [...]; public $layout = '//layouts/wp2'; public $defaultAction = 'index'; private ${CController}_id = 'price'; private ${CController}_action = ...; private ${CController}_pageTitle = NULL; private ${CController}_cachingStack = NULL; private ${CController}_clips = NULL; private ${CController}_dynamicOutput = NULL; private ${CController}_pageStates = NULL; private ${CController}_module = NULL; public $robots = ''; public $pageDescription = 'Покупайте с выгодой Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA. Доставим! Артикул: TE31560. Фильтры масляные АКПП, трансмиссии аналоги: TE31560 JT508 0BH325183B.'; public $pageKeywords = 'Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA, SAKURA, Фильтры масляные АКПП, трансмиссии, TE31560 JT508 0BH325183B, TE31560, купить Фильтры масляные АКПП, трансмиссии, продажа SAKURA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/filtr_maslyanyiy_akpp_vw_tiguan_audi_q3__s_prokladkoiy__sakura-373047/'; public $pubdate = '2026-08-23'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/ba1/373047.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '505ee108fd71596878e0aac32d98e05cc44a2d9bd6059a7f6965ed18257a4660'; private ${BaseController}securityService = class AA\Security\Csrf\SecurityService { ... }; protected Psr\Log\LoggerInterface $logger = class AA\Framework\Log\Adapters\YiiLog { ... }; public $behaviors = [...]; public $menu = [...]; public $breadcrumbs = [...]; public $topMenu = [...]; public $pageTitle = 'TE31560 Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA - TE31560 JT508 0BH325183B - фото, цена, описание, применимость. Купить в интернет-магазине AvtoALL.Ru'; public $pageHeader = ''; public $pageText = ''; public $forceTheme = FALSE; public $_seoProperties = [...]; public $list_tags_show = TRUE }; private ${BaseAction}isUserAdmin = FALSE; private ${BaseAction}isUserManager = FALSE; private ${BaseAction}isUserSimple = FALSE; private ${BaseAction}isUserB2BCompany = FALSE; private ${BaseAction}B2BCompany = FALSE; private ${BaseAction}isAjax = FALSE }, $filters = [0 => [0 => 'application.filters.RedirectFilter + index'], 1 => [0 => 'application.filters.DBReadUncomitedLevelFilter + part, list']] ).../CController.php:265
70.02391689720CFilterChain->run( ).../CController.php:291
80.02391690016CFilter->filter( $filterChain = class CFilterChain { private ${CComponent}_e = NULL; private ${CComponent}_m = NULL; private ${CList}_d = [0 => class DBReadUncomitedLevelFilter { ... }]; private ${CList}_c = 1; private ${CList}_r = FALSE; public $controller = class PriceController { private ${CComponent}_e = NULL; private ${CComponent}_m = [...]; private ${CBaseController}_widgetStack = [...]; public $layout = '//layouts/wp2'; public $defaultAction = 'index'; private ${CController}_id = 'price'; private ${CController}_action = class PricePartAction { ... }; private ${CController}_pageTitle = NULL; private ${CController}_cachingStack = NULL; private ${CController}_clips = NULL; private ${CController}_dynamicOutput = NULL; private ${CController}_pageStates = NULL; private ${CController}_module = NULL; public $robots = ''; public $pageDescription = 'Покупайте с выгодой Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA. Доставим! Артикул: TE31560. Фильтры масляные АКПП, трансмиссии аналоги: TE31560 JT508 0BH325183B.'; public $pageKeywords = 'Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA, SAKURA, Фильтры масляные АКПП, трансмиссии, TE31560 JT508 0BH325183B, TE31560, купить Фильтры масляные АКПП, трансмиссии, продажа SAKURA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/filtr_maslyanyiy_akpp_vw_tiguan_audi_q3__s_prokladkoiy__sakura-373047/'; public $pubdate = '2026-08-23'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/ba1/373047.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '505ee108fd71596878e0aac32d98e05cc44a2d9bd6059a7f6965ed18257a4660'; private ${BaseController}securityService = class AA\Security\Csrf\SecurityService { ... }; protected Psr\Log\LoggerInterface $logger = class AA\Framework\Log\Adapters\YiiLog { ... }; public $behaviors = [...]; public $menu = [...]; public $breadcrumbs = [...]; public $topMenu = [...]; public $pageTitle = 'TE31560 Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA - TE31560 JT508 0BH325183B - фото, цена, описание, применимость. Купить в интернет-магазине AvtoALL.Ru'; public $pageHeader = ''; public $pageText = ''; public $forceTheme = FALSE; public $_seoProperties = [...]; public $list_tags_show = TRUE }; public $action = class PricePartAction { private ${CComponent}_e = NULL; private ${CComponent}_m = NULL; private ${CAction}_id = 'part'; private ${CAction}_controller = class PriceController { ... }; private ${BaseAction}isUserAdmin = FALSE; private ${BaseAction}isUserManager = FALSE; private ${BaseAction}isUserSimple = FALSE; private ${BaseAction}isUserB2BCompany = FALSE; private ${BaseAction}B2BCompany = FALSE; private ${BaseAction}isAjax = FALSE }; public $filterIndex = 1 } ).../CFilterChain.php:131
90.02411691040CFilterChain->run( ).../CFilter.php:40
100.02421691040CController->runAction( $action = class PricePartAction { private ${CComponent}_e = NULL; private ${CComponent}_m = NULL; private ${CAction}_id = 'part'; private ${CAction}_controller = class PriceController { private ${CComponent}_e = NULL; private ${CComponent}_m = [...]; private ${CBaseController}_widgetStack = [...]; public $layout = '//layouts/wp2'; public $defaultAction = 'index'; private ${CController}_id = 'price'; private ${CController}_action = ...; private ${CController}_pageTitle = NULL; private ${CController}_cachingStack = NULL; private ${CController}_clips = NULL; private ${CController}_dynamicOutput = NULL; private ${CController}_pageStates = NULL; private ${CController}_module = NULL; public $robots = ''; public $pageDescription = 'Покупайте с выгодой Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA. Доставим! Артикул: TE31560. Фильтры масляные АКПП, трансмиссии аналоги: TE31560 JT508 0BH325183B.'; public $pageKeywords = 'Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA, SAKURA, Фильтры масляные АКПП, трансмиссии, TE31560 JT508 0BH325183B, TE31560, купить Фильтры масляные АКПП, трансмиссии, продажа SAKURA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/filtr_maslyanyiy_akpp_vw_tiguan_audi_q3__s_prokladkoiy__sakura-373047/'; public $pubdate = '2026-08-23'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/ba1/373047.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '505ee108fd71596878e0aac32d98e05cc44a2d9bd6059a7f6965ed18257a4660'; private ${BaseController}securityService = class AA\Security\Csrf\SecurityService { ... }; protected Psr\Log\LoggerInterface $logger = class AA\Framework\Log\Adapters\YiiLog { ... }; public $behaviors = [...]; public $menu = [...]; public $breadcrumbs = [...]; public $topMenu = [...]; public $pageTitle = 'TE31560 Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA - TE31560 JT508 0BH325183B - фото, цена, описание, применимость. Купить в интернет-магазине AvtoALL.Ru'; public $pageHeader = ''; public $pageText = ''; public $forceTheme = FALSE; public $_seoProperties = [...]; public $list_tags_show = TRUE }; private ${BaseAction}isUserAdmin = FALSE; private ${BaseAction}isUserManager = FALSE; private ${BaseAction}isUserSimple = FALSE; private ${BaseAction}isUserB2BCompany = FALSE; private ${BaseAction}B2BCompany = FALSE; private ${BaseAction}isAjax = FALSE } ).../CFilterChain.php:134
110.03331952992CAction->runWithParams( $params = ['name' => 'filtr_maslyanyiy_akpp_vw_tiguan_audi_q3__s_prokladkoiy__sakura', 'code' => '373047'] ).../CController.php:308
120.03331953104CAction->runWithParamsInternal( $object = class PricePartAction { private ${CComponent}_e = NULL; private ${CComponent}_m = NULL; private ${CAction}_id = 'part'; private ${CAction}_controller = class PriceController { private ${CComponent}_e = NULL; private ${CComponent}_m = [...]; private ${CBaseController}_widgetStack = [...]; public $layout = '//layouts/wp2'; public $defaultAction = 'index'; private ${CController}_id = 'price'; private ${CController}_action = ...; private ${CController}_pageTitle = NULL; private ${CController}_cachingStack = NULL; private ${CController}_clips = NULL; private ${CController}_dynamicOutput = NULL; private ${CController}_pageStates = NULL; private ${CController}_module = NULL; public $robots = ''; public $pageDescription = 'Покупайте с выгодой Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA. Доставим! Артикул: TE31560. Фильтры масляные АКПП, трансмиссии аналоги: TE31560 JT508 0BH325183B.'; public $pageKeywords = 'Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA, SAKURA, Фильтры масляные АКПП, трансмиссии, TE31560 JT508 0BH325183B, TE31560, купить Фильтры масляные АКПП, трансмиссии, продажа SAKURA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/filtr_maslyanyiy_akpp_vw_tiguan_audi_q3__s_prokladkoiy__sakura-373047/'; public $pubdate = '2026-08-23'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/ba1/373047.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '505ee108fd71596878e0aac32d98e05cc44a2d9bd6059a7f6965ed18257a4660'; private ${BaseController}securityService = class AA\Security\Csrf\SecurityService { ... }; protected Psr\Log\LoggerInterface $logger = class AA\Framework\Log\Adapters\YiiLog { ... }; public $behaviors = [...]; public $menu = [...]; public $breadcrumbs = [...]; public $topMenu = [...]; public $pageTitle = 'TE31560 Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA - TE31560 JT508 0BH325183B - фото, цена, описание, применимость. Купить в интернет-магазине AvtoALL.Ru'; public $pageHeader = ''; public $pageText = ''; public $forceTheme = FALSE; public $_seoProperties = [...]; public $list_tags_show = TRUE }; private ${BaseAction}isUserAdmin = FALSE; private ${BaseAction}isUserManager = FALSE; private ${BaseAction}isUserSimple = FALSE; private ${BaseAction}isUserB2BCompany = FALSE; private ${BaseAction}B2BCompany = FALSE; private ${BaseAction}isAjax = FALSE }, $method = class ReflectionMethod { public string $name = 'run'; public string $class = 'PricePartAction' }, $params = ['name' => 'filtr_maslyanyiy_akpp_vw_tiguan_audi_q3__s_prokladkoiy__sakura', 'code' => '373047'] ).../CAction.php:74
130.03331953440invokeArgs( $object = class PricePartAction { private ${CComponent}_e = NULL; private ${CComponent}_m = NULL; private ${CAction}_id = 'part'; private ${CAction}_controller = class PriceController { private ${CComponent}_e = NULL; private ${CComponent}_m = [...]; private ${CBaseController}_widgetStack = [...]; public $layout = '//layouts/wp2'; public $defaultAction = 'index'; private ${CController}_id = 'price'; private ${CController}_action = ...; private ${CController}_pageTitle = NULL; private ${CController}_cachingStack = NULL; private ${CController}_clips = NULL; private ${CController}_dynamicOutput = NULL; private ${CController}_pageStates = NULL; private ${CController}_module = NULL; public $robots = ''; public $pageDescription = 'Покупайте с выгодой Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA. Доставим! Артикул: TE31560. Фильтры масляные АКПП, трансмиссии аналоги: TE31560 JT508 0BH325183B.'; public $pageKeywords = 'Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA, SAKURA, Фильтры масляные АКПП, трансмиссии, TE31560 JT508 0BH325183B, TE31560, купить Фильтры масляные АКПП, трансмиссии, продажа SAKURA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/filtr_maslyanyiy_akpp_vw_tiguan_audi_q3__s_prokladkoiy__sakura-373047/'; public $pubdate = '2026-08-23'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/ba1/373047.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '505ee108fd71596878e0aac32d98e05cc44a2d9bd6059a7f6965ed18257a4660'; private ${BaseController}securityService = class AA\Security\Csrf\SecurityService { ... }; protected Psr\Log\LoggerInterface $logger = class AA\Framework\Log\Adapters\YiiLog { ... }; public $behaviors = [...]; public $menu = [...]; public $breadcrumbs = [...]; public $topMenu = [...]; public $pageTitle = 'TE31560 Фильтр масляный АКПП VW Tiguan AUDI Q3 (с прокладкой) SAKURA - TE31560 JT508 0BH325183B - фото, цена, описание, применимость. Купить в интернет-магазине AvtoALL.Ru'; public $pageHeader = ''; public $pageText = ''; public $forceTheme = FALSE; public $_seoProperties = [...]; public $list_tags_show = TRUE }; private ${BaseAction}isUserAdmin = FALSE; private ${BaseAction}isUserManager = FALSE; private ${BaseAction}isUserSimple = FALSE; private ${BaseAction}isUserB2BCompany = FALSE; private ${BaseAction}B2BCompany = FALSE; private ${BaseAction}isAjax = FALSE }, $args = [0 => '373047'] ).../CAction.php:114
140.03331953504PricePartAction->run( $code = '373047' ).../CAction.php:114
150.141418779568AA\Content\ProductCertificate\Services\ProductCertificateService->getCertificateByProductId( $productId = '373047' ).../PricePartAction.php:90
160.141418779568AA\Content\ProductCertificate\Repositories\Yii3DaoProductCertificateRepository->findByProductId( $productId = '373047' ).../ProductCertificateService.php:162
170.142318780792AA\Content\ProductCertificate\Repositories\Yii3DaoProductCertificateRepository->findByInternalId( $internalId = '107571' ).../Yii3DaoProductCertificateRepository.php:163
180.142418783232Yiisoft\Db\Query\Query->all( ).../Yii3DaoProductCertificateRepository.php:106
190.142718784232Yiisoft\Db\Command\AbstractCommand->queryAll( ).../Query.php:266
200.142718784232Yiisoft\Db\Mysql\Command->queryInternal( $queryMode = 4 ).../AbstractCommand.php:410
210.142718784232Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->queryInternal( $queryMode = 4 ).../Command.php:135
220.142818785704Yiisoft\Db\Command\AbstractCommand->queryInternal( $queryMode = 4 ).../AbstractPdoCommand.php:302
230.697431738984Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->internalGetQueryResult( $queryMode = 4 ).../AbstractCommand.php:611
240.697431738984fetchAll( $mode = 2 ).../AbstractPdoCommand.php:276
Общий отчет (Время: 0.81176с, Память: 126,329Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SELECT `gr`.`ID` AS `t1_c0`, `gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`, `gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`, `gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS `t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`, `gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`, `gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`, `gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS `t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section` `gr` INNER JOIN `sp_catalog2msections` `groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND (`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL) 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`, `t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS `t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`, `t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`, `t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`, `t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`, `t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`, `t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`, `t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`, `t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS `t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`, `t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`, `t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS `t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`, `p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`, `p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`, `p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`, `p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`, `p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`, `p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`, `pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS `t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`, `pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR` AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`, `pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN (7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) 1 0.00272 0.00272 0.00272 0.00272
loading session 2 0.00087 0.00043 0.00000 0.00087
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) WHERE (`t`.`ID`=227856775)) 1 0.00251 0.00251 0.00251 0.00251
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`, `t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS `t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`, `t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`, `t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`, `t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`, `t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`, `t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`, `t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`, `t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS `t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`, `t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`, `t`.`SHOW_COUNTER_START` AS `t0_c32` FROM `b_iblock_element` `t` WHERE ((t.IBLOCK_ID = 24) AND (t.CODE = :CODE))) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS `t4_c0`, `uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`, `uf`.`date_create` AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status` AS `t4_c5`, `uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`, `uf`.`review_id` AS `t4_c8`, `uf`.`file_path` AS `t4_c9`, `uf`.`file_path_small` AS `t4_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_user_good_file` `userImage_uf` ON (`t`.`ID`=`userImage_uf`.`good_id`) LEFT OUTER JOIN `sp_user_upload_file_for_good` `uf` ON (`uf`.`id`=`userImage_uf`.`file_id`) AND (status IN (:ycp0, :ycp1)) WHERE (`t`.`ID`=227856775) ORDER BY sorter) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 2 0.00047 0.00023 0.00023 0.00024
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query( SELECT `marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto` FROM `marks`, `s_marks` WHERE `s_marks`.`idsite` = 3 AND `marks`.`ID` = `s_marks`.`idmark` ORDER BY 3 ) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS `t2_c0`, `pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`, `pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`, `pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`, `pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`, `pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND (pr.CATALOG_GROUP_ID IN (2,1)) WHERE (`t`.`ID`=227856775)) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`, `ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS `t1_c3` FROM `sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND (`ms`.`ELEMENT_ID`=:ypl0)) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT `id`,`aid`,`name` FROM `typeauto` WHERE `typeauto`.`idsite` = 3 ORDER BY `typeauto`.`sort` ) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`, `pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT` AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`, `pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME` AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10` FROM `b_file` `pp` WHERE (`pp`.`ID`=:ypl0)) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`, `t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS `t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`, `t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`, `t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`, `t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`, `t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`, `t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`, `t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`, `t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS `t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`, `t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`, `t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`, `pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS `t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`, `pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR` AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`, `pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN (7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW() AND (t.ACTIVE_TO IS NULL OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW())))) ORDER BY ACTIVE_FROM DESC LIMIT 10) 1 0.00457 0.00457 0.00457 0.00457
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS `t3_c0`, `cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`, `cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`, `cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`, `cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO` AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`, `cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`, `cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`, `cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`, `cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`, `cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`, `cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`, `cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`, `cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS `t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`, `cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON (`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr` ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88) WHERE (`t`.`ID`=227856775)) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`, `tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`, `tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`, `tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`, `tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO` AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`, `tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`, `tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`, `tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`, `tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`, `tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`, `tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`, `tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`, `tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS `t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM `b_iblock_element` `tg` INNER JOIN `sp_tags2catalog` `tags_tg` ON (`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND (tg.IBLOCK_ID = 50)) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query( SELECT t.id AS `AUTO_TYPE_ID`, t.`name` AS `AUTO_TYPE_NAME`, mo.`NAMESHORT` AS `AUTO_MODEL_NAME`, mo.`PATHICON` AS `ICO`, mo.`ID` AS `AUTO_MODEL_ID`, ma.`ID` AS `AUTO_MARK_ID`, ma.`NAMESHORT` AS `AUTO_MARK_NAME` FROM `sp_acat2catalog` INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id` INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3 INNER JOIN marks ma ON ma.ID = s.MARKID INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3 INNER JOIN models mo ON mo.ID = s.MODELID INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3 WHERE `sp_acat2catalog`.`catalog_id` = 227856775 GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC ) 1 0.00065 0.00065 0.00065 0.00065
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 1 0.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query( SELECT t.id AS `AUTO_TYPE_ID`, t.`name` AS `AUTO_TYPE_NAME`, mo.`NAMESHORT` AS `AUTO_MODEL_NAME`, mo.`ID` AS `AUTO_MODEL_ID`, ma.`ID` AS `AUTO_MARK_ID`, ma.`NAMESHORT` AS `AUTO_MARK_NAME`, s.G0ID, s.G0NAME, s.G1NAME, s.SMALLPICTUREINDEX, s.PPID AS ID, s.NAME AS NAME FROM `sp_acat2catalog` INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id` INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3 INNER JOIN marks ma ON ma.ID = s.MARKID INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3 INNER JOIN models mo ON mo.ID = s.MODELID INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3 WHERE `sp_acat2catalog`.`catalog_id` = 227856775 GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`, `t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`, `t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`, `t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`, `t`.`question`, `t`.`state_change_reason`, `t`.`real_views` FROM `sp_reviews` `t` INNER JOIN sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId) AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10) 1 0.00078 0.00078 0.00078 0.00078
Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SELECT `word` FROM `morph_nouns_morf` WHERE code_parent = :codeParent AND plural = 1) 3 0.00060 0.00020 0.00019 0.00021
system.db.CDbCommand.query(SELECT `code_parent` FROM `morph_nouns_morf` WHERE word = :word) 3 0.00059 0.00020 0.00018 0.00021
system.db.CDbCommand.query(SELECT `code` FROM `morph_nouns` WHERE word = :word) 3 0.00057 0.00019 0.00018 0.00021
system.db.CDbCommand.query(SELECT `sp_product_groups`.* FROM `sp_product_group_products` LEFT JOIN `sp_product_groups` ON sp_product_group_products.key_hash=sp_product_groups.key_hash WHERE product_code=:product_code) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT `code_parent` FROM `morph_adjectives_morf` WHERE word = :word) 2 0.00042 0.00021 0.00020 0.00022
system.db.CDbCommand.query(SELECT * FROM `sp_fast_reviews` `t` WHERE good_code=:good_code ORDER BY created_at DESC LIMIT 10) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT `code` FROM `morph_adjectives` WHERE word = :word) 2 0.00040 0.00020 0.00019 0.00021
system.db.CDbCommand.query(SELECT `word` FROM `morph_adjectives_morf` WHERE code_parent = :codeParent AND plural = 1) 2 0.00038 0.00019 0.00018 0.00020
system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t` WHERE (good_code=:good_code) AND (is_active = :is_active)) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `sp_rating2goods` WHERE (((rating BETWEEN :from AND :to) OR (group_rating BETWEEN :from AND :to) OR (rating IS NULL) OR (group_rating IS NULL))) AND (catalog_code IN ("373047"))) 1 0.00036 0.00036 0.00036 0.00036
SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code = '373047' GROUP BY `ce`.`external_id` 1 0.00053 0.00053 0.00053 0.00053
SELECT `ce`.`id`, `ce`.`external_id`, `cef`.`file`, `cep`.`product_code` FROM `sp_certs2` `ce` LEFT JOIN `sp_certs2_files` `cef` ON cef.cert_id = ce.id LEFT JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE ce.id = '107571' GROUP BY `cef`.`id`, `cep`.`id` 1 0.66939 0.66939 0.66939 0.66939
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00028 0.00028 0.00028 0.00028
Журнал приложения
Время Уровень Категория Сообщение
22:08:06.014084 trace system.CModule
Loading "log" application component
22:08:06.018141 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
22:08:06.018438 trace system.CModule
Loading "db" application component
22:08:06.018532 trace system.db.CDbConnection
Opening DB connection
22:08:06.019615 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
22:08:06.019629 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
22:08:06.019906 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
22:08:06.020097 trace system.CModule
Loading "urlHelper" application component
22:08:06.020222 trace system.CModule
Loading "DBConfig" application component
22:08:06.020261 trace system.CModule
Loading "cache" application component
22:08:06.021150 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
22:08:06.021421 trace system.CModule
Loading "geo" application component
22:08:06.021478 trace system.CModule
Loading "request" application component
22:08:06.022049 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
22:08:06.022084 trace system.db.ar.CActiveRecord
Location.findByPk()
22:08:06.022569 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
22:08:06.023076 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
22:08:06.023430 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`,
`t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`,
`ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS
`t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS
`t2_c2` FROM `b_sale_location` `t`  LEFT OUTER JOIN `b_sale_location_city`
`ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country`
`cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID)
AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC
22:08:06.023437 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS
`t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS
`t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS
`t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t`  LEFT
OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT
OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`)
WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC,
ct.NAME ASC)
22:08:06.023761 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID`
AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS
`t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`,
`ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`,
`cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t`  LEFT OUTER JOIN
`b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN
`b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE
((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC,
ct.NAME ASC)
22:08:06.023977 trace system.CModule
Loading "user" application component
22:08:06.024090 profile application
begin:loading session
22:08:06.024094 trace system.CModule
Loading "session" application component
22:08:06.024955 profile application
end:loading session
22:08:06.025510 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
22:08:06.025654 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
22:08:06.025721 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
22:08:06.025723 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
22:08:06.025949 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
22:08:06.026020 trace system.CModule
Loading "B2BConfig" application component
22:08:06.026077 trace system.CModule
Loading "urlManager" application component
22:08:06.026928 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
22:08:06.028959 trace system.CModule
Loading "themeInterlayer" application component
22:08:06.029556 trace system.CModule
Loading "themeManager" application component
22:08:06.029695 trace system.CModule
Loading "clientScript" application component
22:08:06.032109 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
22:08:06.032123 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
22:08:06.032125 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
22:08:06.032382 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
22:08:06.032428 trace system.CModule
Loading "cart" application component
22:08:06.032763 trace system.db.ar.CActiveRecord
CartUser.find()
22:08:06.033324 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
22:08:06.033381 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
22:08:06.033386 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
22:08:06.033624 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
22:08:06.033962 trace system.CModule
Loading "coupon" application component
22:08:06.034677 trace system.CModule
Loading "assetManager" application component
22:08:06.034934 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
22:08:06.035135 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
22:08:06.035188 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
22:08:06.035192 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1)
22:08:06.035454 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1)
22:08:06.038634 trace system.CModule
Loading "redisCache" application component
22:08:06.039412 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
22:08:06.039819 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
22:08:06.039942 profile application
begin:loading session
22:08:06.039946 profile application
end:loading session
22:08:06.041402 trace system.CModule
Loading "order" application component
22:08:06.041635 trace system.db.ar.CActiveRecord
Good.find()
22:08:06.041886 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
22:08:06.042174 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache
22:08:06.042231 trace system.CModule
Loading "ICatalog" application component
22:08:06.042370 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
22:08:06.042515 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_catalog_price"
from cache
22:08:06.042797 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache
22:08:06.042928 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32` FROM `b_iblock_element` `t`  WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE))
22:08:06.042932 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32` FROM `b_iblock_element` `t`  WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE)))
22:08:06.043596 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32` FROM `b_iblock_element` `t`  WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE)))
22:08:06.043890 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)  WHERE (`t`.`ID`=227856775)
22:08:06.043894 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`,
`mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`,
`mp`.`DESCRIPTION` AS `t1_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) 
WHERE (`t`.`ID`=227856775))
22:08:06.046408 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`,
`mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`,
`mp`.`DESCRIPTION` AS `t1_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) 
WHERE (`t`.`ID`=227856775))
22:08:06.052992 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS `t2_c0`,
`pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`,
`pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`,
`pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`,
`pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`,
`pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND
(pr.CATALOG_GROUP_ID IN (2,1))  WHERE (`t`.`ID`=227856775)
22:08:06.052995 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS
`t2_c0`, `pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`,
`pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`,
`pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`,
`pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`,
`pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND
(pr.CATALOG_GROUP_ID IN (2,1))  WHERE (`t`.`ID`=227856775))
22:08:06.053484 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS
`t2_c0`, `pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`,
`pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`,
`pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`,
`pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`,
`pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND
(pr.CATALOG_GROUP_ID IN (2,1))  WHERE (`t`.`ID`=227856775))
22:08:06.054723 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_certs2catalog"
from cache
22:08:06.054847 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS `t3_c0`,
`cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`,
`cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`,
`cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`,
`cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO`
AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`,
`cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`,
`cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`,
`cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`,
`cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`,
`cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`,
`cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`,
`cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`,
`cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS
`t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`,
`cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON
(`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr`
ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88)  WHERE
(`t`.`ID`=227856775)
22:08:06.054857 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS
`t3_c0`, `cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`,
`cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`,
`cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`,
`cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO`
AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`,
`cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`,
`cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`,
`cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`,
`cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`,
`cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`,
`cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`,
`cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`,
`cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS
`t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`,
`cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON
(`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr`
ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88)  WHERE
(`t`.`ID`=227856775))
22:08:06.055495 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS
`t3_c0`, `cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`,
`cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`,
`cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`,
`cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO`
AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`,
`cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`,
`cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`,
`cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`,
`cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`,
`cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`,
`cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`,
`cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`,
`cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS
`t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`,
`cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON
(`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr`
ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88)  WHERE
(`t`.`ID`=227856775))
22:08:06.055783 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache
22:08:06.055839 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS `t4_c0`,
`uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`, `uf`.`date_create`
AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status` AS `t4_c5`,
`uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`, `uf`.`review_id` AS
`t4_c8`, `uf`.`file_path` AS `t4_c9`, `uf`.`file_path_small` AS `t4_c10`
FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_user_good_file`
`userImage_uf` ON (`t`.`ID`=`userImage_uf`.`good_id`) LEFT OUTER JOIN
`sp_user_upload_file_for_good` `uf` ON (`uf`.`id`=`userImage_uf`.`file_id`)
AND (status IN (:ycp0, :ycp1))  WHERE (`t`.`ID`=227856775) ORDER BY sorter
22:08:06.055841 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t4_c0`, `uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`,
`uf`.`date_create` AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status`
AS `t4_c5`, `uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`,
`uf`.`review_id` AS `t4_c8`, `uf`.`file_path` AS `t4_c9`,
`uf`.`file_path_small` AS `t4_c10` FROM `b_iblock_element` `t` LEFT OUTER
JOIN `sp_user_good_file` `userImage_uf` ON
(`t`.`ID`=`userImage_uf`.`good_id`) LEFT OUTER JOIN
`sp_user_upload_file_for_good` `uf` ON (`uf`.`id`=`userImage_uf`.`file_id`)
AND (status IN (:ycp0, :ycp1))  WHERE (`t`.`ID`=227856775) ORDER BY sorter)
22:08:06.056349 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t4_c0`, `uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`,
`uf`.`date_create` AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status`
AS `t4_c5`, `uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`,
`uf`.`review_id` AS `t4_c8`, `uf`.`file_path` AS `t4_c9`,
`uf`.`file_path_small` AS `t4_c10` FROM `b_iblock_element` `t` LEFT OUTER
JOIN `sp_user_good_file` `userImage_uf` ON
(`t`.`ID`=`userImage_uf`.`good_id`) LEFT OUTER JOIN
`sp_user_upload_file_for_good` `uf` ON (`uf`.`id`=`userImage_uf`.`file_id`)
AND (status IN (:ycp0, :ycp1))  WHERE (`t`.`ID`=227856775) ORDER BY sorter)
22:08:06.057142 trace system.CModule
Loading "IPropeties" application component
22:08:06.060825 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
22:08:06.062257 trace system.CModule
Loading "warehouse" application component
22:08:06.062709 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
22:08:06.063057 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
22:08:06.063817 trace system.db.ar.CActiveRecord
lazy loading Good.msections
22:08:06.064141 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
22:08:06.064304 trace system.db.CDbCommand
Querying SQL: SELECT `ms`.`ELEMENT_ID` AS `t1_c0`, `ms`.`SECTION_ID` AS
`t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS `t1_c3` FROM
`sp_catalog2msections` `ms`  WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0)
22:08:06.064310 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms`  WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0))
22:08:06.064745 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms`  WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0))
22:08:06.064919 trace system.CModule
Loading "GoodSections" application component
22:08:06.064989 trace system.CModule
Loading "fcache" application component
22:08:06.077140 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
22:08:06.077347 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
22:08:06.077681 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
22:08:06.077687 trace system.CModule
Loading "dbTP" application component
22:08:06.077706 trace system.db.CDbConnection
Opening DB connection
22:08:06.078795 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
22:08:06.079068 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
22:08:06.079279 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t`  LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id)
22:08:06.111754 trace system.db.ar.CActiveRecord
TPAllPrices.findAll()
22:08:06.112018 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}"
from cache
22:08:06.112420 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}"
from cache
22:08:06.112996 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`sup_id` AS `t0_c1`,
`t`.`art_search` AS `t0_c2`, `t`.`art_replace` AS `t0_c3`, `t`.`brand_id`
AS `t0_c4`, `t`.`brand_art` AS `t0_c5`, `t`.`brand_name` AS `t0_c6`,
`t`.`name` AS `t0_c7`, `t`.`name_ext` AS `t0_c8`, `t`.`quantity` AS
`t0_c9`, `t`.`quantity_min` AS `t0_c10`, `t`.`quantity_expectation` AS
`t0_c11`, `t`.`quantity_expectation_min` AS `t0_c12`, `t`.`price_id` AS
`t0_c13`, `t`.`price` AS `t0_c14`, `t`.`price_purchase` AS `t0_c15`,
`t`.`price_retail` AS `t0_c16`, `t`.`delivery_date` AS `t0_c17`,
`t`.`package_type` AS `t0_c18`, `t`.`weight` AS `t0_c19`, `t`.`weight_id`
AS `t0_c20`, `t`.`sup_code` AS `t0_c21`, `t`.`date_added` AS `t0_c22`,
`t`.`art_supplier` AS `t0_c23`, `t`.`is_im_visible` AS `t0_c24`,
`t`.`price_rr` AS `t0_c25`, `supplier`.`id` AS `t1_c0`,
`supplier`.`legal_name` AS `t1_c1`, `supplier`.`name` AS `t1_c2`,
`supplier`.`address` AS `t1_c3`, `supplier`.`contact` AS `t1_c4`,
`supplier`.`is_load_price` AS `t1_c5`, `supplier`.`load_price_params` AS
`t1_c6`, `supplier`.`srok` AS `t1_c7`, `supplier`.`nacenka` AS `t1_c8`,
`supplier`.`is_ext_price` AS `t1_c9`, `supplier`.`ext_price_model` AS
`t1_c10`, `supplier`.`tmp_table_name` AS `t1_c11`,
`supplier`.`date_updated` AS `t1_c12`, `supplier`.`type` AS `t1_c13`,
`supplier`.`cfo` AS `t1_c14`, `supplier`.`adjective_field` AS `t1_c15`,
`supplier`.`adjective_value` AS `t1_c16`,
`supplier`.`adjective_price_field` AS `t1_c17`, `supplier`.`warehouses` AS
`t1_c18`, `supplier`.`use_for_replacement` AS `t1_c19`,
`supplier`.`lf_code` AS `t1_c20`, `supplier`.`purchase_channel` AS
`t1_c21`, `supplier`.`is_purchase_auto` AS `t1_c22`,
`supplier`.`api_auth_params` AS `t1_c23`, `supplier`.`comment` AS `t1_c24`,
`supplier`.`min_order_price` AS `t1_c25`, `supplier`.`is_official` AS
`t1_c26`, `supplier`.`is_by_codes` AS `t1_c27`,
`supplier`.`is_order_without_tp` AS `t1_c28`, `supplier`.`order_email` AS
`t1_c29`, `supplier`.`margin_type_id` AS `t1_c30`, `supplier`.`is_checkall`
AS `t1_c31`, `supplier`.`margin_id` AS `t1_c32`, `supplier`.`grid_id` AS
`t1_c33`, `supplier`.`quantity_min_restriction` AS `t1_c34`,
`supplier`.`encrypt_name` AS `t1_c35`,
`supplier`.`additional_adjective_field` AS `t1_c36`,
`supplier`.`additional_adjective_value` AS `t1_c37`,
`supplier`.`additional_adjective_price_field` AS `t1_c38`,
`supplier`.`auto_update` AS `t1_c39`, `supplier`.`is_price_rr_use` AS
`t1_c40`, `supplier`.`is_price_rr_less_deny` AS `t1_c41`,
`supplier`.`is_price_rr_greater_deny` AS `t1_c42`,
`supplier`.`is_manual_price` AS `t1_c43`, `supplier`.`margin_type` AS
`t1_c44`, `supplier`.`is_factory` AS `t1_c45`, `supplier`.`owner_id` AS
`t1_c46`, `supplier`.`response_time` AS `t1_c47`,
`supplier`.`days_to_return` AS `t1_c48`, `supplier`.`is_not_update` AS
`t1_c49`, `supplier`.`unique_delivery` AS `t1_c50`,
`supplier`.`is_fast_update` AS `t1_c51`, `supplier`.`update_version` AS
`t1_c52` FROM `tbl_allprices` `t`  LEFT OUTER JOIN `tbl_supplier`
`supplier` ON (`t`.`sup_id`=`supplier`.`id`) WHERE (((((t.is_im_visible =
1) AND (t.sup_id IN (:ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8,
:ycp9, :ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15, :ycp16, :ycp17,
:ycp18, :ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24, :ycp25, :ycp26,
:ycp27, :ycp28, :ycp29, :ycp30, :ycp31, :ycp32, :ycp33, :ycp34, :ycp35,
:ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41, :ycp42, :ycp43, :ycp44,
:ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50, :ycp51, :ycp52, :ycp53,
:ycp54, :ycp55, :ycp56, :ycp57, :ycp58, :ycp59, :ycp60, :ycp61, :ycp62,
:ycp63, :ycp64, :ycp65, :ycp66, :ycp67, :ycp68, :ycp69, :ycp70, :ycp71,
:ycp72, :ycp73, :ycp74, :ycp75, :ycp76, :ycp77, :ycp78, :ycp79, :ycp80,
:ycp81, :ycp82, :ycp83, :ycp84, :ycp85, :ycp86, :ycp87, :ycp88, :ycp89,
:ycp90, :ycp91, :ycp92, :ycp93, :ycp94, :ycp95, :ycp96, :ycp97, :ycp98,
:ycp99, :ycp100, :ycp101, :ycp102, :ycp103, :ycp104, :ycp105, :ycp106,
:ycp107, :ycp108, :ycp109, :ycp110, :ycp111, :ycp112, :ycp113, :ycp114,
:ycp115, :ycp116, :ycp117, :ycp118, :ycp119, :ycp120, :ycp121, :ycp122,
:ycp123, :ycp124, :ycp125, :ycp126, :ycp127, :ycp128, :ycp129, :ycp130,
:ycp131, :ycp132, :ycp133, :ycp134, :ycp135, :ycp136, :ycp137, :ycp138,
:ycp139))) AND (t.sup_code=:ycp140)) AND (supplier.is_by_codes = 1)) AND
(t.date_added > :date_added))
22:08:06.115799 trace system.db.ar.CActiveRecord
lazy loading Good.groups
22:08:06.116050 trace system.db.CDbCommand
Querying SQL: SELECT `gr`.`ID` AS `t1_c0`, `gr`.`TIMESTAMP_X` AS `t1_c1`,
`gr`.`MODIFIED_BY` AS `t1_c2`, `gr`.`DATE_CREATE` AS `t1_c3`,
`gr`.`CREATED_BY` AS `t1_c4`, `gr`.`IBLOCK_ID` AS `t1_c5`,
`gr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `gr`.`ACTIVE` AS `t1_c7`,
`gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS `t1_c9`, `gr`.`NAME` AS
`t1_c10`, `gr`.`PICTURE` AS `t1_c11`, `gr`.`LEFT_MARGIN` AS `t1_c12`,
`gr`.`RIGHT_MARGIN` AS `t1_c13`, `gr`.`DEPTH_LEVEL` AS `t1_c14`,
`gr`.`DESCRIPTION` AS `t1_c15`, `gr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`gr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `gr`.`CODE` AS `t1_c18`,
`gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS `t1_c20`, `gr`.`DETAIL_PICTURE`
AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section`
`gr`  INNER JOIN `sp_catalog2msections` `groups_gr` ON
(`groups_gr`.`ELEMENT_ID`=:ypl0) AND (`gr`.`ID`=`groups_gr`.`SECTION_ID`)
AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") ORDER BY gr.LEFT_MARGIN,
gr.DEPTH_LEVEL
22:08:06.116055 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_section` `gr`  INNER JOIN `sp_catalog2msections`
`groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND
(`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE =
"Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL)
22:08:06.117115 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_section` `gr`  INNER JOIN `sp_catalog2msections`
`groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND
(`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE =
"Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL)
22:08:06.117410 trace system.db.ar.CActiveRecord
lazy loading Good.I_PREVIEW_PICTURE
22:08:06.117691 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
22:08:06.117799 trace system.db.CDbCommand
Querying SQL: SELECT `pp`.`ID` AS `t1_c0`, `pp`.`TIMESTAMP_X` AS `t1_c1`,
`pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT` AS `t1_c3`, `pp`.`WIDTH` AS
`t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`, `pp`.`CONTENT_TYPE` AS `t1_c6`,
`pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME` AS `t1_c8`, `pp`.`ORIGINAL_NAME`
AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10` FROM `b_file` `pp`  WHERE
(`pp`.`ID`=:ypl0)
22:08:06.117804 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`,
`pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT`
AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`,
`pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME`
AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10`
FROM `b_file` `pp`  WHERE (`pp`.`ID`=:ypl0))
22:08:06.118139 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`,
`pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT`
AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`,
`pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME`
AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10`
FROM `b_file` `pp`  WHERE (`pp`.`ID`=:ypl0))
22:08:06.118412 trace system.base.CModule
Loading "acat" module
22:08:06.118735 trace system.db.CDbCommand
Querying SQL: SELECT
											`id`,`aid`,`name`
										FROM
											`typeauto`

										WHERE

											`typeauto`.`idsite` = 3

										ORDER BY
											`typeauto`.`sort`
			
22:08:06.118740 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
											`id`,`aid`,`name`
										FROM
											`typeauto`

										WHERE

											`typeauto`.`idsite` = 3

										ORDER BY
											`typeauto`.`sort`
			)
22:08:06.119090 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
											`id`,`aid`,`name`
										FROM
											`typeauto`

										WHERE

											`typeauto`.`idsite` = 3

										ORDER BY
											`typeauto`.`sort`
			)
22:08:06.119188 trace system.db.CDbCommand
Querying SQL: 
		  					SELECT
		 
						`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`

		  					FROM
		  						`marks`,
		  						`s_marks`

		  					WHERE
		  						`s_marks`.`idsite` = 3 AND
		  						`marks`.`ID` = `s_marks`.`idmark`

		  					ORDER BY
		  						3
		  	
22:08:06.119191 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(
		  					SELECT
		 
						`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`

		  					FROM
		  						`marks`,
		  						`s_marks`

		  					WHERE
		  						`s_marks`.`idsite` = 3 AND
		  						`marks`.`ID` = `s_marks`.`idmark`

		  					ORDER BY
		  						3
		  	)
22:08:06.119790 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(
		  					SELECT
		 
						`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`

		  					FROM
		  						`marks`,
		  						`s_marks`

		  					WHERE
		  						`s_marks`.`idsite` = 3 AND
		  						`marks`.`ID` = `s_marks`.`idmark`

		  					ORDER BY
		  						3
		  	)
22:08:06.121337 trace system.db.CDbCommand
Querying SQL: 
        		SELECT
                    t.id AS `AUTO_TYPE_ID`,
                    t.`name` AS `AUTO_TYPE_NAME`,
                    mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
                    mo.`PATHICON` AS `ICO`,
                    mo.`ID` AS `AUTO_MODEL_ID`,
                    ma.`ID` AS `AUTO_MARK_ID`,
                    ma.`NAMESHORT` AS `AUTO_MARK_NAME`
                FROM
					`sp_acat2catalog`
					INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
    				INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
	    			INNER JOIN marks ma ON ma.ID = s.MARKID
					INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
					INNER JOIN models mo ON mo.ID = s.MODELID
					INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
                WHERE `sp_acat2catalog`.`catalog_id` = 227856775
                GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
        
22:08:06.121341 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(
        		SELECT
                    t.id AS `AUTO_TYPE_ID`,
                    t.`name` AS `AUTO_TYPE_NAME`,
                    mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
                    mo.`PATHICON` AS `ICO`,
                    mo.`ID` AS `AUTO_MODEL_ID`,
                    ma.`ID` AS `AUTO_MARK_ID`,
                    ma.`NAMESHORT` AS `AUTO_MARK_NAME`
                FROM
					`sp_acat2catalog`
					INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
    				INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
	    			INNER JOIN marks ma ON ma.ID = s.MARKID
					INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
					INNER JOIN models mo ON mo.ID = s.MODELID
					INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
                WHERE `sp_acat2catalog`.`catalog_id` = 227856775
                GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
        )
22:08:06.121988 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(
        		SELECT
                    t.id AS `AUTO_TYPE_ID`,
                    t.`name` AS `AUTO_TYPE_NAME`,
                    mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
                    mo.`PATHICON` AS `ICO`,
                    mo.`ID` AS `AUTO_MODEL_ID`,
                    ma.`ID` AS `AUTO_MARK_ID`,
                    ma.`NAMESHORT` AS `AUTO_MARK_NAME`
                FROM
					`sp_acat2catalog`
					INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
    				INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
	    			INNER JOIN marks ma ON ma.ID = s.MARKID
					INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
					INNER JOIN models mo ON mo.ID = s.MODELID
					INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
                WHERE `sp_acat2catalog`.`catalog_id` = 227856775
                GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
        )
22:08:06.122015 trace system.db.CDbCommand
Querying SQL: 
				SELECT
                    t.id AS `AUTO_TYPE_ID`,
                    t.`name` AS `AUTO_TYPE_NAME`,
                    mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
                    mo.`ID` AS `AUTO_MODEL_ID`,
                    ma.`ID` AS `AUTO_MARK_ID`,
                    ma.`NAMESHORT` AS `AUTO_MARK_NAME`,
                    s.G0ID,
                    s.G0NAME,
                    s.G1NAME,
                    s.SMALLPICTUREINDEX,
                    s.PPID AS ID,
                    s.NAME AS NAME
                FROM
					`sp_acat2catalog`
					INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
					INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
					INNER JOIN marks ma ON ma.ID = s.MARKID
					INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
					INNER JOIN models mo ON mo.ID = s.MODELID
					INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
                WHERE `sp_acat2catalog`.`catalog_id` = 227856775
                GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000
22:08:06.122019 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(
				SELECT
                    t.id AS `AUTO_TYPE_ID`,
                    t.`name` AS `AUTO_TYPE_NAME`,
                    mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
                    mo.`ID` AS `AUTO_MODEL_ID`,
                    ma.`ID` AS `AUTO_MARK_ID`,
                    ma.`NAMESHORT` AS `AUTO_MARK_NAME`,
                    s.G0ID,
                    s.G0NAME,
                    s.G1NAME,
                    s.SMALLPICTUREINDEX,
                    s.PPID AS ID,
                    s.NAME AS NAME
                FROM
					`sp_acat2catalog`
					INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
					INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
					INNER JOIN marks ma ON ma.ID = s.MARKID
					INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
					INNER JOIN models mo ON mo.ID = s.MODELID
					INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
                WHERE `sp_acat2catalog`.`catalog_id` = 227856775
                GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000)
22:08:06.122615 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(
				SELECT
                    t.id AS `AUTO_TYPE_ID`,
                    t.`name` AS `AUTO_TYPE_NAME`,
                    mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
                    mo.`ID` AS `AUTO_MODEL_ID`,
                    ma.`ID` AS `AUTO_MARK_ID`,
                    ma.`NAMESHORT` AS `AUTO_MARK_NAME`,
                    s.G0ID,
                    s.G0NAME,
                    s.G1NAME,
                    s.SMALLPICTUREINDEX,
                    s.PPID AS ID,
                    s.NAME AS NAME
                FROM
					`sp_acat2catalog`
					INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
					INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
					INNER JOIN marks ma ON ma.ID = s.MARKID
					INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
					INNER JOIN models mo ON mo.ID = s.MODELID
					INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
                WHERE `sp_acat2catalog`.`catalog_id` = 227856775
                GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000)
22:08:06.122637 trace system.db.ar.CActiveRecord
lazy loading Good.tags
22:08:06.123132 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_tags2catalog"
from cache
22:08:06.123184 trace system.db.CDbCommand
Querying SQL: SELECT `tg`.`ID` AS `t1_c0`, `tg`.`TIMESTAMP_X` AS `t1_c1`,
`tg`.`MODIFIED_BY` AS `t1_c2`, `tg`.`DATE_CREATE` AS `t1_c3`,
`tg`.`CREATED_BY` AS `t1_c4`, `tg`.`IBLOCK_ID` AS `t1_c5`,
`tg`.`IBLOCK_SECTION_ID` AS `t1_c6`, `tg`.`ACTIVE` AS `t1_c7`,
`tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO` AS `t1_c9`, `tg`.`SORT` AS
`t1_c10`, `tg`.`NAME` AS `t1_c11`, `tg`.`PREVIEW_PICTURE` AS `t1_c12`,
`tg`.`PREVIEW_TEXT` AS `t1_c13`, `tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`,
`tg`.`DETAIL_PICTURE` AS `t1_c15`, `tg`.`DETAIL_TEXT` AS `t1_c16`,
`tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`, `tg`.`SEARCHABLE_CONTENT` AS `t1_c18`,
`tg`.`WF_STATUS_ID` AS `t1_c19`, `tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`,
`tg`.`WF_NEW` AS `t1_c21`, `tg`.`WF_LOCKED_BY` AS `t1_c22`,
`tg`.`WF_DATE_LOCK` AS `t1_c23`, `tg`.`WF_COMMENTS` AS `t1_c24`,
`tg`.`IN_SECTIONS` AS `t1_c25`, `tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS
`t1_c27`, `tg`.`TAGS` AS `t1_c28`, `tg`.`TMP_ID` AS `t1_c29`,
`tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `tg`.`SHOW_COUNTER` AS `t1_c31`,
`tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM `b_iblock_element` `tg`  INNER
JOIN `sp_tags2catalog` `tags_tg` ON (`tags_tg`.`catalog_id`=:ypl0) AND
(`tg`.`ID`=`tags_tg`.`tag_id`) AND (tg.IBLOCK_ID = 50)
22:08:06.123188 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`,
`tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`,
`tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`,
`tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO`
AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`,
`tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`,
`tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`,
`tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`,
`tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`,
`tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`,
`tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`,
`tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS
`t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`,
`tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `tg`  INNER JOIN `sp_tags2catalog` `tags_tg` ON
(`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND
(tg.IBLOCK_ID = 50))
22:08:06.123856 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`,
`tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`,
`tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`,
`tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO`
AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`,
`tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`,
`tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`,
`tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`,
`tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`,
`tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`,
`tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`,
`tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS
`t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`,
`tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `tg`  INNER JOIN `sp_tags2catalog` `tags_tg` ON
(`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND
(tg.IBLOCK_ID = 50))
22:08:06.124824 trace system.db.ar.CActiveRecord
Articles.findAll()
22:08:06.125138 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_m52"
from cache
22:08:06.125336 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_s52"
from cache
22:08:06.125596 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND  mp.VALUE IN
(7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND  mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10
22:08:06.125598 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND  mp.VALUE IN
(7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND  mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10)
22:08:06.128321 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND  mp.VALUE IN
(7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND  mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10)
22:08:06.129034 trace system.db.ar.CActiveRecord
News.findAll()
22:08:06.129367 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
 mp.VALUE IN (7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND  mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE 
                AND t.ACTIVE_FROM < NOW()
                AND (t.ACTIVE_TO IS NULL 
                    OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10
22:08:06.129369 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
 mp.VALUE IN (7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND  mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE 
                AND t.ACTIVE_FROM < NOW()
                AND (t.ACTIVE_TO IS NULL 
                    OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10)
22:08:06.133941 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
 mp.VALUE IN (7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND  mp.VALUE IN (373047)))) AND (t.ACTIVE=:ACTIVE 
                AND t.ACTIVE_FROM < NOW()
                AND (t.ACTIVE_TO IS NULL 
                    OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10)
22:08:06.134166 trace system.db.ar.CActiveRecord
ReviewModel.findAll()
22:08:06.134398 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reviews"
from cache
22:08:06.134618 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id`, `t`.`user_id`, `t`.`seo_url`, `t`.`type_id`,
`t`.`status_id`, `t`.`meta_title`, `t`.`meta_description`, `t`.`title`,
`t`.`preview`, `t`.`content`, `t`.`views`, `t`.`created_at`,
`t`.`updated_at`, `t`.`published_at`, `t`.`question`,
`t`.`state_change_reason`, `t`.`real_views` FROM `sp_reviews` `t` INNER
JOIN sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id =
:goodId) AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10
22:08:06.134623 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`,
`t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`,
`t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`,
`t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`,
`t`.`question`, `t`.`state_change_reason`, `t`.`real_views` FROM
`sp_reviews` `t` INNER JOIN sp_review_product rp ON rp.review_id = t.id
WHERE (rp.product_id = :goodId) AND (t.status_id=:statusId) ORDER BY
t.published_at DESC LIMIT 10)
22:08:06.135402 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`,
`t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`,
`t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`,
`t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`,
`t`.`question`, `t`.`state_change_reason`, `t`.`real_views` FROM
`sp_reviews` `t` INNER JOIN sp_review_product rp ON rp.review_id = t.id
WHERE (rp.product_id = :goodId) AND (t.status_id=:statusId) ORDER BY
t.published_at DESC LIMIT 10)
22:08:06.135468 trace system.db.ar.CActiveRecord
FastReview.findAll()
22:08:06.135656 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_fast_reviews"
from cache
22:08:06.135720 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_fast_reviews` `t` WHERE
good_code=:good_code ORDER BY created_at DESC LIMIT 10
22:08:06.135724 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_fast_reviews` `t` WHERE
good_code=:good_code ORDER BY created_at DESC LIMIT 10)
22:08:06.136120 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_fast_reviews` `t` WHERE
good_code=:good_code ORDER BY created_at DESC LIMIT 10)
22:08:06.136193 trace system.db.ar.CActiveRecord
Question.count()
22:08:06.136399 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_questions"
from cache
22:08:06.136464 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `sp_questions` `t` WHERE
(good_code=:good_code) AND (is_active = :is_active)
22:08:06.136466 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t`
WHERE (good_code=:good_code) AND (is_active = :is_active))
22:08:06.136838 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t`
WHERE (good_code=:good_code) AND (is_active = :is_active))
22:08:06.138638 trace system.db.ar.CActiveRecord
CartUser.find()
22:08:06.138678 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
22:08:06.138680 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
22:08:06.138909 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
22:08:06.139584 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `sp_rating2goods`
WHERE (((rating BETWEEN :from AND :to) OR (group_rating BETWEEN :from AND
:to) OR (rating IS NULL) OR (group_rating IS NULL))) AND (catalog_code IN
("373047"))
22:08:06.139586 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `sp_rating2goods`
WHERE (((rating BETWEEN :from AND :to) OR (group_rating BETWEEN :from AND
:to) OR (rating IS NULL) OR (group_rating IS NULL))) AND (catalog_code IN
("373047")))
22:08:06.139950 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `sp_rating2goods`
WHERE (((rating BETWEEN :from AND :to) OR (group_rating BETWEEN :from AND
:to) OR (rating IS NULL) OR (group_rating IS NULL))) AND (catalog_code IN
("373047")))
22:08:06.141855 trace system.db.CDbCommand
Querying SQL: SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code
22:08:06.141859 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code)
22:08:06.142342 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code)
22:08:06.142777 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word
22:08:06.142781 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
22:08:06.142992 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
22:08:06.143028 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word
22:08:06.143030 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
22:08:06.143244 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
22:08:06.143275 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1
22:08:06.143276 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.143477 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.143507 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word
22:08:06.143508 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
22:08:06.143727 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
22:08:06.143764 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_adjectives`
WHERE word = :word
22:08:06.143767 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word)
22:08:06.143973 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word)
22:08:06.144001 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1
22:08:06.144005 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.144207 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.144242 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word
22:08:06.144244 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
22:08:06.144445 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
22:08:06.144470 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word
22:08:06.144473 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
22:08:06.144654 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
22:08:06.144680 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1
22:08:06.144681 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.144874 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.144901 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word
22:08:06.144905 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
22:08:06.145108 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
22:08:06.145139 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_adjectives`
WHERE word = :word
22:08:06.145143 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word)
22:08:06.145332 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word)
22:08:06.145359 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1
22:08:06.145361 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.145541 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.145575 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word
22:08:06.145576 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
22:08:06.145756 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
22:08:06.145781 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word
22:08:06.145785 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
22:08:06.145961 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
22:08:06.145987 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1
22:08:06.145988 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.146199 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
22:08:06.148375 profile yii3.db
begin:SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
22:08:06.148406 profile yii3.db
begin:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt
22:08:06.149303 profile yii3.db
end:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt
22:08:06.149483 profile yii3.db
end:SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
22:08:06.150028 profile yii3.db
begin:SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN
`sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code =
'373047' GROUP BY `ce`.`external_id`
22:08:06.150561 profile yii3.db
end:SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products`
`cep` ON cep.cert_id = ce.id WHERE cep.product_code = '373047' GROUP BY
`ce`.`external_id`
22:08:06.151027 profile yii3.db
begin:SELECT `ce`.`id`, `ce`.`external_id`, `cef`.`file`,
`cep`.`product_code` FROM `sp_certs2` `ce` LEFT JOIN `sp_certs2_files`
`cef` ON cef.cert_id = ce.id LEFT JOIN `sp_certs2_products` `cep` ON
cep.cert_id = ce.id WHERE ce.id = '107571' GROUP BY `cef`.`id`, `cep`.`id`