SELECT * FROM voice_compaign_summary WHERE compaign_id='29022' LIMIT 1
before elastic get data
30-Aug-2024 03:02:11 pm
after elastic get data
30-Aug-2024 03:02:11 pm
before elastic new get data
30-Aug-2024 03:02:11 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
30-Aug-2024 03:02:11 pmCutting Percentage = 45
1 alloted_apis_json--[{"cli":"","g_id":"54"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 54
)
)
gateway_id_arrs
Array
(
[0] => 54
)
before elastic get data
30-Aug-2024 03:02:11 pm
after elastic get data
30-Aug-2024 03:02:11 pm
before elastic get data
30-Aug-2024 03:02:11 pm
after elastic get data
30-Aug-2024 03:02:11 pm
before elastic get data
30-Aug-2024 03:02:11 pm
after elastic get data
30-Aug-2024 03:02:11 pm
SELECT * FROM `contacts_temp_group_28254` where group_id in(28254) group by mobile_number order by contact_id LIMIT 0,55
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7027841955', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9350572331', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8529480428', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930110268', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8683811099', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8307694352', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7015184272', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930429190', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9996372980', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7930662280', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8851822499', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9653515433', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9053542947', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9813210723', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9254868312', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8950333404', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7919001660', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9611610884', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9896568568', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9468003297', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9350044915', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8168009411', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9306476808', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8398907158', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7015726084', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8307143198', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930485309', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930095753', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8685838190', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9306647952', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9813008251', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9671468438', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8168743758', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9540550962', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7404900426', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8607344131', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7015152084', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9991951408', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9815532804', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9050773978', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8950006081', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8053007964', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7082097191', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8571022308', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8685889939', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8813072773', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9813682032', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8586845545', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8607121535', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9991568148', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9255539809', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9812878199', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8397910430', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7056920225', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8059656690', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
30-Aug-2024 03:02:11 pm
after INSERT DETAIL
30-Aug-2024 03:02:11 pm
before UPDATE SUMMARY
30-Aug-2024 03:02:11 pm
after before UPDATE SUMMARY
30-Aug-2024 03:02: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
blacklis in sec 0
whitelist get data sec 0
whitelist get data mic sec 0.12336897850037
blacklist in micro sec 0.031297922134399