Symfony Profiler

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 = 5 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 = ?
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 = '25carat.marello.com' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.target_slug AS target_slug_2,
  c0_.target_uri AS target_uri_3,
  c0_.sort_order AS sort_order_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c1_.id AS id_7,
  c1_.locale AS locale_8,
  c1_.name AS name_9,
  c0_.menu_id AS menu_id_10,
  c0_.parent_id AS parent_id_11,
  c0_.organization_id AS organization_id_12,
  c1_.node_id AS node_id_13
FROM
  cms_menu_node c0_
  LEFT JOIN cms_menu_node_translation c1_ ON c0_.id = c1_.node_id
WHERE
  (c0_.menu_id = ?)
  AND (c0_.organization_id = '5')
ORDER BY
  c0_.sort_order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.target_slug AS target_slug_2, c0_.target_uri AS target_uri_3, c0_.sort_order AS sort_order_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.name AS name_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11, c0_.organization_id AS organization_id_12, c1_.node_id AS node_id_13 FROM cms_menu_node c0_ LEFT JOIN cms_menu_node_translation c1_ ON c0_.id = c1_.node_id WHERE (c0_.menu_id = 17) AND (c0_.organization_id = '5') ORDER BY c0_.sort_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.appearance AS appearance_3,
  c0_.is_system AS is_system_4,
  c0_.is_enabled AS is_enabled_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.organization_id AS organization_id_8
FROM
  cms_menu c0_
WHERE
  (
    c0_.code = ?
    AND c0_.is_enabled = true
  )
  AND (c0_.organization_id = '5')
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.appearance AS appearance_3, c0_.is_system AS is_system_4, c0_.is_enabled AS is_enabled_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.organization_id AS organization_id_8 FROM cms_menu c0_ WHERE (c0_.code = 'main' AND c0_.is_enabled = true) AND (c0_.organization_id = '5') LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.status AS status_2,
  m0_.title AS title_3,
  m0_.tags AS tags_4,
  m0_.excerpt AS excerpt_5,
  m0_.body AS body_6,
  m0_.meta_title AS meta_title_7,
  m0_.meta_description AS meta_description_8,
  m0_.ai_provider AS ai_provider_9,
  m0_.failure_reason AS failure_reason_10,
  m0_.image_brief AS image_brief_11,
  m0_.image_url AS image_url_12,
  m0_.image_attribution AS image_attribution_13,
  m0_.image_candidates AS image_candidates_14,
  m0_.image_provider AS image_provider_15,
  m0_.slug AS slug_16,
  m0_.scheduled_for AS scheduled_for_17,
  m0_.published_at AS published_at_18,
  m0_.linkedin_post_urn AS linkedin_post_urn_19,
  m0_.linkedin_posted_at AS linkedin_posted_at_20,
  m0_.created_at AS created_at_21,
  m0_.updated_at AS updated_at_22,
  m0_.topic_id AS topic_id_23,
  m0_.organization_id AS organization_id_24,
  m0_.created_by_id AS created_by_id_25,
  m0_.updated_by_id AS updated_by_id_26
FROM
  marketing_content_piece m0_
WHERE
  (
    m0_.status = ?
    AND m0_.type = ?
    AND m0_.slug IS NOT NULL
  )
  AND (m0_.organization_id = '5')
ORDER BY
  m0_.published_at DESC,
  m0_.id DESC
LIMIT
  13

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.status AS status_2, m0_.title AS title_3, m0_.tags AS tags_4, m0_.excerpt AS excerpt_5, m0_.body AS body_6, m0_.meta_title AS meta_title_7, m0_.meta_description AS meta_description_8, m0_.ai_provider AS ai_provider_9, m0_.failure_reason AS failure_reason_10, m0_.image_brief AS image_brief_11, m0_.image_url AS image_url_12, m0_.image_attribution AS image_attribution_13, m0_.image_candidates AS image_candidates_14, m0_.image_provider AS image_provider_15, m0_.slug AS slug_16, m0_.scheduled_for AS scheduled_for_17, m0_.published_at AS published_at_18, m0_.linkedin_post_urn AS linkedin_post_urn_19, m0_.linkedin_posted_at AS linkedin_posted_at_20, m0_.created_at AS created_at_21, m0_.updated_at AS updated_at_22, m0_.topic_id AS topic_id_23, m0_.organization_id AS organization_id_24, m0_.created_by_id AS created_by_id_25, m0_.updated_by_id AS updated_by_id_26 FROM marketing_content_piece m0_ WHERE (m0_.status = 'published' AND m0_.type = 'blog_post' AND m0_.slug IS NOT NULL) AND (m0_.organization_id = '5') ORDER BY m0_.published_at DESC, m0_.id DESC LIMIT 13;

SELECT
  t0.id AS id_1,
  t0.heading_font AS heading_font_2,
  t0.body_font AS body_font_3,
  t0.primary_color AS primary_color_4,
  t0.secondary_color AS secondary_color_5,
  t0.accent_color AS accent_color_6,
  t0.light_color AS light_color_7,
  t0.dark_color AS dark_color_8,
  t0.logo_url AS logo_url_9,
  t0.favicon_url AS favicon_url_10,
  t0.site_name AS site_name_11,
  t0.blog_title AS blog_title_12,
  t0.og_image_url AS og_image_url_13,
  t0.footer_tagline AS footer_tagline_14,
  t0.linkedin_url AS linkedin_url_15,
  t0.twitter_url AS twitter_url_16,
  t0.facebook_url AS facebook_url_17,
  t0.instagram_url AS instagram_url_18,
  t0.youtube_url AS youtube_url_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.organization_id AS organization_id_22
FROM
  cms_tenant_styleguide t0
WHERE
  t0.organization_id = ?
  AND (
    (t0.organization_id = '5')
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.heading_font AS heading_font_2, t0.body_font AS body_font_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.accent_color AS accent_color_6, t0.light_color AS light_color_7, t0.dark_color AS dark_color_8, t0.logo_url AS logo_url_9, t0.favicon_url AS favicon_url_10, t0.site_name AS site_name_11, t0.blog_title AS blog_title_12, t0.og_image_url AS og_image_url_13, t0.footer_tagline AS footer_tagline_14, t0.linkedin_url AS linkedin_url_15, t0.twitter_url AS twitter_url_16, t0.facebook_url AS facebook_url_17, t0.instagram_url AS instagram_url_18, t0.youtube_url AS youtube_url_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.organization_id AS organization_id_22 FROM cms_tenant_styleguide t0 WHERE t0.organization_id = 5 AND ((t0.organization_id = '5')) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.target_slug AS target_slug_3,
  t0.target_uri AS target_uri_4,
  t0.sort_order AS sort_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.menu_id AS menu_id_8,
  t0.parent_id AS parent_id_9,
  t0.organization_id AS organization_id_10
FROM
  cms_menu_node t0
WHERE
  t0.menu_id = ?
  AND (
    (t0.organization_id = '5')
  )
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.target_slug AS target_slug_3, t0.target_uri AS target_uri_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.menu_id AS menu_id_8, t0.parent_id AS parent_id_9, t0.organization_id AS organization_id_10 FROM cms_menu_node t0 WHERE t0.menu_id = 17 AND ((t0.organization_id = '5')) ORDER BY t0.sort_order ASC;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  marketing_content_piece m0_
WHERE
  (
    m0_.status = ?
    AND m0_.type = ?
    AND m0_.slug IS NOT NULL
  )
  AND (m0_.organization_id = '5')

SELECT COUNT(m0_.id) AS sclr_0 FROM marketing_content_piece m0_ WHERE (m0_.status = 'published' AND m0_.type = 'blog_post' AND m0_.slug IS NOT NULL) AND (m0_.organization_id = '5');