SELECT * FROM voice_compaign_summary WHERE compaign_id='20422' LIMIT 1
before elastic get data
07-Jun-2024 02:30:02 pm
after elastic get data
07-Jun-2024 02:30:02 pm
before elastic new get data
07-Jun-2024 02:30:02 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
07-Jun-2024 02:30:02 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"48"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 48
)
)
gateway_id_arrs
Array
(
[0] => 48
)
before elastic get data
07-Jun-2024 02:30:02 pm
after elastic get data
07-Jun-2024 02:30:02 pm
before elastic get data
07-Jun-2024 02:30:02 pm
after elastic get data
07-Jun-2024 02:30:02 pm
before elastic get data
07-Jun-2024 02:30:02 pm
after elastic get data
07-Jun-2024 02:30:02 pm
SELECT * FROM `contacts_temp_group_19995` where group_id in(19995) group by mobile_number order by contact_id LIMIT 0,34
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8097988482', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8108157777', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8451973788', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8454918821', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8652189053', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8655873015', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8691841292', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8779951007', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8828747740', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8898994777', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8928148436', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9320408752', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9619938038', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9769169114', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9892279909', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9920174074', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8097313047', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','7715847197', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8097431770', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9152186607', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9324350605', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9892005268', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','6391663893', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','7822064459', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9892233403', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9702680847', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9920962687', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','8691948659', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9930541332', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9664524209', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9967116988', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9628654199', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9594686425', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
INSERT INTO `voice_compaign_detail_20422` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20422','9870753274', 'p', '48', '0', '','','','', '')
before INSERT DETAIL
07-Jun-2024 02:30:02 pm
after INSERT DETAIL
07-Jun-2024 02:30:02 pm
before UPDATE SUMMARY
07-Jun-2024 02:30:02 pm
after before UPDATE SUMMARY
07-Jun-2024 02:30:02 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.044989824295044
blacklist in micro sec 0.0269935131073