GET https://largeformatsupplies.store/materiales/23

Query Metrics

14 Database Queries
4 Different statements
2.39 ms Query time
0 Invalid entities
39 Managed entities

Queries

Group similar statements

# Time Info
1 0.27 ms
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "23"
]
2 0.67 ms
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.resumen AS resumen_2, p0_.descripcion AS descripcion_3, p0_.cabezal AS cabezal_4, p0_.resolucion AS resolucion_5, p0_.tinta AS tinta_6, p0_.url AS url_7, p0_.meta_titulo AS meta_titulo_8, p0_.meta_descripcion AS meta_descripcion_9, p0_.meta_keywords AS meta_keywords_10, p0_.activo AS activo_11, p0_.categorias AS categorias_12, p0_.sub_titulo AS sub_titulo_13, p0_.velocidades AS velocidades_14, p0_.materiales AS materiales_15, p0_.configuracion_cabezales AS configuracion_cabezales_16, p0_.h_estandard AS h_estandard_17, p0_.h_opcionales AS h_opcionales_18, p0_.area_corte AS area_corte_19, p0_.espesor AS espesor_20, p0_.min_hoja AS min_hoja_21, p0_.max_hoja AS max_hoja_22, p0_.min_caja AS min_caja_23, p0_.max_caja AS max_caja_24, p0_.categoria_id AS categoria_id_25 FROM productos p0_ WHERE JSON_CONTAINS(p0_.categorias, ?, '$') = 1 ORDER BY p0_.nombre DESC LIMIT 20
Parameters:
[
  ""23""
]
3 0.21 ms
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.padre = ?
Parameters:
[
  3
]
4 0.13 ms
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.padre = ?
Parameters:
[
  4
]
5 0.08 ms
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.padre = ?
Parameters:
[
  16
]
6 0.15 ms
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.padre = ?
Parameters:
[
  19
]
7 0.25 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  77
]
8 0.12 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  64
]
9 0.13 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  69
]
10 0.08 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  78
]
11 0.08 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  72
]
12 0.10 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  70
]
13 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  71
]
14 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?
Parameters:
[
  68
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Categorias 22
App\Entity\Imagenes 9
App\Entity\Productos 8

Entities Mapping

Class Mapping errors
App\Entity\Categorias No errors.
App\Entity\Productos No errors.
App\Entity\Videos No errors.
App\Entity\Imagenes No errors.
App\Entity\Archivos No errors.
App\Entity\Cabezales No errors.