GET https://quiro.care/solicitudcobertura/list-comprobantes?solicitud_id=7895

Response
200 OK
Browse referrer URL
IP
186.194.58.77
Profiled on
Token
a16589

Query Metrics

4 Database Queries
4 Different statements
3.61 ms Query time
5 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.57 ms
(71.09%) 		1 
SELECT t0.id AS id_1, t0.nombrearchivo AS nombrearchivo_2, t0.fechasubida AS fechasubida_3, t0.comentario AS comentario_4, t0.solicitud_id AS solicitud_id_5, t0.usuariosubida_id AS usuariosubida_id_6 FROM comprobante_pago_archivo t0 WHERE t0.solicitud_id = ? ORDER BY t0.fechasubida DESC
Parameters: 
[
  7895
]
View formatted query    View runnable query    Explain query
0.38 ms
(10.46%) 		1 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
0.36 ms
(9.96%) 		1 
SELECT t0.id AS id_1, t0.precio AS precio_2, t0.valorasegurado AS valorasegurado_3, t0.duracion AS duracion_4, t0.observacion AS observacion_5, t0.fechaprocedimiento AS fechaprocedimiento_6, t0.fechacreacion AS fechacreacion_7, t0.fechaenviada AS fechaenviada_8, t0.urldocidentificacion AS urldocidentificacion_9, t0.urlcobertura AS urlcobertura_10, t0.urlcomprobantepago AS urlcomprobantepago_11, t0.tipopersonafacturacion AS tipopersonafacturacion_12, t0.sincronizado AS sincronizado_13, t0.pedidoodoo AS pedidoodoo_14, t0.edad AS edad_15, t0.estatura AS estatura_16, t0.peso AS peso_17, t0.asa AS asa_18, t0.hemoglobina AS hemoglobina_19, t0.anexos AS anexos_20, t0.certificado AS certificado_21, t0.fechamodificacion AS fechamodificacion_22, t0.nombreodoo AS nombreodoo_23, t0.consumidorfinal AS consumidorfinal_24, t0.usuario_id AS usuario_id_25, t0.profesional_id AS profesional_id_26, t0.asistente_id AS asistente_id_27, t0.paciente_id AS paciente_id_28, t0.entidad_id AS entidad_id_29, t0.paquetecobertura_id AS paquetecobertura_id_30, t0.estado_id AS estado_id_31, t0.especialidad_id AS especialidad_id_32, t0.municipio_id AS municipio_id_33, t0.poliza_id AS poliza_id_34, t0.personafacturacion_id AS personafacturacion_id_35, t0.empresafacturacion_id AS empresafacturacion_id_36, t0.usuariocancela_id AS usuariocancela_id_37, t0.usuariomodifica_id AS usuariomodifica_id_38, t0.tipopago_id AS tipopago_id_39 FROM solicitudcobertura t0 WHERE t0.id = ?
Parameters: 
[
  7895
]
View formatted query    View runnable query    Explain query
0.31 ms
(8.49%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.terminosycondiciones AS terminosycondiciones_5, t0.suscripcion AS suscripcion_6, t0.persona_id AS persona_id_7, t0.rol_id AS rol_id_8 FROM `user` t0 WHERE t0.id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 2
App\Entity\Persona 2
App\Entity\Rol 1
App\Entity\Solicitudcobertura 1
App\Entity\Profesionales 1
App\Entity\Asistenteprofesional 1
App\Entity\Entidad 1
App\Entity\Paqueteproducto 1
App\Entity\Estadocobertura 1
App\Entity\Poliza 1
App\Entity\Tipopago 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Persona
  • The mappings App\Entity\Persona#posicionfiscal and App\Entity\Tiporesponsabilidad#personas are inconsistent with each other.
  • If association App\Entity\Persona#posicionfiscal is many-to-one, then the inversed side App\Entity\Tiporesponsabilidad#personas has to be one-to-many.
App\Entity\Rol No errors.
App\Entity\Solicitudcobertura
  • The association App\Entity\Solicitudcobertura#usuariomodifica refers to the inverse side field App\Entity\User#solicitudusuariomodifica which does not exist.
App\Entity\Bloqueofactura No errors.
App\Entity\QuiroPay No errors.
App\Entity\Modulo No errors.
App\Entity\Profesionales
  • If association App\Entity\Profesionales#poliza is many-to-many, then the inversed side App\Entity\Poliza#profesionales has to be many-to-many as well.
  • The association App\Entity\Profesionales#catalogoventa refers to the inverse side field App\Entity\GrupoListasPrecios#profesionales which does not exist.
App\Entity\Asistenteprofesional No errors.
App\Entity\Entidad No errors.
App\Entity\Paqueteproducto No errors.
App\Entity\Estadocobertura No errors.
App\Entity\Categoriaproducto No errors.
App\Entity\Municipio No errors.
App\Entity\Poliza No errors.
App\Entity\Empresa
  • The mappings App\Entity\Empresa#posicionfiscal and App\Entity\Tiporesponsabilidad#empresas are inconsistent with each other.
  • If association App\Entity\Empresa#posicionfiscal is many-to-one, then the inversed side App\Entity\Tiporesponsabilidad#empresas has to be one-to-many.
App\Entity\Tipopago
  • The mappings App\Entity\Tipopago#solicitudcoberturas and App\Entity\Solicitudcobertura#tipopago are inconsistent with each other.
App\Entity\Productos No errors.
App\Entity\Activarcobertura No errors.
App\Entity\ComprobantePagoArchivo No errors.