| Profiling Summary Report (Time: 0.07830s, Memory: 4,802KB) | |||||
|---|---|---|---|---|---|
| Procedure | Count | Total (s) | Avg. (s) | Min. (s) | Max. (s) |
| WebApplication::createController | 2 | 0.13036 | 0.06518 | 0.06508 | 0.06528 |
| appRun | 1 | 0.07003 | 0.07003 | 0.07003 | 0.07003 |
| Organization::afterFind() | 3 | 0.02490 | 0.00830 | 0.00373 | 0.01711 |
| Controller::init() | 1 | 0.00675 | 0.00675 | 0.00675 | 0.00675 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `challenge`) | 1 | 0.00217 | 0.00217 | 0.00217 | 0.00217 |
| Controller::beforeAction() | 1 | 0.00178 | 0.00178 | 0.00178 | 0.00178 |
| system.db.CDbCommand.query(SELECT `ownerOrganization`.`id` AS `t1_c0`, `ownerOrganization`.`code` AS `t1_c1`, `ownerOrganization`.`slug` AS `t1_c2`, `ownerOrganization`.`title` AS `t1_c3`, `ownerOrganization`.`text_oneliner` AS `t1_c4`, `ownerOrganization`.`html_content` AS `t1_c5`, `ownerOrganization`.`text_short_description` AS `t1_c6`, `ownerOrganization`.`legalform_id` AS `t1_c7`, `ownerOrganization`.`company_number` AS `t1_c8`, `ownerOrganization`.`image_logo` AS `t1_c9`, `ownerOrganization`.`url_website` AS `t1_c10`, `ownerOrganization`.`email_contact` AS `t1_c11`, `ownerOrganization`.`timezone` AS `t1_c12`, `ownerOrganization`.`year_founded` AS `t1_c13`, `ownerOrganization`.`is_active` AS `t1_c14`, `ownerOrganization`.`date_added` AS `t1_c15`, `ownerOrganization`.`date_modified` AS `t1_c16`, `ownerOrganization`.`legal_name` AS `t1_c17`, `ownerOrganization`.`full_address` AS `t1_c18`, `ownerOrganization`.`address_line1` AS `t1_c19`, `ownerOrganization`.`address_line2` AS `t1_c20`, `ownerOrganization`.`address_zip` AS `t1_c21`, `ownerOrganization`.`address_city` AS `t1_c22`, `ownerOrganization`.`address_state` AS `t1_c23`, `ownerOrganization`.`address_country_code` AS `t1_c24`, `ownerOrganization`.`latlong_address` AS `t1_c25`, `ownerOrganization`.`startup_stage_id` AS `t1_c26`, `ownerOrganization`.`score_completeness` AS `t1_c27`, `ownerOrganization`.`latest_status` AS `t1_c28`, `ownerOrganization`.`total_revenue` AS `t1_c29`, `ownerOrganization`.`total_funding` AS `t1_c30`, `ownerOrganization`.`total_funding_disclosed` AS `t1_c31`, `ownerOrganization`.`total_funding_publicized` AS `t1_c32`, `ownerOrganization`.`latest_funding_round_ordering` AS `t1_c33`, `ownerOrganization`.`latest_funding_round` AS `t1_c34`, ST_AsText(`ownerOrganization`.`latlong_address`) AS ownerOrganization_latlong_address FROM `organization` `ownerOrganization` WHERE (`ownerOrganization`.`id`=:ypl0). Bound with :ypl0='3003') | 1 | 0.00108 | 0.00108 | 0.00108 | 0.00108 |
| system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`owner_organization_id`, `t`.`creator_user_id`, `t`.`title`, `t`.`text_short_description`, `t`.`html_content`, `t`.`image_cover`, `t`.`image_header`, `t`.`url_video`, `t`.`url_application_form`, `t`.`application_form_id`, `t`.`html_deliverable`, `t`.`html_criteria`, `t`.`prize_title`, `t`.`html_prize_detail`, `t`.`date_open`, `t`.`date_close`, `t`.`ordering`, `t`.`text_remark`, `t`.`text_note`, `t`.`json_extra`, `t`.`status`, `t`.`timezone`, `t`.`is_active`, `t`.`is_publish`, `t`.`is_highlight`, `t`.`process_by`, `t`.`date_submit`, `t`.`date_process`, `t`.`date_added`, `t`.`date_modified` FROM `challenge` `t` LEFT JOIN organization as o ON o.id=t.owner_organization_id WHERE t.status='approved' AND t.is_active=1 AND o.is_active=1 AND t.is_publish=1 ORDER BY date_close DESC LIMIT 12 OFFSET 12) | 1 | 0.00095 | 0.00095 | 0.00095 | 0.00095 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) | 1 | 0.00086 | 0.00086 | 0.00086 | 0.00086 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `challenge` `t`) | 3 | 0.00082 | 0.00027 | 0.00023 | 0.00032 |
| Organization::init() | 3 | 0.00080 | 0.00027 | 0.00025 | 0.00028 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) | 1 | 0.00066 | 0.00066 | 0.00066 | 0.00066 |
| 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=3001) | 1 | 0.00062 | 0.00062 | 0.00062 | 0.00062 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) | 1 | 0.00060 | 0.00060 | 0.00060 | 0.00060 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) | 1 | 0.00059 | 0.00059 | 0.00059 | 0.00059 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) | 1 | 0.00059 | 0.00059 | 0.00059 | 0.00059 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) | 1 | 0.00057 | 0.00057 | 0.00057 | 0.00057 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) | 1 | 0.00056 | 0.00056 | 0.00056 | 0.00056 |
| 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=3002) | 1 | 0.00055 | 0.00055 | 0.00055 | 0.00055 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) | 1 | 0.00054 | 0.00054 | 0.00054 | 0.00054 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2challenge`) | 1 | 0.00052 | 0.00052 | 0.00052 | 0.00052 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) | 1 | 0.00052 | 0.00052 | 0.00052 | 0.00052 |
| 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='3003') | 1 | 0.00051 | 0.00051 | 0.00051 | 0.00051 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) | 1 | 0.00050 | 0.00050 | 0.00050 | 0.00050 |
| 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=3003) | 1 | 0.00050 | 0.00050 | 0.00050 | 0.00050 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) | 1 | 0.00049 | 0.00049 | 0.00049 | 0.00049 |
| system.db.CDbCommand.query(SELECT `ownerOrganization`.`id` AS `t1_c0`, `ownerOrganization`.`code` AS `t1_c1`, `ownerOrganization`.`slug` AS `t1_c2`, `ownerOrganization`.`title` AS `t1_c3`, `ownerOrganization`.`text_oneliner` AS `t1_c4`, `ownerOrganization`.`html_content` AS `t1_c5`, `ownerOrganization`.`text_short_description` AS `t1_c6`, `ownerOrganization`.`legalform_id` AS `t1_c7`, `ownerOrganization`.`company_number` AS `t1_c8`, `ownerOrganization`.`image_logo` AS `t1_c9`, `ownerOrganization`.`url_website` AS `t1_c10`, `ownerOrganization`.`email_contact` AS `t1_c11`, `ownerOrganization`.`timezone` AS `t1_c12`, `ownerOrganization`.`year_founded` AS `t1_c13`, `ownerOrganization`.`is_active` AS `t1_c14`, `ownerOrganization`.`date_added` AS `t1_c15`, `ownerOrganization`.`date_modified` AS `t1_c16`, `ownerOrganization`.`legal_name` AS `t1_c17`, `ownerOrganization`.`full_address` AS `t1_c18`, `ownerOrganization`.`address_line1` AS `t1_c19`, `ownerOrganization`.`address_line2` AS `t1_c20`, `ownerOrganization`.`address_zip` AS `t1_c21`, `ownerOrganization`.`address_city` AS `t1_c22`, `ownerOrganization`.`address_state` AS `t1_c23`, `ownerOrganization`.`address_country_code` AS `t1_c24`, `ownerOrganization`.`latlong_address` AS `t1_c25`, `ownerOrganization`.`startup_stage_id` AS `t1_c26`, `ownerOrganization`.`score_completeness` AS `t1_c27`, `ownerOrganization`.`latest_status` AS `t1_c28`, `ownerOrganization`.`total_revenue` AS `t1_c29`, `ownerOrganization`.`total_funding` AS `t1_c30`, `ownerOrganization`.`total_funding_disclosed` AS `t1_c31`, `ownerOrganization`.`total_funding_publicized` AS `t1_c32`, `ownerOrganization`.`latest_funding_round_ordering` AS `t1_c33`, `ownerOrganization`.`latest_funding_round` AS `t1_c34`, ST_AsText(`ownerOrganization`.`latlong_address`) AS ownerOrganization_latlong_address FROM `organization` `ownerOrganization` WHERE (`ownerOrganization`.`id`=:ypl0). Bound with :ypl0='3002') | 1 | 0.00048 | 0.00048 | 0.00048 | 0.00048 |
| system.db.CDbCommand.query(SELECT `ownerOrganization`.`id` AS `t1_c0`, `ownerOrganization`.`code` AS `t1_c1`, `ownerOrganization`.`slug` AS `t1_c2`, `ownerOrganization`.`title` AS `t1_c3`, `ownerOrganization`.`text_oneliner` AS `t1_c4`, `ownerOrganization`.`html_content` AS `t1_c5`, `ownerOrganization`.`text_short_description` AS `t1_c6`, `ownerOrganization`.`legalform_id` AS `t1_c7`, `ownerOrganization`.`company_number` AS `t1_c8`, `ownerOrganization`.`image_logo` AS `t1_c9`, `ownerOrganization`.`url_website` AS `t1_c10`, `ownerOrganization`.`email_contact` AS `t1_c11`, `ownerOrganization`.`timezone` AS `t1_c12`, `ownerOrganization`.`year_founded` AS `t1_c13`, `ownerOrganization`.`is_active` AS `t1_c14`, `ownerOrganization`.`date_added` AS `t1_c15`, `ownerOrganization`.`date_modified` AS `t1_c16`, `ownerOrganization`.`legal_name` AS `t1_c17`, `ownerOrganization`.`full_address` AS `t1_c18`, `ownerOrganization`.`address_line1` AS `t1_c19`, `ownerOrganization`.`address_line2` AS `t1_c20`, `ownerOrganization`.`address_zip` AS `t1_c21`, `ownerOrganization`.`address_city` AS `t1_c22`, `ownerOrganization`.`address_state` AS `t1_c23`, `ownerOrganization`.`address_country_code` AS `t1_c24`, `ownerOrganization`.`latlong_address` AS `t1_c25`, `ownerOrganization`.`startup_stage_id` AS `t1_c26`, `ownerOrganization`.`score_completeness` AS `t1_c27`, `ownerOrganization`.`latest_status` AS `t1_c28`, `ownerOrganization`.`total_revenue` AS `t1_c29`, `ownerOrganization`.`total_funding` AS `t1_c30`, `ownerOrganization`.`total_funding_disclosed` AS `t1_c31`, `ownerOrganization`.`total_funding_publicized` AS `t1_c32`, `ownerOrganization`.`latest_funding_round_ordering` AS `t1_c33`, `ownerOrganization`.`latest_funding_round` AS `t1_c34`, ST_AsText(`ownerOrganization`.`latlong_address`) AS ownerOrganization_latlong_address FROM `organization` `ownerOrganization` WHERE (`ownerOrganization`.`id`=:ypl0). Bound with :ypl0='3001') | 1 | 0.00048 | 0.00048 | 0.00048 | 0.00048 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) | 1 | 0.00047 | 0.00047 | 0.00047 | 0.00047 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) | 1 | 0.00047 | 0.00047 | 0.00047 | 0.00047 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `challenge`) | 1 | 0.00046 | 0.00046 | 0.00046 | 0.00046 |
| 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='3001') | 1 | 0.00044 | 0.00044 | 0.00044 | 0.00044 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) | 1 | 0.00044 | 0.00044 | 0.00044 | 0.00044 |
| 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='3003') | 1 | 0.00044 | 0.00044 | 0.00044 | 0.00044 |
| 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='3002') | 1 | 0.00043 | 0.00043 | 0.00043 | 0.00043 |
| system.db.CDbCommand.query(SELECT MAX(date_modified) FROM challenge) | 1 | 0.00041 | 0.00041 | 0.00041 | 0.00041 |
| 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 `industry2challenge` `industries_industries` ON (`industries_industries`.`challenge_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='23') | 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='3003') | 1 | 0.00039 | 0.00039 | 0.00039 | 0.00039 |
| 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='3001') | 1 | 0.00039 | 0.00039 | 0.00039 | 0.00039 |
| 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='3003') | 1 | 0.00038 | 0.00038 | 0.00038 | 0.00038 |
| 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='3003') | 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='3002') | 1 | 0.00038 | 0.00038 | 0.00038 | 0.00038 |
| 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='3003') | 1 | 0.00037 | 0.00037 | 0.00037 | 0.00037 |
| 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='3002') | 1 | 0.00037 | 0.00037 | 0.00037 | 0.00037 |
| 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='3001') | 1 | 0.00036 | 0.00036 | 0.00036 | 0.00036 |
| 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='3002') | 1 | 0.00036 | 0.00036 | 0.00036 | 0.00036 |
| system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2challenge et ON t.id = et.tag_id WHERE et.challenge_id = :ownerid . Bound with :ownerid='27') | 1 | 0.00036 | 0.00036 | 0.00036 | 0.00036 |
| system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2challenge et ON t.id = et.tag_id WHERE et.challenge_id = :ownerid . Bound with :ownerid='23') | 1 | 0.00033 | 0.00033 | 0.00033 | 0.00033 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) | 1 | 0.00033 | 0.00033 | 0.00033 | 0.00033 |
| 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='3001') | 1 | 0.00033 | 0.00033 | 0.00033 | 0.00033 |
| 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='3001') | 1 | 0.00033 | 0.00033 | 0.00033 | 0.00033 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) | 1 | 0.00032 | 0.00032 | 0.00032 | 0.00032 |
| 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='3002') | 1 | 0.00031 | 0.00031 | 0.00031 | 0.00031 |
| 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='3001') | 1 | 0.00031 | 0.00031 | 0.00031 | 0.00031 |
| system.db.CDbCommand.query(SELECT t.name as `name` FROM `tag` `t` INNER JOIN tag2challenge et ON t.id = et.tag_id WHERE et.challenge_id = :ownerid . Bound with :ownerid='28') | 1 | 0.00031 | 0.00031 | 0.00031 | 0.00031 |
| 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='3001') | 1 | 0.00031 | 0.00031 | 0.00031 | 0.00031 |
| 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='3002') | 1 | 0.00030 | 0.00030 | 0.00030 | 0.00030 |
| 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='3003') | 1 | 0.00030 | 0.00030 | 0.00030 | 0.00030 |
| 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 `industry2challenge` `industries_industries` ON (`industries_industries`.`challenge_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='28') | 1 | 0.00030 | 0.00030 | 0.00030 | 0.00030 |
| 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='3002') | 1 | 0.00029 | 0.00029 | 0.00029 | 0.00029 |
| 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 `industry2challenge` `industries_industries` ON (`industries_industries`.`challenge_id`=:ypl0) AND (`industries`.`id`=`industries_industries`.`industry_id`). Bound with :ypl0='27') | 1 | 0.00029 | 0.00029 | 0.00029 | 0.00029 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `industry2challenge`) | 1 | 0.00025 | 0.00025 | 0.00025 | 0.00025 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) | 1 | 0.00025 | 0.00025 | 0.00025 | 0.00025 |
| 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.00023 | 0.00023 | 0.00023 | 0.00023 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) | 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 `impact`) | 1 | 0.00022 | 0.00022 | 0.00022 | 0.00022 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) | 1 | 0.00022 | 0.00022 | 0.00022 | 0.00022 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) | 1 | 0.00022 | 0.00022 | 0.00022 | 0.00022 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) | 1 | 0.00021 | 0.00021 | 0.00021 | 0.00021 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) | 1 | 0.00021 | 0.00021 | 0.00021 | 0.00021 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) | 1 | 0.00021 | 0.00021 | 0.00021 | 0.00021 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) | 1 | 0.00020 | 0.00020 | 0.00020 | 0.00020 |
| Organization::behaviors() | 4 | 0.00019 | 0.00005 | 0.00003 | 0.00011 |
| WebApplication::createController::override | 1 | 0.00001 | 0.00001 | 0.00001 | 0.00001 |