SELECT * FROM voice_compaign_summary WHERE compaign_id='60019' LIMIT 1
before elastic get data
16-Dec-2025 07:57:12 pm
after elastic get data
16-Dec-2025 07:57:12 pm
before elastic new get data
16-Dec-2025 07:57:12 pmloop : 0
total records 119
process records 119below is user whitelist data
Array
(
[8712372751] => 8712372751
[7013008066] => 7013008066
[9966990230] => 9966990230
[9110592503] => 9110592503
[9140583326] => 9140583326
[8888888888] => 8888888888
[9819361573] => 9819361573
[9728836697] => 9728836697
[8278704201] => 8278704201
[7038757119] => 7038757119
[9717953152] => 9717953152
[6374783226] => 6374783226
[6264989770] => 6264989770
[6388227540] => 6388227540
[8967395317] => 8967395317
[9315622149] => 9315622149
[9382138668] => 9382138668
[9140486926] => 9140486926
[9623296525] => 9623296525
[6304798328] => 6304798328
[9307285067] => 9307285067
[9310257478] => 9310257478
[7397111804] => 7397111804
[9648808011] => 9648808011
[6399598979] => 6399598979
[8303883504] => 8303883504
[9592415001] => 9592415001
[7448284720] => 7448284720
[9900260483] => 9900260483
[9978924305] => 9978924305
[7020931125] => 7020931125
[8962049988] => 8962049988
[9018731266] => 9018731266
[9518943388] => 9518943388
[9910850296] => 9910850296
[8800316061] => 8800316061
[7982636694] => 7982636694
[8171071064] => 8171071064
[8923897940] => 8923897940
[8600794922] => 8600794922
[7769912283] => 7769912283
[7830363914] => 7830363914
[6239892289] => 6239892289
[7398692325] => 7398692325
[8591583826] => 8591583826
[9455363606] => 9455363606
[9642745618] => 9642745618
[7798237090] => 7798237090
[7260824665] => 7260824665
[6376669661] => 6376669661
[6203389952] => 6203389952
[7606071316] => 7606071316
[9984519218] => 9984519218
[8800362956] => 8800362956
[7007672522] => 7007672522
[6207293316] => 6207293316
[9657058409] => 9657058409
[8439313423] => 8439313423
[8808738513] => 8808738513
[9755925210] => 9755925210
[9760028232] => 9760028232
[9862975709] => 9862975709
[9500034518] => 9500034518
[7667350203] => 7667350203
[8617613203] => 8617613203
[6204648122] => 6204648122
[7061827006] => 7061827006
[9811816332] => 9811816332
[9324533782] => 9324533782
[8766615973] => 8766615973
[9608834325] => 9608834325
[9600788477] => 9600788477
[8388932119] => 8388932119
[7528858790] => 7528858790
[9975988247] => 9975988247
[8758032120] => 8758032120
[9956546804] => 9956546804
[9061294741] => 9061294741
[7692011734] => 7692011734
[9310731557] => 9310731557
[7572885699] => 7572885699
[9818056454] => 9818056454
[9368054038] => 9368054038
[6238686546] => 6238686546
[9251064592] => 9251064592
[8827368445] => 8827368445
[7008951514] => 7008951514
[9970293629] => 9970293629
[8802116269] => 8802116269
[9782166875] => 9782166875
[9209068854] => 9209068854
[9508331262] => 9508331262
[7995342653] => 7995342653
[8574225225] => 8574225225
[9811255727] => 9811255727
[9558253598] => 9558253598
[9558281631] => 9558281631
[6351892489] => 6351892489
[9301705014] => 9301705014
[8486122652] => 8486122652
[8971893179] => 8971893179
[9330266818] => 9330266818
[8433027690] => 8433027690
[8449073134] => 8449073134
[8882346684] => 8882346684
[9431931766] => 9431931766
[9322606179] => 9322606179
[8271595995] => 8271595995
[6394820002] => 6394820002
[7354673321] => 7354673321
[9663649970] => 9663649970
[9214141994] => 9214141994
[8448615614] => 8448615614
[8721815308] => 8721815308
[8830241256] => 8830241256
[7678690937] => 7678690937
[9064319093] => 9064319093
[8319162215] => 8319162215
[9315235169] => 9315235169
)
after elastic new get data
after elastic get data
16-Dec-2025 07:57:12 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:57:12 pm
after elastic get data
16-Dec-2025 07:57:12 pm
before elastic get data
16-Dec-2025 07:57:12 pm
after elastic get data
16-Dec-2025 07:57:12 pm
before elastic get data
16-Dec-2025 07:57:12 pm
after elastic get data
16-Dec-2025 07:57:12 pm
SELECT * FROM `contacts_temp_group_53956` where group_id in(53956) group by mobile_number order by contact_id LIMIT 0,42
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7223055078', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8095357754', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9955700823', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8409877378', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8930552183', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7069733555', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9310060749', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7003494110', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9999597226', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9867414590', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9327740165', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9718899034', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9728171855', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','6290443154', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7666881816', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9313645347', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9534270841', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7015547166', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','6204328124', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8726081055', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9711084669', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9033964154', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9870349857', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7004700227', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8297650026', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9038492212', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9467661978', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9705502244', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8011412510', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9996510107', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7903120635', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7601961926', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','6200365410', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7023780706', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9589775191', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7006068998', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9767022690', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9321780436', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','7983585769', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8128539199', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','8651353406', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
INSERT INTO `voice_compaign_detail_60019` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('60019','9439178880', 'p', '184', '0', '','','','', '')
before INSERT DETAIL
16-Dec-2025 07:57:12 pm
after INSERT DETAIL
16-Dec-2025 07:57:12 pm
before UPDATE SUMMARY
16-Dec-2025 07:57:12 pm
after before UPDATE SUMMARY
16-Dec-2025 07:57:12 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.076618194580078
blacklist in micro sec 0.024460315704346