Query Metrics
18
Database Queries
10
Different statements
7.34 ms
Query time
0
Invalid entities
17
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.40 ms (32.71%) |
8 |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM setting t0 WHERE t0.setting_key = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"password_min_length"
]
|
||||||||||||||||||||||||||||||
|
0.88 ms (11.98%) |
2 |
SELECT r0_.id AS id_0, r0_.uuid AS uuid_1, r0_.title AS title_2, r0_.kind AS kind_3, r0_.start_at AS start_at_4, r0_.end_at AS end_at_5, r0_.all_day AS all_day_6, r0_.location AS location_7, r0_.body AS body_8, r0_.ews_item_id AS ews_item_id_9, r0_.ews_change_key AS ews_change_key_10, r0_.graph_event_id AS graph_event_id_11, r0_.sensitivity AS sensitivity_12, r0_.show_as AS show_as_13, r0_.organizer_email AS organizer_email_14, r0_.organizer_name AS organizer_name_15, r0_.attendees AS attendees_16, r0_.is_reminder_set AS is_reminder_set_17, r0_.reminder_minutes AS reminder_minutes_18, r0_.is_recurring AS is_recurring_19, r0_.categories AS categories_20, r0_.my_response AS my_response_21, r0_.is_cancelled AS is_cancelled_22, r0_.raw_data AS raw_data_23, r0_.created_at AS created_at_24, r0_.updated_at AS updated_at_25, r0_.deleted_at AS deleted_at_26, r0_.client_id AS client_id_27, r0_.site_id AS site_id_28, r0_.contact_id AS contact_id_29, r0_.projet_id AS projet_id_30, r0_.owner_id AS owner_id_31 FROM rdv_item r0_ WHERE (r0_.owner_id = ? AND (r0_.start_at < ? AND r0_.end_at > ?)) AND (r0_.deleted_at IS NULL) ORDER BY r0_.start_at ASC
Parameters:
[ 1 "2026-06-03 00:00:00" "2026-06-02 00:00:00" ]
|
||||||||||||||||||||||||||||||
|
0.70 ms (9.49%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed_at AS password_changed_at_5, t0.password_reset_required AS password_reset_required_6, t0.is_active AS is_active_7, t0.preferences AS preferences_8, t0.sso_id AS sso_id_9, t0.sso_provider AS sso_provider_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.personne_id AS personne_id_14 FROM `user` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.63 ms (8.64%) |
1 |
SELECT i0_.id AS id_0, i0_.uuid AS uuid_1, i0_.title AS title_2, i0_.date_at AS date_at_3, i0_.duration_minutes AS duration_minutes_4, i0_.date_realisee AS date_realisee_5, i0_.status AS status_6, i0_.location AS location_7, i0_.planifie AS planifie_8, i0_.realise AS realise_9, i0_.suite AS suite_10, i0_.created_at AS created_at_11, i0_.updated_at AS updated_at_12, i0_.deleted_at AS deleted_at_13, i0_.client_id AS client_id_14, i0_.site_id AS site_id_15, i0_.contact_id AS contact_id_16, i0_.projet_id AS projet_id_17, i0_.rdv_id AS rdv_id_18, i0_.suite_de_id AS suite_de_id_19, i0_.owner_id AS owner_id_20 FROM intervention i0_ WHERE (i0_.owner_id = ? AND i0_.date_at >= ? AND i0_.date_at < ?) AND (i0_.deleted_at IS NULL) ORDER BY i0_.date_at ASC
Parameters:
[ 1 "2026-06-02 00:00:00" "2026-06-03 00:00:00" ]
|
||||||||||||||||||||||||||||||
|
0.58 ms (7.86%) |
1 |
SELECT l0_.id AS id_0, l0_.uuid AS uuid_1, l0_.date_at AS date_at_2, l0_.mode AS mode_3, l0_.category AS category_4, l0_.amount_ttc AS amount_ttc_5, l0_.vat_rate AS vat_rate_6, l0_.vat_amount AS vat_amount_7, l0_.amount_ht AS amount_ht_8, l0_.vat_breakdown AS vat_breakdown_9, l0_.vendor AS vendor_10, l0_.description AS description_11, l0_.distance_km AS distance_km_12, l0_.trajet AS trajet_13, l0_.amount_ik AS amount_ik_14, l0_.photo_path AS photo_path_15, l0_.photo_mime AS photo_mime_16, l0_.photo_size AS photo_size_17, l0_.photo_sha256 AS photo_sha256_18, l0_.photo_received_at AS photo_received_at_19, l0_.photo_signature AS photo_signature_20, l0_.photo_signed_payload AS photo_signed_payload_21, l0_.photo_signing_key_version AS photo_signing_key_version_22, l0_.extraction_mode AS extraction_mode_23, l0_.extraction_status AS extraction_status_24, l0_.extraction_raw_text AS extraction_raw_text_25, l0_.extraction_raw_response AS extraction_raw_response_26, l0_.extraction_blocks AS extraction_blocks_27, l0_.extraction_source AS extraction_source_28, l0_.vlm_provider AS vlm_provider_29, l0_.vlm_raw_response AS vlm_raw_response_30, l0_.status AS status_31, l0_.coherence_issues AS coherence_issues_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.deleted_at AS deleted_at_35, l0_.vehicule_id AS vehicule_id_36, l0_.note_frais_id AS note_frais_id_37, l0_.intervention_id AS intervention_id_38, l0_.client_id AS client_id_39, l0_.rdv_id AS rdv_id_40, l0_.owner_id AS owner_id_41 FROM ligne_frais l0_ WHERE (l0_.owner_id = ? AND l0_.date_at >= ? AND l0_.date_at < ?) AND (l0_.deleted_at IS NULL) ORDER BY l0_.date_at ASC
Parameters:
[ 1 "2026-06-02 00:00:00" "2026-06-03 00:00:00" ]
|
||||||||||||||||||||||||||||||
|
0.52 ms (7.14%) |
1 |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM setting t0 WHERE t0.setting_key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ "branding_app_name" "branding_welcome_text" "branding_company_name" "branding_logo" "branding_favicon" "theme_primary_color" "theme_secondary_color" "theme_header_bg" "theme_header_text" "theme_icon_color" "theme_login_bg" "theme_home_bg" "theme_bg_opacity" "theme_font_url" "theme_font_family" "theme_border_radius" "theme_dark_mode" ] |
||||||||||||||||||||||||||||||
|
0.48 ms (6.54%) |
1 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.title AS title_2, t0_.description AS description_3, t0_.priority AS priority_4, t0_.due_at AS due_at_5, t0_.completed_at AS completed_at_6, t0_.recurrence AS recurrence_7, t0_.reminder_at AS reminder_at_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.deleted_at AS deleted_at_11, t0_.parent_id AS parent_id_12, t0_.client_id AS client_id_13, t0_.projet_id AS projet_id_14, t0_.tache_groupe_id AS tache_groupe_id_15, t0_.owner_id AS owner_id_16 FROM tache t0_ WHERE (t0_.owner_id = ?) AND (t0_.deleted_at IS NULL) ORDER BY t0_.due_at ASC, t0_.updated_at DESC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.47 ms (6.42%) |
1 |
SELECT n0_.id AS id_0, n0_.uuid AS uuid_1, n0_.title AS title_2, n0_.content AS content_3, n0_.tags AS tags_4, n0_.type AS type_5, n0_.pinned AS pinned_6, n0_.created_at AS created_at_7, n0_.updated_at AS updated_at_8, n0_.deleted_at AS deleted_at_9, n0_.client_id AS client_id_10, n0_.projet_id AS projet_id_11, n0_.tache_id AS tache_id_12, n0_.note_groupe_id AS note_groupe_id_13, n0_.owner_id AS owner_id_14 FROM note n0_ WHERE (n0_.owner_id = ?) AND (n0_.deleted_at IS NULL) ORDER BY n0_.pinned DESC, n0_.updated_at DESC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.41 ms (5.64%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM feature_flag t0 WHERE ((t0.deleted_at IS NULL))
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.26 ms (3.57%) |
1 |
SELECT t0.id AS id_1, t0.email_perso AS email_perso_2, t0.preferred_email AS preferred_email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.anonymized_at AS anonymized_at_9 FROM personne t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
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\Business\Entity\Note | 8 |
| App\Business\Entity\RdvItem | 3 |
| App\Business\Entity\LigneFrais | 2 |
| App\Core\Entity\User | 1 |
| App\Core\Entity\Personne | 1 |
| App\Business\Entity\NoteFrais | 1 |
| App\Business\Entity\Tache | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Core\Entity\User | No errors. |
| App\Core\Entity\Personne | No errors. |
| App\Core\Entity\Group | No errors. |
| App\Core\Entity\UserPermission | No errors. |
| App\Core\Entity\PermissionSchedule | No errors. |
| App\Core\Entity\NetworkRule | No errors. |
| App\Core\Entity\Setting | No errors. |
| App\Business\Entity\Intervention | No errors. |
| App\Business\Entity\Client | No errors. |
| App\Business\Entity\Site | No errors. |
| App\Business\Entity\Contact | No errors. |
| App\Business\Entity\Projet | No errors. |
| App\Business\Entity\RdvItem | No errors. |
| App\Business\Entity\LigneFrais | No errors. |
| App\Business\Entity\Vehicule | No errors. |
| App\Business\Entity\NoteFrais | No errors. |
| App\Business\Entity\Tache | No errors. |
| App\Business\Entity\TacheGroupe | No errors. |
| App\Business\Entity\Note | No errors. |
| App\Business\Entity\NoteGroupe | No errors. |
| App\Core\Entity\FeatureFlag | No errors. |