Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.roles AS roles_3,
  t0.status AS status_4,
  t0.name AS name_5,
  t0.email_address_for_confirmation AS email_address_for_confirmation_6,
  t0.show_in_reports AS show_in_reports_7
FROM
  api_user t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.roles AS roles_3, t0.status AS status_4, t0.name AS name_5, t0.email_address_for_confirmation AS email_address_for_confirmation_6, t0.show_in_reports AS show_in_reports_7 FROM api_user t0 WHERE t0.api_key = 'c69384e217208f1c3e4dc7b4233bddfe' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.roles AS roles_3,
  t0.status AS status_4,
  t0.name AS name_5,
  t0.email_address_for_confirmation AS email_address_for_confirmation_6,
  t0.show_in_reports AS show_in_reports_7
FROM
  api_user t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.roles AS roles_3, t0.status AS status_4, t0.name AS name_5, t0.email_address_for_confirmation AS email_address_for_confirmation_6, t0.show_in_reports AS show_in_reports_7 FROM api_user t0 WHERE t0.api_key = 'c69384e217208f1c3e4dc7b4233bddfe' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO api_log (
  subject, reference, payload, route,
  sender, response_code, created_at_timestamp,
  updated_at_timestamp
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO api_log (subject, reference, payload, route, sender, response_code, created_at_timestamp, updated_at_timestamp) VALUES (NULL, NULL, '{\"fullName\":\"Dupe Check\",\"source\":\"partner_portal\",\"contact\":{\"telephone\":\"07700160211\"},\"address\":{\"lines\":null,\"town\":\"Leeds\",\"postcode\":\"LS1 1AA\"},\"metadata\":{\"origin\":\"partner-portal\",\"submitted_by_portal_user\":\"manager@portal.test\",\"submitted_by_portal_user_id\":\"ca7fac99-b21d-4459-8e50-b07fd8bc9e44\",\"partner_name\":\"Northern Mobility Ltd\",\"partner_id\":\"c677706a-4f66-4277-8a8b-bada80b9b241\",\"store_id\":\"86628f28-ffb4-4ed3-9c1c-469cb102f2be\",\"store_name\":\"Manchester Central\"}}', '/api/sales-leads', 'Partner Portal', NULL, 1786617131, NULL);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.requirements AS requirements_1,
  p0_.source AS source_2,
  p0_.stairlift_condition AS stairlift_condition_3,
  p0_.staircase AS staircase_4,
  p0_.external_id AS external_id_5,
  p0_.external_distribution_id AS external_distribution_id_6,
  p0_.lead_type AS lead_type_7,
  p0_.extended_warranty AS extended_warranty_8,
  p0_.other_reason AS other_reason_9,
  p0_.third_dead_reason AS third_dead_reason_10,
  p0_.sub_dead_reason AS sub_dead_reason_11,
  p0_.status AS status_12,
  p0_.created_at_timestamp AS created_at_timestamp_13,
  p0_.updated_at_timestamp AS updated_at_timestamp_14,
  p0_.metadata AS metadata_15,
  p0_.customer_id AS customer_id_16,
  p0_.brand_id AS brand_id_17,
  p0_.api_user_id AS api_user_id_18,
  p0_.assigned_user_id AS assigned_user_id_19
FROM
  project p0_
  LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id
WHERE
  c1_.contact_number LIKE ?
  AND p0_.created_at_timestamp >= ?
  AND (
    p0_.status = ?
    OR p0_.status = ?
  )
ORDER BY
  p0_.created_at_timestamp DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.requirements AS requirements_1, p0_.source AS source_2, p0_.stairlift_condition AS stairlift_condition_3, p0_.staircase AS staircase_4, p0_.external_id AS external_id_5, p0_.external_distribution_id AS external_distribution_id_6, p0_.lead_type AS lead_type_7, p0_.extended_warranty AS extended_warranty_8, p0_.other_reason AS other_reason_9, p0_.third_dead_reason AS third_dead_reason_10, p0_.sub_dead_reason AS sub_dead_reason_11, p0_.status AS status_12, p0_.created_at_timestamp AS created_at_timestamp_13, p0_.updated_at_timestamp AS updated_at_timestamp_14, p0_.metadata AS metadata_15, p0_.customer_id AS customer_id_16, p0_.brand_id AS brand_id_17, p0_.api_user_id AS api_user_id_18, p0_.assigned_user_id AS assigned_user_id_19 FROM project p0_ LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id WHERE c1_.contact_number LIKE '%07700160211' AND p0_.created_at_timestamp >= 1783987200 AND (p0_.status = 'unassigned' OR p0_.status = 'lead') ORDER BY p0_.created_at_timestamp DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.roles AS roles_3,
  t0.status AS status_4,
  t0.name AS name_5,
  t0.email_address_for_confirmation AS email_address_for_confirmation_6,
  t0.show_in_reports AS show_in_reports_7
FROM
  api_user t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.roles AS roles_3, t0.status AS status_4, t0.name AS name_5, t0.email_address_for_confirmation AS email_address_for_confirmation_6, t0.show_in_reports AS show_in_reports_7 FROM api_user t0 WHERE t0.api_key = 'c69384e217208f1c3e4dc7b4233bddfe' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO customer (
  name, additional_name, alternative_contact_number,
  stripe_id, address_lines, address_town,
  address_postcode, address_county,
  address_country, created_at_timestamp,
  updated_at_timestamp, contact_number,
  e164_contact_number, email_address,
  latitude, longitude, display_id,
  created_by_user_id, last_updated_by_user_id,
  xero_guid_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO customer (name, additional_name, alternative_contact_number, stripe_id, address_lines, address_town, address_postcode, address_county, address_country, created_at_timestamp, updated_at_timestamp, contact_number, e164_contact_number, email_address, latitude, longitude, display_id, created_by_user_id, last_updated_by_user_id, xero_guid_id) VALUES ('Dupe Check', NULL, NULL, NULL, NULL, 'Leeds', 'LS1 1AA', NULL, NULL, 1786617132, NULL, '07700160211', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO project (
  requirements, source, stairlift_condition,
  staircase, external_id, external_distribution_id,
  lead_type, extended_warranty, other_reason,
  third_dead_reason, sub_dead_reason,
  status, created_at_timestamp, updated_at_timestamp,
  metadata, customer_id, brand_id,
  api_user_id, assigned_user_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO project (requirements, source, stairlift_condition, staircase, external_id, external_distribution_id, lead_type, extended_warranty, other_reason, third_dead_reason, sub_dead_reason, status, created_at_timestamp, updated_at_timestamp, metadata, customer_id, brand_id, api_user_id, assigned_user_id) VALUES ('unknown', 'partner_portal', 'unknown', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unassigned', 1786617132, NULL, '{\"origin\":\"partner-portal\",\"submitted_by_portal_user\":\"manager@portal.test\",\"submitted_by_portal_user_id\":\"ca7fac99-b21d-4459-8e50-b07fd8bc9e44\",\"partner_name\":\"Northern Mobility Ltd\",\"partner_id\":\"c677706a-4f66-4277-8a8b-bada80b9b241\",\"store_id\":\"86628f28-ffb4-4ed3-9c1c-469cb102f2be\",\"store_name\":\"Manchester Central\"}', 24043, NULL, 20, NULL);

INSERT INTO project_note (
  is_pinned, anniversary_category,
  is_deleted, deleted_at_timestamp,
  body, category, completed_at_timestamp,
  created_at_timestamp, updated_at_timestamp,
  due_at_timestamp, project_id, deleted_by_user_id,
  assigned_user_id, created_by_user_id,
  last_updated_by_user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO project_note (is_pinned, anniversary_category, is_deleted, deleted_at_timestamp, body, category, completed_at_timestamp, created_at_timestamp, updated_at_timestamp, due_at_timestamp, project_id, deleted_by_user_id, assigned_user_id, created_by_user_id, last_updated_by_user_id) VALUES (0, NULL, 0, NULL, 'Give this person a callback!', NULL, NULL, 1786617132, NULL, 1786579200, 19918, NULL, NULL, NULL, NULL);

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

UPDATE
  customer
SET
  display_id = ?,
  updated_at_timestamp = ?
WHERE
  id = ?

UPDATE customer SET display_id = 'C-24043', updated_at_timestamp = 1786617132 WHERE id = 24043;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  api_log
SET
  subject = ?,
  reference = ?,
  response_code = ?,
  updated_at_timestamp = ?
WHERE
  id = ?

UPDATE api_log SET subject = 'App\\Entity\\Project', reference = 19918, response_code = 201, updated_at_timestamp = 1786617132 WHERE id = 12679;

UPDATE
  customer
SET
  latitude = ?,
  longitude = ?
WHERE
  id = ?

UPDATE customer SET latitude = 21.0110559, longitude = 105.7927458 WHERE id = 24043;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:50:\\\"App\\\\Message\\\\Email\\\\SuccessfulApiRequestEmailMessage\\\":3:{s:59:\\\"\\0App\\\\Message\\\\Email\\\\SuccessfulApiRequestEmailMessage\\0toEmail\\\";s:36:\\\"partnerportal@seniorstairlifts.co.uk\\\";s:64:\\\"\\0App\\\\Message\\\\Email\\\\SuccessfulApiRequestEmailMessage\\0customerName\\\";s:10:\\\"Dupe Check\\\";s:61:\\\"\\0App\\\\Message\\\\Email\\\\SuccessfulApiRequestEmailMessage\\0timestamp\\\";i:1786617132;}}', '[]', 'default', '2026-08-13 10:32:12', '2026-08-13 10:32:12');

"COMMIT"

"COMMIT";