Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

9 Database Queries

9 Different statements

77.69 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`] View formatted query View runnable query Explain query 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 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 = 0 ORDER BY t0.id DESC;
2	1.32 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 = '24' and c.search > 0 group by c.id order by c.prior desc Parameters: [] View formatted query View runnable query Explain query select c.id, c.name, c.prior from `catchar` as cc right join `char` as c on c.id = cc.char where cc.cat = '24' and c.search > 0 group by c.id order by c.prior desc select c.id, c.name, c.prior from `catchar` as cc right join `char` as c on c.id = cc.char where cc.cat = '24' and c.search > 0 group by c.id order by c.prior desc;
3	5.15 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`] View formatted query View runnable query Explain query 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 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 (298, 309, 270, 287, 274, 272) ORDER BY t0.prior DESC;
4	14.83 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, 29578, 29586, 19207, 547, 19207, 19207, 19207, 19207, 19207, 29577, 551, 547, 547, 547, 547, 547, 547, 547, 547, 551, 25183, 19207, 19207, 19207, 19207, 29577, 547, 547, 551, 25183, 25183, 25183, 25183, 19207, 19207, 551, 551, 551, 19207, 547, 547, 547, 19207, 19207, 547, 25183, 19207, 19207, 19207, 25183, 547, 547, 547, 551, 551, 29577, 25183, 25183, 547, 19207, 547, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 25183, 551, 547, 547, 547, 547, 19207, 19207, 547, 551, 19207, 19207, 551, 29577, 19207, 551, 19207, 547, 19207, 547, 547, 19207, 25183, 547, 29577, 551, 551, 551, 547, 547, 19207, 19207, 547, 29577, 19207, 19207, 547, 547, 19207, 551, 547, 19207, 19207, 19207, 19207, 19207, 19207, 547, 551, 19207, 19207, 547, 25183, 25183, 25183, 19207, 547, 551, 551, 551, 551, 551, 551, 547, 19207, 19207, 25183, 25183, 19207, 25183, 19207, 19207, 547, 547, 547, 19207, 25183, 551, 19207, 551, 19207, 25183, 547, 547, 19207, 19207, 547, 547, 551, 551, 19207, 547, 547, 25183, 25183, 25183, 547, 19207, 547, 25183, 25183, 19207, 19207, 25183, 19207, 25183, 25183, 19207, 19207, 19207, 547, 19207, 25183, 547, 19207, 19207, 29577, 547, 19207, 19207, 29577, 551, 25183, 25183, 25183, 19207, 551, 551, 551, 19207, 19207, 19207, 19207, 547, 547, 547, 25183, 19207, 547, 547, 19207, 29578, 29578, 29578, 29577, 29577, 551, 29577, 551, 547, 547, 29577, 29577, 29577, 29577, 29577, 29577, 29578, 29577, 29586, 29577, 29577, 29577, 29577, 29586, 29577, 29578, 29577, 29577, 29577, 29577, 29578, 547, 29578, 29578, 29578, 29578, 29577, 29577, 29577, 29577, 29577, 29578, 547, 547, 547, 29578) ORDER BY c0_.prior DESC, c0_.value ASC Parameters: [] View formatted query View runnable query Explain query 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, 29578, 29586, 19207, 547, 19207, 19207, 19207, 19207, 19207, 29577, 551, 547, 547, 547, 547, 547, 547, 547, 547, 551, 25183, 19207, 19207, 19207, 19207, 29577, 547, 547, 551, 25183, 25183, 25183, 25183, 19207, 19207, 551, 551, 551, 19207, 547, 547, 547, 19207, 19207, 547, 25183, 19207, 19207, 19207, 25183, 547, 547, 547, 551, 551, 29577, 25183, 25183, 547, 19207, 547, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 25183, 551, 547, 547, 547, 547, 19207, 19207, 547, 551, 19207, 19207, 551, 29577, 19207, 551, 19207, 547, 19207, 547, 547, 19207, 25183, 547, 29577, 551, 551, 551, 547, 547, 19207, 19207, 547, 29577, 19207, 19207, 547, 547, 19207, 551, 547, 19207, 19207, 19207, 19207, 19207, 19207, 547, 551, 19207, 19207, 547, 25183, 25183, 25183, 19207, 547, 551, 551, 551, 551, 551, 551, 547, 19207, 19207, 25183, 25183, 19207, 25183, 19207, 19207, 547, 547, 547, 19207, 25183, 551, 19207, 551, 19207, 25183, 547, 547, 19207, 19207, 547, 547, 551, 551, 19207, 547, 547, 25183, 25183, 25183, 547, 19207, 547, 25183, 25183, 19207, 19207, 25183, 19207, 25183, 25183, 19207, 19207, 19207, 547, 19207, 25183, 547, 19207, 19207, 29577, 547, 19207, 19207, 29577, 551, 25183, 25183, 25183, 19207, 551, 551, 551, 19207, 19207, 19207, 19207, 547, 547, 547, 25183, 19207, 547, 547, 19207, 29578, 29578, 29578, 29577, 29577, 551, 29577, 551, 547, 547, 29577, 29577, 29577, 29577, 29577, 29577, 29578, 29577, 29586, 29577, 29577, 29577, 29577, 29586, 29577, 29578, 29577, 29577, 29577, 29577, 29578, 547, 29578, 29578, 29578, 29578, 29577, 29577, 29577, 29577, 29577, 29578, 547, 547, 547, 29578 ) ORDER BY c0_.prior DESC, c0_.value ASC 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, 29578, 29586, 19207, 547, 19207, 19207, 19207, 19207, 19207, 29577, 551, 547, 547, 547, 547, 547, 547, 547, 547, 551, 25183, 19207, 19207, 19207, 19207, 29577, 547, 547, 551, 25183, 25183, 25183, 25183, 19207, 19207, 551, 551, 551, 19207, 547, 547, 547, 19207, 19207, 547, 25183, 19207, 19207, 19207, 25183, 547, 547, 547, 551, 551, 29577, 25183, 25183, 547, 19207, 547, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 25183, 551, 547, 547, 547, 547, 19207, 19207, 547, 551, 19207, 19207, 551, 29577, 19207, 551, 19207, 547, 19207, 547, 547, 19207, 25183, 547, 29577, 551, 551, 551, 547, 547, 19207, 19207, 547, 29577, 19207, 19207, 547, 547, 19207, 551, 547, 19207, 19207, 19207, 19207, 19207, 19207, 547, 551, 19207, 19207, 547, 25183, 25183, 25183, 19207, 547, 551, 551, 551, 551, 551, 551, 547, 19207, 19207, 25183, 25183, 19207, 25183, 19207, 19207, 547, 547, 547, 19207, 25183, 551, 19207, 551, 19207, 25183, 547, 547, 19207, 19207, 547, 547, 551, 551, 19207, 547, 547, 25183, 25183, 25183, 547, 19207, 547, 25183, 25183, 19207, 19207, 25183, 19207, 25183, 25183, 19207, 19207, 19207, 547, 19207, 25183, 547, 19207, 19207, 29577, 547, 19207, 19207, 29577, 551, 25183, 25183, 25183, 19207, 551, 551, 551, 19207, 19207, 19207, 19207, 547, 547, 547, 25183, 19207, 547, 547, 19207, 29578, 29578, 29578, 29577, 29577, 551, 29577, 551, 547, 547, 29577, 29577, 29577, 29577, 29577, 29577, 29578, 29577, 29586, 29577, 29577, 29577, 29577, 29586, 29577, 29578, 29577, 29577, 29577, 29577, 29578, 547, 29578, 29578, 29578, 29578, 29577, 29577, 29577, 29577, 29577, 29578, 547, 547, 547, 29578) ORDER BY c0_.prior DESC, c0_.value ASC;
5	4.57 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 (634, 635, 638, 12788, 653, 653, 631) ORDER BY c0_.prior DESC, c0_.value ASC Parameters: [] View formatted query View runnable query Explain query 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 (634, 635, 638, 12788, 653, 653, 631) ORDER BY c0_.prior DESC, c0_.value ASC 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 (634, 635, 638, 12788, 653, 653, 631) ORDER BY c0_.prior DESC, c0_.value ASC;
6	15.43 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 (16994, 16994, 16994, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 17288, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 17288, 17288, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 29552, 29552, 1707, 1707, 29552, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 1707, 29552, 23032, 15214, 23032, 23032, 23032, 1707, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 1707, 1707, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 1707, 1707, 1707, 29552, 1707, 1707, 1707, 31763, 31763, 29552, 1707, 1707, 29552, 1707, 29552, 1707, 1707, 29552, 29552, 29552, 15214, 29552, 29552, 29552, 29552, 15214, 29552, 29552, 29552, 29552, 1707, 1707, 1707, 29552, 1707, 1707, 1707, 1707, 15800, 23032, 58543, 15214, 58543, 58543, 23032, 1707, 17288, 29552, 23032, 29552, 29552, 23032, 1707, 15214, 23032, 23032, 23032, 29552, 29552, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 23032, 23995, 29552, 29552, 29552, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 29552, 29552, 29552, 29552, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 29552) ORDER BY c0_.prior DESC, c0_.value ASC Parameters: [] View formatted query View runnable query Explain query 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 ( 16994, 16994, 16994, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 17288, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 17288, 17288, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 29552, 29552, 1707, 1707, 29552, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 1707, 29552, 23032, 15214, 23032, 23032, 23032, 1707, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 1707, 1707, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 1707, 1707, 1707, 29552, 1707, 1707, 1707, 31763, 31763, 29552, 1707, 1707, 29552, 1707, 29552, 1707, 1707, 29552, 29552, 29552, 15214, 29552, 29552, 29552, 29552, 15214, 29552, 29552, 29552, 29552, 1707, 1707, 1707, 29552, 1707, 1707, 1707, 1707, 15800, 23032, 58543, 15214, 58543, 58543, 23032, 1707, 17288, 29552, 23032, 29552, 29552, 23032, 1707, 15214, 23032, 23032, 23032, 29552, 29552, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 23032, 23995, 29552, 29552, 29552, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 29552, 29552, 29552, 29552, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 29552 ) ORDER BY c0_.prior DESC, c0_.value ASC 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 (16994, 16994, 16994, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 17288, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 17288, 17288, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 29552, 29552, 1707, 1707, 29552, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 1707, 29552, 23032, 15214, 23032, 23032, 23032, 1707, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 23032, 23032, 23032, 23032, 17288, 17288, 23032, 1707, 1707, 1707, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 1707, 1707, 1707, 1707, 29552, 1707, 1707, 1707, 31763, 31763, 29552, 1707, 1707, 29552, 1707, 29552, 1707, 1707, 29552, 29552, 29552, 15214, 29552, 29552, 29552, 29552, 15214, 29552, 29552, 29552, 29552, 1707, 1707, 1707, 29552, 1707, 1707, 1707, 1707, 15800, 23032, 58543, 15214, 58543, 58543, 23032, 1707, 17288, 29552, 23032, 29552, 29552, 23032, 1707, 15214, 23032, 23032, 23032, 29552, 29552, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 1707, 23032, 23995, 29552, 29552, 29552, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 29552, 29552, 29552, 29552, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 23032, 29552) ORDER BY c0_.prior DESC, c0_.value ASC;
7	12.76 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, 81, 76, 59, 654, 59, 576, 59, 640, 640, 654, 92, 654, 593, 593, 654, 660, 1088, 654, 1088, 108, 81, 12808, 660, 660, 660, 17553, 654, 654, 92, 81, 81, 81, 81, 640, 108, 654, 654, 92, 12808, 17550, 17550, 654, 108, 640, 81, 660, 81, 81, 654, 59, 92, 17550, 654, 654, 92, 92, 81, 81, 660, 654, 576, 108, 108, 108, 108, 108, 593, 576, 81, 21338, 593, 26, 26, 593, 654, 108, 108, 654, 92, 108, 640, 660, 92, 640, 654, 654, 81, 81, 17553, 17553, 12805, 640, 593, 92, 92, 108, 108, 108, 17553, 503, 81, 593, 12416, 81, 81, 593, 654, 576, 108, 576, 593, 81, 81, 593, 593, 593, 576, 108, 81, 81, 593, 12805, 12805, 12805, 31762, 1088, 17553, 17553, 17553, 17553, 17553, 17553, 576, 593, 593, 81, 81, 14718, 81, 81, 81, 17550, 17550, 14718, 576, 12805, 593, 17553, 81, 593, 660, 593, 593, 640, 640, 593, 17550, 17550, 17550, 81, 81, 81, 12805, 72, 81, 654, 593, 593, 640, 640, 640, 640, 17550, 12805, 640, 81, 593, 593, 108, 654, 81, 81, 108, 593, 654, 356, 17553, 593, 81, 654, 17550, 654, 654, 81, 81, 17553, 17553, 17553, 81, 654, 654, 654, 654, 654, 576, 81, 654, 654, 654, 81, 76, 452, 452, 229, 229, 76, 76, 654, 12808, 660, 81, 63, 21543, 26, 26, 593, 116, 149, 21572, 21543, 21543, 12416, 26034, 26030, 305, 26210, 356, 356, 356, 27421, 27422, 25142, 12805, 12805, 12805, 12805, 81, 21572, 21572, 21572, 81, 21859, 21859, 21859, 81, 12805) ORDER BY c0_.prior DESC, c0_.value ASC Parameters: [] View formatted query View runnable query Explain query 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, 81, 76, 59, 654, 59, 576, 59, 640, 640, 654, 92, 654, 593, 593, 654, 660, 1088, 654, 1088, 108, 81, 12808, 660, 660, 660, 17553, 654, 654, 92, 81, 81, 81, 81, 640, 108, 654, 654, 92, 12808, 17550, 17550, 654, 108, 640, 81, 660, 81, 81, 654, 59, 92, 17550, 654, 654, 92, 92, 81, 81, 660, 654, 576, 108, 108, 108, 108, 108, 593, 576, 81, 21338, 593, 26, 26, 593, 654, 108, 108, 654, 92, 108, 640, 660, 92, 640, 654, 654, 81, 81, 17553, 17553, 12805, 640, 593, 92, 92, 108, 108, 108, 17553, 503, 81, 593, 12416, 81, 81, 593, 654, 576, 108, 576, 593, 81, 81, 593, 593, 593, 576, 108, 81, 81, 593, 12805, 12805, 12805, 31762, 1088, 17553, 17553, 17553, 17553, 17553, 17553, 576, 593, 593, 81, 81, 14718, 81, 81, 81, 17550, 17550, 14718, 576, 12805, 593, 17553, 81, 593, 660, 593, 593, 640, 640, 593, 17550, 17550, 17550, 81, 81, 81, 12805, 72, 81, 654, 593, 593, 640, 640, 640, 640, 17550, 12805, 640, 81, 593, 593, 108, 654, 81, 81, 108, 593, 654, 356, 17553, 593, 81, 654, 17550, 654, 654, 81, 81, 17553, 17553, 17553, 81, 654, 654, 654, 654, 654, 576, 81, 654, 654, 654, 81, 76, 452, 452, 229, 229, 76, 76, 654, 12808, 660, 81, 63, 21543, 26, 26, 593, 116, 149, 21572, 21543, 21543, 12416, 26034, 26030, 305, 26210, 356, 356, 356, 27421, 27422, 25142, 12805, 12805, 12805, 12805, 81, 21572, 21572, 21572, 81, 21859, 21859, 21859, 81, 12805 ) ORDER BY c0_.prior DESC, c0_.value ASC 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, 81, 76, 59, 654, 59, 576, 59, 640, 640, 654, 92, 654, 593, 593, 654, 660, 1088, 654, 1088, 108, 81, 12808, 660, 660, 660, 17553, 654, 654, 92, 81, 81, 81, 81, 640, 108, 654, 654, 92, 12808, 17550, 17550, 654, 108, 640, 81, 660, 81, 81, 654, 59, 92, 17550, 654, 654, 92, 92, 81, 81, 660, 654, 576, 108, 108, 108, 108, 108, 593, 576, 81, 21338, 593, 26, 26, 593, 654, 108, 108, 654, 92, 108, 640, 660, 92, 640, 654, 654, 81, 81, 17553, 17553, 12805, 640, 593, 92, 92, 108, 108, 108, 17553, 503, 81, 593, 12416, 81, 81, 593, 654, 576, 108, 576, 593, 81, 81, 593, 593, 593, 576, 108, 81, 81, 593, 12805, 12805, 12805, 31762, 1088, 17553, 17553, 17553, 17553, 17553, 17553, 576, 593, 593, 81, 81, 14718, 81, 81, 81, 17550, 17550, 14718, 576, 12805, 593, 17553, 81, 593, 660, 593, 593, 640, 640, 593, 17550, 17550, 17550, 81, 81, 81, 12805, 72, 81, 654, 593, 593, 640, 640, 640, 640, 17550, 12805, 640, 81, 593, 593, 108, 654, 81, 81, 108, 593, 654, 356, 17553, 593, 81, 654, 17550, 654, 654, 81, 81, 17553, 17553, 17553, 81, 654, 654, 654, 654, 654, 576, 81, 654, 654, 654, 81, 76, 452, 452, 229, 229, 76, 76, 654, 12808, 660, 81, 63, 21543, 26, 26, 593, 116, 149, 21572, 21543, 21543, 12416, 26034, 26030, 305, 26210, 356, 356, 356, 27421, 27422, 25142, 12805, 12805, 12805, 12805, 81, 21572, 21572, 21572, 81, 21859, 21859, 21859, 81, 12805) ORDER BY c0_.prior DESC, c0_.value ASC;
8	21.12 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, 537, 539, 537, 539, 539, 539, 537, 537, 537, 539, 537, 539, 539, 537, 537, 537, 537, 537, 537, 539, 539, 539, 539, 539, 537, 544, 544, 539, 539, 539, 539, 539, 539, 539, 544, 544, 539, 539, 537, 537, 3222, 539, 539, 537, 539, 539, 539, 537, 539, 537, 537, 537, 537, 537, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 544, 539, 537, 539, 537, 544, 544, 3222, 544, 539, 539, 537, 539, 539, 537, 3222, 539, 539, 539, 539, 537, 539, 539, 539, 544, 537, 539, 539, 537, 544, 544, 539, 539, 539, 537, 3222, 537, 537, 537, 3222, 544, 539, 544, 537, 544, 537, 539, 544, 544, 544, 539, 544, 539, 539, 537, 539, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 539, 539, 12807, 539, 544, 539, 539, 539, 537, 537, 3222, 539, 539, 537, 539, 537, 537, 539, 537, 537, 537, 537, 29551, 537, 544, 544, 537, 544, 544, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 544, 539, 539, 539, 539, 539, 544, 539, 539, 537, 539, 544, 29551, 539, 539, 539, 544, 3222, 539, 539, 12807, 539, 537, 537, 537, 539, 537, 537, 537, 537, 537, 539, 539, 12807, 537, 3222, 539, 539, 539, 539, 539, 539, 539, 539, 544, 537, 537, 537, 12807, 539, 539, 539, 537, 537, 12807, 537, 539, 539, 12807, 539, 539, 539, 544, 544, 544, 544, 544, 537, 539, 29549, 29549, 29549, 29549, 539, 537, 537, 537, 539, 539, 539, 539, 539, 29549) ORDER BY c0_.prior DESC, c0_.value ASC Parameters: [] View formatted query View runnable query Explain query 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, 537, 539, 537, 539, 539, 539, 537, 537, 537, 539, 537, 539, 539, 537, 537, 537, 537, 537, 537, 539, 539, 539, 539, 539, 537, 544, 544, 539, 539, 539, 539, 539, 539, 539, 544, 544, 539, 539, 537, 537, 3222, 539, 539, 537, 539, 539, 539, 537, 539, 537, 537, 537, 537, 537, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 544, 539, 537, 539, 537, 544, 544, 3222, 544, 539, 539, 537, 539, 539, 537, 3222, 539, 539, 539, 539, 537, 539, 539, 539, 544, 537, 539, 539, 537, 544, 544, 539, 539, 539, 537, 3222, 537, 537, 537, 3222, 544, 539, 544, 537, 544, 537, 539, 544, 544, 544, 539, 544, 539, 539, 537, 539, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 539, 539, 12807, 539, 544, 539, 539, 539, 537, 537, 3222, 539, 539, 537, 539, 537, 537, 539, 537, 537, 537, 537, 29551, 537, 544, 544, 537, 544, 544, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 544, 539, 539, 539, 539, 539, 544, 539, 539, 537, 539, 544, 29551, 539, 539, 539, 544, 3222, 539, 539, 12807, 539, 537, 537, 537, 539, 537, 537, 537, 537, 537, 539, 539, 12807, 537, 3222, 539, 539, 539, 539, 539, 539, 539, 539, 544, 537, 537, 537, 12807, 539, 539, 539, 537, 537, 12807, 537, 539, 539, 12807, 539, 539, 539, 544, 544, 544, 544, 544, 537, 539, 29549, 29549, 29549, 29549, 539, 537, 537, 537, 539, 539, 539, 539, 539, 29549 ) ORDER BY c0_.prior DESC, c0_.value ASC 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, 537, 539, 537, 539, 539, 539, 537, 537, 537, 539, 537, 539, 539, 537, 537, 537, 537, 537, 537, 539, 539, 539, 539, 539, 537, 544, 544, 539, 539, 539, 539, 539, 539, 539, 544, 544, 539, 539, 537, 537, 3222, 539, 539, 537, 539, 539, 539, 537, 539, 537, 537, 537, 537, 537, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 544, 539, 537, 539, 537, 544, 544, 3222, 544, 539, 539, 537, 539, 539, 537, 3222, 539, 539, 539, 539, 537, 539, 539, 539, 544, 537, 539, 539, 537, 544, 544, 539, 539, 539, 537, 3222, 537, 537, 537, 3222, 544, 539, 544, 537, 544, 537, 539, 544, 544, 544, 539, 544, 539, 539, 537, 539, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 539, 539, 12807, 539, 544, 539, 539, 539, 537, 537, 3222, 539, 539, 537, 539, 537, 537, 539, 537, 537, 537, 537, 29551, 537, 544, 544, 537, 544, 544, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 544, 539, 539, 539, 539, 539, 544, 539, 539, 537, 539, 544, 29551, 539, 539, 539, 544, 3222, 539, 539, 12807, 539, 537, 537, 537, 539, 537, 537, 537, 537, 537, 539, 539, 12807, 537, 3222, 539, 539, 539, 539, 539, 539, 539, 539, 544, 537, 537, 537, 12807, 539, 539, 539, 537, 537, 12807, 537, 539, 539, 12807, 539, 539, 539, 544, 544, 544, 544, 544, 537, 539, 29549, 29549, 29549, 29549, 539, 537, 537, 537, 539, 539, 539, 539, 539, 29549) ORDER BY c0_.prior DESC, c0_.value ASC;
9	2.04 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, 22293, 22289, 22294, 22289, 22288, 22290, 22288, 22289, 22289, 22288, 22289, 22289, 22289, 22293, 22293, 22289, 22292, 22288, 22291, 22289, 22290, 22310, 22291, 22288, 22309, 22290, 22291, 22294, 22309, 22288, 22310, 22289, 22293, 22310, 22310, 22293, 22288, 22310, 22289, 22289, 22289, 22310, 22292, 22291, 22310, 22288, 22289, 22294, 22288, 22289, 22288, 22289, 22291, 22292, 22289, 22292, 22289, 22309, 22292, 22288, 22294, 22293, 22288, 22294, 22293, 22290, 22289, 22291, 22292, 22289, 22294, 22290, 22292, 22292, 22289, 22291, 22289, 22293, 22293, 22291, 22292, 22291, 25138, 25138, 22290, 22309, 25138, 26327, 22294, 22292, 22294, 22294, 22292, 22289, 26506, 28836, 25138, 22288, 25138, 22291, 22292, 22293, 22290, 22293, 22293, 22291, 22291, 22291, 22292, 22292, 22289, 22293, 22288, 22289, 22291, 22292, 22292, 22291, 22309, 22292, 22292, 22291, 22293, 22291, 22292, 26560, 22290, 22294, 22310, 22292, 22291, 28836, 22291, 22292, 22309, 22291, 22309, 22292, 26327, 28836, 25138, 22291, 25138, 26327, 22310, 25138, 25138, 25138, 22291, 25138, 22291, 25138, 22291, 25138, 25138, 22291, 22291, 25138, 22291, 22291, 22291, 25138, 22291, 22291, 22291, 22290, 22294, 25138, 22290, 22291, 22292, 22290, 22291, 22291, 22291, 22289, 22291, 25138, 22291, 22289, 22289, 22910, 29944, 28836, 22291, 22291, 22290, 22309, 22290, 22291, 22290, 22309, 22291, 22290, 22294, 22291, 22291, 25138, 22291, 22292, 22289, 22288, 22293, 22289, 22288, 22289, 22289, 22289, 22288, 22289, 22289, 22289, 22289, 22290, 22292, 22289, 22288, 22289, 22289, 22293, 22288, 22289, 22289, 22310, 22289, 22289, 22288, 22289, 22293, 22290, 22289, 22289, 22289, 22289, 22289, 22289, 22288, 22294, 22290, 22921, 22289, 22288, 22288, 22289, 22289, 22289) ORDER BY c0_.prior DESC, c0_.value ASC Parameters: [] View formatted query View runnable query Explain query 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, 22293, 22289, 22294, 22289, 22288, 22290, 22288, 22289, 22289, 22288, 22289, 22289, 22289, 22293, 22293, 22289, 22292, 22288, 22291, 22289, 22290, 22310, 22291, 22288, 22309, 22290, 22291, 22294, 22309, 22288, 22310, 22289, 22293, 22310, 22310, 22293, 22288, 22310, 22289, 22289, 22289, 22310, 22292, 22291, 22310, 22288, 22289, 22294, 22288, 22289, 22288, 22289, 22291, 22292, 22289, 22292, 22289, 22309, 22292, 22288, 22294, 22293, 22288, 22294, 22293, 22290, 22289, 22291, 22292, 22289, 22294, 22290, 22292, 22292, 22289, 22291, 22289, 22293, 22293, 22291, 22292, 22291, 25138, 25138, 22290, 22309, 25138, 26327, 22294, 22292, 22294, 22294, 22292, 22289, 26506, 28836, 25138, 22288, 25138, 22291, 22292, 22293, 22290, 22293, 22293, 22291, 22291, 22291, 22292, 22292, 22289, 22293, 22288, 22289, 22291, 22292, 22292, 22291, 22309, 22292, 22292, 22291, 22293, 22291, 22292, 26560, 22290, 22294, 22310, 22292, 22291, 28836, 22291, 22292, 22309, 22291, 22309, 22292, 26327, 28836, 25138, 22291, 25138, 26327, 22310, 25138, 25138, 25138, 22291, 25138, 22291, 25138, 22291, 25138, 25138, 22291, 22291, 25138, 22291, 22291, 22291, 25138, 22291, 22291, 22291, 22290, 22294, 25138, 22290, 22291, 22292, 22290, 22291, 22291, 22291, 22289, 22291, 25138, 22291, 22289, 22289, 22910, 29944, 28836, 22291, 22291, 22290, 22309, 22290, 22291, 22290, 22309, 22291, 22290, 22294, 22291, 22291, 25138, 22291, 22292, 22289, 22288, 22293, 22289, 22288, 22289, 22289, 22289, 22288, 22289, 22289, 22289, 22289, 22290, 22292, 22289, 22288, 22289, 22289, 22293, 22288, 22289, 22289, 22310, 22289, 22289, 22288, 22289, 22293, 22290, 22289, 22289, 22289, 22289, 22289, 22289, 22288, 22294, 22290, 22921, 22289, 22288, 22288, 22289, 22289, 22289 ) ORDER BY c0_.prior DESC, c0_.value ASC 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, 22293, 22289, 22294, 22289, 22288, 22290, 22288, 22289, 22289, 22288, 22289, 22289, 22289, 22293, 22293, 22289, 22292, 22288, 22291, 22289, 22290, 22310, 22291, 22288, 22309, 22290, 22291, 22294, 22309, 22288, 22310, 22289, 22293, 22310, 22310, 22293, 22288, 22310, 22289, 22289, 22289, 22310, 22292, 22291, 22310, 22288, 22289, 22294, 22288, 22289, 22288, 22289, 22291, 22292, 22289, 22292, 22289, 22309, 22292, 22288, 22294, 22293, 22288, 22294, 22293, 22290, 22289, 22291, 22292, 22289, 22294, 22290, 22292, 22292, 22289, 22291, 22289, 22293, 22293, 22291, 22292, 22291, 25138, 25138, 22290, 22309, 25138, 26327, 22294, 22292, 22294, 22294, 22292, 22289, 26506, 28836, 25138, 22288, 25138, 22291, 22292, 22293, 22290, 22293, 22293, 22291, 22291, 22291, 22292, 22292, 22289, 22293, 22288, 22289, 22291, 22292, 22292, 22291, 22309, 22292, 22292, 22291, 22293, 22291, 22292, 26560, 22290, 22294, 22310, 22292, 22291, 28836, 22291, 22292, 22309, 22291, 22309, 22292, 26327, 28836, 25138, 22291, 25138, 26327, 22310, 25138, 25138, 25138, 22291, 25138, 22291, 25138, 22291, 25138, 25138, 22291, 22291, 25138, 22291, 22291, 22291, 25138, 22291, 22291, 22291, 22290, 22294, 25138, 22290, 22291, 22292, 22290, 22291, 22291, 22291, 22289, 22291, 25138, 22291, 22289, 22289, 22910, 29944, 28836, 22291, 22291, 22290, 22309, 22290, 22291, 22290, 22309, 22291, 22290, 22294, 22291, 22291, 25138, 22291, 22292, 22289, 22288, 22293, 22289, 22288, 22289, 22289, 22289, 22288, 22289, 22289, 22289, 22289, 22290, 22292, 22289, 22288, 22289, 22289, 22293, 22288, 22289, 22289, 22310, 22289, 22289, 22288, 22289, 22293, 22290, 22289, 22289, 22289, 22289, 22289, 22289, 22288, 22294, 22290, 22921, 22289, 22288, 22288, 22289, 22289, 22289) ORDER BY c0_.prior DESC, c0_.value ASC;

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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Discount	No errors.
App\Entity\Prod	No errors.
App\Entity\CartUnsaved	No errors.
App\Entity\Cart	No errors.
App\Entity\Cat	No errors.
App\Entity\Page	No errors.
App\Entity\Catpage	No errors.
App\Entity\Photo	No errors.
App\Entity\Wishlist	No errors.
App\Entity\Catchar	No errors.
App\Entity\PagePhoto	No errors.
App\Entity\PageBlock	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Entity\Translation\PageTranslation	No errors.
App\Entity\Translation\CatTranslation	No errors.
App\Entity\Translation\ProdTranslation	No errors.
App\Entity\Translation\DiscountTranslation	No errors.
App\Entity\Translation\CatpageTranslation	No errors.
App\Entity\Timer	No errors.
App\Entity\Char	No errors.
App\Entity\Charval	No errors.
App\Entity\Translation\TimerTranslation	No errors.
App\Entity\Translation\CharTranslation	No errors.
App\Entity\Translation\CharvalTranslation	No errors.

Symfony Profiler

https://test.dombusin.com/ru/block/filter/24/metallicheskie/filter

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping