SELECT * FROM voice_compaign_summary WHERE compaign_id='40103' LIMIT 1
before elastic get data
07-Jun-2025 05:48:05 pm
after elastic get data
07-Jun-2025 05:48:05 pm
before elastic new get data
07-Jun-2025 05:48:05 pmloop : 0
total records 545
process records 545below 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
[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
[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
[9535045274] => 9535045274
[9449501832] => 9449501832
[9663020746] => 9663020746
[9008420024] => 9008420024
[8762152148] => 8762152148
[9480461045] => 9480461045
[8197898728] => 8197898728
[9449111115] => 9449111115
[8971097333] => 8971097333
[9481862284] => 9481862284
[9482988938] => 9482988938
[9483905296] => 9483905296
[9743254702] => 9743254702
[8762654750] => 8762654750
[9902468046] => 9902468046
[9481459126] => 9481459126
[9900982079] => 9900982079
[8277521359] => 8277521359
[9481811936] => 9481811936
[9483555561] => 9483555561
[9481463996] => 9481463996
[7353255411] => 7353255411
[7090604676] => 7090604676
[7760777067] => 7760777067
[9075783597] => 9075783597
[9019086395] => 9019086395
[9448995607] => 9448995607
[9481458997] => 9481458997
[9964283661] => 9964283661
[9481323472] => 9481323472
[9741790995] => 9741790995
[9481560889] => 9481560889
[9845115312] => 9845115312
[8762151949] => 8762151949
[9448034796] => 9448034796
[7259187953] => 7259187953
[9164874291] => 9164874291
[9448843176] => 9448843176
[9482314005] => 9482314005
[8762099304] => 8762099304
[9538408949] => 9538408949
[9620863295] => 9620863295
[9448167038] => 9448167038
[9242161192] => 9242161192
[9448872378] => 9448872378
[8762846570] => 8762846570
[8277750691] => 8277750691
[8197864953] => 8197864953
[8762327586] => 8762327586
[9620585166] => 9620585166
[9482416593] => 9482416593
[9448920091] => 9448920091
[9110299353] => 9110299353
[9480897098] => 9480897098
[9448923488] => 9448923488
[9743513597] => 9743513597
[9449613442] => 9449613442
[9535359250] => 9535359250
[9353949591] => 9353949591
[9731292836] => 9731292836
[8861488196] => 8861488196
[9591977758] => 9591977758
[9740737939] => 9740737939
[9482626311] => 9482626311
[9620020024] => 9620020024
[9731688123] => 9731688123
[9742189535] => 9742189535
[9449293957] => 9449293957
[8310567562] => 8310567562
[9482471239] => 9482471239
[8277266493] => 8277266493
[9449108814] => 9449108814
[9448825789] => 9448825789
[8722091654] => 8722091654
[9535896532] => 9535896532
[9480737883] => 9480737883
[9845407035] => 9845407035
[9481105241] => 9481105241
[9448918459] => 9448918459
[9482472097] => 9482472097
[9341556256] => 9341556256
[9482720258] => 9482720258
[9480341153] => 9480341153
[7090428870] => 7090428870
[9483722491] => 9483722491
[8277647739] => 8277647739
[9481408235] => 9481408235
[9482298711] => 9482298711
[9741110347] => 9741110347
[9480038270] => 9480038270
[9880342630] => 9880342630
[9481537634] => 9481537634
[8147850830] => 8147850830
[9483482725] => 9483482725
[8722775477] => 8722775477
[9902710854] => 9902710854
[8762981107] => 8762981107
[8431965805] => 8431965805
[8762327805] => 8762327805
[9480737284] => 9480737284
[9481186408] => 9481186408
[9620050597] => 9620050597
[9449194142] => 9449194142
[9380591509] => 9380591509
[8310854503] => 8310854503
[9481408289] => 9481408289
[8296286453] => 8296286453
[8073157342] => 8073157342
[8762110542] => 8762110542
[8296417539] => 8296417539
[7899502836] => 7899502836
[7760624528] => 7760624528
[7019037500] => 7019037500
[9448947434] => 9448947434
[9482921103] => 9482921103
[9449292903] => 9449292903
[9480393906] => 9480393906
[8762701327] => 8762701327
[8317366311] => 8317366311
[9480505400] => 9480505400
[9482426925] => 9482426925
[9844587005] => 9844587005
[9008700267] => 9008700267
[9663463318] => 9663463318
[9741701296] => 9741701296
[8277008008] => 8277008008
[9242317761] => 9242317761
[8762762545] => 8762762545
[7019066760] => 7019066760
[6360982104] => 6360982104
[9481373405] => 9481373405
[9019220136] => 9019220136
[6360428429] => 6360428429
[9449649018] => 9449649018
[9482105805] => 9482105805
[9880603683] => 9880603683
[8553117270] => 8553117270
[8892417424] => 8892417424
[9880008181] => 9880008181
[9591018369] => 9591018369
[8277007660] => 8277007660
[8277626569] => 8277626569
[9880906397] => 9880906397
[8277384423] => 8277384423
[9482932259] => 9482932259
[8277536305] => 8277536305
[9483283838] => 9483283838
[9886325271] => 9886325271
[9986707166] => 9986707166
[9481959547] => 9481959547
[8296721248] => 8296721248
[9945551074] => 9945551074
[7760780095] => 7760780095
[9845566976] => 9845566976
[7090818848] => 7090818848
[9663505135] => 9663505135
[9420597486] => 9420597486
[9945994599] => 9945994599
[9663023226] => 9663023226
[9611692660] => 9611692660
[8431115526] => 8431115526
[8123716266] => 8123716266
[9611773309] => 9611773309
[9483485449] => 9483485449
[9743453149] => 9743453149
[8884699004] => 8884699004
[8007150120] => 8007150120
[9980843830] => 9980843830
[7259755481] => 7259755481
[9075179439] => 9075179439
[8296300903] => 8296300903
[7483455980] => 7483455980
[8618973369] => 8618973369
[9945677526] => 9945677526
[7259118514] => 7259118514
[9880418212] => 9880418212
[9740271877] => 9740271877
[9741279221] => 9741279221
[9845338926] => 9845338926
[8970461015] => 8970461015
[8710026200] => 8710026200
[9743136432] => 9743136432
[9845409336] => 9845409336
[8197685642] => 8197685642
[7676832606] => 7676832606
[9945854168] => 9945854168
[9483806179] => 9483806179
[8105794894] => 8105794894
[7975422678] => 7975422678
[9480940092] => 9480940092
[8495864764] => 8495864764
[9742872363] => 9742872363
[9482020105] => 9482020105
[8105711379] => 8105711379
[9980667158] => 9980667158
[9482759478] => 9482759478
[9886070132] => 9886070132
[9481861617] => 9481861617
[9449749805] => 9449749805
[9845805897] => 9845805897
[9740116174] => 9740116174
[8971124419] => 8971124419
[9611094746] => 9611094746
[9481117204] => 9481117204
[9731404318] => 9731404318
[7259812774] => 7259812774
[9480143499] => 9480143499
[8660228791] => 8660228791
[9480210879] => 9480210879
[9448153351] => 9448153351
[8762939594] => 8762939594
[9481200275] => 9481200275
[9481630089] => 9481630089
)
after elastic new get data
after elastic get data
07-Jun-2025 05:48:06 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
07-Jun-2025 05:48:06 pm
after elastic get data
07-Jun-2025 05:48:06 pm
before elastic get data
07-Jun-2025 05:48:06 pm
after elastic get data
07-Jun-2025 05:48:06 pm
before elastic get data
07-Jun-2025 05:48:06 pm
after elastic get data
07-Jun-2025 05:48:06 pm
SELECT * FROM `contacts_temp_group_37031` where group_id in(37031) group by mobile_number order by contact_id LIMIT 0,3
DND FILTERING YES
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_40103` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('40103','8762939594', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
07-Jun-2025 05:48:06 pm
after INSERT DETAIL
07-Jun-2025 05:48:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_40103` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('40103','9481200275', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
07-Jun-2025 05:48:06 pm
after INSERT DETAIL
07-Jun-2025 05:48:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_40103` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('40103','9481630089', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
07-Jun-2025 05:48:06 pm
after INSERT DETAIL
07-Jun-2025 05:48:06 pm
before UPDATE SUMMARY
07-Jun-2025 05:48:06 pm
after before UPDATE SUMMARY
07-Jun-2025 05:48:06 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.89397382736206
blacklist in micro sec 0.002126932144165