https://gite-colombine.fr/fr/booking

Query Metrics

26 Database Queries
14 Different statements
12.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT t0.id AS id_1 FROM seo t0 LIMIT 1
Parameters:
[]
2 0.57 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.address AS address_5, t0.additionnal_address AS additionnal_address_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.logo AS logo_9, t0.updated_at AS updated_at_10, t0.siteweb AS siteweb_11 FROM about_info t0 LIMIT 1
Parameters:
[]
3 0.49 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.avatar AS avatar_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM profile t0 LIMIT 1
Parameters:
[]
4 0.72 ms
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 LIMIT 1
Parameters:
[]
5 1.05 ms
SELECT t0.id AS id_1, t0.cover_image AS cover_image_2, t0.updated_at AS updated_at_3, t0.page AS page_4 FROM page_header t0 WHERE t0.page = ? LIMIT 1
Parameters:
[
  "booking"
]
6 0.52 ms
SELECT t0.id AS id_1 FROM booking_contract t0 LIMIT 1
Parameters:
[]
7 0.56 ms
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
]
8 0.55 ms
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
]
9 0.53 ms
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:
[
  7
]
10 0.54 ms
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:
[
  8
]
11 0.51 ms
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:
[
  9
]
12 0.78 ms
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 LIMIT 1
Parameters:
[]
13 0.85 ms
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
]
14 0.47 ms
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
]
15 0.34 ms
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:
[
  2
]
16 0.30 ms
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 LIMIT 1
Parameters:
[]
17 0.29 ms
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 LIMIT 1
Parameters:
[]
18 0.27 ms
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 LIMIT 1
Parameters:
[]
19 0.28 ms
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 LIMIT 1
Parameters:
[]
20 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.introduction AS introduction_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM page_header_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
21 0.53 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.gender AS gender_6, t0.approval AS approval_7, t0.rgpd AS rgpd_8, t0.payment_method AS payment_method_9, t0.created_at AS created_at_10, t0.comment AS comment_11, t0.number AS number_12, t0.start_date AS start_date_13, t0.end_date AS end_date_14, t0.amount AS amount_15, t0.uniq_id AS uniq_id_16, t0.deposit AS deposit_17, t0.discount AS discount_18, t0.is_advance_payed AS is_advance_payed_19, t0.is_balance_payed AS is_balance_payed_20, t0.balance_payment_deadline AS balance_payment_deadline_21, t0.advance_payment AS advance_payment_22, t0.advance_payment_deadline AS advance_payment_deadline_23, t0.locale AS locale_24, t0.is_advance_payment_alert1 AS is_advance_payment_alert1_25, t0.is_advance_payment_alert2 AS is_advance_payment_alert2_26, t0.is_balance_payment_alert1 AS is_balance_payment_alert1_27, t0.is_balance_payment_alert2 AS is_balance_payment_alert2_28, t0.is_for_soon AS is_for_soon_29, t0.tracking AS tracking_30, t0.is_caution_payed AS is_caution_payed_31, t0.caution_payment_deadline AS caution_payment_deadline_32, t0.is_caution_payment_alert1 AS is_caution_payment_alert1_33, t0.is_caution_payment_alert2 AS is_caution_payment_alert2_34, t0.stay_tax AS stay_tax_35, t0.housework AS housework_36, t0.final_amount AS final_amount_37, t0.day_price AS day_price_38, t0.day_price_with_tax AS day_price_with_tax_39, t0.contract AS contract_40, t0.swikly_request_id AS swikly_request_id_41, t0.swikly_url AS swikly_url_42, t0.children AS children_43, t0.booking_constraint_id AS booking_constraint_id_44 FROM booking t0 WHERE t0.booking_constraint_id = ?
Parameters:
[
  1
]
22 0.37 ms
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
]
23 0.38 ms
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
]
24 0.31 ms
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:
[
  7
]
25 0.29 ms
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:
[
  8
]
26 0.28 ms
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:
[
  9
]

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\SEO No errors.
App\Entity\AboutInfo No errors.
App\Entity\Profile No errors.
App\Entity\PageHeader No errors.
App\Entity\BookingConstraint No errors.
App\Entity\SEOKeyword No errors.
App\Entity\SEOTranslation No errors.
App\Entity\User No errors.
App\Entity\BookingConstraintPeriod No errors.
App\Entity\Booking No errors.
App\Entity\BookingPaymentMethod No errors.
App\Entity\BookingConstraintSaison No errors.
App\Entity\BookingConstraintTranslation No errors.
App\Entity\BookingContract No errors.
App\Entity\BookingMail No errors.
App\Entity\PageHeaderTranslation No errors.
App\Entity\BookingContractTranslation No errors.
App\Entity\BookingConstraintSaisonPeriod No errors.
App\Entity\BookingConstraintSaisonTranslation No errors.
App\Entity\BookingPaymentMethodTranslation No errors.