Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Log Messages

"api_mobile_parent_child_show"

[
  "route" => "api_mobile_parent_child_show"
  "route_parameters" => [
    "_route" => "api_mobile_parent_child_show"
    "_controller" => "App\Controller\Api\Mobile\MobileParentController::childShow"
    "id" => "4"
  ]
  "request_uri" => "https://assalam-orleans.fr/api/mobile/parent/children/4"
  "method" => "GET"
]

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

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

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "paef5393_asslam_orleans_admin"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "paef5393_assalam_orleans"
  "serverVersion" => "8.3.26"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "paef5393_asslam_orleans_admin"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "paef5393_assalam_orleans"
    "serverVersion" => "8.3.26"
    "charset" => "utf8mb4"
  ]
]

"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.piece_identite AS piece_identite_8, t0.is_adherent AS is_adherent_9, t0.identifiant AS identifiant_10, t0.is_prof AS is_prof_11, t0.is_active AS is_active_12, t0.email_auth_code AS email_auth_code_13, t0.email_auth_enabled AS email_auth_enabled_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t0.address_id AS address_id_17 FROM `user` t0 WHERE t0.email = ? LIMIT 1"

[
  1 => "abdelhak.hamdouni@cat-secteurprive.fr"
]

[
  1 => Doctrine\DBAL\ParameterType {#927
    +name: "STRING"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.piece_identite AS piece_identite_8, t0.is_adherent AS is_adherent_9, t0.identifiant AS identifiant_10, t0.is_prof AS is_prof_11, t0.is_active AS is_active_12, t0.email_auth_code AS email_auth_code_13, t0.email_auth_enabled AS email_auth_enabled_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t0.address_id AS address_id_17 FROM `user` t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "abdelhak.hamdouni@cat-secteurprive.fr"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "STRING"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#705
    -user: App\Entity\User {#923 …}
    -roleNames: [
      "ROLE_ADMIN"
      "ROLE_PARENT"
      "ROLE_MEMBRE"
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api_mobile"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODE1MzA0MzgsImV4cCI6MTc4NDEyMjQzOCwicm9sZXMiOlsiUk9MRV9BRE1JTiIsIlJPTEVfUEFSRU5UIiwiUk9MRV9NRU1CUkUiLCJST0xFX1VTRVIiXSwidXNlcm5hbWUiOiJhYmRlbGhhay5oYW1kb3VuaUBjYXQtc2VjdGV1cnByaXZlLmZyIn0.OioedD54iSDmNkvhDWqEoRscI-_LkjTSm2iizmqTIImvWIMVrBz6L7pFbgc53iE3e4rxRAQUuvV9PV56XBW3NIDszS8kCqnFySf4rsb-tarSUE4-kgMOYaqTuCxXwFGzIZWDuu9GG8qUQU0Q4_ur-T1V_B-Ef70qThwCFO4CNxpny4nRZK56ansglp0uAjDNXBkSa-V-ZBGSJ_0VtXCt3VZGR2TH8UCYWBrV4WGG83rQy5XTPr5mDd9Nwmr1jvjsMXHeKV5RookqlGeoYTv0JbkxgM5X1EeDTQ_znYSEmXp8rM6AsOT37nBXPcpVKg1yh6SXVl7AZvnsOlfv6Gm2ow"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

"INSERT INTO audit_log (user_email, action, entity_type, entity_id, description, data_before, data_after, ip_address, user_agent, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

[
  1 => "abdelhak.hamdouni@cat-secteurprive.fr"
  2 => "LOGIN_SUCCESS"
  3 => null
  4 => null
  5 => "Connexion réussie"
  6 => null
  7 => null
  8 => "93.2.212.82"
  9 => "okhttp/4.12.0"
  10 => "2026-06-15 13:34:24"
]

[
  1 => Doctrine\DBAL\ParameterType {#927
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#927}
  3 => Doctrine\DBAL\ParameterType {#927}
  4 => Doctrine\DBAL\ParameterType {#929
    +name: "INTEGER"
  }
  5 => Doctrine\DBAL\ParameterType {#927}
  6 => Doctrine\DBAL\ParameterType {#927}
  7 => Doctrine\DBAL\ParameterType {#927}
  8 => Doctrine\DBAL\ParameterType {#927}
  9 => Doctrine\DBAL\ParameterType {#927}
  10 => Doctrine\DBAL\ParameterType {#927}
]

[
  "sql" => "INSERT INTO audit_log (user_email, action, entity_type, entity_id, description, data_before, data_after, ip_address, user_agent, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "abdelhak.hamdouni@cat-secteurprive.fr"
    2 => "LOGIN_SUCCESS"
    3 => null
    4 => null
    5 => "Connexion réussie"
    6 => null
    7 => null
    8 => "93.2.212.82"
    9 => "okhttp/4.12.0"
    10 => "2026-06-15 13:34:24"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#927}
    3 => Doctrine\DBAL\ParameterType {#927}
    4 => Doctrine\DBAL\ParameterType {#929
      +name: "INTEGER"
    }
    5 => Doctrine\DBAL\ParameterType {#927}
    6 => Doctrine\DBAL\ParameterType {#927}
    7 => Doctrine\DBAL\ParameterType {#927}
    8 => Doctrine\DBAL\ParameterType {#927}
    9 => Doctrine\DBAL\ParameterType {#927}
    10 => Doctrine\DBAL\ParameterType {#927}
  ]
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

"SELECT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2, e0_.birthday AS birthday_3, e0_.birth_city AS birth_city_4, e0_.is_arabo_phone AS is_arabo_phone_5, e0_.is_dificult AS is_dificult_6, e0_.observation AS observation_7, e0_.created_at AS created_at_8, e0_.pere_id AS pere_id_9, e0_.mere_id AS mere_id_10, e0_.tuteur_id AS tuteur_id_11, e0_.created_by_id AS created_by_id_12 FROM eleve e0_ WHERE e0_.pere_id = ? OR e0_.mere_id = ? OR e0_.tuteur_id = ? ORDER BY e0_.last_name ASC"

[
  1 => 1
  2 => 1
  3 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#929
    +name: "INTEGER"
  }
  2 => Doctrine\DBAL\ParameterType {#929}
  3 => Doctrine\DBAL\ParameterType {#929}
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2, e0_.birthday AS birthday_3, e0_.birth_city AS birth_city_4, e0_.is_arabo_phone AS is_arabo_phone_5, e0_.is_dificult AS is_dificult_6, e0_.observation AS observation_7, e0_.created_at AS created_at_8, e0_.pere_id AS pere_id_9, e0_.mere_id AS mere_id_10, e0_.tuteur_id AS tuteur_id_11, e0_.created_by_id AS created_by_id_12 FROM eleve e0_ WHERE e0_.pere_id = ? OR e0_.mere_id = ? OR e0_.tuteur_id = ? ORDER BY e0_.last_name ASC"
  "params" => [
    1 => 1
    2 => 1
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#929
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#929}
    3 => Doctrine\DBAL\ParameterType {#929}
  ]
]

"SELECT t0.id AS id_1, t0.annee AS annee_2, t0.type AS type_3, t0.identifiant AS identifiant_4, t0.cursus AS cursus_5, t0.avec_science AS avec_science_6, t0.fiche_sanitaire AS fiche_sanitaire_7, t0.fiche_sanitaire_at AS fiche_sanitaire_at_8, t0.montant_total AS montant_total_9, t0.montant_inscription AS montant_inscription_10, t0.paiement_exempte AS paiement_exempte_11, t0.motif_exemption_paiement AS motif_exemption_paiement_12, t0.eleve_id AS eleve_id_13, t0.author_id AS author_id_14, t0.tarif_id AS tarif_id_15 FROM inscription t0 WHERE t0.eleve_id = ?"

[
  1 => 4
]

[
  1 => Doctrine\DBAL\ParameterType {#929
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.type AS type_3, t0.identifiant AS identifiant_4, t0.cursus AS cursus_5, t0.avec_science AS avec_science_6, t0.fiche_sanitaire AS fiche_sanitaire_7, t0.fiche_sanitaire_at AS fiche_sanitaire_at_8, t0.montant_total AS montant_total_9, t0.montant_inscription AS montant_inscription_10, t0.paiement_exempte AS paiement_exempte_11, t0.motif_exemption_paiement AS motif_exemption_paiement_12, t0.eleve_id AS eleve_id_13, t0.author_id AS author_id_14, t0.tarif_id AS tarif_id_15 FROM inscription t0 WHERE t0.eleve_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#929
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.montant AS montant_2, t0.mode AS mode_3, t0.statut AS statut_4, t0.date_paiement AS date_paiement_5, t0.reference AS reference_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.inscription_id AS inscription_id_9, t0.created_by_id AS created_by_id_10 FROM paiement t0 WHERE t0.inscription_id = ?"

[
  1 => 4
]

[
  1 => Doctrine\DBAL\ParameterType {#929
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.montant AS montant_2, t0.mode AS mode_3, t0.statut AS statut_4, t0.date_paiement AS date_paiement_5, t0.reference AS reference_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.inscription_id AS inscription_id_9, t0.created_by_id AS created_by_id_10 FROM paiement t0 WHERE t0.inscription_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#929
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.jour AS jour_3, t0.horaire AS horaire_4, t0.description AS description_5 FROM classe t0 INNER JOIN classe_eleve ON t0.id = classe_eleve.classe_id WHERE classe_eleve.eleve_id = ?"

[
  1 => 4
]

[
  1 => Doctrine\DBAL\ParameterType {#929
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.jour AS jour_3, t0.horaire AS horaire_4, t0.description AS description_5 FROM classe t0 INNER JOIN classe_eleve ON t0.id = classe_eleve.classe_id WHERE classe_eleve.eleve_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#929
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.absence_at AS absence_at_2, t0.is_resolved AS is_resolved_3, t0.eleve_id AS eleve_id_4, t0.resolved_by_id AS resolved_by_id_5, t0.prof_id AS prof_id_6 FROM absence t0 WHERE t0.eleve_id = ?"

[
  1 => 4
]

[
  1 => Doctrine\DBAL\ParameterType {#929
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.absence_at AS absence_at_2, t0.is_resolved AS is_resolved_3, t0.eleve_id AS eleve_id_4, t0.resolved_by_id AS resolved_by_id_5, t0.prof_id AS prof_id_6 FROM absence t0 WHERE t0.eleve_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#929
      +name: "INTEGER"
    }
  ]
]