https://test.dombusin.com/ru/block/filter/636/sharmi-evrobusini-s-podveskoj/filter

Query Metrics

9 Database Queries
9 Different statements
28.33 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.47 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 1.21 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 = '636' and c.search > 0 group by c.id order by c.prior desc
Parameters:
[]
3 0.34 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:
[
  298
  309
  270
  287
  274
  272
]
4 0.33 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 (29586, 29586, 29576, 29576, 29576, 29576, 29576, 29576, 29576, 29576, 29576, 29586) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
5 9.40 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 (12788, 12821, 12788, 12788, 12788, 12788, 638, 12788, 635, 635, 638, 12821) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
6 3.09 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 (23032, 30546, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
7 7.26 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 (76, 59, 118, 118, 118, 21251, 409, 168, 409, 409, 409, 593) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
8 5.24 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 (29551, 3218, 3218, 3218, 3218, 3222, 3222, 3218, 3222, 3222, 3222, 3222) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
9 1.00 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 (22289, 22289, 22290, 22290, 22290, 22289, 22292, 22289, 22292, 22292, 22292, 22290) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]

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.