Query Metrics
5
Database Queries
4
Different statements
37.27 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 7.53 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login_at AS last_login_at_5, t0.last_logout_at AS last_logout_at_6, t0.description AS description_7, t0.lastname AS lastname_8, t0.firstname AS firstname_9, t0.is_first_connexion AS is_first_connexion_10, t0.registration_number AS registration_number_11, t0.hierarchical_level AS hierarchical_level_12, t0.phone_number AS phone_number_13, t0.status AS status_14, t0.active AS active_15, t0.referent AS referent_16, t0.entry_date AS entry_date_17, t0.activation_code AS activation_code_18, t0.activation_code_expired_at AS activation_code_expired_at_19, t0.reset_code AS reset_code_20, t0.reset_code_expired_at AS reset_code_expired_at_21, t0.device_tokens AS device_tokens_22, t0.is_verified AS is_verified_23, t0.profile_color AS profile_color_24, t0.is_internal_account AS is_internal_account_25, t0.elapsed_time AS elapsed_time_26, t0.last_login_notified_at AS last_login_notified_at_27, t0.country_id AS country_id_28, t0.module_id AS module_id_29, t0.subsidiary_company_id AS subsidiary_company_id_30, t0.job_id AS job_id_31, t0.office_id AS office_id_32, t0.contract_id AS contract_id_33, t0.photo_id AS photo_id_34, t0.responsible_id AS responsible_id_35 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
3758
]
|
2 | 7.42 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ LEFT JOIN notification_receiver n1_ ON n0_.id = n1_.notification_id WHERE ((n0_.receiver_id = ? AND n1_.id IS NULL) AND (n0_.is_read IS NULL OR n0_.is_read = 0)) OR (n1_.receiver_id = ? AND (n1_.is_read IS NULL OR n1_.is_read = 0)) LIMIT 1
Parameters:
[ 3758 3758 ] |
3 | 7.47 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.object_type AS object_type_3, n0_.object_id AS object_id_4, n0_.is_read AS is_read_5, n0_.topics AS topics_6, n0_.action AS action_7, n0_.created_at AS created_at_8, n0_.updated_at AS updated_at_9, n1_.id AS id_10, n1_.read_at AS read_at_11, n1_.topics AS topics_12, n1_.created_at AS created_at_13, n1_.is_read AS is_read_14, n0_.receiver_id AS receiver_id_15, n0_.comment_id AS comment_id_16, n0_.module_id AS module_id_17, n0_.subject_id AS subject_id_18, n0_.created_by AS created_by_19, n1_.notification_id AS notification_id_20, n1_.receiver_id AS receiver_id_21 FROM notification n0_ LEFT JOIN notification_receiver n1_ ON n0_.id = n1_.notification_id AND (n1_.receiver_id = ?) WHERE (n0_.receiver_id = ? AND n1_.id IS NULL) OR n1_.receiver_id = ? ORDER BY n0_.created_at DESC LIMIT 12
Parameters:
[ 3758 3758 3758 ] |
4 | 7.47 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login_at AS last_login_at_5, t0.last_logout_at AS last_logout_at_6, t0.description AS description_7, t0.lastname AS lastname_8, t0.firstname AS firstname_9, t0.is_first_connexion AS is_first_connexion_10, t0.registration_number AS registration_number_11, t0.hierarchical_level AS hierarchical_level_12, t0.phone_number AS phone_number_13, t0.status AS status_14, t0.active AS active_15, t0.referent AS referent_16, t0.entry_date AS entry_date_17, t0.activation_code AS activation_code_18, t0.activation_code_expired_at AS activation_code_expired_at_19, t0.reset_code AS reset_code_20, t0.reset_code_expired_at AS reset_code_expired_at_21, t0.device_tokens AS device_tokens_22, t0.is_verified AS is_verified_23, t0.profile_color AS profile_color_24, t0.is_internal_account AS is_internal_account_25, t0.elapsed_time AS elapsed_time_26, t0.last_login_notified_at AS last_login_notified_at_27, t0.country_id AS country_id_28, t0.module_id AS module_id_29, t0.subsidiary_company_id AS subsidiary_company_id_30, t0.job_id AS job_id_31, t0.office_id AS office_id_32, t0.contract_id AS contract_id_33, t0.photo_id AS photo_id_34, t0.responsible_id AS responsible_id_35 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
680
]
|
5 | 7.39 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4 FROM image_manager t0 WHERE t0.id = ?
Parameters:
[
282
]
|
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\User |
|
App\Entity\Country | No errors. |
App\Entity\BaseEntity | No errors. |
App\Entity\Module | No errors. |
App\Entity\SubsidiaryCompany |
|
App\Entity\Job | No errors. |
App\Entity\Office | No errors. |
App\Entity\Contract | No errors. |
App\Entity\ImageManager | No errors. |
App\Entity\UserOffice | No errors. |
App\Entity\Experience | No errors. |
App\Entity\Course | No errors. |
App\Entity\Role | No errors. |
App\Entity\Enrollment | No errors. |
App\Entity\ModuleView | No errors. |
App\Entity\ModuleLike | No errors. |
App\Entity\UserQuizQuestion | No errors. |
App\Entity\Quote | No errors. |
App\Entity\Director | No errors. |
App\Entity\Live | No errors. |
App\Entity\LiveParticipant | No errors. |
App\Entity\ModuleComment | No errors. |
App\Entity\ProgramParticipation | No errors. |
App\Entity\ModuleParticipation | No errors. |
App\Entity\ModuleInscription | No errors. |
App\Entity\Discussion | No errors. |
App\Entity\Message |
|
App\Entity\Program | No errors. |
App\Entity\UserModuleParticipation | No errors. |
App\Entity\Notification | No errors. |
App\Entity\NotificationReceiver | No errors. |
App\Entity\Comment | No errors. |
App\Entity\Subject | No errors. |