SELECT * FROM voice_compaign_summary WHERE compaign_id='39889' LIMIT 1
before elastic get data
03-Jun-2025 02:36:05 pm
after elastic get data
03-Jun-2025 02:36:05 pm
before elastic new get data
03-Jun-2025 02:36:05 pmloop : 0
total records 14
process records 14below is user whitelist data
Array
(
[7014036497] => 7014036497
[9509858287] => 9509858287
[9643574492] => 9643574492
[9205959919] => 9205959919
[9690917800] => 9690917800
[7974149349] => 7974149349
[8821010002] => 8821010002
[9826807474] => 9826807474
[8305534396] => 8305534396
[9589989692] => 9589989692
[9893278228] => 9893278228
[9131621704] => 9131621704
[9479951376] => 9479951376
[7974295690] => 7974295690
)
after elastic new get data
after elastic get data
03-Jun-2025 02:36:06 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"185"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 185
)
)
gateway_id_arrs
Array
(
[0] => 185
)
before elastic get data
03-Jun-2025 02:36:06 pm
after elastic get data
03-Jun-2025 02:36:06 pm
before elastic get data
03-Jun-2025 02:36:06 pm
after elastic get data
03-Jun-2025 02:36:06 pm
before elastic get data
03-Jun-2025 02:36:06 pm
after elastic get data
03-Jun-2025 02:36:06 pm
SELECT * FROM `contacts_temp_group_36858` where group_id in(36858) group by mobile_number order by contact_id LIMIT 0,9
DND FILTERING YES
mobile no is dnd9826807474
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','9589989692', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','7974149349', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','9893278228', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','8821010002', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','9479951376', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','9826807474', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','7974295690', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','8305534396', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39889` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39889','9131621704', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
03-Jun-2025 02:36:06 pm
after INSERT DETAIL
03-Jun-2025 02:36:06 pm
before UPDATE SUMMARY
03-Jun-2025 02:36:06 pm
after before UPDATE SUMMARY
03-Jun-2025 02:36: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 0
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.84543490409851
blacklist in micro sec 0.0045363903045654