Query Metrics
11
Database Queries
11
Different statements
40.58 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
13.42 ms (33.08%) |
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 (539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 64136, 64136, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 537, 537, 537, 539, 539, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 539, 64136, 539, 539, 539, 539, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 537, 539, 64136, 539, 537, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 64136, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 64136, 539, 539, 539, 539, 539, 539, 539, 539, 539, 64136, 539, 64136, 539, 537, 539, 539, 539, 539, 539, 539, 539, 537, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 537, 539, 537, 537, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 539, 64136, 539, 539, 64136, 64136, 539, 539, 64136, 64136, 64136, 64136, 64136, 539, 64136, 64136, 539, 64136, 539, 539, 539, 64136, 539, 539, 539, 539, 539, 539, 539, 539, 539, 537, 539, 64136, 539, 539, 64136, 64136, 539, 539, 64136, 539, 64136, 539, 64136, 64136, 539, 64136, 64136, 64136, 539, 64136, 64136, 64136, 64136, 539, 539, 539, 539, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 539, 539, 539, 539, 539, 539, 64136, 64136, 64136, 64136, 64136, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 539, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 64136, 539, 64136, 539, 539, 539, 64136, 539, 539, 64136, 64136, 64136, 64136, 539, 539, 64136, 64136, 64136, 539, 539, 539, 539, 539, 64136, 539, 539, 64136, 64136, 539, 539, 64136, 539, 64136, 539, 64136, 64136, 539, 64136, 539, 64136, 539, 64136, 64136, 64136, 64136, 539, 64136, 64136, 539, 539, 539, 64136) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
11.52 ms (28.40%) |
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 (634, 629, 629, 638, 638, 646, 635, 631, 634, 629, 631, 653, 646, 638, 634, 635, 631, 631, 631, 631, 635, 635, 635, 635, 638, 638, 631, 635, 638, 638, 646, 635, 12306, 634, 638, 631, 631, 12821, 631, 629, 638, 629, 631, 638, 638, 629, 631, 631, 653, 634, 631, 12788, 634, 638, 12788, 631, 635, 635, 631, 12788, 631, 12788, 629, 646, 638, 638, 653, 631, 634, 629, 629, 631, 629, 634, 12788, 653, 12788, 12788, 631, 638, 635, 638, 631, 12788, 638, 634, 12788, 634, 12788, 634, 634, 631, 631, 635, 12788, 638, 638, 629, 634, 646, 12788, 12788, 638, 12788, 646, 638, 12788, 629, 638, 629, 638, 653, 634, 631, 646, 12788, 634, 631, 634, 629, 12788, 12788, 653, 12821, 631, 631, 629, 638, 631, 629, 631, 631, 12788, 634, 12788, 629, 629, 638, 12306, 638, 629, 12788, 629, 12788, 12788, 635, 638, 629, 635, 635, 635, 629, 634, 631, 638, 629, 629, 653, 646, 653, 653, 12788, 12788, 638, 12821, 12821, 629, 12821, 635, 634, 12821, 12821, 634, 631, 634, 638, 635, 638, 629, 629, 634, 634, 635, 629, 638, 631, 629, 638, 635, 12821, 634, 12821, 635, 629, 629, 629, 12788, 12788, 635, 638, 631, 638, 638, 638, 638, 638, 653, 653, 653, 653, 653, 646, 646, 638, 12788, 638, 631, 12788, 634, 634, 653, 638, 638, 638, 629, 629, 12788, 12788, 631, 631, 631, 631, 631, 631, 638, 638, 638, 629, 12788, 12788, 12788, 12788, 635, 635, 12821, 653, 638, 653, 653, 629, 635, 631, 12821, 646, 629, 629, 631, 638, 12821, 629, 629, 638, 635, 629, 631, 629, 12821, 638, 638, 631, 634, 629, 12821, 12788, 638, 646, 635, 638, 629, 631, 631, 634, 12821, 638, 638, 634, 629, 635, 631, 629, 629, 629, 12821, 629, 631, 635, 629, 638, 631, 631, 646, 12788, 638, 12821, 635, 629, 635, 631, 12788, 629, 12306, 12788, 12788, 12306, 12306, 653, 629, 638, 629, 12306, 631, 635, 631, 638, 629, 629, 629, 12788, 629, 635, 635, 629, 638, 12788, 638, 634, 631, 653, 635, 634, 629, 653, 12788, 646, 629, 638, 638, 634, 12788, 12306, 629, 12788, 635, 646, 629, 653, 638, 12788, 12788) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
9.48 ms (23.36%) |
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 (18676, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 14803, 14803, 15347, 14803, 15347, 15347, 15347, 15347, 14803, 14803, 14803, 14803, 14803, 14803, 15347, 14803, 14803, 14803, 14803, 14803, 14803, 14803, 14803, 18676, 18676, 18676, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 18463, 15347, 15347, 15347, 57093, 15347, 57093, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 14824, 15347, 15347, 18674, 18674, 18674, 18674, 18461, 18461, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 57093, 15347, 15347, 57093, 15347, 15347, 15347, 18676, 15347, 15347, 18674, 18674, 18063, 18063, 18461, 18461, 18461, 18674, 18674, 15347, 18461, 18461, 15347, 12946, 15347, 15347, 15347, 15347, 15347, 14824, 14824, 14824, 15347, 15347, 15347, 15347, 15347, 57093, 15347, 12954, 18676, 18676, 15347, 15347, 15347, 57093, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18674, 18674, 18674, 18674, 18676, 18676, 12947, 57093, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 15347, 15347, 15347, 12947, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 15347, 12947, 12947, 15347, 15347, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 12947, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 18676, 15347, 15347, 15347, 15347, 15347, 18676, 15347, 18676, 18676, 18676, 18676, 18676, 15347, 18676, 18676, 18674, 15517, 12947) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
1.28 ms (3.15%) |
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 = '430' and c.search > 0 group by c.id order by c.prior desc
Parameters:
[] |
1.15 ms (2.83%) |
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 (551, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 547, 19207, 551, 551, 547, 551, 551, 547, 551, 547, 551, 551, 547, 547, 547, 547, 547, 551, 551, 547, 547, 547, 551, 547, 551, 29865, 551, 29865, 547, 24878, 24878, 19207, 547, 19207, 551, 551, 24878, 551, 547, 551, 19207, 24878, 19207, 551, 547, 29865, 547, 547, 29865, 29865, 29865, 19207, 547, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 29865, 24878, 29865, 547, 29865, 547, 19207, 19207, 19207, 29865, 24878, 19207, 24878, 24878, 24878, 547, 19207, 19207, 547, 19207, 24878, 547, 24878, 547, 551, 24878, 547, 29865, 547, 24878, 547, 29865, 24878, 24878, 547, 29865, 547, 547, 547, 19207, 29865, 29865, 19207, 19207, 19207, 29865, 29865, 29865, 551, 29865, 29866, 29866, 551, 551, 29865, 29865, 547, 29865, 551, 29866, 24878, 24878, 24878, 24878, 19207, 547, 547, 547, 29865, 29866, 29866, 547, 29865, 551, 551, 547, 19207, 547, 24878, 19207, 24878, 19207, 29865, 547, 547, 547, 547, 29866, 29866, 29866, 29865, 29865, 29865, 29865, 24878, 547, 547, 551, 29865, 551, 29866, 29865, 19207, 29865, 29865, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 19207, 551, 547, 551, 547, 19207, 19207, 547, 547, 19207, 19207, 19207, 19207, 19207, 547, 19207, 19207, 547, 19207, 547, 547, 551, 19207, 551, 551, 551, 547, 19207, 19207, 19207, 19207, 19207, 29866, 547, 24878, 551, 551, 24878, 24878, 551, 551, 24878, 547, 19207, 547, 24878, 24878, 547, 19207, 19207, 19207, 547, 24878, 19207, 19207, 24878, 29865, 551, 551, 551, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 19207, 19207, 19207, 19207, 19207, 551, 19207, 19207, 19207, 19207, 19207, 551, 547, 547, 547, 547, 547, 547, 547, 547, 547, 547, 551, 551, 551, 551, 551, 551, 551, 551, 551, 19207, 19207, 547, 547, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 24878, 29865, 19207, 547, 24878, 547, 19207, 29865, 547, 19207, 19207, 24878, 24878, 547, 547, 19207, 19207, 19207, 547, 551, 551, 551, 547, 19207, 547, 547, 19207, 19207, 19207, 19207, 24878, 19207, 24878, 19207, 24878, 24878, 551, 24878, 547, 19207, 19207, 24878, 24878, 24878, 24878, 19207, 24878, 19207, 547, 19207, 19207, 24878) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
1.04 ms (2.56%) |
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 (654, 576, 576, 576, 576, 576, 576, 576, 576, 576, 654, 576, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 81, 654, 654, 68, 654, 640, 654, 654, 654, 81, 81, 81, 81, 81, 81, 81, 654, 81, 576, 576, 576, 576, 576, 576, 576, 576, 68, 576, 68, 68, 81, 654, 576, 576, 576, 1088, 576, 81, 576, 576, 576, 81, 640, 81, 654, 654, 654, 654, 654, 654, 654, 654, 81, 81, 81, 654, 654, 81, 654, 654, 654, 654, 654, 81, 68, 576, 68, 68, 576, 576, 576, 81, 81, 654, 654, 654, 81, 81, 593, 593, 68, 68, 654, 654, 654, 81, 640, 654, 654, 640, 654, 654, 654, 654, 305, 68, 68, 68, 81, 81, 81, 654, 654, 654, 576, 576, 576, 81, 1088, 576, 576, 576, 576, 593, 593, 593, 81, 81, 81, 81, 654, 654, 654, 654, 654, 68, 68, 81, 81, 81, 81, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 81, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 81, 81, 81, 81, 81, 81, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 81, 576, 576, 576, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 81, 18861, 18861, 18861, 18861, 18861, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 576, 576, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 654, 576, 576, 576, 576, 576, 576, 654, 654, 81, 654, 654, 654, 576, 654, 654, 654, 654, 576, 654, 654, 654, 576, 81, 654) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
0.95 ms (2.33%) |
1 |
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[] |
0.54 ms (1.32%) |
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 = 279 AND c0_.id IN (586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586, 586) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
0.50 ms (1.24%) |
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
]
|
0.35 ms (0.87%) |
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 274 279 287 298 315 ] |
0.34 ms (0.85%) |
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:
[] |
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.