Query Metrics
6
Database Queries
6
Different statements
10.66 ms
Query time
0
Invalid entities
495
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.83 ms (26.56%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.club_meeting AS club_meeting_3, t0.depth AS depth_4, t0.club_member AS club_member_5, t0.remark AS remark_6, t0.group_number AS group_number_7, t0.diver_number AS diver_number_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.registration_end_date AS registration_end_date_11, t0.ship_meeting AS ship_meeting_12, t0.cancelation AS cancelation_13, t0.confirmation AS confirmation_14, t0.is_paid AS is_paid_15, t0.price AS price_16, t0.created_by_id AS created_by_id_17, t0.skipper_id AS skipper_id_18, t0.location_id AS location_id_19, t0.dive_type_id AS dive_type_id_20, t0.level_id AS level_id_21, t0.dive_master_id AS dive_master_id_22, t0.file_id AS file_id_23 FROM dive t0
Parameters:
[] |
|
2.16 ms (20.22%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.club_meeting AS club_meeting_4, t0.max_people AS max_people_5, t0.club_member AS club_member_6, t0.is_paid AS is_paid_7, t0.price AS price_8, t0.hello_asso_widget AS hello_asso_widget_9, t0.event_type_id AS event_type_id_10, t0.event_location_id AS event_location_id_11, t0.created_by_id AS created_by_id_12, t0.file_id AS file_id_13 FROM event t0
Parameters:
[] |
|
1.61 ms (15.10%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.licence_number AS licence_number_8, t0.phone AS phone_9, t0.emergency_phone AS emergency_phone_10, t0.kinship AS kinship_11, t0.secondary_mail AS secondary_mail_12, t0.birthday AS birthday_13, t0.skipper AS skipper_14, t0.place_birth AS place_birth_15, t0.profil_picture AS profil_picture_16, t0.bail AS bail_17, t0.club_member AS club_member_18, t0.payment_method AS payment_method_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_rights AS image_rights_22, t0.other_level AS other_level_23, t0.address AS address_24, t0.medical_certificate AS medical_certificate_25, t0.training AS training_26, t0.level_id AS level_id_27 FROM `user` t0
Parameters:
[] |
|
1.46 ms (13.70%) |
1 |
SELECT t0.id AS id_1, t0.group_number AS group_number_2, t0.dive_leader AS dive_leader_3, t0.payment_status AS payment_status_4, t0.hello_asso_checkout_id AS hello_asso_checkout_id_5, t0.hello_asso_payment_id AS hello_asso_payment_id_6, t0.dive_id AS dive_id_7, t0.user_id AS user_id_8 FROM dive_booking t0 WHERE t0.user_id = ?
Parameters:
[
29
]
|
|
1.41 ms (13.22%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.club_meeting AS club_meeting_2, d0_.depth AS depth_3, d0_.club_member AS club_member_4, d0_.remark AS remark_5, d0_.group_number AS group_number_6, d0_.diver_number AS diver_number_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9, d0_.registration_end_date AS registration_end_date_10, d0_.ship_meeting AS ship_meeting_11, d0_.cancelation AS cancelation_12, d0_.confirmation AS confirmation_13, d0_.is_paid AS is_paid_14, d0_.price AS price_15, d0_.created_by_id AS created_by_id_16, d0_.skipper_id AS skipper_id_17, d0_.location_id AS location_id_18, d0_.dive_type_id AS dive_type_id_19, d0_.level_id AS level_id_20, d0_.dive_master_id AS dive_master_id_21, d0_.file_id AS file_id_22 FROM dive d0_ WHERE d0_.club_meeting >= ? AND d0_.cancelation <> 1
Parameters:
[
"2026-06-27"
]
|
|
1.19 ms (11.19%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.content AS content_2, e0_.club_meeting AS club_meeting_3, e0_.max_people AS max_people_4, e0_.club_member AS club_member_5, e0_.is_paid AS is_paid_6, e0_.price AS price_7, e0_.hello_asso_widget AS hello_asso_widget_8, e0_.event_type_id AS event_type_id_9, e0_.event_location_id AS event_location_id_10, e0_.created_by_id AS created_by_id_11, e0_.file_id AS file_id_12 FROM event e0_ WHERE e0_.club_meeting >= ?
Parameters:
[
"2026-06-27"
]
|
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 |
|---|---|
| App\Entity\Dive | 165 |
| App\Entity\Event | 112 |
| App\Entity\User | 91 |
| App\Entity\Files | 56 |
| App\Entity\EventLocation | 20 |
| App\Entity\Level | 17 |
| App\Entity\DiveBooking | 13 |
| App\Entity\DiveLocation | 8 |
| App\Entity\EventType | 8 |
| App\Entity\DiveType | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Dive | No errors. |
| App\Entity\User | No errors. |
| App\Entity\DiveLocation | No errors. |
| App\Entity\DiveType | No errors. |
| App\Entity\Level | No errors. |
| App\Entity\Files | No errors. |
| App\Entity\DiveBooking | No errors. |
| App\Entity\Qualification | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\EventBooking | No errors. |
| App\Entity\EventType | No errors. |
| App\Entity\EventLocation | No errors. |