POST https://www2.champishop.fr/statistiques-cueilleurs

Response
200 OK
Browse referrer URL
IP
77.156.227.211
Profiled on
Token
650274

Query Metrics

7 Database Queries
6 Different statements
73.07 ms Query time
0 Invalid entities
128 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
40.28 ms
(55.13%) 		1 
SELECT
                c.id AS cueilleur_id,
                c.nom,
                c.prenom,
                CONVERT(VARCHAR(10), s.creneau_scan, 23) AS jour,
                COALESCE(SUM(s.nombre_scans), 0) AS nbScans,
                COALESCE(SUM(s.poids_total), 0) AS poidsTotal
            FROM scan_cueilleur s
            INNER JOIN cueilleur c
                ON c.id = s.cueilleur_id
            WHERE s.creneau_scan >= ?
            AND s.creneau_scan < ?
            AND s.cueilleur_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            GROUP BY
                c.id,
                c.nom,
                c.prenom,
                CONVERT(VARCHAR(10), s.creneau_scan, 23)
            ORDER BY
                c.nom,
                c.prenom,
                jour
Parameters: 
[
  "2026-09-01 00:00:00"
  "2026-09-30 23:59:59"
  335
  336
  337
  338
  339
  340
  341
  342
  343
  344
  345
  346
  347
  348
  349
  350
  351
  352
  353
  354
  355
  356
  357
  358
  359
  360
  361
  362
  363
  364
  365
  366
  367
  368
  369
  370
  371
  372
  373
  374
  375
  376
  377
  378
  379
  380
  381
  382
  383
  384
  385
  386
  387
  388
  389
  390
  391
  392
  393
  394
  395
  396
  397
  398
  399
  400
  401
  402
  403
  404
  405
  406
  407
  408
  409
  410
  411
  412
  413
  414
  415
  416
  417
  418
  419
  420
  421
  422
  423
  424
  425
  426
  427
  428
  429
  430
  431
  432
  433
  434
  435
  436
  437
  438
  439
  440
  441
  442
  443
  444
  445
  446
  447
  448
  449
  450
  451
  452
  453
  454
]
View formatted query    View runnable query    Explain query
30.68 ms
(41.98%) 		2 
WITH creneaux AS (
                SELECT
                    s.cueilleur_id AS cueilleur_id,
                    DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0) AS heure,
                    COALESCE(SUM(s.nombre_scans), 0) AS nbScans,
                    COALESCE(SUM(s.poids_total), 0) AS poidsTotal
                FROM scan_cueilleur s
                WHERE s.creneau_scan >= ?
                AND s.creneau_scan < ?
                AND s.cueilleur_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                GROUP BY
                    s.cueilleur_id,
                    DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0)
                HAVING COALESCE(SUM(s.nombre_scans), 0) >= ?
            )
            SELECT
                c.id AS cueilleur_id,
                c.nom,
                c.prenom,
                SUM(cr.poidsTotal) AS poidsTotal,
                SUM(cr.nbScans) AS nbScans,
                COUNT(*) AS nbCreneauxActifs
            FROM creneaux cr
            INNER JOIN cueilleur c
                ON c.id = cr.cueilleur_id
            GROUP BY
                c.id,
                c.nom,
                c.prenom
            ORDER BY
                c.nom,
                c.prenom
Parameters: 
[
  "2026-09-01 00:00:00"
  "2026-09-30 23:59:59"
  335
  336
  337
  338
  339
  340
  341
  342
  343
  344
  345
  346
  347
  348
  349
  350
  351
  352
  353
  354
  355
  356
  357
  358
  359
  360
  361
  362
  363
  364
  365
  366
  367
  368
  369
  370
  371
  372
  373
  374
  375
  376
  377
  378
  379
  380
  381
  382
  383
  384
  385
  386
  387
  388
  389
  390
  391
  392
  393
  394
  395
  396
  397
  398
  399
  400
  401
  402
  403
  404
  405
  406
  407
  408
  409
  410
  411
  412
  413
  414
  415
  416
  417
  418
  419
  420
  421
  422
  423
  424
  425
  426
  427
  428
  429
  430
  431
  432
  433
  434
  435
  436
  437
  438
  439
  440
  441
  442
  443
  444
  445
  446
  447
  448
  449
  450
  451
  452
  453
  454
  1
]
View formatted query    View runnable query    Explain query
0.62 ms
(0.85%) 		1 
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 = ?
Parameters: 
[
  3058
]
View formatted query    View runnable query    Explain query
0.61 ms
(0.84%) 		1 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.48 ms
(0.66%) 		1 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.39 ms
(0.54%) 		1 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Cueilleur 120
App\Entity\SeuilRendement 3
App\Entity\User 1
App\Entity\Parametre 1
App\Entity\Article 1
App\Entity\Client 1
App\Entity\Transporteur 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Parametre No errors.
App\Entity\Article No errors.
App\Entity\Client No errors.
App\Entity\Transporteur No errors.
App\Entity\Cueilleur No errors.
App\Entity\ScanCueilleur No errors.
App\Entity\SeuilRendement No errors.