[2025-12-07 03:24:32] STMT OK [convo counters cid=282987] affected=1 insert_id=0
[2025-12-07 03:24:32] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:24:32] STMT OK [smsrec insert] affected=1 insert_id=289173
[2025-12-07 03:24:32] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:24:32] SQL OK [create sms_optins] affected=0
[2025-12-07 03:24:32] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15613580925','+18624571680',NOW(),'end')
[2025-12-07 03:24:32] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:24:32] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[end]
[2025-12-07 03:24:32] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:24:32] STMT OK [msg insert OUT cid=282987] affected=1 insert_id=573858
[2025-12-07 03:24:32] STMT OK [convo touch operator cid=282987] affected=1 insert_id=0
[2025-12-07 03:24:32] DONE
[2025-12-07 03:25:13] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:25:13] MO numbers raw_from=19097099631 raw_to(DID)=18624571680 norm_from=+19097099631 norm_to=+18624571680 msgId=59c41127-35d5-4d1c-af5b-0e906b253f5c rec_date=2025-12-07 03:25:13
[2025-12-07 03:25:13] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:13] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:13] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:25:13] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:13] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:25:13] SQL OK [create sms_responses] affected=0
[2025-12-07 03:25:13] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:25:13] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:25:13] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:25:13] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:25:13] ensure_open_conversation -> cid=282988
[2025-12-07 03:25:13] STMT OK [convo stamp cid=282988] affected=1 insert_id=0
[2025-12-07 03:25:13] STMT OK [convo select-after-stamp cid=282988] affected=-1 insert_id=0
[2025-12-07 03:25:13] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:13] STMT OK [msg insert IN cid=282988] affected=1 insert_id=573859
[2025-12-07 03:25:13] STMT OK [convo counters cid=282988] affected=1 insert_id=0
[2025-12-07 03:25:13] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:25:13] STMT OK [smsrec insert] affected=1 insert_id=289174
[2025-12-07 03:25:13] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:25:13] SQL OK [create sms_optins] affected=0
[2025-12-07 03:25:13] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+19097099631','+18624571680',NOW(),'stop')
[2025-12-07 03:25:13] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:25:13] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:25:13] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:25:13] STMT OK [msg insert OUT cid=282988] affected=1 insert_id=573860
[2025-12-07 03:25:13] STMT OK [convo touch operator cid=282988] affected=1 insert_id=0
[2025-12-07 03:25:13] DONE
[2025-12-07 03:25:48] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:25:48] MO numbers raw_from=15035021981 raw_to(DID)=18624571680 norm_from=+15035021981 norm_to=+18624571680 msgId=1f0e9227-8c0d-4093-9fcb-99ddb6e97fe2 rec_date=2025-12-07 03:25:48
[2025-12-07 03:25:48] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:48] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:48] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:25:48] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:48] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:25:48] SQL OK [create sms_responses] affected=0
[2025-12-07 03:25:48] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:25:48] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:25:48] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:25:48] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:25:48] ensure_open_conversation -> cid=282989
[2025-12-07 03:25:48] STMT OK [convo stamp cid=282989] affected=1 insert_id=0
[2025-12-07 03:25:48] STMT OK [convo select-after-stamp cid=282989] affected=-1 insert_id=0
[2025-12-07 03:25:48] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:48] STMT OK [msg insert IN cid=282989] affected=1 insert_id=573861
[2025-12-07 03:25:48] STMT OK [convo counters cid=282989] affected=1 insert_id=0
[2025-12-07 03:25:48] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:25:48] STMT OK [smsrec insert] affected=1 insert_id=289175
[2025-12-07 03:25:48] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:25:48] SQL OK [create sms_optins] affected=0
[2025-12-07 03:25:48] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15035021981','+18624571680',NOW(),'stop')
[2025-12-07 03:25:48] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:25:48] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:25:48] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:25:48] STMT OK [msg insert OUT cid=282989] affected=1 insert_id=573862
[2025-12-07 03:25:48] STMT OK [convo touch operator cid=282989] affected=1 insert_id=0
[2025-12-07 03:25:48] DONE
[2025-12-07 03:26:02] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:26:02] MO numbers raw_from=13109183644 raw_to(DID)=18624571680 norm_from=+13109183644 norm_to=+18624571680 msgId=9e64d3b3-7948-48c9-87a7-a5377da43781 rec_date=2025-12-07 03:26:02
[2025-12-07 03:26:02] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:26:02] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:26:02] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:26:02] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:26:02] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:26:02] SQL OK [create sms_responses] affected=0
[2025-12-07 03:26:02] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:26:02] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:26:02] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:26:02] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:26:02] ensure_open_conversation -> cid=282990
[2025-12-07 03:26:02] STMT OK [convo stamp cid=282990] affected=1 insert_id=0
[2025-12-07 03:26:02] STMT OK [convo select-after-stamp cid=282990] affected=-1 insert_id=0
[2025-12-07 03:26:02] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:26:02] STMT OK [msg insert IN cid=282990] affected=1 insert_id=573863
[2025-12-07 03:26:02] STMT OK [convo counters cid=282990] affected=1 insert_id=0
[2025-12-07 03:26:02] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:26:02] STMT OK [smsrec insert] affected=1 insert_id=289176
[2025-12-07 03:26:02] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:26:02] SQL OK [create sms_optins] affected=0
[2025-12-07 03:26:02] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+13109183644','+18624571680',NOW(),'stop')
[2025-12-07 03:26:02] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:26:02] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:26:02] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:26:02] STMT OK [msg insert OUT cid=282990] affected=1 insert_id=573864
[2025-12-07 03:26:02] STMT OK [convo touch operator cid=282990] affected=1 insert_id=0
[2025-12-07 03:26:02] DONE