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

Home / Network / Direct lending Sdn Bhd

98 visited

Direct lending Sdn Bhd MaGIC Alumni 

Login to View

Public Disclosed Funding 
Malaysia https://www.directlending.com.my/ Active
Organization Description
Online personal lending platform - faster, simpler, safer dan more affordable

Organization Profile

Team Members
image
Hui Yik Seong
Founder
image
Lim Soon Tak
Founder

Participated Programs

Grill Or Chill - Startup 2016-10

2016 MaGIC Cyberjaya

MaGIC Co-Working space 2016-9

2016 MaGIC Cyberjaya

Stanford Go2Market Batch 3

2017 MaGIC Cyberjaya

GAP Cohort 1

2017 MaGIC Cyberjaya

Available Job Vacancy

No results found.
 

Embed into your website

Hello, proud MaGIC Alumni! Copy the HTML code below and paste it into your website

<embed src="https://hub.mymagic.my/magicOps/alumni/embed/915" width="380px" height="100px" />
238 queries in 0.1269 second
Profiling Summary Report (Time: 0.25472s, Memory: 7,922KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.48241 0.24121 0.24116 0.24125
appRun 1 0.24615 0.24615 0.24615 0.24615
Organization::afterFind() 10 0.07105 0.00711 0.00378 0.02704
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') 8 0.00908 0.00114 0.00040 0.00587
Organization::init() 10 0.00511 0.00051 0.00037 0.00129
Controller::init() 1 0.00486 0.00486 0.00486 0.00486
Controller::beforeRender() 1 0.00464 0.00464 0.00464 0.00464
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') 8 0.00407 0.00051 0.00039 0.00060
system.db.CDbCommand.query(SELECT `sdgs`.`id` AS `t1_c0`, `sdgs`.`code` AS `t1_c1`, `sdgs`.`title` AS `t1_c2`, `sdgs`.`text_short_description` AS `t1_c3`, `sdgs`.`image_cover` AS `t1_c4`, `sdgs`.`is_active` AS `t1_c5`, `sdgs`.`date_added` AS `t1_c6`, `sdgs`.`date_modified` AS `t1_c7` FROM `sdg` `sdgs` INNER JOIN `sdg2organization` `sdgs_sdgs` ON (`sdgs_sdgs`.`organization_id`=:ypl0) AND (`sdgs`.`id`=`sdgs_sdgs`.`sdg_id`). Bound with :ypl0='163') 8 0.00394 0.00049 0.00038 0.00076
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') 8 0.00356 0.00045 0.00039 0.00058
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') 8 0.00341 0.00043 0.00040 0.00048
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') 8 0.00340 0.00042 0.00039 0.00051
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') 8 0.00321 0.00040 0.00037 0.00044
system.db.CDbCommand.query(SELECT `organization`.`id` AS `t1_c0`, `organization`.`code` AS `t1_c1`, `organization`.`slug` AS `t1_c2`, `organization`.`title` AS `t1_c3`, `organization`.`text_oneliner` AS `t1_c4`, `organization`.`html_content` AS `t1_c5`, `organization`.`text_short_description` AS `t1_c6`, `organization`.`legalform_id` AS `t1_c7`, `organization`.`company_number` AS `t1_c8`, `organization`.`image_logo` AS `t1_c9`, `organization`.`url_website` AS `t1_c10`, `organization`.`email_contact` AS `t1_c11`, `organization`.`timezone` AS `t1_c12`, `organization`.`year_founded` AS `t1_c13`, `organization`.`is_active` AS `t1_c14`, `organization`.`date_added` AS `t1_c15`, `organization`.`date_modified` AS `t1_c16`, `organization`.`legal_name` AS `t1_c17`, `organization`.`full_address` AS `t1_c18`, `organization`.`address_line1` AS `t1_c19`, `organization`.`address_line2` AS `t1_c20`, `organization`.`address_zip` AS `t1_c21`, `organization`.`address_city` AS `t1_c22`, `organization`.`address_state` AS `t1_c23`, `organization`.`address_country_code` AS `t1_c24`, `organization`.`latlong_address` AS `t1_c25`, `organization`.`startup_stage_id` AS `t1_c26`, `organization`.`score_completeness` AS `t1_c27`, `organization`.`latest_status` AS `t1_c28`, `organization`.`total_revenue` AS `t1_c29`, `organization`.`total_funding` AS `t1_c30`, `organization`.`total_funding_disclosed` AS `t1_c31`, `organization`.`total_funding_publicized` AS `t1_c32`, `organization`.`latest_funding_round_ordering` AS `t1_c33`, `organization`.`latest_funding_round` AS `t1_c34`, ST_AsText(`organization`.`latlong_address`) AS organization_latlong_address FROM `organization` `organization` WHERE (`organization`.`code`=:ypl0). Bound with :ypl0='6ea6ff9c-bca4-492c-8d0d-59a1f75a6878') 4 0.00314 0.00079 0.00057 0.00133
Controller::beforeAction() 1 0.00215 0.00215 0.00215 0.00215
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') 3 0.00156 0.00052 0.00049 0.00056
system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') 3 0.00148 0.00049 0.00036 0.00076
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00116 0.00116 0.00116 0.00116
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00106 0.00035 0.00032 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00101 0.00101 0.00101 0.00101
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2persona`) 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_group`) 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2event_group`) 1 0.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `cv_portfolio`) 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SELECT `eventOwners`.`id` AS `t1_c0`, `eventOwners`.`event_code` AS `t1_c1`, `eventOwners`.`event_id` AS `t1_c2`, `eventOwners`.`organization_code` AS `t1_c3`, `eventOwners`.`organization_id` AS `t1_c4`, `eventOwners`.`department` AS `t1_c5`, `eventOwners`.`date_added` AS `t1_c6`, `eventOwners`.`date_modified` AS `t1_c7`, `eventOwners`.`as_role_code` AS `t1_c8` FROM `event_owner` `eventOwners` WHERE (`eventOwners`.`event_code`=:ypl0). Bound with :ypl0='b102754d-1ad0-11e8-b097-064817b8db8a') 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2industry`) 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country`) 1 0.00088 0.00088 0.00088 0.00088
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_category`) 1 0.00087 0.00087 0.00087 0.00087
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=108) 1 0.00086 0.00086 0.00086 0.00086
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 `event2persona` `personas_personas` ON (`personas_personas`.`event_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='15582') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_geofocus`) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_category`) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `job_vacancy`) 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event`) 1 0.00074 0.00074 0.00074 0.00074
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='915') 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource`) 1 0.00074 0.00074 0.00074 0.00074
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='108') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `product`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2event_group`) 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SELECT cv.* FROM `individual2email` as i2e LEFT JOIN individual as i ON i.id=i2e.individual_id INNER JOIN user as u ON u.username=i2e.user_email LEFT JOIN cv_portfolio as cv ON cv.user_id = u.id WHERE i2e.is_verify=1 AND i.is_active=1 AND u.is_active=1 AND cv.slug IS NOT NULL AND cv.visibility='public' AND i.id=:individualId. Bound with :individualId='4319') 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_owner`) 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SELECT `startupStages`.`id` AS `t1_c0`, `startupStages`.`code` AS `t1_c1`, `startupStages`.`slug` AS `t1_c2`, `startupStages`.`title` AS `t1_c3`, `startupStages`.`text_short_description` AS `t1_c4`, `startupStages`.`ordering` AS `t1_c5`, `startupStages`.`is_active` AS `t1_c6`, `startupStages`.`date_added` AS `t1_c7`, `startupStages`.`date_modified` AS `t1_c8`, `startupStages`.`title_en` AS `t1_c9`, `startupStages`.`title_ms` AS `t1_c10`, `startupStages`.`text_short_description_en` AS `t1_c11`, `startupStages`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStages` INNER JOIN `resource2startup_stage` `startupStages_startupStages` ON (`startupStages_startupStages`.`resource_id`=:ypl0) AND (`startupStages`.`id`=`startupStages_startupStages`.`startup_stage_id`). Bound with :ypl0='2694') 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00069 0.00069 0.00069 0.00069
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=915) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SELECT `organizations`.`id` AS `t1_c0`, `organizations`.`code` AS `t1_c1`, `organizations`.`slug` AS `t1_c2`, `organizations`.`title` AS `t1_c3`, `organizations`.`text_oneliner` AS `t1_c4`, `organizations`.`html_content` AS `t1_c5`, `organizations`.`text_short_description` AS `t1_c6`, `organizations`.`legalform_id` AS `t1_c7`, `organizations`.`company_number` AS `t1_c8`, `organizations`.`image_logo` AS `t1_c9`, `organizations`.`url_website` AS `t1_c10`, `organizations`.`email_contact` AS `t1_c11`, `organizations`.`timezone` AS `t1_c12`, `organizations`.`year_founded` AS `t1_c13`, `organizations`.`is_active` AS `t1_c14`, `organizations`.`date_added` AS `t1_c15`, `organizations`.`date_modified` AS `t1_c16`, `organizations`.`legal_name` AS `t1_c17`, `organizations`.`full_address` AS `t1_c18`, `organizations`.`address_line1` AS `t1_c19`, `organizations`.`address_line2` AS `t1_c20`, `organizations`.`address_zip` AS `t1_c21`, `organizations`.`address_city` AS `t1_c22`, `organizations`.`address_state` AS `t1_c23`, `organizations`.`address_country_code` AS `t1_c24`, `organizations`.`latlong_address` AS `t1_c25`, `organizations`.`startup_stage_id` AS `t1_c26`, `organizations`.`score_completeness` AS `t1_c27`, `organizations`.`latest_status` AS `t1_c28`, `organizations`.`total_revenue` AS `t1_c29`, `organizations`.`total_funding` AS `t1_c30`, `organizations`.`total_funding_disclosed` AS `t1_c31`, `organizations`.`total_funding_publicized` AS `t1_c32`, `organizations`.`latest_funding_round_ordering` AS `t1_c33`, `organizations`.`latest_funding_round` AS `t1_c34`, ST_AsText(`organizations`.`latlong_address`) AS organizations_latlong_address FROM `organization` `organizations` INNER JOIN `resource2organization` `organizations_organizations` ON (`organizations_organizations`.`resource_id`=:ypl0) AND (`organizations`.`id`=`organizations_organizations`.`organization_id`). Bound with :ypl0='2694') 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `campus_member2organization`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) 1 0.00067 0.00067 0.00067 0.00067
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.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ekyc_company`) 1 0.00066 0.00066 0.00066 0.00066
Organization::behaviors() 12 0.00066 0.00006 0.00003 0.00018
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_geofocus`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2startup_stage`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2organization`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `individual`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00062 0.00062 0.00062 0.00062
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='individual' AND i.ref_id=4320) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `individual_organization`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2persona`) 1 0.00062 0.00062 0.00062 0.00062
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='event' AND i.ref_id=15582) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2startup_stage`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT `eventGroup`.`id` AS `t1_c0`, `eventGroup`.`code` AS `t1_c1`, `eventGroup`.`title` AS `t1_c2`, `eventGroup`.`image_cover` AS `t1_c3`, `eventGroup`.`text_oneliner` AS `t1_c4`, `eventGroup`.`text_short_description` AS `t1_c5`, `eventGroup`.`url_website` AS `t1_c6`, `eventGroup`.`slug` AS `t1_c7`, `eventGroup`.`genre` AS `t1_c8`, `eventGroup`.`funnel` AS `t1_c9`, `eventGroup`.`date_started` AS `t1_c10`, `eventGroup`.`date_ended` AS `t1_c11`, `eventGroup`.`is_active` AS `t1_c12`, `eventGroup`.`json_extra` AS `t1_c13`, `eventGroup`.`date_added` AS `t1_c14`, `eventGroup`.`date_modified` AS `t1_c15`, `eventGroup`.`department` AS `t1_c16`, `eventGroup`.`participant_type` AS `t1_c17`, `eventGroup`.`group_category` AS `t1_c18` FROM `event_group` `eventGroup` WHERE (`eventGroup`.`code`=:ypl0). Bound with :ypl0='0ae77bf5-0ef1-4d2e-b889-f2bd8545bdf5') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00058 0.00058 0.00058 0.00058
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 `resource2persona` `personas_personas` ON (`personas_personas`.`resource_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='2694') 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SELECT `event`.`id` AS `t1_c0`, `event`.`code` AS `t1_c1`, `event`.`event_group_code` AS `t1_c2`, `event`.`event_group_id` AS `t1_c3`, `event`.`title` AS `t1_c4`, `event`.`text_short_desc` AS `t1_c5`, `event`.`url_website` AS `t1_c6`, `event`.`date_started` AS `t1_c7`, `event`.`date_ended` AS `t1_c8`, `event`.`is_paid_event` AS `t1_c9`, `event`.`genre` AS `t1_c10`, `event`.`funnel` AS `t1_c11`, `event`.`vendor` AS `t1_c12`, `event`.`vendor_code` AS `t1_c13`, `event`.`at` AS `t1_c14`, `event`.`address_country_code` AS `t1_c15`, `event`.`address_state_code` AS `t1_c16`, `event`.`full_address` AS `t1_c17`, `event`.`latlong_address` AS `t1_c18`, `event`.`email_contact` AS `t1_c19`, `event`.`is_cancelled` AS `t1_c20`, `event`.`is_active` AS `t1_c21`, `event`.`is_for_reporting` AS `t1_c22`, `event`.`json_original` AS `t1_c23`, `event`.`json_extra` AS `t1_c24`, `event`.`date_added` AS `t1_c25`, `event`.`date_modified` AS `t1_c26`, `event`.`is_survey_enabled` AS `t1_c27`, `event`.`address_line1` AS `t1_c28`, `event`.`address_line2` AS `t1_c29`, `event`.`address_zip` AS `t1_c30`, `event`.`address_city` AS `t1_c31`, `event`.`address_state` AS `t1_c32`, ST_AsText(`event`.`latlong_address`) AS event_latlong_address FROM `event` `event` WHERE (`event`.`id`=:ypl0). Bound with :ypl0='19975') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `organization` `t` WHERE `t`.`id`=915 LIMIT 1) 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(SELECT `resources`.`id` AS `t1_c0`, `resources`.`orid` AS `t1_c1`, `resources`.`title` AS `t1_c2`, `resources`.`slug` AS `t1_c3`, `resources`.`html_content` AS `t1_c4`, `resources`.`image_logo` AS `t1_c5`, `resources`.`url_website` AS `t1_c6`, `resources`.`latlong_address` AS `t1_c7`, `resources`.`full_address` AS `t1_c8`, `resources`.`typefor` AS `t1_c9`, `resources`.`owner` AS `t1_c10`, `resources`.`is_featured` AS `t1_c11`, `resources`.`is_active` AS `t1_c12`, `resources`.`json_extra` AS `t1_c13`, `resources`.`date_added` AS `t1_c14`, `resources`.`date_modified` AS `t1_c15`, `resources`.`title_en` AS `t1_c16`, `resources`.`title_ms` AS `t1_c17`, `resources`.`html_content_en` AS `t1_c18`, `resources`.`html_content_ms` AS `t1_c19`, `resources`.`is_blocked` AS `t1_c20`, ST_AsText(`resources`.`latlong_address`) AS resources_latlong_address FROM `resource` `resources` LEFT OUTER JOIN `resource2event_group` `resource2EventGroups` ON (`resource2EventGroups`.`resource_id`=`resources`.`id`) WHERE (`resource2EventGroups`.`event_group_id`=:ypl0). Bound with :ypl0='47') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT `eventOwners`.`id` AS `t1_c0`, `eventOwners`.`event_code` AS `t1_c1`, `eventOwners`.`event_id` AS `t1_c2`, `eventOwners`.`organization_code` AS `t1_c3`, `eventOwners`.`organization_id` AS `t1_c4`, `eventOwners`.`department` AS `t1_c5`, `eventOwners`.`date_added` AS `t1_c6`, `eventOwners`.`date_modified` AS `t1_c7`, `eventOwners`.`as_role_code` AS `t1_c8` FROM `event_owner` `eventOwners` WHERE (`eventOwners`.`event_code`=:ypl0). Bound with :ypl0='grillorchill-startup-2016-10') 1 0.00056 0.00056 0.00056 0.00056
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 `event2industry` `industries_industries` ON (`industries_industries`.`event_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='19975') 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT cv.* FROM `individual2email` as i2e LEFT JOIN individual as i ON i.id=i2e.individual_id INNER JOIN user as u ON u.username=i2e.user_email LEFT JOIN cv_portfolio as cv ON cv.user_id = u.id WHERE i2e.is_verify=1 AND i.is_active=1 AND u.is_active=1 AND cv.slug IS NOT NULL AND cv.visibility='public' AND i.id=:individualId. Bound with :individualId='4320') 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT `event`.`id` AS `t1_c0`, `event`.`code` AS `t1_c1`, `event`.`event_group_code` AS `t1_c2`, `event`.`event_group_id` AS `t1_c3`, `event`.`title` AS `t1_c4`, `event`.`text_short_desc` AS `t1_c5`, `event`.`url_website` AS `t1_c6`, `event`.`date_started` AS `t1_c7`, `event`.`date_ended` AS `t1_c8`, `event`.`is_paid_event` AS `t1_c9`, `event`.`genre` AS `t1_c10`, `event`.`funnel` AS `t1_c11`, `event`.`vendor` AS `t1_c12`, `event`.`vendor_code` AS `t1_c13`, `event`.`at` AS `t1_c14`, `event`.`address_country_code` AS `t1_c15`, `event`.`address_state_code` AS `t1_c16`, `event`.`full_address` AS `t1_c17`, `event`.`latlong_address` AS `t1_c18`, `event`.`email_contact` AS `t1_c19`, `event`.`is_cancelled` AS `t1_c20`, `event`.`is_active` AS `t1_c21`, `event`.`is_for_reporting` AS `t1_c22`, `event`.`json_original` AS `t1_c23`, `event`.`json_extra` AS `t1_c24`, `event`.`date_added` AS `t1_c25`, `event`.`date_modified` AS `t1_c26`, `event`.`is_survey_enabled` AS `t1_c27`, `event`.`address_line1` AS `t1_c28`, `event`.`address_line2` AS `t1_c29`, `event`.`address_zip` AS `t1_c30`, `event`.`address_city` AS `t1_c31`, `event`.`address_state` AS `t1_c32`, ST_AsText(`event`.`latlong_address`) AS event_latlong_address FROM `event` `event` WHERE (`event`.`id`=:ypl0). Bound with :ypl0='15582') 1 0.00054 0.00054 0.00054 0.00054
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 `resource2industry` `industries_industries` ON (`industries_industries`.`resource_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='2694') 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2individual`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT `resourceGeofocuses`.`id` AS `t1_c0`, `resourceGeofocuses`.`title` AS `t1_c1`, `resourceGeofocuses`.`slug` AS `t1_c2`, `resourceGeofocuses`.`is_active` AS `t1_c3`, `resourceGeofocuses`.`date_added` AS `t1_c4`, `resourceGeofocuses`.`date_modified` AS `t1_c5`, `resourceGeofocuses`.`title_en` AS `t1_c6`, `resourceGeofocuses`.`title_ms` AS `t1_c7` FROM `resource_geofocus` `resourceGeofocuses` INNER JOIN `resource2resource_geofocus` `resourceGeofocuses_resourceGeofocuses` ON (`resourceGeofocuses_resourceGeofocuses`.`resource_id`=:ypl0) AND (`resourceGeofocuses`.`id`=`resourceGeofocuses_resourceGeofocuses`.`resource_geofocus_id`). Bound with :ypl0='2694') 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT `event`.`id` AS `t1_c0`, `event`.`code` AS `t1_c1`, `event`.`event_group_code` AS `t1_c2`, `event`.`event_group_id` AS `t1_c3`, `event`.`title` AS `t1_c4`, `event`.`text_short_desc` AS `t1_c5`, `event`.`url_website` AS `t1_c6`, `event`.`date_started` AS `t1_c7`, `event`.`date_ended` AS `t1_c8`, `event`.`is_paid_event` AS `t1_c9`, `event`.`genre` AS `t1_c10`, `event`.`funnel` AS `t1_c11`, `event`.`vendor` AS `t1_c12`, `event`.`vendor_code` AS `t1_c13`, `event`.`at` AS `t1_c14`, `event`.`address_country_code` AS `t1_c15`, `event`.`address_state_code` AS `t1_c16`, `event`.`full_address` AS `t1_c17`, `event`.`latlong_address` AS `t1_c18`, `event`.`email_contact` AS `t1_c19`, `event`.`is_cancelled` AS `t1_c20`, `event`.`is_active` AS `t1_c21`, `event`.`is_for_reporting` AS `t1_c22`, `event`.`json_original` AS `t1_c23`, `event`.`json_extra` AS `t1_c24`, `event`.`date_added` AS `t1_c25`, `event`.`date_modified` AS `t1_c26`, `event`.`is_survey_enabled` AS `t1_c27`, `event`.`address_line1` AS `t1_c28`, `event`.`address_line2` AS `t1_c29`, `event`.`address_zip` AS `t1_c30`, `event`.`address_city` AS `t1_c31`, `event`.`address_state` AS `t1_c32`, ST_AsText(`event`.`latlong_address`) AS event_latlong_address FROM `event` `event` WHERE (`event`.`id`=:ypl0). Bound with :ypl0='19923') 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT `startupStages`.`id` AS `t1_c0`, `startupStages`.`code` AS `t1_c1`, `startupStages`.`slug` AS `t1_c2`, `startupStages`.`title` AS `t1_c3`, `startupStages`.`text_short_description` AS `t1_c4`, `startupStages`.`ordering` AS `t1_c5`, `startupStages`.`is_active` AS `t1_c6`, `startupStages`.`date_added` AS `t1_c7`, `startupStages`.`date_modified` AS `t1_c8`, `startupStages`.`title_en` AS `t1_c9`, `startupStages`.`title_ms` AS `t1_c10`, `startupStages`.`text_short_description_en` AS `t1_c11`, `startupStages`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStages` INNER JOIN `event2startup_stage` `startupStages_startupStages` ON (`startupStages_startupStages`.`event_id`=:ypl0) AND (`startupStages`.`id`=`startupStages_startupStages`.`startup_stage_id`). Bound with :ypl0='15582') 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT `startupStages`.`id` AS `t1_c0`, `startupStages`.`code` AS `t1_c1`, `startupStages`.`slug` AS `t1_c2`, `startupStages`.`title` AS `t1_c3`, `startupStages`.`text_short_description` AS `t1_c4`, `startupStages`.`ordering` AS `t1_c5`, `startupStages`.`is_active` AS `t1_c6`, `startupStages`.`date_added` AS `t1_c7`, `startupStages`.`date_modified` AS `t1_c8`, `startupStages`.`title_en` AS `t1_c9`, `startupStages`.`title_ms` AS `t1_c10`, `startupStages`.`text_short_description_en` AS `t1_c11`, `startupStages`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStages` INNER JOIN `event2startup_stage` `startupStages_startupStages` ON (`startupStages_startupStages`.`event_id`=:ypl0) AND (`startupStages`.`id`=`startupStages_startupStages`.`startup_stage_id`). Bound with :ypl0='19975') 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT `resourceCategories`.`id` AS `t1_c0`, `resourceCategories`.`typefor` AS `t1_c1`, `resourceCategories`.`title` AS `t1_c2`, `resourceCategories`.`slug` AS `t1_c3`, `resourceCategories`.`is_active` AS `t1_c4`, `resourceCategories`.`date_added` AS `t1_c5`, `resourceCategories`.`date_modified` AS `t1_c6`, `resourceCategories`.`title_en` AS `t1_c7`, `resourceCategories`.`title_ms` AS `t1_c8` FROM `resource_category` `resourceCategories` INNER JOIN `resource2resource_category` `resourceCategories_resourceCategories` ON (`resourceCategories_resourceCategories`.`resource_id`=:ypl0) AND (`resourceCategories`.`id`=`resourceCategories_resourceCategories`.`resource_category_id`). Bound with :ypl0='2694') 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `job_vacancy` `t` WHERE (((t.is_active=:ycp0) AND (t.is_publish=:ycp1)) AND (t.status=:ycp2)) AND (t.owner_organization_id=:ycp3) ORDER BY t.date_submit DESC LIMIT 30. Bound with :ycp0='1', :ycp1='1', :ycp2='approved', :ycp3='915') 1 0.00052 0.00052 0.00052 0.00052
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='individual' AND i.ref_id=4319) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT `resources`.`id` AS `t1_c0`, `resources`.`orid` AS `t1_c1`, `resources`.`title` AS `t1_c2`, `resources`.`slug` AS `t1_c3`, `resources`.`html_content` AS `t1_c4`, `resources`.`image_logo` AS `t1_c5`, `resources`.`url_website` AS `t1_c6`, `resources`.`latlong_address` AS `t1_c7`, `resources`.`full_address` AS `t1_c8`, `resources`.`typefor` AS `t1_c9`, `resources`.`owner` AS `t1_c10`, `resources`.`is_featured` AS `t1_c11`, `resources`.`is_active` AS `t1_c12`, `resources`.`json_extra` AS `t1_c13`, `resources`.`date_added` AS `t1_c14`, `resources`.`date_modified` AS `t1_c15`, `resources`.`title_en` AS `t1_c16`, `resources`.`title_ms` AS `t1_c17`, `resources`.`html_content_en` AS `t1_c18`, `resources`.`html_content_ms` AS `t1_c19`, `resources`.`is_blocked` AS `t1_c20`, ST_AsText(`resources`.`latlong_address`) AS resources_latlong_address FROM `resource` `resources` LEFT OUTER JOIN `resource2event_group` `resource2EventGroups` ON (`resource2EventGroups`.`resource_id`=`resources`.`id`) WHERE (`resource2EventGroups`.`event_group_id`=:ypl0). Bound with :ypl0='44') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT `event`.`id` AS `t1_c0`, `event`.`code` AS `t1_c1`, `event`.`event_group_code` AS `t1_c2`, `event`.`event_group_id` AS `t1_c3`, `event`.`title` AS `t1_c4`, `event`.`text_short_desc` AS `t1_c5`, `event`.`url_website` AS `t1_c6`, `event`.`date_started` AS `t1_c7`, `event`.`date_ended` AS `t1_c8`, `event`.`is_paid_event` AS `t1_c9`, `event`.`genre` AS `t1_c10`, `event`.`funnel` AS `t1_c11`, `event`.`vendor` AS `t1_c12`, `event`.`vendor_code` AS `t1_c13`, `event`.`at` AS `t1_c14`, `event`.`address_country_code` AS `t1_c15`, `event`.`address_state_code` AS `t1_c16`, `event`.`full_address` AS `t1_c17`, `event`.`latlong_address` AS `t1_c18`, `event`.`email_contact` AS `t1_c19`, `event`.`is_cancelled` AS `t1_c20`, `event`.`is_active` AS `t1_c21`, `event`.`is_for_reporting` AS `t1_c22`, `event`.`json_original` AS `t1_c23`, `event`.`json_extra` AS `t1_c24`, `event`.`date_added` AS `t1_c25`, `event`.`date_modified` AS `t1_c26`, `event`.`is_survey_enabled` AS `t1_c27`, `event`.`address_line1` AS `t1_c28`, `event`.`address_line2` AS `t1_c29`, `event`.`address_zip` AS `t1_c30`, `event`.`address_city` AS `t1_c31`, `event`.`address_state` AS `t1_c32`, ST_AsText(`event`.`latlong_address`) AS event_latlong_address FROM `event` `event` WHERE (`event`.`id`=:ypl0). Bound with :ypl0='19996') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event2industry`) 1 0.00051 0.00051 0.00051 0.00051
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='915') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_geofocus`) 1 0.00051 0.00051 0.00051 0.00051
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='event' AND i.ref_id=19923) 1 0.00051 0.00051 0.00051 0.00051
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='108') 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SELECT `eventOwners`.`id` AS `t1_c0`, `eventOwners`.`event_code` AS `t1_c1`, `eventOwners`.`event_id` AS `t1_c2`, `eventOwners`.`organization_code` AS `t1_c3`, `eventOwners`.`organization_id` AS `t1_c4`, `eventOwners`.`department` AS `t1_c5`, `eventOwners`.`date_added` AS `t1_c6`, `eventOwners`.`date_modified` AS `t1_c7`, `eventOwners`.`as_role_code` AS `t1_c8` FROM `event_owner` `eventOwners` WHERE (`eventOwners`.`event_code`=:ypl0). Bound with :ypl0='stanfordgo2market-2017-3') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT `resources`.`id` AS `t1_c0`, `resources`.`orid` AS `t1_c1`, `resources`.`title` AS `t1_c2`, `resources`.`slug` AS `t1_c3`, `resources`.`html_content` AS `t1_c4`, `resources`.`image_logo` AS `t1_c5`, `resources`.`url_website` AS `t1_c6`, `resources`.`latlong_address` AS `t1_c7`, `resources`.`full_address` AS `t1_c8`, `resources`.`typefor` AS `t1_c9`, `resources`.`owner` AS `t1_c10`, `resources`.`is_featured` AS `t1_c11`, `resources`.`is_active` AS `t1_c12`, `resources`.`json_extra` AS `t1_c13`, `resources`.`date_added` AS `t1_c14`, `resources`.`date_modified` AS `t1_c15`, `resources`.`title_en` AS `t1_c16`, `resources`.`title_ms` AS `t1_c17`, `resources`.`html_content_en` AS `t1_c18`, `resources`.`html_content_ms` AS `t1_c19`, `resources`.`is_blocked` AS `t1_c20`, ST_AsText(`resources`.`latlong_address`) AS resources_latlong_address FROM `resource` `resources` LEFT OUTER JOIN `resource2event_group` `resource2EventGroups` ON (`resource2EventGroups`.`resource_id`=`resources`.`id`) WHERE (`resource2EventGroups`.`event_group_id`=:ypl0). Bound with :ypl0='2') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00049 0.00049 0.00049 0.00049
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='resource' AND i.ref_id=2694) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT `resources`.`id` AS `t1_c0`, `resources`.`orid` AS `t1_c1`, `resources`.`title` AS `t1_c2`, `resources`.`slug` AS `t1_c3`, `resources`.`html_content` AS `t1_c4`, `resources`.`image_logo` AS `t1_c5`, `resources`.`url_website` AS `t1_c6`, `resources`.`latlong_address` AS `t1_c7`, `resources`.`full_address` AS `t1_c8`, `resources`.`typefor` AS `t1_c9`, `resources`.`owner` AS `t1_c10`, `resources`.`is_featured` AS `t1_c11`, `resources`.`is_active` AS `t1_c12`, `resources`.`json_extra` AS `t1_c13`, `resources`.`date_added` AS `t1_c14`, `resources`.`date_modified` AS `t1_c15`, `resources`.`title_en` AS `t1_c16`, `resources`.`title_ms` AS `t1_c17`, `resources`.`html_content_en` AS `t1_c18`, `resources`.`html_content_ms` AS `t1_c19`, `resources`.`is_blocked` AS `t1_c20`, ST_AsText(`resources`.`latlong_address`) AS resources_latlong_address FROM `resource` `resources` LEFT OUTER JOIN `resource2event_group` `resource2EventGroups` ON (`resource2EventGroups`.`resource_id`=`resources`.`id`) WHERE (`resource2EventGroups`.`event_group_id`=:ypl0). Bound with :ypl0='11') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW CREATE TABLE `event_owner`) 1 0.00049 0.00049 0.00049 0.00049
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='event' AND i.ref_id=19996) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT `startupStages`.`id` AS `t1_c0`, `startupStages`.`code` AS `t1_c1`, `startupStages`.`slug` AS `t1_c2`, `startupStages`.`title` AS `t1_c3`, `startupStages`.`text_short_description` AS `t1_c4`, `startupStages`.`ordering` AS `t1_c5`, `startupStages`.`is_active` AS `t1_c6`, `startupStages`.`date_added` AS `t1_c7`, `startupStages`.`date_modified` AS `t1_c8`, `startupStages`.`title_en` AS `t1_c9`, `startupStages`.`title_ms` AS `t1_c10`, `startupStages`.`text_short_description_en` AS `t1_c11`, `startupStages`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStages` INNER JOIN `event2startup_stage` `startupStages_startupStages` ON (`startupStages_startupStages`.`event_id`=:ypl0) AND (`startupStages`.`id`=`startupStages_startupStages`.`startup_stage_id`). Bound with :ypl0='19923') 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT `eventGroup`.`id` AS `t1_c0`, `eventGroup`.`code` AS `t1_c1`, `eventGroup`.`title` AS `t1_c2`, `eventGroup`.`image_cover` AS `t1_c3`, `eventGroup`.`text_oneliner` AS `t1_c4`, `eventGroup`.`text_short_description` AS `t1_c5`, `eventGroup`.`url_website` AS `t1_c6`, `eventGroup`.`slug` AS `t1_c7`, `eventGroup`.`genre` AS `t1_c8`, `eventGroup`.`funnel` AS `t1_c9`, `eventGroup`.`date_started` AS `t1_c10`, `eventGroup`.`date_ended` AS `t1_c11`, `eventGroup`.`is_active` AS `t1_c12`, `eventGroup`.`json_extra` AS `t1_c13`, `eventGroup`.`date_added` AS `t1_c14`, `eventGroup`.`date_modified` AS `t1_c15`, `eventGroup`.`department` AS `t1_c16`, `eventGroup`.`participant_type` AS `t1_c17`, `eventGroup`.`group_category` AS `t1_c18` FROM `event_group` `eventGroup` WHERE (`eventGroup`.`code`=:ypl0). Bound with :ypl0='a1b310c0-ff2f-4e5a-91c7-03f111b9f988') 1 0.00048 0.00048 0.00048 0.00048
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='915') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT `startupStages`.`id` AS `t1_c0`, `startupStages`.`code` AS `t1_c1`, `startupStages`.`slug` AS `t1_c2`, `startupStages`.`title` AS `t1_c3`, `startupStages`.`text_short_description` AS `t1_c4`, `startupStages`.`ordering` AS `t1_c5`, `startupStages`.`is_active` AS `t1_c6`, `startupStages`.`date_added` AS `t1_c7`, `startupStages`.`date_modified` AS `t1_c8`, `startupStages`.`title_en` AS `t1_c9`, `startupStages`.`title_ms` AS `t1_c10`, `startupStages`.`text_short_description_en` AS `t1_c11`, `startupStages`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStages` INNER JOIN `event2startup_stage` `startupStages_startupStages` ON (`startupStages_startupStages`.`event_id`=:ypl0) AND (`startupStages`.`id`=`startupStages_startupStages`.`startup_stage_id`). Bound with :ypl0='19996') 1 0.00047 0.00047 0.00047 0.00047
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='915') 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 `event2industry` `industries_industries` ON (`industries_industries`.`event_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='15582') 1 0.00046 0.00046 0.00046 0.00046
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='915') 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `cv_portfolio`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00046 0.00046 0.00046 0.00046
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 `persona2individual` `personas_personas` ON (`personas_personas`.`individual_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='4319') 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `event`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT `eventGroup`.`id` AS `t1_c0`, `eventGroup`.`code` AS `t1_c1`, `eventGroup`.`title` AS `t1_c2`, `eventGroup`.`image_cover` AS `t1_c3`, `eventGroup`.`text_oneliner` AS `t1_c4`, `eventGroup`.`text_short_description` AS `t1_c5`, `eventGroup`.`url_website` AS `t1_c6`, `eventGroup`.`slug` AS `t1_c7`, `eventGroup`.`genre` AS `t1_c8`, `eventGroup`.`funnel` AS `t1_c9`, `eventGroup`.`date_started` AS `t1_c10`, `eventGroup`.`date_ended` AS `t1_c11`, `eventGroup`.`is_active` AS `t1_c12`, `eventGroup`.`json_extra` AS `t1_c13`, `eventGroup`.`date_added` AS `t1_c14`, `eventGroup`.`date_modified` AS `t1_c15`, `eventGroup`.`department` AS `t1_c16`, `eventGroup`.`participant_type` AS `t1_c17`, `eventGroup`.`group_category` AS `t1_c18` FROM `event_group` `eventGroup` WHERE (`eventGroup`.`code`=:ypl0). Bound with :ypl0='6ba70929-14f2-4e22-80d2-da8c3f37fda6') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT `individualOrganizations`.`id` AS `t1_c0`, `individualOrganizations`.`individual_id` AS `t1_c1`, `individualOrganizations`.`organization_code` AS `t1_c2`, `individualOrganizations`.`organization_id` AS `t1_c3`, `individualOrganizations`.`as_role_code` AS `t1_c4`, `individualOrganizations`.`job_position` AS `t1_c5`, `individualOrganizations`.`date_started` AS `t1_c6`, `individualOrganizations`.`date_ended` AS `t1_c7`, `individualOrganizations`.`json_extra` AS `t1_c8`, `individualOrganizations`.`date_added` AS `t1_c9`, `individualOrganizations`.`date_modified` AS `t1_c10` FROM `individual_organization` `individualOrganizations` WHERE (`individualOrganizations`.`organization_code`=:ypl0). Bound with :ypl0='6ddbaa4c-96f5-4ff4-a110-92353f01510b') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT `country`.`id` AS `t1_c0`, `country`.`code` AS `t1_c1`, `country`.`name` AS `t1_c2`, `country`.`printable_name` AS `t1_c3`, `country`.`iso3` AS `t1_c4`, `country`.`numcode` AS `t1_c5`, `country`.`is_default` AS `t1_c6`, `country`.`is_highlight` AS `t1_c7`, `country`.`is_active` AS `t1_c8`, `country`.`date_added` AS `t1_c9`, `country`.`date_modified` AS `t1_c10` FROM `country` `country` WHERE (`country`.`code`=:ypl0). Bound with :ypl0='MY') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2event et ON t.id = et.tag_id WHERE et.event_id = :ownerid . Bound with :ownerid='19923') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT `eventOwners`.`id` AS `t1_c0`, `eventOwners`.`event_code` AS `t1_c1`, `eventOwners`.`event_id` AS `t1_c2`, `eventOwners`.`organization_code` AS `t1_c3`, `eventOwners`.`organization_id` AS `t1_c4`, `eventOwners`.`department` AS `t1_c5`, `eventOwners`.`date_added` AS `t1_c6`, `eventOwners`.`date_modified` AS `t1_c7`, `eventOwners`.`as_role_code` AS `t1_c8` FROM `event_owner` `eventOwners` WHERE (`eventOwners`.`event_code`=:ypl0). Bound with :ypl0='magicco-workingspace-2016-9') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT * FROM `campus_member2organization` `t` WHERE t.organization_id=:organizationId LIMIT 1. Bound with :organizationId='915') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_category`) 1 0.00044 0.00044 0.00044 0.00044
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='915') 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='915', :status='approved') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2persona`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2startup_stage`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2industry`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `ekyc_company`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT `eventGroup`.`id` AS `t1_c0`, `eventGroup`.`code` AS `t1_c1`, `eventGroup`.`title` AS `t1_c2`, `eventGroup`.`image_cover` AS `t1_c3`, `eventGroup`.`text_oneliner` AS `t1_c4`, `eventGroup`.`text_short_description` AS `t1_c5`, `eventGroup`.`url_website` AS `t1_c6`, `eventGroup`.`slug` AS `t1_c7`, `eventGroup`.`genre` AS `t1_c8`, `eventGroup`.`funnel` AS `t1_c9`, `eventGroup`.`date_started` AS `t1_c10`, `eventGroup`.`date_ended` AS `t1_c11`, `eventGroup`.`is_active` AS `t1_c12`, `eventGroup`.`json_extra` AS `t1_c13`, `eventGroup`.`date_added` AS `t1_c14`, `eventGroup`.`date_modified` AS `t1_c15`, `eventGroup`.`department` AS `t1_c16`, `eventGroup`.`participant_type` AS `t1_c17`, `eventGroup`.`group_category` AS `t1_c18` FROM `event_group` `eventGroup` WHERE (`eventGroup`.`code`=:ypl0). Bound with :ypl0='85e129f5-ffbd-4b36-8450-ef7af4f3cb6f') 1 0.00044 0.00044 0.00044 0.00044
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 `persona2individual` `personas_personas` ON (`personas_personas`.`individual_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='4320') 1 0.00043 0.00043 0.00043 0.00043
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 `event2industry` `industries_industries` ON (`industries_industries`.`event_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='19923') 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SHOW CREATE TABLE `job_vacancy`) 1 0.00043 0.00043 0.00043 0.00043
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='915') 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='915') 1 0.00042 0.00042 0.00042 0.00042
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 `event2industry` `industries_industries` ON (`industries_industries`.`event_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='19996') 1 0.00042 0.00042 0.00042 0.00042
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 `event2persona` `personas_personas` ON (`personas_personas`.`event_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='19923') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT `individual`.`id` AS `t1_c0`, `individual`.`full_name` AS `t1_c1`, `individual`.`gender` AS `t1_c2`, `individual`.`image_photo` AS `t1_c3`, `individual`.`country_code` AS `t1_c4`, `individual`.`state_code` AS `t1_c5`, `individual`.`ic_number` AS `t1_c6`, `individual`.`text_address_residential` AS `t1_c7`, `individual`.`mobile_number` AS `t1_c8`, `individual`.`can_code` AS `t1_c9`, `individual`.`is_active` AS `t1_c10`, `individual`.`date_added` AS `t1_c11`, `individual`.`date_modified` AS `t1_c12`, `individual`.`score_completeness` AS `t1_c13` FROM `individual` `individual` WHERE (`individual`.`id`=:ypl0). Bound with :ypl0='4320') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT COUNT(*) FROM `job_vacancy` `t` WHERE (((t.is_active=:ycp0) AND (t.is_publish=:ycp1)) AND (t.status=:ycp2)) AND (t.owner_organization_id=:ycp3). Bound with :ycp0='1', :ycp1='1', :ycp2='approved', :ycp3='915') 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 `event2persona` `personas_personas` ON (`personas_personas`.`event_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='19996') 1 0.00041 0.00041 0.00041 0.00041
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='event' AND i.ref_id=19975) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT `activeProducts`.`id` AS `t1_c0`, `activeProducts`.`organization_id` AS `t1_c1`, `activeProducts`.`product_category_id` AS `t1_c2`, `activeProducts`.`title` AS `t1_c3`, `activeProducts`.`text_short_description` AS `t1_c4`, `activeProducts`.`typeof` AS `t1_c5`, `activeProducts`.`image_cover` AS `t1_c6`, `activeProducts`.`url_website` AS `t1_c7`, `activeProducts`.`is_active` AS `t1_c8`, `activeProducts`.`date_added` AS `t1_c9`, `activeProducts`.`date_modified` AS `t1_c10`, `activeProducts`.`price_min` AS `t1_c11`, `activeProducts`.`price_max` AS `t1_c12` FROM `product` `activeProducts` WHERE (is_active=1) AND (`activeProducts`.`organization_id`=:ypl0). Bound with :ypl0='915') 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `event_group`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `resource`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2resource et ON t.id = et.tag_id WHERE et.resource_id = :ownerid . Bound with :ownerid='2694') 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2event et ON t.id = et.tag_id WHERE et.event_id = :ownerid . Bound with :ownerid='15582') 1 0.00039 0.00039 0.00039 0.00039
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 `event2persona` `personas_personas` ON (`personas_personas`.`event_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='19975') 1 0.00039 0.00039 0.00039 0.00039
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='108') 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2individual et ON t.id = et.tag_id WHERE et.individual_id = :ownerid . Bound with :ownerid='4319') 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `event_organization`) 1 0.00038 0.00038 0.00038 0.00038
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='108') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2organization`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `event2persona`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2event et ON t.id = et.tag_id WHERE et.event_id = :ownerid . Bound with :ownerid='19996') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2individual et ON t.id = et.tag_id WHERE et.individual_id = :ownerid . Bound with :ownerid='4320') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `individual`.`id` AS `t1_c0`, `individual`.`full_name` AS `t1_c1`, `individual`.`gender` AS `t1_c2`, `individual`.`image_photo` AS `t1_c3`, `individual`.`country_code` AS `t1_c4`, `individual`.`state_code` AS `t1_c5`, `individual`.`ic_number` AS `t1_c6`, `individual`.`text_address_residential` AS `t1_c7`, `individual`.`mobile_number` AS `t1_c8`, `individual`.`can_code` AS `t1_c9`, `individual`.`is_active` AS `t1_c10`, `individual`.`date_added` AS `t1_c11`, `individual`.`date_modified` AS `t1_c12`, `individual`.`score_completeness` AS `t1_c13` FROM `individual` `individual` WHERE (`individual`.`id`=:ypl0). Bound with :ypl0='4319') 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT `startupStage`.`id` AS `t1_c0`, `startupStage`.`code` AS `t1_c1`, `startupStage`.`slug` AS `t1_c2`, `startupStage`.`title` AS `t1_c3`, `startupStage`.`text_short_description` AS `t1_c4`, `startupStage`.`ordering` AS `t1_c5`, `startupStage`.`is_active` AS `t1_c6`, `startupStage`.`date_added` AS `t1_c7`, `startupStage`.`date_modified` AS `t1_c8`, `startupStage`.`title_en` AS `t1_c9`, `startupStage`.`title_ms` AS `t1_c10`, `startupStage`.`text_short_description_en` AS `t1_c11`, `startupStage`.`text_short_description_ms` AS `t1_c12` FROM `startup_stage` `startupStage` WHERE (`startupStage`.`id`=:ypl0). Bound with :ypl0=NULL) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00037 0.00037 0.00037 0.00037
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='108') 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2event et ON t.id = et.tag_id WHERE et.event_id = :ownerid . Bound with :ownerid='19975') 1 0.00036 0.00036 0.00036 0.00036
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='108') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_category`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `individual_organization`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 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='108') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `event2startup_stage`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_geofocus`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `individual`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT COUNT(*) FROM `startup_stage` `t`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `campus_member2organization`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `event2industry`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2individual`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `product`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `country`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00031 0.00031 0.00031 0.00031
WebApplication::createController::override 1 0.00003 0.00003 0.00003 0.00003