app\/Http\/Controllers\/Admin\/DashboardController.php:18-107<\/a>"},"queries":{"nb_statements":20,"nb_visible_statements":21,"nb_excluded_statements":0,"nb_failed_statements":0,"accumulated_duration":0.010089999999999998,"accumulated_duration_str":"10.09ms","memory_usage":0,"memory_usage_str":null,"statements":[{"sql":"Connection Established","type":"transaction","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":168},{"index":14,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":57},{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":159},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":56},{"index":17,"namespace":"middleware","name":"auth","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Middleware\/Authenticate.php","line":76}],"start":1762933683.544063,"duration":0,"duration_str":"","memory":0,"memory_str":null,"filename":"EloquentUserProvider.php:168","source":{"index":13,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":168},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fvendor%2Flaravel%2Fframework%2Fsrc%2FIlluminate%2FAuth%2FEloquentUserProvider.php&line=168","ajax":false,"filename":"EloquentUserProvider.php","line":"168"},"connection":"cblms","explain":null,"start_percent":0,"width_percent":0},{"sql":"select * from `admins` where `id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":159},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":56},{"index":19,"namespace":"middleware","name":"auth","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Middleware\/Authenticate.php","line":76},{"index":20,"namespace":"middleware","name":"auth","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Middleware\/Authenticate.php","line":55}],"start":1762933683.5443242,"duration":0.00152,"duration_str":"1.52ms","memory":0,"memory_str":null,"filename":"EloquentUserProvider.php:59","source":{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fvendor%2Flaravel%2Fframework%2Fsrc%2FIlluminate%2FAuth%2FEloquentUserProvider.php&line=59","ajax":false,"filename":"EloquentUserProvider.php","line":"59"},"connection":"cblms","explain":null,"start_percent":0,"width_percent":15.064},{"sql":"select `id`, `coupon_discount_amount`, `payable_amount`, `gateway_charge`, `commission_rate`, `created_at` from `orders` where `payment_status` = 'paid'","type":"query","params":[],"bindings":["paid"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":23},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.547051,"duration":0.00035,"duration_str":"350\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:23","source":{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":23},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=23","ajax":false,"filename":"DashboardController.php","line":"23"},"connection":"cblms","explain":null,"start_percent":15.064,"width_percent":3.469},{"sql":"select DATE(created_at) as date, SUM(payable_amount) as total_price, SUM(gateway_charge) as gateway_charge, SUM(coupon_discount_amount) as coupon_discount_amount from `orders` where `payment_status` = 'paid' and `created_at` between '2025-11-01 00:00:00' and '2025-11-30 23:59:59' group by `date`","type":"query","params":[],"bindings":["paid","2025-11-01 00:00:00","2025-11-30 23:59:59"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":73},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.5479531,"duration":0.00045,"duration_str":"450\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:73","source":{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":73},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=73","ajax":false,"filename":"DashboardController.php","line":"73"},"connection":"cblms","explain":null,"start_percent":18.533,"width_percent":4.46},{"sql":"select * from `orders` order by `created_at` asc limit 1","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":90},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.548959,"duration":0.00031,"duration_str":"310\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:90","source":{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":90},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=90","ajax":false,"filename":"DashboardController.php","line":"90"},"connection":"cblms","explain":null,"start_percent":22.993,"width_percent":3.072},{"sql":"select * from `orders` order by `created_at` desc limit 1","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":91},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.5496361,"duration":0.00031,"duration_str":"310\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:91","source":{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":91},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=91","ajax":false,"filename":"DashboardController.php","line":"91"},"connection":"cblms","explain":null,"start_percent":26.065,"width_percent":3.072},{"sql":"select count(*) as aggregate from `orders`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":92},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.55039,"duration":0.00029,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:92","source":{"index":19,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":92},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=92","ajax":false,"filename":"DashboardController.php","line":"92"},"connection":"cblms","explain":null,"start_percent":29.138,"width_percent":2.874},{"sql":"select count(*) as aggregate from `orders` where (`status` = 'pending')","type":"query","params":[],"bindings":["pending"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":93},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.551006,"duration":0.00028000000000000003,"duration_str":"280\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:93","source":{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":93},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=93","ajax":false,"filename":"DashboardController.php","line":"93"},"connection":"cblms","explain":null,"start_percent":32.012,"width_percent":2.775},{"sql":"select count(*) as aggregate from `courses` where `courses`.`deleted_at` is null","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":94},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.551842,"duration":0.00029,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:94","source":{"index":19,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":94},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=94","ajax":false,"filename":"DashboardController.php","line":"94"},"connection":"cblms","explain":null,"start_percent":34.787,"width_percent":2.874},{"sql":"select count(*) as aggregate from `courses` where (`status` = 'pending' and `is_approved` = 'approved') and `courses`.`deleted_at` is null","type":"query","params":[],"bindings":["pending","approved"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":95},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.55251,"duration":0.00033,"duration_str":"330\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:95","source":{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":95},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=95","ajax":false,"filename":"DashboardController.php","line":"95"},"connection":"cblms","explain":null,"start_percent":37.661,"width_percent":3.271},{"sql":"select * from `courses` where `courses`.`deleted_at` is null order by `created_at` desc limit 5","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":100},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.553195,"duration":0.00039,"duration_str":"390\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:100","source":{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":100},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=100","ajax":false,"filename":"DashboardController.php","line":"100"},"connection":"cblms","explain":null,"start_percent":40.932,"width_percent":3.865},{"sql":"select count(*) as aggregate from `courses` where `is_approved` = 'pending' and `courses`.`deleted_at` is null","type":"query","params":[],"bindings":["pending"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":101},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.5540478,"duration":0.00041,"duration_str":"410\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:101","source":{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":101},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=101","ajax":false,"filename":"DashboardController.php","line":"101"},"connection":"cblms","explain":null,"start_percent":44.797,"width_percent":4.063},{"sql":"select * from `blogs` order by `created_at` desc limit 5","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":102},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.554923,"duration":0.00031,"duration_str":"310\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:102","source":{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":102},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=102","ajax":false,"filename":"DashboardController.php","line":"102"},"connection":"cblms","explain":null,"start_percent":48.86,"width_percent":3.072},{"sql":"select count(*) as aggregate from `blogs` where `status` = 0","type":"query","params":[],"bindings":[0],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":103},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.555604,"duration":0.0003,"duration_str":"300\u03bcs","memory":0,"memory_str":null,"filename":"DashboardController.php:103","source":{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":103},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=103","ajax":false,"filename":"DashboardController.php","line":"103"},"connection":"cblms","explain":null,"start_percent":51.933,"width_percent":2.973},{"sql":"select * from `contact_messages` order by `created_at` desc limit 5","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":104},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"start":1762933683.5563262,"duration":0.00155,"duration_str":"1.55ms","memory":0,"memory_str":null,"filename":"DashboardController.php:104","source":{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Admin\/DashboardController.php","file":"\/var\/www\/html\/app\/Http\/Controllers\/Admin\/DashboardController.php","line":104},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FHttp%2FControllers%2FAdmin%2FDashboardController.php&line=104","ajax":false,"filename":"DashboardController.php","line":"104"},"connection":"cblms","explain":null,"start_percent":54.906,"width_percent":15.362},{"sql":"select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` = 1 and `model_has_permissions`.`model_type` = 'App\\\\Models\\\\Admin'","type":"query","params":[],"bindings":[1,"App\\Models\\Admin"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":326},{"index":21,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":215},{"index":22,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":261},{"index":23,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","line":129},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Access\/Gate.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Access\/Gate.php","line":566}],"start":1762933683.561129,"duration":0.00054,"duration_str":"540\u03bcs","memory":0,"memory_str":null,"filename":"HasPermissions.php:326","source":{"index":20,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":326},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fvendor%2Fspatie%2Flaravel-permission%2Fsrc%2FTraits%2FHasPermissions.php&line=326","ajax":false,"filename":"HasPermissions.php","line":"326"},"connection":"cblms","explain":null,"start_percent":70.268,"width_percent":5.352},{"sql":"select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` in (1) and `model_has_roles`.`model_type` = 'App\\\\Models\\\\Admin'","type":"query","params":[],"bindings":["App\\Models\\Admin"],"hints":null,"show_copy":false,"backtrace":[{"index":22,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php","line":227},{"index":23,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":312},{"index":24,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":215},{"index":25,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":261},{"index":26,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","line":129}],"start":1762933683.562403,"duration":0.00043,"duration_str":"430\u03bcs","memory":0,"memory_str":null,"filename":"HasRoles.php:227","source":{"index":22,"namespace":null,"name":"vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php","file":"\/var\/www\/html\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php","line":227},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fvendor%2Fspatie%2Flaravel-permission%2Fsrc%2FTraits%2FHasRoles.php&line=227","ajax":false,"filename":"HasRoles.php","line":"227"},"connection":"cblms","explain":null,"start_percent":75.619,"width_percent":4.262},{"sql":"select count(*) as aggregate from `courses` where `is_approved` = 'pending' and `courses`.`deleted_at` is null","type":"query","params":[],"bindings":["pending"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":"view","name":"course::sidebar","file":"\/var\/www\/html\/Modules\/Course\/resources\/views\/sidebar.blade.php","line":3},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":124},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":207}],"start":1762933683.5914478,"duration":0.00057,"duration_str":"570\u03bcs","memory":0,"memory_str":null,"filename":"course::sidebar:3","source":{"index":16,"namespace":"view","name":"course::sidebar","file":"\/var\/www\/html\/Modules\/Course\/resources\/views\/sidebar.blade.php","line":3},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2FModules%2FCourse%2Fresources%2Fviews%2Fsidebar.blade.php&line=3","ajax":false,"filename":"sidebar.blade.php","line":"3"},"connection":"cblms","explain":null,"start_percent":79.881,"width_percent":5.649},{"sql":"select count(*) as aggregate from `orders` where `payment_status` = 'pending'","type":"query","params":[],"bindings":["pending"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":"view","name":"order::sidebar","file":"\/var\/www\/html\/Modules\/Order\/resources\/views\/sidebar.blade.php","line":2},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":124},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":207}],"start":1762933683.598342,"duration":0.0005200000000000001,"duration_str":"520\u03bcs","memory":0,"memory_str":null,"filename":"order::sidebar:2","source":{"index":16,"namespace":"view","name":"order::sidebar","file":"\/var\/www\/html\/Modules\/Order\/resources\/views\/sidebar.blade.php","line":2},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2FModules%2FOrder%2Fresources%2Fviews%2Fsidebar.blade.php&line=2","ajax":false,"filename":"sidebar.blade.php","line":"2"},"connection":"cblms","explain":null,"start_percent":85.53,"width_percent":5.154},{"sql":"select count(*) as aggregate from `withdraw_requests` where `status` = 'pending'","type":"query","params":[],"bindings":["pending"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":"view","name":"paymentwithdraw::admin.sidebar","file":"\/var\/www\/html\/Modules\/PaymentWithdraw\/resources\/views\/admin\/sidebar.blade.php","line":2},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":124},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":207}],"start":1762933683.6027632,"duration":0.00047999999999999996,"duration_str":"480\u03bcs","memory":0,"memory_str":null,"filename":"paymentwithdraw::admin.sidebar:2","source":{"index":16,"namespace":"view","name":"paymentwithdraw::admin.sidebar","file":"\/var\/www\/html\/Modules\/PaymentWithdraw\/resources\/views\/admin\/sidebar.blade.php","line":2},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2FModules%2FPaymentWithdraw%2Fresources%2Fviews%2Fadmin%2Fsidebar.blade.php&line=2","ajax":false,"filename":"sidebar.blade.php","line":"2"},"connection":"cblms","explain":null,"start_percent":90.684,"width_percent":4.757},{"sql":"select count(*) as aggregate from `instructor_requests` where `status` = 'pending'","type":"query","params":[],"bindings":["pending"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":"view","name":"instructorrequest::sidebar","file":"\/var\/www\/html\/Modules\/InstructorRequest\/resources\/views\/sidebar.blade.php","line":2},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":124},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":207}],"start":1762933683.6054032,"duration":0.00046,"duration_str":"460\u03bcs","memory":0,"memory_str":null,"filename":"instructorrequest::sidebar:2","source":{"index":16,"namespace":"view","name":"instructorrequest::sidebar","file":"\/var\/www\/html\/Modules\/InstructorRequest\/resources\/views\/sidebar.blade.php","line":2},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2FModules%2FInstructorRequest%2Fresources%2Fviews%2Fsidebar.blade.php&line=2","ajax":false,"filename":"sidebar.blade.php","line":"2"},"connection":"cblms","explain":null,"start_percent":95.441,"width_percent":4.559}]},"models":{"data":{"App\\Models\\Course":{"value":3,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FModels%2FCourse.php&line=1","ajax":false,"filename":"Course.php","line":"?"}},"App\\Models\\Admin":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fapp%2FModels%2FAdmin.php&line=1","ajax":false,"filename":"Admin.php","line":"?"}},"Modules\\Blog\\app\\Models\\Blog":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2FModules%2FBlog%2Fapp%2FModels%2FBlog.php&line=1","ajax":false,"filename":"Blog.php","line":"?"}},"Spatie\\Permission\\Models\\Role":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fvar%2Fwww%2Fhtml%2Fvendor%2Fspatie%2Flaravel-permission%2Fsrc%2FModels%2FRole.php&line=1","ajax":false,"filename":"Role.php","line":"?"}}},"count":6,"is_counter":true},"symfonymailer_mails":{"count":0,"mails":[]},"gate":{"count":109,"messages":[{"message":"[\n ability => course.management,\n target => null,\n result => true,\n admin => 1,\n arguments => []\n]","message_html":"course.management <\/span> [\n \"ability<\/span>\" => \"course.management<\/span>\"\n \"target<\/span>\" => null<\/span>\n \"result<\/span>\" => true<\/span>\n \"admin<\/span>\" => 1<\/span>\n \"arguments<\/span>\" => \"[]<\/span>\"\n<\/samp>]\n<\/pre>