Symfony Profiler

[
  "route" => "app_events"
  "route_parameters" => [
    "_route" => "app_events"
    "_controller" => "App\Event\Controller\EventsController::index"
    "_locale" => "en"
  ]
  "request_uri" => "https://trouvemoi.eu/en/events?categorie=repas"
  "method" => "GET"
]

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

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "loisir"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "admin_plaisir"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SET TIME ZONE 'Europe/Paris'"
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= ? AND e0_.visibility = 'public' AND e1_.slug = ?"
  "params" => [
    1 => "2026-11-06 17:15:11"
    2 => "2026-11-06 00:00:00"
    3 => "repas"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1199
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1199}
    3 => Doctrine\DBAL\ParameterType {#1199}
  ]
]

[
  "sql" => "SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= ? AND e0_.visibility = 'public' AND e1_.slug = ? ORDER BY e0_.starts_at ASC LIMIT 10"
  "params" => [
    1 => "2026-11-06 17:15:11"
    2 => "2026-11-06 00:00:00"
    3 => "repas"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1199
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1199}
    3 => Doctrine\DBAL\ParameterType {#1199}
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= ? AND e0_.visibility = 'public'"
  "params" => [
    1 => "2026-11-06 17:15:11"
    2 => "2026-11-06 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1199
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1199}
  ]
]

[
  "sql" => "SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= ? AND e0_.visibility = 'public' ORDER BY e0_.starts_at ASC LIMIT 4"
  "params" => [
    1 => "2026-11-06 17:15:11"
    2 => "2026-11-06 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1199
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1199}
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= ? AND e0_.visibility = 'public'"
  "params" => [
    1 => "2026-11-06 17:15:11"
    2 => "2026-11-06 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1199
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1199}
  ]
]

[
  "sql" => "SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= ? AND e0_.visibility = 'public' ORDER BY e0_.starts_at ASC LIMIT 300"
  "params" => [
    1 => "2026-11-06 17:15:11"
    2 => "2026-11-06 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1199
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1199}
  ]
]

[
  "sql" => "SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.status AS status_7, t0.reset_code_hash AS reset_code_hash_8, t0.reset_code_expires_at AS reset_code_expires_at_9, t0.reset_code_attempts AS reset_code_attempts_10, t0.email_verification_code_hash AS email_verification_code_hash_11, t0.email_verification_expires_at AS email_verification_expires_at_12, t0.email_verification_attempts AS email_verification_attempts_13, t0.avatar_path AS avatar_path_14, t0.birth_date AS birth_date_15, t0.gender AS gender_16, t0.preferred_locale AS preferred_locale_17, t0.country AS country_18, t0.bio AS bio_19, t0.city AS city_20, t0.interests AS interests_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25 FROM "user" t0 WHERE t0.id = ?"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1199
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.position AS position_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM event_category t0 ORDER BY t0.position ASC"
]