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)
104 queries in 0.0483 second
Profiling Summary Report (Time: 0.10458s, Memory: 6,641KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.18725 0.09362 0.09359 0.09365
appRun 1 0.09768 0.09768 0.09768 0.09768
Organization::afterFind() 6 0.02554 0.00426 0.00280 0.00998
Controller::init() 1 0.00371 0.00371 0.00371 0.00371
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.00270 0.00045 0.00031 0.00091
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.00260 0.00043 0.00029 0.00085
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.00255 0.00043 0.00035 0.00055
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.00251 0.00042 0.00029 0.00083
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.00249 0.00041 0.00035 0.00056
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.00247 0.00041 0.00029 0.00062
Controller::beforeRender() 1 0.00232 0.00232 0.00232 0.00232
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.00232 0.00039 0.00030 0.00064
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.00224 0.00056 0.00046 0.00067
Organization::init() 6 0.00158 0.00026 0.00024 0.00031
Controller::beforeAction() 1 0.00154 0.00154 0.00154 0.00154
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.00146 0.00146 0.00146 0.00146
system.db.CDbCommand.query(SELECT COUNT(*) FROM `cv_jobpos_group` `t`) 4 0.00139 0.00035 0.00026 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `job_vacancy`) 1 0.00128 0.00128 0.00128 0.00128
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.00126 0.00042 0.00035 0.00054
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00100 0.00033 0.00028 0.00041
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.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00092 0.00092 0.00092 0.00092
Organization::behaviors() 7 0.00081 0.00012 0.00003 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos_group`) 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event`) 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2startup_stage`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2user`) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_owner`) 1 0.00060 0.00060 0.00060 0.00060
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.00059 0.00059 0.00059 0.00059
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.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2industry`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2persona`) 1 0.00050 0.00050 0.00050 0.00050
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.00050 0.00050 0.00050 0.00050
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.00045 0.00045 0.00045 0.00045
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=63652) 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW CREATE TABLE `job_vacancy`) 1 0.00044 0.00044 0.00044 0.00044
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.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member`) 1 0.00041 0.00041 0.00041 0.00041
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.00040 0.00040 0.00040 0.00040
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.00039 0.00039 0.00039 0.00039
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.00038 0.00038 0.00038 0.00038
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.00037 0.00037 0.00037 0.00037
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.00037 0.00037 0.00037 0.00037
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.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 `event2persona` `personas_personas` ON (`personas_personas`.`event_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='63652') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `event`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='163') 1 0.00032 0.00032 0.00032 0.00032
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.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `event2startup_stage`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `event_owner`) 1 0.00031 0.00031 0.00031 0.00031
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.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos_group`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `event2industry`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `event2persona`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2user`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00021 0.00021 0.00021 0.00021
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002