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

Rolling Expenditure Advance Cash Scheme (i-REACH)

i-REACH is a special contract financing scheme to finance short term contract of construction, civil, mechanical, engineering, landscaping and other simple contract. It is an affordable and complete financing package that requires no collateral. It offers working capital financing and bank guarantee to support contractors to perform and deliver the project within the stipulated contract period.


More Information
Back
85 queries in 0.0796 second
Profiling Summary Report (Time: 0.15443s, Memory: 4,727KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.26249 0.13125 0.13122 0.13127
appRun 1 0.13816 0.13816 0.13816 0.13816
Organization::afterFind() 1 0.02345 0.02345 0.02345 0.02345
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.01138 0.01138 0.01138 0.01138
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.00861 0.00861 0.00861 0.00861
Controller::beforeRender() 1 0.00847 0.00847 0.00847 0.00847
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.00597 0.00597 0.00597 0.00597
Controller::init() 1 0.00442 0.00442 0.00442 0.00442
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.00404 0.00404 0.00404 0.00404
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.00379 0.00379 0.00379 0.00379
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00334 0.00111 0.00028 0.00181
system.db.CDbCommand.query(SELECT COUNT(*) FROM `startup_stage` `t`) 8 0.00246 0.00031 0.00025 0.00040
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00157 0.00157 0.00157 0.00157
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00153 0.00153 0.00153 0.00153
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource`) 1 0.00153 0.00153 0.00153 0.00153
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00102 0.00102 0.00102 0.00102
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `resource` `t` WHERE `t`.`id`=1922 LIMIT 1) 1 0.00101 0.00101 0.00101 0.00101
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00096 0.00096 0.00096 0.00096
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.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00088 0.00088 0.00088 0.00088
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_category`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2event_group`) 1 0.00072 0.00072 0.00072 0.00072
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='1922') 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_geofocus`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW CREATE TABLE `resource`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2industry`) 1 0.00064 0.00064 0.00064 0.00064
Organization::behaviors() 2 0.00063 0.00032 0.00002 0.00061
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_geofocus`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2persona`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_category`) 1 0.00059 0.00059 0.00059 0.00059
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.00057 0.00057 0.00057 0.00057
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.00056 0.00056 0.00056 0.00056
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='1922') 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2organization`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00055 0.00055 0.00055 0.00055
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.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_geofocus`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2startup_stage`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00050 0.00050 0.00050 0.00050
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.00049 0.00049 0.00049 0.00049
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='1922') 1 0.00044 0.00044 0.00044 0.00044
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.00042 0.00042 0.00042 0.00042
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='1922') 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 `resource2persona` `personas_personas` ON (`personas_personas`.`resource_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='1922') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00040 0.00040 0.00040 0.00040
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=1922) 1 0.00040 0.00040 0.00040 0.00040
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.00039 0.00039 0.00039 0.00039
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='1922') 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00038 0.00038 0.00038 0.00038
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='1922') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00036 0.00036 0.00036 0.00036
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.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2persona`) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_geofocus`) 1 0.00033 0.00033 0.00033 0.00033
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='1922') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2event_group`) 1 0.00026 0.00026 0.00026 0.00026
Organization::init() 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_category`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_category`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2organization`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2industry`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2startup_stage`) 1 0.00022 0.00022 0.00022 0.00022
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001