SELECT * FROM voice_compaign_summary WHERE compaign_id='22424' LIMIT 1
before elastic get data 26-Jun-2024 09:24:48 am after elastic get data 26-Jun-2024 09:24:48 am before elastic new get data 26-Jun-2024 09:24:48 ambelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

26-Jun-2024 09:24:48 amCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 129
)


 before elastic get data 

26-Jun-2024 09:24:48 am

 after elastic get data 

26-Jun-2024 09:24:48 am

 before elastic get data 

26-Jun-2024 09:24:48 am

 after elastic get data 

26-Jun-2024 09:24:48 am

 before elastic get data 

26-Jun-2024 09:24:48 am

 after elastic get data 

26-Jun-2024 09:24:48 am
SELECT * FROM `contacts_temp_group_21917` where group_id in(21917)  group by mobile_number order by contact_id  LIMIT 0,40  


INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','7020257459', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','7083502354', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','7263044314', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','7499119505', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','7769036930', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8055452731', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8380986746', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8459597578', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8625997320', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8668222051', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8788738960', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8830980172', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','8975604065', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9011328294', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9022997805', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9028636939', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9049437956', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9096788737', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9130740274', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9146858941', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9158806439', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9168305782', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9226782998', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9309106643', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9325442498', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9325522976', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9518547969', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9527941858', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9579482471', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9604160787', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9673299770', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9673776255', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9763279244', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9766480639', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9767217797', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9822267291', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9834425092', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9923052961', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9923668162', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am
INSERT INTO `voice_compaign_detail_22424` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22424','9975996513', 'p', '129', '0', '','','','', '')


 before  INSERT DETAIL 

26-Jun-2024 09:24:48 am

 after INSERT DETAIL 

26-Jun-2024 09:24:48 am

 before UPDATE SUMMARY 

26-Jun-2024 09:24:48 am

 after before UPDATE SUMMARY  

26-Jun-2024 09:24:48 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.019248008728027 

 blacklist in micro sec 0.023172616958618