SELECT * FROM voice_compaign_summary WHERE compaign_id='30198' LIMIT 1
before elastic get data 05-Oct-2024 05:00:08 pm after elastic get data 05-Oct-2024 05:00:08 pm before elastic new get data 05-Oct-2024 05:00:08 pmbelow is user whitelist data
Array
(
)


 after elastic new get data 


 after elastic get data 

05-Oct-2024 05:00:08 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 

05-Oct-2024 05:00:08 pm

 after elastic get data 

05-Oct-2024 05:00:08 pm

 before elastic get data 

05-Oct-2024 05:00:08 pm

 after elastic get data 

05-Oct-2024 05:00:08 pm

 before elastic get data 

05-Oct-2024 05:00:08 pm

 after elastic get data 

05-Oct-2024 05:00:08 pm
SELECT * FROM `contacts_temp_group_29231` where group_id in(29231) group by mobile_number order by contact_id LIMIT 0,29 DND FILTERING YES
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9444364006', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442651313', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9361786897', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9843806320', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7708802156', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9443466769', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9790438850', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9487036307', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442960795', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9787887333', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9843425277', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','8760493770', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442970406', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9655494571', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9442556171', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9789500101', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','8903009092', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7639537908', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9843384338', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9865640026', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9443328976', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9486651731', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7868932491', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','8300016904', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9597935939', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9444038915', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','7598854425', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9443467463', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm
INSERT INTO `voice_compaign_detail_30198` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('30198','9486117552', 'p', '79', '0', '','','','', '') before INSERT DETAIL 05-Oct-2024 05:00:09 pm after INSERT DETAIL 05-Oct-2024 05:00:09 pm before UPDATE SUMMARY 05-Oct-2024 05:00:09 pm after before UPDATE SUMMARY 05-Oct-2024 05:00:09 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 0 blacklis in sec 0 whitelist get data sec 0 whitelist get data mic sec 0.051892995834351 blacklist in micro sec 0.015990972518921