WrinkleAway – Case Alladin Pharma Co., whose shares are publi...

Question
WrinkleAway – Case

Alladin Pharma Co., whose shares are publicly traded on the TSX, operates in the pharmaceutical industry in North America. It was incorporated under the Canada Business Corporations Act in 1986 and its head office is located in Vancouver. Alladin’s fiscal year end is December 31, and as a public company, it follows International Financial Reporting Standards (IFRS).

Alladin currently owns a number of products, some of which have patent protection in North America, and some of which are off patent. Alladin also licenses and markets products from other pharmaceutical companies, which is a common practice in the industry. All of Alladin’s products are manufactured by contract manufacturing organizations, minimizing the need for investment in property, plant and equipment. Some of its products are distributed to retail outlets, while others are distributed through medical practitioners (such as dermatologists and plastic surgeons).

Effective December 31, 2013, Alladin acquired 100% of the shares of a privately held competitor, Solas Inc., to expand its product portfolio. The transaction offered Alladin the opportunity to broaden its suite of product offerings, which was expected to generate positive revenue and cost synergies from economies of both scale and scope. An external valuation professional was used to value the identifiable tangible and intangible assets and to determine the purchase price allocation as at December 31, 2013.

WrinkleAway was a key product acquired in the acquisition of Solas. WrinkleAway is a patented product that helps reduce or eliminate facial wrinkles. The product has been well accepted in the North American market with growing market share and revenues since its introduction in 2011. The patent was set to expire at December 31, 2020, with a declining amount of residual sales after this point. Alladin determined, in consultation with its auditors at the date of acquisition, that using a straight-line amortization over 10 years for this intangible asset would be appropriate.

Prior to the acquisition, Solas had initiated a patent infringement lawsuit against a generic competitor, Insegra Company Limited, in relation to WrinkleAway.

On September 30, 2014, the court ruled that starting January 1, 2018, Insegra will be allowed to sell a product that uses WrinkleAway’s patented formula to develop its own generic version of WrinkleAway. Alladin’s lawyers had always anticipated competition; however, the expectation at the date of acquisition was that generics would launch after the expiry of the original patent, that being December 31, 2020.

On top of the shortened exclusivity period, Alladin senior management expressed concerns that the level of synergies expected were tracking behind the business case. After nine months of integration, it was confirmed that the actual level of synergies would be lower than anticipated.

Alex Weingart, the CFO of Alladin, has asked for your help in determining the financial reporting implications of these developments. You, a CPA, work as a financial analyst for Mr. Weingart.

Mr. Weingart has requested that you prepare a memo to him assessing whether there has been an impairment in the value of the WrinkleAway intangible asset, and if so, how much.

He provides you with a number of pieces of relevant information he has gathered including:

• Exhibit A: Purchase price allocation of Solas Inc. at December 31, 2013
• Exhibit B: Calculation of WACC as at December 31, 2013
• Exhibit C: Free cash flow projection of WrinkleAway as at December 31, 2013
• Exhibit D: Fair value of WrinkleAway patent as at December 31, 2013
• Exhibit E: Updated financial projection assumptions for WrinkleAway
• Exhibit F: Other information and corporate assumptions

Your response, not including Excel (if applicable), should not exceed 3 pages.

See below

Exhibit E: Updated financial projection assumptions for WrinkleAway

1. As a result of the recent court case ruling, sales of WrinkleAway are expected to start decreasing 20% per annum starting January 1, 2018. Sales are still on track to meet the original projections for 2014, 2015, 2016 and 2017.
2. Due to certain integration challenges, we do not expect to realize any synergies in 2014 that had been projected at the date of acquisition due to higher integration costs than anticipated. We now believe that synergies from the acquisition from 2015 onward will only be 12% of net revenue, instead of the 20% expected at the date of acquisition.
3. All other costs, except for research and development, are expected to be as originally projected on a percentage of net revenue basis.
4. Knowing that WrinkleAway now has a shorter product life cycle with the court’s decision, we now expect to reduce our research and development expenditures and capital expenditures by 50%. Research and development costs will decline from 5% to 2% of net revenues. Capital expenditures will decline from 2% to 1% of net revenues.
5. Investments in working capital expenditures are expected to be 2% of the change in net revenue year over year, which is consistent with the original projection.

Exhibit F: Other information and corporate assumptions

Other information
• Any licensing of the WrinkleAway product patent would align to the remaining exclusivity period. Information gathered on current royalty rates for a variety of similar pharmaceutical product patents are outlined below:
Product patent Royalty rate Product geographic scope Terms and conditions
FX’s sculpting cream 35% Asia only The licence is for 15 years. This global product is the number two seller in the world. The licence is for selling in Asia only. Licensee must pay marketing costs.
Seporana’s acne cream 25% North America The licence is for 10 years for a North American licence. No additional marketing costs are required, as licensor will support product.
Neuvelle antiwrinkle cream for the eyes 30% North America Licence is for four years, and licensee will be required to pay marketing costs of at least 3% to support the product.
Oliveria antiaging cream for the neck and face 31% United States Licence is for 11 years for U.S. distribution. Marketing costs of 5% will be required by the licensee.
Zanas toning cream 28% Europe Licence is for eight years only for European distribution. Marketing costs of 3% will be required by the licensee.

• Any costs of disposal of the WrinkleAway patent are estimated to be 3% of the proceeds on sale.
• Any licensee of the WrinkleAway product will be required to pay 2% for ongoing marketing costs to support the product.

Corporate assumptions

• Impairment analysis (use IAS 36, Impairment of Assets, for guidance):
o For the value-in-use calculation, Alladin uses pre-tax cash flows and a pre-tax discount rate to determine the recoverable amount.
o For the fair value less costs of disposal, Alladin uses the relief-from-royalty approach for valuing pharmaceutical patents.
• All components of the WACC calculation at December 31, 2013, are still relevant at September 30, 2014 (see Exhibit B), other than:
o Risk-free rate of return (long-term government of Canada bond yields) is now
2.9%.
o The cost of debt is now 7.5%.
o Weighting of debt is 30%.
• Effective income tax rate for Alladin and Solas is 25%.
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.

MEMORANDUM
To: Alex Weingart, CFO of Alladin
From: Lynn, Financial analyst
Date: December 14, 2017
Subject: Assessment of impairment in the value of WrinkleAway.
WrinkleAway was the crown jewel in the acquisition of Solas and has been shown on the balance sheet at carrying value of $525,896,000. However, due to the passing of the new court ruling on September 30, 2014 which shortens the exclusivity period till January 1, 2018, it is expected that there has been an impairment in the value of the intangible asset. The valuation of the asset has been done on the basis of value-in-use and it is expected that the company would not dispose the asset after its exclusivity period expires due to creation of loyal consumer base during the period of exclusivity.
In order to assess whether there has been an impairment loss, the weighted average cost of capital is computed on September 30, 2014. The calculations are shown in Appendix 1 and the new value of the WACC is 9.67%, compared to 11.1% which was used at the time of acquisition. Since the cost of capital has decreased as more of debt and financial leverage is added to the capital structure, it is expected that the fair value of WrinkleAway should increase. However, this is not the case since the estimates about the free cash flow of the asset have reduced drastically.
This is only a preview of the solution.
Please use the purchase button to see the entire solution.
By purchasing this solution you'll be able to access the following files:
Solution.docx
Solution.xlsx
Purchase Solution
$75.00
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Business 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 Version901msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (616ms)time
    • Application (284ms)time
    • 1 x Booting (68.43%)
      616ms
      1 x Application (31.57%)
      284ms
      • Illuminate\Routing\Events\Routing (1.02ms)
      • Illuminate\Routing\Events\RouteMatched (417μs)
      • Illuminate\Foundation\Events\LocaleUpdated (2.05ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (226μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (113μs)
      • Illuminate\Database\Events\ConnectionEstablished (680μs)
      • Illuminate\Database\Events\StatementPrepared (4.27ms)
      • Illuminate\Database\Events\QueryExecuted (973μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (116μs)
      • eloquent.booting: App\Models\Subject (72μs)
      • eloquent.booted: App\Models\Subject (61μs)
      • Illuminate\Database\Events\StatementPrepared (1.94ms)
      • Illuminate\Database\Events\QueryExecuted (925μs)
      • eloquent.retrieved: App\Models\Subject (95μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (88μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (47μs)
      • Illuminate\Database\Events\StatementPrepared (583μs)
      • Illuminate\Database\Events\QueryExecuted (1.06ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (97μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (20μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (12μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (10μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.booting: App\Models\SubjectCat (848μs)
      • eloquent.booted: App\Models\SubjectCat (58μs)
      • Illuminate\Database\Events\StatementPrepared (659μs)
      • Illuminate\Database\Events\QueryExecuted (1.04ms)
      • eloquent.retrieved: App\Models\SubjectCat (443μs)
      • Illuminate\Cache\Events\CacheHit (51.25ms)
      • Illuminate\Cache\Events\CacheMissed (199μs)
      • Illuminate\Database\Events\StatementPrepared (786μs)
      • Illuminate\Database\Events\QueryExecuted (26.4ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (124μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (24μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (14μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (12μs)
      • Illuminate\Database\Events\StatementPrepared (3.86ms)
      • Illuminate\Database\Events\QueryExecuted (2.44ms)
      • eloquent.retrieved: App\Models\Subject (134μs)
      • Illuminate\Cache\Events\KeyWritten (1.31ms)
      • Illuminate\Database\Events\StatementPrepared (3.63ms)
      • Illuminate\Database\Events\QueryExecuted (1.75ms)
      • Illuminate\Database\Events\StatementPrepared (970μs)
      • Illuminate\Database\Events\QueryExecuted (1.66ms)
      • Illuminate\Database\Events\StatementPrepared (641μs)
      • Illuminate\Database\Events\QueryExecuted (3.32ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (132μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (22μs)
      • Illuminate\Cache\Events\CacheHit (1.95ms)
      • creating: homework.show (755μs)
      • composing: homework.show (2.44ms)
      • creating: components.breadcrumbs (527μs)
      • composing: components.breadcrumbs (188μs)
      • Illuminate\Database\Events\StatementPrepared (3.7ms)
      • Illuminate\Database\Events\QueryExecuted (965μs)
      • eloquent.retrieved: App\Models\SubjectCat (146μs)
      • Illuminate\Cache\Events\CacheHit (5.34ms)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (283μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (295μs)
      • Illuminate\Cache\Events\CacheHit (2.1ms)
      • Illuminate\Cache\Events\CacheHit (310μs)
      • Illuminate\Cache\Events\CacheHit (570μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (229μs)
      • Illuminate\Cache\Events\CacheHit (279μs)
      • Illuminate\Cache\Events\CacheHit (226μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (318μs)
      • Illuminate\Cache\Events\CacheHit (253μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (891μs)
      • Illuminate\Cache\Events\CacheHit (218μs)
      • Illuminate\Cache\Events\CacheHit (279μs)
      • Illuminate\Cache\Events\CacheHit (343μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (525μs)
      • Illuminate\Cache\Events\CacheHit (281μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (380μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (412μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (243μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (241μs)
      • Illuminate\Cache\Events\CacheHit (275μs)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (324μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (238μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (307μs)
      • Illuminate\Cache\Events\CacheHit (270μs)
      • Illuminate\Cache\Events\CacheHit (272μs)
      • Illuminate\Cache\Events\CacheHit (216μs)
      • Illuminate\Cache\Events\CacheHit (1.03ms)
      • Illuminate\Cache\Events\CacheHit (699μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (302μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (336μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (239μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (346μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (413μs)
      • Illuminate\Cache\Events\CacheHit (516μs)
      • Illuminate\Cache\Events\CacheHit (244μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (160μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (212μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheHit (486μs)
      • Illuminate\Cache\Events\CacheHit (938μs)
      • Illuminate\Cache\Events\CacheHit (194μs)
      • Illuminate\Cache\Events\CacheHit (304μs)
      • Illuminate\Cache\Events\CacheHit (265μs)
      • Illuminate\Cache\Events\CacheHit (733μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (319μs)
      • Illuminate\Cache\Events\CacheHit (1.27ms)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (262μs)
      • Illuminate\Cache\Events\CacheHit (320μs)
      • Illuminate\Cache\Events\CacheHit (324μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (3.24ms)
      • Illuminate\Cache\Events\CacheHit (402μs)
      • Illuminate\Cache\Events\CacheHit (200μs)
      • Illuminate\Cache\Events\CacheHit (2.06ms)
      • Illuminate\Cache\Events\CacheHit (466μs)
      • Illuminate\Cache\Events\CacheHit (297μs)
      • Illuminate\Cache\Events\CacheHit (612μs)
      • Illuminate\Cache\Events\CacheHit (307μs)
      • Illuminate\Cache\Events\CacheHit (479μs)
      • Illuminate\Cache\Events\CacheHit (401μs)
      • Illuminate\Cache\Events\CacheHit (258μs)
      • Illuminate\Cache\Events\CacheHit (619μs)
      • Illuminate\Cache\Events\CacheHit (388μs)
      • Illuminate\Cache\Events\CacheHit (496μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (260μs)
      • Illuminate\Cache\Events\CacheHit (453μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (281μs)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (331μs)
      • Illuminate\Cache\Events\CacheHit (954μs)
      • Illuminate\Cache\Events\CacheHit (364μs)
      • Illuminate\Cache\Events\CacheHit (331μs)
      • Illuminate\Cache\Events\CacheHit (335μs)
      • Illuminate\Cache\Events\CacheHit (293μs)
      • Illuminate\Cache\Events\CacheHit (325μs)
      • Illuminate\Cache\Events\CacheHit (453μs)
      • Illuminate\Cache\Events\CacheHit (284μs)
      • Illuminate\Cache\Events\CacheHit (430μs)
      • Illuminate\Cache\Events\CacheHit (564μs)
      • Illuminate\Cache\Events\CacheHit (1.15ms)
      • Illuminate\Cache\Events\CacheHit (1.69ms)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (246μs)
      • Illuminate\Cache\Events\CacheHit (251μs)
      • Illuminate\Cache\Events\CacheHit (249μs)
      • Illuminate\Cache\Events\CacheHit (291μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (520μs)
      • Illuminate\Cache\Events\CacheHit (238μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (717μs)
      • Illuminate\Cache\Events\CacheHit (444μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (220μs)
      • Illuminate\Cache\Events\CacheHit (263μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (382μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (287μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (265μs)
      • Illuminate\Cache\Events\CacheHit (259μs)
      • Illuminate\Cache\Events\CacheHit (267μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (269μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheMissed (2.72ms)
      • Illuminate\Database\Events\StatementPrepared (8.44ms)
      • Illuminate\Database\Events\QueryExecuted (1.44ms)
      • eloquent.retrieved: App\Models\SubjectCat (109μs)
      • Illuminate\Cache\Events\KeyWritten (479μs)
      • Illuminate\Cache\Events\CacheHit (266μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (427μs)
      • Illuminate\Cache\Events\CacheHit (393μs)
      • Illuminate\Cache\Events\CacheHit (445μs)
      • Illuminate\Cache\Events\CacheHit (678μs)
      • Illuminate\Cache\Events\CacheHit (262μs)
      • Illuminate\Cache\Events\CacheHit (206μs)
      • Illuminate\Cache\Events\CacheHit (361μs)
      • Illuminate\Cache\Events\CacheHit (324μs)
      • Illuminate\Cache\Events\CacheHit (171μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (255μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (307μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (1.44ms)
      • Illuminate\Cache\Events\CacheHit (264μs)
      • Illuminate\Cache\Events\CacheHit (331μs)
      • Illuminate\Cache\Events\CacheHit (350μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (274μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (256μs)
      • Illuminate\Cache\Events\CacheHit (309μs)
      • Illuminate\Cache\Events\CacheHit (263μs)
      • Illuminate\Cache\Events\CacheHit (271μs)
      • Illuminate\Cache\Events\CacheHit (608μs)
      • Illuminate\Cache\Events\CacheHit (306μs)
      • Illuminate\Cache\Events\CacheHit (232μs)
      • Illuminate\Cache\Events\CacheHit (254μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (358μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (286μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (398μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (359μs)
      • Illuminate\Cache\Events\CacheHit (223μs)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (383μs)
      • Illuminate\Cache\Events\CacheHit (403μs)
      • Illuminate\Cache\Events\CacheHit (219μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (225μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (184μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (195μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (592μs)
      • Illuminate\Cache\Events\CacheHit (182μs)
      • Illuminate\Cache\Events\CacheHit (177μs)
      • Illuminate\Cache\Events\CacheHit (580μs)
      • Illuminate\Cache\Events\CacheHit (222μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheHit (192μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheMissed (290μs)
      • Illuminate\Database\Events\StatementPrepared (1.06ms)
      • Illuminate\Database\Events\QueryExecuted (1ms)
      • eloquent.retrieved: App\Models\SubjectCat (101μs)
      • Illuminate\Cache\Events\KeyWritten (711μs)
      • Illuminate\Cache\Events\CacheHit (190μs)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (717μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (430μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (196μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (340μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (394μs)
      • Illuminate\Cache\Events\CacheHit (193μs)
      • Illuminate\Cache\Events\CacheHit (254μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (187μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • creating: site.layouts.app (743μs)
      • composing: site.layouts.app (26μs)
      • creating: components.canonical (538μs)
      • composing: components.canonical (116μs)
      • creating: components.open-graph (221μs)
      • composing: components.open-graph (301μs)
      • creating: site.headers.header (602μs)
      • composing: site.headers.header (91μs)
      • Illuminate\Cache\Events\CacheHit (2.23ms)
      • creating: components.footer (82μs)
      • composing: components.footer (101μs)
      • Illuminate\Cache\Events\CacheHit (1.31ms)
      • Illuminate\Cache\Events\CacheMissed (648μs)
      • Illuminate\Database\Events\StatementPrepared (8.42ms)
      • Illuminate\Database\Events\QueryExecuted (3.34ms)
      • eloquent.retrieved: App\Models\SubjectCat (108μs)
      • Illuminate\Cache\Events\KeyWritten (410μs)
      • Illuminate\Cache\Events\CacheHit (542μs)
      • Illuminate\Cache\Events\CacheHit (234μs)
      • Illuminate\Cache\Events\CacheHit (1.07ms)
      • Illuminate\Cache\Events\CacheHit (237μs)
      • Illuminate\Cache\Events\CacheHit (344μs)
      • Illuminate\Cache\Events\CacheHit (431μs)
      • Illuminate\Cache\Events\CacheHit (413μs)
      • Illuminate\Cache\Events\CacheHit (251μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (191μs)
      • Illuminate\Cache\Events\CacheHit (250μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • creating: components.forms.contact-us (722μs)
      • composing: components.forms.contact-us (197μs)
      • creating: components.forms.get-started (249μs)
      • composing: components.forms.get-started (437μs)
      • creating: components.forms.free-tool-download (171μs)
      • composing: components.forms.free-tool-download (80μs)
      • creating: components.forms.claim-free-worksheet (141μs)
      • composing: components.forms.claim-free-worksheet (75μs)
      • creating: components.forms.tutor-subscription-waitlist (136μs)
      • composing: components.forms.tutor-subscription-waitlist (74μs)
      • creating: components.forms.tutor-subscription-join (135μs)
      • composing: components.forms.tutor-subscription-join (73μs)
      • creating: components.forms.tutor-support (314μs)
      • composing: components.forms.tutor-support (152μs)
      • 318 x Illuminate\Cache\Events\CacheHit (17.48%)
        157ms
        13 x Illuminate\Database\Events\QueryExecuted (5.14%)
        46.31ms
        13 x Illuminate\Database\Events\StatementPrepared (4.33%)
        38.97ms
        4 x Illuminate\Cache\Events\CacheMissed (0.43%)
        3.86ms
        4 x Illuminate\Cache\Events\KeyWritten (0.32%)
        2.91ms
        1 x composing: homework.show (0.27%)
        2.44ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (0.23%)
        2.05ms
        1 x Illuminate\Routing\Events\Routing (0.11%)
        1.02ms
        5 x eloquent.retrieved: App\Models\SubjectCat (0.1%)
        907μs
        1 x eloquent.booting: App\Models\SubjectCat (0.09%)
        848μs
        1 x creating: homework.show (0.08%)
        755μs
        1 x creating: site.layouts.app (0.08%)
        743μs
        1 x creating: components.forms.contact-us (0.08%)
        722μs
        1 x Illuminate\Database\Events\ConnectionEstablished (0.08%)
        680μs
        1 x creating: site.headers.header (0.07%)
        602μs
        1 x creating: components.canonical (0.06%)
        538μs
        1 x creating: components.breadcrumbs (0.06%)
        527μs
        1 x composing: components.forms.get-started (0.05%)
        437μs
        1 x Illuminate\Routing\Events\RouteMatched (0.05%)
        417μs
        10 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.04%)
        326μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        316μs
        1 x creating: components.forms.tutor-support (0.03%)
        314μs
        1 x composing: components.open-graph (0.03%)
        301μs
        1 x creating: components.forms.get-started (0.03%)
        249μs
        2 x eloquent.retrieved: App\Models\Subject (0.03%)
        229μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.03%)
        226μs
        1 x creating: components.open-graph (0.02%)
        221μs
        1 x composing: components.forms.contact-us (0.02%)
        197μs
        1 x composing: components.breadcrumbs (0.02%)
        188μs
        1 x creating: components.forms.free-tool-download (0.02%)
        171μs
        1 x composing: components.forms.tutor-support (0.02%)
        152μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        141μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.02%)
        136μs
        1 x creating: components.forms.tutor-subscription-join (0.01%)
        135μs
        1 x composing: components.canonical (0.01%)
        116μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.01%)
        113μs
        1 x composing: components.footer (0.01%)
        101μs
        1 x composing: site.headers.header (0.01%)
        91μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        88μs
        1 x creating: components.footer (0.01%)
        82μs
        1 x composing: components.forms.free-tool-download (0.01%)
        80μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        75μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        74μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        73μs
        1 x eloquent.booting: App\Models\Subject (0.01%)
        72μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        61μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        58μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        47μs
        1 x composing: site.layouts.app (0%)
        26μ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
      13 statements were executed, 4 of which were duplicates, 9 unique. Show only duplicated68.77ms
      • 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` = '34271' limit 1
        4.52mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 34271
        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 (19)
        870μ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 (34271)
        860μ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 `subject_cats` where `subject_cats`.`id` = 4 limit 1
        930μstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 4
        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` <> 34271 and `subject` = 19 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        26.24mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 34271
        • 1: 19
        • 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 (19)
        5.45mstwenty4_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` = 34271 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        820μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 34271
        • 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` = 34271 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.77mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 34271
        • 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` = 34271 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        3.18mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 34271
        • 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` = 4 limit 1
        2.95mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 4
        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` = 34 limit 1
        8.98mstwenty4_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.35mstwenty4_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
        10.85mstwenty4_siteSubject.php#100
        Bindings
        • 0: 36
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 28. view::components.footer:170
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      10HomeworkLibraryFile.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\SubjectCat
      5SubjectCat.php
      App\Models\Subject
      2Subject.php
          _token
          xOihxw002SATjs3WgnRf5Ptv5YccdKypoGuRcAnu
          utm_source
          direct
          redirectUrl
          /college-homework-library/Business/Finance/34271
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Business/Financ...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/Business/Finance/34271
          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-67fb530d-1c0d2272315d2b4e1e816283" ] "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.221.200.48" ] "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 => "Sun, 13 Apr 2025 06:00:46 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImV3VUNyZGZMNnZPYStFaE5zOHlCbEE9PSIsInZhbHVlIjoiOFZVMlFkMXJnaGNaOHE2cUFZR0kyVDduUkkvSnIxWTE0UjZMVUJEbGR3VzBqQmtBbUMwdGJsZ0U1bDRNdXNmUVNDRWR6cFFvS2xuUlMvTzFvTVIwSjNwOE5pTnBEV3BuZGxCK1I1WlVmS2lBOUVWTjJmZ2hLRnVFaktDU0JlNGUiLCJtYWMiOiIxMmIwYWM5MGYzNzEwYTM2YTVlOTJjMzFlNGY0OTNjMmQ4YWUxYzIzNDkxNjk2MzliY2UwOGMzMWIzYzcyYzdiIiwidGFnIjoiIn0%3D; expires=Sun, 13 Apr 2025 08:00:46 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6ImV3VUNyZGZMNnZPYStFaE5zOHlCbEE9PSIsInZhbHVlIjoiOFZVMlFkMXJnaGNaOHE2cUFZR0kyVDduUkkvSnIxWTE0UjZMVUJEbGR3VzBqQmtBbUMwdGJsZ0U1bDRNdXNmUVNDRWR6c" 1 => "24houranswers_session=eyJpdiI6Iks4VlJPek5pdlZNMjY1STk2NmZwWFE9PSIsInZhbHVlIjoiaFBvdVY1TEsyWWJVbkQ4SURXQzkxcHpnaHQxek8vOEV1U2ZtZ3RjMDBIUzR4UFljTG1Wd2JYc3RaMXJTbWlQZ09raHhWOVJjWUdpUDY1TjJOUHZ1TXhSa0JGWitQVnZoNXRrbkNiQXg3d2l3dFZKSU16QzBqU3ZwN1dKbFBHVG4iLCJtYWMiOiIzNzVhNzg2ZDE3MGQ0MzE0OTc0ZGRkMTAyNTQ2NDU0Y2MwYTA2ZGZmYzJmMTc2MTQyY2Q2NDI5NzA3NDk2MTViIiwidGFnIjoiIn0%3D; expires=Sun, 13 Apr 2025 08:00:46 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6Iks4VlJPek5pdlZNMjY1STk2NmZwWFE9PSIsInZhbHVlIjoiaFBvdVY1TEsyWWJVbkQ4SURXQzkxcHpnaHQxek8vOEV1U2ZtZ3RjMDBIUzR4UFljTG1Wd2JYc3RaMXJTbW" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImV3VUNyZGZMNnZPYStFaE5zOHlCbEE9PSIsInZhbHVlIjoiOFZVMlFkMXJnaGNaOHE2cUFZR0kyVDduUkkvSnIxWTE0UjZMVUJEbGR3VzBqQmtBbUMwdGJsZ0U1bDRNdXNmUVNDRWR6cFFvS2xuUlMvTzFvTVIwSjNwOE5pTnBEV3BuZGxCK1I1WlVmS2lBOUVWTjJmZ2hLRnVFaktDU0JlNGUiLCJtYWMiOiIxMmIwYWM5MGYzNzEwYTM2YTVlOTJjMzFlNGY0OTNjMmQ4YWUxYzIzNDkxNjk2MzliY2UwOGMzMWIzYzcyYzdiIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 08:00:46 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6ImV3VUNyZGZMNnZPYStFaE5zOHlCbEE9PSIsInZhbHVlIjoiOFZVMlFkMXJnaGNaOHE2cUFZR0kyVDduUkkvSnIxWTE0UjZMVUJEbGR3VzBqQmtBbUMwdGJsZ0U1bDRNdXNmUVNDRWR6c" 1 => "24houranswers_session=eyJpdiI6Iks4VlJPek5pdlZNMjY1STk2NmZwWFE9PSIsInZhbHVlIjoiaFBvdVY1TEsyWWJVbkQ4SURXQzkxcHpnaHQxek8vOEV1U2ZtZ3RjMDBIUzR4UFljTG1Wd2JYc3RaMXJTbWlQZ09raHhWOVJjWUdpUDY1TjJOUHZ1TXhSa0JGWitQVnZoNXRrbkNiQXg3d2l3dFZKSU16QzBqU3ZwN1dKbFBHVG4iLCJtYWMiOiIzNzVhNzg2ZDE3MGQ0MzE0OTc0ZGRkMTAyNTQ2NDU0Y2MwYTA2ZGZmYzJmMTc2MTQyY2Q2NDI5NzA3NDk2MTViIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 08:00:46 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6Iks4VlJPek5pdlZNMjY1STk2NmZwWFE9PSIsInZhbHVlIjoiaFBvdVY1TEsyWWJVbkQ4SURXQzkxcHpnaHQxek8vOEV1U2ZtZ3RjMDBIUzR4UFljTG1Wd2JYc3RaMXJTbW" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "xOihxw002SATjs3WgnRf5Ptv5YccdKypoGuRcAnu" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Business/Finance/34271" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Business/Finance/34271" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]