Query Metrics
159
Database Queries
41
Different statements
313.15 ms
Query time
0
Invalid entities
0
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 10.72 ms |
SELECT * FROM MEMBER WHERE MEMB_ID = ?
Parameters:
[
41
]
|
2 | 7.92 ms |
SELECT * FROM CLEARANCE WHERE CLEA_ID IN (?)
Parameters:
[
4
]
|
3 | 8.13 ms |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
41
]
|
4 | 16.39 ms |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
41
]
|
5 | 23.96 ms |
SELECT MEMB_ID FROM COOKIE WHERE COOK_TOKEN = '7868ea4a49709df3f996ea04e877bbd53b2ee52c08f672e6bb75b58b90c8a827';
Parameters:
[] |
6 | 2.92 ms |
SELECT * FROM MEMBER WHERE MEMB_ID = '41';
Parameters:
[] |
7 | 20.22 ms |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
41
]
|
8 | 0.40 ms |
/* Username */ SELECT * FROM MEMBER WHERE MEMB_ID = ?
Parameters:
[
"41"
]
|
9 | 13.37 ms |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
41
]
|
10 | 49.25 ms |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
41
]
|
11 | 0.53 ms |
SELECT * FROM SECUREPAGE WHERE SEPA_PAGE = ?
Parameters:
[
"irms/profile"
]
|
12 | 0.25 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
9
]
|
13 | 0.20 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
12
]
|
14 | 0.33 ms |
SELECT * FROM MEMBER_POSITION MP LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID WHERE MEMB_ID = ?
Parameters:
[
41
]
|
15 | 0.19 ms |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
2
]
|
16 | 0.20 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
25
]
|
17 | 0.17 ms |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
9
]
|
18 | 0.56 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
30
]
|
19 | 0.17 ms |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
10
]
|
20 | 0.19 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
41
]
|
21 | 2.24 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
24
]
|
22 | 0.20 ms |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
3
]
|
23 | 10.36 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
15
]
|
24 | 0.26 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
43
]
|
25 | 0.18 ms |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
16
]
|
26 | 0.19 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
47
]
|
27 | 0.17 ms |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
4
]
|
28 | 0.16 ms |
SELECT * FROM UNIT WHERE UNIT_ID IN (?)
Parameters:
[
26
]
|
29 | 0.21 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 42 41 ] |
30 | 5.96 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 48 41 ] |
31 | 0.23 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 59 41 ] |
32 | 0.20 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 40 41 ] |
33 | 0.18 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 41 41 ] |
34 | 0.17 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 60 41 ] |
35 | 0.18 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 24 41 ] |
36 | 6.11 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 63 41 ] |
37 | 0.23 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 65 41 ] |
38 | 0.19 ms |
SELECT * FROM MEMBER_POSITION WHERE POSI_ID=? AND MEMB_ID=?
Parameters:
[ 43 41 ] |
39 | 0.57 ms |
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:
[ 40 43 41 60 24 42 65 63 48 59 ] |
40 | 0.23 ms |
SELECT * FROM STATUS WHERE STAT_ID IN (?)
Parameters:
[
1
]
|
41 | 0.26 ms |
SELECT * FROM UNIT
Parameters:
[] |
42 | 0.19 ms |
SELECT * FROM UNIT
Parameters:
[] |
43 | 8.40 ms |
SELECT * FROM BRANCH
Parameters:
[] |
44 | 15.56 ms |
SELECT * FROM FORWARD_RELATION
Parameters:
[] |
45 | 3.24 ms |
SELECT * FROM SPECIALITY ORDER BY BRAN_ID ASC, SPEC_NAME ASC
Parameters:
[] |
46 | 0.87 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
12
]
|
47 | 0.81 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
13
]
|
48 | 0.77 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
11
]
|
49 | 0.76 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
15
]
|
50 | 0.75 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
10
]
|
51 | 0.74 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
14
]
|
52 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
6
]
|
53 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
7
]
|
54 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
9
]
|
55 | 0.74 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
8
]
|
56 | 0.73 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
5
]
|
57 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
22
]
|
58 | 0.73 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
20
]
|
59 | 0.75 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
16
]
|
60 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
18
]
|
61 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
24
]
|
62 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
23
]
|
63 | 0.70 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
21
]
|
64 | 0.73 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
17
]
|
65 | 2.68 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
19
]
|
66 | 0.76 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
25
]
|
67 | 1.57 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
27
]
|
68 | 4.38 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
26
]
|
69 | 0.73 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
29
]
|
70 | 0.71 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
28
]
|
71 | 9.55 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
4
]
|
72 | 3.54 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
2
]
|
73 | 0.79 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
3
]
|
74 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
1
]
|
75 | 4.53 ms |
SELECT * FROM QUALIFICATION WHERE QUAL_TYPE = ?
Parameters:
[
1
]
|
76 | 0.19 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
10
]
|
77 | 4.04 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
10
]
|
78 | 0.20 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
11
]
|
79 | 0.74 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
11
]
|
80 | 0.18 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
14
]
|
81 | 0.73 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
14
]
|
82 | 0.18 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
15
]
|
83 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
15
]
|
84 | 0.17 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
12
]
|
85 | 0.74 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
12
]
|
86 | 0.17 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
13
]
|
87 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
13
]
|
88 | 8.53 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
6
]
|
89 | 2.74 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
6
]
|
90 | 0.22 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
7
]
|
91 | 0.72 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
7
]
|
92 | 0.19 ms |
SELECT * FROM BRANCH WHERE BRAN_ID IN (?)
Parameters:
[
5
]
|
93 | 0.17 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
8
]
|
94 | 4.67 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
8
]
|
95 | 0.22 ms |
SELECT * FROM SPECIALITY WHERE SPEC_ID IN (?)
Parameters:
[
9
]
|
96 | 0.75 ms |
SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = ? ORDER BY SKCA_ORDER, SKIL_ORDER
Parameters:
[
9
]
|
97 | 0.26 ms |
SELECT * FROM BRANCH_SERVICE_HISTORY WHERE MEMB_ID = ? ORDER BY BRSE_START_DATE DESC
Parameters:
[
41
]
|
98 | 0.49 ms |
SELECT COUNT(*) as count FROM `NOTIFICATION` WHERE `NOTI_TARGET` = ? AND `NOTI_UNREAD` = ?
Parameters:
[ 41 1 ] |
99 | 0.27 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_SECURE = ? ORDER BY PACA_ORDER ASC
Parameters:
[
1
]
|
100 | 0.23 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
9
]
|
101 | 0.30 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 9 12 ] |
102 | 0.22 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
10
]
|
103 | 0.18 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
10
]
|
104 | 0.36 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 10 26 ] |
105 | 0.18 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
26
]
|
106 | 0.24 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
12
]
|
107 | 0.19 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
12
]
|
108 | 0.26 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 12 28 ] |
109 | 0.17 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
28
]
|
110 | 0.20 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
13
]
|
111 | 0.17 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
13
]
|
112 | 0.26 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 13 29 ] |
113 | 0.17 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
29
]
|
114 | 0.22 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
17
]
|
115 | 0.17 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
17
]
|
116 | 0.26 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 17 66 ] |
117 | 0.17 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
66
]
|
118 | 0.25 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
20
]
|
119 | 0.18 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
20
]
|
120 | 0.24 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 20 69 ] |
121 | 0.18 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
69
]
|
122 | 0.20 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
18
]
|
123 | 0.17 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
18
]
|
124 | 0.24 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 18 67 ] |
125 | 0.17 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
67
]
|
126 | 0.20 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
14
]
|
127 | 0.17 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
14
]
|
128 | 0.31 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 14 30 ] |
129 | 0.17 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
30
]
|
130 | 0.21 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
16
]
|
131 | 0.17 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
16
]
|
132 | 0.24 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 16 32 ] |
133 | 0.20 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
32
]
|
134 | 0.20 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = ? ORDER BY SCAT_ORDER
Parameters:
[
19
]
|
135 | 0.19 ms |
SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (?)
Parameters:
[
19
]
|
136 | 0.33 ms |
SELECT * FROM SECUREPAGE WHERE PACA_ID = ? AND SCAT_ID = ? ORDER BY SEPA_ORDER ASC
Parameters:
[ 19 68 ] |
137 | 0.28 ms |
SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (?)
Parameters:
[
68
]
|
138 | 0.25 ms |
SELECT * FROM RANK_MEMBER WHERE MEMB_ID = ? AND RAME_PRIMARY=1
Parameters:
[
41
]
|
139 | 0.21 ms |
SELECT * FROM RANK WHERE RANK_ID IN (?)
Parameters:
[
153
]
|
140 | 0.22 ms |
SELECT * FROM RANK_MEMBER WHERE RANK_ID=? AND MEMB_ID=?
Parameters:
[ 153 41 ] |
141 | 0.21 ms |
SELECT * FROM RANK_MEMBER WHERE MEMB_ID = ? AND RAME_PRIMARY=1
Parameters:
[
41
]
|
142 | 0.22 ms |
SELECT * FROM RANK_MEMBER WHERE RANK_ID=? AND MEMB_ID=?
Parameters:
[ 153 41 ] |
143 | 0.21 ms |
SELECT * FROM RANK_MEMBER WHERE MEMB_ID = ? AND RAME_PRIMARY=1
Parameters:
[
41
]
|
144 | 0.23 ms |
SELECT * FROM RANK_MEMBER WHERE RANK_ID=? AND MEMB_ID=?
Parameters:
[ 153 41 ] |
145 | 0.20 ms |
SELECT * FROM STATUS_CHANGE WHERE MEMB_ID=?
Parameters:
[
41
]
|
146 | 0.18 ms |
SELECT * FROM RACE WHERE RACE_ID IN (?)
Parameters:
[
33
]
|
147 | 0.20 ms |
SELECT * FROM STATUS_CHANGE WHERE MEMB_ID=?
Parameters:
[
41
]
|
148 | 0.21 ms |
SELECT * FROM MEMBER_LEAVE WHERE MEMB_ID=? AND MELE_STATUS<2
Parameters:
[
41
]
|
149 | 0.21 ms |
SELECT * FROM LEAVE_GRANTS WHERE MEMB_ID=?
Parameters:
[
41
]
|
150 | 1.14 ms |
SELECT * FROM IMM_ATTENDANCE WHERE MEMB_ID = ?
Parameters:
[
41
]
|
151 | 1.49 ms |
SELECT *, COUNT(*) AS COUNT FROM MEMBER_AWARD MA LEFT JOIN AWARD AW ON MA.AWAR_ID=AW.AWAR_ID WHERE MEMB_ID=? GROUP BY AW.AWAR_HIERARCHY ORDER BY AW.AWAR_HIERARCHY
Parameters:
[
41
]
|
152 | 0.29 ms |
SELECT * FROM MEMBER_AWARD WHERE AWAR_ID=? AND MEMB_ID=?
Parameters:
[ 123 41 ] |
153 | 0.22 ms |
SELECT * FROM MEMBER WHERE MEMB_ID IN (?)
Parameters:
[
41
]
|
154 | 9.79 ms |
SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = ? ORDER BY MELO_STAMP DESC LIMIT 1
Parameters:
[
41
]
|
155 | 0.25 ms |
SELECT * FROM RANK_MEMBER WHERE MEMB_ID = ?
Parameters:
[
41
]
|
156 | 0.23 ms |
SELECT * FROM RANK WHERE RANK_ID IN (?, ?)
Parameters:
[ 153 177 ] |
157 | 0.22 ms |
SELECT * FROM RANK_MEMBER WHERE RANK_ID=? AND MEMB_ID=?
Parameters:
[ 153 41 ] |
158 | 0.22 ms |
SELECT * FROM RANK_MEMBER WHERE RANK_ID=? AND MEMB_ID=?
Parameters:
[ 177 41 ] |
159 | 4.48 ms |
INSERT INTO EXCEPTION (EXCE_MESSAGE, EXCE_CONTEXT, EXCE_TRACE, EXCE_DATE) VALUES (?, ?, ?, ?)
Parameters:
[ "Impossible to access an attribute ("id") on a null variable in "irms/profile.twig" at line 279." "/home/empire/public_html/dev/application/templates/irms/profile.twig L279" """ #0 /home/empire/public_html/dev/application/var/cache/dev/twig/1b/1b665fe48b595e6dd48ef0dcc4ecfd92.php(733): Twig\Extension\CoreExtension::getAttribute(Object(Twig\Environment), Object(Twig\Source), NULL, 'id', Array, 'any', false, false, false, 279)\n #1 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(446): __TwigTemplate_bb45fb2527abe5b3caa552a1187a9777->block_content(Array, Array)\n #2 /home/empire/public_html/dev/application/var/cache/dev/twig/e5/e50238017428ce0a1087b2f0af1da4a5.php(252): Twig\Template->yieldBlock('content', Array, Array)\n #3 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(402): __TwigTemplate_035fc62eb7d90b6abd4834f1bb342155->doDisplay(Array, Array)\n #4 /home/empire/public_html/dev/application/var/cache/dev/twig/1a/1a7817790505379372e152b862a1c228.php(53): Twig\Template->yield(Array, Array)\n #5 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(402): __TwigTemplate_79dcf6ae96f2063b78d04a9ae3e60bb3->doDisplay(Array, Array)\n #6 /home/empire/public_html/dev/application/var/cache/dev/twig/1b/1b665fe48b595e6dd48ef0dcc4ecfd92.php(56): Twig\Template->yield(Array, Array)\n #7 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(402): __TwigTemplate_bb45fb2527abe5b3caa552a1187a9777->doDisplay(Array, Array)\n #8 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(358): Twig\Template->yield(Array, Array)\n #9 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(373): Twig\Template->display(Array)\n #10 /home/empire/public_html/dev/application/vendor/twig/twig/src/TemplateWrapper.php(51): Twig\Template->render(Array)\n #11 /home/empire/public_html/dev/application/vendor/twig/twig/src/Environment.php(333): Twig\TemplateWrapper->render(Array)\n #12 /home/empire/public_html/dev/application/vendor/symfony/framework-bundle/Controller/AbstractController.php(448): Twig\Environment->render('irms/profile.tw...', Array)\n #13 /home/empire/public_html/dev/application/vendor/symfony/framework-bundle/Controller/AbstractController.php(453): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView('irms/profile.tw...', NULL, Array, 'render')\n #14 /home/empire/public_html/dev/application/vendor/symfony/framework-bundle/Controller/AbstractController.php(253): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender('irms/profile.tw...', NULL, Array, NULL, 'render')\n #15 /home/empire/public_html/dev/application/src/Controller/IRMS/ProfileController.php(49): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render('irms/profile.tw...', Array)\n #16 /home/empire/public_html/dev/application/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\IRMS\ProfileController->profile(0, 0)\n #17 /home/empire/public_html/dev/application/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)\n #18 /home/empire/public_html/dev/application/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)\n #19 /home/empire/public_html/dev/index.php(33): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))\n #20 {main} """ 1751921168 ] |
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.