|
Общий отчет
(Время: 7.24598с,
Память: 126,090Кб)
|
| Процедура |
Номер |
Всего (с) |
Средн. (с) |
Мин. (с) |
Макс. (с) |
| loading session |
2 |
6.46130 |
3.23065 |
0.00000 |
6.46130 |
| system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) WHERE (`t`.`ID`=222415211)) |
1 |
0.00251 |
0.00251 |
0.00251 |
0.00251 |
| 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` FROM `b_iblock_element` `t` WHERE ((t.IBLOCK_ID = 24) AND (t.CODE = :CODE))) |
1 |
0.00071 |
0.00071 |
0.00071 |
0.00071 |
| 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.00026 |
0.00026 |
0.00026 |
0.00026 |
| system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) |
1 |
0.00025 |
0.00025 |
0.00025 |
0.00025 |
| system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) |
1 |
0.00020 |
0.00020 |
0.00020 |
0.00020 |
| system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) |
1 |
0.00019 |
0.00019 |
0.00019 |
0.00019 |
| system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1) |
1 |
0.00019 |
0.00019 |
0.00019 |
0.00019 |
| system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS `t2_c0`, `pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`, `pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`, `pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`, `pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`, `pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND (pr.CATALOG_GROUP_ID IN (2,1)) WHERE (`t`.`ID`=222415211)) |
1 |
0.00048 |
0.00048 |
0.00048 |
0.00048 |
| system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS `t3_c0`, `cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`, `cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`, `cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`, `cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO` AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`, `cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`, `cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`, `cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`, `cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`, `cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`, `cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`, `cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`, `cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS `t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`, `cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM `b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON (`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr` ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88) WHERE (`t`.`ID`=222415211)) |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| 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_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`, `p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`, `p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`, `p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`, `p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`, `p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`, `pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS `t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`, `pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR` AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`, `pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN (9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) |
1 |
0.00250 |
0.00250 |
0.00250 |
0.00250 |
| system.db.CDbCommand.query(SELECT `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_section` `gr` INNER JOIN `sp_catalog2msections` `groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND (`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL) |
1 |
0.00108 |
0.00108 |
0.00108 |
0.00108 |
| system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS `t4_c0`, `uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`, `uf`.`date_create` AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status` AS `t4_c5`, `uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`, `uf`.`review_id` AS `t4_c8`, `uf`.`file_path` AS `t4_c9`, `uf`.`file_path_small` AS `t4_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 (status IN (:ycp0, :ycp1)) WHERE (`t`.`ID`=222415211) ORDER BY sorter) |
1 |
0.00047 |
0.00047 |
0.00047 |
0.00047 |
| system.db.CDbCommand.query(
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`PATHICON` AS `ICO`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
1 |
0.00067 |
0.00067 |
0.00067 |
0.00067 |
| system.db.CDbCommand.query(
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`,
s.G0ID,
s.G0NAME,
s.G1NAME,
s.SMALLPICTUREINDEX,
s.PPID AS ID,
s.NAME AS NAME
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
1 |
0.00063 |
0.00063 |
0.00063 |
0.00063 |
| system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`, `tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`, `tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`, `tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`, `tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO` AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`, `tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`, `tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`, `tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`, `tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`, `tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`, `tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`, `tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`, `tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS `t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM `b_iblock_element` `tg` INNER JOIN `sp_tags2catalog` `tags_tg` ON (`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND (tg.IBLOCK_ID = 50)) |
1 |
0.00061 |
0.00061 |
0.00061 |
0.00061 |
| 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.00025 |
0.00025 |
0.00025 |
0.00025 |
| system.db.CDbCommand.query(SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code) |
1 |
0.00174 |
0.00174 |
0.00174 |
0.00174 |
| SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code = '527133' GROUP BY `ce`.`external_id` |
1 |
0.00162 |
0.00162 |
0.00162 |
0.00162 |
| 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_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`, `pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS `t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`, `pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR` AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`, `pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN (9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW()
AND (t.ACTIVE_TO IS NULL
OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW())))) ORDER BY ACTIVE_FROM DESC LIMIT 10) |
1 |
0.00153 |
0.00153 |
0.00153 |
0.00153 |
| system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
3 |
0.00074 |
0.00025 |
0.00018 |
0.00036 |
| system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`, `t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`, `t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`, `t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`, `t`.`question`, `t`.`state_change_reason` FROM `sp_reviews` `t` INNER JOIN sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId) AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10) |
1 |
0.00064 |
0.00064 |
0.00064 |
0.00064 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t` WHERE (good_code=:good_code) AND (is_active = :is_active)) |
1 |
0.00038 |
0.00038 |
0.00038 |
0.00038 |
| system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`, `ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS `t1_c3` FROM `sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND (`ms`.`ELEMENT_ID`=:ypl0)) |
1 |
0.00037 |
0.00037 |
0.00037 |
0.00037 |
| system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS `t0_c1`, `t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`, `t`.`model_id` AS `t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS `t0_c6`, `t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`, `t`.`reg_number` AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS `t0_c11`, `t`.`year` AS `t0_c12`, `t`.`date_create` AS `t0_c13`, `t`.`engine` AS `t0_c14`, `t`.`chassis` AS `t0_c15`, `t`.`carrying` AS `t0_c16`, `t`.`body` AS `t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id` AS `t0_c19`, `t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS `t0_c21`, `t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS `t0_c24`, `t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS `t0_c27`, `t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`, `t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`, `t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`, `t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`, `t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id` AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`, `catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`, `catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS `t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month` AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`, `catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort` AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS `t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`, `catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS `t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS `t2_c6`, `catt`.`construct_from_month` AS `t2_c7`, `catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS `t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`, `catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`, `catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM `sp_user_cars` `t` LEFT OUTER JOIN `cat_models` `catm` ON (`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON (`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active)) LIMIT 100) |
1 |
0.00037 |
0.00037 |
0.00037 |
0.00037 |
| 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 ("527133"))) |
1 |
0.00038 |
0.00038 |
0.00038 |
0.00038 |
| system.db.CDbCommand.query(SELECT `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_file` `pp` WHERE (`pp`.`ID`=:ypl0)) |
1 |
0.00033 |
0.00033 |
0.00033 |
0.00033 |
| system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
3 |
0.00068 |
0.00023 |
0.00018 |
0.00032 |
| system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
3 |
0.00067 |
0.00022 |
0.00017 |
0.00032 |
| system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
1 |
0.00022 |
0.00022 |
0.00022 |
0.00022 |
| system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
2 |
0.00037 |
0.00018 |
0.00018 |
0.00019 |
| Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
1 |
0.00099 |
0.00099 |
0.00099 |
0.00099 |
| system.db.CDbCommand.query(
SELECT
`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`
FROM
`marks`,
`s_marks`
WHERE
`s_marks`.`idsite` = 3 AND
`marks`.`ID` = `s_marks`.`idmark`
ORDER BY
3
) |
1 |
0.00054 |
0.00054 |
0.00054 |
0.00054 |
| SELECT `ce`.`id`, `ce`.`external_id`, `cef`.`file`, `cep`.`product_code` FROM `sp_certs2` `ce` LEFT JOIN `sp_certs2_files` `cef` ON cef.cert_id = ce.id LEFT JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE ce.id = '15447' GROUP BY `cef`.`id`, `cep`.`id` |
1 |
0.64784 |
0.64784 |
0.64784 |
0.64784 |
| system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
1 |
0.00023 |
0.00023 |
0.00023 |
0.00023 |
|
Журнал приложения
|
| Время |
Уровень |
Категория |
Сообщение |
| 06:51:50.248574 |
trace |
system.CModule |
Loading "log" application component |
| 06:51:50.252161 |
trace |
glitchtip_fallback |
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed. |
| 06:51:50.252409 |
trace |
system.CModule |
Loading "db" application component |
| 06:51:50.252465 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 06:51:50.253472 |
trace |
system.db.CDbCommand |
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1 |
| 06:51:50.253477 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 06:51:50.253706 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 06:51:50.253846 |
trace |
system.CModule |
Loading "urlHelper" application component |
| 06:51:50.253952 |
trace |
system.CModule |
Loading "DBConfig" application component |
| 06:51:50.253979 |
trace |
system.CModule |
Loading "cache" application component |
| 06:51:50.254825 |
trace |
system.caching.CMemCache |
Serving "66307959e0460a2e2436b0319b2fda14" from cache |
| 06:51:50.255232 |
trace |
system.CModule |
Loading "geo" application component |
| 06:51:50.255327 |
trace |
system.CModule |
Loading "request" application component |
| 06:51:50.256247 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache |
| 06:51:50.256304 |
trace |
system.db.ar.CActiveRecord |
Location.findByPk() |
| 06:51:50.257061 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache |
| 06:51:50.257581 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache |
| 06:51:50.257816 |
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 |
| 06:51:50.257822 |
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) |
| 06:51:50.258068 |
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) |
| 06:51:50.258286 |
trace |
system.CModule |
Loading "user" application component |
| 06:51:50.258456 |
profile |
application |
begin:loading session |
| 06:51:50.258462 |
trace |
system.CModule |
Loading "session" application component |
| 06:51:56.719753 |
profile |
application |
end:loading session |
| 06:51:56.720401 |
trace |
system.db.ar.CActiveRecord |
OutLocation.findByPk() |
| 06:51:56.720628 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache |
| 06:51:56.720748 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1 |
| 06:51:56.720756 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1) |
| 06:51:56.721004 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1) |
| 06:51:56.721144 |
trace |
system.CModule |
Loading "B2BConfig" application component |
| 06:51:56.721235 |
trace |
system.CModule |
Loading "urlManager" application component |
| 06:51:56.722783 |
trace |
system.caching.CMemCache |
Serving "Yii.CUrlManager.rules" from cache |
| 06:51:56.723404 |
trace |
system.CModule |
Loading "themeInterlayer" application component |
| 06:51:56.723803 |
trace |
system.CModule |
Loading "themeManager" application component |
| 06:51:56.725279 |
trace |
system.web.filters.CFilterChain |
Running filter DBReadUncomitedLevelFilter.filter() |
| 06:51:56.725300 |
trace |
system.db.CDbCommand |
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; |
| 06:51:56.725306 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 06:51:56.725509 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 06:51:56.725562 |
trace |
system.CModule |
Loading "cart" application component |
| 06:51:56.725713 |
trace |
system.db.ar.CActiveRecord |
CartUser.find() |
| 06:51:56.725881 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache |
| 06:51:56.725936 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1 |
| 06:51:56.725941 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1) |
| 06:51:56.726129 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1) |
| 06:51:56.726542 |
trace |
system.CModule |
Loading "coupon" application component |
| 06:51:56.726696 |
trace |
system.db.ar.CActiveRecord |
Cart.findAll() |
| 06:51:56.726985 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache |
| 06:51:56.727351 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket_props"
from cache |
| 06:51:56.727622 |
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)) |
| 06:51:56.727628 |
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))) |
| 06:51:56.727889 |
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))) |
| 06:51:56.728133 |
trace |
system.CModule |
Loading "assetManager" application component |
| 06:51:56.728390 |
trace |
system.db.ar.CActiveRecord |
DeliveryCalcMain.find() |
| 06:51:56.728576 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache |
| 06:51:56.728616 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1 |
| 06:51:56.728620 |
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) |
| 06:51:56.728810 |
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) |
| 06:51:56.729751 |
trace |
system.CModule |
Loading "redisCache" application component |
| 06:51:56.730674 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 06:51:56.730938 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 06:51:56.731089 |
profile |
application |
begin:loading session |
| 06:51:56.731091 |
profile |
application |
end:loading session |
| 06:51:56.732785 |
trace |
system.CModule |
Loading "order" application component |
| 06:51:56.733004 |
trace |
system.db.ar.CActiveRecord |
Good.find() |
| 06:51:56.733233 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache |
| 06:51:56.733532 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache |
| 06:51:56.733592 |
trace |
system.CModule |
Loading "ICatalog" application component |
| 06:51:56.733741 |
trace |
system.caching.CMemCache |
Serving "b_catalog_group1" from cache |
| 06:51:56.733892 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_catalog_price"
from cache |
| 06:51:56.734194 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache |
| 06:51:56.734352 |
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` FROM `b_iblock_element` `t` WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE)) |
| 06:51:56.734354 |
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` FROM `b_iblock_element` `t` WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE))) |
| 06:51:56.735061 |
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` FROM `b_iblock_element` `t` WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE))) |
| 06:51:56.735219 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON
(`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) WHERE (`t`.`ID`=222415211) |
| 06:51:56.735222 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`,
`mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`,
`mp`.`DESCRIPTION` AS `t1_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
WHERE (`t`.`ID`=222415211)) |
| 06:51:56.737735 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `mp`.`ID` AS
`t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS
`t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`,
`mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`,
`mp`.`DESCRIPTION` AS `t1_c7` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
WHERE (`t`.`ID`=222415211)) |
| 06:51:56.743196 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS `t2_c0`,
`pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`,
`pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`,
`pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`,
`pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`,
`pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND
(pr.CATALOG_GROUP_ID IN (2,1)) WHERE (`t`.`ID`=222415211) |
| 06:51:56.743200 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS
`t2_c0`, `pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`,
`pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`,
`pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`,
`pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`,
`pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND
(pr.CATALOG_GROUP_ID IN (2,1)) WHERE (`t`.`ID`=222415211)) |
| 06:51:56.743678 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `pr`.`ID` AS
`t2_c0`, `pr`.`PRODUCT_ID` AS `t2_c1`, `pr`.`EXTRA_ID` AS `t2_c2`,
`pr`.`CATALOG_GROUP_ID` AS `t2_c3`, `pr`.`PRICE` AS `t2_c4`,
`pr`.`CURRENCY` AS `t2_c5`, `pr`.`TIMESTAMP_X` AS `t2_c6`,
`pr`.`QUANTITY_FROM` AS `t2_c7`, `pr`.`QUANTITY_TO` AS `t2_c8`,
`pr`.`TMP_ID` AS `t2_c9` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_catalog_price` `pr` ON (`pr`.`PRODUCT_ID`=`t`.`ID`) AND
(pr.CATALOG_GROUP_ID IN (2,1)) WHERE (`t`.`ID`=222415211)) |
| 06:51:56.743959 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_certs2catalog"
from cache |
| 06:51:56.744003 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS `t3_c0`,
`cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`,
`cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`,
`cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`,
`cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO`
AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`,
`cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`,
`cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`,
`cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`,
`cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`,
`cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`,
`cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`,
`cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`,
`cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS
`t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`,
`cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON
(`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr`
ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88) WHERE
(`t`.`ID`=222415211) |
| 06:51:56.744005 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS
`t3_c0`, `cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`,
`cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`,
`cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`,
`cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO`
AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`,
`cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`,
`cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`,
`cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`,
`cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`,
`cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`,
`cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`,
`cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`,
`cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS
`t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`,
`cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON
(`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr`
ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88) WHERE
(`t`.`ID`=222415211)) |
| 06:51:56.744606 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `cr`.`ID` AS
`t3_c0`, `cr`.`TIMESTAMP_X` AS `t3_c1`, `cr`.`MODIFIED_BY` AS `t3_c2`,
`cr`.`DATE_CREATE` AS `t3_c3`, `cr`.`CREATED_BY` AS `t3_c4`,
`cr`.`IBLOCK_ID` AS `t3_c5`, `cr`.`IBLOCK_SECTION_ID` AS `t3_c6`,
`cr`.`ACTIVE` AS `t3_c7`, `cr`.`ACTIVE_FROM` AS `t3_c8`, `cr`.`ACTIVE_TO`
AS `t3_c9`, `cr`.`SORT` AS `t3_c10`, `cr`.`NAME` AS `t3_c11`,
`cr`.`PREVIEW_PICTURE` AS `t3_c12`, `cr`.`PREVIEW_TEXT` AS `t3_c13`,
`cr`.`PREVIEW_TEXT_TYPE` AS `t3_c14`, `cr`.`DETAIL_PICTURE` AS `t3_c15`,
`cr`.`DETAIL_TEXT` AS `t3_c16`, `cr`.`DETAIL_TEXT_TYPE` AS `t3_c17`,
`cr`.`SEARCHABLE_CONTENT` AS `t3_c18`, `cr`.`WF_STATUS_ID` AS `t3_c19`,
`cr`.`WF_PARENT_ELEMENT_ID` AS `t3_c20`, `cr`.`WF_NEW` AS `t3_c21`,
`cr`.`WF_LOCKED_BY` AS `t3_c22`, `cr`.`WF_DATE_LOCK` AS `t3_c23`,
`cr`.`WF_COMMENTS` AS `t3_c24`, `cr`.`IN_SECTIONS` AS `t3_c25`,
`cr`.`XML_ID` AS `t3_c26`, `cr`.`CODE` AS `t3_c27`, `cr`.`TAGS` AS
`t3_c28`, `cr`.`TMP_ID` AS `t3_c29`, `cr`.`WF_LAST_HISTORY_ID` AS `t3_c30`,
`cr`.`SHOW_COUNTER` AS `t3_c31`, `cr`.`SHOW_COUNTER_START` AS `t3_c32` FROM
`b_iblock_element` `t` LEFT OUTER JOIN `sp_certs2catalog` `certs_cr` ON
(`t`.`ID`=`certs_cr`.`catalog_id`) LEFT OUTER JOIN `b_iblock_element` `cr`
ON (`cr`.`ID`=`certs_cr`.`cert_id`) AND (cr.IBLOCK_ID = 88) WHERE
(`t`.`ID`=222415211)) |
| 06:51:56.744909 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache |
| 06:51:56.744960 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS `t4_c0`,
`uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`, `uf`.`date_create`
AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status` AS `t4_c5`,
`uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`, `uf`.`review_id` AS
`t4_c8`, `uf`.`file_path` AS `t4_c9`, `uf`.`file_path_small` AS `t4_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 (status IN (:ycp0, :ycp1)) WHERE (`t`.`ID`=222415211) ORDER BY sorter |
| 06:51:56.744962 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t4_c0`, `uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`,
`uf`.`date_create` AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status`
AS `t4_c5`, `uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`,
`uf`.`review_id` AS `t4_c8`, `uf`.`file_path` AS `t4_c9`,
`uf`.`file_path_small` AS `t4_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 (status IN (:ycp0, :ycp1)) WHERE (`t`.`ID`=222415211) ORDER BY sorter) |
| 06:51:56.745429 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `uf`.`id` AS
`t4_c0`, `uf`.`good_code` AS `t4_c1`, `uf`.`user_id` AS `t4_c2`,
`uf`.`date_create` AS `t4_c3`, `uf`.`date_update` AS `t4_c4`, `uf`.`status`
AS `t4_c5`, `uf`.`sorter` AS `t4_c6`, `uf`.`comment` AS `t4_c7`,
`uf`.`review_id` AS `t4_c8`, `uf`.`file_path` AS `t4_c9`,
`uf`.`file_path_small` AS `t4_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 (status IN (:ycp0, :ycp1)) WHERE (`t`.`ID`=222415211) ORDER BY sorter) |
| 06:51:56.746157 |
trace |
system.CModule |
Loading "IPropeties" application component |
| 06:51:56.749537 |
trace |
system.caching.CMemCache |
Serving "iblock_properties_0" from cache |
| 06:51:56.750715 |
trace |
system.CModule |
Loading "warehouse" application component |
| 06:51:56.750993 |
trace |
system.caching.CMemCache |
Serving "IWarehouseIWarehouse::getStaticList" from cache |
| 06:51:56.751238 |
trace |
system.caching.CMemCache |
Serving "IWarehouse1" from cache |
| 06:51:56.751621 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.msections |
| 06:51:56.751837 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache |
| 06:51:56.751929 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `ms`.`ELEMENT_ID` AS `t1_c0`, `ms`.`SECTION_ID` AS
`t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS `t1_c3` FROM
`sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0) |
| 06:51:56.751931 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0)) |
| 06:51:56.752305 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0)) |
| 06:51:56.752547 |
trace |
system.CModule |
Loading "GoodSections" application component |
| 06:51:56.752630 |
trace |
system.CModule |
Loading "fcache" application component |
| 06:51:56.763133 |
trace |
system.caching.CFileCache |
Serving "good_sections_tree5" from cache |
| 06:51:56.763374 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache |
| 06:51:56.763717 |
trace |
system.db.ar.CActiveRecord |
TPSupToTer.findAll() |
| 06:51:56.763725 |
trace |
system.CModule |
Loading "dbTP" application component |
| 06:51:56.763746 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 06:51:56.764851 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache |
| 06:51:56.765093 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache |
| 06:51:56.765264 |
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) |
| 06:51:56.794744 |
trace |
system.db.ar.CActiveRecord |
TPAllPrices.findAll() |
| 06:51:56.795026 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}"
from cache |
| 06:51:56.795367 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}"
from cache |
| 06:51:56.795942 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`sup_id` AS `t0_c1`,
`t`.`art_search` AS `t0_c2`, `t`.`art_replace` AS `t0_c3`, `t`.`brand_id`
AS `t0_c4`, `t`.`brand_art` AS `t0_c5`, `t`.`brand_name` AS `t0_c6`,
`t`.`name` AS `t0_c7`, `t`.`name_ext` AS `t0_c8`, `t`.`quantity` AS
`t0_c9`, `t`.`quantity_min` AS `t0_c10`, `t`.`quantity_expectation` AS
`t0_c11`, `t`.`quantity_expectation_min` AS `t0_c12`, `t`.`price_id` AS
`t0_c13`, `t`.`price` AS `t0_c14`, `t`.`price_purchase` AS `t0_c15`,
`t`.`price_retail` AS `t0_c16`, `t`.`delivery_date` AS `t0_c17`,
`t`.`package_type` AS `t0_c18`, `t`.`weight` AS `t0_c19`, `t`.`weight_id`
AS `t0_c20`, `t`.`sup_code` AS `t0_c21`, `t`.`date_added` AS `t0_c22`,
`t`.`art_supplier` AS `t0_c23`, `t`.`is_im_visible` AS `t0_c24`,
`t`.`price_rr` AS `t0_c25`, `supplier`.`id` AS `t1_c0`,
`supplier`.`legal_name` AS `t1_c1`, `supplier`.`name` AS `t1_c2`,
`supplier`.`address` AS `t1_c3`, `supplier`.`contact` AS `t1_c4`,
`supplier`.`is_load_price` AS `t1_c5`, `supplier`.`load_price_params` AS
`t1_c6`, `supplier`.`srok` AS `t1_c7`, `supplier`.`nacenka` AS `t1_c8`,
`supplier`.`is_ext_price` AS `t1_c9`, `supplier`.`ext_price_model` AS
`t1_c10`, `supplier`.`tmp_table_name` AS `t1_c11`,
`supplier`.`date_updated` AS `t1_c12`, `supplier`.`type` AS `t1_c13`,
`supplier`.`cfo` AS `t1_c14`, `supplier`.`adjective_field` AS `t1_c15`,
`supplier`.`adjective_value` AS `t1_c16`,
`supplier`.`adjective_price_field` AS `t1_c17`, `supplier`.`warehouses` AS
`t1_c18`, `supplier`.`use_for_replacement` AS `t1_c19`,
`supplier`.`lf_code` AS `t1_c20`, `supplier`.`purchase_channel` AS
`t1_c21`, `supplier`.`is_purchase_auto` AS `t1_c22`,
`supplier`.`api_auth_params` AS `t1_c23`, `supplier`.`comment` AS `t1_c24`,
`supplier`.`min_order_price` AS `t1_c25`, `supplier`.`is_official` AS
`t1_c26`, `supplier`.`is_by_codes` AS `t1_c27`,
`supplier`.`is_order_without_tp` AS `t1_c28`, `supplier`.`order_email` AS
`t1_c29`, `supplier`.`margin_type_id` AS `t1_c30`, `supplier`.`is_checkall`
AS `t1_c31`, `supplier`.`margin_id` AS `t1_c32`, `supplier`.`grid_id` AS
`t1_c33`, `supplier`.`quantity_min_restriction` AS `t1_c34`,
`supplier`.`encrypt_name` AS `t1_c35`,
`supplier`.`additional_adjective_field` AS `t1_c36`,
`supplier`.`additional_adjective_value` AS `t1_c37`,
`supplier`.`additional_adjective_price_field` AS `t1_c38`,
`supplier`.`auto_update` AS `t1_c39`, `supplier`.`is_price_rr_use` AS
`t1_c40`, `supplier`.`is_price_rr_less_deny` AS `t1_c41`,
`supplier`.`is_price_rr_greater_deny` AS `t1_c42`,
`supplier`.`is_manual_price` AS `t1_c43`, `supplier`.`margin_type` AS
`t1_c44`, `supplier`.`is_factory` AS `t1_c45`, `supplier`.`owner_id` AS
`t1_c46`, `supplier`.`response_time` AS `t1_c47`,
`supplier`.`days_to_return` AS `t1_c48`, `supplier`.`is_not_update` AS
`t1_c49`, `supplier`.`unique_delivery` AS `t1_c50`,
`supplier`.`is_fast_update` AS `t1_c51`, `supplier`.`update_version` AS
`t1_c52` FROM `tbl_allprices` `t` LEFT OUTER JOIN `tbl_supplier`
`supplier` ON (`t`.`sup_id`=`supplier`.`id`) WHERE (((((t.is_im_visible =
1) AND (t.sup_id IN (: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, :ycp30, :ycp31, :ycp32, :ycp33, :ycp34, :ycp35,
:ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41, :ycp42, :ycp43, :ycp44,
:ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50, :ycp51, :ycp52, :ycp53,
:ycp54, :ycp55, :ycp56, :ycp57, :ycp58, :ycp59, :ycp60, :ycp61, :ycp62,
:ycp63, :ycp64, :ycp65, :ycp66, :ycp67, :ycp68, :ycp69, :ycp70, :ycp71,
:ycp72, :ycp73, :ycp74, :ycp75, :ycp76, :ycp77, :ycp78, :ycp79, :ycp80,
:ycp81, :ycp82, :ycp83, :ycp84, :ycp85, :ycp86, :ycp87, :ycp88, :ycp89,
:ycp90, :ycp91, :ycp92, :ycp93, :ycp94, :ycp95, :ycp96, :ycp97, :ycp98,
:ycp99, :ycp100, :ycp101, :ycp102, :ycp103, :ycp104, :ycp105, :ycp106,
:ycp107, :ycp108, :ycp109, :ycp110, :ycp111, :ycp112, :ycp113, :ycp114,
:ycp115, :ycp116, :ycp117, :ycp118, :ycp119, :ycp120, :ycp121, :ycp122,
:ycp123, :ycp124, :ycp125, :ycp126, :ycp127, :ycp128, :ycp129, :ycp130,
:ycp131, :ycp132, :ycp133, :ycp134, :ycp135, :ycp136, :ycp137, :ycp138,
:ycp139, :ycp140, :ycp141, :ycp142, :ycp143, :ycp144, :ycp145))) AND
(t.sup_code=:ycp146)) AND (supplier.is_by_codes = 1)) AND (t.date_added >
:date_added)) |
| 06:51:56.799304 |
trace |
system.CModule |
Loading "clientScript" application component |
| 06:51:56.800942 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.groups |
| 06:51:56.801147 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `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_section`
`gr` INNER JOIN `sp_catalog2msections` `groups_gr` ON
(`groups_gr`.`ELEMENT_ID`=:ypl0) AND (`gr`.`ID`=`groups_gr`.`SECTION_ID`)
AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") ORDER BY gr.LEFT_MARGIN,
gr.DEPTH_LEVEL |
| 06:51:56.801151 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `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_section` `gr` INNER JOIN `sp_catalog2msections`
`groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND
(`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE =
"Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL) |
| 06:51:56.802232 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `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_section` `gr` INNER JOIN `sp_catalog2msections`
`groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND
(`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE =
"Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL) |
| 06:51:56.802474 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.I_PREVIEW_PICTURE |
| 06:51:56.802676 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache |
| 06:51:56.802763 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `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_file` `pp` WHERE
(`pp`.`ID`=:ypl0) |
| 06:51:56.802767 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `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_file` `pp` WHERE (`pp`.`ID`=:ypl0)) |
| 06:51:56.803098 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `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_file` `pp` WHERE (`pp`.`ID`=:ypl0)) |
| 06:51:56.803651 |
trace |
system.base.CModule |
Loading "acat" module |
| 06:51:56.803970 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
|
| 06:51:56.803972 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 06:51:56.804194 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 06:51:56.804250 |
trace |
system.db.CDbCommand |
Querying SQL:
SELECT
`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`
FROM
`marks`,
`s_marks`
WHERE
`s_marks`.`idsite` = 3 AND
`marks`.`ID` = `s_marks`.`idmark`
ORDER BY
3
|
| 06:51:56.804251 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(
SELECT
`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`
FROM
`marks`,
`s_marks`
WHERE
`s_marks`.`idsite` = 3 AND
`marks`.`ID` = `s_marks`.`idmark`
ORDER BY
3
) |
| 06:51:56.804795 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(
SELECT
`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`
FROM
`marks`,
`s_marks`
WHERE
`s_marks`.`idsite` = 3 AND
`marks`.`ID` = `s_marks`.`idmark`
ORDER BY
3
) |
| 06:51:56.806457 |
trace |
system.db.CDbCommand |
Querying SQL:
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`PATHICON` AS `ICO`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
|
| 06:51:56.806463 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`PATHICON` AS `ICO`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 06:51:56.807132 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`PATHICON` AS `ICO`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 06:51:56.807168 |
trace |
system.db.CDbCommand |
Querying SQL:
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`,
s.G0ID,
s.G0NAME,
s.G1NAME,
s.SMALLPICTUREINDEX,
s.PPID AS ID,
s.NAME AS NAME
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000 |
| 06:51:56.807171 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`,
s.G0ID,
s.G0NAME,
s.G1NAME,
s.SMALLPICTUREINDEX,
s.PPID AS ID,
s.NAME AS NAME
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 06:51:56.807804 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(
SELECT
t.id AS `AUTO_TYPE_ID`,
t.`name` AS `AUTO_TYPE_NAME`,
mo.`NAMESHORT` AS `AUTO_MODEL_NAME`,
mo.`ID` AS `AUTO_MODEL_ID`,
ma.`ID` AS `AUTO_MARK_ID`,
ma.`NAMESHORT` AS `AUTO_MARK_NAME`,
s.G0ID,
s.G0NAME,
s.G1NAME,
s.SMALLPICTUREINDEX,
s.PPID AS ID,
s.NAME AS NAME
FROM
`sp_acat2catalog`
INNER JOIN `search` s ON s.`PARTNAMEID` = `sp_acat2catalog`.`acat_id`
INNER JOIN typeauto t ON t.typeid = s.TYPEAUTO AND t.idsite = 3
INNER JOIN marks ma ON ma.ID = s.MARKID
INNER JOIN s_marks sma ON sma.idmark = s.MARKID AND sma.idsite = 3
INNER JOIN models mo ON mo.ID = s.MODELID
INNER JOIN s_models smo ON smo.idmodel = s.MODELID AND smo.idsite = 3
WHERE `sp_acat2catalog`.`catalog_id` = 222415211
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 06:51:56.807818 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.tags |
| 06:51:56.808265 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_tags2catalog"
from cache |
| 06:51:56.808315 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `tg`.`ID` AS `t1_c0`, `tg`.`TIMESTAMP_X` AS `t1_c1`,
`tg`.`MODIFIED_BY` AS `t1_c2`, `tg`.`DATE_CREATE` AS `t1_c3`,
`tg`.`CREATED_BY` AS `t1_c4`, `tg`.`IBLOCK_ID` AS `t1_c5`,
`tg`.`IBLOCK_SECTION_ID` AS `t1_c6`, `tg`.`ACTIVE` AS `t1_c7`,
`tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO` AS `t1_c9`, `tg`.`SORT` AS
`t1_c10`, `tg`.`NAME` AS `t1_c11`, `tg`.`PREVIEW_PICTURE` AS `t1_c12`,
`tg`.`PREVIEW_TEXT` AS `t1_c13`, `tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`,
`tg`.`DETAIL_PICTURE` AS `t1_c15`, `tg`.`DETAIL_TEXT` AS `t1_c16`,
`tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`, `tg`.`SEARCHABLE_CONTENT` AS `t1_c18`,
`tg`.`WF_STATUS_ID` AS `t1_c19`, `tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`,
`tg`.`WF_NEW` AS `t1_c21`, `tg`.`WF_LOCKED_BY` AS `t1_c22`,
`tg`.`WF_DATE_LOCK` AS `t1_c23`, `tg`.`WF_COMMENTS` AS `t1_c24`,
`tg`.`IN_SECTIONS` AS `t1_c25`, `tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS
`t1_c27`, `tg`.`TAGS` AS `t1_c28`, `tg`.`TMP_ID` AS `t1_c29`,
`tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `tg`.`SHOW_COUNTER` AS `t1_c31`,
`tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM `b_iblock_element` `tg` INNER
JOIN `sp_tags2catalog` `tags_tg` ON (`tags_tg`.`catalog_id`=:ypl0) AND
(`tg`.`ID`=`tags_tg`.`tag_id`) AND (tg.IBLOCK_ID = 50) |
| 06:51:56.808317 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`,
`tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`,
`tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`,
`tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO`
AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`,
`tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`,
`tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`,
`tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`,
`tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`,
`tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`,
`tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`,
`tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS
`t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`,
`tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `tg` INNER JOIN `sp_tags2catalog` `tags_tg` ON
(`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND
(tg.IBLOCK_ID = 50)) |
| 06:51:56.808932 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`,
`tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`,
`tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`,
`tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO`
AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`,
`tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`,
`tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`,
`tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`,
`tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`,
`tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`,
`tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`,
`tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS
`t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`,
`tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `tg` INNER JOIN `sp_tags2catalog` `tags_tg` ON
(`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND
(tg.IBLOCK_ID = 50)) |
| 06:51:56.809529 |
trace |
system.db.ar.CActiveRecord |
Articles.findAll() |
| 06:51:56.809778 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_m52"
from cache |
| 06:51:56.810091 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_s52"
from cache |
| 06:51:56.810384 |
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_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN
(9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND
mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW()))
ORDER BY ACTIVE_FROM DESC LIMIT 10 |
| 06:51:56.810395 |
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_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN
(9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND
mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW()))
ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 06:51:56.812896 |
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_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN
(9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND
mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW()))
ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 06:51:56.813242 |
trace |
system.db.ar.CActiveRecord |
News.findAll() |
| 06:51:56.813684 |
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_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
mp.VALUE IN (9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW()
AND (t.ACTIVE_TO IS NULL
OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10 |
| 06:51:56.813698 |
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_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
mp.VALUE IN (9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW()
AND (t.ACTIVE_TO IS NULL
OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 06:51:56.815231 |
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_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
mp.VALUE IN (9490889,9491652)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (527133)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW()
AND (t.ACTIVE_TO IS NULL
OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 06:51:56.815347 |
trace |
system.db.ar.CActiveRecord |
ReviewModel.findAll() |
| 06:51:56.815548 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reviews"
from cache |
| 06:51:56.815686 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`id`, `t`.`user_id`, `t`.`seo_url`, `t`.`type_id`,
`t`.`status_id`, `t`.`meta_title`, `t`.`meta_description`, `t`.`title`,
`t`.`preview`, `t`.`content`, `t`.`views`, `t`.`created_at`,
`t`.`updated_at`, `t`.`published_at`, `t`.`question`,
`t`.`state_change_reason` FROM `sp_reviews` `t` INNER JOIN
sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId)
AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10 |
| 06:51:56.815690 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`,
`t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`,
`t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`,
`t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`,
`t`.`question`, `t`.`state_change_reason` FROM `sp_reviews` `t` INNER JOIN
sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId)
AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10) |
| 06:51:56.816325 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`,
`t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`,
`t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`,
`t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`,
`t`.`question`, `t`.`state_change_reason` FROM `sp_reviews` `t` INNER JOIN
sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId)
AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10) |
| 06:51:56.816385 |
trace |
system.db.ar.CActiveRecord |
Question.count() |
| 06:51:56.816653 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_questions"
from cache |
| 06:51:56.816710 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT COUNT(*) FROM `sp_questions` `t` WHERE
(good_code=:good_code) AND (is_active = :is_active) |
| 06:51:56.816714 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t`
WHERE (good_code=:good_code) AND (is_active = :is_active)) |
| 06:51:56.817094 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t`
WHERE (good_code=:good_code) AND (is_active = :is_active)) |
| 06:51:56.817154 |
trace |
system.CModule |
Loading "Garage" application component |
| 06:51:56.817277 |
trace |
system.db.ar.CActiveRecord |
UserCar.findAll() |
| 06:51:56.817531 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_cars"
from cache |
| 06:51:56.817892 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_models"
from cache |
| 06:51:56.818202 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_types"
from cache |
| 06:51:56.818661 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS `t0_c1`,
`t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`, `t`.`model_id` AS
`t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS `t0_c6`,
`t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`, `t`.`reg_number`
AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS `t0_c11`, `t`.`year`
AS `t0_c12`, `t`.`date_create` AS `t0_c13`, `t`.`engine` AS `t0_c14`,
`t`.`chassis` AS `t0_c15`, `t`.`carrying` AS `t0_c16`, `t`.`body` AS
`t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id` AS `t0_c19`,
`t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS `t0_c21`,
`t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS `t0_c24`,
`t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS `t0_c27`,
`t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`,
`t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`,
`t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`,
`t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`,
`t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id`
AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`,
`catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`,
`catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS
`t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month`
AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`,
`catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort`
AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS
`t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`,
`catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS
`t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS
`t2_c6`, `catt`.`construct_from_month` AS `t2_c7`,
`catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS
`t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`,
`catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`,
`catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM
`sp_user_cars` `t` LEFT OUTER JOIN `cat_models` `catm` ON
(`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON
(`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active))
LIMIT 100 |
| 06:51:56.818667 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id`
AS `t0_c1`, `t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`,
`t`.`model_id` AS `t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS
`t0_c6`, `t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`,
`t`.`reg_number` AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS
`t0_c11`, `t`.`year` AS `t0_c12`, `t`.`date_create` AS `t0_c13`,
`t`.`engine` AS `t0_c14`, `t`.`chassis` AS `t0_c15`, `t`.`carrying` AS
`t0_c16`, `t`.`body` AS `t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id`
AS `t0_c19`, `t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS
`t0_c21`, `t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS
`t0_c24`, `t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS
`t0_c27`, `t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`,
`t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`,
`t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`,
`t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`,
`t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id`
AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`,
`catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`,
`catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS
`t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month`
AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`,
`catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort`
AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS
`t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`,
`catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS
`t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS
`t2_c6`, `catt`.`construct_from_month` AS `t2_c7`,
`catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS
`t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`,
`catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`,
`catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM
`sp_user_cars` `t` LEFT OUTER JOIN `cat_models` `catm` ON
(`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON
(`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active))
LIMIT 100) |
| 06:51:56.819034 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS
`t0_c1`, `t`.`car_type` AS `t0_c2`, `t`.`mark_id` AS `t0_c3`,
`t`.`model_id` AS `t0_c4`, `t`.`type_id` AS `t0_c5`, `t`.`mark_name` AS
`t0_c6`, `t`.`model_name` AS `t0_c7`, `t`.`type_name` AS `t0_c8`,
`t`.`reg_number` AS `t0_c9`, `t`.`comments` AS `t0_c10`, `t`.`vin` AS
`t0_c11`, `t`.`year` AS `t0_c12`, `t`.`date_create` AS `t0_c13`,
`t`.`engine` AS `t0_c14`, `t`.`chassis` AS `t0_c15`, `t`.`carrying` AS
`t0_c16`, `t`.`body` AS `t0_c17`, `t`.`active` AS `t0_c18`, `t`.`td_car_id`
AS `t0_c19`, `t`.`lx_catalog_id` AS `t0_c20`, `t`.`lx_vehicle_id` AS
`t0_c21`, `t`.`lx_ssd` AS `t0_c22`, `t`.`json` AS `t0_c23`, `t`.`xml_id` AS
`t0_c24`, `t`.`ac_id` AS `t0_c25`, `t`.`name` AS `t0_c26`, `t`.`area_id` AS
`t0_c27`, `t`.`unit_id` AS `t0_c28`, `t`.`engine_volume` AS `t0_c29`,
`t`.`engine_capacity` AS `t0_c30`, `t`.`gear_type` AS `t0_c31`,
`t`.`wheel_type` AS `t0_c32`, `t`.`wheel_number` AS `t0_c33`,
`t`.`garage_number` AS `t0_c34`, `t`.`for_report` AS `t0_c35`,
`t`.`catalog_calculate` AS `t0_c36`, `catm`.`id` AS `t1_c0`, `catm`.`td_id`
AS `t1_c1`, `catm`.`name` AS `t1_c2`, `catm`.`code` AS `t1_c3`,
`catm`.`manufacturer_id` AS `t1_c4`, `catm`.`photo_path` AS `t1_c5`,
`catm`.`construct_from_year` AS `t1_c6`, `catm`.`construct_from_month` AS
`t1_c7`, `catm`.`construct_to_year` AS `t1_c8`, `catm`.`construct_to_month`
AS `t1_c9`, `catm`.`is_actual` AS `t1_c10`, `catm`.`part` AS `t1_c11`,
`catm`.`is_visible` AS `t1_c12`, `catm`.`ac_id` AS `t1_c13`, `catm`.`sort`
AS `t1_c14`, `catm`.`name_normalize` AS `t1_c15`, `catm`.`car_type_id` AS
`t1_c16`, `catt`.`id` AS `t2_c0`, `catt`.`td_type` AS `t2_c1`,
`catt`.`td_id` AS `t2_c2`, `catt`.`code` AS `t2_c3`, `catt`.`name` AS
`t2_c4`, `catt`.`model_id` AS `t2_c5`, `catt`.`construct_from_year` AS
`t2_c6`, `catt`.`construct_from_month` AS `t2_c7`,
`catt`.`constuct_to_year` AS `t2_c8`, `catt`.`construct_to_month` AS
`t2_c9`, `catt`.`attrs` AS `t2_c10`, `catt`.`is_visible` AS `t2_c11`,
`catt`.`ac_id` AS `t2_c12`, `catt`.`engine_normalize` AS `t2_c13`,
`catt`.`name_normalize` AS `t2_c14`, `catt`.`car_type_id` AS `t2_c15` FROM
`sp_user_cars` `t` LEFT OUTER JOIN `cat_models` `catm` ON
(`t`.`model_id`=`catm`.`id`) LEFT OUTER JOIN `cat_types` `catt` ON
(`t`.`type_id`=`catt`.`id`) WHERE ((user_id=:user_id) AND (active=:active))
LIMIT 100) |
| 06:51:56.820229 |
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
("527133")) |
| 06:51:56.820233 |
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
("527133"))) |
| 06:51:56.820611 |
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
("527133"))) |
| 06:51:56.823394 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code |
| 06:51:56.823398 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code) |
| 06:51:56.825139 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code) |
| 06:51:56.825607 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 06:51:56.825609 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:51:56.825970 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:51:56.826000 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 06:51:56.826004 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:51:56.826328 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:51:56.826356 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 06:51:56.826359 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:51:56.826683 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:51:56.826710 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 06:51:56.826713 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:51:56.826899 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:51:56.826930 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 06:51:56.826934 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:51:56.827132 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:51:56.827157 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 06:51:56.827159 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:51:56.827337 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:51:56.827361 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 06:51:56.827363 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:51:56.827541 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:51:56.827565 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 06:51:56.827569 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:51:56.827749 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:51:56.827780 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 06:51:56.827781 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:51:56.827958 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:51:56.827981 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 06:51:56.827984 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:51:56.828156 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:51:56.828181 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 06:51:56.828182 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:51:56.828360 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:51:56.828915 |
trace |
system.CModule |
Loading "db_lf" application component |
| 06:51:56.828939 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 06:51:56.841392 |
profile |
yii3.db |
begin:SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN
`sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code =
'527133' GROUP BY `ce`.`external_id` |
| 06:51:56.841427 |
profile |
yii3.db |
begin:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 06:51:56.842418 |
profile |
yii3.db |
end:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 06:51:56.843014 |
profile |
yii3.db |
end:SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products`
`cep` ON cep.cert_id = ce.id WHERE cep.product_code = '527133' GROUP BY
`ce`.`external_id` |
| 06:51:56.843240 |
profile |
yii3.db |
begin:SELECT `ce`.`id`, `ce`.`external_id`, `cef`.`file`,
`cep`.`product_code` FROM `sp_certs2` `ce` LEFT JOIN `sp_certs2_files`
`cef` ON cef.cert_id = ce.id LEFT JOIN `sp_certs2_products` `cep` ON
cep.cert_id = ce.id WHERE ce.id = '15447' GROUP BY `cef`.`id`, `cep`.`id` |