|
Общий отчет
(Время: 0.78893с,
Память: 126,270Кб)
|
| Процедура |
Номер |
Всего (с) |
Средн. (с) |
Мин. (с) |
Макс. (с) |
| system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) |
2 |
0.00438 |
0.00219 |
0.00036 |
0.00402 |
| system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1) |
1 |
0.00285 |
0.00285 |
0.00285 |
0.00285 |
| 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`=35116778)) |
1 |
0.00278 |
0.00278 |
0.00278 |
0.00278 |
| 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`=35116778)) |
1 |
0.00268 |
0.00268 |
0.00268 |
0.00268 |
| system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) |
1 |
0.00235 |
0.00235 |
0.00235 |
0.00235 |
| 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.00125 |
0.00125 |
0.00125 |
0.00125 |
| 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.00099 |
0.00099 |
0.00099 |
0.00099 |
| system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) |
1 |
0.00085 |
0.00085 |
0.00085 |
0.00085 |
| 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`=35116778) ORDER BY sorter) |
1 |
0.00084 |
0.00084 |
0.00084 |
0.00084 |
| loading session |
2 |
0.00073 |
0.00036 |
0.00001 |
0.00072 |
| 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.00063 |
0.00063 |
0.00063 |
0.00063 |
| 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.00060 |
0.00060 |
0.00060 |
0.00060 |
| 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`=35116778)) |
1 |
0.00049 |
0.00049 |
0.00049 |
0.00049 |
| system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
1 |
0.00149 |
0.00149 |
0.00149 |
0.00149 |
| 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.00085 |
0.00085 |
0.00085 |
0.00085 |
| 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` = 35116778
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
1 |
0.00272 |
0.00272 |
0.00272 |
0.00272 |
| 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 (434638)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) |
1 |
0.00122 |
0.00122 |
0.00122 |
0.00122 |
| 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.00037 |
0.00037 |
0.00037 |
0.00037 |
| 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.00253 |
0.00253 |
0.00253 |
0.00253 |
| system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
3 |
0.00249 |
0.00083 |
0.00029 |
0.00159 |
| system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
3 |
0.00182 |
0.00061 |
0.00026 |
0.00091 |
| system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
3 |
0.00127 |
0.00042 |
0.00024 |
0.00064 |
| 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 (434638)))) 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.00101 |
0.00101 |
0.00101 |
0.00101 |
| 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` = 35116778
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
1 |
0.00090 |
0.00090 |
0.00090 |
0.00090 |
| system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
2 |
0.00080 |
0.00040 |
0.00021 |
0.00059 |
| 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 ("434638"))) |
1 |
0.00073 |
0.00073 |
0.00073 |
0.00073 |
| 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.00056 |
0.00056 |
0.00056 |
0.00056 |
| 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.00049 |
0.00049 |
0.00049 |
0.00049 |
| system.db.CDbCommand.query(SELECT * FROM `sp_fast_reviews` `t` WHERE good_code=:good_code ORDER BY created_at DESC LIMIT 10) |
1 |
0.00037 |
0.00037 |
0.00037 |
0.00037 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t` WHERE (good_code=:good_code) AND (is_active = :is_active)) |
1 |
0.00163 |
0.00163 |
0.00163 |
0.00163 |
| Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
1 |
0.00085 |
0.00085 |
0.00085 |
0.00085 |
| SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED |
1 |
0.00110 |
0.00110 |
0.00110 |
0.00110 |
| SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code = '434638' GROUP BY `ce`.`external_id` |
1 |
0.00051 |
0.00051 |
0.00051 |
0.00051 |
| 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 = '89628' GROUP BY `cef`.`id`, `cep`.`id` |
1 |
0.62170 |
0.62170 |
0.62170 |
0.62170 |
| system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
1 |
0.00077 |
0.00077 |
0.00077 |
0.00077 |
|
Журнал приложения
|
| Время |
Уровень |
Категория |
Сообщение |
| 06:32:38.190047 |
trace |
system.CModule |
Loading "log" application component |
| 06:32:38.192188 |
trace |
glitchtip_fallback |
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed. |
| 06:32:38.192373 |
trace |
system.CModule |
Loading "db" application component |
| 06:32:38.192437 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 06:32:38.193738 |
trace |
system.db.CDbCommand |
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1 |
| 06:32:38.193742 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 06:32:38.194510 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 06:32:38.194643 |
trace |
system.CModule |
Loading "urlHelper" application component |
| 06:32:38.194745 |
trace |
system.CModule |
Loading "DBConfig" application component |
| 06:32:38.194780 |
trace |
system.CModule |
Loading "cache" application component |
| 06:32:38.195482 |
trace |
system.caching.CMemCache |
Serving "66307959e0460a2e2436b0319b2fda14" from cache |
| 06:32:38.195733 |
trace |
system.CModule |
Loading "geo" application component |
| 06:32:38.195789 |
trace |
system.CModule |
Loading "request" application component |
| 06:32:38.196404 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location"
from cache |
| 06:32:38.196444 |
trace |
system.db.ar.CActiveRecord |
Location.findByPk() |
| 06:32:38.197031 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_city"
from cache |
| 06:32:38.197402 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_location_country"
from cache |
| 06:32:38.197559 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID` AS `t0_c1`,
`t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS `t1_c0`,
`ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`, `ct`.`country_id` AS
`t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`, `cu`.`SHORT_NAME` AS
`t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN `b_sale_location_city`
`ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN `b_sale_location_country`
`cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE ((t.COUNTRY_ID != :COUNTRY_ID)
AND (`t`.`ID`=0)) ORDER BY t.SORT ASC, ct.NAME ASC |
| 06:32:38.197563 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`COUNTRY_ID` AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS
`t0_c3`, `ct`.`ID` AS `t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS
`t1_c2`, `ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS
`t2_c1`, `cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT
OUTER JOIN `b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT
OUTER JOIN `b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`)
WHERE ((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC,
ct.NAME ASC) |
| 06:32:38.197933 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`COUNTRY_ID`
AS `t0_c1`, `t`.`CITY_ID` AS `t0_c2`, `t`.`SORT` AS `t0_c3`, `ct`.`ID` AS
`t1_c0`, `ct`.`NAME` AS `t1_c1`, `ct`.`SHORT_NAME` AS `t1_c2`,
`ct`.`country_id` AS `t1_c3`, `cu`.`ID` AS `t2_c0`, `cu`.`NAME` AS `t2_c1`,
`cu`.`SHORT_NAME` AS `t2_c2` FROM `b_sale_location` `t` LEFT OUTER JOIN
`b_sale_location_city` `ct` ON (`t`.`CITY_ID`=`ct`.`ID`) LEFT OUTER JOIN
`b_sale_location_country` `cu` ON (`t`.`COUNTRY_ID`=`cu`.`ID`) WHERE
((t.COUNTRY_ID != :COUNTRY_ID) AND (`t`.`ID`=0)) ORDER BY t.SORT ASC,
ct.NAME ASC) |
| 06:32:38.198090 |
trace |
system.CModule |
Loading "user" application component |
| 06:32:38.198208 |
profile |
application |
begin:loading session |
| 06:32:38.198211 |
trace |
system.CModule |
Loading "session" application component |
| 06:32:38.198928 |
profile |
application |
end:loading session |
| 06:32:38.199378 |
trace |
system.db.ar.CActiveRecord |
OutLocation.findByPk() |
| 06:32:38.199562 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_locations"
from cache |
| 06:32:38.199632 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1 |
| 06:32:38.199635 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1) |
| 06:32:38.202490 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE
`t`.`id`='' LIMIT 1) |
| 06:32:38.202565 |
trace |
system.CModule |
Loading "B2BConfig" application component |
| 06:32:38.202621 |
trace |
system.CModule |
Loading "urlManager" application component |
| 06:32:38.203579 |
trace |
system.caching.CMemCache |
Serving "Yii.CUrlManager.rules" from cache |
| 06:32:38.204046 |
trace |
system.CModule |
Loading "themeInterlayer" application component |
| 06:32:38.204257 |
trace |
system.CModule |
Loading "themeManager" application component |
| 06:32:38.206022 |
trace |
system.web.filters.CFilterChain |
Running filter DBReadUncomitedLevelFilter.filter() |
| 06:32:38.206034 |
trace |
system.db.CDbCommand |
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; |
| 06:32:38.206037 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 06:32:38.206891 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 06:32:38.206927 |
trace |
system.CModule |
Loading "cart" application component |
| 06:32:38.207071 |
trace |
system.db.ar.CActiveRecord |
CartUser.find() |
| 06:32:38.207242 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache |
| 06:32:38.207278 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1 |
| 06:32:38.207281 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 06:32:38.211304 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 06:32:38.211563 |
trace |
system.CModule |
Loading "coupon" application component |
| 06:32:38.211791 |
trace |
system.CModule |
Loading "assetManager" application component |
| 06:32:38.211990 |
trace |
system.db.ar.CActiveRecord |
DeliveryCalcMain.find() |
| 06:32:38.212166 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache |
| 06:32:38.212207 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1 |
| 06:32:38.212209 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1) |
| 06:32:38.214557 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t`
WHERE t.location_id = :location_id LIMIT 1) |
| 06:32:38.216295 |
trace |
system.CModule |
Loading "redisCache" application component |
| 06:32:38.217356 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 06:32:38.217752 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 06:32:38.217875 |
profile |
application |
begin:loading session |
| 06:32:38.217880 |
profile |
application |
end:loading session |
| 06:32:38.219523 |
trace |
system.CModule |
Loading "order" application component |
| 06:32:38.219795 |
trace |
system.db.ar.CActiveRecord |
Good.find() |
| 06:32:38.220012 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache |
| 06:32:38.220717 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache |
| 06:32:38.220971 |
trace |
system.CModule |
Loading "ICatalog" application component |
| 06:32:38.221137 |
trace |
system.caching.CMemCache |
Serving "b_catalog_group1" from cache |
| 06:32:38.221317 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_catalog_price"
from cache |
| 06:32:38.221884 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache |
| 06:32:38.222014 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32` FROM `b_iblock_element` `t` WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE)) |
| 06:32:38.222018 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32` FROM `b_iblock_element` `t` WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE))) |
| 06:32:38.222645 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32` FROM `b_iblock_element` `t` WHERE
((t.IBLOCK_ID = 24) AND (t.CODE = :CODE))) |
| 06:32:38.222805 |
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`=35116778) |
| 06:32:38.222810 |
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`=35116778)) |
| 06:32:38.225486 |
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`=35116778)) |
| 06:32:38.230979 |
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`=35116778) |
| 06:32:38.230983 |
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`=35116778)) |
| 06:32:38.231476 |
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`=35116778)) |
| 06:32:38.231745 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_certs2catalog"
from cache |
| 06:32:38.231791 |
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`=35116778) |
| 06:32:38.231794 |
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`=35116778)) |
| 06:32:38.234571 |
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`=35116778)) |
| 06:32:38.235065 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache |
| 06:32:38.235126 |
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`=35116778) ORDER BY sorter |
| 06:32:38.235130 |
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`=35116778) ORDER BY sorter) |
| 06:32:38.235974 |
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`=35116778) ORDER BY sorter) |
| 06:32:38.236756 |
trace |
system.CModule |
Loading "IPropeties" application component |
| 06:32:38.240281 |
trace |
system.caching.CMemCache |
Serving "iblock_properties_0" from cache |
| 06:32:38.241463 |
trace |
system.CModule |
Loading "warehouse" application component |
| 06:32:38.241760 |
trace |
system.caching.CMemCache |
Serving "IWarehouseIWarehouse::getStaticList" from cache |
| 06:32:38.242011 |
trace |
system.caching.CMemCache |
Serving "IWarehouse1" from cache |
| 06:32:38.242364 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.msections |
| 06:32:38.242607 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache |
| 06:32:38.242703 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `ms`.`ELEMENT_ID` AS `t1_c0`, `ms`.`SECTION_ID` AS
`t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS `t1_c3` FROM
`sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0) |
| 06:32:38.242707 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0)) |
| 06:32:38.243302 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `ms`.`ELEMENT_ID` AS `t1_c0`,
`ms`.`SECTION_ID` AS `t1_c1`, `ms`.`IBLOCK_ID` AS `t1_c2`, `ms`.`NUM` AS
`t1_c3` FROM `sp_catalog2msections` `ms` WHERE (ms.IBLOCK_ID = 49) AND
(`ms`.`ELEMENT_ID`=:ypl0)) |
| 06:32:38.243510 |
trace |
system.CModule |
Loading "GoodSections" application component |
| 06:32:38.243576 |
trace |
system.CModule |
Loading "fcache" application component |
| 06:32:38.253607 |
trace |
system.caching.CFileCache |
Serving "good_sections_tree5" from cache |
| 06:32:38.253849 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache |
| 06:32:38.254067 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_uts_iblock_49_section"
from cache |
| 06:32:38.254370 |
trace |
system.db.ar.CActiveRecord |
TPSupToTer.findAll() |
| 06:32:38.254376 |
trace |
system.CModule |
Loading "dbTP" application component |
| 06:32:38.254399 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 06:32:38.256198 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache |
| 06:32:38.256504 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache |
| 06:32:38.256778 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`ter_id` AS `t0_c1`,
`t`.`sup_id` AS `t0_c2`, `t`.`margin` AS `t0_c3`, `t`.`delivery_ext` AS
`t0_c4`, `t`.`price_min` AS `t0_c5`, `t`.`type` AS `t0_c6`,
`t`.`is_price_purchase_edit` AS `t0_c7`, `t`.`is_price_retail_edit` AS
`t0_c8`, `t`.`use_standart_margin` AS `t0_c9`, `t`.`purchase_price_field`
AS `t0_c10`, `t`.`rating` AS `t0_c11`, `t`.`for_retail` AS `t0_c12`,
`t`.`for_purchase` AS `t0_c13`, `t`.`is_native` AS `t0_c14`,
`t`.`delivery_end_time` AS `t0_c15`, `t`.`delivery_get_orders` AS `t0_c16`,
`t`.`delivery_shipment_orders` AS `t0_c17`, `t`.`is_modified` AS `t0_c18`,
`t`.`is_zzap` AS `t0_c19`, `t`.`email` AS `t0_c20`, `t`.`theme` AS
`t0_c21`, `t`.`message` AS `t0_c22`, `t`.`params` AS `t0_c23`,
`t`.`is_price_rr_use` AS `t0_c24`, `t`.`is_price_erp_less_deny` AS
`t0_c25`, `t`.`parish_territory` AS `t0_c26`, `delivery`.`id` AS `t1_c0`,
`delivery`.`supplier_id` AS `t1_c1`, `delivery`.`territory_id` AS `t1_c2`,
`delivery`.`week_day` AS `t1_c3`, `delivery`.`time_start` AS `t1_c4`,
`delivery`.`time_end` AS `t1_c5`, `delivery`.`add_days` AS `t1_c6`,
`delivery`.`work_days` AS `t1_c7`, `delivery`.`comment` AS `t1_c8`,
`delivery`.`time_finish` AS `t1_c9` FROM `tbl_sup_to_ter` `t` LEFT OUTER
JOIN `tbl_supplier_delivery_settings` `delivery` ON
(`delivery`.`supplier_id`=`t`.`sup_id`) AND
(`delivery`.`territory_id`=`t`.`ter_id`) WHERE (t.ter_id=:ter_id) |
| 06:32:38.291059 |
trace |
system.db.ar.CActiveRecord |
TPAllPrices.findAll() |
| 06:32:38.291357 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}"
from cache |
| 06:32:38.291941 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}"
from cache |
| 06:32:38.292790 |
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))) AND (t.sup_code=:ycp142)) AND
(supplier.is_by_codes = 1)) AND (t.date_added > :date_added)) |
| 06:32:38.295670 |
trace |
system.CModule |
Loading "clientScript" application component |
| 06:32:38.299616 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.groups |
| 06:32:38.300304 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `gr`.`ID` AS `t1_c0`, `gr`.`TIMESTAMP_X` AS `t1_c1`,
`gr`.`MODIFIED_BY` AS `t1_c2`, `gr`.`DATE_CREATE` AS `t1_c3`,
`gr`.`CREATED_BY` AS `t1_c4`, `gr`.`IBLOCK_ID` AS `t1_c5`,
`gr`.`IBLOCK_SECTION_ID` AS `t1_c6`, `gr`.`ACTIVE` AS `t1_c7`,
`gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS `t1_c9`, `gr`.`NAME` AS
`t1_c10`, `gr`.`PICTURE` AS `t1_c11`, `gr`.`LEFT_MARGIN` AS `t1_c12`,
`gr`.`RIGHT_MARGIN` AS `t1_c13`, `gr`.`DEPTH_LEVEL` AS `t1_c14`,
`gr`.`DESCRIPTION` AS `t1_c15`, `gr`.`DESCRIPTION_TYPE` AS `t1_c16`,
`gr`.`SEARCHABLE_CONTENT` AS `t1_c17`, `gr`.`CODE` AS `t1_c18`,
`gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS `t1_c20`, `gr`.`DETAIL_PICTURE`
AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS `t1_c22` FROM `b_iblock_section`
`gr` INNER JOIN `sp_catalog2msections` `groups_gr` ON
(`groups_gr`.`ELEMENT_ID`=:ypl0) AND (`gr`.`ID`=`groups_gr`.`SECTION_ID`)
AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE = "Y") ORDER BY gr.LEFT_MARGIN,
gr.DEPTH_LEVEL |
| 06:32:38.300317 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_section` `gr` INNER JOIN `sp_catalog2msections`
`groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND
(`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE =
"Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL) |
| 06:32:38.301565 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `gr`.`ID` AS `t1_c0`,
`gr`.`TIMESTAMP_X` AS `t1_c1`, `gr`.`MODIFIED_BY` AS `t1_c2`,
`gr`.`DATE_CREATE` AS `t1_c3`, `gr`.`CREATED_BY` AS `t1_c4`,
`gr`.`IBLOCK_ID` AS `t1_c5`, `gr`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`gr`.`ACTIVE` AS `t1_c7`, `gr`.`GLOBAL_ACTIVE` AS `t1_c8`, `gr`.`SORT` AS
`t1_c9`, `gr`.`NAME` AS `t1_c10`, `gr`.`PICTURE` AS `t1_c11`,
`gr`.`LEFT_MARGIN` AS `t1_c12`, `gr`.`RIGHT_MARGIN` AS `t1_c13`,
`gr`.`DEPTH_LEVEL` AS `t1_c14`, `gr`.`DESCRIPTION` AS `t1_c15`,
`gr`.`DESCRIPTION_TYPE` AS `t1_c16`, `gr`.`SEARCHABLE_CONTENT` AS `t1_c17`,
`gr`.`CODE` AS `t1_c18`, `gr`.`XML_ID` AS `t1_c19`, `gr`.`TMP_ID` AS
`t1_c20`, `gr`.`DETAIL_PICTURE` AS `t1_c21`, `gr`.`SOCNET_GROUP_ID` AS
`t1_c22` FROM `b_iblock_section` `gr` INNER JOIN `sp_catalog2msections`
`groups_gr` ON (`groups_gr`.`ELEMENT_ID`=:ypl0) AND
(`gr`.`ID`=`groups_gr`.`SECTION_ID`) AND (gr.IBLOCK_ID = 49 AND gr.ACTIVE =
"Y") ORDER BY gr.LEFT_MARGIN, gr.DEPTH_LEVEL) |
| 06:32:38.301934 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.I_PREVIEW_PICTURE |
| 06:32:38.302182 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache |
| 06:32:38.302328 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `pp`.`ID` AS `t1_c0`, `pp`.`TIMESTAMP_X` AS `t1_c1`,
`pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT` AS `t1_c3`, `pp`.`WIDTH` AS
`t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`, `pp`.`CONTENT_TYPE` AS `t1_c6`,
`pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME` AS `t1_c8`, `pp`.`ORIGINAL_NAME`
AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10` FROM `b_file` `pp` WHERE
(`pp`.`ID`=:ypl0) |
| 06:32:38.302333 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`,
`pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT`
AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`,
`pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME`
AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10`
FROM `b_file` `pp` WHERE (`pp`.`ID`=:ypl0)) |
| 06:32:38.303320 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `pp`.`ID` AS `t1_c0`,
`pp`.`TIMESTAMP_X` AS `t1_c1`, `pp`.`MODULE_ID` AS `t1_c2`, `pp`.`HEIGHT`
AS `t1_c3`, `pp`.`WIDTH` AS `t1_c4`, `pp`.`FILE_SIZE` AS `t1_c5`,
`pp`.`CONTENT_TYPE` AS `t1_c6`, `pp`.`SUBDIR` AS `t1_c7`, `pp`.`FILE_NAME`
AS `t1_c8`, `pp`.`ORIGINAL_NAME` AS `t1_c9`, `pp`.`DESCRIPTION` AS `t1_c10`
FROM `b_file` `pp` WHERE (`pp`.`ID`=:ypl0)) |
| 06:32:38.304543 |
trace |
system.base.CModule |
Loading "acat" module |
| 06:32:38.305145 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
|
| 06:32:38.305150 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 06:32:38.306643 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 06:32:38.306844 |
trace |
system.db.CDbCommand |
Querying SQL:
SELECT
`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`
FROM
`marks`,
`s_marks`
WHERE
`s_marks`.`idsite` = 3 AND
`marks`.`ID` = `s_marks`.`idmark`
ORDER BY
3
|
| 06:32:38.306857 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(
SELECT
`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`
FROM
`marks`,
`s_marks`
WHERE
`s_marks`.`idsite` = 3 AND
`marks`.`ID` = `s_marks`.`idmark`
ORDER BY
3
) |
| 06:32:38.307707 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(
SELECT
`marks`.`ID`,`AID`,`NAMESHORT`,`NAMEFULL`,`ENAMESHORT`,`ENAMEFULL`,`PATHICON`,`PATHHTML`,`PATHWWW`,`HTML_SHORT`,`HTML_FULL`,`s_marks`.`S_HTML_SHORT`,`s_marks`.`S_HTML_FULL`,`s_marks`.`S_META_TITLE`,`s_marks`.`S_META_DESCRIPTION`,`s_marks`.`S_META_KEYWORDS`,`s_marks`.`params`,`s_marks`.`idtypeauto`
FROM
`marks`,
`s_marks`
WHERE
`s_marks`.`idsite` = 3 AND
`marks`.`ID` = `s_marks`.`idmark`
ORDER BY
3
) |
| 06:32:38.310748 |
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` = 35116778
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
|
| 06:32:38.310754 |
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` = 35116778
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 06:32:38.313473 |
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` = 35116778
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 06:32:38.313524 |
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` = 35116778
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000 |
| 06:32:38.313528 |
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` = 35116778
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 06:32:38.314424 |
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` = 35116778
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 06:32:38.314455 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.tags |
| 06:32:38.314902 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_tags2catalog"
from cache |
| 06:32:38.314943 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `tg`.`ID` AS `t1_c0`, `tg`.`TIMESTAMP_X` AS `t1_c1`,
`tg`.`MODIFIED_BY` AS `t1_c2`, `tg`.`DATE_CREATE` AS `t1_c3`,
`tg`.`CREATED_BY` AS `t1_c4`, `tg`.`IBLOCK_ID` AS `t1_c5`,
`tg`.`IBLOCK_SECTION_ID` AS `t1_c6`, `tg`.`ACTIVE` AS `t1_c7`,
`tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO` AS `t1_c9`, `tg`.`SORT` AS
`t1_c10`, `tg`.`NAME` AS `t1_c11`, `tg`.`PREVIEW_PICTURE` AS `t1_c12`,
`tg`.`PREVIEW_TEXT` AS `t1_c13`, `tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`,
`tg`.`DETAIL_PICTURE` AS `t1_c15`, `tg`.`DETAIL_TEXT` AS `t1_c16`,
`tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`, `tg`.`SEARCHABLE_CONTENT` AS `t1_c18`,
`tg`.`WF_STATUS_ID` AS `t1_c19`, `tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`,
`tg`.`WF_NEW` AS `t1_c21`, `tg`.`WF_LOCKED_BY` AS `t1_c22`,
`tg`.`WF_DATE_LOCK` AS `t1_c23`, `tg`.`WF_COMMENTS` AS `t1_c24`,
`tg`.`IN_SECTIONS` AS `t1_c25`, `tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS
`t1_c27`, `tg`.`TAGS` AS `t1_c28`, `tg`.`TMP_ID` AS `t1_c29`,
`tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `tg`.`SHOW_COUNTER` AS `t1_c31`,
`tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM `b_iblock_element` `tg` INNER
JOIN `sp_tags2catalog` `tags_tg` ON (`tags_tg`.`catalog_id`=:ypl0) AND
(`tg`.`ID`=`tags_tg`.`tag_id`) AND (tg.IBLOCK_ID = 50) |
| 06:32:38.314945 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`,
`tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`,
`tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`,
`tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO`
AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`,
`tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`,
`tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`,
`tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`,
`tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`,
`tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`,
`tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`,
`tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS
`t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`,
`tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `tg` INNER JOIN `sp_tags2catalog` `tags_tg` ON
(`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND
(tg.IBLOCK_ID = 50)) |
| 06:32:38.315507 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `tg`.`ID` AS `t1_c0`,
`tg`.`TIMESTAMP_X` AS `t1_c1`, `tg`.`MODIFIED_BY` AS `t1_c2`,
`tg`.`DATE_CREATE` AS `t1_c3`, `tg`.`CREATED_BY` AS `t1_c4`,
`tg`.`IBLOCK_ID` AS `t1_c5`, `tg`.`IBLOCK_SECTION_ID` AS `t1_c6`,
`tg`.`ACTIVE` AS `t1_c7`, `tg`.`ACTIVE_FROM` AS `t1_c8`, `tg`.`ACTIVE_TO`
AS `t1_c9`, `tg`.`SORT` AS `t1_c10`, `tg`.`NAME` AS `t1_c11`,
`tg`.`PREVIEW_PICTURE` AS `t1_c12`, `tg`.`PREVIEW_TEXT` AS `t1_c13`,
`tg`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `tg`.`DETAIL_PICTURE` AS `t1_c15`,
`tg`.`DETAIL_TEXT` AS `t1_c16`, `tg`.`DETAIL_TEXT_TYPE` AS `t1_c17`,
`tg`.`SEARCHABLE_CONTENT` AS `t1_c18`, `tg`.`WF_STATUS_ID` AS `t1_c19`,
`tg`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `tg`.`WF_NEW` AS `t1_c21`,
`tg`.`WF_LOCKED_BY` AS `t1_c22`, `tg`.`WF_DATE_LOCK` AS `t1_c23`,
`tg`.`WF_COMMENTS` AS `t1_c24`, `tg`.`IN_SECTIONS` AS `t1_c25`,
`tg`.`XML_ID` AS `t1_c26`, `tg`.`CODE` AS `t1_c27`, `tg`.`TAGS` AS
`t1_c28`, `tg`.`TMP_ID` AS `t1_c29`, `tg`.`WF_LAST_HISTORY_ID` AS `t1_c30`,
`tg`.`SHOW_COUNTER` AS `t1_c31`, `tg`.`SHOW_COUNTER_START` AS `t1_c32` FROM
`b_iblock_element` `tg` INNER JOIN `sp_tags2catalog` `tags_tg` ON
(`tags_tg`.`catalog_id`=:ypl0) AND (`tg`.`ID`=`tags_tg`.`tag_id`) AND
(tg.IBLOCK_ID = 50)) |
| 06:32:38.317257 |
trace |
system.db.ar.CActiveRecord |
Articles.findAll() |
| 06:32:38.318125 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_m52"
from cache |
| 06:32:38.318922 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_s52"
from cache |
| 06:32:38.319473 |
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
(434638)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10 |
| 06:32:38.319479 |
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
(434638)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10) |
| 06:32:38.320702 |
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
(434638)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY
ACTIVE_FROM DESC LIMIT 10) |
| 06:32:38.321623 |
trace |
system.db.ar.CActiveRecord |
News.findAll() |
| 06:32:38.322310 |
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 (434638)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW()
AND (t.ACTIVE_TO IS NULL
OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10 |
| 06:32:38.322314 |
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 (434638)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW()
AND (t.ACTIVE_TO IS NULL
OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 06:32:38.323328 |
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 (434638)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW()
AND (t.ACTIVE_TO IS NULL
OR (t.ACTIVE_TO IS NOT NULL AND t.ACTIVE_TO > NOW()))))
ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 06:32:38.323810 |
trace |
system.db.ar.CActiveRecord |
ReviewModel.findAll() |
| 06:32:38.323986 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reviews"
from cache |
| 06:32:38.324265 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`id`, `t`.`user_id`, `t`.`seo_url`, `t`.`type_id`,
`t`.`status_id`, `t`.`meta_title`, `t`.`meta_description`, `t`.`title`,
`t`.`preview`, `t`.`content`, `t`.`views`, `t`.`created_at`,
`t`.`updated_at`, `t`.`published_at`, `t`.`question`,
`t`.`state_change_reason` FROM `sp_reviews` `t` INNER JOIN
sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId)
AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10 |
| 06:32:38.324269 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`,
`t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`,
`t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`,
`t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`,
`t`.`question`, `t`.`state_change_reason` FROM `sp_reviews` `t` INNER JOIN
sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId)
AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10) |
| 06:32:38.326802 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`user_id`,
`t`.`seo_url`, `t`.`type_id`, `t`.`status_id`, `t`.`meta_title`,
`t`.`meta_description`, `t`.`title`, `t`.`preview`, `t`.`content`,
`t`.`views`, `t`.`created_at`, `t`.`updated_at`, `t`.`published_at`,
`t`.`question`, `t`.`state_change_reason` FROM `sp_reviews` `t` INNER JOIN
sp_review_product rp ON rp.review_id = t.id WHERE (rp.product_id = :goodId)
AND (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 10) |
| 06:32:38.326932 |
trace |
system.db.ar.CActiveRecord |
FastReview.findAll() |
| 06:32:38.327116 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_fast_reviews"
from cache |
| 06:32:38.327167 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_fast_reviews` `t` WHERE
good_code=:good_code ORDER BY created_at DESC LIMIT 10 |
| 06:32:38.327169 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `sp_fast_reviews` `t` WHERE
good_code=:good_code ORDER BY created_at DESC LIMIT 10) |
| 06:32:38.327541 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `sp_fast_reviews` `t` WHERE
good_code=:good_code ORDER BY created_at DESC LIMIT 10) |
| 06:32:38.327871 |
trace |
system.db.ar.CActiveRecord |
Question.count() |
| 06:32:38.328018 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_questions"
from cache |
| 06:32:38.328093 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT COUNT(*) FROM `sp_questions` `t` WHERE
(good_code=:good_code) AND (is_active = :is_active) |
| 06:32:38.328097 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t`
WHERE (good_code=:good_code) AND (is_active = :is_active)) |
| 06:32:38.329725 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t`
WHERE (good_code=:good_code) AND (is_active = :is_active)) |
| 06:32:38.332572 |
trace |
system.db.ar.CActiveRecord |
CartUser.find() |
| 06:32:38.332649 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1 |
| 06:32:38.332654 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 06:32:38.333014 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 06:32:38.334362 |
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
("434638")) |
| 06:32:38.334366 |
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
("434638"))) |
| 06:32:38.335098 |
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
("434638"))) |
| 06:32:38.338644 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code |
| 06:32:38.338648 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code) |
| 06:32:38.339140 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `sp_product_groups`.*
FROM `sp_product_group_products`
LEFT JOIN `sp_product_groups` ON
sp_product_group_products.key_hash=sp_product_groups.key_hash
WHERE product_code=:product_code) |
| 06:32:38.340118 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 06:32:38.340137 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:32:38.340760 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:32:38.340792 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 06:32:38.340795 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:32:38.341454 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:32:38.341486 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 06:32:38.341490 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:32:38.341871 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:32:38.341903 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 06:32:38.341907 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:32:38.342498 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:32:38.342535 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 06:32:38.342538 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:32:38.342824 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:32:38.342854 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 06:32:38.342856 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:32:38.343116 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:32:38.343142 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 06:32:38.343146 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:32:38.343785 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:32:38.343822 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 06:32:38.343825 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:32:38.344037 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 06:32:38.344074 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 06:32:38.344075 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:32:38.345660 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 06:32:38.345690 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 06:32:38.345691 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:32:38.346596 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 06:32:38.346643 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 06:32:38.346647 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:32:38.346892 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 06:32:38.350960 |
profile |
yii3.db |
begin:SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED |
| 06:32:38.351008 |
profile |
yii3.db |
begin:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 06:32:38.351857 |
profile |
yii3.db |
end:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 06:32:38.352063 |
profile |
yii3.db |
end:SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED |
| 06:32:38.353212 |
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 =
'434638' GROUP BY `ce`.`external_id` |
| 06:32:38.353725 |
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 = '434638' GROUP BY
`ce`.`external_id` |
| 06:32:38.354042 |
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 = '89628' GROUP BY `cef`.`id`, `cep`.`id` |