Question
- This assignment assumes that you have a basic knowledge of Microsoft Excel and have the software installed on your computer.
- You will need to download the data file (See Question.xlsx).
- The report must be professionally written. All graphs must be accompanied by explanations in a paragraph that follows them. All captions and labels must be meaningful.

Pelican Stores Case
Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout the country. The chain recently ran a promotion in which discountn coupons were sent to customers of other National Clothing stores. Data collected for a sample of 80 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the file named PelicanStores.
The Proprietary Card method of payment refers to charges made using a National Clothing charge card. Customers who made a purchase using a discount coupon are referred to as promotional customers and customers who made a purchase but did not use a discount coupon are referred to as regular customers. Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Pelican also hopes that the promotional customers will continue to shop at its stores. Most of the variables shown the data are self-explanatory, but two of the variables require some clarification.
Items: The total number of items purchased
Net Sales: The total amount ($) charged to the credit card
Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

Managerial Report
1. Develop the Percent frequency distribution for key variables. Comment on your findings.
2. Develop a bar chart showing the number of customer purchases attributable to the method of
payment. Comment on your findings.
3. Develop a crosstabulation of type of customer (regular or promotional) versus net sales. Comment on
any similarities or differences present.
4. Compute descriptive statistics (mean, median, standard deviation, min, max, and range) on net sales
and descriptive statistics on net sales by various classifications of customers. Comment on your findings.
5. Compute descriptive statistics concerning the relationship between age and net sales. Comment on
your findings.
6. Develop a scatter diagram to explore the relationship between net sales and customer age.
Comment on your findings.
7. What is your opinion on the effectiveness of the promotion involving discount coupons?
Solution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references.
Students may use these solutions for personal skill-building and practice.
Unethical use is strictly forbidden.

This is only a preview of the solution.
Please use the purchase button to see the entire solution.
By purchasing this solution you'll be able to access the following files:
Solution.docx
Purchase Solution
$1.00
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Mathematics 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 Version462msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
  • warninglog[16:55:25] LOG.warning: Return type of STS\Session\RawSessionHandler::open($savePath, $sessionName) ...
  • warninglog[16:55:25] LOG.warning: Return type of STS\Session\RawSessionHandler::open($savePath, $sessionName) ...
  • warninglog[16:55:25] LOG.warning: Return type of STS\Session\RawSessionHandler::close() should either be compa...
  • warninglog[16:55:25] LOG.warning: Return type of STS\Session\RawSessionHandler::read($sessionId) should either...
  • warninglog[16:55:25] LOG.warning: Return type of STS\Session\RawSessionHandler::write($sessionId, $data) shoul...
  • warninglog[16:55:25] LOG.warning: Return type of STS\Session\RawSessionHandler::destroy($sessionId) should eit...
  • warninglog[16:55:25] LOG.warning: Return type of STS\Session\RawSessionHandler::gc($lifetime) should either be...
  • Booting (217ms)time
  • Application (245ms)time
  • 1 x Application (53.08%)
    245ms
    1 x Booting (46.92%)
    217ms
    • Illuminate\Routing\Events\Routing (1.08ms)
    • Illuminate\Routing\Events\RouteMatched (500μs)
    • Illuminate\Log\Events\MessageLogged (2.88ms)
    • Illuminate\Log\Events\MessageLogged (77μs)
    • Illuminate\Log\Events\MessageLogged (56μs)
    • Illuminate\Log\Events\MessageLogged (50μs)
    • Illuminate\Log\Events\MessageLogged (48μs)
    • Illuminate\Log\Events\MessageLogged (45μs)
    • Illuminate\Log\Events\MessageLogged (49μs)
    • Illuminate\Foundation\Events\LocaleUpdated (4.38ms)
    • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (187μs)
    • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (156μs)
    • Illuminate\Database\Events\ConnectionEstablished (896μs)
    • Illuminate\Database\Events\StatementPrepared (9.63ms)
    • Illuminate\Database\Events\QueryExecuted (895μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (98μs)
    • eloquent.booting: App\Models\Subject (118μs)
    • eloquent.booted: App\Models\Subject (42μs)
    • Illuminate\Database\Events\StatementPrepared (1.59ms)
    • Illuminate\Database\Events\QueryExecuted (1.13ms)
    • eloquent.retrieved: App\Models\Subject (103μs)
    • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (883μs)
    • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (44μs)
    • Illuminate\Database\Events\StatementPrepared (1.03ms)
    • Illuminate\Database\Events\QueryExecuted (801μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (65μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (14μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (6μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (4μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (6μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
    • eloquent.booting: App\Models\SubjectCat (2.23ms)
    • eloquent.booted: App\Models\SubjectCat (44μs)
    • Illuminate\Database\Events\StatementPrepared (729μs)
    • Illuminate\Database\Events\QueryExecuted (1.1ms)
    • eloquent.retrieved: App\Models\SubjectCat (86μs)
    • Illuminate\Cache\Events\CacheMissed (683μs)
    • eloquent.booting: App\Models\User\Tutor (312μs)
    • eloquent.booted: App\Models\User\Tutor (120μs)
    • Illuminate\Database\Events\ConnectionEstablished (586μs)
    • Illuminate\Database\Events\StatementPrepared (7.04ms)
    • Illuminate\Database\Events\QueryExecuted (9.98ms)
    • eloquent.retrieved: App\Models\User\Tutor (130μs)
    • eloquent.retrieved: App\Models\User\Tutor (22μs)
    • eloquent.retrieved: App\Models\User\Tutor (31μs)
    • Illuminate\Cache\Events\CacheHit (1.11ms)
    • Illuminate\Cache\Events\CacheHit (4.15ms)
    • eloquent.booting: App\Models\User\TutorAttributes\TutorDegree (966μs)
    • eloquent.booted: App\Models\User\TutorAttributes\TutorDegree (46μs)
    • Illuminate\Database\Events\StatementPrepared (938μs)
    • Illuminate\Database\Events\QueryExecuted (931μs)
    • Illuminate\Cache\Events\CacheHit (441μs)
    • Illuminate\Cache\Events\CacheHit (2.11ms)
    • Illuminate\Database\Events\StatementPrepared (1.3ms)
    • Illuminate\Database\Events\QueryExecuted (822μs)
    • Illuminate\Cache\Events\CacheHit (570μs)
    • Illuminate\Cache\Events\CacheHit (1.5ms)
    • Illuminate\Database\Events\StatementPrepared (1.35ms)
    • Illuminate\Database\Events\QueryExecuted (716μs)
    • Illuminate\Cache\Events\KeyWritten (40.98ms)
    • Illuminate\Cache\Events\CacheMissed (222μs)
    • Illuminate\Database\Events\StatementPrepared (995μs)
    • Illuminate\Database\Events\QueryExecuted (10.65ms)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (87μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (15μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (8μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (5μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
    • Illuminate\Database\Events\StatementPrepared (682μs)
    • Illuminate\Database\Events\QueryExecuted (773μs)
    • eloquent.retrieved: App\Models\Subject (76μs)
    • Illuminate\Cache\Events\KeyWritten (728μs)
    • Illuminate\Database\Events\StatementPrepared (17.13ms)
    • Illuminate\Database\Events\QueryExecuted (771μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (122μs)
    • Illuminate\Database\Events\StatementPrepared (1.73ms)
    • Illuminate\Database\Events\QueryExecuted (722μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (41μs)
    • Illuminate\Database\Events\StatementPrepared (765μs)
    • Illuminate\Database\Events\QueryExecuted (734μs)
    • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (36μs)
    • Illuminate\Cache\Events\CacheMissed (238μs)
    • Illuminate\Database\Events\StatementPrepared (783μs)
    • Illuminate\Database\Events\QueryExecuted (868μs)
    • Illuminate\Cache\Events\KeyWritten (291μs)
    • creating: homework.show (3.09ms)
    • composing: homework.show (208μs)
    • creating: components.breadcrumbs (1.57ms)
    • composing: components.breadcrumbs (122μs)
    • Illuminate\Database\Events\StatementPrepared (1.97ms)
    • Illuminate\Database\Events\QueryExecuted (805μs)
    • eloquent.retrieved: App\Models\SubjectCat (72μs)
    • Illuminate\Cache\Events\CacheMissed (5.26ms)
    • Illuminate\Database\Events\StatementPrepared (753μs)
    • Illuminate\Database\Events\QueryExecuted (1.05ms)
    • eloquent.retrieved: App\Models\SubjectCat (82μs)
    • Illuminate\Cache\Events\KeyWritten (336μs)
    • Illuminate\Cache\Events\CacheHit (232μs)
    • Illuminate\Cache\Events\CacheHit (159μs)
    • Illuminate\Cache\Events\CacheHit (110μs)
    • Illuminate\Cache\Events\CacheHit (350μs)
    • Illuminate\Cache\Events\CacheHit (189μs)
    • Illuminate\Cache\Events\CacheHit (136μs)
    • Illuminate\Cache\Events\CacheHit (261μs)
    • Illuminate\Cache\Events\CacheHit (145μs)
    • Illuminate\Cache\Events\CacheHit (141μs)
    • Illuminate\Cache\Events\CacheHit (114μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheHit (227μs)
    • Illuminate\Cache\Events\CacheHit (116μs)
    • Illuminate\Cache\Events\CacheMissed (1.04ms)
    • Illuminate\Database\Events\StatementPrepared (959μs)
    • Illuminate\Database\Events\QueryExecuted (900μs)
    • eloquent.retrieved: App\Models\SubjectCat (62μs)
    • Illuminate\Cache\Events\KeyWritten (325μs)
    • Illuminate\Cache\Events\CacheHit (175μs)
    • Illuminate\Cache\Events\CacheHit (150μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (129μs)
    • Illuminate\Cache\Events\CacheHit (128μs)
    • Illuminate\Cache\Events\CacheHit (128μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • Illuminate\Cache\Events\CacheMissed (177μs)
    • Illuminate\Database\Events\StatementPrepared (1.62ms)
    • Illuminate\Database\Events\QueryExecuted (1.25ms)
    • eloquent.retrieved: App\Models\SubjectCat (85μs)
    • Illuminate\Cache\Events\KeyWritten (281μs)
    • Illuminate\Cache\Events\CacheHit (169μs)
    • Illuminate\Cache\Events\CacheHit (163μs)
    • Illuminate\Cache\Events\CacheHit (105μs)
    • Illuminate\Cache\Events\CacheHit (118μs)
    • Illuminate\Cache\Events\CacheHit (100μs)
    • Illuminate\Cache\Events\CacheHit (143μs)
    • Illuminate\Cache\Events\CacheHit (111μs)
    • Illuminate\Cache\Events\CacheHit (123μs)
    • Illuminate\Cache\Events\CacheHit (147μs)
    • Illuminate\Cache\Events\CacheHit (274μs)
    • Illuminate\Cache\Events\CacheHit (308μs)
    • Illuminate\Cache\Events\CacheHit (264μs)
    • Illuminate\Cache\Events\CacheHit (144μs)
    • Illuminate\Cache\Events\CacheHit (158μs)
    • Illuminate\Cache\Events\CacheHit (175μs)
    • Illuminate\Cache\Events\CacheHit (280μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (97μs)
    • Illuminate\Cache\Events\CacheHit (113μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheHit (220μs)
    • Illuminate\Cache\Events\CacheHit (347μs)
    • Illuminate\Cache\Events\CacheHit (150μs)
    • Illuminate\Cache\Events\CacheHit (119μs)
    • Illuminate\Cache\Events\CacheHit (127μs)
    • Illuminate\Cache\Events\CacheHit (107μs)
    • Illuminate\Cache\Events\CacheHit (125μs)
    • Illuminate\Cache\Events\CacheHit (118μs)
    • Illuminate\Cache\Events\CacheHit (125μs)
    • Illuminate\Cache\Events\CacheHit (134μs)
    • Illuminate\Cache\Events\CacheMissed (187μs)
    • Illuminate\Database\Events\StatementPrepared (700μs)
    • Illuminate\Database\Events\QueryExecuted (1.07ms)
    • eloquent.retrieved: App\Models\SubjectCat (63μs)
    • Illuminate\Cache\Events\KeyWritten (271μs)
    • Illuminate\Cache\Events\CacheHit (263μs)
    • Illuminate\Cache\Events\CacheHit (166μs)
    • Illuminate\Cache\Events\CacheHit (109μs)
    • Illuminate\Cache\Events\CacheHit (267μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (119μs)
    • Illuminate\Cache\Events\CacheHit (181μs)
    • Illuminate\Cache\Events\CacheHit (229μs)
    • Illuminate\Cache\Events\CacheHit (119μs)
    • Illuminate\Cache\Events\CacheHit (144μs)
    • Illuminate\Cache\Events\CacheHit (119μs)
    • Illuminate\Cache\Events\CacheHit (121μs)
    • Illuminate\Cache\Events\CacheHit (192μs)
    • Illuminate\Cache\Events\CacheHit (367μs)
    • Illuminate\Cache\Events\CacheHit (145μs)
    • Illuminate\Cache\Events\CacheHit (180μs)
    • Illuminate\Cache\Events\CacheHit (120μs)
    • Illuminate\Cache\Events\CacheHit (295μs)
    • Illuminate\Cache\Events\CacheHit (226μs)
    • Illuminate\Cache\Events\CacheHit (293μs)
    • Illuminate\Cache\Events\CacheHit (140μs)
    • Illuminate\Cache\Events\CacheHit (129μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • Illuminate\Cache\Events\CacheHit (132μs)
    • Illuminate\Cache\Events\CacheHit (103μs)
    • Illuminate\Cache\Events\CacheHit (116μs)
    • Illuminate\Cache\Events\CacheHit (102μs)
    • Illuminate\Cache\Events\CacheHit (116μs)
    • Illuminate\Cache\Events\CacheHit (103μs)
    • Illuminate\Cache\Events\CacheHit (118μs)
    • Illuminate\Cache\Events\CacheHit (101μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (101μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (173μs)
    • Illuminate\Cache\Events\CacheHit (138μs)
    • Illuminate\Cache\Events\CacheHit (97μs)
    • Illuminate\Cache\Events\CacheHit (123μs)
    • Illuminate\Cache\Events\CacheHit (238μs)
    • Illuminate\Cache\Events\CacheMissed (298μs)
    • Illuminate\Database\Events\StatementPrepared (975μs)
    • Illuminate\Database\Events\QueryExecuted (1.18ms)
    • eloquent.retrieved: App\Models\SubjectCat (66μs)
    • Illuminate\Cache\Events\KeyWritten (303μs)
    • Illuminate\Cache\Events\CacheHit (160μs)
    • Illuminate\Cache\Events\CacheHit (296μs)
    • Illuminate\Cache\Events\CacheHit (206μs)
    • Illuminate\Cache\Events\CacheHit (140μs)
    • Illuminate\Cache\Events\CacheHit (102μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (181μs)
    • Illuminate\Cache\Events\CacheMissed (205μs)
    • Illuminate\Database\Events\StatementPrepared (640μs)
    • Illuminate\Database\Events\QueryExecuted (787μs)
    • eloquent.retrieved: App\Models\SubjectCat (57μs)
    • Illuminate\Cache\Events\KeyWritten (254μs)
    • Illuminate\Cache\Events\CacheHit (162μs)
    • Illuminate\Cache\Events\CacheHit (423μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (163μs)
    • Illuminate\Cache\Events\CacheHit (113μs)
    • Illuminate\Cache\Events\CacheHit (123μs)
    • Illuminate\Cache\Events\CacheHit (265μs)
    • Illuminate\Cache\Events\CacheHit (158μs)
    • Illuminate\Cache\Events\CacheHit (102μs)
    • Illuminate\Cache\Events\CacheHit (125μs)
    • Illuminate\Cache\Events\CacheHit (106μs)
    • Illuminate\Cache\Events\CacheHit (651μs)
    • Illuminate\Cache\Events\CacheHit (172μs)
    • Illuminate\Cache\Events\CacheHit (140μs)
    • Illuminate\Cache\Events\CacheHit (101μs)
    • Illuminate\Cache\Events\CacheHit (218μs)
    • Illuminate\Cache\Events\CacheHit (122μs)
    • Illuminate\Cache\Events\CacheHit (248μs)
    • Illuminate\Cache\Events\CacheHit (129μs)
    • Illuminate\Cache\Events\CacheHit (120μs)
    • Illuminate\Cache\Events\CacheHit (99μs)
    • Illuminate\Cache\Events\CacheHit (180μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (126μs)
    • Illuminate\Cache\Events\CacheHit (391μs)
    • Illuminate\Cache\Events\CacheHit (169μs)
    • Illuminate\Cache\Events\CacheHit (101μs)
    • Illuminate\Cache\Events\CacheHit (136μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • Illuminate\Cache\Events\CacheMissed (279μs)
    • Illuminate\Database\Events\StatementPrepared (835μs)
    • Illuminate\Database\Events\QueryExecuted (2.25ms)
    • eloquent.retrieved: App\Models\SubjectCat (75μs)
    • Illuminate\Cache\Events\KeyWritten (298μs)
    • Illuminate\Cache\Events\CacheHit (186μs)
    • Illuminate\Cache\Events\CacheHit (415μs)
    • Illuminate\Cache\Events\CacheHit (132μs)
    • Illuminate\Cache\Events\CacheHit (124μs)
    • Illuminate\Cache\Events\CacheHit (101μs)
    • Illuminate\Cache\Events\CacheHit (223μs)
    • Illuminate\Cache\Events\CacheHit (123μs)
    • Illuminate\Cache\Events\CacheHit (138μs)
    • Illuminate\Cache\Events\CacheHit (102μs)
    • Illuminate\Cache\Events\CacheHit (124μs)
    • Illuminate\Cache\Events\CacheHit (215μs)
    • Illuminate\Cache\Events\CacheHit (124μs)
    • Illuminate\Cache\Events\CacheHit (133μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (98μs)
    • Illuminate\Cache\Events\CacheHit (113μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheHit (111μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheHit (110μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheHit (111μs)
    • Illuminate\Cache\Events\CacheHit (94μs)
    • Illuminate\Cache\Events\CacheHit (120μs)
    • Illuminate\Cache\Events\CacheHit (92μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • Illuminate\Cache\Events\CacheHit (93μs)
    • Illuminate\Cache\Events\CacheHit (107μs)
    • Illuminate\Cache\Events\CacheHit (93μs)
    • Illuminate\Cache\Events\CacheHit (140μs)
    • Illuminate\Cache\Events\CacheHit (111μs)
    • Illuminate\Cache\Events\CacheHit (118μs)
    • Illuminate\Cache\Events\CacheHit (101μs)
    • Illuminate\Cache\Events\CacheHit (201μs)
    • Illuminate\Cache\Events\CacheHit (99μs)
    • Illuminate\Cache\Events\CacheHit (204μs)
    • Illuminate\Cache\Events\CacheHit (102μs)
    • Illuminate\Cache\Events\CacheHit (109μs)
    • Illuminate\Cache\Events\CacheHit (210μs)
    • Illuminate\Cache\Events\CacheHit (133μs)
    • Illuminate\Cache\Events\CacheHit (95μs)
    • Illuminate\Cache\Events\CacheHit (181μs)
    • Illuminate\Cache\Events\CacheHit (298μs)
    • Illuminate\Cache\Events\CacheHit (147μs)
    • Illuminate\Cache\Events\CacheHit (123μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (95μs)
    • Illuminate\Cache\Events\CacheHit (111μs)
    • Illuminate\Cache\Events\CacheHit (97μs)
    • Illuminate\Cache\Events\CacheHit (129μs)
    • Illuminate\Cache\Events\CacheHit (106μs)
    • Illuminate\Cache\Events\CacheHit (121μs)
    • Illuminate\Cache\Events\CacheHit (105μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (97μs)
    • Illuminate\Cache\Events\CacheHit (111μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheHit (250μs)
    • Illuminate\Cache\Events\CacheHit (124μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (93μs)
    • Illuminate\Cache\Events\CacheHit (116μs)
    • Illuminate\Cache\Events\CacheHit (97μs)
    • Illuminate\Cache\Events\CacheMissed (294μs)
    • Illuminate\Database\Events\StatementPrepared (684μs)
    • Illuminate\Database\Events\QueryExecuted (1.03ms)
    • eloquent.retrieved: App\Models\SubjectCat (68μs)
    • Illuminate\Cache\Events\KeyWritten (279μs)
    • Illuminate\Cache\Events\CacheHit (162μs)
    • Illuminate\Cache\Events\CacheHit (170μs)
    • Illuminate\Cache\Events\CacheHit (112μs)
    • Illuminate\Cache\Events\CacheHit (2.78ms)
    • Illuminate\Cache\Events\CacheHit (146μs)
    • Illuminate\Cache\Events\CacheHit (284μs)
    • Illuminate\Cache\Events\CacheHit (164μs)
    • Illuminate\Cache\Events\CacheHit (132μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • Illuminate\Cache\Events\CacheHit (217μs)
    • Illuminate\Cache\Events\CacheHit (109μs)
    • Illuminate\Cache\Events\CacheHit (118μs)
    • Illuminate\Cache\Events\CacheHit (101μs)
    • Illuminate\Cache\Events\CacheHit (125μs)
    • Illuminate\Cache\Events\CacheHit (95μs)
    • Illuminate\Cache\Events\CacheHit (127μs)
    • Illuminate\Cache\Events\CacheHit (337μs)
    • Illuminate\Cache\Events\CacheHit (1.37ms)
    • Illuminate\Cache\Events\CacheHit (203μs)
    • Illuminate\Cache\Events\CacheHit (272μs)
    • Illuminate\Cache\Events\CacheHit (210μs)
    • Illuminate\Cache\Events\CacheHit (218μs)
    • Illuminate\Cache\Events\CacheHit (168μs)
    • Illuminate\Cache\Events\CacheHit (138μs)
    • Illuminate\Cache\Events\CacheHit (103μs)
    • Illuminate\Cache\Events\CacheHit (178μs)
    • Illuminate\Cache\Events\CacheHit (113μs)
    • Illuminate\Cache\Events\CacheHit (118μs)
    • Illuminate\Cache\Events\CacheHit (99μs)
    • Illuminate\Cache\Events\CacheHit (327μs)
    • Illuminate\Cache\Events\CacheHit (130μs)
    • Illuminate\Cache\Events\CacheHit (118μs)
    • Illuminate\Cache\Events\CacheHit (98μs)
    • Illuminate\Cache\Events\CacheHit (110μs)
    • Illuminate\Cache\Events\CacheHit (94μs)
    • Illuminate\Cache\Events\CacheHit (134μs)
    • Illuminate\Cache\Events\CacheHit (106μs)
    • Illuminate\Cache\Events\CacheHit (185μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (145μs)
    • Illuminate\Cache\Events\CacheHit (140μs)
    • Illuminate\Cache\Events\CacheHit (98μs)
    • Illuminate\Cache\Events\CacheHit (158μs)
    • Illuminate\Cache\Events\CacheHit (100μs)
    • Illuminate\Cache\Events\CacheHit (109μs)
    • Illuminate\Cache\Events\CacheHit (93μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • Illuminate\Cache\Events\CacheHit (93μs)
    • Illuminate\Cache\Events\CacheHit (241μs)
    • Illuminate\Cache\Events\CacheHit (128μs)
    • Illuminate\Cache\Events\CacheHit (141μs)
    • Illuminate\Cache\Events\CacheHit (99μs)
    • Illuminate\Cache\Events\CacheHit (110μs)
    • Illuminate\Cache\Events\CacheHit (97μs)
    • Illuminate\Cache\Events\CacheHit (124μs)
    • Illuminate\Cache\Events\CacheHit (99μs)
    • Illuminate\Cache\Events\CacheHit (113μs)
    • Illuminate\Cache\Events\CacheHit (97μs)
    • Illuminate\Cache\Events\CacheHit (109μs)
    • Illuminate\Cache\Events\CacheHit (94μs)
    • Illuminate\Cache\Events\CacheHit (109μs)
    • Illuminate\Cache\Events\CacheHit (111μs)
    • Illuminate\Cache\Events\CacheHit (364μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (114μs)
    • Illuminate\Cache\Events\CacheHit (94μs)
    • Illuminate\Cache\Events\CacheHit (107μs)
    • Illuminate\Cache\Events\CacheHit (93μs)
    • Illuminate\Cache\Events\CacheHit (230μs)
    • Illuminate\Cache\Events\CacheHit (120μs)
    • Illuminate\Cache\Events\CacheHit (138μs)
    • Illuminate\Cache\Events\CacheHit (190μs)
    • Illuminate\Cache\Events\CacheHit (168μs)
    • Illuminate\Cache\Events\CacheHit (132μs)
    • Illuminate\Cache\Events\CacheHit (116μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheHit (182μs)
    • Illuminate\Cache\Events\CacheHit (345μs)
    • Illuminate\Cache\Events\CacheHit (206μs)
    • Illuminate\Cache\Events\CacheHit (104μs)
    • Illuminate\Cache\Events\CacheHit (113μs)
    • Illuminate\Cache\Events\CacheHit (92μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (100μs)
    • Illuminate\Cache\Events\CacheHit (120μs)
    • Illuminate\Cache\Events\CacheHit (99μs)
    • Illuminate\Cache\Events\CacheHit (112μs)
    • Illuminate\Cache\Events\CacheHit (96μs)
    • Illuminate\Cache\Events\CacheMissed (189μs)
    • Illuminate\Database\Events\StatementPrepared (880μs)
    • Illuminate\Database\Events\QueryExecuted (782μs)
    • eloquent.retrieved: App\Models\SubjectCat (65μs)
    • Illuminate\Cache\Events\KeyWritten (320μs)
    • Illuminate\Cache\Events\CacheHit (152μs)
    • Illuminate\Cache\Events\CacheHit (147μs)
    • Illuminate\Cache\Events\CacheHit (169μs)
    • Illuminate\Cache\Events\CacheHit (137μs)
    • Illuminate\Cache\Events\CacheHit (202μs)
    • Illuminate\Cache\Events\CacheHit (152μs)
    • Illuminate\Cache\Events\CacheHit (219μs)
    • Illuminate\Cache\Events\CacheHit (169μs)
    • Illuminate\Cache\Events\CacheHit (106μs)
    • Illuminate\Cache\Events\CacheHit (117μs)
    • Illuminate\Cache\Events\CacheHit (203μs)
    • Illuminate\Cache\Events\CacheHit (126μs)
    • Illuminate\Cache\Events\CacheHit (107μs)
    • Illuminate\Cache\Events\CacheHit (110μs)
    • Illuminate\Cache\Events\CacheHit (94μs)
    • Illuminate\Cache\Events\CacheHit (106μs)
    • Illuminate\Cache\Events\CacheHit (92μs)
    • creating: site.layouts.app (334μs)
    • composing: site.layouts.app (16μs)
    • creating: components.canonical (441μs)
    • composing: components.canonical (137μs)
    • creating: components.open-graph (171μs)
    • composing: components.open-graph (53μs)
    • creating: site.headers.header (279μs)
    • composing: site.headers.header (53μs)
    • Illuminate\Cache\Events\CacheHit (1.22ms)
    • creating: components.footer (60μs)
    • composing: components.footer (62μs)
    • Illuminate\Cache\Events\CacheHit (695μs)
    • Illuminate\Cache\Events\CacheMissed (315μs)
    • Illuminate\Database\Events\StatementPrepared (668μs)
    • Illuminate\Database\Events\QueryExecuted (881μs)
    • eloquent.retrieved: App\Models\SubjectCat (64μs)
    • Illuminate\Cache\Events\KeyWritten (350μs)
    • Illuminate\Cache\Events\CacheHit (355μs)
    • Illuminate\Cache\Events\CacheHit (182μs)
    • Illuminate\Cache\Events\CacheHit (132μs)
    • Illuminate\Cache\Events\CacheHit (115μs)
    • Illuminate\Cache\Events\CacheHit (114μs)
    • Illuminate\Cache\Events\CacheHit (189μs)
    • Illuminate\Cache\Events\CacheHit (482μs)
    • Illuminate\Cache\Events\CacheHit (144μs)
    • Illuminate\Cache\Events\CacheHit (122μs)
    • Illuminate\Cache\Events\CacheHit (112μs)
    • Illuminate\Cache\Events\CacheHit (116μs)
    • Illuminate\Cache\Events\CacheHit (108μs)
    • creating: components.forms.contact-us (178μs)
    • composing: components.forms.contact-us (95μs)
    • creating: components.forms.get-started (112μs)
    • composing: components.forms.get-started (43μs)
    • creating: components.forms.free-tool-download (78μs)
    • composing: components.forms.free-tool-download (38μs)
    • creating: components.forms.claim-free-worksheet (76μs)
    • composing: components.forms.claim-free-worksheet (37μs)
    • creating: components.forms.tutor-subscription-waitlist (151μs)
    • composing: components.forms.tutor-subscription-waitlist (47μs)
    • creating: components.forms.tutor-subscription-join (90μs)
    • composing: components.forms.tutor-subscription-join (37μs)
    • creating: components.forms.tutor-support (74μs)
    • composing: components.forms.tutor-support (37μs)
    • 315 x Illuminate\Cache\Events\CacheHit (13.37%)
      61.75ms
      25 x Illuminate\Database\Events\StatementPrepared (12.21%)
      56.39ms
      13 x Illuminate\Cache\Events\KeyWritten (9.74%)
      45.01ms
      25 x Illuminate\Database\Events\QueryExecuted (9.28%)
      42.89ms
      13 x Illuminate\Cache\Events\CacheMissed (2.03%)
      9.39ms
      1 x Illuminate\Foundation\Events\LocaleUpdated (0.95%)
      4.38ms
      7 x Illuminate\Log\Events\MessageLogged (0.69%)
      3.21ms
      1 x creating: homework.show (0.67%)
      3.09ms
      1 x eloquent.booting: App\Models\SubjectCat (0.48%)
      2.23ms
      1 x creating: components.breadcrumbs (0.34%)
      1.57ms
      2 x Illuminate\Database\Events\ConnectionEstablished (0.32%)
      1.48ms
      1 x Illuminate\Routing\Events\Routing (0.23%)
      1.08ms
      1 x eloquent.booting: App\Models\User\TutorAttributes\TutorDegree (0.21%)
      966μs
      1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.19%)
      883μs
      12 x eloquent.retrieved: App\Models\SubjectCat (0.18%)
      845μs
      1 x Illuminate\Routing\Events\RouteMatched (0.11%)
      500μs
      1 x creating: components.canonical (0.1%)
      441μs
      1 x creating: site.layouts.app (0.07%)
      334μs
      14 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.07%)
      329μs
      1 x eloquent.booting: App\Models\User\Tutor (0.07%)
      312μs
      1 x creating: site.headers.header (0.06%)
      279μs
      7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
      226μs
      1 x composing: homework.show (0.05%)
      208μs
      1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
      187μs
      3 x eloquent.retrieved: App\Models\User\Tutor (0.04%)
      183μs
      2 x eloquent.retrieved: App\Models\Subject (0.04%)
      179μs
      1 x creating: components.forms.contact-us (0.04%)
      178μs
      1 x creating: components.open-graph (0.04%)
      171μs
      1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.03%)
      156μs
      1 x creating: components.forms.tutor-subscription-waitlist (0.03%)
      151μs
      1 x composing: components.canonical (0.03%)
      137μs
      1 x composing: components.breadcrumbs (0.03%)
      122μs
      1 x eloquent.booted: App\Models\User\Tutor (0.03%)
      120μs
      1 x eloquent.booting: App\Models\Subject (0.03%)
      118μs
      1 x creating: components.forms.get-started (0.02%)
      112μs
      1 x composing: components.forms.contact-us (0.02%)
      95μs
      1 x creating: components.forms.tutor-subscription-join (0.02%)
      90μs
      1 x creating: components.forms.free-tool-download (0.02%)
      78μs
      1 x creating: components.forms.claim-free-worksheet (0.02%)
      76μs
      1 x creating: components.forms.tutor-support (0.02%)
      74μs
      1 x composing: components.footer (0.01%)
      62μs
      1 x creating: components.footer (0.01%)
      60μs
      1 x composing: site.headers.header (0.01%)
      53μs
      1 x composing: components.open-graph (0.01%)
      53μs
      1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
      47μs
      1 x eloquent.booted: App\Models\User\TutorAttributes\TutorDegree (0.01%)
      46μs
      1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
      44μs
      1 x eloquent.booted: App\Models\SubjectCat (0.01%)
      44μs
      1 x composing: components.forms.get-started (0.01%)
      43μs
      1 x eloquent.booted: App\Models\Subject (0.01%)
      42μs
      1 x composing: components.forms.free-tool-download (0.01%)
      38μs
      1 x composing: components.forms.claim-free-worksheet (0.01%)
      37μs
      1 x composing: components.forms.tutor-subscription-join (0.01%)
      37μs
      1 x composing: components.forms.tutor-support (0.01%)
      37μs
      1 x composing: site.layouts.app (0%)
      16μ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
    25 statements were executed, 5 of which were duplicates, 20 unique. Show only duplicated61.49ms
    • 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` = '13324' limit 1
      9.83mstwenty4_siteHomeworkLibraryController.php#97
      Bindings
      • 0: published
      • 1: 0
      • 2: 13324
      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 (7)
      1.06mstwenty4_siteHomeworkLibraryController.php#97
      Backtrace
      • 21. app/Http/Controllers/HomeworkLibraryController.php:97
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `solutionslibrary_files` where `solutionslibrary_files`.`solutionlib_id` in (13324)
      1.1mstwenty4_siteHomeworkLibraryController.php#97
      Backtrace
      • 21. app/Http/Controllers/HomeworkLibraryController.php:97
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `subject_cats` where `subject_cats`.`id` = 1 limit 1
      1.05mstwenty4_siteHomeworkLibrary.php#201
      Bindings
      • 0: 1
      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
    • Connection Establishedtwenty4_siteHomeworkLibraryController.php#124
      Backtrace
      • 13. app/Http/Controllers/HomeworkLibraryController.php:124
      • 14. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 15. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
      • 17. app/Http/Controllers/HomeworkLibraryController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `users` where `disable_profile` = 0 and `picture` != '' and `solutionrequestQualified` = 1 and `is_suspended` = 0 and `is_deactivated` = 0 and `status` != '' and `status` = 'tutor' order by `completed_requests` desc limit 3
      16.22mstwenty4_siteHomeworkLibraryController.php#128
      Bindings
      • 0: 0
      • 1: 
      • 2: 1
      • 3: 0
      • 4: 0
      • 5: 
      • 6: tutor
      Backtrace
      • 14. app/Http/Controllers/HomeworkLibraryController.php:128
      • 15. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 16. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
      • 18. app/Http/Controllers/HomeworkLibraryController.php:136
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `tutor_degrees` where `tutor_degrees`.`tutor_id` = 6002 and `tutor_degrees`.`tutor_id` is not null order by `year` desc limit 1
      1.26mstwenty4_siteTutor.php#361
      Bindings
      • 0: 6002
      Backtrace
      • 18. app/Models/User/Tutor.php:361
      • 19. app/Transformers/Tutor/TutorTransformer.php:72
      • 22. vendor/league/fractal/src/TransformerAbstract.php:128
      • 23. vendor/league/fractal/src/TransformerAbstract.php:107
      • 24. vendor/league/fractal/src/Scope.php:383
    • select * from `tutor_degrees` where `tutor_degrees`.`tutor_id` = 2821 and `tutor_degrees`.`tutor_id` is not null order by `year` desc limit 1
      1.06mstwenty4_siteTutor.php#361
      Bindings
      • 0: 2821
      Backtrace
      • 18. app/Models/User/Tutor.php:361
      • 19. app/Transformers/Tutor/TutorTransformer.php:72
      • 22. vendor/league/fractal/src/TransformerAbstract.php:128
      • 23. vendor/league/fractal/src/TransformerAbstract.php:107
      • 24. vendor/league/fractal/src/Scope.php:383
    • select * from `tutor_degrees` where `tutor_degrees`.`tutor_id` = 6531 and `tutor_degrees`.`tutor_id` is not null order by `year` desc limit 1
      1.03mstwenty4_siteTutor.php#361
      Bindings
      • 0: 6531
      Backtrace
      • 18. app/Models/User/Tutor.php:361
      • 19. app/Transformers/Tutor/TutorTransformer.php:72
      • 22. vendor/league/fractal/src/TransformerAbstract.php:128
      • 23. vendor/league/fractal/src/TransformerAbstract.php:107
      • 24. vendor/league/fractal/src/Scope.php:383
    • select * from `solutionslibrary` where `id` <> 13324 and `subject` = 7 and `status` = 'published' and `price` > 0 order by RAND() limit 6
      10.92mstwenty4_siteHomeworkLibraryRepository.php#30
      Bindings
      • 0: 13324
      • 1: 7
      • 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 (7)
      970μ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` = 13324 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
      990μstwenty4_siteHomeworkLibrary.php#260
      Bindings
      • 0: 13324
      • 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` = 13324 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
      1mstwenty4_siteHomeworkLibrary.php#260
      Bindings
      • 0: 13324
      • 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` = 13324 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
      910μstwenty4_siteHomeworkLibrary.php#260
      Bindings
      • 0: 13324
      • 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 count(*) as aggregate from `users` where `disable_profile` = 0 and `picture` != '' and `solutionrequestQualified` = 1 and `is_suspended` = 0 and `is_deactivated` = 0 and `status` != '' and `status` = 'tutor'
      990μstwenty4_siteTutor.php#479
      Bindings
      • 0: 0
      • 1: 
      • 2: 1
      • 3: 0
      • 4: 0
      • 5: 
      • 6: tutor
      Backtrace
      • 15. app/Models/User/Tutor.php:479
      • 16. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 17. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
      • 19. app/Models/User/Tutor.php:480
      • 20. app/Http/Controllers/HomeworkLibraryController.php:169
    • select * from `subject_cats` where `subject_cats`.`id` = 1 limit 1
      1.04mstwenty4_siteHomeworkLibrary.php#201
      Bindings
      • 0: 1
      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.21mstwenty4_siteSubject.php#100
      Bindings
      • 0: 1
      Backtrace
      • 18. app/Models/Subject.php:100
      • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
      • 22. app/Models/Subject.php:101
      • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
    • select * from `subject_cats` where `subject_cats`.`id` = 3 limit 1
      1.24mstwenty4_siteSubject.php#100
      Bindings
      • 0: 3
      Backtrace
      • 18. app/Models/Subject.php:100
      • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
      • 22. app/Models/Subject.php:101
      • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
    • select * from `subject_cats` where `subject_cats`.`id` = 4 limit 1
      2.01mstwenty4_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.03mstwenty4_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.2mstwenty4_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
      910μstwenty4_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.14mstwenty4_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.19mstwenty4_siteSubject.php#100
      Bindings
      • 0: 34
      Backtrace
      • 18. app/Models/Subject.php:100
      • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
      • 22. app/Models/Subject.php:101
      • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
    • select * from `subject_cats` where `subject_cats`.`id` = 31 limit 1
      1.17mstwenty4_siteSubject.php#100
      Bindings
      • 0: 31
      Backtrace
      • 18. app/Models/Subject.php:100
      • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
      • 22. app/Models/Subject.php:101
      • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
    • select * from `subject_cats` where `subject_cats`.`id` = 36 limit 1
      960μstwenty4_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
    14HomeworkLibraryFile.php
    App\Models\SubjectCat
    12SubjectCat.php
    App\Models\HomeworkLibrary\HomeworkLibrary
    7HomeworkLibrary.php
    App\Models\User\Tutor
    3Tutor.php
    App\Models\Subject
    2Subject.php
        _token
        Jcj5gS8QJyD70gRkdEh0SXpwgy6JkXYPZ2IEebwY
        utm_source
        direct
        redirectUrl
        /college-homework-library/Mathematics/General-Statistics/13324
        _previous
        array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Mathematics/Gen...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /college-homework-library/Mathematics/General-Statistics/13324
        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-67f8303d-68d9763942fae0bc194fc82c" ] "host" => array:1 [ 0 => "staging.dev.24houranswers.com" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-forwarded-for" => array:1 [ 0 => "3.133.91.217" ] "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 => "Thu, 10 Apr 2025 20:55:25 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1tYVdwTCtNSUJMMGYvNlVQNmIrS0E9PSIsInZhbHVlIjoiZjBnK0k2MGZobDlUNzIyVXpOR21TemZzakVCaTBPc2dMa21yQWFnZFhtYkkzS0g1WkNnNEw0dFZxRnIvSmtjYTRPT0IxMG9LUHdKOHRkaFNRbFViR253UHlyU1VCNUNFQmJ0NUswVGhRaVpBS3AzWGw4akhqV2VFV0ZER3huSEYiLCJtYWMiOiIyZWYzN2I3YTQ0Y2RmODQyY2Y3ODY0OGRjY2YyOTQ4ZTg4ZmNjZTk4MGJkOWViZDc0OWY5NTViOGQyNDIxNGIwIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 22:55:25 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6Im1tYVdwTCtNSUJMMGYvNlVQNmIrS0E9PSIsInZhbHVlIjoiZjBnK0k2MGZobDlUNzIyVXpOR21TemZzakVCaTBPc2dMa21yQWFnZFhtYkkzS0g1WkNnNEw0dFZxRnIvSmtjYTRPT0IxM" 1 => "24houranswers_session=eyJpdiI6InpSTmZSR2gvcVdhV3E0d0RnMlM5WkE9PSIsInZhbHVlIjoiZHBDNVY3NllKREt5cFlrZFhxNXZvV1VQUFVZbjEyNDdjcWJ5ZG5yM3VCL0lYUlZDVU96cTFBeFgyMUlVbTMrSEpwUFNtOFdaV014a2FBYWNSVmFISnFhdXVtWWxGUlJsVHlsbXROaGtlYm4rRG5LZEJDK0c5U1JzWlRGRjRxYmgiLCJtYWMiOiI5NzM3ODhkMGQ4ZmVhZGEzMGU3NDhlZWVkYWExMTJmYzk0ODI0NzU2YzIyZGQxZDI1MDg0NjBjOWE1NTZmNTk4IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 22:55:25 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6InpSTmZSR2gvcVdhV3E0d0RnMlM5WkE9PSIsInZhbHVlIjoiZHBDNVY3NllKREt5cFlrZFhxNXZvV1VQUFVZbjEyNDdjcWJ5ZG5yM3VCL0lYUlZDVU96cTFBeFgyMUlVbT" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1tYVdwTCtNSUJMMGYvNlVQNmIrS0E9PSIsInZhbHVlIjoiZjBnK0k2MGZobDlUNzIyVXpOR21TemZzakVCaTBPc2dMa21yQWFnZFhtYkkzS0g1WkNnNEw0dFZxRnIvSmtjYTRPT0IxMG9LUHdKOHRkaFNRbFViR253UHlyU1VCNUNFQmJ0NUswVGhRaVpBS3AzWGw4akhqV2VFV0ZER3huSEYiLCJtYWMiOiIyZWYzN2I3YTQ0Y2RmODQyY2Y3ODY0OGRjY2YyOTQ4ZTg4ZmNjZTk4MGJkOWViZDc0OWY5NTViOGQyNDIxNGIwIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 22:55:25 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6Im1tYVdwTCtNSUJMMGYvNlVQNmIrS0E9PSIsInZhbHVlIjoiZjBnK0k2MGZobDlUNzIyVXpOR21TemZzakVCaTBPc2dMa21yQWFnZFhtYkkzS0g1WkNnNEw0dFZxRnIvSmtjYTRPT0IxM" 1 => "24houranswers_session=eyJpdiI6InpSTmZSR2gvcVdhV3E0d0RnMlM5WkE9PSIsInZhbHVlIjoiZHBDNVY3NllKREt5cFlrZFhxNXZvV1VQUFVZbjEyNDdjcWJ5ZG5yM3VCL0lYUlZDVU96cTFBeFgyMUlVbTMrSEpwUFNtOFdaV014a2FBYWNSVmFISnFhdXVtWWxGUlJsVHlsbXROaGtlYm4rRG5LZEJDK0c5U1JzWlRGRjRxYmgiLCJtYWMiOiI5NzM3ODhkMGQ4ZmVhZGEzMGU3NDhlZWVkYWExMTJmYzk0ODI0NzU2YzIyZGQxZDI1MDg0NjBjOWE1NTZmNTk4IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 22:55:25 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6InpSTmZSR2gvcVdhV3E0d0RnMlM5WkE9PSIsInZhbHVlIjoiZHBDNVY3NllKREt5cFlrZFhxNXZvV1VQUFVZbjEyNDdjcWJ5ZG5yM3VCL0lYUlZDVU96cTFBeFgyMUlVbT" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "Jcj5gS8QJyD70gRkdEh0SXpwgy6JkXYPZ2IEebwY" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Mathematics/General-Statistics/13324" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Mathematics/General-Statistics/13324" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]