GET https://backend.chalet-montagne.com/api/public-front/hostings/21445/home

Query Metrics

32 Database Queries
26 Different statements
4.71 ms Query time
0 Invalid entities
108 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surface AS surface_3, t0.nb_places AS nb_places_4, t0.max_nb_places_with_baby AS max_nb_places_with_baby_5, t0.nb_confortable_places AS nb_confortable_places_6, t0.nb_double_bed AS nb_double_bed_7, t0.nb_simple_bed AS nb_simple_bed_8, t0.nb_sofa_bed AS nb_sofa_bed_9, t0.nb_rooms AS nb_rooms_10, t0.sanitary AS sanitary_11, t0.independent_sanitary AS independent_sanitary_12, t0.shower AS shower_13, t0.bathrooms AS bathrooms_14, t0.energetic_performance_diag_ce AS energetic_performance_diag_ce_15, t0.energetic_performance_diag_ges AS energetic_performance_diag_ges_16, t0.surface_under1_m80_height AS surface_under1_m80_height_17, t0.points AS points_18, t0.classification_registration_number AS classification_registration_number_19, t0.classification_registration_date AS classification_registration_date_20, t0.external_gateway_id AS external_gateway_id_21, t0.created_at AS created_at_22, t0.deleted_at AS deleted_at_23, t0.is_on_operational_tour_website AS is_on_operational_tour_website_24, t0.internet_incoming_flow AS internet_incoming_flow_25, t0.internet_outcoming_flow AS internet_outcoming_flow_26, t0.internet_gsm_infos AS internet_gsm_infos_27, t0.translations_local_source AS translations_local_source_28, t0.optimisation_page_consulting_date AS optimisation_page_consulting_date_29, t0.is_hosting_primary_house AS is_hosting_primary_house_30, t0.is_hosting_secondary_house AS is_hosting_secondary_house_31, t0.is_city_hall_declared AS is_city_hall_declared_32, t0.sunday_hosting_preference AS sunday_hosting_preference_33, t0.is_city_hall_simple_declaration AS is_city_hall_simple_declaration_34, t0.is_owner AS is_owner_35, t0.city_hall_declaration_number AS city_hall_declaration_number_36, t0.city_hall_declaration_date AS city_hall_declaration_date_37, t0.city_hall_declaration_date_signature AS city_hall_declaration_date_signature_38, t0.latitude AS latitude_39, t0.longitude AS longitude_40, t0.sea_view_angle AS sea_view_angle_41, t0.km_distance_from_sea AS km_distance_from_sea_42, t0.address AS address_43, t0.zip AS zip_44, t0.city AS city_45, t0.optional_address_info AS optional_address_info_46, t0.is_address_valid AS is_address_valid_47, t0.nb_pieces AS nb_pieces_48, t0.reference AS reference_49, t0.alur_target_charge_value AS alur_target_charge_value_50, t0.alur_corpo_value AS alur_corpo_value_51, t0.is_on_personal_website_welcome_page AS is_on_personal_website_welcome_page_52, t0.insurance_link_fr AS insurance_link_fr_53, t0.insurance_link_en AS insurance_link_en_54, t0.is_on_website_to AS is_on_website_to_55, t0.charges AS charges_56, t0.only_for_sale AS only_for_sale_57, t0.sunday_for_rent AS sunday_for_rent_58, t0.saturday_for_rent AS saturday_for_rent_59, t0.has_short_stay AS has_short_stay_60, t0.end_date AS end_date_61, t0.website_url AS website_url_62, t0.video_code AS video_code_63, t0.hosting_type_id AS hosting_type_id_64, t0.distance_from_station_km_id AS distance_from_station_km_id_65, t0.distance_from_ski_lift_id AS distance_from_ski_lift_id_66, t0.tag_id AS tag_id_67, t0.hosting_class_id AS hosting_class_id_68, t0.spot_id AS spot_id_69, t0.sale_id AS sale_id_70, t0.rental_id AS rental_id_71, t0.floor_id AS floor_id_72, t0.lessor_id AS lessor_id_73, t0.country_id AS country_id_74, t0.geo_ville_id AS geo_ville_id_75, t0.distance_from_station_km2_id AS distance_from_station_km2_id_76, t0.distance_from_ski_lift2_id AS distance_from_ski_lift2_id_77, t0.main_station_id AS main_station_id_78, t0.secondary_station_id AS secondary_station_id_79 FROM hosting t0 WHERE t0.id = ?
Parameters:
[
  21445
]
2 0.22 ms
SELECT t0.id AS id_1, t0.is_renting_active AS is_renting_active_2, t0.system_is_renting_allowed AS system_is_renting_allowed_3, t0.system_is_annual_renting_allowed AS system_is_annual_renting_allowed_4, t0.system_is_auto_resa_allowed AS system_is_auto_resa_allowed_5, t0.is_on_personal_website AS is_on_personal_website_6, t0.is_rental_seasonal_on_personal_website AS is_rental_seasonal_on_personal_website_7, t0.is_rental_annual_on_personal_website AS is_rental_annual_on_personal_website_8, t0.visitor_tax_included AS visitor_tax_included_9, t0.system_is_rental_city_hall_compliant AS system_is_rental_city_hall_compliant_10, t0.all_summer_renting_price AS all_summer_renting_price_11, t0.all_winter_renting_price AS all_winter_renting_price_12, t0.is_banking_card_booking_active AS is_banking_card_booking_active_13, t0.exceptional_rental AS exceptional_rental_14, t0.system_is_renting_downgraded AS system_is_renting_downgraded_15, t0.booking_fees AS booking_fees_16, t0.weekly_rental_fees AS weekly_rental_fees_17, t0.monthly_rental_fees AS monthly_rental_fees_18, t0.monthly_off_load_rental_fees AS monthly_off_load_rental_fees_19, t0.automated_points_distribution AS automated_points_distribution_20, t0.is_rental_contract_active AS is_rental_contract_active_21, t0.contract_signature_days_limit AS contract_signature_days_limit_22, t0.rest_on_advance_payment_days_limit AS rest_on_advance_payment_days_limit_23, t0.advance_on_rental AS advance_on_rental_24, t0.deposit AS deposit_25, t0.system_rating AS system_rating_26, t0.nb_allowed_animals AS nb_allowed_animals_27, t0.checkin_hour AS checkin_hour_28, t0.checkout_hour AS checkout_hour_29, t0.system_last_price_date AS system_last_price_date_30, t0.admin_moderation_date AS admin_moderation_date_31, t0.boost_date AS boost_date_32, t0.system_rating_updated_at AS system_rating_updated_at_33, t0.last_planning_updated_at AS last_planning_updated_at_34, t0.system_last_non_complaint_email_date AS system_last_non_complaint_email_date_35, t0.created_at AS created_at_36, t0.deleted_at AS deleted_at_37, t0.updated_at AS updated_at_38, t0.annulation_nb_days AS annulation_nb_days_39, t0.all_year_renting_price AS all_year_renting_price_40, t0.alert_level AS alert_level_41, t0.system_last_price_alert_date AS system_last_price_alert_date_42, t0.accept_non_compliant_requests AS accept_non_compliant_requests_43, t0.annulation_condition_id AS annulation_condition_id_44 FROM rental t0 WHERE t0.id = ?
Parameters:
[
  10808
]
3 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.active AS active_4, t0.planning_updated_at AS planning_updated_at_5, t0.planning_confirmed_at AS planning_confirmed_at_6, t0.master AS master_7, t0.auto_alert AS auto_alert_8, t0.hosting_id AS hosting_id_9 FROM ical_urls t0 WHERE t0.hosting_id = ?
Parameters:
[
  21445
]
4 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.number AS number_4 FROM country t0 WHERE t0.id = ?
Parameters:
[
  76
]
5 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.subscription_price AS subscription_price_4, t0.contact_credit_rate AS contact_credit_rate_5, t0.name_en AS name_en_6, t0.name_it AS name_it_7, t0.name_sp AS name_sp_8, t0.name_nl AS name_nl_9, t0.name_de AS name_de_10, t0.slug_en AS slug_en_11, t0.slug_it AS slug_it_12, t0.slug_sp AS slug_sp_13, t0.slug_nl AS slug_nl_14, t0.slug_de AS slug_de_15 FROM hosting_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.08 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.host AS host_3, t0.q1 AS q1_4, t0.q2 AS q2_5, t0.q3 AS q3_6, t0.q4 AS q4_7, t0.q5 AS q5_8, t0.comment AS comment_9, t0.hosting_contact_id AS hosting_contact_id_10, t0.hosting_id AS hosting_id_11 FROM hosting_reviews t0 WHERE t0.hosting_id = ?
Parameters:
[
  21445
]
7 0.11 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.comment AS comment_3, t0.ordre AS ordre_4, t0.type AS type_5, t0.comment_en AS comment_en_6, t0.updated_at AS updated_at_7, t0.hosting_id AS hosting_id_8 FROM image t0 WHERE t0.hosting_id = ?
Parameters:
[
  21445
]
8 0.11 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.hosting_id AS hosting_id_3, t0.hosting_options_id AS hosting_options_id_4, t0.included_hosting_options_id AS included_hosting_options_id_5, t0.private_hosting_options_id AS private_hosting_options_id_6 FROM hosting_options_preferences t0 WHERE t0.hosting_id = ?
Parameters:
[
  21445
]
9 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.research AS research_3, t0.included AS included_4, t0.is_private AS is_private_5, t0.is_price AS is_price_6, t0.old_id AS old_id_7, t0.cat AS cat_8, t0.cat1 AS cat1_9, t0.cat2 AS cat2_10, t0.priority AS priority_11, t0.sell AS sell_12, t0.subscription_type AS subscription_type_13, t0.correspondance AS correspondance_14, t0.theme AS theme_15, t0.name_en AS name_en_16, t0.name_it AS name_it_17, t0.name_sp AS name_sp_18, t0.name_nl AS name_nl_19, t0.name_de AS name_de_20, t0.type_id AS type_id_21 FROM hosting_options t0 WHERE t0.id = ?
Parameters:
[
  21
]
10 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM hosting_options_type t0 WHERE t0.id = ?
Parameters:
[
  3
]
11 0.12 ms
SELECT t0.id AS id_1, t0.value AS value_2 FROM included_hosting_options t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 0.12 ms
SELECT t0.id AS id_1, t0.value AS value_2 FROM private_hosting_options t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.research AS research_3, t0.included AS included_4, t0.is_private AS is_private_5, t0.is_price AS is_price_6, t0.old_id AS old_id_7, t0.cat AS cat_8, t0.cat1 AS cat1_9, t0.cat2 AS cat2_10, t0.priority AS priority_11, t0.sell AS sell_12, t0.subscription_type AS subscription_type_13, t0.correspondance AS correspondance_14, t0.theme AS theme_15, t0.name_en AS name_en_16, t0.name_it AS name_it_17, t0.name_sp AS name_sp_18, t0.name_nl AS name_nl_19, t0.name_de AS name_de_20, t0.type_id AS type_id_21 FROM hosting_options t0 WHERE t0.id = ?
Parameters:
[
  24
]
14 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.research AS research_3, t0.included AS included_4, t0.is_private AS is_private_5, t0.is_price AS is_price_6, t0.old_id AS old_id_7, t0.cat AS cat_8, t0.cat1 AS cat1_9, t0.cat2 AS cat2_10, t0.priority AS priority_11, t0.sell AS sell_12, t0.subscription_type AS subscription_type_13, t0.correspondance AS correspondance_14, t0.theme AS theme_15, t0.name_en AS name_en_16, t0.name_it AS name_it_17, t0.name_sp AS name_sp_18, t0.name_nl AS name_nl_19, t0.name_de AS name_de_20, t0.type_id AS type_id_21 FROM hosting_options t0 WHERE t0.id = ?
Parameters:
[
  45
]
15 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM hosting_options_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
16 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.research AS research_3, t0.included AS included_4, t0.is_private AS is_private_5, t0.is_price AS is_price_6, t0.old_id AS old_id_7, t0.cat AS cat_8, t0.cat1 AS cat1_9, t0.cat2 AS cat2_10, t0.priority AS priority_11, t0.sell AS sell_12, t0.subscription_type AS subscription_type_13, t0.correspondance AS correspondance_14, t0.theme AS theme_15, t0.name_en AS name_en_16, t0.name_it AS name_it_17, t0.name_sp AS name_sp_18, t0.name_nl AS name_nl_19, t0.name_de AS name_de_20, t0.type_id AS type_id_21 FROM hosting_options t0 ORDER BY t0.priority ASC, t0.name ASC
Parameters:
[]
17 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM hosting_options_type t0 WHERE t0.id = ?
Parameters:
[
  6
]
18 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM hosting_options_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
19 0.15 ms
SELECT t0.id AS id_1, t0.slug_name AS slug_name_2, t0.name AS name_3, t0.massif AS massif_4, t0.massif_txt AS massif_txt_5, t0.country AS country_6, t0.country_code AS country_code_7, t0.office_number AS office_number_8, t0.office_url AS office_url_9, t0.alt_station AS alt_station_10, t0.alt_maxi AS alt_maxi_11, t0.km_ski_alpin AS km_ski_alpin_12, t0.km_ski_fond AS km_ski_fond_13, t0.snow_park AS snow_park_14, t0.url_web_cam AS url_web_cam_15, t0.url_meteo AS url_meteo_16, t0.url_ski_lift AS url_ski_lift_17, t0.url_school_ski AS url_school_ski_18, t0.email AS email_19, t0.password AS password_20, t0.description AS description_21, t0.descriptionuk AS descriptionuk_22, t0.id_ski_france AS id_ski_france_23, t0.id_ski_france_secondary AS id_ski_france_secondary_24, t0.id_sitra AS id_sitra_25, t0.latitude AS latitude_26, t0.longitude AS longitude_27, t0.cy_id AS cy_id_28, t0.cy_slug AS cy_slug_29, t0.department AS department_30, t0.department_slug AS department_slug_31, t0.department_code AS department_code_32, t0.insee_code AS insee_code_33, t0.zip AS zip_34, t0.region AS region_35, t0.sector_id AS sector_id_36 FROM station t0 WHERE t0.id = ?
Parameters:
[
  248
]
20 0.15 ms
SELECT DISTINCT s0_.ski_domain_id AS sclr_0 FROM station_ski_domain s0_ WHERE s0_.station_id IN (?)
Parameters:
[
  248
]
21 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug_name AS slug_name_3, t0.name_en AS name_en_4, t0.name_it AS name_it_5, t0.name_sp AS name_sp_6, t0.name_nl AS name_nl_7, t0.name_de AS name_de_8, t0.slug_name_en AS slug_name_en_9, t0.slug_name_it AS slug_name_it_10, t0.slug_name_sp AS slug_name_sp_11, t0.slug_name_nl AS slug_name_nl_12, t0.slug_name_de AS slug_name_de_13 FROM sector t0 WHERE t0.id = ?
Parameters:
[
  1
]
22 0.08 ms
SELECT t0.id AS id_1, t0.distance AS distance_2, t0.name AS name_3, t0.ordre AS ordre_4, t0.name_en AS name_en_5, t0.name_it AS name_it_6, t0.name_sp AS name_sp_7, t0.name_nl AS name_nl_8, t0.name_de AS name_de_9, t0.name_es AS name_es_10 FROM hosting_distance t0 WHERE t0.id = ?
Parameters:
[
  99
]
23 0.08 ms
SELECT t0.id AS id_1, t0.distance AS distance_2, t0.name AS name_3, t0.ordre AS ordre_4, t0.name_en AS name_en_5, t0.name_it AS name_it_6, t0.name_sp AS name_sp_7, t0.name_nl AS name_nl_8, t0.name_de AS name_de_9, t0.name_es AS name_es_10 FROM hosting_distance t0 WHERE t0.id = ?
Parameters:
[
  12
]
24 0.56 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.auto AS auto_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.locale_source AS locale_source_6, t0.hosting_id AS hosting_id_7 FROM hosting_translation t0 WHERE t0.hosting_id = ? ORDER BY t0.updated_at DESC
Parameters:
[
  21445
]
25 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.detailed_name AS detailed_name_3, t0.name_en AS name_en_4, t0.detailed_name_en AS detailed_name_en_5, t0.name_it AS name_it_6, t0.detailed_name_it AS detailed_name_it_7, t0.name_es AS name_es_8, t0.detailed_name_es AS detailed_name_es_9, t0.name_nl AS name_nl_10, t0.detailed_name_nl AS detailed_name_nl_11, t0.name_de AS name_de_12, t0.detailed_name_de AS detailed_name_de_13 FROM floor t0 WHERE t0.id = ?
Parameters:
[
  2
]
26 0.08 ms
SELECT t0.id AS id_1, t0.classification AS classification_2, t0.level AS level_3, t0.classification_en AS classification_en_4, t0.classification_it AS classification_it_5, t0.classification_sp AS classification_sp_6, t0.classification_nl AS classification_nl_7, t0.classification_de AS classification_de_8 FROM hosting_class t0 WHERE t0.id = ?
Parameters:
[
  1
]
27 0.20 ms
SELECT ps.*
            FROM pricing_schedule ps
            WHERE ps.hosting_id = ?
              AND ps.base_price IS NOT NULL
              AND ps.base_price > 0
              AND (ps.starting_date IS NULL OR ps.starting_date <= NOW())
              AND (
                  -- Week prices: strict 7-day slot, only future
                  (
                      ps.min_nb_of_nights = 7
                      AND DATEDIFF(ps.end_date, ps.start_date) = 7
                      AND ps.start_date >= ?
                  )
                  OR
                  -- Advanced prices: period != strict week, show while enough nights remain
                  (
                      (DATEDIFF(ps.end_date, ps.start_date) != 7 OR COALESCE(ps.min_nb_of_nights, 7) != 7)
                      AND ps.end_date >= ?
                      AND DATEDIFF(ps.end_date, ?) >= COALESCE(ps.min_nb_of_nights, 1)
                  )
              )
            ORDER BY ps.start_date ASC
Parameters:
[
  21445
  "2026-06-10"
  "2026-06-10"
  "2026-06-10"
]
28 0.12 ms
SELECT p0_.id AS id_0, p0_.start_date AS start_date_1, p0_.end_date AS end_date_2, p0_.week_price AS week_price_3, p0_.comment AS comment_4, p0_.base_price AS base_price_5, p0_.additional_night_price AS additional_night_price_6, p0_.min_nb_of_nights AS min_nb_of_nights_7, p0_.starting_date AS starting_date_8, p0_.discount_percentage AS discount_percentage_9, p0_.arrival_day AS arrival_day_10, p0_.hosting_id AS hosting_id_11 FROM pricing_schedule p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.start_date ASC
Parameters:
[
  77570554
  77570555
  77570556
  77570557
  77570558
  77570559
  77570560
  77570561
]
29 0.18 ms
SELECT
                p.id,
                p.hosting_id as hosting_id,
                p.start_date,
                p.end_date,
                p.date_last_update AS datelastupdate,
                p.description,
                p.ical_url_id,
                ical.title as ical_title,
                ps.value as planning_state_value,
                ps.id as planning_state_id,
                pr.value as planning_reason_value,
                pr.id as planning_reason_id
            FROM planning p
            LEFT JOIN planning_state ps ON p.planning_state_id = ps.id
            LEFT JOIN planning_reason pr ON p.planning_reason_id = pr.id
            LEFT JOIN ical_urls ical ON p.ical_url_id = ical.id
            WHERE p.hosting_id = ?
              AND p.start_date <= ? AND p.end_date >= ?
            ORDER BY p.start_date ASC
Parameters:
[
  21445
  "2028-06-01"
  "2026-06-01"
]
30 0.22 ms
SELECT t1.id AS id_2, t1.uuid AS uuid_3, t1.password AS password_4, t1.email AS email_5, t1.is_active AS is_active_6, t1.verification_token AS verification_token_7, t1.first_name AS first_name_8, t1.last_name AS last_name_9, t1.old_id AS old_id_10, t1.email_validation_date AS email_validation_date_11, t1.is_phone_active AS is_phone_active_12, t1.last_login_date AS last_login_date_13, t1.created_at AS created_at_14, t1.updated_at AS updated_at_15, t1.address AS address_16, t1.address_line2 AS address_line2_17, t1.zip AS zip_18, t1.city AS city_19, t1.latitude AS latitude_20, t1.longitude AS longitude_21, t1.hide_address AS hide_address_22, t1.address_validated_at AS address_validated_at_23, t1.address_sent_at AS address_sent_at_24, t1.deleted_at AS deleted_at_25, t1.is_cm_invoice_lessor AS is_cm_invoice_lessor_26, t1.tour_operator_credit AS tour_operator_credit_27, t1.password_otp_code AS password_otp_code_28, t1.password_otp_expires_at AS password_otp_expires_at_29, t1.email_verification_code AS email_verification_code_30, t1.email_verification_code_expires_at AS email_verification_code_expires_at_31, t1.session_version AS session_version_32, t0.suspicion_level AS suspicion_level_33, t0.trusted AS trusted_34, t0.points AS points_35, t0.date_end_trust AS date_end_trust_36, t0.contact_credit AS contact_credit_37, t0.repondeur AS repondeur_38, t0.system_is_lessor_without_contact_credit AS system_is_lessor_without_contact_credit_39, t0.mail_sending_date AS mail_sending_date_40, t0.stripe_connect AS stripe_connect_41, t0.system_is_confidence_blocked AS system_is_confidence_blocked_42, t0.stock_boost AS stock_boost_43, t0.is_pro AS is_pro_44, t0.is_name_masked AS is_name_masked_45, t0.is_phone_masked AS is_phone_masked_46, t0.is_vacation_checks_allowed AS is_vacation_checks_allowed_47, t0.is_sms_active AS is_sms_active_48, t0.sms_credit AS sms_credit_49, t0.img_profile AS img_profile_50, t0.img_logo AS img_logo_51, t0.missing_price_alert_date AS missing_price_alert_date_52, t0.secondary_email AS secondary_email_53, t0.is_active_contact AS is_active_contact_54, t0.is_hosting_contracts AS is_hosting_contracts_55, t0.secondary_email_validation_date AS secondary_email_validation_date_56, t0.description AS description_57, t0.url AS url_58, t0.description_en AS description_en_59, t1.role_id AS role_id_60, t1.country_id AS country_id_61, t1.company_id AS company_id_62, t1.phone_number_id AS phone_number_id_63, t1.landline_phone_number_id AS landline_phone_number_id_64, t0.referral_id AS referral_id_65, t0.lessor_type_id AS lessor_type_id_66, t0.security_id AS security_id_67, t1.user_type FROM lessor t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  15134
]
31 0.14 ms
SELECT t0.id AS id_1, t0.value AS value_2 FROM language t0 INNER JOIN lessor_language ON t0.id = lessor_language.language_id WHERE lessor_language.lessor_id = ?
Parameters:
[
  15134
]
32 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.name_it AS name_it_4, t0.name_sp AS name_sp_5, t0.name_nl AS name_nl_6, t0.name_de AS name_de_7, t0.name_es AS name_es_8 FROM lessor_type t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\HostingOptions 51
App\Entity\Image 14
App\Entity\PricingSchedule 8
App\Entity\HostingTranslation 6
App\Entity\HostingOptionsType 4
App\Entity\HostingOptionsPreferences 3
App\Entity\Language 3
App\Entity\HostingDistance 2
App\Entity\Phone 2
App\Entity\Hosting 1
App\Entity\HostingType 1
App\Entity\HostingClass 1
App\Entity\Rental 1
App\Entity\Floor 1
App\Entity\User 1
App\Entity\Country 1
App\Entity\Station 1
App\Entity\IncludedHostingOptions 1
App\Entity\PrivateHostingOptions 1
App\Entity\Sector 1
App\Entity\Role 1
App\Entity\Company 1
App\Entity\LessorType 1
App\Entity\LessorSecurity 1