Query Metrics
7
Database Queries
6
Different statements
89.52 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | 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
| Class | Mapping errors |
|---|---|
| App\Entity\Admin | No errors. |
| App\Entity\Club | No errors. |
| App\Entity\HR\Address | No errors. |
| App\Entity\HR\BankAccount | No errors. |
| App\Entity\HR\Employee | No errors. |
| App\Entity\AuditLog | No errors. |
| App\Entity\HR\Contract | No errors. |
| App\Entity\Planning\Shift | No errors. |
| App\Entity\Planning\Absence | No errors. |
| App\Entity\Planning\Teams | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\Entrance | No errors. |