Query Metrics
54
Database Queries
5
Different statements
409.17 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.75 ms |
SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC
Parameters:
[
0
]
|
2 | 7.25 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.page AS page_2, a0_.intname AS intname_3, a0_.mainpage AS mainpage_4, a0_.name AS name_5, a0_.href AS href_6, a0_.short AS short_7, a0_.cont AS cont_8, a0_.prior AS prior_9, a0_.visible AS visible_10, a0_.title AS title_11, a0_.h1 AS h1_12, a0_.kw AS kw_13, a0_.descr AS descr_14, a0_.tstamp AS tstamp_15, a0_.icon AS icon_16 FROM article a0_ WHERE a0_.visible = 1 AND a0_.type = 'article' ORDER BY a0_.tstamp DESC) dctrn_result) dctrn_table
Parameters:
[] |
3 | 19.18 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, tstamp_15 FROM (SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.page AS page_2, a0_.intname AS intname_3, a0_.mainpage AS mainpage_4, a0_.name AS name_5, a0_.href AS href_6, a0_.short AS short_7, a0_.cont AS cont_8, a0_.prior AS prior_9, a0_.visible AS visible_10, a0_.title AS title_11, a0_.h1 AS h1_12, a0_.kw AS kw_13, a0_.descr AS descr_14, a0_.tstamp AS tstamp_15, a0_.icon AS icon_16 FROM article a0_ WHERE a0_.visible = 1 AND a0_.type = 'article') dctrn_result_inner ORDER BY tstamp_15 DESC) dctrn_result LIMIT 50 OFFSET 50
Parameters:
[] |
4 | 26.53 ms |
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.page AS page_2, a0_.intname AS intname_3, a0_.mainpage AS mainpage_4, a0_.name AS name_5, a0_.href AS href_6, a0_.short AS short_7, a0_.cont AS cont_8, a0_.prior AS prior_9, a0_.visible AS visible_10, a0_.title AS title_11, a0_.h1 AS h1_12, a0_.kw AS kw_13, a0_.descr AS descr_14, a0_.tstamp AS tstamp_15, a0_.icon AS icon_16 FROM article a0_ WHERE a0_.visible = 1 AND a0_.type = 'article' AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.tstamp DESC
Parameters:
[ 302 301 300 299 298 297 296 295 294 293 292 291 290 289 288 287 286 285 284 283 282 281 280 279 278 277 276 275 273 272 271 270 269 261 259 258 257 256 255 254 253 252 250 249 248 247 246 245 244 235 ] |
5 | 0.21 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
302
]
|
6 | 1.96 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
301
]
|
7 | 3.73 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
300
]
|
8 | 4.13 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
299
]
|
9 | 2.80 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
298
]
|
10 | 14.12 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
297
]
|
11 | 7.12 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
296
]
|
12 | 1.00 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
295
]
|
13 | 4.48 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
294
]
|
14 | 16.76 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
293
]
|
15 | 0.97 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
292
]
|
16 | 4.02 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
291
]
|
17 | 2.18 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
290
]
|
18 | 1.04 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
289
]
|
19 | 1.78 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
288
]
|
20 | 5.12 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
287
]
|
21 | 3.27 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
286
]
|
22 | 7.34 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
285
]
|
23 | 6.25 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
284
]
|
24 | 1.14 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
283
]
|
25 | 5.12 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
282
]
|
26 | 2.10 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
281
]
|
27 | 7.03 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
280
]
|
28 | 13.31 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
279
]
|
29 | 3.29 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
278
]
|
30 | 7.40 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
277
]
|
31 | 8.42 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
276
]
|
32 | 15.58 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
275
]
|
33 | 20.15 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
273
]
|
34 | 2.63 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
272
]
|
35 | 3.58 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
271
]
|
36 | 4.30 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
270
]
|
37 | 8.29 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
269
]
|
38 | 10.83 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
261
]
|
39 | 2.60 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
259
]
|
40 | 4.96 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
258
]
|
41 | 17.35 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
257
]
|
42 | 3.61 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
256
]
|
43 | 2.73 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
255
]
|
44 | 12.98 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
254
]
|
45 | 4.38 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
253
]
|
46 | 15.70 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
252
]
|
47 | 12.57 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
250
]
|
48 | 4.96 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
249
]
|
49 | 13.69 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
248
]
|
50 | 11.37 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
247
]
|
51 | 7.25 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
246
]
|
52 | 15.02 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
245
]
|
53 | 16.64 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
244
]
|
54 | 6.19 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM article_translation t0 WHERE t0.object_id = ?
Parameters:
[
235
]
|
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\Discount | No errors. |
App\Entity\Wishlist | No errors. |
App\Entity\Article | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\ArticleTranslation | No errors. |