https://test.dombusin.com/catalog/pop/cat-16-biser?start=180

Method
GET
HTTP Status
200
IP
216.73.216.28
Profiled on
Token
6b838d

Query Metrics

23 Database Queries
21 Different statements
1944.82 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1832.29 ms
(94.21%) 		1 
SELECT id, cat, intname, name, art, price, price2, price3, priceopt, priceopt2, priceopt3, skidka, skidka2, skidka3, skidkaopt, skidkaopt2, skidkaopt3, numdiscount, numdiscount2, numdiscount3, chars, numdiscountopt, numdiscountopt2, numdiscountopt3, num, num2, num3, weight, weight2, weight3, inpack, inpack2, inpack3, pop, new, mix, action, onsale, selection1, selection2, prior, ordered, changed, colors FROM prod WHERE visible = 1 and (num > 0 or num2 > 0 or num3 > 0) and (cat = 143 or cat = 144 or cat = 608 or cat = 609 or cat = 752 or cat = 753 or cat = 764 or cat = 808 or cat = 893 or cat = 937 or cat = 16) and `pop` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
83.69 ms
(4.30%) 		2 
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.cart AS cart_3 FROM cart_unsaved t0 WHERE t0.user_id = ? LIMIT 1
Parameters: 
[
  "guest_69846cd1be16d"
]
View formatted query    View runnable query    Explain query
14.84 ms
(0.76%) 		1 
select c.id, c.name, c.prior
                from `catchar` as cc 
                right join `char` as c on c.id = cc.char 
                where c.search > 0 group by c.id order by c.prior desc
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.51 ms
(0.18%) 		1 
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.short AS short_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.spec AS spec_10, t0.newlabel AS newlabel_11, t0.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18, t0.pic AS pic_19 FROM cat t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query
1.53 ms
(0.08%) 		1 
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 16 ORDER BY c0_.prior DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.08 ms
(0.06%) 		1 
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.short AS short_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.spec AS spec_10, t0.newlabel AS newlabel_11, t0.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18, t0.pic AS pic_19 FROM cat t0 WHERE t0.cat = ? AND t0.visible = ? ORDER BY t0.prior DESC
Parameters: 
[
  0
  1
]
View formatted query    View runnable query    Explain query
0.97 ms
(0.05%) 		2 
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: 
[
  "catalog/pop/cat-16-biser"
]
View formatted query    View runnable query    Explain query
0.85 ms
(0.04%) 		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 = 315 AND c0_.id IN (16144, 16152, 16386, 16158, 16158, 16158, 16141, 16141, 16141, 16104, 16230, 16158, 16104, 16117, 16101, 16141, 16144, 16144, 16144, 16144, 16166, 16144, 16144, 16158, 16158, 16117, 16141, 16141, 16141, 16127, 16127, 16127, 16127, 16141, 16158, 16141, 16212, 16104, 16144, 16141, 16158, 16386, 16386, 16144, 16127, 16127, 16166, 16166, 16141, 16141, 16144, 16166, 16158, 16127, 16127, 16104, 16158, 16158, 16106, 14274, 13623, 16127, 16127, 16144, 16144, 16144, 16144, 16144, 16141, 16127, 16122, 16144, 16127, 16127, 16144, 16141, 16127, 16212, 16212, 16141, 16127, 16117, 16152, 16152, 16152, 13623, 14273, 16158, 16122, 16122, 16158, 16144, 16144, 16144, 16144, 16144, 16144, 16144, 16127, 16106, 16106, 16106, 16230, 16117, 16101, 16101, 16101, 16171, 16171, 16171, 16171, 16144, 16144, 16144, 16144, 16122, 16122, 16122, 16144, 16166, 16160, 16152, 16386, 16144, 16101, 16171, 16212, 16212, 16141, 16158, 16144, 16101, 16106, 16158, 16158, 16386, 16101, 16122, 16106, 16122, 16127, 16386, 16106, 16212, 16101, 16106, 16097, 16171, 16101, 16158, 16101, 16144, 16152, 16144, 24994, 16127, 16127, 16127, 16144, 16144, 16144, 16144, 16101, 16166, 16127, 16127, 16144, 16144, 16144, 16144, 16144, 16144, 16127, 16144, 16171) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.72 ms
(0.04%) 		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 (646, 12788, 12306, 638, 629, 638, 635, 635, 635, 12306, 12788, 646, 635, 638, 638, 634, 646, 12306, 638, 12788, 638, 631, 631, 638, 638, 629, 629, 629, 629, 631, 631, 634, 629, 12788, 638, 635, 631, 12306, 638, 638, 638, 12306, 12306, 634, 629, 635, 631, 631, 635, 629, 629, 635, 12306, 629, 631, 12306, 12306, 12788, 634, 635, 631, 12306, 635, 638, 638, 12306, 629, 631, 631, 629, 12788, 634, 635, 638, 634, 634, 635, 631, 631, 634, 638, 12788, 634, 634, 629, 635, 635, 629, 646, 631, 12788, 634, 638, 635, 635, 638, 631, 629, 634, 629, 629, 629, 634, 12788, 631, 629, 646, 635, 12788, 631, 634, 638, 638, 638, 646, 631, 631, 638, 638, 635, 12306, 12306, 634, 638, 631, 631, 631, 631, 634, 12306, 635, 638, 635, 631, 629, 631, 629, 631, 12306, 12788, 12306, 12306, 635, 12306, 634, 12788, 12788, 12306, 629, 629, 631, 629, 631, 12788, 638, 12788, 631, 12788, 629, 638, 635, 638, 631, 631, 12788, 631, 629, 638, 635, 635, 635, 635, 638, 629, 12788, 12306, 631, 635) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.71 ms
(0.04%) 		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: 
[
  298
  309
  312
  270
  287
  274
  279
  272
  283
  288
  284
  315
  314
  297
  281
  311
  310
  316
  401
  402
  408
]
View formatted query    View runnable query    Explain query
0.66 ms
(0.03%) 		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 = 298 AND c0_.id IN (13620, 13620, 13620, 13620, 16934, 678, 678, 678, 678, 678, 27280) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.64 ms
(0.03%) 		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 = 288 AND c0_.id IN (561, 572, 13107, 477, 138, 477, 75, 75, 562, 237, 572, 561, 75, 477, 477, 550, 339, 237, 477, 198, 477, 338, 338, 477, 340, 138, 23, 23, 23, 16, 3449, 16, 23, 198, 340, 75, 16, 237, 477, 340, 477, 237, 13107, 550, 23, 75, 338, 338, 75, 23, 23, 75, 237, 23, 338, 237, 237, 572, 550, 75, 338, 237, 75, 340, 477, 237, 23, 47, 338, 23, 572, 550, 75, 340, 550, 550, 75, 16, 16, 550, 340, 572, 550, 550, 23, 13778, 75, 138, 339, 338, 572, 550, 340, 75, 75, 614, 47, 23, 550, 23, 23, 23, 550, 572, 338, 138, 561, 75, 198, 47, 550, 477, 477, 340, 339, 338, 47, 340, 340, 75, 237, 237, 206, 340, 338, 338, 16, 16, 550, 237, 75, 477, 75, 338, 23, 667, 23, 338, 237, 572, 237, 237, 75, 237, 550, 572, 198, 237, 23, 138, 47, 138, 338, 572, 340, 572, 16, 198, 23, 340, 75, 477, 47, 338, 572, 16, 23, 340, 75, 75, 75, 75, 477, 23, 572, 237, 16, 3427) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.50 ms
(0.03%) 		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 = 316 AND c0_.id IN (13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 60592, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 60592, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 60592, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 60592, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 60592, 60592, 60592, 13619, 60592, 60592, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619, 13619) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.47 ms
(0.02%) 		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 (16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 13617, 13617, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 13617, 13617, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16933, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 16096, 13617, 16933, 16096) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.46 ms
(0.02%) 		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 = 287 AND c0_.id IN (81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 16930, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 3085, 81, 81) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.44 ms
(0.02%) 		1 
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: 
[]
View formatted query    View runnable query    Explain query
0.35 ms
(0.02%) 		1 
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 0 ORDER BY c0_.prior DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.33 ms
(0.02%) 		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.31 ms
(0.02%) 		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 = 283 AND c0_.id IN (668, 16143, 16143, 16143, 16143, 16099, 28356, 685) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.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 (175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175, 175) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.18 ms
(0.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 = 274 AND c0_.id IN (12807, 12807, 12807, 12807, 12807, 12807) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters: 
[]
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\Char No errors.
App\Entity\Cube No errors.
App\Entity\Block No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
App\Entity\Translation\BlockTranslation No errors.
App\Entity\Wishlist No errors.
App\Entity\Catchar No errors.
App\Entity\Charval No errors.
App\Entity\PagePhoto No errors.
App\Entity\PageBlock No errors.
App\Entity\Translation\PageTranslation No errors.
App\Entity\Translation\CatTranslation No errors.
App\Entity\Translation\CharTranslation No errors.
App\Entity\Translation\CharvalTranslation No errors.