Question
Part 1:
Write a Perl program to accomplish each of the following on the file solar.txt
1. Print all records that do not list a discoverer in the eighth field.
2. Print every record after erasing the second field. Note: It would be better to say "print every record" omitting the second field.
3. Print the records for satellites that have negative orbital periods. (A negative orbital period simply means that the satellite orbits in a counterclockwise direction.)
4. Print the data for the objects discovered by the Voyager2 space probe.
5. Print each record with the orbital period given in seconds rather than days.

About solar.txt file: This file contains lines of 9 items, the first being:
Adrastea XV Jupiter 129000 0.30 0.00 0.00 Jewitt 1979 in alphabetical order by the name of the planet or moon (first field).
The text in [] is the corresponding field from the line above.
The fields in this file are:
1. Name of planet or moon [Adrastea]
2. Number of moon or planet (roman numerals) [XV]
3. Name of the abject around which the satellite orbits [Jupiter]
4. Orbital radius (semimajor axis) in kilometers [129000]
5. Orbital period in days [0.30]
6. Orbital inclination in degrees [0.00]
7. Orbital eccentricity [0.00]
8. Discoverer [Jewitt]
9. Year of discovery [1979]

Solar.txt file
Adrastea XV Jupiter 129000 0.30 0.00 0.00 Jewitt 1979
Amalthea V Jupiter 181000 0.50 0.40 0.00 Barnard 1892
Ananke XII Jupiter 21200000 -631 147.00 0.17 Nicholson 1951
Ariel I Uranus 191000 2.52 0.00 0.00 Lassell 1851
Atlas XV Saturn 138000 0.60 0.00 0.00 Terrile 1980
Belinda XIV Uranus 75000 0.62 0.03 0.00 Voyager2 1986
Bianca VIII Uranus 59000 0.43 0.16 0.00 Voyager2 1986
Caliban XVI Uranus 7169000 -580 140. 0.08 Gladman 1997
Callirrhoe XVII Jupiter 24100000 ? ? ? Sheppard 2000
Callisto IV Jupiter 1883000 16.69 0.28 0.01 Galileo 1610
Calypso XIV Saturn 295000 1.89 0.00 0.00 Pascu 1980
Carme XI Jupiter 22600000 -692 163.00 0.21 Nicholson 1938
Chaldene XXI Jupiter 23387000 -733.7 165.2 0.238 Sheppard 2000
Charon I Pluto 20000 6.39 98.80 0.00 Christy 1978
Cordelia VI Uranus 50000 0.34 0.14 0.00 Voyager2 1986
Cressida IX Uranus 62000 0.46 0.04 0.00 Voyager2 1986
Deimos II Mars 23000 1.26 1.80 0.00 Hall 1877
Desdemona X Uranus 63000 0.47 0.16 0.00 Voyager2 1986
Despina V Neptune 53000 0.33 0.00 0.00 Voyager2 1989
Dione IV Saturn 377000 2.74 0.02 0.00 Cassini 1684
Earth III Sun 149600000 365.26 0.00 0.02 - -
Elara VII Jupiter 11737000 259.65 28.00 0.21 Perrine 1905
Enceladus II Saturn 238000 1.37 0.02 0.00 Herschel 1789
Epimetheus XI Saturn 151000 0.69 0.34 0.01 Walker 1980
Erinome XXV Jupiter 23279000 728 164.9 0.266 Sheppard 2000
Europa II Jupiter 671000 3.55 0.47 0.01 Galileo 1610
Galatea VI Neptune 62000 0.43 0.00 0.00 Voyager2 1989
Ganymede III Jupiter 1070000 7.15 0.19 0.00 Galileo 1610
Harpalyke XXII Jupiter 21132000 623.3 148.6 0.226 Sheppard 2000
Helene XII Saturn 377000 2.74 0.20 0.01 Laques 1980
Himalia VI Jupiter 11480000 250.57 28.00 0.16 Perrine 1904
Hyperion VII Saturn 1481000 21.28 0.43 0.10 Bond 1848
Iapetus VIII Saturn 3561000 79.33 14.72 0.03 Cassini 1671
Io I Jupiter 422000 1.77 0.04 0.00 Galileo 1610
Iocaste XXIV Jupiter 20216000 ? ? ? Sheppard 2000
Isonoe XXVI Jupiter 23078000 ? ? ? Sheppard 2000
Janus X Saturn 151000 0.69 0.14 0.01 Dollfus 1966
Juliet XI Uranus 64000 0.49 0.06 0.00 Voyager2 1986
Jupiter V Sun 778330000 4332.71 1.31 0.05 - -
Kalyke XXIII Jupiter 23745000 ? ? ? Sheppard 2000
Larissa VII Neptune 74000 0.55 0.00 0.00 Reitsema 1989
Leda XIII Jupiter 11094000 238.72 27.00 0.15 Kowal 1974
Lysithea X Jupiter 11720000 259.22 29.00 0.11 Nicholson 1938
Mars IV Sun 227940000 686.98 1.85 0.09 - -
Megaclite XIX Jupiter 23911000 ? ? ? Sheppard 2000
Mercury I Sun 57910000 87.97 7.00 0.21 - -
Metis XVI Jupiter 128000 0.29 0.00 0.00 Synnott 1979
Mimas I Saturn 186000 0.94 1.53 0.02 Herschel 1789
Miranda V Uranus 130000 1.41 4.22 0.00 Kuiper 1948
Moon I Earth 384000 27.32 5.14 0.05 - -
Naiad III Neptune 48000 0.29 0.00 0.00 Voyager2 1989
Neptune VIII Sun 4504300000 60190.00 1.77 0.01 Adams 1846
Nereid II Neptune 5513000 360.13 29.00 0.75 Kuiper 1949
Oberon IV Uranus 583000 13.46 0.00 0.00 Herschel 1787
Ophelia VII Uranus 54000 0.38 0.09 0.00 Voyager2 1986
Pan XVIII Saturn 134000 0.58 0.00 0.00 Showalter 1990
Pandora XVII Saturn 142000 0.63 0.00 0.00 Collins 1980
Pasiphae VIII Jupiter 23500000 -735 147.00 0.38 Melotte 1908
Phobos I Mars 9000 0.32 1.00 0.02 Hall 1877
Phoebe IX Saturn 12952000 -550.48 175.30 0.16 Pickering 1898
Pluto IX Sun 5913520000 90550 17.15 0.25 Tombaugh 1930
Portia XII Uranus 66000 0.51 0.09 0.00 Voyager2 1986
Praxidike XXVII Jupiter 20964000 ? ? ? Sheppard 2000
Prometheus XVI Saturn 139000 0.61 0.00 0.00 Collins 1980
Prospero XVIII Uranus 16568000 -2019 152. 0.44 Holman 1999
Proteus VIII Neptune 118000 1.12 0.00 0.00 Voyager2 1989
Puck XV Uranus 86000 0.76 0.31 0.00 Voyager2 1985
Rhea V Saturn 527000 4.52 0.35 0.00 Cassini 1672
Rosalind XIII Uranus 70000 0.56 0.28 0.00 Voyager2 1986
Saturn VI Sun 1429400000 10759.50 2.49 0.06 - -
Setebos XIX Uranus 17681000 -2239 158. 0.57 Kavelaars 1999
Sinope IX Jupiter 23700000 -758 153.00 0.28 Nicholson 1914
Stephano XX Uranus 7948000 -674 143. 0.24 Gladman 1999
Sun - - - - - - - -
Sycorax XVII Uranus 12213000 -1289 153. 0.51 Nicholson 1997
Taygete XX Jupiter 23312000 ? ? ? Sheppard 2000
Telesto XIII Saturn 295000 1.89 0.00 0.00 Smith 1980
Tethys III Saturn 295000 1.89 1.09 0.00 Cassini 1684
Thalassa IV Neptune 50000 0.31 4.50 0.00 Voyager2 1989
Thebe XIV Jupiter 222000 0.67 0.80 0.02 Synnott 1979
Themisto XVIII Jupiter 7507000 ? ? ? Sheppard 2000
Titan VI Saturn 1222000 15.95 0.33 0.03 Huygens 1655
Titania III Uranus 436000 8.71 0.00 0.00 Herschel 1787
Trinculo XXI Uranus 8578000 -759 167.0 0.208 Gladman 2001
Triton I Neptune 355000 -5.88 157.00 0.00 Lassell 1846
Umbriel II Uranus 266000 4.14 0.00 0.00 Lassell 1851
Uranus VII Sun 2870990000 30685.00 0.77 0.05 Herschel 1781
Venus II Sun 108200000 224.70 3.39 0.01 - -

Part 2:
Separate, count and sort the words in the example text file, electricity.txt. Sort in the following orders and your output should be nicely lined up in columns to the output file.
1. alphabetically (ignoring capitalization),
2. alphabetically with upper case words just in front of lower-case words with the same initial characters
3. by frequency, from high to low, (any order for equal frequency)
4. by frequency, with alphabetical order for words with the same frequency

Electricity.txt file
Today's scientific question is: What in the world is electricity and where does it go after it leaves the toaster?

Here is a simple experiment that will teach you an important electrical lesson: On a cool dry day, scuff your feet along a carpet, then reach your hand into a friend's mouth and touch one of his dental fillings. Did you notice how your friend twitched violently and cried out in pain? This teaches one that electricity can be a very powerful force, but we must never use it to hurt others unless we need to learn an important lesson about electricity.

It also illustrates how an electrical circuit works. When you scuffed your feet, you picked up batches of "electrons", which are very small objects that carpet manufacturers weave into carpet so that they will attract dirt. The electrons travel through your bloodstream and collect in your finger, where they form a spark that leaps to your friend's filling, then travel down to his feet and back into the carpet, thus completing the circuit.

AMAZING ELECTRONIC FACT: If you scuffed your feet long enough without touching anything, you would build up so many electrons that your finger would explode! But this is nothing to worry about unless you have carpeting.

Although we modern persons tend to take our electric lights, radios, mixers, etc. for granted, hundreds of years ago people did not have any of these things, which is just as well because there was no place
to plug them in. Then along came the first Electrical Pioneer, Benjamin Franklin, who flew a kite in a lightning storm and received a serious electrical shock. This proved that lightning was powered by
the same force as carpets, but it also damaged Franklin's brain so severely that he started speaking only in incomprehensible maxims, such as, "A penny saved is a penny earned." Eventually he had to be given a job running the post office.

After Franklin came a herd of Electrical Pioneers whose names have become part of our electrical terminology: Myron Volt, Mary Louise Amp, James Watt, Bob Transformer, etc. These pioneers conducted many important electrical experiments. Among them, Galvani discovered (this is the truth) that when he attached two different kinds of metal to the leg of a frog, an electrical current developed and the frog's leg kicked, even though it was no longer attached to the frog, which was dead anyway. Galvani's discovery led to enormous advances in the field of amphibian medicine. Today, skilled veterinary surgeons can take a frog that has been seriously injured or killed, implant pieces of metal in its muscles, and watch it hop back into the pond -- almost.

But the greatest Electrical Pioneer of them all was Thomas Edison, who was a brilliant inventor despite the fact that he had little formal education and lived in New Jersey. Edison's first major invention in 1877 was the phonograph, which could soon be found in thousands of American homes, where it basically sat until 1923, when the record was invented. But Edison's greatest achievement came in 1879 when he
invented the electric company. Edison's design was a brilliant adaptation of the simple electrical circuit: the electric company sends electricity through a wire to a customer, then immediately gets the electricity back through another wire, then (this is the brilliant part) sends it right back to the customer again.
This means that an electric company can sell a customer the same batch of electricity thousands of times a day and never get caught, since very few customers take the time to examine their electricity closely.
In fact, the last year any new electricity was generated was 1937.

Today, thanks to men like Edison and Franklin, and frogs like Galvani's, we receive almost unlimited benefits from electricity. For example, in the past decade scientists have developed the laser, an electronic appliance so powerful that it can vaporize a bulldozer 2000 yards away, yet so precise that doctors can use it to perform delicate operations to the human eyeball, provided they remember to change the power setting from "Bulldozer" to "Eyeball."
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.

# Opening the file
open(FH, "solar.txt")or die "Sorry!! couldn't open";
print "Reading file \n";

my @fileContent=();
my $count=0;
# Reading the file till FH reaches EOF
while(<FH>)
{   
    $count++;
    # Adding records to an array to reuse it
    push(@fileContent, $_);
}
close(FH);

print "No. of records: $count \n";
print "======================================================\n";

# subroutine to print records without a discoverer
sub printNoDiscoverer
{   
    # passing argument   
    @recordArray = @{$_[0]};
    print "Finding records without a Discoverer \n";
    my $recordCount = 0;
    foreach my $line (@recordArray)
    {
       my @spl = split(' ', $line);
       # check discoverer column
       if ((@spl[7] eq '?') || (@spl[7] eq '-')) {
            print "$line";
            $recordCount++;
       }
    }
    print "No. of matching records: $recordCount
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:
part1.pl
part2.pl
Purchase Solution
$25.00 $12.5
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Computer Science Tutors 529 tutors matched
Ionut
(ionut)
Hi! MSc Applied Informatics & Computer Science Engineer. Practical experience in many CS & IT branches.Research work & homework
5/5 (5,654+ sessions)
2 hours avg response
Leo
(Leo)
Hi! I have been a professor in New York and taught in a math department and in an applied math department.
4.9/5 (5,652+ sessions)
2 hours avg response
Pranay
(math1983)
Ph.D. in mathematics and working as an Assistant Professor in University. I can provide help in mathematics, statistics and allied areas.
4.6/5 (5,512+ sessions)
1 hour avg response

Similar Homework Solutions

8.1.0PHP Version443msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (282ms)time
    • Application (161ms)time
    • 1 x Booting (63.55%)
      282ms
      1 x Application (36.44%)
      161ms
      • Illuminate\Routing\Events\Routing (1.37ms)
      • Illuminate\Routing\Events\RouteMatched (594μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.89ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (239μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (226μs)
      • Illuminate\Database\Events\ConnectionEstablished (1.19ms)
      • Illuminate\Database\Events\StatementPrepared (16.1ms)
      • Illuminate\Database\Events\QueryExecuted (1.4ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (93μs)
      • eloquent.booting: App\Models\Subject (53μs)
      • eloquent.booted: App\Models\Subject (40μs)
      • Illuminate\Database\Events\StatementPrepared (1.29ms)
      • Illuminate\Database\Events\QueryExecuted (869μs)
      • eloquent.retrieved: App\Models\Subject (104μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (119μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (41μs)
      • Illuminate\Database\Events\StatementPrepared (602μs)
      • Illuminate\Database\Events\QueryExecuted (1.06ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (104μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (20μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (11μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.booting: App\Models\SubjectCat (932μs)
      • eloquent.booted: App\Models\SubjectCat (52μs)
      • Illuminate\Database\Events\StatementPrepared (610μs)
      • Illuminate\Database\Events\QueryExecuted (862μs)
      • eloquent.retrieved: App\Models\SubjectCat (103μs)
      • Illuminate\Cache\Events\CacheHit (10.99ms)
      • Illuminate\Cache\Events\CacheMissed (823μs)
      • Illuminate\Database\Events\StatementPrepared (1.16ms)
      • Illuminate\Database\Events\QueryExecuted (1.45ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (75μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (15μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (10μs)
      • Illuminate\Database\Events\StatementPrepared (618μs)
      • Illuminate\Database\Events\QueryExecuted (911μs)
      • eloquent.retrieved: App\Models\Subject (73μs)
      • Illuminate\Cache\Events\KeyWritten (891μs)
      • Illuminate\Database\Events\StatementPrepared (2.08ms)
      • Illuminate\Database\Events\QueryExecuted (958μs)
      • Illuminate\Database\Events\StatementPrepared (1.01ms)
      • Illuminate\Database\Events\QueryExecuted (898μs)
      • Illuminate\Database\Events\StatementPrepared (707μs)
      • Illuminate\Database\Events\QueryExecuted (881μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (137μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (17μs)
      • Illuminate\Cache\Events\CacheHit (637μs)
      • creating: homework.show (463μs)
      • composing: homework.show (126μs)
      • creating: components.breadcrumbs (285μs)
      • composing: components.breadcrumbs (149μs)
      • Illuminate\Database\Events\StatementPrepared (1.13ms)
      • Illuminate\Database\Events\QueryExecuted (946μs)
      • eloquent.retrieved: App\Models\SubjectCat (85μs)
      • Illuminate\Cache\Events\CacheMissed (4.05ms)
      • Illuminate\Database\Events\StatementPrepared (717μs)
      • Illuminate\Database\Events\QueryExecuted (1ms)
      • eloquent.retrieved: App\Models\SubjectCat (75μs)
      • Illuminate\Cache\Events\KeyWritten (332μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheMissed (132μs)
      • Illuminate\Database\Events\StatementPrepared (761μs)
      • Illuminate\Database\Events\QueryExecuted (917μs)
      • eloquent.retrieved: App\Models\SubjectCat (78μs)
      • Illuminate\Cache\Events\KeyWritten (446μs)
      • Illuminate\Cache\Events\CacheHit (1.47ms)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheMissed (345μs)
      • Illuminate\Database\Events\StatementPrepared (732μs)
      • Illuminate\Database\Events\QueryExecuted (1.09ms)
      • eloquent.retrieved: App\Models\SubjectCat (69μs)
      • Illuminate\Cache\Events\KeyWritten (1.48ms)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (344μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (348μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheMissed (258μs)
      • Illuminate\Database\Events\StatementPrepared (789μs)
      • Illuminate\Database\Events\QueryExecuted (989μs)
      • eloquent.retrieved: App\Models\SubjectCat (69μs)
      • Illuminate\Cache\Events\KeyWritten (1.55ms)
      • Illuminate\Cache\Events\CacheHit (235μs)
      • Illuminate\Cache\Events\CacheHit (479μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (476μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (217μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (250μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (308μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheMissed (198μs)
      • Illuminate\Database\Events\StatementPrepared (699μs)
      • Illuminate\Database\Events\QueryExecuted (799μs)
      • eloquent.retrieved: App\Models\SubjectCat (79μs)
      • Illuminate\Cache\Events\KeyWritten (547μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (426μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheMissed (309μs)
      • Illuminate\Database\Events\StatementPrepared (794μs)
      • Illuminate\Database\Events\QueryExecuted (1.03ms)
      • eloquent.retrieved: App\Models\SubjectCat (76μs)
      • Illuminate\Cache\Events\KeyWritten (670μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (910μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheMissed (282μs)
      • Illuminate\Database\Events\StatementPrepared (802μs)
      • Illuminate\Database\Events\QueryExecuted (955μs)
      • eloquent.retrieved: App\Models\SubjectCat (104μs)
      • Illuminate\Cache\Events\KeyWritten (320μs)
      • Illuminate\Cache\Events\CacheHit (281μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (482μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (227μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (413μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (268μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheMissed (304μs)
      • Illuminate\Database\Events\StatementPrepared (880μs)
      • Illuminate\Database\Events\QueryExecuted (1.04ms)
      • eloquent.retrieved: App\Models\SubjectCat (147μs)
      • Illuminate\Cache\Events\KeyWritten (1.63ms)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (228μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (880μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (148μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheMissed (206μs)
      • Illuminate\Database\Events\StatementPrepared (814μs)
      • Illuminate\Database\Events\QueryExecuted (925μs)
      • eloquent.retrieved: App\Models\SubjectCat (78μs)
      • Illuminate\Cache\Events\KeyWritten (281μs)
      • Illuminate\Cache\Events\CacheHit (1.12ms)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • creating: site.layouts.app (685μs)
      • composing: site.layouts.app (27μs)
      • creating: components.canonical (548μs)
      • composing: components.canonical (104μs)
      • creating: components.open-graph (232μs)
      • composing: components.open-graph (79μs)
      • creating: site.headers.header (317μs)
      • composing: site.headers.header (80μs)
      • Illuminate\Cache\Events\CacheHit (1.86ms)
      • creating: components.footer (97μs)
      • composing: components.footer (100μs)
      • Illuminate\Cache\Events\CacheHit (1.06ms)
      • Illuminate\Cache\Events\CacheMissed (419μs)
      • Illuminate\Database\Events\StatementPrepared (1.1ms)
      • Illuminate\Database\Events\QueryExecuted (1.17ms)
      • eloquent.retrieved: App\Models\SubjectCat (70μs)
      • Illuminate\Cache\Events\KeyWritten (1.98ms)
      • Illuminate\Cache\Events\CacheHit (330μs)
      • Illuminate\Cache\Events\CacheHit (913μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (316μs)
      • Illuminate\Cache\Events\CacheHit (511μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (235μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (213μs)
      • creating: components.forms.contact-us (244μs)
      • composing: components.forms.contact-us (162μs)
      • creating: components.forms.get-started (148μs)
      • composing: components.forms.get-started (74μs)
      • creating: components.forms.free-tool-download (110μs)
      • composing: components.forms.free-tool-download (70μs)
      • creating: components.forms.claim-free-worksheet (105μs)
      • composing: components.forms.claim-free-worksheet (66μs)
      • creating: components.forms.tutor-subscription-waitlist (102μs)
      • composing: components.forms.tutor-subscription-waitlist (66μs)
      • creating: components.forms.tutor-subscription-join (104μs)
      • composing: components.forms.tutor-subscription-join (65μs)
      • creating: components.forms.tutor-support (95μs)
      • composing: components.forms.tutor-support (61μs)
      • 311 x Illuminate\Cache\Events\CacheHit (15.61%)
        69.16ms
        20 x Illuminate\Database\Events\StatementPrepared (7.54%)
        33.40ms
        20 x Illuminate\Database\Events\QueryExecuted (4.55%)
        20.16ms
        11 x Illuminate\Cache\Events\KeyWritten (2.28%)
        10.12ms
        11 x Illuminate\Cache\Events\CacheMissed (1.65%)
        7.33ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.1%)
        4.89ms
        1 x Illuminate\Routing\Events\Routing (0.31%)
        1.37ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.27%)
        1.19ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.23%)
        1.03ms
        1 x eloquent.booting: App\Models\SubjectCat (0.21%)
        932μs
        1 x creating: site.layouts.app (0.15%)
        685μs
        1 x Illuminate\Routing\Events\RouteMatched (0.13%)
        594μs
        1 x creating: components.canonical (0.12%)
        548μs
        1 x creating: homework.show (0.1%)
        463μs
        9 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.07%)
        330μs
        1 x creating: site.headers.header (0.07%)
        317μs
        1 x creating: components.breadcrumbs (0.06%)
        285μs
        1 x creating: components.forms.contact-us (0.06%)
        244μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        239μs
        1 x creating: components.open-graph (0.05%)
        232μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        226μs
        4 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        193μs
        2 x eloquent.retrieved: App\Models\Subject (0.04%)
        177μs
        1 x composing: components.forms.contact-us (0.04%)
        162μs
        1 x composing: components.breadcrumbs (0.03%)
        149μs
        1 x creating: components.forms.get-started (0.03%)
        148μs
        1 x composing: homework.show (0.03%)
        126μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        119μs
        1 x creating: components.forms.free-tool-download (0.02%)
        110μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        105μs
        1 x creating: components.forms.tutor-subscription-join (0.02%)
        104μs
        1 x composing: components.canonical (0.02%)
        104μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.02%)
        102μs
        1 x composing: components.footer (0.02%)
        100μs
        1 x creating: components.footer (0.02%)
        97μs
        1 x creating: components.forms.tutor-support (0.02%)
        95μs
        1 x composing: site.headers.header (0.02%)
        80μs
        1 x composing: components.open-graph (0.02%)
        79μs
        1 x composing: components.forms.get-started (0.02%)
        74μs
        1 x composing: components.forms.free-tool-download (0.02%)
        70μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        66μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        66μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        65μs
        1 x composing: components.forms.tutor-support (0.01%)
        61μs
        1 x eloquent.booting: App\Models\Subject (0.01%)
        53μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        52μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        41μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        40μs
        1 x composing: site.layouts.app (0.01%)
        27μs
      14 templates were rendered
      • 1x homework.showshow.blade.phpblade
      • 1x components.breadcrumbsbreadcrumbs.blade.phpblade
      • 1x site.layouts.appapp.blade.phpblade
      • 1x components.canonicalcanonical.blade.phpblade
      • 1x components.open-graphopen-graph.blade.phpblade
      • 1x site.headers.headerheader.blade.phpblade
      • 1x components.footerfooter.blade.phpblade
      • 1x components.forms.contact-uscontact-us.blade.phpblade
      • 1x components.forms.get-startedget-started.blade.phpblade
      • 1x components.forms.free-tool-downloadfree-tool-download.blade.phpblade
      • 1x components.forms.claim-free-worksheetclaim-free-worksheet.blade.phpblade
      • 1x components.forms.tutor-subscription-waitlisttutor-subscription-waitlist.blade.phpblade
      • 1x components.forms.tutor-subscription-jointutor-subscription-join.blade.phpblade
      • 1x components.forms.tutor-supporttutor-support.blade.phpblade
      uri
      GET college-homework-library/{category}/{subject}/{id}
      middleware
      web, utm.parameters
      controller
      App\Http\Controllers\HomeworkLibraryController@show
      namespace
      where
      as
      homework.show
      file
      app/Http/Controllers/HomeworkLibraryController.php:79-176
      20 statements were executed, 5 of which were duplicates, 15 unique. Show only duplicated39.1ms
      • Connection Establishedtwenty4_siteHomeworkLibraryController.php#91
        Backtrace
        • 13. app/Http/Controllers/HomeworkLibraryController.php:91
        • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `solutionslibrary` where `status` = 'published' and `price` > 0 and `solutionslibrary`.`id` = '58161' limit 1
        16.5mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 58161
        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 (354)
        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 `solutionslibrary_files` where `solutionslibrary_files`.`solutionlib_id` in (58161)
        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 `subject_cats` where `subject_cats`.`id` = 3 limit 1
        940μstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 3
        Backtrace
        • 20. app/Models/HomeworkLibrary/HomeworkLibrary.php:201
        • 26. app/Http/Controllers/HomeworkLibraryController.php:105
        • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `solutionslibrary` where `id` <> 58161 and `subject` = 354 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        1.82mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 58161
        • 1: 354
        • 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 (354)
        960μstwenty4_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` = 58161 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.14mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 58161
        • 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` = 58161 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.23mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 58161
        • 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` = 58161 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        940μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 58161
        • 1: solution
        Backtrace
        • 15. app/Models/HomeworkLibrary/HomeworkLibrary.php:260
        • 16. app/Transformers/HomeworkLibrary/HomeworkLibraryTransformer.php:80
        • 19. vendor/league/fractal/src/TransformerAbstract.php:128
        • 20. vendor/league/fractal/src/TransformerAbstract.php:107
        • 21. vendor/league/fractal/src/Scope.php:383
      • select * from `subject_cats` where `subject_cats`.`id` = 3 limit 1
        1.07mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 3
        Backtrace
        • 20. app/Models/HomeworkLibrary/HomeworkLibrary.php:201
        • 32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 33. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 34. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `subject_cats` where `subject_cats`.`id` = 1 limit 1
        1.16mstwenty4_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.25mstwenty4_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.26mstwenty4_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.22mstwenty4_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.04mstwenty4_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.17mstwenty4_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.13mstwenty4_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.25mstwenty4_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.29mstwenty4_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.59mstwenty4_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
      4HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          0mmnGkJIPz7N0oMGg8zlGEiyfND8vnWH8oDNkKE6
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/Perl-Programming/58161
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Scienc...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/Computer-Science/Perl-Programming/58161
          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-680d14ea-5fd58f03056ee01622f1bc4c" ] "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.190.207.149" ] "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 17:16:26 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkxkbXRZM1dQUHZxTEo3YVJRc3JNdkE9PSIsInZhbHVlIjoiZzV1eHNYLzRwSFdKMWt1MXZBUkdJSUZiVVQ0TnhRNHpKV3J1d0hsa3hsQ3RiMWNMc1p1MnpwOXBObzBRV2hmUDVVOWNBVm5rS2JuY3dydXh5UTVYMVp1aUMwNHBKVDJZemYyeUM1UDBPOGNoMys3Z2k1d1R4Y1pZaHZKVUZRMmciLCJtYWMiOiJiZWNkZmMxNjFmNjQxZTEzMzlmNjdjMWFmNmNkOWZmMWQ5MDNjYWVhMmZiNWM2NTRkNjkzMmVmY2E4YjZiODU4IiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 19:16:27 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6IkxkbXRZM1dQUHZxTEo3YVJRc3JNdkE9PSIsInZhbHVlIjoiZzV1eHNYLzRwSFdKMWt1MXZBUkdJSUZiVVQ0TnhRNHpKV3J1d0hsa3hsQ3RiMWNMc1p1MnpwOXBObzBRV2hmUDVVOWNBV" 1 => "24houranswers_session=eyJpdiI6InBPSDRTMmJHNkdYWXd1ZS93bjZwYnc9PSIsInZhbHVlIjoiTGw2cnI0SWFKU3dUREpRcGprY00zbWVlTFNEMndUZm9OZU1VcHZ6QndNajd5NUdhTmdqWDBYd1BtdzE5RVl3a1RIU09OL1orUkVVWk1ZemVoMHh1Y3UyVWVEY2Z2RUNNR1pNbnh1czdHNkFqVWVPdkp6RGVzb0pRSTJ3cE40a2YiLCJtYWMiOiI1OTRlOWFmY2ZkODVhZTk5OGM4NjFlY2E3MzM4ZDNjZGYxZGFjZjFjNzZjYzVhNDE2NTg1Y2I2YWJhZGVlMDdkIiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 19:16:27 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6InBPSDRTMmJHNkdYWXd1ZS93bjZwYnc9PSIsInZhbHVlIjoiTGw2cnI0SWFKU3dUREpRcGprY00zbWVlTFNEMndUZm9OZU1VcHZ6QndNajd5NUdhTmdqWDBYd1BtdzE5RV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkxkbXRZM1dQUHZxTEo3YVJRc3JNdkE9PSIsInZhbHVlIjoiZzV1eHNYLzRwSFdKMWt1MXZBUkdJSUZiVVQ0TnhRNHpKV3J1d0hsa3hsQ3RiMWNMc1p1MnpwOXBObzBRV2hmUDVVOWNBVm5rS2JuY3dydXh5UTVYMVp1aUMwNHBKVDJZemYyeUM1UDBPOGNoMys3Z2k1d1R4Y1pZaHZKVUZRMmciLCJtYWMiOiJiZWNkZmMxNjFmNjQxZTEzMzlmNjdjMWFmNmNkOWZmMWQ5MDNjYWVhMmZiNWM2NTRkNjkzMmVmY2E4YjZiODU4IiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 19:16:27 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6IkxkbXRZM1dQUHZxTEo3YVJRc3JNdkE9PSIsInZhbHVlIjoiZzV1eHNYLzRwSFdKMWt1MXZBUkdJSUZiVVQ0TnhRNHpKV3J1d0hsa3hsQ3RiMWNMc1p1MnpwOXBObzBRV2hmUDVVOWNBV" 1 => "24houranswers_session=eyJpdiI6InBPSDRTMmJHNkdYWXd1ZS93bjZwYnc9PSIsInZhbHVlIjoiTGw2cnI0SWFKU3dUREpRcGprY00zbWVlTFNEMndUZm9OZU1VcHZ6QndNajd5NUdhTmdqWDBYd1BtdzE5RVl3a1RIU09OL1orUkVVWk1ZemVoMHh1Y3UyVWVEY2Z2RUNNR1pNbnh1czdHNkFqVWVPdkp6RGVzb0pRSTJ3cE40a2YiLCJtYWMiOiI1OTRlOWFmY2ZkODVhZTk5OGM4NjFlY2E3MzM4ZDNjZGYxZGFjZjFjNzZjYzVhNDE2NTg1Y2I2YWJhZGVlMDdkIiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 19:16:27 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6InBPSDRTMmJHNkdYWXd1ZS93bjZwYnc9PSIsInZhbHVlIjoiTGw2cnI0SWFKU3dUREpRcGprY00zbWVlTFNEMndUZm9OZU1VcHZ6QndNajd5NUdhTmdqWDBYd1BtdzE5RV" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "0mmnGkJIPz7N0oMGg8zlGEiyfND8vnWH8oDNkKE6" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/Perl-Programming/58161" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/Perl-Programming/58161" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]