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.position AS position_7,
  t0.user_group AS user_group_8,
  t0.email AS email_9,
  t0.created_at AS created_at_10,
  t0.created_by_name AS created_by_name_11,
  t0.is_active AS is_active_12
FROM
  users t0
WHERE
  t0.id = ?

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.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.material AS material_3,
  t0.dimension AS dimension_4,
  t0.quantity AS quantity_5,
  t0.cut_length AS cut_length_6,
  t0.warning_level AS warning_level_7,
  t0.price AS price_8,
  t0.position AS position_9,
  t0.supplier AS supplier_10,
  t0.product_code AS product_code_11,
  t0.image_file_name AS image_file_name_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.item_type AS item_type_15,
  t0.is_active AS is_active_16,
  t0.unit_id AS unit_id_17,
  t0.warehouse_id AS warehouse_id_18,
  t0.category_id AS category_id_19,
  t0.subcategory_id AS subcategory_id_20
FROM
  warehouse_items t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.material AS material_3, t0.dimension AS dimension_4, t0.quantity AS quantity_5, t0.cut_length AS cut_length_6, t0.warning_level AS warning_level_7, t0.price AS price_8, t0.position AS position_9, t0.supplier AS supplier_10, t0.product_code AS product_code_11, t0.image_file_name AS image_file_name_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.item_type AS item_type_15, t0.is_active AS is_active_16, t0.unit_id AS unit_id_17, t0.warehouse_id AS warehouse_id_18, t0.category_id AS category_id_19, t0.subcategory_id AS subcategory_id_20 FROM warehouse_items t0 WHERE t0.id = 2774;

SELECT
  COUNT(*)
FROM
  (
    SELECT
      full_code
    FROM
      (
        SELECT
          CONCAT(
            z.code, '.', a.code, '.', s.code, '.',
            p.code
          ) as full_code
        FROM
          storage_position p
          JOIN storage_section s ON p.section_id = s.id
          JOIN storage_area a ON s.area_id = a.id
          JOIN storage_zone z ON a.zone_id = z.id
        WHERE
          z.warehouse_id = ?
        UNION ALL
        SELECT
          CONCAT(z.code, '.', a.code, '.', s.code) as full_code
        FROM
          storage_section s
          JOIN storage_area a ON s.area_id = a.id
          JOIN storage_zone z ON a.zone_id = z.id
        WHERE
          z.warehouse_id = ?
        UNION ALL
        SELECT
          CONCAT(z.code, '.', a.code) as full_code
        FROM
          storage_area a
          JOIN storage_zone z ON a.zone_id = z.id
        WHERE
          z.warehouse_id = ?
      ) codes
    WHERE
      full_code = ?
  ) cnt

SELECT COUNT(*) FROM (
                SELECT full_code FROM (
                    SELECT CONCAT(z.code, '.', a.code, '.', s.code, '.', p.code) as full_code
                    FROM storage_position p
                    JOIN storage_section s ON p.section_id = s.id
                    JOIN storage_area a ON s.area_id = a.id
                    JOIN storage_zone z ON a.zone_id = z.id
                    WHERE z.warehouse_id = 3
                    UNION ALL
                    SELECT CONCAT(z.code, '.', a.code, '.', s.code) as full_code
                    FROM storage_section s
                    JOIN storage_area a ON s.area_id = a.id
                    JOIN storage_zone z ON a.zone_id = z.id
                    WHERE z.warehouse_id = 3
                    UNION ALL
                    SELECT CONCAT(z.code, '.', a.code) as full_code
                    FROM storage_area a
                    JOIN storage_zone z ON a.zone_id = z.id
                    WHERE z.warehouse_id = 3
                ) codes
                WHERE full_code = 'C.4.1.1'
            ) cnt;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO warehouse_movements (
  type, document_number, quantity, quantity_after,
  price, created_by_name, created_at,
  notes, unit_calculated, unit_calculation_log,
  from_unit_symbol, supplier, item_id,
  project_id, issued_to_user_id, issued_to_employee_id,
  receipt_id, project_category_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO warehouse_movements (type, document_number, quantity, quantity_after, price, created_by_name, created_at, notes, unit_calculated, unit_calculation_log, from_unit_symbol, supplier, item_id, project_id, issued_to_user_id, issued_to_employee_id, receipt_id, project_category_id) VALUES ('przesunięcie', 'MV-20260810-153954', '117', '117.000', NULL, 'Bartosz Ulik', '2026-08-10 15:39:54', NULL, NULL, NULL, NULL, NULL, 2774, NULL, NULL, NULL, NULL, NULL);

UPDATE
  warehouse_items
SET
  position = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE warehouse_items SET position = 'C.4.1.1', updated_at = '2026-08-10 15:39:54' WHERE id = 2774;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO entity_change_logs (
  entity_class, entity_label, entity_id,
  action, changes, changed_by_name,
  changed_by_id, changed_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO entity_change_logs (entity_class, entity_label, entity_id, action, changes, changed_by_name, changed_by_id, changed_at) VALUES ('App\\Entity\\WarehouseMovement', '#?', 0, 'create', NULL, 'magazynier', 3, '2026-08-10 15:39:54');

INSERT INTO entity_change_logs (
  entity_class, entity_label, entity_id,
  action, changes, changed_by_name,
  changed_by_id, changed_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO entity_change_logs (entity_class, entity_label, entity_id, action, changes, changed_by_name, changed_by_id, changed_at) VALUES ('App\\Entity\\WarehouseItem', 'Lower part marine with welding sleeve 470.000.050 S', 2774, 'update', '{\"position\":{\"old\":null,\"new\":\"C.4.1.1\"}}', 'magazynier', 3, '2026-08-10 15:39:54');

"ROLLBACK"

"ROLLBACK";