SELECT * FROM voice_compaign_summary WHERE compaign_id='39146' LIMIT 1
before elastic get data 19-May-2025 01:38:03 pm after elastic get data 19-May-2025 01:38:03 pm before elastic new get data 19-May-2025 01:38:03 pmloop : 0

total records 48
process records 48below is user whitelist data
Array
(
    [9951312313] => 9951312313
    [7702391102] => 7702391102
    [7708039590] => 7708039590
    [8885556885] => 8885556885
    [9492238468] => 9492238468
    [9989282549] => 9989282549
    [9640208398] => 9640208398
    [8008508269] => 8008508269
    [9247756816] => 9247756816
    [9441596089] => 9441596089
    [9849643641] => 9849643641
    [9390662224] => 9390662224
    [9490260361] => 9490260361
    [8688689322] => 8688689322
    [9550234204] => 9550234204
    [9966216316] => 9966216316
    [9030594948] => 9030594948
    [9949717217] => 9949717217
    [9618422584] => 9618422584
    [8106790688] => 8106790688
    [6300707280] => 6300707280
    [9701531186] => 9701531186
    [9290003487] => 9290003487
    [9491905992] => 9491905992
    [9553892040] => 9553892040
    [9295757262] => 9295757262
    [9866306890] => 9866306890
    [9885765506] => 9885765506
    [7396026889] => 7396026889
    [9701745249] => 9701745249
    [9908397811] => 9908397811
    [9291259355] => 9291259355
    [8247522161] => 8247522161
    [9849699962] => 9849699962
    [7893484375] => 7893484375
    [9491495572] => 9491495572
    [8019208359] => 8019208359
    [9985481860] => 9985481860
    [9603469494] => 9603469494
    [8008325078] => 8008325078
    [8008528297] => 8008528297
    [9505968732] => 9505968732
    [9505833520] => 9505833520
    [8886144457] => 8886144457
    [8309602443] => 8309602443
    [8800260337] => 8800260337
    [7562800337] => 7562800337
    [9289933499] => 9289933499
)


 after elastic new get data 


 after elastic get data 

19-May-2025 01:38:03 pmCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 Array
(
    [0] => 184
)


 before elastic get data 

19-May-2025 01:38:03 pm

 after elastic get data 

19-May-2025 01:38:03 pm

 before elastic get data 

19-May-2025 01:38:03 pm

 after elastic get data 

19-May-2025 01:38:03 pm

 before elastic get data 

19-May-2025 01:38:03 pm

 after elastic get data 

19-May-2025 01:38:03 pm
SELECT * FROM `contacts_temp_group_36327` where group_id in(36327)  group by mobile_number order by contact_id  LIMIT 0,2  

 

 DND FILTERING YES  

 MOBILE NO IS WHITELIST YES 
INSERT INTO `voice_compaign_detail_39146` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39146','7562800337', 'p', '184', '1', '','','','', '')


 before  INSERT DETAIL 

19-May-2025 01:38:03 pm

 after INSERT DETAIL 

19-May-2025 01:38:03 pm 

 MOBILE NO IS WHITELIST YES 
INSERT INTO `voice_compaign_detail_39146` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39146','9289933499', 'p', '184', '1', '','','','', '')


 before  INSERT DETAIL 

19-May-2025 01:38:03 pm

 after INSERT DETAIL 

19-May-2025 01:38:03 pm

 before UPDATE SUMMARY 

19-May-2025 01:38:03 pm

 after before UPDATE SUMMARY  

19-May-2025 01:38:03 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 0 

 blacklis in sec 0 

 whitelist get data sec 0 

 whitelist get data mic sec 0.097935914993286 

 blacklist in micro sec 0.0012383460998535