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 = '1dc83a39-47f0-4dff-9ea2-f1aa8e49c903' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE inspection SET date = '2025-09-24 15:16:38', version = 76, data = '{\"uuid\":\"1dc83a39-47f0-4dff-9ea2-f1aa8e49c903\",\"version\":\"76\",\"date\":\"2025-09-24\",\"propname\":\"5C Periwinkle\",\"totalScore\":\"67\",\"stars\":\"3\",\"extbuildappear\":\"3\",\"extparkfacility\":\"3\",\"extsiding\":\"4\",\"exteriorTotal\":\"67\",\"extpropertysign\":\"5\",\"extkeysafe\":\"5\",\"extemergencykeysafe\":\"0\",\"extlighting\":\"5\",\"extgates\":\"n\\/a\",\"extgardenfurniture\":\"5\",\"extbarbecue\":\"n\\/a\",\"extnotes\":\"Could do with getting rid of the second key box so not to confused guests. Outside could do with a good wash. (outdoor furniture will be re painted like last year for you.)\",\"extpic1\":null,\"extpic2\":null,\"extpic3\":null,\"extpic4\":null,\"generalinformationpack\":\"4.5\",\"generalwelcomepack\":\"4\",\"generalwifi\":\"3\",\"generalwifilogininfoandspeed\":\"15.68 mbps\",\"generalspaceandeaseofuse\":\"3\",\"generalaccessories\":\"4\",\"generalcleanliness\":\"4.5\",\"generalTotal\":\"77\",\"generalcot\":\"0\",\"generalhighchair\":\"0\",\"generalstairgate\":\"n\\/a\",\"generalvacuum\":\"0\",\"generaliron\":\"0\",\"generalwashingmachine\":\"5\",\"generaltumbledryer\":\"5\",\"generalnotes\":\"combination washer and dryer.\\r\\nAs previously suggested before, a drop leaf table would help with living space.\\r\\nCurtains are all needing to be replaced.\\r\\n3 pillows re unacceptable and need replacing before the season starts.\",\"generalpic1\":null,\"generalpic2\":null,\"generalpic3\":null,\"generalpic4\":null,\"publicdecoration\":\"3\",\"publicfurniture\":\"2\",\"publicflooring\":\"4\",\"publiclighting\":\"4.5\",\"publicTotal\":\"68\",\"publiccurtains\":\"5\",\"publicdiningtable\":\"5\",\"publiccoffeetable\":\"5\",\"publiclamps\":\"5\",\"publictv\":\"5\",\"publicfireproofbin\":\"0\",\"publicnotes\":\"Dining chairs need an extremely deep clean on the cushions or replacing. New table cloth is needed and a good repaint on the walls and ceiling. Curtain poles have begun to come away from the walls so needs sorting.\",\"publicpic1\":null,\"publicpic2\":null,\"publicpic3\":null,\"publicpic4\":null,\"kitchendecoration\":\"3\",\"kitchenfurniture\":\"3\",\"kitchenflooring\":\"4\",\"kitchenlighting\":\"4\",\"kitchenequipment\":\"2\",\"kitchencrockerycutleryglassware\":\"4\",\"kitchenpots\":\"4\",\"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\":\"0\",\"kitchenwashingupbowl\":\"5\",\"kitchencleaningmaterials\":\"5\",\"kitchennotes\":\"Salt and pepper grinder needed. The kitchen is well equipped. The fridge door and shelf need replacing, a piece of wood to keep it together is not a good sight and unhygienic, and the shelf is unsafe. Cooker hood filter needs replacing\\/ cleaning \",\"kitchenpic1\":null,\"kitchenpic2\":\"null\",\"kitchenpic3\":null,\"kitchenpic4\":null,\"bedrooms\":\"1\",\"bedroom_1_name\":\"Bedrooms \",\"bedroom_1_decoration\":\"3\",\"bedroom_1_furniture\":\"2\",\"bedroom_1_flooring\":\"4.5\",\"bedroom_1_lighting\":\"3.5\",\"bedroom_1_beds\":\"2\",\"bedroom_1_bedding\":\"4\",\"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\":\"63\",\"bedroomsnotes\":\"The bedrooms could do with a coat of paint after a busy season. The mattress in the master needs replacing. both bedroom curtains need the lining replacing or new ones. (these where cleaned this year but still have mould stains.) Both lamps in the master bedroom are coated in mould and need replacing. The headboard in the master needs replacing. It cannot be tightened and may end up being dangerous. The blind in the single room also needs replacing due to mould.\",\"bedroomspic1\":null,\"bedroomspic2\":null,\"bedroomspic3\":null,\"bedroomspic4\":null,\"bathrooms\":\"1\",\"bathroom_1_name\":\"Bathroom 1\",\"bathroom_1_decoration\":\"2\",\"bathroom_1_furniture\":\"2\",\"bathroom_1_flooring\":\"4\",\"bathroom_1_lighting\":\"4\",\"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 bathroom as a whole looks very tired. This needs a deep clean to get rid of the mould that is starting to come up on the walls. Both taps on the sink are now loose and a new plug hole for this would improve the look. The rail above the bath needs replacing due to rust. The wood cladding around the bath is now starting to go black on the edges so needs repainting or replacing. The small mirror cabinet in the bathroom should be removed (not needed, starting to rust inside.) blinds need replacing due to the mould. 2 toilet brushes seems a bit much.\",\"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-09-24\",\"safetyeicr\":\"5\",\"safetyeicr_date\":\"2025-12-12\",\"safetylegionella\":\"5\",\"safetylegionella_date\":\"2026-01-13\",\"safetypublicliability\":\"0\",\"safetypublicliability_date\":\"2025-04-16\",\"safetychimney\":\"n\\/a\",\"safetychimney_date\":\"\",\"safetyTotal\":\"\",\"safetyfirealarms\":\"5\",\"safetyco\":\"n\\/a\",\"safetyfireextinguishers\":\"5\",\"safetyfireblanket\":\"5\",\"safetyemergencylighting\":\"5\",\"safetyfireactionsign\":\"5\",\"safetybindcords\":\"5\",\"exitdoorkeylessescape\":\"5\",\"safetynotes\":\"A new copy of public liability please. EICR is due in December\",\"safetypic1\":null,\"safetypic2\":null,\"safetypic3\":null,\"safetypic4\":null,\"brand\":\"THC\",\"lastUpdate\":\"2025-09-29\",\"completeness\":\"100\"}', completeness = 100 WHERE id = 847;

"COMMIT"

"COMMIT";