MovieDatabase | An application that demonstrates the use

Like title I can't get correct item data, now imagine I have 2 recycler view list on my main fragment, one recycler view is vertical, other horizontal. If I use only one recycler everything is working fine. But when I add other one it's opening items randomly, but that random data openings only random both recyclers positions. Like my first recycler have [a,b,c,d] , other recycler have [e,f,g,h]. When I click first item of first recycler its go to other fragment which shows detail, its opening e instead of a, if I go back and retry it, its opening e again, retry and its a !! so its opening randomly, why this is happening why can't I open correct data? I put Log.d on my adapters and when I click recycler items, adapters log says u clicked "a" but my detail fragment shows me data of "e". What I am doing wrong? Here is my codes:(I have lots of codes so I share what we need)

my databases TvDAO:

Ín my app's room database I have a table called movie_table. When the user clicks the item, it is saved to another table called favorite_table. I tried almost two days but I can't solve it. I am new to MVVM. For better understanding please see the code:

FavoriteMovieDao.kt

In my app I have a model class, it has some variables, I can call and show this data in this app using retrofit and room DB. which means this app first collects data from the server then it shows in room DB. But when I am using the list in this model class it shows this error. Here is my code

Movie.kt

In my app firstly i am fetching data from server using retrofit then it's saved in room database table then it shows in recyclerview but when i using a id as a primary key it's show only one data then this id i annotat autoGenerate = true then it's show all data which i put in server but when i reopen my app,it's show double data(this mean firstly i have 3 data in server,this app show 3 data but when i reopen or refresh my database it's show 6 data ,every time in refresh it's increasing).but i want this id will be increase but data will be not increase that's mean server have 3 data and it's store in room database table.

Movie.kt

Im using bottom navigation view with hide_bottom_view_on_scroll_behavior. When user selects item from first fragment list app goes to detail fragment.I want to show bottom navigation view if its hidden in that (detail) fragment.

Main activity xml:

I am creating a site using the moviedatabase API in React. (https://developers.themoviedb.org/3)

I have created a button where users can click to add the id of the movie they are looking at to an array of movie id's which is stored in localstorage.

On the 'to watch' page i can use this code to get the information for 1 movie from the array by stating the index number movies[0] but i want to map/ for loop all the ids stored in local storage. How can i do this ?

I have 2 fragments in view pager.They both start to make network requests at the same time.I want to speed up first fragment by delaying second until the first loads the data.How can i do that? Im coding in java.

Edit: When both fragments loads the data it takes additional 2 seconds to finish loading first fragment compared to when i make network request only with first fragment(when testing) because view pager loads both tabs at the same time.

Edit2: found same question at: link One answer suggests creating interface for the first fragment.

the error is in tbody and with map function. code :

First time posting a question and I'm a coding noob so sorry if I do something wrong.

I check around and found one answer which is somewhat similar to my question: When / How to Create / Destroy Room Database

However I am not using dagger, nor do I know how to use it.

I wanted to ask when should you build your room database instance? Suppose my app uses the database throughout, should I build it in the OnCreate of the Main Activity? Or should I only build it once the users tries to access some functionality that requires it?

This is the code in question: