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 = 22;

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 = 'f592f3bd-5a33-420e-8ec4-2ab2850e83af' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE inspection SET date = '2025-09-29 15:13:54', version = 67, total_score = 58, data = '{\"uuid\":\"f592f3bd-5a33-420e-8ec4-2ab2850e83af\",\"version\":\"67\",\"date\":\"2025-09-29\",\"propname\":\"26 The Crags\",\"totalScore\":\"58\",\"stars\":\"2\",\"extbuildappear\":\"3\",\"extparkfacility\":\"3.5\",\"extsiding\":\"4\",\"exteriorTotal\":\"70\",\"extpropertysign\":\"5\",\"extkeysafe\":\"5\",\"extemergencykeysafe\":\"0\",\"extlighting\":\"5\",\"extgates\":\"n\\/a\",\"extgardenfurniture\":\"5\",\"extbarbecue\":\"5\",\"extnotes\":\"BBQ metal trays need replacing and the outdoor chairs and table could do with replacing as well.\\r\\nPatio needs cleaning, and it would be worth asking the estate if the gardeners could do a couple of hours to tidy the back.\",\"extpic1\":null,\"extpic2\":null,\"extpic3\":null,\"extpic4\":null,\"generalinformationpack\":\"4\",\"generalwelcomepack\":\"4\",\"generalwifi\":\"3\",\"generalwifilogininfoandspeed\":\"19.98\",\"generalspaceandeaseofuse\":\"3.5\",\"generalaccessories\":\"3\",\"generalcleanliness\":\"3\",\"generalTotal\":\"68\",\"generalcot\":\"0\",\"generalhighchair\":\"0\",\"generalstairgate\":\"0\",\"generalvacuum\":\"5\",\"generaliron\":\"5\",\"generalwashingmachine\":\"5\",\"generaltumbledryer\":\"5\",\"generalnotes\":\"Cleanliness has dropped significantly, due to carpets and curtains being in poor condition.\",\"generalpic1\":null,\"generalpic2\":null,\"generalpic3\":null,\"generalpic4\":null,\"publicdecoration\":\"3\",\"publicfurniture\":\"2\",\"publicflooring\":\"3\",\"publiclighting\":\"2\",\"publicTotal\":\"50\",\"publiccurtains\":\"5\",\"publicdiningtable\":\"5\",\"publiccoffeetable\":\"5\",\"publiclamps\":\"5\",\"publictv\":\"5\",\"publicfireproofbin\":\"0\",\"publicnotes\":\"A repaint throughout would be of use. All carpets need cleaning, or replacing. The flooring in the dining area is nice, but showing its age. Lights in the living area need taking down and emptying of dead flies. Sofas either need replacing or new covers fitted. Table and chairs are in a location guests don\'t like, and it doesn\'t seat 6. the top window needs to be looked at as the wood looks like its rotting. The bookshelf needs a repaint\",\"publicpic1\":null,\"publicpic2\":null,\"publicpic3\":null,\"publicpic4\":null,\"kitchendecoration\":\"3\",\"kitchenfurniture\":\"4.5\",\"kitchenflooring\":\"3.5\",\"kitchenlighting\":\"3\",\"kitchenequipment\":\"4\",\"kitchencrockerycutleryglassware\":\"3\",\"kitchenpots\":\"3\",\"kitchenTotal\":\"69\",\"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\":\"5\",\"kitchensaltandpepper\":\"5\",\"kitchenwashingupbowl\":\"5\",\"kitchencleaningmaterials\":\"0\",\"kitchennotes\":\"New table mats and coasters are needed. The kickboards in the kitchen need replacing and a paint on the wall next to the cooker. New cutlery to match the high spec of the plates would be good.\",\"kitchenpic1\":null,\"kitchenpic2\":\"null\",\"kitchenpic3\":null,\"kitchenpic4\":null,\"bedrooms\":\"1\",\"bedroom_1_name\":\"Bedrooms\",\"bedroom_1_decoration\":\"1\",\"bedroom_1_furniture\":\"1\",\"bedroom_1_flooring\":\"1\",\"bedroom_1_lighting\":\"2\",\"bedroom_1_beds\":\"2\",\"bedroom_1_bedding\":\"3.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\":\"35\",\"bedroomsnotes\":\"The bedrooms need a complete refresh. The bed frames are wobbly and all the headboards move. The wardrobes and drawers are all wobbly, and the carpets desperately need cleaning at least. The bedside lamps all need replacing. The lighting in the upstairs bedroom isn\'t great. \",\"bedroomspic1\":null,\"bedroomspic2\":null,\"bedroomspic3\":null,\"bedroomspic4\":null,\"bathrooms\":\"1\",\"bathroom_1_name\":\"Bathrooms \",\"bathroom_1_decoration\":\"3\",\"bathroom_1_furniture\":\"3\",\"bathroom_1_flooring\":\"3\",\"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\":\"60\",\"bathroomsnotes\":\"The bathrooms are light. Both bathrooms needs a new mirror, and some silicone needs replacing\",\"bathroomspic1\":null,\"bathroomspic2\":null,\"bathroomspic3\":null,\"bathroomspic4\":null,\"safetyfire\":\"5\",\"safetyfire_date\":\"2030-03-12\",\"safetyboiler\":\"n\\/a\",\"safetyboiler_date\":\"\",\"safetypat\":\"5\",\"safetypat_date\":\"2026-02-22\",\"safetyeicr\":\"5\",\"safetyeicr_date\":\"2026-04-16\",\"safetylegionella\":\"5\",\"safetylegionella_date\":\"2026-01-13\",\"safetypublicliability\":\"5\",\"safetypublicliability_date\":\"2026-03-30\",\"safetychimney\":\"n\\/a\",\"safetychimney_date\":\"\",\"safetyTotal\":\"\",\"safetyfirealarms\":\"5\",\"safetyco\":\"n\\/a\",\"safetyfireextinguishers\":\"5\",\"safetyfireblanket\":\"5\",\"safetyemergencylighting\":\"5\",\"safetyfireactionsign\":\"5\",\"safetybindcords\":\"n\\/a\",\"exitdoorkeylessescape\":\"5\",\"safetynotes\":\"EICR is due in April, would be worth sorting out after Christmas, to avoid it clashing with bookings.\",\"safetypic1\":null,\"safetypic2\":null,\"safetypic3\":null,\"safetypic4\":null,\"brand\":\"THC\",\"lastUpdate\":\"2025-11-03\",\"completeness\":\"100\"}', completeness = 100 WHERE id = 851;

"COMMIT"

"COMMIT";