SELECT * FROM voice_compaign_summary WHERE compaign_id='50645' LIMIT 1
before elastic get data 08-Aug-2025 08:37:16 pm after elastic get data 08-Aug-2025 08:37:16 pm before elastic new get data 08-Aug-2025 08:37:16 pmbelow is user whitelist data
Array
(
)


 after elastic new get data 


 after elastic get data 

08-Aug-2025 08:37:16 pm alloted_apis_json--[{"cli":"","g_id":"31"}]

alloted api array 

 
Array
(
    [0] => Array
        (
            [cli] => 
            [g_id] => 31
        )

)
gateway_id_arrs 

 
Array
(
    [0] => 31
)


 before elastic get data 

08-Aug-2025 08:37:16 pm

 after elastic get data 

08-Aug-2025 08:37:16 pm

 before elastic get data 

08-Aug-2025 08:37:16 pm

 after elastic get data 

08-Aug-2025 08:37:16 pm

 before elastic get data 

08-Aug-2025 08:37:16 pm

 after elastic get data 

08-Aug-2025 08:37:16 pm
SELECT * FROM `contacts_temp_group_49550` where group_id in(49550) group by mobile_number order by contact_id LIMIT 0,37 compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new compaign id not set new DND FILTERING YES {"query":{"bool":{"must":[{"terms":{"Mobile":[7970325855,7004658536,6206142717,7903372623,8298903636,7992258532,7549226898,9708606036,7389204335,8521878921,9508519230,8235658126,7004358536,8877706179,9835924634,9570729281,9631890229,8210115981,9955066671,9155066671,9471341866,9570238043,6201953826,7903256825,9905603226,8709701808,6203630948,8298318041,6207532550,9534651174,7903376587,9097309790,7549931137,7727936710,8210561257,9570778867,9905640009]}}]}}} mobile no is dnd9570729281 mobile no is dnd9905603226 mobile no is dnd9708606036 mobile no is dnd8298903636 mobile no is dnd8298318041 mobile no is dnd7389204335 mobile no is dnd7549226898 mobile no is dnd7004358536 before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7970325855', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7004658536', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','6206142717', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7903372623', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8298903636', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7992258532', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7549226898', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9708606036', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7389204335', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8521878921', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9508519230', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8235658126', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7004358536', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8877706179', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9835924634', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9570729281', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9631890229', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8210115981', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9955066671', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9155066671', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9471341866', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9570238043', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','6201953826', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7903256825', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9905603226', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8709701808', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','6203630948', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8298318041', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','6207532550', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9534651174', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7903376587', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9097309790', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7549931137', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','7727936710', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','8210561257', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9570778867', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm after BLACKLIST_CONTASTS 08-Aug-2025 08:37:17 pm
INSERT INTO `voice_compaign_detail_50645` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50645','9905640009', 'p', '31', '0', '','','','', '') before INSERT DETAIL 08-Aug-2025 08:37:17 pm after INSERT DETAIL 08-Aug-2025 08:37:17 pm before UPDATE SUMMARY 08-Aug-2025 08:37:17 pm after before UPDATE SUMMARY 08-Aug-2025 08:37:17 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 3.814697265625E-5 blacklist in micro sec 0.016195774078369