Экспресс доставка
Возврат 90 дней
Консультируем и принимаем заказы
с 9:00 до 22:00 (MSK)
по бесплатному телефону
с 9:00 до 20:00 (MSK) в
Max и Telegram
По запросу «1.2» найдено 51791 товар
Сортировать по:
Датчик давления воздуха AUDI A3 (08-) коллектора впускного MEAT&DORIA
Датчик давления воздуха AUDI A3 (08-) коллектора впускного MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 82246 все Артикулы доп.: 550263, 038906051DКод для заказа: 247604 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 250 ₽
563 ₽х4 в сплит
3
1
3
Бесплатная доставка
оптовые цены ?
Датчик температуры воздуха VW Golf (97-05) AUDI TT (98-06) MEAT&DORIA
Датчик температуры воздуха VW Golf (97-05) AUDI TT (98-06) MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 82122 все Артикулы доп.: 550495, 058905379Код для заказа: 291741 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
880 ₽
220 ₽х4 в сплит
6
1
6
Бесплатная доставка
оптовые цены ?
Датчик температуры воздуха VW Golf (03-13) AUDI A1 (11-13) MEAT&DORIA
Датчик температуры воздуха VW Golf (03-13) AUDI A1 (11-13) MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 82174 все Артикулы доп.: 550685, 06B905379DКод для заказа: 291858 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
890 ₽
223 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Датчик положения коленвала VW AUDI MEAT&DORIA
Датчик положения коленвала VW AUDI MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 87914 все Артикулы доп.: 550.103, 038957147EКод для заказа: 370087 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 050 ₽
513 ₽х4 в сплит
5
1
5
Бесплатная доставка
оптовые цены ?
Датчик положения коленвала VW Golf (97-05) MEAT&DORIA
Датчик положения коленвала VW Golf (97-05) MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 87278E все Артикулы доп.: 550.026, 036907601EКод для заказа: 370088 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 800 ₽
450 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Замок двери VW Golf задней правой MEAT&DORIA
Замок двери VW Golf задней правой MEAT&DORIA
4
Применяется: показать Артикул: 31152 Код для заказа: 400594 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
4 200 ₽
1 050 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Датчик фазы ВАЗ-2110-2112 MEAT&DORIA
Датчик фазы ВАЗ-2110-2112 MEAT&DORIA
6
Применяется: показать Артикул: 87642 все Артикулы доп.: KT104841, 2111-3706040Код для заказа: 402844 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
900 ₽
225 ₽х4 в сплит
6
1
6
Бесплатная доставка
оптовые цены ?
Группа контактная замка зажигания AUDI 80,100,A6 MEAT&DORIA
Группа контактная замка зажигания AUDI 80,100,A6 MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 24014 все Артикулы доп.: 4A0905849BКод для заказа: 433817 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 250 ₽
313 ₽х4 в сплит
10
1
10
Бесплатная доставка
оптовые цены ?
Привод стартера DAEWOO Nexia (08-16) (бендикс) MEAT&DORIA
Привод стартера DAEWOO Nexia (08-16) (бендикс) MEAT&DORIA
2
Применяется: показать Артикул: 47053 все Артикулы доп.: ZN1619, A005151060180Код для заказа: 470740 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 050 ₽
513 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Датчик VW Passat (88-91) включения фонаря заднего хода MEAT&DORIA
Датчик VW Passat (88-91) включения фонаря заднего хода MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 36031 все Артикулы доп.: 21760, 02A945413CКод для заказа: 496122 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
850 ₽
213 ₽х4 в сплит
3
1
3
Бесплатная доставка
оптовые цены ?
Фильтр топливный VW Golf (83-92) MEAT&DORIA
Фильтр топливный VW Golf (83-92) MEAT&DORIA
2
Применяется: показать Артикул: 4124 все Артикулы доп.: 1001270001, 026127177BКод для заказа: 522985 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 250 ₽
313 ₽х4 в сплит
8
1
8
Бесплатная доставка
оптовые цены ?
Переключатель VW Golf 2 (89-91),Passat B3 фар/поворотников MEAT&DORIA
Переключатель VW Golf 2 (89-91),Passat B3 фар/поворотников MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 23077 все Артикулы доп.: 1196201800, 535953513A01CКод для заказа: 548050 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 800 ₽
450 ₽х4 в сплит
7
1
7
Бесплатная доставка
оптовые цены ?
Термостат VW Jetta,Polo SKODA Fabia,Rapid MEAT&DORIA
Термостат VW Jetta,Polo SKODA Fabia,Rapid MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 92646 все Артикулы доп.: 03C121110AAКод для заказа: 548413 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Хабаровская (24ч)
1 300 ₽
1 300 ₽
325 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Выключатель VW Polo (11-) стоп-сигнала MEAT&DORIA
Выключатель VW Polo (11-) стоп-сигнала MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 35035 все Артикулы доп.: 1J0945511CКод для заказа: 638524 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 000 ₽
250 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Фланец VW Golf (06-13) AUDI A3 (04-08) системы охлаждения MEAT&DORIA
Фланец VW Golf (06-13) AUDI A3 (04-08) системы охлаждения MEAT&DORIA
6
Применяется: показать Артикул: 93241 все Артикулы доп.: 29888, 06A121132RКод для заказа: 662558 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
740 ₽
185 ₽х4 в сплит
8
1
8
Бесплатная доставка
оптовые цены ?
Реле CITROEN C5 свечей накала MEAT&DORIA
Реле CITROEN C5 свечей накала MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 7243000 Код для заказа: 713297 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
4 400 ₽
1 100 ₽х4 в сплит
3
1
3
Бесплатная доставка
оптовые цены ?
Датчик температуры воздуха VW Golf (00-05) MEAT&DORIA
Датчик температуры воздуха VW Golf (00-05) MEAT&DORIA
6
Применяется: показать Артикул: 82045 все Артикулы доп.: 550384, 046905379Код для заказа: 714071 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
950 ₽
238 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Датчик температуры FIAT Panda (91-03) охлаждающей жидкости MEAT&DORIA
Датчик температуры FIAT Panda (91-03) охлаждающей жидкости MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 82125 все Артикулы доп.: 46753479Код для заказа: 759606 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
830 ₽
208 ₽х4 в сплит
6
1
6
Бесплатная доставка
оптовые цены ?
Группа контактная замка зажигания AUDI A3 (08-) MEAT&DORIA
Группа контактная замка зажигания AUDI A3 (08-) MEAT&DORIA
6
Применяется: показать Артикул: 24012 все Артикулы доп.: 38638, 1K0905849BКод для заказа: 785039 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 150 ₽
288 ₽х4 в сплит
5
1
5
Бесплатная доставка
оптовые цены ?
Датчик VW Bora (99-05),Golf AUDI A2,A3,TT включения фонаря заднего хода MEAT&DORIA
Датчик VW Bora (99-05),Golf AUDI A2,A3,TT включения фонаря заднего хода MEAT&DORIA
6
Применяется: показать Артикул: 36035 все Артикулы доп.: 76215, 02K945415Код для заказа: 785040 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 250 ₽
313 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Переключатель подрулевой AUDI 80,90 MEAT&DORIA
Переключатель подрулевой AUDI 80,90 MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 23167 все Артикулы доп.: 32195351301CКод для заказа: 873665 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
870 ₽
218 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Термостат VW Polo (09-) MEAT&DORIA
Термостат VW Polo (09-) MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 92618 все Артикулы доп.: TH42383G1, 03C121110QКод для заказа: 904610 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 800 ₽
450 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Переключатель подрулевой VW Passat (94-96) указателей поворота MEAT&DORIA
Переключатель подрулевой VW Passat (94-96) указателей поворота MEAT&DORIA
1
Применяется: показать Артикул: 23214 все Артикулы доп.: 440.246, 1H095351301CКод для заказа: 926938 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
1 950 ₽
488 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Датчик детонации AUDI A3 (96-) MEAT&DORIA
Датчик детонации AUDI A3 (96-) MEAT&DORIA
1
Применяется: показать Артикул: 87619 все Артикулы доп.: 06A905377Код для заказа: 225575 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 150 ₽
538 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Датчик давления воздуха PEUGEOT Boxer CITROEN Jumper MEAT&DORIA
Датчик давления воздуха PEUGEOT Boxer CITROEN Jumper MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 82051 все Артикулы доп.: 9609269380Код для заказа: 643421 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
Наличие в
4 магазинах
1 шт.
Сабурово (24ч)
2 100 ₽
1 шт.
Хабаровская (24ч)
2 100 ₽
1 шт.
МКАД 6 км. (внут.)
2 100 ₽
1 шт.
МКАД 6 км (внеш.)
2 100 ₽
2 100 ₽
525 ₽х4 в сплит
5
1
5
Бесплатная доставка
оптовые цены ?
Датчик положения коленвала VW Polo (09-) MEAT&DORIA
Датчик положения коленвала VW Polo (09-) MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 87453 все Артикулы доп.: PE40235, 036906433CКод для заказа: 646088 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 350 ₽
588 ₽х4 в сплит
3
1
3
Бесплатная доставка
оптовые цены ?
Переключатель VW Golf 4 света MEAT&DORIA
Переключатель VW Golf 4 света MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 23811 все Артикулы доп.: P15-0036, 1C0941531A20HКод для заказа: 672621 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 350 ₽
588 ₽х4 в сплит
9
1
9
Бесплатная доставка
оптовые цены ?
Датчик положения распредвала VW Golf (95-),Passat (96-) AUDI A3 SKODA Fabia (00-) MEAT&DORIA
Датчик положения распредвала VW Golf (95-),Passat (96-) AUDI A3 SKODA Fabia (00-) MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 87480 все Артикулы доп.: 550254, 045957147BКод для заказа: 748904 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 350 ₽
588 ₽х4 в сплит
3
1
3
Бесплатная доставка
оптовые цены ?
Датчик давления VW Golf,Polo AUDI A2 SKODA Fabia Octavia (09-) коллектора впускного MEAT&DORIA
Датчик давления VW Golf,Polo AUDI A2 SKODA Fabia Octavia (09-) коллектора впускного MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 82150 все Артикулы доп.: 550194, 03D906051Код для заказа: 748905 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 000 ₽
500 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Выключатель VW Caddy света фар MEAT&DORIA
Выключатель VW Caddy света фар MEAT&DORIA
Оставить отзыв
Применяется: показать Артикул: 23808 все Артикулы доп.: 662440, 1K0941431AJREHКод для заказа: 762609 Производитель: MEAT&DORIA
Доставка дешевле
Доставка быстрее
2 250 ₽
563 ₽х4 в сплит
6
1
6
Бесплатная доставка
оптовые цены ?
Перейти к странице:

Уточните бренд, чтобы увидеть больше результатов


Производитель Артикул Описание
GENERAL MOTORS 12 Показать аналоги
MERCEDES 12 Показать аналоги
BMW 12 Показать аналоги
RENAULT 12 Показать аналоги
BERU 12 Показать аналоги
LESJOFORS 12 Показать аналоги
SWAG 12 Показать аналоги
MANN 12 Показать аналоги
MAHLE 12 Показать аналоги
BRISK 12 Показать аналоги
BOSCH 12 Показать аналоги
MGA 12 Колодки тормозные дисковые Показать аналоги
NGK 12 Датчик кислородный Показать аналоги
LUK 12 Показать аналоги
CHAMPION 12 Показать аналоги
EUROFILTER 12 Фильтр воздушный Показать аналоги
Наличие товара на складах и в магазинах, а также цена товара указана на 01.07.2026 19:30.
Цены и наличие товара во всех магазинах и складах обновляются 1 раз в час. При достаточном количестве товара в нужном вам магазине вы можете купить его без предзаказа.
Интернет-цена - действительна при заказе на сайте или через оператора call-центра по телефону 8 800 6006 966. При условии достаточного количества товара в момент заказа.
Цена в магазинах - розничная цена товара в торговых залах магазинов без предварительного заказа.
Представленные данные о запчастях на этой странице несут исключительно информационный характер.

Уточните категорию

Общий отчет (Время: 2.35020с, Память: 20,455Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
loading session 2 0.00061 0.00031 0.00000 0.00061
system.db.CDbCommand.query(SELECT `NAME`, `CODE` FROM `b_iblock_element` `t` LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE =:value AND (t.NAME LIKE :word0)) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE` AS `replace` FROM `b_iblock_element` `t` LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE = :value) 2 0.00042 0.00021 0.00020 0.00023
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00021 0.00021 0.00021 0.00021
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.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1) 1 0.00016 0.00016 0.00016 0.00016
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`, `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_iblock_element` `t` LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN (:ycp0, :ycp1, :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)))) 1 0.01497 0.01497 0.01497 0.01497
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS `t2_c0`, `uf`.`good_code` AS `t2_c1`, `uf`.`user_id` AS `t2_c2`, `uf`.`date_create` AS `t2_c3`, `uf`.`date_update` AS `t2_c4`, `uf`.`status` AS `t2_c5`, `uf`.`sorter` AS `t2_c6`, `uf`.`comment` AS `t2_c7`, `uf`.`review_id` AS `t2_c8`, `uf`.`file_path` AS `t2_c9`, `uf`.`file_path_small` AS `t2_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 (uf.status = :status) WHERE (`t`.`ID` IN (228386200, 228386248, 228386251, 228386269, 228386272, 228386293, 228386320, 228386386, 228386449, 228386494, 228386521, 228386557, 228386560, 228386671, 228386704, 228386794, 228386797, 228386911, 228386983, 228386986, 228387103, 228387133, 228387175, 228394033, 228394444, 228394450, 228394507, 228394684, 228394687, 228394720)) ORDER BY sorter) 1 0.00076 0.00076 0.00076 0.00076
Sphinx index catalog,catalog_morph,marketplace 2 3.74373 1.87186 1.48668 2.25705
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `ms`.`ELEMENT_ID` AS `t3_c0`, `ms`.`SECTION_ID` AS `t3_c1`, `ms`.`IBLOCK_ID` AS `t3_c2`, `ms`.`NUM` AS `t3_c3` FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_catalog2msections` `ms` ON (`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49) WHERE (`t`.`ID` IN (228386200, 228386248, 228386251, 228386269, 228386272, 228386293, 228386320, 228386386, 228386449, 228386494, 228386521, 228386557, 228386560, 228386671, 228386704, 228386794, 228386797, 228386911, 228386983, 228386986, 228387103, 228387133, 228387175, 228394033, 228394444, 228394450, 228394507, 228394684, 228394687, 228394720))) 1 0.00117 0.00117 0.00117 0.00117
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS `t4_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t4_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t4_c2`, `mp`.`VALUE` AS `t4_c3`, `mp`.`VALUE_TYPE` AS `t4_c4`, `mp`.`VALUE_ENUM` AS `t4_c5`, `mp`.`VALUE_NUM` AS `t4_c6`, `mp`.`DESCRIPTION` AS `t4_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) AND (mp.IBLOCK_PROPERTY_ID IN (2455,436,437,1892,2467)) WHERE (`t`.`ID` IN (228386200, 228386248, 228386251, 228386269, 228386272, 228386293, 228386320, 228386386, 228386449, 228386494, 228386521, 228386557, 228386560, 228386671, 228386704, 228386794, 228386797, 228386911, 228386983, 228386986, 228387103, 228387133, 228387175, 228394033, 228394444, 228394450, 228394507, 228394684, 228394687, 228394720))) 1 0.08780 0.08780 0.08780 0.08780
Sphinx search. total_found: 2309; time: 0.615 1 0.79032 0.79032 0.79032 0.79032
system.db.CDbCommand.query(call get_applied_by_catalog_ids_query('228386200,228386248,228386251,228386269,228386272,228386293,228386320,228386386,228386449,228386494,228386521,228386557,228386560,228386671,228386704,228386794,228386797,228386911,228386983,228386986,228387103,228387133,228387175,228394033,228394444,228394450,228394507,228394684,228394687,228394720', '1', '(cm.`name` LIKE "%1 2%")')) 1 0.02826 0.02826 0.02826 0.02826
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 ("247604","291741","291858","370087","370088","400594","402844","433817","470740","496122","522985","548050","548413","638524","662558","713297","714071","759606","785039","785040","873665","904610","926938","225575","643421","646088","672621","748904","748905","762609"))) 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY) 2 0.00039 0.00019 0.00018 0.00021
system.db.CDbCommand.query(SELECT * FROM `personal_settings` WHERE actor_uid=:uid AND actor_type=:type_id) 2 0.00037 0.00018 0.00017 0.00019
system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE (t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID)) 1 0.00030 0.00030 0.00030 0.00030
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.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SELECT * FROM `application_settings` `t` WHERE `t`.`domain`='dev7.autoall.ru' AND `t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT * FROM `application_settings` `t` WHERE `t`.`domain`='dev7.autoall.ru' AND `t`.`key`='paysystems.sberSplit.isEnabled' LIMIT 1) 1 0.00016 0.00016 0.00016 0.00016
Sphinx select id,@groupby,@distinct,@count,property_msection_id 1 1.48669 1.48669 1.48669 1.48669
Sphinx search. total_found: 51791; time: 0.586 1 1.64597 1.64597 1.64597 1.64597
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00019 0.00019 0.00019 0.00019
Журнал приложения
Время Уровень Категория Сообщение
20:14:45.823851 trace system.CModule
Loading "log" application component
20:14:45.827009 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
20:14:45.827220 trace system.CModule
Loading "db" application component
20:14:45.827281 trace system.db.CDbConnection
Opening DB connection
20:14:45.828165 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
20:14:45.828170 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
20:14:45.828363 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
20:14:45.828507 trace system.CModule
Loading "urlHelper" application component
20:14:45.828597 trace system.CModule
Loading "DBConfig" application component
20:14:45.828624 trace system.CModule
Loading "cache" application component
20:14:45.829428 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
20:14:45.829694 trace system.CModule
Loading "geo" application component
20:14:45.829751 trace system.CModule
Loading "request" application component
20:14:45.830156 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
20:14:45.830190 trace system.db.ar.CActiveRecord
Location.findByPk()
20:14:45.830522 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
20:14:45.830688 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
20:14:45.830821 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
20:14:45.830825 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)
20:14:45.831023 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)
20:14:45.831223 trace system.CModule
Loading "user" application component
20:14:45.831338 profile application
begin:loading session
20:14:45.831342 trace system.CModule
Loading "session" application component
20:14:45.831947 profile application
end:loading session
20:14:45.832285 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
20:14:45.832508 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
20:14:45.832592 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
20:14:45.832595 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
20:14:45.832772 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
20:14:45.832842 trace system.CModule
Loading "B2BConfig" application component
20:14:45.832899 trace system.CModule
Loading "urlManager" application component
20:14:45.833745 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
20:14:45.834445 trace system.CModule
Loading "themeInterlayer" application component
20:14:45.835030 trace system.CModule
Loading "themeManager" application component
20:14:45.835192 trace system.CModule
Loading "clientScript" application component
20:14:45.837337 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
20:14:45.837351 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
20:14:45.837353 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
20:14:45.837563 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
20:14:45.837594 trace system.CModule
Loading "cart" application component
20:14:45.837683 trace system.db.ar.CActiveRecord
CartUser.find()
20:14:45.837815 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
20:14:45.837848 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1
20:14:45.837852 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
20:14:45.838011 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
20:14:45.838284 trace system.CModule
Loading "coupon" application component
20:14:45.838381 trace system.db.ar.CActiveRecord
Cart.findAll()
20:14:45.838571 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
20:14:45.838973 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket_props"
from cache
20:14:45.839118 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))
20:14:45.839121 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)))
20:14:45.839303 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)))
20:14:45.839473 trace system.CModule
Loading "assetManager" application component
20:14:45.839634 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
20:14:45.839764 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
20:14:45.839797 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
20:14:45.839801 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)
20:14:45.839982 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)
20:14:45.840980 trace system.CModule
Loading "redisCache" application component
20:14:45.841751 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
20:14:45.842024 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
20:14:45.842149 profile application
begin:loading session
20:14:45.842153 profile application
end:loading session
20:14:45.843862 trace system.CModule
Loading "order" application component
20:14:45.847496 trace system.CModule
Loading "IPropeties" application component
20:14:45.850752 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
20:14:45.851263 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1408" from cache
20:14:45.851676 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
20:14:45.851788 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
20:14:45.851793 trace system.CModule
Loading "dbTP" application component
20:14:45.851811 trace system.db.CDbConnection
Opening DB connection
20:14:45.852829 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
20:14:45.853076 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
20:14:45.853243 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)
20:14:45.880779 trace system.CModule
Loading "ICatalog" application component
20:14:45.880971 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
20:14:45.883369 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
20:14:45.883675 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
20:14:45.883896 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)
20:14:45.912054 trace system.db.CDbCommand
Querying SQL: SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0)
20:14:45.912059 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0))
20:14:45.912553 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `NAME`, `CODE`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID =:block_id AND IBLOCK_PROPERTY_ID =:prop_id AND VALUE
=:value AND (t.NAME LIKE :word0))
20:14:45.912883 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`NAME` AS `pattern`, `t`.`CODE` AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value
20:14:45.912887 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
20:14:45.913084 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
20:14:45.913294 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
20:14:46.524367 profile application
begin:Sphinx search. total_found: 51791; time: 0.586
20:14:46.524558 trace system.db.ar.CActiveRecord
Good.findAll()
20:14:46.524893 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
20:14:46.525105 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache
20:14:46.525299 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
20:14:46.527626 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache
20:14:46.527849 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`, `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_iblock_element` `t`  LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN
(:ycp0, :ycp1, :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)))
20:14:46.527853 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`, `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_iblock_element` `t`  LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN
(:ycp0, :ycp1, :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))))
20:14:46.542823 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`, `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_iblock_element` `t`  LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE ((t.IBLOCK_ID = 24) AND (t.ID IN
(:ycp0, :ycp1, :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))))
20:14:46.545010 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache
20:14:46.545074 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS `t2_c0`,
`uf`.`good_code` AS `t2_c1`, `uf`.`user_id` AS `t2_c2`, `uf`.`date_create`
AS `t2_c3`, `uf`.`date_update` AS `t2_c4`, `uf`.`status` AS `t2_c5`,
`uf`.`sorter` AS `t2_c6`, `uf`.`comment` AS `t2_c7`, `uf`.`review_id` AS
`t2_c8`, `uf`.`file_path` AS `t2_c9`, `uf`.`file_path_small` AS `t2_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 (uf.status = :status)  WHERE (`t`.`ID` IN (228386200, 228386248,
228386251, 228386269, 228386272, 228386293, 228386320, 228386386,
228386449, 228386494, 228386521, 228386557, 228386560, 228386671,
228386704, 228386794, 228386797, 228386911, 228386983, 228386986,
228387103, 228387133, 228387175, 228394033, 228394444, 228394450,
228394507, 228394684, 228394687, 228394720)) ORDER BY sorter
20:14:46.545078 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t2_c0`, `uf`.`good_code` AS `t2_c1`, `uf`.`user_id` AS `t2_c2`,
`uf`.`date_create` AS `t2_c3`, `uf`.`date_update` AS `t2_c4`, `uf`.`status`
AS `t2_c5`, `uf`.`sorter` AS `t2_c6`, `uf`.`comment` AS `t2_c7`,
`uf`.`review_id` AS `t2_c8`, `uf`.`file_path` AS `t2_c9`,
`uf`.`file_path_small` AS `t2_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 (uf.status = :status)  WHERE (`t`.`ID` IN (228386200, 228386248,
228386251, 228386269, 228386272, 228386293, 228386320, 228386386,
228386449, 228386494, 228386521, 228386557, 228386560, 228386671,
228386704, 228386794, 228386797, 228386911, 228386983, 228386986,
228387103, 228387133, 228387175, 228394033, 228394444, 228394450,
228394507, 228394684, 228394687, 228394720)) ORDER BY sorter)
20:14:46.545836 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t2_c0`, `uf`.`good_code` AS `t2_c1`, `uf`.`user_id` AS `t2_c2`,
`uf`.`date_create` AS `t2_c3`, `uf`.`date_update` AS `t2_c4`, `uf`.`status`
AS `t2_c5`, `uf`.`sorter` AS `t2_c6`, `uf`.`comment` AS `t2_c7`,
`uf`.`review_id` AS `t2_c8`, `uf`.`file_path` AS `t2_c9`,
`uf`.`file_path_small` AS `t2_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 (uf.status = :status)  WHERE (`t`.`ID` IN (228386200, 228386248,
228386251, 228386269, 228386272, 228386293, 228386320, 228386386,
228386449, 228386494, 228386521, 228386557, 228386560, 228386671,
228386704, 228386794, 228386797, 228386911, 228386983, 228386986,
228387103, 228387133, 228387175, 228394033, 228394444, 228394450,
228394507, 228394684, 228394687, 228394720)) ORDER BY sorter)
20:14:46.546003 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `ms`.`ELEMENT_ID` AS `t3_c0`,
`ms`.`SECTION_ID` AS `t3_c1`, `ms`.`IBLOCK_ID` AS `t3_c2`, `ms`.`NUM` AS
`t3_c3` FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_catalog2msections`
`ms` ON (`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49)  WHERE
(`t`.`ID` IN (228386200, 228386248, 228386251, 228386269, 228386272,
228386293, 228386320, 228386386, 228386449, 228386494, 228386521,
228386557, 228386560, 228386671, 228386704, 228386794, 228386797,
228386911, 228386983, 228386986, 228387103, 228387133, 228387175,
228394033, 228394444, 228394450, 228394507, 228394684, 228394687,
228394720))
20:14:46.546005 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`ms`.`ELEMENT_ID` AS `t3_c0`, `ms`.`SECTION_ID` AS `t3_c1`,
`ms`.`IBLOCK_ID` AS `t3_c2`, `ms`.`NUM` AS `t3_c3` FROM `b_iblock_element`
`t` LEFT OUTER JOIN `sp_catalog2msections` `ms` ON
(`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49)  WHERE (`t`.`ID` IN
(228386200, 228386248, 228386251, 228386269, 228386272, 228386293,
228386320, 228386386, 228386449, 228386494, 228386521, 228386557,
228386560, 228386671, 228386704, 228386794, 228386797, 228386911,
228386983, 228386986, 228387103, 228387133, 228387175, 228394033,
228394444, 228394450, 228394507, 228394684, 228394687, 228394720)))
20:14:46.547173 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`ms`.`ELEMENT_ID` AS `t3_c0`, `ms`.`SECTION_ID` AS `t3_c1`,
`ms`.`IBLOCK_ID` AS `t3_c2`, `ms`.`NUM` AS `t3_c3` FROM `b_iblock_element`
`t` LEFT OUTER JOIN `sp_catalog2msections` `ms` ON
(`ms`.`ELEMENT_ID`=`t`.`ID`) AND (ms.IBLOCK_ID = 49)  WHERE (`t`.`ID` IN
(228386200, 228386248, 228386251, 228386269, 228386272, 228386293,
228386320, 228386386, 228386449, 228386494, 228386521, 228386557,
228386560, 228386671, 228386704, 228386794, 228386797, 228386911,
228386983, 228386986, 228387103, 228387133, 228387175, 228394033,
228394444, 228394450, 228394507, 228394684, 228394687, 228394720)))
20:14:46.552954 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS `t4_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t4_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t4_c2`,
`mp`.`VALUE` AS `t4_c3`, `mp`.`VALUE_TYPE` AS `t4_c4`, `mp`.`VALUE_ENUM` AS
`t4_c5`, `mp`.`VALUE_NUM` AS `t4_c6`, `mp`.`DESCRIPTION` AS `t4_c7` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) AND (mp.IBLOCK_PROPERTY_ID IN
(2455,436,437,1892,2467))  WHERE (`t`.`ID` IN (228386200, 228386248,
228386251, 228386269, 228386272, 228386293, 228386320, 228386386,
228386449, 228386494, 228386521, 228386557, 228386560, 228386671,
228386704, 228386794, 228386797, 228386911, 228386983, 228386986,
228387103, 228387133, 228387175, 228394033, 228394444, 228394450,
228394507, 228394684, 228394687, 228394720))
20:14:46.552958 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t4_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t4_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t4_c2`, `mp`.`VALUE` AS `t4_c3`, `mp`.`VALUE_TYPE` AS `t4_c4`,
`mp`.`VALUE_ENUM` AS `t4_c5`, `mp`.`VALUE_NUM` AS `t4_c6`,
`mp`.`DESCRIPTION` AS `t4_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) AND
(mp.IBLOCK_PROPERTY_ID IN (2455,436,437,1892,2467))  WHERE (`t`.`ID` IN
(228386200, 228386248, 228386251, 228386269, 228386272, 228386293,
228386320, 228386386, 228386449, 228386494, 228386521, 228386557,
228386560, 228386671, 228386704, 228386794, 228386797, 228386911,
228386983, 228386986, 228387103, 228387133, 228387175, 228394033,
228394444, 228394450, 228394507, 228394684, 228394687, 228394720)))
20:14:46.640763 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t4_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t4_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t4_c2`, `mp`.`VALUE` AS `t4_c3`, `mp`.`VALUE_TYPE` AS `t4_c4`,
`mp`.`VALUE_ENUM` AS `t4_c5`, `mp`.`VALUE_NUM` AS `t4_c6`,
`mp`.`DESCRIPTION` AS `t4_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) AND
(mp.IBLOCK_PROPERTY_ID IN (2455,436,437,1892,2467))  WHERE (`t`.`ID` IN
(228386200, 228386248, 228386251, 228386269, 228386272, 228386293,
228386320, 228386386, 228386449, 228386494, 228386521, 228386557,
228386560, 228386671, 228386704, 228386794, 228386797, 228386911,
228386983, 228386986, 228387103, 228387133, 228387175, 228394033,
228394444, 228394450, 228394507, 228394684, 228394687, 228394720)))
20:14:46.649522 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`NAME` AS `pattern`, `t`.`CODE` AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value
20:14:46.649525 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
20:14:46.649750 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`NAME` AS `pattern`, `t`.`CODE`
AS `replace`
FROM `b_iblock_element` `t`
LEFT JOIN `b_iblock_element_property` `mp` ON mp.IBLOCK_ELEMENT_ID = t.ID
WHERE IBLOCK_ID = :block_id AND IBLOCK_PROPERTY_ID = :prop_id AND VALUE =
:value)
20:14:46.649940 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
20:14:46.650343 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)
20:14:46.683650 profile application
begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
20:14:46.683656 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
20:14:47.380017 profile application
begin:Sphinx search. total_found: 2309; time: 0.615
20:14:47.381067 trace system.CModule
Loading "GoodSections" application component
20:14:47.381150 trace system.CModule
Loading "fcache" application component
20:14:47.391887 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
20:14:47.392183 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
20:14:47.402017 trace system.db.CDbCommand
Querying SQL: call
get_applied_by_catalog_ids_query('228386200,228386248,228386251,228386269,228386272,228386293,228386320,228386386,228386449,228386494,228386521,228386557,228386560,228386671,228386704,228386794,228386797,228386911,228386983,228386986,228387103,228387133,228387175,228394033,228394444,228394450,228394507,228394684,228394687,228394720',
'1', '(cm.`name` LIKE "%1 2%")')
20:14:47.402023 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('228386200,228386248,228386251,228386269,228386272,228386293,228386320,228386386,228386449,228386494,228386521,228386557,228386560,228386671,228386704,228386794,228386797,228386911,228386983,228386986,228387103,228387133,228387175,228394033,228394444,228394450,228394507,228394684,228394687,228394720',
'1', '(cm.`name` LIKE "%1 2%")'))
20:14:47.430285 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('228386200,228386248,228386251,228386269,228386272,228386293,228386320,228386386,228386449,228386494,228386521,228386557,228386560,228386671,228386704,228386794,228386797,228386911,228386983,228386986,228387103,228387133,228387175,228394033,228394444,228394450,228394507,228394684,228394687,228394720',
'1', '(cm.`name` LIKE "%1 2%")'))
20:14:47.431427 trace system.CModule
Loading "dbTecDoc" application component
20:14:47.431452 trace system.db.CDbConnection
Opening DB connection
20:14:47.432670 trace system.db.CDbCommand
Querying SQL: SELECT
    		  DISTINCT ab.level_id, ab.name, lan.description,
ab.is_russian_manufacturer
    	FROM
    		tp.tbl_analogs lan
    		INNER JOIN tp.tbl_allbrands ab ON (ab.id = lan.brand_id)
    	WHERE
    		lan.art_search = :art
20:14:47.434406 trace system.CModule
Loading "dbTecDoc2" application component
20:14:47.434427 trace system.db.CDbConnection
Opening DB connection
20:14:47.435275 trace system.db.CDbCommand
Querying SQL: call get_brandfilter_by_art_no_link_v7_1('12', 49, 66, 1, 66)
20:14:47.779272 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
("247604","291741","291858","370087","370088","400594","402844","433817","470740","496122","522985","548050","548413","638524","662558","713297","714071","759606","785039","785040","873665","904610","926938","225575","643421","646088","672621","748904","748905","762609"))
20:14:47.779278 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
("247604","291741","291858","370087","370088","400594","402844","433817","470740","496122","522985","548050","548413","638524","662558","713297","714071","759606","785039","785040","873665","904610","926938","225575","643421","646088","672621","748904","748905","762609")))
20:14:47.780168 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
("247604","291741","291858","370087","370088","400594","402844","433817","470740","496122","522985","548050","548413","638524","662558","713297","714071","759606","785039","785040","873665","904610","926938","225575","643421","646088","672621","748904","748905","762609")))
20:14:47.780350 trace system.CModule
Loading "warehouse" application component
20:14:47.780705 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
20:14:47.803602 trace system.CModule
Loading "goodTpl" application component
20:14:47.816210 trace system.CModule
Loading "microdataManager" application component
20:14:47.816859 trace system.CModule
Loading "widgetFactory" application component
20:14:47.827768 trace system.CModule
Loading "yandexEcom" application component
20:14:47.829461 trace system.db.ar.CActiveRecord
Bookmark.findAll()
20:14:47.829565 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_basket` `t` WHERE (t.LID = :CART_LID
and DELAY = "Y") AND (FUSER_ID=:FUSER_ID)
20:14:47.829569 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE
(t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID))
20:14:47.829865 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE
(t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID))
20:14:47.833607 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
20:14:47.833611 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:14:47.833801 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:14:47.833854 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
20:14:47.834017 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:application_settings"
from cache
20:14:47.834078 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `application_settings` `t` WHERE
`t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1
20:14:47.834080 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1)
20:14:47.834239 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1)
20:14:47.834809 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
20:14:47.834811 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:14:47.834986 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:14:47.834997 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
20:14:47.835071 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `application_settings` `t` WHERE
`t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.sberSplit.isEnabled' LIMIT 1
20:14:47.835072 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.sberSplit.isEnabled' LIMIT 1)
20:14:47.835231 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `application_settings` `t`
WHERE `t`.`domain`='dev7.autoall.ru' AND
`t`.`key`='paysystems.sberSplit.isEnabled' LIMIT 1)
20:14:47.977274 trace system.CModule
Loading "coreMessages" application component
20:14:48.113564 trace system.CModule
Loading "GoodPropDesc" application component
20:14:48.114075 trace system.caching.CFileCache
Serving "iblock_properties_desc" from cache
20:14:48.115223 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCodes1Good744531bceb8d881d3bb05a8964626d23"
from cache
20:14:48.115547 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66744531bceb8d881d3bb05a8964626d23"
from cache
20:14:48.115674 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66744531bceb8d881d3bb05a8964626d23"
from cache
20:14:48.120460 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTaebc36c6e69e1397f684e0f9e0e811f2dcca48101505dd86b703689a604fe3c4"
from cache
20:14:48.121716 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPaebc36c6e69e1397f684e0f9e0e811f2dcca48101505dd86b703689a604fe3c4"
from cache
20:14:48.128228 trace system.db.ar.CActiveRecord
Cart.count()
20:14:48.128319 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE
FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY
20:14:48.128324 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
20:14:48.128531 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
20:14:48.130789 trace system.caching.CMemCache
Serving "CB:name:top_header_menu_delivery_desktop" from cache
20:14:48.131922 trace system.caching.CMemCache
Serving "CB:name:top_alert_desktop" from cache
20:14:48.133573 trace system.db.ar.CActiveRecord
Cart.count()
20:14:48.133624 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE
FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY
20:14:48.133625 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
20:14:48.133804 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t`
WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)
20:14:48.136954 trace system.caching.CMemCache
Serving "CB:name:bottom_job_desktop" from cache
20:14:48.137428 trace system.caching.CMemCache
Serving "CB:name:partners_desktop" from cache
20:14:48.137917 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_desktop" from cache
20:14:48.138365 trace system.CModule
Loading "territory" application component
20:14:48.142402 trace system.caching.CMemCache
Serving "ITerritory3" from cache
20:14:48.144820 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
20:14:48.149626 trace system.caching.CMemCache
Serving "CB:name:bottom_copy_text_desktop" from cache