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

Query Metrics

11 Database Queries
4 Different statements
8.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.34 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:
[
  "lv"
  0
  1
]
2 1.05 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:
[
  "lv"
  1
  1
]
3 0.53 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:
[
  "lv"
  9
  1
]
4 0.51 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:
[
  "lv"
  14
  1
]
5 0.34 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:
[
  "lv"
  15
  1
]
6 0.31 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:
[
  "lv"
  8
  1
]
7 0.36 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:
[
  "lv"
  16
  1
]
8 0.35 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:
[
  "lv"
  28
  1
]
9 0.78 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:
[
  "lv"
  7
]
10 0.66 ms
SELECT 
            l.*,
            m.content_id
          FROM link l 
          LEFT JOIN menu m ON m.id=l.navigation_id 
          WHERE l.lang='lv' 
          ORDER BY l.sort_index ASC
Parameters:
[]
11 0.90 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:
[
  "lv"
  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.