GET https://praktiker.wdemo.net/es/solicitud/actividades

Query Metrics

40 Database Queries
8 Different statements
15.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT t0_.id AS id_0, t0_.nombre_es AS nombre_es_1, t0_.codigo AS codigo_2, t0_.label AS label_3, t0_.modalidad AS modalidad_4, t0_.tipo AS tipo_5, t0_.tipopractica_es AS tipopractica_es_6, t0_.nombre_eu AS nombre_eu_7, t0_.tipopractica_eu AS tipopractica_eu_8, t0_.nivel AS nivel_9 FROM titulacion t0_ WHERE t0_.modalidad = ? ORDER BY t0_.id ASC
Parameters:
[
  "corta"
]
2 0.27 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  2
]
3 0.13 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  3
]
4 0.16 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  4
]
5 0.17 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  5
]
6 0.13 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  6
]
7 0.13 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  7
]
8 0.11 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  8
]
9 0.10 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  9
]
10 0.11 ms
SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?
Parameters:
[
  10
]
11 0.26 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a0_.visible AS visible_2, a0_.nombre_eu AS nombre_eu_3 FROM area a0_ WHERE a0_.visible = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  1
]
12 0.25 ms
SELECT f0_.id AS id_0, f0_.nombre_es AS nombre_es_1, f0_.visible AS visible_2, f0_.nombre_eu AS nombre_eu_3, f0_.area_id AS area_id_4 FROM funcion f0_
Parameters:
[]
13 0.28 ms
SELECT t0_.id AS id_0, t0_.nombre_es AS nombre_es_1, t0_.tipopractica_es AS tipopractica_es_2 FROM titulacion t0_
Parameters:
[]
14 0.31 ms
SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
15 1.31 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  1
]
16 0.37 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  1
]
17 0.72 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  2
]
18 1.50 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  2
]
19 0.96 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  3
]
20 0.35 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  3
]
21 0.68 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  4
]
22 0.33 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  4
]
23 0.68 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  5
]
24 0.33 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  5
]
25 0.68 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  6
]
26 0.37 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  6
]
27 0.44 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  7
]
28 0.26 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  7
]
29 0.74 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  8
]
30 0.38 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  8
]
31 0.52 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  9
]
32 0.28 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  9
]
33 0.54 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  10
]
34 0.27 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  10
]
35 0.23 ms
SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = ?
Parameters:
[
  11
]
36 0.22 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  11
]
37 0.14 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  11
]
38 0.17 ms
SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = ?
Parameters:
[
  12
]
39 0.17 ms
SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_es ASC
Parameters:
[
  12
]
40 0.13 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?
Parameters:
[
  12
]

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\Titulacion No errors.
App\Entity\Area No errors.
App\Entity\Keyword No errors.
App\Entity\Funcion No errors.
App\Entity\ActividadTitulacion No errors.
App\Entity\InfoTitulacion No errors.
App\Entity\PerfilCompetencial No errors.
App\Entity\Actividad No errors.