Symfony Profiler

(
  SELECT
    entry.id,
    entry.created_at,
    entry.score,
    entry.ranking,
    entry.last_active,
    entry.comment_count,
    'entry' AS type
  FROM
    entry
    INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id
    INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
  WHERE
    entry.visibility = :visibility
    AND m_entry.visibility = :visibility
    AND entry.user_id = :criteria_user
    AND entry.is_adult = false
    AND m_entry.is_adult = false
    AND (
      entry.created_at BETWEEN :timeFrom
      AND :timeTo
    )
)
UNION
  (
    SELECT
      post.id,
      post.created_at,
      post.score,
      post.ranking,
      post.last_active,
      post.comment_count,
      'post' AS type
    FROM
      post
      INNER JOIN magazine m_post ON post.magazine_id = m_post.id
      INNER JOIN "user" u_post ON post.user_id = u_post.id
    WHERE
      post.visibility = :visibility
      AND m_post.visibility = :visibility
      AND post.user_id = :criteria_user
      AND post.is_adult = false
      AND m_post.is_adult = false
      AND (
        post.created_at BETWEEN :timeFrom
        AND :timeTo
      )
  )
UNION
  (
    SELECT
      entry_comment.id,
      entry_comment.created_at,
      entry_comment.score,
      entry_comment.score + entry_comment.favourite_count AS ranking,
      entry_comment.last_active,
      0 as comment_count,
      'entry_comment' AS type
    FROM
      entry_comment
      INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id
      INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id
    WHERE
      entry_comment.visibility = :visibility
      AND m_entry_comment.visibility = :visibility
      AND entry_comment.user_id = :criteria_user
      AND entry_comment.is_adult = false
      AND m_entry_comment.is_adult = false
      AND (
        entry_comment.created_at BETWEEN :timeFrom
        AND :timeTo
      )
  )
UNION
  (
    SELECT
      post_comment.id,
      post_comment.created_at,
      post_comment.score,
      post_comment.score + post_comment.favourite_count AS ranking,
      post_comment.last_active,
      0 as comment_count,
      'post_comment' AS type
    FROM
      post_comment
      INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id
      INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id
    WHERE
      post_comment.visibility = :visibility
      AND m_post_comment.visibility = :visibility
      AND post_comment.user_id = :criteria_user
      AND post_comment.is_adult = false
      AND m_post_comment.is_adult = false
      AND (
        post_comment.created_at BETWEEN :timeFrom
        AND :timeTo
      )
  )
ORDER BY
  comment_count DESC,
  created_at DESC
LIMIT
  25000

(
        SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type 
        FROM entry 
        INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id 
        INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
        
            WHERE entry.visibility = 'visible'
            AND m_entry.visibility = 'visible'
            
            AND entry.user_id = 89402
            
            AND entry.is_adult = false
            AND m_entry.is_adult = false
            
            AND (entry.created_at BETWEEN '2024-03-09 15:46:24' AND '2025-03-09 15:46:24')
            
        )
        UNION
        (
        SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type 
        FROM post 
        INNER JOIN magazine m_post ON post.magazine_id = m_post.id 
        INNER JOIN "user" u_post ON post.user_id = u_post.id
        
            WHERE post.visibility = 'visible'
            AND m_post.visibility = 'visible'
            
            AND post.user_id = 89402
            
            AND post.is_adult = false
            AND m_post.is_adult = false
            
            AND (post.created_at BETWEEN '2024-03-09 15:46:24' AND '2025-03-09 15:46:24')
            
        )
        
        UNION
        (
        SELECT entry_comment.id, entry_comment.created_at, entry_comment.score, entry_comment.score + entry_comment.favourite_count AS ranking, entry_comment.last_active, 0 as comment_count, 'entry_comment' AS type 
        FROM entry_comment 
        INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id 
        INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id
        
            WHERE entry_comment.visibility = 'visible'
            AND m_entry_comment.visibility = 'visible'
            
            AND entry_comment.user_id = 89402
            
            AND entry_comment.is_adult = false
            AND m_entry_comment.is_adult = false
            
            AND (entry_comment.created_at BETWEEN '2024-03-09 15:46:24' AND '2025-03-09 15:46:24')
            
        )
        UNION
        (
        SELECT post_comment.id, post_comment.created_at, post_comment.score, post_comment.score + post_comment.favourite_count AS ranking, post_comment.last_active, 0 as comment_count, 'post_comment' AS type 
        FROM post_comment 
        INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id 
        INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id
        
            WHERE post_comment.visibility = 'visible'
            AND m_post_comment.visibility = 'visible'
            
            AND post_comment.user_id = 89402
            
            AND post_comment.is_adult = false
            AND m_post_comment.is_adult = false
            
            AND (post_comment.created_at BETWEEN '2024-03-09 15:46:24' AND '2025-03-09 15:46:24')
            
        )
        ORDER BY comment_count DESC, created_at DESC LIMIT 25000;

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.type AS type_5,
  t0.lang AS lang_6,
  t0.is_oc AS is_oc_7,
  t0.has_embed AS has_embed_8,
  t0.comment_count AS comment_count_9,
  t0.favourite_count AS favourite_count_10,
  t0.score AS score_11,
  t0.is_adult AS is_adult_12,
  t0.sticky AS sticky_13,
  t0.last_active AS last_active_14,
  t0.ip AS ip_15,
  t0.ada_amount AS ada_amount_16,
  t0.tags AS tags_17,
  t0.mentions AS mentions_18,
  t0.id AS id_19,
  t0.title_ts AS title_ts_20,
  t0.body_ts AS body_ts_21,
  t0.up_votes AS up_votes_22,
  t0.down_votes AS down_votes_23,
  t0.ranking AS ranking_24,
  t0.visibility AS visibility_25,
  t0.ap_id AS ap_id_26,
  t0.edited_at AS edited_at_27,
  t0.created_at AS created_at_28,
  t0.user_id AS user_id_29,
  t0.magazine_id AS magazine_id_30,
  t0.image_id AS image_id_31,
  t0.domain_id AS domain_id_32
FROM
  entry t0
WHERE
  t0.id IN (NULL)

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (NULL);

SELECT
  t0.slug AS slug_1,
  t0.body AS body_2,
  t0.lang AS lang_3,
  t0.comment_count AS comment_count_4,
  t0.favourite_count AS favourite_count_5,
  t0.score AS score_6,
  t0.is_adult AS is_adult_7,
  t0.sticky AS sticky_8,
  t0.last_active AS last_active_9,
  t0.ip AS ip_10,
  t0.tags AS tags_11,
  t0.mentions AS mentions_12,
  t0.id AS id_13,
  t0.body_ts AS body_ts_14,
  t0.up_votes AS up_votes_15,
  t0.down_votes AS down_votes_16,
  t0.ranking AS ranking_17,
  t0.visibility AS visibility_18,
  t0.ap_id AS ap_id_19,
  t0.edited_at AS edited_at_20,
  t0.created_at AS created_at_21,
  t0.user_id AS user_id_22,
  t0.magazine_id AS magazine_id_23,
  t0.image_id AS image_id_24
FROM
  post t0
WHERE
  t0.id IN (NULL)

SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL);

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.is_adult AS is_adult_3,
  t0.favourite_count AS favourite_count_4,
  t0.score AS score_5,
  t0.last_active AS last_active_6,
  t0.ip AS ip_7,
  t0.tags AS tags_8,
  t0.mentions AS mentions_9,
  t0.id AS id_10,
  t0.body_ts AS body_ts_11,
  t0.up_votes AS up_votes_12,
  t0.down_votes AS down_votes_13,
  t0.visibility AS visibility_14,
  t0.ap_id AS ap_id_15,
  t0.edited_at AS edited_at_16,
  t0.created_at AS created_at_17,
  t0.user_id AS user_id_18,
  t0.entry_id AS entry_id_19,
  t0.magazine_id AS magazine_id_20,
  t0.image_id AS image_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23
FROM
  entry_comment t0
WHERE
  t0.id IN (NULL)

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id IN (NULL);

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.favourite_count AS favourite_count_3,
  t0.score AS score_4,
  t0.last_active AS last_active_5,
  t0.ip AS ip_6,
  t0.tags AS tags_7,
  t0.mentions AS mentions_8,
  t0.is_adult AS is_adult_9,
  t0.update_mark AS update_mark_10,
  t0.id AS id_11,
  t0.body_ts AS body_ts_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.visibility AS visibility_15,
  t0.ap_id AS ap_id_16,
  t0.edited_at AS edited_at_17,
  t0.created_at AS created_at_18,
  t0.user_id AS user_id_19,
  t0.post_id AS post_id_20,
  t0.magazine_id AS magazine_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23,
  t0.image_id AS image_id_24
FROM
  post_comment t0
WHERE
  t0.id IN (NULL)

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id IN (NULL);

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.type AS type_5,
  t0.lang AS lang_6,
  t0.is_oc AS is_oc_7,
  t0.has_embed AS has_embed_8,
  t0.comment_count AS comment_count_9,
  t0.favourite_count AS favourite_count_10,
  t0.score AS score_11,
  t0.is_adult AS is_adult_12,
  t0.sticky AS sticky_13,
  t0.last_active AS last_active_14,
  t0.ip AS ip_15,
  t0.ada_amount AS ada_amount_16,
  t0.tags AS tags_17,
  t0.mentions AS mentions_18,
  t0.id AS id_19,
  t0.title_ts AS title_ts_20,
  t0.body_ts AS body_ts_21,
  t0.up_votes AS up_votes_22,
  t0.down_votes AS down_votes_23,
  t0.ranking AS ranking_24,
  t0.visibility AS visibility_25,
  t0.ap_id AS ap_id_26,
  t0.edited_at AS edited_at_27,
  t0.created_at AS created_at_28,
  t0.user_id AS user_id_29,
  t0.magazine_id AS magazine_id_30,
  t0.image_id AS image_id_31,
  t0.domain_id AS domain_id_32
FROM
  entry t0
WHERE
  t0.user_id = ?

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.user_id = 89402;

SELECT
  COUNT(*)
FROM
  entry_comment t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM entry_comment t0 WHERE t0.user_id = 89402;

SELECT
  COUNT(*)
FROM
  post t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM post t0 WHERE t0.user_id = 89402;

SELECT
  COUNT(*)
FROM
  post_comment t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM post_comment t0 WHERE t0.user_id = 89402;

(
  SELECT
    entry_id as id,
    created_at,
    'entry' AS type
  FROM
    entry_vote
  WHERE
    user_id = :userId
    AND choice = 1
)
UNION
  (
    SELECT
      comment_id as id,
      created_at,
      'entry_comment' AS type
    FROM
      entry_comment_vote
    WHERE
      user_id = :userId
      AND choice = 1
  )
UNION
  (
    SELECT
      post_id as id,
      created_at,
      'post' AS type
    FROM
      post_vote
    WHERE
      user_id = :userId
      AND choice = 1
  )
UNION
  (
    SELECT
      comment_id as id,
      created_at,
      'post_comment' AS type
    FROM
      post_comment_vote
    WHERE
      user_id = :userId
      AND choice = 1
  )
ORDER BY
  created_at DESC

(SELECT entry_id as id, created_at, 'entry' AS type FROM entry_vote WHERE user_id = 89402 AND choice = 1)
        UNION
        (SELECT comment_id as id, created_at, 'entry_comment' AS type FROM entry_comment_vote WHERE user_id = 89402 AND choice = 1)
        UNION
        (SELECT post_id as id, created_at, 'post' AS type FROM post_vote WHERE user_id = 89402 AND choice = 1)
        UNION
        (SELECT comment_id as id, created_at, 'post_comment' AS type FROM post_comment_vote WHERE user_id = 89402 AND choice = 1)
        ORDER BY created_at DESC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.follower_id AS follower_id_3,
  t0.following_id AS following_id_4
FROM
  user_follow t0
WHERE
  t0.follower_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.follower_id AS follower_id_3, t0.following_id AS following_id_4 FROM user_follow t0 WHERE t0.follower_id = 89402 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.follower_id AS follower_id_3,
  t0.following_id AS following_id_4
FROM
  user_follow t0
WHERE
  t0.following_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.follower_id AS follower_id_3, t0.following_id AS following_id_4 FROM user_follow t0 WHERE t0.following_id = 89402 ORDER BY t0.created_at DESC;

SELECT
  (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            entry_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            entry_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) + (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            entry_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            entry_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) + (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            post_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            post_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) + (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            post_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            post_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) as total

SELECT
                    (SELECT SUM(
            (SELECT COUNT(id) FROM entry_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM entry_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM post_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM post_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = 89402 AND user_id != 89402 AND choice = -1)
        )) as total;

SELECT
  (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN entry fj ON f.entry_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) + (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN entry_comment fj ON f.entry_comment_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) + (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN post fj ON f.post_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) + (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN post_comment fj ON f.post_comment_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) as total

SELECT
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN entry fj ON f.entry_id = fj.id
                WHERE fj.user_id = 89402 AND f.user_id != 89402) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN entry_comment fj ON f.entry_comment_id = fj.id
                WHERE fj.user_id = 89402 AND f.user_id != 89402) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN post fj ON f.post_id = fj.id
                WHERE fj.user_id = 89402 AND f.user_id != 89402) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN post_comment fj ON f.post_comment_id = fj.id
                WHERE fj.user_id = 89402 AND f.user_id != 89402) as total;

SELECT
  m0_.name AS name_0,
  m0_.title AS title_1,
  m0_.description AS description_2,
  m0_.rules AS rules_3,
  m0_.subscriptions_count AS subscriptions_count_4,
  m0_.entry_count AS entry_count_5,
  m0_.entry_comment_count AS entry_comment_count_6,
  m0_.post_count AS post_count_7,
  m0_.post_comment_count AS post_comment_count_8,
  m0_.is_adult AS is_adult_9,
  m0_.custom_css AS custom_css_10,
  m0_.last_active AS last_active_11,
  m0_.marked_for_deletion_at AS marked_for_deletion_at_12,
  m0_.tags AS tags_13,
  m0_.id AS id_14,
  m0_.ap_id AS ap_id_15,
  m0_.ap_profile_id AS ap_profile_id_16,
  m0_.ap_public_url AS ap_public_url_17,
  m0_.ap_followers_url AS ap_followers_url_18,
  m0_.ap_inbox_url AS ap_inbox_url_19,
  m0_.ap_domain AS ap_domain_20,
  m0_.ap_preferred_username AS ap_preferred_username_21,
  m0_.ap_discoverable AS ap_discoverable_22,
  m0_.ap_manually_approves_followers AS ap_manually_approves_followers_23,
  m0_.private_key AS private_key_24,
  m0_.public_key AS public_key_25,
  m0_.ap_fetched_at AS ap_fetched_at_26,
  m0_.ap_deleted_at AS ap_deleted_at_27,
  m0_.ap_timeout_at AS ap_timeout_at_28,
  m0_.visibility AS visibility_29,
  m0_.created_at AS created_at_30,
  m0_.icon_id AS icon_id_31
FROM
  magazine m0_
WHERE
  m0_.id IN (
    SELECT
      m1_.magazine_id AS sclr_32
    FROM
      moderator m1_
    WHERE
      m1_.user_id = ?
  )
ORDER BY
  m0_.ap_id DESC,
  m0_.last_active DESC

SELECT m0_.name AS name_0, m0_.title AS title_1, m0_.description AS description_2, m0_.rules AS rules_3, m0_.subscriptions_count AS subscriptions_count_4, m0_.entry_count AS entry_count_5, m0_.entry_comment_count AS entry_comment_count_6, m0_.post_count AS post_count_7, m0_.post_comment_count AS post_comment_count_8, m0_.is_adult AS is_adult_9, m0_.custom_css AS custom_css_10, m0_.last_active AS last_active_11, m0_.marked_for_deletion_at AS marked_for_deletion_at_12, m0_.tags AS tags_13, m0_.id AS id_14, m0_.ap_id AS ap_id_15, m0_.ap_profile_id AS ap_profile_id_16, m0_.ap_public_url AS ap_public_url_17, m0_.ap_followers_url AS ap_followers_url_18, m0_.ap_inbox_url AS ap_inbox_url_19, m0_.ap_domain AS ap_domain_20, m0_.ap_preferred_username AS ap_preferred_username_21, m0_.ap_discoverable AS ap_discoverable_22, m0_.ap_manually_approves_followers AS ap_manually_approves_followers_23, m0_.private_key AS private_key_24, m0_.public_key AS public_key_25, m0_.ap_fetched_at AS ap_fetched_at_26, m0_.ap_deleted_at AS ap_deleted_at_27, m0_.ap_timeout_at AS ap_timeout_at_28, m0_.visibility AS visibility_29, m0_.created_at AS created_at_30, m0_.icon_id AS icon_id_31 FROM magazine m0_ WHERE m0_.id IN (SELECT m1_.magazine_id AS sclr_32 FROM moderator m1_ WHERE m1_.user_id = 89402) ORDER BY m0_.ap_id DESC, m0_.last_active DESC;

SELECT
  u0_.email AS email_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.followers_count AS followers_count_3,
  u0_.homepage AS homepage_4,
  u0_.about AS about_5,
  u0_.last_active AS last_active_6,
  u0_.marked_for_deletion_at AS marked_for_deletion_at_7,
  u0_.fields AS fields_8,
  u0_.oauth_github_id AS oauth_github_id_9,
  u0_.oauth_google_id AS oauth_google_id_10,
  u0_.oauth_facebook_id AS oauth_facebook_id_11,
  u0_.oauth_keycloak_id AS oauth_keycloak_id_12,
  u0_.hide_adult AS hide_adult_13,
  u0_.show_subscribed_users AS show_subscribed_users_14,
  u0_.show_subscribed_magazines AS show_subscribed_magazines_15,
  u0_.show_subscribed_domains AS show_subscribed_domains_16,
  u0_.preferred_languages AS preferred_languages_17,
  u0_.featured_magazines AS featured_magazines_18,
  u0_.show_profile_subscriptions AS show_profile_subscriptions_19,
  u0_.show_profile_followings AS show_profile_followings_20,
  u0_.mark_new_comments AS mark_new_comments_21,
  u0_.notify_on_new_entry AS notify_on_new_entry_22,
  u0_.notify_on_new_entry_reply AS notify_on_new_entry_reply_23,
  u0_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_24,
  u0_.notify_on_new_post AS notify_on_new_post_25,
  u0_.notify_on_new_post_reply AS notify_on_new_post_reply_26,
  u0_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_27,
  u0_.add_mentions_entries AS add_mentions_entries_28,
  u0_.add_mentions_posts AS add_mentions_posts_29,
  u0_.is_banned AS is_banned_30,
  u0_.is_verified AS is_verified_31,
  u0_.is_deleted AS is_deleted_32,
  u0_.is_bot AS is_bot_33,
  u0_.spam_protection AS spam_protection_34,
  u0_.custom_css AS custom_css_35,
  u0_.ignore_magazines_custom_css AS ignore_magazines_custom_css_36,
  u0_.id AS id_37,
  u0_.password AS password_38,
  u0_.totp_secret AS totp_secret_39,
  u0_.totp_backup_codes AS totp_backup_codes_40,
  u0_.ap_id AS ap_id_41,
  u0_.ap_profile_id AS ap_profile_id_42,
  u0_.ap_public_url AS ap_public_url_43,
  u0_.ap_followers_url AS ap_followers_url_44,
  u0_.ap_inbox_url AS ap_inbox_url_45,
  u0_.ap_domain AS ap_domain_46,
  u0_.ap_preferred_username AS ap_preferred_username_47,
  u0_.ap_discoverable AS ap_discoverable_48,
  u0_.ap_manually_approves_followers AS ap_manually_approves_followers_49,
  u0_.private_key AS private_key_50,
  u0_.public_key AS public_key_51,
  u0_.ap_fetched_at AS ap_fetched_at_52,
  u0_.ap_deleted_at AS ap_deleted_at_53,
  u0_.ap_timeout_at AS ap_timeout_at_54,
  u0_.visibility AS visibility_55,
  u0_.created_at AS created_at_56,
  u0_.avatar_id AS avatar_id_57,
  u0_.cover_id AS cover_id_58
FROM
  "user" u0_
  INNER JOIN image i1_ ON u0_.avatar_id = i1_.id
WHERE
  u0_.last_active >= ?
  AND u0_.is_banned = false
  AND u0_.ap_deleted_at IS NULL
  AND u0_.avatar_id IS NOT NULL
ORDER BY
  u0_.last_active DESC
LIMIT
  35

SELECT u0_.email AS email_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.followers_count AS followers_count_3, u0_.homepage AS homepage_4, u0_.about AS about_5, u0_.last_active AS last_active_6, u0_.marked_for_deletion_at AS marked_for_deletion_at_7, u0_.fields AS fields_8, u0_.oauth_github_id AS oauth_github_id_9, u0_.oauth_google_id AS oauth_google_id_10, u0_.oauth_facebook_id AS oauth_facebook_id_11, u0_.oauth_keycloak_id AS oauth_keycloak_id_12, u0_.hide_adult AS hide_adult_13, u0_.show_subscribed_users AS show_subscribed_users_14, u0_.show_subscribed_magazines AS show_subscribed_magazines_15, u0_.show_subscribed_domains AS show_subscribed_domains_16, u0_.preferred_languages AS preferred_languages_17, u0_.featured_magazines AS featured_magazines_18, u0_.show_profile_subscriptions AS show_profile_subscriptions_19, u0_.show_profile_followings AS show_profile_followings_20, u0_.mark_new_comments AS mark_new_comments_21, u0_.notify_on_new_entry AS notify_on_new_entry_22, u0_.notify_on_new_entry_reply AS notify_on_new_entry_reply_23, u0_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_24, u0_.notify_on_new_post AS notify_on_new_post_25, u0_.notify_on_new_post_reply AS notify_on_new_post_reply_26, u0_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_27, u0_.add_mentions_entries AS add_mentions_entries_28, u0_.add_mentions_posts AS add_mentions_posts_29, u0_.is_banned AS is_banned_30, u0_.is_verified AS is_verified_31, u0_.is_deleted AS is_deleted_32, u0_.is_bot AS is_bot_33, u0_.spam_protection AS spam_protection_34, u0_.custom_css AS custom_css_35, u0_.ignore_magazines_custom_css AS ignore_magazines_custom_css_36, u0_.id AS id_37, u0_.password AS password_38, u0_.totp_secret AS totp_secret_39, u0_.totp_backup_codes AS totp_backup_codes_40, u0_.ap_id AS ap_id_41, u0_.ap_profile_id AS ap_profile_id_42, u0_.ap_public_url AS ap_public_url_43, u0_.ap_followers_url AS ap_followers_url_44, u0_.ap_inbox_url AS ap_inbox_url_45, u0_.ap_domain AS ap_domain_46, u0_.ap_preferred_username AS ap_preferred_username_47, u0_.ap_discoverable AS ap_discoverable_48, u0_.ap_manually_approves_followers AS ap_manually_approves_followers_49, u0_.private_key AS private_key_50, u0_.public_key AS public_key_51, u0_.ap_fetched_at AS ap_fetched_at_52, u0_.ap_deleted_at AS ap_deleted_at_53, u0_.ap_timeout_at AS ap_timeout_at_54, u0_.visibility AS visibility_55, u0_.created_at AS created_at_56, u0_.avatar_id AS avatar_id_57, u0_.cover_id AS cover_id_58 FROM "user" u0_ INNER JOIN image i1_ ON u0_.avatar_id = i1_.id WHERE u0_.last_active >= '2025-03-02 15:46:24' AND u0_.is_banned = false AND u0_.ap_deleted_at IS NULL AND u0_.avatar_id IS NOT NULL ORDER BY u0_.last_active DESC LIMIT 35;