Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.type AS type_3,
  t0.is_investment_project AS is_investment_project_4,
  t0.planned_budget AS planned_budget_5,
  t0.realized_budget AS realized_budget_6,
  t0.status AS status_7,
  t0.planned_start_date AS planned_start_date_8,
  t0.planned_end_date AS planned_end_date_9,
  t0.actual_start_date AS actual_start_date_10,
  t0.actual_end_date AS actual_end_date_11,
  t0.created_at AS created_at_12,
  t0.market_type AS market_type_13,
  t0.is_deleted AS is_deleted_14,
  t0.title AS title_15,
  t0.phase AS phase_16,
  t0.description AS description_17,
  t0.is_sub_project AS is_sub_project_18,
  t0.currency_id AS currency_id_19,
  t0.site_id AS site_id_20,
  t0.objective_id AS objective_id_21,
  t0.administrative_unit_id AS administrative_unit_id_22,
  t0.budget_item_id AS budget_item_id_23,
  t0.main_project_id AS main_project_id_24
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.is_investment_project AS is_investment_project_4, t0.planned_budget AS planned_budget_5, t0.realized_budget AS realized_budget_6, t0.status AS status_7, t0.planned_start_date AS planned_start_date_8, t0.planned_end_date AS planned_end_date_9, t0.actual_start_date AS actual_start_date_10, t0.actual_end_date AS actual_end_date_11, t0.created_at AS created_at_12, t0.market_type AS market_type_13, t0.is_deleted AS is_deleted_14, t0.title AS title_15, t0.phase AS phase_16, t0.description AS description_17, t0.is_sub_project AS is_sub_project_18, t0.currency_id AS currency_id_19, t0.site_id AS site_id_20, t0.objective_id AS objective_id_21, t0.administrative_unit_id AS administrative_unit_id_22, t0.budget_item_id AS budget_item_id_23, t0.main_project_id AS main_project_id_24 FROM project t0 WHERE t0.id = '172';

SELECT
  p0_.id AS id_0,
  p0_.label AS label_1,
  p0_.description AS description_2,
  p0_.planned_budget AS planned_budget_3,
  p0_.executed_budget AS executed_budget_4,
  p0_.planned_start_date AS planned_start_date_5,
  p0_.planned_end_date AS planned_end_date_6,
  p0_.actual_start_date AS actual_start_date_7,
  p0_.actual_end_date AS actual_end_date_8,
  p0_.position AS position_9,
  p0_.status AS status_10,
  p0_.progress_percentage AS progress_percentage_11,
  p0_.notes AS notes_12,
  p0_.is_deleted AS is_deleted_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.project_id AS project_id_16
FROM
  project_steps p0_
WHERE
  p0_.project_id = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.description AS description_2, p0_.planned_budget AS planned_budget_3, p0_.executed_budget AS executed_budget_4, p0_.planned_start_date AS planned_start_date_5, p0_.planned_end_date AS planned_end_date_6, p0_.actual_start_date AS actual_start_date_7, p0_.actual_end_date AS actual_end_date_8, p0_.position AS position_9, p0_.status AS status_10, p0_.progress_percentage AS progress_percentage_11, p0_.notes AS notes_12, p0_.is_deleted AS is_deleted_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.project_id AS project_id_16 FROM project_steps p0_ WHERE p0_.project_id = 172 ORDER BY p0_.id ASC;

SELECT
  p0_.status AS status_0,
  COUNT(p0_.id) AS sclr_1
FROM
  project_steps p0_
WHERE
  p0_.project_id = ?
GROUP BY
  p0_.status

SELECT p0_.status AS status_0, COUNT(p0_.id) AS sclr_1 FROM project_steps p0_ WHERE p0_.project_id = 172 GROUP BY p0_.status;

SELECT
  SUM(p0_.planned_budget) AS sclr_0,
  SUM(p0_.executed_budget) AS sclr_1
FROM
  project_steps p0_
WHERE
  p0_.project_id = ?

SELECT SUM(p0_.planned_budget) AS sclr_0, SUM(p0_.executed_budget) AS sclr_1 FROM project_steps p0_ WHERE p0_.project_id = 172;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.type AS type_3,
  t0.is_investment_project AS is_investment_project_4,
  t0.planned_budget AS planned_budget_5,
  t0.realized_budget AS realized_budget_6,
  t0.status AS status_7,
  t0.planned_start_date AS planned_start_date_8,
  t0.planned_end_date AS planned_end_date_9,
  t0.actual_start_date AS actual_start_date_10,
  t0.actual_end_date AS actual_end_date_11,
  t0.created_at AS created_at_12,
  t0.market_type AS market_type_13,
  t0.is_deleted AS is_deleted_14,
  t0.title AS title_15,
  t0.phase AS phase_16,
  t0.description AS description_17,
  t0.is_sub_project AS is_sub_project_18,
  t0.currency_id AS currency_id_19,
  t0.site_id AS site_id_20,
  t0.objective_id AS objective_id_21,
  t0.administrative_unit_id AS administrative_unit_id_22,
  t0.budget_item_id AS budget_item_id_23,
  t0.main_project_id AS main_project_id_24
FROM
  project t0
WHERE
  t0.main_project_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.is_investment_project AS is_investment_project_4, t0.planned_budget AS planned_budget_5, t0.realized_budget AS realized_budget_6, t0.status AS status_7, t0.planned_start_date AS planned_start_date_8, t0.planned_end_date AS planned_end_date_9, t0.actual_start_date AS actual_start_date_10, t0.actual_end_date AS actual_end_date_11, t0.created_at AS created_at_12, t0.market_type AS market_type_13, t0.is_deleted AS is_deleted_14, t0.title AS title_15, t0.phase AS phase_16, t0.description AS description_17, t0.is_sub_project AS is_sub_project_18, t0.currency_id AS currency_id_19, t0.site_id AS site_id_20, t0.objective_id AS objective_id_21, t0.administrative_unit_id AS administrative_unit_id_22, t0.budget_item_id AS budget_item_id_23, t0.main_project_id AS main_project_id_24 FROM project t0 WHERE t0.main_project_id = 172;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.amount AS amount_4,
  t0.expense_date AS expense_date_5,
  t0.category AS category_6,
  t0.provider AS provider_7,
  t0.invoice_number AS invoice_number_8,
  t0.payment_method AS payment_method_9,
  t0.receipt_number AS receipt_number_10,
  t0.notes AS notes_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.validated_at AS validated_at_14,
  t0.status AS status_15,
  t0.project_step_id AS project_step_id_16,
  t0.project_id AS project_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.validated_by_id AS validated_by_id_19
FROM
  expense t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.amount AS amount_4, t0.expense_date AS expense_date_5, t0.category AS category_6, t0.provider AS provider_7, t0.invoice_number AS invoice_number_8, t0.payment_method AS payment_method_9, t0.receipt_number AS receipt_number_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.validated_at AS validated_at_14, t0.status AS status_15, t0.project_step_id AS project_step_id_16, t0.project_id AS project_id_17, t0.created_by_id AS created_by_id_18, t0.validated_by_id AS validated_by_id_19 FROM expense t0 WHERE t0.project_id = 172;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.planned_budget AS planned_budget_4,
  t0.executed_budget AS executed_budget_5,
  t0.planned_start_date AS planned_start_date_6,
  t0.planned_end_date AS planned_end_date_7,
  t0.actual_start_date AS actual_start_date_8,
  t0.actual_end_date AS actual_end_date_9,
  t0.position AS position_10,
  t0.status AS status_11,
  t0.progress_percentage AS progress_percentage_12,
  t0.notes AS notes_13,
  t0.is_deleted AS is_deleted_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.project_id AS project_id_17
FROM
  project_steps t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.planned_budget AS planned_budget_4, t0.executed_budget AS executed_budget_5, t0.planned_start_date AS planned_start_date_6, t0.planned_end_date AS planned_end_date_7, t0.actual_start_date AS actual_start_date_8, t0.actual_end_date AS actual_end_date_9, t0.position AS position_10, t0.status AS status_11, t0.progress_percentage AS progress_percentage_12, t0.notes AS notes_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.project_id AS project_id_17 FROM project_steps t0 WHERE t0.project_id = 172;