GET http://80.76.228.122/news

Query Metrics

31 Database Queries
5 Different statements
8.79 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1, t0.tag_id AS tag_id_2, t0.name AS name_3, t0.description AS description_4 FROM news_tags_list t0
Parameters:
[]
2 0.38 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  1
  1
]
3 0.30 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  2
  1
]
4 0.28 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  3
  1
]
5 0.27 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  4
  1
]
6 0.27 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  5
  1
]
7 0.29 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  6
  1
]
8 0.27 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  7
  1
]
9 0.25 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  8
  1
]
10 0.30 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  9
  1
]
11 0.27 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  10
  1
]
12 0.28 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  11
  1
]
13 0.29 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  12
  1
]
14 0.25 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  13
  1
]
15 0.28 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  14
  1
]
16 0.31 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  15
  1
]
17 0.28 ms
SELECT COUNT(*) FROM news_likes t0 WHERE t0.news_id = ?
Parameters:
[
  54
]
18 0.28 ms
SELECT n0_.id AS id_0, n0_.name AS name_1 FROM news_tags n1_ INNER JOIN news_tags_list n0_ ON (n1_.tag_id = n0_.id) WHERE n1_.news_id = ?
Parameters:
[
  54
]
19 0.27 ms
SELECT n0_.youtube_ref AS youtube_ref_0 FROM news_youtube n0_ WHERE n0_.news_id = ?
Parameters:
[
  54
]
20 0.28 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  16
  1
]
21 0.29 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  17
  1
]
22 0.22 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  18
  1
]
23 0.23 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  19
  1
]
24 0.23 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  20
  1
]
25 0.29 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  21
  1
]
26 0.28 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  22
  1
]
27 0.29 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  23
  1
]
28 0.30 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  24
  1
]
29 0.26 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  25
  1
]
30 0.29 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  26
  1
]
31 0.29 ms
SELECT n0_.id AS id_0, n0_.added AS added_1, n0_.changed AS changed_2, n0_.title AS title_3, n0_.text AS text_4, n0_.views AS views_5, n0_.poster AS poster_6, n0_.section AS section_7, n0_.draft AS draft_8, n0_.user_id AS user_id_9, u1_.user_name AS user_name_10, u1_.user_last_name AS user_last_name_11, u1_.avatar AS avatar_12, n0_.org_id AS org_id_13, o2_.name AS name_14, o2_.avatar AS avatar_15 FROM news n0_ LEFT JOIN users u1_ ON (n0_.user_id = u1_.id) LEFT JOIN organizations o2_ ON (n0_.org_id = o2_.id) WHERE n0_.section = ? AND n0_.enabled = ?
Parameters:
[
  27
  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\NewsTagsList No errors.
App\Entity\News No errors.
App\Entity\Users No errors.
App\Entity\Organizations No errors.
App\Entity\NewsLikes No errors.
App\Entity\NewsTags No errors.
App\Entity\NewsYoutube No errors.