GET https://listas.commandcrossfire.com/

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.14 ms
"START TRANSACTION"
Parameters:
[]
2 0.34 ms
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"
]
3 1.18 ms
"COMMIT"
Parameters:
[]
4 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0
Parameters:
[]
5 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0
Parameters:
[]
6 0.29 ms
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"
]
7 0.29 ms
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áú\x7F¶¥rQÇ\e\v\x02"
]
8 0.33 ms
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"
]

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