SELECT * FROM voice_compaign_summary WHERE compaign_id='39158' LIMIT 1
before elastic get data 19-May-2025 06:50:35 pm after elastic get data 19-May-2025 06:50:35 pm before elastic new get data 19-May-2025 06:50:35 pmloop : 0

total records 55
process records 55below 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
    [9810361305] => 9810361305
    [9810298980] => 9810298980
    [9560890049] => 9560890049
    [8130912200] => 8130912200
    [9599334159] => 9599334159
    [7291988605] => 7291988605
    [8800025114] => 8800025114
)


 after elastic new get data 


 after elastic get data 

19-May-2025 06:50:35 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 06:50:35 pm

 after elastic get data 

19-May-2025 06:50:35 pm

 before elastic get data 

19-May-2025 06:50:35 pm

 after elastic get data 

19-May-2025 06:50:35 pm

 before elastic get data 

19-May-2025 06:50:35 pm

 after elastic get data 

19-May-2025 06:50:35 pm
SELECT * FROM `contacts_temp_group_36337` where group_id in(36337) group by mobile_number order by contact_id LIMIT 0,7 DND FILTERING YES MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39158` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39158','9810361305', 'p', '184', '1', '','','','', '') before INSERT DETAIL 19-May-2025 06:50:36 pm after INSERT DETAIL 19-May-2025 06:50:36 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39158` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39158','9810298980', 'p', '184', '1', '','','','', '') before INSERT DETAIL 19-May-2025 06:50:36 pm after INSERT DETAIL 19-May-2025 06:50:36 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39158` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39158','9599334159', 'p', '184', '1', '','','','', '') before INSERT DETAIL 19-May-2025 06:50:36 pm after INSERT DETAIL 19-May-2025 06:50:36 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39158` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39158','9560890049', 'p', '184', '1', '','','','', '') before INSERT DETAIL 19-May-2025 06:50:36 pm after INSERT DETAIL 19-May-2025 06:50:36 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39158` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39158','8130912200', 'p', '184', '1', '','','','', '') before INSERT DETAIL 19-May-2025 06:50:36 pm after INSERT DETAIL 19-May-2025 06:50:36 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39158` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39158','8800025114', 'p', '184', '1', '','','','', '') before INSERT DETAIL 19-May-2025 06:50:36 pm after INSERT DETAIL 19-May-2025 06:50:36 pm MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_39158` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('39158','7291988605', 'p', '184', '1', '','','','', '') before INSERT DETAIL 19-May-2025 06:50:36 pm after INSERT DETAIL 19-May-2025 06:50:36 pm before UPDATE SUMMARY 19-May-2025 06:50:36 pm after before UPDATE SUMMARY 19-May-2025 06:50:36 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.85621500015259 blacklist in micro sec 0.0043210983276367