Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.language_id AS language_id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.description_short AS description_short_6,
  t0.unit AS unit_7,
  t0.meta_description AS meta_description_8,
  t0.meta_keyword AS meta_keyword_9,
  t0.meta_title AS meta_title_10,
  t0.category_id AS category_id_11
FROM
  oc_category_description t0
WHERE
  (
    t0.language_id = ?
    AND t0.category_id = ?
  )

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.language_id AS language_id_3, t0.name AS name_4, t0.description AS description_5, t0.description_short AS description_short_6, t0.unit AS unit_7, t0.meta_description AS meta_description_8, t0.meta_keyword AS meta_keyword_9, t0.meta_title AS meta_title_10, t0.category_id AS category_id_11 FROM oc_category_description t0 WHERE (t0.language_id = 2 AND t0.category_id = 592);

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 = 9758;

SELECT
  count(DISTINCT o0_.product_id) AS sclr_0
FROM
  oc_product o0_
WHERE
  o0_.tax_class_id <> 13

SELECT count(DISTINCT o0_.product_id) AS sclr_0 FROM oc_product o0_ WHERE o0_.tax_class_id <> 13;

SELECT
  t0.id AS id_1,
  t0.tax_id AS tax_id_2,
  t0.rate AS rate_3
FROM
  lager_tax t0
WHERE
  t0.tax_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tax_id AS tax_id_2, t0.rate AS rate_3 FROM lager_tax t0 WHERE t0.tax_id = 11 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.lagerort_id AS lagerort_id_2,
  t0.product_id AS product_id_3,
  t0.quantity AS quantity_4,
  t0.product_id AS product_id_5,
  t0.lagerort_id AS lagerort_id_6
FROM
  lv_lagerort_to_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.lagerort_id AS lagerort_id_2, t0.product_id AS product_id_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.lagerort_id AS lagerort_id_6 FROM lv_lagerort_to_product t0 WHERE t0.product_id = 76870;

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 = 9758);

SELECT
  o0_.category_id AS category_id_0,
  o0_.image AS image_1,
  o0_.image_startpage AS image_startpage_2,
  o0_.image_startpage_new AS image_startpage_new_3,
  o0_.parent_id AS parent_id_4,
  o0_.top AS top_5,
  o0_.template_id AS template_id_6,
  o0_.sort_order AS sort_order_7,
  o0_.discounts AS discounts_8,
  o0_.status AS status_9,
  o0_.ext_link AS ext_link_10,
  o0_.show_inactive AS show_inactive_11,
  o0_.show_in_circle_banner AS show_in_circle_banner_12,
  o0_.show_on_startpage_cat AS show_on_startpage_cat_13,
  o0_.show_on_startpage_inspiration AS show_on_startpage_inspiration_14,
  o0_.startpage_inspiration_filter AS startpage_inspiration_filter_15,
  o0_.show_on_startpage_cat_new AS show_on_startpage_cat_new_16,
  o0_.show_on_startpage_new_mixed AS show_on_startpage_new_mixed_17,
  o0_.is_hot AS is_hot_18,
  o0_.highlight AS highlight_19,
  o0_.sw_category AS sw_category_20,
  o0_.canonical AS canonical_21,
  o0_.is_digital AS is_digital_22,
  o0_.date_added AS date_added_23,
  o0_.date_modified AS date_modified_24
FROM
  oc_category o0_
  LEFT JOIN oc_category_description o1_ ON o0_.category_id = o1_.category_id
WHERE
  (
    o0_.status = 1
    OR o1_.name LIKE 'Geschenke'
  )
  AND o0_.is_digital = 0
  AND o1_.language_id = 2
ORDER BY
  o1_.name ASC

SELECT o0_.category_id AS category_id_0, o0_.image AS image_1, o0_.image_startpage AS image_startpage_2, o0_.image_startpage_new AS image_startpage_new_3, o0_.parent_id AS parent_id_4, o0_.top AS top_5, o0_.template_id AS template_id_6, o0_.sort_order AS sort_order_7, o0_.discounts AS discounts_8, o0_.status AS status_9, o0_.ext_link AS ext_link_10, o0_.show_inactive AS show_inactive_11, o0_.show_in_circle_banner AS show_in_circle_banner_12, o0_.show_on_startpage_cat AS show_on_startpage_cat_13, o0_.show_on_startpage_inspiration AS show_on_startpage_inspiration_14, o0_.startpage_inspiration_filter AS startpage_inspiration_filter_15, o0_.show_on_startpage_cat_new AS show_on_startpage_cat_new_16, o0_.show_on_startpage_new_mixed AS show_on_startpage_new_mixed_17, o0_.is_hot AS is_hot_18, o0_.highlight AS highlight_19, o0_.sw_category AS sw_category_20, o0_.canonical AS canonical_21, o0_.is_digital AS is_digital_22, o0_.date_added AS date_added_23, o0_.date_modified AS date_modified_24 FROM oc_category o0_ LEFT JOIN oc_category_description o1_ ON o0_.category_id = o1_.category_id WHERE (o0_.status = 1 OR o1_.name LIKE 'Geschenke') AND o0_.is_digital = 0 AND o1_.language_id = 2 ORDER BY o1_.name ASC;

SELECT
  SUM(o0_.quantity) AS sclr_0
FROM
  oc_order_product o0_
  LEFT JOIN oc_order o1_ ON o0_.order_id = o1_.order_id
  LEFT JOIN oc_product o2_ ON o0_.product_id = o2_.product_id
WHERE
  o0_.product_id = ?
  AND (
    (
      o1_.order_status_id = 1
      OR o1_.order_status_id = 2
      OR o1_.order_status_id = 14
      OR o1_.order_status_id = 17
      OR o1_.order_status_id = 16
      OR o1_.order_status_id = 19
      OR o1_.order_status_id = 21
    )
  )
  AND o1_.date_modified >= ?
  AND o2_.tax_class_id <> 13

SELECT SUM(o0_.quantity) AS sclr_0 FROM oc_order_product o0_ LEFT JOIN oc_order o1_ ON o0_.order_id = o1_.order_id LEFT JOIN oc_product o2_ ON o0_.product_id = o2_.product_id WHERE o0_.product_id = 9758 AND ((o1_.order_status_id = 1 OR o1_.order_status_id = 2 OR o1_.order_status_id = 14 OR o1_.order_status_id = 17 OR o1_.order_status_id = 16 OR o1_.order_status_id = 19 OR o1_.order_status_id = 21)) AND o1_.date_modified >= '2026-04-01 12:13:49' AND o2_.tax_class_id <> 13;

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 = ?
LIMIT
  1

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 = 9758 LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.product_id AS product_id_1,
  l0_.user_id AS user_id_2,
  l0_.quant_before AS quant_before_3,
  l0_.quant_after AS quant_after_4,
  l0_.diff AS diff_5,
  l0_.cart_amount AS cart_amount_6,
  l0_.afsm_open AS afsm_open_7,
  l0_.dawanda AS dawanda_8,
  l0_.dawanda_open AS dawanda_open_9,
  l0_.hzg AS hzg_10,
  l0_.modify_reason_id AS modify_reason_id_11,
  l0_.comment AS comment_12,
  l0_.date_modified AS date_modified_13,
  l0_.product_id AS product_id_14,
  l0_.modify_reason_id AS modify_reason_id_15,
  l0_.user_id AS user_id_16
FROM
  lager_product_user l0_
WHERE
  l0_.product_id = ?
ORDER BY
  l0_.date_modified DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.product_id AS product_id_1, l0_.user_id AS user_id_2, l0_.quant_before AS quant_before_3, l0_.quant_after AS quant_after_4, l0_.diff AS diff_5, l0_.cart_amount AS cart_amount_6, l0_.afsm_open AS afsm_open_7, l0_.dawanda AS dawanda_8, l0_.dawanda_open AS dawanda_open_9, l0_.hzg AS hzg_10, l0_.modify_reason_id AS modify_reason_id_11, l0_.comment AS comment_12, l0_.date_modified AS date_modified_13, l0_.product_id AS product_id_14, l0_.modify_reason_id AS modify_reason_id_15, l0_.user_id AS user_id_16 FROM lager_product_user l0_ WHERE l0_.product_id = 9758 ORDER BY l0_.date_modified DESC LIMIT 1;

SELECT
  t0.category_id AS category_id_1,
  t0.image AS image_2,
  t0.image_startpage AS image_startpage_3,
  t0.image_startpage_new AS image_startpage_new_4,
  t0.parent_id AS parent_id_5,
  t0.top AS top_6,
  t0.template_id AS template_id_7,
  t0.sort_order AS sort_order_8,
  t0.discounts AS discounts_9,
  t0.status AS status_10,
  t0.ext_link AS ext_link_11,
  t0.show_inactive AS show_inactive_12,
  t0.show_in_circle_banner AS show_in_circle_banner_13,
  t0.show_on_startpage_cat AS show_on_startpage_cat_14,
  t0.show_on_startpage_inspiration AS show_on_startpage_inspiration_15,
  t0.startpage_inspiration_filter AS startpage_inspiration_filter_16,
  t0.show_on_startpage_cat_new AS show_on_startpage_cat_new_17,
  t0.show_on_startpage_new_mixed AS show_on_startpage_new_mixed_18,
  t0.is_hot AS is_hot_19,
  t0.highlight AS highlight_20,
  t0.sw_category AS sw_category_21,
  t0.canonical AS canonical_22,
  t0.is_digital AS is_digital_23,
  t0.date_added AS date_added_24,
  t0.date_modified AS date_modified_25
FROM
  oc_category t0
  INNER JOIN oc_product_to_category ON t0.category_id = oc_product_to_category.category_id
WHERE
  oc_product_to_category.product_id = ?

SELECT t0.category_id AS category_id_1, t0.image AS image_2, t0.image_startpage AS image_startpage_3, t0.image_startpage_new AS image_startpage_new_4, t0.parent_id AS parent_id_5, t0.top AS top_6, t0.template_id AS template_id_7, t0.sort_order AS sort_order_8, t0.discounts AS discounts_9, t0.status AS status_10, t0.ext_link AS ext_link_11, t0.show_inactive AS show_inactive_12, t0.show_in_circle_banner AS show_in_circle_banner_13, t0.show_on_startpage_cat AS show_on_startpage_cat_14, t0.show_on_startpage_inspiration AS show_on_startpage_inspiration_15, t0.startpage_inspiration_filter AS startpage_inspiration_filter_16, t0.show_on_startpage_cat_new AS show_on_startpage_cat_new_17, t0.show_on_startpage_new_mixed AS show_on_startpage_new_mixed_18, t0.is_hot AS is_hot_19, t0.highlight AS highlight_20, t0.sw_category AS sw_category_21, t0.canonical AS canonical_22, t0.is_digital AS is_digital_23, t0.date_added AS date_added_24, t0.date_modified AS date_modified_25 FROM oc_category t0 INNER JOIN oc_product_to_category ON t0.category_id = oc_product_to_category.category_id WHERE oc_product_to_category.product_id = 9758;

SELECT
  o0_.product_id AS product_id_0,
  o0_.model AS model_1,
  o0_.sku AS sku_2,
  o0_.quantity AS quantity_3,
  o0_.warn_stock AS warn_stock_4,
  o0_.image AS image_5,
  o0_.video AS video_6,
  o0_.manufacturer_id AS manufacturer_id_7,
  o0_.designer_id AS designer_id_8,
  o0_.designer_provision AS designer_provision_9,
  o0_.shipping AS shipping_10,
  o0_.price AS price_11,
  o0_.input_price AS input_price_12,
  o0_.unit_id AS unit_id_13,
  o0_.units_per_item AS units_per_item_14,
  o0_.points AS points_15,
  o0_.tax_class_id AS tax_class_id_16,
  o0_.date_available AS date_available_17,
  o0_.weight AS weight_18,
  o0_.length AS length_19,
  o0_.width AS width_20,
  o0_.height AS height_21,
  o0_.subtract AS subtract_22,
  o0_.minimum AS minimum_23,
  o0_.maximum AS maximum_24,
  o0_.sort_order AS sort_order_25,
  o0_.status AS status_26,
  o0_.date_added AS date_added_27,
  o0_.date_modified AS date_modified_28,
  o0_.viewed AS viewed_29,
  o0_.stamp_preset AS stamp_preset_30,
  o0_.template_id AS template_id_31,
  o0_.reorder AS reorder_32,
  o0_.reorder_date AS reorder_date_33,
  o0_.seller_article_nr AS seller_article_nr_34,
  o0_.startpage_hide AS startpage_hide_35,
  o0_.sw_id AS sw_id_36,
  o0_.sw_custom_template AS sw_custom_template_37,
  o0_.selected_yarns_id AS selected_yarns_id_38,
  o0_.billbee_id AS billbee_id_39,
  o0_.beton_id AS beton_id_40,
  o0_.tiktok_id AS tiktok_id_41,
  o0_.is_wc_main AS is_wc_main_42,
  o0_.product_group_id AS product_group_id_43,
  o0_.has_options AS has_options_44,
  o0_.is_box_main_product AS is_box_main_product_45,
  o0_.box_quantity AS box_quantity_46,
  o0_.mix_and_match AS mix_and_match_47,
  o0_.manufacturer_id AS manufacturer_id_48,
  o0_.designer_id AS designer_id_49,
  o0_.template_id AS template_id_50,
  o0_.stock_status_id AS stock_status_id_51,
  o0_.unit_id AS unit_id_52,
  o0_.tax_class_id AS tax_class_id_53,
  o0_.box_main_product AS box_main_product_54,
  o0_.product_group_id AS product_group_id_55
FROM
  oc_product o0_
WHERE
  o0_.tax_class_id <> 13
  AND o0_.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  o0_.date_added DESC

SELECT o0_.product_id AS product_id_0, o0_.model AS model_1, o0_.sku AS sku_2, o0_.quantity AS quantity_3, o0_.warn_stock AS warn_stock_4, o0_.image AS image_5, o0_.video AS video_6, o0_.manufacturer_id AS manufacturer_id_7, o0_.designer_id AS designer_id_8, o0_.designer_provision AS designer_provision_9, o0_.shipping AS shipping_10, o0_.price AS price_11, o0_.input_price AS input_price_12, o0_.unit_id AS unit_id_13, o0_.units_per_item AS units_per_item_14, o0_.points AS points_15, o0_.tax_class_id AS tax_class_id_16, o0_.date_available AS date_available_17, o0_.weight AS weight_18, o0_.length AS length_19, o0_.width AS width_20, o0_.height AS height_21, o0_.subtract AS subtract_22, o0_.minimum AS minimum_23, o0_.maximum AS maximum_24, o0_.sort_order AS sort_order_25, o0_.status AS status_26, o0_.date_added AS date_added_27, o0_.date_modified AS date_modified_28, o0_.viewed AS viewed_29, o0_.stamp_preset AS stamp_preset_30, o0_.template_id AS template_id_31, o0_.reorder AS reorder_32, o0_.reorder_date AS reorder_date_33, o0_.seller_article_nr AS seller_article_nr_34, o0_.startpage_hide AS startpage_hide_35, o0_.sw_id AS sw_id_36, o0_.sw_custom_template AS sw_custom_template_37, o0_.selected_yarns_id AS selected_yarns_id_38, o0_.billbee_id AS billbee_id_39, o0_.beton_id AS beton_id_40, o0_.tiktok_id AS tiktok_id_41, o0_.is_wc_main AS is_wc_main_42, o0_.product_group_id AS product_group_id_43, o0_.has_options AS has_options_44, o0_.is_box_main_product AS is_box_main_product_45, o0_.box_quantity AS box_quantity_46, o0_.mix_and_match AS mix_and_match_47, o0_.manufacturer_id AS manufacturer_id_48, o0_.designer_id AS designer_id_49, o0_.template_id AS template_id_50, o0_.stock_status_id AS stock_status_id_51, o0_.unit_id AS unit_id_52, o0_.tax_class_id AS tax_class_id_53, o0_.box_main_product AS box_main_product_54, o0_.product_group_id AS product_group_id_55 FROM oc_product o0_ WHERE o0_.tax_class_id <> 13 AND o0_.product_id IN (9758, 76870, 76869, 76868, 76866, 76865, 76864, 76862, 76861, 76860, 76859, 76858, 76857, 76856, 76855, 76854, 76853, 76852, 76851, 74471, 76849, 76848, 76846, 76844, 76843) ORDER BY o0_.date_added DESC;

SELECT
  SUM(l0_.diff) AS sclr_0
FROM
  lager_product_user l0_
WHERE
  l0_.product_id = ?
  AND l0_.modify_reason_id = 4
  AND l0_.date_modified >= ?

SELECT SUM(l0_.diff) AS sclr_0 FROM lager_product_user l0_ WHERE l0_.product_id = 9758 AND l0_.modify_reason_id = 4 AND l0_.date_modified >= '2026-05-04 12:13:49';

SELECT
  o0_.manufacturer_id AS manufacturer_id_0,
  o0_.name AS name_1,
  o0_.image AS image_2,
  o0_.sort_order AS sort_order_3,
  o0_.firstname AS firstname_4,
  o0_.lastname AS lastname_5,
  o0_.company AS company_6,
  o0_.email AS email_7,
  o0_.telefone AS telefone_8,
  o0_.address AS address_9,
  o0_.city AS city_10,
  o0_.postcode AS postcode_11,
  o0_.country_id AS country_id_12,
  o0_.mwst AS mwst_13,
  o0_.ust_id AS ust_id_14,
  o0_.auszahlung AS auszahlung_15,
  o0_.period_paid_prev AS period_paid_prev_16,
  o0_.period_paid AS period_paid_17,
  o0_.provision_date AS provision_date_18,
  o0_.provision_amount AS provision_amount_19,
  o0_.username AS username_20,
  o0_.username_canonical AS username_canonical_21,
  o0_.email_canonical AS email_canonical_22,
  o0_.enabled AS enabled_23,
  o0_.salt AS salt_24,
  o0_.password AS password_25,
  o0_.last_login AS last_login_26,
  o0_.locked AS locked_27,
  o0_.expired AS expired_28,
  o0_.expires_at AS expires_at_29,
  o0_.confirmation_token AS confirmation_token_30,
  o0_.password_requested_at AS password_requested_at_31,
  o0_.roles AS roles_32,
  o0_.credentials_expired AS credentials_expired_33,
  o0_.credentials_expire_at AS credentials_expire_at_34,
  o0_.tax_id AS tax_id_35,
  o0_.date_terms_accepted AS date_terms_accepted_36,
  o0_.konto_inhaber AS konto_inhaber_37,
  o0_.konto_iban AS konto_iban_38,
  o0_.konto_bic AS konto_bic_39,
  o0_.paypal_email AS paypal_email_40,
  o0_.next_ebook_number AS next_ebook_number_41,
  o0_.next_stick_number AS next_stick_number_42,
  o0_.next_plott_number AS next_plott_number_43,
  o0_.billing_enabled AS billing_enabled_44,
  o0_.commission_factor AS commission_factor_45,
  o0_.balance AS balance_46,
  o0_.auto_publish_enabled AS auto_publish_enabled_47,
  o0_.date_billing_end AS date_billing_end_48,
  o0_.support_email AS support_email_49,
  o0_.show_in_product_admin AS show_in_product_admin_50
FROM
  oc_manufacturer o0_
WHERE
  o0_.show_in_product_admin = 1
ORDER BY
  o0_.name ASC

SELECT o0_.manufacturer_id AS manufacturer_id_0, o0_.name AS name_1, o0_.image AS image_2, o0_.sort_order AS sort_order_3, o0_.firstname AS firstname_4, o0_.lastname AS lastname_5, o0_.company AS company_6, o0_.email AS email_7, o0_.telefone AS telefone_8, o0_.address AS address_9, o0_.city AS city_10, o0_.postcode AS postcode_11, o0_.country_id AS country_id_12, o0_.mwst AS mwst_13, o0_.ust_id AS ust_id_14, o0_.auszahlung AS auszahlung_15, o0_.period_paid_prev AS period_paid_prev_16, o0_.period_paid AS period_paid_17, o0_.provision_date AS provision_date_18, o0_.provision_amount AS provision_amount_19, o0_.username AS username_20, o0_.username_canonical AS username_canonical_21, o0_.email_canonical AS email_canonical_22, o0_.enabled AS enabled_23, o0_.salt AS salt_24, o0_.password AS password_25, o0_.last_login AS last_login_26, o0_.locked AS locked_27, o0_.expired AS expired_28, o0_.expires_at AS expires_at_29, o0_.confirmation_token AS confirmation_token_30, o0_.password_requested_at AS password_requested_at_31, o0_.roles AS roles_32, o0_.credentials_expired AS credentials_expired_33, o0_.credentials_expire_at AS credentials_expire_at_34, o0_.tax_id AS tax_id_35, o0_.date_terms_accepted AS date_terms_accepted_36, o0_.konto_inhaber AS konto_inhaber_37, o0_.konto_iban AS konto_iban_38, o0_.konto_bic AS konto_bic_39, o0_.paypal_email AS paypal_email_40, o0_.next_ebook_number AS next_ebook_number_41, o0_.next_stick_number AS next_stick_number_42, o0_.next_plott_number AS next_plott_number_43, o0_.billing_enabled AS billing_enabled_44, o0_.commission_factor AS commission_factor_45, o0_.balance AS balance_46, o0_.auto_publish_enabled AS auto_publish_enabled_47, o0_.date_billing_end AS date_billing_end_48, o0_.support_email AS support_email_49, o0_.show_in_product_admin AS show_in_product_admin_50 FROM oc_manufacturer o0_ WHERE o0_.show_in_product_admin = 1 ORDER BY o0_.name ASC;

SELECT
  COUNT(o0_.product_id) AS sclr_0
FROM
  oc_customer_product_notif o0_
WHERE
  o0_.product_id = ?

SELECT COUNT(o0_.product_id) AS sclr_0 FROM oc_customer_product_notif o0_ WHERE o0_.product_id = 9758;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.quantity AS quantity_3,
  t0.ordered AS ordered_4,
  t0.product_id AS product_id_5
FROM
  lv_product_reserved t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.ordered AS ordered_4, t0.product_id AS product_id_5 FROM lv_product_reserved t0 WHERE t0.product_id = 9758;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.display AS display_2,
  l0_.display_app AS display_app_3,
  l0_.reduce_location AS reduce_location_4,
  l0_.no_button_plus AS no_button_plus_5,
  l0_.no_button_minus AS no_button_minus_6,
  l0_.update_init AS update_init_7,
  l0_.to_produktion_transport AS to_produktion_transport_8,
  l0_.sort AS sort_9
FROM
  lager_modify_reason l0_
WHERE
  l0_.display = 1
ORDER BY
  l0_.id ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.display AS display_2, l0_.display_app AS display_app_3, l0_.reduce_location AS reduce_location_4, l0_.no_button_plus AS no_button_plus_5, l0_.no_button_minus AS no_button_minus_6, l0_.update_init AS update_init_7, l0_.to_produktion_transport AS to_produktion_transport_8, l0_.sort AS sort_9 FROM lager_modify_reason l0_ WHERE l0_.display = 1 ORDER BY l0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.company AS company_5,
  t0.email AS email_6,
  t0.telefone AS telefone_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.postcode AS postcode_10,
  t0.country_id AS country_id_11,
  t0.mwst AS mwst_12,
  t0.ust_id AS ust_id_13,
  t0.auszahlung AS auszahlung_14,
  t0.provision_date AS provision_date_15,
  t0.provision_amount AS provision_amount_16,
  t0.enabled AS enabled_17,
  t0.konto_inhaber AS konto_inhaber_18,
  t0.konto_iban AS konto_iban_19,
  t0.konto_bic AS konto_bic_20,
  t0.paypal_email AS paypal_email_21
FROM
  oc_designer t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.company AS company_5, t0.email AS email_6, t0.telefone AS telefone_7, t0.address AS address_8, t0.city AS city_9, t0.postcode AS postcode_10, t0.country_id AS country_id_11, t0.mwst AS mwst_12, t0.ust_id AS ust_id_13, t0.auszahlung AS auszahlung_14, t0.provision_date AS provision_date_15, t0.provision_amount AS provision_amount_16, t0.enabled AS enabled_17, t0.konto_inhaber AS konto_inhaber_18, t0.konto_iban AS konto_iban_19, t0.konto_bic AS konto_bic_20, t0.paypal_email AS paypal_email_21 FROM oc_designer t0;

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 = 'admin' LIMIT 1;

SELECT
  o0_.stock_status_id AS stock_status_id_0,
  o0_.language_id AS language_id_1,
  o0_.sort_order AS sort_order_2,
  o0_.name AS name_3,
  o0_.show_in_active AS show_in_active_4
FROM
  oc_stock_status o0_
WHERE
  o0_.language_id = ?

SELECT o0_.stock_status_id AS stock_status_id_0, o0_.language_id AS language_id_1, o0_.sort_order AS sort_order_2, o0_.name AS name_3, o0_.show_in_active AS show_in_active_4 FROM oc_stock_status o0_ WHERE o0_.language_id = 2;