GET https://poker.development-casinos.com/poker2/api/cash-tables?page=1&rule=Texas%20Holdem

Query Metrics

11 Database Queries
4 Different statements
2.05 ms Query time
8 Invalid entities

Queries

Group similar statements

# 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
  • 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\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.
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 No errors.
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.