GET https://poth-api.keszul.hu/falburkolo-lap/homlokzati-klinkerlap/feldhaus-klinkerlapok/

Response
200 OK
IP
216.73.217.72
Profiled on
Token
2c5f67

Query Metrics

11 Database Queries
4 Different statements
20.76 ms Query time
0 Invalid entities
13 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 1.29 ms 
SELECT COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = ?
Parameters: 
[
  "33ea3e8158594354ff714dfcf51acbae"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 4.19 ms 
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
Parameters: 
[
  1
  0
  34
]
View formatted query    View runnable query    Explain query    View query backtrace
3 6.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, 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
Parameters: 
[
  2029
  2028
  2027
  2026
  2025
  2024
  2023
  2022
]
View formatted query    View runnable query    Explain query    View query backtrace

intralog connection

#▲ Time Info
1 1.45 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"
  240526758516315
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.96 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"
  240526758514355
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.95 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"
  240526758516295
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.69 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"
  240526758516294
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.88 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"
  240526758516296
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.22 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"
  240526758516307
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.36 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"
  240526758513872
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.86 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"
  240526758516284
]
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
App\Entity\Ablaktok 1
App\Entity\Cserep 1
App\Entity\House 1
App\Entity\Vakolat 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.