https://dev.swc-empire.com/api/position/40/0.jpg

Query Metrics

7 Database Queries
7 Different statements
19.44 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.29 ms
(32.35%)
1
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 41 ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[]
5.99 ms
(30.79%)
1
SELECT * FROM MEMBER_POSITION WHERE POSI_ID = 40
Parameters:
[]
3.59 ms
(18.45%)
1
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 76 ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[]
1.87 ms
(9.60%)
1
SELECT * FROM POSITION WHERE POSI_ID IN (?)
Parameters:
[
  [
    "40"
  ]
]
0.87 ms
(4.48%)
1
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
  [
    "24"
  ]
]
0.45 ms
(2.34%)
1
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
  [
    "2"
  ]
]
0.39 ms
(2.00%)
1
SELECT * FROM MEMBER WHERE MEMB_ID IN (?)
Parameters:
[
  [
    "41"
    "76"
  ]
]

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

No loaded entities.