Symfony Profiler

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 >= '2024-09-19 17:05:31'
            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 >= '2024-09-19 17:05:31'
            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);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.url AS url_3,
  p0_.image_url AS image_url_4,
  p0_.image_width AS image_width_5,
  p0_.image_height AS image_height_6,
  p0_.is_active AS is_active_7,
  p0_.last_active AS last_active_8
FROM
  partner_block p0_
WHERE
  p0_.is_active = true
ORDER BY
  p0_.last_active ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.url AS url_3, p0_.image_url AS image_url_4, p0_.image_width AS image_width_5, p0_.image_height AS image_height_6, p0_.is_active AS is_active_7, p0_.last_active AS last_active_8 FROM partner_block p0_ WHERE p0_.is_active = true ORDER BY p0_.last_active ASC LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.rules AS rules_4,
  t0.subscriptions_count AS subscriptions_count_5,
  t0.entry_count AS entry_count_6,
  t0.entry_comment_count AS entry_comment_count_7,
  t0.post_count AS post_count_8,
  t0.post_comment_count AS post_comment_count_9,
  t0.is_adult AS is_adult_10,
  t0.custom_css AS custom_css_11,
  t0.last_active AS last_active_12,
  t0.marked_for_deletion_at AS marked_for_deletion_at_13,
  t0.tags AS tags_14,
  t0.id AS id_15,
  t0.ap_id AS ap_id_16,
  t0.ap_profile_id AS ap_profile_id_17,
  t0.ap_public_url AS ap_public_url_18,
  t0.ap_followers_url AS ap_followers_url_19,
  t0.ap_inbox_url AS ap_inbox_url_20,
  t0.ap_domain AS ap_domain_21,
  t0.ap_preferred_username AS ap_preferred_username_22,
  t0.ap_discoverable AS ap_discoverable_23,
  t0.ap_manually_approves_followers AS ap_manually_approves_followers_24,
  t0.private_key AS private_key_25,
  t0.public_key AS public_key_26,
  t0.ap_fetched_at AS ap_fetched_at_27,
  t0.ap_deleted_at AS ap_deleted_at_28,
  t0.ap_timeout_at AS ap_timeout_at_29,
  t0.visibility AS visibility_30,
  t0.created_at AS created_at_31,
  t0.icon_id AS icon_id_32
FROM
  magazine t0
WHERE
  t0.ap_id IS NULL
  AND t0.visibility = ?
ORDER BY
  t0.last_active DESC
LIMIT
  28

SELECT t0.name AS name_1, t0.title AS title_2, t0.description AS description_3, t0.rules AS rules_4, t0.subscriptions_count AS subscriptions_count_5, t0.entry_count AS entry_count_6, t0.entry_comment_count AS entry_comment_count_7, t0.post_count AS post_count_8, t0.post_comment_count AS post_comment_count_9, t0.is_adult AS is_adult_10, t0.custom_css AS custom_css_11, t0.last_active AS last_active_12, t0.marked_for_deletion_at AS marked_for_deletion_at_13, t0.tags AS tags_14, t0.id AS id_15, t0.ap_id AS ap_id_16, t0.ap_profile_id AS ap_profile_id_17, t0.ap_public_url AS ap_public_url_18, t0.ap_followers_url AS ap_followers_url_19, t0.ap_inbox_url AS ap_inbox_url_20, t0.ap_domain AS ap_domain_21, t0.ap_preferred_username AS ap_preferred_username_22, t0.ap_discoverable AS ap_discoverable_23, t0.ap_manually_approves_followers AS ap_manually_approves_followers_24, t0.private_key AS private_key_25, t0.public_key AS public_key_26, t0.ap_fetched_at AS ap_fetched_at_27, t0.ap_deleted_at AS ap_deleted_at_28, t0.ap_timeout_at AS ap_timeout_at_29, t0.visibility AS visibility_30, t0.created_at AS created_at_31, t0.icon_id AS icon_id_32 FROM magazine t0 WHERE t0.ap_id IS NULL AND t0.visibility = 'visible' ORDER BY t0.last_active DESC LIMIT 28;