Общий отчет (Время: 0.20308с, Память: 11,229Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
loading session	2	0.00079	0.00040	0.00000	0.00079
system.db.CDbCommand.query(SELECT * FROM `sp_locations` `t` WHERE `t`.`id`='' LIMIT 1)	1	0.00033	0.00033	0.00033	0.00033
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE USER_ID=:USER_ID LIMIT 1)	3	0.00066	0.00022	0.00019	0.00024
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS `t0_c1`, `t`.`seo_url` AS `t0_c2`, `t`.`type_id` AS `t0_c3`, `t`.`status_id` AS `t0_c4`, `t`.`meta_title` AS `t0_c5`, `t`.`meta_description` AS `t0_c6`, `t`.`title` AS `t0_c7`, `t`.`preview` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`views` AS `t0_c10`, `t`.`created_at` AS `t0_c11`, `t`.`updated_at` AS `t0_c12`, `t`.`published_at` AS `t0_c13`, `t`.`question` AS `t0_c14`, `t`.`state_change_reason` AS `t0_c15`, `t`.`real_views` AS `t0_c16`, `ach`.`id` AS `t1_c0`, `ach`.`user_id` AS `t1_c1`, `ach`.`entity_id` AS `t1_c2`, `ach`.`entity_type` AS `t1_c3`, `ach`.`achievement_type_id` AS `t1_c4`, `ach`.`comment` AS `t1_c5`, `ach`.`created_at` AS `t1_c6` FROM `sp_reviews` `t` LEFT OUTER JOIN `sp_achievements` `ach` ON (`ach`.`entity_id`=`t`.`id`) WHERE ((t.status_id=:statusId) AND (t.published_at >= :lastMonthFirstDay AND t.published_at < :thisMonthFirstDay AND ach.achievement_type_id IS NOT NULL AND ach.achievement_type_id IN(10, 20, 30) )) AND (ach.entity_type=1) ORDER BY ach.achievement_type_id ASC)	1	0.00163	0.00163	0.00163	0.00163
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00024	0.00024	0.00024	0.00024
system.db.CDbCommand.query(SELECT `images`.`ID` AS `t1_c0`, `images`.`PATH` AS `t1_c1`, `images`.`REVIEW_ID` AS `t1_c2`, `images`.`USER_ID` AS `t1_c3`, `images`.`DESCRIPTION` AS `t1_c4`, `images`.`SORT` AS `t1_c5` FROM `sp_review_images` `images` WHERE (`images`.`review_id`=:ypl0))	23	0.07960	0.00346	0.00020	0.00406
system.db.CDbCommand.query(SELECT `profile`.`user_id` AS `t1_c0`, `profile`.`nickname` AS `t1_c1`, `profile`.`avatar_filename` AS `t1_c2`, `profile`.`bio` AS `t1_c3`, `profile`.`experience` AS `t1_c4`, `profile`.`level` AS `t1_c5`, `profile`.`internal_rating` AS `t1_c6`, `profile`.`created_at` AS `t1_c7`, `profile`.`updated_at` AS `t1_c8` FROM `sp_user_social_profiles` `profile` WHERE (`profile`.`user_id`=:ypl0))	23	0.00579	0.00025	0.00018	0.00036
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.00023	0.00023	0.00023	0.00023
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS `t0_c1`, `t`.`seo_url` AS `t0_c2`, `t`.`type_id` AS `t0_c3`, `t`.`status_id` AS `t0_c4`, `t`.`meta_title` AS `t0_c5`, `t`.`meta_description` AS `t0_c6`, `t`.`title` AS `t0_c7`, `t`.`preview` AS `t0_c8`, `t`.`content` AS `t0_c9`, `t`.`views` AS `t0_c10`, `t`.`created_at` AS `t0_c11`, `t`.`updated_at` AS `t0_c12`, `t`.`published_at` AS `t0_c13`, `t`.`question` AS `t0_c14`, `t`.`state_change_reason` AS `t0_c15`, `t`.`real_views` AS `t0_c16` FROM `sp_reviews` `t` WHERE (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 20 OFFSET 1300)	1	0.00812	0.00812	0.00812	0.00812
system.db.CDbCommand.query(SELECT `r`.`entity_id` AS `t1_c0`, `r`.`entity_type` AS `t1_c1`, `r`.`user_id` AS `t1_c2`, `r`.`reaction_type` AS `t1_c3`, `r`.`created_at` AS `t1_c4` FROM `sp_reactions` `r` WHERE (r.entity_type=:entityType) AND (`r`.`entity_id`=:ypl0))	20	0.00683	0.00034	0.00029	0.00060
system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_reviews` `t` WHERE t.status_id=:statusId)	1	0.00189	0.00189	0.00189	0.00189
system.db.CDbCommand.query(SELECT `product`.`ID` AS `t1_c0`, `product`.`TIMESTAMP_X` AS `t1_c1`, `product`.`MODIFIED_BY` AS `t1_c2`, `product`.`DATE_CREATE` AS `t1_c3`, `product`.`CREATED_BY` AS `t1_c4`, `product`.`IBLOCK_ID` AS `t1_c5`, `product`.`IBLOCK_SECTION_ID` AS `t1_c6`, `product`.`ACTIVE` AS `t1_c7`, `product`.`ACTIVE_FROM` AS `t1_c8`, `product`.`ACTIVE_TO` AS `t1_c9`, `product`.`SORT` AS `t1_c10`, `product`.`NAME` AS `t1_c11`, `product`.`PREVIEW_PICTURE` AS `t1_c12`, `product`.`PREVIEW_TEXT` AS `t1_c13`, `product`.`PREVIEW_TEXT_TYPE` AS `t1_c14`, `product`.`DETAIL_PICTURE` AS `t1_c15`, `product`.`DETAIL_TEXT` AS `t1_c16`, `product`.`DETAIL_TEXT_TYPE` AS `t1_c17`, `product`.`SEARCHABLE_CONTENT` AS `t1_c18`, `product`.`WF_STATUS_ID` AS `t1_c19`, `product`.`WF_PARENT_ELEMENT_ID` AS `t1_c20`, `product`.`WF_NEW` AS `t1_c21`, `product`.`WF_LOCKED_BY` AS `t1_c22`, `product`.`WF_DATE_LOCK` AS `t1_c23`, `product`.`WF_COMMENTS` AS `t1_c24`, `product`.`IN_SECTIONS` AS `t1_c25`, `product`.`XML_ID` AS `t1_c26`, `product`.`CODE` AS `t1_c27`, `product`.`TAGS` AS `t1_c28`, `product`.`TMP_ID` AS `t1_c29`, `product`.`WF_LAST_HISTORY_ID` AS `t1_c30`, `product`.`SHOW_COUNTER` AS `t1_c31`, `product`.`SHOW_COUNTER_START` AS `t1_c32` FROM `b_iblock_element` `product` INNER JOIN `sp_review_product` `goods_product` ON (`goods_product`.`review_id`=:ypl0) AND (`product`.`ID`=`goods_product`.`product_id`) AND (product.IBLOCK_ID = 24))	2	0.00117	0.00058	0.00055	0.00062
system.db.CDbCommand.query(SELECT `c`.`id` AS `t1_c0`, `c`.`user_id` AS `t1_c1`, `c`.`content` AS `t1_c2`, `c`.`status_id` AS `t1_c3`, `c`.`entity_id` AS `t1_c4`, `c`.`entity_type` AS `t1_c5`, `c`.`created_at` AS `t1_c6`, `c`.`updated_at` AS `t1_c7`, `c`.`parent_comment_id` AS `t1_c8` FROM `sp_comments` `c` WHERE (c.entity_type=:entityType and c.status_id=:statusId) AND (`c`.`entity_id`=:ypl0))	3	0.00064	0.00021	0.00019	0.00022
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `c`.`id` AS `t1_c0`, `c`.`user_id` AS `t1_c1`, `c`.`content` AS `t1_c2`, `c`.`status_id` AS `t1_c3`, `c`.`entity_id` AS `t1_c4`, `c`.`entity_type` AS `t1_c5`, `c`.`created_at` AS `t1_c6`, `c`.`updated_at` AS `t1_c7`, `c`.`parent_comment_id` AS `t1_c8` FROM `sp_reviews` `t` LEFT OUTER JOIN `sp_comments` `c` ON (`c`.`entity_id`=`t`.`id`) WHERE (`t`.`id` IN ('19092', '19080', '19071', '19056', '16155', '16152', '16149', '16146', '16143', '16140', '16134', '16131', '16101', '16080', '16074', '16071', '16068', '16050', '16044', '16035')) AND (c.entity_type=:entityType and c.status_id=:statusId))	1	0.00063	0.00063	0.00063	0.00063
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))	2	0.00061	0.00030	0.00029	0.00031
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00021	0.00021	0.00021	0.00021
system.db.CDbCommand.query(SELECT COUNT(*) FROM `b_sale_basket` `t` WHERE FUSER_ID=:FUSER_ID AND ORDER_ID IS NULL AND DELAY = :DELAY)	1	0.00019	0.00019	0.00019	0.00019

Обзоры товаров Правила конкурса обзоров

Призовые места прошлого месяца