1
1.77 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 = '5' ;
Copy
2
0.51 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
3
0.46 ms
SELECT c0_ . id AS id_0 , c0_ . first_name AS first_name_1 , c0_ . last_name AS last_name_2 , c0_ . email AS email_3 , c0_ . phone AS phone_4 , c0_ . address AS address_5 , c0_ . city AS city_6 , c0_ . postal_code AS postal_code_7 , c0_ . nature AS nature_8 , c0_ . notes AS notes_9 , c0_ . created_at AS created_at_10 , c0_ . updated_at AS updated_at_11 FROM customer c0_ ORDER BY c0_ . last_name ASC
SELECT c0_ . id AS id_0 , c0_ . first_name AS first_name_1 , c0_ . last_name AS last_name_2 , c0_ . email AS email_3 , c0_ . phone AS phone_4 , c0_ . address AS address_5 , c0_ . city AS city_6 , c0_ . postal_code AS postal_code_7 , c0_ . nature AS nature_8 , c0_ . notes AS notes_9 , c0_ . created_at AS created_at_10 , c0_ . updated_at AS updated_at_11 FROM customer c0_ ORDER BY c0_ . last_name ASC ;
Copy
4
0.41 ms
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 , r0_ . vehicle_id AS vehicle_id_18 , r0_ . customer_id AS customer_id_19 , r0_ . diagnostic_id AS diagnostic_id_20 , r0_ . mechanic_id AS mechanic_id_21 , r0_ . customer_delivery_id AS customer_delivery_id_22 FROM repair r0_ INNER JOIN vehicle v1_ ON r0_ . vehicle_id = v1_ . id WHERE v1_ . customer_id = ? ORDER BY r0_ . created_at DESC
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 , r0_ . vehicle_id AS vehicle_id_18 , r0_ . customer_id AS customer_id_19 , r0_ . diagnostic_id AS diagnostic_id_20 , r0_ . mechanic_id AS mechanic_id_21 , r0_ . customer_delivery_id AS customer_delivery_id_22 FROM repair r0_ INNER JOIN vehicle v1_ ON r0_ . vehicle_id = v1_ . id WHERE v1_ . customer_id = 4 ORDER BY r0_ . created_at DESC ;
Copy
5
0.27 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 = 7 ;
Copy
6
0.23 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
7
0.30 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 = 4 ;
Copy
8
0.35 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
9
0.60 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