GET https://bcc-project-tracker.com/projects/81

Query Metrics

6 Database Queries
5 Different statements
2.17 ms Query time
1 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.is_investment_project AS is_investment_project_4, t0.planned_budget AS planned_budget_5, t0.realized_budget AS realized_budget_6, t0.status AS status_7, t0.planned_start_date AS planned_start_date_8, t0.planned_end_date AS planned_end_date_9, t0.actual_start_date AS actual_start_date_10, t0.actual_end_date AS actual_end_date_11, t0.created_at AS created_at_12, t0.market_type AS market_type_13, t0.is_deleted AS is_deleted_14, t0.title AS title_15, t0.phase AS phase_16, t0.description AS description_17, t0.is_sub_project AS is_sub_project_18, t0.currency_id AS currency_id_19, t0.site_id AS site_id_20, t0.objective_id AS objective_id_21, t0.administrative_unit_id AS administrative_unit_id_22, t0.budget_item_id AS budget_item_id_23, t0.main_project_id AS main_project_id_24 FROM project t0 WHERE t0.id = ?
Parameters:
[
  81
]
2 0.52 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.planned_budget AS planned_budget_4, t0.executed_budget AS executed_budget_5, t0.planned_start_date AS planned_start_date_6, t0.planned_end_date AS planned_end_date_7, t0.actual_start_date AS actual_start_date_8, t0.actual_end_date AS actual_end_date_9, t0.position AS position_10, t0.status AS status_11, t0.progress_percentage AS progress_percentage_12, t0.notes AS notes_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.project_id AS project_id_17 FROM project_steps t0 WHERE t0.project_id = ?
Parameters:
[
  81
]
3 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.accronym AS accronym_3, t0.type AS type_4, t0.is_deleted AS is_deleted_5 FROM administrative_unit t0 WHERE t0.id = ?
Parameters:
[
  24
]
4 0.23 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.position AS position_3, t0.label AS label_4, t0.description AS description_5, t0.type AS type_6, t0.start_date AS start_date_7, t0.deadline AS deadline_8, t0.status AS status_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.higher_objective_id AS higher_objective_id_12, t0.administrative_unit_id AS administrative_unit_id_13 FROM objective t0 WHERE t0.id = ?
Parameters:
[
  44
]
5 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.amount AS amount_4, t0.expense_date AS expense_date_5, t0.category AS category_6, t0.provider AS provider_7, t0.invoice_number AS invoice_number_8, t0.payment_method AS payment_method_9, t0.receipt_number AS receipt_number_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.validated_at AS validated_at_14, t0.status AS status_15, t0.project_step_id AS project_step_id_16, t0.project_id AS project_id_17, t0.created_by_id AS created_by_id_18, t0.validated_by_id AS validated_by_id_19 FROM expense t0 WHERE t0.project_id = ?
Parameters:
[
  81
]
6 0.24 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.planned_budget AS planned_budget_4, t0.executed_budget AS executed_budget_5, t0.planned_start_date AS planned_start_date_6, t0.planned_end_date AS planned_end_date_7, t0.actual_start_date AS actual_start_date_8, t0.actual_end_date AS actual_end_date_9, t0.position AS position_10, t0.status AS status_11, t0.progress_percentage AS progress_percentage_12, t0.notes AS notes_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.project_id AS project_id_17 FROM project_steps t0 WHERE t0.project_id = ?
Parameters:
[
  81
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Objective 2
App\Entity\AdministrativeUnit 2
App\Entity\Project 1
App\Entity\Currency 1
App\Entity\BudgetItem 1

Entities Mapping

Class Mapping errors
App\Entity\Project No errors.
App\Entity\Currency
  • The association App\Entity\Currency#deviseCible refers to the owning side field App\Entity\ConversionDevise#devise_source which does not exist.
App\Entity\Site No errors.
App\Entity\Objective No errors.
App\Entity\AdministrativeUnit No errors.
App\Entity\BudgetItem No errors.
App\Entity\ProjectSteps No errors.
App\Entity\Expense No errors.
App\Entity\User No errors.