SELECT * FROM voice_compaign_summary WHERE compaign_id='59996' LIMIT 1
before elastic get data
16-Dec-2025 07:04:05 pm
after elastic get data
16-Dec-2025 07:04:05 pm
before elastic new get data
16-Dec-2025 07:04:05 pmloop : 0
total records 117
process records 117below is user whitelist data
Array
(
[8179445599] => 8179445599
[9492238112] => 9492238112
[8008666363] => 8008666363
[7993727815] => 7993727815
[8500727146] => 8500727146
[9618744474] => 9618744474
[9704241999] => 9704241999
[9052432234] => 9052432234
[9849466777] => 9849466777
[9866474371] => 9866474371
[9963652394] => 9963652394
[9441305604] => 9441305604
[7901025139] => 7901025139
[9856669999] => 9856669999
[9989034251] => 9989034251
[9440836979] => 9440836979
[9440581919] => 9440581919
[9908967394] => 9908967394
[6305978869] => 6305978869
[9603454513] => 9603454513
[9603217182] => 9603217182
[9052684138] => 9052684138
[9885270942] => 9885270942
[7093208311] => 7093208311
[9705192600] => 9705192600
[9491331131] => 9491331131
[7095416630] => 7095416630
[9603336221] => 9603336221
[9440876031] => 9440876031
[7288904076] => 7288904076
[6305391744] => 6305391744
[7989824003] => 7989824003
[9440320239] => 9440320239
[9908833125] => 9908833125
[9396655645] => 9396655645
[8639612134] => 8639612134
[9000925926] => 9000925926
[9912377988] => 9912377988
[9885991953] => 9885991953
[9948083188] => 9948083188
[8977648455] => 8977648455
[9959035857] => 9959035857
[9885527749] => 9885527749
[9866135678] => 9866135678
[9948473794] => 9948473794
[9989355399] => 9989355399
[9346650616] => 9346650616
[9177777097] => 9177777097
[9490709362] => 9490709362
[9866866559] => 9866866559
[7730063172] => 7730063172
[9866252982] => 9866252982
[9030772345] => 9030772345
[8885213334] => 8885213334
[8349888018] => 8349888018
[8860233336] => 8860233336
[9798964227] => 9798964227
[9523334891] => 9523334891
[7676326428] => 7676326428
[8678049202] => 8678049202
[7678652743] => 7678652743
[8436622265] => 8436622265
[9151155173] => 9151155173
[9814080870] => 9814080870
[7665407584] => 7665407584
[8239147687] => 8239147687
[9022978467] => 9022978467
[7307184052] => 7307184052
[7759881496] => 7759881496
[9163732333] => 9163732333
[9794775994] => 9794775994
[8862894558] => 8862894558
[7800594958] => 7800594958
[8503972364] => 8503972364
[9681802453] => 9681802453
[9149202730] => 9149202730
[8058582734] => 8058582734
[9868425891] => 9868425891
[8320346823] => 8320346823
[7982185137] => 7982185137
[8670430252] => 8670430252
[7210471930] => 7210471930
[7780047577] => 7780047577
[8310842593] => 8310842593
[6261899090] => 6261899090
[7549860959] => 7549860959
[9630891953] => 9630891953
[9560307376] => 9560307376
[9471724496] => 9471724496
[8687802039] => 8687802039
[7024670102] => 7024670102
[7011392829] => 7011392829
[8090902251] => 8090902251
[9826381211] => 9826381211
[9881139538] => 9881139538
[8896083271] => 8896083271
[9540820803] => 9540820803
[9879318227] => 9879318227
[7381925718] => 7381925718
[9175163553] => 9175163553
[9616723510] => 9616723510
[8530833939] => 8530833939
[8929483473] => 8929483473
[9609427428] => 9609427428
[7087096771] => 7087096771
[9630890650] => 9630890650
[7404521936] => 7404521936
[8819918806] => 8819918806
[7007524362] => 7007524362
[8793341846] => 8793341846
[7020222451] => 7020222451
[7973762812] => 7973762812
[8707475900] => 8707475900
[8077323737] => 8077323737
[9621955629] => 9621955629
[9211037276] => 9211037276
[7377182846] => 7377182846
)
after elastic new get data
after elastic get data
16-Dec-2025 07:04:06 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"184"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 184
)
)
gateway_id_arrs
Array
(
[0] => 184
)
before elastic get data
16-Dec-2025 07:04:06 pm
after elastic get data
16-Dec-2025 07:04:06 pm
before elastic get data
16-Dec-2025 07:04:06 pm
after elastic get data
16-Dec-2025 07:04:06 pm
before elastic get data
16-Dec-2025 07:04:06 pm
after elastic get data
16-Dec-2025 07:04:06 pm
SELECT * FROM `contacts_temp_group_53931` where group_id in(53931) group by mobile_number order by contact_id LIMIT 0,20
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','9879318227', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','7381925718', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','9175163553', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','9616723510', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','8929483473', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','8530833939', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','9609427428', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','7087096771', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','8793341846', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','9630890650', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','7404521936', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','8819918806', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','7007524362', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','7020222451', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','7973762812', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','8707475900', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','8077323737', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','9621955629', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','9211037276', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_59996` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('59996','7377182846', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:04:06 pm
after INSERT DETAIL
16-Dec-2025 07:04:06 pm
before UPDATE SUMMARY
16-Dec-2025 07:04:06 pm
after before UPDATE SUMMARY
16-Dec-2025 07:04:06 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 1
whitelist get data mic sec 0.77898192405701
blacklist in micro sec 0.011327981948853