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.body_ts @@ plainto_tsquery(:search) = true
    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.body_ts @@ plainto_tsquery(:search) = true
      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.body_ts @@ plainto_tsquery(:search) = true
      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.body_ts @@ plainto_tsquery(:search) = true
      AND post_comment.is_adult = false
      AND m_post_comment.is_adult = false
      AND (
        post_comment.created_at BETWEEN :timeFrom
        AND :timeTo
      )
  )
ORDER BY
  ranking 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.body_ts @@ plainto_tsquery( '1900s@lemmy.world' ) = true
            
            AND entry.is_adult = false
            AND m_entry.is_adult = false
            
            AND (entry.created_at BETWEEN '2025-01-23 15:07:57' AND '2025-01-23 21:07:57')
            
        )
        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.body_ts @@ plainto_tsquery( '1900s@lemmy.world' ) = true
            
            AND post.is_adult = false
            AND m_post.is_adult = false
            
            AND (post.created_at BETWEEN '2025-01-23 15:07:57' AND '2025-01-23 21:07:57')
            
        )
        
        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.body_ts @@ plainto_tsquery( '1900s@lemmy.world' ) = true
            
            AND entry_comment.is_adult = false
            AND m_entry_comment.is_adult = false
            
            AND (entry_comment.created_at BETWEEN '2025-01-23 15:07:57' AND '2025-01-23 21:07:57')
            
        )
        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.body_ts @@ plainto_tsquery( '1900s@lemmy.world' ) = true
            
            AND post_comment.is_adult = false
            AND m_post_comment.is_adult = false
            
            AND (post_comment.created_at BETWEEN '2025-01-23 15:07:57' AND '2025-01-23 21:07:57')
            
        )
        ORDER BY ranking 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
  c.id
FROM
  category c
WHERE
  c.is_private = false
ORDER BY
  random()
LIMIT
  5

SELECT c.id FROM category c
            WHERE c.is_private = false
            ORDER BY random()
            LIMIT 5
            ;

SELECT
  c0_.name AS name_0,
  c0_.slug AS slug_1,
  c0_.description AS description_2,
  c0_.is_private AS is_private_3,
  c0_.is_official AS is_official_4,
  c0_.magazines_count AS magazines_count_5,
  c0_.subscriptions_count AS subscriptions_count_6,
  c0_.id AS id_7,
  c0_.created_at AS created_at_8,
  c0_.user_id AS user_id_9
FROM
  category c0_
WHERE
  c0_.id IN (NULL)

SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.description AS description_2, c0_.is_private AS is_private_3, c0_.is_official AS is_official_4, c0_.magazines_count AS magazines_count_5, c0_.subscriptions_count AS subscriptions_count_6, c0_.id AS id_7, c0_.created_at AS created_at_8, c0_.user_id AS user_id_9 FROM category c0_ WHERE c0_.id IN (NULL);

SELECT
  p.id
FROM
  post p
  JOIN magazine m ON p.magazine_id = m.id
WHERE
  p.is_adult = false
  AND p.visibility = :visible
  AND m.is_adult = false
  AND p.ap_id IS NULL
  AND p.created_at >= :time
ORDER BY
  random(),
  p.created_at DESC
LIMIT
  :limit;

SELECT p.id
            FROM post p
            JOIN magazine m ON p.magazine_id = m.id
            WHERE p.is_adult = false
              AND p.visibility = 'visible'
              AND m.is_adult = false
              AND p.ap_id IS NULL
              AND p.created_at >= '2025-01-21 21:07:58'
            ORDER BY random(), p.created_at DESC
            LIMIT 154;    
        ;

SELECT
  p0_.slug AS slug_0,
  p0_.body AS body_1,
  p0_.lang AS lang_2,
  p0_.comment_count AS comment_count_3,
  p0_.favourite_count AS favourite_count_4,
  p0_.score AS score_5,
  p0_.is_adult AS is_adult_6,
  p0_.sticky AS sticky_7,
  p0_.last_active AS last_active_8,
  p0_.ip AS ip_9,
  p0_.tags AS tags_10,
  p0_.mentions AS mentions_11,
  p0_.id AS id_12,
  p0_.body_ts AS body_ts_13,
  p0_.up_votes AS up_votes_14,
  p0_.down_votes AS down_votes_15,
  p0_.ranking AS ranking_16,
  p0_.visibility AS visibility_17,
  p0_.ap_id AS ap_id_18,
  p0_.edited_at AS edited_at_19,
  p0_.created_at AS created_at_20,
  p0_.user_id AS user_id_21,
  p0_.magazine_id AS magazine_id_22,
  p0_.image_id AS image_id_23
FROM
  post p0_
  INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id
  LEFT JOIN image i2_ ON p0_.image_id = i2_.id
WHERE
  p0_.id IN (NULL)

SELECT p0_.slug AS slug_0, p0_.body AS body_1, p0_.lang AS lang_2, p0_.comment_count AS comment_count_3, p0_.favourite_count AS favourite_count_4, p0_.score AS score_5, p0_.is_adult AS is_adult_6, p0_.sticky AS sticky_7, p0_.last_active AS last_active_8, p0_.ip AS ip_9, p0_.tags AS tags_10, p0_.mentions AS mentions_11, p0_.id AS id_12, p0_.body_ts AS body_ts_13, p0_.up_votes AS up_votes_14, p0_.down_votes AS down_votes_15, p0_.ranking AS ranking_16, p0_.visibility AS visibility_17, p0_.ap_id AS ap_id_18, p0_.edited_at AS edited_at_19, p0_.created_at AS created_at_20, p0_.user_id AS user_id_21, p0_.magazine_id AS magazine_id_22, p0_.image_id AS image_id_23 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id LEFT JOIN image i2_ ON p0_.image_id = i2_.id WHERE p0_.id IN (NULL);

SELECT
  e.id
FROM
  entry e
  JOIN magazine m ON e.magazine_id = m.id
WHERE
  e.is_adult = false
  AND e.visibility = :visible
  AND m.is_adult = false
  AND e.ap_id IS NULL
  AND e.created_at >= :time
ORDER BY
  random(),
  e.created_at DESC
LIMIT
  :limit;

SELECT e.id
            FROM entry e
            JOIN magazine m ON e.magazine_id = m.id
            WHERE e.is_adult = false
              AND e.visibility = 'visible'
              AND m.is_adult = false
              AND e.ap_id IS NULL
              AND e.created_at >= '2025-01-21 21:07:58'
            ORDER BY random(), e.created_at DESC
            LIMIT 154;    
        ;

SELECT
  e0_.slug AS slug_0,
  e0_.title AS title_1,
  e0_.url AS url_2,
  e0_.body AS body_3,
  e0_.type AS type_4,
  e0_.lang AS lang_5,
  e0_.is_oc AS is_oc_6,
  e0_.has_embed AS has_embed_7,
  e0_.comment_count AS comment_count_8,
  e0_.favourite_count AS favourite_count_9,
  e0_.score AS score_10,
  e0_.is_adult AS is_adult_11,
  e0_.sticky AS sticky_12,
  e0_.last_active AS last_active_13,
  e0_.ip AS ip_14,
  e0_.ada_amount AS ada_amount_15,
  e0_.tags AS tags_16,
  e0_.mentions AS mentions_17,
  e0_.id AS id_18,
  e0_.title_ts AS title_ts_19,
  e0_.body_ts AS body_ts_20,
  e0_.up_votes AS up_votes_21,
  e0_.down_votes AS down_votes_22,
  e0_.ranking AS ranking_23,
  e0_.visibility AS visibility_24,
  e0_.ap_id AS ap_id_25,
  e0_.edited_at AS edited_at_26,
  e0_.created_at AS created_at_27,
  e0_.user_id AS user_id_28,
  e0_.magazine_id AS magazine_id_29,
  e0_.image_id AS image_id_30,
  e0_.domain_id AS domain_id_31
FROM
  entry e0_
  INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id
  LEFT JOIN image i2_ ON e0_.image_id = i2_.id
WHERE
  e0_.id IN (NULL)

SELECT e0_.slug AS slug_0, e0_.title AS title_1, e0_.url AS url_2, e0_.body AS body_3, e0_.type AS type_4, e0_.lang AS lang_5, e0_.is_oc AS is_oc_6, e0_.has_embed AS has_embed_7, e0_.comment_count AS comment_count_8, e0_.favourite_count AS favourite_count_9, e0_.score AS score_10, e0_.is_adult AS is_adult_11, e0_.sticky AS sticky_12, e0_.last_active AS last_active_13, e0_.ip AS ip_14, e0_.ada_amount AS ada_amount_15, e0_.tags AS tags_16, e0_.mentions AS mentions_17, e0_.id AS id_18, e0_.title_ts AS title_ts_19, e0_.body_ts AS body_ts_20, e0_.up_votes AS up_votes_21, e0_.down_votes AS down_votes_22, e0_.ranking AS ranking_23, e0_.visibility AS visibility_24, e0_.ap_id AS ap_id_25, e0_.edited_at AS edited_at_26, e0_.created_at AS created_at_27, e0_.user_id AS user_id_28, e0_.magazine_id AS magazine_id_29, e0_.image_id AS image_id_30, e0_.domain_id AS domain_id_31 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id LEFT JOIN image i2_ ON e0_.image_id = i2_.id WHERE e0_.id IN (NULL);