Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.key_app AS key_app_1,
  p0_.name AS name_2,
  p0_.active_flag AS active_flag_3
FROM
  product_groups p0_
WHERE
  p0_.key_app LIKE ?

SELECT p0_.id AS id_0, p0_.key_app AS key_app_1, p0_.name AS name_2, p0_.active_flag AS active_flag_3 FROM product_groups p0_ WHERE p0_.key_app LIKE '%tubes%';

SELECT
  DISTINCT d0_.id AS id_0,
  d1_.cl_delivery_status AS cl_delivery_status_1,
  d0_.rim AS rim_2
FROM
  data_tires_master d0_
  INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id
  LEFT JOIN cart c2_ ON d0_.id = c2_.article_id
  INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id
WHERE
  d1_.cl_state <> 'X'
  AND d1_.cl_active_flag_consumer = 1
  AND d0_.product_group_id IN (17, 36, 37, 1100)
ORDER BY
  d1_.cl_delivery_status ASC,
  d0_.rim ASC
LIMIT
  20

SELECT DISTINCT d0_.id AS id_0, d1_.cl_delivery_status AS cl_delivery_status_1, d0_.rim AS rim_2 FROM data_tires_master d0_ INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id LEFT JOIN cart c2_ ON d0_.id = c2_.article_id INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id WHERE d1_.cl_state <> 'X' AND d1_.cl_active_flag_consumer = 1 AND d0_.product_group_id IN (17, 36, 37, 1100) ORDER BY d1_.cl_delivery_status ASC, d0_.rim ASC LIMIT 20;

SELECT
  d0_.id AS id_0,
  d0_.ean AS ean_1,
  d0_.order_no AS order_no_2,
  d0_.product_group_manufacturer AS product_group_manufacturer_3,
  d0_.size AS size_4,
  d0_.tread_id AS tread_id_5,
  d0_.tread_id2 AS tread_id2_6,
  d0_.tread_name AS tread_name_7,
  d0_.tread_longtext AS tread_longtext_8,
  d0_.rim AS rim_9,
  d0_.construction_type AS construction_type_10,
  d0_.load_capacity AS load_capacity_11,
  d0_.speed_index AS speed_index_12,
  d0_.tube AS tube_13,
  d0_.category_index AS category_index_14,
  d0_.image_path AS image_path_15,
  d0_.matchcode AS matchcode_16,
  d0_.pg1 AS pg1_17,
  d0_.pg2 AS pg2_18,
  d0_.pg3 AS pg3_19,
  d0_.pg4 AS pg4_20,
  d0_.pg5 AS pg5_21,
  d0_.pg6 AS pg6_22,
  d0_.pg7 AS pg7_23,
  d0_.pg8 AS pg8_24,
  d0_.pg9 AS pg9_25,
  d0_.pg10 AS pg10_26,
  d0_.selling_price_consumer_gross1 AS selling_price_consumer_gross1_27,
  d0_.selling_price_consumer_gross2 AS selling_price_consumer_gross2_28,
  d0_.selling_price_consumer_gross3 AS selling_price_consumer_gross3_29,
  d0_.stock AS stock_30,
  d0_.delivery_status AS delivery_status_31,
  d0_.special_price_flag AS special_price_flag_32,
  d0_.offer_flag AS offer_flag_33,
  d0_.expiry_flag AS expiry_flag_34,
  d0_.in_preparation_flag AS in_preparation_flag_35,
  d0_.article_group AS article_group_36,
  d0_.article_subgroup AS article_subgroup_37,
  d0_.alt_article_no1 AS alt_article_no1_38,
  d0_.alt_article_no2 AS alt_article_no2_39,
  d0_.alt_article_no3 AS alt_article_no3_40,
  d0_.info1 AS info1_41,
  d0_.info2 AS info2_42,
  d0_.info3 AS info3_43,
  d0_.note AS note_44,
  d0_.application_purpose AS application_purpose_45,
  d0_.article_dead_flag AS article_dead_flag_46,
  d0_.article_expiry_flag AS article_expiry_flag_47,
  d0_.article_in_preparation_flag AS article_in_preparation_flag_48,
  d0_.article_new_flag AS article_new_flag_49,
  d0_.unit_premium_flag AS unit_premium_flag_50,
  d0_.dot_week AS dot_week_51,
  d0_.dot_year AS dot_year_52,
  d0_.ms_flag AS ms_flag_53,
  d0_.from_mms_flag AS from_mms_flag_54,
  d0_.active_flag AS active_flag_55,
  d1_.id AS id_56,
  d1_.cl_article_id AS cl_article_id_57,
  d1_.cl_info_text AS cl_info_text_58,
  d1_.cl_offer_flag AS cl_offer_flag_59,
  d1_.cl_special_discount_flag AS cl_special_discount_flag_60,
  d1_.cl_discount0 AS cl_discount0_61,
  d1_.cl_discount1 AS cl_discount1_62,
  d1_.cl_discount2 AS cl_discount2_63,
  d1_.cl_discount3 AS cl_discount3_64,
  d1_.cl_discount4 AS cl_discount4_65,
  d1_.cl_discount5 AS cl_discount5_66,
  d1_.cl_discount6 AS cl_discount6_67,
  d1_.cl_discount7 AS cl_discount7_68,
  d1_.cl_discount8 AS cl_discount8_69,
  d1_.cl_discount9 AS cl_discount9_70,
  d1_.cl_discount10 AS cl_discount10_71,
  d1_.cl_special_price_flag0 AS cl_special_price_flag0_72,
  d1_.cl_selling_price0 AS cl_selling_price0_73,
  d1_.cl_special_price_flag1 AS cl_special_price_flag1_74,
  d1_.cl_selling_price1 AS cl_selling_price1_75,
  d1_.cl_special_price_flag2 AS cl_special_price_flag2_76,
  d1_.cl_selling_price2 AS cl_selling_price2_77,
  d1_.cl_special_price_flag3 AS cl_special_price_flag3_78,
  d1_.cl_selling_price3 AS cl_selling_price3_79,
  d1_.cl_special_price_flag4 AS cl_special_price_flag4_80,
  d1_.cl_selling_price4 AS cl_selling_price4_81,
  d1_.cl_special_price_flag5 AS cl_special_price_flag5_82,
  d1_.cl_selling_price5 AS cl_selling_price5_83,
  d1_.cl_special_price_flag6 AS cl_special_price_flag6_84,
  d1_.cl_selling_price6 AS cl_selling_price6_85,
  d1_.cl_special_price_flag7 AS cl_special_price_flag7_86,
  d1_.cl_selling_price7 AS cl_selling_price7_87,
  d1_.cl_special_price_flag8 AS cl_special_price_flag8_88,
  d1_.cl_selling_price8 AS cl_selling_price8_89,
  d1_.cl_special_price_flag9 AS cl_special_price_flag9_90,
  d1_.cl_selling_price9 AS cl_selling_price9_91,
  d1_.cl_special_price_flag10 AS cl_special_price_flag10_92,
  d1_.cl_selling_price10 AS cl_selling_price10_93,
  d1_.cl_stock AS cl_stock_94,
  d1_.cl_delivery_status AS cl_delivery_status_95,
  d1_.cl_state AS cl_state_96,
  d1_.cl_delivery_status_old AS cl_delivery_status_old_97,
  d1_.cl_selection_homepage_flag AS cl_selection_homepage_flag_98,
  d1_.cl_datetime_creation AS cl_datetime_creation_99,
  d1_.cl_datetime_edited AS cl_datetime_edited_100,
  d1_.cl_active_flag AS cl_active_flag_101,
  d1_.cl_active_flag_merchant AS cl_active_flag_merchant_102,
  d1_.cl_active_flag_consumer AS cl_active_flag_consumer_103,
  d1_.cl_warning_text AS cl_warning_text_104,
  c2_.id AS id_105,
  c2_.session_id AS session_id_106,
  c2_.amount AS amount_107,
  c2_.commission AS commission_108,
  c2_.tube AS tube_109,
  c2_.dealer AS dealer_110,
  c2_.context AS context_111,
  c2_.timestamp AS timestamp_112,
  t3_.id AS id_113,
  t3_.name AS name_114,
  t3_.categories AS categories_115,
  t3_.active_flag AS active_flag_116,
  d0_.manufacturer_id AS manufacturer_id_117,
  d0_.product_group_id AS product_group_id_118,
  d0_.data_tires_client_id AS data_tires_client_id_119,
  c2_.article_id AS article_id_120,
  c2_.user_id AS user_id_121
FROM
  data_tires_master d0_
  INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id
  LEFT JOIN cart c2_ ON d0_.id = c2_.article_id
  INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id
WHERE
  d1_.cl_state <> 'X'
  AND d1_.cl_active_flag_consumer = 1
  AND d0_.product_group_id IN (17, 36, 37, 1100)
  AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  d1_.cl_delivery_status ASC,
  d0_.rim ASC

SELECT d0_.id AS id_0, d0_.ean AS ean_1, d0_.order_no AS order_no_2, d0_.product_group_manufacturer AS product_group_manufacturer_3, d0_.size AS size_4, d0_.tread_id AS tread_id_5, d0_.tread_id2 AS tread_id2_6, d0_.tread_name AS tread_name_7, d0_.tread_longtext AS tread_longtext_8, d0_.rim AS rim_9, d0_.construction_type AS construction_type_10, d0_.load_capacity AS load_capacity_11, d0_.speed_index AS speed_index_12, d0_.tube AS tube_13, d0_.category_index AS category_index_14, d0_.image_path AS image_path_15, d0_.matchcode AS matchcode_16, d0_.pg1 AS pg1_17, d0_.pg2 AS pg2_18, d0_.pg3 AS pg3_19, d0_.pg4 AS pg4_20, d0_.pg5 AS pg5_21, d0_.pg6 AS pg6_22, d0_.pg7 AS pg7_23, d0_.pg8 AS pg8_24, d0_.pg9 AS pg9_25, d0_.pg10 AS pg10_26, d0_.selling_price_consumer_gross1 AS selling_price_consumer_gross1_27, d0_.selling_price_consumer_gross2 AS selling_price_consumer_gross2_28, d0_.selling_price_consumer_gross3 AS selling_price_consumer_gross3_29, d0_.stock AS stock_30, d0_.delivery_status AS delivery_status_31, d0_.special_price_flag AS special_price_flag_32, d0_.offer_flag AS offer_flag_33, d0_.expiry_flag AS expiry_flag_34, d0_.in_preparation_flag AS in_preparation_flag_35, d0_.article_group AS article_group_36, d0_.article_subgroup AS article_subgroup_37, d0_.alt_article_no1 AS alt_article_no1_38, d0_.alt_article_no2 AS alt_article_no2_39, d0_.alt_article_no3 AS alt_article_no3_40, d0_.info1 AS info1_41, d0_.info2 AS info2_42, d0_.info3 AS info3_43, d0_.note AS note_44, d0_.application_purpose AS application_purpose_45, d0_.article_dead_flag AS article_dead_flag_46, d0_.article_expiry_flag AS article_expiry_flag_47, d0_.article_in_preparation_flag AS article_in_preparation_flag_48, d0_.article_new_flag AS article_new_flag_49, d0_.unit_premium_flag AS unit_premium_flag_50, d0_.dot_week AS dot_week_51, d0_.dot_year AS dot_year_52, d0_.ms_flag AS ms_flag_53, d0_.from_mms_flag AS from_mms_flag_54, d0_.active_flag AS active_flag_55, d1_.id AS id_56, d1_.cl_article_id AS cl_article_id_57, d1_.cl_info_text AS cl_info_text_58, d1_.cl_offer_flag AS cl_offer_flag_59, d1_.cl_special_discount_flag AS cl_special_discount_flag_60, d1_.cl_discount0 AS cl_discount0_61, d1_.cl_discount1 AS cl_discount1_62, d1_.cl_discount2 AS cl_discount2_63, d1_.cl_discount3 AS cl_discount3_64, d1_.cl_discount4 AS cl_discount4_65, d1_.cl_discount5 AS cl_discount5_66, d1_.cl_discount6 AS cl_discount6_67, d1_.cl_discount7 AS cl_discount7_68, d1_.cl_discount8 AS cl_discount8_69, d1_.cl_discount9 AS cl_discount9_70, d1_.cl_discount10 AS cl_discount10_71, d1_.cl_special_price_flag0 AS cl_special_price_flag0_72, d1_.cl_selling_price0 AS cl_selling_price0_73, d1_.cl_special_price_flag1 AS cl_special_price_flag1_74, d1_.cl_selling_price1 AS cl_selling_price1_75, d1_.cl_special_price_flag2 AS cl_special_price_flag2_76, d1_.cl_selling_price2 AS cl_selling_price2_77, d1_.cl_special_price_flag3 AS cl_special_price_flag3_78, d1_.cl_selling_price3 AS cl_selling_price3_79, d1_.cl_special_price_flag4 AS cl_special_price_flag4_80, d1_.cl_selling_price4 AS cl_selling_price4_81, d1_.cl_special_price_flag5 AS cl_special_price_flag5_82, d1_.cl_selling_price5 AS cl_selling_price5_83, d1_.cl_special_price_flag6 AS cl_special_price_flag6_84, d1_.cl_selling_price6 AS cl_selling_price6_85, d1_.cl_special_price_flag7 AS cl_special_price_flag7_86, d1_.cl_selling_price7 AS cl_selling_price7_87, d1_.cl_special_price_flag8 AS cl_special_price_flag8_88, d1_.cl_selling_price8 AS cl_selling_price8_89, d1_.cl_special_price_flag9 AS cl_special_price_flag9_90, d1_.cl_selling_price9 AS cl_selling_price9_91, d1_.cl_special_price_flag10 AS cl_special_price_flag10_92, d1_.cl_selling_price10 AS cl_selling_price10_93, d1_.cl_stock AS cl_stock_94, d1_.cl_delivery_status AS cl_delivery_status_95, d1_.cl_state AS cl_state_96, d1_.cl_delivery_status_old AS cl_delivery_status_old_97, d1_.cl_selection_homepage_flag AS cl_selection_homepage_flag_98, d1_.cl_datetime_creation AS cl_datetime_creation_99, d1_.cl_datetime_edited AS cl_datetime_edited_100, d1_.cl_active_flag AS cl_active_flag_101, d1_.cl_active_flag_merchant AS cl_active_flag_merchant_102, d1_.cl_active_flag_consumer AS cl_active_flag_consumer_103, d1_.cl_warning_text AS cl_warning_text_104, c2_.id AS id_105, c2_.session_id AS session_id_106, c2_.amount AS amount_107, c2_.commission AS commission_108, c2_.tube AS tube_109, c2_.dealer AS dealer_110, c2_.context AS context_111, c2_.timestamp AS timestamp_112, t3_.id AS id_113, t3_.name AS name_114, t3_.categories AS categories_115, t3_.active_flag AS active_flag_116, d0_.manufacturer_id AS manufacturer_id_117, d0_.product_group_id AS product_group_id_118, d0_.data_tires_client_id AS data_tires_client_id_119, c2_.article_id AS article_id_120, c2_.user_id AS user_id_121 FROM data_tires_master d0_ INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id LEFT JOIN cart c2_ ON d0_.id = c2_.article_id INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id WHERE d1_.cl_state <> 'X' AND d1_.cl_active_flag_consumer = 1 AND d0_.product_group_id IN (17, 36, 37, 1100) AND d0_.id IN (17100170, 26814, 1763, 2109, 17160000, 17170060, 17170110, 17180100) ORDER BY d1_.cl_delivery_status ASC, d0_.rim ASC;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  data_tires_master d0_
  INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id
  LEFT JOIN cart c2_ ON d0_.id = c2_.article_id
  INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id
WHERE
  d1_.cl_state <> 'X'
  AND d1_.cl_active_flag_consumer = 1
  AND d0_.product_group_id IN (17, 36, 37, 1100)

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM data_tires_master d0_ INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id LEFT JOIN cart c2_ ON d0_.id = c2_.article_id INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id WHERE d1_.cl_state <> 'X' AND d1_.cl_active_flag_consumer = 1 AND d0_.product_group_id IN (17, 36, 37, 1100);

SELECT
  d0_.id AS id_0,
  d0_.level0 AS level0_1,
  d0_.level1 AS level1_2,
  d0_.level2 AS level2_3,
  d0_.level3 AS level3_4,
  d0_.level4 AS level4_5,
  d0_.level5 AS level5_6,
  d0_.level6 AS level6_7,
  d0_.level7 AS level7_8,
  d0_.level8 AS level8_9,
  d0_.level9 AS level9_10,
  d0_.level10 AS level10_11,
  d0_.level11 AS level11_12,
  d0_.level12 AS level12_13,
  d0_.new_flag AS new_flag_14,
  d0_.active_flag AS active_flag_15,
  d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16,
  d0_.product_group_tmp AS product_group_tmp_17,
  d0_.tire_manufacturer_id AS tire_manufacturer_id_18,
  d0_.product_group_id AS product_group_id_19
FROM
  discount_level d0_
WHERE
  d0_.tire_manufacturer_id = 13
  AND d0_.product_group_id = 17
  AND d0_.active_flag = 1

SELECT d0_.id AS id_0, d0_.level0 AS level0_1, d0_.level1 AS level1_2, d0_.level2 AS level2_3, d0_.level3 AS level3_4, d0_.level4 AS level4_5, d0_.level5 AS level5_6, d0_.level6 AS level6_7, d0_.level7 AS level7_8, d0_.level8 AS level8_9, d0_.level9 AS level9_10, d0_.level10 AS level10_11, d0_.level11 AS level11_12, d0_.level12 AS level12_13, d0_.new_flag AS new_flag_14, d0_.active_flag AS active_flag_15, d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16, d0_.product_group_tmp AS product_group_tmp_17, d0_.tire_manufacturer_id AS tire_manufacturer_id_18, d0_.product_group_id AS product_group_id_19 FROM discount_level d0_ WHERE d0_.tire_manufacturer_id = 13 AND d0_.product_group_id = 17 AND d0_.active_flag = 1;

SELECT
  d0_.id AS id_0,
  d0_.level0 AS level0_1,
  d0_.level1 AS level1_2,
  d0_.level2 AS level2_3,
  d0_.level3 AS level3_4,
  d0_.level4 AS level4_5,
  d0_.level5 AS level5_6,
  d0_.level6 AS level6_7,
  d0_.level7 AS level7_8,
  d0_.level8 AS level8_9,
  d0_.level9 AS level9_10,
  d0_.level10 AS level10_11,
  d0_.level11 AS level11_12,
  d0_.level12 AS level12_13,
  d0_.new_flag AS new_flag_14,
  d0_.active_flag AS active_flag_15,
  d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16,
  d0_.product_group_tmp AS product_group_tmp_17,
  d0_.tire_manufacturer_id AS tire_manufacturer_id_18,
  d0_.product_group_id AS product_group_id_19
FROM
  discount_level d0_
WHERE
  d0_.tire_manufacturer_id = 1
  AND d0_.product_group_id = 17
  AND d0_.active_flag = 1

SELECT d0_.id AS id_0, d0_.level0 AS level0_1, d0_.level1 AS level1_2, d0_.level2 AS level2_3, d0_.level3 AS level3_4, d0_.level4 AS level4_5, d0_.level5 AS level5_6, d0_.level6 AS level6_7, d0_.level7 AS level7_8, d0_.level8 AS level8_9, d0_.level9 AS level9_10, d0_.level10 AS level10_11, d0_.level11 AS level11_12, d0_.level12 AS level12_13, d0_.new_flag AS new_flag_14, d0_.active_flag AS active_flag_15, d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16, d0_.product_group_tmp AS product_group_tmp_17, d0_.tire_manufacturer_id AS tire_manufacturer_id_18, d0_.product_group_id AS product_group_id_19 FROM discount_level d0_ WHERE d0_.tire_manufacturer_id = 1 AND d0_.product_group_id = 17 AND d0_.active_flag = 1;

SELECT
  d0_.id AS id_0,
  d0_.level0 AS level0_1,
  d0_.level1 AS level1_2,
  d0_.level2 AS level2_3,
  d0_.level3 AS level3_4,
  d0_.level4 AS level4_5,
  d0_.level5 AS level5_6,
  d0_.level6 AS level6_7,
  d0_.level7 AS level7_8,
  d0_.level8 AS level8_9,
  d0_.level9 AS level9_10,
  d0_.level10 AS level10_11,
  d0_.level11 AS level11_12,
  d0_.level12 AS level12_13,
  d0_.new_flag AS new_flag_14,
  d0_.active_flag AS active_flag_15,
  d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16,
  d0_.product_group_tmp AS product_group_tmp_17,
  d0_.tire_manufacturer_id AS tire_manufacturer_id_18,
  d0_.product_group_id AS product_group_id_19
FROM
  discount_level d0_
WHERE
  d0_.tire_manufacturer_id = 1
  AND d0_.product_group_id = 17
  AND d0_.active_flag = 1

SELECT d0_.id AS id_0, d0_.level0 AS level0_1, d0_.level1 AS level1_2, d0_.level2 AS level2_3, d0_.level3 AS level3_4, d0_.level4 AS level4_5, d0_.level5 AS level5_6, d0_.level6 AS level6_7, d0_.level7 AS level7_8, d0_.level8 AS level8_9, d0_.level9 AS level9_10, d0_.level10 AS level10_11, d0_.level11 AS level11_12, d0_.level12 AS level12_13, d0_.new_flag AS new_flag_14, d0_.active_flag AS active_flag_15, d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16, d0_.product_group_tmp AS product_group_tmp_17, d0_.tire_manufacturer_id AS tire_manufacturer_id_18, d0_.product_group_id AS product_group_id_19 FROM discount_level d0_ WHERE d0_.tire_manufacturer_id = 1 AND d0_.product_group_id = 17 AND d0_.active_flag = 1;

SELECT
  d0_.id AS id_0,
  d0_.level0 AS level0_1,
  d0_.level1 AS level1_2,
  d0_.level2 AS level2_3,
  d0_.level3 AS level3_4,
  d0_.level4 AS level4_5,
  d0_.level5 AS level5_6,
  d0_.level6 AS level6_7,
  d0_.level7 AS level7_8,
  d0_.level8 AS level8_9,
  d0_.level9 AS level9_10,
  d0_.level10 AS level10_11,
  d0_.level11 AS level11_12,
  d0_.level12 AS level12_13,
  d0_.new_flag AS new_flag_14,
  d0_.active_flag AS active_flag_15,
  d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16,
  d0_.product_group_tmp AS product_group_tmp_17,
  d0_.tire_manufacturer_id AS tire_manufacturer_id_18,
  d0_.product_group_id AS product_group_id_19
FROM
  discount_level d0_
WHERE
  d0_.tire_manufacturer_id = 5
  AND d0_.product_group_id = 17
  AND d0_.active_flag = 1

SELECT d0_.id AS id_0, d0_.level0 AS level0_1, d0_.level1 AS level1_2, d0_.level2 AS level2_3, d0_.level3 AS level3_4, d0_.level4 AS level4_5, d0_.level5 AS level5_6, d0_.level6 AS level6_7, d0_.level7 AS level7_8, d0_.level8 AS level8_9, d0_.level9 AS level9_10, d0_.level10 AS level10_11, d0_.level11 AS level11_12, d0_.level12 AS level12_13, d0_.new_flag AS new_flag_14, d0_.active_flag AS active_flag_15, d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16, d0_.product_group_tmp AS product_group_tmp_17, d0_.tire_manufacturer_id AS tire_manufacturer_id_18, d0_.product_group_id AS product_group_id_19 FROM discount_level d0_ WHERE d0_.tire_manufacturer_id = 5 AND d0_.product_group_id = 17 AND d0_.active_flag = 1;

SELECT
  d0_.id AS id_0,
  d0_.level0 AS level0_1,
  d0_.level1 AS level1_2,
  d0_.level2 AS level2_3,
  d0_.level3 AS level3_4,
  d0_.level4 AS level4_5,
  d0_.level5 AS level5_6,
  d0_.level6 AS level6_7,
  d0_.level7 AS level7_8,
  d0_.level8 AS level8_9,
  d0_.level9 AS level9_10,
  d0_.level10 AS level10_11,
  d0_.level11 AS level11_12,
  d0_.level12 AS level12_13,
  d0_.new_flag AS new_flag_14,
  d0_.active_flag AS active_flag_15,
  d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16,
  d0_.product_group_tmp AS product_group_tmp_17,
  d0_.tire_manufacturer_id AS tire_manufacturer_id_18,
  d0_.product_group_id AS product_group_id_19
FROM
  discount_level d0_
WHERE
  d0_.tire_manufacturer_id = 13
  AND d0_.product_group_id = 17
  AND d0_.active_flag = 1

SELECT d0_.id AS id_0, d0_.level0 AS level0_1, d0_.level1 AS level1_2, d0_.level2 AS level2_3, d0_.level3 AS level3_4, d0_.level4 AS level4_5, d0_.level5 AS level5_6, d0_.level6 AS level6_7, d0_.level7 AS level7_8, d0_.level8 AS level8_9, d0_.level9 AS level9_10, d0_.level10 AS level10_11, d0_.level11 AS level11_12, d0_.level12 AS level12_13, d0_.new_flag AS new_flag_14, d0_.active_flag AS active_flag_15, d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16, d0_.product_group_tmp AS product_group_tmp_17, d0_.tire_manufacturer_id AS tire_manufacturer_id_18, d0_.product_group_id AS product_group_id_19 FROM discount_level d0_ WHERE d0_.tire_manufacturer_id = 13 AND d0_.product_group_id = 17 AND d0_.active_flag = 1;

SELECT
  d0_.id AS id_0,
  d0_.level0 AS level0_1,
  d0_.level1 AS level1_2,
  d0_.level2 AS level2_3,
  d0_.level3 AS level3_4,
  d0_.level4 AS level4_5,
  d0_.level5 AS level5_6,
  d0_.level6 AS level6_7,
  d0_.level7 AS level7_8,
  d0_.level8 AS level8_9,
  d0_.level9 AS level9_10,
  d0_.level10 AS level10_11,
  d0_.level11 AS level11_12,
  d0_.level12 AS level12_13,
  d0_.new_flag AS new_flag_14,
  d0_.active_flag AS active_flag_15,
  d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16,
  d0_.product_group_tmp AS product_group_tmp_17,
  d0_.tire_manufacturer_id AS tire_manufacturer_id_18,
  d0_.product_group_id AS product_group_id_19
FROM
  discount_level d0_
WHERE
  d0_.tire_manufacturer_id = 13
  AND d0_.product_group_id = 17
  AND d0_.active_flag = 1

SELECT d0_.id AS id_0, d0_.level0 AS level0_1, d0_.level1 AS level1_2, d0_.level2 AS level2_3, d0_.level3 AS level3_4, d0_.level4 AS level4_5, d0_.level5 AS level5_6, d0_.level6 AS level6_7, d0_.level7 AS level7_8, d0_.level8 AS level8_9, d0_.level9 AS level9_10, d0_.level10 AS level10_11, d0_.level11 AS level11_12, d0_.level12 AS level12_13, d0_.new_flag AS new_flag_14, d0_.active_flag AS active_flag_15, d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16, d0_.product_group_tmp AS product_group_tmp_17, d0_.tire_manufacturer_id AS tire_manufacturer_id_18, d0_.product_group_id AS product_group_id_19 FROM discount_level d0_ WHERE d0_.tire_manufacturer_id = 13 AND d0_.product_group_id = 17 AND d0_.active_flag = 1;

SELECT
  d0_.id AS id_0,
  d0_.level0 AS level0_1,
  d0_.level1 AS level1_2,
  d0_.level2 AS level2_3,
  d0_.level3 AS level3_4,
  d0_.level4 AS level4_5,
  d0_.level5 AS level5_6,
  d0_.level6 AS level6_7,
  d0_.level7 AS level7_8,
  d0_.level8 AS level8_9,
  d0_.level9 AS level9_10,
  d0_.level10 AS level10_11,
  d0_.level11 AS level11_12,
  d0_.level12 AS level12_13,
  d0_.new_flag AS new_flag_14,
  d0_.active_flag AS active_flag_15,
  d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16,
  d0_.product_group_tmp AS product_group_tmp_17,
  d0_.tire_manufacturer_id AS tire_manufacturer_id_18,
  d0_.product_group_id AS product_group_id_19
FROM
  discount_level d0_
WHERE
  d0_.tire_manufacturer_id = 5
  AND d0_.product_group_id = 17
  AND d0_.active_flag = 1

SELECT d0_.id AS id_0, d0_.level0 AS level0_1, d0_.level1 AS level1_2, d0_.level2 AS level2_3, d0_.level3 AS level3_4, d0_.level4 AS level4_5, d0_.level5 AS level5_6, d0_.level6 AS level6_7, d0_.level7 AS level7_8, d0_.level8 AS level8_9, d0_.level9 AS level9_10, d0_.level10 AS level10_11, d0_.level11 AS level11_12, d0_.level12 AS level12_13, d0_.new_flag AS new_flag_14, d0_.active_flag AS active_flag_15, d0_.tire_manufacturer_tmp AS tire_manufacturer_tmp_16, d0_.product_group_tmp AS product_group_tmp_17, d0_.tire_manufacturer_id AS tire_manufacturer_id_18, d0_.product_group_id AS product_group_id_19 FROM discount_level d0_ WHERE d0_.tire_manufacturer_id = 5 AND d0_.product_group_id = 17 AND d0_.active_flag = 1;