7.4.33PHP Version1.45sRequest Duration7MBMemory UsageGET en/pacijentam/podhotovka-k-obsledovanyyuRoute
    • Booting (568ms)
    • Application (883ms)
    • 1 x Application (60.85%)
      882.74ms
      1 x Booting (39.13%)
      567.62ms
      13 templates were rendered
      • patients.prepare_to_diagnostic (resources/views/patients/prepare_to_diagnostic.blade.php)4blade
        Params
        0
        page
        1
        structuredSurveysAlpha
        2
        surveys
        3
        menu
      • partials.seo (resources/views/partials/seo.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        canonicalUrl
        9
        alternatePageLangs
        10
        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)10blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        title
      • layouts.default (resources/views/layouts/default.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        __currentLoopData
        10
        char
        11
        loop
        12
        surveyList
        13
        survey
      • partials.ie (resources/views/partials/ie.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        __currentLoopData
        10
        char
        11
        loop
        12
        surveyList
        13
        survey
      • 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)16blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        __currentLoopData
        10
        char
        11
        loop
        12
        surveyList
        13
        survey
        14
        doctorsPageUrl
        15
        departmentsPageUrl
      • partials.footer.footer_menu (resources/views/partials/footer/footer_menu.blade.php)16blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        __currentLoopData
        10
        char
        11
        loop
        12
        surveyList
        13
        survey
        14
        doctorsPageUrl
        15
        departmentsPageUrl
      • partials.footer.footer_menu_mobile (resources/views/partials/footer/footer_menu_mobile.blade.php)16blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        __currentLoopData
        10
        char
        11
        loop
        12
        surveyList
        13
        survey
        14
        doctorsPageUrl
        15
        departmentsPageUrl
      • popups.popup-phones (resources/views/popups/popup-phones.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        __currentLoopData
        10
        char
        11
        loop
        12
        surveyList
        13
        survey
      • popups.popup-response (resources/views/popups/popup-response.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        agent
        3
        errors
        4
        page
        5
        structuredSurveysAlpha
        6
        surveys
        7
        menu
        8
        component
        9
        __currentLoopData
        10
        char
        11
        loop
        12
        surveyList
        13
        survey
      uri
      GET en/pacijentam/podhotovka-k-obsledovanyyu
      middleware
      web
      controller
      App\Http\Controllers\PrepareToDiagnosticController@showAdultPage
      namespace
      App\Http\Controllers
      prefix
      /en
      where
      as
      patients.adult
      file
      app/Http/Controllers/PrepareToDiagnosticController.php:37-52
      38 statements were executed322ms
      • select * from `tb_tree` where `id` = 39 limit 1590μsc1_dev_oberig
        Metadata
        Bindings
        • 0. 39
        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)11
        Metadata
        id1
        select_typeSIMPLE
        tabletb_tree
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `preparation_survey` where `type_id` = 1 and `is_active` = '1'298msc1_dev_oberig
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • - EXPLAIN # 1: `preparation_survey` (SIMPLE)321
        Metadata
        id1
        select_typeSIMPLE
        tablepreparation_survey
        partitionsnull
        typeref
        possible_keyspreparation_survey_type_id_index
        keypreparation_survey_type_id_index
        key_len5
        refconst
        rows32
        filtered10
        ExtraUsing where
      • select * from `preparation_survey` where `type_id` = 1 and `is_active` = '1' and `title_en` LIKE 'R%' and `is_active` = '1' order by `title_en` asc900μsc1_dev_oberig
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. R%
        • 3. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • - EXPLAIN # 1: `preparation_survey` (SIMPLE)321
        Metadata
        id1
        select_typeSIMPLE
        tablepreparation_survey
        partitionsnull
        typeref
        possible_keyspreparation_survey_type_id_index
        keypreparation_survey_type_id_index
        key_len5
        refconst
        rows32
        filtered3.846153974533081
        ExtraUsing where; Using filesort
      • select * from `tb_tree` where `tb_tree`.`parent_id` = 39 and `tb_tree`.`parent_id` is not null and `is_show_right_menu` = 1 and `is_active` = 1 order by `lft` asc, `lft` asc9.15msc1_dev_oberig
        Metadata
        Bindings
        • 0. 39
        • 1. 1
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • - EXPLAIN # 1: `tb_tree` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tabletb_tree
        partitionsnull
        typeref
        possible_keystb_tree_parent_id_foreign
        keytb_tree_parent_id_foreign
        key_len5
        refconst
        rows1
        filtered5
        ExtraUsing where; Using filesort
      • select * from `seo` where `seo`.`seo_id` = 39 and `seo`.`seo_id` is not null and `seo`.`seo_type` = 'App\Models\Tree' limit 1580μsc1_dev_oberig
        Metadata
        Bindings
        • 0. 39
        • 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
        id1
        select_typeSIMPLE
        tableseo
        partitionsnull
        typeref
        possible_keysseo_seo_id_seo_type_index
        keyseo_seo_id_seo_type_index
        key_len1026
        refconst,const
        rows1
        filtered100
        Extranull
      • select * from `settings` where `slug` like 'emails-callback-form' limit 1480μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing where
      • select * from `settings` where `slug` like 'contact-phone' limit 1230μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing where
      • select * from `tb_tree` where ((select `_`.`rgt` from `tb_tree` as `_` where `id` = 39 limit 1) between `tb_tree`.`lft` and `tb_tree`.`rgt`) order by `lft` asc640μsc1_dev_oberig
        Metadata
        Bindings
        • 0. 39
        Hints
        • Use SELECT * only if you need all columns from table
      • - EXPLAIN # 1: `tb_tree` (PRIMARY)171
        Metadata
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_lft_index
        key_len4
        refnull
        rows17
        filtered81.0810775756836
        ExtraUsing where
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc430μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows1
        filtered100
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc510μsc1_dev_oberig
        Metadata
        Bindings
        • 0. 14
        Hints
        • Use SELECT * only if you need all columns from table
      • - EXPLAIN # 1: `tb_tree` (PRIMARY)221
        Metadata
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows22
        filtered64.86486053466797
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `settings` where `slug` like 'head-tag-scripts' limit 1490μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing where
      • select * from `settings` where `slug` like 'google-chrome' limit 1200μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing where
      • select * from `settings` where `slug` like 'firefox' limit 1190μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing where
      • select * from `settings` where `slug` like 'microsoft-edge' limit 1190μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing where
      • select * from `settings` where `slug` like 'body-tag-start-scripts' limit 1220μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing 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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing 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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing 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` asc740μsc1_dev_oberig
        Metadata
        Bindings
        • 0. 1
      • - EXPLAIN # 1: `menu_header` (PRIMARY)151
        Metadata
        id1
        select_typePRIMARY
        tablemenu_header
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows15
        filtered10
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `laravel_reserved_0` (DEPENDENT SUBQUERY)32
        Metadata
        id2
        select_typeDEPENDENT SUBQUERY
        tablelaravel_reserved_0
        partitionsnull
        typeref
        possible_keysmenu_header_parent_id_index
        keymenu_header_parent_id_index
        key_len5
        refc1_dev_oberig.menu_header.id
        rows3
        filtered100
        ExtraUsing 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
        id1
        select_typeSIMPLE
        tabletb_tree
        partitionsnull
        typerange
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refnull
        rows9
        filtered100
        ExtraUsing 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
        id1
        select_typeSIMPLE
        tablemenu_header
        partitionsnull
        typeALL
        possible_keysmenu_header_parent_id_index
        keynull
        key_lennull
        refnull
        rows15
        filtered100
        ExtraUsing 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` asc590μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_lft_index
        key_len4
        refnull
        rows15
        filtered83.78378295898438
        ExtraUsing where
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc450μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_lft_index
        key_len4
        refnull
        rows12
        filtered91.89189147949219
        ExtraUsing where
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc450μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_lft_index
        key_len4
        refnull
        rows9
        filtered100
        ExtraUsing where
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc410μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_lft_index
        key_len4
        refnull
        rows10
        filtered97.29730224609375
        ExtraUsing where
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc330μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_lft_index
        key_len4
        refnull
        rows11
        filtered94.59458923339844
        ExtraUsing where
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc330μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows16
        filtered81.0810775756836
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc390μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows15
        filtered83.78378295898438
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc340μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows12
        filtered91.89189147949219
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `social_networks` where `is_active` = 1 order by `priority` asc270μ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
        id1
        select_typeSIMPLE
        tablesocial_networks
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows4
        filtered25
        ExtraUsing where; Using filesort
      • select * from `footer_menu` where `is_active` = 1 order by `lft` asc940μ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
        id1
        select_typeSIMPLE
        tablefooter_menu
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows5
        filtered20
        ExtraUsing where; Using filesort
      • select * from `tb_tree` where `is_active` = '1' and `tb_tree`.`id` in (2, 19, 20, 21)340μ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
        id1
        select_typeSIMPLE
        tabletb_tree
        partitionsnull
        typerange
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refnull
        rows4
        filtered10
        ExtraUsing where
      • select * from `footer_menu` where `footer_menu`.`parent_id` in (1, 2, 3, 4, 7) order by `lft` asc300μsc1_dev_oberig
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
      • - EXPLAIN # 1: `footer_menu` (SIMPLE)51
        Metadata
        id1
        select_typeSIMPLE
        tablefooter_menu
        partitionsnull
        typeALL
        possible_keysfooter_menu_parent_id_index
        keynull
        key_lennull
        refnull
        rows5
        filtered100
        ExtraUsing where; Using filesort
      • select * from `tb_tree` where `template` = 'doctors' and `is_active` = 1 limit 1230μ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
        id1
        select_typeSIMPLE
        tabletb_tree
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows37
        filtered2.702702522277832
        ExtraUsing where
      • select * from `tb_tree` where `template` = 'departments' and `is_active` = 1 limit 1240μ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
        id1
        select_typeSIMPLE
        tabletb_tree
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows37
        filtered2.702702522277832
        ExtraUsing 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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows14
        filtered86.48648834228516
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc460μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows11
        filtered94.59458923339844
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • 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` asc410μ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
        id1
        select_typePRIMARY
        tabletb_tree
        partitionsnull
        typerange
        possible_keystb_tree_lft_index,tb_tree_rgt_index
        keytb_tree_rgt_index
        key_len4
        refnull
        rows13
        filtered89.1891860961914
        ExtraUsing where; Using filesort
      • - EXPLAIN # 2: `_` (SUBQUERY)12
        Metadata
        id2
        select_typeSUBQUERY
        table_
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `settings` where `slug` like 'body-tag-end-scripts' limit 1230μ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
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows21
        filtered11.110000610351562
        ExtraUsing where
      App\Models\MenuFooter
      9
      App\Models\SocialNetwork
      4
      App\Models\MenuHeader
      28
      Vis\Builder\Setting
      10
      App\Models\MorphOne\Seo
      1
      App\Models\PreparationSurvey
      30
      App\Models\Tree
      44
        _token
        a6BrQp9pq1beU8EV1qYe1ZUy66wGpxPGDiAvzsRm
        _previous
        array:1 [ "url" => "https://oberig-dev.vis-design.com.ua/en/pacijentam/podhotovka-k-obsledovanyyu?...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/pacijentam/podhotovka-k-obsledovanyyu
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "letter" => "R" ]
        request_request
        0 of 0
        array:1 [ "letter" => "R" ]
        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: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" => "/en/pacijentam/podhotovka-k-obsledovanyyu?letter=R" "QUERY_STRING" => "letter=R" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "letter=R" "REDIRECT_URL" => "/en/pacijentam/podhotovka-k-obsledovanyyu" "REMOTE_PORT" => "15592" "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.133.113.237" "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" => 1744887806.8519 "REQUEST_TIME" => 1744887806 ]
        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 => "Thu, 17 Apr 2025 11:03:27 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNGU212TEFVcE94MFlFblpucUFkTVE9PSIsInZhbHVlIjoiQi9lSmcrWWswOVZsdnhCaStKamdaVGNWTXhRRm42N1J6MGFPcnpiWFlsT2dGbkJIL2pOYVJNNjJTSURsY09Ob29oVVJHQ01RaWJsN2dLbXI5bnplWno0UjZoV3cyWUY5QlJmL2llQ0pxWS9QVHJNNWFoTE5TWXdnZVN5ZEp4WXkiLCJtYWMiOiI2ZDgzZDE2M2Q4ZGMxNmQ2M2NlYzdhZWY2ZGM0M2I3ZWM1Y2U4NTAwMjQyZmQ2YTY2ZTlmMWI1NGM2ZWFmZjVkIn0%3D; expires=Thu, 17-Apr-2025 13:03:28 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjNGU212TEFVcE94MFlFblpucUFkTVE9PSIsInZhbHVlIjoiQi9lSmcrWWswOVZsdnhCaStKamdaVGNWTXhRRm42N1J6MGFPcnpiWFlsT2dGbkJIL2pOYVJNNjJTSURsY09Ob29oVVJHQ" 1 => "oberig_dev_session=eyJpdiI6InZsWGNLUm1nMGc2SElLVjdCSkl6WWc9PSIsInZhbHVlIjoidWVDUjlGcXM1NDZYMitLZWh1K0RUbU0yNGRndy9zWkQ4dUp0VUx3eC9aUThGWG1hTHZ5amhrbGYzNnkwL2RXblJqUzZIVUtkRy9GeW5PWHpidVdCd1dVU3Z5a2lwanJlTmNCUUtIMmZ1NnNyYkIrZWk3ZnJMQXc1Uk9qdmsva0wiLCJtYWMiOiJkZDIyODQwZjRiYTI2OTViZWY5ZjNhNmU0MzY3ODIzY2IxODdjN2E3NTFhNjljOWNlY2E1NjI2MTIzZmU1MDI0In0%3D; expires=Thu, 17-Apr-2025 13:03:28 GMT; Max-Age=7200; path=/; httponlyoberig_dev_session=eyJpdiI6InZsWGNLUm1nMGc2SElLVjdCSkl6WWc9PSIsInZhbHVlIjoidWVDUjlGcXM1NDZYMitLZWh1K0RUbU0yNGRndy9zWkQ4dUp0VUx3eC9aUThGWG1hTHZ5amhrbGYzNnkwL2RXb" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNGU212TEFVcE94MFlFblpucUFkTVE9PSIsInZhbHVlIjoiQi9lSmcrWWswOVZsdnhCaStKamdaVGNWTXhRRm42N1J6MGFPcnpiWFlsT2dGbkJIL2pOYVJNNjJTSURsY09Ob29oVVJHQ01RaWJsN2dLbXI5bnplWno0UjZoV3cyWUY5QlJmL2llQ0pxWS9QVHJNNWFoTE5TWXdnZVN5ZEp4WXkiLCJtYWMiOiI2ZDgzZDE2M2Q4ZGMxNmQ2M2NlYzdhZWY2ZGM0M2I3ZWM1Y2U4NTAwMjQyZmQ2YTY2ZTlmMWI1NGM2ZWFmZjVkIn0%3D; expires=Thu, 17-Apr-2025 13:03:28 GMT; path=/XSRF-TOKEN=eyJpdiI6IjNGU212TEFVcE94MFlFblpucUFkTVE9PSIsInZhbHVlIjoiQi9lSmcrWWswOVZsdnhCaStKamdaVGNWTXhRRm42N1J6MGFPcnpiWFlsT2dGbkJIL2pOYVJNNjJTSURsY09Ob29oVVJHQ" 1 => "oberig_dev_session=eyJpdiI6InZsWGNLUm1nMGc2SElLVjdCSkl6WWc9PSIsInZhbHVlIjoidWVDUjlGcXM1NDZYMitLZWh1K0RUbU0yNGRndy9zWkQ4dUp0VUx3eC9aUThGWG1hTHZ5amhrbGYzNnkwL2RXblJqUzZIVUtkRy9GeW5PWHpidVdCd1dVU3Z5a2lwanJlTmNCUUtIMmZ1NnNyYkIrZWk3ZnJMQXc1Uk9qdmsva0wiLCJtYWMiOiJkZDIyODQwZjRiYTI2OTViZWY5ZjNhNmU0MzY3ODIzY2IxODdjN2E3NTFhNjljOWNlY2E1NjI2MTIzZmU1MDI0In0%3D; expires=Thu, 17-Apr-2025 13:03:28 GMT; path=/; httponlyoberig_dev_session=eyJpdiI6InZsWGNLUm1nMGc2SElLVjdCSkl6WWc9PSIsInZhbHVlIjoidWVDUjlGcXM1NDZYMitLZWh1K0RUbU0yNGRndy9zWkQ4dUp0VUx3eC9aUThGWG1hTHZ5amhrbGYzNnkwL2RXb" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "a6BrQp9pq1beU8EV1qYe1ZUy66wGpxPGDiAvzsRm" "_previous" => array:1 [ "url" => "https://oberig-dev.vis-design.com.ua/en/pacijentam/podhotovka-k-obsledovanyyu?letter=R" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]