Symfony Profiler

Query Metrics

397 Database Queries
42 Different statements
295.69 ms Query time
0 Invalid entities
172 Managed entities
Queries


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.name AS name_6, t0.locale AS locale_7, t0.picture AS picture_8 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.revision AS revision_2, t0.public_id AS public_id_3, t0.offer_type AS offer_type_4, t0.sell_price AS sell_price_5, t0.rent_price AS rent_price_6, t0.publishing_status AS publishing_status_7, t0.apartments_count AS apartments_count_8, t0.rooms_count AS rooms_count_9, t0.bathrooms_count AS bathrooms_count_10, t0.floor AS floor_11, t0.floors_count AS floors_count_12, t0.living_area AS living_area_13, t0.land_area AS land_area_14, t0.usable_area AS usable_area_15, t0.ceiling_height AS ceiling_height_16, t0.year_built AS year_built_17, t0.last_renovation AS last_renovation_18, t0.calendly_url AS calendly_url_19, t0.tour_first_date_delay AS tour_first_date_delay_20, t0.tour_week_days AS tour_week_days_21, t0.waiting_list_active AS waiting_list_active_22, t0.favourite_richard AS favourite_richard_23, t0.location_optimiser_active AS location_optimiser_active_24, t0.video AS video_25, t0.video2 AS video2_26, t0.virtual_tour AS virtual_tour_27, t0.title AS title_28, t0.description_results AS description_results_29, t0.description_detail_view AS description_detail_view_30, t0.benefits AS benefits_31, t0.description_external_portals AS description_external_portals_32, t0.property_id AS property_id_33, t0.wordpress_export_active AS wordpress_export_active_34, t0.wordpress_exported_revision AS wordpress_exported_revision_35, t0.wordpress_page_url AS wordpress_page_url_36, t0.wordpress_post_id AS wordpress_post_id_37, t0.main_language AS main_language_38, t0.draft_at AS draft_at_39, t0.paused_at AS paused_at_40, t0.archived_at AS archived_at_41, t0.on_air_at AS on_air_at_42, t0.reserved_at AS reserved_at_43, t0.sold_or_rented_at AS sold_or_rented_at_44, t0.automatic_translation_disabled AS automatic_translation_disabled_45, t0.automatic_translated AS automatic_translated_46, t0.publish_full_address AS publish_full_address_47, t0.first_published_at AS first_published_at_48, t0.edit_lock_until AS edit_lock_until_49, t0.forced_publishing_phases AS forced_publishing_phases_50, t0.disallowed_publishing_phases AS disallowed_publishing_phases_51, t0.media_url_original_images AS media_url_original_images_52, t0.media_url_web_images AS media_url_web_images_53, t0.media_url_floor_plans AS media_url_floor_plans_54, t0.media_upload_status AS media_upload_status_55, t0.additional_publishing_delays AS additional_publishing_delays_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.category_id AS category_id_59, t0.object_type_id AS object_type_id_60, t0.agent_id AS agent_id_61, t0.address_id AS address_id_62, t0.cloned_from_id AS cloned_from_id_63, t0.edit_lock_by_user_id AS edit_lock_by_user_id_64, t0.mandate_id AS mandate_id_65 FROM property t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.street AS street_2, t0.street_door AS street_door_3, t0.zip_code_id AS zip_code_id_4, t0.city_id AS city_id_5, t0.zip_code_city_id AS zip_code_city_id_6, t7.id AS id_8, t7.revision AS revision_9, t7.public_id AS public_id_10, t7.offer_type AS offer_type_11, t7.sell_price AS sell_price_12, t7.rent_price AS rent_price_13, t7.publishing_status AS publishing_status_14, t7.apartments_count AS apartments_count_15, t7.rooms_count AS rooms_count_16, t7.bathrooms_count AS bathrooms_count_17, t7.floor AS floor_18, t7.floors_count AS floors_count_19, t7.living_area AS living_area_20, t7.land_area AS land_area_21, t7.usable_area AS usable_area_22, t7.ceiling_height AS ceiling_height_23, t7.year_built AS year_built_24, t7.last_renovation AS last_renovation_25, t7.calendly_url AS calendly_url_26, t7.tour_first_date_delay AS tour_first_date_delay_27, t7.tour_week_days AS tour_week_days_28, t7.waiting_list_active AS waiting_list_active_29, t7.favourite_richard AS favourite_richard_30, t7.location_optimiser_active AS location_optimiser_active_31, t7.video AS video_32, t7.video2 AS video2_33, t7.virtual_tour AS virtual_tour_34, t7.title AS title_35, t7.description_results AS description_results_36, t7.description_detail_view AS description_detail_view_37, t7.benefits AS benefits_38, t7.description_external_portals AS description_external_portals_39, t7.property_id AS property_id_40, t7.wordpress_export_active AS wordpress_export_active_41, t7.wordpress_exported_revision AS wordpress_exported_revision_42, t7.wordpress_page_url AS wordpress_page_url_43, t7.wordpress_post_id AS wordpress_post_id_44, t7.main_language AS main_language_45, t7.draft_at AS draft_at_46, t7.paused_at AS paused_at_47, t7.archived_at AS archived_at_48, t7.on_air_at AS on_air_at_49, t7.reserved_at AS reserved_at_50, t7.sold_or_rented_at AS sold_or_rented_at_51, t7.automatic_translation_disabled AS automatic_translation_disabled_52, t7.automatic_translated AS automatic_translated_53, t7.publish_full_address AS publish_full_address_54, t7.first_published_at AS first_published_at_55, t7.edit_lock_until AS edit_lock_until_56, t7.forced_publishing_phases AS forced_publishing_phases_57, t7.disallowed_publishing_phases AS disallowed_publishing_phases_58, t7.media_url_original_images AS media_url_original_images_59, t7.media_url_web_images AS media_url_web_images_60, t7.media_url_floor_plans AS media_url_floor_plans_61, t7.media_upload_status AS media_upload_status_62, t7.additional_publishing_delays AS additional_publishing_delays_63, t7.created_at AS created_at_64, t7.updated_at AS updated_at_65, t7.category_id AS category_id_66, t7.object_type_id AS object_type_id_67, t7.agent_id AS agent_id_68, t7.address_id AS address_id_69, t7.cloned_from_id AS cloned_from_id_70, t7.edit_lock_by_user_id AS edit_lock_by_user_id_71, t7.mandate_id AS mandate_id_72, t73.id AS id_74, t73.sent_at AS sent_at_75, t73.offer_type AS offer_type_76, t73.price AS price_77, t73.public_id AS public_id_78, t73.rooms_count AS rooms_count_79, t73.living_area AS living_area_80, t73.land_area AS land_area_81, t73.usable_area AS usable_area_82, t73.commercial_area AS commercial_area_83, t73.commercial_usable_area AS commercial_usable_area_84, t73.gross_area AS gross_area_85, t73.floor AS floor_86, t73.floors_count AS floors_count_87, t73.ceiling_height AS ceiling_height_88, t73.year_built AS year_built_89, t73.property_number_whole_house AS property_number_whole_house_90, t73.property_number_apartment AS property_number_apartment_91, t73.value_ratio AS value_ratio_92, t73.building_zone AS building_zone_93, t73.property_number_land AS property_number_land_94, t73.total_land_area AS total_land_area_95, t73.individual_land_areas AS individual_land_areas_96, t73.deposit AS deposit_97, t73.status_fund AS status_fund_98, t73.share AS share_99, t73.renovation_information_as_of_date AS renovation_information_as_of_date_100, t73.operating_expenses AS operating_expenses_101, t73.operating_expenses_information_as_of_date AS operating_expenses_information_as_of_date_102, t73.debt_certificates AS debt_certificates_103, t73.tax_value AS tax_value_104, t73.imputed_rental_value AS imputed_rental_value_105, t73.transfer_tax_first_level AS transfer_tax_first_level_106, t73.has_transfer_tax_second_level AS has_transfer_tax_second_level_107, t73.transfer_tax_second_level AS transfer_tax_second_level_108, t73.notary_and_registry AS notary_and_registry_109, t73.commission_purchase_price AS commission_purchase_price_110, t73.commission_purchase_price_responsibility AS commission_purchase_price_responsibility_111, t73.transaction_price_minimum AS transaction_price_minimum_112, t73.transaction_price_minimum_responsibility AS transaction_price_minimum_responsibility_113, t73.no_parking_available AS no_parking_available_114, t73.parking_facilities AS parking_facilities_115, t73.parking_facilities_counts AS parking_facilities_counts_116, t73.parking_included_in_price AS parking_included_in_price_117, t73.parking_price AS parking_price_118, t73.no_wet_rooms AS no_wet_rooms_119, t73.wet_rooms AS wet_rooms_120, t73.wet_rooms_counts AS wet_rooms_counts_121, t73.no_heating_system AS no_heating_system_122, t73.heating_systems AS heating_systems_123, t73.heating_systems_wood AS heating_systems_wood_124, t73.heating_systems_heat_pump AS heating_systems_heat_pump_125, t73.heating_systems_solar AS heating_systems_solar_126, t73.heating_systems_electric AS heating_systems_electric_127, t73.unknown_heat_distribution_system AS unknown_heat_distribution_system_128, t73.heat_distribution_systems AS heat_distribution_systems_129, t73.unknown_floor_coverings AS unknown_floor_coverings_130, t73.floor_coverings AS floor_coverings_131, t73.floor_coverings_parquet AS floor_coverings_parquet_132, t73.floor_coverings_stone AS floor_coverings_stone_133, t73.no_adjacent_rooms AS no_adjacent_rooms_134, t73.adjacent_rooms AS adjacent_rooms_135, t73.craft_room_heating AS craft_room_heating_136, t73.craft_room_ownership AS craft_room_ownership_137, t73.workshop_heating AS workshop_heating_138, t73.workshop_ownership AS workshop_ownership_139, t73.party_room_heating AS party_room_heating_140, t73.party_room_ownership AS party_room_ownership_141, t73.cellar_heating AS cellar_heating_142, t73.cellar_ownership AS cellar_ownership_143, t73.winter_garden_heating AS winter_garden_heating_144, t73.special_features AS special_features_145, t73.special_features_areas AS special_features_areas_146, t73.recordings_needed AS recordings_needed_147, t73.target_demographics AS target_demographics_148, t73.residence AS residence_149, t73.protected_site AS protected_site_150, t73.subject_to_building_regulations AS subject_to_building_regulations_151, t73.building_rights_holder AS building_rights_holder_152, t73.building_rights_end_main_building_only AS building_rights_end_main_building_only_153, t73.building_rights_end AS building_rights_end_154, t73.building_rights_interest AS building_rights_interest_155, t73.recordings_special_instructions AS recordings_special_instructions_156, t73.notes_for_contacts AS notes_for_contacts_157, t73.status AS status_158, t73.kick_off_meeting_necessary AS kick_off_meeting_necessary_159, t73.power_of_attorney_and_brokerage_filled AS power_of_attorney_and_brokerage_filled_160, t73.photo_assignment_email_sent AS photo_assignment_email_sent_161, t73.kickoff_meeting_email_sent AS kickoff_meeting_email_sent_162, t73.agent_recommendation_result AS agent_recommendation_result_163, t73.layout AS layout_164, t73.created_at AS created_at_165, t73.updated_at AS updated_at_166, t73.evaluator_id AS evaluator_id_167, t73.creator_id AS creator_id_168, t73.category_id AS category_id_169, t73.object_type_id AS object_type_id_170, t73.address_id AS address_id_171, t73.agent_recommended_id AS agent_recommended_id_172 FROM address t0 LEFT JOIN property t7 ON t7.address_id = t0.id LEFT JOIN mandate t73 ON t73.address_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.checked AS checked_2, t0.data AS data_3, t0.property_id AS property_id_4, t0.feature_id AS feature_id_5 FROM property_feature t0 WHERE t0.property_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.active AS active_2, t0.can_become_active AS can_become_active_3, t0.forced_not_active AS forced_not_active_4, t0.revision AS revision_5, t0.forced_active AS forced_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.configuration_id AS configuration_id_9, t0.property_id AS property_id_10 FROM property_idx t0 WHERE t0.property_id = ?
SELECT t0.id AS id_1, t0.revision AS revision_2, t0.active AS active_3, t0.can_become_active AS can_become_active_4, t0.forced_active AS forced_active_5, t0.forced_not_active AS forced_not_active_6, t0.configuration_id AS configuration_id_7, t0.property_id AS property_id_8 FROM property_swiss_rets t0 WHERE t0.property_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ftp_server_host AS ftp_server_host_3, t0.ftp_password AS ftp_password_4, t0.ftp_data_folder AS ftp_data_folder_5, t0.ftp_images_folder AS ftp_images_folder_6, t0.ftp_username AS ftp_username_7, t0.language_forced AS language_forced_8, t0.publishing_phase AS publishing_phase_9, t0.last_updated_at AS last_updated_at_10, t0.sftp AS sftp_11, t0.max_number_of_images AS max_number_of_images_12, t0.active AS active_13, t0.sender_id AS sender_id_14, t0.agency_id AS agency_id_15, t0.test AS test_16 FROM idx_configuration t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.language_forced AS language_forced_5, t0.publishing_phase AS publishing_phase_6, t0.last_updated_at AS last_updated_at_7, t0.max_number_of_images AS max_number_of_images_8, t0.active AS active_9, t0.last_upload_response AS last_upload_response_10, t0.last_upload_status_code AS last_upload_status_code_11, t0.last_upload_request AS last_upload_request_12, t0.agency_id AS agency_id_13, t0.category_required AS category_required_14, t0.test AS test_15 FROM swiss_rets_configuration t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.idx_object_category AS idx_object_category_4, t0.detail_fields AS detail_fields_5, t0.swiss_rets_object_category AS swiss_rets_object_category_6, t0.ai_prompt AS ai_prompt_7 FROM property_category t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.idx_field AS idx_field_4, t0.translatable AS translatable_5, t0.icon AS icon_6, t0.feature_order AS feature_order_7, t0.swiss_rets_field AS swiss_rets_field_8, t0.enum_mapping AS enum_mapping_9, t0.category_id AS category_id_10 FROM feature t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.original_filename AS original_filename_2, t0.ulid AS ulid_3, t0.size_minimum AS size_minimum_4, t0.size_maximum AS size_maximum_5, t0.extension AS extension_6, t0.original_width AS original_width_7, t0.original_height AS original_height_8, t0.transparency AS transparency_9, t0.processed AS processed_10, t0.orientation AS orientation_11, t0.position AS position_12, t0.wordpress_uploaded AS wordpress_uploaded_13, t0.for_idx AS for_idx_14, t0.position_secondary AS position_secondary_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.property_id AS property_id_18, t19.id AS id_20, t19.property_id AS property_id_21, t19.url AS url_22, t19.file_retrieval_failed AS file_retrieval_failed_23, t19.image_id AS image_id_24 FROM image t0 LEFT JOIN media t19 ON t19.image_id = t0.id WHERE t0.property_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.type AS type_4, t0.size AS size_5, t0.locales AS locales_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.property_id AS property_id_9, t0.mandate_with_power_of_attorney_id AS mandate_with_power_of_attorney_id_10, t0.mandate_with_brokerage_agreement_id AS mandate_with_brokerage_agreement_id_11 FROM upload t0 WHERE t0.property_id = ?
SELECT t0.id AS id_1, t0.zip_code_id AS zip_code_id_2, t0.city_id AS city_id_3, t0.district_id AS district_id_4 FROM zip_code_city t0 INNER JOIN property_zip_code_city ON t0.id = property_zip_code_city.zip_code_city_id WHERE property_zip_code_city.property_id = ?
SELECT t0.id AS id_1, t0.zip_code_id AS zip_code_id_2, t0.city_id AS city_id_3, t0.district_id AS district_id_4 FROM zip_code_city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.canton_id AS canton_id_4 FROM district t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.languages AS languages_3, t0.canton_id AS canton_id_4 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.shortcode AS shortcode_4, t0.flag AS flag_5 FROM canton t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.idx_object_type AS idx_object_type_4, t0.swiss_rets_object_category AS swiss_rets_object_category_5, t0.category_id AS category_id_6 FROM property_object t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.zip_code AS zip_code_2 FROM zip_code t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.picture AS picture_4, t0.description AS description_5, t0.phone AS phone_6 FROM agent t0 WHERE t0.id = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.idx_object_category AS idx_object_category_3, p0_.detail_fields AS detail_fields_4, p0_.swiss_rets_object_category AS swiss_rets_object_category_5, p0_.ai_prompt AS ai_prompt_6 FROM property_category p0_ WHERE p0_.id IN (?)
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.idx_object_type AS idx_object_type_3, p0_.swiss_rets_object_category AS swiss_rets_object_category_4, p0_.category_id AS category_id_5 FROM property_object p0_ WHERE p0_.id IN (?)
SELECT z0_.id AS id_0, z0_.zip_code AS zip_code_1 FROM zip_code z0_ WHERE z0_.id IN (?)
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.languages AS languages_2, c0_.canton_id AS canton_id_3 FROM city c0_ WHERE c0_.id IN (?)
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.email AS email_2, a0_.picture AS picture_3, a0_.description AS description_4, a0_.phone AS phone_5 FROM agent a0_ WHERE a0_.id IN (?)
SELECT t0.id AS id_1, t0.old_status AS old_status_2, t0.new_status AS new_status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.property_id AS property_id_6, t0.user_id AS user_id_7 FROM publishing_status_change t0 WHERE t0.property_id = ?
"START TRANSACTION"
SELECT t0.id AS id_1, t0.revision AS revision_2, t0.request AS request_3, t0.route AS route_4, t0.parameters AS parameters_5, t0.user_id AS user_id_6 FROM draft t0 WHERE t0.revision = ? AND t0.route = ?
SELECT t0.id AS id_1, t0.zip_code_id AS zip_code_id_2, t0.city_id AS city_id_3, t0.district_id AS district_id_4 FROM zip_code_city t0 WHERE t0.city_id = ?
SAVEPOINT DOCTRINE_2
DELETE FROM property_zip_code_city WHERE property_id = ?
INSERT INTO publishing_status_change (old_status, new_status, created_at, updated_at, property_id, user_id) VALUES (?, ?, ?, ?, ?, ?)
UPDATE property SET revision = ?, tour_week_days = ?, on_air_at = ?, edit_lock_until = ?, edit_lock_by_user_id = ?, updated_at = ? WHERE id = ?
UPDATE property_idx SET active = ?, updated_at = ? WHERE id = ?
UPDATE property_idx SET active = ?, forced_not_active = ?, updated_at = ? WHERE id = ?
UPDATE property_idx SET active = ?, updated_at = ? WHERE id = ?
UPDATE property_idx SET active = ?, updated_at = ? WHERE id = ?
DELETE FROM draft WHERE id = ?
RELEASE SAVEPOINT DOCTRINE_2
"COMMIT"
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
INSERT INTO `ext_translations`(`locale`, `object_class`, `field`, `foreign_key`, `content`) 
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE content = ?
UPDATE property_feature
SET data = ?
WHERE id = ?
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\Property\PropertyFeature	44
App\Entity\Property\Feature	44
App\Entity\Image	30
App\Entity\Property\FeatureCategory	10
App\Entity\Property\PublishingStatusChange	9
App\Entity\Property\PropertyIdx	8
App\Entity\IdxConfiguration	8
App\Entity\User	4
App\Entity\Property\PropertySwissRets	2
App\Entity\SwissRetsConfiguration	2
App\Entity\Property	1
App\Entity\Property\PropertyCategory	1
App\Entity\Property\PropertyObject	1
App\Entity\Agent	1
App\Entity\Location\Address	1
App\Entity\Location\ZipCode	1
App\Entity\Location\City	1
App\Entity\Location\ZipCodeCity	1
App\Entity\Upload	1
App\Entity\Location\District	1
App\Entity\Location\Canton	1
App\Entity\Draft	0
Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Draft	No errors.
App\Entity\Mandate	No errors.
App\Entity\Property	No errors.
App\Entity\Property\PropertyCategory	No errors.
App\Entity\Property\PropertyObject	No errors.
App\Entity\Agent	No errors.
App\Entity\Location\Address	No errors.
App\Entity\Location\ZipCodeCity	No errors.
App\Entity\Image	No errors.
App\Entity\Upload	No errors.
App\Entity\Property\PropertyFeature	No errors.
App\Entity\Property\PropertyIdx	No errors.
App\Entity\Contact	No errors.
App\Entity\Property\PublishingStatusChange	No errors.
App\Entity\Property\PropertySwissRets	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\Location\ZipCode	No errors.
App\Entity\Location\City	No errors.
App\Entity\Property\Feature	No errors.
App\Entity\Property\FeatureChoice	No errors.
App\Entity\IdxConfiguration	No errors.
App\Entity\SwissRetsConfiguration	No errors.
App\Entity\Property\FeatureCategory	No errors.
App\Entity\Location\Canton	No errors.
App\Entity\Property\Media	No errors.
App\Entity\Location\District	No errors.
Symfony Profiler

POST https://liberate-gvs.ch/eigenschaften/627/edieren/de

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
