Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.image AS image_3,
  t0.background_image AS background_image_4,
  t0.position AS position_5,
  t0.rank AS rank_6,
  t0.enabled AS enabled_7,
  t0.disabling_reason AS disabling_reason_8,
  t0.demo_available AS demo_available_9,
  t0.released_at AS released_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.category AS category_13,
  t0.country_list AS country_list_14,
  t0.country_list_type AS country_list_type_15,
  t0.desktop_provider_game_projection_id AS desktop_provider_game_projection_id_16,
  t0.mobile_provider_game_projection_id AS mobile_provider_game_projection_id_17
FROM
  site_games t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.background_image AS background_image_4, t0.position AS position_5, t0.rank AS rank_6, t0.enabled AS enabled_7, t0.disabling_reason AS disabling_reason_8, t0.demo_available AS demo_available_9, t0.released_at AS released_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category AS category_13, t0.country_list AS country_list_14, t0.country_list_type AS country_list_type_15, t0.desktop_provider_game_projection_id AS desktop_provider_game_projection_id_16, t0.mobile_provider_game_projection_id AS mobile_provider_game_projection_id_17 FROM site_games t0 WHERE t0.slug = '70-site-game' LIMIT 1;

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 = 70;

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 = 72;

SELECT
  g0_.id AS id_0,
  g0_.country_list AS country_list_1,
  g0_.country_list_type AS country_list_type_2,
  g0_.created_at AS created_at_3,
  g0_.updated_at AS updated_at_4,
  g0_.tag_id AS tag_id_5
FROM
  game_restrictions g0_
WHERE
  g0_.tag_id IN (?, ?)

SELECT g0_.id AS id_0, g0_.country_list AS country_list_1, g0_.country_list_type AS country_list_type_2, g0_.created_at AS created_at_3, g0_.updated_at AS updated_at_4, g0_.tag_id AS tag_id_5 FROM game_restrictions g0_ WHERE g0_.tag_id IN (44, 58);

SELECT
  t0.id AS id_19,
  t0.title AS title_20,
  t0.enabled AS enabled_21,
  t0.is_mobile AS is_mobile_22,
  t0.is_desktop AS is_desktop_23,
  t0.aspect_ratio AS aspect_ratio_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.image AS image_27,
  t0.image_url AS image_url_28,
  t0.category AS category_29,
  t0.vendor,
  t1.external_id AS external_id_30,
  t1.active AS active_31,
  t2.external_id AS external_id_32,
  t2.active AS active_33,
  t3.external_id AS external_id_34,
  t3.active AS active_35,
  t4.external_id AS external_id_36,
  t4.active AS active_37,
  t4.is_freespins_available AS is_freespins_available_38,
  t4.minimum_bets AS minimum_bets_39,
  t5.external_id AS external_id_40,
  t5.active AS active_41,
  t5.system AS system_42,
  t5.freeround_bets AS freeround_bets_43,
  t5.game_type AS game_type_44,
  t5.lobby AS lobby_45,
  t6.external_id AS external_id_46,
  t6.short_external_id AS short_external_id_47,
  t6.active AS active_48,
  t7.external_id AS external_id_49,
  t7.active AS active_50,
  t7.game_type AS game_type_51,
  t8.external_id AS external_id_52,
  t8.active AS active_53,
  t8.system AS system_54,
  t8.game_type AS game_type_55,
  t9.external_id AS external_id_56,
  t9.active AS active_57,
  t9.freespins_available AS freespins_available_58,
  t10.external_id AS external_id_59,
  t10.active AS active_60,
  t10.demo_available AS demo_available_61,
  t10.freespins_available AS freespins_available_62,
  t11.external_id AS external_id_63,
  t11.active AS active_64,
  t12.external_id AS external_id_65,
  t12.active AS active_66,
  t12.system AS system_67,
  t12.game_type AS game_type_68,
  t13.external_id AS external_id_69,
  t13.active AS active_70,
  t13.system AS system_71,
  t13.game_type AS game_type_72,
  t13.freespins_available AS freespins_available_73,
  t14.external_id AS external_id_74,
  t14.active AS active_75,
  t14.system AS system_76,
  t14.game_type AS game_type_77,
  t14.demo_available AS demo_available_78,
  t15.external_id AS external_id_79,
  t15.active AS active_80,
  t15.system AS system_81,
  t15.game_type AS game_type_82,
  t16.external_id AS external_id_83,
  t16.active AS active_84,
  t17.external_id AS external_id_85,
  t17.active AS active_86,
  t18.external_id AS external_id_87,
  t18.active AS active_88,
  t18.system AS system_89
FROM
  provider_games t0
  LEFT JOIN dummy_provider_games t1 ON t0.id = t1.id
  LEFT JOIN belatra_provider_games t2 ON t0.id = t2.id
  LEFT JOIN egt_provider_games t3 ON t0.id = t3.id
  LEFT JOIN endorphina_provider_games t4 ON t0.id = t4.id
  LEFT JOIN evolution_provider_games t5 ON t0.id = t5.id
  LEFT JOIN igrosoft_provider_games t6 ON t0.id = t6.id
  LEFT JOIN netent_provider_games t7 ON t0.id = t7.id
  LEFT JOIN oryx_provider_games t8 ON t0.id = t8.id
  LEFT JOIN pgsoft_provider_games t9 ON t0.id = t9.id
  LEFT JOIN pragmatic_provider_games t10 ON t0.id = t10.id
  LEFT JOIN push_provider_games t11 ON t0.id = t11.id
  LEFT JOIN relax_provider_games t12 ON t0.id = t12.id
  LEFT JOIN slotegrator_provider_games t13 ON t0.id = t13.id
  LEFT JOIN softgamings_provider_games t14 ON t0.id = t14.id
  LEFT JOIN softswiss_provider_games t15 ON t0.id = t15.id
  LEFT JOIN turbo_provider_games t16 ON t0.id = t16.id
  LEFT JOIN vavada_provider_games t17 ON t0.id = t17.id
  LEFT JOIN vivo_provider_games t18 ON t0.id = t18.id
WHERE
  t0.id = ?

SELECT t0.id AS id_19, t0.title AS title_20, t0.enabled AS enabled_21, t0.is_mobile AS is_mobile_22, t0.is_desktop AS is_desktop_23, t0.aspect_ratio AS aspect_ratio_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.image AS image_27, t0.image_url AS image_url_28, t0.category AS category_29, t0.vendor, t1.external_id AS external_id_30, t1.active AS active_31, t2.external_id AS external_id_32, t2.active AS active_33, t3.external_id AS external_id_34, t3.active AS active_35, t4.external_id AS external_id_36, t4.active AS active_37, t4.is_freespins_available AS is_freespins_available_38, t4.minimum_bets AS minimum_bets_39, t5.external_id AS external_id_40, t5.active AS active_41, t5.system AS system_42, t5.freeround_bets AS freeround_bets_43, t5.game_type AS game_type_44, t5.lobby AS lobby_45, t6.external_id AS external_id_46, t6.short_external_id AS short_external_id_47, t6.active AS active_48, t7.external_id AS external_id_49, t7.active AS active_50, t7.game_type AS game_type_51, t8.external_id AS external_id_52, t8.active AS active_53, t8.system AS system_54, t8.game_type AS game_type_55, t9.external_id AS external_id_56, t9.active AS active_57, t9.freespins_available AS freespins_available_58, t10.external_id AS external_id_59, t10.active AS active_60, t10.demo_available AS demo_available_61, t10.freespins_available AS freespins_available_62, t11.external_id AS external_id_63, t11.active AS active_64, t12.external_id AS external_id_65, t12.active AS active_66, t12.system AS system_67, t12.game_type AS game_type_68, t13.external_id AS external_id_69, t13.active AS active_70, t13.system AS system_71, t13.game_type AS game_type_72, t13.freespins_available AS freespins_available_73, t14.external_id AS external_id_74, t14.active AS active_75, t14.system AS system_76, t14.game_type AS game_type_77, t14.demo_available AS demo_available_78, t15.external_id AS external_id_79, t15.active AS active_80, t15.system AS system_81, t15.game_type AS game_type_82, t16.external_id AS external_id_83, t16.active AS active_84, t17.external_id AS external_id_85, t17.active AS active_86, t18.external_id AS external_id_87, t18.active AS active_88, t18.system AS system_89 FROM provider_games t0 LEFT JOIN dummy_provider_games t1 ON t0.id = t1.id LEFT JOIN belatra_provider_games t2 ON t0.id = t2.id LEFT JOIN egt_provider_games t3 ON t0.id = t3.id LEFT JOIN endorphina_provider_games t4 ON t0.id = t4.id LEFT JOIN evolution_provider_games t5 ON t0.id = t5.id LEFT JOIN igrosoft_provider_games t6 ON t0.id = t6.id LEFT JOIN netent_provider_games t7 ON t0.id = t7.id LEFT JOIN oryx_provider_games t8 ON t0.id = t8.id LEFT JOIN pgsoft_provider_games t9 ON t0.id = t9.id LEFT JOIN pragmatic_provider_games t10 ON t0.id = t10.id LEFT JOIN push_provider_games t11 ON t0.id = t11.id LEFT JOIN relax_provider_games t12 ON t0.id = t12.id LEFT JOIN slotegrator_provider_games t13 ON t0.id = t13.id LEFT JOIN softgamings_provider_games t14 ON t0.id = t14.id LEFT JOIN softswiss_provider_games t15 ON t0.id = t15.id LEFT JOIN turbo_provider_games t16 ON t0.id = t16.id LEFT JOIN vavada_provider_games t17 ON t0.id = t17.id LEFT JOIN vivo_provider_games t18 ON t0.id = t18.id WHERE t0.id = -70;

SELECT
  1 AS sclr_0
FROM
  game_provider_fees g0_
WHERE
  g0_.vendor = ?
  AND g0_.activated_at <= ?
LIMIT
  1

SELECT 1 AS sclr_0 FROM game_provider_fees g0_ WHERE g0_.vendor = 'dummy' AND g0_.activated_at <= '2025-10-28 03:51:23' LIMIT 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
  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 = 70;