Query Metrics
24
Database Queries
8
Different statements
24.13 ms
Query time
0
Invalid entities
32
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.62 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 WHERE t0.id = ?
Parameters:
[
"207"
]
|
| 2 | 1.34 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
]
|
| 3 | 1.03 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 WHERE t0.id = ? LIMIT 1
Parameters:
[
207
]
|
| 4 | 1.05 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
]
|
| 5 | 0.83 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 | 1.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM dive_location t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.97 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:
[
4
]
|
| 8 | 1.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM dive_type t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 9 | 1.48 ms |
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
]
|
| 10 | 1.13 ms |
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
]
|
| 11 | 0.96 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:
[
19
]
|
| 12 | 0.86 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:
[
6
]
|
| 13 | 0.84 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
]
|
| 14 | 0.94 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:
[
75
]
|
| 15 | 0.94 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:
[
100
]
|
| 16 | 0.92 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:
[
87
]
|
| 17 | 0.90 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
]
|
| 18 | 0.85 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
]
|
| 19 | 0.78 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
]
|
| 20 | 0.86 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:
[
20
]
|
| 21 | 0.85 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:
[
31
]
|
| 22 | 0.84 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:
[
8
]
|
| 23 | 0.80 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:
[
65
]
|
| 24 | 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:
[
15
]
|
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. |