Query Metrics
31
Database Queries
2
Different statements
29.06 ms
Query time
2
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 16.19 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.created_at DESC NULLS LAST LIMIT :limit
Parameters:
[ "status" => "status.public" "limit" => 30 ] |
| 2 | 1.24 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:
[ "89cb1462-5287-4add-85b5-c27e47d88ebe" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 3 | 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:
[ "07a26555-a5ed-4567-9181-ecee48a4aba5" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 4 | 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:
[ "4c6f1ff9-d193-4963-b939-e912d0694dc9" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 5 | 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:
[ "2878a84c-265a-4099-ae9f-c3acf1e68c36" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 6 | 0.35 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:
[ "b0c7c21b-b1ee-4b81-af90-06e6ac2855da" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 7 | 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:
[ "761bc16b-a00f-40fb-8f06-ff03fc8b767a" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 8 | 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:
[ "4f3eda8b-5e35-4f35-b9d5-a52ca9b0c4f7" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 9 | 0.48 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:
[ "0bd3e62d-1c42-4c0b-845e-ed7323187c20" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 10 | 0.35 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:
[ "aac62f5a-f535-4e81-8c95-bac33e9bb31e" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 11 | 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:
[ "3521eb48-6a08-41b1-8e81-1d462ceccaec" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "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:
[ "52a5cf74-12c1-46db-a4ef-0b12a3817929" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 13 | 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:
[ "edd1d315-f8d0-4c84-b0e4-430b460830d4" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 14 | 0.49 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:
[ "c5f7751b-7c48-41ba-8110-316e836c130e" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "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:
[ "4b8ffdf7-2ef3-4f15-8d4e-fc8918264b7a" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 16 | 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:
[ "bb93f2d4-9790-440e-9a42-877ac8f5356d" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 17 | 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:
[ "864d533b-b383-4201-9da7-9ea0a4c23e3c" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 18 | 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:
[ "282db30b-3be9-43e4-aee9-ad0bf3dff5a3" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 19 | 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:
[ "b307ea98-f26a-4ec9-a76b-638ea99ea39f" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "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:
[ "e2e43d4e-bfc4-4993-b193-25cfe3a792f7" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 21 | 0.48 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:
[ "3e950559-1582-4174-a341-d038d7ba0ca4" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 22 | 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:
[ "3713f80d-a4a9-40ed-82da-ec01c281a312" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 23 | 0.31 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:
[ "41f7e6db-00e0-4381-a657-8e6a7d542bfa" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 24 | 0.32 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:
[ "8c23f241-14fa-436b-94ca-1a755172ce4e" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 25 | 0.35 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:
[ "ae3bcdef-65f0-4efc-9059-53c36f7a18fd" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 26 | 0.31 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:
[ "7d903a53-8eff-41ba-bd76-af96f1f992b5" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 27 | 0.31 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:
[ "9f0946f0-3d5c-4983-8103-21e012f6b6d3" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 28 | 0.32 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:
[ "3b9b9fc0-d663-4c35-9841-0dac2b412e2d" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 29 | 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:
[ "a4018c01-1988-409a-9b98-d133885d1bc5" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 30 | 0.32 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:
[ "d1fd6ff6-57e6-4669-a9fb-73ad7493d0d8" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "CANCELED" ] |
| 31 | 0.51 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:
[ "1315730b-b581-4f6a-a540-4dcea02c27d3" "2026-01-18 00:00:00" "2026-04-19 20:14:30" "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 |
|