[2025-12-07 03:18:37] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:18:37] STMT OK [smsrec insert] affected=1 insert_id=289159
[2025-12-07 03:18:37] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:18:37] SQL OK [create sms_optins] affected=0
[2025-12-07 03:18:37] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+16307404489','+18624571680',NOW(),'stop')
[2025-12-07 03:18:37] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:18:37] 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:18:37] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:18:37] STMT OK [msg insert OUT cid=282974] affected=1 insert_id=573831
[2025-12-07 03:18:37] STMT OK [convo touch operator cid=282974] affected=1 insert_id=0
[2025-12-07 03:18:37] DONE
[2025-12-07 03:18:40] BEGIN method=POST ctype=application/json clen=414
[2025-12-07 03:18:40] MO numbers raw_from=18139971524 raw_to(DID)=18624571680 norm_from=+18139971524 norm_to=+18624571680 msgId=c3075471-a347-4371-ab51-461370baace5 rec_date=2025-12-07 03:18:40
[2025-12-07 03:18:40] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:18:40] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:18:40] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:18:40] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:18:40] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:18:40] SQL OK [create sms_responses] affected=0
[2025-12-07 03:18:40] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:18:40] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:18:40] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:18:40] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:18:40] ensure_open_conversation -> cid=282975
[2025-12-07 03:18:40] STMT OK [convo stamp cid=282975] affected=1 insert_id=0
[2025-12-07 03:18:40] STMT OK [convo select-after-stamp cid=282975] affected=-1 insert_id=0
[2025-12-07 03:18:40] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:18:40] STMT OK [msg insert IN cid=282975] affected=1 insert_id=573832
[2025-12-07 03:18:40] STMT OK [convo counters cid=282975] affected=1 insert_id=0
[2025-12-07 03:18:40] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:18:40] STMT OK [smsrec insert] affected=1 insert_id=289160
[2025-12-07 03:18:40] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:18:40] SQL OK [create sms_optins] affected=0
[2025-12-07 03:18:40] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+18139971524','+18624571680',NOW(),'stop')
[2025-12-07 03:18:40] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:18:40] 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:18:41] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:18:41] STMT OK [msg insert OUT cid=282975] affected=1 insert_id=573833
[2025-12-07 03:18:41] STMT OK [convo touch operator cid=282975] affected=1 insert_id=0
[2025-12-07 03:18:41] DONE
[2025-12-07 03:19:31] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:19:31] MO numbers raw_from=13109383192 raw_to(DID)=18624571680 norm_from=+13109383192 norm_to=+18624571680 msgId=3d334a44-4cb1-4475-ad63-7e65ea3188c3 rec_date=2025-12-07 03:19:31
[2025-12-07 03:19:31] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:19:31] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:19:31] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:19:31] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:19:31] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:19:31] SQL OK [create sms_responses] affected=0
[2025-12-07 03:19:31] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:19:31] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:19:31] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:19:31] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:19:31] ensure_open_conversation -> cid=282976
[2025-12-07 03:19:31] STMT OK [convo stamp cid=282976] affected=1 insert_id=0
[2025-12-07 03:19:31] STMT OK [convo select-after-stamp cid=282976] affected=-1 insert_id=0
[2025-12-07 03:19:31] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:19:31] STMT OK [msg insert IN cid=282976] affected=1 insert_id=573834
[2025-12-07 03:19:31] STMT OK [convo counters cid=282976] affected=1 insert_id=0
[2025-12-07 03:19:31] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:19:31] STMT OK [smsrec insert] affected=1 insert_id=289161
[2025-12-07 03:19:31] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:19:31] SQL OK [create sms_optins] affected=0
[2025-12-07 03:19:31] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+13109383192','+18624571680',NOW(),'stop')
[2025-12-07 03:19:31] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:19:31] 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:19:31] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:19:31] STMT OK [msg insert OUT cid=282976] affected=1 insert_id=573835
[2025-12-07 03:19:31] STMT OK [convo touch operator cid=282976] affected=1 insert_id=0
[2025-12-07 03:19:31] DONE
[2025-12-07 03:20:14] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:20:14] MO numbers raw_from=16096586784 raw_to(DID)=18624571680 norm_from=+16096586784 norm_to=+18624571680 msgId=df12cb07-23d8-49e3-97f2-1516b390599b rec_date=2025-12-07 03:20:14
[2025-12-07 03:20:14] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:14] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:14] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:20:14] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:14] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:20:14] SQL OK [create sms_responses] affected=0
[2025-12-07 03:20:14] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:20:14] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:20:14] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:20:14] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:20:14] ensure_open_conversation -> cid=282977
[2025-12-07 03:20:14] STMT OK [convo stamp cid=282977] affected=1 insert_id=0
[2025-12-07 03:20:14] STMT OK [convo select-after-stamp cid=282977] affected=-1 insert_id=0
[2025-12-07 03:20:14] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:14] STMT OK [msg insert IN cid=282977] affected=1 insert_id=573836
[2025-12-07 03:20:14] STMT OK [convo counters cid=282977] affected=1 insert_id=0
[2025-12-07 03:20:14] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:20:14] STMT OK [smsrec insert] affected=1 insert_id=289162
[2025-12-07 03:20:14] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:20:14] SQL OK [create sms_optins] affected=0
[2025-12-07 03:20:14] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+16096586784','+18624571680',NOW(),'stop')
[2025-12-07 03:20:14] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:20:14] 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:20:14] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:20:14] STMT OK [msg insert OUT cid=282977] affected=1 insert_id=573837
[2025-12-07 03:20:14] STMT OK [convo touch operator cid=282977] affected=1 insert_id=0
[2025-12-07 03:20:14] DONE
[2025-12-07 03:20:33] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:20:33] MO numbers raw_from=15629225704 raw_to(DID)=18624571680 norm_from=+15629225704 norm_to=+18624571680 msgId=f9ae4414-ccd1-4b99-b88d-84fe54444ba8 rec_date=2025-12-07 03:20:32
[2025-12-07 03:20:33] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:33] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:33] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:20:33] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:33] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:20:33] SQL OK [create sms_responses] affected=0
[2025-12-07 03:20:33] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:20:33] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:20:33] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:20:33] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:20:33] ensure_open_conversation -> cid=282978
[2025-12-07 03:20:33] STMT OK [convo stamp cid=282978] affected=1 insert_id=0
[2025-12-07 03:20:33] STMT OK [convo select-after-stamp cid=282978] affected=-1 insert_id=0
[2025-12-07 03:20:33] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:33] STMT OK [msg insert IN cid=282978] affected=1 insert_id=573838
[2025-12-07 03:20:33] STMT OK [convo counters cid=282978] affected=1 insert_id=0
[2025-12-07 03:20:33] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:20:33] STMT OK [smsrec insert] affected=1 insert_id=289163
[2025-12-07 03:20:33] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:20:33] SQL OK [create sms_optins] affected=0
[2025-12-07 03:20:33] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15629225704','+18624571680',NOW(),'stop')
[2025-12-07 03:20:33] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:20:33] 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:20:33] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:20:33] STMT OK [msg insert OUT cid=282978] affected=1 insert_id=573839
[2025-12-07 03:20:33] STMT OK [convo touch operator cid=282978] affected=1 insert_id=0
[2025-12-07 03:20:33] DONE
[2025-12-07 03:20:33] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:20:33] MO numbers raw_from=14083164607 raw_to(DID)=18624571680 norm_from=+14083164607 norm_to=+18624571680 msgId=f4f9e70a-cbe1-4395-b52f-79a1fea2d0ba rec_date=2025-12-07 03:20:33
[2025-12-07 03:20:33] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:33] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:33] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:20:33] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:33] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:20:33] SQL OK [create sms_responses] affected=0
[2025-12-07 03:20:33] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:20:33] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:20:33] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:20:33] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:20:33] ensure_open_conversation -> cid=282979
[2025-12-07 03:20:33] STMT OK [convo stamp cid=282979] affected=1 insert_id=0
[2025-12-07 03:20:33] STMT OK [convo select-after-stamp cid=282979] affected=-1 insert_id=0
[2025-12-07 03:20:33] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:33] STMT OK [msg insert IN cid=282979] affected=1 insert_id=573840
[2025-12-07 03:20:33] STMT OK [convo counters cid=282979] affected=1 insert_id=0
[2025-12-07 03:20:33] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:20:33] STMT OK [smsrec insert] affected=1 insert_id=289164
[2025-12-07 03:20:33] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:20:33] SQL OK [create sms_optins] affected=0
[2025-12-07 03:20:33] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+14083164607','+18624571680',NOW(),'stop')
[2025-12-07 03:20:33] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:20:33] 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:20:33] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:20:33] STMT OK [msg insert OUT cid=282979] affected=1 insert_id=573841
[2025-12-07 03:20:33] STMT OK [convo touch operator cid=282979] affected=1 insert_id=0
[2025-12-07 03:20:33] DONE
[2025-12-07 03:20:42] BEGIN method=POST ctype=application/json clen=417
[2025-12-07 03:20:42] MO numbers raw_from=16107246120 raw_to(DID)=18624571680 norm_from=+16107246120 norm_to=+18624571680 msgId=3f1f329e-f49e-4fc2-a202-c99f5bd7f5ca rec_date=2025-12-07 03:20:42
[2025-12-07 03:20:42] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:42] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:20:42] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:20:42] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:42] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:20:42] SQL OK [create sms_responses] affected=0
[2025-12-07 03:20:42] STMT OK [keyword reverse-like lookup norm=59doara] affected=-1 insert_id=0
[2025-12-07 03:20:42] KW result code=null optout=0 auto_reply=0 match=null
[2025-12-07 03:20:42] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:20:42] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:20:42] ensure_open_conversation -> cid=157906
[2025-12-07 03:20:42] STMT OK [convo stamp cid=157906] affected=0 insert_id=0
[2025-12-07 03:20:42] STMT OK [convo select-after-stamp cid=157906] affected=-1 insert_id=0
[2025-12-07 03:20:42] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:20:42] STMT OK [msg insert IN cid=157906] affected=1 insert_id=573842
[2025-12-07 03:20:42] STMT OK [convo counters cid=157906] affected=1 insert_id=0
[2025-12-07 03:20:42] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:20:42] STMT OK [smsrec insert] affected=1 insert_id=289165
[2025-12-07 03:20:42] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:20:42] SQL OK [create sms_optins] affected=0
[2025-12-07 03:20:42] keyword_code:[] is_optout:[0] auto_reply:[0] response_text:[] match:[]
[2025-12-07 03:20:42] DONE
[2025-12-07 03:21:04] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:21:04] MO numbers raw_from=14252604675 raw_to(DID)=18624571680 norm_from=+14252604675 norm_to=+18624571680 msgId=d6b52a73-8c6b-41a3-b009-71e2533a7438 rec_date=2025-12-07 03:21:04
[2025-12-07 03:21:04] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:21:04] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:21:04] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:21:04] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:21:04] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:21:04] SQL OK [create sms_responses] affected=0
[2025-12-07 03:21:04] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:21:04] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:21:04] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:21:04] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:21:04] ensure_open_conversation -> cid=282980
[2025-12-07 03:21:04] STMT OK [convo stamp cid=282980] affected=1 insert_id=0
[2025-12-07 03:21:04] STMT OK [convo select-after-stamp cid=282980] affected=-1 insert_id=0
[2025-12-07 03:21:04] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:21:04] STMT OK [msg insert IN cid=282980] affected=1 insert_id=573843
[2025-12-07 03:21:04] STMT OK [convo counters cid=282980] affected=1 insert_id=0
[2025-12-07 03:21:04] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:21:04] STMT OK [smsrec insert] affected=1 insert_id=289166
[2025-12-07 03:21:04] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:21:04] SQL OK [create sms_optins] affected=0
[2025-12-07 03:21:04] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+14252604675','+18624571680',NOW(),'stop')
[2025-12-07 03:21:04] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:21:04] 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:21:04] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:21:04] STMT OK [msg insert OUT cid=282980] affected=1 insert_id=573844
[2025-12-07 03:21:04] STMT OK [convo touch operator cid=282980] affected=1 insert_id=0
[2025-12-07 03:21:04] DONE
[2025-12-07 03:22:03] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:22:03] MO numbers raw_from=15306040175 raw_to(DID)=18624571680 norm_from=+15306040175 norm_to=+18624571680 msgId=8a990fdf-83bb-472b-b48c-69d5830f15c3 rec_date=2025-12-07 03:22:03
[2025-12-07 03:22:03] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:22:03] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:22:03] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:22:03] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:22:03] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:22:03] SQL OK [create sms_responses] affected=0
[2025-12-07 03:22:03] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:22:03] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:22:03] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:22:03] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:22:03] ensure_open_conversation -> cid=282981
[2025-12-07 03:22:03] STMT OK [convo stamp cid=282981] affected=1 insert_id=0
[2025-12-07 03:22:03] STMT OK [convo select-after-stamp cid=282981] affected=-1 insert_id=0
[2025-12-07 03:22:03] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:22:03] STMT OK [msg insert IN cid=282981] affected=1 insert_id=573845
[2025-12-07 03:22:03] STMT OK [convo counters cid=282981] affected=1 insert_id=0
[2025-12-07 03:22:03] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:22:03] STMT OK [smsrec insert] affected=1 insert_id=289167
[2025-12-07 03:22:03] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:22:03] SQL OK [create sms_optins] affected=0
[2025-12-07 03:22:03] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15306040175','+18624571680',NOW(),'stop')
[2025-12-07 03:22:03] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:22:03] 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:22:03] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:22:03] STMT OK [msg insert OUT cid=282981] affected=1 insert_id=573846
[2025-12-07 03:22:03] STMT OK [convo touch operator cid=282981] affected=1 insert_id=0
[2025-12-07 03:22:03] DONE
[2025-12-07 03:22:11] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:22:11] MO numbers raw_from=15419904002 raw_to(DID)=18624571680 norm_from=+15419904002 norm_to=+18624571680 msgId=cd7d3da5-2cf0-46b3-8772-efcab9c1c7c6 rec_date=2025-12-07 03:22:11
[2025-12-07 03:22:11] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:22:11] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:22:11] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:22:11] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:22:11] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:22:11] SQL OK [create sms_responses] affected=0
[2025-12-07 03:22:11] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:22:11] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:22:11] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:22:11] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:22:11] ensure_open_conversation -> cid=282982
[2025-12-07 03:22:11] STMT OK [convo stamp cid=282982] affected=1 insert_id=0
[2025-12-07 03:22:11] STMT OK [convo select-after-stamp cid=282982] affected=-1 insert_id=0
[2025-12-07 03:22:11] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:22:11] STMT OK [msg insert IN cid=282982] affected=1 insert_id=573847
[2025-12-07 03:22:11] STMT OK [convo counters cid=282982] affected=1 insert_id=0
[2025-12-07 03:22:11] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:22:11] STMT OK [smsrec insert] affected=1 insert_id=289168
[2025-12-07 03:22:11] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:22:11] SQL OK [create sms_optins] affected=0
[2025-12-07 03:22:11] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15419904002','+18624571680',NOW(),'stop')
[2025-12-07 03:22:11] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:22:11] 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:22:11] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:22:11] STMT OK [msg insert OUT cid=282982] affected=1 insert_id=573848
[2025-12-07 03:22:11] STMT OK [convo touch operator cid=282982] affected=1 insert_id=0
[2025-12-07 03:22:11] DONE
[2025-12-07 03:23:38] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:23:38] MO numbers raw_from=18143082342 raw_to(DID)=18624571680 norm_from=+18143082342 norm_to=+18624571680 msgId=f16b9057-a66c-41f2-8cbe-6bd267468604 rec_date=2025-12-07 03:23:37
[2025-12-07 03:23:38] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:38] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:38] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:23:38] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:38] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:23:38] SQL OK [create sms_responses] affected=0
[2025-12-07 03:23:38] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:23:38] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:23:38] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:23:38] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:23:38] ensure_open_conversation -> cid=282983
[2025-12-07 03:23:38] STMT OK [convo stamp cid=282983] affected=1 insert_id=0
[2025-12-07 03:23:38] STMT OK [convo select-after-stamp cid=282983] affected=-1 insert_id=0
[2025-12-07 03:23:38] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:38] STMT OK [msg insert IN cid=282983] affected=1 insert_id=573849
[2025-12-07 03:23:38] STMT OK [convo counters cid=282983] affected=1 insert_id=0
[2025-12-07 03:23:38] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:23:38] STMT OK [smsrec insert] affected=1 insert_id=289169
[2025-12-07 03:23:38] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:23:38] SQL OK [create sms_optins] affected=0
[2025-12-07 03:23:38] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+18143082342','+18624571680',NOW(),'stop')
[2025-12-07 03:23:38] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:23:38] 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:23:38] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:23:38] STMT OK [msg insert OUT cid=282983] affected=1 insert_id=573850
[2025-12-07 03:23:38] STMT OK [convo touch operator cid=282983] affected=1 insert_id=0
[2025-12-07 03:23:38] DONE
[2025-12-07 03:23:48] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:23:48] MO numbers raw_from=16192658383 raw_to(DID)=18624571680 norm_from=+16192658383 norm_to=+18624571680 msgId=0fc76e45-a31c-42b3-863e-5ab539e65b74 rec_date=2025-12-07 03:23:48
[2025-12-07 03:23:48] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:48] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:48] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:23:48] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:48] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:23:48] SQL OK [create sms_responses] affected=0
[2025-12-07 03:23:48] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:23:48] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:23:48] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:23:48] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:23:48] ensure_open_conversation -> cid=282984
[2025-12-07 03:23:48] STMT OK [convo stamp cid=282984] affected=1 insert_id=0
[2025-12-07 03:23:48] STMT OK [convo select-after-stamp cid=282984] affected=-1 insert_id=0
[2025-12-07 03:23:48] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:48] STMT OK [msg insert IN cid=282984] affected=1 insert_id=573851
[2025-12-07 03:23:48] STMT OK [convo counters cid=282984] affected=1 insert_id=0
[2025-12-07 03:23:48] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:23:48] STMT OK [smsrec insert] affected=1 insert_id=289170
[2025-12-07 03:23:48] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:23:48] SQL OK [create sms_optins] affected=0
[2025-12-07 03:23:48] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+16192658383','+18624571680',NOW(),'stop')
[2025-12-07 03:23:48] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:23: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:23:48] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:23:48] STMT OK [msg insert OUT cid=282984] affected=1 insert_id=573852
[2025-12-07 03:23:48] STMT OK [convo touch operator cid=282984] affected=1 insert_id=0
[2025-12-07 03:23:48] DONE
[2025-12-07 03:23:57] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:23:57] MO numbers raw_from=14156403574 raw_to(DID)=18624571680 norm_from=+14156403574 norm_to=+18624571680 msgId=789257c8-90fb-4b45-a709-5af9c34b1f0d rec_date=2025-12-07 03:23:57
[2025-12-07 03:23:57] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:57] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:57] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:23:57] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:57] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:23:57] SQL OK [create sms_responses] affected=0
[2025-12-07 03:23:57] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:23:57] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:23:57] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:23:57] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:23:57] ensure_open_conversation -> cid=282985
[2025-12-07 03:23:57] STMT OK [convo stamp cid=282985] affected=1 insert_id=0
[2025-12-07 03:23:57] STMT OK [convo select-after-stamp cid=282985] affected=-1 insert_id=0
[2025-12-07 03:23:57] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:57] STMT OK [msg insert IN cid=282985] affected=1 insert_id=573853
[2025-12-07 03:23:57] STMT OK [convo counters cid=282985] affected=1 insert_id=0
[2025-12-07 03:23:57] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:23:57] STMT OK [smsrec insert] affected=1 insert_id=289171
[2025-12-07 03:23:57] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:23:57] SQL OK [create sms_optins] affected=0
[2025-12-07 03:23:57] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+14156403574','+18624571680',NOW(),'stop')
[2025-12-07 03:23:57] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:23:57] 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:23:57] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:23:57] STMT OK [msg insert OUT cid=282985] affected=1 insert_id=573854
[2025-12-07 03:23:57] STMT OK [convo touch operator cid=282985] affected=1 insert_id=0
[2025-12-07 03:23:57] DONE
[2025-12-07 03:24:14] BEGIN method=POST ctype=application/json clen=420
[2025-12-07 03:24:14] MO numbers raw_from=15035397184 raw_to(DID)=18624571680 norm_from=+15035397184 norm_to=+18624571680 msgId=1c949a5c-22b1-452b-ba88-04f8001fc6c8 rec_date=2025-12-07 03:24:14
[2025-12-07 03:24:14] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:14] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:14] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:24:14] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:14] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:24:14] SQL OK [create sms_responses] affected=0
[2025-12-07 03:24:14] STMT OK [keyword reverse-like lookup norm=stoptoend] affected=-1 insert_id=0
[2025-12-07 03:24:14] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:24:14] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:24:14] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:24:14] ensure_open_conversation -> cid=282986
[2025-12-07 03:24:14] STMT OK [convo stamp cid=282986] affected=1 insert_id=0
[2025-12-07 03:24:14] STMT OK [convo select-after-stamp cid=282986] affected=-1 insert_id=0
[2025-12-07 03:24:14] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:14] STMT OK [msg insert IN cid=282986] affected=1 insert_id=573855
[2025-12-07 03:24:14] STMT OK [convo counters cid=282986] affected=1 insert_id=0
[2025-12-07 03:24:14] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:24:14] STMT OK [smsrec insert] affected=1 insert_id=289172
[2025-12-07 03:24:14] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:24:14] SQL OK [create sms_optins] affected=0
[2025-12-07 03:24:14] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15035397184','+18624571680',NOW(),'stop')
[2025-12-07 03:24:14] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:24:14] 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:24:15] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:24:15] STMT OK [msg insert OUT cid=282986] affected=1 insert_id=573856
[2025-12-07 03:24:15] STMT OK [convo touch operator cid=282986] affected=1 insert_id=0
[2025-12-07 03:24:15] DONE
[2025-12-07 03:24:32] BEGIN method=POST ctype=application/json clen=412
[2025-12-07 03:24:32] MO numbers raw_from=15613580925 raw_to(DID)=18624571680 norm_from=+15613580925 norm_to=+18624571680 msgId=8292d111-8ca6-4ea7-893e-e18d170349b4 rec_date=2025-12-07 03:24:32
[2025-12-07 03:24:32] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:32] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:32] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:24:32] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:32] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:24:32] SQL OK [create sms_responses] affected=0
[2025-12-07 03:24:32] STMT OK [keyword reverse-like lookup norm=end] affected=-1 insert_id=0
[2025-12-07 03:24:32] KW result code=OPTOUT optout=1 auto_reply=1 match=end
[2025-12-07 03:24:32] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:24:32] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:24:32] ensure_open_conversation -> cid=282987
[2025-12-07 03:24:32] STMT OK [convo stamp cid=282987] affected=1 insert_id=0
[2025-12-07 03:24:32] STMT OK [convo select-after-stamp cid=282987] affected=-1 insert_id=0
[2025-12-07 03:24:32] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:32] STMT OK [msg insert IN cid=282987] affected=1 insert_id=573857
[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