GET https://korin.keszul.hu/diszlecek-led-szalaghoz/mintakepek?sorrend=price_desc

Query Metrics

135 Database Queries
13 Different statements
843.84 ms Query time
0 Invalid entities
456 Managed entities

Grouped Statements

Show all queries

Time Count Info
756.12 ms
(89.60%)
118
SELECT t0.id AS id_1, t0.alias_hu AS alias_hu_2, t0.name_hu AS name_hu_3, t0.seo_title_hu AS seo_title_hu_4, t0.meta_desc_hu AS meta_desc_hu_5, t0.sorrend AS sorrend_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.active AS active_9, t0.kulcssoft_id AS kulcssoft_id_10, t0.parent_id AS parent_id_11 FROM evc_category t0 WHERE t0.parent_id = ? ORDER BY t0.sorrend ASC
Parameters:
[
  12316
]
35.75 ms
(4.24%)
1
SELECT e0_.id AS id_0, e0_.name_hu AS name_hu_1, e0_.seo_title_hu AS seo_title_hu_2, e0_.meta_desc_hu AS meta_desc_hu_3, e0_.leiras_hu AS leiras_hu_4, e0_.afa AS afa_5, e0_.active AS active_6, e0_.created_at AS created_at_7, e0_.modified_at AS modified_at_8, e0_.sorrend AS sorrend_9, e0_.alias_hu AS alias_hu_10, e0_.kiem AS kiem_11, e0_.type AS type_12, e0_.quantity_unit AS quantity_unit_13, e0_.min_order_quantity AS min_order_quantity_14, e0_.kulcssoft_id AS kulcssoft_id_15, e0_.product_code AS product_code_16, e0_.price_netto AS price_netto_17, e0_.price_brutto AS price_brutto_18, e0_.category_id AS category_id_19 FROM evc_prod e0_ WHERE e0_.active = 1 AND e0_.category_id IN (?) ORDER BY e0_.sorrend DESC
Parameters:
[
  2387002
]
22.10 ms
(2.62%)
1
SELECT t0.menu_id AS menu_id_1, t0.menu_title_hu AS menu_title_hu_2, t0.menu_title_en AS menu_title_en_3, t0.menu_seo_title_hu AS menu_seo_title_hu_4, t0.menu_seo_title_en AS menu_seo_title_en_5, t0.menu_alias_hu AS menu_alias_hu_6, t0.menu_alias_en AS menu_alias_en_7, t0.menu_cikk_id AS menu_cikk_id_8, t0.menu_tipus AS menu_tipus_9, t0.menu_fajlnev AS menu_fajlnev_10, t0.menu_szulo_id AS menu_szulo_id_11, t0.menu_szint AS menu_szint_12, t0.menu_sorrend AS menu_sorrend_13, t0.menu_aktiv AS menu_aktiv_14, t0.menu_date AS menu_date_15, t0.menu_pozicio AS menu_pozicio_16, t0.meta_desc_hu AS meta_desc_hu_17, t0.meta_desc_en AS meta_desc_en_18, t0.menu_url_hu AS menu_url_hu_19, t0.menu_url_en AS menu_url_en_20, t0.menu_fajl_hu AS menu_fajl_hu_21, t0.menu_fajl_en AS menu_fajl_en_22, t0.menu_mod AS menu_mod_23 FROM evc_menu t0 WHERE t0.menu_aktiv = ? ORDER BY t0.menu_sorrend ASC
Parameters:
[
  1
]
15.64 ms
(1.85%)
5
SELECT t0.id AS id_1, t0.alias_hu AS alias_hu_2, t0.name_hu AS name_hu_3, t0.seo_title_hu AS seo_title_hu_4, t0.meta_desc_hu AS meta_desc_hu_5, t0.sorrend AS sorrend_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.active AS active_9, t0.kulcssoft_id AS kulcssoft_id_10, t0.parent_id AS parent_id_11 FROM evc_category t0 WHERE t0.alias_hu = ? LIMIT 1
Parameters:
[
  "diszlecek-led-szalaghoz"
]
3.33 ms
(0.39%)
1
SELECT t0.id AS id_1, t0.name_hu AS name_hu_2, t0.seo_title_hu AS seo_title_hu_3, t0.meta_desc_hu AS meta_desc_hu_4, t0.leiras_hu AS leiras_hu_5, t0.afa AS afa_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.modified_at AS modified_at_9, t0.sorrend AS sorrend_10, t0.alias_hu AS alias_hu_11, t0.kiem AS kiem_12, t0.type AS type_13, t0.quantity_unit AS quantity_unit_14, t0.min_order_quantity AS min_order_quantity_15, t0.kulcssoft_id AS kulcssoft_id_16, t0.product_code AS product_code_17, t0.price_netto AS price_netto_18, t0.price_brutto AS price_brutto_19, t0.category_id AS category_id_20 FROM evc_prod t0 WHERE t0.alias_hu = ? LIMIT 1
Parameters:
[
  "mintakepek"
]
2.21 ms
(0.26%)
1
SELECT t0.modulok_id AS modulok_id_1, t0.modulok_nev AS modulok_nev_2, t0.modulok_szoveg_hu AS modulok_szoveg_hu_3, t0.modulok_szoveg_en AS modulok_szoveg_en_4, t0.modulok_date AS modulok_date_5, t0.modulok_pozicio AS modulok_pozicio_6, t0.modulok_aktiv AS modulok_aktiv_7 FROM evc_modulok t0 WHERE t0.modulok_aktiv = ?
Parameters:
[
  1
]
1.83 ms
(0.22%)
2
SELECT t0.id AS id_1, t0.alias_hu AS alias_hu_2, t0.name_hu AS name_hu_3, t0.seo_title_hu AS seo_title_hu_4, t0.meta_desc_hu AS meta_desc_hu_5, t0.sorrend AS sorrend_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.active AS active_9, t0.kulcssoft_id AS kulcssoft_id_10, t0.parent_id AS parent_id_11 FROM evc_category t0 WHERE t0.alias_hu = ?
Parameters:
[
  "diszlecek-led-szalaghoz"
]
1.52 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.shop_tel AS shop_tel_2, t0.shop_utca_hsz AS shop_utca_hsz_3, t0.shop_varos AS shop_varos_4, t0.shop_irsz AS shop_irsz_5 FROM evc_shop_config t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
1.30 ms
(0.15%)
1
SELECT t0.id AS id_1, t0.siteadmin_pass AS siteadmin_pass_2, t0.sitename AS sitename_3, t0.sitename_seo_hu AS sitename_seo_hu_4, t0.sitename_seo_en AS sitename_seo_en_5, t0.siteemail AS siteemail_6, t0.meta_desc_hu AS meta_desc_hu_7, t0.meta_desc_en AS meta_desc_en_8, t0.site_aktiv AS site_aktiv_9, t0.site_aktiv_uzenet AS site_aktiv_uzenet_10, t0.masolas_vedelem AS masolas_vedelem_11, t0.ev_logo_url AS ev_logo_url_12, t0.ev_logo_title AS ev_logo_title_13, t0.ev_img_title AS ev_img_title_14, t0.ev_img_alt AS ev_img_alt_15, t0.body AS body_16, t0.inactive_link AS inactive_link_17, t0.robots AS robots_18, t0.siteurl AS siteurl_19, t0.insta AS insta_20, t0.tiktok AS tiktok_21, t0.facebook AS facebook_22 FROM evc_config t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
1.25 ms
(0.15%)
1
SELECT t0.szavak_id AS szavak_id_1, t0.szavak_hu AS szavak_hu_2, t0.szavak_en AS szavak_en_3, t0.szavak_code AS szavak_code_4, t0.szavak_date AS szavak_date_5 FROM evc_szavak t0
Parameters:
[]
1.21 ms
(0.14%)
1
SELECT t0.id AS id_1, t0.alias_hu AS alias_hu_2, t0.name_hu AS name_hu_3, t0.seo_title_hu AS seo_title_hu_4, t0.meta_desc_hu AS meta_desc_hu_5, t0.sorrend AS sorrend_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.active AS active_9, t0.kulcssoft_id AS kulcssoft_id_10, t0.parent_id AS parent_id_11 FROM evc_category t0 WHERE t0.active = ? AND t0.parent_id = ? ORDER BY t0.sorrend ASC
Parameters:
[
  1
  0
]
0.83 ms
(0.10%)
1
SELECT t0.langs_id AS langs_id_1, t0.langs_name AS langs_name_2, t0.langs_leiras AS langs_leiras_3, t0.langs_default AS langs_default_4, t0.langs_aktiv AS langs_aktiv_5, t0.langs_code AS langs_code_6, t0.langs_flag AS langs_flag_7, t0.langs_sort AS langs_sort_8 FROM evc_langs t0 WHERE t0.langs_aktiv = ?
Parameters:
[
  1
]
0.76 ms
(0.09%)
1
SELECT t0.id AS id_1, t0.alias_hu AS alias_hu_2, t0.name_hu AS name_hu_3, t0.seo_title_hu AS seo_title_hu_4, t0.meta_desc_hu AS meta_desc_hu_5, t0.sorrend AS sorrend_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.active AS active_9, t0.kulcssoft_id AS kulcssoft_id_10, t0.parent_id AS parent_id_11 FROM evc_category t0 WHERE t0.parent_id = ? AND t0.active = ?
Parameters:
[
  2387002
  1
]

Database Connections

Name Service
default doctrine.dbal.default_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\EvcMenu 167
App\Entity\EvcSzavak 162
App\Entity\EvcCategory 119
App\Entity\EvcModulok 5
App\Entity\EvcConfig 1
App\Entity\EvcShopConfig 1
App\Entity\EvcLangs 1

Entities Mapping

Class Mapping errors
App\Entity\EvcConfig No errors.
App\Entity\EvcShopConfig No errors.
App\Entity\EvcMenu No errors.
App\Entity\EvcSzavak No errors.
App\Entity\EvcProd No errors.
App\Entity\EvcCategory No errors.
App\Entity\EvcLangs No errors.
App\Entity\EvcModulok No errors.