Symfony Profiler

[
  "route" => "app_logescom_vente_facturation_vente"
  "route_parameters" => [
    "_route" => "app_logescom_vente_facturation_vente"
    "_controller" => "App\Controller\Logescom\Vente\FacturationController::index"
    "lieu_vente" => "1"
  ]
  "request_uri" => "https://etselboubacarbalde.damkocompany.com/public/logescom/vente/facturation/vente/1"
  "method" => "GET"
]

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

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

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.type_user AS type_user_9, t0.date_creation AS date_creation_10, t0.adresse AS adresse_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.statut AS statut_14, t0.reference AS reference_15, t0.lieu_vente_id AS lieu_vente_id_16, t0.region_id AS region_id_17 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "MtBalde"
]

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerXQp3ZVO\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.product_id = NULL"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fonction AS fonction_2, t0.document_identite AS document_identite_3, t0.type_paie AS type_paie_4, t0.taux_horaire AS taux_horaire_5, t0.salaire_base AS salaire_base_6, t0.photo_identite AS photo_identite_7, t0.signature AS signature_8, t0.user_id AS user_id_9 FROM personnel t0 WHERE t0.user_id = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_stock AS nom_stock_2, t0.adresse AS adresse_3, t0.surface AS surface_4, t0.nbre_pieces AS nbre_pieces_5, t0.type AS type_6, t0.statut AS statut_7, t0.lieu_vente_id AS lieu_vente_id_8, t0.responsable_id AS responsable_id_9 FROM liste_stock t0 INNER JOIN personnel_liste_stock ON t0.id = personnel_liste_stock.liste_stock_id WHERE personnel_liste_stock.personnel_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.taux AS taux_2, t0.devise_id AS devise_id_3, t0.lieu_vente_id AS lieu_vente_id_4 FROM taux_devise t0 WHERE t0.lieu_vente_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2 FROM mode_paiement t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2 FROM frais_sup t0"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.numero_compte AS numero_compte_3, c0_.document AS document_4, c0_.point_de_vente_id AS point_de_vente_id_5 FROM caisse c0_ LEFT JOIN point_de_vente p1_ ON (c0_.point_de_vente_id = p1_.id OR c0_.point_de_vente_id IS NULL) WHERE c0_.type = ? AND p1_.lieu_vente_id = ? ORDER BY c0_.id ASC"
  "params" => [
    1 => "banque"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.numero_compte AS numero_compte_3, c0_.document AS document_4, c0_.point_de_vente_id AS point_de_vente_id_5 FROM caisse c0_ LEFT JOIN point_de_vente p1_ ON (c0_.point_de_vente_id = p1_.id OR c0_.point_de_vente_id IS NULL) WHERE p1_.lieu_vente_id = ? ORDER BY c0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.color AS color_2, t0.background_color AS background_color_3, t0.livraison AS livraison_4, t0.caisse AS caisse_5, t0.format_facture AS format_facture_6, t0.long_logo AS long_logo_7, t0.larg_logo AS larg_logo_8, t0.nom_entreprise AS nom_entreprise_9, t0.compte_client_fournisseur AS compte_client_fournisseur_10, t0.affichage_vente_compte AS affichage_vente_compte_11, t0.chemin_sauvegarde AS chemin_sauvegarde_12, t0.chemin_mysql AS chemin_mysql_13, t0.vente_stock AS vente_stock_14 FROM configuration_logiciel t0 LIMIT 1"
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::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.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\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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