SELECT * FROM voice_compaign_summary WHERE compaign_id='11932' LIMIT 1
before elastic get data
01-Dec-2024 07:57:13 pm
after elastic get data
01-Dec-2024 07:57:13 pm
before elastic new get data
01-Dec-2024 07:57:13 pmbelow is user whitelist data
Array
(
)
after elastic new get data
after elastic get data
01-Dec-2024 07:57:13 pm alloted_apis_json--[{"cli":"","g_id":"29"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 29
)
)
gateway_id_arrs
Array
(
[0] => 29
)
before elastic get data
01-Dec-2024 07:57:13 pm
after elastic get data
01-Dec-2024 07:57:13 pm
before elastic get data
01-Dec-2024 07:57:13 pm
after elastic get data
01-Dec-2024 07:57:13 pm
before elastic get data
01-Dec-2024 07:57:13 pm
after elastic get data
01-Dec-2024 07:57:13 pm
SELECT * FROM `contacts_temp_group_12557` where group_id in(12557) group by mobile_number order by contact_id LIMIT 0,4
compaign id not set new
compaign id not set new
compaign id not set new
compaign id not set new
DND FILTERING YES {"query":{"bool":{"must":[{"terms":{"Mobile":[8809898594,8867197799,8978458627,9686631544]}}]}}}
mobile no is dnd9686631544
mobile no is dnd8867197799
before BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
after BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
INSERT INTO `voice_compaign_detail_11932` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('11932','8809898594', 'p', '29', '0', '','','','', '')
before INSERT DETAIL
01-Dec-2024 07:57:13 pm
after INSERT DETAIL
01-Dec-2024 07:57:13 pm
before BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
after BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
INSERT INTO `voice_compaign_detail_11932` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('11932','8867197799', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
01-Dec-2024 07:57:13 pm
after INSERT DETAIL
01-Dec-2024 07:57:13 pm
before BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
after BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
INSERT INTO `voice_compaign_detail_11932` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('11932','8978458627', 'p', '29', '0', '','','','', '')
before INSERT DETAIL
01-Dec-2024 07:57:13 pm
after INSERT DETAIL
01-Dec-2024 07:57:13 pm
before BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
after BLACKLIST_CONTASTS
01-Dec-2024 07:57:13 pm
INSERT INTO `voice_compaign_detail_11932` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('11932','9686631544', 'p', '-3', '0', '','','','', '')
before INSERT DETAIL
01-Dec-2024 07:57:13 pm
after INSERT DETAIL
01-Dec-2024 07:57:13 pm
before UPDATE SUMMARY
01-Dec-2024 07:57:13 pm
after before UPDATE SUMMARY
01-Dec-2024 07:57:13 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 0
blacklis in sec 0
whitelist get data sec 0
whitelist get data mic sec 3.504753112793E-5
blacklist in micro sec 0.0028727054595947