Query Metrics
25
Database Queries
15
Different statements
55.61 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.01 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 | 4.06 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 | 2.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 | 2.72 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.47 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.30 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.89 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.46 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 | 1.12 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 | 1.11 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.46 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 | 2.43 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 | 1.65 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 | 2.38 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 | 2.35 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.34 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 | 9.04 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.20 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 | 2.08 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:
[
"sv"
]
|
| 20 | 1.36 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.89 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 | 1.23 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 | 1.18 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 | 1.10 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.87 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
game_transaction entity manager
No loaded entities.