GET https://recette.junglebike.fr/search/workshop

Query Metrics

31 Database Queries
2 Different statements
114.41 ms Query time
2 Invalid entities
0 Managed entities

Queries

Group similar statements

# 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
  • The association App\Entity\Workshop#users refers to the inverse side field App\Entity\User#workshops which does not exist.
App\Entity\Appointment
  • The mappings App\Entity\Appointment#fleet and App\Entity\Fleet#appointments are inconsistent with each other.