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

In our effort to provide a holistic assistance to our SME entrepreneurs, SME Bank offers My Seed SME Scheme (MYS3) especially to Indian entrepreneurs to get an access for financing assistance to expand their businesses. MYS3 comes with financing features on fixed asset such as purchasing machineries and equipment’s and working capital.



76 queries in 0.2579 second
Profiling Summary Report (Time: 0.55617s, Memory: 4,748KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.97832 0.48916 0.48907 0.48926
appRun 1 0.51097 0.51097 0.51097 0.51097
Organization::afterFind() 1 0.05968 0.05968 0.05968 0.05968
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.05553 0.05553 0.05553 0.05553
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.03064 0.03064 0.03064 0.03064
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.03041 0.03041 0.03041 0.03041
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource`) 1 0.02110 0.02110 0.02110 0.02110
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.01094 0.01094 0.01094 0.01094
Controller::beforeRender() 1 0.00979 0.00979 0.00979 0.00979
Controller::init() 1 0.00966 0.00966 0.00966 0.00966
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.00764 0.00764 0.00764 0.00764
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2event_group`) 1 0.00753 0.00753 0.00753 0.00753
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.00572 0.00572 0.00572 0.00572
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=1887) 1 0.00512 0.00512 0.00512 0.00512
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='1887') 1 0.00487 0.00487 0.00487 0.00487
system.db.CDbCommand.query(SHOW CREATE TABLE `resource`) 1 0.00384 0.00384 0.00384 0.00384
system.db.CDbCommand.query(SELECT COUNT(*) FROM `startup_stage` `t`) 9 0.00357 0.00040 0.00023 0.00076
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00349 0.00349 0.00349 0.00349
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00329 0.00329 0.00329 0.00329
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00277 0.00277 0.00277 0.00277
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00266 0.00266 0.00266 0.00266
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='1887') 1 0.00266 0.00266 0.00266 0.00266
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00263 0.00263 0.00263 0.00263
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `resource` `t` WHERE `t`.`id`=1887 LIMIT 1) 1 0.00256 0.00256 0.00256 0.00256
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00238 0.00238 0.00238 0.00238
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=535) 1 0.00233 0.00233 0.00233 0.00233
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00232 0.00232 0.00232 0.00232
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00195 0.00065 0.00055 0.00080
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.00190 0.00190 0.00190 0.00190
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00185 0.00185 0.00185 0.00185
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.00176 0.00176 0.00176 0.00176
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_category`) 1 0.00175 0.00175 0.00175 0.00175
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.00171 0.00171 0.00171 0.00171
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_geofocus`) 1 0.00155 0.00155 0.00155 0.00155
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.00143 0.00143 0.00143 0.00143
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00136 0.00136 0.00136 0.00136
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_geofocus`) 1 0.00133 0.00133 0.00133 0.00133
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00126 0.00126 0.00126 0.00126
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_category`) 1 0.00117 0.00117 0.00117 0.00117
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='1887') 1 0.00116 0.00116 0.00116 0.00116
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='1887') 1 0.00116 0.00116 0.00116 0.00116
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2organization`) 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00110 0.00110 0.00110 0.00110
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2industry`) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_geofocus`) 1 0.00102 0.00102 0.00102 0.00102
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='1887') 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2startup_stage`) 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2organization`) 1 0.00096 0.00096 0.00096 0.00096
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='1887') 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00081 0.00081 0.00081 0.00081
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.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2industry`) 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00070 0.00070 0.00070 0.00070
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.00065 0.00065 0.00065 0.00065
Organization::behaviors() 2 0.00064 0.00032 0.00006 0.00059
Organization::init() 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2persona`) 1 0.00058 0.00058 0.00058 0.00058
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='1887') 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2startup_stage`) 1 0.00057 0.00057 0.00057 0.00057
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='1887') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2persona`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_geofocus`) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2event_group`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00031 0.00031 0.00031 0.00031
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002