Profiling Summary Report (Time: 0.02691s, Memory: 3,332KB)
Procedure	Count	Total (s)	Avg. (s)	Min. (s)	Max. (s)
WebApplication::createController	2	0.02762	0.01381	0.01371	0.01391
appRun	1	0.01914	0.01914	0.01914	0.01914
Controller::init()	1	0.00762	0.00762	0.00762	0.00762
Controller::beforeAction()	1	0.00126	0.00126	0.00126	0.00126
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `challenge`)	1	0.00100	0.00100	0.00100	0.00100
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.00071	0.00071	0.00071	0.00071
system.db.CDbCommand.query(SHOW CREATE TABLE `challenge`)	1	0.00036	0.00036	0.00036	0.00036
system.db.CDbCommand.query(SELECT MAX(date_modified) FROM challenge)	1	0.00032	0.00032	0.00032	0.00032
WebApplication::createController::override	1	0.00001	0.00001	0.00001	0.00001