Экспресс доставка
Возврат 90 дней
Консультируем и принимаем заказы
с 9:00 до 22:00 (MSK)
по бесплатному телефону
с 9:00 до 20:00 (MSK) в
Max и Telegram
По запросу «Т-3» найдено 6755 товаров
Сортировать по:
Катушка зажигания TOYOTA Corolla (02-04) (1.4/1.6/1.8) PEUGEOT 107 (05-) (1.0) ERA
Катушка зажигания TOYOTA Corolla (02-04) (1.4/1.6/1.8) PEUGEOT 107 (05-) (1.0) ERA
6
Применяется: показать Артикул: 880243 все Артикулы доп.: DIC-0100, 90080-19015/5970.88Код для заказа: 921638 Производитель: ERA
Наличие в
1 магазине
1 шт.
Черное
5 200 ₽
5 200 ₽
1 300 ₽х4 в сплит
0
1
0
оптовые цены ?
Датчик давления масла CITROEN C1 VERNET
Датчик давления масла CITROEN C1 VERNET
4
Применяется: показать Артикул: OS3557 Код для заказа: 935451 Производитель: VERNET
Наличие в
1 магазине
1 шт.
Черное
565 ₽
565 ₽
142 ₽х4 в сплит
0
1
0
оптовые цены ?
Колодки тормозные TOYOTA Corolla (99-),Yaris (99-05) задние (4шт.) NIBK
Колодки тормозные TOYOTA Corolla (99-),Yaris (99-05) задние (4шт.) NIBK
404
Применяется: показать Артикул: PN1454 все Артикулы доп.: GDB3243, 04466-52030Код для заказа: 936065 Производитель: NIBK
Доставка дешевле
Доставка быстрее
Наличие в
7 магазинах
1 шт.
Новогиреево (24ч)
2 615 ₽
1 шт.
Сабурово (24ч)
2 615 ₽
1 шт.
Хабаровская (24ч)
2 615 ₽
1 шт.
Вешняки
2 615 ₽
1 шт.
Кожухово
2 615 ₽
1 шт.
Тула
2 435 ₽
1 шт.
Нефтекамск
2 355 ₽
2 615 ₽
654 ₽х4 в сплит
10
1
10
Бесплатная доставка
оптовые цены ?
Щетка стеклоочистителя 650мм гибридная Hblade SWF
Щетка стеклоочистителя 650мм гибридная Hblade SWF
94
Артикул: 116185 все Артикулы доп.: 98350-2W100/98350-KDL65Код для заказа: 949727 Длина щетки, мм: 650 • Применяемость щетки: грузовой автомобиль • Тип щетки стеклоочистителя: гибридная • Тип крепления: Крючок • Производитель: SWF
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
3 шт.
Новогиреево (24ч)
2 500 ₽
2 500 ₽
625 ₽х4 в сплит
3
1
3
оптовые цены ?
Сальник TOYOTA Avensis (03-08) амортизатора переднего OE
Сальник TOYOTA Avensis (03-08) амортизатора переднего OE
Оставить отзыв
Применяется: показать Артикул: 90303-22002 Код для заказа: 666491 Производитель: TOYOTA/LEXUS
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
2 шт.
Новогиреево (24ч)
590 ₽
2 шт.
Сабурово (24ч)
590 ₽
590 ₽
148 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Фильтр масляный TOYOTA Avensis,Camry,Corolla JS ASAKASHI
Фильтр масляный TOYOTA Avensis,Camry,Corolla JS ASAKASHI
21
Применяется: показать Артикул: C110J все Артикулы доп.: OC534, 90915-YZZJ1Код для заказа: 495038 Производитель: JS ASAKASHI
Доставка дешевле
Доставка быстрее
475 ₽
119 ₽х4 в сплит
19
1
19
оптовые цены ?
Пыльник TOYOTA направляющей суппорта
Пыльник TOYOTA направляющей суппорта
1
Применяется: показать Артикул: 47775-50010 Код для заказа: 412015 Производитель: TOYOTA/LEXUS
Доставка дешевле
Доставка быстрее
Наличие в
7 магазинах
много
Новогиреево (24ч)
285 ₽
5 шт.
Сабурово (24ч)
285 ₽
5 шт.
Хабаровская (24ч)
285 ₽
4 шт.
Кожухово
285 ₽
2 шт.
Пролетарка (24ч)
285 ₽
4 шт.
Тула
270 ₽
4 шт.
Пермь 2
260 ₽
285 ₽
72 ₽х4 в сплит
16
1
16
оптовые цены ?
Прокладка ЛАДА RENAULT Logan,Megane датчика давления OE
Прокладка ЛАДА RENAULT Logan,Megane датчика давления OE
Оставить отзыв
Применяется: показать Артикул: 7703062063 Код для заказа: 639973 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
5 шт.
Новогиреево (24ч)
70 ₽
5 шт.
Раменское
65 ₽
70 ₽
18 ₽х4 в сплит
5
1
5
оптовые цены ?
Фильтр воздушный салона TOYOTA Camry MANN
Фильтр воздушный салона TOYOTA Camry MANN
66
Применяется: показать Артикул: CU2131 Код для заказа: 909006 Производитель: MANN
Доставка дешевле
Доставка быстрее
Наличие в
4 магазинах
2 шт.
Новогиреево (24ч)
930 ₽
2 шт.
Сабурово (24ч)
930 ₽
1 шт.
Хабаровская (24ч)
930 ₽
1 шт.
Кожухово
930 ₽
930 ₽
233 ₽х4 в сплит
9
1
9
Бесплатная доставка
оптовые цены ?
Стойка стабилизатора TOYOTA Corolla (01-07) переднего левая/правая LYNX
Стойка стабилизатора TOYOTA Corolla (01-07) переднего левая/правая LYNX
20
Применяется: показать Артикул: C7039LR все Артикулы доп.: 22993, 48820-32010Код для заказа: 996920 Производитель: LYNX
Доставка дешевле
Доставка быстрее
Наличие в
7 магазинах
2 шт.
Новогиреево (24ч)
1 150 ₽
2 шт.
Сабурово (24ч)
1 150 ₽
2 шт.
Хабаровская (24ч)
1 150 ₽
2 шт.
Кожухово
1 150 ₽
2 шт.
Пролетарка (24ч)
1 150 ₽
2 шт.
Подольск (24ч)
1 150 ₽
2 шт.
Тула
1 070 ₽
1 150 ₽
288 ₽х4 в сплит
6
1
6
Бесплатная доставка
оптовые цены ?
Аккумулятор SOLITE 50А/ч обратная полярность (куб)
Аккумулятор SOLITE 50А/ч обратная полярность (куб)
3
Артикул: 8809376160217 все Артикулы доп.: 6СТ50(0) CMF50ALКод для заказа: 499800 Полярность R-прямая: Нет • Полярность Е-обратная: Да • Емкость, Aч: 50 • Клеммы евро (толстые): Да • Клеммы азия (тонкие): Нет • Клеммы под гайку: Нет • Клеммы под болт: Нет • Клеммы америка (боковые): Нет • Клеммы мото: Нет • Залитый: Да • Производитель: SOLITE
Доставка дешевле
Доставка быстрее
Наличие в
11 магазинах
много
Новогиреево (24ч)
9 940 ₽
3 шт.
Сабурово (24ч)
9 940 ₽
2 шт.
Хабаровская (24ч)
9 940 ₽
2 шт.
Перово
9 940 ₽
3 шт.
Вешняки
9 940 ₽
2 шт.
Кожухово
9 940 ₽
2 шт.
Пролетарка (24ч)
9 940 ₽
1 шт.
Подольск (24ч)
9 940 ₽
1 шт.
Щёлково
9 940 ₽
2 шт.
Тула
9 450 ₽
1 шт.
Нефтекамск
8 450 ₽
9 940 ₽
2 485 ₽х4 в сплит
20
1
20
Бесплатная доставка
оптовые цены ?
Сальник коленвала CHEVROLET Cruze (12-),Orlando (11-),Aveo (12-) задний CORTECO
Сальник коленвала CHEVROLET Cruze (12-),Orlando (11-),Aveo (12-) задний CORTECO
9
Применяется: показать Артикул: 12013882B все Артикулы доп.: 90325571Код для заказа: 499968 Производитель: CORTECO
Доставка дешевле
Доставка быстрее
1 700 ₽
425 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Подшипник ступицы TOYOTA Avensis,Corolla (02-) передней LYNX
Подшипник ступицы TOYOTA Avensis,Corolla (02-) передней LYNX
25
Применяется: показать Артикул: WB1398 все Артикулы доп.: 24716, 90363-40066Код для заказа: 500043 Производитель: LYNX
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
2 шт.
Сабурово (24ч)
2 260 ₽
2 260 ₽
565 ₽х4 в сплит
4
1
4
Бесплатная доставка
оптовые цены ?
Сальник рапредвала BMW 3 (E21) (77-) ELRING
Сальник рапредвала BMW 3 (E21) (77-) ELRING
Оставить отзыв
Применяется: показать Артикул: 586.668 все Артикулы доп.: 11121285609Код для заказа: 513307 Производитель: ELRING
Доставка дешевле
Доставка быстрее
695 ₽
174 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Фильтр воздушный TOYOTA Celica FILTRON
Фильтр воздушный TOYOTA Celica FILTRON
378
Применяется: показать Артикул: AP147 все Артикулы доп.: 17801-16020-83Код для заказа: 516486 Производитель: FILTRON
Доставка дешевле
Доставка быстрее
1 190 ₽
298 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Фильтр масляный MANN W 818/81
Фильтр масляный MANN W 818/81
235
Применяется: показать Артикул: W818/81 Код для заказа: 309813 Производитель: MANN
Доставка дешевле
Доставка быстрее
1 090 ₽
273 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Пыльник ШРУСа наружного MASUMA
Пыльник ШРУСа наружного MASUMA
2
Применяется: показать Артикул: MF-2119 все Артикулы доп.: J2862003, 04438-YZZ03Код для заказа: 415872 Производитель: MASUMA
Доставка дешевле
Доставка быстрее
680 ₽
170 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Диск тормозной TOYOTA Celica (93-05) передний вентилируемый (1шт.) NIBK
Диск тормозной TOYOTA Celica (93-05) передний вентилируемый (1шт.) NIBK
Оставить отзыв
Применяется: показать Артикул: RN1058 все Артикулы доп.: DF4877, 43512-32301Код для заказа: 428866 Производитель: NIBK
Доставка дешевле
Доставка быстрее
4 200 ₽
1 050 ₽х4 в сплит
23
1
23
Бесплатная доставка
оптовые цены ?
Ролик приводного ремня TOYOTA Avensis,Corolla (03-) натяжителя FEBEST
Ролик приводного ремня TOYOTA Avensis,Corolla (03-) натяжителя FEBEST
1
Применяется: показать Артикул: 0187-ACA20 все Артикулы доп.: VKM61014, 16620-0W093Код для заказа: 433951 Производитель: FEBEST
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
1 350 ₽
1 350 ₽
338 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Сальник привода TOYOTA Corolla (08-13) левый OE
Сальник привода TOYOTA Corolla (08-13) левый OE
Оставить отзыв
Применяется: показать Артикул: 90311-35064 Код для заказа: 451569 Производитель: TOYOTA/LEXUS
Доставка дешевле
Доставка быстрее
Наличие в
4 магазинах
1 шт.
Новогиреево (24ч)
840 ₽
1 шт.
Сабурово (24ч)
840 ₽
1 шт.
Хабаровская (24ч)
840 ₽
1 шт.
Тула
785 ₽
840 ₽
210 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Опора шаровая TOYOTA Rav 4 (00-03) левая/правая PATRON
Опора шаровая TOYOTA Rav 4 (00-03) левая/правая PATRON
22
Применяется: показать Артикул: PS3108 все Артикулы доп.: 23111, 43330-19115Код для заказа: 498374 Производитель: PATRON
Доставка дешевле
Доставка быстрее
1 050 ₽
263 ₽х4 в сплит
2
1
2
Бесплатная доставка
оптовые цены ?
Втулка LEXUS RX300 (06-08) радиатора FEBEST
Втулка LEXUS RX300 (06-08) радиатора FEBEST
Оставить отзыв
Применяется: показать Артикул: TSB-129 все Артикулы доп.: 16535-20030Код для заказа: 514894 Производитель: FEBEST
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
2 шт.
Новогиреево (24ч)
455 ₽
1 шт.
Сабурово (24ч)
455 ₽
455 ₽
114 ₽х4 в сплит
3
1
3
оптовые цены ?
Сальник коленвала TOYOTA Avensis,Camry,Carina,Celica задний OE
Сальник коленвала TOYOTA Avensis,Camry,Carina,Celica задний OE
Оставить отзыв
Применяется: показать Артикул: 90311-85009 Код для заказа: 641529 Производитель: TOYOTA/LEXUS
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
2 340 ₽
2 340 ₽
585 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Фильтр топливный JCB 3CX,4CX,Robot (дв.PERKINS) короткий MANN
Фильтр топливный JCB 3CX,4CX,Robot (дв.PERKINS) короткий MANN
35
Применяется: показать Артикул: P917X все Артикулы доп.: KX23D/P556245/P917X, 32/401102/236628/1640376200Код для заказа: 707844 Производитель: MANN
Доставка дешевле
Доставка быстрее
1 750 ₽
438 ₽х4 в сплит
5
1
5
Бесплатная доставка
оптовые цены ?
Штуцер TOYOTA суппорта заднего OE
Штуцер TOYOTA суппорта заднего OE
Оставить отзыв
Применяется: показать Артикул: 47547-20010 Код для заказа: 725556 Производитель: TOYOTA/LEXUS
Доставка дешевле
Доставка быстрее
Наличие в
3 магазинах
1 шт.
Новогиреево (24ч)
625 ₽
2 шт.
Сабурово (24ч)
625 ₽
2 шт.
Хабаровская (24ч)
625 ₽
625 ₽
157 ₽х4 в сплит
3
1
3
Бесплатная доставка
оптовые цены ?
Фильтр масляный TOYOTA Auris,Avensis,Prius PATRON
Фильтр масляный TOYOTA Auris,Avensis,Prius PATRON
23
Применяется: показать Артикул: PF4102 все Артикулы доп.: 90915YZZD4Код для заказа: 968584 Производитель: PATRON
Доставка дешевле
Доставка быстрее
310 ₽
78 ₽х4 в сплит
2
1
2
оптовые цены ?
Пробка сливная RENAULT Logan поддона картера OE
Пробка сливная RENAULT Logan поддона картера OE
7
Применяется: показать Артикул: 7703075347 Код для заказа: 520223 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Кожухово
165 ₽
165 ₽
42 ₽х4 в сплит
1
1
1
оптовые цены ?
Опора шаровая TOYOTA Corolla (97-) нижняя левая/правая LYNX
Опора шаровая TOYOTA Corolla (97-) нижняя левая/правая LYNX
44
Применяется: показать Артикул: C1062LR все Артикулы доп.: 43330-19115Код для заказа: 526702 Производитель: LYNX
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
4 шт.
Новогиреево (24ч)
1 450 ₽
4 шт.
Сабурово (24ч)
1 450 ₽
1 450 ₽
363 ₽х4 в сплит
8
1
8
Бесплатная доставка
оптовые цены ?
Колодки тормозные TOYOTA Matrix (01-04) задние барабанные (4шт.) MASUMA
Колодки тормозные TOYOTA Matrix (01-04) задние барабанные (4шт.) MASUMA
Оставить отзыв
Применяется: показать Артикул: MK-2358 все Артикулы доп.: K2358, 04495-63011Код для заказа: 540066 Производитель: MASUMA
Доставка дешевле
Доставка быстрее
2 540 ₽
635 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Датчик температуры HYUNDAI HD120,AeroTown дв.D6DA19/22 охлаждающей жидкости VERNET
Датчик температуры HYUNDAI HD120,AeroTown дв.D6DA19/22 охлаждающей жидкости VERNET
1
Применяется: показать Артикул: WS2528 все Артикулы доп.: AA92E-18510Код для заказа: 554443 Производитель: VERNET
Доставка дешевле
Доставка быстрее
Наличие в
3 магазинах
1 шт.
Новогиреево (24ч)
550 ₽
1 шт.
Сабурово (24ч)
550 ₽
1 шт.
МКАД 6 км (внеш.)
550 ₽
550 ₽
138 ₽х4 в сплит
2
1
2
оптовые цены ?
Перейти к странице:
Наличие товара на складах и в магазинах, а также цена товара указана на 28.06.2026 19:30.
Цены и наличие товара во всех магазинах и складах обновляются 1 раз в час. При достаточном количестве товара в нужном вам магазине вы можете купить его без предзаказа.
Интернет-цена - действительна при заказе на сайте или через оператора call-центра по телефону 8 800 6006 966. При условии достаточного количества товара в момент заказа.
Цена в магазинах - розничная цена товара в торговых залах магазинов без предварительного заказа.
Представленные данные о запчастях на этой странице несут исключительно информационный характер.

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

Общий отчет (Время: 1.42010с, Память: 20,507Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
loading session 2 0.60171 0.30085 0.00000 0.60170
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.00294 0.00294 0.00294 0.00294
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 6 0.00120 0.00020 0.00017 0.00026
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) 3 0.00074 0.00025 0.00022 0.00027
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.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00022 0.00022 0.00022 0.00022
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 `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 (50492713, 50503534, 50504044, 50516209, 54971756, 55438565, 57225512, 57287243, 57348872, 57393782, 57632633, 57783518, 57894392, 66515998, 66547490, 67886023, 67891061, 67898263, 67901977, 67912607, 67934559, 67944837, 67955877, 67973703, 67979211, 68019771, 69171551, 70630529, 76306147, 83484881)) ORDER BY sorter) 1 0.00090 0.00090 0.00090 0.00090
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 (50492713, 50503534, 50504044, 50516209, 54971756, 55438565, 57225512, 57287243, 57348872, 57393782, 57632633, 57783518, 57894392, 66515998, 66547490, 67886023, 67891061, 67898263, 67901977, 67912607, 67934559, 67944837, 67955877, 67973703, 67979211, 68019771, 69171551, 70630529, 76306147, 83484881))) 1 0.00106 0.00106 0.00106 0.00106
Sphinx index catalog,catalog_morph,marketplace 2 1.29388 0.64694 0.56098 0.73290
Sphinx search. total_found: 1414; time: 0.083 1 0.43121 0.43121 0.43121 0.43121
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 (50492713, 50503534, 50504044, 50516209, 54971756, 55438565, 57225512, 57287243, 57348872, 57393782, 57632633, 57783518, 57894392, 66515998, 66547490, 67886023, 67891061, 67898263, 67901977, 67912607, 67934559, 67944837, 67955877, 67973703, 67979211, 68019771, 69171551, 70630529, 76306147, 83484881))) 1 0.04480 0.04480 0.04480 0.04480
system.db.CDbCommand.query(call get_applied_by_catalog_ids_query('50492713,50503534,50504044,50516209,54971756,55438565,57225512,57287243,57348872,57393782,57632633,57783518,57894392,66515998,66547490,67886023,67891061,67898263,67901977,67912607,67934559,67944837,67955877,67973703,67979211,68019771,69171551,70630529,76306147,83484881', '1', '(cm.`name` LIKE "%Т 3%")')) 1 0.02607 0.02607 0.02607 0.02607
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 ("921638","935451","936065","949727","666491","495038","412015","639973","909006","996920","499800","499968","500043","513307","516486","309813","415872","428866","433951","451569","498374","514894","641529","707844","725556","968584","520223","526702","540066","554443"))) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code LIMIT 1) 2 0.00052 0.00026 0.00019 0.00033
system.db.CDbCommand.query(SELECT * FROM `personal_settings` WHERE actor_uid=:uid AND actor_type=:type_id) 2 0.00044 0.00022 0.00022 0.00022
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.00034 0.00017 0.00016 0.00018
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.00025 0.00025 0.00025 0.00025
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 * FROM `application_settings` `t` WHERE `t`.`domain`='dev7.autoall.ru' AND `t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1) 1 0.00019 0.00019 0.00019 0.00019
Sphinx select id,@groupby,@distinct,@count,property_msection_id 1 0.56099 0.56099 0.56099 0.56099
Sphinx search. total_found: 6755; time: 0.075 1 0.65230 0.65230 0.65230 0.65230
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00024 0.00024 0.00024 0.00024
Журнал приложения
Время Уровень Категория Сообщение
20:34:23.689991 trace system.CModule
Loading "log" application component
20:34:23.692883 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
20:34:23.693089 trace system.CModule
Loading "db" application component
20:34:23.693144 trace system.db.CDbConnection
Opening DB connection
20:34:23.694118 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
20:34:23.694123 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
20:34:23.694366 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
20:34:23.694508 trace system.CModule
Loading "urlHelper" application component
20:34:23.694597 trace system.CModule
Loading "DBConfig" application component
20:34:23.694622 trace system.CModule
Loading "cache" application component
20:34:23.695461 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
20:34:23.695732 trace system.CModule
Loading "geo" application component
20:34:23.696144 trace system.CModule
Loading "request" application component
20:34:23.696563 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
20:34:23.696599 trace system.db.ar.CActiveRecord
Location.findByPk()
20:34:23.696926 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
20:34:23.697113 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
20:34:23.697248 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:34:23.697252 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:34:23.697474 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:34:23.697627 trace system.CModule
Loading "user" application component
20:34:23.697738 profile application
begin:loading session
20:34:23.697742 trace system.CModule
Loading "session" application component
20:34:24.299443 profile application
end:loading session
20:34:24.299910 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
20:34:24.300117 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
20:34:24.300203 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
20:34:24.300206 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
20:34:24.300499 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
20:34:24.300597 trace system.CModule
Loading "B2BConfig" application component
20:34:24.300673 trace system.CModule
Loading "urlManager" application component
20:34:24.301546 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
20:34:24.302294 trace system.CModule
Loading "themeInterlayer" application component
20:34:24.302889 trace system.CModule
Loading "themeManager" application component
20:34:24.303024 trace system.CModule
Loading "clientScript" application component
20:34:24.304781 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
20:34:24.304795 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
20:34:24.304797 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
20:34:24.305018 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
20:34:24.305049 trace system.CModule
Loading "cart" application component
20:34:24.305141 trace system.db.ar.CActiveRecord
CartUser.find()
20:34:24.305270 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
20:34:24.305305 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
20:34:24.305308 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:24.305493 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:24.305752 trace system.CModule
Loading "coupon" application component
20:34:24.305948 trace system.CModule
Loading "assetManager" application component
20:34:24.306104 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
20:34:24.306242 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
20:34:24.306276 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
20:34:24.306278 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:34:24.306474 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:34:24.307413 trace system.CModule
Loading "redisCache" application component
20:34:24.308191 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
20:34:24.308427 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
20:34:24.308543 profile application
begin:loading session
20:34:24.308547 profile application
end:loading session
20:34:24.309952 trace system.CModule
Loading "order" application component
20:34:24.312923 trace system.CModule
Loading "IPropeties" application component
20:34:24.316070 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
20:34:24.316531 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1408" from cache
20:34:24.316910 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
20:34:24.317019 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
20:34:24.317025 trace system.CModule
Loading "dbTP" application component
20:34:24.317043 trace system.db.CDbConnection
Opening DB connection
20:34:24.318109 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
20:34:24.318336 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
20:34:24.318500 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:34:24.344820 trace system.CModule
Loading "ICatalog" application component
20:34:24.345062 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
20:34:24.345633 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
20:34:24.345956 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
20:34:24.346183 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:34:24.372888 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:34:24.372891 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:34:24.373502 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:34:24.373656 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:34:24.373658 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:34:24.373881 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:34:24.374092 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
20:34:24.454691 profile application
begin:Sphinx search. total_found: 6755; time: 0.075
20:34:24.455082 trace system.db.ar.CActiveRecord
Good.findAll()
20:34:24.455447 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
20:34:24.455815 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:34:24.456218 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
20:34:24.458785 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache
20:34:24.459059 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:34:24.459064 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:34:24.461999 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:34:24.463608 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache
20:34:24.463664 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 (50492713, 50503534,
50504044, 50516209, 54971756, 55438565, 57225512, 57287243, 57348872,
57393782, 57632633, 57783518, 57894392, 66515998, 66547490, 67886023,
67891061, 67898263, 67901977, 67912607, 67934559, 67944837, 67955877,
67973703, 67979211, 68019771, 69171551, 70630529, 76306147, 83484881))
ORDER BY sorter
20:34:24.463666 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 (50492713, 50503534,
50504044, 50516209, 54971756, 55438565, 57225512, 57287243, 57348872,
57393782, 57632633, 57783518, 57894392, 66515998, 66547490, 67886023,
67891061, 67898263, 67901977, 67912607, 67934559, 67944837, 67955877,
67973703, 67979211, 68019771, 69171551, 70630529, 76306147, 83484881))
ORDER BY sorter)
20:34:24.464561 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 (50492713, 50503534,
50504044, 50516209, 54971756, 55438565, 57225512, 57287243, 57348872,
57393782, 57632633, 57783518, 57894392, 66515998, 66547490, 67886023,
67891061, 67898263, 67901977, 67912607, 67934559, 67944837, 67955877,
67973703, 67979211, 68019771, 69171551, 70630529, 76306147, 83484881))
ORDER BY sorter)
20:34:24.464709 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 (50492713, 50503534, 50504044, 50516209, 54971756, 55438565,
57225512, 57287243, 57348872, 57393782, 57632633, 57783518, 57894392,
66515998, 66547490, 67886023, 67891061, 67898263, 67901977, 67912607,
67934559, 67944837, 67955877, 67973703, 67979211, 68019771, 69171551,
70630529, 76306147, 83484881))
20:34:24.464711 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
(50492713, 50503534, 50504044, 50516209, 54971756, 55438565, 57225512,
57287243, 57348872, 57393782, 57632633, 57783518, 57894392, 66515998,
66547490, 67886023, 67891061, 67898263, 67901977, 67912607, 67934559,
67944837, 67955877, 67973703, 67979211, 68019771, 69171551, 70630529,
76306147, 83484881)))
20:34:24.465774 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
(50492713, 50503534, 50504044, 50516209, 54971756, 55438565, 57225512,
57287243, 57348872, 57393782, 57632633, 57783518, 57894392, 66515998,
66547490, 67886023, 67891061, 67898263, 67901977, 67912607, 67934559,
67944837, 67955877, 67973703, 67979211, 68019771, 69171551, 70630529,
76306147, 83484881)))
20:34:24.470225 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 (50492713, 50503534,
50504044, 50516209, 54971756, 55438565, 57225512, 57287243, 57348872,
57393782, 57632633, 57783518, 57894392, 66515998, 66547490, 67886023,
67891061, 67898263, 67901977, 67912607, 67934559, 67944837, 67955877,
67973703, 67979211, 68019771, 69171551, 70630529, 76306147, 83484881))
20:34:24.470227 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
(50492713, 50503534, 50504044, 50516209, 54971756, 55438565, 57225512,
57287243, 57348872, 57393782, 57632633, 57783518, 57894392, 66515998,
66547490, 67886023, 67891061, 67898263, 67901977, 67912607, 67934559,
67944837, 67955877, 67973703, 67979211, 68019771, 69171551, 70630529,
76306147, 83484881)))
20:34:24.515032 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
(50492713, 50503534, 50504044, 50516209, 54971756, 55438565, 57225512,
57287243, 57348872, 57393782, 57632633, 57783518, 57894392, 66515998,
66547490, 67886023, 67891061, 67898263, 67901977, 67912607, 67934559,
67944837, 67955877, 67973703, 67979211, 68019771, 69171551, 70630529,
76306147, 83484881)))
20:34:24.519246 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:34:24.519249 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:34:24.519503 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:34:24.519659 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
20:34:24.519890 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:34:24.546000 profile application
begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
20:34:24.546005 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
20:34:24.675781 profile application
begin:Sphinx search. total_found: 1414; time: 0.083
20:34:24.676434 trace system.CModule
Loading "GoodSections" application component
20:34:24.676549 trace system.CModule
Loading "fcache" application component
20:34:24.686482 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
20:34:24.686815 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
20:34:24.692951 trace system.db.CDbCommand
Querying SQL: call
get_applied_by_catalog_ids_query('50492713,50503534,50504044,50516209,54971756,55438565,57225512,57287243,57348872,57393782,57632633,57783518,57894392,66515998,66547490,67886023,67891061,67898263,67901977,67912607,67934559,67944837,67955877,67973703,67979211,68019771,69171551,70630529,76306147,83484881',
'1', '(cm.`name` LIKE "%Т 3%")')
20:34:24.692956 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('50492713,50503534,50504044,50516209,54971756,55438565,57225512,57287243,57348872,57393782,57632633,57783518,57894392,66515998,66547490,67886023,67891061,67898263,67901977,67912607,67934559,67944837,67955877,67973703,67979211,68019771,69171551,70630529,76306147,83484881',
'1', '(cm.`name` LIKE "%Т 3%")'))
20:34:24.719022 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('50492713,50503534,50504044,50516209,54971756,55438565,57225512,57287243,57348872,57393782,57632633,57783518,57894392,66515998,66547490,67886023,67891061,67898263,67901977,67912607,67934559,67944837,67955877,67973703,67979211,68019771,69171551,70630529,76306147,83484881',
'1', '(cm.`name` LIKE "%Т 3%")'))
20:34:24.720227 trace system.CModule
Loading "dbTecDoc" application component
20:34:24.720254 trace system.db.CDbConnection
Opening DB connection
20:34:24.721612 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:34:24.723773 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
("921638","935451","936065","949727","666491","495038","412015","639973","909006","996920","499800","499968","500043","513307","516486","309813","415872","428866","433951","451569","498374","514894","641529","707844","725556","968584","520223","526702","540066","554443"))
20:34:24.723778 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
("921638","935451","936065","949727","666491","495038","412015","639973","909006","996920","499800","499968","500043","513307","516486","309813","415872","428866","433951","451569","498374","514894","641529","707844","725556","968584","520223","526702","540066","554443")))
20:34:24.724452 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
("921638","935451","936065","949727","666491","495038","412015","639973","909006","996920","499800","499968","500043","513307","516486","309813","415872","428866","433951","451569","498374","514894","641529","707844","725556","968584","520223","526702","540066","554443")))
20:34:24.724670 trace system.CModule
Loading "warehouse" application component
20:34:24.725022 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
20:34:24.743854 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_uts_iblock_49_section"
from cache
20:34:24.748867 trace system.CModule
Loading "goodTpl" application component
20:34:24.758944 trace system.CModule
Loading "microdataManager" application component
20:34:24.759612 trace system.CModule
Loading "widgetFactory" application component
20:34:24.770590 trace system.CModule
Loading "yandexEcom" application component
20:34:24.772062 trace system.db.ar.CActiveRecord
CartUser.find()
20:34:24.772130 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
20:34:24.772135 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:24.772397 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:24.777224 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
20:34:24.777226 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:34:24.777447 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:34:24.777662 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
20:34:24.777843 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:application_settings"
from cache
20:34:24.777899 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:34:24.777903 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:34:24.778093 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:34:24.778723 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
20:34:24.778728 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:34:24.778949 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
20:34:24.778975 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
20:34:24.779103 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:34:24.779107 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:34:24.779356 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:34:24.938040 trace system.CModule
Loading "coreMessages" application component
20:34:25.019886 trace system.CModule
Loading "GoodPropDesc" application component
20:34:25.020417 trace system.caching.CFileCache
Serving "iblock_properties_desc" from cache
20:34:25.021287 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCodes1Goodca14885ec666a7ef9bac894c8a55cb9f"
from cache
20:34:25.021528 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66ca14885ec666a7ef9bac894c8a55cb9f"
from cache
20:34:25.021743 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods"
from cache
20:34:25.021869 trace system.db.ar.CActiveRecord
MpAttr.find()
20:34:25.022017 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_attrs"
from cache
20:34:25.022075 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
20:34:25.022079 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
20:34:25.022408 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
20:34:25.022449 trace system.db.ar.CActiveRecord
MpAttr.find()
20:34:25.022483 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
20:34:25.022485 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
20:34:25.022671 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
20:34:25.022778 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
20:34:25.023008 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:34:25.049062 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:34:25.049067 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:34:25.049335 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:34:25.051379 trace system.caching.CMemCache
Saving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66ca14885ec666a7ef9bac894c8a55cb9f"
to cache
20:34:25.051701 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66ca14885ec666a7ef9bac894c8a55cb9f"
from cache
20:34:25.055593 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTe1de79af418d76a8490836bb5b9a672ddcca48101505dd86b703689a604fe3c4"
from cache
20:34:25.056876 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPe1de79af418d76a8490836bb5b9a672ddcca48101505dd86b703689a604fe3c4"
from cache
20:34:25.062699 trace system.db.ar.CActiveRecord
CartUser.find()
20:34:25.062762 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
20:34:25.062764 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.062975 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.063746 trace system.db.ar.CActiveRecord
CartUser.find()
20:34:25.063781 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
20:34:25.063782 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.063961 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.063967 trace system.db.ar.CActiveRecord
Cart.count()
20:34:25.064177 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
20:34:25.064248 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:34:25.064249 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:34:25.064429 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:34:25.066771 trace system.caching.CMemCache
Serving "CB:name:top_header_menu_delivery_desktop" from cache
20:34:25.067852 trace system.caching.CMemCache
Serving "CB:name:top_alert_desktop" from cache
20:34:25.069482 trace system.db.ar.CActiveRecord
CartUser.find()
20:34:25.069519 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
20:34:25.069523 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.069716 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.069755 trace system.db.ar.CActiveRecord
CartUser.find()
20:34:25.069786 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
20:34:25.069787 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.069955 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
20:34:25.069961 trace system.db.ar.CActiveRecord
Cart.count()
20:34:25.070005 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:34:25.070008 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:34:25.070169 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:34:25.073246 trace system.caching.CMemCache
Serving "CB:name:bottom_job_desktop" from cache
20:34:25.073710 trace system.caching.CMemCache
Serving "CB:name:partners_desktop" from cache
20:34:25.074193 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_desktop" from cache
20:34:25.074677 trace system.CModule
Loading "territory" application component
20:34:25.079853 trace system.caching.CMemCache
Serving "ITerritory3" from cache
20:34:25.082293 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
20:34:25.087086 trace system.caching.CMemCache
Serving "CB:name:bottom_copy_text_desktop" from cache