SELECT * FROM voice_compaign_summary WHERE compaign_id='28927' LIMIT 1
before elastic get data 29-Aug-2024 07:52:04 pm after elastic get data 29-Aug-2024 07:52:04 pm before elastic new get data 29-Aug-2024 07:52:04 pmbelow is user whitelist data 
Array
(
)


 after elastic new get data 


 after elastic get data 

29-Aug-2024 07:52: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 

29-Aug-2024 07:52:04 pm

 after elastic get data 

29-Aug-2024 07:52:04 pm

 before elastic get data 

29-Aug-2024 07:52:04 pm

 after elastic get data 

29-Aug-2024 07:52:04 pm

 before elastic get data 

29-Aug-2024 07:52:04 pm

 after elastic get data 

29-Aug-2024 07:52:04 pm
SELECT * FROM `contacts_temp_group_28158` where group_id in(28158)  group by mobile_number order by contact_id  LIMIT 0,46  


INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9741039911', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9643884661', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9007141578', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9168585577', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8797537635', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8247474198', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9825114769', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9366655524', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7003515156', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9619591419', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9762762394', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7780524043', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7043119341', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8103260301', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9823426053', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7010887134', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9860768252', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7568700000', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9525137313', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9940307164', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9346879789', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','6303819220', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8349212346', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9811775691', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7014823817', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9784094178', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9908120053', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9594622111', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9307998108', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8124723687', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8377996446', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:04 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9582722770', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:04 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8695034160', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9823929493', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7008463843', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8904043007', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7550230641', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','8320415974', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7030090006', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9843143738', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9490843200', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','7206927396', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9488767686', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9800028020', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9924171097', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm
INSERT INTO `voice_compaign_detail_28927` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('28927','9742345768', 'p', '79', '0', '','','','', '')


 before  INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 after INSERT DETAIL 

29-Aug-2024 07:52:05 pm

 before UPDATE SUMMARY 

29-Aug-2024 07:52:05 pm

 after before UPDATE SUMMARY  

29-Aug-2024 07:52: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.050393104553223 

 blacklist in micro sec 0.025076627731323