Profiling Summary Report (Time: 0.02827s, Memory: 3,332KB)
Procedure	Count	Total (s)	Avg. (s)	Min. (s)	Max. (s)
WebApplication::createController	2	0.02984	0.01492	0.01461	0.01522
appRun	1	0.02009	0.02009	0.02009	0.02009
Controller::init()	1	0.00663	0.00663	0.00663	0.00663
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `challenge`)	1	0.00183	0.00183	0.00183	0.00183
Controller::beforeAction()	1	0.00131	0.00131	0.00131	0.00131
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`owner_organization_id`, `t`.`creator_user_id`, `t`.`title`, `t`.`text_short_description`, `t`.`html_content`, `t`.`image_cover`, `t`.`image_header`, `t`.`url_video`, `t`.`url_application_form`, `t`.`application_form_id`, `t`.`html_deliverable`, `t`.`html_criteria`, `t`.`prize_title`, `t`.`html_prize_detail`, `t`.`date_open`, `t`.`date_close`, `t`.`ordering`, `t`.`text_remark`, `t`.`text_note`, `t`.`json_extra`, `t`.`status`, `t`.`timezone`, `t`.`is_active`, `t`.`is_publish`, `t`.`is_highlight`, `t`.`process_by`, `t`.`date_submit`, `t`.`date_process`, `t`.`date_added`, `t`.`date_modified` FROM `challenge` `t` LEFT JOIN organization as o ON o.id=t.owner_organization_id WHERE t.status='approved' AND t.is_active=1 AND o.is_active=1 AND t.is_publish=1 ORDER BY date_close DESC LIMIT 12 OFFSET 24)	1	0.00107	0.00107	0.00107	0.00107
system.db.CDbCommand.query(SELECT MAX(date_modified) FROM challenge)	1	0.00044	0.00044	0.00044	0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `challenge`)	1	0.00041	0.00041	0.00041	0.00041
WebApplication::createController::override	1	0.00002	0.00002	0.00002	0.00002