SELECT * FROM voice_compaign_summary WHERE compaign_id='39086' LIMIT 1
before elastic get data
18-May-2025 10:15:11 am
after elastic get data
18-May-2025 10:15:11 am
before elastic new get data
18-May-2025 10:15:11 amloop : 0
total records 259
process records 259below 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
)
after elastic new get data
after elastic get data
18-May-2025 10:15:12 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
18-May-2025 10:15:12 am
after elastic get data
18-May-2025 10:15:12 am
before elastic get data
18-May-2025 10:15:12 am
after elastic get data
18-May-2025 10:15:12 am
before elastic get data
18-May-2025 10:15:12 am
after elastic get data
18-May-2025 10:15:12 am
SELECT * FROM `contacts_temp_group_36285` where group_id in(36285) group by mobile_number order by contact_id LIMIT 0,25
DND FILTERING YES
mobile no is dnd8602462216
mobile no is dnd7415718284
mobile no is dnd9566233553
mobile no is dnd9726067982
mobile no is dnd8866531013
mobile no is dnd7879482948
mobile no is dnd9770295630
mobile no is dnd8884557940
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9458277643', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8496988041', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8866531013', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8308494901', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9834009895', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8884557940', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8169756863', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9770295630', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8770035852', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','6205391608', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8602462216', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8955148269', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9712483072', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8817133605', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8084613401', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9566233553', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9044795879', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9726067982', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','7415718284', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8830614098', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','8768695253', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9542768401', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','9309292894', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','7972783232', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39086` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39086','7879482948', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
18-May-2025 10:15:12 am
after INSERT DETAIL
18-May-2025 10:15:12 am
before UPDATE SUMMARY
18-May-2025 10:15:12 am
after before UPDATE SUMMARY
18-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 42570403200
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.87116813659668
blacklist in micro sec 0.014091730117798