Query Metrics
16
Database Queries
12
Different statements
7.43 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.18 ms (42.80%) |
5 |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
9378
]
|
0.81 ms (10.85%) |
1 |
SELECT * FROM MEMBER WHERE MEMB_ID = ?
Parameters:
[
9378
]
|
0.57 ms (7.72%) |
1 |
SELECT * FROM MEMBER_POSITION MP LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID WHERE MEMB_ID = ?
Parameters:
[
9378
]
|
0.48 ms (6.48%) |
1 |
/* Username */ SELECT * FROM MEMBER WHERE MEMB_ID = ?
Parameters:
[
"9378"
]
|
0.45 ms (5.99%) |
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.31 ms (4.13%) |
1 |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
25
]
|
0.30 ms (4.00%) |
1 |
SELECT * FROM CLEARANCE WHERE CLEA_ID IN (?)
Parameters:
[
2
]
|
0.29 ms (3.86%) |
1 |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
2
]
|
0.27 ms (3.64%) |
1 |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 45 9378 ] |
0.27 ms (3.60%) |
1 |
SELECT MEMB_ID FROM COOKIE WHERE COOK_TOKEN = '712b09d88786bc5e6d6ff268c72ae87f2f9b540f77feaca8e86ccc762f6de533';
Parameters:
[] |
0.26 ms (3.46%) |
1 |
SELECT * FROM MEMBER WHERE MEMB_ID = '9378';
Parameters:
[] |
0.26 ms (3.46%) |
1 |
SELECT * FROM STATUS WHERE STAT_ID IN (?)
Parameters:
[
1
]
|
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.