Query Metrics

7 Database Queries
5 Different statements
3.90 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.04 ms
(52.38%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "project"
]
0.60 ms
(15.37%)
2
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
]
0.44 ms
(11.28%)
1
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
]
0.43 ms
(10.91%)
2
SELECT DATABASE()
Parameters:
[]
0.39 ms
(10.05%)
1
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:
[]

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.
App\Entity\UserGroup No errors.
App\Entity\ProjectVersion No errors.
App\Entity\ProjectSponsor No errors.
App\Entity\ProjectResource No errors.
App\Entity\ProjectDeliverable No errors.
App\Entity\ProjectMilestone No errors.
App\Entity\ProjectMemberHistory No errors.
App\Entity\ProjectActivity
  • The association App\Entity\ProjectActivity#activityChats refers to the owning side field App\Entity\ActivityChat#activity which does not exist.
App\Entity\ProjectCollaborationTopic No errors.
App\Entity\ActivityChat No errors.
App\Entity\ProjectPlanRevision No errors.
App\Entity\ProjectPlanStatus No errors.
App\Entity\ProjectPlanComment No errors.
App\Entity\Organization No errors.
App\Entity\PlanModificationRequest No errors.
App\Entity\EmailTemplate No errors.
App\Entity\Goal No errors.