SELECT * FROM voice_compaign_summary WHERE compaign_id='40071' LIMIT 1
before elastic get data
06-Jun-2025 07:51:37 pm
after elastic get data
06-Jun-2025 07:51:37 pm
before elastic new get data
06-Jun-2025 07:51:37 pmloop : 0
total records 117
process records 117below is user whitelist data
Array
(
[9177151155] => 9177151155
[9440959839] => 9440959839
[8247853403] => 8247853403
[9110570616] => 9110570616
[9963370430] => 9963370430
[9440205694] => 9440205694
[9966359111] => 9966359111
[9494844758] => 9494844758
[9440446325] => 9440446325
[9000004547] => 9000004547
[9490483755] => 9490483755
[9848099335] => 9848099335
[9032571433] => 9032571433
[9440155046] => 9440155046
[8341504282] => 8341504282
[9440296022] => 9440296022
[9440256611] => 9440256611
[9000004549] => 9000004549
[9440361942] => 9440361942
[9441628404] => 9441628404
[8328432142] => 8328432142
[9390033330] => 9390033330
[8696005444] => 8696005444
[9440914004] => 9440914004
[9440724889] => 9440724889
[9441379137] => 9441379137
[9701986074] => 9701986074
[8247453808] => 8247453808
[9849909390] => 9849909390
[9885015563] => 9885015563
[9985584692] => 9985584692
[9492502009] => 9492502009
[9885370058] => 9885370058
[8686715909] => 8686715909
[9848007127] => 9848007127
[9908054888] => 9908054888
[9491853593] => 9491853593
[9177017227] => 9177017227
[8247881536] => 8247881536
[8008008234] => 8008008234
[9866174648] => 9866174648
[9581310009] => 9581310009
[9581079699] => 9581079699
[9052021675] => 9052021675
[9246843565] => 9246843565
[9059759558] => 9059759558
[9848076186] => 9848076186
[7382312175] => 7382312175
[9985374968] => 9985374968
[9177290513] => 9177290513
[9705337204] => 9705337204
[9640079977] => 9640079977
[9581006646] => 9581006646
[7799559885] => 7799559885
[8968696615] => 8968696615
[8555875460] => 8555875460
[9845636185] => 9845636185
[9849351997] => 9849351997
[9885035625] => 9885035625
[8639976048] => 8639976048
[9440797502] => 9440797502
[9440297468] => 9440297468
[6281918380] => 6281918380
[7330891666] => 7330891666
[6300292529] => 6300292529
[9032234477] => 9032234477
[9985104213] => 9985104213
[6302108016] => 6302108016
[9618598369] => 9618598369
[8886850080] => 8886850080
[9440546996] => 9440546996
[9885500502] => 9885500502
[9398919205] => 9398919205
[9515115345] => 9515115345
[7799833224] => 7799833224
[9440547955] => 9440547955
[9989714173] => 9989714173
[9440123956] => 9440123956
[9848463390] => 9848463390
[9985251556] => 9985251556
[9966532886] => 9966532886
[9985691599] => 9985691599
[9177657657] => 9177657657
[8500288899] => 8500288899
[8500188899] => 8500188899
[9703476124] => 9703476124
[9553019171] => 9553019171
[7780139042] => 7780139042
[9490256611] => 9490256611
[9000860137] => 9000860137
[9989940085] => 9989940085
[9705096107] => 9705096107
[8555590280] => 8555590280
[9985102566] => 9985102566
[9866176705] => 9866176705
[8639203590] => 8639203590
[7013887081] => 7013887081
[9000062001] => 9000062001
[9666990516] => 9666990516
[8519867209] => 8519867209
[8096188415] => 8096188415
[9030797810] => 9030797810
[9494456611] => 9494456611
[9705557700] => 9705557700
[9908999665] => 9908999665
[9505385719] => 9505385719
[6302376863] => 6302376863
[8639794549] => 8639794549
[7729954881] => 7729954881
[8096101333] => 8096101333
[8897479682] => 8897479682
[9666338893] => 9666338893
[8688336512] => 8688336512
[7562800337] => 7562800337
[9896323154] => 9896323154
[7206268013] => 7206268013
[8569877731] => 8569877731
)
after elastic new get data
after elastic get data
06-Jun-2025 07:51:38 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
06-Jun-2025 07:51:38 pm
after elastic get data
06-Jun-2025 07:51:38 pm
before elastic get data
06-Jun-2025 07:51:38 pm
after elastic get data
06-Jun-2025 07:51:38 pm
before elastic get data
06-Jun-2025 07:51:38 pm
after elastic get data
06-Jun-2025 07:51:38 pm
SELECT * FROM `contacts_temp_group_37009` where group_id in(37009) group by mobile_number order by contact_id LIMIT 0,1
DND FILTERING YES
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_40071` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('40071','8569877731', 'p', '184', '1', '','','','', '')
before INSERT DETAIL
06-Jun-2025 07:51:38 pm
after INSERT DETAIL
06-Jun-2025 07:51:38 pm
before UPDATE SUMMARY
06-Jun-2025 07:51:38 pm
after before UPDATE SUMMARY
06-Jun-2025 07:51:39 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 1
whitelist get data mic sec 0.98262000083923
blacklist in micro sec 0.00075387954711914