Query Metrics
83
Database Queries
10
Different statements
153.35 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
93.55 ms (61.00%) |
33 |
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:
[
6
]
|
|
35.96 ms (23.45%) |
33 |
SELECT t0.id AS id_1, t0.read_at AS read_at_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.jackpot_win_id AS jackpot_win_id_5, t0.type FROM notifications t0 WHERE t0.jackpot_win_id = ? AND t0.type IN ('jackpot_win')
Parameters:
[
1
]
|
|
6.28 ms (4.09%) |
3 |
SELECT j0_.id AS id_0, j0_.amount AS amount_1, j0_.currency AS currency_2, j0_.jackpot_amount AS jackpot_amount_3, j0_.jackpot_fund AS jackpot_fund_4, j0_.jackpot_currency AS jackpot_currency_5, j0_.created_at AS created_at_6, j0_.user_id AS user_id_7, j0_.jackpot_id AS jackpot_id_8, j0_.debit_transaction_id AS debit_transaction_id_9 FROM jackpot_wins j0_ INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id WHERE j1_.type = ? ORDER BY j0_.created_at DESC LIMIT 1
Parameters:
[
"mega"
]
|
|
4.94 ms (3.22%) |
6 |
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"
]
|
|
3.67 ms (2.39%) |
3 |
SELECT j0_.id AS id_0, j0_.type AS type_1, j0_.pay_percent AS pay_percent_2, j0_.probability AS probability_3, j0_.probability_by_rounds AS probability_by_rounds_4, j0_.prize_fund_per_day AS prize_fund_per_day_5, j0_.min_win_amount AS min_win_amount_6, j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7, j0_.active AS active_8, j0_.created_at AS created_at_9 FROM jackpots j0_ WHERE j0_.created_at >= ? AND j0_.type = ? ORDER BY j0_.created_at ASC
Parameters:
[ "2025-09-17 15:44:51" "mega" ] |
|
2.66 ms (1.74%) |
1 |
SELECT j0_.id AS id_0, j0_.type AS type_1, j0_.pay_percent AS pay_percent_2, j0_.probability AS probability_3, j0_.probability_by_rounds AS probability_by_rounds_4, j0_.prize_fund_per_day AS prize_fund_per_day_5, j0_.min_win_amount AS min_win_amount_6, j0_.min_prize_fund_per_day AS min_prize_fund_per_day_7, j0_.active AS active_8, j0_.created_at AS created_at_9 FROM jackpots j0_ WHERE j0_.active = true
Parameters:
[] |
|
1.73 ms (1.13%) |
1 |
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:
[
"ru"
]
|
|
1.68 ms (1.09%) |
1 |
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:
[] |
|
1.60 ms (1.05%) |
1 |
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
]
|
|
1.28 ms (0.84%) |
1 |
SELECT j0_.id AS id_0, j0_.amount AS amount_1, j0_.currency AS currency_2, j0_.jackpot_amount AS jackpot_amount_3, j0_.jackpot_fund AS jackpot_fund_4, j0_.jackpot_currency AS jackpot_currency_5, j0_.created_at AS created_at_6, j0_.user_id AS user_id_7, j0_.jackpot_id AS jackpot_id_8, j0_.debit_transaction_id AS debit_transaction_id_9 FROM jackpot_wins j0_ INNER JOIN jackpots j1_ ON j0_.jackpot_id = j1_.id ORDER BY j0_.created_at DESC LIMIT 100
Parameters:
[] |
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.