Query Metrics
538
Database Queries
36
Different statements
168.26 ms
Query time
2
Invalid entities
314
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
48.17 ms (28.63%) |
100 |
SELECT s0_.id AS id_0, s0_.ldap_guid AS ldap_guid_1, s0_.username AS username_2, s0_.password AS password_3, s0_.email AS email_4, s0_.is_active AS is_active_5, s0_.first_name AS first_name_6, s0_.last_name AS last_name_7, s0_.last_login AS last_login_8, s0_.old_matrix_user_id AS old_matrix_user_id_9, s0_.pbem_slitherine_user_id AS pbem_slitherine_user_id_10, s0_.bluesnap_id AS bluesnap_id_11, s0_.same_login_id AS same_login_id_12, s0_.is_wishlist_notification_active AS is_wishlist_notification_active_13, s0_.pro_client_id AS pro_client_id_14, s0_.company AS company_15, s0_.is_tournament_notification_active AS is_tournament_notification_active_16, s0_.security_token AS security_token_17, s0_.security_token_time AS security_token_time_18, s0_.is_welcome_email_sent AS is_welcome_email_sent_19, s0_.department AS department_20, s0_.last_active AS last_active_21, s0_.is_mailchimp_subscribe_requested AS is_mailchimp_subscribe_requested_22, s0_.is_mailchimp_subscribe_completed AS is_mailchimp_subscribe_completed_23, s0_.is_temporary AS is_temporary_24, s0_.is_new_pro_user_survey_email_sent AS is_new_pro_user_survey_email_sent_25, s0_.is_pro_teammate_member AS is_pro_teammate_member_26, s0_.pro_role_added_at AS pro_role_added_at_27, s0_.hide_multiplayer_profile AS hide_multiplayer_profile_28, s0_.discord_id AS discord_id_29, s0_.discord_username AS discord_username_30, s0_.has_discord_account AS has_discord_account_31, s0_.is_pro_buyer AS is_pro_buyer_32, s0_.pro_mailings_signature AS pro_mailings_signature_33, s0_.steam_id AS steam_id_34, s0_.steam_username AS steam_username_35, s0_.address_id AS address_id_36, s0_.shopping_cart_address_id AS shopping_cart_address_id_37, s0_.developer_id AS developer_id_38, s0_.country_id AS country_id_39, s0_.timezone_id AS timezone_id_40 FROM slith_user s0_ WHERE s0_.same_login_id = ? LIMIT 1
Parameters:
[
"19799fd1-4b69-479c-840c-013b321b0fcc"
]
|
|
27.20 ms (16.17%) |
3 |
"COMMIT"
Parameters:
[] |
|
10.31 ms (6.13%) |
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"
]
|
|
9.30 ms (5.53%) |
100 |
SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.name AS name_3, t0.slug AS slug_4, t0.status_id AS status_id_5, t0.user_id AS user_id_6 FROM slith_dealer t0 WHERE t0.user_id = ?
Parameters:
[
143406
]
|
|
8.41 ms (5.00%) |
100 |
SELECT t0.id AS id_1, t0.city AS city_2, t0.street_address AS street_address_3, t0.postal_code AS postal_code_4, t0.company AS company_5, t0.email AS email_6, t0.streak_box_key AS streak_box_key_7, t0.streak_contact_key AS streak_contact_key_8, t0.user_id AS user_id_9, t0.country_id AS country_id_10, t0.province_id AS province_id_11, t0.service_id AS service_id_12 FROM slith_prouser t0 WHERE t0.user_id = ?
Parameters:
[
143406
]
|
|
7.26 ms (4.31%) |
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 ] |
|
6.92 ms (4.11%) |
100 |
INSERT INTO slith_eloratingleaderboardcachepageitem (rank, username, rating, hide_profile, elo_rating_leaderboard_cache_page_id, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 1 "Witan" 1565 0 19098 143406 ] |
|
6.39 ms (3.80%) |
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:
[
389
]
|
|
5.92 ms (3.52%) |
100 |
DELETE FROM slith_eloratingleaderboardcachepageitem WHERE id = ?
Parameters:
[
1575611
]
|
|
5.62 ms (3.34%) |
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 = ?
Parameters:
[ 2 7 2 ] |
|
5.09 ms (3.03%) |
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:
[
389
]
|
|
5.07 ms (3.01%) |
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 06:27:49" "2026-02-25 06:27:49" ] |
|
3.59 ms (2.13%) |
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:
[
389
]
|
|
3.16 ms (1.88%) |
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
]
|
|
3.01 ms (1.79%) |
1 |
SELECT s0_.id AS id_0, s0_.last_updated_time AS last_updated_time_1, s0_.page_number AS page_number_2, s0_.elo_rating_leaderboard_cache_id AS elo_rating_leaderboard_cache_id_3 FROM slith_eloratingleaderboardcachepage s0_ INNER JOIN slith_eloratingleaderboardcache s1_ ON s0_.elo_rating_leaderboard_cache_id = s1_.id WHERE s0_.page_number = ? AND s1_.elo_rating_leaderboard_id = ?
Parameters:
[ 1 10 ] |
|
2.18 ms (1.29%) |
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:
[ "field-of-glory-ii" "slitherine" 2 ] |
|
1.72 ms (1.03%) |
3 |
SELECT s0_.id AS id_0, s0_.last_updated_time AS last_updated_time_1, s0_.total_items AS total_items_2, s0_.elo_rating_leaderboard_id AS elo_rating_leaderboard_id_3 FROM slith_eloratingleaderboardcache s0_ WHERE s0_.elo_rating_leaderboard_id = ?
Parameters:
[
10
]
|
|
1.66 ms (0.99%) |
2 |
SELECT s0_.id AS id_0, s0_.rank AS rank_1, s0_.username AS username_2, s0_.rating AS rating_3, s0_.hide_profile AS hide_profile_4, s0_.elo_rating_leaderboard_cache_page_id AS elo_rating_leaderboard_cache_page_id_5, s0_.user_id AS user_id_6 FROM slith_eloratingleaderboardcachepageitem s0_ INNER JOIN slith_eloratingleaderboardcachepage s1_ ON s0_.elo_rating_leaderboard_cache_page_id = s1_.id INNER JOIN slith_eloratingleaderboardcache s2_ ON s1_.elo_rating_leaderboard_cache_id = s2_.id WHERE s2_.elo_rating_leaderboard_id = ? AND s1_.page_number = ? AND s1_.last_updated_time > ?
Parameters:
[ 10 1 "2026-02-25 06:22:49" ] |
|
1.16 ms (0.69%) |
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:
[
389
]
|
|
1.03 ms (0.61%) |
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:
[
389
]
|
|
0.85 ms (0.50%) |
1 |
SELECT t0.id AS id_1, t0.rank AS rank_2, t0.username AS username_3, t0.rating AS rating_4, t0.hide_profile AS hide_profile_5, t0.elo_rating_leaderboard_cache_page_id AS elo_rating_leaderboard_cache_page_id_6, t0.user_id AS user_id_7 FROM slith_eloratingleaderboardcachepageitem t0 WHERE t0.elo_rating_leaderboard_cache_page_id = ?
Parameters:
[
19089
]
|
|
0.68 ms (0.40%) |
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
Parameters:
[
"copyright"
]
|
|
0.65 ms (0.38%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.background_image_name AS background_image_name_2, s0_.description AS description_3, s0_.server AS server_4, s0_.is_active_cache AS is_active_cache_5, s0_.last_cache_update_time AS last_cache_update_time_6, s0_.ttl_page_cache_overwrite AS ttl_page_cache_overwrite_7, s0_.max_items_per_page_overwrite AS max_items_per_page_overwrite_8, s0_.status_id AS status_id_9, s0_.pbem_server_id AS pbem_server_id_10, s0_.leaderboard_type_id AS leaderboard_type_id_11, s0_.product_id AS product_id_12 FROM slith_eloratingleaderboard s0_ WHERE s0_.product_id = ? AND s0_.leaderboard_type_id = ?
Parameters:
[ 389 3 ] |
|
0.61 ms (0.37%) |
1 |
SELECT s0_.id AS id_0, s0_.leaderboard_type AS leaderboard_type_1, s0_.slug AS slug_2, s0_.server_value AS server_value_3 FROM slith_leaderboardtype s0_ WHERE s0_.slug = ?
Parameters:
[
"live"
]
|
|
0.42 ms (0.25%) |
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"
]
|
|
0.37 ms (0.22%) |
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:
[
389
]
|
|
0.24 ms (0.14%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pbem_game_id AS pbem_game_id_3, t0.pbem_game_url AS pbem_game_url_4, t0.pbem_game_identifier AS pbem_game_identifier_5, t0.pbem_enabled AS pbem_enabled_6, t0.pbem_password AS pbem_password_7, t0.pbem_serials_enabled AS pbem_serials_enabled_8, t0.pbem_tournaments_test_enabled AS pbem_tournaments_test_enabled_9, t0.pbem_tournaments_live_enabled AS pbem_tournaments_live_enabled_10, t0.version_test AS version_test_11, t0.version_beta AS version_beta_12, t0.version_live AS version_live_13, t0.pbem_limit_backup_files AS pbem_limit_backup_files_14, t0.is_active AS is_active_15, t0.is_cheating_system_enabled AS is_cheating_system_enabled_16, t0.is_auto_ban_enabled AS is_auto_ban_enabled_17, t0.autoban_tracking_days AS autoban_tracking_days_18, t0.autoban_offending_actions_count_for_trigger AS autoban_offending_actions_count_for_trigger_19, t0.autoban_ban_days AS autoban_ban_days_20, t0.is_send_email_active AS is_send_email_active_21, t0.threshold_level_one AS threshold_level_one_22, t0.threshold_level_two AS threshold_level_two_23, t0.threshold_level_three AS threshold_level_three_24, t0.tracking_frame_days AS tracking_frame_days_25, t0.is_support_only_simple_password AS is_support_only_simple_password_26, t0.product_game_id AS product_game_id_27, t28.id AS id_29, t28.is_missing_normal_serials AS is_missing_normal_serials_30, t28.is_missing_virtual_serials AS is_missing_virtual_serials_31, t28.product_id AS product_id_32, t0.pbem_server_id AS pbem_server_id_33 FROM slith_pbemgame t0 LEFT JOIN slith_tempserialvalidationproductlog t28 ON t28.product_id = t0.id WHERE t0.product_game_id = ?
Parameters:
[
389
]
|
|
0.19 ms (0.11%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
0.17 ms (0.10%) |
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:
[
389
]
|
|
0.16 ms (0.09%) |
1 |
UPDATE slith_eloratingleaderboardcache SET last_updated_time = ? WHERE id = ?
Parameters:
[ "2026-02-25 06:27:50" 9 ] |
|
0.16 ms (0.09%) |
1 |
INSERT INTO slith_eloratingleaderboardcachepage (last_updated_time, page_number, elo_rating_leaderboard_cache_id) VALUES (?, ?, ?)
Parameters:
[ "2026-02-25 06:27:50" 1 9 ] |
|
0.13 ms (0.08%) |
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:
[
389
]
|
|
0.12 ms (0.07%) |
1 |
DELETE FROM slith_eloratingleaderboardcachepage WHERE id = ?
Parameters:
[
19089
]
|
|
0.12 ms (0.07%) |
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.11 ms (0.07%) |
1 |
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 = ?
Parameters:
[
5
]
|
|
0.10 ms (0.06%) |
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:
[
389
]
|
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\User | 101 |
| App\Entity\EloRatingLeaderboardCachePageItem | 100 |
| App\Entity\ShoppingCartAddress | 65 |
| App\Entity\Country | 4 |
| App\Entity\TimeZone | 4 |
| App\Entity\Status | 2 |
| App\Entity\Helpdesk | 2 |
| App\Entity\PbemServer | 2 |
| App\Entity\EloRatingLeaderboardCachePage | 2 |
| App\Entity\Config | 1 |
| App\Entity\Language | 1 |
| App\Entity\Currency | 1 |
| App\Entity\Website | 1 |
| App\Entity\Forum | 1 |
| App\Entity\Newsletter | 1 |
| App\Entity\NewsletterProvider | 1 |
| App\Entity\GlobalAnnouncement | 1 |
| App\Entity\BlockLocation | 1 |
| App\Entity\Block | 1 |
| App\Entity\Product | 1 |
| App\Entity\GameContent | 1 |
| App\Entity\GameOptions | 1 |
| App\Entity\Genre | 1 |
| App\Entity\Timeline | 1 |
| App\Entity\Theatre | 1 |
| App\Entity\Difficulty | 1 |
| App\Entity\PlayStyle | 1 |
| App\Entity\ArtificialIntelligence | 1 |
| App\Entity\GameEditor | 1 |
| App\Entity\Multiplayer | 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 |
| App\Entity\LeaderboardType | 1 |
| App\Entity\ELORatingLeaderboard | 1 |
| App\Entity\EloRatingLeaderboardCache | 1 |
| App\Entity\PbemGame | 1 |
| App\Entity\TempSerialValidationProductLog | 1 |