SELECT * FROM voice_compaign_summary WHERE compaign_id='30198' LIMIT 1
before elastic get data
05-Oct-2024 05:00:08 pm
after elastic get data
05-Oct-2024 05:00:08 pm
before elastic new get data
05-Oct-2024 05:00:08 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
05-Oct-2024 05:00:08 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"79"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 79
)
)
gateway_id_arrs
Array
(
[0] => 79
)
before elastic get data
05-Oct-2024 05:00:08 pm
after elastic get data
05-Oct-2024 05:00:08 pm
before elastic get data
05-Oct-2024 05:00:08 pm
after elastic get data
05-Oct-2024 05:00:08 pm
before elastic get data
05-Oct-2024 05:00:08 pm
after elastic get data
05-Oct-2024 05:00:08 pm
SELECT * FROM `contacts_temp_group_29231` where group_id in(29231) group by mobile_number order by contact_id LIMIT 0,29
DND FILTERING YES
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9444364006', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442651313', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9361786897', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9843806320', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7708802156', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9443466769', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9790438850', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9487036307', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442960795', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9787887333', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9843425277', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','8760493770', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442970406', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9655494571', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442556171', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9789500101', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','8903009092', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7639537908', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9843384338', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9865640026', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9443328976', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9486651731', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7868932491', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','8300016904', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9597935939', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9444038915', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7598854425', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9443467463', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9486117552', 'p', '79', '0', '','','','', '')
before INSERT DETAIL
05-Oct-2024 05:00:09 pm
after INSERT DETAIL
05-Oct-2024 05:00:09 pm
before UPDATE SUMMARY
05-Oct-2024 05:00:09 pm
after before UPDATE SUMMARY
05-Oct-2024 05:00: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 0
whitelist get data mic sec 0.051892995834351
blacklist in micro sec 0.015990972518921