Query Metrics

4 Database Queries
3 Different statements
1.43 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.44 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.is_working_on_task AS is_working_on_task_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.created_by_id AS created_by_id_6, t0.project_id AS project_id_7, t0.role_id AS role_id_8 FROM project_members t0 WHERE t0.user_id IS NULL AND t0.status = ?
Parameters:
[
  1
]
2 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.amount AS amount_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.outcome AS outcome_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.baseline AS baseline_10, t0.planned_value AS planned_value_11, t0.active AS active_12, t0.project_manager_id AS project_manager_id_13, t0.currency_id AS currency_id_14, t0.program_id AS program_id_15, t0.created_by_id AS created_by_id_16, t0.unit_id AS unit_id_17, t0.objective_id AS objective_id_18 FROM project t0 WHERE t0.project_manager_id IS NULL
Parameters:
[]
3 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.amount AS amount_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.outcome AS outcome_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.baseline AS baseline_10, t0.planned_value AS planned_value_11, t0.active AS active_12, t0.project_manager_id AS project_manager_id_13, t0.currency_id AS currency_id_14, t0.program_id AS program_id_15, t0.created_by_id AS created_by_id_16, t0.unit_id AS unit_id_17, t0.objective_id AS objective_id_18 FROM project t0 WHERE t0.id IN (NULL) AND t0.status = ?
Parameters:
[
  1
]
4 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.amount AS amount_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.outcome AS outcome_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.baseline AS baseline_10, t0.planned_value AS planned_value_11, t0.active AS active_12, t0.project_manager_id AS project_manager_id_13, t0.currency_id AS currency_id_14, t0.program_id AS program_id_15, t0.created_by_id AS created_by_id_16, t0.unit_id AS unit_id_17, t0.objective_id AS objective_id_18 FROM project t0 WHERE t0.id IN (NULL) AND t0.status = ?
Parameters:
[
  2
]

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.

Entities Mapping

Class Mapping errors
App\Entity\ProjectMembers No errors.
App\Entity\User No errors.
App\Entity\Project
  • The association App\Entity\Project#activityChats refers to the owning side field App\Entity\ActivityChat#project which does not exist.
App\Entity\ProjectStructure No errors.
App\Entity\Currency No errors.
App\Entity\Program No errors.
App\Entity\OrganizationUnit No errors.
App\Entity\Objective No errors.