Экспресс доставка
Возврат 90 дней
Консультируем и принимаем заказы
с 9:00 до 22:00 (MSK)
по бесплатному телефону
с 9:00 до 20:00 (MSK) в
Max и Telegram

Запчасти ВАЗ (Лада)

Сортировать по:
Трубка ВАЗ-2190 адсорбера средняя БАЛАКОВОЗАПЧАСТЬ
Трубка ВАЗ-2190 адсорбера средняя БАЛАКОВОЗАПЧАСТЬ
Оставить отзыв
Применяется: показать Артикул: 10045 все Артикулы доп.: 2190-1164248Код для заказа: 533825 Производитель: БАЛАКОВОЗАПЧАСТЬ
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
2 шт.
Новогиреево (24ч)
590 ₽
1 шт.
Хабаровская (24ч)
590 ₽
590 ₽
148 ₽х4 в сплит
4
1
4
оптовые цены ?
Трубка ВАЗ-1118 паропровода передняя БАЛАКОВОЗАПЧАСТЬ
Трубка ВАЗ-1118 паропровода передняя БАЛАКОВОЗАПЧАСТЬ
1
Артикул: 10032 все Артикулы доп.: 1118-1164244Код для заказа: 533826 Производитель: БАЛАКОВОЗАПЧАСТЬ
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
390 ₽
1 шт.
Хабаровская (24ч)
390 ₽
390 ₽
98 ₽х4 в сплит
1
1
1
оптовые цены ?
Трубка ВАЗ-2190 паропровода передняя БАЛАКОВОЗАПЧАСТЬ
Трубка ВАЗ-2190 паропровода передняя БАЛАКОВОЗАПЧАСТЬ
Оставить отзыв
Применяется: показать Артикул: 10044 все Артикулы доп.: 2190-1164244Код для заказа: 533827 Производитель: БАЛАКОВОЗАПЧАСТЬ
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Тула
310 ₽
306 ₽
77 ₽х4 в сплит
1
1
1
оптовые цены ?
Трубка ВАЗ-1118 паропровода в сборе БАЛАКОВОЗАПЧАСТЬ
Трубка ВАЗ-1118 паропровода в сборе БАЛАКОВОЗАПЧАСТЬ
Оставить отзыв
Применяется: показать Артикул: 10033 все Артикулы доп.: 1118-1164248Код для заказа: 533828 Производитель: БАЛАКОВОЗАПЧАСТЬ
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
6 шт.
Новогиреево (24ч)
425 ₽
1 шт.
Хабаровская (24ч)
425 ₽
425 ₽
107 ₽х4 в сплит
6
1
6
оптовые цены ?
Трубка ВАЗ-1118 фильтра топливного и трубопровода БАЛАКОВОЗАПЧАСТЬ
Трубка ВАЗ-1118 фильтра топливного и трубопровода БАЛАКОВОЗАПЧАСТЬ
7
Артикул: 10028 все Артикулы доп.: 1118-1104222Код для заказа: 533829 Производитель: БАЛАКОВОЗАПЧАСТЬ
Доставка дешевле
Доставка быстрее
Наличие в
5 магазинах
3 шт.
Новогиреево (24ч)
745 ₽
2 шт.
Сабурово (24ч)
745 ₽
4 шт.
Хабаровская (24ч)
745 ₽
1 шт.
Подольск (24ч)
745 ₽
1 шт.
Тула
725 ₽
745 ₽
187 ₽х4 в сплит
7
1
7
Бесплатная доставка
оптовые цены ?
Трубка ВАЗ-2115 топливная от бака к фильтру в сборе Н/О БАЛАКОВОЗАПЧАСТЬ
Трубка ВАЗ-2115 топливная от бака к фильтру в сборе Н/О БАЛАКОВОЗАПЧАСТЬ
12
Применяется: показать Артикул: 10035 все Артикулы доп.: 21094-1104243Код для заказа: 533832 Производитель: БАЛАКОВОЗАПЧАСТЬ
Доставка дешевле
Доставка быстрее
Наличие в
10 магазинах
3 шт.
Новогиреево (24ч)
570 ₽
3 шт.
Сабурово (24ч)
570 ₽
1 шт.
Хабаровская (24ч)
570 ₽
1 шт.
Черное
570 ₽
1 шт.
Вешняки
570 ₽
1 шт.
Кожухово
570 ₽
1 шт.
МКАД 6 км. (внут.)
570 ₽
1 шт.
Пролетарка (24ч)
570 ₽
1 шт.
Раменское
535 ₽
1 шт.
Тула
555 ₽
570 ₽
143 ₽х4 в сплит
6
1
6
оптовые цены ?
Провод АКБ "+" ВАЗ-2106 евро клемма (латунь) ДИАЛУЧ
Провод АКБ "+" ВАЗ-2106 евро клемма (латунь) ДИАЛУЧ
42
Артикул: КЛ011-10ЕП все Артикулы доп.: 2103-3724070Код для заказа: 002485 Производитель: АВТО-ЭЛЕКТРО ДИАЛ
Доставка дешевле
Доставка быстрее
Наличие в
4 магазинах
1 шт.
Сабурово (24ч)
760 ₽
1 шт.
Хабаровская (24ч)
760 ₽
1 шт.
Вешняки
760 ₽
1 шт.
Щёлково
760 ₽
760 ₽
190 ₽х4 в сплит
1
1
1
оптовые цены ?
Бампер ЛАДА X-Ray задний ОЕ
Бампер ЛАДА X-Ray задний ОЕ
Оставить отзыв
Применяется: показать Артикул: 850220699R Код для заказа: 536080 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
12 000 ₽
12 000 ₽
3 000 ₽х4 в сплит
2
1
2
оптовые цены ?
Бампер ЛАДА X-Ray передний ОЕ АвтоВАЗ
Бампер ЛАДА X-Ray передний ОЕ АвтоВАЗ
1
Применяется: показать Артикул: 620228136R Код для заказа: 536081 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
11 500 ₽
1 шт.
Вешняки
11 500 ₽
11 500 ₽
2 875 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Облицовка радиатора ЛАДА X-Ray ОЕ
Облицовка радиатора ЛАДА X-Ray ОЕ
1
Применяется: показать Артикул: 623101223R Код для заказа: 536089 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
3 магазинах
1 шт.
Кожухово
5 800 ₽
1 шт.
Подольск (24ч)
5 800 ₽
1 шт.
Тула
5 630 ₽
5 800 ₽
1 450 ₽х4 в сплит
3
1
3
оптовые цены ?
Фара ЛАДА X-Ray левая ОЕ
Фара ЛАДА X-Ray левая ОЕ
Оставить отзыв
Применяется: показать Артикул: 260600467R Код для заказа: 536092 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
38 500 ₽
1 шт.
Тула
37 345 ₽
38 500 ₽
9 625 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Фара ЛАДА X-Ray правая ОЕ
Фара ЛАДА X-Ray правая ОЕ
1
Применяется: показать Артикул: 260107436R Код для заказа: 536093 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
46 500 ₽
46 500 ₽
11 625 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Шланг тормозной ЛАДА Vesta задний БРТ
Шланг тормозной ЛАДА Vesta задний БРТ
8
Артикул: 2180-3506085Р все Артикулы доп.: 8450006862Код для заказа: 536290 Производитель: БРТ
Доставка дешевле
Доставка быстрее
Наличие в
5 магазинах
5 шт.
Новогиреево (24ч)
136 ₽
1 шт.
Сабурово (24ч)
136 ₽
2 шт.
Хабаровская (24ч)
136 ₽
2 шт.
Черное
225 ₽
2 шт.
Кожухово
136 ₽
136 ₽
34 ₽х4 в сплит
6
1
6
оптовые цены ?
Накладка двери ВАЗ-2101,2106 задней правой
Накладка двери ВАЗ-2101,2106 задней правой
2
Применяется: показать Артикул: 21010-6201014-00 все Артикулы доп.: 2101-6201014Код для заказа: 008275 Производитель: NO NAME
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
2 шт.
Новогиреево (24ч)
1 580 ₽
1 580 ₽
395 ₽х4 в сплит
4
1
4
оптовые цены ?
Цилиндр тормозной задний ЛАДА Vesta FENOX
Цилиндр тормозной задний ЛАДА Vesta FENOX
3
Применяется: показать Артикул: K19023 Код для заказа: 536360 Производитель: FENOX
Доставка дешевле
Доставка быстрее
Наличие в
4 магазинах
1 шт.
Новогиреево (24ч)
1 620 ₽
2 шт.
Вешняки
1 620 ₽
2 шт.
Пролетарка (24ч)
1 620 ₽
2 шт.
Нефтекамск
1 460 ₽
1 620 ₽
405 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Щетка стартера ВАЗ-2101-08 комплект 4шт.
Щетка стартера ВАЗ-2101-08 комплект 4шт.
Оставить отзыв
Применяется: показать Артикул: 35.3708340* все Артикулы доп.: 2101-3708340Код для заказа: 074348
Доставка дешевле
Доставка быстрее
450 ₽
113 ₽х4 в сплит
3
1
3
оптовые цены ?
Плафон освещения салона ВАЗ-2170 АвтоВАЗ
Плафон освещения салона ВАЗ-2170 АвтоВАЗ
13
Применяется: показать Артикул: 21700-3714010-10 все Артикулы доп.: 21700371401010Код для заказа: 600697 Тип электрооборудования: плафоны освещения салона, багажника … • Производитель: LADA
Доставка дешевле
Доставка быстрее
Наличие в
9 магазинах
2 шт.
Новогиреево (24ч)
3 700 ₽
1 шт.
Сабурово (24ч)
3 700 ₽
1 шт.
Вешняки
3 700 ₽
1 шт.
Кожухово
3 700 ₽
1 шт.
Пролетарка (24ч)
3 700 ₽
2 шт.
Подольск (24ч)
3 700 ₽
1 шт.
Раменское
3 445 ₽
2 шт.
Тула
3 590 ₽
4 шт.
Пермь 2
3 330 ₽
3 700 ₽
925 ₽х4 в сплит
8
1
8
Бесплатная доставка
оптовые цены ?
Дверь ЛАДА Vesta передняя левая OE
Дверь ЛАДА Vesta передняя левая OE
Оставить отзыв
Применяется: показать Артикул: 8460013093 Код для заказа: 971633 Производитель: LADA
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
37 800 ₽
1 шт.
Хабаровская (24ч)
37 800 ₽
37 800 ₽
9 450 ₽х4 в сплит
1
1
1
оптовые цены ?
Дверь ЛАДА Vesta передняя правая OE
Дверь ЛАДА Vesta передняя правая OE
Оставить отзыв
Применяется: показать Артикул: 8450039385 все Артикулы доп.: 8460013091Код для заказа: 971634 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
36 700 ₽
1 шт.
Хабаровская (24ч)
36 700 ₽
36 700 ₽
9 175 ₽х4 в сплит
1
1
1
оптовые цены ?
Бампер ЛАДА Largus Cross задний OE
Бампер ЛАДА Largus Cross задний OE
Оставить отзыв
Применяется: показать Артикул: 8450009388 Код для заказа: 538244 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
7 850 ₽
1 шт.
Вешняки
7 850 ₽
7 850 ₽
1 963 ₽х4 в сплит
2
1
2
оптовые цены ?
Крыло ЛАДА Vesta переднее правое OE
Крыло ЛАДА Vesta переднее правое OE
29
Применяется: показать Артикул: 8450039386 Код для заказа: 538264 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
2 шт.
Сабурово (24ч)
12 300 ₽
1 шт.
Хабаровская (24ч)
12 300 ₽
12 300 ₽
3 075 ₽х4 в сплит
2
1
2
оптовые цены ?
Накладка бампера ЛАДА Vesta заднего OE
Накладка бампера ЛАДА Vesta заднего OE
20
Применяется: показать Артикул: 8450008884 Код для заказа: 538271 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
5 магазинах
4 шт.
Новогиреево (24ч)
2 900 ₽
1 шт.
Сабурово (24ч)
2 900 ₽
1 шт.
Кожухово
2 900 ₽
1 шт.
Тула
2 815 ₽
1 шт.
Пермь 2
2 610 ₽
2 900 ₽
725 ₽х4 в сплит
9
1
9
оптовые цены ?
Накладка бампера ЛАДА Vesta переднего средняя (решетка радиатора глянцевая) OE
Накладка бампера ЛАДА Vesta переднего средняя (решетка радиатора глянцевая) OE
20
Применяется: показать Артикул: 8450008876 Код для заказа: 538273 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
5 магазинах
1 шт.
Новогиреево (24ч)
4 250 ₽
1 шт.
Вешняки
4 250 ₽
1 шт.
Кожухово
4 250 ₽
1 шт.
Пролетарка (24ч)
4 250 ₽
2 шт.
Тула
4 125 ₽
4 250 ₽
1 063 ₽х4 в сплит
1
1
1
оптовые цены ?
Накладка бампера ЛАДА Vesta переднего средняя (решетка радиатора шагрень) OE
Накладка бампера ЛАДА Vesta переднего средняя (решетка радиатора шагрень) OE
20
Применяется: показать Артикул: 8450008875 Код для заказа: 538274 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
3 магазинах
5 шт.
Новогиреево (24ч)
4 900 ₽
1 шт.
Сабурово (24ч)
4 900 ₽
1 шт.
Тула
4 755 ₽
4 900 ₽
1 225 ₽х4 в сплит
12
1
12
оптовые цены ?
Наклейка ЛАДА X-Ray информационная о применяемом бензине OE
Наклейка ЛАДА X-Ray информационная о применяемом бензине OE
Оставить отзыв
Применяется: показать Артикул: 990830148R Код для заказа: 538283 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
353 ₽
353 ₽
89 ₽х4 в сплит
2
1
2
оптовые цены ?
Проводка ЛАДА Largus жгут проводов моторного отсека OE
Проводка ЛАДА Largus жгут проводов моторного отсека OE
Оставить отзыв
Артикул: 8450090226 Код для заказа: 538301 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
85 ₽
85 ₽
22 ₽х4 в сплит
1
1
1
оптовые цены ?
Усилитель бампера ЛАДА Vesta переднего средний OE
Усилитель бампера ЛАДА Vesta переднего средний OE
1
Применяется: показать Артикул: 8450008960 Код для заказа: 538318 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Сабурово (24ч)
4 400 ₽
1 шт.
Хабаровская (24ч)
4 400 ₽
4 400 ₽
1 100 ₽х4 в сплит
1
1
1
Бесплатная доставка
оптовые цены ?
Эмблема ЛАДА Largus Cross двери задка "CROSS " OE
Эмблема ЛАДА Largus Cross двери задка "CROSS " OE
1
Применяется: показать Артикул: 8450009415 Код для заказа: 538325 Производитель: RENAULT
Доставка дешевле
Доставка быстрее
Наличие в
5 магазинах
1 шт.
Новогиреево (24ч)
765 ₽
2 шт.
Сабурово (24ч)
765 ₽
1 шт.
Хабаровская (24ч)
765 ₽
1 шт.
Вешняки
765 ₽
1 шт.
Подольск (24ч)
765 ₽
765 ₽
192 ₽х4 в сплит
3
1
3
оптовые цены ?
Уплотнитель ВАЗ-2121 капота БРТ
Уплотнитель ВАЗ-2121 капота БРТ
11
Применяется: показать Артикул: 2121-8402200Р все Артикулы доп.: 2121-8402200Код для заказа: 003480 Производитель: БРТ
Доставка дешевле
Доставка быстрее
420 ₽
105 ₽х4 в сплит
2
1
2
оптовые цены ?
Сальник коленвала и распредвала ВАЗ-2108,1111 28х42х7 VICTOR REINZ
Сальник коленвала и распредвала ВАЗ-2108,1111 28х42х7 VICTOR REINZ
8
Применяется: показать Артикул: 80-33653-10 все Артикулы доп.: 2108-1005034Код для заказа: 538795 Внутренний диаметр, мм: 28 • Внешний диаметр, мм: 42 • Толщина, мм: 7 • Производитель: VICTOR REINZ
Доставка дешевле
Доставка быстрее
135 ₽
34 ₽х4 в сплит
51
1
51
оптовые цены ?
Перейти к странице:
Наличие товара на складах и в магазинах, а также цена товара указана на 05.07.2026 20:30.
Цены и наличие товара во всех магазинах и складах обновляются 1 раз в час. При достаточном количестве товара в нужном вам магазине вы можете купить его без предзаказа.
Интернет-цена - действительна при заказе на сайте или через оператора call-центра по телефону 8 800 6006 966. При условии достаточного количества товара в момент заказа.
Цена в магазинах - розничная цена товара в торговых залах магазинов без предварительного заказа.
Представленные данные о запчастях на этой странице несут исключительно информационный характер.
  Бак топливный ВАЗ Бензонасос Вал коленчатый Гидроусилитель руля Датчики показать все Двери Диск сцепления Замки дверей Замки зажигания Замки капота Клапаны Корзина сцепления Механизм рулевой Мост диодный ВАЗ Мост задний Накладка порога Наконечник рулевой Насос масляный Насос водяной (помпа) Обивки дверей Опоры Подшипник Пружины Радиатор Реле Ремень Распределитель зажигания Решетка (облицовка) радиатора Рулевая рейка Рычаг подвески Сальник Сиденье Стартер Стеклоподъёмник Стекло лобовое Стойка Ступица Сцепление Термостат Трамблер ВАЗ Трос ручника Труба приемная Тяга рулевая Усилитель вакуумный Фары Фонари Форсунки Цепь ГРМ Цилиндр суппорта Цилиндр сцепления Цилиндр тормозной ШРУС ВАЗ Бампер Амортизатор ВАЗ Барабан тормозной Вал карданный Вал распределительный Генератор Глушитель Диски тормозные Капот ВАЗ Катушка зажигания Руль Колодки тормозные Панель приборов КПП Крыло скрыть

Автомобили отечественного производства на российских дорогах встречаются чаще других, и их популярность, основанная на доступной цене, в ближайшее время вряд ли снизится. Именно поэтому в интернет-магазине AvtoALL крайне востребованы запчасти для отечественных авто, в первую очередь — запчасти на ВАЗ.

Здесь вы найдете любые запчасти на автомобили ВАЗ, как производимее в настоящее время, так и уже снятые с производства: на «классику» от ВАЗ-2101 до 2107,более современные модели ВАЗ 2110-2115, ВАЗ-2121 «Нива» и ВАЗ-2123 Chevrolet Niva, а также Lada Kalina, Priora и Granta.

В AvtoALL представлены только высококачественные запчасти для ВАЗ известного происхождения, обладающие разумной стоимостью. Просто выберите то, что нужно вашему автомобилю, и без лишних затрат вдохните в него новую жизнь.

Набираем команду в магазин
Подбор по марке
Оригинальные каталоги
Общий отчет (Время: 1.45736с, Память: 24,837Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
loading session 2 0.00094 0.00047 0.00001 0.00093
Sphinx index catalog_morph 1 0.49298 0.49298 0.49298 0.49298
Sphinx search. total_found: 13858; time: 0.440 1 0.92119 0.92119 0.92119 0.92119
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.00290 0.00290 0.00290 0.00290
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 (72935497, 72935499, 72935501, 72935503, 72935505, 72935511, 73129001, 74054401, 74054403, 74054421, 74054429, 74054431, 74124261, 74151037, 74226709, 74447569, 74547757, 74822341, 74822343, 75194195, 75194241, 75194255, 75194259, 75194261, 75194283, 75194325, 75194361, 75194375, 75198019, 75513719))) 1 0.04618 0.04618 0.04618 0.04618
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) 6 0.00144 0.00024 0.00017 0.00030
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 (72935497, 72935499, 72935501, 72935503, 72935505, 72935511, 73129001, 74054401, 74054403, 74054421, 74054429, 74054431, 74124261, 74151037, 74226709, 74447569, 74547757, 74822341, 74822343, 75194195, 75194241, 75194255, 75194259, 75194261, 75194283, 75194325, 75194361, 75194375, 75198019, 75513719))) 1 0.00123 0.00123 0.00123 0.00123
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 (72935497, 72935499, 72935501, 72935503, 72935505, 72935511, 73129001, 74054401, 74054403, 74054421, 74054429, 74054431, 74124261, 74151037, 74226709, 74447569, 74547757, 74822341, 74822343, 75194195, 75194241, 75194255, 75194259, 75194261, 75194283, 75194325, 75194361, 75194375, 75198019, 75513719)) ORDER BY sorter) 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SELECT * FROM `personal_settings` WHERE actor_uid=:uid AND actor_type=:type_id) 2 0.00044 0.00022 0.00019 0.00025
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 * FROM `application_settings` `t` WHERE `t`.`domain`='dev7.autoall.ru' AND `t`.`key`='paysystems.yandexSplit.isEnabled' LIMIT 1) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00022 0.00022 0.00022 0.00022
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 ("533825","533826","533827","533828","533829","533832","002485","536080","536081","536089","536092","536093","536290","008275","536360","074348","600697","971633","971634","538244","538264","538271","538273","538274","538283","538301","538318","538325","003480","538795"))) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code LIMIT 1) 2 0.00040 0.00020 0.00018 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.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY) 2 0.00039 0.00019 0.00018 0.00021
Sphinx search. total_found: 482; time: 0.373 1 0.11083 0.11083 0.11083 0.11083
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`, `t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS `t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`, `t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`, `t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`, `t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`, `t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`, `t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`, `t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`, `t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS `t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`, `t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`, `t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS `t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`, `p`.`PROPERTY_1036` AS `t2_c1`, `p`.`DESCRIPTION_1036` AS `t2_c2`, `p`.`PROPERTY_1037` AS `t2_c3`, `p`.`DESCRIPTION_1037` AS `t2_c4`, `p`.`PROPERTY_1047` AS `t2_c5`, `p`.`DESCRIPTION_1047` AS `t2_c6`, `p`.`PROPERTY_1048` AS `t2_c7`, `p`.`DESCRIPTION_1048` AS `t2_c8`, `p`.`PROPERTY_1049` AS `t2_c9`, `p`.`DESCRIPTION_1049` AS `t2_c10`, `p`.`PROPERTY_1050` AS `t2_c11`, `p`.`DESCRIPTION_1050` AS `t2_c12`, `p`.`PROPERTY_1129` AS `t2_c13`, `p`.`DESCRIPTION_1129` AS `t2_c14`, `p`.`PROPERTY_1156` AS `t2_c15`, `p`.`DESCRIPTION_1156` AS `t2_c16`, `p`.`PROPERTY_1821` AS `t2_c17`, `p`.`DESCRIPTION_1821` AS `t2_c18`, `p`.`PROPERTY_1893` AS `t2_c19`, `p`.`DESCRIPTION_1893` AS `t2_c20`, `p`.`PROPERTY_1894` AS `t2_c21`, `p`.`DESCRIPTION_1894` AS `t2_c22` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_prop_m50` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN `b_iblock_element_prop_s50` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) WHERE (((t.IBLOCK_ID = 50) AND (t.ACTIVE = :ACTIVE)) AND (IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_ID AND VALUE = :VALUE)) ORDER BY t.SORT ASC) 2 0.00658 0.00329 0.00068 0.00590
Sphinx select id,@groupby,@count,PROPERTY_MAKER_LIST 1 0.49299 0.49299 0.49299 0.49299
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`, `gr`.`ID` AS `t1_c0`, `gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`, `gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`, `gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS `t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`, `gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`, `gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`, `gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS `t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_section_element` `groups_gr` ON (`t`.`ID`=`groups_gr`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_iblock_section` `gr` ON (`gr`.`ID`=`groups_gr`.`IBLOCK_SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") WHERE ((((t.IBLOCK_ID = 49) AND (t.ACTIVE = :ACTIVE)) AND (gr.ID = :ID)) AND ((t.CODE IS NULL OR t.CODE = ""))) ORDER BY t.SORT ASC, gr.LEFT_MARGIN, gr.DEPTH_LEVEL) 2 0.00093 0.00047 0.00024 0.00069
Sphinx index marketplace,catalog_morph 1 1.36845 1.36845 1.36845 1.36845
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00026 0.00026 0.00026 0.00026
Журнал приложения
Время Уровень Категория Сообщение
21:20:37.383512 trace system.CModule
Loading "log" application component
21:20:37.389570 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
21:20:37.389884 trace system.CModule
Loading "db" application component
21:20:37.389970 trace system.db.CDbConnection
Opening DB connection
21:20:37.391091 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
21:20:37.391098 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
21:20:37.391355 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
21:20:37.391511 trace system.CModule
Loading "urlHelper" application component
21:20:37.391652 trace system.CModule
Loading "DBConfig" application component
21:20:37.391695 trace system.CModule
Loading "cache" application component
21:20:37.392654 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
21:20:37.393145 trace system.CModule
Loading "geo" application component
21:20:37.393243 trace system.CModule
Loading "request" application component
21:20:37.394270 trace system.CModule
Loading "user" application component
21:20:37.394434 profile application
begin:loading session
21:20:37.394442 trace system.CModule
Loading "session" application component
21:20:37.395365 profile application
end:loading session
21:20:37.396749 trace system.CModule
Loading "B2BConfig" application component
21:20:37.396819 trace system.CModule
Loading "urlManager" application component
21:20:37.397945 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
21:20:37.399132 trace system.CModule
Loading "themeInterlayer" application component
21:20:37.399996 trace system.CModule
Loading "themeManager" application component
21:20:37.400177 trace system.CModule
Loading "clientScript" application component
21:20:37.402925 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
21:20:37.402941 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
21:20:37.402945 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
21:20:37.403194 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
21:20:37.403234 trace system.CModule
Loading "cart" application component
21:20:37.403348 trace system.db.ar.CActiveRecord
CartUser.find()
21:20:37.403677 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
21:20:37.403727 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
21:20:37.403732 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:37.404004 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:37.404314 trace system.CModule
Loading "coupon" application component
21:20:37.404587 trace system.CModule
Loading "assetManager" application component
21:20:37.404788 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
21:20:37.404941 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
21:20:37.404990 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
21:20:37.404995 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)
21:20:37.405215 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)
21:20:37.406279 trace system.CModule
Loading "redisCache" application component
21:20:37.407011 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
21:20:37.407510 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
21:20:37.407680 profile application
begin:loading session
21:20:37.407685 profile application
end:loading session
21:20:37.409768 trace system.CModule
Loading "order" application component
21:20:37.409969 trace system.CModule
Loading "GoodSections" application component
21:20:37.410048 trace system.CModule
Loading "fcache" application component
21:20:37.420264 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
21:20:37.420542 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
21:20:37.421963 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_uts_iblock_49_section"
from cache
21:20:37.423197 trace system.CModule
Loading "IPropeties" application component
21:20:37.431127 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
21:20:37.432208 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1408" from cache
21:20:37.432742 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
21:20:37.433387 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
21:20:37.433451 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
21:20:37.433460 trace system.CModule
Loading "dbTP" application component
21:20:37.433494 trace system.db.CDbConnection
Opening DB connection
21:20:37.434690 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
21:20:37.435170 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
21:20:37.435348 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)
21:20:37.469405 profile application
begin:Sphinx index marketplace,catalog_morph
21:20:37.916662 profile application
begin:Sphinx search. total_found: 13858; time: 0.440
21:20:37.916888 trace system.db.ar.CActiveRecord
Good.findAll()
21:20:37.917150 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
21:20:37.917417 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache
21:20:37.917673 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
21:20:37.920391 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache
21:20:37.920618 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)))
21:20:37.920622 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))))
21:20:37.923522 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))))
21:20:37.925681 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache
21:20:37.925739 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 (72935497, 72935499,
72935501, 72935503, 72935505, 72935511, 73129001, 74054401, 74054403,
74054421, 74054429, 74054431, 74124261, 74151037, 74226709, 74447569,
74547757, 74822341, 74822343, 75194195, 75194241, 75194255, 75194259,
75194261, 75194283, 75194325, 75194361, 75194375, 75198019, 75513719))
ORDER BY sorter
21:20:37.925743 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 (72935497, 72935499,
72935501, 72935503, 72935505, 72935511, 73129001, 74054401, 74054403,
74054421, 74054429, 74054431, 74124261, 74151037, 74226709, 74447569,
74547757, 74822341, 74822343, 75194195, 75194241, 75194255, 75194259,
75194261, 75194283, 75194325, 75194361, 75194375, 75198019, 75513719))
ORDER BY sorter)
21:20:37.926668 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 (72935497, 72935499,
72935501, 72935503, 72935505, 72935511, 73129001, 74054401, 74054403,
74054421, 74054429, 74054431, 74124261, 74151037, 74226709, 74447569,
74547757, 74822341, 74822343, 75194195, 75194241, 75194255, 75194259,
75194261, 75194283, 75194325, 75194361, 75194375, 75198019, 75513719))
ORDER BY sorter)
21:20:37.926876 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 (72935497, 72935499, 72935501, 72935503, 72935505, 72935511,
73129001, 74054401, 74054403, 74054421, 74054429, 74054431, 74124261,
74151037, 74226709, 74447569, 74547757, 74822341, 74822343, 75194195,
75194241, 75194255, 75194259, 75194261, 75194283, 75194325, 75194361,
75194375, 75198019, 75513719))
21:20:37.926881 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
(72935497, 72935499, 72935501, 72935503, 72935505, 72935511, 73129001,
74054401, 74054403, 74054421, 74054429, 74054431, 74124261, 74151037,
74226709, 74447569, 74547757, 74822341, 74822343, 75194195, 75194241,
75194255, 75194259, 75194261, 75194283, 75194325, 75194361, 75194375,
75198019, 75513719)))
21:20:37.928114 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
(72935497, 72935499, 72935501, 72935503, 72935505, 72935511, 73129001,
74054401, 74054403, 74054421, 74054429, 74054431, 74124261, 74151037,
74226709, 74447569, 74547757, 74822341, 74822343, 75194195, 75194241,
75194255, 75194259, 75194261, 75194283, 75194325, 75194361, 75194375,
75198019, 75513719)))
21:20:37.936254 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 (72935497, 72935499,
72935501, 72935503, 72935505, 72935511, 73129001, 74054401, 74054403,
74054421, 74054429, 74054431, 74124261, 74151037, 74226709, 74447569,
74547757, 74822341, 74822343, 75194195, 75194241, 75194255, 75194259,
75194261, 75194283, 75194325, 75194361, 75194375, 75198019, 75513719))
21:20:37.936261 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
(72935497, 72935499, 72935501, 72935503, 72935505, 72935511, 73129001,
74054401, 74054403, 74054421, 74054429, 74054431, 74124261, 74151037,
74226709, 74447569, 74547757, 74822341, 74822343, 75194195, 75194241,
75194255, 75194259, 75194261, 75194283, 75194325, 75194361, 75194375,
75198019, 75513719)))
21:20:37.982445 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
(72935497, 72935499, 72935501, 72935503, 72935505, 72935511, 73129001,
74054401, 74054403, 74054421, 74054429, 74054431, 74124261, 74151037,
74226709, 74447569, 74547757, 74822341, 74822343, 75194195, 75194241,
75194255, 75194259, 75194261, 75194283, 75194325, 75194361, 75194375,
75198019, 75513719)))
21:20:37.988552 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
("533825","533826","533827","533828","533829","533832","002485","536080","536081","536089","536092","536093","536290","008275","536360","074348","600697","971633","971634","538244","538264","538271","538273","538274","538283","538301","538318","538325","003480","538795"))
21:20:37.988555 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
("533825","533826","533827","533828","533829","533832","002485","536080","536081","536089","536092","536093","536290","008275","536360","074348","600697","971633","971634","538244","538264","538271","538273","538274","538283","538301","538318","538325","003480","538795")))
21:20:37.989203 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
("533825","533826","533827","533828","533829","533832","002485","536080","536081","536089","536092","536093","536290","008275","536360","074348","600697","971633","971634","538244","538264","538271","538273","538274","538283","538301","538318","538325","003480","538795")))
21:20:37.989411 trace system.CModule
Loading "goodTpl" application component
21:20:37.989695 trace system.CModule
Loading "widgetFactory" application component
21:20:37.990835 trace system.CModule
Loading "coreMessages" application component
21:20:37.992042 trace system.CModule
Loading "microdataManager" application component
21:20:37.993709 trace system.db.ar.CActiveRecord
Tag.findAll()
21:20:37.994132 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_m50"
from cache
21:20:37.994541 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_s50"
from cache
21:20:37.994760 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1036` AS `t2_c1`, `p`.`DESCRIPTION_1036` AS `t2_c2`,
`p`.`PROPERTY_1037` AS `t2_c3`, `p`.`DESCRIPTION_1037` AS `t2_c4`,
`p`.`PROPERTY_1047` AS `t2_c5`, `p`.`DESCRIPTION_1047` AS `t2_c6`,
`p`.`PROPERTY_1048` AS `t2_c7`, `p`.`DESCRIPTION_1048` AS `t2_c8`,
`p`.`PROPERTY_1049` AS `t2_c9`, `p`.`DESCRIPTION_1049` AS `t2_c10`,
`p`.`PROPERTY_1050` AS `t2_c11`, `p`.`DESCRIPTION_1050` AS `t2_c12`,
`p`.`PROPERTY_1129` AS `t2_c13`, `p`.`DESCRIPTION_1129` AS `t2_c14`,
`p`.`PROPERTY_1156` AS `t2_c15`, `p`.`DESCRIPTION_1156` AS `t2_c16`,
`p`.`PROPERTY_1821` AS `t2_c17`, `p`.`DESCRIPTION_1821` AS `t2_c18`,
`p`.`PROPERTY_1893` AS `t2_c19`, `p`.`DESCRIPTION_1893` AS `t2_c20`,
`p`.`PROPERTY_1894` AS `t2_c21`, `p`.`DESCRIPTION_1894` AS `t2_c22` FROM
`b_iblock_element` `t`  LEFT OUTER JOIN `b_iblock_element_prop_m50` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN
`b_iblock_element_prop_s50` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) WHERE
(((t.IBLOCK_ID = 50) AND (t.ACTIVE = :ACTIVE)) AND (IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_ID AND VALUE = :VALUE)) ORDER BY t.SORT ASC
21:20:37.994764 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1036` AS `t2_c1`, `p`.`DESCRIPTION_1036` AS `t2_c2`,
`p`.`PROPERTY_1037` AS `t2_c3`, `p`.`DESCRIPTION_1037` AS `t2_c4`,
`p`.`PROPERTY_1047` AS `t2_c5`, `p`.`DESCRIPTION_1047` AS `t2_c6`,
`p`.`PROPERTY_1048` AS `t2_c7`, `p`.`DESCRIPTION_1048` AS `t2_c8`,
`p`.`PROPERTY_1049` AS `t2_c9`, `p`.`DESCRIPTION_1049` AS `t2_c10`,
`p`.`PROPERTY_1050` AS `t2_c11`, `p`.`DESCRIPTION_1050` AS `t2_c12`,
`p`.`PROPERTY_1129` AS `t2_c13`, `p`.`DESCRIPTION_1129` AS `t2_c14`,
`p`.`PROPERTY_1156` AS `t2_c15`, `p`.`DESCRIPTION_1156` AS `t2_c16`,
`p`.`PROPERTY_1821` AS `t2_c17`, `p`.`DESCRIPTION_1821` AS `t2_c18`,
`p`.`PROPERTY_1893` AS `t2_c19`, `p`.`DESCRIPTION_1893` AS `t2_c20`,
`p`.`PROPERTY_1894` AS `t2_c21`, `p`.`DESCRIPTION_1894` AS `t2_c22` FROM
`b_iblock_element` `t`  LEFT OUTER JOIN `b_iblock_element_prop_m50` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN
`b_iblock_element_prop_s50` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) WHERE
(((t.IBLOCK_ID = 50) AND (t.ACTIVE = :ACTIVE)) AND (IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_ID AND VALUE = :VALUE)) ORDER BY t.SORT ASC)
21:20:38.000664 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1036` AS `t2_c1`, `p`.`DESCRIPTION_1036` AS `t2_c2`,
`p`.`PROPERTY_1037` AS `t2_c3`, `p`.`DESCRIPTION_1037` AS `t2_c4`,
`p`.`PROPERTY_1047` AS `t2_c5`, `p`.`DESCRIPTION_1047` AS `t2_c6`,
`p`.`PROPERTY_1048` AS `t2_c7`, `p`.`DESCRIPTION_1048` AS `t2_c8`,
`p`.`PROPERTY_1049` AS `t2_c9`, `p`.`DESCRIPTION_1049` AS `t2_c10`,
`p`.`PROPERTY_1050` AS `t2_c11`, `p`.`DESCRIPTION_1050` AS `t2_c12`,
`p`.`PROPERTY_1129` AS `t2_c13`, `p`.`DESCRIPTION_1129` AS `t2_c14`,
`p`.`PROPERTY_1156` AS `t2_c15`, `p`.`DESCRIPTION_1156` AS `t2_c16`,
`p`.`PROPERTY_1821` AS `t2_c17`, `p`.`DESCRIPTION_1821` AS `t2_c18`,
`p`.`PROPERTY_1893` AS `t2_c19`, `p`.`DESCRIPTION_1893` AS `t2_c20`,
`p`.`PROPERTY_1894` AS `t2_c21`, `p`.`DESCRIPTION_1894` AS `t2_c22` FROM
`b_iblock_element` `t`  LEFT OUTER JOIN `b_iblock_element_prop_m50` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN
`b_iblock_element_prop_s50` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) WHERE
(((t.IBLOCK_ID = 50) AND (t.ACTIVE = :ACTIVE)) AND (IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_ID AND VALUE = :VALUE)) ORDER BY t.SORT ASC)
21:20:38.006107 trace system.db.ar.CActiveRecord
TagSearch.findAll()
21:20:38.006552 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section_element"
from cache
21:20:38.006618 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`, `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_section_element` `groups_gr` ON
(`t`.`ID`=`groups_gr`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN
`b_iblock_section` `gr` ON (`gr`.`ID`=`groups_gr`.`IBLOCK_SECTION_ID`) AND
(gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") WHERE ((((t.IBLOCK_ID = 49) AND
(t.ACTIVE = :ACTIVE)) AND (gr.ID = :ID)) AND ((t.CODE IS NULL OR t.CODE =
""))) ORDER BY t.SORT ASC, gr.LEFT_MARGIN, gr.DEPTH_LEVEL
21:20:38.006623 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`, `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_section_element` `groups_gr` ON
(`t`.`ID`=`groups_gr`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN
`b_iblock_section` `gr` ON (`gr`.`ID`=`groups_gr`.`IBLOCK_SECTION_ID`) AND
(gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") WHERE ((((t.IBLOCK_ID = 49) AND
(t.ACTIVE = :ACTIVE)) AND (gr.ID = :ID)) AND ((t.CODE IS NULL OR t.CODE =
""))) ORDER BY t.SORT ASC, gr.LEFT_MARGIN, gr.DEPTH_LEVEL)
21:20:38.007311 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`, `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_section_element` `groups_gr` ON
(`t`.`ID`=`groups_gr`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN
`b_iblock_section` `gr` ON (`gr`.`ID`=`groups_gr`.`IBLOCK_SECTION_ID`) AND
(gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") WHERE ((((t.IBLOCK_ID = 49) AND
(t.ACTIVE = :ACTIVE)) AND (gr.ID = :ID)) AND ((t.CODE IS NULL OR t.CODE =
""))) ORDER BY t.SORT ASC, gr.LEFT_MARGIN, gr.DEPTH_LEVEL)
21:20:38.010144 trace system.caching.CMemCache
Serving "SectionHitsWidget1563" from cache
21:20:38.025363 trace system.CModule
Loading "yandexEcom" application component
21:20:38.025417 trace system.CModule
Loading "warehouse" application component
21:20:38.025800 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
21:20:38.028012 trace system.db.ar.CActiveRecord
CartUser.find()
21:20:38.028059 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
21:20:38.028062 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.028265 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.033286 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
21:20:38.033291 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
21:20:38.033540 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
21:20:38.033586 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
21:20:38.033788 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:application_settings"
from cache
21:20:38.033874 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
21:20:38.033879 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)
21:20:38.034106 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)
21:20:38.034821 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
21:20:38.034825 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
21:20:38.035018 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
21:20:38.035029 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
21:20:38.035104 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
21:20:38.035106 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)
21:20:38.035300 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)
21:20:38.236143 trace system.db.ar.CActiveRecord
Tag.findAll()
21:20:38.236453 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1036` AS `t2_c1`, `p`.`DESCRIPTION_1036` AS `t2_c2`,
`p`.`PROPERTY_1037` AS `t2_c3`, `p`.`DESCRIPTION_1037` AS `t2_c4`,
`p`.`PROPERTY_1047` AS `t2_c5`, `p`.`DESCRIPTION_1047` AS `t2_c6`,
`p`.`PROPERTY_1048` AS `t2_c7`, `p`.`DESCRIPTION_1048` AS `t2_c8`,
`p`.`PROPERTY_1049` AS `t2_c9`, `p`.`DESCRIPTION_1049` AS `t2_c10`,
`p`.`PROPERTY_1050` AS `t2_c11`, `p`.`DESCRIPTION_1050` AS `t2_c12`,
`p`.`PROPERTY_1129` AS `t2_c13`, `p`.`DESCRIPTION_1129` AS `t2_c14`,
`p`.`PROPERTY_1156` AS `t2_c15`, `p`.`DESCRIPTION_1156` AS `t2_c16`,
`p`.`PROPERTY_1821` AS `t2_c17`, `p`.`DESCRIPTION_1821` AS `t2_c18`,
`p`.`PROPERTY_1893` AS `t2_c19`, `p`.`DESCRIPTION_1893` AS `t2_c20`,
`p`.`PROPERTY_1894` AS `t2_c21`, `p`.`DESCRIPTION_1894` AS `t2_c22` FROM
`b_iblock_element` `t`  LEFT OUTER JOIN `b_iblock_element_prop_m50` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN
`b_iblock_element_prop_s50` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) WHERE
(((t.IBLOCK_ID = 50) AND (t.ACTIVE = :ACTIVE)) AND (IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_ID AND VALUE = :VALUE)) ORDER BY t.SORT ASC
21:20:38.236457 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1036` AS `t2_c1`, `p`.`DESCRIPTION_1036` AS `t2_c2`,
`p`.`PROPERTY_1037` AS `t2_c3`, `p`.`DESCRIPTION_1037` AS `t2_c4`,
`p`.`PROPERTY_1047` AS `t2_c5`, `p`.`DESCRIPTION_1047` AS `t2_c6`,
`p`.`PROPERTY_1048` AS `t2_c7`, `p`.`DESCRIPTION_1048` AS `t2_c8`,
`p`.`PROPERTY_1049` AS `t2_c9`, `p`.`DESCRIPTION_1049` AS `t2_c10`,
`p`.`PROPERTY_1050` AS `t2_c11`, `p`.`DESCRIPTION_1050` AS `t2_c12`,
`p`.`PROPERTY_1129` AS `t2_c13`, `p`.`DESCRIPTION_1129` AS `t2_c14`,
`p`.`PROPERTY_1156` AS `t2_c15`, `p`.`DESCRIPTION_1156` AS `t2_c16`,
`p`.`PROPERTY_1821` AS `t2_c17`, `p`.`DESCRIPTION_1821` AS `t2_c18`,
`p`.`PROPERTY_1893` AS `t2_c19`, `p`.`DESCRIPTION_1893` AS `t2_c20`,
`p`.`PROPERTY_1894` AS `t2_c21`, `p`.`DESCRIPTION_1894` AS `t2_c22` FROM
`b_iblock_element` `t`  LEFT OUTER JOIN `b_iblock_element_prop_m50` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN
`b_iblock_element_prop_s50` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) WHERE
(((t.IBLOCK_ID = 50) AND (t.ACTIVE = :ACTIVE)) AND (IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_ID AND VALUE = :VALUE)) ORDER BY t.SORT ASC)
21:20:38.237140 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1036` AS `t2_c1`, `p`.`DESCRIPTION_1036` AS `t2_c2`,
`p`.`PROPERTY_1037` AS `t2_c3`, `p`.`DESCRIPTION_1037` AS `t2_c4`,
`p`.`PROPERTY_1047` AS `t2_c5`, `p`.`DESCRIPTION_1047` AS `t2_c6`,
`p`.`PROPERTY_1048` AS `t2_c7`, `p`.`DESCRIPTION_1048` AS `t2_c8`,
`p`.`PROPERTY_1049` AS `t2_c9`, `p`.`DESCRIPTION_1049` AS `t2_c10`,
`p`.`PROPERTY_1050` AS `t2_c11`, `p`.`DESCRIPTION_1050` AS `t2_c12`,
`p`.`PROPERTY_1129` AS `t2_c13`, `p`.`DESCRIPTION_1129` AS `t2_c14`,
`p`.`PROPERTY_1156` AS `t2_c15`, `p`.`DESCRIPTION_1156` AS `t2_c16`,
`p`.`PROPERTY_1821` AS `t2_c17`, `p`.`DESCRIPTION_1821` AS `t2_c18`,
`p`.`PROPERTY_1893` AS `t2_c19`, `p`.`DESCRIPTION_1893` AS `t2_c20`,
`p`.`PROPERTY_1894` AS `t2_c21`, `p`.`DESCRIPTION_1894` AS `t2_c22` FROM
`b_iblock_element` `t`  LEFT OUTER JOIN `b_iblock_element_prop_m50` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN
`b_iblock_element_prop_s50` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) WHERE
(((t.IBLOCK_ID = 50) AND (t.ACTIVE = :ACTIVE)) AND (IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_ID AND VALUE = :VALUE)) ORDER BY t.SORT ASC)
21:20:38.241935 trace system.db.ar.CActiveRecord
TagSearch.findAll()
21:20:38.242187 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`, `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_section_element` `groups_gr` ON
(`t`.`ID`=`groups_gr`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN
`b_iblock_section` `gr` ON (`gr`.`ID`=`groups_gr`.`IBLOCK_SECTION_ID`) AND
(gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") WHERE ((((t.IBLOCK_ID = 49) AND
(t.ACTIVE = :ACTIVE)) AND (gr.ID = :ID)) AND ((t.CODE IS NULL OR t.CODE =
""))) ORDER BY t.SORT ASC, gr.LEFT_MARGIN, gr.DEPTH_LEVEL
21:20:38.242189 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`, `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_section_element` `groups_gr` ON
(`t`.`ID`=`groups_gr`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN
`b_iblock_section` `gr` ON (`gr`.`ID`=`groups_gr`.`IBLOCK_SECTION_ID`) AND
(gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") WHERE ((((t.IBLOCK_ID = 49) AND
(t.ACTIVE = :ACTIVE)) AND (gr.ID = :ID)) AND ((t.CODE IS NULL OR t.CODE =
""))) ORDER BY t.SORT ASC, gr.LEFT_MARGIN, gr.DEPTH_LEVEL)
21:20:38.242434 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`, `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_element` `t`  LEFT OUTER JOIN
`b_iblock_section_element` `groups_gr` ON
(`t`.`ID`=`groups_gr`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN
`b_iblock_section` `gr` ON (`gr`.`ID`=`groups_gr`.`IBLOCK_SECTION_ID`) AND
(gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") WHERE ((((t.IBLOCK_ID = 49) AND
(t.ACTIVE = :ACTIVE)) AND (gr.ID = :ID)) AND ((t.CODE IS NULL OR t.CODE =
""))) ORDER BY t.SORT ASC, gr.LEFT_MARGIN, gr.DEPTH_LEVEL)
21:20:38.260483 trace system.CModule
Loading "GoodPropDesc" application component
21:20:38.260657 trace system.caching.CFileCache
Serving "iblock_properties_desc" from cache
21:20:38.261221 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCodes1Goodcb0181357bd0e8ce7227a7f6b3995086"
from cache
21:20:38.261403 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66cb0181357bd0e8ce7227a7f6b3995086"
from cache
21:20:38.261559 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods"
from cache
21:20:38.261639 trace system.db.ar.CActiveRecord
MpAttr.find()
21:20:38.261776 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_attrs"
from cache
21:20:38.261822 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
21:20:38.261826 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
21:20:38.262047 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
21:20:38.262062 trace system.db.ar.CActiveRecord
MpAttr.find()
21:20:38.262095 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
21:20:38.262098 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
21:20:38.262280 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
21:20:38.262396 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
21:20:38.262612 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)
21:20:38.297662 trace system.caching.CMemCache
Saving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66cb0181357bd0e8ce7227a7f6b3995086"
to cache
21:20:38.297981 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66cb0181357bd0e8ce7227a7f6b3995086"
from cache
21:20:38.314517 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUPec02fe9809abfa9886ebd24bee855b30dcca48101505dd86b703689a604fe3c4"
from cache
21:20:38.317332 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
21:20:38.317591 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)
21:20:38.344861 profile application
begin:Sphinx select id,@groupby,@count,PROPERTY_MAKER_LIST
21:20:38.344866 profile application
begin:Sphinx index catalog_morph
21:20:38.727020 profile application
begin:Sphinx search. total_found: 482; time: 0.373
21:20:38.736870 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues2532" from cache
21:20:38.739192 trace system.caching.CMemCache
Saving "690139" to cache
21:20:38.786541 trace system.caching.CMemCache
Serving "CB:name:price_list_right_bottom1_desktop" from cache
21:20:38.787113 trace system.caching.CMemCache
Serving "CB:name:price_list_right_bottom_desktop" from cache
21:20:38.793699 trace system.db.ar.CActiveRecord
CartUser.find()
21:20:38.793795 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
21:20:38.793802 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.794106 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.794270 trace system.db.ar.CActiveRecord
CartUser.find()
21:20:38.794306 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
21:20:38.794308 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.794504 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.794513 trace system.db.ar.CActiveRecord
Cart.count()
21:20:38.794790 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
21:20:38.794867 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
21:20:38.794869 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)
21:20:38.795078 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)
21:20:38.797324 trace system.caching.CMemCache
Serving "CB:name:top_header_menu_delivery_desktop" from cache
21:20:38.798417 trace system.caching.CMemCache
Serving "CB:name:top_alert_desktop" from cache
21:20:38.800126 trace system.db.ar.CActiveRecord
CartUser.find()
21:20:38.800163 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
21:20:38.800164 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.800451 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.800487 trace system.db.ar.CActiveRecord
CartUser.find()
21:20:38.800518 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1
21:20:38.800522 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.800695 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1)
21:20:38.800702 trace system.db.ar.CActiveRecord
Cart.count()
21:20:38.800745 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
21:20:38.800748 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)
21:20:38.800925 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)
21:20:38.803997 trace system.caching.CMemCache
Serving "CB:name:bottom_job_desktop" from cache
21:20:38.804493 trace system.caching.CMemCache
Serving "CB:name:partners_desktop" from cache
21:20:38.804984 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_desktop" from cache
21:20:38.805430 trace system.CModule
Loading "territory" application component
21:20:38.809576 trace system.caching.CMemCache
Serving "ITerritory3" from cache
21:20:38.812017 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
21:20:38.816883 trace system.caching.CMemCache
Serving "CB:name:bottom_copy_text_desktop" from cache