Query Metrics
24
Database Queries
5
Different statements
6.01 ms
Query time
10
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2.35 ms (39.18%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.image AS image_2, t0_.currency AS currency_3, t0_.type AS type_4, t0_.buy_in AS buy_in_5, t0_.small_blind AS small_blind_6, t0_.big_blind AS big_blind_7, t0_.style AS style_8, t0_.count_players AS count_players_9, t0_.rule AS rule_10, t0_.rake AS rake_11, t0_.rake_cap AS rake_cap_12, t0_.turn_time AS turn_time_13, t0_.time_bank AS time_bank_14, t0_.count_cards AS count_cards_15, t0_.count_boards AS count_boards_16, t0_.reconnect_time AS reconnect_time_17, t0_.created_at AS created_at_18, t0_.updated_at AS updated_at_19 FROM `table_setting` t0_ INNER JOIN `bridge` b1_ ON t0_.bridge_id = b1_.id WHERE t0_.type = ? AND b1_.type = ?) dctrn_result) dctrn_table
Parameters:
[ "cash" "shared" ]
|
||||||||||||||||||||||||||||||||||
1.64 ms (27.33%) |
10 |
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.small_blind AS small_blind_16, t0.big_blind AS big_blind_17, t0.ante AS ante_18, t0.last_bet_transaction AS last_bet_transaction_19, t0.hidden_cards AS hidden_cards_20, t0.in_progress AS in_progress_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, t0.bridge_id AS bridge_id_26 FROM `table` t0 WHERE t0.setting_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||||||
1.41 ms (23.50%) |
11 |
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.auto_bet AS auto_bet_14, t0.chips AS chips_15, t0.lose_at AS lose_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.table_id AS table_id_19, t0.user_id AS user_id_20, t21.id AS id_22, t21.hands_played AS hands_played_23, t21.opened_flop_count AS opened_flop_count_24, t21.three_bet_count AS three_bet_count_25, t21.player_id AS player_id_26, t21.table_id AS table_id_27, t0.bridge_id AS bridge_id_28 FROM `table_user` t0 LEFT JOIN `player_table_statistic` t21 ON t21.player_id = t0.id WHERE t0.table_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||||||
0.32 ms (5.41%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.image AS image_2, t0_.currency AS currency_3, t0_.type AS type_4, t0_.buy_in AS buy_in_5, t0_.small_blind AS small_blind_6, t0_.big_blind AS big_blind_7, t0_.style AS style_8, t0_.count_players AS count_players_9, t0_.rule AS rule_10, t0_.rake AS rake_11, t0_.rake_cap AS rake_cap_12, t0_.turn_time AS turn_time_13, t0_.time_bank AS time_bank_14, t0_.count_cards AS count_cards_15, t0_.count_boards AS count_boards_16, t0_.reconnect_time AS reconnect_time_17, t0_.created_at AS created_at_18, t0_.updated_at AS updated_at_19, t0_.bridge_id AS bridge_id_20 FROM `table_setting` t0_ INNER JOIN `bridge` b1_ ON t0_.bridge_id = b1_.id WHERE t0_.type = ? AND b1_.type = ? AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "cash" "shared" 4 5 6 8 9 16 17 18 19 20 ]
|
||||||||||||||||||||||||||||||||||
0.27 ms (4.58%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.image AS image_2, t0_.currency AS currency_3, t0_.type AS type_4, t0_.buy_in AS buy_in_5, t0_.small_blind AS small_blind_6, t0_.big_blind AS big_blind_7, t0_.style AS style_8, t0_.count_players AS count_players_9, t0_.rule AS rule_10, t0_.rake AS rake_11, t0_.rake_cap AS rake_cap_12, t0_.turn_time AS turn_time_13, t0_.time_bank AS time_bank_14, t0_.count_cards AS count_cards_15, t0_.count_boards AS count_boards_16, t0_.reconnect_time AS reconnect_time_17, t0_.created_at AS created_at_18, t0_.updated_at AS updated_at_19 FROM `table_setting` t0_ INNER JOIN `bridge` b1_ ON t0_.bridge_id = b1_.id WHERE t0_.type = ? AND b1_.type = ?) dctrn_result LIMIT 10
Parameters:
[ "cash" "shared" ]
|
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\Bridge |
|
App\Entity\Table |
|
App\Entity\Tournament |
|
App\Entity\TableUser |
|
App\Entity\TableUserInvoice |
|
App\Entity\Chat | No errors. |
App\Entity\TableHistory |
|
App\Entity\TournamentUser | No errors. |
App\Entity\Bank |
|
App\Entity\Winner |
|
App\Entity\PlayerTableStatistic | No errors. |
App\Entity\User |
|