1
0.52 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 = ?
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 = '20584' ;
Copy
2
0.30 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 = ?
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 ;
Copy
3
0.33 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 (? )
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 (20584 );
Copy
4
0.25 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 = ?
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 ;
Copy
5
0.27 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 = ?
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 ;
Copy
6
0.41 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 = ?
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 ;
Copy
7
0.50 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
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 < 20584 AND r0_ . sri_info_id = 16 ORDER BY r0_ . id DESC LIMIT 1 ;
Copy
8
0.41 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 = ?
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 = 20583 ;
Copy
9
0.35 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 (? )
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 (20583 );
Copy
10
0.26 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
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 > 20584 AND r0_ . sri_info_id = 16 LIMIT 1 ;
Copy
11
0.32 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 "
14
]
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 = 14 LIMIT 1 ;
Copy
12
0.26 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 "
14
]
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 = 14 LIMIT 1 ;
Copy
13
0.22 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 "
14
]
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 = 'liquidacion' AND t0 . saas_configuration_id = 14 LIMIT 1 ;
Copy
14
0.21 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 "
14
]
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 = 'notaCredito' AND t0 . saas_configuration_id = 14 LIMIT 1 ;
Copy
15
0.28 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 "
14
]
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 = 'notaCredito' AND t0 . saas_configuration_id = 14 LIMIT 1 ;
Copy
16
0.22 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 "
14
]
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 = 'guiaRemision' AND t0 . saas_configuration_id = 14 LIMIT 1 ;
Copy
17
0.23 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 = ?
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 = 9516 ;
Copy
18
0.28 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 = ?
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 = 20560 ;
Copy
19
0.40 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 = ?
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 = 20584 ;
Copy