Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Business\Controller\App\DashboardController::index"
  ]
  "request_uri" => "https://myworkspace.sysval.fr/"
  "method" => "HEAD"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main_security"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "myassistant"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "myassistant_dev"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "valentin.meriel@ag2i.fr"
]

[
  "sql" => "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"
  "params" => [
    1 => "password_min_length"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "password_require_uppercase"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "password_require_lowercase"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "password_require_digit"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "password_require_special"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "password_history_count"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "password_expire_days"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "password_pwned_check"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-06-02 00:00:00"
    3 => "2026-06-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1170}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-06-03 00:00:00"
    3 => "2026-06-02 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1170}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-06-02 00:00:00"
    3 => "2026-06-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1170}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "2026-06-04 00:00:00"
    3 => "2026-06-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1170}
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "branding_app_name"
    2 => "branding_welcome_text"
    3 => "branding_company_name"
    4 => "branding_logo"
    5 => "branding_favicon"
    6 => "theme_primary_color"
    7 => "theme_secondary_color"
    8 => "theme_header_bg"
    9 => "theme_header_text"
    10 => "theme_icon_color"
    11 => "theme_login_bg"
    12 => "theme_home_bg"
    13 => "theme_bg_opacity"
    14 => "theme_font_url"
    15 => "theme_font_family"
    16 => "theme_border_radius"
    17 => "theme_dark_mode"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1170}
    3 => Doctrine\DBAL\ParameterType {#1170}
    4 => Doctrine\DBAL\ParameterType {#1170}
    5 => Doctrine\DBAL\ParameterType {#1170}
    6 => Doctrine\DBAL\ParameterType {#1170}
    7 => Doctrine\DBAL\ParameterType {#1170}
    8 => Doctrine\DBAL\ParameterType {#1170}
    9 => Doctrine\DBAL\ParameterType {#1170}
    10 => Doctrine\DBAL\ParameterType {#1170}
    11 => Doctrine\DBAL\ParameterType {#1170}
    12 => Doctrine\DBAL\ParameterType {#1170}
    13 => Doctrine\DBAL\ParameterType {#1170}
    14 => Doctrine\DBAL\ParameterType {#1170}
    15 => Doctrine\DBAL\ParameterType {#1170}
    16 => Doctrine\DBAL\ParameterType {#1170}
    17 => Doctrine\DBAL\ParameterType {#1170}
  ]
]

[
  "sql" => "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))"
]

[
  "sql" => "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))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1377
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main_security"
]