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


 after elastic new get data 


 after elastic get data 

21-Oct-2024 04:30:08 pmCutting Percentage = 0

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

alloted api array 

 
Array
(
    [0] => Array
        (
            [cli] => 7447141132
            [g_id] => 145
        )

)
gateway_id_arrs 

 
Array
(
    [0] => 145
)


 before elastic get data 

21-Oct-2024 04:30:08 pm

 after elastic get data 

21-Oct-2024 04:30:08 pm

 before elastic get data 

21-Oct-2024 04:30:08 pm

 after elastic get data 

21-Oct-2024 04:30:08 pm

 before elastic get data 

21-Oct-2024 04:30:08 pm

 after elastic get data 

21-Oct-2024 04:30:08 pm
SELECT * FROM `contacts_temp_group_30110` where group_id in(30110)  group by mobile_number order by contact_id  LIMIT 0,29  

 

 DND FILTERING YES 
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9443642414', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442940499', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','8883063333', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9444364006', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442689233', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9444270032', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9159073777', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442046140', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','8940754979', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9443508623', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442320382', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','6379459712', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9698788481', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9486483242', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9487148895', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9384592602', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442959118', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','8525978969', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442651313', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9943909526', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9626249211', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9003616379', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442752061', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','8098388760', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9442225021', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9052941254', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9600367028', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','8489833597', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm
INSERT INTO `voice_compaign_detail_31272` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('31272','9443932864', 'p', '145', '0', '','','','', '')


 before  INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 after INSERT DETAIL 

21-Oct-2024 04:30:08 pm

 before UPDATE SUMMARY 

21-Oct-2024 04:30:08 pm

 after before UPDATE SUMMARY  

21-Oct-2024 04:30:08 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 -203193316790 

 blacklis in sec 0 

 whitelist get data sec 0 

 whitelist get data mic sec 0.18711805343628 

 blacklist in micro sec 0.018853902816772