This is a staging environment for testing purposes only. Data you inserted here is not persistent!
Yew Hong

Yew Hong

Full-stack Web Developer at Do IT Right

I just build with whatever it takes.
  • Subang Jaya, Selangor, Malaysia

  I'M LOOKING FOR

  • Full Time
  • Freelance
  • Co-Founder
  • Apprenticeship
25 queries in 0.0136 second
Profiling Summary Report (Time: 0.05468s, Memory: 4,121KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.08582 0.04291 0.04283 0.04299
appRun 1 0.04792 0.04792 0.04792 0.04792
Controller::init() 1 0.00663 0.00663 0.00663 0.00663
Controller::beforeRender() 1 0.00386 0.00386 0.00386 0.00386
Controller::beforeAction() 1 0.00170 0.00170 0.00170 0.00170
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00126 0.00126 0.00126 0.00126
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos`) 1 0.00103 0.00103 0.00103 0.00103
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=229) 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00072 0.00024 0.00022 0.00026
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_experience`) 1 0.00071 0.00071 0.00071 0.00071
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='229') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW CREATE TABLE `user`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `state`) 1 0.00063 0.00063 0.00063 0.00063
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='yewness') 1 0.00062 0.00062 0.00062 0.00062
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='3') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT `country`.`id` AS `t1_c0`, `country`.`code` AS `t1_c1`, `country`.`name` AS `t1_c2`, `country`.`printable_name` AS `t1_c3`, `country`.`iso3` AS `t1_c4`, `country`.`numcode` AS `t1_c5`, `country`.`is_default` AS `t1_c6`, `country`.`is_highlight` AS `t1_c7`, `country`.`is_active` AS `t1_c8`, `country`.`date_added` AS `t1_c9`, `country`.`date_modified` AS `t1_c10` FROM `country` `country` WHERE (`country`.`code`=:ypl0). Bound with :ypl0='MY') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT `state`.`id` AS `t1_c0`, `state`.`code` AS `t1_c1`, `state`.`country_code` AS `t1_c2`, `state`.`title` AS `t1_c3`, `state`.`date_added` AS `t1_c4`, `state`.`date_modified` AS `t1_c5` FROM `state` `state` WHERE (`state`.`code`=:ypl0). Bound with :ypl0='my-sgr') 1 0.00038 0.00038 0.00038 0.00038
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.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_experience`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `country`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `state`) 1 0.00024 0.00024 0.00024 0.00024
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001