1 |
3.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%"
]
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 '%préstamo%' ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;
|
2 |
3.28 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
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;
|
3 |
0.97 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
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 = 1 ORDER BY t0.created_at DESC;
|
4 |
0.57 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
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 = 2 ORDER BY t0.created_at DESC;
|
5 |
0.48 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
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 = 3 ORDER BY t0.created_at DESC;
|
6 |
0.38 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
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 = 4 ORDER BY t0.created_at DESC;
|
7 |
0.82 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 380
Parameters: [
"%préstamo%"
]
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 '%préstamo%') dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20 OFFSET 380;
|