web123456

Turn on the console in SpringBoot to print the execution SQL of MyBatis

  • Registering transaction synchronization for SqlSession [@69fe8f8a]
  • JDBC Connection [@615a03bc] will be managed by Spring
  • ==> Preparing: SELECT a.template_site_id,a.lv_site_name,a.lv_site_id FROM r_template_site_relate AS a,r_template_site AS b WHERE b.template_id = a.template_id AND a.template_site_id = AND b.template_id = ? GROUP BY a.template_site_id
  • ==> Parameters: 454(Long)
  • <== Columns: template_site_id, lv_site_name, lv_site_id
  • <== Row: 3030, Shanghai,9
  • <== Row: 3031, Beijing,13
  • <== Row: 3032, Tianjin,14
  • <== Row: 3033, Hangzhou,69
  • <== Row: 3034, Nanjing,56
  • <== Row: 3035, Changzhou,59
  • <== Row: 3036, Suzhou,60
  • <== Row: 3037, Wuxi,57
  • <== Row: 3038, Hefei,80
  • <== Row: 3039, Nanchang,163
  • <== Row: 3040, Fuzhou,154
  • <== Row: 3041, Zhaoqing,195
  • <== Row: 3042, Shenzhen,324
  • <== Row: 3043, Nanning,207
  • <== Row: 3044, Haikou,221
  • <== Row: 3045, Jinan,174
  • <== Row: 3046, *, China,40
  • <== Row: 3047, Macau, China,41
  • <== Row: 3048, Taipei City, China,8000
  • <== Row: 3049, Ganzi,222
  • <== Row: 3050, Chongqing,31
  • <== Row: 3051, Guiyang,224
  • <== Row: 3052, Kunming,233
  • <== Row: 3054, Yinchuan,362
  • <== Row: 3055, Lanzhou,340
  • <== Row: 3056, Lhasa,249
  • <== Row: 3057, Taiyuan,100
  • <== Row: 3058, Shijiazhuang,89
  • <== Row: 3059, Hohhot,111
  • <== Row: 3060, Shenyang,123
  • <== Row: 3061, Harbin,43
  • <== Row: 3062, Changchun,137
  • <== Row: 3063, Wuhan,291
  • <== Row: 3064, Changsha,308
  • <== Row: 3065, Xi'an,256
  • <== Row: 3066, Zhengzhou,191
  • <== Total: 36