18.log 59 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601
  1. ---------------------------------------------------------------
  2. [2022-01-18T14:53:11+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  3. [ sql ] [ DB ] CONNECT:[ UseTime:0.074487s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  4. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.011879s ]
  5. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000544s ]
  6. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.008969s ]
  7. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000514s ]
  8. ---------------------------------------------------------------
  9. [2022-01-18T14:53:11+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/unrebate
  10. [ sql ] [ DB ] CONNECT:[ UseTime:0.003147s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  11. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.012700s ]
  12. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 4189 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000368s ]
  13. [ error ] [403]
  14. ---------------------------------------------------------------
  15. [2022-01-18T14:53:12+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  16. [ sql ] [ DB ] CONNECT:[ UseTime:0.002726s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  17. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.009735s ]
  18. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000462s ]
  19. ---------------------------------------------------------------
  20. [2022-01-18T14:53:12+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/category
  21. [ sql ] [ DB ] CONNECT:[ UseTime:0.009916s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  22. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_category` [ RunTime:0.005986s ]
  23. [ sql ] [ SQL ] SELECT `id`,`name` FROM `ins_goods_category` WHERE `ins_goods_category`.`deleted_at` = 0 [ RunTime:0.000319s ]
  24. ---------------------------------------------------------------
  25. [2022-01-18T14:53:12+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/collage?page=1&cateId=
  26. [ sql ] [ DB ] CONNECT:[ UseTime:0.004021s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  27. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods` [ RunTime:0.007674s ]
  28. [ sql ] [ SQL ] SELECT * FROM `ins_goods` WHERE ( `is_pin` = 1 AND `status` = 1 ) AND `ins_goods`.`deleted_at` = 0 LIMIT 0,10 [ RunTime:0.001094s ]
  29. ---------------------------------------------------------------
  30. [2022-01-18T14:53:16+08:00] 127.0.0.1 POST renrenjie.com/api/v1/wechat/login
  31. [ sql ] [ DB ] CONNECT:[ UseTime:0.002838s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  32. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.003978s ]
  33. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `open_id` = 'o11PJ5Y1A3Yy8-SFfv3gPIxy_m10' ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.001457s ]
  34. ---------------------------------------------------------------
  35. [2022-01-18T14:53:16+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  36. [ sql ] [ DB ] CONNECT:[ UseTime:0.002652s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  37. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.004025s ]
  38. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000982s ]
  39. ---------------------------------------------------------------
  40. [2022-01-18T14:53:16+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  41. [ sql ] [ DB ] CONNECT:[ UseTime:0.003289s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  42. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.004868s ]
  43. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000350s ]
  44. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.004268s ]
  45. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000364s ]
  46. ---------------------------------------------------------------
  47. [2022-01-18T14:53:18+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  48. [ sql ] [ DB ] CONNECT:[ UseTime:0.003338s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  49. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004766s ]
  50. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000382s ]
  51. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000503s ]
  52. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.008548s ]
  53. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000390s ]
  54. ---------------------------------------------------------------
  55. [2022-01-18T14:58:20+08:00] 127.0.0.1 POST renrenjie.com/api/v1/user/withdraw
  56. [ sql ] [ DB ] CONNECT:[ UseTime:0.002925s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  57. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004319s ]
  58. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000326s ]
  59. ---------------------------------------------------------------
  60. [2022-01-18T14:58:23+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  61. [ sql ] [ DB ] CONNECT:[ UseTime:0.003609s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  62. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.004989s ]
  63. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000472s ]
  64. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.004862s ]
  65. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000443s ]
  66. ---------------------------------------------------------------
  67. [2022-01-18T14:58:23+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/category
  68. [ sql ] [ DB ] CONNECT:[ UseTime:0.004452s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  69. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_category` [ RunTime:0.004626s ]
  70. [ sql ] [ SQL ] SELECT `id`,`name` FROM `ins_goods_category` WHERE `ins_goods_category`.`deleted_at` = 0 [ RunTime:0.000329s ]
  71. ---------------------------------------------------------------
  72. [2022-01-18T14:58:23+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  73. [ sql ] [ DB ] CONNECT:[ UseTime:0.004518s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  74. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.005865s ]
  75. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000339s ]
  76. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.004350s ]
  77. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000420s ]
  78. ---------------------------------------------------------------
  79. [2022-01-18T14:58:23+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/collage?page=1&cateId=
  80. [ sql ] [ DB ] CONNECT:[ UseTime:0.005098s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  81. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods` [ RunTime:0.006171s ]
  82. [ sql ] [ SQL ] SELECT * FROM `ins_goods` WHERE ( `is_pin` = 1 AND `status` = 1 ) AND `ins_goods`.`deleted_at` = 0 LIMIT 0,10 [ RunTime:0.000592s ]
  83. ---------------------------------------------------------------
  84. [2022-01-18T14:58:23+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/unrebate
  85. [ sql ] [ DB ] CONNECT:[ UseTime:0.005952s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  86. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.007214s ]
  87. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000592s ]
  88. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.010152s ]
  89. [ sql ] [ SQL ] SELECT `id`,`is_pin`,`pin_rebate`,`pin_rebate_expired`,`pin_rebate_rec` FROM `ins_goods_order` WHERE ( `is_pin` = 1 AND `pin_rebate_rec` = 0 AND `status` = 6 AND `user_id` = 176 AND `pin_rebate_expired` <> 0 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.001485s ]
  90. ---------------------------------------------------------------
  91. [2022-01-18T14:58:24+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  92. [ sql ] [ DB ] CONNECT:[ UseTime:0.009512s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  93. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.005934s ]
  94. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.001007s ]
  95. ---------------------------------------------------------------
  96. [2022-01-18T14:58:24+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  97. [ sql ] [ DB ] CONNECT:[ UseTime:0.003775s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  98. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.006606s ]
  99. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000408s ]
  100. ---------------------------------------------------------------
  101. [2022-01-18T14:58:24+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  102. [ sql ] [ DB ] CONNECT:[ UseTime:0.003925s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  103. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001109s ]
  104. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000407s ]
  105. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000474s ]
  106. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004521s ]
  107. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000437s ]
  108. ---------------------------------------------------------------
  109. [2022-01-18T14:59:07+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  110. [ sql ] [ DB ] CONNECT:[ UseTime:0.002800s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  111. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.004787s ]
  112. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000430s ]
  113. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.004125s ]
  114. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000494s ]
  115. ---------------------------------------------------------------
  116. [2022-01-18T14:59:07+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  117. [ sql ] [ DB ] CONNECT:[ UseTime:0.003763s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  118. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.006433s ]
  119. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.001292s ]
  120. ---------------------------------------------------------------
  121. [2022-01-18T14:59:07+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  122. [ sql ] [ DB ] CONNECT:[ UseTime:0.015455s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  123. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.004214s ]
  124. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000388s ]
  125. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.006552s ]
  126. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000516s ]
  127. ---------------------------------------------------------------
  128. [2022-01-18T14:59:07+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  129. [ sql ] [ DB ] CONNECT:[ UseTime:0.011745s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  130. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.007040s ]
  131. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.001453s ]
  132. ---------------------------------------------------------------
  133. [2022-01-18T14:59:07+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/unrebate
  134. [ sql ] [ DB ] CONNECT:[ UseTime:0.002713s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  135. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004361s ]
  136. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.001984s ]
  137. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.004370s ]
  138. [ sql ] [ SQL ] SELECT `id`,`is_pin`,`pin_rebate`,`pin_rebate_expired`,`pin_rebate_rec` FROM `ins_goods_order` WHERE ( `is_pin` = 1 AND `pin_rebate_rec` = 0 AND `status` = 6 AND `user_id` = 176 AND `pin_rebate_expired` <> 0 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000397s ]
  139. ---------------------------------------------------------------
  140. [2022-01-18T14:59:08+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/category
  141. [ sql ] [ DB ] CONNECT:[ UseTime:0.002781s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  142. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_category` [ RunTime:0.004434s ]
  143. [ sql ] [ SQL ] SELECT `id`,`name` FROM `ins_goods_category` WHERE `ins_goods_category`.`deleted_at` = 0 [ RunTime:0.000328s ]
  144. ---------------------------------------------------------------
  145. [2022-01-18T14:59:08+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/collage?page=1&cateId=
  146. [ sql ] [ DB ] CONNECT:[ UseTime:0.004708s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  147. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods` [ RunTime:0.004071s ]
  148. [ sql ] [ SQL ] SELECT * FROM `ins_goods` WHERE ( `is_pin` = 1 AND `status` = 1 ) AND `ins_goods`.`deleted_at` = 0 LIMIT 0,10 [ RunTime:0.000481s ]
  149. ---------------------------------------------------------------
  150. [2022-01-18T14:59:10+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  151. [ sql ] [ DB ] CONNECT:[ UseTime:0.005523s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  152. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001068s ]
  153. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000392s ]
  154. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000930s ]
  155. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.005239s ]
  156. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000303s ]
  157. ---------------------------------------------------------------
  158. [2022-01-18T14:59:37+08:00] 127.0.0.1 PUT renrenjie.com/api/v1/user/info
  159. [ sql ] [ DB ] CONNECT:[ UseTime:0.002677s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  160. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004988s ]
  161. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000329s ]
  162. [ sql ] [ SQL ] UPDATE `ins_users` SET `paycode` = 'e10adc3949ba59abbe56e057f20f883e' , `updated_at` = 1642489177 WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.002266s ]
  163. ---------------------------------------------------------------
  164. [2022-01-18T14:59:43+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  165. [ sql ] [ DB ] CONNECT:[ UseTime:0.003072s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  166. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.005122s ]
  167. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000342s ]
  168. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000250s ]
  169. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.003857s ]
  170. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000253s ]
  171. ---------------------------------------------------------------
  172. [2022-01-18T14:59:52+08:00] 127.0.0.1 POST renrenjie.com/api/v1/user/withdraw
  173. [ sql ] [ DB ] CONNECT:[ UseTime:0.022713s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  174. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004607s ]
  175. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000333s ]
  176. ---------------------------------------------------------------
  177. [2022-01-18T14:59:58+08:00] 127.0.0.1 POST renrenjie.com/api/v1/user/withdraw
  178. [ sql ] [ DB ] CONNECT:[ UseTime:0.024584s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  179. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004757s ]
  180. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000636s ]
  181. ---------------------------------------------------------------
  182. [2022-01-18T15:00:05+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  183. [ sql ] [ DB ] CONNECT:[ UseTime:0.002697s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  184. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000935s ]
  185. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000259s ]
  186. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000415s ]
  187. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004865s ]
  188. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000588s ]
  189. ---------------------------------------------------------------
  190. [2022-01-18T15:00:49+08:00] 127.0.0.1 POST renrenjie.com/api/v1/user/withdraw
  191. [ sql ] [ DB ] CONNECT:[ UseTime:0.002622s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  192. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004700s ]
  193. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000309s ]
  194. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000217s ]
  195. ---------------------------------------------------------------
  196. [2022-01-18T15:01:09+08:00] 127.0.0.1 POST renrenjie.com/api/v1/user/withdraw
  197. [ sql ] [ DB ] CONNECT:[ UseTime:0.003622s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  198. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.003966s ]
  199. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000263s ]
  200. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000241s ]
  201. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.003883s ]
  202. [ error ] [10501]SQLSTATE[HY000]: General error: 1364 Field 'bank' doesn't have a default value
  203. ---------------------------------------------------------------
  204. [2022-01-18T15:01:44+08:00] 127.0.0.1 POST renrenjie.com/api/v1/user/withdraw
  205. [ sql ] [ DB ] CONNECT:[ UseTime:0.003163s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  206. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.004992s ]
  207. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000359s ]
  208. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000355s ]
  209. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004033s ]
  210. [ sql ] [ SQL ] INSERT INTO `ins_users_withdraw` (`realname` , `account` , `amount` , `type` , `user_id` , `draw_no` , `created_at` , `updated_at`) VALUES ('1' , '收款账号为您的微信零钱' , '101' , 0 , 176 , '2022011856574856' , 1642489304 , 1642489304) [ RunTime:0.000255s ]
  211. ---------------------------------------------------------------
  212. [2022-01-18T15:01:46+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/balance?type=3&page=1
  213. [ sql ] [ DB ] CONNECT:[ UseTime:0.003722s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  214. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.005355s ]
  215. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000384s ]
  216. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.005623s ]
  217. [ sql ] [ SQL ] SELECT *,FROM_UNIXTIME(created_at, '%Y-%m-%d %H:%i:%s') as created_at FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `created_at` BETWEEN 1640966400 AND 1643558400 ) AND `ins_users_withdraw`.`deleted_at` = 0 ORDER BY `id` DESC,`updated_at` DESC [ RunTime:0.000574s ]
  218. ---------------------------------------------------------------
  219. [2022-01-18T15:02:04+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/balance?type=balance&page=1
  220. [ sql ] [ DB ] CONNECT:[ UseTime:0.007825s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  221. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001618s ]
  222. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.001273s ]
  223. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_balance_record` [ RunTime:0.005425s ]
  224. [ sql ] [ SQL ] SELECT *,FROM_UNIXTIME(created_at, '%Y-%m-%d %H:%i:%s') as created_at FROM `ins_users_balance_record` WHERE ( `user_id` = 176 AND `created_at` BETWEEN 1640966400 AND 1643558400 ) AND `ins_users_balance_record`.`deleted_at` = 0 ORDER BY `id` DESC,`updated_at` DESC [ RunTime:0.002322s ]
  225. ---------------------------------------------------------------
  226. [2022-01-18T15:02:08+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  227. [ sql ] [ DB ] CONNECT:[ UseTime:0.003002s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  228. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.001080s ]
  229. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000365s ]
  230. ---------------------------------------------------------------
  231. [2022-01-18T15:02:08+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  232. [ sql ] [ DB ] CONNECT:[ UseTime:0.003316s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  233. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.001087s ]
  234. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000304s ]
  235. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.001061s ]
  236. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000395s ]
  237. ---------------------------------------------------------------
  238. [2022-01-18T15:02:09+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/category
  239. [ sql ] [ DB ] CONNECT:[ UseTime:0.011685s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  240. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_category` [ RunTime:0.006886s ]
  241. [ sql ] [ SQL ] SELECT `id`,`name` FROM `ins_goods_category` WHERE `ins_goods_category`.`deleted_at` = 0 [ RunTime:0.000470s ]
  242. ---------------------------------------------------------------
  243. [2022-01-18T15:02:09+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  244. [ sql ] [ DB ] CONNECT:[ UseTime:0.003130s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  245. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.005319s ]
  246. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000366s ]
  247. ---------------------------------------------------------------
  248. [2022-01-18T15:02:09+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/unrebate
  249. [ sql ] [ DB ] CONNECT:[ UseTime:0.025149s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  250. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001407s ]
  251. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000415s ]
  252. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.004336s ]
  253. [ sql ] [ SQL ] SELECT `id`,`is_pin`,`pin_rebate`,`pin_rebate_expired`,`pin_rebate_rec` FROM `ins_goods_order` WHERE ( `is_pin` = 1 AND `pin_rebate_rec` = 0 AND `status` = 6 AND `user_id` = 176 AND `pin_rebate_expired` <> 0 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000624s ]
  254. ---------------------------------------------------------------
  255. [2022-01-18T15:02:09+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/collage?page=1&cateId=
  256. [ sql ] [ DB ] CONNECT:[ UseTime:0.005417s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  257. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods` [ RunTime:0.005214s ]
  258. [ sql ] [ SQL ] SELECT * FROM `ins_goods` WHERE ( `is_pin` = 1 AND `status` = 1 ) AND `ins_goods`.`deleted_at` = 0 LIMIT 0,10 [ RunTime:0.000447s ]
  259. ---------------------------------------------------------------
  260. [2022-01-18T15:02:10+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  261. [ sql ] [ DB ] CONNECT:[ UseTime:0.005132s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  262. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.000939s ]
  263. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000385s ]
  264. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.001043s ]
  265. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000400s ]
  266. ---------------------------------------------------------------
  267. [2022-01-18T15:02:10+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  268. [ sql ] [ DB ] CONNECT:[ UseTime:0.005419s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  269. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001438s ]
  270. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000753s ]
  271. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000479s ]
  272. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004676s ]
  273. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000422s ]
  274. ---------------------------------------------------------------
  275. [2022-01-18T15:02:13+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/balance?type=withdraw&page=1
  276. [ sql ] [ DB ] CONNECT:[ UseTime:0.005674s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  277. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001027s ]
  278. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000378s ]
  279. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004182s ]
  280. [ sql ] [ SQL ] SELECT *,FROM_UNIXTIME(created_at, '%Y-%m-%d %H:%i:%s') as created_at FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `created_at` BETWEEN 1640966400 AND 1643558400 ) AND `ins_users_withdraw`.`deleted_at` = 0 ORDER BY `id` DESC,`updated_at` DESC [ RunTime:0.000359s ]
  281. ---------------------------------------------------------------
  282. [2022-01-18T15:03:11+08:00] 127.0.0.1 POST renrenjie.com/manage/login
  283. [ sql ] [ DB ] CONNECT:[ UseTime:0.002732s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  284. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.004049s ]
  285. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `username` = 'lettered' ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000293s ]
  286. [ sql ] [ SQL ] UPDATE `ins_system_users` SET `last_login_time` = 1642489391 , `updated_at` = 1642489391 WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 [ RunTime:0.000392s ]
  287. ---------------------------------------------------------------
  288. [2022-01-18T15:03:12+08:00] 127.0.0.1 GET renrenjie.com/manage/config
  289. [ sql ] [ DB ] CONNECT:[ UseTime:0.002849s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  290. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_config` [ RunTime:0.004679s ]
  291. [ sql ] [ SQL ] SELECT * FROM `ins_system_config` WHERE ( `web` = 1 ) AND `ins_system_config`.`deleted_at` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001656s ]
  292. ---------------------------------------------------------------
  293. [2022-01-18T15:03:12+08:00] 127.0.0.1 GET renrenjie.com/manage/person
  294. [ sql ] [ DB ] CONNECT:[ UseTime:0.004246s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  295. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.005188s ]
  296. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000304s ]
  297. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001654s ]
  298. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/person' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.027477s ]
  299. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/person' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 189 , `updated_at` = 1642489392 WHERE ( `id` = 45880 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002540s ]
  300. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000375s ]
  301. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_permissions` [ RunTime:0.006480s ]
  302. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_system_permissions` WHERE `ins_system_permissions`.`deleted_at` = 0 [ RunTime:0.000397s ]
  303. ---------------------------------------------------------------
  304. [2022-01-18T15:03:17+08:00] 127.0.0.1 GET renrenjie.com/manage/users/relation
  305. [ sql ] [ DB ] CONNECT:[ UseTime:0.002654s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  306. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.003844s ]
  307. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000282s ]
  308. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.003377s ]
  309. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/users/relation' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.020259s ]
  310. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/users/relation' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 4 , `updated_at` = 1642489397 WHERE ( `id` = 45902 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.001858s ]
  311. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000780s ]
  312. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE `ins_users`.`deleted_at` = 0 [ RunTime:0.017581s ]
  313. ---------------------------------------------------------------
  314. [2022-01-18T15:03:29+08:00] 127.0.0.1 GET renrenjie.com/manage/users/group?page=1&limit=10
  315. [ sql ] [ DB ] CONNECT:[ UseTime:0.004326s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  316. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.003941s ]
  317. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000340s ]
  318. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001353s ]
  319. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/users/group' AND `operate` = 'get' AND `query` = '{\"page\":\"1\",\"limit\":\"10\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.018384s ]
  320. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/users/group' , `operate` = 'get' , `query` = '{\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 4 , `updated_at` = 1642489409 WHERE ( `id` = 45950 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.001963s ]
  321. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_group` [ RunTime:0.004094s ]
  322. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_users_group` [ RunTime:0.000235s ]
  323. [ sql ] [ SQL ] SELECT * FROM `ins_users_group` LIMIT 0,10 [ RunTime:0.000221s ]
  324. ---------------------------------------------------------------
  325. [2022-01-18T15:03:32+08:00] 127.0.0.1 GET renrenjie.com/manage/users?page=1&limit=10
  326. [ sql ] [ DB ] CONNECT:[ UseTime:0.003020s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  327. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.003986s ]
  328. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000239s ]
  329. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.000975s ]
  330. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/users' AND `operate` = 'get' AND `query` = '{\"page\":\"1\",\"limit\":\"10\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.019893s ]
  331. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/users' , `operate` = 'get' , `query` = '{\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 22 , `updated_at` = 1642489412 WHERE ( `id` = 45903 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002812s ]
  332. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000824s ]
  333. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_users` WHERE `ins_users`.`deleted_at` = 0 [ RunTime:0.001119s ]
  334. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE `ins_users`.`deleted_at` = 0 ORDER BY `created_at` DESC LIMIT 0,10 [ RunTime:0.001553s ]
  335. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 0 ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000218s ]
  336. ---------------------------------------------------------------
  337. [2022-01-18T15:03:40+08:00] 127.0.0.1 GET renrenjie.com/manage/store/withdraw?page=1&limit=10
  338. [ sql ] [ DB ] CONNECT:[ UseTime:0.020199s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  339. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.006024s ]
  340. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000375s ]
  341. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001114s ]
  342. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/store/withdraw' AND `operate` = 'get' AND `query` = '{\"page\":\"1\",\"limit\":\"10\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.024912s ]
  343. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/store/withdraw' , `operate` = 'get' , `query` = '{\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 3 , `updated_at` = 1642489420 WHERE ( `id` = 45904 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002450s ]
  344. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.006919s ]
  345. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_users_withdraw` WHERE `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000428s ]
  346. [ sql ] [ SQL ] SELECT * FROM `ins_users_withdraw` WHERE `ins_users_withdraw`.`deleted_at` = 0 ORDER BY `created_at` DESC LIMIT 0,10 [ RunTime:0.000346s ]
  347. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000822s ]
  348. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` IN (176,31,4) ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000346s ]
  349. ---------------------------------------------------------------
  350. [2022-01-18T15:16:49+08:00] 127.0.0.1 POST renrenjie.com/api/v1/user/withdraw
  351. [ sql ] [ DB ] CONNECT:[ UseTime:0.002892s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  352. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000971s ]
  353. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000374s ]
  354. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000260s ]
  355. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004084s ]
  356. [ sql ] [ SQL ] INSERT INTO `ins_users_withdraw` (`realname` , `account` , `amount` , `type` , `user_id` , `draw_no` , `created_at` , `updated_at`) VALUES ('韦传宝' , '收款账号为您的微信零钱' , '0.01' , 0 , 176 , '2022011849554949' , 1642490209 , 1642490209) [ RunTime:0.000311s ]
  357. ---------------------------------------------------------------
  358. [2022-01-18T15:16:51+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/balance?type=3&page=1
  359. [ sql ] [ DB ] CONNECT:[ UseTime:0.003310s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  360. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001097s ]
  361. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000368s ]
  362. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004739s ]
  363. [ sql ] [ SQL ] SELECT *,FROM_UNIXTIME(created_at, '%Y-%m-%d %H:%i:%s') as created_at FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `created_at` BETWEEN 1640966400 AND 1643558400 ) AND `ins_users_withdraw`.`deleted_at` = 0 ORDER BY `id` DESC,`updated_at` DESC [ RunTime:0.000324s ]
  364. ---------------------------------------------------------------
  365. [2022-01-18T15:16:53+08:00] 127.0.0.1 GET renrenjie.com/manage/store/withdraw?page=1&limit=10
  366. [ sql ] [ DB ] CONNECT:[ UseTime:0.028461s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  367. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.003995s ]
  368. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000417s ]
  369. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001522s ]
  370. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/store/withdraw' AND `operate` = 'get' AND `query` = '{\"page\":\"1\",\"limit\":\"10\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.023764s ]
  371. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/store/withdraw' , `operate` = 'get' , `query` = '{\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 4 , `updated_at` = 1642490213 WHERE ( `id` = 45904 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.001025s ]
  372. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.006931s ]
  373. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_users_withdraw` WHERE `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000403s ]
  374. [ sql ] [ SQL ] SELECT * FROM `ins_users_withdraw` WHERE `ins_users_withdraw`.`deleted_at` = 0 ORDER BY `created_at` DESC LIMIT 0,10 [ RunTime:0.000454s ]
  375. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001201s ]
  376. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` IN (176,31,4) ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000408s ]
  377. ---------------------------------------------------------------
  378. [2022-01-18T15:17:39+08:00] 127.0.0.1 PUT renrenjie.com/manage/store/withdraw/4
  379. [ sql ] [ DB ] CONNECT:[ UseTime:0.026031s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  380. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.004092s ]
  381. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000352s ]
  382. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001127s ]
  383. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/store/withdraw/4' AND `operate` = 'put' AND `query` = '{\"status\":\"2\",\"id\":\"4\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.021860s ]
  384. [ sql ] [ SQL ] INSERT INTO `ins_system_operate_log` (`user_id` , `route` , `operate` , `query` , `ip` , `os` , `browser` , `created_at` , `updated_at`) VALUES (1 , '/manage/store/withdraw/4' , 'put' , '{\"status\":\"2\",\"id\":\"4\"}' , '127.0.0.1' , 'Windows' , 'Chrome' , 1642490258 , 1642490258) [ RunTime:0.002567s ]
  385. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.000884s ]
  386. [ sql ] [ SQL ] SELECT * FROM `ins_users_withdraw` WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000400s ]
  387. [ sql ] [ SQL ] UPDATE `ins_users_withdraw` SET `status` = 2 , `updated_at` = 1642490258 WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000385s ]
  388. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000845s ]
  389. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000346s ]
  390. [ sql ] [ SQL ] UPDATE `ins_users` SET `balance` = `balance` - 0.01 WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000368s ]
  391. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_balance_record` [ RunTime:0.006005s ]
  392. [ sql ] [ SQL ] INSERT INTO `ins_users_balance_record` (`user_id` , `dec_amount` , `aft_amount` , `remark` , `created_at` , `updated_at`) VALUES (176 , '0.01' , 99965 , '主动提现,¥0.01,单号;2022011849554949' , 1642490258 , 1642490258) [ RunTime:0.000296s ]
  393. ---------------------------------------------------------------
  394. [2022-01-18T15:18:21+08:00] 127.0.0.1 GET renrenjie.com/manage/store/withdraw?page=1&limit=10
  395. [ sql ] [ DB ] CONNECT:[ UseTime:0.002924s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  396. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.006147s ]
  397. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000285s ]
  398. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001355s ]
  399. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/store/withdraw' AND `operate` = 'get' AND `query` = '{\"page\":\"1\",\"limit\":\"10\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.021277s ]
  400. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/store/withdraw' , `operate` = 'get' , `query` = '{\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 5 , `updated_at` = 1642490301 WHERE ( `id` = 45904 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.001985s ]
  401. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.000887s ]
  402. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_users_withdraw` WHERE `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000211s ]
  403. [ sql ] [ SQL ] SELECT * FROM `ins_users_withdraw` WHERE `ins_users_withdraw`.`deleted_at` = 0 ORDER BY `created_at` DESC LIMIT 0,10 [ RunTime:0.000201s ]
  404. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000737s ]
  405. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` IN (176,31,4) ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000300s ]
  406. ---------------------------------------------------------------
  407. [2022-01-18T15:18:25+08:00] 127.0.0.1 PUT renrenjie.com/manage/store/withdraw/4
  408. [ sql ] [ DB ] CONNECT:[ UseTime:0.003713s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  409. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.004175s ]
  410. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000328s ]
  411. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001322s ]
  412. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/store/withdraw/4' AND `operate` = 'put' AND `query` = '{\"status\":\"2\",\"id\":\"4\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.022291s ]
  413. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/store/withdraw/4' , `operate` = 'put' , `query` = '{\"status\":\"2\",\"id\":\"4\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 2 , `updated_at` = 1642490305 WHERE ( `id` = 46084 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002042s ]
  414. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.004040s ]
  415. [ sql ] [ SQL ] SELECT * FROM `ins_users_withdraw` WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000422s ]
  416. [ sql ] [ SQL ] UPDATE `ins_users_withdraw` SET `status` = 2 , `updated_at` = 1642490305 WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000461s ]
  417. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001027s ]
  418. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000454s ]
  419. [ sql ] [ SQL ] UPDATE `ins_users` SET `balance` = `balance` - 1 WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000430s ]
  420. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_balance_record` [ RunTime:0.004391s ]
  421. [ sql ] [ SQL ] INSERT INTO `ins_users_balance_record` (`user_id` , `dec_amount` , `aft_amount` , `remark` , `created_at` , `updated_at`) VALUES (176 , '1.00' , 99964 , '主动提现,¥1.00,单号;2022011849554949' , 1642490305 , 1642490305) [ RunTime:0.000472s ]
  422. ---------------------------------------------------------------
  423. [2022-01-18T15:23:41+08:00] 127.0.0.1 PUT renrenjie.com/manage/store/withdraw/4
  424. [ sql ] [ DB ] CONNECT:[ UseTime:0.013564s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  425. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.001507s ]
  426. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000371s ]
  427. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001251s ]
  428. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/store/withdraw/4' AND `operate` = 'put' AND `query` = '{\"status\":\"2\",\"id\":\"4\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.021114s ]
  429. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/store/withdraw/4' , `operate` = 'put' , `query` = '{\"status\":\"2\",\"id\":\"4\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 3 , `updated_at` = 1642490621 WHERE ( `id` = 46084 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002193s ]
  430. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.003983s ]
  431. [ sql ] [ SQL ] SELECT * FROM `ins_users_withdraw` WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000373s ]
  432. [ sql ] [ SQL ] UPDATE `ins_users_withdraw` SET `status` = 2 , `updated_at` = 1642490621 WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000364s ]
  433. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.000870s ]
  434. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000330s ]
  435. [ sql ] [ SQL ] UPDATE `ins_users` SET `balance` = `balance` - 1 WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000361s ]
  436. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_balance_record` [ RunTime:0.005001s ]
  437. [ sql ] [ SQL ] INSERT INTO `ins_users_balance_record` (`user_id` , `dec_amount` , `aft_amount` , `remark` , `created_at` , `updated_at`) VALUES (176 , '1.00' , 99963 , '主动提现,¥1.00,单号;2022011849554949' , 1642490621 , 1642490621) [ RunTime:0.000357s ]
  438. ---------------------------------------------------------------
  439. [2022-01-18T15:25:34+08:00] 127.0.0.1 PUT renrenjie.com/manage/store/withdraw/4
  440. [ sql ] [ DB ] CONNECT:[ UseTime:0.025302s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  441. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_users` [ RunTime:0.004513s ]
  442. [ sql ] [ SQL ] SELECT * FROM `ins_system_users` WHERE ( `id` = 1 ) AND `ins_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000764s ]
  443. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_system_operate_log` [ RunTime:0.001257s ]
  444. [ sql ] [ SQL ] SELECT * FROM `ins_system_operate_log` WHERE ( `user_id` = 1 AND `route` = '/manage/store/withdraw/4' AND `operate` = 'put' AND `query` = '{\"status\":\"2\",\"id\":\"4\"}' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.021530s ]
  445. [ sql ] [ SQL ] UPDATE `ins_system_operate_log` SET `user_id` = 1 , `route` = '/manage/store/withdraw/4' , `operate` = 'put' , `query` = '{\"status\":\"2\",\"id\":\"4\"}' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 4 , `updated_at` = 1642490732 WHERE ( `id` = 46084 ) AND `ins_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002145s ]
  446. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.000923s ]
  447. [ sql ] [ SQL ] SELECT * FROM `ins_users_withdraw` WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000407s ]
  448. [ sql ] [ SQL ] UPDATE `ins_users_withdraw` SET `status` = 2 , `updated_at` = 1642490732 WHERE ( `id` = 4 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000723s ]
  449. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.003916s ]
  450. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000420s ]
  451. [ sql ] [ SQL ] UPDATE `ins_users` SET `balance` = `balance` - 1 WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 [ RunTime:0.000544s ]
  452. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_balance_record` [ RunTime:0.001124s ]
  453. [ sql ] [ SQL ] INSERT INTO `ins_users_balance_record` (`user_id` , `dec_amount` , `aft_amount` , `remark` , `created_at` , `updated_at`) VALUES (176 , '1.00' , 99962 , '主动提现,¥1.00,单号;2022011849554949' , 1642490732 , 1642490732) [ RunTime:0.000384s ]
  454. ---------------------------------------------------------------
  455. [2022-01-18T15:29:15+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  456. [ sql ] [ DB ] CONNECT:[ UseTime:0.003248s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  457. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.001065s ]
  458. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000281s ]
  459. ---------------------------------------------------------------
  460. [2022-01-18T15:29:15+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/category
  461. [ sql ] [ DB ] CONNECT:[ UseTime:0.020036s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  462. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_category` [ RunTime:0.016341s ]
  463. [ sql ] [ SQL ] SELECT `id`,`name` FROM `ins_goods_category` WHERE `ins_goods_category`.`deleted_at` = 0 [ RunTime:0.000442s ]
  464. ---------------------------------------------------------------
  465. [2022-01-18T15:29:15+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  466. [ sql ] [ DB ] CONNECT:[ UseTime:0.003738s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  467. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.004691s ]
  468. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000715s ]
  469. ---------------------------------------------------------------
  470. [2022-01-18T15:29:15+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/collage?page=1&cateId=
  471. [ sql ] [ DB ] CONNECT:[ UseTime:0.003981s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  472. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods` [ RunTime:0.001213s ]
  473. [ sql ] [ SQL ] SELECT * FROM `ins_goods` WHERE ( `is_pin` = 1 AND `status` = 1 ) AND `ins_goods`.`deleted_at` = 0 LIMIT 0,10 [ RunTime:0.000482s ]
  474. ---------------------------------------------------------------
  475. [2022-01-18T15:29:16+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  476. [ sql ] [ DB ] CONNECT:[ UseTime:0.005566s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  477. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.004283s ]
  478. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000341s ]
  479. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.005561s ]
  480. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000442s ]
  481. ---------------------------------------------------------------
  482. [2022-01-18T15:29:16+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  483. [ sql ] [ DB ] CONNECT:[ UseTime:0.004109s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  484. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.000998s ]
  485. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000254s ]
  486. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.000881s ]
  487. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000287s ]
  488. ---------------------------------------------------------------
  489. [2022-01-18T15:29:16+08:00] 127.0.0.1 GET renrenjie.com/api/v1/goods/unrebate
  490. [ sql ] [ DB ] CONNECT:[ UseTime:0.016135s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  491. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001228s ]
  492. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.001092s ]
  493. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.004660s ]
  494. [ sql ] [ SQL ] SELECT `id`,`is_pin`,`pin_rebate`,`pin_rebate_expired`,`pin_rebate_rec` FROM `ins_goods_order` WHERE ( `is_pin` = 1 AND `pin_rebate_rec` = 0 AND `status` = 6 AND `user_id` = 176 AND `pin_rebate_expired` <> 0 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000564s ]
  495. ---------------------------------------------------------------
  496. [2022-01-18T15:29:16+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  497. [ sql ] [ DB ] CONNECT:[ UseTime:0.004734s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  498. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001703s ]
  499. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000944s ]
  500. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000375s ]
  501. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.001103s ]
  502. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000259s ]
  503. ---------------------------------------------------------------
  504. [2022-01-18T15:29:18+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/balance?type=withdraw&page=1
  505. [ sql ] [ DB ] CONNECT:[ UseTime:0.004711s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  506. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001032s ]
  507. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000287s ]
  508. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.000917s ]
  509. [ sql ] [ SQL ] SELECT *,FROM_UNIXTIME(created_at, '%Y-%m-%d %H:%i:%s') as created_at FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `created_at` BETWEEN 1640966400 AND 1643558400 ) AND `ins_users_withdraw`.`deleted_at` = 0 ORDER BY `id` DESC,`updated_at` DESC [ RunTime:0.000306s ]
  510. ---------------------------------------------------------------
  511. [2022-01-18T15:29:21+08:00] 127.0.0.1 GET renrenjie.com/api/v1/user/ucenter
  512. [ sql ] [ DB ] CONNECT:[ UseTime:0.003235s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  513. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users` [ RunTime:0.001194s ]
  514. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000346s ]
  515. [ sql ] [ SQL ] SELECT * FROM `ins_users` WHERE ( `id` = 176 ) AND `ins_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000362s ]
  516. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_users_withdraw` [ RunTime:0.000833s ]
  517. [ sql ] [ SQL ] SELECT SUM(`amount`) AS tp_sum FROM `ins_users_withdraw` WHERE ( `user_id` = 176 AND `status` = 2 ) AND `ins_users_withdraw`.`deleted_at` = 0 [ RunTime:0.000200s ]
  518. ---------------------------------------------------------------
  519. [2022-01-18T15:29:22+08:00] 127.0.0.1 GET renrenjie.com/api/v1/system/notice
  520. [ sql ] [ DB ] CONNECT:[ UseTime:0.004124s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  521. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_article` [ RunTime:0.001104s ]
  522. [ sql ] [ SQL ] SELECT * FROM `ins_article` WHERE ( `category_id` = 1 ) AND `ins_article`.`deleted_at` = 0 [ RunTime:0.000335s ]
  523. ---------------------------------------------------------------
  524. [2022-01-18T15:29:22+08:00] 127.0.0.1 GET renrenjie.com/api/v1/banner/1
  525. [ sql ] [ DB ] CONNECT:[ UseTime:0.002934s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  526. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner` [ RunTime:0.001033s ]
  527. [ sql ] [ SQL ] SELECT * FROM `ins_banner` WHERE ( `id` = 1 ) AND `ins_banner`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000374s ]
  528. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_banner_item` [ RunTime:0.000947s ]
  529. [ sql ] [ SQL ] SELECT * FROM `ins_banner_item` WHERE ( `status` = 1 AND `banner_id` = 1 ) AND `ins_banner_item`.`deleted_at` = 0 [ RunTime:0.000311s ]