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.email_address AS email_address_5,
  t0.roles AS roles_6,
  t0.password_new AS password_new_7,
  t0.token AS token_8,
  t0.is_active AS is_active_9,
  t0.salt AS salt_10
FROM
  sf_guard_user t0
WHERE
  t0.token = ?
LIMIT
  1

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.email_address AS email_address_5, t0.roles AS roles_6, t0.password_new AS password_new_7, t0.token AS token_8, t0.is_active AS is_active_9, t0.salt AS salt_10 FROM sf_guard_user t0 WHERE t0.token = 'k0PKUVYvFUzfwqvbosRW' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.token AS token_3,
  t0.avatar AS avatar_4,
  t0.user_id AS user_id_5
FROM
  lv_app_user t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.token AS token_3, t0.avatar AS avatar_4, t0.user_id AS user_id_5 FROM lv_app_user t0 WHERE t0.token = 'k0PKUVYvFUzfwqvbosRW' LIMIT 1;

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.email_address AS email_address_5,
  t0.roles AS roles_6,
  t0.password_new AS password_new_7,
  t0.token AS token_8,
  t0.is_active AS is_active_9,
  t0.salt AS salt_10
FROM
  sf_guard_user t0
WHERE
  t0.id = ?
LIMIT
  1

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.email_address AS email_address_5, t0.roles AS roles_6, t0.password_new AS password_new_7, t0.token AS token_8, t0.is_active AS is_active_9, t0.salt AS salt_10 FROM sf_guard_user t0 WHERE t0.id = '31' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ean13 AS ean13_2,
  t0.order_id AS order_id_3,
  t0.picking_area_id AS picking_area_id_4,
  t0.user_id AS user_id_5,
  t0.label_printed AS label_printed_6,
  t0.user_id AS user_id_7,
  t0.order_id AS order_id_8,
  t0.picking_area_id AS picking_area_id_9
FROM
  lv_picking_tote t0
WHERE
  t0.ean13 = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ean13 AS ean13_2, t0.order_id AS order_id_3, t0.picking_area_id AS picking_area_id_4, t0.user_id AS user_id_5, t0.label_printed AS label_printed_6, t0.user_id AS user_id_7, t0.order_id AS order_id_8, t0.picking_area_id AS picking_area_id_9 FROM lv_picking_tote t0 WHERE t0.ean13 = '5000000000210' LIMIT 1;

SELECT
  t0.order_id AS order_id_1,
  t0.invoice_no AS invoice_no_2,
  t0.invoice_prefix AS invoice_prefix_3,
  t0.store_id AS store_id_4,
  t0.store_name AS store_name_5,
  t0.store_url AS store_url_6,
  t0.customer_id AS customer_id_7,
  t0.customer_group_id AS customer_group_id_8,
  t0.firstname AS firstname_9,
  t0.lastname AS lastname_10,
  t0.email AS email_11,
  t0.telephone AS telephone_12,
  t0.fax AS fax_13,
  t0.ust_id AS ust_id_14,
  t0.shipping_firstname AS shipping_firstname_15,
  t0.shipping_lastname AS shipping_lastname_16,
  t0.shipping_company AS shipping_company_17,
  t0.shipping_address_1 AS shipping_address_1_18,
  t0.shipping_address_2 AS shipping_address_2_19,
  t0.shipping_city AS shipping_city_20,
  t0.shipping_postcode AS shipping_postcode_21,
  t0.shipping_country AS shipping_country_22,
  t0.shipping_country_id AS shipping_country_id_23,
  t0.shipping_zone AS shipping_zone_24,
  t0.shipping_zone_id AS shipping_zone_id_25,
  t0.shipping_address_format AS shipping_address_format_26,
  t0.shipping_method AS shipping_method_27,
  t0.shipping_delivery AS shipping_delivery_28,
  t0.shipping_code AS shipping_code_29,
  t0.payment_firstname AS payment_firstname_30,
  t0.payment_lastname AS payment_lastname_31,
  t0.payment_company AS payment_company_32,
  t0.payment_address_1 AS payment_address_1_33,
  t0.payment_address_2 AS payment_address_2_34,
  t0.payment_city AS payment_city_35,
  t0.payment_postcode AS payment_postcode_36,
  t0.payment_country AS payment_country_37,
  t0.payment_country_id AS payment_country_id_38,
  t0.payment_zone AS payment_zone_39,
  t0.payment_zone_id AS payment_zone_id_40,
  t0.payment_address_format AS payment_address_format_41,
  t0.payment_method AS payment_method_42,
  t0.payment_code AS payment_code_43,
  t0.comment AS comment_44,
  t0.preisanpassung AS preisanpassung_45,
  t0.preisanpassung_text AS preisanpassung_text_46,
  t0.total AS total_47,
  t0.reward AS reward_48,
  t0.order_status_id AS order_status_id_49,
  t0.affiliate_id AS affiliate_id_50,
  t0.commission AS commission_51,
  t0.language_id AS language_id_52,
  t0.currency_id AS currency_id_53,
  t0.currency_code AS currency_code_54,
  t0.currency_value AS currency_value_55,
  t0.date_added AS date_added_56,
  t0.date_modified AS date_modified_57,
  t0.ip AS ip_58,
  t0.forwarded_ip AS forwarded_ip_59,
  t0.user_agent AS user_agent_60,
  t0.accept_language AS accept_language_61,
  t0.rechnungsdruck AS rechnungsdruck_62,
  t0.billbee_order_id AS billbee_order_id_63,
  t0.delayed_order_id AS delayed_order_id_64,
  t0.voided AS voided_65,
  t0.picking_area_id AS picking_area_id_66,
  t0.has_dropshipping AS has_dropshipping_67,
  t0.pick_comment AS pick_comment_68,
  t0.order_status_id AS order_status_id_69,
  t0.picking_area_id AS picking_area_id_70
FROM
  oc_order t0
WHERE
  t0.order_id = ?

SELECT t0.order_id AS order_id_1, t0.invoice_no AS invoice_no_2, t0.invoice_prefix AS invoice_prefix_3, t0.store_id AS store_id_4, t0.store_name AS store_name_5, t0.store_url AS store_url_6, t0.customer_id AS customer_id_7, t0.customer_group_id AS customer_group_id_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.ust_id AS ust_id_14, t0.shipping_firstname AS shipping_firstname_15, t0.shipping_lastname AS shipping_lastname_16, t0.shipping_company AS shipping_company_17, t0.shipping_address_1 AS shipping_address_1_18, t0.shipping_address_2 AS shipping_address_2_19, t0.shipping_city AS shipping_city_20, t0.shipping_postcode AS shipping_postcode_21, t0.shipping_country AS shipping_country_22, t0.shipping_country_id AS shipping_country_id_23, t0.shipping_zone AS shipping_zone_24, t0.shipping_zone_id AS shipping_zone_id_25, t0.shipping_address_format AS shipping_address_format_26, t0.shipping_method AS shipping_method_27, t0.shipping_delivery AS shipping_delivery_28, t0.shipping_code AS shipping_code_29, t0.payment_firstname AS payment_firstname_30, t0.payment_lastname AS payment_lastname_31, t0.payment_company AS payment_company_32, t0.payment_address_1 AS payment_address_1_33, t0.payment_address_2 AS payment_address_2_34, t0.payment_city AS payment_city_35, t0.payment_postcode AS payment_postcode_36, t0.payment_country AS payment_country_37, t0.payment_country_id AS payment_country_id_38, t0.payment_zone AS payment_zone_39, t0.payment_zone_id AS payment_zone_id_40, t0.payment_address_format AS payment_address_format_41, t0.payment_method AS payment_method_42, t0.payment_code AS payment_code_43, t0.comment AS comment_44, t0.preisanpassung AS preisanpassung_45, t0.preisanpassung_text AS preisanpassung_text_46, t0.total AS total_47, t0.reward AS reward_48, t0.order_status_id AS order_status_id_49, t0.affiliate_id AS affiliate_id_50, t0.commission AS commission_51, t0.language_id AS language_id_52, t0.currency_id AS currency_id_53, t0.currency_code AS currency_code_54, t0.currency_value AS currency_value_55, t0.date_added AS date_added_56, t0.date_modified AS date_modified_57, t0.ip AS ip_58, t0.forwarded_ip AS forwarded_ip_59, t0.user_agent AS user_agent_60, t0.accept_language AS accept_language_61, t0.rechnungsdruck AS rechnungsdruck_62, t0.billbee_order_id AS billbee_order_id_63, t0.delayed_order_id AS delayed_order_id_64, t0.voided AS voided_65, t0.picking_area_id AS picking_area_id_66, t0.has_dropshipping AS has_dropshipping_67, t0.pick_comment AS pick_comment_68, t0.order_status_id AS order_status_id_69, t0.picking_area_id AS picking_area_id_70 FROM oc_order t0 WHERE t0.order_id = 1318164;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO lv_picking_history (
  user_id, order_id, picking_area_id,
  picking_tote_id, action, date_added
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO lv_picking_history (user_id, order_id, picking_area_id, picking_tote_id, action, date_added) VALUES (31, 1318164, 6, 21, 'weitere Station: Kiste gescannt', '2026-05-06 11:10:30');

"COMMIT"

"COMMIT";