Query Metrics
20
Database Queries
10
Different statements
7.22 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.81 ms |
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2, p0_.precio AS precio_3, p0_.descripcion_completa AS descripcion_completa_4, p0_.destacado AS destacado_5, p0_.activo AS activo_6, p0_.codigo AS codigo_7, p0_.stock AS stock_8, p0_.precio_usd AS precio_usd_9, p0_.portada_id AS portada_id_10 FROM producto p0_ WHERE p0_.activo = 1 AND p0_.stock > 0 AND p0_.destacado = 1 ORDER BY p0_.destacado DESC
Parameters:
[] |
| 2 | 0.59 ms |
SELECT p0_.id AS id_0, p0_.fecha AS fecha_1, p0_.cuerpo AS cuerpo_2, p0_.titulo AS titulo_3, p0_.descripcion AS descripcion_4, p0_.autor_id AS autor_id_5, p0_.portada_id AS portada_id_6 FROM publicacion p0_ ORDER BY p0_.id DESC LIMIT 3
Parameters:
[] |
| 3 | 0.57 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_.activo = 1 ORDER BY c0_.nombre ASC
Parameters:
[] |
| 4 | 0.46 ms |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.descripcion AS descripcion_2, c0_.precio AS precio_3, c0_.activo AS activo_4, c0_.destacado AS destacado_5, c0_.informacion_adicional AS informacion_adicional_6, c0_.flag_publico AS flag_publico_7, c0_.precio_usd AS precio_usd_8 FROM curso c0_ WHERE c0_.activo = 1 AND c0_.destacado = 1 ORDER BY c0_.id DESC LIMIT 3
Parameters:
[] |
| 5 | 0.34 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:
[] |
| 6 | 0.33 ms |
SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, a0_.descripcion AS descripcion_2, a0_.link AS link_3, a0_.activo AS activo_4, a0_.imagen_id AS imagen_id_5 FROM acceso_directo a0_ WHERE a0_.activo = 1 ORDER BY a0_.id DESC
Parameters:
[] |
| 7 | 0.36 ms |
SELECT t0.id AS id_1, t0.mensaje AS mensaje_2, t0.activo AS activo_3, t0.tipo AS tipo_4 FROM configuracion t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 8 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.email AS email_2, c0_.mensaje AS mensaje_3, c0_.fecha AS fecha_4, c0_.leido AS leido_5, c0_.tipo AS tipo_6, c0_.flag_destacado AS flag_destacado_7, c0_.usuario_logueado_id AS usuario_logueado_id_8 FROM contacto c0_ WHERE c0_.flag_destacado = 1 ORDER BY c0_.id DESC
Parameters:
[] |
| 9 | 0.42 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.id = ?
Parameters:
[
78
]
|
| 10 | 0.21 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.id = ?
Parameters:
[
113
]
|
| 11 | 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.id = ?
Parameters:
[
79
]
|
| 12 | 0.23 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.id = ?
Parameters:
[
187
]
|
| 13 | 0.20 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.id = ?
Parameters:
[
186
]
|
| 14 | 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.id = ?
Parameters:
[
185
]
|
| 15 | 0.51 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.mail AS mail_3, t0.roles AS roles_4, t0.password AS password_5, t0.telefono AS telefono_6, t0.apellido AS apellido_7, t0.nombre AS nombre_8, t9.id AS id_10, t9.monto AS monto_11, t9.monto_usd AS monto_usd_12, t9.usuario_id AS usuario_id_13, t0.direccion_id AS direccion_id_14, t0.avatar_id AS avatar_id_15 FROM `user` t0 LEFT JOIN carrito t9 ON t9.usuario_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
| 16 | 0.44 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.id = ?
Parameters:
[
191
]
|
| 17 | 0.33 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.mail AS mail_3, t0.roles AS roles_4, t0.password AS password_5, t0.telefono AS telefono_6, t0.apellido AS apellido_7, t0.nombre AS nombre_8, t9.id AS id_10, t9.monto AS monto_11, t9.monto_usd AS monto_usd_12, t9.usuario_id AS usuario_id_13, t0.direccion_id AS direccion_id_14, t0.avatar_id AS avatar_id_15 FROM `user` t0 LEFT JOIN carrito t9 ON t9.usuario_id = t0.id WHERE t0.id = ?
Parameters:
[
3
]
|
| 18 | 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.id = ?
Parameters:
[
189
]
|
| 19 | 0.31 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.mail AS mail_3, t0.roles AS roles_4, t0.password AS password_5, t0.telefono AS telefono_6, t0.apellido AS apellido_7, t0.nombre AS nombre_8, t9.id AS id_10, t9.monto AS monto_11, t9.monto_usd AS monto_usd_12, t9.usuario_id AS usuario_id_13, t0.direccion_id AS direccion_id_14, t0.avatar_id AS avatar_id_15 FROM `user` t0 LEFT JOIN carrito t9 ON t9.usuario_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
| 20 | 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.id = ?
Parameters:
[
192
]
|
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\Publicacion | No errors. |
| App\Entity\Producto | No errors. |
| App\Entity\Curso | No errors. |
| App\Entity\Categoria | No errors. |
| App\Entity\AccesoDirecto | No errors. |
| App\Entity\Configuracion | No errors. |
| App\Entity\Contacto | No errors. |
| App\Entity\Imagen | No errors. |
| App\Entity\ProductosCarrito | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Archivo | No errors. |
| App\Entity\Clase | No errors. |
| App\Entity\Album | No errors. |
| App\Entity\Carrito | No errors. |
| App\Entity\Direccion | No errors. |
| App\Entity\Venta | No errors. |