Military Embedded Systems

Code Quality: Improving testing for military-grade applications

Blog

September 18, 2013

Mark Pitchford

LDRA Technology

Once upon a time, long, long ago, the only kind of dynamic software test was a system functional test. The battle against unreliable software was exclusively fought with complete system test in which an application’s worth was proven by reference to a set of requirements, a set of test data, and expected results.

While this still provides a vital component of the validation and verification process, most test data sets only exercise particular parts of the code. Unfortunately, it is that unusual code path which is only called into play when something out of the ordinary takes place that can lead to in-field catastrophic results. An example might be the test of a divisor to ensure that it is not zero prior to use in a calculation. It should never happen – but what if it does, and the test is flawed?

To prevent this kind of possibility, it’s good to introduce unit and integration testing as well. Unit test involves writing a wrapper ”harness” around a function or procedure, passing data to it, and ensuring that the output generated is in line with design requirements. Integration testing builds upon that success by employing a similar approach, but allowing the functions to make calls to other functions in the call tree, thus proving that the units work together as expected.

Unit and integration tests can fill in the gaps left behind by system test and exercise constructs to protect against those unexpected occurrences, such as “divide by zero”. Alternatively, we can exercise the whole system from the “bottom up”, first by proving that the smallest functional components have been fully exercised, and then showing that they work together.

Either way, although we now have the means to exercise all of the code, how do we know that we have done so? Good test tools provide structural coverage metrics to quantitatively analyze how many code paths have been exercised during structural coverage analysis. The use of standards, such as DO-178, have proven that such an approach reduces the risk of failure. Consequently, this has become the norm for most embedded military standards.

While such standards do not demand that you use tools to generate this information, the overhead of manually demonstrating coverage is so time consuming (never mind more prone to error) that most companies see tools as a way to significantly reduce development costs. Test tools create coverage data using proven instrumentation mechanisms consisting of function calls to record executed paths taken. To create an in-house implementation takes a similar level of effort as the application code itself.

Third party tools also provide a measure of independence, giving evidence that tests are comprehensive using a mechanism written by an organization with no vested interest.

So that’s the end of the story, is it? Using these tools and techniques, you can slay the dragon and prove that all statements are functionally correct and have been exercised.

Well, maybe. It depends on the implications of failure. The more critical the application, the more demanding the standards. Does the amount of coverage data you have generated reflect the criticality of the project? Has the code been exercised on the target, or the host?

More on all of this later. We’ll walk through the various aspects of how to create code quality so that regardless what circumstances demand, you’ll know how to use test tools to slay the dragon and rescue that pile of gold.

 

Featured Companies

LDRA Technology

2540 King Arthur Blvd, Suite #228
Lewisville, TX 75056
8.2.22PHP Version6.77sRequest Duration6MBMemory UsageGET comms/{uri_path?}Route
  • warninglog[10:58:32] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[10:58:34] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (380ms)
  • Application (6.39s)
  • 1 x Application (94.35%)
    6.39s
    1 x Booting (5.61%)
    380.10ms
    82 templates were rendered
    • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
      Params
      0
      displayed_articles
      1
      page_title
      2
      article
    • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      authors
    • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
    • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
    • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      company
      8
      loop
    • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      category
    • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      tags
    • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      socialMedia
    • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
      Params
      0
      displayed_articles
      1
      page_title
      2
      article
    • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      authors
    • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
    • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
    • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      company
      8
      loop
    • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      category
    • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      tags
    • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      sidebar_articles
    • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
    • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      navbarCategories
    • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      subfooterCategories
      10
      categoryBuilder
      11
      categories
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      category
      8
      loop
      9
      socialMedia
    uri
    GET comms/{uri_path?}
    middleware
    web
    controller
    App\Http\Controllers\Frontend\ArticleController@viewArticleByShortname
    namespace
    App\Http\Controllers
    prefix
    where
    file
    app/Http/Controllers/Frontend/ArticleController.php:35-49
    105 statements were executed, 73 of which were duplicated, 32 unique. Show only duplicated4.16s
    • select * from `articles` where `shortname` = 'code-quality-improving-testing-for-military-grade-applications' and `publish_at` < '2025-03-17 10:58:31' limit 1
      47.27ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
      Metadata
      Bindings
      • 0. code-quality-improving-testing-for-military-grade-applications
      • 1. 2025-03-17 10:58:31
      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 (42)
      4.13ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
      Metadata
      Backtrace
      • 21. /app/Http/Controllers/Frontend/ArticleController.php:42
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `categories` where `categories`.`id` in (6)
      1.94ms/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.01ms/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` = 1428
      27.41msview::theme::article.view.generic:15mes
      Metadata
      Bindings
      • 0. 1428
      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
      8.5msview::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` = 1428 and `article_attachments`.`article_id` is not null
      3.6ms/app/Models/Article.php:262mes
      Metadata
      Bindings
      • 0. 1428
      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` = 1428
      20.01msview::theme::article.components.companies:1mes
      Metadata
      Bindings
      • 0. 1428
      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` = 1428
      14.14msview::theme::article.view.generic:45mes
      Metadata
      Bindings
      • 0. 1428
      Backtrace
      • 19. view::theme::article.view.generic:45
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 5 limit 1
      2.43ms/app/Models/Category.php:266mes
      Metadata
      Bindings
      • 0. 5
      Backtrace
      • 21. /app/Models/Category.php:266
      • 27. view::theme::article.view.generic:46
      • 29. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 30. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `tags`.*, `articles_tags`.`article_id` as `pivot_article_id`, `articles_tags`.`tag_id` as `pivot_tag_id` from `tags` inner join `articles_tags` on `tags`.`id` = `articles_tags`.`tag_id` where `articles_tags`.`article_id` = 1428
      13.32msview::theme::article.view.generic:51mes
      Metadata
      Bindings
      • 0. 1428
      Backtrace
      • 19. view::theme::article.view.generic:51
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-03-17 10:58:32' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
      225ms/app/Models/Article.php:375mes
      Metadata
      Bindings
      • 0. publish
      • 1. hidden
      • 2. 8
      • 3. 2025-03-17 10:58:32
      • 4. 
      • 5. 0
      Backtrace
      • 14. /app/Models/Article.php:375
      • 15. view::theme::layouts.components.sidebar:8
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`id` in (7, 13, 15, 19, 21, 23, 24, 25, 26, 27, 31, 32, 44, 47, 1000, 1001)
      3.67ms/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.94ms/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.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 `id`, `name`, `shortname` from `categories` where `parent_id` is null and `id` not in (999, 100) and exists (select * from `articles` where `categories`.`id` = `articles`.`primary_category` and `publish_at` < '2025-03-17 10:58:32' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
      99.81ms/app/View/Composers/SubfooterComposer.php:38mes
      Metadata
      Bindings
      • 0. 999
      • 1. 100
      • 2. 2025-03-17 10:58:32
      • 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
      2.16ms/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
      6.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)
      2.19ms/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)
      5.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)
      1.64ms/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
      78.83ms/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.4ms/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.64ms/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)
      7.16ms/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
      17.04ms/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)
      13.63ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (5)
      1.75ms/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)
      9.4ms/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
      10.6ms/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)
      3.33ms/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)
      5.02ms/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)
      4.08ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `parent_id` is null and `id` not in (999, 100, 1061)
      2.42msview::theme::layouts.components.category_subfooter:6mes
      Metadata
      Bindings
      • 0. 999
      • 1. 100
      • 2. 1061
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:6
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 2 limit 1
      2.76ms/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
      1.81ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 2
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:33' 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
      480msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:33
      • 1. 0
      • 2. 
      • 3. 8
      • 4. 2
      • 5. 14
      • 6. 17
      • 7. 18
      • 8. 13
      • 9. 1004
      • 10. 15
      • 11. 16
      • 12. 19
      • 13. 8
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:19
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (13, 15, 19)
      1.67msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (2)
      2.91msview::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)
      5.17msview::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.37ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 4 and `categories`.`parent_id` is not null order by `shortname` asc
      1.13ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:33' 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
      255msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:33
      • 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)
      8.94msview::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)
      5.45msview::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)
      5.5msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 5 limit 1
      1.42ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 5
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 5 and `categories`.`parent_id` is not null order by `shortname` asc
      1.94ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 5
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:34' 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
      231msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:34
      • 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.37msview::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)
      830μsview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 24. view::theme::layouts.components.category_subfooter:19
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `article_types` where `article_types`.`id` in (2, 3)
      1.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 `categories` where `categories`.`id` = 6 limit 1
      3.62ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 6 and `categories`.`parent_id` is not null order by `shortname` asc
      3.76ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:34' 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
      205msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:34
      • 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)
      1msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (6)
      1.68msview::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)
      700μsview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-03-17 10:58:34' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
      361ms/app/Models/Article.php:375mes
      Metadata
      Bindings
      • 0. publish
      • 1. hidden
      • 2. 8
      • 3. 2025-03-17 10:58:34
      • 4. 
      • 5. 0
      Backtrace
      • 14. /app/Models/Article.php:375
      • 15. view::theme::layouts.components.sidebar:8
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`id` in (7, 13, 15, 19, 21, 23, 24, 25, 26, 27, 31, 32, 44, 47, 1000, 1001)
      2.26ms/app/Models/Article.php:375mes
      Metadata
      Backtrace
      • 19. /app/Models/Article.php:375
      • 20. view::theme::layouts.components.sidebar:8
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`id` in (1, 2, 3, 4, 6)
      3.32ms/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.39ms/app/Models/Article.php:375mes
      Metadata
      Backtrace
      • 19. /app/Models/Article.php:375
      • 20. view::theme::layouts.components.sidebar:8
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `id`, `name`, `shortname` from `categories` where `parent_id` is null and `id` not in (999, 100) and exists (select * from `articles` where `categories`.`id` = `articles`.`primary_category` and `publish_at` < '2025-03-17 10:58:35' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
      109ms/app/View/Composers/SubfooterComposer.php:38mes
      Metadata
      Bindings
      • 0. 999
      • 1. 100
      • 2. 2025-03-17 10:58:35
      • 3. 
      • 4. 0
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:38
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6) order by `shortname` asc
      2.9ms/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
      9.39ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Bindings
      • 0. 
      • 1. 0
      • 2. 2
      • 3. 14
      • 4. 17
      • 5. 18
      • 6. 13
      • 7. 1004
      • 8. 15
      • 9. 16
      • 10. 19
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:63
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (15, 16, 18)
      1.22ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (2)
      3.07ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 24. /app/View/Composers/SubfooterComposer.php:63
      • 25. /app/View/Composers/SubfooterComposer.php:19
      • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `article_types` where `article_types`.`id` in (2)
      3.18ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (3, 1005, 23, 26, 25, 21, 20, 24, 22) limit 5
      5.84ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Bindings
      • 0. 
      • 1. 0
      • 2. 3
      • 3. 1005
      • 4. 23
      • 5. 26
      • 6. 25
      • 7. 21
      • 8. 20
      • 9. 24
      • 10. 22
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:63
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (20, 23)
      3.7ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (3)
      3.01ms/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.89ms/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
      81.23ms/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)
      1.39ms/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)
      2.19ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 24. /app/View/Composers/SubfooterComposer.php:63
      • 25. /app/View/Composers/SubfooterComposer.php:19
      • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `article_types` where `article_types`.`id` in (2, 3)
      2.4ms/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
      11.94ms/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)
      10.83ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (5)
      2.04ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 24. /app/View/Composers/SubfooterComposer.php:63
      • 25. /app/View/Composers/SubfooterComposer.php:19
      • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `article_types` where `article_types`.`id` in (2)
      1.46ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `parent_id` is null and `id` not in (999, 100, 1061)
      1.2msview::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
      5.54ms/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
      2.74ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:35' 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
      311msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:35
      • 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)
      12.27msview::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)
      5.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.83msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 2 limit 1
      3.35ms/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
      5.77ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 2
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:36' 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
      383msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:36
      • 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)
      2.9msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (2)
      1.57msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 24. view::theme::layouts.components.category_subfooter:19
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `article_types` where `article_types`.`id` in (2, 3, 4)
      1.47msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 4 limit 1
      1.38ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 4 and `categories`.`parent_id` is not null order by `shortname` asc
      3.38ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:36' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 4 or `primary_category` = 32 or `primary_category` = 31 or `primary_category` = 30 or `primary_category` = 29 or `primary_category` = 27) and `article_type_id` <> '8' order by `publish_at` desc limit 5
      347msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:36
      • 1. 0
      • 2. 
      • 3. 8
      • 4. 4
      • 5. 32
      • 6. 31
      • 7. 30
      • 8. 29
      • 9. 27
      • 10. 8
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:19
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (27, 31, 32)
      2.21msview::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)
      4.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 (2, 3)
      9msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 6 limit 1
      2.65ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 6 and `categories`.`parent_id` is not null order by `shortname` asc
      2.51ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-17 10:58:37' 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
      515msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-17 10:58:37
      • 1. 0
      • 2. 
      • 3. 8
      • 4. 6
      • 5. 45
      • 6. 44
      • 7. 46
      • 8. 1008
      • 9. 1006
      • 10. 40
      • 11. 43
      • 12. 47
      • 13. 39
      • 14. 41
      • 15. 42
      • 16. 1007
      • 17. 8
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:19
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (44, 47, 1007)
      2.96msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (6)
      4.4msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 24. view::theme::layouts.components.category_subfooter:19
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `article_types` where `article_types`.`id` in (3)
      1.77msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    App\Models\Company
    2
    App\Models\Author
    1
    App\Models\ArticleType
    34
    App\Models\Category
    282
    App\Models\Article
    141
      _token
      1clylEAXvt3fPSUaT3mrsfgmHIYF7i9DmCq8pkXb
      _previous
      array:1 [ "url" => "https://dev007.militaryembedded.com/comms/test/code-quality-improving-testing-...
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /comms/test/code-quality-improving-testing-for-military-grade-applications
      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 => "3.128.180.89" ] "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 => "3.128.180.89" ] "cf-ray" => array:1 [ 0 => "921bf9bf9d80f606-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" => "3.128.180.89" "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" => "3.128.180.89" "HTTP_CF_RAY" => "921bf9bf9d80f606-ORD" "HTTP_HOST" => "dev007.militaryembedded.com" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SERVER_NAME" => "dev007.militaryembedded.com" "SERVER_PORT" => "443" "SERVER_ADDR" => "209.38.74.90" "REMOTE_PORT" => "" "REMOTE_ADDR" => "3.128.180.89" "SERVER_SOFTWARE" => "nginx/1.26.2" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/home/forge/dev007.militaryembedded.com/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/comms/test/code-quality-improving-testing-for-military-grade-applications" "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" => 1742209111.1176 "REQUEST_TIME" => 1742209111 ]
      request_cookies
      []
      
      response_headers
      0 of 0
      array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 17 Mar 2025 10:58:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlhaeTFpVnFQRldxTldjakxkdWwydWc9PSIsInZhbHVlIjoiMUZoUGlNR01iTEhRcUdFL0FxaU9PdFRRU0pZZXc3SWdicWhkVWVtd201d3N0RjNRby9qK0s0V3NoUjlBanVWckJ2OU1LUkEwRDlIYjNuNnFLV21rN2R1MVFCL0VMZktNY0NCRy81MDFaUTdQa3FqN3oxWGUySjVuV2VzWlZMRTIiLCJtYWMiOiJiMDQzZTcwYTY3YmJmODU5YzNhMzk1NjFlMjRmMmNkMWQxN2E3MmIzMjgxNDMyYzMyYTU5OWVlYTk5NjViNjY3IiwidGFnIjoiIn0%3D; expires=Mon, 17 Mar 2025 12:58:37 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IlhaeTFpVnFQRldxTldjakxkdWwydWc9PSIsInZhbHVlIjoiMUZoUGlNR01iTEhRcUdFL0FxaU9PdFRRU0pZZXc3SWdicWhkVWVtd201d3N0RjNRby9qK0s0V3NoUjlBanVWckJ2OU1LU" 1 => "military_embedded_systems_session=eyJpdiI6InVQeWo3Qk1MNmR3dnBjNG42VEkxQkE9PSIsInZhbHVlIjoicG9QYkhyZkJnYjVwbnJ1T0luZGZoZXcvU1pDRElrYkQ5VDZtRUdsNjN6TENJejlVek41eGc4YWtleU9wV1YzSXlHMDA1T0lycGJORCtOdWw5K0xxZmpmdkdGRGUxZ3V5NGN3NEV3K1RBdUlwK0h2TDl6bVJNMU42d2FTd29UVisiLCJtYWMiOiI1NjMxNGE5NzFiMWFhNTMwMzQyODVhYzJhZjc2NzA5ODQ0NzEzZTVmYjk1NmU3MjJhZWNkMTYxMDg0OWY3YWU4IiwidGFnIjoiIn0%3D; expires=Mon, 17 Mar 2025 12:58:37 GMT; Max-Age=7200; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6InVQeWo3Qk1MNmR3dnBjNG42VEkxQkE9PSIsInZhbHVlIjoicG9QYkhyZkJnYjVwbnJ1T0luZGZoZXcvU1pDRElrYkQ5VDZtRUdsNjN6TENJejlVek41eG" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlhaeTFpVnFQRldxTldjakxkdWwydWc9PSIsInZhbHVlIjoiMUZoUGlNR01iTEhRcUdFL0FxaU9PdFRRU0pZZXc3SWdicWhkVWVtd201d3N0RjNRby9qK0s0V3NoUjlBanVWckJ2OU1LUkEwRDlIYjNuNnFLV21rN2R1MVFCL0VMZktNY0NCRy81MDFaUTdQa3FqN3oxWGUySjVuV2VzWlZMRTIiLCJtYWMiOiJiMDQzZTcwYTY3YmJmODU5YzNhMzk1NjFlMjRmMmNkMWQxN2E3MmIzMjgxNDMyYzMyYTU5OWVlYTk5NjViNjY3IiwidGFnIjoiIn0%3D; expires=Mon, 17-Mar-2025 12:58:37 GMT; path=/XSRF-TOKEN=eyJpdiI6IlhaeTFpVnFQRldxTldjakxkdWwydWc9PSIsInZhbHVlIjoiMUZoUGlNR01iTEhRcUdFL0FxaU9PdFRRU0pZZXc3SWdicWhkVWVtd201d3N0RjNRby9qK0s0V3NoUjlBanVWckJ2OU1LU" 1 => "military_embedded_systems_session=eyJpdiI6InVQeWo3Qk1MNmR3dnBjNG42VEkxQkE9PSIsInZhbHVlIjoicG9QYkhyZkJnYjVwbnJ1T0luZGZoZXcvU1pDRElrYkQ5VDZtRUdsNjN6TENJejlVek41eGc4YWtleU9wV1YzSXlHMDA1T0lycGJORCtOdWw5K0xxZmpmdkdGRGUxZ3V5NGN3NEV3K1RBdUlwK0h2TDl6bVJNMU42d2FTd29UVisiLCJtYWMiOiI1NjMxNGE5NzFiMWFhNTMwMzQyODVhYzJhZjc2NzA5ODQ0NzEzZTVmYjk1NmU3MjJhZWNkMTYxMDg0OWY3YWU4IiwidGFnIjoiIn0%3D; expires=Mon, 17-Mar-2025 12:58:37 GMT; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6InVQeWo3Qk1MNmR3dnBjNG42VEkxQkE9PSIsInZhbHVlIjoicG9QYkhyZkJnYjVwbnJ1T0luZGZoZXcvU1pDRElrYkQ5VDZtRUdsNjN6TENJejlVek41eG" ] ]
      session_attributes
      0 of 0
      array:4 [ "_token" => "1clylEAXvt3fPSUaT3mrsfgmHIYF7i9DmCq8pkXb" "_previous" => array:1 [ "url" => "https://dev007.militaryembedded.com/comms/test/code-quality-improving-testing-for-military-grade-applications" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]