Symfony Profiler

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

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.password AS password_2,
  t0.roles AS roles_3,
  t0.is_active AS is_active_4,
  t0.last_login_at AS last_login_at_5,
  t0.totp_secret AS totp_secret_6,
  t0.oidc_subject AS oidc_subject_7,
  t0.backup_codes AS backup_codes_8,
  t0.password_reset_token AS password_reset_token_9,
  t0.password_reset_token_expires_at AS password_reset_token_expires_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.contact_id AS contact_id_13,
  t0.organization_id AS organization_id_14
FROM
  customer_account t0
WHERE
  t0.id = ?
  AND (
    (t0.organization_id = '1')
  )

SELECT t0.id AS id_1, t0.password AS password_2, t0.roles AS roles_3, t0.is_active AS is_active_4, t0.last_login_at AS last_login_at_5, t0.totp_secret AS totp_secret_6, t0.oidc_subject AS oidc_subject_7, t0.backup_codes AS backup_codes_8, t0.password_reset_token AS password_reset_token_9, t0.password_reset_token_expires_at AS password_reset_token_expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.contact_id AS contact_id_13, t0.organization_id AS organization_id_14 FROM customer_account t0 WHERE t0.id = 10 AND ((t0.organization_id = '1'));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.channel_type AS channel_type_4,
  t0.currency AS currency_5,
  t0.active AS active_6,
  t0.localization AS localization_7,
  t0.email_sender_name AS email_sender_name_8,
  t0.email_sender_address AS email_sender_address_9,
  t0.auto_confirm_allocation_plan AS auto_confirm_allocation_plan_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.zone_id AS zone_id_13,
  t0.organization_id AS organization_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16
FROM
  sales_channel t0
WHERE
  t0.id = ?
  AND (
    (t0.organization_id = '1')
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.channel_type AS channel_type_4, t0.currency AS currency_5, t0.active AS active_6, t0.localization AS localization_7, t0.email_sender_name AS email_sender_name_8, t0.email_sender_address AS email_sender_address_9, t0.auto_confirm_allocation_plan AS auto_confirm_allocation_plan_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.zone_id AS zone_id_13, t0.organization_id AS organization_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM sales_channel t0 WHERE t0.id = 7 AND ((t0.organization_id = '1'));

SELECT
  t0.id AS id_1,
  t0.portal_name AS portal_name_2,
  t0.portal_url AS portal_url_3,
  t0.login_eyebrow AS login_eyebrow_4,
  t0.login_title AS login_title_5,
  t0.login_description AS login_description_6,
  t0.dns_verification_key AS dns_verification_key_7,
  t0.font_type_headers AS font_type_headers_8,
  t0.font_type_body AS font_type_body_9,
  t0.primary_color AS primary_color_10,
  t0.secondary_color AS secondary_color_11,
  t0.accent_color AS accent_color_12,
  t0.light_color AS light_color_13,
  t0.dark_color AS dark_color_14,
  t0.tone AS tone_15,
  t0.oidc_enabled AS oidc_enabled_16,
  t0.intake_email_address AS intake_email_address_17,
  t0.intake_email_password AS intake_email_password_18,
  t0.intake_email_polling_interval AS intake_email_polling_interval_19,
  t0.intake_email_provider AS intake_email_provider_20,
  t0.intake_email_last_polled_at AS intake_email_last_polled_at_21,
  t0.open_catalog_enabled AS open_catalog_enabled_22,
  t0.open_catalog_show_pricing AS open_catalog_show_pricing_23,
  t0.open_catalog_show_inventory AS open_catalog_show_inventory_24,
  t0.open_catalog_show_shipping_promise AS open_catalog_show_shipping_promise_25,
  t0.grouping_product_contact_enabled AS grouping_product_contact_enabled_26,
  t0.sales_channel_id AS sales_channel_id_27,
  t0.menu_id AS menu_id_28,
  t0.logo_asset_id AS logo_asset_id_29,
  t0.login_logo_asset_id AS login_logo_asset_id_30,
  t0.email_logo_asset_id AS email_logo_asset_id_31,
  t0.favicon_asset_id AS favicon_asset_id_32,
  t0.key_visual_asset_id AS key_visual_asset_id_33,
  t0.dashboard_banner_asset_id AS dashboard_banner_asset_id_34,
  t0.mailbox_connection_id AS mailbox_connection_id_35,
  t0.type
FROM
  sales_channel_settings t0
WHERE
  t0.sales_channel_id = ?
  AND t0.type IN (
    'b2b_portal', 'field_sales', 'store'
  )

SELECT t0.id AS id_1, t0.portal_name AS portal_name_2, t0.portal_url AS portal_url_3, t0.login_eyebrow AS login_eyebrow_4, t0.login_title AS login_title_5, t0.login_description AS login_description_6, t0.dns_verification_key AS dns_verification_key_7, t0.font_type_headers AS font_type_headers_8, t0.font_type_body AS font_type_body_9, t0.primary_color AS primary_color_10, t0.secondary_color AS secondary_color_11, t0.accent_color AS accent_color_12, t0.light_color AS light_color_13, t0.dark_color AS dark_color_14, t0.tone AS tone_15, t0.oidc_enabled AS oidc_enabled_16, t0.intake_email_address AS intake_email_address_17, t0.intake_email_password AS intake_email_password_18, t0.intake_email_polling_interval AS intake_email_polling_interval_19, t0.intake_email_provider AS intake_email_provider_20, t0.intake_email_last_polled_at AS intake_email_last_polled_at_21, t0.open_catalog_enabled AS open_catalog_enabled_22, t0.open_catalog_show_pricing AS open_catalog_show_pricing_23, t0.open_catalog_show_inventory AS open_catalog_show_inventory_24, t0.open_catalog_show_shipping_promise AS open_catalog_show_shipping_promise_25, t0.grouping_product_contact_enabled AS grouping_product_contact_enabled_26, t0.sales_channel_id AS sales_channel_id_27, t0.menu_id AS menu_id_28, t0.logo_asset_id AS logo_asset_id_29, t0.login_logo_asset_id AS login_logo_asset_id_30, t0.email_logo_asset_id AS email_logo_asset_id_31, t0.favicon_asset_id AS favicon_asset_id_32, t0.key_visual_asset_id AS key_visual_asset_id_33, t0.dashboard_banner_asset_id AS dashboard_banner_asset_id_34, t0.mailbox_connection_id AS mailbox_connection_id_35, t0.type FROM sales_channel_settings t0 WHERE t0.sales_channel_id = 7 AND t0.type IN ('b2b_portal', 'field_sales', 'store');

SELECT
  t0.id AS id_1,
  t0.name_prefix AS name_prefix_2,
  t0.first_name AS first_name_3,
  t0.middle_name AS middle_name_4,
  t0.last_name AS last_name_5,
  t0.name_suffix AS name_suffix_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.job_title AS job_title_9,
  t0.role AS role_10,
  t0.locale AS locale_11,
  t0.receive_invoice_copy AS receive_invoice_copy_12,
  t0.is_active AS is_active_13,
  t0.approval_authority AS approval_authority_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.frontend_role_id AS frontend_role_id_17,
  t0.customer_id AS customer_id_18,
  t0.organization_id AS organization_id_19
FROM
  contact t0
WHERE
  t0.id = ?
  AND (
    (t0.organization_id = '1')
  )

SELECT t0.id AS id_1, t0.name_prefix AS name_prefix_2, t0.first_name AS first_name_3, t0.middle_name AS middle_name_4, t0.last_name AS last_name_5, t0.name_suffix AS name_suffix_6, t0.email AS email_7, t0.phone AS phone_8, t0.job_title AS job_title_9, t0.role AS role_10, t0.locale AS locale_11, t0.receive_invoice_copy AS receive_invoice_copy_12, t0.is_active AS is_active_13, t0.approval_authority AS approval_authority_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.frontend_role_id AS frontend_role_id_17, t0.customer_id AS customer_id_18, t0.organization_id AS organization_id_19 FROM contact t0 WHERE t0.id = 111 AND ((t0.organization_id = '1'));

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.customer_number AS customer_number_4,
  t0.vat_number AS vat_number_5,
  t0.email AS email_6,
  t0.invoice_email AS invoice_email_7,
  t0.invoice_copy_to_contact AS invoice_copy_to_contact_8,
  t0.phone AS phone_9,
  t0.website AS website_10,
  t0.logo AS logo_11,
  t0.preferred_locale AS preferred_locale_12,
  t0.credit_limit AS credit_limit_13,
  t0.credit_limit_currency AS credit_limit_currency_14,
  t0.is_active AS is_active_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.customer_group_id AS customer_group_id_18,
  t0.payment_term_id AS payment_term_id_19,
  t0.payment_schedule_id AS payment_schedule_id_20,
  t0.sales_representative_id AS sales_representative_id_21,
  t0.organization_id AS organization_id_22
FROM
  customer t0
WHERE
  t0.id = ?
  AND (
    (t0.organization_id = '1')
  )

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.customer_number AS customer_number_4, t0.vat_number AS vat_number_5, t0.email AS email_6, t0.invoice_email AS invoice_email_7, t0.invoice_copy_to_contact AS invoice_copy_to_contact_8, t0.phone AS phone_9, t0.website AS website_10, t0.logo AS logo_11, t0.preferred_locale AS preferred_locale_12, t0.credit_limit AS credit_limit_13, t0.credit_limit_currency AS credit_limit_currency_14, t0.is_active AS is_active_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.customer_group_id AS customer_group_id_18, t0.payment_term_id AS payment_term_id_19, t0.payment_schedule_id AS payment_schedule_id_20, t0.sales_representative_id AS sales_representative_id_21, t0.organization_id AS organization_id_22 FROM customer t0 WHERE t0.id = 2 AND ((t0.organization_id = '1'));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.channel_type AS channel_type_4,
  t0.currency AS currency_5,
  t0.active AS active_6,
  t0.localization AS localization_7,
  t0.email_sender_name AS email_sender_name_8,
  t0.email_sender_address AS email_sender_address_9,
  t0.auto_confirm_allocation_plan AS auto_confirm_allocation_plan_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.zone_id AS zone_id_13,
  t0.organization_id AS organization_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16
FROM
  sales_channel t0
  INNER JOIN contact_sales_channel ON t0.id = contact_sales_channel.sales_channel_id
WHERE
  contact_sales_channel.contact_id = ?
  AND (
    (t0.organization_id = '1')
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.channel_type AS channel_type_4, t0.currency AS currency_5, t0.active AS active_6, t0.localization AS localization_7, t0.email_sender_name AS email_sender_name_8, t0.email_sender_address AS email_sender_address_9, t0.auto_confirm_allocation_plan AS auto_confirm_allocation_plan_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.zone_id AS zone_id_13, t0.organization_id AS organization_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM sales_channel t0 INNER JOIN contact_sales_channel ON t0.id = contact_sales_channel.sales_channel_id WHERE contact_sales_channel.contact_id = 111 AND ((t0.organization_id = '1'));

SELECT
  t0.id AS id_1,
  t0.portal_name AS portal_name_2,
  t0.portal_url AS portal_url_3,
  t0.login_eyebrow AS login_eyebrow_4,
  t0.login_title AS login_title_5,
  t0.login_description AS login_description_6,
  t0.dns_verification_key AS dns_verification_key_7,
  t0.font_type_headers AS font_type_headers_8,
  t0.font_type_body AS font_type_body_9,
  t0.primary_color AS primary_color_10,
  t0.secondary_color AS secondary_color_11,
  t0.accent_color AS accent_color_12,
  t0.light_color AS light_color_13,
  t0.dark_color AS dark_color_14,
  t0.tone AS tone_15,
  t0.oidc_enabled AS oidc_enabled_16,
  t0.intake_email_address AS intake_email_address_17,
  t0.intake_email_password AS intake_email_password_18,
  t0.intake_email_polling_interval AS intake_email_polling_interval_19,
  t0.intake_email_provider AS intake_email_provider_20,
  t0.intake_email_last_polled_at AS intake_email_last_polled_at_21,
  t0.open_catalog_enabled AS open_catalog_enabled_22,
  t0.open_catalog_show_pricing AS open_catalog_show_pricing_23,
  t0.open_catalog_show_inventory AS open_catalog_show_inventory_24,
  t0.open_catalog_show_shipping_promise AS open_catalog_show_shipping_promise_25,
  t0.grouping_product_contact_enabled AS grouping_product_contact_enabled_26,
  t0.sales_channel_id AS sales_channel_id_27,
  t0.menu_id AS menu_id_28,
  t0.logo_asset_id AS logo_asset_id_29,
  t0.login_logo_asset_id AS login_logo_asset_id_30,
  t0.email_logo_asset_id AS email_logo_asset_id_31,
  t0.favicon_asset_id AS favicon_asset_id_32,
  t0.key_visual_asset_id AS key_visual_asset_id_33,
  t0.dashboard_banner_asset_id AS dashboard_banner_asset_id_34,
  t0.mailbox_connection_id AS mailbox_connection_id_35,
  t0.type
FROM
  sales_channel_settings t0
WHERE
  t0.sales_channel_id = ?
  AND t0.type IN (
    'b2b_portal', 'field_sales', 'store'
  )

SELECT t0.id AS id_1, t0.portal_name AS portal_name_2, t0.portal_url AS portal_url_3, t0.login_eyebrow AS login_eyebrow_4, t0.login_title AS login_title_5, t0.login_description AS login_description_6, t0.dns_verification_key AS dns_verification_key_7, t0.font_type_headers AS font_type_headers_8, t0.font_type_body AS font_type_body_9, t0.primary_color AS primary_color_10, t0.secondary_color AS secondary_color_11, t0.accent_color AS accent_color_12, t0.light_color AS light_color_13, t0.dark_color AS dark_color_14, t0.tone AS tone_15, t0.oidc_enabled AS oidc_enabled_16, t0.intake_email_address AS intake_email_address_17, t0.intake_email_password AS intake_email_password_18, t0.intake_email_polling_interval AS intake_email_polling_interval_19, t0.intake_email_provider AS intake_email_provider_20, t0.intake_email_last_polled_at AS intake_email_last_polled_at_21, t0.open_catalog_enabled AS open_catalog_enabled_22, t0.open_catalog_show_pricing AS open_catalog_show_pricing_23, t0.open_catalog_show_inventory AS open_catalog_show_inventory_24, t0.open_catalog_show_shipping_promise AS open_catalog_show_shipping_promise_25, t0.grouping_product_contact_enabled AS grouping_product_contact_enabled_26, t0.sales_channel_id AS sales_channel_id_27, t0.menu_id AS menu_id_28, t0.logo_asset_id AS logo_asset_id_29, t0.login_logo_asset_id AS login_logo_asset_id_30, t0.email_logo_asset_id AS email_logo_asset_id_31, t0.favicon_asset_id AS favicon_asset_id_32, t0.key_visual_asset_id AS key_visual_asset_id_33, t0.dashboard_banner_asset_id AS dashboard_banner_asset_id_34, t0.mailbox_connection_id AS mailbox_connection_id_35, t0.type FROM sales_channel_settings t0 WHERE t0.sales_channel_id = 8 AND t0.type IN ('b2b_portal', 'field_sales', 'store');

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', 'field_sales', 'store'
  )
WHERE
  (
    s0_.active = true
    AND (
      LOWER(s1_.portal_url) IN (?, ?)
      OR LOWER(s1_.portal_url) LIKE ?
      OR LOWER(s1_.portal_url) LIKE ?
      OR LOWER(s1_.portal_url) LIKE ?
      OR LOWER(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', 'field_sales', 'store') WHERE (s0_.active = true AND (LOWER(s1_.portal_url) IN ('https://vendordesk-portal.marello.com', 'http://vendordesk-portal.marello.com') OR LOWER(s1_.portal_url) LIKE 'https://vendordesk-portal.marello.com/%' OR LOWER(s1_.portal_url) LIKE 'https://vendordesk-portal.marello.com:%' OR LOWER(s1_.portal_url) LIKE 'http://vendordesk-portal.marello.com/%' OR LOWER(s1_.portal_url) LIKE 'http://vendordesk-portal.marello.com:%')) AND (s0_.organization_id = '1') LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.status AS status_2,
  s0_.localization AS localization_3,
  s0_.po_number AS po_number_4,
  s0_.notes AS notes_5,
  s0_.requested_shipping_date AS requested_shipping_date_6,
  s0_.subtotal_excl AS subtotal_excl_7,
  s0_.vat_total AS vat_total_8,
  s0_.shipping_cost AS shipping_cost_9,
  s0_.shipping_vat_amount AS shipping_vat_amount_10,
  s0_.grand_total AS grand_total_11,
  s0_.payment_instrument AS payment_instrument_12,
  s0_.is_current AS is_current_13,
  s0_.prices_stale AS prices_stale_14,
  s0_.last_modified_at AS last_modified_at_15,
  s0_.last_reminded_at AS last_reminded_at_16,
  s0_.assistant_origin AS assistant_origin_17,
  s0_.assistant_conversation_id AS assistant_conversation_id_18,
  s0_.assistant_credential_id AS assistant_credential_id_19,
  s0_.reminder_cycle AS reminder_cycle_20,
  s0_.created_at AS created_at_21,
  s0_.updated_at AS updated_at_22,
  s0_.customer_id AS customer_id_23,
  s0_.contact_id AS contact_id_24,
  s0_.sales_channel_id AS sales_channel_id_25,
  s0_.billing_address_id AS billing_address_id_26,
  s0_.shipping_address_id AS shipping_address_id_27,
  s0_.shipping_rule_id AS shipping_rule_id_28,
  s0_.payment_method_id AS payment_method_id_29,
  s0_.converted_order_id AS converted_order_id_30,
  s0_.organization_id AS organization_id_31,
  s0_.created_by_id AS created_by_id_32,
  s0_.updated_by_id AS updated_by_id_33
FROM
  shopping_list s0_
WHERE
  (
    s0_.id = ?
    AND s0_.customer_id = ?
    AND (
      (
        s0_.contact_id IS NULL
        OR s0_.contact_id = ?
      )
    )
  )
  AND (s0_.organization_id = '1')

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.status AS status_2, s0_.localization AS localization_3, s0_.po_number AS po_number_4, s0_.notes AS notes_5, s0_.requested_shipping_date AS requested_shipping_date_6, s0_.subtotal_excl AS subtotal_excl_7, s0_.vat_total AS vat_total_8, s0_.shipping_cost AS shipping_cost_9, s0_.shipping_vat_amount AS shipping_vat_amount_10, s0_.grand_total AS grand_total_11, s0_.payment_instrument AS payment_instrument_12, s0_.is_current AS is_current_13, s0_.prices_stale AS prices_stale_14, s0_.last_modified_at AS last_modified_at_15, s0_.last_reminded_at AS last_reminded_at_16, s0_.assistant_origin AS assistant_origin_17, s0_.assistant_conversation_id AS assistant_conversation_id_18, s0_.assistant_credential_id AS assistant_credential_id_19, s0_.reminder_cycle AS reminder_cycle_20, s0_.created_at AS created_at_21, s0_.updated_at AS updated_at_22, s0_.customer_id AS customer_id_23, s0_.contact_id AS contact_id_24, s0_.sales_channel_id AS sales_channel_id_25, s0_.billing_address_id AS billing_address_id_26, s0_.shipping_address_id AS shipping_address_id_27, s0_.shipping_rule_id AS shipping_rule_id_28, s0_.payment_method_id AS payment_method_id_29, s0_.converted_order_id AS converted_order_id_30, s0_.organization_id AS organization_id_31, s0_.created_by_id AS created_by_id_32, s0_.updated_by_id AS updated_by_id_33 FROM shopping_list s0_ WHERE (s0_.id = 9729 AND s0_.customer_id = 2 AND ((s0_.contact_id IS NULL OR s0_.contact_id = 111))) AND (s0_.organization_id = '1');