Symfony Profiler

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_
WHERE
  p0_.deleted = 0
  AND (
    p0_.incomplete_product = 0
    OR p0_.incomplete_product IS NULL
  )

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_ WHERE p0_.deleted = 0 AND (p0_.incomplete_product = 0 OR p0_.incomplete_product IS NULL);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.meta_tag_description AS meta_tag_description_2,
  c0_.meta_tag_keyword AS meta_tag_keyword_3,
  c0_.description AS description_4,
  c0_.seo_title AS seo_title_5,
  c0_.seo_url AS seo_url_6,
  c0_.image AS image_7,
  c0_.icon AS icon_8,
  c0_.top AS top_9,
  c0_.sort_order AS sort_order_10,
  c0_.status AS status_11,
  c0_.deleted AS deleted_12,
  c0_.created_at AS created_at_13,
  c0_.updated_at AS updated_at_14,
  c0_.parent_category_id AS parent_category_id_15
FROM
  category c0_
WHERE
  c0_.deleted = 0

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.meta_tag_description AS meta_tag_description_2, c0_.meta_tag_keyword AS meta_tag_keyword_3, c0_.description AS description_4, c0_.seo_title AS seo_title_5, c0_.seo_url AS seo_url_6, c0_.image AS image_7, c0_.icon AS icon_8, c0_.top AS top_9, c0_.sort_order AS sort_order_10, c0_.status AS status_11, c0_.deleted AS deleted_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.parent_category_id AS parent_category_id_15 FROM category c0_ WHERE c0_.deleted = 0;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.seo_keyword AS seo_keyword_3,
  c0_.seo_title AS seo_title_4,
  c0_.seo_description AS seo_description_5,
  c0_.seo_url AS seo_url_6,
  c0_.image AS image_7,
  c0_.position AS position_8,
  c0_.sort_order AS sort_order_9,
  c0_.status AS status_10,
  c0_.created_at AS created_at_11,
  c0_.updated_at AS updated_at_12
FROM
  cms c0_
WHERE
  c0_.status = 1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.seo_keyword AS seo_keyword_3, c0_.seo_title AS seo_title_4, c0_.seo_description AS seo_description_5, c0_.seo_url AS seo_url_6, c0_.image AS image_7, c0_.position AS position_8, c0_.sort_order AS sort_order_9, c0_.status AS status_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12 FROM cms c0_ WHERE c0_.status = 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2
FROM
  customer_ban_ip t0
WHERE
  t0.ip = ?

SELECT t0.id AS id_1, t0.ip AS ip_2 FROM customer_ban_ip t0 WHERE t0.ip = '216.73.216.147';

SELECT
  s0_.current_timezone AS current_timezone_0
FROM
  settings s0_
LIMIT
  1

SELECT s0_.current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1;

SELECT
  p0_.color AS color_0
FROM
  product_label p0_
WHERE
  p0_.alias = ?
LIMIT
  1

SELECT p0_.color AS color_0 FROM product_label p0_ WHERE p0_.alias = 'discount' LIMIT 1;

SELECT
  p0_.color AS color_0,
  p0_.name AS name_1
FROM
  product_label p0_
WHERE
  p0_.id = 10
LIMIT
  1

SELECT p0_.color AS color_0, p0_.name AS name_1 FROM product_label p0_ WHERE p0_.id = 10 LIMIT 1;