3.51 ms (28.42%)
3
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 = 5 ;
Copy
2.53 ms (20.52%)
3
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 = 3 ;
Copy
1.56 ms (12.66%)
1
SELECT t0 . id AS id_1 , t0 . status AS status_2 , t0 . started_at AS started_at_3 , t0 . completed_at AS completed_at_4 , t0 . overall_comments AS overall_comments_5 , t0 . approved AS approved_6 , t0 . rejection_reason AS rejection_reason_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . repair_id AS repair_id_10 , t0 . inspector_id AS inspector_id_11 FROM quality_control t0 ORDER BY t0 . created_at DESC
SELECT t0 . id AS id_1 , t0 . status AS status_2 , t0 . started_at AS started_at_3 , t0 . completed_at AS completed_at_4 , t0 . overall_comments AS overall_comments_5 , t0 . approved AS approved_6 , t0 . rejection_reason AS rejection_reason_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . repair_id AS repair_id_10 , t0 . inspector_id AS inspector_id_11 FROM quality_control t0 ORDER BY t0 . created_at DESC ;
Copy
0.62 ms (5.04%)
1
SELECT t0 . id AS id_1 , t0 . brand AS brand_2 , t0 . model AS model_3 , t0 . year AS year_4 , t0 . license_plate AS license_plate_5 , t0 . registration_number AS registration_number_6 , t0 . vin AS vin_7 , t0 . mileage AS mileage_8 , t0 . fuel_type AS fuel_type_9 , t0 . color AS color_10 , t0 . notes AS notes_11 , t0 . created_at AS created_at_12 , t0 . updated_at AS updated_at_13 , t0 . customer_id AS customer_id_14 FROM vehicle t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . brand AS brand_2 , t0 . model AS model_3 , t0 . year AS year_4 , t0 . license_plate AS license_plate_5 , t0 . registration_number AS registration_number_6 , t0 . vin AS vin_7 , t0 . mileage AS mileage_8 , t0 . fuel_type AS fuel_type_9 , t0 . color AS color_10 , t0 . notes AS notes_11 , t0 . created_at AS created_at_12 , t0 . updated_at AS updated_at_13 , t0 . customer_id AS customer_id_14 FROM vehicle t0 WHERE t0 . id = 3 ;
Copy
0.37 ms (3.00%)
1
SELECT t0 . id AS id_1 , t0 . first_name AS first_name_2 , t0 . last_name AS last_name_3 , t0 . email AS email_4 , t0 . phone AS phone_5 , t0 . address AS address_6 , t0 . city AS city_7 , t0 . postal_code AS postal_code_8 , t0 . nature AS nature_9 , t0 . notes AS notes_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 FROM customer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . first_name AS first_name_2 , t0 . last_name AS last_name_3 , t0 . email AS email_4 , t0 . phone AS phone_5 , t0 . address AS address_6 , t0 . city AS city_7 , t0 . postal_code AS postal_code_8 , t0 . nature AS nature_9 , t0 . notes AS notes_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 FROM customer t0 WHERE t0 . id = 4 ;
Copy