2022-01-22 09:37:56 [32] INFO  lp.shop.core.MsgAPI 发送手机号码：18617701343,短信模板：1,内容：{"phone":"18617701343","code":"3422"}

 
2022-01-22 09:37:56 [32] INFO  lp.shop.core.MsgAPI 18617701343短信执行返回：{"RequestId":"69DB7787-8B5B-509B-B03B-414226947832","BizId":"784502242815476358^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"69DB7787-8B5B-509B-B03B-414226947832","x-acs-trace-id":"e34938d980026164e82026743fc2cc31","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 22 Jan 2022 01:37:56 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18617701343&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218617701343%22%2c%22code%22:%223422%22%7D&OutId=202201220937569689&Timestamp=2022-01-22T01:37:56Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=9221fe0b-7571-4035-8aae-2768afc76b74&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=tRWypPV1gJE%2bSb%2fEFKFTyG8whCY%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxSZXF1ZXN0SWQ+NjlEQjc3ODctOEI1Qi01MDlCLUIwM0ItNDE0MjI2OTQ3ODMyPC9SZXF1ZXN0SWQ+PE1lc3NhZ2U+T0s8L01lc3NhZ2U+PEJpeklkPjc4NDUwMjI0MjgxNTQ3NjM1OF4wPC9CaXpJZD48Q29kZT5PSzwvQ29kZT48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2022-01-22 09:38:02 [41] INFO  lp.shop.core.MsgAPI 发送手机号码：18616702342,短信模板：1,内容：{"phone":"18616702342","code":"0408"}

 
2022-01-22 09:38:02 [41] INFO  lp.shop.core.MsgAPI 18616702342短信执行返回：{"RequestId":"7788E74A-1FD7-51A3-9B84-FB90FFFA406F","BizId":"233023642815482418^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"7788E74A-1FD7-51A3-9B84-FB90FFFA406F","x-acs-trace-id":"fbf81708790f446fbd21d2759da383ea","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 22 Jan 2022 01:38:02 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18616702342&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218616702342%22%2c%22code%22:%220408%22%7D&OutId=202201220938022920&Timestamp=2022-01-22T01:38:02Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=86b50eaa-2dda-465b-a5b5-8d25ccd2ce54&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=wDknHq7qVY%2bcgL%2fZvSLuFQSoqwM%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxSZXF1ZXN0SWQ+Nzc4OEU3NEEtMUZENy01MUEzLTlCODQtRkI5MEZGRkE0MDZGPC9SZXF1ZXN0SWQ+PE1lc3NhZ2U+T0s8L01lc3NhZ2U+PEJpeklkPjIzMzAyMzY0MjgxNTQ4MjQxOF4wPC9CaXpJZD48Q29kZT5PSzwvQ29kZT48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2022-01-22 09:39:25 [25] INFO  lp.shop.core.MsgAPI 发送手机号码：18616702343,短信模板：1,内容：{"phone":"18616702343","code":"1810"}

 
2022-01-22 09:39:25 [25] INFO  lp.shop.core.MsgAPI 18616702343短信执行返回：{"RequestId":"96B976E3-14C0-5318-9413-CDE6B05E9D26","BizId":"706222942815565463^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"96B976E3-14C0-5318-9413-CDE6B05E9D26","x-acs-trace-id":"43495896780e279d82665f26569f3bf8","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 22 Jan 2022 01:39:25 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18616702343&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2218616702343%22%2c%22code%22:%221810%22%7D&OutId=202201220939254467&Timestamp=2022-01-22T01:39:25Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=7192b7fb-e597-4ba0-848a-0678d62d68c7&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=GA1qNGsK8xRIMGDF6%2b0qzgsVS1k%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxSZXF1ZXN0SWQ+OTZCOTc2RTMtMTRDMC01MzE4LTk0MTMtQ0RFNkIwNUU5RDI2PC9SZXF1ZXN0SWQ+PE1lc3NhZ2U+T0s8L01lc3NhZ2U+PEJpeklkPjcwNjIyMjk0MjgxNTU2NTQ2M14wPC9CaXpJZD48Q29kZT5PSzwvQ29kZT48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2022-01-22 18:46:11 [40] INFO  lp.shop.core.MsgAPI 发送手机号码：15576769543,短信模板：1,内容：{"phone":"15576769543","code":"0347"}

 
2022-01-22 18:46:11 [40] INFO  lp.shop.core.MsgAPI 15576769543短信执行返回：{"RequestId":"B264DC20-D0A9-5C30-8D0E-5974F47FF1FA","BizId":"936600842848371320^0","Code":"OK","Message":"OK","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","Access-Control-Allow-Methods":"POST, GET, OPTIONS, PUT, DELETE","Access-Control-Allow-Headers":"X-Requested-With, X-Sequence, _aop_secret, _aop_signature, x-acs-action, x-acs-version, x-acs-date, Content-Type","Access-Control-Max-Age":"172800","x-acs-request-id":"B264DC20-D0A9-5C30-8D0E-5974F47FF1FA","x-acs-trace-id":"6eea766154e60f50695c73024284e5b4","Content-Length":"203","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 22 Jan 2022 10:46:11 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=15576769543&SignName=%E4%B8%89%E8%9A%81%E8%BD%AF%E4%BB%B6&TemplateCode=SMS_219606788&TemplateParam=%7B%22phone%22:%2215576769543%22%2c%22code%22:%220347%22%7D&OutId=202201221846118893&Timestamp=2022-01-22T10:46:11Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=e57d8874-4f4a-49ac-93bb-1b44e8269a46&AccessKeyId=LTAI5tBnfF1GCDQDmFvc7kmF&RegionId=cn-hangzhou&Signature=nyaCXEDNzpADjLtREu1yvTQXkL4%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxSZXF1ZXN0SWQ+QjI2NERDMjAtRDBBOS01QzMwLThEMEUtNTk3NEY0N0ZGMUZBPC9SZXF1ZXN0SWQ+PE1lc3NhZ2U+T0s8L01lc3NhZ2U+PEJpeklkPjkzNjYwMDg0Mjg0ODM3MTMyMF4wPC9CaXpJZD48Q29kZT5PSzwvQ29kZT48L1NlbmRTbXNSZXNwb25zZT4=","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2022-01-22 20:28:56 [16] INFO  lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.model,
SUM(TIMESTAMPDIFF(SECOND, a.starttime, a.endtime)) durationtime, 
(SELECT Count(DISTINCT b.memberuserid)  from statistics_shop_duration b WHERE a.model = b.model GROUP BY b.model) uv,
(SELECT Count(c.memberuserid)  from statistics_shop_duration c WHERE a.model = c.model GROUP BY c.model) pv,
IFNULL((SELECT Count(1)  FROM statistics_user_behavior d WHERE d.behaviortype = 1 and a.model = d.model GROUP BY d.model),0) collectiontimes,
IFNULL((SELECT  Count(1)  FROM statistics_user_behavior e WHERE e.behaviortype = 2 and a.model = e.model GROUP BY e.model),0) addcarttimes,
IFNULL((SELECT Count(1)  FROM statistics_user_behavior f WHERE f.behaviortype = 3 and a.model = f.model GROUP BY f.model),0) adddesigntimes,
IFNULL((SELECT Count(1)  FROM statistics_user_behavior g WHERE g.behaviortype = 4 and a.model = g.model GROUP BY g.model),0) addvideotimes,
IFNULL((SELECT Count(1)  FROM statistics_user_behavior h WHERE h.behaviortype = 5 and a.model = h.model GROUP BY h.model),0) sharetimes,
u.registered_companyid as companyid,
u.registered_storedid as storedid from  statistics_shop_duration a left join member_user u on u.id=a.memberuserid  where  1=1  and u.registered_companyid ='10000' group by   a.model order by   a.model asc limit 0,50