Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.domaine AS domaine_1,
  a0_.actif AS actif_2,
  a0_.template AS template_3,
  a0_.config AS config_4,
  a0_.infos AS infos_5,
  a0_.menu AS menu_6,
  a0_.seo AS seo_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.footer AS footer_10,
  a1_.id AS id_11,
  a1_.nom AS nom_12,
  a1_.ville AS ville_13,
  a1_.telephone AS telephone_14,
  a1_.email AS email_15,
  a1_.adresse AS adresse_16,
  a1_.npa AS npa_17,
  a1_.actif AS actif_18,
  a1_.afficher_listing AS afficher_listing_19,
  a1_.created_at AS created_at_20,
  a1_.updated_at AS updated_at_21,
  a1_.addresses AS addresses_22,
  a1_.website AS website_23,
  a0_.agence_id AS agence_id_24,
  a1_.subscription_plan_id AS subscription_plan_id_25
FROM
  agence_site a0_
  LEFT JOIN agence a1_ ON a0_.agence_id = a1_.id
WHERE
  LOWER(a0_.domaine) = LOWER(?)
  AND a0_.actif = 1

SELECT a0_.id AS id_0, a0_.domaine AS domaine_1, a0_.actif AS actif_2, a0_.template AS template_3, a0_.config AS config_4, a0_.infos AS infos_5, a0_.menu AS menu_6, a0_.seo AS seo_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.footer AS footer_10, a1_.id AS id_11, a1_.nom AS nom_12, a1_.ville AS ville_13, a1_.telephone AS telephone_14, a1_.email AS email_15, a1_.adresse AS adresse_16, a1_.npa AS npa_17, a1_.actif AS actif_18, a1_.afficher_listing AS afficher_listing_19, a1_.created_at AS created_at_20, a1_.updated_at AS updated_at_21, a1_.addresses AS addresses_22, a1_.website AS website_23, a0_.agence_id AS agence_id_24, a1_.subscription_plan_id AS subscription_plan_id_25 FROM agence_site a0_ LEFT JOIN agence a1_ ON a0_.agence_id = a1_.id WHERE LOWER(a0_.domaine) = LOWER('novimmob.pix-preview.ch') AND a0_.actif = 1;

SELECT
  t0.id AS id_1,
  t0.theme AS theme_2,
  t0.logo_path AS logo_path_3,
  t0.primary_color AS primary_color_4,
  t0.secondary_color AS secondary_color_5,
  t0.default_resolution AS default_resolution_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.agence_id AS agence_id_9
FROM
  agence_pdf_settings t0
WHERE
  t0.agence_id = ?

SELECT t0.id AS id_1, t0.theme AS theme_2, t0.logo_path AS logo_path_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.default_resolution AS default_resolution_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agence_id AS agence_id_9 FROM agence_pdf_settings t0 WHERE t0.agence_id = 5;

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1,
  a0_.api_key AS api_key_2,
  a0_.active AS active_3,
  a0_.last_used_at AS last_used_at_4,
  a0_.hits_total AS hits_total_5,
  a0_.created_at AS created_at_6,
  a1_.id AS id_7,
  a1_.nom AS nom_8,
  a1_.ville AS ville_9,
  a1_.telephone AS telephone_10,
  a1_.email AS email_11,
  a1_.adresse AS adresse_12,
  a1_.npa AS npa_13,
  a1_.actif AS actif_14,
  a1_.afficher_listing AS afficher_listing_15,
  a1_.created_at AS created_at_16,
  a1_.updated_at AS updated_at_17,
  a1_.addresses AS addresses_18,
  a1_.website AS website_19,
  a0_.agence_id AS agence_id_20,
  a0_.created_by_id AS created_by_id_21,
  a1_.subscription_plan_id AS subscription_plan_id_22
FROM
  agence_api_key a0_
  LEFT JOIN agence a1_ ON a0_.agence_id = a1_.id
WHERE
  a0_.api_key = ?
  AND a0_.active = 1

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.api_key AS api_key_2, a0_.active AS active_3, a0_.last_used_at AS last_used_at_4, a0_.hits_total AS hits_total_5, a0_.created_at AS created_at_6, a1_.id AS id_7, a1_.nom AS nom_8, a1_.ville AS ville_9, a1_.telephone AS telephone_10, a1_.email AS email_11, a1_.adresse AS adresse_12, a1_.npa AS npa_13, a1_.actif AS actif_14, a1_.afficher_listing AS afficher_listing_15, a1_.created_at AS created_at_16, a1_.updated_at AS updated_at_17, a1_.addresses AS addresses_18, a1_.website AS website_19, a0_.agence_id AS agence_id_20, a0_.created_by_id AS created_by_id_21, a1_.subscription_plan_id AS subscription_plan_id_22 FROM agence_api_key a0_ LEFT JOIN agence a1_ ON a0_.agence_id = a1_.id WHERE a0_.api_key = 'casaq_live_46ded05138f672eacecde6fcdd5948533d7ecaaf' AND a0_.active = 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  agence_api_key
SET
  last_used_at = ?,
  hits_total = ?
WHERE
  id = ?

UPDATE agence_api_key SET last_used_at = '2026-07-02 11:15:23', hits_total = 4908 WHERE id = 4;

"COMMIT"

"COMMIT";

SELECT
  COUNT(DISTINCT b0_.id) AS sclr_0
FROM
  bien b0_
  LEFT JOIN bien_cadastral b1_ ON b0_.id = b1_.bien_id
  LEFT JOIN bien_details b2_ ON b0_.id = b2_.bien_id
  LEFT JOIN bien_finance b3_ ON b0_.id = b3_.bien_id
  LEFT JOIN bien_descriptif b4_ ON b0_.id = b4_.bien_id
  LEFT JOIN category c5_ ON b0_.category_id = c5_.id
  LEFT JOIN user u6_ ON b0_.courtier_id = u6_.id
  LEFT JOIN bien_image b7_ ON b0_.cover_image_id = b7_.id
  LEFT JOIN bien_image b8_ ON b0_.id = b8_.bien_id
WHERE
  b0_.agence_id = ?
  AND b0_.deleted = 0
  AND b0_.statut = ?

SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM bien b0_ LEFT JOIN bien_cadastral b1_ ON b0_.id = b1_.bien_id LEFT JOIN bien_details b2_ ON b0_.id = b2_.bien_id LEFT JOIN bien_finance b3_ ON b0_.id = b3_.bien_id LEFT JOIN bien_descriptif b4_ ON b0_.id = b4_.bien_id LEFT JOIN category c5_ ON b0_.category_id = c5_.id LEFT JOIN user u6_ ON b0_.courtier_id = u6_.id LEFT JOIN bien_image b7_ ON b0_.cover_image_id = b7_.id LEFT JOIN bien_image b8_ ON b0_.id = b8_.bien_id WHERE b0_.agence_id = 5 AND b0_.deleted = 0 AND b0_.statut = 'ACTIVE';

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      position_65,
      id_61
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.reference AS reference_1,
          b0_.statut AS statut_2,
          b0_.deal AS deal_3,
          b0_.deleted AS deleted_4,
          b0_.prestige AS prestige_5,
          b0_.foreigner_sale AS foreigner_sale_6,
          b0_.secondary_residence AS secondary_residence_7,
          b0_.comment AS comment_8,
          b0_.tags AS tags_9,
          b0_.created_at AS created_at_10,
          b0_.updated_at AS updated_at_11,
          b1_.id AS id_12,
          b1_.country AS country_13,
          b1_.npa AS npa_14,
          b1_.city AS city_15,
          b1_.address AS address_16,
          b1_.substitution_address AS substitution_address_17,
          b1_.lat AS lat_18,
          b1_.lng AS lng_19,
          b1_.public_mode AS public_mode_20,
          b1_.pub_radius AS pub_radius_21,
          b1_.rf_number AS rf_number_22,
          b1_.egid AS egid_23,
          b1_.ewid AS ewid_24,
          b1_.construct_zone AS construct_zone_25,
          b2_.id AS id_26,
          b2_.data AS data_27,
          b3_.id AS id_28,
          b3_.data AS data_29,
          b4_.id AS id_30,
          b4_.data AS data_31,
          c5_.id AS id_32,
          c5_.name AS name_33,
          c5_.slug AS slug_34,
          c5_.active AS active_35,
          c5_.sort_order AS sort_order_36,
          c5_.depth AS depth_37,
          u6_.id AS id_38,
          u6_.email AS email_39,
          u6_.prenom AS prenom_40,
          u6_.nom AS nom_41,
          u6_.roles AS roles_42,
          u6_.password AS password_43,
          u6_.actif AS actif_44,
          u6_.created_at AS created_at_45,
          u6_.updated_at AS updated_at_46,
          u6_.agence_role AS agence_role_47,
          u6_.active_session_token AS active_session_token_48,
          u6_.telephone AS telephone_49,
          u6_.profile_image AS profile_image_50,
          b7_.id AS id_51,
          b7_.path AS path_52,
          b7_.alt AS alt_53,
          b7_.caption AS caption_54,
          b7_.position AS position_55,
          b7_.thumb_small_path AS thumb_small_path_56,
          b7_.thumb_medium_path AS thumb_medium_path_57,
          b7_.thumb_large_path AS thumb_large_path_58,
          b7_.thumb_xl_path AS thumb_xl_path_59,
          b7_.created_at AS created_at_60,
          b8_.id AS id_61,
          b8_.path AS path_62,
          b8_.alt AS alt_63,
          b8_.caption AS caption_64,
          b8_.position AS position_65,
          b8_.thumb_small_path AS thumb_small_path_66,
          b8_.thumb_medium_path AS thumb_medium_path_67,
          b8_.thumb_large_path AS thumb_large_path_68,
          b8_.thumb_xl_path AS thumb_xl_path_69,
          b8_.created_at AS created_at_70
        FROM
          bien b0_
          LEFT JOIN bien_cadastral b1_ ON b0_.id = b1_.bien_id
          LEFT JOIN bien_details b2_ ON b0_.id = b2_.bien_id
          LEFT JOIN bien_finance b3_ ON b0_.id = b3_.bien_id
          LEFT JOIN bien_descriptif b4_ ON b0_.id = b4_.bien_id
          LEFT JOIN category c5_ ON b0_.category_id = c5_.id
          LEFT JOIN user u6_ ON b0_.courtier_id = u6_.id
          LEFT JOIN bien_image b7_ ON b0_.cover_image_id = b7_.id
          LEFT JOIN bien_image b8_ ON b0_.id = b8_.bien_id
        WHERE
          b0_.agence_id = ?
          AND b0_.deleted = 0
          AND b0_.statut = ?
        ORDER BY
          b8_.position ASC,
          b8_.id ASC
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC,
      position_65 ASC,
      id_61 ASC
  ) dctrn_result
LIMIT
  1

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_65, id_61 FROM (SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.statut AS statut_2, b0_.deal AS deal_3, b0_.deleted AS deleted_4, b0_.prestige AS prestige_5, b0_.foreigner_sale AS foreigner_sale_6, b0_.secondary_residence AS secondary_residence_7, b0_.comment AS comment_8, b0_.tags AS tags_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11, b1_.id AS id_12, b1_.country AS country_13, b1_.npa AS npa_14, b1_.city AS city_15, b1_.address AS address_16, b1_.substitution_address AS substitution_address_17, b1_.lat AS lat_18, b1_.lng AS lng_19, b1_.public_mode AS public_mode_20, b1_.pub_radius AS pub_radius_21, b1_.rf_number AS rf_number_22, b1_.egid AS egid_23, b1_.ewid AS ewid_24, b1_.construct_zone AS construct_zone_25, b2_.id AS id_26, b2_.data AS data_27, b3_.id AS id_28, b3_.data AS data_29, b4_.id AS id_30, b4_.data AS data_31, c5_.id AS id_32, c5_.name AS name_33, c5_.slug AS slug_34, c5_.active AS active_35, c5_.sort_order AS sort_order_36, c5_.depth AS depth_37, u6_.id AS id_38, u6_.email AS email_39, u6_.prenom AS prenom_40, u6_.nom AS nom_41, u6_.roles AS roles_42, u6_.password AS password_43, u6_.actif AS actif_44, u6_.created_at AS created_at_45, u6_.updated_at AS updated_at_46, u6_.agence_role AS agence_role_47, u6_.active_session_token AS active_session_token_48, u6_.telephone AS telephone_49, u6_.profile_image AS profile_image_50, b7_.id AS id_51, b7_.path AS path_52, b7_.alt AS alt_53, b7_.caption AS caption_54, b7_.position AS position_55, b7_.thumb_small_path AS thumb_small_path_56, b7_.thumb_medium_path AS thumb_medium_path_57, b7_.thumb_large_path AS thumb_large_path_58, b7_.thumb_xl_path AS thumb_xl_path_59, b7_.created_at AS created_at_60, b8_.id AS id_61, b8_.path AS path_62, b8_.alt AS alt_63, b8_.caption AS caption_64, b8_.position AS position_65, b8_.thumb_small_path AS thumb_small_path_66, b8_.thumb_medium_path AS thumb_medium_path_67, b8_.thumb_large_path AS thumb_large_path_68, b8_.thumb_xl_path AS thumb_xl_path_69, b8_.created_at AS created_at_70 FROM bien b0_ LEFT JOIN bien_cadastral b1_ ON b0_.id = b1_.bien_id LEFT JOIN bien_details b2_ ON b0_.id = b2_.bien_id LEFT JOIN bien_finance b3_ ON b0_.id = b3_.bien_id LEFT JOIN bien_descriptif b4_ ON b0_.id = b4_.bien_id LEFT JOIN category c5_ ON b0_.category_id = c5_.id LEFT JOIN user u6_ ON b0_.courtier_id = u6_.id LEFT JOIN bien_image b7_ ON b0_.cover_image_id = b7_.id LEFT JOIN bien_image b8_ ON b0_.id = b8_.bien_id WHERE b0_.agence_id = 5 AND b0_.deleted = 0 AND b0_.statut = 'ACTIVE' ORDER BY b8_.position ASC, b8_.id ASC) dctrn_result_inner ORDER BY id_0 DESC, position_65 ASC, id_61 ASC) dctrn_result LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.reference AS reference_1,
  b0_.statut AS statut_2,
  b0_.deal AS deal_3,
  b0_.deleted AS deleted_4,
  b0_.prestige AS prestige_5,
  b0_.foreigner_sale AS foreigner_sale_6,
  b0_.secondary_residence AS secondary_residence_7,
  b0_.comment AS comment_8,
  b0_.tags AS tags_9,
  b0_.created_at AS created_at_10,
  b0_.updated_at AS updated_at_11,
  b1_.id AS id_12,
  b1_.country AS country_13,
  b1_.npa AS npa_14,
  b1_.city AS city_15,
  b1_.address AS address_16,
  b1_.substitution_address AS substitution_address_17,
  b1_.lat AS lat_18,
  b1_.lng AS lng_19,
  b1_.public_mode AS public_mode_20,
  b1_.pub_radius AS pub_radius_21,
  b1_.rf_number AS rf_number_22,
  b1_.egid AS egid_23,
  b1_.ewid AS ewid_24,
  b1_.construct_zone AS construct_zone_25,
  b2_.id AS id_26,
  b2_.data AS data_27,
  b3_.id AS id_28,
  b3_.data AS data_29,
  b4_.id AS id_30,
  b4_.data AS data_31,
  c5_.id AS id_32,
  c5_.name AS name_33,
  c5_.slug AS slug_34,
  c5_.active AS active_35,
  c5_.sort_order AS sort_order_36,
  c5_.depth AS depth_37,
  u6_.id AS id_38,
  u6_.email AS email_39,
  u6_.prenom AS prenom_40,
  u6_.nom AS nom_41,
  u6_.roles AS roles_42,
  u6_.password AS password_43,
  u6_.actif AS actif_44,
  u6_.created_at AS created_at_45,
  u6_.updated_at AS updated_at_46,
  u6_.agence_role AS agence_role_47,
  u6_.active_session_token AS active_session_token_48,
  u6_.telephone AS telephone_49,
  u6_.profile_image AS profile_image_50,
  b7_.id AS id_51,
  b7_.path AS path_52,
  b7_.alt AS alt_53,
  b7_.caption AS caption_54,
  b7_.position AS position_55,
  b7_.thumb_small_path AS thumb_small_path_56,
  b7_.thumb_medium_path AS thumb_medium_path_57,
  b7_.thumb_large_path AS thumb_large_path_58,
  b7_.thumb_xl_path AS thumb_xl_path_59,
  b7_.created_at AS created_at_60,
  b8_.id AS id_61,
  b8_.path AS path_62,
  b8_.alt AS alt_63,
  b8_.caption AS caption_64,
  b8_.position AS position_65,
  b8_.thumb_small_path AS thumb_small_path_66,
  b8_.thumb_medium_path AS thumb_medium_path_67,
  b8_.thumb_large_path AS thumb_large_path_68,
  b8_.thumb_xl_path AS thumb_xl_path_69,
  b8_.created_at AS created_at_70,
  b0_.category_id AS category_id_71,
  b0_.courtier_id AS courtier_id_72,
  b0_.cover_image_id AS cover_image_id_73,
  b0_.created_by_id AS created_by_id_74,
  b0_.agence_id AS agence_id_75,
  b0_.projet_id AS projet_id_76,
  b1_.bien_id AS bien_id_77,
  b2_.bien_id AS bien_id_78,
  b3_.bien_id AS bien_id_79,
  b4_.bien_id AS bien_id_80,
  c5_.taxonomy_id AS taxonomy_id_81,
  c5_.parent_id AS parent_id_82,
  u6_.agence_id AS agence_id_83,
  u6_.filiale_id AS filiale_id_84,
  b7_.bien_id AS bien_id_85,
  b7_.created_by_id AS created_by_id_86,
  b8_.bien_id AS bien_id_87,
  b8_.created_by_id AS created_by_id_88
FROM
  bien b0_
  LEFT JOIN bien_cadastral b1_ ON b0_.id = b1_.bien_id
  LEFT JOIN bien_details b2_ ON b0_.id = b2_.bien_id
  LEFT JOIN bien_finance b3_ ON b0_.id = b3_.bien_id
  LEFT JOIN bien_descriptif b4_ ON b0_.id = b4_.bien_id
  LEFT JOIN category c5_ ON b0_.category_id = c5_.id
  LEFT JOIN user u6_ ON b0_.courtier_id = u6_.id
  LEFT JOIN bien_image b7_ ON b0_.cover_image_id = b7_.id
  LEFT JOIN bien_image b8_ ON b0_.id = b8_.bien_id
WHERE
  b0_.agence_id = ?
  AND b0_.deleted = 0
  AND b0_.statut = ?
  AND b0_.id IN (?)
ORDER BY
  b0_.id DESC,
  b8_.position ASC,
  b8_.id ASC

SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.statut AS statut_2, b0_.deal AS deal_3, b0_.deleted AS deleted_4, b0_.prestige AS prestige_5, b0_.foreigner_sale AS foreigner_sale_6, b0_.secondary_residence AS secondary_residence_7, b0_.comment AS comment_8, b0_.tags AS tags_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11, b1_.id AS id_12, b1_.country AS country_13, b1_.npa AS npa_14, b1_.city AS city_15, b1_.address AS address_16, b1_.substitution_address AS substitution_address_17, b1_.lat AS lat_18, b1_.lng AS lng_19, b1_.public_mode AS public_mode_20, b1_.pub_radius AS pub_radius_21, b1_.rf_number AS rf_number_22, b1_.egid AS egid_23, b1_.ewid AS ewid_24, b1_.construct_zone AS construct_zone_25, b2_.id AS id_26, b2_.data AS data_27, b3_.id AS id_28, b3_.data AS data_29, b4_.id AS id_30, b4_.data AS data_31, c5_.id AS id_32, c5_.name AS name_33, c5_.slug AS slug_34, c5_.active AS active_35, c5_.sort_order AS sort_order_36, c5_.depth AS depth_37, u6_.id AS id_38, u6_.email AS email_39, u6_.prenom AS prenom_40, u6_.nom AS nom_41, u6_.roles AS roles_42, u6_.password AS password_43, u6_.actif AS actif_44, u6_.created_at AS created_at_45, u6_.updated_at AS updated_at_46, u6_.agence_role AS agence_role_47, u6_.active_session_token AS active_session_token_48, u6_.telephone AS telephone_49, u6_.profile_image AS profile_image_50, b7_.id AS id_51, b7_.path AS path_52, b7_.alt AS alt_53, b7_.caption AS caption_54, b7_.position AS position_55, b7_.thumb_small_path AS thumb_small_path_56, b7_.thumb_medium_path AS thumb_medium_path_57, b7_.thumb_large_path AS thumb_large_path_58, b7_.thumb_xl_path AS thumb_xl_path_59, b7_.created_at AS created_at_60, b8_.id AS id_61, b8_.path AS path_62, b8_.alt AS alt_63, b8_.caption AS caption_64, b8_.position AS position_65, b8_.thumb_small_path AS thumb_small_path_66, b8_.thumb_medium_path AS thumb_medium_path_67, b8_.thumb_large_path AS thumb_large_path_68, b8_.thumb_xl_path AS thumb_xl_path_69, b8_.created_at AS created_at_70, b0_.category_id AS category_id_71, b0_.courtier_id AS courtier_id_72, b0_.cover_image_id AS cover_image_id_73, b0_.created_by_id AS created_by_id_74, b0_.agence_id AS agence_id_75, b0_.projet_id AS projet_id_76, b1_.bien_id AS bien_id_77, b2_.bien_id AS bien_id_78, b3_.bien_id AS bien_id_79, b4_.bien_id AS bien_id_80, c5_.taxonomy_id AS taxonomy_id_81, c5_.parent_id AS parent_id_82, u6_.agence_id AS agence_id_83, u6_.filiale_id AS filiale_id_84, b7_.bien_id AS bien_id_85, b7_.created_by_id AS created_by_id_86, b8_.bien_id AS bien_id_87, b8_.created_by_id AS created_by_id_88 FROM bien b0_ LEFT JOIN bien_cadastral b1_ ON b0_.id = b1_.bien_id LEFT JOIN bien_details b2_ ON b0_.id = b2_.bien_id LEFT JOIN bien_finance b3_ ON b0_.id = b3_.bien_id LEFT JOIN bien_descriptif b4_ ON b0_.id = b4_.bien_id LEFT JOIN category c5_ ON b0_.category_id = c5_.id LEFT JOIN user u6_ ON b0_.courtier_id = u6_.id LEFT JOIN bien_image b7_ ON b0_.cover_image_id = b7_.id LEFT JOIN bien_image b8_ ON b0_.id = b8_.bien_id WHERE b0_.agence_id = 5 AND b0_.deleted = 0 AND b0_.statut = 'ACTIVE' AND b0_.id IN (1013) ORDER BY b0_.id DESC, b8_.position ASC, b8_.id ASC;

SELECT
  t0.id AS id_1,
  t0.mode AS mode_2,
  t0.closed_at AS closed_at_3,
  t0.reason AS reason_4,
  t0.note AS note_5,
  t0.transaction_date AS transaction_date_6,
  t0.transaction_amount AS transaction_amount_7,
  t0.commission_amount AS commission_amount_8,
  t0.buyer_name AS buyer_name_9,
  t0.entry_into_possession_date AS entry_into_possession_date_10,
  t0.invoice_number AS invoice_number_11,
  t0.commission_payment_due_date AS commission_payment_due_date_12,
  t0.commission_payment_date AS commission_payment_date_13,
  t0.lease_start_date AS lease_start_date_14,
  t0.lease_end_date AS lease_end_date_15,
  t0.rent_amount AS rent_amount_16,
  t0.charges_amount AS charges_amount_17,
  t0.deposit_amount AS deposit_amount_18,
  t0.tenant_name AS tenant_name_19,
  t0.show_in_mandant_report AS show_in_mandant_report_20,
  t0.bien_id AS bien_id_21,
  t0.closed_by_id AS closed_by_id_22,
  t0.seller_id AS seller_id_23,
  t0.tenant_contact_id AS tenant_contact_id_24,
  t0.manager_id AS manager_id_25
FROM
  bien_closure t0
WHERE
  t0.bien_id = ?

SELECT t0.id AS id_1, t0.mode AS mode_2, t0.closed_at AS closed_at_3, t0.reason AS reason_4, t0.note AS note_5, t0.transaction_date AS transaction_date_6, t0.transaction_amount AS transaction_amount_7, t0.commission_amount AS commission_amount_8, t0.buyer_name AS buyer_name_9, t0.entry_into_possession_date AS entry_into_possession_date_10, t0.invoice_number AS invoice_number_11, t0.commission_payment_due_date AS commission_payment_due_date_12, t0.commission_payment_date AS commission_payment_date_13, t0.lease_start_date AS lease_start_date_14, t0.lease_end_date AS lease_end_date_15, t0.rent_amount AS rent_amount_16, t0.charges_amount AS charges_amount_17, t0.deposit_amount AS deposit_amount_18, t0.tenant_name AS tenant_name_19, t0.show_in_mandant_report AS show_in_mandant_report_20, t0.bien_id AS bien_id_21, t0.closed_by_id AS closed_by_id_22, t0.seller_id AS seller_id_23, t0.tenant_contact_id AS tenant_contact_id_24, t0.manager_id AS manager_id_25 FROM bien_closure t0 WHERE t0.bien_id = 1013;