Question
Use the bank database you created to perform the following
1. Write a query that returns the account ID for each nonbusiness customer.cust_type_cd =' 'I') along with the customer's federal ID customer.fed_id). Run the query using MySQL Workbench and R.
2. Now modify the same query to add the name of the product on which the account is based (product.name).
3. Construct a query that finds all employees whose supervisor is assigned to a different department. Retrieve the employees' ID, first name, and last name.
4. Write a query that returns all product names along with the accounts based on that product (use the product cd column in the account table to link to the product table). Include all products, even if no accounts have been opened for that product.
5. Outer-join the account table to both the individual and business tables (via the account. cust id column) such that the result set contains one row per account.
Columns to include are account.account_id, account.product_cd, individual.fname individual.Iname, and business.name. Run query in both MySQL Workbench and R
6. Write a compound query that finds the first and last names of all individual customers along with the first and last names of all employees sorted in descending order by first name and last name
7. Write a query that returns the 17th through 25th characters of the string 'Please find the substring in this string'.
8. Write a query to return just the month portion of the current date
9. Find the total available balance by product and branch where there is more than one account per product and branch. Order the results by total balance (highest to lowest).
10. Construct a query against the account table that uses a filter condition with a subquery against the product table to find all loan accounts product.product type cd = 'LOAN'). Retrieve the account ID, product code, customer ID, and available balance.
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.

-- 1.
SELECT
    A.account_id, C.fed_id
FROM
    Bank.customer C
       INNER JOIN
    Bank.account A ON C.cust_id = A.cust_id
WHERE
    C.cust_type_cd="I";
   
   
-- 2.   
SELECT
    A.account_id, C.fed_id, P.name
FROM
    Bank.customer C
       INNER JOIN
    Bank.account A ON C.cust
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_1_5.sql
solution_6_10.sql
sol1_5.R
Purchase Solution
$30.00 $15
Google Pay
Amazon
Paypal
Mastercard
Visacard
Discover
Amex
View Available Computer Science Tutors 529 tutors matched
Ionut
(ionut)
Hi! MSc Applied Informatics & Computer Science Engineer. Practical experience in many CS & IT branches.Research work & homework
5/5 (5,654+ sessions)
2 hours avg response
Leo
(Leo)
Hi! I have been a professor in New York and taught in a math department and in an applied math department.
4.9/5 (5,652+ sessions)
2 hours avg response
Pranay
(math1983)
Ph.D. in mathematics and working as an Assistant Professor in University. I can provide help in mathematics, statistics and allied areas.
4.6/5 (5,512+ sessions)
1 hour avg response

Similar Homework Solutions

8.1.0PHP Version380msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (231ms)time
    • Application (149ms)time
    • 1 x Booting (60.87%)
      231ms
      1 x Application (39.13%)
      149ms
      • Illuminate\Routing\Events\Routing (908μs)
      • Illuminate\Routing\Events\RouteMatched (355μs)
      • Illuminate\Foundation\Events\LocaleUpdated (3.98ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (173μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (143μs)
      • Illuminate\Database\Events\ConnectionEstablished (786μs)
      • Illuminate\Database\Events\StatementPrepared (27.98ms)
      • Illuminate\Database\Events\QueryExecuted (955μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (100μs)
      • eloquent.booting: App\Models\Subject (93μs)
      • eloquent.booted: App\Models\Subject (42μs)
      • Illuminate\Database\Events\StatementPrepared (1.75ms)
      • Illuminate\Database\Events\QueryExecuted (788μs)
      • eloquent.retrieved: App\Models\Subject (87μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (96μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (39μs)
      • Illuminate\Database\Events\StatementPrepared (575μs)
      • Illuminate\Database\Events\QueryExecuted (658μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (60μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (13μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (9μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (69μ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 (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.booting: App\Models\SubjectCat (404μs)
      • eloquent.booted: App\Models\SubjectCat (38μs)
      • Illuminate\Database\Events\StatementPrepared (576μs)
      • Illuminate\Database\Events\QueryExecuted (1.12ms)
      • eloquent.retrieved: App\Models\SubjectCat (73μs)
      • Illuminate\Cache\Events\CacheHit (11.25ms)
      • Illuminate\Cache\Events\CacheMissed (765μs)
      • Illuminate\Database\Events\StatementPrepared (887μs)
      • Illuminate\Database\Events\QueryExecuted (2.73ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (72μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (14μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • Illuminate\Database\Events\StatementPrepared (682μs)
      • Illuminate\Database\Events\QueryExecuted (731μs)
      • eloquent.retrieved: App\Models\Subject (92μs)
      • Illuminate\Cache\Events\KeyWritten (993μs)
      • Illuminate\Database\Events\StatementPrepared (1.46ms)
      • Illuminate\Database\Events\QueryExecuted (736μs)
      • Illuminate\Database\Events\StatementPrepared (606μs)
      • Illuminate\Database\Events\QueryExecuted (654μs)
      • Illuminate\Database\Events\StatementPrepared (538μs)
      • Illuminate\Database\Events\QueryExecuted (631μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (36μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (12μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (7μs)
      • Illuminate\Cache\Events\CacheHit (774μs)
      • creating: homework.show (271μs)
      • composing: homework.show (116μs)
      • creating: components.breadcrumbs (244μs)
      • composing: components.breadcrumbs (115μs)
      • Illuminate\Database\Events\StatementPrepared (989μs)
      • Illuminate\Database\Events\QueryExecuted (791μs)
      • eloquent.retrieved: App\Models\SubjectCat (143μs)
      • Illuminate\Cache\Events\CacheMissed (4.54ms)
      • Illuminate\Database\Events\StatementPrepared (636μs)
      • Illuminate\Database\Events\QueryExecuted (766μs)
      • eloquent.retrieved: App\Models\SubjectCat (53μs)
      • Illuminate\Cache\Events\KeyWritten (285μs)
      • Illuminate\Cache\Events\CacheHit (188μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (181μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheMissed (195μs)
      • Illuminate\Database\Events\StatementPrepared (538μs)
      • Illuminate\Database\Events\QueryExecuted (780μs)
      • eloquent.retrieved: App\Models\SubjectCat (53μs)
      • Illuminate\Cache\Events\KeyWritten (276μs)
      • Illuminate\Cache\Events\CacheHit (175μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheMissed (215μs)
      • Illuminate\Database\Events\StatementPrepared (546μs)
      • Illuminate\Database\Events\QueryExecuted (760μs)
      • eloquent.retrieved: App\Models\SubjectCat (50μs)
      • Illuminate\Cache\Events\KeyWritten (243μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheMissed (176μs)
      • Illuminate\Database\Events\StatementPrepared (634μs)
      • Illuminate\Database\Events\QueryExecuted (822μs)
      • eloquent.retrieved: App\Models\SubjectCat (58μs)
      • Illuminate\Cache\Events\KeyWritten (232μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (318μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (258μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (173μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheMissed (175μs)
      • Illuminate\Database\Events\StatementPrepared (613μs)
      • Illuminate\Database\Events\QueryExecuted (733μs)
      • eloquent.retrieved: App\Models\SubjectCat (51μs)
      • Illuminate\Cache\Events\KeyWritten (213μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheMissed (202μs)
      • Illuminate\Database\Events\StatementPrepared (723μs)
      • Illuminate\Database\Events\QueryExecuted (842μs)
      • eloquent.retrieved: App\Models\SubjectCat (52μs)
      • Illuminate\Cache\Events\KeyWritten (262μs)
      • Illuminate\Cache\Events\CacheHit (203μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (261μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (214μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (570μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (179μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (91μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (92μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheMissed (163μs)
      • Illuminate\Database\Events\StatementPrepared (642μs)
      • Illuminate\Database\Events\QueryExecuted (713μs)
      • eloquent.retrieved: App\Models\SubjectCat (50μs)
      • Illuminate\Cache\Events\KeyWritten (205μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (306μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (91μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (89μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (91μs)
      • Illuminate\Cache\Events\CacheHit (158μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (230μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (91μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (92μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (92μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (90μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (293μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheMissed (190μs)
      • Illuminate\Database\Events\StatementPrepared (1.7ms)
      • Illuminate\Database\Events\QueryExecuted (838μs)
      • eloquent.retrieved: App\Models\SubjectCat (52μs)
      • Illuminate\Cache\Events\KeyWritten (242μs)
      • Illuminate\Cache\Events\CacheHit (159μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (141μs)
      • Illuminate\Cache\Events\CacheHit (162μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (174μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (650μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (92μs)
      • Illuminate\Cache\Events\CacheHit (198μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (291μs)
      • Illuminate\Cache\Events\CacheHit (205μs)
      • Illuminate\Cache\Events\CacheHit (447μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (93μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (201μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (189μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (95μs)
      • Illuminate\Cache\Events\CacheHit (199μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (91μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (89μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheMissed (183μs)
      • Illuminate\Database\Events\StatementPrepared (743μs)
      • Illuminate\Database\Events\QueryExecuted (762μs)
      • eloquent.retrieved: App\Models\SubjectCat (62μs)
      • Illuminate\Cache\Events\KeyWritten (242μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (176μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (242μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (94μs)
      • creating: site.layouts.app (452μs)
      • composing: site.layouts.app (18μs)
      • creating: components.canonical (414μs)
      • composing: components.canonical (79μs)
      • creating: components.open-graph (148μs)
      • composing: components.open-graph (61μs)
      • creating: site.headers.header (221μs)
      • composing: site.headers.header (48μs)
      • Illuminate\Cache\Events\CacheHit (1.86ms)
      • creating: components.footer (74μs)
      • composing: components.footer (72μs)
      • Illuminate\Cache\Events\CacheHit (621μs)
      • Illuminate\Cache\Events\CacheMissed (304μs)
      • Illuminate\Database\Events\StatementPrepared (5.72ms)
      • Illuminate\Database\Events\QueryExecuted (1.24ms)
      • eloquent.retrieved: App\Models\SubjectCat (82μs)
      • Illuminate\Cache\Events\KeyWritten (318μs)
      • Illuminate\Cache\Events\CacheHit (295μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (210μs)
      • Illuminate\Cache\Events\CacheHit (400μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (272μs)
      • Illuminate\Cache\Events\CacheHit (163μs)
      • Illuminate\Cache\Events\CacheHit (233μs)
      • creating: components.forms.contact-us (300μs)
      • composing: components.forms.contact-us (115μs)
      • creating: components.forms.get-started (124μs)
      • composing: components.forms.get-started (44μs)
      • creating: components.forms.free-tool-download (81μs)
      • composing: components.forms.free-tool-download (39μs)
      • creating: components.forms.claim-free-worksheet (152μs)
      • composing: components.forms.claim-free-worksheet (48μs)
      • creating: components.forms.tutor-subscription-waitlist (81μs)
      • composing: components.forms.tutor-subscription-waitlist (39μs)
      • creating: components.forms.tutor-subscription-join (75μs)
      • composing: components.forms.tutor-subscription-join (38μs)
      • creating: components.forms.tutor-support (73μs)
      • composing: components.forms.tutor-support (36μs)
      • 311 x Illuminate\Cache\Events\CacheHit (14.51%)
        55.08ms
        20 x Illuminate\Database\Events\StatementPrepared (12.79%)
        48.55ms
        20 x Illuminate\Database\Events\QueryExecuted (4.76%)
        18.06ms
        11 x Illuminate\Cache\Events\CacheMissed (1.87%)
        7.11ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (1.05%)
        3.98ms
        11 x Illuminate\Cache\Events\KeyWritten (0.92%)
        3.51ms
        1 x Illuminate\Routing\Events\Routing (0.24%)
        908μs
        1 x Illuminate\Database\Events\ConnectionEstablished (0.21%)
        786μs
        12 x eloquent.retrieved: App\Models\SubjectCat (0.21%)
        779μs
        1 x creating: site.layouts.app (0.12%)
        452μs
        1 x creating: components.canonical (0.11%)
        414μs
        1 x eloquent.booting: App\Models\SubjectCat (0.11%)
        404μs
        1 x Illuminate\Routing\Events\RouteMatched (0.09%)
        355μs
        1 x creating: components.forms.contact-us (0.08%)
        300μs
        1 x creating: homework.show (0.07%)
        271μs
        1 x creating: components.breadcrumbs (0.06%)
        244μs
        13 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.06%)
        239μs
        1 x creating: site.headers.header (0.06%)
        221μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.06%)
        212μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        179μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        173μs
        1 x creating: components.forms.claim-free-worksheet (0.04%)
        152μs
        1 x creating: components.open-graph (0.04%)
        148μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        143μs
        1 x creating: components.forms.get-started (0.03%)
        124μs
        1 x composing: homework.show (0.03%)
        116μs
        1 x composing: components.breadcrumbs (0.03%)
        115μs
        1 x composing: components.forms.contact-us (0.03%)
        115μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.03%)
        96μs
        1 x eloquent.booting: App\Models\Subject (0.02%)
        93μs
        1 x creating: components.forms.free-tool-download (0.02%)
        81μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.02%)
        81μs
        1 x composing: components.canonical (0.02%)
        79μs
        1 x creating: components.forms.tutor-subscription-join (0.02%)
        75μs
        1 x creating: components.footer (0.02%)
        74μs
        1 x creating: components.forms.tutor-support (0.02%)
        73μs
        1 x composing: components.footer (0.02%)
        72μs
        1 x composing: components.open-graph (0.02%)
        61μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        48μs
        1 x composing: site.headers.header (0.01%)
        48μs
        1 x composing: components.forms.get-started (0.01%)
        44μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        42μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        39μs
        1 x composing: components.forms.free-tool-download (0.01%)
        39μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        39μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        38μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        38μs
        1 x composing: components.forms.tutor-support (0.01%)
        36μs
        1 x composing: site.layouts.app (0%)
        18μs
      14 templates were rendered
      • 1x homework.showshow.blade.phpblade
      • 1x components.breadcrumbsbreadcrumbs.blade.phpblade
      • 1x site.layouts.appapp.blade.phpblade
      • 1x components.canonicalcanonical.blade.phpblade
      • 1x components.open-graphopen-graph.blade.phpblade
      • 1x site.headers.headerheader.blade.phpblade
      • 1x components.footerfooter.blade.phpblade
      • 1x components.forms.contact-uscontact-us.blade.phpblade
      • 1x components.forms.get-startedget-started.blade.phpblade
      • 1x components.forms.free-tool-downloadfree-tool-download.blade.phpblade
      • 1x components.forms.claim-free-worksheetclaim-free-worksheet.blade.phpblade
      • 1x components.forms.tutor-subscription-waitlisttutor-subscription-waitlist.blade.phpblade
      • 1x components.forms.tutor-subscription-jointutor-subscription-join.blade.phpblade
      • 1x components.forms.tutor-supporttutor-support.blade.phpblade
      uri
      GET college-homework-library/{category}/{subject}/{id}
      middleware
      web, utm.parameters
      controller
      App\Http\Controllers\HomeworkLibraryController@show
      namespace
      where
      as
      homework.show
      file
      app/Http/Controllers/HomeworkLibraryController.php:79-176
      20 statements were executed, 5 of which were duplicates, 15 unique. Show only duplicated54.52ms
      • 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` = '40823' limit 1
        28.21mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 40823
        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 (72)
        910μ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 (40823)
        810μ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` = 3 limit 1
        1.18mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 3
        Backtrace
        • 20. app/Models/HomeworkLibrary/HomeworkLibrary.php:201
        • 26. app/Http/Controllers/HomeworkLibraryController.php:105
        • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `solutionslibrary` where `id` <> 40823 and `subject` = 72 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        2.99mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 40823
        • 1: 72
        • 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 (72)
        930μ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` = 40823 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        840μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 40823
        • 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` = 40823 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        790μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 40823
        • 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` = 40823 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        760μstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 40823
        • 1: solution
        Backtrace
        • 15. app/Models/HomeworkLibrary/HomeworkLibrary.php:260
        • 16. app/Transformers/HomeworkLibrary/HomeworkLibraryTransformer.php:80
        • 19. vendor/league/fractal/src/TransformerAbstract.php:128
        • 20. vendor/league/fractal/src/TransformerAbstract.php:107
        • 21. vendor/league/fractal/src/Scope.php:383
      • select * from `subject_cats` where `subject_cats`.`id` = 3 limit 1
        1.01mstwenty4_siteHomeworkLibrary.php#201
        Bindings
        • 0: 3
        Backtrace
        • 20. app/Models/HomeworkLibrary/HomeworkLibrary.php:201
        • 32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 33. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 34. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
        • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `subject_cats` where `subject_cats`.`id` = 1 limit 1
        950μstwenty4_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
        870μstwenty4_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
        870μstwenty4_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
        990μstwenty4_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
        950μstwenty4_siteSubject.php#100
        Bindings
        • 0: 33
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 11 limit 1
        1.1mstwenty4_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
        970μstwenty4_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
        2.13mstwenty4_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.04mstwenty4_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
        6.22mstwenty4_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
      13HomeworkLibraryFile.php
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\Subject
      2Subject.php
          _token
          EtajQsy4ixYlUoX3C5eZWpcdUK4dgT0xLDenPdj6
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/Programming-Dynamic-Linear-Non-linear-etc/40823
          _previous
          array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Scienc...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /college-homework-library/Computer-Science/Programming-Dynamic-Linear-Non-linear-etc/40823
          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-67f8ec9f-4d12ad8e13c6e9b927ff93e6" ] "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.191.187.115" ] "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 => "Fri, 11 Apr 2025 10:19:11 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVOTTNkTjBTUm1qRG1heFlUbE1Rd2c9PSIsInZhbHVlIjoidmZZcGJYNHBUVFFWaUVvY1FrWjdDb1V0SlIzZFcxbC9UZHRBR1NYcDlYcGFTUEorUTVSWW4yaTJQVnZRQjE0YzZSYUNaRHBFeXNEM2VvSFpTMVdpUkptZzNpK1EzQ0Vya0hhaUhKdEhjOUU3RFZmL3lONFBmN1h1ZThGZjZQamciLCJtYWMiOiI3N2Y2YmExODVkZmFhODY4ZTQwYzU3MTZhZjU5MzAyYzA0ODY3ODM4ZmZhYmM5ODQyOTA0MTM5MmFjYmZjOWRkIiwidGFnIjoiIn0%3D; expires=Fri, 11 Apr 2025 12:19:12 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6IlVOTTNkTjBTUm1qRG1heFlUbE1Rd2c9PSIsInZhbHVlIjoidmZZcGJYNHBUVFFWaUVvY1FrWjdDb1V0SlIzZFcxbC9UZHRBR1NYcDlYcGFTUEorUTVSWW4yaTJQVnZRQjE0YzZSYUNaR" 1 => "24houranswers_session=eyJpdiI6IkxhdElxeXpzejNlc1RUbjNlcm4zcFE9PSIsInZhbHVlIjoiRVQ0VEtzOFhyOCt3S0N3NWRyd2JLdlRKUkllU05Kc21jTSswTzlVd0ZNdFBXcnZyakZGQ0NkVzE2UFAvRzlTU3VPNDh1cEcvaXpibjFibjE0QVNRdzJhMzhwd05KcHQvYjZJSG5peWxiL1VoMGtQditWMmRWaTZVN2wvSHR6K2wiLCJtYWMiOiI1Y2ZjMjM5NjIyYzYwOTQ4MjllMWVjMDJiODcwOTgwMmE0YTVlNTk1NmFjYTBkNjY1MTdhZGE5YWZmMzBjZDlmIiwidGFnIjoiIn0%3D; expires=Fri, 11 Apr 2025 12:19:12 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IkxhdElxeXpzejNlc1RUbjNlcm4zcFE9PSIsInZhbHVlIjoiRVQ0VEtzOFhyOCt3S0N3NWRyd2JLdlRKUkllU05Kc21jTSswTzlVd0ZNdFBXcnZyakZGQ0NkVzE2UFAvRz" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVOTTNkTjBTUm1qRG1heFlUbE1Rd2c9PSIsInZhbHVlIjoidmZZcGJYNHBUVFFWaUVvY1FrWjdDb1V0SlIzZFcxbC9UZHRBR1NYcDlYcGFTUEorUTVSWW4yaTJQVnZRQjE0YzZSYUNaRHBFeXNEM2VvSFpTMVdpUkptZzNpK1EzQ0Vya0hhaUhKdEhjOUU3RFZmL3lONFBmN1h1ZThGZjZQamciLCJtYWMiOiI3N2Y2YmExODVkZmFhODY4ZTQwYzU3MTZhZjU5MzAyYzA0ODY3ODM4ZmZhYmM5ODQyOTA0MTM5MmFjYmZjOWRkIiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 12:19:12 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6IlVOTTNkTjBTUm1qRG1heFlUbE1Rd2c9PSIsInZhbHVlIjoidmZZcGJYNHBUVFFWaUVvY1FrWjdDb1V0SlIzZFcxbC9UZHRBR1NYcDlYcGFTUEorUTVSWW4yaTJQVnZRQjE0YzZSYUNaR" 1 => "24houranswers_session=eyJpdiI6IkxhdElxeXpzejNlc1RUbjNlcm4zcFE9PSIsInZhbHVlIjoiRVQ0VEtzOFhyOCt3S0N3NWRyd2JLdlRKUkllU05Kc21jTSswTzlVd0ZNdFBXcnZyakZGQ0NkVzE2UFAvRzlTU3VPNDh1cEcvaXpibjFibjE0QVNRdzJhMzhwd05KcHQvYjZJSG5peWxiL1VoMGtQditWMmRWaTZVN2wvSHR6K2wiLCJtYWMiOiI1Y2ZjMjM5NjIyYzYwOTQ4MjllMWVjMDJiODcwOTgwMmE0YTVlNTk1NmFjYTBkNjY1MTdhZGE5YWZmMzBjZDlmIiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 12:19:12 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IkxhdElxeXpzejNlc1RUbjNlcm4zcFE9PSIsInZhbHVlIjoiRVQ0VEtzOFhyOCt3S0N3NWRyd2JLdlRKUkllU05Kc21jTSswTzlVd0ZNdFBXcnZyakZGQ0NkVzE2UFAvRz" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "EtajQsy4ixYlUoX3C5eZWpcdUK4dgT0xLDenPdj6" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/Programming-Dynamic-Linear-Non-linear-etc/40823" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/Programming-Dynamic-Linear-Non-linear-etc/40823" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]