Symfony Profiler

SELECT
  DISTINCT id_4
FROM
  (
    SELECT
      DISTINCT id_4
    FROM
      (
        SELECT
          t0_.taxonomy AS taxonomy_0,
          t0_.name AS name_1,
          t0_.name_tr AS name_tr_2,
          t0_.uid AS uid_3,
          t0_.id AS id_4,
          t0_.created_at AS created_at_5,
          t0_.deleted_at AS deleted_at_6,
          t0_.is_deleted AS is_deleted_7,
          t0_.updated_at AS updated_at_8
        FROM
          terms t0_
        WHERE
          t0_.company_id = ?
      ) dctrn_result_inner
    ORDER BY
      id_4 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_4 FROM (SELECT DISTINCT id_4 FROM (SELECT t0_.taxonomy AS taxonomy_0, t0_.name AS name_1, t0_.name_tr AS name_tr_2, t0_.uid AS uid_3, t0_.id AS id_4, t0_.created_at AS created_at_5, t0_.deleted_at AS deleted_at_6, t0_.is_deleted AS is_deleted_7, t0_.updated_at AS updated_at_8 FROM terms t0_ WHERE t0_.company_id = '2') dctrn_result_inner ORDER BY id_4 DESC) dctrn_result LIMIT 20;

SELECT
  t0.email AS email_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.full_name AS full_name_4,
  t0.is_active AS is_active_5,
  t0.roles AS roles_6,
  t0.is_back_office_user AS is_back_office_user_7,
  t0.password AS password_8,
  t0.auth_code AS auth_code_9,
  t0.temp_password AS temp_password_10,
  t0.google_auth_id AS google_auth_id_11,
  t0.uid AS uid_12,
  t0.forgot_password_created_time AS forgot_password_created_time_13,
  t0.forgot_password_updated_time AS forgot_password_updated_time_14,
  t0.id AS id_15,
  t0.created_at AS created_at_16,
  t17.avatar AS avatar_18,
  t17.greeting AS greeting_19,
  t17.title AS title_20,
  t17.gender AS gender_21,
  t17.name AS name_22,
  t17.middle_name AS middle_name_23,
  t17.surname AS surname_24,
  t17.name_org AS name_org_25,
  t17.middle_name_org AS middle_name_org_26,
  t17.surname_org AS surname_org_27,
  t17.identity_number AS identity_number_28,
  t17.birthday AS birthday_29,
  t17.nationality AS nationality_30,
  t17.phone AS phone_31,
  t17.email AS email_32,
  t17.company_uid AS company_uid_33,
  t17.employee_number AS employee_number_34,
  t17.division AS division_35,
  t17.location_id AS location_id_36,
  t17.department_customer_id AS department_customer_id_37,
  t17.cmg_number AS cmg_number_38,
  t17.project_number AS project_number_39,
  t17.sap_code AS sap_code_40,
  t17.id AS id_41,
  t17.created_at AS created_at_42,
  t17.deleted_at AS deleted_at_43,
  t17.is_deleted AS is_deleted_44,
  t17.company_id AS company_id_45,
  t17.related_user_id AS related_user_id_46,
  t17.department_id AS department_id_47,
  t17.job_title_id AS job_title_id_48,
  t17.cost_center_id AS cost_center_id_49,
  t17.rule_id AS rule_id_50,
  t17.created_by_id AS created_by_id_51,
  t17.deleted_by_id AS deleted_by_id_52,
  t0.company_id AS company_id_53,
  t0.created_by_id AS created_by_id_54
FROM
  users t0
  LEFT JOIN company_persons t17 ON t17.related_user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.email AS email_1, t0.name AS name_2, t0.surname AS surname_3, t0.full_name AS full_name_4, t0.is_active AS is_active_5, t0.roles AS roles_6, t0.is_back_office_user AS is_back_office_user_7, t0.password AS password_8, t0.auth_code AS auth_code_9, t0.temp_password AS temp_password_10, t0.google_auth_id AS google_auth_id_11, t0.uid AS uid_12, t0.forgot_password_created_time AS forgot_password_created_time_13, t0.forgot_password_updated_time AS forgot_password_updated_time_14, t0.id AS id_15, t0.created_at AS created_at_16, t17.avatar AS avatar_18, t17.greeting AS greeting_19, t17.title AS title_20, t17.gender AS gender_21, t17.name AS name_22, t17.middle_name AS middle_name_23, t17.surname AS surname_24, t17.name_org AS name_org_25, t17.middle_name_org AS middle_name_org_26, t17.surname_org AS surname_org_27, t17.identity_number AS identity_number_28, t17.birthday AS birthday_29, t17.nationality AS nationality_30, t17.phone AS phone_31, t17.email AS email_32, t17.company_uid AS company_uid_33, t17.employee_number AS employee_number_34, t17.division AS division_35, t17.location_id AS location_id_36, t17.department_customer_id AS department_customer_id_37, t17.cmg_number AS cmg_number_38, t17.project_number AS project_number_39, t17.sap_code AS sap_code_40, t17.id AS id_41, t17.created_at AS created_at_42, t17.deleted_at AS deleted_at_43, t17.is_deleted AS is_deleted_44, t17.company_id AS company_id_45, t17.related_user_id AS related_user_id_46, t17.department_id AS department_id_47, t17.job_title_id AS job_title_id_48, t17.cost_center_id AS cost_center_id_49, t17.rule_id AS rule_id_50, t17.created_by_id AS created_by_id_51, t17.deleted_by_id AS deleted_by_id_52, t0.company_id AS company_id_53, t0.created_by_id AS created_by_id_54 FROM users t0 LEFT JOIN company_persons t17 ON t17.related_user_id = t0.id WHERE t0.email = 'mustafa.turan@atgturkey.com' LIMIT 1;

SELECT
  t0_.taxonomy AS taxonomy_0,
  t0_.name AS name_1,
  t0_.name_tr AS name_tr_2,
  t0_.uid AS uid_3,
  t0_.id AS id_4,
  t0_.created_at AS created_at_5,
  t0_.deleted_at AS deleted_at_6,
  t0_.is_deleted AS is_deleted_7,
  t0_.updated_at AS updated_at_8
FROM
  terms t0_
WHERE
  t0_.company_id = ?
  AND t0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  t0_.id DESC

SELECT t0_.taxonomy AS taxonomy_0, t0_.name AS name_1, t0_.name_tr AS name_tr_2, t0_.uid AS uid_3, t0_.id AS id_4, t0_.created_at AS created_at_5, t0_.deleted_at AS deleted_at_6, t0_.is_deleted AS is_deleted_7, t0_.updated_at AS updated_at_8 FROM terms t0_ WHERE t0_.company_id = '2' AND t0_.id IN ('43', '42', '41', '40', '39', '38', '37', '36', '35', '34', '33', '32', '31', '30', '29', '28', '27', '26', '25', '24') ORDER BY t0_.id DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_4
    FROM
      (
        SELECT
          t0_.taxonomy AS taxonomy_0,
          t0_.name AS name_1,
          t0_.name_tr AS name_tr_2,
          t0_.uid AS uid_3,
          t0_.id AS id_4,
          t0_.created_at AS created_at_5,
          t0_.deleted_at AS deleted_at_6,
          t0_.is_deleted AS is_deleted_7,
          t0_.updated_at AS updated_at_8
        FROM
          terms t0_
        WHERE
          t0_.company_id = ?
        ORDER BY
          t0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT t0_.taxonomy AS taxonomy_0, t0_.name AS name_1, t0_.name_tr AS name_tr_2, t0_.uid AS uid_3, t0_.id AS id_4, t0_.created_at AS created_at_5, t0_.deleted_at AS deleted_at_6, t0_.is_deleted AS is_deleted_7, t0_.updated_at AS updated_at_8 FROM terms t0_ WHERE t0_.company_id = '2' ORDER BY t0_.id DESC) dctrn_result) dctrn_table;

SELECT
  t0.name AS name_1,
  t0.currency AS currency_2,
  t0.is_active AS is_active_3,
  t0.parent AS parent_4,
  t0.children AS children_5,
  t0.users AS users_6,
  t0.uid AS uid_7,
  t0.location_type AS location_type_8,
  t0.notification_email AS notification_email_9,
  t0.credit AS credit_10,
  t0.credit_balance AS credit_balance_11,
  t0.corporate_card_id AS corporate_card_id_12,
  t0.vat_number AS vat_number_13,
  t0.vat_office AS vat_office_14,
  t0.registration_number AS registration_number_15,
  t0.is_credit_active AS is_credit_active_16,
  t0.contact_name AS contact_name_17,
  t0.contact_phone AS contact_phone_18,
  t0.contact_email AS contact_email_19,
  t0.finance_contact_name AS finance_contact_name_20,
  t0.finance_contact_phone AS finance_contact_phone_21,
  t0.finance_contact_email AS finance_contact_email_22,
  t0.id AS id_23
FROM
  companies t0
WHERE
  t0.uid = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.currency AS currency_2, t0.is_active AS is_active_3, t0.parent AS parent_4, t0.children AS children_5, t0.users AS users_6, t0.uid AS uid_7, t0.location_type AS location_type_8, t0.notification_email AS notification_email_9, t0.credit AS credit_10, t0.credit_balance AS credit_balance_11, t0.corporate_card_id AS corporate_card_id_12, t0.vat_number AS vat_number_13, t0.vat_office AS vat_office_14, t0.registration_number AS registration_number_15, t0.is_credit_active AS is_credit_active_16, t0.contact_name AS contact_name_17, t0.contact_phone AS contact_phone_18, t0.contact_email AS contact_email_19, t0.finance_contact_name AS finance_contact_name_20, t0.finance_contact_phone AS finance_contact_phone_21, t0.finance_contact_email AS finance_contact_email_22, t0.id AS id_23 FROM companies t0 WHERE t0.uid = 'CF1A1BE' LIMIT 1;