Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_14
    FROM
      (
        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
        FROM
          magazine m0_
        WHERE
          m0_.visibility = ?
        ORDER BY
          m0_.entry_comment_count DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_14 FROM (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 FROM magazine m0_ WHERE m0_.visibility = 'visible' ORDER BY m0_.entry_comment_count DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_14,
  MIN(sclr_31) AS dctrn_minrownum
FROM
  (
    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,
      ROW_NUMBER() OVER(
        ORDER BY
          m0_.entry_comment_count DESC
      ) AS sclr_31
    FROM
      magazine m0_
    WHERE
      m0_.visibility = ?
  ) dctrn_result
GROUP BY
  id_14
ORDER BY
  dctrn_minrownum ASC
LIMIT
  48

SELECT DISTINCT id_14, MIN(sclr_31) AS dctrn_minrownum FROM (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, ROW_NUMBER() OVER(ORDER BY m0_.entry_comment_count DESC) AS sclr_31 FROM magazine m0_ WHERE m0_.visibility = 'visible') dctrn_result GROUP BY id_14 ORDER BY dctrn_minrownum ASC LIMIT 48;

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_.visibility = ?
  AND m0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
ORDER BY
  m0_.entry_comment_count 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_.visibility = 'visible' AND m0_.id IN (38, 49, 102, 73, 78, 51, 9, 80, 83, 45, 50, 85, 20, 16, 36, 19, 120, 100, 47, 39, 77, 8, 69, 35, 43, 11, 58, 128, 93, 48, 89, 34, 40, 70, 111, 3, 71, 142, 33, 42, 22, 108, 145, 32, 57, 13, 81, 18) ORDER BY m0_.entry_comment_count DESC;

SELECT
  t0.file_path AS file_path_1,
  t0.file_name AS file_name_2,
  t0.sha256 AS sha256_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.blurhash AS blurhash_6,
  t0.alt_text AS alt_text_7,
  t0.source_url AS source_url_8,
  t0.id AS id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = 23300;

SELECT
  t0.file_path AS file_path_1,
  t0.file_name AS file_name_2,
  t0.sha256 AS sha256_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.blurhash AS blurhash_6,
  t0.alt_text AS alt_text_7,
  t0.source_url AS source_url_8,
  t0.id AS id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = 44743;