Symfony Profiler

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.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.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 = 23723;

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.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 = 23723;

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
  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 = 'retencion' AND t0.saas_configuration_id = 13 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  sri_document
WHERE
  id = ?

DELETE FROM sri_document WHERE id = 23723;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.show_transporter AS show_transporter_2,
  t0.sucursal_limit AS sucursal_limit_3,
  t0.should_print332_pdf AS should_print332_pdf_4,
  t0.company_id AS company_id_5
FROM
  saas_configuration t0
WHERE
  t0.company_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.show_transporter AS show_transporter_2, t0.sucursal_limit AS sucursal_limit_3, t0.should_print332_pdf AS should_print332_pdf_4, t0.company_id AS company_id_5 FROM saas_configuration t0 WHERE t0.company_id = 15 LIMIT 1;

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
  t0.creation_date AS creation_date_1,
  t0.date_update AS date_update_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.code AS code_5,
  t0.percentage AS percentage_6,
  t0.iva AS iva_7,
  t0.valid_from AS valid_from_8,
  t0.valid_to AS valid_to_9,
  t0.percentage_iva AS percentage_iva_10,
  t0.code_iva AS code_iva_11,
  t0.code103 AS code103_12
FROM
  retention_code_list t0
WHERE
  t0.id = ?

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.name AS name_4, t0.code AS code_5, t0.percentage AS percentage_6, t0.iva AS iva_7, t0.valid_from AS valid_from_8, t0.valid_to AS valid_to_9, t0.percentage_iva AS percentage_iva_10, t0.code_iva AS code_iva_11, t0.code103 AS code103_12 FROM retention_code_list t0 WHERE t0.id = 147;

SELECT
  t0.id AS id_1,
  t0.payment_form AS payment_form_2,
  t0.total AS total_3,
  t0.term AS term_4,
  t0.term_time AS term_time_5,
  t0.debit_note_id AS debit_note_id_6,
  t0.liquidacion_compra_id AS liquidacion_compra_id_7,
  t0.doc_sustento_id AS doc_sustento_id_8,
  t0.invoice_id AS invoice_id_9
FROM
  sri_payment t0
WHERE
  t0.doc_sustento_id = ?

SELECT t0.id AS id_1, t0.payment_form AS payment_form_2, t0.total AS total_3, t0.term AS term_4, t0.term_time AS term_time_5, t0.debit_note_id AS debit_note_id_6, t0.liquidacion_compra_id AS liquidacion_compra_id_7, t0.doc_sustento_id AS doc_sustento_id_8, t0.invoice_id AS invoice_id_9 FROM sri_payment t0 WHERE t0.doc_sustento_id = 20565;

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;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sri_document (
  clave_accesso, secuencial, estado,
  error, serie1, serie2, cancel, has_fetch_error,
  invoice_id, retention_id, remission_guide_id,
  debit_note_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO sri_document (clave_accesso, secuencial, estado, error, serie1, serie2, cancel, has_fetch_error, invoice_id, retention_id, remission_guide_id, debit_note_id) VALUES ('3112202507226001727000120010030000002984464752612', '000000298', 'RECHAZADO', 'Hubo un error enviendo al SRI. Código http: 500', '001', '003', NULL, NULL, NULL, 20589, NULL, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  sri_document
SET
  has_fetch_error = ?
WHERE
  id = ?

UPDATE sri_document SET has_fetch_error = 0 WHERE id = 23724;

"COMMIT"

"COMMIT";