GET https://dev.efectivate.com/blog/buscar?clave=apoyo

Query Metrics

9 Database Queries
6 Different statements
6.76 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.58 ms
(38.14%)
4
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
]
1.43 ms
(21.19%)
1
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:
[
  "%apoyo%"
]
0.80 ms
(11.86%)
1
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
Parameters:
[
  "%apoyo%"
]
0.74 ms
(10.90%)
1
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, b0_.categoria_id AS categoria_id_11, b0_.created_by AS created_by_12 FROM blog_entrada b0_ WHERE LOWER(b0_.keywords) LIKE ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC
Parameters:
[
  "%apoyo%"
  30
  29
  25
  24
  23
  22
  20
  19
  18
  17
  9
  2
]
0.68 ms
(9.99%)
1
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:
[]
0.54 ms
(7.92%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.dark_mode AS dark_mode_14, t0.nombres AS nombres_15, t0.apellidos AS apellidos_16, t0.telefono AS telefono_17, t0.cod_postal AS cod_postal_18, t0.estado AS estado_19, t0.ciudad AS ciudad_20, t0.direccion AS direccion_21, t0.roles AS roles_22, t0.password AS password_23, t0.fetch_id AS fetch_id_24 FROM usuario t0 WHERE t0.id = ?
Parameters:
[
  83533
]

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.