SELECT * FROM voice_compaign_summary WHERE compaign_id='31509' LIMIT 1
before elastic get data
25-Oct-2024 11:05:04 am
after elastic get data
25-Oct-2024 11:05:04 am
before elastic new get data
25-Oct-2024 11:05:04 ambelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
25-Oct-2024 11:05:05 amCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"135"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 135
)
)
gateway_id_arrs
Array
(
[0] => 135
)
before elastic get data
25-Oct-2024 11:05:05 am
after elastic get data
25-Oct-2024 11:05:05 am
before elastic get data
25-Oct-2024 11:05:05 am
after elastic get data
25-Oct-2024 11:05:05 am
before elastic get data
25-Oct-2024 11:05:05 am
after elastic get data
25-Oct-2024 11:05:05 am
SELECT * FROM `contacts_temp_group_30301` where group_id in(30301) group by mobile_number order by contact_id LIMIT 0,25
DND FILTERING YES
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8929544444', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','7908884946', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8238257115', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','7004506960', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9580901288', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','6398556701', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8546067621', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9500296156', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','7738803118', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8145155976', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','7070520067', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9356075565', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','7007119582', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9650036406', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9370787969', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9674398893', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','7984264274', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9113713211', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8709708941', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8401557591', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8160256052', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9746426887', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8638852400', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','9779140919', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
INSERT INTO `voice_compaign_detail_31509` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31509','8309609750', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 11:05:05 am
after INSERT DETAIL
25-Oct-2024 11:05:05 am
before UPDATE SUMMARY
25-Oct-2024 11:05:05 am
after before UPDATE SUMMARY
25-Oct-2024 11:05:05 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 0
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.020637989044189
blacklist in micro sec 0.013768911361694