Symfony Profiler

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

Query Metrics

SET TIME ZONE 'UTC'

[]

SET
  TIME ZONE 'UTC'

SET TIME ZONE 'UTC';

SELECT group_id FROM channels WHERE id = ?

[
  "01a154d0-2c4c-78d1-a730-4ba0dee6cad0"
]

SELECT
  group_id
FROM
  channels
WHERE
  id = ?

SELECT group_id FROM channels WHERE id = '01a154d0-2c4c-78d1-a730-4ba0dee6cad0';

SELECT timezone FROM users WHERE id = ? AND account_type IN ('group', 'organization')

[
  "01a154cc-beb0-72dd-8312-040cb8716c73"
]

SELECT
  timezone
FROM
  users
WHERE
  id = ?
  AND account_type IN ('group', 'organization')

SELECT timezone FROM users WHERE id = '01a154cc-beb0-72dd-8312-040cb8716c73' AND account_type IN ('group', 'organization');

SELECT t0.id AS id_1, t0.email AS email_2, t0.hashed_password AS hashed_password_3, t0.display_name AS display_name_4, t0.roles AS roles_5, t0.avatar_url AS avatar_url_6, t0.status AS status_7, t0.custom_status_text AS custom_status_text_8, t0.last_seen_at AS last_seen_at_9, t0.created_at AS created_at_10, t0.is_email_verified AS is_email_verified_11, t0.email_verification_token AS email_verification_token_12, t0.email_verification_token_expires_at AS email_verification_token_expires_at_13, t0.account_type AS account_type_14, t0.description AS description_15, t0.organization_category AS organization_category_16, t0.featured_channel_id AS featured_channel_id_17, t0.contact_email AS contact_email_18, t0.website_url AS website_url_19, t0.phone_number AS phone_number_20, t0.postal_address AS postal_address_21, t0.group_visibility AS group_visibility_22, t0.timezone AS timezone_23, t0.accepts_membership_requests AS accepts_membership_requests_24, t0.tutorial_completed AS tutorial_completed_25, t0.archived_at AS archived_at_26, t0.subdomain AS subdomain_27, t0.home_subdomain AS home_subdomain_28, t0.deleted_at AS deleted_at_29, t0.white_label_config AS white_label_config_30 FROM users t0 WHERE t0.id = ?

[
  "019d684b-ecf0-7f4a-b22f-73346006b23c"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.hashed_password AS hashed_password_3,
  t0.display_name AS display_name_4,
  t0.roles AS roles_5,
  t0.avatar_url AS avatar_url_6,
  t0.status AS status_7,
  t0.custom_status_text AS custom_status_text_8,
  t0.last_seen_at AS last_seen_at_9,
  t0.created_at AS created_at_10,
  t0.is_email_verified AS is_email_verified_11,
  t0.email_verification_token AS email_verification_token_12,
  t0.email_verification_token_expires_at AS email_verification_token_expires_at_13,
  t0.account_type AS account_type_14,
  t0.description AS description_15,
  t0.organization_category AS organization_category_16,
  t0.featured_channel_id AS featured_channel_id_17,
  t0.contact_email AS contact_email_18,
  t0.website_url AS website_url_19,
  t0.phone_number AS phone_number_20,
  t0.postal_address AS postal_address_21,
  t0.group_visibility AS group_visibility_22,
  t0.timezone AS timezone_23,
  t0.accepts_membership_requests AS accepts_membership_requests_24,
  t0.tutorial_completed AS tutorial_completed_25,
  t0.archived_at AS archived_at_26,
  t0.subdomain AS subdomain_27,
  t0.home_subdomain AS home_subdomain_28,
  t0.deleted_at AS deleted_at_29,
  t0.white_label_config AS white_label_config_30
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.hashed_password AS hashed_password_3, t0.display_name AS display_name_4, t0.roles AS roles_5, t0.avatar_url AS avatar_url_6, t0.status AS status_7, t0.custom_status_text AS custom_status_text_8, t0.last_seen_at AS last_seen_at_9, t0.created_at AS created_at_10, t0.is_email_verified AS is_email_verified_11, t0.email_verification_token AS email_verification_token_12, t0.email_verification_token_expires_at AS email_verification_token_expires_at_13, t0.account_type AS account_type_14, t0.description AS description_15, t0.organization_category AS organization_category_16, t0.featured_channel_id AS featured_channel_id_17, t0.contact_email AS contact_email_18, t0.website_url AS website_url_19, t0.phone_number AS phone_number_20, t0.postal_address AS postal_address_21, t0.group_visibility AS group_visibility_22, t0.timezone AS timezone_23, t0.accepts_membership_requests AS accepts_membership_requests_24, t0.tutorial_completed AS tutorial_completed_25, t0.archived_at AS archived_at_26, t0.subdomain AS subdomain_27, t0.home_subdomain AS home_subdomain_28, t0.deleted_at AS deleted_at_29, t0.white_label_config AS white_label_config_30 FROM users t0 WHERE t0.id = '019d684b-ecf0-7f4a-b22f-73346006b23c';

SELECT t0.id AS id_1, t0.owner_id AS owner_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.type AS type_6, t0.is_public AS is_public_7, t0.category_id AS category_id_8, t0.group_id AS group_id_9, t0.parent_channel_id AS parent_channel_id_10, t0.channel_type AS channel_type_11, t0.purpose AS purpose_12, t0.default_session_location AS default_session_location_13, t0.default_session_min_participants AS default_session_min_participants_14, t0.default_session_max_participants AS default_session_max_participants_15, t0.deleted_at AS deleted_at_16, t0.settings AS settings_17 FROM channels t0 WHERE t0.id = ?

[
  "01a154d0-2c4c-78d1-a730-4ba0dee6cad0"
]

SELECT
  t0.id AS id_1,
  t0.owner_id AS owner_id_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.type AS type_6,
  t0.is_public AS is_public_7,
  t0.category_id AS category_id_8,
  t0.group_id AS group_id_9,
  t0.parent_channel_id AS parent_channel_id_10,
  t0.channel_type AS channel_type_11,
  t0.purpose AS purpose_12,
  t0.default_session_location AS default_session_location_13,
  t0.default_session_min_participants AS default_session_min_participants_14,
  t0.default_session_max_participants AS default_session_max_participants_15,
  t0.deleted_at AS deleted_at_16,
  t0.settings AS settings_17
FROM
  channels t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.owner_id AS owner_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.type AS type_6, t0.is_public AS is_public_7, t0.category_id AS category_id_8, t0.group_id AS group_id_9, t0.parent_channel_id AS parent_channel_id_10, t0.channel_type AS channel_type_11, t0.purpose AS purpose_12, t0.default_session_location AS default_session_location_13, t0.default_session_min_participants AS default_session_min_participants_14, t0.default_session_max_participants AS default_session_max_participants_15, t0.deleted_at AS deleted_at_16, t0.settings AS settings_17 FROM channels t0 WHERE t0.id = '01a154d0-2c4c-78d1-a730-4ba0dee6cad0';

SELECT t0.user_id AS user_id_1, t0.joined_at AS joined_at_2, t0.role AS role_3, t0.last_read_message_id AS last_read_message_id_4, t0.last_read_at AS last_read_at_5, t0.conversation_id AS conversation_id_6 FROM channel_members t0 WHERE t0.conversation_id = ?

[
  "01a154d0-2c4c-78d1-a730-4ba0dee6cad0"
]

SELECT
  t0.user_id AS user_id_1,
  t0.joined_at AS joined_at_2,
  t0.role AS role_3,
  t0.last_read_message_id AS last_read_message_id_4,
  t0.last_read_at AS last_read_at_5,
  t0.conversation_id AS conversation_id_6
FROM
  channel_members t0
WHERE
  t0.conversation_id = ?

SELECT t0.user_id AS user_id_1, t0.joined_at AS joined_at_2, t0.role AS role_3, t0.last_read_message_id AS last_read_message_id_4, t0.last_read_at AS last_read_at_5, t0.conversation_id AS conversation_id_6 FROM channel_members t0 WHERE t0.conversation_id = '01a154d0-2c4c-78d1-a730-4ba0dee6cad0';

SELECT m0_.subject AS subject_0, m0_.body AS body_1, m0_.delivery_channel AS delivery_channel_2, m0_.audience_scope AS audience_scope_3, m0_.audience_role AS audience_role_4, m0_.audience_tag AS audience_tag_5, m0_.status AS status_6, m0_.scheduled_at AS scheduled_at_7, m0_.sent_at AS sent_at_8, m0_.recipient_count AS recipient_count_9, m0_.id AS id_10, m0_.conversation_id AS conversation_id_11, m0_.author_id AS author_id_12, m0_.created_at AS created_at_13 FROM mailing_campaigns m0_ WHERE m0_.conversation_id = ? ORDER BY m0_.created_at DESC LIMIT 50

[
  "01a154d0-2c4c-78d1-a730-4ba0dee6cad0"
]

SELECT
  m0_.subject AS subject_0,
  m0_.body AS body_1,
  m0_.delivery_channel AS delivery_channel_2,
  m0_.audience_scope AS audience_scope_3,
  m0_.audience_role AS audience_role_4,
  m0_.audience_tag AS audience_tag_5,
  m0_.status AS status_6,
  m0_.scheduled_at AS scheduled_at_7,
  m0_.sent_at AS sent_at_8,
  m0_.recipient_count AS recipient_count_9,
  m0_.id AS id_10,
  m0_.conversation_id AS conversation_id_11,
  m0_.author_id AS author_id_12,
  m0_.created_at AS created_at_13
FROM
  mailing_campaigns m0_
WHERE
  m0_.conversation_id = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  50

SELECT m0_.subject AS subject_0, m0_.body AS body_1, m0_.delivery_channel AS delivery_channel_2, m0_.audience_scope AS audience_scope_3, m0_.audience_role AS audience_role_4, m0_.audience_tag AS audience_tag_5, m0_.status AS status_6, m0_.scheduled_at AS scheduled_at_7, m0_.sent_at AS sent_at_8, m0_.recipient_count AS recipient_count_9, m0_.id AS id_10, m0_.conversation_id AS conversation_id_11, m0_.author_id AS author_id_12, m0_.created_at AS created_at_13 FROM mailing_campaigns m0_ WHERE m0_.conversation_id = '01a154d0-2c4c-78d1-a730-4ba0dee6cad0' ORDER BY m0_.created_at DESC LIMIT 50;