Question
An application that will allow a user to search for and store a list of stocks, called their portfolio, for which they'd like to keep track. The application should use the standard dual-pane display mode, with a list displayed in one pane (Portfolio pane), and details displayed in the other (Stock Details pane).
Large screens and landscape layouts should display both panes simultaneously (dual-pane mode), while smaller screens in portrait mode should display one pane at a time (single-pane mode) starting with the navigation pane.

A user must be able to:

• Add a stock to their portfolio using the stock’s ticker symbol (e.g. GOOG for Alphabet)
◦ The Add function must be initiated from a Floating Action Button (FAB)
◦ The search interface should be presented to the user as an activity ideally formatted as a windowed dialog. The dialog will have an EditText to capture the stock symbol as well as 2 buttons to Add and Cancel respectively
◦ If the user attempts to enter a stock ticker symbol that doesn’t exist, they should be shown an error message using a Toast
◦ The search FAB must always be present regardless of if the device is displaying single or dual-pane mode.
• Have their portfolio persist across application restarts (the data must be saved to storage)
• View details of a stock when the user clicks on the stock from the list (see below)

The main interface of the application must implement fragments. The portfolio pane will display a list of stocks that the user has previously saved to their portfolio. It must display the ticker symbol and current price for each stock. Additionally, each stock ticker’s view must either have a green or red background depending on if the stock price is higher or lower for the day respectively (a stock that is the same as it’s opening price should be green).
They should be displayed in a ListView (or similar adapter view that allows seeing multiple stocks at once) that displays the stock symbol for each stock saved in the portfolio.

Selecting a stock from the portfolio pane will display details of that stock in the stock details pane. Those details must (at a minimum) include:

● The Company Name
● The 1 day stock chart
● The current stock price
● The opening stock price

When your application is running, it should continuously update all the stocks stored in a portfolio, even if a user is not currently looking at that stock. This must be done with a Worker Thread. The thread should be started once the application begins and continuously update the stock price in the background (update each stock every 1 minute or other reasonable interval). When the thread

receives an updated stock price, it should save the information to a file (portfolio_file). Nothing Else.

NOTE A regular ol’ worker thread exists past the lifecycle of the activity that created it, and holds an implicit reference to said activity. This means that whenever your activity restarts (for example, when the device is rotated from Portrait to Landscape, triggering a configuration change) the “old thread” is still running. Additionally, threads that never stop running are never garbage collected. These issues lead to the dreaded Memory Leak! You must ensure that any running thread is either killed and restarted whenever such events occur, or ensure that only one instance of your thread is ever running (Investigate private static threads). Regardless of your chosen approach, ensure that background threads are stopped entirely when your application exits (FYI, calling stop() on a thread has been deprecated since API Version 1 [it has always been a bad idea], so come up with another solution).

Whenever the worker thread updates portfolio_file, your application needs to react to this update by

a) displaying the updated stock information in the portfolio pane (updated colors and all), and
b) display updated stock information in the stock details pane if the stock being viewed has updated information

The be notified of changes to portfolio_file (remember, the worker thread only fetches updated portfolio information form the web and updates the file, it doesn’t directly notify anyone), your activity must monitor it for changes using a FileObserver object.

Whenever the user selects a stock from the portfolio pane, the activity should retrieve information about that stock from portfolio_file, and thereafter provide that information to the stock details pane. This way the user will always see the stock’s information instantly instead of having to fetch updated information from the web directly. Remember that as portfolio_file is updated by the worker thread, you must also have the stock details pane continuously show updated information for the displayed stock as well.
The only data the stock details fragment will not get directly from its parent activity directly is the stock chart. Instead, it should only receive the stock ticker (or the full stock image URL) which it will then use to fetch the stock chart and update its ImageView (see appendix ii).

Upon launch, if the application does not have any stocks saved, it should display a message in the navigation fragment instructing the user to add a stock. The message must be fixed (For instance, a textview inside the navigation fragment. You must not use a temporary message notification mechanism such as a Toast).

All string displayed to the user must be retrieved from a string resource. Additionally, there must be an additional string resource file in a non-English language of your choice.
Solution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references.
Students may use these solutions for personal skill-building and practice.
Unethical use is strictly forbidden.

public class StockListActivity extends AppCompatActivity {

    // Boolean to know if it needs to load the two pane or single pane layout
    private boolean mTwoPane;

    // This activity uses a background thread.
    // Its task is to get the stock information at regular interval of time
    private PortfolioWorkerThread workerThread;

    // A reference to shared preferences to store information
    SharedPreferences sharedpreferences;

    private String PREF = "portfolios";

    // Member variable of file observer object.
    private PortfolioFileObserver portfolioFileObserver;

    // Time to repeat the thread in every few seconds
    private Timer timer;
    private static TextView empty;

    // Broadcast receiver to listen to the event from the
    // file observer, ie. each time file observer receives the update in
    // file, it sends the event to this broadcast so that it can read and
    // display the updated information. This event is fired from PortfolioFileObserver class.
    private BroadcastReceiver listener = new BroadcastReceiver() {
       @Override
       public void onReceive(Context context, Intent intent ) {
            boolean hasChanged = intent.getBooleanExtra("hasChanged", false);
            if(hasChanged){
                readUpdatedSymbols();
            }
       }
    };

    // Adapter to hold the list content
    private SimpleItemRecyclerViewAdapter adapter;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
       super.onCreate(savedInstanceState);

       // if orientation is landscape and on large screen, it loads the two-pane layout.
       // otherwise, it loads the normal portrait single pane layour
       if(getResources().getConfiguration().orientation == Configuration.ORIENTATION_LANDSCAPE){
            setContentView(R.layout.activity_stock_list_land);
       }else {
            setContentView(R.layout.activity_stock_list);
       }
       Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
       setSupportActionBar(toolbar);
       toolbar.setTitle(getTitle());
This is only a preview of the solution.
Please use the purchase button to see the entire solution.
By purchasing this solution you'll be able to access the following files:
Solution.zip
Purchase Solution
$150.00 $75
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Computer Science Tutors 529 tutors matched
Ionut
(ionut)
Hi! MSc Applied Informatics & Computer Science Engineer. Practical experience in many CS & IT branches.Research work & homework
5/5 (5,654+ sessions)
2 hours avg response
Leo
(Leo)
Hi! I have been a professor in New York and taught in a math department and in an applied math department.
4.9/5 (5,652+ sessions)
2 hours avg response
Pranay
(math1983)
Ph.D. in mathematics and working as an Assistant Professor in University. I can provide help in mathematics, statistics and allied areas.
4.6/5 (5,512+ sessions)
1 hour avg response

Similar Homework Solutions

8.1.0PHP Version371msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (191ms)time
    • Application (180ms)time
    • 1 x Booting (51.57%)
      191ms
      1 x Application (48.43%)
      180ms
      • Illuminate\Routing\Events\Routing (1.06ms)
      • Illuminate\Routing\Events\RouteMatched (467μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.21ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (184μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (165μs)
      • Illuminate\Database\Events\ConnectionEstablished (912μs)
      • Illuminate\Database\Events\StatementPrepared (24.85ms)
      • Illuminate\Database\Events\QueryExecuted (1.17ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (86μs)
      • eloquent.booting: App\Models\Subject (93μs)
      • eloquent.booted: App\Models\Subject (41μs)
      • Illuminate\Database\Events\StatementPrepared (1.59ms)
      • Illuminate\Database\Events\QueryExecuted (1.28ms)
      • eloquent.retrieved: App\Models\Subject (103μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (115μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (62μs)
      • Illuminate\Database\Events\StatementPrepared (648μs)
      • Illuminate\Database\Events\QueryExecuted (742μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (67μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.booting: App\Models\SubjectCat (415μs)
      • eloquent.booted: App\Models\SubjectCat (37μs)
      • Illuminate\Database\Events\StatementPrepared (615μs)
      • Illuminate\Database\Events\QueryExecuted (863μs)
      • eloquent.retrieved: App\Models\SubjectCat (79μs)
      • Illuminate\Cache\Events\CacheHit (10.98ms)
      • Illuminate\Cache\Events\CacheMissed (207μs)
      • Illuminate\Database\Events\StatementPrepared (1.22ms)
      • Illuminate\Database\Events\QueryExecuted (2.83ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (97μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (16μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • Illuminate\Database\Events\StatementPrepared (771μs)
      • Illuminate\Database\Events\QueryExecuted (879μs)
      • eloquent.retrieved: App\Models\Subject (88μs)
      • Illuminate\Cache\Events\KeyWritten (731μs)
      • Illuminate\Database\Events\StatementPrepared (1.77ms)
      • Illuminate\Database\Events\QueryExecuted (1.07ms)
      • Illuminate\Database\Events\StatementPrepared (870μs)
      • Illuminate\Database\Events\QueryExecuted (2.43ms)
      • Illuminate\Database\Events\StatementPrepared (729μs)
      • Illuminate\Database\Events\QueryExecuted (1.04ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (61μs)
      • Illuminate\Cache\Events\CacheHit (417μs)
      • creating: homework.show (190μs)
      • composing: homework.show (76μs)
      • creating: components.breadcrumbs (179μs)
      • composing: components.breadcrumbs (98μs)
      • Illuminate\Database\Events\StatementPrepared (1.08ms)
      • Illuminate\Database\Events\QueryExecuted (1.03ms)
      • eloquent.retrieved: App\Models\SubjectCat (93μs)
      • Illuminate\Cache\Events\CacheMissed (3.65ms)
      • Illuminate\Database\Events\StatementPrepared (796μs)
      • Illuminate\Database\Events\QueryExecuted (809μs)
      • eloquent.retrieved: App\Models\SubjectCat (74μs)
      • Illuminate\Cache\Events\KeyWritten (366μs)
      • Illuminate\Cache\Events\CacheHit (276μs)
      • Illuminate\Cache\Events\CacheHit (244μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (302μs)
      • Illuminate\Cache\Events\CacheHit (299μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheMissed (2.09ms)
      • Illuminate\Database\Events\StatementPrepared (656μs)
      • Illuminate\Database\Events\QueryExecuted (1.15ms)
      • eloquent.retrieved: App\Models\SubjectCat (86μs)
      • Illuminate\Cache\Events\KeyWritten (717μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheMissed (155μs)
      • Illuminate\Database\Events\StatementPrepared (632μs)
      • Illuminate\Database\Events\QueryExecuted (842μs)
      • eloquent.retrieved: App\Models\SubjectCat (70μs)
      • Illuminate\Cache\Events\KeyWritten (1.37ms)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (597μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheMissed (139μs)
      • Illuminate\Database\Events\StatementPrepared (775μs)
      • Illuminate\Database\Events\QueryExecuted (886μs)
      • eloquent.retrieved: App\Models\SubjectCat (82μs)
      • Illuminate\Cache\Events\KeyWritten (331μs)
      • Illuminate\Cache\Events\CacheHit (1.5ms)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (374μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (707μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheMissed (144μs)
      • Illuminate\Database\Events\StatementPrepared (788μs)
      • Illuminate\Database\Events\QueryExecuted (793μs)
      • eloquent.retrieved: App\Models\SubjectCat (78μs)
      • Illuminate\Cache\Events\KeyWritten (1.04ms)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheMissed (208μs)
      • Illuminate\Database\Events\StatementPrepared (764μs)
      • Illuminate\Database\Events\QueryExecuted (921μs)
      • eloquent.retrieved: App\Models\SubjectCat (85μs)
      • Illuminate\Cache\Events\KeyWritten (316μs)
      • Illuminate\Cache\Events\CacheHit (1.27ms)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (253μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (960μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (305μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (353μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheMissed (299μs)
      • Illuminate\Database\Events\StatementPrepared (923μs)
      • Illuminate\Database\Events\QueryExecuted (872μs)
      • eloquent.retrieved: App\Models\SubjectCat (69μs)
      • Illuminate\Cache\Events\KeyWritten (1.43ms)
      • Illuminate\Cache\Events\CacheHit (301μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (827μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (744μs)
      • Illuminate\Cache\Events\CacheHit (808μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (3.39ms)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (239μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheMissed (143μs)
      • Illuminate\Database\Events\StatementPrepared (720μs)
      • Illuminate\Database\Events\QueryExecuted (818μs)
      • eloquent.retrieved: App\Models\SubjectCat (89μs)
      • Illuminate\Cache\Events\KeyWritten (1.61ms)
      • Illuminate\Cache\Events\CacheHit (239μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (655μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (323μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheMissed (222μs)
      • Illuminate\Database\Events\StatementPrepared (855μs)
      • Illuminate\Database\Events\QueryExecuted (998μs)
      • eloquent.retrieved: App\Models\SubjectCat (73μs)
      • Illuminate\Cache\Events\KeyWritten (1.19ms)
      • Illuminate\Cache\Events\CacheHit (379μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • creating: site.layouts.app (352μs)
      • composing: site.layouts.app (17μs)
      • creating: components.canonical (291μs)
      • composing: components.canonical (86μs)
      • creating: components.open-graph (130μs)
      • composing: components.open-graph (50μs)
      • creating: site.headers.header (379μs)
      • composing: site.headers.header (57μs)
      • Illuminate\Cache\Events\CacheHit (1.37ms)
      • creating: components.footer (67μs)
      • composing: components.footer (64μs)
      • Illuminate\Cache\Events\CacheHit (652μs)
      • Illuminate\Cache\Events\CacheMissed (274μs)
      • Illuminate\Database\Events\StatementPrepared (741μs)
      • Illuminate\Database\Events\QueryExecuted (1.1ms)
      • eloquent.retrieved: App\Models\SubjectCat (73μs)
      • Illuminate\Cache\Events\KeyWritten (4.72ms)
      • Illuminate\Cache\Events\CacheHit (373μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (411μs)
      • Illuminate\Cache\Events\CacheHit (270μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • creating: components.forms.contact-us (249μs)
      • composing: components.forms.contact-us (1.19ms)
      • creating: components.forms.get-started (346μs)
      • composing: components.forms.get-started (105μs)
      • creating: components.forms.free-tool-download (151μs)
      • composing: components.forms.free-tool-download (77μs)
      • creating: components.forms.claim-free-worksheet (4.27ms)
      • composing: components.forms.claim-free-worksheet (132μs)
      • creating: components.forms.tutor-subscription-waitlist (211μs)
      • composing: components.forms.tutor-subscription-waitlist (82μs)
      • creating: components.forms.tutor-subscription-join (139μs)
      • composing: components.forms.tutor-subscription-join (76μs)
      • creating: components.forms.tutor-support (128μs)
      • composing: components.forms.tutor-support (62μs)
      • 311 x Illuminate\Cache\Events\CacheHit (18.82%)
        69.83ms
        20 x Illuminate\Database\Events\StatementPrepared (11.26%)
        41.78ms
        20 x Illuminate\Database\Events\QueryExecuted (6.07%)
        22.53ms
        11 x Illuminate\Cache\Events\KeyWritten (3.73%)
        13.83ms
        11 x Illuminate\Cache\Events\CacheMissed (2.03%)
        7.53ms
        1 x creating: components.forms.claim-free-worksheet (1.15%)
        4.27ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.14%)
        4.21ms
        1 x composing: components.forms.contact-us (0.32%)
        1.19ms
        1 x Illuminate\Routing\Events\Routing (0.29%)
        1.06ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.26%)
        951μs
        1 x Illuminate\Database\Events\ConnectionEstablished (0.25%)
        912μs
        1 x Illuminate\Routing\Events\RouteMatched (0.13%)
        467μs
        1 x eloquent.booting: App\Models\SubjectCat (0.11%)
        415μs
        1 x creating: site.headers.header (0.1%)
        379μs
        1 x creating: site.layouts.app (0.09%)
        352μs
        1 x creating: components.forms.get-started (0.09%)
        346μs
        1 x creating: components.canonical (0.08%)
        291μs
        1 x creating: components.forms.contact-us (0.07%)
        249μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.06%)
        228μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.06%)
        211μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        191μs
        1 x creating: homework.show (0.05%)
        190μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        184μs
        10 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.05%)
        180μs
        1 x creating: components.breadcrumbs (0.05%)
        179μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        165μs
        1 x creating: components.forms.free-tool-download (0.04%)
        151μs
        1 x creating: components.forms.tutor-subscription-join (0.04%)
        139μs
        1 x composing: components.forms.claim-free-worksheet (0.04%)
        132μs
        1 x creating: components.open-graph (0.04%)
        130μs
        1 x creating: components.forms.tutor-support (0.03%)
        128μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        115μs
        1 x composing: components.forms.get-started (0.03%)
        105μs
        1 x composing: components.breadcrumbs (0.03%)
        98μs
        1 x eloquent.booting: App\Models\Subject (0.03%)
        93μs
        1 x composing: components.canonical (0.02%)
        86μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.02%)
        82μs
        1 x composing: components.forms.free-tool-download (0.02%)
        77μs
        1 x composing: homework.show (0.02%)
        76μs
        1 x composing: components.forms.tutor-subscription-join (0.02%)
        76μs
        1 x creating: components.footer (0.02%)
        67μs
        1 x composing: components.footer (0.02%)
        64μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.02%)
        62μs
        1 x composing: components.forms.tutor-support (0.02%)
        62μs
        1 x composing: site.headers.header (0.02%)
        57μs
        1 x composing: components.open-graph (0.01%)
        50μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        41μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        37μs
        1 x composing: site.layouts.app (0%)
        17μs
      14 templates were rendered
      • 1x homework.showshow.blade.phpblade
      • 1x components.breadcrumbsbreadcrumbs.blade.phpblade
      • 1x site.layouts.appapp.blade.phpblade
      • 1x components.canonicalcanonical.blade.phpblade
      • 1x components.open-graphopen-graph.blade.phpblade
      • 1x site.headers.headerheader.blade.phpblade
      • 1x components.footerfooter.blade.phpblade
      • 1x components.forms.contact-uscontact-us.blade.phpblade
      • 1x components.forms.get-startedget-started.blade.phpblade
      • 1x components.forms.free-tool-downloadfree-tool-download.blade.phpblade
      • 1x components.forms.claim-free-worksheetclaim-free-worksheet.blade.phpblade
      • 1x components.forms.tutor-subscription-waitlisttutor-subscription-waitlist.blade.phpblade
      • 1x components.forms.tutor-subscription-jointutor-subscription-join.blade.phpblade
      • 1x components.forms.tutor-supporttutor-support.blade.phpblade
      uri
      GET college-homework-library/{category}/{subject}/{id}
      middleware
      web, utm.parameters
      controller
      App\Http\Controllers\HomeworkLibraryController@show
      namespace
      where
      as
      homework.show
      file
      app/Http/Controllers/HomeworkLibraryController.php:79-176
      20 statements were executed, 5 of which were duplicates, 15 unique. Show only duplicated51.37ms
      • Connection Establishedtwenty4_siteHomeworkLibraryController.php#91
        Backtrace
        • 13. app/Http/Controllers/HomeworkLibraryController.php:91
        • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `solutionslibrary` where `status` = 'published' and `price` > 0 and `solutionslibrary`.`id` = '44550' limit 1
        25.29mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 44550
        Backtrace
        • 16. app/Http/Controllers/HomeworkLibraryController.php:97
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `subjects` where `subjects`.`id` in (419)
        1.48mstwenty4_siteHomeworkLibraryController.php#97
        Backtrace
        • 21. app/Http/Controllers/HomeworkLibraryController.php:97
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `solutionslibrary_files` where `solutionslibrary_files`.`solutionlib_id` in (44550)
        920μstwenty4_siteHomeworkLibraryController.php#97
        Backtrace
        • 21. app/Http/Controllers/HomeworkLibraryController.php:97
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `subject_cats` where `subject_cats`.`id` = 3 limit 1
        1.01mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 3
        Backtrace
        • 20. app/Models/HomeworkLibrary/HomeworkLibrary.php:201
        • 26. app/Http/Controllers/HomeworkLibraryController.php:105
        • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `solutionslibrary` where `id` <> 44550 and `subject` = 419 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        3.4mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 44550
        • 1: 419
        • 2: published
        • 3: 0
        Backtrace
        • 14. app/Repositories/HomeworkLibraryRepository.php:30
        • 15. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 16. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 18. app/Repositories/HomeworkLibraryRepository.php:39
        • 19. app/Http/Controllers/HomeworkLibraryController.php:139
      • select * from `subjects` where `subjects`.`id` in (419)
        1.13mstwenty4_siteHomeworkLibraryRepository.php#30
        Backtrace
        • 19. app/Repositories/HomeworkLibraryRepository.php:30
        • 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 23. app/Repositories/HomeworkLibraryRepository.php:39
        • 24. app/Http/Controllers/HomeworkLibraryController.php:139
      • select * from `solutionslibrary_files` where `solutionslibrary_files`.`solutionlib_id` = 44550 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.46mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 44550
        • 1: question
        Backtrace
        • 15. app/Models/HomeworkLibrary/HomeworkLibrary.php:260
        • 16. app/Transformers/HomeworkLibrary/HomeworkLibraryTransformer.php:58
        • 19. vendor/league/fractal/src/TransformerAbstract.php:128
        • 20. vendor/league/fractal/src/TransformerAbstract.php:107
        • 21. vendor/league/fractal/src/Scope.php:383
      • select * from `solutionslibrary_files` where `solutionslibrary_files`.`solutionlib_id` = 44550 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        2.7mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 44550
        • 1: teaser
        Backtrace
        • 15. app/Models/HomeworkLibrary/HomeworkLibrary.php:260
        • 16. app/Transformers/HomeworkLibrary/HomeworkLibraryTransformer.php:69
        • 19. vendor/league/fractal/src/TransformerAbstract.php:128
        • 20. vendor/league/fractal/src/TransformerAbstract.php:107
        • 21. vendor/league/fractal/src/Scope.php:383
      • select * from `solutionslibrary_files` where `solutionslibrary_files`.`solutionlib_id` = 44550 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.22mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 44550
        • 1: solution
        Backtrace
        • 15. app/Models/HomeworkLibrary/HomeworkLibrary.php:260
        • 16. app/Transformers/HomeworkLibrary/HomeworkLibraryTransformer.php:80
        • 19. vendor/league/fractal/src/TransformerAbstract.php:128
        • 20. vendor/league/fractal/src/TransformerAbstract.php:107
        • 21. vendor/league/fractal/src/Scope.php:383
      • select * from `subject_cats` where `subject_cats`.`id` = 3 limit 1
        1.1mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 3
        Backtrace
        • 20. app/Models/HomeworkLibrary/HomeworkLibrary.php:201
        • 32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 33. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 34. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `subject_cats` where `subject_cats`.`id` = 1 limit 1
        1.12mstwenty4_siteSubject.php#100
        Bindings
        • 0: 1
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 3 limit 1
        1.13mstwenty4_siteSubject.php#100
        Bindings
        • 0: 3
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 4 limit 1
        1.07mstwenty4_siteSubject.php#100
        Bindings
        • 0: 4
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 10 limit 1
        1.22mstwenty4_siteSubject.php#100
        Bindings
        • 0: 10
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 33 limit 1
        1.07mstwenty4_siteSubject.php#100
        Bindings
        • 0: 33
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 11 limit 1
        1.15mstwenty4_siteSubject.php#100
        Bindings
        • 0: 11
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 5 limit 1
        1.24mstwenty4_siteSubject.php#100
        Bindings
        • 0: 5
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 34 limit 1
        1.04mstwenty4_siteSubject.php#100
        Bindings
        • 0: 34
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 31 limit 1
        1.33mstwenty4_siteSubject.php#100
        Bindings
        • 0: 31
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 36 limit 1
        1.29mstwenty4_siteSubject.php#100
        Bindings
        • 0: 36
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 28. view::components.footer:170
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      10HomeworkLibraryFile.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          n0Sw10n5NfRIxCEWBAH7o49R1oqy7mKHMR5HvBGZ
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/App-Development/44550
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Scienc...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/Computer-Science/App-Development/44550
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:21 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-680c4a84-13f52bae1ff7c1864e123f03" ] "host" => array:1 [ 0 => "staging.dev.24houranswers.com" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-forwarded-for" => array:1 [ 0 => "52.15.174.200" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 26 Apr 2025 02:52:53 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik5HbzdzY1hLZ2VmSUw4MERjcWxCeXc9PSIsInZhbHVlIjoiYks1OVlSSkpyUmlIL0NDRlhSOXJvRlBCV2RoWW8razJYVHhoUGlsZ2RYK1lZOW9NdnpjUVI4eFJoNEhIblVTQThCRkhPSncrUy9aU0NOSXJDL2JmSTYzU1JPYUM2UE96N0FLRG5Za1dtbGp1ZXpvL0d4Z1EzNlg4V3dVdDJmRWIiLCJtYWMiOiIxMmQyYzAwMWRmMDE4NGUxZWZjZTNiZTZkMDU0ZjcxOWU2YTBkOTY0Yzc0NDE3OGVkMzI3MTFiZWE3MDg5NGI4IiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 04:52:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6Ik5HbzdzY1hLZ2VmSUw4MERjcWxCeXc9PSIsInZhbHVlIjoiYks1OVlSSkpyUmlIL0NDRlhSOXJvRlBCV2RoWW8razJYVHhoUGlsZ2RYK1lZOW9NdnpjUVI4eFJoNEhIblVTQThCRkhPS" 1 => "24houranswers_session=eyJpdiI6Iml3MzNpeFNtRVNTSFFmVU1ha3BSWEE9PSIsInZhbHVlIjoiQ2NuUjFRdEx6TGFQS3Z0bk9neE9YaFpMQ1RidnF5cWNLVTRicVhLS2lnalI5Z055bm1ZWW1RaUoxTkw2MVpiOVhZbXZDNXhhaGFsMVFRK2VnU0VSdkdCYmphQjYrUkFGNHJyQzlDMXc4a1hKT1ZEWjNKelF6YmVReHNURlNlV0EiLCJtYWMiOiJiYWJmZTUyYWY2MzdkOTliYjgzMWVmYTlhNDc3NzcxOWU3YTJlZmZlOWU5NzFhMzAwNGE3NTdjM2M4ZmUzNmFjIiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 04:52:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6Iml3MzNpeFNtRVNTSFFmVU1ha3BSWEE9PSIsInZhbHVlIjoiQ2NuUjFRdEx6TGFQS3Z0bk9neE9YaFpMQ1RidnF5cWNLVTRicVhLS2lnalI5Z055bm1ZWW1RaUoxTkw2MV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik5HbzdzY1hLZ2VmSUw4MERjcWxCeXc9PSIsInZhbHVlIjoiYks1OVlSSkpyUmlIL0NDRlhSOXJvRlBCV2RoWW8razJYVHhoUGlsZ2RYK1lZOW9NdnpjUVI4eFJoNEhIblVTQThCRkhPSncrUy9aU0NOSXJDL2JmSTYzU1JPYUM2UE96N0FLRG5Za1dtbGp1ZXpvL0d4Z1EzNlg4V3dVdDJmRWIiLCJtYWMiOiIxMmQyYzAwMWRmMDE4NGUxZWZjZTNiZTZkMDU0ZjcxOWU2YTBkOTY0Yzc0NDE3OGVkMzI3MTFiZWE3MDg5NGI4IiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 04:52:53 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6Ik5HbzdzY1hLZ2VmSUw4MERjcWxCeXc9PSIsInZhbHVlIjoiYks1OVlSSkpyUmlIL0NDRlhSOXJvRlBCV2RoWW8razJYVHhoUGlsZ2RYK1lZOW9NdnpjUVI4eFJoNEhIblVTQThCRkhPS" 1 => "24houranswers_session=eyJpdiI6Iml3MzNpeFNtRVNTSFFmVU1ha3BSWEE9PSIsInZhbHVlIjoiQ2NuUjFRdEx6TGFQS3Z0bk9neE9YaFpMQ1RidnF5cWNLVTRicVhLS2lnalI5Z055bm1ZWW1RaUoxTkw2MVpiOVhZbXZDNXhhaGFsMVFRK2VnU0VSdkdCYmphQjYrUkFGNHJyQzlDMXc4a1hKT1ZEWjNKelF6YmVReHNURlNlV0EiLCJtYWMiOiJiYWJmZTUyYWY2MzdkOTliYjgzMWVmYTlhNDc3NzcxOWU3YTJlZmZlOWU5NzFhMzAwNGE3NTdjM2M4ZmUzNmFjIiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 04:52:53 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6Iml3MzNpeFNtRVNTSFFmVU1ha3BSWEE9PSIsInZhbHVlIjoiQ2NuUjFRdEx6TGFQS3Z0bk9neE9YaFpMQ1RidnF5cWNLVTRicVhLS2lnalI5Z055bm1ZWW1RaUoxTkw2MV" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "n0Sw10n5NfRIxCEWBAH7o49R1oqy7mKHMR5HvBGZ" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/App-Development/44550" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/App-Development/44550" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]