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


 before elastic get data 

06-May-2025 10:08:43 am

 after elastic get data 

06-May-2025 10:08:43 am

 before elastic new get data 

06-May-2025 10:08:43 amloop : 0 <br> <br> total records 25<br>  process records 25below is user whitelist data 

 <pre/>Array
(
    [9716000400] => 9716000400
    [9868118925] => 9868118925
    [9913398822] => 9913398822
    [9959788999] => 9959788999
    [9871339125] => 9871339125
    [9212676766] => 9212676766
    [9899183283] => 9899183283
    [8406077015] => 8406077015
    [8460770154] => 8460770154
    [9662825689] => 9662825689
    [9426827577] => 9426827577
    [9712111110] => 9712111110
    [7600291429] => 7600291429
    [7878295500] => 7878295500
    [8421882545] => 8421882545
    [9730825467] => 9730825467
    [7408830689] => 7408830689
    [8652409335] => 8652409335
    [9954381856] => 9954381856
    [9819760752] => 9819760752
    [7020796408] => 7020796408
    [8975407987] => 8975407987
    [9650150863] => 9650150863
    [9987530698] => 9987530698
    [9825143667] => 9825143667
)


 after elastic new get data 


 after elastic get data 

06-May-2025 10:08:44 amCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

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


 before elastic get data 

06-May-2025 10:08:44 am

 after elastic get data 

06-May-2025 10:08:44 am

 before elastic get data 

06-May-2025 10:08:44 am

 after elastic get data 

06-May-2025 10:08:44 am

 before elastic get data 

06-May-2025 10:08:44 am

 after elastic get data 

06-May-2025 10:08:44 am<br>SELECT * FROM `contacts_temp_group_35811` where group_id in(35811)  group by mobile_number order by contact_id  LIMIT 0,1  

 

 DND FILTERING YES  

 MOBILE NO IS WHITELIST YES <br>INSERT INTO `voice_compaign_detail_38486` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38486','9825143667', 'p', '184', '1', '','','','', '')


 before  INSERT DETAIL 

06-May-2025 10:08:44 am

 after INSERT DETAIL 

06-May-2025 10:08:44 am

 before UPDATE SUMMARY 

06-May-2025 10:08:44 am

 after before UPDATE SUMMARY  

06-May-2025 10:08:44 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 -77897289600 

 blacklis in sec 0 

 whitelist get data sec 1 

 whitelist get data mic sec 0.81354212760925 

 blacklist in micro sec 0.00076413154602051