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.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';

SELECT
  t0.order_id AS order_id_1,
  t0.invoice_no AS invoice_no_2,
  t0.comment AS comment_3,
  t0.order_status_id AS order_status_id_4,
  t0.date_added AS date_added_5,
  t0.date_modified AS date_modified_6,
  t0.billbee_order_id AS billbee_order_id_7,
  t0.pick_comment AS pick_comment_8,
  t0.bb_comment AS bb_comment_9,
  t0.order_status_id AS order_status_id_10
FROM
  wc_order t0
WHERE
  t0.order_id = ?

SELECT t0.order_id AS order_id_1, t0.invoice_no AS invoice_no_2, t0.comment AS comment_3, t0.order_status_id AS order_status_id_4, t0.date_added AS date_added_5, t0.date_modified AS date_modified_6, t0.billbee_order_id AS billbee_order_id_7, t0.pick_comment AS pick_comment_8, t0.bb_comment AS bb_comment_9, t0.order_status_id AS order_status_id_10 FROM wc_order t0 WHERE t0.order_id = '1318164';

SELECT
  t0.id AS id_1,
  t0.code_number AS code_number_2,
  t0.product_id AS product_id_3,
  t0.order_product_id AS order_product_id_4,
  t0.manufacturer_id AS manufacturer_id_5,
  t0.model AS model_6,
  t0.quantity AS quantity_7,
  t0.quantity_old AS quantity_old_8,
  t0.order_id AS order_id_9,
  t0.wc_order_id AS wc_order_id_10,
  t0.list_id AS list_id_11,
  t0.state_id AS state_id_12,
  t0.label_printed_at AS label_printed_at_13,
  t0.code_number_seen AS code_number_seen_14,
  t0.ordered_at AS ordered_at_15,
  t0.ordered_amount AS ordered_amount_16,
  t0.email_sent_at AS email_sent_at_17,
  t0.user_id AS user_id_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.pickup_mail_sent AS pickup_mail_sent_21,
  t0.list_id AS list_id_22,
  t0.manufacturer_id AS manufacturer_id_23,
  t0.state_id AS state_id_24,
  t0.order_id AS order_id_25,
  t0.wc_order_id AS wc_order_id_26,
  t0.product_id AS product_id_27,
  t0.user_id AS user_id_28
FROM
  lv_stockout t0
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.code_number AS code_number_2, t0.product_id AS product_id_3, t0.order_product_id AS order_product_id_4, t0.manufacturer_id AS manufacturer_id_5, t0.model AS model_6, t0.quantity AS quantity_7, t0.quantity_old AS quantity_old_8, t0.order_id AS order_id_9, t0.wc_order_id AS wc_order_id_10, t0.list_id AS list_id_11, t0.state_id AS state_id_12, t0.label_printed_at AS label_printed_at_13, t0.code_number_seen AS code_number_seen_14, t0.ordered_at AS ordered_at_15, t0.ordered_amount AS ordered_amount_16, t0.email_sent_at AS email_sent_at_17, t0.user_id AS user_id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.pickup_mail_sent AS pickup_mail_sent_21, t0.list_id AS list_id_22, t0.manufacturer_id AS manufacturer_id_23, t0.state_id AS state_id_24, t0.order_id AS order_id_25, t0.wc_order_id AS wc_order_id_26, t0.product_id AS product_id_27, t0.user_id AS user_id_28 FROM lv_stockout t0 WHERE t0.order_id = 1318164;

SELECT
  t0.order_history_id AS order_history_id_1,
  t0.order_id AS order_id_2,
  t0.order_status_id AS order_status_id_3,
  t0.notify AS notify_4,
  t0.comment AS comment_5,
  t0.date_added AS date_added_6,
  t0.order_id AS order_id_7
FROM
  oc_order_history t0
WHERE
  t0.order_id = ?

SELECT t0.order_history_id AS order_history_id_1, t0.order_id AS order_id_2, t0.order_status_id AS order_status_id_3, t0.notify AS notify_4, t0.comment AS comment_5, t0.date_added AS date_added_6, t0.order_id AS order_id_7 FROM oc_order_history t0 WHERE t0.order_id = 1318164;

SELECT
  t0.order_status_id AS order_status_id_1,
  t0.language_id AS language_id_2,
  t0.name AS name_3
FROM
  oc_order_status_german t0
WHERE
  t0.order_status_id = ?

SELECT t0.order_status_id AS order_status_id_1, t0.language_id AS language_id_2, t0.name AS name_3 FROM oc_order_status_german t0 WHERE t0.order_status_id = 2;

SELECT
  t0.order_total_id AS order_total_id_1,
  t0.order_id AS order_id_2,
  t0.code AS code_3,
  t0.title AS title_4,
  t0.text AS text_5,
  t0.value AS value_6,
  t0.sort_order AS sort_order_7,
  t0.order_id AS order_id_8
FROM
  oc_order_total t0
WHERE
  t0.order_id = ?

SELECT t0.order_total_id AS order_total_id_1, t0.order_id AS order_id_2, t0.code AS code_3, t0.title AS title_4, t0.text AS text_5, t0.value AS value_6, t0.sort_order AS sort_order_7, t0.order_id AS order_id_8 FROM oc_order_total t0 WHERE t0.order_id = 1318164;

SELECT
  o0_.order_product_id AS order_product_id_0,
  o0_.order_id AS order_id_1,
  o0_.product_id AS product_id_2,
  o0_.name AS name_3,
  o0_.model AS model_4,
  o0_.quantity AS quantity_5,
  o0_.price AS price_6,
  o0_.total AS total_7,
  o0_.tax AS tax_8,
  o0_.reward AS reward_9,
  o0_.svg_image AS svg_image_10,
  o0_.packed_by_user_id AS packed_by_user_id_11,
  o0_.packed_by_user_id AS packed_by_user_id_12,
  o0_.order_id AS order_id_13,
  o0_.product_id AS product_id_14
FROM
  oc_order_product o0_
  LEFT JOIN oc_product o1_ ON o0_.product_id = o1_.product_id
  LEFT JOIN lv_lagerort_to_product l3_ ON o1_.product_id = l3_.product_id
  LEFT JOIN lv_lagerort l2_ ON l2_.id = l3_.lagerort_id
  LEFT JOIN lv_lagerbereich l4_ ON l2_.lagerbereich_id = l4_.id
  LEFT JOIN lv_regal l5_ ON l2_.regal_id = l5_.id
WHERE
  o0_.order_id = ?
  AND o0_.packed_by_user_id = 0
  AND o1_.tax_class_id <> 13
ORDER BY
  l2_.lager_id ASC,
  l4_.attribut_id DESC,
  l4_.name ASC,
  l5_.name ASC,
  l2_.segment ASC,
  l2_.regalboden ASC,
  o0_.model ASC

SELECT o0_.order_product_id AS order_product_id_0, o0_.order_id AS order_id_1, o0_.product_id AS product_id_2, o0_.name AS name_3, o0_.model AS model_4, o0_.quantity AS quantity_5, o0_.price AS price_6, o0_.total AS total_7, o0_.tax AS tax_8, o0_.reward AS reward_9, o0_.svg_image AS svg_image_10, o0_.packed_by_user_id AS packed_by_user_id_11, o0_.packed_by_user_id AS packed_by_user_id_12, o0_.order_id AS order_id_13, o0_.product_id AS product_id_14 FROM oc_order_product o0_ LEFT JOIN oc_product o1_ ON o0_.product_id = o1_.product_id LEFT JOIN lv_lagerort_to_product l3_ ON o1_.product_id = l3_.product_id LEFT JOIN lv_lagerort l2_ ON l2_.id = l3_.lagerort_id LEFT JOIN lv_lagerbereich l4_ ON l2_.lagerbereich_id = l4_.id LEFT JOIN lv_regal l5_ ON l2_.regal_id = l5_.id WHERE o0_.order_id = 1318164 AND o0_.packed_by_user_id = 0 AND o1_.tax_class_id <> 13 ORDER BY l2_.lager_id ASC, l4_.attribut_id DESC, l4_.name ASC, l5_.name ASC, l2_.segment ASC, l2_.regalboden ASC, o0_.model ASC;

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.order_id = ?

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.order_id = 1318164;

SELECT
  t0.product_id AS product_id_1,
  t0.model AS model_2,
  t0.sku AS sku_3,
  t0.quantity AS quantity_4,
  t0.warn_stock AS warn_stock_5,
  t0.image AS image_6,
  t0.video AS video_7,
  t0.manufacturer_id AS manufacturer_id_8,
  t0.designer_id AS designer_id_9,
  t0.designer_provision AS designer_provision_10,
  t0.shipping AS shipping_11,
  t0.price AS price_12,
  t0.input_price AS input_price_13,
  t0.unit_id AS unit_id_14,
  t0.units_per_item AS units_per_item_15,
  t0.points AS points_16,
  t0.tax_class_id AS tax_class_id_17,
  t0.date_available AS date_available_18,
  t0.weight AS weight_19,
  t0.length AS length_20,
  t0.width AS width_21,
  t0.height AS height_22,
  t0.subtract AS subtract_23,
  t0.minimum AS minimum_24,
  t0.maximum AS maximum_25,
  t0.sort_order AS sort_order_26,
  t0.status AS status_27,
  t0.date_added AS date_added_28,
  t0.date_modified AS date_modified_29,
  t0.viewed AS viewed_30,
  t0.stamp_preset AS stamp_preset_31,
  t0.template_id AS template_id_32,
  t0.reorder AS reorder_33,
  t0.reorder_date AS reorder_date_34,
  t0.seller_article_nr AS seller_article_nr_35,
  t0.startpage_hide AS startpage_hide_36,
  t0.sw_id AS sw_id_37,
  t0.sw_custom_template AS sw_custom_template_38,
  t0.selected_yarns_id AS selected_yarns_id_39,
  t0.billbee_id AS billbee_id_40,
  t0.beton_id AS beton_id_41,
  t0.tiktok_id AS tiktok_id_42,
  t0.is_wc_main AS is_wc_main_43,
  t0.product_group_id AS product_group_id_44,
  t0.has_options AS has_options_45,
  t0.is_box_main_product AS is_box_main_product_46,
  t0.box_quantity AS box_quantity_47,
  t0.mix_and_match AS mix_and_match_48,
  t0.manufacturer_id AS manufacturer_id_49,
  t0.designer_id AS designer_id_50,
  t0.template_id AS template_id_51,
  t0.stock_status_id AS stock_status_id_52,
  t0.unit_id AS unit_id_53,
  t0.tax_class_id AS tax_class_id_54,
  t0.box_main_product AS box_main_product_55,
  t0.product_group_id AS product_group_id_56
FROM
  oc_product t0
WHERE
  t0.product_id = ?

SELECT t0.product_id AS product_id_1, t0.model AS model_2, t0.sku AS sku_3, t0.quantity AS quantity_4, t0.warn_stock AS warn_stock_5, t0.image AS image_6, t0.video AS video_7, t0.manufacturer_id AS manufacturer_id_8, t0.designer_id AS designer_id_9, t0.designer_provision AS designer_provision_10, t0.shipping AS shipping_11, t0.price AS price_12, t0.input_price AS input_price_13, t0.unit_id AS unit_id_14, t0.units_per_item AS units_per_item_15, t0.points AS points_16, t0.tax_class_id AS tax_class_id_17, t0.date_available AS date_available_18, t0.weight AS weight_19, t0.length AS length_20, t0.width AS width_21, t0.height AS height_22, t0.subtract AS subtract_23, t0.minimum AS minimum_24, t0.maximum AS maximum_25, t0.sort_order AS sort_order_26, t0.status AS status_27, t0.date_added AS date_added_28, t0.date_modified AS date_modified_29, t0.viewed AS viewed_30, t0.stamp_preset AS stamp_preset_31, t0.template_id AS template_id_32, t0.reorder AS reorder_33, t0.reorder_date AS reorder_date_34, t0.seller_article_nr AS seller_article_nr_35, t0.startpage_hide AS startpage_hide_36, t0.sw_id AS sw_id_37, t0.sw_custom_template AS sw_custom_template_38, t0.selected_yarns_id AS selected_yarns_id_39, t0.billbee_id AS billbee_id_40, t0.beton_id AS beton_id_41, t0.tiktok_id AS tiktok_id_42, t0.is_wc_main AS is_wc_main_43, t0.product_group_id AS product_group_id_44, t0.has_options AS has_options_45, t0.is_box_main_product AS is_box_main_product_46, t0.box_quantity AS box_quantity_47, t0.mix_and_match AS mix_and_match_48, t0.manufacturer_id AS manufacturer_id_49, t0.designer_id AS designer_id_50, t0.template_id AS template_id_51, t0.stock_status_id AS stock_status_id_52, t0.unit_id AS unit_id_53, t0.tax_class_id AS tax_class_id_54, t0.box_main_product AS box_main_product_55, t0.product_group_id AS product_group_id_56 FROM oc_product t0 WHERE t0.product_id = 75705;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.language_id AS language_id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.meta_description AS meta_description_6,
  t0.meta_keyword AS meta_keyword_7,
  t0.lock_overwrite AS lock_overwrite_8,
  t0.product_id AS product_id_9
FROM
  oc_product_description t0
WHERE
  (
    t0.language_id = ?
    AND t0.product_id = ?
  )

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.language_id AS language_id_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.meta_keyword AS meta_keyword_7, t0.lock_overwrite AS lock_overwrite_8, t0.product_id AS product_id_9 FROM oc_product_description t0 WHERE (t0.language_id = 2 AND t0.product_id = 75705);

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.language_id AS language_id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.meta_description AS meta_description_6,
  t0.meta_keyword AS meta_keyword_7,
  t0.lock_overwrite AS lock_overwrite_8,
  t0.product_id AS product_id_9
FROM
  oc_product_description t0
WHERE
  (
    t0.language_id = ?
    AND t0.product_id = ?
  )

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.language_id AS language_id_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.meta_keyword AS meta_keyword_7, t0.lock_overwrite AS lock_overwrite_8, t0.product_id AS product_id_9 FROM oc_product_description t0 WHERE (t0.language_id = 2 AND t0.product_id = 75705);

SELECT
  t0.id AS id_1,
  t0.regal_id AS regal_id_2,
  t0.segment AS segment_3,
  t0.regalboden AS regalboden_4,
  t0.zusatz AS zusatz_5,
  t0.lager_id AS lager_id_6,
  t0.lagerbereich_id AS lagerbereich_id_7,
  t0.Bemerkungen AS Bemerkungen_8,
  t0.delete_if_empty AS delete_if_empty_9,
  t0.regal_id AS regal_id_10,
  t0.lager_id AS lager_id_11,
  t0.lagerbereich_id AS lagerbereich_id_12
FROM
  lv_lagerort t0
  INNER JOIN lv_lagerort_to_product ON t0.id = lv_lagerort_to_product.lagerort_id
WHERE
  lv_lagerort_to_product.product_id = ?

SELECT t0.id AS id_1, t0.regal_id AS regal_id_2, t0.segment AS segment_3, t0.regalboden AS regalboden_4, t0.zusatz AS zusatz_5, t0.lager_id AS lager_id_6, t0.lagerbereich_id AS lagerbereich_id_7, t0.Bemerkungen AS Bemerkungen_8, t0.delete_if_empty AS delete_if_empty_9, t0.regal_id AS regal_id_10, t0.lager_id AS lager_id_11, t0.lagerbereich_id AS lagerbereich_id_12 FROM lv_lagerort t0 INNER JOIN lv_lagerort_to_product ON t0.id = lv_lagerort_to_product.lagerort_id WHERE lv_lagerort_to_product.product_id = 75705;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_in_picking AS is_in_picking_3
FROM
  lp_printer_roll t0
  INNER JOIN lp_order_product_roll ON t0.id = lp_order_product_roll.printer_roll_id
WHERE
  lp_order_product_roll.order_product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_in_picking AS is_in_picking_3 FROM lp_printer_roll t0 INNER JOIN lp_order_product_roll ON t0.id = lp_order_product_roll.printer_roll_id WHERE lp_order_product_roll.order_product_id = 11839175;

SELECT
  t0.order_option_id AS order_option_id_1,
  t0.order_id AS order_id_2,
  t0.order_product_id AS order_product_id_3,
  t0.product_option_id AS product_option_id_4,
  t0.product_option_value_id AS product_option_value_id_5,
  t0.name AS name_6,
  t0.value AS value_7,
  t0.type AS type_8,
  t0.order_product_id AS order_product_id_9,
  t0.order_id AS order_id_10,
  t0.product_option_value_id AS product_option_value_id_11
FROM
  oc_order_option t0
WHERE
  t0.order_product_id = ?

SELECT t0.order_option_id AS order_option_id_1, t0.order_id AS order_id_2, t0.order_product_id AS order_product_id_3, t0.product_option_id AS product_option_id_4, t0.product_option_value_id AS product_option_value_id_5, t0.name AS name_6, t0.value AS value_7, t0.type AS type_8, t0.order_product_id AS order_product_id_9, t0.order_id AS order_id_10, t0.product_option_value_id AS product_option_value_id_11 FROM oc_order_option t0 WHERE t0.order_product_id = 11839175;