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

Job Role

Looking for

Location

Name

Filter(s): -
Front-end Web Developer

Munzir Madhadzir

Kuala Lumpur, Malaysia

IOS Mobile Developer

MunFai

Malaysia

Product Manager

Chun

Selangor, Malaysia

Full-stack Web Developer

Haoyu Quan

Kuala Lumpur, Malaysia

Full-stack Web Developer

Hazri Jordan

Kuala Lumpur, Malaysia

Nadia Hazeman

Malaysia

Back-end Web Developer

Way Shen Ang

Kuala Lumpur, Malaysia

Gze Xie Cheong

Malaysia

Full-stack Web Developer

Lai Sim, Wong

Selangor, Malaysia

Chee Keen

Malaysia

Back-end Web Developer

Estelle Chang

Cyberjaya, Selangor, Malaysia

Front-end Web Developer

Lance Yeong

SEREMBAN, Negeri Sembilan, Malaysia

Full-stack Web Developer

Suki Lim

Kuala Lumpur, Malaysia

Product Manager

Aaron Edwards

Kuala Lumpur, Malaysia

Product Manager

Aidil Goh

Malaysia

UX Designer

Zainny Azuar

Kuala Lumpur, Malaysia

Android Mobile Developer

Douglas Tay

Bandar Sungai Long, Kajang., Selangor, Malaysia

UX Designer

Herne Gan

Selangor, Malaysia

Siti Shuhada Suharman

Cyberjaya, Selangor, Malaysia

Full-stack Web Developer

Zen Chow

Kuala Lumpur, Malaysia

UX Designer

Nor Faraniza Razali

Petaling Jaya, Selangor, Malaysia

Full-stack Web Developer

Syafiq Faiz

Kajang, Selangor, Malaysia

Mohamed Saddam Bin Mohamed Amin

Kuala Lumpur, Malaysia

Product Manager

Daniel Dea

Kuala Lumpur, Malaysia

Front-end Web Developer

Nor Shazwan Shah Nor Hisham Shah

Putrajaya, Putrajaya, Malaysia

Elise Wong

Kuala Lumpur, Malaysia

Product Manager

Michael Tan

Petaling Jaya, Selangor, Malaysia

Android Mobile Developer

Faiz

Cyberjaya, Selangor, Malaysia

Android Mobile Developer

Daryl Lee

Seri Kembangan, Selangor, Malaysia

Android Mobile Developer

Lawrence Loh

Malaysia

37 queries in 0.0264 second
Profiling Summary Report (Time: 0.08121s, Memory: 5,196KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.14145 0.07073 0.07070 0.07076
appRun 1 0.07432 0.07432 0.07432 0.07432
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 390. Bound with :ycp0='1', :ycp1='1', :ycp2='public') 1 0.00683 0.00683 0.00683 0.00683
Controller::init() 1 0.00442 0.00442 0.00442 0.00442
Controller::beforeRender() 1 0.00335 0.00335 0.00335 0.00335
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.00191 0.00191 0.00191 0.00191
Controller::beforeAction() 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=9217) 1 0.00124 0.00124 0.00124 0.00124
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=9224) 1 0.00098 0.00098 0.00098 0.00098
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=9220) 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00097 0.00032 0.00023 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=1729) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 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=9158) 1 0.00068 0.00068 0.00068 0.00068
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=7491) 1 0.00064 0.00064 0.00064 0.00064
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=2036) 1 0.00063 0.00063 0.00063 0.00063
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=5008) 1 0.00059 0.00059 0.00059 0.00059
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=9218) 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=9204) 1 0.00056 0.00056 0.00056 0.00056
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=9219) 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=9201) 1 0.00053 0.00053 0.00053 0.00053
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=9215) 1 0.00052 0.00052 0.00052 0.00052
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=9221) 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=9202) 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=9210) 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=9211) 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=9206) 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=9223) 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=9203) 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=9205) 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=6439) 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=9222) 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=9214) 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=9212) 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=9213) 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=9209) 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=9207) 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=9208) 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=9216) 1 0.00030 0.00030 0.00030 0.00030
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001