Query Metrics

43 Database Queries
2 Different statements
14.73 ms Query time
0 Invalid entities
85 Managed entities

Queries

Group similar statements

# Time Info
1 0.74 ms
SELECT e0_.id AS id_0, e0_.public AS public_1, e0_.status AS status_2, e0_.firstname AS firstname_3, e0_.lastname AS lastname_4, e0_.email AS email_5, e0_.phone AS phone_6, e0_.number_of_unequipped_players AS number_of_unequipped_players_7, e0_.number_of_equipped_players AS number_of_equipped_players_8, e0_.created AS created_9, e0_.comment AS comment_10, e0_.name AS name_11, e0_.category AS category_12, e0_.event_start AS event_start_13, e0_.event_end AS event_end_14, e0_.registrations_start AS registrations_start_15, e0_.registrations_end AS registrations_end_16, e0_.transportation_time AS transportation_time_17, e0_.referee AS referee_18, e0_.type AS type_19, e0_.price AS price_20, e0_.ammunition_price AS ammunition_price_21, e0_.description AS description_22, e0_.price_comment AS price_comment_23, e0_.mail_sent AS mail_sent_24, e0_.admin_comment AS admin_comment_25, e0_.station AS station_26, e0_.image AS image_27, e0_.google_calendar_id AS google_calendar_id_28, e0_.confirmed AS confirmed_29, e0_.google_calendar_event_id AS google_calendar_event_id_30, e0_.field_id AS field_id_31, e0_.reservation_id AS reservation_id_32 FROM event e0_ WHERE e0_.public = 1 AND e0_.category = ? AND e0_.event_start > ? ORDER BY e0_.event_start ASC
Parameters:
[
  "FOR-BEGINNERS"
  "2026-08-04 13:09:28"
]
2 0.30 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  67
]
3 0.40 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  16
]
4 0.37 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  37
]
5 0.27 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  52
]
6 0.34 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  60
]
7 0.31 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  8
]
8 0.30 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  97
]
9 0.36 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  103
]
10 0.39 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  84
]
11 0.27 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  19
]
12 0.32 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  76
]
13 0.31 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  73
]
14 0.36 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  20
]
15 0.27 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  55
]
16 0.37 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  46
]
17 0.40 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  87
]
18 0.58 ms
SELECT e0_.id AS id_0, e0_.public AS public_1, e0_.status AS status_2, e0_.firstname AS firstname_3, e0_.lastname AS lastname_4, e0_.email AS email_5, e0_.phone AS phone_6, e0_.number_of_unequipped_players AS number_of_unequipped_players_7, e0_.number_of_equipped_players AS number_of_equipped_players_8, e0_.created AS created_9, e0_.comment AS comment_10, e0_.name AS name_11, e0_.category AS category_12, e0_.event_start AS event_start_13, e0_.event_end AS event_end_14, e0_.registrations_start AS registrations_start_15, e0_.registrations_end AS registrations_end_16, e0_.transportation_time AS transportation_time_17, e0_.referee AS referee_18, e0_.type AS type_19, e0_.price AS price_20, e0_.ammunition_price AS ammunition_price_21, e0_.description AS description_22, e0_.price_comment AS price_comment_23, e0_.mail_sent AS mail_sent_24, e0_.admin_comment AS admin_comment_25, e0_.station AS station_26, e0_.image AS image_27, e0_.google_calendar_id AS google_calendar_id_28, e0_.confirmed AS confirmed_29, e0_.google_calendar_event_id AS google_calendar_event_id_30, e0_.field_id AS field_id_31, e0_.reservation_id AS reservation_id_32 FROM event e0_ WHERE e0_.public = 1 AND e0_.category = ? AND e0_.event_start > ? ORDER BY e0_.event_start ASC
Parameters:
[
  "FOR-EVERYONE"
  "2026-08-04 13:09:28"
]
19 0.26 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  78
]
20 0.25 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  101
]
21 0.26 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  40
]
22 0.30 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  10
]
23 0.25 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  107
]
24 0.28 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  70
]
25 0.25 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  7
]
26 0.25 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  77
]
27 0.26 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  30
]
28 0.26 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  53
]
29 0.25 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  44
]
30 0.55 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  6
]
31 0.37 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  108
]
32 0.37 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  109
]
33 0.78 ms
SELECT e0_.id AS id_0, e0_.public AS public_1, e0_.status AS status_2, e0_.firstname AS firstname_3, e0_.lastname AS lastname_4, e0_.email AS email_5, e0_.phone AS phone_6, e0_.number_of_unequipped_players AS number_of_unequipped_players_7, e0_.number_of_equipped_players AS number_of_equipped_players_8, e0_.created AS created_9, e0_.comment AS comment_10, e0_.name AS name_11, e0_.category AS category_12, e0_.event_start AS event_start_13, e0_.event_end AS event_end_14, e0_.registrations_start AS registrations_start_15, e0_.registrations_end AS registrations_end_16, e0_.transportation_time AS transportation_time_17, e0_.referee AS referee_18, e0_.type AS type_19, e0_.price AS price_20, e0_.ammunition_price AS ammunition_price_21, e0_.description AS description_22, e0_.price_comment AS price_comment_23, e0_.mail_sent AS mail_sent_24, e0_.admin_comment AS admin_comment_25, e0_.station AS station_26, e0_.image AS image_27, e0_.google_calendar_id AS google_calendar_id_28, e0_.confirmed AS confirmed_29, e0_.google_calendar_event_id AS google_calendar_event_id_30, e0_.field_id AS field_id_31, e0_.reservation_id AS reservation_id_32 FROM event e0_ WHERE e0_.public = 1 AND e0_.category = ? AND e0_.event_start > ? ORDER BY e0_.event_start ASC
Parameters:
[
  "OTHERS"
  "2026-08-04 13:09:28"
]
34 0.33 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  106
]
35 0.33 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  74
]
36 0.30 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  66
]
37 0.31 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  28
]
38 0.28 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  23
]
39 0.34 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  43
]
40 0.28 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  51
]
41 0.34 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  98
]
42 0.28 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  93
]
43 0.31 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
  65
]

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\Event 40
App\Entity\Reservation 40
App\Entity\Field 5

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\Field No errors.
App\Entity\Reservation No errors.
App\Entity\Registration No errors.
App\Entity\EshopProduct No errors.