Symfony Profiler

SELECT
  t0.user_id AS user_id_1,
  t0.password AS password_2,
  t0.roles AS roles_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.is_banned AS is_banned_6,
  t0.created_timestamp AS created_timestamp_7,
  t0.deleted_timestamp AS deleted_timestamp_8,
  t0.must_login_after AS must_login_after_9
FROM
  user_account_list t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.user_id AS user_id_1, t0.password AS password_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.is_banned AS is_banned_6, t0.created_timestamp AS created_timestamp_7, t0.deleted_timestamp AS deleted_timestamp_8, t0.must_login_after AS must_login_after_9 FROM user_account_list t0 WHERE t0.user_id = '019c059d-34d0-7844-b22d-6f9733cdff43' LIMIT 1;

SELECT
  t0.proxy_id AS proxy_id_1,
  t0.organisation_id AS organisation_id_2,
  t0.resource_type AS resource_type_3,
  t0.resource_id AS resource_id_4,
  t0.is_active AS is_active_5,
  t0.created_timestamp AS created_timestamp_6,
  t0.deleted_timestamp AS deleted_timestamp_7
FROM
  organisation_resource_proxy t0
WHERE
  t0.proxy_id = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.proxy_id AS proxy_id_1, t0.organisation_id AS organisation_id_2, t0.resource_type AS resource_type_3, t0.resource_id AS resource_id_4, t0.is_active AS is_active_5, t0.created_timestamp AS created_timestamp_6, t0.deleted_timestamp AS deleted_timestamp_7 FROM organisation_resource_proxy t0 WHERE t0.proxy_id = '019c059e-aa37-737c-8b9a-48863296191a' AND t0.is_active = 1 LIMIT 1;

SELECT
  o0_.organisation_id AS organisation_id_0,
  o0_.name AS name_1,
  o0_.plan_code AS plan_code_2,
  o0_.plan_selected_timestamp AS plan_selected_timestamp_3,
  o0_.created_timestamp AS created_timestamp_4,
  o0_.deleted_timestamp AS deleted_timestamp_5,
  o0_.deletion_scheduled_timestamp AS deletion_scheduled_timestamp_6
FROM
  organisation_list o0_
WHERE
  o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL

SELECT o0_.organisation_id AS organisation_id_0, o0_.name AS name_1, o0_.plan_code AS plan_code_2, o0_.plan_selected_timestamp AS plan_selected_timestamp_3, o0_.created_timestamp AS created_timestamp_4, o0_.deleted_timestamp AS deleted_timestamp_5, o0_.deletion_scheduled_timestamp AS deletion_scheduled_timestamp_6 FROM organisation_list o0_ WHERE o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL;

SELECT
  o0_.id AS id_0,
  o0_.contact_id AS contact_id_1,
  o0_.organisation_id AS organisation_id_2,
  o0_.scope_type AS scope_type_3,
  o0_.scope_id AS scope_id_4,
  o0_.permission_level AS permission_level_5,
  o0_.created_timestamp AS created_timestamp_6,
  o0_.deleted_timestamp AS deleted_timestamp_7,
  o0_.user_id AS user_id_8
FROM
  organisation_team_permission o0_
WHERE
  o0_.user_id = ?
  AND o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL

SELECT o0_.id AS id_0, o0_.contact_id AS contact_id_1, o0_.organisation_id AS organisation_id_2, o0_.scope_type AS scope_type_3, o0_.scope_id AS scope_id_4, o0_.permission_level AS permission_level_5, o0_.created_timestamp AS created_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o0_.user_id AS user_id_8 FROM organisation_team_permission o0_ WHERE o0_.user_id = '019c059d-34d0-7844-b22d-6f9733cdff43' AND o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL;

SELECT
  t0.list_id AS list_id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.list_type AS list_type_4,
  t0.query_definition AS query_definition_5,
  t0.created_timestamp AS created_timestamp_6,
  t0.updated_timestamp AS updated_timestamp_7,
  t0.snapshot_timestamp AS snapshot_timestamp_8,
  t0.deleted_timestamp AS deleted_timestamp_9,
  t0.organisation_id AS organisation_id_10
FROM
  organisation_contact_list_definition t0
WHERE
  t0.list_id = ?

SELECT t0.list_id AS list_id_1, t0.name AS name_2, t0.description AS description_3, t0.list_type AS list_type_4, t0.query_definition AS query_definition_5, t0.created_timestamp AS created_timestamp_6, t0.updated_timestamp AS updated_timestamp_7, t0.snapshot_timestamp AS snapshot_timestamp_8, t0.deleted_timestamp AS deleted_timestamp_9, t0.organisation_id AS organisation_id_10 FROM organisation_contact_list_definition t0 WHERE t0.list_id = '019c47ff-d440-7c95-a70a-94213d0e43d1';

SELECT
  o0_.field_definition_id AS field_definition_id_0,
  o0_.field_name AS field_name_1,
  o0_.field_label AS field_label_2,
  o0_.field_type AS field_type_3,
  o0_.is_required AS is_required_4,
  o0_.display_order AS display_order_5,
  o0_.field_settings AS field_settings_6,
  o0_.created_timestamp AS created_timestamp_7,
  o0_.updated_timestamp AS updated_timestamp_8,
  o0_.deleted_timestamp AS deleted_timestamp_9,
  o1_.option_id AS option_id_10,
  o1_.option_label AS option_label_11,
  o1_.option_value AS option_value_12,
  o1_.display_order AS display_order_13,
  o1_.is_active AS is_active_14,
  o1_.created_timestamp AS created_timestamp_15,
  o0_.organisation_id AS organisation_id_16,
  o1_.field_definition_id AS field_definition_id_17
FROM
  organisation_contact_field_definition o0_
  LEFT JOIN organisation_contact_field_option o1_ ON o0_.field_definition_id = o1_.field_definition_id
WHERE
  o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL
ORDER BY
  o0_.display_order ASC,
  o0_.field_name ASC,
  o1_.display_order ASC

SELECT o0_.field_definition_id AS field_definition_id_0, o0_.field_name AS field_name_1, o0_.field_label AS field_label_2, o0_.field_type AS field_type_3, o0_.is_required AS is_required_4, o0_.display_order AS display_order_5, o0_.field_settings AS field_settings_6, o0_.created_timestamp AS created_timestamp_7, o0_.updated_timestamp AS updated_timestamp_8, o0_.deleted_timestamp AS deleted_timestamp_9, o1_.option_id AS option_id_10, o1_.option_label AS option_label_11, o1_.option_value AS option_value_12, o1_.display_order AS display_order_13, o1_.is_active AS is_active_14, o1_.created_timestamp AS created_timestamp_15, o0_.organisation_id AS organisation_id_16, o1_.field_definition_id AS field_definition_id_17 FROM organisation_contact_field_definition o0_ LEFT JOIN organisation_contact_field_option o1_ ON o0_.field_definition_id = o1_.field_definition_id WHERE o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL ORDER BY o0_.display_order ASC, o0_.field_name ASC, o1_.display_order ASC;

SELECT
  o0_.contact_id AS contact_id_0,
  o0_.contact_email AS contact_email_1,
  o0_.first_name AS first_name_2,
  o0_.last_name AS last_name_3,
  o0_.tags AS tags_4,
  o0_.created_timestamp AS created_timestamp_5,
  o0_.updated_timestamp AS updated_timestamp_6,
  o0_.deleted_timestamp AS deleted_timestamp_7,
  o1_.field_id AS field_id_8,
  o1_.field_value AS field_value_9,
  o1_.created_timestamp AS created_timestamp_10,
  o1_.updated_timestamp AS updated_timestamp_11,
  o2_.field_definition_id AS field_definition_id_12,
  o2_.field_name AS field_name_13,
  o2_.field_label AS field_label_14,
  o2_.field_type AS field_type_15,
  o2_.is_required AS is_required_16,
  o2_.display_order AS display_order_17,
  o2_.field_settings AS field_settings_18,
  o2_.created_timestamp AS created_timestamp_19,
  o2_.updated_timestamp AS updated_timestamp_20,
  o2_.deleted_timestamp AS deleted_timestamp_21,
  o0_.organisation_id AS organisation_id_22,
  o0_.user_id AS user_id_23,
  o1_.contact_id AS contact_id_24,
  o1_.field_definition_id AS field_definition_id_25,
  o2_.organisation_id AS organisation_id_26
FROM
  organisation_contact_list o0_
  LEFT JOIN organisation_contact_custom_field o1_ ON o0_.contact_id = o1_.contact_id
  LEFT JOIN organisation_contact_field_definition o2_ ON o1_.field_definition_id = o2_.field_definition_id
WHERE
  o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL
ORDER BY
  o0_.created_timestamp DESC

SELECT o0_.contact_id AS contact_id_0, o0_.contact_email AS contact_email_1, o0_.first_name AS first_name_2, o0_.last_name AS last_name_3, o0_.tags AS tags_4, o0_.created_timestamp AS created_timestamp_5, o0_.updated_timestamp AS updated_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o1_.field_id AS field_id_8, o1_.field_value AS field_value_9, o1_.created_timestamp AS created_timestamp_10, o1_.updated_timestamp AS updated_timestamp_11, o2_.field_definition_id AS field_definition_id_12, o2_.field_name AS field_name_13, o2_.field_label AS field_label_14, o2_.field_type AS field_type_15, o2_.is_required AS is_required_16, o2_.display_order AS display_order_17, o2_.field_settings AS field_settings_18, o2_.created_timestamp AS created_timestamp_19, o2_.updated_timestamp AS updated_timestamp_20, o2_.deleted_timestamp AS deleted_timestamp_21, o0_.organisation_id AS organisation_id_22, o0_.user_id AS user_id_23, o1_.contact_id AS contact_id_24, o1_.field_definition_id AS field_definition_id_25, o2_.organisation_id AS organisation_id_26 FROM organisation_contact_list o0_ LEFT JOIN organisation_contact_custom_field o1_ ON o0_.contact_id = o1_.contact_id LEFT JOIN organisation_contact_field_definition o2_ ON o1_.field_definition_id = o2_.field_definition_id WHERE o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL ORDER BY o0_.created_timestamp DESC;