1
2.93 ms
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 WHERE t0 . id = ?
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 WHERE t0 . id = '1' ;
Copy
2
0.43 ms
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 ;
Copy
3
0.60 ms
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 = 6 ;
Copy
4
0.80 ms
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
5
2.56 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . diagnostic_type AS diagnostic_type_4 , t0 . result AS result_5 , t0 . estimated_repair_cost AS estimated_repair_cost_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . vehicle_id AS vehicle_id_9 , t0 . customer_id AS customer_id_10 , t0 . mechanic_id AS mechanic_id_11 , t12 . id AS id_13 , t12 . title AS title_14 , t12 . description AS description_15 , t12 . status AS status_16 , t12 . priority AS priority_17 , t12 . estimated_cost AS estimated_cost_18 , t12 . actual_cost AS actual_cost_19 , t12 . estimated_duration AS estimated_duration_20 , t12 . actual_duration AS actual_duration_21 , t12 . labor_hours AS labor_hours_22 , t12 . start_date AS start_date_23 , t12 . end_date AS end_date_24 , t12 . labor_cost AS labor_cost_25 , t12 . notes AS notes_26 , t12 . created_at AS created_at_27 , t12 . updated_at AS updated_at_28 , t12 . current_workflow_step AS current_workflow_step_29 , t12 . has_workflow AS has_workflow_30 , t12 . vehicle_id AS vehicle_id_31 , t12 . customer_id AS customer_id_32 , t12 . diagnostic_id AS diagnostic_id_33 , t12 . mechanic_id AS mechanic_id_34 , t12 . customer_delivery_id AS customer_delivery_id_35 FROM diagnostic t0 LEFT JOIN repair t12 ON t12 . diagnostic_id = t0 . id WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . diagnostic_type AS diagnostic_type_4 , t0 . result AS result_5 , t0 . estimated_repair_cost AS estimated_repair_cost_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . vehicle_id AS vehicle_id_9 , t0 . customer_id AS customer_id_10 , t0 . mechanic_id AS mechanic_id_11 , t12 . id AS id_13 , t12 . title AS title_14 , t12 . description AS description_15 , t12 . status AS status_16 , t12 . priority AS priority_17 , t12 . estimated_cost AS estimated_cost_18 , t12 . actual_cost AS actual_cost_19 , t12 . estimated_duration AS estimated_duration_20 , t12 . actual_duration AS actual_duration_21 , t12 . labor_hours AS labor_hours_22 , t12 . start_date AS start_date_23 , t12 . end_date AS end_date_24 , t12 . labor_cost AS labor_cost_25 , t12 . notes AS notes_26 , t12 . created_at AS created_at_27 , t12 . updated_at AS updated_at_28 , t12 . current_workflow_step AS current_workflow_step_29 , t12 . has_workflow AS has_workflow_30 , t12 . vehicle_id AS vehicle_id_31 , t12 . customer_id AS customer_id_32 , t12 . diagnostic_id AS diagnostic_id_33 , t12 . mechanic_id AS mechanic_id_34 , t12 . customer_delivery_id AS customer_delivery_id_35 FROM diagnostic t0 LEFT JOIN repair t12 ON t12 . diagnostic_id = t0 . id WHERE t0 . id = 4 ;
Copy
6
0.52 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . severity AS severity_3 , t0 . component AS component_4 , t0 . estimated_cost AS estimated_cost_5 , t0 . recommended_action AS recommended_action_6 , t0 . diagnostic_id AS diagnostic_id_7 FROM diagnostic_issue t0 WHERE t0 . diagnostic_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . severity AS severity_3 , t0 . component AS component_4 , t0 . estimated_cost AS estimated_cost_5 , t0 . recommended_action AS recommended_action_6 , t0 . diagnostic_id AS diagnostic_id_7 FROM diagnostic_issue t0 WHERE t0 . diagnostic_id = 4 ;
Copy
7
0.46 ms
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 = 1 ;
Copy
8
0.42 ms
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