SELECT * FROM voice_compaign_summary WHERE compaign_id='29357' LIMIT 1
before elastic get data
23-Sep-2024 09:30:10 am
after elastic get data
23-Sep-2024 09:30:10 am
before elastic new get data
23-Sep-2024 09:30:10 ambelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
23-Sep-2024 09:30:11 amCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"114"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 114
)
)
gateway_id_arrs
Array
(
[0] => 114
)
before elastic get data
23-Sep-2024 09:30:11 am
after elastic get data
23-Sep-2024 09:30:11 am
before elastic get data
23-Sep-2024 09:30:11 am
after elastic get data
23-Sep-2024 09:30:11 am
before elastic get data
23-Sep-2024 09:30:11 am
after elastic get data
23-Sep-2024 09:30:11 am
SELECT * FROM `contacts_temp_group_28526` where group_id in(28526) group by mobile_number order by contact_id LIMIT 0,46
DND FILTERING YES
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9842178976', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9976498550', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9715906843', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9865906548', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9159225109', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','7397033904', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8248128898', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9342241899', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9786269706', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8667889438', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','6369222175', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8220621411', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','7339453304', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9698936832', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9787506012', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','6384161349', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9688181581', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9003787784', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','7845331945', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9943875788', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','6380908613', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8489856065', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9787978272', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9786465545', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9363385478', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9500816621', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9788181546', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9514423389', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8072832348', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9047315057', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9655012819', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9597259789', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8122472387', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8015610885', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9489810657', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9159268629', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9003743747', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9894869288', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9943251391', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9943281128', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8610305516', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9786845596', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','8098663010', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9626097104', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','9790520709', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
INSERT INTO `voice_compaign_detail_29357` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29357','7418199443', 'p', '114', '0', '','','','', '')
before INSERT DETAIL
23-Sep-2024 09:30:11 am
after INSERT DETAIL
23-Sep-2024 09:30:11 am
before UPDATE SUMMARY
23-Sep-2024 09:30:11 am
after before UPDATE SUMMARY
23-Sep-2024 09:30:11 am
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.022539138793945
blacklist in micro sec 0.0271155834198