Query Metrics

12 Database Queries
7 Different statements
3.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 ms
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.url = ? LIMIT 1
Parameters:
[
  "filmy"
]
2 0.31 ms
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 = ? AND t0.enabled = ? ORDER BY t0.position DESC
Parameters:
[
  22
  1
]
3 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.filename AS filename_4, t0.code AS code_5 FROM template t0 WHERE t0.id = ?
Parameters:
[
  6
]
4 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.url AS url_4, t0.source AS source_5 FROM video t0 WHERE t0.enabled = ? ORDER BY t0.id DESC
Parameters:
[
  1
]
5 0.23 ms
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:
[]
6 0.11 ms
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:
[]
7 0.10 ms
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:
[]
8 0.29 ms
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
]
9 0.21 ms
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
]
10 0.25 ms
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:
[
  7
]
11 0.22 ms
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:
[
  18
]
12 0.20 ms
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:
[
  76
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\Template No errors.
App\Entity\Attachment No errors.
App\Entity\Video No errors.
App\Entity\Settings No errors.