GET https://provalv.com/es/productos

Query Metrics

5 Database Queries
5 Different statements
5.33 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.65 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.imagen_principal AS imagen_principal_1, p0_.content AS content_2, p0_.galeria AS galeria_3, p0_.caracteristicas AS caracteristicas_4, p0_.columnas AS columnas_5, p0_.orden AS orden_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.content AS content_10, c1_.imagen AS imagen_11, c1_.orden AS orden_12 FROM productos p0_ LEFT JOIN categorias c1_ ON p0_.categoria_id = c1_.id ORDER BY p0_.orden ASC) dctrn_result) dctrn_table
Parameters:
[]
2 1.01 ms
SELECT p0_.id AS id_0, p0_.imagen_principal AS imagen_principal_1, p0_.content AS content_2, p0_.galeria AS galeria_3, p0_.caracteristicas AS caracteristicas_4, p0_.columnas AS columnas_5, p0_.orden AS orden_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.content AS content_10, c1_.imagen AS imagen_11, c1_.orden AS orden_12, p0_.categoria_id AS categoria_id_13 FROM productos p0_ LEFT JOIN categorias c1_ ON p0_.categoria_id = c1_.id ORDER BY p0_.orden ASC LIMIT 8
Parameters:
[]
3 1.00 ms
SELECT DISTINCT c0_.id AS id_0, c0_.content AS content_1, c0_.imagen AS imagen_2, c0_.orden AS orden_3 FROM categorias c0_ INNER JOIN productos p1_ ON (p1_.categoria_id = c0_.id) ORDER BY c0_.orden ASC
Parameters:
[]
4 1.06 ms
SELECT p0_.id AS id_0, p0_.imagen_principal AS imagen_principal_1, p0_.content AS content_2, p0_.galeria AS galeria_3, p0_.caracteristicas AS caracteristicas_4, p0_.columnas AS columnas_5, p0_.orden AS orden_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.content AS content_10, c1_.imagen AS imagen_11, c1_.orden AS orden_12, p0_.categoria_id AS categoria_id_13 FROM productos p0_ INNER JOIN categorias c1_ ON p0_.categoria_id = c1_.id ORDER BY c1_.orden ASC, p0_.orden ASC
Parameters:
[]
5 0.62 ms
SELECT t0.id AS id_1, t0.correo AS correo_2, t0.phone AS phone_3, t0.maps AS maps_4, t0.locale AS locale_5, t0.ubicacion AS ubicacion_6 FROM text t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "es"
]

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\Productos No errors.
App\Entity\Categorias No errors.
App\Entity\Text No errors.