This is a staging environment for testing purposes only. Data you inserted here is not persistent!
37 queries in 0.0255 second
Profiling Summary Report (Time: 0.07728s, Memory: 5,186KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.13140 0.06570 0.06567 0.06573
appRun 1 0.06962 0.06962 0.06962 0.06962
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`user_id` AS `t0_c1`, `t`.`slug` AS `t0_c2`, `t`.`cv_jobpos_id` AS `t0_c3`, `t`.`organization_name` AS `t0_c4`, `t`.`location` AS `t0_c5`, `t`.`text_address_residential` AS `t0_c6`, `t`.`latlong_address_residential` AS `t0_c7`, `t`.`state_code` AS `t0_c8`, `t`.`country_code` AS `t0_c9`, `t`.`display_name` AS `t0_c10`, `t`.`image_avatar` AS `t0_c11`, `t`.`high_academy_experience_id` AS `t0_c12`, `t`.`current_job_experience_id` AS `t0_c13`, `t`.`text_oneliner` AS `t0_c14`, `t`.`text_short_description` AS `t0_c15`, `t`.`is_looking_fulltime` AS `t0_c16`, `t`.`is_looking_contract` AS `t0_c17`, `t`.`is_looking_freelance` AS `t0_c18`, `t`.`is_looking_cofounder` AS `t0_c19`, `t`.`is_looking_internship` AS `t0_c20`, `t`.`is_looking_apprenticeship` AS `t0_c21`, `t`.`visibility` AS `t0_c22`, `t`.`is_active` AS `t0_c23`, `t`.`json_social` AS `t0_c24`, `t`.`json_extra` AS `t0_c25`, `t`.`date_added` AS `t0_c26`, `t`.`date_modified` AS `t0_c27`, `t`.`file_cv` AS `t0_c28`, `t`.`expected_salary` AS `t0_c29`, `t`.`expected_salary_local` AS `t0_c30`, `t`.`currency_code_local` AS `t0_c31`, `t`.`currency_rates` AS `t0_c32`, ST_AsText(`t`.`latlong_address_residential`) AS latlong_address_residential, `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`, `cvJobpos`.`id` AS `t2_c0`, `cvJobpos`.`cv_jobpos_group_id` AS `t2_c1`, `cvJobpos`.`title` AS `t2_c2`, `cvJobpos`.`is_active` AS `t2_c3`, `cvJobpos`.`json_extra` AS `t2_c4`, `cvJobpos`.`date_added` AS `t2_c5`, `cvJobpos`.`date_modified` AS `t2_c6`, `state`.`id` AS `t3_c0`, `state`.`code` AS `t3_c1`, `state`.`country_code` AS `t3_c2`, `state`.`title` AS `t3_c3`, `state`.`date_added` AS `t3_c4`, `state`.`date_modified` AS `t3_c5`, `country`.`id` AS `t4_c0`, `country`.`code` AS `t4_c1`, `country`.`name` AS `t4_c2`, `country`.`printable_name` AS `t4_c3`, `country`.`iso3` AS `t4_c4`, `country`.`numcode` AS `t4_c5`, `country`.`is_default` AS `t4_c6`, `country`.`is_highlight` AS `t4_c7`, `country`.`is_active` AS `t4_c8`, `country`.`date_added` AS `t4_c9`, `country`.`date_modified` AS `t4_c10` FROM `cv_portfolio` `t` LEFT OUTER JOIN `user` `user` ON (`t`.`user_id`=`user`.`id`) LEFT OUTER JOIN `cv_jobpos` `cvJobpos` ON (`t`.`cv_jobpos_id`=`cvJobpos`.`id`) LEFT OUTER JOIN `state` `state` ON (`t`.`state_code`=`state`.`code`) LEFT OUTER JOIN `country` `country` ON (`t`.`country_code`=`country`.`code`) WHERE ((((t.display_name IS NOT NULL AND t.display_name != "") AND (t.is_active=:ycp0)) AND (user.is_active=:ycp1)) AND (t.visibility=:ycp2)) ORDER BY if(t.image_avatar="" or t.image_avatar is null, 1, 0), t.image_avatar, SUBSTRING(t.display_name, 1, 1) ASC, cvJobpos.title ASC LIMIT 30 OFFSET 330. Bound with :ycp0='1', :ycp1='1', :ycp2='public') 1 0.00740 0.00740 0.00740 0.00740
Controller::init() 1 0.00313 0.00313 0.00313 0.00313
Controller::beforeRender() 1 0.00215 0.00215 0.00215 0.00215
system.db.CDbCommand.query(SELECT COUNT(DISTINCT `t`.`id`) FROM `cv_portfolio` `t` LEFT OUTER JOIN `user` `user` ON (`t`.`user_id`=`user`.`id`) LEFT OUTER JOIN `cv_jobpos` `cvJobpos` ON (`t`.`cv_jobpos_id`=`cvJobpos`.`id`) LEFT OUTER JOIN `state` `state` ON (`t`.`state_code`=`state`.`code`) LEFT OUTER JOIN `country` `country` ON (`t`.`country_code`=`country`.`code`) WHERE ((((t.display_name IS NOT NULL AND t.display_name != "") AND (t.is_active=:ycp0)) AND (user.is_active=:ycp1)) AND (t.visibility=:ycp2)). Bound with :ycp0='1', :ycp1='1', :ycp2='public') 1 0.00195 0.00195 0.00195 0.00195
Controller::beforeAction() 1 0.00099 0.00099 0.00099 0.00099
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=1457) 1 0.00088 0.00088 0.00088 0.00088
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=183) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00083 0.00028 0.00024 0.00030
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=9462) 1 0.00075 0.00075 0.00075 0.00075
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=9461) 1 0.00071 0.00071 0.00071 0.00071
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=300) 1 0.00071 0.00071 0.00071 0.00071
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=238) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00062 0.00062 0.00062 0.00062
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=301) 1 0.00058 0.00058 0.00058 0.00058
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=9186) 1 0.00058 0.00058 0.00058 0.00058
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=9471) 1 0.00055 0.00055 0.00055 0.00055
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=255) 1 0.00050 0.00050 0.00050 0.00050
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=1254) 1 0.00043 0.00043 0.00043 0.00043
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=9468) 1 0.00043 0.00043 0.00043 0.00043
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=9470) 1 0.00043 0.00043 0.00043 0.00043
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=9475) 1 0.00041 0.00041 0.00041 0.00041
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=9463) 1 0.00041 0.00041 0.00041 0.00041
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=9467) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT `id` AS `key`, `title` AS `title` FROM `cv_jobpos` ORDER BY `title` ASC) 1 0.00040 0.00040 0.00040 0.00040
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=105) 1 0.00039 0.00039 0.00039 0.00039
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=9465) 1 0.00039 0.00039 0.00039 0.00039
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=4323) 1 0.00039 0.00039 0.00039 0.00039
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=9469) 1 0.00038 0.00038 0.00038 0.00038
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=9473) 1 0.00037 0.00037 0.00037 0.00037
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=6254) 1 0.00037 0.00037 0.00037 0.00037
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=1411) 1 0.00037 0.00037 0.00037 0.00037
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=153) 1 0.00036 0.00036 0.00036 0.00036
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=304) 1 0.00036 0.00036 0.00036 0.00036
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=240) 1 0.00035 0.00035 0.00035 0.00035
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=9474) 1 0.00034 0.00034 0.00034 0.00034
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=9472) 1 0.00034 0.00034 0.00034 0.00034
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=9464) 1 0.00032 0.00032 0.00032 0.00032
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=9466) 1 0.00031 0.00031 0.00031 0.00031
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001