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

71 queries in 0.0550 second
Profiling Summary Report (Time: 0.13031s, Memory: 5,193KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.23273 0.11637 0.11625 0.11649
appRun 1 0.12129 0.12129 0.12129 0.12129
Organization::afterFind() 2 0.03980 0.01990 0.00461 0.03519
Controller::init() 1 0.00692 0.00692 0.00692 0.00692
Controller::beforeRender() 1 0.00347 0.00347 0.00347 0.00347
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00346 0.00346 0.00346 0.00346
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00206 0.00206 0.00206 0.00206
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00190 0.00190 0.00190 0.00190
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00182 0.00182 0.00182 0.00182
Controller::beforeAction() 1 0.00172 0.00172 0.00172 0.00172
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00138 0.00046 0.00027 0.00076
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00137 0.00137 0.00137 0.00137
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00124 0.00124 0.00124 0.00124
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00123 0.00123 0.00123 0.00123
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `challenge`) 1 0.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00117 0.00117 0.00117 0.00117
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00117 0.00117 0.00117 0.00117
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.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00110 0.00110 0.00110 0.00110
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00106 0.00106 0.00106 0.00106
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.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2challenge`) 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00089 0.00089 0.00089 0.00089
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.00088 0.00088 0.00088 0.00088
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00080 0.00080 0.00080 0.00080
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.00078 0.00078 0.00078 0.00078
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.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00076 0.00076 0.00076 0.00076
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.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00066 0.00066 0.00066 0.00066
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.00066 0.00066 0.00066 0.00066
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=1784686932) 1 0.00065 0.00065 0.00065 0.00065
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.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2challenge`) 1 0.00061 0.00061 0.00061 0.00061
Organization::init() 2 0.00060 0.00030 0.00030 0.00030
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.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT COUNT(*) FROM `challenge` `t`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00058 0.00058 0.00058 0.00058
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.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00057 0.00057 0.00057 0.00057
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.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00055 0.00055 0.00055 0.00055
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.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00053 0.00053 0.00053 0.00053
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.00053 0.00053 0.00053 0.00053
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.00048 0.00048 0.00048 0.00048
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.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `organization` `t` WHERE t.code=:code LIMIT 1. Bound with :code='6ea6ff9c-bca4-492c-8d0d-59a1f75a6878') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='3001') 1 0.00042 0.00042 0.00042 0.00042
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.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='3001') 1 0.00041 0.00041 0.00041 0.00041
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.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SHOW CREATE TABLE `challenge`) 1 0.00041 0.00041 0.00041 0.00041
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.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00036 0.00036 0.00036 0.00036
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.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 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.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00032 0.00032 0.00032 0.00032
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.00029 0.00029 0.00029 0.00029
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 `setting`) 1 0.00024 0.00024 0.00024 0.00024
Organization::behaviors() 3 0.00022 0.00007 0.00003 0.00015
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002