Назад Головна Пацієнтам

Пошук

Імпендансометрія-рН

Підготовка до дослідження:

В день проведення дослідження виключити прийом їжі та рідини.
напередодні дослідження рекомендується легка вечеря не пізніше ніж за 3 години перед сном.
Якщо Ви приймаєте регулярно медикаментозні препарати - прийом цих препаратів повинен бути за 3 год до призначеної процедури.
У тому випадку, якщо Ви приймаєте ІПП (інгібітори протонної помпи), - Ви маєте скасувати їх прийом за 14 днів до дослідження (якщо лікар не надав інші рекомендації).
У тому випадку, якщо Ви приймаєте Н₂-блокатори, антациди – відмініть прийом препаратів за 1 день до дослідження.

Увага! Для проведення дослідження імпендансометрії- рН необхідно:

направлення лікаря-гастроентеролога або ендоскопіста, результати ЕКГ (не старше 1 міс) та дані езофагогастродуоденоскопії – ЕГДС (не старше 12 міс).

Друк

Messages Timeline Exceptions Views14 Route Queries36 Models96 Mails Session Request

7.4.33357ms23MBGET preparation-survey/{slug}-{id}

Booting (232ms)
Application (123ms)
1 x Booting (65.02%)
232.00ms
1 x Application (34.45%)
122.91ms

14 templates were rendered

patients.preparation-survey (resources/views/patients/preparation-survey.blade.php)2blade
Params
0
page
1
patientsCatalog

Params
0	`page`
1	`patientsCatalog`

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


__env
app
agent
errors
page
patientsCatalog
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 (resources/views/partials/search.blade.php)7blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
partials.seo_text (resources/views/partials/seo_text.blade.php)7blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
layouts.default (resources/views/layouts/default.blade.php)7blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
partials.ie (resources/views/partials/ie.blade.php)7blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
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)10blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
7
menu
8
doctorsPageUrl
9
departmentsPageUrl
partials.footer.footer_menu (resources/views/partials/footer/footer_menu.blade.php)10blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
7
menu
8
doctorsPageUrl
9
departmentsPageUrl
partials.footer.footer_menu_mobile (resources/views/partials/footer/footer_menu_mobile.blade.php)10blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
7
menu
8
doctorsPageUrl
9
departmentsPageUrl
popups.popup-phones (resources/views/popups/popup-phones.blade.php)7blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component
popups.popup-response (resources/views/popups/popup-response.blade.php)7blade
Params
0
__env
1
app
2
agent
3
errors
4
page
5
patientsCatalog
6
component

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`canonicalUrl`
7	`alternatePageLangs`
8	`isSeoNoIndex`

Params
0	`breadcrumbs`
1	`componentName`
2	`attributes`
3	`slot`
4	`__laravel_slots`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`

Params
0	`languages`
1	`type`
2	`currentLanguage`
3	`componentName`
4	`attributes`
5	`slot`
6	`__laravel_slots`

Params
0	`menu`
1	`type`
2	`socialIcons`
3	`componentName`
4	`attributes`
5	`slot`
6	`__laravel_slots`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`
7	`menu`
8	`doctorsPageUrl`
9	`departmentsPageUrl`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`
7	`menu`
8	`doctorsPageUrl`
9	`departmentsPageUrl`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`
7	`menu`
8	`doctorsPageUrl`
9	`departmentsPageUrl`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`

Params
0	`__env`
1	`app`
2	`agent`
3	`errors`
4	`page`
5	`patientsCatalog`
6	`component`

uri: GET preparation-survey/{slug}-{id}
middleware: web
controller: App\Http\Controllers\PrepareToDiagnosticController@page
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/PrepareToDiagnosticController.php:18-24

36 statements were executed, 2 of which were duplicated, 34 unique14.08ms

select * from `preparation_survey` where `id` = '64' and `is_active` = '1' limit 1420μsc1_dev_oberig
Metadata
Bindings
0. 64
1. 1
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: `preparation_survey` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table preparation_survey
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null
select * from `tb_tree` where `template` = 'prepare_to_diagnostic' limit 1380μsc1_dev_oberig
Metadata
Bindings
0. prepare_to_diagnostic
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

Metadata
Bindings	0. 64 1. 1
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

Metadata
Bindings	0. prepare_to_diagnostic
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

select * from `seo` where `seo`.`seo_id` = 64 and `seo`.`seo_id` is not null and `seo`.`seo_type` = 'App\Models\PreparationSurvey' limit 1

400μsc1_dev_oberig

Metadata
Bindings	0. 64 1. App\Models\PreparationSurvey
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 `settings` where `slug` like 'emails-callback-form' limit 1370μsc1_dev_oberig
Metadata
Bindings
0. emails-callback-form
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `settings` where `slug` like 'contact-phone' limit 1220μsc1_dev_oberig
Metadata
Bindings
0. contact-phone
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 14 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc620μsc1_dev_oberig
Metadata
Bindings
0. 14
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. emails-callback-form
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

Metadata
Bindings	0. contact-phone
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

Metadata
Bindings	0. 14
Hints	Use `SELECT *` only if you need all columns from table

- EXPLAIN # 1: `tb_tree` (PRIMARY)221

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_rgt_index
key_len	4
ref	null
rows	22
filtered	64.86486053466797
Extra	Using where; Using filesort

- 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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 1 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc420μsc1_dev_oberig
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (PRIMARY)11
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_rgt_index
key_len 4
ref null
rows 1
filtered 100
Extra Using where; Using filesort
- 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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 14 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc540μsc1_dev_oberig
Metadata
Bindings
0. 14
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 14
Hints	Use `SELECT *` only if you need all columns from table

- EXPLAIN # 1: `tb_tree` (PRIMARY)221

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_rgt_index
key_len	4
ref	null
rows	22
filtered	64.86486053466797
Extra	Using where; Using filesort

- 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 `settings` where `slug` like 'head-tag-scripts' limit 1270μsc1_dev_oberig
Metadata
Bindings
0. head-tag-scripts
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `settings` where `slug` like 'google-chrome' limit 1170μsc1_dev_oberig
Metadata
Bindings
0. google-chrome
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `settings` where `slug` like 'firefox' limit 1170μsc1_dev_oberig
Metadata
Bindings
0. firefox
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `settings` where `slug` like 'microsoft-edge' limit 1170μsc1_dev_oberig
Metadata
Bindings
0. microsoft-edge
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `settings` where `slug` like 'body-tag-start-scripts' limit 1160μsc1_dev_oberig
Metadata
Bindings
0. body-tag-start-scripts
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `settings` where `slug` like 'zapisatis-na-priiom' limit 1190μsc1_dev_oberig
Metadata
Bindings
0. zapisatis-na-priiom
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
select * from `settings` where `slug` like 'osobistii-kabinet' limit 1170μsc1_dev_oberig
Metadata
Bindings
0. osobistii-kabinet
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where
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` asc490μ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

Metadata
Bindings	0. head-tag-scripts
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

Metadata
Bindings	0. google-chrome
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

Metadata
Bindings	0. firefox
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

Metadata
Bindings	0. microsoft-edge
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

Metadata
Bindings	0. body-tag-start-scripts
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

Metadata
Bindings	0. zapisatis-na-priiom
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

Metadata
Bindings	0. osobistii-kabinet
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

Metadata
Bindings	0. 1

- 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)490μ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` asc350μ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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 4 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc570μsc1_dev_oberig
Metadata
Bindings
0. 4
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (PRIMARY)151
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 15
filtered 83.78378295898438
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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 23 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc540μsc1_dev_oberig
Metadata
Bindings
0. 23
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (PRIMARY)121
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 12
filtered 91.89189147949219
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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 25 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc460μsc1_dev_oberig
Metadata
Bindings
0. 25
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (PRIMARY)91
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 9
filtered 100
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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 3 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc480μsc1_dev_oberig
Metadata
Bindings
0. 3
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (PRIMARY)101
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 10
filtered 97.29730224609375
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 `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` asc460μ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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 7 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc450μsc1_dev_oberig
Metadata
Bindings
0. 7
Hints
Use SELECT * only if you need all columns from table

- EXPLAIN # 1: `tb_tree` (PRIMARY)161

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_rgt_index
key_len	4
ref	null
rows	16
filtered	81.0810775756836
Extra	Using where; Using filesort

- 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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 5 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc400μsc1_dev_oberig
Metadata
Bindings
0. 5
Hints
Use SELECT * only if you need all columns from table

- EXPLAIN # 1: `tb_tree` (PRIMARY)151

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_rgt_index
key_len	4
ref	null
rows	15
filtered	83.78378295898438
Extra	Using where; Using filesort

- 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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 2 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc400μsc1_dev_oberig
Metadata
Bindings
0. 2
Hints
Use SELECT * only if you need all columns from table

- EXPLAIN # 1: `tb_tree` (PRIMARY)121

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_rgt_index
key_len	4
ref	null
rows	12
filtered	91.89189147949219
Extra	Using where; Using filesort

- 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 `social_networks` where `is_active` = 1 order by `priority` asc200μ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
select * from `footer_menu` where `is_active` = 1 order by `lft` asc970μsc1_dev_oberig
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `footer_menu` (SIMPLE)51
Metadata
id 1
select_type SIMPLE
table footer_menu
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 5
filtered 20
Extra Using where; Using filesort
select * from `tb_tree` where `is_active` = '1' and `tb_tree`.`id` in (2, 19, 20, 21)350μsc1_dev_oberig
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `tb_tree` (SIMPLE)41
Metadata
id 1
select_type SIMPLE
table tb_tree
partitions null
type range
possible_keys PRIMARY
key PRIMARY
key_len 4
ref null
rows 4
filtered 10
Extra Using where
select * from `footer_menu` where `footer_menu`.`parent_id` in (1, 2, 3, 4, 7) order by `lft` asc250μsc1_dev_oberig
Metadata
Hints
Use SELECT * only if you need all columns from table
- EXPLAIN # 1: `footer_menu` (SIMPLE)51
Metadata
id 1
select_type SIMPLE
table footer_menu
partitions null
type ALL
possible_keys footer_menu_parent_id_index
key null
key_len null
ref null
rows 5
filtered 100
Extra Using where; Using filesort
select * from `tb_tree` where `template` = 'doctors' and `is_active` = 1 limit 1360μsc1_dev_oberig
Metadata
Bindings
0. doctors
1. 1
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 2.702702522277832
Extra Using where
select * from `tb_tree` where `template` = 'departments' and `is_active` = 1 limit 1270μsc1_dev_oberig
Metadata
Bindings
0. departments
1. 1
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 2.702702522277832
Extra Using where
select * from `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 19 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc560μsc1_dev_oberig
Metadata
Bindings
0. 19
Hints
Use SELECT * only if you need all columns from table

- EXPLAIN # 1: `tb_tree` (PRIMARY)141

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_rgt_index
key_len	4
ref	null
rows	14
filtered	86.48648834228516
Extra	Using where; Using filesort

- 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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 21 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc530μsc1_dev_oberig
Metadata
Bindings
0. 21
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_rgt_index
key_len	4
ref	null
rows	11
filtered	94.59458923339844
Extra	Using where; Using filesort

- 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 `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 20 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc540μsc1_dev_oberig
Metadata
Bindings
0. 20
Hints
Use SELECT * only if you need all columns from table

- EXPLAIN # 1: `tb_tree` (PRIMARY)131

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_rgt_index
key_len	4
ref	null
rows	13
filtered	89.1891860961914
Extra	Using where; Using filesort

- 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 `settings` where `slug` like 'body-tag-end-scripts' limit 1290μsc1_dev_oberig
Metadata
Bindings
0. body-tag-end-scripts
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: `settings` (SIMPLE)211
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 21
filtered 11.110000610351562
Extra Using where

App\Models\MenuFooter: 9
App\Models\SocialNetwork: 4
App\Models\MenuHeader: 28
Vis\Builder\Setting: 10
App\Models\MorphOne\Seo: 1
App\Models\Tree: 43
App\Models\PreparationSurvey: 1

_token: UpGLZ4ZQiF4MDN2WBUvP68RG3BfcZFnhFYjVl36Z
_previous: array:1 [ "url" => "https://oberig-dev.vis-design.com.ua/preparation-survey/impendansometriya-rn-6...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/preparation-survey/impendansometriya-rn-64

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "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:52 [▼
  "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" => "/preparation-survey/impendansometriya-rn-64"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/preparation-survey/impendansometriya-rn-64"
  "REMOTE_PORT" => "58733"
  "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" => "18.188.87.95"
  "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "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" => 1744038527.1439
  "REQUEST_TIME" => 1744038527
]

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 => "Mon, 07 Apr 2025 15:08:47 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktFTENPTkJzM2EzRDQ1aC96Y0s0bVE9PSIsInZhbHVlIjoiZXljdkNxdU5SY0lTcXF4TVNMdDFIYUxIUTBlYU1vaFlReTJwSlFSSnMwQlc4RlhZZlBzVHdXRlJJR3dMSTh4V1dqRDhKMzRGUVJlTjU0MElpVzNzOXJnTHZWbURSTW93NEgrRHhMWnJUUEhobGJsaU1PdFRQdWVFMnczaTJ6alciLCJtYWMiOiIxY2NkNjAwYWZkMThmODRmYzEyYmQ2ZjViNzE0Y2E2YjUzYzU5ZjU3NThiYzNmMTM1Mjg4ZjZkMjIzMThmNDZjIn0%3D; expires=Mon, 07-Apr-2025 17:08:47 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IktFTENPTkJzM2EzRDQ1aC96Y0s0bVE9PSIsInZhbHVlIjoiZXljdkNxdU5SY0lTcXF4TVNMdDFIYUxIUTBlYU1vaFlReTJwSlFSSnMwQlc4RlhZZlBzVHdXRlJJR3dMSTh4V1dqRDhKM ▶"
    1 => "oberig_dev_session=eyJpdiI6IjZyRVU5d1lKUmFqOG5TY2NPWmdOVXc9PSIsInZhbHVlIjoiZEJXWmg1bU8wMWxvMnVhRTBEOVhNNlJRcUgxOVFnWkZCendSNFpNUGIyQjRLZ3o5aVFMaFNmdXNKNHp5RWxJak9xM0ZTb1RlZnRoTTlJKy9TWVU3L0J6azV6NlIwbktSUW1vUm5oZkxtQUxvM0JHWHpmY3l3eEZreUh2MnVMeCsiLCJtYWMiOiI2OTljZGY5N2EyNjBmZTQ5MzhiNGU0MmEzM2YwYWQ1ZjJkNDIxMGRiNTFkMzY1YWQ4MDljYzM4NmJhNTEwNThiIn0%3D; expires=Mon, 07-Apr-2025 17:08:47 GMT; Max-Age=7200; path=/; httponly ◀oberig_dev_session=eyJpdiI6IjZyRVU5d1lKUmFqOG5TY2NPWmdOVXc9PSIsInZhbHVlIjoiZEJXWmg1bU8wMWxvMnVhRTBEOVhNNlJRcUgxOVFnWkZCendSNFpNUGIyQjRLZ3o5aVFMaFNmdXNKNHp5RWxJa ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktFTENPTkJzM2EzRDQ1aC96Y0s0bVE9PSIsInZhbHVlIjoiZXljdkNxdU5SY0lTcXF4TVNMdDFIYUxIUTBlYU1vaFlReTJwSlFSSnMwQlc4RlhZZlBzVHdXRlJJR3dMSTh4V1dqRDhKMzRGUVJlTjU0MElpVzNzOXJnTHZWbURSTW93NEgrRHhMWnJUUEhobGJsaU1PdFRQdWVFMnczaTJ6alciLCJtYWMiOiIxY2NkNjAwYWZkMThmODRmYzEyYmQ2ZjViNzE0Y2E2YjUzYzU5ZjU3NThiYzNmMTM1Mjg4ZjZkMjIzMThmNDZjIn0%3D; expires=Mon, 07-Apr-2025 17:08:47 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IktFTENPTkJzM2EzRDQ1aC96Y0s0bVE9PSIsInZhbHVlIjoiZXljdkNxdU5SY0lTcXF4TVNMdDFIYUxIUTBlYU1vaFlReTJwSlFSSnMwQlc4RlhZZlBzVHdXRlJJR3dMSTh4V1dqRDhKM ▶"
    1 => "oberig_dev_session=eyJpdiI6IjZyRVU5d1lKUmFqOG5TY2NPWmdOVXc9PSIsInZhbHVlIjoiZEJXWmg1bU8wMWxvMnVhRTBEOVhNNlJRcUgxOVFnWkZCendSNFpNUGIyQjRLZ3o5aVFMaFNmdXNKNHp5RWxJak9xM0ZTb1RlZnRoTTlJKy9TWVU3L0J6azV6NlIwbktSUW1vUm5oZkxtQUxvM0JHWHpmY3l3eEZreUh2MnVMeCsiLCJtYWMiOiI2OTljZGY5N2EyNjBmZTQ5MzhiNGU0MmEzM2YwYWQ1ZjJkNDIxMGRiNTFkMzY1YWQ4MDljYzM4NmJhNTEwNThiIn0%3D; expires=Mon, 07-Apr-2025 17:08:47 GMT; path=/; httponly ◀oberig_dev_session=eyJpdiI6IjZyRVU5d1lKUmFqOG5TY2NPWmdOVXc9PSIsInZhbHVlIjoiZEJXWmg1bU8wMWxvMnVhRTBEOVhNNlJRcUgxOVFnWkZCendSNFpNUGIyQjRLZ3o5aVFMaFNmdXNKNHp5RWxJa ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "UpGLZ4ZQiF4MDN2WBUvP68RG3BfcZFnhFYjVl36Z"
  "_previous" => array:1 [▶
    "url" => "https://oberig-dev.vis-design.com.ua/preparation-survey/impendansometriya-rn-64"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Booting (65.02%)	232.00ms
1 x Application (34.45%)	122.91ms

Metadata
id	1
select_type	SIMPLE
table	preparation_survey
partitions	null
type	const
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	const
rows	1
filtered	100
Extra	null

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

Metadata
Bindings	0. 4
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 23
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 25
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 3
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 7
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 5
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 2
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. doctors 1. 1
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

Metadata
Bindings	0. departments 1. 1
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

Metadata
Bindings	0. 19
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 21
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 20
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. body-tag-end-scripts
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