Query Metrics
159
Database Queries
61
Different statements
34.43 ms
Query time
2
Invalid entities
222
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.19 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.23 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.18 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 06:27:47" "2026-02-25 06:27:47" ] |
| 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.16 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.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 2 2 ] |
| 11 | 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:
[
"home-page"
]
|
| 12 | 0.16 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.12 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 | 0.65 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_.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-black-sea-battle-pack-1" "slitherine" 2 ] |
| 16 | 0.11 ms |
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:
[
658
]
|
| 17 | 0.09 ms |
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:
[
658
]
|
| 18 | 0.11 ms |
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:
[
658
]
|
| 19 | 0.14 ms |
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:
[
658
]
|
| 20 | 0.10 ms |
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:
[
658
]
|
| 21 | 0.10 ms |
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:
[
658
]
|
| 22 | 0.12 ms |
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:
[
658
]
|
| 23 | 0.09 ms |
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:
[
658
]
|
| 24 | 0.09 ms |
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:
[
658
]
|
| 25 | 0.10 ms |
SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.requirements AS requirements_3, t0.release_date AS release_date_4, t0.old_game_platform_id AS old_game_platform_id_5, t0.short_url AS short_url_6, t0.product_id AS product_id_7, t0.platform_id AS platform_id_8, t0.status_id AS status_id_9 FROM slith_gameplatform t0 WHERE t0.product_id = ?
Parameters:
[
658
]
|
| 26 | 0.10 ms |
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
]
|
| 27 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.forum_url AS forum_url_3, t0.thread_url_template AS thread_url_template_4, t0.slitherine_same_login_website_id AS slitherine_same_login_website_id_5 FROM slith_forum t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 28 | 0.14 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.post_date AS post_date_3, s0_.description AS description_4, s0_.image_file_name AS image_file_name_5, s0_.sort_order_index AS sort_order_index_6, s0_.product_id AS product_id_7, s0_.status_id AS status_id_8, s0_.download_link_type_id AS download_link_type_id_9 FROM slith_downloadlink s0_ WHERE s0_.status_id IN (?) AND s0_.product_id = ? AND s0_.download_link_type_id = ?
Parameters:
[ 2 658 3 ] |
| 29 | 0.12 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.post_date AS post_date_3, s0_.description AS description_4, s0_.image_file_name AS image_file_name_5, s0_.sort_order_index AS sort_order_index_6, s0_.product_id AS product_id_7, s0_.status_id AS status_id_8, s0_.download_link_type_id AS download_link_type_id_9 FROM slith_downloadlink s0_ WHERE s0_.status_id IN (?) AND s0_.product_id = ? AND s0_.download_link_type_id = ?
Parameters:
[ 2 658 4 ] |
| 30 | 0.12 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.post_date AS post_date_3, s0_.description AS description_4, s0_.image_file_name AS image_file_name_5, s0_.sort_order_index AS sort_order_index_6, s0_.product_id AS product_id_7, s0_.status_id AS status_id_8, s0_.download_link_type_id AS download_link_type_id_9 FROM slith_downloadlink s0_ WHERE s0_.status_id IN (?) AND s0_.product_id = ? AND s0_.download_link_type_id = ?
Parameters:
[ 2 658 5 ] |
| 31 | 0.12 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.post_date AS post_date_3, s0_.description AS description_4, s0_.image_file_name AS image_file_name_5, s0_.sort_order_index AS sort_order_index_6, s0_.product_id AS product_id_7, s0_.status_id AS status_id_8, s0_.download_link_type_id AS download_link_type_id_9 FROM slith_downloadlink s0_ WHERE s0_.status_id IN (?) AND s0_.product_id = ? AND s0_.download_link_type_id = ?
Parameters:
[ 2 658 1 ] |
| 32 | 0.13 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.post_date AS post_date_2, s0_.version AS version_3, s0_.description AS description_4, s0_.file_name AS file_name_5, s0_.old_download_id AS old_download_id_6, s0_.old_file_id AS old_file_id_7, s0_.changelog AS changelog_8, s0_.slug AS slug_9, s0_.sort_order_index AS sort_order_index_10, s0_.product_id AS product_id_11, s0_.status_id AS status_id_12 FROM slith_download s0_ WHERE s0_.status_id IN (?) AND s0_.product_id = ?
Parameters:
[ 2 658 ] |
| 33 | 5.90 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_.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, s2_.id AS id_17, s2_.is_default AS is_default_18, s2_.requirements AS requirements_19, s2_.release_date AS release_date_20, s2_.old_game_platform_id AS old_game_platform_id_21, s2_.short_url AS short_url_22, s3_.id AS id_23, s3_.contract AS contract_24, s3_.price AS price_25, s3_.is_round AS is_round_26, s3_.old_platform_contract_id AS old_platform_contract_id_27, s3_.weight AS weight_28, s3_.length AS length_29, s3_.width AS width_30, s3_.depth AS depth_31, s3_.is_free AS is_free_32, s3_.contract_priority AS contract_priority_33, s0_.status_id AS status_id_34, s0_.family_id AS family_id_35, s0_.product_type_id AS product_type_id_36, s0_.otrsqueue_id AS otrsqueue_id_37, s0_.product_game_serial_pool_id AS product_game_serial_pool_id_38, s1_.product_id AS product_id_39, s2_.product_id AS product_id_40, s2_.platform_id AS platform_id_41, s2_.status_id AS status_id_42, s3_.game_platform_id AS game_platform_id_43, s3_.store_id AS store_id_44, s3_.contract_type_id AS contract_type_id_45, s3_.shipping_type_id AS shipping_type_id_46, s3_.status_id AS status_id_47, s3_.product_id AS product_id_48, s3_.game_edition_id AS game_edition_id_49, s3_.shopping_cart_coupon_id AS shopping_cart_coupon_id_50 FROM slith_product s0_ INNER JOIN slith_productart s1_ ON s0_.id = s1_.product_id INNER JOIN slith_status s4_ ON s0_.status_id = s4_.id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id INNER JOIN slith_gameplatform s2_ ON s0_.id = s2_.product_id INNER JOIN slith_status s7_ ON s2_.status_id = s7_.id AND (s7_.id IN (?)) INNER JOIN slith_platform s8_ ON s2_.platform_id = s8_.id INNER JOIN slith_store_platform s10_ ON s8_.id = s10_.slith_platform_id INNER JOIN slith_store s9_ ON s9_.id = s10_.slith_store_id INNER JOIN slith_gamecontract s3_ ON s0_.id = s3_.product_id INNER JOIN slith_status s11_ ON s3_.status_id = s11_.id AND (s11_.id IN (?)) INNER JOIN slith_productgame s12_ ON s0_.id = s12_.product_id INNER JOIN slith_productgame_product s14_ ON s12_.id = s14_.slith_productgame_id INNER JOIN slith_product s13_ ON s13_.id = s14_.slith_product_id WHERE s13_.slug = ? AND s5_.slug = ? AND s4_.id IN (?) ORDER BY s0_.latest_release_date DESC
Parameters:
[ 2 2 "combat-mission-black-sea-battle-pack-1" "slitherine" 2 ] |
| 34 | 0.18 ms |
SELECT s0_.id AS id_0, s0_.to_assign_serial AS to_assign_serial_1, s0_.image_file_name AS image_file_name_2, s0_.title AS title_3, s0_.description AS description_4, s0_.required_discord_account AS required_discord_account_5, s0_.product_id AS product_id_6, s0_.status_id AS status_id_7 FROM slith_betagame s0_ INNER JOIN slith_product s1_ ON s0_.product_id = s1_.id INNER JOIN slith_betagame_website s3_ ON s0_.id = s3_.slith_betagame_id INNER JOIN slith_website s2_ ON s2_.id = s3_.slith_website_id INNER JOIN slith_betagameforumgroup s4_ ON s0_.id = s4_.beta_game_id WHERE s2_.slug = ? AND s1_.id = ? AND s0_.status_id IN (?) AND s4_.status_id IN (?) AND s4_.is_private = 0 ORDER BY s0_.id DESC LIMIT 1
Parameters:
[ "slitherine" 658 2 2 ] |
| 35 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.background_image_name AS background_image_name_3, t0.description AS description_4, t0.server AS server_5, t0.is_active_cache AS is_active_cache_6, t0.last_cache_update_time AS last_cache_update_time_7, t0.ttl_page_cache_overwrite AS ttl_page_cache_overwrite_8, t0.max_items_per_page_overwrite AS max_items_per_page_overwrite_9, t0.status_id AS status_id_10, t0.pbem_server_id AS pbem_server_id_11, t0.leaderboard_type_id AS leaderboard_type_id_12, t0.product_id AS product_id_13 FROM slith_eloratingleaderboard t0 WHERE t0.product_id = ?
Parameters:
[
658
]
|
| 36 | 0.15 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.post_date AS post_date_3, s0_.description AS description_4, s0_.image_file_name AS image_file_name_5, s0_.sort_order_index AS sort_order_index_6, s0_.product_id AS product_id_7, s0_.status_id AS status_id_8, s0_.download_link_type_id AS download_link_type_id_9 FROM slith_downloadlink s0_ INNER JOIN slith_product s1_ ON s0_.product_id = s1_.id AND (s1_.id = ?) INNER JOIN slith_downloadlinktype s2_ ON s0_.download_link_type_id = s2_.id AND (s2_.slug = ?) WHERE s0_.status_id IN (?) ORDER BY s0_.sort_order_index ASC LIMIT 1
Parameters:
[ 658 "manual" 2 ] |
| 37 | 0.13 ms |
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 INNER JOIN slith_productgame_product ON t0.id = slith_productgame_product.slith_productgame_id WHERE slith_productgame_product.slith_product_id = ?
Parameters:
[
658
]
|
| 38 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.old_game_id AS old_game_id_4, t0.slug AS slug_5, t0.earliest_release_date AS earliest_release_date_6, t0.latest_release_date AS latest_release_date_7, t0.smallest_price AS smallest_price_8, t0.old_game_url AS old_game_url_9, t0.is_release_date_visible AS is_release_date_visible_10, t0.google_conversion_code AS google_conversion_code_11, t12.id AS id_13, t12.description AS description_14, t12.features AS features_15, t12.requirements AS requirements_16, t12.game_data AS game_data_17, t12.discover_more_link AS discover_more_link_18, t12.historical_background AS historical_background_19, t12.lore AS lore_20, t12.product_id AS product_id_21, t22.id AS id_23, t22.discount_percent AS discount_percent_24, t22.product_id AS product_id_25, t26.id AS id_27, t26.min_players AS min_players_28, t26.max_players AS max_players_29, t26.product_id AS product_id_30, t26.genre_id AS genre_id_31, t26.timeline_id AS timeline_id_32, t26.theatre_id AS theatre_id_33, t26.difficulty_id AS difficulty_id_34, t26.play_style_id AS play_style_id_35, t26.artificial_intelligence_id AS artificial_intelligence_id_36, t26.game_editor_id AS game_editor_id_37, t26.turn_scale_id AS turn_scale_id_38, t26.multiplayer_id AS multiplayer_id_39, t26.unit_scale_id AS unit_scale_id_40, t41.id AS id_42, t41.portrait_image_name AS portrait_image_name_43, t41.landscape_image_name AS landscape_image_name_44, t41.logo_image_name AS logo_image_name_45, t41.icon_image_name AS icon_image_name_46, t41.landscape_image_name_external AS landscape_image_name_external_47, t41.product_id AS product_id_48, t0.status_id AS status_id_49, t0.family_id AS family_id_50, t0.product_type_id AS product_type_id_51, t52.id AS id_53, t52.steam_app_id AS steam_app_id_54, t52.external_forum_id AS external_forum_id_55, t52.forum_url AS forum_url_56, t52.is_serial_steam_key AS is_serial_steam_key_57, t52.is_preorder AS is_preorder_58, t52.is_indie AS is_indie_59, t52.gog_slug AS gog_slug_60, t52.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_61, t52.is_release_notification_sent AS is_release_notification_sent_62, t52.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_63, t52.steam_app_api_key AS steam_app_api_key_64, t52.gog_app_id AS gog_app_id_65, t52.gog_app_api_key AS gog_app_api_key_66, t52.discord_url AS discord_url_67, t52.epic_app_id AS epic_app_id_68, t52.epic_slug AS epic_slug_69, t52.epic_app_sandbox_id AS epic_app_sandbox_id_70, t52.training_url AS training_url_71, t52.folder_name AS folder_name_72, t52.has_custom_button AS has_custom_button_73, t52.custom_button_title AS custom_button_title_74, t52.custom_button_link AS custom_button_link_75, t52.product_id AS product_id_76, t52.developer_id AS developer_id_77, t52.life_cycle_id AS life_cycle_id_78, t52.forum_id AS forum_id_79, t80.id AS id_81, t80.name AS name_82, t80.web_apipublisher_key AS web_apipublisher_key_83, t80.background_image_name AS background_image_name_84, t80.leaderboard_title_id AS leaderboard_title_id_85, t80.secret_key AS secret_key_86, t80.product_id AS product_id_87, t80.status_id AS status_id_88, t80.leaderboard_provider_id AS leaderboard_provider_id_89, t0.otrsqueue_id AS otrsqueue_id_90, t91.id AS id_92, t91.is_license_file_revocable AS is_license_file_revocable_93, t91.is_price_calculator_available AS is_price_calculator_available_94, t91.pro_license_encryption_key AS pro_license_encryption_key_95, t91.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_96, t91.pro_license_generation_alert_email AS pro_license_generation_alert_email_97, t91.capabilities AS capabilities_98, t91.product_id AS product_id_99, t0.product_game_serial_pool_id AS product_game_serial_pool_id_100, t101.id AS id_102, t101.description AS description_103, t101.product_id AS product_id_104, t101.belongs_to_product_id AS belongs_to_product_id_105, t101.merchandise_type_id AS merchandise_type_id_106, t107.id AS id_108, t107.name AS name_109, t107.streak_key AS streak_key_110, t107.sort_order_index AS sort_order_index_111, t107.internal_product_id AS internal_product_id_112, t107.streak_field_product_type_id AS streak_field_product_type_id_113 FROM slith_product t0 LEFT JOIN slith_gamecontent t12 ON t12.product_id = t0.id LEFT JOIN slith_productbundle t22 ON t22.product_id = t0.id LEFT JOIN slith_gameoptions t26 ON t26.product_id = t0.id LEFT JOIN slith_productart t41 ON t41.product_id = t0.id LEFT JOIN slith_productgame t52 ON t52.product_id = t0.id LEFT JOIN slith_leaderboard t80 ON t80.product_id = t0.id LEFT JOIN slith_proproduct t91 ON t91.product_id = t0.id LEFT JOIN slith_productmerchandise t101 ON t101.product_id = t0.id LEFT JOIN slith_streakfieldproduct t107 ON t107.internal_product_id = t0.id INNER JOIN slith_productgame_product ON t0.id = slith_productgame_product.slith_product_id WHERE slith_productgame_product.slith_productgame_id = ?
Parameters:
[
658
]
|
| 39 | 0.10 ms |
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:
[
654
]
|
| 40 | 3.44 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.introduction AS introduction_2, s0_.article AS article_3, s0_.link AS link_4, s0_.redirect AS redirect_5, s0_.start_date AS start_date_6, s0_.end_date AS end_date_7, s0_.image_file_name AS image_file_name_8, s0_.spotlight_image_file_name AS spotlight_image_file_name_9, s0_.homepage_banner_image_file_name AS homepage_banner_image_file_name_10, s0_.old_news_id AS old_news_id_11, s0_.posted_date AS posted_date_12, s0_.slug AS slug_13, s0_.old_id AS old_id_14, s0_.has_countdown AS has_countdown_15, s0_.countdown_end_date AS countdown_end_date_16, s0_.countdown_timer_color AS countdown_timer_color_17, s0_.countdown_timer_legend_color AS countdown_timer_legend_color_18, s0_.countdown_timer_font_size AS countdown_timer_font_size_19, s0_.countdown_timer_legend_font_size AS countdown_timer_legend_font_size_20, s0_.countdown_position_left AS countdown_position_left_21, s0_.countdown_position_bottom AS countdown_position_bottom_22, s0_.news_has_box_overlay AS news_has_box_overlay_23, s0_.spotlight_has_box_overlay AS spotlight_has_box_overlay_24, s0_.news_box_overlay_text AS news_box_overlay_text_25, s0_.news_overlay_text AS news_overlay_text_26, s0_.spotlight_box_overlay_text AS spotlight_box_overlay_text_27, s0_.spotlight_overlay_text AS spotlight_overlay_text_28, s0_.status_id AS status_id_29 FROM slith_news s0_ INNER JOIN slith_news_newszone s2_ ON s0_.id = s2_.slith_news_id INNER JOIN slith_newszone s1_ ON s1_.id = s2_.slith_newszone_id INNER JOIN slith_news_product s4_ ON s0_.id = s4_.slith_news_id INNER JOIN slith_product s3_ ON s3_.id = s4_.slith_product_id INNER JOIN slith_news_website s6_ ON s0_.id = s6_.slith_news_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id WHERE s0_.status_id IN (?) AND s5_.id = ? AND s1_.id = ? AND s3_.id = ? AND s0_.start_date <= ? AND ((s0_.end_date IS NULL OR s0_.end_date >= ?)) ORDER BY s0_.start_date DESC
Parameters:
[ 2 2 3 654 "2026-02-25 06:27:47" "2026-02-25 06:27:47" ] |
| 41 | 0.15 ms |
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 INNER JOIN slith_productgame_product ON t0.id = slith_productgame_product.slith_productgame_id WHERE slith_productgame_product.slith_product_id = ?
Parameters:
[
654
]
|
| 42 | 0.35 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.introduction AS introduction_2, s0_.article AS article_3, s0_.link AS link_4, s0_.redirect AS redirect_5, s0_.start_date AS start_date_6, s0_.end_date AS end_date_7, s0_.image_file_name AS image_file_name_8, s0_.spotlight_image_file_name AS spotlight_image_file_name_9, s0_.homepage_banner_image_file_name AS homepage_banner_image_file_name_10, s0_.old_news_id AS old_news_id_11, s0_.posted_date AS posted_date_12, s0_.slug AS slug_13, s0_.old_id AS old_id_14, s0_.has_countdown AS has_countdown_15, s0_.countdown_end_date AS countdown_end_date_16, s0_.countdown_timer_color AS countdown_timer_color_17, s0_.countdown_timer_legend_color AS countdown_timer_legend_color_18, s0_.countdown_timer_font_size AS countdown_timer_font_size_19, s0_.countdown_timer_legend_font_size AS countdown_timer_legend_font_size_20, s0_.countdown_position_left AS countdown_position_left_21, s0_.countdown_position_bottom AS countdown_position_bottom_22, s0_.news_has_box_overlay AS news_has_box_overlay_23, s0_.spotlight_has_box_overlay AS spotlight_has_box_overlay_24, s0_.news_box_overlay_text AS news_box_overlay_text_25, s0_.news_overlay_text AS news_overlay_text_26, s0_.spotlight_box_overlay_text AS spotlight_box_overlay_text_27, s0_.spotlight_overlay_text AS spotlight_overlay_text_28, s0_.status_id AS status_id_29 FROM slith_news s0_ INNER JOIN slith_news_newszone s2_ ON s0_.id = s2_.slith_news_id INNER JOIN slith_newszone s1_ ON s1_.id = s2_.slith_newszone_id INNER JOIN slith_news_product s4_ ON s0_.id = s4_.slith_news_id INNER JOIN slith_product s3_ ON s3_.id = s4_.slith_product_id INNER JOIN slith_news_website s6_ ON s0_.id = s6_.slith_news_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id WHERE s0_.status_id IN (?) AND s5_.id = ? AND s1_.id = ? AND s3_.id = ? AND s0_.start_date <= ? AND ((s0_.end_date IS NULL OR s0_.end_date >= ?)) ORDER BY s0_.start_date DESC
Parameters:
[ 2 2 3 658 "2026-02-25 06:27:47" "2026-02-25 06:27:47" ] |
| 43 | 0.16 ms |
SELECT s0_.id AS id_0, s0_.discount_percent AS discount_percent_1, s1_.id AS id_2, s1_.name AS name_3, s1_.introduction AS introduction_4, s1_.old_game_id AS old_game_id_5, s1_.slug AS slug_6, s1_.earliest_release_date AS earliest_release_date_7, s1_.latest_release_date AS latest_release_date_8, s1_.smallest_price AS smallest_price_9, s1_.old_game_url AS old_game_url_10, s1_.is_release_date_visible AS is_release_date_visible_11, s1_.google_conversion_code AS google_conversion_code_12, s0_.product_id AS product_id_13, s1_.status_id AS status_id_14, s1_.family_id AS family_id_15, s1_.product_type_id AS product_type_id_16, s1_.otrsqueue_id AS otrsqueue_id_17, s1_.product_game_serial_pool_id AS product_game_serial_pool_id_18 FROM slith_productbundle s0_ INNER JOIN slith_product s1_ ON s0_.product_id = s1_.id INNER JOIN slith_productbundle_product s3_ ON s0_.id = s3_.slith_productbundle_id INNER JOIN slith_product s2_ ON s2_.id = s3_.slith_product_id WHERE s2_.id = ? AND s1_.status_id IN (?)
Parameters:
[ 658 2 ] |
| 44 | 0.09 ms |
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:
[
659
]
|
| 45 | 0.09 ms |
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:
[
659
]
|
| 46 | 0.08 ms |
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:
[
659
]
|
| 47 | 0.10 ms |
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:
[
659
]
|
| 48 | 0.08 ms |
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:
[
659
]
|
| 49 | 0.08 ms |
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:
[
659
]
|
| 50 | 0.09 ms |
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:
[
659
]
|
| 51 | 0.08 ms |
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:
[
659
]
|
| 52 | 0.21 ms |
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:
[
659
]
|
| 53 | 1.69 ms |
SELECT s0_.id AS id_0, s0_.steam_key_type AS steam_key_type_1, s0_.slug AS slug_2 FROM slith_steamkeytype s0_ WHERE s0_.slug = ?
Parameters:
[
"regular"
]
|
| 54 | 4.02 ms |
SELECT s0_.id AS id_0, s0_.steam_key AS steam_key_1, s0_.old_steam_key_id AS old_steam_key_id_2, s0_.issue_date AS issue_date_3, s0_.is_disabled AS is_disabled_4, s0_.product_game_id AS product_game_id_5, s0_.serial_id AS serial_id_6, s0_.steam_key_type_id AS steam_key_type_id_7 FROM slith_steamkey s0_ WHERE s0_.product_game_id = ? AND s0_.steam_key_type_id = ? AND s0_.serial_id IS NULL AND s0_.is_disabled = 0 LIMIT 1
Parameters:
[ 658 1 ] |
| 55 | 0.19 ms |
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:
[] |
| 56 | 1.26 ms |
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:
[
838
]
|
| 57 | 0.09 ms |
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:
[
838
]
|
| 58 | 0.09 ms |
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:
[
838
]
|
| 59 | 0.13 ms |
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:
[
838
]
|
| 60 | 0.08 ms |
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:
[
838
]
|
| 61 | 0.08 ms |
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:
[
838
]
|
| 62 | 0.51 ms |
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:
[
838
]
|
| 63 | 0.08 ms |
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:
[
838
]
|
| 64 | 0.11 ms |
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:
[
838
]
|
| 65 | 0.09 ms |
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:
[
826
]
|
| 66 | 0.07 ms |
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:
[
826
]
|
| 67 | 0.08 ms |
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:
[
826
]
|
| 68 | 0.12 ms |
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:
[
826
]
|
| 69 | 0.08 ms |
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:
[
826
]
|
| 70 | 0.08 ms |
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:
[
826
]
|
| 71 | 0.10 ms |
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:
[
826
]
|
| 72 | 0.07 ms |
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:
[
826
]
|
| 73 | 0.07 ms |
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:
[
826
]
|
| 74 | 0.08 ms |
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:
[
680
]
|
| 75 | 0.07 ms |
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:
[
680
]
|
| 76 | 0.08 ms |
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:
[
680
]
|
| 77 | 0.11 ms |
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:
[
680
]
|
| 78 | 0.07 ms |
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:
[
680
]
|
| 79 | 0.08 ms |
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:
[
680
]
|
| 80 | 0.10 ms |
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:
[
680
]
|
| 81 | 0.07 ms |
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:
[
680
]
|
| 82 | 0.08 ms |
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:
[
680
]
|
| 83 | 0.09 ms |
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:
[
834
]
|
| 84 | 0.07 ms |
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:
[
834
]
|
| 85 | 0.08 ms |
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:
[
834
]
|
| 86 | 0.11 ms |
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:
[
834
]
|
| 87 | 0.08 ms |
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:
[
834
]
|
| 88 | 0.08 ms |
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:
[
834
]
|
| 89 | 0.10 ms |
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:
[
834
]
|
| 90 | 0.08 ms |
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:
[
834
]
|
| 91 | 0.07 ms |
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:
[
834
]
|
| 92 | 0.08 ms |
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:
[
824
]
|
| 93 | 0.07 ms |
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:
[
824
]
|
| 94 | 0.08 ms |
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:
[
824
]
|
| 95 | 0.11 ms |
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:
[
824
]
|
| 96 | 0.07 ms |
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:
[
824
]
|
| 97 | 0.10 ms |
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:
[
824
]
|
| 98 | 0.10 ms |
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:
[
824
]
|
| 99 | 0.07 ms |
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:
[
824
]
|
| 100 | 0.07 ms |
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:
[
824
]
|
| 101 | 0.12 ms |
SELECT t0.id AS id_1, t0.video_url AS video_url_2, t0.comment AS comment_3, t0.title AS title_4, t0.sort_order_index AS sort_order_index_5, t0.product_id AS product_id_6 FROM slith_gamevideo t0 WHERE t0.product_id = ?
Parameters:
[
658
]
|
| 102 | 0.09 ms |
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
]
|
| 103 | 0.14 ms |
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
]
|
| 104 | 0.13 ms |
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:
[
1147
]
|
| 105 | 0.10 ms |
SELECT t0.id AS id_1, t0.life_cycle AS life_cycle_2, t0.slug AS slug_3, t0.old_game_status_id AS old_game_status_id_4 FROM slith_gamelifecycle t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 106 | 0.12 ms |
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:
[
1398
]
|
| 107 | 0.16 ms |
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:
[
89
]
|
| 108 | 0.10 ms |
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
]
|
| 109 | 0.14 ms |
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:
[
100
]
|
| 110 | 0.10 ms |
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:
[
443
]
|
| 111 | 0.14 ms |
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:
[
124
]
|
| 112 | 0.09 ms |
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:
[
553
]
|
| 113 | 0.13 ms |
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:
[
134
]
|
| 114 | 0.09 ms |
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:
[
579
]
|
| 115 | 0.12 ms |
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:
[
140
]
|
| 116 | 0.09 ms |
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:
[
599
]
|
| 117 | 0.12 ms |
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:
[
152
]
|
| 118 | 0.09 ms |
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:
[
631
]
|
| 119 | 0.13 ms |
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:
[
163
]
|
| 120 | 0.08 ms |
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:
[
724
]
|
| 121 | 0.12 ms |
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:
[
171
]
|
| 122 | 0.12 ms |
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:
[
173
]
|
| 123 | 0.13 ms |
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:
[
176
]
|
| 124 | 0.09 ms |
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:
[
787
]
|
| 125 | 0.12 ms |
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:
[
178
]
|
| 126 | 0.13 ms |
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:
[
186
]
|
| 127 | 0.12 ms |
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:
[
198
]
|
| 128 | 0.12 ms |
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:
[
240
]
|
| 129 | 0.12 ms |
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:
[
254
]
|
| 130 | 0.12 ms |
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:
[
264
]
|
| 131 | 0.12 ms |
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:
[
265
]
|
| 132 | 0.09 ms |
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
]
|
| 133 | 0.11 ms |
SELECT t0.id AS id_1, t0.screen_image_file_name AS screen_image_file_name_2, t0.upload_time AS upload_time_3, t0.comment AS comment_4, t0.sort_order_index AS sort_order_index_5, t0.product_id AS product_id_6 FROM slith_gamescreen t0 WHERE t0.product_id = ?
Parameters:
[
658
]
|
| 134 | 0.11 ms |
SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.requirements AS requirements_3, t0.release_date AS release_date_4, t0.old_game_platform_id AS old_game_platform_id_5, t0.short_url AS short_url_6, t0.product_id AS product_id_7, t0.platform_id AS platform_id_8, t0.status_id AS status_id_9 FROM slith_gameplatform t0 WHERE t0.product_id = ?
Parameters:
[
654
]
|
| 135 | 0.11 ms |
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:
[
1144
]
|
| 136 | 0.09 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.slug AS slug_3 FROM slith_status t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 137 | 0.10 ms |
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:
[
1396
]
|
| 138 | 0.13 ms |
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:
[
141
]
|
| 139 | 0.09 ms |
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:
[
604
]
|
| 140 | 0.13 ms |
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:
[
156
]
|
| 141 | 0.08 ms |
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:
[
645
]
|
| 142 | 0.19 ms |
SELECT t0.id AS id_1, t0.tournament_id AS tournament_id_2, t0.visible AS visible_3, t0.tournament_title AS tournament_title_4, t0.game_id AS game_id_5, t0.rounds_num AS rounds_num_6, t0.current_round_num AS current_round_num_7, t0.joined_players_num AS joined_players_num_8, t0.max_players AS max_players_9, t0.start_date AS start_date_10, t0.round_time AS round_time_11, t0.round_points AS round_points_12, t0.bye_points AS bye_points_13, t0.next_round_start_date AS next_round_start_date_14, t0.status AS status_15, t0.forum_url AS forum_url_16, t0.server AS server_17, t0.current_round_start_date AS current_round_start_date_18, t0.current_round_end_date AS current_round_end_date_19, t0.scores_draws_last_update AS scores_draws_last_update_20, t0.hidden AS hidden_21, t0.is_private AS is_private_22, t0.is_tournament_with_problem AS is_tournament_with_problem_23, t0.description AS description_24, t0.is_ranked AS is_ranked_25, t0.created_at AS created_at_26, t0.num_players_from_child AS num_players_from_child_27, t0.product_id AS product_id_28, t0.tournament_server_id AS tournament_server_id_29, t30.id AS id_31, t30.name AS name_32, t30.description AS description_33, t30.date_created AS date_created_34, t30.date_finished AS date_finished_35, t30.email_subject AS email_subject_36, t30.notification_status_id AS notification_status_id_37, t30.notification_type_id AS notification_type_id_38, t30.notification_template_id AS notification_template_id_39, t30.wishlist_id AS wishlist_id_40, t30.product_id AS product_id_41, t30.discount_id AS discount_id_42, t30.transaction_id AS transaction_id_43, t30.tournament_id AS tournament_id_44, t45.id AS id_46, t45.trigger_time AS trigger_time_47, t45.notification_id AS notification_id_48, t45.action_status_id AS action_status_id_49, t45.notification_type_id AS notification_type_id_50, t45.discount_id AS discount_id_51, t45.product_id AS product_id_52, t45.transaction_id AS transaction_id_53, t45.tournament_id AS tournament_id_54, t45.user_id AS user_id_55, t0.tournament_status_id AS tournament_status_id_56, t0.pbem_server_id AS pbem_server_id_57, t0.tournament_type_id AS tournament_type_id_58, t0.parent_tournament_id AS parent_tournament_id_59 FROM slith_tournament t0 LEFT JOIN slith_notification t30 ON t30.tournament_id = t0.id LEFT JOIN slith_notificationtrigger t45 ON t45.tournament_id = t0.id WHERE t0.product_id = ?
Parameters:
[
658
]
|
| 143 | 0.19 ms |
SELECT t0.id AS id_1, t0.tournament_id AS tournament_id_2, t0.visible AS visible_3, t0.tournament_title AS tournament_title_4, t0.game_id AS game_id_5, t0.rounds_num AS rounds_num_6, t0.current_round_num AS current_round_num_7, t0.joined_players_num AS joined_players_num_8, t0.max_players AS max_players_9, t0.start_date AS start_date_10, t0.round_time AS round_time_11, t0.round_points AS round_points_12, t0.bye_points AS bye_points_13, t0.next_round_start_date AS next_round_start_date_14, t0.status AS status_15, t0.forum_url AS forum_url_16, t0.server AS server_17, t0.current_round_start_date AS current_round_start_date_18, t0.current_round_end_date AS current_round_end_date_19, t0.scores_draws_last_update AS scores_draws_last_update_20, t0.hidden AS hidden_21, t0.is_private AS is_private_22, t0.is_tournament_with_problem AS is_tournament_with_problem_23, t0.description AS description_24, t0.is_ranked AS is_ranked_25, t0.created_at AS created_at_26, t0.num_players_from_child AS num_players_from_child_27, t0.product_id AS product_id_28, t0.tournament_server_id AS tournament_server_id_29, t30.id AS id_31, t30.name AS name_32, t30.description AS description_33, t30.date_created AS date_created_34, t30.date_finished AS date_finished_35, t30.email_subject AS email_subject_36, t30.notification_status_id AS notification_status_id_37, t30.notification_type_id AS notification_type_id_38, t30.notification_template_id AS notification_template_id_39, t30.wishlist_id AS wishlist_id_40, t30.product_id AS product_id_41, t30.discount_id AS discount_id_42, t30.transaction_id AS transaction_id_43, t30.tournament_id AS tournament_id_44, t45.id AS id_46, t45.trigger_time AS trigger_time_47, t45.notification_id AS notification_id_48, t45.action_status_id AS action_status_id_49, t45.notification_type_id AS notification_type_id_50, t45.discount_id AS discount_id_51, t45.product_id AS product_id_52, t45.transaction_id AS transaction_id_53, t45.tournament_id AS tournament_id_54, t45.user_id AS user_id_55, t0.tournament_status_id AS tournament_status_id_56, t0.pbem_server_id AS pbem_server_id_57, t0.tournament_type_id AS tournament_type_id_58, t0.parent_tournament_id AS parent_tournament_id_59 FROM slith_tournament t0 LEFT JOIN slith_notification t30 ON t30.tournament_id = t0.id LEFT JOIN slith_notificationtrigger t45 ON t45.tournament_id = t0.id WHERE t0.product_id = ?
Parameters:
[
654
]
|
| 144 | 0.10 ms |
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
]
|
| 145 | 0.12 ms |
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:
[
658
]
|
| 146 | 0.10 ms |
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
]
|
| 147 | 0.08 ms |
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
]
|
| 148 | 0.08 ms |
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:
[
3
]
|
| 149 | 0.08 ms |
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
]
|
| 150 | 0.09 ms |
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
]
|
| 151 | 0.09 ms |
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
]
|
| 152 | 0.08 ms |
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
]
|
| 153 | 0.11 ms |
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:
[
658
]
|
| 154 | 0.08 ms |
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
]
|
| 155 | 0.09 ms |
SELECT t0.id AS id_1, t0.reviewer AS reviewer_2, t0.review_date AS review_date_3, t0.review AS review_4, t0.link AS link_5, t0.quote AS quote_6, t0.product_id AS product_id_7, t0.status_id AS status_id_8 FROM slith_mediareview t0 WHERE t0.product_id = ?
Parameters:
[
658
]
|
| 156 | 0.10 ms |
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:
[
659
]
|
| 157 | 0.13 ms |
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
]
|
| 158 | 0.09 ms |
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
]
|
| 159 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.old_game_id AS old_game_id_4, t0.slug AS slug_5, t0.earliest_release_date AS earliest_release_date_6, t0.latest_release_date AS latest_release_date_7, t0.smallest_price AS smallest_price_8, t0.old_game_url AS old_game_url_9, t0.is_release_date_visible AS is_release_date_visible_10, t0.google_conversion_code AS google_conversion_code_11, t12.id AS id_13, t12.description AS description_14, t12.features AS features_15, t12.requirements AS requirements_16, t12.game_data AS game_data_17, t12.discover_more_link AS discover_more_link_18, t12.historical_background AS historical_background_19, t12.lore AS lore_20, t12.product_id AS product_id_21, t22.id AS id_23, t22.discount_percent AS discount_percent_24, t22.product_id AS product_id_25, t26.id AS id_27, t26.min_players AS min_players_28, t26.max_players AS max_players_29, t26.product_id AS product_id_30, t26.genre_id AS genre_id_31, t26.timeline_id AS timeline_id_32, t26.theatre_id AS theatre_id_33, t26.difficulty_id AS difficulty_id_34, t26.play_style_id AS play_style_id_35, t26.artificial_intelligence_id AS artificial_intelligence_id_36, t26.game_editor_id AS game_editor_id_37, t26.turn_scale_id AS turn_scale_id_38, t26.multiplayer_id AS multiplayer_id_39, t26.unit_scale_id AS unit_scale_id_40, t41.id AS id_42, t41.portrait_image_name AS portrait_image_name_43, t41.landscape_image_name AS landscape_image_name_44, t41.logo_image_name AS logo_image_name_45, t41.icon_image_name AS icon_image_name_46, t41.landscape_image_name_external AS landscape_image_name_external_47, t41.product_id AS product_id_48, t0.status_id AS status_id_49, t0.family_id AS family_id_50, t0.product_type_id AS product_type_id_51, t52.id AS id_53, t52.steam_app_id AS steam_app_id_54, t52.external_forum_id AS external_forum_id_55, t52.forum_url AS forum_url_56, t52.is_serial_steam_key AS is_serial_steam_key_57, t52.is_preorder AS is_preorder_58, t52.is_indie AS is_indie_59, t52.gog_slug AS gog_slug_60, t52.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_61, t52.is_release_notification_sent AS is_release_notification_sent_62, t52.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_63, t52.steam_app_api_key AS steam_app_api_key_64, t52.gog_app_id AS gog_app_id_65, t52.gog_app_api_key AS gog_app_api_key_66, t52.discord_url AS discord_url_67, t52.epic_app_id AS epic_app_id_68, t52.epic_slug AS epic_slug_69, t52.epic_app_sandbox_id AS epic_app_sandbox_id_70, t52.training_url AS training_url_71, t52.folder_name AS folder_name_72, t52.has_custom_button AS has_custom_button_73, t52.custom_button_title AS custom_button_title_74, t52.custom_button_link AS custom_button_link_75, t52.product_id AS product_id_76, t52.developer_id AS developer_id_77, t52.life_cycle_id AS life_cycle_id_78, t52.forum_id AS forum_id_79, t80.id AS id_81, t80.name AS name_82, t80.web_apipublisher_key AS web_apipublisher_key_83, t80.background_image_name AS background_image_name_84, t80.leaderboard_title_id AS leaderboard_title_id_85, t80.secret_key AS secret_key_86, t80.product_id AS product_id_87, t80.status_id AS status_id_88, t80.leaderboard_provider_id AS leaderboard_provider_id_89, t0.otrsqueue_id AS otrsqueue_id_90, t91.id AS id_92, t91.is_license_file_revocable AS is_license_file_revocable_93, t91.is_price_calculator_available AS is_price_calculator_available_94, t91.pro_license_encryption_key AS pro_license_encryption_key_95, t91.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_96, t91.pro_license_generation_alert_email AS pro_license_generation_alert_email_97, t91.capabilities AS capabilities_98, t91.product_id AS product_id_99, t0.product_game_serial_pool_id AS product_game_serial_pool_id_100, t101.id AS id_102, t101.description AS description_103, t101.product_id AS product_id_104, t101.belongs_to_product_id AS belongs_to_product_id_105, t101.merchandise_type_id AS merchandise_type_id_106, t107.id AS id_108, t107.name AS name_109, t107.streak_key AS streak_key_110, t107.sort_order_index AS sort_order_index_111, t107.internal_product_id AS internal_product_id_112, t107.streak_field_product_type_id AS streak_field_product_type_id_113 FROM slith_product t0 LEFT JOIN slith_gamecontent t12 ON t12.product_id = t0.id LEFT JOIN slith_productbundle t22 ON t22.product_id = t0.id LEFT JOIN slith_gameoptions t26 ON t26.product_id = t0.id LEFT JOIN slith_productart t41 ON t41.product_id = t0.id LEFT JOIN slith_productgame t52 ON t52.product_id = t0.id LEFT JOIN slith_leaderboard t80 ON t80.product_id = t0.id LEFT JOIN slith_proproduct t91 ON t91.product_id = t0.id LEFT JOIN slith_productmerchandise t101 ON t101.product_id = t0.id LEFT JOIN slith_streakfieldproduct t107 ON t107.internal_product_id = t0.id INNER JOIN slith_productbundle_product ON t0.id = slith_productbundle_product.slith_product_id WHERE slith_productbundle_product.slith_productbundle_id = ?
Parameters:
[
659
]
|
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 | 36 |
| App\Entity\Discount | 20 |
| App\Entity\NotificationTrigger | 10 |
| App\Entity\Notification | 10 |
| App\Entity\Product | 8 |
| App\Entity\ProductArt | 8 |
| App\Entity\GameContent | 7 |
| App\Entity\GameOptions | 7 |
| App\Entity\ProductGame | 7 |
| App\Entity\Developer | 6 |
| App\Entity\Language | 5 |
| App\Entity\GameScreen | 5 |
| App\Entity\BlockLocation | 4 |
| App\Entity\Block | 4 |
| App\Entity\Theatre | 4 |
| App\Entity\DownloadLinkType | 4 |
| App\Entity\GameEdition | 4 |
| App\Entity\Family | 4 |
| App\Entity\GameContract | 4 |
| App\Entity\Timeline | 3 |
| App\Entity\PlayStyle | 3 |
| App\Entity\ContractType | 3 |
| App\Entity\Tournament | 3 |
| App\Entity\Status | 2 |
| App\Entity\Helpdesk | 2 |
| App\Entity\PbemServer | 2 |
| App\Entity\Forum | 2 |
| App\Entity\Genre | 2 |
| App\Entity\Difficulty | 2 |
| App\Entity\Multiplayer | 2 |
| App\Entity\ProductType | 2 |
| App\Entity\GamePlatform | 2 |
| App\Entity\GameEditor | 2 |
| App\Entity\Store | 2 |
| App\Entity\PurchaseMethod | 2 |
| App\Entity\Config | 1 |
| App\Entity\Currency | 1 |
| App\Entity\User | 1 |
| App\Entity\Website | 1 |
| App\Entity\Newsletter | 1 |
| App\Entity\NewsletterProvider | 1 |
| App\Entity\GlobalAnnouncement | 1 |
| App\Entity\ArtificialIntelligence | 1 |
| App\Entity\UnitScale | 1 |
| App\Entity\GameLifeCycle | 1 |
| App\Entity\Platform | 1 |
| App\Entity\Download | 1 |
| App\Entity\NewsZone | 1 |
| App\Entity\News | 1 |
| App\Entity\ProductBundle | 1 |
| App\Entity\SteamKeyType | 1 |
| App\Entity\SteamKey | 1 |
| App\Entity\GameVideo | 1 |
| App\Entity\DiscountMethod | 1 |
| App\Entity\ActionStatus | 1 |
| App\Entity\NotificationType | 1 |
| App\Entity\NotificationStatus | 1 |
| App\Entity\NotificationTemplate | 1 |
| App\Entity\ShippingType | 1 |
| App\Entity\TournamentServer | 1 |
| App\Entity\TournamentStatus | 1 |
| App\Entity\TournamentType | 1 |
| App\Entity\Manual | 1 |
| App\Entity\DiscountBundle | 1 |