Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_name AS original_name_3,
  t0.alt AS alt_4,
  t0.caption AS caption_5,
  t0.position AS position_6,
  t0.active AS active_7,
  t0.hero AS hero_8,
  t0.presentation AS presentation_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.property_id AS property_id_12
FROM
  property_media t0
WHERE
  t0.property_id = ?
ORDER BY
  t0.position ASC,
  t0.created_at ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.alt AS alt_4, t0.caption AS caption_5, t0.position AS position_6, t0.active AS active_7, t0.hero AS hero_8, t0.presentation AS presentation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.property_id AS property_id_12 FROM property_media t0 WHERE t0.property_id = 1 ORDER BY t0.position ASC, t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.zip_code AS zip_code_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.capacity AS capacity_10,
  t0.bedrooms AS bedrooms_11,
  t0.bathrooms AS bathrooms_12,
  t0.surface AS surface_13,
  t0.nightly_rate AS nightly_rate_14,
  t0.included_guests AS included_guests_15,
  t0.extra_guest_fee AS extra_guest_fee_16,
  t0.cleaning_fee AS cleaning_fee_17,
  t0.nearby_place1 AS nearby_place1_18,
  t0.nearby_place1_time AS nearby_place1_time_19,
  t0.nearby_place2 AS nearby_place2_20,
  t0.nearby_place2_time AS nearby_place2_time_21,
  t0.nearby_place3 AS nearby_place3_22,
  t0.nearby_place3_time AS nearby_place3_time_23,
  t0.nearby_place4 AS nearby_place4_24,
  t0.nearby_place4_time AS nearby_place4_time_25,
  t0.arrival_time AS arrival_time_26,
  t0.departure_time AS departure_time_27,
  t0.minimum_nights AS minimum_nights_28,
  t0.maximum_nights AS maximum_nights_29,
  t0.minimum_booking_notice_days AS minimum_booking_notice_days_30,
  t0.maximum_booking_advance_days AS maximum_booking_advance_days_31,
  t0.cancellation_policy AS cancellation_policy_32,
  t0.custom_cancellation_policy AS custom_cancellation_policy_33,
  t0.ical_export_token AS ical_export_token_34,
  t0.ical_export_enabled AS ical_export_enabled_35,
  t0.active AS active_36,
  t0.created_at AS created_at_37,
  t0.updated_at AS updated_at_38,
  t0.owner_id AS owner_id_39,
  t40.id AS id_41,
  t40.site_name AS site_name_42,
  t40.slug AS slug_43,
  t40.hero_eyebrow AS hero_eyebrow_44,
  t40.headline AS headline_45,
  t40.property_eyebrow AS property_eyebrow_46,
  t40.property_title AS property_title_47,
  t40.property_introduction AS property_introduction_48,
  t40.description AS description_49,
  t40.gallery_eyebrow AS gallery_eyebrow_50,
  t40.gallery_title AS gallery_title_51,
  t40.gallery_introduction AS gallery_introduction_52,
  t40.location_eyebrow AS location_eyebrow_53,
  t40.location_title AS location_title_54,
  t40.location_description AS location_description_55,
  t40.contact_email AS contact_email_56,
  t40.contact_phone AS contact_phone_57,
  t40.contact_address AS contact_address_58,
  t40.primary_color AS primary_color_59,
  t40.secondary_color AS secondary_color_60,
  t40.seo_title AS seo_title_61,
  t40.seo_description AS seo_description_62,
  t40.direct_booking_enabled AS direct_booking_enabled_63,
  t40.published AS published_64,
  t40.published_at AS published_at_65,
  t40.preview_image AS preview_image_66,
  t40.created_at AS created_at_67,
  t40.updated_at AS updated_at_68,
  t40.property_id AS property_id_69,
  t40.theme_id AS theme_id_70
FROM
  property t0
  LEFT JOIN property_website t40 ON t40.property_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.zip_code AS zip_code_5, t0.city AS city_6, t0.country AS country_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.capacity AS capacity_10, t0.bedrooms AS bedrooms_11, t0.bathrooms AS bathrooms_12, t0.surface AS surface_13, t0.nightly_rate AS nightly_rate_14, t0.included_guests AS included_guests_15, t0.extra_guest_fee AS extra_guest_fee_16, t0.cleaning_fee AS cleaning_fee_17, t0.nearby_place1 AS nearby_place1_18, t0.nearby_place1_time AS nearby_place1_time_19, t0.nearby_place2 AS nearby_place2_20, t0.nearby_place2_time AS nearby_place2_time_21, t0.nearby_place3 AS nearby_place3_22, t0.nearby_place3_time AS nearby_place3_time_23, t0.nearby_place4 AS nearby_place4_24, t0.nearby_place4_time AS nearby_place4_time_25, t0.arrival_time AS arrival_time_26, t0.departure_time AS departure_time_27, t0.minimum_nights AS minimum_nights_28, t0.maximum_nights AS maximum_nights_29, t0.minimum_booking_notice_days AS minimum_booking_notice_days_30, t0.maximum_booking_advance_days AS maximum_booking_advance_days_31, t0.cancellation_policy AS cancellation_policy_32, t0.custom_cancellation_policy AS custom_cancellation_policy_33, t0.ical_export_token AS ical_export_token_34, t0.ical_export_enabled AS ical_export_enabled_35, t0.active AS active_36, t0.created_at AS created_at_37, t0.updated_at AS updated_at_38, t0.owner_id AS owner_id_39, t40.id AS id_41, t40.site_name AS site_name_42, t40.slug AS slug_43, t40.hero_eyebrow AS hero_eyebrow_44, t40.headline AS headline_45, t40.property_eyebrow AS property_eyebrow_46, t40.property_title AS property_title_47, t40.property_introduction AS property_introduction_48, t40.description AS description_49, t40.gallery_eyebrow AS gallery_eyebrow_50, t40.gallery_title AS gallery_title_51, t40.gallery_introduction AS gallery_introduction_52, t40.location_eyebrow AS location_eyebrow_53, t40.location_title AS location_title_54, t40.location_description AS location_description_55, t40.contact_email AS contact_email_56, t40.contact_phone AS contact_phone_57, t40.contact_address AS contact_address_58, t40.primary_color AS primary_color_59, t40.secondary_color AS secondary_color_60, t40.seo_title AS seo_title_61, t40.seo_description AS seo_description_62, t40.direct_booking_enabled AS direct_booking_enabled_63, t40.published AS published_64, t40.published_at AS published_at_65, t40.preview_image AS preview_image_66, t40.created_at AS created_at_67, t40.updated_at AS updated_at_68, t40.property_id AS property_id_69, t40.theme_id AS theme_id_70 FROM property t0 LEFT JOIN property_website t40 ON t40.property_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.slug AS slug_3,
  t0.hero_eyebrow AS hero_eyebrow_4,
  t0.headline AS headline_5,
  t0.property_eyebrow AS property_eyebrow_6,
  t0.property_title AS property_title_7,
  t0.property_introduction AS property_introduction_8,
  t0.description AS description_9,
  t0.gallery_eyebrow AS gallery_eyebrow_10,
  t0.gallery_title AS gallery_title_11,
  t0.gallery_introduction AS gallery_introduction_12,
  t0.location_eyebrow AS location_eyebrow_13,
  t0.location_title AS location_title_14,
  t0.location_description AS location_description_15,
  t0.contact_email AS contact_email_16,
  t0.contact_phone AS contact_phone_17,
  t0.contact_address AS contact_address_18,
  t0.primary_color AS primary_color_19,
  t0.secondary_color AS secondary_color_20,
  t0.seo_title AS seo_title_21,
  t0.seo_description AS seo_description_22,
  t0.direct_booking_enabled AS direct_booking_enabled_23,
  t0.published AS published_24,
  t0.published_at AS published_at_25,
  t0.preview_image AS preview_image_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.property_id AS property_id_29,
  t0.theme_id AS theme_id_30,
  t31.id AS id_32,
  t31.domain_name AS domain_name_33,
  t31.mode AS mode_34,
  t31.registrar AS registrar_35,
  t31.status AS status_36,
  t31.registrar_domain_id AS registrar_domain_id_37,
  t31.dns_configured AS dns_configured_38,
  t31.ssl_enabled AS ssl_enabled_39,
  t31.auto_renew AS auto_renew_40,
  t31.transfer_auth_code AS transfer_auth_code_41,
  t31.last_error AS last_error_42,
  t31.registered_at AS registered_at_43,
  t31.expires_at AS expires_at_44,
  t31.activated_at AS activated_at_45,
  t31.created_at AS created_at_46,
  t31.updated_at AS updated_at_47,
  t31.website_id AS website_id_48
FROM
  property_website t0
  LEFT JOIN domain t31 ON t31.website_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.slug AS slug_3, t0.hero_eyebrow AS hero_eyebrow_4, t0.headline AS headline_5, t0.property_eyebrow AS property_eyebrow_6, t0.property_title AS property_title_7, t0.property_introduction AS property_introduction_8, t0.description AS description_9, t0.gallery_eyebrow AS gallery_eyebrow_10, t0.gallery_title AS gallery_title_11, t0.gallery_introduction AS gallery_introduction_12, t0.location_eyebrow AS location_eyebrow_13, t0.location_title AS location_title_14, t0.location_description AS location_description_15, t0.contact_email AS contact_email_16, t0.contact_phone AS contact_phone_17, t0.contact_address AS contact_address_18, t0.primary_color AS primary_color_19, t0.secondary_color AS secondary_color_20, t0.seo_title AS seo_title_21, t0.seo_description AS seo_description_22, t0.direct_booking_enabled AS direct_booking_enabled_23, t0.published AS published_24, t0.published_at AS published_at_25, t0.preview_image AS preview_image_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.property_id AS property_id_29, t0.theme_id AS theme_id_30, t31.id AS id_32, t31.domain_name AS domain_name_33, t31.mode AS mode_34, t31.registrar AS registrar_35, t31.status AS status_36, t31.registrar_domain_id AS registrar_domain_id_37, t31.dns_configured AS dns_configured_38, t31.ssl_enabled AS ssl_enabled_39, t31.auto_renew AS auto_renew_40, t31.transfer_auth_code AS transfer_auth_code_41, t31.last_error AS last_error_42, t31.registered_at AS registered_at_43, t31.expires_at AS expires_at_44, t31.activated_at AS activated_at_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.website_id AS website_id_48 FROM property_website t0 LEFT JOIN domain t31 ON t31.website_id = t0.id WHERE t0.id = '1';

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.icon AS icon_2,
  a0_.description AS description_3,
  a0_.active AS active_4
FROM
  amenity a0_
WHERE
  a0_.active = ?
ORDER BY
  a0_.title ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.icon AS icon_2, a0_.description AS description_3, a0_.active AS active_4 FROM amenity a0_ WHERE a0_.active = 1 ORDER BY a0_.title ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.last_login_at AS last_login_at_8,
  t0.google_id AS google_id_9,
  t0.facebook_id AS facebook_id_10,
  t0.avatar AS avatar_11,
  t0.avatar_source AS avatar_source_12,
  t13.id AS id_14,
  t13.first_name AS first_name_15,
  t13.last_name AS last_name_16,
  t13.phone AS phone_17,
  t13.email AS email_18,
  t13.access_token AS access_token_19,
  t13.created_at AS created_at_20,
  t13.user_id AS user_id_21,
  t22.id AS id_23,
  t22.first_name AS first_name_24,
  t22.last_name AS last_name_25,
  t22.phone AS phone_26,
  t22.trade_name AS trade_name_27,
  t22.legal_name AS legal_name_28,
  t22.siret AS siret_29,
  t22.vat_number AS vat_number_30,
  t22.address AS address_31,
  t22.zip_code AS zip_code_32,
  t22.city AS city_33,
  t22.country AS country_34,
  t22.lws_contact_id AS lws_contact_id_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.user_id AS user_id_38,
  t39.id AS id_40,
  t39.notify_reservations AS notify_reservations_41,
  t39.notify_interventions AS notify_interventions_42,
  t39.notify_checkins AS notify_checkins_43,
  t39.notify_ical_errors AS notify_ical_errors_44,
  t39.ical_sync_interval AS ical_sync_interval_45,
  t39.language AS language_46,
  t39.timezone AS timezone_47,
  t39.date_format AS date_format_48,
  t39.time_format AS time_format_49,
  t39.stripe_enabled AS stripe_enabled_50,
  t39.paypal_enabled AS paypal_enabled_51,
  t39.account_enabled AS account_enabled_52,
  t39.created_at AS created_at_53,
  t39.updated_at AS updated_at_54,
  t39.user_id AS user_id_55
FROM
  user t0
  LEFT JOIN worker t13 ON t13.user_id = t0.id
  LEFT JOIN owner_profile t22 ON t22.user_id = t0.id
  LEFT JOIN owner_settings t39 ON t39.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.last_login_at AS last_login_at_8, t0.google_id AS google_id_9, t0.facebook_id AS facebook_id_10, t0.avatar AS avatar_11, t0.avatar_source AS avatar_source_12, t13.id AS id_14, t13.first_name AS first_name_15, t13.last_name AS last_name_16, t13.phone AS phone_17, t13.email AS email_18, t13.access_token AS access_token_19, t13.created_at AS created_at_20, t13.user_id AS user_id_21, t22.id AS id_23, t22.first_name AS first_name_24, t22.last_name AS last_name_25, t22.phone AS phone_26, t22.trade_name AS trade_name_27, t22.legal_name AS legal_name_28, t22.siret AS siret_29, t22.vat_number AS vat_number_30, t22.address AS address_31, t22.zip_code AS zip_code_32, t22.city AS city_33, t22.country AS country_34, t22.lws_contact_id AS lws_contact_id_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.user_id AS user_id_38, t39.id AS id_40, t39.notify_reservations AS notify_reservations_41, t39.notify_interventions AS notify_interventions_42, t39.notify_checkins AS notify_checkins_43, t39.notify_ical_errors AS notify_ical_errors_44, t39.ical_sync_interval AS ical_sync_interval_45, t39.language AS language_46, t39.timezone AS timezone_47, t39.date_format AS date_format_48, t39.time_format AS time_format_49, t39.stripe_enabled AS stripe_enabled_50, t39.paypal_enabled AS paypal_enabled_51, t39.account_enabled AS account_enabled_52, t39.created_at AS created_at_53, t39.updated_at AS updated_at_54, t39.user_id AS user_id_55 FROM user t0 LEFT JOIN worker t13 ON t13.user_id = t0.id LEFT JOIN owner_profile t22 ON t22.user_id = t0.id LEFT JOIN owner_settings t39 ON t39.user_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.icon AS icon_3,
  t0.description AS description_4,
  t0.active AS active_5
FROM
  amenity t0
  INNER JOIN property_amenity ON t0.id = property_amenity.amenity_id
WHERE
  property_amenity.property_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.description AS description_4, t0.active AS active_5 FROM amenity t0 INNER JOIN property_amenity ON t0.id = property_amenity.amenity_id WHERE property_amenity.property_id = 1;