GET https://jenny-ai.riskplaza.nl/api/announcements/all

Query Metrics

52 Database Queries
3 Different statements
153.87 ms Query time
0 Invalid entities
104 Managed entities

Queries

Group similar statements

# Time Info
1 1.88 ms
SELECT t0.email AS email_1, t0.name AS name_2, t0.token AS token_3, t0.token_created_at AS token_created_at_4, t0.email_hash AS email_hash_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM user t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "96cde75f7963f636de5b3913dd0f8243d482b8e287beba1b91ac0a4cc2103489"
]
2 8.15 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.link AS link_3, t0.publication_date AS publication_date_4, t0.hash AS hash_5, t0.source_id AS source_id_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM announcement t0 ORDER BY t0.publication_date DESC LIMIT 50
Parameters:
[]
3 2.45 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7045
]
4 2.64 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7046
]
5 2.22 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7047
]
6 2.40 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7048
]
7 2.13 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7049
]
8 3.31 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7050
]
9 3.24 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7051
]
10 3.23 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7052
]
11 3.21 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7053
]
12 3.16 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7054
]
13 3.40 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7039
]
14 3.39 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7029
]
15 3.26 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7030
]
16 3.23 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7031
]
17 3.24 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7032
]
18 3.21 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7033
]
19 3.43 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7034
]
20 3.57 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7035
]
21 3.39 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7036
]
22 3.18 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7037
]
23 3.26 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7038
]
24 3.22 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7040
]
25 3.32 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7041
]
26 3.27 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7042
]
27 3.21 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7043
]
28 3.03 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7044
]
29 3.22 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7022
]
30 3.08 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7008
]
31 3.15 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7009
]
32 3.08 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7010
]
33 2.92 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7011
]
34 2.73 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7012
]
35 2.90 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7013
]
36 2.98 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7014
]
37 2.96 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7015
]
38 2.93 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7016
]
39 3.10 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7017
]
40 2.93 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7018
]
41 2.92 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7019
]
42 2.82 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7020
]
43 2.07 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7021
]
44 1.90 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7023
]
45 2.12 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7024
]
46 2.16 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7025
]
47 2.27 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7026
]
48 1.92 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7027
]
49 2.61 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  7028
]
50 2.68 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  6995
]
51 1.78 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  6986
]
52 2.03 ms
SELECT t0.announcement_id AS announcement_id_1, t0.article AS article_2, t0.favorite_article AS favorite_article_3, t0.id AS id_4 FROM announcement_article t0 WHERE t0.announcement_id = ?
Parameters:
[
  6987
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\AnnouncementArticle 53
App\Entity\Announcement 50
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Announcement No errors.
App\Entity\AnnouncementArticle No errors.