https://inout.mante.solutions/vacations/notesApproved/138

Query Metrics

5 Database Queries
4 Different statements
5.75 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.