Symfony Profiler

SET
  search_path TO bws_dev_hr

SET search_path TO bws_dev_hr;

SELECT
  count(DISTINCT n0_.id) AS sclr_0
FROM
  node n0_
WHERE
  n0_.node_type = ?
  AND n0_.status = ?

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM node n0_ WHERE n0_.node_type = 'read' AND n0_.status = 1;

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.node_order AS node_order_1,
  n0_.changed_at AS changed_at_2
FROM
  node n0_
WHERE
  n0_.node_type = ?
  AND n0_.status = ?
ORDER BY
  n0_.node_order ASC,
  n0_.changed_at DESC
LIMIT
  100

SELECT DISTINCT n0_.id AS id_0, n0_.node_order AS node_order_1, n0_.changed_at AS changed_at_2 FROM node n0_ WHERE n0_.node_type = 'read' AND n0_.status = 1 ORDER BY n0_.node_order ASC, n0_.changed_at DESC LIMIT 100;

SELECT
  n0_.id AS id_0,
  n0_.slug AS slug_1,
  n0_.body AS body_2,
  n0_.node_type AS node_type_3,
  n0_.title AS title_4,
  n0_.status AS status_5,
  n0_.created_at AS created_at_6,
  n0_.changed_at AS changed_at_7,
  n0_.meta AS meta_8,
  n0_.node_order AS node_order_9,
  n0_.language AS language_10,
  n0_.owner_id AS owner_id_11
FROM
  node n0_
WHERE
  n0_.node_type = ?
  AND n0_.status = ?
  AND n0_.id IN (?)
ORDER BY
  n0_.node_order ASC,
  n0_.changed_at DESC

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.body AS body_2, n0_.node_type AS node_type_3, n0_.title AS title_4, n0_.status AS status_5, n0_.created_at AS created_at_6, n0_.changed_at AS changed_at_7, n0_.meta AS meta_8, n0_.node_order AS node_order_9, n0_.language AS language_10, n0_.owner_id AS owner_id_11 FROM node n0_ WHERE n0_.node_type = 'read' AND n0_.status = 1 AND n0_.id IN (1) ORDER BY n0_.node_order ASC, n0_.changed_at DESC;

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

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