Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.createdAt AS createdAt_1,
  t0_.updatedAt AS updatedAt_2,
  t0_.name AS name_3,
  t0_.dateFrom AS dateFrom_4,
  t0_.dateTo AS dateTo_5,
  t0_.status AS status_6,
  t0_.closedAt AS closedAt_7,
  t0_.isRecurrentGenerated AS isRecurrentGenerated_8,
  t0_.isOneShotGenerated AS isOneShotGenerated_9,
  t0_.isCustomerDiversGenerated AS isCustomerDiversGenerated_10,
  t0_.closedBy_id AS closedBy_id_11
FROM
  tbl_invoicing_campaign t0_
WHERE
  t0_.status = ?
  OR (
    t0_.dateFrom >= ?
    AND t0_.status = ?
  )

SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.name AS name_3, t0_.dateFrom AS dateFrom_4, t0_.dateTo AS dateTo_5, t0_.status AS status_6, t0_.closedAt AS closedAt_7, t0_.isRecurrentGenerated AS isRecurrentGenerated_8, t0_.isOneShotGenerated AS isOneShotGenerated_9, t0_.isCustomerDiversGenerated AS isCustomerDiversGenerated_10, t0_.closedBy_id AS closedBy_id_11 FROM tbl_invoicing_campaign t0_ WHERE t0_.status = 'open' OR (t0_.dateFrom >= '2025-07-01 02:00:00' AND t0_.status = 'close');

SELECT
  t0_.id AS id_0,
  t0_.createdAt AS createdAt_1,
  t0_.updatedAt AS updatedAt_2,
  t0_.name AS name_3,
  t0_.dateFrom AS dateFrom_4,
  t0_.dateTo AS dateTo_5,
  t0_.status AS status_6,
  t0_.closedAt AS closedAt_7,
  t0_.isRecurrentGenerated AS isRecurrentGenerated_8,
  t0_.isOneShotGenerated AS isOneShotGenerated_9,
  t0_.isCustomerDiversGenerated AS isCustomerDiversGenerated_10,
  t0_.closedBy_id AS closedBy_id_11
FROM
  tbl_invoicing_campaign t0_
WHERE
  t0_.status = ?
ORDER BY
  t0_.dateTo DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.name AS name_3, t0_.dateFrom AS dateFrom_4, t0_.dateTo AS dateTo_5, t0_.status AS status_6, t0_.closedAt AS closedAt_7, t0_.isRecurrentGenerated AS isRecurrentGenerated_8, t0_.isOneShotGenerated AS isOneShotGenerated_9, t0_.isCustomerDiversGenerated AS isCustomerDiversGenerated_10, t0_.closedBy_id AS closedBy_id_11 FROM tbl_invoicing_campaign t0_ WHERE t0_.status = 'close' ORDER BY t0_.dateTo DESC LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.id AS id_2,
  t2_.id AS id_3,
  t2_.reference AS reference_4,
  t3_.id AS id_5,
  t4_.id AS id_6,
  t5_.id AS id_7,
  t6_.id AS id_8,
  SUM(t7_.quantity * t7_.unitPrice) AS sclr_9,
  SUM(t7_.quantity) AS sclr_10,
  t7_.codeArticle AS codeArticle_11,
  t8_.id AS id_12,
  t8_.isRecurrent AS isRecurrent_13,
  t8_.isOneShot AS isOneShot_14,
  t8_.isCustom AS isCustom_15,
  t9_.id AS id_16,
  t9_.isRecurrent AS isRecurrent_17,
  t9_.isOneShot AS isOneShot_18,
  t9_.isCustom AS isCustom_19,
  SUM(t10_.nbMeal) AS sclr_20,
  SUM(t11_.nbMeal) AS sclr_21,
  t12_.id AS id_22,
  t7_.dateDelivery AS dateDelivery_23,
  t13_.id AS id_24,
  t13_.status AS status_25,
  t13_.dateTo AS dateTo_26
FROM
  tbl_invoicing_sale_journal t7_
  LEFT JOIN tbl_invoicing_campaign t13_ ON t7_.invoicingCampaign_id = t13_.id
  LEFT JOIN tbl_production_extra t10_ ON t7_.productionExtra_id = t10_.id
  LEFT JOIN tbl_customer t2_ ON t7_.customer_id = t2_.id
  LEFT JOIN tbl_customer_typology t3_ ON t2_.typology_id = t3_.id
  LEFT JOIN tbl_customer_category t4_ ON t2_.category_id = t4_.id
  LEFT JOIN tbl_helper_pillar t5_ ON t2_.pillar_id = t5_.id
  LEFT JOIN tbl_helper_sub_pillar t6_ ON t2_.subPillar_id = t6_.id
  LEFT JOIN tbl_site t0_ ON t7_.site_id = t0_.id
  LEFT JOIN tbl_site_typology t1_ ON t0_.typology_id = t1_.id
  LEFT JOIN tbl_production_journal t14_ ON t7_.productionJournal_id = t14_.id
  LEFT JOIN tbl_production_grid t15_ ON t14_.productionGrid_id = t15_.id
  LEFT JOIN tbl_helper_guest_type t12_ ON t15_.guestType_id = t12_.id
  LEFT JOIN tbl_invoice_grid_contract t16_ ON t7_.invoiceGrid_id = t16_.id
  LEFT JOIN tbl_invoice_grid_type t8_ ON t16_.invoiceGridType_id = t8_.id
  LEFT JOIN tbl_invoice_grid_generic t17_ ON t7_.invoiceGridGeneric_id = t17_.id
  LEFT JOIN tbl_invoice_grid_type t9_ ON t17_.invoiceGridType_id = t9_.id
  LEFT JOIN tbl_order_form_item t11_ ON t7_.orderFormItem_id = t11_.id
WHERE
  (
    t13_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    OR t13_.id IS NULL
  )
  AND t7_.codeArticle NOT IN (?, ?)
GROUP BY
  t13_.id,
  t2_.id,
  t0_.id,
  t16_.id,
  t17_.id,
  t7_.nameItem,
  t7_.unitPrice

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.id AS id_2, t2_.id AS id_3, t2_.reference AS reference_4, t3_.id AS id_5, t4_.id AS id_6, t5_.id AS id_7, t6_.id AS id_8, SUM(t7_.quantity * t7_.unitPrice) AS sclr_9, SUM(t7_.quantity) AS sclr_10, t7_.codeArticle AS codeArticle_11, t8_.id AS id_12, t8_.isRecurrent AS isRecurrent_13, t8_.isOneShot AS isOneShot_14, t8_.isCustom AS isCustom_15, t9_.id AS id_16, t9_.isRecurrent AS isRecurrent_17, t9_.isOneShot AS isOneShot_18, t9_.isCustom AS isCustom_19, SUM(t10_.nbMeal) AS sclr_20, SUM(t11_.nbMeal) AS sclr_21, t12_.id AS id_22, t7_.dateDelivery AS dateDelivery_23, t13_.id AS id_24, t13_.status AS status_25, t13_.dateTo AS dateTo_26 FROM tbl_invoicing_sale_journal t7_ LEFT JOIN tbl_invoicing_campaign t13_ ON t7_.invoicingCampaign_id = t13_.id LEFT JOIN tbl_production_extra t10_ ON t7_.productionExtra_id = t10_.id LEFT JOIN tbl_customer t2_ ON t7_.customer_id = t2_.id LEFT JOIN tbl_customer_typology t3_ ON t2_.typology_id = t3_.id LEFT JOIN tbl_customer_category t4_ ON t2_.category_id = t4_.id LEFT JOIN tbl_helper_pillar t5_ ON t2_.pillar_id = t5_.id LEFT JOIN tbl_helper_sub_pillar t6_ ON t2_.subPillar_id = t6_.id LEFT JOIN tbl_site t0_ ON t7_.site_id = t0_.id LEFT JOIN tbl_site_typology t1_ ON t0_.typology_id = t1_.id LEFT JOIN tbl_production_journal t14_ ON t7_.productionJournal_id = t14_.id LEFT JOIN tbl_production_grid t15_ ON t14_.productionGrid_id = t15_.id LEFT JOIN tbl_helper_guest_type t12_ ON t15_.guestType_id = t12_.id LEFT JOIN tbl_invoice_grid_contract t16_ ON t7_.invoiceGrid_id = t16_.id LEFT JOIN tbl_invoice_grid_type t8_ ON t16_.invoiceGridType_id = t8_.id LEFT JOIN tbl_invoice_grid_generic t17_ ON t7_.invoiceGridGeneric_id = t17_.id LEFT JOIN tbl_invoice_grid_type t9_ ON t17_.invoiceGridType_id = t9_.id LEFT JOIN tbl_order_form_item t11_ ON t7_.orderFormItem_id = t11_.id WHERE (t13_.id IN (142, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151) OR t13_.id IS NULL) AND t7_.codeArticle NOT IN ('.COM', 'ST') GROUP BY t13_.id, t2_.id, t0_.id, t16_.id, t17_.id, t7_.nameItem, t7_.unitPrice;

SELECT
  t0_.id AS id_0,
  t1_.id AS id_1,
  COUNT(DISTINCT t1_.id) AS sclr_2
FROM
  tbl_customer t0_
  LEFT JOIN tbl_site_customer t2_ ON t0_.id = t2_.customer_id
  LEFT JOIN tbl_site t1_ ON t1_.id = t2_.site_id
WHERE
  t1_.isActive = 1
GROUP BY
  t0_.id
ORDER BY
  sclr_2 ASC

SELECT t0_.id AS id_0, t1_.id AS id_1, COUNT(DISTINCT t1_.id) AS sclr_2 FROM tbl_customer t0_ LEFT JOIN tbl_site_customer t2_ ON t0_.id = t2_.customer_id LEFT JOIN tbl_site t1_ ON t1_.id = t2_.site_id WHERE t1_.isActive = 1 GROUP BY t0_.id ORDER BY sclr_2 ASC;

SELECT
  t0_.id AS id_0,
  t0_.isActive AS isActive_1,
  t0_.reference AS reference_2,
  t0_.reference AS reference_3,
  t0_.name AS name_4,
  t0_.zipCode AS zipCode_5,
  t1_.id AS id_6,
  t2_.id AS id_7,
  t3_.id AS id_8
FROM
  tbl_site t0_
  LEFT JOIN tbl_site_typology t1_ ON t0_.typology_id = t1_.id
  LEFT JOIN tbl_site_activity t3_ ON t0_.activity_id = t3_.id
  LEFT JOIN tbl_region_production t2_ ON t0_.region_id = t2_.id

SELECT t0_.id AS id_0, t0_.isActive AS isActive_1, t0_.reference AS reference_2, t0_.reference AS reference_3, t0_.name AS name_4, t0_.zipCode AS zipCode_5, t1_.id AS id_6, t2_.id AS id_7, t3_.id AS id_8 FROM tbl_site t0_ LEFT JOIN tbl_site_typology t1_ ON t0_.typology_id = t1_.id LEFT JOIN tbl_site_activity t3_ ON t0_.activity_id = t3_.id LEFT JOIN tbl_region_production t2_ ON t0_.region_id = t2_.id;