22_sql.log
9.6 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
---------------------------------------------------------------
[ 2020-10-22T09:15:48+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.181000s ] 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` LIMIT 0,25 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-10-22T10:07:18+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_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_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-10-22T10:07:20+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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_win` [ RunTime:0.026000s ]
[ 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.027000s ]
[ 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-22T10:07:39+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ sql ] [ DB ] CONNECT:[ UseTime:0.029000s ] 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.020000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.020000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.020000s ]
---------------------------------------------------------------
[ 2020-10-22T10:07:40+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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_win` [ RunTime:0.024000s ]
[ 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.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.024000s ]
[ 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-22T10:07:41+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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.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.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.025000s ]
[ 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.025000s ]
---------------------------------------------------------------
[ 2020-10-22T10:07:42+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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_win` [ RunTime:0.023000s ]
[ 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.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.027000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.021000s ]
[ 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-22T10:07:58+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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.023000s ]
[ 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.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-22T10:07:58+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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 *,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.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.023000s ]
[ 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-22T10:07:59+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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 `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.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-22T10:08:03+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.033000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_prize` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.023000s ]
---------------------------------------------------------------
[ 2020-10-22T10:08:05+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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 *,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.025000s ]
[ 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-22T10:08:31+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ sql ] [ DB ] CONNECT:[ UseTime:0.056000s ] 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 `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.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (25,24,27) [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 LIMIT 1 [ RunTime:0.024000s ]