GET https://listas.commandcrossfire.com/

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.12 ms
"START TRANSACTION"
Parameters:
[]
2 0.28 ms
INSERT INTO user (id, session_id, created_at, last_activity) VALUES (?, ?, ?, ?)
Parameters:
[
  b"\x01›«Ý\x13¨sû®÷MÑ>%\x02Í"
  "a4c3623e-1a1e-4694-ac89-a8cb13303101"
  "2026-01-11 07:02:31"
  "2026-01-11 07:02:31"
]
3 1.01 ms
"COMMIT"
Parameters:
[]
4 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0
Parameters:
[]
5 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0
Parameters:
[]
6 0.24 ms
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"
]
7 0.21 ms
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¨s]ŒŠAÈ=–@"
]
8 0.32 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:
[
  "a4c3623e-1a1e-4694-ac89-a8cb13303101"
]

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