SELECT * FROM voice_compaign_summary WHERE compaign_id='38770' LIMIT 1
before elastic get data
12-May-2025 02:44:08 pm
after elastic get data
12-May-2025 02:44:08 pm
before elastic new get data
12-May-2025 02:44:08 pmloop : 0
total records 9
process records 9below is user whitelist data
Array
(
[9977099303] => 9977099303
[9421614735] => 9421614735
[9422748548] => 9422748548
[9225123223] => 9225123223
[7517455505] => 7517455505
[9174599999] => 9174599999
[9174444447] => 9174444447
[8109060600] => 8109060600
[8770956513] => 8770956513
)
after elastic new get data
after elastic get data
12-May-2025 02:44: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
12-May-2025 02:44:09 pm
after elastic get data
12-May-2025 02:44:09 pm
before elastic get data
12-May-2025 02:44:09 pm
after elastic get data
12-May-2025 02:44:09 pm
before elastic get data
12-May-2025 02:44:09 pm
after elastic get data
12-May-2025 02:44:09 pm
SELECT * FROM `contacts_temp_group_36025` where group_id in(36025) group by mobile_number order by contact_id LIMIT 0,3
DND FILTERING YES
mobile no is dnd8109060600
mobile no is dnd8770956513
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38770` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38770','9174444447', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
12-May-2025 02:44:09 pm
after INSERT DETAIL
12-May-2025 02:44:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38770` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38770','8109060600', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
12-May-2025 02:44:09 pm
after INSERT DETAIL
12-May-2025 02:44:09 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38770` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38770','8770956513', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
12-May-2025 02:44:09 pm
after INSERT DETAIL
12-May-2025 02:44:09 pm
before UPDATE SUMMARY
12-May-2025 02:44:09 pm
after before UPDATE SUMMARY
12-May-2025 02:44: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 0
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.14513516426086
blacklist in micro sec 0.0019392967224121