09_sql.log
11.3 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
---------------------------------------------------------------
[ 2020-10-09T09:32:15+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.215000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.021000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.021000s ]
---------------------------------------------------------------
[ 2020-10-09T11:19:54+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.051000s ] 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` LIMIT 0,25 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-09T11:19:56+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ sql ] [ DB ] CONNECT:[ UseTime:0.044000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.026000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-10-09T11:21:24+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.020000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.021000s ]
---------------------------------------------------------------
[ 2020-10-09T11:21:29+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ sql ] [ DB ] CONNECT:[ UseTime:0.037000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.027000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.026000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-10-09T11:21:32+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_user_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.037000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department1' AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (27) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department1' AND `receive` = 1 LIMIT 1 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-10-09T11:21:35+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_user_list
[ 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_win` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `member_id` = 27 AND `receive` = 1 [ RunTime:0.024000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (27) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `member_id` = 27 AND `receive` = 1 LIMIT 1 [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-10-09T11:21:45+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_user_list
[ 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_win` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department2' AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24) [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department2' AND `receive` = 1 LIMIT 1 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-09T11:21:46+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.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `member_id` = 25 AND `receive` = 1 [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `member_id` = 25 AND `receive` = 1 LIMIT 1 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-09T11:23:23+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.046000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.032000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.032000s ]
---------------------------------------------------------------
[ 2020-10-09T11:23: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.031000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.021000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.021000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.021000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.023000s ]
---------------------------------------------------------------
[ 2020-10-09T11:26:44+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_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_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-09T11:26:47+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ sql ] [ DB ] CONNECT:[ UseTime:0.046000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.022000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.034000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.028000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.022000s ]
---------------------------------------------------------------
[ 2020-10-09T11:26:50+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_user_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.037000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.045000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department1' AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.027000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.028000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (27) [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department1' AND `receive` = 1 LIMIT 1 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-10-09T11:26:53+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_user_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.041000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_win` [ RunTime:0.028000s ]
[ sql ] [ SQL ] SELECT *,count(*) as num FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department2' AND `receive` = 1 GROUP BY `member_id` ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.030000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.028000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24) [ RunTime:0.028000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `source` = 'department2' AND `receive` = 1 LIMIT 1 [ RunTime:0.027000s ]
---------------------------------------------------------------
[ 2020-10-09T11:26:55+08:00 ] 127.0.0.1 POST cartext.com/products/Turn_prize/prize_user_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_win` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `member_id` = 25 AND `receive` = 1 [ RunTime:0.026000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25) [ RunTime:0.026000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `member_id` = 25 AND `receive` = 1 LIMIT 1 [ RunTime:0.030000s ]