https://www.test.mirbusin.ru/uk/block/filter/action/9/derevyannie/filter

Query Metrics

73 Database Queries
13 Different statements
28.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.21 ms
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.value AS value_4 FROM block t0
Parameters:
[]
2 0.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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
3 0.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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  2
]
4 0.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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  3
]
5 0.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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  4
]
6 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  5
]
7 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  6
]
8 0.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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  7
]
9 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  8
]
10 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  9
]
11 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  10
]
12 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  11
]
13 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  12
]
14 0.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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  13
]
15 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  14
]
16 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  15
]
17 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  16
]
18 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  17
]
19 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  18
]
20 0.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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  19
]
21 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  20
]
22 0.11 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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  21
]
23 0.37 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
]
24 0.89 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 = '9' and c.search > 0 group by c.id order by c.prior desc
Parameters:
[]
25 0.25 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
  274
  287
  297
  298
  312
  315
]
26 0.16 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
]
27 0.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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  287
]
28 0.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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  274
]
29 0.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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  298
]
30 0.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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  297
]
31 0.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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  315
]
32 0.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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
  312
]
33 0.50 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 (12306, 12306, 12306, 12788, 634, 12306, 629, 12306, 12788, 634, 634, 12821, 634, 12306, 12821, 638, 631, 629, 629, 646, 12821, 629, 12821, 12821, 12821, 634, 12821, 12821, 638, 634, 634, 634, 634, 634, 634, 634, 634, 634, 12306, 634, 634, 634, 634, 634, 12306, 634, 12306, 12306, 12306, 12306, 12306, 634, 12306, 634, 12306, 12306, 12306, 12306, 12306, 12306, 634, 634, 634, 12821, 12821, 12821, 12821, 12788, 12821, 634, 634, 12788, 634, 634, 634, 12821, 12821, 12306, 12306, 12306, 12306, 12306, 12306, 12306, 634, 12306, 12306) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
34 0.16 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:
[
  12306
]
35 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  634
]
36 0.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:
[
  629
]
37 0.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:
[
  12821
]
38 0.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:
[
  631
]
39 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  638
]
40 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  646
]
41 0.75 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:
[
  12788
]
42 0.37 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 = 287 AND c0_.id IN (81, 81, 81, 81, 576, 81, 81, 81, 81, 81, 26, 26, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 654, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 356, 81, 81, 21189, 593, 81, 81, 81, 81, 81, 660, 26, 654, 81, 81, 81, 26, 654, 81, 81, 81, 81, 81, 81, 640, 81, 640, 81, 81, 81, 640, 81, 640, 81, 81, 81, 12805, 12805, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
43 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:
[
  576
]
44 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  660
]
45 0.33 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:
[
  12805
]
46 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  81
]
47 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  593
]
48 0.36 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:
[
  640
]
49 0.36 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:
[
  21189
]
50 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  26
]
51 0.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:
[
  654
]
52 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  356
]
53 2.47 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 = 274 AND c0_.id IN (537, 537, 64137, 64137, 29839, 64137, 64137, 64137, 64137, 3222, 64137, 537, 3222, 537, 64137, 64137, 64137, 64137, 64137, 64137, 64137, 64137, 64137, 537, 29839, 3222, 537, 64137, 537, 539, 539, 539, 539, 537, 537, 539, 537, 537, 3222, 29839, 64137, 537, 29837, 537, 3222, 64137, 30184, 21207, 21207, 3222, 29839, 64137, 537, 3222, 537, 64137, 29837, 64137, 29837, 3222, 64137, 3222, 3222, 64137, 29839, 64137, 64137, 539, 537, 537, 537, 64137, 537, 537, 539, 539, 539, 537, 64137, 29837, 29837, 3222, 64137, 537, 539, 64137, 537) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
54 0.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:
[
  21207
]
55 0.16 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:
[
  30184
]
56 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  539
]
57 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  537
]
58 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  64137
]
59 5.92 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:
[
  3222
]
60 0.28 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:
[
  29839
]
61 1.36 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:
[
  29837
]
62 0.36 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 = 298 AND c0_.id IN (29865, 29874, 29865, 551, 29874, 551, 551, 29874, 551, 29874, 29866, 547, 29874, 551, 29874, 29865, 29865, 29874, 29865, 29865, 29865, 547, 29874, 547, 29874, 29874, 547, 551, 547, 551, 547, 551, 551, 551, 29874, 29874, 29874, 29874, 29874, 29864, 29874, 551, 29864, 29866, 29864, 29866, 29874, 29874, 29864, 29874, 29874, 29874, 29874, 29865, 29866, 29866, 29874, 29865, 29864, 29865, 29866, 29874, 29874, 29865, 29874, 551, 29865, 547, 29874, 29874, 29865, 29874, 551, 551, 551, 547, 551, 29874, 29866, 29864, 29874, 29874, 29874, 29874, 551, 29874, 29866) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
63 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  547
]
64 0.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:
[
  551
]
65 0.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:
[
  29865
]
66 3.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:
[
  29866
]
67 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  29874
]
68 0.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:
[
  29864
]
69 0.25 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 = 315 AND c0_.id IN (30169, 30169, 30169, 15342, 30169, 30169, 30169, 30169, 30169, 30169, 30169, 30169, 30169, 15342, 30169, 30169, 30169, 30169, 30169, 30169, 30169) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
70 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  30169
]
71 0.17 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:
[
  15342
]
72 0.22 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 = 312 AND c0_.id IN (12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
73 0.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 charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
  12790
]

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.