Query Metrics

16 Database Queries
7 Different statements
9.55 ms Query time
0 Invalid entities
20 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.39 ms
(35.49%)
8
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.category_url AS category_url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.frontend_description AS frontend_description_6, t0.meta_h1 AS meta_h1_7, t0.meta_h2 AS meta_h2_8, t0.custom_category_id AS custom_category_id_9, t0.lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0.custom_category_id = ?
Parameters:
[
  1
]
1.96 ms
(20.47%)
2
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.text AS text_2, s0_.exa_color AS exa_color_3, s0_.font_color AS font_color_4, s0_.valid_from AS valid_from_5, s0_.valid_to AS valid_to_6 FROM static_texts s0_ INNER JOIN static_text_langs s1_ ON (s0_.id = s1_.static_text_id) WHERE s0_.type = ? AND s1_.lang_id = ? AND (s0_.valid_from IS NULL OR s0_.valid_from <= ?) AND (s0_.valid_to IS NULL OR s0_.valid_to >= ?) ORDER BY s0_.id DESC LIMIT 1
Parameters:
[
  "contacts"
  1
  "2025-12-06 02:50:48"
  "2025-12-06 02:50:48"
]
1.03 ms
(10.79%)
2
SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c0_.parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_.is_online = 1 AND c0_.show_in_menu = 1 AND c0_.parent_id = ? ORDER BY c0_.ordine ASC
Parameters:
[
  1
]
0.94 ms
(9.87%)
1
SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.81 ms
(8.43%)
1
SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c0_.parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_.is_online = 1 AND c0_.show_in_menu = 1 AND c0_.parent_id IS NULL ORDER BY c0_.ordine ASC
Parameters:
[]
0.75 ms
(7.86%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.label AS label_4 FROM currencies t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.68 ms
(7.08%)
1
SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.lang = ? LIMIT 1
Parameters:
[
  "it"
]

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\CustomCategory 8
App\Entity\CustomCategoriesLang 8
App\Entity\StaticTexts 2
App\Entity\Language 1
App\Entity\Currencies 1