GET https://listas.commandcrossfire.com/

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.05 ms
(36.17%)
1
"COMMIT"
Parameters:
[]
0.55 ms
(18.91%)
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.48 ms
(16.44%)
2
SELECT t0.id AS id_1, t0.name AS name_2 FROM faction t0
Parameters:
[]
0.37 ms
(12.62%)
1
INSERT INTO user (id, session_id, created_at, last_activity) VALUES (?, ?, ?, ?)
Parameters:
[
  b"\x01›§\t?¸z\x1A­ú8\x1C%(þ¥"
  "750bd0f2-d967-4127-9628-9aefa29f38f4"
  "2026-01-10 08:32:39"
  "2026-01-10 08:32:39"
]
0.31 ms
(10.83%)
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:
[
  "750bd0f2-d967-4127-9628-9aefa29f38f4"
]
0.15 ms
(5.03%)
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