Query Metrics

16 Database Queries
9 Different statements
6.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.50 ms
(23.05%)
4
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.booking_constraint_saison_id AS booking_constraint_saison_id_4 FROM booking_constraint_saison_period t0 WHERE t0.booking_constraint_saison_id = ?
Parameters:
[
  6
]
1.25 ms
(19.19%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM booking_constraint_saison_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
0.86 ms
(13.22%)
1
SELECT t0.id AS id_1, t0.cgv AS cgv_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM booking_constraint_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.81 ms
(12.38%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.first_name AS first_name_7, t5.last_name AS last_name_8, t5.email AS email_9, t5.phone AS phone_10, t5.avatar AS avatar_11, t5.updated_at AS updated_at_12, t5.user_id AS user_id_13 FROM user t0 LEFT JOIN profile t5 ON t5.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
0.60 ms
(9.27%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM booking_payment_method_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.42 ms
(6.42%)
1
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.booking_constraint_id AS booking_constraint_id_4 FROM booking_constraint_period t0 WHERE t0.booking_constraint_id = ?
Parameters:
[
  1
]
0.41 ms
(6.27%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.max_number AS max_number_3, t0.min_duration AS min_duration_4, t0.max_duration AS max_duration_5, t0.advance_payment AS advance_payment_6, t0.deposit AS deposit_7, t0.long_stay_discount AS long_stay_discount_8, t0.balance_payment_deadline AS balance_payment_deadline_9, t0.advance_payment_deadline AS advance_payment_deadline_10, t0.off_duration AS off_duration_11, t0.blocked_days_after_now AS blocked_days_after_now_12, t0.soon_booking_payment_delay AS soon_booking_payment_delay_13, t0.start_hour AS start_hour_14, t0.end_hour AS end_hour_15, t0.surface AS surface_16, t0.housework AS housework_17, t0.caution_payment_delay AS caution_payment_delay_18, t0.stay_tax AS stay_tax_19 FROM booking_constraint t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.36 ms
(5.57%)
1
SELECT t0.id AS id_1, t0.price AS price_2, t0.icon AS icon_3, t0.booking_constraint_id AS booking_constraint_id_4 FROM booking_constraint_saison t0 WHERE t0.booking_constraint_id = ?
Parameters:
[
  1
]
0.30 ms
(4.64%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.img AS img_3, t0.updated_at AS updated_at_4, t0.booking_constraint_id AS booking_constraint_id_5 FROM booking_payment_method t0 WHERE t0.booking_constraint_id = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Profile No errors.
App\Entity\ContactForm No errors.
App\Entity\Testimonial No errors.
App\Entity\Booking No errors.
App\Entity\BookingConstraint No errors.
App\Entity\BookingConstraintPeriod No errors.
App\Entity\BookingPaymentMethod No errors.
App\Entity\BookingConstraintSaison No errors.
App\Entity\BookingConstraintTranslation No errors.
App\Entity\BookingConstraintSaisonPeriod No errors.
App\Entity\BookingConstraintSaisonTranslation No errors.
App\Entity\BookingPaymentMethodTranslation No errors.