|
Общий отчет
(Время: 0.78664с,
Память: 126,202Кб)
|
| Процедура |
Номер |
Всего (с) |
Средн. (с) |
Мин. (с) |
Макс. (с) |
| 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.00194 |
0.00194 |
0.00194 |
0.00194 |
| loading session |
2 |
0.00076 |
0.00038 |
0.00001 |
0.00076 |
| 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.00066 |
0.00066 |
0.00066 |
0.00066 |
| 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`=153057683)) |
1 |
0.00250 |
0.00250 |
0.00250 |
0.00250 |
| 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`=153057683)) |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| 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`=153057683) ORDER BY sorter) |
1 |
0.00051 |
0.00051 |
0.00051 |
0.00051 |
| 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`=153057683)) |
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.00042 |
0.00042 |
0.00042 |
0.00042 |
| 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.00035 |
0.00035 |
0.00035 |
0.00035 |
| system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1) |
2 |
0.00034 |
0.00017 |
0.00017 |
0.00017 |
| system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
1 |
0.00022 |
0.00022 |
0.00022 |
0.00022 |
| system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1) |
1 |
0.00017 |
0.00017 |
0.00017 |
0.00017 |
| SELECT `ce`.`id` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE cep.product_code = '875736' GROUP BY `ce`.`external_id` |
1 |
0.00180 |
0.00180 |
0.00180 |
0.00180 |
| 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.00057 |
0.00057 |
0.00057 |
0.00057 |
| 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` = 153057683
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
1 |
0.00071 |
0.00071 |
0.00071 |
0.00071 |
| system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`, `t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS `t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`, `t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`, `t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`, `t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`, `t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`, `t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`, `t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`, `t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS `t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`, `t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`, `t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS `t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`, `p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`, `p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`, `p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`, `p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`, `p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`, `p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`, `pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS `t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`, `pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR` AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`, `pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON (`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN (4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) AND (t.ACTIVE=:ACTIVE AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) |
1 |
0.00252 |
0.00252 |
0.00252 |
0.00252 |
| system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
3 |
0.00167 |
0.00056 |
0.00016 |
0.00111 |
| system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`, `t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS `t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`, `t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`, `t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`, `t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`, `t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`, `t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`, `t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`, `t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS `t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`, `t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`, `t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`, `mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS `t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`, `pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS `t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`, `pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR` AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`, `pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN `b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`) LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN (4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) 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.00162 |
0.00162 |
0.00162 |
0.00162 |
| system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
3 |
0.00069 |
0.00023 |
0.00018 |
0.00032 |
| 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.00066 |
0.00066 |
0.00066 |
0.00066 |
| 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.00060 |
0.00060 |
0.00060 |
0.00060 |
| system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
2 |
0.00054 |
0.00027 |
0.00023 |
0.00031 |
| system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
3 |
0.00053 |
0.00018 |
0.00016 |
0.00018 |
| system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word) |
2 |
0.00047 |
0.00023 |
0.00018 |
0.00029 |
| 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.00044 |
0.00044 |
0.00044 |
0.00044 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_questions` `t` WHERE (good_code=:good_code) AND (is_active = :is_active)) |
1 |
0.00036 |
0.00036 |
0.00036 |
0.00036 |
| 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 ("875736"))) |
1 |
0.00034 |
0.00034 |
0.00034 |
0.00034 |
| system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1) |
2 |
0.00062 |
0.00031 |
0.00026 |
0.00035 |
| Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
1 |
0.00099 |
0.00099 |
0.00099 |
0.00099 |
| system.db.CDbCommand.query(
SELECT
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` = 153057683
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
1 |
0.00061 |
0.00061 |
0.00061 |
0.00061 |
| SELECT `ce`.`id`, `ce`.`external_id`, `cef`.`file`, `cep`.`product_code` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_files` `cef` ON cef.cert_id = ce.id INNER JOIN `sp_certs2_products` `cep` ON cep.cert_id = ce.id WHERE ce.id = '15447' GROUP BY `cef`.`id`, `cep`.`id` |
1 |
0.61995 |
0.61995 |
0.61995 |
0.61995 |
| system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
1 |
0.00022 |
0.00022 |
0.00022 |
0.00022 |
|
Журнал приложения
|
| Время |
Уровень |
Категория |
Сообщение |
| 16:28:21.609204 |
trace |
system.CModule |
Loading "log" application component |
| 16:28:21.614049 |
trace |
glitchtip_fallback |
The "Sentry\Integration\RequestIntegration,
Sentry\Integration\TransactionIntegration,
Sentry\Integration\FrameContextifierIntegration,
Sentry\Integration\EnvironmentIntegration" integration(s) have been
installed. |
| 16:28:21.614228 |
trace |
system.CModule |
Loading "db" application component |
| 16:28:21.614283 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 16:28:21.615647 |
trace |
system.db.CDbCommand |
Executing SQL: DELETE FROM `YiiLog` WHERE 0=1 |
| 16:28:21.615650 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 16:28:21.615870 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1) |
| 16:28:21.616000 |
trace |
system.CModule |
Loading "urlHelper" application component |
| 16:28:21.616091 |
trace |
system.CModule |
Loading "DBConfig" application component |
| 16:28:21.616117 |
trace |
system.CModule |
Loading "cache" application component |
| 16:28:21.617403 |
trace |
system.caching.CMemCache |
Serving "66307959e0460a2e2436b0319b2fda14" from cache |
| 16:28:21.617651 |
trace |
system.CModule |
Loading "geo" application component |
| 16:28:21.617707 |
trace |
system.CModule |
Loading "request" application component |
| 16:28:21.617897 |
trace |
system.CModule |
Loading "user" application component |
| 16:28:21.618005 |
profile |
application |
begin:loading session |
| 16:28:21.618009 |
trace |
system.CModule |
Loading "session" application component |
| 16:28:21.618762 |
profile |
application |
end:loading session |
| 16:28:21.619132 |
trace |
system.CModule |
Loading "B2BConfig" application component |
| 16:28:21.619220 |
trace |
system.CModule |
Loading "urlManager" application component |
| 16:28:21.620066 |
trace |
system.caching.CMemCache |
Serving "Yii.CUrlManager.rules" from cache |
| 16:28:21.620373 |
trace |
system.CModule |
Loading "themeInterlayer" application component |
| 16:28:21.620938 |
trace |
system.CModule |
Loading "themeManager" application component |
| 16:28:21.621056 |
trace |
system.CModule |
Loading "clientScript" application component |
| 16:28:21.623064 |
trace |
system.web.filters.CFilterChain |
Running filter DBReadUncomitedLevelFilter.filter() |
| 16:28:21.623078 |
trace |
system.db.CDbCommand |
Executing SQL: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; |
| 16:28:21.623080 |
profile |
system.db.CDbCommand.execute |
begin:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 16:28:21.623285 |
profile |
system.db.CDbCommand.execute |
end:system.db.CDbCommand.execute(SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;) |
| 16:28:21.623313 |
trace |
system.CModule |
Loading "cart" application component |
| 16:28:21.623398 |
trace |
system.db.ar.CActiveRecord |
CartUser.find() |
| 16:28:21.623646 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_sale_fuser"
from cache |
| 16:28:21.623683 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1 |
| 16:28:21.623687 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 16:28:21.623857 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 16:28:21.624047 |
trace |
system.CModule |
Loading "coupon" application component |
| 16:28:21.624228 |
trace |
system.CModule |
Loading "assetManager" application component |
| 16:28:21.624366 |
trace |
system.db.ar.CActiveRecord |
DeliveryCalcMain.find() |
| 16:28:21.624516 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_delivery_calc_main"
from cache |
| 16:28:21.624548 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id
= :location_id LIMIT 1 |
| 16:28:21.624552 |
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) |
| 16:28:21.624725 |
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) |
| 16:28:21.625674 |
trace |
system.CModule |
Loading "redisCache" application component |
| 16:28:21.626516 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 16:28:21.627111 |
trace |
system.caching.CRedisCache |
Serving "sberid_AA\Service\OAuth\Clients\SberIdClient_sberid_authState"
from cache |
| 16:28:21.627296 |
profile |
application |
begin:loading session |
| 16:28:21.627302 |
profile |
application |
end:loading session |
| 16:28:21.629920 |
trace |
system.CModule |
Loading "order" application component |
| 16:28:21.630238 |
trace |
system.db.ar.CActiveRecord |
Good.find() |
| 16:28:21.630562 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element"
from cache |
| 16:28:21.630976 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_property"
from cache |
| 16:28:21.631334 |
trace |
system.CModule |
Loading "ICatalog" application component |
| 16:28:21.631524 |
trace |
system.caching.CMemCache |
Serving "b_catalog_group1" from cache |
| 16:28:21.631735 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_catalog_price"
from cache |
| 16:28:21.632493 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_upload_file_for_good"
from cache |
| 16:28:21.632747 |
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)) |
| 16:28:21.632752 |
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))) |
| 16:28:21.633414 |
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))) |
| 16:28:21.633663 |
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`=153057683) |
| 16:28:21.633668 |
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`=153057683)) |
| 16:28:21.636169 |
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`=153057683)) |
| 16:28:21.647403 |
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`=153057683) |
| 16:28:21.647408 |
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`=153057683)) |
| 16:28:21.647913 |
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`=153057683)) |
| 16:28:21.648458 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_certs2catalog"
from cache |
| 16:28:21.648507 |
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`=153057683) |
| 16:28:21.648509 |
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`=153057683)) |
| 16:28:21.649113 |
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`=153057683)) |
| 16:28:21.649295 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_user_good_file"
from cache |
| 16:28:21.649362 |
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`=153057683) ORDER BY sorter |
| 16:28:21.649377 |
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`=153057683) ORDER BY sorter) |
| 16:28:21.649890 |
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`=153057683) ORDER BY sorter) |
| 16:28:21.650644 |
trace |
system.CModule |
Loading "IPropeties" application component |
| 16:28:21.654242 |
trace |
system.caching.CMemCache |
Serving "iblock_properties_0" from cache |
| 16:28:21.655631 |
trace |
system.CModule |
Loading "warehouse" application component |
| 16:28:21.656405 |
trace |
system.caching.CMemCache |
Serving "IWarehouseIWarehouse::getStaticList" from cache |
| 16:28:21.656708 |
trace |
system.caching.CMemCache |
Serving "IWarehouse1" from cache |
| 16:28:21.657339 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.msections |
| 16:28:21.657638 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_catalog2msections"
from cache |
| 16:28:21.657764 |
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) |
| 16:28:21.657768 |
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)) |
| 16:28:21.658184 |
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)) |
| 16:28:21.659216 |
trace |
system.CModule |
Loading "GoodSections" application component |
| 16:28:21.659291 |
trace |
system.CModule |
Loading "fcache" application component |
| 16:28:21.670130 |
trace |
system.caching.CFileCache |
Serving "good_sections_tree5" from cache |
| 16:28:21.671205 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_section"
from cache |
| 16:28:21.671603 |
trace |
system.db.ar.CActiveRecord |
TPSupToTer.findAll() |
| 16:28:21.671612 |
trace |
system.CModule |
Loading "dbTP" application component |
| 16:28:21.671633 |
trace |
system.db.CDbConnection |
Opening DB connection |
| 16:28:21.672825 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{sup_to_ter}}"
from cache |
| 16:28:21.678855 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier_delivery_settings}}"
from cache |
| 16:28:21.679124 |
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) |
| 16:28:21.716090 |
trace |
system.db.ar.CActiveRecord |
TPAllPrices.findAll() |
| 16:28:21.717077 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{allprices}}"
from cache |
| 16:28:21.722579 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=tp:alliance-auto:{{supplier}}"
from cache |
| 16:28:21.726763 |
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))) AND
(t.sup_code=:ycp145)) AND (supplier.is_by_codes = 1)) AND (t.date_added >
:date_added)) |
| 16:28:21.730387 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.groups |
| 16:28:21.730668 |
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 |
| 16:28:21.730673 |
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) |
| 16:28:21.732611 |
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) |
| 16:28:21.732825 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.I_PREVIEW_PICTURE |
| 16:28:21.733078 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_file"
from cache |
| 16:28:21.733180 |
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) |
| 16:28:21.733182 |
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)) |
| 16:28:21.733530 |
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)) |
| 16:28:21.734399 |
trace |
system.base.CModule |
Loading "acat" module |
| 16:28:21.734692 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
|
| 16:28:21.734694 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 16:28:21.734918 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT
`id`,`aid`,`name`
FROM
`typeauto`
WHERE
`typeauto`.`idsite` = 3
ORDER BY
`typeauto`.`sort`
) |
| 16:28:21.734972 |
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
|
| 16:28:21.734976 |
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
) |
| 16:28:21.735543 |
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
) |
| 16:28:21.737219 |
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` = 153057683
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
|
| 16:28:21.737221 |
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` = 153057683
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 16:28:21.737931 |
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` = 153057683
GROUP BY mo.`NAMESHORT` ORDER BY AUTO_TYPE_NAME ASC
) |
| 16:28:21.737958 |
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` = 153057683
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000 |
| 16:28:21.737961 |
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` = 153057683
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 16:28:21.738569 |
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` = 153057683
GROUP BY s.`ID` ORDER BY s.`G1NAME` LIMIT 1000) |
| 16:28:21.738594 |
trace |
system.db.ar.CActiveRecord |
lazy loading Good.tags |
| 16:28:21.739268 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_tags2catalog"
from cache |
| 16:28:21.739332 |
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) |
| 16:28:21.739336 |
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)) |
| 16:28:21.739938 |
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)) |
| 16:28:21.741170 |
trace |
system.db.ar.CActiveRecord |
Articles.findAll() |
| 16:28:21.741683 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_m52"
from cache |
| 16:28:21.742156 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:b_iblock_element_prop_s52"
from cache |
| 16:28:21.742444 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN
(4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10 |
| 16:28:21.742449 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN
(4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 16:28:21.744965 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_ELEMENT_ID` AS `t1_c1`, `mp`.`IBLOCK_PROPERTY_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_ENUM` AS `t1_c4`, `mp`.`VALUE_NUM` AS
`t1_c5`, `mp`.`DESCRIPTION` AS `t1_c6`, `p`.`IBLOCK_ELEMENT_ID` AS `t2_c0`,
`p`.`PROPERTY_1137` AS `t2_c1`, `p`.`DESCRIPTION_1137` AS `t2_c2`,
`p`.`PROPERTY_1138` AS `t2_c3`, `p`.`DESCRIPTION_1138` AS `t2_c4`,
`p`.`PROPERTY_1154` AS `t2_c5`, `p`.`DESCRIPTION_1154` AS `t2_c6`,
`p`.`PROPERTY_1167` AS `t2_c7`, `p`.`DESCRIPTION_1167` AS `t2_c8`,
`p`.`PROPERTY_1168` AS `t2_c9`, `p`.`DESCRIPTION_1168` AS `t2_c10`,
`p`.`PROPERTY_1895` AS `t2_c11`, `p`.`DESCRIPTION_1895` AS `t2_c12`,
`pp`.`ID` AS `t3_c0`, `pp`.`TIMESTAMP_X` AS `t3_c1`, `pp`.`MODULE_ID` AS
`t3_c2`, `pp`.`HEIGHT` AS `t3_c3`, `pp`.`WIDTH` AS `t3_c4`,
`pp`.`FILE_SIZE` AS `t3_c5`, `pp`.`CONTENT_TYPE` AS `t3_c6`, `pp`.`SUBDIR`
AS `t3_c7`, `pp`.`FILE_NAME` AS `t3_c8`, `pp`.`ORIGINAL_NAME` AS `t3_c9`,
`pp`.`DESCRIPTION` AS `t3_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_prop_m52` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_iblock_element_prop_s52` `p` ON
(`t`.`ID`=`p`.`IBLOCK_ELEMENT_ID`) LEFT OUTER JOIN `b_file` `pp` ON
(`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE (((t.IBLOCK_ID = 52) AND
((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND mp.VALUE IN
(4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) AND (t.ACTIVE=:ACTIVE
AND t.ACTIVE_FROM < NOW())) ORDER BY ACTIVE_FROM DESC LIMIT 10) |
| 16:28:21.745811 |
trace |
system.db.ar.CActiveRecord |
News.findAll() |
| 16:28:21.746726 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `t`.`ID` AS `t0_c0`, `t`.`TIMESTAMP_X` AS `t0_c1`,
`t`.`MODIFIED_BY` AS `t0_c2`, `t`.`DATE_CREATE` AS `t0_c3`,
`t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID` AS `t0_c5`,
`t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
mp.VALUE IN (4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) 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 |
| 16:28:21.746732 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
mp.VALUE IN (4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) 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) |
| 16:28:21.748356 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `t`.`ID` AS `t0_c0`,
`t`.`TIMESTAMP_X` AS `t0_c1`, `t`.`MODIFIED_BY` AS `t0_c2`,
`t`.`DATE_CREATE` AS `t0_c3`, `t`.`CREATED_BY` AS `t0_c4`, `t`.`IBLOCK_ID`
AS `t0_c5`, `t`.`IBLOCK_SECTION_ID` AS `t0_c6`, `t`.`ACTIVE` AS `t0_c7`,
`t`.`ACTIVE_FROM` AS `t0_c8`, `t`.`ACTIVE_TO` AS `t0_c9`, `t`.`SORT` AS
`t0_c10`, `t`.`NAME` AS `t0_c11`, `t`.`PREVIEW_PICTURE` AS `t0_c12`,
`t`.`PREVIEW_TEXT` AS `t0_c13`, `t`.`PREVIEW_TEXT_TYPE` AS `t0_c14`,
`t`.`DETAIL_PICTURE` AS `t0_c15`, `t`.`DETAIL_TEXT` AS `t0_c16`,
`t`.`DETAIL_TEXT_TYPE` AS `t0_c17`, `t`.`SEARCHABLE_CONTENT` AS `t0_c18`,
`t`.`WF_STATUS_ID` AS `t0_c19`, `t`.`WF_PARENT_ELEMENT_ID` AS `t0_c20`,
`t`.`WF_NEW` AS `t0_c21`, `t`.`WF_LOCKED_BY` AS `t0_c22`,
`t`.`WF_DATE_LOCK` AS `t0_c23`, `t`.`WF_COMMENTS` AS `t0_c24`,
`t`.`IN_SECTIONS` AS `t0_c25`, `t`.`XML_ID` AS `t0_c26`, `t`.`CODE` AS
`t0_c27`, `t`.`TAGS` AS `t0_c28`, `t`.`TMP_ID` AS `t0_c29`,
`t`.`WF_LAST_HISTORY_ID` AS `t0_c30`, `t`.`SHOW_COUNTER` AS `t0_c31`,
`t`.`SHOW_COUNTER_START` AS `t0_c32`, `mp`.`ID` AS `t1_c0`,
`mp`.`IBLOCK_PROPERTY_ID` AS `t1_c1`, `mp`.`IBLOCK_ELEMENT_ID` AS `t1_c2`,
`mp`.`VALUE` AS `t1_c3`, `mp`.`VALUE_TYPE` AS `t1_c4`, `mp`.`VALUE_ENUM` AS
`t1_c5`, `mp`.`VALUE_NUM` AS `t1_c6`, `mp`.`DESCRIPTION` AS `t1_c7`,
`pp`.`ID` AS `t2_c0`, `pp`.`TIMESTAMP_X` AS `t2_c1`, `pp`.`MODULE_ID` AS
`t2_c2`, `pp`.`HEIGHT` AS `t2_c3`, `pp`.`WIDTH` AS `t2_c4`,
`pp`.`FILE_SIZE` AS `t2_c5`, `pp`.`CONTENT_TYPE` AS `t2_c6`, `pp`.`SUBDIR`
AS `t2_c7`, `pp`.`FILE_NAME` AS `t2_c8`, `pp`.`ORIGINAL_NAME` AS `t2_c9`,
`pp`.`DESCRIPTION` AS `t2_c10` FROM `b_iblock_element` `t` LEFT OUTER JOIN
`b_iblock_element_property` `mp` ON (`mp`.`IBLOCK_ELEMENT_ID`=`t`.`ID`)
LEFT OUTER JOIN `b_file` `pp` ON (`t`.`PREVIEW_PICTURE`=`pp`.`ID`) WHERE
(((t.IBLOCK_ID = 53) AND ((mp.IBLOCK_PROPERTY_ID = :IBLOCK_PROPERTY_TAG AND
mp.VALUE IN (4468782,7986211,7986225,9081946)) OR (mp.IBLOCK_PROPERTY_ID =
:IBLOCK_PROPERTY_CODE AND mp.VALUE IN (875736)))) 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) |
| 16:28:21.748931 |
trace |
system.db.ar.CActiveRecord |
ReviewModel.findAll() |
| 16:28:21.749169 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_reviews"
from cache |
| 16:28:21.749402 |
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 |
| 16:28:21.749404 |
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) |
| 16:28:21.750061 |
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) |
| 16:28:21.750376 |
trace |
system.db.ar.CActiveRecord |
Question.count() |
| 16:28:21.750901 |
trace |
system.caching.CMemCache |
Serving
"yii:dbschemamysql:host=192.168.0.1;dbname=autoopt:alliance-auto:sp_questions"
from cache |
| 16:28:21.750974 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT COUNT(*) FROM `sp_questions` `t` WHERE
(good_code=:good_code) AND (is_active = :is_active) |
| 16:28:21.750977 |
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)) |
| 16:28:21.751341 |
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)) |
| 16:28:21.751434 |
trace |
system.db.ar.CActiveRecord |
CartUser.find() |
| 16:28:21.751471 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT
1 |
| 16:28:21.751473 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 16:28:21.751645 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE
USER_ID=:USER_ID LIMIT 1) |
| 16:28:21.752855 |
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
("875736")) |
| 16:28:21.752860 |
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
("875736"))) |
| 16:28:21.753202 |
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
("875736"))) |
| 16:28:21.755248 |
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 |
| 16:28:21.755250 |
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) |
| 16:28:21.755695 |
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) |
| 16:28:21.756438 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 16:28:21.756441 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 16:28:21.756623 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 16:28:21.756653 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 16:28:21.756654 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 16:28:21.756817 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 16:28:21.756844 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 16:28:21.756846 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.757004 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.757031 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 16:28:21.757034 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 16:28:21.757343 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 16:28:21.757368 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_adjectives`
WHERE word = :word |
| 16:28:21.757369 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word) |
| 16:28:21.757662 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word) |
| 16:28:21.757687 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 16:28:21.757688 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.758043 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.758090 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 16:28:21.758093 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 16:28:21.758280 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 16:28:21.758310 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 16:28:21.758311 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 16:28:21.758496 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 16:28:21.758536 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 16:28:21.758538 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.758934 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.759027 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word |
| 16:28:21.759032 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 16:28:21.759265 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_adjectives_morf`
WHERE word = :word) |
| 16:28:21.759310 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_adjectives`
WHERE word = :word |
| 16:28:21.759314 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word) |
| 16:28:21.759490 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_adjectives`
WHERE word = :word) |
| 16:28:21.759521 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 16:28:21.759522 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.759783 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_adjectives_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.759829 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word |
| 16:28:21.759830 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 16:28:21.760147 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code_parent`
FROM `morph_nouns_morf`
WHERE word = :word) |
| 16:28:21.760176 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `code`
FROM `morph_nouns`
WHERE word = :word |
| 16:28:21.760179 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 16:28:21.760361 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `code`
FROM `morph_nouns`
WHERE word = :word) |
| 16:28:21.760391 |
trace |
system.db.CDbCommand |
Querying SQL: SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1 |
| 16:28:21.760394 |
profile |
system.db.CDbCommand.query |
begin:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.761508 |
profile |
system.db.CDbCommand.query |
end:system.db.CDbCommand.query(SELECT `word`
FROM `morph_nouns_morf`
WHERE code_parent = :codeParent AND plural = 1) |
| 16:28:21.768110 |
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 =
'875736' GROUP BY `ce`.`external_id` |
| 16:28:21.768165 |
profile |
yii3.db |
begin:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 16:28:21.769155 |
profile |
yii3.db |
end:Opening DB connection: mysql:host=192.168.0.1;dbname=autoopt |
| 16:28:21.769908 |
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 = '875736' GROUP BY
`ce`.`external_id` |
| 16:28:21.770235 |
profile |
yii3.db |
begin:SELECT `ce`.`id`, `ce`.`external_id`, `cef`.`file`,
`cep`.`product_code` FROM `sp_certs2` `ce` INNER JOIN `sp_certs2_files`
`cef` ON cef.cert_id = ce.id INNER JOIN `sp_certs2_products` `cep` ON
cep.cert_id = ce.id WHERE ce.id = '15447' GROUP BY `cef`.`id`, `cep`.`id` |