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,
  p0_.teglakotes AS teglakotes_54,
  p0_.eltolas AS eltolas_55,
  p0_.fugameret AS fugameret_56,
  p0_.oszlop AS oszlop_57,
  p0_.sor AS sor_58,
  p0_.arnyek AS arnyek_59,
  p0_.arnyek_szelesseg AS arnyek_szelesseg_60,
  p1_.sorrend AS sorrend_61,
  p2_.id AS id_62,
  p2_.sorrend AS sorrend_63,
  p2_.name AS name_64,
  p2_.active AS active_65,
  p2_.created_at AS created_at_66,
  p2_.updated_at AS updated_at_67,
  p2_.file AS file_68,
  p2_.icon AS icon_69,
  p2_.alias AS alias_70,
  p2_.raktaron AS raktaron_71,
  p2_.ujdonsag AS ujdonsag_72,
  p2_.kedvelt AS kedvelt_73,
  p2_.akcios AS akcios_74,
  p2_.icon_alt AS icon_alt_75,
  p2_.icon_title AS icon_title_76,
  p2_.label AS label_77,
  p2_.menu AS menu_78,
  p2_.megrendelo_tipus AS megrendelo_tipus_79,
  p2_.mertekegyseg AS mertekegyseg_80,
  p2_.webshop_enabled AS webshop_enabled_81,
  p2_.valtoszam AS valtoszam_82,
  p2_.u_hossz_mm AS u_hossz_mm_83,
  p2_.u_magassag AS u_magassag_84,
  p2_.u_fugameret AS u_fugameret_85,
  p2_.u_anyagnorma AS u_anyagnorma_86,
  p2_.u_mennyiseg_korlat AS u_mennyiseg_korlat_87,
  p2_.tortmennyiseg AS tortmennyiseg_88,
  p2_.tortkiszereles AS tortkiszereles_89,
  p2_.teljesnev AS teljesnev_90,
  p2_.tipuskod AS tipuskod_91,
  p2_.sorozat AS sorozat_92,
  p2_.meretek AS meretek_93,
  p2_.dobozolas AS dobozolas_94,
  p2_.tomeg AS tomeg_95,
  p2_.raklap_tomeg AS raklap_tomeg_96,
  p2_.darabsuly AS darabsuly_97,
  p2_.raklap_darabszam AS raklap_darabszam_98,
  p2_.jellemzo AS jellemzo_99,
  p2_.seo_title AS seo_title_100,
  p2_.meta_desc AS meta_desc_101,
  p2_.cikkszam AS cikkszam_102,
  p2_.gyarto AS gyarto_103,
  p2_.anyagnorma AS anyagnorma_104,
  p2_.sarokelem_meret AS sarokelem_meret_105,
  p2_.m2_suly AS m2_suly_106,
  p2_.csuszasgatlas AS csuszasgatlas_107,
  p2_.kopasallosag AS kopasallosag_108,
  p2_.meret AS meret_109,
  p2_.price AS price_110,
  p2_.afa_price AS afa_price_111,
  p2_.t_mertekegys AS t_mertekegys_112,
  p2_.keszlet AS keszlet_113,
  p2_.def AS def_114,
  p2_.intra_id AS intra_id_115,
  p2_.teglakotes AS teglakotes_116,
  p2_.eltolas AS eltolas_117,
  p2_.fugameret AS fugameret_118,
  p2_.oszlop AS oszlop_119,
  p2_.sor AS sor_120,
  p2_.arnyek AS arnyek_121,
  p2_.arnyek_szelesseg AS arnyek_szelesseg_122,
  p0_.category_id AS category_id_123,
  p0_.default_fuga_id AS default_fuga_id_124,
  p0_.default_alapszin_id AS default_alapszin_id_125,
  p0_.default_ablaktok_id AS default_ablaktok_id_126,
  p0_.default_cserep_id AS default_cserep_id_127,
  p0_.default_house_id AS default_house_id_128,
  p0_.default_vakolat_id AS default_vakolat_id_129,
  p1_.product_source AS product_source_130,
  p1_.product_target AS product_target_131,
  p2_.category_id AS category_id_132,
  p2_.default_fuga_id AS default_fuga_id_133,
  p2_.default_alapszin_id AS default_alapszin_id_134,
  p2_.default_ablaktok_id AS default_ablaktok_id_135,
  p2_.default_cserep_id AS default_cserep_id_136,
  p2_.default_house_id AS default_house_id_137,
  p2_.default_vakolat_id AS default_vakolat_id_138
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, p0_.teglakotes AS teglakotes_54, p0_.eltolas AS eltolas_55, p0_.fugameret AS fugameret_56, p0_.oszlop AS oszlop_57, p0_.sor AS sor_58, p0_.arnyek AS arnyek_59, p0_.arnyek_szelesseg AS arnyek_szelesseg_60, p1_.sorrend AS sorrend_61, p2_.id AS id_62, p2_.sorrend AS sorrend_63, p2_.name AS name_64, p2_.active AS active_65, p2_.created_at AS created_at_66, p2_.updated_at AS updated_at_67, p2_.file AS file_68, p2_.icon AS icon_69, p2_.alias AS alias_70, p2_.raktaron AS raktaron_71, p2_.ujdonsag AS ujdonsag_72, p2_.kedvelt AS kedvelt_73, p2_.akcios AS akcios_74, p2_.icon_alt AS icon_alt_75, p2_.icon_title AS icon_title_76, p2_.label AS label_77, p2_.menu AS menu_78, p2_.megrendelo_tipus AS megrendelo_tipus_79, p2_.mertekegyseg AS mertekegyseg_80, p2_.webshop_enabled AS webshop_enabled_81, p2_.valtoszam AS valtoszam_82, p2_.u_hossz_mm AS u_hossz_mm_83, p2_.u_magassag AS u_magassag_84, p2_.u_fugameret AS u_fugameret_85, p2_.u_anyagnorma AS u_anyagnorma_86, p2_.u_mennyiseg_korlat AS u_mennyiseg_korlat_87, p2_.tortmennyiseg AS tortmennyiseg_88, p2_.tortkiszereles AS tortkiszereles_89, p2_.teljesnev AS teljesnev_90, p2_.tipuskod AS tipuskod_91, p2_.sorozat AS sorozat_92, p2_.meretek AS meretek_93, p2_.dobozolas AS dobozolas_94, p2_.tomeg AS tomeg_95, p2_.raklap_tomeg AS raklap_tomeg_96, p2_.darabsuly AS darabsuly_97, p2_.raklap_darabszam AS raklap_darabszam_98, p2_.jellemzo AS jellemzo_99, p2_.seo_title AS seo_title_100, p2_.meta_desc AS meta_desc_101, p2_.cikkszam AS cikkszam_102, p2_.gyarto AS gyarto_103, p2_.anyagnorma AS anyagnorma_104, p2_.sarokelem_meret AS sarokelem_meret_105, p2_.m2_suly AS m2_suly_106, p2_.csuszasgatlas AS csuszasgatlas_107, p2_.kopasallosag AS kopasallosag_108, p2_.meret AS meret_109, p2_.price AS price_110, p2_.afa_price AS afa_price_111, p2_.t_mertekegys AS t_mertekegys_112, p2_.keszlet AS keszlet_113, p2_.def AS def_114, p2_.intra_id AS intra_id_115, p2_.teglakotes AS teglakotes_116, p2_.eltolas AS eltolas_117, p2_.fugameret AS fugameret_118, p2_.oszlop AS oszlop_119, p2_.sor AS sor_120, p2_.arnyek AS arnyek_121, p2_.arnyek_szelesseg AS arnyek_szelesseg_122, p0_.category_id AS category_id_123, p0_.default_fuga_id AS default_fuga_id_124, p0_.default_alapszin_id AS default_alapszin_id_125, p0_.default_ablaktok_id AS default_ablaktok_id_126, p0_.default_cserep_id AS default_cserep_id_127, p0_.default_house_id AS default_house_id_128, p0_.default_vakolat_id AS default_vakolat_id_129, p1_.product_source AS product_source_130, p1_.product_target AS product_target_131, p2_.category_id AS category_id_132, p2_.default_fuga_id AS default_fuga_id_133, p2_.default_alapszin_id AS default_alapszin_id_134, p2_.default_ablaktok_id AS default_ablaktok_id_135, p2_.default_cserep_id AS default_cserep_id_136, p2_.default_house_id AS default_house_id_137, p2_.default_vakolat_id AS default_vakolat_id_138 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 = 'oranje-genuanceerd-burkolotegla' ORDER BY p1_.sorrend ASC;

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 = '0520dcb03862d6ef54e533fa11f301b5';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.sorrend AS sorrend_5,
  t0.active AS active_6,
  t0.product_id AS product_id_7
FROM
  product_other_size t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.sorrend AS sorrend_5, t0.active AS active_6, t0.product_id AS product_id_7 FROM product_other_size t0 WHERE t0.product_id = 1476;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.alt AS alt_4,
  t0.file AS file_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.sorrend AS sorrend_9,
  t0.product_id AS product_id_10
FROM
  downloads t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.alt AS alt_4, t0.file AS file_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.sorrend AS sorrend_9, t0.product_id AS product_id_10 FROM downloads t0 WHERE t0.product_id = 1476;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.file AS file_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.sorrend AS sorrend_7,
  t0.alt AS alt_8,
  t0.title AS title_9,
  t0.product_id AS product_id_10
FROM
  icons t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sorrend AS sorrend_7, t0.alt AS alt_8, t0.title AS title_9, t0.product_id AS product_id_10 FROM icons t0 WHERE t0.product_id = 1476;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.sorrend AS sorrend_7,
  t0.product_id AS product_id_8
FROM
  product_gyik t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sorrend AS sorrend_7, t0.product_id AS product_id_8 FROM product_gyik t0 WHERE t0.product_id = 1476;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.alt AS alt_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.sorrend AS sorrend_8,
  t0.parent_id AS parent_id_9
FROM
  product_gallery t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.alt AS alt_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.sorrend AS sorrend_8, t0.parent_id AS parent_id_9 FROM product_gallery t0 WHERE t0.parent_id = 1476;

SELECT
  ARAK.AR AS ar,
  ARAK.BRUTTO_AR AS brutto_ar,
  COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM
  ANYAGOK
  LEFT JOIN ARAK ON ANYAGOK.ID = ARAK.ANYAG
  AND ARAK.ARLISTA = ?
  LEFT JOIN KESZLETEK ON ANYAGOK.ID = KESZLETEK.ID
WHERE
  ANYAGOK.ID = ?

SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = '0'
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = 240526758514807;