https://test.paomdisyart.com/cursos/categoria/1

Query Metrics

30 Database Queries
6 Different statements
6.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.38 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 0.32 ms
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.descripcion AS descripcion_2, c0_.flagproducto AS flagproducto_3, c0_.activo AS activo_4, c0_.imagen_id AS imagen_id_5 FROM categoria c0_ WHERE c0_.flagproducto = 0 AND c0_.activo = 1 ORDER BY c0_.nombre ASC
Parameters:
[]
3 0.38 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.activo AS activo_5, t0.destacado AS destacado_6, t0.informacion_adicional AS informacion_adicional_7, t0.flag_publico AS flag_publico_8, t0.precio_usd AS precio_usd_9 FROM curso t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.curso_id WHERE curso_categoria.categoria_id = ?
Parameters:
[
  1
]
4 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  27
]
5 0.25 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  27
]
6 0.22 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  27
]
7 0.22 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  5
]
8 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  5
]
9 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  5
]
10 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  6
]
11 0.22 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  6
]
12 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  6
]
13 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  7
]
14 0.19 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  7
]
15 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  7
]
16 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  11
]
17 0.20 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  11
]
18 0.18 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  11
]
19 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  12
]
20 0.20 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  12
]
21 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  12
]
22 0.19 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  37
]
23 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  37
]
24 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  37
]
25 0.19 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  38
]
26 0.20 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  38
]
27 0.15 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  38
]
28 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.curso_id = ?
Parameters:
[
  35
]
29 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
  35
]
30 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
  35
]

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\Curso No errors.
App\Entity\Archivo No errors.
App\Entity\Imagen No errors.
App\Entity\Categoria No errors.
App\Entity\Parametro No errors.
App\Entity\User No errors.
App\Entity\Venta No errors.
App\Entity\Estadoventa No errors.
App\Entity\TipoVenta No errors.
App\Entity\Producto No errors.
App\Entity\Clase No errors.
App\Entity\Publicacion No errors.
App\Entity\Album No errors.
App\Entity\Video No errors.