SELECT * FROM voice_compaign_summary WHERE compaign_id='39379' LIMIT 1
before elastic get data 24-May-2025 12:40:11 pm after elastic get data 24-May-2025 12:40:11 pm before elastic new get data 24-May-2025 12:40:11 pmloop : 0

total records 10
process records 10below is user whitelist data
Array
(
    [9590899989] => 9590899989
    [8017757701] => 8017757701
    [8777355023] => 8777355023
    [6290932090] => 6290932090
    [9064013133] => 9064013133
    [9136402721] => 9136402721
    [8697188644] => 8697188644
    [8240124303] => 8240124303
    [8617281912] => 8617281912
    [8777638327] => 8777638327
)


 after elastic new get data 


 after elastic get data 

24-May-2025 12:40:11 pmCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 184
)


 before elastic get data 

24-May-2025 12:40:11 pm

 after elastic get data 

24-May-2025 12:40:11 pm

 before elastic get data 

24-May-2025 12:40:11 pm

 after elastic get data 

24-May-2025 12:40:11 pm

 before elastic get data 

24-May-2025 12:40:11 pm

 after elastic get data 

24-May-2025 12:40:11 pm
SELECT * FROM `contacts_temp_group_36505` where group_id in(36505) group by mobile_number order by contact_id LIMIT 0,1 DND FILTERING YES mobile no is dnd8777638327 MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39379` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39379','8777638327', 'p', '-3', '1', '','','','', '') before INSERT DETAIL 24-May-2025 12:40:11 pm after INSERT DETAIL 24-May-2025 12:40:11 pm before UPDATE SUMMARY 24-May-2025 12:40:11 pm after before UPDATE SUMMARY 24-May-2025 12:40:11 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.038105010986328 blacklist in micro sec 0.0028009414672852