SELECT * FROM voice_compaign_summary WHERE compaign_id='40030' LIMIT 1
before elastic get data
05-Jun-2025 01:31:24 pm
after elastic get data
05-Jun-2025 01:31:24 pm
before elastic new get data
05-Jun-2025 01:31:24 pmloop : 0
total records 54
process records 54below is user whitelist data
Array
(
[9063555222] => 9063555222
[8712372751] => 8712372751
[9440808443] => 9440808443
[8971888885] => 8971888885
[8886926763] => 8886926763
[9440045822] => 9440045822
[7888050725] => 7888050725
[7888050731] => 7888050731
[7888050734] => 7888050734
[9623061081] => 9623061081
[9763694840] => 9763694840
[9850232787] => 9850232787
[9011680122] => 9011680122
[9028299268] => 9028299268
[8484030939] => 8484030939
[9422866764] => 9422866764
[7588189529] => 7588189529
[7620030355] => 7620030355
[9405430144] => 9405430144
[8805423923] => 8805423923
[9850283904] => 9850283904
[8263976176] => 8263976176
[8788632418] => 8788632418
[8975823853] => 8975823853
[8767266220] => 8767266220
[9404850328] => 9404850328
[9421773275] => 9421773275
[9881129605] => 9881129605
[7775904292] => 7775904292
[8275808033] => 8275808033
[9850503058] => 9850503058
[9421980556] => 9421980556
[9130457346] => 9130457346
[9763114092] => 9763114092
[9551360138] => 9551360138
[9765198319] => 9765198319
[9552286311] => 9552286311
[7559167826] => 7559167826
[9763040055] => 9763040055
[9834590934] => 9834590934
[7720832043] => 7720832043
[8830560417] => 8830560417
[9552343857] => 9552343857
[9921021642] => 9921021642
[9823651909] => 9823651909
[8668832774] => 8668832774
[9881389175] => 9881389175
[9527913810] => 9527913810
[8830703058] => 8830703058
[9766516222] => 9766516222
[9156419526] => 9156419526
[8087894009] => 8087894009
[7888050726] => 7888050726
[9881553058] => 9881553058
)
after elastic new get data
after elastic get data
05-Jun-2025 01:31:24 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"140"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 140
)
)
gateway_id_arrs
Array
(
[0] => 140
)
before elastic get data
05-Jun-2025 01:31:24 pm
after elastic get data
05-Jun-2025 01:31:24 pm
before elastic get data
05-Jun-2025 01:31:24 pm
after elastic get data
05-Jun-2025 01:31:24 pm
before elastic get data
05-Jun-2025 01:31:24 pm
after elastic get data
05-Jun-2025 01:31:24 pm
SELECT * FROM `contacts_temp_group_36975` where group_id in(36975) group by mobile_number order by contact_id LIMIT 0,2
DND FILTERING YES
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_40030` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('40030','7888050726', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-Jun-2025 01:31:24 pm
after INSERT DETAIL
05-Jun-2025 01:31:24 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_40030` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('40030','9881553058', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-Jun-2025 01:31:24 pm
after INSERT DETAIL
05-Jun-2025 01:31:24 pm
before UPDATE SUMMARY
05-Jun-2025 01:31:24 pm
after before UPDATE SUMMARY
05-Jun-2025 01:31:24 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 0
whitelist get data mic sec 0.025048971176147
blacklist in micro sec 0.0013492107391357