Query Metrics
15
Database Queries
9
Different statements
4.56 ms
Query time
2
Invalid entities
22
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.20 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.20 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.17 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.17 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 04:28:19" "2026-02-25 04:28:19" ] |
| 7 | 0.10 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 ] |
| 9 | 0.08 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:
[
"store-footer"
]
|
| 10 | 0.14 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 2 2 ] |
| 11 | 0.09 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:
[
"home-page"
]
|
| 12 | 0.14 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 4 2 ] |
| 13 | 0.08 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:
[
"product-page"
]
|
| 14 | 0.13 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 5 2 ] |
| 15 | 2.62 ms |
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 "big-rts-bundle" "slitherine" 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\BlockLocation | 4 |
| App\Entity\Block | 4 |
| 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 |