SELECT * FROM voice_compaign_summary WHERE compaign_id='24254' LIMIT 1
before elastic get data 15-Jul-2024 09:28:48 am after elastic get data 15-Jul-2024 09:28:48 am before elastic new get data 15-Jul-2024 09:28:48 ambelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

15-Jul-2024 09:28:48 amCutting Percentage = 0

1 alloted_apis_json--[{"cli":7313658803,"g_id":129}]

alloted api array 

 
Array
(
    [0] => Array
        (
            [cli] => 7313658803
            [g_id] => 129
        )

)
gateway_id_arrs 

 
Array
(
    [0] => 129
)


 before elastic get data 

15-Jul-2024 09:28:48 am

 after elastic get data 

15-Jul-2024 09:28:48 am

 before elastic get data 

15-Jul-2024 09:28:48 am

 after elastic get data 

15-Jul-2024 09:28:48 am

 before elastic get data 

15-Jul-2024 09:28:48 am

 after elastic get data 

15-Jul-2024 09:28:48 am
SELECT * FROM `contacts_temp_group_23713` where group_id in(23713)  group by mobile_number order by contact_id  LIMIT 0,34  


INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','7057661950', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','7499496797', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','7588004044', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','7620266150', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','7666440690', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','7756945295', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','7875667978', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','8411086443', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','8453616161', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','8483998519', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','8793500531', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','8805558125', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','8806255356', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9075567760', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9096697164', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9130108297', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9130161748', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9350832339', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9359147373', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9421413799', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9623260616', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9657391671', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9657555632', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9657557203', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9665017861', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9673114939', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9689442820', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9763781585', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9764464243', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9766513003', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9807981111', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9822619922', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9834782275', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am
INSERT INTO `voice_compaign_detail_24254` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('24254','9850337777', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

15-Jul-2024 09:28:48 am

 after INSERT DETAIL 

15-Jul-2024 09:28:48 am

 before UPDATE SUMMARY 

15-Jul-2024 09:28:48 am

 after before UPDATE SUMMARY  

15-Jul-2024 09:28:48 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  

 blacklis in sec 0 

 whitelist get data sec 0 

 whitelist get data mic sec 0.023990154266357 

 blacklist in micro sec 0.019751071929932