Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::scraping"
  ]
  "request_uri" => "https://coza.smart-it-partner.com/admin/home?%253D%2526client%25253D%252526dateRangePicker%25253D%252526type%25253DFacture%252526unpaid_only%25253D1%253D%3D%26amp%3D="
  "method" => "GET"
]

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

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

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

[
  "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.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"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "cozasmartitpartn_db"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "cozasmartitpartn_db"
    "serverVersion" => "MariaDB-10.4.18"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.vendeur AS vendeur_1, d0_.adresse AS adresse_2, d0_.telphvendeur1 AS telphvendeur1_3, d0_.telphvendeur2 AS telphvendeur2_4, d0_.rc AS rc_5, d0_.mf AS mf_6, d0_.nomclient AS nomclient_7, d0_.adresseclient AS adresseclient_8, d0_.telphclient AS telphclient_9, d0_.faxclient AS faxclient_10, d0_.mfclient AS mfclient_11, d0_.num AS num_12, d0_.date AS date_13, d0_.reference AS reference_14, d0_.code AS code_15, d0_.base AS base_16, d0_.taux AS taux_17, d0_.montant AS montant_18, d0_.total AS total_19, d0_.totalht AS totalht_20, d0_.qttotal AS qttotal_21, d0_.totalttc AS totalttc_22, d0_.montant_net AS montant_net_23, d0_.statut AS statut_24, d0_.timbre AS timbre_25, d0_.idfacture AS idfacture_26, d0_.oldtype AS oldtype_27, d0_.retour AS retour_28, d0_.frtour AS frtour_29, d0_.fav AS fav_30, d0_.lu AS lu_31, d0_.datecreation AS datecreation_32, d0_.demandedevisold AS demandedevisold_33, d0_.iddevisold AS iddevisold_34, d0_.iduerold AS iduerold_35, d0_.idintervold AS idintervold_36, d0_.username AS username_37, d0_.adressp AS adressp_38, d0_.telpp AS telpp_39, d0_.idsfacts AS idsfacts_40, c1_.id AS id_41, c1_.email AS email_42, c1_.nom AS nom_43, c1_.prenom AS prenom_44, c1_.raisonsocial AS raisonsocial_45, c1_.adresse AS adresse_46, c1_.tel AS tel_47, c1_.photo AS photo_48, c1_.faxclient AS faxclient_49, c1_.mfclient AS mfclient_50, c1_.exoneres AS exoneres_51, p2_.id AS id_52, p2_.montant AS montant_53, p2_.acompte AS acompte_54, p2_.reste AS reste_55, p2_.description AS description_56, p2_.piecejointe AS piecejointe_57, p2_.date AS date_58, p2_.modedepaiement AS modedepaiement_59, p2_.num AS num_60, p2_.remise AS remise_61, d0_.vendeurs_id AS vendeurs_id_62, d0_.client_id AS client_id_63, d0_.user_id AS user_id_64, d0_.fournisseur_id AS fournisseur_id_65, c1_.region_id AS region_id_66, p2_.devis_id AS devis_id_67 FROM devis d0_ LEFT JOIN client c1_ ON d0_.client_id = c1_.id LEFT JOIN paymentdevi p2_ ON d0_.id = p2_.devis_id WHERE d0_.statut IN (?, ?, ?) ORDER BY d0_.date DESC, d0_.datecreation DESC, d0_.id DESC"
  "params" => [
    1 => "Facture"
    2 => "BL"
    3 => "BLP"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.nomprenom AS nomprenom_1, b0_.adresse AS adresse_2, b0_.telephone AS telephone_3, b0_.datecreation AS datecreation_4, b0_.numbs AS numbs_5, b0_.date AS date_6, b0_.totaleqte AS totaleqte_7, b0_.totaleht AS totaleht_8, b0_.totaltva AS totaltva_9, b0_.totalttc AS totalttc_10, c1_.id AS id_11, c1_.email AS email_12, c1_.nom AS nom_13, c1_.prenom AS prenom_14, c1_.raisonsocial AS raisonsocial_15, c1_.adresse AS adresse_16, c1_.tel AS tel_17, c1_.photo AS photo_18, c1_.faxclient AS faxclient_19, c1_.mfclient AS mfclient_20, c1_.exoneres AS exoneres_21, b0_.vendeur_id AS vendeur_id_22, b0_.client_id AS client_id_23, c1_.region_id AS region_id_24 FROM bondesortie b0_ LEFT JOIN client c1_ ON b0_.client_id = c1_.id ORDER BY b0_.date DESC, b0_.datecreation DESC, b0_.id DESC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.raisonsocial AS raisonsocial_5, t0.adresse AS adresse_6, t0.tel AS tel_7, t0.photo AS photo_8, t0.faxclient AS faxclient_9, t0.mfclient AS mfclient_10, t0.exoneres AS exoneres_11, t0.region_id AS region_id_12 FROM client t0 ORDER BY t0.raisonsocial ASC, t0.nom ASC, t0.prenom ASC"
]

[
  "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" => "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.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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]