SELECT * FROM voice_compaign_summary WHERE compaign_id='29623' LIMIT 1
before elastic get data
27-Sep-2024 01:52:11 pm
after elastic get data
27-Sep-2024 01:52:11 pm
before elastic new get data
27-Sep-2024 01:52:11 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
27-Sep-2024 01:52:12 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"132"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 132
)
)
gateway_id_arrs
Array
(
[0] => 132
)
before elastic get data
27-Sep-2024 01:52:12 pm
after elastic get data
27-Sep-2024 01:52:12 pm
before elastic get data
27-Sep-2024 01:52:12 pm
after elastic get data
27-Sep-2024 01:52:12 pm
before elastic get data
27-Sep-2024 01:52:12 pm
after elastic get data
27-Sep-2024 01:52:12 pm
SELECT * FROM `contacts_temp_group_28720` where group_id in(28720) group by mobile_number order by contact_id LIMIT 0,33
DND FILTERING YES
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9158301496', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9075635556', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9309270792', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9766108519', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9673879563', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7083624277', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9767653625', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9822097919', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8600243420', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8999016059', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9637375830', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9689316855', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7057265729', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9579923030', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8975994308', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7040145333', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9921652135', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7822877470', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7057240206', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9673616866', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9767149019', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7262034602', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8766672364', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8805181958', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8799821410', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9322320776', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9623523844', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8796080672', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7972352324', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','7483583707', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9322350500', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','8698987086', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
INSERT INTO `voice_compaign_detail_29623` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29623','9764347492', 'p', '132', '0', '','','','', '')
before INSERT DETAIL
27-Sep-2024 01:52:12 pm
after INSERT DETAIL
27-Sep-2024 01:52:12 pm
before UPDATE SUMMARY
27-Sep-2024 01:52:12 pm
after before UPDATE SUMMARY
27-Sep-2024 01:52:12 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 -106098983862
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.046063899993896
blacklist in micro sec 0.019819974899292