Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.email AS email_4,
  t0.dni AS dni_5,
  t0.document_type AS document_type_6,
  t0.mobile_phone AS mobile_phone_7,
  t0.office_phone AS office_phone_8,
  t0.position AS position_9,
  t0.address AS address_10,
  t0.city AS city_11,
  t0.state AS state_12,
  t0.zip_code AS zip_code_13,
  t0.country AS country_14,
  t0.locale AS locale_15,
  t0.reset_password_token AS reset_password_token_16,
  t0.password AS password_17,
  t0.roles AS roles_18,
  t0.mobile_phone_available_time AS mobile_phone_available_time_19,
  t0.office_phone_available_time AS office_phone_available_time_20,
  t0.is_favorite AS is_favorite_21,
  t0.can_receive_notifications AS can_receive_notifications_22,
  t0.privacy_policy_accepted_at AS privacy_policy_accepted_at_23,
  t0.password_changed_at AS password_changed_at_24,
  t0.disabled_at AS disabled_at_25,
  t0.previous_login_ip AS previous_login_ip_26,
  t0.previous_login_at AS previous_login_at_27,
  t0.last_login_ip AS last_login_ip_28,
  t0.last_login_at AS last_login_at_29,
  t0.tos_accepted_at AS tos_accepted_at_30,
  t0.auth_code AS auth_code_31,
  t0.double_factor_method AS double_factor_method_32,
  t0.expires_at AS expires_at_33,
  t0.failed_password_attempts AS failed_password_attempts_34,
  t0.failed_password_locked_at AS failed_password_locked_at_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.default_customer_id AS default_customer_id_38,
  t0.default_provider_id AS default_provider_id_39,
  t0.backoffice_profile_id AS backoffice_profile_id_40
FROM
  users t0
WHERE
  t0.email = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.dni AS dni_5, t0.document_type AS document_type_6, t0.mobile_phone AS mobile_phone_7, t0.office_phone AS office_phone_8, t0.position AS position_9, t0.address AS address_10, t0.city AS city_11, t0.state AS state_12, t0.zip_code AS zip_code_13, t0.country AS country_14, t0.locale AS locale_15, t0.reset_password_token AS reset_password_token_16, t0.password AS password_17, t0.roles AS roles_18, t0.mobile_phone_available_time AS mobile_phone_available_time_19, t0.office_phone_available_time AS office_phone_available_time_20, t0.is_favorite AS is_favorite_21, t0.can_receive_notifications AS can_receive_notifications_22, t0.privacy_policy_accepted_at AS privacy_policy_accepted_at_23, t0.password_changed_at AS password_changed_at_24, t0.disabled_at AS disabled_at_25, t0.previous_login_ip AS previous_login_ip_26, t0.previous_login_at AS previous_login_at_27, t0.last_login_ip AS last_login_ip_28, t0.last_login_at AS last_login_at_29, t0.tos_accepted_at AS tos_accepted_at_30, t0.auth_code AS auth_code_31, t0.double_factor_method AS double_factor_method_32, t0.expires_at AS expires_at_33, t0.failed_password_attempts AS failed_password_attempts_34, t0.failed_password_locked_at AS failed_password_locked_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.default_customer_id AS default_customer_id_38, t0.default_provider_id AS default_provider_id_39, t0.backoffice_profile_id AS backoffice_profile_id_40 FROM users t0 WHERE t0.email = 'matiasgutierrez.dev@gmail.com' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT
  b0_.access_key AS access_key_0
FROM
  backoffice_permission b0_

SELECT b0_.access_key AS access_key_0 FROM backoffice_permission b0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  backoffice_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM backoffice_profile t0 WHERE t0.id = 'e2a6cbbb-ea32-11ef-a96c-000c291403de';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.access_key AS access_key_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.backoffice_permission_type_id AS backoffice_permission_type_id_7
FROM
  backoffice_permission t0
  INNER JOIN backoffice_profile_backoffice_permission ON t0.id = backoffice_profile_backoffice_permission.backoffice_permission_id
WHERE
  backoffice_profile_backoffice_permission.backoffice_profile_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.backoffice_permission_type_id AS backoffice_permission_type_id_7 FROM backoffice_permission t0 INNER JOIN backoffice_profile_backoffice_permission ON t0.id = backoffice_profile_backoffice_permission.backoffice_permission_id WHERE backoffice_profile_backoffice_permission.backoffice_profile_id = 'e2a6cbbb-ea32-11ef-a96c-000c291403de';

SELECT
  DISTINCT id_0,
  MIN(sclr_23) AS dctrn_minrownum
FROM
  (
    SELECT
      c0_.id AS id_0,
      c0_.external_id AS external_id_1,
      c0_.code AS code_2,
      c0_.name AS name_3,
      c0_.tin AS tin_4,
      c0_.status AS status_5,
      c0_.type AS type_6,
      c0_.company_type AS company_type_7,
      c0_.address AS address_8,
      c0_.city AS city_9,
      c0_.state AS state_10,
      c0_.zip_code AS zip_code_11,
      c0_.country AS country_12,
      c0_.notification_phone AS notification_phone_13,
      c0_.notification_email AS notification_email_14,
      c0_.technical_phone AS technical_phone_15,
      c0_.technical_email AS technical_email_16,
      c0_.observation AS observation_17,
      c0_.disabled_at AS disabled_at_18,
      c0_.can_be_hired AS can_be_hired_19,
      c0_.id_customer_sst AS id_customer_sst_20,
      c0_.created_at AS created_at_21,
      c0_.updated_at AS updated_at_22,
      ROW_NUMBER() OVER(
        ORDER BY
          c0_.name ASC
      ) AS sclr_23
    FROM
      customer c0_
      INNER JOIN user_customer u2_ ON c0_.id = u2_.customer_id
      INNER JOIN users u1_ ON u1_.id = u2_.user_id
    WHERE
      u1_.id = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
OFFSET
  0
ROWS
FETCH
  NEXT 10
ROWS
  ONLY

SELECT DISTINCT id_0, MIN(sclr_23) AS dctrn_minrownum FROM (SELECT c0_.id AS id_0, c0_.external_id AS external_id_1, c0_.code AS code_2, c0_.name AS name_3, c0_.tin AS tin_4, c0_.status AS status_5, c0_.type AS type_6, c0_.company_type AS company_type_7, c0_.address AS address_8, c0_.city AS city_9, c0_.state AS state_10, c0_.zip_code AS zip_code_11, c0_.country AS country_12, c0_.notification_phone AS notification_phone_13, c0_.notification_email AS notification_email_14, c0_.technical_phone AS technical_phone_15, c0_.technical_email AS technical_email_16, c0_.observation AS observation_17, c0_.disabled_at AS disabled_at_18, c0_.can_be_hired AS can_be_hired_19, c0_.id_customer_sst AS id_customer_sst_20, c0_.created_at AS created_at_21, c0_.updated_at AS updated_at_22, ROW_NUMBER() OVER(ORDER BY c0_.name ASC) AS sclr_23 FROM customer c0_ INNER JOIN user_customer u2_ ON c0_.id = u2_.customer_id INNER JOIN users u1_ ON u1_.id = u2_.user_id WHERE u1_.id = '30b5bec2-ac18-4f66-a56a-744842b31bb7') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  customer c0_
  INNER JOIN user_customer u2_ ON c0_.id = u2_.customer_id
  INNER JOIN users u1_ ON u1_.id = u2_.user_id
WHERE
  u1_.id = ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer c0_ INNER JOIN user_customer u2_ ON c0_.id = u2_.customer_id INNER JOIN users u1_ ON u1_.id = u2_.user_id WHERE u1_.id = '30b5bec2-ac18-4f66-a56a-744842b31bb7';