|
Общий отчет
(Время: 0.88184с,
Память: 126,123Кб)
|
| Процедура |
Номер |
Всего (с) |
Средн. (с) |
Мин. (с) |
Макс. (с) |
| 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`=229822014)) |
1 |
0.00255 |
0.00255 |
0.00255 |
0.00255 |
| loading session |
2 |
0.00070 |
0.00035 |
0.00000 |
0.00069 |
| 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.00076 |
0.00076 |
0.00076 |
0.00076 |
| 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`=229822014)) |
1 |
0.00064 |
0.00064 |
0.00064 |
0.00064 |
| 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`=229822014)) |
1 |
0.00058 |
0.00058 |
0.00058 |
0.00058 |
| 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.00028 |
0.00028 |
0.00028 |
0.00028 |
| system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1) |
1 |
0.00024 |
0.00024 |
0.00024 |
0.00024 |
| system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) |
1 |
0.00022 |
0.00022 |
0.00022 |
0.00022 |
| system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) |
1 |
0.00019 |
0.00019 |
0.00019 |
0.00019 |
| 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 `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`=229822014) ORDER BY sorter) |
1 |
0.00050 |
0.00050 |
0.00050 |
0.00050 |
| 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.00070 |
0.00070 |
0.00070 |
0.00070 |
| 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.00103 |
0.00103 |
0.00103 |
0.00103 |
| 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_CODE AND mp.VALUE IN (321109)))) 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.00103 |
0.00103 |
0.00103 |
0.00103 |
| 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.00061 |
0.00061 |
0.00061 |
0.00061 |
| 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` = 229822014
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
1 |
0.00058 |
0.00058 |
0.00058 |
0.00058 |
| 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_CODE AND mp.VALUE IN (321109)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) |
1 |
0.00114 |
0.00114 |
0.00114 |
0.00114 |
| 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` = 229822014
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
1 |
0.00057 |
0.00057 |
0.00057 |
0.00057 |
| 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.00053 |
0.00053 |
0.00053 |
0.00053 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t` WHERE (good_code=:good_code) AND (is_active = :is_active)) |
1 |
0.00035 |
0.00035 |
0.00035 |
0.00035 |
| 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.00031 |
0.00031 |
0.00031 |
0.00031 |
| 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.00021 |
0.00021 |
0.00021 |
0.00021 |
| SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code = '321109' GROUP BY `ce`.`external_id` |
1 |
0.00139 |
0.00139 |
0.00139 |
0.00139 |
| 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 `code`
FROM `morph_nouns`
WHERE word = :word) |
3 |
0.00071 |
0.00024 |
0.00017 |
0.00034 |
| 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 ("321109"))) |
1 |
0.00033 |
0.00033 |
0.00033 |
0.00033 |
| 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.00043 |
0.00043 |
0.00043 |
0.00043 |
| 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.00034 |
0.00034 |
0.00034 |
0.00034 |
| system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
3 |
0.00070 |
0.00023 |
0.00018 |
0.00034 |
| system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
1 |
0.00023 |
0.00023 |
0.00023 |
0.00023 |
| system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
2 |
0.00050 |
0.00025 |
0.00019 |
0.00032 |
| Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
1 |
0.00086 |
0.00086 |
0.00086 |
0.00086 |
| 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.00059 |
0.00059 |
0.00059 |
0.00059 |
| 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.73783 |
0.73783 |
0.73783 |
0.73783 |
| system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
1 |
0.00022 |
0.00022 |
0.00022 |
0.00022 |
|
Журнал приложения
|
| Время |
Уровень |
Категория |
Сообщение |
| 15:00:38.972913 |
trace |
system.CModule |
Loading "log" application component |
| 15:00:38.975716 |
trace |
glitchtip_fallback |
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed. |
| 15:00:38.975907 |
trace |
system.CModule |
Loading "db" application component |
| 15:00:38.975961 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 15:00:38.976954 |
trace |
system.db.CDbCommand |
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1 |
| 15:00:38.976959 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 15:00:38.977179 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 15:00:38.977289 |
trace |
system.CModule |
Loading "urlHelper" application component |
| 15:00:38.977375 |
trace |
system.CModule |
Loading "DBConfig" application component |
| 15:00:38.977400 |
trace |
system.CModule |
Loading "cache" application component |
| 15:00:38.978315 |
trace |
system.caching.CMemCache |
Serving "66307959e0460a2e2436b0319b2fda14" from cache |
| 15:00:38.978569 |
trace |
system.CModule |
Loading "geo" application component |
| 15:00:38.978622 |
trace |
system.CModule |
Loading "request" application component |
| 15:00:38.979063 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache |
| 15:00:38.979098 |
trace |
system.db.ar.CActiveRecord |
Location.findByPk() |
| 15:00:38.979410 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache |
| 15:00:38.979629 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache |
| 15:00:38.979772 |
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 |
| 15:00:38.979775 |
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) |
| 15:00:38.979985 |
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) |
| 15:00:38.980133 |
trace |
system.CModule |
Loading "user" application component |
| 15:00:38.980242 |
profile |
application |
begin:loading session |
| 15:00:38.980246 |
trace |
system.CModule |
Loading "session" application component |
| 15:00:38.980937 |
profile |
application |
end:loading session |
| 15:00:38.981270 |
trace |
system.db.ar.CActiveRecord |
OutLocation.findByPk() |
| 15:00:38.981442 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache |
| 15:00:38.981499 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1 |
| 15:00:38.981502 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1) |
| 15:00:38.981693 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1) |
| 15:00:38.981758 |
trace |
system.CModule |
Loading "B2BConfig" application component |
| 15:00:38.981810 |
trace |
system.CModule |
Loading "urlManager" application component |
| 15:00:38.982721 |
trace |
system.caching.CMemCache |
Serving "Yii.CUrlManager.rules" from cache |
| 15:00:38.983139 |
trace |
system.CModule |
Loading "themeInterlayer" application component |
| 15:00:38.983802 |
trace |
system.CModule |
Loading "themeManager" application component |
| 15:00:38.983936 |
trace |
system.CModule |
Loading "clientScript" application component |
| 15:00:38.986295 |
trace |
system.web.filters.CFilterChain |
Running filter DBReadUncomitedLevelFilter.filter() |
| 15:00:38.986308 |
trace |
system.db.CDbCommand |
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; |
| 15:00:38.986310 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 15:00:38.986529 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 15:00:38.986560 |
trace |
system.CModule |
Loading "cart" application component |
| 15:00:38.986670 |
trace |
system.db.ar.CActiveRecord |
CartUser.find() |
| 15:00:38.986820 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache |
| 15:00:38.986854 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1 |
| 15:00:38.986855 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1) |
| 15:00:38.987093 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
ID=:ID LIMIT 1) |
| 15:00:38.987377 |
trace |
system.CModule |
Loading "coupon" application component |
| 15:00:38.987481 |
trace |
system.db.ar.CActiveRecord |
Cart.findAll() |
| 15:00:38.987704 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket"
from cache |
| 15:00:38.987982 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_basket_props"
from cache |
| 15:00:38.988115 |
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)) |
| 15:00:38.988117 |
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))) |
| 15:00:38.988398 |
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))) |
| 15:00:38.988588 |
trace |
system.CModule |
Loading "assetManager" application component |
| 15:00:38.988800 |
trace |
system.db.ar.CActiveRecord |
DeliveryCalcMain.find() |
| 15:00:38.988975 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache |
| 15:00:38.989008 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1 |
| 15:00:38.989012 |
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) |
| 15:00:38.989202 |
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) |
| 15:00:38.990350 |
trace |
system.CModule |
Loading "redisCache" application component |
| 15:00:38.991074 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 15:00:38.991291 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 15:00:38.991419 |
profile |
application |
begin:loading session |
| 15:00:38.991421 |
profile |
application |
end:loading session |
| 15:00:38.992891 |
trace |
system.CModule |
Loading "order" application component |
| 15:00:38.993114 |
trace |
system.db.ar.CActiveRecord |
Good.find() |
| 15:00:38.993340 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache |
| 15:00:38.993633 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache |
| 15:00:38.993701 |
trace |
system.CModule |
Loading "ICatalog" application component |
| 15:00:38.993870 |
trace |
system.caching.CMemCache |
Serving "b_catalog_group1" from cache |
| 15:00:38.994059 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_catalog_price"
from cache |
| 15:00:38.994529 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache |
| 15:00:38.994909 |
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)) |
| 15:00:38.994911 |
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))) |
| 15:00:38.995675 |
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))) |
| 15:00:38.995804 |
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`=229822014) |
| 15:00:38.995805 |
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`=229822014)) |
| 15:00:38.998357 |
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`=229822014)) |
| 15:00:39.005433 |
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`=229822014) |
| 15:00:39.005436 |
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`=229822014)) |
| 15:00:39.006011 |
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`=229822014)) |
| 15:00:39.006375 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_certs2catalog"
from cache |
| 15:00:39.006438 |
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`=229822014) |
| 15:00:39.006442 |
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`=229822014)) |
| 15:00:39.007078 |
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`=229822014)) |
| 15:00:39.007350 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache |
| 15:00:39.007397 |
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`=229822014) ORDER BY sorter |
| 15:00:39.007400 |
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`=229822014) ORDER BY sorter) |
| 15:00:39.007896 |
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`=229822014) ORDER BY sorter) |
| 15:00:39.008611 |
trace |
system.CModule |
Loading "IPropeties" application component |
| 15:00:39.013020 |
trace |
system.caching.CMemCache |
Serving "iblock_properties_0" from cache |
| 15:00:39.014444 |
trace |
system.CModule |
Loading "warehouse" application component |
| 15:00:39.014847 |
trace |
system.caching.CMemCache |
Serving "IWarehouseIWarehouse::getStaticList" from cache |
| 15:00:39.015121 |
trace |
system.caching.CMemCache |
Serving "IWarehouse1" from cache |
| 15:00:39.015500 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.msections |
| 15:00:39.015780 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache |
| 15:00:39.015902 |
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) |
| 15:00:39.015908 |
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)) |
| 15:00:39.016611 |
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)) |
| 15:00:39.016880 |
trace |
system.CModule |
Loading "GoodSections" application component |
| 15:00:39.016961 |
trace |
system.CModule |
Loading "fcache" application component |
| 15:00:39.030719 |
trace |
system.caching.CFileCache |
Serving "good_sections_tree5" from cache |
| 15:00:39.031017 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache |
| 15:00:39.031436 |
trace |
system.db.ar.CActiveRecord |
TPSupToTer.findAll() |
| 15:00:39.031446 |
trace |
system.CModule |
Loading "dbTP" application component |
| 15:00:39.031472 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 15:00:39.032948 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache |
| 15:00:39.033229 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache |
| 15:00:39.033446 |
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) |
| 15:00:39.069595 |
trace |
system.db.ar.CActiveRecord |
TPAllPrices.findAll() |
| 15:00:39.070044 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}"
from cache |
| 15:00:39.070417 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}"
from cache |
| 15:00:39.070944 |
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)) |
| 15:00:39.074300 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.groups |
| 15:00:39.074640 |
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 |
| 15:00:39.074647 |
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) |
| 15:00:39.075680 |
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) |
| 15:00:39.075886 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.I_PREVIEW_PICTURE |
| 15:00:39.076215 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache |
| 15:00:39.076311 |
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) |
| 15:00:39.076313 |
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)) |
| 15:00:39.076653 |
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)) |
| 15:00:39.076931 |
trace |
system.base.CModule |
Loading "acat" module |
| 15:00:39.077229 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
|
| 15:00:39.077233 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 15:00:39.077467 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 15:00:39.077527 |
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
|
| 15:00:39.077531 |
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
) |
| 15:00:39.078119 |
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
) |
| 15:00:39.080130 |
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` = 229822014
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
|
| 15:00:39.080137 |
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` = 229822014
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 15:00:39.080714 |
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` = 229822014
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 15:00:39.080744 |
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` = 229822014
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000 |
| 15:00:39.080746 |
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` = 229822014
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 15:00:39.081316 |
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` = 229822014
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 15:00:39.081341 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.tags |
| 15:00:39.081825 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_tags2catalog"
from cache |
| 15:00:39.081871 |
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) |
| 15:00:39.081875 |
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)) |
| 15:00:39.082406 |
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)) |
| 15:00:39.083081 |
trace |
system.db.ar.CActiveRecord |
Articles.findAll() |
| 15:00:39.083456 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_m52"
from cache |
| 15:00:39.083697 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_s52"
from cache |
| 15:00:39.084038 |
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_CODE AND mp.VALUE IN
(321109)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10 |
| 15:00:39.084041 |
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_CODE AND mp.VALUE IN
(321109)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10) |
| 15:00:39.085180 |
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_CODE AND mp.VALUE IN
(321109)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10) |
| 15:00:39.085695 |
trace |
system.db.ar.CActiveRecord |
News.findAll() |
| 15:00:39.086061 |
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_CODE
AND mp.VALUE IN (321109)))) 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 |
| 15:00:39.086066 |
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_CODE
AND mp.VALUE IN (321109)))) 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) |
| 15:00:39.087100 |
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_CODE
AND mp.VALUE IN (321109)))) 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) |
| 15:00:39.087218 |
trace |
system.db.ar.CActiveRecord |
ReviewModel.findAll() |
| 15:00:39.087423 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reviews"
from cache |
| 15:00:39.087604 |
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 |
| 15:00:39.087610 |
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) |
| 15:00:39.088221 |
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) |
| 15:00:39.088288 |
trace |
system.db.ar.CActiveRecord |
Question.count() |
| 15:00:39.088471 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_questions"
from cache |
| 15:00:39.088547 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT COUNT(*) FROM `sp_questions` `t` WHERE
(good_code=:good_code) AND (is_active = :is_active) |
| 15:00:39.088551 |
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)) |
| 15:00:39.088897 |
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)) |
| 15:00:39.088953 |
trace |
system.CModule |
Loading "Garage" application component |
| 15:00:39.089096 |
trace |
system.db.ar.CActiveRecord |
UserCar.findAll() |
| 15:00:39.089323 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_cars"
from cache |
| 15:00:39.089557 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_models"
from cache |
| 15:00:39.089803 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:cat_types"
from cache |
| 15:00:39.090045 |
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 |
| 15:00:39.090049 |
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) |
| 15:00:39.090359 |
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) |
| 15:00:39.091198 |
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
("321109")) |
| 15:00:39.091202 |
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
("321109"))) |
| 15:00:39.091532 |
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
("321109"))) |
| 15:00:39.093491 |
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 |
| 15:00:39.093493 |
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) |
| 15:00:39.093928 |
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) |
| 15:00:39.094468 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 15:00:39.094470 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 15:00:39.094826 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 15:00:39.094860 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 15:00:39.094861 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 15:00:39.095206 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 15:00:39.095251 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 15:00:39.095254 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 15:00:39.095590 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 15:00:39.095623 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 15:00:39.095624 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 15:00:39.095941 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 15:00:39.095979 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 15:00:39.095983 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 15:00:39.096185 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 15:00:39.096225 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 15:00:39.096229 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 15:00:39.096421 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 15:00:39.096455 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 15:00:39.096458 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 15:00:39.096641 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 15:00:39.096677 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 15:00:39.096682 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 15:00:39.096870 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 15:00:39.096905 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 15:00:39.096909 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 15:00:39.097089 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 15:00:39.097122 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 15:00:39.097125 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 15:00:39.097296 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 15:00:39.097323 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 15:00:39.097326 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 15:00:39.097512 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 15:00:39.098206 |
trace |
system.CModule |
Loading "db_lf" application component |
| 15:00:39.098227 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 15:00:39.111598 |
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 =
'321109' GROUP BY `ce`.`external_id` |
| 15:00:39.111634 |
profile |
yii3.db |
begin:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 15:00:39.112498 |
profile |
yii3.db |
end:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 15:00:39.112992 |
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 = '321109' GROUP BY
`ce`.`external_id` |
| 15:00:39.113194 |
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` |