SELECT * FROM voice_compaign_summary WHERE compaign_id='39741' LIMIT 1  <br>


 before elastic get data 

31-May-2025 05:03:05 pm

 after elastic get data 

31-May-2025 05:03:05 pm

 before elastic new get data 

31-May-2025 05:03:05 pmloop : 0 <br> <br> total records 40<br>  process records 40below is user whitelist data 

 <pre/>Array
(
    [8005937319] => 8005937319
    [6375671081] => 6375671081
    [8431359169] => 8431359169
    [8300765581] => 8300765581
    [8527522466] => 8527522466
    [9877295940] => 9877295940
    [9625260673] => 9625260673
    [9210819400] => 9210819400
    [8968989040] => 8968989040
    [9008653337] => 9008653337
    [8376036068] => 8376036068
    [6377440226] => 6377440226
    [9265190992] => 9265190992
    [7276701761] => 7276701761
    [7489895989] => 7489895989
    [9911667652] => 9911667652
    [9014865990] => 9014865990
    [8275108798] => 8275108798
    [6590976563] => 6590976563
    [8826096500] => 8826096500
    [9586855544] => 9586855544
    [9870294773] => 9870294773
    [9210360234] => 9210360234
    [9820298926] => 9820298926
    [8374895210] => 8374895210
    [7607277639] => 7607277639
    [9810620321] => 9810620321
    [8955273354] => 8955273354
    [9268848387] => 9268848387
    [7349731315] => 7349731315
    [7908481287] => 7908481287
    [7587957022] => 7587957022
    [9830905500] => 9830905500
    [9408752101] => 9408752101
    [7015734484] => 7015734484
    [9131846742] => 9131846742
    [9101264462] => 9101264462
    [8699321076] => 8699321076
    [9141560632] => 9141560632
    [8168563127] => 8168563127
)


 after elastic new get data 


 after elastic get data 

31-May-2025 05:03:06 pmCutting Percentage = 0

1 alloted_apis_json--[{"cli":"","g_id":"140"}]

alloted api array 

 <pre/>Array
(
    [0] => Array
        (
            [cli] => 
            [g_id] => 140
        )

)
gateway_id_arrs 

 <pre/>Array
(
    [0] => 140
)


 before elastic get data 

31-May-2025 05:03:06 pm

 after elastic get data 

31-May-2025 05:03:06 pm

 before elastic get data 

31-May-2025 05:03:06 pm

 after elastic get data 

31-May-2025 05:03:06 pm

 before elastic get data 

31-May-2025 05:03:06 pm

 after elastic get data 

31-May-2025 05:03:06 pm<br>SELECT * FROM `contacts_temp_group_36769` where group_id in(36769)  group by mobile_number order by contact_id  LIMIT 0,1  

 

 DND FILTERING YES  

 MOBILE NO IS WHITELIST YES <br>INSERT INTO `voice_compaign_detail_39741` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39741','8168563127', 'p', '140', '1', '','','','', '')


 before  INSERT DETAIL 

31-May-2025 05:03:06 pm

 after INSERT DETAIL 

31-May-2025 05:03:06 pm

 before UPDATE SUMMARY 

31-May-2025 05:03:06 pm

 after before UPDATE SUMMARY  

31-May-2025 05:03:06 pm

 contact in sec 0 

 sepration in sec 0 

 settings in sec 0 

 whitelist in sec 0 

 dnd status in sec  

 elastic dnd get data in sec 0 

 blacklis in sec 0 

 whitelist get data sec 1 

 whitelist get data mic sec 1.154522895813 

 blacklist in micro sec 0.00075292587280273