Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.roles AS roles_5,
  t0.password AS password_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6 FROM user t0 WHERE t0.id = 5;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.indeks AS indeks_2,
  d0_.is_active AS is_active_3,
  d0_.created_at AS created_at_4
FROM
  device_model d0_
WHERE
  d0_.id = ?

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.indeks AS indeks_2, d0_.is_active AS is_active_3, d0_.created_at AS created_at_4 FROM device_model d0_ WHERE d0_.id = 0xACE740DBC7024C47B64419FEE2B38B3B;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO disassembled_device (
  id, model, serial_number, created_at,
  disassembled_date
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO disassembled_device (id, model, serial_number, created_at, disassembled_date) VALUES (0x84FFC2C72C2D47E3A4D5160BA82B023E, 0xACE740DBC7024C47B64419FEE2B38B3B, '4857544311b3e7a2', '2026-06-10', '2026-04-21');

"COMMIT"

"COMMIT";

SELECT
  d0_.id AS id_0,
  d0_.model AS model_1,
  d0_.serial_number AS serial_number_2,
  d0_.created_at AS created_at_3,
  d0_.engineer_id AS engineer_id_4,
  d0_.hangover_date AS hangover_date_5,
  d0_.assembled_date AS assembled_date_6,
  d0_.notes AS notes_7,
  d0_.finished_type AS finished_type_8
FROM
  device d0_
WHERE
  d0_.id = ?

SELECT d0_.id AS id_0, d0_.model AS model_1, d0_.serial_number AS serial_number_2, d0_.created_at AS created_at_3, d0_.engineer_id AS engineer_id_4, d0_.hangover_date AS hangover_date_5, d0_.assembled_date AS assembled_date_6, d0_.notes AS notes_7, d0_.finished_type AS finished_type_8 FROM device d0_ WHERE d0_.id = 0x00E9371E0E99400B84AE6A612F8024B0;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  device
SET
  assembled_date = ?,
  notes = ?
WHERE
  id = ?

UPDATE device SET assembled_date = '2026-04-21', notes = 'CTT 26/04/020417' WHERE id = 0x00E9371E0E99400B84AE6A612F8024B0;

"COMMIT"

"COMMIT";

SELECT
  d.id,
  dm.name,
  dm.indeks,
  d.serial_number,
  concat(e.first_name, ' ', e.last_name) as engineer
FROM
  device d
  LEFT JOIN device_model dm on d.model = dm.id
  LEFT JOIN engineer e on d.engineer_id = e.id
WHERE
  d.id = :id
LIMIT
  1

SELECT d.id, dm.name, dm.indeks, d.serial_number, concat(e.first_name, ' ', e.last_name) as engineer
            FROM device d 
            LEFT JOIN device_model dm on d.model = dm.id
            LEFT JOIN engineer e on d.engineer_id = e.id
            WHERE d.id = 0x00E9371E0E99400B84AE6A612F8024B0
            LIMIT 1
        ;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO orders (
  id, order_date, address, order_number,
  disassembled, assembled, created_at,
  engineer, created_by
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO orders (id, order_date, address, order_number, disassembled, assembled, created_at, engineer, created_by) VALUES (0xD657655A26614488821E9B170BE1150F, '2026-04-21', 'WAŁBRZYCH, HETMAŃSKA 52/11', 'CTT 26/04/020417', 'a:1:{i:0;a:3:{s:4:\"name\";s:33:\"HUAWEI Router ONT Huawei HG8245Q2\";s:6:\"indeks\";s:6:\"142794\";s:12:\"serialNumber\";s:16:\"4857544311b3e7a2\";}}', 'a:1:{i:0;a:3:{s:4:\"name\";s:33:\"HUAWEI Router ONT Huawei HG8245Q2\";s:6:\"indeks\";s:6:\"142794\";s:12:\"serialNumber\";s:16:\"485754438506829F\";}}', '2026-06-10 09:58:33', 'Robert Sylwek Serwis Wałbrzych', 'Anna Sądej');

"COMMIT"

"COMMIT";

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.indeks AS indeks_2,
  d0_.is_active AS is_active_3,
  d0_.created_at AS created_at_4
FROM
  device_model d0_
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.indeks AS indeks_2, d0_.is_active AS is_active_3, d0_.created_at AS created_at_4 FROM device_model d0_ ORDER BY d0_.name ASC;