Question
The purpose of the assignment is to test your skills in developing a small database using Database Management System (DBMS) and to apply the knowledge that you learn on manipulating queries.

REQUIREMENT / ASSIGNMENT QUESTION

Create a database with the tables listed below. Choose appropriate data types for each attribute.
Doctor (DoctorID, DoctorName, DepartmentName, HospitalID, City, Salary)
Patient (PatientID, PatientName, Sex, Birthdate, City, Phone, Disease, Bed, Room, HospitalID)
Hospital(HospitalID, HospitalName)
Treatment (DoctorID, PatientID, TypeofTreatment)

Using Microsoft Access (or any other DBMS tool), create the tables (using DDL SQL), and enter sample data (using DDL SQL or GUI). 10 records per table is enough. The data must satisfy the following constraint:
* there are at least 3 hospitals
* each bed of any room can only be assigned to one patient
* each room has no more than 3 patients
* each doctor only works in one hospital
* for each doctor, he or she should be in the same hospital with all the patients treated by him or her

Make sure you create the relationship between tables, also using DDL SQL. Then, write DML SQL queries that answer the questions below (one query per question) and run them.

1. Retrieve the name and address of patients who live in Kuala Lumpur and treated by Dr. Anwar.
2. Retrieve the name and salary of all doctors who can treat disease “Cancer” and who earn more than RM55,000.
3. Retrieve the name, sex and age of every patient in room 307 at Sungai Buloh hospital.
4. Retrieve the name, age and phone number of every female patient.
5. Retrieve the name of every doctor who has at least one male patient older than 75.
6. Dr. Ken is retiring, move all his patients to some other doctors and delete existing records relating to him. Make sure that all constraints are satisfied.

You should hand in a printout of:
1. Each query used to create the tables.
2. Each table which shows table name, the fields and the sample records.
3. The relationships between tables.
4. Each query in “SQL View”, so that the grader can see your SQL code.
5. The result of each query.
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.

Create table queries

CREATE TABLE [HOSPITAL](
[HOSPITALID] number PRIMARY KEY NOT NULL,
[HOSPITALNAME] text NULL
);


CREATE TABLE [DOCTOR](
[DOCTORID] number PRIMARY KEY NOT NULL,
[DOCTORNAME] text NULL,
[DEPARTMENTNAME] text NULL,
[HOSPITALID] number NULL,
[CITY] text NULL,
[SALARY] number NULL,
FOREIGN KEY (HOSPITALID) REFERENCES HOSPITAL(HOSPITALID)
);


CREATE TABLE [PATIENT](
[PATIENTID] number PRIMARY KEY NOT NULL,
[PATIENTNAME] text NULL,
[SEX] text NULL,
[BIRTHDATE] [datetime] NULL,
[CITY] text NULL,
[PHONE] text NULL,
[DISEASE] text NULL,
[BED] number NULL,
[ROOM] number NULL,
[HOSPITALID] number NULL,
FOREIGN KEY (HOSPITALID) REFERENCES HOSPITAL(HOSPITALID)
);

CREATE TABLE [TREATMENT](
[DOCTORID] number NULL,
[PATIENTID] number NULL,
[TYPEOFTREATMENT] text NULL,
FOREIGN KEY (DOCTORID) REFERENCES DOCTOR(DOCTORID),
FOREIGN KEY (PATIENTID) REFERENCES PATIENT(PATIENTID)
);
This is only a preview of the solution.
Please use the purchase button to see the entire solution.
By purchasing this solution you'll be able to access the following files:
Solution.zip
Purchase Solution
$1.30
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 Version431msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (269ms)time
    • Application (162ms)time
    • 1 x Booting (62.35%)
      269ms
      1 x Application (37.65%)
      162ms
      • Illuminate\Routing\Events\Routing (1.38ms)
      • Illuminate\Routing\Events\RouteMatched (528μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.49ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (183μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (169μs)
      • Illuminate\Database\Events\ConnectionEstablished (924μs)
      • Illuminate\Database\Events\StatementPrepared (15.28ms)
      • Illuminate\Database\Events\QueryExecuted (1.14ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (241μs)
      • eloquent.booting: App\Models\Subject (154μs)
      • eloquent.booted: App\Models\Subject (65μs)
      • Illuminate\Database\Events\StatementPrepared (2.06ms)
      • Illuminate\Database\Events\QueryExecuted (1.76ms)
      • eloquent.retrieved: App\Models\Subject (106μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (96μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (39μs)
      • Illuminate\Database\Events\StatementPrepared (754μs)
      • Illuminate\Database\Events\QueryExecuted (1.03ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (86μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (15μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.booting: App\Models\SubjectCat (391μs)
      • eloquent.booted: App\Models\SubjectCat (43μs)
      • Illuminate\Database\Events\StatementPrepared (702μs)
      • Illuminate\Database\Events\QueryExecuted (929μs)
      • eloquent.retrieved: App\Models\SubjectCat (84μs)
      • Illuminate\Cache\Events\CacheHit (10.86ms)
      • Illuminate\Cache\Events\CacheMissed (190μs)
      • Illuminate\Database\Events\StatementPrepared (959μs)
      • Illuminate\Database\Events\QueryExecuted (8.6ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (110μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (16μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • Illuminate\Database\Events\StatementPrepared (729μs)
      • Illuminate\Database\Events\QueryExecuted (1.51ms)
      • eloquent.retrieved: App\Models\Subject (96μs)
      • Illuminate\Cache\Events\KeyWritten (961μs)
      • Illuminate\Database\Events\StatementPrepared (1.95ms)
      • Illuminate\Database\Events\QueryExecuted (861μs)
      • Illuminate\Database\Events\StatementPrepared (755μs)
      • Illuminate\Database\Events\QueryExecuted (952μs)
      • Illuminate\Database\Events\StatementPrepared (823μs)
      • Illuminate\Database\Events\QueryExecuted (901μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (52μs)
      • Illuminate\Cache\Events\CacheHit (612μs)
      • creating: homework.show (276μs)
      • composing: homework.show (124μs)
      • creating: components.breadcrumbs (276μs)
      • composing: components.breadcrumbs (113μs)
      • Illuminate\Database\Events\StatementPrepared (1.22ms)
      • Illuminate\Database\Events\QueryExecuted (1.39ms)
      • eloquent.retrieved: App\Models\SubjectCat (86μs)
      • Illuminate\Cache\Events\CacheMissed (4.84ms)
      • Illuminate\Database\Events\StatementPrepared (687μs)
      • Illuminate\Database\Events\QueryExecuted (914μs)
      • eloquent.retrieved: App\Models\SubjectCat (71μs)
      • Illuminate\Cache\Events\KeyWritten (297μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheMissed (129μs)
      • Illuminate\Database\Events\StatementPrepared (676μs)
      • Illuminate\Database\Events\QueryExecuted (1.08ms)
      • eloquent.retrieved: App\Models\SubjectCat (70μs)
      • Illuminate\Cache\Events\KeyWritten (320μs)
      • Illuminate\Cache\Events\CacheHit (1.55ms)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheMissed (205μs)
      • Illuminate\Database\Events\StatementPrepared (815μs)
      • Illuminate\Database\Events\QueryExecuted (838μs)
      • eloquent.retrieved: App\Models\SubjectCat (74μs)
      • Illuminate\Cache\Events\KeyWritten (294μs)
      • Illuminate\Cache\Events\CacheHit (1.17ms)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheMissed (216μs)
      • Illuminate\Database\Events\StatementPrepared (759μs)
      • Illuminate\Database\Events\QueryExecuted (1.08ms)
      • eloquent.retrieved: App\Models\SubjectCat (68μs)
      • Illuminate\Cache\Events\KeyWritten (1.59ms)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheMissed (133μs)
      • Illuminate\Database\Events\StatementPrepared (703μs)
      • Illuminate\Database\Events\QueryExecuted (792μs)
      • eloquent.retrieved: App\Models\SubjectCat (78μs)
      • Illuminate\Cache\Events\KeyWritten (331μs)
      • Illuminate\Cache\Events\CacheHit (1.12ms)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheMissed (287μs)
      • Illuminate\Database\Events\StatementPrepared (810μs)
      • Illuminate\Database\Events\QueryExecuted (1.1ms)
      • eloquent.retrieved: App\Models\SubjectCat (70μs)
      • Illuminate\Cache\Events\KeyWritten (1.49ms)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (675μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheMissed (340μs)
      • Illuminate\Database\Events\StatementPrepared (742μs)
      • Illuminate\Database\Events\QueryExecuted (899μs)
      • eloquent.retrieved: App\Models\SubjectCat (71μs)
      • Illuminate\Cache\Events\KeyWritten (299μs)
      • Illuminate\Cache\Events\CacheHit (1.29ms)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheMissed (219μs)
      • Illuminate\Database\Events\StatementPrepared (799μs)
      • Illuminate\Database\Events\QueryExecuted (1.12ms)
      • eloquent.retrieved: App\Models\SubjectCat (84μs)
      • Illuminate\Cache\Events\KeyWritten (371μs)
      • Illuminate\Cache\Events\CacheHit (1.44ms)
      • Illuminate\Cache\Events\CacheHit (249μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (248μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (327μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (1.14ms)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (387μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheMissed (287μs)
      • Illuminate\Database\Events\StatementPrepared (840μs)
      • Illuminate\Database\Events\QueryExecuted (972μs)
      • eloquent.retrieved: App\Models\SubjectCat (72μs)
      • Illuminate\Cache\Events\KeyWritten (1.34ms)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • creating: site.layouts.app (347μs)
      • composing: site.layouts.app (18μs)
      • creating: components.canonical (344μs)
      • composing: components.canonical (74μ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 (78μs)
      • composing: components.footer (77μs)
      • Illuminate\Cache\Events\CacheHit (692μs)
      • Illuminate\Cache\Events\CacheMissed (277μs)
      • Illuminate\Database\Events\StatementPrepared (1.1ms)
      • Illuminate\Database\Events\QueryExecuted (1.23ms)
      • eloquent.retrieved: App\Models\SubjectCat (72μs)
      • Illuminate\Cache\Events\KeyWritten (1.44ms)
      • Illuminate\Cache\Events\CacheHit (287μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (244μs)
      • creating: components.forms.contact-us (191μs)
      • composing: components.forms.contact-us (114μs)
      • creating: components.forms.get-started (114μs)
      • composing: components.forms.get-started (45μs)
      • creating: components.forms.free-tool-download (72μs)
      • composing: components.forms.free-tool-download (40μs)
      • creating: components.forms.claim-free-worksheet (65μs)
      • composing: components.forms.claim-free-worksheet (38μs)
      • creating: components.forms.tutor-subscription-waitlist (64μs)
      • composing: components.forms.tutor-subscription-waitlist (37μs)
      • creating: components.forms.tutor-subscription-join (62μs)
      • composing: components.forms.tutor-subscription-join (37μs)
      • creating: components.forms.tutor-support (63μs)
      • composing: components.forms.tutor-support (46μs)
      • 311 x Illuminate\Cache\Events\CacheHit (15.52%)
        66.85ms
        20 x Illuminate\Database\Events\StatementPrepared (7.7%)
        33.17ms
        20 x Illuminate\Database\Events\QueryExecuted (6.76%)
        29.11ms
        11 x Illuminate\Cache\Events\KeyWritten (2.03%)
        8.73ms
        11 x Illuminate\Cache\Events\CacheMissed (1.65%)
        7.12ms
        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.21%)
        924μs
        12 x eloquent.retrieved: App\Models\SubjectCat (0.21%)
        901μs
        1 x Illuminate\Routing\Events\RouteMatched (0.12%)
        528μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.09%)
        396μs
        1 x eloquent.booting: App\Models\SubjectCat (0.09%)
        391μs
        1 x creating: site.layouts.app (0.08%)
        347μs
        1 x creating: components.canonical (0.08%)
        344μs
        1 x creating: components.breadcrumbs (0.06%)
        276μs
        1 x creating: homework.show (0.06%)
        276μs
        1 x creating: site.headers.header (0.05%)
        220μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        202μs
        1 x creating: components.forms.contact-us (0.04%)
        191μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        183μs
        6 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.04%)
        173μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        169μs
        1 x eloquent.booting: App\Models\Subject (0.04%)
        154μs
        1 x creating: components.open-graph (0.03%)
        143μs
        1 x composing: homework.show (0.03%)
        124μs
        1 x creating: components.forms.get-started (0.03%)
        114μs
        1 x composing: components.forms.contact-us (0.03%)
        114μs
        1 x composing: components.breadcrumbs (0.03%)
        113μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.02%)
        96μs
        1 x creating: components.footer (0.02%)
        78μs
        1 x composing: components.footer (0.02%)
        77μs
        1 x composing: components.canonical (0.02%)
        74μs
        1 x creating: components.forms.free-tool-download (0.02%)
        72μs
        1 x eloquent.booted: App\Models\Subject (0.02%)
        65μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        65μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.01%)
        64μs
        1 x creating: components.forms.tutor-support (0.01%)
        63μs
        1 x creating: components.forms.tutor-subscription-join (0.01%)
        62μ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.tutor-support (0.01%)
        46μs
        1 x composing: components.forms.get-started (0.01%)
        45μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        43μs
        1 x composing: components.forms.free-tool-download (0.01%)
        40μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        39μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        38μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        37μs
        1 x composing: components.forms.tutor-subscription-join (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.49ms
      • Connection Establishedtwenty4_siteHomeworkLibraryController.php#91
        Backtrace
        • 13. app/Http/Controllers/HomeworkLibraryController.php:91
        • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `solutionslibrary` where `status` = 'published' and `price` > 0 and `solutionslibrary`.`id` = '10748' limit 1
        15.59mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 10748
        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)
        2mstwenty4_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 (10748)
        1.25mstwenty4_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.11mstwenty4_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` <> 10748 and `subject` = 18 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        8.74mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 10748
        • 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` = 10748 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.19mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 10748
        • 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` = 10748 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        950μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 10748
        • 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` = 10748 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.07mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 10748
        • 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.62mstwenty4_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.07mstwenty4_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.31mstwenty4_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.22mstwenty4_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.32mstwenty4_siteSubject.php#100
        Bindings
        • 0: 10
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 33 limit 1
        1.08mstwenty4_siteSubject.php#100
        Bindings
        • 0: 33
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 11 limit 1
        1.29mstwenty4_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.08mstwenty4_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.2mstwenty4_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.19mstwenty4_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.53mstwenty4_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
      6HomeworkLibraryFile.php
      App\Models\Subject
      2Subject.php
          _token
          3hKXbH7VejE7bAS1KWIEbnh2N4Q31bFuTOSeCTPq
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/Database-Development/10748
          _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/10748
          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-5c145e4c1e9e40cb773e8d42" ] "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=eyJpdiI6IlNVVVZCMSszL3dPTUg2LzJzMXdSM2c9PSIsInZhbHVlIjoid2xSWWRNbk9CTXFFckF3Vjc1T0pib2dsckExNHN0RTFpZ2ZnV2E2dXJyZzYwb2phd3FjWmdXb2E0QnRWS3ppRlJlN1pEL1lLclVoOXFiNFdxMXEzVU5FY2M5dGdpVjNBZGIrdnNqME11TExmOXd6YkUrVW5hWEJOcmRWL0htNEEiLCJtYWMiOiI0MjU3Mjg3ODQ3NGNiYzIwMjE1NmY1MDMyOThmNzkzY2IxMzE3Njc3ODVhZTI3MTM0NGFmZjVjYWU2MWZhNmEyIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:38:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6IlNVVVZCMSszL3dPTUg2LzJzMXdSM2c9PSIsInZhbHVlIjoid2xSWWRNbk9CTXFFckF3Vjc1T0pib2dsckExNHN0RTFpZ2ZnV2E2dXJyZzYwb2phd3FjWmdXb2E0QnRWS3ppRlJlN1pEL" 1 => "24houranswers_session=eyJpdiI6IjRKVklFUVBmS1JOa0M1ZXJTN1dsT1E9PSIsInZhbHVlIjoiVzJWSlNQUzRZQmlZcnhDQkFaSGJMZGRlOG1tdWh5UVUwL3ZXTmdOb3ZNNk11TGpwZW5BdGRJdSs5QlpxWlA0N0ZUVnVrd2ZPSS9wWHA0OHJTZTZUMmhNWCtvYzh2bHBPWW5TMkk3WDZNenIwekQ3a1d4ZjRvbHdlOGQ3SHl6b2giLCJtYWMiOiJlODNmMWVmM2NhNjcyNTllNjc0ZmQwNjVkYWMzNTI3ZDBkOTM0MzI3MTUyM2YwMWM3ZWUwNjg0NDcyYTEzZWMwIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 07:38:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IjRKVklFUVBmS1JOa0M1ZXJTN1dsT1E9PSIsInZhbHVlIjoiVzJWSlNQUzRZQmlZcnhDQkFaSGJMZGRlOG1tdWh5UVUwL3ZXTmdOb3ZNNk11TGpwZW5BdGRJdSs5QlpxWl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlNVVVZCMSszL3dPTUg2LzJzMXdSM2c9PSIsInZhbHVlIjoid2xSWWRNbk9CTXFFckF3Vjc1T0pib2dsckExNHN0RTFpZ2ZnV2E2dXJyZzYwb2phd3FjWmdXb2E0QnRWS3ppRlJlN1pEL1lLclVoOXFiNFdxMXEzVU5FY2M5dGdpVjNBZGIrdnNqME11TExmOXd6YkUrVW5hWEJOcmRWL0htNEEiLCJtYWMiOiI0MjU3Mjg3ODQ3NGNiYzIwMjE1NmY1MDMyOThmNzkzY2IxMzE3Njc3ODVhZTI3MTM0NGFmZjVjYWU2MWZhNmEyIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:38:53 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6IlNVVVZCMSszL3dPTUg2LzJzMXdSM2c9PSIsInZhbHVlIjoid2xSWWRNbk9CTXFFckF3Vjc1T0pib2dsckExNHN0RTFpZ2ZnV2E2dXJyZzYwb2phd3FjWmdXb2E0QnRWS3ppRlJlN1pEL" 1 => "24houranswers_session=eyJpdiI6IjRKVklFUVBmS1JOa0M1ZXJTN1dsT1E9PSIsInZhbHVlIjoiVzJWSlNQUzRZQmlZcnhDQkFaSGJMZGRlOG1tdWh5UVUwL3ZXTmdOb3ZNNk11TGpwZW5BdGRJdSs5QlpxWlA0N0ZUVnVrd2ZPSS9wWHA0OHJTZTZUMmhNWCtvYzh2bHBPWW5TMkk3WDZNenIwekQ3a1d4ZjRvbHdlOGQ3SHl6b2giLCJtYWMiOiJlODNmMWVmM2NhNjcyNTllNjc0ZmQwNjVkYWMzNTI3ZDBkOTM0MzI3MTUyM2YwMWM3ZWUwNjg0NDcyYTEzZWMwIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 07:38:53 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IjRKVklFUVBmS1JOa0M1ZXJTN1dsT1E9PSIsInZhbHVlIjoiVzJWSlNQUzRZQmlZcnhDQkFaSGJMZGRlOG1tdWh5UVUwL3ZXTmdOb3ZNNk11TGpwZW5BdGRJdSs5QlpxWl" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "3hKXbH7VejE7bAS1KWIEbnh2N4Q31bFuTOSeCTPq" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/Database-Development/10748" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/Database-Development/10748" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]