SELECT * FROM voice_compaign_summary WHERE compaign_id='39515' LIMIT 1
before elastic get data
26-May-2025 05:21:02 pm
after elastic get data
26-May-2025 05:21:02 pm
before elastic new get data
26-May-2025 05:21:02 pmloop : 0
total records 412
process records 412below 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
[9880906375] => 9880906375
[9483416378] => 9483416378
[8277227510] => 8277227510
[9481706391] => 9481706391
[9902467696] => 9902467696
[9480327180] => 9480327180
[9448823592] => 9448823592
[8073984327] => 8073984327
[9611960791] => 9611960791
[9482349260] => 9482349260
[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
[9380626221] => 9380626221
[9902208660] => 9902208660
[9449773770] => 9449773770
[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
[8277786658] => 8277786658
[9481461483] => 9481461483
[9482987942] => 9482987942
[7892730459] => 7892730459
[8197688253] => 8197688253
[8762846026] => 8762846026
[9483705486] => 9483705486
[9844640556] => 9844640556
[8197837074] => 8197837074
[9481049091] => 9481049091
[9110811824] => 9110811824
[8884894173] => 8884894173
[9482191467] => 9482191467
[9449172740] => 9449172740
[7760777745] => 7760777745
[9741048331] => 9741048331
[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
[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
)
after elastic new get data
after elastic get data
26-May-2025 05:21:03 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
26-May-2025 05:21:03 pm
after elastic get data
26-May-2025 05:21:03 pm
before elastic get data
26-May-2025 05:21:03 pm
after elastic get data
26-May-2025 05:21:03 pm
before elastic get data
26-May-2025 05:21:03 pm
after elastic get data
26-May-2025 05:21:03 pm
SELECT * FROM `contacts_temp_group_36608` where group_id in(36608) group by mobile_number order by contact_id LIMIT 0,21
DND FILTERING YES
mobile no is dnd8277266493
mobile no is dnd9535896532
mobile no is dnd9845407035
mobile no is dnd9731688123
mobile no is dnd9731292836
mobile no is dnd9449108814
mobile no is dnd9449293957
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9353949591', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','8861488196', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9731292836', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9740737939', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9482626311', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9620020024', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9591977758', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9731688123', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9480737883', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','8722091654', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9742189535', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9845407035', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9449293957', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','8310567562', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9482471239', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9481105241', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9448918459', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9535896532', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','8277266493', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9449108814', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39515` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39515','9448825789', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
26-May-2025 05:21:03 pm
after INSERT DETAIL
26-May-2025 05:21:03 pm
before UPDATE SUMMARY
26-May-2025 05:21:03 pm
after before UPDATE SUMMARY
26-May-2025 05:21:03 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.91503596305847
blacklist in micro sec 0.013413190841675