SELECT * FROM voice_compaign_summary WHERE compaign_id='29560' LIMIT 1
before elastic get data
26-Sep-2024 11:00:11 am
after elastic get data
26-Sep-2024 11:00:11 am
before elastic new get data
26-Sep-2024 11:00:11 ambelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
26-Sep-2024 11:00:11 amCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"132"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 132
)
)
gateway_id_arrs
Array
(
[0] => 132
)
before elastic get data
26-Sep-2024 11:00:11 am
after elastic get data
26-Sep-2024 11:00:11 am
before elastic get data
26-Sep-2024 11:00:11 am
after elastic get data
26-Sep-2024 11:00:11 am
before elastic get data
26-Sep-2024 11:00:11 am
after elastic get data
26-Sep-2024 11:00:11 am
SELECT * FROM `contacts_temp_group_28676` where group_id in(28676) group by mobile_number order by contact_id LIMIT 0,49
DND FILTERING YES
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9585322380', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','7339565631', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9500855927', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9080757200', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','8610479390', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9442048845', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9943284375', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9865848711', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9943856655', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9884277576', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','7639891135', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','7708261919', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9500239368', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9442757427', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9500297026', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9597811584', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9600080732', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9095935571', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9788763995', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','6382155929', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9047168617', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','8870270251', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9486922455', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9944035004', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9842779152', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9894893830', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9750105997', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9047640160', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9488088793', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','8695522721', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9994717850', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9597863393', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9943570582', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','8220763825', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9655781429', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','7708468683', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9486290488', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9750573819', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9698474815', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','7708802156', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9443495458', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9442046239', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9943065108', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','7449090098', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','8220065380', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9994470018', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9597326867', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','8663131185', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
INSERT INTO `voice_compaign_detail_29560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29560','9095929366', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
26-Sep-2024 11:00:11 am
after INSERT DETAIL
26-Sep-2024 11:00:11 am
before UPDATE SUMMARY
26-Sep-2024 11:00:11 am
after before UPDATE SUMMARY
26-Sep-2024 11:00: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 0
whitelist get data mic sec 0.021965980529785
blacklist in micro sec 0.028845548629761