SELECT * FROM voice_compaign_summary WHERE compaign_id='38992' LIMIT 1
before elastic get data
16-May-2025 05:46:28 pm
after elastic get data
16-May-2025 05:46:28 pm
before elastic new get data
16-May-2025 05:46:28 pmloop : 0
total records 334
process records 334below is user whitelist data
Array
(
[9980704083] => 9980704083
[9986142246] => 9986142246
[6362046025] => 6362046025
[9663003777] => 9663003777
[7337792608] => 7337792608
[9945994555] => 9945994555
[7411109227] => 7411109227
[9448134856] => 9448134856
[7259800087] => 7259800087
[8496989549] => 8496989549
[9449105150] => 9449105150
[9535586900] => 9535586900
[9019411311] => 9019411311
[9782902155] => 9782902155
[7622927564] => 7622927564
[9071266286] => 9071266286
[8762860656] => 8762860656
[9482944477] => 9482944477
[9141238128] => 9141238128
[9480459715] => 9480459715
[9449457709] => 9449457709
[9449294688] => 9449294688
[9448347442] => 9448347442
[8762370428] => 8762370428
[8277007504] => 8277007504
[9901849632] => 9901849632
[9480520198] => 9480520198
[8861163805] => 8861163805
[9241212444] => 9241212444
[9448703454] => 9448703454
[9481720894] => 9481720894
[9964045925] => 9964045925
[9480780819] => 9480780819
[9482933237] => 9482933237
[8494903484] => 8494903484
[9449359430] => 9449359430
[9483485598] => 9483485598
[8310115415] => 8310115415
[9380767806] => 9380767806
[7353687340] => 7353687340
[9480963175] => 9480963175
[9448933937] => 9448933937
[9741187183] => 9741187183
[9448545911] => 9448545911
[9449501832] => 9449501832
[8762841226] => 8762841226
[9663730345] => 9663730345
[9113942001] => 9113942001
[9741790694] => 9741790694
[7676847273] => 7676847273
[8147977562] => 8147977562
[9739641623] => 9739641623
[9480726996] => 9480726996
[9448642348] => 9448642348
[9449293066] => 9449293066
[9481458979] => 9481458979
[8310743252] => 8310743252
[9481111736] => 9481111736
[8762099560] => 8762099560
[8152917962] => 8152917962
[8495935857] => 8495935857
[9483938735] => 9483938735
[9632341192] => 9632341192
[9483538494] => 9483538494
[9481156519] => 9481156519
[9480898208] => 9480898208
[7829014889] => 7829014889
[9632148455] => 9632148455
[9945995943] => 9945995943
[9481862396] => 9481862396
[9480274129] => 9480274129
[9448877161] => 9448877161
[9008013833] => 9008013833
[9448933687] => 9448933687
[8277349218] => 8277349218
[8431919993] => 8431919993
[9380873083] => 9380873083
[9483416378] => 9483416378
[8277227510] => 8277227510
[9481706391] => 9481706391
[9880906375] => 9880906375
[9902467696] => 9902467696
[9480327180] => 9480327180
[9482349260] => 9482349260
[9448823592] => 9448823592
[8073984327] => 8073984327
[9611960791] => 9611960791
[8660858894] => 8660858894
[7259307741] => 7259307741
[9481645570] => 9481645570
[9482998979] => 9482998979
[9483730597] => 9483730597
[8746006655] => 8746006655
[8296420759] => 8296420759
[6362378821] => 6362378821
[9481862098] => 9481862098
[9483938893] => 9483938893
[9448058892] => 9448058892
[9242913964] => 9242913964
[9108208100] => 9108208100
[9449939075] => 9449939075
[8762149932] => 8762149932
[9449359089] => 9449359089
[8748810586] => 8748810586
[9482133353] => 9482133353
[8431475300] => 8431475300
[9449928425] => 9449928425
[9448486874] => 9448486874
[9880075499] => 9880075499
[9449343147] => 9449343147
[9663598385] => 9663598385
[8197305199] => 8197305199
[9535146129] => 9535146129
[8431665953] => 8431665953
[9902798179] => 9902798179
[9480440943] => 9480440943
[9535617251] => 9535617251
[8861638875] => 8861638875
[9900485632] => 9900485632
[7892387911] => 7892387911
[9449192543] => 9449192543
[9611659730] => 9611659730
[9972052785] => 9972052785
[9731069149] => 9731069149
[9448965263] => 9448965263
[8105818187] => 8105818187
[8660106179] => 8660106179
[9742051153] => 9742051153
[6361441760] => 6361441760
[8762846828] => 8762846828
[9901851408] => 9901851408
[8197357934] => 8197357934
[8446183995] => 8446183995
[9008909974] => 9008909974
[8431907309] => 8431907309
[6366278112] => 6366278112
[8277007251] => 8277007251
[9480944731] => 9480944731
[9449188618] => 9449188618
[9448342676] => 9448342676
[9482988586] => 9482988586
[9686093339] => 9686093339
[9480700422] => 9480700422
[9481751008] => 9481751008
[9448236277] => 9448236277
[9448317630] => 9448317630
[7019127441] => 7019127441
[9916880085] => 9916880085
[9743620972] => 9743620972
[9482986463] => 9482986463
[9480759906] => 9480759906
[9845337734] => 9845337734
[7829846144] => 7829846144
[9880519703] => 9880519703
[9448915947] => 9448915947
[9449773770] => 9449773770
[9380626221] => 9380626221
[9902208660] => 9902208660
[9449629660] => 9449629660
[9482993497] => 9482993497
[9480119106] => 9480119106
[9483485740] => 9483485740
[9482125057] => 9482125057
[9900903033] => 9900903033
[7349497600] => 7349497600
[9945661086] => 9945661086
[9483781462] => 9483781462
[9019498492] => 9019498492
[9901440956] => 9901440956
[9916079455] => 9916079455
[7892889348] => 7892889348
[8762759275] => 8762759275
[9483315302] => 9483315302
[9448965032] => 9448965032
[9740748980] => 9740748980
[9448690528] => 9448690528
[9449180267] => 9449180267
[9448147350] => 9448147350
[9620798833] => 9620798833
[9739944777] => 9739944777
[8762328892] => 8762328892
[9480019137] => 9480019137
[9449200138] => 9449200138
[9448876094] => 9448876094
[8277214230] => 8277214230
[9482557562] => 9482557562
[8970921668] => 8970921668
[9480413469] => 9480413469
[8762957836] => 8762957836
[7618735717] => 7618735717
[9480526752] => 9480526752
[9448833377] => 9448833377
[9483687231] => 9483687231
[9241010393] => 9241010393
[9448964169] => 9448964169
[9901318743] => 9901318743
[9008492731] => 9008492731
[8197981335] => 8197981335
[9483857796] => 9483857796
[9480701301] => 9480701301
[8762150005] => 8762150005
[7406830054] => 7406830054
[9019826137] => 9019826137
[9035709033] => 9035709033
[9481048833] => 9481048833
[7829909087] => 7829909087
[9986910684] => 9986910684
[8762654519] => 8762654519
[9483998320] => 9483998320
[9164393115] => 9164393115
[9483280828] => 9483280828
[9880179016] => 9880179016
[8277138579] => 8277138579
[9449158421] => 9449158421
[9916886681] => 9916886681
[8970675147] => 8970675147
[9480508374] => 9480508374
[8762654479] => 8762654479
[8310049975] => 8310049975
[8197985215] => 8197985215
[9448147828] => 9448147828
[9844259203] => 9844259203
[7483937249] => 7483937249
[9480439468] => 9480439468
[9482029473] => 9482029473
[9482699319] => 9482699319
[8105141888] => 8105141888
[9448579998] => 9448579998
[7899792266] => 7899792266
[9483199353] => 9483199353
[9901995427] => 9901995427
[8970497938] => 8970497938
[9164190880] => 9164190880
[9449263923] => 9449263923
[8618139407] => 8618139407
[9980427366] => 9980427366
[7892730459] => 7892730459
[8197688253] => 8197688253
[8762846026] => 8762846026
[9483705486] => 9483705486
[8277786658] => 8277786658
[9481461483] => 9481461483
[9482987942] => 9482987942
[9481049091] => 9481049091
[9844640556] => 9844640556
[8197837074] => 8197837074
[9741048331] => 9741048331
[9110811824] => 9110811824
[8884894173] => 8884894173
[9482191467] => 9482191467
[9449172740] => 9449172740
[7760777745] => 7760777745
[8762450494] => 8762450494
[8217216040] => 8217216040
[8277087845] => 8277087845
[7760142626] => 7760142626
[9483933157] => 9483933157
[8277158436] => 8277158436
[8861941976] => 8861941976
[9480474927] => 9480474927
[6364281422] => 6364281422
[7338210627] => 7338210627
[9449994377] => 9449994377
[8277647134] => 8277647134
[8971115199] => 8971115199
[9482115365] => 9482115365
[9480089812] => 9480089812
[9740284863] => 9740284863
[9480570872] => 9480570872
[9449012121] => 9449012121
[9448736449] => 9448736449
[9482554412] => 9482554412
[7019301980] => 7019301980
[9481458930] => 9481458930
[9591003727] => 9591003727
[8277503595] => 8277503595
[9880597780] => 9880597780
[9480526799] => 9480526799
[9483648693] => 9483648693
[9480585310] => 9480585310
[9482993545] => 9482993545
[9449783114] => 9449783114
[9480508653] => 9480508653
[7676332225] => 7676332225
[8762835621] => 8762835621
[9902447964] => 9902447964
[9449994783] => 9449994783
[9480602903] => 9480602903
[9449912259] => 9449912259
[9740119288] => 9740119288
[9986658349] => 9986658349
[9448182793] => 9448182793
[9481351230] => 9481351230
[9353948727] => 9353948727
[9113657960] => 9113657960
[9480702754] => 9480702754
[9481952900] => 9481952900
[9535334547] => 9535334547
[7019710879] => 7019710879
[9481384980] => 9481384980
[9480765039] => 9480765039
[8277338540] => 8277338540
[8310179385] => 8310179385
[8762958309] => 8762958309
[9483998462] => 9483998462
[9538429661] => 9538429661
[9481157301] => 9481157301
[7875050281] => 7875050281
[8762327655] => 8762327655
[8660228791] => 8660228791
[9663912088] => 9663912088
[8762940166] => 8762940166
[9482810895] => 9482810895
[9482944437] => 9482944437
[9480588723] => 9480588723
[9448580072] => 9448580072
[9845996474] => 9845996474
[9964592674] => 9964592674
[9481955115] => 9481955115
[9916263091] => 9916263091
[6363779763] => 6363779763
[9164071510] => 9164071510
[9916634922] => 9916634922
[7975445792] => 7975445792
[8762661156] => 8762661156
[9449978705] => 9449978705
[9060842963] => 9060842963
[9591403662] => 9591403662
[8088885523] => 8088885523
[9611987343] => 9611987343
[9482471717] => 9482471717
[7676588912] => 7676588912
[9449791660] => 9449791660
[9483938577] => 9483938577
)
after elastic new get data
after elastic get data
16-May-2025 05:46:29 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"140"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 140
)
)
gateway_id_arrs
Array
(
[0] => 140
)
before elastic get data
16-May-2025 05:46:29 pm
after elastic get data
16-May-2025 05:46:29 pm
before elastic get data
16-May-2025 05:46:29 pm
after elastic get data
16-May-2025 05:46:29 pm
before elastic get data
16-May-2025 05:46:29 pm
after elastic get data
16-May-2025 05:46:29 pm
SELECT * FROM `contacts_temp_group_36206` where group_id in(36206) group by mobile_number order by contact_id LIMIT 0,2
DND FILTERING YES
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38992` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38992','9449791660', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:46:29 pm
after INSERT DETAIL
16-May-2025 05:46:29 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38992` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38992','9483938577', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:46:29 pm
after INSERT DETAIL
16-May-2025 05:46:29 pm
before UPDATE SUMMARY
16-May-2025 05:46:29 pm
after before UPDATE SUMMARY
16-May-2025 05:46:29 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 0.80068898200989
blacklist in micro sec 0.0013511180877686