Query Metrics

11 Database Queries
6 Different statements
3.04 ms Query time
0 Invalid entities
54 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.01 ms
(33.34%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.position DESC
Parameters:
[
  1
]
0.68 ms
(22.39%)
1
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.url AS url_2, t0_.enabled AS enabled_3, t0_.promo AS promo_4, t0_.position AS position_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.lead AS lead_8, t0_.title AS title_9, t0_.content AS content_10, t0_.content2 AS content2_11, t0_.image AS image_12, t0_.schedule_name AS schedule_name_13, t0_.schedule AS schedule_14, t0_.schedule2_name AS schedule2_name_15, t0_.schedule2 AS schedule2_16, t0_.lead_image AS lead_image_17, t0_.nolink AS nolink_18, t0_.lead_color AS lead_color_19, t0_.keywords AS keywords_20, t0_.css AS css_21, t0_.redirect AS redirect_22, t0_.created AS created_23, t0_.updated AS updated_24, t0_.homepage AS homepage_25, t0_.private AS private_26 FROM tile t0_ INNER JOIN tiles_categories t2_ ON t0_.id = t2_.tile_id INNER JOIN category c1_ ON c1_.id = t2_.category_id WHERE t0_.enabled = 1 AND t0_.start_date <= ? AND (t0_.end_date >= ? OR t0_.end_date IS NULL) AND c1_.slug = ? AND (t0_.private IS NULL OR t0_.private = 0) ORDER BY t0_.position DESC, t0_.start_date DESC LIMIT 10
Parameters:
[
  "2025-04-19 00:43:28"
  "2025-04-19 00:43:28"
  "oferty"
]
0.47 ms
(15.56%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM settings t0
Parameters:
[]
0.40 ms
(13.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.in_menu = ? AND t0.parent_id IS NULL AND t0.enabled = ? ORDER BY t0.position DESC
Parameters:
[
  1
  1
]
0.30 ms
(10.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "oferty"
]
0.17 ms
(5.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0
Parameters:
[]

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\Page 31
App\Entity\Settings 9
App\Entity\Category 6
App\Entity\Template 6
App\Entity\Tile 2

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Tile No errors.
App\Entity\Attachment No errors.
App\Entity\Tag No errors.
App\Entity\Settings No errors.
App\Entity\Page No errors.
App\Entity\Template No errors.