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 12:16:18', hits_total = 5011 WHERE id = 4;

"COMMIT"

"COMMIT";

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,
  u5_.id AS id_32,
  u5_.email AS email_33,
  u5_.prenom AS prenom_34,
  u5_.nom AS nom_35,
  u5_.roles AS roles_36,
  u5_.password AS password_37,
  u5_.actif AS actif_38,
  u5_.created_at AS created_at_39,
  u5_.updated_at AS updated_at_40,
  u5_.agence_role AS agence_role_41,
  u5_.active_session_token AS active_session_token_42,
  u5_.telephone AS telephone_43,
  u5_.profile_image AS profile_image_44,
  c6_.id AS id_45,
  c6_.name AS name_46,
  c6_.slug AS slug_47,
  c6_.active AS active_48,
  c6_.sort_order AS sort_order_49,
  c6_.depth AS depth_50,
  c7_.id AS id_51,
  c7_.name AS name_52,
  c7_.slug AS slug_53,
  c7_.active AS active_54,
  c7_.sort_order AS sort_order_55,
  c7_.depth AS depth_56,
  c8_.id AS id_57,
  c8_.name AS name_58,
  c8_.slug AS slug_59,
  c8_.active AS active_60,
  c8_.sort_order AS sort_order_61,
  c8_.depth AS depth_62,
  b9_.id AS id_63,
  b9_.path AS path_64,
  b9_.alt AS alt_65,
  b9_.caption AS caption_66,
  b9_.position AS position_67,
  b9_.thumb_small_path AS thumb_small_path_68,
  b9_.thumb_medium_path AS thumb_medium_path_69,
  b9_.thumb_large_path AS thumb_large_path_70,
  b9_.thumb_xl_path AS thumb_xl_path_71,
  b9_.created_at AS created_at_72,
  b10_.id AS id_73,
  b10_.path AS path_74,
  b10_.alt AS alt_75,
  b10_.caption AS caption_76,
  b10_.position AS position_77,
  b10_.thumb_small_path AS thumb_small_path_78,
  b10_.thumb_medium_path AS thumb_medium_path_79,
  b10_.thumb_large_path AS thumb_large_path_80,
  b10_.thumb_xl_path AS thumb_xl_path_81,
  b10_.created_at AS created_at_82,
  b11_.id AS id_83,
  b11_.path AS path_84,
  b11_.original_name AS original_name_85,
  b11_.display_name AS display_name_86,
  b11_.mime_type AS mime_type_87,
  b11_.size AS size_88,
  b11_.position AS position_89,
  b11_.created_at AS created_at_90,
  b0_.category_id AS category_id_91,
  b0_.courtier_id AS courtier_id_92,
  b0_.cover_image_id AS cover_image_id_93,
  b0_.created_by_id AS created_by_id_94,
  b0_.agence_id AS agence_id_95,
  b0_.projet_id AS projet_id_96,
  b1_.bien_id AS bien_id_97,
  b2_.bien_id AS bien_id_98,
  b3_.bien_id AS bien_id_99,
  b4_.bien_id AS bien_id_100,
  u5_.agence_id AS agence_id_101,
  u5_.filiale_id AS filiale_id_102,
  c6_.taxonomy_id AS taxonomy_id_103,
  c6_.parent_id AS parent_id_104,
  c7_.taxonomy_id AS taxonomy_id_105,
  c7_.parent_id AS parent_id_106,
  c8_.taxonomy_id AS taxonomy_id_107,
  c8_.parent_id AS parent_id_108,
  b9_.bien_id AS bien_id_109,
  b9_.created_by_id AS created_by_id_110,
  b10_.bien_id AS bien_id_111,
  b10_.created_by_id AS created_by_id_112,
  b11_.bien_id AS bien_id_113,
  b11_.created_by_id AS created_by_id_114
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 user u5_ ON b0_.courtier_id = u5_.id
  LEFT JOIN category c6_ ON b0_.category_id = c6_.id
  LEFT JOIN bien_commodite b12_ ON b0_.id = b12_.bien_id
  LEFT JOIN category c7_ ON c7_.id = b12_.category_id
  LEFT JOIN category c8_ ON c7_.parent_id = c8_.id
  LEFT JOIN bien_image b9_ ON b0_.cover_image_id = b9_.id
  LEFT JOIN bien_image b10_ ON b0_.id = b10_.bien_id
  LEFT JOIN bien_file b11_ ON b0_.id = b11_.bien_id
WHERE
  b0_.id = ?
  AND b0_.agence_id = ?
  AND b0_.deleted = 0
  AND b0_.statut = ?
ORDER BY
  b10_.position ASC,
  b10_.id ASC,
  b11_.position ASC,
  b11_.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, u5_.id AS id_32, u5_.email AS email_33, u5_.prenom AS prenom_34, u5_.nom AS nom_35, u5_.roles AS roles_36, u5_.password AS password_37, u5_.actif AS actif_38, u5_.created_at AS created_at_39, u5_.updated_at AS updated_at_40, u5_.agence_role AS agence_role_41, u5_.active_session_token AS active_session_token_42, u5_.telephone AS telephone_43, u5_.profile_image AS profile_image_44, c6_.id AS id_45, c6_.name AS name_46, c6_.slug AS slug_47, c6_.active AS active_48, c6_.sort_order AS sort_order_49, c6_.depth AS depth_50, c7_.id AS id_51, c7_.name AS name_52, c7_.slug AS slug_53, c7_.active AS active_54, c7_.sort_order AS sort_order_55, c7_.depth AS depth_56, c8_.id AS id_57, c8_.name AS name_58, c8_.slug AS slug_59, c8_.active AS active_60, c8_.sort_order AS sort_order_61, c8_.depth AS depth_62, b9_.id AS id_63, b9_.path AS path_64, b9_.alt AS alt_65, b9_.caption AS caption_66, b9_.position AS position_67, b9_.thumb_small_path AS thumb_small_path_68, b9_.thumb_medium_path AS thumb_medium_path_69, b9_.thumb_large_path AS thumb_large_path_70, b9_.thumb_xl_path AS thumb_xl_path_71, b9_.created_at AS created_at_72, b10_.id AS id_73, b10_.path AS path_74, b10_.alt AS alt_75, b10_.caption AS caption_76, b10_.position AS position_77, b10_.thumb_small_path AS thumb_small_path_78, b10_.thumb_medium_path AS thumb_medium_path_79, b10_.thumb_large_path AS thumb_large_path_80, b10_.thumb_xl_path AS thumb_xl_path_81, b10_.created_at AS created_at_82, b11_.id AS id_83, b11_.path AS path_84, b11_.original_name AS original_name_85, b11_.display_name AS display_name_86, b11_.mime_type AS mime_type_87, b11_.size AS size_88, b11_.position AS position_89, b11_.created_at AS created_at_90, b0_.category_id AS category_id_91, b0_.courtier_id AS courtier_id_92, b0_.cover_image_id AS cover_image_id_93, b0_.created_by_id AS created_by_id_94, b0_.agence_id AS agence_id_95, b0_.projet_id AS projet_id_96, b1_.bien_id AS bien_id_97, b2_.bien_id AS bien_id_98, b3_.bien_id AS bien_id_99, b4_.bien_id AS bien_id_100, u5_.agence_id AS agence_id_101, u5_.filiale_id AS filiale_id_102, c6_.taxonomy_id AS taxonomy_id_103, c6_.parent_id AS parent_id_104, c7_.taxonomy_id AS taxonomy_id_105, c7_.parent_id AS parent_id_106, c8_.taxonomy_id AS taxonomy_id_107, c8_.parent_id AS parent_id_108, b9_.bien_id AS bien_id_109, b9_.created_by_id AS created_by_id_110, b10_.bien_id AS bien_id_111, b10_.created_by_id AS created_by_id_112, b11_.bien_id AS bien_id_113, b11_.created_by_id AS created_by_id_114 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 user u5_ ON b0_.courtier_id = u5_.id LEFT JOIN category c6_ ON b0_.category_id = c6_.id LEFT JOIN bien_commodite b12_ ON b0_.id = b12_.bien_id LEFT JOIN category c7_ ON c7_.id = b12_.category_id LEFT JOIN category c8_ ON c7_.parent_id = c8_.id LEFT JOIN bien_image b9_ ON b0_.cover_image_id = b9_.id LEFT JOIN bien_image b10_ ON b0_.id = b10_.bien_id LEFT JOIN bien_file b11_ ON b0_.id = b11_.bien_id WHERE b0_.id = 1012 AND b0_.agence_id = 5 AND b0_.deleted = 0 AND b0_.statut = 'ACTIVE' ORDER BY b10_.position ASC, b10_.id ASC, b11_.position ASC, b11_.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 = 1012;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.default_cost AS default_cost_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.ftp_enabled AS ftp_enabled_8,
  t0.website AS website_9
FROM
  passerelle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.default_cost AS default_cost_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.ftp_enabled AS ftp_enabled_8, t0.website AS website_9 FROM passerelle t0 WHERE t0.id = 12;