GET https://upgrade.mountainbike-parts.ch/_fragment?_path=_format%3Dhtml%26_locale%3Dde%26_controller%3DApp%255CController%255CUser%255CDefaultController%253A%253Ah…

Response
200 OK
IP
103.90.45.161
Profiled on
Token
94c98e

Query Metrics

78 Database Queries
34 Different statements
11.94 ms Query time
1 Invalid entities
382 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.15 ms 
SELECT t0.id AS id_1, t0.ip AS ip_2 FROM customer_ban_ip t0 WHERE t0.ip = ?
Parameters: 
[
  "103.90.45.161"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.11 ms 
SELECT s0_.current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.41 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.ecp AS ecp_3, t0.is_bulky AS is_bulky_4, t0.new_name AS new_name_5, t0.icp_name AS icp_name_6, t0.code AS code_7, t0.mpn_code AS mpn_code_8, t0.ean_code AS ean_code_9, t0.iean_code AS iean_code_10, t0.sean_code AS sean_code_11, t0.is_iean_print AS is_iean_print_12, t0.is_cean_print AS is_cean_print_13, t0.is_sean_print AS is_sean_print_14, t0.sean AS sean_15, t0.org_supplier_id AS org_supplier_id_16, t0.is_retail_hold AS is_retail_hold_17, t0.description AS description_18, t0.type AS type_19, t0.tags AS tags_20, t0.product_custom_label AS product_custom_label_21, t0.product_label_active_days AS product_label_active_days_22, t0.required_configuration AS required_configuration_23, t0.price AS price_24, t0.price_gross AS price_gross_25, t0.msrp AS msrp_26, t0.distri_price AS distri_price_27, t0.stock_item_value AS stock_item_value_28, t0.stock_place AS stock_place_29, t0.product_type AS product_type_30, t0.quantity AS quantity_31, t0.minimum_stock AS minimum_stock_32, t0.minimum_stock_status AS minimum_stock_status_33, t0.mins_last_status AS mins_last_status_34, t0.is_force_mins AS is_force_mins_35, t0.is_ds AS is_ds_36, t0.is_force_ds AS is_force_ds_37, t0.int_stockyard AS int_stockyard_38, t0.vct_stock_quantity AS vct_stock_quantity_39, t0.vct_stock_status AS vct_stock_status_40, t0.expected_delivery_date AS expected_delivery_date_41, t0.seller_item_id AS seller_item_id_42, t0.other_seller_item_id AS other_seller_item_id_43, t0.other_supplier_id AS other_supplier_id_44, t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45, t0.cost_price AS cost_price_46, t0.abroad_base_price AS abroad_base_price_47, t0.base_price AS base_price_48, t0.item_discount AS item_discount_49, t0.purchase_price AS purchase_price_50, t0.supplier_tax_category AS supplier_tax_category_51, t0.publish_date AS publish_date_52, t0.expire_date AS expire_date_53, t0.require_shipping AS require_shipping_54, t0.returnable AS returnable_55, t0.stock_shelf AS stock_shelf_56, t0.shelf_place AS shelf_place_57, t0.package_width AS package_width_58, t0.package_height AS package_height_59, t0.package_depth AS package_depth_60, t0.package_weight AS package_weight_61, t0.related_product AS related_product_62, t0.spare_parts AS spare_parts_63, t0.components AS components_64, t0.up_selling_product AS up_selling_product_65, t0.cross_selling_product AS cross_selling_product_66, t0.attachment AS attachment_67, t0.seo_title AS seo_title_68, t0.seo_description AS seo_description_69, t0.seo_keyword AS seo_keyword_70, t0.seo_url AS seo_url_71, t0.old_seo_url AS old_seo_url_72, t0.show_extra_fields AS show_extra_fields_73, t0.status AS status_74, t0.manual_status AS manual_status_75, t0.is_manual_status AS is_manual_status_76, t0.import AS import_77, t0.display_stock_report AS display_stock_report_78, t0.display_front_status_change AS display_front_status_change_79, t0.deleted AS deleted_80, t0.incomplete_product AS incomplete_product_81, t0.assign_incomplete_product AS assign_incomplete_product_82, t0.incomplete_to_assign_product AS incomplete_to_assign_product_83, t0.incomplete_assign_product_id AS incomplete_assign_product_id_84, t0.sort_order AS sort_order_85, t0.profit AS profit_86, t0.margin AS margin_87, t0.b2b_profit AS b2b_profit_88, t0.b2b_margin AS b2b_margin_89, t0.catalogue_status AS catalogue_status_90, t0.is_unite AS is_unite_91, t0.supplier_cart_id AS supplier_cart_id_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.tax_id AS tax_id_95, t0.stock_indicators_id AS stock_indicators_id_96, t0.return_rule_id AS return_rule_id_97, t0.category_id AS category_id_98, t0.supplier_id AS supplier_id_99, t0.manufacturer_id AS manufacturer_id_100, t0.courier_id AS courier_id_101, t0.sub_shipping_method_id AS sub_shipping_method_id_102, t0.currency_id AS currency_id_103, t0.product_label_id AS product_label_id_104 FROM product t0 WHERE t0.id = ?
Parameters: 
[
  11660
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_b2b_distri AS is_b2b_distri_4, t0.is_b2b_resell AS is_b2b_resell_5, t0.is_b2c_retail AS is_b2c_retail_6, t0.b2b_distri_disagio AS b2b_distri_disagio_7, t0.free_b2c_shipping AS free_b2c_shipping_8, t0.subtitle AS subtitle_9, t0.banner_image AS banner_image_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keyword AS seo_keyword_13, t0.seo_url AS seo_url_14, t0.image AS image_15, t0.sort_order AS sort_order_16, t0.status AS status_17, t0.display_front AS display_front_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21 FROM manufacturer t0 WHERE t0.id = ?
Parameters: 
[
  385
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.24 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.characteristic_type AS characteristic_type_3, t0.alias AS alias_4, t0.code AS code_5, t0.mpn_code AS mpn_code_6, t0.ean_code AS ean_code_7, t0.iean_code AS iean_code_8, t0.sean_code AS sean_code_9, t0.is_iean_print AS is_iean_print_10, t0.is_cean_print AS is_cean_print_11, t0.is_sean_print AS is_sean_print_12, t0.sean AS sean_13, t0.org_supplier_id AS org_supplier_id_14, t0.price AS price_15, t0.price_gross AS price_gross_16, t0.msrp AS msrp_17, t0.distri_price AS distri_price_18, t0.stock_item_value AS stock_item_value_19, t0.prefix AS prefix_20, t0.stock_place AS stock_place_21, t0.product_type AS product_type_22, t0.quantity AS quantity_23, t0.minimum_stock AS minimum_stock_24, t0.minimum_stock_status AS minimum_stock_status_25, t0.mins_last_status AS mins_last_status_26, t0.is_force_mins AS is_force_mins_27, t0.is_ds AS is_ds_28, t0.is_force_ds AS is_force_ds_29, t0.int_stockyard AS int_stockyard_30, t0.vct_stock_quantity AS vct_stock_quantity_31, t0.vct_stock_status AS vct_stock_status_32, t0.expected_delivery_date AS expected_delivery_date_33, t0.seller_item_id AS seller_item_id_34, t0.other_seller_item_id AS other_seller_item_id_35, t0.other_supplier_id AS other_supplier_id_36, t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37, t0.cost_price AS cost_price_38, t0.abroad_base_price AS abroad_base_price_39, t0.base_price AS base_price_40, t0.item_discount AS item_discount_41, t0.purchase_price AS purchase_price_42, t0.returnable AS returnable_43, t0.supplier_tax_category AS supplier_tax_category_44, t0.stock_shelf AS stock_shelf_45, t0.shelf_place AS shelf_place_46, t0.extra_charge AS extra_charge_47, t0.session_id AS session_id_48, t0.ip AS ip_49, t0.sort_order AS sort_order_50, t0.profit AS profit_51, t0.margin AS margin_52, t0.b2b_profit AS b2b_profit_53, t0.b2b_margin AS b2b_margin_54, t0.deleted AS deleted_55, t0.status AS status_56, t0.manual_status AS manual_status_57, t0.is_manual_status AS is_manual_status_58, t0.display_stock_report AS display_stock_report_59, t0.publish_date AS publish_date_60, t0.expire_date AS expire_date_61, t0.is_unite AS is_unite_62, t0.supplier_cart_id AS supplier_cart_id_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.product_id AS product_id_66, t0.child_product_id AS child_product_id_67, t0.child_product_attribute_id AS child_product_attribute_id_68, t0.stock_indicators_id AS stock_indicators_id_69, t0.category_product_characteristic_id AS category_product_characteristic_id_70, t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_71, t0.supplier_id AS supplier_id_72, t0.return_rule_id AS return_rule_id_73 FROM product_attribute t0 WHERE t0.id = ?
Parameters: 
[
  1081161
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.16 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.price_mode AS price_mode_4, t0.discount_rate AS discount_rate_5, t0.price AS price_6, t0.net_price AS net_price_7, t0.start_date AS start_date_8, t0.expire_date AS expire_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.product_id AS product_id_13, t0.currency_id AS currency_id_14, t0.product_attribute_id AS product_attribute_id_15, t0.tax_id AS tax_id_16 FROM special_price t0 WHERE t0.product_id = ? AND t0.product_attribute_id = ? AND t0.status = ? ORDER BY t0.id DESC LIMIT 1
Parameters: 
[
  11660
  1081161
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.19 ms 
SELECT p0_.id AS id_0 FROM product_attribute p0_ WHERE p0_.product_id = ? AND p0_.deleted = 0 AND p0_.status = 1 AND p0_.characteristic_type = ? ORDER BY p0_.sort_order ASC
Parameters: 
[
  11660
  "product_option"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.18 ms 
SELECT t0.id AS id_1, t0.product_option AS product_option_2, t0.filter_navigation AS filter_navigation_3, t0.tech_specification AS tech_specification_4, t0.display_front AS display_front_5, t0.ecp AS ecp_6, t0.product_option_sort_order AS product_option_sort_order_7, t0.tech_specification_sort_order AS tech_specification_sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.product_id AS product_id_11, t0.category_product_characteristic_id AS category_product_characteristic_id_12 FROM product_attribute_options t0 WHERE t0.product_id = ? AND t0.product_option = ? ORDER BY t0.product_option_sort_order ASC
Parameters: 
[
  11660
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.29 ms 
SELECT c0_.id AS id_0, c0_.product_id AS product_id_1, c0_.product_attribute_id AS product_attribute_id_2, c0_.category_product_characteristic_id AS category_product_characteristic_id_3, c0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_.product_attribute_id IN (918893, 918894, 1081161, 1157756, 1157757, 1157758, 918895, 918896, 1081192, 1153261, 1153286, 1153311, 1157752, 997938, 997939, 997906, 997907, 1158315, 1158316, 1158317, 1157759, 1157760, 1157761) AND c0_.category_product_characteristic_id IN (18, 19, 16, 17)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.20 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.product_option AS product_option_3, t0.filter_navigation AS filter_navigation_4, t0.tech_specification AS tech_specification_5, t0.status AS status_6, t0.sort_order AS sort_order_7, t0.product_option_sort_order AS product_option_sort_order_8, t0.filter_navigation_sort_order AS filter_navigation_sort_order_9, t0.tech_specification_sort_order AS tech_specification_sort_order_10, t0.product_specific_option AS product_specific_option_11, t0.product_specific_tech_spec AS product_specific_tech_spec_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.category_id AS category_id_15, t0.product_characteristic_id AS product_characteristic_id_16, t0.product_id AS product_id_17, t0.configure_product_id AS configure_product_id_18 FROM category_product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.13 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.13 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  108
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.12 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  56
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.13 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.product_option AS product_option_3, t0.filter_navigation AS filter_navigation_4, t0.tech_specification AS tech_specification_5, t0.status AS status_6, t0.sort_order AS sort_order_7, t0.product_option_sort_order AS product_option_sort_order_8, t0.filter_navigation_sort_order AS filter_navigation_sort_order_9, t0.tech_specification_sort_order AS tech_specification_sort_order_10, t0.product_specific_option AS product_specific_option_11, t0.product_specific_tech_spec AS product_specific_tech_spec_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.category_id AS category_id_15, t0.product_characteristic_id AS product_characteristic_id_16, t0.product_id AS product_id_17, t0.configure_product_id AS configure_product_id_18 FROM category_product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.12 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  119
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.08 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  143
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.09 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.product_option AS product_option_3, t0.filter_navigation AS filter_navigation_4, t0.tech_specification AS tech_specification_5, t0.status AS status_6, t0.sort_order AS sort_order_7, t0.product_option_sort_order AS product_option_sort_order_8, t0.filter_navigation_sort_order AS filter_navigation_sort_order_9, t0.tech_specification_sort_order AS tech_specification_sort_order_10, t0.product_specific_option AS product_specific_option_11, t0.product_specific_tech_spec AS product_specific_tech_spec_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.category_id AS category_id_15, t0.product_characteristic_id AS product_characteristic_id_16, t0.product_id AS product_id_17, t0.configure_product_id AS configure_product_id_18 FROM category_product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.07 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.07 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  28069
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.07 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  14923
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.08 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.product_option AS product_option_3, t0.filter_navigation AS filter_navigation_4, t0.tech_specification AS tech_specification_5, t0.status AS status_6, t0.sort_order AS sort_order_7, t0.product_option_sort_order AS product_option_sort_order_8, t0.filter_navigation_sort_order AS filter_navigation_sort_order_9, t0.tech_specification_sort_order AS tech_specification_sort_order_10, t0.product_specific_option AS product_specific_option_11, t0.product_specific_tech_spec AS product_specific_tech_spec_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.category_id AS category_id_15, t0.product_characteristic_id AS product_characteristic_id_16, t0.product_id AS product_id_17, t0.configure_product_id AS configure_product_id_18 FROM category_product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.06 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM product_characteristic t0 WHERE t0.id = ?
Parameters: 
[
  35
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.07 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  99
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.07 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  16046
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.09 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  104
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  16051
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.07 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  31925
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.07 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  17315
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.08 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  31874
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  17434
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.06 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  31875
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  18451
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.08 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  9656
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  16061
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.07 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  115
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  110
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.07 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  33490
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  18363
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.06 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  117
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  112
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.06 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  33413
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.07 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  3690
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.07 ms 
SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  33931
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.06 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?
Parameters: 
[
  6722
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.13 ms 
SELECT t0.id AS id_1, t0.cover AS cover_2, t0.badge_color AS badge_color_3, t0.product_id AS product_id_4, t0.product_media_id AS product_media_id_5, t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_6 FROM product_attribute_image t0 WHERE t0.product_id = ? AND t0.cover = ?
Parameters: 
[
  11660
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.11 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  41206
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.10 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  41204
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.08 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  43684
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.08 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  43679
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.08 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  43687
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.08 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  43675
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.07 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  43681
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.08 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  43686
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.08 ms 
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.is_save AS is_save_4, t0.file AS file_5, t0.type AS type_6, t0.caption AS caption_7, t0.description AS description_8, t0.is_main_image AS is_main_image_9, t0.cover AS cover_10, t0.status AS status_11, t0.sort_order AS sort_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.product_id AS product_id_15 FROM product_media t0 WHERE t0.id = ?
Parameters: 
[
  45055
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.12 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_tag_description AS meta_tag_description_3, t0.meta_tag_keyword AS meta_tag_keyword_4, t0.description AS description_5, t0.seo_title AS seo_title_6, t0.seo_url AS seo_url_7, t0.image AS image_8, t0.icon AS icon_9, t0.top AS top_10, t0.sort_order AS sort_order_11, t0.status AS status_12, t0.deleted AS deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_category_id AS parent_category_id_16 FROM category t0 WHERE t0.seo_url = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "teile-federung-federgabeln-c-180_183_1"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_tag_description AS meta_tag_description_3, t0.meta_tag_keyword AS meta_tag_keyword_4, t0.description AS description_5, t0.seo_title AS seo_title_6, t0.seo_url AS seo_url_7, t0.image AS image_8, t0.icon AS icon_9, t0.top AS top_10, t0.sort_order AS sort_order_11, t0.status AS status_12, t0.deleted AS deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_category_id AS parent_category_id_16 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  183
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.08 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_tag_description AS meta_tag_description_3, t0.meta_tag_keyword AS meta_tag_keyword_4, t0.description AS description_5, t0.seo_title AS seo_title_6, t0.seo_url AS seo_url_7, t0.image AS image_8, t0.icon AS icon_9, t0.top AS top_10, t0.sort_order AS sort_order_11, t0.status AS status_12, t0.deleted AS deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_category_id AS parent_category_id_16 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  180
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.09 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_tag_description AS meta_tag_description_3, t0.meta_tag_keyword AS meta_tag_keyword_4, t0.description AS description_5, t0.seo_title AS seo_title_6, t0.seo_url AS seo_url_7, t0.image AS image_8, t0.icon AS icon_9, t0.top AS top_10, t0.sort_order AS sort_order_11, t0.status AS status_12, t0.deleted AS deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_category_id AS parent_category_id_16 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  " 183"
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.86 ms 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.ecp AS ecp_2, p0_.is_bulky AS is_bulky_3, p0_.new_name AS new_name_4, p0_.icp_name AS icp_name_5, p0_.code AS code_6, p0_.mpn_code AS mpn_code_7, p0_.ean_code AS ean_code_8, p0_.iean_code AS iean_code_9, p0_.sean_code AS sean_code_10, p0_.is_iean_print AS is_iean_print_11, p0_.is_cean_print AS is_cean_print_12, p0_.is_sean_print AS is_sean_print_13, p0_.sean AS sean_14, p0_.org_supplier_id AS org_supplier_id_15, p0_.is_retail_hold AS is_retail_hold_16, p0_.description AS description_17, p0_.type AS type_18, p0_.tags AS tags_19, p0_.product_custom_label AS product_custom_label_20, p0_.product_label_active_days AS product_label_active_days_21, p0_.required_configuration AS required_configuration_22, p0_.price AS price_23, p0_.price_gross AS price_gross_24, p0_.msrp AS msrp_25, p0_.distri_price AS distri_price_26, p0_.stock_item_value AS stock_item_value_27, p0_.stock_place AS stock_place_28, p0_.product_type AS product_type_29, p0_.quantity AS quantity_30, p0_.minimum_stock AS minimum_stock_31, p0_.minimum_stock_status AS minimum_stock_status_32, p0_.mins_last_status AS mins_last_status_33, p0_.is_force_mins AS is_force_mins_34, p0_.is_ds AS is_ds_35, p0_.is_force_ds AS is_force_ds_36, p0_.int_stockyard AS int_stockyard_37, p0_.vct_stock_quantity AS vct_stock_quantity_38, p0_.vct_stock_status AS vct_stock_status_39, p0_.expected_delivery_date AS expected_delivery_date_40, p0_.seller_item_id AS seller_item_id_41, p0_.other_seller_item_id AS other_seller_item_id_42, p0_.other_supplier_id AS other_supplier_id_43, p0_.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_44, p0_.cost_price AS cost_price_45, p0_.abroad_base_price AS abroad_base_price_46, p0_.base_price AS base_price_47, p0_.item_discount AS item_discount_48, p0_.purchase_price AS purchase_price_49, p0_.supplier_tax_category AS supplier_tax_category_50, p0_.publish_date AS publish_date_51, p0_.expire_date AS expire_date_52, p0_.require_shipping AS require_shipping_53, p0_.returnable AS returnable_54, p0_.stock_shelf AS stock_shelf_55, p0_.shelf_place AS shelf_place_56, p0_.package_width AS package_width_57, p0_.package_height AS package_height_58, p0_.package_depth AS package_depth_59, p0_.package_weight AS package_weight_60, p0_.related_product AS related_product_61, p0_.spare_parts AS spare_parts_62, p0_.components AS components_63, p0_.up_selling_product AS up_selling_product_64, p0_.cross_selling_product AS cross_selling_product_65, p0_.attachment AS attachment_66, p0_.seo_title AS seo_title_67, p0_.seo_description AS seo_description_68, p0_.seo_keyword AS seo_keyword_69, p0_.seo_url AS seo_url_70, p0_.old_seo_url AS old_seo_url_71, p0_.show_extra_fields AS show_extra_fields_72, p0_.status AS status_73, p0_.manual_status AS manual_status_74, p0_.is_manual_status AS is_manual_status_75, p0_.import AS import_76, p0_.display_stock_report AS display_stock_report_77, p0_.display_front_status_change AS display_front_status_change_78, p0_.deleted AS deleted_79, p0_.incomplete_product AS incomplete_product_80, p0_.assign_incomplete_product AS assign_incomplete_product_81, p0_.incomplete_to_assign_product AS incomplete_to_assign_product_82, p0_.incomplete_assign_product_id AS incomplete_assign_product_id_83, p0_.sort_order AS sort_order_84, p0_.profit AS profit_85, p0_.margin AS margin_86, p0_.b2b_profit AS b2b_profit_87, p0_.b2b_margin AS b2b_margin_88, p0_.catalogue_status AS catalogue_status_89, p0_.is_unite AS is_unite_90, p0_.supplier_cart_id AS supplier_cart_id_91, p0_.created_at AS created_at_92, p0_.updated_at AS updated_at_93, p0_.tax_id AS tax_id_94, p0_.stock_indicators_id AS stock_indicators_id_95, p0_.return_rule_id AS return_rule_id_96, p0_.category_id AS category_id_97, p0_.supplier_id AS supplier_id_98, p0_.manufacturer_id AS manufacturer_id_99, p0_.courier_id AS courier_id_100, p0_.sub_shipping_method_id AS sub_shipping_method_id_101, p0_.currency_id AS currency_id_102, p0_.product_label_id AS product_label_id_103 FROM product p0_ INNER JOIN product_category p1_ ON (p1_.product_id = p0_.id) INNER JOIN category c2_ ON (p1_.category_id = c2_.id) WHERE c2_.id = ? AND p0_.deleted = 0 AND p0_.status = 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.43 ms 
SELECT p0_.id AS id_0, p0_.product_option AS product_option_1, p0_.filter_navigation AS filter_navigation_2, p0_.tech_specification AS tech_specification_3, p0_.display_front AS display_front_4, p0_.ecp AS ecp_5, p0_.product_option_sort_order AS product_option_sort_order_6, p0_.tech_specification_sort_order AS tech_specification_sort_order_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.product_id AS product_id_10, p0_.category_product_characteristic_id AS category_product_characteristic_id_11 FROM product_attribute_options p0_ WHERE p0_.product_id IN (11782, 11783, 13528, 13662, 13663, 14149, 14163, 14170, 14352, 14360, 14361, 15292, 15300, 15565, 15563) AND p0_.product_option = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.45 ms 
SELECT p0_.id AS id_0, p0_.product_option AS product_option_1, p0_.filter_navigation AS filter_navigation_2, p0_.tech_specification AS tech_specification_3, p0_.display_front AS display_front_4, p0_.ecp AS ecp_5, p0_.product_option_sort_order AS product_option_sort_order_6, p0_.tech_specification_sort_order AS tech_specification_sort_order_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.product_id AS product_id_10, p0_.category_product_characteristic_id AS category_product_characteristic_id_11 FROM product_attribute_options p0_ WHERE p0_.product_id IN (11782, 11783, 13528, 13662, 13663, 14149, 14163, 14170, 14352, 14360, 14361, 15292, 15300, 15565, 15563) AND p0_.product_option = 1 AND p0_.display_front = 1 ORDER BY p0_.product_option_sort_order ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.61 ms 
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.characteristic_type AS characteristic_type_2, p0_.alias AS alias_3, p0_.code AS code_4, p0_.mpn_code AS mpn_code_5, p0_.ean_code AS ean_code_6, p0_.iean_code AS iean_code_7, p0_.sean_code AS sean_code_8, p0_.is_iean_print AS is_iean_print_9, p0_.is_cean_print AS is_cean_print_10, p0_.is_sean_print AS is_sean_print_11, p0_.sean AS sean_12, p0_.org_supplier_id AS org_supplier_id_13, p0_.price AS price_14, p0_.price_gross AS price_gross_15, p0_.msrp AS msrp_16, p0_.distri_price AS distri_price_17, p0_.stock_item_value AS stock_item_value_18, p0_.prefix AS prefix_19, p0_.stock_place AS stock_place_20, p0_.product_type AS product_type_21, p0_.quantity AS quantity_22, p0_.minimum_stock AS minimum_stock_23, p0_.minimum_stock_status AS minimum_stock_status_24, p0_.mins_last_status AS mins_last_status_25, p0_.is_force_mins AS is_force_mins_26, p0_.is_ds AS is_ds_27, p0_.is_force_ds AS is_force_ds_28, p0_.int_stockyard AS int_stockyard_29, p0_.vct_stock_quantity AS vct_stock_quantity_30, p0_.vct_stock_status AS vct_stock_status_31, p0_.expected_delivery_date AS expected_delivery_date_32, p0_.seller_item_id AS seller_item_id_33, p0_.other_seller_item_id AS other_seller_item_id_34, p0_.other_supplier_id AS other_supplier_id_35, p0_.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_36, p0_.cost_price AS cost_price_37, p0_.abroad_base_price AS abroad_base_price_38, p0_.base_price AS base_price_39, p0_.item_discount AS item_discount_40, p0_.purchase_price AS purchase_price_41, p0_.returnable AS returnable_42, p0_.supplier_tax_category AS supplier_tax_category_43, p0_.stock_shelf AS stock_shelf_44, p0_.shelf_place AS shelf_place_45, p0_.extra_charge AS extra_charge_46, p0_.session_id AS session_id_47, p0_.ip AS ip_48, p0_.sort_order AS sort_order_49, p0_.profit AS profit_50, p0_.margin AS margin_51, p0_.b2b_profit AS b2b_profit_52, p0_.b2b_margin AS b2b_margin_53, p0_.deleted AS deleted_54, p0_.status AS status_55, p0_.manual_status AS manual_status_56, p0_.is_manual_status AS is_manual_status_57, p0_.display_stock_report AS display_stock_report_58, p0_.publish_date AS publish_date_59, p0_.expire_date AS expire_date_60, p0_.is_unite AS is_unite_61, p0_.supplier_cart_id AS supplier_cart_id_62, p0_.created_at AS created_at_63, p0_.updated_at AS updated_at_64, p0_.product_id AS product_id_65, p0_.child_product_id AS child_product_id_66, p0_.child_product_attribute_id AS child_product_attribute_id_67, p0_.stock_indicators_id AS stock_indicators_id_68, p0_.category_product_characteristic_id AS category_product_characteristic_id_69, p0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_70, p0_.supplier_id AS supplier_id_71, p0_.return_rule_id AS return_rule_id_72 FROM product_attribute p0_ WHERE p0_.product_id IN (11782, 11783, 13528, 13662, 13663, 14149, 14163, 14170, 14352, 14360, 14361, 15292, 15300, 15565, 15563) AND p0_.deleted = 0 AND p0_.status = 1 AND p0_.type = ? AND p0_.characteristic_type = ?
Parameters: 
[
  "characteristic"
  "product_option"
]
View formatted query    View runnable query    Explain query    View query backtrace
64 1.37 ms 
SELECT c0_.id AS id_0, p1_.id AS id_1, p2_.value AS value_2 FROM child_product_characteristic_value c0_ INNER JOIN product_attribute p1_ ON (c0_.product_attribute_id = p1_.id) INNER JOIN category_product_characteristic_value c3_ ON (c0_.category_product_characteristic_value_id = c3_.id) INNER JOIN product_characteristic_value p2_ ON (c3_.product_characteristic_value_id = p2_.id) WHERE c0_.product_attribute_id IN (960852, 960853, 960854, 960855, 960856, 960857, 960858, 960859, 960907, 960908, 960909, 960910, 960911, 960912, 960913, 960914, 960915, 1095214, 1157974, 1158292, 1097138, 1097139, 1157833, 1097193, 1097194, 1154291, 1154292, 1155192, 1155193, 1155194, 1155195, 1155196, 1155197, 1155198, 1155199, 1155798, 1155799, 1155800, 1156965, 1156966, 1156967, 1156968, 1156969, 1156970, 1156971, 1156972, 1156973, 1156974, 1156975, 1156976, 1156977, 1156978, 1156979, 1156980, 1156981, 1156982, 1156983, 1156984, 1156985, 1156986, 1156987, 1156988, 1156989, 1156990, 1156991, 1156992, 1156993, 1156994, 1156995, 1156996, 1156997, 1156998, 1156999, 1157000, 1157001, 1157002, 1157003, 1157004, 1157005, 1157006, 1157824, 1157825, 1157826, 1157007, 1157013, 1157921, 1158328, 1157975, 1158324, 1158325, 1158326, 1158329)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.33 ms 
SELECT p0_.id AS id_0, p1_.cover AS cover_1, p1_.file AS file_2 FROM product_media p1_ INNER JOIN product p0_ ON (p1_.product_id = p0_.id) WHERE p1_.product_id IN (11782, 11783, 13528, 13662, 13663, 14149, 14163, 14170, 14352, 14360, 14361, 15292, 15300, 15565, 15563) AND p1_.type = ? AND p1_.status = 1 AND p1_.is_save IS NULL ORDER BY p1_.cover DESC, p1_.sort_order ASC
Parameters: 
[
  "image"
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.26 ms 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.ecp AS ecp_2, p0_.is_bulky AS is_bulky_3, p0_.new_name AS new_name_4, p0_.icp_name AS icp_name_5, p0_.code AS code_6, p0_.mpn_code AS mpn_code_7, p0_.ean_code AS ean_code_8, p0_.iean_code AS iean_code_9, p0_.sean_code AS sean_code_10, p0_.is_iean_print AS is_iean_print_11, p0_.is_cean_print AS is_cean_print_12, p0_.is_sean_print AS is_sean_print_13, p0_.sean AS sean_14, p0_.org_supplier_id AS org_supplier_id_15, p0_.is_retail_hold AS is_retail_hold_16, p0_.description AS description_17, p0_.type AS type_18, p0_.tags AS tags_19, p0_.product_custom_label AS product_custom_label_20, p0_.product_label_active_days AS product_label_active_days_21, p0_.required_configuration AS required_configuration_22, p0_.price AS price_23, p0_.price_gross AS price_gross_24, p0_.msrp AS msrp_25, p0_.distri_price AS distri_price_26, p0_.stock_item_value AS stock_item_value_27, p0_.stock_place AS stock_place_28, p0_.product_type AS product_type_29, p0_.quantity AS quantity_30, p0_.minimum_stock AS minimum_stock_31, p0_.minimum_stock_status AS minimum_stock_status_32, p0_.mins_last_status AS mins_last_status_33, p0_.is_force_mins AS is_force_mins_34, p0_.is_ds AS is_ds_35, p0_.is_force_ds AS is_force_ds_36, p0_.int_stockyard AS int_stockyard_37, p0_.vct_stock_quantity AS vct_stock_quantity_38, p0_.vct_stock_status AS vct_stock_status_39, p0_.expected_delivery_date AS expected_delivery_date_40, p0_.seller_item_id AS seller_item_id_41, p0_.other_seller_item_id AS other_seller_item_id_42, p0_.other_supplier_id AS other_supplier_id_43, p0_.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_44, p0_.cost_price AS cost_price_45, p0_.abroad_base_price AS abroad_base_price_46, p0_.base_price AS base_price_47, p0_.item_discount AS item_discount_48, p0_.purchase_price AS purchase_price_49, p0_.supplier_tax_category AS supplier_tax_category_50, p0_.publish_date AS publish_date_51, p0_.expire_date AS expire_date_52, p0_.require_shipping AS require_shipping_53, p0_.returnable AS returnable_54, p0_.stock_shelf AS stock_shelf_55, p0_.shelf_place AS shelf_place_56, p0_.package_width AS package_width_57, p0_.package_height AS package_height_58, p0_.package_depth AS package_depth_59, p0_.package_weight AS package_weight_60, p0_.related_product AS related_product_61, p0_.spare_parts AS spare_parts_62, p0_.components AS components_63, p0_.up_selling_product AS up_selling_product_64, p0_.cross_selling_product AS cross_selling_product_65, p0_.attachment AS attachment_66, p0_.seo_title AS seo_title_67, p0_.seo_description AS seo_description_68, p0_.seo_keyword AS seo_keyword_69, p0_.seo_url AS seo_url_70, p0_.old_seo_url AS old_seo_url_71, p0_.show_extra_fields AS show_extra_fields_72, p0_.status AS status_73, p0_.manual_status AS manual_status_74, p0_.is_manual_status AS is_manual_status_75, p0_.import AS import_76, p0_.display_stock_report AS display_stock_report_77, p0_.display_front_status_change AS display_front_status_change_78, p0_.deleted AS deleted_79, p0_.incomplete_product AS incomplete_product_80, p0_.assign_incomplete_product AS assign_incomplete_product_81, p0_.incomplete_to_assign_product AS incomplete_to_assign_product_82, p0_.incomplete_assign_product_id AS incomplete_assign_product_id_83, p0_.sort_order AS sort_order_84, p0_.profit AS profit_85, p0_.margin AS margin_86, p0_.b2b_profit AS b2b_profit_87, p0_.b2b_margin AS b2b_margin_88, p0_.catalogue_status AS catalogue_status_89, p0_.is_unite AS is_unite_90, p0_.supplier_cart_id AS supplier_cart_id_91, p0_.created_at AS created_at_92, p0_.updated_at AS updated_at_93, FIELD(p0_.id, 15492) AS sclr_94, p0_.tax_id AS tax_id_95, p0_.stock_indicators_id AS stock_indicators_id_96, p0_.return_rule_id AS return_rule_id_97, p0_.category_id AS category_id_98, p0_.supplier_id AS supplier_id_99, p0_.manufacturer_id AS manufacturer_id_100, p0_.courier_id AS courier_id_101, p0_.sub_shipping_method_id AS sub_shipping_method_id_102, p0_.currency_id AS currency_id_103, p0_.product_label_id AS product_label_id_104 FROM product p0_ WHERE p0_.id IN (15492) AND p0_.deleted = 0 AND p0_.status = 1 ORDER BY sclr_94 ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.11 ms 
SELECT p0_.id AS id_0, p0_.product_option AS product_option_1, p0_.filter_navigation AS filter_navigation_2, p0_.tech_specification AS tech_specification_3, p0_.display_front AS display_front_4, p0_.ecp AS ecp_5, p0_.product_option_sort_order AS product_option_sort_order_6, p0_.tech_specification_sort_order AS tech_specification_sort_order_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.product_id AS product_id_10, p0_.category_product_characteristic_id AS category_product_characteristic_id_11 FROM product_attribute_options p0_ WHERE p0_.product_id IN (15492) AND p0_.product_option = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.12 ms 
SELECT p0_.id AS id_0, p0_.product_option AS product_option_1, p0_.filter_navigation AS filter_navigation_2, p0_.tech_specification AS tech_specification_3, p0_.display_front AS display_front_4, p0_.ecp AS ecp_5, p0_.product_option_sort_order AS product_option_sort_order_6, p0_.tech_specification_sort_order AS tech_specification_sort_order_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.product_id AS product_id_10, p0_.category_product_characteristic_id AS category_product_characteristic_id_11 FROM product_attribute_options p0_ WHERE p0_.product_id IN (15492) AND p0_.product_option = 1 AND p0_.display_front = 1 ORDER BY p0_.product_option_sort_order ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.21 ms 
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.characteristic_type AS characteristic_type_2, p0_.alias AS alias_3, p0_.code AS code_4, p0_.mpn_code AS mpn_code_5, p0_.ean_code AS ean_code_6, p0_.iean_code AS iean_code_7, p0_.sean_code AS sean_code_8, p0_.is_iean_print AS is_iean_print_9, p0_.is_cean_print AS is_cean_print_10, p0_.is_sean_print AS is_sean_print_11, p0_.sean AS sean_12, p0_.org_supplier_id AS org_supplier_id_13, p0_.price AS price_14, p0_.price_gross AS price_gross_15, p0_.msrp AS msrp_16, p0_.distri_price AS distri_price_17, p0_.stock_item_value AS stock_item_value_18, p0_.prefix AS prefix_19, p0_.stock_place AS stock_place_20, p0_.product_type AS product_type_21, p0_.quantity AS quantity_22, p0_.minimum_stock AS minimum_stock_23, p0_.minimum_stock_status AS minimum_stock_status_24, p0_.mins_last_status AS mins_last_status_25, p0_.is_force_mins AS is_force_mins_26, p0_.is_ds AS is_ds_27, p0_.is_force_ds AS is_force_ds_28, p0_.int_stockyard AS int_stockyard_29, p0_.vct_stock_quantity AS vct_stock_quantity_30, p0_.vct_stock_status AS vct_stock_status_31, p0_.expected_delivery_date AS expected_delivery_date_32, p0_.seller_item_id AS seller_item_id_33, p0_.other_seller_item_id AS other_seller_item_id_34, p0_.other_supplier_id AS other_supplier_id_35, p0_.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_36, p0_.cost_price AS cost_price_37, p0_.abroad_base_price AS abroad_base_price_38, p0_.base_price AS base_price_39, p0_.item_discount AS item_discount_40, p0_.purchase_price AS purchase_price_41, p0_.returnable AS returnable_42, p0_.supplier_tax_category AS supplier_tax_category_43, p0_.stock_shelf AS stock_shelf_44, p0_.shelf_place AS shelf_place_45, p0_.extra_charge AS extra_charge_46, p0_.session_id AS session_id_47, p0_.ip AS ip_48, p0_.sort_order AS sort_order_49, p0_.profit AS profit_50, p0_.margin AS margin_51, p0_.b2b_profit AS b2b_profit_52, p0_.b2b_margin AS b2b_margin_53, p0_.deleted AS deleted_54, p0_.status AS status_55, p0_.manual_status AS manual_status_56, p0_.is_manual_status AS is_manual_status_57, p0_.display_stock_report AS display_stock_report_58, p0_.publish_date AS publish_date_59, p0_.expire_date AS expire_date_60, p0_.is_unite AS is_unite_61, p0_.supplier_cart_id AS supplier_cart_id_62, p0_.created_at AS created_at_63, p0_.updated_at AS updated_at_64, p0_.product_id AS product_id_65, p0_.child_product_id AS child_product_id_66, p0_.child_product_attribute_id AS child_product_attribute_id_67, p0_.stock_indicators_id AS stock_indicators_id_68, p0_.category_product_characteristic_id AS category_product_characteristic_id_69, p0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_70, p0_.supplier_id AS supplier_id_71, p0_.return_rule_id AS return_rule_id_72 FROM product_attribute p0_ WHERE p0_.product_id IN (15492) AND p0_.deleted = 0 AND p0_.status = 1 AND p0_.type = ? AND p0_.characteristic_type = ?
Parameters: 
[
  "characteristic"
  "product_option"
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.18 ms 
SELECT c0_.id AS id_0, p1_.id AS id_1, p2_.value AS value_2 FROM child_product_characteristic_value c0_ INNER JOIN product_attribute p1_ ON (c0_.product_attribute_id = p1_.id) INNER JOIN category_product_characteristic_value c3_ ON (c0_.category_product_characteristic_value_id = c3_.id) INNER JOIN product_characteristic_value p2_ ON (c3_.product_characteristic_value_id = p2_.id) WHERE c0_.product_attribute_id IN (1158037, 1158038)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.16 ms 
SELECT p0_.id AS id_0, p1_.cover AS cover_1, p1_.file AS file_2 FROM product_media p1_ INNER JOIN product p0_ ON (p1_.product_id = p0_.id) WHERE p1_.product_id IN (15492) AND p1_.type = ? AND p1_.status = 1 AND p1_.is_save IS NULL ORDER BY p1_.cover DESC, p1_.sort_order ASC
Parameters: 
[
  "image"
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.13 ms 
SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.sub_title AS sub_title_2, i0_.description AS description_3, i0_.combined AS combined_4, i0_.color AS color_5, i0_.seo_url AS seo_url_6, i0_.status AS status_7, i0_.created_at AS created_at_8, i0_.updated_at AS updated_at_9 FROM info_bar i0_ WHERE i0_.status = ? AND i0_.combined IS NOT NULL LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.09 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.description AS description_4, t0.combined AS combined_5, t0.color AS color_6, t0.seo_url AS seo_url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM info_bar t0 WHERE t0.status = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.12 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.time_line AS time_line_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM order_timelines t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "customer order submit time"
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.11 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.return_days AS return_days_3, t0.shipping_paid_by AS shipping_paid_by_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM return_rule t0 WHERE t0.is_default = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.12 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.seo_keyword AS seo_keyword_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_url AS seo_url_7, t0.image AS image_8, t0.position AS position_9, t0.sort_order AS sort_order_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM cms t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.09 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.seo_keyword AS seo_keyword_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_url AS seo_url_7, t0.image AS image_8, t0.position AS position_9, t0.sort_order AS sort_order_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM cms t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.08 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.seo_keyword AS seo_keyword_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_url AS seo_url_7, t0.image AS image_8, t0.position AS position_9, t0.sort_order AS sort_order_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM cms t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ProductAttribute 117
App\Entity\ChildProductCharacteristicValue 92
App\Entity\ProductAttributeOptions 65
App\Entity\Product 17
App\Entity\CategoryProductCharacteristicValue 14
App\Entity\ProductCharacteristicValue 14
App\Entity\CategoryProductCharacteristic 11
App\Entity\ProductAttributeImage 9
App\Entity\ProductMedia 9
App\Entity\Supplier 8
App\Entity\Category 5
App\Entity\Manufacturer 4
App\Entity\ProductCharacteristic 4
App\Entity\ProductLabel 3
App\Entity\Cms 3
App\Entity\Taxes 1
App\Entity\ReturnRule 1
App\Entity\Courier 1
App\Entity\ShippingMethod 1
App\Entity\Currency 1
App\Entity\StockIndicators 1
App\Entity\OrderTimelines 1

Entities Mapping

Class Mapping errors
App\Entity\CustomerBanIp No errors.
App\Entity\Settings No errors.
App\Entity\SpecialPrice No errors.
App\Entity\Product
  • The field App\Entity\Product#productAttributes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductAttribute#product does not contain the required 'inversedBy: "productAttributes"' attribute.
App\Entity\Taxes No errors.
App\Entity\StockIndicators No errors.
App\Entity\ReturnRule No errors.
App\Entity\Category No errors.
App\Entity\Supplier No errors.
App\Entity\Manufacturer No errors.
App\Entity\Courier No errors.
App\Entity\ShippingMethod No errors.
App\Entity\Currency No errors.
App\Entity\ProductLabel No errors.
App\Entity\ProductAttribute No errors.
App\Entity\CategoryProductCharacteristic No errors.
App\Entity\CategoryProductCharacteristicValue No errors.
App\Entity\ProductAttributeOptions No errors.
App\Entity\ChildProductCharacteristicValue No errors.
App\Entity\ProductCharacteristic No errors.
App\Entity\ProductCharacteristicValue No errors.
App\Entity\ProductAttributeImage No errors.
App\Entity\ProductMedia No errors.
App\Entity\ProductCategory No errors.
App\Entity\InfoBar No errors.
App\Entity\OrderTimelines No errors.
App\Entity\Cms No errors.