Symfony Profiler

[
  "route" => "tous_pdf_prod"
  "route_parameters" => [
    "_route" => "tous_pdf_prod"
    "_controller" => "App\Controller\PdfOutputController::tousPdfProd"
  ]
  "request_uri" => "https://www.groupe-btelecom.fr/tousPdfProd"
  "method" => "POST"
]

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

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "groupuvbtelecom.mysql.db"
    "port" => null
    "user" => "groupuvbtelecom"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "groupuvbtelecom"
    "serverVersion" => "mariadb-10.3.34"
    "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.username AS username_5, t0.mode AS mode_6 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "noury.johny@groupe-btelecom.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.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 t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.voie AS voie_3, t0.adresse AS adresse_4, t0.siret AS siret_5, t0.prenom AS prenom_6, t0.nom AS nom_7, t0.email AS email_8, t0.entreprise_fact AS entreprise_fact_9, t0.tva AS tva_10, t0.contrat AS contrat_11, t0.reduction AS reduction_12, t0.societe_id AS societe_id_13 FROM etr_prod t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 263
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
     \n
            SELECT b.`etr_prod_id` as `etr`, mip.mois  as `mois`, mip.annee as `annee`, \n
            SUM(b.`montant`) as `montant` FROM `bpu_prod` b \n
            INNER JOIN `intervention_production` i on b.intervention_production_id = i.`id` \n
            INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id \n
            WHERE i.removed=0  \n
            GROUP BY `etr`,`mois`,`annee` HAVING `etr`=263 AND `mois`=4 AND `annee`=2025
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.rc AS rc_2, t0.anomalie AS anomalie_3, t0.date_rdv AS date_rdv_4, t0.mois AS mois_5, t0.penalite AS penalite_6, t0.annee AS annee_7, t0.nom_penalite AS nom_penalite_8, t0.etr_prod_id AS etr_prod_id_9, t0.planning_etr_prod_id AS planning_etr_prod_id_10, t0.fichier_penalites_id AS fichier_penalites_id_11 FROM penalite t0 WHERE t0.etr_prod_id = ? AND t0.mois = ? AND t0.annee = ?"
  "params" => [
    1 => 263
    2 => "04"
    3 => 2025
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.voie AS voie_3, t0.adresse AS adresse_4, t0.icon AS icon_5 FROM societe t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
     \n
            SELECT i.`jeton_rc`, i.`code_du_departement_abonne`, i.`nom_du_departement_abonne`, i.`code_de_la_commune_abonne`, \n
            i.`nom_de_la_commune_abonne`, i.`zone`, i.`technologie`, i.`nom_du_nro`, i.`operateur_immeuble`, i.`type_de_pbo`, \n
            i.`type_de_pto`, i.`intevention_id`, i.`type_intervention`, i.`date_intervention`, i.`nom_du_prestataire`, p.`login_technicien`, \n
            p.`tech_id`, i.`code_du_debriefing`, i.`libelle_du_debriefing`, i.`reference_de_article`, i.`pu`, i.`qte`, i.`montant`, \n
            i.`commentaire`, e.`raison_sociale`,b.`article_etr`,b.`pu`,b.`montant`,b.`pv_type`,s.`raison_sociale` \n
            FROM `intervention_production` i INNER JOIN `planning_etr_prod` p ON i.`planning_etr_prod_id` = p.`id` \n
            INNER JOIN `etr_prod` e on e.`id` = p.`etr_prod_id` INNER JOIN `bpu_prod` b on b.`intervention_production_id` = i.`id` \n
            INNER JOIN `article_prod` a ON a.`id` = b.`article_prod_id` INNER JOIN `societe` s ON s.`id` = e.`societe_id` \n
            INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id  \n
            WHERE i.removed=0 and mip.mois = 4 and mip.annee = 2025 and e.`id` = 263
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
     \n
            SELECT p2.login_technicien, p2.tech_id, p1.`rc`, p1.`anomalie`, p1.`date_rdv`, p1.`penalite`,p1.`mois`,  p1.`annee` FROM `penalite` p1\n
            INNER JOIN `planning_etr_prod` p2 on p1.`planning_etr_prod_id`=p2.`id` \n
            WHERE p1.`etr_prod_id` = 263 and p1.`mois`=4 and p1.`annee`=2025
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    \n
                SELECT p.tech_id as "techId", sum(b.montant) as "montant" FROM `bpu_prod` b INNER JOIN `intervention_production` i \n
                on i.`id` = b.`intervention_production_id` INNER JOIN `planning_etr_prod` p on i.planning_etr_prod_id = p.id \n
                INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id \n
                WHERE i.removed = 0 AND p.etr_prod_id = :etr and mip.mois = :mois AND mip.annee = :annee GROUP BY techId
    """
  "params" => [
    "mois" => 4
    "annee" => 2025
    "etr" => 263
  ]
  "types" => []
]

[
  "key" => "_security_main"
]

[
  "sql" => "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "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.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\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

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