Redirect 302 redirect from GET @app_product_product (1d7fd6)

GET https://www51.slitherine.com/bundle/combat-mission-collection

Query Metrics

155 Database Queries
45 Different statements
77.95 ms Query time
2 Invalid entities
283 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.84 ms
(13.90%)
8
SELECT t0.id AS id_1, t0.name AS name_2, t0.web_apipublisher_key AS web_apipublisher_key_3, t0.background_image_name AS background_image_name_4, t0.leaderboard_title_id AS leaderboard_title_id_5, t0.secret_key AS secret_key_6, t0.product_id AS product_id_7, t0.status_id AS status_id_8, t0.leaderboard_provider_id AS leaderboard_provider_id_9 FROM slith_leaderboard t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
7.35 ms
(9.43%)
25
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.image_file_name AS image_file_name_6, t0.do_not_send_notification AS do_not_send_notification_7, t0.status_id AS status_id_8, t9.id AS id_10, t9.trigger_time AS trigger_time_11, t9.notification_id AS notification_id_12, t9.action_status_id AS action_status_id_13, t9.notification_type_id AS notification_type_id_14, t9.discount_id AS discount_id_15, t9.product_id AS product_id_16, t9.transaction_id AS transaction_id_17, t9.tournament_id AS tournament_id_18, t9.user_id AS user_id_19, t20.id AS id_21, t20.name AS name_22, t20.description AS description_23, t20.date_created AS date_created_24, t20.date_finished AS date_finished_25, t20.email_subject AS email_subject_26, t20.notification_status_id AS notification_status_id_27, t20.notification_type_id AS notification_type_id_28, t20.notification_template_id AS notification_template_id_29, t20.wishlist_id AS wishlist_id_30, t20.product_id AS product_id_31, t20.discount_id AS discount_id_32, t20.transaction_id AS transaction_id_33, t20.tournament_id AS tournament_id_34, t0.discount_method_id AS discount_method_id_35 FROM slith_discount t0 LEFT JOIN slith_notificationtrigger t9 ON t9.discount_id = t0.id LEFT JOIN slith_notification t20 ON t20.discount_id = t0.id WHERE t0.id = ?
Parameters:
[
  146
]
5.30 ms
(6.80%)
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 = ? LIMIT 1
Parameters:
[
  "192.168.19.44"
]
4.83 ms
(6.19%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.introduction AS introduction_2, s0_.old_game_id AS old_game_id_3, s0_.slug AS slug_4, s0_.earliest_release_date AS earliest_release_date_5, s0_.latest_release_date AS latest_release_date_6, s0_.smallest_price AS smallest_price_7, s0_.old_game_url AS old_game_url_8, s0_.is_release_date_visible AS is_release_date_visible_9, s0_.google_conversion_code AS google_conversion_code_10, s1_.id AS id_11, s1_.discount_percent AS discount_percent_12, s2_.id AS id_13, s2_.name AS name_14, s2_.introduction AS introduction_15, s2_.old_game_id AS old_game_id_16, s2_.slug AS slug_17, s2_.earliest_release_date AS earliest_release_date_18, s2_.latest_release_date AS latest_release_date_19, s2_.smallest_price AS smallest_price_20, s2_.old_game_url AS old_game_url_21, s2_.is_release_date_visible AS is_release_date_visible_22, s2_.google_conversion_code AS google_conversion_code_23, s3_.id AS id_24, s3_.portrait_image_name AS portrait_image_name_25, s3_.landscape_image_name AS landscape_image_name_26, s3_.logo_image_name AS logo_image_name_27, s3_.icon_image_name AS icon_image_name_28, s3_.landscape_image_name_external AS landscape_image_name_external_29, s4_.id AS id_30, s4_.min_players AS min_players_31, s4_.max_players AS max_players_32, s5_.id AS id_33, s5_.is_default AS is_default_34, s5_.requirements AS requirements_35, s5_.release_date AS release_date_36, s5_.old_game_platform_id AS old_game_platform_id_37, s5_.short_url AS short_url_38, s6_.id AS id_39, s6_.contract AS contract_40, s6_.price AS price_41, s6_.is_round AS is_round_42, s6_.old_platform_contract_id AS old_platform_contract_id_43, s6_.weight AS weight_44, s6_.length AS length_45, s6_.width AS width_46, s6_.depth AS depth_47, s6_.is_free AS is_free_48, s6_.contract_priority AS contract_priority_49, s0_.status_id AS status_id_50, s0_.family_id AS family_id_51, s0_.product_type_id AS product_type_id_52, s0_.otrsqueue_id AS otrsqueue_id_53, s0_.product_game_serial_pool_id AS product_game_serial_pool_id_54, s1_.product_id AS product_id_55, s2_.status_id AS status_id_56, s2_.family_id AS family_id_57, s2_.product_type_id AS product_type_id_58, s2_.otrsqueue_id AS otrsqueue_id_59, s2_.product_game_serial_pool_id AS product_game_serial_pool_id_60, s3_.product_id AS product_id_61, s4_.product_id AS product_id_62, s4_.genre_id AS genre_id_63, s4_.timeline_id AS timeline_id_64, s4_.theatre_id AS theatre_id_65, s4_.difficulty_id AS difficulty_id_66, s4_.play_style_id AS play_style_id_67, s4_.artificial_intelligence_id AS artificial_intelligence_id_68, s4_.game_editor_id AS game_editor_id_69, s4_.turn_scale_id AS turn_scale_id_70, s4_.multiplayer_id AS multiplayer_id_71, s4_.unit_scale_id AS unit_scale_id_72, s5_.product_id AS product_id_73, s5_.platform_id AS platform_id_74, s5_.status_id AS status_id_75, s6_.game_platform_id AS game_platform_id_76, s6_.store_id AS store_id_77, s6_.contract_type_id AS contract_type_id_78, s6_.shipping_type_id AS shipping_type_id_79, s6_.status_id AS status_id_80, s6_.product_id AS product_id_81, s6_.game_edition_id AS game_edition_id_82, s6_.shopping_cart_coupon_id AS shopping_cart_coupon_id_83 FROM slith_product s0_ INNER JOIN slith_productbundle s1_ ON s0_.id = s1_.product_id INNER JOIN slith_productbundle_product s7_ ON s1_.id = s7_.slith_productbundle_id INNER JOIN slith_product s2_ ON s2_.id = s7_.slith_product_id INNER JOIN slith_status s8_ ON s0_.status_id = s8_.id INNER JOIN slith_product_website s10_ ON s0_.id = s10_.slith_product_id INNER JOIN slith_website s9_ ON s9_.id = s10_.slith_website_id INNER JOIN slith_status s11_ ON s2_.status_id = s11_.id AND (s11_.id IN (?)) INNER JOIN slith_product_website s13_ ON s2_.id = s13_.slith_product_id INNER JOIN slith_website s12_ ON s12_.id = s13_.slith_website_id AND (s12_.slug IN (?)) INNER JOIN slith_productart s3_ ON s2_.id = s3_.product_id INNER JOIN slith_gameoptions s4_ ON s2_.id = s4_.product_id INNER JOIN slith_gameplatform s5_ ON s2_.id = s5_.product_id INNER JOIN slith_status s14_ ON s5_.status_id = s14_.id AND (s14_.id IN (?)) INNER JOIN slith_platform s15_ ON s5_.platform_id = s15_.id INNER JOIN slith_store_platform s17_ ON s15_.id = s17_.slith_platform_id INNER JOIN slith_store s16_ ON s16_.id = s17_.slith_store_id INNER JOIN slith_gamecontract s6_ ON s2_.id = s6_.product_id INNER JOIN slith_status s18_ ON s6_.status_id = s18_.id AND (s18_.id IN (?)) WHERE s0_.slug = ? AND s9_.slug = ? AND s8_.id IN (?)
Parameters:
[
  2
  "slitherine"
  2
  2
  "combat-mission-collection"
  "slitherine"
  2
]
4.51 ms
(5.78%)
7
SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.discount_id AS discount_id_3, t0.game_contract_id AS game_contract_id_4 FROM slith_discountcontract t0 WHERE t0.game_contract_id = ?
Parameters:
[
  1375
]
4.33 ms
(5.55%)
8
SELECT t0.id AS id_1, t0.description AS description_2, t0.features AS features_3, t0.requirements AS requirements_4, t0.game_data AS game_data_5, t0.discover_more_link AS discover_more_link_6, t0.historical_background AS historical_background_7, t0.lore AS lore_8, t0.product_id AS product_id_9 FROM slith_gamecontent t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
3.95 ms
(5.07%)
8
SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3, t0.belongs_to_product_id AS belongs_to_product_id_4, t0.merchandise_type_id AS merchandise_type_id_5 FROM slith_productmerchandise t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
3.82 ms
(4.90%)
1
SELECT t0.id AS id_1, t0.min_players AS min_players_2, t0.max_players AS max_players_3, t0.product_id AS product_id_4, t0.genre_id AS genre_id_5, t0.timeline_id AS timeline_id_6, t0.theatre_id AS theatre_id_7, t0.difficulty_id AS difficulty_id_8, t0.play_style_id AS play_style_id_9, t0.artificial_intelligence_id AS artificial_intelligence_id_10, t0.game_editor_id AS game_editor_id_11, t0.turn_scale_id AS turn_scale_id_12, t0.multiplayer_id AS multiplayer_id_13, t0.unit_scale_id AS unit_scale_id_14 FROM slith_gameoptions t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
3.75 ms
(4.81%)
4
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
Parameters:
[
  "copyright"
]
3.66 ms
(4.70%)
1
SELECT t0.id AS id_1, t0.manual AS manual_2, t0.old_manual_id AS old_manual_id_3 FROM slith_manual t0 INNER JOIN slith_gameoptions_manual ON t0.id = slith_gameoptions_manual.slith_manual_id WHERE slith_gameoptions_manual.slith_gameoptions_id = ?
Parameters:
[
  636
]
3.64 ms
(4.67%)
1
SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.discount_id AS discount_id_3, t0.product_bundle_id AS product_bundle_id_4 FROM slith_discountbundle t0 WHERE t0.product_bundle_id = ?
Parameters:
[
  689
]
3.47 ms
(4.45%)
1
SELECT t0.id AS id_1, t0.platform AS platform_2, t0.wikipedia_url AS wikipedia_url_3, t0.logo_file_name AS logo_file_name_4, t0.old_platform_id AS old_platform_id_5, t0.logo_light_file_name AS logo_light_file_name_6, t0.slug AS slug_7 FROM slith_platform t0 WHERE t0.id = ?
Parameters:
[
  1
]
3.32 ms
(4.27%)
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 = ? LIMIT 1
Parameters:
[
  1
]
2.96 ms
(3.79%)
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 = ? LIMIT 1
Parameters:
[
  "www51.slitherine.com"
]
1.92 ms
(2.46%)
1
SELECT t0.id AS id_1, t0.view_count AS view_count_2, t0.last_time_viewed AS last_time_viewed_3, t0.website_id AS website_id_4, t0.product_id AS product_id_5 FROM slith_productviewcount t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
1.25 ms
(1.60%)
13
SELECT t0.id AS id_1, t0.trigger_time AS trigger_time_2, t0.notification_id AS notification_id_3, t0.action_status_id AS action_status_id_4, t0.notification_type_id AS notification_type_id_5, t0.discount_id AS discount_id_6, t0.product_id AS product_id_7, t0.transaction_id AS transaction_id_8, t0.tournament_id AS tournament_id_9, t0.user_id AS user_id_10 FROM slith_notificationtrigger t0 WHERE t0.notification_id = ?
Parameters:
[
  628
]
1.13 ms
(1.45%)
1
"START TRANSACTION"
Parameters:
[]
0.91 ms
(1.17%)
8
SELECT t0.id AS id_1, t0.steam_app_id AS steam_app_id_2, t0.external_forum_id AS external_forum_id_3, t0.forum_url AS forum_url_4, t0.is_serial_steam_key AS is_serial_steam_key_5, t0.is_preorder AS is_preorder_6, t0.is_indie AS is_indie_7, t0.gog_slug AS gog_slug_8, t0.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_9, t0.is_release_notification_sent AS is_release_notification_sent_10, t0.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_11, t0.steam_app_api_key AS steam_app_api_key_12, t0.gog_app_id AS gog_app_id_13, t0.gog_app_api_key AS gog_app_api_key_14, t0.discord_url AS discord_url_15, t0.epic_app_id AS epic_app_id_16, t0.epic_slug AS epic_slug_17, t0.epic_app_sandbox_id AS epic_app_sandbox_id_18, t0.training_url AS training_url_19, t0.folder_name AS folder_name_20, t0.has_custom_button AS has_custom_button_21, t0.custom_button_title AS custom_button_title_22, t0.custom_button_link AS custom_button_link_23, t0.product_id AS product_id_24, t0.developer_id AS developer_id_25, t0.life_cycle_id AS life_cycle_id_26, t0.forum_id AS forum_id_27 FROM slith_productgame t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
0.87 ms
(1.12%)
8
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 = ?
Parameters:
[
  689
]
0.79 ms
(1.01%)
7
SELECT t0.id AS id_1, t0.contract AS contract_2, t0.price AS price_3, t0.is_round AS is_round_4, t0.old_platform_contract_id AS old_platform_contract_id_5, t0.weight AS weight_6, t0.length AS length_7, t0.width AS width_8, t0.depth AS depth_9, t0.is_free AS is_free_10, t0.contract_priority AS contract_priority_11, t0.game_platform_id AS game_platform_id_12, t0.store_id AS store_id_13, t0.contract_type_id AS contract_type_id_14, t0.shipping_type_id AS shipping_type_id_15, t0.status_id AS status_id_16, t0.product_id AS product_id_17, t0.game_edition_id AS game_edition_id_18, t0.shopping_cart_coupon_id AS shopping_cart_coupon_id_19 FROM slith_gamecontract t0 WHERE t0.game_platform_id = ?
Parameters:
[
  1132
]
0.68 ms
(0.88%)
8
SELECT t0.id AS id_1, t0.is_license_file_revocable AS is_license_file_revocable_2, t0.is_price_calculator_available AS is_price_calculator_available_3, t0.pro_license_encryption_key AS pro_license_encryption_key_4, t0.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_5, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_6, t0.capabilities AS capabilities_7, t0.product_id AS product_id_8 FROM slith_proproduct t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
0.58 ms
(0.74%)
8
SELECT t0.id AS id_1, t0.name AS name_2, t0.streak_key AS streak_key_3, t0.sort_order_index AS sort_order_index_4, t0.internal_product_id AS internal_product_id_5, t0.streak_field_product_type_id AS streak_field_product_type_id_6 FROM slith_streakfieldproduct t0 WHERE t0.internal_product_id = ?
Parameters:
[
  689
]
0.58 ms
(0.74%)
4
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 = ?
Parameters:
[
  2
  7
  2
]
0.53 ms
(0.68%)
1
"COMMIT"
Parameters:
[]
0.53 ms
(0.68%)
7
SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.product_id AS product_id_3 FROM slith_productbundle t0 WHERE t0.product_id = ?
Parameters:
[
  636
]
0.28 ms
(0.36%)
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
Parameters:
[
  2
  2
  "2026-02-25 09:39:35"
  "2026-02-25 09:39:35"
]
0.25 ms
(0.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_file_name AS logo_file_name_4, t0.highlight AS highlight_5, t0.description AS description_6 FROM slith_gameedition t0
Parameters:
[]
0.18 ms
(0.23%)
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 (?)
Parameters:
[
  2
  2
]
0.17 ms
(0.22%)
2
SELECT t0.id AS id_1, t0.status AS status_2, t0.slug AS slug_3 FROM slith_status t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.16 ms
(0.21%)
1
UPDATE slith_productviewcount SET view_count = ?, last_time_viewed = ? WHERE id = ?
Parameters:
[
  6922
  "2026-02-25 09:39:35"
  936
]
0.14 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.language AS language_2, t0.native_script AS native_script_3, t0.old_language_id AS old_language_id_4 FROM slith_language t0 INNER JOIN slith_gameoptions_language ON t0.id = slith_gameoptions_language.slith_language_id WHERE slith_gameoptions_language.slith_gameoptions_id = ?
Parameters:
[
  636
]
0.13 ms
(0.16%)
1
SELECT t0.id AS id_1, t0.store AS store_2, t0.style AS style_3, t0.label AS label_4, t0.show_price AS show_price_5, t0.logo_file_name AS logo_file_name_6, t0.old_store_id AS old_store_id_7, t0.slug AS slug_8, t0.purchase_method_id AS purchase_method_id_9 FROM slith_store t0 INNER JOIN slith_store_platform ON t0.id = slith_store_platform.slith_store_id WHERE slith_store_platform.slith_platform_id = ?
Parameters:
[
  1
]
0.11 ms
(0.14%)
1
SELECT t0.id AS id_1, t0.portrait_image_name AS portrait_image_name_2, t0.landscape_image_name AS landscape_image_name_3, t0.logo_image_name AS logo_image_name_4, t0.icon_image_name AS icon_image_name_5, t0.landscape_image_name_external AS landscape_image_name_external_6, t0.product_id AS product_id_7 FROM slith_productart t0 WHERE t0.product_id = ?
Parameters:
[
  689
]
0.11 ms
(0.14%)
1
SELECT t0.id AS id_1, t0.currency AS currency_2, t0.display_format_full AS display_format_full_3, t0.display_format_short AS display_format_short_4, t0.iso3 AS iso3_5, t0.exchange_rate AS exchange_rate_6, t0.exchange_rate_updated AS exchange_rate_updated_7, t0.is_custom_exchange_rate AS is_custom_exchange_rate_8, t0.is_pay_pal_currency AS is_pay_pal_currency_9, t0.old_currency_id AS old_currency_id_10 FROM slith_currency t0 WHERE t0.iso3 = ? LIMIT 1
Parameters:
[
  "USD"
]
0.10 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.genre AS genre_2, t0.old_genre_id AS old_genre_id_3 FROM slith_genre t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.09 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.theatre AS theatre_2, t0.old_theatre_id AS old_theatre_id_3 FROM slith_theatre t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.09 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.developer_name AS developer_name_2, t0.old_developer_id AS old_developer_id_3, t0.email AS email_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.status_id AS status_id_7 FROM slith_developer t0 WHERE t0.id = ?
Parameters:
[
  8
]
0.09 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.unit_scale AS unit_scale_2, t0.old_unit_scale_id AS old_unit_scale_id_3 FROM slith_unitscale t0 WHERE t0.id = ?
Parameters:
[
  7
]
0.09 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.contract_type AS contract_type_2, t0.label AS label_3, t0.style AS style_4, t0.shipping AS shipping_5, t0.old_contract_type_id AS old_contract_type_id_6, t0.slug AS slug_7, t0.super_contract_type_id AS super_contract_type_id_8 FROM slith_contracttype t0 WHERE t0.id = ?
Parameters:
[
  12
]
0.09 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.old_difficulty_id AS old_difficulty_id_3 FROM slith_difficulty t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.09 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.timeline AS timeline_2, t0.old_timeline_id AS old_timeline_id_3 FROM slith_timeline t0 WHERE t0.id = ?
Parameters:
[
  8
]
0.08 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.discount_method AS discount_method_2, t0.slug AS slug_3 FROM slith_discountmethod t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.08 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.artificial_intelligence AS artificial_intelligence_2, t0.old_artificial_intelligence_id AS old_artificial_intelligence_id_3 FROM slith_artificialintelligence t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.08 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.play_style AS play_style_2, t0.old_play_style_id AS old_play_style_id_3 FROM slith_playstyle t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.07 ms
(0.09%)
1
SELECT t0.id AS id_1, t0.multiplayer AS multiplayer_2, t0.old_multiplayer_id AS old_multiplayer_id_3 FROM slith_multiplayer t0 WHERE t0.id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\DiscountContract 96
App\Entity\Discount 25
App\Entity\GameContract 21
App\Entity\NotificationTrigger 13
App\Entity\Notification 13
App\Entity\Product 8
App\Entity\ProductArt 8
App\Entity\GameContent 7
App\Entity\ProductGame 7
App\Entity\GameOptions 7
App\Entity\GamePlatform 7
App\Entity\Language 5
App\Entity\BlockLocation 4
App\Entity\Block 4
App\Entity\GameEdition 4
App\Entity\Timeline 3
App\Entity\Theatre 3
App\Entity\ContractType 3
App\Entity\Status 2
App\Entity\Helpdesk 2
App\Entity\Website 2
App\Entity\Forum 2
App\Entity\ProductType 2
App\Entity\Genre 2
App\Entity\Multiplayer 2
App\Entity\Store 2
App\Entity\ProductViewCount 2
App\Entity\PurchaseMethod 2
App\Entity\ShippingType 2
App\Entity\Config 1
App\Entity\Currency 1
App\Entity\User 1
App\Entity\PbemServer 1
App\Entity\Newsletter 1
App\Entity\NewsletterProvider 1
App\Entity\GlobalAnnouncement 1
App\Entity\Family 1
App\Entity\ProductBundle 1
App\Entity\Developer 1
App\Entity\GameLifeCycle 1
App\Entity\Difficulty 1
App\Entity\PlayStyle 1
App\Entity\ArtificialIntelligence 1
App\Entity\UnitScale 1
App\Entity\Platform 1
App\Entity\DiscountBundle 1
App\Entity\DiscountMethod 1
App\Entity\ActionStatus 1
App\Entity\NotificationType 1
App\Entity\NotificationStatus 1
App\Entity\NotificationTemplate 1
App\Entity\Manual 1

Entities Mapping

Class Mapping errors
App\Entity\WebServer No errors.
App\Entity\Status No errors.
App\Entity\Config No errors.
App\Entity\Language No errors.
App\Entity\Currency
  • The mappings App\Entity\Currency#bluesnapCountries and App\Entity\Country#bluesnapCurrency are inconsistent with each other.
App\Entity\User No errors.
App\Entity\Helpdesk No errors.
App\Entity\Website No errors.
App\Entity\PbemServer No errors.
App\Entity\PaymentCreditCard No errors.
App\Entity\Newsletter No errors.
App\Entity\NewsletterProvider No errors.
App\Entity\Forum No errors.
App\Entity\Product No errors.
App\Entity\News No errors.
App\Entity\Page No errors.
App\Entity\BetaGame No errors.
App\Entity\GlobalAnnouncement No errors.
App\Entity\ProductViewLog No errors.
App\Entity\Block No errors.
App\Entity\GameContractMessage No errors.
App\Entity\DiscountWebsiteImage No errors.
App\Entity\GlobalVariable No errors.
App\Entity\NotificationType No errors.
App\Entity\Skin No errors.
App\Entity\Mailing No errors.
App\Entity\MailingTemplate No errors.
App\Entity\BetaGameForumGroup No errors.
App\Entity\CacheForumGroup No errors.
App\Entity\ContactHelpdeskDepartment No errors.
App\Entity\ProductUserWebsiteForumBadge No errors.
App\Entity\Event No errors.
App\Entity\WebsiteDomain No errors.
App\Entity\NewsletterSubscriptionHistory No errors.
App\Entity\Country
  • The association App\Entity\Country#bluesnapCurrency refers to the inverse side field App\Entity\Currency#blusnapCountries which does not exist.
App\Entity\CustomerInvoice No errors.
App\Entity\BankAccount No errors.
App\Entity\LicenseInvoice No errors.
App\Entity\CustomInvoice No errors.
App\Entity\LicenseQuote No errors.
App\Entity\CustomQuote No errors.
App\Entity\CustomerQuote No errors.
App\Entity\BlockLocation No errors.
App\Entity\ProductBundle No errors.
App\Entity\ProductArt No errors.
App\Entity\GameOptions No errors.
App\Entity\GamePlatform No errors.
App\Entity\GameContract No errors.
App\Entity\GameContent No errors.
App\Entity\Genre No errors.
App\Entity\Timeline No errors.
App\Entity\Theatre No errors.
App\Entity\Difficulty No errors.
App\Entity\PlayStyle No errors.
App\Entity\ArtificialIntelligence No errors.
App\Entity\GameEditor No errors.
App\Entity\TurnScale No errors.
App\Entity\Multiplayer No errors.
App\Entity\UnitScale No errors.
App\Entity\GameScreen No errors.
App\Entity\Family No errors.
App\Entity\HotProduct No errors.
App\Entity\ProductType No errors.
App\Entity\ProductGame No errors.
App\Entity\Developer No errors.
App\Entity\GameLifeCycle No errors.
App\Entity\GameVideo No errors.
App\Entity\Download No errors.
App\Entity\MediaReview No errors.
App\Entity\DownloadLink No errors.
App\Entity\Tournament No errors.
App\Entity\Wishlist No errors.
App\Entity\ProductViewCount No errors.
App\Entity\UserProductLog No errors.
App\Entity\Leaderboard No errors.
App\Entity\LeaderboardProvider No errors.
App\Entity\AudienceType No errors.
App\Entity\NotificationUser No errors.
App\Entity\NotificationTrigger No errors.
App\Entity\LauncherSale No errors.
App\Entity\ProDownload No errors.
App\Entity\OTRSQueue No errors.
App\Entity\ProProduct No errors.
App\Entity\ProProductPrice No errors.
App\Entity\CrossSale No errors.
App\Entity\Platform No errors.
App\Entity\ProLicenseQuoteRequestLog No errors.
App\Entity\ELORatingLeaderboard No errors.
App\Entity\ContactProRequest No errors.
App\Entity\GameSlide No errors.
App\Entity\GameFAQ No errors.
App\Entity\GameRequirements No errors.
App\Entity\ProductUserMayLike No errors.
App\Entity\ProductMerchandise No errors.
App\Entity\MerchandiseType No errors.
App\Entity\StreakFieldProduct No errors.
App\Entity\StreakFieldProductType No errors.
App\Entity\DiscountBundle No errors.
App\Entity\UserGame No errors.
App\Entity\Serial No errors.
App\Entity\SteamKey No errors.
App\Entity\SerialSummaryCache No errors.
App\Entity\SteamKeySummaryCache No errors.
App\Entity\ProUserGameLicense No errors.
App\Entity\PlayFabLeaderboardCache No errors.
App\Entity\PbemGame No errors.
App\Entity\ProUserGameLicenseIssueCount No errors.
App\Entity\PingPBEMUserChallengeMessage No errors.
App\Entity\OnlineStore No errors.
App\Entity\Manual No errors.
App\Entity\Store No errors.
App\Entity\ContractType No errors.
App\Entity\ShippingType No errors.
App\Entity\DiscountContract No errors.
App\Entity\GameEdition No errors.
App\Entity\ShoppingCartItem No errors.
App\Entity\ShoppingCartCoupon No errors.
App\Entity\CouponContract No errors.
App\Entity\MerchandiseSize No errors.
App\Entity\MerchandiseColor No errors.
App\Entity\Discount No errors.
App\Entity\Notification No errors.
App\Entity\ActionStatus No errors.
App\Entity\Transaction No errors.
App\Entity\NotificationStatus No errors.
App\Entity\NotificationTemplate No errors.
App\Entity\DiscountMethod No errors.
App\Entity\JobPosting No errors.
App\Entity\Dealer No errors.
App\Entity\HttpLinkServer No errors.
App\Entity\Coupon No errors.
App\Entity\CouponCode No errors.
App\Entity\StripeTaxRate No errors.
App\Entity\EventTicket No errors.
App\Entity\ProInstallationType No errors.
App\Entity\ProLicenseMultiplayerServerType No errors.
App\Entity\PurchaseMethod No errors.
App\Entity\CouponContractType No errors.
App\Entity\GameLanguage No errors.
App\Entity\BetaApplication No errors.