Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.login AS login_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.avatar AS avatar_6,
  t0.last_login AS last_login_7,
  t0.role AS role_8,
  t0.language AS language_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t12.id AS id_13,
  t12.stack_view AS stack_view_14,
  t12.card_squeeze AS card_squeeze_15,
  t12.button_macros AS button_macros_16,
  t12.created_at AS created_at_17,
  t12.updated_at AS updated_at_18,
  t12.user_id AS user_id_19,
  t20.id AS id_21,
  t20.hands_played AS hands_played_22,
  t20.opened_flop_count AS opened_flop_count_23,
  t20.three_bet_count AS three_bet_count_24,
  t20.user_id AS user_id_25
FROM
  `user` t0
  LEFT JOIN player_setting t12 ON t12.user_id = t0.id
  LEFT JOIN `player_statistic` t20 ON t20.user_id = t0.id
WHERE
  t0.external_id = ?
  AND t0.role = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.login AS login_3, t0.email AS email_4, t0.password AS password_5, t0.avatar AS avatar_6, t0.last_login AS last_login_7, t0.role AS role_8, t0.language AS language_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t12.id AS id_13, t12.stack_view AS stack_view_14, t12.card_squeeze AS card_squeeze_15, t12.button_macros AS button_macros_16, t12.created_at AS created_at_17, t12.updated_at AS updated_at_18, t12.user_id AS user_id_19, t20.id AS id_21, t20.hands_played AS hands_played_22, t20.opened_flop_count AS opened_flop_count_23, t20.three_bet_count AS three_bet_count_24, t20.user_id AS user_id_25 FROM `user` t0 LEFT JOIN player_setting t12 ON t12.user_id = t0.id LEFT JOIN `player_statistic` t20 ON t20.user_id = t0.id WHERE t0.external_id = 1196767 AND t0.role = 'ROLE_PLAYER' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  `user`
SET
  last_login = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE `user` SET last_login = 1736955842, updated_at = 1736955842 WHERE id = 2;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.login AS login_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.avatar AS avatar_6,
  t0.last_login AS last_login_7,
  t0.role AS role_8,
  t0.language AS language_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t12.id AS id_13,
  t12.stack_view AS stack_view_14,
  t12.card_squeeze AS card_squeeze_15,
  t12.button_macros AS button_macros_16,
  t12.created_at AS created_at_17,
  t12.updated_at AS updated_at_18,
  t12.user_id AS user_id_19,
  t20.id AS id_21,
  t20.hands_played AS hands_played_22,
  t20.opened_flop_count AS opened_flop_count_23,
  t20.three_bet_count AS three_bet_count_24,
  t20.user_id AS user_id_25
FROM
  `user` t0
  LEFT JOIN player_setting t12 ON t12.user_id = t0.id
  LEFT JOIN `player_statistic` t20 ON t20.user_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.login AS login_3, t0.email AS email_4, t0.password AS password_5, t0.avatar AS avatar_6, t0.last_login AS last_login_7, t0.role AS role_8, t0.language AS language_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t12.id AS id_13, t12.stack_view AS stack_view_14, t12.card_squeeze AS card_squeeze_15, t12.button_macros AS button_macros_16, t12.created_at AS created_at_17, t12.updated_at AS updated_at_18, t12.user_id AS user_id_19, t20.id AS id_21, t20.hands_played AS hands_played_22, t20.opened_flop_count AS opened_flop_count_23, t20.three_bet_count AS three_bet_count_24, t20.user_id AS user_id_25 FROM `user` t0 LEFT JOIN player_setting t12 ON t12.user_id = t0.id LEFT JOIN `player_statistic` t20 ON t20.user_id = t0.id WHERE t0.id = '2' LIMIT 1;

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
  10

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 = 'cash' AND t0.rule = 'Texas Holdem' LIMIT 10;

SELECT
  COUNT(*)
FROM
  `table_setting` t0
WHERE
  t0.type = ?
  AND t0.rule = ?

SELECT COUNT(*) FROM `table_setting` t0 WHERE t0.type = 'cash' AND t0.rule = 'Texas Holdem';

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 = ?

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 = 5;

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 = ?

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 = 4;

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 = ?

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 = 5;

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 = ?

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 = 106;

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 = ?

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 = 6;

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 = ?

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 = 6;

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 = ?

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 = 109;

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 = ?

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 = 107;