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 = 0x6607B11D0DAC4F32B33A1857D4E8BF20;

"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 (0xCD7BDCB481C14FF289FD82C648C5A79E, 0x6607B11D0DAC4F32B33A1857D4E8BF20, 'esan-2425304351', '2026-06-10', '2026-06-09');

"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 = 0xBD83C712068B439DAA504AEBA408AB3C;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  device
SET
  assembled_date = ?
WHERE
  id = ?

UPDATE device SET assembled_date = '2026-06-09' WHERE id = 0xBD83C712068B439DAA504AEBA408AB3C;

"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 = 0xBD83C712068B439DAA504AEBA408AB3C
            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 (0x2F04AB5F771548E089800BFAB9798715, '2026-06-09', 'DOA', 'DOA', 'a:1:{i:0;a:3:{s:4:\"name\";s:20:\"Evobox 4K Lite Netia\";s:6:\"indeks\";s:6:\"149806\";s:12:\"serialNumber\";s:15:\"esan-2425304351\";}}', 'a:1:{i:0;a:3:{s:4:\"name\";s:20:\"Evobox 4K Lite Netia\";s:6:\"indeks\";s:6:\"149806\";s:12:\"serialNumber\";s:15:\"ESAN-2425304351\";}}', '2026-06-10 09:53:08', 'Oskar Ronkiewicz', '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;