GET http://d.pre.re/en/tournaments/6

Query Metrics

25 Database Queries
15 Different statements
69.05 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 5.27 ms
SELECT t0.score_logic AS score_logic_1, t0.rank_limit AS rank_limit_2, t0.prize_currency AS prize_currency_3, t0.prizes AS prizes_4, t0.theme AS theme_5, t0.max_rebuy_count AS max_rebuy_count_6, t0.rebuy_amount AS rebuy_amount_7, t0.start_date AS start_date_8, t0.end_date AS end_date_9, t0.crypto AS crypto_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.partner_id AS partner_id_13, t0.type, t0.start_balance AS start_balance_14, t0.use_billing_account AS use_billing_account_15, t0.currency AS currency_16, t0.freerounds_count AS freerounds_count_17 FROM tournaments t0 WHERE t0.id = ? AND t0.type IN ('regular', 'freeround')
Parameters:
[
  "6"
]
2 5.16 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM site_games s0_ INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id AND t1_.type IN ('regular', 'freeround') AND (t1_.id = ?) LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id WHERE (p3_.enabled = ? OR p4_.enabled = ?) AND s0_.enabled = ?
Parameters:
[
  6
  1
  1
  1
]
3 3.91 ms
SELECT DISTINCT s0_.id AS id_0, s0_.slug AS slug_1 FROM site_games s0_ INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id AND t1_.type IN ('regular', 'freeround') AND (t1_.id = ?) LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id WHERE (p3_.enabled = ? OR p4_.enabled = ?) AND s0_.enabled = ? ORDER BY s0_.slug ASC LIMIT 20
Parameters:
[
  6
  1
  1
  1
]
4 3.64 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.image AS image_2, s0_.background_image AS background_image_3, s0_.position AS position_4, s0_.rank AS rank_5, s0_.enabled AS enabled_6, s0_.disabling_reason AS disabling_reason_7, s0_.demo_available AS demo_available_8, s0_.released_at AS released_at_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.category AS category_12, s0_.country_list AS country_list_13, s0_.country_list_type AS country_list_type_14, s0_.desktop_provider_game_projection_id AS desktop_provider_game_projection_id_15, s0_.mobile_provider_game_projection_id AS mobile_provider_game_projection_id_16 FROM site_games s0_ INNER JOIN tournament_site_games t2_ ON s0_.id = t2_.site_game_id INNER JOIN tournaments t1_ ON t1_.id = t2_.tournament_id AND t1_.type IN ('regular', 'freeround') AND (t1_.id = ?) LEFT JOIN provider_game_projections p3_ ON s0_.desktop_provider_game_projection_id = p3_.id LEFT JOIN provider_game_projections p4_ ON s0_.mobile_provider_game_projection_id = p4_.id WHERE (p3_.enabled = ? OR p4_.enabled = ?) AND s0_.enabled = ? AND s0_.id IN (?, ?) ORDER BY s0_.slug ASC
Parameters:
[
  6
  1
  1
  1
  102
  101
]
5 2.28 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM tags t0 INNER JOIN site_games_tags ON t0.id = site_games_tags.tag_id WHERE site_games_tags.site_game_id = ?
Parameters:
[
  102
]
6 1.35 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM tags t0 INNER JOIN site_games_tags ON t0.id = site_games_tags.tag_id WHERE site_games_tags.site_game_id = ?
Parameters:
[
  101
]
7 1.91 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM site_game_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  102
]
8 1.21 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.81 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM site_game_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  101
]
10 0.80 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 1.59 ms
SELECT s0_.id AS id_0, s0_.provider AS provider_1, s0_.active AS active_2, s0_.created_at AS created_at_3 FROM social_providers s0_ WHERE s0_.active = ?
Parameters:
[
  1
]
12 1.93 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM tournament_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
13 2.07 ms
SELECT b0_.id AS id_0, b0_.enabled AS enabled_1, b0_.name AS name_2, b0_.visibility AS visibility_3, b0_.country_list AS country_list_4, b0_.position AS position_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7 FROM banners b0_ WHERE b0_.enabled = true ORDER BY b0_.position ASC
Parameters:
[]
14 4.21 ms
SELECT t0_.id AS id_0, t0_.score AS score_1, t0_.score_data AS score_data_2, t0_.prize AS prize_3, t0_.token AS token_4, t0_.rebuy_count AS rebuy_count_5, t0_.reset_at AS reset_at_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8, t0_.tournament_id AS tournament_id_9, t0_.account_id AS account_id_10, t0_.user_id AS user_id_11 FROM tournament_sessions t0_ WHERE t0_.tournament_id = ? ORDER BY t0_.score DESC LIMIT 4
Parameters:
[
  6
]
15 4.32 ms
SELECT t0.id AS id_1, t0.balance AS balance_2, t0.currency AS currency_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blocked_balance AS blocked_balance_6, t0.user_id AS user_id_7, t0.type, t0.sum_deposits AS sum_deposits_8, t0.sum_withdrawals AS sum_withdrawals_9, t0.active AS active_10 FROM accounts t0 WHERE t0.id = ? AND t0.type IN ('game', 'billing', 'funny_game')
Parameters:
[
  3
]
16 1.18 ms
SELECT t0.id AS id_1, t0.balance AS balance_2, t0.currency AS currency_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blocked_balance AS blocked_balance_6, t0.user_id AS user_id_7, t0.type, t0.sum_deposits AS sum_deposits_8, t0.sum_withdrawals AS sum_withdrawals_9, t0.active AS active_10 FROM accounts t0 WHERE t0.id = ? AND t0.type IN ('game', 'billing', 'funny_game')
Parameters:
[
  4
]
17 18.19 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_canonical AS email_canonical_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.password_requested_at AS password_requested_at_6, t0.roles_array AS roles_array_7, t0.default_name AS default_name_8, t0.name AS name_9, t0.partner_reward_percent AS partner_reward_percent_10, t0.phone_number AS phone_number_11, t0.phone_number_confirmed_at AS phone_number_confirmed_at_12, t0.phone_number_confirmation_code AS phone_number_confirmation_code_13, t0.phone_number_requested_at AS phone_number_requested_at_14, t0.phone_number_attempt AS phone_number_attempt_15, t0.created_at AS created_at_16, t0.deleted_at AS deleted_at_17, t0.first_name AS first_name_18, t0.last_name AS last_name_19, t0.middle_name AS middle_name_20, t0.birthday AS birthday_21, t0.gender AS gender_22, t0.country AS country_23, t0.city AS city_24, t0.admin_note AS admin_note_25, t0.admin_vip_note AS admin_vip_note_26, t0.two_factor_enabled AS two_factor_enabled_27, t0.two_factor_secret AS two_factor_secret_28, t0.two_factor_required_since AS two_factor_required_since_29, t0.trust_group AS trust_group_30, t0.preferred_language AS preferred_language_31, t0.money_transfer_enabled AS money_transfer_enabled_32, t0.vip AS vip_33, t0.verified AS verified_34, t35.id AS id_36, t35.telegram_id AS telegram_id_37, t35.telegram_chat_id AS telegram_chat_id_38, t35.telegram_user_name AS telegram_user_name_39, t35.last_activity_at AS last_activity_at_40, t35.created_at AS created_at_41, t35.send_notification_at AS send_notification_at_42, t35.locale AS locale_43, t35.user_id AS user_id_44, t45.id AS id_46, t45.role AS role_47, t45.migrated_at AS migrated_at_48, t45.user_id AS user_id_49, t45.company_id AS company_id_50, t51.account_number AS account_number_52, t51.user_id AS user_id_53, t54.requested_at AS requested_at_55, t54.confirmed_at AS confirmed_at_56, t54.confirmation_token AS confirmation_token_57, t54.user_id AS user_id_58, t59.partner_id AS partner_id_60, t59.user_id AS user_id_61, t62.rank AS rank_63, t62.rank_in_progress AS rank_in_progress_64, t62.data AS data_65, t62.expires_at AS expires_at_66, t62.user_id AS user_id_67 FROM users t0 LEFT JOIN telegram_users t35 ON t35.user_id = t0.id LEFT JOIN partner_migration_user_data t45 ON t45.user_id = t0.id LEFT JOIN user_account_numbers t51 ON t51.user_id = t0.id LEFT JOIN email_confirmations t54 ON t54.user_id = t0.id LEFT JOIN user_partners t59 ON t59.user_id = t0.id LEFT JOIN user_ranks t62 ON t62.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
18 3.48 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_canonical AS email_canonical_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.password_requested_at AS password_requested_at_6, t0.roles_array AS roles_array_7, t0.default_name AS default_name_8, t0.name AS name_9, t0.partner_reward_percent AS partner_reward_percent_10, t0.phone_number AS phone_number_11, t0.phone_number_confirmed_at AS phone_number_confirmed_at_12, t0.phone_number_confirmation_code AS phone_number_confirmation_code_13, t0.phone_number_requested_at AS phone_number_requested_at_14, t0.phone_number_attempt AS phone_number_attempt_15, t0.created_at AS created_at_16, t0.deleted_at AS deleted_at_17, t0.first_name AS first_name_18, t0.last_name AS last_name_19, t0.middle_name AS middle_name_20, t0.birthday AS birthday_21, t0.gender AS gender_22, t0.country AS country_23, t0.city AS city_24, t0.admin_note AS admin_note_25, t0.admin_vip_note AS admin_vip_note_26, t0.two_factor_enabled AS two_factor_enabled_27, t0.two_factor_secret AS two_factor_secret_28, t0.two_factor_required_since AS two_factor_required_since_29, t0.trust_group AS trust_group_30, t0.preferred_language AS preferred_language_31, t0.money_transfer_enabled AS money_transfer_enabled_32, t0.vip AS vip_33, t0.verified AS verified_34, t35.id AS id_36, t35.telegram_id AS telegram_id_37, t35.telegram_chat_id AS telegram_chat_id_38, t35.telegram_user_name AS telegram_user_name_39, t35.last_activity_at AS last_activity_at_40, t35.created_at AS created_at_41, t35.send_notification_at AS send_notification_at_42, t35.locale AS locale_43, t35.user_id AS user_id_44, t45.id AS id_46, t45.role AS role_47, t45.migrated_at AS migrated_at_48, t45.user_id AS user_id_49, t45.company_id AS company_id_50, t51.account_number AS account_number_52, t51.user_id AS user_id_53, t54.requested_at AS requested_at_55, t54.confirmed_at AS confirmed_at_56, t54.confirmation_token AS confirmation_token_57, t54.user_id AS user_id_58, t59.partner_id AS partner_id_60, t59.user_id AS user_id_61, t62.rank AS rank_63, t62.rank_in_progress AS rank_in_progress_64, t62.data AS data_65, t62.expires_at AS expires_at_66, t62.user_id AS user_id_67 FROM users t0 LEFT JOIN telegram_users t35 ON t35.user_id = t0.id LEFT JOIN partner_migration_user_data t45 ON t45.user_id = t0.id LEFT JOIN user_account_numbers t51 ON t51.user_id = t0.id LEFT JOIN email_confirmations t54 ON t54.user_id = t0.id LEFT JOIN user_partners t59 ON t59.user_id = t0.id LEFT JOIN user_ranks t62 ON t62.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
19 1.45 ms
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3 FROM social_network_links s0_ WHERE s0_.locale = ? ORDER BY s0_.type ASC
Parameters:
[
  "en"
]
20 1.49 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_name"
]
21 0.66 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_registered_number"
]
22 0.55 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_office_address"
]
23 0.52 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_post_card"
]
24 0.52 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_city"
]
25 0.53 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_country"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
game_transaction doctrine.dbal.game_transaction_connection
vavadapart doctrine.dbal.vavadapart_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
game_transaction doctrine.orm.game_transaction_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Tournament\Tournament No errors.
App\Entity\User No errors.
App\Entity\Tournament\RegularTournament No errors.
App\Entity\Tournament\FreeroundTournament No errors.
App\Entity\TournamentSession No errors.
App\Entity\SiteGame No errors.
App\Entity\Tournament\TournamentTranslation No errors.
App\Entity\ProviderGameProjection No errors.
App\Entity\SiteGameTag No errors.
App\Entity\SiteGamePosition No errors.
App\Entity\SiteGameTranslation No errors.
App\Entity\SocialProvider No errors.
App\Entity\Banner No errors.
App\Accounting\Entity\Account\Account No errors.
App\Accounting\Entity\Account\GameAccount No errors.
App\Accounting\Entity\Account\BillingAccount No errors.
App\Accounting\Entity\Account\FunnyGameAccount No errors.
App\Entity\Freeround\Freeround No errors.
App\Entity\Freeround\TournamentFreeround No errors.
App\Entity\TelegramUser No errors.
App\Entity\PartnerMigrationUserData No errors.
App\Entity\UserAccountNumber No errors.
App\Entity\EmailConfirmation No errors.
App\Entity\UserPartner No errors.
App\Entity\UserRank No errors.
App\Entity\UserDocument No errors.
App\Entity\PaymentMethod\PaymentMethod No errors.
App\Entity\UserAuthentication No errors.
App\Entity\ActionRecord No errors.
App\Entity\UserRestriction No errors.
App\Entity\UtmTag No errors.
App\Entity\Message\Message No errors.
App\Entity\Message\AdminMessage No errors.
App\Entity\Notification\Notification No errors.
App\Entity\Invoice\Invoice No errors.
App\Entity\Invoice\WithdrawalInvoice No errors.
App\Entity\PromoCodeActivation No errors.
App\Entity\Wallet No errors.
App\Entity\UserVerificationRequest No errors.
App\Entity\SocialNetworkLink No errors.
App\Entity\Parameter No errors.

game_transaction entity manager

No loaded entities.