Question
Homework Assignment
Exchange of information among healthcare organizations is a very important problem facing the healthcare industry at this time. There are a number of efforts ongoing to solve the various difficulties. Information can arrive at a healthcare organization in different formats. The FHIR (Fast Healthcare Interoperability Resources) project, being conducted by the Health Level Seven International (HL7) organization, uses several standards, such as XML (Extensible Markup Language), for exchanging information. Parsing the information stream coming into the organization is necessary to extract the relevant information.
For the assignment, you need to modify the given parser program to work with your PatientBill Class created in Assignment #4. The final program should be able to extract the 4 types of information for each patient, first prints out the total number of people listed in the file, and then prints the information for each person out to the screen with labels.
Please note that there are 4 individuals in the file given to you, which is called Patient.xml in the My Course Content area. However, your program should be general enough that it can handle any number of individuals in the file (so, I may test your Java code using a test file that contains a different number and list of people).
For the assignment, you need to submit both your Java source code (PatientBill.java and PatientBillParser.java) and the screen output that resulted when you ran the program. Remember to include comments in the source code to explain what the code is doing.
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.

import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;
import org.xml.sax.SAXException;

/*
* Class to parse PatientBill objects from XML file
*/
public class PatientBillParser
{
    private ArrayList<PatientBill> patients;
    private Document dom;
   
    // Constructor
    public PatientBillParser()
    {
       patients = new ArrayList<PatientBill>();
    }
   
    // Method to run example
    public void runExample()
    {
       //parse the xml file and get the dom object
       parseXMLFile();
      
       //get each patient element and create a PatientInfo object
       parseDocument();
      
       //Iterate through the list and print the data
       printData();
      
    }
   
    // Method to parse XML file
    private void parseXMLFile()
    {
       DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
       try{
            DocumentBuilder db = dbf.newDocumentBuilder();
            dom = db.parse("Patient.xml");
       }catch(ParserConfigurationException pce)
       {
            pce.printStackTrace();
       }catch(SAXException se)
       {
            se.printStackTrace();
       }catch(IOException ioe)
       {
            ioe.printStackTrace();
       }
    }
   
    // Method to parse document
    private void
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
$50.00 $25
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 Version460msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (282ms)time
    • Application (179ms)time
    • 1 x Booting (61.2%)
      282ms
      1 x Application (38.79%)
      179ms
      • Illuminate\Routing\Events\Routing (1.4ms)
      • Illuminate\Routing\Events\RouteMatched (537μs)
      • Illuminate\Foundation\Events\LocaleUpdated (5.05ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (202μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (105μs)
      • Illuminate\Database\Events\ConnectionEstablished (709μs)
      • Illuminate\Database\Events\StatementPrepared (21.76ms)
      • Illuminate\Database\Events\QueryExecuted (1.35ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (107μs)
      • eloquent.booting: App\Models\Subject (124μs)
      • eloquent.booted: App\Models\Subject (43μs)
      • Illuminate\Database\Events\StatementPrepared (1.56ms)
      • Illuminate\Database\Events\QueryExecuted (1.37ms)
      • eloquent.retrieved: App\Models\Subject (382μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (137μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (43μs)
      • Illuminate\Database\Events\StatementPrepared (770μs)
      • Illuminate\Database\Events\QueryExecuted (915μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (84μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (19μ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 (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (11μs)
      • eloquent.booting: App\Models\SubjectCat (334μs)
      • eloquent.booted: App\Models\SubjectCat (41μs)
      • Illuminate\Database\Events\StatementPrepared (631μs)
      • Illuminate\Database\Events\QueryExecuted (1.19ms)
      • eloquent.retrieved: App\Models\SubjectCat (124μs)
      • Illuminate\Cache\Events\CacheHit (15.46ms)
      • Illuminate\Cache\Events\CacheMissed (257μs)
      • Illuminate\Database\Events\StatementPrepared (1.1ms)
      • Illuminate\Database\Events\QueryExecuted (1.74ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (102μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (16μ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 (808μs)
      • Illuminate\Database\Events\QueryExecuted (1.11ms)
      • eloquent.retrieved: App\Models\Subject (93μs)
      • Illuminate\Cache\Events\KeyWritten (865μs)
      • Illuminate\Database\Events\StatementPrepared (2.16ms)
      • Illuminate\Database\Events\QueryExecuted (1.17ms)
      • Illuminate\Database\Events\StatementPrepared (1.78ms)
      • Illuminate\Database\Events\QueryExecuted (984μs)
      • Illuminate\Database\Events\StatementPrepared (799μs)
      • Illuminate\Database\Events\QueryExecuted (1.12ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (69μs)
      • Illuminate\Cache\Events\CacheHit (1.07ms)
      • creating: homework.show (389μs)
      • composing: homework.show (358μs)
      • creating: components.breadcrumbs (375μs)
      • composing: components.breadcrumbs (183μs)
      • Illuminate\Database\Events\StatementPrepared (1.44ms)
      • Illuminate\Database\Events\QueryExecuted (840μs)
      • eloquent.retrieved: App\Models\SubjectCat (126μs)
      • Illuminate\Cache\Events\CacheMissed (5.97ms)
      • Illuminate\Database\Events\StatementPrepared (750μs)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • eloquent.retrieved: App\Models\SubjectCat (87μs)
      • Illuminate\Cache\Events\KeyWritten (358μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (440μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheMissed (177μs)
      • Illuminate\Database\Events\StatementPrepared (703μs)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • eloquent.retrieved: App\Models\SubjectCat (121μs)
      • Illuminate\Cache\Events\KeyWritten (453μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (1.16ms)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheMissed (217μs)
      • Illuminate\Database\Events\StatementPrepared (745μs)
      • Illuminate\Database\Events\QueryExecuted (1.44ms)
      • eloquent.retrieved: App\Models\SubjectCat (77μs)
      • Illuminate\Cache\Events\KeyWritten (2.47ms)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (272μs)
      • Illuminate\Cache\Events\CacheHit (290μs)
      • Illuminate\Cache\Events\CacheHit (277μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (259μs)
      • Illuminate\Cache\Events\CacheHit (305μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheMissed (225μs)
      • Illuminate\Database\Events\StatementPrepared (669μs)
      • Illuminate\Database\Events\QueryExecuted (862μs)
      • eloquent.retrieved: App\Models\SubjectCat (83μs)
      • Illuminate\Cache\Events\KeyWritten (1.14ms)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (259μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (438μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheMissed (184μs)
      • Illuminate\Database\Events\StatementPrepared (743μs)
      • Illuminate\Database\Events\QueryExecuted (837μs)
      • eloquent.retrieved: App\Models\SubjectCat (84μs)
      • Illuminate\Cache\Events\KeyWritten (665μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (429μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheMissed (142μs)
      • Illuminate\Database\Events\StatementPrepared (734μs)
      • Illuminate\Database\Events\QueryExecuted (790μs)
      • eloquent.retrieved: App\Models\SubjectCat (69μs)
      • Illuminate\Cache\Events\KeyWritten (1.33ms)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (322μs)
      • Illuminate\Cache\Events\CacheHit (284μs)
      • Illuminate\Cache\Events\CacheHit (360μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (617μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheMissed (227μs)
      • Illuminate\Database\Events\StatementPrepared (838μs)
      • Illuminate\Database\Events\QueryExecuted (1.01ms)
      • eloquent.retrieved: App\Models\SubjectCat (79μs)
      • Illuminate\Cache\Events\KeyWritten (304μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (750μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (442μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheMissed (279μs)
      • Illuminate\Database\Events\StatementPrepared (920μs)
      • Illuminate\Database\Events\QueryExecuted (1.01ms)
      • eloquent.retrieved: App\Models\SubjectCat (84μs)
      • Illuminate\Cache\Events\KeyWritten (498μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (980μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (379μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (303μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheMissed (334μs)
      • Illuminate\Database\Events\StatementPrepared (1.8ms)
      • Illuminate\Database\Events\QueryExecuted (929μs)
      • eloquent.retrieved: App\Models\SubjectCat (75μs)
      • Illuminate\Cache\Events\KeyWritten (1.47ms)
      • Illuminate\Cache\Events\CacheHit (252μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • creating: site.layouts.app (377μs)
      • composing: site.layouts.app (18μs)
      • creating: components.canonical (338μs)
      • composing: components.canonical (81μs)
      • creating: components.open-graph (156μs)
      • composing: components.open-graph (53μs)
      • creating: site.headers.header (299μs)
      • composing: site.headers.header (60μs)
      • Illuminate\Cache\Events\CacheHit (2.17ms)
      • creating: components.footer (91μs)
      • composing: components.footer (99μs)
      • Illuminate\Cache\Events\CacheHit (676μs)
      • Illuminate\Cache\Events\CacheMissed (235μs)
      • Illuminate\Database\Events\StatementPrepared (894μs)
      • Illuminate\Database\Events\QueryExecuted (892μs)
      • eloquent.retrieved: App\Models\SubjectCat (76μs)
      • Illuminate\Cache\Events\KeyWritten (301μs)
      • Illuminate\Cache\Events\CacheHit (288μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (294μs)
      • Illuminate\Cache\Events\CacheHit (341μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • creating: components.forms.contact-us (315μs)
      • composing: components.forms.contact-us (196μs)
      • creating: components.forms.get-started (214μs)
      • composing: components.forms.get-started (90μs)
      • creating: components.forms.free-tool-download (151μs)
      • composing: components.forms.free-tool-download (84μs)
      • creating: components.forms.claim-free-worksheet (154μs)
      • composing: components.forms.claim-free-worksheet (87μs)
      • creating: components.forms.tutor-subscription-waitlist (152μs)
      • composing: components.forms.tutor-subscription-waitlist (113μs)
      • creating: components.forms.tutor-subscription-join (155μs)
      • composing: components.forms.tutor-subscription-join (86μs)
      • creating: components.forms.tutor-support (392μs)
      • composing: components.forms.tutor-support (111μs)
      • 311 x Illuminate\Cache\Events\CacheHit (16.4%)
        75.49ms
        20 x Illuminate\Database\Events\StatementPrepared (9.04%)
        41.60ms
        20 x Illuminate\Database\Events\QueryExecuted (4.69%)
        21.59ms
        11 x Illuminate\Cache\Events\KeyWritten (2.14%)
        9.85ms
        11 x Illuminate\Cache\Events\CacheMissed (1.79%)
        8.24ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.1%)
        5.05ms
        1 x Illuminate\Routing\Events\Routing (0.3%)
        1.40ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.24%)
        1.09ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.15%)
        709μs
        1 x Illuminate\Routing\Events\RouteMatched (0.12%)
        537μs
        2 x eloquent.retrieved: App\Models\Subject (0.1%)
        475μs
        1 x creating: components.forms.tutor-support (0.09%)
        392μs
        1 x creating: homework.show (0.08%)
        389μs
        1 x creating: site.layouts.app (0.08%)
        377μs
        1 x creating: components.breadcrumbs (0.08%)
        375μs
        1 x composing: homework.show (0.08%)
        358μs
        1 x creating: components.canonical (0.07%)
        338μs
        1 x eloquent.booting: App\Models\SubjectCat (0.07%)
        334μs
        1 x creating: components.forms.contact-us (0.07%)
        315μs
        1 x creating: site.headers.header (0.06%)
        299μs
        6 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        246μs
        10 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.05%)
        218μs
        1 x creating: components.forms.get-started (0.05%)
        214μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        202μs
        1 x composing: components.forms.contact-us (0.04%)
        196μs
        1 x composing: components.breadcrumbs (0.04%)
        183μs
        1 x creating: components.open-graph (0.03%)
        156μs
        1 x creating: components.forms.tutor-subscription-join (0.03%)
        155μs
        1 x creating: components.forms.claim-free-worksheet (0.03%)
        154μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.03%)
        152μs
        1 x creating: components.forms.free-tool-download (0.03%)
        151μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        137μs
        1 x eloquent.booting: App\Models\Subject (0.03%)
        124μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.02%)
        113μs
        1 x composing: components.forms.tutor-support (0.02%)
        111μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.02%)
        105μs
        1 x composing: components.footer (0.02%)
        99μs
        1 x creating: components.footer (0.02%)
        91μs
        1 x composing: components.forms.get-started (0.02%)
        90μs
        1 x composing: components.forms.claim-free-worksheet (0.02%)
        87μs
        1 x composing: components.forms.tutor-subscription-join (0.02%)
        86μs
        1 x composing: components.forms.free-tool-download (0.02%)
        84μs
        1 x composing: components.canonical (0.02%)
        81μs
        1 x composing: site.headers.header (0.01%)
        60μs
        1 x composing: components.open-graph (0.01%)
        53μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        43μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        43μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        41μs
        1 x composing: site.layouts.app (0%)
        18μ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 duplicated47.49ms
      • 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` = '51977' limit 1
        22.31mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 51977
        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 (307)
        1.51mstwenty4_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 (51977)
        1mstwenty4_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.04mstwenty4_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` <> 51977 and `subject` = 307 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        2.05mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 51977
        • 1: 307
        • 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 (307)
        1.26mstwenty4_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` = 51977 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.28mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 51977
        • 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` = 51977 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.86mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 51977
        • 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` = 51977 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.11mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 51977
        • 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.12mstwenty4_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
        990μstwenty4_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.25mstwenty4_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.6mstwenty4_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.05mstwenty4_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.08mstwenty4_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
        940μstwenty4_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.26mstwenty4_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.31mstwenty4_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
        2.15mstwenty4_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.32mstwenty4_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
      6HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          tIjeg0eVAI3CoEC4MBKN1Ho2wPev0MQs9cCYrb60
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/Bioinformatics/51977
          _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/Bioinformatics/51977
          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-680bd5dc-674609ed60077c44552e46b9" ] "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 => "3.133.100.195" ] "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 => "Fri, 25 Apr 2025 18:35:09 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik45YW1qQzF6VDd4ZEdqOUJCWUJvUHc9PSIsInZhbHVlIjoiVjJkVmZCWWFoVTAyMmVqUnpGODVIa0xzV3czTUF2WDFwYTJlNWpza1ZiNUJ6QlMxRGdrTENMSTNuR2Z1WDZ2U2RxL2ZmMlVXM241dUYrMnJ3aWpzM1dNRjlpTFZvMlpQTUxPSjNXcEFCMmc5UVJaQ1BySlI1dkpRRjJYR0FtM1EiLCJtYWMiOiI0MWRmNmI0ZjI5M2M4YWIyOWU3MTE5ZDc2MGYzM2I4ZmJiY2E1M2QxNzRiNjM5NjVkNWQwNmVhNjk4YzA1YjI3IiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 20:35:09 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6Ik45YW1qQzF6VDd4ZEdqOUJCWUJvUHc9PSIsInZhbHVlIjoiVjJkVmZCWWFoVTAyMmVqUnpGODVIa0xzV3czTUF2WDFwYTJlNWpza1ZiNUJ6QlMxRGdrTENMSTNuR2Z1WDZ2U2RxL2ZmM" 1 => "24houranswers_session=eyJpdiI6IlNkcnpiYUZxSGJERG54OTdCTDhYRnc9PSIsInZhbHVlIjoiKy9meUkwUUVzenFKaVhhakZlZXBUeU8yM1hkdkFjREVjODBZdnVwcnY4NlRkcWFQU1VUUDRUejYxTXNocVRsWVpmZ1FzUXBPY2RUU0NjUjFONW5ZWFpUK2o4Y204SFVXdkY0STB4ZkVXQ2ozcHVpTk5mQXpGK1RZa1hmTWpGeHciLCJtYWMiOiJmMmJmNzYyZDIxNWRjZjdiZmZmYTkyMzhhZTNhZjdlNTMyMTM2YzBiNDhhNTFkMmM4Njg0OTEzNDg5Mzk5N2NhIiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 20:35:09 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IlNkcnpiYUZxSGJERG54OTdCTDhYRnc9PSIsInZhbHVlIjoiKy9meUkwUUVzenFKaVhhakZlZXBUeU8yM1hkdkFjREVjODBZdnVwcnY4NlRkcWFQU1VUUDRUejYxTXNocV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik45YW1qQzF6VDd4ZEdqOUJCWUJvUHc9PSIsInZhbHVlIjoiVjJkVmZCWWFoVTAyMmVqUnpGODVIa0xzV3czTUF2WDFwYTJlNWpza1ZiNUJ6QlMxRGdrTENMSTNuR2Z1WDZ2U2RxL2ZmMlVXM241dUYrMnJ3aWpzM1dNRjlpTFZvMlpQTUxPSjNXcEFCMmc5UVJaQ1BySlI1dkpRRjJYR0FtM1EiLCJtYWMiOiI0MWRmNmI0ZjI5M2M4YWIyOWU3MTE5ZDc2MGYzM2I4ZmJiY2E1M2QxNzRiNjM5NjVkNWQwNmVhNjk4YzA1YjI3IiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 20:35:09 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6Ik45YW1qQzF6VDd4ZEdqOUJCWUJvUHc9PSIsInZhbHVlIjoiVjJkVmZCWWFoVTAyMmVqUnpGODVIa0xzV3czTUF2WDFwYTJlNWpza1ZiNUJ6QlMxRGdrTENMSTNuR2Z1WDZ2U2RxL2ZmM" 1 => "24houranswers_session=eyJpdiI6IlNkcnpiYUZxSGJERG54OTdCTDhYRnc9PSIsInZhbHVlIjoiKy9meUkwUUVzenFKaVhhakZlZXBUeU8yM1hkdkFjREVjODBZdnVwcnY4NlRkcWFQU1VUUDRUejYxTXNocVRsWVpmZ1FzUXBPY2RUU0NjUjFONW5ZWFpUK2o4Y204SFVXdkY0STB4ZkVXQ2ozcHVpTk5mQXpGK1RZa1hmTWpGeHciLCJtYWMiOiJmMmJmNzYyZDIxNWRjZjdiZmZmYTkyMzhhZTNhZjdlNTMyMTM2YzBiNDhhNTFkMmM4Njg0OTEzNDg5Mzk5N2NhIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 20:35:09 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IlNkcnpiYUZxSGJERG54OTdCTDhYRnc9PSIsInZhbHVlIjoiKy9meUkwUUVzenFKaVhhakZlZXBUeU8yM1hkdkFjREVjODBZdnVwcnY4NlRkcWFQU1VUUDRUejYxTXNocV" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "tIjeg0eVAI3CoEC4MBKN1Ho2wPev0MQs9cCYrb60" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/Bioinformatics/51977" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/Bioinformatics/51977" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]