[2025-12-07 03:14:37] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:14:37] SQL OK [create sms_responses] affected=0
[2025-12-07 03:14:37] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:14:37] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:14:37] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:14:37] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:14:37] ensure_open_conversation -> cid=282959
[2025-12-07 03:14:37] STMT OK [convo stamp cid=282959] affected=1 insert_id=0
[2025-12-07 03:14:37] STMT OK [convo select-after-stamp cid=282959] affected=-1 insert_id=0
[2025-12-07 03:14:37] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:14:37] STMT OK [msg insert IN cid=282959] affected=1 insert_id=573797
[2025-12-07 03:14:37] STMT OK [convo counters cid=282959] affected=1 insert_id=0
[2025-12-07 03:14:37] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:14:37] STMT OK [smsrec insert] affected=1 insert_id=289142
[2025-12-07 03:14:37] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:14:37] SQL OK [create sms_optins] affected=0
[2025-12-07 03:14:37] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+19204105875','+18624571680',NOW(),'stop')
[2025-12-07 03:14:37] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:14: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:14:37] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:14:37] STMT OK [msg insert OUT cid=282959] affected=1 insert_id=573798
[2025-12-07 03:14:37] STMT OK [convo touch operator cid=282959] affected=1 insert_id=0
[2025-12-07 03:14:37] DONE
[2025-12-07 03:14:41] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:14:41] MO numbers raw_from=18087858706 raw_to(DID)=18624571680 norm_from=+18087858706 norm_to=+18624571680 msgId=d739915d-30f6-4d4b-b38d-0930cc4542cc rec_date=2025-12-07 03:14:40
[2025-12-07 03:14:41] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:14:41] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:14:41] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:14:41] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:14:41] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:14:41] SQL OK [create sms_responses] affected=0
[2025-12-07 03:14:41] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:14:41] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:14:41] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:14:41] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:14:41] ensure_open_conversation -> cid=282960
[2025-12-07 03:14:41] STMT OK [convo stamp cid=282960] affected=1 insert_id=0
[2025-12-07 03:14:41] STMT OK [convo select-after-stamp cid=282960] affected=-1 insert_id=0
[2025-12-07 03:14:41] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:14:41] STMT OK [msg insert IN cid=282960] affected=1 insert_id=573799
[2025-12-07 03:14:41] STMT OK [convo counters cid=282960] affected=1 insert_id=0
[2025-12-07 03:14:41] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:14:41] STMT OK [smsrec insert] affected=1 insert_id=289143
[2025-12-07 03:14:41] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:14:41] SQL OK [create sms_optins] affected=0
[2025-12-07 03:14:41] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+18087858706','+18624571680',NOW(),'stop')
[2025-12-07 03:14:41] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:14:41] 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:14:41] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:14:41] STMT OK [msg insert OUT cid=282960] affected=1 insert_id=573800
[2025-12-07 03:14:41] STMT OK [convo touch operator cid=282960] affected=1 insert_id=0
[2025-12-07 03:14:41] DONE
[2025-12-07 03:14:55] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:14:55] MO numbers raw_from=14149403932 raw_to(DID)=18624571680 norm_from=+14149403932 norm_to=+18624571680 msgId=b5f61984-6c8b-49b3-b2fb-c83a8c32d939 rec_date=2025-12-07 03:14:55
[2025-12-07 03:14:55] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:14:55] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:14:55] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:14:55] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:14:55] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:14:55] SQL OK [create sms_responses] affected=0
[2025-12-07 03:14:55] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:14:55] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:14:55] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:14:55] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:14:55] ensure_open_conversation -> cid=282961
[2025-12-07 03:14:55] STMT OK [convo stamp cid=282961] affected=1 insert_id=0
[2025-12-07 03:14:55] STMT OK [convo select-after-stamp cid=282961] affected=-1 insert_id=0
[2025-12-07 03:14:55] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:14:55] STMT OK [msg insert IN cid=282961] affected=1 insert_id=573801
[2025-12-07 03:14:55] STMT OK [convo counters cid=282961] affected=1 insert_id=0
[2025-12-07 03:14:55] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:14:55] STMT OK [smsrec insert] affected=1 insert_id=289144
[2025-12-07 03:14:55] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:14:55] SQL OK [create sms_optins] affected=0
[2025-12-07 03:14:55] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+14149403932','+18624571680',NOW(),'stop')
[2025-12-07 03:14:55] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:14:55] 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:14:55] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:14:55] STMT OK [msg insert OUT cid=282961] affected=1 insert_id=573802
[2025-12-07 03:14:55] STMT OK [convo touch operator cid=282961] affected=1 insert_id=0
[2025-12-07 03:14:55] DONE
[2025-12-07 03:15:07] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:15:07] MO numbers raw_from=17147377490 raw_to(DID)=18624571680 norm_from=+17147377490 norm_to=+18624571680 msgId=acecb135-f1fe-4d9e-9efc-8827daaae831 rec_date=2025-12-07 03:15:07
[2025-12-07 03:15:07] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:07] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:07] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:15:07] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:07] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:15:07] SQL OK [create sms_responses] affected=0
[2025-12-07 03:15:07] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:15:07] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:15:07] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:15:07] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:15:07] ensure_open_conversation -> cid=282962
[2025-12-07 03:15:07] STMT OK [convo stamp cid=282962] affected=1 insert_id=0
[2025-12-07 03:15:07] STMT OK [convo select-after-stamp cid=282962] affected=-1 insert_id=0
[2025-12-07 03:15:07] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:07] STMT OK [msg insert IN cid=282962] affected=1 insert_id=573803
[2025-12-07 03:15:07] STMT OK [convo counters cid=282962] affected=1 insert_id=0
[2025-12-07 03:15:07] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:15:07] STMT OK [smsrec insert] affected=1 insert_id=289145
[2025-12-07 03:15:07] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:15:07] SQL OK [create sms_optins] affected=0
[2025-12-07 03:15:07] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+17147377490','+18624571680',NOW(),'stop')
[2025-12-07 03:15:07] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:15:07] 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:15:07] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:15:07] STMT OK [msg insert OUT cid=282962] affected=1 insert_id=573804
[2025-12-07 03:15:07] STMT OK [convo touch operator cid=282962] affected=1 insert_id=0
[2025-12-07 03:15:07] DONE
[2025-12-07 03:15:17] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:15:17] MO numbers raw_from=13106135967 raw_to(DID)=18624571680 norm_from=+13106135967 norm_to=+18624571680 msgId=e167bd96-0790-4847-add3-de5f9cb83008 rec_date=2025-12-07 03:15:17
[2025-12-07 03:15:17] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:17] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:17] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:15:17] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:17] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:15:17] SQL OK [create sms_responses] affected=0
[2025-12-07 03:15:17] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:15:17] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:15:17] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:15:17] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:15:17] ensure_open_conversation -> cid=282963
[2025-12-07 03:15:17] STMT OK [convo stamp cid=282963] affected=1 insert_id=0
[2025-12-07 03:15:17] STMT OK [convo select-after-stamp cid=282963] affected=-1 insert_id=0
[2025-12-07 03:15:17] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:17] STMT OK [msg insert IN cid=282963] affected=1 insert_id=573805
[2025-12-07 03:15:17] STMT OK [convo counters cid=282963] affected=1 insert_id=0
[2025-12-07 03:15:17] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:15:17] STMT OK [smsrec insert] affected=1 insert_id=289146
[2025-12-07 03:15:17] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:15:17] SQL OK [create sms_optins] affected=0
[2025-12-07 03:15:17] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+13106135967','+18624571680',NOW(),'stop')
[2025-12-07 03:15:17] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:15:17] 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:15:17] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:15:17] STMT OK [msg insert OUT cid=282963] affected=1 insert_id=573806
[2025-12-07 03:15:17] STMT OK [convo touch operator cid=282963] affected=1 insert_id=0
[2025-12-07 03:15:17] DONE
[2025-12-07 03:15:26] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:15:26] MO numbers raw_from=17147377490 raw_to(DID)=18624571680 norm_from=+17147377490 norm_to=+18624571680 msgId=88925aab-df92-46d6-b98f-1dd74fc2b6e6 rec_date=2025-12-07 03:15:26
[2025-12-07 03:15:26] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:26] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:26] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:15:26] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:26] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:15:26] SQL OK [create sms_responses] affected=0
[2025-12-07 03:15:26] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:15:26] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:15:26] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:15:26] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:15:26] ensure_open_conversation -> cid=282962
[2025-12-07 03:15:26] STMT OK [convo stamp cid=282962] affected=0 insert_id=0
[2025-12-07 03:15:26] STMT OK [convo select-after-stamp cid=282962] affected=-1 insert_id=0
[2025-12-07 03:15:26] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:26] STMT OK [msg insert IN cid=282962] affected=1 insert_id=573807
[2025-12-07 03:15:26] STMT OK [convo counters cid=282962] affected=1 insert_id=0
[2025-12-07 03:15:26] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:15:26] STMT OK [smsrec insert] affected=1 insert_id=289147
[2025-12-07 03:15:26] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:15:26] SQL OK [create sms_optins] affected=0
[2025-12-07 03:15:26] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+17147377490','+18624571680',NOW(),'stop')
[2025-12-07 03:15:26] STMT OK [optout upsert] affected=2 insert_id=0
[2025-12-07 03:15:26] 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:15:26] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:15:27] STMT OK [msg insert OUT cid=282962] affected=1 insert_id=573808
[2025-12-07 03:15:27] STMT OK [convo touch operator cid=282962] affected=1 insert_id=0
[2025-12-07 03:15:27] DONE
[2025-12-07 03:15:40] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:15:40] MO numbers raw_from=13219480033 raw_to(DID)=18624571680 norm_from=+13219480033 norm_to=+18624571680 msgId=ae153c67-866d-47b2-b612-13611cba4bbb rec_date=2025-12-07 03:15:40
[2025-12-07 03:15:40] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:40] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:15:40] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:15:40] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:40] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:15:40] SQL OK [create sms_responses] affected=0
[2025-12-07 03:15:40] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:15:40] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:15:40] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:15:40] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:15:40] ensure_open_conversation -> cid=282964
[2025-12-07 03:15:40] STMT OK [convo stamp cid=282964] affected=1 insert_id=0
[2025-12-07 03:15:40] STMT OK [convo select-after-stamp cid=282964] affected=-1 insert_id=0
[2025-12-07 03:15:40] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:15:40] STMT OK [msg insert IN cid=282964] affected=1 insert_id=573809
[2025-12-07 03:15:40] STMT OK [convo counters cid=282964] affected=1 insert_id=0
[2025-12-07 03:15:40] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:15:40] STMT OK [smsrec insert] affected=1 insert_id=289148
[2025-12-07 03:15:40] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:15:40] SQL OK [create sms_optins] affected=0
[2025-12-07 03:15:40] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+13219480033','+18624571680',NOW(),'stop')
[2025-12-07 03:15:40] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:15: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:15:40] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:15:40] STMT OK [msg insert OUT cid=282964] affected=1 insert_id=573810
[2025-12-07 03:15:40] STMT OK [convo touch operator cid=282964] affected=1 insert_id=0
[2025-12-07 03:15:40] DONE
[2025-12-07 03:16:04] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:16:04] MO numbers raw_from=16158043492 raw_to(DID)=18624571680 norm_from=+16158043492 norm_to=+18624571680 msgId=23193134-1d9c-4b7e-89f9-73f2ee882d20 rec_date=2025-12-07 03:16:04
[2025-12-07 03:16:04] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:04] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:04] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:16:04] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:04] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:16:04] SQL OK [create sms_responses] affected=0
[2025-12-07 03:16:04] STMT OK [keyword reverse-like lookup norm=sto0] affected=-1 insert_id=0
[2025-12-07 03:16:04] KW result code=null optout=0 auto_reply=0 match=null
[2025-12-07 03:16:04] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:16:04] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:16:04] ensure_open_conversation -> cid=282965
[2025-12-07 03:16:04] STMT OK [convo stamp cid=282965] affected=1 insert_id=0
[2025-12-07 03:16:04] STMT OK [convo select-after-stamp cid=282965] affected=-1 insert_id=0
[2025-12-07 03:16:04] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:04] STMT OK [msg insert IN cid=282965] affected=1 insert_id=573811
[2025-12-07 03:16:04] STMT OK [convo counters cid=282965] affected=1 insert_id=0
[2025-12-07 03:16:04] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:16:04] STMT OK [smsrec insert] affected=1 insert_id=289149
[2025-12-07 03:16:04] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:16:04] SQL OK [create sms_optins] affected=0
[2025-12-07 03:16:04] keyword_code:[] is_optout:[0] auto_reply:[0] response_text:[] match:[]
[2025-12-07 03:16:04] DONE
[2025-12-07 03:16:11] BEGIN method=POST ctype=application/json clen=414
[2025-12-07 03:16:11] MO numbers raw_from=12534322213 raw_to(DID)=18624571680 norm_from=+12534322213 norm_to=+18624571680 msgId=cc763f13-3181-4755-8160-46b99d0b8779 rec_date=2025-12-07 03:16:11
[2025-12-07 03:16:11] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:11] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:11] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:16:11] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:11] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:16:11] SQL OK [create sms_responses] affected=0
[2025-12-07 03:16:11] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:16:11] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:16:11] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:16:11] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:16:11] ensure_open_conversation -> cid=282966
[2025-12-07 03:16:11] STMT OK [convo stamp cid=282966] affected=1 insert_id=0
[2025-12-07 03:16:11] STMT OK [convo select-after-stamp cid=282966] affected=-1 insert_id=0
[2025-12-07 03:16:11] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:11] STMT OK [msg insert IN cid=282966] affected=1 insert_id=573812
[2025-12-07 03:16:11] STMT OK [convo counters cid=282966] affected=1 insert_id=0
[2025-12-07 03:16:11] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:16:11] STMT OK [smsrec insert] affected=1 insert_id=289150
[2025-12-07 03:16:11] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:16:11] SQL OK [create sms_optins] affected=0
[2025-12-07 03:16:11] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+12534322213','+18624571680',NOW(),'stop')
[2025-12-07 03:16:11] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:16: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:16:11] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:16:11] STMT OK [msg insert OUT cid=282966] affected=1 insert_id=573813
[2025-12-07 03:16:11] STMT OK [convo touch operator cid=282966] affected=1 insert_id=0
[2025-12-07 03:16:11] DONE
[2025-12-07 03:16:12] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:16:12] MO numbers raw_from=16158043492 raw_to(DID)=18624571680 norm_from=+16158043492 norm_to=+18624571680 msgId=fe49ced0-a190-4615-84ba-139795d0d0dc rec_date=2025-12-07 03:16:12
[2025-12-07 03:16:12] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:12] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:12] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:16:12] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:12] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:16:12] SQL OK [create sms_responses] affected=0
[2025-12-07 03:16:12] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:16:12] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:16:12] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:16:12] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:16:12] ensure_open_conversation -> cid=282965
[2025-12-07 03:16:12] STMT OK [convo stamp cid=282965] affected=0 insert_id=0
[2025-12-07 03:16:12] STMT OK [convo select-after-stamp cid=282965] affected=-1 insert_id=0
[2025-12-07 03:16:12] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:12] STMT OK [msg insert IN cid=282965] affected=1 insert_id=573814
[2025-12-07 03:16:12] STMT OK [convo counters cid=282965] affected=1 insert_id=0
[2025-12-07 03:16:12] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:16:12] STMT OK [smsrec insert] affected=1 insert_id=289151
[2025-12-07 03:16:12] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:16:12] SQL OK [create sms_optins] affected=0
[2025-12-07 03:16:12] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+16158043492','+18624571680',NOW(),'stop')
[2025-12-07 03:16:12] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:16:12] 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:16:12] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:16:12] STMT OK [msg insert OUT cid=282965] affected=1 insert_id=573815
[2025-12-07 03:16:12] STMT OK [convo touch operator cid=282965] affected=1 insert_id=0
[2025-12-07 03:16:12] DONE
[2025-12-07 03:16:24] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:16:24] MO numbers raw_from=15415256174 raw_to(DID)=18624571680 norm_from=+15415256174 norm_to=+18624571680 msgId=137a91d2-561c-423b-ab8e-721416eaa46d rec_date=2025-12-07 03:16:24
[2025-12-07 03:16:24] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:24] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:24] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:16:24] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:24] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:16:24] SQL OK [create sms_responses] affected=0
[2025-12-07 03:16:24] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:16:24] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:16:24] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:16:24] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:16:24] ensure_open_conversation -> cid=282967
[2025-12-07 03:16:24] STMT OK [convo stamp cid=282967] affected=1 insert_id=0
[2025-12-07 03:16:24] STMT OK [convo select-after-stamp cid=282967] affected=-1 insert_id=0
[2025-12-07 03:16:24] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:24] STMT OK [msg insert IN cid=282967] affected=1 insert_id=573816
[2025-12-07 03:16:24] STMT OK [convo counters cid=282967] affected=1 insert_id=0
[2025-12-07 03:16:24] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:16:24] STMT OK [smsrec insert] affected=1 insert_id=289152
[2025-12-07 03:16:24] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:16:24] SQL OK [create sms_optins] affected=0
[2025-12-07 03:16:24] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15415256174','+18624571680',NOW(),'stop')
[2025-12-07 03:16:24] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:16:24] 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:16:24] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:16:24] STMT OK [msg insert OUT cid=282967] affected=1 insert_id=573817
[2025-12-07 03:16:24] STMT OK [convo touch operator cid=282967] affected=1 insert_id=0
[2025-12-07 03:16:24] DONE
[2025-12-07 03:16:41] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:16:41] MO numbers raw_from=15103236780 raw_to(DID)=18624571680 norm_from=+15103236780 norm_to=+18624571680 msgId=e28a4f02-da0d-49a7-9d09-33739d140786 rec_date=2025-12-07 03:16:41
[2025-12-07 03:16:41] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:41] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:41] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:16:41] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:41] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:16:41] SQL OK [create sms_responses] affected=0
[2025-12-07 03:16:41] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:16:41] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:16:41] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:16:41] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:16:41] ensure_open_conversation -> cid=282968
[2025-12-07 03:16:41] STMT OK [convo stamp cid=282968] affected=1 insert_id=0
[2025-12-07 03:16:41] STMT OK [convo select-after-stamp cid=282968] affected=-1 insert_id=0
[2025-12-07 03:16:41] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:41] STMT OK [msg insert IN cid=282968] affected=1 insert_id=573818
[2025-12-07 03:16:41] STMT OK [convo counters cid=282968] affected=1 insert_id=0
[2025-12-07 03:16:41] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:16:41] STMT OK [smsrec insert] affected=1 insert_id=289153
[2025-12-07 03:16:41] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:16:41] SQL OK [create sms_optins] affected=0
[2025-12-07 03:16:41] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15103236780','+18624571680',NOW(),'stop')
[2025-12-07 03:16:41] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:16:41] 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:16:41] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:16:41] STMT OK [msg insert OUT cid=282968] affected=1 insert_id=573819
[2025-12-07 03:16:41] STMT OK [convo touch operator cid=282968] affected=1 insert_id=0
[2025-12-07 03:16:41] DONE
[2025-12-07 03:16:50] BEGIN method=POST ctype=application/json clen=414
[2025-12-07 03:16:50] MO numbers raw_from=12068616152 raw_to(DID)=18624571680 norm_from=+12068616152 norm_to=+18624571680 msgId=99d5a57e-c3ee-4c16-aa8f-0220d4492593 rec_date=2025-12-07 03:16:50
[2025-12-07 03:16:50] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:50] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:50] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:16:50] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:50] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:16:50] SQL OK [create sms_responses] affected=0
[2025-12-07 03:16:50] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:16:50] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:16:50] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:16:50] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:16:50] ensure_open_conversation -> cid=282969
[2025-12-07 03:16:50] STMT OK [convo stamp cid=282969] affected=1 insert_id=0
[2025-12-07 03:16:50] STMT OK [convo select-after-stamp cid=282969] affected=-1 insert_id=0
[2025-12-07 03:16:50] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:50] STMT OK [msg insert IN cid=282969] affected=1 insert_id=573820
[2025-12-07 03:16:50] STMT OK [convo counters cid=282969] affected=1 insert_id=0
[2025-12-07 03:16:50] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:16:50] STMT OK [smsrec insert] affected=1 insert_id=289154
[2025-12-07 03:16:50] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:16:50] SQL OK [create sms_optins] affected=0
[2025-12-07 03:16:50] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+12068616152','+18624571680',NOW(),'stop')
[2025-12-07 03:16:50] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:16:50] 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:16:50] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:16:50] STMT OK [msg insert OUT cid=282969] affected=1 insert_id=573821
[2025-12-07 03:16:50] STMT OK [convo touch operator cid=282969] affected=1 insert_id=0
[2025-12-07 03:16:50] DONE
[2025-12-07 03:16:51] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:16:51] MO numbers raw_from=19166611232 raw_to(DID)=18624571680 norm_from=+19166611232 norm_to=+18624571680 msgId=90a52715-ddc6-4869-8985-879edb3ee7bf rec_date=2025-12-07 03:16:51
[2025-12-07 03:16:51] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:51] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:16:51] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:16:51] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:51] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:16:51] SQL OK [create sms_responses] affected=0
[2025-12-07 03:16:51] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:16:51] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:16:51] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:16:51] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:16:51] ensure_open_conversation -> cid=282970
[2025-12-07 03:16:51] STMT OK [convo stamp cid=282970] affected=1 insert_id=0
[2025-12-07 03:16:51] STMT OK [convo select-after-stamp cid=282970] affected=-1 insert_id=0
[2025-12-07 03:16:51] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:16:51] STMT OK [msg insert IN cid=282970] affected=1 insert_id=573822
[2025-12-07 03:16:51] STMT OK [convo counters cid=282970] affected=1 insert_id=0
[2025-12-07 03:16:51] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:16:51] STMT OK [smsrec insert] affected=1 insert_id=289155
[2025-12-07 03:16:51] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:16:51] SQL OK [create sms_optins] affected=0
[2025-12-07 03:16:51] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+19166611232','+18624571680',NOW(),'stop')
[2025-12-07 03:16:51] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:16:51] 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:16:51] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:16:51] STMT OK [msg insert OUT cid=282970] affected=1 insert_id=573823
[2025-12-07 03:16:51] STMT OK [convo touch operator cid=282970] affected=1 insert_id=0
[2025-12-07 03:16:51] DONE
[2025-12-07 03:17:02] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:17:02] MO numbers raw_from=12017905980 raw_to(DID)=18624571680 norm_from=+12017905980 norm_to=+18624571680 msgId=febaef18-bdd7-4579-ad9f-0289b50a42d8 rec_date=2025-12-07 03:17:02
[2025-12-07 03:17:02] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:17:02] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:17:02] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:17:02] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:17:02] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:17:02] SQL OK [create sms_responses] affected=0
[2025-12-07 03:17:02] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:17:02] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:17:02] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:17:02] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:17:02] ensure_open_conversation -> cid=282971
[2025-12-07 03:17:02] STMT OK [convo stamp cid=282971] affected=1 insert_id=0
[2025-12-07 03:17:02] STMT OK [convo select-after-stamp cid=282971] affected=-1 insert_id=0
[2025-12-07 03:17:02] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:17:02] STMT OK [msg insert IN cid=282971] affected=1 insert_id=573824
[2025-12-07 03:17:02] STMT OK [convo counters cid=282971] affected=1 insert_id=0
[2025-12-07 03:17:02] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:17:02] STMT OK [smsrec insert] affected=1 insert_id=289156
[2025-12-07 03:17:02] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:17:02] SQL OK [create sms_optins] affected=0
[2025-12-07 03:17:02] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+12017905980','+18624571680',NOW(),'stop')
[2025-12-07 03:17:02] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:17: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:17:02] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:17:02] STMT OK [msg insert OUT cid=282971] affected=1 insert_id=573825
[2025-12-07 03:17:02] STMT OK [convo touch operator cid=282971] affected=1 insert_id=0
[2025-12-07 03:17:02] DONE
[2025-12-07 03:17:43] BEGIN method=POST ctype=application/json clen=419
[2025-12-07 03:17:43] MO numbers raw_from=13347141591 raw_to(DID)=18624571680 norm_from=+13347141591 norm_to=+18624571680 msgId=862efd24-8ec6-413a-8500-e03c37c02f2d rec_date=2025-12-07 03:17:43
[2025-12-07 03:17:43] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:17:43] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:17:43] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:17:43] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:17:43] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:17:43] SQL OK [create sms_responses] affected=0
[2025-12-07 03:17:43] STMT OK [keyword reverse-like lookup norm=stoptoend] affected=-1 insert_id=0
[2025-12-07 03:17:43] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:17:43] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:17:43] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:17:43] ensure_open_conversation -> cid=282972
[2025-12-07 03:17:43] STMT OK [convo stamp cid=282972] affected=1 insert_id=0
[2025-12-07 03:17:43] STMT OK [convo select-after-stamp cid=282972] affected=-1 insert_id=0
[2025-12-07 03:17:43] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:17:43] STMT OK [msg insert IN cid=282972] affected=1 insert_id=573826
[2025-12-07 03:17:43] STMT OK [convo counters cid=282972] affected=1 insert_id=0
[2025-12-07 03:17:43] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:17:43] STMT OK [smsrec insert] affected=1 insert_id=289157
[2025-12-07 03:17:43] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:17:43] SQL OK [create sms_optins] affected=0
[2025-12-07 03:17:43] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+13347141591','+18624571680',NOW(),'stop')
[2025-12-07 03:17:43] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:17:43] 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:17:43] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:17:43] STMT OK [msg insert OUT cid=282972] affected=1 insert_id=573827
[2025-12-07 03:17:43] STMT OK [convo touch operator cid=282972] affected=1 insert_id=0
[2025-12-07 03:17:43] DONE
[2025-12-07 03:17:52] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:17:52] MO numbers raw_from=19142617553 raw_to(DID)=18624571680 norm_from=+19142617553 norm_to=+18624571680 msgId=a7223d40-9050-41e3-8af4-69ecd1cb04c5 rec_date=2025-12-07 03:17:52
[2025-12-07 03:17:52] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:17:52] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:17:52] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:17:52] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:17:52] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:17:52] SQL OK [create sms_responses] affected=0
[2025-12-07 03:17:52] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:17:52] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:17:52] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:17:52] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:17:52] ensure_open_conversation -> cid=282973
[2025-12-07 03:17:52] STMT OK [convo stamp cid=282973] affected=1 insert_id=0
[2025-12-07 03:17:52] STMT OK [convo select-after-stamp cid=282973] affected=-1 insert_id=0
[2025-12-07 03:17:52] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:17:52] STMT OK [msg insert IN cid=282973] affected=1 insert_id=573828
[2025-12-07 03:17:52] STMT OK [convo counters cid=282973] affected=1 insert_id=0
[2025-12-07 03:17:52] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:17:52] STMT OK [smsrec insert] affected=1 insert_id=289158
[2025-12-07 03:17:52] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:17:52] SQL OK [create sms_optins] affected=0
[2025-12-07 03:17:52] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+19142617553','+18624571680',NOW(),'stop')
[2025-12-07 03:17:52] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:17:52] 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:17:52] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:17:52] STMT OK [msg insert OUT cid=282973] affected=1 insert_id=573829
[2025-12-07 03:17:52] STMT OK [convo touch operator cid=282973] affected=1 insert_id=0
[2025-12-07 03:17:52] DONE
[2025-12-07 03:18:37] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:18:37] MO numbers raw_from=16307404489 raw_to(DID)=18624571680 norm_from=+16307404489 norm_to=+18624571680 msgId=e408b3a6-8caf-4d83-a3d2-ee42238cd1f7 rec_date=2025-12-07 03:18:37
[2025-12-07 03:18:37] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:18:37] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:18:37] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:18:37] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:18:37] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:18:37] SQL OK [create sms_responses] affected=0
[2025-12-07 03:18:37] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:18:37] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:18:37] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:18:37] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:18:37] ensure_open_conversation -> cid=282974
[2025-12-07 03:18:37] STMT OK [convo stamp cid=282974] affected=1 insert_id=0
[2025-12-07 03:18:37] STMT OK [convo select-after-stamp cid=282974] affected=-1 insert_id=0
[2025-12-07 03:18:37] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:18:37] STMT OK [msg insert IN cid=282974] affected=1 insert_id=573830
[2025-12-07 03:18:37] STMT OK [convo counters cid=282974] affected=1 insert_id=0
[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