GET https://provalv.com/es/productos?categoria=2

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.85 ms
(32.91%)
1
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 WHERE c1_.id = ? ORDER BY p0_.orden ASC) dctrn_result) dctrn_table
Parameters:
[
  2
]
1.34 ms
(23.76%)
1
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:
[]
0.99 ms
(17.63%)
1
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:
[]
0.80 ms
(14.16%)
1
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 WHERE c1_.id = ? ORDER BY p0_.orden ASC LIMIT 8
Parameters:
[
  2
]
0.65 ms
(11.53%)
1
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.