SELECT * FROM voice_compaign_summary WHERE compaign_id='59871' LIMIT 1
before elastic get data
16-Dec-2025 11:35:45 am
after elastic get data
16-Dec-2025 11:35:45 am
before elastic new get data
16-Dec-2025 11:35:45 amloop : 0
total records 98
process records 98below 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
[6360929923] => 6360929923
[9619259577] => 9619259577
[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
[9428676364] => 9428676364
[8866294725] => 8866294725
[9106078464] => 9106078464
[9099820110] => 9099820110
[9987690790] => 9987690790
[9930399951] => 9930399951
[9619259505] => 9619259505
[7400397459] => 7400397459
[8401780510] => 8401780510
[7062500466] => 7062500466
[9426226769] => 9426226769
[9404400388] => 9404400388
[9405033333] => 9405033333
[9763855000] => 9763855000
[9112168079] => 9112168079
[9322102325] => 9322102325
[9881081068] => 9881081068
[9421479268] => 9421479268
[8087929129] => 8087929129
[8421940222] => 8421940222
[9112695001] => 9112695001
[9763855645] => 9763855645
[9822867777] => 9822867777
[9150556555] => 9150556555
[9921454544] => 9921454544
[9075552323] => 9075552323
[8975785727] => 8975785727
[9423390038] => 9423390038
[9423741020] => 9423741020
[9421557557] => 9421557557
[8830369099] => 8830369099
[9822282088] => 9822282088
[9511234060] => 9511234060
[7304393649] => 7304393649
[9595853266] => 9595853266
[8777618003] => 8777618003
[9829045415] => 9829045415
[9987666981] => 9987666981
[8240478857] => 8240478857
[9903622941] => 9903622941
[9328442567] => 9328442567
[7778935338] => 7778935338
[9512575707] => 9512575707
)
after elastic new get data
after elastic get data
16-Dec-2025 11:35:47 amCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"168"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 168
)
)
gateway_id_arrs
Array
(
[0] => 168
)
before elastic get data
16-Dec-2025 11:35:47 am
after elastic get data
16-Dec-2025 11:35:47 am
before elastic get data
16-Dec-2025 11:35:47 am
after elastic get data
16-Dec-2025 11:35:47 am
before elastic get data
16-Dec-2025 11:35:47 am
after elastic get data
16-Dec-2025 11:35:47 am
SELECT * FROM `contacts_temp_group_53812` where group_id in(53812) group by mobile_number order by contact_id LIMIT 0,3
DND FILTERING YES
mobile no is dnd9512575707
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59871` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59871','7778935338', 'p', '168', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 11:35:47 am
after INSERT DETAIL
16-Dec-2025 11:35:47 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59871` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59871','9328442567', 'p', '168', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 11:35:47 am
after INSERT DETAIL
16-Dec-2025 11:35:47 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59871` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59871','9512575707', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 11:35:47 am
after INSERT DETAIL
16-Dec-2025 11:35:47 am
before UPDATE SUMMARY
16-Dec-2025 11:35:47 am
after before UPDATE SUMMARY
16-Dec-2025 11:35:47 am
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 2
whitelist get data mic sec 1.4897420406342
blacklist in micro sec 0.0019052028656006