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

Query Metrics

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

Queries

Group similar statements

# 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
  • 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.