PharmEd
Filtr

Aktiv məhsullar

Son müsabiqələr

Adi müsabiqə

Premium

Reseptsiz premium

Premium

Premium Reseptli Müsabiqə

Prospal

MessagesTimelineExceptionsViews8RouteQueries8Models125MailsGateSessionRequest
Request history8.3.10PHP Version116msRequest Duration3MBMemory UsageGET aptek-mehsullariRoute
    • Booting (24.5ms)time
    • Application (91.05ms)time
    • 1 x Application (78.78%)
      91.05ms
      1 x Booting (21.2%)
      24.50ms
      8 templates were rendered
      • design.medicinesmedicines.blade.php#?blade
      • design.partials.medicines_listmedicines_list.blade.php#?blade
      • pagination::bootstrap-5bootstrap-5.blade.php#?blade
      • components.quiz-cardquiz-card.blade.php#?blade
      • components.quiz-cardquiz-card.blade.php#?blade
      • components.quiz-cardquiz-card.blade.php#?blade
      • components.quiz-cardquiz-card.blade.php#?blade
      • design.layoutlayout.blade.php#?blade
      uri
      GET aptek-mehsullari
      middleware
      web
      controller
      App\Http\Controllers\Frontend\MedicineController@index
      namespace
      App\Http\Controllers
      prefix
      where
      as
      frontend.medicine.index
      file
      app/Http/Controllers/Frontend/MedicineController.php:23-120
      8 statements were executed72.83ms
      • MedicineController.php#25pharmed_db_testConnection Established
        Backtrace
        • app/Http/Controllers/Frontend/MedicineController.php:25
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • MedicineController.php#65pharmed_db_test7.91msselect count(*) as aggregate from `sciences` inner join `medicine_category` on `sciences`.`category_id` = `medicine_category`.`id` where `status` = 'approved'
        Bindings
        • 0: approved
        Backtrace
        • app/Http/Controllers/Frontend/MedicineController.php:65
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • MedicineController.php#65pharmed_db_test8.46msselect * from `sciences` inner join `medicine_category` on `sciences`.`category_id` = `medicine_category`.`id` where `status` = 'approved' order by CASE WHEN medicine_category.parent_id = 2 THEN 0 ELSE 1 END, `sciences`.`science_name` asc limit 12 offset 168
        Bindings
        • 0: approved
        • 1: 2
        Backtrace
        • app/Http/Controllers/Frontend/MedicineController.php:65
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • MedicineController.php#86pharmed_db_test1.33msselect * from `quiz` where `quiz_type` = 1 and `is_deleted` = 0 order by `activated_at` desc limit 4
        Bindings
        • 0: 1
        • 1: 0
        Backtrace
        • app/Http/Controllers/Frontend/MedicineController.php:86
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • MedicineController.php#101pharmed_db_test1.03msselect `id`, `name` from `medicine_category` where `is_deleted` = 0 and `id` in (select `parent_id` from `medicine_category` where `is_deleted` = 0) order by `custom_order` asc
        Bindings
        • 0: 0
        • 1: 0
        Backtrace
        • app/Http/Controllers/Frontend/MedicineController.php:101
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • MedicineController.php#101pharmed_db_test1.17msselect `id`, `name`, `parent_id` from `medicine_category` where `parent_id` != `id` and `medicine_category`.`parent_id` in (1, 2, 3) and `is_deleted` = 0 order by `name` asc
        Bindings
        • 0: 0
        Backtrace
        • app/Http/Controllers/Frontend/MedicineController.php:101
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • MedicineController.php#103pharmed_db_test880μsselect * from `quiz_check` where `user_id` is null
        Backtrace
        • app/Http/Controllers/Frontend/MedicineController.php:103
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • AppServiceProvider.php#27pharmed_db_test51.02msselect * from `settings` limit 1
        Backtrace
        • app/Providers/AppServiceProvider.php:27
        • vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • vendor/laravel/framework/src/Illuminate/View/View.php:176
        • vendor/laravel/framework/src/Illuminate/View/View.php:147
        • view::design.medicines:442
      • AppServiceProvider.php#31pharmed_db_test1.03msselect * from `announcement` where `is_deleted` = 0 and `is_paid` = 1 and `is_active` = 0
        Bindings
        • 0: 0
        • 1: 1
        • 2: 0
        Backtrace
        • app/Providers/AppServiceProvider.php:31
        • vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • vendor/laravel/framework/src/Illuminate/View/View.php:176
        • vendor/laravel/framework/src/Illuminate/View/View.php:147
        • view::design.medicines:442
      App\Models\MedicineCategory
      107MedicineCategory.php#?
      App\Models\Medicine
      12Medicine.php#?
      App\Models\Quiz
      4Quiz.php#?
      App\Models\Settings
      1Settings.php#?
      App\Models\Announcement
      1Announcement.php#?
          _token
          R3PAn1YfClNrnkXOcZi8LIU2Vd7WZCiYLl2wNvLr
          _previous
          array:1 [ "url" => "http://pharmed.kripton.az/aptek-mehsullari?page=15" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /aptek-mehsullari
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
            0 of 0   
          array:1 [▼
  "page" => "15"
]
          request_request
          []
          request_headers
            0 of 0   
          array:28 [▼
  "host" => array:1 [▶
    0 => "pharmed.kripton.az"
  ]
  "x-request-id" => array:1 [▶
    0 => "3a727dd88492dd152938ca8f874a4b5b"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.69.7.158"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "172.69.7.158"
  ]
  "x-forwarded-host" => array:1 [▶
    0 => "pharmed.kripton.az"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "443"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-scheme" => array:1 [▶
    0 => "https"
  ]
  "x-original-forwarded-for" => array:1 [▶
    0 => "216.73.216.23"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "cf-ray" => array:1 [▶
    0 => "954d3f023e5860ae-ORD"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "216.73.216.23"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
]
          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 => "Tue, 24 Jun 2025 15:26:54 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjJmOHdlcklHTGxsbUpoN0E4TjhQRFE9PSIsInZhbHVlIjoiUW9wYTU5d0FCbkxkNDBCb2NjbkdCMHEzQ1RYUEd6cUdMeXlHKzF1Y0pqajl6R1o3Yis0Z1Z6TytNQVB3NlZsVTNJL290cFl3MlF1aUg4eStTY3l4ZldqNUtOcjVyVGhvQ2ViOU9ycVRyK0lkc1pRNUx4OGRWL3dMVkV2Ry9XdlIiLCJtYWMiOiIzNzNmMWQ1N2Y5NzU2NzhmMTFlMGU3NjI0Y2U1YTE5NWU5Yzk2ZGU3OTQzMzMwYTU0NjcxNWU0MmZkNTlkOTQyIiwidGFnIjoiIn0%3D; expires=Tue, 24 Jun 2025 17:26:54 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjJmOHdlcklHTGxsbUpoN0E4TjhQRFE9PSIsInZhbHVlIjoiUW9wYTU5d0FCbkxkNDBCb2NjbkdCMHEzQ1RYUEd6cUdMeXlHKzF1Y0pqajl6R1o3Yis0Z1Z6TytNQVB3NlZsVTNJL290c ▶"
    1 => "pharmed_session=eyJpdiI6Ii9xUnl1Z3UyYmNHYlRXWkNRbnMwZEE9PSIsInZhbHVlIjoiMGFZaWVNN2V1enU3K3hVRUpsYm1saXNsVCsvY2hDcVMza1psTmM5bXhMekxML1RaLzdhMlVjVjFSMjhuLytPcjh1QzJCbGUvOXROdWFXcEV1eVEzeGN2WkFoZTdjZktzRXcwK2puWHRoR2d4NXRZSU1FOEM2V0o4SG5yTkFlVUQiLCJtYWMiOiJlNDgxYWZiYjFhOTI5YTUxZDE3ZjY1YzJhNjViMzI2NmYwNzdmOWIzMTg3OGVlNzIwYWI1ZWExZWQ3NTU2OTZmIiwidGFnIjoiIn0%3D; expires=Tue, 24 Jun 2025 17:26:54 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀pharmed_session=eyJpdiI6Ii9xUnl1Z3UyYmNHYlRXWkNRbnMwZEE9PSIsInZhbHVlIjoiMGFZaWVNN2V1enU3K3hVRUpsYm1saXNsVCsvY2hDcVMza1psTmM5bXhMekxML1RaLzdhMlVjVjFSMjhuLytPcjh1 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjJmOHdlcklHTGxsbUpoN0E4TjhQRFE9PSIsInZhbHVlIjoiUW9wYTU5d0FCbkxkNDBCb2NjbkdCMHEzQ1RYUEd6cUdMeXlHKzF1Y0pqajl6R1o3Yis0Z1Z6TytNQVB3NlZsVTNJL290cFl3MlF1aUg4eStTY3l4ZldqNUtOcjVyVGhvQ2ViOU9ycVRyK0lkc1pRNUx4OGRWL3dMVkV2Ry9XdlIiLCJtYWMiOiIzNzNmMWQ1N2Y5NzU2NzhmMTFlMGU3NjI0Y2U1YTE5NWU5Yzk2ZGU3OTQzMzMwYTU0NjcxNWU0MmZkNTlkOTQyIiwidGFnIjoiIn0%3D; expires=Tue, 24-Jun-2025 17:26:54 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjJmOHdlcklHTGxsbUpoN0E4TjhQRFE9PSIsInZhbHVlIjoiUW9wYTU5d0FCbkxkNDBCb2NjbkdCMHEzQ1RYUEd6cUdMeXlHKzF1Y0pqajl6R1o3Yis0Z1Z6TytNQVB3NlZsVTNJL290c ▶"
    1 => "pharmed_session=eyJpdiI6Ii9xUnl1Z3UyYmNHYlRXWkNRbnMwZEE9PSIsInZhbHVlIjoiMGFZaWVNN2V1enU3K3hVRUpsYm1saXNsVCsvY2hDcVMza1psTmM5bXhMekxML1RaLzdhMlVjVjFSMjhuLytPcjh1QzJCbGUvOXROdWFXcEV1eVEzeGN2WkFoZTdjZktzRXcwK2puWHRoR2d4NXRZSU1FOEM2V0o4SG5yTkFlVUQiLCJtYWMiOiJlNDgxYWZiYjFhOTI5YTUxZDE3ZjY1YzJhNjViMzI2NmYwNzdmOWIzMTg3OGVlNzIwYWI1ZWExZWQ3NTU2OTZmIiwidGFnIjoiIn0%3D; expires=Tue, 24-Jun-2025 17:26:54 GMT; path=/; httponly ◀pharmed_session=eyJpdiI6Ii9xUnl1Z3UyYmNHYlRXWkNRbnMwZEE9PSIsInZhbHVlIjoiMGFZaWVNN2V1enU3K3hVRUpsYm1saXNsVCsvY2hDcVMza1psTmM5bXhMekxML1RaLzdhMlVjVjFSMjhuLytPcjh1 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "R3PAn1YfClNrnkXOcZi8LIU2Vd7WZCiYLl2wNvLr"
  "_previous" => array:1 [▶
    "url" => "http://pharmed.kripton.az/aptek-mehsullari?page=15"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-06-24 19:26:54GET/aptek-mehsullari?page=1588125