HEAD https://myworkspace.sysval.fr/

Query Metrics

18 Database Queries
10 Different statements
7.04 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 ms
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
]
2 0.37 ms
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"
]
3 0.30 ms
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_require_uppercase"
]
4 0.29 ms
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_require_lowercase"
]
5 0.30 ms
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_require_digit"
]
6 0.32 ms
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_require_special"
]
7 0.33 ms
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_history_count"
]
8 0.30 ms
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_expire_days"
]
9 0.29 ms
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_pwned_check"
]
10 0.44 ms
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"
]
11 0.48 ms
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"
]
12 0.65 ms
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"
]
13 0.40 ms
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
]
14 0.39 ms
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
]
15 0.70 ms
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-04 00:00:00"
  "2026-06-03 00:00:00"
]
16 0.37 ms
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"
]
17 0.35 ms
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:
[]
18 0.30 ms
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