Query Metrics
16
Database Queries
12
Different statements
84.20 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
25.15 ms (29.87%) |
1 |
/* Username */ SELECT * FROM MEMBER WHERE MEMB_ID = ?
Parameters:
[
"9378"
]
|
23.04 ms (27.37%) |
5 |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
9378
]
|
14.83 ms (17.61%) |
1 |
SELECT * FROM STATUS WHERE STAT_ID IN (?)
Parameters:
[
1
]
|
6.46 ms (7.67%) |
1 |
SELECT MEMB_ID FROM COOKIE WHERE COOK_TOKEN = '712b09d88786bc5e6d6ff268c72ae87f2f9b540f77feaca8e86ccc762f6de533';
Parameters:
[] |
5.27 ms (6.26%) |
1 |
SELECT * FROM MEMBER_POSITION MP LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID WHERE MEMB_ID = ?
Parameters:
[
9378
]
|
3.10 ms (3.68%) |
1 |
SELECT * FROM MEMBER WHERE MEMB_ID = ?
Parameters:
[
9378
]
|
2.99 ms (3.55%) |
1 |
SELECT * FROM CLEARANCE WHERE CLEA_ID IN (?)
Parameters:
[
2
]
|
1.42 ms (1.68%) |
1 |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
2
]
|
0.98 ms (1.16%) |
1 |
SELECT ACCESS.ACKY_ID AS ACKY_ID, ACKY_DESC, ACKY_KEY, ACCS_VALUE, ACKY_CATEGORY, ACKY_MAXVAL, POSI_ID FROM ACCESS LEFT JOIN ACCESS_KEY ON ACCESS.ACKY_ID = ACCESS_KEY.ACKY_ID WHERE POSI_ID IN (?)
Parameters:
[
45
]
|
0.43 ms (0.52%) |
1 |
SELECT * FROM MEMBER WHERE MEMB_ID = '9378';
Parameters:
[] |
0.27 ms (0.32%) |
1 |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
25
]
|
0.26 ms (0.31%) |
1 |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 45 9378 ] |
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|
Entities Mapping
No loaded entities.