GET http://dep.portal.blocbuster.fr/admin/hr/contract/new/7

Query Metrics

5 Database Queries
5 Different statements
65.43 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 14.54 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.98 ms
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.legal_lastname AS legal_lastname_3, t0.legal_firstname AS legal_firstname_4, t0.birth_date AS birth_date_5, t0.birth_place AS birth_place_6, t0.secu_number AS secu_number_7, t0.secu_hash AS secu_hash_8, t0.civility AS civility_9, t0.maiden_name AS maiden_name_10, t0.nationality AS nationality_11, t0.country_of_birth AS country_of_birth_12, t0.marital_status AS marital_status_13, t0.personal_email AS personal_email_14, t0.personal_phone AS personal_phone_15, t0.is_rqth AS is_rqth_16, t0.updated_at AS updated_at_17, t0.address_street AS address_street_18, t0.address_complement AS address_complement_19, t0.address_zip_code AS address_zip_code_20, t0.address_city AS address_city_21, t0.address_country AS address_country_22, t0.bank_account_iban AS bank_account_iban_23, t0.bank_account_bic AS bank_account_bic_24, t0.bank_account_bank_name AS bank_account_bank_name_25, t0.bank_account_account_holder_name AS bank_account_account_holder_name_26, t0.admin_user_id AS admin_user_id_27, t0.club_id AS club_id_28 FROM employee t0 WHERE t0.id = ?
Parameters:
[
  7
]
3 12.74 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
]
4 12.62 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.label AS label_2, c0_.address AS address_3, c0_.postal AS postal_4, c0_.city AS city_5 FROM club c0_ ORDER BY c0_.name ASC
Parameters:
[]
5 12.54 ms
SELECT e0_.id AS id_0, e0_.matricule AS matricule_1, e0_.legal_lastname AS legal_lastname_2, e0_.legal_firstname AS legal_firstname_3, e0_.birth_date AS birth_date_4, e0_.birth_place AS birth_place_5, e0_.secu_number AS secu_number_6, e0_.secu_hash AS secu_hash_7, e0_.civility AS civility_8, e0_.maiden_name AS maiden_name_9, e0_.nationality AS nationality_10, e0_.country_of_birth AS country_of_birth_11, e0_.marital_status AS marital_status_12, e0_.personal_email AS personal_email_13, e0_.personal_phone AS personal_phone_14, e0_.is_rqth AS is_rqth_15, e0_.updated_at AS updated_at_16, e0_.address_street AS address_street_17, e0_.address_complement AS address_complement_18, e0_.address_zip_code AS address_zip_code_19, e0_.address_city AS address_city_20, e0_.address_country AS address_country_21, e0_.bank_account_iban AS bank_account_iban_22, e0_.bank_account_bic AS bank_account_bic_23, e0_.bank_account_bank_name AS bank_account_bank_name_24, e0_.bank_account_account_holder_name AS bank_account_account_holder_name_25, e0_.admin_user_id AS admin_user_id_26, e0_.club_id AS club_id_27 FROM employee e0_
Parameters:
[]

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 7
App\Entity\HR\Employee 7
App\Entity\Club 3

Entities Mapping