Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 195
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Configuration

Query Metrics

SELECT * FROM MEMBER WHERE MEMB_ID = ?

[
  9378
]

SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID = ?

SELECT * FROM MEMBER WHERE MEMB_ID = 9378;

SELECT * FROM CLEARANCE WHERE CLEA_ID IN (?)

[
  2
]

SELECT
  *
FROM
  CLEARANCE
WHERE
  CLEA_ID IN (?)

SELECT * FROM CLEARANCE WHERE CLEA_ID IN (2);

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1

[
  9378
]

SELECT
  MELO_STAMP
FROM
  MEMBER_LOGIN
WHERE
  MEMB_ID = ?
ORDER BY
  MELO_STAMP DESC
LIMIT
  1

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 9378 ORDER BY MELO_STAMP DESC LIMIT 1;

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1

[
  9378
]

SELECT
  MELO_STAMP
FROM
  MEMBER_LOGIN
WHERE
  MEMB_ID = ?
ORDER BY
  MELO_STAMP DESC
LIMIT
  1

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 9378 ORDER BY MELO_STAMP DESC LIMIT 1;

SELECT MEMB_ID FROM COOKIE WHERE COOK_TOKEN = '712b09d88786bc5e6d6ff268c72ae87f2f9b540f77feaca8e86ccc762f6de533';

[]

SELECT
  MEMB_ID
FROM
  COOKIE
WHERE
  COOK_TOKEN = '712b09d88786bc5e6d6ff268c72ae87f2f9b540f77feaca8e86ccc762f6de533';

SELECT MEMB_ID FROM COOKIE WHERE COOK_TOKEN = '712b09d88786bc5e6d6ff268c72ae87f2f9b540f77feaca8e86ccc762f6de533';;

SELECT * FROM MEMBER WHERE MEMB_ID = '9378';

[]

SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID = '9378';

SELECT * FROM MEMBER WHERE MEMB_ID = '9378';;

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1

[
  9378
]

SELECT
  MELO_STAMP
FROM
  MEMBER_LOGIN
WHERE
  MEMB_ID = ?
ORDER BY
  MELO_STAMP DESC
LIMIT
  1

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 9378 ORDER BY MELO_STAMP DESC LIMIT 1;

/* Username */ SELECT * FROM MEMBER WHERE MEMB_ID = ?

[
  "9378"
]

/* Username */
SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID = ?

/* Username */ SELECT * FROM MEMBER WHERE MEMB_ID = '9378';

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1

[
  9378
]

SELECT
  MELO_STAMP
FROM
  MEMBER_LOGIN
WHERE
  MEMB_ID = ?
ORDER BY
  MELO_STAMP DESC
LIMIT
  1

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 9378 ORDER BY MELO_STAMP DESC LIMIT 1;

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1

[
  9378
]

SELECT
  MELO_STAMP
FROM
  MEMBER_LOGIN
WHERE
  MEMB_ID = ?
ORDER BY
  MELO_STAMP DESC
LIMIT
  1

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 9378 ORDER BY MELO_STAMP DESC LIMIT 1;

SELECT * FROM MEMBER_POSITION MP LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID WHERE MEMB_ID = ?

[
  9378
]

SELECT
  *
FROM
  MEMBER_POSITION MP
  LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID
WHERE
  MEMB_ID = ?

SELECT * FROM MEMBER_POSITION MP LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID WHERE MEMB_ID = 9378;

SELECT * FROM BRANCH WHERE BRAN_ID IN (?)

[
  2
]

SELECT
  *
FROM
  BRANCH
WHERE
  BRAN_ID IN (?)

SELECT * FROM BRANCH WHERE BRAN_ID IN (2);

SELECT * FROM UNIT WHERE UNIT_ID IN (?)

[
  25
]

SELECT
  *
FROM
  UNIT
WHERE
  UNIT_ID IN (?)

SELECT * FROM UNIT WHERE UNIT_ID IN (25);

SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?

[
  45
  9378
]

SELECT
  *
FROM
  MEMBER_POSITION
WHERE
  POSI_ID = ?
  AND MEMB_ID = ?

SELECT * FROM MEMBER_POSITION WHERE POSI_ID=45 AND MEMB_ID=9378;

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 (?)

[
  45
]

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 (?)

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 (45);

SELECT * FROM STATUS WHERE STAT_ID IN (?)

[
  1
]

SELECT
  *
FROM
  STATUS
WHERE
  STAT_ID IN (?)

SELECT * FROM STATUS WHERE STAT_ID IN (1);