Экспресс доставка
Возврат 90 дней
Консультируем и принимаем заказы
с 9:00 до 22:00 (MSK)
по бесплатному телефону
с 9:00 до 20:00 (MSK) в
Max и Telegram
По запросу «20-14-21» найдено 2141 товар
Сортировать по:
Генератор МАЗ,ЛАЗ,УРАЛ дв.ЯМЗ-236,7511,7601 28В 80А (замена для 6582.3701000-03) КЗАТЭ (ЗиТ)
Генератор МАЗ,ЛАЗ,УРАЛ дв.ЯМЗ-236,7511,7601 28В 80А (замена для 6582.3701000-03) КЗАТЭ (ЗиТ)
Оставить отзыв
Применяется: показать Артикул: 6582.3701000-03ГЧ все Артикулы доп.: 6582.3701-03Код для заказа: 246579 Производитель: ЗиТ
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
МКАД 6 км. (внут.)
12 055 ₽
12 055 ₽
3 014 ₽х4 в сплит
3
1
3
Бесплатная доставка
оптовые цены ?
Генератор МАЗ,КРАЗ,УРАЛ дв.ЯМЗ-236,238 28В 47А (замена для Г288Е) КЗАТЭ (ЗиТ)
Генератор МАЗ,КРАЗ,УРАЛ дв.ЯМЗ-236,238 28В 47А (замена для Г288Е) КЗАТЭ (ЗиТ)
Оставить отзыв
Применяется: показать Артикул: Г288Е-3701000ГЧ все Артикулы доп.: Г288Е-3701000Код для заказа: 247366 Производитель: ЗиТ
Доставка дешевле
Доставка быстрее
11 685 ₽
2 922 ₽х4 в сплит
13
1
13
Бесплатная доставка
оптовые цены ?
Клапан впускной ЯМЗ Луганский Автоклапан
Клапан впускной ЯМЗ Луганский Автоклапан
Оставить отзыв
Применяется: показать Артикул: 236-1007010-В2 Код для заказа: 248306 Производитель: Луганск
Доставка дешевле
Доставка быстрее
1 490 ₽
373 ₽х4 в сплит
42
1
42
Бесплатная доставка
оптовые цены ?
Клапан выпускной ЯМЗ Луганск
Клапан выпускной ЯМЗ Луганск
Оставить отзыв
Применяется: показать Артикул: 236-1007015-В6 Код для заказа: 248308 Производитель: Автомотозапчасть
Доставка дешевле
Доставка быстрее
1 700 ₽
425 ₽х4 в сплит
33
1
33
оптовые цены ?
Привод вентилятора ЯМЗ-236БЕ,ДЕ,238БЕ,ДЕ с гидромуфтой в сборе АВТОДИЗЕЛЬ
Привод вентилятора ЯМЗ-236БЕ,ДЕ,238БЕ,ДЕ с гидромуфтой в сборе АВТОДИЗЕЛЬ
3
Применяется: показать Артикул: 238-1308011-В3 все Артикулы доп.: ТС107-1306100-06Код для заказа: 250064 Производитель: ЯМЗ
Доставка дешевле
Доставка быстрее
60 930 ₽
15 233 ₽х4 в сплит
96
1
96
оптовые цены ?
Кольцо КАМАЗ штуцера секции ТНВД (018-021-19-2-2) ЯЗДА
Кольцо КАМАЗ штуцера секции ТНВД (018-021-19-2-2) ЯЗДА
Оставить отзыв
Применяется: показать Артикул: 33.1111259-05 все Артикулы доп.: 33.1111259Код для заказа: 147106 Производитель: ЯЗДА
Доставка дешевле
Доставка быстрее
150 ₽
38 ₽х4 в сплит
115
1
115
оптовые цены ?
Прокладка КАМАЗ корректора ТНВД ЯЗДА
Прокладка КАМАЗ корректора ТНВД ЯЗДА
Оставить отзыв
Применяется: показать Артикул: 333.1110984 Код для заказа: 255254 Производитель: ЯЗДА
Доставка дешевле
Доставка быстрее
85 ₽
22 ₽х4 в сплит
6
1
6
оптовые цены ?
Элемент фильтрующий КАМАЗ-ЕВРО,ЯМЗ масляный (бумага) DIFA
Элемент фильтрующий КАМАЗ-ЕВРО,ЯМЗ масляный (бумага) DIFA
23
Применяется: показать Артикул: М5302К все Артикулы доп.: 840.1012039-12, 840-1012038-12Код для заказа: 260678 Производитель: DIFA
Доставка дешевле
Доставка быстрее
410 ₽
103 ₽х4 в сплит
19
1
19
оптовые цены ?
Фильтр гидравлический ЭО-3323 ЕК ЕТ АВТОКРАН Реготмас-661 DIFA
Фильтр гидравлический ЭО-3323 ЕК ЕТ АВТОКРАН Реготмас-661 DIFA
21
Применяется: показать Артикул: DIFA 5301 все Артикулы доп.: Р-661-1-05, 661-1-05Код для заказа: 260680 Производитель: DIFA
Доставка дешевле
Доставка быстрее
450 ₽
113 ₽х4 в сплит
109
1
109
оптовые цены ?
Элемент фильтрующий КАМАЗ-ЕВРО,ЯМЗ масляный (бумага) DIFA
Элемент фильтрующий КАМАЗ-ЕВРО,ЯМЗ масляный (бумага) DIFA
23
Применяется: показать Артикул: DIFA 5302 все Артикулы доп.: 840-1012038(40)-12, 840-1012038-12Код для заказа: 260719 Производитель: DIFA
Доставка дешевле
Доставка быстрее
340 ₽
85 ₽х4 в сплит
30
1
30
оптовые цены ?
Генератор КАМАЗ,МАЗ дв.ЯМЗ-236,238,КАМАЗ-740 дополнительная фаза 28В 60А ПРАМО
Генератор КАМАЗ,МАЗ дв.ЯМЗ-236,238,КАМАЗ-740 дополнительная фаза 28В 60А ПРАМО
Оставить отзыв
Применяется: показать Артикул: 1322.3771 Код для заказа: 265244 Производитель: ПРАМО
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Черное
6 915 ₽
6 915 ₽
1 729 ₽х4 в сплит
5
1
5
Бесплатная доставка
оптовые цены ?
Генератор МАЗ,КРАЗ,УРАЛ дв.ЯМЗ-236,238 28В 60А ПРАМО
Генератор МАЗ,КРАЗ,УРАЛ дв.ЯМЗ-236,238 28В 60А ПРАМО
51
Применяется: показать Артикул: 1702.3771 Код для заказа: 265247 Производитель: ПРАМО
Доставка дешевле
Доставка быстрее
8 710 ₽
2 178 ₽х4 в сплит
23
1
23
Бесплатная доставка
оптовые цены ?
Скоба ЯМЗ-236НЕ,НЕ2,БЕ,БЕ2,238М2,238Д,7511.10,240 трубок топливных ТНВД АВТОДИЗЕЛЬ
Скоба ЯМЗ-236НЕ,НЕ2,БЕ,БЕ2,238М2,238Д,7511.10,240 трубок топливных ТНВД АВТОДИЗЕЛЬ
Оставить отзыв
Применяется: показать Артикул: 240-1104459 Код для заказа: 265213 Производитель: ЯМЗ
Доставка дешевле
Доставка быстрее
210 ₽
53 ₽х4 в сплит
48
1
48
оптовые цены ?
Крышка ЯМЗ люка картера маховика АВТОДИЗЕЛЬ
Крышка ЯМЗ люка картера маховика АВТОДИЗЕЛЬ
Оставить отзыв
Применяется: показать Артикул: 236-1002318 Код для заказа: 269000 Производитель: ЯМЗ
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
2 шт.
Новогиреево (24ч)
270 ₽
1 шт.
МКАД 6 км. (внут.)
270 ₽
270 ₽
68 ₽х4 в сплит
13
1
13
оптовые цены ?
Колпачок ЯМЗ маслоотражательный в сборе АВТОДИЗЕЛЬ
Колпачок ЯМЗ маслоотражательный в сборе АВТОДИЗЕЛЬ
Оставить отзыв
Применяется: показать Артикул: 236-1007262 Код для заказа: 274620 Производитель: ЯМЗ
Доставка дешевле
Доставка быстрее
Наличие в
7 магазинах
много
Новогиреево (24ч)
250 ₽
8 шт.
Сабурово (24ч)
250 ₽
8 шт.
Хабаровская (24ч)
250 ₽
8 шт.
МКАД 6 км. (внут.)
250 ₽
8 шт.
Рябиновая
250 ₽
много
Пермь 2
225 ₽
много
Нефтекамск
225 ₽
250 ₽
63 ₽х4 в сплит
107
1
107
оптовые цены ?
Шайба 10.2х14.0х1.5 ЯМЗ крепления трубки топливной медная АВТОДИЗЕЛЬ
Шайба 10.2х14.0х1.5 ЯМЗ крепления трубки топливной медная АВТОДИЗЕЛЬ
Оставить отзыв
Применяется: показать Артикул: 312482-П34 Код для заказа: 274636 Производитель: ЯМЗ
Доставка дешевле
Доставка быстрее
Наличие в
6 магазинах
много
Новогиреево (24ч)
670 ₽
4 шт.
МКАД 6 км. (внут.)
670 ₽
4 шт.
МКАД 6 км (внеш.)
670 ₽
4 шт.
Рябиновая
670 ₽
4 шт.
Щёлково
670 ₽
много
Нефтекамск
605 ₽
670 ₽
168 ₽х4 в сплит
1181
1
1181
Бесплатная доставка
оптовые цены ?
Патрубок ЯМЗ-7511 соединительный (L=67,5мм,d=55) АВТОДИЗЕЛЬ
Патрубок ЯМЗ-7511 соединительный (L=67,5мм,d=55) АВТОДИЗЕЛЬ
Оставить отзыв
Применяется: показать Артикул: 7601.1013740 Код для заказа: 671033 Производитель: ЯМЗ
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Рябиновая
1 060 ₽
1 060 ₽
265 ₽х4 в сплит
6
1
6
Бесплатная доставка
оптовые цены ?
Сальник ЯМЗ вала первичного КПП передний 1.2-42х64х10 АВТОДИЗЕЛЬ
Сальник ЯМЗ вала первичного КПП передний 1.2-42х64х10 АВТОДИЗЕЛЬ
Оставить отзыв
Применяется: показать Артикул: 236-1701230 Код для заказа: 275347 Внутренний диаметр, мм: 42 • Внешний диаметр, мм: 64 • Толщина, мм: 10 • Производитель: ЯМЗ
625 ₽
157 ₽х4 в сплит
0
1
0
оптовые цены ?
Шестерня КПП ЯМЗ заднего хода 44 зуба АВТОДИЗЕЛЬ
Шестерня КПП ЯМЗ заднего хода 44 зуба АВТОДИЗЕЛЬ
Оставить отзыв
Применяется: показать Артикул: 238-1701140 Код для заказа: 275352 Производитель: ЯМЗ
Доставка дешевле
Доставка быстрее
13 200 ₽
3 300 ₽х4 в сплит
5
1
5
Бесплатная доставка
оптовые цены ?
Прокладка ЯМЗ-238Д болта крышки клапанной РД
Прокладка ЯМЗ-238Д болта крышки клапанной РД
Оставить отзыв
Применяется: показать Артикул: 204А-1003278 Код для заказа: 373429 Производитель: РУССКИЙ ДВИГАТЕЛЬ
Доставка дешевле
Доставка быстрее
Наличие в
6 магазинах
4 шт.
Новогиреево (24ч)
6 ₽
много
Хабаровская (24ч)
6 ₽
1 шт.
МКАД 6 км. (внут.)
6 ₽
6 шт.
Рябиновая
6 ₽
8 шт.
Щёлково
6 ₽
много
Пермь 2
6 ₽
6 ₽
2 ₽х4 в сплит
973
1
973
оптовые цены ?
Кольцо КАМАЗ уплотнительное форсунки силикон СТРОЙМАШ
Кольцо КАМАЗ уплотнительное форсунки силикон СТРОЙМАШ
8
Применяется: показать Артикул: 33.1112342 Код для заказа: 382054 Производитель: СТРОЙМАШ
Доставка дешевле
Доставка быстрее
40 ₽
10 ₽х4 в сплит
1142
1
1142
оптовые цены ?
Кольцо ЯМЗ-240 уплотнительное вала коленчатого силикон СТРОЙМАШ
Кольцо ЯМЗ-240 уплотнительное вала коленчатого силикон СТРОЙМАШ
8
Применяется: показать Артикул: 240-1005582-Б Код для заказа: 382055 Производитель: СТРОЙМАШ
Доставка дешевле
Доставка быстрее
20 ₽
5 ₽х4 в сплит
189
1
189
оптовые цены ?
Прокладка двигателя ЯМЗ-536 комплект полный силикон/фторсиликон (18 поз./62 дет.) СТРОЙМАШ
Прокладка двигателя ЯМЗ-536 комплект полный силикон/фторсиликон (18 поз./62 дет.) СТРОЙМАШ
Оставить отзыв
Применяется: показать Артикул: 5360-2000005 все Артикулы доп.: 658.1306054-01Код для заказа: 382063 Производитель: СТРОЙМАШ
Доставка дешевле
Доставка быстрее
15 080 ₽
3 770 ₽х4 в сплит
11
1
11
оптовые цены ?
Прокладка ЯМЗ колпака Ф.Г.О.М фторсиликон СТРОЙМАШ
Прокладка ЯМЗ колпака Ф.Г.О.М фторсиликон СТРОЙМАШ
Оставить отзыв
Применяется: показать Артикул: 840.1012083-10 Код для заказа: 382065 Производитель: СТРОЙМАШ
Доставка дешевле
Доставка быстрее
565 ₽
142 ₽х4 в сплит
48
1
48
оптовые цены ?
Лампа 24V H4 75/70W P43t Long Life MTF
Лампа 24V H4 75/70W P43t Long Life MTF
Оставить отзыв
Применяется: показать Артикул: HS2404 все Артикулы доп.: АКГ 24-75-70 (Н4)Код для заказа: 384215 Вольтаж, V: 24 • Мощность, W: 75/70 • Тип цоколя: P43t • Маркировка ламп: H4 • Производитель: MTF
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
3 шт.
МКАД 6 км (внеш.)
470 ₽
470 ₽
118 ₽х4 в сплит
7
1
7
оптовые цены ?
Прокладка двигателя ЯМЗ-7511.10 общая ГБЦ комплект силикон+ металл (52 наим.199 шт.) ПТП
Прокладка двигателя ЯМЗ-7511.10 общая ГБЦ комплект силикон+ металл (52 наим.199 шт.) ПТП
Оставить отзыв
Применяется: показать Артикул: PTP028155 все Артикулы доп.: 7511.100000*, 238АК-1002266Код для заказа: 386274 Производитель: ПТП
Доставка дешевле
Доставка быстрее
11 380 ₽
2 845 ₽х4 в сплит
4
1
4
оптовые цены ?
Прокладка головки блока ЯМЗ-8401, ТМЗ-8402 инд. ГБЦ комплект (11 наим. 17 шт.) ПТП
Прокладка головки блока ЯМЗ-8401, ТМЗ-8402 инд. ГБЦ комплект (11 наим. 17 шт.) ПТП
Оставить отзыв
Применяется: показать Артикул: PTP028315 все Артикулы доп.: 840.1003212*, 238-1723026Код для заказа: 386275 Производитель: ПТП
Доставка дешевле
Доставка быстрее
1 440 ₽
360 ₽х4 в сплит
52
1
52
оптовые цены ?
Прокладка двигателя ЯМЗ-236НЕ,236БЕ общая ГБЦ полный комплект силикон+металл (49 наим. 160 шт.) ПТП
Прокладка двигателя ЯМЗ-236НЕ,236БЕ общая ГБЦ полный комплект силикон+металл (49 наим. 160 шт.) ПТП
Оставить отзыв
Применяется: показать Артикул: PTP028177 все Артикулы доп.: 236НЕ-1000*, 201-1117118Код для заказа: 386276 Производитель: ПТП
Наличие в
1 магазине
2 шт.
Щёлково
8 435 ₽
8 435 ₽
2 109 ₽х4 в сплит
0
1
0
оптовые цены ?
Подшипник заднего,среднего моста КАМАЗ,ЗИЛ-130,МАЗ-5440,643068; КПП ЯМЗ-238ДЕ ГПЗ
Подшипник заднего,среднего моста КАМАЗ,ЗИЛ-130,МАЗ-5440,643068; КПП ЯМЗ-238ДЕ ГПЗ
Оставить отзыв
Применяется: показать Артикул: 7516 (32216) все Артикулы доп.: 7516Код для заказа: 387286 Производитель: ГПЗ
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
4 шт.
Нефтекамск
1 255 ₽
1 390 ₽
348 ₽х4 в сплит
21
1
21
Бесплатная доставка
оптовые цены ?
Прокладка ЯМЗ-236 картера масляного МБС синяя армированная РТР
Прокладка ЯМЗ-236 картера масляного МБС синяя армированная РТР
Оставить отзыв
Применяется: показать Артикул: 236-1009040 Код для заказа: 388453 Производитель: РТР
Доставка дешевле
Доставка быстрее
265 ₽
67 ₽х4 в сплит
9
1
9
оптовые цены ?
Перейти к странице:

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


Производитель Артикул Описание
HELLA 201421 Показать аналоги
Наличие товара на складах и в магазинах, а также цена товара указана на 28.06.2026 18:30.
Цены и наличие товара во всех магазинах и складах обновляются 1 раз в час. При достаточном количестве товара в нужном вам магазине вы можете купить его без предзаказа.
Интернет-цена - действительна при заказе на сайте или через оператора call-центра по телефону 8 800 6006 966. При условии достаточного количества товара в момент заказа.
Цена в магазинах - розничная цена товара в торговых залах магазинов без предварительного заказа.
Представленные данные о запчастях на этой странице несут исключительно информационный характер.

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

Общий отчет (Время: 1.18026с, Память: 20,506Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
loading session 2 0.45146 0.22573 0.00000 0.45145
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.00336 0.00336 0.00336 0.00336
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 6 0.00138 0.00023 0.00018 0.00034
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.00085 0.00028 0.00024 0.00031
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032
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.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00025 0.00025 0.00025 0.00025
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 (194599539, 194730936, 194924223, 194924229, 195350686, 195882860, 195907600, 197115474, 197115478, 197115482, 197875612, 197875618, 197927296, 198602430, 199580440, 199580472, 199604788, 199925042, 199925052, 200968935, 202255443, 202255447, 202255473, 202255481, 202855627, 203289561, 203289563, 203289565, 203473132, 203682924)) ORDER BY sorter) 1 0.00081 0.00081 0.00081 0.00081
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 (194599539, 194730936, 194924223, 194924229, 195350686, 195882860, 195907600, 197115474, 197115478, 197115482, 197875612, 197875618, 197927296, 198602430, 199580440, 199580472, 199604788, 199925042, 199925052, 200968935, 202255443, 202255447, 202255473, 202255481, 202855627, 203289561, 203289563, 203289565, 203473132, 203682924))) 1 0.00115 0.00115 0.00115 0.00115
Sphinx index catalog,catalog_morph,marketplace 2 1.11652 0.55826 0.49324 0.62329
Sphinx search. total_found: 666; time: 0.050 1 0.41004 0.41004 0.41004 0.41004
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 (194599539, 194730936, 194924223, 194924229, 195350686, 195882860, 195907600, 197115474, 197115478, 197115482, 197875612, 197875618, 197927296, 198602430, 199580440, 199580472, 199604788, 199925042, 199925052, 200968935, 202255443, 202255447, 202255473, 202255481, 202855627, 203289561, 203289563, 203289565, 203473132, 203682924))) 1 0.04645 0.04645 0.04645 0.04645
system.db.CDbCommand.query(call get_applied_by_catalog_ids_query('194599539,194730936,194924223,194924229,195350686,195882860,195907600,197115474,197115478,197115482,197875612,197875618,197927296,198602430,199580440,199580472,199604788,199925042,199925052,200968935,202255443,202255447,202255473,202255481,202855627,203289561,203289563,203289565,203473132,203682924', '1', '(cm.`name` LIKE "%20 14 21%")')) 1 0.00206 0.00206 0.00206 0.00206
system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code LIMIT 1) 2 0.00066 0.00033 0.00029 0.00036
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 ("246579","247366","248306","248308","250064","147106","255254","260678","260680","260719","265244","265247","265213","269000","274620","274636","671033","275347","275352","373429","382054","382055","382063","382065","384215","386274","386275","386276","387286","388453"))) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SELECT * FROM `personal_settings` WHERE actor_uid=:uid AND actor_type=:type_id) 2 0.00052 0.00026 0.00023 0.00029
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.00036 0.00018 0.00018 0.00019
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.00022 0.00022 0.00022 0.00022
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.sberSplit.isEnabled' LIMIT 1) 1 0.00020 0.00020 0.00020 0.00020
Sphinx select id,@groupby,@distinct,@count,property_msection_id 1 0.49325 0.49325 0.49325 0.49325
Sphinx search. total_found: 2141; time: 0.027 1 0.59251 0.59251 0.59251 0.59251
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00022 0.00022 0.00022 0.00022
Журнал приложения
Время Уровень Категория Сообщение
19:18:33.794049 trace system.CModule
Loading "log" application component
19:18:33.796679 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
19:18:33.796864 trace system.CModule
Loading "db" application component
19:18:33.796914 trace system.db.CDbConnection
Opening DB connection
19:18:33.797831 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
19:18:33.797835 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
19:18:33.798054 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
19:18:33.798172 trace system.CModule
Loading "urlHelper" application component
19:18:33.798261 trace system.CModule
Loading "DBConfig" application component
19:18:33.798286 trace system.CModule
Loading "cache" application component
19:18:33.799148 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
19:18:33.799426 trace system.CModule
Loading "geo" application component
19:18:33.799484 trace system.CModule
Loading "request" application component
19:18:33.799891 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
19:18:33.799925 trace system.db.ar.CActiveRecord
Location.findByPk()
19:18:33.800236 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
19:18:33.800404 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
19:18:33.800529 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
19:18:33.800534 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)
19:18:33.800749 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)
19:18:33.800903 trace system.CModule
Loading "user" application component
19:18:33.801011 profile application
begin:loading session
19:18:33.801016 trace system.CModule
Loading "session" application component
19:18:34.252463 profile application
end:loading session
19:18:34.254709 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
19:18:34.254920 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
19:18:34.255026 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
19:18:34.255031 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
19:18:34.255348 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
19:18:34.255444 trace system.CModule
Loading "B2BConfig" application component
19:18:34.255863 trace system.CModule
Loading "urlManager" application component
19:18:34.257025 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
19:18:34.258469 trace system.CModule
Loading "themeInterlayer" application component
19:18:34.261064 trace system.CModule
Loading "themeManager" application component
19:18:34.261831 trace system.CModule
Loading "clientScript" application component
19:18:34.266182 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
19:18:34.266199 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
19:18:34.266201 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
19:18:34.266449 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
19:18:34.266484 trace system.CModule
Loading "cart" application component
19:18:34.267129 trace system.db.ar.CActiveRecord
CartUser.find()
19:18:34.267287 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
19:18:34.267328 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
19:18:34.267332 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.267533 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.267743 trace system.CModule
Loading "coupon" application component
19:18:34.268273 trace system.CModule
Loading "assetManager" application component
19:18:34.268913 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
19:18:34.269054 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
19:18:34.269089 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
19:18:34.269092 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)
19:18:34.269592 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)
19:18:34.271234 trace system.CModule
Loading "redisCache" application component
19:18:34.272133 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
19:18:34.272382 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
19:18:34.272492 profile application
begin:loading session
19:18:34.272495 profile application
end:loading session
19:18:34.274892 trace system.CModule
Loading "order" application component
19:18:34.281214 trace system.CModule
Loading "IPropeties" application component
19:18:34.284878 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
19:18:34.285371 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1408" from cache
19:18:34.286138 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
19:18:34.286391 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
19:18:34.286397 trace system.CModule
Loading "dbTP" application component
19:18:34.286420 trace system.db.CDbConnection
Opening DB connection
19:18:34.287599 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
19:18:34.287966 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
19:18:34.288132 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)
19:18:34.314763 trace system.CModule
Loading "ICatalog" application component
19:18:34.315341 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
19:18:34.317888 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
19:18:34.318727 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
19:18:34.318962 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)
19:18:34.346996 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)
19:18:34.347002 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))
19:18:34.347306 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))
19:18:34.347645 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
19:18:34.347647 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)
19:18:34.347882 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)
19:18:34.348110 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
19:18:34.378884 profile application
begin:Sphinx search. total_found: 2141; time: 0.027
19:18:34.379204 trace system.db.ar.CActiveRecord
Good.findAll()
19:18:34.379725 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
19:18:34.380166 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache
19:18:34.380361 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
19:18:34.382890 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache
19:18:34.383145 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)))
19:18:34.383148 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))))
19:18:34.386507 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))))
19:18:34.388089 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache
19:18:34.388148 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 (194599539, 194730936,
194924223, 194924229, 195350686, 195882860, 195907600, 197115474,
197115478, 197115482, 197875612, 197875618, 197927296, 198602430,
199580440, 199580472, 199604788, 199925042, 199925052, 200968935,
202255443, 202255447, 202255473, 202255481, 202855627, 203289561,
203289563, 203289565, 203473132, 203682924)) ORDER BY sorter
19:18:34.388151 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 (194599539, 194730936,
194924223, 194924229, 195350686, 195882860, 195907600, 197115474,
197115478, 197115482, 197875612, 197875618, 197927296, 198602430,
199580440, 199580472, 199604788, 199925042, 199925052, 200968935,
202255443, 202255447, 202255473, 202255481, 202855627, 203289561,
203289563, 203289565, 203473132, 203682924)) ORDER BY sorter)
19:18:34.388957 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 (194599539, 194730936,
194924223, 194924229, 195350686, 195882860, 195907600, 197115474,
197115478, 197115482, 197875612, 197875618, 197927296, 198602430,
199580440, 199580472, 199604788, 199925042, 199925052, 200968935,
202255443, 202255447, 202255473, 202255481, 202855627, 203289561,
203289563, 203289565, 203473132, 203682924)) ORDER BY sorter)
19:18:34.389111 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 (194599539, 194730936, 194924223, 194924229, 195350686,
195882860, 195907600, 197115474, 197115478, 197115482, 197875612,
197875618, 197927296, 198602430, 199580440, 199580472, 199604788,
199925042, 199925052, 200968935, 202255443, 202255447, 202255473,
202255481, 202855627, 203289561, 203289563, 203289565, 203473132,
203682924))
19:18:34.389115 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
(194599539, 194730936, 194924223, 194924229, 195350686, 195882860,
195907600, 197115474, 197115478, 197115482, 197875612, 197875618,
197927296, 198602430, 199580440, 199580472, 199604788, 199925042,
199925052, 200968935, 202255443, 202255447, 202255473, 202255481,
202855627, 203289561, 203289563, 203289565, 203473132, 203682924)))
19:18:34.390268 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
(194599539, 194730936, 194924223, 194924229, 195350686, 195882860,
195907600, 197115474, 197115478, 197115482, 197875612, 197875618,
197927296, 198602430, 199580440, 199580472, 199604788, 199925042,
199925052, 200968935, 202255443, 202255447, 202255473, 202255481,
202855627, 203289561, 203289563, 203289565, 203473132, 203682924)))
19:18:34.396312 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 (194599539, 194730936,
194924223, 194924229, 195350686, 195882860, 195907600, 197115474,
197115478, 197115482, 197875612, 197875618, 197927296, 198602430,
199580440, 199580472, 199604788, 199925042, 199925052, 200968935,
202255443, 202255447, 202255473, 202255481, 202855627, 203289561,
203289563, 203289565, 203473132, 203682924))
19:18:34.396316 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
(194599539, 194730936, 194924223, 194924229, 195350686, 195882860,
195907600, 197115474, 197115478, 197115482, 197875612, 197875618,
197927296, 198602430, 199580440, 199580472, 199604788, 199925042,
199925052, 200968935, 202255443, 202255447, 202255473, 202255481,
202855627, 203289561, 203289563, 203289565, 203473132, 203682924)))
19:18:34.442770 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
(194599539, 194730936, 194924223, 194924229, 195350686, 195882860,
195907600, 197115474, 197115478, 197115482, 197875612, 197875618,
197927296, 198602430, 199580440, 199580472, 199604788, 199925042,
199925052, 200968935, 202255443, 202255447, 202255473, 202255481,
202855627, 203289561, 203289563, 203289565, 203473132, 203682924)))
19:18:34.448645 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
19:18:34.448649 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)
19:18:34.448962 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)
19:18:34.449127 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
19:18:34.449393 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)
19:18:34.478149 profile application
begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
19:18:34.478159 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
19:18:34.561355 profile application
begin:Sphinx search. total_found: 666; time: 0.050
19:18:34.561609 trace system.CModule
Loading "GoodSections" application component
19:18:34.562098 trace system.CModule
Loading "fcache" application component
19:18:34.573996 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
19:18:34.574305 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
19:18:34.577940 trace system.db.CDbCommand
Querying SQL: call
get_applied_by_catalog_ids_query('194599539,194730936,194924223,194924229,195350686,195882860,195907600,197115474,197115478,197115482,197875612,197875618,197927296,198602430,199580440,199580472,199604788,199925042,199925052,200968935,202255443,202255447,202255473,202255481,202855627,203289561,203289563,203289565,203473132,203682924',
'1', '(cm.`name` LIKE "%20 14 21%")')
19:18:34.577945 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('194599539,194730936,194924223,194924229,195350686,195882860,195907600,197115474,197115478,197115482,197875612,197875618,197927296,198602430,199580440,199580472,199604788,199925042,199925052,200968935,202255443,202255447,202255473,202255481,202855627,203289561,203289563,203289565,203473132,203682924',
'1', '(cm.`name` LIKE "%20 14 21%")'))
19:18:34.580009 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('194599539,194730936,194924223,194924229,195350686,195882860,195907600,197115474,197115478,197115482,197875612,197875618,197927296,198602430,199580440,199580472,199604788,199925042,199925052,200968935,202255443,202255447,202255473,202255481,202855627,203289561,203289563,203289565,203473132,203682924',
'1', '(cm.`name` LIKE "%20 14 21%")'))
19:18:34.581170 trace system.CModule
Loading "dbTecDoc" application component
19:18:34.581197 trace system.db.CDbConnection
Opening DB connection
19:18:34.582088 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
19:18:34.582401 trace system.CModule
Loading "dbTecDoc2" application component
19:18:34.582416 trace system.db.CDbConnection
Opening DB connection
19:18:34.583247 trace system.db.CDbCommand
Querying SQL: call get_brandfilter_by_art_no_link_v7_1('201421', 49, 66, 1,
66)
19:18:34.592211 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
("246579","247366","248306","248308","250064","147106","255254","260678","260680","260719","265244","265247","265213","269000","274620","274636","671033","275347","275352","373429","382054","382055","382063","382065","384215","386274","386275","386276","387286","388453"))
19:18:34.592219 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
("246579","247366","248306","248308","250064","147106","255254","260678","260680","260719","265244","265247","265213","269000","274620","274636","671033","275347","275352","373429","382054","382055","382063","382065","384215","386274","386275","386276","387286","388453")))
19:18:34.592849 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
("246579","247366","248306","248308","250064","147106","255254","260678","260680","260719","265244","265247","265213","269000","274620","274636","671033","275347","275352","373429","382054","382055","382063","382065","384215","386274","386275","386276","387286","388453")))
19:18:34.593136 trace system.CModule
Loading "warehouse" application component
19:18:34.593606 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
19:18:34.619941 trace system.CModule
Loading "goodTpl" application component
19:18:34.635807 trace system.CModule
Loading "microdataManager" application component
19:18:34.636806 trace system.CModule
Loading "widgetFactory" application component
19:18:34.647929 trace system.CModule
Loading "yandexEcom" application component
19:18:34.649951 trace system.db.ar.CActiveRecord
CartUser.find()
19:18:34.650027 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
19:18:34.650032 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.650371 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.656683 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
19:18:34.656688 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
19:18:34.656977 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
19:18:34.657196 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
19:18:34.657428 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:application_settings"
from cache
19:18:34.657499 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
19:18:34.657501 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)
19:18:34.657718 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)
19:18:34.658428 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
19:18:34.658431 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
19:18:34.658658 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
19:18:34.658669 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
19:18:34.658719 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
19:18:34.658721 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)
19:18:34.658925 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)
19:18:34.816306 trace system.CModule
Loading "coreMessages" application component
19:18:34.874063 trace system.CModule
Loading "GoodPropDesc" application component
19:18:34.874727 trace system.caching.CFileCache
Serving "iblock_properties_desc" from cache
19:18:34.875626 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCodes1Good76379d763ce6ed62e2d686a9eb5aa929"
from cache
19:18:34.875865 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e6676379d763ce6ed62e2d686a9eb5aa929"
from cache
19:18:34.876132 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods"
from cache
19:18:34.876287 trace system.db.ar.CActiveRecord
MpAttr.find()
19:18:34.876621 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_attrs"
from cache
19:18:34.876699 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
19:18:34.876705 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
19:18:34.877068 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
19:18:34.877115 trace system.db.ar.CActiveRecord
MpAttr.find()
19:18:34.877168 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
19:18:34.877171 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
19:18:34.877465 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
19:18:34.877593 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
19:18:34.877904 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)
19:18:34.913084 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
19:18:34.913090 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)
19:18:34.913393 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)
19:18:34.915550 trace system.caching.CMemCache
Saving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e6676379d763ce6ed62e2d686a9eb5aa929"
to cache
19:18:34.915889 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e6676379d763ce6ed62e2d686a9eb5aa929"
from cache
19:18:34.919194 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LISTdeced2c4f3db30faaecdcac8e5f02265dcca48101505dd86b703689a604fe3c4"
from cache
19:18:34.920495 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPdeced2c4f3db30faaecdcac8e5f02265dcca48101505dd86b703689a604fe3c4"
from cache
19:18:34.926363 trace system.db.ar.CActiveRecord
CartUser.find()
19:18:34.926479 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
19:18:34.926482 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.926729 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.927664 trace system.db.ar.CActiveRecord
CartUser.find()
19:18:34.927700 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
19:18:34.927704 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.927908 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.927917 trace system.db.ar.CActiveRecord
Cart.count()
19:18:34.928143 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
19:18:34.928216 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
19:18:34.928220 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)
19:18:34.928407 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)
19:18:34.930825 trace system.caching.CMemCache
Serving "CB:name:top_header_menu_delivery_desktop" from cache
19:18:34.931962 trace system.caching.CMemCache
Serving "CB:name:top_alert_desktop" from cache
19:18:34.933588 trace system.db.ar.CActiveRecord
CartUser.find()
19:18:34.933626 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
19:18:34.933629 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.933837 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.933876 trace system.db.ar.CActiveRecord
CartUser.find()
19:18:34.933908 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
19:18:34.933912 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.934088 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
19:18:34.934094 trace system.db.ar.CActiveRecord
Cart.count()
19:18:34.934140 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
19:18:34.934143 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)
19:18:34.934319 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)
19:18:34.937685 trace system.caching.CMemCache
Serving "CB:name:bottom_job_desktop" from cache
19:18:34.938169 trace system.caching.CMemCache
Serving "CB:name:partners_desktop" from cache
19:18:34.938783 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_desktop" from cache
19:18:34.939337 trace system.CModule
Loading "territory" application component
19:18:34.945203 trace system.caching.CMemCache
Serving "ITerritory3" from cache
19:18:34.947784 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
19:18:34.952712 trace system.caching.CMemCache
Serving "CB:name:bottom_copy_text_desktop" from cache