SELECT * FROM voice_compaign_summary WHERE compaign_id='25683' LIMIT 1
before elastic get data 28-Jul-2024 10:00:14 am after elastic get data 28-Jul-2024 10:00:14 am before elastic new get data 28-Jul-2024 10:00:14 ambelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

28-Jul-2024 10:00:14 amCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 53
)


 before elastic get data 

28-Jul-2024 10:00:14 am

 after elastic get data 

28-Jul-2024 10:00:14 am

 before elastic get data 

28-Jul-2024 10:00:14 am

 after elastic get data 

28-Jul-2024 10:00:14 am

 before elastic get data 

28-Jul-2024 10:00:14 am

 after elastic get data 

28-Jul-2024 10:00:14 am
SELECT * FROM `contacts_temp_group_25114` where group_id in(25114)  group by mobile_number order by contact_id  LIMIT 0,47  


INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9923410740', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9790565001', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9182350642', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9518411805', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7020880120', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7838853086', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8179221084', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8108192920', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9867409589', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9173874163', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7892346488', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7004039421', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8523636985', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7092358609', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8828867727', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9645075073', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9747381591', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9447544224', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9975252585', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9158323693', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8827451555', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8210775623', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8667200778', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8390860276', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9833587477', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7558482958', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7977338620', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8023536598', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9953501321', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9811464647', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9996038665', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9972302038', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8414815323', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7729027463', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9056657191', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8801390152', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8299030737', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9971675017', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8466036090', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9552350471', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9426591552', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8446009092', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','6290936726', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9990841047', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','9819099714', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','8454883333', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am
INSERT INTO `voice_compaign_detail_25683` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('25683','7276705462', 'p', '53', '0', '','','','', '')


 before  INSERT DETAIL 

28-Jul-2024 10:00:14 am

 after INSERT DETAIL 

28-Jul-2024 10:00:14 am

 before UPDATE SUMMARY 

28-Jul-2024 10:00:14 am

 after before UPDATE SUMMARY  

28-Jul-2024 10:00:14 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.019451141357422 

 blacklist in micro sec 0.027401208877563