30_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
96
97
98
99
100
101
102
103
104
---------------------------------------------------------------
[ 2020-09-30T14:35:50+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ 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_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-09-30T16:23:11+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule
[ 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_rule` [ RunTime:0.021000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_rule` LIMIT 1 [ RunTime:0.021000s ]
---------------------------------------------------------------
[ 2020-09-30T16:23:13+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule_edit
[ 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_rule` [ RunTime:0.021000s ]
---------------------------------------------------------------
[ 2020-09-30T16:23:15+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule_edit
[ sql ] [ DB ] CONNECT:[ UseTime:0.100000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_rule` [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-09-30T16:23:16+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule_edit
[ 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_rule` [ RunTime:0.040000s ]
---------------------------------------------------------------
[ 2020-09-30T16:24:00+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_user_list?page=1&rows=10
[ 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_win` [ RunTime:0.033000s ]
[ 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.032000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.029000s ]
[ 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.025000s ]
---------------------------------------------------------------
[ 2020-09-30T16:24:03+08:00 ] 127.0.0.1 GET cartext.com/products/prize/prize_list?page=1&rows=10
[ 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_prize` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_prize` LIMIT 0,10 [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-09-30T16:24:05+08:00 ] 127.0.0.1 GET cartext.com/products/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_win` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_win` WHERE `receive` = 1 ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.026000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_member` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_member` WHERE `id` IN (746,742,741,740,739,738,736,734,731,729) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_prize` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_prize` WHERE `id` IN (7) [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_win` WHERE `receive` = 1 LIMIT 1 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-09-30T16:24:12+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule
[ 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_rule` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_rule` LIMIT 1 [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-09-30T16:25:12+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule_edit
[ 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_rule` [ RunTime:0.023000s ]
---------------------------------------------------------------
[ 2020-09-30T16:26:22+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule_edit
[ 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_rule` [ RunTime:0.022000s ]
[ sql ] [ SQL ] UPDATE `sos_prize_rule` SET `number`=1,`title`='抽奖规则：&\r\n1、永保保险承保的所有客户&\r\n2、每位客户可参与抽奖一次&\r\n3、最终奖品请以实物为准&\r\n4、抽奖活动最终解释权归永保所有&\r\n奖品派送：&\r\n请您务必填写准确的姓名与联系方式，成功添加客服微信即可领取',`addTime`='1601454382',`open`=0 WHERE `id` = 1 [ RunTime:0.034000s ]
---------------------------------------------------------------
[ 2020-09-30T16:26:26+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.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-09-30T16:26:29+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule
[ 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_rule` [ RunTime:0.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_rule` LIMIT 1 [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-09-30T16:26:31+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule_edit
[ 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_rule` [ RunTime:0.024000s ]
[ sql ] [ SQL ] UPDATE `sos_prize_rule` SET `number`=1,`open`=1,`title`='抽奖规则：&amp;\r\n1、永保保险承保的所有客户&amp;\r\n2、每位客户可参与抽奖一次&amp;\r\n3、最终奖品请以实物为准&amp;\r\n4、抽奖活动最终解释权归永保所有&amp;\r\n奖品派送：&amp;\r\n请您务必填写准确的姓名与联系方式，成功添加客服微信即可领取',`addTime`='1601454390' WHERE `id` = 1 [ RunTime:0.036000s ]
---------------------------------------------------------------
[ 2020-09-30T16:26:35+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.022000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.023000s ]
---------------------------------------------------------------
[ 2020-09-30T16:26:37+08:00 ] 127.0.0.1 GET cartext.com/products/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_win` [ RunTime:0.020000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_win` WHERE `receive` = 1 ORDER BY `addTime` DESC LIMIT 0,10 [ RunTime:0.021000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_member` [ RunTime:0.020000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_member` WHERE `id` IN (746,742,741,740,739,738,736,734,731,729) [ RunTime:0.021000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_prize` [ RunTime:0.020000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_prize` WHERE `id` IN (7) [ RunTime:0.020000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_win` WHERE `receive` = 1 LIMIT 1 [ RunTime:0.020000s ]
---------------------------------------------------------------
[ 2020-09-30T16:26:40+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule
[ sql ] [ DB ] CONNECT:[ UseTime:0.055000s ] mysql:host=49.232.59.136;port=3306;dbname=prize;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_rule` [ RunTime:0.039000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_rule` LIMIT 1 [ RunTime:0.036000s ]
---------------------------------------------------------------
[ 2020-09-30T16:27:52+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.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.021000s ]
---------------------------------------------------------------
[ 2020-09-30T16:27:54+08:00 ] 127.0.0.1 POST cartext.com/products/prize/prize_rule
[ 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_rule` [ RunTime:0.022000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_rule` LIMIT 1 [ RunTime:0.022000s ]