Query Metrics
31
Database Queries
2
Different statements
29.80 ms
Query time
2
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
16.47 ms (55.28%) |
1 |
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 ] |
|
13.33 ms (44.72%) |
30 |
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" ] |
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 |
|