Выберите город
Поиск по запросу: 1-67
599 - 624 из 3649 товаров
Фильтр (0)
Уточните категорию
Сортировка
Сортировка
Фильтр
Диск тормозной FORD Transit (00-06) передний (1шт.) SUFIX
Производитель: SUFIX
Артикул: FX1710
Код для заказа: 563963
1 оптовые цены ?
Бесплатная доставка
3 000 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
2 шт.
Новогиреево (24ч)
3 000 ₽
Клапан OPEL Antara (07-) вентиляции бака топливного LONGHO
Производитель: LONGHO
Артикул: 8854157
Код для заказа: 576494
Оставить отзыв оптовые цены ?
Бесплатная доставка
1 450 ₽
Доставка дешевле
Доставка быстрее
Наличие в
3 магазинах
1 шт.
Новогиреево (24ч)
1 450 ₽
1 шт.
Сабурово (24ч)
1 450 ₽
1 шт.
Хабаровская (24ч)
1 450 ₽
Диск тормозной FORD Focus (04-),Kuga,Transit (13-) передний вентилируемый (1шт.) BREMBO
Применяется: показать
Производитель: BREMBO
Артикул: 09.C542.11
Код для заказа: 586958
2 оптовые цены ?
Бесплатная доставка
9 850 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
4 шт.
Новогиреево (24ч)
9 850 ₽
Набор инструментов для демонтажа уплотнителей стекол 7 предметов АВТОДЕЛО
Производитель: АВТОDЕЛО
Артикул: 40687
Код для заказа: 816961
2 оптовые цены ?
Бесплатная доставка
2 190 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
4 шт.
Хабаровская (24ч)
2 190 ₽
Колодки тормозные OPEL Astra G,H,Zafira A задние (4шт.) BOSCH
Применяется: показать
Производитель: BOSCH
Артикул: 0986424646
Код для заказа: 855509
64 оптовые цены ?
Бесплатная доставка
1 875 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
1 875 ₽
Стойка стабилизатора FORD Focus (11-),C-Max (10-) заднего левая/правая KORTEX
Применяется: показать
Производитель: KORTEX
Артикул: KLS5265
Код для заказа: 883135
Оставить отзыв оптовые цены ?
Бесплатная доставка
1 045 ₽
Доставка дешевле
Доставка быстрее
Патрубок SKODA Octavia (97-) вентиляции картера PATRON
Применяется: показать
Производитель: PATRON
Артикул: PH4055
Код для заказа: 882825
14 оптовые цены ?
580 ₽
Доставка дешевле
Доставка быстрее
Наличие в
6 магазинах
5 шт.
Новогиреево (24ч)
580 ₽
2 шт.
Сабурово (24ч)
580 ₽
1 шт.
Хабаровская (24ч)
580 ₽
1 шт.
Кожухово
580 ₽
1 шт.
Пролетарка (24ч)
580 ₽
1 шт.
Тула
540 ₽
Диск тормозной FORD Focus (04-),Kuga,Transit (13-) передний вентилируемый (1шт.) NK
Применяется: показать
Производитель: NK
Артикул: 2025105
Код для заказа: 887483
Оставить отзыв оптовые цены ?
Бесплатная доставка
9 500 ₽
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
9 500 ₽
2 шт.
Хабаровская (24ч)
9 500 ₽
ПГУ DAF SAMPA
Производитель: SAMPA
Артикул: 096.127
Код для заказа: 895948
Оставить отзыв оптовые цены ?
Бесплатная доставка
8 600 ₽
Доставка дешевле
Доставка быстрее
Амортизатор OPEL Vectra C (03-08) крышки багажника PATRON
Применяется: показать
Производитель: PATRON
Артикул: PGS9339XW
Код для заказа: 201825
5 оптовые цены ?
880 ₽
Доставка дешевле
Доставка быстрее
Стакан SCANIA 4 series VOLVO водосборный сепаратора с обогревом (овальный разъем) ATD
Производитель: ATD
Артикул: ATD65373
Код для заказа: 207585
Оставить отзыв оптовые цены ?
Бесплатная доставка
1 250 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Хабаровская (24ч)
1 250 ₽
Реле втягивающее MERCEDES Actros (4 контакта) TESLA TECHNICS
Производитель: TESLA TECHNICS
Артикул: TT76402
Код для заказа: 213490
2 оптовые цены ?
Бесплатная доставка
4 800 ₽
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Новогиреево (24ч)
4 800 ₽
1 шт.
МКАД 6 км. (внут.)
4 800 ₽
Датчик положения коленвала DAF CF75 BOSCH
Применяется: показать
Производитель: BOSCH
Артикул: 0281002511
Код для заказа: 371812
46 оптовые цены ?
Бесплатная доставка
3 150 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Кожухово
3 150 ₽
Колодки тормозные CHEVROLET Cruze (09-),Orlando (10-) задние (4шт.) MANDO
Применяется: показать
Производитель: MANDO
Артикул: MPD31NS
Код для заказа: 374702
120 оптовые цены ?
Бесплатная доставка
1 650 ₽
Доставка дешевле
Доставка быстрее
Датчик температуры PEUGEOT Boxer CITROEN Jumper FIAT Ducato (00-) охлаждающей жидкости STELLOX
Применяется: показать
Производитель: STELLOX
Артикул: 0604011SX
Код для заказа: 376627
Оставить отзыв оптовые цены ?
540 ₽
Доставка дешевле
Доставка быстрее
Наличие в
5 магазинах
1 шт.
Новогиреево (24ч)
540 ₽
1 шт.
Сабурово (24ч)
540 ₽
1 шт.
Хабаровская (24ч)
540 ₽
1 шт.
МКАД 6 км. (внут.)
540 ₽
1 шт.
МКАД 6 км (внеш.)
540 ₽
Амортизатор BMW 5 (E34) (90-) передний левый/правый газовый MANDO
Применяется: показать
Производитель: MANDO
Артикул: MSS016938
Код для заказа: 381420
12 оптовые цены ?
Бесплатная доставка
4 600 ₽
Доставка дешевле
Доставка быстрее
Амортизатор FORD Focus (98-04) задний левый/правый газовый MANDO
Производитель: MANDO
Артикул: MSS016962
Код для заказа: 381434
31 оптовые цены ?
Бесплатная доставка
2 930 ₽
Доставка дешевле
Доставка быстрее
Молдинг FORD Fusion (02-) двери передней левой BSG
Производитель: BSG
Артикул: BSG30925006
Код для заказа: 381546
1 оптовые цены ?
Бесплатная доставка
2 200 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
2 200 ₽
Крышка DAF фильтра топливного SAMPA
Производитель: SAMPA
Артикул: 051.432
Код для заказа: 391483
Оставить отзыв оптовые цены ?
Бесплатная доставка
730 ₽
Доставка дешевле
Доставка быстрее
Наличие в
2 магазинах
1 шт.
Хабаровская (24ч)
730 ₽
1 шт.
МКАД 6 км. (внут.)
730 ₽
Фильтр воздушный BMW 2 (F45),X1 (F48) MINI Cooper METACO
Производитель: METACO
Артикул: 1000-519
Код для заказа: 410925
Оставить отзыв оптовые цены ?
Только самовывоз
670 ₽
Наличие в
1 магазине
1 шт.
Черное
670 ₽
Радиатор BMW X3 (09-) NISSENS
Применяется: показать
Производитель: NISSENS
Артикул: 60808
Код для заказа: 290142
1 оптовые цены ?
22 600 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
1 шт.
Новогиреево (24ч)
22 600 ₽
Датчик положения коленвала DAF CF75 SAMPA
Применяется: показать
Производитель: SAMPA
Артикул: 093.254
Код для заказа: 293801
Оставить отзыв оптовые цены ?
Бесплатная доставка
790 ₽
Доставка дешевле
Доставка быстрее
Буфер DAF рессоры задней SAMPA
Производитель: SAMPA
Артикул: 050.162
Код для заказа: 313988
Оставить отзыв оптовые цены ?
Бесплатная доставка
6 659 ₽
Доставка дешевле
Доставка быстрее
Радиатор CHEVROLET Cruze (09-) (2.0) АКПП PATRON
Применяется: показать
Производитель: PATRON
Артикул: PRS4463
Код для заказа: 314905
Оставить отзыв оптовые цены ?
8 000 ₽
Доставка дешевле
Доставка быстрее
Наличие в
10 магазинах
1 шт.
Новогиреево (24ч)
8 000 ₽
2 шт.
Сабурово (24ч)
8 000 ₽
1 шт.
Хабаровская (24ч)
8 000 ₽
1 шт.
Черное
8 000 ₽
1 шт.
Кожухово
8 000 ₽
1 шт.
Пролетарка (24ч)
8 000 ₽
1 шт.
Подольск (24ч)
8 000 ₽
1 шт.
Щёлково
8 000 ₽
1 шт.
Раменское
7 440 ₽
1 шт.
Тула
7 440 ₽
Диск тормозной FORD Focus (04-),Kuga,Transit (13-) передний вентилируемый (1шт.) MANDO
Производитель: MANDO
Артикул: MBC035041
Код для заказа: 321804
Оставить отзыв оптовые цены ?
Бесплатная доставка
5 200 ₽
Доставка дешевле
Доставка быстрее
Наличие в
1 магазине
2 шт.
МКАД 6 км. (внут.)
5 200 ₽
Ролик ГРМ CHEVROLET Cruze (09-) (1.6/1.8) комплект LYNX
Применяется: показать
Производитель: LYNX
Артикул: PK3129
Код для заказа: 324630
Оставить отзыв оптовые цены ?
Бесплатная доставка
5 700 ₽
Доставка дешевле
Доставка быстрее
Наличие в
7 магазинах
1 шт.
Новогиреево (24ч)
5 700 ₽
1 шт.
Сабурово (24ч)
5 700 ₽
1 шт.
Хабаровская (24ч)
5 700 ₽
1 шт.
Кожухово
5 700 ₽
1 шт.
Щёлково
5 700 ₽
2 шт.
Раменское
5 020 ₽
1 шт.
Тула
5 305 ₽

MECAFILTER
Фильтр воздушный
CASALS
Крышка
DODUCO
Контактная группа магнето
PVL
Комплект высоковольтных проводов
OSVAT
Клапан выпускной
METALFREN
Колодки тормозные
QUINTON HAZELL
Натяжной ролик, ремень ГРМ
MAGNETI MARELLI
Колодки тормозные
SEIWA
Провода высоковольтные
CDX
Комплект ШРУСа
KALE
Радиатор охлаждения двигателя
DAYCO
Промежуточный ролик ремня ГРМ
IZAWIT
Основной глушитель
FISPA
Фильтр салонный
POWER FRICTION
Диск тормозной
ZARA
Приемная труба глушителя
ALCO
Амортизатор
FIAT
Гайка
BREMS.-U.KUPPL.TEILE
Суппорт тормозной
GT EXHAUST
Система выпуска ОГ
MGA
Колодки тормозные дисковые
PEUGEOT/CITROEN
SIDAT
Фильтр салонный
AUTOMOTOR FRANCE
ORJIN
Наконечник рулевой тяги
ACDELCO
Колодки тормозные
CX
Комплект подшипника ступицы колеса
FRICTION MASTER
VEMA
Рычаг независимой подвески колеса, подвеска колеса
LAUTRETTE
Фильтр воздушный
NGK
Датчик кислородный
EBERSPACHER
Система выпуска ОГ
FIAT/ALFA ROMEO/LANCIA
Гайка
NISSAN/INFINITI
DR. MARCUS
Ароматизатор воздуха жидкий Senso Regulated Big 10мл Dr.Marcus ocean вклад
НОВОСИБИРСКИЙ ИЗ
СТАНКОИМПОРТ
DAIHATSU
Гайка
Личный кабинет 0
Общий отчет (Время: 3.97369с, Память: 24,276Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
loading session 2 3.15526 1.57763 0.00000 3.15526
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)))) 1 0.00294 0.00294 0.00294 0.00294
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.00076 0.00025 0.00022 0.00029
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) 1 0.00043 0.00043 0.00043 0.00043
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.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID` AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`, `t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY` AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`, `t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`, `t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`, `t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS `t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS `t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS `t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS `t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS `t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS `t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`, `t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`, `t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`, `t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM `b_sale_basket` `t` WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND (FUSER_ID=:FUSER_ID))) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT `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 (87944164, 93352641, 100089574, 116968958, 132008588, 158248385, 158431229, 164514353, 175810193, 184006812, 188849982, 191059266, 200624329, 201255537, 201550973, 202195816, 202195830, 202195942, 204203033, 204858831, 206252941, 206350435, 207524353, 207649879, 208346329, 208465011)) ORDER BY sorter) 1 0.00078 0.00078 0.00078 0.00078
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 (87944164, 93352641, 100089574, 116968958, 132008588, 158248385, 158431229, 164514353, 175810193, 184006812, 188849982, 191059266, 200624329, 201255537, 201550973, 202195816, 202195830, 202195942, 204203033, 204858831, 206252941, 206350435, 207524353, 207649879, 208346329, 208465011))) 1 0.00096 0.00096 0.00096 0.00096
Sphinx index catalog,catalog_morph,marketplace 2 1.30785 0.65392 0.58482 0.72303
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 (87944164, 93352641, 100089574, 116968958, 132008588, 158248385, 158431229, 164514353, 175810193, 184006812, 188849982, 191059266, 200624329, 201255537, 201550973, 202195816, 202195830, 202195942, 204203033, 204858831, 206252941, 206350435, 207524353, 207649879, 208346329, 208465011))) 1 0.03868 0.03868 0.03868 0.03868
system.db.CDbCommand.query(call get_applied_by_catalog_ids_query('87944164,93352641,100089574,116968958,132008588,158248385,158431229,164514353,175810193,184006812,188849982,191059266,200624329,201255537,201550973,202195816,202195830,202195942,204203033,204858831,206252941,206350435,207524353,207649879,208346329,208465011', '1', '(cm.`name` LIKE "%1 67%")')) 1 0.00650 0.00650 0.00650 0.00650
Sphinx search. total_found: 1150; time: 0.056 1 0.48180 0.48180 0.48180 0.48180
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 ("563963","576494","586958","816961","855509","883135","882825","887483","895948","201825","207585","213490","371812","374702","376627","381420","381434","381546","391483","410925","290142","293801","313988","314905","321804","324630"))) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code LIMIT 1) 2 0.00046 0.00023 0.00019 0.00028
system.db.CDbCommand.query(SELECT * FROM `personal_settings` WHERE actor_uid=:uid AND actor_type=:type_id) 2 0.00044 0.00022 0.00021 0.00023
system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE (t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID)) 1 0.00024 0.00024 0.00024 0.00024
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 `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
Sphinx select id,@groupby,@distinct,@count,property_msection_id 1 0.58482 0.58482 0.58482 0.58482
Sphinx search. total_found: 3649; time: 0.048 1 0.67060 0.67060 0.67060 0.67060
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) 1 0.00024 0.00024 0.00024 0.00024
Журнал приложения
Время Уровень Категория Сообщение
04:23:12.378448 trace system.CModule
Loading "log" application component
04:23:12.382309 trace glitchtip_fallback
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed.
04:23:12.382824 trace system.CModule
Loading "db" application component
04:23:12.383219 trace system.db.CDbConnection
Opening DB connection
04:23:12.384253 trace system.db.CDbCommand
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1
04:23:12.384258 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
04:23:12.384495 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)
04:23:12.384772 trace system.CModule
Loading "urlHelper" application component
04:23:12.385807 trace system.CModule
Loading "DBConfig" application component
04:23:12.386142 trace system.CModule
Loading "cache" application component
04:23:12.387295 trace system.caching.CMemCache
Serving "66307959e0460a2e2436b0319b2fda14" from cache
04:23:12.387562 trace system.CModule
Loading "geo" application component
04:23:12.388207 trace system.CModule
Loading "request" application component
04:23:12.389293 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache
04:23:12.389328 trace system.db.ar.CActiveRecord
Location.findByPk()
04:23:12.389674 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache
04:23:12.389858 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache
04:23:12.389986 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
04:23:12.389990 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)
04:23:12.390227 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)
04:23:12.390727 trace system.CModule
Loading "user" application component
04:23:12.391204 profile application
begin:loading session
04:23:12.391207 trace system.CModule
Loading "session" application component
04:23:15.546464 profile application
end:loading session
04:23:15.546964 trace system.db.ar.CActiveRecord
OutLocation.findByPk()
04:23:15.547235 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache
04:23:15.547331 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1
04:23:15.547336 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
04:23:15.547769 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1)
04:23:15.547933 trace system.CModule
Loading "B2BConfig" application component
04:23:15.548079 trace system.CModule
Loading "urlManager" application component
04:23:15.549312 trace system.caching.CMemCache
Serving "Yii.CUrlManager.rules" from cache
04:23:15.550123 trace system.CModule
Loading "themeInterlayer" application component
04:23:15.550400 trace system.CModule
Loading "themeManager" application component
04:23:15.551673 trace system.web.filters.CFilterChain
Running filter DBReadUncomitedLevelFilter.filter()
04:23:15.551692 trace system.db.CDbCommand
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
04:23:15.551697 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
04:23:15.551940 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;)
04:23:15.551975 trace system.CModule
Loading "cart" application component
04:23:15.552089 trace system.db.ar.CActiveRecord
CartUser.find()
04:23:15.552247 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache
04:23:15.552288 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1
04:23:15.552289 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
04:23:15.552473 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1)
04:23:15.552721 trace system.CModule
Loading "coupon" application component
04:23:15.552820 trace system.db.ar.CActiveRecord
Cart.findAll()
04:23:15.553019 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache
04:23:15.553251 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket_props"
from cache
04:23:15.553374 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID` AS `t0_c1`,
`t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID))
04:23:15.553376 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID`
AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID)))
04:23:15.553596 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID`
AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`,
`t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY`
AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`,
`t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`,
`t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`,
`t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS
`t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS
`t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS
`t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS
`t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS
`t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS
`t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`,
`t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`,
`t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`,
`t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM
`b_sale_basket` `t`  WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND
(FUSER_ID=:FUSER_ID)))
04:23:15.553777 trace system.CModule
Loading "assetManager" application component
04:23:15.553951 trace system.db.ar.CActiveRecord
DeliveryCalcMain.find()
04:23:15.554088 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache
04:23:15.554121 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1
04:23:15.554124 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)
04:23:15.554306 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)
04:23:15.555342 trace system.CModule
Loading "redisCache" application component
04:23:15.556158 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
04:23:15.556374 trace system.caching.CRedisCache
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache
04:23:15.556479 profile application
begin:loading session
04:23:15.556483 profile application
end:loading session
04:23:15.558094 trace system.CModule
Loading "order" application component
04:23:15.561182 trace system.CModule
Loading "IPropeties" application component
04:23:15.564590 trace system.caching.CMemCache
Serving "iblock_properties_0" from cache
04:23:15.565480 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1408" from cache
04:23:15.565885 trace system.caching.CMemCache
Serving "IWarehouseIWarehouse::getStaticList" from cache
04:23:15.566009 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
04:23:15.566015 trace system.CModule
Loading "dbTP" application component
04:23:15.566034 trace system.db.CDbConnection
Opening DB connection
04:23:15.567141 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache
04:23:15.567358 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache
04:23:15.567538 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)
04:23:15.594513 trace system.CModule
Loading "ICatalog" application component
04:23:15.594695 trace system.caching.CMemCache
Serving "b_catalog_group1" from cache
04:23:15.595288 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache
04:23:15.595619 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
04:23:15.595824 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)
04:23:15.624079 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)
04:23:15.624085 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))
04:23:15.624392 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))
04:23:15.624553 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
04:23:15.624556 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)
04:23:15.624774 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)
04:23:15.625019 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
04:23:15.677449 profile application
begin:Sphinx search. total_found: 3649; time: 0.048
04:23:15.677658 trace system.db.ar.CActiveRecord
Good.findAll()
04:23:15.678014 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache
04:23:15.678232 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache
04:23:15.678459 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache
04:23:15.680722 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache
04:23:15.680941 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)))
04:23:15.680943 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))))
04:23:15.683887 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))))
04:23:15.685250 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache
04:23:15.685301 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 (87944164, 93352641,
100089574, 116968958, 132008588, 158248385, 158431229, 164514353,
175810193, 184006812, 188849982, 191059266, 200624329, 201255537,
201550973, 202195816, 202195830, 202195942, 204203033, 204858831,
206252941, 206350435, 207524353, 207649879, 208346329, 208465011)) ORDER BY
sorter
04:23:15.685303 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 (87944164, 93352641,
100089574, 116968958, 132008588, 158248385, 158431229, 164514353,
175810193, 184006812, 188849982, 191059266, 200624329, 201255537,
201550973, 202195816, 202195830, 202195942, 204203033, 204858831,
206252941, 206350435, 207524353, 207649879, 208346329, 208465011)) ORDER BY
sorter)
04:23:15.686086 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 (87944164, 93352641,
100089574, 116968958, 132008588, 158248385, 158431229, 164514353,
175810193, 184006812, 188849982, 191059266, 200624329, 201255537,
201550973, 202195816, 202195830, 202195942, 204203033, 204858831,
206252941, 206350435, 207524353, 207649879, 208346329, 208465011)) ORDER BY
sorter)
04:23:15.686220 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 (87944164, 93352641, 100089574, 116968958, 132008588,
158248385, 158431229, 164514353, 175810193, 184006812, 188849982,
191059266, 200624329, 201255537, 201550973, 202195816, 202195830,
202195942, 204203033, 204858831, 206252941, 206350435, 207524353,
207649879, 208346329, 208465011))
04:23:15.686223 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
(87944164, 93352641, 100089574, 116968958, 132008588, 158248385, 158431229,
164514353, 175810193, 184006812, 188849982, 191059266, 200624329,
201255537, 201550973, 202195816, 202195830, 202195942, 204203033,
204858831, 206252941, 206350435, 207524353, 207649879, 208346329,
208465011)))
04:23:15.687186 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
(87944164, 93352641, 100089574, 116968958, 132008588, 158248385, 158431229,
164514353, 175810193, 184006812, 188849982, 191059266, 200624329,
201255537, 201550973, 202195816, 202195830, 202195942, 204203033,
204858831, 206252941, 206350435, 207524353, 207649879, 208346329,
208465011)))
04:23:15.691492 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 (87944164, 93352641,
100089574, 116968958, 132008588, 158248385, 158431229, 164514353,
175810193, 184006812, 188849982, 191059266, 200624329, 201255537,
201550973, 202195816, 202195830, 202195942, 204203033, 204858831,
206252941, 206350435, 207524353, 207649879, 208346329, 208465011))
04:23:15.691494 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
(87944164, 93352641, 100089574, 116968958, 132008588, 158248385, 158431229,
164514353, 175810193, 184006812, 188849982, 191059266, 200624329,
201255537, 201550973, 202195816, 202195830, 202195942, 204203033,
204858831, 206252941, 206350435, 207524353, 207649879, 208346329,
208465011)))
04:23:15.730174 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
(87944164, 93352641, 100089574, 116968958, 132008588, 158248385, 158431229,
164514353, 175810193, 184006812, 188849982, 191059266, 200624329,
201255537, 201550973, 202195816, 202195830, 202195942, 204203033,
204858831, 206252941, 206350435, 207524353, 207649879, 208346329,
208465011)))
04:23:15.736160 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
04:23:15.736165 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)
04:23:15.736454 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)
04:23:15.736620 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
04:23:15.736857 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)
04:23:15.763231 profile application
begin:Sphinx select id,@groupby,@distinct,@count,property_msection_id
04:23:15.763236 profile application
begin:Sphinx index catalog,catalog_morph,marketplace
04:23:15.866255 profile application
begin:Sphinx search. total_found: 1150; time: 0.056
04:23:15.866725 trace system.CModule
Loading "GoodSections" application component
04:23:15.866811 trace system.CModule
Loading "fcache" application component
04:23:15.877103 trace system.caching.CFileCache
Serving "good_sections_tree5" from cache
04:23:15.877384 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache
04:23:15.882405 trace system.db.CDbCommand
Querying SQL: call
get_applied_by_catalog_ids_query('87944164,93352641,100089574,116968958,132008588,158248385,158431229,164514353,175810193,184006812,188849982,191059266,200624329,201255537,201550973,202195816,202195830,202195942,204203033,204858831,206252941,206350435,207524353,207649879,208346329,208465011',
'1', '(cm.`name` LIKE "%1 67%")')
04:23:15.882410 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('87944164,93352641,100089574,116968958,132008588,158248385,158431229,164514353,175810193,184006812,188849982,191059266,200624329,201255537,201550973,202195816,202195830,202195942,204203033,204858831,206252941,206350435,207524353,207649879,208346329,208465011',
'1', '(cm.`name` LIKE "%1 67%")'))
04:23:15.888906 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(call
get_applied_by_catalog_ids_query('87944164,93352641,100089574,116968958,132008588,158248385,158431229,164514353,175810193,184006812,188849982,191059266,200624329,201255537,201550973,202195816,202195830,202195942,204203033,204858831,206252941,206350435,207524353,207649879,208346329,208465011',
'1', '(cm.`name` LIKE "%1 67%")'))
04:23:15.889059 trace system.CModule
Loading "dbTecDoc" application component
04:23:15.889081 trace system.db.CDbConnection
Opening DB connection
04:23:15.890055 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
04:23:15.890470 trace system.CModule
Loading "dbTecDoc2" application component
04:23:15.890482 trace system.db.CDbConnection
Opening DB connection
04:23:15.891326 trace system.db.CDbCommand
Querying SQL: call get_brandfilter_by_art_no_link_v7_1('167', 49, 66, 1,
66)
04:23:15.969603 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
("563963","576494","586958","816961","855509","883135","882825","887483","895948","201825","207585","213490","371812","374702","376627","381420","381434","381546","391483","410925","290142","293801","313988","314905","321804","324630"))
04:23:15.969611 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
("563963","576494","586958","816961","855509","883135","882825","887483","895948","201825","207585","213490","371812","374702","376627","381420","381434","381546","391483","410925","290142","293801","313988","314905","321804","324630")))
04:23:15.970458 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
("563963","576494","586958","816961","855509","883135","882825","887483","895948","201825","207585","213490","371812","374702","376627","381420","381434","381546","391483","410925","290142","293801","313988","314905","321804","324630")))
04:23:15.970751 trace system.CModule
Loading "warehouse" application component
04:23:15.971240 trace system.caching.CMemCache
Serving "IWarehouse1" from cache
04:23:15.984549 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_uts_iblock_49_section"
from cache
04:23:15.990593 trace system.CModule
Loading "goodTpl" application component
04:23:15.998312 trace system.CModule
Loading "clientScript" application component
04:23:16.001903 trace system.CModule
Loading "microdataManager" application component
04:23:16.086457 trace system.CModule
Loading "widgetFactory" application component
04:23:16.087074 trace system.CModule
Loading "GoodPropDesc" application component
04:23:16.087297 trace system.caching.CFileCache
Serving "iblock_properties_desc" from cache
04:23:16.088018 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCodes1Goodba7be359a34cab1b24fd9526a4a6781b"
from cache
04:23:16.088224 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66ba7be359a34cab1b24fd9526a4a6781b"
from cache
04:23:16.088413 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_goods"
from cache
04:23:16.088507 trace system.db.ar.CActiveRecord
MpAttr.find()
04:23:16.088661 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:mp_attrs"
from cache
04:23:16.088726 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
04:23:16.088731 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
04:23:16.089006 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
04:23:16.089057 trace system.db.ar.CActiveRecord
MpAttr.find()
04:23:16.089109 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mp_attrs` `t` WHERE global_code=:global_code
LIMIT 1
04:23:16.089112 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
04:23:16.089302 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mp_attrs` `t` WHERE
global_code=:global_code LIMIT 1)
04:23:16.089411 trace system.db.ar.CActiveRecord
TPSupToTer.findAll()
04:23:16.089694 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)
04:23:16.118099 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
04:23:16.118103 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)
04:23:16.118355 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)
04:23:16.120349 trace system.caching.CMemCache
Saving
"MpAttrsHelpergetAttrIssetValuesByCodesd41d8cd98f00b204e9800998ecf8427e66ba7be359a34cab1b24fd9526a4a6781b"
to cache
04:23:16.120645 trace system.caching.CMemCache
Serving
"MpAttrsHelpergetAttrIssetForOurGoodsValuesByCodesd41d8cd98f00b204e9800998ecf8427e66ba7be359a34cab1b24fd9526a4a6781b"
from cache
04:23:16.124248 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_MAKER_LIST17ba7591c20bdc7891fcefc7e4492c71dcca48101505dd86b703689a604fe3c4"
from cache
04:23:16.125508 trace system.caching.CMemCache
Serving
"iblock_properties_0getPropIssetValuesByCoded41d8cd98f00b204e9800998ecf8427eGoodPROPERTY_CATGROUP17ba7591c20bdc7891fcefc7e4492c71dcca48101505dd86b703689a604fe3c4"
from cache
04:23:16.142932 trace system.CModule
Loading "yandexEcom" application component
04:23:16.149230 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
04:23:16.149235 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
04:23:16.149461 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
04:23:16.149504 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
04:23:16.149665 trace system.caching.CMemCache
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:application_settings"
from cache
04:23:16.149744 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
04:23:16.149749 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)
04:23:16.149976 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)
04:23:16.150690 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id
04:23:16.150692 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
04:23:16.150903 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT *
FROM `personal_settings`
WHERE actor_uid=:uid AND actor_type=:type_id)
04:23:16.150919 trace system.db.ar.CActiveRecord
ApplicationSetting.findByPk()
04:23:16.150970 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
04:23:16.150974 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)
04:23:16.151163 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)
04:23:16.151295 trace system.db.ar.CActiveRecord
Bookmark.findAll()
04:23:16.151376 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `b_sale_basket` `t` WHERE (t.LID = :CART_LID
and DELAY = "Y") AND (FUSER_ID=:FUSER_ID)
04:23:16.151381 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE
(t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID))
04:23:16.151616 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_basket` `t` WHERE
(t.LID = :CART_LID and DELAY = "Y") AND (FUSER_ID=:FUSER_ID))
04:23:16.293809 trace system.CModule
Loading "coreMessages" application component
04:23:16.299418 trace system.caching.CMemCache
Serving "GoodsShortListWidget_043c037720362f7577b735c50699edd5" from cache
04:23:16.308108 trace system.caching.CMemCache
Serving "CB:name:top_alert_mobile" from cache
04:23:16.309799 trace system.caching.CMemCache
Serving "CB:name:bottom_for_buyer_mobile" from cache
04:23:16.310529 trace system.CModule
Loading "territory" application component
04:23:16.314738 trace system.caching.CMemCache
Serving "ITerritory3" from cache
04:23:16.317223 trace system.caching.CMemCache
Serving "iblock_properties_0getPropValues1045" from cache
04:23:16.324253 trace system.caching.CMemCache
Serving "CB:name:bottom_job_mobile" from cache
04:23:16.325129 trace system.caching.CMemCache
Serving "CB:name:partners_mobile" from cache
04:23:16.327924 trace system.db.ar.CActiveRecord
Cart.count()
04:23:16.328006 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
04:23:16.328011 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)
04:23:16.328314 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)