Query Metrics
8
Database Queries
8
Different statements
7.94 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.06 ms |
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[] |
2 | 0.47 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 | 1.04 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
]
|
4 | 1.96 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 = '493' and c.search > 0 group by c.id order by c.prior desc
Parameters:
[] |
5 | 0.51 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:
[ 270 309 278 ] |
6 | 0.63 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 (5, 5, 5, 58, 5, 5, 58, 5, 5, 58, 5, 1, 159, 15, 1, 15, 15, 1) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
7 | 1.14 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, 653, 653, 653, 653, 653, 653, 653, 653, 653, 12788, 12788, 12821, 653, 12821, 653, 653, 653, 653, 653, 653, 653, 12821, 653, 12788, 12821, 653, 12788, 12821, 653, 12821, 12821, 653, 634, 653, 653, 653, 653, 653, 653, 653, 653, 12821, 12788, 653, 653, 653, 653, 653, 653, 653, 653, 653, 653, 653, 653, 653, 653, 653, 12821, 653, 653, 653, 653, 653, 653, 653, 653, 653, 12821, 12788, 646, 635, 646, 631, 631, 646, 629, 638, 12306, 12788, 635, 629, 631, 12306, 653, 653, 12306, 12788, 634, 12306, 12306, 12306, 12306, 653, 12306, 12306, 12306, 12306, 12306, 12306, 629, 12306, 12306, 653, 12306, 12306, 12788, 653, 653, 653, 653, 653, 653, 653, 653, 653, 653, 12788, 12306, 12306, 12306, 12306, 12306, 12306, 653, 12306, 12306, 12788, 12306, 629, 631, 638, 629, 12788, 12306, 638) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
8 | 1.15 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 = 278 AND c0_.id IN (870, 6659, 21, 769, 1114, 31217, 31217, 870, 769, 1114, 1114, 769, 31217, 420, 769, 420, 1114, 769, 21, 769, 420, 1114, 31217, 420, 420, 420, 769, 769, 769, 31217, 420, 769, 870, 21, 6659, 870, 31217, 31217, 1114, 870, 870, 6659, 870, 21, 420, 1114, 1114, 769, 1114, 1114, 420, 21, 769, 6659, 6659, 769, 1114, 31217, 1114, 6659, 57577, 870, 870, 420, 769, 31217, 870, 769, 769, 21, 21, 21, 1114, 1114, 1114, 1114, 1114, 1114, 1114, 769, 769, 420, 420, 769, 870, 420, 21, 21, 1114, 769, 21, 769, 1114, 769, 21, 870, 420, 769, 769, 769, 769, 769, 769, 769, 769, 31217, 769, 870, 20674, 1114, 420, 6659, 2696, 20674, 2696, 2696, 1114, 6679, 31217, 6739, 19800, 20674, 870, 420, 19458, 19458, 19458, 19458, 19458, 19458, 19458, 19458, 19458) 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.