Symfony Profiler

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

[
  "sql" => "SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1"
]

[
  "route" => "app_chant_catalogue"
  "route_parameters" => [
    "_route" => "app_chant_catalogue"
    "_controller" => "App\Controller\ChantController::catalogue"
  ]
  "request_uri" => "https://preprod.citizenj7-music.fr/chants/catalogue"
  "method" => "GET"
]

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.path AS path_4, t0.is_published AS is_published_5 FROM page t0 WHERE t0.path = ? LIMIT 1"
  "params" => [
    1 => "/chants/catalogue"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1004
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT count(DISTINCT c0_.id) AS sclr_0 FROM chant c0_ WHERE c0_.is_published = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1333
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT c0_.id AS id_0 FROM chant c0_ WHERE c0_.is_published = ? LIMIT 12"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1333
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.tonalite AS tonalite_4, c0_.tempo AS tempo_5, c0_.duree AS duree_6, c0_.mp3 AS mp3_7, c0_.image AS image_8, c0_.is_published AS is_published_9, c0_.is_featured AS is_featured_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.music_style AS music_style_13, c0_.video_id AS video_id_14, c0_.tablature_id AS tablature_id_15 FROM chant c0_ WHERE c0_.is_published = ? AND c0_.id IN (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => 1
    3 => 2
    4 => 3
    5 => 4
    6 => 5
    7 => 6
    8 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1333
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1006
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#1006}
    4 => Doctrine\DBAL\ParameterType {#1006}
    5 => Doctrine\DBAL\ParameterType {#1006}
    6 => Doctrine\DBAL\ParameterType {#1006}
    7 => Doctrine\DBAL\ParameterType {#1006}
    8 => Doctrine\DBAL\ParameterType {#1006}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.content AS content_3, t0.image AS image_4, t0.section AS section_5, t0.position AS position_6, t0.page_id AS page_id_7 FROM block t0 WHERE t0.page_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1006
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1"
]