SELECT * FROM voice_compaign_summary WHERE compaign_id='39434' LIMIT 1
before elastic get data
25-May-2025 10:15:11 am
after elastic get data
25-May-2025 10:15:11 am
before elastic new get data
25-May-2025 10:15:11 amloop : 0
total records 290
process records 290below is user whitelist data
Array
(
[9490247175] => 9490247175
[7396507062] => 7396507062
[9885770215] => 9885770215
[9989336129] => 9989336129
[9989020028] => 9989020028
[9866625042] => 9866625042
[9063609799] => 9063609799
[9701409799] => 9701409799
[9542550028] => 9542550028
[9448854653] => 9448854653
[9594273876] => 9594273876
[7999434507] => 7999434507
[7568819305] => 7568819305
[8458991987] => 8458991987
[9561559392] => 9561559392
[9740948216] => 9740948216
[9792937439] => 9792937439
[9984999511] => 9984999511
[8546079708] => 8546079708
[8128337118] => 8128337118
[9782253089] => 9782253089
[9527939281] => 9527939281
[7823037021] => 7823037021
[9503616366] => 9503616366
[9978544934] => 9978544934
[7439774152] => 7439774152
[9399604155] => 9399604155
[7775877708] => 7775877708
[8390315571] => 8390315571
[7995909281] => 7995909281
[9552773300] => 9552773300
[9796362826] => 9796362826
[7030724313] => 7030724313
[9573016469] => 9573016469
[7024823740] => 7024823740
[8448736963] => 8448736963
[7219346802] => 7219346802
[7060841595] => 7060841595
[7743995230] => 7743995230
[8016616517] => 8016616517
[7028544853] => 7028544853
[9634864643] => 9634864643
[8095243450] => 8095243450
[8927366303] => 8927366303
[8401230380] => 8401230380
[9861882843] => 9861882843
[8103461673] => 8103461673
[9763737253] => 9763737253
[7076417326] => 7076417326
[7972058422] => 7972058422
[8273865572] => 8273865572
[8329245739] => 8329245739
[7709429446] => 7709429446
[8279770541] => 8279770541
[9579667051] => 9579667051
[7263099000] => 7263099000
[7999231078] => 7999231078
[9024029474] => 9024029474
[8962287353] => 8962287353
[7774015554] => 7774015554
[6582037557] => 6582037557
[8081053119] => 8081053119
[9096916998] => 9096916998
[7666067323] => 7666067323
[8759338436] => 8759338436
[9823930799] => 9823930799
[8839293135] => 8839293135
[8240528471] => 8240528471
[9588447040] => 9588447040
[8989733726] => 8989733726
[9644128319] => 9644128319
[8856840287] => 8856840287
[7498425883] => 7498425883
[9407266435] => 9407266435
[6362700122] => 6362700122
[8370033066] => 8370033066
[7814346359] => 7814346359
[7827573625] => 7827573625
[9555670167] => 9555670167
[7080462934] => 7080462934
[8770226319] => 8770226319
[9689284382] => 9689284382
[9082507533] => 9082507533
[8449449233] => 8449449233
[9516423310] => 9516423310
[9834260882] => 9834260882
[8401880187] => 8401880187
[7020649488] => 7020649488
[7065516467] => 7065516467
[8758772742] => 8758772742
[9538683842] => 9538683842
[8210283915] => 8210283915
[6360277083] => 6360277083
[7508441444] => 7508441444
[7083416456] => 7083416456
[7249613315] => 7249613315
[9797870729] => 9797870729
[8572840533] => 8572840533
[9832694744] => 9832694744
[9518633703] => 9518633703
[9945706177] => 9945706177
[7008250527] => 7008250527
[8088637804] => 8088637804
[9834577756] => 9834577756
[7350063036] => 7350063036
[8555088554] => 8555088554
[9148827418] => 9148827418
[8076343977] => 8076343977
[8709322177] => 8709322177
[8708672540] => 8708672540
[9909811173] => 9909811173
[9882915407] => 9882915407
[9148821418] => 9148821418
[6389524205] => 6389524205
[8757727875] => 8757727875
[8860718665] => 8860718665
[8264930093] => 8264930093
[9556793180] => 9556793180
[9913554524] => 9913554524
[8591173231] => 8591173231
[9804179065] => 9804179065
[9289431992] => 9289431992
[8745098349] => 8745098349
[9978083069] => 9978083069
[6264203959] => 6264203959
[9829751567] => 9829751567
[8623906122] => 8623906122
[9082215646] => 9082215646
[8476982954] => 8476982954
[9429347011] => 9429347011
[7841838676] => 7841838676
[8770309320] => 8770309320
[9425999012] => 9425999012
[7987115494] => 7987115494
[7666737476] => 7666737476
[9310056612] => 9310056612
[9022844209] => 9022844209
[9009289596] => 9009289596
[6262999612] => 6262999612
[7056596600] => 7056596600
[6656868668] => 6656868668
[6263600134] => 6263600134
[9422424235] => 9422424235
[9765902207] => 9765902207
[8850174639] => 8850174639
[9953090406] => 9953090406
[9717312470] => 9717312470
[9326929803] => 9326929803
[8109907189] => 8109907189
[8459095851] => 8459095851
[7709536595] => 7709536595
[8658781707] => 8658781707
[7359275862] => 7359275862
[9903990724] => 9903990724
[8319192831] => 8319192831
[9328957539] => 9328957539
[9691949759] => 9691949759
[8448228211] => 8448228211
[9260958272] => 9260958272
[9313416370] => 9313416370
[9178254902] => 9178254902
[6386367305] => 6386367305
[9057613782] => 9057613782
[9494003884] => 9494003884
[8617382001] => 8617382001
[9313665969] => 9313665969
[9027596352] => 9027596352
[8237553322] => 8237553322
[9021361631] => 9021361631
[9988808967] => 9988808967
[6352539126] => 6352539126
[9356257789] => 9356257789
[9123696744] => 9123696744
[9373759352] => 9373759352
[8626009803] => 8626009803
[7411809561] => 7411809561
[7322975741] => 7322975741
[9415599969] => 9415599969
[9140806855] => 9140806855
[8482813394] => 8482813394
[9826796978] => 9826796978
[6397560333] => 6397560333
[7208317860] => 7208317860
[9814640944] => 9814640944
[8193986439] => 8193986439
[9922784783] => 9922784783
[9953203640] => 9953203640
[7219781729] => 7219781729
[8779159764] => 8779159764
[9528189376] => 9528189376
[7039546987] => 7039546987
[8962606567] => 8962606567
[7666989399] => 7666989399
[9008331402] => 9008331402
[8200327336] => 8200327336
[9975458330] => 9975458330
[8144729250] => 8144729250
[9075684811] => 9075684811
[9697076826] => 9697076826
[8805927885] => 8805927885
[9096831046] => 9096831046
[9657057464] => 9657057464
[7470693468] => 7470693468
[7817978802] => 7817978802
[9327047612] => 9327047612
[9175520378] => 9175520378
[7013303579] => 7013303579
[9424881654] => 9424881654
[6264766180] => 6264766180
[7028231612] => 7028231612
[6265936494] => 6265936494
[9557716297] => 9557716297
[6354614318] => 6354614318
[8600628322] => 8600628322
[9172458329] => 9172458329
[9960833849] => 9960833849
[8003061982] => 8003061982
[8368803138] => 8368803138
[6363145982] => 6363145982
[7001562315] => 7001562315
[7368825761] => 7368825761
[8983587305] => 8983587305
[8485888111] => 8485888111
[8602013353] => 8602013353
[8077176363] => 8077176363
[8209297978] => 8209297978
[7780822218] => 7780822218
[6200546943] => 6200546943
[8400911454] => 8400911454
[8792921078] => 8792921078
[9697979590] => 9697979590
[8169648997] => 8169648997
[8296232106] => 8296232106
[7431466330] => 7431466330
[8308494901] => 8308494901
[9834009895] => 9834009895
[9770295630] => 9770295630
[6205391608] => 6205391608
[8602462216] => 8602462216
[8955148269] => 8955148269
[8884557940] => 8884557940
[9458277643] => 9458277643
[8496988041] => 8496988041
[8169756863] => 8169756863
[8866531013] => 8866531013
[9542768401] => 9542768401
[7879482948] => 7879482948
[9712483072] => 9712483072
[8084613401] => 8084613401
[9044795879] => 9044795879
[8770035852] => 8770035852
[7415718284] => 7415718284
[8830614098] => 8830614098
[9309292894] => 9309292894
[7972783232] => 7972783232
[8817133605] => 8817133605
[9566233553] => 9566233553
[9726067982] => 9726067982
[8768695253] => 8768695253
[9067577766] => 9067577766
[7465021070] => 7465021070
[7878867040] => 7878867040
[7388628151] => 7388628151
[9767030879] => 9767030879
[8149200747] => 8149200747
[8724912770] => 8724912770
[9616892311] => 9616892311
[7485016478] => 7485016478
[9113757673] => 9113757673
[9987535937] => 9987535937
[7878499964] => 7878499964
[8305483255] => 8305483255
[9900673299] => 9900673299
[9449641922] => 9449641922
[9834653618] => 9834653618
[8668583033] => 8668583033
[9722734055] => 9722734055
[9284123813] => 9284123813
[7624929256] => 7624929256
[8600166833] => 8600166833
[7257811807] => 7257811807
[8866862457] => 8866862457
[8200048709] => 8200048709
[8081865782] => 8081865782
[8789782304] => 8789782304
[9666320362] => 9666320362
[8982191775] => 8982191775
[8080345894] => 8080345894
[8518015068] => 8518015068
[8917431487] => 8917431487
)
after elastic new get data
after elastic get data
25-May-2025 10:15:11 amCutting 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
25-May-2025 10:15:11 am
after elastic get data
25-May-2025 10:15:11 am
before elastic get data
25-May-2025 10:15:11 am
after elastic get data
25-May-2025 10:15:11 am
before elastic get data
25-May-2025 10:15:11 am
after elastic get data
25-May-2025 10:15:11 am
SELECT * FROM `contacts_temp_group_36551` where group_id in(36551) group by mobile_number order by contact_id LIMIT 0,31
DND FILTERING YES
mobile no is dnd8305483255
mobile no is dnd7878499964
mobile no is dnd9113757673
mobile no is dnd7878867040
mobile no is dnd9067577766
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','7878867040', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8724912770', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','7388628151', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9767030879', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9067577766', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','7465021070', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9616892311', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8081865782', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8668583033', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8917431487', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8149200747', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','7624929256', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9449641922', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8600166833', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8305483255', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9900673299', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','7257811807', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','7485016478', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8866862457', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9113757673', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9987535937', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9834653618', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8200048709', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8789782304', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9722734055', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9284123813', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','9666320362', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8982191775', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','7878499964', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8080345894', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39434` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39434','8518015068', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
25-May-2025 10:15:12 am
after INSERT DETAIL
25-May-2025 10:15:12 am
before UPDATE SUMMARY
25-May-2025 10:15:12 am
after before UPDATE SUMMARY
25-May-2025 10:15:12 am
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.40165686607361
blacklist in micro sec 0.017650365829468