Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.mobile_number AS mobile_number_7,
  t0.manage_quote AS manage_quote_8,
  t0.manage_file_deletion AS manage_file_deletion_9,
  t0.manage_export AS manage_export_10,
  t0.manage_export_limited AS manage_export_limited_11,
  t0.sales_department AS sales_department_12,
  t0.last_activity_timestamp AS last_activity_timestamp_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.hex_colour AS hex_colour_15
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.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = 83;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  last_activity_timestamp = ?
WHERE
  id = ?

UPDATE user SET last_activity_timestamp = 1782390464 WHERE id = 83;

"COMMIT"

"COMMIT";

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  credit_note c0_
  LEFT JOIN invoice i1_ ON c0_.invoice_id = i1_.id
  LEFT JOIN project p2_ ON i1_.project_id = p2_.id
  LEFT JOIN customer c3_ ON p2_.customer_id = c3_.id
  LEFT JOIN quote q4_ ON i1_.id = q4_.invoice_id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM credit_note c0_ LEFT JOIN invoice i1_ ON c0_.invoice_id = i1_.id LEFT JOIN project p2_ ON i1_.project_id = p2_.id LEFT JOIN customer c3_ ON p2_.customer_id = c3_.id LEFT JOIN quote q4_ ON i1_.id = q4_.invoice_id;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.created_at_timestamp AS created_at_timestamp_1
FROM
  credit_note c0_
  LEFT JOIN invoice i1_ ON c0_.invoice_id = i1_.id
  LEFT JOIN project p2_ ON i1_.project_id = p2_.id
  LEFT JOIN customer c3_ ON p2_.customer_id = c3_.id
  LEFT JOIN quote q4_ ON i1_.id = q4_.invoice_id
ORDER BY
  c0_.created_at_timestamp DESC
LIMIT
  20

SELECT DISTINCT c0_.id AS id_0, c0_.created_at_timestamp AS created_at_timestamp_1 FROM credit_note c0_ LEFT JOIN invoice i1_ ON c0_.invoice_id = i1_.id LEFT JOIN project p2_ ON i1_.project_id = p2_.id LEFT JOIN customer c3_ ON p2_.customer_id = c3_.id LEFT JOIN quote q4_ ON i1_.id = q4_.invoice_id ORDER BY c0_.created_at_timestamp DESC LIMIT 20;

SELECT
  c0_.id AS id_0,
  c0_.amount AS amount_1,
  c0_.description AS description_2,
  c0_.number AS number_3,
  c0_.status AS status_4,
  c0_.created_at_timestamp AS created_at_timestamp_5,
  c0_.updated_at_timestamp AS updated_at_timestamp_6,
  c0_.invoice_id AS invoice_id_7,
  c0_.allocation_guid_id AS allocation_guid_id_8,
  c0_.xero_guid_id AS xero_guid_id_9,
  c0_.created_by_user_id AS created_by_user_id_10,
  c0_.last_updated_by_user_id AS last_updated_by_user_id_11
FROM
  credit_note c0_
  LEFT JOIN invoice i1_ ON c0_.invoice_id = i1_.id
  LEFT JOIN project p2_ ON i1_.project_id = p2_.id
  LEFT JOIN customer c3_ ON p2_.customer_id = c3_.id
  LEFT JOIN quote q4_ ON i1_.id = q4_.invoice_id
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  c0_.created_at_timestamp DESC

SELECT c0_.id AS id_0, c0_.amount AS amount_1, c0_.description AS description_2, c0_.number AS number_3, c0_.status AS status_4, c0_.created_at_timestamp AS created_at_timestamp_5, c0_.updated_at_timestamp AS updated_at_timestamp_6, c0_.invoice_id AS invoice_id_7, c0_.allocation_guid_id AS allocation_guid_id_8, c0_.xero_guid_id AS xero_guid_id_9, c0_.created_by_user_id AS created_by_user_id_10, c0_.last_updated_by_user_id AS last_updated_by_user_id_11 FROM credit_note c0_ LEFT JOIN invoice i1_ ON c0_.invoice_id = i1_.id LEFT JOIN project p2_ ON i1_.project_id = p2_.id LEFT JOIN customer c3_ ON p2_.customer_id = c3_.id LEFT JOIN quote q4_ ON i1_.id = q4_.invoice_id WHERE c0_.id IN (320, 319, 318, 317, 316, 315, 314, 313, 312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301) ORDER BY c0_.created_at_timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.reference AS reference_3,
  t0.due_date_timestamp AS due_date_timestamp_4,
  t0.created_at_timestamp AS created_at_timestamp_5,
  t0.updated_at_timestamp AS updated_at_timestamp_6,
  t0.status AS status_7,
  t0.metadata AS metadata_8,
  t0.project_id AS project_id_9,
  t10.id AS id_11,
  t10.expiry_date AS expiry_date_12,
  t10.terms AS terms_13,
  t10.number AS number_14,
  t10.xero_status AS xero_status_15,
  t10.status AS status_16,
  t10.created_at_timestamp AS created_at_timestamp_17,
  t10.updated_at_timestamp AS updated_at_timestamp_18,
  t10.project_id AS project_id_19,
  t10.invoice_id AS invoice_id_20,
  t10.quoted_by_id AS quoted_by_id_21,
  t10.sold_by_id AS sold_by_id_22,
  t10.created_by_user_id AS created_by_user_id_23,
  t10.last_updated_by_user_id AS last_updated_by_user_id_24,
  t10.xero_guid_id AS xero_guid_id_25,
  t0.created_by_user_id AS created_by_user_id_26,
  t0.last_updated_by_user_id AS last_updated_by_user_id_27,
  t0.xero_guid_id AS xero_guid_id_28
FROM
  invoice t0
  LEFT JOIN quote t10 ON t10.invoice_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.reference AS reference_3, t0.due_date_timestamp AS due_date_timestamp_4, t0.created_at_timestamp AS created_at_timestamp_5, t0.updated_at_timestamp AS updated_at_timestamp_6, t0.status AS status_7, t0.metadata AS metadata_8, t0.project_id AS project_id_9, t10.id AS id_11, t10.expiry_date AS expiry_date_12, t10.terms AS terms_13, t10.number AS number_14, t10.xero_status AS xero_status_15, t10.status AS status_16, t10.created_at_timestamp AS created_at_timestamp_17, t10.updated_at_timestamp AS updated_at_timestamp_18, t10.project_id AS project_id_19, t10.invoice_id AS invoice_id_20, t10.quoted_by_id AS quoted_by_id_21, t10.sold_by_id AS sold_by_id_22, t10.created_by_user_id AS created_by_user_id_23, t10.last_updated_by_user_id AS last_updated_by_user_id_24, t10.xero_guid_id AS xero_guid_id_25, t0.created_by_user_id AS created_by_user_id_26, t0.last_updated_by_user_id AS last_updated_by_user_id_27, t0.xero_guid_id AS xero_guid_id_28 FROM invoice t0 LEFT JOIN quote t10 ON t10.invoice_id = t0.id WHERE t0.id = 3809;

SELECT
  t0.id AS id_1,
  t0.requirements AS requirements_2,
  t0.source AS source_3,
  t0.stairlift_condition AS stairlift_condition_4,
  t0.staircase AS staircase_5,
  t0.external_id AS external_id_6,
  t0.external_distribution_id AS external_distribution_id_7,
  t0.lead_type AS lead_type_8,
  t0.extended_warranty AS extended_warranty_9,
  t0.status AS status_10,
  t0.created_at_timestamp AS created_at_timestamp_11,
  t0.updated_at_timestamp AS updated_at_timestamp_12,
  t0.metadata AS metadata_13,
  t0.customer_id AS customer_id_14,
  t0.brand_id AS brand_id_15,
  t0.api_user_id AS api_user_id_16,
  t0.assigned_user_id AS assigned_user_id_17
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.requirements AS requirements_2, t0.source AS source_3, t0.stairlift_condition AS stairlift_condition_4, t0.staircase AS staircase_5, t0.external_id AS external_id_6, t0.external_distribution_id AS external_distribution_id_7, t0.lead_type AS lead_type_8, t0.extended_warranty AS extended_warranty_9, t0.status AS status_10, t0.created_at_timestamp AS created_at_timestamp_11, t0.updated_at_timestamp AS updated_at_timestamp_12, t0.metadata AS metadata_13, t0.customer_id AS customer_id_14, t0.brand_id AS brand_id_15, t0.api_user_id AS api_user_id_16, t0.assigned_user_id AS assigned_user_id_17 FROM project t0 WHERE t0.id = 19095;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.additional_name AS additional_name_3,
  t0.stripe_id AS stripe_id_4,
  t0.address_lines AS address_lines_5,
  t0.address_town AS address_town_6,
  t0.address_postcode AS address_postcode_7,
  t0.address_county AS address_county_8,
  t0.address_country AS address_country_9,
  t0.created_at_timestamp AS created_at_timestamp_10,
  t0.updated_at_timestamp AS updated_at_timestamp_11,
  t0.contact_number AS contact_number_12,
  t0.e164_contact_number AS e164_contact_number_13,
  t0.email_address AS email_address_14,
  t0.latitude AS latitude_15,
  t0.longitude AS longitude_16,
  t0.display_id AS display_id_17,
  t0.created_by_user_id AS created_by_user_id_18,
  t0.last_updated_by_user_id AS last_updated_by_user_id_19,
  t0.xero_guid_id AS xero_guid_id_20
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.additional_name AS additional_name_3, t0.stripe_id AS stripe_id_4, t0.address_lines AS address_lines_5, t0.address_town AS address_town_6, t0.address_postcode AS address_postcode_7, t0.address_county AS address_county_8, t0.address_country AS address_country_9, t0.created_at_timestamp AS created_at_timestamp_10, t0.updated_at_timestamp AS updated_at_timestamp_11, t0.contact_number AS contact_number_12, t0.e164_contact_number AS e164_contact_number_13, t0.email_address AS email_address_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.display_id AS display_id_17, t0.created_by_user_id AS created_by_user_id_18, t0.last_updated_by_user_id AS last_updated_by_user_id_19, t0.xero_guid_id AS xero_guid_id_20 FROM customer t0 WHERE t0.id = 19063;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.mobile_number AS mobile_number_7,
  t0.manage_quote AS manage_quote_8,
  t0.manage_file_deletion AS manage_file_deletion_9,
  t0.manage_export AS manage_export_10,
  t0.manage_export_limited AS manage_export_limited_11,
  t0.sales_department AS sales_department_12,
  t0.last_activity_timestamp AS last_activity_timestamp_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.hex_colour AS hex_colour_15
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.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = 27;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.reference AS reference_3,
  t0.due_date_timestamp AS due_date_timestamp_4,
  t0.created_at_timestamp AS created_at_timestamp_5,
  t0.updated_at_timestamp AS updated_at_timestamp_6,
  t0.status AS status_7,
  t0.metadata AS metadata_8,
  t0.project_id AS project_id_9,
  t10.id AS id_11,
  t10.expiry_date AS expiry_date_12,
  t10.terms AS terms_13,
  t10.number AS number_14,
  t10.xero_status AS xero_status_15,
  t10.status AS status_16,
  t10.created_at_timestamp AS created_at_timestamp_17,
  t10.updated_at_timestamp AS updated_at_timestamp_18,
  t10.project_id AS project_id_19,
  t10.invoice_id AS invoice_id_20,
  t10.quoted_by_id AS quoted_by_id_21,
  t10.sold_by_id AS sold_by_id_22,
  t10.created_by_user_id AS created_by_user_id_23,
  t10.last_updated_by_user_id AS last_updated_by_user_id_24,
  t10.xero_guid_id AS xero_guid_id_25,
  t0.created_by_user_id AS created_by_user_id_26,
  t0.last_updated_by_user_id AS last_updated_by_user_id_27,
  t0.xero_guid_id AS xero_guid_id_28
FROM
  invoice t0
  LEFT JOIN quote t10 ON t10.invoice_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.reference AS reference_3, t0.due_date_timestamp AS due_date_timestamp_4, t0.created_at_timestamp AS created_at_timestamp_5, t0.updated_at_timestamp AS updated_at_timestamp_6, t0.status AS status_7, t0.metadata AS metadata_8, t0.project_id AS project_id_9, t10.id AS id_11, t10.expiry_date AS expiry_date_12, t10.terms AS terms_13, t10.number AS number_14, t10.xero_status AS xero_status_15, t10.status AS status_16, t10.created_at_timestamp AS created_at_timestamp_17, t10.updated_at_timestamp AS updated_at_timestamp_18, t10.project_id AS project_id_19, t10.invoice_id AS invoice_id_20, t10.quoted_by_id AS quoted_by_id_21, t10.sold_by_id AS sold_by_id_22, t10.created_by_user_id AS created_by_user_id_23, t10.last_updated_by_user_id AS last_updated_by_user_id_24, t10.xero_guid_id AS xero_guid_id_25, t0.created_by_user_id AS created_by_user_id_26, t0.last_updated_by_user_id AS last_updated_by_user_id_27, t0.xero_guid_id AS xero_guid_id_28 FROM invoice t0 LEFT JOIN quote t10 ON t10.invoice_id = t0.id WHERE t0.id = 3765;

SELECT
  t0.id AS id_1,
  t0.requirements AS requirements_2,
  t0.source AS source_3,
  t0.stairlift_condition AS stairlift_condition_4,
  t0.staircase AS staircase_5,
  t0.external_id AS external_id_6,
  t0.external_distribution_id AS external_distribution_id_7,
  t0.lead_type AS lead_type_8,
  t0.extended_warranty AS extended_warranty_9,
  t0.status AS status_10,
  t0.created_at_timestamp AS created_at_timestamp_11,
  t0.updated_at_timestamp AS updated_at_timestamp_12,
  t0.metadata AS metadata_13,
  t0.customer_id AS customer_id_14,
  t0.brand_id AS brand_id_15,
  t0.api_user_id AS api_user_id_16,
  t0.assigned_user_id AS assigned_user_id_17
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.requirements AS requirements_2, t0.source AS source_3, t0.stairlift_condition AS stairlift_condition_4, t0.staircase AS staircase_5, t0.external_id AS external_id_6, t0.external_distribution_id AS external_distribution_id_7, t0.lead_type AS lead_type_8, t0.extended_warranty AS extended_warranty_9, t0.status AS status_10, t0.created_at_timestamp AS created_at_timestamp_11, t0.updated_at_timestamp AS updated_at_timestamp_12, t0.metadata AS metadata_13, t0.customer_id AS customer_id_14, t0.brand_id AS brand_id_15, t0.api_user_id AS api_user_id_16, t0.assigned_user_id AS assigned_user_id_17 FROM project t0 WHERE t0.id = 6391;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.additional_name AS additional_name_3,
  t0.stripe_id AS stripe_id_4,
  t0.address_lines AS address_lines_5,
  t0.address_town AS address_town_6,
  t0.address_postcode AS address_postcode_7,
  t0.address_county AS address_county_8,
  t0.address_country AS address_country_9,
  t0.created_at_timestamp AS created_at_timestamp_10,
  t0.updated_at_timestamp AS updated_at_timestamp_11,
  t0.contact_number AS contact_number_12,
  t0.e164_contact_number AS e164_contact_number_13,
  t0.email_address AS email_address_14,
  t0.latitude AS latitude_15,
  t0.longitude AS longitude_16,
  t0.display_id AS display_id_17,
  t0.created_by_user_id AS created_by_user_id_18,
  t0.last_updated_by_user_id AS last_updated_by_user_id_19,
  t0.xero_guid_id AS xero_guid_id_20
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.additional_name AS additional_name_3, t0.stripe_id AS stripe_id_4, t0.address_lines AS address_lines_5, t0.address_town AS address_town_6, t0.address_postcode AS address_postcode_7, t0.address_county AS address_county_8, t0.address_country AS address_country_9, t0.created_at_timestamp AS created_at_timestamp_10, t0.updated_at_timestamp AS updated_at_timestamp_11, t0.contact_number AS contact_number_12, t0.e164_contact_number AS e164_contact_number_13, t0.email_address AS email_address_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.display_id AS display_id_17, t0.created_by_user_id AS created_by_user_id_18, t0.last_updated_by_user_id AS last_updated_by_user_id_19, t0.xero_guid_id AS xero_guid_id_20 FROM customer t0 WHERE t0.id = 6380;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.mobile_number AS mobile_number_7,
  t0.manage_quote AS manage_quote_8,
  t0.manage_file_deletion AS manage_file_deletion_9,
  t0.manage_export AS manage_export_10,
  t0.manage_export_limited AS manage_export_limited_11,
  t0.sales_department AS sales_department_12,
  t0.last_activity_timestamp AS last_activity_timestamp_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.hex_colour AS hex_colour_15
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.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = 35;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.reference AS reference_3,
  t0.due_date_timestamp AS due_date_timestamp_4,
  t0.created_at_timestamp AS created_at_timestamp_5,
  t0.updated_at_timestamp AS updated_at_timestamp_6,
  t0.status AS status_7,
  t0.metadata AS metadata_8,
  t0.project_id AS project_id_9,
  t10.id AS id_11,
  t10.expiry_date AS expiry_date_12,
  t10.terms AS terms_13,
  t10.number AS number_14,
  t10.xero_status AS xero_status_15,
  t10.status AS status_16,
  t10.created_at_timestamp AS created_at_timestamp_17,
  t10.updated_at_timestamp AS updated_at_timestamp_18,
  t10.project_id AS project_id_19,
  t10.invoice_id AS invoice_id_20,
  t10.quoted_by_id AS quoted_by_id_21,
  t10.sold_by_id AS sold_by_id_22,
  t10.created_by_user_id AS created_by_user_id_23,
  t10.last_updated_by_user_id AS last_updated_by_user_id_24,
  t10.xero_guid_id AS xero_guid_id_25,
  t0.created_by_user_id AS created_by_user_id_26,
  t0.last_updated_by_user_id AS last_updated_by_user_id_27,
  t0.xero_guid_id AS xero_guid_id_28
FROM
  invoice t0
  LEFT JOIN quote t10 ON t10.invoice_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.reference AS reference_3, t0.due_date_timestamp AS due_date_timestamp_4, t0.created_at_timestamp AS created_at_timestamp_5, t0.updated_at_timestamp AS updated_at_timestamp_6, t0.status AS status_7, t0.metadata AS metadata_8, t0.project_id AS project_id_9, t10.id AS id_11, t10.expiry_date AS expiry_date_12, t10.terms AS terms_13, t10.number AS number_14, t10.xero_status AS xero_status_15, t10.status AS status_16, t10.created_at_timestamp AS created_at_timestamp_17, t10.updated_at_timestamp AS updated_at_timestamp_18, t10.project_id AS project_id_19, t10.invoice_id AS invoice_id_20, t10.quoted_by_id AS quoted_by_id_21, t10.sold_by_id AS sold_by_id_22, t10.created_by_user_id AS created_by_user_id_23, t10.last_updated_by_user_id AS last_updated_by_user_id_24, t10.xero_guid_id AS xero_guid_id_25, t0.created_by_user_id AS created_by_user_id_26, t0.last_updated_by_user_id AS last_updated_by_user_id_27, t0.xero_guid_id AS xero_guid_id_28 FROM invoice t0 LEFT JOIN quote t10 ON t10.invoice_id = t0.id WHERE t0.id = 3782;

SELECT
  t0.id AS id_1,
  t0.requirements AS requirements_2,
  t0.source AS source_3,
  t0.stairlift_condition AS stairlift_condition_4,
  t0.staircase AS staircase_5,
  t0.external_id AS external_id_6,
  t0.external_distribution_id AS external_distribution_id_7,
  t0.lead_type AS lead_type_8,
  t0.extended_warranty AS extended_warranty_9,
  t0.status AS status_10,
  t0.created_at_timestamp AS created_at_timestamp_11,
  t0.updated_at_timestamp AS updated_at_timestamp_12,
  t0.metadata AS metadata_13,
  t0.customer_id AS customer_id_14,
  t0.brand_id AS brand_id_15,
  t0.api_user_id AS api_user_id_16,
  t0.assigned_user_id AS assigned_user_id_17
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.requirements AS requirements_2, t0.source AS source_3, t0.stairlift_condition AS stairlift_condition_4, t0.staircase AS staircase_5, t0.external_id AS external_id_6, t0.external_distribution_id AS external_distribution_id_7, t0.lead_type AS lead_type_8, t0.extended_warranty AS extended_warranty_9, t0.status AS status_10, t0.created_at_timestamp AS created_at_timestamp_11, t0.updated_at_timestamp AS updated_at_timestamp_12, t0.metadata AS metadata_13, t0.customer_id AS customer_id_14, t0.brand_id AS brand_id_15, t0.api_user_id AS api_user_id_16, t0.assigned_user_id AS assigned_user_id_17 FROM project t0 WHERE t0.id = 19062;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.additional_name AS additional_name_3,
  t0.stripe_id AS stripe_id_4,
  t0.address_lines AS address_lines_5,
  t0.address_town AS address_town_6,
  t0.address_postcode AS address_postcode_7,
  t0.address_county AS address_county_8,
  t0.address_country AS address_country_9,
  t0.created_at_timestamp AS created_at_timestamp_10,
  t0.updated_at_timestamp AS updated_at_timestamp_11,
  t0.contact_number AS contact_number_12,
  t0.e164_contact_number AS e164_contact_number_13,
  t0.email_address AS email_address_14,
  t0.latitude AS latitude_15,
  t0.longitude AS longitude_16,
  t0.display_id AS display_id_17,
  t0.created_by_user_id AS created_by_user_id_18,
  t0.last_updated_by_user_id AS last_updated_by_user_id_19,
  t0.xero_guid_id AS xero_guid_id_20
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.additional_name AS additional_name_3, t0.stripe_id AS stripe_id_4, t0.address_lines AS address_lines_5, t0.address_town AS address_town_6, t0.address_postcode AS address_postcode_7, t0.address_county AS address_county_8, t0.address_country AS address_country_9, t0.created_at_timestamp AS created_at_timestamp_10, t0.updated_at_timestamp AS updated_at_timestamp_11, t0.contact_number AS contact_number_12, t0.e164_contact_number AS e164_contact_number_13, t0.email_address AS email_address_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.display_id AS display_id_17, t0.created_by_user_id AS created_by_user_id_18, t0.last_updated_by_user_id AS last_updated_by_user_id_19, t0.xero_guid_id AS xero_guid_id_20 FROM customer t0 WHERE t0.id = 19030;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.mobile_number AS mobile_number_7,
  t0.manage_quote AS manage_quote_8,
  t0.manage_file_deletion AS manage_file_deletion_9,
  t0.manage_export AS manage_export_10,
  t0.manage_export_limited AS manage_export_limited_11,
  t0.sales_department AS sales_department_12,
  t0.last_activity_timestamp AS last_activity_timestamp_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.hex_colour AS hex_colour_15
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.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.reference AS reference_3,
  t0.due_date_timestamp AS due_date_timestamp_4,
  t0.created_at_timestamp AS created_at_timestamp_5,
  t0.updated_at_timestamp AS updated_at_timestamp_6,
  t0.status AS status_7,
  t0.metadata AS metadata_8,
  t0.project_id AS project_id_9,
  t10.id AS id_11,
  t10.expiry_date AS expiry_date_12,
  t10.terms AS terms_13,
  t10.number AS number_14,
  t10.xero_status AS xero_status_15,
  t10.status AS status_16,
  t10.created_at_timestamp AS created_at_timestamp_17,
  t10.updated_at_timestamp AS updated_at_timestamp_18,
  t10.project_id AS project_id_19,
  t10.invoice_id AS invoice_id_20,
  t10.quoted_by_id AS quoted_by_id_21,
  t10.sold_by_id AS sold_by_id_22,
  t10.created_by_user_id AS created_by_user_id_23,
  t10.last_updated_by_user_id AS last_updated_by_user_id_24,
  t10.xero_guid_id AS xero_guid_id_25,
  t0.created_by_user_id AS created_by_user_id_26,
  t0.last_updated_by_user_id AS last_updated_by_user_id_27,
  t0.xero_guid_id AS xero_guid_id_28
FROM
  invoice t0
  LEFT JOIN quote t10 ON t10.invoice_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.reference AS reference_3, t0.due_date_timestamp AS due_date_timestamp_4, t0.created_at_timestamp AS created_at_timestamp_5, t0.updated_at_timestamp AS updated_at_timestamp_6, t0.status AS status_7, t0.metadata AS metadata_8, t0.project_id AS project_id_9, t10.id AS id_11, t10.expiry_date AS expiry_date_12, t10.terms AS terms_13, t10.number AS number_14, t10.xero_status AS xero_status_15, t10.status AS status_16, t10.created_at_timestamp AS created_at_timestamp_17, t10.updated_at_timestamp AS updated_at_timestamp_18, t10.project_id AS project_id_19, t10.invoice_id AS invoice_id_20, t10.quoted_by_id AS quoted_by_id_21, t10.sold_by_id AS sold_by_id_22, t10.created_by_user_id AS created_by_user_id_23, t10.last_updated_by_user_id AS last_updated_by_user_id_24, t10.xero_guid_id AS xero_guid_id_25, t0.created_by_user_id AS created_by_user_id_26, t0.last_updated_by_user_id AS last_updated_by_user_id_27, t0.xero_guid_id AS xero_guid_id_28 FROM invoice t0 LEFT JOIN quote t10 ON t10.invoice_id = t0.id WHERE t0.id = 3780;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.reference AS reference_3,
  t0.due_date_timestamp AS due_date_timestamp_4,
  t0.created_at_timestamp AS created_at_timestamp_5,
  t0.updated_at_timestamp AS updated_at_timestamp_6,
  t0.status AS status_7,
  t0.metadata AS metadata_8,
  t0.project_id AS project_id_9,
  t10.id AS id_11,
  t10.expiry_date AS expiry_date_12,
  t10.terms AS terms_13,
  t10.number AS number_14,
  t10.xero_status AS xero_status_15,
  t10.status AS status_16,
  t10.created_at_timestamp AS created_at_timestamp_17,
  t10.updated_at_timestamp AS updated_at_timestamp_18,
  t10.project_id AS project_id_19,
  t10.invoice_id AS invoice_id_20,
  t10.quoted_by_id AS quoted_by_id_21,
  t10.sold_by_id AS sold_by_id_22,
  t10.created_by_user_id AS created_by_user_id_23,
  t10.last_updated_by_user_id AS last_updated_by_user_id_24,
  t10.xero_guid_id AS xero_guid_id_25,
  t0.created_by_user_id AS created_by_user_id_26,
  t0.last_updated_by_user_id AS last_updated_by_user_id_27,
  t0.xero_guid_id AS xero_guid_id_28
FROM
  invoice t0
  LEFT JOIN quote t10 ON t10.invoice_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.reference AS reference_3, t0.due_date_timestamp AS due_date_timestamp_4, t0.created_at_timestamp AS created_at_timestamp_5, t0.updated_at_timestamp AS updated_at_timestamp_6, t0.status AS status_7, t0.metadata AS metadata_8, t0.project_id AS project_id_9, t10.id AS id_11, t10.expiry_date AS expiry_date_12, t10.terms AS terms_13, t10.number AS number_14, t10.xero_status AS xero_status_15, t10.status AS status_16, t10.created_at_timestamp AS created_at_timestamp_17, t10.updated_at_timestamp AS updated_at_timestamp_18, t10.project_id AS project_id_19, t10.invoice_id AS invoice_id_20, t10.quoted_by_id AS quoted_by_id_21, t10.sold_by_id AS sold_by_id_22, t10.created_by_user_id AS created_by_user_id_23, t10.last_updated_by_user_id AS last_updated_by_user_id_24, t10.xero_guid_id AS xero_guid_id_25, t0.created_by_user_id AS created_by_user_id_26, t0.last_updated_by_user_id AS last_updated_by_user_id_27, t0.xero_guid_id AS xero_guid_id_28 FROM invoice t0 LEFT JOIN quote t10 ON t10.invoice_id = t0.id WHERE t0.id = 3733;

SELECT
  t0.id AS id_1,
  t0.requirements AS requirements_2,
  t0.source AS source_3,
  t0.stairlift_condition AS stairlift_condition_4,
  t0.staircase AS staircase_5,
  t0.external_id AS external_id_6,
  t0.external_distribution_id AS external_distribution_id_7,
  t0.lead_type AS lead_type_8,
  t0.extended_warranty AS extended_warranty_9,
  t0.status AS status_10,
  t0.created_at_timestamp AS created_at_timestamp_11,
  t0.updated_at_timestamp AS updated_at_timestamp_12,
  t0.metadata AS metadata_13,
  t0.customer_id AS customer_id_14,
  t0.brand_id AS brand_id_15,
  t0.api_user_id AS api_user_id_16,
  t0.assigned_user_id AS assigned_user_id_17
FROM
  project t0
WHERE
  t0.id = ?