Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.default_origin AS default_origin_2,
  t0.default_region AS default_region_3,
  t0.name AS name_4,
  t0.domain AS domain_5,
  t0.status AS status_6,
  t0.active AS active_7,
  t0.recaptcha_site_key AS recaptcha_site_key_8,
  t0.recaptcha_private_key AS recaptcha_private_key_9,
  t0.gtm_code AS gtm_code_10,
  t0.gtm_enabled AS gtm_enabled_11,
  t0.ga_code AS ga_code_12,
  t0.casino_cdn AS casino_cdn_13,
  t0.ga_enabled AS ga_enabled_14,
  t0.telegram_bot_origin AS telegram_bot_origin_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17
FROM
  project t0
WHERE
  t0.id = ?
  AND t0.active = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.default_origin AS default_origin_2, t0.default_region AS default_region_3, t0.name AS name_4, t0.domain AS domain_5, t0.status AS status_6, t0.active AS active_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_private_key AS recaptcha_private_key_9, t0.gtm_code AS gtm_code_10, t0.gtm_enabled AS gtm_enabled_11, t0.ga_code AS ga_code_12, t0.casino_cdn AS casino_cdn_13, t0.ga_enabled AS ga_enabled_14, t0.telegram_bot_origin AS telegram_bot_origin_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM project t0 WHERE t0.id = '0194ae0d-5b56-7acf-90b2-fb67913e9272' AND t0.active = 1 AND t0.status = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.default_origin AS default_origin_2,
  t0.default_region AS default_region_3,
  t0.name AS name_4,
  t0.domain AS domain_5,
  t0.status AS status_6,
  t0.active AS active_7,
  t0.recaptcha_site_key AS recaptcha_site_key_8,
  t0.recaptcha_private_key AS recaptcha_private_key_9,
  t0.gtm_code AS gtm_code_10,
  t0.gtm_enabled AS gtm_enabled_11,
  t0.ga_code AS ga_code_12,
  t0.casino_cdn AS casino_cdn_13,
  t0.ga_enabled AS ga_enabled_14,
  t0.telegram_bot_origin AS telegram_bot_origin_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17
FROM
  project t0
WHERE
  t0.id = ?
  AND t0.active = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.default_origin AS default_origin_2, t0.default_region AS default_region_3, t0.name AS name_4, t0.domain AS domain_5, t0.status AS status_6, t0.active AS active_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_private_key AS recaptcha_private_key_9, t0.gtm_code AS gtm_code_10, t0.gtm_enabled AS gtm_enabled_11, t0.ga_code AS ga_code_12, t0.casino_cdn AS casino_cdn_13, t0.ga_enabled AS ga_enabled_14, t0.telegram_bot_origin AS telegram_bot_origin_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM project t0 WHERE t0.id = '0194ae0d-5b56-7acf-90b2-fb67913e9272' AND t0.active = 1 AND t0.status = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.system_type AS system_type_3,
  t0.is_default AS is_default_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.project_id AS project_id_7,
  t0.language AS language_8,
  t9.locale AS locale_10,
  t9.name AS name_11,
  t9.position AS position_12
FROM
  project_language t0
  LEFT JOIN language t9 ON t0.language = t9.locale
WHERE
  t0.project_id = ?
ORDER BY
  t0.is_default DESC,
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.system_type AS system_type_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.project_id AS project_id_7, t0.language AS language_8, t9.locale AS locale_10, t9.name AS name_11, t9.position AS position_12 FROM project_language t0 LEFT JOIN language t9 ON t0.language = t9.locale WHERE t0.project_id = '0194ae0d-5b56-7acf-90b2-fb67913e9272' ORDER BY t0.is_default DESC, t0.position ASC;

SELECT
  banner.id,
  bt.background_image,
  bt.background_mobile_image,
  bt.inner_image,
  bt.inner_mobile_image,
  bt.title,
  bt.description,
  bt.mobile_description,
  bt.primary_button_text,
  bt.primary_button_url,
  bt.secondary_button_text,
  bt.secondary_button_url,
  bt.shown_on_sportsbook_main_page as show_on_sportsbook_main_page,
  bt.shown_on_casino_main_page as show_on_casino_main_page,
  bt.shown_on_casino_games_list as show_on_casino_games_list,
  COALESCE(bt.start_at, banner.start_at) start_at,
  COALESCE(bt.end_at, banner.end_at) end_at
FROM
  banner banner
  INNER JOIN banner_translation bt ON bt.banner_id = banner.id
  AND bt.language = ?
WHERE
  (
    banner.project_id = ?
    AND COALESCE(bt.published, banner.published) = 1
  )
  AND (banner.type = ?)
  AND (
    COALESCE(bt.start_at, banner.start_at) IS NULL
    OR COALESCE(bt.start_at, banner.start_at) <= NOW()
  )
  AND (
    COALESCE(bt.end_at, banner.end_at) IS NULL
    OR COALESCE(bt.end_at, banner.end_at) > NOW()
  )
  AND (
    bt.shown_on_sportsbook_main_page = ?
  )
ORDER BY
  COALESCE(bt.position, banner.position) ASC

SELECT banner.id, bt.background_image, bt.background_mobile_image, bt.inner_image, bt.inner_mobile_image, bt.title, bt.description, bt.mobile_description, bt.primary_button_text, bt.primary_button_url, bt.secondary_button_text, bt.secondary_button_url, bt.shown_on_sportsbook_main_page as show_on_sportsbook_main_page, bt.shown_on_casino_main_page as show_on_casino_main_page, bt.shown_on_casino_games_list as show_on_casino_games_list, COALESCE(bt.start_at, banner.start_at) start_at, COALESCE(bt.end_at, banner.end_at) end_at FROM banner banner INNER JOIN banner_translation bt ON bt.banner_id = banner.id AND bt.language = 'en-GB' WHERE (banner.project_id = '0194ae0d-5b56-7acf-90b2-fb67913e9272' AND COALESCE(bt.published, banner.published) = 1) AND (banner.type = 'Banner') AND (COALESCE(bt.start_at, banner.start_at) IS NULL OR COALESCE(bt.start_at, banner.start_at) <= NOW()) AND (COALESCE(bt.end_at, banner.end_at) IS NULL OR COALESCE(bt.end_at, banner.end_at) > NOW()) AND (bt.shown_on_sportsbook_main_page = 1) ORDER BY COALESCE(bt.position, banner.position) ASC;