Symfony Profiler

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 = ?

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 = 3058;

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

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 = 1 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

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 = ?

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 = 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

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 >= '2026-09-01 00:00:00'
            AND s.creneau_scan < '2026-09-30 23:59:59'
            AND s.cueilleur_id IN (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)
            GROUP BY
                c.id,
                c.nom,
                c.prenom,
                CONVERT(VARCHAR(10), s.creneau_scan, 23)
            ORDER BY
                c.nom,
                c.prenom,
                jour
        ;

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

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 >= '2026-09-01 00:00:00'
                AND s.creneau_scan < '2026-09-30 23:59:59'
                AND s.cueilleur_id IN (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)
                GROUP BY
                    s.cueilleur_id,
                    DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0)
                HAVING COALESCE(SUM(s.nombre_scans), 0) >= 1
            )
            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
        ;

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

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;

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

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 >= '2026-09-01 00:00:00'
                AND s.creneau_scan < '2026-09-30 23:59:59'
                AND s.cueilleur_id IN (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)
                GROUP BY
                    s.cueilleur_id,
                    DATEADD(HOUR, DATEDIFF(HOUR, 0, s.creneau_scan), 0)
                HAVING COALESCE(SUM(s.nombre_scans), 0) >= 1
            )
            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
        ;