This is a staging environment for testing purposes only. Data you inserted here is not persistent!
49 queries in 0.0351 second
Profiling Summary Report (Time: 0.10980s, Memory: 5,137KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.19313 0.09657 0.09647 0.09666
appRun 1 0.10189 0.10189 0.10189 0.10189
Controller::beforeRender() 1 0.00811 0.00811 0.00811 0.00811
Controller::init() 1 0.00801 0.00801 0.00801 0.00801
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 150. Bound with :ycp0='1', :ycp1='1', :ycp2='public') 1 0.00664 0.00664 0.00664 0.00664
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00173 0.00173 0.00173 0.00173
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00168 0.00056 0.00031 0.00069
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.00163 0.00163 0.00163 0.00163
Controller::beforeAction() 1 0.00134 0.00134 0.00134 0.00134
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=9359) 1 0.00125 0.00125 0.00125 0.00125
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=9349) 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00092 0.00092 0.00092 0.00092
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=9351) 1 0.00091 0.00091 0.00091 0.00091
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user`) 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00084 0.00084 0.00084 0.00084
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=9352) 1 0.00078 0.00078 0.00078 0.00078
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=9348) 1 0.00074 0.00074 0.00074 0.00074
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=9343) 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=5353) 1 0.00069 0.00069 0.00069 0.00069
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=9360) 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=9355) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `state`) 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=9347) 1 0.00061 0.00061 0.00061 0.00061
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=9345) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos`) 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=9344) 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=9361) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos`) 1 0.00048 0.00048 0.00048 0.00048
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=9357) 1 0.00047 0.00047 0.00047 0.00047
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=9354) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00046 0.00046 0.00046 0.00046
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=9362) 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=9365) 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=9358) 1 0.00042 0.00042 0.00042 0.00042
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=9172) 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=49) 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=9356) 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=9364) 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=9363) 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=43) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `id` AS `key`, `title` AS `title` FROM `cv_jobpos` ORDER BY `title` ASC) 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=9353) 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=9350) 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=6845) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 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=396) 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=9346) 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=9171) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `user`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `state`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `country`) 1 0.00023 0.00023 0.00023 0.00023
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002