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 = '018d7e2d-c109-7e08-b765-142f028832ef' 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 = '018d7e2d-c109-7e08-b765-142f028832ef' 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 = '018d7e2d-c109-7e08-b765-142f028832ef' ORDER BY t0.is_default DESC, t0.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.icon AS icon_1,
  c0_.image AS image_2,
  c0_.type AS type_3,
  c0_.project_id AS project_id_4
FROM
  casino_game_category c0_
  INNER JOIN casino_game_category_translation c1_ ON c0_.id = c1_.entity_id
  AND (
    c1_.language_code = ?
    AND c1_.slug = ?
  )
WHERE
  (c0_.project_id = ?)
  AND c0_.type IN ('root')

SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.image AS image_2, c0_.type AS type_3, c0_.project_id AS project_id_4 FROM casino_game_category c0_ INNER JOIN casino_game_category_translation c1_ ON c0_.id = c1_.entity_id AND (c1_.language_code = 'pt-PT' AND c1_.slug = 'casino') WHERE (c0_.project_id = '018d7e2d-c109-7e08-b765-142f028832ef') AND c0_.type IN ('root');

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 = '018d7e2d-c109-7e08-b765-142f028832ef' 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 = '018d7e2d-c109-7e08-b765-142f028832ef' AND t0.active = 1 AND t0.status = 10 LIMIT 1;

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 = ?
  INNER JOIN casino_game_category_to_info_card_banner btc ON btc.banner_id = banner.id
  AND btc.category_id = ?
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()
  )
ORDER BY
  btc.index 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 = 'pt-PT' INNER JOIN casino_game_category_to_info_card_banner btc ON btc.banner_id = banner.id AND btc.category_id = '018fce31-76c8-78ac-8576-ea0bc16d3079' WHERE (banner.project_id = '018d7e2d-c109-7e08-b765-142f028832ef' AND COALESCE(bt.published, banner.published) = 1) AND (banner.type = 'Info-card') 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()) ORDER BY btc.index ASC;