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

Job Role

Looking for

Location

Name

Filter(s): -
13 queries in 0.0150 second
Profiling Summary Report (Time: 0.05076s, Memory: 4,404KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.07886 0.03943 0.03940 0.03945
appRun 1 0.04373 0.04373 0.04373 0.04373
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 450. Bound with :ycp0='1', :ycp1='1', :ycp2='public') 1 0.00678 0.00678 0.00678 0.00678
Controller::init() 1 0.00384 0.00384 0.00384 0.00384
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.00223 0.00223 0.00223 0.00223
Controller::beforeRender() 1 0.00216 0.00216 0.00216 0.00216
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=9516) 1 0.00130 0.00130 0.00130 0.00130
Controller::beforeAction() 1 0.00103 0.00103 0.00103 0.00103
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00077 0.00026 0.00021 0.00029
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00070 0.00070 0.00070 0.00070
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=9514) 1 0.00067 0.00067 0.00067 0.00067
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=9503) 1 0.00060 0.00060 0.00060 0.00060
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=9495) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT `id` AS `key`, `title` AS `title` FROM `cv_jobpos` ORDER BY `title` ASC) 1 0.00051 0.00051 0.00051 0.00051
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=9504) 1 0.00045 0.00045 0.00045 0.00045
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=9513) 1 0.00042 0.00042 0.00042 0.00042
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002