Question
E-R Diagram
A1 Home Improvement (AHI) provides installation services for home improvement in Northern Virginia. AHI does not employ installers, but rather subcontracts the installations out to a list of approved installers. Whenever a customer requests an installation service in the store, a contract is created for the installation. AHI offers different payment options such as 20% deposit+80% after completion, 30% deposit+70% after completion, etc. AHI decides a deposit amount based on the installation job and the customer pays upfront. Then AHI will assign an installer for the installation job in the contract. Afterwards, the installer will go to the customer’s house and complete the installation. Currently, this process is primarily paper-based and does not provide management with the information needed to efficiently monitor contracts and installers. AHI often runs advertisements for specials such as guaranteed 2-week installation. Without a way to effectively manage installations, installation service sometimes does not get completed within the promised timeframe which has resulted in customer dissatisfaction.
You are hired by AHI to create a database that helps automatically tracks installation contracts and installers. The database must keep track of each AHI customer, including their unique customer ID, first name, last name, street address, city, state, zipcode, and phone number. It also keeps track of all approved installers, including their unique installer ID, SSN (i.e., social security number), first name, last name, city, state, zipcode, phone number, and daily charge (i.e., how much AHI pays to the installer for one day’s work). In addition, the database records each payment option, including unique payment option ID and deposit percentage. In order to provide management with the information needed to effectively track installations, the database keeps track of the details for each installation contract, including unique contract ID, the ID of the customer who requests the service, the ID of the installer assigned to complete the installation, description of the requested installation job, the service charge amount (i.e., how much the customer need to pay to AHI for the installation service), the ID of the payment option associated with the contract, the date the contract is created, the date an installer is assigned to work on the installation, the date the installation is completed by the installer, and the customer’s rating of the job performed by the installer after the job is finished.
Each installation contract may have not been assigned an installer yet, but once assigned each installation is assigned to only one installer. An installer might have not been assigned to any installation or might have been assigned to multiple installations. Each installation contract is associated with one payment option, but each payment option may have not been used for any installation contract yet or may have been used for multiple installation contracts. The database only records existing customers who has requested services from AHI. While a customer might have requested for multiple installations, each installation is for one specific customer.
Q. Carefully read the above business description and draw an Entity-Relationship Diagram (E-R diagram) using Microsoft Powerpoint 2016 for the database that is required for AHI’s tracking system. Make sure that:
1) Your E-R Diagram includes all necessary entities, attributes, and relationships. Hint: since each installation is represented as a contract, installation or contract or installation contract mean the same.
2) For each entity, you need to underline its identifier.
3) For each relationship, you need to give it a meaningful name (remember that a relationship should have a name with a verb).
4) For each relationship, you need to specify the relationship type and cardinality numbers.
5) Make sure that the E-R diagram looks professional: the boxes for entities and the diamonds for relationships are clearly separated from each other rather than being overlapped; the lines are connecting to boxes for entities and diamonds for relationships; the numbers for cardinalities are written at the appropriate positions (i.e., near the entities and are not overlapping with the lines).
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.

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.pptx
Purchase Solution
$22.50
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 Version423msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (266ms)time
    • Application (156ms)time
    • 1 x Booting (63.01%)
      266ms
      1 x Application (36.99%)
      156ms
      • Illuminate\Routing\Events\Routing (1.38ms)
      • Illuminate\Routing\Events\RouteMatched (576μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.49ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (282μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (173μs)
      • Illuminate\Database\Events\ConnectionEstablished (899μs)
      • Illuminate\Database\Events\StatementPrepared (12.33ms)
      • Illuminate\Database\Events\QueryExecuted (1.01ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (99μs)
      • eloquent.booting: App\Models\Subject (101μs)
      • eloquent.booted: App\Models\Subject (56μs)
      • Illuminate\Database\Events\StatementPrepared (1.39ms)
      • Illuminate\Database\Events\QueryExecuted (1.68ms)
      • eloquent.retrieved: App\Models\Subject (112μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (126μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (49μs)
      • Illuminate\Database\Events\StatementPrepared (697μs)
      • Illuminate\Database\Events\QueryExecuted (858μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (173μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (19μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (11μ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 (6μ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.booting: App\Models\SubjectCat (376μs)
      • eloquent.booted: App\Models\SubjectCat (40μs)
      • Illuminate\Database\Events\StatementPrepared (760μs)
      • Illuminate\Database\Events\QueryExecuted (918μs)
      • eloquent.retrieved: App\Models\SubjectCat (92μs)
      • Illuminate\Cache\Events\CacheHit (10.4ms)
      • Illuminate\Cache\Events\CacheMissed (203μs)
      • Illuminate\Database\Events\StatementPrepared (924μs)
      • Illuminate\Database\Events\QueryExecuted (7.96ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (89μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (16μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • Illuminate\Database\Events\StatementPrepared (707μs)
      • Illuminate\Database\Events\QueryExecuted (1.57ms)
      • eloquent.retrieved: App\Models\Subject (97μs)
      • Illuminate\Cache\Events\KeyWritten (1.08ms)
      • Illuminate\Database\Events\StatementPrepared (1.91ms)
      • Illuminate\Database\Events\QueryExecuted (1.1ms)
      • Illuminate\Database\Events\StatementPrepared (891μs)
      • Illuminate\Database\Events\QueryExecuted (981μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (65μs)
      • Illuminate\Database\Events\StatementPrepared (823μs)
      • Illuminate\Database\Events\QueryExecuted (712μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (135μs)
      • Illuminate\Cache\Events\CacheHit (577μs)
      • creating: homework.show (264μs)
      • composing: homework.show (128μs)
      • creating: components.breadcrumbs (282μs)
      • composing: components.breadcrumbs (119μs)
      • Illuminate\Database\Events\StatementPrepared (1.06ms)
      • Illuminate\Database\Events\QueryExecuted (771μs)
      • eloquent.retrieved: App\Models\SubjectCat (64μs)
      • Illuminate\Cache\Events\CacheMissed (4.41ms)
      • Illuminate\Database\Events\StatementPrepared (632μs)
      • Illuminate\Database\Events\QueryExecuted (801μs)
      • eloquent.retrieved: App\Models\SubjectCat (61μs)
      • Illuminate\Cache\Events\KeyWritten (311μs)
      • Illuminate\Cache\Events\CacheHit (821μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheMissed (315μs)
      • Illuminate\Database\Events\StatementPrepared (849μs)
      • Illuminate\Database\Events\QueryExecuted (997μs)
      • eloquent.retrieved: App\Models\SubjectCat (59μs)
      • Illuminate\Cache\Events\KeyWritten (2.32ms)
      • Illuminate\Cache\Events\CacheHit (312μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheMissed (194μs)
      • Illuminate\Database\Events\StatementPrepared (792μs)
      • Illuminate\Database\Events\QueryExecuted (1.05ms)
      • eloquent.retrieved: App\Models\SubjectCat (99μs)
      • Illuminate\Cache\Events\KeyWritten (383μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (277μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (238μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheMissed (298μs)
      • Illuminate\Database\Events\StatementPrepared (754μs)
      • Illuminate\Database\Events\QueryExecuted (1.05ms)
      • eloquent.retrieved: App\Models\SubjectCat (68μs)
      • Illuminate\Cache\Events\KeyWritten (369μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (316μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (292μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheMissed (292μs)
      • Illuminate\Database\Events\StatementPrepared (789μs)
      • Illuminate\Database\Events\QueryExecuted (1.2ms)
      • eloquent.retrieved: App\Models\SubjectCat (140μs)
      • Illuminate\Cache\Events\KeyWritten (286μs)
      • Illuminate\Cache\Events\CacheHit (325μs)
      • Illuminate\Cache\Events\CacheHit (981μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheMissed (216μs)
      • Illuminate\Database\Events\StatementPrepared (646μs)
      • Illuminate\Database\Events\QueryExecuted (902μs)
      • eloquent.retrieved: App\Models\SubjectCat (63μs)
      • Illuminate\Cache\Events\KeyWritten (1.49ms)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (420μs)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (267μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (1ms)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (247μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (283μs)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheMissed (305μs)
      • Illuminate\Database\Events\StatementPrepared (869μs)
      • Illuminate\Database\Events\QueryExecuted (781μs)
      • eloquent.retrieved: App\Models\SubjectCat (79μs)
      • Illuminate\Cache\Events\KeyWritten (299μs)
      • Illuminate\Cache\Events\CacheHit (1.15ms)
      • Illuminate\Cache\Events\CacheHit (244μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (341μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheMissed (192μs)
      • Illuminate\Database\Events\StatementPrepared (831μs)
      • Illuminate\Database\Events\QueryExecuted (910μs)
      • eloquent.retrieved: App\Models\SubjectCat (83μs)
      • Illuminate\Cache\Events\KeyWritten (345μs)
      • Illuminate\Cache\Events\CacheHit (1.34ms)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (629μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (319μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (322μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (261μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheMissed (362μs)
      • Illuminate\Database\Events\StatementPrepared (610μs)
      • Illuminate\Database\Events\QueryExecuted (1.47ms)
      • eloquent.retrieved: App\Models\SubjectCat (72μs)
      • Illuminate\Cache\Events\KeyWritten (540μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (271μs)
      • creating: site.layouts.app (376μs)
      • composing: site.layouts.app (133μs)
      • creating: components.canonical (322μs)
      • composing: components.canonical (72μs)
      • creating: components.open-graph (120μs)
      • composing: components.open-graph (49μs)
      • creating: site.headers.header (177μs)
      • composing: site.headers.header (48μs)
      • Illuminate\Cache\Events\CacheHit (1.21ms)
      • creating: components.footer (64μs)
      • composing: components.footer (67μs)
      • Illuminate\Cache\Events\CacheHit (604μs)
      • Illuminate\Cache\Events\CacheMissed (238μs)
      • Illuminate\Database\Events\StatementPrepared (670μs)
      • Illuminate\Database\Events\QueryExecuted (802μs)
      • eloquent.retrieved: App\Models\SubjectCat (70μs)
      • Illuminate\Cache\Events\KeyWritten (1.42ms)
      • Illuminate\Cache\Events\CacheHit (288μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (310μs)
      • Illuminate\Cache\Events\CacheHit (364μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • creating: components.forms.contact-us (187μs)
      • composing: components.forms.contact-us (119μs)
      • creating: components.forms.get-started (102μs)
      • composing: components.forms.get-started (47μs)
      • creating: components.forms.free-tool-download (75μs)
      • composing: components.forms.free-tool-download (41μs)
      • creating: components.forms.claim-free-worksheet (69μs)
      • composing: components.forms.claim-free-worksheet (41μs)
      • creating: components.forms.tutor-subscription-waitlist (80μs)
      • composing: components.forms.tutor-subscription-waitlist (42μs)
      • creating: components.forms.tutor-subscription-join (70μs)
      • composing: components.forms.tutor-subscription-join (40μs)
      • creating: components.forms.tutor-support (67μs)
      • composing: components.forms.tutor-support (42μs)
      • 311 x Illuminate\Cache\Events\CacheHit (15.71%)
        66.40ms
        20 x Illuminate\Database\Events\StatementPrepared (6.85%)
        28.94ms
        20 x Illuminate\Database\Events\QueryExecuted (6.51%)
        27.53ms
        11 x Illuminate\Cache\Events\KeyWritten (2.09%)
        8.84ms
        11 x Illuminate\Cache\Events\CacheMissed (1.66%)
        7.02ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.06%)
        4.49ms
        1 x Illuminate\Routing\Events\Routing (0.33%)
        1.38ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.22%)
        949μs
        1 x Illuminate\Database\Events\ConnectionEstablished (0.21%)
        899μs
        1 x Illuminate\Routing\Events\RouteMatched (0.14%)
        576μs
        12 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.11%)
        444μs
        1 x eloquent.booting: App\Models\SubjectCat (0.09%)
        376μs
        1 x creating: site.layouts.app (0.09%)
        376μs
        1 x creating: components.canonical (0.08%)
        322μs
        1 x creating: components.breadcrumbs (0.07%)
        282μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.07%)
        282μs
        1 x creating: homework.show (0.06%)
        264μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        230μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        209μs
        1 x creating: components.forms.contact-us (0.04%)
        187μs
        1 x creating: site.headers.header (0.04%)
        177μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        173μs
        1 x composing: site.layouts.app (0.03%)
        133μs
        1 x composing: homework.show (0.03%)
        128μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        126μs
        1 x creating: components.open-graph (0.03%)
        120μs
        1 x composing: components.breadcrumbs (0.03%)
        119μs
        1 x composing: components.forms.contact-us (0.03%)
        119μs
        1 x creating: components.forms.get-started (0.02%)
        102μs
        1 x eloquent.booting: App\Models\Subject (0.02%)
        101μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.02%)
        80μs
        1 x creating: components.forms.free-tool-download (0.02%)
        75μs
        1 x composing: components.canonical (0.02%)
        72μs
        1 x creating: components.forms.tutor-subscription-join (0.02%)
        70μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        69μs
        1 x composing: components.footer (0.02%)
        67μs
        1 x creating: components.forms.tutor-support (0.02%)
        67μs
        1 x creating: components.footer (0.02%)
        64μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        56μs
        1 x composing: components.open-graph (0.01%)
        49μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        49μs
        1 x composing: site.headers.header (0.01%)
        48μs
        1 x composing: components.forms.get-started (0.01%)
        47μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        42μs
        1 x composing: components.forms.tutor-support (0.01%)
        42μs
        1 x composing: components.forms.free-tool-download (0.01%)
        41μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        41μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        40μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        40μ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 duplicated42.37ms
      • Connection Establishedtwenty4_siteHomeworkLibraryController.php#91
        Backtrace
        • 13. app/Http/Controllers/HomeworkLibraryController.php:91
        • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `solutionslibrary` where `status` = 'published' and `price` > 0 and `solutionslibrary`.`id` = '33099' limit 1
        12.55mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 33099
        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 (18)
        1.85mstwenty4_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 (33099)
        1.04mstwenty4_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.2mstwenty4_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` <> 33099 and `subject` = 18 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        8.19mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 33099
        • 1: 18
        • 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 (18)
        1.58mstwenty4_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` = 33099 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        980μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 33099
        • 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` = 33099 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.1mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 33099
        • 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` = 33099 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        810μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 33099
        • 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
        960μstwenty4_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
        950μ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.35mstwenty4_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.19mstwenty4_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.16mstwenty4_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.36mstwenty4_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
        1mstwenty4_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.18mstwenty4_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.27mstwenty4_siteSubject.php#100
        Bindings
        • 0: 34
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 31 limit 1
        1.65mstwenty4_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
        1mstwenty4_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\HomeworkLibrary\HomeworkLibraryFile
      12HomeworkLibraryFile.php
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          Yvgziy9SF36e2nqrXCoIxGovBREL3vfu3MW2a2Lf
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/Database-Development/33099
          _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/Database-Development/33099
          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-680dbfec-2be683a87e29682039751946" ] "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 => "13.59.46.202" ] "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 => "Sun, 27 Apr 2025 05:26:05 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImhCR0M4Uk43WnVmQk4xTk93OWtpREE9PSIsInZhbHVlIjoiWWdMVytRR0hvV0xCZmtzWVhjUTBpQmk1WnhpZ0FOaE1LMVNDYW1DbkMzVk44dmd6QURicHN2OUNWWjlBV3UzeFp6OU1Zc2FoYnZ4K3pocXlFV1Q1Ukl3bjd2cEQwNy9vQzVrMVRoL0tkRnhwQ3pkemtwR2VKbzM3azM4Y25TSTkiLCJtYWMiOiJiY2IzYzU4MWExODg2MzViZjRmNzE5ODg4YWY3ZTk0YzExMGNlNWZhY2NiOTY0MTM3MmRiNjU2YzI3MjM5MWY4IiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:26:05 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6ImhCR0M4Uk43WnVmQk4xTk93OWtpREE9PSIsInZhbHVlIjoiWWdMVytRR0hvV0xCZmtzWVhjUTBpQmk1WnhpZ0FOaE1LMVNDYW1DbkMzVk44dmd6QURicHN2OUNWWjlBV3UzeFp6OU1Zc" 1 => "24houranswers_session=eyJpdiI6IjNCbUk2emZhWWttUG1UYk1rOHQyM2c9PSIsInZhbHVlIjoiQk5TZkJRQ2huMi8rQmhRTWlEZ09nbG5IdWQ1b1RGRWZaK2p0Z1VBVXVVYm40VzM3bmdiT0FJdUxmbG9UdXJ1SklTQ0d4OEw3Ty9GV3JuWnQ3b3dVQVlVUWJTN3k1eDFJamZqVHVkSTZSaFJkSXFBZDhnSm5kdVk0VWNQNVNHYnIiLCJtYWMiOiI3NGI5NDQxYzc3ODFiMzJlNThiZmE1ODQ4OTZjMDkyM2M0MDJjYWIxYjU3ZDg0ZWY5YmU0OGVjOThjYjJhNzRiIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:26:05 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IjNCbUk2emZhWWttUG1UYk1rOHQyM2c9PSIsInZhbHVlIjoiQk5TZkJRQ2huMi8rQmhRTWlEZ09nbG5IdWQ1b1RGRWZaK2p0Z1VBVXVVYm40VzM3bmdiT0FJdUxmbG9UdX" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImhCR0M4Uk43WnVmQk4xTk93OWtpREE9PSIsInZhbHVlIjoiWWdMVytRR0hvV0xCZmtzWVhjUTBpQmk1WnhpZ0FOaE1LMVNDYW1DbkMzVk44dmd6QURicHN2OUNWWjlBV3UzeFp6OU1Zc2FoYnZ4K3pocXlFV1Q1Ukl3bjd2cEQwNy9vQzVrMVRoL0tkRnhwQ3pkemtwR2VKbzM3azM4Y25TSTkiLCJtYWMiOiJiY2IzYzU4MWExODg2MzViZjRmNzE5ODg4YWY3ZTk0YzExMGNlNWZhY2NiOTY0MTM3MmRiNjU2YzI3MjM5MWY4IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:26:05 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6ImhCR0M4Uk43WnVmQk4xTk93OWtpREE9PSIsInZhbHVlIjoiWWdMVytRR0hvV0xCZmtzWVhjUTBpQmk1WnhpZ0FOaE1LMVNDYW1DbkMzVk44dmd6QURicHN2OUNWWjlBV3UzeFp6OU1Zc" 1 => "24houranswers_session=eyJpdiI6IjNCbUk2emZhWWttUG1UYk1rOHQyM2c9PSIsInZhbHVlIjoiQk5TZkJRQ2huMi8rQmhRTWlEZ09nbG5IdWQ1b1RGRWZaK2p0Z1VBVXVVYm40VzM3bmdiT0FJdUxmbG9UdXJ1SklTQ0d4OEw3Ty9GV3JuWnQ3b3dVQVlVUWJTN3k1eDFJamZqVHVkSTZSaFJkSXFBZDhnSm5kdVk0VWNQNVNHYnIiLCJtYWMiOiI3NGI5NDQxYzc3ODFiMzJlNThiZmE1ODQ4OTZjMDkyM2M0MDJjYWIxYjU3ZDg0ZWY5YmU0OGVjOThjYjJhNzRiIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:26:05 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IjNCbUk2emZhWWttUG1UYk1rOHQyM2c9PSIsInZhbHVlIjoiQk5TZkJRQ2huMi8rQmhRTWlEZ09nbG5IdWQ1b1RGRWZaK2p0Z1VBVXVVYm40VzM3bmdiT0FJdUxmbG9UdX" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "Yvgziy9SF36e2nqrXCoIxGovBREL3vfu3MW2a2Lf" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/Database-Development/33099" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/Database-Development/33099" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]