SELECT * FROM voice_compaign_summary WHERE compaign_id='59710' LIMIT 1
before elastic get data
15-Dec-2025 01:15:08 pm
after elastic get data
15-Dec-2025 01:15:08 pm
before elastic new get data
15-Dec-2025 01:15:08 pmloop : 0
total records 277
process records 277below is user whitelist data
Array
(
[9492449562] => 9492449562
[8106310709] => 8106310709
[8186869488] => 8186869488
[9494970131] => 9494970131
[9493723389] => 9493723389
[9885980553] => 9885980553
[6303922677] => 6303922677
[9515266460] => 9515266460
[9494013302] => 9494013302
[9491571243] => 9491571243
[9490459617] => 9490459617
[9398544354] => 9398544354
[9052119338] => 9052119338
[9666633453] => 9666633453
[9441326521] => 9441326521
[7731897899] => 7731897899
[8857862465] => 8857862465
[9999392080] => 9999392080
[9575584276] => 9575584276
[9822912234] => 9822912234
[9882556639] => 9882556639
[9610619947] => 9610619947
[9972249174] => 9972249174
[8573027847] => 8573027847
[9425019623] => 9425019623
[6299901015] => 6299901015
[8712157963] => 8712157963
[9733204467] => 9733204467
[7001364733] => 7001364733
[7870569730] => 7870569730
[9601919844] => 9601919844
[9326373771] => 9326373771
[9425365811] => 9425365811
[8267810587] => 8267810587
[9767338592] => 9767338592
[9162403659] => 9162403659
[7388523232] => 7388523232
[9957918121] => 9957918121
[8116671166] => 8116671166
[9503417117] => 9503417117
[8800615929] => 8800615929
[7409238385] => 7409238385
[8810799177] => 8810799177
[8638079761] => 8638079761
[9969547520] => 9969547520
[7753035501] => 7753035501
[9021902830] => 9021902830
[6207740172] => 6207740172
[8777236335] => 8777236335
[8469618512] => 8469618512
[9038469833] => 9038469833
[7348142680] => 7348142680
[8018491634] => 8018491634
[9458406660] => 9458406660
[6201719603] => 6201719603
[8824983929] => 8824983929
[9632020679] => 9632020679
[7534880881] => 7534880881
[9890211994] => 9890211994
[8287954442] => 8287954442
[9098921420] => 9098921420
[7588394587] => 7588394587
[9339193093] => 9339193093
[7607675544] => 7607675544
[7759071904] => 7759071904
[9867016693] => 9867016693
[9523501292] => 9523501292
[9112404540] => 9112404540
[9722222128] => 9722222128
[7992303423] => 7992303423
[9061666193] => 9061666193
[9579108959] => 9579108959
[9417291305] => 9417291305
[8077946519] => 8077946519
[8407015546] => 8407015546
[8957512128] => 8957512128
[9264926183] => 9264926183
[9399144467] => 9399144467
[8989018488] => 8989018488
[6299187481] => 6299187481
[8368443057] => 8368443057
[7385426494] => 7385426494
[9096945766] => 9096945766
[9035056905] => 9035056905
[9345848173] => 9345848173
[9627940917] => 9627940917
[9820714658] => 9820714658
[8512085095] => 8512085095
[9874593806] => 9874593806
[9555493190] => 9555493190
[6280025081] => 6280025081
[9372309640] => 9372309640
[7039898250] => 7039898250
[9307748371] => 9307748371
[7905207614] => 7905207614
[8729824373] => 8729824373
[9861786343] => 9861786343
[7906553195] => 7906553195
[8141291649] => 8141291649
[9080257513] => 9080257513
[6284618669] => 6284618669
[7727965991] => 7727965991
[7386036057] => 7386036057
[9602783695] => 9602783695
[7439995275] => 7439995275
[8077586243] => 8077586243
[7033613647] => 7033613647
[9404701508] => 9404701508
[8391075506] => 8391075506
[9510705955] => 9510705955
[8770535202] => 8770535202
[8107991981] => 8107991981
[8755412559] => 8755412559
[9815474244] => 9815474244
[8218573391] => 8218573391
[8199083874] => 8199083874
[8009651105] => 8009651105
[9370677866] => 9370677866
[9540914633] => 9540914633
[7972531362] => 7972531362
[9090033513] => 9090033513
[9721959037] => 9721959037
[9041223031] => 9041223031
[9518353259] => 9518353259
[9336773331] => 9336773331
[7892676154] => 7892676154
[8690109815] => 8690109815
[7017053302] => 7017053302
[7988798016] => 7988798016
[8601662033] => 8601662033
[9462300396] => 9462300396
[8054758144] => 8054758144
[7550740160] => 7550740160
[9172665122] => 9172665122
[9732324759] => 9732324759
[7014309256] => 7014309256
[7309259312] => 7309259312
[9968462876] => 9968462876
[9045188115] => 9045188115
[9839214542] => 9839214542
[9326750265] => 9326750265
[8371039147] => 8371039147
[7908912291] => 7908912291
[9685966717] => 9685966717
[9934070980] => 9934070980
[9007216711] => 9007216711
[8126453959] => 8126453959
[8942894506] => 8942894506
[7983171406] => 7983171406
[8868869488] => 8868869488
[8283008955] => 8283008955
[9711902966] => 9711902966
[6296351157] => 6296351157
[7889705430] => 7889705430
[9161740480] => 9161740480
[9783927747] => 9783927747
[8709781887] => 8709781887
[9728203404] => 9728203404
[7617894048] => 7617894048
[9310887242] => 9310887242
[9958084745] => 9958084745
[9981998916] => 9981998916
[9733718225] => 9733718225
[6394142887] => 6394142887
[9627001943] => 9627001943
[9734548777] => 9734548777
[6392696120] => 6392696120
[9540232755] => 9540232755
[8767505297] => 8767505297
[9749487826] => 9749487826
[7718437873] => 7718437873
[9038367106] => 9038367106
[9004685800] => 9004685800
[9818833931] => 9818833931
[7813974755] => 7813974755
[8178412031] => 8178412031
[8247316952] => 8247316952
[9839339080] => 9839339080
[9872423345] => 9872423345
[9870785537] => 9870785537
[9876295678] => 9876295678
[9143055145] => 9143055145
[9804160297] => 9804160297
[9258000444] => 9258000444
[8603700984] => 8603700984
[9779492884] => 9779492884
[9727386334] => 9727386334
[8450975422] => 8450975422
[8207282855] => 8207282855
[9369511172] => 9369511172
[9996682225] => 9996682225
[6296152309] => 6296152309
[9813193905] => 9813193905
[9352004006] => 9352004006
[9777399910] => 9777399910
[9623254097] => 9623254097
[9870831042] => 9870831042
[7085824264] => 7085824264
[7677645368] => 7677645368
[9873365671] => 9873365671
[7386757890] => 7386757890
[7744977601] => 7744977601
[8421900787] => 8421900787
[8077634871] => 8077634871
[9058106686] => 9058106686
[7463089291] => 7463089291
[9996637008] => 9996637008
[9654440020] => 9654440020
[8801688981] => 8801688981
[8971114900] => 8971114900
[8587833071] => 8587833071
[9501934114] => 9501934114
[8527131433] => 8527131433
[9381786681] => 9381786681
[9577379934] => 9577379934
[9752495492] => 9752495492
[8318575500] => 8318575500
[7817047550] => 7817047550
[9004406202] => 9004406202
[8511707169] => 8511707169
[9993188335] => 9993188335
[8521970657] => 8521970657
[7014717770] => 7014717770
[8955384521] => 8955384521
[8865594140] => 8865594140
[9667200284] => 9667200284
[6289763822] => 6289763822
[8824530977] => 8824530977
[8698363796] => 8698363796
[9101778826] => 9101778826
[7208166326] => 7208166326
[8238353620] => 8238353620
[8073267711] => 8073267711
[8967000866] => 8967000866
[7384235483] => 7384235483
[9738806233] => 9738806233
[9958998528] => 9958998528
[8851977830] => 8851977830
[8390748666] => 8390748666
[9945754509] => 9945754509
[8690053559] => 8690053559
[8169140373] => 8169140373
[9789883706] => 9789883706
[7024151373] => 7024151373
[9681108519] => 9681108519
[8726081055] => 8726081055
[8810665332] => 8810665332
[9270595596] => 9270595596
[9457101626] => 9457101626
[9907833483] => 9907833483
[7800162850] => 7800162850
[7667699592] => 7667699592
[8484841978] => 8484841978
[7700046901] => 7700046901
[8278948486] => 8278948486
[7403476000] => 7403476000
[9978966334] => 9978966334
[9630098298] => 9630098298
[9432078312] => 9432078312
[8144326679] => 8144326679
[9855101016] => 9855101016
[9799241780] => 9799241780
[8305409734] => 8305409734
[9607128086] => 9607128086
[9560170614] => 9560170614
[8004358406] => 8004358406
[9688874000] => 9688874000
[6351529095] => 6351529095
[7022917516] => 7022917516
[7022646562] => 7022646562
[9716934304] => 9716934304
[7766914446] => 7766914446
[8299448393] => 8299448393
[9733775805] => 9733775805
[8440852185] => 8440852185
[9658221683] => 9658221683
[9876634510] => 9876634510
)
after elastic new get data
after elastic get data
15-Dec-2025 01:15:09 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
15-Dec-2025 01:15:09 pm
after elastic get data
15-Dec-2025 01:15:09 pm
before elastic get data
15-Dec-2025 01:15:09 pm
after elastic get data
15-Dec-2025 01:15:09 pm
before elastic get data
15-Dec-2025 01:15:09 pm
after elastic get data
15-Dec-2025 01:15:09 pm
SELECT * FROM `contacts_temp_group_53646` where group_id in(53646) group by mobile_number order by contact_id LIMIT 0,22
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','8390748666', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9945754509', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','7024151373', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','8690053559', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9681108519', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','8144326679', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','7700046901', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9855101016', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','8726081055', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','8810665332', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9270595596', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9978966334', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','7667699592', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','7022646562', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9716934304', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','6351529095', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9607128086', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','7022917516', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9560170614', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9733775805', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','8440852185', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59710` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59710','9658221683', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
15-Dec-2025 01:15:09 pm
after INSERT DETAIL
15-Dec-2025 01:15:09 pm
before UPDATE SUMMARY
15-Dec-2025 01:15:09 pm
after before UPDATE SUMMARY
15-Dec-2025 01:15:09 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 1
whitelist get data mic sec 0.72970914840698
blacklist in micro sec 0.011615514755249