Symfony Profiler

[
  "route" => "confirmerRdv"
  "route_parameters" => [
    "_route" => "confirmerRdv"
    "_controller" => "App\Controller\RendezVousController::confirmerRdv"
  ]
  "request_uri" => "https://llvd-avocats.be/confirmerRdv?p=confirmerRdv"
  "method" => "POST"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\SecurityAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\SecurityAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "8h5xh.myd.infomaniak.com"
    "port" => null
    "user" => "8h5xh_llvd"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "8h5xh_llvd"
    "serverVersion" => "8"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.photos AS photos_4, t0.description AS description_5, t0.deleted AS deleted_6, t0.tel AS tel_7, t0.email AS email_8 FROM avocats t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.deleted AS deleted_3, t0.adresse AS adresse_4 FROM lieux t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statuts t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_ouverture AS heure_ouverture_3, t0.heure_fermeture AS heure_fermeture_4, t0.lieux_id AS lieux_id_5, t0.avocats_id AS avocats_id_6 FROM jours_fermetures t0 WHERE t0.avocats_id = ? AND t0.lieux_id = ? AND t0.date = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
    3 => "2025-11-18"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.horaires AS horaires_4, t0.envoi_conf AS envoi_conf_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.motif AS motif_10, t0.date_fin AS date_fin_11, t0.user_id AS user_id_12, t0.lieux_id AS lieux_id_13, t0.avocats_id AS avocats_id_14, t0.statuts_id AS statuts_id_15 FROM rendez_vous t0 WHERE t0.date = ? AND t0.avocats_id = ? LIMIT 1"
  "params" => [
    1 => "2025-11-18 15:30:00"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "INSERT INTO rendez_vous (date, created, horaires, envoi_conf, nom, prenom, telephone, email, motif, date_fin, user_id, lieux_id, avocats_id, statuts_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "2025-11-18 15:30:00"
    2 => "2025-11-10 16:11:59"
    3 => "15:30"
    4 => null
    5 => "BODSON"
    6 => "Béatrice"
    7 => "+32471 93 00 04"
    8 => "bodson6262@hotmail.com"
    9 => "Demande d'avis consultatif au sujet d'un chantier (remplacement d'un escalier extérieur à passage fréquent) demandé le 01/03, commencé le 04/07 (démolition de l'escalier défectueux) et poursuivi le 06/11 (enlèvement des terres et profilage). Le travail tarde, traîne et est interrompu pour des raisons qui ne me paraissent pas recevables. Le 10/07, j'ai donné en main propre à l'entrepreneur et à sa demande une avance de 7.000€ pour la pierre bleue (ce qui me semble élevé), le jour même. Pas de reçu. Aujourd'hui, je me retrouve avec un escalier en terre, boueux avec les pluies et donc impraticable. Dimanche 09/11, l'entrepreneur m'a proposé de me remettre la pierre bleue ce mercredi 12/11. Il ne souhaite pas poursuivre le chantier, ce que je ne souhaite pas non plus vu les nombreuses contrariétés qu'il m'a causées déjà précédemment. L'entrepreneur doit me prévenir de son passage la veille. Après réflexion, je lui ai adressé un mail lui demandant de m'envoyer par mail la veille différents documents: la facture détaillée de ses prestations, le reçu de l'avance de 7.000€ et le détail de sa commande de pierre bleue avec le document valant pour garantie. Je m'interroge sur la somme précitée et ne sais si je trouverai une société pour faire le nouvel escalier avec les matériaux que l'entrepreneur  m'a proposé de me remettre... Et si cela était possible, quand l'escalier serait-il fait? J'estime avoir subi des préjudices. NB: La pierre bleue commandée concerne aussi un seuil de garage non fait également. L'actuel est brisé en 4 parties et fait sauter le carrelage qui se trouve contre. Par ailleurs, la porterie du garage automatisée se relève parfois seule lorsqu'elle touche un morceau du seuil cassé et déstabilisé. "
    10 => "2025-11-18 16:30:00"
    11 => null
    12 => 1
    13 => 1
    14 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 1
    12 => 1
    13 => 1
    14 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.date AS date_1, t0_.ouvert AS ouvert_2, t0_.occupe AS occupe_3, t0_.jours_fermetures_id AS jours_fermetures_id_4 FROM tranches t0_ WHERE t0_.date >= ? AND t0_.date < ? AND t0_.jours_fermetures_id <= ?"
  "params" => [
    1 => "2025-11-18 15:00:00"
    2 => "2025-11-18 16:30:00"
    3 => 955
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "UPDATE tranches SET ouvert = ? WHERE id = ?"
  "params" => [
    1 => 0
    2 => 30447
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "sql" => "UPDATE tranches SET ouvert = ? WHERE id = ?"
  "params" => [
    1 => 0
    2 => 30448
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]