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

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

Cyberjaya •  Tech •  Service Level Agreement (SLA)

The tech team builds products based on requirements from other teams and the company. We have permanent vacancies to be filled up by hiring vendors of SLA based in order to ensure that all programmes will run smoothly. SLA mechanism allows us to better evaluate a software engineer before we decide to offer him/her a permanent position.

For this position, the vendors will be working on the implementation and maintenance of the new MaGIC’s Campus ID component of MaGIC Central System.

Job Requirements

  • Bachelor's Degree in Computer Science, Software Engineering, Information Systems or in any other related field.
  • Minimum 4 years of relevant experience in related fields.
  • HTML, CSS, and JavaScript. Being up on latest practices is a must, e.g., HTML5, CSS3, and ECMAScript 6 (minimum)
  • A relevant back-end programming language (PHP) on the LAMP platform
  • Familiar with or willing to learn Yii PHP development framework and design pattern of MVC
  • Database design and management, including being up on the latest practices and associated versions
  • Server management and deployment for the relevant environment
  • Thorough understanding of user experience and possibly even product strategy
  • Experience implementing testing platforms and unit tests
  • Proficiency with Git
  • Appreciation for clean and well-documented code

Responsibilities

Main Responsibility

  • Working mainly on the MaGIC Campus ID Project from the initial phase to the support and maintenance phase.
  • Responsible for the design, program unit test and functional test of software platform and server.
  • Working together with other developers. Ensure technical projects can cover functional and stability.
  • Involved in optimization and secondary development of the products to boost the operation of business models.
  • Write reusable and clean code base
  • Perform UI/UX and R&D when required
  • Produce necessary documentation, user manual
  • Meeting with stakeholders when required

 

Software Development

  • Developing front and back end website architecture
  • Creating servers and databases for functionality
  • Ensuring cross-platform optimization for mobile phones
  • Ensuring responsiveness of applications
  • Working with Designer to implement UI/UX and improving design guideline
  • Designing and developing APIs
  • Staying abreast of developments in web applications and programming languages
  • Handle code deployments and fixes in all environments 

 

DevOps

  • Build tools to reduce occurrences of errors and improve customer experience
  • Investigate and resolve technical issues
  • Brainstorm for new ideas and ways to improve development delivery
  • Design procedures for system troubleshooting and maintenance
  • Follow all best practices and procedures as established by the company
  • Perform day to day maintenance on existing systems and servers
  • Perform advanced data analytics which involves but not limited to data warehousing, data mining and sentiment analytics with the ultimate goal to provide insight and predictive suggestion to management

 

Project Management

  • Meeting both technical and consumer needs
  • Seeing through a project from conception to finished product
  • Design and strategise plans as well as execute discussions and engagements to promote data-driven organisation, open data and open-source software
  • Provide training and guidance to peer, junior developers and interns
  • Execute additional assignments/initiatives from time to time as agreed with HOD and Managers
  • Support project findings, reports, documentation and proposals

Community/Stakeholder

  • Engagements with the community through support as mentor/advisory/judge
  • Engagements and meetings with teams and external members as well as stakeholders, including but not limited to daily standup, sprint planning and sprint review.
  • Assist plan and schedule phases of engagement with ecosystems and stakeholders
  • Leads several low-risk engagements with stakeholders at the ministry level.
 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

Programme Coordinator, Social Innovation - Technology & Innovation Department

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

Executive, Performance Analyst - Strategy Department

MALAYSIAN GLOBAL INNOVATION & CREATIVITY CENTRE BERHAD
Cyberjaya · Tech · Fixed Term Contract
178 queries in 0.0664 second
Profiling Summary Report (Time: 0.14637s, Memory: 7,100KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.26753 0.13377 0.13344 0.13409
appRun 1 0.13835 0.13835 0.13835 0.13835
Organization::afterFind() 6 0.03373 0.00562 0.00264 0.01962
Controller::init() 1 0.00598 0.00598 0.00598 0.00598
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') 16 0.00496 0.00031 0.00025 0.00061
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') 16 0.00441 0.00028 0.00024 0.00034
Controller::beforeRender() 1 0.00407 0.00407 0.00407 0.00407
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.00220 0.00055 0.00047 0.00061
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.00202 0.00034 0.00029 0.00036
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.00201 0.00033 0.00027 0.00042
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.00197 0.00033 0.00029 0.00043
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.00193 0.00032 0.00028 0.00039
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.00193 0.00032 0.00028 0.00036
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.00187 0.00031 0.00028 0.00038
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.00181 0.00030 0.00026 0.00039
Organization::init() 6 0.00161 0.00027 0.00024 0.00033
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='MY', :stateCode='my-sgr') 1 0.00152 0.00152 0.00152 0.00152
system.db.CDbCommand.query(SELECT COUNT(*) FROM `cv_jobpos_group` `t`) 5 0.00133 0.00027 0.00023 0.00030
Controller::beforeAction() 1 0.00132 0.00132 0.00132 0.00132
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.00100 0.00033 0.00031 0.00036
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `job_vacancy`) 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00081 0.00027 0.00025 0.00030
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.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event`) 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `state`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2startup_stage`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2user`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 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=163) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2industry`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_owner`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00050 0.00050 0.00050 0.00050
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.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos_group`) 1 0.00049 0.00049 0.00049 0.00049
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='8clemu') 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00045 0.00045 0.00045 0.00045
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.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(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2persona`) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00040 0.00040 0.00040 0.00040
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 `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 `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.00037 0.00037 0.00037 0.00037
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.00036 0.00036 0.00036 0.00036
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.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='163') 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.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT i.*, s.code as metaStructureCode, s.datatype as metaStructureDataType, s.ref_table as metaStructureRefTable FROM `meta_item` as i LEFT JOIN meta_structure as s ON i.meta_structure_id=s.id WHERE s.ref_table='event' AND i.ref_id=63652) 1 0.00034 0.00034 0.00034 0.00034
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.00033 0.00033 0.00033 0.00033
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.00033 0.00033 0.00033 0.00033
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.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `event2startup_stage`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 1 0.00030 0.00030 0.00030 0.00030
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.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
Organization::behaviors() 7 0.00029 0.00004 0.00002 0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00029 0.00029 0.00029 0.00029
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.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `event`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `user`) 1 0.00028 0.00028 0.00028 0.00028
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.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `event_owner`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `state`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `country`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos_group`) 1 0.00022 0.00022 0.00022 0.00022
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.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `event2persona`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `event2industry`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00019 0.00019 0.00019 0.00019
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002