https://naturmed.sismedsolution.com/index.php/producto/midas/existencias/NAT0003

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
0.84 ms
(60.65%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.apellido1 AS apellido1_3, t0.apellido2 AS apellido2_4, t0.nombre1 AS nombre1_5, t0.nombre2 AS nombre2_6, t0.roles AS roles_7, t0.password AS password_8, t0.cedula AS cedula_9, t0.estado AS estado_10, t0.firma AS firma_11, t0.cod_senescyt AS cod_senescyt_12, t0.titulo AS titulo_13, t0.titulo_abrev AS titulo_abrev_14, t0.color AS color_15, t0.dr AS dr_16, t0.tipousuario_id AS tipousuario_id_17, t0.especialidad_id AS especialidad_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  31
]
0.55 ms
(39.35%)
1
SELECT t0.id AS id_1, t0.ruc AS ruc_2, t0.nombre_corto AS nombre_corto_3, t0.nombre_largo AS nombre_largo_4, t0.servicio AS servicio_5, t0.correo AS correo_6, t0.telefono AS telefono_7, t0.estado AS estado_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.canton AS canton_11, t0.provincia AS provincia_12, t0.parroquia AS parroquia_13, t0.direccion AS direccion_14, t0.correo2 AS correo2_15, t0.estado_factura AS estado_factura_16, t0.id_api AS id_api_17, t0.token AS token_18, t0.convenio_id AS convenio_id_19 FROM empresa t0 WHERE t0.id_api = ? LIMIT 1
Parameters:
[
  "95"
]

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\User No errors.
App\Entity\TipoUsuario No errors.
App\Entity\Especialidad No errors.
App\Entity\Paciente
  • The mappings App\Entity\Paciente#redsocial and App\Entity\RedSocial#agendas are inconsistent with each other.
App\Entity\Agenda
  • The field App\Entity\Agenda#agenda_procedimientos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AgendaProcedimiento#agenda does not contain the required 'inversedBy="agenda_procedimientos"' attribute.
  • The mappings App\Entity\Agenda#redsocial and App\Entity\RedSocial#agendas are inconsistent with each other.
  • The field App\Entity\Agenda#agendasReferenciadas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Agenda#referencia does not contain the required 'inversedBy="agendasReferenciadas"' attribute.
App\Entity\LogAgenda No errors.
App\Entity\Receta No errors.
App\Entity\ExamenOrden No errors.
App\Entity\Orden012 No errors.
App\Entity\PlanoCabecera No errors.
App\Entity\Epicrisis No errors.
App\Entity\LabProtocolo No errors.
App\Entity\Empresa No errors.
App\Entity\Convenio No errors.