Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.code AS code_2,
  s0_.channel_type AS channel_type_3,
  s0_.currency AS currency_4,
  s0_.active AS active_5,
  s0_.localization AS localization_6,
  s0_.email_sender_name AS email_sender_name_7,
  s0_.email_sender_address AS email_sender_address_8,
  s0_.auto_confirm_allocation_plan AS auto_confirm_allocation_plan_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.zone_id AS zone_id_12,
  s0_.organization_id AS organization_id_13,
  s0_.created_by_id AS created_by_id_14,
  s0_.updated_by_id AS updated_by_id_15
FROM
  sales_channel s0_
  INNER JOIN sales_channel_settings s1_ ON s0_.id = s1_.sales_channel_id
  AND s1_.type IN ('b2b_portal')
WHERE
  (
    s0_.active = true
    AND (
      s1_.portal_url LIKE ?
      OR s1_.portal_url LIKE ?
    )
  )
  AND (s0_.organization_id = '1')
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.channel_type AS channel_type_3, s0_.currency AS currency_4, s0_.active AS active_5, s0_.localization AS localization_6, s0_.email_sender_name AS email_sender_name_7, s0_.email_sender_address AS email_sender_address_8, s0_.auto_confirm_allocation_plan AS auto_confirm_allocation_plan_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.zone_id AS zone_id_12, s0_.organization_id AS organization_id_13, s0_.created_by_id AS created_by_id_14, s0_.updated_by_id AS updated_by_id_15 FROM sales_channel s0_ INNER JOIN sales_channel_settings s1_ ON s0_.id = s1_.sales_channel_id AND s1_.type IN ('b2b_portal') WHERE (s0_.active = true AND (s1_.portal_url LIKE 'https://vendordesk-portal.marello.com%' OR s1_.portal_url LIKE 'http://vendordesk-portal.marello.com%')) AND (s0_.organization_id = '1') 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.api_token AS api_token_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  organization t0
WHERE
  t0.domain = ?
  AND t0.is_active = ?
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.api_token AS api_token_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM organization t0 WHERE t0.domain = 'vendordesk.marello.com' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.allowed_currencies AS allowed_currencies_2,
  t0.default_currency AS default_currency_3,
  t0.allowed_localizations AS allowed_localizations_4,
  t0.default_localization AS default_localization_5,
  t0.timezone AS timezone_6,
  t0.shipping_origin_country AS shipping_origin_country_7,
  t0.order_number_prefix AS order_number_prefix_8,
  t0.order_number_next AS order_number_next_9,
  t0.intake_number_next AS intake_number_next_10,
  t0.invoice_number_prefix AS invoice_number_prefix_11,
  t0.invoice_number_next AS invoice_number_next_12,
  t0.price_resolution_mode AS price_resolution_mode_13,
  t0.search_boosts AS search_boosts_14,
  t0.frequently_bought_retention_days AS frequently_bought_retention_days_15,
  t0.ga4_measurement_id AS ga4_measurement_id_16,
  t0.gtm_container_id AS gtm_container_id_17,
  t0.cookie_banner_enabled AS cookie_banner_enabled_18,
  t0.cookie_policy_slug AS cookie_policy_slug_19,
  t0.seo_head_snippet AS seo_head_snippet_20,
  t0.robots_txt AS robots_txt_21,
  t0.jwt_ttl_seconds AS jwt_ttl_seconds_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.organization_id AS organization_id_25,
  t0.default_payment_term_id AS default_payment_term_id_26
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.allowed_localizations AS allowed_localizations_4, t0.default_localization AS default_localization_5, t0.timezone AS timezone_6, t0.shipping_origin_country AS shipping_origin_country_7, t0.order_number_prefix AS order_number_prefix_8, t0.order_number_next AS order_number_next_9, t0.intake_number_next AS intake_number_next_10, t0.invoice_number_prefix AS invoice_number_prefix_11, t0.invoice_number_next AS invoice_number_next_12, t0.price_resolution_mode AS price_resolution_mode_13, t0.search_boosts AS search_boosts_14, t0.frequently_bought_retention_days AS frequently_bought_retention_days_15, t0.ga4_measurement_id AS ga4_measurement_id_16, t0.gtm_container_id AS gtm_container_id_17, t0.cookie_banner_enabled AS cookie_banner_enabled_18, t0.cookie_policy_slug AS cookie_policy_slug_19, t0.seo_head_snippet AS seo_head_snippet_20, t0.robots_txt AS robots_txt_21, t0.jwt_ttl_seconds AS jwt_ttl_seconds_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.organization_id AS organization_id_25, t0.default_payment_term_id AS default_payment_term_id_26 FROM organization_settings t0 WHERE t0.organization_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.primary_color AS primary_color_2,
  t0.accent_color AS accent_color_3,
  t0.heading_font AS heading_font_4,
  t0.body_font AS body_font_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.organization_id AS organization_id_8
FROM
  brand_config t0
WHERE
  t0.organization_id = ?
  AND (
    (t0.organization_id = '1')
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.primary_color AS primary_color_2, t0.accent_color AS accent_color_3, t0.heading_font AS heading_font_4, t0.body_font AS body_font_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.organization_id AS organization_id_8 FROM brand_config t0 WHERE t0.organization_id = 1 AND ((t0.organization_id = '1')) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.portal_name AS portal_name_2,
  t0.portal_url AS portal_url_3,
  t0.dns_verification_key AS dns_verification_key_4,
  t0.font_type_headers AS font_type_headers_5,
  t0.font_type_body AS font_type_body_6,
  t0.primary_color AS primary_color_7,
  t0.secondary_color AS secondary_color_8,
  t0.intake_email_address AS intake_email_address_9,
  t0.intake_email_password AS intake_email_password_10,
  t0.intake_email_polling_interval AS intake_email_polling_interval_11,
  t0.intake_email_provider AS intake_email_provider_12,
  t0.intake_notification_recipients AS intake_notification_recipients_13,
  t0.sales_channel_id AS sales_channel_id_14,
  t0.menu_id AS menu_id_15,
  t0.logo_asset_id AS logo_asset_id_16,
  t0.login_logo_asset_id AS login_logo_asset_id_17,
  t0.email_logo_asset_id AS email_logo_asset_id_18,
  t0.favicon_asset_id AS favicon_asset_id_19,
  t0.key_visual_asset_id AS key_visual_asset_id_20,
  t0.dashboard_banner_asset_id AS dashboard_banner_asset_id_21,
  t0.type
FROM
  sales_channel_settings t0
WHERE
  t0.sales_channel_id = ?
  AND t0.type IN ('b2b_portal')

SELECT t0.id AS id_1, t0.portal_name AS portal_name_2, t0.portal_url AS portal_url_3, t0.dns_verification_key AS dns_verification_key_4, t0.font_type_headers AS font_type_headers_5, t0.font_type_body AS font_type_body_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.intake_email_address AS intake_email_address_9, t0.intake_email_password AS intake_email_password_10, t0.intake_email_polling_interval AS intake_email_polling_interval_11, t0.intake_email_provider AS intake_email_provider_12, t0.intake_notification_recipients AS intake_notification_recipients_13, t0.sales_channel_id AS sales_channel_id_14, t0.menu_id AS menu_id_15, t0.logo_asset_id AS logo_asset_id_16, t0.login_logo_asset_id AS login_logo_asset_id_17, t0.email_logo_asset_id AS email_logo_asset_id_18, t0.favicon_asset_id AS favicon_asset_id_19, t0.key_visual_asset_id AS key_visual_asset_id_20, t0.dashboard_banner_asset_id AS dashboard_banner_asset_id_21, t0.type FROM sales_channel_settings t0 WHERE t0.sales_channel_id = 7 AND t0.type IN ('b2b_portal');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.appearance AS appearance_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.organization_id AS organization_id_8
FROM
  menu t0
WHERE
  t0.id = ?
  AND (
    (t0.organization_id = '1')
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.appearance AS appearance_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.organization_id AS organization_id_8 FROM menu t0 WHERE t0.id = 2 AND ((t0.organization_id = '1') AND (t0.deleted_at IS NULL));