GET https://poker.gambling-dev.pro/poker2/api/cash-tables?limit=10&page=1

Query Metrics

24 Database Queries
5 Different statements
6.01 ms Query time
10 Invalid entities

Grouped Statements

Show all queries

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
  • The field 'App\Entity\TableSetting#buyIn' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\TableSetting#smallBlind' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\TableSetting#bigBlind' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Bridge
  • The mappings App\Entity\Bridge#players and App\Entity\User#bridge are inconsistent with each other.
  • The mappings App\Entity\Bridge#tableHistories and App\Entity\TableHistory#bridge are inconsistent with each other.
  • The mappings App\Entity\Bridge#tournamentPrizes and App\Entity\TournamentPrize#bridge are inconsistent with each other.
  • The mappings App\Entity\Bridge#tournamentUsers and App\Entity\TournamentPrize#bridge are inconsistent with each other.
App\Entity\Table
  • The field 'App\Entity\Table#maxBet' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Table#smallBlind' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Table#bigBlind' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Table#ante' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Tournament
  • The field 'App\Entity\Tournament#balance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Tournament#smallBlind' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Tournament#bigBlind' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Tournament#ante' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Tournament#guaranteedPrizePool' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The mappings App\Entity\Tournament#transactions and App\Entity\Transaction#tournament are inconsistent with each other.
  • The mappings App\Entity\Tournament#tournamentChats and App\Entity\TournamentChat#tournament are inconsistent with each other.
App\Entity\TableUser
  • The field 'App\Entity\TableUser#stack' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\TableUser#bet' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\TableUser#betSum' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\TableUserInvoice
  • The field 'App\Entity\TableUserInvoice#sum' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Chat No errors.
App\Entity\TableHistory
  • The association App\Entity\TableHistory#bridge refers to the inverse side field App\Entity\Bridge#tableHistory which does not exist.
App\Entity\TournamentUser No errors.
App\Entity\Bank
  • The field 'App\Entity\Bank#bet' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Bank#sum' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Winner
  • The field 'App\Entity\Winner#sum' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PlayerTableStatistic No errors.
App\Entity\User
  • The association App\Entity\User#prizes refers to the owning side field App\Entity\TournamentPrize#user which does not exist.
  • The association App\Entity\User#bridge refers to the inverse side field App\Entity\Bridge#clients which does not exist.