Question
Write 10 SQL statements against the STUDENT schema. Your statements should run error-free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only; and the other document (doc/docx/pdf) include both your statements and your query results (copy and paste text or screen shots).
Q1. List all instructors. Show salutation in all lower cases, last name in all upper cases and phone number in the format of '(xxx) xxx-xxxx'. (HINT: use LOWER, UPPER and SUBSTR function)
Q2. List all students (display student_id, first name, last name, street address, zipcode, city, and state) who live in New York, NY. Sort results by last name, and then first name, in descending order.
Q3. Display the city in which each instructor lives. List first name, last name, zip, city, and state. Display "N/A" for zip, city, and state if an instructor does not have a zipcode. (HINT: left join INSTRUCTOR and ZIPCODE; use NVL function)
Q4. Show the number of instructors who live in NY state and has a street number of 518. (HINT: use string functions such as SUBSTR and INSTR)
Q5. Display the lowest, highest, and average numeric grade of Project grade type. (HINT: use the MIN, MAX, and AVG function; join GRADE and GRADE_TYPE)
-- LEFT JOIN, DATE
Q6. List all students (display student_id, first name, last name, and registration date) who registered on or before 2/15/2007 but have not enrolled in any course. (HINT: left outer join STUDENT and ENROLLMENT; use the TO_DATE function)
-- COUNT WITH 3-TABLE JOIN
Q7. Find how many students are enrolled in sections taught by Todd Smythe. (HINT: join INSTRUCTOR, SECTION, and ENROLLMENT)
-- 4-TABLE JOIN
Q8. Show all students who are taking, or have taken the course "Advanced Java Programming course". List student name, enrollment date, and section location. (HINT: join COURSE, SECTION, ENROLLMENT, and STUDENT)
-- 4-TABLE JOIN
Q9. List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.
-- 4-TABLE JOIN WITH DISTINCT
Q10. List the instructors who teach Advanced Java Programming (having a section with students enrolled), without duplication. Show instructor name and course name. (HINT: use the DISTINCT keyword)
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.

-- Q1. List all instructors. Show salutation in all lower cases,
-- last name in all upper cases and phone -- number in the format
-- of '(xxx) xxx-xxxx'. (HINT: use LOWER, UPPER and SUBSTR function)
SELECT LOWER(salutation) AS FormattedSalut, UPPER(last_name),
'(' || SUBSTR(phone,1,3) || ') ' || SUBSTR(phone,4,3) || '-'
|| SUBSTR(phone,7,4)
FROM instructor;

-- Q2. List all students (display student_id, first name, last name,
-- street address, zipcode, city, and -- state) who live in New York, NY.
-- Sort results by last name, and then first name, in descending order.
SELECT student.student_id,student.first_name,student.last_name,
student.street_address,student.zip,zipcode.city,zipcode.state
FROM student
JOIN zipcode ON (student.zip=zipcode.zip)
WHERE zipcode.city='New York' AND zipcode.state='NY'
ORDER BY last_name DESC,first_name DESC;
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
Purchase Solution
$35.75
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Computer Science Tutors 529 tutors matched
Ionut
(ionut)
Hi! MSc Applied Informatics & Computer Science Engineer. Practical experience in many CS & IT branches.Research work & homework
5/5 (5,654+ sessions)
2 hours avg response
Leo
(Leo)
Hi! I have been a professor in New York and taught in a math department and in an applied math department.
4.9/5 (5,652+ sessions)
2 hours avg response
Pranay
(math1983)
Ph.D. in mathematics and working as an Assistant Professor in University. I can provide help in mathematics, statistics and allied areas.
4.6/5 (5,512+ sessions)
1 hour avg response

Similar Homework Solutions

8.1.0PHP Version422msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (266ms)time
    • Application (156ms)time
    • 1 x Booting (63.12%)
      266ms
      1 x Application (36.88%)
      156ms
      • Illuminate\Routing\Events\Routing (1.38ms)
      • Illuminate\Routing\Events\RouteMatched (576μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.56ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (214μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (176μs)
      • Illuminate\Database\Events\ConnectionEstablished (899μs)
      • Illuminate\Database\Events\StatementPrepared (11.99ms)
      • Illuminate\Database\Events\QueryExecuted (1.1ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (102μs)
      • eloquent.booting: App\Models\Subject (105μs)
      • eloquent.booted: App\Models\Subject (43μs)
      • Illuminate\Database\Events\StatementPrepared (1.6ms)
      • Illuminate\Database\Events\QueryExecuted (1.73ms)
      • eloquent.retrieved: App\Models\Subject (99μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (124μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (43μs)
      • Illuminate\Database\Events\StatementPrepared (672μs)
      • Illuminate\Database\Events\QueryExecuted (891μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (172μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (16μ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 (368μs)
      • eloquent.booted: App\Models\SubjectCat (43μs)
      • Illuminate\Database\Events\StatementPrepared (720μs)
      • Illuminate\Database\Events\QueryExecuted (983μs)
      • eloquent.retrieved: App\Models\SubjectCat (86μs)
      • Illuminate\Cache\Events\CacheHit (12.27ms)
      • Illuminate\Cache\Events\CacheMissed (169μs)
      • Illuminate\Database\Events\StatementPrepared (817μs)
      • Illuminate\Database\Events\QueryExecuted (8.6ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (119μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (22μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (14μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (12μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (10μs)
      • Illuminate\Database\Events\StatementPrepared (727μs)
      • Illuminate\Database\Events\QueryExecuted (1.31ms)
      • eloquent.retrieved: App\Models\Subject (113μs)
      • Illuminate\Cache\Events\KeyWritten (1.05ms)
      • Illuminate\Database\Events\StatementPrepared (1.76ms)
      • Illuminate\Database\Events\QueryExecuted (1.03ms)
      • Illuminate\Database\Events\StatementPrepared (813μs)
      • Illuminate\Database\Events\QueryExecuted (868μs)
      • Illuminate\Database\Events\StatementPrepared (626μs)
      • Illuminate\Database\Events\QueryExecuted (699μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (51μs)
      • Illuminate\Cache\Events\CacheHit (351μs)
      • creating: homework.show (173μs)
      • composing: homework.show (70μs)
      • creating: components.breadcrumbs (184μs)
      • composing: components.breadcrumbs (79μs)
      • Illuminate\Database\Events\StatementPrepared (1.1ms)
      • Illuminate\Database\Events\QueryExecuted (1.68ms)
      • eloquent.retrieved: App\Models\SubjectCat (66μs)
      • Illuminate\Cache\Events\CacheMissed (2.91ms)
      • Illuminate\Database\Events\StatementPrepared (583μs)
      • Illuminate\Database\Events\QueryExecuted (786μs)
      • eloquent.retrieved: App\Models\SubjectCat (62μs)
      • Illuminate\Cache\Events\KeyWritten (835μs)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (287μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheMissed (146μs)
      • Illuminate\Database\Events\StatementPrepared (715μs)
      • Illuminate\Database\Events\QueryExecuted (870μs)
      • eloquent.retrieved: App\Models\SubjectCat (72μs)
      • Illuminate\Cache\Events\KeyWritten (331μs)
      • Illuminate\Cache\Events\CacheHit (2.1ms)
      • Illuminate\Cache\Events\CacheHit (262μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (221μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (239μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheMissed (2.39ms)
      • Illuminate\Database\Events\StatementPrepared (673μs)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • eloquent.retrieved: App\Models\SubjectCat (94μs)
      • Illuminate\Cache\Events\KeyWritten (325μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (292μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheMissed (210μs)
      • Illuminate\Database\Events\StatementPrepared (703μs)
      • Illuminate\Database\Events\QueryExecuted (890μs)
      • eloquent.retrieved: App\Models\SubjectCat (91μs)
      • Illuminate\Cache\Events\KeyWritten (327μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (317μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (383μs)
      • Illuminate\Cache\Events\CacheHit (182μ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 (200μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (185μ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 (178μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheMissed (186μs)
      • Illuminate\Database\Events\StatementPrepared (615μs)
      • Illuminate\Database\Events\QueryExecuted (863μs)
      • eloquent.retrieved: App\Models\SubjectCat (71μs)
      • Illuminate\Cache\Events\KeyWritten (1.22ms)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheMissed (149μs)
      • Illuminate\Database\Events\StatementPrepared (633μs)
      • Illuminate\Database\Events\QueryExecuted (781μs)
      • eloquent.retrieved: App\Models\SubjectCat (68μs)
      • Illuminate\Cache\Events\KeyWritten (285μs)
      • Illuminate\Cache\Events\CacheHit (1.34ms)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (421μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (1.08ms)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (463μs)
      • Illuminate\Cache\Events\CacheHit (256μs)
      • Illuminate\Cache\Events\CacheMissed (342μs)
      • Illuminate\Database\Events\StatementPrepared (799μs)
      • Illuminate\Database\Events\QueryExecuted (893μs)
      • eloquent.retrieved: App\Models\SubjectCat (67μs)
      • Illuminate\Cache\Events\KeyWritten (1.32ms)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheMissed (238μs)
      • Illuminate\Database\Events\StatementPrepared (776μs)
      • Illuminate\Database\Events\QueryExecuted (1.03ms)
      • eloquent.retrieved: App\Models\SubjectCat (72μs)
      • Illuminate\Cache\Events\KeyWritten (1.51ms)
      • Illuminate\Cache\Events\CacheHit (264μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (322μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (631μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (105μ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 (119μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (240μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheMissed (216μs)
      • Illuminate\Database\Events\StatementPrepared (881μs)
      • Illuminate\Database\Events\QueryExecuted (1.05ms)
      • eloquent.retrieved: App\Models\SubjectCat (91μs)
      • Illuminate\Cache\Events\KeyWritten (314μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • creating: site.layouts.app (366μs)
      • composing: site.layouts.app (25μs)
      • creating: components.canonical (486μs)
      • composing: components.canonical (78μs)
      • creating: components.open-graph (168μs)
      • composing: components.open-graph (71μs)
      • creating: site.headers.header (250μs)
      • composing: site.headers.header (50μs)
      • Illuminate\Cache\Events\CacheHit (1.64ms)
      • creating: components.footer (71μs)
      • composing: components.footer (84μs)
      • Illuminate\Cache\Events\CacheHit (643μs)
      • Illuminate\Cache\Events\CacheMissed (276μs)
      • Illuminate\Database\Events\StatementPrepared (758μs)
      • Illuminate\Database\Events\QueryExecuted (1.04ms)
      • eloquent.retrieved: App\Models\SubjectCat (79μs)
      • Illuminate\Cache\Events\KeyWritten (333μs)
      • Illuminate\Cache\Events\CacheHit (293μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (253μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • creating: components.forms.contact-us (325μs)
      • composing: components.forms.contact-us (131μs)
      • creating: components.forms.get-started (148μs)
      • composing: components.forms.get-started (195μs)
      • creating: components.forms.free-tool-download (121μs)
      • composing: components.forms.free-tool-download (49μs)
      • creating: components.forms.claim-free-worksheet (84μs)
      • composing: components.forms.claim-free-worksheet (207μs)
      • creating: components.forms.tutor-subscription-waitlist (115μs)
      • composing: components.forms.tutor-subscription-waitlist (46μs)
      • creating: components.forms.tutor-subscription-join (84μs)
      • composing: components.forms.tutor-subscription-join (39μs)
      • creating: components.forms.tutor-support (83μs)
      • composing: components.forms.tutor-support (41μs)
      • 311 x Illuminate\Cache\Events\CacheHit (15.68%)
        66.15ms
        20 x Illuminate\Database\Events\QueryExecuted (6.67%)
        28.13ms
        20 x Illuminate\Database\Events\StatementPrepared (6.63%)
        27.96ms
        11 x Illuminate\Cache\Events\KeyWritten (1.86%)
        7.85ms
        11 x Illuminate\Cache\Events\CacheMissed (1.71%)
        7.23ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.08%)
        4.56ms
        1 x Illuminate\Routing\Events\Routing (0.33%)
        1.38ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.22%)
        919μs
        1 x Illuminate\Database\Events\ConnectionEstablished (0.21%)
        899μs
        1 x Illuminate\Routing\Events\RouteMatched (0.14%)
        576μs
        1 x creating: components.canonical (0.12%)
        486μs
        1 x eloquent.booting: App\Models\SubjectCat (0.09%)
        368μs
        1 x creating: site.layouts.app (0.09%)
        366μs
        1 x creating: components.forms.contact-us (0.08%)
        325μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.07%)
        292μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.06%)
        264μs
        1 x creating: site.headers.header (0.06%)
        250μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        214μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        212μs
        1 x composing: components.forms.claim-free-worksheet (0.05%)
        207μs
        1 x composing: components.forms.get-started (0.05%)
        195μs
        1 x creating: components.breadcrumbs (0.04%)
        184μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        176μs
        1 x creating: homework.show (0.04%)
        173μs
        1 x creating: components.open-graph (0.04%)
        168μs
        1 x creating: components.forms.get-started (0.04%)
        148μs
        1 x composing: components.forms.contact-us (0.03%)
        131μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        124μs
        1 x creating: components.forms.free-tool-download (0.03%)
        121μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.03%)
        115μs
        1 x eloquent.booting: App\Models\Subject (0.02%)
        105μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        84μs
        1 x creating: components.forms.tutor-subscription-join (0.02%)
        84μs
        1 x composing: components.footer (0.02%)
        84μs
        1 x creating: components.forms.tutor-support (0.02%)
        83μs
        1 x composing: components.breadcrumbs (0.02%)
        79μs
        1 x composing: components.canonical (0.02%)
        78μs
        1 x composing: components.open-graph (0.02%)
        71μs
        1 x creating: components.footer (0.02%)
        71μs
        1 x composing: homework.show (0.02%)
        70μs
        1 x composing: site.headers.header (0.01%)
        50μs
        1 x composing: components.forms.free-tool-download (0.01%)
        49μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        46μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        43μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        43μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        43μs
        1 x composing: components.forms.tutor-support (0.01%)
        41μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        39μs
        1 x composing: site.layouts.app (0.01%)
        25μ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 duplicated41.55ms
      • 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` = '53919' limit 1
        12.33mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 53919
        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.91mstwenty4_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 (53919)
        1.03mstwenty4_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.16mstwenty4_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` <> 53919 and `subject` = 18 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        8.09mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 53919
        • 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.39mstwenty4_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` = 53919 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.07mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 53919
        • 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` = 53919 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        990μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 53919
        • 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` = 53919 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        810μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 53919
        • 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.8mstwenty4_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
        960μ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.2mstwenty4_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
        970μstwenty4_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.06mstwenty4_siteSubject.php#100
        Bindings
        • 0: 10
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 33 limit 1
        1.07mstwenty4_siteSubject.php#100
        Bindings
        • 0: 33
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 11 limit 1
        990μstwenty4_siteSubject.php#100
        Bindings
        • 0: 11
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 5 limit 1
        1.16mstwenty4_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.25mstwenty4_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.17mstwenty4_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.14mstwenty4_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\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      7HomeworkLibraryFile.php
      App\Models\Subject
      2Subject.php
          _token
          Hwl7A9ehdq88dCiXmCFWv9mESHynkibi6bkINJIs
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/Database-Development/53919
          _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/53919
          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-52a58d937e72c548280e34ab" ] "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=eyJpdiI6InQ0Vk1IT1ViNjRjY1pJSlNxMmVuZXc9PSIsInZhbHVlIjoiWm14WkxKZEFaV2MraDlucVVZY2V3U2dzZGNHdEdTOE11S3Y4LzVzTzNUN3dTcVdad3FTelJCNnVLSStaUk8xVXF3SUN6L2Y4SGZuN0NNRklxai9kSmVmRVNoUUx0dXVIWWVwVnFXR1VVUkVYVVAyZlVHSEJOUVQ1NmJBbzlINlciLCJtYWMiOiI3NjU2YTNhZTFmM2YzMTUzMmExNGQ1ZGE5OWQ5MGY1ZDk0NjM2NWUzZjU4OGQxYmFhNTk2MjY4ZDYwMDE2NjQ2IiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:26:05 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6InQ0Vk1IT1ViNjRjY1pJSlNxMmVuZXc9PSIsInZhbHVlIjoiWm14WkxKZEFaV2MraDlucVVZY2V3U2dzZGNHdEdTOE11S3Y4LzVzTzNUN3dTcVdad3FTelJCNnVLSStaUk8xVXF3SUN6L" 1 => "24houranswers_session=eyJpdiI6IndYai9yWDVNVjRHWnZHUGIyNkdDOVE9PSIsInZhbHVlIjoiYkpaamxrWkhucjlwOTJWZDNaSllZU1ZpSTlJNmQwMDBmMk9LZnMxWmZOTVN3aUozcEsxeHRJM2hFcklwc1hQT1M0WUtBQjhXaDhaV0ZxUEU3MExndjZKUm1vdHZMNkd3NjZSNGNDTCtRSHpJMW14S3ZiNGhwTGwvamgxb1Z5MHQiLCJtYWMiOiIzMmMzODQ0MGM5NWFhOGI1M2I1ZDEwZjhlODQzZDA2MGY0ODY5NzZmNDFlNTMzMDY4YWY1ZGFkZWFjMjM2YjNiIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:26:05 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IndYai9yWDVNVjRHWnZHUGIyNkdDOVE9PSIsInZhbHVlIjoiYkpaamxrWkhucjlwOTJWZDNaSllZU1ZpSTlJNmQwMDBmMk9LZnMxWmZOTVN3aUozcEsxeHRJM2hFcklwc1" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InQ0Vk1IT1ViNjRjY1pJSlNxMmVuZXc9PSIsInZhbHVlIjoiWm14WkxKZEFaV2MraDlucVVZY2V3U2dzZGNHdEdTOE11S3Y4LzVzTzNUN3dTcVdad3FTelJCNnVLSStaUk8xVXF3SUN6L2Y4SGZuN0NNRklxai9kSmVmRVNoUUx0dXVIWWVwVnFXR1VVUkVYVVAyZlVHSEJOUVQ1NmJBbzlINlciLCJtYWMiOiI3NjU2YTNhZTFmM2YzMTUzMmExNGQ1ZGE5OWQ5MGY1ZDk0NjM2NWUzZjU4OGQxYmFhNTk2MjY4ZDYwMDE2NjQ2IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:26:05 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6InQ0Vk1IT1ViNjRjY1pJSlNxMmVuZXc9PSIsInZhbHVlIjoiWm14WkxKZEFaV2MraDlucVVZY2V3U2dzZGNHdEdTOE11S3Y4LzVzTzNUN3dTcVdad3FTelJCNnVLSStaUk8xVXF3SUN6L" 1 => "24houranswers_session=eyJpdiI6IndYai9yWDVNVjRHWnZHUGIyNkdDOVE9PSIsInZhbHVlIjoiYkpaamxrWkhucjlwOTJWZDNaSllZU1ZpSTlJNmQwMDBmMk9LZnMxWmZOTVN3aUozcEsxeHRJM2hFcklwc1hQT1M0WUtBQjhXaDhaV0ZxUEU3MExndjZKUm1vdHZMNkd3NjZSNGNDTCtRSHpJMW14S3ZiNGhwTGwvamgxb1Z5MHQiLCJtYWMiOiIzMmMzODQ0MGM5NWFhOGI1M2I1ZDEwZjhlODQzZDA2MGY0ODY5NzZmNDFlNTMzMDY4YWY1ZGFkZWFjMjM2YjNiIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:26:05 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IndYai9yWDVNVjRHWnZHUGIyNkdDOVE9PSIsInZhbHVlIjoiYkpaamxrWkhucjlwOTJWZDNaSllZU1ZpSTlJNmQwMDBmMk9LZnMxWmZOTVN3aUozcEsxeHRJM2hFcklwc1" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "Hwl7A9ehdq88dCiXmCFWv9mESHynkibi6bkINJIs" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/Database-Development/53919" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/Database-Development/53919" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]