SELECT * FROM voice_compaign_summary WHERE compaign_id='26307' LIMIT 1
before elastic get data
02-Aug-2024 07:00:11 pm
after elastic get data
02-Aug-2024 07:00:11 pm
before elastic new get data
02-Aug-2024 07:00:11 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
02-Aug-2024 07:00:11 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"53"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 53
)
)
gateway_id_arrs
Array
(
[0] => 53
)
before elastic get data
02-Aug-2024 07:00:11 pm
after elastic get data
02-Aug-2024 07:00:11 pm
before elastic get data
02-Aug-2024 07:00:11 pm
after elastic get data
02-Aug-2024 07:00:11 pm
before elastic get data
02-Aug-2024 07:00:11 pm
after elastic get data
02-Aug-2024 07:00:11 pm
SELECT * FROM `contacts_temp_group_25635` where group_id in(25635) group by mobile_number order by contact_id LIMIT 0,38
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9840724443', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9267973131', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9539066522', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','7732044799', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8095158819', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9673552782', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','6380144861', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9604063754', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8910639383', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8928881747', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9752015503', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8291150789', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','7698986520', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9958452413', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','7980273025', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9972029928', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9059097229', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8825755698', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','6207616766', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9915599830', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','7009270949', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9969889825', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9014932720', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9825945704', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','7987597759', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9828765433', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8544890744', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8956788910', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','7045322646', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9842559415', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9810621055', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8850996319', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9840499424', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8658492010', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','9986738179', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8006127096', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8146919659', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
INSERT INTO `voice_compaign_detail_26307` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26307','8310016610', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
02-Aug-2024 07:00:11 pm
after INSERT DETAIL
02-Aug-2024 07:00:11 pm
before UPDATE SUMMARY
02-Aug-2024 07:00:11 pm
after before UPDATE SUMMARY
02-Aug-2024 07:00: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.12352108955383
blacklist in micro sec 0.02167820930481