Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  widget t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM widget t0 WHERE t0.id = 'ca67ce91-d46d-4a34-9f49-e719c720b035';

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.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.region AS region_2,
  t0.origin AS origin_3,
  t0.project_id AS project_id_4
FROM
  project_origin t0
WHERE
  t0.project_id = ?
  AND t0.region = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.region AS region_2, t0.origin AS origin_3, t0.project_id AS project_id_4 FROM project_origin t0 WHERE t0.project_id = '0194ae0d-5b56-7acf-90b2-fb67913e9272' AND t0.region = 'MD' LIMIT 1;

SELECT
  COALESCE(b0_.position, b1_.position) AS sclr_0,
  b1_.id AS id_1,
  b1_.type AS type_2,
  b1_.identifier AS identifier_3,
  b1_.description AS description_4,
  b1_.start_date_time AS start_date_time_5,
  b1_.end_date_time AS end_date_time_6,
  b1_.position AS position_7,
  b1_.published AS published_8,
  b1_.image1 AS image1_9,
  b1_.image2 AS image2_10,
  b1_.created_at AS created_at_11,
  b1_.updated_at AS updated_at_12,
  b0_.id AS id_13,
  b0_.name AS name_14,
  b0_.image AS image_15,
  b0_.image_alt AS image_alt_16,
  b0_.image_title AS image_title_17,
  b0_.locale AS locale_18,
  b0_.position AS position_19,
  b0_.published AS published_20,
  b0_.entity_id AS entity_id_21
FROM
  bt_promo_bets b1_
  INNER JOIN bt_promo_bets_origin b2_ ON b1_.id = b2_.promo_bets_id
  AND (b2_.origin = ?)
  LEFT JOIN bt_promo_bets_translation b0_ ON b1_.id = b0_.entity_id
WHERE
  (
    b1_.project_id = ?
    AND COALESCE(b0_.published, b1_.published) = 1
  )
  AND b1_.type = ?
  AND (
    (
      b1_.start_date_time <= ?
      OR b1_.start_date_time IS NULL
    )
    AND (
      b1_.end_date_time > ?
      OR b1_.end_date_time IS NULL
    )
  )
ORDER BY
  sclr_0 ASC

SELECT COALESCE(b0_.position, b1_.position) AS sclr_0, b1_.id AS id_1, b1_.type AS type_2, b1_.identifier AS identifier_3, b1_.description AS description_4, b1_.start_date_time AS start_date_time_5, b1_.end_date_time AS end_date_time_6, b1_.position AS position_7, b1_.published AS published_8, b1_.image1 AS image1_9, b1_.image2 AS image2_10, b1_.created_at AS created_at_11, b1_.updated_at AS updated_at_12, b0_.id AS id_13, b0_.name AS name_14, b0_.image AS image_15, b0_.image_alt AS image_alt_16, b0_.image_title AS image_title_17, b0_.locale AS locale_18, b0_.position AS position_19, b0_.published AS published_20, b0_.entity_id AS entity_id_21 FROM bt_promo_bets b1_ INNER JOIN bt_promo_bets_origin b2_ ON b1_.id = b2_.promo_bets_id AND (b2_.origin = '62000') LEFT JOIN bt_promo_bets_translation b0_ ON b1_.id = b0_.entity_id WHERE (b1_.project_id = '0194ae0d-5b56-7acf-90b2-fb67913e9272' AND COALESCE(b0_.published, b1_.published) = 1) AND b1_.type = 'Top Match' AND ((b1_.start_date_time <= '2025-04-25 02:16:30' OR b1_.start_date_time IS NULL) AND (b1_.end_date_time > '2025-04-25 02:16:30' OR b1_.end_date_time IS NULL)) ORDER BY sclr_0 ASC;