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

Example Job Vacancy

General •  Contract

Short Description

"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."

Job Requirements

"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."

Responsibilities

"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."

 Thank you for your interest. Please login now to apply to this position.
TestForJobs
 

Campus ID: C528344  EKYC Verified 

92 queries in 0.0567 second
Profiling Summary Report (Time: 0.12305s, Memory: 5,775KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.21912 0.10956 0.10945 0.10967
appRun 1 0.11461 0.11461 0.11461 0.11461
Organization::afterFind() 3 0.03664 0.01221 0.00301 0.03008
Controller::init() 1 0.00804 0.00804 0.00804 0.00804
Controller::beforeRender() 1 0.00366 0.00366 0.00366 0.00366
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 1 0.00173 0.00173 0.00173 0.00173
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2organization et ON t.id = et.tag_id WHERE et.organization_id = :ownerid . Bound with :ownerid='4442') 2 0.00166 0.00083 0.00058 0.00108
system.db.CDbCommand.query(SELECT `classifications`.`id` AS `t1_c0`, `classifications`.`slug` AS `t1_c1`, `classifications`.`code` AS `t1_c2`, `classifications`.`group_code` AS `t1_c3`, `classifications`.`group_en` AS `t1_c4`, `classifications`.`group_ms` AS `t1_c5`, `classifications`.`title_en` AS `t1_c6`, `classifications`.`title_ms` AS `t1_c7`, `classifications`.`text_short_description_en` AS `t1_c8`, `classifications`.`text_short_description_ms` AS `t1_c9`, `classifications`.`is_active` AS `t1_c10`, `classifications`.`date_added` AS `t1_c11`, `classifications`.`date_modified` AS `t1_c12` FROM `classification` `classifications` INNER JOIN `classification2organization` `classifications_classifications` ON (`classifications_classifications`.`organization_id`=:ypl0) AND (`classifications`.`id`=`classifications_classifications`.`classification_id`). Bound with :ypl0='4442') 2 0.00152 0.00076 0.00068 0.00084
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `job_vacancy`) 1 0.00137 0.00137 0.00137 0.00137
Controller::beforeAction() 1 0.00131 0.00131 0.00131 0.00131
system.db.CDbCommand.query(SELECT `industries`.`id` AS `t1_c0`, `industries`.`code` AS `t1_c1`, `industries`.`slug` AS `t1_c2`, `industries`.`title` AS `t1_c3`, `industries`.`is_active` AS `t1_c4`, `industries`.`date_added` AS `t1_c5`, `industries`.`date_modified` AS `t1_c6`, `industries`.`title_en` AS `t1_c7`, `industries`.`title_ms` AS `t1_c8` FROM `industry` `industries` INNER JOIN `industry2organization` `industries_industries` ON (`industries_industries`.`organization_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='4442') 2 0.00127 0.00064 0.00034 0.00094
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, `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`, `cvJobposGroup`.`id` AS `t2_c0`, `cvJobposGroup`.`title` AS `t2_c1`, `cvJobposGroup`.`ordering` AS `t2_c2`, `cvJobposGroup`.`is_active` AS `t2_c3`, `cvJobposGroup`.`json_extra` AS `t2_c4`, `cvJobposGroup`.`date_added` AS `t2_c5`, `cvJobposGroup`.`date_modified` AS `t2_c6` FROM `cv_portfolio` `t` LEFT OUTER JOIN `cv_jobpos` `cvJobpos` ON (`t`.`cv_jobpos_id`=`cvJobpos`.`id`) LEFT OUTER JOIN `cv_jobpos_group` `cvJobposGroup` ON (`cvJobpos`.`cv_jobpos_group_id`=`cvJobposGroup`.`id`) WHERE (t.visibility LIKE :visibility AND t.is_active=1 AND cvJobposGroup.id=:cvJobposGroupId AND t.country_code LIKE :countryCode AND t.state_code LIKE :stateCode AND t.is_looking_contract=1) ORDER BY RAND(), cvJobpos.title ASC LIMIT 48. Bound with :visibility='public', :cvJobposGroupId='4', :countryCode='MY', :stateCode=NULL) 1 0.00126 0.00126 0.00126 0.00126
system.db.CDbCommand.query(SELECT `impacts`.`id` AS `t1_c0`, `impacts`.`code` AS `t1_c1`, `impacts`.`title` AS `t1_c2`, `impacts`.`image_cover` AS `t1_c3`, `impacts`.`is_active` AS `t1_c4`, `impacts`.`date_added` AS `t1_c5`, `impacts`.`date_modified` AS `t1_c6` FROM `impact` `impacts` INNER JOIN `impact2organization` `impacts_impacts` ON (`impacts_impacts`.`organization_id`=:ypl0) AND (`impacts`.`id`=`impacts_impacts`.`impact_id`). Bound with :ypl0='4442') 2 0.00126 0.00063 0.00043 0.00083
system.db.CDbCommand.query(SHOW CREATE TABLE `job_vacancy`) 1 0.00123 0.00123 0.00123 0.00123
system.db.CDbCommand.query(SELECT `organizationAlternativeNames`.`id` AS `t1_c0`, `organizationAlternativeNames`.`organization_id` AS `t1_c1`, `organizationAlternativeNames`.`title` AS `t1_c2`, `organizationAlternativeNames`.`date_added` AS `t1_c3`, `organizationAlternativeNames`.`date_modified` AS `t1_c4` FROM `organization_alternative_name` `organizationAlternativeNames` WHERE (`organizationAlternativeNames`.`organization_id`=:ypl0). Bound with :ypl0='4442') 2 0.00120 0.00060 0.00029 0.00091
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00108 0.00108 0.00108 0.00108
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00105 0.00105 0.00105 0.00105
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user`) 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00103 0.00103 0.00103 0.00103
Organization::init() 3 0.00095 0.00032 0.00027 0.00037
system.db.CDbCommand.query(SELECT `ownerOrganization`.`id` AS `t1_c0`, `ownerOrganization`.`code` AS `t1_c1`, `ownerOrganization`.`slug` AS `t1_c2`, `ownerOrganization`.`title` AS `t1_c3`, `ownerOrganization`.`text_oneliner` AS `t1_c4`, `ownerOrganization`.`html_content` AS `t1_c5`, `ownerOrganization`.`text_short_description` AS `t1_c6`, `ownerOrganization`.`legalform_id` AS `t1_c7`, `ownerOrganization`.`company_number` AS `t1_c8`, `ownerOrganization`.`image_logo` AS `t1_c9`, `ownerOrganization`.`url_website` AS `t1_c10`, `ownerOrganization`.`email_contact` AS `t1_c11`, `ownerOrganization`.`timezone` AS `t1_c12`, `ownerOrganization`.`year_founded` AS `t1_c13`, `ownerOrganization`.`is_active` AS `t1_c14`, `ownerOrganization`.`date_added` AS `t1_c15`, `ownerOrganization`.`date_modified` AS `t1_c16`, `ownerOrganization`.`legal_name` AS `t1_c17`, `ownerOrganization`.`full_address` AS `t1_c18`, `ownerOrganization`.`address_line1` AS `t1_c19`, `ownerOrganization`.`address_line2` AS `t1_c20`, `ownerOrganization`.`address_zip` AS `t1_c21`, `ownerOrganization`.`address_city` AS `t1_c22`, `ownerOrganization`.`address_state` AS `t1_c23`, `ownerOrganization`.`address_country_code` AS `t1_c24`, `ownerOrganization`.`latlong_address` AS `t1_c25`, `ownerOrganization`.`startup_stage_id` AS `t1_c26`, `ownerOrganization`.`score_completeness` AS `t1_c27`, `ownerOrganization`.`latest_status` AS `t1_c28`, `ownerOrganization`.`total_revenue` AS `t1_c29`, `ownerOrganization`.`total_funding` AS `t1_c30`, `ownerOrganization`.`total_funding_disclosed` AS `t1_c31`, `ownerOrganization`.`total_funding_publicized` AS `t1_c32`, `ownerOrganization`.`latest_funding_round_ordering` AS `t1_c33`, `ownerOrganization`.`latest_funding_round` AS `t1_c34`, ST_AsText(`ownerOrganization`.`latlong_address`) AS ownerOrganization_latlong_address FROM `organization` `ownerOrganization` WHERE (`ownerOrganization`.`id`=:ypl0). Bound with :ypl0='4442') 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2user`) 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00091 0.00091 0.00091 0.00091
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00091 0.00091 0.00091 0.00091
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SELECT `personas`.`id` AS `t1_c0`, `personas`.`code` AS `t1_c1`, `personas`.`slug` AS `t1_c2`, `personas`.`title` AS `t1_c3`, `personas`.`text_short_description` AS `t1_c4`, `personas`.`is_active` AS `t1_c5`, `personas`.`date_added` AS `t1_c6`, `personas`.`date_modified` AS `t1_c7`, `personas`.`title_en` AS `t1_c8`, `personas`.`title_ms` AS `t1_c9`, `personas`.`text_short_description_en` AS `t1_c10`, `personas`.`text_short_description_ms` AS `t1_c11` FROM `persona` `personas` INNER JOIN `persona2organization` `personas_personas` ON (`personas_personas`.`organization_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='4442') 2 0.00090 0.00045 0.00031 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT `sdgs`.`id` AS `t1_c0`, `sdgs`.`code` AS `t1_c1`, `sdgs`.`title` AS `t1_c2`, `sdgs`.`text_short_description` AS `t1_c3`, `sdgs`.`image_cover` AS `t1_c4`, `sdgs`.`is_active` AS `t1_c5`, `sdgs`.`date_added` AS `t1_c6`, `sdgs`.`date_modified` AS `t1_c7` FROM `sdg` `sdgs` INNER JOIN `sdg2organization` `sdgs_sdgs` ON (`sdgs_sdgs`.`organization_id`=:ypl0) AND (`sdgs`.`id`=`sdgs_sdgs`.`sdg_id`). Bound with :ypl0='4442') 2 0.00080 0.00040 0.00038 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SELECT `users`.`id` AS `t1_c0`, `users`.`username` AS `t1_c1`, `users`.`social_provider` AS `t1_c2`, `users`.`social_identifier` AS `t1_c3`, `users`.`json_social_params` AS `t1_c4`, `users`.`password` AS `t1_c5`, `users`.`reset_password_key` AS `t1_c6`, `users`.`stat_reset_password_count` AS `t1_c7`, `users`.`stat_login_count` AS `t1_c8`, `users`.`stat_login_success_count` AS `t1_c9`, `users`.`last_login_ip` AS `t1_c10`, `users`.`date_last_login` AS `t1_c11`, `users`.`signup_type` AS `t1_c12`, `users`.`signup_ip` AS `t1_c13`, `users`.`is_active` AS `t1_c14`, `users`.`date_activated` AS `t1_c15`, `users`.`date_added` AS `t1_c16`, `users`.`date_modified` AS `t1_c17` FROM `user` `users` INNER JOIN `campus_member2user` `users_users` ON (`users_users`.`campus_member_id`=:ypl0) AND (`users`.`id`=`users_users`.`user_id`). Bound with :ypl0='150') 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SELECT `eventOrganizationsSelectedParticipant`.`id` AS `t1_c0`, `eventOrganizationsSelectedParticipant`.`event_code` AS `t1_c1`, `eventOrganizationsSelectedParticipant`.`event_id` AS `t1_c2`, `eventOrganizationsSelectedParticipant`.`event_vendor_code` AS `t1_c3`, `eventOrganizationsSelectedParticipant`.`registration_code` AS `t1_c4`, `eventOrganizationsSelectedParticipant`.`organization_id` AS `t1_c5`, `eventOrganizationsSelectedParticipant`.`organization_name` AS `t1_c6`, `eventOrganizationsSelectedParticipant`.`as_role_code` AS `t1_c7`, `eventOrganizationsSelectedParticipant`.`date_action` AS `t1_c8`, `eventOrganizationsSelectedParticipant`.`date_added` AS `t1_c9`, `eventOrganizationsSelectedParticipant`.`date_modified` AS `t1_c10` FROM `event_organization` `eventOrganizationsSelectedParticipant` WHERE (eventOrganizationsSelectedParticipant.as_role_code = 'selectedParticipant') AND (`eventOrganizationsSelectedParticipant`.`organization_id`=:ypl0). Bound with :ypl0='4442') 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00074 0.00025 0.00022 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `user`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `organization` `t` WHERE t.code=:code LIMIT 1. Bound with :code='6ea6ff9c-bca4-492c-8d0d-59a1f75a6878') 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SELECT `organizations`.`id` AS `t1_c0`, `organizations`.`code` AS `t1_c1`, `organizations`.`slug` AS `t1_c2`, `organizations`.`title` AS `t1_c3`, `organizations`.`text_oneliner` AS `t1_c4`, `organizations`.`html_content` AS `t1_c5`, `organizations`.`text_short_description` AS `t1_c6`, `organizations`.`legalform_id` AS `t1_c7`, `organizations`.`company_number` AS `t1_c8`, `organizations`.`image_logo` AS `t1_c9`, `organizations`.`url_website` AS `t1_c10`, `organizations`.`email_contact` AS `t1_c11`, `organizations`.`timezone` AS `t1_c12`, `organizations`.`year_founded` AS `t1_c13`, `organizations`.`is_active` AS `t1_c14`, `organizations`.`date_added` AS `t1_c15`, `organizations`.`date_modified` AS `t1_c16`, `organizations`.`legal_name` AS `t1_c17`, `organizations`.`full_address` AS `t1_c18`, `organizations`.`address_line1` AS `t1_c19`, `organizations`.`address_line2` AS `t1_c20`, `organizations`.`address_zip` AS `t1_c21`, `organizations`.`address_city` AS `t1_c22`, `organizations`.`address_state` AS `t1_c23`, `organizations`.`address_country_code` AS `t1_c24`, `organizations`.`latlong_address` AS `t1_c25`, `organizations`.`startup_stage_id` AS `t1_c26`, `organizations`.`score_completeness` AS `t1_c27`, `organizations`.`latest_status` AS `t1_c28`, `organizations`.`total_revenue` AS `t1_c29`, `organizations`.`total_funding` AS `t1_c30`, `organizations`.`total_funding_disclosed` AS `t1_c31`, `organizations`.`total_funding_publicized` AS `t1_c32`, `organizations`.`latest_funding_round_ordering` AS `t1_c33`, `organizations`.`latest_funding_round` AS `t1_c34`, ST_AsText(`organizations`.`latlong_address`) AS organizations_latlong_address FROM `organization` `organizations` INNER JOIN `campus_member2organization` `organizations_organizations` ON (`organizations_organizations`.`campus_member_id`=:ypl0) AND (`organizations`.`id`=`organizations_organizations`.`organization_id`). Bound with :ypl0='150') 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2user`) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `job_vacancy` `t` WHERE owner_organization_id=:organizationId AND is_publish=1 AND is_active=1 ORDER BY id DESC. Bound with :organizationId='4442') 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos_group`) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `job_vacancy` `t` WHERE t.slug=:slug LIMIT 1. Bound with :slug='wekyhww') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 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='organization' AND i.ref_id=4442) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `ekyc_company` `t` WHERE organization_id=:organizationId AND status=:status LIMIT 1. Bound with :organizationId='4442', :status='approved') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT `industries`.`id` AS `t1_c0`, `industries`.`code` AS `t1_c1`, `industries`.`slug` AS `t1_c2`, `industries`.`title` AS `t1_c3`, `industries`.`is_active` AS `t1_c4`, `industries`.`date_added` AS `t1_c5`, `industries`.`date_modified` AS `t1_c6`, `industries`.`title_en` AS `t1_c7`, `industries`.`title_ms` AS `t1_c8` FROM `industry` `industries` INNER JOIN `industry2organization` `industries_industries` ON (`industries_industries`.`organization_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='163') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='4442') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2organization et ON t.id = et.tag_id WHERE et.organization_id = :ownerid . Bound with :ownerid='163') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `impacts`.`id` AS `t1_c0`, `impacts`.`code` AS `t1_c1`, `impacts`.`title` AS `t1_c2`, `impacts`.`image_cover` AS `t1_c3`, `impacts`.`is_active` AS `t1_c4`, `impacts`.`date_added` AS `t1_c5`, `impacts`.`date_modified` AS `t1_c6` FROM `impact` `impacts` INNER JOIN `impact2organization` `impacts_impacts` ON (`impacts_impacts`.`organization_id`=:ypl0) AND (`impacts`.`id`=`impacts_impacts`.`impact_id`). Bound with :ypl0='163') 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT `campusMember`.`id` AS `t1_c0`, `campusMember`.`code` AS `t1_c1`, `campusMember`.`typeof` AS `t1_c2`, `campusMember`.`creator_user_id` AS `t1_c3`, `campusMember`.`title` AS `t1_c4`, `campusMember`.`identifier_source` AS `t1_c5`, `campusMember`.`identifier` AS `t1_c6`, `campusMember`.`date_applied` AS `t1_c7`, `campusMember`.`date_approved` AS `t1_c8`, `campusMember`.`admin_user_id` AS `t1_c9`, `campusMember`.`status` AS `t1_c10`, `campusMember`.`text_note` AS `t1_c11`, `campusMember`.`text_remark` AS `t1_c12`, `campusMember`.`is_active` AS `t1_c13`, `campusMember`.`is_perk_provider` AS `t1_c14`, `campusMember`.`is_quest_provider` AS `t1_c15`, `campusMember`.`sms_mobile_no` AS `t1_c16`, `campusMember`.`json_extra` AS `t1_c17`, `campusMember`.`date_added` AS `t1_c18`, `campusMember`.`date_modified` AS `t1_c19` FROM `campus_member` `campusMember` WHERE (`campusMember`.`id`=:ypl0). Bound with :ypl0='150') 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT `cvJobposGroup`.`id` AS `t1_c0`, `cvJobposGroup`.`title` AS `t1_c1`, `cvJobposGroup`.`ordering` AS `t1_c2`, `cvJobposGroup`.`is_active` AS `t1_c3`, `cvJobposGroup`.`json_extra` AS `t1_c4`, `cvJobposGroup`.`date_added` AS `t1_c5`, `cvJobposGroup`.`date_modified` AS `t1_c6` FROM `cv_jobpos_group` `cvJobposGroup` WHERE (`cvJobposGroup`.`id`=:ypl0). Bound with :ypl0='4') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT `personas`.`id` AS `t1_c0`, `personas`.`code` AS `t1_c1`, `personas`.`slug` AS `t1_c2`, `personas`.`title` AS `t1_c3`, `personas`.`text_short_description` AS `t1_c4`, `personas`.`is_active` AS `t1_c5`, `personas`.`date_added` AS `t1_c6`, `personas`.`date_modified` AS `t1_c7`, `personas`.`title_en` AS `t1_c8`, `personas`.`title_ms` AS `t1_c9`, `personas`.`text_short_description_en` AS `t1_c10`, `personas`.`text_short_description_ms` AS `t1_c11` FROM `persona` `personas` INNER JOIN `persona2organization` `personas_personas` ON (`personas_personas`.`organization_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='163') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT `organizationAlternativeNames`.`id` AS `t1_c0`, `organizationAlternativeNames`.`organization_id` AS `t1_c1`, `organizationAlternativeNames`.`title` AS `t1_c2`, `organizationAlternativeNames`.`date_added` AS `t1_c3`, `organizationAlternativeNames`.`date_modified` AS `t1_c4` FROM `organization_alternative_name` `organizationAlternativeNames` WHERE (`organizationAlternativeNames`.`organization_id`=:ypl0). Bound with :ypl0='163') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT `classifications`.`id` AS `t1_c0`, `classifications`.`slug` AS `t1_c1`, `classifications`.`code` AS `t1_c2`, `classifications`.`group_code` AS `t1_c3`, `classifications`.`group_en` AS `t1_c4`, `classifications`.`group_ms` AS `t1_c5`, `classifications`.`title_en` AS `t1_c6`, `classifications`.`title_ms` AS `t1_c7`, `classifications`.`text_short_description_en` AS `t1_c8`, `classifications`.`text_short_description_ms` AS `t1_c9`, `classifications`.`is_active` AS `t1_c10`, `classifications`.`date_added` AS `t1_c11`, `classifications`.`date_modified` AS `t1_c12` FROM `classification` `classifications` INNER JOIN `classification2organization` `classifications_classifications` ON (`classifications_classifications`.`organization_id`=:ypl0) AND (`classifications`.`id`=`classifications_classifications`.`classification_id`). Bound with :ypl0='163') 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT `sdgs`.`id` AS `t1_c0`, `sdgs`.`code` AS `t1_c1`, `sdgs`.`title` AS `t1_c2`, `sdgs`.`text_short_description` AS `t1_c3`, `sdgs`.`image_cover` AS `t1_c4`, `sdgs`.`is_active` AS `t1_c5`, `sdgs`.`date_added` AS `t1_c6`, `sdgs`.`date_modified` AS `t1_c7` FROM `sdg` `sdgs` INNER JOIN `sdg2organization` `sdgs_sdgs` ON (`sdgs_sdgs`.`organization_id`=:ypl0) AND (`sdgs`.`id`=`sdgs_sdgs`.`sdg_id`). Bound with :ypl0='163') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT COUNT(*) FROM `cv_jobpos_group` `t`) 1 0.00024 0.00024 0.00024 0.00024
Organization::behaviors() 4 0.00024 0.00006 0.00003 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos_group`) 1 0.00023 0.00023 0.00023 0.00023
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001