Military Embedded Systems

Code Quality: Dynamic & static analysis combined makes engineers & auditors happy

Blog

March 28, 2013

Mark Pitchford

LDRA Technology

In the good old days, before writing software became “software engineering,” code development was a black art practiced by weird nerdy kids straight out of college. For them, coding was by no means a structured discipline. If you managed to get them to communicate, they might tell you that they were hacking code together and using ad hoc test data to see whether it did what it was supposed to do when they executed it.

Whether they knew it or not, they were practicing dynamic analysis through system functional test. Unlike static analysis, dynamic analysis involves code execution by definition.

But what did this do beyond showing the basic functionality as roughly correct for whatever rudimentary test data was dreamed up? While better than nothing, likely no more than half of the code was exercised. Jack Ganssle, industry software guru, and chief consultant for The Ganssle Group, and industry editor, concurs: “Studies confirm that, without the use of code coverage analysis, testing typically exercises only 50% of the code. Given typical bug rates, that means 100K lines of code in a program will ship with 2500 to 5000 bugs. These bugs lead to many systems failures.”

Why? Because no matter how imaginative the tests, chances are that real life will throw some curve balls to try out the untested paths. And if something executes that wasn’t tested, you’re likely in for some surprises and potentially catastrophic failures.

Fast forward 30 or 40 years. Although such a homespun approach doesn’t cut it with complex military embedded applications, functional test remains at the core of what dynamic test can do. Carefully selected test data show that the branches and statements in the source code are exercised in accordance with specification, allowing us to not only show that the system is functionally correct, but also that we have exercised all of it. When used in tandem with static analysis, dynamic analysis provides the supporting evidence needed to prove that all of our other good works and best practices yield a safe, secure, and high-quality end product.

Unlike the hacking of years ago, today’s automated test tools precisely trace the execution route via techniques such as the use of instrumentation probes. These probes are essentially additional function calls that generate “I’ve been here” messages from strategic points in the source code and allow coverage data to be collated. They allow dynamic tests to generate feedback on how comprehensive they are, so that we can successively build on each set of results until the desired level of coverage is reached.

In turn, this gives us flexibility in how much code is exercised at a time. Dynamic analysis of an entire system is possible, but there are always routes through the code which cannot be exercised by our system during normal operation – defensive code for instance; perhaps a check for a division by zero.

At times like this, it’s good to also use “Unit tests.” Unit tests encapsulate a subset of the system and allow parameters to be passed such that the defense mechanism code in our example is exercised. We even have the option of basing application dynamic analysis entirely on unit tests, collating code coverage data as each module is developed and removing any requirement to wait for a complete system.

Today’s military applications require support for architectural standards such as ARINC 653 or FACE to improve code portability and reusability. The provision of comprehensive coverage data by means of dynamic analysis provides evidence that code remains maintainable, safe, and secure even when ported to a different application, particularly when used in tandem with an effective static analysis regime.

Our nerdy friends of yesteryear weren’t easily impressed, but they would surely recognize what we are doing as an extension of their own test efforts. Who knows?! We might even get a grunt of approval for our system failure rates or maybe even high fives over the mounds of Coke cans and pizza boxes stacked around their computers!

 

 

Featured Companies

LDRA Technology

2540 King Arthur Blvd, Suite #228
Lewisville, TX 75056
Categories
Avionics - Software
Topic Tags
8.2.22PHP Version9.61sRequest Duration6MBMemory UsageGET avionics/{uri_path?}Route
    • Booting (534ms)
    • Application (9.07s)
    • 1 x Application (94.4%)
      9.07s
      1 x Booting (5.56%)
      533.65ms
      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, 62 of which were duplicated, 42 unique. Show only duplicated6.52s
      • select * from `articles` where `shortname` = 'code-quality-dynamic-static-analysis-combined-makes-engineers-auditors-happy' and `publish_at` < '2025-03-17 12:44:47' limit 1
        18.25ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Bindings
        • 0. code-quality-dynamic-static-analysis-combined-makes-engineers-auditors-happy
        • 1. 2025-03-17 12:44:47
        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)
        4.99ms/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)
        5.12ms/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.49ms/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` = 1174
        13.37msview::theme::article.view.generic:15mes
        Metadata
        Bindings
        • 0. 1174
        Backtrace
        • 19. view::theme::article.view.generic:15
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `companies` where `companies`.`id` = 180 limit 1
        2.17msview::theme::author.card:16mes
        Metadata
        Bindings
        • 0. 180
        Backtrace
        • 21. view::theme::author.card:16
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 26. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_attachments` where `article_attachments`.`article_id` = 1174 and `article_attachments`.`article_id` is not null
        6.68ms/app/Models/Article.php:262mes
        Metadata
        Bindings
        • 0. 1174
        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` = 1174
        24.46msview::theme::article.components.companies:1mes
        Metadata
        Bindings
        • 0. 1174
        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` = 1174
        36.84msview::theme::article.view.generic:45mes
        Metadata
        Bindings
        • 0. 1174
        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` = 1174
        35.08msview::theme::article.view.generic:51mes
        Metadata
        Bindings
        • 0. 1174
        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 12:44:48' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        567ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-03-17 12:44:48
        • 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)
        6.71ms/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)
        5.06ms/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)
        5.52ms/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 12:44:48' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        296ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-03-17 12:44:48
        • 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
        5.96ms/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
        15.59ms/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)
        4.82ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (2)
        6.25ms/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.5ms/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
        182ms/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)
        3.05ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (4)
        4.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, 3)
        6.59ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (5, 37, 36, 35) limit 5
        25.9ms/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)
        5.01ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (5)
        4.44ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        8.26ms/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
        19.27ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 6
        • 3. 45
        • 4. 44
        • 5. 46
        • 6. 1008
        • 7. 1006
        • 8. 40
        • 9. 43
        • 10. 47
        • 11. 39
        • 12. 41
        • 13. 42
        • 14. 1007
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (43, 44, 46)
        12.97ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (6)
        8.79ms/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)
        8.29ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `parent_id` is null and `id` not in (999, 100, 1061)
        8.1msview::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
        10.68ms/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
        15.39ms/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 12:44:49' 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
        606msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:49
        • 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)
        6.33msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (2)
        3.3msview::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)
        7.75msview::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
        2.1ms/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
        5.99ms/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 12:44:50' 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
        747msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:50
        • 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)
        6.24msview::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)
        7.08msview::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.91msview::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
        9.73ms/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
        11.17ms/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 12:44:51' 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
        523msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:51
        • 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.19msview::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)
        3.22msview::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.79msview::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
        8.41ms/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
        9.56ms/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 12:44:51' 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
        572msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:51
        • 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)
        7.84msview::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)
        3.38msview::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.97msview::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 12:44:52' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        523ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-03-17 12:44:52
        • 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)
        6.49ms/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.59ms/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)
        5.18ms/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 12:44:53' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        173ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-03-17 12:44:53
        • 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
        7.63ms/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
        18.46ms/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)
        3.3ms/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)
        5.83ms/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.8ms/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
        2.77ms/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.15ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (3)
        3.14ms/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.55ms/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
        124ms/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)
        4.55ms/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)
        5.36ms/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)
        4.28ms/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.12ms/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)
        2.61ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (6)
        1.62ms/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.81ms/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)
        1.93msview::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
        7.68ms/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
        6.3ms/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 12:44:54' 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
        484msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:54
        • 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)
        3.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` in (1)
        3.52msview::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.89msview::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
        2.17ms/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
        1.73ms/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 12:44:54' 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
        360msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:54
        • 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)
        5.91msview::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)
        4.82msview::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.23msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 4 limit 1
        1.23ms/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
        8.3ms/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 12:44:55' 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
        385msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:55
        • 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)
        3.03msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (4)
        3.22msview::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.38msview::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
        6.07ms/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
        5.72ms/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 12:44:55' 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
        351msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-03-17 12:44:55
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 6
        • 5. 45
        • 6. 44
        • 7. 46
        • 8. 1008
        • 9. 1006
        • 10. 40
        • 11. 43
        • 12. 47
        • 13. 39
        • 14. 41
        • 15. 42
        • 16. 1007
        • 17. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (44, 47, 1007)
        1.63msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (6)
        2.4msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (3)
        2.6msview::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
      2
      App\Models\Company
      2
      App\Models\Author
      1
      App\Models\ArticleType
      31
      App\Models\Category
      283
      App\Models\Article
      141
        _token
        qxkAlWvprx42yednUmLhj8OY703Ioq35yr30llCJ
        _previous
        array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/software/code-quality-dynamic-sta...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /avionics/software/code-quality-dynamic-static-analysis-combined-makes-engineers-auditors-happy
        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.222.254.247" ] "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.222.254.247" ] "cf-ray" => array:1 [ 0 => "921c95653b3298b9-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.222.254.247" "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.222.254.247" "HTTP_CF_RAY" => "921c95653b3298b9-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.222.254.247" "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/code-quality-dynamic-static-analysis-combined-makes-engineers-auditors-happy" "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" => 1742215486.4758 "REQUEST_TIME" => 1742215486 ]
        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 12:44:52 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkczNWxDRmY3VmJjbUtOb3h4cFprWVE9PSIsInZhbHVlIjoiUDlFT1VCd0VyaW92MWw4Y0loWEUweVFMNFJvdzlpRXlGWWU5VHJmMjNrVjdnNHc3NWc2R3VkT2QwaXNWMlpjVEhBTDlQdjRWNFE2Rk9rMTFQS2czTTR4cGhKQlRJN2w1enZpbHlGdFFmYVJubS9nM2t1WnN5dFhEOXFCdVJHek8iLCJtYWMiOiI2NzU5NDU3NGQ0Njc5MGE0YTAwMTI0ODZkMTRkMzZhNjM4NWI0OWIzZjFmMDA0NWE3OGJmOWI2Njg0MGJmOTBjIiwidGFnIjoiIn0%3D; expires=Mon, 17 Mar 2025 14:44:56 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IkczNWxDRmY3VmJjbUtOb3h4cFprWVE9PSIsInZhbHVlIjoiUDlFT1VCd0VyaW92MWw4Y0loWEUweVFMNFJvdzlpRXlGWWU5VHJmMjNrVjdnNHc3NWc2R3VkT2QwaXNWMlpjVEhBTDlQd" 1 => "military_embedded_systems_session=eyJpdiI6Ikx0NzhoUVRRalBNQzlBbTlSekFib2c9PSIsInZhbHVlIjoidmt3L3VQVFBDQkpnNTF6a3NLN1lyUHBNMXltejN3TlVCOG83MGNNaTY0L2pRczMxQ3E1SlNOL3lLTHdZY0Qwckd3YkR6ams5aXd3T01vMlJxYlRNSFg5dzQrQUZHMGJibllKOEp0QkFwSk53dXQzci9SZkpZMTJnVjcrM0RUQngiLCJtYWMiOiI4YTNiMTM0M2Y1MzZkNWQ3NTI0YjEwZWFlNTZhNTRlZGUyMjBiOGY4MzQzNjlhYWViZjliNjA0OTg0YWI3NTRjIiwidGFnIjoiIn0%3D; expires=Mon, 17 Mar 2025 14:44:56 GMT; Max-Age=7200; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6Ikx0NzhoUVRRalBNQzlBbTlSekFib2c9PSIsInZhbHVlIjoidmt3L3VQVFBDQkpnNTF6a3NLN1lyUHBNMXltejN3TlVCOG83MGNNaTY0L2pRczMxQ3E1Sl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkczNWxDRmY3VmJjbUtOb3h4cFprWVE9PSIsInZhbHVlIjoiUDlFT1VCd0VyaW92MWw4Y0loWEUweVFMNFJvdzlpRXlGWWU5VHJmMjNrVjdnNHc3NWc2R3VkT2QwaXNWMlpjVEhBTDlQdjRWNFE2Rk9rMTFQS2czTTR4cGhKQlRJN2w1enZpbHlGdFFmYVJubS9nM2t1WnN5dFhEOXFCdVJHek8iLCJtYWMiOiI2NzU5NDU3NGQ0Njc5MGE0YTAwMTI0ODZkMTRkMzZhNjM4NWI0OWIzZjFmMDA0NWE3OGJmOWI2Njg0MGJmOTBjIiwidGFnIjoiIn0%3D; expires=Mon, 17-Mar-2025 14:44:56 GMT; path=/XSRF-TOKEN=eyJpdiI6IkczNWxDRmY3VmJjbUtOb3h4cFprWVE9PSIsInZhbHVlIjoiUDlFT1VCd0VyaW92MWw4Y0loWEUweVFMNFJvdzlpRXlGWWU5VHJmMjNrVjdnNHc3NWc2R3VkT2QwaXNWMlpjVEhBTDlQd" 1 => "military_embedded_systems_session=eyJpdiI6Ikx0NzhoUVRRalBNQzlBbTlSekFib2c9PSIsInZhbHVlIjoidmt3L3VQVFBDQkpnNTF6a3NLN1lyUHBNMXltejN3TlVCOG83MGNNaTY0L2pRczMxQ3E1SlNOL3lLTHdZY0Qwckd3YkR6ams5aXd3T01vMlJxYlRNSFg5dzQrQUZHMGJibllKOEp0QkFwSk53dXQzci9SZkpZMTJnVjcrM0RUQngiLCJtYWMiOiI4YTNiMTM0M2Y1MzZkNWQ3NTI0YjEwZWFlNTZhNTRlZGUyMjBiOGY4MzQzNjlhYWViZjliNjA0OTg0YWI3NTRjIiwidGFnIjoiIn0%3D; expires=Mon, 17-Mar-2025 14:44:56 GMT; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6Ikx0NzhoUVRRalBNQzlBbTlSekFib2c9PSIsInZhbHVlIjoidmt3L3VQVFBDQkpnNTF6a3NLN1lyUHBNMXltejN3TlVCOG83MGNNaTY0L2pRczMxQ3E1Sl" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "qxkAlWvprx42yednUmLhj8OY703Ioq35yr30llCJ" "_previous" => array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/software/code-quality-dynamic-static-analysis-combined-makes-engineers-auditors-happy" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]