Query Metrics
31
Database Queries
2
Different statements
29.80 ms
Query time
2
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 16.47 ms |
SELECT w.id, w.name, w.city, w.address, w.country, w.postal_code, w.lat, w.lng, w.radius AS radius_km, w.avatar_path, w.description, w.electric_bike_accepted, w.next_available_date, w.status, w.booking_type, w.bike_type_keys, w.services_provided_keys, w.services_provided, w.practice_type_keys, w.motor_brands, w.motor_positions, w.activity, w.location, w.contact, w.schedule, w.availability_calendar, w.created_at, w.gallery, w.supported_bike_type, w.supported_practice_type, w.time_slots, NULL AS distance_km FROM workshop w WHERE 1=1 AND w.status = :status ORDER BY w.next_available_date ASC NULLS LAST, w.created_at DESC NULLS LAST LIMIT :limit
Parameters:
[ "status" => "status.public" "limit" => 30 ] |
| 2 | 1.06 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "807038d9-8f9c-452e-99e9-88a752f4cd06" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 3 | 0.50 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "0fd53aec-8900-4dba-abf2-52ca0d98e660" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 4 | 0.47 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "68d9d634-613f-49ff-b176-0f5776ba2af9" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 5 | 0.52 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "2a746556-425e-488d-bd54-b8085f61a48a" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 6 | 0.39 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "017dd614-c0f5-4eb2-a73a-75ff7c654a37" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 7 | 0.38 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "5e3bf0cf-6a72-4c11-aad2-c9bfeee71c70" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 8 | 0.43 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "8fa3b70a-d500-49db-a171-124b2efbbdcb" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 9 | 0.39 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "8fd8b91c-7e04-45d2-96bb-783c67ab74ce" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 10 | 0.43 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "d99c958b-cf0e-48cf-8a1f-83c15a20ad16" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 11 | 0.42 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "c37d67fb-fe18-4f2c-84b0-dc97fb2758db" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 12 | 0.42 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "237f1f2b-fc7b-4a8d-9f2f-896cc24a8ed0" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 13 | 0.38 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "112b6b97-8887-417c-b62d-ae2ab38f77e7" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 14 | 0.40 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "ce24da68-6aac-48c5-9ded-138eec3771ba" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 15 | 0.42 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "e4ae3937-5a11-4217-ac17-59f78be99d72" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 16 | 0.43 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "9a4f9455-78f1-4f9c-b0bb-b6682641918a" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 17 | 0.43 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "c30a6774-fa69-4cda-8bac-8d6c662331b5" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 18 | 0.37 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "6140fd30-3a86-435a-8737-0283015fa4fe" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 19 | 0.39 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "59ec3ea4-e1b6-4fb7-9667-b31f34d075c3" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 20 | 0.38 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "a71b4279-f89d-4b34-879a-99bb71bb2a7f" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 21 | 0.41 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "c6999cb0-0af1-4e7c-a4a9-8ea4778546a2" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 22 | 0.45 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "1477c4b9-0b19-4cf0-9cbe-41116e1181bd" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 23 | 0.45 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "40350466-a55a-476e-8b5b-a86d2dc5cf7d" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 24 | 0.40 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "53c74d65-a12b-470d-9515-76a4f874f6b3" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 25 | 0.44 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "324fb9e6-41b9-4500-892c-f3b952d95644" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 26 | 0.42 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "c17b0093-6727-45a3-95b9-ba8a9c40d755" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 27 | 0.37 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "3bf50ce7-766d-4b12-8e9e-ac564df3b4a2" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 28 | 0.38 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "9865f19a-3280-4867-8389-7de183a9f91f" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 29 | 0.39 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "121288a5-9243-4be6-90ab-908adc825704" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 30 | 0.55 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "df41862d-f834-4bf4-b89a-3ec2b3e087a5" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
| 31 | 0.42 ms |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "a442729c-803b-4f0d-ac36-e791089c5a76" "2026-04-03 00:00:00" "2026-07-04 08:57:07" "CANCELED" ] |
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Workshop |
|
| App\Entity\Appointment |
|