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


 after elastic new get data 


 after elastic get data 

18-Oct-2024 11:00:07 amCutting Percentage = 0

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

alloted api array 

 
Array
(
    [0] => Array
        (
            [cli] => 7447141132
            [g_id] => 145
        )

)
gateway_id_arrs 

 
Array
(
    [0] => 145
)


 before elastic get data 

18-Oct-2024 11:00:07 am

 after elastic get data 

18-Oct-2024 11:00:07 am

 before elastic get data 

18-Oct-2024 11:00:07 am

 after elastic get data 

18-Oct-2024 11:00:07 am

 before elastic get data 

18-Oct-2024 11:00:07 am

 after elastic get data 

18-Oct-2024 11:00:07 am
SELECT * FROM `contacts_temp_group_29951` where group_id in(29951)  group by mobile_number order by contact_id  LIMIT 0,45  

 

 DND FILTERING YES 
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9444609395', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9443883885', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9442048804', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9486666555', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9894963377', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9566568207', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9894424316', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9789500101', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9443503304', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9443650555', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9789211895', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','8220101048', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9894139219', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9976253636', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9994727618', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9486212144', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9677336678', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9750105514', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9345969255', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9698302696', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9842517473', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9750223216', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9655238828', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9585413902', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9345820757', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9524518530', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9786329444', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','8098584717', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','8939371880', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9487935547', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9787327201', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9486483619', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9486339479', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9443005426', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9150123488', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9487148895', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9750428403', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9994607362', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9842177222', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','8940107626', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9443977552', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','8056835520', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9884477754', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9597360029', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am
INSERT INTO `voice_compaign_detail_31081` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31081','9443405633', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

18-Oct-2024 11:00:08 am

 after INSERT DETAIL 

18-Oct-2024 11:00:08 am

 before UPDATE SUMMARY 

18-Oct-2024 11:00:08 am

 after before UPDATE SUMMARY  

18-Oct-2024 11:00: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 0.036926984786987 

 blacklist in micro sec 0.027086973190308