GET http://152.228.230.208/search/workshop

Query Metrics

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

Queries

Group similar statements

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