POST https://www.quiro.care/solicitudcobertura/new

Query Metrics

70 Database Queries
26 Different statements
31.55 ms Query time
11 Invalid entities
1848 Managed entities

Grouped Statements

Show all queries

Time Count Info
11.13 ms
(35.29%)
40
SELECT t0.id AS id_1, t0.idfactura AS idfactura_2, t0.factura AS factura_3, t0.idcliente AS idcliente_4, t0.cliente AS cliente_5, t0.fechavencimiento AS fechavencimiento_6, t0.total AS total_7, t0.estadopago AS estadopago_8, t0.pedidos AS pedidos_9, t0.user_id AS user_id_10 FROM bloqueofactura t0
Parameters:
[]
3.42 ms
(10.83%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadoprofesional t0 WHERE t0.id = ?
Parameters:
[
  3
]
2.34 ms
(7.43%)
1
SELECT t0.id AS id_1, t0.primernombre AS primernombre_2, t0.segundonombre AS segundonombre_3, t0.primerapellido AS primerapellido_4, t0.segundoapellido AS segundoapellido_5, t0.documento AS documento_6, t0.estado AS estado_7, t0.fechanacimiento AS fechanacimiento_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.email AS email_11, t0.idintegracion AS idintegracion_12, t0.documentfile AS documentfile_13, t0.tipodocumento_id AS tipodocumento_id_14, t0.municipio_id AS municipio_id_15, t0.empresa_id AS empresa_id_16, t0.tipopago_id AS tipopago_id_17, t0.catalogoprecio_id AS catalogoprecio_id_18, t0.tipocliente_id AS tipocliente_id_19, t0.resptributaria_id AS resptributaria_id_20, t0.posicionfiscal_id AS posicionfiscal_id_21 FROM persona t0 WHERE t0.id = ?
Parameters:
[
  133
]
2.24 ms
(7.11%)
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.profesional_id = ?
Parameters:
[
  67
]
1.69 ms
(5.35%)
1
SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.abreviatura AS abreviatura_2, t0_.tipodocumentodian AS tipodocumentodian_3, t0_.idodoo AS idodoo_4 FROM tipodocumento t0_ WHERE t0_.id IN (?)
Parameters:
[
  "1"
]
1.25 ms
(3.97%)
1
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2, p0_.is_active AS is_active_3, p0_.costo AS costo_4, p0_.urlimagen AS urlimagen_5, p0_.urlvideo AS urlvideo_6, p0_.visible AS visible_7, p0_.requiere_agenda AS requiere_agenda_8, p0_.categoriaproducto_id AS categoriaproducto_id_9, p0_.tipoproducto_id AS tipoproducto_id_10, p0_.subtipoproducto_id AS subtipoproducto_id_11 FROM paqueteproducto p0_
Parameters:
[]
0.96 ms
(3.05%)
1
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2, p0_.grupo_lista_precio_id AS grupo_lista_precio_id_3 FROM poliza p0_
Parameters:
[]
0.94 ms
(2.98%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.grupo_lista_precio_id AS grupo_lista_precio_id_4 FROM poliza t0 INNER JOIN profesionales_poliza ON t0.id = profesionales_poliza.poliza_id WHERE profesionales_poliza.profesionales_id = ?
Parameters:
[
  67
]
0.89 ms
(2.82%)
4
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadocobertura t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.64 ms
(2.04%)
3
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.padre_id = ? AND m0_.activo = ? AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[
  241
  1
  "ROLE_ASISTENTE"
]
0.64 ms
(2.02%)
1
SELECT p0_.id AS id_0, p0_.primernombre AS primernombre_1, p0_.segundonombre AS segundonombre_2, p0_.primerapellido AS primerapellido_3, p0_.segundoapellido AS segundoapellido_4, p0_.documento AS documento_5, p0_.estado AS estado_6, p0_.fechanacimiento AS fechanacimiento_7, p0_.direccion AS direccion_8, p0_.telefono AS telefono_9, p0_.email AS email_10, p0_.idintegracion AS idintegracion_11, p0_.documentfile AS documentfile_12, p0_.tipodocumento_id AS tipodocumento_id_13, p0_.municipio_id AS municipio_id_14, p0_.empresa_id AS empresa_id_15, p0_.tipopago_id AS tipopago_id_16, p0_.catalogoprecio_id AS catalogoprecio_id_17, p0_.tipocliente_id AS tipocliente_id_18, p0_.resptributaria_id AS resptributaria_id_19, p0_.posicionfiscal_id AS posicionfiscal_id_20 FROM persona p0_ WHERE p0_.documento = ? ORDER BY p0_.primernombre ASC
Parameters:
[
  "1116723063"
]
0.62 ms
(1.96%)
1
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.codigo AS codigo_2, m0_.departamento_id AS departamento_id_3 FROM municipio m0_
Parameters:
[]
0.59 ms
(1.86%)
1
SELECT e0_.id AS id_0, e0_.descripcion AS descripcion_1, e0_.estado AS estado_2, e0_.direccion AS direccion_3, e0_.empresa_id AS empresa_id_4, e0_.tipoentidad_id AS tipoentidad_id_5, e0_.municipio_id AS municipio_id_6 FROM entidad e0_
Parameters:
[]
0.58 ms
(1.82%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.telefono AS telefono_3, t0.persona_id AS persona_id_4 FROM asistenteprofesional t0 WHERE t0.persona_id = ?
Parameters:
[
  1002
]
0.43 ms
(1.36%)
1
SELECT t0.id AS id_1, t0.numerocuenta AS numerocuenta_2, t0.anioexperiencia AS anioexperiencia_3, t0.tarjetaprofesional AS tarjetaprofesional_4, t0.validacion AS validacion_5, t0.persona_id AS persona_id_6, t0.profesion_id AS profesion_id_7, t0.banco_id AS banco_id_8, t0.tipocuenta_id AS tipocuenta_id_9, t0.comercial_id AS comercial_id_10, t0.estado_id AS estado_id_11, t0.tipofacturacion_id AS tipofacturacion_id_12, t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_13, t0.catalogoventa_id AS catalogoventa_id_14 FROM profesionales t0 INNER JOIN profesionales_asistenteprofesional ON t0.id = profesionales_asistenteprofesional.profesionales_id WHERE profesionales_asistenteprofesional.asistenteprofesional_id = ?
Parameters:
[
  85
]
0.42 ms
(1.34%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.39 ms
(1.22%)
1
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.activo = ? AND m0_.nivel = 0 AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[
  1
  "ROLE_ASISTENTE"
]
0.36 ms
(1.14%)
1
SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.descripcion AS descripcion_2 FROM estadocobertura e0_
Parameters:
[]
0.33 ms
(1.05%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.departamento_id AS departamento_id_4 FROM municipio t0 ORDER BY t0.nombre ASC
Parameters:
[]
0.29 ms
(0.91%)
1
SELECT t0.id AS id_1, t0.urlconexion AS urlconexion_2, t0.basededatos AS basededatos_3, t0.usuario AS usuario_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.idusuario AS idusuario_7, t0.sync_quiropay_recargas AS sync_quiropay_recargas_8, t0.sync_pedidos AS sync_pedidos_9, t0.sync_comprobantes_pedidos AS sync_comprobantes_pedidos_10 FROM sincronizacion t0
Parameters:
[]
0.28 ms
(0.88%)
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:
[
  77
]
0.25 ms
(0.78%)
1
SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.codigo AS codigo_2, t0_.codigoodoo AS codigoodoo_3 FROM tiporesponsabilidad t0_
Parameters:
[]
0.24 ms
(0.75%)
1
SELECT t0.id AS id_1, t0.maxprocedalta AS maxprocedalta_2, t0.maxnumprocedimiento AS maxnumprocedimiento_3, t0.edadmin AS edadmin_4, t0.edadmax AS edadmax_5, t0.imcmax AS imcmax_6, t0.asa AS asa_7, t0.hemoglobinamax AS hemoglobinamax_8, t0.consumidorfinal AS consumidorfinal_9, t0.catalogoprecio_id AS catalogoprecio_id_10 FROM config_cobertura t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.23 ms
(0.74%)
1
SELECT r0_.id AS id_0, r0_.descripcion AS descripcion_1, r0_.codigo AS codigo_2, r0_.codigoodoo AS codigoodoo_3 FROM resptributaria r0_
Parameters:
[]
0.21 ms
(0.66%)
1
SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.abreviatura AS abreviatura_2, t0_.tipodocumentodian AS tipodocumentodian_3, t0_.idodoo AS idodoo_4 FROM tipodocumento t0_
Parameters:
[]
0.20 ms
(0.63%)
1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.abreviatura AS abreviatura_3, t0.tipodocumentodian AS tipodocumentodian_4, t0.idodoo AS idodoo_5 FROM tipodocumento t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Municipio 1123
App\Entity\Entidad 242
App\Entity\Empresa 233
App\Entity\Solicitudcobertura 62
App\Entity\Persona 56
App\Entity\Departamento 33
App\Entity\Paqueteproducto 23
App\Entity\Estadocobertura 13
App\Entity\Subtipoproducto 10
App\Entity\User 7
App\Entity\MenuItem 7
App\Entity\Poliza 6
App\Entity\Tipodocumento 5
App\Entity\Tiporesponsabilidad 5
App\Entity\Resptributaria 4
App\Entity\GrupoListasPrecios 3
App\Entity\Categoriaproducto 2
App\Entity\Rol 1
App\Entity\Sincronizacion 1
App\Entity\Asistenteprofesional 1
App\Entity\Profesionales 1
App\Entity\Profesion 1
App\Entity\Comercial 1
App\Entity\Estadoprofesional 1
App\Entity\Tipofacturacion 1
App\Entity\Tipopago 1
App\Entity\ConfigCobertura 1
App\Entity\Catalogoprecio 1
App\Entity\Tipocliente 1
App\Entity\Tipoentidad 1
App\Entity\Tipoproducto 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\Sincronizacion No errors.
App\Entity\Tipodocumento No errors.
App\Entity\Municipio No errors.
App\Entity\Departamento 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\Entidad No errors.
App\Entity\Asistenteprofesional 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\Profesion No errors.
App\Entity\Bancos No errors.
App\Entity\Tipocuenta No errors.
App\Entity\Comercial No errors.
App\Entity\Estadoprofesional No errors.
App\Entity\Tipofacturacion No errors.
App\Entity\GrupoListasPrecios No errors.
App\Entity\Contactoreferencia No errors.
App\Entity\Especializaciones No errors.
App\Entity\Poliza No errors.
App\Entity\AgendaProfesional No errors.
App\Entity\Servicio
  • The mappings App\Entity\Servicio#personaresponsable and App\Entity\Persona#servicios are inconsistent with each other.
App\Entity\CitaProducto
  • The association App\Entity\CitaProducto#cliente refers to the inverse side field App\Entity\Persona#citaProductos which does not exist.
  • The association App\Entity\CitaProducto#pedido refers to the inverse side field App\Entity\Pedido#citaProductos which does not exist.
App\Entity\Paqueteproducto No errors.
App\Entity\Estadocobertura No errors.
App\Entity\Categoriaproducto No errors.
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\ConfigCobertura
  • The association App\Entity\ConfigCobertura#catalogoprecio refers to the inverse side field App\Entity\Catalogoprecio#configCoberturas which does not exist.
App\Entity\Catalogoprecio No errors.
App\Entity\ConfigCoberturaCategoriaproducto No errors.
App\Entity\Tiporesponsabilidad
  • The mappings App\Entity\Tiporesponsabilidad#personasposfiscal and App\Entity\Persona#posicionfiscal are inconsistent with each other.
  • The mappings App\Entity\Tiporesponsabilidad#empresasposfiscal and App\Entity\Empresa#posicionfiscal are inconsistent with each other.
App\Entity\Resptributaria No errors.
App\Entity\Tipocliente No errors.
App\Entity\Pedido
  • The association App\Entity\Pedido#solicitudcobertura refers to the inverse side field App\Entity\Solicitudcobertura#pedidos which does not exist.
App\Entity\Tipoentidad No errors.
App\Entity\Tipoproducto No errors.
App\Entity\Subtipoproducto No errors.
App\Entity\CatalogoprecioProducto
  • The association App\Entity\CatalogoprecioProducto#condicionesvariante refers to the inverse side field App\Entity\ConfigPaqueteVar#catalogoprecioProductos which does not exist.
App\Entity\ConfigPaqueteVar No errors.
App\Entity\TipoclienteProducto No errors.
App\Entity\MenuItem No errors.