Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.status AS status_3,
  t0.discount AS discount_4,
  t0.discount_type AS discount_type_5,
  t0.parked AS parked_6,
  t0.park_date AS park_date_7,
  t0.finished AS finished_8,
  t0.finished_date AS finished_date_9,
  t0.name AS name_10,
  t0.save_date AS save_date_11,
  t0.saved AS saved_12,
  t0.comment AS comment_13,
  t0.closed AS closed_14,
  t0.close_date AS close_date_15,
  t0.total AS total_16,
  t0.total_otax AS total_otax_17,
  t0.total_fixed AS total_fixed_18,
  t0.total_otax_fixed AS total_otax_fixed_19,
  t0.total_tax AS total_tax_20,
  t0.total_tax_fixed AS total_tax_fixed_21,
  t0.employee_id AS employee_id_22,
  t0.location_id AS location_id_23,
  t0.cashbox_id AS cashbox_id_24,
  t0.customer_id AS customer_id_25,
  t0.cash_closure_id AS cash_closure_id_26,
  t0.customer_address_id AS customer_address_id_27
FROM
  cart t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.status AS status_3, t0.discount AS discount_4, t0.discount_type AS discount_type_5, t0.parked AS parked_6, t0.park_date AS park_date_7, t0.finished AS finished_8, t0.finished_date AS finished_date_9, t0.name AS name_10, t0.save_date AS save_date_11, t0.saved AS saved_12, t0.comment AS comment_13, t0.closed AS closed_14, t0.close_date AS close_date_15, t0.total AS total_16, t0.total_otax AS total_otax_17, t0.total_fixed AS total_fixed_18, t0.total_otax_fixed AS total_otax_fixed_19, t0.total_tax AS total_tax_20, t0.total_tax_fixed AS total_tax_fixed_21, t0.employee_id AS employee_id_22, t0.location_id AS location_id_23, t0.cashbox_id AS cashbox_id_24, t0.customer_id AS customer_id_25, t0.cash_closure_id AS cash_closure_id_26, t0.customer_address_id AS customer_address_id_27 FROM cart t0 WHERE t0.id = '8338';

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.config_group AS config_group_4,
  t0.environment AS environment_5
FROM
  fiskaly_configuration t0
WHERE
  t0.config_key = ?
  AND t0.config_group = ?
  AND t0.environment IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.config_group AS config_group_4, t0.environment AS environment_5 FROM fiskaly_configuration t0 WHERE t0.config_key = 'FISKALY_ENVIRONMENT' AND t0.config_group = 'FISKALY_API' AND t0.environment IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.config_group AS config_group_4,
  t0.environment AS environment_5
FROM
  fiskaly_configuration t0
WHERE
  (
    t0.environment IN (?)
    OR t0.environment IS NULL
  )

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.config_group AS config_group_4, t0.environment AS environment_5 FROM fiskaly_configuration t0 WHERE (t0.environment IN ('LIVE', NULL) OR t0.environment IS NULL);

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  cart
SET
  finished = ?,
  finished_date = ?
WHERE
  id = ?

UPDATE cart SET finished = 1, finished_date = '2024-05-16 11:57:48' WHERE id = 8338;

"COMMIT"

"COMMIT";

UPDATE
  cart
SET
  status = 0

UPDATE cart SET status = 0;

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.config_group AS config_group_4
FROM
  configuration t0
WHERE
  t0.config_key = ?
  AND t0.config_group = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.config_group AS config_group_4 FROM configuration t0 WHERE t0.config_key = 'FOLLOW_UP_IS_DEPOSIT' AND t0.config_group = 'POS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.config_group AS config_group_4
FROM
  configuration t0
WHERE
  t0.config_key = ?
  AND t0.config_group = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.config_group AS config_group_4 FROM configuration t0 WHERE t0.config_key = 'RECEIPT_NUMBER_START' AND t0.config_group = 'POS_RECEIPT' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.status AS status_3,
  t0.discount AS discount_4,
  t0.discount_type AS discount_type_5,
  t0.comment AS comment_6,
  t0.total AS total_7,
  t0.total_otax AS total_otax_8,
  t0.total_fixed AS total_fixed_9,
  t0.total_otax_fixed AS total_otax_fixed_10,
  t0.total_tax AS total_tax_11,
  t0.total_tax_fixed AS total_tax_fixed_12,
  t0.cart_total AS cart_total_13,
  t0.cart_total_otax AS cart_total_otax_14,
  t0.cart_total_fixed AS cart_total_fixed_15,
  t0.cart_total_otax_fixed AS cart_total_otax_fixed_16,
  t0.cart_total_tax AS cart_total_tax_17,
  t0.cart_total_tax_fixed AS cart_total_tax_fixed_18,
  t0.number AS number_19,
  t0.uuid AS uuid_20,
  t0.canceled AS canceled_21,
  t0.reversal_receipt AS reversal_receipt_22,
  t0.receipt_cashbox_id AS receipt_cashbox_id_23,
  t0.receipt_location_id AS receipt_location_id_24,
  t0.receipt_employee_id AS receipt_employee_id_25,
  t0.customer_id AS customer_id_26,
  t0.customer_address_id AS customer_address_id_27,
  t0.daily_financial_statement_id AS daily_financial_statement_id_28
FROM
  receipt t0
ORDER BY
  t0.number DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.status AS status_3, t0.discount AS discount_4, t0.discount_type AS discount_type_5, t0.comment AS comment_6, t0.total AS total_7, t0.total_otax AS total_otax_8, t0.total_fixed AS total_fixed_9, t0.total_otax_fixed AS total_otax_fixed_10, t0.total_tax AS total_tax_11, t0.total_tax_fixed AS total_tax_fixed_12, t0.cart_total AS cart_total_13, t0.cart_total_otax AS cart_total_otax_14, t0.cart_total_fixed AS cart_total_fixed_15, t0.cart_total_otax_fixed AS cart_total_otax_fixed_16, t0.cart_total_tax AS cart_total_tax_17, t0.cart_total_tax_fixed AS cart_total_tax_fixed_18, t0.number AS number_19, t0.uuid AS uuid_20, t0.canceled AS canceled_21, t0.reversal_receipt AS reversal_receipt_22, t0.receipt_cashbox_id AS receipt_cashbox_id_23, t0.receipt_location_id AS receipt_location_id_24, t0.receipt_employee_id AS receipt_employee_id_25, t0.customer_id AS customer_id_26, t0.customer_address_id AS customer_address_id_27, t0.daily_financial_statement_id AS daily_financial_statement_id_28 FROM receipt t0 ORDER BY t0.number DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO receipt (
  create_date, status, discount, discount_type,
  comment, total, total_otax, total_fixed,
  total_otax_fixed, total_tax, total_tax_fixed,
  cart_total, cart_total_otax, cart_total_fixed,
  cart_total_otax_fixed, cart_total_tax,
  cart_total_tax_fixed, number, uuid,
  canceled, reversal_receipt, receipt_cashbox_id,
  receipt_location_id, receipt_employee_id,
  customer_id, customer_address_id,
  daily_financial_statement_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO receipt (create_date, status, discount, discount_type, comment, total, total_otax, total_fixed, total_otax_fixed, total_tax, total_tax_fixed, cart_total, cart_total_otax, cart_total_fixed, cart_total_otax_fixed, cart_total_tax, cart_total_tax_fixed, number, uuid, canceled, reversal_receipt, receipt_cashbox_id, receipt_location_id, receipt_employee_id, customer_id, customer_address_id, daily_financial_statement_id) VALUES ('2024-05-16 11:57:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7.9, 7.3831775700935, 7.9, 7.38, 0.51682242990654, 0.52, 14366, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.comment AS comment_3,
  t0.locked AS locked_4,
  t0.serial_number AS serial_number_5,
  t6.id AS id_7,
  t6.client_id AS client_id_8,
  t6.status AS status_9,
  t6.add_date AS add_date_10,
  t6.cashbox_id AS cashbox_id_11,
  t6.fiskaly_tss_id AS fiskaly_tss_id_12,
  t0.location_id AS location_id_13
FROM
  cashbox t0
  LEFT JOIN fiskaly_client t6 ON t6.cashbox_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.locked AS locked_4, t0.serial_number AS serial_number_5, t6.id AS id_7, t6.client_id AS client_id_8, t6.status AS status_9, t6.add_date AS add_date_10, t6.cashbox_id AS cashbox_id_11, t6.fiskaly_tss_id AS fiskaly_tss_id_12, t0.location_id AS location_id_13 FROM cashbox t0 LEFT JOIN fiskaly_client t6 ON t6.cashbox_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.transaction_date AS transaction_date_2,
  t0.to_pay AS to_pay_3,
  t0.given_cash AS given_cash_4,
  t0.change_cash AS change_cash_5,
  t0.payment_method_id AS payment_method_id_6,
  t0.cart_id AS cart_id_7
FROM
  transaction t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.transaction_date AS transaction_date_2, t0.to_pay AS to_pay_3, t0.given_cash AS given_cash_4, t0.change_cash AS change_cash_5, t0.payment_method_id AS payment_method_id_6, t0.cart_id AS cart_id_7 FROM transaction t0 WHERE t0.cart_id = 8338;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.cash AS cash_3,
  t0.uuid AS uuid_4
FROM
  payment_method t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.cash AS cash_3, t0.uuid AS uuid_4 FROM payment_method t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.given_name AS given_name_3,
  t0.family_name AS family_name_4,
  t0.email AS email_5,
  t0.uuid AS uuid_6,
  t0.b2b AS b2b_7,
  t0.vat AS vat_8,
  t0.receipt_customer_group_id AS receipt_customer_group_id_9,
  t0.receipt_discount_id AS receipt_discount_id_10,
  t0.receipt_price_group_id AS receipt_price_group_id_11,
  t0.customer_id AS customer_id_12,
  t0.receipt_id AS receipt_id_13
FROM
  receipt_customer t0
WHERE
  t0.receipt_id = ?
  AND t0.customer_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.given_name AS given_name_3, t0.family_name AS family_name_4, t0.email AS email_5, t0.uuid AS uuid_6, t0.b2b AS b2b_7, t0.vat AS vat_8, t0.receipt_customer_group_id AS receipt_customer_group_id_9, t0.receipt_discount_id AS receipt_discount_id_10, t0.receipt_price_group_id AS receipt_price_group_id_11, t0.customer_id AS customer_id_12, t0.receipt_id AS receipt_id_13 FROM receipt_customer t0 WHERE t0.receipt_id = 7367 AND t0.customer_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.uuid AS uuid_3,
  t0.given_name AS given_name_4,
  t0.family_name AS family_name_5,
  t0.email AS email_6,
  t0.b2b AS b2b_7,
  t0.vat AS vat_8,
  t0.customer_group_id AS customer_group_id_9,
  t0.discount_id AS discount_id_10,
  t0.price_group_id AS price_group_id_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.uuid AS uuid_3, t0.given_name AS given_name_4, t0.family_name AS family_name_5, t0.email AS email_6, t0.b2b AS b2b_7, t0.vat AS vat_8, t0.customer_group_id AS customer_group_id_9, t0.discount_id AS discount_id_10, t0.price_group_id AS price_group_id_11 FROM customer t0 WHERE t0.id = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO receipt_payment_method (
  name, cash, uuid, payment_method_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO receipt_payment_method (name, cash, uuid, payment_method_id) VALUES ('Bar', 1, '7abe7a84-8bfd-468a-adb7-4a734266b745', 1);

INSERT INTO receipt_cashbox (
  name, comment, locked, serial_number,
  snap_date, cashbox_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO receipt_cashbox (name, comment, locked, serial_number, snap_date, cashbox_id) VALUES ('Kasse 1', NULL, 0, 'SWTPOS-V1-590dcbcc26a0561166e9d2470c94716fc25a944477fa8e4803e7b322457f3aa5', '2024-05-16 11:57:48', 1);

INSERT INTO receipt_transaction (
  transaction_date, to_pay, given_cash,
  change_cash, transaction_id, receipt_payment_method_id,
  receipt_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO receipt_transaction (transaction_date, to_pay, given_cash, change_cash, transaction_id, receipt_payment_method_id, receipt_id) VALUES ('2024-05-16 11:57:48', 7.9, 0, -7.9, 7346, 7342, 7367);

INSERT INTO receipt_customer (
  create_date, given_name, family_name,
  email, uuid, b2b, vat, receipt_customer_group_id,
  receipt_discount_id, receipt_price_group_id,
  customer_id, receipt_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO receipt_customer (create_date, given_name, family_name, email, uuid, b2b, vat, receipt_customer_group_id, receipt_discount_id, receipt_price_group_id, customer_id, receipt_id) VALUES ('2022-06-30 06:07:19', 'DEFAULT_CUSTOMER', 'DEFAULT_CUSTOMER', NULL, '77123bd6-9cfe-4219-850d-240e1465757f', 1, NULL, NULL, NULL, NULL, 1, 7367);

UPDATE
  receipt
SET
  receipt_cashbox_id = ?,
  customer_id = ?
WHERE
  id = ?

UPDATE receipt SET receipt_cashbox_id = 7367, customer_id = 1 WHERE id = 7367;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.external_identifier AS external_identifier_3,
  t0.gender AS gender_4,
  t0.title AS title_5,
  t0.date_of_birth AS date_of_birth_6,
  t0.telephone AS telephone_7,
  t0.mobilephone AS mobilephone_8,
  t0.fax_number AS fax_number_9,
  t0.company AS company_10,
  t0.given_name AS given_name_11,
  t0.family_name AS family_name_12,
  t0.street_address AS street_address_13,
  t0.postal_code AS postal_code_14,
  t0.address_locality AS address_locality_15,
  t0.address_suburb AS address_suburb_16,
  t0.address_addition AS address_addition_17,
  t0.address_country AS address_country_18,
  t0.company_department AS company_department_19,
  t0.uuid AS uuid_20,
  t0.type AS type_21,
  t0.customer_id AS customer_id_22
FROM
  customer_address t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.external_identifier AS external_identifier_3, t0.gender AS gender_4, t0.title AS title_5, t0.date_of_birth AS date_of_birth_6, t0.telephone AS telephone_7, t0.mobilephone AS mobilephone_8, t0.fax_number AS fax_number_9, t0.company AS company_10, t0.given_name AS given_name_11, t0.family_name AS family_name_12, t0.street_address AS street_address_13, t0.postal_code AS postal_code_14, t0.address_locality AS address_locality_15, t0.address_suburb AS address_suburb_16, t0.address_addition AS address_addition_17, t0.address_country AS address_country_18, t0.company_department AS company_department_19, t0.uuid AS uuid_20, t0.type AS type_21, t0.customer_id AS customer_id_22 FROM customer_address t0 WHERE t0.customer_id = 1;

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.external_identifier AS external_identifier_3,
  t0.gender AS gender_4,
  t0.title AS title_5,
  t0.date_of_birth AS date_of_birth_6,
  t0.telephone AS telephone_7,
  t0.mobilephone AS mobilephone_8,
  t0.fax_number AS fax_number_9,
  t0.company AS company_10,
  t0.given_name AS given_name_11,
  t0.family_name AS family_name_12,
  t0.street_address AS street_address_13,
  t0.postal_code AS postal_code_14,
  t0.address_locality AS address_locality_15,
  t0.address_suburb AS address_suburb_16,
  t0.address_addition AS address_addition_17,
  t0.address_country AS address_country_18,
  t0.company_department AS company_department_19,
  t0.type AS type_20,
  t0.receipt_customer_id AS receipt_customer_id_21,
  t0.customer_address_id AS customer_address_id_22,
  t0.receipt_id AS receipt_id_23
FROM
  receipt_customer_address t0
WHERE
  t0.receipt_id = ?
  AND t0.customer_address_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.external_identifier AS external_identifier_3, t0.gender AS gender_4, t0.title AS title_5, t0.date_of_birth AS date_of_birth_6, t0.telephone AS telephone_7, t0.mobilephone AS mobilephone_8, t0.fax_number AS fax_number_9, t0.company AS company_10, t0.given_name AS given_name_11, t0.family_name AS family_name_12, t0.street_address AS street_address_13, t0.postal_code AS postal_code_14, t0.address_locality AS address_locality_15, t0.address_suburb AS address_suburb_16, t0.address_addition AS address_addition_17, t0.address_country AS address_country_18, t0.company_department AS company_department_19, t0.type AS type_20, t0.receipt_customer_id AS receipt_customer_id_21, t0.customer_address_id AS customer_address_id_22, t0.receipt_id AS receipt_id_23 FROM receipt_customer_address t0 WHERE t0.receipt_id = 7367 AND t0.customer_address_id = 954 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.component_price AS component_price_3,
  t0.valid_from AS valid_from_4,
  t0.valid_to AS valid_to_5,
  t0.sales_unit_factor AS sales_unit_factor_6,
  t0.quantity AS quantity_7,
  t0.product_id AS product_id_8,
  t0.price_group_id AS price_group_id_9,
  t0.customer_id AS customer_id_10,
  t0.unit_id AS unit_id_11
FROM
  price t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.component_price AS component_price_3, t0.valid_from AS valid_from_4, t0.valid_to AS valid_to_5, t0.sales_unit_factor AS sales_unit_factor_6, t0.quantity AS quantity_7, t0.product_id AS product_id_8, t0.price_group_id AS price_group_id_9, t0.customer_id AS customer_id_10, t0.unit_id AS unit_id_11 FROM price t0 WHERE t0.customer_id = 1;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.quantity AS quantity_3,
  t0.component_price AS component_price_4,
  t0.valid_from AS valid_from_5,
  t0.valid_to AS valid_to_6,
  t0.sales_unit_factor AS sales_unit_factor_7,
  t0.product_id AS product_id_8,
  t0.price_group_id AS price_group_id_9,
  t0.customer_id AS customer_id_10,
  t0.unit_id AS unit_id_11
FROM
  scale_price t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.component_price AS component_price_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6, t0.sales_unit_factor AS sales_unit_factor_7, t0.product_id AS product_id_8, t0.price_group_id AS price_group_id_9, t0.customer_id AS customer_id_10, t0.unit_id AS unit_id_11 FROM scale_price t0 WHERE t0.customer_id = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO receipt_customer_address (
  create_date, external_identifier,
  gender, title, date_of_birth, telephone,
  mobilephone, fax_number, company,
  given_name, family_name, street_address,
  postal_code, address_locality, address_suburb,
  address_addition, address_country,
  company_department, type, receipt_customer_id,
  customer_address_id, receipt_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO receipt_customer_address (create_date, external_identifier, gender, title, date_of_birth, telephone, mobilephone, fax_number, company, given_name, family_name, street_address, postal_code, address_locality, address_suburb, address_addition, address_country, company_department, type, receipt_customer_id, customer_address_id, receipt_id) VALUES ('2024-05-16 11:57:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'DEFAULT_CUSTOMER', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'DE', NULL, 'billing', 17359, 954, 7367);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.given_name AS given_name_2,
  t0.family_name AS family_name_3,
  t0.external_identifier AS external_identifier_4,
  t0.telephone AS telephone_5,
  t0.status AS status_6,
  t0.lock_pin AS lock_pin_7,
  t0.from_api AS from_api_8,
  t0.user_id AS user_id_9,
  t0.employee_group_id AS employee_group_id_10,
  t0.language_id AS language_id_11
FROM
  employee t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.given_name AS given_name_2, t0.family_name AS family_name_3, t0.external_identifier AS external_identifier_4, t0.telephone AS telephone_5, t0.status AS status_6, t0.lock_pin AS lock_pin_7, t0.from_api AS from_api_8, t0.user_id AS user_id_9, t0.employee_group_id AS employee_group_id_10, t0.language_id AS language_id_11 FROM employee t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.account_id AS account_id_5,
  t6.id AS id_7,
  t6.given_name AS given_name_8,
  t6.family_name AS family_name_9,
  t6.external_identifier AS external_identifier_10,
  t6.telephone AS telephone_11,
  t6.status AS status_12,
  t6.lock_pin AS lock_pin_13,
  t6.from_api AS from_api_14,
  t6.user_id AS user_id_15,
  t6.employee_group_id AS employee_group_id_16,
  t6.language_id AS language_id_17
FROM
  user t0
  LEFT JOIN employee t6 ON t6.user_id = t0.id
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.account_id AS account_id_5, t6.id AS id_7, t6.given_name AS given_name_8, t6.family_name AS family_name_9, t6.external_identifier AS external_identifier_10, t6.telephone AS telephone_11, t6.status AS status_12, t6.lock_pin AS lock_pin_13, t6.from_api AS from_api_14, t6.user_id AS user_id_15, t6.employee_group_id AS employee_group_id_16, t6.language_id AS language_id_17 FROM user t0 LEFT JOIN employee t6 ON t6.user_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.account_id AS account_id_5,
  t6.id AS id_7,
  t6.given_name AS given_name_8,
  t6.family_name AS family_name_9,
  t6.external_identifier AS external_identifier_10,
  t6.telephone AS telephone_11,
  t6.status AS status_12,
  t6.lock_pin AS lock_pin_13,
  t6.from_api AS from_api_14,
  t6.user_id AS user_id_15,
  t6.employee_group_id AS employee_group_id_16,
  t6.language_id AS language_id_17
FROM
  user t0
  LEFT JOIN employee t6 ON t6.user_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.account_id AS account_id_5, t6.id AS id_7, t6.given_name AS given_name_8, t6.family_name AS family_name_9, t6.external_identifier AS external_identifier_10, t6.telephone AS telephone_11, t6.status AS status_12, t6.lock_pin AS lock_pin_13, t6.from_api AS from_api_14, t6.user_id AS user_id_15, t6.employee_group_id AS employee_group_id_16, t6.language_id AS language_id_17 FROM user t0 LEFT JOIN employee t6 ON t6.user_id = t0.id WHERE t0.id = 2 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO receipt_user (
  email, roles, password, account_id,
  user_id, receipt_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO receipt_user (email, roles, password, account_id, user_id, receipt_id) VALUES ('durbengmbh@swtpos.de', '[\"ROLE_ADMIN\",\"ROLE_USER\"]', '$argon2id$v=19$m=65536,t=4,p=1$ozGmGmGSAOvwNCg6ICu/dw$vcmNV8SVq3nBjExc+BpHyT0UZMXtnb4oanfPRcppxP8', 18, 2, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO receipt_employee (
  given_name, family_name, external_identifier,
  telephone, status, lock_pin, from_api,
  receipt_user_id, receipt_employee_group_id,
  employee_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO receipt_employee (given_name, family_name, external_identifier, telephone, status, lock_pin, from_api, receipt_user_id, receipt_employee_group_id, employee_id) VALUES ('Durben GmbH', 'Gastro- und Eventlieferanten', NULL, NULL, 1, '41564', 1, 7351, NULL, 1);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.street_address AS street_address_4,
  t0.postal_code AS postal_code_5,
  t0.address_locality AS address_locality_6,
  t0.address_addition AS address_addition_7,
  t0.address_country AS address_country_8,
  t0.telephone AS telephone_9,
  t0.website AS website_10,
  t0.email AS email_11,
  t0.fax_number AS fax_number_12,
  t0.show_address_on_receipt AS show_address_on_receipt_13,
  t0.show_contact_on_receipt AS show_contact_on_receipt_14,
  t15.id AS id_16,
  t15.tss_id AS tss_id_17,
  t15.admin_puk AS admin_puk_18,
  t15.admin_pin AS admin_pin_19,
  t15.is_initialized AS is_initialized_20,
  t15.has_admin AS has_admin_21,
  t15.status AS status_22,
  t15.is_disabled AS is_disabled_23,
  t15.add_date AS add_date_24,
  t15.location_id AS location_id_25
FROM
  location t0
  LEFT JOIN fiskaly_tss t15 ON t15.location_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.street_address AS street_address_4, t0.postal_code AS postal_code_5, t0.address_locality AS address_locality_6, t0.address_addition AS address_addition_7, t0.address_country AS address_country_8, t0.telephone AS telephone_9, t0.website AS website_10, t0.email AS email_11, t0.fax_number AS fax_number_12, t0.show_address_on_receipt AS show_address_on_receipt_13, t0.show_contact_on_receipt AS show_contact_on_receipt_14, t15.id AS id_16, t15.tss_id AS tss_id_17, t15.admin_puk AS admin_puk_18, t15.admin_pin AS admin_pin_19, t15.is_initialized AS is_initialized_20, t15.has_admin AS has_admin_21, t15.status AS status_22, t15.is_disabled AS is_disabled_23, t15.add_date AS add_date_24, t15.location_id AS location_id_25 FROM location t0 LEFT JOIN fiskaly_tss t15 ON t15.location_id = t0.id WHERE t0.id = 1;