Prices

Subscribing is easy; just three simple steps to follow

Pay

Start Using

The Booking Form - annual subscription

Running autotoc object(Joomla\CMS\Version)#1146 (0) { } object(stdClass)#1117 (1) { ["text"]=> string(1180) "The Booking Form - annual subscription.

No upfront cost or installation fees.
Integrate the booking form on any website and even Facebook page.
No commission on bookings.
Unlimited Cars.
Unlimited Drivers.
Unlimited Users.
Unlimited Technical support.
Unlimited Updates.
Multiple online Payment methods.
Multiple languages.
Android booking app.
Reviews and Rating website.
FREE Joomla 3.x Responsive website from our demos.
No contract, Cancel any time.
Pay 10 months use for 12.

" }

The Booking Form - annual subscription.

No upfront cost or installation fees.
Integrate the booking form on any website and even Facebook page.
No commission on bookings.
Unlimited Cars.
Unlimited Drivers.
Unlimited Users.
Unlimited Technical support.
Unlimited Updates.
Multiple online Payment methods.
Multiple languages.
Android booking app.
Reviews and Rating website.
FREE Joomla 3.x Responsive website from our demos.
No contract, Cancel any time.
Pay 10 months use for 12.

Javascript is not enabledPlease enable Javascript on your browser and disable any Javascript blockers (e.g. NoScript) for this page to work optimally. Javascript is required to notify you of any problems with the subscription information and speed up the checkout. Thank you for your understanding.

Information for your new account on our site

* Name of representative Name of representative is required

* Email Invalid email address

* Email (repeat it) Emails don't match

Password * Password can't be empty

Retype Password * Passwords don't match

* I agree to the Terms of Service

Company Name

Website URL

How did you find us?

Privacy policy

Website Privacy Notice

1. Introduction

This privacy notice provides you with details of how we collect and process your personal data through your use of our site https://booking.drivenot.com

By providing us with your data, you warrant to us that you are over 13 years of age.

Kanev Web Development Limited also trading as booking.drivenot.com / DriveNot / Taxi Booking Pro and kanev.com is the data controller and we are responsible for your personal data (referred to as “we”, “us” or “our” in this privacy notice).

Contact Details

Our full details are:

Full name of legal entity: Kanev Web Development Limited

Email address: privacy@kanev.com

Postal address: C/o Sagacity, U5 20 High Street, London, England, E15 2PP

It is very important that the information we hold about you is accurate and up to date. Please let us know if at any time your personal information changes by emailing us at privacy@kanev.com

2. What data we collect about you, for what purpose and what ground we process it.

Personal data means any information capable of identifying an individual. It does not include anonymised data.

We may process the following categories of personal data about you:

Communication Data that includes any communication that you send to us whether that be through the contact form on our website, through email, text, social media messaging, social media posting or any other communication that you send us. We process this data for the purposes of communicating with you, for record keeping and for the establishment, pursuance or defence of legal claims. Our lawful ground for this processing is our legitimate interests which in this case are to reply to communications sent to us, to keep records and to establish, pursue or defend legal claims.

Customer Data that includes data relating to any purchases of goods and/or services such as your name, title, address, delivery address, email address, phone number, contact details, purchase details. We process this data to supply the goods and/or services you have purchased and to keep records of such transactions. Our lawful ground for this processing is the performance of a contract between you and us and/or taking steps at your request to enter into such a contract. We do not keep any credit/debit card details or billing address as we use reputable third parties to process your payments such as PayPal and Stripe (please refer to their own Privacy Policy).

User Data that includes data about how you use our website and any online services together with any data that you post for publication on our website or through other online services. We process this data to operate our website and ensure relevant content is provided to you, to ensure the security of our website, to maintain back-ups of our website and/or databases and to enable publication and administration of our website, other online services and business. Our lawful ground for this processing is our legitimate interests which in this case are to enable us to properly administer our website and our business.

Technical Data that includes data about your use of our website and online services such as your IP address, your login data, details about your browser, length of visit to pages on our website, page views and navigation paths, details about the number of times you use our website, time zone settings and other technology on the devices you use to access our website as well as email opens, clicks, geolocation, history etc. The source of this data is from our analytics tracking systems. We process this data to analyse your use of our website and other online services, to administer and protect our business and website, to deliver relevant website content and advertisements to you and to understand the effectiveness of our advertising. Our lawful ground for this processing is our legitimate interests which in this case are to enable us to properly administer our website and our business and to grow our business and to decide our marketing strategy.

Marketing Data that includes data about your preferences in receiving marketing from us and our partner third parties and your communication preferences. We process this data to enable you to partake in our promotions such as discounts, competitions, prize draws and free giveaways, to deliver relevant website content and advertisements to you and measure or understand the effectiveness of this advertising. Our lawful ground for this processing is our legitimate interests which in this case are to study how customers use our products/services, to develop them, to grow our business and to decide our marketing strategy.

We may use Customer Data, User Data, Technical Data and Marketing Data to deliver relevant website content and advertisements to you (including Facebook and Google adverts or other display advertisements) and to measure or understand the effectiveness of the advertising we serve you. Our lawful ground for this processing is legitimate interests which are to grow our business. We may also use such data to send other marketing communications to you. Our lawful ground for this processing is either consent or legitimate interests (namely to grow our business).

Sensitive Data

We do not collect any Sensitive Data about you. Sensitive data refers to data that includes details about your race or ethnicity, religious or philosophical beliefs, sex life, sexual orientation, political opinions, trade union membership, information about your health and genetic and biometric data. We do not collect any information about criminal convictions and offences.

Where we are required to collect personal data by law, or under the terms of the contract between us and you do not provide us with that data when requested, we may not be able to perform the contract (for example, to deliver goods or services to you). If you don’t provide us with the requested data, we may have to cancel a product or service you have ordered but if we do, we will notify you at the time.

We will only use your personal data for a purpose it was collected for or a reasonably compatible purpose if necessary. For more information on this please email us at privacy@kanev.com. In case we need to use your details for an unrelated new purpose we will let you know and explain the legal grounds for processing.

We may process your personal data without your knowledge or consent where this is required or permitted by law.

We do not carry out automated decision making or any type of automated profiling.

3. How we collect your personal data

We may collect data about you by you providing the data directly to us (for example by filling in forms on our site or by sending us emails). We may automatically collect certain data from you as you use our website by using cookies and similar technologies. Please see our cookie policy for more details about this here.

We may receive data from third parties such as analytics providers such as Google based outside the EU, advertising networks such as Facebook, based outside the EU, search information providers such as Google based outside the EU, providers of technical, payment and delivery services, such as data brokers or aggregators.

We may also receive data from publicly available sources such as Companies House and the Electoral Register based inside the EU.

You have provided us with your data at one of our talks, seminars, workshops, webinars or Facebook group. You may have also provided us with your data through a contact form of a software directory/listing or booked an appointment via our online scheduling system.

4. Marketing Communications

Our lawful ground of processing your personal data to send you marketing communications is either your consent or our legitimate interests (namely to grow our business).

Under the Privacy and Electronic Communications Regulations, we may send you marketing communications from us if (i) you made a purchase or asked for information from us about our goods or services or (ii) you agreed to receive marketing communications and in each case you have not opted out of receiving such communications since. Under these regulations, if you are a limited company, we may send you marketing emails without your consent. However, you can still opt out of receiving marketing emails from us at any time.

Before we share your personal data with any third party for their own marketing purposes we will get your express consent.

You can ask us or third parties to stop sending you marketing messages at any time by following the opt-out links on any marketing message sent to you OR by emailing us at privacy@kanev.com at any time.

If you opt out of receiving marketing communications this opt-out does not apply to personal data provided as a result of other transactions, such as purchases, warranty registrations etc.

5. Disclosures of Your Personal Data

We may have to share your personal data with the parties set out below:

Service providers who provide IT and system administration services.
Professional advisers including lawyers, bankers, auditors and insurers
Government bodies that require us to report processing activities.
Third parties to whom we sell, transfer, or merge parts of our business or our assets.

We require all third parties to whom we transfer your data to respect the security of your personal data and to treat it in accordance with the law. We only allow such third parties to process your personal data for specified purposes and in accordance with our instructions.

6. International Transfers

Countries outside of the European Economic Area (EEA) do not always offer the same levels of protection to your personal data, so European law has prohibited transfers of personal data outside of the EEA unless the transfer meets certain criteria.

Many of our third parties service providers are based outside the European Economic Area (EEA) so their processing of your personal data will involve a transfer of data outside the EEA.

Whenever we transfer your personal data out of the EEA, we do our best to ensure a similar degree of security of data by ensuring at least one of the following safeguards is in place:

We will only transfer your personal data to countries that the European Commission have approved as providing an adequate level of protection for personal data by; or

Where we use certain service providers, we may use specific contracts or codes of conduct or certification mechanisms approved by the European Commission which give personal data the same protection it has in Europe; or

If we use US-based providers that are part of EU-US Privacy Shield, we may transfer data to them, as they have equivalent safeguards in place.

If none of the above safeguards is available, we may request your explicit consent to the specific transfer. You will have the right to withdraw this consent at any time.

7. Data Security

We have put in place security measures to prevent your personal data from being accidentally lost, used, altered, disclosed, or accessed without authorisation. We also allow access to your personal data only to those employees and partners who have a business need to know such data. They will only process your personal data on our instructions and they must keep it confidential.

We have procedures in place to deal with any suspected personal data breach and will notify you and any applicable regulator of a breach if we are legally required to.

8. Data Retention

We will only retain your personal data for as long as necessary to fulfil the purposes we collected it for, including for the purposes of satisfying any legal, accounting, or reporting requirements.

When deciding what the correct time is to keep the data for we look at its amount, nature and sensitivity, the potential risk of harm from unauthorised use or disclosure, the processing purposes, if these can be achieved by other means and legal requirements.

For tax purposes, the law requires us to keep basic information about our customers (including Contact, Identity, Financial and Transaction Data) for six years after they stop being customers.

In some circumstances, we may anonymize your personal data for research or statistical purposes in which case we may use this information indefinitely without further notice to you.

9. Your Legal Rights

Under data protection laws you have rights in relation to your personal data that include the right to request access, correction, erasure, restriction, transfer, to object to processing, to the portability of data and (where the lawful ground of processing is consent) to withdraw consent.

You can see more about these rights at:

https://ico.org.uk/for-organisations/guide-to-the-general-data-protection-regulation-gdpr/individual-rights/

If you wish to exercise any of the rights set out above, please email us at privacy@kanev.com

You will not have to pay a fee to access your personal data (or to exercise any of the other rights). However, we may charge a reasonable fee if your request is clearly unfounded, repetitive or excessive or refuse to comply with your request in these circumstances.

We may need to request specific information from you to help us confirm your identity and ensure your right to access your personal data (or to exercise any of your other rights). This is a security measure to ensure that personal data is not disclosed to any person who has no right to receive it. We may also contact you to ask you for further information in relation to your request to speed up our response.

We try to respond to all legitimate requests within one month. Occasionally it may take us longer than a month if your request is particularly complex or you have made a number of requests. In this case, we will notify you.

If you are not happy with any aspect of how we collect and use your data, you have the right to complain to the Information Commissioner’s Office (ICO), the UK supervisory authority for data protection issues (www.ico.org.uk). We should be grateful if you would contact us first if you do have a complaint so that we can try to resolve it for you.

10. Third-Party Links

This website may include links to third-party websites, plug-ins and applications. Clicking on those links or enabling those connections may allow third parties to collect or share data about you. We do not control these third-party websites and are not responsible for their privacy statements. When you leave our website, we encourage you to read the privacy notice of every website you visit.

11. Cookies

You can set your browser to refuse all or some browser cookies or to alert you when websites set or access cookies. If you disable or refuse cookies, please note that some parts of this website may become inaccessible or not function properly. For more information about the cookies we use, please see here.

* Address This field is required

Address (continued from above)

Language

* City This field is required

* State This field is required

* ZIP / Postal Code This field is required

* Country This field is required

Business invoicing preferences

Yes

* Register as a business

* Business name

* Business activity This field is required

EU* VAT Number (for EU customers) VAT Nr is not VIES registered

Summary

$Regular price

$Discount

$Taxes

$Total charge

Coupon code

Please type the characters displayed below:

(case-sensitive)

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714456676,
                "last": 1714456676,
                "now": 1714456676
            },
            "client": {
                "forwarded": "3.16.29.209"
            },
            "token": "pZme8NqqeBYY9w9BP0mQZIs7DPlV1fu1"
        },
        "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
        },
        "akeeba_subs_security_code": "8c8wd"
    },
    "__com_akeebasubs": {
        "validation_cache_data": "{\"state\":{\"\\u0000*\\u0000_errors\":[],\"limit\":\"20\",\"limitstart\":0,\"paymentmethod\":\"\",\"username\":\"\",\"password\":\"\",\"password2\":\"\",\"name\":\"\",\"email\":\"\",\"email2\":\"\",\"address1\":\"\",\"address2\":\"\",\"country\":\"XX\",\"state\":\"\",\"city\":\"\",\"zip\":\"\",\"isbusiness\":\"\",\"businessname\":\"\",\"vatnumber\":\"\",\"coupon\":\"\",\"occupation\":\"\",\"custom\":[],\"subcustom\":[],\"layout\":\"default\",\"format\":\"html\",\"hidemainmenu\":true}}",
        "firstrun": false
    }
}

Profile Information

Time

Memory

Time: 22.40 ms / 22.40 ms Memory: 1.505 MB / 1.84 MB Application: afterLoad

Time: 211.75 ms / 234.16 ms Memory: 6.732 MB / 8.58 MB Application: afterInitialise

Time: 36.46 ms / 270.62 ms Memory: 1.532 MB / 10.11 MB Application: afterRoute

Time: 13.68 ms / 284.30 ms Memory: 0.208 MB / 10.32 MB Application: beforeRenderComponent com_akeebasubs

Time: 57.16 ms / 341.46 ms Memory: 1.877 MB / 12.19 MB Application: Before Access::preloadComponents (all components)

Time: 5.24 ms / 346.70 ms Memory: 0.066 MB / 12.26 MB Application: After Access::preloadComponents (all components)

Time: 0.05 ms / 346.75 ms Memory: 0.000 MB / 12.26 MB Application: Before Access::getAssetRules (id:59 name:com_akeebasubs)

Time: 0.76 ms / 347.51 ms Memory: 0.025 MB / 12.29 MB Application: After Access::getAssetRules (id:59 name:com_akeebasubs)

Time: 288.03 ms / 635.54 ms Memory: 6.265 MB / 18.55 MB Application: afterRenderComponent com_akeebasubs

Time: 8.65 ms / 644.19 ms Memory: 0.147 MB / 18.70 MB Application: afterDispatch

Time: 2.60 ms / 646.78 ms Memory: 0.061 MB / 18.76 MB Application: beforeRenderModule mod_custom (Company info)

Time: 0.96 ms / 647.75 ms Memory: 0.026 MB / 18.78 MB Application: afterRenderModule mod_custom (Company info)

Time: 0.06 ms / 647.80 ms Memory: -0.001 MB / 18.78 MB Application: beforeRenderModule mod_menu (Subscriptions)

Time: 6.24 ms / 654.04 ms Memory: 0.215 MB / 19.00 MB Application: afterRenderModule mod_menu (Subscriptions)

Time: 0.05 ms / 654.09 ms Memory: -0.005 MB / 18.99 MB Application: beforeRenderModule mod_custom (Facebook audience)

Time: 0.21 ms / 654.30 ms Memory: 0.003 MB / 19.00 MB Application: afterRenderModule mod_custom (Facebook audience)

Time: 0.02 ms / 654.33 ms Memory: 0.000 MB / 19.00 MB Application: beforeRenderModule mod_custom (Google Remarketing)

Time: 0.25 ms / 654.58 ms Memory: 0.004 MB / 19.00 MB Application: afterRenderModule mod_custom (Google Remarketing)

Time: 0.07 ms / 654.64 ms Memory: 0.002 MB / 19.00 MB Application: beforeRenderModule mod_addthis_smartlayers (AddThis Smart Layers)

Time: 1.62 ms / 656.26 ms Memory: 0.025 MB / 19.03 MB Application: afterRenderModule mod_addthis_smartlayers (AddThis Smart Layers)

Time: 0.11 ms / 656.37 ms Memory: -0.006 MB / 19.02 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 3.78 ms / 660.15 ms Memory: 0.042 MB / 19.06 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 21.53 ms / 681.68 ms Memory: 0.368 MB / 19.43 MB Application: afterRender

Database queries total: 180.12 ms

Memory Usage

Database Queries

70 Queries Logged 180.12 ms

28 duplicate found!

2 duplicates: #17 #18

4 duplicates: #25 #36 #51 #64

6 duplicates: #28 #29 #30 #31 #32 #47

2 duplicates: #33 #34

6 duplicates: #37 #38 #43 #45 #57 #62

3 duplicates: #39 #44 #46

2 duplicates: #58 #63

3 duplicates: #59 #60 #61

Query Time: 3.02 ms Query memory: 0.022 MB Memory before query: 3.346 MB Rows returned: 0

SELECT `data`

  FROM `zlaw_session`

  WHERE `session_id` = X'6964676d6d676661646d6f71353339353431696b303766336739'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_session	const	PRIMARY	PRIMARY	194	const	1

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	2.06 ms
Preparing	0.03 ms
Executing	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.86 ms After last query: 2.09 ms Query memory: 0.020 MB Memory before query: 3.435 MB Rows returned: 0

SELECT `session_id`

  FROM `zlaw_session`

  WHERE `session_id` = X'6964676d6d676661646d6f71353339353431696b303766336739' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.42 ms After last query: 0.20 ms Query memory: 0.003 MB Memory before query: 3.439 MB

INSERT INTO `zlaw_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6964676d6d676661646d6f71353339353431696b303766336739', 1, 1714456676, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `zlaw_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6964676d6d676661646d6f71353339353431696b303766336739', 1, 1714456676, 0, '', 0)

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init for update	0.03 ms
Update	2.50 ms
Waiting for query cache lock	0.02 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	2.37 ms
Closing tables	0.04 ms
Unlocking tables	0.09 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 12.60 ms After last query: 3.98 ms Query memory: 0.178 MB Memory before query: 3.611 MB Rows returned: 50

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `zlaw_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	extension	extension	82	const	56	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.15 ms
Optimizing	0.05 ms
Statistics	1.73 ms
Preparing	0.10 ms
Executing	0.02 ms
Sending data	9.85 ms
End of update loop	0.06 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.37 ms After last query: 3.24 ms Query memory: 0.020 MB Memory before query: 3.921 MB Rows returned: 6

SELECT id, rules

  FROM `zlaw_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	1.36 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	1.38 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.64 ms After last query: 0.25 ms Query memory: 0.020 MB Memory before query: 3.931 MB Rows returned: 2

SELECT b.id

  FROM zlaw_usergroups AS a

  LEFT JOIN zlaw_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	2.01 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.06 ms After last query: 1.00 ms Query memory: 0.023 MB Memory before query: 3.995 MB Rows returned: 162

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM zlaw_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	extension	extension	82	const	291	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.03 ms
Statistics	0.59 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	4.68 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.78 ms After last query: 18.22 ms Query memory: 0.021 MB Memory before query: 5.189 MB Rows returned: 1

SELECT `value`

  FROM `zlaw_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profile

Status	Duration
Starting	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	1.92 ms
Preparing	0.03 ms
Unlocking tables	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/models/storage.php:99
10	AdmintoolsModelStorage->load()	JROOT/administrator/components/com_admintools/models/storage.php:49
9	AdmintoolsModelStorage->getValue()	JROOT/plugins/system/admintools/admintools/main.php:289
8	plgSystemAdmintools->workaroundIP()	JROOT/plugins/system/admintools/admintools/main.php:81
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.62 ms After last query: 2.95 ms Query memory: 0.020 MB Memory before query: 5.332 MB Rows returned: 0

SELECT *

  FROM `zlaw_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_admintools_wafexceptions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	1.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:526
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:447
8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:90
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.81 ms After last query: 20.49 ms Query memory: 0.020 MB Memory before query: 6.595 MB Rows returned: 12

SELECT *

  FROM zlaw_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_languages	ALL	idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	12	Using where; Using filesort

Profile

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	1.40 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.63 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:66
7	PlgSystemTBFLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.74 ms After last query: 0.69 ms Query memory: 0.021 MB Memory before query: 6.645 MB Rows returned: 23

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `zlaw_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	extension	extension	82	const	24	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.19 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
9	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/administrator/components/com_languages/helpers/multilangstatus.php:100
8	MultilangstatusHelper::getSitelangs()	JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:77
7	PlgSystemTBFLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.31 ms After last query: 38.98 ms Query memory: 0.021 MB Memory before query: 8.035 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
Starting	0.13 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	1.24 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.33 ms
Closing tables	0.01 ms
Removing tmp table	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:345
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:685
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:118
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.71 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 8.046 MB Rows returned: 0

SELECT *

  FROM `zlaw_admintools_ipautoban`

  WHERE `ip` = '3.16.29.209'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	5.16 ms
Preparing	0.03 ms
Executing	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:32
10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:685
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:118
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.07 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 8.053 MB Rows returned: 0

SELECT *

  FROM `zlaw_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('') 
  AND `view` IN('') 
  AND `task` IN('')

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_admintools_wafblacklists	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	1.28 ms
Creating sort index	0.05 ms
Removing tmp table	0.03 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:65
10	AtsystemFeatureWafblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:685
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:118
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 10.76 ms After last query: 22.12 ms Query memory: 0.057 MB Memory before query: 8.241 MB Rows returned: 56

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 zlaw_menu AS m

  LEFT JOIN zlaw_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	744	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	appcrbgnfx.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.19 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.10 ms
Optimizing	0.05 ms
Statistics	2.22 ms
Preparing	0.08 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	7.38 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:104
8	PlgSystemTBFLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.89 ms After last query: 3.28 ms Query memory: 0.020 MB Memory before query: 8.478 MB Rows returned: 0

SELECT id 
  FROM zlaw_affiliate_tracker_accounts 
  WHERE id = 0 
  AND publish = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	1.24 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/affiliate_tracker/affiliate_tracker.php:45
8	plgSystemAffiliate_tracker->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.55 ms After last query: 12.36 ms Query memory: 0.022 MB Memory before query: 9.120 MB Rows returned: 1

Duplicate queries: #18

SELECT `manifest_cache`

  FROM `zlaw_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_ats'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	extension	extension	82	const	56	Using index condition; Using where

Profile

Status	Duration
Starting	0.20 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.18 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.60 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/components/com_ats/router.php:16
7	require_once JROOT/components/com_ats/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.06 ms After last query: 4.22 ms Query memory: 0.021 MB Memory before query: 9.260 MB Rows returned: 1

Duplicate queries: #17

SELECT `manifest_cache`

  FROM `zlaw_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_ats'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	extension	extension	82	const	56	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.34 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/components/com_ats/router.php:16
7	require_once JROOT/components/com_ats/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.07 ms After last query: 20.07 ms Query memory: 0.022 MB Memory before query: 10.143 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `zlaw_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	1.13 ms
Preparing	0.08 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.68 ms After last query: 0.26 ms Query memory: 0.004 MB Memory before query: 10.133 MB

UPDATE `zlaw_extensions`

  SET `params` = '{\"mediaversion\":\"5f57bd01ae5921d29838ce05c2d3fafe\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `zlaw_extensions` SET `params` = '{\"mediaversion\":\"5f57bd01ae5921d29838ce05c2d3fafe\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.10 ms
Updating	0.73 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	2.28 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.91 ms After last query: 3.49 ms Query memory: 0.018 MB Memory before query: 10.309 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM zlaw_template_styles as s

  LEFT JOIN zlaw_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	appcrbgnfx.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	1.61 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.57 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.23 ms After last query: 39.61 ms Query memory: 0.032 MB Memory before query: 11.905 MB Rows returned: 262

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Checking permissions	1.14 ms
Executing	0.02 ms
Sending data	0.26 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
17	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
16	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2070
15	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
14	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
13	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
12	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
11	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:896
10	F0FModel->setIDsFromRequest()	JROOT/components/com_akeebasubs/controllers/levels.php:125
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.47 ms After last query: 0.38 ms Query memory: 0.024 MB Memory before query: 11.937 MB Rows returned: 33

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_levels`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_levels`

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.45 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
Checking permissions	0.21 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.11 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
16	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
15	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
14	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
13	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
12	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
11	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:896
10	F0FModel->setIDsFromRequest()	JROOT/components/com_akeebasubs/controllers/levels.php:125
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.35 ms After last query: 3.18 ms Query memory: 0.022 MB Memory before query: 12.036 MB Rows returned: 1

SELECT *

  FROM `zlaw_akeebasubs_levels`

  WHERE `slug` = 'the-booking-form-annual-subscription'

  ORDER BY akeebasubs_level_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	const	slug	slug	1022	const	1

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.02 ms
Statistics	1.50 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
13	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
12	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
11	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1320
10	F0FModel->getFirstItem()	JROOT/components/com_akeebasubs/controllers/levels.php:133
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.76 ms After last query: 0.77 ms Query memory: 0.022 MB Memory before query: 12.043 MB Rows returned: 1

Duplicate queries: #36 #51 #64

SELECT zlaw_akeebasubs_levels.*

  FROM zlaw_akeebasubs_levels

  WHERE `zlaw_akeebasubs_levels`.`akeebasubs_level_id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	const	PRIMARY	PRIMARY	8	const	1

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
12	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
11	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
10	F0FModel->getItem()	JROOT/components/com_akeebasubs/controllers/levels.php:151
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.78 ms After last query: 7.51 ms Query memory: 0.026 MB Memory before query: 12.198 MB Rows returned: 50

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `zlaw_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advancedmodules','com_affiliatetracker','com_ajax','com_akeeba','com_akeebasubs','com_associations','com_ats','com_autoresponder','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_demobar','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_leadmagnet','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rereplacer','com_search','com_tags','com_tbcorporate','com_tbdrivers','com_tbhelp','com_tbsaas','com_tbsaasadmin','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	231	Using where

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.05 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.11 ms
Optimizing	0.03 ms
Statistics	0.16 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	3.80 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/libraries/f0f/integration/joomla/platform.php:584
15	F0FIntegrationJoomlaPlatform->authorise()	JROOT/libraries/f0f/view/raw.php:80
14	F0FViewRaw->__construct()	JROOT/libraries/f0f/view/html.php:53
13	F0FViewHtml->__construct()	JROOT/libraries/f0f/controller/controller.php:2805
12	F0FController->createView()	JROOT/libraries/f0f/controller/controller.php:2500
11	F0FController->getView()	JROOT/libraries/f0f/controller/controller.php:2402
10	F0FController->getThisView()	JROOT/components/com_akeebasubs/controllers/levels.php:184
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 16.78 ms After last query: 3.82 ms Query memory: 0.024 MB Memory before query: 12.389 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `zlaw_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_users`

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.44 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	15.15 ms
After opening tables	0.06 ms
Checking permissions	0.16 ms
Closing tables	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Removing tmp table	0.15 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
15	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
14	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
13	F0FTable->__construct()	JROOT/administrator/components/com_akeebasubs/tables/juser.php:16
12	AkeebasubsTableJuser->__construct()	JROOT/libraries/f0f/table/table.php:433
11	F0FTable::getAnInstance()	JROOT/administrator/components/com_akeebasubs/models/users.php:348
10	AkeebasubsModelUsers->getMergedData()	JROOT/components/com_akeebasubs/controllers/levels.php:189
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.90 ms After last query: 5.99 ms Query memory: 0.025 MB Memory before query: 12.572 MB Rows returned: 4

Duplicate queries: #29 #30 #31 #32 #47

SELECT *

  FROM `zlaw_akeebasubs_levels`

  ORDER BY akeebasubs_level_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	index	NULL	PRIMARY	8	NULL	4

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
19	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
18	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
17	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
16	F0FModel->getList()	JROOT/administrator/components/com_akeebasubs/assets/akeebasubs.php:259
15	plgAkeebasubsAbstract->loadGroupAssignments()	JROOT/administrator/components/com_akeebasubs/assets/akeebasubs.php:85
14	plgAkeebasubsAbstract->__construct()	JROOT/plugins/akeebasubs/acymailing/acymailing.php:20
13	plgAkeebasubsAcymailing->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_akeebasubs/models/users.php:421
10	AkeebasubsModelUsers->getMergedData()	JROOT/components/com_akeebasubs/controllers/levels.php:189
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.69 ms After last query: 13.32 ms Query memory: 0.025 MB Memory before query: 12.819 MB Rows returned: 4

Duplicate queries: #28 #30 #31 #32 #47

SELECT *

  FROM `zlaw_akeebasubs_levels`

  ORDER BY akeebasubs_level_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	index	NULL	PRIMARY	8	NULL	4

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
19	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
18	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
17	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
16	F0FModel->getList()	JROOT/administrator/components/com_akeebasubs/assets/akeebasubs.php:259
15	plgAkeebasubsAbstract->loadGroupAssignments()	JROOT/administrator/components/com_akeebasubs/assets/akeebasubs.php:85
14	plgAkeebasubsAbstract->__construct()	JROOT/plugins/akeebasubs/joomla/joomla.php:20
13	plgAkeebasubsJoomla->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_akeebasubs/models/users.php:421
10	AkeebasubsModelUsers->getMergedData()	JROOT/components/com_akeebasubs/controllers/levels.php:189
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.63 ms After last query: 2.82 ms Query memory: 0.025 MB Memory before query: 12.889 MB Rows returned: 4

Duplicate queries: #28 #29 #31 #32 #47

SELECT *

  FROM `zlaw_akeebasubs_levels`

  ORDER BY akeebasubs_level_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	index	NULL	PRIMARY	8	NULL	4

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.04 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
19	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
18	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
17	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
16	F0FModel->getList()	JROOT/administrator/components/com_akeebasubs/assets/akeebasubs.php:259
15	plgAkeebasubsAbstract->loadGroupAssignments()	JROOT/administrator/components/com_akeebasubs/assets/akeebasubs.php:85
14	plgAkeebasubsAbstract->__construct()	JROOT/plugins/akeebasubs/mijoshop/mijoshop.php:20
13	plgAkeebasubsMijoshop->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_akeebasubs/models/users.php:421
10	AkeebasubsModelUsers->getMergedData()	JROOT/components/com_akeebasubs/controllers/levels.php:189
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.58 ms After last query: 2.72 ms Query memory: 0.024 MB Memory before query: 12.954 MB Rows returned: 4

Duplicate queries: #28 #29 #30 #32 #47

SELECT *

  FROM `zlaw_akeebasubs_levels`

  ORDER BY akeebasubs_level_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	index	NULL	PRIMARY	8	NULL	4

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
18	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
17	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
16	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
15	F0FModel->getList()	JROOT/plugins/akeebasubs/slavesubs/slavesubs.php:661
14	plgAkeebasubsSlavesubs->loadLevelAssignments()	JROOT/plugins/akeebasubs/slavesubs/slavesubs.php:21
13	plgAkeebasubsSlavesubs->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_akeebasubs/models/users.php:421
10	AkeebasubsModelUsers->getMergedData()	JROOT/components/com_akeebasubs/controllers/levels.php:189
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.71 ms After last query: 4.70 ms Query memory: 0.025 MB Memory before query: 13.092 MB Rows returned: 4

Duplicate queries: #28 #29 #30 #31 #47

SELECT *

  FROM `zlaw_akeebasubs_levels`

  ORDER BY akeebasubs_level_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	index	NULL	PRIMARY	8	NULL	4

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
19	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
18	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
17	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
16	F0FModel->getList()	JROOT/plugins/akeebasubs/tbsaas/tbsaas.php:763
15	plgAkeebasubsTbsaas->loadGroupAssignments()	JROOT/administrator/components/com_akeebasubs/assets/akeebasubs.php:85
14	plgAkeebasubsAbstract->__construct()	JROOT/plugins/akeebasubs/tbsaas/tbsaas.php:30
13	plgAkeebasubsTbsaas->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_akeebasubs/models/users.php:421
10	AkeebasubsModelUsers->getMergedData()	JROOT/components/com_akeebasubs/controllers/levels.php:189
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.78 ms After last query: 8.71 ms Query memory: 0.027 MB Memory before query: 13.574 MB Rows returned: 11

Duplicate queries: #34

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_states`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_states`

Profile

Status	Duration
Starting	0.18 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.31 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	6.23 ms
After opening tables	0.05 ms
Checking permissions	0.19 ms
Closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.21 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
22	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
21	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
20	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
19	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
18	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
17	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2061
16	F0FModel->buildQuery()	JROOT/administrator/components/com_akeebasubs/models/states.php:15
15	AkeebasubsModelStates->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
14	F0FModel->getItemList()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:856
13	akeebasubsHelperSelect_init()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:893
12	require_once JROOT/administrator/components/com_akeebasubs/helpers/select.php	JROOT/components/com_akeebasubs/models/subscribes.php:517
11	AkeebasubsModelSubscribes->_validateState()	JROOT/components/com_akeebasubs/models/subscribes.php:230
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.10 ms After last query: 1.48 ms Query memory: 0.026 MB Memory before query: 13.712 MB Rows returned: 11

Duplicate queries: #33

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_states`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_states`

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.29 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.06 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.10 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.09 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
21	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/model/model.php:2129
20	F0FModel->getTableFields()	JROOT/libraries/f0f/model/behavior/filters.php:37
19	F0FModelBehaviorFilters->onAfterBuildQuery()	JROOT/libraries/f0f/utils/observable/event.php:63
18	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
17	F0FUtilsObservableDispatcher->trigger()	JROOT/libraries/f0f/model/model.php:2113
16	F0FModel->buildQuery()	JROOT/administrator/components/com_akeebasubs/models/states.php:15
15	AkeebasubsModelStates->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
14	F0FModel->getItemList()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:856
13	akeebasubsHelperSelect_init()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:893
12	require_once JROOT/administrator/components/com_akeebasubs/helpers/select.php	JROOT/components/com_akeebasubs/models/subscribes.php:517
11	AkeebasubsModelSubscribes->_validateState()	JROOT/components/com_akeebasubs/models/subscribes.php:230
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.84 ms After last query: 7.37 ms Query memory: 0.024 MB Memory before query: 13.868 MB Rows returned: 51

SELECT `zlaw_akeebasubs_states`.*

  FROM `zlaw_akeebasubs_states`

  WHERE (`enabled` = '1')

  ORDER BY country ASC, label ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_states	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	213	Using where; Using filesort

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.05 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.97 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
16	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
15	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
14	F0FModel->getItemList()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:856
13	akeebasubsHelperSelect_init()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:893
12	require_once JROOT/administrator/components/com_akeebasubs/helpers/select.php	JROOT/components/com_akeebasubs/models/subscribes.php:517
11	AkeebasubsModelSubscribes->_validateState()	JROOT/components/com_akeebasubs/models/subscribes.php:230
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.70 ms After last query: 0.86 ms Query memory: 0.023 MB Memory before query: 13.891 MB Rows returned: 1

Duplicate queries: #25 #51 #64

SELECT zlaw_akeebasubs_levels.*

  FROM zlaw_akeebasubs_levels

  WHERE `zlaw_akeebasubs_levels`.`akeebasubs_level_id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	const	PRIMARY	PRIMARY	8	const	1

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
14	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
13	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
12	F0FModel->getItem()	JROOT/components/com_akeebasubs/models/subscribes.php:694
11	AkeebasubsModelSubscribes->validatePrice()	JROOT/components/com_akeebasubs/models/subscribes.php:233
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.63 ms After last query: 6.03 ms Query memory: 0.027 MB Memory before query: 14.051 MB Rows returned: 18

Duplicate queries: #38 #43 #45 #57 #62

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_customfields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_customfields`

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.35 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.09 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	2.11 ms
After opening tables	0.02 ms
Checking permissions	0.14 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.22 ms
Closing tables	0.02 ms
Unlocking tables	0.03 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
23	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
22	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
21	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
20	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
19	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
18	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2061
17	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
16	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:305
15	plgAkeebasubsCustomfields->onValidateSubscriptionPrice()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_akeebasubs/models/subscribes.php:738
11	AkeebasubsModelSubscribes->validatePrice()	JROOT/components/com_akeebasubs/models/subscribes.php:233
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.43 ms After last query: 0.68 ms Query memory: 0.026 MB Memory before query: 14.090 MB Rows returned: 18

Duplicate queries: #37 #43 #45 #57 #62

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_customfields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_customfields`

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.35 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.12 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.14 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
22	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/model/model.php:2129
21	F0FModel->getTableFields()	JROOT/libraries/f0f/model/behavior/filters.php:37
20	F0FModelBehaviorFilters->onAfterBuildQuery()	JROOT/libraries/f0f/utils/observable/event.php:63
19	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
18	F0FUtilsObservableDispatcher->trigger()	JROOT/libraries/f0f/model/model.php:2113
17	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
16	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:305
15	plgAkeebasubsCustomfields->onValidateSubscriptionPrice()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_akeebasubs/models/subscribes.php:738
11	AkeebasubsModelSubscribes->validatePrice()	JROOT/components/com_akeebasubs/models/subscribes.php:233
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.85 ms After last query: 0.82 ms Query memory: 0.024 MB Memory before query: 14.100 MB Rows returned: 3

Duplicate queries: #44 #46

SELECT `zlaw_akeebasubs_customfields`.*

  FROM `zlaw_akeebasubs_customfields`

  WHERE (`enabled` = '1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_customfields	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.10 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
18	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
17	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
16	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:305
15	plgAkeebasubsCustomfields->onValidateSubscriptionPrice()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_akeebasubs/models/subscribes.php:738
11	AkeebasubsModelSubscribes->validatePrice()	JROOT/components/com_akeebasubs/models/subscribes.php:233
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.07 ms After last query: 1.87 ms Query memory: 0.025 MB Memory before query: 14.144 MB Rows returned: 15

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_taxrules`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_taxrules`

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.40 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.05 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	3.46 ms
After opening tables	0.05 ms
Checking permissions	0.20 ms
Closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.03 ms
Removing tmp table	0.15 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
18	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
17	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
16	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
15	F0FModel->getTable()	JROOT/administrator/components/com_akeebasubs/models/taxrules.php:65
14	AkeebasubsModelTaxrules->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
13	F0FModel->getItemList()	JROOT/components/com_akeebasubs/models/subscribes.php:1616
12	AkeebasubsModelSubscribes->_getTaxRule()	JROOT/components/com_akeebasubs/models/subscribes.php:848
11	AkeebasubsModelSubscribes->validatePrice()	JROOT/components/com_akeebasubs/models/subscribes.php:233
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.05 ms After last query: 0.61 ms Query memory: 0.023 MB Memory before query: 14.172 MB Rows returned: 0

SELECT *

  FROM `zlaw_akeebasubs_taxrules`

  WHERE `enabled`='1' 
  AND `akeebasubs_level_id`='14'

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_taxrules	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	58	Using where; Using filesort

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.04 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.07 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
15	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
14	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
13	F0FModel->getItemList()	JROOT/components/com_akeebasubs/models/subscribes.php:1616
12	AkeebasubsModelSubscribes->_getTaxRule()	JROOT/components/com_akeebasubs/models/subscribes.php:848
11	AkeebasubsModelSubscribes->validatePrice()	JROOT/components/com_akeebasubs/models/subscribes.php:233
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.11 ms After last query: 0.85 ms Query memory: 0.024 MB Memory before query: 14.204 MB Rows returned: 58

SELECT *

  FROM `zlaw_akeebasubs_taxrules`

  WHERE `enabled`='1'

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_taxrules	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	58	Using where; Using filesort

Profile

Status	Duration
Starting	0.19 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.35 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
15	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
14	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
13	F0FModel->getItemList()	JROOT/components/com_akeebasubs/models/subscribes.php:1629
12	AkeebasubsModelSubscribes->_getTaxRule()	JROOT/components/com_akeebasubs/models/subscribes.php:848
11	AkeebasubsModelSubscribes->validatePrice()	JROOT/components/com_akeebasubs/models/subscribes.php:233
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.35 ms After last query: 0.74 ms Query memory: 0.026 MB Memory before query: 14.222 MB Rows returned: 18

Duplicate queries: #37 #38 #45 #57 #62

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_customfields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_customfields`

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Closing tables	0.04 ms
Opening tables	0.38 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.13 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
22	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/model/model.php:2129
21	F0FModel->getTableFields()	JROOT/libraries/f0f/model/behavior/filters.php:37
20	F0FModelBehaviorFilters->onAfterBuildQuery()	JROOT/libraries/f0f/utils/observable/event.php:63
19	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
18	F0FUtilsObservableDispatcher->trigger()	JROOT/libraries/f0f/model/model.php:2113
17	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
16	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:160
15	plgAkeebasubsCustomfields->onValidate()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_akeebasubs/models/subscribes.php:254
11	AkeebasubsModelSubscribes->pluginValidation()	JROOT/components/com_akeebasubs/models/subscribes.php:235
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.57 ms After last query: 0.92 ms Query memory: 0.024 MB Memory before query: 14.232 MB Rows returned: 3

Duplicate queries: #39 #46

SELECT `zlaw_akeebasubs_customfields`.*

  FROM `zlaw_akeebasubs_customfields`

  WHERE (`enabled` = '1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_customfields	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
18	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
17	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
16	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:160
15	plgAkeebasubsCustomfields->onValidate()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_akeebasubs/models/subscribes.php:254
11	AkeebasubsModelSubscribes->pluginValidation()	JROOT/components/com_akeebasubs/models/subscribes.php:235
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.45 ms After last query: 0.63 ms Query memory: 0.026 MB Memory before query: 14.251 MB Rows returned: 18

Duplicate queries: #37 #38 #43 #57 #62

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_customfields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_customfields`

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.39 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.17 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
22	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/model/model.php:2129
21	F0FModel->getTableFields()	JROOT/libraries/f0f/model/behavior/filters.php:37
20	F0FModelBehaviorFilters->onAfterBuildQuery()	JROOT/libraries/f0f/utils/observable/event.php:63
19	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
18	F0FUtilsObservableDispatcher->trigger()	JROOT/libraries/f0f/model/model.php:2113
17	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
16	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:236
15	plgAkeebasubsCustomfields->onValidatePerSubscription()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_akeebasubs/models/subscribes.php:285
11	AkeebasubsModelSubscribes->pluginValidation()	JROOT/components/com_akeebasubs/models/subscribes.php:235
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.74 ms After last query: 0.82 ms Query memory: 0.024 MB Memory before query: 14.261 MB Rows returned: 3

Duplicate queries: #39 #44

SELECT `zlaw_akeebasubs_customfields`.*

  FROM `zlaw_akeebasubs_customfields`

  WHERE (`enabled` = '1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_customfields	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
18	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
17	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
16	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:236
15	plgAkeebasubsCustomfields->onValidatePerSubscription()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_akeebasubs/models/subscribes.php:285
11	AkeebasubsModelSubscribes->pluginValidation()	JROOT/components/com_akeebasubs/models/subscribes.php:235
10	AkeebasubsModelSubscribes->getValidation()	JROOT/components/com_akeebasubs/controllers/levels.php:211
9	AkeebasubsControllerLevels->onBeforeRead()	JROOT/libraries/f0f/controller/controller.php:919
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.16 ms After last query: 14.17 ms Query memory: 0.025 MB Memory before query: 14.625 MB Rows returned: 4

Duplicate queries: #28 #29 #30 #31 #32

SELECT *

  FROM `zlaw_akeebasubs_levels`

  ORDER BY akeebasubs_level_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	index	NULL	PRIMARY	8	NULL	4

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.09 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
21	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
20	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1229
19	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
18	F0FModel->getList()	JROOT/plugins/content/astimedrelease/astimedrelease.php:69
17	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:54
16	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
15	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
14	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/f0f/integration/joomla/platform.php:522
13	F0FIntegrationJoomlaPlatform->importPlugin()	JROOT/libraries/f0f/model/model.php:2563
12	F0FModel->preprocessForm()	JROOT/libraries/f0f/model/model.php:2411
11	F0FModel->loadForm()	JROOT/libraries/f0f/model/model.php:2321
10	F0FModel->getForm()	JROOT/libraries/f0f/controller/controller.php:1210
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.48 ms After last query: 8.37 ms Query memory: 0.023 MB Memory before query: 14.960 MB Rows returned: 1

SELECT MAX(ordering)

  FROM `zlaw_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	extension	extension	82	const	291	Using index condition

Profile

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.43 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
16	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
15	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
14	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/f0f/integration/joomla/platform.php:522
13	F0FIntegrationJoomlaPlatform->importPlugin()	JROOT/libraries/f0f/model/model.php:2563
12	F0FModel->preprocessForm()	JROOT/libraries/f0f/model/model.php:2411
11	F0FModel->loadForm()	JROOT/libraries/f0f/model/model.php:2321
10	F0FModel->getForm()	JROOT/libraries/f0f/controller/controller.php:1210
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.86 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 14.967 MB Rows returned: 1

SELECT `ordering`

  FROM `zlaw_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content' 
  AND `element` = 'perfect_everything_in_everyway'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.15 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
16	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
15	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
14	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/f0f/integration/joomla/platform.php:522
13	F0FIntegrationJoomlaPlatform->importPlugin()	JROOT/libraries/f0f/model/model.php:2563
12	F0FModel->preprocessForm()	JROOT/libraries/f0f/model/model.php:2411
11	F0FModel->loadForm()	JROOT/libraries/f0f/model/model.php:2321
10	F0FModel->getForm()	JROOT/libraries/f0f/controller/controller.php:1210
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 11.69 ms After last query: 4.27 ms Query memory: 0.026 MB Memory before query: 15.147 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 zlaw_fields AS a

  LEFT JOIN `zlaw_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN zlaw_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN zlaw_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN zlaw_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN zlaw_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_akeebasubs.levels.form.default' 
  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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	appcrbgnfx.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	appcrbgnfx.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	appcrbgnfx.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	appcrbgnfx.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	appcrbgnfx.a.group_id	1	Using where

Profile

Status	Duration
Starting	0.26 ms
Checking permissions	0.02 ms
Opening tables	7.79 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.19 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Init	0.12 ms
Optimizing	0.07 ms
Statistics	1.46 ms
Preparing	0.10 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.50 ms
Creating sort index	0.07 ms
Removing tmp table	0.20 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/f0f/integration/joomla/platform.php:545
13	F0FIntegrationJoomlaPlatform->runPlugins()	JROOT/libraries/f0f/model/model.php:2566
12	F0FModel->preprocessForm()	JROOT/libraries/f0f/model/model.php:2411
11	F0FModel->loadForm()	JROOT/libraries/f0f/model/model.php:2321
10	F0FModel->getForm()	JROOT/libraries/f0f/controller/controller.php:1210
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.26 ms After last query: 50.84 ms Query memory: 0.025 MB Memory before query: 17.074 MB Rows returned: 1

Duplicate queries: #25 #36 #64

SELECT zlaw_akeebasubs_levels.*

  FROM zlaw_akeebasubs_levels

  WHERE `zlaw_akeebasubs_levels`.`akeebasubs_level_id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	const	PRIMARY	PRIMARY	8	const	1

Profile

Status	Duration
Starting	0.18 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.05 ms
Statistics	0.23 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
19	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
18	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
17	F0FModel->getItem()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:553
16	AkeebasubsHelperSelect::paymentmethods()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:39
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.82 ms After last query: 10.07 ms Query memory: 0.042 MB Memory before query: 17.576 MB Rows returned: 18

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM zlaw_modules AS m

  LEFT JOIN zlaw_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN zlaw_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds,idx_language	published	1	const	21	Using index condition; Using where; Using filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	appcrbgnfx.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	appcrbgnfx.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.27 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.09 ms
Optimizing	0.06 ms
Statistics	1.84 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	4.89 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:361
22	plgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:126
21	plgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
18	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
17	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_akeebasubs/helpers/modules.php:19
16	AkeebasubsHelperModules::loadposition()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:70
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.78 ms After last query: 6.61 ms Query memory: 0.027 MB Memory before query: 17.813 MB Rows returned: 1

SELECT m.menutype

  FROM zlaw_menu AS m

  WHERE m.id = 239

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:80
25	nnFrameworkAssignmentsMenu->getMenuType()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:28
24	nnFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:344
23	nnFrameworkAssignmentsHelper->passAllByType()	JROOT/plugins/system/nnframework/helpers/assignments.php:289
22	nnFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:176
21	plgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
18	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
17	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_akeebasubs/helpers/modules.php:19
16	AkeebasubsHelperModules::loadposition()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:70
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.49 ms After last query: 0.55 ms Query memory: 0.027 MB Memory before query: 17.855 MB Rows returned: 1

SELECT t.parent_id

  FROM zlaw_menu as t

  WHERE t.id = 239

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignment.php:168
26	nnFrameworkAssignment->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65
25	nnFrameworkAssignmentsMenu->getMenuParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47
24	nnFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:344
23	nnFrameworkAssignmentsHelper->passAllByType()	JROOT/plugins/system/nnframework/helpers/assignments.php:289
22	nnFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:176
21	plgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
18	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
17	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_akeebasubs/helpers/modules.php:19
16	AkeebasubsHelperModules::loadposition()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:70
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.43 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 17.866 MB Rows returned: 1

SELECT t.parent_id

  FROM zlaw_menu as t

  WHERE t.id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignment.php:168
26	nnFrameworkAssignment->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65
25	nnFrameworkAssignmentsMenu->getMenuParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47
24	nnFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:344
23	nnFrameworkAssignmentsHelper->passAllByType()	JROOT/plugins/system/nnframework/helpers/assignments.php:289
22	nnFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:176
21	plgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
18	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
17	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_akeebasubs/helpers/modules.php:19
16	AkeebasubsHelperModules::loadposition()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:70
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.69 ms After last query: 10.54 ms Query memory: 0.028 MB Memory before query: 18.058 MB Rows returned: 0

SELECT r.*

  FROM zlaw_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'articles')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ref	idx_published	idx_published	1	const	3	Using where; Using filesort

Profile

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.04 ms
Statistics	1.40 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
Creating sort index	0.41 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:52
27	plgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helper.php:37
26	plgSystemReReplacerHelper->onContentPrepare()	JROOT/plugins/system/rereplacer/rereplacer.php:40
25	plgSystemReReplacer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
24	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
23	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
22	JHtmlContent::prepare()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
20	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
19	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_level.php:24
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_level.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:76
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.36 ms After last query: 19.45 ms Query memory: 0.030 MB Memory before query: 18.521 MB Rows returned: 18

Duplicate queries: #37 #38 #43 #45 #62

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_customfields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_customfields`

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.31 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.05 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.15 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.11 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
30	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/model/model.php:2129
29	F0FModel->getTableFields()	JROOT/libraries/f0f/model/behavior/filters.php:37
28	F0FModelBehaviorFilters->onAfterBuildQuery()	JROOT/libraries/f0f/utils/observable/event.php:63
27	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
26	F0FUtilsObservableDispatcher->trigger()	JROOT/libraries/f0f/model/model.php:2113
25	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
24	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:84
23	plgAkeebasubsCustomfields->_customFieldRender()	JROOT/plugins/akeebasubs/customfields/customfields.php:52
22	plgAkeebasubsCustomfields->onSubscriptionFormRender()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php:231
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:100
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.69 ms After last query: 0.62 ms Query memory: 0.027 MB Memory before query: 18.535 MB Rows returned: 3

Duplicate queries: #63

SELECT `zlaw_akeebasubs_customfields`.*

  FROM `zlaw_akeebasubs_customfields`

  WHERE (`enabled` = '1')

  ORDER BY `ordering` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_customfields	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
26	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
25	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
24	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:84
23	plgAkeebasubsCustomfields->_customFieldRender()	JROOT/plugins/akeebasubs/customfields/customfields.php:52
22	plgAkeebasubsCustomfields->onSubscriptionFormRender()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php:231
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:100
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.48 ms After last query: 1.06 ms Query memory: 0.056 MB Memory before query: 18.550 MB Rows returned: 1

Duplicate queries: #60 #61

SELECT id, title, introtext

  FROM zlaw_content

  WHERE id = 84 
  AND state = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_content	const	PRIMARY,idx_state	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	1.82 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_akeebasubs/helpers/cparams.php:55
19	AkeebasubsHelperCparams::privacyPolicy()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php:338
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:100
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.59 ms After last query: 0.15 ms Query memory: 0.056 MB Memory before query: 18.559 MB Rows returned: 1

Duplicate queries: #59 #61

SELECT id, title, introtext

  FROM zlaw_content

  WHERE id = 84 
  AND state = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_content	const	PRIMARY,idx_state	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_akeebasubs/helpers/cparams.php:55
19	AkeebasubsHelperCparams::privacyPolicy()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php:341
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:100
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.49 ms After last query: 0.14 ms Query memory: 0.056 MB Memory before query: 18.568 MB Rows returned: 1

Duplicate queries: #59 #60

SELECT id, title, introtext

  FROM zlaw_content

  WHERE id = 84 
  AND state = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_content	const	PRIMARY,idx_state	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_akeebasubs/helpers/cparams.php:55
19	AkeebasubsHelperCparams::privacyPolicy()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php:342
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:100
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.37 ms After last query: 5.13 ms Query memory: 0.030 MB Memory before query: 18.693 MB Rows returned: 18

Duplicate queries: #37 #38 #43 #45 #57

SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_customfields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zlaw_akeebasubs_customfields`

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.39 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.17 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.14 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
30	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/model/model.php:2129
29	F0FModel->getTableFields()	JROOT/libraries/f0f/model/behavior/filters.php:37
28	F0FModelBehaviorFilters->onAfterBuildQuery()	JROOT/libraries/f0f/utils/observable/event.php:63
27	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
26	F0FUtilsObservableDispatcher->trigger()	JROOT/libraries/f0f/model/model.php:2113
25	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
24	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:84
23	plgAkeebasubsCustomfields->_customFieldRender()	JROOT/plugins/akeebasubs/customfields/customfields.php:33
22	plgAkeebasubsCustomfields->onSubscriptionFormRenderPerSubFields()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php:521
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:100
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.74 ms After last query: 0.65 ms Query memory: 0.027 MB Memory before query: 18.707 MB Rows returned: 3

Duplicate queries: #58

SELECT `zlaw_akeebasubs_customfields`.*

  FROM `zlaw_akeebasubs_customfields`

  WHERE (`enabled` = '1')

  ORDER BY `ordering` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_customfields	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.18 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
26	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
25	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
24	F0FModel->getItemList()	JROOT/plugins/akeebasubs/customfields/customfields.php:84
23	plgAkeebasubsCustomfields->_customFieldRender()	JROOT/plugins/akeebasubs/customfields/customfields.php:33
22	plgAkeebasubsCustomfields->onSubscriptionFormRenderPerSubFields()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php:521
18	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default_fields.php	JROOT/libraries/f0f/view/view.php:442
17	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
16	F0FView->loadTemplate()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:100
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.62 ms After last query: 1.28 ms Query memory: 0.025 MB Memory before query: 18.652 MB Rows returned: 1

Duplicate queries: #25 #36 #51

SELECT zlaw_akeebasubs_levels.*

  FROM zlaw_akeebasubs_levels

  WHERE `zlaw_akeebasubs_levels`.`akeebasubs_level_id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_akeebasubs_levels	const	PRIMARY	PRIMARY	8	const	1

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
19	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
18	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
17	F0FModel->getItem()	JROOT/administrator/components/com_akeebasubs/helpers/select.php:553
16	AkeebasubsHelperSelect::paymentmethods()	JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php:187
15	include JROOT/templates/sportsmaterial/html/com_akeebasubs/level/default.php	JROOT/libraries/f0f/view/view.php:442
14	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
13	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
12	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
11	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
10	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1218
9	F0FController->read()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:35
6	require_once JROOT/components/com_akeebasubs/akeebasubs.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.25 ms After last query: 5.07 ms Query memory: 0.022 MB Memory before query: 18.634 MB Rows returned: 13

SELECT language,id

  FROM `zlaw_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	744	Using where

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.61 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/administrator/components/com_languages/helpers/multilangstatus.php:125
8	MultilangstatusHelper::getHomepages()	JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:708
7	PlgSystemTBFLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.96 ms After last query: 29.21 ms Query memory: 0.021 MB Memory before query: 19.345 MB Rows returned: 0

SELECT r.*

  FROM zlaw_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'component')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ref	idx_published	idx_published	1	const	3	Using where; Using filesort

Profile

Status	Duration
Starting	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:52
11	plgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:50
10	plgSystemReReplacerHelperReplace->replaceInArea()	JROOT/plugins/system/rereplacer/helpers/replace.php:36
9	plgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:102
8	plgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:60
7	plgSystemReReplacer->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 19.350 MB Rows returned: 0

SELECT r.*

  FROM zlaw_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'head')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ref	idx_published	idx_published	1	const	3	Using where; Using filesort

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:52
11	plgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:50
10	plgSystemReReplacerHelperReplace->replaceInArea()	JROOT/plugins/system/rereplacer/helpers/replace.php:37
9	plgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:102
8	plgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:60
7	plgSystemReReplacer->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.60 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 19.356 MB Rows returned: 3

SELECT r.*

  FROM zlaw_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'body')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ref	idx_published	idx_published	1	const	3	Using where; Using filesort

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:52
11	plgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:50
10	plgSystemReReplacerHelperReplace->replaceInArea()	JROOT/plugins/system/rereplacer/helpers/replace.php:38
9	plgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:102
8	plgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:60
7	plgSystemReReplacer->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.89 ms After last query: 5.66 ms Query memory: 0.021 MB Memory before query: 19.491 MB Rows returned: 0

SELECT r.*

  FROM zlaw_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'everywhere')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ref	idx_published	idx_published	1	const	3	Using where; Using filesort

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:52
11	plgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:75
10	plgSystemReReplacerHelperReplace->replaceEverywhere()	JROOT/plugins/system/rereplacer/helpers/replace.php:40
9	plgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:102
8	plgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:60
7	plgSystemReReplacer->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.45 ms After last query: 0.33 ms Query memory: 0.020 MB Memory before query: 19.429 MB Rows returned: 1

SELECT `value`

  FROM `zlaw_admintools_storage`

  WHERE `key` = 'atoolsjupdatecheck_lastrun'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zlaw_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/atoolsjupdatecheck/atoolsjupdatecheck.php:78
7	plgSystemAtoolsjupdatecheck->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\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 Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT * 
  FROM `zlaw_akeebasubs_levels`

5 × SELECT `zlaw_akeebasubs_customfields`.* 
  FROM `zlaw_akeebasubs_customfields`

5 × SELECT r.* 
  FROM zlaw_rereplacer AS r

4 × SELECT zlaw_akeebasubs_levels.* 
  FROM zlaw_akeebasubs_levels

3 × SELECT id, title, introtext 
  FROM zlaw_content

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `zlaw_extensions`

2 × SELECT `value` 
  FROM `zlaw_admintools_storage`

2 × SELECT `manifest_cache` 
  FROM `zlaw_extensions`

2 × SELECT * 
  FROM `zlaw_akeebasubs_taxrules`

2 × SELECT t.parent_id 
  FROM zlaw_menu as t

1 × SELECT `data` 
  FROM `zlaw_session`

1 × SELECT `session_id` 
  FROM `zlaw_session`

1 × SELECT id, rules 
  FROM `zlaw_viewlevels

1 × SELECT b.id 
  FROM zlaw_usergroups AS a 
  LEFT JOIN zlaw_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM zlaw_extensions

1 × SELECT * 
  FROM `zlaw_admintools_wafexceptions`

```
1 × SELECT * 
  FROM zlaw_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `zlaw_extensions`

1 × SELECT * 
  FROM `zlaw_admintools_ipautoban`

1 × SELECT * 
  FROM `zlaw_admintools_wafblacklists`

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 zlaw_menu AS m 
  LEFT JOIN zlaw_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id 
  FROM zlaw_affiliate_tracker_accounts

1 × SELECT id, home, template, s.params 
  FROM zlaw_template_styles as s 
  LEFT JOIN zlaw_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `zlaw_assets`

1 × SELECT `zlaw_akeebasubs_states`.* 
  FROM `zlaw_akeebasubs_states`

1 × SELECT MAX(ordering) 
  FROM `zlaw_extensions`

1 × SELECT `ordering` 
  FROM `zlaw_extensions`

1 × 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 zlaw_fields AS a 
  LEFT JOIN `zlaw_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN zlaw_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN zlaw_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN zlaw_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN zlaw_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
  FROM zlaw_modules AS m 
  LEFT JOIN zlaw_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN zlaw_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT m.menutype 
  FROM zlaw_menu AS m

1 × SELECT language,id 
  FROM `zlaw_menu`

OTHER Tables:

6 × SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_customfields

2 × SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_states

1 × INSERT INTO `zlaw_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6964676d6d676661646d6f71353339353431696b303766336739', 1, 1714456676, 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `zlaw_extensions` 
  SET `params` = '{\"mediaversion\":\"5f57bd01ae5921d29838ce05c2d3fafe\"}'

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_levels

1 × SHOW FULL COLUMNS 
  FROM `zlaw_users

1 × SHOW FULL COLUMNS 
  FROM `zlaw_akeebasubs_taxrules

Prices

The Booking Form - annual subscription

Login

Information for your new account on our site

Privacy policy

Website Privacy Notice

1. Introduction

2. What data we collect about you, for what purpose and what ground we process it.

3. How we collect your personal data

4. Marketing Communications

5. Disclosures of Your Personal Data

6. International Transfers

7. Data Security

8. Data Retention

9. Your Legal Rights

10. Third-Party Links

11. Cookies

Business invoicing preferences

Summary

Subscribe

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

70 Queries Logged 180.12 ms

28 duplicate found!

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: