GET https://grrifapero.fr/

Query Metrics

16 Database Queries
3 Different statements
3.62 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.slots AS slots_4, t0.enabled AS enabled_5, t0.uber_enabled AS uber_enabled_6 FROM opening_day t0 WHERE t0.enabled = ? ORDER BY t0.day ASC, t0.service ASC
Parameters:
[
  1
]
2 0.24 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "sunday"
  "soir"
]
3 0.15 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "thursday"
  "soir"
]
4 0.14 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "monday"
  "soir"
]
5 0.15 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "tuesday"
  "soir"
]
6 0.14 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "wednesday"
  "soir"
]
7 0.15 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "saturday"
  "midi"
]
8 0.16 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "saturday"
  "soir"
]
9 0.16 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.label AS label_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7 FROM location_slot t0 WHERE t0.day = ? AND t0.service = ? LIMIT 1
Parameters:
[
  "friday"
  "soir"
]
10 0.61 ms
SELECT c0_.id AS id_0, c0_.date_start AS date_start_1, c0_.date_end AS date_end_2, c0_.service AS service_3, c0_.reason AS reason_4, c0_.archived AS archived_5, c0_.archived_at AS archived_at_6 FROM closure_period c0_ WHERE c0_.archived = ? AND c0_.date_start <= ? AND c0_.date_end >= ? ORDER BY c0_.date_start ASC
Parameters:
[
  0
  "2025-12-15 00:00:00"
  "2025-12-15 00:00:00"
]
11 0.19 ms
SELECT c0_.id AS id_0, c0_.date_start AS date_start_1, c0_.date_end AS date_end_2, c0_.service AS service_3, c0_.reason AS reason_4, c0_.archived AS archived_5, c0_.archived_at AS archived_at_6 FROM closure_period c0_ WHERE c0_.archived = ? AND c0_.date_start <= ? AND c0_.date_end >= ? ORDER BY c0_.date_start ASC
Parameters:
[
  0
  "2025-12-16 00:00:00"
  "2025-12-16 00:00:00"
]
12 0.16 ms
SELECT c0_.id AS id_0, c0_.date_start AS date_start_1, c0_.date_end AS date_end_2, c0_.service AS service_3, c0_.reason AS reason_4, c0_.archived AS archived_5, c0_.archived_at AS archived_at_6 FROM closure_period c0_ WHERE c0_.archived = ? AND c0_.date_start <= ? AND c0_.date_end >= ? ORDER BY c0_.date_start ASC
Parameters:
[
  0
  "2025-12-17 00:00:00"
  "2025-12-17 00:00:00"
]
13 0.18 ms
SELECT c0_.id AS id_0, c0_.date_start AS date_start_1, c0_.date_end AS date_end_2, c0_.service AS service_3, c0_.reason AS reason_4, c0_.archived AS archived_5, c0_.archived_at AS archived_at_6 FROM closure_period c0_ WHERE c0_.archived = ? AND c0_.date_start <= ? AND c0_.date_end >= ? ORDER BY c0_.date_start ASC
Parameters:
[
  0
  "2025-12-18 00:00:00"
  "2025-12-18 00:00:00"
]
14 0.15 ms
SELECT c0_.id AS id_0, c0_.date_start AS date_start_1, c0_.date_end AS date_end_2, c0_.service AS service_3, c0_.reason AS reason_4, c0_.archived AS archived_5, c0_.archived_at AS archived_at_6 FROM closure_period c0_ WHERE c0_.archived = ? AND c0_.date_start <= ? AND c0_.date_end >= ? ORDER BY c0_.date_start ASC
Parameters:
[
  0
  "2025-12-19 00:00:00"
  "2025-12-19 00:00:00"
]
15 0.17 ms
SELECT c0_.id AS id_0, c0_.date_start AS date_start_1, c0_.date_end AS date_end_2, c0_.service AS service_3, c0_.reason AS reason_4, c0_.archived AS archived_5, c0_.archived_at AS archived_at_6 FROM closure_period c0_ WHERE c0_.archived = ? AND c0_.date_start <= ? AND c0_.date_end >= ? ORDER BY c0_.date_start ASC
Parameters:
[
  0
  "2025-12-20 00:00:00"
  "2025-12-20 00:00:00"
]
16 0.19 ms
SELECT c0_.id AS id_0, c0_.date_start AS date_start_1, c0_.date_end AS date_end_2, c0_.service AS service_3, c0_.reason AS reason_4, c0_.archived AS archived_5, c0_.archived_at AS archived_at_6 FROM closure_period c0_ WHERE c0_.archived = ? AND c0_.date_start <= ? AND c0_.date_end >= ? ORDER BY c0_.date_start ASC
Parameters:
[
  0
  "2025-12-21 00:00:00"
  "2025-12-21 00:00:00"
]

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\OpeningDay 8
App\Entity\LocationSlot 8

Entities Mapping

Class Mapping errors
App\Entity\OpeningDay No errors.
App\Entity\LocationSlot No errors.
App\Entity\ClosurePeriod No errors.