SELECT * FROM voice_compaign_summary WHERE compaign_id='22560' LIMIT 1
before elastic get data 27-Jun-2024 12:45:04 pm after elastic get data 27-Jun-2024 12:45:04 pm before elastic new get data 27-Jun-2024 12:45:04 pmbelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

27-Jun-2024 12:45:04 pmCutting Percentage = 0

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 79
)


 before elastic get data 

27-Jun-2024 12:45:04 pm

 after elastic get data 

27-Jun-2024 12:45:04 pm

 before elastic get data 

27-Jun-2024 12:45:04 pm

 after elastic get data 

27-Jun-2024 12:45:04 pm

 before elastic get data 

27-Jun-2024 12:45:04 pm

 after elastic get data 

27-Jun-2024 12:45:04 pm
SELECT * FROM `contacts_temp_group_22039` where group_id in(22039)  group by mobile_number order by contact_id  LIMIT 0,33  


INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9758332869', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7310706445', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8923348346', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7689837918', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8393021283', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9719301337', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7834034397', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7895955176', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9457121063', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7500566016', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7983227014', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9411691092', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','6387164604', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:04 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9026991499', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:04 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9045169808', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9719281813', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9528831546', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9625209315', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7983778562', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8273119379', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8475921980', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8126429859', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9761901089', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','7701845152', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8650883996', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9411079453', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8449164173', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8077194964', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9115374158', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9759340932', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','9760764270', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8279491607', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm
INSERT INTO `voice_compaign_detail_22560` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('22560','8791603739', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 after INSERT DETAIL 

27-Jun-2024 12:45:05 pm

 before UPDATE SUMMARY 

27-Jun-2024 12:45:05 pm

 after before UPDATE SUMMARY  

27-Jun-2024 12:45:05 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  

 blacklis in sec 0 

 whitelist get data sec 0 

 whitelist get data mic sec 0.017718076705933 

 blacklist in micro sec 0.016115427017212