https://test.paomdisyart.com/

Query Metrics

20 Database Queries
10 Different statements
7.42 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.78 ms
(37.48%)
9
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
]
1.30 ms
(17.54%)
3
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
]
0.52 ms
(7.05%)
1
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:
[]
0.52 ms
(6.95%)
1
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:
[]
0.49 ms
(6.57%)
1
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:
[]
0.46 ms
(6.15%)
1
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:
[]
0.37 ms
(4.97%)
1
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:
[]
0.34 ms
(4.53%)
1
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
]
0.33 ms
(4.51%)
1
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:
[]
0.32 ms
(4.26%)
1
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:
[]

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.