Question
Install the following package:
library(devtools) install_github("jdstorey/qvalue")

Problem 1: Modeling overdispersion in RNA-seq

We’ve already encountered RNA sequencing as a method for measuring gene expression. After processing, the data is often presented as nonnegative integer counts for each gene. Instinctively, we would hope to be able to use a Poisson distribution to model gene expression for each gene, but in practice, we often observe a phenomenon known as overdispersion. Overdispersion is where the mean-variance relationship for the Poisson distribution is broken, and the sample variance exceeds the sample mean. We would like to explore the sources of overdispersion using a carefully designed experiment.

We use a subset of data from an experiment published in Robinson, Wang, and Storey (2015). In this experiment, a common model organism S. cerevisiae (bakers yeast) was grown in a nested factorial fashion in order to capture variation introduced at each step. The steps are as follows:

1. Condition: a colony of yeast was split into two cultures, one grown in glucose limiting medium and the other in ethanol limiting medium. The two colonies are referred to by glucose and ethanol, respectively.

2. Biological replication: yeast growing in each culture was sampled twice, at different times.

3. Preparation effects: the four samples from the previous two steps were prepared twice for RNA sequencing using the sample protocol.

4. Lane effects: the eight samples from the previous three steps were prepared and sequenced in two separate lanes, for a total of 16 samples.

See Figure 1 in the manuscript for a graphical depiction of the experiment. Since the samples were prepared in this nested fashion, we hope to model the contributions to the observed overdispersion in each step of the experiment.

The data is available in the file yeast_rnaseq.txt. There are 6,000 genes. There is a header containing sample names, which identify the experimental design variable values. The file experimental_design.txt contains a mapping between the sample names and vectors showing which part of the experimental design each sample was taken from.

Some hints:

1. You may find it helpful to tidy your data.

2. We’ve mentioned the package broom in the past, but we haven’t had an exercise that uses it. You may find it very useful here, since you will be fitting many models simultaneously. It will tidy the output of lm() and glm() and plays well with do() from dplyr.

Problem 1, part a: Observed overdispersion

Plot the method of moments variance estimates versus the maximum likelihood variance estimates for each gene in this dataset. You should observe overdispersion in that the methods of moments variance estimates are larger than the MLE variances, and this deviation increases as a function of observed mean expression of each gene. Consider carefully the scale of the axes when making this plot.

Problem 1, part b: Model matrix for the experimental design

One strategy to model the sources of overdispersion is to fit a Poisson GLM implementing the experimental design in terms of explanatory variables. Use the R function model.matrix to implement the experimental design as numerical explanatory variables, with particular attention to the nested nature of the experiment. A big hint: the answer is in Figure S9 of the manuscript. Your use of model.matrix should use standard R model formula syntax (e.g., ~ age + weight + age:weight) and the output should match Figure S11. Since we are giving you the answer, we won’t accept solutions that just hard code the values.

Problem 1, part c: Poisson GLM

For each gene, fit a Poisson GLM with the gene expression as the response with an explanatory variables model as determined in part b. Then, extract the fitted Poisson fitted parameter for each observation. Treating the fitted paramaters values as MLE estimate of the Poisson variance accounting for the experimental design, remake the figure from part a, replacing the old MLE estimate with the Poisson GLM estimate. You should observe that the overdispersion is greatly reduced.

Problem 1, part d: explanation

Provide a brief explanation as to why the Poisson GLM model fit reduces apparent overdispersion. You do not need to do a lot of technical work here. We are looking for a brief argument that uses the statistical principles.


Problem 2: GEUVADIS data set

For this problem, we consider a simplified version of expression quantitative trait loci (eQTL) analysis. First, there is genome-wide gene expression data. Second, there is also corresponding genetic variation data (in our case, SNP genotypes). The goal is to identify genetic variants (SNPs) that are associated with the gene expression values. The hope is that detecting this type of association provides evidence that these variants are involved in the regulation of gene expression.

The data for this problem is sourced from the GEUVADIS project (http://www.geuvadis.org/web/geuvadis). We have provided a tiny subset of it consisting of gene expression values for the gene SHANK2, as well as genotypes for 1,000 SNPs. There are 458 individuals in this study.

There are two data files.

1. geuvadis_genotypes.txt: This contains the genotypes. There are no row names, but we recommend simply numbering the SNPs from 1 to 1000. The column header identifies the samples.
2. geuvadis_gene_exp.txt: This contains gene expression data as well as information about the samples.

Some general hints:

1. For the many responses models, building a combined tidy data.frame of all the data could help since that’ll give you easy access to the do() function.

2. However, for the LASSO, tidy format might not help by default since glmnet() takes vectors/matrices as input. You might want to try the package glmnetUtils.
3. Be very careful about the organization of the data. If the genotypes and expression values don’t match up for the same samples, the analysis won’t work! If you find yourself needing to change the order of a vector to match another vector, the base function match() will help.

Problem 2, part a: Exploring systematic variation in the data

Use PCA to explore systematic variation among the genotype variables by making biplots. We give you two additional pieces of information about each sample: the sample’s population and also the lab where the data was generated. Further, make a scree plot showing the proportion of variation explained by each PC.

Problem 2, part b: Transforming the response

Let’s examine the distribution of the gene expression values for SHANK2 to motivate a log transformation. Plot the distribution of the raw gene expression. Then, plot the distribution of the log transformed data. Note that since there are zeroes, you will need to use a pseudocount, i.e., add something to the argument of the log. One option is doing log(gene expression + 1), since this maps 0 to 0. Explain if the plots of these distributions visually justify the log transformation. Use the transformed gene expression for the rest of the problem.

Problem 2, part c: Accounting for variation in gene expression

Determine if there are differences in mean (transformed) gene expression, when the expression is modeled in terms of population or lab. First, assess this visually. Then, assess this using statistical inference (i.e., compute p-values using appropriate hypothesis tests).

Problem 2, part d: Multiple testing I

For each SNP, perform a test of association by fitting a simple linear model of the (transformed) gene expression as a function of the SNP.
Then, aggregate the p-values across SNPs and plot a p-value histogram. Finally, compute πˆ0 (estimated proportion of null tests) and identify which SNPs are significant at threshold corresponding to a false discovery rate (FDR) estimate ≤ 0.05, using the qvalue package. We will refer to this analysis as the “unadjusted analysis” in future parts of this problem.

Problem 2, part e: Multiple testing II

Repeat part d, except include as covariates the variables population and lab to adjust for possible confounding factors. Make sure to report the same results: histogram of p-values, πˆ0, and which SNPs are significant at FDR ≤ 0.05. How do the results compare to those of part d?

Problem 2, part f: Multiple regressors with LASSO

Perform LASSO regression using all the SNPs as explanatory variables and the (transformed) gene expression as the response variable. We recommend using the glmnet package. Don’t forget that LASSO regression has a tuning parameter, usually called λ, which you should determine using cross-validation. Since cross-validation is a random process, please set a seed! Plot the cross validation results (i.e., prediction error as a function of λ). Report which SNPs have non-zero coefficients at the chosen value of λ. Is this consistent with the unadjusted analysis in part d? Explain why or why not.

Hint: Use lambda.min instead of lambda.1se. The signal in this analysis is too weak to shrink away coefficients aggressively.

Problem 2, part g: Modeling many responses

Now, use logistic regression to perform a test of association for each SNP, treating genotype as a response variable modeled in ters of the transformed gene expression as an explanatory variable. Do your results agree with the unadjusted test for association in part d? Provide a theoretical justification for what you observe. We are not asking for a lot of technical work or algebra, but rather a demonstration of an understanding of the concepts.

Always include the session information.
sessionInfo()
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.

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
$150.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 Version558msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (352ms)time
    • Application (207ms)time
    • 1 x Booting (62.97%)
      352ms
      1 x Application (37.03%)
      207ms
      • Illuminate\Routing\Events\Routing (1.33ms)
      • Illuminate\Routing\Events\RouteMatched (529μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.8ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (267μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (214μs)
      • Illuminate\Database\Events\ConnectionEstablished (1.37ms)
      • Illuminate\Database\Events\StatementPrepared (11.88ms)
      • Illuminate\Database\Events\QueryExecuted (1.42ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (125μs)
      • eloquent.booting: App\Models\Subject (128μs)
      • eloquent.booted: App\Models\Subject (63μs)
      • Illuminate\Database\Events\StatementPrepared (2.14ms)
      • Illuminate\Database\Events\QueryExecuted (932μs)
      • eloquent.retrieved: App\Models\Subject (136μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (140μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (62μs)
      • Illuminate\Database\Events\StatementPrepared (724μs)
      • Illuminate\Database\Events\QueryExecuted (866μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (70μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (14μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μ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.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (4μ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.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (4μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (6μs)
      • eloquent.booting: App\Models\SubjectCat (611μs)
      • eloquent.booted: App\Models\SubjectCat (42μs)
      • Illuminate\Database\Events\StatementPrepared (924μs)
      • Illuminate\Database\Events\QueryExecuted (1.27ms)
      • eloquent.retrieved: App\Models\SubjectCat (88μs)
      • Illuminate\Cache\Events\CacheHit (16.99ms)
      • Illuminate\Cache\Events\CacheMissed (623μs)
      • Illuminate\Database\Events\StatementPrepared (1.26ms)
      • Illuminate\Database\Events\QueryExecuted (1.86ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (84μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (22μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (12μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (10μs)
      • Illuminate\Database\Events\StatementPrepared (806μs)
      • Illuminate\Database\Events\QueryExecuted (786μs)
      • eloquent.retrieved: App\Models\Subject (75μs)
      • Illuminate\Cache\Events\KeyWritten (889μs)
      • Illuminate\Database\Events\StatementPrepared (2.04ms)
      • Illuminate\Database\Events\QueryExecuted (1.39ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (62μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (20μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (11μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • Illuminate\Database\Events\StatementPrepared (2.23ms)
      • Illuminate\Database\Events\QueryExecuted (1.55ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (58μs)
      • Illuminate\Database\Events\StatementPrepared (780μs)
      • Illuminate\Database\Events\QueryExecuted (1.01ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (56μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (22μs)
      • Illuminate\Cache\Events\CacheHit (1.14ms)
      • creating: homework.show (428μs)
      • composing: homework.show (168μs)
      • creating: components.breadcrumbs (467μs)
      • composing: components.breadcrumbs (171μs)
      • Illuminate\Database\Events\StatementPrepared (1.59ms)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • eloquent.retrieved: App\Models\SubjectCat (67μs)
      • Illuminate\Cache\Events\CacheMissed (7.2ms)
      • Illuminate\Database\Events\StatementPrepared (767μs)
      • Illuminate\Database\Events\QueryExecuted (1.11ms)
      • eloquent.retrieved: App\Models\SubjectCat (92μs)
      • Illuminate\Cache\Events\KeyWritten (399μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (377μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (488μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (247μs)
      • Illuminate\Cache\Events\CacheMissed (199μs)
      • Illuminate\Database\Events\StatementPrepared (1.09ms)
      • Illuminate\Database\Events\QueryExecuted (956μs)
      • eloquent.retrieved: App\Models\SubjectCat (106μs)
      • Illuminate\Cache\Events\KeyWritten (404μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (1.47ms)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (315μs)
      • Illuminate\Cache\Events\CacheMissed (393μs)
      • Illuminate\Database\Events\StatementPrepared (701μs)
      • Illuminate\Database\Events\QueryExecuted (1.12ms)
      • eloquent.retrieved: App\Models\SubjectCat (86μs)
      • Illuminate\Cache\Events\KeyWritten (375μs)
      • Illuminate\Cache\Events\CacheHit (1.01ms)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (257μs)
      • Illuminate\Cache\Events\CacheHit (481μs)
      • Illuminate\Cache\Events\CacheHit (270μs)
      • Illuminate\Cache\Events\CacheHit (485μs)
      • Illuminate\Cache\Events\CacheHit (263μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (398μs)
      • Illuminate\Cache\Events\CacheHit (365μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheMissed (301μs)
      • Illuminate\Database\Events\StatementPrepared (1.16ms)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • eloquent.retrieved: App\Models\SubjectCat (60μs)
      • Illuminate\Cache\Events\KeyWritten (313μs)
      • Illuminate\Cache\Events\CacheHit (1.21ms)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (470μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (340μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (343μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (744μs)
      • Illuminate\Cache\Events\CacheHit (290μs)
      • Illuminate\Cache\Events\CacheHit (382μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheMissed (291μs)
      • Illuminate\Database\Events\StatementPrepared (806μs)
      • Illuminate\Database\Events\QueryExecuted (1.2ms)
      • eloquent.retrieved: App\Models\SubjectCat (121μs)
      • Illuminate\Cache\Events\KeyWritten (1.48ms)
      • Illuminate\Cache\Events\CacheHit (321μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (277μs)
      • Illuminate\Cache\Events\CacheHit (306μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheMissed (316μs)
      • Illuminate\Database\Events\StatementPrepared (689μs)
      • Illuminate\Database\Events\QueryExecuted (857μs)
      • eloquent.retrieved: App\Models\SubjectCat (84μs)
      • Illuminate\Cache\Events\KeyWritten (342μs)
      • Illuminate\Cache\Events\CacheHit (1.31ms)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (249μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (5.68ms)
      • Illuminate\Cache\Events\CacheHit (2.05ms)
      • Illuminate\Cache\Events\CacheHit (260μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (3.22ms)
      • Illuminate\Cache\Events\CacheHit (738μs)
      • Illuminate\Cache\Events\CacheHit (1.1ms)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (495μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (420μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheMissed (272μs)
      • Illuminate\Database\Events\StatementPrepared (910μs)
      • Illuminate\Database\Events\QueryExecuted (1.01ms)
      • eloquent.retrieved: App\Models\SubjectCat (180μs)
      • Illuminate\Cache\Events\KeyWritten (345μs)
      • Illuminate\Cache\Events\CacheHit (1.03ms)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (284μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (248μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (248μs)
      • Illuminate\Cache\Events\CacheHit (478μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (334μs)
      • Illuminate\Cache\Events\CacheHit (263μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (305μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (304μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (252μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (240μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (221μs)
      • Illuminate\Cache\Events\CacheHit (294μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheMissed (635μs)
      • Illuminate\Database\Events\StatementPrepared (786μs)
      • Illuminate\Database\Events\QueryExecuted (1.09ms)
      • eloquent.retrieved: App\Models\SubjectCat (56μs)
      • Illuminate\Cache\Events\KeyWritten (403μs)
      • Illuminate\Cache\Events\CacheHit (1.41ms)
      • Illuminate\Cache\Events\CacheHit (236μs)
      • Illuminate\Cache\Events\CacheHit (367μs)
      • Illuminate\Cache\Events\CacheHit (238μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (303μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (1.08ms)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (317μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (470μs)
      • Illuminate\Cache\Events\CacheHit (274μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (282μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (282μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (273μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (340μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (261μs)
      • Illuminate\Cache\Events\CacheHit (1.47ms)
      • Illuminate\Cache\Events\CacheHit (282μs)
      • Illuminate\Cache\Events\CacheHit (422μs)
      • Illuminate\Cache\Events\CacheHit (328μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (281μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (244μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheMissed (285μs)
      • Illuminate\Database\Events\StatementPrepared (870μs)
      • Illuminate\Database\Events\QueryExecuted (1.23ms)
      • eloquent.retrieved: App\Models\SubjectCat (61μs)
      • Illuminate\Cache\Events\KeyWritten (1.15ms)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (281μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (466μs)
      • Illuminate\Cache\Events\CacheHit (300μs)
      • Illuminate\Cache\Events\CacheHit (279μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (448μs)
      • Illuminate\Cache\Events\CacheHit (339μs)
      • Illuminate\Cache\Events\CacheHit (627μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (256μs)
      • creating: site.layouts.app (631μs)
      • composing: site.layouts.app (20μs)
      • creating: components.canonical (498μs)
      • composing: components.canonical (104μs)
      • creating: components.open-graph (370μs)
      • composing: components.open-graph (115μs)
      • creating: site.headers.header (562μs)
      • composing: site.headers.header (112μs)
      • Illuminate\Cache\Events\CacheHit (2.93ms)
      • creating: components.footer (80μs)
      • composing: components.footer (91μs)
      • Illuminate\Cache\Events\CacheHit (840μs)
      • Illuminate\Cache\Events\CacheMissed (242μs)
      • Illuminate\Database\Events\StatementPrepared (627μs)
      • Illuminate\Database\Events\QueryExecuted (1.34ms)
      • eloquent.retrieved: App\Models\SubjectCat (86μs)
      • Illuminate\Cache\Events\KeyWritten (1.92ms)
      • Illuminate\Cache\Events\CacheHit (292μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (301μs)
      • Illuminate\Cache\Events\CacheHit (413μs)
      • Illuminate\Cache\Events\CacheHit (271μs)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • creating: components.forms.contact-us (262μs)
      • composing: components.forms.contact-us (169μs)
      • creating: components.forms.get-started (129μs)
      • composing: components.forms.get-started (72μs)
      • creating: components.forms.free-tool-download (107μs)
      • composing: components.forms.free-tool-download (68μs)
      • creating: components.forms.claim-free-worksheet (103μs)
      • composing: components.forms.claim-free-worksheet (64μs)
      • creating: components.forms.tutor-subscription-waitlist (102μs)
      • composing: components.forms.tutor-subscription-waitlist (64μs)
      • creating: components.forms.tutor-subscription-join (101μs)
      • composing: components.forms.tutor-subscription-join (63μs)
      • creating: components.forms.tutor-support (97μs)
      • composing: components.forms.tutor-support (66μs)
      • 311 x Illuminate\Cache\Events\CacheHit (19.67%)
        110ms
        20 x Illuminate\Database\Events\StatementPrepared (5.87%)
        32.76ms
        20 x Illuminate\Database\Events\QueryExecuted (4.13%)
        23.06ms
        11 x Illuminate\Cache\Events\CacheMissed (1.93%)
        10.75ms
        11 x Illuminate\Cache\Events\KeyWritten (1.44%)
        8.02ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (0.86%)
        4.80ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.25%)
        1.37ms
        1 x Illuminate\Routing\Events\Routing (0.24%)
        1.33ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.19%)
        1.09ms
        1 x creating: site.layouts.app (0.11%)
        631μs
        1 x eloquent.booting: App\Models\SubjectCat (0.11%)
        611μs
        1 x creating: site.headers.header (0.1%)
        562μs
        1 x Illuminate\Routing\Events\RouteMatched (0.09%)
        529μs
        1 x creating: components.canonical (0.09%)
        498μs
        1 x creating: components.breadcrumbs (0.08%)
        467μs
        1 x creating: homework.show (0.08%)
        428μs
        23 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.07%)
        395μs
        1 x creating: components.open-graph (0.07%)
        370μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        276μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        267μs
        1 x creating: components.forms.contact-us (0.05%)
        262μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        214μs
        2 x eloquent.retrieved: App\Models\Subject (0.04%)
        211μs
        1 x composing: components.breadcrumbs (0.03%)
        171μs
        1 x composing: components.forms.contact-us (0.03%)
        169μs
        1 x composing: homework.show (0.03%)
        168μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        140μs
        1 x creating: components.forms.get-started (0.02%)
        129μs
        1 x eloquent.booting: App\Models\Subject (0.02%)
        128μs
        1 x composing: components.open-graph (0.02%)
        115μs
        1 x composing: site.headers.header (0.02%)
        112μs
        1 x creating: components.forms.free-tool-download (0.02%)
        107μs
        1 x composing: components.canonical (0.02%)
        104μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        103μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.02%)
        102μs
        1 x creating: components.forms.tutor-subscription-join (0.02%)
        101μs
        1 x creating: components.forms.tutor-support (0.02%)
        97μs
        1 x composing: components.footer (0.02%)
        91μs
        1 x creating: components.footer (0.01%)
        80μs
        1 x composing: components.forms.get-started (0.01%)
        72μs
        1 x composing: components.forms.free-tool-download (0.01%)
        68μs
        1 x composing: components.forms.tutor-support (0.01%)
        66μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        64μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        64μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        63μs
        1 x composing: components.forms.tutor-subscription-join (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%)
        42μs
        1 x composing: site.layouts.app (0%)
        20μ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 duplicated35.41ms
      • 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` = '28620' limit 1
        12.09mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 28620
        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)
        1.06mstwenty4_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 (28620)
        1.08mstwenty4_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.25mstwenty4_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` <> 28620 and `subject` = 376 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        2.32mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 28620
        • 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.08mstwenty4_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` = 28620 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 28620
        • 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` = 28620 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.91mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 28620
        • 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` = 28620 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        880μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 28620
        • 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.3mstwenty4_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.09mstwenty4_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.24mstwenty4_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.05mstwenty4_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.15mstwenty4_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.24mstwenty4_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.07mstwenty4_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.22mstwenty4_siteSubject.php#100
        Bindings
        • 0: 5
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 34 limit 1
        1.2mstwenty4_siteSubject.php#100
        Bindings
        • 0: 34
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 31 limit 1
        1.17mstwenty4_siteSubject.php#100
        Bindings
        • 0: 31
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 36 limit 1
        1.01mstwenty4_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
      23HomeworkLibraryFile.php
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          ZRamIyW8uiK92YTLxJSnn5k4dbuYCT5FtPERORmO
          utm_source
          direct
          redirectUrl
          /college-homework-library/Biology/Computational-Biology/28620
          _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/28620
          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-67fffc2f-37c572520a6f179f57ad2085" ] "host" => array:1 [ 0 => "staging.dev.24houranswers.com" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-forwarded-for" => array:1 [ 0 => "3.144.23.154" ] "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:51:28 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik1RUTdOZndCY0hMd0ZaSTM3SDZoU2c9PSIsInZhbHVlIjoiWFIwVVdjMmdNQTAwcU1ZN09nWDBXeUdocnFDZEMzWDlzcDJzUFpkTVFqRk9SWDVmaUZOc1BFTEdTdTZObXNxR0xFZTZxY2xvUFFRVVNTZzZLVStwS1RIVm5KMjBMUnQvS3haMTVKODVEQ1FsTDI5L0tMUXphVjIxcWUxbHY4S2oiLCJtYWMiOiI3Y2E4Yjg2OWQxYTcwNzg3ZWU1YTE2MTdhY2MzNmEyMjYyMjUzMTc3ZjI4OThkN2FkN2Y3NTEyMDY3MjQyNzQyIiwidGFnIjoiIn0%3D; expires=Wed, 16 Apr 2025 20:51:28 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6Ik1RUTdOZndCY0hMd0ZaSTM3SDZoU2c9PSIsInZhbHVlIjoiWFIwVVdjMmdNQTAwcU1ZN09nWDBXeUdocnFDZEMzWDlzcDJzUFpkTVFqRk9SWDVmaUZOc1BFTEdTdTZObXNxR0xFZTZxY" 1 => "24houranswers_session=eyJpdiI6InVyaTdGU1drN3ZldUtDZDE3K3JhU1E9PSIsInZhbHVlIjoiSm9OVUxUbmNRa2JQN2JodzVVUERJRk1VNWJzV2IxY3gwMHlncHhrbmNqbmIza2ovSFFCbThvUVN5ZWkyaTIydEI0TkVKWVMwaTczNkFQdTRVMk1SQTJVTlpvWW8xbVF5TGh0eHhHdGlhYklpa2pIMDlPU1laY09aZ2hrMGxZeFoiLCJtYWMiOiI0NWFjMjUyZGY4MmQ5ZGJhNGQyYzAwZjI0OTg3YmU1Y2I4MWI4NjY1NTU5NDljZWVhMjRiMTlhMWMxNjA5MWE3IiwidGFnIjoiIn0%3D; expires=Wed, 16 Apr 2025 20:51:28 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6InVyaTdGU1drN3ZldUtDZDE3K3JhU1E9PSIsInZhbHVlIjoiSm9OVUxUbmNRa2JQN2JodzVVUERJRk1VNWJzV2IxY3gwMHlncHhrbmNqbmIza2ovSFFCbThvUVN5ZWkyaT" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik1RUTdOZndCY0hMd0ZaSTM3SDZoU2c9PSIsInZhbHVlIjoiWFIwVVdjMmdNQTAwcU1ZN09nWDBXeUdocnFDZEMzWDlzcDJzUFpkTVFqRk9SWDVmaUZOc1BFTEdTdTZObXNxR0xFZTZxY2xvUFFRVVNTZzZLVStwS1RIVm5KMjBMUnQvS3haMTVKODVEQ1FsTDI5L0tMUXphVjIxcWUxbHY4S2oiLCJtYWMiOiI3Y2E4Yjg2OWQxYTcwNzg3ZWU1YTE2MTdhY2MzNmEyMjYyMjUzMTc3ZjI4OThkN2FkN2Y3NTEyMDY3MjQyNzQyIiwidGFnIjoiIn0%3D; expires=Wed, 16-Apr-2025 20:51:28 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6Ik1RUTdOZndCY0hMd0ZaSTM3SDZoU2c9PSIsInZhbHVlIjoiWFIwVVdjMmdNQTAwcU1ZN09nWDBXeUdocnFDZEMzWDlzcDJzUFpkTVFqRk9SWDVmaUZOc1BFTEdTdTZObXNxR0xFZTZxY" 1 => "24houranswers_session=eyJpdiI6InVyaTdGU1drN3ZldUtDZDE3K3JhU1E9PSIsInZhbHVlIjoiSm9OVUxUbmNRa2JQN2JodzVVUERJRk1VNWJzV2IxY3gwMHlncHhrbmNqbmIza2ovSFFCbThvUVN5ZWkyaTIydEI0TkVKWVMwaTczNkFQdTRVMk1SQTJVTlpvWW8xbVF5TGh0eHhHdGlhYklpa2pIMDlPU1laY09aZ2hrMGxZeFoiLCJtYWMiOiI0NWFjMjUyZGY4MmQ5ZGJhNGQyYzAwZjI0OTg3YmU1Y2I4MWI4NjY1NTU5NDljZWVhMjRiMTlhMWMxNjA5MWE3IiwidGFnIjoiIn0%3D; expires=Wed, 16-Apr-2025 20:51:28 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6InVyaTdGU1drN3ZldUtDZDE3K3JhU1E9PSIsInZhbHVlIjoiSm9OVUxUbmNRa2JQN2JodzVVUERJRk1VNWJzV2IxY3gwMHlncHhrbmNqbmIza2ovSFFCbThvUVN5ZWkyaT" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "ZRamIyW8uiK92YTLxJSnn5k4dbuYCT5FtPERORmO" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Biology/Computational-Biology/28620" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Biology/Computational-Biology/28620" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]