https://www.test.dombusin.com/uk/articles?start=50

Query Metrics

54 Database Queries
5 Different statements
409.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
353.46 ms
(86.38%)
50
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
]
26.53 ms
(6.48%)
1
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
]
19.18 ms
(4.69%)
1
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:
[]
7.25 ms
(1.77%)
1
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:
[]
2.75 ms
(0.67%)
1
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
]

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.