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

Home / MaGIC Activate / Challenges / Challenge

TM: REinvent Beyond Connectivity Featured

Are you ready to create change? Join us on our way towards our aspiration to offer Malaysians the full benefits of a convergence lifestyle – the ability to stay connected with the world of information and entertainment, and with friends as well as business, no matter where or when, or on whatever device.

About the challenge

Convergence to us is more than having the technology or infrastructure that allows for converged solutions; rather it is about enabling a high-quality experience whenever customers use TM to access internet, data and application services, wherever they are and whatever device they employ. In other words; convergence is part of the customer value proposition that we aspire to deliver, which we are realising by further expanding our reach and coverage; making available higher speeds and seamless broadband connection; with mobility, content and smart solutions; to fulfil our customers’ lifestyle and business needs.

We are exploring collaborative opportunities with innovative startups targeting Consumer, SME, Enterprise, Government in the following areas (but not limited to):

  • Digital business solution (SaaS, Advertising, Cloud, etc)
  • Smart solutions (Home, Office, City)
  • Creative content
  • AR/VR

At the same time, we are opening TM Developer sandbox, a safe and secure virtual space to learn, develop, test and showcase new ideas. Essentially, a developer platform, the sandbox enables experimentation, incubation and prototyping of ideas and innovative solution.

Our current APIs categories are as below:

  • Communication
  • Maps
  • Payment
  • Authentication
  • Digital signing

(sandbox is accessible from developer.tm.com.my)

Prize

  • Partnership with TM group of companies
  • Access to TM’s business network
  • Joint go-to-market
  • Co-working space
  • Mentorship and coaching from RE: innovation team

Criteria / Eligibility

  • Able to demonstrate established content/solutions
  • Have paying customers
  • Possess the capabilities and strategy to support and scale the product(s)

Timeline

  • Date Start: 2017 Jun 09
  • Date End: 2017 Jul 31

RE:
https://www.tm.com.my/re

RE: was set up in 2014 to catalyze innovative culture and entrepreneurship within TM and capitalize on market opportunities through engagement with promising start-ups and enter into partnerships with leading innovators. Via these collaborations, we have been able to invest in and adopt various new technologies that are driving greater efficiencies within TM.

0
day(s) left
RE:
IoT
App
AR/VR
Software
Artificial Intelligence
Creative

Market access

39 queries in 0.0683 second
Profiling Summary Report (Time: 0.35248s, Memory: 5,222KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.58137 0.29069 0.29061 0.29076
appRun 1 0.32899 0.32899 0.32899 0.32899
Controller::init() 1 0.03288 0.03288 0.03288 0.03288
Organization::afterFind() 2 0.02726 0.01363 0.01230 0.01497
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`owner_organization_id` AS `t0_c1`, `t`.`creator_user_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`text_short_description` AS `t0_c4`, `t`.`html_content` AS `t0_c5`, `t`.`image_cover` AS `t0_c6`, `t`.`image_header` AS `t0_c7`, `t`.`url_video` AS `t0_c8`, `t`.`url_application_form` AS `t0_c9`, `t`.`application_form_id` AS `t0_c10`, `t`.`html_deliverable` AS `t0_c11`, `t`.`html_criteria` AS `t0_c12`, `t`.`prize_title` AS `t0_c13`, `t`.`html_prize_detail` AS `t0_c14`, `t`.`date_open` AS `t0_c15`, `t`.`date_close` AS `t0_c16`, `t`.`ordering` AS `t0_c17`, `t`.`text_remark` AS `t0_c18`, `t`.`text_note` AS `t0_c19`, `t`.`json_extra` AS `t0_c20`, `t`.`status` AS `t0_c21`, `t`.`timezone` AS `t0_c22`, `t`.`is_active` AS `t0_c23`, `t`.`is_publish` AS `t0_c24`, `t`.`is_highlight` AS `t0_c25`, `t`.`process_by` AS `t0_c26`, `t`.`date_submit` AS `t0_c27`, `t`.`date_process` AS `t0_c28`, `t`.`date_added` AS `t0_c29`, `t`.`date_modified` AS `t0_c30`, `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 `challenge` `t` LEFT OUTER JOIN `organization` `ownerOrganization` ON (`t`.`owner_organization_id`=`ownerOrganization`.`id`) WHERE (`t`.`id`=28)) 1 0.00711 0.00711 0.00711 0.00711
Controller::beforeRender() 1 0.00630 0.00630 0.00630 0.00630
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `challenge`) 1 0.00620 0.00620 0.00620 0.00620
system.db.CDbCommand.query(SELECT `ac`.`id` FROM `tag` `t` JOIN `tag2challenge` `tac` ON t.id=tac.tag_id JOIN `challenge` `ac` ON ac.id=tac.challenge_id WHERE ((`t`.`name` IN ('IoT', ' App', ' AR/VR', ' Software', ' Artificial Intelligence', ' Creative')) AND (`ac`.`id` NOT LIKE '28')) AND (ac.is_active=1 AND ac.status="approved" AND ac.date_open<=:date AND ac.date_close>=:date AND ac.is_publish=1) LIMIT 2. Bound with :date=1784688304) 1 0.00538 0.00538 0.00538 0.00538
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00447 0.00447 0.00447 0.00447
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2challenge et ON t.id = et.tag_id WHERE et.challenge_id = :ownerid . Bound with :ownerid='28') 1 0.00415 0.00415 0.00415 0.00415
system.db.CDbCommand.query(SELECT `impacts`.`id` AS `t1_c0`, `impacts`.`code` AS `t1_c1`, `impacts`.`title` AS `t1_c2`, `impacts`.`image_cover` AS `t1_c3`, `impacts`.`is_active` AS `t1_c4`, `impacts`.`date_added` AS `t1_c5`, `impacts`.`date_modified` AS `t1_c6` FROM `impact` `impacts` INNER JOIN `impact2organization` `impacts_impacts` ON (`impacts_impacts`.`organization_id`=:ypl0) AND (`impacts`.`id`=`impacts_impacts`.`impact_id`). Bound with :ypl0='163') 1 0.00272 0.00272 0.00272 0.00272
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00256 0.00256 0.00256 0.00256
system.db.CDbCommand.query(SELECT `personas`.`id` AS `t1_c0`, `personas`.`code` AS `t1_c1`, `personas`.`slug` AS `t1_c2`, `personas`.`title` AS `t1_c3`, `personas`.`text_short_description` AS `t1_c4`, `personas`.`is_active` AS `t1_c5`, `personas`.`date_added` AS `t1_c6`, `personas`.`date_modified` AS `t1_c7`, `personas`.`title_en` AS `t1_c8`, `personas`.`title_ms` AS `t1_c9`, `personas`.`text_short_description_en` AS `t1_c10`, `personas`.`text_short_description_ms` AS `t1_c11` FROM `persona` `personas` INNER JOIN `persona2organization` `personas_personas` ON (`personas_personas`.`organization_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='163') 1 0.00252 0.00252 0.00252 0.00252
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`owner_organization_id` AS `t0_c1`, `t`.`creator_user_id` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`text_short_description` AS `t0_c4`, `t`.`html_content` AS `t0_c5`, `t`.`image_cover` AS `t0_c6`, `t`.`image_header` AS `t0_c7`, `t`.`url_video` AS `t0_c8`, `t`.`url_application_form` AS `t0_c9`, `t`.`application_form_id` AS `t0_c10`, `t`.`html_deliverable` AS `t0_c11`, `t`.`html_criteria` AS `t0_c12`, `t`.`prize_title` AS `t0_c13`, `t`.`html_prize_detail` AS `t0_c14`, `t`.`date_open` AS `t0_c15`, `t`.`date_close` AS `t0_c16`, `t`.`ordering` AS `t0_c17`, `t`.`text_remark` AS `t0_c18`, `t`.`text_note` AS `t0_c19`, `t`.`json_extra` AS `t0_c20`, `t`.`status` AS `t0_c21`, `t`.`timezone` AS `t0_c22`, `t`.`is_active` AS `t0_c23`, `t`.`is_publish` AS `t0_c24`, `t`.`is_highlight` AS `t0_c25`, `t`.`process_by` AS `t0_c26`, `t`.`date_submit` AS `t0_c27`, `t`.`date_process` AS `t0_c28`, `t`.`date_added` AS `t0_c29`, `t`.`date_modified` AS `t0_c30`, `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 `challenge` `t` LEFT OUTER JOIN `organization` `ownerOrganization` ON (`t`.`owner_organization_id`=`ownerOrganization`.`id`) WHERE (0=1)) 1 0.00225 0.00225 0.00225 0.00225
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='3003') 1 0.00209 0.00209 0.00209 0.00209
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='3003', :status='approved') 1 0.00191 0.00191 0.00191 0.00191
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00175 0.00175 0.00175 0.00175
system.db.CDbCommand.query(SELECT `organizationAlternativeNames`.`id` AS `t1_c0`, `organizationAlternativeNames`.`organization_id` AS `t1_c1`, `organizationAlternativeNames`.`title` AS `t1_c2`, `organizationAlternativeNames`.`date_added` AS `t1_c3`, `organizationAlternativeNames`.`date_modified` AS `t1_c4` FROM `organization_alternative_name` `organizationAlternativeNames` WHERE (`organizationAlternativeNames`.`organization_id`=:ypl0). Bound with :ypl0='163') 1 0.00163 0.00163 0.00163 0.00163
system.db.CDbCommand.query(SELECT COUNT(*) FROM `challenge` `t`) 1 0.00159 0.00159 0.00159 0.00159
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='3003') 1 0.00142 0.00142 0.00142 0.00142
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='3003') 1 0.00141 0.00141 0.00141 0.00141
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00141 0.00141 0.00141 0.00141
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='3003') 1 0.00128 0.00128 0.00128 0.00128
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00120 0.00040 0.00033 0.00051
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='3003') 1 0.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00110 0.00110 0.00110 0.00110
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2challenge`) 1 0.00106 0.00106 0.00106 0.00106
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.00106 0.00106 0.00106 0.00106
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='3003') 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SELECT `industries`.`id` AS `t1_c0`, `industries`.`code` AS `t1_c1`, `industries`.`slug` AS `t1_c2`, `industries`.`title` AS `t1_c3`, `industries`.`is_active` AS `t1_c4`, `industries`.`date_added` AS `t1_c5`, `industries`.`date_modified` AS `t1_c6`, `industries`.`title_en` AS `t1_c7`, `industries`.`title_ms` AS `t1_c8` FROM `industry` `industries` INNER JOIN `industry2organization` `industries_industries` ON (`industries_industries`.`organization_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='163') 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='3003') 1 0.00095 0.00095 0.00095 0.00095
Controller::beforeAction() 1 0.00094 0.00094 0.00094 0.00094
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 `industry2challenge` `industries_industries` ON (`industries_industries`.`challenge_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='28') 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW CREATE TABLE `challenge`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2organization et ON t.id = et.tag_id WHERE et.organization_id = :ownerid . Bound with :ownerid='163') 1 0.00082 0.00082 0.00082 0.00082
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=3003) 1 0.00078 0.00078 0.00078 0.00078
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.00077 0.00077 0.00077 0.00077
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='3003') 1 0.00073 0.00073 0.00073 0.00073
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='3003') 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT `classifications`.`id` AS `t1_c0`, `classifications`.`slug` AS `t1_c1`, `classifications`.`code` AS `t1_c2`, `classifications`.`group_code` AS `t1_c3`, `classifications`.`group_en` AS `t1_c4`, `classifications`.`group_ms` AS `t1_c5`, `classifications`.`title_en` AS `t1_c6`, `classifications`.`title_ms` AS `t1_c7`, `classifications`.`text_short_description_en` AS `t1_c8`, `classifications`.`text_short_description_ms` AS `t1_c9`, `classifications`.`is_active` AS `t1_c10`, `classifications`.`date_added` AS `t1_c11`, `classifications`.`date_modified` AS `t1_c12` FROM `classification` `classifications` INNER JOIN `classification2organization` `classifications_classifications` ON (`classifications_classifications`.`organization_id`=:ypl0) AND (`classifications`.`id`=`classifications_classifications`.`classification_id`). Bound with :ypl0='163') 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT `sdgs`.`id` AS `t1_c0`, `sdgs`.`code` AS `t1_c1`, `sdgs`.`title` AS `t1_c2`, `sdgs`.`text_short_description` AS `t1_c3`, `sdgs`.`image_cover` AS `t1_c4`, `sdgs`.`is_active` AS `t1_c5`, `sdgs`.`date_added` AS `t1_c6`, `sdgs`.`date_modified` AS `t1_c7` FROM `sdg` `sdgs` INNER JOIN `sdg2organization` `sdgs_sdgs` ON (`sdgs_sdgs`.`organization_id`=:ypl0) AND (`sdgs`.`id`=`sdgs_sdgs`.`sdg_id`). Bound with :ypl0='163') 1 0.00052 0.00052 0.00052 0.00052
Organization::init() 2 0.00039 0.00020 0.00018 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2challenge`) 1 0.00030 0.00030 0.00030 0.00030
Organization::behaviors() 3 0.00017 0.00006 0.00004 0.00010
WebApplication::createController::override 1 0.00005 0.00005 0.00005 0.00005