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

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 = '53e39c05-03eb-494c-86e1-e4c0d69655c9' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE inspection SET date = '2025-06-10 10:50:40', version = 2, total_score = 76, data = '{\"uuid\":\"53e39c05-03eb-494c-86e1-e4c0d69655c9\",\"version\":\"2\",\"date\":\"2025-06-10\",\"propname\":\"Cribb Cottage\",\"totalScore\":\"76\",\"stars\":\"4\",\"extbuildappear\":\"4\",\"extparkfacility\":\"3.5\",\"extsiding\":\"4.5\",\"exteriorTotal\":\"80\",\"extpropertysign\":\"5\",\"extkeysafe\":\"5\",\"extemergencykeysafe\":\"0\",\"extlighting\":\"5\",\"extgates\":\"0\",\"extgardenfurniture\":\"5\",\"extbarbecue\":\"0\",\"extnotes\":\"Lovely views across Woodside. Make sure the outside windows and ledges are clean. \",\"extpic1\":null,\"extpic2\":null,\"extpic3\":null,\"extpic4\":null,\"generalinformationpack\":\"4\",\"generalwelcomepack\":\"4\",\"generalwifi\":\"2\",\"generalwifilogininfoandspeed\":\"8 mbps\",\"generalspaceandeaseofuse\":\"3.5\",\"generalaccessories\":\"4\",\"generalcleanliness\":\"4.5\",\"generalTotal\":\"73\",\"generalcot\":\"0\",\"generalhighchair\":\"0\",\"generalstairgate\":\"0\",\"generalvacuum\":\"5\",\"generaliron\":\"5\",\"generalwashingmachine\":\"5\",\"generaltumbledryer\":\"0\",\"generalnotes\":\"Make sure cleaning items are washed after use. The ironing board needs to be replaced. \",\"generalpic1\":\"WIN_20250610_16_29_33_Pro.jpg\",\"generalpic2\":\"WIN_20250610_16_31_07_Pro.jpg\",\"generalpic3\":null,\"generalpic4\":null,\"publicdecoration\":\"4\",\"publicfurniture\":\"3.5\",\"publicflooring\":\"3.5\",\"publiclighting\":\"4\",\"publicTotal\":\"75\",\"publiccurtains\":\"5\",\"publicdiningtable\":\"5\",\"publiccoffeetable\":\"5\",\"publiclamps\":\"5\",\"publictv\":\"5\",\"publicfireproofbin\":\"\",\"publicnotes\":\"Good selection of books, games and puzzles. A small stereo for guests to use. \",\"publicpic1\":null,\"publicpic2\":null,\"publicpic3\":null,\"publicpic4\":null,\"kitchendecoration\":\"3.5\",\"kitchenfurniture\":\"3.5\",\"kitchenflooring\":\"3.5\",\"kitchenlighting\":\"4\",\"kitchenequipment\":\"4\",\"kitchencrockerycutleryglassware\":\"4\",\"kitchenpots\":\"4\",\"kitchenTotal\":\"76\",\"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\":\"5\",\"kitchencleaningmaterials\":\"5\",\"kitchennotes\":\"The kettle needs to be descaled. Make sure the toasters crumb tray is cleaned. Slow cooker provided along with a cafetiere. Make sure the oven is clean. Add table mats to protect the dining table as I couldn\'t see any.\",\"kitchenpic1\":\"WIN_20250610_16_37_03_Pro.jpg\",\"kitchenpic2\":\"WIN_20250610_16_40_05_Pro.jpg\",\"kitchenpic3\":null,\"kitchenpic4\":null,\"bedrooms\":\"1\",\"bedroom_1_name\":\"Bedroom 1\",\"bedroom_1_decoration\":\"4\",\"bedroom_1_furniture\":\"3.5\",\"bedroom_1_flooring\":\"3.5\",\"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\":\"77\",\"bedroomsnotes\":\"Hairdryer provided. Remove the ladder from the wardrobe. \",\"bedroomspic1\":\"WIN_20250610_16_18_22_Pro.jpg\",\"bedroomspic2\":null,\"bedroomspic3\":null,\"bedroomspic4\":null,\"bathrooms\":\"1\",\"bathroom_1_name\":\"Bathroom 1\",\"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\":\"0\",\"bathroom_1_wastebin\":\"5\",\"bathroom_1_bathmats\":\"5\",\"bathroom_1_toiletbrush\":\"5\",\"bathroom_1_showerhead\":\"5\",\"bathroomsTotal\":\"80\",\"bathroomsnotes\":\"The shower head needs to be descaled. We recommend just pump soap for the basin.\",\"bathroomspic1\":\"WIN_20250610_16_23_43_Pro.jpg\",\"bathroomspic2\":\"WIN_20250610_16_21_09_Pro.jpg\",\"bathroomspic3\":null,\"bathroomspic4\":null,\"safetyfire\":\"5\",\"safetyfire_date\":\"\",\"safetyboiler\":\"5\",\"safetyboiler_date\":\"\",\"safetypat\":\"5\",\"safetypat_date\":\"\",\"safetyeicr\":\"5\",\"safetyeicr_date\":\"\",\"safetylegionella\":\"5\",\"safetylegionella_date\":\"\",\"safetypublicliability\":\"5\",\"safetypublicliability_date\":\"\",\"safetychimney\":\"n\\/a\",\"safetychimney_date\":\"\",\"safetyTotal\":\"\",\"safetyfirealarms\":\"5\",\"safetyco\":\"0\",\"safetyfireextinguishers\":\"0\",\"safetyfireblanket\":\"0\",\"safetyemergencylighting\":\"5\",\"safetyfireactionsign\":\"0\",\"safetybindcords\":\"0\",\"exitdoorkeylessescape\":\"0\",\"safetynotes\":\"Heat alarm in the kitchen and a smoke detector in middle landing. I couldn\'t see one in the attic bedroom, we would definitely recommend adding one.  Make sure there is a fire blanket in the kitchen either placed on the wall or on a hook so it is visible to guests. The blind cords look like they have breakers on them, please confirm. Carbon monoxide detector in the boiler cupboard which is interconnected. Make sure there is a carbon monoxide detector close to the gas hob as I couldn\'t see one.  We will take the fire notices to the property as these do need to be displayed.\",\"safetypic1\":\"WIN_20250610_16_15_18_Pro.jpg\",\"safetypic2\":null,\"safetypic3\":null,\"safetypic4\":null,\"brand\":\"NFC\",\"lastUpdate\":\"2025-06-10\",\"completeness\":\"100\"}' WHERE id = 833;

"COMMIT"

"COMMIT";