SELECT * FROM voice_compaign_summary WHERE compaign_id='27131' LIMIT 1
before elastic get data
12-Aug-2024 02:27:43 pm
after elastic get data
12-Aug-2024 02:27:43 pm
before elastic new get data
12-Aug-2024 02:27:43 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
12-Aug-2024 02:27:43 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
12-Aug-2024 02:27:43 pm
after elastic get data
12-Aug-2024 02:27:43 pm
before elastic get data
12-Aug-2024 02:27:43 pm
after elastic get data
12-Aug-2024 02:27:43 pm
before elastic get data
12-Aug-2024 02:27:43 pm
after elastic get data
12-Aug-2024 02:27:43 pm
SELECT * FROM `contacts_temp_group_26439` where group_id in(26439) group by mobile_number order by contact_id LIMIT 0,18
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9810334423', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9654386107', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','8882127948', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9711349224', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9971692537', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9899029605', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9999921443', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9138988172', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9810030541', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9811662999', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9811066950', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','8969845756', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9871154071', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9716009667', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9540393273', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','8447475804', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9910096424', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
INSERT INTO `voice_compaign_detail_27131` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27131','9990545786', 'p', '53', '0', '','','','', '')
before INSERT DETAIL
12-Aug-2024 02:27:43 pm
after INSERT DETAIL
12-Aug-2024 02:27:43 pm
before UPDATE SUMMARY
12-Aug-2024 02:27:43 pm
after before UPDATE SUMMARY
12-Aug-2024 02:27:43 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.020214796066284
blacklist in micro sec 0.0096030235290527