Question
Use the attached database.

1. Write a query to count the number of patients.
2. Write a query to get a list of providers who have worked in institute 1020. Only one line per provider must appear in the result (in other words, get the distinct list of providers).
3. Write a query to count the number of visits in the months of October, November and December 2012 that occurred in each institution.
4. Write a query to show all patients along with their diagnoses. The result should have 4 columns: patient ID, patient first and last name, and their diagnosis. Sort the results based on patient last names.
5. You notice that there are several patients in Patients table that have a first name of John. However, their names have not been entered consistently as far as “case” goes. For example some are entered as “john”, some are entered as “John”, some are entered as “JOHN”, etc.
Write a query to update Patients table and change all possible variations of this name to “John”
Note: Assume there are thousands of records in this table (not just the few lines of sample data that I have included), and there are all sorts of capitalization typos, as indicated above. Your query must correct all capitalization errors of the name John.
6. Look at the following 2 queries. You have seen the first one as an example in your lesson for IN (…) and NOT IN (…).
The second query joins Patients and Visits tables and selects all fields in Patients (through p.*, which means all fields of table Patients) that their visit does not have Dr. Cooper as the provider. This query also ensures duplicate records are not returned (through use of DISTINCT).
One might think the two queries are identical and always return the same results. However, they are indeed different. Explain why they return different results in some circumstances. Note: you are not being asked to send the results of the queries to show they are different. You are being asked to explain why they are different.
Hint 1: The answer is NOT this: “The second query has a DISTINCT keyword and therefore unlike the 1st query does not return duplicate values”. Neither one of the queries returns duplicate patients, because the first query selects from the Patients table, in which, patients are not repeated.
Hint 2: Think of a patient who has had two visits, one with Dr. Cooper, and one with Dr. Samuel.
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.

1. SELECT count(*) from Patients

2. SELECT distinct provider from Visits where institute = 1020
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.docx
Solution.accdb
Purchase Solution
$13.00
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 Version430msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (269ms)time
    • Application (161ms)time
    • 1 x Booting (62.52%)
      269ms
      1 x Application (37.48%)
      161ms
      • Illuminate\Routing\Events\Routing (1.38ms)
      • Illuminate\Routing\Events\RouteMatched (528μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.49ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (182μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (168μs)
      • Illuminate\Database\Events\ConnectionEstablished (925μs)
      • Illuminate\Database\Events\StatementPrepared (16ms)
      • Illuminate\Database\Events\QueryExecuted (1.2ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (111μs)
      • eloquent.booting: App\Models\Subject (83μs)
      • eloquent.booted: App\Models\Subject (168μs)
      • Illuminate\Database\Events\StatementPrepared (1.38ms)
      • Illuminate\Database\Events\QueryExecuted (1.7ms)
      • eloquent.retrieved: App\Models\Subject (113μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (123μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (40μs)
      • Illuminate\Database\Events\StatementPrepared (786μs)
      • Illuminate\Database\Events\QueryExecuted (1.03ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (87μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (15μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μ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.booting: App\Models\SubjectCat (387μs)
      • eloquent.booted: App\Models\SubjectCat (42μs)
      • Illuminate\Database\Events\StatementPrepared (719μs)
      • Illuminate\Database\Events\QueryExecuted (897μs)
      • eloquent.retrieved: App\Models\SubjectCat (82μs)
      • Illuminate\Cache\Events\CacheHit (10.86ms)
      • Illuminate\Cache\Events\CacheMissed (206μs)
      • Illuminate\Database\Events\StatementPrepared (987μs)
      • Illuminate\Database\Events\QueryExecuted (8.63ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (82μ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)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • Illuminate\Database\Events\StatementPrepared (741μs)
      • Illuminate\Database\Events\QueryExecuted (1.48ms)
      • eloquent.retrieved: App\Models\Subject (96μs)
      • Illuminate\Cache\Events\KeyWritten (960μs)
      • Illuminate\Database\Events\StatementPrepared (1.9ms)
      • Illuminate\Database\Events\QueryExecuted (900μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (62μs)
      • Illuminate\Database\Events\StatementPrepared (885μs)
      • Illuminate\Database\Events\QueryExecuted (883μs)
      • Illuminate\Database\Events\StatementPrepared (714μs)
      • Illuminate\Database\Events\QueryExecuted (900μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (48μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (14μs)
      • Illuminate\Cache\Events\CacheHit (601μs)
      • creating: homework.show (277μs)
      • composing: homework.show (122μs)
      • creating: components.breadcrumbs (264μs)
      • composing: components.breadcrumbs (123μs)
      • Illuminate\Database\Events\StatementPrepared (1.22ms)
      • Illuminate\Database\Events\QueryExecuted (1.45ms)
      • eloquent.retrieved: App\Models\SubjectCat (82μs)
      • Illuminate\Cache\Events\CacheMissed (3.04ms)
      • Illuminate\Database\Events\StatementPrepared (706μs)
      • Illuminate\Database\Events\QueryExecuted (914μs)
      • eloquent.retrieved: App\Models\SubjectCat (73μs)
      • Illuminate\Cache\Events\KeyWritten (319μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (310μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheMissed (1.84ms)
      • Illuminate\Database\Events\StatementPrepared (599μs)
      • Illuminate\Database\Events\QueryExecuted (1.1ms)
      • eloquent.retrieved: App\Models\SubjectCat (65μs)
      • Illuminate\Cache\Events\KeyWritten (1.61ms)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheMissed (223μs)
      • Illuminate\Database\Events\StatementPrepared (745μs)
      • Illuminate\Database\Events\QueryExecuted (966μs)
      • eloquent.retrieved: App\Models\SubjectCat (67μs)
      • Illuminate\Cache\Events\KeyWritten (1.33ms)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (235μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheMissed (133μs)
      • Illuminate\Database\Events\StatementPrepared (646μs)
      • Illuminate\Database\Events\QueryExecuted (952μs)
      • eloquent.retrieved: App\Models\SubjectCat (76μs)
      • Illuminate\Cache\Events\KeyWritten (315μs)
      • Illuminate\Cache\Events\CacheHit (1.41ms)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (221μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheMissed (204μs)
      • Illuminate\Database\Events\StatementPrepared (778μs)
      • Illuminate\Database\Events\QueryExecuted (874μs)
      • eloquent.retrieved: App\Models\SubjectCat (65μs)
      • Illuminate\Cache\Events\KeyWritten (1.33ms)
      • Illuminate\Cache\Events\CacheHit (254μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheMissed (195μs)
      • Illuminate\Database\Events\StatementPrepared (682μs)
      • Illuminate\Database\Events\QueryExecuted (1.06ms)
      • eloquent.retrieved: App\Models\SubjectCat (74μs)
      • Illuminate\Cache\Events\KeyWritten (307μs)
      • Illuminate\Cache\Events\CacheHit (1.35ms)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (675μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheMissed (299μs)
      • Illuminate\Database\Events\StatementPrepared (877μs)
      • Illuminate\Database\Events\QueryExecuted (776μs)
      • eloquent.retrieved: App\Models\SubjectCat (81μs)
      • Illuminate\Cache\Events\KeyWritten (1.52ms)
      • Illuminate\Cache\Events\CacheHit (239μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (542μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheMissed (186μs)
      • Illuminate\Database\Events\StatementPrepared (604μs)
      • Illuminate\Database\Events\QueryExecuted (841μs)
      • eloquent.retrieved: App\Models\SubjectCat (73μs)
      • Illuminate\Cache\Events\KeyWritten (1.68ms)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (254μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (1.15ms)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (941μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (303μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (387μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheMissed (174μs)
      • Illuminate\Database\Events\StatementPrepared (665μs)
      • Illuminate\Database\Events\QueryExecuted (720μs)
      • eloquent.retrieved: App\Models\SubjectCat (79μs)
      • Illuminate\Cache\Events\KeyWritten (301μs)
      • Illuminate\Cache\Events\CacheHit (1.12ms)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (331μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • creating: site.layouts.app (354μs)
      • composing: site.layouts.app (18μs)
      • creating: components.canonical (395μs)
      • composing: components.canonical (76μs)
      • creating: components.open-graph (143μs)
      • composing: components.open-graph (49μs)
      • creating: site.headers.header (220μs)
      • composing: site.headers.header (48μs)
      • Illuminate\Cache\Events\CacheHit (1.84ms)
      • creating: components.footer (94μs)
      • composing: components.footer (73μs)
      • Illuminate\Cache\Events\CacheHit (768μs)
      • Illuminate\Cache\Events\CacheMissed (221μs)
      • Illuminate\Database\Events\StatementPrepared (1.04ms)
      • Illuminate\Database\Events\QueryExecuted (1.1ms)
      • eloquent.retrieved: App\Models\SubjectCat (84μs)
      • Illuminate\Cache\Events\KeyWritten (298μs)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (235μs)
      • Illuminate\Cache\Events\CacheHit (252μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • creating: components.forms.contact-us (205μs)
      • composing: components.forms.contact-us (121μs)
      • creating: components.forms.get-started (117μs)
      • composing: components.forms.get-started (45μs)
      • creating: components.forms.free-tool-download (88μs)
      • composing: components.forms.free-tool-download (40μs)
      • creating: components.forms.claim-free-worksheet (80μs)
      • composing: components.forms.claim-free-worksheet (38μs)
      • creating: components.forms.tutor-subscription-waitlist (79μs)
      • composing: components.forms.tutor-subscription-waitlist (39μs)
      • creating: components.forms.tutor-subscription-join (79μs)
      • composing: components.forms.tutor-subscription-join (39μs)
      • creating: components.forms.tutor-support (77μs)
      • composing: components.forms.tutor-support (37μs)
      • 311 x Illuminate\Cache\Events\CacheHit (15.29%)
        65.71ms
        20 x Illuminate\Database\Events\StatementPrepared (7.6%)
        32.67ms
        20 x Illuminate\Database\Events\QueryExecuted (6.6%)
        28.36ms
        11 x Illuminate\Cache\Events\KeyWritten (2.32%)
        9.98ms
        11 x Illuminate\Cache\Events\CacheMissed (1.56%)
        6.72ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.04%)
        4.49ms
        1 x Illuminate\Routing\Events\Routing (0.32%)
        1.38ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.22%)
        925μs
        12 x eloquent.retrieved: App\Models\SubjectCat (0.21%)
        901μs
        1 x Illuminate\Routing\Events\RouteMatched (0.12%)
        528μs
        1 x creating: components.canonical (0.09%)
        395μs
        1 x eloquent.booting: App\Models\SubjectCat (0.09%)
        387μs
        1 x creating: site.layouts.app (0.08%)
        354μs
        1 x creating: homework.show (0.06%)
        277μs
        1 x creating: components.breadcrumbs (0.06%)
        264μs
        9 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.06%)
        251μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        236μs
        1 x creating: site.headers.header (0.05%)
        220μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        209μs
        1 x creating: components.forms.contact-us (0.05%)
        205μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        182μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        168μs
        1 x eloquent.booted: App\Models\Subject (0.04%)
        168μs
        1 x creating: components.open-graph (0.03%)
        143μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        123μs
        1 x composing: components.breadcrumbs (0.03%)
        123μs
        1 x composing: homework.show (0.03%)
        122μs
        1 x composing: components.forms.contact-us (0.03%)
        121μs
        1 x creating: components.forms.get-started (0.03%)
        117μs
        1 x creating: components.footer (0.02%)
        94μs
        1 x creating: components.forms.free-tool-download (0.02%)
        88μs
        1 x eloquent.booting: App\Models\Subject (0.02%)
        83μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        80μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.02%)
        79μs
        1 x creating: components.forms.tutor-subscription-join (0.02%)
        79μs
        1 x creating: components.forms.tutor-support (0.02%)
        77μs
        1 x composing: components.canonical (0.02%)
        76μs
        1 x composing: components.footer (0.02%)
        73μs
        1 x composing: components.open-graph (0.01%)
        49μs
        1 x composing: site.headers.header (0.01%)
        48μs
        1 x composing: components.forms.get-started (0.01%)
        45μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        42μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        40μs
        1 x composing: components.forms.free-tool-download (0.01%)
        40μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        39μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        39μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        38μs
        1 x composing: components.forms.tutor-support (0.01%)
        37μ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.46ms
      • 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` = '32271' limit 1
        16.33mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 32271
        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.81mstwenty4_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 (32271)
        1.28mstwenty4_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.08mstwenty4_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` <> 32271 and `subject` = 18 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        8.78mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 32271
        • 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.68mstwenty4_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` = 32271 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.22mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 32271
        • 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` = 32271 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        920μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 32271
        • 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` = 32271 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.05mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 32271
        • 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.63mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 3
        Backtrace
        • 20. app/Models/HomeworkLibrary/HomeworkLibrary.php:201
        • 32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 33. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 34. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `subject_cats` where `subject_cats`.`id` = 1 limit 1
        1.18mstwenty4_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.21mstwenty4_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.13mstwenty4_siteSubject.php#100
        Bindings
        • 0: 33
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 11 limit 1
        1.27mstwenty4_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.14mstwenty4_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
        930μstwenty4_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
        970μstwenty4_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.5mstwenty4_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
      9HomeworkLibraryFile.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          cEXRDpNsLuxBiOMOcWtDHBdveIt0ibntm59yUlwd
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/Database-Development/32271
          _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/32271
          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-680dc2ed-7257bf4741c2d35b49735025" ] "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.135.229.106" ] "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:38:53 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBuT1VCV0NsRUlRekpvZW9uQWxLK2c9PSIsInZhbHVlIjoiYUs1akRXOFZtNWlzS1FEZTV3d0F5MmFUUFk4QlgyNHFaY0s2UkcxdlZSMnFpK1NOYkVGZDh5TzZNVy9zaEJSMW9kMEFrdTk1Q2lKN0pzYjQ0VFZLRWFzeXhMdUIyT3gxVFcwMTFMM0RQK3I0MitkSjFhZFBkT2tUamYxb2c0dVoiLCJtYWMiOiJjNWFkNmJmNzQ3ODAwNjY3OGFhNTJmZjY1NmEzZTNjMGM1MTA0MGI5ZDIwZjZiN2FiZTkyMDM0ZWUwMzA0ZGU0IiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:38:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6InBuT1VCV0NsRUlRekpvZW9uQWxLK2c9PSIsInZhbHVlIjoiYUs1akRXOFZtNWlzS1FEZTV3d0F5MmFUUFk4QlgyNHFaY0s2UkcxdlZSMnFpK1NOYkVGZDh5TzZNVy9zaEJSMW9kMEFrd" 1 => "24houranswers_session=eyJpdiI6Ik1FY2k3SnIrTXJNNlhJTkI5WEpZV3c9PSIsInZhbHVlIjoiVkZXNTVMM1E1elpOMllJbi91VTZaa2QyTHdwRThkbWlJaElRRkFhZlYrVVZ0UDgwZzBqSTFWZnZPMUcwbTgrbE1QSDVROXNaak9ZMVVWbW1sTVN6MXUxdnpGRUpPLy94d1ZYQjhWSWlxemovWjIvbzFyTFlqMkJYOEFrZDhNYnEiLCJtYWMiOiJkNjFiM2Y5OGRlNzljMzZhMTg5MWM3ODhiMTNiYzcyNmJkY2RmYjlhM2M4YjU5Zjg5MGEwYzU3ODlkMWZjYmJhIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:38:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6Ik1FY2k3SnIrTXJNNlhJTkI5WEpZV3c9PSIsInZhbHVlIjoiVkZXNTVMM1E1elpOMllJbi91VTZaa2QyTHdwRThkbWlJaElRRkFhZlYrVVZ0UDgwZzBqSTFWZnZPMUcwbT" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBuT1VCV0NsRUlRekpvZW9uQWxLK2c9PSIsInZhbHVlIjoiYUs1akRXOFZtNWlzS1FEZTV3d0F5MmFUUFk4QlgyNHFaY0s2UkcxdlZSMnFpK1NOYkVGZDh5TzZNVy9zaEJSMW9kMEFrdTk1Q2lKN0pzYjQ0VFZLRWFzeXhMdUIyT3gxVFcwMTFMM0RQK3I0MitkSjFhZFBkT2tUamYxb2c0dVoiLCJtYWMiOiJjNWFkNmJmNzQ3ODAwNjY3OGFhNTJmZjY1NmEzZTNjMGM1MTA0MGI5ZDIwZjZiN2FiZTkyMDM0ZWUwMzA0ZGU0IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:38:53 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6InBuT1VCV0NsRUlRekpvZW9uQWxLK2c9PSIsInZhbHVlIjoiYUs1akRXOFZtNWlzS1FEZTV3d0F5MmFUUFk4QlgyNHFaY0s2UkcxdlZSMnFpK1NOYkVGZDh5TzZNVy9zaEJSMW9kMEFrd" 1 => "24houranswers_session=eyJpdiI6Ik1FY2k3SnIrTXJNNlhJTkI5WEpZV3c9PSIsInZhbHVlIjoiVkZXNTVMM1E1elpOMllJbi91VTZaa2QyTHdwRThkbWlJaElRRkFhZlYrVVZ0UDgwZzBqSTFWZnZPMUcwbTgrbE1QSDVROXNaak9ZMVVWbW1sTVN6MXUxdnpGRUpPLy94d1ZYQjhWSWlxemovWjIvbzFyTFlqMkJYOEFrZDhNYnEiLCJtYWMiOiJkNjFiM2Y5OGRlNzljMzZhMTg5MWM3ODhiMTNiYzcyNmJkY2RmYjlhM2M4YjU5Zjg5MGEwYzU3ODlkMWZjYmJhIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:38:53 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6Ik1FY2k3SnIrTXJNNlhJTkI5WEpZV3c9PSIsInZhbHVlIjoiVkZXNTVMM1E1elpOMllJbi91VTZaa2QyTHdwRThkbWlJaElRRkFhZlYrVVZ0UDgwZzBqSTFWZnZPMUcwbT" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "cEXRDpNsLuxBiOMOcWtDHBdveIt0ibntm59yUlwd" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/Database-Development/32271" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/Database-Development/32271" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]