Symfony Profiler

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 = ?

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';

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';

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

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;