Общий отчет (Время: 4.71689с, Память: 10,852Кб)
Процедура	Номер	Всего (с)	Средн. (с)	Мин. (с)	Макс. (с)
loading session	2	4.50843	2.25421	0.00001	4.50842
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.07160	0.00311	0.00306	0.00325
system.db.CDbCommand.query(SELECT `user`.`ID` AS `t1_c0`, `user`.`TIMESTAMP_X` AS `t1_c1`, `user`.`LOGIN` AS `t1_c2`, `user`.`PASSWORD` AS `t1_c3`, `user`.`CHECKWORD` AS `t1_c4`, `user`.`ACTIVE` AS `t1_c5`, `user`.`NAME` AS `t1_c6`, `user`.`LAST_NAME` AS `t1_c7`, `user`.`EMAIL` AS `t1_c8`, `user`.`LAST_LOGIN` AS `t1_c9`, `user`.`DATE_REGISTER` AS `t1_c10`, `user`.`LID` AS `t1_c11`, `user`.`PERSONAL_PROFESSION` AS `t1_c12`, `user`.`PERSONAL_WWW` AS `t1_c13`, `user`.`PERSONAL_ICQ` AS `t1_c14`, `user`.`PERSONAL_GENDER` AS `t1_c15`, `user`.`PERSONAL_BIRTHDATE` AS `t1_c16`, `user`.`PERSONAL_PHOTO` AS `t1_c17`, `user`.`PERSONAL_PHONE` AS `t1_c18`, `user`.`PERSONAL_FAX` AS `t1_c19`, `user`.`PERSONAL_MOBILE` AS `t1_c20`, `user`.`PERSONAL_PAGER` AS `t1_c21`, `user`.`PERSONAL_STREET` AS `t1_c22`, `user`.`PERSONAL_MAILBOX` AS `t1_c23`, `user`.`PERSONAL_CITY` AS `t1_c24`, `user`.`PERSONAL_STATE` AS `t1_c25`, `user`.`PERSONAL_ZIP` AS `t1_c26`, `user`.`PERSONAL_COUNTRY` AS `t1_c27`, `user`.`PERSONAL_NOTES` AS `t1_c28`, `user`.`WORK_COMPANY` AS `t1_c29`, `user`.`WORK_DEPARTMENT` AS `t1_c30`, `user`.`WORK_POSITION` AS `t1_c31`, `user`.`WORK_WWW` AS `t1_c32`, `user`.`WORK_PHONE` AS `t1_c33`, `user`.`WORK_FAX` AS `t1_c34`, `user`.`WORK_PAGER` AS `t1_c35`, `user`.`WORK_STREET` AS `t1_c36`, `user`.`WORK_MAILBOX` AS `t1_c37`, `user`.`WORK_CITY` AS `t1_c38`, `user`.`WORK_STATE` AS `t1_c39`, `user`.`WORK_ZIP` AS `t1_c40`, `user`.`WORK_COUNTRY` AS `t1_c41`, `user`.`WORK_PROFILE` AS `t1_c42`, `user`.`WORK_LOGO` AS `t1_c43`, `user`.`WORK_NOTES` AS `t1_c44`, `user`.`ADMIN_NOTES` AS `t1_c45`, `user`.`STORED_HASH` AS `t1_c46`, `user`.`XML_ID` AS `t1_c47`, `user`.`PERSONAL_BIRTHDAY` AS `t1_c48`, `user`.`EXTERNAL_AUTH_ID` AS `t1_c49`, `user`.`CHECKWORD_TIME` AS `t1_c50`, `user`.`SECOND_NAME` AS `t1_c51`, `user`.`CONFIRM_CODE` AS `t1_c52`, `user`.`LOGIN_ATTEMPTS` AS `t1_c53`, `user`.`LAST_ACTIVITY_DATE` AS `t1_c54`, `user`.`_sendMerge` AS `t1_c55`, `user`.`_sendInfo` AS `t1_c56`, `user`.`unread_ticket_msg` AS `t1_c57`, `user`.`unread_vin_msg` AS `t1_c58`, `user`.`inn` AS `t1_c59` FROM `b_user` `user` WHERE (`user`.`ID`=:ypl0))	23	0.00816	0.00035	0.00022	0.00058
system.db.CDbCommand.query(SELECT `uf`.`ID` AS `t1_c0`, `uf`.`USER_ID` AS `t1_c1`, `uf`.`ALIAS` AS `t1_c2`, `uf`.`DESCRIPTION` AS `t1_c3`, `uf`.`IP_ADDRESS` AS `t1_c4`, `uf`.`AVATAR` AS `t1_c5`, `uf`.`NUM_POSTS` AS `t1_c6`, `uf`.`INTERESTS` AS `t1_c7`, `uf`.`LAST_POST` AS `t1_c8`, `uf`.`ALLOW_POST` AS `t1_c9`, `uf`.`LAST_VISIT` AS `t1_c10`, `uf`.`DATE_REG` AS `t1_c11`, `uf`.`REAL_IP_ADDRESS` AS `t1_c12`, `uf`.`SIGNATURE` AS `t1_c13`, `uf`.`SHOW_NAME` AS `t1_c14`, `uf`.`RANK_ID` AS `t1_c15`, `uf`.`POINTS` AS `t1_c16`, `uf`.`HIDE_FROM_ONLINE` AS `t1_c17`, `uf`.`SUBSC_GROUP_MESSAGE` AS `t1_c18`, `uf`.`SUBSC_GET_MY_MESSAGE` AS `t1_c19` FROM `b_forum_user` `uf` WHERE (`uf`.`USER_ID`=:ypl0))	23	0.00570	0.00025	0.00017	0.00038
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`, `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)	2	0.00238	0.00119	0.00118	0.00121
system.db.CDbCommand.query(SELECT COUNT(*) FROM `sp_reviews` `t` WHERE t.status_id=:statusId)	1	0.00210	0.00210	0.00210	0.00210
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.00019	0.00019	0.00019	0.00019
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` FROM `sp_reviews` `t` WHERE (t.status_id=:statusId) ORDER BY t.published_at DESC LIMIT 20 OFFSET 200)	1	0.00186	0.00186	0.00186	0.00186
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.00111	0.00037	0.00034	0.00041
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 `t`.`ID` AS `t0_c0`, `t`.`FUSER_ID` AS `t0_c1`, `t`.`ORDER_ID` AS `t0_c2`, `t`.`PRODUCT_ID` AS `t0_c3`, `t`.`PRODUCT_PRICE_ID` AS `t0_c4`, `t`.`PRICE` AS `t0_c5`, `t`.`CURRENCY` AS `t0_c6`, `t`.`DATE_INSERT` AS `t0_c7`, `t`.`DATE_UPDATE` AS `t0_c8`, `t`.`WEIGHT` AS `t0_c9`, `t`.`QUANTITY` AS `t0_c10`, `t`.`LID` AS `t0_c11`, `t`.`DELAY` AS `t0_c12`, `t`.`NAME` AS `t0_c13`, `t`.`CAN_BUY` AS `t0_c14`, `t`.`MODULE` AS `t0_c15`, `t`.`CALLBACK_FUNC` AS `t0_c16`, `t`.`NOTES` AS `t0_c17`, `t`.`ORDER_CALLBACK_FUNC` AS `t0_c18`, `t`.`DETAIL_PAGE_URL` AS `t0_c19`, `t`.`DISCOUNT_PRICE` AS `t0_c20`, `t`.`CANCEL_CALLBACK_FUNC` AS `t0_c21`, `t`.`PAY_CALLBACK_FUNC` AS `t0_c22`, `t`.`CATALOG_XML_ID` AS `t0_c23`, `t`.`PRODUCT_XML_ID` AS `t0_c24`, `t`.`DISCOUNT_NAME` AS `t0_c25`, `t`.`DISCOUNT_VALUE` AS `t0_c26`, `t`.`DISCOUNT_COUPON` AS `t0_c27`, `t`.`VAT_RATE` AS `t0_c28`, `t`.`PURCHASE_PRICE` AS `t0_c29`, `t`.`CAR_ID` AS `t0_c30`, `t`.`EXPEND_ID` AS `t0_c31`, `t`.`LINKED_PRODUCT_ID` AS `t0_c32`, `t`.`LINKED_MPRODUCT_ID` AS `t0_c33`, `t`.`basket_id` AS `t0_c34`, `t`.`product_avail` AS `t0_c35` FROM `b_sale_basket` `t` WHERE ((ORDER_ID IS NULL AND DELAY IN("N","F")) AND (FUSER_ID=:FUSER_ID)))	1	0.00023	0.00023	0.00023	0.00023
system.db.CDbCommand.query(SELECT * FROM `sp_delivery_calc_main` `t` WHERE t.location_id = :location_id LIMIT 1)	1	0.00022	0.00022	0.00022	0.00022
system.db.CDbCommand.query(SELECT * FROM `b_sale_fuser` `t` WHERE ID=:ID LIMIT 1)	1	0.00021	0.00021	0.00021	0.00021
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.00593	0.00030	0.00026	0.00037
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 ('573005', '573002', '570011', '555004', '555001', '549007', '549004', '549001', '546001', '543001', '540001', '537001', '534007', '534001', '534004', '531022', '531025', '531019', '531016', '531013')) AND (c.entity_type=:entityType and c.status_id=:statusId))	1	0.00058	0.00058	0.00058	0.00058
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.00028	0.00028	0.00028	0.00028
system.db.CDbCommand.execute(DELETE FROM `YiiLog` WHERE 0=1)	1	0.00026	0.00026	0.00026	0.00026

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

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