SELECT * FROM voice_compaign_summary WHERE compaign_id='38825' LIMIT 1
before elastic get data
13-May-2025 06:37:05 pm
after elastic get data
13-May-2025 06:37:05 pm
before elastic new get data
13-May-2025 06:37:05 pmloop : 0
total records 88
process records 88below is user whitelist data
Array
(
[9660247793] => 9660247793
[9672017979] => 9672017979
[9901472840] => 9901472840
[9980545460] => 9980545460
[9721601358] => 9721601358
[8849583687] => 8849583687
[9910204368] => 9910204368
[9862097762] => 9862097762
[8595779385] => 8595779385
[8887667873] => 8887667873
[9322955507] => 9322955507
[9900529443] => 9900529443
[9561508582] => 9561508582
[8849833895] => 8849833895
[9340450136] => 9340450136
[9555644336] => 9555644336
[9540781418] => 9540781418
[7733348198] => 7733348198
[9955253266] => 9955253266
[7827251892] => 7827251892
[6395483434] => 6395483434
[7248546197] => 7248546197
[9986045088] => 9986045088
[9035411499] => 9035411499
[8287430255] => 8287430255
[7203988867] => 7203988867
[8708980857] => 8708980857
[9962553712] => 9962553712
[6395266795] => 6395266795
[8360530411] => 8360530411
[9290460174] => 9290460174
[9511556787] => 9511556787
[8800526025] => 8800526025
[9902546182] => 9902546182
[9726713614] => 9726713614
[7810863009] => 7810863009
[8792242486] => 8792242486
[8668716776] => 8668716776
[9511667687] => 9511667687
[9876789876] => 9876789876
[9566218417] => 9566218417
[8765445678] => 8765445678
[7777777777] => 7777777777
[8220297407] => 8220297407
[9500000110] => 9500000110
[8868823888] => 8868823888
[9654323456] => 9654323456
[9500176899] => 9500176899
[8178163054] => 8178163054
[6388368861] => 6388368861
[9837784877] => 9837784877
[8480101865] => 8480101865
[9511667898] => 9511667898
[7798922288] => 7798922288
[9792815167] => 9792815167
[7703949181] => 7703949181
[9671655551] => 9671655551
[8296780930] => 8296780930
[6267685500] => 6267685500
[9619582576] => 9619582576
[7011328489] => 7011328489
[7017266853] => 7017266853
[8887494029] => 8887494029
[9810491354] => 9810491354
[6394543646] => 6394543646
[8941805272] => 8941805272
[8017351929] => 8017351929
[9330452950] => 9330452950
[9999999999] => 9999999999
[9511445654] => 9511445654
[9361925294] => 9361925294
[9040882125] => 9040882125
[9543456787] => 9543456787
[7721045963] => 7721045963
[8160036436] => 8160036436
[7878066860] => 7878066860
[9916422998] => 9916422998
[8899988999] => 8899988999
[9511668953] => 9511668953
[7905258271] => 7905258271
[8262003997] => 8262003997
[9623190231] => 9623190231
[9717964037] => 9717964037
[7307558594] => 7307558594
[9721603158] => 9721603158
[8218429382] => 8218429382
[9548742789] => 9548742789
[9623190252] => 9623190252
)
after elastic new get data
after elastic get data
13-May-2025 06:37:06 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":7447142515,"g_id":145}]
alloted api array
Array
(
[0] => Array
(
[cli] => 7447142515
[g_id] => 145
)
)
gateway_id_arrs
Array
(
[0] => 145
)
before elastic get data
13-May-2025 06:37:06 pm
after elastic get data
13-May-2025 06:37:06 pm
before elastic get data
13-May-2025 06:37:06 pm
after elastic get data
13-May-2025 06:37:06 pm
before elastic get data
13-May-2025 06:37:06 pm
after elastic get data
13-May-2025 06:37:06 pm
SELECT * FROM `contacts_temp_group_36069` where group_id in(36069) group by mobile_number order by contact_id LIMIT 0,1
DND FILTERING YES
mobile no is dnd9623190252
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38825` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38825','9623190252', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
13-May-2025 06:37:06 pm
after INSERT DETAIL
13-May-2025 06:37:06 pm
before UPDATE SUMMARY
13-May-2025 06:37:06 pm
after before UPDATE SUMMARY
13-May-2025 06:37: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 0
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.66156816482544
blacklist in micro sec 0.00064301490783691