Military Embedded Systems

When code is born of old: Architectural obsolescence within the development life cycle

Story

April 11, 2011

Mark Pitchford

LDRA Technology

Portability is not just relevant to software migration during the lifetime of a product. In complex military projects where the development cycle can easily take up to 10 years, software might have to be ported to new architectures two or three times. Unless specific steps are taken to ensure platform portability, such migration accelerates project overage, extending work schedules right through testing and verification. The ideal would be to anticipate such an occurrence and plan to minimize its impact, but the right software test tools can smooth the way even when porting legacy code written without such foresight.

Choosing appropriate software test tools is always an essential step for safety-critical applications, and that is particularly true when portability is vital. It is well worth a little additional lateral thinking about how those tools might be applied to this specific circumstance.

The purpose of DO-178B is to provide guidelines for the production of software for airborne systems and equipment that performs its intended function while providing safety criticality. Although DO-178B demands the use of appropriate coding rules, it does not dictate what those rules should be.

Other standards, such as the Motor Industry Software Reliability Association C coding standard (MISRA C), MISRA C++, and Joint Strike Fighter Air Vehicle C++ Coding Standard (JSF++AV), specify detailed rules about how such safety-critical code should be written, and are found in an increasingly broad spectrum of applications. For instance, MISRA C was initially developed for use in automotive applications but has since been adopted and used across a wide variety of industries, including the medical, rail, aerospace, and military sectors. Sure, standards such as DO-178B will insist on the use of a rule set such as the MISRA and JSF++AV standards. The problem is that although these all acknowledge that portability is desirable and include rules relating to it, it is rarely the primary concern.

Adopting an appropriate rule set

Choosing a static analysis tool that encompasses many such standards will provide access to the portability rules of all of them. Considering additional portability rules in tandem with those from a chosen standard will ensure more focus on that element of the development work, and hence, ensure the minimum possible impact in the event of such a change.

There is no consequential compromise in the adherence to the standard of choice. And by choosing a rule superset of the nominated standard, it is possible to ensure that a change in architecture will have the minimum possible impact. With the correct tools, it is also perfectly possible to cross-reference Code Review Reports to a nominated standard and still include the additional portability rules.

Adapting to new target hardware

When the time comes to port code to a new target, it is useful to focus on only those parts of the rule set that have implications for portability, regardless of whether target obsolescence results from lengthy development times.

If the portability-focused rule set has been in place from the start, this exercise should largely be one of confirming that there are no problems. If not, the ability to filter static code review reporting to focus on portability becomes invaluable.

In this case, there are likely to be changes spread through the code base. So once the changes have been made, how can it be proven that the code functionality has not been compromised?

Ensuring uncompromised functionality

Unit test tools often encourage the collation of a suite of regression tests as development progresses. If such tests exist, rerunning them for a new target environment is a trivial exercise. If there is no such existing portfolio of unit test cases, an alternative approach needs to be considered.

For example, it is possible to automatically generate a set of unit test cases based on code analysis. These test cases can then be used to prove that functionality is identical before and after modification. While unit test cases not based on requirements are generally inferior because of a lack of independence, this approach bears scrutiny here because the primary requirement is to confirm that functionality has not changed.

Another approach involves comparing “baselines” from test tools, which can show how code has been changed. These can be used in conjunction with the tools’ graphical representations of code architecture to ensure that even unchanged code is not affected by changes made elsewhere.

Such possibilities exist because modern test tool suites include a collection of tools that, although frequently used in a prescribed sequence, is often much more adaptable than such a rigid definition implies. By considering them not only as part of the development process but also as a tool kit, they have the flexibility to help in a plethora of situations … including this one.

Mark Pitchford has more than 25 years of experience in software development for engineering applications. Since 2001, he has specialized in software testing and works as a Field Applications Engineer with LDRA. He can be contacted at Mark.Pitchford@ldra.com.

 

Featured Companies

LDRA Technology

2540 King Arthur Blvd, Suite #228
Lewisville, TX 75056
8.2.22PHP Version4.29sRequest Duration6MBMemory UsageGET avionics/{uri_path?}Route
    • Booting (344ms)
    • Application (3.94s)
    • 1 x Application (91.91%)
      3.94s
      1 x Booting (8.02%)
      343.89ms
      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)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • 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
        category
        8
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        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)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • 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
        category
        8
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • 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
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        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)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        socialMedia
      uri
      GET avionics/{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
      105 statements were executed, 69 of which were duplicated, 36 unique. Show only duplicated2.1s
      • select * from `articles` where `shortname` = 'when-within-development-life-cycle' and `publish_at` < '2025-03-16 07:24:13' limit 1
        2.75ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Bindings
        • 0. when-within-development-life-cycle
        • 1. 2025-03-16 07:24:13
        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 (9)
        1.26ms/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 (1)
        1.95ms/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.41ms/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` = 96
        6.82msview::theme::article.view.generic:15mes
        Metadata
        Bindings
        • 0. 96
        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` = 180 limit 1
        6.09msview::theme::author.card:16mes
        Metadata
        Bindings
        • 0. 180
        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` = 96 and `article_attachments`.`article_id` is not null
        2.99ms/app/Models/Article.php:262mes
        Metadata
        Bindings
        • 0. 96
        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` = 96
        7.17msview::theme::article.components.companies:1mes
        Metadata
        Bindings
        • 0. 96
        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` = 96
        18.72msview::theme::article.view.generic:45mes
        Metadata
        Bindings
        • 0. 96
        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 * from `categories` where `categories`.`id` = 1 limit 1
        2.93ms/app/Models/Category.php:266mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 21. /app/Models/Category.php:266
        • 27. view::theme::article.view.generic:46
        • 29. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 30. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 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` = 96
        12.07msview::theme::article.view.generic:51mes
        Metadata
        Bindings
        • 0. 96
        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-03-16 07:24:13' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        174ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-03-16 07:24:13
        • 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)
        2.64ms/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.3ms/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.31ms/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-03-16 07:24:14' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        83.81ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-03-16 07:24:14
        • 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
        3.21ms/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 (2, 14, 17, 18, 13, 1004, 15, 16, 19) limit 5
        3.95ms/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)
        2.01ms/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.63ms/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.59ms/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.14ms/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)
        3.82ms/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)
        3.09ms/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.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 `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
        7.41ms/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.46ms/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.12ms/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.06ms/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
        2.83ms/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)
        1.41ms/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)
        1.69ms/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)
        750μ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 `parent_id` is null and `id` not in (999, 100, 1061)
        3.04msview::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.14ms/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.79ms/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-03-16 07:24:14' 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
        182msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:14
        • 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.63msview::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)
        2.59msview::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)
        3.12msview::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
        1.73ms/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
        2.13ms/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-03-16 07:24:14' 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
        128msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:14
        • 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.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 (2)
        1.48msview::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)
        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` = 4 limit 1
        1.82ms/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
        3.22ms/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-03-16 07:24:14' 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
        126msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:14
        • 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)
        2.03msview::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)
        2.95msview::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)
        3.18msview::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.51ms/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.91ms/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-03-16 07:24:15' 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
        178msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:15
        • 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)
        4.29msview::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.57msview::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.63msview::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-03-16 07:24:15' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        219ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-03-16 07:24:15
        • 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)
        2.55ms/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.6ms/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)
        2.38ms/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-03-16 07:24:16' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        171ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-03-16 07:24:16
        • 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
        3.3ms/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
        6.54ms/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)
        1.75ms/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)
        2.43ms/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.6ms/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
        5.03ms/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)
        1.98ms/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.91ms/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.99ms/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.87ms/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.91ms/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.33ms/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.32ms/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
        1.66ms/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)
        1.62ms/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)
        2.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)
        1.63ms/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.82msview::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` = 3 limit 1
        2.76ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 3
        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` = 3 and `categories`.`parent_id` is not null order by `shortname` asc
        2.61ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 3
        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-03-16 07:24:16' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 3 or `primary_category` = 1005 or `primary_category` = 23 or `primary_category` = 26 or `primary_category` = 25 or `primary_category` = 21 or `primary_category` = 20 or `primary_category` = 24 or `primary_category` = 22) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        199msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:16
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 3
        • 5. 1005
        • 6. 23
        • 7. 26
        • 8. 25
        • 9. 21
        • 10. 20
        • 11. 24
        • 12. 22
        • 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 (23, 25)
        2.26msview::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 (3)
        2.12msview::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.33msview::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
        1.87ms/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
        2.66ms/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-03-16 07:24:16' 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
        120msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:16
        • 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)
        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 (4)
        1.03msview::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.29msview::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.75ms/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
        1.44ms/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-03-16 07:24:16' 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
        140msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:16
        • 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)
        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 (5)
        4.1msview::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.47msview::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
        3.59ms/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
        2.93ms/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-03-16 07:24:17' 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
        122msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-16 07:24:17
        • 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)
        1.99msview::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.43msview::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)
        850μsview::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
      284
      App\Models\Article
      141
        _token
        klqmiRr73l37IspeuSelgAGY9ZaE2JkmwnKi44hF
        _previous
        array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/safety-certification/when-within-...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /avionics/safety-certification/when-within-development-life-cycle
        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:24 [ "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" ] "priority" => array:1 [ 0 => "u=0, i" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cf-connecting-ip" => array:1 [ 0 => "18.118.171.28" ] "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" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "x-forwarded-for" => array:1 [ 0 => "18.118.171.28" ] "cf-ray" => array:1 [ 0 => "92128274af3cf83d-ORD" ] "host" => array:1 [ 0 => "dev007.militaryembedded.com" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
        request_server
        0 of 0
        array:47 [ "USER" => "forge" "HOME" => "/home/forge" "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_PRIORITY" => "u=0, i" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CF_CONNECTING_IP" => "18.118.171.28" "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_SEC_FETCH_SITE" => "none" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_X_FORWARDED_FOR" => "18.118.171.28" "HTTP_CF_RAY" => "92128274af3cf83d-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" => "18.118.171.28" "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" => "/avionics/safety-certification/when-within-development-life-cycle" "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" => 1742109853.0365 "REQUEST_TIME" => 1742109853 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 16 Mar 2025 07:24:15 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IklacXNZdlJuaUlDNUFHOWFNUVBmV1E9PSIsInZhbHVlIjoiS1NoczdndytqRDAyY2NxanhBNFNaTGZ3MlhDU1U1U0pYbC9OT2NTY003akowOU5Sc2I3c3ErKy9Xdm9iTE9TWEFKUW9xSWRjRlluOFpRa0Jxb0o4V0V0Rk9LZlh1VWRyTXMybFdTdDA5OUtWYjcvbXNXM1I4aWYvbTVKd2JYeEwiLCJtYWMiOiJkNTI2N2NiNzYwM2Q5MmNiM2ZjMTg0NzI1ZDdhNjczNGVhMDQzZjhmYWYwYjNhYzRlYTY0ZDNlYTJjOGIwNGUzIiwidGFnIjoiIn0%3D; expires=Sun, 16 Mar 2025 09:24:17 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IklacXNZdlJuaUlDNUFHOWFNUVBmV1E9PSIsInZhbHVlIjoiS1NoczdndytqRDAyY2NxanhBNFNaTGZ3MlhDU1U1U0pYbC9OT2NTY003akowOU5Sc2I3c3ErKy9Xdm9iTE9TWEFKUW9xS" 1 => "military_embedded_systems_session=eyJpdiI6InkrQjdOcjNuVWFJYURoN213d1d4N2c9PSIsInZhbHVlIjoiRTBLbUs3ckxBaDBPV3BLTkYybHZLVnowaC8rVFJRZjIvMFl5N2VJWExYdVMzUndXTGdRWFNadWdONFhQc01wSU0wdk5PRW9QTXI1b1htK2lFYk1NR0N2UTVvVWhhT1RoR3plOERhWW01WmRLdkJBTk9Dd1M2bWZyUzRmNmgvQ0QiLCJtYWMiOiI3ZjEzY2ZlZjkzNjQ5MmM2MzJkMWUxYThmZGM4MWE4Y2QyYmQ1ZTBjYmY3YmYwZmFiYjA4M2YxNzFiMGU5YzIyIiwidGFnIjoiIn0%3D; expires=Sun, 16 Mar 2025 09:24:17 GMT; Max-Age=7200; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6InkrQjdOcjNuVWFJYURoN213d1d4N2c9PSIsInZhbHVlIjoiRTBLbUs3ckxBaDBPV3BLTkYybHZLVnowaC8rVFJRZjIvMFl5N2VJWExYdVMzUndXTGdRWF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IklacXNZdlJuaUlDNUFHOWFNUVBmV1E9PSIsInZhbHVlIjoiS1NoczdndytqRDAyY2NxanhBNFNaTGZ3MlhDU1U1U0pYbC9OT2NTY003akowOU5Sc2I3c3ErKy9Xdm9iTE9TWEFKUW9xSWRjRlluOFpRa0Jxb0o4V0V0Rk9LZlh1VWRyTXMybFdTdDA5OUtWYjcvbXNXM1I4aWYvbTVKd2JYeEwiLCJtYWMiOiJkNTI2N2NiNzYwM2Q5MmNiM2ZjMTg0NzI1ZDdhNjczNGVhMDQzZjhmYWYwYjNhYzRlYTY0ZDNlYTJjOGIwNGUzIiwidGFnIjoiIn0%3D; expires=Sun, 16-Mar-2025 09:24:17 GMT; path=/XSRF-TOKEN=eyJpdiI6IklacXNZdlJuaUlDNUFHOWFNUVBmV1E9PSIsInZhbHVlIjoiS1NoczdndytqRDAyY2NxanhBNFNaTGZ3MlhDU1U1U0pYbC9OT2NTY003akowOU5Sc2I3c3ErKy9Xdm9iTE9TWEFKUW9xS" 1 => "military_embedded_systems_session=eyJpdiI6InkrQjdOcjNuVWFJYURoN213d1d4N2c9PSIsInZhbHVlIjoiRTBLbUs3ckxBaDBPV3BLTkYybHZLVnowaC8rVFJRZjIvMFl5N2VJWExYdVMzUndXTGdRWFNadWdONFhQc01wSU0wdk5PRW9QTXI1b1htK2lFYk1NR0N2UTVvVWhhT1RoR3plOERhWW01WmRLdkJBTk9Dd1M2bWZyUzRmNmgvQ0QiLCJtYWMiOiI3ZjEzY2ZlZjkzNjQ5MmM2MzJkMWUxYThmZGM4MWE4Y2QyYmQ1ZTBjYmY3YmYwZmFiYjA4M2YxNzFiMGU5YzIyIiwidGFnIjoiIn0%3D; expires=Sun, 16-Mar-2025 09:24:17 GMT; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6InkrQjdOcjNuVWFJYURoN213d1d4N2c9PSIsInZhbHVlIjoiRTBLbUs3ckxBaDBPV3BLTkYybHZLVnowaC8rVFJRZjIvMFl5N2VJWExYdVMzUndXTGdRWF" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "klqmiRr73l37IspeuSelgAGY9ZaE2JkmwnKi44hF" "_previous" => array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/safety-certification/when-within-development-life-cycle" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]