Military Embedded Systems

Blockchain for embedded systems (Part 2)

Blog

September 04, 2018

Part 1 of this blog on blockchain for embedded systems (see July/August 2018 issue) explored one way of using blockchain technology for sensor data, especially where the integrity and provenance of the data must be verified. Blockchain is also useful for the other part of embedded systems: command and control.

In many cases, the “control” part of an embedded system is a series of commands to directly attached actuators. Some of these systems, such as flight controls, may be performance-­sensitive – actually, latency-sensitive. Other cases, such as something like setting the chemical injection rate for groundwater remediation, might be changed on an hourly or daily basis. A common requirement for a controller is to be able to verify and validate commands as well as maintain a verifiable history of commands.

Consider the case of an autonomous drone. Critical commands issued to the drone would include a destination and whether or not to release a payload when it reaches the destination. The payload could be instrumentation or other high value items.

To make sure the drone is on a valid mission, there should be multiple authorizations. Parties authorizing a mission might include a science group, a funding or governance group, and an operations group. In a situation like this, there would be a system where all three of these groups have to approve and authorize a location before the drone accepts it. The system would need to be fake-proof or spoof-proof and ideally maintain a secure history of all commands.

Blockchain can provide this reassurance through validation, including validation servers and validation policies. Validation servers work by cryptographically signing a proposed transaction. In the autonomous drone example, a command to send a drone on a specific mission would be considered a transaction.

The simplest case is a single validation server that signs every transaction. Validation policies can create more complex authorizations, as in the example that would call for three validation servers with each server signing (approving) the transaction before it is valid. More complex situations are also possible: For example, a resilient system might have 20 validation servers and require signing by a majority (11 servers) or in a different case the same 20 validation servers require signing only by five for a valid transaction. A different system could have one primary validation server that must sign, plus any two out of five secondary servers signing.

A validation policy called Byzantine Fault Tolerance works even in the presence of failure of validation servers and the presence of compromised or hostile validation servers. Compromising a system using Byzantine Fault Tolerance requires compromising more than half of the validation servers, making this approach robust even in the presence of failure and hostile compromise of systems. The details of Byzantine Fault Tolerance are a bit too arcane to discuss here, but it is nonetheless an example of the power and flexibility of blockchain.

Validation servers work by cryptographically signing a transaction. This is done using a private-key/public-key pair, one that is different on each validation server. This crypto signing can be done in software, taking advantage of the performance of the host system. It can also be done using a Hardware Security Module (HSM), a specially hardened module that is dedicated to the security operations. An HSM can be a high-performance/high-cost module or a lower-performance/lower-cost unit such as a Trusted Platform Module (TPM) or even a smart card.

When using software signing, the private key is present on the system and can be compromised. Using an HSM, the private key is contained inside the hardware module and can’t be compromised. (While this statement isn’t completely true, modern HSMs are considered secure against anything short of a state-level actor.)

The beauty of blockchain in the drone example is that the drone verifies the validity of the commands it receives, verifies that the commands have been issued and validated by approved authorities, and confirm that they have been received in the proper order. These steps avoid the risks associated with modifying the commands in transit or even having the commands changed by the person entering them into the drone. In addition to the drone, everyone else in the blockchain ecosystem can verify the sequence of commands and who authorized and approved them.

Note that the actual command content need not be visible to everyone. The blockchain payload can be encrypted so that only authorized entities can actually read the contents. This action produces a very robust system where everyone can verify the sequence and authority of all commands, but only the entities needing to implement a specific command can determine what that command is.

One major concern about command and control systems is the ability to function in the presence of disrupted and degraded communications systems. A key strength of blockchain is that it is extremely tolerant of retransmission: A user can send (and receive) a block a thousand times and end up with a single command or transaction, not a thousand of them. There can be multiple partial transmissions of a block that then get reconstructed into a single verifiable block; blocks can come in out of order, as the blockchain enables the blocks to get assembled in the proper order no matter what order you receive them in.

This combination of properties makes blockchain a powerful tool for building robust, secure, high-trust systems. In addition to supporting low-performance applications, like the drone target destination in the previous example, blockchain can also support high-performance applications. The key to all of this? Enough computing power, ample network bandwidth, and ­sufficiently low latency to support the required performance.

Is blockchain the perfect technology for building invulnerable systems? Yes and no … If you follow the media, you know that cryptocurrency systems using blockchain are regularly compromised. If you dig into the failures, however, you discover that these failures are due to human error and faulty implementation. The actual blockchain algorithms and protocols are surprisingly robust. This is much like other applications of crypto: The algorithms are robust, but the people, software, and ­systems using them aren’t necessarily robust.

These examples show how blockchain technology can be used to build more robust and secure distributed systems, including those that deliver a verifiable history of changes. Cryptography is a powerful tool with many real-world applications.

 

8.2.22PHP Version3.08sRequest Duration6MBMemory UsageGET cyber/{uri_path?}Route
  • warninglog[01:03:21] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[01:03:22] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (184ms)
  • Application (2.9s)
  • 1 x Application (94.03%)
    2.90s
    1 x Booting (5.97%)
    183.77ms
    80 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::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      category
    • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      tags
    • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      socialMedia
    • theme::article.view.generic (resources/views/themes/_base/article/view/generic.blade.php)3bladefile
      Params
      0
      displayed_articles
      1
      page_title
      2
      article
    • theme::author.card (resources/views/themes/_base/author/card.blade.php)7bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      authors
    • theme::article.components.primary-image (resources/views/themes/_base/article/components/primary-image.blade.php)6bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
    • theme::article.components.companies (resources/views/themes/_base/article/components/companies.blade.php)6bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
    • theme::article.components.category-tag (resources/views/themes/_base/article/components/category-tag.blade.php)7bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      category
    • theme::article.components.tags (resources/views/themes/_base/article/components/tags.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      tags
    • theme::layouts.article (resources/views/themes/_base/layouts/article.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::layouts.components.sidebar (resources/views/themes/_base/layouts/components/sidebar.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      sidebar_articles
    • theme::layouts.web (resources/views/themes/_base/layouts/web.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::layouts.components.html_head (resources/views/themes/_base/layouts/components/html_head.blade.php)8bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
    • theme::layouts.components.navbar (resources/views/themes/_base/layouts/components/navbar.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category (resources/views/themes/_base/layouts/components/navbar-category.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.navbar-category-mobile (resources/views/themes/_base/layouts/components/navbar-category-mobile.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      navbarCategories
      9
      category
    • theme::layouts.components.category_subfooter (resources/views/themes/_base/layouts/components/category_subfooter.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)14bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.card (resources/views/themes/_base/article/card.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::article.components.article-type-tag (resources/views/themes/_base/article/components/article-type-tag.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      subfooterCategories
      9
      categoryBuilder
      10
      categories
      11
      category
      12
      category_subfooter_articles
      13
      top_footer_article
      14
      category_footer_article
    • theme::layouts.components.footer (resources/views/themes/_base/layouts/components/footer.blade.php)9bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      displayed_articles
      4
      page_title
      5
      article
      6
      __currentLoopData
      7
      loop
      8
      socialMedia
    uri
    GET cyber/{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
    103 statements were executed, 69 of which were duplicated, 34 unique. Show only duplicated1.34s
    • select * from `articles` where `shortname` = 'blockchain-for-embedded-systems-part-2' and `publish_at` < '2025-03-30 01:03:20' limit 1
      74.2ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
      Metadata
      Bindings
      • 0. blockchain-for-embedded-systems-part-2
      • 1. 2025-03-30 01:03:20
      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 (37)
      2.03ms/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 (5)
      2.09ms/app/Http/Controllers/Frontend/ArticleController.php:42mes
      Metadata
      Backtrace
      • 26. /app/Http/Controllers/Frontend/ArticleController.php:42
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `article_types` where `article_types`.`id` in (1)
      2.4ms/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` = 5831
      12.38msview::theme::article.view.generic:15mes
      Metadata
      Bindings
      • 0. 5831
      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 `article_attachments` where `article_attachments`.`article_id` = 5831 and `article_attachments`.`article_id` is not null
      9.35ms/app/Models/Article.php:262mes
      Metadata
      Bindings
      • 0. 5831
      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` = 5831
      9.17msview::theme::article.components.companies:1mes
      Metadata
      Bindings
      • 0. 5831
      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` = 5831
      10.31msview::theme::article.view.generic:45mes
      Metadata
      Bindings
      • 0. 5831
      Backtrace
      • 19. view::theme::article.view.generic:45
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select `tags`.*, `articles_tags`.`article_id` as `pivot_article_id`, `articles_tags`.`tag_id` as `pivot_tag_id` from `tags` inner join `articles_tags` on `tags`.`id` = `articles_tags`.`tag_id` where `articles_tags`.`article_id` = 5831
      6.87msview::theme::article.view.generic:51mes
      Metadata
      Bindings
      • 0. 5831
      Backtrace
      • 19. view::theme::article.view.generic:51
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-03-30 01:03:21' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
      95.74ms/app/Models/Article.php:375mes
      Metadata
      Bindings
      • 0. publish
      • 1. hidden
      • 2. 8
      • 3. 2025-03-30 01:03:21
      • 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)
      1.8ms/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.68ms/app/Models/Article.php:375mes
      Metadata
      Backtrace
      • 24. /app/Models/Article.php:375
      • 25. view::theme::layouts.components.sidebar:8
      • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `article_types` where `article_types`.`id` in (2, 3, 4, 5)
      2.04ms/app/Models/Article.php:375mes
      Metadata
      Backtrace
      • 19. /app/Models/Article.php:375
      • 20. view::theme::layouts.components.sidebar:8
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `id`, `name`, `shortname` from `categories` where `parent_id` is null and `id` not in (999, 100) and exists (select * from `articles` where `categories`.`id` = `articles`.`primary_category` and `publish_at` < '2025-03-30 01:03:21' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
      52.08ms/app/View/Composers/SubfooterComposer.php:38mes
      Metadata
      Bindings
      • 0. 999
      • 1. 100
      • 2. 2025-03-30 01:03:21
      • 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
      8.89ms/app/View/Composers/SubfooterComposer.php:38mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:38
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (1, 1000, 1003, 7, 1001, 9, 1002, 8) limit 5
      6.91ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Bindings
      • 0. 
      • 1. 0
      • 2. 1
      • 3. 1000
      • 4. 1003
      • 5. 7
      • 6. 1001
      • 7. 9
      • 8. 1002
      • 9. 8
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:63
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (7, 8, 9, 1000)
      1.68ms/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)
      45.93ms/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)
      22.98ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `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
      24.64ms/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.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 `categories`.`id` in (2)
      1.26ms/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.59ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (3, 1005, 23, 26, 25, 21, 20, 24, 22) limit 5
      2.73ms/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)
      1.33ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (3)
      1.74ms/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)
      900μs/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `articles` where `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')) and `primary_category` in (6, 45, 44, 46, 1008, 1006, 40, 43, 47, 39, 41, 42, 1007) limit 5
      4.03ms/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.35ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (6)
      1.57ms/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)
      1.61msview::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.02ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 1 and `categories`.`parent_id` is not null order by `shortname` asc
      1.53ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:21' 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
      73.25msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:21
      • 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.13msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (1)
      820μsview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 24. view::theme::layouts.components.category_subfooter:19
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `article_types` where `article_types`.`id` in (3)
      910μsview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 3 limit 1
      19.47ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 3 and `categories`.`parent_id` is not null order by `shortname` asc
      2.06ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:22' 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
      79.18msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:22
      • 1. 0
      • 2. 
      • 3. 8
      • 4. 3
      • 5. 1005
      • 6. 23
      • 7. 26
      • 8. 25
      • 9. 21
      • 10. 20
      • 11. 24
      • 12. 22
      • 13. 8
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:19
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (23, 25)
      1.76msview::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.61msview::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.23msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 5 limit 1
      1.95ms/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.3ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 5
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:22' 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
      79.49msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:22
      • 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)
      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 (5)
      1.46msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 24. view::theme::layouts.components.category_subfooter:19
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `article_types` where `article_types`.`id` in (2, 3)
      1.41msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 6 limit 1
      1.79ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 6 and `categories`.`parent_id` is not null order by `shortname` asc
      1.51ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:22' 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
      110msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:22
      • 1. 0
      • 2. 
      • 3. 8
      • 4. 6
      • 5. 45
      • 6. 44
      • 7. 46
      • 8. 1008
      • 9. 1006
      • 10. 40
      • 11. 43
      • 12. 47
      • 13. 39
      • 14. 41
      • 15. 42
      • 16. 1007
      • 17. 8
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:19
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (44, 47, 1007)
      1.64msview::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.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 (3)
      1.08msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `articles` where `status` = 'publish' and `visibility` <> 'hidden' and `article_type_id` <> '8' and `publish_at` <= '2025-03-30 01:03:22' and `primary_image` is not null and `primary_image` <> '' and `primary_image` <> '0' order by `publish_at` desc limit 30
      95.93ms/app/Models/Article.php:375mes
      Metadata
      Bindings
      • 0. publish
      • 1. hidden
      • 2. 8
      • 3. 2025-03-30 01:03:22
      • 4. 
      • 5. 0
      Backtrace
      • 14. /app/Models/Article.php:375
      • 15. view::theme::layouts.components.sidebar:8
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`id` in (7, 13, 15, 19, 21, 23, 24, 25, 26, 27, 31, 32, 44, 47, 1000, 1001)
      2.19ms/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.57ms/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.59ms/app/Models/Article.php:375mes
      Metadata
      Backtrace
      • 19. /app/Models/Article.php:375
      • 20. view::theme::layouts.components.sidebar:8
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `id`, `name`, `shortname` from `categories` where `parent_id` is null and `id` not in (999, 100) and exists (select * from `articles` where `categories`.`id` = `articles`.`primary_category` and `publish_at` < '2025-03-30 01:03:22' and `primary_image` is not null and (`primary_image` is not null and `primary_image` not in ('', '0')))
      41.86ms/app/View/Composers/SubfooterComposer.php:38mes
      Metadata
      Bindings
      • 0. 999
      • 1. 100
      • 2. 2025-03-30 01:03:22
      • 3. 
      • 4. 0
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:38
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6) order by `shortname` asc
      1.39ms/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
      2.67ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Bindings
      • 0. 
      • 1. 0
      • 2. 1
      • 3. 1000
      • 4. 1003
      • 5. 7
      • 6. 1001
      • 7. 9
      • 8. 1002
      • 9. 8
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:63
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (7, 8, 9, 1000)
      1.46ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (1)
      980μ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)
      1.35ms/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.98ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Bindings
      • 0. 
      • 1. 0
      • 2. 3
      • 3. 1005
      • 4. 23
      • 5. 26
      • 6. 25
      • 7. 21
      • 8. 20
      • 9. 24
      • 10. 22
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:63
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (20, 23)
      2.83ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (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)
      1.65ms/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
      16.63ms/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.47ms/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.28ms/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.65ms/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.49ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Bindings
      • 0. 
      • 1. 0
      • 2. 5
      • 3. 37
      • 4. 36
      • 5. 35
      Backtrace
      • 14. /app/View/Composers/SubfooterComposer.php:63
      • 15. /app/View/Composers/SubfooterComposer.php:19
      • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (36, 37)
      1.47ms/app/View/Composers/SubfooterComposer.php:63mes
      Metadata
      Backtrace
      • 19. /app/View/Composers/SubfooterComposer.php:63
      • 20. /app/View/Composers/SubfooterComposer.php:19
      • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
      • 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
      • 25. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
    • select * from `categories` where `categories`.`id` in (5)
      1.1ms/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.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 `parent_id` is null and `id` not in (999, 100, 1061)
      1.69msview::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.71ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 1 and `categories`.`parent_id` is not null order by `shortname` asc
      1.36ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:23' 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
      73.2msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:23
      • 1. 0
      • 2. 
      • 3. 8
      • 4. 1
      • 5. 1000
      • 6. 1003
      • 7. 7
      • 8. 1001
      • 9. 9
      • 10. 1002
      • 11. 8
      • 12. 8
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:19
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (7, 8, 1000, 1001)
      1.18msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (1)
      1.24msview::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.2msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 3 limit 1
      1.49ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 3 and `categories`.`parent_id` is not null order by `shortname` asc
      1.64ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:23' 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
      81.13msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:23
      • 1. 0
      • 2. 
      • 3. 8
      • 4. 3
      • 5. 1005
      • 6. 23
      • 7. 26
      • 8. 25
      • 9. 21
      • 10. 20
      • 11. 24
      • 12. 22
      • 13. 8
      Backtrace
      • 14. view::theme::layouts.components.category_subfooter:19
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (23, 25)
      1.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` in (3)
      1.11msview::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` = 4 limit 1
      2.08ms/app/Models/Category.php:142mes
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 19. /app/Models/Category.php:142
      • 20. view::theme::layouts.components.category_subfooter:18
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `categories` where `categories`.`parent_id` = 4 and `categories`.`parent_id` is not null order by `shortname` asc
      1.44ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:23' 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
      71.22msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:23
      • 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.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` in (4)
      1.57msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 24. view::theme::layouts.components.category_subfooter:19
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `article_types` where `article_types`.`id` in (2, 3)
      1.25msview::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
      2.24ms/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.62ms/app/Models/Category.php:148mes
      Metadata
      Bindings
      • 0. 5
      Backtrace
      • 20. /app/Models/Category.php:148
      • 21. view::theme::layouts.components.category_subfooter:18
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select `articles`.* from `articles` where `publish_at` < '2025-03-30 01:03:23' 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
      92.18msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Bindings
      • 0. 2025-03-30 01:03:23
      • 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)
      970μsview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 19. view::theme::layouts.components.category_subfooter:19
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` in (5)
      1.45msview::theme::layouts.components.category_subfooter:19mes
      Metadata
      Backtrace
      • 24. view::theme::layouts.components.category_subfooter:19
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `article_types` where `article_types`.`id` in (2, 3)
      1.02msview::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\Author
    1
    App\Models\ArticleType
    29
    App\Models\Category
    273
    App\Models\Article
    141
      _token
      hPsEz7HP4pbiNDdlKakHVTSGdduaG7UyLIz2Oz1k
      _previous
      array:1 [ "url" => "https://dev007.militaryembedded.com/cyber/cybersecurity/blockchain-for-embedde...
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /cyber/cybersecurity/blockchain-for-embedded-systems-part-2
      status_code
      200
      
      status_text
      OK
      format
      html
      content_type
      text/html; charset=UTF-8
      request_query
      []
      
      request_request
      []
      
      request_headers
      0 of 0
      array:24 [ "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "priority" => array:1 [ 0 => "u=0, i" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cf-connecting-ip" => array:1 [ 0 => "18.223.29.51" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "x-forwarded-for" => array:1 [ 0 => "18.223.29.51" ] "cf-ray" => array:1 [ 0 => "9283afc97a8e5d07-ORD" ] "host" => array:1 [ 0 => "dev007.militaryembedded.com" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
      request_server
      0 of 0
      array:47 [ "USER" => "forge" "HOME" => "/home/forge" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_PRIORITY" => "u=0, i" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CF_CONNECTING_IP" => "18.223.29.51" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_X_FORWARDED_FOR" => "18.223.29.51" "HTTP_CF_RAY" => "9283afc97a8e5d07-ORD" "HTTP_HOST" => "dev007.militaryembedded.com" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SERVER_NAME" => "dev007.militaryembedded.com" "SERVER_PORT" => "443" "SERVER_ADDR" => "209.38.74.90" "REMOTE_PORT" => "" "REMOTE_ADDR" => "18.223.29.51" "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" => "/cyber/cybersecurity/blockchain-for-embedded-systems-part-2" "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" => 1743296600.7155 "REQUEST_TIME" => 1743296600 ]
      request_cookies
      []
      
      response_headers
      0 of 0
      array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 30 Mar 2025 01:03:22 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjhBa0xQa3ZtVjBLV2J3MVAyWEJXZlE9PSIsInZhbHVlIjoicDdWcXllWVRNN3ZxbEp5dU0xMU1MUllZQnlKZWhZL0V6REJkeW5JUmtYbDJ2NlZ3NGxqekxYRlNRZWZta3ZIcnhvSG1tNnlBNG9XVWVqcVlnL1liOXJ3bkxUWmRGYmNlbGRXZjQzM1Jhb1ZFTStleGVINmxhWVpmOVNsL0R6ODYiLCJtYWMiOiIxMjBmM2FmZjJjOWZjNzIzMTU5ODBiZDA2YWZlMzc4ZWRkN2Y3ODIzYjU2ZTc4N2Q2YmY2MDExZDE3NTc3NGI1IiwidGFnIjoiIn0%3D; expires=Sun, 30 Mar 2025 03:03:23 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjhBa0xQa3ZtVjBLV2J3MVAyWEJXZlE9PSIsInZhbHVlIjoicDdWcXllWVRNN3ZxbEp5dU0xMU1MUllZQnlKZWhZL0V6REJkeW5JUmtYbDJ2NlZ3NGxqekxYRlNRZWZta3ZIcnhvSG1tN" 1 => "military_embedded_systems_session=eyJpdiI6IjBraVFpdkd6UldXMWI0VHc1eTloWmc9PSIsInZhbHVlIjoibUxjalh6bDdDUFkzTUdMWlcyQTVHdjlrNjdwaGxtTG9NdWMrcGVaa0tzbmtXVWJ4b1N4RFdzNS9HQ0tuWit0MWpKZWtTajdmRVZOeGVUM0gwV1hzMUMydGNmemg1Mm1vOFFSbGNiUWhCUVkvM3pBdzhwZGo3cTlUMzdTbHF3bkciLCJtYWMiOiIzYjEyN2VkNmNhOWI2Y2E3OWUzODY0N2E5Y2FjYzUxOTc2Y2IxNzQzZjUzODZlNzBkOTEzZmNhNDEyY2M0OWY3IiwidGFnIjoiIn0%3D; expires=Sun, 30 Mar 2025 03:03:23 GMT; Max-Age=7200; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6IjBraVFpdkd6UldXMWI0VHc1eTloWmc9PSIsInZhbHVlIjoibUxjalh6bDdDUFkzTUdMWlcyQTVHdjlrNjdwaGxtTG9NdWMrcGVaa0tzbmtXVWJ4b1N4RF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjhBa0xQa3ZtVjBLV2J3MVAyWEJXZlE9PSIsInZhbHVlIjoicDdWcXllWVRNN3ZxbEp5dU0xMU1MUllZQnlKZWhZL0V6REJkeW5JUmtYbDJ2NlZ3NGxqekxYRlNRZWZta3ZIcnhvSG1tNnlBNG9XVWVqcVlnL1liOXJ3bkxUWmRGYmNlbGRXZjQzM1Jhb1ZFTStleGVINmxhWVpmOVNsL0R6ODYiLCJtYWMiOiIxMjBmM2FmZjJjOWZjNzIzMTU5ODBiZDA2YWZlMzc4ZWRkN2Y3ODIzYjU2ZTc4N2Q2YmY2MDExZDE3NTc3NGI1IiwidGFnIjoiIn0%3D; expires=Sun, 30-Mar-2025 03:03:23 GMT; path=/XSRF-TOKEN=eyJpdiI6IjhBa0xQa3ZtVjBLV2J3MVAyWEJXZlE9PSIsInZhbHVlIjoicDdWcXllWVRNN3ZxbEp5dU0xMU1MUllZQnlKZWhZL0V6REJkeW5JUmtYbDJ2NlZ3NGxqekxYRlNRZWZta3ZIcnhvSG1tN" 1 => "military_embedded_systems_session=eyJpdiI6IjBraVFpdkd6UldXMWI0VHc1eTloWmc9PSIsInZhbHVlIjoibUxjalh6bDdDUFkzTUdMWlcyQTVHdjlrNjdwaGxtTG9NdWMrcGVaa0tzbmtXVWJ4b1N4RFdzNS9HQ0tuWit0MWpKZWtTajdmRVZOeGVUM0gwV1hzMUMydGNmemg1Mm1vOFFSbGNiUWhCUVkvM3pBdzhwZGo3cTlUMzdTbHF3bkciLCJtYWMiOiIzYjEyN2VkNmNhOWI2Y2E3OWUzODY0N2E5Y2FjYzUxOTc2Y2IxNzQzZjUzODZlNzBkOTEzZmNhNDEyY2M0OWY3IiwidGFnIjoiIn0%3D; expires=Sun, 30-Mar-2025 03:03:23 GMT; path=/; httponlymilitary_embedded_systems_session=eyJpdiI6IjBraVFpdkd6UldXMWI0VHc1eTloWmc9PSIsInZhbHVlIjoibUxjalh6bDdDUFkzTUdMWlcyQTVHdjlrNjdwaGxtTG9NdWMrcGVaa0tzbmtXVWJ4b1N4RF" ] ]
      session_attributes
      0 of 0
      array:4 [ "_token" => "hPsEz7HP4pbiNDdlKakHVTSGdduaG7UyLIz2Oz1k" "_previous" => array:1 [ "url" => "https://dev007.militaryembedded.com/cyber/cybersecurity/blockchain-for-embedded-systems-part-2" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]