This is a staging environment for testing purposes only. Data you inserted here is not persistent!
|
Search
I am
 
 
 
 
 
 
Categories
Company stage
 
 
 
 
 
 

For Location

For Industries
logo

TERAS Financing Scheme

TERAS Financing Scheme Collaborative effort with TERAJU in financing eligible Bumiputera SME companies under TERAS and Non Teras program.


More Information
Back
74 queries in 0.2396 second
Profiling Summary Report (Time: 0.51730s, Memory: 4,744KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.85487 0.42744 0.42740 0.42747
appRun 1 0.50218 0.50218 0.50218 0.50218
Organization::afterFind() 1 0.05824 0.05824 0.05824 0.05824
system.db.CDbCommand.query(SELECT i.* FROM `industry` as i, resource as r, resource2industry as r2i WHERE r2i.resource_id=r.id AND r2i.industry_id=i.id AND r.is_active=1 AND i.is_active=1 GROUP BY i.id ORDER BY i.title_en ASC) 1 0.03479 0.03479 0.03479 0.03479
system.db.CDbCommand.query(SELECT `resource2EventGroups`.`id` AS `t1_c0`, `resource2EventGroups`.`resource_id` AS `t1_c1`, `resource2EventGroups`.`event_group_id` AS `t1_c2`, `resource2EventGroups`.`is_active` AS `t1_c3`, `resource2EventGroups`.`json_mapping` AS `t1_c4`, `resource2EventGroups`.`json_extra` AS `t1_c5`, `resource2EventGroups`.`date_added` AS `t1_c6`, `resource2EventGroups`.`date_modified` AS `t1_c7` FROM `resource2event_group` `resource2EventGroups` WHERE (`resource2EventGroups`.`resource_id`=:ypl0). Bound with :ypl0='1985') 1 0.02350 0.02350 0.02350 0.02350
Controller::init() 1 0.01988 0.01988 0.01988 0.01988
system.db.CDbCommand.query(SELECT g.* FROM `resource_geofocus` as g, resource as r, resource2resource_geofocus as r2g WHERE r2g.resource_id=r.id AND r2g.resource_geofocus_id=g.id AND r.is_active=1 AND g.is_active=1 GROUP BY g.id ORDER BY g.slug ASC) 1 0.01925 0.01925 0.01925 0.01925
system.db.CDbCommand.query(SELECT s.* FROM `startup_stage` as s, resource as r, resource2startup_stage as r2s WHERE r2s.resource_id=r.id AND r2s.startup_stage_id=s.id AND r.is_active=1 AND s.is_active=1 GROUP BY s.id ORDER BY s.ordering ASC) 1 0.01839 0.01839 0.01839 0.01839
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.01763 0.01763 0.01763 0.01763
Controller::beforeRender() 1 0.01373 0.01373 0.01373 0.01373
system.db.CDbCommand.query(SELECT p.* FROM `persona` as p, resource as r, resource2persona as r2p WHERE r2p.resource_id=r.id AND r2p.persona_id=p.id AND r.is_active=1 AND p.is_active=1 GROUP BY p.id) 1 0.01305 0.01305 0.01305 0.01305
system.db.CDbCommand.query(SELECT c.* FROM `resource_category` as c, resource as r, resource2resource_category as r2c WHERE r2c.resource_id=r.id AND r2c.resource_category_id=c.id AND r.is_active=1 AND c.is_active=1 GROUP BY c.id ORDER BY typefor ASC, c.title ASC) 1 0.01233 0.01233 0.01233 0.01233
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00957 0.00319 0.00134 0.00530
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource`) 1 0.00954 0.00954 0.00954 0.00954
system.db.CDbCommand.query(SELECT COUNT(*) FROM `startup_stage` `t`) 8 0.00930 0.00116 0.00024 0.00577
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='535') 1 0.00465 0.00465 0.00465 0.00465
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00356 0.00356 0.00356 0.00356
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=1985) 1 0.00322 0.00322 0.00322 0.00322
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00307 0.00307 0.00307 0.00307
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2persona`) 1 0.00301 0.00301 0.00301 0.00301
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_category`) 1 0.00236 0.00236 0.00236 0.00236
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2organization`) 1 0.00232 0.00232 0.00232 0.00232
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='535') 1 0.00207 0.00207 0.00207 0.00207
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_category`) 1 0.00198 0.00198 0.00198 0.00198
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='1985') 1 0.00194 0.00194 0.00194 0.00194
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_geofocus`) 1 0.00187 0.00187 0.00187 0.00187
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='1985') 1 0.00187 0.00187 0.00187 0.00187
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00186 0.00186 0.00186 0.00186
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='1985') 1 0.00184 0.00184 0.00184 0.00184
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00177 0.00177 0.00177 0.00177
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00169 0.00169 0.00169 0.00169
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2startup_stage`) 1 0.00160 0.00160 0.00160 0.00160
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `resource` `t` WHERE `t`.`id`=1985 LIMIT 1) 1 0.00158 0.00158 0.00158 0.00158
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00150 0.00150 0.00150 0.00150
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00145 0.00145 0.00145 0.00145
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00144 0.00144 0.00144 0.00144
system.db.CDbCommand.query(SHOW CREATE TABLE `resource`) 1 0.00131 0.00131 0.00131 0.00131
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2startup_stage`) 1 0.00127 0.00127 0.00127 0.00127
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00125 0.00125 0.00125 0.00125
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='535') 1 0.00118 0.00118 0.00118 0.00118
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00115 0.00115 0.00115 0.00115
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00114 0.00114 0.00114 0.00114
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00112 0.00112 0.00112 0.00112
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='1985') 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_geofocus`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2persona`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_category`) 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00074 0.00074 0.00074 0.00074
Organization::behaviors() 2 0.00073 0.00037 0.00004 0.00069
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_category`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00070 0.00070 0.00070 0.00070
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='535') 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00067 0.00067 0.00067 0.00067
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='1985') 1 0.00064 0.00064 0.00064 0.00064
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='1985') 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2organization`) 1 0.00058 0.00058 0.00058 0.00058
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='535') 1 0.00054 0.00054 0.00054 0.00054
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='535') 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00048 0.00048 0.00048 0.00048
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='1985') 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='535') 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00030 0.00030 0.00030 0.00030
Organization::init() 1 0.00019 0.00019 0.00019 0.00019
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002