SELECT * FROM voice_compaign_summary WHERE compaign_id='38675' LIMIT 1
before elastic get data
10-May-2025 04:42:24 pm
after elastic get data
10-May-2025 04:42:24 pm
before elastic new get data
10-May-2025 04:42:24 pmloop : 0
total records 236
process records 236below is user whitelist data
Array
(
[9980704083] => 9980704083
[9986142246] => 9986142246
[6362046025] => 6362046025
[9663003777] => 9663003777
[7337792608] => 7337792608
[9945994555] => 9945994555
[7411109227] => 7411109227
[9448134856] => 9448134856
[7259800087] => 7259800087
[8496989549] => 8496989549
[9449105150] => 9449105150
[9535586900] => 9535586900
[9019411311] => 9019411311
[9782902155] => 9782902155
[7622927564] => 7622927564
[9071266286] => 9071266286
[8762860656] => 8762860656
[9482944477] => 9482944477
[9141238128] => 9141238128
[9480459715] => 9480459715
[9449457709] => 9449457709
[9449294688] => 9449294688
[9448347442] => 9448347442
[8762370428] => 8762370428
[8277007504] => 8277007504
[9901849632] => 9901849632
[9480520198] => 9480520198
[8861163805] => 8861163805
[9241212444] => 9241212444
[9448703454] => 9448703454
[9481720894] => 9481720894
[9964045925] => 9964045925
[9480780819] => 9480780819
[9482933237] => 9482933237
[8494903484] => 8494903484
[9449359430] => 9449359430
[9483485598] => 9483485598
[8310115415] => 8310115415
[9380767806] => 9380767806
[7353687340] => 7353687340
[9480963175] => 9480963175
[9448933937] => 9448933937
[9741187183] => 9741187183
[9448545911] => 9448545911
[9449501832] => 9449501832
[8762841226] => 8762841226
[9663730345] => 9663730345
[9113942001] => 9113942001
[9741790694] => 9741790694
[7676847273] => 7676847273
[8147977562] => 8147977562
[9739641623] => 9739641623
[9480726996] => 9480726996
[9448642348] => 9448642348
[9449293066] => 9449293066
[9481458979] => 9481458979
[8310743252] => 8310743252
[9481111736] => 9481111736
[8762099560] => 8762099560
[8152917962] => 8152917962
[8495935857] => 8495935857
[9483938735] => 9483938735
[9632341192] => 9632341192
[9483538494] => 9483538494
[9481156519] => 9481156519
[9480898208] => 9480898208
[7829014889] => 7829014889
[9632148455] => 9632148455
[9945995943] => 9945995943
[9481862396] => 9481862396
[9480274129] => 9480274129
[9448877161] => 9448877161
[9008013833] => 9008013833
[9448933687] => 9448933687
[8277349218] => 8277349218
[8431919993] => 8431919993
[9380873083] => 9380873083
[9483416378] => 9483416378
[8277227510] => 8277227510
[9481706391] => 9481706391
[9880906375] => 9880906375
[9902467696] => 9902467696
[9480327180] => 9480327180
[9482349260] => 9482349260
[9448823592] => 9448823592
[8073984327] => 8073984327
[9611960791] => 9611960791
[8660858894] => 8660858894
[7259307741] => 7259307741
[9481645570] => 9481645570
[9482998979] => 9482998979
[9483730597] => 9483730597
[8746006655] => 8746006655
[8296420759] => 8296420759
[6362378821] => 6362378821
[9481862098] => 9481862098
[9483938893] => 9483938893
[9448058892] => 9448058892
[9242913964] => 9242913964
[9108208100] => 9108208100
[9449939075] => 9449939075
[8762149932] => 8762149932
[9449359089] => 9449359089
[8748810586] => 8748810586
[9482133353] => 9482133353
[8431475300] => 8431475300
[9449928425] => 9449928425
[9448486874] => 9448486874
[9880075499] => 9880075499
[9449343147] => 9449343147
[9663598385] => 9663598385
[8197305199] => 8197305199
[9535146129] => 9535146129
[8431665953] => 8431665953
[9902798179] => 9902798179
[9480440943] => 9480440943
[9535617251] => 9535617251
[8861638875] => 8861638875
[9900485632] => 9900485632
[7892387911] => 7892387911
[9449192543] => 9449192543
[9611659730] => 9611659730
[9972052785] => 9972052785
[9731069149] => 9731069149
[9448965263] => 9448965263
[8105818187] => 8105818187
[8660106179] => 8660106179
[9742051153] => 9742051153
[6361441760] => 6361441760
[8762846828] => 8762846828
[9901851408] => 9901851408
[8197357934] => 8197357934
[8446183995] => 8446183995
[9008909974] => 9008909974
[8431907309] => 8431907309
[6366278112] => 6366278112
[8277007251] => 8277007251
[9480944731] => 9480944731
[9449188618] => 9449188618
[9448342676] => 9448342676
[9482988586] => 9482988586
[9686093339] => 9686093339
[9480700422] => 9480700422
[9481751008] => 9481751008
[9448236277] => 9448236277
[9448317630] => 9448317630
[7019127441] => 7019127441
[9916880085] => 9916880085
[9743620972] => 9743620972
[9482986463] => 9482986463
[9480759906] => 9480759906
[9845337734] => 9845337734
[7829846144] => 7829846144
[9880519703] => 9880519703
[9448915947] => 9448915947
[9449773770] => 9449773770
[9380626221] => 9380626221
[9902208660] => 9902208660
[9449629660] => 9449629660
[9482993497] => 9482993497
[9480119106] => 9480119106
[9483485740] => 9483485740
[9482125057] => 9482125057
[9900903033] => 9900903033
[7349497600] => 7349497600
[9945661086] => 9945661086
[9483781462] => 9483781462
[9019498492] => 9019498492
[9901440956] => 9901440956
[9916079455] => 9916079455
[7892889348] => 7892889348
[8762759275] => 8762759275
[9483315302] => 9483315302
[9448965032] => 9448965032
[9740748980] => 9740748980
[9448690528] => 9448690528
[9449180267] => 9449180267
[9448147350] => 9448147350
[9620798833] => 9620798833
[9739944777] => 9739944777
[8762328892] => 8762328892
[9480019137] => 9480019137
[9449200138] => 9449200138
[9448876094] => 9448876094
[8277214230] => 8277214230
[9482557562] => 9482557562
[8970921668] => 8970921668
[9480413469] => 9480413469
[8762957836] => 8762957836
[7618735717] => 7618735717
[9480526752] => 9480526752
[9448833377] => 9448833377
[9483687231] => 9483687231
[9241010393] => 9241010393
[9448964169] => 9448964169
[9901318743] => 9901318743
[9008492731] => 9008492731
[8197981335] => 8197981335
[9483857796] => 9483857796
[9480701301] => 9480701301
[8762150005] => 8762150005
[7406830054] => 7406830054
[9019826137] => 9019826137
[9035709033] => 9035709033
[9481048833] => 9481048833
[7829909087] => 7829909087
[9986910684] => 9986910684
[8762654519] => 8762654519
[9483998320] => 9483998320
[9164393115] => 9164393115
[9483280828] => 9483280828
[9880179016] => 9880179016
[8277138579] => 8277138579
[9449158421] => 9449158421
[9916886681] => 9916886681
[8970675147] => 8970675147
[9480508374] => 9480508374
[8762654479] => 8762654479
[8310049975] => 8310049975
[8197985215] => 8197985215
[9448147828] => 9448147828
[9844259203] => 9844259203
[7483937249] => 7483937249
[9480439468] => 9480439468
[9482029473] => 9482029473
[9482699319] => 9482699319
[8105141888] => 8105141888
[9448579998] => 9448579998
[7899792266] => 7899792266
[9483199353] => 9483199353
[9901995427] => 9901995427
[8970497938] => 8970497938
[9164190880] => 9164190880
[9449263923] => 9449263923
[8618139407] => 8618139407
[9980427366] => 9980427366
)
after elastic new get data
after elastic get data
10-May-2025 04:42:25 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"140"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 140
)
)
gateway_id_arrs
Array
(
[0] => 140
)
before elastic get data
10-May-2025 04:42:25 pm
after elastic get data
10-May-2025 04:42:25 pm
before elastic get data
10-May-2025 04:42:25 pm
after elastic get data
10-May-2025 04:42:25 pm
before elastic get data
10-May-2025 04:42:25 pm
after elastic get data
10-May-2025 04:42:25 pm
SELECT * FROM `contacts_temp_group_35955` where group_id in(35955) group by mobile_number order by contact_id LIMIT 0,3
DND FILTERING YES
mobile no is dnd9980427366
mobile no is dnd9449263923
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38675` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38675','9449263923', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
10-May-2025 04:42:25 pm
after INSERT DETAIL
10-May-2025 04:42:25 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38675` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38675','8618139407', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
10-May-2025 04:42:25 pm
after INSERT DETAIL
10-May-2025 04:42:25 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38675` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38675','9980427366', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
10-May-2025 04:42:25 pm
after INSERT DETAIL
10-May-2025 04:42:25 pm
before UPDATE SUMMARY
10-May-2025 04:42:25 pm
after before UPDATE SUMMARY
10-May-2025 04:42:25 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.75652098655701
blacklist in micro sec 0.0019099712371826