Query Metrics
11
Database Queries
4
Different statements
2.05 ms
Query time
8
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.currency AS currency_4, t0.type AS type_5, t0.buy_in AS buy_in_6, t0.small_blind AS small_blind_7, t0.big_blind AS big_blind_8, t0.style AS style_9, t0.count_players AS count_players_10, t0.rule AS rule_11, t0.rake AS rake_12, t0.rake_cap AS rake_cap_13, t0.turn_time AS turn_time_14, t0.time_bank AS time_bank_15, t0.count_cards AS count_cards_16, t0.count_boards AS count_boards_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM `table_setting` t0 WHERE t0.type = ? AND t0.rule = ? LIMIT 20
Parameters:
[ "cash" "Texas Holdem" ]
|
||||||||||||||||||||||||||
2 | 0.17 ms |
SELECT COUNT(*) FROM `table_setting` t0 WHERE t0.type = ? AND t0.rule = ?
Parameters:
[ "cash" "Texas Holdem" ]
|
||||||||||||||||||||||||||
3 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.max_bet AS max_bet_3, t0.session AS session_4, t0.round AS round_5, t0.state AS state_6, t0.dealer_place AS dealer_place_7, t0.small_blind_place AS small_blind_place_8, t0.big_blind_place AS big_blind_place_9, t0.turn_place AS turn_place_10, t0.last_word AS last_word_11, t0.cards AS cards_12, t0.is_archived AS is_archived_13, t0.rake_status AS rake_status_14, t0.number AS number_15, t0.reconnect_time AS reconnect_time_16, t0.small_blind AS small_blind_17, t0.big_blind AS big_blind_18, t0.ante AS ante_19, t0.last_bet_transaction AS last_bet_transaction_20, t0.hidden_cards AS hidden_cards_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.tournament_id AS tournament_id_24, t0.setting_id AS setting_id_25 FROM `table` t0 WHERE t0.setting_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||
4 | 0.19 ms |
SELECT t0.id AS id_1, t0.place AS place_2, t0.stack AS stack_3, t0.status AS status_4, t0.bet AS bet_5, t0.bet_sum AS bet_sum_6, t0.bet_type AS bet_type_7, t0.bet_expiration_time AS bet_expiration_time_8, t0.cards AS cards_9, t0.leaver AS leaver_10, t0.seat_out AS seat_out_11, t0.count_buy_in AS count_buy_in_12, t0.time_bank AS time_bank_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.table_id AS table_id_16, t0.user_id AS user_id_17, t18.id AS id_19, t18.hands_played AS hands_played_20, t18.opened_flop_count AS opened_flop_count_21, t18.three_bet_count AS three_bet_count_22, t18.player_id AS player_id_23, t18.table_id AS table_id_24 FROM `table_user` t0 LEFT JOIN `player_table_statistic` t18 ON t18.player_id = t0.id WHERE t0.table_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||
5 | 0.12 ms |
SELECT t0.id AS id_1, t0.place AS place_2, t0.stack AS stack_3, t0.status AS status_4, t0.bet AS bet_5, t0.bet_sum AS bet_sum_6, t0.bet_type AS bet_type_7, t0.bet_expiration_time AS bet_expiration_time_8, t0.cards AS cards_9, t0.leaver AS leaver_10, t0.seat_out AS seat_out_11, t0.count_buy_in AS count_buy_in_12, t0.time_bank AS time_bank_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.table_id AS table_id_16, t0.user_id AS user_id_17, t18.id AS id_19, t18.hands_played AS hands_played_20, t18.opened_flop_count AS opened_flop_count_21, t18.three_bet_count AS three_bet_count_22, t18.player_id AS player_id_23, t18.table_id AS table_id_24 FROM `table_user` t0 LEFT JOIN `player_table_statistic` t18 ON t18.player_id = t0.id WHERE t0.table_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||
6 | 0.12 ms |
SELECT t0.id AS id_1, t0.place AS place_2, t0.stack AS stack_3, t0.status AS status_4, t0.bet AS bet_5, t0.bet_sum AS bet_sum_6, t0.bet_type AS bet_type_7, t0.bet_expiration_time AS bet_expiration_time_8, t0.cards AS cards_9, t0.leaver AS leaver_10, t0.seat_out AS seat_out_11, t0.count_buy_in AS count_buy_in_12, t0.time_bank AS time_bank_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.table_id AS table_id_16, t0.user_id AS user_id_17, t18.id AS id_19, t18.hands_played AS hands_played_20, t18.opened_flop_count AS opened_flop_count_21, t18.three_bet_count AS three_bet_count_22, t18.player_id AS player_id_23, t18.table_id AS table_id_24 FROM `table_user` t0 LEFT JOIN `player_table_statistic` t18 ON t18.player_id = t0.id WHERE t0.table_id = ?
Parameters:
[
106
]
|
||||||||||||||||||||||||||
7 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.max_bet AS max_bet_3, t0.session AS session_4, t0.round AS round_5, t0.state AS state_6, t0.dealer_place AS dealer_place_7, t0.small_blind_place AS small_blind_place_8, t0.big_blind_place AS big_blind_place_9, t0.turn_place AS turn_place_10, t0.last_word AS last_word_11, t0.cards AS cards_12, t0.is_archived AS is_archived_13, t0.rake_status AS rake_status_14, t0.number AS number_15, t0.reconnect_time AS reconnect_time_16, t0.small_blind AS small_blind_17, t0.big_blind AS big_blind_18, t0.ante AS ante_19, t0.last_bet_transaction AS last_bet_transaction_20, t0.hidden_cards AS hidden_cards_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.tournament_id AS tournament_id_24, t0.setting_id AS setting_id_25 FROM `table` t0 WHERE t0.setting_id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||
8 | 0.16 ms |
SELECT t0.id AS id_1, t0.place AS place_2, t0.stack AS stack_3, t0.status AS status_4, t0.bet AS bet_5, t0.bet_sum AS bet_sum_6, t0.bet_type AS bet_type_7, t0.bet_expiration_time AS bet_expiration_time_8, t0.cards AS cards_9, t0.leaver AS leaver_10, t0.seat_out AS seat_out_11, t0.count_buy_in AS count_buy_in_12, t0.time_bank AS time_bank_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.table_id AS table_id_16, t0.user_id AS user_id_17, t18.id AS id_19, t18.hands_played AS hands_played_20, t18.opened_flop_count AS opened_flop_count_21, t18.three_bet_count AS three_bet_count_22, t18.player_id AS player_id_23, t18.table_id AS table_id_24 FROM `table_user` t0 LEFT JOIN `player_table_statistic` t18 ON t18.player_id = t0.id WHERE t0.table_id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||
9 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.max_bet AS max_bet_3, t0.session AS session_4, t0.round AS round_5, t0.state AS state_6, t0.dealer_place AS dealer_place_7, t0.small_blind_place AS small_blind_place_8, t0.big_blind_place AS big_blind_place_9, t0.turn_place AS turn_place_10, t0.last_word AS last_word_11, t0.cards AS cards_12, t0.is_archived AS is_archived_13, t0.rake_status AS rake_status_14, t0.number AS number_15, t0.reconnect_time AS reconnect_time_16, t0.small_blind AS small_blind_17, t0.big_blind AS big_blind_18, t0.ante AS ante_19, t0.last_bet_transaction AS last_bet_transaction_20, t0.hidden_cards AS hidden_cards_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.tournament_id AS tournament_id_24, t0.setting_id AS setting_id_25 FROM `table` t0 WHERE t0.setting_id = ?
Parameters:
[
109
]
|
||||||||||||||||||||||||||
10 | 0.14 ms |
SELECT t0.id AS id_1, t0.place AS place_2, t0.stack AS stack_3, t0.status AS status_4, t0.bet AS bet_5, t0.bet_sum AS bet_sum_6, t0.bet_type AS bet_type_7, t0.bet_expiration_time AS bet_expiration_time_8, t0.cards AS cards_9, t0.leaver AS leaver_10, t0.seat_out AS seat_out_11, t0.count_buy_in AS count_buy_in_12, t0.time_bank AS time_bank_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.table_id AS table_id_16, t0.user_id AS user_id_17, t18.id AS id_19, t18.hands_played AS hands_played_20, t18.opened_flop_count AS opened_flop_count_21, t18.three_bet_count AS three_bet_count_22, t18.player_id AS player_id_23, t18.table_id AS table_id_24 FROM `table_user` t0 LEFT JOIN `player_table_statistic` t18 ON t18.player_id = t0.id WHERE t0.table_id = ?
Parameters:
[
107
]
|
||||||||||||||||||||||||||
11 | 0.11 ms |
SELECT t0.id AS id_1, t0.place AS place_2, t0.stack AS stack_3, t0.status AS status_4, t0.bet AS bet_5, t0.bet_sum AS bet_sum_6, t0.bet_type AS bet_type_7, t0.bet_expiration_time AS bet_expiration_time_8, t0.cards AS cards_9, t0.leaver AS leaver_10, t0.seat_out AS seat_out_11, t0.count_buy_in AS count_buy_in_12, t0.time_bank AS time_bank_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.table_id AS table_id_16, t0.user_id AS user_id_17, t18.id AS id_19, t18.hands_played AS hands_played_20, t18.opened_flop_count AS opened_flop_count_21, t18.three_bet_count AS three_bet_count_22, t18.player_id AS player_id_23, t18.table_id AS table_id_24 FROM `table_user` t0 LEFT JOIN `player_table_statistic` t18 ON t18.player_id = t0.id WHERE t0.table_id = ?
Parameters:
[
121
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\TableSetting |
|
App\Entity\Table |
|
App\Entity\Tournament |
|
App\Entity\TableUser |
|
App\Entity\TableUserInvoice |
|
App\Entity\Chat | No errors. |
App\Entity\TableHistory | No errors. |
App\Entity\TournamentUser | No errors. |
App\Entity\Bank |
|
App\Entity\Winner |
|
App\Entity\PlayerTableStatistic | No errors. |
App\Entity\User |
|