1.87sRequest Duration31.25MBMemory UsageGET explore/donate-zakat-in-ramadanRouteAuth status
    • Booting (1.81s)
    • Application (1.81s)
      7 templates were rendered
      • cms::web.pages.ramzan_donations (Modules/Cms/Resources/views/web/pages/ramzan_donations.blade.php)0blade
      • layouts.web.master (resources/themes/metronic/layouts/web/master.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        request_protocol
        4
        meta_title
        5
        meta_keywords
        6
        meta_description
        7
        og_title
        8
        og_description
        9
        og_type
        10
        og_image
        11
        og_site_name
        12
        errors
      • partials.web.head_styles (resources/themes/metronic/partials/web/head_styles.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        request_protocol
        4
        meta_title
        5
        meta_keywords
        6
        meta_description
        7
        og_title
        8
        og_description
        9
        og_type
        10
        og_image
        11
        og_site_name
        12
        errors
        13
        user
      • web.javascriptRoutes (resources/views/web/javascriptRoutes.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        request_protocol
        4
        meta_title
        5
        meta_keywords
        6
        meta_description
        7
        og_title
        8
        og_description
        9
        og_type
        10
        og_image
        11
        og_site_name
        12
        errors
      • partials.web.header (resources/themes/metronic/partials/web/header.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        request_protocol
        4
        meta_title
        5
        meta_keywords
        6
        meta_description
        7
        og_title
        8
        og_description
        9
        og_type
        10
        og_image
        11
        og_site_name
        12
        errors
        13
        user
      • partials.web.footer (resources/themes/metronic/partials/web/footer.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        request_protocol
        4
        meta_title
        5
        meta_keywords
        6
        meta_description
        7
        og_title
        8
        og_description
        9
        og_type
        10
        og_image
        11
        og_site_name
        12
        errors
        13
        color_class
        14
        user
      • flash.web.message (resources/views/flash/web/message.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        request_protocol
        4
        meta_title
        5
        meta_keywords
        6
        meta_description
        7
        og_title
        8
        og_description
        9
        og_type
        10
        og_image
        11
        og_site_name
        12
        errors
      uri
      GET explore/donate-zakat-in-ramadan
      middleware
      web, checkZone
      as
      web.cms.donate_zakat_in_ramadan
      controller
      Modules\Cms\Http\Controllers\Web\PagesController@ramzanCompaign
      namespace
      Modules\Cms\Http\Controllers\Web
      prefix
      null
      where
      file
      Modules/Cms/Http/Controllers/Web/PagesController.php:199-203
      10 statements were executed1.58s
      • select * from `currencies`170μs/vendor/torann/currency/src/Drivers/Database.php:62seedoutm_seedout_staging
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 9. /vendor/torann/currency/src/Drivers/Database.php:62
        • 10. /vendor/torann/currency/src/Currency.php:242
        • 11. /vendor/torann/currency/src/Currency.php:230
        • 12. /vendor/torann/currency/src/Currency.php:215
        • 13. /app/Providers/AppServiceProvider.php:47
        • 25. /public/index.php:54
      • select count(*) as aggregate from `applications` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower'1.15ms/Modules/Application/Repositories/web/facade/Filters.php:186seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. 9
        • 1. Live
        • 2. Approved
        • 3. borrower
        Backtrace
        • 13. /Modules/Application/Repositories/web/facade/Filters.php:186
        • 14. /Modules/Application/Repositories/web/facade/Filters.php:186
        • 15. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 17. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 30. /public/index.php:54
      • select `categories`.`id`, `categories`.`category`, count(borrower.id) as borrower from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' group by `categories`.`id`1.73ms/Modules/Application/Repositories/web/facade/Filters.php:192seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. 9
        • 1. Live
        • 2. Approved
        • 3. borrower
        Backtrace
        • 11. /Modules/Application/Repositories/web/facade/Filters.php:192
        • 12. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 14. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 27. /public/index.php:54
      • select `borrower`.`id`, `borrower_gender`, count(borrower.id) as borrower from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' group by `categories`.`id`, `borrower`.`borrower_gender`1.48ms/Modules/Application/Repositories/web/facade/Filters.php:198seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. 9
        • 1. Live
        • 2. Approved
        • 3. borrower
        Backtrace
        • 11. /Modules/Application/Repositories/web/facade/Filters.php:198
        • 12. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 14. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 27. /public/index.php:54
      • select count(*) as aggregate from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' and `applications`.`expiry_date` between '2025-04-07 17:52:34' and '2025-05-07 17:52:34' group by `categories`.`id`, `borrower`.`borrower_gender`1.02ms/Modules/Application/Repositories/web/facade/Filters.php:201seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. 9
        • 1. Live
        • 2. Approved
        • 3. borrower
        • 4. 2025-04-07 17:52:34
        • 5. 2025-05-07 17:52:34
        Backtrace
        • 13. /Modules/Application/Repositories/web/facade/Filters.php:201
        • 14. /Modules/Application/Repositories/web/facade/Filters.php:201
        • 15. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 17. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 30. /public/index.php:54
      • select count(*) as aggregate from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' and `applications`.`expiry_date` between '2025-04-07 17:52:34' and '2025-05-07 17:52:34' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc980μs/Modules/Application/Repositories/web/facade/Filters.php:205seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. 9
        • 1. Live
        • 2. Approved
        • 3. borrower
        • 4. 2025-04-07 17:52:34
        • 5. 2025-05-07 17:52:34
        Backtrace
        • 13. /Modules/Application/Repositories/web/facade/Filters.php:205
        • 14. /Modules/Application/Repositories/web/facade/Filters.php:205
        • 15. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 17. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 30. /public/index.php:54
      • select `cities`.`id`, `cities`.`city_name`, count(applications.id) as apps_count from `applications` left join `branches` on `branches`.`id` = `applications`.`branch_id` left join `students` on `applications`.`applicable_id` = `students`.`id` and `applications`.`applicable_type` = 'student' inner join `cities` on `cities`.`id` = `branches`.`city_id` or `cities`.`id` = `students`.`current_address_city_id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null group by `cities`.`id`1.58s/Modules/Application/Repositories/web/facade/Filters.php:254seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. student
        • 1. 9
        • 2. Live
        • 3. Approved
        Backtrace
        • 11. /Modules/Application/Repositories/web/facade/Filters.php:254
        • 12. /Modules/Application/Repositories/web/facade/Filters.php:209
        • 13. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 16. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 28. /public/index.php:54
      • select count(*) as aggregate from `applications` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applications`.`applicable_type` = 'student'950μs/Modules/Application/Repositories/web/facade/Filters.php:225seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. 9
        • 1. Live
        • 2. Approved
        • 3. student
        Backtrace
        • 13. /Modules/Application/Repositories/web/facade/Filters.php:225
        • 14. /Modules/Application/Repositories/web/facade/Filters.php:225
        • 15. /Modules/Application/Repositories/web/facade/Filters.php:213
        • 16. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 19. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 31. /public/index.php:54
      • select `students`.`gender`, count(applications.id) as students from `applications` inner join `students` on `applications`.`applicable_id` = `students`.`id` and `applications`.`applicable_type` = 'student' where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applications`.`applicable_type` = 'student' group by `students`.`gender`940μs/Modules/Application/Repositories/web/facade/Filters.php:232seedoutm_seedout_staging
        Metadata
        Bindings
        • 0. student
        • 1. 9
        • 2. Live
        • 3. Approved
        • 4. student
        Backtrace
        • 11. /Modules/Application/Repositories/web/facade/Filters.php:232
        • 12. /Modules/Application/Repositories/web/facade/Filters.php:213
        • 13. /Modules/Application/Repositories/web/facade/Filters.php:172
        • 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 16. /Modules/Application/Providers/ApplicationServiceProvider.php:44
        • 28. /public/index.php:54
      • select * from `cms_menu` order by `order` asc870μs/Modules/Cms/Repositories/web/facade/cms.php:285seedoutm_seedout_staging
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 11. /Modules/Cms/Repositories/web/facade/cms.php:285
        • 12. /Modules/Cms/Repositories/web/facade/cms.php:117
        • 13. /Modules/Cms/Repositories/web/facade/cms.php:94
        • 15. /Modules/Cms/Http/Controllers/Web/PagesController.php:201
        • 16. /Modules/Cms/Http/Controllers/Web/PagesController.php:201
        • 32. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
        • 42. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
        • 85. /app/Http/Middleware/HttpsProtocol.php:13
        • 90. /app/Http/Middleware/InitiateTheme.php:19
        • 104. /public/index.php:54
        users
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
        web
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
        api
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
          currency
          USD
          _token
          BNX3U5xuRy83BSW4kubxU2eqrpMlctLHc5ph2Cgb
          _previous
          array:1 [ "url" => "https://www.seedout.me/explore/donate-zakat-in-ramadan" ]
          PHPDEBUGBAR_STACK_DATA
          []
          format
          html
          content_type
          text/html; charset=UTF-8
          status_text
          OK
          status_code
          200
          request_query
          []
          request_request
          []
          request_headers
          array:20 [ "host" => array:1 [ 0 => "www.seedout.me" ] "x-forwarded-for" => array:1 [ ...
          request_server
          array:67 [ "TZ" => "Asia/Karachi" "REDIRECT_REDIRECT_UNIQUE_ID" => "Z_PKknmzPlKtv_r2OhC_lgAAAAM"...
          request_cookies
          []
          response_headers
          array:4 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
          path_info
          /explore/donate-zakat-in-ramadan
          session_attributes
          array:4 [ "currency" => "USD" "_token" => "BNX3U5xuRy83BSW4kubxU2eqrpMlctLHc5ph2Cgb" "_previou...