Query Metrics
3
Database Queries
3
Different statements
6.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4.96 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.date_of_birth AS date_of_birth_5, u0_.is_active AS is_active_6, u0_.confirmation_token AS confirmation_token_7, u0_.password_reset_token AS password_reset_token_8, u0_.last_login_at AS last_login_at_9, u0_.phone_number AS phone_number_10, u0_.fonction AS fonction_11, u0_.sex AS sex_12, u0_.avatar AS avatar_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.id AS id_17, u0_.email AS email_18, u0_.password AS password_19, u0_.first_name AS first_name_20, u0_.last_name AS last_name_21, u0_.date_of_birth AS date_of_birth_22, u0_.is_active AS is_active_23, u0_.confirmation_token AS confirmation_token_24, u0_.password_reset_token AS password_reset_token_25, u0_.last_login_at AS last_login_at_26, u0_.phone_number AS phone_number_27, u0_.fonction AS fonction_28, u0_.sex AS sex_29, u0_.avatar AS avatar_30, u0_.created_at AS created_at_31, u0_.updated_at AS updated_at_32, u0_.deleted_at AS deleted_at_33, r1_.id AS id_34, r1_.code AS code_35, r1_.name AS name_36, r1_.description AS description_37, r1_.is_default AS is_default_38, r1_.created_at AS created_at_39, r1_.updated_at AS updated_at_40, r1_.deleted_at AS deleted_at_41, p2_.id AS id_42, p2_.code AS code_43, p2_.name AS name_44, p2_.description AS description_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.deleted_at AS deleted_at_48, u0_.user_preference_id AS user_preference_id_49, u0_.department_id AS department_id_50, u0_.organization_id AS organization_id_51, r1_.department_id AS department_id_52, r1_.organization_id AS organization_id_53, p2_.permission_group_id AS permission_group_id_54 FROM user u0_ LEFT JOIN user_role u3_ ON u0_.id = u3_.user_id LEFT JOIN role r1_ ON r1_.id = u3_.role_id AND (r1_.deleted_at IS NULL) LEFT JOIN role_permission r4_ ON r1_.id = r4_.role_id LEFT JOIN permission p2_ ON p2_.id = r4_.permission_id AND (p2_.deleted_at IS NULL) WHERE (u0_.id = ?) AND (u0_.deleted_at IS NULL)
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 2 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.acronym AS acronym_4, t0.type AS type_5, t0.status AS status_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.progress AS progress_9, t0.currency AS currency_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.department_id AS department_id_14, t0.program_id AS program_id_15, t16.id AS id_17, t16.reference_date AS reference_date_18, t16.date_justification AS date_justification_19, t16.finished AS finished_20, t16.actual_step AS actual_step_21, t16.finished_at AS finished_at_22, t16.created_at AS created_at_23, t16.updated_at AS updated_at_24, t16.project_id AS project_id_25 FROM project t0 LEFT JOIN follow_up_initialization t16 ON t16.project_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"11"
]
|
||||||||||||||||||||||||||||
| 3 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.target AS target_4, t0.achieved AS achieved_5, t0.completion_rate AS completion_rate_6, t0.has_map AS has_map_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.project_id AS project_id_11 FROM output t0 WHERE t0.project_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
11
]
|
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\Department | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\UserPreference | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\PermissionGroup | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\UserAssignment | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Program | No errors. |
| App\Entity\FollowUpInitialization | No errors. |
| App\Entity\Component | No errors. |
| App\Entity\ProjectSettings | No errors. |
| App\Entity\BudgetLine | No errors. |
| App\Entity\PlanVersion | No errors. |
| App\Entity\Output | No errors. |
| App\Entity\Locality | No errors. |
| App\Entity\Objective | No errors. |
| App\Entity\StakeHolder | No errors. |