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
  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.body_ts @@ plainto_tsquery( 'community@instance' ) = true
            
            AND entry.is_adult = false
            AND m_entry.is_adult = false
            
            AND (entry.created_at BETWEEN '2025-03-11 23:48:22' AND '2025-03-12 11:48:22')
            
        )
        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( 'community@instance' ) = true
            
            AND post.is_adult = false
            AND m_post.is_adult = false
            
            AND (post.created_at BETWEEN '2025-03-11 23:48:22' AND '2025-03-12 11:48:22')
            
        )
        
        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( 'community@instance' ) = true
            
            AND entry_comment.is_adult = false
            AND m_entry_comment.is_adult = false
            
            AND (entry_comment.created_at BETWEEN '2025-03-11 23:48:22' AND '2025-03-12 11:48:22')
            
        )
        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( 'community@instance' ) = true
            
            AND post_comment.is_adult = false
            AND m_post_comment.is_adult = false
            
            AND (post_comment.created_at BETWEEN '2025-03-11 23:48:22' AND '2025-03-12 11:48:22')
            
        )
        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);