Military Embedded Systems

Managing legacy graphics and user interface software

Story

August 11, 2010

Mark Snyder

ALT Software

Graphics represent a challenging area for managing software obsolescence. Most applications that render to the screen or manage a user interface make use of low-level driver calls, such as OpenGL, and extensive User Interface (UI) libraries such as X-Windows or other UI libraries. Deploying these software applications on new platforms when technology insertion is needed because of performance requirements changes or obsolescence is challenging. However, a methodology whereby graphics and UI interfaces can be abstracted without sacrificing performance or flexibility is vastly extending the useful life of legacy software when technology insertion is required.

User interface and graphics software represents a significant proportion of any software system that requires user interactions. In military systems, User Interfaces (UIs) range from real-time embedded displays through extensive digital map and geospatial C4ISR applications. User interface software is unique in that it is highly visible to the computer user while at the same time interfacing directly to graphics hardware through driver calls. Such driver calls include those provided by standards such as OpenGL or by APIs such as rendering libraries provided for a radar processor to draw reticles or text.

In addition, user interface software is highly dependent on operating system constructs such as a windows manager (for example, X-Windows), often also used to provide 2D graphics capabilities. Many times the chief impediment to software portability is in the UI and graphics area. This is even more true when trying to manage legacy software migration to systems that require technology insertion, such as replacement of obsolete graphics chips.

Many tools and methods have been developed during the years to aid in making UI and graphics applications more portable and resistant to obsolescence. For instance, many popular software tools and libraries that abstract the interface to the graphics hardware are available for developers’ use. These tools might employ code generation (example: Presagis VAPS) or pass graphics rendering calls through an abstraction library (example: Nokia QT).

These development tools are very beneficial, but they do not help much with a legacy code base that has extensive dependence on graphics calls. In many cases, technology insertion requires investment in new graphics drivers or window management software to match legacy software’s API needs. The API calls required by the legacy application are implemented in the hardware device driver. In practice, this means that hardware evolution is slowed, and that hardware capabilities do not evolve as they should. For military systems, sadly, it also often means that developers cannot take advantage of new technologies that would greatly benefit the system, such as low-power, low-cost computing platforms that are revolutionizing mobile computing. Industry standard groups such as Khronos (www.khronos.org) have paved the way for new, low-power graphics and UI systems through defining and supporting new standards such as OpenGL ES for embedded graphics. However, these standards are designed to enable UIs and rich graphics experience with drastically reduced APIs and embedded driver sizes. Few would argue that they deliver rich, useful user interfaces, but legacy software cannot take advantage because it was not written to support these new, streamlined APIs.

Simply put, graphics software obsolescence is leaving military systems stuck in the past. This means that soldiers, sailors, and airmen are using computers that cost more and consume more power than they need to, and often deliver substandard operation. In addition, new technologies that make smartphones, TabletPCs, and automobile computers ever more user-friendly and useful cannot find their way to military embedded systems.

New software approaches

Several approaches exist to bring legacy graphics software applications onto these new hardware platforms. One approach that offers much promise is to leverage the concept of virtualization and apply this to graphics and UI systems. Using this approach, graphics-rendering commands – whether legacy APIs, 2D window-management commands, or 3D rendering – can be implemented through a virtualization mechanism similar to those used for other OS and device interfaces. The main challenge in implementing such a scheme lies in preserving the performance and real-time interface to the hardware and graphics resources while still supporting the needed APIs. For this reason, a good virtualization solution must be built from the device-driver level to ensure success. A “hybrid” between a traditional driver and a virtualized one is necessary.

Such a “hybrid” approach can offer high-performance, divergent back-end implementations for new devices in addition to front-end APIs that legacy applications expect. Graphics resources and commands must be marshaled by this layer to deliver real-time performance. The virtualization layer must be prepared to manage graphics resource memory and virtualized device interfaces such as windows. It must also be ready to perform seamless low-overhead API conversions as required.

Embracing the future

The best approach for managing obsolescence in graphics and UI applications is to design and develop for it up front, by choosing a development strategy and tools that attempt to “future proof” an application and by adhering to relevant standards such as those offered by Khronos. When this is not possible, a virtualization strategy, or “hybrid” device driver, can offer a promising alternative. Work remains to be done, but graphics virtualization is a new and promising area. It offers a way forward to bring legacy military graphics systems into the new computing world vigorously charted by smartphones, TabletPCs, and the devices that are changing everyday lives.

Mark Snyder is Vice President of Product Marketing for ALT Software. He has been responsible for many innovations in user interface and real-time computer graphics software architectures and tool chains during his 25-year career working at Quantum3D, Honeywell International, and the U.S. Air Force. He can be contacted at msnyder@altsoftware.com.

 

Featured Companies

ALT Software

2525 W Greenway Rd # 332
Phoenix, AZ 85023
Categories
Comms - Communications
Topic Tags
8.2.22PHP Version3.93sRequest Duration6MBMemory UsageGET comms/{uri_path?}Route
    • Booting (92.32ms)
    • Application (3.84s)
    • 1 x Application (97.65%)
      3.84s
      1 x Booting (2.35%)
      92.32ms
      82 templates were rendered
      • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
        Params
        0
        displayed_articles
        1
        page_title
        2
        article
      • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        authors
      • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        company
        8
        loop
      • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        category
      • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        socialMedia
      • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
        Params
        0
        displayed_articles
        1
        page_title
        2
        article
      • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        authors
      • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        company
        8
        loop
      • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        category
      • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        socialMedia
      uri
      GET comms/{uri_path?}
      middleware
      web
      controller
      App\Http\Controllers\Frontend\ArticleController@viewArticleByShortname
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/Frontend/ArticleController.php:35-49
      104 statements were executed, 72 of which were duplicated, 32 unique. Show only duplicated2.12s
      • select * from `articles` where `shortname` = 'managing-graphics-user-interface-software' and `publish_at` < '2025-04-06 02:52:37' limit 1
        4.22ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Bindings
        • 0. managing-graphics-user-interface-software
        • 1. 2025-04-06 02:52:37
        Backtrace
        • 16. /app/Http/Controllers/Frontend/ArticleController.php:42
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` where `categories`.`id` in (44)
        1.22ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Backtrace
        • 21. /app/Http/Controllers/Frontend/ArticleController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` where `categories`.`id` in (6)
        1.07ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Backtrace
        • 26. /app/Http/Controllers/Frontend/ArticleController.php:42
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `article_types` where `article_types`.`id` in (2)
        1.06ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Backtrace
        • 21. /app/Http/Controllers/Frontend/ArticleController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `authors`.*, `articles_authors`.`article_id` as `pivot_article_id`, `articles_authors`.`author_id` as `pivot_author_id` from `authors` inner join `articles_authors` on `authors`.`id` = `articles_authors`.`author_id` where `articles_authors`.`article_id` = 253
        8.02msview::theme::article.view.generic:15mes
        Metadata
        Bindings
        • 0. 253
        Backtrace
        • 19. view::theme::article.view.generic:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `companies` where `companies`.`id` = 300 limit 1
        1.56msview::theme::author.card:16mes
        Metadata
        Bindings
        • 0. 300
        Backtrace
        • 21. view::theme::author.card:16
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 26. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_attachments` where `article_attachments`.`article_id` = 253 and `article_attachments`.`article_id` is not null
        1.57ms/app/Models/Article.php:262mes
        Metadata
        Bindings
        • 0. 253
        Backtrace
        • 19. /app/Models/Article.php:262
        • 25. view::theme::article.components.primary-image:2
        • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `companies`.*, `articles_companies`.`article_id` as `pivot_article_id`, `articles_companies`.`company_id` as `pivot_company_id` from `companies` inner join `articles_companies` on `companies`.`id` = `articles_companies`.`company_id` where `articles_companies`.`article_id` = 253
        12.63msview::theme::article.components.companies:1mes
        Metadata
        Bindings
        • 0. 253
        Backtrace
        • 19. view::theme::article.components.companies:1
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select `categories`.*, `articles_categories`.`article_id` as `pivot_article_id`, `articles_categories`.`category_id` as `pivot_category_id` from `categories` inner join `articles_categories` on `categories`.`id` = `articles_categories`.`category_id` where `articles_categories`.`article_id` = 253
        10.07msview::theme::article.view.generic:45mes
        Metadata
        Bindings
        • 0. 253
        Backtrace
        • 19. view::theme::article.view.generic:45
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select `tags`.*, `articles_tags`.`article_id` as `pivot_article_id`, `articles_tags`.`tag_id` as `pivot_tag_id` from `tags` inner join `articles_tags` on `tags`.`id` = `articles_tags`.`tag_id` where `articles_tags`.`article_id` = 253
        12.91msview::theme::article.view.generic:51mes
        Metadata
        Bindings
        • 0. 253
        Backtrace
        • 19. view::theme::article.view.generic:51
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-04-06 02:52:37' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        78.93ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-04-06 02:52:37
        • 4. 
        • 5. 0
        Backtrace
        • 14. /app/Models/Article.php:375
        • 15. view::theme::layouts.components.sidebar:8
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (7, 13, 15, 19, 21, 23, 24, 25, 26, 27, 31, 32, 44, 47, 1000, 1001)
        1.63ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (1, 2, 3, 4, 6)
        1.53ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 24. /app/Models/Article.php:375
        • 25. view::theme::layouts.components.sidebar:8
        • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `article_types` where `article_types`.`id` in (2, 3, 4, 5)
        1.33ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `id`, `name`, `shortname` from `categories` where `parent_id` is null and `id` not in (999, 100) and exists (select * from `articles` where `categories`.`id` = `articles`.`primary_category` and `publish_at` < '2025-04-06 02:52:38' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        36.24ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-04-06 02:52:38
        • 3. 
        • 4. 0
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:38
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6) order by `shortname` asc
        1.73ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:38
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (1, 1000, 1003, 7, 1001, 9, 1002, 8) limit 5
        2.58ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 1
        • 3. 1000
        • 4. 1003
        • 5. 7
        • 6. 1001
        • 7. 9
        • 8. 1002
        • 9. 8
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (7, 8, 9, 1000)
        940μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (1)
        750μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        770μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (2, 14, 17, 18, 13, 1004, 15, 16, 19) limit 5
        1.79ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 2
        • 3. 14
        • 4. 17
        • 5. 18
        • 6. 13
        • 7. 1004
        • 8. 15
        • 9. 16
        • 10. 19
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (15, 16, 18)
        970μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (2)
        1.03ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        1.05ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (3, 1005, 23, 26, 25, 21, 20, 24, 22) limit 5
        1.95ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 3
        • 3. 1005
        • 4. 23
        • 5. 26
        • 6. 25
        • 7. 21
        • 8. 20
        • 9. 24
        • 10. 22
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (20, 23)
        1.34ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (3)
        1.07ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        1.13ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (5, 37, 36, 35) limit 5
        3.62ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 5
        • 3. 37
        • 4. 36
        • 5. 35
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (36, 37)
        1.54ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (5)
        1.17ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        1.08ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `parent_id` is null and `id` not in (999, 100, 1061)
        2.26msview::theme::layouts.components.category_subfooter:6mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 1061
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:6
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 1 limit 1
        1.16ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 1 and `categories`.`parent_id` is not null order by `shortname` asc
        1.67ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:38' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 1 or `primary_category` = 1000 or `primary_category` = 1003 or `primary_category` = 7 or `primary_category` = 1001 or `primary_category` = 9 or `primary_category` = 1002 or `primary_category` = 8) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        82.34msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:38
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 1
        • 5. 1000
        • 6. 1003
        • 7. 7
        • 8. 1001
        • 9. 9
        • 10. 1002
        • 11. 8
        • 12. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (7, 8, 1000, 1001)
        1.67msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (1)
        1.4msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (3)
        1.15msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 4 limit 1
        2.06ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 4
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 4 and `categories`.`parent_id` is not null order by `shortname` asc
        1.33ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 4
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:38' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 4 or `primary_category` = 32 or `primary_category` = 31 or `primary_category` = 30 or `primary_category` = 29 or `primary_category` = 27) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        83.86msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:38
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 4
        • 5. 32
        • 6. 31
        • 7. 30
        • 8. 29
        • 9. 27
        • 10. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (27, 31, 32)
        1.68msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (4)
        1.33msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3)
        1msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 5 limit 1
        1.94ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 5 and `categories`.`parent_id` is not null order by `shortname` asc
        2.36ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:38' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 5 or `primary_category` = 37 or `primary_category` = 36 or `primary_category` = 35) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        77.92msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:38
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 5
        • 5. 37
        • 6. 36
        • 7. 35
        • 8. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (37)
        1.59msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (5)
        1.63msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3)
        1.36msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 6 limit 1
        1.78ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 6
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 6 and `categories`.`parent_id` is not null order by `shortname` asc
        1.48ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 6
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:38' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 6 or `primary_category` = 45 or `primary_category` = 44 or `primary_category` = 46 or `primary_category` = 1008 or `primary_category` = 1006 or `primary_category` = 40 or `primary_category` = 43 or `primary_category` = 47 or `primary_category` = 39 or `primary_category` = 41 or `primary_category` = 42 or `primary_category` = 1007) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        78.72msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:38
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 6
        • 5. 45
        • 6. 44
        • 7. 46
        • 8. 1008
        • 9. 1006
        • 10. 40
        • 11. 43
        • 12. 47
        • 13. 39
        • 14. 41
        • 15. 42
        • 16. 1007
        • 17. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (44, 47, 1007)
        2.22msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (6)
        1.6msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (3)
        1.56msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-04-06 02:52:38' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        108ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-04-06 02:52:38
        • 4. 
        • 5. 0
        Backtrace
        • 14. /app/Models/Article.php:375
        • 15. view::theme::layouts.components.sidebar:8
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (7, 13, 15, 19, 21, 23, 24, 25, 26, 27, 31, 32, 44, 47, 1000, 1001)
        3.26ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (1, 2, 3, 4, 6)
        2.23ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 24. /app/Models/Article.php:375
        • 25. view::theme::layouts.components.sidebar:8
        • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `article_types` where `article_types`.`id` in (2, 3, 4, 5)
        3.17ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `id`, `name`, `shortname` from `categories` where `parent_id` is null and `id` not in (999, 100) and exists (select * from `articles` where `categories`.`id` = `articles`.`primary_category` and `publish_at` < '2025-04-06 02:52:39' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        94.15ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-04-06 02:52:39
        • 3. 
        • 4. 0
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:38
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6) order by `shortname` asc
        22.02ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:38
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (1, 1000, 1003, 7, 1001, 9, 1002, 8) limit 5
        7.47ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 1
        • 3. 1000
        • 4. 1003
        • 5. 7
        • 6. 1001
        • 7. 9
        • 8. 1002
        • 9. 8
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (7, 8, 9, 1000)
        5.42ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (1)
        7.44ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        2.86ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (3, 1005, 23, 26, 25, 21, 20, 24, 22) limit 5
        5.41ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 3
        • 3. 1005
        • 4. 23
        • 5. 26
        • 6. 25
        • 7. 21
        • 8. 20
        • 9. 24
        • 10. 22
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (20, 23)
        5.7ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (3)
        4.34ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        3.45ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (5, 37, 36, 35) limit 5
        5.97ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 5
        • 3. 37
        • 4. 36
        • 5. 35
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (36, 37)
        3.61ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (5)
        2.47ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        3.72ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (6, 45, 44, 46, 1008, 1006, 40, 43, 47, 39, 41, 42, 1007) limit 5
        7.9ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 6
        • 3. 45
        • 4. 44
        • 5. 46
        • 6. 1008
        • 7. 1006
        • 8. 40
        • 9. 43
        • 10. 47
        • 11. 39
        • 12. 41
        • 13. 42
        • 14. 1007
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (43, 44, 46)
        12.29ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (6)
        8.22ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        6.73ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `parent_id` is null and `id` not in (999, 100, 1061)
        4.24msview::theme::layouts.components.category_subfooter:6mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 1061
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:6
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 1 limit 1
        2.29ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 1 and `categories`.`parent_id` is not null order by `shortname` asc
        1.61ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:39' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 1 or `primary_category` = 1000 or `primary_category` = 1003 or `primary_category` = 7 or `primary_category` = 1001 or `primary_category` = 9 or `primary_category` = 1002 or `primary_category` = 8) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        272msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:39
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 1
        • 5. 1000
        • 6. 1003
        • 7. 7
        • 8. 1001
        • 9. 9
        • 10. 1002
        • 11. 8
        • 12. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (7, 8, 1000, 1001)
        1.67msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (1)
        1.65msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (3)
        2.3msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 2 limit 1
        2.3ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 2
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 2 and `categories`.`parent_id` is not null order by `shortname` asc
        3.9ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 2
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:39' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 2 or `primary_category` = 14 or `primary_category` = 17 or `primary_category` = 18 or `primary_category` = 13 or `primary_category` = 1004 or `primary_category` = 15 or `primary_category` = 16 or `primary_category` = 19) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        197msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:39
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 2
        • 5. 14
        • 6. 17
        • 7. 18
        • 8. 13
        • 9. 1004
        • 10. 15
        • 11. 16
        • 12. 19
        • 13. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (13, 15, 19)
        1.5msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (2)
        1.01msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3, 4)
        3.98msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 5 limit 1
        1.81ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 5 and `categories`.`parent_id` is not null order by `shortname` asc
        8.93ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:40' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 5 or `primary_category` = 37 or `primary_category` = 36 or `primary_category` = 35) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        344msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:40
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 5
        • 5. 37
        • 6. 36
        • 7. 35
        • 8. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (37)
        4.66msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (5)
        2.37msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3)
        6.1msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 6 limit 1
        2.79ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 6
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 6 and `categories`.`parent_id` is not null order by `shortname` asc
        6.82ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 6
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-06 02:52:40' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 6 or `primary_category` = 45 or `primary_category` = 44 or `primary_category` = 46 or `primary_category` = 1008 or `primary_category` = 1006 or `primary_category` = 40 or `primary_category` = 43 or `primary_category` = 47 or `primary_category` = 39 or `primary_category` = 41 or `primary_category` = 42 or `primary_category` = 1007) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        350msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-06 02:52:40
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 6
        • 5. 45
        • 6. 44
        • 7. 46
        • 8. 1008
        • 9. 1006
        • 10. 40
        • 11. 43
        • 12. 47
        • 13. 39
        • 14. 41
        • 15. 42
        • 16. 1007
        • 17. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (44, 47, 1007)
        2.54msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (6)
        11.15msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (3)
        2.07msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      App\Models\Tag
      1
      App\Models\Company
      2
      App\Models\Author
      1
      App\Models\ArticleType
      30
      App\Models\Category
      279
      App\Models\Article
      141
        _token
        XDQDZjXnhWCcafrBYbPpJyQ6ZAnlDL9eh0cbLGkM
        _previous
        array:1 [ "url" => "https://dev007.militaryembedded.com/comms/communications/managing-graphics-use...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /comms/communications/managing-graphics-user-interface-software
        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:25 [ "cookie" => array:1 [ 0 => "_mkto_trk=id:609-IYN-899&token:_mch-militaryembedded.com-e8560525fe25e7a94c277da778739dde; XSRF-TOKEN=eyJpdiI6IlJSVTNXeHU4eEd6TUs2aDdjQWJVUlE9PSIsInZhbHVlIjoib2ErWE5rWWNMT2xrNGxZak54eENWdW9FVDVic1NrUEhyZUJucnRESm5iMWdpVDdTd250UHdsdTFUVXN1NndiRnAyaW4zMTduSkVWVVNVeEZLdGVNNkRZYUZHV093YUtWek9TMERzeUdqbFNPcmowWTcyNnpQdnRCenlaZzhXZTMiLCJtYWMiOiIwZWQ2ZGJjOWNhZGMxNWU0MDU4NWIzNzBiOWQ2NzY1YjU1YTlkMjZmZjRkOGE0NjgzYzBiZGQ1N2U1YmVhMDRlIiwidGFnIjoiIn0%3D; military_embedded_systems_session=e0I62lNUhs7XgX1G2v2e9xRKIgAzxH3oZ9H29GJW; cf_clearance=bQmM4QEuk.GyqKgjn5J45Clxvxq42JnsJo5jjc3CNQ4-1743907957-1.2.1.1-T3CS5MBZfmRGm9faxTpX3FX2Sjvd1h8E1JG3S2Vzz3tog1t0.6_IyfB.LbN.183b.eGYBIryFuNjqqSyvSGKH8lhbP9SLUHINlzXfTQFBMwpqjety5HD2G9hpv.oaDwSgdO9vW4vt6x8ul5.878wc8zBh9IVlzldSqBqdpXKzHZ.uBVan1iZEIsms0ygNT6aGGSu603tdjpxbiC5G1Ba.Nm_jBppA_a_21hSd8obOYzw82nZTIiIbW1KxsBUKcyIjW10PyAjBB3QcOBAe_yeernPFSaEIK.k1OllJP3E_Ar9R4vNhWKcZI44vujqVikTqAqnuc0_Ip5yw4a6ZGOdHu_8VxyDDSFNOKIAScdG4d0_mkto_trk=id:609-IYN-899&token:_mch-militaryembedded.com-e8560525fe25e7a94c277da778739dde; XSRF-TOKEN=eyJpdiI6IlJSVTNXeHU4eEd6TUs2aDdjQWJVUlE9PSIsInZhbHVlIjoib2" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "cf-connecting-ip" => array:1 [ 0 => "3.14.145.69" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "priority" => array:1 [ 0 => "u=0, i" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "x-forwarded-for" => array:1 [ 0 => "3.14.145.69" ] "cf-ray" => array:1 [ 0 => "92bdfd7ceaed22fd-ORD" ] "host" => array:1 [ 0 => "dev007.militaryembedded.com" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
        request_server
        0 of 0
        array:48 [ "USER" => "forge" "HOME" => "/home/forge" "HTTP_COOKIE" => "_mkto_trk=id:609-IYN-899&token:_mch-militaryembedded.com-e8560525fe25e7a94c277da778739dde; XSRF-TOKEN=eyJpdiI6IlJSVTNXeHU4eEd6TUs2aDdjQWJVUlE9PSIsInZhbHVlIjoib2ErWE5rWWNMT2xrNGxZak54eENWdW9FVDVic1NrUEhyZUJucnRESm5iMWdpVDdTd250UHdsdTFUVXN1NndiRnAyaW4zMTduSkVWVVNVeEZLdGVNNkRZYUZHV093YUtWek9TMERzeUdqbFNPcmowWTcyNnpQdnRCenlaZzhXZTMiLCJtYWMiOiIwZWQ2ZGJjOWNhZGMxNWU0MDU4NWIzNzBiOWQ2NzY1YjU1YTlkMjZmZjRkOGE0NjgzYzBiZGQ1N2U1YmVhMDRlIiwidGFnIjoiIn0%3D; military_embedded_systems_session=e0I62lNUhs7XgX1G2v2e9xRKIgAzxH3oZ9H29GJW; cf_clearance=bQmM4QEuk.GyqKgjn5J45Clxvxq42JnsJo5jjc3CNQ4-1743907957-1.2.1.1-T3CS5MBZfmRGm9faxTpX3FX2Sjvd1h8E1JG3S2Vzz3tog1t0.6_IyfB.LbN.183b.eGYBIryFuNjqqSyvSGKH8lhbP9SLUHINlzXfTQFBMwpqjety5HD2G9hpv.oaDwSgdO9vW4vt6x8ul5.878wc8zBh9IVlzldSqBqdpXKzHZ.uBVan1iZEIsms0ygNT6aGGSu603tdjpxbiC5G1Ba.Nm_jBppA_a_21hSd8obOYzw82nZTIiIbW1KxsBUKcyIjW10PyAjBB3QcOBAe_yeernPFSaEIK.k1OllJP3E_Ar9R4vNhWKcZI44vujqVikTqAqnuc0_Ip5yw4a6ZGOdHu_8VxyDDSFNOKIAScdG4d0_mkto_trk=id:609-IYN-899&token:_mch-militaryembedded.com-e8560525fe25e7a94c277da778739dde; XSRF-TOKEN=eyJpdiI6IlJSVTNXeHU4eEd6TUs2aDdjQWJVUlE9PSIsInZhbHVlIjoib2" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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_CF_CONNECTING_IP" => "3.14.145.69" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_PRIORITY" => "u=0, i" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_X_FORWARDED_FOR" => "3.14.145.69" "HTTP_CF_RAY" => "92bdfd7ceaed22fd-ORD" "HTTP_HOST" => "dev007.militaryembedded.com" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SERVER_NAME" => "dev007.militaryembedded.com" "SERVER_PORT" => "443" "SERVER_ADDR" => "209.38.74.90" "REMOTE_PORT" => "" "REMOTE_ADDR" => "3.14.145.69" "SERVER_SOFTWARE" => "nginx/1.26.2" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/home/forge/dev007.militaryembedded.com/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/comms/communications/managing-graphics-user-interface-software" "SCRIPT_NAME" => "/index.php" "SCRIPT_FILENAME" => "/home/forge/dev007.militaryembedded.com/public/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743907957.2949 "REQUEST_TIME" => 1743907957 ]
        request_cookies
        0 of 0
        array:4 [ "_mkto_trk" => "id:609-IYN-899&token:_mch-militaryembedded.com-e8560525fe25e7a94c277da778739dde" "XSRF-TOKEN" => "XDQDZjXnhWCcafrBYbPpJyQ6ZAnlDL9eh0cbLGkM" "military_embedded_systems_session" => null "cf_clearance" => null ]
        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 => "Sun, 06 Apr 2025 02:52:38 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBkSWJrYVRrRUR3VlhMY0kwUnhXSEE9PSIsInZhbHVlIjoiZWdsYTRJK3dFWWUvWXlWM3NMY04zK25FM1VjNDRUM3JJeVBPc1c1TkwxcnhUc1NrakNia0tDYWVqUkx3Uk9iczEvT1l0cDUvU3dyMnBqWXY5Z25DOU5NbzV0S01ma3h6eVlBb09FWHpHOWNWWG83SEdXSUNvMVlMUEVJSndYK3ciLCJtYWMiOiIzMTk0ZjNiMTUxOWJkY2NiZGE1ZmM3YjNmM2FjMGE3MDE1M2FiYjZmZDM3NmM1YTkxMTMwZGEzZDc4MzZjZTViIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 04:52:41 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InBkSWJrYVRrRUR3VlhMY0kwUnhXSEE9PSIsInZhbHVlIjoiZWdsYTRJK3dFWWUvWXlWM3NMY04zK25FM1VjNDRUM3JJeVBPc1c1TkwxcnhUc1NrakNia0tDYWVqUkx3Uk9iczEvT1l0c" 1 => "military_embedded_systems_session=eyJpdiI6IjgzeXNYL1hqbmhGdTZ4eDErVDVGblE9PSIsInZhbHVlIjoiYXQ0TkUwNFppekJoZ0EvMk4zWXFNUUgrd0k5NVNScko2SGZ1Tkl4d2VkZFNrOXhtSGV5eExIb3lIcWhCYU9tYURKdFJFTWV1YWFhZVlQanRvek9jcFRTelRYN1RHeERpOVBiOVBHLzZZTnMrcUJtVTBvVCtCblF5bzljZEh2cm8iLCJtYWMiOiI5Y2U4MzllOGQ2NzgwOGY5MWMyYjllNTI4ZTBmNjYzZTZiYWZjOWUwMmJlODZjODRjNDg2NzdlOWE5ZDI5OTlmIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 04:52:41 GMT; Max-Age=7200; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6IjgzeXNYL1hqbmhGdTZ4eDErVDVGblE9PSIsInZhbHVlIjoiYXQ0TkUwNFppekJoZ0EvMk4zWXFNUUgrd0k5NVNScko2SGZ1Tkl4d2VkZFNrOXhtSGV5eE" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBkSWJrYVRrRUR3VlhMY0kwUnhXSEE9PSIsInZhbHVlIjoiZWdsYTRJK3dFWWUvWXlWM3NMY04zK25FM1VjNDRUM3JJeVBPc1c1TkwxcnhUc1NrakNia0tDYWVqUkx3Uk9iczEvT1l0cDUvU3dyMnBqWXY5Z25DOU5NbzV0S01ma3h6eVlBb09FWHpHOWNWWG83SEdXSUNvMVlMUEVJSndYK3ciLCJtYWMiOiIzMTk0ZjNiMTUxOWJkY2NiZGE1ZmM3YjNmM2FjMGE3MDE1M2FiYjZmZDM3NmM1YTkxMTMwZGEzZDc4MzZjZTViIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 04:52:41 GMT; path=/XSRF-TOKEN=eyJpdiI6InBkSWJrYVRrRUR3VlhMY0kwUnhXSEE9PSIsInZhbHVlIjoiZWdsYTRJK3dFWWUvWXlWM3NMY04zK25FM1VjNDRUM3JJeVBPc1c1TkwxcnhUc1NrakNia0tDYWVqUkx3Uk9iczEvT1l0c" 1 => "military_embedded_systems_session=eyJpdiI6IjgzeXNYL1hqbmhGdTZ4eDErVDVGblE9PSIsInZhbHVlIjoiYXQ0TkUwNFppekJoZ0EvMk4zWXFNUUgrd0k5NVNScko2SGZ1Tkl4d2VkZFNrOXhtSGV5eExIb3lIcWhCYU9tYURKdFJFTWV1YWFhZVlQanRvek9jcFRTelRYN1RHeERpOVBiOVBHLzZZTnMrcUJtVTBvVCtCblF5bzljZEh2cm8iLCJtYWMiOiI5Y2U4MzllOGQ2NzgwOGY5MWMyYjllNTI4ZTBmNjYzZTZiYWZjOWUwMmJlODZjODRjNDg2NzdlOWE5ZDI5OTlmIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 04:52:41 GMT; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6IjgzeXNYL1hqbmhGdTZ4eDErVDVGblE9PSIsInZhbHVlIjoiYXQ0TkUwNFppekJoZ0EvMk4zWXFNUUgrd0k5NVNScko2SGZ1Tkl4d2VkZFNrOXhtSGV5eE" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "XDQDZjXnhWCcafrBYbPpJyQ6ZAnlDL9eh0cbLGkM" "_previous" => array:1 [ "url" => "https://dev007.militaryembedded.com/comms/communications/managing-graphics-user-interface-software" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]