Query Metrics
31
Database Queries
2
Different statements
114.41 ms
Query time
2
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 16.27 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 | 9.75 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:
[ "1f11632a-13b6-65c8-8b73-1772a471e45e" "2026-03-15 00:00:00" "2026-06-16 15:13:49" "CANCELED" ] |
| 3 | 1.67 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:
[ "1f1133cc-ede7-6d74-a2bd-e32d40dbf090" "2026-03-15 00:00:00" "2026-06-16 15:13:49" "CANCELED" ] |
| 4 | 3.99 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:
[ "1f1133c9-9b4d-6256-a5fe-238cf71d37c4" "2026-03-15 00:00:00" "2026-06-16 15:13:49" "CANCELED" ] |
| 5 | 2.16 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:
[ "1f112788-4070-6e48-af45-91a274c6931d" "2026-03-15 00:00:00" "2026-06-16 15:13:49" "CANCELED" ] |
| 6 | 18.71 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:
[ "1f108f1f-9de9-6e6e-9f49-9df777e13847" "2026-03-15 00:00:00" "2026-06-16 15:13:49" "CANCELED" ] |
| 7 | 13.23 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-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 8 | 14.16 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:
[ "294f7e6c-9a88-4c13-a957-eaee3e945a8a" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 9 | 8.56 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:
[ "2cd9652c-9001-4d33-9a1e-15b9b67a9605" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 10 | 6.46 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:
[ "ed1fc250-cd77-483d-bf09-0169945cb60e" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 11 | 1.79 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-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 12 | 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:
[ "e2c283b1-7049-4019-94ac-36a3e1f27970" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 13 | 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-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 14 | 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:
[ "a442729c-803b-4f0d-ac36-e791089c5a76" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 15 | 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:
[ "40785c3a-6450-4c74-b9f7-f6225b5f8dcc" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 16 | 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:
[ "081bf2ee-a7df-4ef7-88c7-8f705439e2d3" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 17 | 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:
[ "9f771c94-78e3-4e6f-9b9c-862db47444f5" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 18 | 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:
[ "9872c189-ce06-44e8-b275-736e8eb9675e" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 19 | 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:
[ "eedf63d1-de55-42f2-8b95-b04aaf457a19" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 20 | 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-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 21 | 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:
[ "2696f4e4-3f79-4a32-9117-7d5a399ae045" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 22 | 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-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 23 | 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:
[ "e439e226-ecf8-492d-bd28-5391ff87cf6e" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 24 | 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:
[ "c1946972-8878-49ef-b581-f3db1a059d4f" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 25 | 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:
[ "09a55498-44c1-41ac-962c-0ad2fa2458bb" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 26 | 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:
[ "8cdbafc3-3aaf-4e31-b31c-6acecfb58ff9" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 27 | 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:
[ "d842520e-06fc-43d5-a68e-91f041f2ab5f" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 28 | 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:
[ "0db97895-aff8-4728-89fb-1ee72b055608" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 29 | 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:
[ "2a746556-425e-488d-bd54-b8085f61a48a" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 30 | 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:
[ "5ce181a6-bfcb-4c59-91ca-1c13c574c111" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "CANCELED" ] |
| 31 | 9.83 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:
[ "585221c0-8b97-41d7-9890-f41efcba9fdd" "2026-03-15 00:00:00" "2026-06-16 15:13:50" "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 |
|