This is a staging environment for testing purposes only. Data you inserted here is not persistent!
Saiful Izwan Ibrahim

Saiful Izwan Ibrahim

  I'M LOOKING FOR

Not speficied

19 queries in 0.0519 second
Profiling Summary Report (Time: 0.09483s, Memory: 4,013KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.16379 0.08190 0.08181 0.08199
appRun 1 0.08682 0.08682 0.08682 0.08682
system.db.CDbCommand.query(SELECT `user`.`id` AS `t1_c0`, `user`.`username` AS `t1_c1`, `user`.`social_provider` AS `t1_c2`, `user`.`social_identifier` AS `t1_c3`, `user`.`json_social_params` AS `t1_c4`, `user`.`password` AS `t1_c5`, `user`.`reset_password_key` AS `t1_c6`, `user`.`stat_reset_password_count` AS `t1_c7`, `user`.`stat_login_count` AS `t1_c8`, `user`.`stat_login_success_count` AS `t1_c9`, `user`.`last_login_ip` AS `t1_c10`, `user`.`date_last_login` AS `t1_c11`, `user`.`signup_type` AS `t1_c12`, `user`.`signup_ip` AS `t1_c13`, `user`.`is_active` AS `t1_c14`, `user`.`date_activated` AS `t1_c15`, `user`.`date_added` AS `t1_c16`, `user`.`date_modified` AS `t1_c17` FROM `user` `user` WHERE (`user`.`id`=:ypl0). Bound with :ypl0='9080') 1 0.01573 0.01573 0.01573 0.01573
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user`) 1 0.01173 0.01173 0.01173 0.01173
Controller::init() 1 0.00625 0.00625 0.00625 0.00625
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_experience`) 1 0.00517 0.00517 0.00517 0.00517
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos`) 1 0.00512 0.00512 0.00512 0.00512
Controller::beforeRender() 1 0.00507 0.00507 0.00507 0.00507
system.db.CDbCommand.query(SELECT i.*, s.code as metaStructureCode, s.datatype as metaStructureDataType, s.ref_table as metaStructureRefTable FROM `meta_item` as i LEFT JOIN meta_structure as s ON i.meta_structure_id=s.id WHERE s.ref_table='user' AND i.ref_id=9080) 1 0.00343 0.00343 0.00343 0.00343
Controller::beforeAction() 1 0.00199 0.00199 0.00199 0.00199
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00182 0.00182 0.00182 0.00182
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address_residential`) AS latlong_address_residential FROM `cv_portfolio` `t` WHERE t.slug=:slug LIMIT 1. Bound with :slug='u4nvs') 1 0.00175 0.00175 0.00175 0.00175
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00153 0.00153 0.00153 0.00153
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00078 0.00026 0.00024 0.00029
system.db.CDbCommand.query(SELECT `highAcademyExperience`.`id` AS `t1_c0`, `highAcademyExperience`.`cv_portfolio_id` AS `t1_c1`, `highAcademyExperience`.`genre` AS `t1_c2`, `highAcademyExperience`.`title` AS `t1_c3`, `highAcademyExperience`.`organization_name` AS `t1_c4`, `highAcademyExperience`.`location` AS `t1_c5`, `highAcademyExperience`.`full_address` AS `t1_c6`, `highAcademyExperience`.`latlong_address` AS `t1_c7`, `highAcademyExperience`.`state_code` AS `t1_c8`, `highAcademyExperience`.`country_code` AS `t1_c9`, `highAcademyExperience`.`text_short_description` AS `t1_c10`, `highAcademyExperience`.`year_start` AS `t1_c11`, `highAcademyExperience`.`month_start` AS `t1_c12`, `highAcademyExperience`.`year_end` AS `t1_c13`, `highAcademyExperience`.`month_end` AS `t1_c14`, `highAcademyExperience`.`is_active` AS `t1_c15`, `highAcademyExperience`.`json_extra` AS `t1_c16`, `highAcademyExperience`.`date_added` AS `t1_c17`, `highAcademyExperience`.`date_modified` AS `t1_c18`, ST_AsText(`highAcademyExperience`.`latlong_address`) AS highAcademyExperience_latlong_address FROM `cv_experience` `highAcademyExperience` WHERE (`highAcademyExperience`.`id`=:ypl0). Bound with :ypl0=NULL) 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_experience`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SELECT `cvJobpos`.`id` AS `t1_c0`, `cvJobpos`.`cv_jobpos_group_id` AS `t1_c1`, `cvJobpos`.`title` AS `t1_c2`, `cvJobpos`.`is_active` AS `t1_c3`, `cvJobpos`.`json_extra` AS `t1_c4`, `cvJobpos`.`date_added` AS `t1_c5`, `cvJobpos`.`date_modified` AS `t1_c6` FROM `cv_jobpos` `cvJobpos` WHERE (`cvJobpos`.`id`=:ypl0) ORDER BY cvJobpos.title ASC. Bound with :ypl0=NULL) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `user`) 1 0.00036 0.00036 0.00036 0.00036
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002