Query Metrics

16 Database Queries
7 Different statements
6.31 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.promo AS promo_5, t0.position AS position_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.lead AS lead_9, t0.title AS title_10, t0.content AS content_11, t0.content2 AS content2_12, t0.image AS image_13, t0.schedule_name AS schedule_name_14, t0.schedule AS schedule_15, t0.schedule2_name AS schedule2_name_16, t0.schedule2 AS schedule2_17, t0.lead_image AS lead_image_18, t0.nolink AS nolink_19, t0.lead_color AS lead_color_20, t0.keywords AS keywords_21, t0.css AS css_22, t0.redirect AS redirect_23, t0.created AS created_24, t0.updated AS updated_25, t0.homepage AS homepage_26 FROM tile t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "xi-ogolnopolskie-mistrzostwa-w-strzelectwie-sportowym-o-puchar-przewodniczacego-rady-moiib"
]
2 0.27 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:
[]
3 0.18 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:
[]
4 0.19 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:
[]
5 0.33 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
]
6 0.30 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
]
7 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.parent_id = ? ORDER BY t0.position DESC
Parameters:
[
  7
]
8 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:
[
  18
]
9 0.27 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
]
10 0.58 ms
SELECT t0.id AS id_1, t0.document AS document_2, t0.info AS info_3, t0.created AS created_4, t0.updated AS updated_5, t0.page_id AS page_id_6, t0.tile_id AS tile_id_7, t0.gallery_id AS gallery_id_8 FROM attachment t0 WHERE t0.tile_id = ?
Parameters:
[
  18
]
11 0.99 ms
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 INNER JOIN tiles_categories ON t0.id = tiles_categories.category_id WHERE tiles_categories.tile_id = ?
Parameters:
[
  18
]
12 0.18 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:
[]
13 0.18 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:
[]
14 0.36 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_footer_menu = ? AND t0.enabled = ? ORDER BY t0.position DESC LIMIT 15
Parameters:
[
  1
  1
]
15 0.13 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:
[]
16 0.13 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:
[]

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\Tile No errors.
App\Entity\Category No errors.
App\Entity\Attachment No errors.
App\Entity\Settings No errors.
App\Entity\Page No errors.
App\Entity\Template No errors.
App\Entity\Gallery No errors.
App\Entity\Resolution No errors.
App\Entity\Video No errors.
App\Entity\Specialist No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Training No errors.
App\Entity\Slide No errors.
App\Entity\User No errors.
Vich\UploaderBundle\Entity\File No errors.