Symfony Profiler

Query Metrics

35 Database Queries

29 Different statements

21.89 ms Query time

1 Invalid entities

326 Managed entities

Queries


SELECT t0.szavak_id AS szavak_id_1, t0.szavak_hu AS szavak_hu_2, t0.szavak_code AS szavak_code_3, t0.szavak_date AS szavak_date_4 FROM evc_szavak t0
SELECT t0.acci_id AS acci_id_1, t0.acci_title AS acci_title_2, t0.acci_leir AS acci_leir_3, t0.acci_accid AS acci_accid_4, t0.acci_aktiv AS acci_aktiv_5, t0.acci_sorrend AS acci_sorrend_6 FROM evc_accordion_items t0
SELECT t0.galeria_kepek_id AS galeria_kepek_id_1, t0.galeria_kepek_kepnev AS galeria_kepek_kepnev_2, t0.galeria_kepek_galeria_id AS galeria_kepek_galeria_id_3, t0.galeria_kepek_sorrend AS galeria_kepek_sorrend_4, t0.galeria_kepek_felirat_hu AS galeria_kepek_felirat_hu_5, t0.galeria_kepek_alt_hu AS galeria_kepek_alt_hu_6, t0.galeria_kepek_kepnev_cropped AS galeria_kepek_kepnev_cropped_7, t0.fo_kep_cropped AS fo_kep_cropped_8, t0.al_kep_cropped AS al_kep_cropped_9 FROM evc_galeria_kepek t0
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.siteemail AS siteemail_5, t0.meta_desc_hu AS meta_desc_hu_6, t0.site_aktiv AS site_aktiv_7, t0.site_aktiv_uzenet AS site_aktiv_uzenet_8, t0.masolas_vedelem AS masolas_vedelem_9, t0.ev_logo_url AS ev_logo_url_10, t0.scroll_appointment AS scroll_appointment_11, t0.ev_logo_title AS ev_logo_title_12, t0.ev_img_title AS ev_img_title_13, t0.ev_img_alt AS ev_img_alt_14, t0.body AS body_15, t0.inactive_link AS inactive_link_16, t0.robots AS robots_17, t0.siteurl AS siteurl_18, t0.linkedin AS linkedin_19, t0.twitter AS twitter_20, t0.facebook AS facebook_21 FROM evc_config t0 WHERE t0.id = ? LIMIT 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
SELECT t0.menu_id AS menu_id_1, t0.menu_title_hu AS menu_title_hu_2, t0.menu_seo_title_hu AS menu_seo_title_hu_3, t0.label AS label_4, t0.menu_alias_hu AS menu_alias_hu_5, t0.menu_cikk_id AS menu_cikk_id_6, t0.menu_tipus AS menu_tipus_7, t0.menu_fajlnev AS menu_fajlnev_8, t0.menu_szulo_id AS menu_szulo_id_9, t0.menu_szint AS menu_szint_10, t0.menu_sorrend AS menu_sorrend_11, t0.menu_aktiv AS menu_aktiv_12, t0.menu_date AS menu_date_13, t0.menu_pozicio AS menu_pozicio_14, t0.meta_desc_hu AS meta_desc_hu_15, t0.menu_url_hu AS menu_url_hu_16, t0.menu_fajl_hu AS menu_fajl_hu_17, t0.menu_mod AS menu_mod_18 FROM evc_menu t0 WHERE t0.menu_aktiv = ? ORDER BY t0.menu_sorrend ASC
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_date AS modulok_date_4, t0.modulok_pozicio AS modulok_pozicio_5, t0.modulok_aktiv AS modulok_aktiv_6 FROM evc_modulok t0 WHERE t0.modulok_aktiv = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.featured AS featured_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM review t0 WHERE t0.active = ? ORDER BY t0.updated_at ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.alias AS alias_4, t0.icon AS icon_5, t0.appointment AS appointment_6, t0.active AS active_7, t0.content AS content_8, t0.featured AS featured_9, t0.weekend AS weekend_10, t0.email AS email_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category AS category_14, t0.sorrend AS sorrend_15 FROM doctor t0 WHERE t0.active = ? ORDER BY t0.sorrend ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.title AS title_4, t0.label AS label_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.active AS active_9, t0.featured AS featured_10, t0.sorrend AS sorrend_11, t0.meta_desc AS meta_desc_12, t0.icon AS icon_13, t0.icon_title AS icon_title_14, t0.icon_alt AS icon_alt_15, t0.home_icon AS home_icon_16, t0.list_icon AS list_icon_17, t0.parent_id AS parent_id_18 FROM product_category t0 WHERE t0.alias = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.title AS title_4, t0.alias AS alias_5, t0.sorrend AS sorrend_6, t0.comparisontables_type AS comparisontables_type_7, t0.active AS active_8, t0.featured AS featured_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.icon AS icon_12, t0.icon_alt AS icon_alt_13, t0.icon_title AS icon_title_14, t0.meta_desc AS meta_desc_15, t0.content AS content_16, t0.price_content AS price_content_17, t0.leir1 AS leir1_18, t0.leir2 AS leir2_19, t0.leir3 AS leir3_20, t0.leir4 AS leir4_21, t0.review_text AS review_text_22, t0.problem_top AS problem_top_23, t0.problem_bot AS problem_bot_24, t0.prep_top AS prep_top_25, t0.prep_bot AS prep_bot_26, t0.process_top AS process_top_27, t0.process_bot AS process_bot_28, t0.cta_top AS cta_top_29, t0.cta_bot AS cta_bot_30, t0.answer_top AS answer_top_31, t0.answer_bot AS answer_bot_32, t0.persona_top AS persona_top_33, t0.persona_bot AS persona_bot_34, t0.price_top AS price_top_35, t0.price_bot AS price_bot_36, t0.eat_top AS eat_top_37, t0.eat_bot AS eat_bot_38, t0.eatnot_top AS eatnot_top_39, t0.eatnot_bot AS eatnot_bot_40, t0.review_top AS review_top_41, t0.review_bot AS review_bot_42, t0.gyik_top AS gyik_top_43, t0.gyik_bot AS gyik_bot_44, t0.articles_top AS articles_top_45, t0.articles_bot AS articles_bot_46, t0.comparisontables_top AS comparisontables_top_47, t0.comparisontables_bot AS comparisontables_bot_48, t0.category_id AS category_id_49, t0.cta_id AS cta_id_50, t0.answer_id AS answer_id_51, t0.problem_id AS problem_id_52, t0.eat_id AS eat_id_53, t0.eatnot_id AS eatnot_id_54, t0.comparisontables_id AS comparisontables_id_55 FROM product t0 WHERE t0.alias = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.title AS title_4, t0.label AS label_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.active AS active_9, t0.featured AS featured_10, t0.sorrend AS sorrend_11, t0.meta_desc AS meta_desc_12, t0.icon AS icon_13, t0.icon_title AS icon_title_14, t0.icon_alt AS icon_alt_15, t0.home_icon AS home_icon_16, t0.list_icon AS list_icon_17, t0.parent_id AS parent_id_18 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.title AS title_4, t0.label AS label_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.active AS active_9, t0.featured AS featured_10, t0.sorrend AS sorrend_11, t0.meta_desc AS meta_desc_12, t0.icon AS icon_13, t0.icon_title AS icon_title_14, t0.icon_alt AS icon_alt_15, t0.home_icon AS home_icon_16, t0.list_icon AS list_icon_17, t0.parent_id AS parent_id_18 FROM product_category t0 WHERE t0.alias = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.title AS title_4, t0.alias AS alias_5, t0.sorrend AS sorrend_6, t0.comparisontables_type AS comparisontables_type_7, t0.active AS active_8, t0.featured AS featured_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.icon AS icon_12, t0.icon_alt AS icon_alt_13, t0.icon_title AS icon_title_14, t0.meta_desc AS meta_desc_15, t0.content AS content_16, t0.price_content AS price_content_17, t0.leir1 AS leir1_18, t0.leir2 AS leir2_19, t0.leir3 AS leir3_20, t0.leir4 AS leir4_21, t0.review_text AS review_text_22, t0.problem_top AS problem_top_23, t0.problem_bot AS problem_bot_24, t0.prep_top AS prep_top_25, t0.prep_bot AS prep_bot_26, t0.process_top AS process_top_27, t0.process_bot AS process_bot_28, t0.cta_top AS cta_top_29, t0.cta_bot AS cta_bot_30, t0.answer_top AS answer_top_31, t0.answer_bot AS answer_bot_32, t0.persona_top AS persona_top_33, t0.persona_bot AS persona_bot_34, t0.price_top AS price_top_35, t0.price_bot AS price_bot_36, t0.eat_top AS eat_top_37, t0.eat_bot AS eat_bot_38, t0.eatnot_top AS eatnot_top_39, t0.eatnot_bot AS eatnot_bot_40, t0.review_top AS review_top_41, t0.review_bot AS review_bot_42, t0.gyik_top AS gyik_top_43, t0.gyik_bot AS gyik_bot_44, t0.articles_top AS articles_top_45, t0.articles_bot AS articles_bot_46, t0.comparisontables_top AS comparisontables_top_47, t0.comparisontables_bot AS comparisontables_bot_48, t0.category_id AS category_id_49, t0.cta_id AS cta_id_50, t0.answer_id AS answer_id_51, t0.problem_id AS problem_id_52, t0.eat_id AS eat_id_53, t0.eatnot_id AS eatnot_id_54, t0.comparisontables_id AS comparisontables_id_55 FROM product t0 WHERE t0.alias = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.icon AS icon_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7 FROM persona t0 INNER JOIN product_persona ON t0.id = product_persona.persona_id WHERE product_persona.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.icon AS icon_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM process t0 INNER JOIN product_process ON t0.id = product_process.process_id WHERE product_process.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.icon AS icon_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM prep t0 INNER JOIN product_prep ON t0.id = product_prep.prep_id WHERE product_prep.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.label AS label_3, t0.content AS content_4, t0.icon AS icon_5, t0.appointment AS appointment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM problem t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.alias AS alias_4, t0.icon AS icon_5, t0.appointment AS appointment_6, t0.active AS active_7, t0.content AS content_8, t0.featured AS featured_9, t0.weekend AS weekend_10, t0.email AS email_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category AS category_14, t0.sorrend AS sorrend_15 FROM doctor t0 INNER JOIN product_doctor ON t0.id = product_doctor.doctor_id WHERE product_doctor.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.featured AS featured_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM review t0 INNER JOIN product_review ON t0.id = product_review.review_id WHERE product_review.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.meta_desc AS meta_desc_4, t0.seo_title AS seo_title_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM blog_category t0 WHERE t0.active = ?
SELECT t0.id AS id_1, t0.blog_cim_hu AS blog_cim_hu_2, t0.blog_alias_hu AS blog_alias_hu_3, t0.blog_bevezeto_hu AS blog_bevezeto_hu_4, t0.blog_szoveg_hu AS blog_szoveg_hu_5, t0.blog_date AS blog_date_6, t0.blog_datetime AS blog_datetime_7, t0.active AS active_8, t0.blog_seo_title_hu AS blog_seo_title_hu_9, t0.meta_desc_hu AS meta_desc_hu_10, t0.blog_kezdo_kep AS blog_kezdo_kep_11, t0.category_id AS category_id_12, t0.blog_sorrend AS blog_sorrend_13, t0.author_id AS author_id_14, t0.blog_kep_alt_hu AS blog_kep_alt_hu_15, t0.blog_kep_title_hu AS blog_kep_title_hu_16, t0.read_time AS read_time_17, t0.article_image AS article_image_18, t0.article_image_alt AS article_image_alt_19, t0.article_image_title AS article_image_title_20, t0.author_id AS author_id_21, t0.category_id AS category_id_22, t0.service_id AS service_id_23 FROM evc_blog t0 INNER JOIN product_evc_blog ON t0.id = product_evc_blog.evc_blog_id WHERE product_evc_blog.product_id = ?
SELECT t0.id AS id_1, t0.blog_cim_hu AS blog_cim_hu_2, t0.blog_alias_hu AS blog_alias_hu_3, t0.blog_bevezeto_hu AS blog_bevezeto_hu_4, t0.blog_szoveg_hu AS blog_szoveg_hu_5, t0.blog_date AS blog_date_6, t0.blog_datetime AS blog_datetime_7, t0.active AS active_8, t0.blog_seo_title_hu AS blog_seo_title_hu_9, t0.meta_desc_hu AS meta_desc_hu_10, t0.blog_kezdo_kep AS blog_kezdo_kep_11, t0.category_id AS category_id_12, t0.blog_sorrend AS blog_sorrend_13, t0.author_id AS author_id_14, t0.blog_kep_alt_hu AS blog_kep_alt_hu_15, t0.blog_kep_title_hu AS blog_kep_title_hu_16, t0.read_time AS read_time_17, t0.article_image AS article_image_18, t0.article_image_alt AS article_image_alt_19, t0.article_image_title AS article_image_title_20, t0.author_id AS author_id_21, t0.category_id AS category_id_22, t0.service_id AS service_id_23 FROM evc_blog t0 WHERE t0.active = ? ORDER BY t0.blog_datetime DESC LIMIT 3
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3 FROM evc_accordion t0 INNER JOIN product_evc_accordion ON t0.id = product_evc_accordion.evc_accordion_id WHERE product_evc_accordion.product_id = ?
SELECT t0.acci_id AS acci_id_1, t0.acci_title AS acci_title_2, t0.acci_leir AS acci_leir_3, t0.acci_accid AS acci_accid_4, t0.acci_aktiv AS acci_aktiv_5, t0.acci_sorrend AS acci_sorrend_6 FROM evc_accordion_items t0 WHERE t0.acci_accid = ?
SELECT t0.acci_id AS acci_id_1, t0.acci_title AS acci_title_2, t0.acci_leir AS acci_leir_3, t0.acci_accid AS acci_accid_4, t0.acci_aktiv AS acci_aktiv_5, t0.acci_sorrend AS acci_sorrend_6 FROM evc_accordion_items t0 WHERE t0.acci_accid = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.value AS value_4, t0.sale_value AS sale_value_5, t0.link AS link_6, t0.appointment AS appointment_7, t0.weekend AS weekend_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.featured AS featured_12, t0.category_id AS category_id_13 FROM price t0 INNER JOIN product_price ON t0.id = product_price.price_id WHERE product_price.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_price AS original_price_3, t0.current_price AS current_price_4, t0.cta_button_text AS cta_button_text_5, t0.cta_button_url AS cta_button_url_6, t0.active AS active_7, t0.display_order AS display_order_8, t0.comparison_table_id AS comparison_table_id_9 FROM lab_packages t0 WHERE t0.comparison_table_id = ? AND t0.active = ? ORDER BY t0.display_order ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.comparison_table_id AS comparison_table_id_4 FROM lab_test_categories t0 WHERE t0.comparison_table_id = ? ORDER BY t0.display_order ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.display_order AS display_order_4, t0.category_id AS category_id_5, t0.comparison_table_id AS comparison_table_id_6 FROM lab_tests t0 WHERE t0.category_id = ? ORDER BY t0.display_order ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.display_order AS display_order_4, t0.category_id AS category_id_5, t0.comparison_table_id AS comparison_table_id_6 FROM lab_tests t0 WHERE t0.category_id = ? ORDER BY t0.display_order ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.display_order AS display_order_4, t0.category_id AS category_id_5, t0.comparison_table_id AS comparison_table_id_6 FROM lab_tests t0 WHERE t0.category_id = ? ORDER BY t0.display_order ASC
SELECT package_id, test_id FROM package_tests
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.appointment AS appointment_4, t0.icon AS icon_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM cta t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.active AS active_4 FROM comparison_tables t0 WHERE t0.id = ?

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	80
App\Entity\EvcSzavak	62
App\Entity\EvcAccordionItems	58
App\Entity\EvcModulok	28
App\Entity\Doctor	26
App\Entity\BlogCategory	16
App\Entity\Review	15
App\Entity\LabTest	9
App\Entity\Persona	4
App\Entity\Prep	4
App\Entity\ProductCategory	3
App\Entity\EvcBlog	3
App\Entity\LabTestCategory	3
App\Entity\Product	2
App\Entity\EvcAccordion	2
App\Entity\EvcConfig	1
App\Entity\EvcShopConfig	1
App\Entity\CTA	1
App\Entity\Answer	1
App\Entity\Problem	1
App\Entity\Eat	1
App\Entity\EatNot	1
App\Entity\ComparisonTable	1
App\Entity\Price	1
App\Entity\PriceCategory	1
App\Entity\LabPackage	1

Entities Mapping

Class	Mapping errors
App\Entity\EvcSzavak	No errors.
App\Entity\EvcAccordionItems	No errors.
App\Entity\EvcGaleriaKepek	No errors.
App\Entity\EvcConfig	No errors.
App\Entity\EvcShopConfig	No errors.
App\Entity\EvcMenu	No errors.
App\Entity\EvcModulok	No errors.
App\Entity\Review	No errors.
App\Entity\Doctor	No errors.
App\Entity\EvcBlog	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Product	No errors.
App\Entity\CTA	No errors.
App\Entity\Answer	No errors.
App\Entity\Problem	No errors.
App\Entity\Eat	No errors.
App\Entity\EatNot	No errors.
App\Entity\ComparisonTable	No errors.
App\Entity\Persona	No errors.
App\Entity\Prep	No errors.
App\Entity\Process	No errors.
App\Entity\Price	No errors.
App\Entity\EvcAccordion	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\PriceCategory	No errors.
App\Entity\LabPackage	No errors.
App\Entity\LabTestCategory	The field App\Entity\LabTestCategory#labTests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LabTest#category does not contain the required 'inversedBy: "labTests"' attribute.
App\Entity\LabTest	No errors.

Symfony Profiler

GET https://medilum.keszul.hu/szolgaltatasok/vizsgalatok/laboratoriumi-vizsgalatok/vesefunkcio-laborvizsgalata

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping