https://mirbusin.ru/ru/block/filter/onsale/433/busini-steklyannie-imitaciya-kamnya/filter

Query Metrics

12 Database Queries
12 Different statements
33.02 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 10.45 ms
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[]
2 0.26 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:
[]
3 0.98 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.page AS page_3, t0.intname AS intname_4, t0.mainpage AS mainpage_5, t0.name AS name_6, t0.href AS href_7, t0.short AS short_8, t0.cont AS cont_9, t0.prior AS prior_10, t0.visible AS visible_11, t0.title AS title_12, t0.h1 AS h1_13, t0.kw AS kw_14, t0.descr AS descr_15, t0.tstamp AS tstamp_16, t0.icon AS icon_17 FROM page t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
  "block/filter/onsale/433/busini-steklyannie-imitaciya-kamnya/filter"
]
4 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
]
5 11.20 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 = '433' and c.search > 0 group by c.id order by c.prior desc
Parameters:
[]
6 0.27 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
  279
  287
  298
  315
]
7 0.32 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 (629, 629, 629, 629, 12306, 629, 12306, 634, 634, 12306) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
8 0.23 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, 654, 654, 576, 576, 654, 654) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
9 8.02 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 (539, 539, 539, 539, 64136, 64136, 539, 539, 64136, 539) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
10 0.31 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 (547, 547, 547, 547, 29865, 29865, 19207, 19207, 24878, 551) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
11 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 = 279 AND c0_.id IN (586, 586, 586, 586, 586, 586) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[]
12 0.29 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 (12958, 12958, 12954, 12954, 12954, 12954, 12954, 12954, 12954, 12954) 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.