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

Home / MaGIC Activate / Challenges / Challenge

Media Prima Labs: Food App Challenge Featured

Do you have ideas or solutions to enhance and monetize our food discovery apps?

About the challenge

We have 2 food discovery apps built based on IP which has more than 10 years strong branding on our TV programs, namely Jalan Jalan Cari Makan, a Halal food discovery and Ho Chak!, a non-halal food discovery. These 2 food discovery apps curate restaurants and eateries around Malaysia and enable users to review and receive exclusive discounts.  

We are looking for value added functionality for our food discovery apps to enhance users engagement and retention, which would leads towards revenue generation. We are open for proposals, examples quoted as below (but not limited to):

  • rewards/deals on app
  • restaurants recommender and reviews
  • fulfillment and logistics

Prize

  • Pilot contract to implement the solution(s) and prove the concept
  • Partnership with Media Prima with access to market
  • Pitching your solution to Media Prima Digital, including a business matching day with other corporates and investors;
  • Mentorship and coaching from Media Prima Digital
  • Access to the Media Prima’s business network.
  • Media coverage and publicity

Criteria / Eligibility

  • Company with maturity in market above 1 year.
  • Able to demonstrate established contents OR proven functionality/prototype
  • Have paying customers
  • If selected, able to be available on-site to work together with MP’s stakeholders to launch your pilot within the organization
  • Able to realize a usable product or service within the next 6 months

Timeline

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

Media Prima Labs
https://www.mediaprimalabs.com/

Media Prima Digital spearheads innovation, digital marketing and technology within the Media Prima Group via an integrated and agile approach.

Media Prima Labs (MPLabs), one of the initiative under Digital arm is to extend our IP’s into mobile technology innovations and games to enrich consumer’s lifestyle.

Aside from developing mobile products for Media Prima’s group of companies, MPLabs also welcomes existing and new idea or product from the public, it aims to accelerate and help to materialise these ideas through strategic partnerships not only on technology and development investment but also leveraging on Media Prima’s mass audience reach via multiple platforms namely TV, radio, print and outdoor, in addition to its experienced content creation arm to promote and push the final product.

 

0
day(s) left
Media Prima Labs
Reward
User Engagement
App Enhancement

Pilot contract

70 queries in 0.0363 second
Profiling Summary Report (Time: 0.11675s, Memory: 5,195KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.20768 0.10384 0.10374 0.10394
appRun 1 0.10915 0.10915 0.10915 0.10915
Organization::afterFind() 2 0.02214 0.01107 0.00436 0.01777
Controller::init() 1 0.00821 0.00821 0.00821 0.00821
Controller::beforeRender() 1 0.00377 0.00377 0.00377 0.00377
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `challenge`) 1 0.00286 0.00286 0.00286 0.00286
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00169 0.00169 0.00169 0.00169
Controller::beforeAction() 1 0.00137 0.00137 0.00137 0.00137
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00114 0.00114 0.00114 0.00114
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00104 0.00035 0.00027 0.00047
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.00084 0.00084 0.00084 0.00084
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.00082 0.00082 0.00082 0.00082
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`=23)) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00061 0.00061 0.00061 0.00061
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='23') 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=3001) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00059 0.00059 0.00059 0.00059
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 ('Reward', ' User Engagement', ' App Enhancement')) AND (`ac`.`id` NOT LIKE '23')) 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=1792483304) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00054 0.00054 0.00054 0.00054
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.00054 0.00054 0.00054 0.00054
Organization::init() 2 0.00053 0.00027 0.00026 0.00027
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00053 0.00053 0.00053 0.00053
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='3001') 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00052 0.00052 0.00052 0.00052
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.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2challenge`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00049 0.00049 0.00049 0.00049
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='3001', :status='approved') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW CREATE TABLE `challenge`) 1 0.00048 0.00048 0.00048 0.00048
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.00047 0.00047 0.00047 0.00047
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.00046 0.00046 0.00046 0.00046
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='23') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT COUNT(*) FROM `challenge` `t`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00044 0.00044 0.00044 0.00044
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.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 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='3001') 1 0.00039 0.00039 0.00039 0.00039
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.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='3001') 1 0.00037 0.00037 0.00037 0.00037
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='3001') 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00037 0.00037 0.00037 0.00037
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='3001') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00035 0.00035 0.00035 0.00035
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='3001') 1 0.00034 0.00034 0.00034 0.00034
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='3001') 1 0.00034 0.00034 0.00034 0.00034
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='3001') 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 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='3001') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00030 0.00030 0.00030 0.00030
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
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2challenge`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00023 0.00023 0.00023 0.00023
Organization::behaviors() 3 0.00023 0.00008 0.00003 0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00022 0.00022 0.00022 0.00022
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001