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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  last_activity_timestamp = ?
WHERE
  id = ?

UPDATE user SET last_activity_timestamp = 1781040810 WHERE id = 80;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.kind AS kind_2,
  t0.completed_at_timestamp AS completed_at_timestamp_3,
  t0.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_4,
  t0.specification AS specification_5,
  t0.reviewed_at_timestamp AS reviewed_at_timestamp_6,
  t0.stock_status AS stock_status_7,
  t0.created_at_timestamp AS created_at_timestamp_8,
  t0.updated_at_timestamp AS updated_at_timestamp_9,
  t0.status AS status_10,
  t0.booked_at_timestamp AS booked_at_timestamp_11,
  t0.metadata AS metadata_12,
  t0.arrival_timestamp AS arrival_timestamp_13,
  t0.leaving_timestamp AS leaving_timestamp_14,
  t0.display_id AS display_id_15,
  t0.project_id AS project_id_16,
  t0.reviewed_by_user_id AS reviewed_by_user_id_17,
  t0.trainer_user_id AS trainer_user_id_18,
  t0.quote_product_id AS quote_product_id_19,
  t0.assigned_items_id AS assigned_items_id_20,
  t0.created_by_user_id AS created_by_user_id_21,
  t0.last_updated_by_user_id AS last_updated_by_user_id_22,
  t0.assigned_user_id AS assigned_user_id_23
FROM
  job t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.kind AS kind_2, t0.completed_at_timestamp AS completed_at_timestamp_3, t0.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_4, t0.specification AS specification_5, t0.reviewed_at_timestamp AS reviewed_at_timestamp_6, t0.stock_status AS stock_status_7, t0.created_at_timestamp AS created_at_timestamp_8, t0.updated_at_timestamp AS updated_at_timestamp_9, t0.status AS status_10, t0.booked_at_timestamp AS booked_at_timestamp_11, t0.metadata AS metadata_12, t0.arrival_timestamp AS arrival_timestamp_13, t0.leaving_timestamp AS leaving_timestamp_14, t0.display_id AS display_id_15, t0.project_id AS project_id_16, t0.reviewed_by_user_id AS reviewed_by_user_id_17, t0.trainer_user_id AS trainer_user_id_18, t0.quote_product_id AS quote_product_id_19, t0.assigned_items_id AS assigned_items_id_20, t0.created_by_user_id AS created_by_user_id_21, t0.last_updated_by_user_id AS last_updated_by_user_id_22, t0.assigned_user_id AS assigned_user_id_23 FROM job t0 WHERE t0.id = '15691';

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_.sales_department AS sales_department_11,
  u0_.last_activity_timestamp AS last_activity_timestamp_12,
  u0_.password_reset_token AS password_reset_token_13,
  u0_.hex_colour AS hex_colour_14
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_.sales_department AS sales_department_11, u0_.last_activity_timestamp AS last_activity_timestamp_12, u0_.password_reset_token AS password_reset_token_13, u0_.hex_colour AS hex_colour_14 FROM user u0_ WHERE u0_.roles NOT LIKE '%ROLE_HIDDEN%' AND u0_.status = 1 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_.sales_department AS sales_department_11,
  u0_.last_activity_timestamp AS last_activity_timestamp_12,
  u0_.password_reset_token AS password_reset_token_13,
  u0_.hex_colour AS hex_colour_14
FROM
  user u0_
WHERE
  u0_.roles NOT LIKE ?
  AND u0_.status = ?
  AND u0_.roles LIKE ?
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_.sales_department AS sales_department_11, u0_.last_activity_timestamp AS last_activity_timestamp_12, u0_.password_reset_token AS password_reset_token_13, u0_.hex_colour AS hex_colour_14 FROM user u0_ WHERE u0_.roles NOT LIKE '%ROLE_HIDDEN%' AND u0_.status = 1 AND u0_.roles LIKE '%ROLE_FIELD_TRAINER%' ORDER BY u0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.quantity AS quantity_4,
  t0.unit_price AS unit_price_5,
  t0.cost AS cost_6,
  t0.tax_rate AS tax_rate_7,
  t0.category AS category_8,
  t0.is_deleted AS is_deleted_9
FROM
  quote_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.cost AS cost_6, t0.tax_rate AS tax_rate_7, t0.category AS category_8, t0.is_deleted AS is_deleted_9 FROM quote_product t0 WHERE t0.id = 78;

SELECT
  u.name,
  h.timestamp,
  h.transition,
  COALESCE(
    date_from, string_from, text_from
  ) as state_from,
  COALESCE(date_to, string_to, text_to) as state_to
FROM
  history_log h
  LEFT JOIN user u on u.id = h.user_id
WHERE
  h.subject = 'JOB'
  AND h.reference = ?
ORDER BY
  h.id DESC

SELECT 
            u.name,
            h.timestamp,
            h.transition,
            COALESCE(date_from, string_from, text_from) as state_from,
            COALESCE(date_to, string_to, text_to) as state_to
            FROM history_log h
            LEFT JOIN user u on u.id = h.user_id
            WHERE h.subject = 'JOB'
            AND h.reference = 15691
            ORDER BY h.id DESC;

SELECT
  q0_.id AS id_0,
  q0_.title AS title_1,
  q0_.description AS description_2,
  q0_.quantity AS quantity_3,
  q0_.unit_price AS unit_price_4,
  q0_.cost AS cost_5,
  q0_.tax_rate AS tax_rate_6,
  q0_.category AS category_7,
  q0_.is_deleted AS is_deleted_8
FROM
  quote_product q0_
WHERE
  q0_.category IN ('curved', 'straight')
  AND (
    (
      q0_.is_deleted <> ?
      OR q0_.is_deleted IS NULL
    )
  )

SELECT q0_.id AS id_0, q0_.title AS title_1, q0_.description AS description_2, q0_.quantity AS quantity_3, q0_.unit_price AS unit_price_4, q0_.cost AS cost_5, q0_.tax_rate AS tax_rate_6, q0_.category AS category_7, q0_.is_deleted AS is_deleted_8 FROM quote_product q0_ WHERE q0_.category IN ('curved', 'straight') AND ((q0_.is_deleted <> 1 OR q0_.is_deleted IS NULL));

SELECT
  q0_.id AS id_0,
  q0_.title AS title_1,
  q0_.description AS description_2,
  q0_.quantity AS quantity_3,
  q0_.unit_price AS unit_price_4,
  q0_.cost AS cost_5,
  q0_.tax_rate AS tax_rate_6,
  q0_.category AS category_7,
  q0_.is_deleted AS is_deleted_8
FROM
  quote_product q0_
WHERE
  q0_.category IN (?, ?)
  AND (
    (
      q0_.is_deleted <> ?
      OR q0_.is_deleted IS NULL
    )
  )

SELECT q0_.id AS id_0, q0_.title AS title_1, q0_.description AS description_2, q0_.quantity AS quantity_3, q0_.unit_price AS unit_price_4, q0_.cost AS cost_5, q0_.tax_rate AS tax_rate_6, q0_.category AS category_7, q0_.is_deleted AS is_deleted_8 FROM quote_product q0_ WHERE q0_.category IN ('curved', 'straight') AND ((q0_.is_deleted <> 1 OR q0_.is_deleted IS NULL));

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.lead_type AS lead_type_7,
  t0.extended_warranty AS extended_warranty_8,
  t0.status AS status_9,
  t0.created_at_timestamp AS created_at_timestamp_10,
  t0.updated_at_timestamp AS updated_at_timestamp_11,
  t0.metadata AS metadata_12,
  t0.customer_id AS customer_id_13,
  t0.brand_id AS brand_id_14,
  t0.api_user_id AS api_user_id_15,
  t0.assigned_user_id AS assigned_user_id_16
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.lead_type AS lead_type_7, t0.extended_warranty AS extended_warranty_8, t0.status AS status_9, t0.created_at_timestamp AS created_at_timestamp_10, t0.updated_at_timestamp AS updated_at_timestamp_11, t0.metadata AS metadata_12, t0.customer_id AS customer_id_13, t0.brand_id AS brand_id_14, t0.api_user_id AS api_user_id_15, t0.assigned_user_id AS assigned_user_id_16 FROM project t0 WHERE t0.id = 19850;

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

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.id = ?

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.id = 7;

SELECT
  t0.id AS id_1,
  t2.id AS id_3,
  t2.kind AS kind_4,
  t2.completed_at_timestamp AS completed_at_timestamp_5,
  t2.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_6,
  t2.specification AS specification_7,
  t2.reviewed_at_timestamp AS reviewed_at_timestamp_8,
  t2.stock_status AS stock_status_9,
  t2.created_at_timestamp AS created_at_timestamp_10,
  t2.updated_at_timestamp AS updated_at_timestamp_11,
  t2.status AS status_12,
  t2.booked_at_timestamp AS booked_at_timestamp_13,
  t2.metadata AS metadata_14,
  t2.arrival_timestamp AS arrival_timestamp_15,
  t2.leaving_timestamp AS leaving_timestamp_16,
  t2.display_id AS display_id_17,
  t2.project_id AS project_id_18,
  t2.reviewed_by_user_id AS reviewed_by_user_id_19,
  t2.trainer_user_id AS trainer_user_id_20,
  t2.quote_product_id AS quote_product_id_21,
  t2.assigned_items_id AS assigned_items_id_22,
  t2.created_by_user_id AS created_by_user_id_23,
  t2.last_updated_by_user_id AS last_updated_by_user_id_24,
  t2.assigned_user_id AS assigned_user_id_25
FROM
  assigned_items t0
  LEFT JOIN job t2 ON t2.assigned_items_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t2.id AS id_3, t2.kind AS kind_4, t2.completed_at_timestamp AS completed_at_timestamp_5, t2.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_6, t2.specification AS specification_7, t2.reviewed_at_timestamp AS reviewed_at_timestamp_8, t2.stock_status AS stock_status_9, t2.created_at_timestamp AS created_at_timestamp_10, t2.updated_at_timestamp AS updated_at_timestamp_11, t2.status AS status_12, t2.booked_at_timestamp AS booked_at_timestamp_13, t2.metadata AS metadata_14, t2.arrival_timestamp AS arrival_timestamp_15, t2.leaving_timestamp AS leaving_timestamp_16, t2.display_id AS display_id_17, t2.project_id AS project_id_18, t2.reviewed_by_user_id AS reviewed_by_user_id_19, t2.trainer_user_id AS trainer_user_id_20, t2.quote_product_id AS quote_product_id_21, t2.assigned_items_id AS assigned_items_id_22, t2.created_by_user_id AS created_by_user_id_23, t2.last_updated_by_user_id AS last_updated_by_user_id_24, t2.assigned_user_id AS assigned_user_id_25 FROM assigned_items t0 LEFT JOIN job t2 ON t2.assigned_items_id = t0.id WHERE t0.id = 4633;

SELECT
  t0.id AS id_1,
  t0.item_condition AS item_condition_2,
  t0.specification AS specification_3,
  t0.name AS name_4,
  t0.sku AS sku_5,
  t0.warranty_in_months AS warranty_in_months_6,
  t0.created_at_timestamp AS created_at_timestamp_7,
  t0.updated_at_timestamp AS updated_at_timestamp_8,
  t0.serial_number AS serial_number_9,
  t0.status AS status_10,
  t0.is_deleted AS is_deleted_11,
  t0.deleted_at_timestamp AS deleted_at_timestamp_12,
  t0.template_id AS template_id_13,
  t0.location_id AS location_id_14,
  t0.assigned_items_id AS assigned_items_id_15,
  t0.customer_id AS customer_id_16,
  t0.brand_id AS brand_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.deleted_by_user_id AS deleted_by_user_id_20
FROM
  item t0
WHERE
  t0.assigned_items_id = ?

SELECT t0.id AS id_1, t0.item_condition AS item_condition_2, t0.specification AS specification_3, t0.name AS name_4, t0.sku AS sku_5, t0.warranty_in_months AS warranty_in_months_6, t0.created_at_timestamp AS created_at_timestamp_7, t0.updated_at_timestamp AS updated_at_timestamp_8, t0.serial_number AS serial_number_9, t0.status AS status_10, t0.is_deleted AS is_deleted_11, t0.deleted_at_timestamp AS deleted_at_timestamp_12, t0.template_id AS template_id_13, t0.location_id AS location_id_14, t0.assigned_items_id AS assigned_items_id_15, t0.customer_id AS customer_id_16, t0.brand_id AS brand_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.deleted_by_user_id AS deleted_by_user_id_20 FROM item t0 WHERE t0.assigned_items_id = 4633;

SELECT
  t0.id AS id_1,
  t0.item_condition AS item_condition_2,
  t0.specification AS specification_3,
  t0.name AS name_4,
  t0.sku AS sku_5,
  t0.warranty_in_months AS warranty_in_months_6,
  t0.created_at_timestamp AS created_at_timestamp_7,
  t0.updated_at_timestamp AS updated_at_timestamp_8,
  t0.serial_number AS serial_number_9,
  t0.status AS status_10,
  t0.is_deleted AS is_deleted_11,
  t0.deleted_at_timestamp AS deleted_at_timestamp_12,
  t0.template_id AS template_id_13,
  t0.location_id AS location_id_14,
  t0.assigned_items_id AS assigned_items_id_15,
  t0.customer_id AS customer_id_16,
  t0.brand_id AS brand_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.deleted_by_user_id AS deleted_by_user_id_20
FROM
  item t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.item_condition AS item_condition_2, t0.specification AS specification_3, t0.name AS name_4, t0.sku AS sku_5, t0.warranty_in_months AS warranty_in_months_6, t0.created_at_timestamp AS created_at_timestamp_7, t0.updated_at_timestamp AS updated_at_timestamp_8, t0.serial_number AS serial_number_9, t0.status AS status_10, t0.is_deleted AS is_deleted_11, t0.deleted_at_timestamp AS deleted_at_timestamp_12, t0.template_id AS template_id_13, t0.location_id AS location_id_14, t0.assigned_items_id AS assigned_items_id_15, t0.customer_id AS customer_id_16, t0.brand_id AS brand_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.deleted_by_user_id AS deleted_by_user_id_20 FROM item t0 WHERE t0.customer_id = 19817;

SELECT
  t0.id AS id_1,
  t0.tracking_number AS tracking_number_2,
  t0.created_at_timestamp AS created_at_timestamp_3,
  t0.updated_at_timestamp AS updated_at_timestamp_4,
  t0.courier_id AS courier_id_5,
  t0.job_id AS job_id_6,
  t0.created_by_user_id AS created_by_user_id_7,
  t0.last_updated_by_user_id AS last_updated_by_user_id_8
FROM
  courier_receipt t0
WHERE
  t0.job_id = ?

SELECT t0.id AS id_1, t0.tracking_number AS tracking_number_2, t0.created_at_timestamp AS created_at_timestamp_3, t0.updated_at_timestamp AS updated_at_timestamp_4, t0.courier_id AS courier_id_5, t0.job_id AS job_id_6, t0.created_by_user_id AS created_by_user_id_7, t0.last_updated_by_user_id AS last_updated_by_user_id_8 FROM courier_receipt t0 WHERE t0.job_id = 15691;

SELECT
  t0.id AS id_1,
  t0.created_at_timestamp AS created_at_timestamp_2,
  t0.updated_at_timestamp AS updated_at_timestamp_3,
  t0.status AS status_4,
  t0.display_id AS display_id_5,
  t0.metadata AS metadata_6,
  t0.job_id AS job_id_7,
  t8.id AS id_9,
  t8.created_at_timestamp AS created_at_timestamp_10,
  t8.updated_at_timestamp AS updated_at_timestamp_11,
  t8.display_id AS display_id_12,
  t8.location_id AS location_id_13,
  t8.pick_order_id AS pick_order_id_14,
  t8.created_by_user_id AS created_by_user_id_15,
  t8.last_updated_by_user_id AS last_updated_by_user_id_16,
  t0.created_by_user_id AS created_by_user_id_17,
  t0.last_updated_by_user_id AS last_updated_by_user_id_18
FROM
  pick_order t0
  LEFT JOIN pick_receipt t8 ON t8.pick_order_id = t0.id
WHERE
  t0.job_id = ?

SELECT t0.id AS id_1, t0.created_at_timestamp AS created_at_timestamp_2, t0.updated_at_timestamp AS updated_at_timestamp_3, t0.status AS status_4, t0.display_id AS display_id_5, t0.metadata AS metadata_6, t0.job_id AS job_id_7, t8.id AS id_9, t8.created_at_timestamp AS created_at_timestamp_10, t8.updated_at_timestamp AS updated_at_timestamp_11, t8.display_id AS display_id_12, t8.location_id AS location_id_13, t8.pick_order_id AS pick_order_id_14, t8.created_by_user_id AS created_by_user_id_15, t8.last_updated_by_user_id AS last_updated_by_user_id_16, t0.created_by_user_id AS created_by_user_id_17, t0.last_updated_by_user_id AS last_updated_by_user_id_18 FROM pick_order t0 LEFT JOIN pick_receipt t8 ON t8.pick_order_id = t0.id WHERE t0.job_id = 15691;

SELECT
  t0.id AS id_1,
  t0.reason AS reason_2,
  t0.status AS status_3,
  t0.display_id AS display_id_4,
  t0.created_at_timestamp AS created_at_timestamp_5,
  t0.updated_at_timestamp AS updated_at_timestamp_6,
  t0.is_deleted AS is_deleted_7,
  t0.deleted_at_timestamp AS deleted_at_timestamp_8,
  t0.new_location_id AS new_location_id_9,
  t0.reviewed_by_user_id AS reviewed_by_user_id_10,
  t0.job_id AS job_id_11,
  t0.created_by_user_id AS created_by_user_id_12,
  t0.last_updated_by_user_id AS last_updated_by_user_id_13,
  t0.deleted_by_user_id AS deleted_by_user_id_14
FROM
  return_request t0
WHERE
  t0.job_id = ?

SELECT t0.id AS id_1, t0.reason AS reason_2, t0.status AS status_3, t0.display_id AS display_id_4, t0.created_at_timestamp AS created_at_timestamp_5, t0.updated_at_timestamp AS updated_at_timestamp_6, t0.is_deleted AS is_deleted_7, t0.deleted_at_timestamp AS deleted_at_timestamp_8, t0.new_location_id AS new_location_id_9, t0.reviewed_by_user_id AS reviewed_by_user_id_10, t0.job_id AS job_id_11, t0.created_by_user_id AS created_by_user_id_12, t0.last_updated_by_user_id AS last_updated_by_user_id_13, t0.deleted_by_user_id AS deleted_by_user_id_14 FROM return_request t0 WHERE t0.job_id = 15691;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.location AS location_3,
  t0.mime_type AS mime_type_4,
  t0.size_in_bytes AS size_in_bytes_5,
  t0.original_name AS original_name_6,
  t0.created_at_timestamp AS created_at_timestamp_7,
  t0.updated_at_timestamp AS updated_at_timestamp_8,
  t0.project_id AS project_id_9,
  t0.job_id AS job_id_10,
  t0.created_by_user_id AS created_by_user_id_11,
  t0.last_updated_by_user_id AS last_updated_by_user_id_12
FROM
  project_file t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.location AS location_3, t0.mime_type AS mime_type_4, t0.size_in_bytes AS size_in_bytes_5, t0.original_name AS original_name_6, t0.created_at_timestamp AS created_at_timestamp_7, t0.updated_at_timestamp AS updated_at_timestamp_8, t0.project_id AS project_id_9, t0.job_id AS job_id_10, t0.created_by_user_id AS created_by_user_id_11, t0.last_updated_by_user_id AS last_updated_by_user_id_12 FROM project_file t0 WHERE t0.project_id = 19850;

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_.sales_department AS sales_department_11,
  u0_.last_activity_timestamp AS last_activity_timestamp_12,
  u0_.password_reset_token AS password_reset_token_13,
  u0_.hex_colour AS hex_colour_14
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_.sales_department AS sales_department_11, u0_.last_activity_timestamp AS last_activity_timestamp_12, u0_.password_reset_token AS password_reset_token_13, u0_.hex_colour AS hex_colour_14 FROM user u0_ WHERE u0_.roles NOT LIKE '%ROLE_HIDDEN%' AND u0_.status = 1 ORDER BY u0_.name ASC;