Question
Examination of protein-ligand interactions through bioinformatics and its relation to drug design
Background:
Proteins bind ligands/substrates through molecular interactions provided by specific amino acids in the binding pocket. These interactions (e.g. hydrogen bond, hydrophobic interactions, and electrostatic interactions etc.) are key to binding and in turn modulating the proteins function. As a result, one common drug design strategy is to design molecules that would make favorable interactions to these essential amino acids in order to outcompete the native substrate and inhibit the protein’s function. At the same time, regions that can change can be important to take advantage of for designing organism specific drugs and avoiding off-target effects (e.g. maybe you want the drug inert in humans but highly functional in dogs). In this case you want to take advantage of the sequence differences between species. In this lab, you are going to identify and visualize these important amino acids through protein sequence analysis using bioinformatics tools.
Instructions:
1. We are going to use a sequence visualization program (Jalview). This is where we can identify the residues we think are interacting with the molecule in the active site.
2. On the page of your protein from the pdb website, click on fasta sequence under the “Display Files” menu.
3. This will display the fasta sequence on your browser (which is the amino acid sequence for your enzyme).
4. Copy this sequence then go to the BLAST web server
5. Select Protein Blast (blastp)
6. Paste in your sequence. Wait! Don’t hit submit, instead lets add some paramters to make sure you have enough diversity in sequences to get a good analysis of conservation:
a. Change database to: Reference Proteins (refseq_protein). This database is a bit less redundant than the default nr database. Ideally we would use a database that is nonredundant on the 75% level (other servers such as HMMER allow that, but they are more difficult to use).
b. Expand “Algorithm Parameters” and select 250 on “Max Target Sequences”. This will
make sure you have enough sequences to measure conservation while making sure that all the proteins identified are predicted to be highly related.
*IMPORTANT NOTE: If you see %’s in the “Ident” column in the blast results going below 30% re-adjust this to 100 or even 50. Below 30% you are in what is considered the “twighlight” zone and the sequences you are finding are not necessarily related in structure or function. Basically, you have drifted too far in evolutionary space. Roughly speaking, 30-70% Ident it has been found that proteins are both related in protein structure and function, above 70% it is almost certain that proteins are almost identical in structure and function.
7. Hit “BLAST” to initiate search results
8. Analyze your results, make sure all the hits are “Pink or Red” for alignment score (i.e. large portions of the sequence aligned). And in the “Descriptions” table with “Sequences producing significant alignments” make sure the Ident column never goes below 30. If it does, see note above.
9. If all looks good, Select “Multiple Alignment” near the top in the “Other Reports” section.
10. From this output (don’t worry if an error is thrown for graphical overview) select:
“Download” -> Fasta plus gaps
13. Now we are going to open another program named Jalview (http://www.jalview.org/). Click Launch Jalview Desktop open the downloaded file.
14. Under the “File” menu, hit Input Alignment, from file and open the alignment file you just downloaded from the BLAST.
15. Under Jalview hit colour tab at top, then click percentage identity, now go back to color and click above identity threshold. Change occurrence to 99% conserved.
15. The residues highlighted here are either critical for protein structure or function. All of the residues you identified in lab 1 (i.e. the catalytic residues) should be highlighted.
16. Using Jalview and using percentage identity and moving the bar back and forth you can determine the percent conservation for a residue (look at switch from being
colored to not colored).
17. Now, in the assignment below you will need to find non-catalytic residues (i.e. residues not directly involved in the reaction mechanism) that are either highly conserved OR have low conservation. Roughly speaking (based on search paramters above):
High Conservation residues have >70% identity across the homologous sequences
Low Conservation residues have <30% identity across the homologous sequences
Residues in the 30-70% range a likely important but not critical for structure or function.
Assignment for lab 2
For your assigned enzyme group complete the following assignments with the help of the Lab 2 instructions:
1) What NON-CATALYTIC residues in the active site of the enzyme are most likely important for function?
a. Highlight three highly conservative residues, show both structural interactions AND conservation using PyMol and JalView. Hypothesize why they are critical for function.
b. Highlight one low conservation residue, show both structural interactions AND conservation using Pymol and JalView. What other amino acids are observed, hypothesize why the alternate residues are ok.
2) How does the inhibitor interact and how would you further optimize?
a. Describe WHY it acts as an inhibitor.
b. What key interactions are made with the inhibitor? Do any of those interactions mimic the natural substrate?
c. If you were to modify the inhibitor what new interactions would you try to take advantage of? (hint…conserved residues in the protein are unlikely to change while maintaining protein structure or function)
Case 1 = ACE: 2X91
Case 2 = OD: 2TOD
Case 3 = α-Fucosidase: 2ZX5
Case 4 = PNP: 1A9S
Case 5 =CD: 2FR6
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
Purchase Solution
$50.00 $25
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Medicine and Nursing 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 Version425msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (253ms)time
    • Application (172ms)time
    • 1 x Booting (59.5%)
      253ms
      1 x Application (40.49%)
      172ms
      • Illuminate\Routing\Events\Routing (1.26ms)
      • Illuminate\Routing\Events\RouteMatched (559μs)
      • Illuminate\Foundation\Events\LocaleUpdated (8.79ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (235μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (231μs)
      • Illuminate\Database\Events\ConnectionEstablished (1.09ms)
      • Illuminate\Database\Events\StatementPrepared (7.52ms)
      • Illuminate\Database\Events\QueryExecuted (1.24ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (136μs)
      • eloquent.booting: App\Models\Subject (141μs)
      • eloquent.booted: App\Models\Subject (60μs)
      • Illuminate\Database\Events\StatementPrepared (2.05ms)
      • Illuminate\Database\Events\QueryExecuted (895μs)
      • eloquent.retrieved: App\Models\Subject (131μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (142μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (56μs)
      • Illuminate\Database\Events\StatementPrepared (632μs)
      • Illuminate\Database\Events\QueryExecuted (1.07ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (97μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (51μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.booting: App\Models\SubjectCat (639μs)
      • eloquent.booted: App\Models\SubjectCat (58μs)
      • Illuminate\Database\Events\StatementPrepared (723μs)
      • Illuminate\Database\Events\QueryExecuted (880μs)
      • eloquent.retrieved: App\Models\SubjectCat (103μs)
      • Illuminate\Cache\Events\CacheHit (13.4ms)
      • Illuminate\Cache\Events\CacheMissed (880μs)
      • Illuminate\Database\Events\StatementPrepared (1.03ms)
      • Illuminate\Database\Events\QueryExecuted (2.63ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (116μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (22μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (11μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (9μs)
      • Illuminate\Database\Events\StatementPrepared (821μs)
      • Illuminate\Database\Events\QueryExecuted (951μs)
      • eloquent.retrieved: App\Models\Subject (124μs)
      • Illuminate\Cache\Events\KeyWritten (987μs)
      • Illuminate\Database\Events\StatementPrepared (2.26ms)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • Illuminate\Database\Events\StatementPrepared (833μs)
      • Illuminate\Database\Events\QueryExecuted (1.27ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (70μs)
      • Illuminate\Database\Events\StatementPrepared (994μs)
      • Illuminate\Database\Events\QueryExecuted (1.15ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (63μs)
      • Illuminate\Cache\Events\CacheHit (831μs)
      • creating: homework.show (430μs)
      • composing: homework.show (124μs)
      • creating: components.breadcrumbs (429μs)
      • composing: components.breadcrumbs (194μs)
      • Illuminate\Database\Events\StatementPrepared (1.5ms)
      • Illuminate\Database\Events\QueryExecuted (855μs)
      • eloquent.retrieved: App\Models\SubjectCat (94μs)
      • Illuminate\Cache\Events\CacheMissed (5.02ms)
      • Illuminate\Database\Events\StatementPrepared (785μs)
      • Illuminate\Database\Events\QueryExecuted (940μs)
      • eloquent.retrieved: App\Models\SubjectCat (73μs)
      • Illuminate\Cache\Events\KeyWritten (411μs)
      • Illuminate\Cache\Events\CacheHit (310μs)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (339μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheMissed (302μs)
      • Illuminate\Database\Events\StatementPrepared (647μs)
      • Illuminate\Database\Events\QueryExecuted (971μs)
      • eloquent.retrieved: App\Models\SubjectCat (66μs)
      • Illuminate\Cache\Events\KeyWritten (490μs)
      • Illuminate\Cache\Events\CacheHit (307μs)
      • Illuminate\Cache\Events\CacheHit (258μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (273μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheMissed (329μs)
      • Illuminate\Database\Events\StatementPrepared (769μs)
      • Illuminate\Database\Events\QueryExecuted (1.17ms)
      • eloquent.retrieved: App\Models\SubjectCat (172μs)
      • Illuminate\Cache\Events\KeyWritten (504μs)
      • Illuminate\Cache\Events\CacheHit (300μs)
      • Illuminate\Cache\Events\CacheHit (272μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (251μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (272μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (236μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheMissed (332μs)
      • Illuminate\Database\Events\StatementPrepared (878μs)
      • Illuminate\Database\Events\QueryExecuted (984μs)
      • eloquent.retrieved: App\Models\SubjectCat (88μs)
      • Illuminate\Cache\Events\KeyWritten (310μs)
      • Illuminate\Cache\Events\CacheHit (236μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (400μs)
      • Illuminate\Cache\Events\CacheHit (408μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (240μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (381μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (461μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheMissed (288μs)
      • Illuminate\Database\Events\StatementPrepared (1.07ms)
      • Illuminate\Database\Events\QueryExecuted (849μs)
      • eloquent.retrieved: App\Models\SubjectCat (96μs)
      • Illuminate\Cache\Events\KeyWritten (563μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheMissed (218μs)
      • Illuminate\Database\Events\StatementPrepared (778μs)
      • Illuminate\Database\Events\QueryExecuted (831μs)
      • eloquent.retrieved: App\Models\SubjectCat (78μs)
      • Illuminate\Cache\Events\KeyWritten (303μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (539μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (262μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (931μs)
      • Illuminate\Cache\Events\CacheHit (389μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (324μs)
      • Illuminate\Cache\Events\CacheHit (265μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (235μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheMissed (303μs)
      • Illuminate\Database\Events\StatementPrepared (977μs)
      • Illuminate\Database\Events\QueryExecuted (1.05ms)
      • eloquent.retrieved: App\Models\SubjectCat (95μs)
      • Illuminate\Cache\Events\KeyWritten (376μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (405μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (441μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (254μs)
      • Illuminate\Cache\Events\CacheHit (329μs)
      • Illuminate\Cache\Events\CacheHit (284μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (375μs)
      • Illuminate\Cache\Events\CacheHit (236μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (277μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (1.49ms)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (569μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheMissed (302μs)
      • Illuminate\Database\Events\StatementPrepared (821μs)
      • Illuminate\Database\Events\QueryExecuted (1.07ms)
      • eloquent.retrieved: App\Models\SubjectCat (96μs)
      • Illuminate\Cache\Events\KeyWritten (393μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (347μs)
      • Illuminate\Cache\Events\CacheHit (287μs)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (975μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (327μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (207μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheMissed (279μs)
      • Illuminate\Database\Events\StatementPrepared (853μs)
      • Illuminate\Database\Events\QueryExecuted (1.47ms)
      • eloquent.retrieved: App\Models\SubjectCat (99μs)
      • Illuminate\Cache\Events\KeyWritten (372μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (289μs)
      • Illuminate\Cache\Events\CacheHit (276μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • creating: site.layouts.app (496μs)
      • composing: site.layouts.app (25μs)
      • creating: components.canonical (550μs)
      • composing: components.canonical (117μs)
      • creating: components.open-graph (266μs)
      • composing: components.open-graph (93μs)
      • creating: site.headers.header (414μs)
      • composing: site.headers.header (86μs)
      • Illuminate\Cache\Events\CacheHit (2.42ms)
      • creating: components.footer (83μs)
      • composing: components.footer (101μs)
      • Illuminate\Cache\Events\CacheHit (1.04ms)
      • Illuminate\Cache\Events\CacheMissed (399μs)
      • Illuminate\Database\Events\StatementPrepared (821μs)
      • Illuminate\Database\Events\QueryExecuted (1.2ms)
      • eloquent.retrieved: App\Models\SubjectCat (96μs)
      • Illuminate\Cache\Events\KeyWritten (389μs)
      • Illuminate\Cache\Events\CacheHit (340μs)
      • Illuminate\Cache\Events\CacheHit (231μs)
      • Illuminate\Cache\Events\CacheHit (319μs)
      • Illuminate\Cache\Events\CacheHit (286μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (330μs)
      • Illuminate\Cache\Events\CacheHit (357μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (215μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • creating: components.forms.contact-us (323μs)
      • composing: components.forms.contact-us (206μs)
      • creating: components.forms.get-started (220μs)
      • composing: components.forms.get-started (94μs)
      • creating: components.forms.free-tool-download (149μs)
      • composing: components.forms.free-tool-download (82μs)
      • creating: components.forms.claim-free-worksheet (142μs)
      • composing: components.forms.claim-free-worksheet (79μs)
      • creating: components.forms.tutor-subscription-waitlist (143μs)
      • composing: components.forms.tutor-subscription-waitlist (80μs)
      • creating: components.forms.tutor-subscription-join (157μs)
      • composing: components.forms.tutor-subscription-join (77μs)
      • creating: components.forms.tutor-support (189μs)
      • composing: components.forms.tutor-support (80μs)
      • 311 x Illuminate\Cache\Events\CacheHit (19.44%)
        82.74ms
        20 x Illuminate\Database\Events\StatementPrepared (6.29%)
        26.76ms
        20 x Illuminate\Database\Events\QueryExecuted (5.29%)
        22.50ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (2.07%)
        8.79ms
        11 x Illuminate\Cache\Events\CacheMissed (2.03%)
        8.66ms
        11 x Illuminate\Cache\Events\KeyWritten (1.2%)
        5.10ms
        1 x Illuminate\Routing\Events\Routing (0.3%)
        1.26ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.27%)
        1.16ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.26%)
        1.09ms
        1 x eloquent.booting: App\Models\SubjectCat (0.15%)
        639μs
        1 x Illuminate\Routing\Events\RouteMatched (0.13%)
        559μs
        1 x creating: components.canonical (0.13%)
        550μs
        1 x creating: site.layouts.app (0.12%)
        496μs
        1 x creating: homework.show (0.1%)
        430μs
        1 x creating: components.breadcrumbs (0.1%)
        429μs
        1 x creating: site.headers.header (0.1%)
        414μs
        9 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.08%)
        328μs
        1 x creating: components.forms.contact-us (0.08%)
        323μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.07%)
        313μs
        1 x creating: components.open-graph (0.06%)
        266μs
        2 x eloquent.retrieved: App\Models\Subject (0.06%)
        255μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.06%)
        235μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        231μs
        1 x creating: components.forms.get-started (0.05%)
        220μs
        1 x composing: components.forms.contact-us (0.05%)
        206μs
        1 x composing: components.breadcrumbs (0.05%)
        194μs
        1 x creating: components.forms.tutor-support (0.04%)
        189μs
        1 x creating: components.forms.tutor-subscription-join (0.04%)
        157μs
        1 x creating: components.forms.free-tool-download (0.04%)
        149μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.03%)
        143μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        142μs
        1 x creating: components.forms.claim-free-worksheet (0.03%)
        142μs
        1 x eloquent.booting: App\Models\Subject (0.03%)
        141μs
        1 x composing: homework.show (0.03%)
        124μs
        1 x composing: components.canonical (0.03%)
        117μs
        1 x composing: components.footer (0.02%)
        101μs
        1 x composing: components.forms.get-started (0.02%)
        94μs
        1 x composing: components.open-graph (0.02%)
        93μs
        1 x composing: site.headers.header (0.02%)
        86μs
        1 x creating: components.footer (0.02%)
        83μs
        1 x composing: components.forms.free-tool-download (0.02%)
        82μs
        1 x composing: components.forms.tutor-support (0.02%)
        80μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.02%)
        80μs
        1 x composing: components.forms.claim-free-worksheet (0.02%)
        79μs
        1 x composing: components.forms.tutor-subscription-join (0.02%)
        77μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        60μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        58μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        56μs
        1 x composing: site.layouts.app (0.01%)
        25μs
      14 templates were rendered
      • 1x homework.showshow.blade.phpblade
      • 1x components.breadcrumbsbreadcrumbs.blade.phpblade
      • 1x site.layouts.appapp.blade.phpblade
      • 1x components.canonicalcanonical.blade.phpblade
      • 1x components.open-graphopen-graph.blade.phpblade
      • 1x site.headers.headerheader.blade.phpblade
      • 1x components.footerfooter.blade.phpblade
      • 1x components.forms.contact-uscontact-us.blade.phpblade
      • 1x components.forms.get-startedget-started.blade.phpblade
      • 1x components.forms.free-tool-downloadfree-tool-download.blade.phpblade
      • 1x components.forms.claim-free-worksheetclaim-free-worksheet.blade.phpblade
      • 1x components.forms.tutor-subscription-waitlisttutor-subscription-waitlist.blade.phpblade
      • 1x components.forms.tutor-subscription-jointutor-subscription-join.blade.phpblade
      • 1x components.forms.tutor-supporttutor-support.blade.phpblade
      uri
      GET college-homework-library/{category}/{subject}/{id}
      middleware
      web, utm.parameters
      controller
      App\Http\Controllers\HomeworkLibraryController@show
      namespace
      where
      as
      homework.show
      file
      app/Http/Controllers/HomeworkLibraryController.php:79-176
      20 statements were executed, 4 of which were duplicates, 16 unique. Show only duplicated31.46ms
      • 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` = '50309' limit 1
        7.79mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 50309
        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 (93)
        950μ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 (50309)
        1mstwenty4_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` = 32 limit 1
        960μstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 32
        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` <> 50309 and `subject` = 93 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        2.72mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 50309
        • 1: 93
        • 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 (93)
        1.04mstwenty4_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` = 50309 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.08mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 50309
        • 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` = 50309 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.29mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 50309
        • 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` = 50309 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.2mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 50309
        • 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` = 32 limit 1
        1.14mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 32
        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.1mstwenty4_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.04mstwenty4_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.16mstwenty4_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.25mstwenty4_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.33mstwenty4_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.12mstwenty4_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.32mstwenty4_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.16mstwenty4_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.58mstwenty4_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.23mstwenty4_siteSubject.php#100
        Bindings
        • 0: 36
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 28. view::components.footer:170
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      9HomeworkLibraryFile.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          XcDJE1XEzPMkSBspwIxMAqbxTGZmUtL4bsA9GvGl
          utm_source
          direct
          redirectUrl
          /college-homework-library/Medicine-and-Nursing/Pharmacology/50309
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Medicine-and-Nu...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/Medicine-and-Nursing/Pharmacology/50309
          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-680cc3c9-64b5685565d3efc36023fcb0" ] "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.118.114.72" ] "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 => "Sat, 26 Apr 2025 11:30:17 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhoMVY3Znk4Ym1qYXRmczR6VjBNRGc9PSIsInZhbHVlIjoiclVnUWRERXcvN3dYSCtXamI5a2tFbGdFSkFpMjZ2WkFXYmV6b0c3enRGa2VyM09CQzdiblBHVjUyUVdienNvNjIraXNaVUQrQWlkaWFScHB3UlFvY1hQWTRpUVpJNnp3VU00czlyaTBtTnk0Y1ZiS3ZnZEdJck1EdkZIUjJPalgiLCJtYWMiOiI1NTdlZDZhYTZiMDAwNDNmYWE1MzI3ZWUzM2Y5NTEzYTA3ZWI1NzZjYjE3MzA5Yzk3MmRjMWYxYTg4OTRiOWVmIiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 13:30:17 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6IkhoMVY3Znk4Ym1qYXRmczR6VjBNRGc9PSIsInZhbHVlIjoiclVnUWRERXcvN3dYSCtXamI5a2tFbGdFSkFpMjZ2WkFXYmV6b0c3enRGa2VyM09CQzdiblBHVjUyUVdienNvNjIraXNaV" 1 => "24houranswers_session=eyJpdiI6ImlxN3BUejVUWjhWYW9TN0RhUTFjZ2c9PSIsInZhbHVlIjoieUd3SzNFRFVZSVhOajBNYWtqVkQ0bWZROU52bXlxQlZCeXhYL0xwTjBFa3l5Z0xHQVhHL0c3SnRNK2ZMTGZmWXJHQUJ4cmNWaCtBaFR4OUlNblR6bVo1MnNqUHZVRXFJeGhKV3hESS9PM0MrVE9TM3kwdzR2YmRGQTVrVmRGY0MiLCJtYWMiOiIyMjlkODczY2RiZTg2NDI4OGZmZDg0ODQ0YmY4M2NlMzMyZjkzYzJkZGEzOTI2ZGExOGViM2YyMWE4MjliMzI4IiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 13:30:17 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6ImlxN3BUejVUWjhWYW9TN0RhUTFjZ2c9PSIsInZhbHVlIjoieUd3SzNFRFVZSVhOajBNYWtqVkQ0bWZROU52bXlxQlZCeXhYL0xwTjBFa3l5Z0xHQVhHL0c3SnRNK2ZMTG" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhoMVY3Znk4Ym1qYXRmczR6VjBNRGc9PSIsInZhbHVlIjoiclVnUWRERXcvN3dYSCtXamI5a2tFbGdFSkFpMjZ2WkFXYmV6b0c3enRGa2VyM09CQzdiblBHVjUyUVdienNvNjIraXNaVUQrQWlkaWFScHB3UlFvY1hQWTRpUVpJNnp3VU00czlyaTBtTnk0Y1ZiS3ZnZEdJck1EdkZIUjJPalgiLCJtYWMiOiI1NTdlZDZhYTZiMDAwNDNmYWE1MzI3ZWUzM2Y5NTEzYTA3ZWI1NzZjYjE3MzA5Yzk3MmRjMWYxYTg4OTRiOWVmIiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 13:30:17 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6IkhoMVY3Znk4Ym1qYXRmczR6VjBNRGc9PSIsInZhbHVlIjoiclVnUWRERXcvN3dYSCtXamI5a2tFbGdFSkFpMjZ2WkFXYmV6b0c3enRGa2VyM09CQzdiblBHVjUyUVdienNvNjIraXNaV" 1 => "24houranswers_session=eyJpdiI6ImlxN3BUejVUWjhWYW9TN0RhUTFjZ2c9PSIsInZhbHVlIjoieUd3SzNFRFVZSVhOajBNYWtqVkQ0bWZROU52bXlxQlZCeXhYL0xwTjBFa3l5Z0xHQVhHL0c3SnRNK2ZMTGZmWXJHQUJ4cmNWaCtBaFR4OUlNblR6bVo1MnNqUHZVRXFJeGhKV3hESS9PM0MrVE9TM3kwdzR2YmRGQTVrVmRGY0MiLCJtYWMiOiIyMjlkODczY2RiZTg2NDI4OGZmZDg0ODQ0YmY4M2NlMzMyZjkzYzJkZGEzOTI2ZGExOGViM2YyMWE4MjliMzI4IiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 13:30:17 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6ImlxN3BUejVUWjhWYW9TN0RhUTFjZ2c9PSIsInZhbHVlIjoieUd3SzNFRFVZSVhOajBNYWtqVkQ0bWZROU52bXlxQlZCeXhYL0xwTjBFa3l5Z0xHQVhHL0c3SnRNK2ZMTG" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "XcDJE1XEzPMkSBspwIxMAqbxTGZmUtL4bsA9GvGl" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Medicine-and-Nursing/Pharmacology/50309" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Medicine-and-Nursing/Pharmacology/50309" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]