Symfony Profiler

"COMMIT"

"COMMIT";

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 = '872944fc-1c48-4f58-b90a-913e4c706768' LIMIT 1;

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

UPDATE inspection SET date = '2025-11-04 12:16:15', data = '{\"uuid\":\"872944fc-1c48-4f58-b90a-913e4c706768\",\"version\":\"1\",\"date\":\"2025-11-04\",\"propname\":\"7 At the Beach\",\"totalScore\":\"77\",\"stars\":\"4\",\"extbuildappear\":\"3.5\",\"extparkfacility\":\"3\",\"extsiding\":\"4.5\",\"exteriorTotal\":\"73\",\"extpropertysign\":\"5\",\"extkeysafe\":\"5\",\"extemergencykeysafe\":\"5\",\"extlighting\":\"5\",\"extgates\":\"n\\/a\",\"extgardenfurniture\":\"5\",\"extbarbecue\":\"n\\/a\",\"extnotes\":\"Green and slimy\",\"extpic1\":null,\"extpic2\":null,\"extpic3\":null,\"extpic4\":null,\"generalinformationpack\":\"4\",\"generalwelcomepack\":\"4\",\"generalwifi\":\"4\",\"generalwifilogininfoandspeed\":\"36.51MBPS\",\"generalspaceandeaseofuse\":\"3.5\",\"generalaccessories\":\"3.5\",\"generalcleanliness\":\"4.5\",\"generalTotal\":\"78\",\"generalcot\":\"5\",\"generalhighchair\":\"0\",\"generalstairgate\":\"n\\/a\",\"generalvacuum\":\"5\",\"generaliron\":\"5\",\"generalwashingmachine\":\"5\",\"generaltumbledryer\":\"5\",\"generalnotes\":\"\",\"generalpic1\":null,\"generalpic2\":null,\"generalpic3\":null,\"generalpic4\":null,\"publicdecoration\":\"3.5\",\"publicfurniture\":\"4\",\"publicflooring\":\"4\",\"publiclighting\":\"4\",\"publicTotal\":\"78\",\"publiccurtains\":\"5\",\"publicdiningtable\":\"5\",\"publiccoffeetable\":\"5\",\"publiclamps\":\"5\",\"publictv\":\"5\",\"publicfireproofbin\":\"0\",\"publicnotes\":\"Perhaps renew scatter cushions \\r\\nPaintwork OK inevitable knocks in high traffic areas.\\r\\nCrack above living kitchen door\\r\\nRusty Hall radiator \",\"publicpic2\":null,\"publicpic3\":null,\"publicpic4\":null,\"kitchendecoration\":\"4\",\"kitchenfurniture\":\"4\",\"kitchenflooring\":\"4\",\"kitchenlighting\":\"4\",\"kitchenequipment\":\"4\",\"kitchencrockerycutleryglassware\":\"3.5\",\"kitchenpots\":\"3.5\",\"kitchenTotal\":\"77\",\"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\":\"We\'ve removed 2 trays and a chipped mug\\r\\n\",\"kitchenpic1\":null,\"kitchenpic2\":\"null\",\"kitchenpic3\":null,\"kitchenpic4\":null,\"bedrooms\":\"1\",\"bedroom_1_name\":\"Bedroom 1\",\"bedroom_1_decoration\":\"3\",\"bedroom_1_furniture\":\"3.5\",\"bedroom_1_flooring\":\"4\",\"bedroom_1_lighting\":\"3.5\",\"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\",\"bedroom_2_name\":\"Bedroom 2\",\"bedroom_2_decoration\":\"3\",\"bedroom_2_furniture\":\"3\",\"bedroom_2_flooring\":\"4\",\"bedroom_2_lighting\":\"3.5\",\"bedroom_2_beds\":\"4\",\"bedroom_2_bedding\":\"4\",\"bedroom_2_curtains\":\"5\",\"bedroom_2_duvets\":\"5\",\"bedroom_2_mattressprotector\":\"5\",\"bedroom_2_towelsprovided\":\"5\",\"bedroom_2_wardrobe\":\"5\",\"bedroom_2_bedsidetable\":\"5\",\"bedroom_2_lamps\":\"5\",\"bedroom_2_wastebins\":\"5\",\"bedroomsTotal\":\"73\",\"bedroomsnotes\":\"Not the most contemporary and welcoming as discussed before but generally in good order. \\r\\nBedside table tops quite marked as is the chest of drawers please advise if you would like us to obtain quotes to deal with the wear and tear.\\r\\nBlinds and radiator rusty would recommend these are replaced\",\"bedroomspic3\":null,\"bedroomspic4\":null,\"bathrooms\":\"1\",\"bathroom_1_name\":\"En suite 1\",\"bathroom_1_decoration\":\"4.5\",\"bathroom_1_furniture\":\"4.5\",\"bathroom_1_flooring\":\"4.5\",\"bathroom_1_lighting\":\"4.5\",\"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\",\"bathroom_2_name\":\"Bathroom 2\",\"bathroom_2_decoration\":\"4.5\",\"bathroom_2_furniture\":\"4\",\"bathroom_2_flooring\":\"4.5\",\"bathroom_2_lighting\":\"4\",\"bathroom_2_towelrail\":\"5\",\"bathroom_2_mirror\":\"5\",\"bathroom_2_shaverpoint\":\"5\",\"bathroom_2_wastebin\":\"5\",\"bathroom_2_bathmats\":\"5\",\"bathroom_2_toiletbrush\":\"5\",\"bathroom_2_showerhead\":\"5\",\"bathroomsTotal\":\"88\",\"bathroomsnotes\":\"Main shower room regroup around shower tray\",\"bathroomspic1\":null,\"bathroomspic2\":null,\"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\":\"5\",\"safetyfireextinguishers\":\"5\",\"safetyfireblanket\":\"5\",\"safetyemergencylighting\":\"5\",\"safetyfireactionsign\":\"0\",\"safetybindcords\":\"n\\/a\",\"exitdoorkeylessescape\":\"5\",\"safetynotes\":\"\",\"safetypic1\":null,\"safetypic2\":null,\"safetypic3\":null,\"safetypic4\":null,\"brand\":\"THC\",\"lastUpdate\":\"2025-11-04\",\"completeness\":\"100\",\"publicpic1\":\"17622556528511595905358011861105.jpg\",\"bedroomspic1\":\"17622560944385959589561491630210.jpg\",\"bedroomspic2\":\"17622561118281972731821248181631.jpg\"}' WHERE id = 906;

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

"START TRANSACTION"

"START TRANSACTION";