SELECT * FROM voice_compaign_summary WHERE compaign_id='59712' LIMIT 1
before elastic get data 15-Dec-2025 01:16:33 pm after elastic get data 15-Dec-2025 01:16:33 pm before elastic new get data 15-Dec-2025 01:16:33 pmloop : 0

total records 71
process records 71below is user whitelist data
Array
(
    [7416562691] => 7416562691
    [9680228289] => 9680228289
    [8125896896] => 8125896896
    [9930305403] => 9930305403
    [9930305406] => 9930305406
    [9321566233] => 9321566233
    [9845254649] => 9845254649
    [9742549293] => 9742549293
    [8296820073] => 8296820073
    [7022662979] => 7022662979
    [9619259577] => 9619259577
    [6360929923] => 6360929923
    [9982990016] => 9982990016
    [9704159595] => 9704159595
    [9030099496] => 9030099496
    [9848759292] => 9848759292
    [9849969188] => 9849969188
    [7702761224] => 7702761224
    [9866430857] => 9866430857
    [9515701589] => 9515701589
    [8897399064] => 8897399064
    [9618667308] => 9618667308
    [9390391525] => 9390391525
    [8007005426] => 8007005426
    [9130336650] => 9130336650
    [9822252579] => 9822252579
    [9825671075] => 9825671075
    [9879184800] => 9879184800
    [9998820110] => 9998820110
    [9825150039] => 9825150039
    [9825018829] => 9825018829
    [9898059237] => 9898059237
    [9979781983] => 9979781983
    [9376310094] => 9376310094
    [9099259315] => 9099259315
    [9825749139] => 9825749139
    [9824322361] => 9824322361
    [8905590002] => 8905590002
    [9825456129] => 9825456129
    [9825316291] => 9825316291
    [9879550540] => 9879550540
    [9227170335] => 9227170335
    [9825326826] => 9825326826
    [9426514247] => 9426514247
    [9099097139] => 9099097139
    [9426506434] => 9426506434
    [9898011889] => 9898011889
    [9825471056] => 9825471056
    [9825152475] => 9825152475
    [9427073593] => 9427073593
    [9428919519] => 9428919519
    [9687173888] => 9687173888
    [9925040341] => 9925040341
    [9426176975] => 9426176975
    [9714396999] => 9714396999
    [9328442567] => 9328442567
    [7778935338] => 7778935338
    [9512575707] => 9512575707
    [9428676364] => 9428676364
    [8866294725] => 8866294725
    [9106078464] => 9106078464
    [9099820110] => 9099820110
    [9987690790] => 9987690790
    [9829045415] => 9829045415
    [8777618003] => 8777618003
    [8240478857] => 8240478857
    [9987666981] => 9987666981
    [9903622941] => 9903622941
    [9930399951] => 9930399951
    [9619259505] => 9619259505
    [7400397459] => 7400397459
)


 after elastic new get data 


 after elastic get data 

15-Dec-2025 01:16:33 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 01:16:33 pm

 after elastic get data 

15-Dec-2025 01:16:33 pm

 before elastic get data 

15-Dec-2025 01:16:33 pm

 after elastic get data 

15-Dec-2025 01:16:33 pm

 before elastic get data 

15-Dec-2025 01:16:33 pm

 after elastic get data 

15-Dec-2025 01:16:33 pm
SELECT * FROM `contacts_temp_group_53653` where group_id in(53653) group by mobile_number order by contact_id LIMIT 0,3 DND FILTERING YES MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59712` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59712','7400397459', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 01:16:33 pm after INSERT DETAIL 15-Dec-2025 01:16:33 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59712` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59712','9930399951', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 01:16:33 pm after INSERT DETAIL 15-Dec-2025 01:16:33 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59712` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59712','9619259505', 'p', '185', '1', '','','','', '') before INSERT DETAIL 15-Dec-2025 01:16:33 pm after INSERT DETAIL 15-Dec-2025 01:16:33 pm before UPDATE SUMMARY 15-Dec-2025 01:16:33 pm after before UPDATE SUMMARY 15-Dec-2025 01:16:33 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.0350501537323 blacklist in micro sec 0.0020790100097656