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 = 'b300ed18-7b42-4f10-bfa6-7d1da185ee91' LIMIT 1;

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

UPDATE inspection SET date = '2025-08-06 10:15:20', version = 2, data = '{\"uuid\":\"b300ed18-7b42-4f10-bfa6-7d1da185ee91\",\"version\":\"2\",\"date\":\"2025-08-06\",\"propname\":\"5 Island Point\",\"totalScore\":\"77\",\"stars\":\"4\",\"extbuildappear\":\"3.5\",\"extparkfacility\":\"4\",\"extsiding\":\"4\",\"exteriorTotal\":\"77\",\"extpropertysign\":\"5\",\"extkeysafe\":\"5\",\"extemergencykeysafe\":\"0\",\"extlighting\":\"5\",\"extgates\":\"n\\/a\",\"extgardenfurniture\":\"5\",\"extbarbecue\":\"0\",\"extnotes\":\"outside plastic table and chairs\",\"extpic1\":null,\"extpic2\":null,\"extpic3\":null,\"extpic4\":null,\"generalinformationpack\":\"4\",\"generalwelcomepack\":\"4\",\"generalwifi\":\"1\",\"generalwifilogininfoandspeed\":\"not working\",\"generalspaceandeaseofuse\":\"4\",\"generalaccessories\":\"4\",\"generalcleanliness\":\"4\",\"generalTotal\":\"70\",\"generalcot\":\"0\",\"generalhighchair\":\"0\",\"generalstairgate\":\"n\\/a\",\"generalvacuum\":\"5\",\"generaliron\":\"5\",\"generalwashingmachine\":\"0\",\"generaltumbledryer\":\"0\",\"generalnotes\":\"\",\"generalpic1\":null,\"generalpic2\":null,\"generalpic3\":null,\"generalpic4\":null,\"publicdecoration\":\"4\",\"publicfurniture\":\"4\",\"publicflooring\":\"4.5\",\"publiclighting\":\"4\",\"publicTotal\":\"83\",\"publiccurtains\":\"5\",\"publicdiningtable\":\"5\",\"publiccoffeetable\":\"5\",\"publiclamps\":\"5\",\"publictv\":\"5\",\"publicfireproofbin\":\"0\",\"publicnotes\":\"\",\"publicpic1\":null,\"publicpic2\":null,\"publicpic3\":null,\"publicpic4\":null,\"kitchendecoration\":\"3\",\"kitchenfurniture\":\"3\",\"kitchenflooring\":\"3.5\",\"kitchenlighting\":\"4\",\"kitchenequipment\":\"4\",\"kitchencrockerycutleryglassware\":\"4\",\"kitchenpots\":\"3.5\",\"kitchenTotal\":\"71\",\"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\":\"Provide kitchen spray. Consider replacing utensils and baking trays \",\"kitchenpic3\":null,\"kitchenpic4\":null,\"bedrooms\":\"1\",\"bedroom_1_name\":\"Bedroom 1\",\"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\":\"0\",\"bedroomsTotal\":\"80\",\"bedroomsnotes\":\"hairdryer in the main bedroom. Replace plastic hangers. \",\"bedroomspic2\":null,\"bedroomspic3\":null,\"bedroomspic4\":null,\"bathrooms\":\"1\",\"bathroom_1_name\":\"Bathroom 1\",\"bathroom_1_decoration\":\"4\",\"bathroom_1_furniture\":\"4.5\",\"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\":\"83\",\"bathroomsnotes\":\"Really nice bathroom. Fluffy toilet mat\",\"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\":\"0\",\"safetyco\":\"n\\/a\",\"safetyfireextinguishers\":\"0\",\"safetyfireblanket\":\"0\",\"safetyemergencylighting\":\"0\",\"safetyfireactionsign\":\"5\",\"safetybindcords\":\"n\\/a\",\"exitdoorkeylessescape\":\"5\",\"safetynotes\":\"one smoke alarm in the hallway which doesn\'t seem to work. \",\"safetypic1\":null,\"safetypic2\":null,\"safetypic3\":null,\"safetypic4\":null,\"brand\":\"NFC\",\"lastUpdate\":\"2025-08-06\",\"completeness\":\"100\",\"kitchenpic1\":\"WIN_20250806_10_41_12_Pro.jpg\",\"kitchenpic2\":\"WIN_20250806_10_40_56_Pro.jpg\",\"bedroomspic1\":\"WIN_20250806_10_43_26_Pro.jpg\",\"bathroomspic1\":\"WIN_20250806_10_47_07_Pro.jpg\",\"bathroomspic2\":\"WIN_20250806_10_47_30_Pro.jpg\"}' WHERE id = 840;

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;

"START TRANSACTION"

"START TRANSACTION";