GET https://www51.slitherine.com/login

Query Metrics

8 Database Queries
8 Different statements
9.17 ms Query time
2 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 7.86 ms
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 0.31 ms
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 0.26 ms
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"
]
4 0.18 ms
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
]
5 0.11 ms
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"
]
6 0.17 ms
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:14:42"
  "2026-02-25 06:14:42"
]
7 0.12 ms
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"
]
8 0.15 ms
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
]

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\Status 2
App\Entity\Helpdesk 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\Forum 1
App\Entity\Newsletter 1
App\Entity\NewsletterProvider 1
App\Entity\GlobalAnnouncement 1
App\Entity\BlockLocation 1
App\Entity\Block 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.