SELECT * FROM voice_compaign_summary WHERE compaign_id='31531' LIMIT 1
before elastic get data
25-Oct-2024 03:45:08 pm
after elastic get data
25-Oct-2024 03:45:08 pm
before elastic new get data
25-Oct-2024 03:45:08 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
25-Oct-2024 03:45:09 pmCutting 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 03:45:09 pm
after elastic get data
25-Oct-2024 03:45:09 pm
before elastic get data
25-Oct-2024 03:45:09 pm
after elastic get data
25-Oct-2024 03:45:09 pm
before elastic get data
25-Oct-2024 03:45:09 pm
after elastic get data
25-Oct-2024 03:45:09 pm
SELECT * FROM `contacts_temp_group_30317` where group_id in(30317) group by mobile_number order by contact_id LIMIT 0,30
DND FILTERING YES
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8929544444', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','7908884946', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8238257115', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','7004506960', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9580901288', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','6398556701', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8546067621', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9500296156', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','7738803118', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8145155976', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','7070520067', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9356075565', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','7007119582', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9650036406', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9370787969', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9674398893', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','7984264274', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9113713211', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8709708941', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8401557591', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8160256052', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9746426887', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8638852400', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9779140919', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8309609750', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','9444640129', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8197841907', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8789176146', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8073070615', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
INSERT INTO `voice_compaign_detail_31531` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31531','8660701889', 'p', '135', '0', '','','','', '')
before INSERT DETAIL
25-Oct-2024 03:45:09 pm
after INSERT DETAIL
25-Oct-2024 03:45:09 pm
before UPDATE SUMMARY
25-Oct-2024 03:45:09 pm
after before UPDATE SUMMARY
25-Oct-2024 03:45: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 0
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.04460883140564
blacklist in micro sec 0.017250299453735