Phone: 226-241-7827

  • Marketing
    • View All Marketing Services
    • Marketing Management
    • Data & Analytics
    • Content Creation
    • SEO
    • Google Ads
    • Websites
    • Guest Posts
    • Schedule A Meeting
    • Free Resources
      • Our Top Recommended
      • Marketing & Sales Knowledge Center
      • Business Ethics Manual
      • Sales & Marketing Podcast
      • Profitworks TV
      • Marketing Plan Template
      • Marketing Budget Worksheet
      • Competitor Review
      • The Ultimate Guide To SEO
      • SEO Checklist
  • Google Ads
  • Industries
    • HVAC Digital Marketing
    • Countertop Digital Marketing
    • Forklift Digital Marketing
    • Water Softener Digital Marketing
  • Why Pick Us?
    • We Focus On Your Sales Results
    • You Gain A Team Of Marketing Specialists
    • Our Hard Work, Integrity & Transparency
    • Our SEO Expertise
    • Because Of What Others Say About Us
    • The Results You Can Achieve
  • Careers
  • Need Help? Call 226-241-7827
  • Let's Talk
    • Digital Marketing
    • Google Ads
    • Content Creation
    • On Page Optimization
    • Website Audits
  • Search
  • Print
  • Email
Details
Website Traffic & SEO

How Google Algorithm Updates Impact Your Website Rankings And Traffic

Google Algorithm updates impact your website rankings by moving your rankings lower if you are not doing what Google wants. If, however, you are following Google's direction for how to provide web users with a better experience, Google will improve your web pages rankings in search results. (Google's most recent update was the Mobile update, continue reading to learn more). Higher rankings means more traffic and if it is the right kind of traffic this should lead to higher sales and profits. There is a large list of factors that affect search engine rankings and this list is always changing as google makes more algorithm updates. Currently, it appears the greatest factor that impacts rankings is the click through rates of your pages. In this article, you can find and overview of all of the key factors currently used by Google to determine rankings.

On this page there is also a podcast that discusses what is Google's search algorithm, what factors are currently included in the algorithm, what factors currently carry the most weight and what updates Google has made is the past to the algorithm they use to determine search result rankings. If Google's search algorithm means nothing to you, this podcast is a great place to start. 

google algorithm updates 1

 

Read more ...

  • Print
  • Email
Details
Email Marketing

Best Time Of Day To Send B2B Emails

Best Time Of Day To Send B2B EmailsAre you wondering when is the best time of day to be send B2B emails? Well you are in luck today because in this article I outline real results that show when the optimal times are.

Read more ...

  • Print
  • Email
Details
Website Traffic & SEO

SEO Tips For B2B Small Businesses

In this podcast we discuss the top 3 tips we have for B2B Small Businesses the search engine optimization efforts. If you would like us to look after your SEO, contact us now to book a time to discuss. The top three tips we outline in detail are post new content regularly, determine what keywords you want your website to rank for and ensure each page on your website has the proper metadata. 

SEO Tips for b2b small businesses

 

Read more ...

  • Print
  • Email
Details
Other

Linkedin Advertising Kitchener - Waterloo

Best Time Of Day To Send B2B EmailsIn this article I take a look at what advertising I have done on Linkedin over the five seven months and the corresponding key measures like click through rate and cost per 1000 impressions or CPM.

Read more ...

  • Print
  • Email
Details
Website Traffic & SEO

SEO Outsourcing - What Are The Benefits

 

SEO outsourcing is the contracting of another company or individual to do the SEO (search engine optimization) work on your website for you. For most businesses, outsourcing their SEO will deliver a better return on investment than spending the same money on internal SEO resources. Companies who outsource their SEO to Profitworks on average see a return on investment of 275% after a full year or more of using our services. 

In this article, we will examine all the reasons why you should be outsourcing your SEO tasks. Click on each corresponding link to jump ahead:

  1. Experience
  2. Expertise
  3. Cost-Effectiveness
  4. Access to Tools and Technology
  5. Focus on Your Core Business
  6. Scalability 
  7. Better Results
  8. Positive Return on Investment
  9. Ethical Considerations

If you require SEO outsourcing, or you have questions regarding this process, contact us directly! We are more than happy to help.

 

 

 

1. Experience

 

A) Why is it Important?

Selecting an SEO company with years of experience is crucial for several reasons:

 

Expertise and Knowledge:

SEO is a dynamic field that constantly evolves with search engine algorithms and industry trends. An experienced SEO company has likely encountered various challenges and changes in the digital landscape, honing its expertise over time. This enables them to stay abreast of the latest developments, algorithm updates, and effective strategies, giving your business a competitive edge.

 

Proven Track Record:

A company with years of experience in SEO typically has a portfolio of successful projects and case studies. This track record allows you to assess their past performance and determine if they have achieved positive results for businesses similar to yours. It provides a level of confidence that they can deliver tangible outcomes for your SEO efforts.

 

Adaptability:

Search engine optimization requires a flexible approach to adapt to the ever-changing algorithms and market dynamics. Experienced SEO professionals are more likely to have encountered a variety of scenarios and can adapt their strategies based on the unique needs of your business. They understand what works and what doesn't, providing a more refined and effective approach.

 

B) Our Experience at Profitworks

 We have 13 years of experience at Profitworks, check out our customer reviews!

 

Now, let’s focus on our 13 years of experience, what does this mean?

 

Longevity and Stability:

Profitworks' 13 years of experience signifies stability and longevity in the industry. A company that has successfully operated for over a decade is likely to be more reliable and have a deeper understanding of the SEO landscape.

 

Refined Strategies:

Over the years, Profitworks has had the opportunity to refine and optimize its SEO strategies based on real-world scenarios. This experience allows them to implement proven techniques and avoid common pitfalls that less experienced companies might encounter.

 

Client Trust:

A company with 13 years of experience is likely to have built strong relationships and earned the trust of its clients. Positive reviews and testimonials from satisfied clients can be indicative of a reliable and effective SEO service provider.

 

C) Selecting a Company With Limited Experience

If you choose a company without experience in SEO, you may encounter several challenges:

 

Ineffective Strategies:

Inexperienced companies might rely on outdated or ineffective SEO practices, leading to suboptimal results. They may lack the knowledge to navigate changes in search engine algorithms.

 

Risk of Penalties:

SEO involves adhering to ethical practices to avoid penalties from search engines. Inexperienced companies may unknowingly engage in practices that violate guidelines, risking penalties and negatively impacting your website's ranking.

 

Wasted Resources:

Without a solid understanding of effective SEO strategies, an inexperienced company may waste your time and resources on tactics that yield minimal results or, worse, harm your online presence.

 

In conclusion, choosing an SEO company with years of experience, such as Profitworks with its 13 years in the industry, provides a higher likelihood of success, proven expertise, and a reliable partner for your business's digital marketing needs.

 

2. Expertise

Would you trust your car with an inexperienced mechanic? No! You shouldn't with SEO either.

 

Choosing a digital marketing company possessing proficiency in SEO and a dedicated team specializing in diverse sub-components of SEO is essential for the following reasons:

 

Comprehensive Approach:

SEO is a multifaceted discipline that encompasses various aspects, including:

  • On-page optimization
  • Off-page optimization
  • Technical SEO
  • Content creation
  • Link building
  • And more

A company with specialized staff can provide a comprehensive approach, addressing each element effectively to maximize the impact on your website's visibility and performance in search engines.

 

Depth of Knowledge:

Specialized staff bring a deeper understanding and expertise in their respective areas, such as:

  • Keyword research
  • Technical audits
  • Content optimization

Having specialists ensures that each aspect of your SEO strategy is handled by professionals with in-depth knowledge, staying updated on the latest trends and best practices.

 

Stay Updated with Industry Changes:

SEO is an ever-evolving field, with search engines frequently updating algorithms and introducing new features. Specialists who focus on specific aspects of SEO are better equipped to stay abreast of changes in their particular domains. This ensures that your SEO strategy remains adaptable and effective in the face of industry developments.

 

Problem Resolution:

Inevitably, challenges and issues arise in the course of SEO campaigns. Having specialists in different areas means that the team is equipped to handle specific problems efficiently, minimizing downtime and potential negative impacts on your website's performance.

 

In summary, selecting an SEO company with specialized staff is vital for a well-rounded and effective approach to search engine optimization. 

 

3. Cost-Effectiveness

Watch the video above to learn about the cost-effectiveness of outsourcing and other benefits. 

  

Selecting Profitworks can be considered cost-effective for several reasons, particularly in the context of receiving an entire team of SEO specialists for the cost of one SEO marketer. At Profitworks, we have a dedicated team of individuals with unique skills and strengths. What does this mean for you?

 

Comprehensive Strategy Development:

With a team of specialists, Profitworks can develop a comprehensive and well-rounded SEO strategy that covers all crucial aspects of search engine optimization. This holistic approach is more likely to yield positive results, as it addresses both on-page and off-page optimization, technical aspects, and content creation, ensuring a more thorough and effective strategy.

 

Efficient Task Execution:

Each specialist within the team can focus on their area of expertise, leading to more efficient task execution. This efficiency not only ensures that tasks are completed in a timely manner but also enhances the quality of work, as specialists can dedicate their attention to specific aspects of your SEO campaign.

 

Increased Productivity:

A team of specialists working collaboratively can handle a larger volume of work compared to a single marketer. This increased productivity allows for the implementation of a more extensive and impactful SEO strategy, potentially leading to faster and more significant improvements in your website's search engine rankings.

 

Access to a Range of Skills:

Different SEO tasks require different skills, and a team of specialists provides a diverse skill set. Whether it’s:

  • Crafting compelling content
  • Conducting in-depth keyword research
  • Implementing technical optimizations

You have access to a broad range of skills that contribute to the overall success of your SEO efforts.

 

In summary, selecting Profitworks can be cost-effective due to the access to a team of SEO specialists.

 

4. Access to Tools and Technology

Google Analytics is just one tool that SEO experts should be well versed in. 

 

Choosing a company that has access to advanced tools and technology for SEO, like Profitworks, offers several benefits:

 

Data-Driven Decision-Making:

Advanced SEO tools provide in-depth analytics and data about your:

  • Website's performance
  • User behaviour
  • Market trends

Companies with access to these tools can interpret and analyze this data to make informed decisions, enabling a more strategic and effective SEO strategy. This data-driven approach helps refine tactics and allocate resources where they will have the most impact.

 

Competitive Analysis:

Advanced SEO tools enable thorough competitive analysis, helping businesses understand how their competitors are performing in search engine rankings. This information is crucial for devising strategies to outperform competitors and gain a competitive edge. Companies with access to these tools can conduct comprehensive analyses and implement targeted strategies based on the insights gained.

 

Keyword Research and Optimization:

Keyword research is a fundamental aspect of SEO. Advanced tools aid in:

  • Identifying relevant keywords
  • Analyzing search volume
  • Understanding user intent

With these tools, companies can optimize content for the most valuable keywords, increasing the likelihood of attracting targeted organic traffic.

 

Link Building Strategies:

Effective link-building is critical for SEO success. Tools can assist in:

  • Identifying quality link-building opportunities
  • Analyzing backlink profiles
  • Monitoring the effectiveness of link-building campaigns

This ensures a more strategic and data-driven approach to building a strong and authoritative online presence.

 

In conclusion, selecting a company with access to tools and technology for SEO empowers your business with valuable insights, efficiency, and a competitive advantage.

 

5. Allows you to Focus on Your Core Business

Outsourcing your SEO allows you to focus on what truly matters - your business.

 

Outsourcing SEO services provides several advantages that allow you to focus on your core business activities:

 

Time and Resource Savings:

Managing SEO in-house demands time and resources for:

  • Training
  • Tool acquisition
  • Staying updated on industry trends

Outsourcing allows you to save time and redirect resources to aspects of your business where your team excels. This can lead to increased overall efficiency and productivity.

 

Scalability and Flexibility:

Outsourcing SEO provides scalability, allowing you to adjust the level of service based on your business needs. Whether you're expanding, downsizing, or simply adjusting your strategy, an outsourced SEO team can adapt quickly to changes, providing flexibility in your overall business strategy.

 

Focus on Core Competencies:

Your core business likely involves product development, customer service, and other critical aspects. Outsourcing SEO allows you to concentrate on what you do best, leaving the intricacies of search engine optimization to specialists. This focus on core competencies enhances your ability to excel in your industry.

 

Reduced Management Burden:

SEO campaigns require ongoing:

  • Management
  • Monitoring
  • Adjustments

By outsourcing, you transfer the management burden to the SEO service provider. This allows you to concentrate on strategic decision-making and other managerial responsibilities within your business.

 

In summary, outsourcing SEO services allows you to leverage the expertise of professionals, save time and resources, access advanced tools, and focus on your core business competencies. 

 

6. Scalability

Watch the video above to learn more about how outsourcing can improve your scalability. 

 

Scalability is a significant advantage when it comes to outsourcing SEO services. Here's a more detailed explanation of how SEO agencies can scale their services to meet your business needs:

 

Flexible Service Packages:

SEO agencies often offer a range of service packages to accommodate businesses of various sizes and requirements. Whether you're a small startup or a large enterprise, you can choose a service package that aligns with your current needs. As your business grows or undergoes changes, the SEO agency can easily adjust the service package to scale up or down accordingly.

 

Customized Campaigns:

Every business has unique goals and SEO needs can vary based on:

  • Industry
  • Target audience
  • Competition

SEO agencies understand this diversity and can create customized campaigns tailored to your specific requirements. This flexibility allows for scalability, as the agency can adapt its strategies to accommodate the evolving needs of your business.

 

Resource Allocation:

Outsourcing SEO enables you to allocate resources efficiently. Instead of investing in a full in-house team with fixed costs, you can scale your SEO efforts by tapping into the resources of an agency. This allows for a more dynamic allocation of resources based on your business growth or changes in marketing priorities.

 

Scalable Content Production:

Content is a crucial aspect of SEO, and the demand for content can vary. SEO agencies often can scale content production based on your needs. Whether you require:

  • Regular blog posts
  • Product descriptions
  • Multimedia content

An agency can adjust its content creation efforts to match your evolving content strategy.

 

In conclusion, outsourcing SEO to an agency provides scalability by offering flexible service packages, customized campaigns, efficient resource allocation, quick response to changes, scalable content production, global reach, and the ability to adapt to seasonal variations and technology advancements. 

 

7. Better Results

Looking for better results? Outsource your SEO to an experienced marketing agency.

 

Outsourcing your SEO to a specialized company often leads to better results, and one contributing factor is the continuous learning and research that SEO companies undertake. Here's a more detailed explanation of how this dynamic learning process can enhance the outcomes of your SEO efforts:

 

Industry Expertise and Insights:

SEO companies work with a diverse range of clients across various industries. This exposure provides them with valuable insights into:

  • Different market landscapes
  • Consumer behaviours
  • Industry trends

The collective experience gained from working with multiple clients allows the SEO company to develop a deep understanding of what strategies work effectively in different contexts.

 

Benchmarking Against Competitors:

SEO companies constantly analyze the strategies and performance of competitors in various industries. This benchmarking process allows them to identify:

  • Best practices
  • Emerging trends
  • Areas of improvement

By applying these insights to your SEO strategy, the company can position your business more competitively in search engine results.

 

Continuous Learning from Campaigns:

Every SEO campaign presents an opportunity to learn and refine strategies. SEO companies take lessons from their successes and failures across various campaigns. This iterative learning process ensures that your SEO strategy benefits from ongoing improvements, making it increasingly effective over time.

 

Staying Updated on Industry Trends:

The digital marketing landscape evolves rapidly, with new technologies and trends emerging regularly. SEO companies invest time and resources in staying updated on these industry trends. This ensures that your SEO strategy incorporates the latest advancements, keeping your business at the forefront of online marketing practices.

 

In summary, outsourcing SEO to a company that is constantly learning from its diverse client base and engaging in daily research leads to better results. 

 

8. Positive Return on Investment 

As this graph suggests, SEO yields a positive ROI compared to other marketing channels. 

 

Profitworks embraces the philosophy that clients should witness tangible returns on their investment in SEO services within the initial year of engagement. Specializing in enhancing organic search rankings, Profitworks extends its SEO services to websites seeking to amplify their return on investment (ROI).

In our experience, the impact of SEO services is typically substantial, yielding an impressive 275% ROI. This translates to an extra $2.75 in profit for every dollar invested, contingent upon the specific industry. Our commitment revolves around delivering results that not only meet but exceed our client's expectations, ensuring a robust and lucrative online presence. 

 

9. Ethical Considerations in SEO Outsourcing

 

A) How to Do It Ethically:

Transparency:

Ethical SEO outsourcing begins with transparency. Ensure that the SEO company is open and honest about their methods, strategies, and any potential risks. Transparency builds trust between your business and the outsourced SEO team.

 

Adherence to Guidelines:

Ethical SEO practices involve strictly adhering to search engine guidelines. Unethical tactics, such as keyword stuffing, cloaking, or buying links, can lead to penalties and long-term damage to your online presence. Choose an SEO partner committed to following ethical and sustainable strategies.

 

Client Education:

Ethical SEO providers prioritize client education. They explain their strategies, provide insights into the optimization process, and help you understand the long-term benefits of ethical practices. This empowers you to make informed decisions about your digital marketing strategy.

 

Content Quality and Relevance:

Ethical SEO emphasizes the creation of high-quality, relevant content. Content should be valuable to users, addressing their needs and providing a positive user experience. Unethical practices like content spinning or duplicating can harm your reputation and lead to poor search engine rankings.

 

Link Building with Integrity:

Ethical link-building focuses on acquiring high-quality, relevant backlinks through organic and natural means. Avoid engaging in link schemes or purchasing low-quality links, as this can result in penalties from search engines. A trustworthy SEO partner builds a strong link profile through ethical means.

 

Respect for Intellectual Property:

Ethical SEO involves respecting intellectual property rights. This includes avoiding plagiarism, unauthorized use of copyrighted material, and giving proper attribution when using third-party content. Unethical practices in this regard can lead to legal issues and damage your brand's reputation.

 

B) What Not to Do:

Keyword Stuffing:

Avoid stuffing your content with excessive keywords. This not only provides a poor user experience but also violates search engine guidelines.

 

Cloaking:

Cloaking involves presenting different content to users and search engines. This deceptive practice is considered unethical and can lead to severe penalties.

 

Hidden Text or Links:

Concealing text or links on a page for search engines but not for users is deceptive. Such tactics violate search engine guidelines and can result in penalties.

 

Buying Links:

Purchasing links to manipulate search engine rankings is an unethical practice. Focus on organic link-building strategies to build a reputable online presence.

 

Duplicate Content:

Publishing identical or substantially similar content across multiple pages or websites is considered unethical. It can lead to confusion for users and negatively impact search rankings.

 

C) Pros of Doing It Ethically:

Long-Term Sustainability:

Ethical SEO practices contribute to the long-term sustainability of your online presence. By adhering to guidelines, you reduce the risk of penalties and maintain a positive reputation with search engines.

 

User Trust and Engagement:

Ethical SEO focuses on providing value to users. This approach builds trust and encourages user engagement, leading to a positive perception of your brand.

 

Positive Brand Image:

Ethical SEO contributes to a positive brand image. Users and search engines recognize businesses that operate ethically, enhancing your brand's credibility and trustworthiness.

 

Compliance with Regulations:

Ethical SEO practices align with legal and regulatory requirements, mitigating the risk of legal issues associated with unethical practices.

 

D) Cons of Doing It Unethically:

Search Engine Penalties:

Unethical SEO practices can result in penalties from search engines, including lower rankings or even removal from search results. This can severely impact your online visibility.

 

Reputation Damage:

Engaging in unethical practices can damage your brand's reputation. Users may lose trust in your business, leading to a decline in customer loyalty and potential legal consequences.

 

Wasted Resources:

Unethical SEO efforts often yield short-term gains but can lead to long-term consequences. Resources invested in unethical tactics may result in wasted time and effort when search engines penalize your website.

 

Loss of Business Opportunities:

A damaged reputation and poor search engine rankings can lead to a loss of business opportunities. Potential customers may choose competitors with a more ethical and trustworthy online presence.

 

In summary, ethical SEO outsourcing involves transparency, adherence to guidelines, client education, and a commitment to quality content and link-building practices. The pros of ethical SEO include long-term sustainability, positive brand image, user trust, and compliance with regulations. On the contrary, unethical practices can lead to search engine penalties, reputation damage, wasted resources, and loss of business opportunities. Choosing ethical SEO practices is not only beneficial for your online presence but also aligns with principles of integrity and trust in the digital marketplace.  

 

Need SEO Outsourcing? Rely on Profitworks  

Profitworks Small Business Services provides website traffic and website conversion optimization services which increase the number of sales generated from a website. The focus of our services is on increasing sales and return on investment from a website and not any other metric. To learn more about Profitworks click here. Connect with us on Google+ or if you are just interested in getting new customers for your businesses feel free to click the "Send Me Free Sales Insights" button below to get free advice on how to gain new customers.

Get Started Now  

  1. Email Marketing From Line Open Rates
  2. The Difference Between Organic vs Paid Search
  3. Direct Mail Design
  4. Is Search Engine Optimization (SEO) Worth The Money?

Page 20 of 51

  • Start
  • Prev
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • Next
  • End

Profitworks is a digital marketing agency that specializes in helping businesses unlock their untapped revenue opportunities. Profitworks is a company built on the values of integrity, hard work, doing things better than they have ever been done before, and the utmost commitment to our customers.

 

226-241-7827
 

 

Waterloo ON, Canada
 

 

 
info@profitworks.ca
facebook twitter google linkedin
 
Learn
Marketing Strategy
How To Grow Revenue
How To Grow Traffic
Market Leadership
Marketing Services
SEO For Small Business
SEO For E-commerce
SEO For Enterprises
SEO Consulting
Customer Support
Sales & Support
Resolve An Issue
Technical Support
Billing
Technology
Google Analytics
Google Search Console
Bing Webmaster Tools
Web Visitor Identifier
Profitworks Values
Hard Work
Integrity
Transparency
Business Ethics
Company
About Profitworks
Careers
Privacy Policy
Contact Profitworks
Profitworks Logo

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1754835248,
                "last": 1754835249,
                "now": 1754835249
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "8dfe3de908b9bee026543680355a7f603b7b066b": {
                    "link": "https://profitworks.trinitywebhosting.com/blog/website-search-engine-optimization-service-tips-and-advice/436-how-google-algorithm-updates-impact-your-website-rankings-and-traffic.html",
                    "expiry": 1754835249
                },
                "b8ec4aafa85e484da5fb8c12fd3cb312b9195751": {
                    "link": "https://profitworks.trinitywebhosting.com/blog/email-marketing-campaign-tips/139-best-time-of-day-to-send-b2b-emails.html",
                    "expiry": 1754835249
                },
                "0f142ab2645a8b2b0591451217d2c8f4d2988b94": {
                    "link": "https://profitworks.trinitywebhosting.com/blog/website-search-engine-optimization-service-tips-and-advice/434-seo-tips-for-b2b-small-businesses.html",
                    "expiry": 1754835249
                },
                "4ba8095ad04d62b2510059f9b437dc63db04d805": {
                    "link": "https://profitworks.trinitywebhosting.com/blog/other-blog-articles/140-linkedin-advertising-kitchener-waterloo.html",
                    "expiry": 1754835249
                },
                "c559bee3cce3edecf582ca74401140fad96c5b31": {
                    "link": "https://profitworks.trinitywebhosting.com/blog/website-search-engine-optimization-service-tips-and-advice/431-seo-outsourcing-what-are-the-benefits.html",
                    "expiry": 1754835249
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 12.45 ms / 12.45 ms Memory: 2.026 MB / 2.40 MB Application: afterLoad
Time: 52.43 ms / 64.87 ms Memory: 6.487 MB / 8.88 MB Application: afterInitialise
Time: 16.28 ms / 81.15 ms Memory: 1.905 MB / 10.79 MB Application: afterRoute
Time: 5.31 ms / 86.46 ms Memory: 0.451 MB / 11.24 MB Application: beforeRenderComponent com_content
Time: 4.03 ms / 90.49 ms Memory: 0.543 MB / 11.78 MB Application: Before Access::preloadComponents (all components)
Time: 0.97 ms / 91.46 ms Memory: 0.061 MB / 11.84 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 91.48 ms Memory: -0.005 MB / 11.84 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.37 ms / 91.85 ms Memory: 0.034 MB / 11.87 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 59.52 ms / 151.37 ms Memory: 3.670 MB / 15.54 MB Application: afterRenderComponent com_content
Time: 0.57 ms / 151.94 ms Memory: 0.006 MB / 15.55 MB Application: afterDispatch
Time: 3.48 ms / 155.42 ms Memory: 0.297 MB / 15.85 MB Application: beforeRenderModule mod_custom (Profitworks - Contact Us - Social Icons 1st footer)
Time: 0.63 ms / 156.06 ms Memory: 0.039 MB / 15.88 MB Application: afterRenderModule mod_custom (Profitworks - Contact Us - Social Icons 1st footer)
Time: 0.28 ms / 156.34 ms Memory: -0.001 MB / 15.88 MB Application: beforeRenderModule mod_custom (Footer Home Learn item 1)
Time: 0.15 ms / 156.49 ms Memory: 0.003 MB / 15.89 MB Application: afterRenderModule mod_custom (Footer Home Learn item 1)
Time: 0.01 ms / 156.49 ms Memory: 0.000 MB / 15.89 MB Application: beforeRenderModule mod_custom (Footer Marketing Services item 2)
Time: 0.12 ms / 156.61 ms Memory: 0.003 MB / 15.89 MB Application: afterRenderModule mod_custom (Footer Marketing Services item 2)
Time: 0.01 ms / 156.62 ms Memory: 0.000 MB / 15.89 MB Application: beforeRenderModule mod_custom (Footer Customer Support Menu item 3)
Time: 0.09 ms / 156.71 ms Memory: 0.004 MB / 15.89 MB Application: afterRenderModule mod_custom (Footer Customer Support Menu item 3)
Time: 0.01 ms / 156.71 ms Memory: -0.000 MB / 15.89 MB Application: beforeRenderModule mod_custom (Footer Technology Menu item 4)
Time: 0.08 ms / 156.80 ms Memory: 0.003 MB / 15.90 MB Application: afterRenderModule mod_custom (Footer Technology Menu item 4)
Time: 0.01 ms / 156.80 ms Memory: 0.000 MB / 15.90 MB Application: beforeRenderModule mod_custom (Footer Profitworks Values item 5)
Time: 0.08 ms / 156.88 ms Memory: 0.003 MB / 15.90 MB Application: afterRenderModule mod_custom (Footer Profitworks Values item 5)
Time: 0.01 ms / 156.89 ms Memory: 0.000 MB / 15.90 MB Application: beforeRenderModule mod_custom (Footer Company Menu item 6)
Time: 0.08 ms / 156.96 ms Memory: 0.003 MB / 15.90 MB Application: afterRenderModule mod_custom (Footer Company Menu item 6)
Time: 0.93 ms / 157.89 ms Memory: 0.005 MB / 15.91 MB Application: beforeRenderModule mod_custom (Copyright)
Time: 0.11 ms / 158.00 ms Memory: 0.004 MB / 15.91 MB Application: afterRenderModule mod_custom (Copyright)
Time: 0.04 ms / 158.04 ms Memory: 0.001 MB / 15.91 MB Application: beforeRenderModule mod_menu (Top Menu)
Time: 6.05 ms / 164.09 ms Memory: 0.337 MB / 16.25 MB Application: afterRenderModule mod_menu (Top Menu)
Time: 0.07 ms / 164.16 ms Memory: -0.008 MB / 16.24 MB Application: beforeRenderModule mod_custom (header-Phone Number)
Time: 0.12 ms / 164.28 ms Memory: 0.003 MB / 16.25 MB Application: afterRenderModule mod_custom (header-Phone Number)
Time: 12.93 ms / 177.21 ms Memory: 1.192 MB / 17.44 MB Application: afterRender

Database queries total: 29.71 ms

Memory Usage

18.05 MB (18,925,016 Bytes)

Database Queries

41 Queries Logged 29.71 ms


9 duplicate found!

9 duplicates: #26  #29  #30  #33  #34  #35  #36  #37  #38
  1. Query Time: 0.51 ms Query memory: 0.020 MB Memory before query: 4.246 MB Rows returned: 1
    SELECT `session_id`
    
      FROM `dfyr2_session`
      WHERE `session_id` = X'3338643831353364663333343366616238666532393266643864336539623564'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.04 ms
    Statistics0.06 ms
    Preparing0.00 ms
    Unlocking tables0.01 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.61 ms After last query: 1.73 ms Query memory: 0.025 MB Memory before query: 4.436 MB Rows returned: 44
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `dfyr2_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefextensionextension82const45Using index condition; Using where
    Profile
    StatusDuration
    Starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.17 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 0.25 ms After last query: 1.94 ms Query memory: 0.021 MB Memory before query: 4.696 MB Rows returned: 5
    SELECT id, rules
    
      FROM `dfyr2_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.28 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 4.708 MB Rows returned: 2
    SELECT b.id
    
      FROM dfyr2_usergroups AS a
      LEFT JOIN dfyr2_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where; Using index
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.84 ms After last query: 0.54 ms Query memory: 0.031 MB Memory before query: 4.777 MB Rows returned: 121
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM dfyr2_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsALLextensionNO INDEX KEY COULD BE USEDNULLNULL273Using where; Using filesort
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.54 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.25 ms After last query: 4.00 ms Query memory: 0.021 MB Memory before query: 5.441 MB Rows returned: 0
    SELECT `path`
    
      FROM dfyr2_rsfirewall_ignored
      WHERE `type`='ignore_folder' OR `type`='ignore_file'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    11JDatabaseDriver->loadColumn()JROOT/administrator/components/com_rsfirewall/helpers/config.php:56
    10RSFirewallConfig->load()JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
    9RSFirewallConfig->__construct()JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
    8RSFirewallConfig::getInstance()JROOT/plugins/system/rsfirewall/rsfirewall.php:41
    7plgSystemRsfirewall->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.25 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 5.447 MB Rows returned: 0
    SELECT `file`
    
      FROM dfyr2_rsfirewall_hashes
      WHERE `type`='protect'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_rsfirewall_hashesALLNULLNO INDEX KEY COULD BE USEDNULLNULL187Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.06 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    11JDatabaseDriver->loadColumn()JROOT/administrator/components/com_rsfirewall/helpers/config.php:63
    10RSFirewallConfig->load()JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
    9RSFirewallConfig->__construct()JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
    8RSFirewallConfig::getInstance()JROOT/plugins/system/rsfirewall/rsfirewall.php:41
    7plgSystemRsfirewall->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.31 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 5.451 MB Rows returned: 67
    SELECT *
    
      FROM dfyr2_rsfirewall_configuration
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_rsfirewall_configurationALLNULLNO INDEX KEY COULD BE USEDNULLNULL67
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.07 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_rsfirewall/helpers/config.php:71
    10RSFirewallConfig->load()JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
    9RSFirewallConfig->__construct()JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
    8RSFirewallConfig::getInstance()JROOT/plugins/system/rsfirewall/rsfirewall.php:41
    7plgSystemRsfirewall->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.66 ms After last query: 2.85 ms Query memory: 0.025 MB Memory before query: 5.910 MB Rows returned: 10
    SHOW FULL COLUMNS 
      FROM `dfyr2_rsfirewall_logs`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `dfyr2_rsfirewall_logs`
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    closing tables0.00 ms
    checking permissions0.00 ms
    Opening tables0.28 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Filling schema table0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    checking permissions0.05 ms
    closing tables0.00 ms
    checking permissions0.00 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Removing tmp table0.07 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    14JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:261
    13Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:180
    12Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_rsfirewall/tables/logs.php:38
    11RsfirewallTableLogs->__construct()JROOT/libraries/src/Table/Table.php:328
    10Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_rsfirewall/helpers/log.php:31
    9RSFirewallLogger->__construct()JROOT/administrator/components/com_rsfirewall/helpers/log.php:84
    8RSFirewallLogger::getInstance()JROOT/plugins/system/rsfirewall/rsfirewall.php:63
    7plgSystemRsfirewall->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.45 ms After last query: 22.49 ms Query memory: 0.023 MB Memory before query: 8.773 MB Rows returned: 37
    SELECT *
    
      FROM dfyr2_rsform_config
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_rsform_configALLNULLNO INDEX KEY COULD BE USEDNULLNULL37
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.05 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_rsform/helpers/config.php:52
    11RSFormProConfig->load()JROOT/administrator/components/com_rsform/helpers/config.php:19
    10RSFormProConfig->__construct()JROOT/administrator/components/com_rsform/helpers/config.php:104
    9RSFormProConfig::getInstance()JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:34
    8plgSystemRsformdeletesubmissions->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 2.11 ms After last query: 2.54 ms Query memory: 0.298 MB Memory before query: 9.072 MB Rows returned: 225
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM dfyr2_menu AS m
      LEFT JOIN dfyr2_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_client_id_parent_id_alias_languageNO INDEX KEY COULD BE USEDNULLNULL327Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4profitw_jdata.m.component_id1Using where
    Profile
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index1.62 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:533
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1141
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.57 ms After last query: 8.58 ms Query memory: 0.021 MB Memory before query: 10.548 MB Rows returned: 4
    SELECT *
    
      FROM dfyr2_rsfirewall_hashes
      WHERE (`type`='3.10.12' OR `type`='protect')
      AND (`flag`!='C' OR `flag` IS NULL)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_rsfirewall_hashesALLNULLNO INDEX KEY COULD BE USEDNULLNULL187Using where
    Profile
    StatusDuration
    Starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.08 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.07 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    9JDatabaseDriver->loadObjectList()JROOT/plugins/system/rsfirewall/rsfirewall.php:1107
    8plgSystemRsfirewall->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.30 ms After last query: 0.59 ms Query memory: 0.021 MB Memory before query: 10.584 MB Rows returned: 0
    SELECT *
    
      FROM dfyr2_rsfirewall_snapshots
      WHERE `type`='protect'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:49
    9RSFirewallSnapshot::get()JROOT/plugins/system/rsfirewall/rsfirewall.php:1130
    8plgSystemRsfirewall->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.25 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 10.589 MB Rows returned: 0
    SELECT `ip`,`reason`
    
      FROM dfyr2_rsfirewall_lists
      WHERE (`ip`='216.73.216.22' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
      AND `type`='1'
      AND `published`='1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/rsfirewall/rsfirewall.php:172
    10plgSystemRsfirewall->isListed()JROOT/plugins/system/rsfirewall/rsfirewall.php:151
    9plgSystemRsfirewall->isWhitelisted()JROOT/plugins/system/rsfirewall/rsfirewall.php:1166
    8plgSystemRsfirewall->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.26 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 10.595 MB Rows returned: 0
    SELECT `ip`,`reason`
    
      FROM dfyr2_rsfirewall_lists
      WHERE (`ip`='216.73.216.22' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
      AND `type`='0'
      AND `published`='1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/rsfirewall/rsfirewall.php:172
    10plgSystemRsfirewall->isListed()JROOT/plugins/system/rsfirewall/rsfirewall.php:141
    9plgSystemRsfirewall->isBlacklisted()JROOT/plugins/system/rsfirewall/rsfirewall.php:1170
    8plgSystemRsfirewall->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.26 ms After last query: 0.47 ms Query memory: 0.021 MB Memory before query: 10.701 MB Rows returned: 3
    SELECT *
    
      FROM dfyr2_rsfirewall_exceptions
      WHERE `published`='1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_rsfirewall_exceptionsALLNULLNO INDEX KEY COULD BE USEDNULLNULL3Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/rsfirewall/rsfirewall.php:758
    9plgSystemRsfirewall->isException()JROOT/plugins/system/rsfirewall/rsfirewall.php:1307
    8plgSystemRsfirewall->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.41 ms After last query: 1.34 ms Query memory: 0.023 MB Memory before query: 10.826 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `dfyr2_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.08 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.04 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.34 ms After last query: 0.17 ms Query memory: 0.005 MB Memory before query: 10.817 MB
    UPDATE `dfyr2_extensions`
    
      SET `params` = '{\"mediaversion\":\"65bb40a969720f59258353bc8bdde0d1\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `dfyr2_extensions` SET `params` = '{\"mediaversion\":\"65bb40a969720f59258353bc8bdde0d1\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.03 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init for update0.07 ms
    Updating0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.33 ms After last query: 1.56 ms Query memory: 0.019 MB Memory before query: 11.001 MB Rows returned: 1
    SELECT *
    
      FROM dfyr2_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.05 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.52 ms After last query: 0.22 ms Query memory: 0.113 MB Memory before query: 11.015 MB Rows returned: 9
    SELECT id, home, template, s.params
    
      FROM dfyr2_template_styles as s
      LEFT JOIN dfyr2_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionextension82const5Using index condition; Using where
    1SIMPLEsref|filteridx_template,idx_client_id,idx_client_id_homeidx_template|idx_client_id202|1profitw_jdata.e.element1 (82%)Using index condition; Using where; Using rowid filter
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.16 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.76 ms After last query: 5.66 ms Query memory: 0.029 MB Memory before query: 11.786 MB Rows returned: 44
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dfyr2_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_geekchatbot','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_rsform','com_search','com_sfg','com_sppagebuilder','com_sptransfer','com_tags','com_templates','com_users','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_assetsrangeidx_asset_nameidx_asset_name202NULL45Using index condition
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.01 ms
    Statistics0.10 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.30 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    19Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:115
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:45
    13ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 6.97 ms After last query: 1.15 ms Query memory: 0.228 MB Memory before query: 11.936 MB Rows returned: 9
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
      FROM dfyr2_content AS a
      INNER JOIN dfyr2_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN dfyr2_categories AS c
      ON c.id = a.catid
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dfyr2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dfyr2_categories as parent
      ON parent.id = c.parent_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-10 14:14:09')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-10 14:14:09')
      ORDER BY a.featured DESC, fp.ordering,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 95, 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL262Using temporary; Using filesort
    1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4profitw_jdata.fp.content_id1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4profitw_jdata.a.catid1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4profitw_jdata.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4profitw_jdata.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4profitw_jdata.c.parent_id1Using where
    Profile
    StatusDuration
    Starting0.15 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.08 ms
    Optimizing0.04 ms
    Statistics0.10 ms
    Preparing0.03 ms
    Creating tmp table0.10 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data4.52 ms
    Creating sort index1.54 ms
    Removing tmp table0.13 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    14Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 1.41 ms After last query: 1.73 ms Query memory: 0.023 MB Memory before query: 12.285 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM dfyr2_content AS a
      INNER JOIN dfyr2_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN dfyr2_categories AS c
      ON c.id = a.catid
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dfyr2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dfyr2_categories as parent
      ON parent.id = c.parent_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-10 14:14:09')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-10 14:14:09')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpindexPRIMARYPRIMARY4NULL262Using index
    1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4profitw_jdata.fp.content_id1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4profitw_jdata.a.catid1Using where
    Profile
    StatusDuration
    Starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.04 ms
    Optimizing0.05 ms
    Statistics0.10 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.88 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    13Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    12Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:57
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.96 ms After last query: 12.73 ms Query memory: 0.027 MB Memory before query: 13.716 MB Rows returned: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `dfyr2_categories` AS `s`
      INNER JOIN `dfyr2_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 918
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL47Using where; Using filesort
    Profile
    StatusDuration
    Starting0.19 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.08 ms
    Optimizing0.04 ms
    Statistics0.15 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.16 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 1.29 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 13.765 MB Rows returned: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM dfyr2_fields AS a
      LEFT JOIN `dfyr2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN dfyr2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN dfyr2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN dfyr2_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `dfyr2_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (918,0,923))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28profitw_jdata.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4profitw_jdata.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4profitw_jdata.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4profitw_jdata.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4profitw_jdata.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4profitw_jdata.a.id1Using where; Using index; Distinct
    Profile
    StatusDuration
    Starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.03 ms
    table lock0.01 ms
    init0.09 ms
    Optimizing0.04 ms
    Statistics0.13 ms
    Preparing0.05 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.38 ms
    Creating sort index0.04 ms
    Removing tmp table0.08 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.48 ms After last query: 2.53 ms Query memory: 0.023 MB Memory before query: 14.062 MB Rows returned: 1
    Duplicate queries: #29  #30  #33  #34  #35  #36  #37  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.04 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.64 ms After last query: 1.53 ms Query memory: 0.027 MB Memory before query: 14.772 MB Rows returned: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `dfyr2_categories` AS `s`
      INNER JOIN `dfyr2_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 909
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL10Using index condition; Using where
    Profile
    StatusDuration
    Starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.10 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.07 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.04 ms
    closing tables0.01 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 1.17 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 14.778 MB Rows returned: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM dfyr2_fields AS a
      LEFT JOIN `dfyr2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN dfyr2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN dfyr2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN dfyr2_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `dfyr2_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (909,0,923))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28profitw_jdata.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4profitw_jdata.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4profitw_jdata.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4profitw_jdata.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4profitw_jdata.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4profitw_jdata.a.id1Using where; Using index; Distinct
    Profile
    StatusDuration
    Starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.10 ms
    Preparing0.04 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.42 ms
    Creating sort index0.03 ms
    Removing tmp table0.07 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.27 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 14.787 MB Rows returned: 1
    Duplicate queries: #26  #30  #33  #34  #35  #36  #37  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.27 ms After last query: 0.90 ms Query memory: 0.023 MB Memory before query: 14.795 MB Rows returned: 1
    Duplicate queries: #26  #29  #33  #34  #35  #36  #37  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.04 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.47 ms After last query: 0.68 ms Query memory: 0.027 MB Memory before query: 14.813 MB Rows returned: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `dfyr2_categories` AS `s`
      INNER JOIN `dfyr2_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 902
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL9Using index condition; Using where
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.04 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.94 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 14.819 MB Rows returned: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM dfyr2_fields AS a
      LEFT JOIN `dfyr2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN dfyr2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN dfyr2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN dfyr2_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `dfyr2_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (902,0,923))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28profitw_jdata.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4profitw_jdata.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4profitw_jdata.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4profitw_jdata.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4profitw_jdata.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4profitw_jdata.a.id1Using where; Using index; Distinct
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.09 ms
    Preparing0.03 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.31 ms
    Creating sort index0.03 ms
    Removing tmp table0.08 ms
    Creating sort index0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.27 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 14.834 MB Rows returned: 1
    Duplicate queries: #26  #29  #30  #34  #35  #36  #37  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 0.26 ms After last query: 2.12 ms Query memory: 0.023 MB Memory before query: 14.879 MB Rows returned: 1
    Duplicate queries: #26  #29  #30  #33  #35  #36  #37  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  35. Query Time: 0.36 ms After last query: 2.47 ms Query memory: 0.023 MB Memory before query: 14.858 MB Rows returned: 1
    Duplicate queries: #26  #29  #30  #33  #34  #36  #37  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  36. Query Time: 0.31 ms After last query: 0.66 ms Query memory: 0.023 MB Memory before query: 14.866 MB Rows returned: 1
    Duplicate queries: #26  #29  #30  #33  #34  #35  #37  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  37. Query Time: 0.30 ms After last query: 0.48 ms Query memory: 0.023 MB Memory before query: 14.874 MB Rows returned: 1
    Duplicate queries: #26  #29  #30  #33  #34  #35  #36  #38
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  38. Query Time: 0.26 ms After last query: 0.98 ms Query memory: 0.023 MB Memory before query: 14.882 MB Rows returned: 1
    Duplicate queries: #26  #29  #30  #33  #34  #35  #36  #37
    SELECT enabled 
      FROM dfyr2_extensions
      WHERE element = 'com_sppagebuilder'
      AND type = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96
    14PlgContentSppagebuilder->isSppagebuilderEnabled()JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80
    13PlgContentSppagebuilder->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  39. Query Time: 1.43 ms After last query: 16.83 ms Query memory: 0.041 MB Memory before query: 15.825 MB Rows returned: 17
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM dfyr2_modules AS m
      LEFT JOIN dfyr2_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN dfyr2_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-08-10 14:14:09')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-08-10 14:14:09')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 754 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const51Using index condition; Using where; Using filesort
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403profitw_jdata.m.module,const1Using index condition; Using where
    1SIMPLEmmrefPRIMARYPRIMARY4profitw_jdata.m.id5Using where; Using index
    Profile
    StatusDuration
    Starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.05 ms
    Statistics0.12 ms
    Preparing0.05 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.70 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    12Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    11Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    10Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    9Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/ja_simpli/helper.php:100
    8SimpliHelper->init()JROOT/templates/ja_simpli/index.php:10
    7require JROOT/templates/ja_simpli/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  40. Query Time: 0.78 ms After last query: 19.11 ms Query memory: 0.029 MB Memory before query: 17.173 MB Rows returned: 177
    SHOW TABLES
    Explain
    EXPLAIN not possible on query: SHOW TABLES
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.00 ms
    Filling schema table0.01 ms
    checking permissions0.33 ms
    Executing0.00 ms
    Sending data0.06 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Removing tmp table0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    15JDatabaseDriver->loadColumn()JROOT/libraries/joomla/database/driver/mysqli.php:505
    14JDatabaseDriverMysqli->getTableList()JROOT/administrator/components/com_acymailing/compat/joomla.php:552
    13acymailing_getTableList()JROOT/administrator/components/com_acymailing/classes/cpanel.php:18
    12cpanelClass->load()JROOT/administrator/components/com_acymailing/helpers/helper.php:523
    11acymailing_config()JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    10include_once JROOT/administrator/components/com_acymailing/compat/joomla.phpJROOT/administrator/components/com_acymailing/helpers/helper.php:25
    9include_once JROOT/administrator/components/com_acymailing/helpers/helper.phpJROOT/plugins/system/regacymailing/regacymailing.php:22
    8plgSystemRegacymailing->initAcy()JROOT/plugins/system/regacymailing/regacymailing.php:146
    7plgSystemRegacymailing->onAfterRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1118
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  41. Query Time: 0.34 ms After last query: 0.08 ms Query memory: 0.035 MB Memory before query: 17.201 MB Rows returned: 230
    SELECT * 
      FROM dfyr2_acymailing_config
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdfyr2_acymailing_configALLNULLNO INDEX KEY COULD BE USEDNULLNULL230
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.10 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acymailing/compat/joomla.php:478
    13acymailing_loadObjectList()JROOT/administrator/components/com_acymailing/classes/cpanel.php:23
    12cpanelClass->load()JROOT/administrator/components/com_acymailing/helpers/helper.php:523
    11acymailing_config()JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    10include_once JROOT/administrator/components/com_acymailing/compat/joomla.phpJROOT/administrator/components/com_acymailing/helpers/helper.php:25
    9include_once JROOT/administrator/components/com_acymailing/helpers/helper.phpJROOT/plugins/system/regacymailing/regacymailing.php:22
    8plgSystemRegacymailing->initAcy()JROOT/plugins/system/regacymailing/regacymailing.php:146
    7plgSystemRegacymailing->onAfterRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1118
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 9 × SELECT enabled 
      FROM dfyr2_extensions
  2. 3 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM dfyr2_fields AS a
      LEFT JOIN `dfyr2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN dfyr2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN dfyr2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN dfyr2_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `dfyr2_fields_categories` AS fc
      ON fc.field_id = a.id
  3. 3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `dfyr2_categories` AS `s`
      INNER JOIN `dfyr2_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  4. 2 × SELECT `ip`,`reason` 
      FROM dfyr2_rsfirewall_lists
  5. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `dfyr2_extensions`
  6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM dfyr2_modules AS m
      LEFT JOIN dfyr2_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN dfyr2_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  7. 1 × SELECT COUNT(*) 
      FROM dfyr2_content AS a
      INNER JOIN dfyr2_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN dfyr2_categories AS c
      ON c.id = a.catid
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dfyr2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dfyr2_categories as parent
      ON parent.id = c.parent_id
  8. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
      FROM dfyr2_content AS a
      INNER JOIN dfyr2_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN dfyr2_categories AS c
      ON c.id = a.catid
      LEFT JOIN dfyr2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dfyr2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dfyr2_categories as parent
      ON parent.id = c.parent_id
  9. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `dfyr2_assets`
  10. 1 × SELECT id, home, template, s.params 
      FROM dfyr2_template_styles as s
      LEFT JOIN dfyr2_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  11. 1 × SELECT * 
      FROM dfyr2_languages
  12. 1 × SELECT * 
      FROM dfyr2_rsfirewall_exceptions
  13. 1 × SELECT `session_id` 
      FROM `dfyr2_session`
  14. 1 × SELECT * 
      FROM dfyr2_rsfirewall_snapshots
  15. 1 × SELECT * 
      FROM dfyr2_rsfirewall_hashes
  16. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM dfyr2_menu AS m
      LEFT JOIN dfyr2_extensions AS e
      ON m.component_id = e.extension_id
  17. 1 × SELECT * 
      FROM dfyr2_rsform_confi
  18. 1 × SELECT * 
      FROM dfyr2_rsfirewall_configuratio
  19. 1 × SELECT `file` 
      FROM dfyr2_rsfirewall_hashes
  20. 1 × SELECT `path` 
      FROM dfyr2_rsfirewall_ignored
  21. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM dfyr2_extensions
  22. 1 × SELECT b.id 
      FROM dfyr2_usergroups AS a
      LEFT JOIN dfyr2_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  23. 1 × SELECT id, rules 
      FROM `dfyr2_viewlevels
  24. 1 × SELECT * 
      FROM dfyr2_acymailing_confi
OTHER Tables:
  1. 1 × SHOW FULL COLUMNS 
      FROM `dfyr2_rsfirewall_logs
  2. 1 × UPDATE `dfyr2_extensions` 
      SET `params` = '{\"mediaversion\":\"65bb40a969720f59258353bc8bdde0d1\"}'
  3. 1 × SHOW TABLE