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

asdsdasd


More Information
Balik
84 queries in 0.0601 second
Profiling Summary Report (Time: 0.13094s, Memory: 4,720KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.20335 0.10168 0.10158 0.10177
appRun 1 0.11072 0.11072 0.11072 0.11072
Organization::afterFind() 1 0.02296 0.02296 0.02296 0.02296
Controller::init() 1 0.00928 0.00928 0.00928 0.00928
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.00599 0.00599 0.00599 0.00599
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.00467 0.00467 0.00467 0.00467
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.00331 0.00331 0.00331 0.00331
Controller::beforeRender() 1 0.00325 0.00325 0.00325 0.00325
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_category`) 1 0.00239 0.00239 0.00239 0.00239
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.00232 0.00232 0.00232 0.00232
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.00225 0.00225 0.00225 0.00225
system.db.CDbCommand.query(SELECT COUNT(*) FROM `startup_stage` `t`) 6 0.00182 0.00030 0.00022 0.00058
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource`) 1 0.00137 0.00137 0.00137 0.00137
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='2693') 1 0.00127 0.00127 0.00127 0.00127
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2persona`) 1 0.00115 0.00115 0.00115 0.00115
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='392') 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2persona`) 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00099 0.00033 0.00030 0.00036
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_category`) 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00079 0.00079 0.00079 0.00079
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='2693') 1 0.00077 0.00077 0.00077 0.00077
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='2693') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00072 0.00072 0.00072 0.00072
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='392') 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2event_group`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource_geofocus`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00061 0.00061 0.00061 0.00061
Organization::behaviors() 2 0.00061 0.00030 0.00003 0.00058
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00059 0.00059 0.00059 0.00059
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='2693') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `startup_stage`) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00058 0.00058 0.00058 0.00058
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='392') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_geofocus`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2organization`) 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(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='2693') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2resource_category`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `resource` `t` WHERE `t`.`id`=2693 LIMIT 1) 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `resource2industry`) 1 0.00043 0.00043 0.00043 0.00043
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='2693') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 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=2693) 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='392') 1 0.00040 0.00040 0.00040 0.00040
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='2693') 1 0.00040 0.00040 0.00040 0.00040
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='392') 1 0.00039 0.00039 0.00039 0.00039
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='2693') 1 0.00038 0.00038 0.00038 0.00038
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='392') 1 0.00034 0.00034 0.00034 0.00034
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='392') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `resource`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2startup_stage`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2event_group`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `resource_geofocus`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2resource_geofocus`) 1 0.00025 0.00025 0.00025 0.00025
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 `classification`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `startup_stage`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2organization`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `resource2industry`) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00020 0.00020 0.00020 0.00020
Organization::init() 1 0.00020 0.00020 0.00020 0.00020
WebApplication::createController::override 1 0.00001 0.00001 0.00001 0.00001