https://test.dombusin.com/uk/block/filter2/43/sergi/filter

Query Metrics

30 Database Queries
8 Different statements
24.72 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 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 3.14 ms
SELECT c.id, c.name, c.prior
            FROM `catchar` AS cc 
            RIGHT JOIN `char` AS c ON c.id = cc.char 
            WHERE cc.cat = '43' AND c.search > 0 GROUP BY c.id ORDER BY c.prior DESC
Parameters:
[]
3 0.73 ms
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.name AS name_3, t0.type AS type_4, t0.search AS search_5, t0.buy AS buy_6, t0.izm AS izm_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.incat AS incat_10, t0.inprod AS inprod_11 FROM `char` t0 WHERE t0.id IN (?, ?, ?) ORDER BY t0.prior DESC
Parameters:
[
  309
  270
  272
]
4 0.56 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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  309
]
5 0.52 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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  270
]
6 0.43 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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  272
]
7 0.96 ms
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 309 AND c0_.id IN (12821, 634, 631, 631, 631) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
8 0.47 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  634
]
9 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  12821
]
10 0.47 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  631
]
11 1.28 ms
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 270 AND c0_.id IN (137, 15800, 15800, 15214, 25210, 25210, 25210, 25210, 25210, 15214, 25210, 25210, 25210, 25210, 1707, 15214, 15214, 25210, 25210, 15214, 25210, 15214, 15214, 15214, 25210, 25210, 25210, 25210, 15214, 15214, 25210, 15214, 15214, 25210, 1707, 25210, 27545, 1707, 1707, 15214, 25210, 1707, 15214, 25210, 25210, 1707, 1707, 25210, 25210, 1707, 15214, 1707, 15214, 15214, 25210, 28109, 15214, 15214, 15214, 15214, 15214, 15214, 15214, 25210, 27601, 15214, 15214, 15214, 15214, 15214, 17122, 175, 15214, 15214, 15214, 25210, 25210, 25210, 15214, 15214, 15214, 15214, 15214, 15214, 15214, 15214, 15214, 15214, 15214, 1707, 15214, 15214, 1707, 1707, 15214, 15214, 53175, 53175, 15214, 53175, 53175, 53175, 53175, 53175) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
12 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  137
]
13 1.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1707
]
14 1.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  28109
]
15 0.46 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  25210
]
16 0.39 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  15214
]
17 0.39 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  53175
]
18 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  27601
]
19 0.66 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  15800
]
20 0.71 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  17122
]
21 0.46 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  27545
]
22 0.44 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  175
]
23 1.28 ms
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 272 AND c0_.id IN (26205, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 26205, 26205, 22291, 26205, 25138, 25138, 25138, 22290, 22291, 22291, 26205, 25138, 22291, 22291, 25138, 25138, 22291, 22291, 22292, 22292, 22292, 22292, 25138, 22291, 22292, 25138, 22291, 22292, 22292, 22292, 22292, 22292, 22291, 25138, 22291, 22291, 22291, 22291, 22290, 22291, 25138, 25138, 25138, 22291, 22291, 22291, 22291, 25138, 22291, 22291, 22291, 22291, 22291, 22290, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 22291, 25138, 22289, 22291, 22291, 22291, 22291, 22292, 22292, 22291, 28836, 25138, 22291, 25138, 25138, 25138, 25138, 25138, 25138) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
24 1.62 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  22289
]
25 0.81 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  22291
]
26 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  25138
]
27 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  22290
]
28 1.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  28836
]
29 0.84 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  26205
]
30 0.68 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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  22292
]

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.