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

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 = '8e4cac68-a295-4422-a233-3cf004ff9409' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE inspection SET date = '2026-03-26 13:07:06', version = 39, data = '{\"uuid\":\"8e4cac68-a295-4422-a233-3cf004ff9409\",\"version\":\"39\",\"date\":\"2026-03-26\",\"propname\":\"Old Stables Cottage - OSTACO\",\"totalScore\":\"77\",\"stars\":\"4\",\"extbuildappear\":\"4\",\"extparkfacility\":\"4\",\"extsiding\":\"4\",\"exteriorTotal\":\"80\",\"extpropertysign\":\"5\",\"extkeysafe\":\"0\",\"extemergencykeysafe\":\"0\",\"extlighting\":\"5\",\"extgates\":\"5\",\"extgardenfurniture\":\"5\",\"extbarbecue\":\"n\\/a\",\"extnotes\":\"\",\"extpic1\":null,\"extpic2\":null,\"extpic3\":null,\"extpic4\":null,\"generalinformationpack\":\"3.5\",\"generalwelcomepack\":\"3.5\",\"generalwifi\":\"1\",\"generalwifilogininfoandspeed\":\"4.11 Mbps recorded on the speed test.\",\"generalspaceandeaseofuse\":\"4\",\"generalaccessories\":\"4\",\"generalcleanliness\":\"4\",\"generalTotal\":\"67\",\"generalcot\":\"0\",\"generalhighchair\":\"0\",\"generalstairgate\":\"n\\/a\",\"generalvacuum\":\"5\",\"generaliron\":\"5\",\"generalwashingmachine\":\"5\",\"generaltumbledryer\":\"5\",\"generalnotes\":\"\",\"generalpic1\":null,\"generalpic2\":null,\"generalpic3\":null,\"generalpic4\":null,\"publicdecoration\":\"4\",\"publicfurniture\":\"4\",\"publicflooring\":\"4\",\"publiclighting\":\"4\",\"publicTotal\":\"80\",\"publiccurtains\":\"5\",\"publicdiningtable\":\"5\",\"publiccoffeetable\":\"5\",\"publiclamps\":\"5\",\"publictv\":\"5\",\"publicfireproofbin\":\"0\",\"publicnotes\":\"\",\"publicpic1\":null,\"publicpic2\":null,\"publicpic3\":null,\"publicpic4\":null,\"kitchendecoration\":\"4\",\"kitchenfurniture\":\"4\",\"kitchenflooring\":\"4\",\"kitchenlighting\":\"4\",\"kitchenequipment\":\"4\",\"kitchencrockerycutleryglassware\":\"4\",\"kitchenpots\":\"4\",\"kitchenTotal\":\"80\",\"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\":\"5\",\"kitchennotes\":\"\",\"kitchenpic1\":null,\"kitchenpic2\":\"null\",\"kitchenpic3\":null,\"kitchenpic4\":null,\"bedrooms\":\"1\",\"bedroom_1_name\":\"Bedroom\",\"bedroom_1_decoration\":\"4\",\"bedroom_1_furniture\":\"4\",\"bedroom_1_flooring\":\"4\",\"bedroom_1_lighting\":\"4\",\"bedroom_1_beds\":\"4\",\"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\":\"80\",\"bedroomsnotes\":\"\",\"bedroomspic1\":null,\"bedroomspic2\":null,\"bedroomspic3\":null,\"bedroomspic4\":null,\"bathrooms\":\"1\",\"bathroom_1_name\":\"Bathroom\",\"bathroom_1_decoration\":\"4\",\"bathroom_1_furniture\":\"4\",\"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\":\"80\",\"bathroomsnotes\":\"Please clean or replace shower head.\",\"bathroomspic1\":null,\"bathroomspic2\":null,\"bathroomspic3\":null,\"bathroomspic4\":null,\"safetyfire\":\"5\",\"safetyfire_date\":\"2023-08-12\",\"safetyboiler\":\"5\",\"safetyboiler_date\":\"2025-03-13\",\"safetypat\":\"5\",\"safetypat_date\":\"2025-10-04\",\"safetyeicr\":\"5\",\"safetyeicr_date\":\"2024-01-20\",\"safetylegionella\":\"5\",\"safetylegionella_date\":\"2025-04-25\",\"safetypublicliability\":\"5\",\"safetypublicliability_date\":\"2025-08-19\",\"safetychimney\":\"5\",\"safetychimney_date\":\"2026-02-21\",\"safetyTotal\":\"\",\"safetyfirealarms\":\"5\",\"safetyco\":\"5\",\"safetyfireextinguishers\":\"5\",\"safetyfireblanket\":\"5\",\"safetyemergencylighting\":\"5\",\"safetyfireactionsign\":\"0\",\"safetybindcords\":\"0\",\"exitdoorkeylessescape\":\"0\",\"safetynotes\":\"Recommend installing keyless locks to exit doors as per your Fire Risk Assessment.\\r\\n\\r\\nHealth & Safety documents - are all in date, thank you. \\r\\n\\r\\nOwners have just fitted a new outside boiler with all the certification. This will still be serviced annually, but won\'t need a service certificate until March 2027.\",\"safetypic1\":null,\"safetypic2\":null,\"safetypic3\":null,\"safetypic4\":null,\"brand\":\"THC\",\"lastUpdate\":\"2026-04-02\",\"completeness\":\"100\"}' WHERE id = 813;

"COMMIT"

"COMMIT";