SELECT * FROM voice_compaign_summary WHERE compaign_id='20908' LIMIT 1
before elastic get data
12-Jun-2024 10:19:33 am
after elastic get data
12-Jun-2024 10:19:33 am
before elastic new get data
12-Jun-2024 10:19:33 ambelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
12-Jun-2024 10:19:33 amCutting Percentage = 0
1 alloted_apis_json--[{"cli":7313658803,"g_id":129}]
alloted api array
Array
(
[0] => Array
(
[cli] => 7313658803
[g_id] => 129
)
)
gateway_id_arrs
Array
(
[0] => 129
)
before elastic get data
12-Jun-2024 10:19:33 am
after elastic get data
12-Jun-2024 10:19:33 am
before elastic get data
12-Jun-2024 10:19:33 am
after elastic get data
12-Jun-2024 10:19:33 am
before elastic get data
12-Jun-2024 10:19:33 am
after elastic get data
12-Jun-2024 10:19:33 am
SELECT * FROM `contacts_temp_group_20490` where group_id in(20490) group by mobile_number order by contact_id LIMIT 0,35
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','7350348671', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','7498679470', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','7620904920', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','7776020426', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','7972794001', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','8261075542', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','8275393413', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','8308258215', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','8796462532', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','8830374326', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9011313464', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9112320211', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9112910853', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9112911096', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9226008067', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9309924811', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9325934240', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9373701071', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9423387329', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9588474719', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9637640321', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9657121767', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9665937664', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9730567559', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9767248211', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9767298803', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9767336479', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9767901866', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9850024987', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9921646624', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9922341326', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9960557385', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9960806539', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9970216333', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
INSERT INTO `voice_compaign_detail_20908` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('20908','9975354086', 'p', '129', '0', '','','','', '')
before INSERT DETAIL
12-Jun-2024 10:19:33 am
after INSERT DETAIL
12-Jun-2024 10:19:33 am
before UPDATE SUMMARY
12-Jun-2024 10:19:33 am
after before UPDATE SUMMARY
12-Jun-2024 10:19:33 am
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.021543025970459
blacklist in micro sec 0.019784927368164