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 citizenin 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

71 queries in 0.0344 second
Profiling Summary Report (Time: 0.10494s, Memory: 5,180KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.18977 0.09489 0.09479 0.09498
appRun 1 0.09834 0.09834 0.09834 0.09834
Organization::afterFind() 2 0.02363 0.01181 0.00324 0.02039
Controller::init() 1 0.00403 0.00403 0.00403 0.00403
Controller::beforeRender() 1 0.00327 0.00327 0.00327 0.00327
Controller::beforeAction() 1 0.00239 0.00239 0.00239 0.00239
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `challenge`) 1 0.00135 0.00135 0.00135 0.00135
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00131 0.00131 0.00131 0.00131
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.query(SELECT COUNT(*) FROM `challenge` `t`) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW CREATE TABLE `challenge`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00065 0.00022 0.00021 0.00023
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.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00064 0.00064 0.00064 0.00064
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 `organization_alternative_name`) 1 0.00062 0.00062 0.00062 0.00062
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.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2challenge`) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00056 0.00056 0.00056 0.00056
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.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00053 0.00053 0.00053 0.00053
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=1776152077) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00048 0.00048 0.00048 0.00048
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.00047 0.00047 0.00047 0.00047
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.00046 0.00046 0.00046 0.00046
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.00045 0.00045 0.00045 0.00045
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.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00045 0.00045 0.00045 0.00045
Organization::init() 2 0.00044 0.00022 0.00021 0.00022
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.00043 0.00043 0.00043 0.00043
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.00042 0.00042 0.00042 0.00042
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.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00041 0.00041 0.00041 0.00041
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.00041 0.00041 0.00041 0.00041
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.00040 0.00040 0.00040 0.00040
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.00040 0.00040 0.00040 0.00040
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.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.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00037 0.00037 0.00037 0.00037
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.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='2999') 1 0.00033 0.00033 0.00033 0.00033
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.00033 0.00033 0.00033 0.00033
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.00033 0.00033 0.00033 0.00033
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.00031 0.00031 0.00031 0.00031
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.00031 0.00031 0.00031 0.00031
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.00030 0.00030 0.00030 0.00030
Organization::behaviors() 3 0.00028 0.00009 0.00003 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2challenge`) 1 0.00028 0.00028 0.00028 0.00028
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.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00022 0.00022 0.00022 0.00022
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001