GET https://dev.efectivate.com/blog/buscar?clave=pr%C3%A9stamo&pag=8

Query Metrics

7 Database Queries
4 Different statements
6.99 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.73 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.tiempo_lectura AS tiempo_lectura_2, b0_.visitas AS visitas_3, b0_.titulo AS titulo_4, b0_.resumen AS resumen_5, b0_.contenido AS contenido_6, b0_.keywords AS keywords_7, b0_.image AS image_8, b0_.image_size AS image_size_9, b0_.updated_at AS updated_at_10 FROM blog_entrada b0_ WHERE LOWER(b0_.keywords) LIKE ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "%préstamo%"
]
2 0.95 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.parent AS parent_4 FROM blog_categoria t0 WHERE t0.parent IS NULL
Parameters:
[]
3 1.13 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tiempo_lectura AS tiempo_lectura_3, t0.visitas AS visitas_4, t0.titulo AS titulo_5, t0.resumen AS resumen_6, t0.contenido AS contenido_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.categoria_id AS categoria_id_12, t0.created_by AS created_by_13 FROM blog_entrada t0 WHERE t0.categoria_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  1
]
4 0.88 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tiempo_lectura AS tiempo_lectura_3, t0.visitas AS visitas_4, t0.titulo AS titulo_5, t0.resumen AS resumen_6, t0.contenido AS contenido_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.categoria_id AS categoria_id_12, t0.created_by AS created_by_13 FROM blog_entrada t0 WHERE t0.categoria_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  2
]
5 0.53 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tiempo_lectura AS tiempo_lectura_3, t0.visitas AS visitas_4, t0.titulo AS titulo_5, t0.resumen AS resumen_6, t0.contenido AS contenido_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.categoria_id AS categoria_id_12, t0.created_by AS created_by_13 FROM blog_entrada t0 WHERE t0.categoria_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  3
]
6 0.52 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tiempo_lectura AS tiempo_lectura_3, t0.visitas AS visitas_4, t0.titulo AS titulo_5, t0.resumen AS resumen_6, t0.contenido AS contenido_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.categoria_id AS categoria_id_12, t0.created_by AS created_by_13 FROM blog_entrada t0 WHERE t0.categoria_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  4
]
7 1.25 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_1 FROM (SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.tiempo_lectura AS tiempo_lectura_2, b0_.visitas AS visitas_3, b0_.titulo AS titulo_4, b0_.resumen AS resumen_5, b0_.contenido AS contenido_6, b0_.keywords AS keywords_7, b0_.image AS image_8, b0_.image_size AS image_size_9, b0_.updated_at AS updated_at_10 FROM blog_entrada b0_ WHERE LOWER(b0_.keywords) LIKE ?) dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20 OFFSET 140
Parameters:
[
  "%préstamo%"
]

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\BlogEntry No errors.
App\Entity\BlogCategory No errors.
App\Entity\User No errors.