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

Executive, Performance Analyst - Strategy Department

Cyberjaya •  Tech •  Fixed Term Contract

To support MaGIC's strategy for the development of startup entrepreneurship ecosystem as a key national agenda in Malaysia by providing the following:

  • To collect requirements of output and outcome from various program owners and stakeholders.
  • To maintain a data dashboard for reporting and data visualization.
  • To standardize data format and ensure data are input according to SOP.

Job Requirements

  • A degree/diploma in business or computer science or related field.
  • At least 2 years work experience in related fields.
  • Data driven and good in gathering, analyzing and cleaning data in spreadsheets.
  • Strong design sense and able to present and visualize complex data into easy to understand information in slides.
  • Collaborative attitude with creativity mindset and able to work in teams to deliver solutions under tight deadlines.
  • Passionate about startups, social enterprises and innovation.
  • At least 1 year experience in SQL and maintaining databases.
  • Ability to communicate well in English (written and oral) is preferred.

Responsibilities

  • Work with developers to help design and enhance an organization & data warehouse, create data standards/structure and framework to standardized impact measurement.
  • Assist program owner to measure pre, during and post program performance by assisting in data gathering activities using surveys, data mining and other secondary data sources.
  • Assist in the process of creating dashboards for the organization's KPI, departments and programs. Work with program owners to automate KPI tracking, write necessary SQL queries to pull data from data warehouses.
  • Prepare insights and reports to senior management on overview of organization KPI, programs performance and recommend measures for improvements using statistical tools and other secondary data sources to make projections.
  • Assist in the production of the organization's annual impact report, work with internal/external data analysts, writers, designers and marketers to finalize and publish the report.
  • Train team members on how to use dashboards, spreadsheets and other data/research tools.
  • Prepare or assist senior management and programs owners in producing ad hoc reports, research projects and data gathering activities.
 Thank you for your interest. Please login now to apply to this position.
MALAYSIAN GLOBAL INNOVATION & CREATIVITY CENTRE BERHAD
Entrepreneurship development 

Campus ID: C99999 Perk Provider  EKYC Verified MaGIC Alumni 


http://mymagic.my

MaGIC discovers and empowers technology startups and social innovators through creativity, innovation and technology adoption, and develops a vibrant and sustainable entrepreneurship ecosystem in Malaysia. Since its inception in 2014, MaGIC has provided its community of start-ups, investors and ecosystem players with capacity building programmes, market & funding opportunities and regulatory assistance that impacted more than 100,000 aspiring and seasoned entrepreneurs with an overall value creation of RM1.9 billion.

As an agency under the Ministry of Science, Technology and Innovation (MOSTI), MaGIC facilitates, navigates and enables the ecosystem with the mission of strengthening Malaysia’s position as an emerging innovation nation.

Webflow designer

MALAYSIAN GLOBAL INNOVATION & CREATIVITY CENTRE BERHAD
· Design · Contract · less than 5000

Full Stack Developer, Campus ID - Technology & Innovation Department (2 positions)

MALAYSIAN GLOBAL INNOVATION & CREATIVITY CENTRE BERHAD
Cyberjaya · Tech · Service Level Agreement (SLA)

Programme Coordinator, Social Innovation - Technology & Innovation Department

MALAYSIAN GLOBAL INNOVATION & CREATIVITY CENTRE BERHAD
Cyberjaya · Tech · Service Level Agreement (SLA)
75 queries in 0.0425 second
Profiling Summary Report (Time: 0.08879s, Memory: 6,677KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.15637 0.07818 0.07816 0.07821
appRun 1 0.08162 0.08162 0.08162 0.08162
Organization::afterFind() 6 0.02844 0.00474 0.00389 0.00549
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') 6 0.00405 0.00067 0.00031 0.00083
Controller::init() 1 0.00391 0.00391 0.00391 0.00391
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') 6 0.00356 0.00059 0.00035 0.00072
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') 6 0.00334 0.00056 0.00030 0.00086
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') 6 0.00325 0.00054 0.00036 0.00083
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') 6 0.00315 0.00053 0.00035 0.00094
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='163') 4 0.00314 0.00079 0.00055 0.00098
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') 6 0.00310 0.00052 0.00035 0.00084
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') 6 0.00290 0.00048 0.00035 0.00085
system.db.CDbCommand.query(SELECT COUNT(*) FROM `cv_jobpos_group` `t`) 4 0.00267 0.00067 0.00055 0.00073
Controller::beforeRender() 1 0.00193 0.00193 0.00193 0.00193
Organization::init() 6 0.00140 0.00023 0.00020 0.00031
Controller::beforeAction() 1 0.00133 0.00133 0.00133 0.00133
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='1', :countryCode=NULL, :stateCode=NULL) 1 0.00131 0.00131 0.00131 0.00131
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='1') 3 0.00105 0.00035 0.00034 0.00037
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='63') 1 0.00101 0.00101 0.00101 0.00101
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='163') 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00086 0.00029 0.00028 0.00030
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='63652') 1 0.00081 0.00081 0.00081 0.00081
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='63652') 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='ossu4bn') 1 0.00070 0.00070 0.00070 0.00070
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='3') 1 0.00070 0.00070 0.00070 0.00070
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='63652') 1 0.00067 0.00067 0.00067 0.00067
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='63') 1 0.00066 0.00066 0.00066 0.00066
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='163') 1 0.00061 0.00061 0.00061 0.00061
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='163', :status='approved') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='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='63652') 1 0.00041 0.00041 0.00041 0.00041
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='40cfdacf-446c-47c0-9f5e-9c2e3eaf58b0') 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00039 0.00039 0.00039 0.00039
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='63') 1 0.00038 0.00038 0.00038 0.00038
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.00035 0.00035 0.00035 0.00035
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='63652') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00029 0.00029 0.00029 0.00029
Organization::behaviors() 7 0.00025 0.00004 0.00002 0.00008
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001