Symfony Profiler

[
  "params" => [
    "driver" => "sqlsrv"
    "idle_connection_ttl" => 600
    "host" => "10.10.1.187"
    "port" => 1433
    "user" => "sa"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "Ruol"
    "charset" => "UTF-8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.roles AS roles_12, t0.restriction_horaire AS restriction_horaire_13 FROM fos_user t0 WHERE t0.id = ?"
  "params" => [
    1 => 3058
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#497
      +name: "INTEGER"
    }
  ]
]

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

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

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

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

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

[
  "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" => "App\Service\UserSessionManager::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" => "ContainerBgakTVb\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.Parametre_raison_sociale AS Parametre_raison_sociale_2, t0.Parametre_adresse AS Parametre_adresse_3, t0.Parametre_complement_adresse AS Parametre_complement_adresse_4, t0.Parametre_code_postal AS Parametre_code_postal_5, t0.Parametre_ville AS Parametre_ville_6, t0.Parametre_email AS Parametre_email_7, t0.Parametre_fax AS Parametre_fax_8, t0.Parametre_capital AS Parametre_capital_9, t0.Parametre_siret AS Parametre_siret_10, t0.Parametre_naf AS Parametre_naf_11, t0.Parametre_tva AS Parametre_tva_12, t0.Parametre_banque AS Parametre_banque_13, t0.Parametre_guichet AS Parametre_guichet_14, t0.Parametre_compte AS Parametre_compte_15, t0.Parametre_cle_rib AS Parametre_cle_rib_16, t0.Parametre_iban AS Parametre_iban_17, t0.Parametre_bic AS Parametre_bic_18, t0.Parametre_pied_facture AS Parametre_pied_facture_19, t0.Parametre_pied_bl AS Parametre_pied_bl_20, t0.Parametre_pied_releve_decadaire AS Parametre_pied_releve_decadaire_21, t0.Parametre_bg AS Parametre_bg_22, t0.Parametre_vente_champignons AS Parametre_vente_champignons_23, t0.Parametre_compte_client AS Parametre_compte_client_24, t0.Parametre_compte_tva AS Parametre_compte_tva_25, t0.Parametre_compte_anda AS Parametre_compte_anda_26, t0.Parametre_compte_ctifl AS Parametre_compte_ctifl_27, t0.Parametre_periode_comptable_debut AS Parametre_periode_comptable_debut_28, t0.Parametre_periode_comptable_fin AS Parametre_periode_comptable_fin_29, t0.Parametre_pied_avoir AS Parametre_pied_avoir_30, t0.Parametre_telephone AS Parametre_telephone_31, t0.Parametre_siren AS Parametre_siren_32, t0.Parametre_rcs AS Parametre_rcs_33, t0.Parametre_forme_juridique AS Parametre_forme_juridique_34, t0.Parametre_gln_facture AS Parametre_gln_facture_35, t0.Parametre_gln_regle_a AS Parametre_gln_regle_a_36, t0.Parametre_cdt_penalites AS Parametre_cdt_penalites_37, t0.Parametre_cdt_indemnite AS Parametre_cdt_indemnite_38, t0.Parametre_cdt_escompte AS Parametre_cdt_escompte_39, t0.Parametre_cdt_mention AS Parametre_cdt_mention_40, t0.Code_Ifco_Ruol AS Code_Ifco_Ruol_41, t0.parametre_taux_tva_palette AS parametre_taux_tva_palette_42, t0.parametre_code_comptable_palette AS parametre_code_comptable_palette_43, t0.parametre_numero_client_affacturage AS parametre_numero_client_affacturage_44, t0.parametre_numero_emetteur_affacturage AS parametre_numero_emetteur_affacturage_45, t0.nom_cueilleur_caches AS nom_cueilleur_caches_46, t0.information_affiche_ecran_cueilleuse AS information_affiche_ecran_cueilleuse_47, t0.article_palette_id AS article_palette_id_48, t0.rentree_emballage_client_defaut_id AS rentree_emballage_client_defaut_id_49, t0.parametre_transporteur_rungis_id AS parametre_transporteur_rungis_id_50 FROM parametre t0 WHERE t0.id = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#497
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.code AS code_4, t0.code_cueilleuse AS code_cueilleuse_5, t0.actif AS actif_6 FROM cueilleur t0 WHERE t0.actif = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2167
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => """
    \n
                SELECT\n
                    c.id AS cueilleur_id,\n
                    c.nom,\n
                    c.prenom,\n
                    CONVERT(VARCHAR(10), s.creneau_scan, 23) AS jour,\n
                    COALESCE(SUM(s.nombre_scans), 0) AS nbScans,\n
                    COALESCE(SUM(s.poids_total), 0) AS poidsTotal\n
                FROM scan_cueilleur s\n
                INNER JOIN cueilleur c\n
                    ON c.id = s.cueilleur_id\n
                WHERE s.creneau_scan >= ?\n
                AND s.creneau_scan < ?\n
                AND s.cueilleur_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
                GROUP BY\n
                    c.id,\n
                    c.nom,\n
                    c.prenom,\n
                    CONVERT(VARCHAR(10), s.creneau_scan, 23)\n
                ORDER BY\n
                    c.nom,\n
                    c.prenom,\n
                    jour\n
            
    """
  "params" => [
    1 => "2026-09-01 00:00:00"
    2 => "2026-09-30 23:59:59"
    3 => 335
    4 => 336
    5 => 337
    6 => 338
    7 => 339
    8 => 340
    9 => 341
    10 => 342
    11 => 343
    12 => 344
    13 => 345
    14 => 346
    15 => 347
    16 => 348
    17 => 349
    18 => 350
    19 => 351
    20 => 352
    21 => 353
    22 => 354
    23 => 355
    24 => 356
    25 => 357
    26 => 358
    27 => 359
    28 => 360
    29 => 361
    30 => 362
    31 => 363
    32 => 364
    33 => 365
    34 => 366
    35 => 367
    36 => 368
    37 => 369
    38 => 370
    39 => 371
    40 => 372
    41 => 373
    42 => 374
    43 => 375
    44 => 376
    45 => 377
    46 => 378
    47 => 379
    48 => 380
    49 => 381
    50 => 382
    51 => 383
    52 => 384
    53 => 385
    54 => 386
    55 => 387
    56 => 388
    57 => 389
    58 => 390
    59 => 391
    60 => 392
    61 => 393
    62 => 394
    63 => 395
    64 => 396
    65 => 397
    66 => 398
    67 => 399
    68 => 400
    69 => 401
    70 => 402
    71 => 403
    72 => 404
    73 => 405
    74 => 406
    75 => 407
    76 => 408
    77 => 409
    78 => 410
    79 => 411
    80 => 412
    81 => 413
    82 => 414
    83 => 415
    84 => 416
    85 => 417
    86 => 418
    87 => 419
    88 => 420
    89 => 421
    90 => 422
    91 => 423
    92 => 424
    93 => 425
    94 => 426
    95 => 427
    96 => 428
    97 => 429
    98 => 430
    99 => 431
    100 => 432
    101 => 433
    102 => 434
    103 => 435
    104 => 436
    105 => 437
    106 => 438
    107 => 439
    108 => 440
    109 => 441
    110 => 442
    111 => 443
    112 => 444
    113 => 445
    114 => 446
    115 => 447
    116 => 448
    117 => 449
    118 => 450
    119 => 451
    120 => 452
    121 => 453
    122 => 454
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2302
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2302}
    3 => Doctrine\DBAL\ParameterType {#497
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#497}
    5 => Doctrine\DBAL\ParameterType {#497}
    6 => Doctrine\DBAL\ParameterType {#497}
    7 => Doctrine\DBAL\ParameterType {#497}
    8 => Doctrine\DBAL\ParameterType {#497}
    9 => Doctrine\DBAL\ParameterType {#497}
    10 => Doctrine\DBAL\ParameterType {#497}
    11 => Doctrine\DBAL\ParameterType {#497}
    12 => Doctrine\DBAL\ParameterType {#497}
    13 => Doctrine\DBAL\ParameterType {#497}
    14 => Doctrine\DBAL\ParameterType {#497}
    15 => Doctrine\DBAL\ParameterType {#497}
    16 => Doctrine\DBAL\ParameterType {#497}
    17 => Doctrine\DBAL\ParameterType {#497}
    18 => Doctrine\DBAL\ParameterType {#497}
    19 => Doctrine\DBAL\ParameterType {#497}
    20 => Doctrine\DBAL\ParameterType {#497}
    21 => Doctrine\DBAL\ParameterType {#497}
    22 => Doctrine\DBAL\ParameterType {#497}
    23 => Doctrine\DBAL\ParameterType {#497}
    24 => Doctrine\DBAL\ParameterType {#497}
    25 => Doctrine\DBAL\ParameterType {#497}
    26 => Doctrine\DBAL\ParameterType {#497}
    27 => Doctrine\DBAL\ParameterType {#497}
    28 => Doctrine\DBAL\ParameterType {#497}
    29 => Doctrine\DBAL\ParameterType {#497}
    30 => Doctrine\DBAL\ParameterType {#497}
    31 => Doctrine\DBAL\ParameterType {#497}
    32 => Doctrine\DBAL\ParameterType {#497}
    33 => Doctrine\DBAL\ParameterType {#497}
    34 => Doctrine\DBAL\ParameterType {#497}
    35 => Doctrine\DBAL\ParameterType {#497}
    36 => Doctrine\DBAL\ParameterType {#497}
    37 => Doctrine\DBAL\ParameterType {#497}
    38 => Doctrine\DBAL\ParameterType {#497}
    39 => Doctrine\DBAL\ParameterType {#497}
    40 => Doctrine\DBAL\ParameterType {#497}
    41 => Doctrine\DBAL\ParameterType {#497}
    42 => Doctrine\DBAL\ParameterType {#497}
    43 => Doctrine\DBAL\ParameterType {#497}
    44 => Doctrine\DBAL\ParameterType {#497}
    45 => Doctrine\DBAL\ParameterType {#497}
    46 => Doctrine\DBAL\ParameterType {#497}
    47 => Doctrine\DBAL\ParameterType {#497}
    48 => Doctrine\DBAL\ParameterType {#497}
    49 => Doctrine\DBAL\ParameterType {#497}
    50 => Doctrine\DBAL\ParameterType {#497}
    51 => Doctrine\DBAL\ParameterType {#497}
    52 => Doctrine\DBAL\ParameterType {#497}
    53 => Doctrine\DBAL\ParameterType {#497}
    54 => Doctrine\DBAL\ParameterType {#497}
    55 => Doctrine\DBAL\ParameterType {#497}
    56 => Doctrine\DBAL\ParameterType {#497}
    57 => Doctrine\DBAL\ParameterType {#497}
    58 => Doctrine\DBAL\ParameterType {#497}
    59 => Doctrine\DBAL\ParameterType {#497}
    60 => Doctrine\DBAL\ParameterType {#497}
    61 => Doctrine\DBAL\ParameterType {#497}
    62 => Doctrine\DBAL\ParameterType {#497}
    63 => Doctrine\DBAL\ParameterType {#497}
    64 => Doctrine\DBAL\ParameterType {#497}
    65 => Doctrine\DBAL\ParameterType {#497}
    66 => Doctrine\DBAL\ParameterType {#497}
    67 => Doctrine\DBAL\ParameterType {#497}
    68 => Doctrine\DBAL\ParameterType {#497}
    69 => Doctrine\DBAL\ParameterType {#497}
    70 => Doctrine\DBAL\ParameterType {#497}
    71 => Doctrine\DBAL\ParameterType {#497}
    72 => Doctrine\DBAL\ParameterType {#497}
    73 => Doctrine\DBAL\ParameterType {#497}
    74 => Doctrine\DBAL\ParameterType {#497}
    75 => Doctrine\DBAL\ParameterType {#497}
    76 => Doctrine\DBAL\ParameterType {#497}
    77 => Doctrine\DBAL\ParameterType {#497}
    78 => Doctrine\DBAL\ParameterType {#497}
    79 => Doctrine\DBAL\ParameterType {#497}
    80 => Doctrine\DBAL\ParameterType {#497}
    81 => Doctrine\DBAL\ParameterType {#497}
    82 => Doctrine\DBAL\ParameterType {#497}
    83 => Doctrine\DBAL\ParameterType {#497}
    84 => Doctrine\DBAL\ParameterType {#497}
    85 => Doctrine\DBAL\ParameterType {#497}
    86 => Doctrine\DBAL\ParameterType {#497}
    87 => Doctrine\DBAL\ParameterType {#497}
    88 => Doctrine\DBAL\ParameterType {#497}
    89 => Doctrine\DBAL\ParameterType {#497}
    90 => Doctrine\DBAL\ParameterType {#497}
    91 => Doctrine\DBAL\ParameterType {#497}
    92 => Doctrine\DBAL\ParameterType {#497}
    93 => Doctrine\DBAL\ParameterType {#497}
    94 => Doctrine\DBAL\ParameterType {#497}
    95 => Doctrine\DBAL\ParameterType {#497}
    96 => Doctrine\DBAL\ParameterType {#497}
    97 => Doctrine\DBAL\ParameterType {#497}
    98 => Doctrine\DBAL\ParameterType {#497}
    99 => Doctrine\DBAL\ParameterType {#497}
    100 => Doctrine\DBAL\ParameterType {#497}
    101 => Doctrine\DBAL\ParameterType {#497}
    102 => Doctrine\DBAL\ParameterType {#497}
    103 => Doctrine\DBAL\ParameterType {#497}
    104 => Doctrine\DBAL\ParameterType {#497}
    105 => Doctrine\DBAL\ParameterType {#497}
    106 => Doctrine\DBAL\ParameterType {#497}
    107 => Doctrine\DBAL\ParameterType {#497}
    108 => Doctrine\DBAL\ParameterType {#497}
    109 => Doctrine\DBAL\ParameterType {#497}
    110 => Doctrine\DBAL\ParameterType {#497}
    111 => Doctrine\DBAL\ParameterType {#497}
    112 => Doctrine\DBAL\ParameterType {#497}
    113 => Doctrine\DBAL\ParameterType {#497}
    114 => Doctrine\DBAL\ParameterType {#497}
    115 => Doctrine\DBAL\ParameterType {#497}
    116 => Doctrine\DBAL\ParameterType {#497}
    117 => Doctrine\DBAL\ParameterType {#497}
    118 => Doctrine\DBAL\ParameterType {#497}
    119 => Doctrine\DBAL\ParameterType {#497}
    120 => Doctrine\DBAL\ParameterType {#497}
    121 => Doctrine\DBAL\ParameterType {#497}
    122 => Doctrine\DBAL\ParameterType {#497}
  ]
]

[
  "sql" => """
    \n
                WITH creneaux AS (\n
                    SELECT\n
                        s.cueilleur_id AS cueilleur_id,\n
                        DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0) AS heure,\n
                        COALESCE(SUM(s.nombre_scans), 0) AS nbScans,\n
                        COALESCE(SUM(s.poids_total), 0) AS poidsTotal\n
                    FROM scan_cueilleur s\n
                    WHERE s.creneau_scan >= ?\n
                    AND s.creneau_scan < ?\n
                    AND s.cueilleur_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
                    GROUP BY\n
                        s.cueilleur_id,\n
                        DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0)\n
                    HAVING COALESCE(SUM(s.nombre_scans), 0) >= ?\n
                )\n
                SELECT\n
                    c.id AS cueilleur_id,\n
                    c.nom,\n
                    c.prenom,\n
                    SUM(cr.poidsTotal) AS poidsTotal,\n
                    SUM(cr.nbScans) AS nbScans,\n
                    COUNT(*) AS nbCreneauxActifs\n
                FROM creneaux cr\n
                INNER JOIN cueilleur c\n
                    ON c.id = cr.cueilleur_id\n
                GROUP BY\n
                    c.id,\n
                    c.nom,\n
                    c.prenom\n
                ORDER BY\n
                    c.nom,\n
                    c.prenom\n
            
    """
  "params" => [
    1 => "2026-09-01 00:00:00"
    2 => "2026-09-30 23:59:59"
    3 => 335
    4 => 336
    5 => 337
    6 => 338
    7 => 339
    8 => 340
    9 => 341
    10 => 342
    11 => 343
    12 => 344
    13 => 345
    14 => 346
    15 => 347
    16 => 348
    17 => 349
    18 => 350
    19 => 351
    20 => 352
    21 => 353
    22 => 354
    23 => 355
    24 => 356
    25 => 357
    26 => 358
    27 => 359
    28 => 360
    29 => 361
    30 => 362
    31 => 363
    32 => 364
    33 => 365
    34 => 366
    35 => 367
    36 => 368
    37 => 369
    38 => 370
    39 => 371
    40 => 372
    41 => 373
    42 => 374
    43 => 375
    44 => 376
    45 => 377
    46 => 378
    47 => 379
    48 => 380
    49 => 381
    50 => 382
    51 => 383
    52 => 384
    53 => 385
    54 => 386
    55 => 387
    56 => 388
    57 => 389
    58 => 390
    59 => 391
    60 => 392
    61 => 393
    62 => 394
    63 => 395
    64 => 396
    65 => 397
    66 => 398
    67 => 399
    68 => 400
    69 => 401
    70 => 402
    71 => 403
    72 => 404
    73 => 405
    74 => 406
    75 => 407
    76 => 408
    77 => 409
    78 => 410
    79 => 411
    80 => 412
    81 => 413
    82 => 414
    83 => 415
    84 => 416
    85 => 417
    86 => 418
    87 => 419
    88 => 420
    89 => 421
    90 => 422
    91 => 423
    92 => 424
    93 => 425
    94 => 426
    95 => 427
    96 => 428
    97 => 429
    98 => 430
    99 => 431
    100 => 432
    101 => 433
    102 => 434
    103 => 435
    104 => 436
    105 => 437
    106 => 438
    107 => 439
    108 => 440
    109 => 441
    110 => 442
    111 => 443
    112 => 444
    113 => 445
    114 => 446
    115 => 447
    116 => 448
    117 => 449
    118 => 450
    119 => 451
    120 => 452
    121 => 453
    122 => 454
    123 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2302
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2302}
    3 => Doctrine\DBAL\ParameterType {#497
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#497}
    5 => Doctrine\DBAL\ParameterType {#497}
    6 => Doctrine\DBAL\ParameterType {#497}
    7 => Doctrine\DBAL\ParameterType {#497}
    8 => Doctrine\DBAL\ParameterType {#497}
    9 => Doctrine\DBAL\ParameterType {#497}
    10 => Doctrine\DBAL\ParameterType {#497}
    11 => Doctrine\DBAL\ParameterType {#497}
    12 => Doctrine\DBAL\ParameterType {#497}
    13 => Doctrine\DBAL\ParameterType {#497}
    14 => Doctrine\DBAL\ParameterType {#497}
    15 => Doctrine\DBAL\ParameterType {#497}
    16 => Doctrine\DBAL\ParameterType {#497}
    17 => Doctrine\DBAL\ParameterType {#497}
    18 => Doctrine\DBAL\ParameterType {#497}
    19 => Doctrine\DBAL\ParameterType {#497}
    20 => Doctrine\DBAL\ParameterType {#497}
    21 => Doctrine\DBAL\ParameterType {#497}
    22 => Doctrine\DBAL\ParameterType {#497}
    23 => Doctrine\DBAL\ParameterType {#497}
    24 => Doctrine\DBAL\ParameterType {#497}
    25 => Doctrine\DBAL\ParameterType {#497}
    26 => Doctrine\DBAL\ParameterType {#497}
    27 => Doctrine\DBAL\ParameterType {#497}
    28 => Doctrine\DBAL\ParameterType {#497}
    29 => Doctrine\DBAL\ParameterType {#497}
    30 => Doctrine\DBAL\ParameterType {#497}
    31 => Doctrine\DBAL\ParameterType {#497}
    32 => Doctrine\DBAL\ParameterType {#497}
    33 => Doctrine\DBAL\ParameterType {#497}
    34 => Doctrine\DBAL\ParameterType {#497}
    35 => Doctrine\DBAL\ParameterType {#497}
    36 => Doctrine\DBAL\ParameterType {#497}
    37 => Doctrine\DBAL\ParameterType {#497}
    38 => Doctrine\DBAL\ParameterType {#497}
    39 => Doctrine\DBAL\ParameterType {#497}
    40 => Doctrine\DBAL\ParameterType {#497}
    41 => Doctrine\DBAL\ParameterType {#497}
    42 => Doctrine\DBAL\ParameterType {#497}
    43 => Doctrine\DBAL\ParameterType {#497}
    44 => Doctrine\DBAL\ParameterType {#497}
    45 => Doctrine\DBAL\ParameterType {#497}
    46 => Doctrine\DBAL\ParameterType {#497}
    47 => Doctrine\DBAL\ParameterType {#497}
    48 => Doctrine\DBAL\ParameterType {#497}
    49 => Doctrine\DBAL\ParameterType {#497}
    50 => Doctrine\DBAL\ParameterType {#497}
    51 => Doctrine\DBAL\ParameterType {#497}
    52 => Doctrine\DBAL\ParameterType {#497}
    53 => Doctrine\DBAL\ParameterType {#497}
    54 => Doctrine\DBAL\ParameterType {#497}
    55 => Doctrine\DBAL\ParameterType {#497}
    56 => Doctrine\DBAL\ParameterType {#497}
    57 => Doctrine\DBAL\ParameterType {#497}
    58 => Doctrine\DBAL\ParameterType {#497}
    59 => Doctrine\DBAL\ParameterType {#497}
    60 => Doctrine\DBAL\ParameterType {#497}
    61 => Doctrine\DBAL\ParameterType {#497}
    62 => Doctrine\DBAL\ParameterType {#497}
    63 => Doctrine\DBAL\ParameterType {#497}
    64 => Doctrine\DBAL\ParameterType {#497}
    65 => Doctrine\DBAL\ParameterType {#497}
    66 => Doctrine\DBAL\ParameterType {#497}
    67 => Doctrine\DBAL\ParameterType {#497}
    68 => Doctrine\DBAL\ParameterType {#497}
    69 => Doctrine\DBAL\ParameterType {#497}
    70 => Doctrine\DBAL\ParameterType {#497}
    71 => Doctrine\DBAL\ParameterType {#497}
    72 => Doctrine\DBAL\ParameterType {#497}
    73 => Doctrine\DBAL\ParameterType {#497}
    74 => Doctrine\DBAL\ParameterType {#497}
    75 => Doctrine\DBAL\ParameterType {#497}
    76 => Doctrine\DBAL\ParameterType {#497}
    77 => Doctrine\DBAL\ParameterType {#497}
    78 => Doctrine\DBAL\ParameterType {#497}
    79 => Doctrine\DBAL\ParameterType {#497}
    80 => Doctrine\DBAL\ParameterType {#497}
    81 => Doctrine\DBAL\ParameterType {#497}
    82 => Doctrine\DBAL\ParameterType {#497}
    83 => Doctrine\DBAL\ParameterType {#497}
    84 => Doctrine\DBAL\ParameterType {#497}
    85 => Doctrine\DBAL\ParameterType {#497}
    86 => Doctrine\DBAL\ParameterType {#497}
    87 => Doctrine\DBAL\ParameterType {#497}
    88 => Doctrine\DBAL\ParameterType {#497}
    89 => Doctrine\DBAL\ParameterType {#497}
    90 => Doctrine\DBAL\ParameterType {#497}
    91 => Doctrine\DBAL\ParameterType {#497}
    92 => Doctrine\DBAL\ParameterType {#497}
    93 => Doctrine\DBAL\ParameterType {#497}
    94 => Doctrine\DBAL\ParameterType {#497}
    95 => Doctrine\DBAL\ParameterType {#497}
    96 => Doctrine\DBAL\ParameterType {#497}
    97 => Doctrine\DBAL\ParameterType {#497}
    98 => Doctrine\DBAL\ParameterType {#497}
    99 => Doctrine\DBAL\ParameterType {#497}
    100 => Doctrine\DBAL\ParameterType {#497}
    101 => Doctrine\DBAL\ParameterType {#497}
    102 => Doctrine\DBAL\ParameterType {#497}
    103 => Doctrine\DBAL\ParameterType {#497}
    104 => Doctrine\DBAL\ParameterType {#497}
    105 => Doctrine\DBAL\ParameterType {#497}
    106 => Doctrine\DBAL\ParameterType {#497}
    107 => Doctrine\DBAL\ParameterType {#497}
    108 => Doctrine\DBAL\ParameterType {#497}
    109 => Doctrine\DBAL\ParameterType {#497}
    110 => Doctrine\DBAL\ParameterType {#497}
    111 => Doctrine\DBAL\ParameterType {#497}
    112 => Doctrine\DBAL\ParameterType {#497}
    113 => Doctrine\DBAL\ParameterType {#497}
    114 => Doctrine\DBAL\ParameterType {#497}
    115 => Doctrine\DBAL\ParameterType {#497}
    116 => Doctrine\DBAL\ParameterType {#497}
    117 => Doctrine\DBAL\ParameterType {#497}
    118 => Doctrine\DBAL\ParameterType {#497}
    119 => Doctrine\DBAL\ParameterType {#497}
    120 => Doctrine\DBAL\ParameterType {#497}
    121 => Doctrine\DBAL\ParameterType {#497}
    122 => Doctrine\DBAL\ParameterType {#497}
    123 => Doctrine\DBAL\ParameterType {#2302}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.couleur AS couleur_2, t0.poids_min AS poids_min_3, t0.poids_max AS poids_max_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6 FROM seuil_rendement t0 ORDER BY t0.ordre ASC"
]

[
  "sql" => """
    \n
                WITH creneaux AS (\n
                    SELECT\n
                        s.cueilleur_id AS cueilleur_id,\n
                        DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0) AS heure,\n
                        COALESCE(SUM(s.nombre_scans), 0) AS nbScans,\n
                        COALESCE(SUM(s.poids_total), 0) AS poidsTotal\n
                    FROM scan_cueilleur s\n
                    WHERE s.creneau_scan >= ?\n
                    AND s.creneau_scan < ?\n
                    AND s.cueilleur_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
                    GROUP BY\n
                        s.cueilleur_id,\n
                        DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0)\n
                    HAVING COALESCE(SUM(s.nombre_scans), 0) >= ?\n
                )\n
                SELECT\n
                    c.id AS cueilleur_id,\n
                    c.nom,\n
                    c.prenom,\n
                    SUM(cr.poidsTotal) AS poidsTotal,\n
                    SUM(cr.nbScans) AS nbScans,\n
                    COUNT(*) AS nbCreneauxActifs\n
                FROM creneaux cr\n
                INNER JOIN cueilleur c\n
                    ON c.id = cr.cueilleur_id\n
                GROUP BY\n
                    c.id,\n
                    c.nom,\n
                    c.prenom\n
                ORDER BY\n
                    c.nom,\n
                    c.prenom\n
            
    """
  "params" => [
    1 => "2026-09-01 00:00:00"
    2 => "2026-09-30 23:59:59"
    3 => 335
    4 => 336
    5 => 337
    6 => 338
    7 => 339
    8 => 340
    9 => 341
    10 => 342
    11 => 343
    12 => 344
    13 => 345
    14 => 346
    15 => 347
    16 => 348
    17 => 349
    18 => 350
    19 => 351
    20 => 352
    21 => 353
    22 => 354
    23 => 355
    24 => 356
    25 => 357
    26 => 358
    27 => 359
    28 => 360
    29 => 361
    30 => 362
    31 => 363
    32 => 364
    33 => 365
    34 => 366
    35 => 367
    36 => 368
    37 => 369
    38 => 370
    39 => 371
    40 => 372
    41 => 373
    42 => 374
    43 => 375
    44 => 376
    45 => 377
    46 => 378
    47 => 379
    48 => 380
    49 => 381
    50 => 382
    51 => 383
    52 => 384
    53 => 385
    54 => 386
    55 => 387
    56 => 388
    57 => 389
    58 => 390
    59 => 391
    60 => 392
    61 => 393
    62 => 394
    63 => 395
    64 => 396
    65 => 397
    66 => 398
    67 => 399
    68 => 400
    69 => 401
    70 => 402
    71 => 403
    72 => 404
    73 => 405
    74 => 406
    75 => 407
    76 => 408
    77 => 409
    78 => 410
    79 => 411
    80 => 412
    81 => 413
    82 => 414
    83 => 415
    84 => 416
    85 => 417
    86 => 418
    87 => 419
    88 => 420
    89 => 421
    90 => 422
    91 => 423
    92 => 424
    93 => 425
    94 => 426
    95 => 427
    96 => 428
    97 => 429
    98 => 430
    99 => 431
    100 => 432
    101 => 433
    102 => 434
    103 => 435
    104 => 436
    105 => 437
    106 => 438
    107 => 439
    108 => 440
    109 => 441
    110 => 442
    111 => 443
    112 => 444
    113 => 445
    114 => 446
    115 => 447
    116 => 448
    117 => 449
    118 => 450
    119 => 451
    120 => 452
    121 => 453
    122 => 454
    123 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2302
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2302}
    3 => Doctrine\DBAL\ParameterType {#497
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#497}
    5 => Doctrine\DBAL\ParameterType {#497}
    6 => Doctrine\DBAL\ParameterType {#497}
    7 => Doctrine\DBAL\ParameterType {#497}
    8 => Doctrine\DBAL\ParameterType {#497}
    9 => Doctrine\DBAL\ParameterType {#497}
    10 => Doctrine\DBAL\ParameterType {#497}
    11 => Doctrine\DBAL\ParameterType {#497}
    12 => Doctrine\DBAL\ParameterType {#497}
    13 => Doctrine\DBAL\ParameterType {#497}
    14 => Doctrine\DBAL\ParameterType {#497}
    15 => Doctrine\DBAL\ParameterType {#497}
    16 => Doctrine\DBAL\ParameterType {#497}
    17 => Doctrine\DBAL\ParameterType {#497}
    18 => Doctrine\DBAL\ParameterType {#497}
    19 => Doctrine\DBAL\ParameterType {#497}
    20 => Doctrine\DBAL\ParameterType {#497}
    21 => Doctrine\DBAL\ParameterType {#497}
    22 => Doctrine\DBAL\ParameterType {#497}
    23 => Doctrine\DBAL\ParameterType {#497}
    24 => Doctrine\DBAL\ParameterType {#497}
    25 => Doctrine\DBAL\ParameterType {#497}
    26 => Doctrine\DBAL\ParameterType {#497}
    27 => Doctrine\DBAL\ParameterType {#497}
    28 => Doctrine\DBAL\ParameterType {#497}
    29 => Doctrine\DBAL\ParameterType {#497}
    30 => Doctrine\DBAL\ParameterType {#497}
    31 => Doctrine\DBAL\ParameterType {#497}
    32 => Doctrine\DBAL\ParameterType {#497}
    33 => Doctrine\DBAL\ParameterType {#497}
    34 => Doctrine\DBAL\ParameterType {#497}
    35 => Doctrine\DBAL\ParameterType {#497}
    36 => Doctrine\DBAL\ParameterType {#497}
    37 => Doctrine\DBAL\ParameterType {#497}
    38 => Doctrine\DBAL\ParameterType {#497}
    39 => Doctrine\DBAL\ParameterType {#497}
    40 => Doctrine\DBAL\ParameterType {#497}
    41 => Doctrine\DBAL\ParameterType {#497}
    42 => Doctrine\DBAL\ParameterType {#497}
    43 => Doctrine\DBAL\ParameterType {#497}
    44 => Doctrine\DBAL\ParameterType {#497}
    45 => Doctrine\DBAL\ParameterType {#497}
    46 => Doctrine\DBAL\ParameterType {#497}
    47 => Doctrine\DBAL\ParameterType {#497}
    48 => Doctrine\DBAL\ParameterType {#497}
    49 => Doctrine\DBAL\ParameterType {#497}
    50 => Doctrine\DBAL\ParameterType {#497}
    51 => Doctrine\DBAL\ParameterType {#497}
    52 => Doctrine\DBAL\ParameterType {#497}
    53 => Doctrine\DBAL\ParameterType {#497}
    54 => Doctrine\DBAL\ParameterType {#497}
    55 => Doctrine\DBAL\ParameterType {#497}
    56 => Doctrine\DBAL\ParameterType {#497}
    57 => Doctrine\DBAL\ParameterType {#497}
    58 => Doctrine\DBAL\ParameterType {#497}
    59 => Doctrine\DBAL\ParameterType {#497}
    60 => Doctrine\DBAL\ParameterType {#497}
    61 => Doctrine\DBAL\ParameterType {#497}
    62 => Doctrine\DBAL\ParameterType {#497}
    63 => Doctrine\DBAL\ParameterType {#497}
    64 => Doctrine\DBAL\ParameterType {#497}
    65 => Doctrine\DBAL\ParameterType {#497}
    66 => Doctrine\DBAL\ParameterType {#497}
    67 => Doctrine\DBAL\ParameterType {#497}
    68 => Doctrine\DBAL\ParameterType {#497}
    69 => Doctrine\DBAL\ParameterType {#497}
    70 => Doctrine\DBAL\ParameterType {#497}
    71 => Doctrine\DBAL\ParameterType {#497}
    72 => Doctrine\DBAL\ParameterType {#497}
    73 => Doctrine\DBAL\ParameterType {#497}
    74 => Doctrine\DBAL\ParameterType {#497}
    75 => Doctrine\DBAL\ParameterType {#497}
    76 => Doctrine\DBAL\ParameterType {#497}
    77 => Doctrine\DBAL\ParameterType {#497}
    78 => Doctrine\DBAL\ParameterType {#497}
    79 => Doctrine\DBAL\ParameterType {#497}
    80 => Doctrine\DBAL\ParameterType {#497}
    81 => Doctrine\DBAL\ParameterType {#497}
    82 => Doctrine\DBAL\ParameterType {#497}
    83 => Doctrine\DBAL\ParameterType {#497}
    84 => Doctrine\DBAL\ParameterType {#497}
    85 => Doctrine\DBAL\ParameterType {#497}
    86 => Doctrine\DBAL\ParameterType {#497}
    87 => Doctrine\DBAL\ParameterType {#497}
    88 => Doctrine\DBAL\ParameterType {#497}
    89 => Doctrine\DBAL\ParameterType {#497}
    90 => Doctrine\DBAL\ParameterType {#497}
    91 => Doctrine\DBAL\ParameterType {#497}
    92 => Doctrine\DBAL\ParameterType {#497}
    93 => Doctrine\DBAL\ParameterType {#497}
    94 => Doctrine\DBAL\ParameterType {#497}
    95 => Doctrine\DBAL\ParameterType {#497}
    96 => Doctrine\DBAL\ParameterType {#497}
    97 => Doctrine\DBAL\ParameterType {#497}
    98 => Doctrine\DBAL\ParameterType {#497}
    99 => Doctrine\DBAL\ParameterType {#497}
    100 => Doctrine\DBAL\ParameterType {#497}
    101 => Doctrine\DBAL\ParameterType {#497}
    102 => Doctrine\DBAL\ParameterType {#497}
    103 => Doctrine\DBAL\ParameterType {#497}
    104 => Doctrine\DBAL\ParameterType {#497}
    105 => Doctrine\DBAL\ParameterType {#497}
    106 => Doctrine\DBAL\ParameterType {#497}
    107 => Doctrine\DBAL\ParameterType {#497}
    108 => Doctrine\DBAL\ParameterType {#497}
    109 => Doctrine\DBAL\ParameterType {#497}
    110 => Doctrine\DBAL\ParameterType {#497}
    111 => Doctrine\DBAL\ParameterType {#497}
    112 => Doctrine\DBAL\ParameterType {#497}
    113 => Doctrine\DBAL\ParameterType {#497}
    114 => Doctrine\DBAL\ParameterType {#497}
    115 => Doctrine\DBAL\ParameterType {#497}
    116 => Doctrine\DBAL\ParameterType {#497}
    117 => Doctrine\DBAL\ParameterType {#497}
    118 => Doctrine\DBAL\ParameterType {#497}
    119 => Doctrine\DBAL\ParameterType {#497}
    120 => Doctrine\DBAL\ParameterType {#497}
    121 => Doctrine\DBAL\ParameterType {#497}
    122 => Doctrine\DBAL\ParameterType {#497}
    123 => Doctrine\DBAL\ParameterType {#2302}
  ]
]