SELECT * FROM voice_compaign_summary WHERE compaign_id='59906' LIMIT 1
before elastic get data
16-Dec-2025 06:46:02 pm
after elastic get data
16-Dec-2025 06:46:02 pm
before elastic new get data
16-Dec-2025 06:46:02 pmloop : 0
total records 236
process records 236below is user whitelist data
Array
(
[6202633684] => 6202633684
[9443601928] => 9443601928
[9740885639] => 9740885639
[9011875159] => 9011875159
[8750759921] => 8750759921
[9604444486] => 9604444486
[9773657348] => 9773657348
[9530973370] => 9530973370
[9414030236] => 9414030236
[9646585079] => 9646585079
[9550852636] => 9550852636
[9011455889] => 9011455889
[8910251494] => 8910251494
[9478090684] => 9478090684
[8252461410] => 8252461410
[8240459716] => 8240459716
[8198972513] => 8198972513
[9651454381] => 9651454381
[9485992063] => 9485992063
[8306782587] => 8306782587
[9520418571] => 9520418571
[9075413619] => 9075413619
[9024300466] => 9024300466
[8511673572] => 8511673572
[9765433198] => 9765433198
[7989906067] => 7989906067
[7430995751] => 7430995751
[8160393113] => 8160393113
[9060944089] => 9060944089
[8799869821] => 8799869821
[9005592011] => 9005592011
[7654989134] => 7654989134
[9313633028] => 9313633028
[7409628705] => 7409628705
[9956172162] => 9956172162
[9739610618] => 9739610618
[9131801751] => 9131801751
[7667914442] => 7667914442
[7558606774] => 7558606774
[9896307175] => 9896307175
[6290439436] => 6290439436
[7270927003] => 7270927003
[9640313101] => 9640313101
[7978578964] => 7978578964
[9212342111] => 9212342111
[9540289321] => 9540289321
[8368890003] => 8368890003
[9633999976] => 9633999976
[9321462094] => 9321462094
[9668414752] => 9668414752
[7207409281] => 7207409281
[8445520679] => 8445520679
[9855761961] => 9855761961
[8406044862] => 8406044862
[8630333389] => 8630333389
[8827281473] => 8827281473
[9411668947] => 9411668947
[8638448685] => 8638448685
[9421041491] => 9421041491
[9037682259] => 9037682259
[7037661851] => 7037661851
[9852279202] => 9852279202
[9438420902] => 9438420902
[9377585771] => 9377585771
[9336877055] => 9336877055
[9414348691] => 9414348691
[9537475459] => 9537475459
[8793679471] => 8793679471
[9016372198] => 9016372198
[9604141812] => 9604141812
[7498383394] => 7498383394
[9939753688] => 9939753688
[9886625749] => 9886625749
[9165669311] => 9165669311
[8767534937] => 8767534937
[8240853529] => 8240853529
[9855421501] => 9855421501
[7304444486] => 7304444486
[9925019684] => 9925019684
[8360189942] => 8360189942
[7678354888] => 7678354888
[9959200228] => 9959200228
[9668184210] => 9668184210
[9621604021] => 9621604021
[7889288949] => 7889288949
[9650871703] => 9650871703
[9545825925] => 9545825925
[7909480203] => 7909480203
[8871264288] => 8871264288
[9813859444] => 9813859444
[8700722314] => 8700722314
[8728919999] => 8728919999
[7895465949] => 7895465949
[8080532271] => 8080532271
[9928423901] => 9928423901
[9540309008] => 9540309008
[7980249710] => 7980249710
[9271594715] => 9271594715
[9560654215] => 9560654215
[9402764308] => 9402764308
[9411457728] => 9411457728
[8536802788] => 8536802788
[9456004121] => 9456004121
[9910662930] => 9910662930
[7538000154] => 7538000154
[7875503316] => 7875503316
[7022917516] => 7022917516
[7889512130] => 7889512130
[7859993536] => 7859993536
[8329301627] => 8329301627
[9011545040] => 9011545040
[6290336372] => 6290336372
[9844125495] => 9844125495
[9672762420] => 9672762420
[9893717210] => 9893717210
[9241489507] => 9241489507
[6395619909] => 6395619909
[7600536680] => 7600536680
[7976782208] => 7976782208
[9106767818] => 9106767818
[9755161843] => 9755161843
[9689096812] => 9689096812
[7678561067] => 7678561067
[7999995007] => 7999995007
[9058106686] => 9058106686
[9368603948] => 9368603948
[7840850878] => 7840850878
[8115720902] => 8115720902
[6280341562] => 6280341562
[9483192365] => 9483192365
[9082520784] => 9082520784
[9113471840] => 9113471840
[9922471156] => 9922471156
[8249816401] => 8249816401
[9372456622] => 9372456622
[8433782325] => 8433782325
[7074504622] => 7074504622
[9175690066] => 9175690066
[9913481768] => 9913481768
[9301293380] => 9301293380
[7011913898] => 7011913898
[9963078843] => 9963078843
[7048133102] => 7048133102
[8869013084] => 8869013084
[7027447781] => 7027447781
[8134812160] => 8134812160
[6297374420] => 6297374420
[9241155126] => 9241155126
[9086841711] => 9086841711
[6387070545] => 6387070545
[7082273267] => 7082273267
[9621284906] => 9621284906
[9021445175] => 9021445175
[8005963844] => 8005963844
[8961007280] => 8961007280
[8765456786] => 8765456786
[9572112241] => 9572112241
[9923012248] => 9923012248
[7528079827] => 7528079827
[8076868821] => 8076868821
[9778020615] => 9778020615
[9925659659] => 9925659659
[9151618767] => 9151618767
[7978409078] => 7978409078
[8838266876] => 8838266876
[7838280456] => 7838280456
[7004682524] => 7004682524
[8302819637] => 8302819637
[7291079301] => 7291079301
[8329451374] => 8329451374
[7385426494] => 7385426494
[7208566773] => 7208566773
[9836113618] => 9836113618
[9170802788] => 9170802788
[9552461126] => 9552461126
[6261706074] => 6261706074
[9370557539] => 9370557539
[9303501346] => 9303501346
[9798780917] => 9798780917
[7567307349] => 7567307349
[8770847679] => 8770847679
[9155546935] => 9155546935
[6397266024] => 6397266024
[9193658636] => 9193658636
[9855172970] => 9855172970
[8999588424] => 8999588424
[7618540086] => 7618540086
[8353985040] => 8353985040
[9303496603] => 9303496603
[8959268923] => 8959268923
[7887418115] => 7887418115
[9404701508] => 9404701508
[7976861735] => 7976861735
[9017687518] => 9017687518
[6203906376] => 6203906376
[9030453524] => 9030453524
[8561924925] => 8561924925
[8923328320] => 8923328320
[8460064107] => 8460064107
[9816606020] => 9816606020
[7898641586] => 7898641586
[9630098298] => 9630098298
[8810557480] => 8810557480
[8962392653] => 8962392653
[8327778931] => 8327778931
[9003900593] => 9003900593
[9818083733] => 9818083733
[9008470618] => 9008470618
[7876142581] => 7876142581
[8822771917] => 8822771917
[7688867582] => 7688867582
[9024990894] => 9024990894
[7417451272] => 7417451272
[8618425952] => 8618425952
[6260369160] => 6260369160
[9337498602] => 9337498602
[7050292717] => 7050292717
[8411079208] => 8411079208
[9319980772] => 9319980772
[9987156368] => 9987156368
[6396784534] => 6396784534
[7888011018] => 7888011018
[8919020172] => 8919020172
[8448663254] => 8448663254
[6201887234] => 6201887234
[9763495894] => 9763495894
[8791115125] => 8791115125
[9050220400] => 9050220400
[9631530891] => 9631530891
[7567133493] => 7567133493
[8657337382] => 8657337382
[7723831742] => 7723831742
[7016578558] => 7016578558
[9320013100] => 9320013100
[7225813717] => 7225813717
[9359302614] => 9359302614
)
after elastic new get data
after elastic get data
16-Dec-2025 06:46:02 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"184"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 184
)
)
gateway_id_arrs
Array
(
[0] => 184
)
before elastic get data
16-Dec-2025 06:46:02 pm
after elastic get data
16-Dec-2025 06:46:02 pm
before elastic get data
16-Dec-2025 06:46:02 pm
after elastic get data
16-Dec-2025 06:46:02 pm
before elastic get data
16-Dec-2025 06:46:02 pm
after elastic get data
16-Dec-2025 06:46:02 pm
SELECT * FROM `contacts_temp_group_53845` where group_id in(53845) group by mobile_number order by contact_id LIMIT 0,32
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8327778931', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9008470618', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7688867582', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9024990894', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7876142581', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8822771917', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7417451272', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8618425952', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','6260369160', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9337498602', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7050292717', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9003900593', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9818083733', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','6201887234', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9763495894', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8791115125', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9050220400', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9631530891', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8411079208', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9319980772', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7567133493', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8657337382', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7723831742', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','6396784534', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7888011018', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8919020172', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9987156368', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7016578558', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9320013100', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','7225813717', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','9359302614', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59906','8448663254', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 06:46:02 pm
after INSERT DETAIL
16-Dec-2025 06:46:02 pm
before UPDATE SUMMARY
16-Dec-2025 06:46:02 pm
after before UPDATE SUMMARY
16-Dec-2025 06:46:02 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
blacklis in sec 0
whitelist get data sec 0
whitelist get data mic sec 0.033743858337402
blacklist in micro sec 0.012769937515259