Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.name AS name_3,
  t0.callback_route AS callback_route_4,
  t0.public_key AS public_key_5,
  t0.private_key AS private_key_6,
  t0.is_active AS is_active_7,
  t0.type AS type_8,
  t0.user_id AS user_id_9
FROM
  `bridge` t0
WHERE
  t0.public_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.callback_route AS callback_route_4, t0.public_key AS public_key_5, t0.private_key AS private_key_6, t0.is_active AS is_active_7, t0.type AS type_8, t0.user_id AS user_id_9 FROM `bridge` t0 WHERE t0.public_key = '0e2e51dd45a7535384d3e8a50f2a49d894005f2d03189677cf072bafe44dd340' 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.last_login AS last_login_5,
  t0.role AS role_6,
  t0.language AS language_7,
  t0.password AS password_8,
  t0.token AS token_9,
  t0.timezone AS timezone_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t13.id AS id_14,
  t13.stack_view AS stack_view_15,
  t13.card_squeeze AS card_squeeze_16,
  t13.button_macros AS button_macros_17,
  t13.theme AS theme_18,
  t13.avatar AS avatar_19,
  t13.created_at AS created_at_20,
  t13.updated_at AS updated_at_21,
  t13.user_id AS user_id_22,
  t23.id AS id_24,
  t23.hands_played AS hands_played_25,
  t23.opened_flop_count AS opened_flop_count_26,
  t23.three_bet_count AS three_bet_count_27,
  t23.user_id AS user_id_28,
  t0.bridge_id AS bridge_id_29
FROM
  `user` t0
  LEFT JOIN player_setting t13 ON t13.user_id = t0.id
  LEFT JOIN `player_statistic` t23 ON t23.user_id = t0.id
WHERE
  t0.token = ?
  AND t0.bridge_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.last_login AS last_login_5, t0.role AS role_6, t0.language AS language_7, t0.password AS password_8, t0.token AS token_9, t0.timezone AS timezone_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t13.id AS id_14, t13.stack_view AS stack_view_15, t13.card_squeeze AS card_squeeze_16, t13.button_macros AS button_macros_17, t13.theme AS theme_18, t13.avatar AS avatar_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.user_id AS user_id_22, t23.id AS id_24, t23.hands_played AS hands_played_25, t23.opened_flop_count AS opened_flop_count_26, t23.three_bet_count AS three_bet_count_27, t23.user_id AS user_id_28, t0.bridge_id AS bridge_id_29 FROM `user` t0 LEFT JOIN player_setting t13 ON t13.user_id = t0.id LEFT JOIN `player_statistic` t23 ON t23.user_id = t0.id WHERE t0.token = '5fcf8da501b3e3ee754865a2dfc36af57016fdc6' AND t0.bridge_id = 1 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE `user` SET last_login = 1741313366, updated_at = 1741313366 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.last_login AS last_login_5,
  t0.role AS role_6,
  t0.language AS language_7,
  t0.password AS password_8,
  t0.token AS token_9,
  t0.timezone AS timezone_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t13.id AS id_14,
  t13.stack_view AS stack_view_15,
  t13.card_squeeze AS card_squeeze_16,
  t13.button_macros AS button_macros_17,
  t13.theme AS theme_18,
  t13.avatar AS avatar_19,
  t13.created_at AS created_at_20,
  t13.updated_at AS updated_at_21,
  t13.user_id AS user_id_22,
  t23.id AS id_24,
  t23.hands_played AS hands_played_25,
  t23.opened_flop_count AS opened_flop_count_26,
  t23.three_bet_count AS three_bet_count_27,
  t23.user_id AS user_id_28,
  t0.bridge_id AS bridge_id_29
FROM
  `user` t0
  LEFT JOIN player_setting t13 ON t13.user_id = t0.id
  LEFT JOIN `player_statistic` t23 ON t23.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.last_login AS last_login_5, t0.role AS role_6, t0.language AS language_7, t0.password AS password_8, t0.token AS token_9, t0.timezone AS timezone_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t13.id AS id_14, t13.stack_view AS stack_view_15, t13.card_squeeze AS card_squeeze_16, t13.button_macros AS button_macros_17, t13.theme AS theme_18, t13.avatar AS avatar_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.user_id AS user_id_22, t23.id AS id_24, t23.hands_played AS hands_played_25, t23.opened_flop_count AS opened_flop_count_26, t23.three_bet_count AS three_bet_count_27, t23.user_id AS user_id_28, t0.bridge_id AS bridge_id_29 FROM `user` t0 LEFT JOIN player_setting t13 ON t13.user_id = t0.id LEFT JOIN `player_statistic` t23 ON t23.user_id = t0.id WHERE t0.id = '2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.name AS name_3,
  t0.callback_route AS callback_route_4,
  t0.public_key AS public_key_5,
  t0.private_key AS private_key_6,
  t0.is_active AS is_active_7,
  t0.type AS type_8,
  t0.user_id AS user_id_9
FROM
  `bridge` t0
WHERE
  t0.public_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.callback_route AS callback_route_4, t0.public_key AS public_key_5, t0.private_key AS private_key_6, t0.is_active AS is_active_7, t0.type AS type_8, t0.user_id AS user_id_9 FROM `bridge` t0 WHERE t0.public_key = '0e2e51dd45a7535384d3e8a50f2a49d894005f2d03189677cf072bafe44dd340' LIMIT 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 = ?
        ORDER BY
          t0_.count_boards DESC
      ) dctrn_result
  ) dctrn_table

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 = 'cash' AND b1_.type = 'shared' ORDER BY t0_.count_boards DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      count_boards_16
    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,
          b1_.id AS id_20,
          b1_.external_id AS external_id_21,
          b1_.name AS name_22,
          b1_.callback_route AS callback_route_23,
          b1_.public_key AS public_key_24,
          b1_.private_key AS private_key_25,
          b1_.is_active AS is_active_26,
          b1_.type AS type_27
        FROM
          `table_setting` t0_
          INNER JOIN `bridge` b1_ ON t0_.bridge_id = b1_.id
        WHERE
          t0_.type = ?
          AND b1_.type = ?
      ) dctrn_result_inner
    ORDER BY
      count_boards_16 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, count_boards_16 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, b1_.id AS id_20, b1_.external_id AS external_id_21, b1_.name AS name_22, b1_.callback_route AS callback_route_23, b1_.public_key AS public_key_24, b1_.private_key AS private_key_25, b1_.is_active AS is_active_26, b1_.type AS type_27 FROM `table_setting` t0_ INNER JOIN `bridge` b1_ ON t0_.bridge_id = b1_.id WHERE t0_.type = 'cash' AND b1_.type = 'shared') dctrn_result_inner ORDER BY count_boards_16 DESC) dctrn_result LIMIT 10;

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t0_.count_boards DESC

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 = 'cash' AND b1_.type = 'shared' AND t0_.id IN (8, 9, 16, 17, 18, 19, 20, 21, 26, 4) ORDER BY t0_.count_boards DESC;

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

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

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

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

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