SELECT * FROM voice_compaign_summary WHERE compaign_id='18669' LIMIT 1
before elastic get data 25-May-2024 07:07:11 am after elastic get data 25-May-2024 07:07:11 am before elastic new get data 25-May-2024 07:07:11 ambelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

25-May-2024 07:07:11 amCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 48
)


 before elastic get data 

25-May-2024 07:07:11 am

 after elastic get data 

25-May-2024 07:07:11 am

 before elastic get data 

25-May-2024 07:07:11 am

 after elastic get data 

25-May-2024 07:07:11 am

 before elastic get data 

25-May-2024 07:07:11 am

 after elastic get data 

25-May-2024 07:07:11 am
SELECT * FROM `contacts_temp_group_18249` where group_id in(18249)  group by mobile_number order by contact_id  LIMIT 0,25  


INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','8800218812', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9999812819', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9999993843', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9811452953', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','8178983382', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9910096424', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9990545786', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9818022044', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','7217609060', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','8588815543', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9971964026', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','7018404454', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9873763695', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9818568913', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','8384011174', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9891137567', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','7830095216', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','8800683838', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9899552777', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9713856078', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9953434405', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9414281402', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','8860292370', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9650782789', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am
INSERT INTO `voice_compaign_detail_18669` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18669','9811469452', 'p', '48', '0', '','','','', '')


 before  INSERT DETAIL 

25-May-2024 07:07:11 am

 after INSERT DETAIL 

25-May-2024 07:07:11 am

 before UPDATE SUMMARY 

25-May-2024 07:07:11 am

 after before UPDATE SUMMARY  

25-May-2024 07:07:11 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.064515113830566 

 blacklist in micro sec 0.0098917484283447