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


 before elastic get data 

13-Aug-2024 04:30:08 pm

 after elastic get data 

13-Aug-2024 04:30:08 pm

 before elastic new get data 

13-Aug-2024 04:30:08 pmbelow is user whitelist data 

 <pre/>Array
(
)


 after elastic new get data 


 after elastic get data 

13-Aug-2024 04:30:09 pmCutting Percentage = 45

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

alloted api array 

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

)
gateway_id_arrs 

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


 before elastic get data 

13-Aug-2024 04:30:09 pm

 after elastic get data 

13-Aug-2024 04:30:09 pm

 before elastic get data 

13-Aug-2024 04:30:09 pm

 after elastic get data 

13-Aug-2024 04:30:09 pm

 before elastic get data 

13-Aug-2024 04:30:09 pm

 after elastic get data 

13-Aug-2024 04:30:09 pm<br>SELECT * FROM `contacts_temp_group_26521` where group_id in(26521)  group by mobile_number order by contact_id  LIMIT 0,52  

<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9047024441', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8190073745', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9585826491', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','6380908613', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9445751429', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8148508514', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8489693821', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8489682915', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9677511788', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9787978272', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9789306676', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9940508146', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9566241301', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9751612618', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8668131185', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9487935547', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8883992954', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9159225109', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9842779152', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8489833597', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9976498550', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9677824943', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9500816621', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8940096306', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9514423389', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8072832348', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9047315057', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9655012819', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9443503128', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9597259789', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9789681393', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8122472387', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9025156011', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','7708168068', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8015610885', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9489810657', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9159268629', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9655765114', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9003743747', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9894869288', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9943251391', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8610305516', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9786845596', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','8098663010', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9790442542', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9626097104', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9790520709', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','7418199443', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','6381707616', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9787791337', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','6369910801', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm<br>INSERT INTO `voice_compaign_detail_27224` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('27224','9865259413', 'p', '127', '0', '','','','', '')


 before  INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 after INSERT DETAIL 

13-Aug-2024 04:30:09 pm

 before UPDATE SUMMARY 

13-Aug-2024 04:30:09 pm

 after before UPDATE SUMMARY  

13-Aug-2024 04:30:09 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 1 

 whitelist get data mic sec 0.24402403831482 

 blacklist in micro sec 0.031811237335205