Query Metrics
32
Database Queries
26
Different statements
4.71 ms
Query time
0
Invalid entities
108
Managed entities
Queries
| #▲ | 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 |