GET https://poth-api.keszul.hu/burkolotegla/klinkertegla/feldhaus-klinkerteglak/?page=3&sorrend=nev-csokkeno

Response
200 OK
IP
216.73.217.131
Profiled on
Token
adccb3

Query Metrics

15 Database Queries
4 Different statements
49.62 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.98 ms 
SELECT COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = ?
Parameters: 
[
  "71323cd76a08804fce1f7396f4f6c444"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 4.64 ms 
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_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p1_.sorrend ASC
Parameters: 
[
  1300
  1299
  1298
  1297
  1296
  1294
  1293
  1292
]
View formatted query    View runnable query    Explain query    View query backtrace
3 3.90 ms 
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_ 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
Parameters: 
[
  1297
]
View formatted query    View runnable query    Explain query    View query backtrace
4 4.35 ms 
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_ 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
Parameters: 
[
  1296
]
View formatted query    View runnable query    Explain query    View query backtrace
5 3.70 ms 
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_ 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
Parameters: 
[
  1294
]
View formatted query    View runnable query    Explain query    View query backtrace
6 4.91 ms 
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_ 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
Parameters: 
[
  1293
]
View formatted query    View runnable query    Explain query    View query backtrace
7 4.63 ms 
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_ 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
Parameters: 
[
  1292
]
View formatted query    View runnable query    Explain query    View query backtrace

intralog connection

#▲ Time Info
1 1.02 ms 
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 = ?
Parameters: 
[
  "0"
  240526758513730
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.91 ms 
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 = ?
Parameters: 
[
  "0"
  240526758512631
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.76 ms 
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 = ?
Parameters: 
[
  "0"
  240526758515021
]
View formatted query    View runnable query    Explain query    View query backtrace
4 7.87 ms 
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 = ?
Parameters: 
[
  "0"
  240526758514643
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.14 ms 
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 = ?
Parameters: 
[
  "0"
  240526758514577
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.20 ms 
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 = ?
Parameters: 
[
  "0"
  240526758513853
]
View formatted query    View runnable query    Explain query    View query backtrace
7 8.32 ms 
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 = ?
Parameters: 
[
  "0"
  240526758513981
]
View formatted query    View runnable query    Explain query    View query backtrace
8 1.30 ms 
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 = ?
Parameters: 
[
  "0"
  240526758514823
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection
intralog doctrine.dbal.intralog_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\Product 8
App\Entity\ProductCategory 1

Entities Mapping

Class Mapping errors
App\Entity\Cart No errors.
App\Entity\Product No errors.
App\Entity\ProductSize No errors.
App\Entity\ProductCategory No errors.
App\Entity\Fuga No errors.
App\Entity\Alapszin No errors.
App\Entity\Ablaktok No errors.
App\Entity\Cserep No errors.
App\Entity\House No errors.
App\Entity\Vakolat No errors.
App\Entity\Felulet No errors.
App\Entity\Tarkasag No errors.
App\Entity\ProductGyik No errors.
App\Entity\Downloads No errors.
App\Entity\Icons No errors.
App\Entity\ProductGallery No errors.
App\Entity\ProductOtherSize No errors.
App\Entity\ProductCategoryGyik No errors.