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

total records 85
process records 85below is user whitelist data
Array
(
    [7411754224] => 7411754224
    [8320117359] => 8320117359
    [9382543187] => 9382543187
    [9474730087] => 9474730087
    [8609190301] => 8609190301
    [8819063384] => 8819063384
    [9352904755] => 9352904755
    [7584920787] => 7584920787
    [9778084676] => 9778084676
    [6202410600] => 6202410600
    [9040936978] => 9040936978
    [8516953681] => 8516953681
    [6396031728] => 6396031728
    [9333106495] => 9333106495
    [7465003009] => 7465003009
    [9034747447] => 9034747447
    [8899734204] => 8899734204
    [8269689656] => 8269689656
    [7696317224] => 7696317224
    [9811011221] => 9811011221
    [9991959623] => 9991959623
    [9709020307] => 9709020307
    [9178616144] => 9178616144
    [8882004711] => 8882004711
    [8668469859] => 8668469859
    [9120209991] => 9120209991
    [9558067514] => 9558067514
    [9016221607] => 9016221607
    [7549521765] => 7549521765
    [9289281071] => 9289281071
    [8600167164] => 8600167164
    [7991143255] => 7991143255
    [9739610618] => 9739610618
    [9642713302] => 9642713302
    [8957940488] => 8957940488
    [9170825651] => 9170825651
    [9582498467] => 9582498467
    [7828327811] => 7828327811
    [7817854931] => 7817854931
    [6306886468] => 6306886468
    [7337582218] => 7337582218
    [9310657931] => 9310657931
    [9832567567] => 9832567567
    [8896619361] => 8896619361
    [9921441952] => 9921441952
    [9875819239] => 9875819239
    [8507319145] => 8507319145
    [6351439913] => 6351439913
    [7635812571] => 7635812571
    [8208402943] => 8208402943
    [9580812190] => 9580812190
    [8210762630] => 8210762630
    [9387583055] => 9387583055
    [9661215449] => 9661215449
    [8744952618] => 8744952618
    [7483995950] => 7483995950
    [9682311044] => 9682311044
    [8795208741] => 8795208741
    [7457869334] => 7457869334
    [9060593713] => 9060593713
    [7068664755] => 7068664755
    [9136402721] => 9136402721
    [8815967245] => 8815967245
    [7086643394] => 7086643394
    [8657716734] => 8657716734
    [9386935127] => 9386935127
    [8878136825] => 8878136825
    [9485028902] => 9485028902
    [9863264380] => 9863264380
    [7709018827] => 7709018827
    [9334596268] => 9334596268
    [8218296078] => 8218296078
    [9686068311] => 9686068311
    [8750755175] => 8750755175
    [8252971006] => 8252971006
    [6900380462] => 6900380462
    [9508826276] => 9508826276
    [8602631145] => 8602631145
    [9779144724] => 9779144724
    [8521608832] => 8521608832
    [9216941906] => 9216941906
    [9289313580] => 9289313580
    [8000705592] => 8000705592
    [8691994112] => 8691994112
    [7973553107] => 7973553107
)


 after elastic new get data 


 after elastic get data 

15-Dec-2025 04:15:11 pmCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 185
)


 before elastic get data 

15-Dec-2025 04:15:12 pm

 after elastic get data 

15-Dec-2025 04:15:12 pm

 before elastic get data 

15-Dec-2025 04:15:12 pm

 after elastic get data 

15-Dec-2025 04:15:12 pm

 before elastic get data 

15-Dec-2025 04:15:12 pm

 after elastic get data 

15-Dec-2025 04:15:12 pm
SELECT * FROM `contacts_temp_group_53706` where group_id in(53706) group by mobile_number order by contact_id LIMIT 0,13 DND FILTERING YES mobile no is dnd8000705592 mobile no is dnd8521608832 mobile no is dnd8750755175 MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','8218296078', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','9686068311', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','8750755175', 'p', '-3', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','8252971006', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','6900380462', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','9508826276', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','8602631145', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','9779144724', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','8521608832', 'p', '-3', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','9216941906', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','9289313580', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','8000705592', 'p', '-3', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59759` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59759','8691994112', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 04:15:12 pm after INSERT DETAIL 15-Dec-2025 04:15:12 pm before UPDATE SUMMARY 15-Dec-2025 04:15:12 pm after before UPDATE SUMMARY 15-Dec-2025 04:15: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 0 blacklis in sec 0 whitelist get data sec 0 whitelist get data mic sec 0.12271094322205 blacklist in micro sec 0.0072216987609863