Military Embedded Systems

Ada Watch: Choosing the right Ada subset for strong static guarantees

Blog

August 13, 2013

Yannick Moy

AdaCore

While Ada offers many features that act as safety guards at run time, by raising exceptions when a violation is detected, some of these features may be too complex to guarantee a safe execution before the program is run. This is the case for example of pointers, which may be used to create arbitrarily complex shared data structures in memory. SPARK is a subset of Ada that forbids these features, most notably pointers, in order to be able to provide strong guarantees at compile time. A preview of the next revision of SPARK called SPARK 2014 is already available, as well as the associated verification tools.

Although SPARK evolution has followed the evolutions of Ada, with a new version of SPARK for each new version of Ada (SPARK 83, SPARK 95, SPARK 2005), the new revision SPARK 2014 is quite different in a number of aspects. SPARK 2014 is the result of a project started in 2010 with the objective of making it cost-effective to use formal verification instead of testing for critical software. Just a few months before, Airbus had presented their five “must-have” criteria for adopting a formal method: soundness, applicability to the code, usability by “normal” engineers on “normal” computers, improve on classical methods, certifiability. We have had these five criteria very much in mind during these three years, and here are the results for SPARK 2014 and the associated verification tool GNATprove.

Soundness:

This is the cornerstone of the language and the tools. It is not limited to saying: "we use Hoare logic". What we want to achieve is "maximum" soundness: not only the tools cannot state wrong properties when you use them appropriately, but it should not be easy to get a false sense of confidence in the software by misusing the tools (for example by stating a wrong axiom). Many decisions were taken to ensure maximum soundness, like forbidding users from stating axioms.

Applicability to the code:

SPARK 2014 is the largest possible subset of Ada that still makes it possible to do formal verification. In particular, it includes generics, tagged types, discriminants, dynamic types, early returns, and many other features that were excluded from SPARK 2005. And we have made it possible to combine formal verification with testing, for those parts of the code that cannot be formally analyzed. So it's not an all-or-nothing technology, but one that you can introduce in any Ada project really.

Usability by normal engineers:

This is the issue that made us most busy all these years. First, we have achieved a level of automation where most proofs go through automatically, in particular the proofs of absence of run-time error. Secondly, we have tightly integrated the tools in the developer workflow (for example, through use of project files and automatically computed dependencies) and development environment (for example, the ability to run GNATprove on a specific subprogram or line of code, and the display of problematic program paths).

Improve on testing:

The fact that formal verification is exhaustive makes it an ideal replacement for the costly unit-testing activity mandated for critical software. The main challenge here was to facilitate progressive adoption of formal verification. Because the subprogram contracts needed for formal verification are already useful for testing, and because GNATprove can be applied separately to individual SPARK subprograms in any Ada program, switching to formal verification can be done in a matter of days.

Certifiability:

When we started the project, the formal methods supplement for the avionics standard DO-178 was not yet finalized. Since then, it has been published with the new version of the standard, DO-178C, so today, GNATprove can be used instead of testing for critical embedded programs in planes developed at the highest levels A or B. We have published a paper in IEEE Software on how to deal with the subtle issue of coverage in that case. Of course, projects in other domains in which formal methods are already recognized (for example, railway) may also use GNATprove.

The results of the industrial case studies developed in the project are publicly available, for others to get a feeling at what the new technology is good at, and the current stage of development. Perhaps the most frequent comment, when users switched from previous SPARK technology to this new SPARK 2014 one, was the incredible usability improvement provided by the ability to execute specifications. This kind of combination of dynamic techniques and static ones is certainly promising for the future of software verification.

 

Featured Companies

AdaCore

150 W. 30th Street, 16th floor
New York, NY 10001
Categories
Avionics - Software
Topic Tags
8.2.22PHP Version5.49sRequest Duration6MBMemory UsageGET avionics/{uri_path?}Route
    • Booting (269ms)
    • Application (5.21s)
    • 1 x Application (95.06%)
      5.21s
      1 x Booting (4.91%)
      269.48ms
      82 templates were rendered
      • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
        Params
        0
        displayed_articles
        1
        page_title
        2
        article
      • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        authors
      • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        company
        8
        loop
      • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        category
      • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        socialMedia
      • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
        Params
        0
        displayed_articles
        1
        page_title
        2
        article
      • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        authors
      • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        company
        8
        loop
      • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        category
      • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        navbarCategories
        9
        category
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        subfooterCategories
        9
        categoryBuilder
        10
        categories
        11
        category
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        loop
        8
        socialMedia
      uri
      GET 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
      104 statements were executed, 63 of which were duplicated, 41 unique. Show only duplicated3.24s
      • select * from `articles` where `shortname` = 'ada-watch-choosing-the-right-ada-subset-for-strong-static-guarantees' and `publish_at` < '2025-03-17 10:07:34' limit 1
        27.34ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Bindings
        • 0. ada-watch-choosing-the-right-ada-subset-for-strong-static-guarantees
        • 1. 2025-03-17 10:07:34
        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 (1002)
        2.77ms/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.02ms/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 (1)
        4.75ms/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` = 1371
        15.93msview::theme::article.view.generic:15mes
        Metadata
        Bindings
        • 0. 1371
        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` = 102 limit 1
        6.48msview::theme::author.card:16mes
        Metadata
        Bindings
        • 0. 102
        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` = 1371 and `article_attachments`.`article_id` is not null
        3.27ms/app/Models/Article.php:262mes
        Metadata
        Bindings
        • 0. 1371
        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` = 1371
        13.77msview::theme::article.components.companies:1mes
        Metadata
        Bindings
        • 0. 1371
        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` = 1371
        8.32msview::theme::article.view.generic:45mes
        Metadata
        Bindings
        • 0. 1371
        Backtrace
        • 19. view::theme::article.view.generic:45
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select `tags`.*, `articles_tags`.`article_id` as `pivot_article_id`, `articles_tags`.`tag_id` as `pivot_tag_id` from `tags` inner join `articles_tags` on `tags`.`id` = `articles_tags`.`tag_id` where `articles_tags`.`article_id` = 1371
        8.46msview::theme::article.view.generic:51mes
        Metadata
        Bindings
        • 0. 1371
        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-17 10:07:34' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        131ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-03-17 10:07:34
        • 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.6ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (1, 2, 3, 4, 6)
        2.44ms/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.09ms/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-17 10:07:35' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        107ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-03-17 10:07:35
        • 3. 
        • 4. 0
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:38
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6) order by `shortname` asc
        1.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 (2, 14, 17, 18, 13, 1004, 15, 16, 19) limit 5
        2.93ms/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.34ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (2)
        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)
        1.49ms/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
        3.84ms/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)
        2.2ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (3)
        1.3ms/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.22ms/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 (4, 32, 31, 30, 29, 27) limit 5
        47.84ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 4
        • 3. 32
        • 4. 31
        • 5. 30
        • 6. 29
        • 7. 27
        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 (30, 32)
        2.12ms/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 (4)
        900μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2, 3)
        2.11ms/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
        9.03ms/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)
        2.04ms/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.21ms/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.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 `parent_id` is null and `id` not in (999, 100, 1061)
        3.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` = 2 limit 1
        2.39ms/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.27ms/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-17 10:07:35' 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
        294msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:35
        • 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.2msview::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)
        3.26msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3, 4)
        3.72msview::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` = 3 limit 1
        6.06ms/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
        3.07ms/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-17 10:07:36' 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
        237msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:36
        • 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)
        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 (3)
        1.96msview::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.16msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 4 limit 1
        2.07ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 4
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 4 and `categories`.`parent_id` is not null order by `shortname` asc
        1.41ms/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-17 10:07:36' 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
        199msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:36
        • 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)
        7.46msview::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.89msview::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.77msview::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.53ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 5 and `categories`.`parent_id` is not null order by `shortname` asc
        2.25ms/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-17 10:07:36' 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
        311msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:36
        • 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.43msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (5)
        1.56msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3)
        1.36msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-03-17 10:07:37' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        282ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-03-17 10:07:37
        • 4. 
        • 5. 0
        Backtrace
        • 14. /app/Models/Article.php:375
        • 15. view::theme::layouts.components.sidebar:8
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (7, 13, 15, 19, 21, 23, 24, 25, 26, 27, 31, 32, 44, 47, 1000, 1001)
        4.43ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (1, 2, 3, 4, 6)
        2.08ms/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.99ms/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-17 10:07:37' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        89.05ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-03-17 10:07:37
        • 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.17ms/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
        4.6ms/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)
        2.34ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (1)
        3.31ms/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)
        890μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (3, 1005, 23, 26, 25, 21, 20, 24, 22) limit 5
        1.57ms/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.79ms/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)
        5.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)
        1.95ms/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
        16.11ms/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.36ms/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.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.86ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (6, 45, 44, 46, 1008, 1006, 40, 43, 47, 39, 41, 42, 1007) limit 5
        5.47ms/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)
        4.12ms/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)
        3.52ms/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.56ms/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.97msview::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.79ms/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
        5.72ms/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-17 10:07:37' 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
        254msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:37
        • 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.2msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (1)
        1.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.13msview::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
        5.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
        3.22ms/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-17 10:07:38' 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
        174msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:38
        • 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.61msview::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.55msview::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)
        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` = 3 limit 1
        3.24ms/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.08ms/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-17 10:07:38' 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
        373msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:38
        • 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)
        7.96msview::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.75msview::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.53msview::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.45ms/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
        3.62ms/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-17 10:07:39' 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
        415msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 10:07:39
        • 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.06msview::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.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)
        2.54msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      App\Models\Tag
      1
      App\Models\Company
      2
      App\Models\Author
      1
      App\Models\ArticleType
      32
      App\Models\Category
      278
      App\Models\Article
      141
        _token
        j5VkMHhvseCiBQRmSgq20tLTC4UAQsEeZyCeeD7B
        _previous
        array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/software/ada-watch-choosing-the-r...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /avionics/software/ada-watch-choosing-the-right-ada-subset-for-strong-static-guarantees
        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.191.91.147" ] "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.191.91.147" ] "cf-ray" => array:1 [ 0 => "921baf1d8c5eeac6-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.191.91.147" "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.191.91.147" "HTTP_CF_RAY" => "921baf1d8c5eeac6-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.191.91.147" "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/software/ada-watch-choosing-the-right-ada-subset-for-strong-static-guarantees" "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" => 1742206054.169 "REQUEST_TIME" => 1742206054 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 17 Mar 2025 10:07:37 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBVR0RmTncwWldGVTVkZjk1c1FyTGc9PSIsInZhbHVlIjoiS0dPTE8vdGQwSzVkbUt6REZRdEliN1VFZjBDMTc5dE1NUnpuaCtXYjVMcTF3T2JGRFR2MFBZYkVUWVd0K0xZU0s0NEg2ZVlWUjNXeVpLQnRFOHpnWTAxeWE1UUlkYTlMa1ZRTmNoeDhmNVBqQnFYMVhwOVl5am9hUGUzTnRIZXYiLCJtYWMiOiI4ODY5NDlhODJlMmRhYjgxY2E1MjY2MmUyNjgzOWVjMTMyZjViYmUxYjQ0NjBlNzE5YTU1NDhhOTcyM2YxYTBiIiwidGFnIjoiIn0%3D; expires=Mon, 17 Mar 2025 12:07:39 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjBVR0RmTncwWldGVTVkZjk1c1FyTGc9PSIsInZhbHVlIjoiS0dPTE8vdGQwSzVkbUt6REZRdEliN1VFZjBDMTc5dE1NUnpuaCtXYjVMcTF3T2JGRFR2MFBZYkVUWVd0K0xZU0s0NEg2Z" 1 => "military_embedded_systems_session=eyJpdiI6Ik9palpML2k1ZE0zWDJCQktVWlBWVWc9PSIsInZhbHVlIjoiRFhiOHFwd1M5NUVHUENSZWtmU1ViMUJFOHB2SFRTQTgwSFhCWU8zdFBscjQzNVF6a0tVSzFCSEFwcXArV2FMblhMcnhQZXRzV1QyT2wrVjNMM1RTMFQwRnZSa3hlUFlzejJtSTdwSXFjakY3N21HQW94N085NzNkNFNkTlp2dngiLCJtYWMiOiI3NjI4NGY2ZmZkMzU3OTYwM2M2NjU2MmU2NGVmMmU2MDhhZDQ2OTIxNWU5NGI2NzBhZmJhMjdlOTU4ZDE5YmNjIiwidGFnIjoiIn0%3D; expires=Mon, 17 Mar 2025 12:07:39 GMT; Max-Age=7200; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6Ik9palpML2k1ZE0zWDJCQktVWlBWVWc9PSIsInZhbHVlIjoiRFhiOHFwd1M5NUVHUENSZWtmU1ViMUJFOHB2SFRTQTgwSFhCWU8zdFBscjQzNVF6a0tVSz" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBVR0RmTncwWldGVTVkZjk1c1FyTGc9PSIsInZhbHVlIjoiS0dPTE8vdGQwSzVkbUt6REZRdEliN1VFZjBDMTc5dE1NUnpuaCtXYjVMcTF3T2JGRFR2MFBZYkVUWVd0K0xZU0s0NEg2ZVlWUjNXeVpLQnRFOHpnWTAxeWE1UUlkYTlMa1ZRTmNoeDhmNVBqQnFYMVhwOVl5am9hUGUzTnRIZXYiLCJtYWMiOiI4ODY5NDlhODJlMmRhYjgxY2E1MjY2MmUyNjgzOWVjMTMyZjViYmUxYjQ0NjBlNzE5YTU1NDhhOTcyM2YxYTBiIiwidGFnIjoiIn0%3D; expires=Mon, 17-Mar-2025 12:07:39 GMT; path=/XSRF-TOKEN=eyJpdiI6IjBVR0RmTncwWldGVTVkZjk1c1FyTGc9PSIsInZhbHVlIjoiS0dPTE8vdGQwSzVkbUt6REZRdEliN1VFZjBDMTc5dE1NUnpuaCtXYjVMcTF3T2JGRFR2MFBZYkVUWVd0K0xZU0s0NEg2Z" 1 => "military_embedded_systems_session=eyJpdiI6Ik9palpML2k1ZE0zWDJCQktVWlBWVWc9PSIsInZhbHVlIjoiRFhiOHFwd1M5NUVHUENSZWtmU1ViMUJFOHB2SFRTQTgwSFhCWU8zdFBscjQzNVF6a0tVSzFCSEFwcXArV2FMblhMcnhQZXRzV1QyT2wrVjNMM1RTMFQwRnZSa3hlUFlzejJtSTdwSXFjakY3N21HQW94N085NzNkNFNkTlp2dngiLCJtYWMiOiI3NjI4NGY2ZmZkMzU3OTYwM2M2NjU2MmU2NGVmMmU2MDhhZDQ2OTIxNWU5NGI2NzBhZmJhMjdlOTU4ZDE5YmNjIiwidGFnIjoiIn0%3D; expires=Mon, 17-Mar-2025 12:07:39 GMT; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6Ik9palpML2k1ZE0zWDJCQktVWlBWVWc9PSIsInZhbHVlIjoiRFhiOHFwd1M5NUVHUENSZWtmU1ViMUJFOHB2SFRTQTgwSFhCWU8zdFBscjQzNVF6a0tVSz" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "j5VkMHhvseCiBQRmSgq20tLTC4UAQsEeZyCeeD7B" "_previous" => array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/software/ada-watch-choosing-the-right-ada-subset-for-strong-static-guarantees" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]