Symfony Profiler

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.product_id AS product_id_2,
  t0.store_id AS store_id_3,
  t0.product_id AS product_id_4
FROM
  oc_product_to_store t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.store_id AS store_id_3, t0.product_id AS product_id_4 FROM oc_product_to_store t0 WHERE t0.product_id = 9758;

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.description AS description_4
FROM
  oc_feature t0
  INNER JOIN oc_product_feature ON t0.id = oc_product_feature.feature_id
WHERE
  oc_product_feature.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM oc_feature t0 INNER JOIN oc_product_feature ON t0.id = oc_product_feature.feature_id WHERE oc_product_feature.product_id = 9758;

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
  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 = ?
  AND l0_.modify_reason_id = 23
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 AND l0_.modify_reason_id = 23 ORDER BY l0_.date_modified DESC 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 = ?
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
  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_.seller_article_nr AS seller_article_nr_33,
  o0_.startpage_hide AS startpage_hide_34,
  o0_.sw_id AS sw_id_35,
  o0_.sw_custom_template AS sw_custom_template_36,
  o0_.selected_yarns_id AS selected_yarns_id_37,
  o0_.billbee_id AS billbee_id_38,
  o0_.beton_id AS beton_id_39,
  o0_.tiktok_id AS tiktok_id_40,
  o0_.is_wc_main AS is_wc_main_41,
  o0_.has_options AS has_options_42,
  o0_.is_box_main_product AS is_box_main_product_43,
  o0_.box_quantity AS box_quantity_44,
  o0_.mix_and_match AS mix_and_match_45,
  o0_.manufacturer_id AS manufacturer_id_46,
  o0_.designer_id AS designer_id_47,
  o0_.template_id AS template_id_48,
  o0_.stock_status_id AS stock_status_id_49,
  o0_.unit_id AS unit_id_50,
  o0_.tax_class_id AS tax_class_id_51,
  o0_.box_main_product AS box_main_product_52
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_.seller_article_nr AS seller_article_nr_33, o0_.startpage_hide AS startpage_hide_34, o0_.sw_id AS sw_id_35, o0_.sw_custom_template AS sw_custom_template_36, o0_.selected_yarns_id AS selected_yarns_id_37, o0_.billbee_id AS billbee_id_38, o0_.beton_id AS beton_id_39, o0_.tiktok_id AS tiktok_id_40, o0_.is_wc_main AS is_wc_main_41, o0_.has_options AS has_options_42, o0_.is_box_main_product AS is_box_main_product_43, o0_.box_quantity AS box_quantity_44, o0_.mix_and_match AS mix_and_match_45, o0_.manufacturer_id AS manufacturer_id_46, o0_.designer_id AS designer_id_47, o0_.template_id AS template_id_48, o0_.stock_status_id AS stock_status_id_49, o0_.unit_id AS unit_id_50, o0_.tax_class_id AS tax_class_id_51, o0_.box_main_product AS box_main_product_52 FROM oc_product o0_ WHERE o0_.tax_class_id <> 13 AND o0_.product_id IN (9758, 76761, 76769, 76768, 76767, 76766, 76764, 76762, 76760, 76758, 76757, 76752, 76751, 76750, 76749, 76745, 76744, 76741, 76740, 76737, 76735, 76734, 76733, 76732, 76730) ORDER BY o0_.date_added DESC;

SELECT
  DISTINCT o0_.product_id AS product_id_0,
  o0_.date_added AS date_added_1
FROM
  oc_product o0_
WHERE
  o0_.tax_class_id <> 13
ORDER BY
  o0_.date_added DESC
LIMIT
  25

SELECT DISTINCT o0_.product_id AS product_id_0, o0_.date_added AS date_added_1 FROM oc_product o0_ WHERE o0_.tax_class_id <> 13 ORDER BY o0_.date_added DESC LIMIT 25;

SELECT
  t0.id AS id_1,
  t0.language_id AS language_id_2,
  t0.name AS name_3,
  t0.sw_unit AS sw_unit_4
FROM
  oc_product_unit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.language_id AS language_id_2, t0.name AS name_3, t0.sw_unit AS sw_unit_4 FROM oc_product_unit t0 WHERE t0.id = 1;

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
  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 AND o0_.is_digital = 0 AND o1_.language_id = 2 ORDER BY o1_.name ASC;

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

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