Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.doc_type AS doc_type_2,
  t0.period AS period_3,
  t0.total AS total_4,
  t0.sealed AS sealed_5,
  t0.saas_configuration_id AS saas_configuration_id_6
FROM
  saas_doc_allowed t0
WHERE
  t0.doc_type = ?
  AND t0.saas_configuration_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.doc_type AS doc_type_2, t0.period AS period_3, t0.total AS total_4, t0.sealed AS sealed_5, t0.saas_configuration_id AS saas_configuration_id_6 FROM saas_doc_allowed t0 WHERE t0.doc_type = 'factura' AND t0.saas_configuration_id = 13 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod_sustento AS cod_sustento_2,
  t0.cod_doc_sustento AS cod_doc_sustento_3,
  t0.num_doc_sustento AS num_doc_sustento_4,
  t0.fecha_emision_doc_sustento AS fecha_emision_doc_sustento_5,
  t0.num_aut_doc_sustento AS num_aut_doc_sustento_6,
  t0.total_sin_impuestos AS total_sin_impuestos_7,
  t0.total AS total_8,
  t0.pago_loc_ext AS pago_loc_ext_9,
  t0.other_value AS other_value_10,
  t0.fecha_caducidad AS fecha_caducidad_11,
  t0.retencion_id AS retencion_id_12,
  t0.pago_loc_id AS pago_loc_id_13
FROM
  doc_sustento t0
WHERE
  t0.retencion_id IN (?)

SELECT t0.id AS id_1, t0.cod_sustento AS cod_sustento_2, t0.cod_doc_sustento AS cod_doc_sustento_3, t0.num_doc_sustento AS num_doc_sustento_4, t0.fecha_emision_doc_sustento AS fecha_emision_doc_sustento_5, t0.num_aut_doc_sustento AS num_aut_doc_sustento_6, t0.total_sin_impuestos AS total_sin_impuestos_7, t0.total AS total_8, t0.pago_loc_ext AS pago_loc_ext_9, t0.other_value AS other_value_10, t0.fecha_caducidad AS fecha_caducidad_11, t0.retencion_id AS retencion_id_12, t0.pago_loc_id AS pago_loc_id_13 FROM doc_sustento t0 WHERE t0.retencion_id IN (20589);

SELECT
  t0.creation_date AS creation_date_1,
  t0.date_update AS date_update_2,
  t0.id AS id_3,
  t0.fecha_emision AS fecha_emision_4,
  t0.tipo_identificacion_sujeto AS tipo_identificacion_sujeto_5,
  t0.razon_social_sujeto AS razon_social_sujeto_6,
  t0.identificacion_sujeto AS identificacion_sujeto_7,
  t0.periodo_fiscal AS periodo_fiscal_8,
  t0.concept AS concept_9,
  t0.tax_amount AS tax_amount_10,
  t0.retencion_iva AS retencion_iva_11,
  t0.dates104 AS dates104_12,
  t0.doc_related_type AS doc_related_type_13,
  t0.doc_related_date AS doc_related_date_14,
  t0.doc_related_serie AS doc_related_serie_15,
  t0.doc_related_sequence AS doc_related_sequence_16,
  t0.doc_related_auth AS doc_related_auth_17,
  t0.tipo_sujeto_retenido AS tipo_sujeto_retenido_18,
  t0.parte_rel AS parte_rel_19,
  t0.sri_info_id AS sri_info_id_20,
  t0.created_by_id AS created_by_id_21,
  t22.id AS id_23,
  t22.clave_accesso AS clave_accesso_24,
  t22.secuencial AS secuencial_25,
  t22.estado AS estado_26,
  t22.error AS error_27,
  t22.serie1 AS serie1_28,
  t22.serie2 AS serie2_29,
  t22.cancel AS cancel_30,
  t22.has_fetch_error AS has_fetch_error_31,
  t22.invoice_id AS invoice_id_32,
  t22.retention_id AS retention_id_33,
  t22.remission_guide_id AS remission_guide_id_34,
  t22.debit_note_id AS debit_note_id_35,
  t0.sucursal_id AS sucursal_id_36,
  t0.provider_id AS provider_id_37,
  t0.import_id AS import_id_38
FROM
  retencion t0
  LEFT JOIN sri_document t22 ON t22.retention_id = t0.id
WHERE
  t0.id = ?

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.fecha_emision AS fecha_emision_4, t0.tipo_identificacion_sujeto AS tipo_identificacion_sujeto_5, t0.razon_social_sujeto AS razon_social_sujeto_6, t0.identificacion_sujeto AS identificacion_sujeto_7, t0.periodo_fiscal AS periodo_fiscal_8, t0.concept AS concept_9, t0.tax_amount AS tax_amount_10, t0.retencion_iva AS retencion_iva_11, t0.dates104 AS dates104_12, t0.doc_related_type AS doc_related_type_13, t0.doc_related_date AS doc_related_date_14, t0.doc_related_serie AS doc_related_serie_15, t0.doc_related_sequence AS doc_related_sequence_16, t0.doc_related_auth AS doc_related_auth_17, t0.tipo_sujeto_retenido AS tipo_sujeto_retenido_18, t0.parte_rel AS parte_rel_19, t0.sri_info_id AS sri_info_id_20, t0.created_by_id AS created_by_id_21, t22.id AS id_23, t22.clave_accesso AS clave_accesso_24, t22.secuencial AS secuencial_25, t22.estado AS estado_26, t22.error AS error_27, t22.serie1 AS serie1_28, t22.serie2 AS serie2_29, t22.cancel AS cancel_30, t22.has_fetch_error AS has_fetch_error_31, t22.invoice_id AS invoice_id_32, t22.retention_id AS retention_id_33, t22.remission_guide_id AS remission_guide_id_34, t22.debit_note_id AS debit_note_id_35, t0.sucursal_id AS sucursal_id_36, t0.provider_id AS provider_id_37, t0.import_id AS import_id_38 FROM retencion t0 LEFT JOIN sri_document t22 ON t22.retention_id = t0.id WHERE t0.id = '20589';

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 = 25;

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,
  r0_.sri_info_id AS sri_info_id_19,
  r0_.created_by_id AS created_by_id_20,
  r0_.sucursal_id AS sucursal_id_21,
  r0_.provider_id AS provider_id_22,
  r0_.import_id AS import_id_23
FROM
  retencion r0_
WHERE
  r0_.id < ?
  AND r0_.sri_info_id = ?
ORDER BY
  r0_.id DESC
LIMIT
  1

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, r0_.sri_info_id AS sri_info_id_19, r0_.created_by_id AS created_by_id_20, r0_.sucursal_id AS sucursal_id_21, r0_.provider_id AS provider_id_22, r0_.import_id AS import_id_23 FROM retencion r0_ WHERE r0_.id < 20589 AND r0_.sri_info_id = 15 ORDER BY r0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.clave_accesso AS clave_accesso_2,
  t0.secuencial AS secuencial_3,
  t0.estado AS estado_4,
  t0.error AS error_5,
  t0.serie1 AS serie1_6,
  t0.serie2 AS serie2_7,
  t0.cancel AS cancel_8,
  t0.has_fetch_error AS has_fetch_error_9,
  t0.invoice_id AS invoice_id_10,
  t0.retention_id AS retention_id_11,
  t12.creation_date AS creation_date_13,
  t12.date_update AS date_update_14,
  t12.id AS id_15,
  t12.emition_date AS emition_date_16,
  t12.motive AS motive_17,
  t12.total_without_tax AS total_without_tax_18,
  t12.total_discount AS total_discount_19,
  t12.total AS total_20,
  t12.sri_info_id AS sri_info_id_21,
  t12.client_id AS client_id_22,
  t12.invoice_id AS invoice_id_23,
  t12.sri_document_id AS sri_document_id_24,
  t12.user_id AS user_id_25,
  t12.sucursal_id AS sucursal_id_26,
  t0.remission_guide_id AS remission_guide_id_27,
  t0.debit_note_id AS debit_note_id_28,
  t29.creation_date AS creation_date_30,
  t29.date_update AS date_update_31,
  t29.id AS id_32,
  t29.emit_date AS emit_date_33,
  t29.total AS total_34,
  t29.total_without_tax AS total_without_tax_35,
  t29.total_discount AS total_discount_36,
  t29.provider_id AS provider_id_37,
  t29.company_id AS company_id_38,
  t29.sucursal_id AS sucursal_id_39,
  t29.user_id AS user_id_40,
  t29.sri_document_id AS sri_document_id_41
FROM
  sri_document t0
  LEFT JOIN credit_note t12 ON t12.sri_document_id = t0.id
  LEFT JOIN liquidacion_compra t29 ON t29.sri_document_id = t0.id
WHERE
  t0.retention_id = ?

SELECT t0.id AS id_1, t0.clave_accesso AS clave_accesso_2, t0.secuencial AS secuencial_3, t0.estado AS estado_4, t0.error AS error_5, t0.serie1 AS serie1_6, t0.serie2 AS serie2_7, t0.cancel AS cancel_8, t0.has_fetch_error AS has_fetch_error_9, t0.invoice_id AS invoice_id_10, t0.retention_id AS retention_id_11, t12.creation_date AS creation_date_13, t12.date_update AS date_update_14, t12.id AS id_15, t12.emition_date AS emition_date_16, t12.motive AS motive_17, t12.total_without_tax AS total_without_tax_18, t12.total_discount AS total_discount_19, t12.total AS total_20, t12.sri_info_id AS sri_info_id_21, t12.client_id AS client_id_22, t12.invoice_id AS invoice_id_23, t12.sri_document_id AS sri_document_id_24, t12.user_id AS user_id_25, t12.sucursal_id AS sucursal_id_26, t0.remission_guide_id AS remission_guide_id_27, t0.debit_note_id AS debit_note_id_28, t29.creation_date AS creation_date_30, t29.date_update AS date_update_31, t29.id AS id_32, t29.emit_date AS emit_date_33, t29.total AS total_34, t29.total_without_tax AS total_without_tax_35, t29.total_discount AS total_discount_36, t29.provider_id AS provider_id_37, t29.company_id AS company_id_38, t29.sucursal_id AS sucursal_id_39, t29.user_id AS user_id_40, t29.sri_document_id AS sri_document_id_41 FROM sri_document t0 LEFT JOIN credit_note t12 ON t12.sri_document_id = t0.id LEFT JOIN liquidacion_compra t29 ON t29.sri_document_id = t0.id WHERE t0.retention_id = 20588;

SELECT
  t0.id AS id_1,
  t0.codigo_retencion AS codigo_retencion_2,
  t0.base AS base_3,
  t0.percentage AS percentage_4,
  t0.value AS value_5,
  t0.base_no_obj AS base_no_obj_6,
  t0.base0 AS base0_7,
  t0.iva AS iva_8,
  t0.percentage_iva AS percentage_iva_9,
  t0.value_iva AS value_iva_10,
  t0.base_total0 AS base_total0_11,
  t0.tax_amount AS tax_amount_12,
  t0.is_manual_iva_calc AS is_manual_iva_calc_13,
  t0.is_manual_values_calc AS is_manual_values_calc_14,
  t0.doc_sustento_id AS doc_sustento_id_15,
  t0.retention_code_id AS retention_code_id_16
FROM
  doc_sustento_impuesto t0
WHERE
  t0.doc_sustento_id = ?

SELECT t0.id AS id_1, t0.codigo_retencion AS codigo_retencion_2, t0.base AS base_3, t0.percentage AS percentage_4, t0.value AS value_5, t0.base_no_obj AS base_no_obj_6, t0.base0 AS base0_7, t0.iva AS iva_8, t0.percentage_iva AS percentage_iva_9, t0.value_iva AS value_iva_10, t0.base_total0 AS base_total0_11, t0.tax_amount AS tax_amount_12, t0.is_manual_iva_calc AS is_manual_iva_calc_13, t0.is_manual_values_calc AS is_manual_values_calc_14, t0.doc_sustento_id AS doc_sustento_id_15, t0.retention_code_id AS retention_code_id_16 FROM doc_sustento_impuesto t0 WHERE t0.doc_sustento_id = 20565;

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,
  r0_.sri_info_id AS sri_info_id_19,
  r0_.created_by_id AS created_by_id_20,
  r0_.sucursal_id AS sucursal_id_21,
  r0_.provider_id AS provider_id_22,
  r0_.import_id AS import_id_23
FROM
  retencion r0_
WHERE
  r0_.id > ?
  AND r0_.sri_info_id = ?
LIMIT
  1

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, r0_.sri_info_id AS sri_info_id_19, r0_.created_by_id AS created_by_id_20, r0_.sucursal_id AS sucursal_id_21, r0_.provider_id AS provider_id_22, r0_.import_id AS import_id_23 FROM retencion r0_ WHERE r0_.id > 20589 AND r0_.sri_info_id = 15 LIMIT 1;

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 = 25;

SELECT
  t0.id AS id_1,
  t0.field AS field_2,
  t0.value AS value_3,
  t0.invoice_id AS invoice_id_4,
  t0.credit_note_id AS credit_note_id_5,
  t0.remission_guide_id AS remission_guide_id_6,
  t0.debit_note_id AS debit_note_id_7,
  t0.liquidacion_compra_id AS liquidacion_compra_id_8,
  t0.retencion_id AS retencion_id_9
FROM
  aditional_field t0
WHERE
  t0.retencion_id = ?

SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.invoice_id AS invoice_id_4, t0.credit_note_id AS credit_note_id_5, t0.remission_guide_id AS remission_guide_id_6, t0.debit_note_id AS debit_note_id_7, t0.liquidacion_compra_id AS liquidacion_compra_id_8, t0.retencion_id AS retencion_id_9 FROM aditional_field t0 WHERE t0.retencion_id = 20589;

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.razon_social AS razon_social_3,
  t0.identification AS identification_4,
  t0.type_id AS type_id_5,
  t0.location AS location_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.tipo_sujeto_retenido AS tipo_sujeto_retenido_9,
  t0.parte_rel AS parte_rel_10,
  t0.company_id AS company_id_11,
  t0.doc_attribute_id AS doc_attribute_id_12
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.razon_social AS razon_social_3, t0.identification AS identification_4, t0.type_id AS type_id_5, t0.location AS location_6, t0.email AS email_7, t0.phone AS phone_8, t0.tipo_sujeto_retenido AS tipo_sujeto_retenido_9, t0.parte_rel AS parte_rel_10, t0.company_id AS company_id_11, t0.doc_attribute_id AS doc_attribute_id_12 FROM provider t0 WHERE t0.id = 9448;