Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          (
            CASE WHEN s0_.latest_release_date IS NULL THEN
              1
            ELSE
              0
            END
          ) AS sclr_0,
          s0_.id AS id_1,
          s0_.name AS name_2,
          s0_.introduction AS introduction_3,
          s0_.old_game_id AS old_game_id_4,
          s0_.slug AS slug_5,
          s0_.earliest_release_date AS earliest_release_date_6,
          s0_.latest_release_date AS latest_release_date_7,
          s0_.smallest_price AS smallest_price_8,
          s0_.old_game_url AS old_game_url_9,
          s0_.is_release_date_visible AS is_release_date_visible_10,
          s0_.google_conversion_code AS google_conversion_code_11,
          s1_.id AS id_12,
          s1_.portrait_image_name AS portrait_image_name_13,
          s1_.landscape_image_name AS landscape_image_name_14,
          s1_.logo_image_name AS logo_image_name_15,
          s1_.icon_image_name AS icon_image_name_16,
          s1_.landscape_image_name_external AS landscape_image_name_external_17
        FROM
          slith_product s0_
          INNER JOIN slith_productart s1_ ON s0_.id = s1_.product_id
          INNER JOIN slith_product_website s3_ ON s0_.id = s3_.slith_product_id
          INNER JOIN slith_website s2_ ON s2_.id = s3_.slith_website_id
          LEFT JOIN slith_productgame s4_ ON s0_.id = s4_.product_id
          LEFT JOIN slith_gamecontract s5_ ON s0_.id = s5_.product_id
          LEFT JOIN slith_productbundle s6_ ON s0_.id = s6_.product_id
          LEFT JOIN slith_discountcontract s7_ ON s5_.id = s7_.game_contract_id
          LEFT JOIN slith_discountbundle s8_ ON s6_.id = s8_.product_bundle_id
          LEFT JOIN slith_discount s9_ ON s7_.discount_id = s9_.id
          LEFT JOIN slith_discount s10_ ON s8_.discount_id = s10_.id
        WHERE
          s2_.slug = ?
          AND s0_.status_id IN (?)
          AND (
            (
              s5_.status_id IN (?)
              OR s5_.status_id IS NULL
            )
          )
          AND (
            (
              s9_.status_id IN (?)
              OR s10_.status_id IN (?)
            )
          )
          AND (
            (
              s9_.discount_method_id = (?)
              OR s10_.discount_method_id = (?)
            )
          )
          AND (
            (
              s9_.start_date <= ?
              AND s9_.end_date >= ?
            )
            OR (
              s10_.start_date <= ?
              AND s10_.end_date >= ?
            )
          )
        ORDER BY
          sclr_0 DESC,
          s0_.latest_release_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT (CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END) AS sclr_0, s0_.id AS id_1, s0_.name AS name_2, s0_.introduction AS introduction_3, s0_.old_game_id AS old_game_id_4, s0_.slug AS slug_5, s0_.earliest_release_date AS earliest_release_date_6, s0_.latest_release_date AS latest_release_date_7, s0_.smallest_price AS smallest_price_8, s0_.old_game_url AS old_game_url_9, s0_.is_release_date_visible AS is_release_date_visible_10, s0_.google_conversion_code AS google_conversion_code_11, s1_.id AS id_12, s1_.portrait_image_name AS portrait_image_name_13, s1_.landscape_image_name AS landscape_image_name_14, s1_.logo_image_name AS logo_image_name_15, s1_.icon_image_name AS icon_image_name_16, s1_.landscape_image_name_external AS landscape_image_name_external_17 FROM slith_product s0_ INNER JOIN slith_productart s1_ ON s0_.id = s1_.product_id INNER JOIN slith_product_website s3_ ON s0_.id = s3_.slith_product_id INNER JOIN slith_website s2_ ON s2_.id = s3_.slith_website_id LEFT JOIN slith_productgame s4_ ON s0_.id = s4_.product_id LEFT JOIN slith_gamecontract s5_ ON s0_.id = s5_.product_id LEFT JOIN slith_productbundle s6_ ON s0_.id = s6_.product_id LEFT JOIN slith_discountcontract s7_ ON s5_.id = s7_.game_contract_id LEFT JOIN slith_discountbundle s8_ ON s6_.id = s8_.product_bundle_id LEFT JOIN slith_discount s9_ ON s7_.discount_id = s9_.id LEFT JOIN slith_discount s10_ ON s8_.discount_id = s10_.id WHERE s2_.slug = 'slitherine' AND s0_.status_id IN (2) AND ((s5_.status_id IN (2) OR s5_.status_id IS NULL)) AND ((s9_.status_id IN (2) OR s10_.status_id IN (2))) AND ((s9_.discount_method_id = (1) OR s10_.discount_method_id = (1))) AND ((s9_.start_date <= '2026-02-25 00:50:24' AND s9_.end_date >= '2026-02-25 00:50:24') OR (s10_.start_date <= '2026-02-25 00:50:24' AND s10_.end_date >= '2026-02-25 00:50:24')) ORDER BY sclr_0 DESC, s0_.latest_release_date DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_1
FROM
  (
    SELECT
      DISTINCT id_1,
      sclr_0,
      latest_release_date_7
    FROM
      (
        SELECT
          (
            CASE WHEN s0_.latest_release_date IS NULL THEN
              1
            ELSE
              0
            END
          ) AS sclr_0,
          s0_.id AS id_1,
          s0_.name AS name_2,
          s0_.introduction AS introduction_3,
          s0_.old_game_id AS old_game_id_4,
          s0_.slug AS slug_5,
          s0_.earliest_release_date AS earliest_release_date_6,
          s0_.latest_release_date AS latest_release_date_7,
          s0_.smallest_price AS smallest_price_8,
          s0_.old_game_url AS old_game_url_9,
          s0_.is_release_date_visible AS is_release_date_visible_10,
          s0_.google_conversion_code AS google_conversion_code_11,
          s1_.id AS id_12,
          s1_.portrait_image_name AS portrait_image_name_13,
          s1_.landscape_image_name AS landscape_image_name_14,
          s1_.logo_image_name AS logo_image_name_15,
          s1_.icon_image_name AS icon_image_name_16,
          s1_.landscape_image_name_external AS landscape_image_name_external_17,
          s2_.id AS id_18,
          s2_.title AS title_19,
          s2_.domain_name AS domain_name_20,
          s2_.old_website_id AS old_website_id_21,
          s2_.slug AS slug_22,
          s2_.google_analytics_tag AS google_analytics_tag_23,
          s2_.facebook_pixel_id AS facebook_pixel_id_24,
          s2_.favicon AS favicon_25,
          s2_.youtube_channel_id AS youtube_channel_id_26,
          s2_.twitch_channel_name AS twitch_channel_name_27,
          s2_.smtp_ip AS smtp_ip_28,
          s2_.smtp_user AS smtp_user_29,
          s2_.smtp_password AS smtp_password_30,
          s2_.email_address AS email_address_31,
          s2_.re_captcha_key AS re_captcha_key_32,
          s2_.forum_url AS forum_url_33,
          s2_.re_captcha_secret_key AS re_captcha_secret_key_34,
          s2_.logo_file_path AS logo_file_path_35,
          s2_.smtp_port AS smtp_port_36,
          s2_.facebook_username AS facebook_username_37,
          s2_.discord_username AS discord_username_38,
          s2_.twitter_handle AS twitter_handle_39,
          s2_.instagram_username AS instagram_username_40,
          s2_.youtube_username AS youtube_username_41,
          s2_.teads_pixel_id AS teads_pixel_id_42,
          s2_.is_subscribe_discount_coupons_available AS is_subscribe_discount_coupons_available_43,
          s2_.reddit_pixel_id AS reddit_pixel_id_44,
          s2_.is_forum_badge_capable AS is_forum_badge_capable_45,
          s2_.forum_badge_update_endpoint AS forum_badge_update_endpoint_46,
          s2_.support_email_address AS support_email_address_47,
          s3_.id AS id_48,
          s3_.contract AS contract_49,
          s3_.price AS price_50,
          s3_.is_round AS is_round_51,
          s3_.old_platform_contract_id AS old_platform_contract_id_52,
          s3_.weight AS weight_53,
          s3_.length AS length_54,
          s3_.width AS width_55,
          s3_.depth AS depth_56,
          s3_.is_free AS is_free_57,
          s3_.contract_priority AS contract_priority_58,
          s4_.id AS id_59,
          s4_.title AS title_60,
          s4_.description AS description_61,
          s4_.start_date AS start_date_62,
          s4_.end_date AS end_date_63,
          s4_.image_file_name AS image_file_name_64,
          s4_.do_not_send_notification AS do_not_send_notification_65,
          s5_.id AS id_66,
          s5_.title AS title_67,
          s5_.description AS description_68,
          s5_.start_date AS start_date_69,
          s5_.end_date AS end_date_70,
          s5_.image_file_name AS image_file_name_71,
          s5_.do_not_send_notification AS do_not_send_notification_72
        FROM
          slith_product s0_
          INNER JOIN slith_productart s1_ ON s0_.id = s1_.product_id
          INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id
          INNER JOIN slith_website s2_ ON s2_.id = s6_.slith_website_id
          LEFT JOIN slith_productgame s7_ ON s0_.id = s7_.product_id
          LEFT JOIN slith_gamecontract s3_ ON s0_.id = s3_.product_id
          LEFT JOIN slith_productbundle s8_ ON s0_.id = s8_.product_id
          LEFT JOIN slith_discountcontract s9_ ON s3_.id = s9_.game_contract_id
          LEFT JOIN slith_discountbundle s10_ ON s8_.id = s10_.product_bundle_id
          LEFT JOIN slith_discount s4_ ON s9_.discount_id = s4_.id
          LEFT JOIN slith_discount s5_ ON s10_.discount_id = s5_.id
        WHERE
          s2_.slug = ?
          AND s0_.status_id IN (?)
          AND (
            (
              s3_.status_id IN (?)
              OR s3_.status_id IS NULL
            )
          )
          AND (
            (
              s4_.status_id IN (?)
              OR s5_.status_id IN (?)
            )
          )
          AND (
            (
              s4_.discount_method_id = (?)
              OR s5_.discount_method_id = (?)
            )
          )
          AND (
            (
              s4_.start_date <= ?
              AND s4_.end_date >= ?
            )
            OR (
              s5_.start_date <= ?
              AND s5_.end_date >= ?
            )
          )
      ) dctrn_result_inner
    ORDER BY
      sclr_0 DESC,
      latest_release_date_7 DESC
  ) dctrn_result
LIMIT
  21

SELECT DISTINCT id_1 FROM (SELECT DISTINCT id_1, sclr_0, latest_release_date_7 FROM (SELECT (CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END) AS sclr_0, s0_.id AS id_1, s0_.name AS name_2, s0_.introduction AS introduction_3, s0_.old_game_id AS old_game_id_4, s0_.slug AS slug_5, s0_.earliest_release_date AS earliest_release_date_6, s0_.latest_release_date AS latest_release_date_7, s0_.smallest_price AS smallest_price_8, s0_.old_game_url AS old_game_url_9, s0_.is_release_date_visible AS is_release_date_visible_10, s0_.google_conversion_code AS google_conversion_code_11, s1_.id AS id_12, s1_.portrait_image_name AS portrait_image_name_13, s1_.landscape_image_name AS landscape_image_name_14, s1_.logo_image_name AS logo_image_name_15, s1_.icon_image_name AS icon_image_name_16, s1_.landscape_image_name_external AS landscape_image_name_external_17, s2_.id AS id_18, s2_.title AS title_19, s2_.domain_name AS domain_name_20, s2_.old_website_id AS old_website_id_21, s2_.slug AS slug_22, s2_.google_analytics_tag AS google_analytics_tag_23, s2_.facebook_pixel_id AS facebook_pixel_id_24, s2_.favicon AS favicon_25, s2_.youtube_channel_id AS youtube_channel_id_26, s2_.twitch_channel_name AS twitch_channel_name_27, s2_.smtp_ip AS smtp_ip_28, s2_.smtp_user AS smtp_user_29, s2_.smtp_password AS smtp_password_30, s2_.email_address AS email_address_31, s2_.re_captcha_key AS re_captcha_key_32, s2_.forum_url AS forum_url_33, s2_.re_captcha_secret_key AS re_captcha_secret_key_34, s2_.logo_file_path AS logo_file_path_35, s2_.smtp_port AS smtp_port_36, s2_.facebook_username AS facebook_username_37, s2_.discord_username AS discord_username_38, s2_.twitter_handle AS twitter_handle_39, s2_.instagram_username AS instagram_username_40, s2_.youtube_username AS youtube_username_41, s2_.teads_pixel_id AS teads_pixel_id_42, s2_.is_subscribe_discount_coupons_available AS is_subscribe_discount_coupons_available_43, s2_.reddit_pixel_id AS reddit_pixel_id_44, s2_.is_forum_badge_capable AS is_forum_badge_capable_45, s2_.forum_badge_update_endpoint AS forum_badge_update_endpoint_46, s2_.support_email_address AS support_email_address_47, s3_.id AS id_48, s3_.contract AS contract_49, s3_.price AS price_50, s3_.is_round AS is_round_51, s3_.old_platform_contract_id AS old_platform_contract_id_52, s3_.weight AS weight_53, s3_.length AS length_54, s3_.width AS width_55, s3_.depth AS depth_56, s3_.is_free AS is_free_57, s3_.contract_priority AS contract_priority_58, s4_.id AS id_59, s4_.title AS title_60, s4_.description AS description_61, s4_.start_date AS start_date_62, s4_.end_date AS end_date_63, s4_.image_file_name AS image_file_name_64, s4_.do_not_send_notification AS do_not_send_notification_65, s5_.id AS id_66, s5_.title AS title_67, s5_.description AS description_68, s5_.start_date AS start_date_69, s5_.end_date AS end_date_70, s5_.image_file_name AS image_file_name_71, s5_.do_not_send_notification AS do_not_send_notification_72 FROM slith_product s0_ INNER JOIN slith_productart s1_ ON s0_.id = s1_.product_id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s2_ ON s2_.id = s6_.slith_website_id LEFT JOIN slith_productgame s7_ ON s0_.id = s7_.product_id LEFT JOIN slith_gamecontract s3_ ON s0_.id = s3_.product_id LEFT JOIN slith_productbundle s8_ ON s0_.id = s8_.product_id LEFT JOIN slith_discountcontract s9_ ON s3_.id = s9_.game_contract_id LEFT JOIN slith_discountbundle s10_ ON s8_.id = s10_.product_bundle_id LEFT JOIN slith_discount s4_ ON s9_.discount_id = s4_.id LEFT JOIN slith_discount s5_ ON s10_.discount_id = s5_.id WHERE s2_.slug = 'slitherine' AND s0_.status_id IN (2) AND ((s3_.status_id IN (2) OR s3_.status_id IS NULL)) AND ((s4_.status_id IN (2) OR s5_.status_id IN (2))) AND ((s4_.discount_method_id = (1) OR s5_.discount_method_id = (1))) AND ((s4_.start_date <= '2026-02-25 00:50:24' AND s4_.end_date >= '2026-02-25 00:50:24') OR (s5_.start_date <= '2026-02-25 00:50:24' AND s5_.end_date >= '2026-02-25 00:50:24'))) dctrn_result_inner ORDER BY sclr_0 DESC, latest_release_date_7 DESC) dctrn_result LIMIT 21;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.introduction AS introduction_2,
  s0_.article AS article_3,
  s0_.link AS link_4,
  s0_.redirect AS redirect_5,
  s0_.start_date AS start_date_6,
  s0_.end_date AS end_date_7,
  s0_.image_file_name AS image_file_name_8,
  s0_.spotlight_image_file_name AS spotlight_image_file_name_9,
  s0_.homepage_banner_image_file_name AS homepage_banner_image_file_name_10,
  s0_.old_news_id AS old_news_id_11,
  s0_.posted_date AS posted_date_12,
  s0_.slug AS slug_13,
  s0_.old_id AS old_id_14,
  s0_.has_countdown AS has_countdown_15,
  s0_.countdown_end_date AS countdown_end_date_16,
  s0_.countdown_timer_color AS countdown_timer_color_17,
  s0_.countdown_timer_legend_color AS countdown_timer_legend_color_18,
  s0_.countdown_timer_font_size AS countdown_timer_font_size_19,
  s0_.countdown_timer_legend_font_size AS countdown_timer_legend_font_size_20,
  s0_.countdown_position_left AS countdown_position_left_21,
  s0_.countdown_position_bottom AS countdown_position_bottom_22,
  s0_.news_has_box_overlay AS news_has_box_overlay_23,
  s0_.spotlight_has_box_overlay AS spotlight_has_box_overlay_24,
  s0_.news_box_overlay_text AS news_box_overlay_text_25,
  s0_.news_overlay_text AS news_overlay_text_26,
  s0_.spotlight_box_overlay_text AS spotlight_box_overlay_text_27,
  s0_.spotlight_overlay_text AS spotlight_overlay_text_28,
  s0_.status_id AS status_id_29
FROM
  slith_news s0_
  INNER JOIN slith_news_website s2_ ON s0_.id = s2_.slith_news_id
  INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id
  INNER JOIN slith_news_newszone s4_ ON s0_.id = s4_.slith_news_id
  INNER JOIN slith_newszone s3_ ON s3_.id = s4_.slith_newszone_id
WHERE
  s1_.id = ?
  AND s0_.status_id IN (?)
  AND s3_.id = ?
  AND s0_.start_date <= ?
  AND (
    (
      s0_.end_date IS NULL
      OR s0_.end_date >= ?
    )
  )
ORDER BY
  s0_.start_date DESC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.introduction AS introduction_2, s0_.article AS article_3, s0_.link AS link_4, s0_.redirect AS redirect_5, s0_.start_date AS start_date_6, s0_.end_date AS end_date_7, s0_.image_file_name AS image_file_name_8, s0_.spotlight_image_file_name AS spotlight_image_file_name_9, s0_.homepage_banner_image_file_name AS homepage_banner_image_file_name_10, s0_.old_news_id AS old_news_id_11, s0_.posted_date AS posted_date_12, s0_.slug AS slug_13, s0_.old_id AS old_id_14, s0_.has_countdown AS has_countdown_15, s0_.countdown_end_date AS countdown_end_date_16, s0_.countdown_timer_color AS countdown_timer_color_17, s0_.countdown_timer_legend_color AS countdown_timer_legend_color_18, s0_.countdown_timer_font_size AS countdown_timer_font_size_19, s0_.countdown_timer_legend_font_size AS countdown_timer_legend_font_size_20, s0_.countdown_position_left AS countdown_position_left_21, s0_.countdown_position_bottom AS countdown_position_bottom_22, s0_.news_has_box_overlay AS news_has_box_overlay_23, s0_.spotlight_has_box_overlay AS spotlight_has_box_overlay_24, s0_.news_box_overlay_text AS news_box_overlay_text_25, s0_.news_overlay_text AS news_overlay_text_26, s0_.spotlight_box_overlay_text AS spotlight_box_overlay_text_27, s0_.spotlight_overlay_text AS spotlight_overlay_text_28, s0_.status_id AS status_id_29 FROM slith_news s0_ INNER JOIN slith_news_website s2_ ON s0_.id = s2_.slith_news_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id INNER JOIN slith_news_newszone s4_ ON s0_.id = s4_.slith_news_id INNER JOIN slith_newszone s3_ ON s3_.id = s4_.slith_newszone_id WHERE s1_.id = 2 AND s0_.status_id IN (2) AND s3_.id = 2 AND s0_.start_date <= '2026-02-25 00:00:00' AND ((s0_.end_date IS NULL OR s0_.end_date >= '2026-02-25 00:00:00')) ORDER BY s0_.start_date DESC LIMIT 5;

SELECT
  s0_.id AS id_0,
  s0_.developer_name AS developer_name_1,
  s0_.old_developer_id AS old_developer_id_2,
  s0_.email AS email_3,
  s0_.first_name AS first_name_4,
  s0_.last_name AS last_name_5,
  s0_.status_id AS status_id_6
FROM
  slith_developer s0_
  INNER JOIN slith_status s1_ ON s0_.status_id = s1_.id
WHERE
  s1_.id = ?
ORDER BY
  s0_.developer_name ASC

SELECT s0_.id AS id_0, s0_.developer_name AS developer_name_1, s0_.old_developer_id AS old_developer_id_2, s0_.email AS email_3, s0_.first_name AS first_name_4, s0_.last_name AS last_name_5, s0_.status_id AS status_id_6 FROM slith_developer s0_ INNER JOIN slith_status s1_ ON s0_.status_id = s1_.id WHERE s1_.id = 2 ORDER BY s0_.developer_name ASC;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.description AS description_2,
  s0_.start_date AS start_date_3,
  s0_.end_date AS end_date_4,
  s0_.image_file_name AS image_file_name_5,
  s0_.do_not_send_notification AS do_not_send_notification_6,
  s0_.status_id AS status_id_7,
  s0_.discount_method_id AS discount_method_id_8
FROM
  slith_discount s0_
  LEFT JOIN slith_discountcontract s1_ ON s0_.id = s1_.discount_id
  LEFT JOIN slith_discountbundle s2_ ON s0_.id = s2_.discount_id
  LEFT JOIN slith_gamecontract s3_ ON s1_.game_contract_id = s3_.id
  LEFT JOIN slith_productbundle s4_ ON s2_.product_bundle_id = s4_.id
  LEFT JOIN slith_product s5_ ON s3_.product_id = s5_.id
  LEFT JOIN slith_product s6_ ON s4_.product_id = s6_.id
  LEFT JOIN slith_product_website s8_ ON s5_.id = s8_.slith_product_id
  LEFT JOIN slith_website s7_ ON s7_.id = s8_.slith_website_id
  LEFT JOIN slith_product_website s10_ ON s6_.id = s10_.slith_product_id
  LEFT JOIN slith_website s9_ ON s9_.id = s10_.slith_website_id
  LEFT JOIN slith_status s11_ ON s0_.status_id = s11_.id
WHERE
  (
    s7_.slug = ?
    OR s9_.slug = ?
  )
  AND s0_.start_date <= ?
  AND s0_.end_date >= ?
  AND s11_.id IN (?)
  AND s0_.discount_method_id = ?

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.start_date AS start_date_3, s0_.end_date AS end_date_4, s0_.image_file_name AS image_file_name_5, s0_.do_not_send_notification AS do_not_send_notification_6, s0_.status_id AS status_id_7, s0_.discount_method_id AS discount_method_id_8 FROM slith_discount s0_ LEFT JOIN slith_discountcontract s1_ ON s0_.id = s1_.discount_id LEFT JOIN slith_discountbundle s2_ ON s0_.id = s2_.discount_id LEFT JOIN slith_gamecontract s3_ ON s1_.game_contract_id = s3_.id LEFT JOIN slith_productbundle s4_ ON s2_.product_bundle_id = s4_.id LEFT JOIN slith_product s5_ ON s3_.product_id = s5_.id LEFT JOIN slith_product s6_ ON s4_.product_id = s6_.id LEFT JOIN slith_product_website s8_ ON s5_.id = s8_.slith_product_id LEFT JOIN slith_website s7_ ON s7_.id = s8_.slith_website_id LEFT JOIN slith_product_website s10_ ON s6_.id = s10_.slith_product_id LEFT JOIN slith_website s9_ ON s9_.id = s10_.slith_website_id LEFT JOIN slith_status s11_ ON s0_.status_id = s11_.id WHERE (s7_.slug = 'slitherine' OR s9_.slug = 'slitherine') AND s0_.start_date <= '2026-02-25 00:00:00' AND s0_.end_date >= '2026-02-25 00:00:00' AND s11_.id IN (2) AND s0_.discount_method_id = 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.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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.url AS url_4
FROM
  slith_blocklocation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.url AS url_4 FROM slith_blocklocation t0 WHERE t0.slug = 'copyright' 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
  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
  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 00:50:24') AND (s0_.valid_until IS NULL OR s0_.valid_until >= '2026-02-25 00:50:24') LIMIT 1;