Symfony Profiler

SELECT
  u.id,
  u.email,
  u.login,
  u.phone,
  u.password_hash,
  u.status,
  u.profile_id,
  u.parent_id,
  u.position_id,
  u.is_resident,
  u.is_eds,
  r.role_constant as role,
  r.permissions,
  po.inn organization_inn,
  c.thumbprint
FROM
  user_users u
  INNER JOIN roles r ON u.role_id = r.id
  LEFT JOIN profile_profiles pr ON u.profile_id = pr.id
  LEFT JOIN certificates c ON u.id = c.user_id
  AND c.status = ?
  LEFT JOIN profile_organizations po ON pr.organization_id = po.id
WHERE
  u.login = ?
  OR u.email = ?
ORDER BY
  u.status ASC,
  u.created_at DESC

SELECT u.id, u.email, u.login, u.phone, u.password_hash, u.status, u.profile_id, u.parent_id, u.position_id, u.is_resident, u.is_eds, r.role_constant as role, r.permissions, po.inn organization_inn, c.thumbprint FROM user_users u INNER JOIN roles r ON u.role_id = r.id LEFT JOIN profile_profiles pr ON u.profile_id = pr.id LEFT JOIN certificates c ON u.id = c.user_id AND c.status = 'STATUS_ACTIVE' LEFT JOIN profile_organizations po ON pr.organization_id = po.id WHERE u.login = 'admin' OR u.email = 'admin' ORDER BY u.status ASC, u.created_at DESC;

SELECT
  t.id,
  t.status,
  t.created_at,
  t.contract_period,
  t.payment_id,
  t.type type_profile,
  t.additional_info,
  t.is_smb,
  t.is_usn,
  t.additional_info,
  r.role_constant role_constant,
  r.permissions role_permissions,
  t.type role_name,
  t.incorporated_form,
  t.is_resident as is_profile_resident,
  re.position,
  re.confirming_document,
  re.phone,
  re.passport_number,
  re.passport_series,
  re.passport_issuer,
  re.passport_owner_contact_person_full_name,
  re.passport_issuance_date,
  re.passport_citizenship,
  re.passport_unit_code,
  re.passport_birth_day,
  re.passport_fact_country,
  re.passport_fact_region,
  re.passport_fact_district,
  re.passport_fact_populated_area,
  re.passport_fact_city,
  re.passport_fact_index,
  re.passport_fact_street,
  re.passport_fact_house,
  re.passport_fact_office,
  re.passport_fact_okato,
  re.passport_legal_country,
  re.passport_legal_region,
  re.passport_legal_district,
  re.passport_legal_populated_area,
  re.passport_legal_city,
  re.passport_legal_index,
  re.passport_legal_street,
  re.passport_legal_house,
  re.passport_legal_office,
  re.passport_legal_okato,
  re.additional_phone,
  re.passport_inn,
  re.passport_inn repr_passport_inn,
  re.passport_snils,
  o.full_title_organization,
  o.short_title_organization,
  o.kpp,
  o.ogrn,
  o.email org_email,
  o.inn,
  o.phone organization_phone,
  o.owner_full_name organization_owner_full_name,
  o.owner_contact_person_full_name organization_owner_contact_person_full_name,
  o.fact_country,
  o.fact_region,
  o.fact_district,
  o.fact_populated_area,
  o.fact_city,
  o.fact_index,
  o.fact_street,
  o.fact_house,
  o.fact_office,
  o.fact_okato,
  o.legal_country,
  o.legal_district,
  o.legal_populated_area,
  o.legal_region,
  o.legal_city,
  o.legal_index,
  o.legal_street,
  o.legal_house,
  o.legal_office,
  o.legal_okato,
  o.okpo,
  o.okopf,
  o.registration_date,
  c.thumbprint certificate_thumbprint,
  c.id certificate_id,
  c.subject_name_owner certificate_owner,
  c.valid_from certificate_valid_from,
  c.valid_to certificate_valid_to,
  c.subject_name_inn certificate_subject_name_inn,
  c.subject_name_snils certificate_subject_name_snils,
  u.email user_email,
  u.id user_id,
  u.is_eds is_eds_user,
  u.full_name_first_name,
  u.full_name_last_name,
  u.full_name_middle_name,
  u.is_resident as is_user_resident,
  u.esia_oid as user_esia_oid,
  TRIM(
    CONCAT(
      u.full_name_last_name, ' ', u.full_name_first_name,
      ' ', u.full_name_middle_name
    )
  ) AS user_name,
  tz.title time_zone,
  tz.id time_zone_id,
  tz.value time_zone_value,
  tz.title as time_zone_title,
  tz.value as time_zone_customer
FROM
  profile_profiles t
  LEFT JOIN certificates c ON t.certificate_id = c.id
  INNER JOIN user_users u ON t.user_id = u.id
  INNER JOIN roles r ON u.role_id = r.id
  LEFT JOIN profile_organizations o ON t.organization_id = o.id
  INNER JOIN profile_representatives re ON t.representative_id = re.id
  LEFT JOIN time_zones tz ON t.time_zone_id = tz.id
WHERE
  t.id = ?

SELECT t.id, t.status, t.created_at, t.contract_period, t.payment_id, t.type type_profile, t.additional_info, t.is_smb, t.is_usn, t.additional_info, r.role_constant role_constant, r.permissions role_permissions, t.type role_name, t.incorporated_form, t.is_resident as is_profile_resident, re.position, re.confirming_document, re.phone, re.passport_number, re.passport_series, re.passport_issuer, re.passport_owner_contact_person_full_name, re.passport_issuance_date, re.passport_citizenship, re.passport_unit_code, re.passport_birth_day, re.passport_fact_country, re.passport_fact_region, re.passport_fact_district, re.passport_fact_populated_area, re.passport_fact_city, re.passport_fact_index, re.passport_fact_street, re.passport_fact_house, re.passport_fact_office, re.passport_fact_okato, re.passport_legal_country, re.passport_legal_region, re.passport_legal_district, re.passport_legal_populated_area, re.passport_legal_city, re.passport_legal_index, re.passport_legal_street, re.passport_legal_house, re.passport_legal_office, re.passport_legal_okato, re.additional_phone, re.passport_inn, re.passport_inn repr_passport_inn, re.passport_snils, o.full_title_organization, o.short_title_organization, o.kpp, o.ogrn, o.email org_email, o.inn, o.phone organization_phone, o.owner_full_name organization_owner_full_name, o.owner_contact_person_full_name organization_owner_contact_person_full_name, o.fact_country, o.fact_region, o.fact_district, o.fact_populated_area, o.fact_city, o.fact_index, o.fact_street, o.fact_house, o.fact_office, o.fact_okato, o.legal_country, o.legal_district, o.legal_populated_area, o.legal_region, o.legal_city, o.legal_index, o.legal_street, o.legal_house, o.legal_office, o.legal_okato, o.okpo, o.okopf, o.registration_date, c.thumbprint certificate_thumbprint, c.id certificate_id, c.subject_name_owner certificate_owner, c.valid_from certificate_valid_from, c.valid_to certificate_valid_to, c.subject_name_inn certificate_subject_name_inn, c.subject_name_snils certificate_subject_name_snils, u.email user_email, u.id user_id, u.is_eds is_eds_user, u.full_name_first_name, u.full_name_last_name, u.full_name_middle_name, u.is_resident as is_user_resident, u.esia_oid as user_esia_oid, TRIM(CONCAT(u.full_name_last_name, ' ', u.full_name_first_name, ' ', u.full_name_middle_name)) AS user_name, tz.title time_zone, tz.id time_zone_id, tz.value time_zone_value, tz.title as time_zone_title, tz.value as time_zone_customer FROM profile_profiles t LEFT JOIN certificates c ON t.certificate_id = c.id INNER JOIN user_users u ON t.user_id = u.id INNER JOIN roles r ON u.role_id = r.id LEFT JOIN profile_organizations o ON t.organization_id = o.id INNER JOIN profile_representatives re ON t.representative_id = re.id LEFT JOIN time_zones tz ON t.time_zone_id = tz.id WHERE t.id = NULL;

SELECT
  u.id,
  u.is_allowed_poa,
  u.login,
  u.phone,
  u.email,
  u.status,
  u.created_at,
  u.client_ip,
  u.password_hash,
  u.confirm_token_expires,
  u.is_eds,
  u.is_resident,
  p.registration_date,
  p.id profile_id,
  p.status as profile_status,
  p.incorporated_form,
  p.contract_period,
  u.role_id,
  r.role_constant as role,
  r.permissions,
  u.full_name_first_name,
  u.full_name_last_name,
  u.full_name_middle_name,
  u.position_id,
  u.parent_id,
  u.esia_oid,
  TRIM(
    CONCAT(
      u.full_name_last_name, ' ', u.full_name_first_name,
      ' ', u.full_name_middle_name
    )
  ) AS user_name,
  o.full_title_organization,
  u.additional_phone,
  p.section_id,
  s.name section_name,
  CASE WHEN p.id IS NOT NULL THEN
    p.id
  WHEN po.profile_id IS NOT NULL THEN
    po.profile_id
  else
    NULL
  END AS profile_id
FROM
  user_users u
  LEFT JOIN profile_profiles p ON u.profile_id = p.id
  INNER JOIN roles r ON u.role_id = r.id
  LEFT JOIN profile_organizations o ON p.organization_id = o.id
  LEFT JOIN sections s ON p.section_id = s.id
  LEFT JOIN profile_organization_positions po ON u.position_id = po.id
WHERE
  u.id = ?

SELECT u.id, u.is_allowed_poa, u.login, u.phone, u.email, u.status, u.created_at, u.client_ip, u.password_hash, u.confirm_token_expires, u.is_eds, u.is_resident, p.registration_date, p.id profile_id, p.status as profile_status, p.incorporated_form, p.contract_period, u.role_id, r.role_constant as role, r.permissions, u.full_name_first_name, u.full_name_last_name, u.full_name_middle_name, u.position_id, u.parent_id, u.esia_oid, TRIM(CONCAT(u.full_name_last_name, ' ', u.full_name_first_name, ' ', u.full_name_middle_name)) AS user_name, o.full_title_organization, u.additional_phone, p.section_id, s.name section_name, CASE 
                    WHEN p.id IS NOT NULL THEN p.id
                    WHEN po.profile_id IS NOT NULL THEN po.profile_id
                    else NULL
                 END AS profile_id FROM user_users u LEFT JOIN profile_profiles p ON u.profile_id = p.id INNER JOIN roles r ON u.role_id = r.id LEFT JOIN profile_organizations o ON p.organization_id = o.id LEFT JOIN sections s ON p.section_id = s.id LEFT JOIN profile_organization_positions po ON u.position_id = po.id WHERE u.id = '6d05f12f-c61a-4492-97fe-16205629ef04';

SELECT
  t.id,
  t.status,
  t.created_at,
  t.contract_period,
  t.payment_id,
  t.type type_profile,
  t.additional_info,
  t.is_smb,
  t.is_usn,
  t.additional_info,
  r.role_constant role_constant,
  r.permissions role_permissions,
  t.type role_name,
  t.incorporated_form,
  t.is_resident as is_profile_resident,
  re.position,
  re.confirming_document,
  re.phone,
  re.passport_number,
  re.passport_series,
  re.passport_issuer,
  re.passport_owner_contact_person_full_name,
  re.passport_issuance_date,
  re.passport_citizenship,
  re.passport_unit_code,
  re.passport_birth_day,
  re.passport_fact_country,
  re.passport_fact_region,
  re.passport_fact_district,
  re.passport_fact_populated_area,
  re.passport_fact_city,
  re.passport_fact_index,
  re.passport_fact_street,
  re.passport_fact_house,
  re.passport_fact_office,
  re.passport_fact_okato,
  re.passport_legal_country,
  re.passport_legal_region,
  re.passport_legal_district,
  re.passport_legal_populated_area,
  re.passport_legal_city,
  re.passport_legal_index,
  re.passport_legal_street,
  re.passport_legal_house,
  re.passport_legal_office,
  re.passport_legal_okato,
  re.additional_phone,
  re.passport_inn,
  re.passport_inn repr_passport_inn,
  re.passport_snils,
  o.full_title_organization,
  o.short_title_organization,
  o.kpp,
  o.ogrn,
  o.email org_email,
  o.inn,
  o.phone organization_phone,
  o.owner_full_name organization_owner_full_name,
  o.owner_contact_person_full_name organization_owner_contact_person_full_name,
  o.fact_country,
  o.fact_region,
  o.fact_district,
  o.fact_populated_area,
  o.fact_city,
  o.fact_index,
  o.fact_street,
  o.fact_house,
  o.fact_office,
  o.fact_okato,
  o.legal_country,
  o.legal_district,
  o.legal_populated_area,
  o.legal_region,
  o.legal_city,
  o.legal_index,
  o.legal_street,
  o.legal_house,
  o.legal_office,
  o.legal_okato,
  o.okpo,
  o.okopf,
  o.registration_date,
  c.thumbprint certificate_thumbprint,
  c.id certificate_id,
  c.subject_name_owner certificate_owner,
  c.valid_from certificate_valid_from,
  c.valid_to certificate_valid_to,
  c.subject_name_inn certificate_subject_name_inn,
  c.subject_name_snils certificate_subject_name_snils,
  u.email user_email,
  u.id user_id,
  u.is_eds is_eds_user,
  u.full_name_first_name,
  u.full_name_last_name,
  u.full_name_middle_name,
  u.is_resident as is_user_resident,
  u.esia_oid as user_esia_oid,
  TRIM(
    CONCAT(
      u.full_name_last_name, ' ', u.full_name_first_name,
      ' ', u.full_name_middle_name
    )
  ) AS user_name,
  tz.title time_zone,
  tz.id time_zone_id,
  tz.value time_zone_value,
  tz.title as time_zone_title,
  tz.value as time_zone_customer
FROM
  profile_profiles t
  LEFT JOIN certificates c ON t.certificate_id = c.id
  INNER JOIN user_users u ON t.user_id = u.id
  INNER JOIN roles r ON u.role_id = r.id
  LEFT JOIN profile_organizations o ON t.organization_id = o.id
  INNER JOIN profile_representatives re ON t.representative_id = re.id
  LEFT JOIN time_zones tz ON t.time_zone_id = tz.id
WHERE
  t.id = ?

SELECT t.id, t.status, t.created_at, t.contract_period, t.payment_id, t.type type_profile, t.additional_info, t.is_smb, t.is_usn, t.additional_info, r.role_constant role_constant, r.permissions role_permissions, t.type role_name, t.incorporated_form, t.is_resident as is_profile_resident, re.position, re.confirming_document, re.phone, re.passport_number, re.passport_series, re.passport_issuer, re.passport_owner_contact_person_full_name, re.passport_issuance_date, re.passport_citizenship, re.passport_unit_code, re.passport_birth_day, re.passport_fact_country, re.passport_fact_region, re.passport_fact_district, re.passport_fact_populated_area, re.passport_fact_city, re.passport_fact_index, re.passport_fact_street, re.passport_fact_house, re.passport_fact_office, re.passport_fact_okato, re.passport_legal_country, re.passport_legal_region, re.passport_legal_district, re.passport_legal_populated_area, re.passport_legal_city, re.passport_legal_index, re.passport_legal_street, re.passport_legal_house, re.passport_legal_office, re.passport_legal_okato, re.additional_phone, re.passport_inn, re.passport_inn repr_passport_inn, re.passport_snils, o.full_title_organization, o.short_title_organization, o.kpp, o.ogrn, o.email org_email, o.inn, o.phone organization_phone, o.owner_full_name organization_owner_full_name, o.owner_contact_person_full_name organization_owner_contact_person_full_name, o.fact_country, o.fact_region, o.fact_district, o.fact_populated_area, o.fact_city, o.fact_index, o.fact_street, o.fact_house, o.fact_office, o.fact_okato, o.legal_country, o.legal_district, o.legal_populated_area, o.legal_region, o.legal_city, o.legal_index, o.legal_street, o.legal_house, o.legal_office, o.legal_okato, o.okpo, o.okopf, o.registration_date, c.thumbprint certificate_thumbprint, c.id certificate_id, c.subject_name_owner certificate_owner, c.valid_from certificate_valid_from, c.valid_to certificate_valid_to, c.subject_name_inn certificate_subject_name_inn, c.subject_name_snils certificate_subject_name_snils, u.email user_email, u.id user_id, u.is_eds is_eds_user, u.full_name_first_name, u.full_name_last_name, u.full_name_middle_name, u.is_resident as is_user_resident, u.esia_oid as user_esia_oid, TRIM(CONCAT(u.full_name_last_name, ' ', u.full_name_first_name, ' ', u.full_name_middle_name)) AS user_name, tz.title time_zone, tz.id time_zone_id, tz.value time_zone_value, tz.title as time_zone_title, tz.value as time_zone_customer FROM profile_profiles t LEFT JOIN certificates c ON t.certificate_id = c.id INNER JOIN user_users u ON t.user_id = u.id INNER JOIN roles r ON u.role_id = r.id LEFT JOIN profile_organizations o ON t.organization_id = o.id INNER JOIN profile_representatives re ON t.representative_id = re.id LEFT JOIN time_zones tz ON t.time_zone_id = tz.id WHERE t.id = NULL;

SELECT
  id,
  thumbprint,
  created_at,
  archived_date,
  valid_from,
  valid_to,
  status,
  subject_name_organization_full_name,
  subject_name_snils,
  subject_name_inn,
  subject_name_owner,
  subject_name_position,
  subject_name_user_name,
  subject_name_region,
  subject_name_city,
  subject_name_street,
  issuer_name_issuer,
  issuer_name_unit_organization,
  issuer_name_inn,
  issuer_name_ogrn,
  issuer_name_email,
  issuer_name_region,
  issuer_name_city,
  issuer_name_street
FROM
  certificates
WHERE
  (user_id = ?)
  AND (status = ?)

SELECT id, thumbprint, created_at, archived_date, valid_from, valid_to, status, subject_name_organization_full_name, subject_name_snils, subject_name_inn, subject_name_owner, subject_name_position, subject_name_user_name, subject_name_region, subject_name_city, subject_name_street, issuer_name_issuer, issuer_name_unit_organization, issuer_name_inn, issuer_name_ogrn, issuer_name_email, issuer_name_region, issuer_name_city, issuer_name_street FROM certificates WHERE (user_id = '6d05f12f-c61a-4492-97fe-16205629ef04') AND (status = 'STATUS_ACTIVE');

SELECT
  u.id,
  u.is_allowed_poa,
  u.login,
  u.phone,
  u.email,
  u.status,
  u.created_at,
  u.client_ip,
  u.password_hash,
  u.confirm_token_expires,
  u.is_eds,
  u.is_resident,
  p.registration_date,
  p.id profile_id,
  p.status as profile_status,
  p.incorporated_form,
  p.contract_period,
  u.role_id,
  r.role_constant as role,
  r.permissions,
  u.full_name_first_name,
  u.full_name_last_name,
  u.full_name_middle_name,
  u.position_id,
  u.parent_id,
  u.esia_oid,
  TRIM(
    CONCAT(
      u.full_name_last_name, ' ', u.full_name_first_name,
      ' ', u.full_name_middle_name
    )
  ) AS user_name,
  o.full_title_organization,
  u.additional_phone,
  p.section_id,
  s.name section_name,
  CASE WHEN p.id IS NOT NULL THEN
    p.id
  WHEN po.profile_id IS NOT NULL THEN
    po.profile_id
  else
    NULL
  END AS profile_id
FROM
  user_users u
  LEFT JOIN profile_profiles p ON u.profile_id = p.id
  INNER JOIN roles r ON u.role_id = r.id
  LEFT JOIN profile_organizations o ON p.organization_id = o.id
  LEFT JOIN sections s ON p.section_id = s.id
  LEFT JOIN profile_organization_positions po ON u.position_id = po.id
WHERE
  u.id = ?

SELECT u.id, u.is_allowed_poa, u.login, u.phone, u.email, u.status, u.created_at, u.client_ip, u.password_hash, u.confirm_token_expires, u.is_eds, u.is_resident, p.registration_date, p.id profile_id, p.status as profile_status, p.incorporated_form, p.contract_period, u.role_id, r.role_constant as role, r.permissions, u.full_name_first_name, u.full_name_last_name, u.full_name_middle_name, u.position_id, u.parent_id, u.esia_oid, TRIM(CONCAT(u.full_name_last_name, ' ', u.full_name_first_name, ' ', u.full_name_middle_name)) AS user_name, o.full_title_organization, u.additional_phone, p.section_id, s.name section_name, CASE 
                    WHEN p.id IS NOT NULL THEN p.id
                    WHEN po.profile_id IS NOT NULL THEN po.profile_id
                    else NULL
                 END AS profile_id FROM user_users u LEFT JOIN profile_profiles p ON u.profile_id = p.id INNER JOIN roles r ON u.role_id = r.id LEFT JOIN profile_organizations o ON p.organization_id = o.id LEFT JOIN sections s ON p.section_id = s.id LEFT JOIN profile_organization_positions po ON u.position_id = po.id WHERE u.id = '6d05f12f-c61a-4492-97fe-16205629ef04';

SELECT
  t.id,
  t.status,
  t.created_at,
  t.contract_period,
  t.payment_id,
  t.type type_profile,
  t.additional_info,
  t.is_smb,
  t.is_usn,
  t.additional_info,
  r.role_constant role_constant,
  r.permissions role_permissions,
  t.type role_name,
  t.incorporated_form,
  t.is_resident as is_profile_resident,
  re.position,
  re.confirming_document,
  re.phone,
  re.passport_number,
  re.passport_series,
  re.passport_issuer,
  re.passport_owner_contact_person_full_name,
  re.passport_issuance_date,
  re.passport_citizenship,
  re.passport_unit_code,
  re.passport_birth_day,
  re.passport_fact_country,
  re.passport_fact_region,
  re.passport_fact_district,
  re.passport_fact_populated_area,
  re.passport_fact_city,
  re.passport_fact_index,
  re.passport_fact_street,
  re.passport_fact_house,
  re.passport_fact_office,
  re.passport_fact_okato,
  re.passport_legal_country,
  re.passport_legal_region,
  re.passport_legal_district,
  re.passport_legal_populated_area,
  re.passport_legal_city,
  re.passport_legal_index,
  re.passport_legal_street,
  re.passport_legal_house,
  re.passport_legal_office,
  re.passport_legal_okato,
  re.additional_phone,
  re.passport_inn,
  re.passport_inn repr_passport_inn,
  re.passport_snils,
  o.full_title_organization,
  o.short_title_organization,
  o.kpp,
  o.ogrn,
  o.email org_email,
  o.inn,
  o.phone organization_phone,
  o.owner_full_name organization_owner_full_name,
  o.owner_contact_person_full_name organization_owner_contact_person_full_name,
  o.fact_country,
  o.fact_region,
  o.fact_district,
  o.fact_populated_area,
  o.fact_city,
  o.fact_index,
  o.fact_street,
  o.fact_house,
  o.fact_office,
  o.fact_okato,
  o.legal_country,
  o.legal_district,
  o.legal_populated_area,
  o.legal_region,
  o.legal_city,
  o.legal_index,
  o.legal_street,
  o.legal_house,
  o.legal_office,
  o.legal_okato,
  o.okpo,
  o.okopf,
  o.registration_date,
  c.thumbprint certificate_thumbprint,
  c.id certificate_id,
  c.subject_name_owner certificate_owner,
  c.valid_from certificate_valid_from,
  c.valid_to certificate_valid_to,
  c.subject_name_inn certificate_subject_name_inn,
  c.subject_name_snils certificate_subject_name_snils,
  u.email user_email,
  u.id user_id,
  u.is_eds is_eds_user,
  u.full_name_first_name,
  u.full_name_last_name,
  u.full_name_middle_name,
  u.is_resident as is_user_resident,
  u.esia_oid as user_esia_oid,
  TRIM(
    CONCAT(
      u.full_name_last_name, ' ', u.full_name_first_name,
      ' ', u.full_name_middle_name
    )
  ) AS user_name,
  tz.title time_zone,
  tz.id time_zone_id,
  tz.value time_zone_value,
  tz.title as time_zone_title,
  tz.value as time_zone_customer
FROM
  profile_profiles t
  LEFT JOIN certificates c ON t.certificate_id = c.id
  INNER JOIN user_users u ON t.user_id = u.id
  INNER JOIN roles r ON u.role_id = r.id
  LEFT JOIN profile_organizations o ON t.organization_id = o.id
  INNER JOIN profile_representatives re ON t.representative_id = re.id
  LEFT JOIN time_zones tz ON t.time_zone_id = tz.id
WHERE
  t.id = ?

SELECT t.id, t.status, t.created_at, t.contract_period, t.payment_id, t.type type_profile, t.additional_info, t.is_smb, t.is_usn, t.additional_info, r.role_constant role_constant, r.permissions role_permissions, t.type role_name, t.incorporated_form, t.is_resident as is_profile_resident, re.position, re.confirming_document, re.phone, re.passport_number, re.passport_series, re.passport_issuer, re.passport_owner_contact_person_full_name, re.passport_issuance_date, re.passport_citizenship, re.passport_unit_code, re.passport_birth_day, re.passport_fact_country, re.passport_fact_region, re.passport_fact_district, re.passport_fact_populated_area, re.passport_fact_city, re.passport_fact_index, re.passport_fact_street, re.passport_fact_house, re.passport_fact_office, re.passport_fact_okato, re.passport_legal_country, re.passport_legal_region, re.passport_legal_district, re.passport_legal_populated_area, re.passport_legal_city, re.passport_legal_index, re.passport_legal_street, re.passport_legal_house, re.passport_legal_office, re.passport_legal_okato, re.additional_phone, re.passport_inn, re.passport_inn repr_passport_inn, re.passport_snils, o.full_title_organization, o.short_title_organization, o.kpp, o.ogrn, o.email org_email, o.inn, o.phone organization_phone, o.owner_full_name organization_owner_full_name, o.owner_contact_person_full_name organization_owner_contact_person_full_name, o.fact_country, o.fact_region, o.fact_district, o.fact_populated_area, o.fact_city, o.fact_index, o.fact_street, o.fact_house, o.fact_office, o.fact_okato, o.legal_country, o.legal_district, o.legal_populated_area, o.legal_region, o.legal_city, o.legal_index, o.legal_street, o.legal_house, o.legal_office, o.legal_okato, o.okpo, o.okopf, o.registration_date, c.thumbprint certificate_thumbprint, c.id certificate_id, c.subject_name_owner certificate_owner, c.valid_from certificate_valid_from, c.valid_to certificate_valid_to, c.subject_name_inn certificate_subject_name_inn, c.subject_name_snils certificate_subject_name_snils, u.email user_email, u.id user_id, u.is_eds is_eds_user, u.full_name_first_name, u.full_name_last_name, u.full_name_middle_name, u.is_resident as is_user_resident, u.esia_oid as user_esia_oid, TRIM(CONCAT(u.full_name_last_name, ' ', u.full_name_first_name, ' ', u.full_name_middle_name)) AS user_name, tz.title time_zone, tz.id time_zone_id, tz.value time_zone_value, tz.title as time_zone_title, tz.value as time_zone_customer FROM profile_profiles t LEFT JOIN certificates c ON t.certificate_id = c.id INNER JOIN user_users u ON t.user_id = u.id INNER JOIN roles r ON u.role_id = r.id LEFT JOIN profile_organizations o ON t.organization_id = o.id INNER JOIN profile_representatives re ON t.representative_id = re.id LEFT JOIN time_zones tz ON t.time_zone_id = tz.id WHERE t.id = NULL;

SELECT
  t.id,
  t.status,
  t.created_at,
  t.contract_period,
  t.payment_id,
  t.type type_profile,
  t.additional_info,
  t.is_smb,
  t.is_usn,
  t.additional_info,
  r.role_constant role_constant,
  r.permissions role_permissions,
  t.type role_name,
  t.incorporated_form,
  t.is_resident as is_profile_resident,
  re.position,
  re.confirming_document,
  re.phone,
  re.passport_number,
  re.passport_series,
  re.passport_issuer,
  re.passport_owner_contact_person_full_name,
  re.passport_issuance_date,
  re.passport_citizenship,
  re.passport_unit_code,
  re.passport_birth_day,
  re.passport_fact_country,
  re.passport_fact_region,
  re.passport_fact_district,
  re.passport_fact_populated_area,
  re.passport_fact_city,
  re.passport_fact_index,
  re.passport_fact_street,
  re.passport_fact_house,
  re.passport_fact_office,
  re.passport_fact_okato,
  re.passport_legal_country,
  re.passport_legal_region,
  re.passport_legal_district,
  re.passport_legal_populated_area,
  re.passport_legal_city,
  re.passport_legal_index,
  re.passport_legal_street,
  re.passport_legal_house,
  re.passport_legal_office,
  re.passport_legal_okato,
  re.additional_phone,
  re.passport_inn,
  re.passport_inn repr_passport_inn,
  re.passport_snils,
  o.full_title_organization,
  o.short_title_organization,
  o.kpp,
  o.ogrn,
  o.email org_email,
  o.inn,
  o.phone organization_phone,
  o.owner_full_name organization_owner_full_name,
  o.owner_contact_person_full_name organization_owner_contact_person_full_name,
  o.fact_country,
  o.fact_region,
  o.fact_district,
  o.fact_populated_area,
  o.fact_city,
  o.fact_index,
  o.fact_street,
  o.fact_house,
  o.fact_office,
  o.fact_okato,
  o.legal_country,
  o.legal_district,
  o.legal_populated_area,
  o.legal_region,
  o.legal_city,
  o.legal_index,
  o.legal_street,
  o.legal_house,
  o.legal_office,
  o.legal_okato,
  o.okpo,
  o.okopf,
  o.registration_date,
  c.thumbprint certificate_thumbprint,
  c.id certificate_id,
  c.subject_name_owner certificate_owner,
  c.valid_from certificate_valid_from,
  c.valid_to certificate_valid_to,
  c.subject_name_inn certificate_subject_name_inn,
  c.subject_name_snils certificate_subject_name_snils,
  u.email user_email,
  u.id user_id,
  u.is_eds is_eds_user,
  u.full_name_first_name,
  u.full_name_last_name,
  u.full_name_middle_name,
  u.is_resident as is_user_resident,
  u.esia_oid as user_esia_oid,
  TRIM(
    CONCAT(
      u.full_name_last_name, ' ', u.full_name_first_name,
      ' ', u.full_name_middle_name
    )
  ) AS user_name,
  tz.title time_zone,
  tz.id time_zone_id,
  tz.value time_zone_value,
  tz.title as time_zone_title,
  tz.value as time_zone_customer
FROM
  profile_profiles t
  LEFT JOIN certificates c ON t.certificate_id = c.id
  INNER JOIN user_users u ON t.user_id = u.id
  INNER JOIN roles r ON u.role_id = r.id
  LEFT JOIN profile_organizations o ON t.organization_id = o.id
  INNER JOIN profile_representatives re ON t.representative_id = re.id
  LEFT JOIN time_zones tz ON t.time_zone_id = tz.id
WHERE
  t.id = ?