SELECT * FROM voice_compaign_summary WHERE compaign_id='26426' LIMIT 1
before elastic get data
04-Aug-2024 11:07:11 am
after elastic get data
04-Aug-2024 11:07:11 am
before elastic new get data
04-Aug-2024 11:07:11 ambelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
04-Aug-2024 11:07:11 amCutting Percentage = 0
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
04-Aug-2024 11:07:11 am
after elastic get data
04-Aug-2024 11:07:12 am
before elastic get data
04-Aug-2024 11:07:12 am
after elastic get data
04-Aug-2024 11:07:12 am
before elastic get data
04-Aug-2024 11:07:12 am
after elastic get data
04-Aug-2024 11:07:12 am
SELECT * FROM `contacts_temp_group_25756` where group_id in(25756) group by mobile_number order by contact_id LIMIT 0,50
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9810068061', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9146535848', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8308607423', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9901580767', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8451928056', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8329652078', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9168519676', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9881217667', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9819725873', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8826726448', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9323396333', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9080933105', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','7889447415', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9782379922', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9680888290', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','7903850984', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8076684970', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9987834252', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8157864246', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9167692110', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9811517099', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9810662139', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9833038733', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9989357380', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9066200002', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9421157687', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','6374098077', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9131943739', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9725289396', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9654962019', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8899410783', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','7317319232', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8369695158', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8239459558', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','8826823584', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','6395032546', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','7510817657', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','7573833131', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','7888297932', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9399731622', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9428956893', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9582223691', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9677256864', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9755356708', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9826284132', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9911369866', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9980531838', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9996050109', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9440842871', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
INSERT INTO `voice_compaign_detail_26426` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26426','9052060412', 'p', '54', '0', '','','','', '')
before INSERT DETAIL
04-Aug-2024 11:07:12 am
after INSERT DETAIL
04-Aug-2024 11:07:12 am
before UPDATE SUMMARY
04-Aug-2024 11:07:12 am
after before UPDATE SUMMARY
04-Aug-2024 11:07:12 am
contact in sec 0
sepration in sec 1
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.036961793899536
blacklist in micro sec 0.027826547622681