Symfony Profiler

[
  "route" => "dashboard"
  "route_parameters" => [
    "_route" => "dashboard"
    "_controller" => "App\Controller\Statistiques\statistiquesController::dashboard"
  ]
  "request_uri" => "https://zouini-td1.proxisoft.ma/dashboard"
  "method" => "GET"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "zouinitdproxisof_test"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "zouinitdproxisof_test"
    "serverVersion" => "8"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.nume_marc AS nume_marc_1, m0_.date_creation AS date_creation_2, m0_.obje_marc AS obje_marc_3, m0_.total_ht AS total_ht_4, m0_.tva AS tva_5, m0_.total_ttc AS total_ttc_6, m0_.etat_marc AS etat_marc_7, m0_.id_client AS id_client_8, m0_.type_marc AS type_marc_9, m0_.desc_marc AS desc_marc_10, m0_.mode_paie AS mode_paie_11, m0_.date_debut AS date_debut_12, m0_.date_fin AS date_fin_13, m0_.id_devis AS id_devis_14, m0_.rg AS rg_15, m0_.montant_rg AS montant_rg_16 FROM marche m0_ INNER JOIN bureau_marche b1_ ON (b1_.id_marche = m0_.id) WHERE b1_.id_bureau = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT sum(f0_.total_ttc) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ? OR f0_.etat_fact = ? OR f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 3
    4 => "2025-09-01"
    5 => "2025-09-30"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT SUM(f0_.total_ttc) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)"
  "params" => [
    1 => 2
    2 => "2025-09-01"
    3 => "2025-09-30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT SUM(f0_.total_ttc - f0_.reste) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)"
  "params" => [
    1 => 3
    2 => "2025-09-01"
    3 => "2025-09-30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT SUM(f0_.total_ttc) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)"
  "params" => [
    1 => 1
    2 => "2025-09-01"
    3 => "2025-09-30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT SUM(f0_.reste) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)"
  "params" => [
    1 => 3
    2 => "2025-09-01"
    3 => "2025-09-30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.num_facture AS num_facture_1, f0_.id_four AS id_four_2, f0_.id_bon_com AS id_bon_com_3, f0_.total_ht AS total_ht_4, f0_.tva AS tva_5, f0_.total_ttc AS total_ttc_6, f0_.etat_fact AS etat_fact_7, f0_.desc_fact AS desc_fact_8, f0_.date_creation AS date_creation_9, f0_.imag_facr AS imag_facr_10, f0_.id_bure AS id_bure_11, f0_.id_char AS id_char_12, f0_.reste AS reste_13 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ? OR f0_.etat_fact = ? OR f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 3
    4 => "2025-09-01"
    5 => "2025-09-30"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 2
    5 => 2
  ]
]

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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