SELECT * FROM voice_compaign_summary WHERE compaign_id='28209' LIMIT 1
before elastic get data 23-Aug-2024 11:00:09 am after elastic get data 23-Aug-2024 11:00:09 am before elastic new get data 23-Aug-2024 11:00:09 ambelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

23-Aug-2024 11:00:09 amCutting Percentage = 0

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

alloted api array 

 
Array
(
    [0] => Array
        (
            [cli] => 7313658832
            [g_id] => 129
        )

)
gateway_id_arrs 

 
Array
(
    [0] => 129
)


 before elastic get data 

23-Aug-2024 11:00:09 am

 after elastic get data 

23-Aug-2024 11:00:09 am

 before elastic get data 

23-Aug-2024 11:00:09 am

 after elastic get data 

23-Aug-2024 11:00:09 am

 before elastic get data 

23-Aug-2024 11:00:09 am

 after elastic get data 

23-Aug-2024 11:00:09 am
SELECT * FROM `contacts_temp_group_27474` where group_id in(27474)  group by mobile_number order by contact_id  LIMIT 0,45  


INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','8754703717', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9445545255', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','6379212525', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9789619264', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9025377838', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9943947709', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9865498485', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','8940115333', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9159399215', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9751917885', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','8098181112', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9841660997', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','6374621317', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9176867313', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9865665326', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','7402217119', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9543084141', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9843122946', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','8610930191', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9791944057', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9952888229', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9865755970', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9944508921', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9943874314', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9443503128', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','8098242095', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9159225109', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9597788455', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9994727618', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','8072540492', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9360676767', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9786230808', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9443962320', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9655280368', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','7845769181', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9488346634', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9442940499', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9842013393', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9789600079', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','8940042311', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9444471800', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9942274999', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','7010506983', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','6380160584', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am
INSERT INTO `voice_compaign_detail_28209` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28209','9787389796', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

23-Aug-2024 11:00:09 am

 after INSERT DETAIL 

23-Aug-2024 11:00:09 am

 before UPDATE SUMMARY 

23-Aug-2024 11:00:09 am

 after before UPDATE SUMMARY  

23-Aug-2024 11:00:09 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  

 blacklis in sec 0 

 whitelist get data sec 0 

 whitelist get data mic sec 0.04117488861084 

 blacklist in micro sec 0.022882223129272