Symfony Profiler

SELECT
  t0_.score_logic AS score_logic_0,
  t0_.rank_limit AS rank_limit_1,
  t0_.prize_currency AS prize_currency_2,
  t0_.prizes AS prizes_3,
  t0_.theme AS theme_4,
  t0_.max_rebuy_count AS max_rebuy_count_5,
  t0_.rebuy_amount AS rebuy_amount_6,
  t0_.start_date AS start_date_7,
  t0_.end_date AS end_date_8,
  t0_.crypto AS crypto_9,
  t0_.id AS id_10,
  t0_.created_at AS created_at_11,
  t0_.start_balance AS start_balance_12,
  t0_.use_billing_account AS use_billing_account_13,
  t0_.currency AS currency_14,
  t0_.freerounds_count AS freerounds_count_15,
  t0_.type AS type_16,
  t0_.partner_id AS partner_id_17
FROM
  tournaments t0_
WHERE
  (t0_.end_date > ?)
  AND t0_.type IN ('regular', 'freeround')
ORDER BY
  t0_.start_date ASC

SELECT t0_.score_logic AS score_logic_0, t0_.rank_limit AS rank_limit_1, t0_.prize_currency AS prize_currency_2, t0_.prizes AS prizes_3, t0_.theme AS theme_4, t0_.max_rebuy_count AS max_rebuy_count_5, t0_.rebuy_amount AS rebuy_amount_6, t0_.start_date AS start_date_7, t0_.end_date AS end_date_8, t0_.crypto AS crypto_9, t0_.id AS id_10, t0_.created_at AS created_at_11, t0_.start_balance AS start_balance_12, t0_.use_billing_account AS use_billing_account_13, t0_.currency AS currency_14, t0_.freerounds_count AS freerounds_count_15, t0_.type AS type_16, t0_.partner_id AS partner_id_17 FROM tournaments t0_ WHERE (t0_.end_date > '2025-10-28 01:04:08') AND t0_.type IN ('regular', 'freeround') ORDER BY t0_.start_date ASC;

SELECT
  j0_.id AS id_0,
  j0_.type AS type_1,
  j0_.pay_percent AS pay_percent_2,
  j0_.probability AS probability_3,
  j0_.probability_by_rounds AS probability_by_rounds_4,
  j0_.prize_fund_per_day AS prize_fund_per_day_5,
  j0_.min_win_amount AS min_win_amount_6,
  j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7,
  j0_.active AS active_8,
  j0_.created_at AS created_at_9
FROM
  jackpots j0_
WHERE
  j0_.active = true

SELECT j0_.id AS id_0, j0_.type AS type_1, j0_.pay_percent AS pay_percent_2, j0_.probability AS probability_3, j0_.probability_by_rounds AS probability_by_rounds_4, j0_.prize_fund_per_day AS prize_fund_per_day_5, j0_.min_win_amount AS min_win_amount_6, j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7, j0_.active AS active_8, j0_.created_at AS created_at_9 FROM jackpots j0_ WHERE j0_.active = true;

SELECT
  j0_.id AS id_0,
  j0_.amount AS amount_1,
  j0_.currency AS currency_2,
  j0_.jackpot_amount AS jackpot_amount_3,
  j0_.jackpot_fund AS jackpot_fund_4,
  j0_.jackpot_currency AS jackpot_currency_5,
  j0_.created_at AS created_at_6,
  j0_.user_id AS user_id_7,
  j0_.jackpot_id AS jackpot_id_8,
  j0_.debit_transaction_id AS debit_transaction_id_9
FROM
  jackpot_wins j0_
  INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id
WHERE
  j1_.type = ?
ORDER BY
  j0_.created_at DESC
LIMIT
  1

SELECT j0_.id AS id_0, j0_.amount AS amount_1, j0_.currency AS currency_2, j0_.jackpot_amount AS jackpot_amount_3, j0_.jackpot_fund AS jackpot_fund_4, j0_.jackpot_currency AS jackpot_currency_5, j0_.created_at AS created_at_6, j0_.user_id AS user_id_7, j0_.jackpot_id AS jackpot_id_8, j0_.debit_transaction_id AS debit_transaction_id_9 FROM jackpot_wins j0_ INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id WHERE j1_.type = 'mega' ORDER BY j0_.created_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.read_at AS read_at_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4,
  t0.jackpot_win_id AS jackpot_win_id_5,
  t0.type
FROM
  notifications t0
WHERE
  t0.jackpot_win_id = ?
  AND t0.type IN ('jackpot_win')

SELECT t0.id AS id_1, t0.read_at AS read_at_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.jackpot_win_id AS jackpot_win_id_5, t0.type FROM notifications t0 WHERE t0.jackpot_win_id = 1 AND t0.type IN ('jackpot_win');

SELECT
  j0_.id AS id_0,
  j0_.type AS type_1,
  j0_.pay_percent AS pay_percent_2,
  j0_.probability AS probability_3,
  j0_.probability_by_rounds AS probability_by_rounds_4,
  j0_.prize_fund_per_day AS prize_fund_per_day_5,
  j0_.min_win_amount AS min_win_amount_6,
  j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7,
  j0_.active AS active_8,
  j0_.created_at AS created_at_9
FROM
  jackpots j0_
WHERE
  j0_.created_at >= ?
  AND j0_.type = ?
ORDER BY
  j0_.created_at ASC

SELECT j0_.id AS id_0, j0_.type AS type_1, j0_.pay_percent AS pay_percent_2, j0_.probability AS probability_3, j0_.probability_by_rounds AS probability_by_rounds_4, j0_.prize_fund_per_day AS prize_fund_per_day_5, j0_.min_win_amount AS min_win_amount_6, j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7, j0_.active AS active_8, j0_.created_at AS created_at_9 FROM jackpots j0_ WHERE j0_.created_at >= '2025-09-17 15:44:51' AND j0_.type = 'mega' ORDER BY j0_.created_at ASC;

SELECT
  j0_.id AS id_0,
  j0_.amount AS amount_1,
  j0_.currency AS currency_2,
  j0_.jackpot_amount AS jackpot_amount_3,
  j0_.jackpot_fund AS jackpot_fund_4,
  j0_.jackpot_currency AS jackpot_currency_5,
  j0_.created_at AS created_at_6,
  j0_.user_id AS user_id_7,
  j0_.jackpot_id AS jackpot_id_8,
  j0_.debit_transaction_id AS debit_transaction_id_9
FROM
  jackpot_wins j0_
  INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id
WHERE
  j1_.type = ?
ORDER BY
  j0_.created_at DESC
LIMIT
  1

SELECT j0_.id AS id_0, j0_.amount AS amount_1, j0_.currency AS currency_2, j0_.jackpot_amount AS jackpot_amount_3, j0_.jackpot_fund AS jackpot_fund_4, j0_.jackpot_currency AS jackpot_currency_5, j0_.created_at AS created_at_6, j0_.user_id AS user_id_7, j0_.jackpot_id AS jackpot_id_8, j0_.debit_transaction_id AS debit_transaction_id_9 FROM jackpot_wins j0_ INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id WHERE j1_.type = 'major' ORDER BY j0_.created_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.read_at AS read_at_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4,
  t0.jackpot_win_id AS jackpot_win_id_5,
  t0.type
FROM
  notifications t0
WHERE
  t0.jackpot_win_id = ?
  AND t0.type IN ('jackpot_win')

SELECT t0.id AS id_1, t0.read_at AS read_at_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.jackpot_win_id AS jackpot_win_id_5, t0.type FROM notifications t0 WHERE t0.jackpot_win_id = 2 AND t0.type IN ('jackpot_win');

SELECT
  j0_.id AS id_0,
  j0_.type AS type_1,
  j0_.pay_percent AS pay_percent_2,
  j0_.probability AS probability_3,
  j0_.probability_by_rounds AS probability_by_rounds_4,
  j0_.prize_fund_per_day AS prize_fund_per_day_5,
  j0_.min_win_amount AS min_win_amount_6,
  j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7,
  j0_.active AS active_8,
  j0_.created_at AS created_at_9
FROM
  jackpots j0_
WHERE
  j0_.created_at >= ?
  AND j0_.type = ?
ORDER BY
  j0_.created_at ASC

SELECT j0_.id AS id_0, j0_.type AS type_1, j0_.pay_percent AS pay_percent_2, j0_.probability AS probability_3, j0_.probability_by_rounds AS probability_by_rounds_4, j0_.prize_fund_per_day AS prize_fund_per_day_5, j0_.min_win_amount AS min_win_amount_6, j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7, j0_.active AS active_8, j0_.created_at AS created_at_9 FROM jackpots j0_ WHERE j0_.created_at >= '2025-10-14 15:44:51' AND j0_.type = 'major' ORDER BY j0_.created_at ASC;

SELECT
  j0_.id AS id_0,
  j0_.amount AS amount_1,
  j0_.currency AS currency_2,
  j0_.jackpot_amount AS jackpot_amount_3,
  j0_.jackpot_fund AS jackpot_fund_4,
  j0_.jackpot_currency AS jackpot_currency_5,
  j0_.created_at AS created_at_6,
  j0_.user_id AS user_id_7,
  j0_.jackpot_id AS jackpot_id_8,
  j0_.debit_transaction_id AS debit_transaction_id_9
FROM
  jackpot_wins j0_
  INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id
WHERE
  j1_.type = ?
ORDER BY
  j0_.created_at DESC
LIMIT
  1

SELECT j0_.id AS id_0, j0_.amount AS amount_1, j0_.currency AS currency_2, j0_.jackpot_amount AS jackpot_amount_3, j0_.jackpot_fund AS jackpot_fund_4, j0_.jackpot_currency AS jackpot_currency_5, j0_.created_at AS created_at_6, j0_.user_id AS user_id_7, j0_.jackpot_id AS jackpot_id_8, j0_.debit_transaction_id AS debit_transaction_id_9 FROM jackpot_wins j0_ INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id WHERE j1_.type = 'minor' ORDER BY j0_.created_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.read_at AS read_at_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4,
  t0.jackpot_win_id AS jackpot_win_id_5,
  t0.type
FROM
  notifications t0
WHERE
  t0.jackpot_win_id = ?
  AND t0.type IN ('jackpot_win')

SELECT t0.id AS id_1, t0.read_at AS read_at_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.jackpot_win_id AS jackpot_win_id_5, t0.type FROM notifications t0 WHERE t0.jackpot_win_id = 3 AND t0.type IN ('jackpot_win');

SELECT
  j0_.id AS id_0,
  j0_.type AS type_1,
  j0_.pay_percent AS pay_percent_2,
  j0_.probability AS probability_3,
  j0_.probability_by_rounds AS probability_by_rounds_4,
  j0_.prize_fund_per_day AS prize_fund_per_day_5,
  j0_.min_win_amount AS min_win_amount_6,
  j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7,
  j0_.active AS active_8,
  j0_.created_at AS created_at_9
FROM
  jackpots j0_
WHERE
  j0_.created_at >= ?
  AND j0_.type = ?
ORDER BY
  j0_.created_at ASC

SELECT j0_.id AS id_0, j0_.type AS type_1, j0_.pay_percent AS pay_percent_2, j0_.probability AS probability_3, j0_.probability_by_rounds AS probability_by_rounds_4, j0_.prize_fund_per_day AS prize_fund_per_day_5, j0_.min_win_amount AS min_win_amount_6, j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7, j0_.active AS active_8, j0_.created_at AS created_at_9 FROM jackpots j0_ WHERE j0_.created_at >= '2025-10-16 15:44:51' AND j0_.type = 'minor' ORDER BY j0_.created_at ASC;

SELECT
  s0_.id AS id_0,
  s0_.provider AS provider_1,
  s0_.active AS active_2,
  s0_.created_at AS created_at_3
FROM
  social_providers s0_
WHERE
  s0_.active = ?

SELECT s0_.id AS id_0, s0_.provider AS provider_1, s0_.active AS active_2, s0_.created_at AS created_at_3 FROM social_providers s0_ WHERE s0_.active = 1;

SELECT
  b0_.id AS id_0,
  b0_.enabled AS enabled_1,
  b0_.name AS name_2,
  b0_.visibility AS visibility_3,
  b0_.country_list AS country_list_4,
  b0_.position AS position_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7
FROM
  banners b0_
WHERE
  b0_.enabled = true
ORDER BY
  b0_.position ASC

SELECT b0_.id AS id_0, b0_.enabled AS enabled_1, b0_.name AS name_2, b0_.visibility AS visibility_3, b0_.country_list AS country_list_4, b0_.position AS position_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7 FROM banners b0_ WHERE b0_.enabled = true ORDER BY b0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  tournament_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM tournament_translations t0 WHERE t0.translatable_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  tournament_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM tournament_translations t0 WHERE t0.translatable_id = 5;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  tournament_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM tournament_translations t0 WHERE t0.translatable_id = 6;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  tournament_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM tournament_translations t0 WHERE t0.translatable_id = 9;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  tournament_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM tournament_translations t0 WHERE t0.translatable_id = 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  tournament_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM tournament_translations t0 WHERE t0.translatable_id = 8;

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.locale AS locale_2,
  s0_.url AS url_3
FROM
  social_network_links s0_
WHERE
  s0_.locale = ?
ORDER BY
  s0_.type ASC

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3 FROM social_network_links s0_ WHERE s0_.locale = 'en' ORDER BY s0_.type ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2
FROM
  parameters p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = 'main_host_company_name';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2
FROM
  parameters p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = 'main_host_company_registered_number';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2
FROM
  parameters p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = 'main_host_company_office_address';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2
FROM
  parameters p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = 'main_host_company_post_card';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2
FROM
  parameters p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = 'main_host_company_city';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2
FROM
  parameters p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = 'main_host_company_country';