stavatar,
Делать демку 30 минут, а вы много говорите. Вторую страницу. /
Уже второй раз пытаюсь прислать .
Я убрал почти все лишние поля
Вот если добавить пост
select
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:31:28.556 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:31:28.557 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:31:28.558 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:31:28.560 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:31:28.561 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.563 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:31:28.563 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.567 INFO 16192 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter : do filter...
2021-03-09 10:31:28.568 INFO 16192 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 10:31:28.571 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:31:28.571 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:31:28.572 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:31:28.573 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:31:28.574 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:31:28.574 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.577 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:31:28.577 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.603 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:31:28.604 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:31:28.606 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:31:28.606 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:31:28.608 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:31:28.608 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.611 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:31:28.612 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.638 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
select
nextval ('posts_id_seq')
Hibernate:
select
nextval ('posts_id_seq')
2021-03-09 10:31:28.666 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
insert
into
posts
(title, id)
values
(?, ?)
Hibernate:
insert
into
posts
(title, id)
values
(?, ?)
2021-03-09 10:31:28.667 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [TITLEE1]
2021-03-09 10:31:28.667 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [2]
2021-03-09 10:31:28.668 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL :
insert
into
users_posts
(user_id, post_id)
values
(?, ?)
Hibernate:
insert
into
users_posts
(user_id, post_id)
values
(?, ?)
2021-03-09 10:31:28.668 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.668 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [2]
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.
694.
695.
696.
697.
698.
699.
700.
701.
702.
703.
704.
705.
706.
707.
708.
709.
710.
711.
712.
713.
714.
715.
716.
717.
718.
719.
720.
721.
722.
723.
724.
725.
726.
727.
728.
729.
730.
731.
732.
733.
734.
2021-03-09 10:33:12.209 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:33:12.210 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:33:12.211 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:33:12.212 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.213 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:33:12.214 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.216 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listcommen0_.comment_id as comment_2_4_0_,
listcommen0_.post_id as post_id3_4_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
users2_.id as id1_5_2_,
users2_.login as login2_5_2_,
users2_.password as password3_5_2_,
users2_.position_id as position4_5_2_,
position3_.id as id1_2_3_,
position3_.description as descript2_2_3_,
position3_.name as name3_2_3_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
users users2_
on comments1_2_.user_id=users2_.id
left outer join
position position3_
on users2_.position_id=position3_.id
where
listcommen0_.comment_id=?
Hibernate:
select
listcommen0_.comment_id as comment_2_4_0_,
listcommen0_.post_id as post_id3_4_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
users2_.id as id1_5_2_,
users2_.login as login2_5_2_,
users2_.password as password3_5_2_,
users2_.position_id as position4_5_2_,
position3_.id as id1_2_3_,
position3_.description as descript2_2_3_,
position3_.name as name3_2_3_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
users users2_
on comments1_2_.user_id=users2_.id
left outer join
position position3_
on users2_.position_id=position3_.id
where
listcommen0_.comment_id=?
2021-03-09 10:33:12.216 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.219 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:33:12.220 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.224 INFO 16192 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter : do filter...
2021-03-09 10:33:12.225 INFO 16192 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 10:33:12.227 INFO 16192 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter : !!test
2021-03-09 10:33:12.228 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:33:12.229 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:33:12.230 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:33:12.230 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.231 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:33:12.231 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.233 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listcommen0_.comment_id as comment_2_4_0_,
listcommen0_.post_id as post_id3_4_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
users2_.id as id1_5_2_,
users2_.login as login2_5_2_,
users2_.password as password3_5_2_,
users2_.position_id as position4_5_2_,
position3_.id as id1_2_3_,
position3_.description as descript2_2_3_,
position3_.name as name3_2_3_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
users users2_
on comments1_2_.user_id=users2_.id
left outer join
position position3_
on users2_.position_id=position3_.id
where
listcommen0_.comment_id=?
Hibernate:
select
listcommen0_.comment_id as comment_2_4_0_,
listcommen0_.post_id as post_id3_4_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
users2_.id as id1_5_2_,
users2_.login as login2_5_2_,
users2_.password as password3_5_2_,
users2_.position_id as position4_5_2_,
position3_.id as id1_2_3_,
position3_.description as descript2_2_3_,
position3_.name as name3_2_3_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
users users2_
on comments1_2_.user_id=users2_.id
left outer join
position position3_
on users2_.position_id=position3_.id
where
listcommen0_.comment_id=?
2021-03-09 10:33:12.234 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.237 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:33:12.238 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.243 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:33:12.243 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:33:12.244 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:33:12.244 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.246 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:33:12.246 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.248 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listcommen0_.comment_id as comment_2_4_0_,
listcommen0_.post_id as post_id3_4_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
users2_.id as id1_5_2_,
users2_.login as login2_5_2_,
users2_.password as password3_5_2_,
users2_.position_id as position4_5_2_,
position3_.id as id1_2_3_,
position3_.description as descript2_2_3_,
position3_.name as name3_2_3_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
users users2_
on comments1_2_.user_id=users2_.id
left outer join
position position3_
on users2_.position_id=position3_.id
where
listcommen0_.comment_id=?
Hibernate:
select
listcommen0_.comment_id as comment_2_4_0_,
listcommen0_.post_id as post_id3_4_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
users2_.id as id1_5_2_,
users2_.login as login2_5_2_,
users2_.password as password3_5_2_,
users2_.position_id as position4_5_2_,
position3_.id as id1_2_3_,
position3_.description as descript2_2_3_,
position3_.name as name3_2_3_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
users users2_
on comments1_2_.user_id=users2_.id
left outer join
position position3_
on users2_.position_id=position3_.id
where
listcommen0_.comment_id=?
2021-03-09 10:33:12.248 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.250 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:33:12.251 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.254 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
select
nextval ('posts_id_seq')
Hibernate:
select
nextval ('posts_id_seq')
2021-03-09 10:33:12.257 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
insert
into
posts
(title, id)
values
(?, ?)
Hibernate:
insert
into
posts
(title, id)
values
(?, ?)
2021-03-09 10:33:12.258 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [TITLEE1]
2021-03-09 10:33:12.258 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [3]
2021-03-09 10:33:12.258 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL :
insert
into
users_posts
(user_id, post_id)
values
(?, ?)
Hibernate:
insert
into
users_posts
(user_id, post_id)
values
(?, ?)
2021-03-09 10:33:12.259 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.259 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [3]
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.
694.
695.
696.
697.
698.
699.
700.
701.
702.
703.
704.
705.
706.
707.
708.
709.
710.
711.
712.
713.
714.
715.
716.
717.
718.
719.
720.
721.
722.
723.
724.
725.
726.
727.
728.
729.
730.
731.
732.
733.
734.
735.
736.
737.
738.
739.
740.
741.
742.
743.
744.
745.
746.
747.
748.
749.
750.
751.
752.
753.
754.
755.
756.
757.
758.
759.
760.
761.
762.
763.
764.
765.
766.
767.
768.
769.
770.
771.
772.
773.
774.
775.
776.
777.
778.
779.
780.
781.
782.
783.
784.
785.
786.
787.
788.
789.
790.
791.
792.
793.
794.
795.
796.
797.
798.
799.
800.
801.
802.
803.
804.
805.
806.
807.
808.
809.
810.
811.
812.
813.
814.
815.
816.
817.
818.
819.
820.
821.
822.
823.
824.
825.
826.
827.
828.
829.
830.
831.
832.
833.
834.
835.
836.
837.
838.
839.
840.
841.
842.
843.
844.
845.
846.
847.
848.
849.
850.
851.
852.
853.
854.
855.
856.
857.
858.
859.
860.
861.
862.
863.
864.
865.
866.
867.
868.
869.
870.
871.
872.
873.
874.
875.
876.
877.
878.
879.
880.
881.
882.
883.
884.
885.
886.
887.
888.
889.
890.
891.
892.
893.
894.
895.
896.
897.
898.
899.
900.
901.
902.
903.
904.
905.
906.
907.
908.
909.
910.
911.
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:35:57.375 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:35:57.376 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:35:57.376 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:35:57.378 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:35:57.378 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.383 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listcommen0_.comment_id as comment_2_4_5_,
listcommen0_.post_id as post_id3_4_5_,
comments1_.id as id1_0_0_,
comments1_.title as title2_0_0_,
comments1_1_.comment_id as comment_2_4_0_,
comments1_2_.user_id as user_id2_6_0_,
posts2_.id as id1_3_1_,
posts2_.title as title2_3_1_,
posts2_1_.user_id as user_id2_7_1_,
users3_.id as id1_5_2_,
users3_.login as login2_5_2_,
users3_.password as password3_5_2_,
users3_.position_id as position4_5_2_,
position4_.id as id1_2_3_,
position4_.description as descript2_2_3_,
position4_.name as name3_2_3_,
users5_.id as id1_5_4_,
users5_.login as login2_5_4_,
users5_.password as password3_5_4_,
users5_.position_id as position4_5_4_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
left outer join
users users5_
on comments1_2_.user_id=users5_.id
where
listcommen0_.comment_id in (
select
posts1_.id
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
)
Hibernate:
select
listcommen0_.comment_id as comment_2_4_5_,
listcommen0_.post_id as post_id3_4_5_,
comments1_.id as id1_0_0_,
comments1_.title as title2_0_0_,
comments1_1_.comment_id as comment_2_4_0_,
comments1_2_.user_id as user_id2_6_0_,
posts2_.id as id1_3_1_,
posts2_.title as title2_3_1_,
posts2_1_.user_id as user_id2_7_1_,
users3_.id as id1_5_2_,
users3_.login as login2_5_2_,
users3_.password as password3_5_2_,
users3_.position_id as position4_5_2_,
position4_.id as id1_2_3_,
position4_.description as descript2_2_3_,
position4_.name as name3_2_3_,
users5_.id as id1_5_4_,
users5_.login as login2_5_4_,
users5_.password as password3_5_4_,
users5_.position_id as position4_5_4_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
left outer join
users users5_
on comments1_2_.user_id=users5_.id
where
listcommen0_.comment_id in (
select
posts1_.id
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
)
2021-03-09 10:35:57.383 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.390 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:35:57.390 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.391 INFO 16192 --- [nio-8087-exec-7] c.e.L.config.jwt.JwtFilter : do filter...
2021-03-09 10:35:57.391 INFO 16192 --- [nio-8087-exec-7] c.e.L.config.jwt.JwtFilter : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 10:35:57.394 INFO 16192 --- [nio-8087-exec-7] c.e.L.config.jwt.JwtFilter : !!test
2021-03-09 10:35:57.394 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:35:57.395 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:35:57.396 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:35:57.397 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:35:57.399 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:35:57.399 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.403 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listcommen0_.comment_id as comment_2_4_5_,
listcommen0_.post_id as post_id3_4_5_,
comments1_.id as id1_0_0_,
comments1_.title as title2_0_0_,
comments1_1_.comment_id as comment_2_4_0_,
comments1_2_.user_id as user_id2_6_0_,
posts2_.id as id1_3_1_,
posts2_.title as title2_3_1_,
posts2_1_.user_id as user_id2_7_1_,
users3_.id as id1_5_2_,
users3_.login as login2_5_2_,
users3_.password as password3_5_2_,
users3_.position_id as position4_5_2_,
position4_.id as id1_2_3_,
position4_.description as descript2_2_3_,
position4_.name as name3_2_3_,
users5_.id as id1_5_4_,
users5_.login as login2_5_4_,
users5_.password as password3_5_4_,
users5_.position_id as position4_5_4_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
left outer join
users users5_
on comments1_2_.user_id=users5_.id
where
listcommen0_.comment_id in (
select
posts1_.id
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
)
Hibernate:
select
listcommen0_.comment_id as comment_2_4_5_,
listcommen0_.post_id as post_id3_4_5_,
comments1_.id as id1_0_0_,
comments1_.title as title2_0_0_,
comments1_1_.comment_id as comment_2_4_0_,
comments1_2_.user_id as user_id2_6_0_,
posts2_.id as id1_3_1_,
posts2_.title as title2_3_1_,
posts2_1_.user_id as user_id2_7_1_,
users3_.id as id1_5_2_,
users3_.login as login2_5_2_,
users3_.password as password3_5_2_,
users3_.position_id as position4_5_2_,
position4_.id as id1_2_3_,
position4_.description as descript2_2_3_,
position4_.name as name3_2_3_,
users5_.id as id1_5_4_,
users5_.login as login2_5_4_,
users5_.password as password3_5_4_,
users5_.position_id as position4_5_4_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
left outer join
users users5_
on comments1_2_.user_id=users5_.id
where
listcommen0_.comment_id in (
select
posts1_.id
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
)
2021-03-09 10:35:57.404 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.410 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:35:57.410 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.422 ERROR 16192 --- [nio-8087-exec-7] c.e.L.controller.CommentsController : Optional.empty
2021-03-09 10:35:57.423 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
Hibernate:
select
users0_.id as id1_5_,
users0_.login as login2_5_,
users0_.password as password3_5_,
users0_.position_id as position4_5_
from
users users0_
where
users0_.login=?
2021-03-09 10:35:57.423 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:35:57.425 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
Hibernate:
select
position0_.id as id1_2_0_,
position0_.description as descript2_2_0_,
position0_.name as name3_2_0_
from
position position0_
where
position0_.id=?
2021-03-09 10:35:57.425 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:35:57.426 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
Hibernate:
select
listpost0_.user_id as user_id2_7_0_,
listpost0_.post_id as post_id3_7_0_,
posts1_.id as id1_3_1_,
posts1_.title as title2_3_1_,
posts1_1_.user_id as user_id2_7_1_
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
2021-03-09 10:35:57.427 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.431 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listcommen0_.comment_id as comment_2_4_5_,
listcommen0_.post_id as post_id3_4_5_,
comments1_.id as id1_0_0_,
comments1_.title as title2_0_0_,
comments1_1_.comment_id as comment_2_4_0_,
comments1_2_.user_id as user_id2_6_0_,
posts2_.id as id1_3_1_,
posts2_.title as title2_3_1_,
posts2_1_.user_id as user_id2_7_1_,
users3_.id as id1_5_2_,
users3_.login as login2_5_2_,
users3_.password as password3_5_2_,
users3_.position_id as position4_5_2_,
position4_.id as id1_2_3_,
position4_.description as descript2_2_3_,
position4_.name as name3_2_3_,
users5_.id as id1_5_4_,
users5_.login as login2_5_4_,
users5_.password as password3_5_4_,
users5_.position_id as position4_5_4_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
left outer join
users users5_
on comments1_2_.user_id=users5_.id
where
listcommen0_.comment_id in (
select
posts1_.id
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
)
Hibernate:
select
listcommen0_.comment_id as comment_2_4_5_,
listcommen0_.post_id as post_id3_4_5_,
comments1_.id as id1_0_0_,
comments1_.title as title2_0_0_,
comments1_1_.comment_id as comment_2_4_0_,
comments1_2_.user_id as user_id2_6_0_,
posts2_.id as id1_3_1_,
posts2_.title as title2_3_1_,
posts2_1_.user_id as user_id2_7_1_,
users3_.id as id1_5_2_,
users3_.login as login2_5_2_,
users3_.password as password3_5_2_,
users3_.position_id as position4_5_2_,
position4_.id as id1_2_3_,
position4_.description as descript2_2_3_,
position4_.name as name3_2_3_,
users5_.id as id1_5_4_,
users5_.login as login2_5_4_,
users5_.password as password3_5_4_,
users5_.position_id as position4_5_4_
from
posts_comments listcommen0_
inner join
comments comments1_
on listcommen0_.post_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
left outer join
users users5_
on comments1_2_.user_id=users5_.id
where
listcommen0_.comment_id in (
select
posts1_.id
from
users_posts listpost0_
inner join
posts posts1_
on listpost0_.post_id=posts1_.id
left outer join
users_posts posts1_1_
on posts1_.id=posts1_1_.post_id
where
listpost0_.user_id=?
)
2021-03-09 10:35:57.432 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.439 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
Hibernate:
select
listcommen0_.user_id as user_id2_6_0_,
listcommen0_.comment_id as comment_3_6_0_,
comments1_.id as id1_0_1_,
comments1_.title as title2_0_1_,
comments1_1_.comment_id as comment_2_4_1_,
comments1_2_.user_id as user_id2_6_1_,
posts2_.id as id1_3_2_,
posts2_.title as title2_3_2_,
posts2_1_.user_id as user_id2_7_2_,
users3_.id as id1_5_3_,
users3_.login as login2_5_3_,
users3_.password as password3_5_3_,
users3_.position_id as position4_5_3_,
position4_.id as id1_2_4_,
position4_.description as descript2_2_4_,
position4_.name as name3_2_4_
from
users_comments listcommen0_
inner join
comments comments1_
on listcommen0_.comment_id=comments1_.id
left outer join
posts_comments comments1_1_
on comments1_.id=comments1_1_.post_id
left outer join
users_comments comments1_2_
on comments1_.id=comments1_2_.comment_id
left outer join
posts posts2_
on comments1_1_.comment_id=posts2_.id
left outer join
users_posts posts2_1_
on posts2_.id=posts2_1_.post_id
left outer join
users users3_
on posts2_1_.user_id=users3_.id
left outer join
position position4_
on users3_.position_id=position4_.id
where
listcommen0_.user_id=?
2021-03-09 10:35:57.440 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.453 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
select
nextval ('comments_id_seq')
Hibernate:
select
nextval ('comments_id_seq')
2021-03-09 10:35:57.456 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
insert
into
comments
(title, id)
values
(?, ?)
Hibernate:
insert
into
comments
(title, id)
values
(?, ?)
2021-03-09 10:35:57.457 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [labore!!!!!!!!]
2021-03-09 10:35:57.457 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [2]
2021-03-09 10:35:57.458 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL :
insert
into
posts_comments
(comment_id, post_id)
values
(?, ?)
Hibernate:
insert
into
posts_comments
(comment_id, post_id)
values
(?, ?)
2021-03-09 10:35:57.459 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [3]
2021-03-09 10:35:57.459 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [2]
2021-03-09 10:35:57.484 WARN 16192 --- [nio-8087-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23503
2021-03-09 10:35:57.484 ERROR 16192 --- [nio-8087-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : ОШИБКА: INSERT или UPDATE в таблице "posts_comments" нарушает ограничение внешнего ключа "posts_comments_comment_id_fkey"
Подробности: Ключ (comment_id)=(3) отсутствует в таблице "comments".
|
