Question
In a randomized study (Storey, et al. 2005), clinicians administered endotoxin to four patients and placebo to four patients. For each patient, gene expression is recorded at time points between 0 and 24 hours (6 time points per patient). The files endotoxin_gene_exp.txt and endotoxin_info.txt contains this data for one particular gene. The goal of this experiment is to determine whether or not the gene expression profiles of patients over time differs between control and endotoxin treated patients. The null hypothesis is that these profiles do not differ. We will use regression to analyze this problem.

Problem 2, part a
We have two different covariates, class and time . class is clearly a factor. What are the advantages and disadvantages to treating time as a continuous variable or as a factor variable?

Problem 2, part b
Use linear regression and ANOVA to test the null hypothesis, and report a p-value.

Problem 2, part c
Continuing from part c, determine from your linear regression if the trajectories over time are different between the classes, or if only the mean expression levels are different.

Problem 2, part d
Use a natural cubic spline with a B-spline basis to test the null hypothesis, and report a p-value. Use the ns() function from the package splines in conjunction with lm() .

Problem 2, part e
Continuing from part d, and analogous to part c, determine from your natural cubic spline fit if the trajectories over time are different between classes, or if only the mean expression levels are different.
Problem 3: testing for genetic association

Recall from previous homeworks that single nucleotide polymorphisms (SNPs) in humans take the values 0, 1, and 2 and represent genetic variation. Consider the following genotype data for a single SNP in a case/control study for some disease. There are 600 patients (300 patients in each class):
Genotype 0 1 2
Has disease 111 143 46
No disease 161 117 22
We want to determine if this particular genetic variant is associated with this disease.

Problem 3, part a
Suppose that Hardy-Weinberg Equilibrium (HWE) holds. In statistical terms, this means that the SNPs can be modeled as the sum of two independent Bernoulli trials. Thus, the table of genotypes could be turned into a table of alleles:
Allele          0 1
Has disease 365 235
No disease 439 161
Obtain a measure of the effect of association, i.e. the log odds ratio of disease status as a function of the alleles, and compute a 95% confidence interval. Is the association between the disease status and the alleles significant at a $\alpha=0.05$ threshold?

Problem 3, part b
Suppose that HWE does not hold. We could go back to the original table and model the three genotypes separately as a categorical factor variable. Obtain the log odds ratios of disease status as a function of the genotypes, and compute 95% confidence intervals. Is the association between disease status and the genotypes significant at a $\alpha=0.05$ threshold?

Problem 3, part c
Instead of treating the genotype as a factor like in part b, we could try treating it as a numerical variable. Model the genotype as a continuous variable taking the integer values of 0, 1, and 2. Obtain the log odds ratio of disease status as a function of the genotypes, and compute a 95% confidence interval. Is the association between disease status and the genotypes significant at a $\alpha=0.05$ threshold?

Problem 3, part d
Use the likelihood ratio test to compare the model of part b with the model of part c, by using the anova() function specifying test as "Chisq" . What are the null and alternative hypotheses of this test? Interpret the results, especially in the context of a genetic model of dominance.
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.

# Converniting the data in long format
library(tidyr)
endotoxin_gene_exp_long<-gather(endotoxin_gene_exp,key = class,value = Values, 2:9)
endotoxin_gene_exp_long$class_org<-ifelse(endotoxin_gene_exp_long$class %in% c("sample_1","sample_2","sample_3","sample_4"),"Endotoxin","Control")

endotoxin_gene_exp_long<-na.omit(endotoxin_gene_exp_long)

# Problem 2
# We have two different covariates, class and time . class is clearly a factor. What are the advantages and disadvantages to treating time as a continuous variable or as a factor variable?

# The advanage of using time as a factor is that the data is collected in hour of the day format and there can be only 24 hours which should not be treated as continous variables, but by using time as factor we will not be able to assess gene expression profiles of patients for the times other than 2,4,6,9 and 24.

# but if we treat them as continous variable then the basic advantage is that we can asses the gene expression profiles of patients over a the time other than the predefined time in the dataset. For each sample time is from 0 to 24 hour and for either of the sample time can not have any other value than 0 to 24 so we should consider it as a factor variable.


#clopper pearson()

# Part b
# Use linear regression and ANOVA to test the null hypothesis, and report a p-value.

# Let's fit a regression model to see the behaviour of the profiles
FitRegression<-lm(Values~as.factor(time)+class_org,data=endotoxin_gene_exp_long)
summary(FitRegression)

# We can see from the above results that the model is giving a significant p-value of 2.425e-09 at f-Statistic 16.46, which means that the model is good to predict the variable under study. Also all the p-Values are coming to be significant except for the one i.e. the 24th hour time


# Now let's proceed with the ANOVA

FitANOVA<-aov(Values~as.factor(time)+class_org,data=endotoxin_gene_exp_long)
summary(FitANOVA)
This is only a preview of the solution.
Please use the purchase button to see the entire solution.
By purchasing this solution you'll be able to access the following files:
Solution.docx
Solution.R
Purchase Solution
$125.00
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Biology 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 Version582msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (343ms)time
    • Application (240ms)time
    • 1 x Booting (58.87%)
      343ms
      1 x Application (41.13%)
      240ms
      • Illuminate\Routing\Events\Routing (1.36ms)
      • Illuminate\Routing\Events\RouteMatched (526μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.23ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (226μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (206μs)
      • Illuminate\Database\Events\ConnectionEstablished (1.14ms)
      • Illuminate\Database\Events\StatementPrepared (7.31ms)
      • Illuminate\Database\Events\QueryExecuted (1.88ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (134μs)
      • eloquent.booting: App\Models\Subject (133μs)
      • eloquent.booted: App\Models\Subject (63μs)
      • Illuminate\Database\Events\StatementPrepared (2.09ms)
      • Illuminate\Database\Events\QueryExecuted (977μs)
      • eloquent.retrieved: App\Models\Subject (134μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (142μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (62μs)
      • Illuminate\Database\Events\StatementPrepared (801μs)
      • Illuminate\Database\Events\QueryExecuted (1.45ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (77μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (15μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.booting: App\Models\SubjectCat (821μs)
      • eloquent.booted: App\Models\SubjectCat (45μs)
      • Illuminate\Database\Events\StatementPrepared (645μs)
      • Illuminate\Database\Events\QueryExecuted (980μs)
      • eloquent.retrieved: App\Models\SubjectCat (90μs)
      • Illuminate\Cache\Events\CacheHit (18.41ms)
      • Illuminate\Cache\Events\CacheMissed (960μs)
      • Illuminate\Database\Events\StatementPrepared (1.07ms)
      • Illuminate\Database\Events\QueryExecuted (2.53ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (176μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (23μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • Illuminate\Database\Events\StatementPrepared (735μs)
      • Illuminate\Database\Events\QueryExecuted (965μs)
      • eloquent.retrieved: App\Models\Subject (182μs)
      • Illuminate\Cache\Events\KeyWritten (1.83ms)
      • Illuminate\Database\Events\StatementPrepared (2.14ms)
      • Illuminate\Database\Events\QueryExecuted (943μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (68μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (20μs)
      • Illuminate\Database\Events\StatementPrepared (1.06ms)
      • Illuminate\Database\Events\QueryExecuted (7.44ms)
      • Illuminate\Database\Events\StatementPrepared (2.29ms)
      • Illuminate\Database\Events\QueryExecuted (2.54ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (74μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (18μs)
      • Illuminate\Cache\Events\CacheHit (3.99ms)
      • creating: homework.show (303μs)
      • composing: homework.show (105μs)
      • creating: components.breadcrumbs (432μs)
      • composing: components.breadcrumbs (793μs)
      • Illuminate\Database\Events\StatementPrepared (3.35ms)
      • Illuminate\Database\Events\QueryExecuted (1.22ms)
      • eloquent.retrieved: App\Models\SubjectCat (108μs)
      • Illuminate\Cache\Events\CacheMissed (10.88ms)
      • Illuminate\Database\Events\StatementPrepared (796μs)
      • Illuminate\Database\Events\QueryExecuted (922μs)
      • eloquent.retrieved: App\Models\SubjectCat (107μs)
      • Illuminate\Cache\Events\KeyWritten (637μs)
      • Illuminate\Cache\Events\CacheHit (408μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (356μs)
      • Illuminate\Cache\Events\CacheHit (289μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheMissed (2.52ms)
      • Illuminate\Database\Events\StatementPrepared (560μs)
      • Illuminate\Database\Events\QueryExecuted (963μs)
      • eloquent.retrieved: App\Models\SubjectCat (83μs)
      • Illuminate\Cache\Events\KeyWritten (1.03ms)
      • Illuminate\Cache\Events\CacheHit (265μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (7.17ms)
      • Illuminate\Cache\Events\CacheHit (804μs)
      • Illuminate\Cache\Events\CacheHit (303μs)
      • Illuminate\Cache\Events\CacheMissed (902μs)
      • Illuminate\Database\Events\StatementPrepared (1.39ms)
      • Illuminate\Database\Events\QueryExecuted (2.06ms)
      • eloquent.retrieved: App\Models\SubjectCat (88μs)
      • Illuminate\Cache\Events\KeyWritten (4.03ms)
      • Illuminate\Cache\Events\CacheHit (305μs)
      • Illuminate\Cache\Events\CacheHit (236μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (3.95ms)
      • Illuminate\Cache\Events\CacheHit (2.64ms)
      • Illuminate\Cache\Events\CacheHit (266μs)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (2.12ms)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (531μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (784μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheMissed (5.43ms)
      • Illuminate\Database\Events\StatementPrepared (1.46ms)
      • Illuminate\Database\Events\QueryExecuted (996μs)
      • eloquent.retrieved: App\Models\SubjectCat (112μs)
      • Illuminate\Cache\Events\KeyWritten (568μs)
      • Illuminate\Cache\Events\CacheHit (1.09ms)
      • Illuminate\Cache\Events\CacheHit (381μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (295μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (396μs)
      • Illuminate\Cache\Events\CacheHit (302μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (311μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheMissed (296μs)
      • Illuminate\Database\Events\StatementPrepared (866μs)
      • Illuminate\Database\Events\QueryExecuted (977μs)
      • eloquent.retrieved: App\Models\SubjectCat (60μs)
      • Illuminate\Cache\Events\KeyWritten (299μs)
      • Illuminate\Cache\Events\CacheHit (1.07ms)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheMissed (278μs)
      • Illuminate\Database\Events\StatementPrepared (793μs)
      • Illuminate\Database\Events\QueryExecuted (1.3ms)
      • eloquent.retrieved: App\Models\SubjectCat (60μs)
      • Illuminate\Cache\Events\KeyWritten (428μs)
      • Illuminate\Cache\Events\CacheHit (1.15ms)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (283μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (283μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (345μs)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (1.23ms)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (313μs)
      • Illuminate\Cache\Events\CacheHit (235μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheMissed (291μs)
      • Illuminate\Database\Events\StatementPrepared (919μs)
      • Illuminate\Database\Events\QueryExecuted (2.79ms)
      • eloquent.retrieved: App\Models\SubjectCat (97μs)
      • Illuminate\Cache\Events\KeyWritten (327μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (282μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (423μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (262μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (380μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (376μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (239μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (256μs)
      • Illuminate\Cache\Events\CacheHit (256μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (422μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (290μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (316μs)
      • Illuminate\Cache\Events\CacheHit (338μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (263μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheMissed (199μs)
      • Illuminate\Database\Events\StatementPrepared (641μs)
      • Illuminate\Database\Events\QueryExecuted (935μs)
      • eloquent.retrieved: App\Models\SubjectCat (104μs)
      • Illuminate\Cache\Events\KeyWritten (454μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (289μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (336μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (278μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (281μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (1.04ms)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (253μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (274μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (346μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (273μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (310μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (328μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (244μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (3.91ms)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (2.64ms)
      • Illuminate\Cache\Events\CacheHit (1.21ms)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (327μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheMissed (201μs)
      • Illuminate\Database\Events\StatementPrepared (687μs)
      • Illuminate\Database\Events\QueryExecuted (980μs)
      • eloquent.retrieved: App\Models\SubjectCat (89μs)
      • Illuminate\Cache\Events\KeyWritten (303μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (251μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (730μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • creating: site.layouts.app (491μs)
      • composing: site.layouts.app (24μs)
      • creating: components.canonical (503μs)
      • composing: components.canonical (94μs)
      • creating: components.open-graph (225μs)
      • composing: components.open-graph (83μs)
      • creating: site.headers.header (255μs)
      • composing: site.headers.header (77μs)
      • Illuminate\Cache\Events\CacheHit (2.13ms)
      • creating: components.footer (80μs)
      • composing: components.footer (93μs)
      • Illuminate\Cache\Events\CacheHit (1.27ms)
      • Illuminate\Cache\Events\CacheMissed (270μs)
      • Illuminate\Database\Events\StatementPrepared (695μs)
      • Illuminate\Database\Events\QueryExecuted (1.12ms)
      • eloquent.retrieved: App\Models\SubjectCat (90μs)
      • Illuminate\Cache\Events\KeyWritten (371μs)
      • Illuminate\Cache\Events\CacheHit (250μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (557μs)
      • Illuminate\Cache\Events\CacheHit (455μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (518μs)
      • Illuminate\Cache\Events\CacheHit (324μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • creating: components.forms.contact-us (362μs)
      • composing: components.forms.contact-us (193μs)
      • creating: components.forms.get-started (202μs)
      • composing: components.forms.get-started (90μs)
      • creating: components.forms.free-tool-download (147μs)
      • composing: components.forms.free-tool-download (76μs)
      • creating: components.forms.claim-free-worksheet (141μs)
      • composing: components.forms.claim-free-worksheet (77μs)
      • creating: components.forms.tutor-subscription-waitlist (262μs)
      • composing: components.forms.tutor-subscription-waitlist (210μs)
      • creating: components.forms.tutor-subscription-join (165μs)
      • composing: components.forms.tutor-subscription-join (122μs)
      • creating: components.forms.tutor-support (145μs)
      • composing: components.forms.tutor-support (71μs)
      • 311 x Illuminate\Cache\Events\CacheHit (20.49%)
        119ms
        20 x Illuminate\Database\Events\QueryExecuted (5.83%)
        33.97ms
        20 x Illuminate\Database\Events\StatementPrepared (5.2%)
        30.31ms
        11 x Illuminate\Cache\Events\CacheMissed (3.82%)
        22.23ms
        11 x Illuminate\Cache\Events\KeyWritten (1.77%)
        10.28ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (0.73%)
        4.23ms
        1 x Illuminate\Routing\Events\Routing (0.23%)
        1.36ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.2%)
        1.14ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.19%)
        1.09ms
        1 x eloquent.booting: App\Models\SubjectCat (0.14%)
        821μs
        1 x composing: components.breadcrumbs (0.14%)
        793μs
        1 x Illuminate\Routing\Events\RouteMatched (0.09%)
        526μs
        1 x creating: components.canonical (0.09%)
        503μs
        1 x creating: site.layouts.app (0.08%)
        491μs
        1 x creating: components.breadcrumbs (0.07%)
        432μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.06%)
        363μs
        1 x creating: components.forms.contact-us (0.06%)
        362μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        316μs
        13 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.05%)
        312μs
        1 x creating: homework.show (0.05%)
        303μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.04%)
        262μs
        1 x creating: site.headers.header (0.04%)
        255μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        226μs
        1 x creating: components.open-graph (0.04%)
        225μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.04%)
        210μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        206μs
        1 x creating: components.forms.get-started (0.03%)
        202μs
        1 x composing: components.forms.contact-us (0.03%)
        193μs
        1 x creating: components.forms.tutor-subscription-join (0.03%)
        165μs
        1 x creating: components.forms.free-tool-download (0.03%)
        147μs
        1 x creating: components.forms.tutor-support (0.02%)
        145μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.02%)
        142μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        141μs
        1 x eloquent.booting: App\Models\Subject (0.02%)
        133μs
        1 x composing: components.forms.tutor-subscription-join (0.02%)
        122μs
        1 x composing: homework.show (0.02%)
        105μs
        1 x composing: components.canonical (0.02%)
        94μs
        1 x composing: components.footer (0.02%)
        93μs
        1 x composing: components.forms.get-started (0.02%)
        90μs
        1 x composing: components.open-graph (0.01%)
        83μs
        1 x creating: components.footer (0.01%)
        80μs
        1 x composing: site.headers.header (0.01%)
        77μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        77μs
        1 x composing: components.forms.free-tool-download (0.01%)
        76μs
        1 x composing: components.forms.tutor-support (0.01%)
        71μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        63μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        62μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        45μ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, 4 of which were duplicates, 16 unique. Show only duplicated42.68ms
      • 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` = '28575' limit 1
        8.08mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 28575
        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 (376)
        990μstwenty4_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 (28575)
        1.6mstwenty4_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` = 35 limit 1
        1.06mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 35
        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` <> 28575 and `subject` = 376 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        2.8mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 28575
        • 1: 376
        • 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 (376)
        1.02mstwenty4_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` = 28575 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        890μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 28575
        • 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` = 28575 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        7.43mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 28575
        • 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` = 28575 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        3.09mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 28575
        • 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` = 35 limit 1
        1.83mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 35
        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.08mstwenty4_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
        880μstwenty4_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.68mstwenty4_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.91mstwenty4_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.18mstwenty4_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.02mstwenty4_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
        2.93mstwenty4_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
        990μstwenty4_siteSubject.php#100
        Bindings
        • 0: 34
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 31 limit 1
        1.07mstwenty4_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.15mstwenty4_siteSubject.php#100
        Bindings
        • 0: 36
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 28. view::components.footer:170
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      13HomeworkLibraryFile.php
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          hqsyG2ZJwIqA3KtyQAjW7IxWKZmA6tcjh6DpIWmi
          utm_source
          direct
          redirectUrl
          /college-homework-library/Biology/Computational-Biology/28575
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Biology/Computa...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/Biology/Computational-Biology/28575
          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-67fff438-4ce6299a72eed0d2247c3131" ] "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.220.95.176" ] "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 => "Wed, 16 Apr 2025 18:17:28 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpIQ1lrdE1ybFpsWDhocmtZRkZoVHc9PSIsInZhbHVlIjoicG9QNDBrTGVMbmxabU02RUluWW1QUEswRWxZM1NiWEJidUMyQmx6UVZOdDhVcmNMQkxJczk2b1g4L3NxUjNYRTFObFMyQjlESlNFdkRTdzBaM0lqM1B1RUNyakVOQlEzZ0p1RC9FOHRKMUdQK3J6aDRwdkZJOGxXck12cWFTMEEiLCJtYWMiOiI4YTJmNjIyZWI5YzRiODUzNzhhOGExMjFjOGMwOGRiOWE2NGRkOTZiY2VhODk3ZmFiM2VmNTAxYjg5YTY4NGM3IiwidGFnIjoiIn0%3D; expires=Wed, 16 Apr 2025 20:17:28 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6ImpIQ1lrdE1ybFpsWDhocmtZRkZoVHc9PSIsInZhbHVlIjoicG9QNDBrTGVMbmxabU02RUluWW1QUEswRWxZM1NiWEJidUMyQmx6UVZOdDhVcmNMQkxJczk2b1g4L3NxUjNYRTFObFMyQ" 1 => "24houranswers_session=eyJpdiI6IjRvSUxCWWVIUWprQUU1b3Z0MmRYRWc9PSIsInZhbHVlIjoibnlxRjJ0a3N3L0pFTmhySlcyeTR1YkMwZ1krNG5QZW1NVXF1V3Y5THZHcm1GYlJMQ1VjRlBBbWcyb1A2QUROQnZGR25WSVhscEVrRVN6dDA4bFJOUFBEWm9SV00wWXhpNVBTSC9Jc2JIb1hmVnVTYWFLOWxHL3JQbXo3T2RkYTMiLCJtYWMiOiJiMGM2ZmIyYzk2NjJiM2U2ODdkMGY1NGVhMTNkMDM0MjY1YjY2NmIzODRmNGJhYTQ5OGM2YmJjZWRkNjY5NjIyIiwidGFnIjoiIn0%3D; expires=Wed, 16 Apr 2025 20:17:28 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IjRvSUxCWWVIUWprQUU1b3Z0MmRYRWc9PSIsInZhbHVlIjoibnlxRjJ0a3N3L0pFTmhySlcyeTR1YkMwZ1krNG5QZW1NVXF1V3Y5THZHcm1GYlJMQ1VjRlBBbWcyb1A2QU" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpIQ1lrdE1ybFpsWDhocmtZRkZoVHc9PSIsInZhbHVlIjoicG9QNDBrTGVMbmxabU02RUluWW1QUEswRWxZM1NiWEJidUMyQmx6UVZOdDhVcmNMQkxJczk2b1g4L3NxUjNYRTFObFMyQjlESlNFdkRTdzBaM0lqM1B1RUNyakVOQlEzZ0p1RC9FOHRKMUdQK3J6aDRwdkZJOGxXck12cWFTMEEiLCJtYWMiOiI4YTJmNjIyZWI5YzRiODUzNzhhOGExMjFjOGMwOGRiOWE2NGRkOTZiY2VhODk3ZmFiM2VmNTAxYjg5YTY4NGM3IiwidGFnIjoiIn0%3D; expires=Wed, 16-Apr-2025 20:17:28 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6ImpIQ1lrdE1ybFpsWDhocmtZRkZoVHc9PSIsInZhbHVlIjoicG9QNDBrTGVMbmxabU02RUluWW1QUEswRWxZM1NiWEJidUMyQmx6UVZOdDhVcmNMQkxJczk2b1g4L3NxUjNYRTFObFMyQ" 1 => "24houranswers_session=eyJpdiI6IjRvSUxCWWVIUWprQUU1b3Z0MmRYRWc9PSIsInZhbHVlIjoibnlxRjJ0a3N3L0pFTmhySlcyeTR1YkMwZ1krNG5QZW1NVXF1V3Y5THZHcm1GYlJMQ1VjRlBBbWcyb1A2QUROQnZGR25WSVhscEVrRVN6dDA4bFJOUFBEWm9SV00wWXhpNVBTSC9Jc2JIb1hmVnVTYWFLOWxHL3JQbXo3T2RkYTMiLCJtYWMiOiJiMGM2ZmIyYzk2NjJiM2U2ODdkMGY1NGVhMTNkMDM0MjY1YjY2NmIzODRmNGJhYTQ5OGM2YmJjZWRkNjY5NjIyIiwidGFnIjoiIn0%3D; expires=Wed, 16-Apr-2025 20:17:28 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IjRvSUxCWWVIUWprQUU1b3Z0MmRYRWc9PSIsInZhbHVlIjoibnlxRjJ0a3N3L0pFTmhySlcyeTR1YkMwZ1krNG5QZW1NVXF1V3Y5THZHcm1GYlJMQ1VjRlBBbWcyb1A2QU" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "hqsyG2ZJwIqA3KtyQAjW7IxWKZmA6tcjh6DpIWmi" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Biology/Computational-Biology/28575" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Biology/Computational-Biology/28575" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]