Query Metrics

11 Database Queries
6 Different statements
30.56 ms Query time
0 Invalid entities
61 Managed entities

Grouped Statements

Show all queries

Time Count Info
16.83 ms
(55.08%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.enabled AS enabled_3, p0_.in_menu AS in_menu_4, p0_.in_footer_menu AS in_footer_menu_5, p0_.menu_name AS menu_name_6, p0_.position AS position_7, p0_.redirect AS redirect_8, p0_.title AS title_9, p0_.content AS content_10, p0_.image AS image_11, p0_.keywords AS keywords_12, p0_.lead_image AS lead_image_13, p0_.lead AS lead_14, p0_.created AS created_15, p0_.updated AS updated_16, p0_.lead_home AS lead_home_17, p0_.lead_color AS lead_color_18, p0_.lead_icon AS lead_icon_19, p0_.lead_hidden AS lead_hidden_20, p0_.parent_id AS parent_id_21, p0_.template_id AS template_id_22 FROM page p0_ WHERE (p0_.enabled = 1 AND p0_.content LIKE ?) OR p0_.keywords LIKE ? OR p0_.title LIKE ? ORDER BY p0_.position DESC
Parameters:
[
  "%2025%"
  "%2025%"
  "%2025%"
]
8.02 ms
(26.25%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.title AS title_2, r0_.url AS url_3, r0_.content AS content_4, r0_.date AS date_5, r0_.enabled AS enabled_6 FROM resolution r0_ WHERE (r0_.enabled = 1 AND r0_.content LIKE ?) OR r0_.title LIKE ? OR r0_.name LIKE ?
Parameters:
[
  "%2025%"
  "%2025%"
  "%2025%"
]
3.43 ms
(11.21%)
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_ WHERE (t0_.enabled = 1 AND t0_.start_date <= ? AND (t0_.end_date >= ? OR t0_.end_date IS NULL) AND (t0_.private IS NULL OR t0_.private = 0) AND t0_.lead LIKE ?) OR t0_.keywords LIKE ? ORDER BY t0_.position DESC, t0_.start_date DESC
Parameters:
[
  "2025-05-13 08:12:06"
  "2025-05-13 08:12:06"
  "%2025%"
  "%2025%"
]
1.23 ms
(4.02%)
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.69 ms
(2.27%)
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.36 ms
(1.16%)
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
]

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 36
App\Entity\Settings 9
App\Entity\Resolution 8
App\Entity\Template 6
App\Entity\Tile 2

Entities Mapping

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