Symfony Profiler

Query Metrics

58 Database Queries

33 Different statements

28.84 ms Query time

1 Invalid entities

Queries


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.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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 FROM oc_product t0 WHERE 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 = ? 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 = ? AND t0.product_id = ?)
SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.query = ? 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.product_option_id AS product_option_id_1, t0.product_id AS product_id_2, t0.option_id AS option_id_3, t0.required AS required_4, t0.product_max_char AS product_max_char_5, t0.display_name AS display_name_6, t0.svg_name AS svg_name_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.option_id AS option_id_10 FROM oc_product_option t0 WHERE t0.product_id = ?
SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ?
SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ?
SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ?
SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ?
SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ?
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_.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_.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.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 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM oc_product_template t0 WHERE t0.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 = ?
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.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.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
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.tax_class_id AS tax_class_id_1, t0.title AS title_2, t0.description AS description_3, t0.sw_tax AS sw_tax_4, t0.date_added AS date_added_5, t0.date_modified AS date_modified_6 FROM oc_tax_class t0 WHERE t0.tax_class_id = ?
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand t0 WHERE t0.product_id = ?
SELECT o0_.id AS id_0, o0_.name AS name_1 FROM oc_product_template o0_ WHERE o0_.id IN (?)
SELECT o0_.id AS id_0, o0_.language_id AS language_id_1, o0_.name AS name_2, o0_.sw_unit AS sw_unit_3 FROM oc_product_unit o0_ WHERE o0_.id IN (?)
SELECT o0_.tax_class_id AS tax_class_id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.sw_tax AS sw_tax_3, o0_.date_added AS date_added_4, o0_.date_modified AS date_modified_5 FROM oc_tax_class o0_ WHERE o0_.tax_class_id IN (?)
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.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.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.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand 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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 FROM oc_product t0 WHERE t0.model = ? LIMIT 2
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 = ? AND t0.product_id = ?)
SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.keyword = ?
SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1
SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1
SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1
"START TRANSACTION"
UPDATE oc_product SET input_price = ?, date_available = ?, weight = ?, width = ?, date_added = ? WHERE product_id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.model AS model_3, t0.printer_file AS printer_file_4, t0.printer_file_2 AS printer_file_2_5, t0.printer_file_3 AS printer_file_3_6, t0.printer_file_4 AS printer_file_4_7, t0.placeholder_name AS placeholder_name_8, t0.placeholder_name_2 AS placeholder_name_2_9, t0.konfi_file AS konfi_file_10, t0.font_file AS font_file_11, t0.product_id AS product_id_12 FROM oc_product_poster_printer 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 = ?
"START TRANSACTION"
DELETE FROM oc_product_to_store WHERE id = ?
"COMMIT"
"START TRANSACTION"
INSERT INTO oc_product_to_store (product_id, store_id) VALUES (?, ?)
"COMMIT"
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 = ? 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 = ? 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 = ? AND t0.product_id = ?)

#▲	Time	Info
1	0.38 ms	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 = ? Parameters: [`353`] View formatted query View runnable query Explain query 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;
2	0.70 ms	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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 FROM oc_product t0 WHERE t0.product_id = ? Parameters: [`"76769"`] View formatted query View runnable query Explain query 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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 FROM oc_product t0 WHERE t0.product_id = '76769';
3	0.47 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
4	0.35 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
5	0.32 ms	SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.query = ? LIMIT 1 Parameters: [`"product_id=76769"`] View formatted query View runnable query Explain query SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.query = ? LIMIT 1 SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.query = 'product_id=76769' LIMIT 1;
6	0.30 ms	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 Parameters: [`11`] View formatted query View runnable query Explain query 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;
7	0.29 ms	SELECT t0.product_option_id AS product_option_id_1, t0.product_id AS product_id_2, t0.option_id AS option_id_3, t0.required AS required_4, t0.product_max_char AS product_max_char_5, t0.display_name AS display_name_6, t0.svg_name AS svg_name_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.option_id AS option_id_10 FROM oc_product_option t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.product_option_id AS product_option_id_1, t0.product_id AS product_id_2, t0.option_id AS option_id_3, t0.required AS required_4, t0.product_max_char AS product_max_char_5, t0.display_name AS display_name_6, t0.svg_name AS svg_name_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.option_id AS option_id_10 FROM oc_product_option t0 WHERE t0.product_id = ? SELECT t0.product_option_id AS product_option_id_1, t0.product_id AS product_id_2, t0.option_id AS option_id_3, t0.required AS required_4, t0.product_max_char AS product_max_char_5, t0.display_name AS display_name_6, t0.svg_name AS svg_name_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.option_id AS option_id_10 FROM oc_product_option t0 WHERE t0.product_id = 76769;
8	0.39 ms	SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? Parameters: [`6738`] View formatted query View runnable query Explain query SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = 6738;
9	0.35 ms	SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? Parameters: [`6739`] View formatted query View runnable query Explain query SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = 6739;
10	0.33 ms	SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? Parameters: [`6740`] View formatted query View runnable query Explain query SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = 6740;
11	0.31 ms	SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? Parameters: [`6741`] View formatted query View runnable query Explain query SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = 6741;
12	0.40 ms	SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? Parameters: [`6742`] View formatted query View runnable query Explain query SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = ? SELECT t0.product_option_value_id AS product_option_value_id_1, t0.product_option_id AS product_option_id_2, t0.product_id AS product_id_3, t0.option_id AS option_id_4, t0.option_value_id AS option_value_id_5, t0.quantity AS quantity_6, t0.subtract AS subtract_7, t0.price AS price_8, t0.price_prefix AS price_prefix_9, t0.points AS points_10, t0.points_prefix AS points_prefix_11, t0.weight AS weight_12, t0.weight_prefix AS weight_prefix_13, t0.is_default AS is_default_14, t0.pos_x AS pos_x_15, t0.pos_y AS pos_y_16, t0.print_on_demand_id AS print_on_demand_id_17, t0.display_name AS display_name_18, t0.product_id AS product_id_19, t0.option_id AS option_id_20, t0.product_option_id AS product_option_id_21, t0.option_value_id AS option_value_id_22, t0.print_on_demand_id AS print_on_demand_id_23 FROM oc_product_option_value t0 WHERE t0.product_option_id = 6742;
13	0.54 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
14	0.39 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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;
15	0.47 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
16	0.38 ms	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 WHERE t0.category_id = ? Parameters: [`11`] View formatted query View runnable query Explain query 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 WHERE t0.category_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 WHERE t0.category_id = 11;
17	0.68 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM oc_product_template t0 WHERE t0.id = ? Parameters: [`13`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM oc_product_template t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM oc_product_template t0 WHERE t0.id = 13;
18	0.39 ms	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 = ? Parameters: [`76769`] View formatted query View runnable query Explain query 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 = 76769;
19	0.31 ms	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 = ? Parameters: [`76769`] View formatted query View runnable query Explain query 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 = 76769;
20	0.33 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
21	0.78 ms	SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = 76769 ORDER BY t0.sort_order ASC;
22	0.35 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
23	0.32 ms	SELECT t0.tax_class_id AS tax_class_id_1, t0.title AS title_2, t0.description AS description_3, t0.sw_tax AS sw_tax_4, t0.date_added AS date_added_5, t0.date_modified AS date_modified_6 FROM oc_tax_class t0 WHERE t0.tax_class_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.tax_class_id AS tax_class_id_1, t0.title AS title_2, t0.description AS description_3, t0.sw_tax AS sw_tax_4, t0.date_added AS date_added_5, t0.date_modified AS date_modified_6 FROM oc_tax_class t0 WHERE t0.tax_class_id = ? SELECT t0.tax_class_id AS tax_class_id_1, t0.title AS title_2, t0.description AS description_3, t0.sw_tax AS sw_tax_4, t0.date_added AS date_added_5, t0.date_modified AS date_modified_6 FROM oc_tax_class t0 WHERE t0.tax_class_id = 11;
24	0.41 ms	SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = 76769;
25	0.29 ms	SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = 76769;
26	0.30 ms	SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand t0 WHERE t0.product_id = 76769;
27	0.57 ms	SELECT o0_.id AS id_0, o0_.name AS name_1 FROM oc_product_template o0_ WHERE o0_.id IN (?) Parameters: [`"13"`] View formatted query View runnable query Explain query SELECT o0_.id AS id_0, o0_.name AS name_1 FROM oc_product_template o0_ WHERE o0_.id IN (?) SELECT o0_.id AS id_0, o0_.name AS name_1 FROM oc_product_template o0_ WHERE o0_.id IN ('13');
28	0.37 ms	SELECT o0_.id AS id_0, o0_.language_id AS language_id_1, o0_.name AS name_2, o0_.sw_unit AS sw_unit_3 FROM oc_product_unit o0_ WHERE o0_.id IN (?) Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT o0_.id AS id_0, o0_.language_id AS language_id_1, o0_.name AS name_2, o0_.sw_unit AS sw_unit_3 FROM oc_product_unit o0_ WHERE o0_.id IN (?) SELECT o0_.id AS id_0, o0_.language_id AS language_id_1, o0_.name AS name_2, o0_.sw_unit AS sw_unit_3 FROM oc_product_unit o0_ WHERE o0_.id IN ('1');
29	0.40 ms	SELECT o0_.tax_class_id AS tax_class_id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.sw_tax AS sw_tax_3, o0_.date_added AS date_added_4, o0_.date_modified AS date_modified_5 FROM oc_tax_class o0_ WHERE o0_.tax_class_id IN (?) Parameters: [`"11"`] View formatted query View runnable query Explain query SELECT o0_.tax_class_id AS tax_class_id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.sw_tax AS sw_tax_3, o0_.date_added AS date_added_4, o0_.date_modified AS date_modified_5 FROM oc_tax_class o0_ WHERE o0_.tax_class_id IN (?) SELECT o0_.tax_class_id AS tax_class_id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.sw_tax AS sw_tax_3, o0_.date_added AS date_added_4, o0_.date_modified AS date_modified_5 FROM oc_tax_class o0_ WHERE o0_.tax_class_id IN ('11');
30	0.54 ms	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 = ? Parameters: [`76769`] View formatted query View runnable query Explain query 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 = 76769;
31	0.38 ms	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 = ? Parameters: [`76769`] View formatted query View runnable query Explain query 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 = 76769;
32	0.38 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
33	0.31 ms	SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_id = 76769 ORDER BY t0.sort_order ASC;
34	0.31 ms	SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.url AS url_4, t0.product_id AS product_id_5 FROM oc_product_document t0 WHERE t0.product_id = 76769;
35	0.31 ms	SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.product_id AS product_id_4 FROM oc_product_video t0 WHERE t0.product_id = 76769;
36	0.31 ms	SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.file AS file_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM oc_product_print_on_demand t0 WHERE t0.product_id = 76769;
37	1.32 ms	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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 FROM oc_product t0 WHERE t0.model = ? LIMIT 2 Parameters: [`"ScTuFabr018"`] View formatted query View runnable query Explain query 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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 FROM oc_product t0 WHERE t0.model = ? LIMIT 2 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.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.tiktok_id AS tiktok_id_41, t0.is_wc_main AS is_wc_main_42, t0.has_options AS has_options_43, t0.is_box_main_product AS is_box_main_product_44, t0.box_quantity AS box_quantity_45, t0.mix_and_match AS mix_and_match_46, t0.manufacturer_id AS manufacturer_id_47, t0.designer_id AS designer_id_48, t0.template_id AS template_id_49, t0.stock_status_id AS stock_status_id_50, t0.unit_id AS unit_id_51, t0.tax_class_id AS tax_class_id_52, t0.box_main_product AS box_main_product_53 FROM oc_product t0 WHERE t0.model = 'ScTuFabr018' LIMIT 2;
38	0.46 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
39	0.76 ms	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 = ?) Parameters: [`3 76769`] View formatted query View runnable query Explain query 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 = 3 AND t0.product_id = 76769);
40	0.43 ms	SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.keyword = ? Parameters: [`"DIY-Naehset-Schultuete-Tintenfisch-Kathi-Bondzio-zum-selber-Naehen"`] View formatted query View runnable query Explain query SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.keyword = ? SELECT t0.url_alias_id AS url_alias_id_1, t0.query AS query_2, t0.keyword AS keyword_3 FROM oc_url_alias t0 WHERE t0.keyword = 'DIY-Naehset-Schultuete-Tintenfisch-Kathi-Bondzio-zum-selber-Naehen';
41	0.41 ms	SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1 Parameters: [`317410`] View formatted query View runnable query Explain query SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1 SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = 317410 LIMIT 1;
42	0.42 ms	SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1 Parameters: [`317411`] View formatted query View runnable query Explain query SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1 SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = 317411 LIMIT 1;
43	0.44 ms	SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1 Parameters: [`317412`] View formatted query View runnable query Explain query SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = ? LIMIT 1 SELECT t0.product_image_id AS product_image_id_1, t0.product_id AS product_id_2, t0.image AS image_3, t0.sort_order AS sort_order_4, t0.name AS name_5, t0.product_id AS product_id_6 FROM oc_product_image t0 WHERE t0.product_image_id = 317412 LIMIT 1;
44	0.43 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
45	0.52 ms	UPDATE oc_product SET input_price = ?, date_available = ?, weight = ?, width = ?, date_added = ? WHERE product_id = ? Parameters: [`"0" "2025-06-19 22:00:00" "0" "0" "2025-06-19 22:00:00" 76769`] View formatted query View runnable query Explain query UPDATE oc_product SET input_price = ?, date_available = ?, weight = ?, width = ?, date_added = ? WHERE product_id = ? UPDATE oc_product SET input_price = '0', date_available = '2025-06-19 22:00:00', weight = '0', width = '0', date_added = '2025-06-19 22:00:00' WHERE product_id = 76769;
46	0.31 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
47	0.32 ms	SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.model AS model_3, t0.printer_file AS printer_file_4, t0.printer_file_2 AS printer_file_2_5, t0.printer_file_3 AS printer_file_3_6, t0.printer_file_4 AS printer_file_4_7, t0.placeholder_name AS placeholder_name_8, t0.placeholder_name_2 AS placeholder_name_2_9, t0.konfi_file AS konfi_file_10, t0.font_file AS font_file_11, t0.product_id AS product_id_12 FROM oc_product_poster_printer t0 WHERE t0.product_id = ? Parameters: [`76769`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.model AS model_3, t0.printer_file AS printer_file_4, t0.printer_file_2 AS printer_file_2_5, t0.printer_file_3 AS printer_file_3_6, t0.printer_file_4 AS printer_file_4_7, t0.placeholder_name AS placeholder_name_8, t0.placeholder_name_2 AS placeholder_name_2_9, t0.konfi_file AS konfi_file_10, t0.font_file AS font_file_11, t0.product_id AS product_id_12 FROM oc_product_poster_printer t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.model AS model_3, t0.printer_file AS printer_file_4, t0.printer_file_2 AS printer_file_2_5, t0.printer_file_3 AS printer_file_3_6, t0.printer_file_4 AS printer_file_4_7, t0.placeholder_name AS placeholder_name_8, t0.placeholder_name_2 AS placeholder_name_2_9, t0.konfi_file AS konfi_file_10, t0.font_file AS font_file_11, t0.product_id AS product_id_12 FROM oc_product_poster_printer t0 WHERE t0.product_id = 76769;
48	0.32 ms	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 = ? Parameters: [`76769`] View formatted query View runnable query Explain query 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 = 76769;
49	0.47 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
50	0.56 ms	DELETE FROM oc_product_to_store WHERE id = ? Parameters: [`68327`] View formatted query View runnable query Explain query DELETE FROM oc_product_to_store WHERE id = ? DELETE FROM oc_product_to_store WHERE id = 68327;
51	1.35 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
52	0.42 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
53	0.46 ms	INSERT INTO oc_product_to_store (product_id, store_id) VALUES (?, ?) Parameters: [`76769 0`] View formatted query View runnable query Explain query INSERT INTO oc_product_to_store (product_id, store_id) VALUES (?, ?) INSERT INTO oc_product_to_store (product_id, store_id) VALUES (76769, 0);
54	1.57 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
55	0.96 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
56	0.94 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
57	0.99 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);
58	0.54 ms	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 = ?) Parameters: [`2 76769`] View formatted query View runnable query Explain query 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 = 76769);

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\LvAppUser	No errors.
App\Entity\BbUser	The join columns of the association 'user' have to match to ALL identifier columns of the target entity 'App\Entity\User', however 'id' are missing.
App\Entity\SfGuardGroup	No errors.
App\Entity\SfGuardPermission	No errors.
App\Entity\OcProduct	No errors.
App\Entity\OcManufacturer	No errors.
App\Entity\OcDesigner	No errors.
App\Entity\OcProductTemplate	No errors.
App\Entity\OcStockStatus	No errors.
App\Entity\OcProductUnit	No errors.
App\Entity\OcTaxClass	No errors.
App\Entity\OcProductDescription	No errors.
App\Entity\OcProductImage	No errors.
App\Entity\OcCategory	No errors.
App\Entity\OcProductToCategory	No errors.
App\Entity\OcFeature	No errors.
App\Entity\OcProductFeature	No errors.
App\Entity\OcProductOption	No errors.
App\Entity\OcProductOptionValue	No errors.
App\Entity\OcProductAttribute	No errors.
App\Entity\OcProductBoxContent	No errors.
App\Entity\LvLagerort	No errors.
App\Entity\LvLagerortToProduct	No errors.
App\Entity\OcProductSublimationPrinter	No errors.
App\Entity\OcProductPosterPrinter	No errors.
App\Entity\LagerProductUser	No errors.
App\Entity\OcProductToStore	No errors.
App\Entity\OcProductDocument	No errors.
App\Entity\OcProductPrintOnDemand	No errors.
App\Entity\OcProductVideo	No errors.
App\Entity\LvProductReserved	No errors.
App\Entity\OcUrlAlias	No errors.
App\Entity\LagerTax	No errors.
App\Entity\OcOption	No errors.
App\Entity\OcOptionValue	No errors.
App\Entity\OcCategoryDescription	No errors.
App\Entity\OcProductField	No errors.

Symfony Profiler

POST https://new.alles-fuer-selbermacher.de/product/edit/76769?page=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping