Query Metrics
10
Database Queries
3
Different statements
9.34 ms
Query time
0
Invalid entities
216
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.15 ms |
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
]
|
| 2 | 1.94 ms |
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 ORDER BY t0.club_meeting ASC
Parameters:
[] |
| 3 | 1.35 ms |
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
]
|
| 4 | 0.71 ms |
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:
[
1
]
|
| 5 | 0.66 ms |
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:
[
13
]
|
| 6 | 0.68 ms |
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:
[
3
]
|
| 7 | 0.73 ms |
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:
[
16
]
|
| 8 | 0.68 ms |
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:
[
12
]
|
| 9 | 0.70 ms |
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:
[
10
]
|
| 10 | 0.73 ms |
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:
[
5
]
|
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\User | 16 |
| App\Entity\Files | 14 |
| App\Entity\Level | 8 |
| App\Entity\DiveLocation | 8 |
| App\Entity\DiveType | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Level | No errors. |
| App\Entity\Qualification | No errors. |
| App\Entity\Dive | No errors. |
| App\Entity\DiveBooking | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\EventBooking | No errors. |
| App\Entity\DiveLocation | No errors. |
| App\Entity\DiveType | No errors. |
| App\Entity\Files | No errors. |