Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• EasyAdmin
• Configuration

Query Metrics

SELECT COUNT(*) AS dctrn_count FROM (SELECT COUNT(u0_.id) AS sclr_0, b1_.id AS id_1, b1_.name AS name_2, b1_.is_public AS is_public_3, b1_.created_at AS created_at_4, u2_.id AS id_5, u2_.registered_at AS registered_at_6, u2_.last_login_at AS last_login_at_7, u2_.nickname AS nickname_8, u2_.roles AS roles_9, u2_.password AS password_10, u2_.email AS email_11, u2_.is_verified AS is_verified_12, u2_.google_id AS google_id_13, u2_.first_name AS first_name_14, u2_.last_name AS last_name_15, u2_.date_of_birth AS date_of_birth_16, u2_.avatar_filename AS avatar_filename_17, u2_.updated_at AS updated_at_18, u2_.notification_settings AS notification_settings_19, u2_.is_profile_private AS is_profile_private_20 FROM bgg_bgCollection b1_ LEFT JOIN users u2_ ON b1_.owner_id = u2_.id LEFT JOIN bg_collection_votes b3_ ON b1_.id = b3_.bg_collection_id LEFT JOIN users u0_ ON u0_.id = b3_.users_id WHERE b1_.is_public = ? GROUP BY b1_.id, u2_.id ORDER BY sclr_0 DESC, b1_.created_at DESC) dctrn_table

[
  1
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      COUNT(u0_.id) AS sclr_0,
      b1_.id AS id_1,
      b1_.name AS name_2,
      b1_.is_public AS is_public_3,
      b1_.created_at AS created_at_4,
      u2_.id AS id_5,
      u2_.registered_at AS registered_at_6,
      u2_.last_login_at AS last_login_at_7,
      u2_.nickname AS nickname_8,
      u2_.roles AS roles_9,
      u2_.password AS password_10,
      u2_.email AS email_11,
      u2_.is_verified AS is_verified_12,
      u2_.google_id AS google_id_13,
      u2_.first_name AS first_name_14,
      u2_.last_name AS last_name_15,
      u2_.date_of_birth AS date_of_birth_16,
      u2_.avatar_filename AS avatar_filename_17,
      u2_.updated_at AS updated_at_18,
      u2_.notification_settings AS notification_settings_19,
      u2_.is_profile_private AS is_profile_private_20
    FROM
      bgg_bgCollection b1_
      LEFT JOIN users u2_ ON b1_.owner_id = u2_.id
      LEFT JOIN bg_collection_votes b3_ ON b1_.id = b3_.bg_collection_id
      LEFT JOIN users u0_ ON u0_.id = b3_.users_id
    WHERE
      b1_.is_public = ?
    GROUP BY
      b1_.id,
      u2_.id
    ORDER BY
      sclr_0 DESC,
      b1_.created_at DESC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT COUNT(u0_.id) AS sclr_0, b1_.id AS id_1, b1_.name AS name_2, b1_.is_public AS is_public_3, b1_.created_at AS created_at_4, u2_.id AS id_5, u2_.registered_at AS registered_at_6, u2_.last_login_at AS last_login_at_7, u2_.nickname AS nickname_8, u2_.roles AS roles_9, u2_.password AS password_10, u2_.email AS email_11, u2_.is_verified AS is_verified_12, u2_.google_id AS google_id_13, u2_.first_name AS first_name_14, u2_.last_name AS last_name_15, u2_.date_of_birth AS date_of_birth_16, u2_.avatar_filename AS avatar_filename_17, u2_.updated_at AS updated_at_18, u2_.notification_settings AS notification_settings_19, u2_.is_profile_private AS is_profile_private_20 FROM bgg_bgCollection b1_ LEFT JOIN users u2_ ON b1_.owner_id = u2_.id LEFT JOIN bg_collection_votes b3_ ON b1_.id = b3_.bg_collection_id LEFT JOIN users u0_ ON u0_.id = b3_.users_id WHERE b1_.is_public = 1 GROUP BY b1_.id, u2_.id ORDER BY sclr_0 DESC, b1_.created_at DESC) dctrn_table;