Назад Головна Лікарі

Пошук

Лікарі напряму "Хірург"

Дорослі Діти

Ковальова Лілія Юріївна

Ковальова Лілія Юріївна

Лікар-мамолог

Лікар-онколог
Лікар-онкохірург

22 роки медичного стажу

Детальніше

Записатися на прийом

Яковенко Владислав Олександрович

Яковенко Владислав Олександрович

Лікар-хірург-ендоскопіст

Кандидат медичних наук
Керівник напряму ендоскопії та малоінвазивної хірургії
30 років медичного стажу

Детальніше

Шуліга Оксана Василівна

Шуліга Оксана Василівна

Лікар-мамолог

Лікар-хірург
Лікар-онкохірург

Керівник Мамологічного центру
Експерт з естетичної мамопластики
Кандидат медичних наук
20 років медичного стажу

Детальніше

Записатися на прийом

Коваленко Андрій Євгенович

Коваленко Андрій Євгенович

Лікар-хірург-ендокринолог

Лікар-хірург
Лікар-онкохірург
Лікар-хірург дитячий

Вища кваліфікаційна категорія
Доктор медичних наук, професор
Професор кафедри хірургії та трансплантології НУОЗУ імені П.Л. Шупика
Член-кореспондент НАМН України
40 років медичного стажу

Детальніше

Котенко Іван Олегович

Котенко Іван Олегович

Лікар-хірург

Трансплантолог

стаж 3 роки

Детальніше

Михайлюк Оксана Сергіївна

Михайлюк Оксана Сергіївна

Лікар-хірург

Лікар-онкохірург

10 років медичного стажу (включаючи стаж роботи медсестрою, лікарський стаж – 6 років)

Детальніше

Мініч Артем Анатолійович

Мініч Артем Анатолійович

Лікар-хірург

Лікар-онкохірург
Лікар-трансплантолог

Кандидат медичних наук
13 років медичного стажу

Детальніше

Власенко Олександр Юрійович

Власенко Олександр Юрійович

Лікар-анестезіолог-інтенсивіст

7 років медичного стажу

Детальніше

Снєжко Єгор Валентинович

Снєжко Єгор Валентинович

Лікар-ендоскопіст

16 років медичного стажу

Детальніше

Messages Timeline Exceptions Views23 Route Queries14 Models97 Mails Session Request

7.4.33300ms7MBGET likari

Booting (233ms)
Application (67.1ms)
1 x Booting (77.5%)
232.63ms
1 x Application (22.35%)
67.10ms

23 templates were rendered

doctors.index (resources/views/doctors/index.blade.php)4blade
Params
0
page
1
doctors
2
specialties
3
types

partials.seo (resources/views/partials/seo.blade.php)11blade


__env
app
agent
errors
page
doctors
specialties
types
canonicalUrl
alternatePageLangs
isSeoNoIndex

components.breadcrumbs (resources/views/components/breadcrumbs.blade.php)5blade
Params
0
breadcrumbs
1
componentName
2
attributes
3
slot
4
__laravel_slots
partials.search_doctors (resources/views/partials/search_doctors.blade.php)9blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
doctors
6
specialties
7
types
8
component
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
doctors.partials.doctor (resources/views/doctors/partials/doctor.blade.php)2blade
Params
0
key
1
doctor
vendor.pagination.bootstrap-4-improved (resources/views/vendor/pagination/bootstrap-4-improved.blade.php)2blade
Params
0
paginator
1
elements
layouts.default (resources/views/layouts/default.blade.php)12blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
doctors
6
specialties
7
types
8
component
9
__currentLoopData
10
specialty
11
loop

partials.ie (resources/views/partials/ie.blade.php)12blade


__env
app
agent
errors
page
doctors
specialties
types
component
__currentLoopData
specialty
loop

components.header (resources/views/components/header.blade.php)7blade
Params
0
languages
1
type
2
currentLanguage
3
componentName
4
attributes
5
slot
6
__laravel_slots
components.left-menu (resources/views/components/left-menu.blade.php)7blade
Params
0
menu
1
type
2
socialIcons
3
componentName
4
attributes
5
slot
6
__laravel_slots

partials.footer.footer (resources/views/partials/footer/footer.blade.php)15blade


__env
app
agent
errors
page
doctors
specialties
types
component
__currentLoopData
specialty
loop
menu
doctorsPageUrl
departmentsPageUrl

partials.footer.footer_menu (resources/views/partials/footer/footer_menu.blade.php)15blade


__env
app
agent
errors
page
doctors
specialties
types
component
__currentLoopData
specialty
loop
menu
doctorsPageUrl
departmentsPageUrl

partials.footer.footer_menu_mobile (resources/views/partials/footer/footer_menu_mobile.blade.php)15blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
doctors
6
specialties
7
types
8
component
9
__currentLoopData
10
specialty
11
loop
12
menu
13
doctorsPageUrl
14
departmentsPageUrl
popups.popup-phones (resources/views/popups/popup-phones.blade.php)12blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
doctors
6
specialties
7
types
8
component
9
__currentLoopData
10
specialty
11
loop
popups.popup-response (resources/views/popups/popup-response.blade.php)12blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
doctors
6
specialties
7
types
8
component
9
__currentLoopData
10
specialty
11
loop

uri: GET likari
middleware: web
controller: App\Http\Controllers\DoctorsController@showAdultPage
namespace: App\Http\Controllers
prefix
where
as: doctors.adult
file: app/Http/Controllers/DoctorsController.php:11-19

14 statements were executed11.4ms

select * from `tb_tree` where `template` = 'doctors' limit 11.96msc1_dev_oberig
Metadata
Bindings
0. doctors
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
- EXPLAIN # 1: `tb_tree` (SIMPLE)371
Metadata
id 1
select_type SIMPLE
table tb_tree
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 37
filtered 10
Extra Using where
select * from `doctors_specialty` where exists (select * from `types` inner join `doctors_specialties_types` on `types`.`id` = `doctors_specialties_types`.`type_id` where `doctors_specialty`.`id` = `doctors_specialties_types`.`doctors_specialty_id` and `type_id` = 1) and exists (select * from `doctors` inner join `doctor_doctors_specialty` on `doctors`.`id` = `doctor_doctors_specialty`.`doctor_id` where `doctors_specialty`.`id` = `doctor_doctors_specialty`.`doctors_specialty_id` and exists (select * from `diagnostics` inner join `doctor_diagnostic` on `diagnostics`.`id` = `doctor_diagnostic`.`diagnostic_id` where `doctors`.`id` = `doctor_diagnostic`.`doctor_id` and `diagnostic_id` = '55')) and exists (select * from `doctors` inner join `doctor_doctors_specialty` on `doctors`.`id` = `doctor_doctors_specialty`.`doctor_id` where `doctors_specialty`.`id` = `doctor_doctors_specialty`.`doctors_specialty_id` and exists (select * from `types` inner join `doctor_type` on `types`.`id` = `doctor_type`.`type_id` where `doctors`.`id` = `doctor_type`.`doctor_id` and `type_id` = 1)) order by `title` asc3.38msc1_dev_oberig
Metadata
Bindings
0. 1
1. 55
2. 1
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `diagnostics` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table diagnostics
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 8
ref const
rows 1
filtered 100
Extra Using index; Using temporary; Using filesort
- EXPLAIN # 1: `types` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table types
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra Using index
- EXPLAIN # 1: `types` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table types
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra Using index

- EXPLAIN # 1: `doctor_diagnostic` (SIMPLE)101

Metadata
id	1
select_type	SIMPLE
table	doctor_diagnostic
partitions	null
type	ref
possible_keys	doctor_diagnostic_doctor_id_index,doctor_diagnostic_diagnostic_id_index
key	doctor_diagnostic_diagnostic_id_index
key_len	8
ref	const
rows	10
filtered	100
Extra	Start temporary

- EXPLAIN # 1: `doctors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table doctors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 8
ref c1_dev_oberig.doctor_diagnostic.doctor_id
rows 1
filtered 100
Extra Using index

- EXPLAIN # 1: `doctor_doctors_specialty` (SIMPLE)11

Metadata
id	1
select_type	SIMPLE
table	doctor_doctors_specialty
partitions	null
type	ref
possible_keys	doctor_doctors_specialty_doctor_id_index,doctor_doctors_specialty_doctors_specialty_id_index
key	doctor_doctors_specialty_doctor_id_index
key_len	8
ref	c1_dev_oberig.doctor_diagnostic.doctor_id
rows	1
filtered	100
Extra	null

- EXPLAIN # 1: `doctors_specialty` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table doctors_specialty
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref c1_dev_oberig.doctor_doctors_specialty.doctors_specialty_id
rows 1
filtered 100
Extra null

- EXPLAIN # 1: `doctors_specialties_types` (SIMPLE)11

Metadata
id	1
select_type	SIMPLE
table	doctors_specialties_types
partitions	null
type	ref
possible_keys	doctors_specialties_types_doctors_specialty_id_index,doctors_specialties_types_type_id_index
key	doctors_specialties_types_doctors_specialty_id_index
key_len	4
ref	c1_dev_oberig.doctor_doctors_specialty.doctors_specialty_id
rows	1
filtered	66.2921371459961
Extra	Using where

- EXPLAIN # 1: `doctor_doctors_specialty` (SIMPLE)21

Metadata
id	1
select_type	SIMPLE
table	doctor_doctors_specialty
partitions	null
type	ref
possible_keys	doctor_doctors_specialty_doctor_id_index,doctor_doctors_specialty_doctors_specialty_id_index
key	doctor_doctors_specialty_doctors_specialty_id_index
key_len	4
ref	c1_dev_oberig.doctor_doctors_specialty.doctors_specialty_id
rows	2
filtered	100
Extra	null

- EXPLAIN # 1: `doctor_type` (SIMPLE)11

Metadata
id	1
select_type	SIMPLE
table	doctor_type
partitions	null
type	ref
possible_keys	doctor_type_doctor_id_index,doctor_type_type_id_index
key	doctor_type_doctor_id_index
key_len	8
ref	c1_dev_oberig.doctor_doctors_specialty.doctor_id
rows	1
filtered	80.27210998535156
Extra	Using where

- EXPLAIN # 1: `doctors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table doctors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 8
ref c1_dev_oberig.doctor_doctors_specialty.doctor_id
rows 1
filtered 100
Extra Using index; End temporary
select * from `types` order by `id` asc260μsc1_dev_oberig
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
- EXPLAIN # 1: `types` (SIMPLE)21
Metadata
id 1
select_type SIMPLE
table types
partitions null
type index
possible_keys null
key PRIMARY
key_len 4
ref null
rows 2
filtered 100
Extra null
select count(*) as aggregate from `doctors` where exists (select * from `types` inner join `doctor_type` on `types`.`id` = `doctor_type`.`type_id` where `doctors`.`id` = `doctor_type`.`doctor_id` and `type_id` = 1) and exists (select * from `diagnostics` inner join `doctor_diagnostic` on `diagnostics`.`id` = `doctor_diagnostic`.`diagnostic_id` where `doctors`.`id` = `doctor_diagnostic`.`doctor_id` and `diagnostic_id` = '55') and `is_active` = '1'840μsc1_dev_oberig
Metadata
Bindings
0. 1
1. 55
2. 1
- EXPLAIN # 1: `types` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table types
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra Using index
- EXPLAIN # 1: `diagnostics` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table diagnostics
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 8
ref const
rows 1
filtered 100
Extra Using index

- EXPLAIN # 1: `doctor_diagnostic` (SIMPLE)101

Metadata
id	1
select_type	SIMPLE
table	doctor_diagnostic
partitions	null
type	ref
possible_keys	doctor_diagnostic_doctor_id_index,doctor_diagnostic_diagnostic_id_index
key	doctor_diagnostic_diagnostic_id_index
key_len	8
ref	const
rows	10
filtered	100
Extra	Start temporary

- EXPLAIN # 1: `doctors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table doctors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 8
ref c1_dev_oberig.doctor_diagnostic.doctor_id
rows 1
filtered 10
Extra Using where

- EXPLAIN # 1: `doctor_type` (SIMPLE)11

Metadata
id	1
select_type	SIMPLE
table	doctor_type
partitions	null
type	ref
possible_keys	doctor_type_doctor_id_index,doctor_type_type_id_index
key	doctor_type_doctor_id_index
key_len	8
ref	c1_dev_oberig.doctor_diagnostic.doctor_id
rows	1
filtered	80.27210998535156
Extra	Using where; End temporary

select * from `doctors` where exists (select * from `types` inner join `doctor_type` on `types`.`id` = `doctor_type`.`type_id` where `doctors`.`id` = `doctor_type`.`doctor_id` and `type_id` = 1) and exists (select * from `diagnostics` inner join `doctor_diagnostic` on `diagnostics`.`id` = `doctor_diagnostic`.`diagnostic_id` where `doctors`.`id` = `doctor_diagnostic`.`doctor_id` and `diagnostic_id` = '55') and `is_active` = '1' order by `is_manager` desc, RAND(1749049592) limit 12 offset 0940μsc1_dev_oberig
Metadata
Bindings
0. 1
1. 55
2. 1
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `types` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table types
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra Using index; Using temporary; Using filesort
- EXPLAIN # 1: `diagnostics` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table diagnostics
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 8
ref const
rows 1
filtered 100
Extra Using index

- EXPLAIN # 1: `doctor_diagnostic` (SIMPLE)101

Metadata
id	1
select_type	SIMPLE
table	doctor_diagnostic
partitions	null
type	ref
possible_keys	doctor_diagnostic_doctor_id_index,doctor_diagnostic_diagnostic_id_index
key	doctor_diagnostic_diagnostic_id_index
key_len	8
ref	const
rows	10
filtered	100
Extra	Start temporary

- EXPLAIN # 1: `doctors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table doctors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 8
ref c1_dev_oberig.doctor_diagnostic.doctor_id
rows 1
filtered 10
Extra Using where

- EXPLAIN # 1: `doctor_type` (SIMPLE)11

Metadata
id	1
select_type	SIMPLE
table	doctor_type
partitions	null
type	ref
possible_keys	doctor_type_doctor_id_index,doctor_type_type_id_index
key	doctor_type_doctor_id_index
key_len	8
ref	c1_dev_oberig.doctor_diagnostic.doctor_id
rows	1
filtered	80.27210998535156
Extra	Using where; End temporary

select `doctors_specialty`.*, `doctor_doctors_specialty`.`doctor_id` as `pivot_doctor_id`, `doctor_doctors_specialty`.`doctors_specialty_id` as `pivot_doctors_specialty_id` from `doctors_specialty` inner join `doctor_doctors_specialty` on `doctors_specialty`.`id` = `doctor_doctors_specialty`.`doctors_specialty_id` where `doctor_doctors_specialty`.`doctor_id` in (61, 81, 84, 115, 160, 167, 170, 198, 202)510μsc1_dev_oberig
Metadata

- EXPLAIN # 1: `doctor_doctors_specialty` (SIMPLE)201

Metadata
id	1
select_type	SIMPLE
table	doctor_doctors_specialty
partitions	null
type	range
possible_keys	doctor_doctors_specialty_doctor_id_index,doctor_doctors_specialty_doctors_specialty_id_index
key	doctor_doctors_specialty_doctor_id_index
key_len	8
ref	null
rows	20
filtered	100
Extra	Using index condition

- EXPLAIN # 1: `doctors_specialty` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table doctors_specialty
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref c1_dev_oberig.doctor_doctors_specialty.doctors_specialty_id
rows 1
filtered 100
Extra null
select `types`.*, `doctor_type`.`doctor_id` as `pivot_doctor_id`, `doctor_type`.`type_id` as `pivot_type_id` from `types` inner join `doctor_type` on `types`.`id` = `doctor_type`.`type_id` where `doctor_type`.`doctor_id` in (61, 81, 84, 115, 160, 167, 170, 198, 202)480μsc1_dev_oberig
Metadata
Hints
Use SELECT * only if you need all columns from table

- EXPLAIN # 1: `doctor_type` (SIMPLE)101

Metadata
id	1
select_type	SIMPLE
table	doctor_type
partitions	null
type	range
possible_keys	doctor_type_doctor_id_index,doctor_type_type_id_index
key	doctor_type_doctor_id_index
key_len	8
ref	null
rows	10
filtered	100
Extra	Using index condition

- EXPLAIN # 1: `types` (SIMPLE)21
Metadata
id 1
select_type SIMPLE
table types
partitions null
type ALL
possible_keys PRIMARY
key null
key_len null
ref null
rows 2
filtered 50
Extra Using where; Using join buffer (hash join)
select * from `seo` where `seo`.`seo_id` = 24 and `seo`.`seo_id` is not null and `seo`.`seo_type` = 'App\Models\Tree' limit 1340μsc1_dev_oberig
Metadata
Bindings
0. 24
1. App\Models\Tree
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
- EXPLAIN # 1: `seo` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table seo
partitions null
type ref
possible_keys seo_seo_id_seo_type_index
key seo_seo_id_seo_type_index
key_len 1026
ref const,const
rows 1
filtered 100
Extra null
select * from `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 24 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc660μsc1_dev_oberig
Metadata
Bindings
0. 24
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (PRIMARY)111
Metadata
id 1
select_type PRIMARY
table tb_tree
partitions null
type range
possible_keys tb_tree_lft_index,tb_tree_rgt_index
key tb_tree_lft_index
key_len 4
ref null
rows 11
filtered 94.59458923339844
Extra Using where
- EXPLAIN # 2: `_` (SUBQUERY)12
Metadata
id 2
select_type SUBQUERY
table _
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null
select * from `diagnostics` where `diagnostics`.`id` = '55' limit 1330μsc1_dev_oberig
Metadata
Bindings
0. 55
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
- EXPLAIN # 1: `diagnostics` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table diagnostics
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 8
ref const
rows 1
filtered 100
Extra null
select `menu_header`.*, (select count(*) from `menu_header` as `laravel_reserved_0` where `menu_header`.`id` = `laravel_reserved_0`.`parent_id`) as `children_count` from `menu_header` where `is_active` = 1 order by `lft` asc510μsc1_dev_oberig
Metadata
Bindings
0. 1
- EXPLAIN # 1: `menu_header` (PRIMARY)151
Metadata
id 1
select_type PRIMARY
table menu_header
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 15
filtered 10
Extra Using where; Using filesort

- EXPLAIN # 2: `laravel_reserved_0` (DEPENDENT SUBQUERY)32

Metadata
id	2
select_type	DEPENDENT SUBQUERY
table	laravel_reserved_0
partitions	null
type	ref
possible_keys	menu_header_parent_id_index
key	menu_header_parent_id_index
key_len	5
ref	c1_dev_oberig.menu_header.id
rows	3
filtered	100
Extra	Using where; Using index

select * from `tb_tree` where `tb_tree`.`id` in (2, 3, 4, 5, 7, 14, 23, 24, 25)480μsc1_dev_oberig
Metadata
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (SIMPLE)91
Metadata
id 1
select_type SIMPLE
table tb_tree
partitions null
type range
possible_keys PRIMARY
key PRIMARY
key_len 4
ref null
rows 9
filtered 100
Extra Using where
select * from `menu_header` where `menu_header`.`parent_id` in (1, 2, 3, 12, 15, 16, 18, 19, 20, 21, 23, 24, 26, 29) order by `lft` asc410μsc1_dev_oberig
Metadata
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `menu_header` (SIMPLE)151
Metadata
id 1
select_type SIMPLE
table menu_header
partitions null
type ALL
possible_keys menu_header_parent_id_index
key null
key_len null
ref null
rows 15
filtered 100
Extra Using where; Using filesort
select * from `social_networks` where `is_active` = 1 order by `priority` asc300μsc1_dev_oberig
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `social_networks` (SIMPLE)41
Metadata
id 1
select_type SIMPLE
table social_networks
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 4
filtered 25
Extra Using where; Using filesort

App\Models\SocialNetwork: 4
App\Models\MenuHeader: 28
App\Models\Diagnostic: 1
App\Models\MorphOne\Seo: 1
App\Models\Doctor: 9
App\Models\Type: 12
App\Models\DoctorsSpecialty: 30
App\Models\Tree: 12

_token: 0g76y4TcCyYuZIzUUnbWiPrbk7H26KP67ni4U9xk
doctors_rand: 1749049592
_previous: array:1 [ "url" => "https://oberig-dev.vis-design.com.ua/likari?diagnostic_id=55" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/likari

status_code

status_text

OK

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "diagnostic_id" => "55"
]

request_request

  0 of 0   
array:1 [▼
  "diagnostic_id" => "55"
]

request_headers

  0 of 0   
array:15 [▼
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "oberig-dev.vis-design.com.ua"
  ]
]

request_server

  0 of 0   
array:53 [▼
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "TEMP" => "/var/www/clients/client1/web116/tmp"
  "TMPDIR" => "/var/www/clients/client1/web116/tmp"
  "TMP" => "/var/www/clients/client1/web116/tmp"
  "HOSTNAME" => ""
  "USER" => "web116"
  "HOME" => "/var/www/clients/client1/web116"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/likari?diagnostic_id=55"
  "QUERY_STRING" => "diagnostic_id=55"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "diagnostic_id=55"
  "REDIRECT_URL" => "/likari"
  "REMOTE_PORT" => "21026"
  "SCRIPT_FILENAME" => "/var/www/clients/client1/web116/web/oberig/public/index.php"
  "SERVER_ADMIN" => "webmaster@oberig-dev.vis-design.com.ua"
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/clients/client1/web116/web/oberig/public"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/var/www/clients/client1/web116/web/oberig/public"
  "REMOTE_ADDR" => "3.138.103.112"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "148.251.123.135"
  "SERVER_NAME" => "oberig-dev.vis-design.com.ua"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "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"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "oberig-dev.vis-design.com.ua"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "oberig-dev.vis-design.com.ua"
  "HTTPS" => "on"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "oberig-dev.vis-design.com.ua"
  "REDIRECT_HTTPS" => "on"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1749049592.0284
  "REQUEST_TIME" => 1749049592
]

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 => "Wed, 04 Jun 2025 15:06:32 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImEyOTBoMzRRd25OYndCbU1jVnpPOWc9PSIsInZhbHVlIjoiRTlVdlJpVU4rWGF0Y04wY2FnR2tlTVg0a0U1aTFidU94STNodTZMa1hvcDRVczNjdE1ZTmRpdFdMRUlLVHF1VVNnbGkrTEpTUlFUdU5lUzBjYVU4TVRkcW5iMUJ6N0x4OUx6N1Y1dHl1NTJqczZyQ2tBaS8wTHdDd0U3V2ludFgiLCJtYWMiOiIwNTUxN2EzZGYxZWQ0Y2ZmOGY1MWQwNGYyNmI0OTIwMDE0MjNkNzcwMWI1ODExNWQ5ZWZlMWJmYjU3NjFjODhiIn0%3D; expires=Wed, 04-Jun-2025 17:06:32 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImEyOTBoMzRRd25OYndCbU1jVnpPOWc9PSIsInZhbHVlIjoiRTlVdlJpVU4rWGF0Y04wY2FnR2tlTVg0a0U1aTFidU94STNodTZMa1hvcDRVczNjdE1ZTmRpdFdMRUlLVHF1VVNnbGkrT ▶"
    1 => "oberig_dev_session=eyJpdiI6Ikw2bE1hcTh3TGhia3UwZVBVTFJsM1E9PSIsInZhbHVlIjoiclRGL1VCc1gycCt1UnJSc0pQYnFOT1FMdnNxMGxRa0FYakFTVlNpTXFFSm5DT2gvbCtQM3BqVHc2eXpwT29kSiszTHM1cmVPNXU3ZmFtMFEvVUg3U1ZmS3BsMitvaStTYUg3V3IrNDk3WVlXdXFYa2xVc2pxMm9CUjZLdHBSRmoiLCJtYWMiOiJjNDg4NmRjYmNiZTNiYWYyMzk3ZWY1OTdkYmNjNmE2NDA5ZDIwODQ0ZTUwNDI1N2E2OGQ2OTg2MGY3NzZmYTJlIn0%3D; expires=Wed, 04-Jun-2025 17:06:32 GMT; Max-Age=7200; path=/; httponly ◀oberig_dev_session=eyJpdiI6Ikw2bE1hcTh3TGhia3UwZVBVTFJsM1E9PSIsInZhbHVlIjoiclRGL1VCc1gycCt1UnJSc0pQYnFOT1FMdnNxMGxRa0FYakFTVlNpTXFFSm5DT2gvbCtQM3BqVHc2eXpwT29kS ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImEyOTBoMzRRd25OYndCbU1jVnpPOWc9PSIsInZhbHVlIjoiRTlVdlJpVU4rWGF0Y04wY2FnR2tlTVg0a0U1aTFidU94STNodTZMa1hvcDRVczNjdE1ZTmRpdFdMRUlLVHF1VVNnbGkrTEpTUlFUdU5lUzBjYVU4TVRkcW5iMUJ6N0x4OUx6N1Y1dHl1NTJqczZyQ2tBaS8wTHdDd0U3V2ludFgiLCJtYWMiOiIwNTUxN2EzZGYxZWQ0Y2ZmOGY1MWQwNGYyNmI0OTIwMDE0MjNkNzcwMWI1ODExNWQ5ZWZlMWJmYjU3NjFjODhiIn0%3D; expires=Wed, 04-Jun-2025 17:06:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImEyOTBoMzRRd25OYndCbU1jVnpPOWc9PSIsInZhbHVlIjoiRTlVdlJpVU4rWGF0Y04wY2FnR2tlTVg0a0U1aTFidU94STNodTZMa1hvcDRVczNjdE1ZTmRpdFdMRUlLVHF1VVNnbGkrT ▶"
    1 => "oberig_dev_session=eyJpdiI6Ikw2bE1hcTh3TGhia3UwZVBVTFJsM1E9PSIsInZhbHVlIjoiclRGL1VCc1gycCt1UnJSc0pQYnFOT1FMdnNxMGxRa0FYakFTVlNpTXFFSm5DT2gvbCtQM3BqVHc2eXpwT29kSiszTHM1cmVPNXU3ZmFtMFEvVUg3U1ZmS3BsMitvaStTYUg3V3IrNDk3WVlXdXFYa2xVc2pxMm9CUjZLdHBSRmoiLCJtYWMiOiJjNDg4NmRjYmNiZTNiYWYyMzk3ZWY1OTdkYmNjNmE2NDA5ZDIwODQ0ZTUwNDI1N2E2OGQ2OTg2MGY3NzZmYTJlIn0%3D; expires=Wed, 04-Jun-2025 17:06:32 GMT; path=/; httponly ◀oberig_dev_session=eyJpdiI6Ikw2bE1hcTh3TGhia3UwZVBVTFJsM1E9PSIsInZhbHVlIjoiclRGL1VCc1gycCt1UnJSc0pQYnFOT1FMdnNxMGxRa0FYakFTVlNpTXFFSm5DT2gvbCtQM3BqVHc2eXpwT29kS ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "0g76y4TcCyYuZIzUUnbWiPrbk7H26KP67ni4U9xk"
  "doctors_rand" => 1749049592
  "_previous" => array:1 [▶
    "url" => "https://oberig-dev.vis-design.com.ua/likari?diagnostic_id=55"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]