https://edigital.aditecec.com/ut/facturas/autorizacion/cron/

Query Metrics

2 Database Queries
2 Different statements
2903.08 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT f0_.id AS id_0, f0_.for_pag_codigo AS for_pag_codigo_1, f0_.for_pag_nombre AS for_pag_nombre_2, f0_.for_pag_estado AS for_pag_estado_3 FROM feforpago f0_ ORDER BY f0_.id ASC
Parameters:
[]
2 2902.50 ms
SELECT u0_.id AS id_0, u0_.FAC_CUSTOMERS AS FAC_CUSTOMERS_1, u0_.FAC_CAJ_ID AS FAC_CAJ_ID_2, u0_.FAC_AMBIENTE AS FAC_AMBIENTE_3, u0_.FAC_TIP_EMISION AS FAC_TIP_EMISION_4, u0_.FAC_RAZ_SOCIAL AS FAC_RAZ_SOCIAL_5, u0_.FAC_NOM_COMERCIAL AS FAC_NOM_COMERCIAL_6, u0_.FAC_RUC AS FAC_RUC_7, u0_.FAC_CLAVE AS FAC_CLAVE_8, u0_.FAC_COD_DOC AS FAC_COD_DOC_9, u0_.FAC_ESTABLECIMIENTO AS FAC_ESTABLECIMIENTO_10, u0_.FAC_PUN_EMISION AS FAC_PUN_EMISION_11, u0_.FAC_SECUENCIAL AS FAC_SECUENCIAL_12, u0_.FAC_DIR_MATRIZ AS FAC_DIR_MATRIZ_13, u0_.FAC_FEC_EMISION AS FAC_FEC_EMISION_14, u0_.FAC_DIR_ESTABLECIMIENTO AS FAC_DIR_ESTABLECIMIENTO_15, u0_.FAC_OBLIGADO AS FAC_OBLIGADO_16, u0_.FAC_TIP_IDE_COMPRADOR AS FAC_TIP_IDE_COMPRADOR_17, u0_.FAC_RAZ_SOC_COMPRADOR AS FAC_RAZ_SOC_COMPRADOR_18, u0_.FAC_IDE_COMPRADOR AS FAC_IDE_COMPRADOR_19, u0_.FAC_DIR_COMPRADOR AS FAC_DIR_COMPRADOR_20, u0_.FAC_TOT_SIN_IMPUESTOS AS FAC_TOT_SIN_IMPUESTOS_21, u0_.FAC_TOT_DESCUENTOS AS FAC_TOT_DESCUENTOS_22, u0_.FAC_TOT_CON_IMP_CODIGO AS FAC_TOT_CON_IMP_CODIGO_23, u0_.FAC_TOT_CON_IMP_PORCENTAJE AS FAC_TOT_CON_IMP_PORCENTAJE_24, u0_.FAC_TOT_CON_IMP_BASE AS FAC_TOT_CON_IMP_BASE_25, u0_.FAC_TOT_CON_IMP_TARIFA AS FAC_TOT_CON_IMP_TARIFA_26, u0_.FAC_TOT_CON_IMP_VALOR AS FAC_TOT_CON_IMP_VALOR_27, u0_.FAC_PROPINA AS FAC_PROPINA_28, u0_.FAC_TOTAL AS FAC_TOTAL_29, u0_.FAC_MONEDA AS FAC_MONEDA_30, u0_.FAC_PLACA AS FAC_PLACA_31, u0_.FAC_FOR_PAGO AS FAC_FOR_PAGO_32, u0_.FAC_FOR_PAG_TOTAL AS FAC_FOR_PAG_TOTAL_33, u0_.FAC_SUB_CERO AS FAC_SUB_CERO_34, u0_.FAC_SUB_CINCO AS FAC_SUB_CINCO_35, u0_.FAC_IVA_CINCO AS FAC_IVA_CINCO_36, u0_.FAC_SUB_DOCE AS FAC_SUB_DOCE_37, u0_.FAC_IVA_DOCE AS FAC_IVA_DOCE_38, u0_.FAC_SUB_TRECE AS FAC_SUB_TRECE_39, u0_.FAC_IVA_TRECE AS FAC_IVA_TRECE_40, u0_.FAC_SUB_CATORCE AS FAC_SUB_CATORCE_41, u0_.FAC_IVA_CATORCE AS FAC_IVA_CATORCE_42, u0_.FAC_SUB_QUINCE AS FAC_SUB_QUINCE_43, u0_.FAC_IVA_QUINCE AS FAC_IVA_QUINCE_44, u0_.FAC_SUB_NO_OBJETO AS FAC_SUB_NO_OBJETO_45, u0_.FAC_SUB_EXENTO AS FAC_SUB_EXENTO_46, u0_.FAC_SUB_DIFERENCIADO AS FAC_SUB_DIFERENCIADO_47, u0_.FAC_CAM_ADI_DIRECCION AS FAC_CAM_ADI_DIRECCION_48, u0_.FAC_CAM_ADI_TELEFONO AS FAC_CAM_ADI_TELEFONO_49, u0_.FAC_CAM_ADI_EMAIL AS FAC_CAM_ADI_EMAIL_50, u0_.FAC_FEC_ENVIO AS FAC_FEC_ENVIO_51, u0_.FAC_FEC_RESPUESTA AS FAC_FEC_RESPUESTA_52, u0_.FAC_ESTADO AS FAC_ESTADO_53, u0_.FAC_EST_MIGRACION AS FAC_EST_MIGRACION_54, u0_.FAC_XML AS FAC_XML_55, u0_.FAC_LOG AS FAC_LOG_56, u0_.FAC_USUARIO AS FAC_USUARIO_57, u0_.FAC_NOT_CREDITO AS FAC_NOT_CREDITO_58, u0_.FAC_INF_ADICIONAL AS FAC_INF_ADICIONAL_59 FROM utfacturas u0_ WHERE u0_.FAC_ESTADO IN ('FIRMADA', 'RECIBIDA') ORDER BY u0_.id ASC
Parameters:
[]

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\UtFacturas No errors.
App\Entity\FeFacDetalles No errors.
App\Entity\FeVentas
  • The mappings App\Entity\FeVentas#venDetalles and App\Entity\FeVenDetalles#ventas are inconsistent with each other.
App\Entity\FeComercios
  • The mappings App\Entity\FeComercios#parametros and App\Entity\FeParametros#comercios are inconsistent with each other.
App\Entity\FeForPago No errors.