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

Home / MaGIC Activate / Challenges / Challenge

IJM: Smart Living for Future Citizen Featured

With more and more people connected in the digital era where technologies are becoming more affordable and available, how do we leverage on them to improve the quality of lives of the future citizen?

About the challenge

What is the impact of digital revolution on modern living? How does the use of technology enhance the quality of life?  We are looking for innovations and start-ups with solutions to redefine modern living and enhance overall quality of lives for future citizen, in the area of accessibility, security and sustainable living.  This is a great opportunity for you to work with one of the top players in property development and construction in the region.

 The expected deliverables from successful applicant include:

  • Blueprints
  • Strategies
  • Working prototype for digital application or IoT devices that can be piloted in 6 months

Prize

  • Co-develop your solution with our internal expertise
  • Opportunity for a pilot contract with a reputable property and construction player
  • Gain access to further investment from IJM Corporation to extend the innovation to the other businesses within the Group

Criteria / Eligibility

  • Have a working prototype to pilot your solutions in 6 months
  • Your start-up have a professional conduct and high integrity in your dealings with all stakeholders
  • You should be able to pitch face-to-face on the proposed time period

Timeline

  • Date Start: 2017 Jun 09
  • Date End: 2017 Aug 15

IJM
http://www.ijm.com

IJM is one of the Malaysia’s most valuable and biggest conglomerates, with its endeavours in construction, property development, manufacturing and quarrying, infrastructure concessions and plantations. Through its diversified business interests, IJM looked to harness synergy – leveraging on the combined strengths of its business operations and enviable track record deliver positive transformation to nation-building.

It has built thousands of kilometres of roads, highways and bridges, infrastructure that is vital for the growth and development of a nation. It takes pride in building properties for families, businesses and communities that resonate with them.  It has set the benchmark for lifestyle developments that have provided the yardstick for others.

Listed on the Main Board of Bursa Malaysia Securities Berhad with a market capitalisation exceeding RM12 billion and total assets of RM20.5 billion, IJM has progressively grown over 30 years into a global company with prominent market presence spanning 10 countries including Malaysia, India, United Arab Emirates, China and Indonesia.

The Group’s belief in a shared destiny with its workforce of 4,600 employees remains pivotal to its growing success. IJM remains committed to ethical business conducts and subscribes to the principles of good.

0
day(s) left
IJM
IoT

Pilot contract

62 queries in 0.0464 second
Profiling Summary Report (Time: 0.17647s, Memory: 5,205KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.30320 0.15160 0.15155 0.15165
appRun 1 0.15898 0.15898 0.15898 0.15898
Organization::afterFind() 2 0.03338 0.01669 0.00722 0.02615
Controller::beforeAction() 1 0.00783 0.00783 0.00783 0.00783
Controller::init() 1 0.00573 0.00573 0.00573 0.00573
Controller::beforeRender() 1 0.00559 0.00559 0.00559 0.00559
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00243 0.00243 0.00243 0.00243
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='2999') 1 0.00207 0.00207 0.00207 0.00207
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00186 0.00062 0.00039 0.00094
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.00177 0.00177 0.00177 0.00177
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00151 0.00151 0.00151 0.00151
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='2999') 1 0.00148 0.00148 0.00148 0.00148
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')) AND (`ac`.`id` NOT LIKE '20')) 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=1784688344) 1 0.00122 0.00122 0.00122 0.00122
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.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00113 0.00113 0.00113 0.00113
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00101 0.00101 0.00101 0.00101
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2challenge`) 1 0.00100 0.00100 0.00100 0.00100
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='2999') 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00096 0.00096 0.00096 0.00096
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.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00094 0.00094 0.00094 0.00094
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`=20)) 1 0.00090 0.00090 0.00090 0.00090
Organization::init() 2 0.00086 0.00043 0.00035 0.00051
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00084 0.00084 0.00084 0.00084
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='20') 1 0.00082 0.00082 0.00082 0.00082
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.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00082 0.00082 0.00082 0.00082
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='2999') 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SELECT COUNT(*) FROM `challenge` `t`) 1 0.00075 0.00075 0.00075 0.00075
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='2999') 1 0.00072 0.00072 0.00072 0.00072
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.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00063 0.00063 0.00063 0.00063
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.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00060 0.00060 0.00060 0.00060
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=2999) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2challenge`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00054 0.00054 0.00054 0.00054
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.00053 0.00053 0.00053 0.00053
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='2999') 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00044 0.00044 0.00044 0.00044
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='2999', :status='approved') 1 0.00043 0.00043 0.00043 0.00043
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.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='2999') 1 0.00039 0.00039 0.00039 0.00039
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.00038 0.00038 0.00038 0.00038
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='20') 1 0.00036 0.00036 0.00036 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='2999') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00032 0.00032 0.00032 0.00032
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='2999') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00023 0.00023 0.00023 0.00023
Organization::behaviors() 3 0.00019 0.00006 0.00003 0.00013
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002