SELECT * FROM voice_compaign_summary WHERE compaign_id='50879' LIMIT 1
before elastic get data 10-Aug-2025 10:45:08 am after elastic get data 10-Aug-2025 10:45:08 am before elastic new get data 10-Aug-2025 10:45:08 ambelow is user whitelist data
Array
(
)


 after elastic new get data 


 after elastic get data 

10-Aug-2025 10:45:08 am 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 

10-Aug-2025 10:45:08 am

 after elastic get data 

10-Aug-2025 10:45:08 am

 before elastic get data 

10-Aug-2025 10:45:08 am

 after elastic get data 

10-Aug-2025 10:45:08 am

 before elastic get data 

10-Aug-2025 10:45:08 am

 after elastic get data 

10-Aug-2025 10:45:08 am
SELECT * FROM `contacts_temp_group_49646` where group_id in(49646) 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":[7976588016,9461635373,8003858654,9434252685,7568315000,8426089125,9251089357,7297872613,9413086204,7726963199,7222877727,9928867878,7240694374,9950344469,8769171975,8440934887,8769235679,7724851056,9460962996,8502052447,9782635952,8420601654,9785989877,8769079397,9928724546,9887569305,7792971016,9983023875,9718972676,9001149125,8824041685,9785276786,9887767251,9468884066,9571134715,9782431275,7014391429]}}]}}} mobile no is dnd9887569305 mobile no is dnd9434252685 mobile no is dnd9950344469 mobile no is dnd8426089125 mobile no is dnd9928867878 mobile no is dnd9785276786 mobile no is dnd7240694374 mobile no is dnd9983023875 mobile no is dnd8502052447 mobile no is dnd9782635952 mobile no is dnd8440934887 mobile no is dnd9785989877 mobile no is dnd7726963199 mobile no is dnd8769171975 before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7976588016', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9461635373', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8003858654', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9434252685', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7568315000', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8426089125', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9251089357', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7297872613', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9413086204', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7726963199', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7222877727', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9928867878', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7240694374', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9950344469', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8769171975', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8440934887', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8769235679', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7724851056', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9460962996', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8502052447', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9782635952', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8420601654', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9785989877', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8769079397', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9928724546', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9887569305', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7792971016', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9983023875', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9718972676', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9001149125', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','8824041685', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9785276786', 'p', '-3', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9887767251', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9468884066', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9571134715', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','9782431275', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am after BLACKLIST_CONTASTS 10-Aug-2025 10:45:08 am
INSERT INTO `voice_compaign_detail_50879` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('50879','7014391429', 'p', '31', '0', '','','','', '') before INSERT DETAIL 10-Aug-2025 10:45:08 am after INSERT DETAIL 10-Aug-2025 10:45:08 am before UPDATE SUMMARY 10-Aug-2025 10:45:08 am after before UPDATE SUMMARY 10-Aug-2025 10:45:08 am 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 2.4080276489258E-5 blacklist in micro sec 0.025716781616211