Symfony Profiler

Query Metrics

16 Database Queries

9 Different statements

3.76 ms Query time

9 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.27 ms
(33.81%)

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
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 17)
9	App\Response\TableSettingsResponse::App\Response\{closure} (line 1)
10	array_map (line 360)
11	Doctrine\Common\Collections\ArrayCollection->map (line 259)
12	Doctrine\Common\Collections\AbstractLazyCollection->map (line 17)
13	App\Response\TableSettingsResponse::item (line 51)
14	App\Response\TableSettingsResponse::collection (line 43)
15	App\Handler\CashTables\GetCashTablesHandler->__invoke (line 34)
16	App\Controller\API\CashTablesController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 43)

0.69 ms
(18.34%)

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
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 16)
8	App\Response\TableSettingsResponse::item (line 51)
9	App\Response\TableSettingsResponse::collection (line 43)
10	App\Handler\CashTables\GetCashTablesHandler->__invoke (line 34)
11	App\Controller\API\CashTablesController->list (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 43)

0.59 ms
(15.69%)

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

Parameters:

[
  1196767
  "ROLE_PLAYER"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 62)
5	App\Security\PlayerAuthenticator->authenticate (line 70)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 43)

0.29 ms
(7.76%)

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

Parameters:

[
  "cash"
  "Texas Holdem"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 36)
5	App\Service\TableSettingService->getCashCollection (line 34)
6	App\Handler\CashTables\GetCashTablesHandler->__invoke (line 34)
7	App\Controller\API\CashTablesController->list (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 43)

0.29 ms
(7.73%)

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

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 87)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 43)

0.25 ms
(6.78%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 76)
7	App\Security\PlayerAuthenticator->authenticate (line 70)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 43)

0.17 ms
(4.49%)

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

Parameters:

[
  "cash"
  "Texas Holdem"
]

View formatted query View runnable query Explain query View query backtrace

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';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 838)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 139)
3	Doctrine\ORM\EntityRepository->count (line 86)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 42)
5	App\Service\TableSettingService->getCashCollection (line 34)
6	App\Handler\CashTables\GetCashTablesHandler->__invoke (line 34)
7	App\Controller\API\CashTablesController->list (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 43)

0.11 ms
(2.85%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 76)
4	App\Security\PlayerAuthenticator->authenticate (line 70)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 43)

0.10 ms
(2.55%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 76)
5	App\Security\PlayerAuthenticator->authenticate (line 70)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 43)

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\User	The association App\Entity\User#prizes refers to the owning side field App\Entity\TournamentPrize#user which does not exist.
App\Entity\PlayerSetting	No errors.
App\Entity\PlayerStatistic	No errors.
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\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\Chat	No errors.
App\Entity\TournamentUser	No errors.
App\Entity\TournamentPrize	The field 'App\Entity\TournamentPrize#sum' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The mappings App\Entity\TournamentPrize#winner and App\Entity\User#prizes are inconsistent with each other.
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\Notification	No errors.
App\Entity\Note	No 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\TableHistory	No errors.
App\Entity\PlayerTableStatistic	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping