SELECT * FROM voice_compaign_summary WHERE compaign_id='28196' LIMIT 1
before elastic get data 22-Aug-2024 07:24:14 pm after elastic get data 22-Aug-2024 07:24:14 pm before elastic new get data 22-Aug-2024 07:24:14 pmbelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

22-Aug-2024 07:24:14 pmCutting Percentage = 45

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

alloted api array 

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

)
gateway_id_arrs 

 
Array
(
    [0] => 110
)


 before elastic get data 

22-Aug-2024 07:24:14 pm

 after elastic get data 

22-Aug-2024 07:24:14 pm

 before elastic get data 

22-Aug-2024 07:24:14 pm

 after elastic get data 

22-Aug-2024 07:24:14 pm

 before elastic get data 

22-Aug-2024 07:24:14 pm

 after elastic get data 

22-Aug-2024 07:24:14 pm
SELECT * FROM `contacts_temp_group_27462` where group_id in(27462)  group by mobile_number order by contact_id  LIMIT 0,53  


INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9197790339', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9350592593', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9199785039', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','6797671209', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8885088806', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9921927244', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7888624633', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9033218545', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9159413911', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8459711782', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8142679953', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9819815513', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8086151935', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7799996608', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9912794776', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9199895685', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8668943328', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9784422687', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7002980934', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9740675070', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8218587636', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','6813934439', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7338796643', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8199000653', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8190139018', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9844496454', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9444703073', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9015107709', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9489888093', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8914190383', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8294630572', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9669638993', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9986118445', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','6536594456', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','6697972988', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9494319689', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7972123016', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9717733415', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8270001738', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7639198466', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9512693110', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7749290785', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9939495620', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9698944771', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','6295992601', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','6706098820', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8999944891', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','6071589088', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','7009534420', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8950007100', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9822713532', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','9777926206', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm
INSERT INTO `voice_compaign_detail_28196` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28196','8862012910', 'p', '110', '0', '','','','', '')


 before  INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 after INSERT DETAIL 

22-Aug-2024 07:24:14 pm

 before UPDATE SUMMARY 

22-Aug-2024 07:24:14 pm

 after before UPDATE SUMMARY  

22-Aug-2024 07:24:14 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.040769100189209 

 blacklist in micro sec 0.031490087509155