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

Skim ini adalah merupakan proses untuk membiayai kontrak dan pembekalan secara terus yang diperolehi daripada Kerajaan Persekutuan, Kerajaan Negeri, Agensi Kerajaan dan Badan Berkanun.



75 queries in 0.1347 second
Profiling Summary Report (Time: 0.21926s, Memory: 4,753KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.38978 0.19489 0.19465 0.19513
appRun 1 0.20547 0.20547 0.20547 0.20547
Organization::afterFind() 1 0.02873 0.02873 0.02873 0.02873
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.01944 0.01944 0.01944 0.01944
Controller::beforeRender() 1 0.01606 0.01606 0.01606 0.01606
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.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.01125 0.01125 0.01125 0.01125
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.01070 0.01070 0.01070 0.01070
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.00859 0.00859 0.00859 0.00859
Controller::init() 1 0.00787 0.00787 0.00787 0.00787
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00675 0.00675 0.00675 0.00675
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00618 0.00618 0.00618 0.00618
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_geofocus`) 1 0.00479 0.00479 0.00479 0.00479
system.db.CDbCommand.query(SELECT COUNT(*) FROM `startup_stage` `t`) 9 0.00406 0.00045 0.00022 0.00105
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='1936') 1 0.00341 0.00341 0.00341 0.00341
Organization::behaviors() 2 0.00261 0.00130 0.00002 0.00258
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='1936') 1 0.00257 0.00257 0.00257 0.00257
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='570') 1 0.00235 0.00235 0.00235 0.00235
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource`) 1 0.00201 0.00201 0.00201 0.00201
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00190 0.00190 0.00190 0.00190
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00190 0.00190 0.00190 0.00190
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2organization`) 1 0.00152 0.00152 0.00152 0.00152
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_category`) 1 0.00148 0.00148 0.00148 0.00148
system.db.CDbCommand.query(SHOW CREATE TABLE `resource`) 1 0.00145 0.00145 0.00145 0.00145
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00142 0.00142 0.00142 0.00142
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='1936') 1 0.00136 0.00136 0.00136 0.00136
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_category`) 1 0.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00118 0.00118 0.00118 0.00118
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00110 0.00110 0.00110 0.00110
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='1936') 1 0.00108 0.00108 0.00108 0.00108
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00103 0.00103 0.00103 0.00103
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=1936) 1 0.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2organization`) 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2startup_stage`) 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2industry`) 1 0.00091 0.00091 0.00091 0.00091
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00090 0.00030 0.00027 0.00032
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_category`) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2persona`) 1 0.00080 0.00080 0.00080 0.00080
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='570') 1 0.00074 0.00074 0.00074 0.00074
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='570') 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00071 0.00071 0.00071 0.00071
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='570') 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2startup_stage`) 1 0.00063 0.00063 0.00063 0.00063
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='1936') 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00053 0.00053 0.00053 0.00053
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='1936') 1 0.00051 0.00051 0.00051 0.00051
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='570') 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='570') 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2persona`) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `resource` `t` WHERE `t`.`id`=1936 LIMIT 1) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 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 `resource2industry` `industries_industries` ON (`industries_industries`.`resource_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='1936') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00038 0.00038 0.00038 0.00038
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='1936') 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 `classification`) 1 0.00033 0.00033 0.00033 0.00033
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='570') 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_category`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2industry`) 1 0.00026 0.00026 0.00026 0.00026
Organization::init() 1 0.00019 0.00019 0.00019 0.00019
WebApplication::createController::override 1 0.00002 0.00002 0.00002 0.00002