GET https://pruebaspema.appoloatiende.com/intern/login

Query Metrics

5 Database Queries
4 Different statements
4.81 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.13 ms
(44.25%)
1
SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = ?
Parameters:
[
  43
]
1.14 ms
(23.73%)
2
SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = ? LIMIT 1
Parameters:
[
  51
]
0.91 ms
(19.01%)
1
SELECT t0_.id_tipo_tema AS id_tipo_tema_0, t0_.css_tema AS css_tema_1, t0_.color_fondo_titulo_recordatorio AS color_fondo_titulo_recordatorio_2, t0_.imagen_panel_agendar AS imagen_panel_agendar_3, t0_.imagen_panel_consultar AS imagen_panel_consultar_4, t0_.imagen_panel_tramites AS imagen_panel_tramites_5, t0_.imagen_panel_cursos AS imagen_panel_cursos_6, t0_.imagen_panel_editar AS imagen_panel_editar_7, t0_.css_responsive AS css_responsive_8, t0_.imagen_panel_visualizador AS imagen_panel_visualizador_9, t0_.imagen_panel_atencion_ventanilla AS imagen_panel_atencion_ventanilla_10, t0_.imagen_panel_administracion AS imagen_panel_administracion_11, t0_.imagen_panel_reportes AS imagen_panel_reportes_12, t0_.imagen_panel_turnero AS imagen_panel_turnero_13, t0_.imagen_panel_atencion_cursos AS imagen_panel_atencion_cursos_14, t0_.imagen_aviso_bienvenida AS imagen_aviso_bienvenida_15, t0_.color_fondo_panel_cita AS color_fondo_panel_cita_16, t0_.imagen_panel_consulta_cursos_fecha AS imagen_panel_consulta_cursos_fecha_17, t0_.imagen_panel_consulta_cursos_identificacion AS imagen_panel_consulta_cursos_identificacion_18, t0_.imagen_panel_reasignar_cita AS imagen_panel_reasignar_cita_19, t0_.imagen_panel_cursos_cancelados AS imagen_panel_cursos_cancelados_20, t0_.css_login_reset_password AS css_login_reset_password_21, t0_.css_flujo_pyg AS css_flujo_pyg_22, t0_.activo AS activo_23 FROM tipo_tema t0_ WHERE t0_.id_tipo_tema = ? AND t0_.activo = true
Parameters:
[
  4
]
0.63 ms
(13.02%)
1
SELECT t0.id_empresa AS id_empresa_1, t0.nombre_empresa AS nombre_empresa_2, t0.nit_empresa AS nit_empresa_3, t0.activo AS activo_4, t0.url_empresa AS url_empresa_5, t0.ruta_banner_login AS ruta_banner_login_6, t0.ruta_doc_protocolo_bioseguridad AS ruta_doc_protocolo_bioseguridad_7, t0.ruta_doc_autenticacion_digital AS ruta_doc_autenticacion_digital_8 FROM empresa 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.

Entities Mapping

Class Mapping errors
App\Entity\Parameter No errors.
App\Entity\TemplateType No errors.
App\Entity\Enterprise
  • The association App\Entity\Enterprise#sites refers to the owning side field App\Entity\Site#Enterprise which does not exist.
  • The field App\Entity\Enterprise#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Video#enterprises does not contain the required 'inversedBy="videos"' attribute.
  • The association App\Entity\Enterprise#procedures refers to the owning side field App\Entity\Procedure#Enterprise which does not exist.
  • The field App\Entity\Enterprise#formTemplates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\FormTemplate#enterprises does not contain the required 'inversedBy="formTemplates"' attribute.
  • The field App\Entity\Enterprise#interns is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intern#enterprises does not contain the required 'inversedBy="interns"' attribute.
  • The field App\Entity\Enterprise#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Message#enterprises does not contain the required 'inversedBy="messages"' attribute.
  • The field App\Entity\Enterprise#schedule is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Schedule#enterprises does not contain the required 'inversedBy="schedule"' attribute.
App\Entity\Site
  • The mappings App\Entity\Site#city and App\Entity\City#sites are inconsistent with each other.
  • The mappings App\Entity\Site#enterprise and App\Entity\Enterprise#sites are inconsistent with each other.
  • The association App\Entity\Site#waitingRooms refers to the owning side field App\Entity\WaitingRoom#sites which does not exist.
  • The association App\Entity\Site#ticketDispensers refers to the owning side field App\Entity\TicketDispenser#sites which does not exist.
App\Entity\Video
  • The field App\Entity\Video#displays is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Display#videos does not contain the required 'inversedBy="displays"' attribute.
App\Entity\Procedure
  • The mappings App\Entity\Procedure#enterprise and App\Entity\Enterprise#procedures are inconsistent with each other.
  • The association App\Entity\Procedure#typeProcess refers to the inverse side field App\Entity\TypeProcess#procedures which does not exist.
  • The field App\Entity\Procedure#sites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Site#procedures does not contain the required 'inversedBy="sites"' attribute.
  • The field App\Entity\Procedure#appointments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Appointment#procedures does not contain the required 'inversedBy="appointments"' attribute.
  • The field App\Entity\Procedure#procedureWindows is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProcedureWindow#procedures does not contain the required 'inversedBy="procedureWindows"' attribute.
  • The field App\Entity\Procedure#ticketDispensers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TicketDispenser#enabledProcedures does not contain the required 'inversedBy="ticketDispensers"' attribute.
App\Entity\FormTemplate
  • The field App\Entity\FormTemplate#tramite is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Procedure#form does not contain the required 'inversedBy="tramite"' attribute.
  • The field App\Entity\FormTemplate#turnProcedure is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Procedure#turnForm does not contain the required 'inversedBy="turnProcedure"' attribute.
  • The association App\Entity\FormTemplate#categories refers to the owning side field App\Entity\Category#formTemplates which does not exist.
App\Entity\Intern No errors.
App\Entity\Message
  • The field App\Entity\Message#displays is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Display#messages does not contain the required 'inversedBy="displays"' attribute.
App\Entity\Schedule
  • The mappings App\Entity\Schedule#specialDate and App\Entity\SpecialDate#schedule are inconsistent with each other.
  • The association App\Entity\Schedule#procedureWindow refers to the inverse side field App\Entity\ProcedureWindow#schedules which does not exist.
App\Entity\Category
  • The mappings App\Entity\Category#formTemplate and App\Entity\FormTemplate#categories are inconsistent with each other.
  • The field App\Entity\Category#sites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Site#categories does not contain the required 'inversedBy="sites"' attribute.