https://pruebassl1.cultura.gob.cl/api/admin/secure/convocatoria/2

Query Metrics

18 Database Queries
8 Different statements
9.96 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombres AS nombres_5, t0.activo AS activo_6, t0.super_admin AS super_admin_7, t0.region_id AS region_id_8 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "dcqy.95@gmail.com"
]
2 0.55 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.anio AS anio_4, t0.bases AS bases_5, t0.presupuesto AS presupuesto_6, t0.puntaje_eval_corte AS puntaje_eval_corte_7, t0.cuestionarios AS cuestionarios_8, t0.documentos AS documentos_9, t0.estado AS estado_10, t0.apertura AS apertura_11 FROM pc_convocatorias t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
3 0.26 ms
"START TRANSACTION"
Parameters:
[]
4 0.51 ms
UPDATE pc_convocatorias SET anio = ?, puntaje_eval_corte = ?, estado = ?, apertura = ? WHERE id = ?
Parameters:
[
  2025
  80
  "1"
  1
  2
]
5 1.20 ms
"COMMIT"
Parameters:
[]
6 0.46 ms
SELECT t0.id AS id_1, t0.peso AS peso_2, t0.convocatorias_id AS convocatorias_id_3, t0.criterios_id AS criterios_id_4 FROM pc_criterios_convocatorias t0 WHERE t0.convocatorias_id = ?
Parameters:
[
  2
]
7 0.25 ms
"START TRANSACTION"
Parameters:
[]
8 0.43 ms
DELETE FROM pc_criterios_convocatorias WHERE id = ?
Parameters:
[
  10
]
9 1.00 ms
"COMMIT"
Parameters:
[]
10 0.20 ms
"START TRANSACTION"
Parameters:
[]
11 0.42 ms
DELETE FROM pc_criterios_convocatorias WHERE id = ?
Parameters:
[
  11
]
12 0.83 ms
"COMMIT"
Parameters:
[]
13 0.22 ms
"START TRANSACTION"
Parameters:
[]
14 0.94 ms
INSERT INTO pc_criterios_convocatorias (peso, convocatorias_id, criterios_id) VALUES (?, ?, ?)
Parameters:
[
  60
  2
  1
]
15 0.44 ms
"COMMIT"
Parameters:
[]
16 0.19 ms
"START TRANSACTION"
Parameters:
[]
17 0.39 ms
INSERT INTO pc_criterios_convocatorias (peso, convocatorias_id, criterios_id) VALUES (?, ?, ?)
Parameters:
[
  40
  2
  2
]
18 0.82 ms
"COMMIT"
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\User No errors.
App\Entity\Region No errors.
App\Entity\PcConvocatorias
  • The association App\Entity\PcConvocatorias#postulacion refers to the owning side field App\Entity\PcPuntoCultura#puntoCultura which does not exist.
App\Entity\PcCriteriosConvocatorias No errors.
App\Entity\PcPuntoCultura
  • The association App\Entity\PcPuntoCultura#postulacion refers to the owning side field App\Entity\PcPuntoCultura#puntoCultura which does not exist.
App\Entity\PcCriterios No errors.