SELECT * FROM voice_compaign_summary WHERE compaign_id='26140' LIMIT 1  <br>


 before elastic get data 

01-Aug-2024 05:00:11 pm

 after elastic get data 

01-Aug-2024 05:00:11 pm

 before elastic new get data 

01-Aug-2024 05:00:11 pmbelow is user whitelist data 

 <pre/>Array
(
)


 after elastic new get data 


 after elastic get data 

01-Aug-2024 05:00:11 pmCutting Percentage = 0

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

alloted api array 

 <pre/>Array
(
    [0] => Array
        (
            [cli] => 7313658832
            [g_id] => 128
        )

)
gateway_id_arrs 

 <pre/>Array
(
    [0] => 128
)


 before elastic get data 

01-Aug-2024 05:00:11 pm

 after elastic get data 

01-Aug-2024 05:00:11 pm

 before elastic get data 

01-Aug-2024 05:00:11 pm

 after elastic get data 

01-Aug-2024 05:00:11 pm

 before elastic get data 

01-Aug-2024 05:00:11 pm

 after elastic get data 

01-Aug-2024 05:00:11 pm<br>SELECT * FROM `contacts_temp_group_25458` where group_id in(25458)  group by mobile_number order by contact_id  LIMIT 0,45  

<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9626237773', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9962794001', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9677593475', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9663325070', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9943767934', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9868932491', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8489873310', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9047224634', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9488151515', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8525065388', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9487935547', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9842779152', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9176266104', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9942951333', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9442045158', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9500816621', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9788181546', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9361058191', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9514423389', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9486211259', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9087342319', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8525005446', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','6369377304', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9047315057', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9443503128', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9597259789', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9789681393', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','7550131713', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8122472387', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9025156011', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8015610885', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9489810657', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','7200993529', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9003743747', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9943251391', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8610305516', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9786845596', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8098663010', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9626097104', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9790520709', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','7418199443', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','6381707616', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','9787791337', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','6369910801', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm<br>INSERT INTO `voice_compaign_detail_26140` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('26140','8428267028', 'p', '128', '0', '','','','', '')


 before  INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 after INSERT DETAIL 

01-Aug-2024 05:00:11 pm

 before UPDATE SUMMARY 

01-Aug-2024 05:00:11 pm

 after before UPDATE SUMMARY  

01-Aug-2024 05:00:11 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  

 blacklis in sec 0 

 whitelist get data sec 0 

 whitelist get data mic sec 0.046449899673462 

 blacklist in micro sec 0.02350640296936