Symfony Profiler

SELECT
  p0_.administrative_comment AS administrative_comment_0,
  p0_.area AS area_1,
  p0_.area_planted AS area_planted_2,
  p0_.biodiversity_bonus AS biodiversity_bonus_3,
  p0_.bounding AS bounding_4,
  p0_.certifications AS certifications_5,
  p0_.contract_status AS contract_status_6,
  p0_.description AS description_7,
  p0_.description_co_benefits AS description_co_benefits_8,
  p0_.description_current AS description_current_9,
  p0_.description_ecology AS description_ecology_10,
  p0_.description_forestry AS description_forestry_11,
  p0_.description_funding AS description_funding_12,
  p0_.finished AS finished_13,
  p0_.funding_status AS funding_status_14,
  p0_.funding AS funding_15,
  p0_.location AS location_16,
  p0_.name AS name_17,
  p0_.name_id AS name_id_18,
  p0_.operation_state AS operation_state_19,
  p0_.operation_start_planned AS operation_start_planned_20,
  p0_.operation_start_real AS operation_start_real_21,
  p0_.plantation_end AS plantation_end_22,
  p0_.planned_carbon_sequestration AS planned_carbon_sequestration_23,
  p0_.planned_operations AS planned_operations_24,
  p0_.planted_species AS planted_species_25,
  p0_.price_mini AS price_mini_26,
  p0_.price_suggested AS price_suggested_27,
  p0_.publishable AS publishable_28,
  p0_.recomputed_carbon_sequestration AS recomputed_carbon_sequestration_29,
  p0_.report_slug AS report_slug_30,
  p0_.stock_of_carbon AS stock_of_carbon_31,
  p0_.stock_of_carbon_taken AS stock_of_carbon_taken_32,
  p0_.stock_of_planted_trees AS stock_of_planted_trees_33,
  p0_.stock_of_planted_trees_taken AS stock_of_planted_trees_taken_34,
  p0_.slug AS slug_35,
  p0_.status AS status_36,
  p0_.subtitle AS subtitle_37,
  p0_.unit_price_of_carbon AS unit_price_of_carbon_38,
  p0_.updated_at AS updated_at_39,
  p0_.id AS id_40,
  p0_.property_created_at AS property_created_at_41,
  p0_.property_id AS property_id_42,
  p0_.property_name AS property_name_43,
  p0_.property_area_input AS property_area_input_44,
  p0_.property_area_geom AS property_area_geom_45,
  p0_.property_area_admin AS property_area_admin_46,
  p0_.property_locality_name AS property_locality_name_47,
  p0_.property_locality_national_code AS property_locality_national_code_48,
  p0_.lbc_decision_date AS lbc_decision_date_49,
  p0_.lbc_expected_decision_date AS lbc_expected_decision_date_50,
  p0_.lbc_file_date AS lbc_file_date_51,
  p0_.lbc_file_identifier AS lbc_file_identifier_52,
  p0_.lbc_method AS lbc_method_53,
  p0_.lbc_notification_date AS lbc_notification_date_54,
  p0_.lbc_status AS lbc_status_55,
  p0_.lbc_official_link AS lbc_official_link_56,
  p0_.assessment_id AS assessment_id_57,
  p0_.forester_id AS forester_id_58,
  p0_.forester_owner_id AS forester_owner_id_59
FROM
  project p0_
WHERE
  p0_.lbc_status = ?
  AND p0_.status <> ?
ORDER BY
  p0_.name_id ASC

SELECT p0_.administrative_comment AS administrative_comment_0, p0_.area AS area_1, p0_.area_planted AS area_planted_2, p0_.biodiversity_bonus AS biodiversity_bonus_3, p0_.bounding AS bounding_4, p0_.certifications AS certifications_5, p0_.contract_status AS contract_status_6, p0_.description AS description_7, p0_.description_co_benefits AS description_co_benefits_8, p0_.description_current AS description_current_9, p0_.description_ecology AS description_ecology_10, p0_.description_forestry AS description_forestry_11, p0_.description_funding AS description_funding_12, p0_.finished AS finished_13, p0_.funding_status AS funding_status_14, p0_.funding AS funding_15, p0_.location AS location_16, p0_.name AS name_17, p0_.name_id AS name_id_18, p0_.operation_state AS operation_state_19, p0_.operation_start_planned AS operation_start_planned_20, p0_.operation_start_real AS operation_start_real_21, p0_.plantation_end AS plantation_end_22, p0_.planned_carbon_sequestration AS planned_carbon_sequestration_23, p0_.planned_operations AS planned_operations_24, p0_.planted_species AS planted_species_25, p0_.price_mini AS price_mini_26, p0_.price_suggested AS price_suggested_27, p0_.publishable AS publishable_28, p0_.recomputed_carbon_sequestration AS recomputed_carbon_sequestration_29, p0_.report_slug AS report_slug_30, p0_.stock_of_carbon AS stock_of_carbon_31, p0_.stock_of_carbon_taken AS stock_of_carbon_taken_32, p0_.stock_of_planted_trees AS stock_of_planted_trees_33, p0_.stock_of_planted_trees_taken AS stock_of_planted_trees_taken_34, p0_.slug AS slug_35, p0_.status AS status_36, p0_.subtitle AS subtitle_37, p0_.unit_price_of_carbon AS unit_price_of_carbon_38, p0_.updated_at AS updated_at_39, p0_.id AS id_40, p0_.property_created_at AS property_created_at_41, p0_.property_id AS property_id_42, p0_.property_name AS property_name_43, p0_.property_area_input AS property_area_input_44, p0_.property_area_geom AS property_area_geom_45, p0_.property_area_admin AS property_area_admin_46, p0_.property_locality_name AS property_locality_name_47, p0_.property_locality_national_code AS property_locality_national_code_48, p0_.lbc_decision_date AS lbc_decision_date_49, p0_.lbc_expected_decision_date AS lbc_expected_decision_date_50, p0_.lbc_file_date AS lbc_file_date_51, p0_.lbc_file_identifier AS lbc_file_identifier_52, p0_.lbc_method AS lbc_method_53, p0_.lbc_notification_date AS lbc_notification_date_54, p0_.lbc_status AS lbc_status_55, p0_.lbc_official_link AS lbc_official_link_56, p0_.assessment_id AS assessment_id_57, p0_.forester_id AS forester_id_58, p0_.forester_owner_id AS forester_owner_id_59 FROM project p0_ WHERE p0_.lbc_status = 'lbc_status_validated' AND p0_.status <> 'project_status_canceled' ORDER BY p0_.name_id ASC;

SELECT
  f0_.broker_customer AS broker_customer_0,
  f0_.expires_at AS expires_at_1,
  f0_.ordered_at AS ordered_at_2,
  f0_.proposal_state AS proposal_state_3,
  f0_.sent_at AS sent_at_4,
  f0_.slug AS slug_5,
  f0_.created_at AS created_at_6,
  f0_.updated_at AS updated_at_7,
  f0_.id AS id_8,
  f0_.options_hide_mean_price AS options_hide_mean_price_9,
  f0_.options_with_biodiversity_bonus AS options_with_biodiversity_bonus_10,
  f0_.options_with_warranty AS options_with_warranty_11,
  f0_.funder_id AS funder_id_12
FROM
  funding_proposal f0_
WHERE
  f0_.proposal_state IN (?)
ORDER BY
  f0_.updated_at ASC

SELECT f0_.broker_customer AS broker_customer_0, f0_.expires_at AS expires_at_1, f0_.ordered_at AS ordered_at_2, f0_.proposal_state AS proposal_state_3, f0_.sent_at AS sent_at_4, f0_.slug AS slug_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.id AS id_8, f0_.options_hide_mean_price AS options_hide_mean_price_9, f0_.options_with_biodiversity_bonus AS options_with_biodiversity_bonus_10, f0_.options_with_warranty AS options_with_warranty_11, f0_.funder_id AS funder_id_12 FROM funding_proposal f0_ WHERE f0_.proposal_state IN ('proposal_ordered') ORDER BY f0_.updated_at ASC;

SELECT
  COUNT(p0_.id) AS sclr_0,
  SUM(p0_.stock_of_carbon) AS sclr_1,
  SUM(
    ROUND(p0_.area / 10000, 2)
  ) AS sclr_2,
  YEAR(p0_.lbc_decision_date) AS sclr_3,
  MONTH(p0_.lbc_decision_date) AS sclr_4
FROM
  project p0_
WHERE
  p0_.lbc_status = ?
  AND p0_.lbc_decision_date > ?
  AND p0_.lbc_decision_date IS NOT NULL
  AND p0_.status <> ?
GROUP BY
  sclr_3,
  sclr_4
ORDER BY
  MIN(p0_.lbc_decision_date) ASC

SELECT COUNT(p0_.id) AS sclr_0, SUM(p0_.stock_of_carbon) AS sclr_1, SUM(ROUND(p0_.area / 10000, 2)) AS sclr_2, YEAR(p0_.lbc_decision_date) AS sclr_3, MONTH(p0_.lbc_decision_date) AS sclr_4 FROM project p0_ WHERE p0_.lbc_status = 'lbc_status_validated' AND p0_.lbc_decision_date > '2022-12-10' AND p0_.lbc_decision_date IS NOT NULL AND p0_.status <> 'project_status_canceled' GROUP BY sclr_3, sclr_4 ORDER BY MIN(p0_.lbc_decision_date) ASC;