Query Metrics
24
Database Queries
8
Different statements
24.13 ms
Query time
0
Invalid entities
32
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.28 ms (42.59%) |
11 |
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 WHERE t0.id = ?
Parameters:
[
29
]
|
|
5.98 ms (24.79%) |
7 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.adult_with_instructor AS adult_with_instructor_3, t0.adult_without_instructor AS adult_without_instructor_4, t0.minor_with_instructor AS minor_with_instructor_5, t0.minor_without_instructor AS minor_without_instructor_6, t0.level_index AS level_index_7, t0.supervisor AS supervisor_8 FROM level t0 WHERE t0.id = ?
Parameters:
[
17
]
|
|
1.62 ms (6.73%) |
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 WHERE t0.id = ?
Parameters:
[
"207"
]
|
|
1.48 ms (6.12%) |
1 |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3 FROM files t0 WHERE t0.id = ?
Parameters:
[
86
]
|
|
1.39 ms (5.76%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM dive_type t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
1.22 ms (5.04%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM dive_location t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.13 ms (4.69%) |
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.dive_id = ?
Parameters:
[
207
]
|
|
1.03 ms (4.28%) |
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
207
]
|
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\User | 11 |
| App\Entity\DiveBooking | 10 |
| App\Entity\Level | 7 |
| App\Entity\Dive | 1 |
| App\Entity\DiveLocation | 1 |
| App\Entity\DiveType | 1 |
| App\Entity\Files | 1 |
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. |