Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.round_num AS round_num_1,
  s0_.display_pos1 AS display_pos1_2,
  s0_.user_id1 AS user_id1_3,
  s0_.username1 AS username1_4,
  s0_.display_pos2 AS display_pos2_5,
  s0_.user_id2 AS user_id2_6,
  s0_.username2 AS username2_7,
  s0_.game1user1points AS game1user1points_8,
  s0_.game1finished AS game1finished_9,
  s0_.game2user1points AS game2user1points_10,
  s0_.game2finished AS game2finished_11,
  s0_.total_points_user1 AS total_points_user1_12,
  s0_.game1user2points AS game1user2points_13,
  s0_.game2user2points AS game2user2points_14,
  s0_.total_points_user2 AS total_points_user2_15,
  s0_.game1user1timed_out AS game1user1timed_out_16,
  s0_.game1user2timed_out AS game1user2timed_out_17,
  s0_.game2user1timed_out AS game2user1timed_out_18,
  s0_.game2user2timed_out AS game2user2timed_out_19,
  s0_.order_asc AS order_asc_20,
  s0_.winning_side AS winning_side_21
FROM
  slith_tournamentrounddraws s0_
  LEFT JOIN slith_tournamentscores s1_ ON (
    s1_.tournament_id = s0_.tournament_id
    AND s1_.user_id = s0_.user_id1
  )
WHERE
  s0_.tournament_id = ?
ORDER BY
  s0_.round_num DESC,
  s1_.rank ASC

SELECT s0_.id AS id_0, s0_.round_num AS round_num_1, s0_.display_pos1 AS display_pos1_2, s0_.user_id1 AS user_id1_3, s0_.username1 AS username1_4, s0_.display_pos2 AS display_pos2_5, s0_.user_id2 AS user_id2_6, s0_.username2 AS username2_7, s0_.game1user1points AS game1user1points_8, s0_.game1finished AS game1finished_9, s0_.game2user1points AS game2user1points_10, s0_.game2finished AS game2finished_11, s0_.total_points_user1 AS total_points_user1_12, s0_.game1user2points AS game1user2points_13, s0_.game2user2points AS game2user2points_14, s0_.total_points_user2 AS total_points_user2_15, s0_.game1user1timed_out AS game1user1timed_out_16, s0_.game1user2timed_out AS game1user2timed_out_17, s0_.game2user1timed_out AS game2user1timed_out_18, s0_.game2user2timed_out AS game2user2timed_out_19, s0_.order_asc AS order_asc_20, s0_.winning_side AS winning_side_21 FROM slith_tournamentrounddraws s0_ LEFT JOIN slith_tournamentscores s1_ ON (s1_.tournament_id = s0_.tournament_id AND s1_.user_id = s0_.user_id1) WHERE s0_.tournament_id = 1299 ORDER BY s0_.round_num DESC, s1_.rank ASC;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.round_num AS round_num_2,
  s0_.start_date_time AS start_date_time_3,
  s0_.finish_date_time AS finish_date_time_4,
  s0_.status AS status_5,
  s0_.required_pbemgame_id AS required_pbemgame_id_6,
  s0_.tournament_id AS tournament_id_7
FROM
  slith_tournamentchallenge s0_
WHERE
  s0_.tournament_id = ?
ORDER BY
  s0_.round_num ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.round_num AS round_num_2, s0_.start_date_time AS start_date_time_3, s0_.finish_date_time AS finish_date_time_4, s0_.status AS status_5, s0_.required_pbemgame_id AS required_pbemgame_id_6, s0_.tournament_id AS tournament_id_7 FROM slith_tournamentchallenge s0_ WHERE s0_.tournament_id = 1299 ORDER BY s0_.round_num ASC;

SELECT
  t0.id AS id_1,
  t0.tournament_type AS tournament_type_2,
  t0.slug AS slug_3
FROM
  slith_tournamenttype t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.tournament_type AS tournament_type_2, t0.slug AS slug_3 FROM slith_tournamenttype t0 WHERE t0.id = 1;

SELECT
  s0_.id AS id_0,
  s0_.user_id AS user_id_1,
  s0_.rank AS rank_2,
  s0_.total_points AS total_points_3,
  s0_.username AS username_4,
  s0_.tournament_id AS tournament_id_5
FROM
  slith_tournamentscores s0_
  INNER JOIN slith_tournamentroundscoresgamepoints s1_ ON s0_.id = s1_.tournament_scores_id
WHERE
  s0_.tournament_id = ?
  AND s1_.finished = 0

SELECT s0_.id AS id_0, s0_.user_id AS user_id_1, s0_.rank AS rank_2, s0_.total_points AS total_points_3, s0_.username AS username_4, s0_.tournament_id AS tournament_id_5 FROM slith_tournamentscores s0_ INNER JOIN slith_tournamentroundscoresgamepoints s1_ ON s0_.id = s1_.tournament_scores_id WHERE s0_.tournament_id = 1299 AND s1_.finished = 0;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.valid_from AS valid_from_3,
  s0_.valid_until AS valid_until_4,
  s0_.left_image_path AS left_image_path_5,
  s0_.right_image_path AS right_image_path_6,
  s0_.status_id AS status_id_7
FROM
  slith_skin s0_
  INNER JOIN slith_skin_website s2_ ON s0_.id = s2_.slith_skin_id
  INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id
WHERE
  s1_.id = ?
  AND s0_.status_id IN (?)
  AND (
    s0_.valid_from IS NULL
    OR s0_.valid_from <= ?
  )
  AND (
    s0_.valid_until IS NULL
    OR s0_.valid_until >= ?
  )
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.valid_from AS valid_from_3, s0_.valid_until AS valid_until_4, s0_.left_image_path AS left_image_path_5, s0_.right_image_path AS right_image_path_6, s0_.status_id AS status_id_7 FROM slith_skin s0_ INNER JOIN slith_skin_website s2_ ON s0_.id = s2_.slith_skin_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = 2 AND s0_.status_id IN (2) AND (s0_.valid_from IS NULL OR s0_.valid_from <= '2026-02-25 04:33:21') AND (s0_.valid_until IS NULL OR s0_.valid_until >= '2026-02-25 04:33:21') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.valid_from_time AS valid_from_time_4,
  t0.valid_until_time AS valid_until_time_5,
  t0.discount_percent AS discount_percent_6,
  t0.is_auto_add_to_shopping_cart AS is_auto_add_to_shopping_cart_7,
  t0.status_id AS status_id_8
FROM
  slith_crosssale t0
  INNER JOIN slith_crosssale_slave_product ON t0.id = slith_crosssale_slave_product.slith_crosssale_id
WHERE
  slith_crosssale_slave_product.slith_product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.valid_from_time AS valid_from_time_4, t0.valid_until_time AS valid_until_time_5, t0.discount_percent AS discount_percent_6, t0.is_auto_add_to_shopping_cart AS is_auto_add_to_shopping_cart_7, t0.status_id AS status_id_8 FROM slith_crosssale t0 INNER JOIN slith_crosssale_slave_product ON t0.id = slith_crosssale_slave_product.slith_crosssale_id WHERE slith_crosssale_slave_product.slith_product_id = 389;

SELECT
  t0.id AS id_1,
  t0.pbem_server AS pbem_server_2,
  t0.slug AS slug_3,
  t0.url AS url_4,
  t0.is_live_server AS is_live_server_5
FROM
  slith_pbemserver t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.pbem_server AS pbem_server_2, t0.slug AS slug_3, t0.url AS url_4, t0.is_live_server AS is_live_server_5 FROM slith_pbemserver t0 WHERE t0.id = 5;

SELECT
  round_num,
  points
FROM
  slith_tournamentroundscoresgamepoints AS GP
  INNER JOIN slith_tournamentscores AS TS ON TS.id = GP.tournament_scores_id
WHERE
  TS.tournament_id = 1299
  AND GP.round_num = 3
GROUP BY
  round_num,
  points
ORDER BY
  CAST(points AS SIGNED) DESC
LIMIT
  3

SELECT round_num, points
                FROM slith_tournamentroundscoresgamepoints AS GP
                INNER JOIN slith_tournamentscores AS TS ON TS.id = GP.tournament_scores_id
                WHERE TS.tournament_id = 1299
                AND GP.round_num = 3
                GROUP BY round_num, points
                ORDER BY CAST(points AS SIGNED) DESC
                LIMIT 3 
            ;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.domain_name AS domain_name_3,
  t0.old_website_id AS old_website_id_4,
  t0.slug AS slug_5,
  t0.google_analytics_tag AS google_analytics_tag_6,
  t0.facebook_pixel_id AS facebook_pixel_id_7,
  t0.favicon AS favicon_8,
  t0.youtube_channel_id AS youtube_channel_id_9,
  t0.twitch_channel_name AS twitch_channel_name_10,
  t0.smtp_ip AS smtp_ip_11,
  t0.smtp_user AS smtp_user_12,
  t0.smtp_password AS smtp_password_13,
  t0.email_address AS email_address_14,
  t0.re_captcha_key AS re_captcha_key_15,
  t0.forum_url AS forum_url_16,
  t0.re_captcha_secret_key AS re_captcha_secret_key_17,
  t0.logo_file_path AS logo_file_path_18,
  t0.smtp_port AS smtp_port_19,
  t0.facebook_username AS facebook_username_20,
  t0.discord_username AS discord_username_21,
  t0.twitter_handle AS twitter_handle_22,
  t0.instagram_username AS instagram_username_23,
  t0.youtube_username AS youtube_username_24,
  t0.teads_pixel_id AS teads_pixel_id_25,
  t0.is_subscribe_discount_coupons_available AS is_subscribe_discount_coupons_available_26,
  t0.reddit_pixel_id AS reddit_pixel_id_27,
  t0.is_forum_badge_capable AS is_forum_badge_capable_28,
  t0.forum_badge_update_endpoint AS forum_badge_update_endpoint_29,
  t0.support_email_address AS support_email_address_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.newsletter_id AS newsletter_id_34,
  t31.newsletter_provider_id AS newsletter_provider_id_35,
  t31.status_id AS status_id_36,
  t31.website_id AS website_id_37,
  t0.forum_id AS forum_id_38
FROM
  slith_website t0
  LEFT JOIN slith_newsletter t31 ON t31.website_id = t0.id
WHERE
  t0.domain_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.domain_name AS domain_name_3, t0.old_website_id AS old_website_id_4, t0.slug AS slug_5, t0.google_analytics_tag AS google_analytics_tag_6, t0.facebook_pixel_id AS facebook_pixel_id_7, t0.favicon AS favicon_8, t0.youtube_channel_id AS youtube_channel_id_9, t0.twitch_channel_name AS twitch_channel_name_10, t0.smtp_ip AS smtp_ip_11, t0.smtp_user AS smtp_user_12, t0.smtp_password AS smtp_password_13, t0.email_address AS email_address_14, t0.re_captcha_key AS re_captcha_key_15, t0.forum_url AS forum_url_16, t0.re_captcha_secret_key AS re_captcha_secret_key_17, t0.logo_file_path AS logo_file_path_18, t0.smtp_port AS smtp_port_19, t0.facebook_username AS facebook_username_20, t0.discord_username AS discord_username_21, t0.twitter_handle AS twitter_handle_22, t0.instagram_username AS instagram_username_23, t0.youtube_username AS youtube_username_24, t0.teads_pixel_id AS teads_pixel_id_25, t0.is_subscribe_discount_coupons_available AS is_subscribe_discount_coupons_available_26, t0.reddit_pixel_id AS reddit_pixel_id_27, t0.is_forum_badge_capable AS is_forum_badge_capable_28, t0.forum_badge_update_endpoint AS forum_badge_update_endpoint_29, t0.support_email_address AS support_email_address_30, t31.id AS id_32, t31.name AS name_33, t31.newsletter_id AS newsletter_id_34, t31.newsletter_provider_id AS newsletter_provider_id_35, t31.status_id AS status_id_36, t31.website_id AS website_id_37, t0.forum_id AS forum_id_38 FROM slith_website t0 LEFT JOIN slith_newsletter t31 ON t31.website_id = t0.id WHERE t0.domain_name = 'www51.slitherine.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.introduction AS introduction_3,
  t0.old_game_id AS old_game_id_4,
  t0.slug AS slug_5,
  t0.earliest_release_date AS earliest_release_date_6,
  t0.latest_release_date AS latest_release_date_7,
  t0.smallest_price AS smallest_price_8,
  t0.old_game_url AS old_game_url_9,
  t0.is_release_date_visible AS is_release_date_visible_10,
  t0.google_conversion_code AS google_conversion_code_11,
  t12.id AS id_13,
  t12.description AS description_14,
  t12.features AS features_15,
  t12.requirements AS requirements_16,
  t12.game_data AS game_data_17,
  t12.discover_more_link AS discover_more_link_18,
  t12.historical_background AS historical_background_19,
  t12.lore AS lore_20,
  t12.product_id AS product_id_21,
  t22.id AS id_23,
  t22.discount_percent AS discount_percent_24,
  t22.product_id AS product_id_25,
  t26.id AS id_27,
  t26.min_players AS min_players_28,
  t26.max_players AS max_players_29,
  t26.product_id AS product_id_30,
  t26.genre_id AS genre_id_31,
  t26.timeline_id AS timeline_id_32,
  t26.theatre_id AS theatre_id_33,
  t26.difficulty_id AS difficulty_id_34,
  t26.play_style_id AS play_style_id_35,
  t26.artificial_intelligence_id AS artificial_intelligence_id_36,
  t26.game_editor_id AS game_editor_id_37,
  t26.turn_scale_id AS turn_scale_id_38,
  t26.multiplayer_id AS multiplayer_id_39,
  t26.unit_scale_id AS unit_scale_id_40,
  t41.id AS id_42,
  t41.portrait_image_name AS portrait_image_name_43,
  t41.landscape_image_name AS landscape_image_name_44,
  t41.logo_image_name AS logo_image_name_45,
  t41.icon_image_name AS icon_image_name_46,
  t41.landscape_image_name_external AS landscape_image_name_external_47,
  t41.product_id AS product_id_48,
  t0.status_id AS status_id_49,
  t0.family_id AS family_id_50,
  t0.product_type_id AS product_type_id_51,
  t52.id AS id_53,
  t52.steam_app_id AS steam_app_id_54,
  t52.external_forum_id AS external_forum_id_55,
  t52.forum_url AS forum_url_56,
  t52.is_serial_steam_key AS is_serial_steam_key_57,
  t52.is_preorder AS is_preorder_58,
  t52.is_indie AS is_indie_59,
  t52.gog_slug AS gog_slug_60,
  t52.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_61,
  t52.is_release_notification_sent AS is_release_notification_sent_62,
  t52.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_63,
  t52.steam_app_api_key AS steam_app_api_key_64,
  t52.gog_app_id AS gog_app_id_65,
  t52.gog_app_api_key AS gog_app_api_key_66,
  t52.discord_url AS discord_url_67,
  t52.epic_app_id AS epic_app_id_68,
  t52.epic_slug AS epic_slug_69,
  t52.epic_app_sandbox_id AS epic_app_sandbox_id_70,
  t52.training_url AS training_url_71,
  t52.folder_name AS folder_name_72,
  t52.has_custom_button AS has_custom_button_73,
  t52.custom_button_title AS custom_button_title_74,
  t52.custom_button_link AS custom_button_link_75,
  t52.product_id AS product_id_76,
  t52.developer_id AS developer_id_77,
  t52.life_cycle_id AS life_cycle_id_78,
  t52.forum_id AS forum_id_79,
  t80.id AS id_81,
  t80.name AS name_82,
  t80.web_apipublisher_key AS web_apipublisher_key_83,
  t80.background_image_name AS background_image_name_84,
  t80.leaderboard_title_id AS leaderboard_title_id_85,
  t80.secret_key AS secret_key_86,
  t80.product_id AS product_id_87,
  t80.status_id AS status_id_88,
  t80.leaderboard_provider_id AS leaderboard_provider_id_89,
  t0.otrsqueue_id AS otrsqueue_id_90,
  t91.id AS id_92,
  t91.is_license_file_revocable AS is_license_file_revocable_93,
  t91.is_price_calculator_available AS is_price_calculator_available_94,
  t91.pro_license_encryption_key AS pro_license_encryption_key_95,
  t91.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_96,
  t91.pro_license_generation_alert_email AS pro_license_generation_alert_email_97,
  t91.capabilities AS capabilities_98,
  t91.product_id AS product_id_99,
  t0.product_game_serial_pool_id AS product_game_serial_pool_id_100,
  t101.id AS id_102,
  t101.description AS description_103,
  t101.product_id AS product_id_104,
  t101.belongs_to_product_id AS belongs_to_product_id_105,
  t101.merchandise_type_id AS merchandise_type_id_106,
  t107.id AS id_108,
  t107.name AS name_109,
  t107.streak_key AS streak_key_110,
  t107.sort_order_index AS sort_order_index_111,
  t107.internal_product_id AS internal_product_id_112,
  t107.streak_field_product_type_id AS streak_field_product_type_id_113
FROM
  slith_product t0
  LEFT JOIN slith_gamecontent t12 ON t12.product_id = t0.id
  LEFT JOIN slith_productbundle t22 ON t22.product_id = t0.id
  LEFT JOIN slith_gameoptions t26 ON t26.product_id = t0.id
  LEFT JOIN slith_productart t41 ON t41.product_id = t0.id
  LEFT JOIN slith_productgame t52 ON t52.product_id = t0.id
  LEFT JOIN slith_leaderboard t80 ON t80.product_id = t0.id
  LEFT JOIN slith_proproduct t91 ON t91.product_id = t0.id
  LEFT JOIN slith_productmerchandise t101 ON t101.product_id = t0.id
  LEFT JOIN slith_streakfieldproduct t107 ON t107.internal_product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.old_game_id AS old_game_id_4, t0.slug AS slug_5, t0.earliest_release_date AS earliest_release_date_6, t0.latest_release_date AS latest_release_date_7, t0.smallest_price AS smallest_price_8, t0.old_game_url AS old_game_url_9, t0.is_release_date_visible AS is_release_date_visible_10, t0.google_conversion_code AS google_conversion_code_11, t12.id AS id_13, t12.description AS description_14, t12.features AS features_15, t12.requirements AS requirements_16, t12.game_data AS game_data_17, t12.discover_more_link AS discover_more_link_18, t12.historical_background AS historical_background_19, t12.lore AS lore_20, t12.product_id AS product_id_21, t22.id AS id_23, t22.discount_percent AS discount_percent_24, t22.product_id AS product_id_25, t26.id AS id_27, t26.min_players AS min_players_28, t26.max_players AS max_players_29, t26.product_id AS product_id_30, t26.genre_id AS genre_id_31, t26.timeline_id AS timeline_id_32, t26.theatre_id AS theatre_id_33, t26.difficulty_id AS difficulty_id_34, t26.play_style_id AS play_style_id_35, t26.artificial_intelligence_id AS artificial_intelligence_id_36, t26.game_editor_id AS game_editor_id_37, t26.turn_scale_id AS turn_scale_id_38, t26.multiplayer_id AS multiplayer_id_39, t26.unit_scale_id AS unit_scale_id_40, t41.id AS id_42, t41.portrait_image_name AS portrait_image_name_43, t41.landscape_image_name AS landscape_image_name_44, t41.logo_image_name AS logo_image_name_45, t41.icon_image_name AS icon_image_name_46, t41.landscape_image_name_external AS landscape_image_name_external_47, t41.product_id AS product_id_48, t0.status_id AS status_id_49, t0.family_id AS family_id_50, t0.product_type_id AS product_type_id_51, t52.id AS id_53, t52.steam_app_id AS steam_app_id_54, t52.external_forum_id AS external_forum_id_55, t52.forum_url AS forum_url_56, t52.is_serial_steam_key AS is_serial_steam_key_57, t52.is_preorder AS is_preorder_58, t52.is_indie AS is_indie_59, t52.gog_slug AS gog_slug_60, t52.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_61, t52.is_release_notification_sent AS is_release_notification_sent_62, t52.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_63, t52.steam_app_api_key AS steam_app_api_key_64, t52.gog_app_id AS gog_app_id_65, t52.gog_app_api_key AS gog_app_api_key_66, t52.discord_url AS discord_url_67, t52.epic_app_id AS epic_app_id_68, t52.epic_slug AS epic_slug_69, t52.epic_app_sandbox_id AS epic_app_sandbox_id_70, t52.training_url AS training_url_71, t52.folder_name AS folder_name_72, t52.has_custom_button AS has_custom_button_73, t52.custom_button_title AS custom_button_title_74, t52.custom_button_link AS custom_button_link_75, t52.product_id AS product_id_76, t52.developer_id AS developer_id_77, t52.life_cycle_id AS life_cycle_id_78, t52.forum_id AS forum_id_79, t80.id AS id_81, t80.name AS name_82, t80.web_apipublisher_key AS web_apipublisher_key_83, t80.background_image_name AS background_image_name_84, t80.leaderboard_title_id AS leaderboard_title_id_85, t80.secret_key AS secret_key_86, t80.product_id AS product_id_87, t80.status_id AS status_id_88, t80.leaderboard_provider_id AS leaderboard_provider_id_89, t0.otrsqueue_id AS otrsqueue_id_90, t91.id AS id_92, t91.is_license_file_revocable AS is_license_file_revocable_93, t91.is_price_calculator_available AS is_price_calculator_available_94, t91.pro_license_encryption_key AS pro_license_encryption_key_95, t91.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_96, t91.pro_license_generation_alert_email AS pro_license_generation_alert_email_97, t91.capabilities AS capabilities_98, t91.product_id AS product_id_99, t0.product_game_serial_pool_id AS product_game_serial_pool_id_100, t101.id AS id_102, t101.description AS description_103, t101.product_id AS product_id_104, t101.belongs_to_product_id AS belongs_to_product_id_105, t101.merchandise_type_id AS merchandise_type_id_106, t107.id AS id_108, t107.name AS name_109, t107.streak_key AS streak_key_110, t107.sort_order_index AS sort_order_index_111, t107.internal_product_id AS internal_product_id_112, t107.streak_field_product_type_id AS streak_field_product_type_id_113 FROM slith_product t0 LEFT JOIN slith_gamecontent t12 ON t12.product_id = t0.id LEFT JOIN slith_productbundle t22 ON t22.product_id = t0.id LEFT JOIN slith_gameoptions t26 ON t26.product_id = t0.id LEFT JOIN slith_productart t41 ON t41.product_id = t0.id LEFT JOIN slith_productgame t52 ON t52.product_id = t0.id LEFT JOIN slith_leaderboard t80 ON t80.product_id = t0.id LEFT JOIN slith_proproduct t91 ON t91.product_id = t0.id LEFT JOIN slith_productmerchandise t101 ON t101.product_id = t0.id LEFT JOIN slith_streakfieldproduct t107 ON t107.internal_product_id = t0.id WHERE t0.id = 389;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.server_name AS server_name_3,
  t0.server_address AS server_address_4,
  t0.status_id AS status_id_5
FROM
  slith_webserver t0
WHERE
  t0.server_address = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.server_name AS server_name_3, t0.server_address AS server_address_4, t0.status_id AS status_id_5 FROM slith_webserver t0 WHERE t0.server_address = '192.168.19.44' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2
FROM
  slith_tournamentconfigpage s0_
WHERE
  s0_.slug = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2 FROM slith_tournamentconfigpage s0_ WHERE s0_.slug = 'scores-and-draws' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.start_time AS start_time_1,
  s0_.end_time AS end_time_2,
  s0_.announcement AS announcement_3,
  s0_.is_sticky AS is_sticky_4,
  s0_.is_one_time AS is_one_time_5,
  s0_.name AS name_6,
  s0_.is_blocking AS is_blocking_7,
  s0_.slug AS slug_8,
  s0_.is_true_false AS is_true_false_9,
  s0_.refresh AS refresh_10,
  s0_.status_id AS status_id_11
FROM
  slith_globalannouncement s0_
  INNER JOIN slith_globalannouncement_website s2_ ON s0_.id = s2_.slith_globalannouncement_id
  INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id
WHERE
  s1_.id = ?
  AND s0_.status_id IN (?)

SELECT s0_.id AS id_0, s0_.start_time AS start_time_1, s0_.end_time AS end_time_2, s0_.announcement AS announcement_3, s0_.is_sticky AS is_sticky_4, s0_.is_one_time AS is_one_time_5, s0_.name AS name_6, s0_.is_blocking AS is_blocking_7, s0_.slug AS slug_8, s0_.is_true_false AS is_true_false_9, s0_.refresh AS refresh_10, s0_.status_id AS status_id_11 FROM slith_globalannouncement s0_ INNER JOIN slith_globalannouncement_website s2_ ON s0_.id = s2_.slith_globalannouncement_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = 2 AND s0_.status_id IN (2);

SELECT
  round_num,
  points
FROM
  slith_tournamentroundscoresgamepoints AS GP
  INNER JOIN slith_tournamentscores AS TS ON TS.id = GP.tournament_scores_id
WHERE
  TS.tournament_id = 1299
  AND GP.round_num = 5
GROUP BY
  round_num,
  points
ORDER BY
  CAST(points AS SIGNED) DESC
LIMIT
  3

SELECT round_num, points
                FROM slith_tournamentroundscoresgamepoints AS GP
                INNER JOIN slith_tournamentscores AS TS ON TS.id = GP.tournament_scores_id
                WHERE TS.tournament_id = 1299
                AND GP.round_num = 5
                GROUP BY round_num, points
                ORDER BY CAST(points AS SIGNED) DESC
                LIMIT 3 
            ;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.bluesnap_data_protection_key AS bluesnap_data_protection_key_3,
  t0.factory_allowed_ips AS factory_allowed_ips_4,
  t0.minimum_stock_steam_keys AS minimum_stock_steam_keys_5,
  t0.max_notification_emails_per_batch AS max_notification_emails_per_batch_6,
  t0.max_notification_users_created_per_batch AS max_notification_users_created_per_batch_7,
  t0.factory_feed_deferral_days AS factory_feed_deferral_days_8,
  t0.max_bluesnap_report_items_per_page AS max_bluesnap_report_items_per_page_9,
  t0.pro_license_encryption_key AS pro_license_encryption_key_10,
  t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_11,
  t0.is_notification_test AS is_notification_test_12,
  t0.notification_test_email AS notification_test_email_13,
  t0.re_captcha_secret_key AS re_captcha_secret_key_14,
  t0.re_captcha_key AS re_captcha_key_15,
  t0.contact_pro_recipient AS contact_pro_recipient_16,
  t0.contact_press_recipient AS contact_press_recipient_17,
  t0.max_wrong_count_coupon_code_applications AS max_wrong_count_coupon_code_applications_18,
  t0.max_time_between_wrong_coupon_code_applications AS max_time_between_wrong_coupon_code_applications_19,
  t0.max_time_between_user_active AS max_time_between_user_active_20,
  t0.pro_license_expiration_notification_day AS pro_license_expiration_notification_day_21,
  t0.pro_license_expiration_notification_survey_day AS pro_license_expiration_notification_survey_day_22,
  t0.pro_license_expiration_notification_survey_link AS pro_license_expiration_notification_survey_link_23,
  t0.pro_license_new_user_notification_survey_day AS pro_license_new_user_notification_survey_day_24,
  t0.pro_license_new_user_notification_survey_link AS pro_license_new_user_notification_survey_link_25,
  t0.otrsmax_message_length AS otrsmax_message_length_26,
  t0.creditcard_processing_seconds_threshold AS creditcard_processing_seconds_threshold_27,
  t0.pro_licensing_otrsqueue AS pro_licensing_otrsqueue_28,
  t0.contact_pro_quote_request_logs_recipient AS contact_pro_quote_request_logs_recipient_29,
  t0.max_forum_badge_selectable AS max_forum_badge_selectable_30,
  t0.ttl_elorating_leaderboard_page_cache AS ttl_elorating_leaderboard_page_cache_31,
  t0.max_items_per_page_elorating_leaderboard AS max_items_per_page_elorating_leaderboard_32,
  t0.max_items_per_page_elorating_leaderboard_history AS max_items_per_page_elorating_leaderboard_history_33,
  t0.contact_press_kproject_recipient AS contact_press_kproject_recipient_34,
  t0.event_max_spots_count AS event_max_spots_count_35,
  t0.stripe_apikey AS stripe_apikey_36,
  t0.stripe_apisecret_key AS stripe_apisecret_key_37,
  t0.test_stripe_apikey AS test_stripe_apikey_38,
  t0.test_stripe_apisecret_key AS test_stripe_apisecret_key_39,
  t0.minimum_stock_coupons_notification_email AS minimum_stock_coupons_notification_email_40,
  t0.is_re_captcha_ipwhitelist_enable AS is_re_captcha_ipwhitelist_enable_41,
  t0.re_captcha_ipwhitelist AS re_captcha_ipwhitelist_42,
  t0.max_days_bluesnap_log_ttl AS max_days_bluesnap_log_ttl_43,
  t0.is_streak_integration_enabled AS is_streak_integration_enabled_44,
  t0.language_id AS language_id_45,
  t0.currency_id AS currency_id_46,
  t0.website_user_id AS website_user_id_47,
  t0.xmas_mode_status_id AS xmas_mode_status_id_48,
  t0.helpdesk_id AS helpdesk_id_49,
  t0.pro_helpdesk_id AS pro_helpdesk_id_50,
  t0.default_website_id AS default_website_id_51,
  t0.current_pbem_server_id AS current_pbem_server_id_52
FROM
  slith_config t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.bluesnap_data_protection_key AS bluesnap_data_protection_key_3, t0.factory_allowed_ips AS factory_allowed_ips_4, t0.minimum_stock_steam_keys AS minimum_stock_steam_keys_5, t0.max_notification_emails_per_batch AS max_notification_emails_per_batch_6, t0.max_notification_users_created_per_batch AS max_notification_users_created_per_batch_7, t0.factory_feed_deferral_days AS factory_feed_deferral_days_8, t0.max_bluesnap_report_items_per_page AS max_bluesnap_report_items_per_page_9, t0.pro_license_encryption_key AS pro_license_encryption_key_10, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_11, t0.is_notification_test AS is_notification_test_12, t0.notification_test_email AS notification_test_email_13, t0.re_captcha_secret_key AS re_captcha_secret_key_14, t0.re_captcha_key AS re_captcha_key_15, t0.contact_pro_recipient AS contact_pro_recipient_16, t0.contact_press_recipient AS contact_press_recipient_17, t0.max_wrong_count_coupon_code_applications AS max_wrong_count_coupon_code_applications_18, t0.max_time_between_wrong_coupon_code_applications AS max_time_between_wrong_coupon_code_applications_19, t0.max_time_between_user_active AS max_time_between_user_active_20, t0.pro_license_expiration_notification_day AS pro_license_expiration_notification_day_21, t0.pro_license_expiration_notification_survey_day AS pro_license_expiration_notification_survey_day_22, t0.pro_license_expiration_notification_survey_link AS pro_license_expiration_notification_survey_link_23, t0.pro_license_new_user_notification_survey_day AS pro_license_new_user_notification_survey_day_24, t0.pro_license_new_user_notification_survey_link AS pro_license_new_user_notification_survey_link_25, t0.otrsmax_message_length AS otrsmax_message_length_26, t0.creditcard_processing_seconds_threshold AS creditcard_processing_seconds_threshold_27, t0.pro_licensing_otrsqueue AS pro_licensing_otrsqueue_28, t0.contact_pro_quote_request_logs_recipient AS contact_pro_quote_request_logs_recipient_29, t0.max_forum_badge_selectable AS max_forum_badge_selectable_30, t0.ttl_elorating_leaderboard_page_cache AS ttl_elorating_leaderboard_page_cache_31, t0.max_items_per_page_elorating_leaderboard AS max_items_per_page_elorating_leaderboard_32, t0.max_items_per_page_elorating_leaderboard_history AS max_items_per_page_elorating_leaderboard_history_33, t0.contact_press_kproject_recipient AS contact_press_kproject_recipient_34, t0.event_max_spots_count AS event_max_spots_count_35, t0.stripe_apikey AS stripe_apikey_36, t0.stripe_apisecret_key AS stripe_apisecret_key_37, t0.test_stripe_apikey AS test_stripe_apikey_38, t0.test_stripe_apisecret_key AS test_stripe_apisecret_key_39, t0.minimum_stock_coupons_notification_email AS minimum_stock_coupons_notification_email_40, t0.is_re_captcha_ipwhitelist_enable AS is_re_captcha_ipwhitelist_enable_41, t0.re_captcha_ipwhitelist AS re_captcha_ipwhitelist_42, t0.max_days_bluesnap_log_ttl AS max_days_bluesnap_log_ttl_43, t0.is_streak_integration_enabled AS is_streak_integration_enabled_44, t0.language_id AS language_id_45, t0.currency_id AS currency_id_46, t0.website_user_id AS website_user_id_47, t0.xmas_mode_status_id AS xmas_mode_status_id_48, t0.helpdesk_id AS helpdesk_id_49, t0.pro_helpdesk_id AS pro_helpdesk_id_50, t0.default_website_id AS default_website_id_51, t0.current_pbem_server_id AS current_pbem_server_id_52 FROM slith_config t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.content AS content_3,
  s0_.description AS description_4,
  s0_.status_id AS status_id_5,
  s0_.block_location_id AS block_location_id_6
FROM
  slith_block s0_
  INNER JOIN slith_block_website s2_ ON s0_.id = s2_.slith_block_id
  INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id
  INNER JOIN slith_blocklocation s3_ ON s0_.block_location_id = s3_.id
WHERE
  s0_.status_id IN (?)
  AND s3_.id = ?
  AND s1_.id = ?

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.description AS description_4, s0_.status_id AS status_id_5, s0_.block_location_id AS block_location_id_6 FROM slith_block s0_ INNER JOIN slith_block_website s2_ ON s0_.id = s2_.slith_block_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id INNER JOIN slith_blocklocation s3_ ON s0_.block_location_id = s3_.id WHERE s0_.status_id IN (2) AND s3_.id = 7 AND s1_.id = 2;

SELECT
  t0.id AS id_1,
  t0.tournament_id AS tournament_id_2,
  t0.visible AS visible_3,
  t0.tournament_title AS tournament_title_4,
  t0.game_id AS game_id_5,
  t0.rounds_num AS rounds_num_6,
  t0.current_round_num AS current_round_num_7,
  t0.joined_players_num AS joined_players_num_8,
  t0.max_players AS max_players_9,
  t0.start_date AS start_date_10,
  t0.round_time AS round_time_11,
  t0.round_points AS round_points_12,
  t0.bye_points AS bye_points_13,
  t0.next_round_start_date AS next_round_start_date_14,
  t0.status AS status_15,
  t0.forum_url AS forum_url_16,
  t0.server AS server_17,
  t0.current_round_start_date AS current_round_start_date_18,
  t0.current_round_end_date AS current_round_end_date_19,
  t0.scores_draws_last_update AS scores_draws_last_update_20,
  t0.hidden AS hidden_21,
  t0.is_private AS is_private_22,
  t0.is_tournament_with_problem AS is_tournament_with_problem_23,
  t0.description AS description_24,
  t0.is_ranked AS is_ranked_25,
  t0.created_at AS created_at_26,
  t0.num_players_from_child AS num_players_from_child_27,
  t0.product_id AS product_id_28,
  t0.tournament_server_id AS tournament_server_id_29,
  t30.id AS id_31,
  t30.name AS name_32,
  t30.description AS description_33,
  t30.date_created AS date_created_34,
  t30.date_finished AS date_finished_35,
  t30.email_subject AS email_subject_36,
  t30.notification_status_id AS notification_status_id_37,
  t30.notification_type_id AS notification_type_id_38,
  t30.notification_template_id AS notification_template_id_39,
  t30.wishlist_id AS wishlist_id_40,
  t30.product_id AS product_id_41,
  t30.discount_id AS discount_id_42,
  t30.transaction_id AS transaction_id_43,
  t30.tournament_id AS tournament_id_44,
  t45.id AS id_46,
  t45.trigger_time AS trigger_time_47,
  t45.notification_id AS notification_id_48,
  t45.action_status_id AS action_status_id_49,
  t45.notification_type_id AS notification_type_id_50,
  t45.discount_id AS discount_id_51,
  t45.product_id AS product_id_52,
  t45.transaction_id AS transaction_id_53,
  t45.tournament_id AS tournament_id_54,
  t45.user_id AS user_id_55,
  t0.tournament_status_id AS tournament_status_id_56,
  t0.pbem_server_id AS pbem_server_id_57,
  t0.tournament_type_id AS tournament_type_id_58,
  t0.parent_tournament_id AS parent_tournament_id_59
FROM
  slith_tournament t0
  LEFT JOIN slith_notification t30 ON t30.tournament_id = t0.id
  LEFT JOIN slith_notificationtrigger t45 ON t45.tournament_id = t0.id
WHERE
  t0.parent_tournament_id = ?