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 m.id FROM magazine m
            WHERE m.ap_id IS NULL
            AND m.visibility = :visible
            AND m.is_adult = false
            ORDER BY random()
            LIMIT 5

[
  "visible" => "visible"
]

SELECT
  m.id
FROM
  magazine m
WHERE
  m.ap_id IS NULL
  AND m.visibility = :visible
  AND m.is_adult = false
ORDER BY
  random()
LIMIT
  5

SELECT m.id FROM magazine m
            WHERE m.ap_id IS NULL
            AND m.visibility = 'visible'
            AND m.is_adult = false
            ORDER BY random()
            LIMIT 5
            ;

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_.id IN (?)

[
  1
]

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_.id IN (?)

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_.id IN (1);

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 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 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);