Redirect 302 redirect from POST @app_retention_send_to_sri (34646b)

GET https://sitacweb.com/retention/info/20589

Query Metrics

19 Database Queries
13 Different statements
4.60 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.49 ms
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 = ?
Parameters:
[
  "20589"
]
2 0.24 ms
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 = ?
Parameters:
[
  23716
]
3 0.27 ms
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 (?)
Parameters:
[
  20589
]
4 0.22 ms
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 = ?
Parameters:
[
  23716
]
5 0.21 ms
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 = ?
Parameters:
[
  25
]
6 0.36 ms
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 = ?
Parameters:
[
  25
]
7 0.32 ms
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
Parameters:
[
  20589
  15
]
8 0.34 ms
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 = ?
Parameters:
[
  20588
]
9 0.20 ms
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 (?)
Parameters:
[
  20588
]
10 0.24 ms
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
Parameters:
[
  20589
  15
]
11 0.23 ms
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
Parameters:
[
  "factura"
  13
]
12 0.18 ms
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
Parameters:
[
  "retencion"
  13
]
13 0.17 ms
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
Parameters:
[
  "liquidacion"
  13
]
14 0.16 ms
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
Parameters:
[
  "notaCredito"
  13
]
15 0.19 ms
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
Parameters:
[
  "notaCredito"
  13
]
16 0.18 ms
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
Parameters:
[
  "guiaRemision"
  13
]
17 0.19 ms
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 = ?
Parameters:
[
  9448
]
18 0.22 ms
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 = ?
Parameters:
[
  20565
]
19 0.19 ms
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 = ?
Parameters:
[
  20589
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\InvoiceSuperClass No errors.
App\Entity\Retencion No errors.
App\Entity\SriInfo No errors.
App\Entity\User No errors.
App\Entity\SriDocument No errors.
App\Entity\Invoice
  • The field 'App\Entity\Invoice#totalWithoutTax' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Invoice#totalDiscount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Invoice#propina' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\RemissionGuide No errors.
App\Entity\DebitNote No errors.
App\Entity\Sucursal No errors.
App\Entity\Provider No errors.
App\Entity\RetentionImport No errors.
App\Entity\RetentionImpuesto No errors.
App\Entity\AditionalField No errors.
App\Entity\DocSustento No errors.
App\Entity\Reembolso No errors.
App\Entity\CreditNote No errors.
App\Entity\Client No errors.
App\Entity\PagoLocExt No errors.
App\Entity\InvoiceTaxes No errors.
App\Entity\DocSustentoImpuesto No errors.
App\Entity\SriPayment No errors.
App\Entity\LiquidacionCompra No errors.
App\Entity\Employee No errors.
App\Entity\Transporter No errors.
App\Entity\Ats No errors.
App\Entity\Certificate No errors.
App\Entity\SriEdwin No errors.
App\Entity\EmailConfiguration No errors.
App\Entity\SaasConfiguration No errors.
App\Entity\EmailExtraConfig No errors.
App\Entity\Sequence No errors.
App\Entity\Tax No errors.
App\Entity\Product No errors.
App\Entity\TransporterRemissionGuide No errors.
App\Entity\DisabledRetentionCode No errors.
App\Entity\Trabajador No errors.
App\Entity\Report103 No errors.
App\Entity\ReportIva No errors.
App\Entity\EmailTemplate No errors.
App\Entity\SaasDocAllowed No errors.
App\Entity\ClientDocSustentoAttributes No errors.
App\Entity\RetentionCodeList No errors.