Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.telephone AS telephone_3,
  t0.telephone_main AS telephone_main_4,
  t0.telephone_master AS telephone_master_5,
  t0.telephone_slave AS telephone_slave_6,
  t0.email_main AS email_main_7,
  t0.email_slave AS email_slave_8,
  t0.website AS website_9,
  t0.licenca AS licenca_10,
  t0.valid AS valid_11,
  t0.nif AS nif_12,
  t0.slogan AS slogan_13,
  t0.logo AS logo_14,
  t0.fullName AS fullName_15,
  t0.fax AS fax_16,
  t0.capitalSocial AS capitalSocial_17,
  t0.endereco AS endereco_18,
  t0.id_tipo AS id_tipo_19,
  t0.sif_public_key AS sif_public_key_20,
  t0.sif_auto_submit AS sif_auto_submit_21,
  t0.sif_private_key AS sif_private_key_22,
  t0.sharedware_house AS sharedware_house_23,
  t0.privacity AS privacity_24,
  t0.provincia AS provincia_25,
  t0.pais AS pais_26,
  t0.address_id AS address_id_27,
  t0.tax_regim_id AS tax_regim_id_28,
  t0.diversos_id AS diversos_id_29,
  t0.settings_id AS settings_id_30
FROM
  company t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.telephone AS telephone_3, t0.telephone_main AS telephone_main_4, t0.telephone_master AS telephone_master_5, t0.telephone_slave AS telephone_slave_6, t0.email_main AS email_main_7, t0.email_slave AS email_slave_8, t0.website AS website_9, t0.licenca AS licenca_10, t0.valid AS valid_11, t0.nif AS nif_12, t0.slogan AS slogan_13, t0.logo AS logo_14, t0.fullName AS fullName_15, t0.fax AS fax_16, t0.capitalSocial AS capitalSocial_17, t0.endereco AS endereco_18, t0.id_tipo AS id_tipo_19, t0.sif_public_key AS sif_public_key_20, t0.sif_auto_submit AS sif_auto_submit_21, t0.sif_private_key AS sif_private_key_22, t0.sharedware_house AS sharedware_house_23, t0.privacity AS privacity_24, t0.provincia AS provincia_25, t0.pais AS pais_26, t0.address_id AS address_id_27, t0.tax_regim_id AS tax_regim_id_28, t0.diversos_id AS diversos_id_29, t0.settings_id AS settings_id_30 FROM company t0;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.name AS name_3,
  t0.invoices AS invoices_4,
  t0.amount AS amount_5,
  t0.wareHouses AS wareHouses_6,
  t0.supplies AS supplies_7,
  t0.users AS users_8,
  t0.accounting AS accounting_9,
  t0.auditing AS auditing_10,
  t0.pos AS pos_11,
  t0.reports AS reports_12,
  t0.dayly_back_ups AS dayly_back_ups_13,
  t0.date AS date_14,
  t0.due_date AS due_date_15,
  t0.license AS license_16,
  t0.company_id AS company_id_17
FROM
  plan_counter t0
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.price AS price_2, t0.name AS name_3, t0.invoices AS invoices_4, t0.amount AS amount_5, t0.wareHouses AS wareHouses_6, t0.supplies AS supplies_7, t0.users AS users_8, t0.accounting AS accounting_9, t0.auditing AS auditing_10, t0.pos AS pos_11, t0.reports AS reports_12, t0.dayly_back_ups AS dayly_back_ups_13, t0.date AS date_14, t0.due_date AS due_date_15, t0.license AS license_16, t0.company_id AS company_id_17 FROM plan_counter t0 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.details AS details_5,
  t0.group_id AS group_id_6,
  t0.tax_exemption_id AS tax_exemption_id_7
FROM
  tax_exemption_artigo_factura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.code AS code_3, t0.description AS description_4, t0.details AS details_5, t0.group_id AS group_id_6, t0.tax_exemption_id AS tax_exemption_id_7 FROM tax_exemption_artigo_factura t0 WHERE t0.id = 306;

SELECT
  t0.id AS id_1,
  t0.uiidToken AS uiidToken_2,
  t0.username AS username_3,
  t0.name AS name_4,
  t0.email AS email_5,
  t0.telefone AS telefone_6,
  t0.password AS password_7,
  t0.role AS role_8,
  t0.LASTACTIVITY AS LASTACTIVITY_9,
  t0.date AS date_10,
  t0.client_id AS client_id_11,
  t0.ware_house_id AS ware_house_id_12,
  t0.empresa_id AS empresa_id_13
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uiidToken AS uiidToken_2, t0.username AS username_3, t0.name AS name_4, t0.email AS email_5, t0.telefone AS telefone_6, t0.password AS password_7, t0.role AS role_8, t0.LASTACTIVITY AS LASTACTIVITY_9, t0.date AS date_10, t0.client_id AS client_id_11, t0.ware_house_id AS ware_house_id_12, t0.empresa_id AS empresa_id_13 FROM users t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.code AS code_3,
  t0.prefix AS prefix_4,
  t0.validade AS validade_5,
  t0.descricao AS descricao_6,
  t0.documentgroup_id AS documentgroup_id_7
FROM
  tipo_factura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.code AS code_3, t0.prefix AS prefix_4, t0.validade AS validade_5, t0.descricao AS descricao_6, t0.documentgroup_id AS documentgroup_id_7 FROM tipo_factura t0 WHERE t0.id = '41cb5e9e-acaa-11e8-8049-658e9954d83e';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nome AS nome_3,
  t0.valor AS valor_4,
  t0.description AS description_5,
  t0.iva_id AS iva_id_6
FROM
  iva_artigo_factura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nome AS nome_3, t0.valor AS valor_4, t0.description AS description_5, t0.iva_id AS iva_id_6 FROM iva_artigo_factura t0 WHERE t0.id = 563;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.date AS date_3,
  t0.docDate AS docDate_4,
  t0.update_date AS update_date_5,
  t0.data_vencimento AS data_vencimento_6,
  t0.serie_id AS serie_id_7,
  t0.original_print AS original_print_8,
  t0.validade AS validade_9,
  t0.desconto AS desconto_10,
  t0.payed_value AS payed_value_11,
  t0.obs AS obs_12,
  t0.hash AS hash_13,
  t0.re_hash AS re_hash_14,
  t0.delivery_time AS delivery_time_15,
  t0.contract AS contract_16,
  t0.valor_documento AS valor_documento_17,
  t0.withholding AS withholding_18,
  t0.sif_status AS sif_status_19,
  t0.tipo_id AS tipo_id_20,
  t21.id AS id_22,
  t21.total_value AS total_value_23,
  t21.status AS status_24,
  t21.notes AS notes_25,
  t21.offer_date AS offer_date_26,
  t21.purchase_request_id AS purchase_request_id_27,
  t21.invoice_id AS invoice_id_28,
  t0.payment_type_id AS payment_type_id_29,
  t30.id AS id_31,
  t30.nome AS nome_32,
  t30.code AS code_33,
  t30.numeroContribuinte AS numeroContribuinte_34,
  t30.responsavel AS responsavel_35,
  t30.estado AS estado_36,
  t30.type AS type_37,
  t30.email AS email_38,
  t30.enderecoWeb AS enderecoWeb_39,
  t30.endereco AS endereco_40,
  t30.telefone AS telefone_41,
  t30.fax AS fax_42,
  t30.telemovel AS telemovel_43,
  t30.date AS date_44,
  t30.industria_id AS industria_id_45,
  t30.account_id AS account_id_46,
  t30.address_id AS address_id_47,
  t30.invoices_id AS invoices_id_48,
  t0.client_id AS client_id_49,
  t0.moeda_id AS moeda_id_50,
  t0.delivery_note_id AS delivery_note_id_51,
  t0.credit_note_id AS credit_note_id_52,
  t0.invoice_id AS invoice_id_53,
  t0.recipt_id AS recipt_id_54,
  t0.order_reference_id AS order_reference_id_55,
  t0.estado_id AS estado_id_56,
  t0.conta_bancaria_id AS conta_bancaria_id_57,
  t0.warehouse_id AS warehouse_id_58,
  t0.user_id AS user_id_59,
  t0.serial_id AS serial_id_60,
  t0.delivery_term_id AS delivery_term_id_61,
  t0.teller_id AS teller_id_62
FROM
  factura t0
  LEFT JOIN purchase_offer t21 ON t21.invoice_id = t0.id
  LEFT JOIN terceiro t30 ON t30.invoices_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.date AS date_3, t0.docDate AS docDate_4, t0.update_date AS update_date_5, t0.data_vencimento AS data_vencimento_6, t0.serie_id AS serie_id_7, t0.original_print AS original_print_8, t0.validade AS validade_9, t0.desconto AS desconto_10, t0.payed_value AS payed_value_11, t0.obs AS obs_12, t0.hash AS hash_13, t0.re_hash AS re_hash_14, t0.delivery_time AS delivery_time_15, t0.contract AS contract_16, t0.valor_documento AS valor_documento_17, t0.withholding AS withholding_18, t0.sif_status AS sif_status_19, t0.tipo_id AS tipo_id_20, t21.id AS id_22, t21.total_value AS total_value_23, t21.status AS status_24, t21.notes AS notes_25, t21.offer_date AS offer_date_26, t21.purchase_request_id AS purchase_request_id_27, t21.invoice_id AS invoice_id_28, t0.payment_type_id AS payment_type_id_29, t30.id AS id_31, t30.nome AS nome_32, t30.code AS code_33, t30.numeroContribuinte AS numeroContribuinte_34, t30.responsavel AS responsavel_35, t30.estado AS estado_36, t30.type AS type_37, t30.email AS email_38, t30.enderecoWeb AS enderecoWeb_39, t30.endereco AS endereco_40, t30.telefone AS telefone_41, t30.fax AS fax_42, t30.telemovel AS telemovel_43, t30.date AS date_44, t30.industria_id AS industria_id_45, t30.account_id AS account_id_46, t30.address_id AS address_id_47, t30.invoices_id AS invoices_id_48, t0.client_id AS client_id_49, t0.moeda_id AS moeda_id_50, t0.delivery_note_id AS delivery_note_id_51, t0.credit_note_id AS credit_note_id_52, t0.invoice_id AS invoice_id_53, t0.recipt_id AS recipt_id_54, t0.order_reference_id AS order_reference_id_55, t0.estado_id AS estado_id_56, t0.conta_bancaria_id AS conta_bancaria_id_57, t0.warehouse_id AS warehouse_id_58, t0.user_id AS user_id_59, t0.serial_id AS serial_id_60, t0.delivery_term_id AS delivery_term_id_61, t0.teller_id AS teller_id_62 FROM factura t0 LEFT JOIN purchase_offer t21 ON t21.invoice_id = t0.id LEFT JOIN terceiro t30 ON t30.invoices_id = t0.id WHERE t0.id = '23d53e74-eb13-40e6-8c04-192225732276';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.name AS name_4,
  t0.natureza AS natureza_5,
  t0.date AS date_6,
  t0.is_active AS is_active_7,
  t0.account_id AS account_id_8,
  t0.account_class_id AS account_class_id_9,
  t0.user_id AS user_id_10
FROM
  account t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.name AS name_4, t0.natureza AS natureza_5, t0.date AS date_6, t0.is_active AS is_active_7, t0.account_id AS account_id_8, t0.account_class_id AS account_class_id_9, t0.user_id AS user_id_10 FROM account t0 WHERE t0.id = '7d8725f7-0cda-4f1c-948c-c9518fc8c780';

SELECT
  s0_.id AS id_0,
  s0_.series AS series_1,
  s0_.prefix AS prefix_2,
  s0_.sufix AS sufix_3,
  s0_.name AS name_4,
  s0_.year AS year_5,
  s0_.count AS count_6,
  s0_.is_active AS is_active_7,
  s0_.createdAt AS createdAt_8,
  s0_.doc_type_id AS doc_type_id_9,
  s0_.ware_house_id AS ware_house_id_10,
  s0_.user_id AS user_id_11
FROM
  serial s0_
  LEFT JOIN tipo_factura t1_ ON s0_.doc_type_id = t1_.id
WHERE
  t1_.prefix IN (?, ?, ?, ?)
  AND s0_.is_active = 1
ORDER BY
  s0_.year ASC

SELECT s0_.id AS id_0, s0_.series AS series_1, s0_.prefix AS prefix_2, s0_.sufix AS sufix_3, s0_.name AS name_4, s0_.year AS year_5, s0_.count AS count_6, s0_.is_active AS is_active_7, s0_.createdAt AS createdAt_8, s0_.doc_type_id AS doc_type_id_9, s0_.ware_house_id AS ware_house_id_10, s0_.user_id AS user_id_11 FROM serial s0_ LEFT JOIN tipo_factura t1_ ON s0_.doc_type_id = t1_.id WHERE t1_.prefix IN ('PP', 'FT', 'FR', 'FA') AND s0_.is_active = 1 ORDER BY s0_.year ASC;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.date AS date_3,
  t0.docDate AS docDate_4,
  t0.update_date AS update_date_5,
  t0.data_vencimento AS data_vencimento_6,
  t0.serie_id AS serie_id_7,
  t0.original_print AS original_print_8,
  t0.validade AS validade_9,
  t0.desconto AS desconto_10,
  t0.payed_value AS payed_value_11,
  t0.obs AS obs_12,
  t0.hash AS hash_13,
  t0.re_hash AS re_hash_14,
  t0.delivery_time AS delivery_time_15,
  t0.contract AS contract_16,
  t0.valor_documento AS valor_documento_17,
  t0.withholding AS withholding_18,
  t0.sif_status AS sif_status_19,
  t0.tipo_id AS tipo_id_20,
  t21.id AS id_22,
  t21.total_value AS total_value_23,
  t21.status AS status_24,
  t21.notes AS notes_25,
  t21.offer_date AS offer_date_26,
  t21.purchase_request_id AS purchase_request_id_27,
  t21.invoice_id AS invoice_id_28,
  t0.payment_type_id AS payment_type_id_29,
  t30.id AS id_31,
  t30.nome AS nome_32,
  t30.code AS code_33,
  t30.numeroContribuinte AS numeroContribuinte_34,
  t30.responsavel AS responsavel_35,
  t30.estado AS estado_36,
  t30.type AS type_37,
  t30.email AS email_38,
  t30.enderecoWeb AS enderecoWeb_39,
  t30.endereco AS endereco_40,
  t30.telefone AS telefone_41,
  t30.fax AS fax_42,
  t30.telemovel AS telemovel_43,
  t30.date AS date_44,
  t30.industria_id AS industria_id_45,
  t30.account_id AS account_id_46,
  t30.address_id AS address_id_47,
  t30.invoices_id AS invoices_id_48,
  t0.client_id AS client_id_49,
  t0.moeda_id AS moeda_id_50,
  t0.delivery_note_id AS delivery_note_id_51,
  t0.credit_note_id AS credit_note_id_52,
  t0.invoice_id AS invoice_id_53,
  t0.recipt_id AS recipt_id_54,
  t0.order_reference_id AS order_reference_id_55,
  t0.estado_id AS estado_id_56,
  t0.conta_bancaria_id AS conta_bancaria_id_57,
  t0.warehouse_id AS warehouse_id_58,
  t0.user_id AS user_id_59,
  t0.serial_id AS serial_id_60,
  t0.delivery_term_id AS delivery_term_id_61,
  t0.teller_id AS teller_id_62
FROM
  factura t0
  LEFT JOIN purchase_offer t21 ON t21.invoice_id = t0.id
  LEFT JOIN terceiro t30 ON t30.invoices_id = t0.id
WHERE
  t0.recipt_id = ?

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.date AS date_3, t0.docDate AS docDate_4, t0.update_date AS update_date_5, t0.data_vencimento AS data_vencimento_6, t0.serie_id AS serie_id_7, t0.original_print AS original_print_8, t0.validade AS validade_9, t0.desconto AS desconto_10, t0.payed_value AS payed_value_11, t0.obs AS obs_12, t0.hash AS hash_13, t0.re_hash AS re_hash_14, t0.delivery_time AS delivery_time_15, t0.contract AS contract_16, t0.valor_documento AS valor_documento_17, t0.withholding AS withholding_18, t0.sif_status AS sif_status_19, t0.tipo_id AS tipo_id_20, t21.id AS id_22, t21.total_value AS total_value_23, t21.status AS status_24, t21.notes AS notes_25, t21.offer_date AS offer_date_26, t21.purchase_request_id AS purchase_request_id_27, t21.invoice_id AS invoice_id_28, t0.payment_type_id AS payment_type_id_29, t30.id AS id_31, t30.nome AS nome_32, t30.code AS code_33, t30.numeroContribuinte AS numeroContribuinte_34, t30.responsavel AS responsavel_35, t30.estado AS estado_36, t30.type AS type_37, t30.email AS email_38, t30.enderecoWeb AS enderecoWeb_39, t30.endereco AS endereco_40, t30.telefone AS telefone_41, t30.fax AS fax_42, t30.telemovel AS telemovel_43, t30.date AS date_44, t30.industria_id AS industria_id_45, t30.account_id AS account_id_46, t30.address_id AS address_id_47, t30.invoices_id AS invoices_id_48, t0.client_id AS client_id_49, t0.moeda_id AS moeda_id_50, t0.delivery_note_id AS delivery_note_id_51, t0.credit_note_id AS credit_note_id_52, t0.invoice_id AS invoice_id_53, t0.recipt_id AS recipt_id_54, t0.order_reference_id AS order_reference_id_55, t0.estado_id AS estado_id_56, t0.conta_bancaria_id AS conta_bancaria_id_57, t0.warehouse_id AS warehouse_id_58, t0.user_id AS user_id_59, t0.serial_id AS serial_id_60, t0.delivery_term_id AS delivery_term_id_61, t0.teller_id AS teller_id_62 FROM factura t0 LEFT JOIN purchase_offer t21 ON t21.invoice_id = t0.id LEFT JOIN terceiro t30 ON t30.invoices_id = t0.id WHERE t0.recipt_id = '23d53e74-eb13-40e6-8c04-192225732276';

SELECT
  t0.id AS id_1,
  t0.quantidade AS quantidade_2,
  t0.code AS code_3,
  t0.tipo AS tipo_4,
  t0.preco AS preco_5,
  t0.aditionalTax AS aditionalTax_6,
  t0.movimentaStock AS movimentaStock_7,
  t0.desconto AS desconto_8,
  t0.imposto AS imposto_9,
  t0.descricao AS descricao_10,
  t0.nome AS nome_11,
  t0.servico AS servico_12,
  t0.withholding AS withholding_13,
  t0.name AS name_14,
  t0.factura_id AS factura_id_15,
  t0.artigo_id AS artigo_id_16,
  t0.iva_id AS iva_id_17,
  t0.tax_exemption_id AS tax_exemption_id_18
FROM
  artigo_factura t0
WHERE
  t0.factura_id = ?
ORDER BY
  t0.name DESC

SELECT t0.id AS id_1, t0.quantidade AS quantidade_2, t0.code AS code_3, t0.tipo AS tipo_4, t0.preco AS preco_5, t0.aditionalTax AS aditionalTax_6, t0.movimentaStock AS movimentaStock_7, t0.desconto AS desconto_8, t0.imposto AS imposto_9, t0.descricao AS descricao_10, t0.nome AS nome_11, t0.servico AS servico_12, t0.withholding AS withholding_13, t0.name AS name_14, t0.factura_id AS factura_id_15, t0.artigo_id AS artigo_id_16, t0.iva_id AS iva_id_17, t0.tax_exemption_id AS tax_exemption_id_18 FROM artigo_factura t0 WHERE t0.factura_id = '23d53e74-eb13-40e6-8c04-192225732276' ORDER BY t0.name DESC;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.name AS name_3,
  t0.invoices AS invoices_4,
  t0.amount AS amount_5,
  t0.wareHouses AS wareHouses_6,
  t0.supplies AS supplies_7,
  t0.users AS users_8,
  t0.accounting AS accounting_9,
  t0.auditing AS auditing_10,
  t0.pos AS pos_11,
  t0.reports AS reports_12,
  t0.dayly_back_ups AS dayly_back_ups_13,
  t0.date AS date_14,
  t0.due_date AS due_date_15,
  t0.license AS license_16,
  t0.company_id AS company_id_17
FROM
  plan_counter t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.due_date DESC

SELECT t0.id AS id_1, t0.price AS price_2, t0.name AS name_3, t0.invoices AS invoices_4, t0.amount AS amount_5, t0.wareHouses AS wareHouses_6, t0.supplies AS supplies_7, t0.users AS users_8, t0.accounting AS accounting_9, t0.auditing AS auditing_10, t0.pos AS pos_11, t0.reports AS reports_12, t0.dayly_back_ups AS dayly_back_ups_13, t0.date AS date_14, t0.due_date AS due_date_15, t0.license AS license_16, t0.company_id AS company_id_17 FROM plan_counter t0 WHERE t0.company_id = 'b07ad383-e03a-48f5-95c8-7b62770e680f' ORDER BY t0.due_date DESC;

SELECT
  f0_.id AS id_0,
  f0_.codigo AS codigo_1,
  f0_.date AS date_2,
  f0_.docDate AS docDate_3,
  f0_.update_date AS update_date_4,
  f0_.data_vencimento AS data_vencimento_5,
  f0_.serie_id AS serie_id_6,
  f0_.original_print AS original_print_7,
  f0_.validade AS validade_8,
  f0_.desconto AS desconto_9,
  f0_.payed_value AS payed_value_10,
  f0_.obs AS obs_11,
  f0_.hash AS hash_12,
  f0_.re_hash AS re_hash_13,
  f0_.delivery_time AS delivery_time_14,
  f0_.contract AS contract_15,
  f0_.valor_documento AS valor_documento_16,
  f0_.withholding AS withholding_17,
  f0_.sif_status AS sif_status_18,
  f0_.tipo_id AS tipo_id_19,
  f0_.payment_type_id AS payment_type_id_20,
  f0_.client_id AS client_id_21,
  f0_.moeda_id AS moeda_id_22,
  f0_.delivery_note_id AS delivery_note_id_23,
  f0_.credit_note_id AS credit_note_id_24,
  f0_.invoice_id AS invoice_id_25,
  f0_.recipt_id AS recipt_id_26,
  f0_.order_reference_id AS order_reference_id_27,
  f0_.estado_id AS estado_id_28,
  f0_.conta_bancaria_id AS conta_bancaria_id_29,
  f0_.warehouse_id AS warehouse_id_30,
  f0_.user_id AS user_id_31,
  f0_.serial_id AS serial_id_32,
  f0_.delivery_term_id AS delivery_term_id_33,
  f0_.teller_id AS teller_id_34
FROM
  factura f0_
WHERE
  f0_.date <= ?
  AND f0_.id <> ?
ORDER BY
  f0_.date DESC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.codigo AS codigo_1, f0_.date AS date_2, f0_.docDate AS docDate_3, f0_.update_date AS update_date_4, f0_.data_vencimento AS data_vencimento_5, f0_.serie_id AS serie_id_6, f0_.original_print AS original_print_7, f0_.validade AS validade_8, f0_.desconto AS desconto_9, f0_.payed_value AS payed_value_10, f0_.obs AS obs_11, f0_.hash AS hash_12, f0_.re_hash AS re_hash_13, f0_.delivery_time AS delivery_time_14, f0_.contract AS contract_15, f0_.valor_documento AS valor_documento_16, f0_.withholding AS withholding_17, f0_.sif_status AS sif_status_18, f0_.tipo_id AS tipo_id_19, f0_.payment_type_id AS payment_type_id_20, f0_.client_id AS client_id_21, f0_.moeda_id AS moeda_id_22, f0_.delivery_note_id AS delivery_note_id_23, f0_.credit_note_id AS credit_note_id_24, f0_.invoice_id AS invoice_id_25, f0_.recipt_id AS recipt_id_26, f0_.order_reference_id AS order_reference_id_27, f0_.estado_id AS estado_id_28, f0_.conta_bancaria_id AS conta_bancaria_id_29, f0_.warehouse_id AS warehouse_id_30, f0_.user_id AS user_id_31, f0_.serial_id AS serial_id_32, f0_.delivery_term_id AS delivery_term_id_33, f0_.teller_id AS teller_id_34 FROM factura f0_ WHERE f0_.date <= '2026-04-13 12:18:59' AND f0_.id <> '23d53e74-eb13-40e6-8c04-192225732276' ORDER BY f0_.date DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.code AS code_3,
  t0.numeroContribuinte AS numeroContribuinte_4,
  t0.responsavel AS responsavel_5,
  t0.estado AS estado_6,
  t0.email AS email_7,
  t0.enderecoWeb AS enderecoWeb_8,
  t0.endereco AS endereco_9,
  t0.codigoPostal AS codigoPostal_10,
  t0.telefone AS telefone_11,
  t0.fax AS fax_12,
  t0.telemovel AS telemovel_13,
  t0.date AS date_14,
  t0.grupo_id AS grupo_id_15,
  t0.tipo_id AS tipo_id_16,
  t0.industria_id AS industria_id_17,
  t0.address_id AS address_id_18,
  t0.pais_id AS pais_id_19,
  t20.id AS id_21,
  t20.codigo AS codigo_22,
  t20.date AS date_23,
  t20.docDate AS docDate_24,
  t20.update_date AS update_date_25,
  t20.data_vencimento AS data_vencimento_26,
  t20.serie_id AS serie_id_27,
  t20.original_print AS original_print_28,
  t20.validade AS validade_29,
  t20.desconto AS desconto_30,
  t20.payed_value AS payed_value_31,
  t20.obs AS obs_32,
  t20.hash AS hash_33,
  t20.re_hash AS re_hash_34,
  t20.delivery_time AS delivery_time_35,
  t20.contract AS contract_36,
  t20.valor_documento AS valor_documento_37,
  t20.withholding AS withholding_38,
  t20.sif_status AS sif_status_39,
  t20.tipo_id AS tipo_id_40,
  t20.payment_type_id AS payment_type_id_41,
  t20.client_id AS client_id_42,
  t20.moeda_id AS moeda_id_43,
  t20.delivery_note_id AS delivery_note_id_44,
  t20.credit_note_id AS credit_note_id_45,
  t20.invoice_id AS invoice_id_46,
  t20.recipt_id AS recipt_id_47,
  t20.order_reference_id AS order_reference_id_48,
  t20.estado_id AS estado_id_49,
  t20.conta_bancaria_id AS conta_bancaria_id_50,
  t20.warehouse_id AS warehouse_id_51,
  t20.user_id AS user_id_52,
  t20.serial_id AS serial_id_53,
  t20.delivery_term_id AS delivery_term_id_54,
  t20.teller_id AS teller_id_55,
  t0.client_id AS client_id_56
FROM
  invoice_client t0
  LEFT JOIN factura t20 ON t20.client_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.code AS code_3, t0.numeroContribuinte AS numeroContribuinte_4, t0.responsavel AS responsavel_5, t0.estado AS estado_6, t0.email AS email_7, t0.enderecoWeb AS enderecoWeb_8, t0.endereco AS endereco_9, t0.codigoPostal AS codigoPostal_10, t0.telefone AS telefone_11, t0.fax AS fax_12, t0.telemovel AS telemovel_13, t0.date AS date_14, t0.grupo_id AS grupo_id_15, t0.tipo_id AS tipo_id_16, t0.industria_id AS industria_id_17, t0.address_id AS address_id_18, t0.pais_id AS pais_id_19, t20.id AS id_21, t20.codigo AS codigo_22, t20.date AS date_23, t20.docDate AS docDate_24, t20.update_date AS update_date_25, t20.data_vencimento AS data_vencimento_26, t20.serie_id AS serie_id_27, t20.original_print AS original_print_28, t20.validade AS validade_29, t20.desconto AS desconto_30, t20.payed_value AS payed_value_31, t20.obs AS obs_32, t20.hash AS hash_33, t20.re_hash AS re_hash_34, t20.delivery_time AS delivery_time_35, t20.contract AS contract_36, t20.valor_documento AS valor_documento_37, t20.withholding AS withholding_38, t20.sif_status AS sif_status_39, t20.tipo_id AS tipo_id_40, t20.payment_type_id AS payment_type_id_41, t20.client_id AS client_id_42, t20.moeda_id AS moeda_id_43, t20.delivery_note_id AS delivery_note_id_44, t20.credit_note_id AS credit_note_id_45, t20.invoice_id AS invoice_id_46, t20.recipt_id AS recipt_id_47, t20.order_reference_id AS order_reference_id_48, t20.estado_id AS estado_id_49, t20.conta_bancaria_id AS conta_bancaria_id_50, t20.warehouse_id AS warehouse_id_51, t20.user_id AS user_id_52, t20.serial_id AS serial_id_53, t20.delivery_term_id AS delivery_term_id_54, t20.teller_id AS teller_id_55, t0.client_id AS client_id_56 FROM invoice_client t0 LEFT JOIN factura t20 ON t20.client_id = t0.id WHERE t0.id = 'c5cbdaec-c9e4-480c-addb-49ef9c4fe7c5';

SELECT
  t0_.id AS id_0,
  t0_.nome AS nome_1,
  t0_.code AS code_2,
  t0_.prefix AS prefix_3,
  t0_.validade AS validade_4,
  t0_.descricao AS descricao_5,
  t0_.documentgroup_id AS documentgroup_id_6
FROM
  tipo_factura t0_
  LEFT JOIN document_group d1_ ON t0_.documentgroup_id = d1_.id
WHERE
  t0_.code <> 8
  AND t0_.code <> 12
  AND t0_.validade < 32
ORDER BY
  t0_.nome ASC

SELECT t0_.id AS id_0, t0_.nome AS nome_1, t0_.code AS code_2, t0_.prefix AS prefix_3, t0_.validade AS validade_4, t0_.descricao AS descricao_5, t0_.documentgroup_id AS documentgroup_id_6 FROM tipo_factura t0_ LEFT JOIN document_group d1_ ON t0_.documentgroup_id = d1_.id WHERE t0_.code <> 8 AND t0_.code <> 12 AND t0_.validade < 32 ORDER BY t0_.nome ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.reference AS reference_3,
  t0.message AS message_4,
  t0.status AS status_5,
  t0.type AS type_6,
  t0.description AS description_7,
  t0.created_at AS created_at_8,
  t0.metadata AS metadata_9,
  t0.invoice_id AS invoice_id_10,
  t0.user_id AS user_id_11
FROM
  invoice_history t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.reference AS reference_3, t0.message AS message_4, t0.status AS status_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.metadata AS metadata_9, t0.invoice_id AS invoice_id_10, t0.user_id AS user_id_11 FROM invoice_history t0 WHERE t0.invoice_id = '23d53e74-eb13-40e6-8c04-192225732276' ORDER BY t0.created_at DESC;