Symfony Profiler

SELECT
  *
FROM
  af_users
WHERE
  deleted_at is null
  and blocked = 0
  and is_active = 1
  and email = ?

SELECT * FROM af_users WHERE deleted_at is null and blocked=0 and is_active=1 and email = 'abcnakolach_jk@koral.com.pl';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortname AS shortname_3,
  t0.uuid AS uuid_4,
  t0.created_at AS created_at_5,
  t0.create_ip AS create_ip_6,
  t0.deleted AS deleted_7,
  t0.deleted_at AS deleted_at_8,
  t0.active AS active_9,
  t0.delete_ip AS delete_ip_10,
  t0.created_by_id AS created_by_id_11,
  t0.deleted_by_id AS deleted_by_id_12
FROM
  af_contract_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.uuid AS uuid_4, t0.created_at AS created_at_5, t0.create_ip AS create_ip_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.active AS active_9, t0.delete_ip AS delete_ip_10, t0.created_by_id AS created_by_id_11, t0.deleted_by_id AS deleted_by_id_12 FROM af_contract_type t0 WHERE t0.id = 1;

SELECT
  d.*
from
  af_distributors_users du
  JOIN af_distributors d on (
    du.distributor_id = d.distributor_id
  )
WHERE
  du.user_id = ?
  AND d.settlement_year_id = ?

SELECT d.* from af_distributors_users du JOIN af_distributors d on (du.distributor_id=d.distributor_id) WHERE du.user_id= 651 AND d.settlement_year_id = 2020;

SELECT
  t0.distributor_id AS distributor_id_1,
  t0.client_id AS client_id_2,
  t0.name AS name_3,
  t0.short_name AS short_name_4,
  t0.nip AS nip_5,
  t0.zipcode AS zipcode_6,
  t0.city AS city_7,
  t0.street AS street_8,
  t0.house_number AS house_number_9,
  t0.flat_number AS flat_number_10,
  t0.phone AS phone_11,
  t0.fax AS fax_12,
  t0.email AS email_13,
  t0.created_at AS created_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.status AS status_16,
  t0.gln AS gln_17,
  t0.ossid AS ossid_18,
  t0.settlement_year_id AS settlement_year_id_19,
  t0.place_type AS place_type_20,
  t0.payment_type AS payment_type_21,
  t0.transport_type AS transport_type_22,
  t0.transport_factor AS transport_factor_23,
  t0.guardian_id AS guardian_id_24,
  t0.mach_id AS mach_id_25,
  t0.frs_total AS frs_total_26,
  t0.frs_total_copy AS frs_total_copy_27,
  t0.type_id AS type_id_28,
  t0.email_frs AS email_frs_29,
  t0.ext_freezers_reports AS ext_freezers_reports_30,
  t0.template_id AS template_id_31,
  t0.frs_max_devices AS frs_max_devices_32,
  t0.frs_extra_devices AS frs_extra_devices_33,
  t0.document_type AS document_type_34,
  t0.last_invoice_date AS last_invoice_date_35,
  t0.agreement_date AS agreement_date_36,
  t0.dist_turnover_enabled AS dist_turnover_enabled_37,
  t0.ph_id AS ph_id_38,
  t0.afm_id AS afm_id_39,
  t0.parent_id AS parent_id_40,
  t0.ph_gastro_id AS ph_gastro_id_41,
  t0.main_network_id AS main_network_id_42,
  t0.region_id AS region_id_43
FROM
  af_distributors t0
WHERE
  t0.distributor_id = ?

SELECT t0.distributor_id AS distributor_id_1, t0.client_id AS client_id_2, t0.name AS name_3, t0.short_name AS short_name_4, t0.nip AS nip_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.street AS street_8, t0.house_number AS house_number_9, t0.flat_number AS flat_number_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.email AS email_13, t0.created_at AS created_at_14, t0.deleted_at AS deleted_at_15, t0.status AS status_16, t0.gln AS gln_17, t0.ossid AS ossid_18, t0.settlement_year_id AS settlement_year_id_19, t0.place_type AS place_type_20, t0.payment_type AS payment_type_21, t0.transport_type AS transport_type_22, t0.transport_factor AS transport_factor_23, t0.guardian_id AS guardian_id_24, t0.mach_id AS mach_id_25, t0.frs_total AS frs_total_26, t0.frs_total_copy AS frs_total_copy_27, t0.type_id AS type_id_28, t0.email_frs AS email_frs_29, t0.ext_freezers_reports AS ext_freezers_reports_30, t0.template_id AS template_id_31, t0.frs_max_devices AS frs_max_devices_32, t0.frs_extra_devices AS frs_extra_devices_33, t0.document_type AS document_type_34, t0.last_invoice_date AS last_invoice_date_35, t0.agreement_date AS agreement_date_36, t0.dist_turnover_enabled AS dist_turnover_enabled_37, t0.ph_id AS ph_id_38, t0.afm_id AS afm_id_39, t0.parent_id AS parent_id_40, t0.ph_gastro_id AS ph_gastro_id_41, t0.main_network_id AS main_network_id_42, t0.region_id AS region_id_43 FROM af_distributors t0 WHERE t0.distributor_id = 1595;

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.title AS title_3,
  t0.contract_number AS contract_number_4,
  t0.client_id AS client_id_5,
  t0.uuid AS uuid_6,
  t0.created_at AS created_at_7,
  t0.create_ip AS create_ip_8,
  t0.deleted AS deleted_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.delete_ip AS delete_ip_12,
  t0.file_name AS file_name_13,
  t0.file_path AS file_path_14,
  t0.signed_at AS signed_at_15,
  t0.valid_from AS valid_from_16,
  t0.valid_to AS valid_to_17,
  t0.created_by_id AS created_by_id_18,
  t0.deleted_by_id AS deleted_by_id_19,
  t0.distributor_id AS distributor_id_20,
  t0.contract_type_id AS contract_type_id_21
FROM
  af_contract t0
WHERE
  t0.distributor_id = ?
  AND t0.deleted = ?
ORDER BY
  t0.signed_at ASC

SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.contract_number AS contract_number_4, t0.client_id AS client_id_5, t0.uuid AS uuid_6, t0.created_at AS created_at_7, t0.create_ip AS create_ip_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.delete_ip AS delete_ip_12, t0.file_name AS file_name_13, t0.file_path AS file_path_14, t0.signed_at AS signed_at_15, t0.valid_from AS valid_from_16, t0.valid_to AS valid_to_17, t0.created_by_id AS created_by_id_18, t0.deleted_by_id AS deleted_by_id_19, t0.distributor_id AS distributor_id_20, t0.contract_type_id AS contract_type_id_21 FROM af_contract t0 WHERE t0.distributor_id = 1595 AND t0.deleted = 0 ORDER BY t0.signed_at ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.create_ip AS create_ip_4,
  t0.deleted AS deleted_5,
  t0.deleted_at AS deleted_at_6,
  t0.active AS active_7,
  t0.delete_ip AS delete_ip_8,
  t0.sort AS sort_9,
  t0.color AS color_10,
  t0.created_by_id AS created_by_id_11,
  t0.deleted_by_id AS deleted_by_id_12
FROM
  af_contract_group t0
  INNER JOIN contract_group_contract_type ON t0.id = contract_group_contract_type.contract_group_id
WHERE
  contract_group_contract_type.contract_type_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.create_ip AS create_ip_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6, t0.active AS active_7, t0.delete_ip AS delete_ip_8, t0.sort AS sort_9, t0.color AS color_10, t0.created_by_id AS created_by_id_11, t0.deleted_by_id AS deleted_by_id_12 FROM af_contract_group t0 INNER JOIN contract_group_contract_type ON t0.id = contract_group_contract_type.contract_group_id WHERE contract_group_contract_type.contract_type_id = 1;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.created_at AS created_at_2,
  a0_.create_ip AS create_ip_3,
  a0_.deleted AS deleted_4,
  a0_.deleted_at AS deleted_at_5,
  a0_.active AS active_6,
  a0_.delete_ip AS delete_ip_7,
  a0_.sort AS sort_8,
  a0_.color AS color_9,
  a0_.created_by_id AS created_by_id_10,
  a0_.deleted_by_id AS deleted_by_id_11
FROM
  af_contract_group a0_
WHERE
  a0_.active = 1
  AND a0_.deleted = 0
ORDER BY
  a0_.sort ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.created_at AS created_at_2, a0_.create_ip AS create_ip_3, a0_.deleted AS deleted_4, a0_.deleted_at AS deleted_at_5, a0_.active AS active_6, a0_.delete_ip AS delete_ip_7, a0_.sort AS sort_8, a0_.color AS color_9, a0_.created_by_id AS created_by_id_10, a0_.deleted_by_id AS deleted_by_id_11 FROM af_contract_group a0_ WHERE a0_.active = 1 AND a0_.deleted = 0 ORDER BY a0_.sort ASC;

SELECT
  *
FROM
  af_users_area
WHERE
  user_id = ?

SELECT * FROM af_users_area WHERE user_id = 651;