( ! ) 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.0001443144{main}( ).../index.php:0
23.1682875936CApplication->run( ).../index.php:22
33.1682876296CWebApplication->processRequest( ).../CApplication.php:185
43.16951630944CWebApplication->runController( $route = 'price/part' ).../CWebApplication.php:141
53.17291681752CController->run( $actionID = 'part' ).../CWebApplication.php:282
63.17301681976CController->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 = 'Покупайте с выгодой Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ. Доставим! Артикул: 21800170110520. Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА" аналоги: 21800-1701105-20 21800170110520. Применяется на автомобилях: LADA Granta FL, LADA Granta FL Cross, LADA XRAY, LADA XRAY Cross, LADA Granta 2190, LADA Granta 2191(Liftback), LADA Granta Cross, LADA Vesta, LADA Vesta SW, LADA Vesta Cross, LADA Vest'...; public $pageKeywords = 'Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ, LADA, Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", 21800-1701105-20 21800170110520, 21800170110520, купить Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", продажа LADA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/val_kpp_vaz_2190_lada_vesta_vtorichnyiy_avtovaz-570665/'; public $pubdate = '2026-08-08'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/8cd/570665.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '10ee31adb6bdfb3abb38053ef957b23920b8207689bdd612fc894129bcbc3d9f'; 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 = '21800170110520 Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ - 21800-1701105-20 21800170110520 - фото, цена, описание, применимость. Купить в интернет-магазине 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
73.17311682792CFilterChain->run( ).../CController.php:291
83.17311683088CFilter->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 = 'Покупайте с выгодой Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ. Доставим! Артикул: 21800170110520. Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА" аналоги: 21800-1701105-20 21800170110520. Применяется на автомобилях: LADA Granta FL, LADA Granta FL Cross, LADA XRAY, LADA XRAY Cross, LADA Granta 2190, LADA Granta 2191(Liftback), LADA Granta Cross, LADA Vesta, LADA Vesta SW, LADA Vesta Cross, LADA Vest'...; public $pageKeywords = 'Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ, LADA, Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", 21800-1701105-20 21800170110520, 21800170110520, купить Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", продажа LADA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/val_kpp_vaz_2190_lada_vesta_vtorichnyiy_avtovaz-570665/'; public $pubdate = '2026-08-08'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/8cd/570665.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '10ee31adb6bdfb3abb38053ef957b23920b8207689bdd612fc894129bcbc3d9f'; 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 = '21800170110520 Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ - 21800-1701105-20 21800170110520 - фото, цена, описание, применимость. Купить в интернет-магазине 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
93.17341684112CFilterChain->run( ).../CFilter.php:40
103.17341684112CController->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 = 'Покупайте с выгодой Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ. Доставим! Артикул: 21800170110520. Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА" аналоги: 21800-1701105-20 21800170110520. Применяется на автомобилях: LADA Granta FL, LADA Granta FL Cross, LADA XRAY, LADA XRAY Cross, LADA Granta 2190, LADA Granta 2191(Liftback), LADA Granta Cross, LADA Vesta, LADA Vesta SW, LADA Vesta Cross, LADA Vest'...; public $pageKeywords = 'Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ, LADA, Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", 21800-1701105-20 21800170110520, 21800170110520, купить Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", продажа LADA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/val_kpp_vaz_2190_lada_vesta_vtorichnyiy_avtovaz-570665/'; public $pubdate = '2026-08-08'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/8cd/570665.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '10ee31adb6bdfb3abb38053ef957b23920b8207689bdd612fc894129bcbc3d9f'; 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 = '21800170110520 Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ - 21800-1701105-20 21800170110520 - фото, цена, описание, применимость. Купить в интернет-магазине 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
113.18132039736CAction->runWithParams( $params = ['name' => 'val_kpp_vaz_2190_lada_vesta_vtorichnyiy_avtovaz', 'code' => '570665'] ).../CController.php:308
123.18132039848CAction->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 = 'Покупайте с выгодой Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ. Доставим! Артикул: 21800170110520. Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА" аналоги: 21800-1701105-20 21800170110520. Применяется на автомобилях: LADA Granta FL, LADA Granta FL Cross, LADA XRAY, LADA XRAY Cross, LADA Granta 2190, LADA Granta 2191(Liftback), LADA Granta Cross, LADA Vesta, LADA Vesta SW, LADA Vesta Cross, LADA Vest'...; public $pageKeywords = 'Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ, LADA, Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", 21800-1701105-20 21800170110520, 21800170110520, купить Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", продажа LADA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/val_kpp_vaz_2190_lada_vesta_vtorichnyiy_avtovaz-570665/'; public $pubdate = '2026-08-08'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/8cd/570665.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '10ee31adb6bdfb3abb38053ef957b23920b8207689bdd612fc894129bcbc3d9f'; 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 = '21800170110520 Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ - 21800-1701105-20 21800170110520 - фото, цена, описание, применимость. Купить в интернет-магазине 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' => 'val_kpp_vaz_2190_lada_vesta_vtorichnyiy_avtovaz', 'code' => '570665'] ).../CAction.php:74
133.18132040184invokeArgs( $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 = 'Покупайте с выгодой Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ. Доставим! Артикул: 21800170110520. Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА" аналоги: 21800-1701105-20 21800170110520. Применяется на автомобилях: LADA Granta FL, LADA Granta FL Cross, LADA XRAY, LADA XRAY Cross, LADA Granta 2190, LADA Granta 2191(Liftback), LADA Granta Cross, LADA Vesta, LADA Vesta SW, LADA Vesta Cross, LADA Vest'...; public $pageKeywords = 'Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ, LADA, Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", 21800-1701105-20 21800170110520, 21800170110520, купить Запчасти для ВАЗ-1117-19, 2192-94 "КАЛИНА", продажа LADA, интернет магазин, доставка товара, AvtoALL.Ru'; public $canonical = 'https://dev7.autoall.ru/val_kpp_vaz_2190_lada_vesta_vtorichnyiy_avtovaz-570665/'; public $pubdate = '2026-08-08'; public $preloadImage = 'https://www.avtoall.ru/product_pictures/medium/8cd/570665.jpg'; public $isOrder = FALSE; public $parthnersCodeParams = [...]; public $webpackAssets = [...]; public $isAjaxPage = FALSE; protected $_secureKey = NULL; public $fullRoute = NULL; public $csrfToken = '10ee31adb6bdfb3abb38053ef957b23920b8207689bdd612fc894129bcbc3d9f'; 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 = '21800170110520 Вал КПП ВАЗ-2190,ЛАДА Vesta вторичный АвтоВАЗ - 21800-1701105-20 21800170110520 - фото, цена, описание, применимость. Купить в интернет-магазине 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 => '570665'] ).../CAction.php:114
143.18132040248PricePartAction->run( $code = '570665' ).../CAction.php:114
153.292919234648AA\Content\ProductCertificate\Services\ProductCertificateService->getCertificateByProductId( $productId = '570665' ).../PricePartAction.php:90
163.292919234648AA\Content\ProductCertificate\Repositories\Yii3DaoProductCertificateRepository->findByProductId( $productId = '570665' ).../ProductCertificateService.php:162
173.293919235872AA\Content\ProductCertificate\Repositories\Yii3DaoProductCertificateRepository->findByInternalId( $internalId = '89628' ).../Yii3DaoProductCertificateRepository.php:163
183.294019238312Yiisoft\Db\Query\Query->all( ).../Yii3DaoProductCertificateRepository.php:106
193.294119239312Yiisoft\Db\Command\AbstractCommand->queryAll( ).../Query.php:266
203.294119239312Yiisoft\Db\Mysql\Command->queryInternal( $queryMode = 4 ).../AbstractCommand.php:410
213.294119239312Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->queryInternal( $queryMode = 4 ).../Command.php:135
223.294219240784Yiisoft\Db\Command\AbstractCommand->queryInternal( $queryMode = 4 ).../AbstractPdoCommand.php:302
233.829232214544Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->internalGetQueryResult( $queryMode = 4 ).../AbstractCommand.php:611
243.829332214544fetchAll( $mode = 2 ).../AbstractPdoCommand.php:276
Общий отчет (Время: 3.94486с, Память: 126,354Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
loading session 2 3.15561 1.57781 0.00000 3.15561
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`=90366306)) 1 0.00312 0.00312 0.00312 0.00312
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.00117 0.00117 0.00117 0.00117
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.00086 0.00086 0.00086 0.00086
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`=90366306)) 1 0.00057 0.00057 0.00057 0.00057
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`=90366306) ORDER BY sorter) 1 0.00052 0.00052 0.00052 0.00052
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`=90366306)) 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.00048 0.00048 0.00048 0.00048
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.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID` AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`, `t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY` AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`, `t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`, `t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`, `t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS `t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS `t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS `t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS `t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS `t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS `t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`, `t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`, `t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`, `t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM `b_sale_basket` `t` WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND (FUSER_ID=:FUSER_ID))) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SELECT `id`,`aid`,`name` FROM `typeauto` WHERE `typeauto`.`idsite` = 3 ORDER BY `typeauto`.`sort` ) 1 0.00026 0.00026 0.00026 0.00026
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.00257 0.00257 0.00257 0.00257
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` = 90366306 GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC ) 1 0.00151 0.00151 0.00151 0.00151
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.00022 0.00022 0.00022 0.00022
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 (2139253)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (570665)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) 1 0.00305 0.00305 0.00305 0.00305
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 (2139253)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (570665)))) 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.00158 0.00158 0.00158 0.00158
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` = 90366306 GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) 1 0.00135 0.00135 0.00135 0.00135
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` 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.00082 0.00082 0.00082 0.00082
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.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT `code_parent` FROM `morph_nouns_morf` WHERE word = :word) 3 0.00058 0.00019 0.00017 0.00022
system.db.CDbCommand.query(SELECT `word` FROM `morph_nouns_morf` WHERE code_parent = :codeParent AND plural = 1) 3 0.00057 0.00019 0.00017 0.00023
system.db.CDbCommand.query(SELECT `code` FROM `morph_nouns` WHERE word = :word) 3 0.00056 0.00019 0.00018 0.00019
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.00056 0.00056 0.00056 0.00056
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 ("570665"))) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t` WHERE (good_code=:good_code) AND (is_active = :is_active)) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT * FROM `sp_fast_reviews` `t` WHERE good_code=:good_code ORDER BY created_at DESC LIMIT 10) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `code_parent` FROM `morph_adjectives_morf` WHERE word = :word) 2 0.00035 0.00018 0.00017 0.00018
Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt 1 0.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS `t0_c1`, `t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`, `t`.`model_id` AS `t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS `t0_c6`, `t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`, `t`.`reg_number` AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS `t0_c11`, `t`.`year` AS `t0_c12`, `t`.`date_create` AS `t0_c13`, `t`.`engine` AS `t0_c14`, `t`.`chassis` AS `t0_c15`, `t`.`carrying` AS `t0_c16`, `t`.`body` AS `t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id` AS `t0_c19`, `t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS `t0_c21`, `t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS `t0_c24`, `t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS `t0_c27`, `t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`, `t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`, `t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`, `t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`, `t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id` AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`, `catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`, `catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS `t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month` AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`, `catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort` AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS `t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`, `catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS `t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS `t2_c6`, `catt`.`construct_from_month` AS `t2_c7`, `catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS `t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`, `catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`, `catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM `sp_user_cars` `t` LEFT OUTER JOIN `cat_models` `catm` ON (`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON (`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active)) LIMIT 100) 1 0.00034 0.00034 0.00034 0.00034
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 1 0.00127 0.00127 0.00127 0.00127
SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code = '570665' GROUP BY `ce`.`external_id` 1 0.00056 0.00056 0.00056 0.00056
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 = '89628' GROUP BY `cef`.`id`, `cep`.`id` 1 0.65093 0.65093 0.65093 0.65093
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00025 0.00025 0.00025 0.00025
Журнал приложения
Время Уровень Категория Сообщение
06:35:49.498267 trace system.CModule
Loading "log" application component
06:35:49.500449 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
06:35:49.500633 trace system.CModule
Loading "db" application component
06:35:49.500684 trace system.db.CDbConnection
Opening DB connection
06:35:49.501718 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
06:35:49.501723 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
06:35:49.501971 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
06:35:49.502160 trace system.CModule
Loading "urlHelper" application component
06:35:49.502264 trace system.CModule
Loading "DBConfig" application component
06:35:49.502290 trace system.CModule
Loading "cache" application component
06:35:49.503037 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
06:35:49.503673 trace system.CModule
Loading "geo" application component
06:35:49.503750 trace system.CModule
Loading "request" application component
06:35:49.504857 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
06:35:49.504909 trace system.db.ar.CActiveRecord
Location.findByPk()
06:35:49.505264 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
06:35:49.505434 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
06:35:49.505568 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
06:35:49.505572 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)
06:35:49.505790 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)
06:35:49.505951 trace system.CModule
Loading "user" application component
06:35:49.506063 profile application
begin:loading session
06:35:49.506067 trace system.CModule
Loading "session" application component
06:35:52.661674 profile application
end:loading session
06:35:52.662170 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
06:35:52.662400 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
06:35:52.662493 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
06:35:52.662497 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
06:35:52.662764 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
06:35:52.662861 trace system.CModule
Loading "B2BConfig" application component
06:35:52.662930 trace system.CModule
Loading "urlManager" application component
06:35:52.664160 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
06:35:52.664741 trace system.CModule
Loading "themeInterlayer" application component
06:35:52.665445 trace system.CModule
Loading "themeManager" application component
06:35:52.665762 trace system.CModule
Loading "clientScript" application component
06:35:52.667881 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
06:35:52.667901 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
06:35:52.667906 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
06:35:52.668137 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
06:35:52.668169 trace system.CModule
Loading "cart" application component
06:35:52.668265 trace system.db.ar.CActiveRecord
CartUser.find()
06:35:52.668400 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
06:35:52.668437 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1
06:35:52.668440 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
06:35:52.668724 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
06:35:52.668976 trace system.CModule
Loading "coupon" application component
06:35:52.669128 trace system.db.ar.CActiveRecord
Cart.findAll()
06:35:52.669322 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
06:35:52.669578 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket_props"
from cache
06:35:52.669714 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID` AS `t0_c1`,
`t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID))
06:35:52.669719 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID`
AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID)))
06:35:52.669962 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID`
AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID)))
06:35:52.670135 trace system.CModule
Loading "assetManager" application component
06:35:52.670481 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
06:35:52.670638 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
06:35:52.670670 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
06:35:52.670674 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)
06:35:52.670875 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)
06:35:52.672931 trace system.CModule
Loading "redisCache" application component
06:35:52.674084 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
06:35:52.674426 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
06:35:52.674540 profile application
begin:loading session
06:35:52.674542 profile application
end:loading session
06:35:52.676008 trace system.CModule
Loading "order" application component
06:35:52.676209 trace system.db.ar.CActiveRecord
Good.find()
06:35:52.676434 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
06:35:52.676713 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache
06:35:52.676846 trace system.CModule
Loading "ICatalog" application component
06:35:52.676984 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
06:35:52.677133 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_catalog_price"
from cache
06:35:52.677567 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache
06:35:52.677736 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))
06:35:52.677741 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)))
06:35:52.678606 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)))
06:35:52.678848 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`=90366306)
06:35:52.678853 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`=90366306))
06:35:52.681973 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`=90366306))
06:35:52.689045 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`=90366306)
06:35:52.689049 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`=90366306))
06:35:52.689538 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`=90366306))
06:35:52.689867 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_certs2catalog"
from cache
06:35:52.689990 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`=90366306)
06:35:52.689996 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`=90366306))
06:35:52.690562 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`=90366306))
06:35:52.690799 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache
06:35:52.690854 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`=90366306) ORDER BY sorter
06:35:52.690856 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`=90366306) ORDER BY sorter)
06:35:52.691375 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`=90366306) ORDER BY sorter)
06:35:52.692420 trace system.CModule
Loading "IPropeties" application component
06:35:52.696719 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
06:35:52.699455 trace system.CModule
Loading "warehouse" application component
06:35:52.700040 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
06:35:52.700419 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
06:35:52.701312 trace system.db.ar.CActiveRecord
lazy loading Good.msections
06:35:52.701718 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
06:35:52.701910 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)
06:35:52.701917 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))
06:35:52.702402 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))
06:35:52.703006 trace system.CModule
Loading "GoodSections" application component
06:35:52.703125 trace system.CModule
Loading "fcache" application component
06:35:52.714351 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
06:35:52.714613 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
06:35:52.715090 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
06:35:52.715097 trace system.CModule
Loading "dbTP" application component
06:35:52.715120 trace system.db.CDbConnection
Opening DB connection
06:35:52.716351 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
06:35:52.716608 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
06:35:52.716785 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)
06:35:52.746011 trace system.db.ar.CActiveRecord
TPAllPrices.findAll()
06:35:52.746304 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}"
from cache
06:35:52.746670 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}"
from cache
06:35:52.747162 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, :ycp140, :ycp141))) AND (t.sup_code=:ycp142)) AND
(supplier.is_by_codes = 1)) AND (t.date_added > :date_added))
06:35:52.750221 trace system.db.ar.CActiveRecord
lazy loading Good.groups
06:35:52.750423 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
06:35:52.750427 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)
06:35:52.751594 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)
06:35:52.751962 trace system.db.ar.CActiveRecord
lazy loading Good.I_PREVIEW_PICTURE
06:35:52.752175 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
06:35:52.752305 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)
06:35:52.752310 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))
06:35:52.752674 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))
06:35:52.753040 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_uts_iblock_49_section"
from cache
06:35:52.753252 trace system.base.CModule
Loading "acat" module
06:35:52.753577 trace system.db.CDbCommand
Querying SQL: SELECT
											`id`,`aid`,`name`
										FROM
											`typeauto`

										WHERE

											`typeauto`.`idsite` = 3

										ORDER BY
											`typeauto`.`sort`
			
06:35:52.753582 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
											`id`,`aid`,`name`
										FROM
											`typeauto`

										WHERE

											`typeauto`.`idsite` = 3

										ORDER BY
											`typeauto`.`sort`
			)
06:35:52.753842 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
											`id`,`aid`,`name`
										FROM
											`typeauto`

										WHERE

											`typeauto`.`idsite` = 3

										ORDER BY
											`typeauto`.`sort`
			)
06:35:52.753911 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
		  	
06:35:52.753915 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
		  	)
06:35:52.756488 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
		  	)
06:35:52.758186 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` = 90366306
                GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
        
06:35:52.758189 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` = 90366306
                GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
        )
06:35:52.759697 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` = 90366306
                GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
        )
06:35:52.759771 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` = 90366306
                GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000
06:35:52.759773 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` = 90366306
                GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000)
06:35:52.761126 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` = 90366306
                GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000)
06:35:52.761181 trace system.db.ar.CActiveRecord
lazy loading Good.tags
06:35:52.761600 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_tags2catalog"
from cache
06:35:52.761646 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)
06:35:52.761648 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))
06:35:52.762207 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))
06:35:52.762933 trace system.db.ar.CActiveRecord
Articles.findAll()
06:35:52.763220 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_m52"
from cache
06:35:52.763428 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_s52"
from cache
06:35:52.763731 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 (2139253))
OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND  mp.VALUE IN
(570665)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10
06:35:52.763736 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 (2139253))
OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND  mp.VALUE IN
(570665)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10)
06:35:52.766788 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 (2139253))
OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND  mp.VALUE IN
(570665)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10)
06:35:52.767308 trace system.db.ar.CActiveRecord
News.findAll()
06:35:52.767705 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 (2139253)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE
AND  mp.VALUE IN (570665)))) 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
06:35:52.767709 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 (2139253)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE
AND  mp.VALUE IN (570665)))) 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)
06:35:52.769288 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 (2139253)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE
AND  mp.VALUE IN (570665)))) 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)
06:35:52.769429 trace system.db.ar.CActiveRecord
ReviewModel.findAll()
06:35:52.769634 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reviews"
from cache
06:35:52.769823 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` 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
06:35:52.769828 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` 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)
06:35:52.770647 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` 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)
06:35:52.770750 trace system.db.ar.CActiveRecord
FastReview.findAll()
06:35:52.770945 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_fast_reviews"
from cache
06:35:52.770997 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_fast_reviews` `t` WHERE
good_code=:good_code ORDER BY created_at DESC LIMIT 10
06:35:52.771001 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)
06:35:52.771378 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)
06:35:52.771439 trace system.db.ar.CActiveRecord
Question.count()
06:35:52.771637 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_questions"
from cache
06:35:52.771713 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `sp_questions` `t` WHERE
(good_code=:good_code) AND (is_active = :is_active)
06:35:52.771718 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))
06:35:52.772109 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))
06:35:52.774521 trace system.CModule
Loading "Garage" application component
06:35:52.774661 trace system.db.ar.CActiveRecord
UserCar.findAll()
06:35:52.774929 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_cars"
from cache
06:35:52.775196 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_models"
from cache
06:35:52.775468 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_types"
from cache
06:35:52.775784 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS `t0_c1`,
`t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`, `t`.`model_id` AS
`t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS `t0_c6`,
`t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`, `t`.`reg_number`
AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS `t0_c11`, `t`.`year`
AS `t0_c12`, `t`.`date_create` AS `t0_c13`, `t`.`engine` AS `t0_c14`,
`t`.`chassis` AS `t0_c15`, `t`.`carrying` AS `t0_c16`, `t`.`body` AS
`t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id` AS `t0_c19`,
`t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS `t0_c21`,
`t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS `t0_c24`,
`t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS `t0_c27`,
`t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`,
`t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`,
`t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`,
`t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`,
`t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id`
AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`,
`catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`,
`catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS
`t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month`
AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`,
`catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort`
AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS
`t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`,
`catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS
`t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS
`t2_c6`, `catt`.`construct_from_month` AS `t2_c7`,
`catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS
`t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`,
`catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`,
`catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM
`sp_user_cars` `t`  LEFT OUTER JOIN `cat_models` `catm` ON
(`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON
(`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active))
LIMIT 100
06:35:52.775790 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id`
AS `t0_c1`, `t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`,
`t`.`model_id` AS `t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS
`t0_c6`, `t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`,
`t`.`reg_number` AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS
`t0_c11`, `t`.`year` AS `t0_c12`, `t`.`date_create` AS `t0_c13`,
`t`.`engine` AS `t0_c14`, `t`.`chassis` AS `t0_c15`, `t`.`carrying` AS
`t0_c16`, `t`.`body` AS `t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id`
AS `t0_c19`, `t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS
`t0_c21`, `t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS
`t0_c24`, `t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS
`t0_c27`, `t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`,
`t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`,
`t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`,
`t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`,
`t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id`
AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`,
`catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`,
`catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS
`t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month`
AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`,
`catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort`
AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS
`t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`,
`catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS
`t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS
`t2_c6`, `catt`.`construct_from_month` AS `t2_c7`,
`catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS
`t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`,
`catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`,
`catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM
`sp_user_cars` `t`  LEFT OUTER JOIN `cat_models` `catm` ON
(`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON
(`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active))
LIMIT 100)
06:35:52.776129 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS
`t0_c1`, `t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`,
`t`.`model_id` AS `t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS
`t0_c6`, `t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`,
`t`.`reg_number` AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS
`t0_c11`, `t`.`year` AS `t0_c12`, `t`.`date_create` AS `t0_c13`,
`t`.`engine` AS `t0_c14`, `t`.`chassis` AS `t0_c15`, `t`.`carrying` AS
`t0_c16`, `t`.`body` AS `t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id`
AS `t0_c19`, `t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS
`t0_c21`, `t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS
`t0_c24`, `t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS
`t0_c27`, `t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`,
`t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`,
`t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`,
`t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`,
`t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id`
AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`,
`catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`,
`catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS
`t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month`
AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`,
`catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort`
AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS
`t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`,
`catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS
`t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS
`t2_c6`, `catt`.`construct_from_month` AS `t2_c7`,
`catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS
`t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`,
`catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`,
`catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM
`sp_user_cars` `t`  LEFT OUTER JOIN `cat_models` `catm` ON
(`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON
(`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active))
LIMIT 100)
06:35:52.776901 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
("570665"))
06:35:52.776905 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
("570665")))
06:35:52.777339 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
("570665")))
06:35:52.779920 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
06:35:52.779922 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)
06:35:52.780514 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)
06:35:52.781162 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word
06:35:52.781167 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
06:35:52.781390 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
06:35:52.781426 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word
06:35:52.781430 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
06:35:52.781615 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
06:35:52.781649 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1
06:35:52.781651 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
06:35:52.781876 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
06:35:52.781909 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word
06:35:52.781913 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
06:35:52.782094 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
06:35:52.782134 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word
06:35:52.782135 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
06:35:52.782321 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
06:35:52.782347 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word
06:35:52.782351 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
06:35:52.782532 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
06:35:52.782558 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1
06:35:52.782561 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
06:35:52.782732 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
06:35:52.782758 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word
06:35:52.782761 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
06:35:52.782932 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word)
06:35:52.782968 trace system.db.CDbCommand
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word
06:35:52.782970 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
06:35:52.783142 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word)
06:35:52.783168 trace system.db.CDbCommand
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word
06:35:52.783169 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
06:35:52.783363 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word)
06:35:52.783395 trace system.db.CDbCommand
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1
06:35:52.783396 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
06:35:52.783566 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1)
06:35:52.786201 profile yii3.db
begin:SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
06:35:52.786237 profile yii3.db
begin:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt
06:35:52.787226 profile yii3.db
end:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt
06:35:52.787467 profile yii3.db
end:SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
06:35:52.788137 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 =
'570665' GROUP BY `ce`.`external_id`
06:35:52.788696 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 = '570665' GROUP BY
`ce`.`external_id`
06:35:52.788944 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 = '89628' GROUP BY `cef`.`id`, `cep`.`id`