Symfony Profiler

SELECT
  t0.score_logic AS score_logic_1,
  t0.rank_limit AS rank_limit_2,
  t0.prize_currency AS prize_currency_3,
  t0.prizes AS prizes_4,
  t0.theme AS theme_5,
  t0.max_rebuy_count AS max_rebuy_count_6,
  t0.rebuy_amount AS rebuy_amount_7,
  t0.start_date AS start_date_8,
  t0.end_date AS end_date_9,
  t0.crypto AS crypto_10,
  t0.id AS id_11,
  t0.created_at AS created_at_12,
  t0.partner_id AS partner_id_13,
  t0.type,
  t0.start_balance AS start_balance_14,
  t0.use_billing_account AS use_billing_account_15,
  t0.currency AS currency_16,
  t0.freerounds_count AS freerounds_count_17
FROM
  tournaments t0
WHERE
  t0.id = ?
  AND t0.type IN ('regular', 'freeround')

SELECT t0.score_logic AS score_logic_1, t0.rank_limit AS rank_limit_2, t0.prize_currency AS prize_currency_3, t0.prizes AS prizes_4, t0.theme AS theme_5, t0.max_rebuy_count AS max_rebuy_count_6, t0.rebuy_amount AS rebuy_amount_7, t0.start_date AS start_date_8, t0.end_date AS end_date_9, t0.crypto AS crypto_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.partner_id AS partner_id_13, t0.type, t0.start_balance AS start_balance_14, t0.use_billing_account AS use_billing_account_15, t0.currency AS currency_16, t0.freerounds_count AS freerounds_count_17 FROM tournaments t0 WHERE t0.id = '9' AND t0.type IN ('regular', 'freeround');

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  site_games s0_
  INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id
  INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id
  AND t1_.type IN ('regular', 'freeround')
  AND (t1_.id = ?)
  LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id
  LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id
WHERE
  (
    p3_.enabled = ?
    OR p4_.enabled = ?
  )
  AND s0_.enabled = ?

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM site_games s0_ INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id AND t1_.type IN ('regular', 'freeround') AND (t1_.id = 9) LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id WHERE (p3_.enabled = 1 OR p4_.enabled = 1) AND s0_.enabled = 1;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.slug AS slug_1
FROM
  site_games s0_
  INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id
  INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id
  AND t1_.type IN ('regular', 'freeround')
  AND (t1_.id = ?)
  LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id
  LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id
WHERE
  (
    p3_.enabled = ?
    OR p4_.enabled = ?
  )
  AND s0_.enabled = ?
ORDER BY
  s0_.slug ASC
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0, s0_.slug AS slug_1 FROM site_games s0_ INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id AND t1_.type IN ('regular', 'freeround') AND (t1_.id = 9) LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id WHERE (p3_.enabled = 1 OR p4_.enabled = 1) AND s0_.enabled = 1 ORDER BY s0_.slug ASC LIMIT 20;

SELECT
  s0_.id AS id_0,
  s0_.slug AS slug_1,
  s0_.image AS image_2,
  s0_.background_image AS background_image_3,
  s0_.position AS position_4,
  s0_.rank AS rank_5,
  s0_.enabled AS enabled_6,
  s0_.disabling_reason AS disabling_reason_7,
  s0_.demo_available AS demo_available_8,
  s0_.released_at AS released_at_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.category AS category_12,
  s0_.country_list AS country_list_13,
  s0_.country_list_type AS country_list_type_14,
  s0_.desktop_provider_game_projection_id AS desktop_provider_game_projection_id_15,
  s0_.mobile_provider_game_projection_id AS mobile_provider_game_projection_id_16
FROM
  site_games s0_
  INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id
  INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id
  AND t1_.type IN ('regular', 'freeround')
  AND (t1_.id = ?)
  LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id
  LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id
WHERE
  (
    p3_.enabled = ?
    OR p4_.enabled = ?
  )
  AND s0_.enabled = ?
  AND s0_.id IN (?, ?)
ORDER BY
  s0_.slug ASC

SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.image AS image_2, s0_.background_image AS background_image_3, s0_.position AS position_4, s0_.rank AS rank_5, s0_.enabled AS enabled_6, s0_.disabling_reason AS disabling_reason_7, s0_.demo_available AS demo_available_8, s0_.released_at AS released_at_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.category AS category_12, s0_.country_list AS country_list_13, s0_.country_list_type AS country_list_type_14, s0_.desktop_provider_game_projection_id AS desktop_provider_game_projection_id_15, s0_.mobile_provider_game_projection_id AS mobile_provider_game_projection_id_16 FROM site_games s0_ INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id AND t1_.type IN ('regular', 'freeround') AND (t1_.id = 9) LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id WHERE (p3_.enabled = 1 OR p4_.enabled = 1) AND s0_.enabled = 1 AND s0_.id IN (102, 101) ORDER BY s0_.slug ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2
FROM
  tags t0
  INNER JOIN site_games_tags ON t0.id = site_games_tags.tag_id
WHERE
  site_games_tags.site_game_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2 FROM tags t0 INNER JOIN site_games_tags ON t0.id = site_games_tags.tag_id WHERE site_games_tags.site_game_id = 102;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2
FROM
  tags t0
  INNER JOIN site_games_tags ON t0.id = site_games_tags.tag_id
WHERE
  site_games_tags.site_game_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2 FROM tags t0 INNER JOIN site_games_tags ON t0.id = site_games_tags.tag_id WHERE site_games_tags.site_game_id = 101;

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
  site_game_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 site_game_translations t0 WHERE t0.translatable_id = 102;

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.title AS title_3,
  t0.enabled AS enabled_4,
  t0.image AS image_5,
  t0.demo_available AS demo_available_6,
  t0.freespins_available AS freespins_available_7,
  t0.system AS system_8,
  t0.vendor AS vendor_9,
  t0.aspect_ratio AS aspect_ratio_10,
  t0.is_mobile AS is_mobile_11,
  t0.is_desktop AS is_desktop_12,
  t0.supports_funny AS supports_funny_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.category AS category_16
FROM
  provider_game_projections t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = 2;

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
  site_game_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 site_game_translations t0 WHERE t0.translatable_id = 101;

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.title AS title_3,
  t0.enabled AS enabled_4,
  t0.image AS image_5,
  t0.demo_available AS demo_available_6,
  t0.freespins_available AS freespins_available_7,
  t0.system AS system_8,
  t0.vendor AS vendor_9,
  t0.aspect_ratio AS aspect_ratio_10,
  t0.is_mobile AS is_mobile_11,
  t0.is_desktop AS is_desktop_12,
  t0.supports_funny AS supports_funny_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.category AS category_16
FROM
  provider_game_projections t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = 1;

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
  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
  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_0,
  t0_.score AS score_1,
  t0_.score_data AS score_data_2,
  t0_.prize AS prize_3,
  t0_.token AS token_4,
  t0_.rebuy_count AS rebuy_count_5,
  t0_.reset_at AS reset_at_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8,
  t0_.tournament_id AS tournament_id_9,
  t0_.account_id AS account_id_10,
  t0_.user_id AS user_id_11
FROM
  tournament_sessions t0_
WHERE
  t0_.tournament_id = ?
ORDER BY
  t0_.score DESC
LIMIT
  4

SELECT t0_.id AS id_0, t0_.score AS score_1, t0_.score_data AS score_data_2, t0_.prize AS prize_3, t0_.token AS token_4, t0_.rebuy_count AS rebuy_count_5, t0_.reset_at AS reset_at_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8, t0_.tournament_id AS tournament_id_9, t0_.account_id AS account_id_10, t0_.user_id AS user_id_11 FROM tournament_sessions t0_ WHERE t0_.tournament_id = 9 ORDER BY t0_.score DESC LIMIT 4;

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 = 'el' 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';