GET https://www51.slitherine.com/product/combat-mission-battle-for-normandy-market-garden

Query Metrics

25 Database Queries
19 Different statements
12.92 ms Query time
2 Invalid entities
39 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.55 ms
(27.45%)
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"
]
3.44 ms
(26.66%)
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"
]
2.54 ms
(19.63%)
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.66 ms
(5.09%)
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_.portrait_image_name AS portrait_image_name_12, s1_.landscape_image_name AS landscape_image_name_13, s1_.logo_image_name AS logo_image_name_14, s1_.icon_image_name AS icon_image_name_15, s1_.landscape_image_name_external AS landscape_image_name_external_16, s0_.status_id AS status_id_17, s0_.family_id AS family_id_18, s0_.product_type_id AS product_type_id_19, s0_.otrsqueue_id AS otrsqueue_id_20, s0_.product_game_serial_pool_id AS product_game_serial_pool_id_21, s1_.product_id AS product_id_22 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 WHERE s0_.slug = ? AND s2_.slug = ? AND s0_.status_id IN (?)
Parameters:
[
  "combat-mission-battle-for-normandy-market-garden"
  "slitherine"
  2
]
0.59 ms
(4.56%)
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.39 ms
(3.03%)
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"
]
0.32 ms
(2.50%)
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
]
0.22 ms
(1.70%)
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 08:09:34"
  "2026-02-25 08:09:34"
]
0.16 ms
(1.20%)
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.14 ms
(1.09%)
1
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:
[
  758
]
0.12 ms
(0.95%)
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 = ?
Parameters:
[
  758
]
0.11 ms
(0.88%)
1
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:
[
  758
]
0.11 ms
(0.85%)
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:
[
  758
]
0.10 ms
(0.80%)
1
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:
[
  758
]
0.10 ms
(0.79%)
1
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:
[
  758
]
0.10 ms
(0.78%)
1
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:
[
  758
]
0.09 ms
(0.70%)
1
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:
[
  758
]
0.09 ms
(0.69%)
1
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:
[
  758
]
0.09 ms
(0.66%)
1
SELECT t0.id AS id_1, t0.product_type AS product_type_2, t0.slug AS slug_3 FROM slith_producttype 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\BlockLocation 4
App\Entity\Block 4
App\Entity\Status 2
App\Entity\Helpdesk 2
App\Entity\Forum 2
App\Entity\Config 1
App\Entity\Language 1
App\Entity\Currency 1
App\Entity\User 1
App\Entity\Website 1
App\Entity\PbemServer 1
App\Entity\Newsletter 1
App\Entity\NewsletterProvider 1
App\Entity\GlobalAnnouncement 1
App\Entity\Product 1
App\Entity\GameContent 1
App\Entity\GameOptions 1
App\Entity\Genre 1
App\Entity\Timeline 1
App\Entity\Difficulty 1
App\Entity\PlayStyle 1
App\Entity\ArtificialIntelligence 1
App\Entity\Multiplayer 1
App\Entity\UnitScale 1
App\Entity\Family 1
App\Entity\ProductType 1
App\Entity\ProductGame 1
App\Entity\Developer 1
App\Entity\GameLifeCycle 1
App\Entity\ProductArt 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\ProductArt No errors.
App\Entity\GamePlatform No errors.
App\Entity\GameContent No errors.
App\Entity\ProductBundle No errors.
App\Entity\GameOptions 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\Manual No errors.
App\Entity\GameScreen No errors.
App\Entity\GameContract 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\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\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.