SELECT * FROM voice_compaign_summary WHERE compaign_id='18704' LIMIT 1
before elastic get data
25-May-2024 09:37:21 am
after elastic get data
25-May-2024 09:37:21 am
before elastic new get data
25-May-2024 09:37:21 ambelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
25-May-2024 09:37:21 amCutting Percentage = 60
1 alloted_apis_json--[{"cli":8645314615,"g_id":33}]
alloted api array
Array
(
[0] => Array
(
[cli] => 8645314615
[g_id] => 33
)
)
gateway_id_arrs
Array
(
[0] => 33
)
before elastic get data
25-May-2024 09:37:21 am
after elastic get data
25-May-2024 09:37:21 am
before elastic get data
25-May-2024 09:37:21 am
after elastic get data
25-May-2024 09:37:21 am
before elastic get data
25-May-2024 09:37:21 am
after elastic get data
25-May-2024 09:37:21 am
SELECT * FROM `contacts_temp_group_18278` where group_id in(18278) group by mobile_number order by contact_id LIMIT 0,55
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7066471893', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7218197170', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7276727874', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7350797051', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7387371611', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7517365954', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7559142933', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7620969750', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7745007248', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','7758976531', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8261940662', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8263822714', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8329211528', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8380841074', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8381062225', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8459642684', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8600680468', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8766969817', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8767029453', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8888374773', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','8983274102', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9011404255', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9021213275', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9021236081', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9067322751', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9284049550', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9325510573', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9356189894', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9370535254', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9405018365', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9420006064', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9420278977', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9422281041', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9503399069', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9503515727', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9503983998', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9518330714', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9527220048', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9552477104', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9552640609', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9595237516', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9604780116', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9604847980', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9657692769', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9657900575', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9765007972', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9766905866', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9822754130', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9822922777', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9881371847', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9881400911', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9921855258', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9922691939', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9960304591', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
INSERT INTO `voice_compaign_detail_18704` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('18704','9970210230', 'p', '33', '0', '','','','', '')
before INSERT DETAIL
25-May-2024 09:37:21 am
after INSERT DETAIL
25-May-2024 09:37:21 am
before UPDATE SUMMARY
25-May-2024 09:37:21 am
after before UPDATE SUMMARY
25-May-2024 09:37:21 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.063117027282715
blacklist in micro sec 0.020002603530884