Query Metrics
5
Database Queries
5
Different statements
10.62 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
4.00 ms (37.64%) |
1 |
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.honorific_prefix AS honorific_prefix_3, t0.given_name AS given_name_4, t0.additional_name AS additional_name_5, t0.family_name AS family_name_6, t0.honorific_suffix AS honorific_suffix_7, t0.nickname AS nickname_8, t0.gender AS gender_9, t0.date_of_birth AS date_of_birth_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.email AS email_13, t0.password AS password_14, t0.reset_token AS reset_token_15, t0.roles AS roles_16, t0.active AS active_17, t0.country AS country_18, t0.language AS language_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.last_login_at AS last_login_at_22, t0.last_login_from AS last_login_from_23, t0.is_verified AS is_verified_24, t0.user_filters AS user_filters_25, t0.profile_picture_name AS profile_picture_name_26, t0.detail AS detail_27, t0.adresse AS adresse_28, t0.complement_adresse AS complement_adresse_29, t0.ville AS ville_30, t0.code_postal AS code_postal_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.reference AS reference_34, t0.reference_uuid AS reference_uuid_35, t0.archived AS archived_36, t0.account_id AS account_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
104
]
|
||||||||||||||||||||||||||||||
|
3.10 ms (29.14%) |
1 |
SELECT t0.id AS id_1, t0.category AS category_2, t0.nom_structure AS nom_structure_3, t0.comment AS comment_4, t0.company AS company_5, t0.company_tva AS company_tva_6, t0.siret AS siret_7, t0.type_juridique AS type_juridique_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.reference AS reference_11, t0.reference_uuid AS reference_uuid_12, t0.archived AS archived_13, t0.avatar_name AS avatar_name_14, t0.avatar_original_name AS avatar_original_name_15, t0.avatar_mime_type AS avatar_mime_type_16, t0.avatar_size AS avatar_size_17, t0.avatar_dimensions AS avatar_dimensions_18, t0.profil_id AS profil_id_19, t0.edition_id AS edition_id_20, t21.id AS id_22, t21.full_name AS full_name_23, t21.honorific_prefix AS honorific_prefix_24, t21.given_name AS given_name_25, t21.additional_name AS additional_name_26, t21.family_name AS family_name_27, t21.honorific_suffix AS honorific_suffix_28, t21.nickname AS nickname_29, t21.gender AS gender_30, t21.date_of_birth AS date_of_birth_31, t21.phone AS phone_32, t21.mobile AS mobile_33, t21.email AS email_34, t21.password AS password_35, t21.reset_token AS reset_token_36, t21.roles AS roles_37, t21.active AS active_38, t21.country AS country_39, t21.language AS language_40, t21.locale AS locale_41, t21.timezone AS timezone_42, t21.last_login_at AS last_login_at_43, t21.last_login_from AS last_login_from_44, t21.is_verified AS is_verified_45, t21.user_filters AS user_filters_46, t21.profile_picture_name AS profile_picture_name_47, t21.detail AS detail_48, t21.adresse AS adresse_49, t21.complement_adresse AS complement_adresse_50, t21.ville AS ville_51, t21.code_postal AS code_postal_52, t21.created_at AS created_at_53, t21.updated_at AS updated_at_54, t21.reference AS reference_55, t21.reference_uuid AS reference_uuid_56, t21.archived AS archived_57, t21.account_id AS account_id_58, t21.created_by AS created_by_59, t21.updated_by AS updated_by_60, t0.address_id AS address_id_61, t0.created_by AS created_by_62, t0.updated_by AS updated_by_63 FROM account t0 LEFT JOIN "user" t21 ON t21.account_id = t0.id WHERE t0.id = ?
Parameters:
[
115
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (16.65%) |
1 |
SELECT e0_.id AS id_0, e0_.nom_edition AS nom_edition_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.reference_uuid AS reference_uuid_4 FROM edition e0_ WHERE e0_.archived = ? AND (e0_.date_fin IS NULL OR e0_.date_fin >= '2026-03-30') ORDER BY e0_.date_debut DESC LIMIT 1
Parameters:
[
0
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (11.61%) |
1 |
SELECT t0.id AS id_1, t0.entitled AS entitled_2, t0.code AS code_3, t0.edition_id AS edition_id_4 FROM custom_list_category t0 ORDER BY t0.entitled ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.53 ms (4.97%) |
1 |
SELECT e0_.id AS id_0, e0_.nom_edition AS nom_edition_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.reference_uuid AS reference_uuid_4 FROM edition e0_ WHERE e0_.archived = ? AND (e0_.date_fin IS NULL OR e0_.date_fin >= '2026-03-30') ORDER BY e0_.date_debut DESC
Parameters:
[
0
]
|
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\CustomListCategory | 4 |
| App\Entity\User | 3 |
| App\Entity\Account | 1 |
| App\Entity\Edition | 1 |
| App\Entity\CustomListItem | 1 |
| App\Entity\AccountAddress | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| App\Entity\Account | No errors. |
| App\Entity\Edition | No errors. |
| App\Entity\CustomListCategory | No errors. |
| App\Entity\CustomListItem | No errors. |
| App\Entity\AccountAddress | No errors. |
| App\Entity\Order | No errors. |