crutchmaster,
Итого, возвращаемся к началу - убрать все поля и оставить только ID, name, FK в демке вопросе на форум.
Трассировку SQL не знаем как включить? /
Ну хорошо....Щас пришлю
Это если добавить первый пост
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.
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 09:18:19.500 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:18:19.501 DEBUG 16704 --- [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 09:18:19.502 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:18:19.503 DEBUG 16704 --- [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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:18:19.504 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.507 DEBUG 16704 --- [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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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 09:18:19.507 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.514 INFO 16704 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter : do filter...
2021-03-09 09:18:19.514 INFO 16704 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 09:18:19.518 INFO 16704 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter : !!test
2021-03-09 09:18:19.519 DEBUG 16704 --- [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 09:18:19.520 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:18:19.521 DEBUG 16704 --- [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 09:18:19.522 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:18:19.523 DEBUG 16704 --- [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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:18:19.524 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.526 DEBUG 16704 --- [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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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 09:18:19.527 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.562 DEBUG 16704 --- [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 09:18:19.563 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:18:19.566 DEBUG 16704 --- [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 09:18:19.566 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:18:19.568 DEBUG 16704 --- [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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:18:19.568 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.571 DEBUG 16704 --- [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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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 09:18:19.572 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.606 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL :
select
nextval ('posts_id_seq')
Hibernate:
select
nextval ('posts_id_seq')
2021-03-09 09:18:19.643 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL :
insert
into
posts
(content, count_like, count_dislike, date_create, title, id)
values
(?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
posts
(content, count_like, count_dislike, date_create, title, id)
values
(?, ?, ?, ?, ?, ?)
2021-03-09 09:18:19.644 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [TEST1]
2021-03-09 09:18:19.644 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [0]
2021-03-09 09:18:19.644 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [BIGINT] - [0]
2021-03-09 09:18:19.645 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [DATE] - [null]
2021-03-09 09:18:19.648 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [TITLEE1]
2021-03-09 09:18:19.649 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [2]
2021-03-09 09:18:19.688 DEBUG 16704 --- [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
(?, ?)
Это если добавить затем второй пост
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.
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 09:21:10.933 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:21:10.934 DEBUG 16704 --- [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 09:21:10.935 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.936 DEBUG 16704 --- [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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:21:10.937 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:21:10.943 DEBUG 16704 --- [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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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 09:21:10.944 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.948 DEBUG 16704 --- [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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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 09:21:10.948 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:21:10.952 INFO 16704 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter : do filter...
2021-03-09 09:21:10.952 INFO 16704 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 09:21:10.955 INFO 16704 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter : !!test
2021-03-09 09:21:10.958 DEBUG 16704 --- [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 09:21:10.959 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:21:10.960 DEBUG 16704 --- [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 09:21:10.961 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.963 DEBUG 16704 --- [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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:21:10.963 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:21:10.966 DEBUG 16704 --- [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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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 09:21:10.967 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.971 DEBUG 16704 --- [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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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:
А теперь когда добавляешь комментарий ко второму добавленному посту,после которого возникает ошибка
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. 912. 913. 914. 915. 916. 917. 918. 919. 920. 921. 922. 923. 924. 925. 926. 927. 928. 929. 930. 931. 932. 933. 934. 935. 936. 937. 938. 939. 940. 941. 942. 943. 944. 945. 946. 947. 948. 949. 950. 951. 952. 953. 954. 955. 956. 957. 958. 959. 960. 961. 962. 963. 964. 965. 966. 967. 968. 969. 970. 971. 972. 973. 974. 975. 976. 977. 978. 979. 980. 981. 982. 983. 984. 985. 986. 987. 988. 989. 990. 991. 992. 993. 994. 995. 996. 997. 998. 999. 1000. 1001. 1002. 1003. 1004. 1005. 1006. 1007. 1008. 1009. 1010. 1011. 1012. 1013. 1014. 1015. 1016. 1017. 1018. 1019. 1020. 1021. 1022. 1023. 1024. 1025. 1026. 1027. 1028. 1029. 1030. 1031. 1032. 1033. 1034. 1035. 1036. 1037.
2021-03-09 09:31:34.741 DEBUG 5392 --- [nio-8087-exec-5] 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 09:31:34.743 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:31:34.746 DEBUG 5392 --- [nio-8087-exec-5] 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 09:31:34.746 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:31:34.748 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:31:34.748 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.765 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_0_0_,
comments1_.count_like as count_li3_0_0_,
comments1_.count_dislike as count_di4_0_0_,
comments1_.date_create as date_cre5_0_0_,
comments1_.title as title6_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_.content as content2_3_1_,
posts2_.count_like as count_li3_3_1_,
posts2_.count_dislike as count_di4_3_1_,
posts2_.date_create as date_cre5_3_1_,
posts2_.title as title6_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_.content as content2_0_0_,
comments1_.count_like as count_li3_0_0_,
comments1_.count_dislike as count_di4_0_0_,
comments1_.date_create as date_cre5_0_0_,
comments1_.title as title6_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_.content as content2_3_1_,
posts2_.count_like as count_li3_3_1_,
posts2_.count_dislike as count_di4_3_1_,
posts2_.date_create as date_cre5_3_1_,
posts2_.title as title6_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 09:31:34.767 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.772 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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 09:31:34.773 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.777 INFO 5392 --- [nio-8087-exec-5] c.e.L.config.jwt.JwtFilter : do filter...
2021-03-09 09:31:34.778 INFO 5392 --- [nio-8087-exec-5] c.e.L.config.jwt.JwtFilter : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 09:31:34.780 INFO 5392 --- [nio-8087-exec-5] c.e.L.config.jwt.JwtFilter : !!test
2021-03-09 09:31:34.781 DEBUG 5392 --- [nio-8087-exec-5] 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 09:31:34.782 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:31:34.783 DEBUG 5392 --- [nio-8087-exec-5] 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 09:31:34.784 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:31:34.785 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:31:34.786 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.789 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_0_0_,
comments1_.count_like as count_li3_0_0_,
comments1_.count_dislike as count_di4_0_0_,
comments1_.date_create as date_cre5_0_0_,
comments1_.title as title6_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_.content as content2_3_1_,
posts2_.count_like as count_li3_3_1_,
posts2_.count_dislike as count_di4_3_1_,
posts2_.date_create as date_cre5_3_1_,
posts2_.title as title6_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_.content as content2_0_0_,
comments1_.count_like as count_li3_0_0_,
comments1_.count_dislike as count_di4_0_0_,
comments1_.date_create as date_cre5_0_0_,
comments1_.title as title6_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_.content as content2_3_1_,
posts2_.count_like as count_li3_3_1_,
posts2_.count_dislike as count_di4_3_1_,
posts2_.date_create as date_cre5_3_1_,
posts2_.title as title6_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 09:31:34.790 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.798 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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 09:31:34.799 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.816 ERROR 5392 --- [nio-8087-exec-5] c.e.L.controller.CommentsController : Optional.empty
2021-03-09 09:31:34.817 DEBUG 5392 --- [nio-8087-exec-5] 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 09:31:34.817 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:31:34.819 DEBUG 5392 --- [nio-8087-exec-5] 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 09:31:34.819 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:31:34.822 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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_.content as content2_3_1_,
posts1_.count_like as count_li3_3_1_,
posts1_.count_dislike as count_di4_3_1_,
posts1_.date_create as date_cre5_3_1_,
posts1_.title as title6_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 09:31:34.822 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.828 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_0_0_,
comments1_.count_like as count_li3_0_0_,
comments1_.count_dislike as count_di4_0_0_,
comments1_.date_create as date_cre5_0_0_,
comments1_.title as title6_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_.content as content2_3_1_,
posts2_.count_like as count_li3_3_1_,
posts2_.count_dislike as count_di4_3_1_,
posts2_.date_create as date_cre5_3_1_,
posts2_.title as title6_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_.content as content2_0_0_,
comments1_.count_like as count_li3_0_0_,
comments1_.count_dislike as count_di4_0_0_,
comments1_.date_create as date_cre5_0_0_,
comments1_.title as title6_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_.content as content2_3_1_,
posts2_.count_like as count_li3_3_1_,
posts2_.count_dislike as count_di4_3_1_,
posts2_.date_create as date_cre5_3_1_,
posts2_.title as title6_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 09:31:34.829 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.837 DEBUG 5392 --- [nio-8087-exec-5] 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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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_.content as content2_0_1_,
comments1_.count_like as count_li3_0_1_,
comments1_.count_dislike as count_di4_0_1_,
comments1_.date_create as date_cre5_0_1_,
comments1_.title as title6_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_.content as content2_3_2_,
posts2_.count_like as count_li3_3_2_,
posts2_.count_dislike as count_di4_3_2_,
posts2_.date_create as date_cre5_3_2_,
posts2_.title as title6_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 09:31:34.837 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.856 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL :
select
nextval ('comments_id_seq')
Hibernate:
select
nextval ('comments_id_seq')
2021-03-09 09:31:34.859 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL :
insert
into
comments
(content, count_like, count_dislike, date_create, title, id)
values
(?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
comments
(content, count_like, count_dislike, date_create, title, id)
values
(?, ?, ?, ?, ?, ?)
2021-03-09 09:31:34.859 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [Ut quaerat est. Consequatur aut aliquid in a eos aspernatur at omnis. Expedita architecto error nesciunt. Molestiae cum consequuntur in quisquam quia a minima.]
2021-03-09 09:31:34.860 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [0]
2021-03-09 09:31:34.860 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [BIGINT] - [0]
2021-03-09 09:31:34.861 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [DATE] - [2021-03-09]
2021-03-09 09:31:34.862 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [totam!!!!!!!!]
2021-03-09 09:31:34.862 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [2]
2021-03-09 09:31:34.864 DEBUG 5392 --- [nio-8087-exec-5] 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 09:31:34.864 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [3]
2021-03-09 09:31:34.864 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [2]
2021-03-09 09:31:34.889 WARN 5392 --- [nio-8087-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23503
2021-03-09 09:31:34.889 ERROR 5392 --- [nio-8087-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper : ОШИБКА: INSERT или UPDATE в таблице "posts_comments" нарушает ограничение внешнего ключа "posts_comments_comment_id_fkey"
Подробности: Ключ (comment_id)=(3) отсутствует в таблице "comments".
2021-03-09 09:31:34.940 ERROR 5392 --- [nio-8087-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause
|