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

total records 117
process records 117below is user whitelist data
Array
(
    [8179445599] => 8179445599
    [9492238112] => 9492238112
    [8008666363] => 8008666363
    [7993727815] => 7993727815
    [8500727146] => 8500727146
    [9618744474] => 9618744474
    [9704241999] => 9704241999
    [9052432234] => 9052432234
    [9849466777] => 9849466777
    [9866474371] => 9866474371
    [9963652394] => 9963652394
    [9441305604] => 9441305604
    [7901025139] => 7901025139
    [9856669999] => 9856669999
    [9989034251] => 9989034251
    [9440836979] => 9440836979
    [9440581919] => 9440581919
    [9908967394] => 9908967394
    [6305978869] => 6305978869
    [9603454513] => 9603454513
    [9603217182] => 9603217182
    [9052684138] => 9052684138
    [9885270942] => 9885270942
    [7093208311] => 7093208311
    [9705192600] => 9705192600
    [9491331131] => 9491331131
    [7095416630] => 7095416630
    [9603336221] => 9603336221
    [9440876031] => 9440876031
    [7288904076] => 7288904076
    [6305391744] => 6305391744
    [7989824003] => 7989824003
    [9440320239] => 9440320239
    [9908833125] => 9908833125
    [9396655645] => 9396655645
    [8639612134] => 8639612134
    [9000925926] => 9000925926
    [9912377988] => 9912377988
    [9885991953] => 9885991953
    [9948083188] => 9948083188
    [8977648455] => 8977648455
    [9959035857] => 9959035857
    [9885527749] => 9885527749
    [9866135678] => 9866135678
    [9948473794] => 9948473794
    [9989355399] => 9989355399
    [9346650616] => 9346650616
    [9177777097] => 9177777097
    [9490709362] => 9490709362
    [9866866559] => 9866866559
    [7730063172] => 7730063172
    [9866252982] => 9866252982
    [9030772345] => 9030772345
    [8885213334] => 8885213334
    [8349888018] => 8349888018
    [8860233336] => 8860233336
    [9798964227] => 9798964227
    [9523334891] => 9523334891
    [7676326428] => 7676326428
    [8678049202] => 8678049202
    [7678652743] => 7678652743
    [8436622265] => 8436622265
    [9151155173] => 9151155173
    [9814080870] => 9814080870
    [7665407584] => 7665407584
    [8239147687] => 8239147687
    [9022978467] => 9022978467
    [7307184052] => 7307184052
    [7759881496] => 7759881496
    [9163732333] => 9163732333
    [9794775994] => 9794775994
    [8862894558] => 8862894558
    [7800594958] => 7800594958
    [8503972364] => 8503972364
    [9681802453] => 9681802453
    [9149202730] => 9149202730
    [8058582734] => 8058582734
    [9868425891] => 9868425891
    [8320346823] => 8320346823
    [7982185137] => 7982185137
    [8670430252] => 8670430252
    [7210471930] => 7210471930
    [7780047577] => 7780047577
    [8310842593] => 8310842593
    [6261899090] => 6261899090
    [7549860959] => 7549860959
    [9630891953] => 9630891953
    [9560307376] => 9560307376
    [9471724496] => 9471724496
    [8687802039] => 8687802039
    [7024670102] => 7024670102
    [7011392829] => 7011392829
    [8090902251] => 8090902251
    [9826381211] => 9826381211
    [9881139538] => 9881139538
    [8896083271] => 8896083271
    [9540820803] => 9540820803
    [9879318227] => 9879318227
    [7381925718] => 7381925718
    [9175163553] => 9175163553
    [9616723510] => 9616723510
    [8530833939] => 8530833939
    [8929483473] => 8929483473
    [9609427428] => 9609427428
    [7087096771] => 7087096771
    [9630890650] => 9630890650
    [7404521936] => 7404521936
    [8819918806] => 8819918806
    [7007524362] => 7007524362
    [8793341846] => 8793341846
    [7020222451] => 7020222451
    [7973762812] => 7973762812
    [8707475900] => 8707475900
    [8077323737] => 8077323737
    [9621955629] => 9621955629
    [9211037276] => 9211037276
    [7377182846] => 7377182846
)


 after elastic new get data 


 after elastic get data 

16-Dec-2025 07:17:12 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 

16-Dec-2025 07:17:12 pm

 after elastic get data 

16-Dec-2025 07:17:12 pm

 before elastic get data 

16-Dec-2025 07:17:12 pm

 after elastic get data 

16-Dec-2025 07:17:12 pm

 before elastic get data 

16-Dec-2025 07:17:12 pm

 after elastic get data 

16-Dec-2025 07:17:12 pm
SELECT * FROM `contacts_temp_group_53939` where group_id in(53939) group by mobile_number order by contact_id LIMIT 0,12 MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','7381925718', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','9175163553', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','8929483473', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','8530833939', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','9609427428', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','8793341846', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','9630890650', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','7404521936', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','8819918806', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','8707475900', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','9621955629', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_60003` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60003','7377182846', 'p', '184', '1', '','','','', '') before INSERT DETAIL 16-Dec-2025 07:17:12 pm after INSERT DETAIL 16-Dec-2025 07:17:12 pm before UPDATE SUMMARY 16-Dec-2025 07:17:12 pm after before UPDATE SUMMARY 16-Dec-2025 07:17:12 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 0 whitelist get data mic sec 0.02423095703125 blacklist in micro sec 0.0068399906158447