SELECT * FROM voice_compaign_summary WHERE compaign_id='29022' LIMIT 1
before elastic get data 30-Aug-2024 03:02:11 pm after elastic get data 30-Aug-2024 03:02:11 pm before elastic new get data 30-Aug-2024 03:02:11 pmbelow is user whitelist data
Array
(
)


 after elastic new get data 


 after elastic get data 

30-Aug-2024 03:02:11 pmCutting Percentage = 45

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 54
)


 before elastic get data 

30-Aug-2024 03:02:11 pm

 after elastic get data 

30-Aug-2024 03:02:11 pm

 before elastic get data 

30-Aug-2024 03:02:11 pm

 after elastic get data 

30-Aug-2024 03:02:11 pm

 before elastic get data 

30-Aug-2024 03:02:11 pm

 after elastic get data 

30-Aug-2024 03:02:11 pm
SELECT * FROM `contacts_temp_group_28254` where group_id in(28254) group by mobile_number order by contact_id LIMIT 0,55
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7027841955', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9350572331', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8529480428', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930110268', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8683811099', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8307694352', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7015184272', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930429190', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9996372980', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7930662280', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8851822499', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9653515433', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9053542947', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9813210723', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9254868312', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8950333404', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7919001660', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9611610884', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9896568568', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9468003297', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9350044915', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8168009411', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9306476808', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8398907158', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7015726084', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8307143198', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930485309', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8930095753', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8685838190', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9306647952', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9813008251', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9671468438', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8168743758', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9540550962', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7404900426', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8607344131', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7015152084', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9991951408', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9815532804', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9050773978', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8950006081', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8053007964', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7082097191', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8571022308', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8685889939', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8813072773', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9813682032', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8586845545', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8607121535', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9991568148', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9255539809', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','9812878199', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8397910430', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','7056920225', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm
INSERT INTO `voice_compaign_detail_29022` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('29022','8059656690', 'p', '54', '0', '','','','', '') before INSERT DETAIL 30-Aug-2024 03:02:11 pm after INSERT DETAIL 30-Aug-2024 03:02:11 pm before UPDATE SUMMARY 30-Aug-2024 03:02:11 pm after before UPDATE SUMMARY 30-Aug-2024 03:02:11 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.12336897850037 blacklist in micro sec 0.031297922134399