SELECT * FROM voice_compaign_summary WHERE compaign_id='39699' LIMIT 1
before elastic get data
30-May-2025 05:39:05 pm
after elastic get data
30-May-2025 05:39:05 pm
before elastic new get data
30-May-2025 05:39:05 pmloop : 0
total records 14
process records 14below is user whitelist data
Array
(
[9376498182] => 9376498182
[9081754474] => 9081754474
[9136402721] => 9136402721
[8849583687] => 8849583687
[9081954474] => 9081954474
[9560867556] => 9560867556
[9819299380] => 9819299380
[9819991338] => 9819991338
[9987583930] => 9987583930
[9867035124] => 9867035124
[7208865591] => 7208865591
[9619959747] => 9619959747
[8879763570] => 8879763570
[9004270393] => 9004270393
)
after elastic new get data
after elastic get data
30-May-2025 05:39:06 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"140"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 140
)
)
gateway_id_arrs
Array
(
[0] => 140
)
before elastic get data
30-May-2025 05:39:06 pm
after elastic get data
30-May-2025 05:39:06 pm
before elastic get data
30-May-2025 05:39:06 pm
after elastic get data
30-May-2025 05:39:06 pm
before elastic get data
30-May-2025 05:39:06 pm
after elastic get data
30-May-2025 05:39:06 pm
SELECT * FROM `contacts_temp_group_36744` where group_id in(36744) group by mobile_number order by contact_id LIMIT 0,9
DND FILTERING YES
mobile no is dnd9819299380
mobile no is dnd9867035124
mobile no is dnd9004270393
mobile no is dnd8879763570
mobile no is dnd9560867556
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','9560867556', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','9619959747', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','9987583930', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','8879763570', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','9819299380', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','9867035124', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','9819991338', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','9004270393', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39699` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39699','7208865591', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
30-May-2025 05:39:06 pm
after INSERT DETAIL
30-May-2025 05:39:06 pm
before UPDATE SUMMARY
30-May-2025 05:39:06 pm
after before UPDATE SUMMARY
30-May-2025 05:39:06 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 34081516800
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.68835115432739
blacklist in micro sec 0.005347728729248