Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.token AS token_5
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token AS token_5 FROM user t0 WHERE t0.id = 44;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.date AS date_3,
  t0.propname AS propname_4,
  t0.brand AS brand_5,
  t0.user_id AS user_id_6,
  t0.version AS version_7,
  t0.total_score AS total_score_8,
  t0.stars AS stars_9,
  t0.is_deleted AS is_deleted_10,
  t0.data AS data_11,
  t0.completeness AS completeness_12
FROM
  inspection t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.date AS date_3, t0.propname AS propname_4, t0.brand AS brand_5, t0.user_id AS user_id_6, t0.version AS version_7, t0.total_score AS total_score_8, t0.stars AS stars_9, t0.is_deleted AS is_deleted_10, t0.data AS data_11, t0.completeness AS completeness_12 FROM inspection t0 WHERE t0.uuid = 'f5126853-8fa0-4d00-8212-d9c33498ff16' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  inspection
SET
  date = ?,
  version = ?,
  data = ?,
  completeness = ?
WHERE
  id = ?

UPDATE inspection SET date = '2025-10-27 16:01:20', version = 29, data = '{\"uuid\":\"f5126853-8fa0-4d00-8212-d9c33498ff16\",\"version\":\"29\",\"date\":\"2025-10-27\",\"propname\":\"19b Small Ships\",\"totalScore\":\"73\",\"stars\":\"3.5\",\"extbuildappear\":\"4\",\"extparkfacility\":\"4\",\"extsiding\":\"4.5\",\"exteriorTotal\":\"83\",\"extpropertysign\":\"5\",\"extkeysafe\":\"5\",\"extemergencykeysafe\":\"0\",\"extlighting\":\"5\",\"extgates\":\"n\\/a\",\"extgardenfurniture\":\"5\",\"extbarbecue\":\"n\\/a\",\"extnotes\":\"deep clean on the balcony after winter would be a good idea\",\"extpic1\":null,\"extpic2\":null,\"extpic3\":null,\"extpic4\":null,\"generalinformationpack\":\"4\",\"generalwelcomepack\":\"4.5\",\"generalwifi\":\"4\",\"generalwifilogininfoandspeed\":\"26.66\",\"generalspaceandeaseofuse\":\"4\",\"generalaccessories\":\"4\",\"generalcleanliness\":\"4.5\",\"generalTotal\":\"83\",\"generalcot\":\"0\",\"generalhighchair\":\"0\",\"generalstairgate\":\"n\\/a\",\"generalvacuum\":\"5\",\"generaliron\":\"0\",\"generalwashingmachine\":\"5\",\"generaltumbledryer\":\"0\",\"generalnotes\":\"Small Ships is a lovely property. There is a lot of good space and nice touches in here. The log burner is a very nice touch and adds a feeling of home and warmth throughout. (Thank you for getting rid of the trolley in the kitchen.)\",\"generalpic1\":null,\"generalpic2\":null,\"generalpic3\":null,\"generalpic4\":null,\"publicdecoration\":\"4\",\"publicfurniture\":\"3.5\",\"publicflooring\":\"3\",\"publiclighting\":\"4\",\"publicTotal\":\"73\",\"publiccurtains\":\"5\",\"publicdiningtable\":\"0\",\"publiccoffeetable\":\"5\",\"publiclamps\":\"5\",\"publictv\":\"5\",\"publicfireproofbin\":\"0\",\"publicnotes\":\"a fireproof bin is needed.\\r\\nThe new table is nice and spacious. Could do with coasters and placemats for this.\\r\\nA good carpet clean needed throughout and the threshold into the kitchen needs replacing due to a large crack in it.\",\"publicpic1\":null,\"publicpic2\":null,\"publicpic3\":null,\"publicpic4\":null,\"kitchendecoration\":\"3.5\",\"kitchenfurniture\":\"3\",\"kitchenflooring\":\"3.5\",\"kitchenlighting\":\"3.5\",\"kitchenequipment\":\"3.5\",\"kitchencrockerycutleryglassware\":\"3\",\"kitchenpots\":\"3\",\"kitchenTotal\":\"66\",\"kitchencooker\":\"5\",\"kitchenfridge\":\"5\",\"kitchenfreezer\":\"5\",\"kitchendishwasher\":\"5\",\"kitchenmicrowave\":\"5\",\"kitchentoaster\":\"5\",\"kitchenkettle\":\"5\",\"kitchensaucepans\":\"5\",\"kitchenfryingpans\":\"5\",\"kitchencookware\":\"5\",\"kitchenutensils\":\"5\",\"kitchencrockery\":\"5\",\"kitchencutlery\":\"5\",\"kitchenglasses\":\"5\",\"kitchentablemats\":\"0\",\"kitchensaltandpepper\":\"5\",\"kitchenwashingupbowl\":\"0\",\"kitchencleaningmaterials\":\"5\",\"kitchennotes\":\"The cutlery is very mis matched and marked so a new set of these would be good and a set of tumblers. \\r\\nThe drawers are starting to slip and the fridge front needs addressing. 1 side plate missing. needs a washing up bowl and a dish drainer.\\r\\nThe kitchen work tops need sanding and treating and a couple of heatproof mats would avoid further marks on this.\",\"kitchenpic1\":null,\"kitchenpic2\":\"null\",\"kitchenpic3\":null,\"kitchenpic4\":null,\"bedrooms\":\"1\",\"bedroom_1_name\":\"Bedrooms\",\"bedroom_1_decoration\":\"3\",\"bedroom_1_furniture\":\"3.5\",\"bedroom_1_flooring\":\"3\",\"bedroom_1_lighting\":\"3.5\",\"bedroom_1_beds\":\"3.5\",\"bedroom_1_bedding\":\"4.5\",\"bedroom_1_curtains\":\"5\",\"bedroom_1_duvets\":\"5\",\"bedroom_1_mattressprotector\":\"5\",\"bedroom_1_towelsprovided\":\"5\",\"bedroom_1_wardrobe\":\"5\",\"bedroom_1_bedsidetable\":\"5\",\"bedroom_1_lamps\":\"5\",\"bedroom_1_wastebins\":\"5\",\"bedroomsTotal\":\"70\",\"bedroomsnotes\":\"The touches in the single room could do with organising. The master bedroom would benefit from some more colour. (artwork.)\",\"bedroomspic1\":null,\"bedroomspic2\":null,\"bedroomspic3\":null,\"bedroomspic4\":null,\"bathrooms\":\"1\",\"bathroom_1_name\":\"Bathroom\",\"bathroom_1_decoration\":\"3\",\"bathroom_1_furniture\":\"3.5\",\"bathroom_1_flooring\":\"3.5\",\"bathroom_1_lighting\":\"3\",\"bathroom_1_towelrail\":\"5\",\"bathroom_1_mirror\":\"5\",\"bathroom_1_shaverpoint\":\"5\",\"bathroom_1_wastebin\":\"5\",\"bathroom_1_bathmats\":\"5\",\"bathroom_1_toiletbrush\":\"5\",\"bathroom_1_showerhead\":\"5\",\"bathroomsTotal\":\"65\",\"bathroomsnotes\":\"The shower is in need of a big deep clean to get all the black marks off and a deep clean of all the tiles. A new toilet brush would be good.\",\"bathroomspic1\":null,\"bathroomspic2\":null,\"bathroomspic3\":null,\"bathroomspic4\":null,\"safetyfire\":\"5\",\"safetyfire_date\":\"2028-01-19\",\"safetyboiler\":\"n\\/a\",\"safetyboiler_date\":\"\",\"safetypat\":\"5\",\"safetypat_date\":\"2026-01-01\",\"safetyeicr\":\"5\",\"safetyeicr_date\":\"2026-05-27\",\"safetylegionella\":\"5\",\"safetylegionella_date\":\"2026-01-13\",\"safetypublicliability\":\"0\",\"safetypublicliability_date\":\"2025-05-10\",\"safetychimney\":\"0\",\"safetychimney_date\":\"2025-04-04\",\"safetyTotal\":\"\",\"safetyfirealarms\":\"5\",\"safetyco\":\"5\",\"safetyfireextinguishers\":\"5\",\"safetyfireblanket\":\"5\",\"safetyemergencylighting\":\"5\",\"safetyfireactionsign\":\"5\",\"safetybindcords\":\"n\\/a\",\"exitdoorkeylessescape\":\"5\",\"safetynotes\":\"Public liability insurance is needed.\",\"safetypic1\":null,\"safetypic2\":null,\"safetypic3\":null,\"safetypic4\":null,\"brand\":\"THC\",\"lastUpdate\":\"2025-10-27\",\"completeness\":\"100\"}', completeness = 100 WHERE id = 884;

"COMMIT"

"COMMIT";