SELECT * FROM voice_compaign_summary WHERE compaign_id='59784' LIMIT 1
before elastic get data 15-Dec-2025 04:57:48 pm after elastic get data 15-Dec-2025 04:57:48 pm before elastic new get data 15-Dec-2025 04:57:48 pmloop : 0

total records 38
process records 38below is user whitelist data
Array
(
    [9447078217] => 9447078217
    [9744212252] => 9744212252
    [9880132082] => 9880132082
    [8921476750] => 8921476750
    [4842978217] => 4842978217
    [9354319466] => 9354319466
    [6388462970] => 6388462970
    [9762005604] => 9762005604
    [9960563560] => 9960563560
    [8087990643] => 8087990643
    [9579754178] => 9579754178
    [9823291660] => 9823291660
    [8956352599] => 8956352599
    [8485031885] => 8485031885
    [9822029212] => 9822029212
    [8451918894] => 8451918894
    [9850989660] => 9850989660
    [8830479242] => 8830479242
    [8956635844] => 8956635844
    [9766511699] => 9766511699
    [9604850306] => 9604850306
    [9022370263] => 9022370263
    [9765002730] => 9765002730
    [8149911886] => 8149911886
    [9921050923] => 9921050923
    [8806060277] => 8806060277
    [9420139001] => 9420139001
    [9922004131] => 9922004131
    [9975990747] => 9975990747
    [9673473950] => 9673473950
    [8805552360] => 8805552360
    [9823502404] => 9823502404
    [7276031885] => 7276031885
    [9716948300] => 9716948300
    [9711174407] => 9711174407
    [8600624432] => 8600624432
    [9762005603] => 9762005603
    [9762005602] => 9762005602
)


 after elastic new get data 


 after elastic get data 

15-Dec-2025 04:57:48 pmCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 Array
(
    [0] => 168
)


 before elastic get data 

15-Dec-2025 04:57:48 pm

 after elastic get data 

15-Dec-2025 04:57:48 pm

 before elastic get data 

15-Dec-2025 04:57:48 pm

 after elastic get data 

15-Dec-2025 04:57:49 pm

 before elastic get data 

15-Dec-2025 04:57:49 pm

 after elastic get data 

15-Dec-2025 04:57:49 pm
SELECT * FROM `contacts_temp_group_53731` where group_id in(53731)  group by mobile_number order by contact_id  LIMIT 0,3  

 

 DND FILTERING YES  

 MOBILE NO IS WHITELIST YES 
INSERT INTO `voice_compaign_detail_59784` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59784','8600624432', 'p', '168', '1', '','','','', '')


 before  INSERT DETAIL 

15-Dec-2025 04:57:49 pm

 after INSERT DETAIL 

15-Dec-2025 04:57:49 pm 

 MOBILE NO IS WHITELIST YES 
INSERT INTO `voice_compaign_detail_59784` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59784','9762005603', 'p', '168', '1', '','','','', '')


 before  INSERT DETAIL 

15-Dec-2025 04:57:49 pm

 after INSERT DETAIL 

15-Dec-2025 04:57:49 pm 

 MOBILE NO IS WHITELIST YES 
INSERT INTO `voice_compaign_detail_59784` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59784','9762005602', 'p', '168', '1', '','','','', '')


 before  INSERT DETAIL 

15-Dec-2025 04:57:49 pm

 after INSERT DETAIL 

15-Dec-2025 04:57:49 pm

 before UPDATE SUMMARY 

15-Dec-2025 04:57:49 pm

 after before UPDATE SUMMARY  

15-Dec-2025 04:57:49 pm

 contact in sec 0 

 sepration in sec 0 

 settings in sec 1 

 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.031492948532104 

 blacklist in micro sec 0.0017046928405762