GET https://pruebasepa.appoloatiende.com/home/agendar

Query Metrics

18 Database Queries
8 Different statements
17.89 ms Query time
14 Invalid entities

Queries

Group similar statements

# Time Info
1 2.58 ms
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:
[
  89
]
2 0.82 ms
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:
[
  100
]
3 0.58 ms
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:
[
  104
]
4 0.40 ms
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:
[
  24
]
5 0.42 ms
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:
[
  91
]
6 0.46 ms
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:
[
  105
]
7 1.38 ms
UPDATE franja 
                        SET id_tipo_estado_franja = 1, fecha_asignacion = null
                        WHERE id_tipo_estado_franja = 3 OR id_tipo_estado_franja = 2
                        AND id_cita is null
                        AND fecha_asignacion <= :lastInterval
Parameters:
[
  "lastInterval" => "2026-04-29 20:15:09"
]
8 0.47 ms
UPDATE franja 
                        SET id_tipo_estado_franja = 2
                        WHERE id_tipo_estado_franja = 3
                        AND id_cita is not null
Parameters:
[]
9 0.41 ms
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:
[
  46
]
10 0.40 ms
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:
[
  80
]
11 0.40 ms
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:
[
  82
]
12 1.03 ms
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:
[
  94
]
13 2.07 ms
SELECT count(s0_.ip) AS sclr_0 FROM solicitud_agendamiento_pasaporte s0_ WHERE s0_.ip = ? AND s0_.fecha_hora_aceptacion_politica_datos >= ? AND s0_.fecha_hora_aceptacion_politica_datos < ?
Parameters:
[
  "216.73.217.145"
  "2026-04-29 00:00:00"
  "2026-04-29 23:59:59"
]
14 0.89 ms
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:
[
  79
]
15 1.06 ms
SELECT t0.id_tramite AS id_tramite_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.activo AS activo_4, t0.letra_turnero AS letra_turnero_5, t0.peso_en_franjas AS peso_en_franjas_6, t0.visible_citas AS visible_citas_7, t0.multiple AS multiple_8, t0.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_9, t0.turno_preferencial AS turno_preferencial_10, t0.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_11, t0.posicion AS posicion_12, t0.ruta_doc_requisitos AS ruta_doc_requisitos_13, t0.tiempo_alerta AS tiempo_alerta_14, t0.consecutivo_tramite AS consecutivo_tramite_15, t0.tipo_documental AS tipo_documental_16, t0.codigo_categoria AS codigo_categoria_17, t0.id_enterprise AS id_enterprise_18, t0.id_tipo_tramite AS id_tipo_tramite_19 FROM tramite t0 WHERE t0.id_tramite = ?
Parameters:
[
  "1"
]
16 1.88 ms
SELECT t0.id_categoria AS id_categoria_1, t0.nombre_categoria AS nombre_categoria_2, t0.activo AS activo_3, t0.id_empresa AS id_empresa_4 FROM categorias t0 INNER JOIN tramites_x_categorias ON t0.id_categoria = tramites_x_categorias.id_categoria WHERE tramites_x_categorias.id_tramite = ?
Parameters:
[
  1
]
17 1.60 ms
SELECT t0.id_ventanilla AS id_ventanilla_1, t0.nombre_ventanilla AS nombre_ventanilla_2, t0.mac_pc AS mac_pc_3, t0.direccion_ip AS direccion_ip_4, t0.activo AS activo_5, t0.ventanilla_virtual AS ventanilla_virtual_6, t0.tipo_agendamiento AS tipo_agendamiento_7, t0.cantidad_tramites_x_cita AS cantidad_tramites_x_cita_8, t0.ventanilla_masiva AS ventanilla_masiva_9, t0.cantidad_cupos AS cantidad_cupos_10, t0.com AS com_11, t0.cantidad_cupos_extra AS cantidad_cupos_extra_12, t0.ventanilla_preferencial AS ventanilla_preferencial_13, t0.id_tramite_transferencia AS id_tramite_transferencia_14, t0.id_sala AS id_sala_15 FROM ventanilla t0 INNER JOIN tramites_x_ventanilla ON t0.id_ventanilla = tramites_x_ventanilla.ventanilla_id WHERE tramites_x_ventanilla.tramite_id = ?
Parameters:
[
  1
]
18 1.04 ms
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:
[
  114
]

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\DocumentType
  • The association App\Entity\DocumentType#schedulingRequest refers to the owning side field App\Entity\SchedulingRequest#documentType which does not exist.
  • The association App\Entity\DocumentType#passportSchedulingRequest refers to the owning side field App\Entity\PassportSchedulingRequest#documentType which does not exist.
App\Entity\PassportSchedulingRequest
  • The association App\Entity\PassportSchedulingRequest#appointment refers to the inverse side field App\Entity\Appointment#passportSchedulingRequest which does not exist.
  • The association App\Entity\PassportSchedulingRequest#passportRequestType refers to the inverse side field App\Entity\PassportRequestType#passportSchedulingRequest which does not exist.
  • The mappings App\Entity\PassportSchedulingRequest#documentTypeSolicitante and App\Entity\DocumentType#passportSchedulingRequest are inconsistent with each other.
  • The mappings App\Entity\PassportSchedulingRequest#documentTypeAcompanante and App\Entity\DocumentType#passportSchedulingRequest are inconsistent with each other.
  • The association App\Entity\PassportSchedulingRequest#companionTypeId refers to the inverse side field App\Entity\CompanionType#passportSchedulingRequest which does not exist.
App\Entity\PassportRequestType
  • The mappings App\Entity\PassportRequestType#passportSchedulingRequests and App\Entity\PassportSchedulingRequest#passportRequestType are inconsistent with each other.
App\Entity\CompanionType No errors.
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\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\TypeProcess No errors.
App\Entity\ProceduresOrder No errors.
App\Entity\Turn
  • The mappings App\Entity\Turn#citizenTurn and App\Entity\CitizenTurn#turns are inconsistent with each other.
  • The mappings App\Entity\Turn#remember_turns and App\Entity\RememberTurn#turn are inconsistent with each other.
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\Appointment
  • The mappings App\Entity\Appointment#passportschedulingRequest and App\Entity\PassportSchedulingRequest#appointment are inconsistent with each other.
App\Entity\ProcedureWindow
  • The mappings App\Entity\ProcedureWindow#schedule and App\Entity\Schedule#procedureWindow are inconsistent with each other.
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\TicketDispenser
  • The mappings App\Entity\TicketDispenser#site and App\Entity\Site#ticketDispensers are inconsistent with each other.
  • If association App\Entity\TicketDispenser#site is many-to-one, then the inversed side App\Entity\Site#ticketDispensers has to be one-to-many.
  • If association App\Entity\TicketDispenser#intern is many-to-one, then the inversed side App\Entity\Intern#ticketDispensers has to be one-to-many.
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.
App\Entity\WaitingRoom No errors.
App\Entity\Interval
  • The association App\Entity\Interval#templateInterval refers to the inverse side field App\Entity\TemplateInterval#interval which does not exist.
  • The mappings App\Entity\Interval#intervalTypeStatus and App\Entity\IntervalTypeStatus#interval are inconsistent with each other.
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\StateAppointmentWindow No errors.
App\Entity\Intern No errors.