GET https://listas.commandcrossfire.com/?username=db

Query Metrics

8 Database Queries
6 Different statements
3.56 ms Query time
0 Invalid entities
17 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.03 ms
(29.00%)
1
"COMMIT"
Parameters:
[]
1.02 ms
(28.68%)
1
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:
[
  "d05842ec-f5df-46ce-8e51-103a50bff5e1"
]
0.58 ms
(16.16%)
2
SELECT t0.id AS id_1, t0.list_name AS list_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›!†\x14”}ûÉÔ¶†â\x7F"
]
0.49 ms
(13.69%)
2
SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0
Parameters:
[]
0.30 ms
(8.57%)
1
INSERT INTO user (id, session_id, created_at, last_activity) VALUES (?, ?, ?, ?)
Parameters:
[
  b"\x01›®ù!À~¥"\t\x185‰£6"
  "d05842ec-f5df-46ce-8e51-103a50bff5e1"
  "2026-01-11 21:32:01"
  "2026-01-11 21:32:01"
]
0.14 ms
(3.91%)
1
"START TRANSACTION"
Parameters:
[]

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