16_sql.log
9.2 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
---------------------------------------------------------------
[ 2020-10-16T10:51:20+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ sql ] [ DB ] CONNECT:[ UseTime:0.189000s ] 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-10-16T10:51:23+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.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.023000s ]
---------------------------------------------------------------
[ 2020-10-16T10:51:25+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/to_excel
[ 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 * FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 [ RunTime:0.027000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.027000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (27,25,24) [ RunTime:0.025000s ]
---------------------------------------------------------------
[ 2020-10-16T10:51:41+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/prize_list
[ 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.025000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_prize` LIMIT 0,25 [ RunTime:0.026000s ]
---------------------------------------------------------------
[ 2020-10-16T10:51: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.035000s ] 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.024000s ]
[ 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.023000s ]
[ 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-16T10:51:44+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/to_excel
[ 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_win` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 [ RunTime:0.023000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_turn_member` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_member` WHERE `id` IN (27,25,24) [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-16T10:52:12+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.024000s ]
---------------------------------------------------------------
[ 2020-10-16T10:52:15+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.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.025000s ]
[ 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-10-16T10:52:16+08:00 ] 127.0.0.1 GET cartext.com/products/Turn_prize/to_excel
[ 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_win` [ RunTime:0.023000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_turn_win` WHERE `is_del` <> 1 AND `receive` = 1 [ 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 (27,25,24) [ RunTime:0.024000s ]
---------------------------------------------------------------
[ 2020-10-16T10:52:50+08:00 ] 127.0.0.1 GET cartext.com/products/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_win` [ RunTime:0.029000s ]
[ 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.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_member` WHERE `id` IN (752,751,750,749,748,746,742,741,740,739) [ RunTime:0.024000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_prize` [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_prize` WHERE `id` IN (7) [ RunTime:0.024000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `sos_prize_win` WHERE `receive` = 1 LIMIT 1 [ RunTime:0.023000s ]
---------------------------------------------------------------
[ 2020-10-16T10:52:52+08:00 ] 127.0.0.1 GET cartext.com/products/prize/to_excel
[ 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 [ RunTime:0.033000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_member` [ RunTime:0.021000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_member` WHERE `id` IN (50,42,269,81,55,58,54,52,51,44,34,35,232,59,60,61,63,65,66,67,68,69,74,76,77,78,79,80,82,83,85,86,88,90,91,92,93,96,97,98,99,100,101,102,104,105,106,108,111,109,110,114,115,117,118,119,120,121,123,126,128,129,130,131,133,136,138,141,142,143,144,146,147,148,149,150,151,152,153,154,155,157,158,159,160,161,162,167,168,170,171,172,173,174,176,177,178,180,179,181,182,183,184,185,186,187,188,192,193,195,197,196,198,199,200,202,203,204,205,206,207,208,209,210,211,214,215,216,217,218,219,220,222,223,224,226,228,229,230,235,237,239,240,242,241,244,245,246,249,250,251,254,253,255,256,257,258,259,262,271,275,274,277,279,280,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,305,304,308,309,306,310,311,313,316,319,320,322,323,325,326,327,328,329,330,331,332,333,40,334,335,336,338,339,340,341,342,344,314,348,349,350,352,353,354,355,356,357,358,362,378,365,367,368,370,371,373,374,375,377,380,381,360,345,383,384,385,386,388,387,389,390,391,392,394,395,396,397,398,400,402,403,404,406,407,408,409,410,411,412,413,414,415,416,417,419,420,422,423,424,425,421,426,427,428,429,430,431,432,434,435,437,436,439,440,441,442,443,445,446,447,448,451,454,453,452,455,456,458,459,461,463,464,466,467,471,473,475,477,478,479,480,481,482,483,484,486,487,488,491,492,493,494,495,496,497,498,499,501,502,504,505,507,508,509,510,511,512,513,514,515,516,517,518,519,520,522,524,528,530,531,532,533,539,537,540,541,543,544,545,546,547,549,550,551,552,555,554,557,558,559,560,561,562,563,748,565,566,567,568,569,570,571,573,574,575,576,577,578,579,580,581,583,584,585,586,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,606,607,608,609,610,615,616,618,621,622,623,624,626,629,630,631,632,614,633,634,635,636,637,639,644,646,648,650,651,652,653,654,655,656,657,660,663,664,668,670,671,672,673,674,676,678,679,681,682,683,684,686,687,688,689,690,691,692,694,695,697,700,746,702,703,704,707,708,709,710,711,712,713,714,715,716,717,719,721,722,723,724,725,726,727,728,729,731,734,736,738,739,740,741,742,749,750,751,752) [ RunTime:0.045000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `sos_prize_prize` [ RunTime:0.021000s ]
[ sql ] [ SQL ] SELECT * FROM `sos_prize_prize` WHERE `id` IN (7) [ RunTime:0.020000s ]