Symfony Profiler

SELECT
  mt_parent.id as category_id,
  mt_parent.name as category_name,
  COALESCE(
    SUM(
      CASE WHEN me.loaded_weight IS NOT NULL
      AND me.empty_weight IS NOT NULL
      AND COALESCE(
        me.departure_time, me.arrival_time,
        me.created_at
      ) >= ? THEN
        (
          (
            me.loaded_weight - me.empty_weight
          ) * mel.quantity / NULLIF(
            (
              SELECT
                SUM(mel2.quantity)
              FROM
                material_entry_line mel2
              WHERE
                mel2.material_entry_id = me.id
                AND mel2.type = ?
            ),
            0
          )
        ) - (
          mel.quantity * COALESCE(b.weight, 0)
        )
      ELSE
        0
      END
    ),
    0
  ) as net_weight,
  COALESCE(
    SUM(
      CASE WHEN COALESCE(
        me.departure_time, me.arrival_time,
        me.created_at
      ) >= ? THEN
        mel.quantity
      ELSE
        0
      END
    ),
    0
  ) as total_boxes
FROM
  material_type mt_parent
  LEFT JOIN material_type mt_child ON mt_child.parent_id = mt_parent.id
  LEFT JOIN material_entry_line mel ON (
    mel.material_type_id = mt_parent.id
    OR mel.material_type_id = mt_child.id
  )
  AND mel.type = ?
  LEFT JOIN box b ON mel.box_id = b.id
  LEFT JOIN material_entry me ON mel.material_entry_id = me.id
  AND me.status IN (?, ?)
WHERE
  mt_parent.parent_id IS NULL
  AND mt_parent.active = 1
GROUP BY
  mt_parent.id,
  mt_parent.name
ORDER BY
  net_weight DESC

SELECT
                mt_parent.id as category_id,
                mt_parent.name as category_name,
                COALESCE(SUM(
                    CASE
                        WHEN me.loaded_weight IS NOT NULL AND me.empty_weight IS NOT NULL
                             AND COALESCE(me.departure_time, me.arrival_time, me.created_at) >= '2026-04-01'
                        THEN (
                            (me.loaded_weight - me.empty_weight) * mel.quantity /
                            NULLIF((SELECT SUM(mel2.quantity) FROM material_entry_line mel2 WHERE mel2.material_entry_id = me.id AND mel2.type = 'actual'), 0)
                        ) - (mel.quantity * COALESCE(b.weight, 0))
                        ELSE 0
                    END
                ), 0) as net_weight,
                COALESCE(SUM(
                    CASE
                        WHEN COALESCE(me.departure_time, me.arrival_time, me.created_at) >= '2026-04-01'
                        THEN mel.quantity
                        ELSE 0
                    END
                ), 0) as total_boxes
            FROM material_type mt_parent
            LEFT JOIN material_type mt_child ON mt_child.parent_id = mt_parent.id
            LEFT JOIN material_entry_line mel ON (mel.material_type_id = mt_parent.id OR mel.material_type_id = mt_child.id)
                AND mel.type = 'actual'
            LEFT JOIN box b ON mel.box_id = b.id
            LEFT JOIN material_entry me ON mel.material_entry_id = me.id
                AND me.status IN ('departed', 'closed')
            WHERE mt_parent.parent_id IS NULL
              AND mt_parent.active = 1
            GROUP BY mt_parent.id, mt_parent.name
            ORDER BY net_weight DESC
        ;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.material_category AS material_category_4,
  t0.legacy_material_type AS legacy_material_type_5,
  t0.packaging_type AS packaging_type_6,
  t0.material_entry_id AS material_entry_id_7,
  t0.material_type_id AS material_type_id_8,
  t0.box_id AS box_id_9,
  t0.box_category_id AS box_category_id_10
FROM
  material_entry_line t0
WHERE
  t0.material_entry_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = 102;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = 4949;

SELECT
  m0_.id AS id_0,
  m0_.truck_plate AS truck_plate_1,
  m0_.status AS status_2,
  m0_.comment AS comment_3,
  m0_.scheduled_date AS scheduled_date_4,
  m0_.arrival_time AS arrival_time_5,
  m0_.departure_time AS departure_time_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.validated_at AS validated_at_9,
  m0_.estimated_box_count AS estimated_box_count_10,
  m0_.estimated_weight AS estimated_weight_11,
  m0_.loaded_weight AS loaded_weight_12,
  m0_.empty_weight AS empty_weight_13,
  m0_.stock_movement AS stock_movement_14,
  m0_.is_delivered AS is_delivered_15,
  m0_.transport_cost AS transport_cost_16,
  m0_.supplier_id AS supplier_id_17,
  m0_.carrier_id AS carrier_id_18,
  m0_.forklift_operator_id AS forklift_operator_id_19
FROM
  material_entry m0_
WHERE
  m0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.truck_plate AS truck_plate_1, m0_.status AS status_2, m0_.comment AS comment_3, m0_.scheduled_date AS scheduled_date_4, m0_.arrival_time AS arrival_time_5, m0_.departure_time AS departure_time_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.validated_at AS validated_at_9, m0_.estimated_box_count AS estimated_box_count_10, m0_.estimated_weight AS estimated_weight_11, m0_.loaded_weight AS loaded_weight_12, m0_.empty_weight AS empty_weight_13, m0_.stock_movement AS stock_movement_14, m0_.is_delivered AS is_delivered_15, m0_.transport_cost AS transport_cost_16, m0_.supplier_id AS supplier_id_17, m0_.carrier_id AS carrier_id_18, m0_.forklift_operator_id AS forklift_operator_id_19 FROM material_entry m0_ WHERE m0_.id IN (102, 101, 100, 99, 98, 97, 95, 94, 93, 92, 89, 88, 87, 86, 85, 83, 82, 81, 80, 79) ORDER BY m0_.created_at DESC;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.created_at AS created_at_1
FROM
  material_entry m0_
ORDER BY
  m0_.created_at DESC
LIMIT
  20

SELECT DISTINCT m0_.id AS id_0, m0_.created_at AS created_at_1 FROM material_entry m0_ ORDER BY m0_.created_at DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.locale AS locale_7,
  t0.favorite_apps AS favorite_apps_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = 16;

SELECT
  count(*) AS sclr_0
FROM
  material_entry m0_

SELECT count(*) AS sclr_0 FROM material_entry m0_;