Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT e0_.id AS id_0, e0_.label AS label_1, e0_.description AS description_2, e0_.amount AS amount_3, e0_.expense_date AS expense_date_4, e0_.category AS category_5, e0_.provider AS provider_6, e0_.invoice_number AS invoice_number_7, e0_.payment_method AS payment_method_8, e0_.receipt_number AS receipt_number_9, e0_.notes AS notes_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.validated_at AS validated_at_13, e0_.status AS status_14, p1_.id AS id_15, p1_.code AS code_16, p1_.type AS type_17, p1_.is_investment_project AS is_investment_project_18, p1_.planned_budget AS planned_budget_19, p1_.realized_budget AS realized_budget_20, p1_.status AS status_21, p1_.planned_start_date AS planned_start_date_22, p1_.planned_end_date AS planned_end_date_23, p1_.actual_start_date AS actual_start_date_24, p1_.actual_end_date AS actual_end_date_25, p1_.created_at AS created_at_26, p1_.market_type AS market_type_27, p1_.is_deleted AS is_deleted_28, p1_.title AS title_29, p1_.phase AS phase_30, p1_.description AS description_31, p1_.is_sub_project AS is_sub_project_32, a2_.id AS id_33, a2_.label AS label_34, a2_.accronym AS accronym_35, a2_.type AS type_36, a2_.is_deleted AS is_deleted_37, e0_.project_step_id AS project_step_id_38, e0_.project_id AS project_id_39, e0_.created_by_id AS created_by_id_40, e0_.validated_by_id AS validated_by_id_41, p1_.currency_id AS currency_id_42, p1_.site_id AS site_id_43, p1_.objective_id AS objective_id_44, p1_.administrative_unit_id AS administrative_unit_id_45, p1_.budget_item_id AS budget_item_id_46, p1_.main_project_id AS main_project_id_47 FROM expense e0_ LEFT JOIN project p1_ ON e0_.project_id = p1_.id LEFT JOIN administrative_unit a2_ ON p1_.administrative_unit_id = a2_.id WHERE e0_.status = ?

[
  "VALIDATED"
]

SELECT
  e0_.id AS id_0,
  e0_.label AS label_1,
  e0_.description AS description_2,
  e0_.amount AS amount_3,
  e0_.expense_date AS expense_date_4,
  e0_.category AS category_5,
  e0_.provider AS provider_6,
  e0_.invoice_number AS invoice_number_7,
  e0_.payment_method AS payment_method_8,
  e0_.receipt_number AS receipt_number_9,
  e0_.notes AS notes_10,
  e0_.created_at AS created_at_11,
  e0_.updated_at AS updated_at_12,
  e0_.validated_at AS validated_at_13,
  e0_.status AS status_14,
  p1_.id AS id_15,
  p1_.code AS code_16,
  p1_.type AS type_17,
  p1_.is_investment_project AS is_investment_project_18,
  p1_.planned_budget AS planned_budget_19,
  p1_.realized_budget AS realized_budget_20,
  p1_.status AS status_21,
  p1_.planned_start_date AS planned_start_date_22,
  p1_.planned_end_date AS planned_end_date_23,
  p1_.actual_start_date AS actual_start_date_24,
  p1_.actual_end_date AS actual_end_date_25,
  p1_.created_at AS created_at_26,
  p1_.market_type AS market_type_27,
  p1_.is_deleted AS is_deleted_28,
  p1_.title AS title_29,
  p1_.phase AS phase_30,
  p1_.description AS description_31,
  p1_.is_sub_project AS is_sub_project_32,
  a2_.id AS id_33,
  a2_.label AS label_34,
  a2_.accronym AS accronym_35,
  a2_.type AS type_36,
  a2_.is_deleted AS is_deleted_37,
  e0_.project_step_id AS project_step_id_38,
  e0_.project_id AS project_id_39,
  e0_.created_by_id AS created_by_id_40,
  e0_.validated_by_id AS validated_by_id_41,
  p1_.currency_id AS currency_id_42,
  p1_.site_id AS site_id_43,
  p1_.objective_id AS objective_id_44,
  p1_.administrative_unit_id AS administrative_unit_id_45,
  p1_.budget_item_id AS budget_item_id_46,
  p1_.main_project_id AS main_project_id_47
FROM
  expense e0_
  LEFT JOIN project p1_ ON e0_.project_id = p1_.id
  LEFT JOIN administrative_unit a2_ ON p1_.administrative_unit_id = a2_.id
WHERE
  e0_.status = ?

SELECT e0_.id AS id_0, e0_.label AS label_1, e0_.description AS description_2, e0_.amount AS amount_3, e0_.expense_date AS expense_date_4, e0_.category AS category_5, e0_.provider AS provider_6, e0_.invoice_number AS invoice_number_7, e0_.payment_method AS payment_method_8, e0_.receipt_number AS receipt_number_9, e0_.notes AS notes_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.validated_at AS validated_at_13, e0_.status AS status_14, p1_.id AS id_15, p1_.code AS code_16, p1_.type AS type_17, p1_.is_investment_project AS is_investment_project_18, p1_.planned_budget AS planned_budget_19, p1_.realized_budget AS realized_budget_20, p1_.status AS status_21, p1_.planned_start_date AS planned_start_date_22, p1_.planned_end_date AS planned_end_date_23, p1_.actual_start_date AS actual_start_date_24, p1_.actual_end_date AS actual_end_date_25, p1_.created_at AS created_at_26, p1_.market_type AS market_type_27, p1_.is_deleted AS is_deleted_28, p1_.title AS title_29, p1_.phase AS phase_30, p1_.description AS description_31, p1_.is_sub_project AS is_sub_project_32, a2_.id AS id_33, a2_.label AS label_34, a2_.accronym AS accronym_35, a2_.type AS type_36, a2_.is_deleted AS is_deleted_37, e0_.project_step_id AS project_step_id_38, e0_.project_id AS project_id_39, e0_.created_by_id AS created_by_id_40, e0_.validated_by_id AS validated_by_id_41, p1_.currency_id AS currency_id_42, p1_.site_id AS site_id_43, p1_.objective_id AS objective_id_44, p1_.administrative_unit_id AS administrative_unit_id_45, p1_.budget_item_id AS budget_item_id_46, p1_.main_project_id AS main_project_id_47 FROM expense e0_ LEFT JOIN project p1_ ON e0_.project_id = p1_.id LEFT JOIN administrative_unit a2_ ON p1_.administrative_unit_id = a2_.id WHERE e0_.status = 'VALIDATED';