Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.sorrend AS sorrend_1,
  p0_.name AS name_2,
  p0_.active AS active_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.file AS file_6,
  p0_.icon AS icon_7,
  p0_.alias AS alias_8,
  p0_.raktaron AS raktaron_9,
  p0_.ujdonsag AS ujdonsag_10,
  p0_.kedvelt AS kedvelt_11,
  p0_.akcios AS akcios_12,
  p0_.icon_alt AS icon_alt_13,
  p0_.icon_title AS icon_title_14,
  p0_.label AS label_15,
  p0_.menu AS menu_16,
  p0_.megrendelo_tipus AS megrendelo_tipus_17,
  p0_.mertekegyseg AS mertekegyseg_18,
  p0_.webshop_enabled AS webshop_enabled_19,
  p0_.valtoszam AS valtoszam_20,
  p0_.u_hossz_mm AS u_hossz_mm_21,
  p0_.u_magassag AS u_magassag_22,
  p0_.u_fugameret AS u_fugameret_23,
  p0_.u_anyagnorma AS u_anyagnorma_24,
  p0_.u_mennyiseg_korlat AS u_mennyiseg_korlat_25,
  p0_.tortmennyiseg AS tortmennyiseg_26,
  p0_.tortkiszereles AS tortkiszereles_27,
  p0_.teljesnev AS teljesnev_28,
  p0_.tipuskod AS tipuskod_29,
  p0_.sorozat AS sorozat_30,
  p0_.meretek AS meretek_31,
  p0_.dobozolas AS dobozolas_32,
  p0_.tomeg AS tomeg_33,
  p0_.raklap_tomeg AS raklap_tomeg_34,
  p0_.darabsuly AS darabsuly_35,
  p0_.raklap_darabszam AS raklap_darabszam_36,
  p0_.jellemzo AS jellemzo_37,
  p0_.seo_title AS seo_title_38,
  p0_.meta_desc AS meta_desc_39,
  p0_.cikkszam AS cikkszam_40,
  p0_.gyarto AS gyarto_41,
  p0_.anyagnorma AS anyagnorma_42,
  p0_.sarokelem_meret AS sarokelem_meret_43,
  p0_.m2_suly AS m2_suly_44,
  p0_.csuszasgatlas AS csuszasgatlas_45,
  p0_.kopasallosag AS kopasallosag_46,
  p0_.meret AS meret_47,
  p0_.price AS price_48,
  p0_.afa_price AS afa_price_49,
  p0_.t_mertekegys AS t_mertekegys_50,
  p0_.keszlet AS keszlet_51,
  p0_.def AS def_52,
  p0_.intra_id AS intra_id_53,
  p1_.sorrend AS sorrend_54,
  p2_.id AS id_55,
  p2_.sorrend AS sorrend_56,
  p2_.name AS name_57,
  p2_.active AS active_58,
  p2_.created_at AS created_at_59,
  p2_.updated_at AS updated_at_60,
  p2_.file AS file_61,
  p2_.icon AS icon_62,
  p2_.alias AS alias_63,
  p2_.raktaron AS raktaron_64,
  p2_.ujdonsag AS ujdonsag_65,
  p2_.kedvelt AS kedvelt_66,
  p2_.akcios AS akcios_67,
  p2_.icon_alt AS icon_alt_68,
  p2_.icon_title AS icon_title_69,
  p2_.label AS label_70,
  p2_.menu AS menu_71,
  p2_.megrendelo_tipus AS megrendelo_tipus_72,
  p2_.mertekegyseg AS mertekegyseg_73,
  p2_.webshop_enabled AS webshop_enabled_74,
  p2_.valtoszam AS valtoszam_75,
  p2_.u_hossz_mm AS u_hossz_mm_76,
  p2_.u_magassag AS u_magassag_77,
  p2_.u_fugameret AS u_fugameret_78,
  p2_.u_anyagnorma AS u_anyagnorma_79,
  p2_.u_mennyiseg_korlat AS u_mennyiseg_korlat_80,
  p2_.tortmennyiseg AS tortmennyiseg_81,
  p2_.tortkiszereles AS tortkiszereles_82,
  p2_.teljesnev AS teljesnev_83,
  p2_.tipuskod AS tipuskod_84,
  p2_.sorozat AS sorozat_85,
  p2_.meretek AS meretek_86,
  p2_.dobozolas AS dobozolas_87,
  p2_.tomeg AS tomeg_88,
  p2_.raklap_tomeg AS raklap_tomeg_89,
  p2_.darabsuly AS darabsuly_90,
  p2_.raklap_darabszam AS raklap_darabszam_91,
  p2_.jellemzo AS jellemzo_92,
  p2_.seo_title AS seo_title_93,
  p2_.meta_desc AS meta_desc_94,
  p2_.cikkszam AS cikkszam_95,
  p2_.gyarto AS gyarto_96,
  p2_.anyagnorma AS anyagnorma_97,
  p2_.sarokelem_meret AS sarokelem_meret_98,
  p2_.m2_suly AS m2_suly_99,
  p2_.csuszasgatlas AS csuszasgatlas_100,
  p2_.kopasallosag AS kopasallosag_101,
  p2_.meret AS meret_102,
  p2_.price AS price_103,
  p2_.afa_price AS afa_price_104,
  p2_.t_mertekegys AS t_mertekegys_105,
  p2_.keszlet AS keszlet_106,
  p2_.def AS def_107,
  p2_.intra_id AS intra_id_108,
  p0_.category_id AS category_id_109,
  p0_.default_fuga_id AS default_fuga_id_110,
  p0_.default_alapszin_id AS default_alapszin_id_111,
  p0_.default_ablaktok_id AS default_ablaktok_id_112,
  p0_.default_cserep_id AS default_cserep_id_113,
  p0_.default_house_id AS default_house_id_114,
  p0_.default_vakolat_id AS default_vakolat_id_115,
  p1_.product_source AS product_source_116,
  p1_.product_target AS product_target_117,
  p2_.category_id AS category_id_118,
  p2_.default_fuga_id AS default_fuga_id_119,
  p2_.default_alapszin_id AS default_alapszin_id_120,
  p2_.default_ablaktok_id AS default_ablaktok_id_121,
  p2_.default_cserep_id AS default_cserep_id_122,
  p2_.default_house_id AS default_house_id_123,
  p2_.default_vakolat_id AS default_vakolat_id_124
FROM
  product p0_
  LEFT JOIN product_product p1_ ON p0_.id = p1_.product_source
  LEFT JOIN product p2_ ON p1_.product_target = p2_.id
WHERE
  p0_.alias = ?
ORDER BY
  p1_.sorrend ASC

SELECT p0_.id AS id_0, p0_.sorrend AS sorrend_1, p0_.name AS name_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.file AS file_6, p0_.icon AS icon_7, p0_.alias AS alias_8, p0_.raktaron AS raktaron_9, p0_.ujdonsag AS ujdonsag_10, p0_.kedvelt AS kedvelt_11, p0_.akcios AS akcios_12, p0_.icon_alt AS icon_alt_13, p0_.icon_title AS icon_title_14, p0_.label AS label_15, p0_.menu AS menu_16, p0_.megrendelo_tipus AS megrendelo_tipus_17, p0_.mertekegyseg AS mertekegyseg_18, p0_.webshop_enabled AS webshop_enabled_19, p0_.valtoszam AS valtoszam_20, p0_.u_hossz_mm AS u_hossz_mm_21, p0_.u_magassag AS u_magassag_22, p0_.u_fugameret AS u_fugameret_23, p0_.u_anyagnorma AS u_anyagnorma_24, p0_.u_mennyiseg_korlat AS u_mennyiseg_korlat_25, p0_.tortmennyiseg AS tortmennyiseg_26, p0_.tortkiszereles AS tortkiszereles_27, p0_.teljesnev AS teljesnev_28, p0_.tipuskod AS tipuskod_29, p0_.sorozat AS sorozat_30, p0_.meretek AS meretek_31, p0_.dobozolas AS dobozolas_32, p0_.tomeg AS tomeg_33, p0_.raklap_tomeg AS raklap_tomeg_34, p0_.darabsuly AS darabsuly_35, p0_.raklap_darabszam AS raklap_darabszam_36, p0_.jellemzo AS jellemzo_37, p0_.seo_title AS seo_title_38, p0_.meta_desc AS meta_desc_39, p0_.cikkszam AS cikkszam_40, p0_.gyarto AS gyarto_41, p0_.anyagnorma AS anyagnorma_42, p0_.sarokelem_meret AS sarokelem_meret_43, p0_.m2_suly AS m2_suly_44, p0_.csuszasgatlas AS csuszasgatlas_45, p0_.kopasallosag AS kopasallosag_46, p0_.meret AS meret_47, p0_.price AS price_48, p0_.afa_price AS afa_price_49, p0_.t_mertekegys AS t_mertekegys_50, p0_.keszlet AS keszlet_51, p0_.def AS def_52, p0_.intra_id AS intra_id_53, p1_.sorrend AS sorrend_54, p2_.id AS id_55, p2_.sorrend AS sorrend_56, p2_.name AS name_57, p2_.active AS active_58, p2_.created_at AS created_at_59, p2_.updated_at AS updated_at_60, p2_.file AS file_61, p2_.icon AS icon_62, p2_.alias AS alias_63, p2_.raktaron AS raktaron_64, p2_.ujdonsag AS ujdonsag_65, p2_.kedvelt AS kedvelt_66, p2_.akcios AS akcios_67, p2_.icon_alt AS icon_alt_68, p2_.icon_title AS icon_title_69, p2_.label AS label_70, p2_.menu AS menu_71, p2_.megrendelo_tipus AS megrendelo_tipus_72, p2_.mertekegyseg AS mertekegyseg_73, p2_.webshop_enabled AS webshop_enabled_74, p2_.valtoszam AS valtoszam_75, p2_.u_hossz_mm AS u_hossz_mm_76, p2_.u_magassag AS u_magassag_77, p2_.u_fugameret AS u_fugameret_78, p2_.u_anyagnorma AS u_anyagnorma_79, p2_.u_mennyiseg_korlat AS u_mennyiseg_korlat_80, p2_.tortmennyiseg AS tortmennyiseg_81, p2_.tortkiszereles AS tortkiszereles_82, p2_.teljesnev AS teljesnev_83, p2_.tipuskod AS tipuskod_84, p2_.sorozat AS sorozat_85, p2_.meretek AS meretek_86, p2_.dobozolas AS dobozolas_87, p2_.tomeg AS tomeg_88, p2_.raklap_tomeg AS raklap_tomeg_89, p2_.darabsuly AS darabsuly_90, p2_.raklap_darabszam AS raklap_darabszam_91, p2_.jellemzo AS jellemzo_92, p2_.seo_title AS seo_title_93, p2_.meta_desc AS meta_desc_94, p2_.cikkszam AS cikkszam_95, p2_.gyarto AS gyarto_96, p2_.anyagnorma AS anyagnorma_97, p2_.sarokelem_meret AS sarokelem_meret_98, p2_.m2_suly AS m2_suly_99, p2_.csuszasgatlas AS csuszasgatlas_100, p2_.kopasallosag AS kopasallosag_101, p2_.meret AS meret_102, p2_.price AS price_103, p2_.afa_price AS afa_price_104, p2_.t_mertekegys AS t_mertekegys_105, p2_.keszlet AS keszlet_106, p2_.def AS def_107, p2_.intra_id AS intra_id_108, p0_.category_id AS category_id_109, p0_.default_fuga_id AS default_fuga_id_110, p0_.default_alapszin_id AS default_alapszin_id_111, p0_.default_ablaktok_id AS default_ablaktok_id_112, p0_.default_cserep_id AS default_cserep_id_113, p0_.default_house_id AS default_house_id_114, p0_.default_vakolat_id AS default_vakolat_id_115, p1_.product_source AS product_source_116, p1_.product_target AS product_target_117, p2_.category_id AS category_id_118, p2_.default_fuga_id AS default_fuga_id_119, p2_.default_alapszin_id AS default_alapszin_id_120, p2_.default_ablaktok_id AS default_ablaktok_id_121, p2_.default_cserep_id AS default_cserep_id_122, p2_.default_house_id AS default_house_id_123, p2_.default_vakolat_id AS default_vakolat_id_124 FROM product p0_ LEFT JOIN product_product p1_ ON p0_.id = p1_.product_source LEFT JOIN product p2_ ON p1_.product_target = p2_.id WHERE p0_.alias = 'rijswaard-homlokzati-lapok' ORDER BY p1_.sorrend ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.active AS active_4,
  t0.sorrend AS sorrend_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.icon_alt AS icon_alt_8,
  t0.icon_title AS icon_title_9,
  t0.icon AS icon_10,
  t0.image AS image_11,
  t0.image_alt AS image_alt_12,
  t0.image_title AS image_title_13,
  t0.article_image AS article_image_14,
  t0.article_image_alt AS article_image_alt_15,
  t0.article_image_title AS article_image_title_16,
  t0.description AS description_17,
  t0.short_description AS short_description_18,
  t0.featured AS featured_19,
  t0.seo_title AS seo_title_20,
  t0.meta_desc AS meta_desc_21,
  t0.beepites AS beepites_22,
  t0.parent_id AS parent_id_23
FROM
  product_category t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.active AS active_4, t0.sorrend AS sorrend_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icon_alt AS icon_alt_8, t0.icon_title AS icon_title_9, t0.icon AS icon_10, t0.image AS image_11, t0.image_alt AS image_alt_12, t0.image_title AS image_title_13, t0.article_image AS article_image_14, t0.article_image_alt AS article_image_alt_15, t0.article_image_title AS article_image_title_16, t0.description AS description_17, t0.short_description AS short_description_18, t0.featured AS featured_19, t0.seo_title AS seo_title_20, t0.meta_desc AS meta_desc_21, t0.beepites AS beepites_22, t0.parent_id AS parent_id_23 FROM product_category t0 WHERE t0.alias = 'rijswaard-homlokzati-lapok' LIMIT 1;

SELECT
  COUNT(c0_.id) AS sclr_0,
  COALESCE(
    SUM(c0_.total),
    0
  ) AS sclr_1
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = '9cf229a7085fd56abda08b617f5afd19';

SELECT
  p0_.id AS id_0
FROM
  product_category p0_
WHERE
  p0_.parent_id IN (?)

SELECT p0_.id AS id_0 FROM product_category p0_ WHERE p0_.parent_id IN (39);

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.active = ?
  AND p0_.meret = ?
  AND p0_.category_id IN (?)
ORDER BY
  p0_.id DESC

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ WHERE p0_.active = 1 AND p0_.meret = 0 AND p0_.category_id IN (39) ORDER BY p0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.sorrend AS sorrend_1,
  p0_.name AS name_2,
  p0_.active AS active_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.file AS file_6,
  p0_.icon AS icon_7,
  p0_.alias AS alias_8,
  p0_.raktaron AS raktaron_9,
  p0_.ujdonsag AS ujdonsag_10,
  p0_.kedvelt AS kedvelt_11,
  p0_.akcios AS akcios_12,
  p0_.icon_alt AS icon_alt_13,
  p0_.icon_title AS icon_title_14,
  p0_.label AS label_15,
  p0_.menu AS menu_16,
  p0_.megrendelo_tipus AS megrendelo_tipus_17,
  p0_.mertekegyseg AS mertekegyseg_18,
  p0_.webshop_enabled AS webshop_enabled_19,
  p0_.valtoszam AS valtoszam_20,
  p0_.u_hossz_mm AS u_hossz_mm_21,
  p0_.u_magassag AS u_magassag_22,
  p0_.u_fugameret AS u_fugameret_23,
  p0_.u_anyagnorma AS u_anyagnorma_24,
  p0_.u_mennyiseg_korlat AS u_mennyiseg_korlat_25,
  p0_.tortmennyiseg AS tortmennyiseg_26,
  p0_.tortkiszereles AS tortkiszereles_27,
  p0_.teljesnev AS teljesnev_28,
  p0_.tipuskod AS tipuskod_29,
  p0_.sorozat AS sorozat_30,
  p0_.meretek AS meretek_31,
  p0_.dobozolas AS dobozolas_32,
  p0_.tomeg AS tomeg_33,
  p0_.raklap_tomeg AS raklap_tomeg_34,
  p0_.darabsuly AS darabsuly_35,
  p0_.raklap_darabszam AS raklap_darabszam_36,
  p0_.jellemzo AS jellemzo_37,
  p0_.seo_title AS seo_title_38,
  p0_.meta_desc AS meta_desc_39,
  p0_.cikkszam AS cikkszam_40,
  p0_.gyarto AS gyarto_41,
  p0_.anyagnorma AS anyagnorma_42,
  p0_.sarokelem_meret AS sarokelem_meret_43,
  p0_.m2_suly AS m2_suly_44,
  p0_.csuszasgatlas AS csuszasgatlas_45,
  p0_.kopasallosag AS kopasallosag_46,
  p0_.meret AS meret_47,
  p0_.price AS price_48,
  p0_.afa_price AS afa_price_49,
  p0_.t_mertekegys AS t_mertekegys_50,
  p0_.keszlet AS keszlet_51,
  p0_.def AS def_52,
  p0_.intra_id AS intra_id_53,
  p1_.sorrend AS sorrend_54,
  p2_.id AS id_55,
  p2_.sorrend AS sorrend_56,
  p2_.name AS name_57,
  p2_.active AS active_58,
  p2_.created_at AS created_at_59,
  p2_.updated_at AS updated_at_60,
  p2_.file AS file_61,
  p2_.icon AS icon_62,
  p2_.alias AS alias_63,
  p2_.raktaron AS raktaron_64,
  p2_.ujdonsag AS ujdonsag_65,
  p2_.kedvelt AS kedvelt_66,
  p2_.akcios AS akcios_67,
  p2_.icon_alt AS icon_alt_68,
  p2_.icon_title AS icon_title_69,
  p2_.label AS label_70,
  p2_.menu AS menu_71,
  p2_.megrendelo_tipus AS megrendelo_tipus_72,
  p2_.mertekegyseg AS mertekegyseg_73,
  p2_.webshop_enabled AS webshop_enabled_74,
  p2_.valtoszam AS valtoszam_75,
  p2_.u_hossz_mm AS u_hossz_mm_76,
  p2_.u_magassag AS u_magassag_77,
  p2_.u_fugameret AS u_fugameret_78,
  p2_.u_anyagnorma AS u_anyagnorma_79,
  p2_.u_mennyiseg_korlat AS u_mennyiseg_korlat_80,
  p2_.tortmennyiseg AS tortmennyiseg_81,
  p2_.tortkiszereles AS tortkiszereles_82,
  p2_.teljesnev AS teljesnev_83,
  p2_.tipuskod AS tipuskod_84,
  p2_.sorozat AS sorozat_85,
  p2_.meretek AS meretek_86,
  p2_.dobozolas AS dobozolas_87,
  p2_.tomeg AS tomeg_88,
  p2_.raklap_tomeg AS raklap_tomeg_89,
  p2_.darabsuly AS darabsuly_90,
  p2_.raklap_darabszam AS raklap_darabszam_91,
  p2_.jellemzo AS jellemzo_92,
  p2_.seo_title AS seo_title_93,
  p2_.meta_desc AS meta_desc_94,
  p2_.cikkszam AS cikkszam_95,
  p2_.gyarto AS gyarto_96,
  p2_.anyagnorma AS anyagnorma_97,
  p2_.sarokelem_meret AS sarokelem_meret_98,
  p2_.m2_suly AS m2_suly_99,
  p2_.csuszasgatlas AS csuszasgatlas_100,
  p2_.kopasallosag AS kopasallosag_101,
  p2_.meret AS meret_102,
  p2_.price AS price_103,
  p2_.afa_price AS afa_price_104,
  p2_.t_mertekegys AS t_mertekegys_105,
  p2_.keszlet AS keszlet_106,
  p2_.def AS def_107,
  p2_.intra_id AS intra_id_108,
  p0_.category_id AS category_id_109,
  p0_.default_fuga_id AS default_fuga_id_110,
  p0_.default_alapszin_id AS default_alapszin_id_111,
  p0_.default_ablaktok_id AS default_ablaktok_id_112,
  p0_.default_cserep_id AS default_cserep_id_113,
  p0_.default_house_id AS default_house_id_114,
  p0_.default_vakolat_id AS default_vakolat_id_115,
  p1_.product_source AS product_source_116,
  p1_.product_target AS product_target_117,
  p2_.category_id AS category_id_118,
  p2_.default_fuga_id AS default_fuga_id_119,
  p2_.default_alapszin_id AS default_alapszin_id_120,
  p2_.default_ablaktok_id AS default_ablaktok_id_121,
  p2_.default_cserep_id AS default_cserep_id_122,
  p2_.default_house_id AS default_house_id_123,
  p2_.default_vakolat_id AS default_vakolat_id_124
FROM
  product p0_
  LEFT JOIN product_product p1_ ON p0_.id = p1_.product_source
  LEFT JOIN product p2_ ON p1_.product_target = p2_.id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p1_.sorrend ASC

SELECT p0_.id AS id_0, p0_.sorrend AS sorrend_1, p0_.name AS name_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.file AS file_6, p0_.icon AS icon_7, p0_.alias AS alias_8, p0_.raktaron AS raktaron_9, p0_.ujdonsag AS ujdonsag_10, p0_.kedvelt AS kedvelt_11, p0_.akcios AS akcios_12, p0_.icon_alt AS icon_alt_13, p0_.icon_title AS icon_title_14, p0_.label AS label_15, p0_.menu AS menu_16, p0_.megrendelo_tipus AS megrendelo_tipus_17, p0_.mertekegyseg AS mertekegyseg_18, p0_.webshop_enabled AS webshop_enabled_19, p0_.valtoszam AS valtoszam_20, p0_.u_hossz_mm AS u_hossz_mm_21, p0_.u_magassag AS u_magassag_22, p0_.u_fugameret AS u_fugameret_23, p0_.u_anyagnorma AS u_anyagnorma_24, p0_.u_mennyiseg_korlat AS u_mennyiseg_korlat_25, p0_.tortmennyiseg AS tortmennyiseg_26, p0_.tortkiszereles AS tortkiszereles_27, p0_.teljesnev AS teljesnev_28, p0_.tipuskod AS tipuskod_29, p0_.sorozat AS sorozat_30, p0_.meretek AS meretek_31, p0_.dobozolas AS dobozolas_32, p0_.tomeg AS tomeg_33, p0_.raklap_tomeg AS raklap_tomeg_34, p0_.darabsuly AS darabsuly_35, p0_.raklap_darabszam AS raklap_darabszam_36, p0_.jellemzo AS jellemzo_37, p0_.seo_title AS seo_title_38, p0_.meta_desc AS meta_desc_39, p0_.cikkszam AS cikkszam_40, p0_.gyarto AS gyarto_41, p0_.anyagnorma AS anyagnorma_42, p0_.sarokelem_meret AS sarokelem_meret_43, p0_.m2_suly AS m2_suly_44, p0_.csuszasgatlas AS csuszasgatlas_45, p0_.kopasallosag AS kopasallosag_46, p0_.meret AS meret_47, p0_.price AS price_48, p0_.afa_price AS afa_price_49, p0_.t_mertekegys AS t_mertekegys_50, p0_.keszlet AS keszlet_51, p0_.def AS def_52, p0_.intra_id AS intra_id_53, p1_.sorrend AS sorrend_54, p2_.id AS id_55, p2_.sorrend AS sorrend_56, p2_.name AS name_57, p2_.active AS active_58, p2_.created_at AS created_at_59, p2_.updated_at AS updated_at_60, p2_.file AS file_61, p2_.icon AS icon_62, p2_.alias AS alias_63, p2_.raktaron AS raktaron_64, p2_.ujdonsag AS ujdonsag_65, p2_.kedvelt AS kedvelt_66, p2_.akcios AS akcios_67, p2_.icon_alt AS icon_alt_68, p2_.icon_title AS icon_title_69, p2_.label AS label_70, p2_.menu AS menu_71, p2_.megrendelo_tipus AS megrendelo_tipus_72, p2_.mertekegyseg AS mertekegyseg_73, p2_.webshop_enabled AS webshop_enabled_74, p2_.valtoszam AS valtoszam_75, p2_.u_hossz_mm AS u_hossz_mm_76, p2_.u_magassag AS u_magassag_77, p2_.u_fugameret AS u_fugameret_78, p2_.u_anyagnorma AS u_anyagnorma_79, p2_.u_mennyiseg_korlat AS u_mennyiseg_korlat_80, p2_.tortmennyiseg AS tortmennyiseg_81, p2_.tortkiszereles AS tortkiszereles_82, p2_.teljesnev AS teljesnev_83, p2_.tipuskod AS tipuskod_84, p2_.sorozat AS sorozat_85, p2_.meretek AS meretek_86, p2_.dobozolas AS dobozolas_87, p2_.tomeg AS tomeg_88, p2_.raklap_tomeg AS raklap_tomeg_89, p2_.darabsuly AS darabsuly_90, p2_.raklap_darabszam AS raklap_darabszam_91, p2_.jellemzo AS jellemzo_92, p2_.seo_title AS seo_title_93, p2_.meta_desc AS meta_desc_94, p2_.cikkszam AS cikkszam_95, p2_.gyarto AS gyarto_96, p2_.anyagnorma AS anyagnorma_97, p2_.sarokelem_meret AS sarokelem_meret_98, p2_.m2_suly AS m2_suly_99, p2_.csuszasgatlas AS csuszasgatlas_100, p2_.kopasallosag AS kopasallosag_101, p2_.meret AS meret_102, p2_.price AS price_103, p2_.afa_price AS afa_price_104, p2_.t_mertekegys AS t_mertekegys_105, p2_.keszlet AS keszlet_106, p2_.def AS def_107, p2_.intra_id AS intra_id_108, p0_.category_id AS category_id_109, p0_.default_fuga_id AS default_fuga_id_110, p0_.default_alapszin_id AS default_alapszin_id_111, p0_.default_ablaktok_id AS default_ablaktok_id_112, p0_.default_cserep_id AS default_cserep_id_113, p0_.default_house_id AS default_house_id_114, p0_.default_vakolat_id AS default_vakolat_id_115, p1_.product_source AS product_source_116, p1_.product_target AS product_target_117, p2_.category_id AS category_id_118, p2_.default_fuga_id AS default_fuga_id_119, p2_.default_alapszin_id AS default_alapszin_id_120, p2_.default_ablaktok_id AS default_ablaktok_id_121, p2_.default_cserep_id AS default_cserep_id_122, p2_.default_house_id AS default_house_id_123, p2_.default_vakolat_id AS default_vakolat_id_124 FROM product p0_ LEFT JOIN product_product p1_ ON p0_.id = p1_.product_source LEFT JOIN product p2_ ON p1_.product_target = p2_.id WHERE p0_.id IN (2030, 1609, 1607, 1606, 1605, 1604, 1603, 1602) ORDER BY p1_.sorrend ASC;

SELECT
  p0_.id AS id_0,
  p0_.sorrend AS sorrend_1,
  p0_.name AS name_2,
  p0_.active AS active_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.file AS file_6,
  p0_.icon AS icon_7,
  p0_.alias AS alias_8,
  p0_.raktaron AS raktaron_9,
  p0_.ujdonsag AS ujdonsag_10,
  p0_.kedvelt AS kedvelt_11,
  p0_.akcios AS akcios_12,
  p0_.icon_alt AS icon_alt_13,
  p0_.icon_title AS icon_title_14,
  p0_.label AS label_15,
  p0_.menu AS menu_16,
  p0_.megrendelo_tipus AS megrendelo_tipus_17,
  p0_.mertekegyseg AS mertekegyseg_18,
  p0_.webshop_enabled AS webshop_enabled_19,
  p0_.valtoszam AS valtoszam_20,
  p0_.u_hossz_mm AS u_hossz_mm_21,
  p0_.u_magassag AS u_magassag_22,
  p0_.u_fugameret AS u_fugameret_23,
  p0_.u_anyagnorma AS u_anyagnorma_24,
  p0_.u_mennyiseg_korlat AS u_mennyiseg_korlat_25,
  p0_.tortmennyiseg AS tortmennyiseg_26,
  p0_.tortkiszereles AS tortkiszereles_27,
  p0_.teljesnev AS teljesnev_28,
  p0_.tipuskod AS tipuskod_29,
  p0_.sorozat AS sorozat_30,
  p0_.meretek AS meretek_31,
  p0_.dobozolas AS dobozolas_32,
  p0_.tomeg AS tomeg_33,
  p0_.raklap_tomeg AS raklap_tomeg_34,
  p0_.darabsuly AS darabsuly_35,
  p0_.raklap_darabszam AS raklap_darabszam_36,
  p0_.jellemzo AS jellemzo_37,
  p0_.seo_title AS seo_title_38,
  p0_.meta_desc AS meta_desc_39,
  p0_.cikkszam AS cikkszam_40,
  p0_.gyarto AS gyarto_41,
  p0_.anyagnorma AS anyagnorma_42,
  p0_.sarokelem_meret AS sarokelem_meret_43,
  p0_.m2_suly AS m2_suly_44,
  p0_.csuszasgatlas AS csuszasgatlas_45,
  p0_.kopasallosag AS kopasallosag_46,
  p0_.meret AS meret_47,
  p0_.price AS price_48,
  p0_.afa_price AS afa_price_49,
  p0_.t_mertekegys AS t_mertekegys_50,
  p0_.keszlet AS keszlet_51,
  p0_.def AS def_52,
  p0_.intra_id AS intra_id_53,
  p1_.sorrend AS sorrend_54,
  p2_.id AS id_55,
  p2_.sorrend AS sorrend_56,
  p2_.name AS name_57,
  p2_.active AS active_58,
  p2_.created_at AS created_at_59,
  p2_.updated_at AS updated_at_60,
  p2_.file AS file_61,
  p2_.icon AS icon_62,
  p2_.alias AS alias_63,
  p2_.raktaron AS raktaron_64,
  p2_.ujdonsag AS ujdonsag_65,
  p2_.kedvelt AS kedvelt_66,
  p2_.akcios AS akcios_67,
  p2_.icon_alt AS icon_alt_68,
  p2_.icon_title AS icon_title_69,
  p2_.label AS label_70,
  p2_.menu AS menu_71,
  p2_.megrendelo_tipus AS megrendelo_tipus_72,
  p2_.mertekegyseg AS mertekegyseg_73,
  p2_.webshop_enabled AS webshop_enabled_74,
  p2_.valtoszam AS valtoszam_75,
  p2_.u_hossz_mm AS u_hossz_mm_76,
  p2_.u_magassag AS u_magassag_77,
  p2_.u_fugameret AS u_fugameret_78,
  p2_.u_anyagnorma AS u_anyagnorma_79,
  p2_.u_mennyiseg_korlat AS u_mennyiseg_korlat_80,
  p2_.tortmennyiseg AS tortmennyiseg_81,
  p2_.tortkiszereles AS tortkiszereles_82,
  p2_.teljesnev AS teljesnev_83,
  p2_.tipuskod AS tipuskod_84,
  p2_.sorozat AS sorozat_85,
  p2_.meretek AS meretek_86,
  p2_.dobozolas AS dobozolas_87,
  p2_.tomeg AS tomeg_88,
  p2_.raklap_tomeg AS raklap_tomeg_89,
  p2_.darabsuly AS darabsuly_90,
  p2_.raklap_darabszam AS raklap_darabszam_91,
  p2_.jellemzo AS jellemzo_92,
  p2_.seo_title AS seo_title_93,
  p2_.meta_desc AS meta_desc_94,
  p2_.cikkszam AS cikkszam_95,
  p2_.gyarto AS gyarto_96,
  p2_.anyagnorma AS anyagnorma_97,
  p2_.sarokelem_meret AS sarokelem_meret_98,
  p2_.m2_suly AS m2_suly_99,
  p2_.csuszasgatlas AS csuszasgatlas_100,
  p2_.kopasallosag AS kopasallosag_101,
  p2_.meret AS meret_102,
  p2_.price AS price_103,
  p2_.afa_price AS afa_price_104,
  p2_.t_mertekegys AS t_mertekegys_105,
  p2_.keszlet AS keszlet_106,
  p2_.def AS def_107,
  p2_.intra_id AS intra_id_108,
  p0_.category_id AS category_id_109,
  p0_.default_fuga_id AS default_fuga_id_110,
  p0_.default_alapszin_id AS default_alapszin_id_111,
  p0_.default_ablaktok_id AS default_ablaktok_id_112,
  p0_.default_cserep_id AS default_cserep_id_113,
  p0_.default_house_id AS default_house_id_114,
  p0_.default_vakolat_id AS default_vakolat_id_115,
  p1_.product_source AS product_source_116,
  p1_.product_target AS product_target_117,
  p2_.category_id AS category_id_118,
  p2_.default_fuga_id AS default_fuga_id_119,
  p2_.default_alapszin_id AS default_alapszin_id_120,
  p2_.default_ablaktok_id AS default_ablaktok_id_121,
  p2_.default_cserep_id AS default_cserep_id_122,
  p2_.default_house_id AS default_house_id_123,
  p2_.default_vakolat_id AS default_vakolat_id_124
FROM
  product p0_
  INNER JOIN product_product p3_ ON p0_.id = p3_.product_source
  INNER JOIN product p4_ ON p3_.product_target = p4_.id
  LEFT JOIN product_product p1_ ON p0_.id = p1_.product_source
  LEFT JOIN product p2_ ON p1_.product_target = p2_.id
WHERE
  p4_.id = ?
ORDER BY
  p1_.sorrend ASC