Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.priority AS priority_5,
  t0.estimated_cost AS estimated_cost_6,
  t0.actual_cost AS actual_cost_7,
  t0.estimated_duration AS estimated_duration_8,
  t0.actual_duration AS actual_duration_9,
  t0.labor_hours AS labor_hours_10,
  t0.start_date AS start_date_11,
  t0.end_date AS end_date_12,
  t0.labor_cost AS labor_cost_13,
  t0.notes AS notes_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.current_workflow_step AS current_workflow_step_17,
  t0.has_workflow AS has_workflow_18,
  t0.vehicle_id AS vehicle_id_19,
  t0.customer_id AS customer_id_20,
  t21.id AS id_22,
  t21.status AS status_23,
  t21.started_at AS started_at_24,
  t21.completed_at AS completed_at_25,
  t21.overall_comments AS overall_comments_26,
  t21.approved AS approved_27,
  t21.rejection_reason AS rejection_reason_28,
  t21.created_at AS created_at_29,
  t21.updated_at AS updated_at_30,
  t21.repair_id AS repair_id_31,
  t21.inspector_id AS inspector_id_32,
  t0.diagnostic_id AS diagnostic_id_33,
  t0.mechanic_id AS mechanic_id_34,
  t0.customer_delivery_id AS customer_delivery_id_35
FROM
  repair t0
  LEFT JOIN quality_control t21 ON t21.repair_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.priority AS priority_5, t0.estimated_cost AS estimated_cost_6, t0.actual_cost AS actual_cost_7, t0.estimated_duration AS estimated_duration_8, t0.actual_duration AS actual_duration_9, t0.labor_hours AS labor_hours_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.labor_cost AS labor_cost_13, t0.notes AS notes_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.current_workflow_step AS current_workflow_step_17, t0.has_workflow AS has_workflow_18, t0.vehicle_id AS vehicle_id_19, t0.customer_id AS customer_id_20, t21.id AS id_22, t21.status AS status_23, t21.started_at AS started_at_24, t21.completed_at AS completed_at_25, t21.overall_comments AS overall_comments_26, t21.approved AS approved_27, t21.rejection_reason AS rejection_reason_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30, t21.repair_id AS repair_id_31, t21.inspector_id AS inspector_id_32, t0.diagnostic_id AS diagnostic_id_33, t0.mechanic_id AS mechanic_id_34, t0.customer_delivery_id AS customer_delivery_id_35 FROM repair t0 LEFT JOIN quality_control t21 ON t21.repair_id = t0.id WHERE t0.id = '7';

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.description AS description_2,
  r0_.status AS status_3,
  r0_.priority AS priority_4,
  r0_.estimated_cost AS estimated_cost_5,
  r0_.actual_cost AS actual_cost_6,
  r0_.estimated_duration AS estimated_duration_7,
  r0_.actual_duration AS actual_duration_8,
  r0_.labor_hours AS labor_hours_9,
  r0_.start_date AS start_date_10,
  r0_.end_date AS end_date_11,
  r0_.labor_cost AS labor_cost_12,
  r0_.notes AS notes_13,
  r0_.created_at AS created_at_14,
  r0_.updated_at AS updated_at_15,
  r0_.current_workflow_step AS current_workflow_step_16,
  r0_.has_workflow AS has_workflow_17,
  d1_.id AS id_18,
  d1_.title AS title_19,
  d1_.description AS description_20,
  d1_.diagnostic_type AS diagnostic_type_21,
  d1_.result AS result_22,
  d1_.estimated_repair_cost AS estimated_repair_cost_23,
  d1_.created_at AS created_at_24,
  d1_.updated_at AS updated_at_25,
  q2_.id AS id_26,
  q2_.status AS status_27,
  q2_.started_at AS started_at_28,
  q2_.completed_at AS completed_at_29,
  q2_.overall_comments AS overall_comments_30,
  q2_.approved AS approved_31,
  q2_.rejection_reason AS rejection_reason_32,
  q2_.created_at AS created_at_33,
  q2_.updated_at AS updated_at_34,
  c3_.id AS id_35,
  c3_.reference AS reference_36,
  c3_.status AS status_37,
  c3_.scheduled_delivery_date AS scheduled_delivery_date_38,
  c3_.actual_delivery_date AS actual_delivery_date_39,
  c3_.delivery_notes AS delivery_notes_40,
  c3_.customer_signature AS customer_signature_41,
  c3_.delivered_by AS delivered_by_42,
  c3_.vehicle_condition_notes AS vehicle_condition_notes_43,
  c3_.delivered_items AS delivered_items_44,
  c3_.km_at_delivery AS km_at_delivery_45,
  c3_.fuel_level AS fuel_level_46,
  c3_.created_at AS created_at_47,
  c3_.updated_at AS updated_at_48,
  w4_.id AS id_49,
  w4_.step_name AS step_name_50,
  w4_.step_order AS step_order_51,
  w4_.status AS status_52,
  w4_.started_at AS started_at_53,
  w4_.completed_at AS completed_at_54,
  w4_.notes AS notes_55,
  w4_.created_at AS created_at_56,
  w4_.updated_at AS updated_at_57,
  v5_.id AS id_58,
  v5_.brand AS brand_59,
  v5_.model AS model_60,
  v5_.year AS year_61,
  v5_.license_plate AS license_plate_62,
  v5_.registration_number AS registration_number_63,
  v5_.vin AS vin_64,
  v5_.mileage AS mileage_65,
  v5_.fuel_type AS fuel_type_66,
  v5_.color AS color_67,
  v5_.notes AS notes_68,
  v5_.created_at AS created_at_69,
  v5_.updated_at AS updated_at_70,
  c6_.id AS id_71,
  c6_.first_name AS first_name_72,
  c6_.last_name AS last_name_73,
  c6_.email AS email_74,
  c6_.phone AS phone_75,
  c6_.address AS address_76,
  c6_.city AS city_77,
  c6_.postal_code AS postal_code_78,
  c6_.nature AS nature_79,
  c6_.notes AS notes_80,
  c6_.created_at AS created_at_81,
  c6_.updated_at AS updated_at_82,
  m7_.id AS id_83,
  m7_.first_name AS first_name_84,
  m7_.last_name AS last_name_85,
  m7_.email AS email_86,
  m7_.phone AS phone_87,
  m7_.specialization AS specialization_88,
  m7_.hire_date AS hire_date_89,
  m7_.salary AS salary_90,
  m7_.notes AS notes_91,
  m7_.created_at AS created_at_92,
  m7_.updated_at AS updated_at_93,
  m8_.id AS id_94,
  m8_.first_name AS first_name_95,
  m8_.last_name AS last_name_96,
  m8_.email AS email_97,
  m8_.phone AS phone_98,
  m8_.specialization AS specialization_99,
  m8_.hire_date AS hire_date_100,
  m8_.salary AS salary_101,
  m8_.notes AS notes_102,
  m8_.created_at AS created_at_103,
  m8_.updated_at AS updated_at_104,
  r0_.vehicle_id AS vehicle_id_105,
  r0_.customer_id AS customer_id_106,
  r0_.diagnostic_id AS diagnostic_id_107,
  r0_.mechanic_id AS mechanic_id_108,
  r0_.customer_delivery_id AS customer_delivery_id_109,
  d1_.vehicle_id AS vehicle_id_110,
  d1_.customer_id AS customer_id_111,
  d1_.mechanic_id AS mechanic_id_112,
  q2_.repair_id AS repair_id_113,
  q2_.inspector_id AS inspector_id_114,
  c3_.repair_id AS repair_id_115,
  c3_.customer_id AS customer_id_116,
  c3_.vehicle_id AS vehicle_id_117,
  w4_.repair_id AS repair_id_118,
  w4_.assigned_to_id AS assigned_to_id_119,
  v5_.customer_id AS customer_id_120
FROM
  repair r0_
  LEFT JOIN diagnostic d1_ ON r0_.diagnostic_id = d1_.id
  LEFT JOIN quality_control q2_ ON r0_.id = q2_.repair_id
  LEFT JOIN customer_delivery c3_ ON r0_.customer_delivery_id = c3_.id
  LEFT JOIN workflow_step w4_ ON r0_.id = w4_.repair_id
  LEFT JOIN vehicle v5_ ON r0_.vehicle_id = v5_.id
  LEFT JOIN customer c6_ ON r0_.customer_id = c6_.id
  LEFT JOIN mechanic m7_ ON r0_.mechanic_id = m7_.id
  LEFT JOIN mechanic m8_ ON d1_.mechanic_id = m8_.id
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.status AS status_3, r0_.priority AS priority_4, r0_.estimated_cost AS estimated_cost_5, r0_.actual_cost AS actual_cost_6, r0_.estimated_duration AS estimated_duration_7, r0_.actual_duration AS actual_duration_8, r0_.labor_hours AS labor_hours_9, r0_.start_date AS start_date_10, r0_.end_date AS end_date_11, r0_.labor_cost AS labor_cost_12, r0_.notes AS notes_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.current_workflow_step AS current_workflow_step_16, r0_.has_workflow AS has_workflow_17, d1_.id AS id_18, d1_.title AS title_19, d1_.description AS description_20, d1_.diagnostic_type AS diagnostic_type_21, d1_.result AS result_22, d1_.estimated_repair_cost AS estimated_repair_cost_23, d1_.created_at AS created_at_24, d1_.updated_at AS updated_at_25, q2_.id AS id_26, q2_.status AS status_27, q2_.started_at AS started_at_28, q2_.completed_at AS completed_at_29, q2_.overall_comments AS overall_comments_30, q2_.approved AS approved_31, q2_.rejection_reason AS rejection_reason_32, q2_.created_at AS created_at_33, q2_.updated_at AS updated_at_34, c3_.id AS id_35, c3_.reference AS reference_36, c3_.status AS status_37, c3_.scheduled_delivery_date AS scheduled_delivery_date_38, c3_.actual_delivery_date AS actual_delivery_date_39, c3_.delivery_notes AS delivery_notes_40, c3_.customer_signature AS customer_signature_41, c3_.delivered_by AS delivered_by_42, c3_.vehicle_condition_notes AS vehicle_condition_notes_43, c3_.delivered_items AS delivered_items_44, c3_.km_at_delivery AS km_at_delivery_45, c3_.fuel_level AS fuel_level_46, c3_.created_at AS created_at_47, c3_.updated_at AS updated_at_48, w4_.id AS id_49, w4_.step_name AS step_name_50, w4_.step_order AS step_order_51, w4_.status AS status_52, w4_.started_at AS started_at_53, w4_.completed_at AS completed_at_54, w4_.notes AS notes_55, w4_.created_at AS created_at_56, w4_.updated_at AS updated_at_57, v5_.id AS id_58, v5_.brand AS brand_59, v5_.model AS model_60, v5_.year AS year_61, v5_.license_plate AS license_plate_62, v5_.registration_number AS registration_number_63, v5_.vin AS vin_64, v5_.mileage AS mileage_65, v5_.fuel_type AS fuel_type_66, v5_.color AS color_67, v5_.notes AS notes_68, v5_.created_at AS created_at_69, v5_.updated_at AS updated_at_70, c6_.id AS id_71, c6_.first_name AS first_name_72, c6_.last_name AS last_name_73, c6_.email AS email_74, c6_.phone AS phone_75, c6_.address AS address_76, c6_.city AS city_77, c6_.postal_code AS postal_code_78, c6_.nature AS nature_79, c6_.notes AS notes_80, c6_.created_at AS created_at_81, c6_.updated_at AS updated_at_82, m7_.id AS id_83, m7_.first_name AS first_name_84, m7_.last_name AS last_name_85, m7_.email AS email_86, m7_.phone AS phone_87, m7_.specialization AS specialization_88, m7_.hire_date AS hire_date_89, m7_.salary AS salary_90, m7_.notes AS notes_91, m7_.created_at AS created_at_92, m7_.updated_at AS updated_at_93, m8_.id AS id_94, m8_.first_name AS first_name_95, m8_.last_name AS last_name_96, m8_.email AS email_97, m8_.phone AS phone_98, m8_.specialization AS specialization_99, m8_.hire_date AS hire_date_100, m8_.salary AS salary_101, m8_.notes AS notes_102, m8_.created_at AS created_at_103, m8_.updated_at AS updated_at_104, r0_.vehicle_id AS vehicle_id_105, r0_.customer_id AS customer_id_106, r0_.diagnostic_id AS diagnostic_id_107, r0_.mechanic_id AS mechanic_id_108, r0_.customer_delivery_id AS customer_delivery_id_109, d1_.vehicle_id AS vehicle_id_110, d1_.customer_id AS customer_id_111, d1_.mechanic_id AS mechanic_id_112, q2_.repair_id AS repair_id_113, q2_.inspector_id AS inspector_id_114, c3_.repair_id AS repair_id_115, c3_.customer_id AS customer_id_116, c3_.vehicle_id AS vehicle_id_117, w4_.repair_id AS repair_id_118, w4_.assigned_to_id AS assigned_to_id_119, v5_.customer_id AS customer_id_120 FROM repair r0_ LEFT JOIN diagnostic d1_ ON r0_.diagnostic_id = d1_.id LEFT JOIN quality_control q2_ ON r0_.id = q2_.repair_id LEFT JOIN customer_delivery c3_ ON r0_.customer_delivery_id = c3_.id LEFT JOIN workflow_step w4_ ON r0_.id = w4_.repair_id LEFT JOIN vehicle v5_ ON r0_.vehicle_id = v5_.id LEFT JOIN customer c6_ ON r0_.customer_id = c6_.id LEFT JOIN mechanic m7_ ON r0_.mechanic_id = m7_.id LEFT JOIN mechanic m8_ ON d1_.mechanic_id = m8_.id WHERE r0_.id = 7;

SELECT
  t0.id AS id_1,
  t0.garage AS garage_2,
  t0.currency AS currency_3,
  t0.date_format AS date_format_4,
  t0.time_format AS time_format_5,
  t0.notifications AS notifications_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.logo AS logo_9
FROM
  app_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quote_number AS quote_number_2,
  t0.status AS status_3,
  t0.issue_date AS issue_date_4,
  t0.valid_until AS valid_until_5,
  t0.total_amount AS total_amount_6,
  t0.notes AS notes_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.customer_id AS customer_id_10,
  t0.repair_id AS repair_id_11
FROM
  quote t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.quote_number AS quote_number_2, t0.status AS status_3, t0.issue_date AS issue_date_4, t0.valid_until AS valid_until_5, t0.total_amount AS total_amount_6, t0.notes AS notes_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.customer_id AS customer_id_10, t0.repair_id AS repair_id_11 FROM quote t0 WHERE t0.customer_id = 4;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.unit_price AS unit_price_3,
  t0.total_price AS total_price_4,
  t0.notes AS notes_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.repair_id AS repair_id_8,
  t0.article_id AS article_id_9
FROM
  repair_part t0
WHERE
  t0.repair_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price AS unit_price_3, t0.total_price AS total_price_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.repair_id AS repair_id_8, t0.article_id AS article_id_9 FROM repair_part t0 WHERE t0.repair_id = 7;

SELECT
  t0.id AS id_1,
  t0.test_name AS test_name_2,
  t0.test_type AS test_type_3,
  t0.passed AS passed_4,
  t0.comments AS comments_5,
  t0.expected_result AS expected_result_6,
  t0.actual_result AS actual_result_7,
  t0.performed_at AS performed_at_8,
  t0.quality_control_id AS quality_control_id_9,
  t0.related_issue_id AS related_issue_id_10
FROM
  quality_control_test t0
WHERE
  t0.quality_control_id = ?

SELECT t0.id AS id_1, t0.test_name AS test_name_2, t0.test_type AS test_type_3, t0.passed AS passed_4, t0.comments AS comments_5, t0.expected_result AS expected_result_6, t0.actual_result AS actual_result_7, t0.performed_at AS performed_at_8, t0.quality_control_id AS quality_control_id_9, t0.related_issue_id AS related_issue_id_10 FROM quality_control_test t0 WHERE t0.quality_control_id = 2;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.stage AS stage_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.repair_id AS repair_id_9
FROM
  repair_photo t0
WHERE
  t0.repair_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.stage AS stage_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.repair_id AS repair_id_9 FROM repair_photo t0 WHERE t0.repair_id = 7;