SELECT * FROM voice_compaign_summary WHERE compaign_id='39613' LIMIT 1
before elastic get data
28-May-2025 05:22:05 pm
after elastic get data
28-May-2025 05:22:05 pm
before elastic new get data
28-May-2025 05:22:05 pmloop : 0
total records 161
process records 161below is user whitelist data
Array
(
[9908756084] => 9908756084
[9701314532] => 9701314532
[9530049999] => 9530049999
[9951059097] => 9951059097
[9701243762] => 9701243762
[9912645303] => 9912645303
[8374119474] => 8374119474
[9676371074] => 9676371074
[9000780401] => 9000780401
[8712345638] => 8712345638
[8885965999] => 8885965999
[8712345606] => 8712345606
[9346432062] => 9346432062
[6303642625] => 6303642625
[6305100051] => 6305100051
[9381383157] => 9381383157
[9182481794] => 9182481794
[7995766104] => 7995766104
[8498892335] => 8498892335
[7893655772] => 7893655772
[8374694752] => 8374694752
[7995244729] => 7995244729
[8317650258] => 8317650258
[9441252050] => 9441252050
[9908246823] => 9908246823
[9348199999] => 9348199999
[9553929053] => 9553929053
[6305131165] => 6305131165
[8106706503] => 8106706503
[9515564988] => 9515564988
[8790489431] => 8790489431
[9441987642] => 9441987642
[9392388995] => 9392388995
[7386727318] => 7386727318
[9949667367] => 9949667367
[8008864535] => 8008864535
[8500799994] => 8500799994
[9441746028] => 9441746028
[9951723883] => 9951723883
[9908915145] => 9908915145
[9866998161] => 9866998161
[7207894999] => 7207894999
[9951712883] => 9951712883
[9948601402] => 9948601402
[8074502310] => 8074502310
[8179442321] => 8179442321
[8522836785] => 8522836785
[8790159193] => 8790159193
[9347061509] => 9347061509
[9849239765] => 9849239765
[9908097778] => 9908097778
[8008723589] => 8008723589
[8247496991] => 8247496991
[8790434083] => 8790434083
[6301363851] => 6301363851
[6304832410] => 6304832410
[7702423917] => 7702423917
[9441508091] => 9441508091
[9441746657] => 9441746657
[8790485556] => 8790485556
[7569054314] => 7569054314
[7780622930] => 7780622930
[7799355106] => 7799355106
[9441803213] => 9441803213
[9550464491] => 9550464491
[9550464931] => 9550464931
[9573235585] => 9573235585
[9603853019] => 9603853019
[7981225815] => 7981225815
[9441979499] => 9441979499
[9490369104] => 9490369104
[9177558357] => 9177558357
[8897888151] => 8897888151
[9000431810] => 9000431810
[9010066743] => 9010066743
[9652271339] => 9652271339
[9160048537] => 9160048537
[9177158197] => 9177158197
[9381716970] => 9381716970
[9392210560] => 9392210560
[9000068043] => 9000068043
[9059991016] => 9059991016
[9110507020] => 9110507020
[9177179507] => 9177179507
[9391132582] => 9391132582
[9440704420] => 9440704420
[9441200850] => 9441200850
[8790620708] => 8790620708
[8897965307] => 8897965307
[9010522684] => 9010522684
[9618651853] => 9618651853
[9676314935] => 9676314935
[9705593329] => 9705593329
[9849343226] => 9849343226
[9908600325] => 9908600325
[9912551582] => 9912551582
[9949677471] => 9949677471
[9652939409] => 9652939409
[9666546850] => 9666546850
[9704722495] => 9704722495
[9949903951] => 9949903951
[9676984784] => 9676984784
[9866403438] => 9866403438
[9951154081] => 9951154081
[9989499645] => 9989499645
[9490369175] => 9490369175
[9573268098] => 9573268098
[6300461163] => 6300461163
[8978101474] => 8978101474
[8978694901] => 8978694901
[9573235663] => 9573235663
[7386510113] => 7386510113
[9963801811] => 9963801811
[9676087450] => 9676087450
[9908391979] => 9908391979
[9963465827] => 9963465827
[9989620945] => 9989620945
[9440774304] => 9440774304
[7995137574] => 7995137574
[9989467411] => 9989467411
[7995711031] => 7995711031
[9908094963] => 9908094963
[9603983310] => 9603983310
[9642959495] => 9642959495
[9502570366] => 9502570366
[9652787215] => 9652787215
[8374590954] => 8374590954
[9493467538] => 9493467538
[9398918460] => 9398918460
[9618710087] => 9618710087
[9326881043] => 9326881043
[8879332664] => 8879332664
[8925508092] => 8925508092
[9152379039] => 9152379039
[7979804246] => 7979804246
[7208865591] => 7208865591
[9563222210] => 9563222210
[9970052555] => 9970052555
[8087799869] => 8087799869
[9207747374] => 9207747374
[9899180000] => 9899180000
[9463135770] => 9463135770
[9604858331] => 9604858331
[7249211259] => 7249211259
[8793748279] => 8793748279
[8793748280] => 8793748280
[8793748281] => 8793748281
[8793748282] => 8793748282
[8793748283] => 8793748283
[8793748285] => 8793748285
[9198905948] => 9198905948
[9437210321] => 9437210321
[8793748286] => 8793748286
[9706177712] => 9706177712
[8793748278] => 8793748278
[8793748284] => 8793748284
[8793748287] => 8793748287
[8793748288] => 8793748288
[8485812710] => 8485812710
[7016762050] => 7016762050
[9325508092] => 9325508092
)
after elastic new get data
after elastic get data
28-May-2025 05:22:05 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
28-May-2025 05:22:05 pm
after elastic get data
28-May-2025 05:22:05 pm
before elastic get data
28-May-2025 05:22:05 pm
after elastic get data
28-May-2025 05:22:05 pm
before elastic get data
28-May-2025 05:22:05 pm
after elastic get data
28-May-2025 05:22:05 pm
SELECT * FROM `contacts_temp_group_36677` where group_id in(36677) group by mobile_number order by contact_id LIMIT 0,1
DND FILTERING YES
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39613` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39613','9325508092', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
28-May-2025 05:22:06 pm
after INSERT DETAIL
28-May-2025 05:22:06 pm
before UPDATE SUMMARY
28-May-2025 05:22:06 pm
after before UPDATE SUMMARY
28-May-2025 05:22:06 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 -247892617123
blacklis in sec 0
whitelist get data sec 0
whitelist get data mic sec 0.21099996566772
blacklist in micro sec 0.00081896781921387