Question
(1)
We analyze the data set NCI60 data from the ISLR library.
library(ISLR) ncidata<-NCI60$data
(a) Delete the cancer types with only one or two cases (“K562A-repro”, etc.). Keep only the cancer types with more than 3 cases.
(b) Analyze the expression values of the first gene in the data (first column). Does the first gene express differently in different types of cancers? If so, in which pairs of cancer types does the first gene express differently? (Use FDR adjustment.)
(c) Check the model assumptions for analysis in part (b). Is ANOVA analysis appropriate here?
(d) Apply ANOVA analysis to each of the 6830 genes. At FDR level of 0.05, how many genes express differently among different types of cancer patients?

(2)
We analyze data for the B-cell patients in the ALL data set in the textbook.
(a) Select gene expression data for only the B-cell patients. The analysis in following parts will only use these gene expression data on the B-cell patients.
(b) Select only those genes whose coefficient of variance (i.e., standard deviation divided by the mean) is greater than 0.2. How many genes are selected?
(c) We wish to conduct clustering analysis to study natural groupings of the patients predicted by the gene expression profiles. For this analysis, we first need to reduce the number of genes studied. The filter in (b) is one such choice. Please comment on what filtering methods you would use to choose genes, other than the filter in (b). What would you consider as the best gene filter in this case.
(d) Conduct a hierarchical clustering analysis with filtered genes in (b). (For uniformity in grading, we ask everyone to use the filter in (b). It may not be your best filter in (c).) How do the clusters compare to the B-stages? How does do the clusters compare to the molecule biology types (in variable ALL$mol.biol)? Provide the confusion matrices of the comparisons, with 4 clusters.
(e) Draw two heatmaps for the expression data in (d), one for each comparison. Using colorbars to show the comparison types (B-stages or molecule biology types). The clusters reflect which types better: B-stages or molecule biology types?
(f) We focus on predicting the B-cell differentiation in the following analysis. We merge the last two categories “B3” and “B4”, so that we are studying 3 classes: “B1”, “B2” and “B34”. (Ignore the unknown type “B” in the analysis.) Use linear model (limma library) to select genes that expresses differently among these three classes at FDR of 0.05. How many genes are selected?
(g) Fit SVM and the classification tree on these selected genes in part (f), evaluate their performance with delete-one-cross-validated misclassification rate.
(h) We select the genes passing both filters in (b) and (f). How many genes are selected? Redo part (g) on these genes passing both filters.
(i) Which classifier you will consider best among the classifiers studied in part (g) and part (h)? Why?
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.

rm(list=ls())
# (1)
library(ISLR)
# data is a 64 by 6830 matrix of the expression values while labs is a vector listing the cancer
# types for the 64 cell lines. 6830 genes. So 1 gene has 64 cell lines.
ncidata <- NCI60$data
dim(ncidata)
# 64 x 6830
str(ncidata)
labs <- NCI60$labs
# length(labs) = 64.
labs
# [1] "CNS"         "CNS"         "CNS"         "RENAL"       "BREAST"      "CNS"         "CNS"         "BREAST"      "NSCLC"      
# [10] "NSCLC"       "RENAL"       "RENAL"       "RENAL"       "RENAL"       "RENAL"       "RENAL"       "RENAL"       "BREAST"   
# [19] "NSCLC"       "RENAL"       "UNKNOWN"    "OVARIAN"    "MELANOMA"    "PROSTATE"    "OVARIAN"    "OVARIAN"    "OVARIAN"   
# [28] "OVARIAN"    "OVARIAN"    "PROSTATE"    "NSCLC"       "NSCLC"       "NSCLC"       "LEUKEMIA"    "K562B-repro" "K562A-repro"
# [37] "LEUKEMIA"    "LEUKEMIA"    "LEUKEMIA"    "LEUKEMIA"    "LEUKEMIA"    "COLON"       "COLON"       "COLON"       "COLON"      
# [46] "COLON"       "COLON"       "COLON"       "MCF7A-repro" "BREAST"      "MCF7D-repro" "BREAST"      "NSCLC"       "NSCLC"      
# [55] "NSCLC"       "MELANOMA"    "BREAST"      "BREAST"      "MELANOMA"    "MELANOMA"    "MELANOMA"    "MELANOMA"    "MELANOMA"   
# [64] "MELANOMA"
table(labs)>2
cancer.types <- names(table(labs))[ table(labs)>2]
cancer.types
# [1] "BREAST"   "CNS"      "COLON"    "LEUKEMIA" "MELANOMA" "NSCLC"    "OVARIAN" "RENAL"
idx <- which( labs %in% cancer.types)
labs <- labs[idx]
ncidata <- ncidata[idx,]
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.R
Purchase Solution
$85.25
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Mathematics 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 Version812msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (493ms)time
    • Application (319ms)time
    • 1 x Booting (60.75%)
      493ms
      1 x Application (39.25%)
      319ms
      • Illuminate\Routing\Events\Routing (1.34ms)
      • Illuminate\Routing\Events\RouteMatched (3.45ms)
      • Illuminate\Foundation\Events\LocaleUpdated (14.82ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (424μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (215μs)
      • Illuminate\Database\Events\ConnectionEstablished (1.12ms)
      • Illuminate\Database\Events\StatementPrepared (13.86ms)
      • Illuminate\Database\Events\QueryExecuted (1.37ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (550μs)
      • eloquent.booting: App\Models\Subject (141μs)
      • eloquent.booted: App\Models\Subject (63μs)
      • Illuminate\Database\Events\StatementPrepared (6.08ms)
      • Illuminate\Database\Events\QueryExecuted (2ms)
      • eloquent.retrieved: App\Models\Subject (150μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (153μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (60μs)
      • Illuminate\Database\Events\StatementPrepared (812μs)
      • Illuminate\Database\Events\QueryExecuted (1.14ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (107μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (20μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
      • eloquent.booting: App\Models\SubjectCat (547μs)
      • eloquent.booted: App\Models\SubjectCat (61μs)
      • Illuminate\Database\Events\StatementPrepared (826μs)
      • Illuminate\Database\Events\QueryExecuted (1.27ms)
      • eloquent.retrieved: App\Models\SubjectCat (116μs)
      • Illuminate\Cache\Events\CacheHit (36.56ms)
      • Illuminate\Cache\Events\CacheMissed (262μs)
      • Illuminate\Database\Events\StatementPrepared (5.83ms)
      • Illuminate\Database\Events\QueryExecuted (12.28ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (75μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (17μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • Illuminate\Database\Events\StatementPrepared (1.03ms)
      • Illuminate\Database\Events\QueryExecuted (1.1ms)
      • eloquent.retrieved: App\Models\Subject (98μs)
      • Illuminate\Cache\Events\KeyWritten (1.24ms)
      • Illuminate\Database\Events\StatementPrepared (16.44ms)
      • Illuminate\Database\Events\QueryExecuted (1.37ms)
      • Illuminate\Database\Events\StatementPrepared (6.08ms)
      • Illuminate\Database\Events\QueryExecuted (1.72ms)
      • Illuminate\Database\Events\StatementPrepared (905μs)
      • Illuminate\Database\Events\QueryExecuted (1.38ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (80μs)
      • Illuminate\Cache\Events\CacheHit (988μs)
      • creating: homework.show (381μs)
      • composing: homework.show (158μs)
      • creating: components.breadcrumbs (343μs)
      • composing: components.breadcrumbs (163μs)
      • Illuminate\Database\Events\StatementPrepared (3.79ms)
      • Illuminate\Database\Events\QueryExecuted (1.38ms)
      • eloquent.retrieved: App\Models\SubjectCat (4.15ms)
      • Illuminate\Cache\Events\CacheMissed (10ms)
      • Illuminate\Database\Events\StatementPrepared (898μs)
      • Illuminate\Database\Events\QueryExecuted (1.26ms)
      • eloquent.retrieved: App\Models\SubjectCat (187μs)
      • Illuminate\Cache\Events\KeyWritten (497μs)
      • Illuminate\Cache\Events\CacheHit (311μs)
      • Illuminate\Cache\Events\CacheHit (277μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (282μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheMissed (295μs)
      • Illuminate\Database\Events\StatementPrepared (818μs)
      • Illuminate\Database\Events\QueryExecuted (1.21ms)
      • eloquent.retrieved: App\Models\SubjectCat (93μs)
      • Illuminate\Cache\Events\KeyWritten (524μs)
      • Illuminate\Cache\Events\CacheHit (2.64ms)
      • Illuminate\Cache\Events\CacheHit (3.48ms)
      • Illuminate\Cache\Events\CacheHit (408μs)
      • Illuminate\Cache\Events\CacheHit (1.64ms)
      • Illuminate\Cache\Events\CacheHit (478μs)
      • Illuminate\Cache\Events\CacheHit (334μs)
      • Illuminate\Cache\Events\CacheHit (320μs)
      • Illuminate\Cache\Events\CacheMissed (320μs)
      • Illuminate\Database\Events\StatementPrepared (1.94ms)
      • Illuminate\Database\Events\QueryExecuted (4.26ms)
      • eloquent.retrieved: App\Models\SubjectCat (96μs)
      • Illuminate\Cache\Events\KeyWritten (431μs)
      • Illuminate\Cache\Events\CacheHit (388μs)
      • Illuminate\Cache\Events\CacheHit (384μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (273μs)
      • Illuminate\Cache\Events\CacheHit (428μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (221μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (488μs)
      • Illuminate\Cache\Events\CacheHit (676μs)
      • Illuminate\Cache\Events\CacheHit (460μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (422μs)
      • Illuminate\Cache\Events\CacheHit (3.8ms)
      • Illuminate\Cache\Events\CacheHit (248μs)
      • Illuminate\Cache\Events\CacheHit (250μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (303μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheMissed (369μs)
      • Illuminate\Database\Events\StatementPrepared (873μs)
      • Illuminate\Database\Events\QueryExecuted (1.43ms)
      • eloquent.retrieved: App\Models\SubjectCat (99μs)
      • Illuminate\Cache\Events\KeyWritten (650μs)
      • Illuminate\Cache\Events\CacheHit (366μs)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (254μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (406μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (338μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (351μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (316μs)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (292μs)
      • Illuminate\Cache\Events\CacheMissed (414μs)
      • Illuminate\Database\Events\StatementPrepared (925μs)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • eloquent.retrieved: App\Models\SubjectCat (80μs)
      • Illuminate\Cache\Events\KeyWritten (385μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheMissed (344μs)
      • Illuminate\Database\Events\StatementPrepared (737μs)
      • Illuminate\Database\Events\QueryExecuted (8.79ms)
      • eloquent.retrieved: App\Models\SubjectCat (123μs)
      • Illuminate\Cache\Events\KeyWritten (451μs)
      • Illuminate\Cache\Events\CacheHit (317μs)
      • Illuminate\Cache\Events\CacheHit (299μs)
      • Illuminate\Cache\Events\CacheHit (351μs)
      • Illuminate\Cache\Events\CacheHit (451μs)
      • Illuminate\Cache\Events\CacheHit (252μs)
      • Illuminate\Cache\Events\CacheHit (357μs)
      • Illuminate\Cache\Events\CacheHit (240μs)
      • Illuminate\Cache\Events\CacheHit (264μs)
      • Illuminate\Cache\Events\CacheHit (265μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (1.12ms)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (276μs)
      • Illuminate\Cache\Events\CacheHit (326μs)
      • Illuminate\Cache\Events\CacheHit (261μs)
      • Illuminate\Cache\Events\CacheHit (240μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (4.3ms)
      • Illuminate\Cache\Events\CacheHit (300μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (379μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheMissed (339μs)
      • Illuminate\Database\Events\StatementPrepared (817μs)
      • Illuminate\Database\Events\QueryExecuted (1.25ms)
      • eloquent.retrieved: App\Models\SubjectCat (94μs)
      • Illuminate\Cache\Events\KeyWritten (361μs)
      • Illuminate\Cache\Events\CacheHit (375μs)
      • Illuminate\Cache\Events\CacheHit (271μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (333μs)
      • Illuminate\Cache\Events\CacheHit (315μs)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (379μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (221μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (263μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (318μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (256μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (252μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (252μs)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (262μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (302μs)
      • Illuminate\Cache\Events\CacheHit (418μs)
      • Illuminate\Cache\Events\CacheHit (384μs)
      • Illuminate\Cache\Events\CacheHit (268μs)
      • Illuminate\Cache\Events\CacheHit (548μs)
      • Illuminate\Cache\Events\CacheHit (288μs)
      • Illuminate\Cache\Events\CacheHit (580μs)
      • Illuminate\Cache\Events\CacheHit (475μs)
      • Illuminate\Cache\Events\CacheHit (296μs)
      • Illuminate\Cache\Events\CacheHit (356μs)
      • Illuminate\Cache\Events\CacheHit (335μs)
      • Illuminate\Cache\Events\CacheHit (326μs)
      • Illuminate\Cache\Events\CacheHit (390μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (247μs)
      • Illuminate\Cache\Events\CacheHit (284μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheMissed (351μs)
      • Illuminate\Database\Events\StatementPrepared (818μs)
      • Illuminate\Database\Events\QueryExecuted (1.16ms)
      • eloquent.retrieved: App\Models\SubjectCat (86μs)
      • Illuminate\Cache\Events\KeyWritten (527μs)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheHit (298μs)
      • Illuminate\Cache\Events\CacheHit (376μs)
      • Illuminate\Cache\Events\CacheHit (350μs)
      • Illuminate\Cache\Events\CacheHit (273μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (273μs)
      • Illuminate\Cache\Events\CacheHit (270μs)
      • Illuminate\Cache\Events\CacheHit (467μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (1.11ms)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (326μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (251μs)
      • Illuminate\Cache\Events\CacheHit (289μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (309μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (354μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (357μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (397μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (261μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (311μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (1.83ms)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (356μs)
      • Illuminate\Cache\Events\CacheHit (389μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (282μs)
      • Illuminate\Cache\Events\CacheHit (341μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheMissed (307μs)
      • Illuminate\Database\Events\StatementPrepared (895μs)
      • Illuminate\Database\Events\QueryExecuted (1.34ms)
      • eloquent.retrieved: App\Models\SubjectCat (95μs)
      • Illuminate\Cache\Events\KeyWritten (354μs)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (285μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (275μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (511μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • creating: site.layouts.app (586μs)
      • composing: site.layouts.app (24μs)
      • creating: components.canonical (644μs)
      • composing: components.canonical (213μs)
      • creating: components.open-graph (342μs)
      • composing: components.open-graph (147μs)
      • creating: site.headers.header (572μs)
      • composing: site.headers.header (85μs)
      • Illuminate\Cache\Events\CacheHit (2.18ms)
      • creating: components.footer (79μs)
      • composing: components.footer (97μs)
      • Illuminate\Cache\Events\CacheHit (1.24ms)
      • Illuminate\Cache\Events\CacheMissed (455μs)
      • Illuminate\Database\Events\StatementPrepared (4.71ms)
      • Illuminate\Database\Events\QueryExecuted (8.85ms)
      • eloquent.retrieved: App\Models\SubjectCat (109μs)
      • Illuminate\Cache\Events\KeyWritten (419μs)
      • Illuminate\Cache\Events\CacheHit (464μs)
      • Illuminate\Cache\Events\CacheHit (250μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (446μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (397μs)
      • Illuminate\Cache\Events\CacheHit (393μs)
      • Illuminate\Cache\Events\CacheHit (236μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • creating: components.forms.contact-us (387μs)
      • composing: components.forms.contact-us (252μs)
      • creating: components.forms.get-started (299μs)
      • composing: components.forms.get-started (101μs)
      • creating: components.forms.free-tool-download (179μs)
      • composing: components.forms.free-tool-download (80μs)
      • creating: components.forms.claim-free-worksheet (145μs)
      • composing: components.forms.claim-free-worksheet (78μs)
      • creating: components.forms.tutor-subscription-waitlist (212μs)
      • composing: components.forms.tutor-subscription-waitlist (142μs)
      • creating: components.forms.tutor-subscription-join (319μs)
      • composing: components.forms.tutor-subscription-join (145μs)
      • creating: components.forms.tutor-support (150μs)
      • composing: components.forms.tutor-support (80μs)
      • 311 x Illuminate\Cache\Events\CacheHit (16.41%)
        133ms
        20 x Illuminate\Database\Events\StatementPrepared (8.51%)
        69.09ms
        20 x Illuminate\Database\Events\QueryExecuted (6.85%)
        55.57ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.83%)
        14.82ms
        11 x Illuminate\Cache\Events\CacheMissed (1.66%)
        13.45ms
        11 x Illuminate\Cache\Events\KeyWritten (0.72%)
        5.83ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.66%)
        5.32ms
        1 x Illuminate\Routing\Events\RouteMatched (0.43%)
        3.45ms
        1 x Illuminate\Routing\Events\Routing (0.17%)
        1.34ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.14%)
        1.12ms
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.08%)
        669μs
        1 x creating: components.canonical (0.08%)
        644μs
        1 x creating: site.layouts.app (0.07%)
        586μs
        1 x creating: site.headers.header (0.07%)
        572μs
        1 x eloquent.booting: App\Models\SubjectCat (0.07%)
        547μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        424μs
        1 x creating: components.forms.contact-us (0.05%)
        387μs
        1 x creating: homework.show (0.05%)
        381μs
        1 x creating: components.breadcrumbs (0.04%)
        343μs
        1 x creating: components.open-graph (0.04%)
        342μs
        1 x creating: components.forms.tutor-subscription-join (0.04%)
        319μs
        1 x creating: components.forms.get-started (0.04%)
        299μs
        10 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        263μs
        1 x composing: components.forms.contact-us (0.03%)
        252μs
        2 x eloquent.retrieved: App\Models\Subject (0.03%)
        248μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.03%)
        215μs
        1 x composing: components.canonical (0.03%)
        213μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.03%)
        212μs
        1 x creating: components.forms.free-tool-download (0.02%)
        179μs
        1 x composing: components.breadcrumbs (0.02%)
        163μs
        1 x composing: homework.show (0.02%)
        158μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.02%)
        153μs
        1 x creating: components.forms.tutor-support (0.02%)
        150μs
        1 x composing: components.open-graph (0.02%)
        147μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        145μs
        1 x composing: components.forms.tutor-subscription-join (0.02%)
        145μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.02%)
        142μs
        1 x eloquent.booting: App\Models\Subject (0.02%)
        141μs
        1 x composing: components.forms.get-started (0.01%)
        101μs
        1 x composing: components.footer (0.01%)
        97μs
        1 x composing: site.headers.header (0.01%)
        85μs
        1 x composing: components.forms.free-tool-download (0.01%)
        80μs
        1 x composing: components.forms.tutor-support (0.01%)
        80μs
        1 x creating: components.footer (0.01%)
        79μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        78μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        63μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        61μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        60μs
        1 x composing: site.layouts.app (0%)
        24μ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 duplicated96.1ms
      • 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` = '20084' limit 1
        14.26mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 20084
        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 (299)
        3.8mstwenty4_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 (20084)
        1.09mstwenty4_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` = 1 limit 1
        1.04mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 1
        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` <> 20084 and `subject` = 299 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        17.18mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 20084
        • 1: 299
        • 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 (299)
        1.35mstwenty4_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` = 20084 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        14.14mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 20084
        • 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` = 20084 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        6.21mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 20084
        • 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` = 20084 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.07mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 20084
        • 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` = 1 limit 1
        3.48mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 1
        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.33mstwenty4_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.33mstwenty4_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.98mstwenty4_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.34mstwenty4_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.28mstwenty4_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
        8.77mstwenty4_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.3mstwenty4_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.22mstwenty4_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.31mstwenty4_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
        12.62mstwenty4_siteSubject.php#100
        Bindings
        • 0: 36
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 28. view::components.footer:170
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      10HomeworkLibraryFile.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          qHM6TN0FhnMVAsZcLCQMtd8nctPZCWeB1LoNnkrx
          utm_source
          direct
          redirectUrl
          /college-homework-library/Mathematics/Statistics-R-Programming/20084
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Mathematics/Sta...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/Mathematics/Statistics-R-Programming/20084
          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-67fd1028-1bb16a0a1b8fb7d2569bad39" ] "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 => "18.222.240.84" ] "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 => "Mon, 14 Apr 2025 13:39:53 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlQ3RDBJUjVKU1VYVjZHQnVVN3RHQkE9PSIsInZhbHVlIjoiQko1VmcvdWFMbDVHamxwNldKYTFZNXpGMlRKWGFJNDRnem5tM0N0QmhOV2JvZmRBSTd0ZE80YkVmNm9FWEMrV0VQNHRrc1pkTTVJMUNBUm83RndERk9oSWpvUThWeFNyL0lyVThFczhYVW1XWTdGYnBMeXpnM1dudWprTit4L0YiLCJtYWMiOiJkYzZkYTk0ZjcwODY1M2VlNWIwMjliZTA1Y2NjOTRhOTFiYTA1YzRiYjU3M2FiYjJmY2E0M2YzOTMwNGYxMDA5IiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 15:39:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6IlQ3RDBJUjVKU1VYVjZHQnVVN3RHQkE9PSIsInZhbHVlIjoiQko1VmcvdWFMbDVHamxwNldKYTFZNXpGMlRKWGFJNDRnem5tM0N0QmhOV2JvZmRBSTd0ZE80YkVmNm9FWEMrV0VQNHRrc" 1 => "24houranswers_session=eyJpdiI6Ik5nVHJ2VVhYdjNzdTNlWHkvZ2ZsZnc9PSIsInZhbHVlIjoiNkNCaVFZNnUwNkFJbEQ1RlZCTXVuQjdaVTNOc1F5MlVteXd1Rll1dFlnRHNXUk9hMXZpUkVROTgwM01VNlJBNkltcWFON0xvUDRjQUh4TWJZanRUeFpGVG5JTGpCbG1yRDBiNW51VUE3UXE1RjRGOWpnSUM3MExzTkxEa1VHNHciLCJtYWMiOiJjZmY5MjliODU2NDlkMTQ5MjI2YmJhMDYxNDlmM2NmZjE0OWM1YTNlOWYzODQyYjViNmRjM2ZiMjI3NmUzMjkxIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 15:39:53 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6Ik5nVHJ2VVhYdjNzdTNlWHkvZ2ZsZnc9PSIsInZhbHVlIjoiNkNCaVFZNnUwNkFJbEQ1RlZCTXVuQjdaVTNOc1F5MlVteXd1Rll1dFlnRHNXUk9hMXZpUkVROTgwM01VNl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlQ3RDBJUjVKU1VYVjZHQnVVN3RHQkE9PSIsInZhbHVlIjoiQko1VmcvdWFMbDVHamxwNldKYTFZNXpGMlRKWGFJNDRnem5tM0N0QmhOV2JvZmRBSTd0ZE80YkVmNm9FWEMrV0VQNHRrc1pkTTVJMUNBUm83RndERk9oSWpvUThWeFNyL0lyVThFczhYVW1XWTdGYnBMeXpnM1dudWprTit4L0YiLCJtYWMiOiJkYzZkYTk0ZjcwODY1M2VlNWIwMjliZTA1Y2NjOTRhOTFiYTA1YzRiYjU3M2FiYjJmY2E0M2YzOTMwNGYxMDA5IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 15:39:53 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6IlQ3RDBJUjVKU1VYVjZHQnVVN3RHQkE9PSIsInZhbHVlIjoiQko1VmcvdWFMbDVHamxwNldKYTFZNXpGMlRKWGFJNDRnem5tM0N0QmhOV2JvZmRBSTd0ZE80YkVmNm9FWEMrV0VQNHRrc" 1 => "24houranswers_session=eyJpdiI6Ik5nVHJ2VVhYdjNzdTNlWHkvZ2ZsZnc9PSIsInZhbHVlIjoiNkNCaVFZNnUwNkFJbEQ1RlZCTXVuQjdaVTNOc1F5MlVteXd1Rll1dFlnRHNXUk9hMXZpUkVROTgwM01VNlJBNkltcWFON0xvUDRjQUh4TWJZanRUeFpGVG5JTGpCbG1yRDBiNW51VUE3UXE1RjRGOWpnSUM3MExzTkxEa1VHNHciLCJtYWMiOiJjZmY5MjliODU2NDlkMTQ5MjI2YmJhMDYxNDlmM2NmZjE0OWM1YTNlOWYzODQyYjViNmRjM2ZiMjI3NmUzMjkxIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 15:39:53 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6Ik5nVHJ2VVhYdjNzdTNlWHkvZ2ZsZnc9PSIsInZhbHVlIjoiNkNCaVFZNnUwNkFJbEQ1RlZCTXVuQjdaVTNOc1F5MlVteXd1Rll1dFlnRHNXUk9hMXZpUkVROTgwM01VNl" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "qHM6TN0FhnMVAsZcLCQMtd8nctPZCWeB1LoNnkrx" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Mathematics/Statistics-R-Programming/20084" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Mathematics/Statistics-R-Programming/20084" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]