GET http://dep.portal.blocbuster.fr/admin/adminUser/7/details/employee

Query Metrics

7 Database Queries
6 Different statements
89.52 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 13.76 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.email AS email_6, t0.planning_conceptor_preferences AS planning_conceptor_preferences_7, t0.related_club_id AS related_club_id_8, t9.id AS id_10, t9.matricule AS matricule_11, t9.legal_lastname AS legal_lastname_12, t9.legal_firstname AS legal_firstname_13, t9.birth_date AS birth_date_14, t9.birth_place AS birth_place_15, t9.secu_number AS secu_number_16, t9.secu_hash AS secu_hash_17, t9.civility AS civility_18, t9.maiden_name AS maiden_name_19, t9.nationality AS nationality_20, t9.country_of_birth AS country_of_birth_21, t9.marital_status AS marital_status_22, t9.personal_email AS personal_email_23, t9.personal_phone AS personal_phone_24, t9.is_rqth AS is_rqth_25, t9.updated_at AS updated_at_26, t9.address_street AS address_street_27, t9.address_complement AS address_complement_28, t9.address_zip_code AS address_zip_code_29, t9.address_city AS address_city_30, t9.address_country AS address_country_31, t9.bank_account_iban AS bank_account_iban_32, t9.bank_account_bic AS bank_account_bic_33, t9.bank_account_bank_name AS bank_account_bank_name_34, t9.bank_account_account_holder_name AS bank_account_account_holder_name_35, t9.admin_user_id AS admin_user_id_36, t9.club_id AS club_id_37 FROM admin t0 LEFT JOIN employee t9 ON t9.admin_user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
2 12.83 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.email AS email_6, t0.planning_conceptor_preferences AS planning_conceptor_preferences_7, t0.related_club_id AS related_club_id_8, t9.id AS id_10, t9.matricule AS matricule_11, t9.legal_lastname AS legal_lastname_12, t9.legal_firstname AS legal_firstname_13, t9.birth_date AS birth_date_14, t9.birth_place AS birth_place_15, t9.secu_number AS secu_number_16, t9.secu_hash AS secu_hash_17, t9.civility AS civility_18, t9.maiden_name AS maiden_name_19, t9.nationality AS nationality_20, t9.country_of_birth AS country_of_birth_21, t9.marital_status AS marital_status_22, t9.personal_email AS personal_email_23, t9.personal_phone AS personal_phone_24, t9.is_rqth AS is_rqth_25, t9.updated_at AS updated_at_26, t9.address_street AS address_street_27, t9.address_complement AS address_complement_28, t9.address_zip_code AS address_zip_code_29, t9.address_city AS address_city_30, t9.address_country AS address_country_31, t9.bank_account_iban AS bank_account_iban_32, t9.bank_account_bic AS bank_account_bic_33, t9.bank_account_bank_name AS bank_account_bank_name_34, t9.bank_account_account_holder_name AS bank_account_account_holder_name_35, t9.admin_user_id AS admin_user_id_36, t9.club_id AS club_id_37 FROM admin t0 LEFT JOIN employee t9 ON t9.admin_user_id = t0.id WHERE t0.id = ?
Parameters:
[
  7
]
3 12.52 ms
SELECT t0.id AS id_1, t0.occurred_at AS occurred_at_2, t0.action AS action_3, t0.ressource_type AS ressource_type_4, t0.ressource_id AS ressource_id_5, t0.route AS route_6, t0.method AS method_7, t0.ip AS ip_8, t0.user_agent AS user_agent_9, t0.context AS context_10, t0.admin_user_id AS admin_user_id_11 FROM audit_log t0 WHERE t0.admin_user_id = ? ORDER BY t0.occurred_at DESC LIMIT 25
Parameters:
[
  7
]
4 12.86 ms
SELECT t0.id AS id_1, t0.job_title AS job_title_2, t0.type AS type_3, t0.classification AS classification_4, t0.gross_monthly_wage AS gross_monthly_wage_5, t0.weekly_hours AS weekly_hours_6, t0.annual_days AS annual_days_7, t0.start_date AS start_date_8, t0.end_date AS end_date_9, t0.probation_period_end AS probation_period_end_10, t0.is_signed AS is_signed_11, t0.document_path AS document_path_12, t0.created_at AS created_at_13, t0.employee_id AS employee_id_14, t0.club_id AS club_id_15 FROM hr_contract t0 WHERE t0.employee_id = ?
Parameters:
[
  7
]
5 12.57 ms
SELECT h0_.id AS id_0, h0_.job_title AS job_title_1, h0_.type AS type_2, h0_.classification AS classification_3, h0_.gross_monthly_wage AS gross_monthly_wage_4, h0_.weekly_hours AS weekly_hours_5, h0_.annual_days AS annual_days_6, h0_.start_date AS start_date_7, h0_.end_date AS end_date_8, h0_.probation_period_end AS probation_period_end_9, h0_.is_signed AS is_signed_10, h0_.document_path AS document_path_11, h0_.created_at AS created_at_12, h0_.employee_id AS employee_id_13, h0_.club_id AS club_id_14 FROM hr_contract h0_ WHERE h0_.employee_id = ? AND h0_.start_date > ? ORDER BY h0_.start_date ASC
Parameters:
[
  7
  "2026-02-11 20:25:14"
]
6 12.48 ms
SELECT h0_.id AS id_0, h0_.job_title AS job_title_1, h0_.type AS type_2, h0_.classification AS classification_3, h0_.gross_monthly_wage AS gross_monthly_wage_4, h0_.weekly_hours AS weekly_hours_5, h0_.annual_days AS annual_days_6, h0_.start_date AS start_date_7, h0_.end_date AS end_date_8, h0_.probation_period_end AS probation_period_end_9, h0_.is_signed AS is_signed_10, h0_.document_path AS document_path_11, h0_.created_at AS created_at_12, h0_.employee_id AS employee_id_13, h0_.club_id AS club_id_14 FROM hr_contract h0_ WHERE h0_.employee_id = ? AND h0_.end_date < ? ORDER BY h0_.end_date DESC
Parameters:
[
  7
  "2026-02-11 20:25:14"
]
7 12.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.address AS address_4, t0.postal AS postal_5, t0.city AS city_6 FROM club t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\Admin 2
App\Entity\HR\Employee 2
App\Entity\Club 1

Entities Mapping