Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\DashboardController::index"
  ]
  "request_uri" => "https://admin.dieng-consulting.com/dashboard"
  "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 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

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

[
  "key" => "dashboard_indicators"
]

[
  "sql" => "SELECT COUNT(*) FROM eleve t0 WHERE t0.deleted_at IS NULL"
]

[
  "sql" => "SELECT COUNT(*) FROM inscription t0 WHERE t0.statut = ? AND t0.deleted_at IS NULL"
  "params" => [
    1 => "ACTIVE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM groupe t0 WHERE t0.active = ? AND t0.deleted_at IS NULL"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT c0_.nom AS nom_0, COUNT(i1_.id) AS sclr_1 FROM inscription i1_ LEFT JOIN concours c0_ ON i1_.concours_id = c0_.id WHERE i1_.deleted_at IS NULL AND i1_.statut = ? GROUP BY c0_.id ORDER BY sclr_1 DESC"
  "params" => [
    1 => "ACTIVE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT g0_.nom AS nom_0, COUNT(i1_.id) AS sclr_1 FROM groupe g0_ LEFT JOIN inscription i1_ ON g0_.id = i1_.groupe_id AND (i1_.statut = 'ACTIVE' AND i1_.deleted_at IS NULL) WHERE g0_.active = 1 AND g0_.deleted_at IS NULL GROUP BY g0_.id ORDER BY sclr_1 DESC"
]

[
  "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 inscription i1_ ON g0_.id = i1_.groupe_id AND (i1_.statut = 'ACTIVE' AND i1_.deleted_at IS NULL) WHERE g0_.active = 1 AND g0_.deleted_at IS NULL AND g0_.effectif_max IS NOT NULL AND g0_.effectif_max > 0 GROUP BY g0_.id HAVING COUNT(i1_.id) > g0_.effectif_max"
]

[
  "sql" => "SELECT e0_.groupe_id AS sclr_0 FROM emploi_du_temps e0_ WHERE e0_.deleted_at IS NULL GROUP BY e0_.groupe_id"
]

[
  "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_ WHERE g0_.active = 1 AND g0_.deleted_at IS NULL ORDER BY g0_.nom ASC"
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.statut AS statut_1, l0_.observation AS observation_2, l0_.ancienne_valeur AS ancienne_valeur_3, l0_.date_correction AS date_correction_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.session_pointage_id AS session_pointage_id_7, l0_.eleve_id AS eleve_id_8, l0_.agent_correcteur_id AS agent_correcteur_id_9 FROM ligne_presence l0_ LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id LEFT JOIN eleve e2_ ON l0_.eleve_id = e2_.id WHERE l0_.statut IN (?, ?) AND s1_.date_pointage >= ? AND s1_.date_pointage <= ? AND s1_.deleted_at IS NULL AND e2_.deleted_at IS NULL ORDER BY s1_.date_pointage ASC"
  "params" => [
    1 => "absent"
    2 => "excuse"
    3 => "2026-04-16"
    4 => "2026-05-16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1095}
    3 => Doctrine\DBAL\ParameterType {#1095}
    4 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date_pointage AS date_pointage_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.groupe_id AS groupe_id_6, t0.concours_id AS concours_id_7, t0.agent_saisie_id AS agent_saisie_id_8 FROM session_pointage t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date_pointage AS date_pointage_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.groupe_id AS groupe_id_6, t0.concours_id AS concours_id_7, t0.agent_saisie_id AS agent_saisie_id_8 FROM session_pointage t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM ligne_presence l0_ LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id WHERE l0_.eleve_id = ? AND s1_.date_pointage >= ? AND s1_.date_pointage <= ? AND s1_.deleted_at IS NULL"
  "params" => [
    1 => 59
    2 => "2026-04-16"
    3 => "2026-05-16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM ligne_presence l0_ LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id WHERE l0_.eleve_id = ? AND s1_.date_pointage >= ? AND s1_.date_pointage <= ? AND s1_.deleted_at IS NULL"
  "params" => [
    1 => 64
    2 => "2026-04-16"
    3 => "2026-05-16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM ligne_presence l0_ LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id WHERE l0_.eleve_id = ? AND s1_.date_pointage >= ? AND s1_.date_pointage <= ? AND s1_.deleted_at IS NULL"
  "params" => [
    1 => 1
    2 => "2026-04-16"
    3 => "2026-05-16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM ligne_presence l0_ LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id WHERE l0_.eleve_id = ? AND s1_.date_pointage >= ? AND s1_.date_pointage <= ? AND s1_.deleted_at IS NULL"
  "params" => [
    1 => 5
    2 => "2026-04-16"
    3 => "2026-05-16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT g0_.id AS id_0, g0_.nom AS nom_1, COUNT(DISTINCT s1_.id) AS sclr_2, SUM(CASE WHEN l2_.statut = 'present' THEN 1 ELSE 0 END) AS sclr_3, COUNT(l2_.id) AS sclr_4 FROM session_pointage s1_ LEFT JOIN groupe g0_ ON s1_.groupe_id = g0_.id LEFT JOIN ligne_presence l2_ ON s1_.id = l2_.session_pointage_id WHERE s1_.deleted_at IS NULL AND s1_.date_pointage >= ? GROUP BY g0_.id ORDER BY g0_.nom ASC"
  "params" => [
    1 => "2026-04-26"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT g0_.id AS id_0, g0_.nom AS nom_1, COUNT(DISTINCT s1_.id) AS sclr_2, SUM(CASE WHEN l2_.statut = 'present' THEN 1 ELSE 0 END) AS sclr_3, COUNT(l2_.id) AS sclr_4 FROM session_pointage s1_ LEFT JOIN groupe g0_ ON s1_.groupe_id = g0_.id LEFT JOIN ligne_presence l2_ ON s1_.id = l2_.session_pointage_id WHERE s1_.deleted_at IS NULL AND s1_.date_pointage >= ? GROUP BY g0_.id ORDER BY g0_.nom ASC"
  "params" => [
    1 => "2026-04-26"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT g0_.id AS id_0, g0_.nom AS nom_1, COUNT(DISTINCT s1_.id) AS sclr_2, SUM(CASE WHEN l2_.statut = 'present' THEN 1 ELSE 0 END) AS sclr_3, COUNT(l2_.id) AS sclr_4 FROM session_pointage s1_ LEFT JOIN groupe g0_ ON s1_.groupe_id = g0_.id LEFT JOIN ligne_presence l2_ ON s1_.id = l2_.session_pointage_id WHERE s1_.deleted_at IS NULL AND s1_.date_pointage >= ? GROUP BY g0_.id ORDER BY g0_.nom ASC"
  "params" => [
    1 => "2026-04-26"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.statut = ? AND ((e0_.annee < ?) OR (e0_.annee = ? AND e0_.mois < ?))"
  "params" => [
    1 => "non_paye"
    2 => 2026
    3 => 2026
    4 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#733}
    4 => Doctrine\DBAL\ParameterType {#733}
  ]
]

[
  "sql" => "SELECT SUM(e0_.montant_paye) AS sclr_0 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.annee = ? AND e0_.mois = ? AND e0_.statut IN (?, ?)"
  "params" => [
    1 => 2026
    2 => 5
    3 => "paye"
    4 => "partiellement_paye"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#733}
    3 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    4 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT SUM(p0_.montant_paye) AS sclr_0 FROM paiement p0_ WHERE p0_.deleted_at IS NULL AND (p0_.date_paiement BETWEEN ? AND ?) AND p0_.statut IN (?, ?)"
  "params" => [
    1 => "2026-05-01 00:00:00"
    2 => "2026-05-31 23:59:59"
    3 => "paye"
    4 => "partiellement_paye"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1095}
    3 => Doctrine\DBAL\ParameterType {#1095}
    4 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT e0_.annee AS annee_0, e0_.mois AS mois_1, SUM(e0_.montant_du) AS sclr_2, SUM(CASE WHEN e0_.montant_paye IS NOT NULL THEN e0_.montant_paye ELSE 0 END) AS sclr_3, COUNT(e0_.id) AS sclr_4, SUM(CASE WHEN e0_.statut = ? THEN 1 ELSE 0 END) AS sclr_5, SUM(CASE WHEN e0_.statut = ? THEN 1 ELSE 0 END) AS sclr_6, SUM(CASE WHEN e0_.statut = ? THEN 1 ELSE 0 END) AS sclr_7 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.annee = ? AND e0_.mois = ? GROUP BY e0_.annee, e0_.mois ORDER BY e0_.mois ASC"
  "params" => [
    1 => "non_paye"
    2 => "paye"
    3 => "exonere"
    4 => 2026
    5 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1095}
    3 => Doctrine\DBAL\ParameterType {#1095}
    4 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    5 => Doctrine\DBAL\ParameterType {#733}
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.statut = ? AND ((e0_.annee < ?) OR (e0_.annee = ? AND e0_.mois < ?))"
  "params" => [
    1 => "non_paye"
    2 => 2026
    3 => 2026
    4 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#733}
    4 => Doctrine\DBAL\ParameterType {#733}
  ]
]

[
  "sql" => "SELECT COUNT(i0_.id) AS sclr_0 FROM inscription i0_ WHERE i0_.deleted_at IS NULL AND i0_.exonere = 1"
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.statut = ?"
  "params" => [
    1 => "exonere"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT SUM(c0_.montant_du) AS sclr_0 FROM charge_professorale c0_ WHERE c0_.mois = ? AND c0_.annee = ? AND c0_.deleted_at IS NULL"
  "params" => [
    1 => 5
    2 => 2026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#733}
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM charge_professorale c0_ WHERE c0_.mois = ? AND c0_.annee = ? AND c0_.statut <> ? AND c0_.deleted_at IS NULL"
  "params" => [
    1 => 5
    2 => 2026
    3 => "paye"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#733}
    3 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.nom ASC"
]

[
  "sql" => "SELECT COUNT(*) FROM observation_suivi t0 WHERE t0.statut = ? AND t0.deleted_at IS NULL"
  "params" => [
    1 => "ouvert"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM observation_suivi t0 WHERE t0.statut = ? AND t0.deleted_at IS NULL"
  "params" => [
    1 => "en_cours"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL AND s0_.date_pointage >= ? AND s0_.date_pointage <= ? GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.nom ASC"
  "params" => [
    1 => "2026-05-01"
    2 => "2026-05-31"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1095
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1095}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.statut AS statut_2, t0.observation AS observation_3, t0.ancienne_valeur AS ancienne_valeur_4, t0.date_correction AS date_correction_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.session_pointage_id AS session_pointage_id_8, t0.eleve_id AS eleve_id_9, t0.agent_correcteur_id AS agent_correcteur_id_10 FROM ligne_presence t0 WHERE t0.session_pointage_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.statut AS statut_2, t0.observation AS observation_3, t0.ancienne_valeur AS ancienne_valeur_4, t0.date_correction AS date_correction_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.session_pointage_id AS session_pointage_id_8, t0.eleve_id AS eleve_id_9, t0.agent_correcteur_id AS agent_correcteur_id_10 FROM ligne_presence t0 WHERE t0.session_pointage_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]