|
Profiling Summary Report
(Time: 0.05612s,
Memory: 4,467KB)
|
| Procedure |
Count |
Total (s) |
Avg. (s) |
Min. (s) |
Max. (s) |
| WebApplication::createController |
2 |
0.08636 |
0.04318 |
0.04309 |
0.04327 |
| appRun |
1 |
0.04849 |
0.04849 |
0.04849 |
0.04849 |
| Organization::afterFind() |
1 |
0.02089 |
0.02089 |
0.02089 |
0.02089 |
| Controller::init() |
1 |
0.00680 |
0.00680 |
0.00680 |
0.00680 |
| Controller::beforeAction() |
1 |
0.00132 |
0.00132 |
0.00132 |
0.00132 |
| system.db.CDbCommand.query(SELECT *, ST_AsText(`t`.`latlong_address`) AS latlong_address FROM `job_vacancy` `t` WHERE t.status='approved' AND t.is_active=1 AND t.is_publish=1 AND t.owner_organization_id != :masterOrganizationId ORDER BY t.date_submit DESC LIMIT 30 OFFSET 30. Bound with :masterOrganizationId='163') |
1 |
0.00107 |
0.00107 |
0.00107 |
0.00107 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization`) |
1 |
0.00096 |
0.00096 |
0.00096 |
0.00096 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `setting`) |
1 |
0.00089 |
0.00089 |
0.00089 |
0.00089 |
| Organization::init() |
1 |
0.00085 |
0.00085 |
0.00085 |
0.00085 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `job_vacancy`) |
1 |
0.00080 |
0.00080 |
0.00080 |
0.00080 |
| 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.00068 |
0.00068 |
0.00068 |
0.00068 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification`) |
1 |
0.00064 |
0.00064 |
0.00064 |
0.00064 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona`) |
1 |
0.00061 |
0.00061 |
0.00061 |
0.00061 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact2organization`) |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg`) |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `organization_alternative_name`) |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tag`) |
1 |
0.00057 |
0.00057 |
0.00057 |
0.00057 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `impact`) |
1 |
0.00057 |
0.00057 |
0.00057 |
0.00057 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `meta_item`) |
1 |
0.00055 |
0.00055 |
0.00055 |
0.00055 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry`) |
1 |
0.00055 |
0.00055 |
0.00055 |
0.00055 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `classification2organization`) |
1 |
0.00055 |
0.00055 |
0.00055 |
0.00055 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `persona2organization`) |
1 |
0.00054 |
0.00054 |
0.00054 |
0.00054 |
| system.db.CDbCommand.query(SELECT MAX(date_modified) FROM job_vacancy) |
1 |
0.00049 |
0.00049 |
0.00049 |
0.00049 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `sdg2organization`) |
1 |
0.00049 |
0.00049 |
0.00049 |
0.00049 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `industry2organization`) |
1 |
0.00045 |
0.00045 |
0.00045 |
0.00045 |
| 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.00044 |
0.00044 |
0.00044 |
0.00044 |
| 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.00042 |
0.00042 |
0.00042 |
0.00042 |
| system.db.CDbCommand.query(SELECT * FROM `setting` `t` WHERE code=:code LIMIT 1. Bound with :code='organization-master-code') |
1 |
0.00037 |
0.00037 |
0.00037 |
0.00037 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `job_vacancy`) |
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='163') |
1 |
0.00036 |
0.00036 |
0.00036 |
0.00036 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `classification2organization`) |
1 |
0.00035 |
0.00035 |
0.00035 |
0.00035 |
| 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.00035 |
0.00035 |
0.00035 |
0.00035 |
| 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.00034 |
0.00034 |
0.00034 |
0.00034 |
| 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.00034 |
0.00034 |
0.00034 |
0.00034 |
| 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.00034 |
0.00034 |
0.00034 |
0.00034 |
| 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.00033 |
0.00033 |
0.00033 |
0.00033 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `organization_alternative_name`) |
1 |
0.00032 |
0.00032 |
0.00032 |
0.00032 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `setting`) |
1 |
0.00032 |
0.00032 |
0.00032 |
0.00032 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `organization`) |
1 |
0.00030 |
0.00030 |
0.00030 |
0.00030 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `classification`) |
1 |
0.00026 |
0.00026 |
0.00026 |
0.00026 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `sdg`) |
1 |
0.00026 |
0.00026 |
0.00026 |
0.00026 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `tag`) |
1 |
0.00026 |
0.00026 |
0.00026 |
0.00026 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `persona`) |
1 |
0.00025 |
0.00025 |
0.00025 |
0.00025 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `impact`) |
1 |
0.00024 |
0.00024 |
0.00024 |
0.00024 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `sdg2organization`) |
1 |
0.00022 |
0.00022 |
0.00022 |
0.00022 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `industry`) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `meta_item`) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `persona2organization`) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `impact2organization`) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `industry2organization`) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| Organization::behaviors() |
2 |
0.00014 |
0.00007 |
0.00003 |
0.00011 |
| WebApplication::createController::override |
1 |
0.00002 |
0.00002 |
0.00002 |
0.00002 |