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 COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_7 FROM (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 FROM category c0_ WHERE c0_.is_private = false ORDER BY c0_.is_official DESC, c0_.subscriptions_count DESC) dctrn_result) dctrn_table

[]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_7
    FROM
      (
        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
        FROM
          category c0_
        WHERE
          c0_.is_private = false
        ORDER BY
          c0_.is_official DESC,
          c0_.subscriptions_count DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_7 FROM (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 FROM category c0_ WHERE c0_.is_private = false ORDER BY c0_.is_official DESC, c0_.subscriptions_count DESC) dctrn_result) dctrn_table;