{
"data": [
{
"id": 2153,
"slug": "مسار-يمان-لاحدا-يعدل-رجاء-1761471307",
"title": "مسار يمان لاحدا يعدل رجاء",
"subtitle": null,
"description": "",
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": [
"برامج",
"تست"
],
"requirements": [
"لايوجد"
],
"price": 0,
"sales_price": 0,
"courses_count": 3,
"enrollments_count": 2,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": true,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": "",
"meta_keywords": [],
"meta_description": null
},
{
"id": 1968,
"slug": "yazan-1751533446",
"title": "ayazmayan",
"subtitle": null,
"description": "",
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 0,
"sales_price": 0,
"courses_count": 1,
"enrollments_count": 10,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": false,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": "",
"meta_keywords": [],
"meta_description": null
},
{
"id": 1384,
"slug": "asd123-1747848841",
"title": "",
"subtitle": null,
"description": null,
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 0,
"sales_price": 0,
"courses_count": 3,
"enrollments_count": 4,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": true,
"certificate_for_every_course": 1,
"reviews_enabled": false
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 1301,
"slug": "مسار-شهادة-1745323538",
"title": "",
"subtitle": null,
"description": null,
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 0,
"sales_price": 0,
"courses_count": 2,
"enrollments_count": 4,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": true,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 1283,
"slug": "learning-path-test",
"title": "",
"subtitle": null,
"description": null,
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 0,
"sales_price": 0,
"courses_count": 3,
"enrollments_count": 366,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": false,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 1279,
"slug": "مسار-يمان-1744207021",
"title": "",
"subtitle": null,
"description": null,
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 0,
"sales_price": 0,
"courses_count": 1,
"enrollments_count": 6,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": true,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 1278,
"slug": "مسار-جديد-1744144135",
"title": "",
"subtitle": null,
"description": null,
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": null,
"requirements": null,
"price": 0,
"sales_price": 0,
"courses_count": 3,
"enrollments_count": 1,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": true,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 1264,
"slug": "path",
"title": "",
"subtitle": null,
"description": null,
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 0,
"sales_price": 0,
"courses_count": 2,
"enrollments_count": 367,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": true,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 1161,
"slug": "مسار-2-1738171575",
"title": "",
"subtitle": null,
"description": "",
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 0,
"sales_price": 0,
"courses_count": 2,
"enrollments_count": 380,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": true,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 1160,
"slug": "مسار-1-1738171403",
"title": "",
"subtitle": null,
"description": "",
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 201000,
"sales_price": 230000,
"courses_count": 1,
"enrollments_count": 378,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": false,
"certificate_for_every_course": 0,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
},
{
"id": 923,
"slug": "مسار-31-12-1735653265",
"title": "",
"subtitle": null,
"description": null,
"short_description": null,
"thumbnail": null,
"cover": null,
"outcomes": "",
"requirements": "",
"price": 200000,
"sales_price": 250000,
"courses_count": 0,
"enrollments_count": 3,
"avg_rating": 0,
"ratings": {
"1": 0,
"2": 0,
"3": 0,
"4": 0,
"5": 0
},
"status": "published",
"settings": {
"certificate_enabled": true,
"navigation_between_courses": false,
"certificate_for_every_course": 1,
"reviews_enabled": true
},
"course_type": "learning_path",
"meta_title": null,
"meta_keywords": [],
"meta_description": null
}
],
"links": {
"first": "https://api.msaaq.test/v2/tenant/learning-paths?page=1",
"last": "https://api.msaaq.test/v2/tenant/learning-paths?page=1",
"prev": null,
"next": null
},
"meta": {
"current_page": 1,
"from": 1,
"last_page": 1,
"links": [
{
"url": null,
"label": "« السابق",
"active": false
},
{
"url": "https://api.msaaq.test/v2/tenant/learning-paths?page=1",
"label": "1",
"active": true
},
{
"url": null,
"label": "التالي »",
"active": false
}
],
"path": "https://api.msaaq.test/v2/tenant/learning-paths",
"per_page": 15,
"to": 11,
"total": 11
},
"_debugbar": {
"__meta": {
"id": "01KCEY7R7DDN7JH1HBJBK6H0DY",
"datetime": "2025-12-14 20:23:52",
"utime": 1765733032.173099,
"method": "GET",
"uri": "/v2/tenant/learning-paths",
"ip": "127.0.0.1"
},
"messages": {
"count": 1,
"messages": [
{
"message": "[20:23:52] LOG.warning: Creation of dynamic property Illuminate\\Http\\Request::$academy is deprecated in /Users/khaledalam/Desktop/MSAAQ/msaaq/app/Providers/AppServiceProvider.php on line 124",
"message_html": null,
"is_string": false,
"label": "warning",
"time": 1765733032.150545,
"xdebug_link": null,
"collector": "log"
}
]
},
"time": {
"count": 4,
"start": 1765733032.070181,
"end": 1765733032.173108,
"duration": 0.10292720794677734,
"duration_str": "103ms",
"measures": [
{
"label": "Booting",
"start": 1765733032.070181,
"relative_start": 0,
"end": 1765733032.119893,
"relative_end": 1765733032.119893,
"duration": 0.049712181091308594,
"duration_str": "49.71ms",
"memory": 0,
"memory_str": "0B",
"params": [],
"collector": "time",
"group": null
},
{
"label": "Application",
"start": 1765733032.119912,
"relative_start": 0.04973101615905762,
"end": 1765733032.173109,
"relative_end": 9.5367431640625e-7,
"duration": 0.05319714546203613,
"duration_str": "53.2ms",
"memory": 0,
"memory_str": "0B",
"params": [],
"collector": "time",
"group": null
},
{
"label": "Routing",
"start": 1765733032.141237,
"relative_start": 0.07105612754821777,
"end": 1765733032.143837,
"relative_end": 1765733032.143837,
"duration": 0.002599954605102539,
"duration_str": "2.6ms",
"memory": 0,
"memory_str": "0B",
"params": [],
"collector": null,
"group": null
},
{
"label": "Preparing Response",
"start": 1765733032.168136,
"relative_start": 0.09795498847961426,
"end": 1765733032.1728,
"relative_end": 1765733032.1728,
"duration": 0.004664182662963867,
"duration_str": "4.66ms",
"memory": 0,
"memory_str": "0B",
"params": [],
"collector": null,
"group": null
}
]
},
"memory": {
"peak_usage": 5952992,
"peak_usage_str": "6MB"
},
"exceptions": {
"count": 0,
"exceptions": []
},
"laravel": {
"version": "11.x",
"tooltip": {
"Laravel Version": "11.46.1",
"PHP Version": "8.3.28",
"Environment": "local",
"Debug Mode": "Enabled",
"URL": "api.msaaq.test",
"Timezone": "Asia/Riyadh",
"Locale": "ar"
}
},
"views": {
"count": 0,
"nb_templates": 0,
"templates": []
},
"queries": {
"count": 8,
"nb_statements": 7,
"nb_visible_statements": 8,
"nb_excluded_statements": 0,
"nb_failed_statements": 0,
"accumulated_duration": 0.01235,
"accumulated_duration_str": "12.35ms",
"memory_usage": 0,
"memory_usage_str": null,
"statements": [
{
"sql": "Connection Established",
"type": "transaction",
"params": [],
"bindings": [],
"hints": null,
"show_copy": false,
"backtrace": [
{
"index": 15,
"namespace": null,
"name": "app/Models/Academy.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Models/Academy.php",
"line": 742
},
{
"index": 16,
"namespace": null,
"name": "app/Providers/AppServiceProvider.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Providers/AppServiceProvider.php",
"line": 124
},
{
"index": 17,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Macroable/Traits/Macroable.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Macroable/Traits/Macroable.php",
"line": 126
},
{
"index": 18,
"namespace": "middleware",
"name": "api.has.academy",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Middleware/Api/V1/HasAcademyMiddleware.php",
"line": 15
},
{
"index": 19,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 209
}
],
"start": 1765733032.147013,
"duration": 0,
"duration_str": "",
"memory": 0,
"memory_str": null,
"filename": "Academy.php:742",
"source": {
"index": 15,
"namespace": null,
"name": "app/Models/Academy.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Models/Academy.php",
"line": 742
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FModels%2FAcademy.php&line=742",
"ajax": false,
"filename": "Academy.php",
"line": "742"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 0,
"width_percent": 0
},
{
"sql": "select * from `academies` where `academies`.`id` = '1' and `academies`.`deleted_at` is null limit 1",
"type": "query",
"params": [],
"bindings": [
"1"
],
"hints": null,
"show_copy": true,
"backtrace": [
{
"index": 20,
"namespace": null,
"name": "app/Models/Academy.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Models/Academy.php",
"line": 742
},
{
"index": 21,
"namespace": null,
"name": "app/Providers/AppServiceProvider.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Providers/AppServiceProvider.php",
"line": 124
},
{
"index": 22,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Macroable/Traits/Macroable.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Macroable/Traits/Macroable.php",
"line": 126
},
{
"index": 23,
"namespace": "middleware",
"name": "api.has.academy",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Middleware/Api/V1/HasAcademyMiddleware.php",
"line": 15
},
{
"index": 24,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 209
}
],
"start": 1765733032.147365,
"duration": 0.0026,
"duration_str": "2.6ms",
"memory": 0,
"memory_str": null,
"filename": "Academy.php:742",
"source": {
"index": 20,
"namespace": null,
"name": "app/Models/Academy.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Models/Academy.php",
"line": 742
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FModels%2FAcademy.php&line=742",
"ajax": false,
"filename": "Academy.php",
"line": "742"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 0,
"width_percent": 21.053
},
{
"sql": "select * from `stripe_subscriptions` where `stripe_subscriptions`.`academy_id` = 1 and `stripe_subscriptions`.`academy_id` is not null order by `created_at` desc",
"type": "query",
"params": [],
"bindings": [
1
],
"hints": null,
"show_copy": true,
"backtrace": [
{
"index": 20,
"namespace": null,
"name": "vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"line": 155
},
{
"index": 21,
"namespace": null,
"name": "vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"line": 138
},
{
"index": 22,
"namespace": null,
"name": "app/Http/Middleware/ValidSubscriptionMiddleware.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Middleware/ValidSubscriptionMiddleware.php",
"line": 26
},
{
"index": 23,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 209
},
{
"index": 24,
"namespace": "middleware",
"name": "api.has.academy",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Middleware/Api/V1/HasAcademyMiddleware.php",
"line": 25
}
],
"start": 1765733032.151058,
"duration": 0.0008399999999999999,
"duration_str": "840μs",
"memory": 0,
"memory_str": null,
"filename": "ManagesSubscriptions.php:155",
"source": {
"index": 20,
"namespace": null,
"name": "vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"line": 155
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fvendor%2Flaravel%2Fcashier%2Fsrc%2FConcerns%2FManagesSubscriptions.php&line=155",
"ajax": false,
"filename": "ManagesSubscriptions.php",
"line": "155"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 21.053,
"width_percent": 6.802
},
{
"sql": "select * from `stripe_subscription_items` where `stripe_subscription_items`.`subscription_id` in (126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 141, 142, 143, 211)",
"type": "query",
"params": [],
"bindings": [],
"hints": null,
"show_copy": true,
"backtrace": [
{
"index": 25,
"namespace": null,
"name": "vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"line": 155
},
{
"index": 26,
"namespace": null,
"name": "vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"line": 138
},
{
"index": 27,
"namespace": null,
"name": "app/Http/Middleware/ValidSubscriptionMiddleware.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Middleware/ValidSubscriptionMiddleware.php",
"line": 26
},
{
"index": 28,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 209
},
{
"index": 29,
"namespace": "middleware",
"name": "api.has.academy",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Middleware/Api/V1/HasAcademyMiddleware.php",
"line": 25
}
],
"start": 1765733032.152881,
"duration": 0.00073,
"duration_str": "730μs",
"memory": 0,
"memory_str": null,
"filename": "ManagesSubscriptions.php:155",
"source": {
"index": 25,
"namespace": null,
"name": "vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/cashier/src/Concerns/ManagesSubscriptions.php",
"line": 155
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fvendor%2Flaravel%2Fcashier%2Fsrc%2FConcerns%2FManagesSubscriptions.php&line=155",
"ajax": false,
"filename": "ManagesSubscriptions.php",
"line": "155"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 27.854,
"width_percent": 5.911
},
{
"sql": "select count(*) as aggregate from `courses` where `courses`.`academy_id` = 1 and `courses`.`academy_id` is not null and `type` = 'learning_path' and `courses`.`status` in ('published', 'scheduled')",
"type": "query",
"params": [],
"bindings": [
1,
"learning_path",
"published",
"scheduled"
],
"hints": null,
"show_copy": true,
"backtrace": [
{
"index": 19,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
{
"index": 20,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"line": 54
},
{
"index": 21,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"line": 44
},
{
"index": 22,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 266
},
{
"index": 23,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 212
}
],
"start": 1765733032.155911,
"duration": 0.00254,
"duration_str": "2.54ms",
"memory": 0,
"memory_str": null,
"filename": "LearningPathController.php:30",
"source": {
"index": 19,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FHttp%2FControllers%2FApi%2FV2%2FTenant%2FLearningPathController.php&line=30",
"ajax": false,
"filename": "LearningPathController.php",
"line": "30"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 33.765,
"width_percent": 20.567
},
{
"sql": "select `courses`.*, (select count(*) from `courses` as `laravel_reserved_0` inner join `learning_path_courses` on `laravel_reserved_0`.`id` = `learning_path_courses`.`course_id` where `courses`.`id` = `learning_path_courses`.`learning_path_id` and `laravel_reserved_0`.`academy_id` = 1) as `courses_count` from `courses` where `courses`.`academy_id` = 1 and `courses`.`academy_id` is not null and `type` = 'learning_path' and `courses`.`status` in ('published', 'scheduled') order by `created_at` desc limit 15 offset 0",
"type": "query",
"params": [],
"bindings": [
1,
1,
"learning_path",
"published",
"scheduled"
],
"hints": null,
"show_copy": true,
"backtrace": [
{
"index": 19,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
{
"index": 20,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"line": 54
},
{
"index": 21,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"line": 44
},
{
"index": 22,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 266
},
{
"index": 23,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 212
}
],
"start": 1765733032.158848,
"duration": 0.0038799999999999998,
"duration_str": "3.88ms",
"memory": 0,
"memory_str": null,
"filename": "LearningPathController.php:30",
"source": {
"index": 19,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FHttp%2FControllers%2FApi%2FV2%2FTenant%2FLearningPathController.php&line=30",
"ajax": false,
"filename": "LearningPathController.php",
"line": "30"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 54.332,
"width_percent": 31.417
},
{
"sql": "select * from `academies` where `academies`.`id` in (1) and `academies`.`deleted_at` is null",
"type": "query",
"params": [],
"bindings": [],
"hints": null,
"show_copy": true,
"backtrace": [
{
"index": 24,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
{
"index": 25,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"line": 54
},
{
"index": 26,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"line": 44
},
{
"index": 27,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 266
},
{
"index": 28,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 212
}
],
"start": 1765733032.1635861,
"duration": 0.00116,
"duration_str": "1.16ms",
"memory": 0,
"memory_str": null,
"filename": "LearningPathController.php:30",
"source": {
"index": 24,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FHttp%2FControllers%2FApi%2FV2%2FTenant%2FLearningPathController.php&line=30",
"ajax": false,
"filename": "LearningPathController.php",
"line": "30"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 85.749,
"width_percent": 9.393
},
{
"sql": "select * from `contents` where `premium` = 0 and `type` = 'video' and `contents`.`course_id` in (923, 1160, 1161, 1264, 1278, 1279, 1283, 1301, 1384, 1968, 2153) and `contents`.`deleted_at` is null",
"type": "query",
"params": [],
"bindings": [
0,
"video"
],
"hints": null,
"show_copy": true,
"backtrace": [
{
"index": 24,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
{
"index": 25,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"line": 54
},
{
"index": 26,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"line": 44
},
{
"index": 27,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 266
},
{
"index": 28,
"namespace": null,
"name": "vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 212
}
],
"start": 1765733032.1653638,
"duration": 0.0006,
"duration_str": "600μs",
"memory": 0,
"memory_str": null,
"filename": "LearningPathController.php:30",
"source": {
"index": 24,
"namespace": null,
"name": "app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"file": "/Users/khaledalam/Desktop/MSAAQ/msaaq/app/Http/Controllers/Api/V2/Tenant/LearningPathController.php",
"line": 30
},
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FHttp%2FControllers%2FApi%2FV2%2FTenant%2FLearningPathController.php&line=30",
"ajax": false,
"filename": "LearningPathController.php",
"line": "30"
},
"connection": "msaaq3",
"explain": null,
"start_percent": 95.142,
"width_percent": 4.858
}
]
},
"models": {
"data": {
"App\\Models\\Cashier\\SubscriptionItem": {
"retrieved": 24,
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FModels%2FCashier%2FSubscriptionItem.php&line=1",
"ajax": false,
"filename": "SubscriptionItem.php",
"line": "?"
}
},
"App\\Models\\Cashier\\Subscription": {
"retrieved": 15,
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FModels%2FCashier%2FSubscription.php&line=1",
"ajax": false,
"filename": "Subscription.php",
"line": "?"
}
},
"App\\Models\\Course": {
"retrieved": 11,
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FModels%2FCourse.php&line=1",
"ajax": false,
"filename": "Course.php",
"line": "?"
}
},
"App\\Models\\Academy": {
"retrieved": 2,
"xdebug_link": {
"url": "phpstorm://open?file=%2FUsers%2Fkhaledalam%2FDesktop%2FMSAAQ%2Fmsaaq%2Fapp%2FModels%2FAcademy.php&line=1",
"ajax": false,
"filename": "Academy.php",
"line": "?"
}
}
},
"count": 52,
"key_map": {
"retrieved": "Retrieved",
"created": "Created",
"updated": "Updated",
"deleted": "Deleted"
},
"is_counter": true,
"badges": {
"retrieved": 52
}
},
"livewire": {
"data": [],
"count": 0
},
"symfonymailer_mails": {
"count": 0,
"mails": []
},
"gate": {
"count": 0,
"messages": []
}
}
}