SELECT * FROM voice_compaign_summary WHERE compaign_id='59695' LIMIT 1
before elastic get data 15-Dec-2025 12:17:23 pm after elastic get data 15-Dec-2025 12:17:23 pm before elastic new get data 15-Dec-2025 12:17:23 pmloop : 0

total records 39
process records 39below is user whitelist data
Array
(
    [8712372751] => 8712372751
    [9440901789] => 9440901789
    [9063637459] => 9063637459
    [9182561711] => 9182561711
    [7032533214] => 7032533214
    [9052556090] => 9052556090
    [8500189888] => 8500189888
    [7675012012] => 7675012012
    [9573031222] => 9573031222
    [9900247059] => 9900247059
    [9030374447] => 9030374447
    [9948477399] => 9948477399
    [9490582920] => 9490582920
    [9182561722] => 9182561722
    [7013493892] => 7013493892
    [9866566565] => 9866566565
    [9412897418] => 9412897418
    [8882728116] => 8882728116
    [9627437967] => 9627437967
    [7245086935] => 7245086935
    [8009536247] => 8009536247
    [9953824957] => 9953824957
    [9027497451] => 9027497451
    [9858631427] => 9858631427
    [7505335684] => 7505335684
    [9777155191] => 9777155191
    [9937574894] => 9937574894
    [9403893376] => 9403893376
    [7618194174] => 7618194174
    [8475053356] => 8475053356
    [6397634461] => 6397634461
    [8630412545] => 8630412545
    [7830564075] => 7830564075
    [9390901020] => 9390901020
    [6260940880] => 6260940880
    [9999019749] => 9999019749
    [8448636023] => 8448636023
    [7528949593] => 7528949593
    [8882396763] => 8882396763
)


 after elastic new get data 


 after elastic get data 

15-Dec-2025 12:17:24 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 

15-Dec-2025 12:17:24 pm

 after elastic get data 

15-Dec-2025 12:17:24 pm

 before elastic get data 

15-Dec-2025 12:17:24 pm

 after elastic get data 

15-Dec-2025 12:17:24 pm

 before elastic get data 

15-Dec-2025 12:17:24 pm

 after elastic get data 

15-Dec-2025 12:17:24 pm
SELECT * FROM `contacts_temp_group_53628` where group_id in(53628) group by mobile_number order by contact_id LIMIT 0,3 MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59695` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59695','7528949593', 'p', '184', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 12:17:24 pm after INSERT DETAIL 15-Dec-2025 12:17:24 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59695` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59695','8448636023', 'p', '184', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 12:17:24 pm after INSERT DETAIL 15-Dec-2025 12:17:24 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59695` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59695','8882396763', 'p', '184', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 12:17:24 pm after INSERT DETAIL 15-Dec-2025 12:17:24 pm before UPDATE SUMMARY 15-Dec-2025 12:17:24 pm after before UPDATE SUMMARY 15-Dec-2025 12:17:24 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 blacklis in sec 0 whitelist get data sec 1 whitelist get data mic sec 1.0352280139923 blacklist in micro sec 0.0013096332550049