1
3.05 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
2
0.40 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 . repair_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 . repair_id = 6 ;
Copy
4
0.40 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
0.27 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