Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
3.17 ms
(39.15%)
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.53 ms
(18.84%)
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:
[
  "about_us"
  1
  "2025-12-06 02:52:05"
  "2025-12-06 02:52:05"
]
1.00 ms
(12.38%)
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.67 ms
(8.25%)
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.67 ms
(8.25%)
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.57 ms
(7.07%)
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"
]
0.49 ms
(6.05%)
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
]

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