Symfony Profiler

[
  "route" => "accueil"
  "route_parameters" => [
    "_route" => "accueil"
    "_controller" => "App\Controller\AccueilController::index"
  ]
  "request_uri" => "https://www.yusiip.cm/public/"
  "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"
]

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

[
  "sql" => "SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.ala_une = 1 ORDER BY a0_.id DESC LIMIT 1"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.ala_une = 1 AND a0_.id <> ? ORDER BY a0_.created_at DESC LIMIT 4"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = ? AND a0_.id <> ? ORDER BY a0_.created_at DESC LIMIT 4"
  "params" => [
    1 => "Sport"
    2 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.titre = ? LIMIT 1"
  "params" => [
    1 => "CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = ? LIMIT 1"
  "params" => [
    1 => "Urbanisme"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    \n
            SELECT id FROM (\n
                SELECT a.id, a.created_at,\n
                       ROW_NUMBER() OVER (\n
                           PARTITION BY a.sous_thematique_id\n
                           ORDER BY a.created_at DESC\n
                       ) AS rn\n
                FROM actualite a\n
                INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id\n
                WHERE st.thematique_id = ?\n
            ) ranked\n
            WHERE rn <= ?\n
            ORDER BY created_at DESC\n
            LIMIT ?\n
        
    """
  "params" => [
    1 => 1
    2 => 2
    3 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150}
    3 => Doctrine\DBAL\ParameterType {#1150}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY a0_.created_at DESC"
  "params" => [
    1 => 17
    2 => 16
    3 => 15
    4 => 14
    5 => 9
    6 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150}
    3 => Doctrine\DBAL\ParameterType {#1150}
    4 => Doctrine\DBAL\ParameterType {#1150}
    5 => Doctrine\DBAL\ParameterType {#1150}
    6 => Doctrine\DBAL\ParameterType {#1150}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = ? LIMIT 1"
  "params" => [
    1 => "Aménagement du territoire"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    \n
            SELECT id FROM (\n
                SELECT a.id, a.created_at,\n
                       ROW_NUMBER() OVER (\n
                           PARTITION BY a.sous_thematique_id\n
                           ORDER BY a.created_at DESC\n
                       ) AS rn\n
                FROM actualite a\n
                INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id\n
                WHERE st.thematique_id = ?\n
            ) ranked\n
            WHERE rn <= ?\n
            ORDER BY created_at DESC\n
            LIMIT ?\n
        
    """
  "params" => [
    1 => 2
    2 => 2
    3 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150}
    3 => Doctrine\DBAL\ParameterType {#1150}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (?, ?, ?) ORDER BY a0_.created_at DESC"
  "params" => [
    1 => 20
    2 => 19
    3 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150}
    3 => Doctrine\DBAL\ParameterType {#1150}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = ? LIMIT 1"
  "params" => [
    1 => "Environnement"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    \n
            SELECT id FROM (\n
                SELECT a.id, a.created_at,\n
                       ROW_NUMBER() OVER (\n
                           PARTITION BY a.sous_thematique_id\n
                           ORDER BY a.created_at DESC\n
                       ) AS rn\n
                FROM actualite a\n
                INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id\n
                WHERE st.thematique_id = ?\n
            ) ranked\n
            WHERE rn <= ?\n
            ORDER BY created_at DESC\n
            LIMIT ?\n
        
    """
  "params" => [
    1 => 3
    2 => 2
    3 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150}
    3 => Doctrine\DBAL\ParameterType {#1150}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (?, ?, ?, ?) ORDER BY a0_.created_at DESC"
  "params" => [
    1 => 13
    2 => 12
    3 => 11
    4 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150}
    3 => Doctrine\DBAL\ParameterType {#1150}
    4 => Doctrine\DBAL\ParameterType {#1150}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "INTEGER"
    }
  ]
]