Military Embedded Systems

Enhancing military and aerospace software testing with data-driven development strategies

Story

May 16, 2024

Ricardo Camacho

director of Safety & Security Compliance

Parasoft

Continuous testing is indispensable in a well-functioning CI/CD [continuous integration/continuous delivery] pipeline, as testing consumes the most time and resources. In a data-driven development (DDD) process, organizations must use tools supporting automation and optimization – critical for continuous testing – driving larger code coverage, intelligent test execution, and bidirectional traceability, and thereby further enhancing software quality and reliability.

When organizations in the military and aerospace sectors adopt a data-driven development (DDD) process, it becomes crucial that they select key performance indicators (KPIs) that are relevant to the industry’s unique challenges and requirements. For software developers and lead engineers in this domain, essential raw KPIs may include tracking the number of requirements implemented per development cycle and the number of lines of code written per day per engineer. These metrics, often recategorized as velocity and sprint burndown, enable valuable insights into labor costs and time-to-market considerations.

Additionally, other software development KPIs pertinent to the military and aerospace industry may encompass code complexity, code execution time, memory usage, number of threads, and others aimed at helping development teams adapt to evolving requirements, prioritize issues, and address high-risk areas efficiently.

For the quality assurance (QA) teams operating within the military and aerospace sector, collecting KPIs such as the average number of defects per line of code becomes paramount. Typically, embedded software in this industry maintains an average of 15 to 50 issues per 1,000 lines, serving as a critical metric for evaluating software robustness and determining whether the application is fit for deployment or delivery.

An 85% defect removal efficiency (DRE) is generally considered acceptable for average nonsafety applications; however, for embedded safety-critical software used in military and aerospace applications, the acceptable range rises substantially to between 95% and 99%. Achieving a DRE of 99.9% remains an aspiration rather than a practical reality.

Notably, projects in the military and aerospace industry that adopt comprehensive testing methodologies – including static analysis as the initial stage of testing, followed by manual peer reviews of key features and a series of multistage testing phases such as unit testing, integration testing, system testing, regression testing, and code coverage – report achieving DRE rates within the desired range of 95% to 99%. Moreover, these teams experience tangible business benefits such as shortened development schedules, reduced project failures, fewer field problem reports, and lower labor costs. (Figure 1.)

[Figure 1 ǀ Incorporating data-driven development (DDD) practices throughout projects, from planning to deployment, empowers software engineers to improve decision-making, performance, and quality, ultimately delivering increased value to customers and stakeholders. When this approach is integrated into the DevOps methodology, it becomes known as DataOps.]

Applications in the military and aerospace domain

In the aerospace sector, data-driven approaches are integral across a spectrum of applications and are aimed at enhancing software design, testing, and deployment processes. For instance, modern aircraft equipped with advanced flight-control systems utilize real-time data from an array of sensors – such as radar, lidar, and cameras – to enable features like autopilot and collision avoidance. Telematics systems further gather performance data, operational parameters, and user interactions, with the goal of fostering continuous enhancements in software quality and safety.

Expanding beyond these applications, key areas in the military and aerospace domain include:

  • Mission planning and execution: The use of data analytics and potentially quantum computing in optimizing mission planning and execution involves the development of software systems to process and analyze historical mission data, environmental conditions, and performance metrics. This approach likely involves creating algorithms, software tools, and systems to handle and analyze large volumes of data, as well as implementing decision-making processes based on this analysis.
  • Aircraft and vehicle systems: Software plays a crucial role in analyzing sensor data, monitoring equipment performance, and predicting maintenance needs in aerospace and military vehicle systems. These needs involve developing software for data collection, analysis, and visualization, as well as implementing predictive-maintenance algorithms.
  • Surveillance and reconnaissance: Analyzing data collected from surveillance systems involves software development to process and analyze large volumes of data from drones, satellites, and ground sensors. These steps likely involve developing software for image processing, pattern recognition, and data visualization.
  • Simulation and training: Military-training simulations rely heavily on software development to create realistic scenarios and adapt to user behavior. Such efforts involve developing simulation software, incorporating machine learning algorithms for adaptive training, and analyzing user data to improve training effectiveness.
  • Cybersecurity: Developing software for analyzing network traffic, detecting anomalies, and identifying security threats involves software development in cybersecurity applications. Development of cybersecurity software includes developing algorithms for anomaly detection, implementing machine learning models for threat detection, and developing software tools for network monitoring and analysis.

In the aerospace industry, real-world data serves as invaluable input for various testing activities, including unit testing, regression testing, performance testing, error handling, security testing, and test case design. By simulating diverse operating conditions and user scenarios, engineers and testers can create comprehensive test cases driven by datasets, enabling exhaustive testing of software functionalities under different circumstances.

Moreover, recognizing the significant costs and time investments required to ensure that software developed for these diverse applications is not only reliable but – crucially – safe and secure, one might inquire about the most efficient and effective approach to software testing. In essence, the answer lies in integrating testing seamlessly into the software-development process.

Employing CI/CD and data-driven testing

Continuous integration and continuous delivery (CI/CD) combine to form a robust software-development practice known as frequent integration, merging smaller build units into cohesive apps, services, libraries, or components, alongside continuous delivery or deployment. The core objective is to automate software testing to promptly identify build and integration issues and errors. By incorporating DDD principles into the continuous integration workflow, the industry can attain elevated levels of software quality and reliability. (Figure 2.)

[Figure 2 ǀ Shown: Data gathering and visualization of software quality workflow.]

In a typical workflow, developers create branches for their work, write new code, or modify existing code, then submit pull requests for review. Within the CI/CD pipeline, automated test scripts – including static analysis, unit testing, and code coverage analysis – are executed for each code commit. Static analysis is actually a foundational step in enhancing software quality.

For C and C++, adhering to coding standards like MISRA C 2023 and MISRA C++ 2023, coupled with SEI CERT C or CERT C++ security standards in conjunction with MISRA, ensures the development of the safest and most secure applications. Additionally, leveraging containerization technologies such as Docker simplifies the testing process, ensuring thorough validation of software changes before integration into the main codebase.

Platforms like GitHub, coupled with self-hosted runners, are prevalent in the avionics and aerospace industries for hosting CI/CD pipelines. These runners, whether physical servers, virtual machines, or container images, seamlessly integrate data-driven tests into the development workflow, resulting in software that meets stringent safety, security, and regulatory requirements while aligning with business objectives.

Continuous integration and delivery have become standard practices in embedded development. Transitioning from a waterfall process to CI/CD and Agile development yields significant benefits in risk reduction and enhancements in quality and security. Embedded developers prioritize security, and CI/CD facilitates DevSecOps [development, security, and operations] by embedding security requirements and controls throughout the pipeline.

Containers are inherently compatible with CI/CD, supporting rapid deployment and portability across diverse host environments with robust versioning and centralized control. Containerized development environments are essential for secure development within a DevSecOps pipeline, providing a reproducible application environment with integrated security controls.

Continuous testing is indispensable in a well-functioning CI/CD pipeline, as testing consumes the most time and resources. By shifting testing earlier in the development life cycle, continuous testing frameworks streamline processes. Automation and targeted focus on high-risk areas enable testing to become less of an impediment in continuous processes. Tools supporting automation and optimization are critical for continuous testing and can drive larger code coverage, intelligent test execution, and bidirectional traceability, thereby further enhancing software quality and reliability.

Ricardo Camacho is director of Safety & Security Compliance at Parasoft. He has decades of experience in systems and software engineering of real-time safety- and security-critical systems for various industries. His career has spanned multiple roles, including technical product marketing, project management, solution architect/technical sales, and embedded software and systems engineering, which he has performed at companies including IBM, Xerox, Vector, and GE Rail.

Parasoft     https://www.parasoft.com/

Featured Companies
8.2.22PHP Version6.32sRequest Duration6MBMemory UsageGET avionics/{uri_path?}Route
    • Booting (152ms)
    • Application (6.17s)
    • 1 x Application (97.6%)
      6.17s
      1 x Booting (2.4%)
      151.92ms
      82 templates were rendered
      • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
        Params
        0
        displayed_articles
        1
        page_title
        2
        article
      • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        authors
      • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        company
        8
        loop
      • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        category
      • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        socialMedia
      • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
        Params
        0
        displayed_articles
        1
        page_title
        2
        article
      • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        authors
      • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
      • theme::company.card (resources/views/themes/_base/company/card.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        company
        8
        loop
      • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        category
      • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        tags
      • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        sidebar_articles
      • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)9bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
      • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        navbarCategories
      • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        subfooterCategories
        10
        categoryBuilder
        11
        categories
        12
        category_subfooter_articles
        13
        top_footer_article
        14
        category_footer_article
      • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        displayed_articles
        4
        page_title
        5
        article
        6
        __currentLoopData
        7
        category
        8
        loop
        9
        socialMedia
      uri
      GET avionics/{uri_path?}
      middleware
      web
      controller
      App\Http\Controllers\Frontend\ArticleController@viewArticleByShortname
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/Frontend/ArticleController.php:35-49
      105 statements were executed, 64 of which were duplicated, 41 unique. Show only duplicated3.75s
      • select * from `articles` where `shortname` = 'enhancing-military-and-aerospace-software-testing-with-data-driven-development-strategies' and `publish_at` < '2025-04-02 04:01:28' limit 1
        147ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Bindings
        • 0. enhancing-military-and-aerospace-software-testing-with-data-driven-development-strategies
        • 1. 2025-04-02 04:01:28
        Backtrace
        • 16. /app/Http/Controllers/Frontend/ArticleController.php:42
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` where `categories`.`id` in (1002)
        1.73ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Backtrace
        • 21. /app/Http/Controllers/Frontend/ArticleController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` where `categories`.`id` in (1)
        3.28ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
        Metadata
        Backtrace
        • 26. /app/Http/Controllers/Frontend/ArticleController.php:42
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `article_types` where `article_types`.`id` in (2)
        3.97ms/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` = 12343
        12.96msview::theme::article.view.generic:15mes
        Metadata
        Bindings
        • 0. 12343
        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` = 1239 limit 1
        8.64msview::theme::author.card:16mes
        Metadata
        Bindings
        • 0. 1239
        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` = 12343 and `article_attachments`.`article_id` is not null
        4.35ms/app/Models/Article.php:262mes
        Metadata
        Bindings
        • 0. 12343
        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` = 12343
        11.46msview::theme::article.components.companies:1mes
        Metadata
        Bindings
        • 0. 12343
        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` = 12343
        23.38msview::theme::article.view.generic:45mes
        Metadata
        Bindings
        • 0. 12343
        Backtrace
        • 19. view::theme::article.view.generic:45
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 1 limit 1
        4.27ms/app/Models/Category.php:266mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 21. /app/Models/Category.php:266
        • 27. view::theme::article.view.generic:46
        • 29. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 30. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `tags`.*, `articles_tags`.`article_id` as `pivot_article_id`, `articles_tags`.`tag_id` as `pivot_tag_id` from `tags` inner join `articles_tags` on `tags`.`id` = `articles_tags`.`tag_id` where `articles_tags`.`article_id` = 12343
        49.16msview::theme::article.view.generic:51mes
        Metadata
        Bindings
        • 0. 12343
        Backtrace
        • 19. view::theme::article.view.generic:51
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-04-02 04:01:28' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        367ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-04-02 04:01:28
        • 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)
        5.96ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (1, 2, 3, 4, 6)
        1.05ms/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)
        4.43ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 19. /app/Models/Article.php:375
        • 20. view::theme::layouts.components.sidebar:8
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `id`, `name`, `shortname` from `categories` where `parent_id` is null and `id` not in (999, 100) and exists (select * from `articles` where `categories`.`id` = `articles`.`primary_category` and `publish_at` < '2025-04-02 04:01:29' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        124ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-04-02 04:01:29
        • 3. 
        • 4. 0
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:38
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6) order by `shortname` asc
        3.75ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:38
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (1, 1000, 1003, 7, 1001, 9, 1002, 8) limit 5
        10.86ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 1
        • 3. 1000
        • 4. 1003
        • 5. 7
        • 6. 1001
        • 7. 9
        • 8. 1002
        • 9. 8
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (7, 8, 9, 1000)
        2.15ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (1)
        2.99ms/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.14ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (2, 14, 17, 18, 13, 1004, 15, 16, 19) limit 5
        3.66ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 2
        • 3. 14
        • 4. 17
        • 5. 18
        • 6. 13
        • 7. 1004
        • 8. 15
        • 9. 16
        • 10. 19
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (15, 16, 18)
        4.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 (2)
        1.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)
        2.99ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (4, 32, 31, 30, 29, 27) limit 5
        49.04ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 4
        • 3. 32
        • 4. 31
        • 5. 30
        • 6. 29
        • 7. 27
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (30, 32)
        2.57ms/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.46ms/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)
        3.38ms/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
        4.63ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 5
        • 3. 37
        • 4. 36
        • 5. 35
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (36, 37)
        3.48ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (5)
        4.13ms/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.21ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `parent_id` is null and `id` not in (999, 100, 1061)
        3.09msview::theme::layouts.components.category_subfooter:6mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 1061
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:6
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 1 limit 1
        1.35ms/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
        3.77ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:29' 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
        189msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:29
        • 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)
        4.11msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (1)
        3.86msview::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)
        7.78msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 3 limit 1
        10.45ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 3 and `categories`.`parent_id` is not null order by `shortname` asc
        11.74ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:30' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 3 or `primary_category` = 1005 or `primary_category` = 23 or `primary_category` = 26 or `primary_category` = 25 or `primary_category` = 21 or `primary_category` = 20 or `primary_category` = 24 or `primary_category` = 22) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        380msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:30
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 3
        • 5. 1005
        • 6. 23
        • 7. 26
        • 8. 25
        • 9. 21
        • 10. 20
        • 11. 24
        • 12. 22
        • 13. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (23, 25)
        2.77msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (3)
        4.37msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (3)
        4.66msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 4 limit 1
        4.7ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 4
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 4 and `categories`.`parent_id` is not null order by `shortname` asc
        2.56ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 4
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:30' 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
        211msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:30
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 4
        • 5. 32
        • 6. 31
        • 7. 30
        • 8. 29
        • 9. 27
        • 10. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (27, 31, 32)
        1.85msview::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)
        12.15msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3)
        2.48msview::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.74ms/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.99ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:31' 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
        343msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:31
        • 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)
        3.28msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (5)
        1.55msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3)
        2.87msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-04-02 04:01:31' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
        220ms/app/Models/Article.php:375mes
        Metadata
        Bindings
        • 0. publish
        • 1. hidden
        • 2. 8
        • 3. 2025-04-02 04:01:31
        • 4. 
        • 5. 0
        Backtrace
        • 14. /app/Models/Article.php:375
        • 15. view::theme::layouts.components.sidebar:8
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`id` in (7, 13, 15, 19, 21, 23, 24, 25, 26, 27, 31, 32, 44, 47, 1000, 1001)
        4.24ms/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)
        6.41ms/app/Models/Article.php:375mes
        Metadata
        Backtrace
        • 24. /app/Models/Article.php:375
        • 25. view::theme::layouts.components.sidebar:8
        • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `article_types` where `article_types`.`id` in (2, 3, 4, 5)
        1.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-04-02 04:01:32' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
        99.67ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 2025-04-02 04:01: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
        4.41ms/app/View/Composers/SubfooterComposer.php:38mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:38
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (2, 14, 17, 18, 13, 1004, 15, 16, 19) limit 5
        2.34ms/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.62ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (2)
        870μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        2.79ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (3, 1005, 23, 26, 25, 21, 20, 24, 22) limit 5
        2.3ms/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)
        950μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (3)
        1.34ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 24. /app/View/Composers/SubfooterComposer.php:63
        • 25. /app/View/Composers/SubfooterComposer.php:19
        • 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 27. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 30. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `article_types` where `article_types`.`id` in (2)
        2.26ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (4, 32, 31, 30, 29, 27) limit 5
        27.89ms/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.44ms/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)
        1.16ms/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)
        1.86ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (6, 45, 44, 46, 1008, 1006, 40, 43, 47, 39, 41, 42, 1007) limit 5
        2.41ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Bindings
        • 0. 
        • 1. 0
        • 2. 6
        • 3. 45
        • 4. 44
        • 5. 46
        • 6. 1008
        • 7. 1006
        • 8. 40
        • 9. 43
        • 10. 47
        • 11. 39
        • 12. 41
        • 13. 42
        • 14. 1007
        Backtrace
        • 14. /app/View/Composers/SubfooterComposer.php:63
        • 15. /app/View/Composers/SubfooterComposer.php:19
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (43, 44, 46)
        1.12ms/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `categories`.`id` in (6)
        2.58ms/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)
        960μs/app/View/Composers/SubfooterComposer.php:63mes
        Metadata
        Backtrace
        • 19. /app/View/Composers/SubfooterComposer.php:63
        • 20. /app/View/Composers/SubfooterComposer.php:19
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
      • select * from `categories` where `parent_id` is null and `id` not in (999, 100, 1061)
        1.12msview::theme::layouts.components.category_subfooter:6mes
        Metadata
        Bindings
        • 0. 999
        • 1. 100
        • 2. 1061
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:6
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 1 limit 1
        1.86ms/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
        960μs/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:32' 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
        180msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:32
        • 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)
        2.79msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (1)
        2.43msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (3)
        1.45msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 2 limit 1
        2.33ms/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
        4.6ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 2
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:32' 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
        214msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:32
        • 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.6msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (2)
        1.62msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 24. view::theme::layouts.components.category_subfooter:19
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `article_types` where `article_types`.`id` in (2, 3, 4)
        2.05msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 3 limit 1
        10.84ms/app/Models/Category.php:142mes
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 19. /app/Models/Category.php:142
        • 20. view::theme::layouts.components.category_subfooter:18
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `categories` where `categories`.`parent_id` = 3 and `categories`.`parent_id` is not null order by `shortname` asc
        8.2ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:33' and `primary_image` is not null and `primary_image` != '0' and `primary_image` != '' and `article_type_id` <> '8' and (`primary_category` = 3 or `primary_category` = 1005 or `primary_category` = 23 or `primary_category` = 26 or `primary_category` = 25 or `primary_category` = 21 or `primary_category` = 20 or `primary_category` = 24 or `primary_category` = 22) and `article_type_id` <> '8' order by `publish_at` desc limit 5
        483msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:33
        • 1. 0
        • 2. 
        • 3. 8
        • 4. 3
        • 5. 1005
        • 6. 23
        • 7. 26
        • 8. 25
        • 9. 21
        • 10. 20
        • 11. 24
        • 12. 22
        • 13. 8
        Backtrace
        • 14. view::theme::layouts.components.category_subfooter:19
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (23, 25)
        10.39msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (3)
        1.49msview::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.22msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 6 limit 1
        3.32ms/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.92ms/app/Models/Category.php:148mes
        Metadata
        Bindings
        • 0. 6
        Backtrace
        • 20. /app/Models/Category.php:148
        • 21. view::theme::layouts.components.category_subfooter:18
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select `articles`.* from `articles` where `publish_at` < '2025-04-02 04:01:33' 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
        320msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Bindings
        • 0. 2025-04-02 04:01:33
        • 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)
        3.51msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` in (6)
        2.72msview::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)
        4msview::theme::layouts.components.category_subfooter:19mes
        Metadata
        Backtrace
        • 19. view::theme::layouts.components.category_subfooter:19
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      App\Models\Tag
      1
      App\Models\Company
      2
      App\Models\Author
      1
      App\Models\ArticleType
      31
      App\Models\Category
      281
      App\Models\Article
      141
        _token
        c6IyKlB0oVujXK4tdasFOH0DfTjkR3XYO36vdUeX
        _previous
        array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/software/enhancing-military-and-a...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /avionics/software/enhancing-military-and-aerospace-software-testing-with-data-driven-development-strategies
        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.12.149.57" ] "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.12.149.57" ] "cf-ray" => array:1 [ 0 => "929d6cd488cd0012-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.12.149.57" "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.12.149.57" "HTTP_CF_RAY" => "929d6cd488cd0012-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.12.149.57" "SERVER_SOFTWARE" => "nginx/1.26.2" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/home/forge/dev007.militaryembedded.com/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/avionics/software/enhancing-military-and-aerospace-software-testing-with-data-driven-development-strategies" "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" => 1743566487.9138 "REQUEST_TIME" => 1743566487 ]
        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 => "Wed, 02 Apr 2025 04:01:31 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBoQmY1RmNyWDZWeExvTzd2RUpBK3c9PSIsInZhbHVlIjoidytsdDlvSkZrTFRFRVVYTVYwQzZZOGI1Rm5tVzIyYnVUeHdKN0dDZkVNalFSOUdPeERDRXJ4YzlzSVVJQWdTOGJmVnIzRFcwYTZHa1FOdm80UUV1UkR5Q1JFNzYxdlJ2bDE3VHc3cGJiWjNiMUpzQnZxNWdob1QzNllrTlNkM1IiLCJtYWMiOiJiOTA5NDcwZWZiOWRkNGMzMmFmZmY3MGU0OGQ5YTdlMzNmMTI4YzJkOGNkZGFjOTBiMTc3NTE5MGIwOTBlOTFjIiwidGFnIjoiIn0%3D; expires=Wed, 02 Apr 2025 06:01:34 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjBoQmY1RmNyWDZWeExvTzd2RUpBK3c9PSIsInZhbHVlIjoidytsdDlvSkZrTFRFRVVYTVYwQzZZOGI1Rm5tVzIyYnVUeHdKN0dDZkVNalFSOUdPeERDRXJ4YzlzSVVJQWdTOGJmVnIzR" 1 => "military_embedded_systems_session=eyJpdiI6ImhMSkNxSjF4eEFkZm16R0d1dlU4OHc9PSIsInZhbHVlIjoiTW44cTUyT2I0QlZQWU50bWRiVG1wL1Q1b1Fpd2pxUXg4dGVENG1HZERwdUM4S0VCNnJWMnpUS0ZZT2lML3NjSG9UZTRsa1dUVC8ycmtpT1l0UkF3SjB6cHdlOG5LWlNDTlRXbk9OMEtuOENvOEduQWQwM1JGb1A4elhIV0ROOU8iLCJtYWMiOiI2ZWEyMmQwYmM1MGY2NDllY2E1MzRiNTFiYmYyOWFkMzA2NTI2MjQ1MTIzZDkwYTJkNDA2ZGQ0Y2FmYmFkMTU5IiwidGFnIjoiIn0%3D; expires=Wed, 02 Apr 2025 06:01:34 GMT; Max-Age=7200; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6ImhMSkNxSjF4eEFkZm16R0d1dlU4OHc9PSIsInZhbHVlIjoiTW44cTUyT2I0QlZQWU50bWRiVG1wL1Q1b1Fpd2pxUXg4dGVENG1HZERwdUM4S0VCNnJWMn" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBoQmY1RmNyWDZWeExvTzd2RUpBK3c9PSIsInZhbHVlIjoidytsdDlvSkZrTFRFRVVYTVYwQzZZOGI1Rm5tVzIyYnVUeHdKN0dDZkVNalFSOUdPeERDRXJ4YzlzSVVJQWdTOGJmVnIzRFcwYTZHa1FOdm80UUV1UkR5Q1JFNzYxdlJ2bDE3VHc3cGJiWjNiMUpzQnZxNWdob1QzNllrTlNkM1IiLCJtYWMiOiJiOTA5NDcwZWZiOWRkNGMzMmFmZmY3MGU0OGQ5YTdlMzNmMTI4YzJkOGNkZGFjOTBiMTc3NTE5MGIwOTBlOTFjIiwidGFnIjoiIn0%3D; expires=Wed, 02-Apr-2025 06:01:34 GMT; path=/XSRF-TOKEN=eyJpdiI6IjBoQmY1RmNyWDZWeExvTzd2RUpBK3c9PSIsInZhbHVlIjoidytsdDlvSkZrTFRFRVVYTVYwQzZZOGI1Rm5tVzIyYnVUeHdKN0dDZkVNalFSOUdPeERDRXJ4YzlzSVVJQWdTOGJmVnIzR" 1 => "military_embedded_systems_session=eyJpdiI6ImhMSkNxSjF4eEFkZm16R0d1dlU4OHc9PSIsInZhbHVlIjoiTW44cTUyT2I0QlZQWU50bWRiVG1wL1Q1b1Fpd2pxUXg4dGVENG1HZERwdUM4S0VCNnJWMnpUS0ZZT2lML3NjSG9UZTRsa1dUVC8ycmtpT1l0UkF3SjB6cHdlOG5LWlNDTlRXbk9OMEtuOENvOEduQWQwM1JGb1A4elhIV0ROOU8iLCJtYWMiOiI2ZWEyMmQwYmM1MGY2NDllY2E1MzRiNTFiYmYyOWFkMzA2NTI2MjQ1MTIzZDkwYTJkNDA2ZGQ0Y2FmYmFkMTU5IiwidGFnIjoiIn0%3D; expires=Wed, 02-Apr-2025 06:01:34 GMT; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6ImhMSkNxSjF4eEFkZm16R0d1dlU4OHc9PSIsInZhbHVlIjoiTW44cTUyT2I0QlZQWU50bWRiVG1wL1Q1b1Fpd2pxUXg4dGVENG1HZERwdUM4S0VCNnJWMn" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "c6IyKlB0oVujXK4tdasFOH0DfTjkR3XYO36vdUeX" "_previous" => array:1 [ "url" => "https://dev007.militaryembedded.com/avionics/software/enhancing-military-and-aerospace-software-testing-with-data-driven-development-strategies" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]