This is a staging environment for testing purposes only. Data you inserted here is not persistent!

63 queries in 0.0425 second
Profiling Summary Report (Time: 0.14396s, Memory: 4,879KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
WebApplication::createController 2 0.25253 0.12626 0.12611 0.12642
appRun 1 0.13296 0.13296 0.13296 0.13296
Organization::afterFind() 2 0.04007 0.02004 0.00647 0.03360
Controller::init() 1 0.01038 0.01038 0.01038 0.01038
Controller::beforeRender() 1 0.00574 0.00574 0.00574 0.00574
Controller::beforeAction() 1 0.00241 0.00241 0.00241 0.00241
Organization::init() 2 0.00163 0.00081 0.00046 0.00117
system.db.CDbCommand.query(SELECT COUNT(*) FROM `seolytic` `t`) 3 0.00144 0.00048 0.00044 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) 1 0.00129 0.00129 0.00129 0.00129
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) 1 0.00127 0.00127 0.00127 0.00127
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) 1 0.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) 1 0.00110 0.00110 0.00110 0.00110
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `seolytic`) 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SELECT * FROM `sdg` `t` WHERE t.is_active = 1 ORDER BY title ASC) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT * FROM `classification` `t` WHERE (t.is_active = 1) AND (group_code='technology-driver') ORDER BY slug ASC) 1 0.00082 0.00082 0.00082 0.00082
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=163) 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `organization` `t` WHERE t.code=:code LIMIT 1. Bound with :code='6ea6ff9c-bca4-492c-8d0d-59a1f75a6878') 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT * FROM `industry` `t` WHERE t.is_active = 1 ORDER BY title_en ASC) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT * FROM `seolytic` `t` WHERE is_active=1 ORDER BY ordering ASC) 1 0.00077 0.00077 0.00077 0.00077
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='163') 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 `persona2organization` `personas_personas` ON (`personas_personas`.`organization_id`=:ypl0) AND (`personas`.`id`=`personas_personas`.`persona_id`). Bound with :ypl0='526') 1 0.00075 0.00075 0.00075 0.00075
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='163') 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) 1 0.00074 0.00074 0.00074 0.00074
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='526') 1 0.00072 0.00072 0.00072 0.00072
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=526) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `organization` `t` WHERE t.code=:code LIMIT 1. Bound with :code='fcaa3745-0aff-4244-893e-87f608002f0e') 1 0.00069 0.00069 0.00069 0.00069
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='526') 1 0.00069 0.00069 0.00069 0.00069
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='526') 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) 1 0.00068 0.00068 0.00068 0.00068
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='526') 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SELECT * FROM `classification` `t` WHERE (t.is_active = 1) AND (group_code='socioeco') ORDER BY slug ASC) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT * FROM `classification` `t` WHERE (t.is_active = 1) AND (group_code='technology') ORDER BY slug ASC) 1 0.00066 0.00066 0.00066 0.00066
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='163') 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SELECT * FROM `persona` `t` WHERE t.slug=:slug LIMIT 1. Bound with :slug='corporate') 1 0.00063 0.00063 0.00063 0.00063
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='526') 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT * FROM `persona` `t` WHERE t.slug=:slug LIMIT 1. Bound with :slug='ecosystem-builder') 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT * FROM `classification` `t` WHERE (t.is_active = 1) AND (group_code='trl') ORDER BY slug ASC) 1 0.00060 0.00060 0.00060 0.00060
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='163') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) 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='163') 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SELECT * FROM `persona` `t` WHERE t.slug=:slug LIMIT 1. Bound with :slug='se') 1 0.00056 0.00056 0.00056 0.00056
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='163') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) 1 0.00056 0.00056 0.00056 0.00056
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='163') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT * FROM `persona` `t` WHERE t.slug=:slug LIMIT 1. Bound with :slug='government') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) 1 0.00055 0.00055 0.00055 0.00055
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='526') 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT * FROM `persona` `t` WHERE t.slug=:slug LIMIT 1. Bound with :slug='startups') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SHOW CREATE TABLE `seolytic`) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) 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(SHOW CREATE TABLE `classification`) 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) 1 0.00043 0.00043 0.00043 0.00043
Organization::behaviors() 3 0.00028 0.00009 0.00005 0.00017
WebApplication::createController::override 1 0.00003 0.00003 0.00003 0.00003