Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\Home\HomeController::index"
  ]
  "request_uri" => "https://rett-family.fr/"
  "method" => "GET"
]

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

[
  "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"
]

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "app_rett"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "re2t_db"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM child_profile c0_ WHERE c0_.visibility_level IN (?, ?)"
  "params" => [
    1 => "public"
    2 => "community"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#809
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#809}
  ]
]

[
  "sql" => "SELECT COUNT(f0_.id) AS sclr_0 FROM funding_project f0_ WHERE f0_.status = ?"
  "params" => [
    1 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#809
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.display_name AS display_name_2, c0_.birth_date AS birth_date_3, c0_.region AS region_4, c0_.bio AS bio_5, c0_.photo_filename AS photo_filename_6, c0_.hero_filename AS hero_filename_7, c0_.visibility_level AS visibility_level_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10 FROM child_profile c0_ WHERE c0_.visibility_level = ? ORDER BY c0_.created_at DESC LIMIT 3"
  "params" => [
    1 => "public"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#809
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.short_summary AS short_summary_2, f0_.description AS description_3, f0_.project_type AS project_type_4, f0_.goal_amount AS goal_amount_5, f0_.collected_amount AS collected_amount_6, f0_.status AS status_7, f0_.visibility_level AS visibility_level_8, f0_.cover_filename AS cover_filename_9, f0_.pinned AS pinned_10, f0_.closing_message AS closing_message_11, f0_.closing_image_filename AS closing_image_filename_12, f0_.provider AS provider_13, f0_.fundraising_mode AS fundraising_mode_14, f0_.embed_url AS embed_url_15, f0_.embed_height AS embed_height_16, f0_.external_url AS external_url_17, f0_.created_at AS created_at_18, f0_.updated_at AS updated_at_19, f0_.child_profile_id AS child_profile_id_20, f0_.created_by_id AS created_by_id_21 FROM funding_project f0_ WHERE f0_.status = ? AND f0_.visibility_level = ? ORDER BY f0_.created_at DESC LIMIT 3"
  "params" => [
    1 => "published"
    2 => "public"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#809
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#809}
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.excerpt AS excerpt_2, n0_.content AS content_3, n0_.category AS category_4, n0_.is_published AS is_published_5, n0_.published_at AS published_at_6, n0_.view_count AS view_count_7, n0_.created_at AS created_at_8, n0_.updated_at AS updated_at_9, n0_.author_id AS author_id_10, n0_.association_id AS association_id_11 FROM news_article n0_ WHERE n0_.is_published = 1 ORDER BY n0_.published_at DESC LIMIT 3"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.image_urls AS image_urls_3, a0_.video_embeds AS video_embeds_4, a0_.resource_links AS resource_links_5, a0_.location_name AS location_name_6, a0_.address_line1 AS address_line1_7, a0_.postal_code AS postal_code_8, a0_.city AS city_9, a0_.country AS country_10, a0_.map_embed_url AS map_embed_url_11, a0_.starts_at AS starts_at_12, a0_.ends_at AS ends_at_13, a0_.status AS status_14, a0_.view_count AS view_count_15, a0_.participant_count AS participant_count_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.association_id AS association_id_19, a0_.created_by_id AS created_by_id_20 FROM association_event a0_ INNER JOIN association a1_ ON a0_.association_id = a1_.id WHERE a0_.status = ? AND a1_.verified_status = ? AND a0_.starts_at IS NOT NULL AND a0_.starts_at >= ? ORDER BY a0_.starts_at ASC LIMIT 3"
  "params" => [
    1 => "published"
    2 => "officielle"
    3 => "2026-05-02 10:40:10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#809
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#809}
    3 => Doctrine\DBAL\ParameterType {#809}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#890
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#890
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#890
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.mission AS mission_5, t0.region AS region_6, t0.website AS website_7, t0.logo_filename AS logo_filename_8, t0.membership_available AS membership_available_9, t0.donation_available AS donation_available_10, t0.verified_status AS verified_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by_id AS created_by_id_14 FROM association t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#890
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.mission AS mission_5, t0.region AS region_6, t0.website AS website_7, t0.logo_filename AS logo_filename_8, t0.membership_available AS membership_available_9, t0.donation_available AS donation_available_10, t0.verified_status AS verified_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by_id AS created_by_id_14 FROM association t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#890
      +name: "INTEGER"
    }
  ]
]