https://www.test.dombusin.com/uk/block/filter/action/491/materiali-dlya-nanizivaniya/filter

301 Redirect from
@prod_list_cat_spec (3e7df1)
Method
GET
HTTP Status
200
IP
216.73.216.235
Profiled on
Token
b794c5

Query Metrics

97 Database Queries
9 Different statements
82.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
67.09 ms
(81.54%) 		86 
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
]
View formatted query    View runnable query    Explain query
7.11 ms
(8.64%) 		1 
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 (22292, 22921, 22291, 25138, 25138, 22292, 22292, 22291, 26560, 22291, 22290, 22290, 26560, 22290, 22290, 22290, 22290, 22291, 22293, 22290, 22292, 22309, 22292, 22291, 22290, 22292, 22293, 25138, 22291, 22292, 22309, 22292, 22292, 22290, 24927, 22291, 26560, 22290, 22291, 22290, 25138, 22309, 22309, 22309, 22309, 22309, 22309, 22309, 22291, 22292, 22292, 22291, 22292, 22921, 22291, 22291, 22293, 22921, 22290, 28836, 22290, 22290, 22291, 22292, 22292, 22292, 26327, 22292, 22292, 22292, 22290, 22290, 22292, 22292, 22290, 22290, 22292, 22291, 22921, 22309, 22292, 22291, 22291, 22291, 22291, 22290, 22921, 28836, 31043, 22291, 28836, 28836, 22291, 28836, 28836, 28836, 28836, 28836, 28836, 22291, 22921, 22291, 22290, 22290, 22293, 22292, 22292, 25138, 22921, 22290, 22292, 22291, 22921, 22292, 22292, 22292, 58120, 22291, 22291, 22292, 22291, 22290, 22293, 22910, 22292, 22291, 25138, 22290, 22290, 22290, 22290, 22290, 22291, 58818, 22290, 22292, 22291, 22291, 26560, 22291) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.66 ms
(2.01%) 		1 
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 (3237, 3249, 12621, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3237, 3055, 3055, 3055, 3055, 3055, 3249, 3249, 15183, 3249, 15911, 15911, 15906, 3249, 12621, 12621, 3237, 30881, 12621, 15906, 15214, 15214, 3055, 15911, 5800, 12645, 3237, 5800, 5800, 12645, 12645, 12645, 12645, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 12645, 15906, 15894, 15894, 15894, 15894, 6351, 17288, 17288, 17288, 17288, 17288, 17288, 6414, 6414, 6414, 17288, 12643, 3237, 3235, 3235, 17288, 18193, 15906, 15906, 15894, 15894, 15894, 12627, 3232, 3235, 6351, 6351, 6351, 6351, 6351, 6351, 6351, 6351, 6351, 3232, 17677, 3228, 3228, 3228, 30881, 30881, 15894, 15894, 15894, 15894, 12636, 3237, 1707, 17836, 1707, 12621, 12621, 12621, 12621, 12621, 12621, 12621, 12621, 12621, 15934, 15934, 15934, 15934, 17288, 17288, 12643, 12643, 3232, 3232, 3237, 3237, 3237, 3237, 3237, 3237, 15217, 3235, 3235, 30881, 30881, 30881, 3055, 17288, 17288, 17288, 17288, 6414, 3237, 3237, 5800, 31788, 3237, 3237, 3237, 1, 6351, 30881, 30881, 30881, 12643, 12643, 15894, 1707, 30881, 30881, 30881, 30881, 30881, 15911, 30881, 30881, 3237, 3237, 15906, 30881, 30881, 30881, 15934, 12643, 30881, 30881, 15217, 17288, 3237, 22124, 30881, 30881, 30881, 12621, 12621, 3237, 1707, 30881, 25210, 15217, 5800, 17288, 17288, 1707, 1707, 17288, 17288, 1707, 17288, 17288, 12621, 12621, 12621, 12621, 15934, 12621, 3237, 12621, 12645, 17288, 15183, 15183, 15183, 15183, 15183, 15183, 15183, 3235, 3235, 3235, 3235, 17836, 17836, 17836, 17836, 15911, 15911, 15911, 15911, 15911, 31788, 15911, 12643, 12627, 3235, 3235, 3235, 3235, 3055, 3055, 3055, 1707, 17288, 17288, 17288, 17288, 26626, 5800, 15911, 26626, 5800, 12627, 12643, 12643, 15894, 15894, 15894, 15906, 15906, 15906, 17288, 3237, 3237, 17836, 17836, 17836, 17836, 17836, 17836, 27409, 17836, 3235, 12621, 12621, 12621, 12621, 12621, 12621, 12621, 12621, 17836, 17836, 158, 158, 158, 158, 158, 158, 15800, 158, 158, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 30881, 5800, 17836, 15214, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 3055, 15934, 15894, 15894, 12621, 12621, 12621, 12621, 5800, 5800, 5800, 5800, 5800, 3235, 5800, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 3237, 31788, 3232, 26626, 22124, 15911, 12643, 12643, 12643, 12643, 12643, 15906, 15906, 158, 15706, 16994, 16994, 1707, 57359, 21562, 1707, 1707, 1707, 1707, 12643, 16994, 16994, 16994, 1707, 12643, 16994, 3055, 15800, 12645, 1707, 12645, 12645, 12645, 5800, 5800, 17288, 17288, 17288, 17288, 17288, 17288, 17288, 17288, 17288, 17288, 17288, 17288, 15214, 30881, 3055, 15906, 17288, 1707, 1707, 3055, 17288, 17836, 17288, 17288, 158, 5800, 25066, 29552, 29552, 27409, 29552, 15906, 15800, 15800, 15800, 15214, 15214, 1707, 15894, 15894, 12645, 12645, 12645, 12645, 12645, 16994, 3232, 26853, 5800, 15934, 3237, 3237, 15934, 15934, 5800, 15934, 15934, 3055, 3055, 5800, 15934, 3232, 3237, 3232, 3237, 3055, 3237, 15934, 15934, 12645, 12645, 12621, 3055, 12621, 3055, 3055, 12621, 58938, 58938) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.48 ms
(1.80%) 		1 
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, 12306, 638, 634, 629, 629, 629, 12788, 12788, 12788, 12788, 12788, 12306, 634, 634, 634, 631, 631, 12788, 12306, 12821, 635, 653, 12788, 12788, 12788, 12306, 12788, 653, 12788, 12788, 12788, 12788, 12306, 653, 635, 653, 653, 653, 638, 635, 646, 12306, 634, 635, 635, 12306, 631, 631, 12788, 635, 634, 12788, 646, 635, 629, 634, 634, 629, 635, 12788, 653, 629, 638, 12788, 12788, 12788, 629, 634, 631, 638, 638, 12788, 646, 634, 646, 634, 646, 638, 629, 646, 629, 631, 634, 638, 12788, 629, 12788, 12788, 629, 12306, 638, 634, 12788, 629, 629, 638, 12788, 12788, 12821, 634, 12821, 12306, 631, 634, 12788, 12788, 631, 631, 631, 12788, 629, 634, 12788, 634, 653, 653, 653, 653, 653, 653, 12306, 12788, 12788, 635, 635, 12788, 631, 634, 629, 653, 12788, 12788, 12788, 629, 631, 631, 635, 634, 629, 634, 12788, 12788, 638, 635, 634, 638, 646, 629, 638, 12788, 634, 634, 629, 638, 635, 12788, 12788, 12788, 635, 635, 631, 629, 634, 634, 638, 629, 12821, 631, 12788, 653, 12788, 12306, 631, 12788, 12788, 653, 634, 12306, 12788, 638, 646, 629, 634, 638, 638, 635, 629, 12306, 653, 12788, 12788, 629, 646, 629, 12306, 12788, 634, 12788, 12306, 634, 634, 634, 12788, 12306, 634, 634, 653, 12306, 634, 12821, 12788, 634, 12788, 629, 629, 638, 634, 634, 634, 634, 12821, 12788, 12788, 629, 653, 653, 653, 634, 12788, 635, 631, 638, 638, 634, 12306, 12788, 12306, 12306, 12788, 634, 12788, 646, 638, 634, 635, 629, 629, 638, 12788, 629, 12821, 12788, 12788, 638, 12788, 653, 653, 12788, 635, 638, 631, 631, 634, 634, 634, 634, 12788, 12788, 12788, 629, 646, 629, 646, 634, 634, 12788, 629, 12788, 653, 653, 12788, 653, 12788, 12306, 653, 629, 629, 646, 629, 12821, 631, 634, 12306, 12788, 635, 631, 12788, 638, 634, 631, 631, 634, 634, 12306, 634, 12788, 634, 12306, 634, 638, 12306, 634, 634, 12788, 634, 12788, 629, 653, 653, 629, 634, 646, 12821, 653, 12788, 629, 629, 653, 12788, 629, 629, 638, 638, 638, 12788, 12306, 653, 629, 638, 629, 653, 631, 12788, 631, 631, 653, 12788, 12821, 638, 12788, 631, 12306, 631, 634, 638, 12821, 629) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.46 ms
(1.77%) 		1 
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 (12921, 12921, 30160, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 12921, 15903, 15903, 15903, 15903, 15903, 12921, 12921, 12601, 12921, 12921, 12921, 12921, 12921, 30577, 30577, 31004, 60440, 30577, 12921, 18189, 18189, 15903, 12921, 60495, 12921, 31004, 60495, 60495, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 17585, 18189, 18189, 18189, 18189, 18189, 18189, 17585, 17585, 17585, 18189, 12921, 31004, 12921, 12921, 18189, 12601, 12921, 12921, 12921, 12921, 12921, 12601, 17585, 12921, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 17585, 60440, 60440, 12921, 12921, 12921, 12921, 18142, 18142, 18142, 27439, 18189, 12601, 30577, 30577, 30577, 30577, 30577, 30577, 30577, 30577, 15903, 15903, 15903, 15903, 15903, 15903, 12921, 12921, 27437, 27437, 31004, 31004, 31004, 31004, 31004, 31004, 12921, 12921, 12921, 60440, 60440, 60440, 18189, 18189, 18189, 18189, 18189, 17585, 12921, 12921, 60495, 60496, 12921, 12921, 12921, 60496, 17585, 60440, 60440, 60440, 12921, 12921, 12921, 18142, 60440, 60440, 60440, 60440, 60440, 12921, 60440, 60440, 12921, 12921, 12921, 60440, 60440, 60440, 15903, 12921, 60440, 60440, 12921, 18142, 12921, 60441, 60440, 60440, 60440, 18142, 18142, 12921, 18142, 60440, 12601, 12921, 60495, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 30577, 30577, 30577, 30577, 15903, 30577, 31004, 18142, 18142, 18142, 12601, 12601, 12601, 12601, 12601, 12601, 12601, 12921, 12921, 12921, 12921, 27439, 27439, 27439, 27439, 12921, 12921, 12921, 12921, 12921, 60496, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 60441, 60495, 12921, 60441, 60495, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 18142, 12921, 12921, 27439, 27439, 27439, 27439, 27439, 27439, 27442, 27439, 12921, 30160, 30160, 30160, 30160, 30160, 30160, 30160, 30160, 27439, 27439, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60440, 60495, 27439, 18189, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 15903, 58335, 12921, 12921, 30160, 30160, 30577, 30160, 60495, 60495, 60495, 60495, 60495, 12921, 60495, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 60496, 60496, 60441, 60441, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 12921, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 18189, 12921, 18189, 18189, 18189, 18189, 12921, 18189, 18189, 18189, 18142, 18189, 12921, 12921, 12921, 60495, 60495, 18189, 18189, 18196, 18196, 18196, 18196, 18196, 18196, 18196, 18196, 18196, 18189, 18189, 60440, 18189, 12921, 18189, 18189, 18189, 18189, 18189, 27439, 18189, 18189, 18189, 60495, 27439, 18142, 18142, 27442, 18142, 18142, 18196, 18196, 18196, 30160, 30160, 18189, 18142, 18142, 18142, 18142, 18142, 18142, 18142, 18189, 27437, 12921, 60495, 15903, 12921, 12921, 15903, 15903, 60495, 15903, 15903, 15903, 15903, 60495, 15903, 27437, 12921, 12921, 12921, 15903, 12921, 15903, 15903, 12921, 12921, 30160, 15903, 30160, 18189, 18189, 30577, 18189, 18189) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.37 ms
(1.66%) 		1 
select c.id, c.name, c.prior
            from `catchar` as cc 
            right join `char` as c on c.id = cc.char 
            where cc.cat = '491' and c.search > 0 group by c.id order by c.prior desc
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.96 ms
(1.17%) 		4 
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
]
View formatted query    View runnable query    Explain query
0.81 ms
(0.99%) 		1 
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
0.34 ms
(0.42%) 		1 
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
  312
  270
  272
]
View formatted query    View runnable query    Explain query

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.