Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.address AS address_8,
  t0.status AS status_9,
  t0.email AS email_10,
  t0.work_schedule AS work_schedule_11,
  t0.telegram AS telegram_12,
  t0.viber AS viber_13,
  t0.hash_date AS hash_date_14,
  t0.device_id AS device_id_15,
  t0.active_code AS active_code_16,
  t0.deleted AS deleted_17,
  t0.debug AS debug_18,
  t0.dev AS dev_19,
  t0.date_entered AS date_entered_20,
  t0.notification_status AS notification_status_21,
  t0.email_status AS email_status_22,
  t0.os_type AS os_type_23,
  t0.manager_id AS manager_id_24
FROM
  users t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.work_schedule AS work_schedule_11, t0.telegram AS telegram_12, t0.viber AS viber_13, t0.hash_date AS hash_date_14, t0.device_id AS device_id_15, t0.active_code AS active_code_16, t0.deleted AS deleted_17, t0.debug AS debug_18, t0.dev AS dev_19, t0.date_entered AS date_entered_20, t0.notification_status AS notification_status_21, t0.email_status AS email_status_22, t0.os_type AS os_type_23, t0.manager_id AS manager_id_24 FROM users t0 WHERE t0.username = '+380687416816' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.users_id AS users_id_2,
  t0.role_id AS role_id_3
FROM
  user_role t0
WHERE
  t0.users_id = ?

SELECT t0.id AS id_1, t0.users_id AS users_id_2, t0.role_id AS role_id_3 FROM user_role t0 WHERE t0.users_id = 31;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log_history_request (
  method, request, date, status, response_answer
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO log_history_request (method, request, date, status, response_answer) VALUES ('get_meter_readings_history', '{\"account\":\"0900015104\",\"user\":31}', '2026-04-23 11:39:23', 'start', NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.name AS name_3,
  t0.number_of_scale AS number_of_scale_4,
  t0.active AS active_5,
  t0.full_address AS full_address_6,
  t0.city AS city_7,
  t0.street AS street_8,
  t0.building AS building_9,
  t0.room AS room_10,
  t0.main_full_address AS main_full_address_11,
  t0.type AS type_12,
  t0.date_entered AS date_entered_13,
  t0.is_main AS is_main_14,
  t0.eic AS eic_15,
  t0.counter AS counter_16,
  t0.is_show AS is_show_17,
  t0.last_history_counter AS last_history_counter_18,
  t0.last_history_counter_date AS last_history_counter_date_19,
  t0.notification_status AS notification_status_20,
  t0.owner_id AS owner_id_21,
  t0.accounts_id AS accounts_id_22,
  t0.parent_id AS parent_id_23,
  t0.company_id AS company_id_24
FROM
  app_personal_account t0
WHERE
  t0.owner_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.name AS name_3, t0.number_of_scale AS number_of_scale_4, t0.active AS active_5, t0.full_address AS full_address_6, t0.city AS city_7, t0.street AS street_8, t0.building AS building_9, t0.room AS room_10, t0.main_full_address AS main_full_address_11, t0.type AS type_12, t0.date_entered AS date_entered_13, t0.is_main AS is_main_14, t0.eic AS eic_15, t0.counter AS counter_16, t0.is_show AS is_show_17, t0.last_history_counter AS last_history_counter_18, t0.last_history_counter_date AS last_history_counter_date_19, t0.notification_status AS notification_status_20, t0.owner_id AS owner_id_21, t0.accounts_id AS accounts_id_22, t0.parent_id AS parent_id_23, t0.company_id AS company_id_24 FROM app_personal_account t0 WHERE t0.owner_id = 31;

SELECT
  t0.id AS id_1,
  t0.method AS method_2,
  t0.request AS request_3,
  t0.date AS date_4,
  t0.status AS status_5,
  t0.response_answer AS response_answer_6
FROM
  log_history_request t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.method AS method_2, t0.request AS request_3, t0.date AS date_4, t0.status AS status_5, t0.response_answer AS response_answer_6 FROM log_history_request t0 WHERE t0.id = 212 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  log_history_request
SET
  status = ?,
  response_answer = ?
WHERE
  id = ?

UPDATE log_history_request SET status = 'finish', response_answer = '{\"rezult\":true,\"data\":[{\"AccountNumber\":\"0900015104\",\"EIC\":\"62Z4766326811404\",\"FullAddress\":\"\\u041b\\u044c\\u0432\\u0456\\u0432\\u0441\\u044c\\u043a\\u0430 \\u043e\\u0431\\u043b., \\u0440\\u0430\\u0439\\u043e\\u043d \\u041b\\u044c\\u0432\\u0456\\u0432\\u0441\\u044c\\u043a\\u0438\\u0439, \\u0441. \\u041f\\u0456\\u0434\\u0431\\u0435\\u0440\\u0456\\u0437\\u0446\\u0456, \\u0432\\u0443\\u043b. \\u041f\\u043e\\u043b\\u044c\\u043e\\u0432\\u0430, \\u0431\\u0443\\u0434. 3, 81146\",\"CounterData\":[{\"CounterNumber\":\"12124388\",\"ScaleCount\":1,\"MeterReadData\":[{\"Date\":\"2026-04-01T00:00:00\",\"MeterRead\":\"15388\",\"MeterReadDesc\":\" \",\"Source\":\"\\u043f\\u043e\\u0434\\u0430\\u043d\\u0438\\u0439 \\u0441\\u043f\\u043e\\u0436\\u0438\\u0432\\u0430\\u0447\\u0435\\u043c \\u0447\\u0435\\u0440\\u0435\\u0437 Telegram\"},{\"Date\":\"2026-03-01T00:00:00\",\"MeterRead\":\"14443\",\"MeterReadDesc\":\" \",\"Source\":\"\\u0432\\u0456\\u0434\\u0441\\u0443\\u0442\\u043d\\u0456\\u0439 \\u043f\\u043e\\u043a\\u0430\\u0437 \\u0441\\u043f\\u043e\\u0436\\u0438\\u0432\\u0430\\u0447\\u0430 \\u043d\\u0430 1-\\u0448\\u0435 \\u0447\\u0438\\u0441\\u043b\\u043e, \\u0440\\u043e\\u0437\\u0440\\u0430\\u0445\\u043e\\u0432\\u0430\\u043d\\u0438\\u0439 \\u0430\\u0432\\u0442\\u043e\\u043c\\u0430\\u0442\\u0438\\u0447\\u043d\\u043e\"},{\"Date\":\"2026-02-04T00:00:00\",\"MeterRead\":\"14428\",\"MeterReadDesc\":\" \",\"Source\":\"\\u043f\\u043e\\u0434\\u0430\\u043d\\u0438\\u0439 \\u0441\\u043f\\u043e\\u0436\\u0438\\u0432\\u0430\\u0447\\u0435\\u043c \\u0447\\u0435\\u0440\\u0435\\u0437 \\u0434\\u043e\\u0434\\u0430\\u0442\\u043e\\u043a \\u041a\\u043e\\u043c\\u041a\\u043e\\u043c\"},{\"Date\":\"2026-02-01T00:00:00\",\"MeterRead\":\"14108\",\"MeterReadDesc\":\" \",\"Source\":\"\\u0432\\u0456\\u0434\\u0441\\u0443\\u0442\\u043d\\u0456\\u0439 \\u043f\\u043e\\u043a\\u0430\\u0437 \\u0441\\u043f\\u043e\\u0436\\u0438\\u0432\\u0430\\u0447\\u0430 \\u043d\\u0430 1-\\u0448\\u0435 \\u0447\\u0438\\u0441\\u043b\\u043e, \\u0440\\u043e\\u0437\\u0440\\u0430\\u0445\\u043e\\u0432\\u0430\\u043d\\u0438\\u0439 \\u0430\\u0432\\u0442\\u043e\\u043c\\u0430\\u0442\\u0438\\u0447\\u043d\\u043e\"}]}]}],\"lastAnswerDate\":\"2026-04-23 11:39:24\"}' WHERE id = 212;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 10;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 35794;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 31;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 17;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 22;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 26;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 11;

UPDATE
  app_personal_account
SET
  last_history_counter_date = ?
WHERE
  id = ?

UPDATE app_personal_account SET last_history_counter_date = '2026-04-23 11:39:24' WHERE id = 9;

"COMMIT"

"COMMIT";