3.83 ms (43.96%)
|
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
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;
|
1.44 ms (16.58%)
|
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 = ?
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 = '83533';
|
1.37 ms (15.72%)
|
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 b0_.created_by = ?) dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20 OFFSET 2660
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 b0_.created_by = '83533') dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20 OFFSET 2660;
|
1.23 ms (14.18%)
|
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 b0_.created_by = ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table
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 b0_.created_by = '83533' ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;
|