SELECT * FROM voice_compaign_summary WHERE compaign_id='27906' LIMIT 1
before elastic get data
20-Aug-2024 09:30:07 am
after elastic get data
20-Aug-2024 09:30:07 am
before elastic new get data
20-Aug-2024 09:30:07 ambelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
20-Aug-2024 09:30:08 amCutting Percentage = 0
1 alloted_apis_json--[{"cli":7313658832,"g_id":128}]
alloted api array
Array
(
[0] => Array
(
[cli] => 7313658832
[g_id] => 128
)
)
gateway_id_arrs
Array
(
[0] => 128
)
before elastic get data
20-Aug-2024 09:30:08 am
after elastic get data
20-Aug-2024 09:30:08 am
before elastic get data
20-Aug-2024 09:30:08 am
after elastic get data
20-Aug-2024 09:30:08 am
before elastic get data
20-Aug-2024 09:30:08 am
after elastic get data
20-Aug-2024 09:30:08 am
SELECT * FROM `contacts_temp_group_27176` where group_id in(27176) group by mobile_number order by contact_id LIMIT 0,43
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','8056791773', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9159371297', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9159538740', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','7695972968', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9500690490', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9444312980', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','8220101048', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9942463761', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9994061907', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9843474103', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9345424673', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','8220835367', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9843641140', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9047315947', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9442959119', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9994470018', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9360394794', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9443013557', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9943704193', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','8270849126', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9787506035', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9626443349', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9600504252', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9442689233', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9976793739', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9443020637', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9442757427', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9344401872', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9894765451', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9443502556', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9943874357', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9003409915', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9598168456', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9442048999', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9486362001', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9486671505', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','8667601373', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9842969190', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9976790728', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9894893966', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9698788481', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','9843075756', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
INSERT INTO `voice_compaign_detail_27906` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27906','6384964560', 'p', '128', '0', '','','','', '')
before INSERT DETAIL
20-Aug-2024 09:30:08 am
after INSERT DETAIL
20-Aug-2024 09:30:08 am
before UPDATE SUMMARY
20-Aug-2024 09:30:08 am
after before UPDATE SUMMARY
20-Aug-2024 09:30:08 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
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.044673919677734
blacklist in micro sec 0.025740146636963