FOLLOW US

Regulations in the pharmaceutical field

The Ministry of Labor, Health and Social Protection of IDPs from the Occupied Territories of Georgia is responsible for regulating and supervising the pharmaceutical sector in Georgia, through the Agency for the Regulation of Medical and Pharmaceutical Activities.

For information about the production and sale of pharmaceutical products, visit the link

"The rules governing medicinal products in the European Union" contains guidance for the interpretation of the principles and guidelines of good manufacturing practices for medicinal products for human and veterinary use laid down in Commission Directives 91/356/EEC, as amended by Directive 2003/94/EC, and 91/412/EEC respectively.

For more information about GMP (Good Manufacturing Practice) and GDP (Good Distribution Practice) visit the link

Share This Via
This website has been produced with the assistance of the European Union (EU) and the United Nations Industrial Development Organization (UNIDO). Its content is the sole responsibility of The Georgian Biopharmaceutical Cluster and do not necessarily reflect the views of the European Union and the United Nations Industrial Development Organization
8.1.32PHP Version3.41sRequest Duration24MBMemory UsageGET {locale?}/{all}Route
  • warninglog[08:56:03] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (504ms)
  • Application (2.9s)
  • 1 x Application (85.04%)
    2.90s
    1 x Booting (14.81%)
    504.32ms
    7 templates were rendered
    • website.pages.text_page.index (resources/views/website/pages/text_page/index.blade.php)8blade
      Params
      0
      model
      1
      breadcrumbs
      2
      language_slugs
      3
      sections
      4
      footerSections
      5
      mainBanner
      6
      cardBanner
      7
      sidebar_menu
    • website.master (resources/views/website/master.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      breadcrumbs
      5
      language_slugs
      6
      sections
      7
      footerSections
      8
      mainBanner
      9
      cardBanner
      10
      sidebar_menu
      11
      __currentLoopData
      12
      breadcrumb
      13
      loop
      14
      file
      15
      card
    • website.components.head (resources/views/website/components/head.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      breadcrumbs
      5
      language_slugs
      6
      sections
      7
      footerSections
      8
      mainBanner
      9
      cardBanner
      10
      sidebar_menu
      11
      __currentLoopData
      12
      breadcrumb
      13
      loop
      14
      file
      15
      card
    • website.components.header (resources/views/website/components/header.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      breadcrumbs
      5
      language_slugs
      6
      sections
      7
      footerSections
      8
      mainBanner
      9
      cardBanner
      10
      sidebar_menu
      11
      __currentLoopData
      12
      breadcrumb
      13
      loop
      14
      file
      15
      card
    • website.components.FooterBanner (resources/views/website/components/FooterBanner.blade.php)20blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      breadcrumbs
      5
      language_slugs
      6
      sections
      7
      footerSections
      8
      mainBanner
      9
      cardBanner
      10
      sidebar_menu
      11
      __currentLoopData
      12
      breadcrumb
      13
      loop
      14
      file
      15
      card
      16
      section
      17
      subSec
      18
      value
      19
      k
    • website.components.footer (resources/views/website/components/footer.blade.php)20blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      breadcrumbs
      5
      language_slugs
      6
      sections
      7
      footerSections
      8
      mainBanner
      9
      cardBanner
      10
      sidebar_menu
      11
      __currentLoopData
      12
      breadcrumb
      13
      loop
      14
      file
      15
      card
      16
      section
      17
      subSec
      18
      value
      19
      k
    • website.components.scripts (resources/views/website/components/scripts.blade.php)20blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      breadcrumbs
      5
      language_slugs
      6
      sections
      7
      footerSections
      8
      mainBanner
      9
      cardBanner
      10
      sidebar_menu
      11
      __currentLoopData
      12
      breadcrumb
      13
      loop
      14
      file
      15
      card
      16
      section
      17
      subSec
      18
      value
      19
      k
    uri
    GET {locale?}/{all}
    middleware
    locale, web
    controller
    App\Http\Controllers\Website\RoutesController@index
    namespace
    prefix
    {locale?}
    where
    file
    App/Http/Controllers/Website/RoutesController.php:13-39
    167 statements were executed, 143 of which were duplicated, 24 unique267ms
    • select * from `slugs` where `fullSlug` = 'en/regulations' limit 1
      7.28ms/App/Http/Controllers/Website/RoutesController.php:17pharmacl_phar
      Metadata
      Bindings
      • 0. en/regulations
      Backtrace
      • 15. /App/Http/Controllers/Website/RoutesController.php:17
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `sections` where `sections`.`id` = 97 limit 1
      3.21ms/App/Http/Controllers/Website/RoutesController.php:23pharmacl_phar
      Metadata
      Bindings
      • 0. 97
      Backtrace
      • 19. /App/Http/Controllers/Website/RoutesController.php:23
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `section_translations` where `section_translations`.`section_id` = 97 and `section_translations`.`section_id` is not null
      2.9ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 97
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /App/Models/Section.php:167
      • 21. /App/Http/Controllers/Website/PagesController.php:41
      • 22. /App/Http/Controllers/Website/RoutesController.php:27
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.37ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. /App/Http/Controllers/Website/PagesController.php:48
      • 17. /App/Http/Controllers/Website/RoutesController.php:27
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `sections` where `id` = 93 limit 1
      1.13ms/App/Http/Controllers/Website/PagesController.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 93
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:52
      • 16. /App/Http/Controllers/Website/RoutesController.php:27
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (93)
      1.11ms/App/Http/Controllers/Website/PagesController.php:52pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:52
      • 21. /App/Http/Controllers/Website/RoutesController.php:27
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.36ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. /App/Http/Controllers/Website/PagesController.php:55
      • 17. /App/Http/Controllers/Website/RoutesController.php:27
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `sections` where `type_id` = 3 limit 1
      1.23ms/App/Http/Controllers/Website/PagesController.php:77pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:77
      • 16. /App/Http/Controllers/Website/RoutesController.php:27
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (32)
      820μs/App/Http/Controllers/Website/PagesController.php:77pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:77
      • 21. /App/Http/Controllers/Website/RoutesController.php:27
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (32) order by `date` desc
      2.15ms/App/Http/Controllers/Website/PagesController.php:77pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:77
      • 21. /App/Http/Controllers/Website/RoutesController.php:27
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (65) and `locale` = 'en'
      1.69ms/App/Http/Controllers/Website/PagesController.php:77pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:77
      • 26. /App/Http/Controllers/Website/RoutesController.php:27
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.61ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.19ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      900μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      750μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      500μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      860μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      840μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.09ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.22ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      5.98ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.64ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.37ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `posts` where `posts`.`section_id` = 97 and `posts`.`section_id` is not null order by `date` desc
      1.87ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 97
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. view::5f59d79d839258b637535256d1be82b5d5482ad5:46
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `post_translations` where `post_translations`.`post_id` in (257) and `locale` = 'en'
      1.87ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 23. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 25. view::5f59d79d839258b637535256d1be82b5d5482ad5:46
      • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `post_files` where `post_files`.`post_id` = 257 and `post_files`.`post_id` is not null
      4.21ms/App/Models/Post.php:106pharmacl_phar
      Metadata
      Bindings
      • 0. 257
      Backtrace
      • 18. /App/Models/Post.php:106
      • 20. view::5f59d79d839258b637535256d1be82b5d5482ad5:62
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3.78ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.33ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      2.04ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.31ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.03ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.47ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.88ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.26ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.09ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.65ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.68ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.37ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.71ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.97ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.7ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.24ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.02ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.43ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.46ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.26ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.98ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.58ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.65ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.28ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.78ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.96ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.78ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.25ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      980μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.4ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.56ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.35ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.23ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.82ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.46ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.66ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.28ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1.2ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.22ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.19ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      1.28ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.19ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      1.35ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      1.32ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.57ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.44ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.29ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.51ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.49ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.42ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.42ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.39ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.13ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.05ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.13ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.1ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.24ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.1ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.08ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      820μs/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      850μs/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      860μs/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      840μs/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      780μs/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      900μs/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.02ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.84ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.55ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.35ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.34ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.49ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.35ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.23ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.43ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 102 and `locale` = 'en' limit 1
      1.25ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 102
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.29ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.29ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.29ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.57ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.62ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.84ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.6ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.08ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      890μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.37ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.36ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.14ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.9ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.84ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      3.74ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.67ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.99ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      2.04ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      2.33ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      920μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.4ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.52ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.28ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.24ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.7ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.77ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.41ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.33ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 32 and `section_translations`.`section_id` is not null
      1.45ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 32
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 89 and `section_translations`.`section_id` is not null
      1.51ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.43ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 82 and `section_translations`.`section_id` is not null
      1.43ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 82
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.42ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 104 and `section_translations`.`section_id` is not null
      1.39ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 104
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.44ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 91 and `section_translations`.`section_id` is not null
      1.42ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 91
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 92 and `section_translations`.`section_id` is not null
      1.38ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.3ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 93 and `section_translations`.`section_id` is not null
      1.36ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 93
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 84 and `section_translations`.`section_id` is not null
      1.42ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 84
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.4ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 81 and `section_translations`.`section_id` is not null
      1.4ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 81
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.71ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 78 and `section_translations`.`section_id` is not null
      1.92ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 78
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.72ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 90 and `section_translations`.`section_id` is not null
      1.39ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 90
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.59ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.88ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      2.05ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.19ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.25ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.47ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.53ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.2ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.05ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.56ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.71ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.35ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    App\Models\PostFile
    1
    App\Models\BannerTranslation
    28
    App\Models\Banner
    35
    App\Models\MenuSection
    91
    App\Models\PostTranslation
    2
    App\Models\Post
    2
    App\Models\SectionTranslation
    245
    App\Models\Section
    290
    App\Models\Slug
    61
        locale
        en
        _token
        5AnM7sS0n1f5NojGERRTgzJ0oG1mGjSdWjPE3vNR
        _previous
        array:1 [ "url" => "https://www.pharmacluster.org/en/regulations" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/regulations
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "www.pharmacluster.org" ] "priority" => array:1 [ 0 => "u=0, i" ] "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" ] ]
        request_server
        0 of 0
        array:75 [ "USER" => "pharmacl" "HOME" => "/home/pharmacl" "SCRIPT_NAME" => "/public/index.php" "REQUEST_URI" => "/en/regulations" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/public/en/regulations" "REMOTE_PORT" => "7523" "SCRIPT_FILENAME" => "/home/pharmacl/domains/pharmacluster.org/private_html/public/index.php" "SERVER_ADMIN" => "webmaster@pharmacluster.org" "CONTEXT_DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "REMOTE_ADDR" => "216.73.216.36" "SERVER_PORT" => "443" "SERVER_ADDR" => "91.239.206.137" "SERVER_NAME" => "www.pharmacluster.org" "SERVER_SOFTWARE" => "Apache/2" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "HTTP_HOST" => "www.pharmacluster.org" "HTTP_PRIORITY" => "u=0, i" "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" "proxy-nokeepalive" => "1" "H2_STREAM_TAG" => "54084-3083-1" "H2_STREAM_ID" => "1" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "www.pharmacluster.org" "HTTPS" => "on" "UNIQUE_ID" => "aIG84RpfGRWiWBUWS9-7FwAAOzw" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "54084-3083-1" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2PUSH" => "off" "REDIRECT_HTTP2" => "on" "REDIRECT_SSL_TLS_SNI" => "www.pharmacluster.org" "REDIRECT_HTTPS" => "on" "REDIRECT_UNIQUE_ID" => "aIG84RpfGRWiWBUWS9-7FwAAOzw" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_H2_STREAM_TAG" => "54084-3083-1" "REDIRECT_REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_REDIRECT_H2_PUSHED" => "" "REDIRECT_REDIRECT_H2_PUSH" => "off" "REDIRECT_REDIRECT_H2PUSH" => "off" "REDIRECT_REDIRECT_HTTP2" => "on" "REDIRECT_REDIRECT_SSL_TLS_SNI" => "www.pharmacluster.org" "REDIRECT_REDIRECT_HTTPS" => "on" "REDIRECT_REDIRECT_UNIQUE_ID" => "aIG84RpfGRWiWBUWS9-7FwAAOzw" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1753332961.881 "REQUEST_TIME" => 1753332961 ]
        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, 24 Jul 2025 04:56:02 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVhc2tERWJTQVpHelFST1U5UUZTaHc9PSIsInZhbHVlIjoiSW1GMG1nMmZaVWpkdlltUlVVUXlvUjV3SkZPdWJQMUZudEJvL2Job09lbldRM29US0tlOEJCNWtES0hkMFFNKzdzaWpmdkNEM3hFYjVtOUNibVBWdDdtYmc4dnArbnBKUVY3QTk2L2xITVBBWVdueFZqenBVUzcyeGhrNmpEM0YiLCJtYWMiOiJlYzVkZjkzNTMxMWVjOTY3ZjEzODFlYTQ4OTQzZmM1ZDQ1ZjAwZDQzZGE1MDM5NTYyZWE0ODdlODM1NDk4ZGU0IiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 06:56:05 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlVhc2tERWJTQVpHelFST1U5UUZTaHc9PSIsInZhbHVlIjoiSW1GMG1nMmZaVWpkdlltUlVVUXlvUjV3SkZPdWJQMUZudEJvL2Job09lbldRM29US0tlOEJCNWtES0hkMFFNKzdzaWpmd" 1 => "geopharmacy_session=eyJpdiI6IkRnR2F2UnROaURiRVF2TGpkdjdwOFE9PSIsInZhbHVlIjoiTEFodTZIaTJjK21RK1NKQ09CY2RrcUlFRG5nbkNGRkxOM01KbFpTVzAzZ1M1QVpncWZIaTNHSXJtTjZHcXZ5YjAvQkJGdjlpZk1HZVZVd3B0TmZkMXM1ZGpXREtlZzlVa0kwdUxpK1h4UVN3ZUwrRTdFMmlSTW1GKzg3MEdEWUgiLCJtYWMiOiI3OWUxOGFmN2RkYWY3NDA2YTNkMmMwNDFjZWFlM2M0ZDk2YzY3ZGFhODIzZWYwMjY3OTRiN2ZhMzNjYzMwNjU0IiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 06:56:05 GMT; Max-Age=7200; path=/; httponly; samesite=laxgeopharmacy_session=eyJpdiI6IkRnR2F2UnROaURiRVF2TGpkdjdwOFE9PSIsInZhbHVlIjoiTEFodTZIaTJjK21RK1NKQ09CY2RrcUlFRG5nbkNGRkxOM01KbFpTVzAzZ1M1QVpncWZIaTNHSXJtTjZHcXZ5" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVhc2tERWJTQVpHelFST1U5UUZTaHc9PSIsInZhbHVlIjoiSW1GMG1nMmZaVWpkdlltUlVVUXlvUjV3SkZPdWJQMUZudEJvL2Job09lbldRM29US0tlOEJCNWtES0hkMFFNKzdzaWpmdkNEM3hFYjVtOUNibVBWdDdtYmc4dnArbnBKUVY3QTk2L2xITVBBWVdueFZqenBVUzcyeGhrNmpEM0YiLCJtYWMiOiJlYzVkZjkzNTMxMWVjOTY3ZjEzODFlYTQ4OTQzZmM1ZDQ1ZjAwZDQzZGE1MDM5NTYyZWE0ODdlODM1NDk4ZGU0IiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 06:56:05 GMT; path=/XSRF-TOKEN=eyJpdiI6IlVhc2tERWJTQVpHelFST1U5UUZTaHc9PSIsInZhbHVlIjoiSW1GMG1nMmZaVWpkdlltUlVVUXlvUjV3SkZPdWJQMUZudEJvL2Job09lbldRM29US0tlOEJCNWtES0hkMFFNKzdzaWpmd" 1 => "geopharmacy_session=eyJpdiI6IkRnR2F2UnROaURiRVF2TGpkdjdwOFE9PSIsInZhbHVlIjoiTEFodTZIaTJjK21RK1NKQ09CY2RrcUlFRG5nbkNGRkxOM01KbFpTVzAzZ1M1QVpncWZIaTNHSXJtTjZHcXZ5YjAvQkJGdjlpZk1HZVZVd3B0TmZkMXM1ZGpXREtlZzlVa0kwdUxpK1h4UVN3ZUwrRTdFMmlSTW1GKzg3MEdEWUgiLCJtYWMiOiI3OWUxOGFmN2RkYWY3NDA2YTNkMmMwNDFjZWFlM2M0ZDk2YzY3ZGFhODIzZWYwMjY3OTRiN2ZhMzNjYzMwNjU0IiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 06:56:05 GMT; path=/; httponlygeopharmacy_session=eyJpdiI6IkRnR2F2UnROaURiRVF2TGpkdjdwOFE9PSIsInZhbHVlIjoiTEFodTZIaTJjK21RK1NKQ09CY2RrcUlFRG5nbkNGRkxOM01KbFpTVzAzZ1M1QVpncWZIaTNHSXJtTjZHcXZ5" ] ]
        session_attributes
        0 of 0
        array:5 [ "locale" => "en" "_token" => "5AnM7sS0n1f5NojGERRTgzJ0oG1mGjSdWjPE3vNR" "_previous" => array:1 [ "url" => "https://www.pharmacluster.org/en/regulations" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]