SELECT * FROM voice_compaign_summary WHERE compaign_id='43919' LIMIT 1
before elastic get data
14-Jul-2025 06:32:10 pm
after elastic get data
14-Jul-2025 06:32:10 pm
before elastic new get data
14-Jul-2025 06:32:10 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
14-Jul-2025 06:32:10 pm alloted_apis_json--[{"cli":"","g_id":"31"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 31
)
)
gateway_id_arrs
Array
(
[0] => 31
)
before elastic get data
14-Jul-2025 06:32:10 pm
after elastic get data
14-Jul-2025 06:32:10 pm
before elastic get data
14-Jul-2025 06:32:10 pm
after elastic get data
14-Jul-2025 06:32:10 pm
before elastic get data
14-Jul-2025 06:32:10 pm
after elastic get data
14-Jul-2025 06:32:10 pm
SELECT * FROM `contacts_temp_group_45358` where group_id in(45358) group by mobile_number order by contact_id LIMIT 0,36
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
DND FILTERING YES {"query":{"bool":{"must":[{"terms":{"Mobile":[7374039456,9828302040,7665638408,9414211417,8058342579,9636505324,6376551306,8107754062,9337875825,9087242995,9928273366,9982937647,9828555885,8058379941,9166245733,9828660022,7742286219,8955363875,6377820792,9166833179,6378405578,9887331571,9928382408,9166085225,8955734483,9928207097,8741050805,9664003422,9602587717,9575846273,9950351707,9694122652,6367959052,9461176865,9783613152,9024544596]}}]}}}
mobile no is dnd7742286219
mobile no is dnd9166833179
mobile no is dnd9828660022
mobile no is dnd7374039456
mobile no is dnd8107754062
mobile no is dnd9166085225
mobile no is dnd9828555885
mobile no is dnd9928273366
mobile no is dnd9928207097
mobile no is dnd9828302040
mobile no is dnd9982937647
mobile no is dnd9166245733
mobile no is dnd9636505324
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','7374039456', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9828302040', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','7665638408', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9414211417', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','8058342579', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9636505324', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','6376551306', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','8107754062', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9337875825', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9087242995', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9928273366', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9982937647', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9828555885', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','8058379941', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9166245733', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9828660022', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','7742286219', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','8955363875', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','6377820792', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9166833179', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','6378405578', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9887331571', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9928382408', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9166085225', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','8955734483', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9928207097', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','8741050805', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9664003422', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9602587717', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9575846273', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9950351707', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9694122652', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','6367959052', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9461176865', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9783613152', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
after BLACKLIST_CONTASTS
14-Jul-2025 06:32:11 pm
INSERT INTO `voice_compaign_detail_43919` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('43919','9024544596', 'p', '31', '0', '','','','', '')
before INSERT DETAIL
14-Jul-2025 06:32:11 pm
after INSERT DETAIL
14-Jul-2025 06:32:11 pm
before UPDATE SUMMARY
14-Jul-2025 06:32:11 pm
after before UPDATE SUMMARY
14-Jul-2025 06:32:11 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 -41156812800
blacklis in sec 0
whitelist get data sec 0
whitelist get data mic sec 4.0054321289062E-5
blacklist in micro sec 0.016886234283447