Symfony Profiler

[
  "route" => "app_groupe_index"
  "route_parameters" => [
    "_route" => "app_groupe_index"
    "_controller" => "App\Controller\GroupeController::index"
  ]
  "request_uri" => "https://admin.dieng-consulting.com/groupe"
  "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"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u338375617_root____"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u338375617_gestion_ecole"
    "serverVersion" => "10.4.28-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.enabled AS enabled_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM `user` t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "brabeatz197@gmail.com"
]

[
  "sql" => "SELECT count(DISTINCT g0_.id) AS sclr_0 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL"
]

[
  "sql" => "SELECT DISTINCT g0_.id AS id_0, g0_.created_at AS created_at_1 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL ORDER BY g0_.created_at DESC LIMIT 20"
]

[
  "sql" => "SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.code AS code_3, g0_.effectif_max AS effectif_max_4, g0_.active AS active_5, g0_.salle AS salle_6, g0_.created_at AS created_at_7, g0_.updated_at AS updated_at_8, g0_.deleted_at AS deleted_at_9, g0_.referent_id AS referent_id_10, g0_.classe_id AS classe_id_11 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY g0_.created_at DESC"
  "params" => [
    1 => 9
    2 => 8
    3 => 7
    4 => 6
    5 => 5
    6 => 4
    7 => 3
    8 => 2
    9 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#733}
    3 => Doctrine\DBAL\ParameterType {#733}
    4 => Doctrine\DBAL\ParameterType {#733}
    5 => Doctrine\DBAL\ParameterType {#733}
    6 => Doctrine\DBAL\ParameterType {#733}
    7 => Doctrine\DBAL\ParameterType {#733}
    8 => Doctrine\DBAL\ParameterType {#733}
    9 => Doctrine\DBAL\ParameterType {#733}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]