GET https://floowy.aytweb.com/api/floow?limit=20&page=1

Query Metrics

159 Database Queries
6 Different statements
1118.10 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1055.94 ms
(94.44%)
153
SELECT t0.id AS id_1, t0.label AS label_2, t0.is_enabled AS is_enabled_3, t0.level AS level_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
27.98 ms
(2.50%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.main_image AS main_image_2, a0_.main_image_credit AS main_image_credit_3, a0_.main_image_description AS main_image_description_4, a0_.src_url AS src_url_5, a0_.original_readable_content AS original_readable_content_6, a0_.ai_summary AS ai_summary_7, a0_.ai_summary_provider AS ai_summary_provider_8, a0_.posted_at AS posted_at_9, a0_.rss_feed_id AS rss_feed_id_10 FROM article a0_ INNER JOIN rss_feed r1_ ON a0_.rss_feed_id = r1_.id INNER JOIN category c2_ ON r1_.category_id = c2_.id WHERE c2_.is_enabled = ? AND c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.posted_at DESC LIMIT 20
Parameters:
[
  1
  1
  2
  5
  6
  3
  4
  50
  51
  52
  53
  54
  56
  57
  58
  59
  60
  61
  62
  111
  63
  64
  65
  66
  67
  123
  68
  69
  70
  135
  71
  72
  73
  74
  76
  77
  140
  142
  112
  75
  87
  96
  114
  118
  131
  55
  109
  136
  78
  79
  80
  81
  82
  83
  143
  84
  85
  86
  88
  89
  90
  91
  92
  93
  94
  95
  141
  97
  144
  98
  99
  100
  101
  102
  103
  146
  104
  105
  119
  106
  145
  107
  108
  110
  113
  147
  115
  116
  117
  121
  120
  137
  124
  125
  126
  134
  139
  138
  127
  128
  129
  130
  132
  148
  133
  122
  229
  7
  10
  11
  12
  13
  14
  15
  16
  17
  8
  18
  9
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  49
  217
  218
  219
  220
]
14.60 ms
(1.31%)
2
SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.birthdate AS birthdate_5, t0.phone AS phone_6, t0.post_code AS post_code_7, t0.roles AS roles_8, t0.password AS password_9 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "[email protected]"
]
6.97 ms
(0.62%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_enabled AS is_enabled_3, t0.url AS url_4 FROM newspaper t0 WHERE t0.id = ?
Parameters:
[
  60
]
6.37 ms
(0.57%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.is_enabled AS is_enabled_3, t0.level AS level_4, t0.parent_id AS parent_id_5 FROM category t0 INNER JOIN users_categories ON t0.id = users_categories.category_id WHERE users_categories.user_id = ?
Parameters:
[
  4
]
6.24 ms
(0.56%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.is_enabled AS is_enabled_4, t0.newspaper_id AS newspaper_id_5, t0.category_id AS category_id_6 FROM rss_feed t0 WHERE t0.id = ?
Parameters:
[
  289
]

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\User No errors.
App\Entity\Category No errors.
App\Entity\Article No errors.
App\Entity\RssFeed No errors.
App\Entity\Newspaper No errors.