27_sql.log
12.8 KB
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
---------------------------------------------------------------
[ 2020-09-27T17:08:01+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.060000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.028000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-09-27T17:21:39+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.039000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.027000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-09-27T17:21:43+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ sql ] [ DB ] CONNECT:[ UseTime:0.043000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.024000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (3) [ RunTime:0.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE `id` IN (1) [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `receive` = 1 LIMIT 1 [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-09-27T17:22:24+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.039000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.031000s ]
---------------------------------------------------------------
[ 2020-09-27T17:22:26+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ sql ] [ DB ] CONNECT:[ UseTime:0.043000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.031000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.027000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (3) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE `id` IN (1) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `receive` = 1 LIMIT 1 [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-09-27T17:22:31+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_user_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.034000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `member_id` = 3 AND `receive` = 1 [ RunTime:0.029000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (3) [ RunTime:0.022000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE `id` IN (1,2) [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `member_id` = 3 AND `receive` = 1 LIMIT 1 [ RunTime:0.023000s ]
---------------------------------------------------------------
[ 2020-09-27T17:23:10+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_rule
[ sql ] [ DB ] CONNECT:[ UseTime:0.155000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_rule` [ RunTime:0.028000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_rule` LIMIT 1 [ RunTime:0.029000s ]
---------------------------------------------------------------
[ 2020-09-27T17:23:13+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.036000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.029000s ]
---------------------------------------------------------------
[ 2020-09-27T17:46:31+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o4LU-uP6os02sc9MfVdZp5MG-_QU&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.042000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.026000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o4LU-uP6os02sc9MfVdZp5MG-_QU' [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-09-27T17:48:53+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o4LU-uP6os02sc9MfVdZp5MG-_QU&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.035000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o4LU-uP6os02sc9MfVdZp5MG-_QU' [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-09-27T17:49:14+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o2UyS0aHNheXL9gXHbdlx5WNwLq4&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.032000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o2UyS0aHNheXL9gXHbdlx5WNwLq4' [ RunTime:0.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `member_id` = 3 ORDER BY `addTime` DESC [ RunTime:0.022000s ]
---------------------------------------------------------------
[ 2020-09-27T17:49:36+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o2UyS0Zbwk7YRBvjqPUcMAsH84QE&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.028000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.020000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.022000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o2UyS0Zbwk7YRBvjqPUcMAsH84QE' [ RunTime:0.020000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.020000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `member_id` = 2 ORDER BY `addTime` DESC [ RunTime:0.020000s ]
---------------------------------------------------------------
[ 2020-09-27T17:51:07+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o2UyS0Zbwk7YRBvjqPUcMAsH84QE&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.040000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.028000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.029000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o2UyS0Zbwk7YRBvjqPUcMAsH84QE' [ RunTime:0.028000s ]
---------------------------------------------------------------
[ 2020-09-27T17:51:46+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o2UyS0Zbwk7YRBvjqPUcMAsH84QE&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.036000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o2UyS0Zbwk7YRBvjqPUcMAsH84QE' [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `member_id` = 2 ORDER BY `addTime` DESC [ RunTime:0.025000s ]
[ sql ] [ SQL ] UPDATE `sos_prize_turn_member` SET `openid`='o2UyS0Zbwk7YRBvjqPUcMAsH84QE',`addTime`='1601200306',`frequency`=1 WHERE `id` = 2 [ RunTime:0.030000s ]
---------------------------------------------------------------
[ 2020-09-27T17:52:35+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o2UyS0Zbwk7YRBvjqPUcMAsH84QE&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.034000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o2UyS0Zbwk7YRBvjqPUcMAsH84QE' [ RunTime:0.024000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `member_id` = 2 ORDER BY `addTime` DESC [ RunTime:0.023000s ]
[ sql ] [ SQL ] UPDATE `sos_prize_turn_member` SET `openid`='o2UyS0Zbwk7YRBvjqPUcMAsH84QE',`addTime`='1601200355',`frequency`=1 WHERE `id` = 2 [ RunTime:0.031000s ]
---------------------------------------------------------------
[ 2020-09-27T17:56:35+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o2UyS0Zbwk7YRBvjqPUcMAsH84QE&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.034000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.024000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o2UyS0Zbwk7YRBvjqPUcMAsH84QE' [ RunTime:0.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `member_id` = 2 ORDER BY `addTime` DESC [ RunTime:0.024000s ]
[ sql ] [ SQL ] UPDATE `sos_prize_turn_member` SET `openid`='o2UyS0Zbwk7YRBvjqPUcMAsH84QE',`addTime`='1601200595',`frequency`=1 WHERE `id` = 2 [ RunTime:0.028000s ]
---------------------------------------------------------------
[ 2020-09-27T17:56:46+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/sel_prize_member?openid=o2UyS0Zbwk7YRBvjqPUcMAsH84QE&number=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.038000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` WHERE ( 1=1 ) LIMIT 0,25 [ RunTime:0.026000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `openid` = 'o2UyS0Zbwk7YRBvjqPUcMAsH84QE' [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.027000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `member_id` = 2 ORDER BY `addTime` DESC [ RunTime:0.025000s ]
[ sql ] [ SQL ] UPDATE `sos_prize_turn_member` SET `openid`='o2UyS0Zbwk7YRBvjqPUcMAsH84QE',`addTime`='1601200606',`frequency`=1 WHERE `id` = 2 [ RunTime:0.031000s ]