Symfony Profiler

[
  "route" => "app_commande_new"
  "route_parameters" => [
    "_route" => "app_commande_new"
    "_controller" => "App\Controller\CommandeController::new"
  ]
  "request_uri" => "https://wine.mbebordeaux.fr/commande/new"
  "method" => "POST"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mysql.bleu2024.on-web.fr"
    "port" => null
    "user" => "mbe_www"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "mbe_www"
    "serverVersion" => "mariadb-10.4.11"
    "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.is_first_connexion AS is_first_connexion_5, t0.compte_id AS compte_id_6, t0.client_id AS client_id_7 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 190
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "chateauboutinet@orange.fr"
]

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

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

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

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::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\RouterListener::onKernelRequest"
]

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

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

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

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

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

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

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

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

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

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

[
  "sql" => "SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.client_id AS client_id_42, c0_.client_final_id AS client_final_id_43 FROM commande c0_ WHERE c0_.client_id = ? AND c0_.is_temporaire = ?"
  "params" => [
    1 => 373
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "INSERT INTO client_final (email, telephone, prenom, nom, full_name) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "cynthia.pope91@yahoo.com"
    2 => "9402065229"
    3 => null
    4 => null
    5 => "POPE CYNTHIA"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "INSERT INTO commande (nombre_colis_total, numero_dae, assurance_livraison, emballage_livraison, fichier_facture, numero_facture, montant_total_facture, date_debut_fenetre, date_fin_fenetre, date_commande_soumission, code_postal_livraison, ville_livraison, adresse_livraison, complement_adresse_livraison, etat_us, state, observation, province, nombre_bouteille_rouge, nombre_bouteille_blanc, nombre_bouteille_petillant, token, fedex_pdf_generated, is_temporaire, is_validee_par_client, commande_massive, date_collecte, nombre_magnum_rouge, nombre_magnum_blanc, nombre_magnum_petillant, tracking_number, fedex_pdf_available, ship_date, prior_url, type_emballage, individual_tracking_numbers, fast_pickup, fichier_facture_pro_forma, pro_forma, dap, service_priority, client_id, client_final_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => ""
    3 => 0
    4 => 1
    5 => "facture_190_68555ceb41f4b.pdf"
    6 => "FA2294"
    7 => 82.0
    8 => null
    9 => null
    10 => "2025-06-20"
    11 => "76259"
    12 => "PONDER"
    13 => "144 January Lane"
    14 => ""
    15 => "TX"
    16 => "emballage_caviste"
    17 => ""
    18 => "Texas"
    19 => 4
    20 => 2
    21 => 0
    22 => "gsrefgrdsgfres"
    23 => 0
    24 => 1
    25 => 0
    26 => 0
    27 => "2025-06-27"
    28 => 0
    29 => 0
    30 => 0
    31 => null
    32 => 0
    33 => null
    34 => null
    35 => null
    36 => null
    37 => 0
    38 => null
    39 => null
    40 => null
    41 => null
    42 => 373
    43 => 10281
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 5
    4 => 5
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 1
    20 => 1
    21 => 1
    22 => 2
    23 => 5
    24 => 5
    25 => 5
    26 => 5
    27 => 2
    28 => 1
    29 => 1
    30 => 1
    31 => 2
    32 => 5
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 5
    38 => 2
    39 => 2
    40 => 5
    41 => 5
    42 => 1
    43 => 1
  ]
]

[
  "sql" => "INSERT INTO client_final (email, telephone, prenom, nom, full_name) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "cynthia.pope91@yahoo.com"
    2 => "9402065229"
    3 => null
    4 => null
    5 => "POPE CYNTHIA"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "INSERT INTO colis (nombre_bouteille, commande_id) VALUES (?, ?)"
  "params" => [
    1 => 6
    2 => 7771
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "key" => "_security_main"
]

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

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

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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"
]