Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

3.08 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.18 ms
(38.50%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 39)
5	App\Service\UserSessionService->getOrCreateUser (line 24)
6	App\Controller\HomeController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.58 ms
(18.88%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.points_modifier AS points_modifier_4, t0.published_at AS published_at_5, t0.skill AS skill_6, t0.faction_id AS faction_id_7 FROM available_army_list t0 WHERE t0.faction_id = ?

Parameters:

[
  b"\x01šQsáævY¼{ì1B›Ëg"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.points_modifier AS points_modifier_4,
  t0.published_at AS published_at_5,
  t0.skill AS skill_6,
  t0.faction_id AS faction_id_7
FROM
  available_army_list t0
WHERE
  t0.faction_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.points_modifier AS points_modifier_4, t0.published_at AS published_at_5, t0.skill AS skill_6, t0.faction_id AS faction_id_7 FROM available_army_list t0 WHERE t0.faction_id = 0x019A5173E1E67659BC7BEC31429BCB67;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 39)
5	App\Service\HomeService->getAvailableArmyListsByFaction (line 27)
6	App\Controller\HomeController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.51 ms
(16.52%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  faction t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 25)
6	App\Service\HomeService->getFactions (line 26)
7	App\Controller\HomeController->index (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 5)

0.34 ms
(10.99%)

INSERT INTO user (id, session_id, email, roles, password, is_registered, created_at, last_activity) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"\x01œÛ4Ùszéžè#\x01à¤üg"
  "ea64ea3e-33a0-4dc9-add2-6e9da42d60f5"
  null
  "[]"
  null
  0
  "2026-03-11 04:43:19"
  "2026-03-11 04:43:19"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO user (
  id, session_id, email, roles, password,
  is_registered, created_at, last_activity
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user (id, session_id, email, roles, password, is_registered, created_at, last_activity) VALUES (0x019CDB34D9737AE99EE82301E0A4FC67, 'ea64ea3e-33a0-4dc9-add2-6e9da42d60f5', NULL, '[]', NULL, 0, '2026-03-11 04:43:19', '2026-03-11 04:43:19');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 255)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 402)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 39)
7	App\Service\UserSessionService->getOrCreateUser (line 24)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.33 ms
(10.72%)

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.total_cost AS total_cost_2, b0_.total_construction_points AS total_construction_points_3, b0_.total_cost_updated_at AS total_cost_updated_at_4, b0_.army_list_id AS army_list_id_5, b0_.user_id AS user_id_6 FROM build_session b0_ INNER JOIN user u1_ ON b0_.user_id = u1_.id WHERE u1_.session_id = ? ORDER BY b0_.created_at DESC

Parameters:

[
  "ea64ea3e-33a0-4dc9-add2-6e9da42d60f5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.created_at AS created_at_1,
  b0_.total_cost AS total_cost_2,
  b0_.total_construction_points AS total_construction_points_3,
  b0_.total_cost_updated_at AS total_cost_updated_at_4,
  b0_.army_list_id AS army_list_id_5,
  b0_.user_id AS user_id_6
FROM
  build_session b0_
  INNER JOIN user u1_ ON b0_.user_id = u1_.id
WHERE
  u1_.session_id = ?
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.total_cost AS total_cost_2, b0_.total_construction_points AS total_construction_points_3, b0_.total_cost_updated_at AS total_cost_updated_at_4, b0_.army_list_id AS army_list_id_5, b0_.user_id AS user_id_6 FROM build_session b0_ INNER JOIN user u1_ ON b0_.user_id = u1_.id WHERE u1_.session_id = 'ea64ea3e-33a0-4dc9-add2-6e9da42d60f5' ORDER BY b0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 54)
7	App\Service\HomeService->getUserLists (line 28)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.14 ms
(4.39%)

"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 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 39)
4	App\Service\UserSessionService->getOrCreateUser (line 24)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AvailableArmyList	14
App\Entity\Faction	2
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\BuildSession	No errors.
App\Entity\Faction	No errors.
App\Entity\ArmyList	No errors.
App\Entity\AvailableArmyList	No errors.
App\Entity\AvailableArmyListUnitLimit	No errors.
App\Entity\AvailableArmyListUpgradeLimit	No errors.

Symfony Profiler

GET https://listas.commandcrossfire.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping