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

Program Manager (2 positions)

Cyberjaya •  Business •  Contract

best job in town

Job Requirements

  • likeable
  • smart
  • work independantly

Responsibilities

  • Manage project
  • Manage people
 Thank you for your interest. Please login now to apply to this position.

Offer: 2000

A1 Test Corp
A long long long description about this organization 

MaGIC Alumni 


http://a1.com

Testing organization for community page

Brand Event Associate

A1 Test Corp
· Business · Permanent
90 queries in 0.4882 second
Profiling Summary Report (Time: 0.55729s, Memory: 6,241KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 1.08799 0.54400 0.54390 0.54409
appRun 1 0.54941 0.54941 0.54941 0.54941
Organization::afterFind() 3 0.31622 0.10541 0.00429 0.30603
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='4164') 2 0.09157 0.04579 0.00085 0.09073
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='4164') 2 0.07556 0.03778 0.00042 0.07514
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='4164') 2 0.03935 0.01968 0.00142 0.03794
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='4164') 2 0.03141 0.01571 0.00061 0.03080
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos_group`) 1 0.02936 0.02936 0.02936 0.02936
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='4164') 2 0.02842 0.01421 0.00040 0.02802
Controller::beforeRender() 1 0.02250 0.02250 0.02250 0.02250
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='4164') 2 0.01891 0.00945 0.00076 0.01815
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='4164') 2 0.01788 0.00894 0.00062 0.01726
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.01534 0.00511 0.00029 0.01459
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.01510 0.01510 0.01510 0.01510
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='4164', :status='approved') 1 0.01438 0.01438 0.01438 0.01438
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='4164') 2 0.01406 0.00703 0.00105 0.01301
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00734 0.00734 0.00734 0.00734
system.db.CDbCommand.query(SELECT COUNT(*) FROM `cv_jobpos_group` `t`) 3 0.00659 0.00220 0.00050 0.00309
Controller::init() 1 0.00631 0.00631 0.00631 0.00631
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='4164') 1 0.00533 0.00533 0.00533 0.00533
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00512 0.00512 0.00512 0.00512
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2startup_stage`) 1 0.00450 0.00450 0.00450 0.00450
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='2', :countryCode='MY', :stateCode='my-sgr') 1 0.00425 0.00425 0.00425 0.00425
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos`) 1 0.00382 0.00382 0.00382 0.00382
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2event et ON t.id = et.tag_id WHERE et.event_id = :ownerid . Bound with :ownerid='65169') 1 0.00290 0.00290 0.00290 0.00290
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='2') 2 0.00282 0.00141 0.00049 0.00233
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_owner`) 1 0.00280 0.00280 0.00280 0.00280
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2persona`) 1 0.00249 0.00249 0.00249 0.00249
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00241 0.00241 0.00241 0.00241
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos`) 1 0.00222 0.00222 0.00222 0.00222
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00219 0.00219 0.00219 0.00219
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00190 0.00190 0.00190 0.00190
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00188 0.00188 0.00188 0.00188
system.db.CDbCommand.query(SELECT `state`.`id` AS `t1_c0`, `state`.`code` AS `t1_c1`, `state`.`country_code` AS `t1_c2`, `state`.`title` AS `t1_c3`, `state`.`date_added` AS `t1_c4`, `state`.`date_modified` AS `t1_c5` FROM `state` `state` WHERE (`state`.`code`=:ypl0). Bound with :ypl0='my-sgr') 3 0.00184 0.00061 0.00036 0.00105
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event`) 1 0.00159 0.00159 0.00159 0.00159
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `state`) 1 0.00156 0.00156 0.00156 0.00156
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='4164') 1 0.00153 0.00153 0.00153 0.00153
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.00146 0.00146 0.00146 0.00146
Controller::beforeAction() 1 0.00139 0.00139 0.00139 0.00139
system.db.CDbCommand.query(SELECT `startupStages`.`id` AS `t1_c0`, `startupStages`.`code` AS `t1_c1`, `startupStages`.`slug` AS `t1_c2`, `startupStages`.`title` AS `t1_c3`, `startupStages`.`text_short_description` AS `t1_c4`, `startupStages`.`ordering` AS `t1_c5`, `startupStages`.`is_active` AS `t1_c6`, `startupStages`.`date_added` AS `t1_c7`, `startupStages`.`date_modified` AS `t1_c8`, `startupStages`.`title_en` AS `t1_c9`, `startupStages`.`title_ms` AS `t1_c10`, `startupStages`.`text_short_description_en` AS `t1_c11`, `startupStages`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStages` INNER JOIN `event2startup_stage` `startupStages_startupStages` ON (`startupStages_startupStages`.`event_id`=:ypl0) AND (`startupStages`.`id`=`startupStages_startupStages`.`startup_stage_id`). Bound with :ypl0='65169') 1 0.00139 0.00139 0.00139 0.00139
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 1 0.00134 0.00134 0.00134 0.00134
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00134 0.00134 0.00134 0.00134
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00133 0.00133 0.00133 0.00133
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00133 0.00133 0.00133 0.00133
system.db.CDbCommand.query(SELECT `country`.`id` AS `t1_c0`, `country`.`code` AS `t1_c1`, `country`.`name` AS `t1_c2`, `country`.`printable_name` AS `t1_c3`, `country`.`iso3` AS `t1_c4`, `country`.`numcode` AS `t1_c5`, `country`.`is_default` AS `t1_c6`, `country`.`is_highlight` AS `t1_c7`, `country`.`is_active` AS `t1_c8`, `country`.`date_added` AS `t1_c9`, `country`.`date_modified` AS `t1_c10` FROM `country` `country` WHERE (`country`.`code`=:ypl0). Bound with :ypl0='MY') 3 0.00121 0.00040 0.00036 0.00047
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2industry`) 1 0.00115 0.00115 0.00115 0.00115
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country`) 1 0.00103 0.00103 0.00103 0.00103
Organization::init() 3 0.00099 0.00033 0.00032 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `event2startup_stage`) 1 0.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SELECT `event`.`id` AS `t1_c0`, `event`.`code` AS `t1_c1`, `event`.`event_group_code` AS `t1_c2`, `event`.`event_group_id` AS `t1_c3`, `event`.`title` AS `t1_c4`, `event`.`text_short_desc` AS `t1_c5`, `event`.`url_website` AS `t1_c6`, `event`.`date_started` AS `t1_c7`, `event`.`date_ended` AS `t1_c8`, `event`.`is_paid_event` AS `t1_c9`, `event`.`genre` AS `t1_c10`, `event`.`funnel` AS `t1_c11`, `event`.`vendor` AS `t1_c12`, `event`.`vendor_code` AS `t1_c13`, `event`.`at` AS `t1_c14`, `event`.`address_country_code` AS `t1_c15`, `event`.`address_state_code` AS `t1_c16`, `event`.`full_address` AS `t1_c17`, `event`.`latlong_address` AS `t1_c18`, `event`.`email_contact` AS `t1_c19`, `event`.`is_cancelled` AS `t1_c20`, `event`.`is_active` AS `t1_c21`, `event`.`is_for_reporting` AS `t1_c22`, `event`.`json_original` AS `t1_c23`, `event`.`json_extra` AS `t1_c24`, `event`.`date_added` AS `t1_c25`, `event`.`date_modified` AS `t1_c26`, `event`.`is_survey_enabled` AS `t1_c27`, `event`.`address_line1` AS `t1_c28`, `event`.`address_line2` AS `t1_c29`, `event`.`address_zip` AS `t1_c30`, `event`.`address_city` AS `t1_c31`, `event`.`address_state` AS `t1_c32`, ST_AsText(`event`.`latlong_address`) AS event_latlong_address FROM `event` `event` WHERE (`event`.`id`=:ypl0). Bound with :ypl0='65169') 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2event et ON t.id = et.tag_id WHERE et.event_id = :ownerid . Bound with :ownerid='65170') 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW CREATE TABLE `event2industry`) 1 0.00090 0.00090 0.00090 0.00090
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='4164') 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos_group`) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SELECT `startupStages`.`id` AS `t1_c0`, `startupStages`.`code` AS `t1_c1`, `startupStages`.`slug` AS `t1_c2`, `startupStages`.`title` AS `t1_c3`, `startupStages`.`text_short_description` AS `t1_c4`, `startupStages`.`ordering` AS `t1_c5`, `startupStages`.`is_active` AS `t1_c6`, `startupStages`.`date_added` AS `t1_c7`, `startupStages`.`date_modified` AS `t1_c8`, `startupStages`.`title_en` AS `t1_c9`, `startupStages`.`title_ms` AS `t1_c10`, `startupStages`.`text_short_description_en` AS `t1_c11`, `startupStages`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStages` INNER JOIN `event2startup_stage` `startupStages_startupStages` ON (`startupStages_startupStages`.`event_id`=:ypl0) AND (`startupStages`.`id`=`startupStages_startupStages`.`startup_stage_id`). Bound with :ypl0='65170') 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SELECT `event`.`id` AS `t1_c0`, `event`.`code` AS `t1_c1`, `event`.`event_group_code` AS `t1_c2`, `event`.`event_group_id` AS `t1_c3`, `event`.`title` AS `t1_c4`, `event`.`text_short_desc` AS `t1_c5`, `event`.`url_website` AS `t1_c6`, `event`.`date_started` AS `t1_c7`, `event`.`date_ended` AS `t1_c8`, `event`.`is_paid_event` AS `t1_c9`, `event`.`genre` AS `t1_c10`, `event`.`funnel` AS `t1_c11`, `event`.`vendor` AS `t1_c12`, `event`.`vendor_code` AS `t1_c13`, `event`.`at` AS `t1_c14`, `event`.`address_country_code` AS `t1_c15`, `event`.`address_state_code` AS `t1_c16`, `event`.`full_address` AS `t1_c17`, `event`.`latlong_address` AS `t1_c18`, `event`.`email_contact` AS `t1_c19`, `event`.`is_cancelled` AS `t1_c20`, `event`.`is_active` AS `t1_c21`, `event`.`is_for_reporting` AS `t1_c22`, `event`.`json_original` AS `t1_c23`, `event`.`json_extra` AS `t1_c24`, `event`.`date_added` AS `t1_c25`, `event`.`date_modified` AS `t1_c26`, `event`.`is_survey_enabled` AS `t1_c27`, `event`.`address_line1` AS `t1_c28`, `event`.`address_line2` AS `t1_c29`, `event`.`address_zip` AS `t1_c30`, `event`.`address_city` AS `t1_c31`, `event`.`address_state` AS `t1_c32`, ST_AsText(`event`.`latlong_address`) AS event_latlong_address FROM `event` `event` WHERE (`event`.`id`=:ypl0). Bound with :ypl0='65170') 1 0.00077 0.00077 0.00077 0.00077
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.00074 0.00074 0.00074 0.00074
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 `event2industry` `industries_industries` ON (`industries_industries`.`event_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='65169') 1 0.00072 0.00072 0.00072 0.00072
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.00072 0.00072 0.00072 0.00072
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='22ku41') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW CREATE TABLE `state`) 1 0.00066 0.00066 0.00066 0.00066
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='event' AND i.ref_id=65169) 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='event' AND i.ref_id=65170) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SELECT `eventOwners`.`id` AS `t1_c0`, `eventOwners`.`event_code` AS `t1_c1`, `eventOwners`.`event_id` AS `t1_c2`, `eventOwners`.`organization_code` AS `t1_c3`, `eventOwners`.`organization_id` AS `t1_c4`, `eventOwners`.`department` AS `t1_c5`, `eventOwners`.`date_added` AS `t1_c6`, `eventOwners`.`date_modified` AS `t1_c7`, `eventOwners`.`as_role_code` AS `t1_c8` FROM `event_owner` `eventOwners` WHERE (`eventOwners`.`event_code`=:ypl0). Bound with :ypl0='52cd6583-021f-4db5-9dcb-940fbf8dc5e3') 1 0.00062 0.00062 0.00062 0.00062
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 `event2industry` `industries_industries` ON (`industries_industries`.`event_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='65170') 1 0.00060 0.00060 0.00060 0.00060
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 `event2persona` `personas_personas` ON (`personas_personas`.`event_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='65169') 1 0.00057 0.00057 0.00057 0.00057
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.00055 0.00055 0.00055 0.00055
Organization::behaviors() 4 0.00054 0.00013 0.00005 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00052 0.00052 0.00052 0.00052
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.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `event_owner`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `event`) 1 0.00043 0.00043 0.00043 0.00043
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.00041 0.00041 0.00041 0.00041
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 `event2persona` `personas_personas` ON (`personas_personas`.`event_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='65170') 1 0.00040 0.00040 0.00040 0.00040
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.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT `eventOwners`.`id` AS `t1_c0`, `eventOwners`.`event_code` AS `t1_c1`, `eventOwners`.`event_id` AS `t1_c2`, `eventOwners`.`organization_code` AS `t1_c3`, `eventOwners`.`organization_id` AS `t1_c4`, `eventOwners`.`department` AS `t1_c5`, `eventOwners`.`date_added` AS `t1_c6`, `eventOwners`.`date_modified` AS `t1_c7`, `eventOwners`.`as_role_code` AS `t1_c8` FROM `event_owner` `eventOwners` WHERE (`eventOwners`.`event_code`=:ypl0). Bound with :ypl0='f3db71e1-d1c4-4522-a72b-bbbd3ff6d0fd') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `country`) 1 0.00037 0.00037 0.00037 0.00037
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.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `event2persona`) 1 0.00029 0.00029 0.00029 0.00029
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002