GET https://mafiajob.youconix.nl/gegevensvergeten/activatie

Query Metrics

6 Database Queries
4 Different statements
5.38 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.85 ms
(34.39%)
2
SELECT t0.id AS id_1, t0.active AS active_2, t0.end AS end_3, t0.number AS number_4, t0.start AS start_5, t0.status AS status_6 FROM round t0 WHERE t0.active = ? LIMIT 1
Parameters:
[
  1
]
1.83 ms
(34.06%)
2
SELECT t0.id AS id_1, t0.members_max_online AS members_max_online_2, t0.ledennieuw AS ledennieuw_3, t0.ledenonline AS ledenonline_4, t0.ledentotaal AS ledentotaal_5, t0.prijzen AS prijzen_6, t0.breakouts_top5 AS breakouts_top5_7, t0.family_top5 AS family_top5_8, t0.killers_top5 AS killers_top5_9, t0.kills_top5 AS kills_top5_10, t0.losses_top5 AS losses_top5_11, t0.money_top5 AS money_top5_12, t0.premium_points_top5 AS premium_points_top5_13, t0.power_top5 AS power_top5_14, t0.rank_top5 AS rank_top5_15, t0.referer_top5 AS referer_top5_16, t0.respect_top5 AS respect_top5_17, t0.stats AS stats_18, t0.wins_top5 AS wins_top5_19 FROM cache t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.88 ms
(16.34%)
1
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.name AS name_2, p0_.sort_order AS sort_order_3, p0_.value AS value_4, p0_.round_id AS round_id_5 FROM prize p0_ WHERE p0_.round_id = ? ORDER BY p0_.sort_order ASC LIMIT 3
Parameters:
[
  1
]
0.82 ms
(15.21%)
1
SELECT COUNT(h0_.id) AS sclr_0 FROM helpdesk_ticket h0_ WHERE h0_.answered = 0 ORDER BY h0_.created_at DESC
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\Prize 3
App\Entity\Cache 1
App\Entity\Round 1

Entities Mapping

Class Mapping errors
App\Entity\Cache No errors.
App\Entity\Round No errors.
App\Entity\HelpdeskTicket No errors.
App\Entity\Prize No errors.