Symfony Profiler

"COMMIT"

"COMMIT";

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;

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

UPDATE agence_api_key SET last_used_at = '2026-07-02 11:12:40', hits_total = 4904 WHERE id = 4;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.statut AS statut_3,
  t0.deal AS deal_4,
  t0.deleted AS deleted_5,
  t0.prestige AS prestige_6,
  t0.foreigner_sale AS foreigner_sale_7,
  t0.secondary_residence AS secondary_residence_8,
  t0.comment AS comment_9,
  t0.tags AS tags_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.category_id AS category_id_13,
  t14.id AS id_15,
  t14.country AS country_16,
  t14.npa AS npa_17,
  t14.city AS city_18,
  t14.address AS address_19,
  t14.substitution_address AS substitution_address_20,
  t14.lat AS lat_21,
  t14.lng AS lng_22,
  t14.public_mode AS public_mode_23,
  t14.pub_radius AS pub_radius_24,
  t14.rf_number AS rf_number_25,
  t14.egid AS egid_26,
  t14.ewid AS ewid_27,
  t14.construct_zone AS construct_zone_28,
  t14.bien_id AS bien_id_29,
  t30.id AS id_31,
  t30.data AS data_32,
  t30.bien_id AS bien_id_33,
  t34.id AS id_35,
  t34.data AS data_36,
  t34.bien_id AS bien_id_37,
  t38.id AS id_39,
  t38.data AS data_40,
  t38.bien_id AS bien_id_41,
  t0.courtier_id AS courtier_id_42,
  t0.cover_image_id AS cover_image_id_43,
  t0.created_by_id AS created_by_id_44,
  t0.agence_id AS agence_id_45,
  t0.projet_id AS projet_id_46,
  t47.id AS id_48,
  t47.mode AS mode_49,
  t47.closed_at AS closed_at_50,
  t47.reason AS reason_51,
  t47.note AS note_52,
  t47.transaction_date AS transaction_date_53,
  t47.transaction_amount AS transaction_amount_54,
  t47.commission_amount AS commission_amount_55,
  t47.buyer_name AS buyer_name_56,
  t47.entry_into_possession_date AS entry_into_possession_date_57,
  t47.invoice_number AS invoice_number_58,
  t47.commission_payment_due_date AS commission_payment_due_date_59,
  t47.commission_payment_date AS commission_payment_date_60,
  t47.lease_start_date AS lease_start_date_61,
  t47.lease_end_date AS lease_end_date_62,
  t47.rent_amount AS rent_amount_63,
  t47.charges_amount AS charges_amount_64,
  t47.deposit_amount AS deposit_amount_65,
  t47.tenant_name AS tenant_name_66,
  t47.show_in_mandant_report AS show_in_mandant_report_67,
  t47.bien_id AS bien_id_68,
  t47.closed_by_id AS closed_by_id_69,
  t47.seller_id AS seller_id_70,
  t47.tenant_contact_id AS tenant_contact_id_71,
  t47.manager_id AS manager_id_72
FROM
  bien t0
  LEFT JOIN bien_cadastral t14 ON t14.bien_id = t0.id
  LEFT JOIN bien_details t30 ON t30.bien_id = t0.id
  LEFT JOIN bien_finance t34 ON t34.bien_id = t0.id
  LEFT JOIN bien_descriptif t38 ON t38.bien_id = t0.id
  LEFT JOIN bien_closure t47 ON t47.bien_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.statut AS statut_3, t0.deal AS deal_4, t0.deleted AS deleted_5, t0.prestige AS prestige_6, t0.foreigner_sale AS foreigner_sale_7, t0.secondary_residence AS secondary_residence_8, t0.comment AS comment_9, t0.tags AS tags_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13, t14.id AS id_15, t14.country AS country_16, t14.npa AS npa_17, t14.city AS city_18, t14.address AS address_19, t14.substitution_address AS substitution_address_20, t14.lat AS lat_21, t14.lng AS lng_22, t14.public_mode AS public_mode_23, t14.pub_radius AS pub_radius_24, t14.rf_number AS rf_number_25, t14.egid AS egid_26, t14.ewid AS ewid_27, t14.construct_zone AS construct_zone_28, t14.bien_id AS bien_id_29, t30.id AS id_31, t30.data AS data_32, t30.bien_id AS bien_id_33, t34.id AS id_35, t34.data AS data_36, t34.bien_id AS bien_id_37, t38.id AS id_39, t38.data AS data_40, t38.bien_id AS bien_id_41, t0.courtier_id AS courtier_id_42, t0.cover_image_id AS cover_image_id_43, t0.created_by_id AS created_by_id_44, t0.agence_id AS agence_id_45, t0.projet_id AS projet_id_46, t47.id AS id_48, t47.mode AS mode_49, t47.closed_at AS closed_at_50, t47.reason AS reason_51, t47.note AS note_52, t47.transaction_date AS transaction_date_53, t47.transaction_amount AS transaction_amount_54, t47.commission_amount AS commission_amount_55, t47.buyer_name AS buyer_name_56, t47.entry_into_possession_date AS entry_into_possession_date_57, t47.invoice_number AS invoice_number_58, t47.commission_payment_due_date AS commission_payment_due_date_59, t47.commission_payment_date AS commission_payment_date_60, t47.lease_start_date AS lease_start_date_61, t47.lease_end_date AS lease_end_date_62, t47.rent_amount AS rent_amount_63, t47.charges_amount AS charges_amount_64, t47.deposit_amount AS deposit_amount_65, t47.tenant_name AS tenant_name_66, t47.show_in_mandant_report AS show_in_mandant_report_67, t47.bien_id AS bien_id_68, t47.closed_by_id AS closed_by_id_69, t47.seller_id AS seller_id_70, t47.tenant_contact_id AS tenant_contact_id_71, t47.manager_id AS manager_id_72 FROM bien t0 LEFT JOIN bien_cadastral t14 ON t14.bien_id = t0.id LEFT JOIN bien_details t30 ON t30.bien_id = t0.id LEFT JOIN bien_finance t34 ON t34.bien_id = t0.id LEFT JOIN bien_descriptif t38 ON t38.bien_id = t0.id LEFT JOIN bien_closure t47 ON t47.bien_id = t0.id WHERE t0.id = 1007;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.expires_at AS expires_at_3,
  t0.created_at AS created_at_4,
  t0.last_used_at AS last_used_at_5,
  t0.contact_id AS contact_id_6
FROM
  contact_session t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.created_at AS created_at_4, t0.last_used_at AS last_used_at_5, t0.contact_id AS contact_id_6 FROM contact_session t0 WHERE t0.token = '64ce24778a9eeca6620141e8b3c7f9755553496059c710ef15248fda609f9395' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  contact_session
SET
  last_used_at = ?
WHERE
  id = ?

UPDATE contact_session SET last_used_at = '2026-07-02 11:12:40' WHERE id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4,
  t0.sort_order AS sort_order_5,
  t0.depth AS depth_6,
  t0.taxonomy_id AS taxonomy_id_7,
  t0.parent_id AS parent_id_8
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.sort_order AS sort_order_5, t0.depth AS depth_6, t0.taxonomy_id AS taxonomy_id_7, t0.parent_id AS parent_id_8 FROM category t0 WHERE t0.id = 217;

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
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.caption AS caption_4,
  t0.position AS position_5,
  t0.thumb_small_path AS thumb_small_path_6,
  t0.thumb_medium_path AS thumb_medium_path_7,
  t0.thumb_large_path AS thumb_large_path_8,
  t0.thumb_xl_path AS thumb_xl_path_9,
  t0.created_at AS created_at_10,
  t0.bien_id AS bien_id_11,
  t0.created_by_id AS created_by_id_12
FROM
  bien_image t0
WHERE
  t0.bien_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.caption AS caption_4, t0.position AS position_5, t0.thumb_small_path AS thumb_small_path_6, t0.thumb_medium_path AS thumb_medium_path_7, t0.thumb_large_path AS thumb_large_path_8, t0.thumb_xl_path AS thumb_xl_path_9, t0.created_at AS created_at_10, t0.bien_id AS bien_id_11, t0.created_by_id AS created_by_id_12 FROM bien_image t0 WHERE t0.bien_id = 1007 ORDER BY t0.position ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.data AS data_6,
  t0.params AS params_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.password_hash AS password_hash_10,
  t0.account_enabled AS account_enabled_11,
  t0.account_created_at AS account_created_at_12,
  t0.last_login_at AS last_login_at_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.password_reset_token_expires_at AS password_reset_token_expires_at_15,
  t0.agence_id AS agence_id_16
FROM
  contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.data AS data_6, t0.params AS params_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.password_hash AS password_hash_10, t0.account_enabled AS account_enabled_11, t0.account_created_at AS account_created_at_12, t0.last_login_at AS last_login_at_13, t0.password_reset_token AS password_reset_token_14, t0.password_reset_token_expires_at AS password_reset_token_expires_at_15, t0.agence_id AS agence_id_16 FROM contact t0 WHERE t0.id = 40;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.caption AS caption_4,
  t0.position AS position_5,
  t0.thumb_small_path AS thumb_small_path_6,
  t0.thumb_medium_path AS thumb_medium_path_7,
  t0.thumb_large_path AS thumb_large_path_8,
  t0.thumb_xl_path AS thumb_xl_path_9,
  t0.created_at AS created_at_10,
  t0.bien_id AS bien_id_11,
  t0.created_by_id AS created_by_id_12
FROM
  bien_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.caption AS caption_4, t0.position AS position_5, t0.thumb_small_path AS thumb_small_path_6, t0.thumb_medium_path AS thumb_medium_path_7, t0.thumb_large_path AS thumb_large_path_8, t0.thumb_xl_path AS thumb_xl_path_9, t0.created_at AS created_at_10, t0.bien_id AS bien_id_11, t0.created_by_id AS created_by_id_12 FROM bien_image t0 WHERE t0.id = 4081;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.contact_id AS contact_id_3,
  t0.bien_id AS bien_id_4
FROM
  contact_favorite t0
WHERE
  t0.contact_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.contact_id AS contact_id_3, t0.bien_id AS bien_id_4 FROM contact_favorite t0 WHERE t0.contact_id = 40 ORDER BY t0.id DESC;