Symfony Profiler

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at_timestamp AS created_at_timestamp_1
FROM
  project p0_
  LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id
  LEFT JOIN user u2_ ON p0_.assigned_user_id = u2_.id
  LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id
WHERE
  p0_.status = ?
  OR p0_.status = ?
ORDER BY
  p0_.created_at_timestamp DESC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, p0_.created_at_timestamp AS created_at_timestamp_1 FROM project p0_ LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id LEFT JOIN user u2_ ON p0_.assigned_user_id = u2_.id LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id WHERE p0_.status = 'unassigned' OR p0_.status = 'lead' ORDER BY p0_.created_at_timestamp DESC LIMIT 20;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  project p0_
  LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id
  LEFT JOIN user u2_ ON p0_.assigned_user_id = u2_.id
  LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id
WHERE
  p0_.status = ?
  OR p0_.status = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM project p0_ LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id LEFT JOIN user u2_ ON p0_.assigned_user_id = u2_.id LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id WHERE p0_.status = 'unassigned' OR p0_.status = 'lead';

SELECT
  p0_.is_pinned AS is_pinned_0,
  p0_.anniversary_category AS anniversary_category_1,
  p0_.is_deleted AS is_deleted_2,
  p0_.deleted_at_timestamp AS deleted_at_timestamp_3,
  p0_.id AS id_4,
  p0_.body AS body_5,
  p0_.category AS category_6,
  p0_.completed_at_timestamp AS completed_at_timestamp_7,
  p0_.created_at_timestamp AS created_at_timestamp_8,
  p0_.updated_at_timestamp AS updated_at_timestamp_9,
  p0_.due_at_timestamp AS due_at_timestamp_10,
  p0_.project_id AS project_id_11,
  p0_.deleted_by_user_id AS deleted_by_user_id_12,
  p0_.assigned_user_id AS assigned_user_id_13,
  p0_.created_by_user_id AS created_by_user_id_14,
  p0_.last_updated_by_user_id AS last_updated_by_user_id_15
FROM
  project_note p0_
WHERE
  p0_.anniversary_category IS NULL
  AND p0_.project_id = ?
  AND p0_.due_at_timestamp IS NOT NULL

SELECT p0_.is_pinned AS is_pinned_0, p0_.anniversary_category AS anniversary_category_1, p0_.is_deleted AS is_deleted_2, p0_.deleted_at_timestamp AS deleted_at_timestamp_3, p0_.id AS id_4, p0_.body AS body_5, p0_.category AS category_6, p0_.completed_at_timestamp AS completed_at_timestamp_7, p0_.created_at_timestamp AS created_at_timestamp_8, p0_.updated_at_timestamp AS updated_at_timestamp_9, p0_.due_at_timestamp AS due_at_timestamp_10, p0_.project_id AS project_id_11, p0_.deleted_by_user_id AS deleted_by_user_id_12, p0_.assigned_user_id AS assigned_user_id_13, p0_.created_by_user_id AS created_by_user_id_14, p0_.last_updated_by_user_id AS last_updated_by_user_id_15 FROM project_note p0_ WHERE p0_.anniversary_category IS NULL AND p0_.project_id = 19909 AND p0_.due_at_timestamp IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.kind AS kind_3,
  t0.completed_at_timestamp AS completed_at_timestamp_4,
  t0.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_5,
  t0.specification AS specification_6,
  t0.trainer_feedback AS trainer_feedback_7,
  t0.reviewed_at_timestamp AS reviewed_at_timestamp_8,
  t0.stock_status AS stock_status_9,
  t0.created_at_timestamp AS created_at_timestamp_10,
  t0.updated_at_timestamp AS updated_at_timestamp_11,
  t0.status AS status_12,
  t0.booked_at_timestamp AS booked_at_timestamp_13,
  t0.metadata AS metadata_14,
  t0.arrival_timestamp AS arrival_timestamp_15,
  t0.leaving_timestamp AS leaving_timestamp_16,
  t0.display_id AS display_id_17,
  t0.project_id AS project_id_18,
  t0.reviewed_by_user_id AS reviewed_by_user_id_19,
  t0.field_trainer_id AS field_trainer_id_20,
  t0.quote_product_id AS quote_product_id_21,
  t0.assigned_items_id AS assigned_items_id_22,
  t0.created_by_user_id AS created_by_user_id_23,
  t0.last_updated_by_user_id AS last_updated_by_user_id_24,
  t0.assigned_user_id AS assigned_user_id_25
FROM
  job t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.kind AS kind_3, t0.completed_at_timestamp AS completed_at_timestamp_4, t0.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_5, t0.specification AS specification_6, t0.trainer_feedback AS trainer_feedback_7, t0.reviewed_at_timestamp AS reviewed_at_timestamp_8, t0.stock_status AS stock_status_9, t0.created_at_timestamp AS created_at_timestamp_10, t0.updated_at_timestamp AS updated_at_timestamp_11, t0.status AS status_12, t0.booked_at_timestamp AS booked_at_timestamp_13, t0.metadata AS metadata_14, t0.arrival_timestamp AS arrival_timestamp_15, t0.leaving_timestamp AS leaving_timestamp_16, t0.display_id AS display_id_17, t0.project_id AS project_id_18, t0.reviewed_by_user_id AS reviewed_by_user_id_19, t0.field_trainer_id AS field_trainer_id_20, t0.quote_product_id AS quote_product_id_21, t0.assigned_items_id AS assigned_items_id_22, t0.created_by_user_id AS created_by_user_id_23, t0.last_updated_by_user_id AS last_updated_by_user_id_24, t0.assigned_user_id AS assigned_user_id_25 FROM job t0 WHERE t0.project_id = 19909;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.additional_name AS additional_name_3,
  t0.alternative_contact_number AS alternative_contact_number_4,
  t0.stripe_id AS stripe_id_5,
  t0.address_lines AS address_lines_6,
  t0.address_town AS address_town_7,
  t0.address_postcode AS address_postcode_8,
  t0.address_county AS address_county_9,
  t0.address_country AS address_country_10,
  t0.created_at_timestamp AS created_at_timestamp_11,
  t0.updated_at_timestamp AS updated_at_timestamp_12,
  t0.contact_number AS contact_number_13,
  t0.e164_contact_number AS e164_contact_number_14,
  t0.email_address AS email_address_15,
  t0.latitude AS latitude_16,
  t0.longitude AS longitude_17,
  t0.display_id AS display_id_18,
  t0.created_by_user_id AS created_by_user_id_19,
  t0.last_updated_by_user_id AS last_updated_by_user_id_20,
  t0.xero_guid_id AS xero_guid_id_21
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.alternative_contact_number AS alternative_contact_number_4, t0.stripe_id AS stripe_id_5, t0.address_lines AS address_lines_6, t0.address_town AS address_town_7, t0.address_postcode AS address_postcode_8, t0.address_county AS address_county_9, t0.address_country AS address_country_10, t0.created_at_timestamp AS created_at_timestamp_11, t0.updated_at_timestamp AS updated_at_timestamp_12, t0.contact_number AS contact_number_13, t0.e164_contact_number AS e164_contact_number_14, t0.email_address AS email_address_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.display_id AS display_id_18, t0.created_by_user_id AS created_by_user_id_19, t0.last_updated_by_user_id AS last_updated_by_user_id_20, t0.xero_guid_id AS xero_guid_id_21 FROM customer t0 WHERE t0.id = 24034;

"COMMIT"

"COMMIT";

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.name AS name_4,
  u0_.status AS status_5,
  u0_.mobile_number AS mobile_number_6,
  u0_.manage_quote AS manage_quote_7,
  u0_.manage_file_deletion AS manage_file_deletion_8,
  u0_.manage_export AS manage_export_9,
  u0_.manage_export_limited AS manage_export_limited_10,
  u0_.can_import_quote_product AS can_import_quote_product_11,
  u0_.sales_department AS sales_department_12,
  u0_.is_deleted AS is_deleted_13,
  u0_.last_activity_timestamp AS last_activity_timestamp_14,
  u0_.password_reset_token AS password_reset_token_15,
  u0_.hex_colour AS hex_colour_16
FROM
  user u0_
WHERE
  u0_.roles NOT LIKE ?
  AND u0_.status = ?
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.status AS status_5, u0_.mobile_number AS mobile_number_6, u0_.manage_quote AS manage_quote_7, u0_.manage_file_deletion AS manage_file_deletion_8, u0_.manage_export AS manage_export_9, u0_.manage_export_limited AS manage_export_limited_10, u0_.can_import_quote_product AS can_import_quote_product_11, u0_.sales_department AS sales_department_12, u0_.is_deleted AS is_deleted_13, u0_.last_activity_timestamp AS last_activity_timestamp_14, u0_.password_reset_token AS password_reset_token_15, u0_.hex_colour AS hex_colour_16 FROM user u0_ WHERE u0_.roles NOT LIKE '%ROLE_HIDDEN%' AND u0_.status = 1 ORDER BY u0_.name ASC;

SELECT
  a0_.id AS id_0,
  a0_.api_key AS api_key_1,
  a0_.roles AS roles_2,
  a0_.status AS status_3,
  a0_.name AS name_4,
  a0_.email_address_for_confirmation AS email_address_for_confirmation_5,
  a0_.show_in_reports AS show_in_reports_6
FROM
  api_user a0_
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.api_key AS api_key_1, a0_.roles AS roles_2, a0_.status AS status_3, a0_.name AS name_4, a0_.email_address_for_confirmation AS email_address_for_confirmation_5, a0_.show_in_reports AS show_in_reports_6 FROM api_user a0_ ORDER BY a0_.name ASC;

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
  LEFT JOIN user u2_ ON p0_.assigned_user_id = u2_.id
  LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id
WHERE
  (
    p0_.status = ?
    OR p0_.status = ?
  )
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.created_at_timestamp DESC

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 LEFT JOIN user u2_ ON p0_.assigned_user_id = u2_.id LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id WHERE (p0_.status = 'unassigned' OR p0_.status = 'lead') AND p0_.id IN (19909, 19908, 19907, 19906, 19905, 19904, 19903, 19902, 19901, 19900, 19899, 19895, 19893, 19892, 19890, 19889, 19888, 19887, 19886, 19885) ORDER BY p0_.created_at_timestamp DESC;

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.can_import_quote_product AS can_import_quote_product_12,
  t0.sales_department AS sales_department_13,
  t0.is_deleted AS is_deleted_14,
  t0.last_activity_timestamp AS last_activity_timestamp_15,
  t0.password_reset_token AS password_reset_token_16,
  t0.hex_colour AS hex_colour_17
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.can_import_quote_product AS can_import_quote_product_12, t0.sales_department AS sales_department_13, t0.is_deleted AS is_deleted_14, t0.last_activity_timestamp AS last_activity_timestamp_15, t0.password_reset_token AS password_reset_token_16, t0.hex_colour AS hex_colour_17 FROM user t0 WHERE t0.id = 88;

UPDATE
  user
SET
  last_activity_timestamp = ?
WHERE
  id = ?

UPDATE user SET last_activity_timestamp = 1786603981 WHERE id = 88;

"START TRANSACTION"

"START TRANSACTION";