Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 86
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Workflow
• Mercure
• Configuration

Query Metrics

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_.post_count > 0 OR m0_.entry_count > 0 ORDER BY m0_.post_count DESC LIMIT 50

[]

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_.post_count > 0
  OR m0_.entry_count > 0
ORDER BY
  m0_.post_count DESC
LIMIT
  50

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_.post_count > 0 OR m0_.entry_count > 0 ORDER BY m0_.post_count DESC LIMIT 50;

SELECT u0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM post p1_ INNER JOIN "user" u0_ ON p1_.user_id = u0_.id INNER JOIN magazine m2_ ON p1_.magazine_id = m2_.id WHERE p1_.magazine_id = ? AND p1_.visibility = ? AND u0_.about <> ? AND u0_.is_banned = false AND u0_.ap_id IS NULL GROUP BY u0_.id ORDER BY sclr_1 DESC LIMIT 50

[
  102
  "visible"
  ""
]

SELECT
  u0_.id AS id_0,
  COUNT(p1_.id) AS sclr_1
FROM
  post p1_
  INNER JOIN "user" u0_ ON p1_.user_id = u0_.id
  INNER JOIN magazine m2_ ON p1_.magazine_id = m2_.id
WHERE
  p1_.magazine_id = ?
  AND p1_.visibility = ?
  AND u0_.about <> ?
  AND u0_.is_banned = false
  AND u0_.ap_id IS NULL
GROUP BY
  u0_.id
ORDER BY
  sclr_1 DESC
LIMIT
  50

SELECT u0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM post p1_ INNER JOIN "user" u0_ ON p1_.user_id = u0_.id INNER JOIN magazine m2_ ON p1_.magazine_id = m2_.id WHERE p1_.magazine_id = 102 AND p1_.visibility = 'visible' AND u0_.about <> '' AND u0_.is_banned = false AND u0_.ap_id IS NULL GROUP BY u0_.id ORDER BY sclr_1 DESC LIMIT 50;

SELECT u0_.id AS id_0, COUNT(e1_.id) AS sclr_1 FROM entry e1_ INNER JOIN "user" u0_ ON e1_.user_id = u0_.id INNER JOIN magazine m2_ ON e1_.magazine_id = m2_.id WHERE e1_.magazine_id = ? AND e1_.visibility = ? AND u0_.about <> ? AND u0_.is_banned = false AND e1_.ap_id IS NULL GROUP BY u0_.id ORDER BY sclr_1 DESC LIMIT 50

[
  102
  "visible"
  ""
]

SELECT
  u0_.id AS id_0,
  COUNT(e1_.id) AS sclr_1
FROM
  entry e1_
  INNER JOIN "user" u0_ ON e1_.user_id = u0_.id
  INNER JOIN magazine m2_ ON e1_.magazine_id = m2_.id
WHERE
  e1_.magazine_id = ?
  AND e1_.visibility = ?
  AND u0_.about <> ?
  AND u0_.is_banned = false
  AND e1_.ap_id IS NULL
GROUP BY
  u0_.id
ORDER BY
  sclr_1 DESC
LIMIT
  50

SELECT u0_.id AS id_0, COUNT(e1_.id) AS sclr_1 FROM entry e1_ INNER JOIN "user" u0_ ON e1_.user_id = u0_.id INNER JOIN magazine m2_ ON e1_.magazine_id = m2_.id WHERE e1_.magazine_id = 102 AND e1_.visibility = 'visible' AND u0_.about <> '' AND u0_.is_banned = false AND e1_.ap_id IS NULL GROUP BY u0_.id ORDER BY sclr_1 DESC LIMIT 50;

SELECT u0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM post p1_ INNER JOIN "user" u0_ ON p1_.user_id = u0_.id INNER JOIN magazine m2_ ON p1_.magazine_id = m2_.id WHERE p1_.magazine_id = ? AND p1_.visibility = ? AND u0_.about <> ? AND u0_.is_banned = false AND u0_.ap_id IS NOT NULL AND u0_.ap_discoverable = true GROUP BY u0_.id ORDER BY sclr_1 DESC LIMIT 50

[
  102
  "visible"
  ""
]

SELECT
  u0_.id AS id_0,
  COUNT(p1_.id) AS sclr_1
FROM
  post p1_
  INNER JOIN "user" u0_ ON p1_.user_id = u0_.id
  INNER JOIN magazine m2_ ON p1_.magazine_id = m2_.id
WHERE
  p1_.magazine_id = ?
  AND p1_.visibility = ?
  AND u0_.about <> ?
  AND u0_.is_banned = false
  AND u0_.ap_id IS NOT NULL
  AND u0_.ap_discoverable = true
GROUP BY
  u0_.id
ORDER BY
  sclr_1 DESC
LIMIT
  50

SELECT u0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM post p1_ INNER JOIN "user" u0_ ON p1_.user_id = u0_.id INNER JOIN magazine m2_ ON p1_.magazine_id = m2_.id WHERE p1_.magazine_id = 102 AND p1_.visibility = 'visible' AND u0_.about <> '' AND u0_.is_banned = false AND u0_.ap_id IS NOT NULL AND u0_.ap_discoverable = true GROUP BY u0_.id ORDER BY sclr_1 DESC LIMIT 50;

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = ? AND t0.magazine_id = ?)

[
  1
  102
]

SELECT
  t0.is_owner AS is_owner_1,
  t0.is_confirmed AS is_confirmed_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.user_id AS user_id_5,
  t0.magazine_id AS magazine_id_6
FROM
  moderator t0
WHERE
  (
    t0.is_owner = ?
    AND t0.magazine_id = ?
  )

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = 1 AND t0.magazine_id = 102);

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = ?

[
  102
]

SELECT
  t0.is_owner AS is_owner_1,
  t0.is_confirmed AS is_confirmed_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.user_id AS user_id_5,
  t0.magazine_id AS magazine_id_6
FROM
  moderator t0
WHERE
  t0.magazine_id = ?

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = 102;

SELECT COUNT(*) FROM magazine_log t0 WHERE t0.magazine_id = ? AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban')

[
  102
]

SELECT
  COUNT(*)
FROM
  magazine_log t0
WHERE
  t0.magazine_id = ?
  AND t0.log_type IN (
    'entry_deleted', 'entry_restored',
    'entry_comment_deleted', 'entry_comment_restored',
    'post_deleted', 'post_restored',
    'post_comment_deleted', 'post_comment_restored',
    'ban'
  )

SELECT COUNT(*) FROM magazine_log t0 WHERE t0.magazine_id = 102 AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban');