SELECT * FROM voice_compaign_summary WHERE compaign_id='27545' LIMIT 1
before elastic get data
16-Aug-2024 04:30:08 pm
after elastic get data
16-Aug-2024 04:30:08 pm
before elastic new get data
16-Aug-2024 04:30:08 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
16-Aug-2024 04:30:08 pmCutting Percentage = 45
1 alloted_apis_json--[{"cli":7313658832,"g_id":127}]
alloted api array
Array
(
[0] => Array
(
[cli] => 7313658832
[g_id] => 127
)
)
gateway_id_arrs
Array
(
[0] => 127
)
before elastic get data
16-Aug-2024 04:30:08 pm
after elastic get data
16-Aug-2024 04:30:08 pm
before elastic get data
16-Aug-2024 04:30:08 pm
after elastic get data
16-Aug-2024 04:30:08 pm
before elastic get data
16-Aug-2024 04:30:08 pm
after elastic get data
16-Aug-2024 04:30:08 pm
SELECT * FROM `contacts_temp_group_26822` where group_id in(26822) group by mobile_number order by contact_id LIMIT 0,54
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9585858563', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','6384161349', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9715906843', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9688181581', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8122671256', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9787506012', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9159073777', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9751613302', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9751612618', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9894285507', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9843216434', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9047024441', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9190073745', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9585826491', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','6380908613', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9445751429', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8148508514', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8489693821', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9677511788', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9787978272', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9500749809', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9940508146', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9566241301', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9626320991', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9944177889', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8524853966', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9487935547', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9943399434', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8682910032', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9442048831', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8098584717', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9677408656', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9842779152', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8489833597', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9976498550', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9786096712', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9500816621', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9788181546', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9514423389', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9751459709', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8072832348', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9047315057', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9655012819', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9597259789', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9789681393', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8122472387', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','8015610885', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9489810657', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','7200993529', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9159268629', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9655765114', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9003743747', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9894869288', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_27545` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27545','9943251391', 'p', '127', '0', '','','','', '')
before INSERT DETAIL
16-Aug-2024 04:30:08 pm
after INSERT DETAIL
16-Aug-2024 04:30:09 pm
before UPDATE SUMMARY
16-Aug-2024 04:30:09 pm
after before UPDATE SUMMARY
16-Aug-2024 04:30:09 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.098424911499023
blacklist in micro sec 0.029943466186523