| 1 |
0.68 ms |
SELECT i0_.invoice_type AS invoice_type_0, i0_.last_analysis_date AS last_analysis_date_1, i0_.advance_date AS advance_date_2, i0_.invoice_number AS invoice_number_3, i0_.broadcast_date AS broadcast_date_4, i0_.delivery_date AS delivery_date_5, i0_.expiration_date AS expiration_date_6, i0_.days_to_expiration AS days_to_expiration_7, i0_.payment_method AS payment_method_8, i0_.tax_base AS tax_base_9, i0_.tax AS tax_10, i0_.retentions AS retentions_11, i0_.total AS total_12, i0_.supplied_expense AS supplied_expense_13, i0_.attached_document AS attached_document_14, i0_.status AS status_15, i0_.discount AS discount_16, i0_.total_to_receive AS total_to_receive_17, i0_.provider_chooses_advance AS provider_chooses_advance_18, i0_.advance_allowed AS advance_allowed_19, i0_.contract_file AS contract_file_20, i0_.invoice_file AS invoice_file_21, i0_.rectified_document AS rectified_document_22, i0_.signed_contract AS signed_contract_23, i0_.concept AS concept_24, i0_.units AS units_25, i0_.price AS price_26, i0_.date_of_service_provision AS date_of_service_provision_27, i0_.created_at AS created_at_28, i0_.updated_at AS updated_at_29, i0_.id AS id_30, i0_.provider_id AS provider_id_31, i0_.client_id AS client_id_32, i0_.target_id AS target_id_33, i0_.advance_bank_account_id AS advance_bank_account_id_34 FROM invoice i0_ INNER JOIN user u1_ ON i0_.provider_id = u1_.id WHERE i0_.id IN (SELECT i2_.id FROM invoice i2_ INNER JOIN user u3_ ON i2_.provider_id = u3_.id WHERE u3_.id = ?) ORDER BY i0_.id ASC LIMIT 30
Parameters: [
"7f66baec-aafa-4b8e-a17d-20e117825db7"
]
SELECT i0_.invoice_type AS invoice_type_0, i0_.last_analysis_date AS last_analysis_date_1, i0_.advance_date AS advance_date_2, i0_.invoice_number AS invoice_number_3, i0_.broadcast_date AS broadcast_date_4, i0_.delivery_date AS delivery_date_5, i0_.expiration_date AS expiration_date_6, i0_.days_to_expiration AS days_to_expiration_7, i0_.payment_method AS payment_method_8, i0_.tax_base AS tax_base_9, i0_.tax AS tax_10, i0_.retentions AS retentions_11, i0_.total AS total_12, i0_.supplied_expense AS supplied_expense_13, i0_.attached_document AS attached_document_14, i0_.status AS status_15, i0_.discount AS discount_16, i0_.total_to_receive AS total_to_receive_17, i0_.provider_chooses_advance AS provider_chooses_advance_18, i0_.advance_allowed AS advance_allowed_19, i0_.contract_file AS contract_file_20, i0_.invoice_file AS invoice_file_21, i0_.rectified_document AS rectified_document_22, i0_.signed_contract AS signed_contract_23, i0_.concept AS concept_24, i0_.units AS units_25, i0_.price AS price_26, i0_.date_of_service_provision AS date_of_service_provision_27, i0_.created_at AS created_at_28, i0_.updated_at AS updated_at_29, i0_.id AS id_30, i0_.provider_id AS provider_id_31, i0_.client_id AS client_id_32, i0_.target_id AS target_id_33, i0_.advance_bank_account_id AS advance_bank_account_id_34 FROM invoice i0_ INNER JOIN user u1_ ON i0_.provider_id = u1_.id WHERE i0_.id IN (SELECT i2_.id FROM invoice i2_ INNER JOIN user u3_ ON i2_.provider_id = u3_.id WHERE u3_.id = '7f66baec-aafa-4b8e-a17d-20e117825db7') ORDER BY i0_.id ASC LIMIT 30;
|
| 2 |
0.24 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"2b7143b1-8e1b-4f9d-847e-24f7adad7027"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = '2b7143b1-8e1b-4f9d-847e-24f7adad7027';
|
| 3 |
0.35 ms |
SELECT t0.roles AS roles_1, t0.social_denomination AS social_denomination_2, t0.is_account_active AS is_account_active_3, t0.is_soft_deleted AS is_soft_deleted_4, t0.email AS email_5, t0.contact_person_name AS contact_person_name_6, t0.contact_person_sur_name AS contact_person_sur_name_7, t0.contact_person_nif AS contact_person_nif_8, t0.contact_person_phone AS contact_person_phone_9, t0.contact_person_email AS contact_person_email_10, t0.contact_person_position AS contact_person_position_11, t0.password AS password_12, t0.company_type AS company_type_13, t0.company_nif AS company_nif_14, t0.vat_number AS vat_number_15, t0.trade_name AS trade_name_16, t0.address AS address_17, t0.city AS city_18, t0.postal_code AS postal_code_19, t0.country AS country_20, t0.registration_reason AS registration_reason_21, t0.trade_offer_comunication AS trade_offer_comunication_22, t0.payment_method AS payment_method_23, t0.free_registration AS free_registration_24, t0.can_modify_data AS can_modify_data_25, t0.can_upload_invoices AS can_upload_invoices_26, t0.uploaded_contract_file AS uploaded_contract_file_27, t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28, t0.output_contract AS output_contract_29, t0.output_corrected_invoice AS output_corrected_invoice_30, t0.logo AS logo_31, t0.first_color AS first_color_32, t0.second_color AS second_color_33, t0.third_color AS third_color_34, t0.typography AS typography_35, t0.slug AS slug_36, t0.user_status AS user_status_37, t0.contact_contable_name AS contact_contable_name_38, t0.contact_contable_surname AS contact_contable_surname_39, t0.contact_contable_email AS contact_contable_email_40, t0.contact_contable_tel AS contact_contable_tel_41, t0.contact_admin_name AS contact_admin_name_42, t0.contact_admin_surname AS contact_admin_surname_43, t0.contact_admin_email AS contact_admin_email_44, t0.contact_admin_tel AS contact_admin_tel_45, t0.contact_admin_type AS contact_admin_type_46, t0.contact_admin_nif AS contact_admin_nif_47, t0.province AS province_48, t0.commercial_name AS commercial_name_49, t0.social_facebook AS social_facebook_50, t0.social_twitter AS social_twitter_51, t0.social_instagram AS social_instagram_52, t0.social_linkedin AS social_linkedin_53, t0.web_page AS web_page_54, t0.company_email AS company_email_55, t0.company_tel AS company_tel_56, t0.company_postal_code AS company_postal_code_57, t0.company_country AS company_country_58, t0.company_street AS company_street_59, t0.social_reason AS social_reason_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.id AS id_63 FROM user t0 WHERE t0.id = ?
Parameters: [
"8e9b99f9-0fea-4496-bc67-275cbca1e416"
]
SELECT
t0.roles AS roles_1,
t0.social_denomination AS social_denomination_2,
t0.is_account_active AS is_account_active_3,
t0.is_soft_deleted AS is_soft_deleted_4,
t0.email AS email_5,
t0.contact_person_name AS contact_person_name_6,
t0.contact_person_sur_name AS contact_person_sur_name_7,
t0.contact_person_nif AS contact_person_nif_8,
t0.contact_person_phone AS contact_person_phone_9,
t0.contact_person_email AS contact_person_email_10,
t0.contact_person_position AS contact_person_position_11,
t0.password AS password_12,
t0.company_type AS company_type_13,
t0.company_nif AS company_nif_14,
t0.vat_number AS vat_number_15,
t0.trade_name AS trade_name_16,
t0.address AS address_17,
t0.city AS city_18,
t0.postal_code AS postal_code_19,
t0.country AS country_20,
t0.registration_reason AS registration_reason_21,
t0.trade_offer_comunication AS trade_offer_comunication_22,
t0.payment_method AS payment_method_23,
t0.free_registration AS free_registration_24,
t0.can_modify_data AS can_modify_data_25,
t0.can_upload_invoices AS can_upload_invoices_26,
t0.uploaded_contract_file AS uploaded_contract_file_27,
t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28,
t0.output_contract AS output_contract_29,
t0.output_corrected_invoice AS output_corrected_invoice_30,
t0.logo AS logo_31,
t0.first_color AS first_color_32,
t0.second_color AS second_color_33,
t0.third_color AS third_color_34,
t0.typography AS typography_35,
t0.slug AS slug_36,
t0.user_status AS user_status_37,
t0.contact_contable_name AS contact_contable_name_38,
t0.contact_contable_surname AS contact_contable_surname_39,
t0.contact_contable_email AS contact_contable_email_40,
t0.contact_contable_tel AS contact_contable_tel_41,
t0.contact_admin_name AS contact_admin_name_42,
t0.contact_admin_surname AS contact_admin_surname_43,
t0.contact_admin_email AS contact_admin_email_44,
t0.contact_admin_tel AS contact_admin_tel_45,
t0.contact_admin_type AS contact_admin_type_46,
t0.contact_admin_nif AS contact_admin_nif_47,
t0.province AS province_48,
t0.commercial_name AS commercial_name_49,
t0.social_facebook AS social_facebook_50,
t0.social_twitter AS social_twitter_51,
t0.social_instagram AS social_instagram_52,
t0.social_linkedin AS social_linkedin_53,
t0.web_page AS web_page_54,
t0.company_email AS company_email_55,
t0.company_tel AS company_tel_56,
t0.company_postal_code AS company_postal_code_57,
t0.company_country AS company_country_58,
t0.company_street AS company_street_59,
t0.social_reason AS social_reason_60,
t0.created_at AS created_at_61,
t0.updated_at AS updated_at_62,
t0.id AS id_63
FROM
user t0
WHERE
t0.id = ?
SELECT t0.roles AS roles_1, t0.social_denomination AS social_denomination_2, t0.is_account_active AS is_account_active_3, t0.is_soft_deleted AS is_soft_deleted_4, t0.email AS email_5, t0.contact_person_name AS contact_person_name_6, t0.contact_person_sur_name AS contact_person_sur_name_7, t0.contact_person_nif AS contact_person_nif_8, t0.contact_person_phone AS contact_person_phone_9, t0.contact_person_email AS contact_person_email_10, t0.contact_person_position AS contact_person_position_11, t0.password AS password_12, t0.company_type AS company_type_13, t0.company_nif AS company_nif_14, t0.vat_number AS vat_number_15, t0.trade_name AS trade_name_16, t0.address AS address_17, t0.city AS city_18, t0.postal_code AS postal_code_19, t0.country AS country_20, t0.registration_reason AS registration_reason_21, t0.trade_offer_comunication AS trade_offer_comunication_22, t0.payment_method AS payment_method_23, t0.free_registration AS free_registration_24, t0.can_modify_data AS can_modify_data_25, t0.can_upload_invoices AS can_upload_invoices_26, t0.uploaded_contract_file AS uploaded_contract_file_27, t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28, t0.output_contract AS output_contract_29, t0.output_corrected_invoice AS output_corrected_invoice_30, t0.logo AS logo_31, t0.first_color AS first_color_32, t0.second_color AS second_color_33, t0.third_color AS third_color_34, t0.typography AS typography_35, t0.slug AS slug_36, t0.user_status AS user_status_37, t0.contact_contable_name AS contact_contable_name_38, t0.contact_contable_surname AS contact_contable_surname_39, t0.contact_contable_email AS contact_contable_email_40, t0.contact_contable_tel AS contact_contable_tel_41, t0.contact_admin_name AS contact_admin_name_42, t0.contact_admin_surname AS contact_admin_surname_43, t0.contact_admin_email AS contact_admin_email_44, t0.contact_admin_tel AS contact_admin_tel_45, t0.contact_admin_type AS contact_admin_type_46, t0.contact_admin_nif AS contact_admin_nif_47, t0.province AS province_48, t0.commercial_name AS commercial_name_49, t0.social_facebook AS social_facebook_50, t0.social_twitter AS social_twitter_51, t0.social_instagram AS social_instagram_52, t0.social_linkedin AS social_linkedin_53, t0.web_page AS web_page_54, t0.company_email AS company_email_55, t0.company_tel AS company_tel_56, t0.company_postal_code AS company_postal_code_57, t0.company_country AS company_country_58, t0.company_street AS company_street_59, t0.social_reason AS social_reason_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.id AS id_63 FROM user t0 WHERE t0.id = '8e9b99f9-0fea-4496-bc67-275cbca1e416';
|
| 4 |
0.35 ms |
SELECT t0.roles AS roles_1, t0.social_denomination AS social_denomination_2, t0.is_account_active AS is_account_active_3, t0.is_soft_deleted AS is_soft_deleted_4, t0.email AS email_5, t0.contact_person_name AS contact_person_name_6, t0.contact_person_sur_name AS contact_person_sur_name_7, t0.contact_person_nif AS contact_person_nif_8, t0.contact_person_phone AS contact_person_phone_9, t0.contact_person_email AS contact_person_email_10, t0.contact_person_position AS contact_person_position_11, t0.password AS password_12, t0.company_type AS company_type_13, t0.company_nif AS company_nif_14, t0.vat_number AS vat_number_15, t0.trade_name AS trade_name_16, t0.address AS address_17, t0.city AS city_18, t0.postal_code AS postal_code_19, t0.country AS country_20, t0.registration_reason AS registration_reason_21, t0.trade_offer_comunication AS trade_offer_comunication_22, t0.payment_method AS payment_method_23, t0.free_registration AS free_registration_24, t0.can_modify_data AS can_modify_data_25, t0.can_upload_invoices AS can_upload_invoices_26, t0.uploaded_contract_file AS uploaded_contract_file_27, t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28, t0.output_contract AS output_contract_29, t0.output_corrected_invoice AS output_corrected_invoice_30, t0.logo AS logo_31, t0.first_color AS first_color_32, t0.second_color AS second_color_33, t0.third_color AS third_color_34, t0.typography AS typography_35, t0.slug AS slug_36, t0.user_status AS user_status_37, t0.contact_contable_name AS contact_contable_name_38, t0.contact_contable_surname AS contact_contable_surname_39, t0.contact_contable_email AS contact_contable_email_40, t0.contact_contable_tel AS contact_contable_tel_41, t0.contact_admin_name AS contact_admin_name_42, t0.contact_admin_surname AS contact_admin_surname_43, t0.contact_admin_email AS contact_admin_email_44, t0.contact_admin_tel AS contact_admin_tel_45, t0.contact_admin_type AS contact_admin_type_46, t0.contact_admin_nif AS contact_admin_nif_47, t0.province AS province_48, t0.commercial_name AS commercial_name_49, t0.social_facebook AS social_facebook_50, t0.social_twitter AS social_twitter_51, t0.social_instagram AS social_instagram_52, t0.social_linkedin AS social_linkedin_53, t0.web_page AS web_page_54, t0.company_email AS company_email_55, t0.company_tel AS company_tel_56, t0.company_postal_code AS company_postal_code_57, t0.company_country AS company_country_58, t0.company_street AS company_street_59, t0.social_reason AS social_reason_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.id AS id_63 FROM user t0 WHERE t0.id = ?
Parameters: [
"7f66baec-aafa-4b8e-a17d-20e117825db7"
]
SELECT
t0.roles AS roles_1,
t0.social_denomination AS social_denomination_2,
t0.is_account_active AS is_account_active_3,
t0.is_soft_deleted AS is_soft_deleted_4,
t0.email AS email_5,
t0.contact_person_name AS contact_person_name_6,
t0.contact_person_sur_name AS contact_person_sur_name_7,
t0.contact_person_nif AS contact_person_nif_8,
t0.contact_person_phone AS contact_person_phone_9,
t0.contact_person_email AS contact_person_email_10,
t0.contact_person_position AS contact_person_position_11,
t0.password AS password_12,
t0.company_type AS company_type_13,
t0.company_nif AS company_nif_14,
t0.vat_number AS vat_number_15,
t0.trade_name AS trade_name_16,
t0.address AS address_17,
t0.city AS city_18,
t0.postal_code AS postal_code_19,
t0.country AS country_20,
t0.registration_reason AS registration_reason_21,
t0.trade_offer_comunication AS trade_offer_comunication_22,
t0.payment_method AS payment_method_23,
t0.free_registration AS free_registration_24,
t0.can_modify_data AS can_modify_data_25,
t0.can_upload_invoices AS can_upload_invoices_26,
t0.uploaded_contract_file AS uploaded_contract_file_27,
t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28,
t0.output_contract AS output_contract_29,
t0.output_corrected_invoice AS output_corrected_invoice_30,
t0.logo AS logo_31,
t0.first_color AS first_color_32,
t0.second_color AS second_color_33,
t0.third_color AS third_color_34,
t0.typography AS typography_35,
t0.slug AS slug_36,
t0.user_status AS user_status_37,
t0.contact_contable_name AS contact_contable_name_38,
t0.contact_contable_surname AS contact_contable_surname_39,
t0.contact_contable_email AS contact_contable_email_40,
t0.contact_contable_tel AS contact_contable_tel_41,
t0.contact_admin_name AS contact_admin_name_42,
t0.contact_admin_surname AS contact_admin_surname_43,
t0.contact_admin_email AS contact_admin_email_44,
t0.contact_admin_tel AS contact_admin_tel_45,
t0.contact_admin_type AS contact_admin_type_46,
t0.contact_admin_nif AS contact_admin_nif_47,
t0.province AS province_48,
t0.commercial_name AS commercial_name_49,
t0.social_facebook AS social_facebook_50,
t0.social_twitter AS social_twitter_51,
t0.social_instagram AS social_instagram_52,
t0.social_linkedin AS social_linkedin_53,
t0.web_page AS web_page_54,
t0.company_email AS company_email_55,
t0.company_tel AS company_tel_56,
t0.company_postal_code AS company_postal_code_57,
t0.company_country AS company_country_58,
t0.company_street AS company_street_59,
t0.social_reason AS social_reason_60,
t0.created_at AS created_at_61,
t0.updated_at AS updated_at_62,
t0.id AS id_63
FROM
user t0
WHERE
t0.id = ?
SELECT t0.roles AS roles_1, t0.social_denomination AS social_denomination_2, t0.is_account_active AS is_account_active_3, t0.is_soft_deleted AS is_soft_deleted_4, t0.email AS email_5, t0.contact_person_name AS contact_person_name_6, t0.contact_person_sur_name AS contact_person_sur_name_7, t0.contact_person_nif AS contact_person_nif_8, t0.contact_person_phone AS contact_person_phone_9, t0.contact_person_email AS contact_person_email_10, t0.contact_person_position AS contact_person_position_11, t0.password AS password_12, t0.company_type AS company_type_13, t0.company_nif AS company_nif_14, t0.vat_number AS vat_number_15, t0.trade_name AS trade_name_16, t0.address AS address_17, t0.city AS city_18, t0.postal_code AS postal_code_19, t0.country AS country_20, t0.registration_reason AS registration_reason_21, t0.trade_offer_comunication AS trade_offer_comunication_22, t0.payment_method AS payment_method_23, t0.free_registration AS free_registration_24, t0.can_modify_data AS can_modify_data_25, t0.can_upload_invoices AS can_upload_invoices_26, t0.uploaded_contract_file AS uploaded_contract_file_27, t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28, t0.output_contract AS output_contract_29, t0.output_corrected_invoice AS output_corrected_invoice_30, t0.logo AS logo_31, t0.first_color AS first_color_32, t0.second_color AS second_color_33, t0.third_color AS third_color_34, t0.typography AS typography_35, t0.slug AS slug_36, t0.user_status AS user_status_37, t0.contact_contable_name AS contact_contable_name_38, t0.contact_contable_surname AS contact_contable_surname_39, t0.contact_contable_email AS contact_contable_email_40, t0.contact_contable_tel AS contact_contable_tel_41, t0.contact_admin_name AS contact_admin_name_42, t0.contact_admin_surname AS contact_admin_surname_43, t0.contact_admin_email AS contact_admin_email_44, t0.contact_admin_tel AS contact_admin_tel_45, t0.contact_admin_type AS contact_admin_type_46, t0.contact_admin_nif AS contact_admin_nif_47, t0.province AS province_48, t0.commercial_name AS commercial_name_49, t0.social_facebook AS social_facebook_50, t0.social_twitter AS social_twitter_51, t0.social_instagram AS social_instagram_52, t0.social_linkedin AS social_linkedin_53, t0.web_page AS web_page_54, t0.company_email AS company_email_55, t0.company_tel AS company_tel_56, t0.company_postal_code AS company_postal_code_57, t0.company_country AS company_country_58, t0.company_street AS company_street_59, t0.social_reason AS social_reason_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.id AS id_63 FROM user t0 WHERE t0.id = '7f66baec-aafa-4b8e-a17d-20e117825db7';
|
| 5 |
0.24 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"44f8c998-4880-443b-9317-b38f4a0c0a0a"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = '44f8c998-4880-443b-9317-b38f4a0c0a0a';
|
| 6 |
0.22 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"56eb0697-a05f-47df-910e-3e4b50ca8ef8"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = '56eb0697-a05f-47df-910e-3e4b50ca8ef8';
|
| 7 |
0.32 ms |
SELECT t0.roles AS roles_1, t0.social_denomination AS social_denomination_2, t0.is_account_active AS is_account_active_3, t0.is_soft_deleted AS is_soft_deleted_4, t0.email AS email_5, t0.contact_person_name AS contact_person_name_6, t0.contact_person_sur_name AS contact_person_sur_name_7, t0.contact_person_nif AS contact_person_nif_8, t0.contact_person_phone AS contact_person_phone_9, t0.contact_person_email AS contact_person_email_10, t0.contact_person_position AS contact_person_position_11, t0.password AS password_12, t0.company_type AS company_type_13, t0.company_nif AS company_nif_14, t0.vat_number AS vat_number_15, t0.trade_name AS trade_name_16, t0.address AS address_17, t0.city AS city_18, t0.postal_code AS postal_code_19, t0.country AS country_20, t0.registration_reason AS registration_reason_21, t0.trade_offer_comunication AS trade_offer_comunication_22, t0.payment_method AS payment_method_23, t0.free_registration AS free_registration_24, t0.can_modify_data AS can_modify_data_25, t0.can_upload_invoices AS can_upload_invoices_26, t0.uploaded_contract_file AS uploaded_contract_file_27, t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28, t0.output_contract AS output_contract_29, t0.output_corrected_invoice AS output_corrected_invoice_30, t0.logo AS logo_31, t0.first_color AS first_color_32, t0.second_color AS second_color_33, t0.third_color AS third_color_34, t0.typography AS typography_35, t0.slug AS slug_36, t0.user_status AS user_status_37, t0.contact_contable_name AS contact_contable_name_38, t0.contact_contable_surname AS contact_contable_surname_39, t0.contact_contable_email AS contact_contable_email_40, t0.contact_contable_tel AS contact_contable_tel_41, t0.contact_admin_name AS contact_admin_name_42, t0.contact_admin_surname AS contact_admin_surname_43, t0.contact_admin_email AS contact_admin_email_44, t0.contact_admin_tel AS contact_admin_tel_45, t0.contact_admin_type AS contact_admin_type_46, t0.contact_admin_nif AS contact_admin_nif_47, t0.province AS province_48, t0.commercial_name AS commercial_name_49, t0.social_facebook AS social_facebook_50, t0.social_twitter AS social_twitter_51, t0.social_instagram AS social_instagram_52, t0.social_linkedin AS social_linkedin_53, t0.web_page AS web_page_54, t0.company_email AS company_email_55, t0.company_tel AS company_tel_56, t0.company_postal_code AS company_postal_code_57, t0.company_country AS company_country_58, t0.company_street AS company_street_59, t0.social_reason AS social_reason_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.id AS id_63 FROM user t0 WHERE t0.id = ?
Parameters: [
"b9e67b3d-b48d-4cc3-8ba2-04c937987eb6"
]
SELECT
t0.roles AS roles_1,
t0.social_denomination AS social_denomination_2,
t0.is_account_active AS is_account_active_3,
t0.is_soft_deleted AS is_soft_deleted_4,
t0.email AS email_5,
t0.contact_person_name AS contact_person_name_6,
t0.contact_person_sur_name AS contact_person_sur_name_7,
t0.contact_person_nif AS contact_person_nif_8,
t0.contact_person_phone AS contact_person_phone_9,
t0.contact_person_email AS contact_person_email_10,
t0.contact_person_position AS contact_person_position_11,
t0.password AS password_12,
t0.company_type AS company_type_13,
t0.company_nif AS company_nif_14,
t0.vat_number AS vat_number_15,
t0.trade_name AS trade_name_16,
t0.address AS address_17,
t0.city AS city_18,
t0.postal_code AS postal_code_19,
t0.country AS country_20,
t0.registration_reason AS registration_reason_21,
t0.trade_offer_comunication AS trade_offer_comunication_22,
t0.payment_method AS payment_method_23,
t0.free_registration AS free_registration_24,
t0.can_modify_data AS can_modify_data_25,
t0.can_upload_invoices AS can_upload_invoices_26,
t0.uploaded_contract_file AS uploaded_contract_file_27,
t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28,
t0.output_contract AS output_contract_29,
t0.output_corrected_invoice AS output_corrected_invoice_30,
t0.logo AS logo_31,
t0.first_color AS first_color_32,
t0.second_color AS second_color_33,
t0.third_color AS third_color_34,
t0.typography AS typography_35,
t0.slug AS slug_36,
t0.user_status AS user_status_37,
t0.contact_contable_name AS contact_contable_name_38,
t0.contact_contable_surname AS contact_contable_surname_39,
t0.contact_contable_email AS contact_contable_email_40,
t0.contact_contable_tel AS contact_contable_tel_41,
t0.contact_admin_name AS contact_admin_name_42,
t0.contact_admin_surname AS contact_admin_surname_43,
t0.contact_admin_email AS contact_admin_email_44,
t0.contact_admin_tel AS contact_admin_tel_45,
t0.contact_admin_type AS contact_admin_type_46,
t0.contact_admin_nif AS contact_admin_nif_47,
t0.province AS province_48,
t0.commercial_name AS commercial_name_49,
t0.social_facebook AS social_facebook_50,
t0.social_twitter AS social_twitter_51,
t0.social_instagram AS social_instagram_52,
t0.social_linkedin AS social_linkedin_53,
t0.web_page AS web_page_54,
t0.company_email AS company_email_55,
t0.company_tel AS company_tel_56,
t0.company_postal_code AS company_postal_code_57,
t0.company_country AS company_country_58,
t0.company_street AS company_street_59,
t0.social_reason AS social_reason_60,
t0.created_at AS created_at_61,
t0.updated_at AS updated_at_62,
t0.id AS id_63
FROM
user t0
WHERE
t0.id = ?
SELECT t0.roles AS roles_1, t0.social_denomination AS social_denomination_2, t0.is_account_active AS is_account_active_3, t0.is_soft_deleted AS is_soft_deleted_4, t0.email AS email_5, t0.contact_person_name AS contact_person_name_6, t0.contact_person_sur_name AS contact_person_sur_name_7, t0.contact_person_nif AS contact_person_nif_8, t0.contact_person_phone AS contact_person_phone_9, t0.contact_person_email AS contact_person_email_10, t0.contact_person_position AS contact_person_position_11, t0.password AS password_12, t0.company_type AS company_type_13, t0.company_nif AS company_nif_14, t0.vat_number AS vat_number_15, t0.trade_name AS trade_name_16, t0.address AS address_17, t0.city AS city_18, t0.postal_code AS postal_code_19, t0.country AS country_20, t0.registration_reason AS registration_reason_21, t0.trade_offer_comunication AS trade_offer_comunication_22, t0.payment_method AS payment_method_23, t0.free_registration AS free_registration_24, t0.can_modify_data AS can_modify_data_25, t0.can_upload_invoices AS can_upload_invoices_26, t0.uploaded_contract_file AS uploaded_contract_file_27, t0.uploaded_corrected_invoice_file AS uploaded_corrected_invoice_file_28, t0.output_contract AS output_contract_29, t0.output_corrected_invoice AS output_corrected_invoice_30, t0.logo AS logo_31, t0.first_color AS first_color_32, t0.second_color AS second_color_33, t0.third_color AS third_color_34, t0.typography AS typography_35, t0.slug AS slug_36, t0.user_status AS user_status_37, t0.contact_contable_name AS contact_contable_name_38, t0.contact_contable_surname AS contact_contable_surname_39, t0.contact_contable_email AS contact_contable_email_40, t0.contact_contable_tel AS contact_contable_tel_41, t0.contact_admin_name AS contact_admin_name_42, t0.contact_admin_surname AS contact_admin_surname_43, t0.contact_admin_email AS contact_admin_email_44, t0.contact_admin_tel AS contact_admin_tel_45, t0.contact_admin_type AS contact_admin_type_46, t0.contact_admin_nif AS contact_admin_nif_47, t0.province AS province_48, t0.commercial_name AS commercial_name_49, t0.social_facebook AS social_facebook_50, t0.social_twitter AS social_twitter_51, t0.social_instagram AS social_instagram_52, t0.social_linkedin AS social_linkedin_53, t0.web_page AS web_page_54, t0.company_email AS company_email_55, t0.company_tel AS company_tel_56, t0.company_postal_code AS company_postal_code_57, t0.company_country AS company_country_58, t0.company_street AS company_street_59, t0.social_reason AS social_reason_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.id AS id_63 FROM user t0 WHERE t0.id = 'b9e67b3d-b48d-4cc3-8ba2-04c937987eb6';
|
| 8 |
0.21 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"5f4c56fc-8844-4087-8c17-6a3b310f0917"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = '5f4c56fc-8844-4087-8c17-6a3b310f0917';
|
| 9 |
0.22 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"6977542a-2df9-4b41-831a-663ab39c57d3"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = '6977542a-2df9-4b41-831a-663ab39c57d3';
|
| 10 |
0.22 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"8c9a730b-16e5-41c8-b04b-49e5a76e198b"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = '8c9a730b-16e5-41c8-b04b-49e5a76e198b';
|
| 11 |
0.23 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"96d436f0-46c9-456d-9760-245ba4313f0a"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = '96d436f0-46c9-456d-9760-245ba4313f0a';
|
| 12 |
0.21 ms |
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = ?
Parameters: [
"e7123c4d-693f-4f87-a346-3f78c9cb8e85"
]
SELECT t0.product_description AS product_description_1, t0.units AS units_2, t0.unit_price AS unit_price_3, t0.product_discount AS product_discount_4, t0.product_total AS product_total_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.invoice_id AS invoice_id_9 FROM product t0 WHERE t0.invoice_id = 'e7123c4d-693f-4f87-a346-3f78c9cb8e85';
|