Question
Creating Graphical User Interfaces can be complex and ridden with little nuances that often escape the new GUI developer. Especially when using an IDE to develop code, the ease of point and click graphics and widgets can appear simple to the user but in fact, behind the scenes, the IDE is actually generating a lot of support code. Netbeans has an awesome built in GUI editor that is WYSIWYG but the code it generates is hard to read and even harder to maintain. However, it does make generating a GUI fairly quick and painless once you know a few little tricks. So this week, you are going to use the class notes which will walk you through generating one small piece of your application using the built in GUI editor and one other small piece without the editor. After you complete both of these exercises, you will have the beginning of a user interface for your application. Once you have had a chance to try both methods of generating user interface code, you can decide which method you will use to complete the user interface. You can use just one or a combination of both. Since both methods generate Java class files, they will all be able to work together, regardless of the method you used to generate them. Although it takes more time to generate code by hand, one big advantage to creating your classes without the use of the WYSIWYG editor is that you have written all the code yourself so it will be easier to read, understand and maintain.
Attached to this lecture is a link to a video tutorial that demonstrates using the Netbeans built in GUI editor to generate a class that will be used for a user interface. This tutorial will walk through creating an input form for adding classrooms and a report form for viewing available classrooms. I suggest tackling one method for generating GUI code at a time, to completion before trying the second method. I will leave it up to you to decide which method you will try first.

Chapter 11 in the text book describes how to design a graphical user interface using the built in Java classes in the the library known as "Swing". There are hundreds of third party libraries that can be used to generate a user interface. I have chosen the Swing library because it is built into the language and there is a lot of support for it. Also, the built in Netbeans GUI editor provides a toolkit of all the widgets and controls in the Swing library. Chapter 11 also goes into great detail regarding the event handling in the UI. We won't be tackling event handling this week so you are welcome to skip over those sections for now and focus on generating the windows.
There's a lot to learn in Swing. Don't worry if you feel a bit overwhelmed by it. You aren't expected to become a Swing expert in six weeks. But you will become familiar with the basic Swing classes you will need to develop a simple GUI application that you can build on later.
The online notes are intended to supplement the text book and provide another example in addtion to the source code from the text book.
Attached to this week's homework assignment is a sample application which you can use to get started. This starter code will have the input and report windows implemented for a single class type, both using the Netbeans GUI editor as well as created manually

A Little GUI History


Java was first released with a set a classes that allowed a programmer to create portable GUI applications. This set of classes is called the Abstract Windowing Toolkit (AWT). The AWT was not well received by the developer community because it was buggy and did not allow the development of a rich graphical interface.

AWT uses the current operating system's native set of graphical components. Since all platforms did not support the same set of GUI components, the AWT could only support a subset of all of the graphical components available. As a result many of the fancy and powerful graphical widgets were left out of AWT. It was clear that a better graphical framework was needed. As a result, the Java Foundation Classes (JFC), better known as Swing, was created and included as part of the JDK (starting with version 1.2).

Swing was implemented differently than AWT. Instead of relying on the underlying operating system to provide the graphical widgets, Swing creates all of its widgets from scratch. This allowed Swing to support a full set of widgets because it did not have to restrict itself to the least common set. In addition, the look and feel of its widgets could be the same on all platforms. The drawback to this approach is performance. Since Swing is responsible for drawing all of its components, it is slower then AWT. However, many recent improvements and faster hardware are making Swing faster each and every day.

So which GUI framework should you use? Until recently, applets written using Swing were almost guaranteed not to run properly in web browsers.    Because of this, applets continued to be developed using AWT which limited their look and feel. Today, this is not usually a factor since most web browsers can support Swing and since applications written in Swing are much richer visually, it makes sense to program in Swing. One caveat, the underlying event handling mechanism which Swing uses is still based on the original event handling classes in the AWT. The developers of Swing didn't implement a new set of event handling classes. Therefore, it is imperative that you learn about the AWT even if you aren't planning on implementing AWT graphical components.

Let's get started with the concept of Containers by learning about the most important one, the JFrame


Report Card Application


The best way to learn GUI programming is by looking at examples. So let's get started with an example. If you remember back in the collection lecture we created some code that would generate a grade for a student and print their grade. What if we were to create a graphical front end for this code so that we could add the grades via an input window and then display the grades in a report window? The goal of this lecture is to build a graphical user interface for this report card program. Download the source code here.


The first step in building a GUI application is to create a main window. In Swing, a main window is called a frame. The Swing class we will use is the JFrame. To build a main window for our report card application we need to import the associated Swing packages, and then create a class that extends the Swing JFrame. Let's get started by creating a class called ReportCard.

import javax.swing.*;
import java.awt.event.*;

public class ReportCard extends JFrame {



public static void main(String args[]) {
ReportCard frame = new ReportCard();
}

public ReportCard() {

// Initially set the frame to 400x400 pixels wide.
// The user can resize the frame later if they like.
setSize(400,400);

// Set the title of the frame
setTitle("Report Card Maker - UML Java Course");

// make the frame visible
setVisible(true);
}
}



As you can see most of the interesting code that generates the window is in the constructor. The constructor sets the initial size for the frame, sets the frame's title, addes visual elements to the windows, and finally it displays it. All of this is done by calling methods that were inherited from the JFrame class. The class above doesn't have any visual elements yet. If you were to run this class, all you would see is an empty window. The next section will demonstrate adding elements to the window.


It is now time to add some user interface Components to our main frame. In Swing, Frames are Containers and Containers "contain" Components. There are many user interface Components that are part of the Swing library. The Components we will need for our report card depend on the program's input and output requirements.

The report card program takes two inputs: the name of a student, and a set of grades. Well, technically, the set of grades is actually 5 individual text inputs for the sake of simplicity, we will think of the grades as a single set. In our user interface, we can allow the user to specify these inputs using the Swing library JTextField class. In addition, we can add a button that the user can click on in order to generate the final grade. Finally, our report card program can display the final grade in the main window. Here is a mock up of what our application will look like:



In summary, we will need the following user interface Components:

    Name input field - this will contain the name of the student. It will be represented using a Swing JTextField.
    Grade input fields - these will contain the input grades. They will also be represented using a Swing JTextField.
    Button - the user can click on this button to generate the final grade. It will be represented using a Swing JButton.

The window will initially display with a default size but the user can make the window larger or smaller. Although your Components may move around, their relative locations always remain the same. This is the result of using layout managers to manage window sizing events. Layout managers are Java classes that are created and attached to JFrame and JPanel objects and are used to manage their display properties.

This functionality was added to Swing in order to make Java applications more portable. LayoutManagers make it easier to build screens that adjust based on the current screen resolution. Much like HTML, a Java interface screen can adjust on the fly based the current platform's display properties. In addition to making applications more portable, LayoutManagers can also make it easier to create well organized interface screens.

LayoutManagers are another good example of how Design Patterns are used in Swing. LayoutManagers are an excellent example of the Strategy pattern. In the Strategy pattern a family of algorithms can vary independently from the clients that use them. By plugging in different strategies for laying out a container's contents, you can change the layout without affecting the rest of the code.

Java comes with several different types of LayoutManagers. In this lecture we will be looking at the BorderLayout. BorderLayouts allow you to add Components to the north, south, east, west, and center regions of a Container. As the Container resizes the Components remain "glued" to the specified region. The BorderLayout is my favorite layout manager becuase it is powerful and easy to use.

You can specify a Container's LayoutManager by calling the setLayout() method. In order to get our main window to use a BorderLayout all we have to do is add one line to the constructor.

    public ReportCard {
       addWindowListener(new FrameExitHandler());
       setSize(400,400);
       setTitle("Report Card Maker - UML Java Course");
      
       setLayout(new BorderLayout());
      
       setVisible(true);
    }

The real power of layout managers can be achieved when you combine them with JPanels. JPanels can be used to split a Container into sections just like our report card program contains a panel for the output and a panel for the input. This can be done by adding a JPanel to a specific region of a Container. The best way to demonstrate this is with an example. Let's start by dividing our main window into two sections, a center section and a bottom section. We can do this by adding two JPanels to our main window.

       // Create the input panel that will contain the student name and the grades
       // and the button
       JPanel inputPanel = new JPanel();

       // Set the layout of the panel to be a grid with one column and 7 rows
       inputPanel.setLayout(new GridLayout(7, 1));

       // Add the panel to the window
       getContentPane().add(inputPanel, BorderLayout.CENTER);

       // Create the panel that will contain the final grade output
       JPanel finalGradePanel = new JPanel();

       // Set the layout of the panel to be a grid with one row, 1 column
       finalGradePanel.setLayout(new GridLayout(1, 1));

       getContentPane().add(finalGradePanel, BorderLayout.SOUTH);

Notice that we create the JPanel, set its layout manager and then we add the JPanel to the appropriate region of the main window. These methods should be called from the constructor.

Notice how we created two new JPanels and we added them to the northern and southern regions of the topPanel. This essentially divides the top red panel into two sub-sections, a green one to the north and a yellow one to the south.

Adding Elements


Now that we have the JPanels added to our window, it's time to add the elements. The input and ouput text fields and the button.


As I mentioned in the last section, the report card program takes 2 inputs, a student name, and a set of grades and outputs a final grade. The first thing we need to do is to declare all the elements that will be on the form. We do this at the top of the class file with the following:

    JTextField name;
    JTextField grade1;
    JTextField grade2;
    JTextField grade3;
    JTextField grade4;
    JTextField grade5;
    JTextField finalGrade;
    JButton generateGradesButton;

Notice that the elements are declared along with their data type but unlike our backend classes, these elements don't get created (instantiated) until the constructor method is called. The code snippet below from the constructor method demonstrates how to create and add the input elements to the input panel. As you can see, each element contains some starting default text that can be replaced by the user:

       name = new JTextField("Student Name");
       inputPanel.add(name);

       grade1 = new JTextField("Grade 1");
       inputPanel.add(grade1);

       grade2 = new JTextField("Grade 2");
       inputPanel.add(grade2);

       grade3 = new JTextField("Grade 3");
       inputPanel.add(grade3);

       grade4 = new JTextField("Grade 4");
       inputPanel.add(grade4);

       grade5 = new JTextField("Grade 5");
       inputPanel.add(grade5);      

Next will add the input button. Notice that the input button is also added to a row in the input panel grid:

       generateGradesButton = new JButton("Generate Grade");
       inputPanel.add(generateGradesButton);

The last element we will add is the output text field to the output panel.


       finalGrade = new JTextField("Final Grade");
       finalGradePanel.add(finalGrade);

Notice an additional line of code for the final grade field which makes this field uneditable by the user:

       finalGrade.setEditable(false);

Once again, our final application window looks like this:
ReportCardWindow

In the next section, we will look at how the grades are read from the form and the final grade is computed and displayed.


Handling Events


The final step in the creation of our application is to write the event handling code. Our application only has to handle one Event, we need to know when the user clicks on the "Generate Grade" Button. When this event occurs, we need to read the grades from the form and generate a final grade. As we learned earlier in this lecture, Events are handled using listeners. If you link a listener object with a control object - like a button, the listener will be notified when an something happens (i.e the buttonis clicked). In our case we need to know when the "Generate Grade" Button is clicked. As a result, we need to create a listener and link it with the generateGradesButton we defined in our class. Below is the code that create an instance of the ButtonHandler class and it with the button.

ButtonHandler buttonHandler = new ButtonHandler();

generateGradesButton.addActionListener(buttonHandler);

Now we need to define the button handler. The button handler will be a private internal class in the ReportCard class and will look like this:

private class ButtonHandler implements java.awt.event.ActionListener {

            public void actionPerformed(java.awt.event.ActionEvent evt) {
                // Retrieve all the grades from the input form
                // The grades on the form are text fields so we have to convert
                // them to float data type
                String grade1Text = grade1.getText();
                float grade1Value = Float.parseFloat(grade1Text);
                String grade2Text = grade2.getText();
                float grade2Value = Float.parseFloat(grade2Text);
                String grade3Text = grade3.getText();
                float grade3Value = Float.parseFloat(grade3Text);
                String grade4Text = grade4.getText();
                float grade4Value = Float.parseFloat(grade4Text);
                String grade5Text = grade5.getText();
                float grade5Value = Float.parseFloat(grade5Text);

                // Calculate the average grade
                float result = (grade1Value + grade2Value + grade3Value + grade4Value + grade5Value) / 5;
               
                // Convert the result to a string and display in the final grade field on the form
                finalGrade.setText(String.valueOf(result));
            }
   }

Notice that this class implements an interface. Just like your some of your backend classes! If you look at this interface in the Java documentation you will see that it contains a single method - actionPerformed. Here we provide the method definition - the same way you provided the method definitions for your backend classes.

And that's it, our report card program with graphical user interface is done!
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.

package Test;

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionListener;
import javax.swing.*;
import view.*;

/**
*
* @author
*/
public class TestClass extends JFrame {
   
    private JLabel inputForms = new JLabel("            INPUT FORMS");
    private JLabel reportForms = new JLabel("          REPORT FORMS");
    private JButton stInputFormButton = new JButton("Student Input Form");
    private JButton stReportFormButton = new JButton("Student Report Form");
    private JButton facInputFormButton = new JButton("Faculty Input Form");
    private JButton facReportFormButton = new JButton("Faculty Report Form");
    private JButton classInputFormButton = new JButton("Clasroom Input Form");
    private JButton classReportFormButton = new JButton("Clasroom Report Form");
    private JButton courseInputFormButton = new JButton("Course Input Form");
    private JButton courseReportFormButton = new JButton("Course Report Form");

    public TestClass() {

       // set the window to 800x500 pixels wide and location (100,100).
       setSize(1000, 600);
       setLocation(50, 50);

       // Close window when exit button clicked
       setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

       // Panel to house the buttons
       JPanel mainPanel = new JPanel();
       mainPanel.setLayout(new GridLayout(6,2,10,10));
       // Set the title of the window
       setTitle("Test CLass");

       // Set the layout of the window
       setLayout(new BorderLayout());

       // Create a listener object and add it to the buttons
       // Notice how we refer to this inner class
       TestClass.ButtonHandler listener = new TestClass.ButtonHandler();
       stInputFormButton.addActionListener(listener);
       stReportFormButton.addActionListener(listener);
       facInputFormButton.addActionListener(listener);
       facReportFormButton.addActionListener(listener);
       classInputFormButton.addActionListener(listener);
       classReportFormButton.addActionListener(listener);
       courseInputFormButton.addActionListener(listener);
       courseReportFormButton
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
$15.00
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available IT Computer Support Services 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 Version314msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (190ms)time
    • Application (124ms)time
    • 1 x Booting (60.61%)
      190ms
      1 x Application (39.39%)
      124ms
      • Illuminate\Routing\Events\Routing (904μs)
      • Illuminate\Routing\Events\RouteMatched (410μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.45ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (175μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (180μs)
      • Illuminate\Database\Events\ConnectionEstablished (813μs)
      • Illuminate\Database\Events\StatementPrepared (16.75ms)
      • Illuminate\Database\Events\QueryExecuted (2.36ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (122μs)
      • eloquent.booting: App\Models\Subject (121μs)
      • eloquent.booted: App\Models\Subject (44μs)
      • Illuminate\Database\Events\StatementPrepared (2.08ms)
      • Illuminate\Database\Events\QueryExecuted (1.99ms)
      • eloquent.retrieved: App\Models\Subject (126μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (136μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (43μs)
      • Illuminate\Database\Events\StatementPrepared (834μs)
      • Illuminate\Database\Events\QueryExecuted (1.39ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (133μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (25μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.booting: App\Models\SubjectCat (2.33ms)
      • eloquent.booted: App\Models\SubjectCat (73μs)
      • Illuminate\Database\Events\StatementPrepared (994μs)
      • Illuminate\Database\Events\QueryExecuted (1.16ms)
      • eloquent.retrieved: App\Models\SubjectCat (164μs)
      • Illuminate\Cache\Events\CacheHit (12.95ms)
      • Illuminate\Cache\Events\CacheMissed (206μs)
      • Illuminate\Database\Events\StatementPrepared (2.36ms)
      • Illuminate\Database\Events\QueryExecuted (3.88ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (100μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (16μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • Illuminate\Database\Events\StatementPrepared (976μs)
      • Illuminate\Database\Events\QueryExecuted (1.56ms)
      • eloquent.retrieved: App\Models\Subject (127μs)
      • Illuminate\Cache\Events\KeyWritten (1.65ms)
      • Illuminate\Database\Events\StatementPrepared (2.34ms)
      • Illuminate\Database\Events\QueryExecuted (1.06ms)
      • Illuminate\Database\Events\StatementPrepared (852μs)
      • Illuminate\Database\Events\QueryExecuted (1.17ms)
      • Illuminate\Database\Events\StatementPrepared (1.16ms)
      • Illuminate\Database\Events\QueryExecuted (1.13ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (95μs)
      • Illuminate\Cache\Events\CacheHit (720μs)
      • creating: homework.show (305μs)
      • composing: homework.show (147μs)
      • creating: components.breadcrumbs (284μs)
      • composing: components.breadcrumbs (138μs)
      • Illuminate\Database\Events\StatementPrepared (1.9ms)
      • Illuminate\Database\Events\QueryExecuted (961μs)
      • eloquent.retrieved: App\Models\SubjectCat (94μs)
      • Illuminate\Cache\Events\CacheHit (2.97ms)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (92μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (90μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (92μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (631μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (92μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (90μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (632μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (90μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • creating: site.layouts.app (374μs)
      • composing: site.layouts.app (16μs)
      • creating: components.canonical (478μs)
      • composing: components.canonical (82μs)
      • creating: components.open-graph (143μs)
      • composing: components.open-graph (49μs)
      • creating: site.headers.header (213μs)
      • composing: site.headers.header (47μs)
      • Illuminate\Cache\Events\CacheHit (1.33ms)
      • creating: components.footer (77μs)
      • composing: components.footer (73μs)
      • Illuminate\Cache\Events\CacheHit (642μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • creating: components.forms.contact-us (208μs)
      • composing: components.forms.contact-us (106μs)
      • creating: components.forms.get-started (115μs)
      • composing: components.forms.get-started (44μs)
      • creating: components.forms.free-tool-download (86μs)
      • composing: components.forms.free-tool-download (40μs)
      • creating: components.forms.claim-free-worksheet (82μs)
      • composing: components.forms.claim-free-worksheet (38μs)
      • creating: components.forms.tutor-subscription-waitlist (123μs)
      • composing: components.forms.tutor-subscription-waitlist (46μs)
      • creating: components.forms.tutor-subscription-join (85μs)
      • composing: components.forms.tutor-subscription-join (38μs)
      • creating: components.forms.tutor-support (81μs)
      • composing: components.forms.tutor-support (39μs)
      • 321 x Illuminate\Cache\Events\CacheHit (18%)
        56.48ms
        10 x Illuminate\Database\Events\StatementPrepared (9.64%)
        30.24ms
        10 x Illuminate\Database\Events\QueryExecuted (5.31%)
        16.67ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.42%)
        4.45ms
        1 x eloquent.booting: App\Models\SubjectCat (0.74%)
        2.33ms
        1 x Illuminate\Cache\Events\KeyWritten (0.53%)
        1.65ms
        1 x Illuminate\Routing\Events\Routing (0.29%)
        904μs
        1 x Illuminate\Database\Events\ConnectionEstablished (0.26%)
        813μs
        1 x creating: components.canonical (0.15%)
        478μs
        1 x Illuminate\Routing\Events\RouteMatched (0.13%)
        410μs
        1 x creating: site.layouts.app (0.12%)
        374μs
        9 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.1%)
        311μs
        1 x creating: homework.show (0.1%)
        305μs
        1 x creating: components.breadcrumbs (0.09%)
        284μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.08%)
        266μs
        2 x eloquent.retrieved: App\Models\SubjectCat (0.08%)
        258μs
        2 x eloquent.retrieved: App\Models\Subject (0.08%)
        253μs
        1 x creating: site.headers.header (0.07%)
        213μs
        1 x creating: components.forms.contact-us (0.07%)
        208μs
        1 x Illuminate\Cache\Events\CacheMissed (0.07%)
        206μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.06%)
        180μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.06%)
        175μs
        1 x composing: homework.show (0.05%)
        147μs
        1 x creating: components.open-graph (0.05%)
        143μs
        1 x composing: components.breadcrumbs (0.04%)
        138μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.04%)
        136μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.04%)
        123μs
        1 x eloquent.booting: App\Models\Subject (0.04%)
        121μs
        1 x creating: components.forms.get-started (0.04%)
        115μs
        1 x composing: components.forms.contact-us (0.03%)
        106μs
        1 x creating: components.forms.free-tool-download (0.03%)
        86μs
        1 x creating: components.forms.tutor-subscription-join (0.03%)
        85μs
        1 x composing: components.canonical (0.03%)
        82μs
        1 x creating: components.forms.claim-free-worksheet (0.03%)
        82μs
        1 x creating: components.forms.tutor-support (0.03%)
        81μs
        1 x creating: components.footer (0.02%)
        77μs
        1 x eloquent.booted: App\Models\SubjectCat (0.02%)
        73μs
        1 x composing: components.footer (0.02%)
        73μs
        1 x composing: components.open-graph (0.02%)
        49μs
        1 x composing: site.headers.header (0.02%)
        47μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        46μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        44μs
        1 x composing: components.forms.get-started (0.01%)
        44μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        43μs
        1 x composing: components.forms.free-tool-download (0.01%)
        40μs
        1 x composing: components.forms.tutor-support (0.01%)
        39μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        38μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        38μs
        1 x composing: site.layouts.app (0.01%)
        16μ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
      10 statements were executed, 4 of which were duplicates, 6 unique. Show only duplicated35.3ms
      • 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` = '41275' limit 1
        17.91mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 41275
        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 (442)
        2.13mstwenty4_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 (41275)
        1.47mstwenty4_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` = 33 limit 1
        1.28mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 33
        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` <> 41275 and `subject` = 442 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        5.38mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 41275
        • 1: 442
        • 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 (442)
        1.91mstwenty4_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` = 41275 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.11mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 41275
        • 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` = 41275 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.34mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 41275
        • 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` = 41275 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.36mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 41275
        • 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` = 33 limit 1
        1.41mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 33
        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
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      9HomeworkLibraryFile.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
      App\Models\SubjectCat
      2SubjectCat.php
          _token
          Hd1PljgBBMcFPTGlMtI0XeTbQr7Cf8JCl3SGxvvr
          utm_source
          direct
          redirectUrl
          /college-homework-library/IT-Computer-Support-Services/IT-Computer-Support-Services-Other/41275
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/IT-Computer-Sup...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/IT-Computer-Support-Services/IT-Computer-Support-Services-Other/41275
          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-680f6213-36ce6dcc6a58d0df00e35956" ] "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 => "18.117.232.238" ] "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 => "Mon, 28 Apr 2025 11:10:12 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IktyNnRCL0tjRnFDR3BEbGhpcFNRRGc9PSIsInZhbHVlIjoiNWx3d2d2SGNtOFFXeHgvbEZhdlFSVHN4TkIwdmRrajkvSk9ncjArZm1mektGWTlqQ2QrVFJqS0d4VSt5Rkt5RThETEV3U05wcGJKRkdnUWRvNDdQODRQTHNlZFZ3bnVnNmMrTXp3dU1YNitxR09VRGhUOThkSFRkM2wvUlVFbE8iLCJtYWMiOiJkMzUyNzQxOTA0NmFiMTFjYWFlMTk2Mzc0NzI4MTRkZDVmOTVkM2Q3MGVjMGYxMzk3YTQzNzgxMTEwZDRkNjc4IiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 13:10:12 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6IktyNnRCL0tjRnFDR3BEbGhpcFNRRGc9PSIsInZhbHVlIjoiNWx3d2d2SGNtOFFXeHgvbEZhdlFSVHN4TkIwdmRrajkvSk9ncjArZm1mektGWTlqQ2QrVFJqS0d4VSt5Rkt5RThETEV3U" 1 => "24houranswers_session=eyJpdiI6IkhHYnpzdFlFYkpXTzBja05TS2VNc0E9PSIsInZhbHVlIjoiRllBdTEvbWhVcmlsNGtOUHJtbUg5dm5heXBtMkVPTEIydnVPTGdQMUpPSkpjMUFnbkp1R0dnWTk3ZDArT0Y0d3VZMFZUZHVaUzJpaDhxOVIyRWJKL0l3cWFMQjI3YndWb2dQOXhpNmVtWnp5ZDJQa1IyM0pmRU5hMGZwREQ5NUciLCJtYWMiOiJhMzViYzgxOGVkZDBiNDYzNjI1YjAwM2JkYWQ3MzYzNWM0ZWJlOWQ2ZTlmYTc3M2MwYmFhODZlZmY0ZjVkNGRlIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 13:10:12 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IkhHYnpzdFlFYkpXTzBja05TS2VNc0E9PSIsInZhbHVlIjoiRllBdTEvbWhVcmlsNGtOUHJtbUg5dm5heXBtMkVPTEIydnVPTGdQMUpPSkpjMUFnbkp1R0dnWTk3ZDArT0" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IktyNnRCL0tjRnFDR3BEbGhpcFNRRGc9PSIsInZhbHVlIjoiNWx3d2d2SGNtOFFXeHgvbEZhdlFSVHN4TkIwdmRrajkvSk9ncjArZm1mektGWTlqQ2QrVFJqS0d4VSt5Rkt5RThETEV3U05wcGJKRkdnUWRvNDdQODRQTHNlZFZ3bnVnNmMrTXp3dU1YNitxR09VRGhUOThkSFRkM2wvUlVFbE8iLCJtYWMiOiJkMzUyNzQxOTA0NmFiMTFjYWFlMTk2Mzc0NzI4MTRkZDVmOTVkM2Q3MGVjMGYxMzk3YTQzNzgxMTEwZDRkNjc4IiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 13:10:12 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6IktyNnRCL0tjRnFDR3BEbGhpcFNRRGc9PSIsInZhbHVlIjoiNWx3d2d2SGNtOFFXeHgvbEZhdlFSVHN4TkIwdmRrajkvSk9ncjArZm1mektGWTlqQ2QrVFJqS0d4VSt5Rkt5RThETEV3U" 1 => "24houranswers_session=eyJpdiI6IkhHYnpzdFlFYkpXTzBja05TS2VNc0E9PSIsInZhbHVlIjoiRllBdTEvbWhVcmlsNGtOUHJtbUg5dm5heXBtMkVPTEIydnVPTGdQMUpPSkpjMUFnbkp1R0dnWTk3ZDArT0Y0d3VZMFZUZHVaUzJpaDhxOVIyRWJKL0l3cWFMQjI3YndWb2dQOXhpNmVtWnp5ZDJQa1IyM0pmRU5hMGZwREQ5NUciLCJtYWMiOiJhMzViYzgxOGVkZDBiNDYzNjI1YjAwM2JkYWQ3MzYzNWM0ZWJlOWQ2ZTlmYTc3M2MwYmFhODZlZmY0ZjVkNGRlIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 13:10:12 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IkhHYnpzdFlFYkpXTzBja05TS2VNc0E9PSIsInZhbHVlIjoiRllBdTEvbWhVcmlsNGtOUHJtbUg5dm5heXBtMkVPTEIydnVPTGdQMUpPSkpjMUFnbkp1R0dnWTk3ZDArT0" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "Hd1PljgBBMcFPTGlMtI0XeTbQr7Cf8JCl3SGxvvr" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/IT-Computer-Support-Services/IT-Computer-Support-Services-Other/41275" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/IT-Computer-Support-Services/IT-Computer-Support-Services-Other/41275" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]