https://gite-colombine.fr/

Query Metrics

67 Database Queries
37 Different statements
28.95 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.74 ms
(16.37%)
15
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM gallery_image_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
2.27 ms
(7.84%)
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.65 ms
(5.70%)
5
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.introduction AS introduction_4, t0.description AS description_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM service_single_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
1.49 ms
(5.16%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM gallery_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
1.17 ms
(4.03%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.is_home_area AS is_home_area_4, t0.position AS position_5 FROM about_area t0 WHERE t0.is_home_area = ? LIMIT 1
Parameters:
[
  1
]
1.01 ms
(3.49%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.introduction AS introduction_4, t0.slug AS slug_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM hobby_single_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
1.00 ms
(3.47%)
2
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:
[]
0.99 ms
(3.40%)
3
SELECT t0.id AS id_1, t0.url AS url_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM gallery_image t0 WHERE t0.category_id = ?
Parameters:
[
  2
]
0.95 ms
(3.28%)
1
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
]
0.66 ms
(2.29%)
2
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.display AS display_5, t0.category_id AS category_id_6 FROM service_single t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
0.64 ms
(2.22%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM service_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.62 ms
(2.16%)
1
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.comment AS comment_5, t0.feeling AS feeling_6, t0.created_at AS created_at_7, t0.display AS display_8, t0.rgpd AS rgpd_9 FROM testimonial t0 ORDER BY t0.created_at ASC
Parameters:
[]
0.61 ms
(2.12%)
1
SELECT t0.id AS id_1 FROM testimonial_area t0 LIMIT 1
Parameters:
[]
0.61 ms
(2.10%)
1
SELECT t0.id AS id_1 FROM seo t0 LIMIT 1
Parameters:
[]
0.61 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.image_mobile AS image_mobile_4, t0.home_main_slider_id AS home_main_slider_id_5 FROM home_main_slider_image t0
Parameters:
[]
0.60 ms
(2.06%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover_image AS cover_image_3, t0.updated_at AS updated_at_4, t0.display AS display_5 FROM gallery_category t0
Parameters:
[]
0.58 ms
(2.02%)
1
SELECT t0.id AS id_1 FROM gallery_area t0 LIMIT 1
Parameters:
[]
0.58 ms
(2.01%)
1
SELECT t0.id AS id_1, t0.cover_image AS cover_image_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.display AS display_5 FROM hobby_single t0
Parameters:
[]
0.58 ms
(1.99%)
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.55 ms
(1.91%)
1
SELECT t0.id AS id_1 FROM intro_area t0 LIMIT 1
Parameters:
[]
0.54 ms
(1.85%)
1
SELECT t0.id AS id_1 FROM service_area t0 LIMIT 1
Parameters:
[]
0.51 ms
(1.78%)
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.51 ms
(1.76%)
1
SELECT t0.id AS id_1 FROM service_category t0
Parameters:
[]
0.50 ms
(1.71%)
1
SELECT t0.id AS id_1, t0.cover_image AS cover_image_2, t0.updated_at AS updated_at_3 FROM hobby_area t0 LIMIT 1
Parameters:
[]
0.49 ms
(1.68%)
1
SELECT t0.id AS id_1, t0.meta_description AS meta_description_2, t0.title AS title_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM seotranslation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.48 ms
(1.65%)
1
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 intro_area_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.45 ms
(1.55%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.poster AS poster_3, t0.updated_at AS updated_at_4 FROM video t0 LIMIT 1
Parameters:
[]
0.40 ms
(1.40%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM about_area_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.38 ms
(1.30%)
1
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:
[]
0.37 ms
(1.26%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.introduction AS introduction_3, t0.call_to_action AS call_to_action_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM video_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.37 ms
(1.26%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.introduction AS introduction_4, t0.call_to_action AS call_to_action_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM service_area_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.36 ms
(1.24%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM testimonial_area_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.36 ms
(1.23%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.intro_area_id AS intro_area_id_5 FROM intro_area_image t0 WHERE t0.intro_area_id = ?
Parameters:
[
  1
]
0.35 ms
(1.21%)
1
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM intro_area_image_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.34 ms
(1.18%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.introduction AS introduction_4, t0.call_to_action AS call_to_action_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM hobby_area_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.33 ms
(1.13%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.call_to_action AS call_to_action_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM gallery_area_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.31 ms
(1.09%)
1
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:
[]

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\BookingConstraint No errors.
App\Entity\SEO No errors.
App\Entity\AboutInfo No errors.
App\Entity\Profile 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\HomeMainSliderImage No errors.
App\Entity\AboutArea No errors.
App\Entity\IntroArea No errors.
App\Entity\Video No errors.
App\Entity\HobbyArea No errors.
App\Entity\HobbySingle No errors.
App\Entity\GalleryArea No errors.
App\Entity\GalleryCategory No errors.
App\Entity\ServiceArea No errors.
App\Entity\ServiceCategory No errors.
App\Entity\TestimonialArea No errors.
App\Entity\Testimonial No errors.
App\Entity\HomeMainSlider No errors.
App\Entity\IntroAreaImage No errors.
App\Entity\IntroAreaTranslation No errors.
App\Entity\VideoTranslation No errors.
App\Entity\AboutAreaTranslation No errors.
App\Entity\HobbyAreaTranslation No errors.
App\Entity\HobbySingleArea No errors.
App\Entity\HobbySingleTranslation No errors.
App\Entity\GalleryAreaTranslation No errors.
App\Entity\GalleryImage No errors.
App\Entity\GalleryCategoryTranslation No errors.
App\Entity\ServiceAreaTranslation No errors.
App\Entity\ServiceSingle No errors.
App\Entity\ServiceCategoryTranslation No errors.
App\Entity\TestimonialAreaTranslation No errors.
App\Entity\BookingConstraintSaisonPeriod No errors.
App\Entity\BookingConstraintSaisonTranslation No errors.
App\Entity\IntroAreaImageTranslation No errors.
App\Entity\ServiceSingleTranslation No errors.
App\Entity\GalleryImageTranslation No errors.