Query Metrics
1
Database Queries
1
Different statements
0.66 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.directory_path AS directory_path_6, t0.one_time_code AS one_time_code_7, t0.role AS role_8, t0.expiration_one_time_code AS expiration_one_time_code_9, t0.office_hours AS office_hours_10, t0.is_active AS is_active_11, t0.is_admin_active AS is_admin_active_12, t0.is_email_notification_active AS is_email_notification_active_13, t0.is_alert_read AS is_alert_read_14, t0.is_gdpr_sent AS is_gdpr_sent_15, t16.id AS id_17, t16.datetime_last_update AS datetime_last_update_18, t16.is_terms_accepted AS is_terms_accepted_19, t16.is_news_accepted AS is_news_accepted_20, t16.user_id AS user_id_21, t22.id AS id_23, t22.country_code AS country_code_24, t22.phone AS phone_25, t22.fax AS fax_26, t22.mobile AS mobile_27, t22.address AS address_28, t22.zip AS zip_29, t22.other_city AS other_city_30, t22.other_province AS other_province_31, t22.avatar AS avatar_32, t22.user_id AS user_id_33, t22.city_id AS city_id_34, t22.user_profession_id AS user_profession_id_35, t36.id AS id_37, t36.residue_rol AS residue_rol_38, t36.residue_holiday AS residue_holiday_39, t36.datetime_start_work AS datetime_start_work_40, t36.datetime_end_work AS datetime_end_work_41, t36.show_in_list AS show_in_list_42, t36.user_id AS user_id_43, t36.supervisor_id AS supervisor_id_44, t0.account_type_id AS account_type_id_45 FROM til_user t0 LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id LEFT JOIN til_employee t36 ON t36.user_id = t0.id WHERE t0.id = ?
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 1 |
| App\Entity\UserAccountType | 1 |
| App\Entity\UserPrivacy | 1 |
| App\Entity\UserProfile | 1 |
| App\Entity\City | 1 |
| App\Entity\UserProfession | 1 |
| App\Entity\Employee | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\UserPrivacy | No errors. |
| App\Entity\UserProfile | No errors. |
| App\Entity\City | No errors. |
| App\Entity\UserProfession | No errors. |
| App\Entity\Employee | No errors. |
| App\Entity\UserAccountType | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Log | No errors. |
| App\Entity\JoinTableUserTest | No errors. |
| App\Entity\TestCode | No errors. |
| App\Entity\TestAnswer | No errors. |
| App\Entity\JoinTableUserPermission | No errors. |
| App\Entity\EmployeeLeasing | No errors. |
| App\Entity\EmployeeHolidayYear | No errors. |
| App\Entity\EmployeeHolidayRequest | No errors. |
| App\Entity\EmployeeActivityYear | No errors. |
| App\Entity\EmployeeActivity | No errors. |
| App\Entity\EmployeePresenceYear | No errors. |
| App\Entity\EmployeeRefundYear | No errors. |
| App\Entity\BudgetEmployee | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\OfferRequest | No errors. |
| App\Entity\Sell | No errors. |
| App\Entity\HospitalFacility | No errors. |
| App\Entity\Province | No errors. |