SELECT * FROM voice_compaign_summary WHERE compaign_id='38606' LIMIT 1
before elastic get data 09-May-2025 01:57:50 pm after elastic get data 09-May-2025 01:57:50 pm before elastic new get data 09-May-2025 01:57:50 pmloop : 0

total records 29
process records 29below is user whitelist data
Array
(
    [9999064740] => 9999064740
    [9582687794] => 9582687794
    [9810879316] => 9810879316
    [9711742838] => 9711742838
    [7726006428] => 7726006428
    [7340635766] => 7340635766
    [9413179594] => 9413179594
    [9414745179] => 9414745179
    [9929155596] => 9929155596
    [7014815322] => 7014815322
    [9001280297] => 9001280297
    [9001661083] => 9001661083
    [7340635733] => 7340635733
    [9929589272] => 9929589272
    [9460549240] => 9460549240
    [8619358248] => 8619358248
    [9414000487] => 9414000487
    [7737814606] => 7737814606
    [9664442722] => 9664442722
    [9509929740] => 9509929740
    [9413980584] => 9413980584
    [9460426877] => 9460426877
    [9829937596] => 9829937596
    [7014169397] => 7014169397
    [9414175716] => 9414175716
    [9829054596] => 9829054596
    [9664056433] => 9664056433
    [9982129594] => 9982129594
    [9462979594] => 9462979594
)


 after elastic new get data 


 after elastic get data 

09-May-2025 01:57:50 pmCutting Percentage = 0

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

alloted api array 

 Array
(
    [0] => Array
        (
            [cli] => 
            [g_id] => 140
        )

)
gateway_id_arrs 

 Array
(
    [0] => 140
)


 before elastic get data 

09-May-2025 01:57:50 pm

 after elastic get data 

09-May-2025 01:57:50 pm

 before elastic get data 

09-May-2025 01:57:50 pm

 after elastic get data 

09-May-2025 01:57:50 pm

 before elastic get data 

09-May-2025 01:57:50 pm

 after elastic get data 

09-May-2025 01:57:50 pm
SELECT * FROM `contacts_temp_group_35897` where group_id in(35897)  group by mobile_number order by contact_id  LIMIT 0,2  

 

 DND FILTERING YES  

 MOBILE NO IS WHITELIST YES 
INSERT INTO `voice_compaign_detail_38606` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38606','9462979594', 'p', '140', '1', '','','','', '')


 before  INSERT DETAIL 

09-May-2025 01:57:50 pm

 after INSERT DETAIL 

09-May-2025 01:57:50 pm 

 MOBILE NO IS WHITELIST YES 
INSERT INTO `voice_compaign_detail_38606` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38606','9982129594', 'p', '140', '1', '','','','', '')


 before  INSERT DETAIL 

09-May-2025 01:57:50 pm

 after INSERT DETAIL 

09-May-2025 01:57:50 pm

 before UPDATE SUMMARY 

09-May-2025 01:57:50 pm

 after before UPDATE SUMMARY  

09-May-2025 01:57:50 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 0 

 whitelist get data mic sec 0.035293102264404 

 blacklist in micro sec 0.0014979839324951