| 2 |
1.39 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.birthdate AS birthdate_5, t0.ipn AS ipn_6, t0.phone AS phone_7, t0.erdpou AS erdpou_8, t0.site AS site_9, t0.address_legal AS address_legal_10, t0.address_actual AS address_actual_11, t0.work_start_date AS work_start_date_12, t0.uuid AS uuid_13, t0.type AS type_14, t0.active AS active_15, t0.plain_password AS plain_password_16, t0.full_name AS full_name_17, t0.direction AS direction_18, t0.balance AS balance_19, t0.last_login AS last_login_20, t0.login_count AS login_count_21 FROM "user" t0 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.birthdate AS birthdate_5, t0.ipn AS ipn_6, t0.phone AS phone_7, t0.erdpou AS erdpou_8, t0.site AS site_9, t0.address_legal AS address_legal_10, t0.address_actual AS address_actual_11, t0.work_start_date AS work_start_date_12, t0.uuid AS uuid_13, t0.type AS type_14, t0.active AS active_15, t0.plain_password AS plain_password_16, t0.full_name AS full_name_17, t0.direction AS direction_18, t0.balance AS balance_19, t0.last_login AS last_login_20, t0.login_count AS login_count_21 FROM "user" t0 WHERE t0.id = 1;
|
| 3 |
0.63 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.birthdate AS birthdate_5, t0.ipn AS ipn_6, t0.phone AS phone_7, t0.erdpou AS erdpou_8, t0.site AS site_9, t0.address_legal AS address_legal_10, t0.address_actual AS address_actual_11, t0.work_start_date AS work_start_date_12, t0.uuid AS uuid_13, t0.type AS type_14, t0.active AS active_15, t0.plain_password AS plain_password_16, t0.full_name AS full_name_17, t0.direction AS direction_18, t0.balance AS balance_19, t0.last_login AS last_login_20, t0.login_count AS login_count_21 FROM "user" t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"y.kozlov08@gmail.com"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.birthdate AS birthdate_5, t0.ipn AS ipn_6, t0.phone AS phone_7, t0.erdpou AS erdpou_8, t0.site AS site_9, t0.address_legal AS address_legal_10, t0.address_actual AS address_actual_11, t0.work_start_date AS work_start_date_12, t0.uuid AS uuid_13, t0.type AS type_14, t0.active AS active_15, t0.plain_password AS plain_password_16, t0.full_name AS full_name_17, t0.direction AS direction_18, t0.balance AS balance_19, t0.last_login AS last_login_20, t0.login_count AS login_count_21 FROM "user" t0 WHERE t0.email = 'y.kozlov08@gmail.com' LIMIT 1;
|
| 4 |
4.00 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.uuid AS uuid_2, a0_.description AS description_3, a0_.deleted AS deleted_4, a0_.code AS code_5, a0_.number AS number_6, a0_.type AS type_7, a0_.orenda AS orenda_8, a0_.date_from AS date_from_9, a0_.date_to AS date_to_10, a0_.balance AS balance_11, a0_.status AS status_12, u1_.id AS id_13, u1_.email AS email_14, u1_.roles AS roles_15, u1_.password AS password_16, u1_.birthdate AS birthdate_17, u1_.ipn AS ipn_18, u1_.phone AS phone_19, u1_.erdpou AS erdpou_20, u1_.site AS site_21, u1_.address_legal AS address_legal_22, u1_.address_actual AS address_actual_23, u1_.work_start_date AS work_start_date_24, u1_.uuid AS uuid_25, u1_.type AS type_26, u1_.active AS active_27, u1_.plain_password AS plain_password_28, u1_.full_name AS full_name_29, u1_.direction AS direction_30, u1_.balance AS balance_31, u1_.last_login AS last_login_32, u1_.login_count AS login_count_33, t2_.id AS id_34, t2_.title AS title_35, t2_.uuid AS uuid_36, t2_.deleted AS deleted_37, t2_.code AS code_38, t2_.description AS description_39, t2_.area AS area_40, t2_.heat_area AS heat_area_41, t2_.cold_area AS cold_area_42, t2_.frost_area AS frost_area_43, t2_.area_garbage AS area_garbage_44, t2_.area_cleaning AS area_cleaning_45, t2_.area_outdoor_lighting AS area_outdoor_lighting_46, o3_.id AS id_47, o3_.title AS title_48, o3_.code AS code_49, o3_.current_account AS current_account_50, o3_.bank AS bank_51, o3_.adress AS adress_52, o3_.ipn AS ipn_53, o3_.certificate_number AS certificate_number_54, o3_.uuid AS uuid_55, i4_.id AS id_56, i4_.title AS title_57, i4_.uuid AS uuid_58, i4_.number AS number_59, i4_.date AS date_60, i4_.sum AS sum_61, a0_.user_id_id AS user_id_id_62, a0_.trading_points_id AS trading_points_id_63, a0_.organisation_id AS organisation_id_64, t2_.sub_zone_id AS sub_zone_id_65, i4_.invoice_group_id AS invoice_group_id_66, i4_.agreement_id_id AS agreement_id_id_67 FROM agreements a0_ LEFT JOIN "user" u1_ ON a0_.user_id_id = u1_.id LEFT JOIN trading_points t2_ ON a0_.trading_points_id = t2_.id LEFT JOIN organizations o3_ ON a0_.organisation_id = o3_.id LEFT JOIN invoice i4_ ON a0_.id = i4_.agreement_id_id WHERE a0_.id = ?
SELECT
a0_.id AS id_0,
a0_.title AS title_1,
a0_.uuid AS uuid_2,
a0_.description AS description_3,
a0_.deleted AS deleted_4,
a0_.code AS code_5,
a0_.number AS number_6,
a0_.type AS type_7,
a0_.orenda AS orenda_8,
a0_.date_from AS date_from_9,
a0_.date_to AS date_to_10,
a0_.balance AS balance_11,
a0_.status AS status_12,
u1_.id AS id_13,
u1_.email AS email_14,
u1_.roles AS roles_15,
u1_.password AS password_16,
u1_.birthdate AS birthdate_17,
u1_.ipn AS ipn_18,
u1_.phone AS phone_19,
u1_.erdpou AS erdpou_20,
u1_.site AS site_21,
u1_.address_legal AS address_legal_22,
u1_.address_actual AS address_actual_23,
u1_.work_start_date AS work_start_date_24,
u1_.uuid AS uuid_25,
u1_.type AS type_26,
u1_.active AS active_27,
u1_.plain_password AS plain_password_28,
u1_.full_name AS full_name_29,
u1_.direction AS direction_30,
u1_.balance AS balance_31,
u1_.last_login AS last_login_32,
u1_.login_count AS login_count_33,
t2_.id AS id_34,
t2_.title AS title_35,
t2_.uuid AS uuid_36,
t2_.deleted AS deleted_37,
t2_.code AS code_38,
t2_.description AS description_39,
t2_.area AS area_40,
t2_.heat_area AS heat_area_41,
t2_.cold_area AS cold_area_42,
t2_.frost_area AS frost_area_43,
t2_.area_garbage AS area_garbage_44,
t2_.area_cleaning AS area_cleaning_45,
t2_.area_outdoor_lighting AS area_outdoor_lighting_46,
o3_.id AS id_47,
o3_.title AS title_48,
o3_.code AS code_49,
o3_.current_account AS current_account_50,
o3_.bank AS bank_51,
o3_.adress AS adress_52,
o3_.ipn AS ipn_53,
o3_.certificate_number AS certificate_number_54,
o3_.uuid AS uuid_55,
i4_.id AS id_56,
i4_.title AS title_57,
i4_.uuid AS uuid_58,
i4_.number AS number_59,
i4_.date AS date_60,
i4_.sum AS sum_61,
a0_.user_id_id AS user_id_id_62,
a0_.trading_points_id AS trading_points_id_63,
a0_.organisation_id AS organisation_id_64,
t2_.sub_zone_id AS sub_zone_id_65,
i4_.invoice_group_id AS invoice_group_id_66,
i4_.agreement_id_id AS agreement_id_id_67
FROM
agreements a0_
LEFT JOIN "user" u1_ ON a0_.user_id_id = u1_.id
LEFT JOIN trading_points t2_ ON a0_.trading_points_id = t2_.id
LEFT JOIN organizations o3_ ON a0_.organisation_id = o3_.id
LEFT JOIN invoice i4_ ON a0_.id = i4_.agreement_id_id
WHERE
a0_.id = ?
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.uuid AS uuid_2, a0_.description AS description_3, a0_.deleted AS deleted_4, a0_.code AS code_5, a0_.number AS number_6, a0_.type AS type_7, a0_.orenda AS orenda_8, a0_.date_from AS date_from_9, a0_.date_to AS date_to_10, a0_.balance AS balance_11, a0_.status AS status_12, u1_.id AS id_13, u1_.email AS email_14, u1_.roles AS roles_15, u1_.password AS password_16, u1_.birthdate AS birthdate_17, u1_.ipn AS ipn_18, u1_.phone AS phone_19, u1_.erdpou AS erdpou_20, u1_.site AS site_21, u1_.address_legal AS address_legal_22, u1_.address_actual AS address_actual_23, u1_.work_start_date AS work_start_date_24, u1_.uuid AS uuid_25, u1_.type AS type_26, u1_.active AS active_27, u1_.plain_password AS plain_password_28, u1_.full_name AS full_name_29, u1_.direction AS direction_30, u1_.balance AS balance_31, u1_.last_login AS last_login_32, u1_.login_count AS login_count_33, t2_.id AS id_34, t2_.title AS title_35, t2_.uuid AS uuid_36, t2_.deleted AS deleted_37, t2_.code AS code_38, t2_.description AS description_39, t2_.area AS area_40, t2_.heat_area AS heat_area_41, t2_.cold_area AS cold_area_42, t2_.frost_area AS frost_area_43, t2_.area_garbage AS area_garbage_44, t2_.area_cleaning AS area_cleaning_45, t2_.area_outdoor_lighting AS area_outdoor_lighting_46, o3_.id AS id_47, o3_.title AS title_48, o3_.code AS code_49, o3_.current_account AS current_account_50, o3_.bank AS bank_51, o3_.adress AS adress_52, o3_.ipn AS ipn_53, o3_.certificate_number AS certificate_number_54, o3_.uuid AS uuid_55, i4_.id AS id_56, i4_.title AS title_57, i4_.uuid AS uuid_58, i4_.number AS number_59, i4_.date AS date_60, i4_.sum AS sum_61, a0_.user_id_id AS user_id_id_62, a0_.trading_points_id AS trading_points_id_63, a0_.organisation_id AS organisation_id_64, t2_.sub_zone_id AS sub_zone_id_65, i4_.invoice_group_id AS invoice_group_id_66, i4_.agreement_id_id AS agreement_id_id_67 FROM agreements a0_ LEFT JOIN "user" u1_ ON a0_.user_id_id = u1_.id LEFT JOIN trading_points t2_ ON a0_.trading_points_id = t2_.id LEFT JOIN organizations o3_ ON a0_.organisation_id = o3_.id LEFT JOIN invoice i4_ ON a0_.id = i4_.agreement_id_id WHERE a0_.id = 4835;
|