GET https://www-tst.lna.lv/en/page

Query Metrics

8 Database Queries
4 Different statements
11.32 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters:
[
  "en"
  0
  1
]
2 1.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters:
[
  "en"
  2
  1
]
3 1.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters:
[
  "en"
  3
  1
]
4 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters:
[
  "en"
  4
  1
]
5 0.59 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters:
[
  "en"
  7
  1
]
6 1.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.content AS content_4, t0.status AS status_5, t0.created AS created_6, t0.modified AS modified_7 FROM page t0 WHERE t0.lang = ? AND t0.id = ? LIMIT 1
Parameters:
[
  "en"
  0
]
7 0.94 ms
SELECT 
            l.*,
            m.content_id
          FROM link l 
          LEFT JOIN menu m ON m.id=l.navigation_id 
          WHERE l.lang='en' 
          ORDER BY l.sort_index ASC
Parameters:
[]
8 1.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.modified AS modified_4, t0.lang AS lang_5, t0.status AS status_6, t0.title_image AS title_image_7, t0.intro AS intro_8, t0.body AS body_9, t0.title_image_aria_label AS title_image_aria_label_10, t0.title_image_alt_tag AS title_image_alt_tag_11 FROM news t0 WHERE t0.lang = ? AND t0.status = ? ORDER BY t0.modified DESC LIMIT 5
Parameters:
[
  "en"
  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.

Entities Mapping

Class Mapping errors
App\Entity\Menu No errors.
App\Entity\Page No errors.
App\Entity\News No errors.