This is a staging environment for testing purposes only. Data you inserted here is not persistent!
Carian
Saya
 
 
 
 
 
 
Kategori
Peringkat Syarikat
 
 
 
 
 
 

Untuk Lokasi

Untuk Industri

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



82 queries in 0.1259 second
Profiling Summary Report (Time: 0.26899s, Memory: 4,727KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.47416 0.23708 0.23697 0.23719
appRun 1 0.25009 0.25009 0.25009 0.25009
Organization::afterFind() 1 0.03365 0.03365 0.03365 0.03365
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_ms ASC) 1 0.01933 0.01933 0.01933 0.01933
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.01625 0.01625 0.01625 0.01625
system.db.CDbCommand.query(SELECT COUNT(*) FROM `startup_stage` `t`) 9 0.01470 0.00163 0.00023 0.00498
Controller::init() 1 0.01462 0.01462 0.01462 0.01462
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.00829 0.00829 0.00829 0.00829
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.00729 0.00729 0.00729 0.00729
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2event_group`) 1 0.00435 0.00435 0.00435 0.00435
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.00421 0.00421 0.00421 0.00421
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00374 0.00374 0.00374 0.00374
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource`) 1 0.00297 0.00297 0.00297 0.00297
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00235 0.00235 0.00235 0.00235
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 1 0.00234 0.00234 0.00234 0.00234
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00217 0.00217 0.00217 0.00217
system.db.CDbCommand.query(SHOW CREATE TABLE `resource`) 1 0.00205 0.00205 0.00205 0.00205
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00177 0.00059 0.00029 0.00106
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00167 0.00167 0.00167 0.00167
Organization::behaviors() 2 0.00157 0.00079 0.00003 0.00155
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2organization`) 1 0.00132 0.00132 0.00132 0.00132
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00108 0.00108 0.00108 0.00108
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.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00093 0.00093 0.00093 0.00093
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.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00088 0.00088 0.00088 0.00088
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 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 FULL COLUMNS FROM `tag`) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 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 FULL COLUMNS FROM `resource2organization`) 1 0.00076 0.00076 0.00076 0.00076
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.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_geofocus`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_category`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00064 0.00064 0.00064 0.00064
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.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2startup_stage`) 1 0.00058 0.00058 0.00058 0.00058
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.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_category`) 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='570') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2event_group`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_geofocus`) 1 0.00055 0.00055 0.00055 0.00055
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.00055 0.00055 0.00055 0.00055
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.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `resource` `t` WHERE `t`.`id`=1936 LIMIT 1) 1 0.00051 0.00051 0.00051 0.00051
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.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00049 0.00049 0.00049 0.00049
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.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00046 0.00046 0.00046 0.00046
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.00046 0.00046 0.00046 0.00046
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.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_geofocus`) 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 `persona2organization` `personas_personas` ON (`personas_personas`.`organization_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='570') 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00037 0.00037 0.00037 0.00037
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.00037 0.00037 0.00037 0.00037
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.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_geofocus`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2startup_stage`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_category`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00032 0.00032 0.00032 0.00032
Organization::init() 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_category`) 1 0.00020 0.00020 0.00020 0.00020
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001