Question
Introduction
An ice-cream distributor has requested your help with software to manage its fleet of ice cream delivery trucks. The delivery trucks come in autonomous and manual versions. The majority of the trucks are of the manual variety as the autopilot feature in the autonomous trucks is restricted to the vicinity of the distributor headquarters. Orders arrive online via the distributor’s website, the items are picked in the warehouse and then loaded on to the trucks for shipping to the customer.

The company’s management team explains that they need a way to monitor and communicate the delivery status of the orders between a central site and the trucks. They are interested in having an app developed so that they can assign, manage and monitor the progress of the delivery operations. Eventually the app will automatically use GPS data to match orders with retailers and automatically update the delivery status when the job is completed. As a first step, they wish to analyze data regarding truck delivery jobs and truck information to see how efficiently delivery is performing. You are required to implement (using the C programming language) a prototype management system for the trucks. Make use of techniques covered in the course material: functions, file handling, dynamic memory allocation, data structures and sorting algorithms.

The Ice-cream Trucks App Management System (ITAMS) will have 2 important files:
File 1: to record information about the trucks
File 2: to record information about the deliveries by the trucks.

The truck’s type and number are kept on file. If the truck is not autonomous the driver name will also be recorded. Each delivery (job) will have a truck number, delivery number, location zip code, date (and time) and delivery status on file. A truck can have many delivery jobs assigned to it. ITAMS should provide functions to add trucks and deliveries, view truck information, sort truck information by type, view delivery information by date, sort delivery information by location, and view delivery information by truck. Create a C program to implement the functions described below.

Note also that the program should be contained in one file only (i.e. no header files or multiple source files).


Function 1: display_menu

When the application is started, use this function to print a list of options to the user using a numbered list. When the user selects an option, the system performs the required action, and returns to the menu waiting for the user to select another option. Include an option to exit the system. Your main menu system should resemble the following:
1. Add a Truck
2. Add a Delivery
3. View all Truck information
4. Sort Truck information by driver name and type
5. View Delivery information by date and time
6. Sort Delivery information location zip code
7. Sort Delivery information by date and time due
8. Set Delivery as completed
9. View Delivery information by Truck
10. Save and Exit s

Function 2: load_data
This function is automatically called when the program is started. It reads truck and delivery information from files. If the files do not exist, notify the user, create the files and display the main menu. Once a file is open, data is read into an array of structs by dynamically creating sufficient memory for each entry read from the file.
Define a struct to represent the information for a truck, containing the following fields:
• Number (int) • Type (int or enum) • Driver Name (char[])
Define a struct to represent the information for a delivery, containing the following fields:
• Truck number (int) • Delivery Number (int) • Location Zip Code (char([]) • Delivery date/time (appropriate type) • Delivery Completed Flag (Boolean or int)

Function 3: add_new_truck
When the user selects the “add new truck” menu item, prompt them for the data for the new truck. Append the new truck to the array of current trucks and notify the user that the new record has been added successfully.

Function 4: add_new_delivery
When the user selects the “add new delivery” menu item, prompt them for the new delivery information. Append the new delivery to the array of current deliveries and notify the user that the new record has been added successfully.

Function 5: view_trucks
When the user selects the “view trucks” option, this function prints a list of all truck information on record. Make sure that the truck information is in a report with headers, not simply a list of raw information.

Function 6: sort_trucks
Give the user the option to sort trucks by name and/or type. Store the sorted information and notify the user of the name of the file. Make a copy of the original array of trucks to perform the sorting function. Make sure that the truck information is in a report with headers, not simply a list of raw information.

Function 7: view_delivery_information_time_due
When the user selects the “View delivery information by date and time due” menu option, this function prompts the user for a delivery number. It then displays the delivery status, date/time due or completed (in a human-readable format), the truck number and the location zip code. Make sure that the information is in a report with headers, not simply a list of raw information.

Function 8: sort_delivery_information
When the user selects the menu items to “sort delivery information “(either by location zip code or by date time due), this function will sort accordingly and display all deliveries. Store the sorted information and notify the user of the name of the file. Make a copy of the original array of deliveries to perform the sorting function. Make sure that the delivery information is in a report with headers, not simply a list of raw information.

Function 9: set_delivery_completed
When the user selects the “Set delivery as completed” from menu options, prompt them for the delivery number. Then find the corresponding delivery, set the completion flag and update the due date and time variable to the current date and time. Store the updated information in the respective data structures. 5

Function 10: view_delivery_information_by_truck
When the user selects the “view delivery information by truck” menu option, this function displays each truck and the delivery number of the deliveries that they have in the database. Make sure that the information is in a report with headers, not simply a list of raw information.

Function 11: save_data
This function is called whenever data needs to be saved, for instance when the user chooses to exit the system. Open all data files and write out the information contained in the respective arrays.
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.

void sort_trucks()
{
int input, i, j;
Truck *trucks_new;
FILE *fp;

fopen_s(&fp, "sorted_trucks.txt", "w");

printf("What would you like to sort by? (0-names, 1-type): ");
scanf_s("%d", &input);
trucks_new = (Truck*)malloc(num_trucks*sizeof(Truck));
memcpy(trucks_new, trucks, num_trucks*sizeof(Truck));
if (input != 1 && input != 0)
{
printf("Incorrect input, going back to menu\n");
return;
}
for (i = 0; i < num_trucks - 1; i++)
for (j = 0; j < num_trucks - i - 1; j++)
if ((input == 0 && strcmp(trucks_new[j].name, trucks_new[j + 1].name) > 0) || (input == 1 && trucks_new[j].type > trucks_new[j+1].type))
{
Truck truck = trucks_new[j];
trucks_new[j] = trucks_new[j + 1];
trucks_new[j + 1] = truck;
}
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.c
Purchase Solution
$75.00
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 Version447msRequest Duration45MBMemory UsageGET college-homework-library/{category}/{subject}/{id}Route
    • Booting (261ms)time
    • Application (185ms)time
    • 1 x Booting (58.49%)
      261ms
      1 x Application (41.51%)
      185ms
      • Illuminate\Routing\Events\Routing (1.36ms)
      • Illuminate\Routing\Events\RouteMatched (576μs)
      • Illuminate\Foundation\Events\LocaleUpdated (4.44ms)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (188μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (173μs)
      • Illuminate\Database\Events\ConnectionEstablished (1.13ms)
      • Illuminate\Database\Events\StatementPrepared (8.68ms)
      • Illuminate\Database\Events\QueryExecuted (1.13ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (89μs)
      • eloquent.booting: App\Models\Subject (54μs)
      • eloquent.booted: App\Models\Subject (39μs)
      • Illuminate\Database\Events\StatementPrepared (1.63ms)
      • Illuminate\Database\Events\QueryExecuted (1.43ms)
      • eloquent.retrieved: App\Models\Subject (114μs)
      • eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (165μs)
      • eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (45μs)
      • Illuminate\Database\Events\StatementPrepared (4.03ms)
      • Illuminate\Database\Events\QueryExecuted (1.21ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (103μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (15μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (5μs)
      • eloquent.booting: App\Models\SubjectCat (517μs)
      • eloquent.booted: App\Models\SubjectCat (45μs)
      • Illuminate\Database\Events\StatementPrepared (1.31ms)
      • Illuminate\Database\Events\QueryExecuted (1.02ms)
      • eloquent.retrieved: App\Models\SubjectCat (119μs)
      • Illuminate\Cache\Events\CacheHit (22.18ms)
      • Illuminate\Cache\Events\CacheMissed (995μs)
      • Illuminate\Database\Events\StatementPrepared (1.14ms)
      • Illuminate\Database\Events\QueryExecuted (28.97ms)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (98μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (16μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (8μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (7μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (6μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (5μs)
      • Illuminate\Database\Events\StatementPrepared (866μs)
      • Illuminate\Database\Events\QueryExecuted (1.35ms)
      • eloquent.retrieved: App\Models\Subject (107μs)
      • Illuminate\Cache\Events\KeyWritten (2.76ms)
      • Illuminate\Database\Events\StatementPrepared (1.9ms)
      • Illuminate\Database\Events\QueryExecuted (1.97ms)
      • Illuminate\Database\Events\StatementPrepared (751μs)
      • Illuminate\Database\Events\QueryExecuted (1.03ms)
      • Illuminate\Database\Events\StatementPrepared (720μs)
      • Illuminate\Database\Events\QueryExecuted (919μs)
      • eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (50μs)
      • Illuminate\Cache\Events\CacheHit (867μs)
      • creating: homework.show (277μs)
      • composing: homework.show (134μs)
      • creating: components.breadcrumbs (521μs)
      • composing: components.breadcrumbs (149μs)
      • Illuminate\Database\Events\StatementPrepared (1.19ms)
      • Illuminate\Database\Events\QueryExecuted (917μs)
      • eloquent.retrieved: App\Models\SubjectCat (252μs)
      • Illuminate\Cache\Events\CacheMissed (4.91ms)
      • Illuminate\Database\Events\StatementPrepared (644μs)
      • Illuminate\Database\Events\QueryExecuted (896μs)
      • eloquent.retrieved: App\Models\SubjectCat (69μs)
      • Illuminate\Cache\Events\KeyWritten (1.13ms)
      • Illuminate\Cache\Events\CacheHit (350μs)
      • Illuminate\Cache\Events\CacheHit (202μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheMissed (208μs)
      • Illuminate\Database\Events\StatementPrepared (753μs)
      • Illuminate\Database\Events\QueryExecuted (903μs)
      • eloquent.retrieved: App\Models\SubjectCat (61μs)
      • Illuminate\Cache\Events\KeyWritten (1.62ms)
      • Illuminate\Cache\Events\CacheHit (224μs)
      • Illuminate\Cache\Events\CacheHit (183μs)
      • Illuminate\Cache\Events\CacheHit (180μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (136μs)
      • Illuminate\Cache\Events\CacheHit (161μs)
      • Illuminate\Cache\Events\CacheMissed (147μs)
      • Illuminate\Database\Events\StatementPrepared (646μs)
      • Illuminate\Database\Events\QueryExecuted (755μs)
      • eloquent.retrieved: App\Models\SubjectCat (68μs)
      • Illuminate\Cache\Events\KeyWritten (406μs)
      • Illuminate\Cache\Events\CacheHit (185μs)
      • Illuminate\Cache\Events\CacheHit (170μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (151μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (150μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (152μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheMissed (202μs)
      • Illuminate\Database\Events\StatementPrepared (601μs)
      • Illuminate\Database\Events\QueryExecuted (895μs)
      • eloquent.retrieved: App\Models\SubjectCat (67μs)
      • Illuminate\Cache\Events\KeyWritten (305μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (165μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (140μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (329μs)
      • Illuminate\Cache\Events\CacheHit (157μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (109μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (186μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (108μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheMissed (227μs)
      • Illuminate\Database\Events\StatementPrepared (2.22ms)
      • Illuminate\Database\Events\QueryExecuted (1.12ms)
      • eloquent.retrieved: App\Models\SubjectCat (67μs)
      • Illuminate\Cache\Events\KeyWritten (1.34ms)
      • Illuminate\Cache\Events\CacheHit (239μs)
      • Illuminate\Cache\Events\CacheHit (168μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheMissed (150μs)
      • Illuminate\Database\Events\StatementPrepared (603μs)
      • Illuminate\Database\Events\QueryExecuted (857μs)
      • eloquent.retrieved: App\Models\SubjectCat (75μs)
      • Illuminate\Cache\Events\KeyWritten (288μs)
      • Illuminate\Cache\Events\CacheHit (1.25ms)
      • Illuminate\Cache\Events\CacheHit (204μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (172μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (664μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (97μs)
      • Illuminate\Cache\Events\CacheHit (280μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheMissed (199μs)
      • Illuminate\Database\Events\StatementPrepared (736μs)
      • Illuminate\Database\Events\QueryExecuted (976μs)
      • eloquent.retrieved: App\Models\SubjectCat (64μs)
      • Illuminate\Cache\Events\KeyWritten (1.58ms)
      • Illuminate\Cache\Events\CacheHit (197μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (169μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (208μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (366μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (156μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (138μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (126μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (164μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (124μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (167μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheMissed (137μs)
      • Illuminate\Database\Events\StatementPrepared (697μs)
      • Illuminate\Database\Events\QueryExecuted (873μs)
      • eloquent.retrieved: App\Models\SubjectCat (77μs)
      • Illuminate\Cache\Events\KeyWritten (355μs)
      • Illuminate\Cache\Events\CacheHit (1.35ms)
      • Illuminate\Cache\Events\CacheHit (323μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (166μs)
      • Illuminate\Cache\Events\CacheHit (121μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (137μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (714μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (145μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (146μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (142μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (96μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (98μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (116μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (155μs)
      • Illuminate\Cache\Events\CacheHit (112μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (102μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (111μs)
      • Illuminate\Cache\Events\CacheHit (125μs)
      • Illuminate\Cache\Events\CacheHit (100μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheHit (99μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (154μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (103μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (128μs)
      • Illuminate\Cache\Events\CacheHit (131μs)
      • Illuminate\Cache\Events\CacheHit (104μs)
      • Illuminate\Cache\Events\CacheHit (120μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (114μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (132μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (101μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (149μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (135μs)
      • Illuminate\Cache\Events\CacheHit (122μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (115μs)
      • Illuminate\Cache\Events\CacheMissed (218μs)
      • Illuminate\Database\Events\StatementPrepared (900μs)
      • Illuminate\Database\Events\QueryExecuted (910μs)
      • eloquent.retrieved: App\Models\SubjectCat (62μs)
      • Illuminate\Cache\Events\KeyWritten (1.27ms)
      • Illuminate\Cache\Events\CacheHit (211μs)
      • Illuminate\Cache\Events\CacheHit (178μs)
      • Illuminate\Cache\Events\CacheHit (130μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (113μs)
      • Illuminate\Cache\Events\CacheHit (144μs)
      • Illuminate\Cache\Events\CacheHit (110μs)
      • Illuminate\Cache\Events\CacheHit (134μs)
      • Illuminate\Cache\Events\CacheHit (123μs)
      • Illuminate\Cache\Events\CacheHit (133μs)
      • Illuminate\Cache\Events\CacheHit (107μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (291μs)
      • Illuminate\Cache\Events\CacheHit (153μs)
      • Illuminate\Cache\Events\CacheHit (106μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (105μs)
      • creating: site.layouts.app (379μs)
      • composing: site.layouts.app (17μs)
      • creating: components.canonical (298μs)
      • composing: components.canonical (72μs)
      • creating: components.open-graph (121μs)
      • composing: components.open-graph (48μs)
      • creating: site.headers.header (194μs)
      • composing: site.headers.header (52μs)
      • Illuminate\Cache\Events\CacheHit (1.31ms)
      • creating: components.footer (77μs)
      • composing: components.footer (87μs)
      • Illuminate\Cache\Events\CacheHit (663μs)
      • Illuminate\Cache\Events\CacheMissed (286μs)
      • Illuminate\Database\Events\StatementPrepared (922μs)
      • Illuminate\Database\Events\QueryExecuted (872μs)
      • eloquent.retrieved: App\Models\SubjectCat (77μs)
      • Illuminate\Cache\Events\KeyWritten (341μs)
      • Illuminate\Cache\Events\CacheHit (264μs)
      • Illuminate\Cache\Events\CacheHit (147μs)
      • Illuminate\Cache\Events\CacheHit (127μs)
      • Illuminate\Cache\Events\CacheHit (118μs)
      • Illuminate\Cache\Events\CacheHit (119μs)
      • Illuminate\Cache\Events\CacheHit (209μs)
      • Illuminate\Cache\Events\CacheHit (245μs)
      • Illuminate\Cache\Events\CacheHit (139μs)
      • Illuminate\Cache\Events\CacheHit (314μs)
      • Illuminate\Cache\Events\CacheHit (143μs)
      • Illuminate\Cache\Events\CacheHit (129μs)
      • Illuminate\Cache\Events\CacheHit (117μs)
      • creating: components.forms.contact-us (222μs)
      • composing: components.forms.contact-us (118μs)
      • creating: components.forms.get-started (119μs)
      • composing: components.forms.get-started (44μs)
      • creating: components.forms.free-tool-download (86μs)
      • composing: components.forms.free-tool-download (39μs)
      • creating: components.forms.claim-free-worksheet (80μs)
      • composing: components.forms.claim-free-worksheet (39μs)
      • creating: components.forms.tutor-subscription-waitlist (79μs)
      • composing: components.forms.tutor-subscription-waitlist (37μs)
      • creating: components.forms.tutor-subscription-join (77μs)
      • composing: components.forms.tutor-subscription-join (37μs)
      • creating: components.forms.tutor-support (77μs)
      • composing: components.forms.tutor-support (38μs)
      • 311 x Illuminate\Cache\Events\CacheHit (15.31%)
        68.38ms
        20 x Illuminate\Database\Events\QueryExecuted (10.97%)
        49.00ms
        20 x Illuminate\Database\Events\StatementPrepared (6.93%)
        30.95ms
        11 x Illuminate\Cache\Events\KeyWritten (2.55%)
        11.39ms
        11 x Illuminate\Cache\Events\CacheMissed (1.72%)
        7.68ms
        1 x Illuminate\Foundation\Events\LocaleUpdated (0.99%)
        4.44ms
        1 x Illuminate\Routing\Events\Routing (0.31%)
        1.36ms
        1 x Illuminate\Database\Events\ConnectionEstablished (0.25%)
        1.13ms
        12 x eloquent.retrieved: App\Models\SubjectCat (0.24%)
        1.06ms
        1 x Illuminate\Routing\Events\RouteMatched (0.13%)
        576μs
        1 x creating: components.breadcrumbs (0.12%)
        521μs
        1 x eloquent.booting: App\Models\SubjectCat (0.12%)
        517μs
        1 x creating: site.layouts.app (0.08%)
        379μs
        1 x creating: components.canonical (0.07%)
        298μs
        1 x creating: homework.show (0.06%)
        277μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibrary (0.05%)
        229μs
        1 x creating: components.forms.contact-us (0.05%)
        222μs
        2 x eloquent.retrieved: App\Models\Subject (0.05%)
        221μs
        1 x creating: site.headers.header (0.04%)
        194μs
        7 x eloquent.retrieved: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.04%)
        193μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        188μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibrary (0.04%)
        173μs
        1 x eloquent.booting: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.04%)
        165μs
        1 x composing: components.breadcrumbs (0.03%)
        149μs
        1 x composing: homework.show (0.03%)
        134μs
        1 x creating: components.open-graph (0.03%)
        121μs
        1 x creating: components.forms.get-started (0.03%)
        119μs
        1 x composing: components.forms.contact-us (0.03%)
        118μs
        1 x composing: components.footer (0.02%)
        87μs
        1 x creating: components.forms.free-tool-download (0.02%)
        86μs
        1 x creating: components.forms.claim-free-worksheet (0.02%)
        80μs
        1 x creating: components.forms.tutor-subscription-waitlist (0.02%)
        79μs
        1 x creating: components.footer (0.02%)
        77μs
        1 x creating: components.forms.tutor-subscription-join (0.02%)
        77μs
        1 x creating: components.forms.tutor-support (0.02%)
        77μs
        1 x composing: components.canonical (0.02%)
        72μs
        1 x eloquent.booting: App\Models\Subject (0.01%)
        54μs
        1 x composing: site.headers.header (0.01%)
        52μs
        1 x composing: components.open-graph (0.01%)
        48μs
        1 x eloquent.booted: App\Models\SubjectCat (0.01%)
        45μs
        1 x eloquent.booted: App\Models\HomeworkLibrary\HomeworkLibraryFile (0.01%)
        45μs
        1 x composing: components.forms.get-started (0.01%)
        44μs
        1 x eloquent.booted: App\Models\Subject (0.01%)
        39μs
        1 x composing: components.forms.free-tool-download (0.01%)
        39μs
        1 x composing: components.forms.claim-free-worksheet (0.01%)
        39μs
        1 x composing: components.forms.tutor-support (0.01%)
        38μs
        1 x composing: components.forms.tutor-subscription-join (0.01%)
        37μs
        1 x composing: components.forms.tutor-subscription-waitlist (0.01%)
        37μs
        1 x composing: site.layouts.app (0%)
        17μ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 duplicated66.01ms
      • 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` = '22514' limit 1
        9.13mstwenty4_siteHomeworkLibraryController.php#97
        Bindings
        • 0: published
        • 1: 0
        • 2: 22514
        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 (16)
        1.69mstwenty4_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 (22514)
        4.67mstwenty4_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.73mstwenty4_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` <> 22514 and `subject` = 16 and `status` = 'published' and `price` > 0 order by RAND() limit 6
        29.2mstwenty4_siteHomeworkLibraryRepository.php#30
        Bindings
        • 0: 22514
        • 1: 16
        • 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 (16)
        1.62mstwenty4_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` = 22514 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'question' order by `order` asc, `id` asc
        1.85mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 22514
        • 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` = 22514 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'teaser' order by `order` asc, `id` asc
        1.12mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 22514
        • 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` = 22514 and `solutionslibrary_files`.`solutionlib_id` is not null and `publish` = 'solution' order by `order` asc, `id` asc
        1.04mstwenty4_siteHomeworkLibrary.php#260
        Bindings
        • 0: 22514
        • 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.09mstwenty4_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
        980μ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
        1.18mstwenty4_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
        1mstwenty4_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
        980μ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
        2.82mstwenty4_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.02mstwenty4_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.18mstwenty4_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.14mstwenty4_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.28mstwenty4_siteSubject.php#100
        Bindings
        • 0: 31
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 34. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • select * from `subject_cats` where `subject_cats`.`id` = 36 limit 1
        1.29mstwenty4_siteSubject.php#100
        Bindings
        • 0: 36
        Backtrace
        • 18. app/Models/Subject.php:100
        • 19. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
        • 20. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:419
        • 22. app/Models/Subject.php:101
        • 28. view::components.footer:170
      App\Models\SubjectCat
      12SubjectCat.php
      App\Models\HomeworkLibrary\HomeworkLibrary
      7HomeworkLibrary.php
      App\Models\HomeworkLibrary\HomeworkLibraryFile
      7HomeworkLibraryFile.php
      App\Models\Subject
      2Subject.php
          _token
          TXHMAaMhdQWrH7JeFwABYqaWFou93Fe5281caQmJ
          utm_source
          direct
          redirectUrl
          /college-homework-library/Computer-Science/C-Family-Programming/22514
          _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/C-Family-Programming/22514
          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-680df70f-7f352c7059e59f376501b61b" ] "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.145.0.168" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 27 Apr 2025 09:21:20 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjdoS2VIa281VDJoSkUxRHJ0bmF6alE9PSIsInZhbHVlIjoiUENXa2E3MityREw0K2tNci94QjNtWFQrN2JuSjRyN2dabGk5dXlyblJZNk9qUjNqYzgwVEpMdjh6Ti90S3pGRnA5U0pXczFFNERSSTZCZU12MHRVcjNHTk8wWUV2SEFwQ3NjUWxXNm9CcTkvTUQ3aFJieDNQVThjSWpobjBaUzkiLCJtYWMiOiJlOTdlNmE5ZjVmY2NiMmI3YjQ4N2NhYWM0MDI4ZDUzN2NmZGJhZWI3YzdmZDZjM2M0MjI4MTdmZGJkYzU4ZTFmIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 11:21:20 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; samesite=laxXSRF-TOKEN=eyJpdiI6IjdoS2VIa281VDJoSkUxRHJ0bmF6alE9PSIsInZhbHVlIjoiUENXa2E3MityREw0K2tNci94QjNtWFQrN2JuSjRyN2dabGk5dXlyblJZNk9qUjNqYzgwVEpMdjh6Ti90S3pGRnA5U0pXc" 1 => "24houranswers_session=eyJpdiI6IjVQc3E5VVZuUnN4RVlvZngrQndvMEE9PSIsInZhbHVlIjoiODNXR01TUkNLSlFESmZSWk9ZMGhGWUVJclkvVmo5Nk1icG1jb0dYS0NNenBFbUJQZm5nOCtOajdUa1M2S2ZKZ2VmNHlXV0J2d2FpbEFpb3UyTG5TTDd0cG5GbUFTZDRDNnFiY1pQYkJEc0MwaGgrTlVnVXQwRDRwUlRXMU9hcnUiLCJtYWMiOiIzNWI0NmZjNTJkMmNmNDU2ODNlOWY2MWI1ODNlNDVjMGQ4MjY5ZmQyZjUxOWMwOGQ3NmViZTBjNTQxMTFkNzhhIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 11:21:20 GMT; Max-Age=7200; path=/; domain=.24houranswers.com; httponly; samesite=lax24houranswers_session=eyJpdiI6IjVQc3E5VVZuUnN4RVlvZngrQndvMEE9PSIsInZhbHVlIjoiODNXR01TUkNLSlFESmZSWk9ZMGhGWUVJclkvVmo5Nk1icG1jb0dYS0NNenBFbUJQZm5nOCtOajdUa1M2S2" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjdoS2VIa281VDJoSkUxRHJ0bmF6alE9PSIsInZhbHVlIjoiUENXa2E3MityREw0K2tNci94QjNtWFQrN2JuSjRyN2dabGk5dXlyblJZNk9qUjNqYzgwVEpMdjh6Ti90S3pGRnA5U0pXczFFNERSSTZCZU12MHRVcjNHTk8wWUV2SEFwQ3NjUWxXNm9CcTkvTUQ3aFJieDNQVThjSWpobjBaUzkiLCJtYWMiOiJlOTdlNmE5ZjVmY2NiMmI3YjQ4N2NhYWM0MDI4ZDUzN2NmZGJhZWI3YzdmZDZjM2M0MjI4MTdmZGJkYzU4ZTFmIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 11:21:20 GMT; domain=.24houranswers.com; path=/XSRF-TOKEN=eyJpdiI6IjdoS2VIa281VDJoSkUxRHJ0bmF6alE9PSIsInZhbHVlIjoiUENXa2E3MityREw0K2tNci94QjNtWFQrN2JuSjRyN2dabGk5dXlyblJZNk9qUjNqYzgwVEpMdjh6Ti90S3pGRnA5U0pXc" 1 => "24houranswers_session=eyJpdiI6IjVQc3E5VVZuUnN4RVlvZngrQndvMEE9PSIsInZhbHVlIjoiODNXR01TUkNLSlFESmZSWk9ZMGhGWUVJclkvVmo5Nk1icG1jb0dYS0NNenBFbUJQZm5nOCtOajdUa1M2S2ZKZ2VmNHlXV0J2d2FpbEFpb3UyTG5TTDd0cG5GbUFTZDRDNnFiY1pQYkJEc0MwaGgrTlVnVXQwRDRwUlRXMU9hcnUiLCJtYWMiOiIzNWI0NmZjNTJkMmNmNDU2ODNlOWY2MWI1ODNlNDVjMGQ4MjY5ZmQyZjUxOWMwOGQ3NmViZTBjNTQxMTFkNzhhIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 11:21:20 GMT; domain=.24houranswers.com; path=/; httponly24houranswers_session=eyJpdiI6IjVQc3E5VVZuUnN4RVlvZngrQndvMEE9PSIsInZhbHVlIjoiODNXR01TUkNLSlFESmZSWk9ZMGhGWUVJclkvVmo5Nk1icG1jb0dYS0NNenBFbUJQZm5nOCtOajdUa1M2S2" ] ]
          session_attributes
          0 of 0
          array:6 [ "_token" => "TXHMAaMhdQWrH7JeFwABYqaWFou93Fe5281caQmJ" "utm_source" => "direct" "redirectUrl" => "/college-homework-library/Computer-Science/C-Family-Programming/22514" "_previous" => array:1 [ "url" => "https://staging.dev.24houranswers.com/college-homework-library/Computer-Science/C-Family-Programming/22514" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]