SELECT * FROM voice_compaign_summary WHERE compaign_id='39386' LIMIT 1
before elastic get data
24-May-2025 02:37:05 pm
after elastic get data
24-May-2025 02:37:05 pm
before elastic new get data
24-May-2025 02:37:05 pmloop : 0
total records 148
process records 148below is user whitelist data
Array
(
[9963510004] => 9963510004
[7569131333] => 7569131333
[9441487119] => 9441487119
[9701144144] => 9701144144
[9032944144] => 9032944144
[9505155155] => 9505155155
[9849914555] => 9849914555
[9849850869] => 9849850869
[9848048919] => 9848048919
[9848160748] => 9848160748
[7202106677] => 7202106677
[9391644408] => 9391644408
[9989930839] => 9989930839
[8106040555] => 8106040555
[9705710004] => 9705710004
[8499929987] => 8499929987
[9866074017] => 9866074017
[9849000567] => 9849000567
[7386670437] => 7386670437
[9640161113] => 9640161113
[9505144144] => 9505144144
[9441349543] => 9441349543
[9492140126] => 9492140126
[9866334444] => 9866334444
[9000530005] => 9000530005
[9916472640] => 9916472640
[8099241272] => 8099241272
[9652243545] => 9652243545
[8555037404] => 8555037404
[9866136954] => 9866136954
[9908888835] => 9908888835
[8074146283] => 8074146283
[9177177664] => 9177177664
[9640606062] => 9640606062
[9030000228] => 9030000228
[7416934881] => 7416934881
[8019692975] => 8019692975
[9912076725] => 9912076725
[9959677543] => 9959677543
[9573700333] => 9573700333
[9652991727] => 9652991727
[9391376623] => 9391376623
[8341200867] => 8341200867
[8341618282] => 8341618282
[9848511835] => 9848511835
[9491758758] => 9491758758
[9949772823] => 9949772823
[9949170134] => 9949170134
[9059267983] => 9059267983
[9948022223] => 9948022223
[9705715978] => 9705715978
[8919960323] => 8919960323
[9949169832] => 9949169832
[9849097206] => 9849097206
[8555862802] => 8555862802
[9959372108] => 9959372108
[9849674163] => 9849674163
[9652063162] => 9652063162
[9949695131] => 9949695131
[8143557766] => 8143557766
[9949170137] => 9949170137
[9866566679] => 9866566679
[9949193623] => 9949193623
[9550861555] => 9550861555
[9248355856] => 9248355856
[9989859501] => 9989859501
[9849667854] => 9849667854
[7396170631] => 7396170631
[9000038836] => 9000038836
[9849211249] => 9849211249
[9550386045] => 9550386045
[9177163605] => 9177163605
[9676112404] => 9676112404
[9553448888] => 9553448888
[8074513838] => 8074513838
[9246204777] => 9246204777
[9948604122] => 9948604122
[9347000038] => 9347000038
[9618884786] => 9618884786
[8978270031] => 8978270031
[9866905463] => 9866905463
[8801990985] => 8801990985
[9966001112] => 9966001112
[8096687248] => 8096687248
[9704146076] => 9704146076
[9703002284] => 9703002284
[9248866649] => 9248866649
[8341043484] => 8341043484
[7396218177] => 7396218177
[9391041416] => 9391041416
[9701111136] => 9701111136
[8074022617] => 8074022617
[9550410781] => 9550410781
[9989929992] => 9989929992
[8309965920] => 8309965920
[8341721832] => 8341721832
[9030882688] => 9030882688
[9949534682] => 9949534682
[9347374755] => 9347374755
[9030505444] => 9030505444
[8686170163] => 8686170163
[9848123753] => 9848123753
[9989859314] => 9989859314
[9701220447] => 9701220447
[8125260333] => 8125260333
[9390899023] => 9390899023
[8712318669] => 8712318669
[9849933606] => 9849933606
[9703799818] => 9703799818
[9908170831] => 9908170831
[8919193357] => 8919193357
[9949329578] => 9949329578
[9347018685] => 9347018685
[9000149902] => 9000149902
[9849241000] => 9849241000
[9441017924] => 9441017924
[9666455648] => 9666455648
[8184828172] => 8184828172
[9000670007] => 9000670007
[9347553888] => 9347553888
[9949904564] => 9949904564
[9396757556] => 9396757556
[9392440505] => 9392440505
[9949225266] => 9949225266
[9849842570] => 9849842570
[9963697375] => 9963697375
[9346425710] => 9346425710
[9704529404] => 9704529404
[9247191431] => 9247191431
[9154676991] => 9154676991
[9912915344] => 9912915344
[9949492233] => 9949492233
[9100456413] => 9100456413
[9640135611] => 9640135611
[8790183352] => 8790183352
[8309237821] => 8309237821
[9399363777] => 9399363777
[9246502379] => 9246502379
[9247225585] => 9247225585
[9849884564] => 9849884564
[9951870321] => 9951870321
[8885000042] => 8885000042
[9550876778] => 9550876778
[9550806582] => 9550806582
[9014877748] => 9014877748
[9437404000] => 9437404000
[9471460474] => 9471460474
[8210327240] => 8210327240
)
after elastic new get data
after elastic get data
24-May-2025 02:37:05 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
24-May-2025 02:37:05 pm
after elastic get data
24-May-2025 02:37:05 pm
before elastic get data
24-May-2025 02:37:05 pm
after elastic get data
24-May-2025 02:37:05 pm
before elastic get data
24-May-2025 02:37:05 pm
after elastic get data
24-May-2025 02:37:05 pm
SELECT * FROM `contacts_temp_group_36514` where group_id in(36514) group by mobile_number order by contact_id LIMIT 0,2
DND FILTERING YES
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39386` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39386','9471460474', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
24-May-2025 02:37:05 pm
after INSERT DETAIL
24-May-2025 02:37:05 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39386` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39386','8210327240', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
24-May-2025 02:37:05 pm
after INSERT DETAIL
24-May-2025 02:37:05 pm
before UPDATE SUMMARY
24-May-2025 02:37:05 pm
after before UPDATE SUMMARY
24-May-2025 02:37:05 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.083741903305054
blacklist in micro sec 0.0013070106506348