Symfony Profiler

SET
  search_path TO bws_dev_hr

SET search_path TO bws_dev_hr;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.uuid AS uuid_4,
  u0_.data AS data_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.active AS active_8,
  u0_.middle_name AS middle_name_9,
  u0_.avatar AS avatar_10,
  u0_.changed AS changed_11,
  u0_.guardian AS guardian_12,
  u0_.logged_in_at AS logged_in_at_13,
  u0_.first_login_at AS first_login_at_14,
  u0_.username AS username_15,
  u0_.birthdate AS birthdate_16,
  u0_.student_password_is_set AS student_password_is_set_17,
  u0_.internal_registration AS internal_registration_18,
  u0_.organisations AS organisations_19,
  u0_.cookies_compliance AS cookies_compliance_20,
  u0_.full_time_access AS full_time_access_21,
  u0_.created_at AS created_at_22,
  u0_.login_token AS login_token_23
FROM
  user_entity_table u0_
WHERE
  LOWER(u0_.email) = LOWER(?)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.uuid AS uuid_4, u0_.data AS data_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.active AS active_8, u0_.middle_name AS middle_name_9, u0_.avatar AS avatar_10, u0_.changed AS changed_11, u0_.guardian AS guardian_12, u0_.logged_in_at AS logged_in_at_13, u0_.first_login_at AS first_login_at_14, u0_.username AS username_15, u0_.birthdate AS birthdate_16, u0_.student_password_is_set AS student_password_is_set_17, u0_.internal_registration AS internal_registration_18, u0_.organisations AS organisations_19, u0_.cookies_compliance AS cookies_compliance_20, u0_.full_time_access AS full_time_access_21, u0_.created_at AS created_at_22, u0_.login_token AS login_token_23 FROM user_entity_table u0_ WHERE LOWER(u0_.email) = LOWER('authoring.testing+automationsuperadmin@gmail.com');

SELECT
  t0.id AS id_1,
  t0.mobile_phone AS mobile_phone_2,
  t0.token AS token_3,
  t0.user_id AS user_id_4
FROM
  verified_mobilephone t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.mobile_phone AS mobile_phone_2, t0.token AS token_3, t0.user_id AS user_id_4 FROM verified_mobilephone t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4
FROM
  registration t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM registration t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.max_devices AS max_devices_2,
  t0.expire_at AS expire_at_3,
  t0.user_id AS user_id_4
FROM
  user_devices_settings t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.max_devices AS max_devices_2, t0.expire_at AS expire_at_3, t0.user_id AS user_id_4 FROM user_devices_settings t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.data AS data_3,
  t0.is_confirmed AS is_confirmed_4,
  t0.changed_at AS changed_at_5,
  t0.email AS email_6,
  t0.user_id AS user_id_7
FROM
  external_registration t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.data AS data_3, t0.is_confirmed AS is_confirmed_4, t0.changed_at AS changed_at_5, t0.email AS email_6, t0.user_id AS user_id_7 FROM external_registration t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.type AS type_3,
  t0.status AS status_4,
  t0.changed_at AS changed_at_5,
  t0.expiry_at AS expiry_at_6,
  t0.user_id AS user_id_7
FROM
  external_user_connection t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.type AS type_3, t0.status AS status_4, t0.changed_at AS changed_at_5, t0.expiry_at AS expiry_at_6, t0.user_id AS user_id_7 FROM external_user_connection t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.aliases AS aliases_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5
FROM
  ext_user_aliases t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.aliases AS aliases_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM ext_user_aliases t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.uuid AS uuid_5,
  t0.data AS data_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.active AS active_9,
  t0.middle_name AS middle_name_10,
  t0.avatar AS avatar_11,
  t0.changed AS changed_12,
  t0.guardian AS guardian_13,
  t0.logged_in_at AS logged_in_at_14,
  t0.first_login_at AS first_login_at_15,
  t0.username AS username_16,
  t0.birthdate AS birthdate_17,
  t0.student_password_is_set AS student_password_is_set_18,
  t0.internal_registration AS internal_registration_19,
  t0.organisations AS organisations_20,
  t0.cookies_compliance AS cookies_compliance_21,
  t0.full_time_access AS full_time_access_22,
  t0.created_at AS created_at_23,
  t0.login_token AS login_token_24,
  t25.id AS id_26,
  t25.mobile_phone AS mobile_phone_27,
  t25.token AS token_28,
  t25.user_id AS user_id_29,
  t30.id AS id_31,
  t30.token AS token_32,
  t30.created_at AS created_at_33,
  t30.user_id AS user_id_34,
  t35.id AS id_36,
  t35.max_devices AS max_devices_37,
  t35.expire_at AS expire_at_38,
  t35.user_id AS user_id_39,
  t40.id AS id_41,
  t40.token AS token_42,
  t40.data AS data_43,
  t40.is_confirmed AS is_confirmed_44,
  t40.changed_at AS changed_at_45,
  t40.email AS email_46,
  t40.user_id AS user_id_47,
  t48.id AS id_49,
  t48.external_id AS external_id_50,
  t48.type AS type_51,
  t48.status AS status_52,
  t48.changed_at AS changed_at_53,
  t48.expiry_at AS expiry_at_54,
  t48.user_id AS user_id_55,
  t56.id AS id_57,
  t56.aliases AS aliases_58,
  t56.created_at AS created_at_59,
  t56.updated_at AS updated_at_60,
  t56.user_id AS user_id_61
FROM
  user_entity_table t0
  LEFT JOIN verified_mobilephone t25 ON t25.user_id = t0.id
  LEFT JOIN registration t30 ON t30.user_id = t0.id
  LEFT JOIN user_devices_settings t35 ON t35.user_id = t0.id
  LEFT JOIN external_registration t40 ON t40.user_id = t0.id
  LEFT JOIN external_user_connection t48 ON t48.user_id = t0.id
  LEFT JOIN ext_user_aliases t56 ON t56.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.uuid AS uuid_5, t0.data AS data_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.active AS active_9, t0.middle_name AS middle_name_10, t0.avatar AS avatar_11, t0.changed AS changed_12, t0.guardian AS guardian_13, t0.logged_in_at AS logged_in_at_14, t0.first_login_at AS first_login_at_15, t0.username AS username_16, t0.birthdate AS birthdate_17, t0.student_password_is_set AS student_password_is_set_18, t0.internal_registration AS internal_registration_19, t0.organisations AS organisations_20, t0.cookies_compliance AS cookies_compliance_21, t0.full_time_access AS full_time_access_22, t0.created_at AS created_at_23, t0.login_token AS login_token_24, t25.id AS id_26, t25.mobile_phone AS mobile_phone_27, t25.token AS token_28, t25.user_id AS user_id_29, t30.id AS id_31, t30.token AS token_32, t30.created_at AS created_at_33, t30.user_id AS user_id_34, t35.id AS id_36, t35.max_devices AS max_devices_37, t35.expire_at AS expire_at_38, t35.user_id AS user_id_39, t40.id AS id_41, t40.token AS token_42, t40.data AS data_43, t40.is_confirmed AS is_confirmed_44, t40.changed_at AS changed_at_45, t40.email AS email_46, t40.user_id AS user_id_47, t48.id AS id_49, t48.external_id AS external_id_50, t48.type AS type_51, t48.status AS status_52, t48.changed_at AS changed_at_53, t48.expiry_at AS expiry_at_54, t48.user_id AS user_id_55, t56.id AS id_57, t56.aliases AS aliases_58, t56.created_at AS created_at_59, t56.updated_at AS updated_at_60, t56.user_id AS user_id_61 FROM user_entity_table t0 LEFT JOIN verified_mobilephone t25 ON t25.user_id = t0.id LEFT JOIN registration t30 ON t30.user_id = t0.id LEFT JOIN user_devices_settings t35 ON t35.user_id = t0.id LEFT JOIN external_registration t40 ON t40.user_id = t0.id LEFT JOIN external_user_connection t48 ON t48.user_id = t0.id LEFT JOIN ext_user_aliases t56 ON t56.user_id = t0.id WHERE t0.email = 'authoring.testing+automationsuperadmin@gmail.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.options AS options_3,
  t0.language AS language_4
FROM
  school_group t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.options AS options_3, t0.language AS language_4 FROM school_group t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.data AS data_3
FROM
  config t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3 FROM config t0 WHERE t0.name = 'schoolGroupsOrder' LIMIT 1;