SELECT * FROM voice_compaign_summary WHERE compaign_id='40108' LIMIT 1
before elastic get data
07-Jun-2025 06:26:25 pm
after elastic get data
07-Jun-2025 06:26:25 pm
before elastic new get data
07-Jun-2025 06:26:25 pmloop : 0
total records 355
process records 355below is user whitelist data
Array
(
[9640161113] => 9640161113
[9440220101] => 9440220101
[9550997309] => 9550997309
[9849229339] => 9849229339
[9849125464] => 9849125464
[9440360554] => 9440360554
[9440249330] => 9440249330
[9440258574] => 9440258574
[9533433040] => 9533433040
[8125441646] => 8125441646
[9441535278] => 9441535278
[7893450923] => 7893450923
[9705311228] => 9705311228
[9848148078] => 9848148078
[9505340531] => 9505340531
[9989126575] => 9989126575
[9247245628] => 9247245628
[9299992737] => 9299992737
[9848157199] => 9848157199
[6300003973] => 6300003973
[9849120231] => 9849120231
[7569131333] => 7569131333
[9849868108] => 9849868108
[9440344108] => 9440344108
[9297105289] => 9297105289
[7382260952] => 7382260952
[9985086906] => 9985086906
[8712373013] => 8712373013
[9290547888] => 9290547888
[8179749777] => 8179749777
[8919933885] => 8919933885
[9440613148] => 9440613148
[9182043499] => 9182043499
[9948135982] => 9948135982
[9441504144] => 9441504144
[8341969697] => 8341969697
[7013853145] => 7013853145
[9885011206] => 9885011206
[9849717370] => 9849717370
[9290222855] => 9290222855
[9553755355] => 9553755355
[9440884326] => 9440884326
[8977562883] => 8977562883
[9701692413] => 9701692413
[9440308597] => 9440308597
[9848072074] => 9848072074
[9493446322] => 9493446322
[9849853218] => 9849853218
[9948863238] => 9948863238
[9849609709] => 9849609709
[9398520626] => 9398520626
[9247336444] => 9247336444
[9642222532] => 9642222532
[8328261019] => 8328261019
[7013273545] => 7013273545
[9291805609] => 9291805609
[9989527551] => 9989527551
[9247475093] => 9247475093
[9848150790] => 9848150790
[9581955940] => 9581955940
[9848792978] => 9848792978
[9299459067] => 9299459067
[7416833666] => 7416833666
[7989847767] => 7989847767
[9640111555] => 9640111555
[9849444638] => 9849444638
[9494965696] => 9494965696
[9492268676] => 9492268676
[9247869306] => 9247869306
[8801776096] => 8801776096
[7036187819] => 7036187819
[9701327395] => 9701327395
[9440949757] => 9440949757
[8374568685] => 8374568685
[9177469628] => 9177469628
[7382589199] => 7382589199
[9491338009] => 9491338009
[8885514369] => 8885514369
[9573299433] => 9573299433
[8639495845] => 8639495845
[9247471734] => 9247471734
[9948719787] => 9948719787
[7013273876] => 7013273876
[8555005800] => 8555005800
[9441752755] => 9441752755
[7842338856] => 7842338856
[8019497369] => 8019497369
[9849068570] => 9849068570
[8185088377] => 8185088377
[9985247020] => 9985247020
[7382197330] => 7382197330
[9948617847] => 9948617847
[9494604232] => 9494604232
[9491968756] => 9491968756
[9949999779] => 9949999779
[6300388841] => 6300388841
[9989332635] => 9989332635
[8186051155] => 8186051155
[9703979709] => 9703979709
[9290722482] => 9290722482
[9885906238] => 9885906238
[7989459667] => 7989459667
[7731890147] => 7731890147
[9440260768] => 9440260768
[9848754857] => 9848754857
[9866943119] => 9866943119
[9849696636] => 9849696636
[9866466188] => 9866466188
[9247891657] => 9247891657
[9441080944] => 9441080944
[9290129743] => 9290129743
[9030510352] => 9030510352
[9381683126] => 9381683126
[8978452974] => 8978452974
[9848232330] => 9848232330
[9032175555] => 9032175555
[9553176666] => 9553176666
[9985858059] => 9985858059
[9705363333] => 9705363333
[9885106777] => 9885106777
[8008475891] => 8008475891
[9963824138] => 9963824138
[9290084697] => 9290084697
[9291402500] => 9291402500
[9440667024] => 9440667024
[9885540139] => 9885540139
[9346709990] => 9346709990
[9849984663] => 9849984663
[9849536339] => 9849536339
[9346661221] => 9346661221
[9848157590] => 9848157590
[9440307905] => 9440307905
[9391110646] => 9391110646
[9949449884] => 9949449884
[9347724999] => 9347724999
[9849124374] => 9849124374
[9948227550] => 9948227550
[9948295633] => 9948295633
[9849539522] => 9849539522
[8185014703] => 8185014703
[7207137239] => 7207137239
[9246459299] => 9246459299
[9381160967] => 9381160967
[9440264858] => 9440264858
[9985067033] => 9985067033
[9440794389] => 9440794389
[8331892889] => 8331892889
[7989759667] => 7989759667
[9440262209] => 9440262209
[9849607557] => 9849607557
[9246440437] => 9246440437
[9666611227] => 9666611227
[9849051758] => 9849051758
[8919892440] => 8919892440
[9848136881] => 9848136881
[7013440048] => 7013440048
[8125831130] => 8125831130
[9246440128] => 9246440128
[9949313422] => 9949313422
[9440771066] => 9440771066
[9030951637] => 9030951637
[9490398773] => 9490398773
[9000507701] => 9000507701
[9347303565] => 9347303565
[9177977115] => 9177977115
[9010186899] => 9010186899
[9290651643] => 9290651643
[8919922975] => 8919922975
[9010299677] => 9010299677
[8977148306] => 8977148306
[9347623932] => 9347623932
[9000395780] => 9000395780
[7799977388] => 7799977388
[9885215969] => 9885215969
[9848250535] => 9848250535
[9160383484] => 9160383484
[8317622748] => 8317622748
[9030233025] => 9030233025
[9491501843] => 9491501843
[9704884960] => 9704884960
[9848123574] => 9848123574
[9849409141] => 9849409141
[9963166180] => 9963166180
[9000787260] => 9000787260
[9848135491] => 9848135491
[7981242888] => 7981242888
[9866232407] => 9866232407
[9849346569] => 9849346569
[7050399999] => 7050399999
[9493738942] => 9493738942
[9849586601] => 9849586601
[9440015175] => 9440015175
[9440838320] => 9440838320
[9848365999] => 9848365999
[9848112216] => 9848112216
[9032555599] => 9032555599
[8500440517] => 8500440517
[9246616161] => 9246616161
[9246411679] => 9246411679
[9949313449] => 9949313449
[9885626859] => 9885626859
[9290736557] => 9290736557
[8008990331] => 8008990331
[9700830091] => 9700830091
[9948017613] => 9948017613
[9848366755] => 9848366755
[9440260573] => 9440260573
[9490724162] => 9490724162
[9346621303] => 9346621303
[9059943799] => 9059943799
[9849348292] => 9849348292
[9396888585] => 9396888585
[9966990700] => 9966990700
[9989051324] => 9989051324
[9160852562] => 9160852562
[9032569994] => 9032569994
[9949156441] => 9949156441
[8074573763] => 8074573763
[9398983475] => 9398983475
[8125699002] => 8125699002
[9032081046] => 9032081046
[9393923456] => 9393923456
[7337045361] => 7337045361
[9440990002] => 9440990002
[7780105212] => 7780105212
[9441452888] => 9441452888
[9652069901] => 9652069901
[9246780030] => 9246780030
[9963184629] => 9963184629
[9700847112] => 9700847112
[9059988777] => 9059988777
[9642161198] => 9642161198
[9704771370] => 9704771370
[9032606553] => 9032606553
[6363923024] => 6363923024
[9885114987] => 9885114987
[9885309545] => 9885309545
[8977756877] => 8977756877
[9032083117] => 9032083117
[9505094333] => 9505094333
[9515656846] => 9515656846
[9849444875] => 9849444875
[9133311479] => 9133311479
[9885062116] => 9885062116
[9848599279] => 9848599279
[9848179343] => 9848179343
[9346460085] => 9346460085
[9391919019] => 9391919019
[9246467688] => 9246467688
[9948423671] => 9948423671
[9398101493] => 9398101493
[9248496011] => 9248496011
[9848136636] => 9848136636
[8125148846] => 8125148846
[8885551439] => 8885551439
[9848212756] => 9848212756
[9985453323] => 9985453323
[9701823124] => 9701823124
[8074258631] => 8074258631
[8919397155] => 8919397155
[9441040969] => 9441040969
[8374079299] => 8374079299
[9848985577] => 9848985577
[8500454004] => 8500454004
[9642223737] => 9642223737
[9666854586] => 9666854586
[9985835052] => 9985835052
[9492470189] => 9492470189
[9949313442] => 9949313442
[9885522651] => 9885522651
[9959447902] => 9959447902
[9885540136] => 9885540136
[9949434550] => 9949434550
[7981602387] => 7981602387
[7842489020] => 7842489020
[8977252719] => 8977252719
[7702552575] => 7702552575
[9652127108] => 9652127108
[8247746281] => 8247746281
[9441127883] => 9441127883
[9247583412] => 9247583412
[8712207275] => 8712207275
[9247915265] => 9247915265
[6302124842] => 6302124842
[9885935230] => 9885935230
[9440061158] => 9440061158
[9885941486] => 9885941486
[8885171953] => 8885171953
[9493070730] => 9493070730
[7989941299] => 7989941299
[9949376666] => 9949376666
[8886083802] => 8886083802
[8143643456] => 8143643456
[7780424061] => 7780424061
[9848366022] => 9848366022
[9052011422] => 9052011422
[9959945991] => 9959945991
[9959137227] => 9959137227
[9989527527] => 9989527527
[9494229902] => 9494229902
[9966977460] => 9966977460
[7780384591] => 7780384591
[9293655555] => 9293655555
[9700023330] => 9700023330
[7032032621] => 7032032621
[9704897700] => 9704897700
[6302839929] => 6302839929
[9494948989] => 9494948989
[9247184328] => 9247184328
[9247449622] => 9247449622
[9848161562] => 9848161562
[9849350332] => 9849350332
[9704668919] => 9704668919
[9491848734] => 9491848734
[9701248198] => 9701248198
[9848694094] => 9848694094
[9885666120] => 9885666120
[9704414084] => 9704414084
[8497918864] => 8497918864
[8099142363] => 8099142363
[9963177523] => 9963177523
[9299453124] => 9299453124
[8978965280] => 8978965280
[9849569446] => 9849569446
[6305899636] => 6305899636
[9704628852] => 9704628852
[8374750907] => 8374750907
[9494152728] => 9494152728
[9030987760] => 9030987760
[9959134415] => 9959134415
[8978389945] => 8978389945
[8121479491] => 8121479491
[9290736526] => 9290736526
[9966627173] => 9966627173
[9490574194] => 9490574194
[9052098343] => 9052098343
[7989782465] => 7989782465
[8309733982] => 8309733982
[9848219198] => 9848219198
[8074431515] => 8074431515
[9010037808] => 9010037808
[9848130011] => 9848130011
[9346483669] => 9346483669
[9440530575] => 9440530575
[9848304433] => 9848304433
[7799861416] => 7799861416
[8008399373] => 8008399373
[7702260778] => 7702260778
[9848569646] => 9848569646
[9291534456] => 9291534456
[8639612895] => 8639612895
[8309077155] => 8309077155
[9440547555] => 9440547555
[9440430978] => 9440430978
[9004487181] => 9004487181
)
after elastic new get data
after elastic get data
07-Jun-2025 06:26:26 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
07-Jun-2025 06:26:26 pm
after elastic get data
07-Jun-2025 06:26:26 pm
before elastic get data
07-Jun-2025 06:26:26 pm
after elastic get data
07-Jun-2025 06:26:26 pm
before elastic get data
07-Jun-2025 06:26:26 pm
after elastic get data
07-Jun-2025 06:26:26 pm
SELECT * FROM `contacts_temp_group_37036` where group_id in(37036) group by mobile_number order by contact_id LIMIT 0,1
DND FILTERING YES
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_40108` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('40108','9004487181', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
07-Jun-2025 06:26:26 pm
after INSERT DETAIL
07-Jun-2025 06:26:26 pm
before UPDATE SUMMARY
07-Jun-2025 06:26:26 pm
after before UPDATE SUMMARY
07-Jun-2025 06:26:26 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 1
whitelist get data mic sec 1.0527288913727
blacklist in micro sec 0.00070500373840332