| 1 |
0.62 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = ?
Parameters: [
"e1d213a7-a827-410f-8a36-623e68f7991b"
]
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = 'e1d213a7-a827-410f-8a36-623e68f7991b';
|
| 2 |
0.57 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = ?
Parameters: [
"71457125-416b-466f-9e32-faf5b79dfcb5"
]
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = '71457125-416b-466f-9e32-faf5b79dfcb5';
|
| 3 |
0.59 ms |
SELECT t0.id AS id_1, t0.assistance_number AS assistance_number_2, t0.customer_business_name AS customer_business_name_3, t0.customer_address AS customer_address_4, t0.customer_zip_code AS customer_zip_code_5, t0.customer_city AS customer_city_6, t0.customer_state AS customer_state_7, t0.customer_phone AS customer_phone_8, t0.customer_email AS customer_email_9, t0.article_code AS article_code_10, t0.article_description AS article_description_11, t0.serial_number AS serial_number_12, t0.purchase_date AS purchase_date_13, t0.warranty_end_date AS warranty_end_date_14, t0.location AS location_15, t0.name_contact_person AS name_contact_person_16, t0.description AS description_17, t0.technician_suggestions AS technician_suggestions_18, t0.assistance_performed AS assistance_performed_19, t0.assistance_date AS assistance_date_20, t0.charge_type AS charge_type_21, t0.technician_name AS technician_name_22, t0.signer_name AS signer_name_23, t0.signer_dni AS signer_dni_24, t0.signer_relationship AS signer_relationship_25, t0.vat_rate AS vat_rate_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.ticket_id AS ticket_id_29 FROM ticket_warranty_machine t0 WHERE t0.id = ?
Parameters: [
"9c857e6f-5874-40f1-adf3-207d853882f1"
]
SELECT t0.id AS id_1, t0.assistance_number AS assistance_number_2, t0.customer_business_name AS customer_business_name_3, t0.customer_address AS customer_address_4, t0.customer_zip_code AS customer_zip_code_5, t0.customer_city AS customer_city_6, t0.customer_state AS customer_state_7, t0.customer_phone AS customer_phone_8, t0.customer_email AS customer_email_9, t0.article_code AS article_code_10, t0.article_description AS article_description_11, t0.serial_number AS serial_number_12, t0.purchase_date AS purchase_date_13, t0.warranty_end_date AS warranty_end_date_14, t0.location AS location_15, t0.name_contact_person AS name_contact_person_16, t0.description AS description_17, t0.technician_suggestions AS technician_suggestions_18, t0.assistance_performed AS assistance_performed_19, t0.assistance_date AS assistance_date_20, t0.charge_type AS charge_type_21, t0.technician_name AS technician_name_22, t0.signer_name AS signer_name_23, t0.signer_dni AS signer_dni_24, t0.signer_relationship AS signer_relationship_25, t0.vat_rate AS vat_rate_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.ticket_id AS ticket_id_29 FROM ticket_warranty_machine t0 WHERE t0.id = '9c857e6f-5874-40f1-adf3-207d853882f1';
|
| 4 |
0.65 ms |
SELECT t0.id AS id_1, t0.ticket_container_id AS ticket_container_id_2, t0.ticket_container_class AS ticket_container_class_3, t0.type AS type_4, t0.status AS status_5, t0.resolved_at AS resolved_at_6, t0.resolution_comment AS resolution_comment_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.requesting_user_id AS requesting_user_id_10, t0.cancelled_by_id AS cancelled_by_id_11, t0.resolved_by_id AS resolved_by_id_12, t13.id AS id_14, t13.assistance_number AS assistance_number_15, t13.customer_business_name AS customer_business_name_16, t13.customer_address AS customer_address_17, t13.customer_zip_code AS customer_zip_code_18, t13.customer_city AS customer_city_19, t13.customer_state AS customer_state_20, t13.customer_phone AS customer_phone_21, t13.customer_email AS customer_email_22, t13.article_code AS article_code_23, t13.article_description AS article_description_24, t13.serial_number AS serial_number_25, t13.purchase_date AS purchase_date_26, t13.warranty_end_date AS warranty_end_date_27, t13.location AS location_28, t13.name_contact_person AS name_contact_person_29, t13.description AS description_30, t13.technician_suggestions AS technician_suggestions_31, t13.assistance_performed AS assistance_performed_32, t13.assistance_date AS assistance_date_33, t13.charge_type AS charge_type_34, t13.technician_name AS technician_name_35, t13.signer_name AS signer_name_36, t13.signer_dni AS signer_dni_37, t13.signer_relationship AS signer_relationship_38, t13.vat_rate AS vat_rate_39, t13.created_at AS created_at_40, t13.updated_at AS updated_at_41, t13.ticket_id AS ticket_id_42 FROM ticket t0 LEFT JOIN ticket_warranty_machine t13 ON t13.ticket_id = t0.id WHERE t0.id = ?
Parameters: [
"24ca6941-be35-4c4f-8d76-ce753500b277"
]
SELECT
t0.id AS id_1,
t0.ticket_container_id AS ticket_container_id_2,
t0.ticket_container_class AS ticket_container_class_3,
t0.type AS type_4,
t0.status AS status_5,
t0.resolved_at AS resolved_at_6,
t0.resolution_comment AS resolution_comment_7,
t0.created_at AS created_at_8,
t0.updated_at AS updated_at_9,
t0.requesting_user_id AS requesting_user_id_10,
t0.cancelled_by_id AS cancelled_by_id_11,
t0.resolved_by_id AS resolved_by_id_12,
t13.id AS id_14,
t13.assistance_number AS assistance_number_15,
t13.customer_business_name AS customer_business_name_16,
t13.customer_address AS customer_address_17,
t13.customer_zip_code AS customer_zip_code_18,
t13.customer_city AS customer_city_19,
t13.customer_state AS customer_state_20,
t13.customer_phone AS customer_phone_21,
t13.customer_email AS customer_email_22,
t13.article_code AS article_code_23,
t13.article_description AS article_description_24,
t13.serial_number AS serial_number_25,
t13.purchase_date AS purchase_date_26,
t13.warranty_end_date AS warranty_end_date_27,
t13.location AS location_28,
t13.name_contact_person AS name_contact_person_29,
t13.description AS description_30,
t13.technician_suggestions AS technician_suggestions_31,
t13.assistance_performed AS assistance_performed_32,
t13.assistance_date AS assistance_date_33,
t13.charge_type AS charge_type_34,
t13.technician_name AS technician_name_35,
t13.signer_name AS signer_name_36,
t13.signer_dni AS signer_dni_37,
t13.signer_relationship AS signer_relationship_38,
t13.vat_rate AS vat_rate_39,
t13.created_at AS created_at_40,
t13.updated_at AS updated_at_41,
t13.ticket_id AS ticket_id_42
FROM
ticket t0
LEFT JOIN ticket_warranty_machine t13 ON t13.ticket_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.ticket_container_id AS ticket_container_id_2, t0.ticket_container_class AS ticket_container_class_3, t0.type AS type_4, t0.status AS status_5, t0.resolved_at AS resolved_at_6, t0.resolution_comment AS resolution_comment_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.requesting_user_id AS requesting_user_id_10, t0.cancelled_by_id AS cancelled_by_id_11, t0.resolved_by_id AS resolved_by_id_12, t13.id AS id_14, t13.assistance_number AS assistance_number_15, t13.customer_business_name AS customer_business_name_16, t13.customer_address AS customer_address_17, t13.customer_zip_code AS customer_zip_code_18, t13.customer_city AS customer_city_19, t13.customer_state AS customer_state_20, t13.customer_phone AS customer_phone_21, t13.customer_email AS customer_email_22, t13.article_code AS article_code_23, t13.article_description AS article_description_24, t13.serial_number AS serial_number_25, t13.purchase_date AS purchase_date_26, t13.warranty_end_date AS warranty_end_date_27, t13.location AS location_28, t13.name_contact_person AS name_contact_person_29, t13.description AS description_30, t13.technician_suggestions AS technician_suggestions_31, t13.assistance_performed AS assistance_performed_32, t13.assistance_date AS assistance_date_33, t13.charge_type AS charge_type_34, t13.technician_name AS technician_name_35, t13.signer_name AS signer_name_36, t13.signer_dni AS signer_dni_37, t13.signer_relationship AS signer_relationship_38, t13.vat_rate AS vat_rate_39, t13.created_at AS created_at_40, t13.updated_at AS updated_at_41, t13.ticket_id AS ticket_id_42 FROM ticket t0 LEFT JOIN ticket_warranty_machine t13 ON t13.ticket_id = t0.id WHERE t0.id = '24ca6941-be35-4c4f-8d76-ce753500b277';
|
| 5 |
0.66 ms |
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.concept AS concept_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_8, t0.product_id AS product_id_9 FROM ticket_warranty_machine_material t0 WHERE t0.ticket_warranty_machine_id = ? ORDER BY t0.concept ASC
Parameters: [
"9c857e6f-5874-40f1-adf3-207d853882f1"
]
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.concept AS concept_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_8, t0.product_id AS product_id_9 FROM ticket_warranty_machine_material t0 WHERE t0.ticket_warranty_machine_id = '9c857e6f-5874-40f1-adf3-207d853882f1' ORDER BY t0.concept ASC;
|
| 6 |
0.48 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.hours AS hours_5, t0.distributor_hours AS distributor_hours_6, t0.hourly_rate AS hourly_rate_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_10 FROM ticket_warranty_machine_labor t0 WHERE t0.ticket_warranty_machine_id = ? ORDER BY t0.date ASC, t0.start_time ASC
Parameters: [
"9c857e6f-5874-40f1-adf3-207d853882f1"
]
SELECT t0.id AS id_1, t0.date AS date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.hours AS hours_5, t0.distributor_hours AS distributor_hours_6, t0.hourly_rate AS hourly_rate_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_10 FROM ticket_warranty_machine_labor t0 WHERE t0.ticket_warranty_machine_id = '9c857e6f-5874-40f1-adf3-207d853882f1' ORDER BY t0.date ASC, t0.start_time ASC;
|
| 7 |
0.35 ms |
SELECT t0.id AS id_1, t0.kilometers AS kilometers_2, t0.kilometer_rate AS kilometer_rate_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_6 FROM ticket_warranty_machine_mileage t0 WHERE t0.ticket_warranty_machine_id = ? ORDER BY t0.created_at ASC
Parameters: [
"9c857e6f-5874-40f1-adf3-207d853882f1"
]
SELECT t0.id AS id_1, t0.kilometers AS kilometers_2, t0.kilometer_rate AS kilometer_rate_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_6 FROM ticket_warranty_machine_mileage t0 WHERE t0.ticket_warranty_machine_id = '9c857e6f-5874-40f1-adf3-207d853882f1' ORDER BY t0.created_at ASC;
|
| 8 |
0.27 ms |
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.hourly_rate AS hourly_rate_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_6 FROM ticket_warranty_machine_travel t0 WHERE t0.ticket_warranty_machine_id = ? ORDER BY t0.created_at ASC
Parameters: [
"9c857e6f-5874-40f1-adf3-207d853882f1"
]
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.hourly_rate AS hourly_rate_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.ticket_warranty_machine_id AS ticket_warranty_machine_id_6 FROM ticket_warranty_machine_travel t0 WHERE t0.ticket_warranty_machine_id = '9c857e6f-5874-40f1-adf3-207d853882f1' ORDER BY t0.created_at ASC;
|
| 9 |
0.28 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.is_video AS is_video_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.ticket_id AS ticket_id_7 FROM ticket_attachment t0 WHERE t0.ticket_id = ?
Parameters: [
"24ca6941-be35-4c4f-8d76-ce753500b277"
]
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.is_video AS is_video_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.ticket_id AS ticket_id_7 FROM ticket_attachment t0 WHERE t0.ticket_id = '24ca6941-be35-4c4f-8d76-ce753500b277';
|