Symfony Profiler

SELECT
  t0.creation_date AS creation_date_1,
  t0.date_update AS date_update_2,
  t0.id AS id_3,
  t0.emition_date AS emition_date_4,
  t0.motive AS motive_5,
  t0.total_without_tax AS total_without_tax_6,
  t0.total_discount AS total_discount_7,
  t0.total AS total_8,
  t0.sri_info_id AS sri_info_id_9,
  t0.client_id AS client_id_10,
  t0.invoice_id AS invoice_id_11,
  t0.sri_document_id AS sri_document_id_12,
  t0.user_id AS user_id_13,
  t0.sucursal_id AS sucursal_id_14
FROM
  credit_note t0
WHERE
  t0.sri_document_id = ?

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.emition_date AS emition_date_4, t0.motive AS motive_5, t0.total_without_tax AS total_without_tax_6, t0.total_discount AS total_discount_7, t0.total AS total_8, t0.sri_info_id AS sri_info_id_9, t0.client_id AS client_id_10, t0.invoice_id AS invoice_id_11, t0.sri_document_id AS sri_document_id_12, t0.user_id AS user_id_13, t0.sucursal_id AS sucursal_id_14 FROM credit_note t0 WHERE t0.sri_document_id = 23711;

SELECT
  t0.creation_date AS creation_date_1,
  t0.date_update AS date_update_2,
  t0.id AS id_3,
  t0.emit_date AS emit_date_4,
  t0.total AS total_5,
  t0.total_without_tax AS total_without_tax_6,
  t0.total_discount AS total_discount_7,
  t0.provider_id AS provider_id_8,
  t0.company_id AS company_id_9,
  t0.sucursal_id AS sucursal_id_10,
  t0.user_id AS user_id_11,
  t0.sri_document_id AS sri_document_id_12
FROM
  liquidacion_compra t0
WHERE
  t0.sri_document_id = ?

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.emit_date AS emit_date_4, t0.total AS total_5, t0.total_without_tax AS total_without_tax_6, t0.total_discount AS total_discount_7, t0.provider_id AS provider_id_8, t0.company_id AS company_id_9, t0.sucursal_id AS sucursal_id_10, t0.user_id AS user_id_11, t0.sri_document_id AS sri_document_id_12 FROM liquidacion_compra t0 WHERE t0.sri_document_id = 23711;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  retencion r0_
  LEFT JOIN sri_document s1_ ON r0_.id = s1_.retention_id
  LEFT JOIN doc_sustento d2_ ON r0_.id = d2_.retencion_id
WHERE
  r0_.sri_info_id = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM retencion r0_ LEFT JOIN sri_document s1_ ON r0_.id = s1_.retention_id LEFT JOIN doc_sustento d2_ ON r0_.id = d2_.retencion_id WHERE r0_.sri_info_id = 16;

SELECT
  r0_.creation_date AS creation_date_0,
  r0_.date_update AS date_update_1,
  r0_.id AS id_2,
  r0_.fecha_emision AS fecha_emision_3,
  r0_.tipo_identificacion_sujeto AS tipo_identificacion_sujeto_4,
  r0_.razon_social_sujeto AS razon_social_sujeto_5,
  r0_.identificacion_sujeto AS identificacion_sujeto_6,
  r0_.periodo_fiscal AS periodo_fiscal_7,
  r0_.concept AS concept_8,
  r0_.tax_amount AS tax_amount_9,
  r0_.retencion_iva AS retencion_iva_10,
  r0_.dates104 AS dates104_11,
  r0_.doc_related_type AS doc_related_type_12,
  r0_.doc_related_date AS doc_related_date_13,
  r0_.doc_related_serie AS doc_related_serie_14,
  r0_.doc_related_sequence AS doc_related_sequence_15,
  r0_.doc_related_auth AS doc_related_auth_16,
  r0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_17,
  r0_.parte_rel AS parte_rel_18,
  s1_.id AS id_19,
  s1_.clave_accesso AS clave_accesso_20,
  s1_.secuencial AS secuencial_21,
  s1_.estado AS estado_22,
  s1_.error AS error_23,
  s1_.serie1 AS serie1_24,
  s1_.serie2 AS serie2_25,
  s1_.cancel AS cancel_26,
  s1_.has_fetch_error AS has_fetch_error_27,
  d2_.id AS id_28,
  d2_.cod_sustento AS cod_sustento_29,
  d2_.cod_doc_sustento AS cod_doc_sustento_30,
  d2_.num_doc_sustento AS num_doc_sustento_31,
  d2_.fecha_emision_doc_sustento AS fecha_emision_doc_sustento_32,
  d2_.num_aut_doc_sustento AS num_aut_doc_sustento_33,
  d2_.total_sin_impuestos AS total_sin_impuestos_34,
  d2_.total AS total_35,
  d2_.pago_loc_ext AS pago_loc_ext_36,
  d2_.other_value AS other_value_37,
  d2_.fecha_caducidad AS fecha_caducidad_38,
  r0_.sri_info_id AS sri_info_id_39,
  r0_.created_by_id AS created_by_id_40,
  r0_.sucursal_id AS sucursal_id_41,
  r0_.provider_id AS provider_id_42,
  r0_.import_id AS import_id_43,
  s1_.invoice_id AS invoice_id_44,
  s1_.retention_id AS retention_id_45,
  s1_.remission_guide_id AS remission_guide_id_46,
  s1_.debit_note_id AS debit_note_id_47,
  d2_.retencion_id AS retencion_id_48,
  d2_.pago_loc_id AS pago_loc_id_49
FROM
  retencion r0_
  LEFT JOIN sri_document s1_ ON r0_.id = s1_.retention_id
  LEFT JOIN doc_sustento d2_ ON r0_.id = d2_.retencion_id
WHERE
  r0_.sri_info_id = ?
ORDER BY
  r0_.id DESC
LIMIT
  20

SELECT r0_.creation_date AS creation_date_0, r0_.date_update AS date_update_1, r0_.id AS id_2, r0_.fecha_emision AS fecha_emision_3, r0_.tipo_identificacion_sujeto AS tipo_identificacion_sujeto_4, r0_.razon_social_sujeto AS razon_social_sujeto_5, r0_.identificacion_sujeto AS identificacion_sujeto_6, r0_.periodo_fiscal AS periodo_fiscal_7, r0_.concept AS concept_8, r0_.tax_amount AS tax_amount_9, r0_.retencion_iva AS retencion_iva_10, r0_.dates104 AS dates104_11, r0_.doc_related_type AS doc_related_type_12, r0_.doc_related_date AS doc_related_date_13, r0_.doc_related_serie AS doc_related_serie_14, r0_.doc_related_sequence AS doc_related_sequence_15, r0_.doc_related_auth AS doc_related_auth_16, r0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_17, r0_.parte_rel AS parte_rel_18, s1_.id AS id_19, s1_.clave_accesso AS clave_accesso_20, s1_.secuencial AS secuencial_21, s1_.estado AS estado_22, s1_.error AS error_23, s1_.serie1 AS serie1_24, s1_.serie2 AS serie2_25, s1_.cancel AS cancel_26, s1_.has_fetch_error AS has_fetch_error_27, d2_.id AS id_28, d2_.cod_sustento AS cod_sustento_29, d2_.cod_doc_sustento AS cod_doc_sustento_30, d2_.num_doc_sustento AS num_doc_sustento_31, d2_.fecha_emision_doc_sustento AS fecha_emision_doc_sustento_32, d2_.num_aut_doc_sustento AS num_aut_doc_sustento_33, d2_.total_sin_impuestos AS total_sin_impuestos_34, d2_.total AS total_35, d2_.pago_loc_ext AS pago_loc_ext_36, d2_.other_value AS other_value_37, d2_.fecha_caducidad AS fecha_caducidad_38, r0_.sri_info_id AS sri_info_id_39, r0_.created_by_id AS created_by_id_40, r0_.sucursal_id AS sucursal_id_41, r0_.provider_id AS provider_id_42, r0_.import_id AS import_id_43, s1_.invoice_id AS invoice_id_44, s1_.retention_id AS retention_id_45, s1_.remission_guide_id AS remission_guide_id_46, s1_.debit_note_id AS debit_note_id_47, d2_.retencion_id AS retencion_id_48, d2_.pago_loc_id AS pago_loc_id_49 FROM retencion r0_ LEFT JOIN sri_document s1_ ON r0_.id = s1_.retention_id LEFT JOIN doc_sustento d2_ ON r0_.id = d2_.retencion_id WHERE r0_.sri_info_id = 16 ORDER BY r0_.id DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.razon_social AS razon_social_2,
  t0.ruc AS ruc_3,
  t0.direction AS direction_4,
  t0.email AS email_5,
  t0.serie1 AS serie1_6,
  t0.serie2 AS serie2_7,
  t0.obligado_contabilidad AS obligado_contabilidad_8,
  t0.logo AS logo_9,
  t0.agente_retencion AS agente_retencion_10,
  t0.contribuyente_rimpe AS contribuyente_rimpe_11,
  t0.contribuyente_especial AS contribuyente_especial_12,
  t0.contribuyente_rimpe_text AS contribuyente_rimpe_text_13,
  t0.phone AS phone_14,
  t0.iess AS iess_15,
  t0.period103 AS period103_16,
  t0.user_id AS user_id_17,
  t0.certificate_id AS certificate_id_18,
  t19.id AS id_20,
  t19.company_created AS company_created_21,
  t19.sri_info_id AS sri_info_id_22,
  t23.id AS id_24,
  t23.host AS host_25,
  t23.email AS email_26,
  t23.password AS password_27,
  t23.name AS name_28,
  t23.port AS port_29,
  t23.auto_send AS auto_send_30,
  t23.sri_info_id AS sri_info_id_31,
  t32.id AS id_33,
  t32.show_transporter AS show_transporter_34,
  t32.sucursal_limit AS sucursal_limit_35,
  t32.should_print332_pdf AS should_print332_pdf_36,
  t32.company_id AS company_id_37,
  t0.disabled_by_id AS disabled_by_id_38,
  t39.id AS id_40,
  t39.email AS email_41,
  t39.sri_info_id AS sri_info_id_42
FROM
  sri_info t0
  LEFT JOIN sri_edwin t19 ON t19.sri_info_id = t0.id
  LEFT JOIN email_configuration t23 ON t23.sri_info_id = t0.id
  LEFT JOIN saas_configuration t32 ON t32.company_id = t0.id
  LEFT JOIN email_extra_config t39 ON t39.sri_info_id = t0.id
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.razon_social AS razon_social_2, t0.ruc AS ruc_3, t0.direction AS direction_4, t0.email AS email_5, t0.serie1 AS serie1_6, t0.serie2 AS serie2_7, t0.obligado_contabilidad AS obligado_contabilidad_8, t0.logo AS logo_9, t0.agente_retencion AS agente_retencion_10, t0.contribuyente_rimpe AS contribuyente_rimpe_11, t0.contribuyente_especial AS contribuyente_especial_12, t0.contribuyente_rimpe_text AS contribuyente_rimpe_text_13, t0.phone AS phone_14, t0.iess AS iess_15, t0.period103 AS period103_16, t0.user_id AS user_id_17, t0.certificate_id AS certificate_id_18, t19.id AS id_20, t19.company_created AS company_created_21, t19.sri_info_id AS sri_info_id_22, t23.id AS id_24, t23.host AS host_25, t23.email AS email_26, t23.password AS password_27, t23.name AS name_28, t23.port AS port_29, t23.auto_send AS auto_send_30, t23.sri_info_id AS sri_info_id_31, t32.id AS id_33, t32.show_transporter AS show_transporter_34, t32.sucursal_limit AS sucursal_limit_35, t32.should_print332_pdf AS should_print332_pdf_36, t32.company_id AS company_id_37, t0.disabled_by_id AS disabled_by_id_38, t39.id AS id_40, t39.email AS email_41, t39.sri_info_id AS sri_info_id_42 FROM sri_info t0 LEFT JOIN sri_edwin t19 ON t19.sri_info_id = t0.id LEFT JOIN email_configuration t23 ON t23.sri_info_id = t0.id LEFT JOIN saas_configuration t32 ON t32.company_id = t0.id LEFT JOIN email_extra_config t39 ON t39.sri_info_id = t0.id WHERE t0.user_id = 26;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.name AS name_6,
  t0.lastname AS lastname_7,
  t0.reset_password_key AS reset_password_key_8,
  t9.id AS id_10,
  t9.phone AS phone_11,
  t9.can_report_main_sucursal AS can_report_main_sucursal_12,
  t9.user_id AS user_id_13,
  t9.sri_info_id AS sri_info_id_14,
  t9.sucursal_id AS sucursal_id_15,
  t0.disabled_by_id AS disabled_by_id_16
FROM
  user t0
  LEFT JOIN employee t9 ON t9.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.name AS name_6, t0.lastname AS lastname_7, t0.reset_password_key AS reset_password_key_8, t9.id AS id_10, t9.phone AS phone_11, t9.can_report_main_sucursal AS can_report_main_sucursal_12, t9.user_id AS user_id_13, t9.sri_info_id AS sri_info_id_14, t9.sucursal_id AS sucursal_id_15, t0.disabled_by_id AS disabled_by_id_16 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.id = 26;