Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.is_active AS is_active_5, t0.purpose AS purpose_6, t0.api_token AS api_token_7, t0.brand_name AS brand_name_8, t0.brand_logo AS brand_logo_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM organization t0 WHERE t0.domain = ? LIMIT 1

[
  "vendordesk.marello.com"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.domain AS domain_4,
  t0.is_active AS is_active_5,
  t0.purpose AS purpose_6,
  t0.api_token AS api_token_7,
  t0.brand_name AS brand_name_8,
  t0.brand_logo AS brand_logo_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  organization t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.is_active AS is_active_5, t0.purpose AS purpose_6, t0.api_token AS api_token_7, t0.brand_name AS brand_name_8, t0.brand_logo AS brand_logo_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM organization t0 WHERE t0.domain = 'vendordesk.marello.com' LIMIT 1;

SELECT t0.id AS id_1, t0.allowed_currencies AS allowed_currencies_2, t0.default_currency AS default_currency_3, t0.credit_limits_enabled AS credit_limits_enabled_4, t0.abandoned_list_reminders_enabled AS abandoned_list_reminders_enabled_5, t0.abandoned_list_delay_minutes AS abandoned_list_delay_minutes_6, t0.abandoned_list_internal_enabled AS abandoned_list_internal_enabled_7, t0.abandoned_list_customer_enabled AS abandoned_list_customer_enabled_8, t0.allowed_localizations AS allowed_localizations_9, t0.default_localization AS default_localization_10, t0.timezone AS timezone_11, t0.shipping_origin_country AS shipping_origin_country_12, t0.order_number_prefix AS order_number_prefix_13, t0.order_number_next AS order_number_next_14, t0.intake_number_next AS intake_number_next_15, t0.invoice_number_prefix AS invoice_number_prefix_16, t0.invoice_number_next AS invoice_number_next_17, t0.consumer_number_prefix AS consumer_number_prefix_18, t0.consumer_number_next AS consumer_number_next_19, t0.price_resolution_mode AS price_resolution_mode_20, t0.search_boosts AS search_boosts_21, t0.frequently_bought_retention_days AS frequently_bought_retention_days_22, t0.ga4_measurement_id AS ga4_measurement_id_23, t0.gtm_container_id AS gtm_container_id_24, t0.cookie_banner_enabled AS cookie_banner_enabled_25, t0.cookie_policy_slug AS cookie_policy_slug_26, t0.seo_head_snippet AS seo_head_snippet_27, t0.robots_txt AS robots_txt_28, t0.jwt_ttl_seconds AS jwt_ttl_seconds_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.organization_id AS organization_id_32, t0.fallback_notification_recipient_id AS fallback_notification_recipient_id_33, t0.default_payment_term_id AS default_payment_term_id_34, t0.default_payment_schedule_id AS default_payment_schedule_id_35 FROM organization_settings t0 WHERE t0.organization_id = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.allowed_currencies AS allowed_currencies_2,
  t0.default_currency AS default_currency_3,
  t0.credit_limits_enabled AS credit_limits_enabled_4,
  t0.abandoned_list_reminders_enabled AS abandoned_list_reminders_enabled_5,
  t0.abandoned_list_delay_minutes AS abandoned_list_delay_minutes_6,
  t0.abandoned_list_internal_enabled AS abandoned_list_internal_enabled_7,
  t0.abandoned_list_customer_enabled AS abandoned_list_customer_enabled_8,
  t0.allowed_localizations AS allowed_localizations_9,
  t0.default_localization AS default_localization_10,
  t0.timezone AS timezone_11,
  t0.shipping_origin_country AS shipping_origin_country_12,
  t0.order_number_prefix AS order_number_prefix_13,
  t0.order_number_next AS order_number_next_14,
  t0.intake_number_next AS intake_number_next_15,
  t0.invoice_number_prefix AS invoice_number_prefix_16,
  t0.invoice_number_next AS invoice_number_next_17,
  t0.consumer_number_prefix AS consumer_number_prefix_18,
  t0.consumer_number_next AS consumer_number_next_19,
  t0.price_resolution_mode AS price_resolution_mode_20,
  t0.search_boosts AS search_boosts_21,
  t0.frequently_bought_retention_days AS frequently_bought_retention_days_22,
  t0.ga4_measurement_id AS ga4_measurement_id_23,
  t0.gtm_container_id AS gtm_container_id_24,
  t0.cookie_banner_enabled AS cookie_banner_enabled_25,
  t0.cookie_policy_slug AS cookie_policy_slug_26,
  t0.seo_head_snippet AS seo_head_snippet_27,
  t0.robots_txt AS robots_txt_28,
  t0.jwt_ttl_seconds AS jwt_ttl_seconds_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.organization_id AS organization_id_32,
  t0.fallback_notification_recipient_id AS fallback_notification_recipient_id_33,
  t0.default_payment_term_id AS default_payment_term_id_34,
  t0.default_payment_schedule_id AS default_payment_schedule_id_35
FROM
  organization_settings t0
WHERE
  t0.organization_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.allowed_currencies AS allowed_currencies_2, t0.default_currency AS default_currency_3, t0.credit_limits_enabled AS credit_limits_enabled_4, t0.abandoned_list_reminders_enabled AS abandoned_list_reminders_enabled_5, t0.abandoned_list_delay_minutes AS abandoned_list_delay_minutes_6, t0.abandoned_list_internal_enabled AS abandoned_list_internal_enabled_7, t0.abandoned_list_customer_enabled AS abandoned_list_customer_enabled_8, t0.allowed_localizations AS allowed_localizations_9, t0.default_localization AS default_localization_10, t0.timezone AS timezone_11, t0.shipping_origin_country AS shipping_origin_country_12, t0.order_number_prefix AS order_number_prefix_13, t0.order_number_next AS order_number_next_14, t0.intake_number_next AS intake_number_next_15, t0.invoice_number_prefix AS invoice_number_prefix_16, t0.invoice_number_next AS invoice_number_next_17, t0.consumer_number_prefix AS consumer_number_prefix_18, t0.consumer_number_next AS consumer_number_next_19, t0.price_resolution_mode AS price_resolution_mode_20, t0.search_boosts AS search_boosts_21, t0.frequently_bought_retention_days AS frequently_bought_retention_days_22, t0.ga4_measurement_id AS ga4_measurement_id_23, t0.gtm_container_id AS gtm_container_id_24, t0.cookie_banner_enabled AS cookie_banner_enabled_25, t0.cookie_policy_slug AS cookie_policy_slug_26, t0.seo_head_snippet AS seo_head_snippet_27, t0.robots_txt AS robots_txt_28, t0.jwt_ttl_seconds AS jwt_ttl_seconds_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.organization_id AS organization_id_32, t0.fallback_notification_recipient_id AS fallback_notification_recipient_id_33, t0.default_payment_term_id AS default_payment_term_id_34, t0.default_payment_schedule_id AS default_payment_schedule_id_35 FROM organization_settings t0 WHERE t0.organization_id = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name_prefix AS name_prefix_5, t0.first_name AS first_name_6, t0.middle_name AS middle_name_7, t0.last_name AS last_name_8, t0.name_suffix AS name_suffix_9, t0.title AS title_10, t0.phone AS phone_11, t0.avatar AS avatar_12, t0.preferred_locale AS preferred_locale_13, t0.password_reset_token AS password_reset_token_14, t0.password_reset_token_expires_at AS password_reset_token_expires_at_15, t0.totp_secret AS totp_secret_16, t0.backup_codes AS backup_codes_17, t0.preferences AS preferences_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.organization_id AS organization_id_21 FROM "user" t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name_prefix AS name_prefix_5,
  t0.first_name AS first_name_6,
  t0.middle_name AS middle_name_7,
  t0.last_name AS last_name_8,
  t0.name_suffix AS name_suffix_9,
  t0.title AS title_10,
  t0.phone AS phone_11,
  t0.avatar AS avatar_12,
  t0.preferred_locale AS preferred_locale_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.password_reset_token_expires_at AS password_reset_token_expires_at_15,
  t0.totp_secret AS totp_secret_16,
  t0.backup_codes AS backup_codes_17,
  t0.preferences AS preferences_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.organization_id AS organization_id_21
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name_prefix AS name_prefix_5, t0.first_name AS first_name_6, t0.middle_name AS middle_name_7, t0.last_name AS last_name_8, t0.name_suffix AS name_suffix_9, t0.title AS title_10, t0.phone AS phone_11, t0.avatar AS avatar_12, t0.preferred_locale AS preferred_locale_13, t0.password_reset_token AS password_reset_token_14, t0.password_reset_token_expires_at AS password_reset_token_expires_at_15, t0.totp_secret AS totp_secret_16, t0.backup_codes AS backup_codes_17, t0.preferences AS preferences_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.organization_id AS organization_id_21 FROM "user" t0 WHERE t0.id = 2;

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE (n0_.organization_id = ? AND n0_.read_at IS NULL) AND (n0_.organization_id = '1')

[
  1
]

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notification n0_
WHERE
  (
    n0_.organization_id = ?
    AND n0_.read_at IS NULL
  )
  AND (n0_.organization_id = '1')

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE (n0_.organization_id = 1 AND n0_.read_at IS NULL) AND (n0_.organization_id = '1');

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE (n0_.organization_id = ? AND n0_.type = ? AND n0_.resolved_at IS NULL) AND (n0_.organization_id = '1')

[
  1
  "error"
]

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notification n0_
WHERE
  (
    n0_.organization_id = ?
    AND n0_.type = ?
    AND n0_.resolved_at IS NULL
  )
  AND (n0_.organization_id = '1')

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE (n0_.organization_id = 1 AND n0_.type = 'error' AND n0_.resolved_at IS NULL) AND (n0_.organization_id = '1');