Query Metrics
5
Database Queries
4
Different statements
5.75 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.84 ms |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"simona.minzat@inout-travel.com"
]
|
2 | 0.21 ms |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"simona.minzat@inout-travel.com"
]
|
3 | 0.61 ms |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.id = ? AND t0.status = ? LIMIT 1
Parameters:
[ "138" 1 ] |
4 | 3.35 ms |
SELECT v0_.id AS id_0, v0_.idv AS idv_1, v0_.idu AS idu_2, v0_.date AS date_3, v0_.status AS status_4, v0_.status_boss AS status_boss_5, v0_.updated_id AS updated_id_6, v0_.createdAt AS createdAt_7, v0_.updatedAt AS updatedAt_8 FROM vacations_validation v0_ WHERE v0_.status_boss = 1 AND YEAR(v0_.date) >= ? AND v0_.idu IN (SELECT u1_.id FROM users u1_ WHERE u1_.id_team IN (?))
Parameters:
[ "2025" 8 ] |
5 | 0.74 ms |
SELECT h0_.id AS id_0, h0_.idv AS idv_1, h0_.idu AS idu_2, h0_.date AS date_3, h0_.horario AS horario_4, h0_.status AS status_5, h0_.status_boss AS status_boss_6, h0_.updated_id AS updated_id_7, h0_.createdAt AS createdAt_8, h0_.updatedAt AS updatedAt_9 FROM half_day_validation h0_ WHERE h0_.status_boss = 1 AND YEAR(h0_.date) >= ? AND 1 = (SELECT h1_.status FROM half_day h1_ WHERE h1_.id = h0_.idv) AND h0_.idu IN (SELECT u2_.id FROM users u2_ WHERE u2_.id_team = ?)
Parameters:
[ "2025" 8 ] |
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 | No errors. |
App\Entity\VacationsValidation | No errors. |
App\Entity\HalfDayValidation | No errors. |
App\Entity\HalfDay | No errors. |