Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.status AS status_5,
  t0.state AS state_6,
  t0.type AS type_7,
  t0.area AS area_8,
  t0.rooms AS rooms_9,
  t0.floor AS floor_10,
  t0.elevator AS elevator_11,
  t0.furnished AS furnished_12,
  t0.heating AS heating_13,
  t0.equipments AS equipments_14,
  t0.benefits AS benefits_15,
  t0.rent AS rent_16,
  t0.charges AS charges_17,
  t0.services AS services_18,
  t0.availability_date AS availability_date_19,
  t0.description AS description_20,
  t0.title AS title_21,
  t0.active AS active_22,
  t0.score AS score_23,
  t0.extrafields AS extrafields_24,
  t0.owner_id AS owner_id_25,
  t0.address_id AS address_id_26
FROM
  property t0
WHERE
  t0.uid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.status AS status_5, t0.state AS state_6, t0.type AS type_7, t0.area AS area_8, t0.rooms AS rooms_9, t0.floor AS floor_10, t0.elevator AS elevator_11, t0.furnished AS furnished_12, t0.heating AS heating_13, t0.equipments AS equipments_14, t0.benefits AS benefits_15, t0.rent AS rent_16, t0.charges AS charges_17, t0.services AS services_18, t0.availability_date AS availability_date_19, t0.description AS description_20, t0.title AS title_21, t0.active AS active_22, t0.score AS score_23, t0.extrafields AS extrafields_24, t0.owner_id AS owner_id_25, t0.address_id AS address_id_26 FROM property t0 WHERE t0.uid = '6a467a20bd62' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.name AS name_3,
  t0.position AS position_4,
  t0.property_id AS property_id_5
FROM
  property_image t0
WHERE
  t0.property_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.name AS name_3, t0.position AS position_4, t0.property_id AS property_id_5 FROM property_image t0 WHERE t0.property_id = 3 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.label AS label_3,
  t0.address AS address_4,
  t0.housenumber AS housenumber_5,
  t0.street AS street_6,
  t0.city AS city_7,
  t0.zipcode AS zipcode_8,
  t0.area AS area_9,
  t0.context AS context_10,
  t0.longitude AS longitude_11,
  t0.latitude AS latitude_12,
  t0.api_id AS api_id_13,
  t0.slug AS slug_14,
  t0.state AS state_15,
  t0.city_slug AS city_slug_16,
  t0.area_slug AS area_slug_17,
  t0.place AS place_18,
  t0.district AS district_19,
  t0.tier AS tier_20,
  t0.hood AS hood_21
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.label AS label_3, t0.address AS address_4, t0.housenumber AS housenumber_5, t0.street AS street_6, t0.city AS city_7, t0.zipcode AS zipcode_8, t0.area AS area_9, t0.context AS context_10, t0.longitude AS longitude_11, t0.latitude AS latitude_12, t0.api_id AS api_id_13, t0.slug AS slug_14, t0.state AS state_15, t0.city_slug AS city_slug_16, t0.area_slug AS area_slug_17, t0.place AS place_18, t0.district AS district_19, t0.tier AS tier_20, t0.hood AS hood_21 FROM address t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.total AS total_3,
  t0.property_id AS property_id_4
FROM
  counter t0
WHERE
  t0.property_id = ?
  AND t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.total AS total_3, t0.property_id AS property_id_4 FROM counter t0 WHERE t0.property_id = 3 AND t0.label = 'viewed' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.total AS total_3,
  t0.property_id AS property_id_4
FROM
  counter t0
WHERE
  t0.property_id = ?
  AND t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.total AS total_3, t0.property_id AS property_id_4 FROM counter t0 WHERE t0.property_id = 3 AND t0.label = 'viewed' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.total AS total_3,
  t0.property_id AS property_id_4
FROM
  counter t0
WHERE
  t0.property_id = ?
  AND t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.total AS total_3, t0.property_id AS property_id_4 FROM counter t0 WHERE t0.property_id = 3 AND t0.label = 'applied' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  property
SET
  score = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE property SET score = 3.1354942159291, updated_at = '2026-07-26 03:24:54' WHERE id = 3;

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.connected_at AS connected_at_5,
  t0.user_agent AS user_agent_6,
  t0.email AS email_7,
  t0.roles AS roles_8,
  t0.password AS password_9,
  t0.type AS type_10,
  t0.status AS status_11,
  t0.firstname AS firstname_12,
  t0.lastname AS lastname_13,
  t0.phone AS phone_14,
  t0.premium_start AS premium_start_15,
  t0.premium_end AS premium_end_16,
  t0.premium_status AS premium_status_17,
  t0.premium_canceled AS premium_canceled_18,
  t0.payment_id AS payment_id_19,
  t0.premium_promocode AS premium_promocode_20,
  t0.customer_id AS customer_id_21,
  t0.dialing_code AS dialing_code_22,
  t0.language AS language_23,
  t24.id AS id_25,
  t24.uid AS uid_26,
  t24.created_at AS created_at_27,
  t24.updated_at AS updated_at_28,
  t24.status AS status_29,
  t24.state AS state_30,
  t24.min_area AS min_area_31,
  t24.min_rooms AS min_rooms_32,
  t24.furnished AS furnished_33,
  t24.max_rent AS max_rent_34,
  t24.residents AS residents_35,
  t24.description AS description_36,
  t24.image AS image_37,
  t24.cities AS cities_38,
  t24.extrafields AS extrafields_39,
  t24.tenant_id AS tenant_id_40,
  t24.city_id AS city_id_41
FROM
  "user" t0
  LEFT JOIN rental_file t24 ON t24.tenant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.connected_at AS connected_at_5, t0.user_agent AS user_agent_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.type AS type_10, t0.status AS status_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.phone AS phone_14, t0.premium_start AS premium_start_15, t0.premium_end AS premium_end_16, t0.premium_status AS premium_status_17, t0.premium_canceled AS premium_canceled_18, t0.payment_id AS payment_id_19, t0.premium_promocode AS premium_promocode_20, t0.customer_id AS customer_id_21, t0.dialing_code AS dialing_code_22, t0.language AS language_23, t24.id AS id_25, t24.uid AS uid_26, t24.created_at AS created_at_27, t24.updated_at AS updated_at_28, t24.status AS status_29, t24.state AS state_30, t24.min_area AS min_area_31, t24.min_rooms AS min_rooms_32, t24.furnished AS furnished_33, t24.max_rent AS max_rent_34, t24.residents AS residents_35, t24.description AS description_36, t24.image AS image_37, t24.cities AS cities_38, t24.extrafields AS extrafields_39, t24.tenant_id AS tenant_id_40, t24.city_id AS city_id_41 FROM "user" t0 LEFT JOIN rental_file t24 ON t24.tenant_id = t0.id WHERE t0.id = 11;

UPDATE
  counter
SET
  total = ?
WHERE
  id = ?

UPDATE counter SET total = 22 WHERE id = 3;

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.uid AS uid_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.status AS status_4,
  p0_.state AS state_5,
  p0_.type AS type_6,
  p0_.area AS area_7,
  p0_.rooms AS rooms_8,
  p0_.floor AS floor_9,
  p0_.elevator AS elevator_10,
  p0_.furnished AS furnished_11,
  p0_.heating AS heating_12,
  p0_.equipments AS equipments_13,
  p0_.benefits AS benefits_14,
  p0_.rent AS rent_15,
  p0_.charges AS charges_16,
  p0_.services AS services_17,
  p0_.availability_date AS availability_date_18,
  p0_.description AS description_19,
  p0_.title AS title_20,
  p0_.active AS active_21,
  p0_.score AS score_22,
  p0_.extrafields AS extrafields_23,
  p0_.owner_id AS owner_id_24,
  p0_.address_id AS address_id_25
FROM
  property p0_
  LEFT JOIN address a1_ ON p0_.address_id = a1_.id
WHERE
  a1_.slug = ?
  AND p0_.rent <= ?
  AND p0_.rooms = ?
  AND p0_.uid <> ?
  AND p0_.active = true
LIMIT
  6

SELECT p0_.id AS id_0, p0_.uid AS uid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.state AS state_5, p0_.type AS type_6, p0_.area AS area_7, p0_.rooms AS rooms_8, p0_.floor AS floor_9, p0_.elevator AS elevator_10, p0_.furnished AS furnished_11, p0_.heating AS heating_12, p0_.equipments AS equipments_13, p0_.benefits AS benefits_14, p0_.rent AS rent_15, p0_.charges AS charges_16, p0_.services AS services_17, p0_.availability_date AS availability_date_18, p0_.description AS description_19, p0_.title AS title_20, p0_.active AS active_21, p0_.score AS score_22, p0_.extrafields AS extrafields_23, p0_.owner_id AS owner_id_24, p0_.address_id AS address_id_25 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE a1_.slug = 'beauraing-5570' AND p0_.rent <= 221 AND p0_.rooms = 5 AND p0_.uid <> '6a467a20bd62' AND p0_.active = true LIMIT 6;