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.1055 second
Profiling Summary Report (Time: 0.19933s, Memory: 7,100KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.37078 0.18539 0.18530 0.18548
appRun 1 0.19094 0.19094 0.19094 0.19094
Organization::afterFind() 6 0.05247 0.00875 0.00284 0.03092
Controller::init() 1 0.00874 0.00874 0.00874 0.00874
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.00864 0.00054 0.00030 0.00095
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.00724 0.00045 0.00026 0.00085
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.00527 0.00088 0.00033 0.00297
Controller::beforeRender() 1 0.00460 0.00460 0.00460 0.00460
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.00342 0.00057 0.00030 0.00107
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.00339 0.00057 0.00027 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.00309 0.00052 0.00031 0.00104
system.db.CDbCommand.query(SELECT COUNT(*) FROM `cv_jobpos_group` `t`) 5 0.00304 0.00061 0.00024 0.00165
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.00294 0.00049 0.00034 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.00251 0.00042 0.00031 0.00052
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.00242 0.00040 0.00031 0.00050
Controller::beforeAction() 1 0.00202 0.00202 0.00202 0.00202
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.00192 0.00048 0.00042 0.00054
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.00177 0.00177 0.00177 0.00177
Organization::init() 6 0.00172 0.00029 0.00026 0.00031
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.00163 0.00163 0.00163 0.00163
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `job_vacancy`) 1 0.00158 0.00158 0.00158 0.00158
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00156 0.00156 0.00156 0.00156
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.00155 0.00052 0.00040 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00130 0.00130 0.00130 0.00130
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00120 0.00120 0.00120 0.00120
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00116 0.00116 0.00116 0.00116
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.00113 0.00113 0.00113 0.00113
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user`) 1 0.00111 0.00111 0.00111 0.00111
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.00108 0.00108 0.00108 0.00108
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event`) 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00102 0.00102 0.00102 0.00102
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2industry`) 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos_group`) 1 0.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member`) 1 0.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SHOW CREATE TABLE `job_vacancy`) 1 0.00091 0.00091 0.00091 0.00091
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.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_jobpos`) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `state`) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2persona`) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00081 0.00081 0.00081 0.00081
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.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00073 0.00024 0.00024 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `event`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00070 0.00070 0.00070 0.00070
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.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_owner`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00063 0.00063 0.00063 0.00063
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.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00062 0.00062 0.00062 0.00062
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.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='63652') 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2user`) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos`) 1 0.00055 0.00055 0.00055 0.00055
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.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 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.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2startup_stage`) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW CREATE TABLE `country`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00046 0.00046 0.00046 0.00046
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(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.00045 0.00045 0.00045 0.00045
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.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.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00042 0.00042 0.00042 0.00042
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.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.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='163') 1 0.00038 0.00038 0.00038 0.00038
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
Organization::behaviors() 7 0.00033 0.00005 0.00003 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `event2persona`) 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 `classification2organization`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `event_owner`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `user`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `state`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `event2industry`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_jobpos_group`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2user`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `event2startup_stage`) 1 0.00022 0.00022 0.00022 0.00022
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002