MarvikShop, is not a bridge, but a total revamp of osCommerce to work within Joomla as a Joomla component, it installs via the Joomla! component and Module installers. With many features available this will be one of the most complete ecommerce solution you need. Because MarvikShop is OScommerce for Joomla, it will be easy to implemented the oscommerce addons you can find here in MarvikShop itself.
MarvikShop 3.0 is easy to install on Joomla! 3.x.x.and Joomla 2.5. The old version Marvikshop 1 series was compatible with Joomla 1.0 and joomla 1.5. MarvikShop 2.x.x works on Joomla 2.5. We do not support MarvikShop 1 and 2 anymore.
Layout:
Nice product listing layout
jQuery/Ajax Shopping Cart
Fly to Cart product image to cart on product page
Ajax Add/Remove buttons in cart
Ajax Delete button in cart
Ajax Remove button in shopping_cart infobox
Unlimited Products and Categories
Gift Vouchers/Coupons
Download/Virtual Product support
Secure/Stable code base
Web Based admin Panel
Supports UPS, USPS and Fed X shipping
Unlimited product Specials
Separate customer groups
Download Controller
New Attribute Manager
Down For Maintenance
Shipping Per Product
Separate Pricing Per Customer
Category Box Enhancement
Specials On Main Page by Default
Column Product Listing + admin toggle and controls
Dynamic Meta Tag Generator
Edit Orders
Categories Descriptions
Easy Populate
Easy product listing
Country/State dropdown
Recover Cart Sales
Wishlist
Customer Loyalty Discount
Sales/Tax Reporting
Page Performance Parse
Some payment Modules Included:
Authorize.Net Consolidated Credit Card
Cash on Delivery
Standard osC Credit Card
EFS Net
GeoTrust QuickPayments
iPayment
Check/Money order
NOCHEX
PayBox Credit Card
2CheckOut
PSIGate
SECPay
Some shipping Modules Included:
FedX Direct Real Time Quotes v2.04
UPS XML v1.1.5
USPS Methods v2.7d + insurance
Flat Rate
Per Item Shipping
and many more...
Prices, Payment and Delivery.
All prices are in EURO € currency and all taxes are included. Listed prices are subject to change without further notice. There will be no supplementary charges. The payment process and all payments are processed by third parties.
Please read very carefully the product description and requirements. Also check the demo and free version, since we have a no-refund policy in order to avoid any fraud attempt.
Offers.
The quotes included in our offers for custom work are valid for 24 hours if there is no other stipulation because of the constant price-offer optimization. Time-frames are approximate, since they may vary due to the clients feedback. Offers are not transmittable. Offers are having a private and confidential character and cannot be published in any form. If involving our products, most probably the custom work will be realized on the latest available version. The answers for questions involving our products in generally are based on the latest available version.
Product License.
All commercial Extensions (components, modules, plugins) or Custom Work that we are offering are PROPRIETARY LICENSED Products (less GPL Extensions; see below). The PROPRIETARY LICENSED products are coming with a single Site License. This means that the buyer is entitled to install and use it only on a single site. Resale or distribution of our work (free or commercial products) including extensions, components, modules, plugins and custom work is strictly forbidden. Regarding custom work, our terms stated here are valid if no other agreement was closed.
In cases of abuse the license will be revoked immediately. Also customers working with 3-rd party developers, should ensure that if a third party acquired the license for them, worked their site or customized the product further to suit their site requirements, signed previous with the third party an NDA agreement in order to respect our terms & conditions presented here. This measure should offer protection to our customers, in case that the third party is violating the terms & conditions. Of course in fraud attempts, where a refund is claimed and surely not granted by the payment processor authority, the license will be revoked immediately, proceeded by legal actions for illegal usage.
Source Code of the components and custom work are NOT encrypted and we hope it will never be necessary to apply such measures. Our intention is to provide customers with more comfort and flexibility. Custom Work, Commercial or Free Components have all sources available and editable. The customer can modify them to match his purpose, but with no further distribution (free or commercial) in any form. Also, the partial use of the code in other components or projects is strictly prohibited! Exclusive "Intellectual Property" Rights are under complete ownership of MarvikShop.com.
Warranty and Support.
We guarantee that our products match their described features. We are not liable when our products may not function properly due to any particular system configuration, but we are trying to solve all the problems. So please do not hesitate to contact us, preferably on our forum. Please note that we are trying to answer as soon as possible, but take also under consideration our time zone (GMT +2) and working days. Support and warranty are offered for a period of one year after acquiring the license and does not include questions regarding the code, how to customize it or further development plans. Eventual fixes will be included in the next version and distributed according to the licensing rights. Customer modified sources, bonus licenses and free products are excluded from any warranty and support.
Updates for commercial Products.
After acquiring one product, the customer will receive upon request the next version releases for free for one a year. Please note that if any updates will be released, they will come as they are and only in special cases an upgrade script will be released. In cases of abuse the license will be revoked immediately!
Customized Versions are build on existing versions and are NOT the subject of any update., as well any bonus distributed licenses. Non-commercial products are also distributed as presented and are also not the subject of updates.
Order Acceptance.
Terms of payment shall be determined in our discretion and as otherwise agreed to by us. Payment shall be made by Paypal . Your receipt of an electronic or other form of order confirmation does not signify our acceptance of your order, nor does it constitute confirmation of the order or our offer to sell. We reserve the right, without prior notification, to accept or decline your order or limit the order quantity for any reason.
In order to download the GPL versions available on our site, you need to be a “MarvikShop GPL Development Club Member”. After becoming a member, the downloadl-ink will be available on as normal on each product page for the featured Club extensions and at the bottom of the page. The provided code through the GPL product version can be used further for personal usage or for other GPL available products, according to the GPL license.
Support for the GPL products it’s offered ONLY through our Forum. The support area covers ONLY the existing provided code, not further tweaks or programming.
By not respecting our terms & conditions the membership can be revoked immediately, without any previous notice. The period of the membership is 12 months. After the membership expires, a new membership can be acquired.
GPL Version Extensions.
All GPL Version Extension products are distributed under the GPL GNU General Public License, version 2. This extensions are only similar by name and main functionality with our other license type solutions (proprietary licensed products). The code itself in the GPL versions may vary allot from the other licensed type products. The obtained result with the GPL version may also vary allot in comparison to other licensed type products offered by our company.
Site Users and Members.
By registering to our site you become a member and also can post topics in the forum. From time to time it's possible that we will inform you on different issues or products. If you don't want to receive our information then please let us know and we will delete your membership account.
Very pertinent behavior on the forum may lead to a ban and canceled membership. without any previous notification, especially in case of spamming or advertising other products. In order to avoid this please do not use improper language, insults, or have a pertinent behavior (for more please see Customers FAQ).
You agree that you will not misuse or abuse account access and passwords. You agree that you will only use your password and that you will take all reasonable precautions to protect its secrecy.
Content.
The author reserves the right not to be responsible for the topicality, correctness, completeness or quality of the information provided. Liability claims regarding damage caused by the use of any information provided, including any kind of information which is incomplete or incorrect, will therefore be rejected. All offers are not-binding and without obligation. Parts of the pages or the complete publication including all offers and information might be extended, changed or partly or completely deleted by the author without separate announcement.
Typographical Errors.
In the event a product is listed at an incorrect price or with incorrect information due to typographical error or error in pricing or product information, we shall have the right to refuse or cancel any orders placed for products listed at the incorrect price. We shall have the right to refuse or cancel any such orders whether or not the order has been confirmed and your credit card has been charged. If your credit card has already been charged for the purchase and your order is canceled, we shall immediately issue a credit to your credit card account in the amount of the charge.
The author is not responsible for any contents linked or referred to from his pages, unless he has full knowledge of illegal contents and would be able to prevent the visitors of his site from viewing those pages. If any damage occurs by the use of information presented there, only the author of the respective pages might be liable, not the one who has linked to these pages. Furthermore the author is not liable for any postings or messages published by users of discussion boards, guest books or mailing lists provided on his page.
The author intended not to use any copyrighted material for the publication or, if not possible, to indicate the copyright of the respective object. The copyright for any material created by the author is reserved. Any duplication or use of objects such as images, diagrams, sounds or texts in other electronic or printed publications is not permitted without the author's agreement.
You agree that we, our directors, officers, employees or other representatives shall not be liable for damages arising from the operation, content, or use of this Site. You agree that this limitation of liability is comprehensive and applies to all damages of any kind, including without limitation direct, indirect, compensatory, special, incidental, punitive and consequential damages, damages for loss of profits, revenue, data and use, incurred by you or any third party, whether in an action in contract or tort, arising from your access to, and use of, this Site or any other hyper-linked Web site, even if we are expressly advised of the possibility of such damages.
Termination of Usage.
Compliance with Laws.
You agree to comply with all applicable laws, statutes, ordinances and regulations regarding your use of this Site and your purchase of products or services through this Site. We may, in our sole discretion, report actual or perceived violations to law enforcement or appropriate authorities. If we become aware, through a complaint or otherwise, of any potential or suspected violation of these Terms and Conditions or the Privacy Policy, we may (but are not obligated to) conduct an investigation to determine the nature and extent of the suspected violation and the appropriate enforcement action, during which investigation we may suspend services to any customer being investigated and/or remove any material from our servers. You agree to cooperate fully with any such investigation. You acknowledge that violations of the Terms and Conditions or the Privacy Policy could be subject to criminal or civil penalties.
Legal Validity of this Disclaimer.
This disclaimer is to be regarded as part of the Internet publication which you were referred from. If sections or individual terms of this statement are not legal or correct, the content or validity of the other parts remain uninfluenced by this fact.
You should not be running with PHP 6.0. First of all, it's an unreleased test version, and is not considered ready for any kind of production use. Second, osC makes use of many of the functions that PHP is removing in PHP 6.0, among them get_magic_quotes_gpc() (there seems to be some discussion about putting that one back in). Read this: us.php.net/ma....deprecated.php . As of PHP 5.3, they will generate "deprecated" errors, warning you to upgrade your code.
Marvikshop is easily installed as any Joomla component. That should be done through your site's backend.
Once you log in, you should open the Extensions => Install/Unistall section and click on the [Browse..] button in the Upload Package File section. Navigate to the two Marvikshop files(com_marvikshop and com_marvikshop_personal) file you have downloaded earlier and select it. Then click on the [Upload File & Install] button to start the installation. It will install and shows the first installation screen:
After the installation of com_marvikshop, the program asks for the installation file com_marvikshop_personal. This file contains your personal layout, language files and images. The following screen displays:
Because it is for now not possible to implemeted oscommerce complete in joomla. We have to edit the index.php from the frontpage and the index.php file in the admin section. The are little edits and not difficult to solve. The best way is to use a ftp program like filezilla and the php edit program notepad ++.
After you edited these files click on CLEAN/NEW install and the database will be installed. In the phpMyadmin you can see how the database was setup. For those who works with oscommerce will see similar tables! It easy to export and import these tables from your old OScommerce website.
Now in the admin section of joomla you can see MarvikShop as a new component in your component pulldown. The program is now ready for use.
First of all you have to do an uninstallation of the program. Because of edit the jooma index files you have to do the installation procedure in reverse.
Note 1 : Database tales will not be deleted!
First of all you have to uninstall the com_marvikshop_personal file. Of course you have to backup your own edits! After that you can use filezilla and notepad+ to delete the edits from the index files. After that upload the files back on the server. The best way is keep the 2 programs open. Because later you have to set the edits back in the files.
After upload the index.php files you can uninstall the com_marvikshop file. Otherwise you get some errors.
Now the program is complete deleted only the database tables are still there. Now you should download the last version of MarvikShop on our website then login the administrator area of your website and do the normal installation procedure.
Now after install the com_marvik_personal file you see the following screen. Do the edits on on the joomla index.php files and choose what version you want. A NEW database installation or an UPGRADE.
Note 2 : When you already got MarvikShop in your database and you do NEW database installation, you get some double rules in your database tables. Of course you can clean them in phpmyadmin. But better to do it right.
Upgrade is finished now.
For complete uninstallation do the following steps
2. Go to "Extensions => Install / Uninstall"
3. Under Components tab select the MarvikShop_Personal and click Uninstall button in the toolbar
4. Then delete the edits in your index.php files from the front and the admin.
6. Now you only have to delete the database tables begin with jos_osc_..
Joomla! Debug Console
{ "__default": { "session": { "counter": 1, "timer": { "start": 1711634770, "last": 1711634770, "now": 1711634770 }, "token": "TxTNrZPWjaxXLFUbDe3qLcYlTNkImNND" }, "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 }, "plg_system_languagefilter": { "language": "en-GB" } } }
Time
Memory
53 Queries Logged 97.22 ms
- Query Time: 0.46 ms Query memory: 0.023 MB Memory before query: 1.034 MB Rows returned: 0
SELECT `data`
FROM `mcyuk_session`
WHERE `session_id` = X'7465396c7337726e36736337746b726966386139737536637663'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.07 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.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Executing 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.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # 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 - Query Time: 0.36 ms After last query: 2.32 ms Query memory: 0.020 MB Memory before query: 1.049 MB Rows returned: 0
SELECT `session_id`
FROM `mcyuk_session`
WHERE `session_id` = X'7465396c7337726e36736337746b726966386139737536637663'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.06 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.05 ms Preparing 0.01 ms Executing 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.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # 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 - Query Time: 42.83 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.054 MB
INSERT INTO `mcyuk_session` (`session_id`,`guest`,`time`,`userid`,`username`)
VALUES (X'7465396c7337726e36736337746b726966386139737536637663', 1, 1711634770, 0, '')EXPLAIN not possible on query: INSERT INTO `mcyuk_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'7465396c7337726e36736337746b726966386139737536637663', 1, 1711634770, 0, '')Status Duration Starting 0.06 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 for update 0.03 ms Update 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 42.42 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 # 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 - Query Time: 6.23 ms After last query: 18.75 ms Query memory: 0.004 MB Memory before query: 1.247 MB
UPDATE `mcyuk_extensions`
SET `params` = '{\"mediaversion\":\"21ed9c2f7ec73bbd13cb5a47c875d8ee\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `mcyuk_extensions` SET `params` = '{\"mediaversion\":\"21ed9c2f7ec73bbd13cb5a47c875d8ee\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 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 for update 0.15 ms Updating 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 5.58 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 # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 6 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 5 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 4 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 3 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 2 Joomla\CMS\Factory::getDocument() JROOT/components/com_oscommerce/includes/application_top.php:24 1 include JROOT/components/com_oscommerce/includes/application_top.php JROOT/index.php:49 - Query Time: 0.61 ms After last query: 31.16 ms Query memory: 0.021 MB Memory before query: 1.466 MB Rows returned: 3
SELECT id, rules
FROM `mcyuk_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 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 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 # 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:53 - Query Time: 0.67 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 1.477 MB Rows returned: 1
SELECT b.id
FROM mcyuk_usergroups AS a
LEFT JOIN mcyuk_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 Using where Status Duration Starting 0.08 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.04 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 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 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 # 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:53 - Query Time: 0.58 ms After last query: 26.65 ms Query memory: 0.022 MB Memory before query: 1.926 MB Rows returned: 1
SELECT `value`
FROM `mcyuk_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_admintools_storage const PRIMARY PRIMARY 402 const 1 Status Duration Starting 0.11 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.07 ms Preparing 0.01 ms Unlocking tables 0.01 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 # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:122 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:49 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:278 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:866 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 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:53 - Query Time: 0.75 ms After last query: 1.06 ms Query memory: 0.021 MB Memory before query: 1.997 MB Rows returned: 0
SELECT `query`
FROM `mcyuk_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '' OR `option` = 'com_content')
AND (`view` IS NULL OR `view` = '' OR `view` = 'article')
GROUP BY `query`
ORDER BY `query` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_admintools_wafexceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary; Using filesort Status Duration Starting 0.11 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.05 ms Optimizing 0.05 ms Statistics 0.04 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.05 ms Removing tmp table 0.02 ms Creating sort index 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.03 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/plugins/system/admintools/admintools/main.php:668 10 plgSystemAdmintools->loadWAFExceptionsByOption() JROOT/plugins/system/admintools/admintools/main.php:506 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:875 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 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:53 - Query Time: 0.59 ms After last query: 24.62 ms Query memory: 0.022 MB Memory before query: 2.173 MB Rows returned: 27
SELECT `path`
FROM mcyuk_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_ignored ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 Using where Status Duration Starting 0.06 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.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.17 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 # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__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:53 - Query Time: 1.47 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 2.182 MB Rows returned: 0
SELECT `file`
FROM mcyuk_rsfirewall_hashes
WHERE `type`='protect'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 377 Using where 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.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.18 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 # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__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:53 - Query Time: 0.61 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 2.187 MB Rows returned: 67
SELECT *
FROM mcyuk_rsfirewall_configurationid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_configuration ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 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.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.31 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 # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__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:53 - Query Time: 1.43 ms After last query: 5.94 ms Query memory: 0.024 MB Memory before query: 2.387 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `mcyuk_rsfirewall_logs`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mcyuk_rsfirewall_logs`Status Duration Starting 0.05 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.59 ms After opening tables 0.01 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.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.16 ms closing tables 0.01 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.20 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 # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_rsfirewall/helpers/log.php:24 9 RSFirewallLogger->__construct() JROOT/administrator/components/com_rsfirewall/helpers/log.php:78 8 RSFirewallLogger::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:56 7 plgSystemRsfirewall->__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:53 - Query Time: 2.53 ms After last query: 13.56 ms Query memory: 0.039 MB Memory before query: 2.669 MB Rows returned: 315
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 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.02 ms Executing 0.01 ms Filling schema table 0.01 ms checking permissions 1.80 ms Executing 0.01 ms Sending data 0.21 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.01 ms closing tables 0.01 ms Unlocking tables 0.00 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 # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 13 JDatabaseDriverMysqli->getTableList() JROOT/administrator/components/com_acymailing/compat/joomla.php:724 12 acymailing_getTableList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:18 11 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:536 10 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:1080 9 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:26 8 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:19 7 plgSystemRegacymailing->__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:53 - Query Time: 0.47 ms After last query: 0.23 ms Query memory: 0.033 MB Memory before query: 2.711 MB Rows returned: 186
SELECT *
FROM mcyuk_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_acymailing_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 186 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.19 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 # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:628 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:23 11 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:536 10 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:1080 9 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:26 8 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:19 7 plgSystemRegacymailing->__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:53 - Query Time: 2.02 ms After last query: 45.14 ms Query memory: 0.022 MB Memory before query: 3.714 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"Status Duration Starting 0.05 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 1.63 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.00 ms Removing tmp table 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # 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:745 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 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:53 - Query Time: 0.56 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 3.722 MB Rows returned: 0
SELECT *
FROM `mcyuk_admintools_ipautoban`
WHERE `ip` = '54.173.214.79'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 Status Duration Starting 0.09 ms checking permissions 0.01 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.03 ms Statistics 0.07 ms Preparing 0.01 ms Executing 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.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/admintools/feature/autoipfiltering.php:74 11 AtsystemFeatureAutoipfiltering->isIPBlocked() JROOT/plugins/system/admintools/feature/autoipfiltering.php:23 10 AtsystemFeatureAutoipfiltering->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:745 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 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:53 - Query Time: 0.48 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 3.729 MB Rows returned: 1
SELECT *
FROM `mcyuk_admintools_storage`
WHERE `key` LIKE 'timestamp_%'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_admintools_storage range PRIMARY PRIMARY 402 NULL 1 Using where 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.02 ms Statistics 0.08 ms Preparing 0.03 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 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 # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/feature/abstract.php:269 12 AtsystemFeatureAbstract->loadTimestamps() JROOT/plugins/system/admintools/feature/abstract.php:349 11 AtsystemFeatureAbstract->getTimestamp() JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:113 10 AtsystemFeatureDisableobsoleteadmins->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:745 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 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:53 - Query Time: 0.68 ms After last query: 1.11 ms Query memory: 0.021 MB Memory before query: 3.740 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `mcyuk_admintools_redirects`
WHERE ((`dest` = 'index.php') OR (`dest` = 'index.php?option=com_content&view=article&id=18&Itemid=993&lang=en') OR ('index.php?option=com_content&view=article&id=18&Itemid=993&lang=en' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_admintools_redirects ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.12 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.10 ms Optimizing 0.05 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.06 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 # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:89 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:745 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 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:53 - Query Time: 0.94 ms After last query: 18.68 ms Query memory: 0.021 MB Memory before query: 3.902 MB Rows returned: 1
SELECT *
FROM `mcyuk_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('','com_content')
AND `view` IN('','article')
AND `task` IN('','article.')
AND `enabled` = '1'
GROUP BY `query`
ORDER BY `query` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_admintools_wafblacklists ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using temporary; Using filesort Status Duration Starting 0.12 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.08 ms Optimizing 0.05 ms Statistics 0.04 ms Preparing 0.03 ms Creating tmp table 0.10 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.12 ms Creating sort index 0.05 ms Removing tmp table 0.02 ms Creating sort index 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.02 ms Updating status 0.03 ms Reset for next command 0.05 ms # 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:87 10 AtsystemFeatureWafblacklist->onAfterRoute() JROOT/plugins/system/admintools/admintools/main.php:745 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:145 8 plgSystemAdmintools->onAfterRoute() 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:1190 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:53 - Query Time: 2.39 ms After last query: 0.79 ms Query memory: 0.021 MB Memory before query: 3.906 MB Rows returned: 2
SELECT *
FROM mcyuk_rsfirewall_hashes
WHERE (`type`='3.10.12' OR `type`='protect')
AND `flag`!='C'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 377 Using where Status Duration Starting 0.08 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.06 ms Optimizing 0.04 ms Statistics 0.04 ms Preparing 0.04 ms Executing 0.01 ms Sending data 1.86 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 # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:1068 8 plgSystemRsfirewall->onAfterRoute() 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:1190 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:53 - Query Time: 0.52 ms After last query: 0.75 ms Query memory: 0.021 MB Memory before query: 3.915 MB Rows returned: 0
SELECT *
FROM mcyuk_rsfirewall_snapshots
WHERE `type`='protect'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_snapshots ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.07 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.02 ms Statistics 0.03 ms Preparing 0.03 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.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 9 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1091 8 plgSystemRsfirewall->onAfterRoute() 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:1190 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:53 - Query Time: 0.39 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 3.921 MB Rows returned: 0
SELECT `ip`,`reason`
FROM mcyuk_rsfirewall_lists
WHERE (`ip`='54.173.214.79' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_lists ref published,type,ip published 1 const 1 Using where Status Duration Starting 0.05 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 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.00 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 # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:174 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:153 9 plgSystemRsfirewall->isWhitelisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1127 8 plgSystemRsfirewall->onAfterRoute() 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:1190 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:53 - Query Time: 0.35 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 3.926 MB Rows returned: 0
SELECT `ip`,`reason`
FROM mcyuk_rsfirewall_lists
WHERE (`ip`='54.173.214.79' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_lists ref published,type,ip published 1 const 1 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 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.05 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.01 ms closing tables 0.01 ms Unlocking tables 0.00 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 # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:174 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:143 9 plgSystemRsfirewall->isBlacklisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1131 8 plgSystemRsfirewall->onAfterRoute() 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:1190 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:53 - Query Time: 0.30 ms After last query: 0.42 ms Query memory: 0.021 MB Memory before query: 3.933 MB Rows returned: 0
SELECT *
FROM mcyuk_rsfirewall_exceptions
WHERE `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_rsfirewall_exceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where 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.01 ms Statistics 0.02 ms Preparing 0.01 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.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:719 9 plgSystemRsfirewall->isException() JROOT/plugins/system/rsfirewall/rsfirewall.php:1262 8 plgSystemRsfirewall->onAfterRoute() 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:1190 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:53 - Query Time: 0.94 ms After last query: 62.78 ms Query memory: 0.028 MB Memory before query: 4.670 MB Rows returned: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mcyuk_assets`
WHERE `name` IN ('root.1','com_acymailing','com_admin','com_admintools','com_aicontactsafe','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mysites','com_newsfeeds','com_oscommerce','com_oscommerce_personal','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_search','com_spiderfaq','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap','com_xtcronjob')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 161 Using where Status Duration Starting 0.11 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.06 ms Optimizing 0.02 ms Statistics 0.15 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.30 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.58 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 4.725 MB Rows returned: 34
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mcyuk_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 161 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 1.18 ms After last query: 2.50 ms Query memory: 0.031 MB Memory before query: 4.800 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `mcyuk_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mcyuk_content`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.39 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.25 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.14 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 4.27 ms After last query: 4.47 ms Query memory: 0.005 MB Memory before query: 4.923 MB
UPDATE mcyuk_content
SET `hits` = (`hits` + 1)
WHERE `id` = '18'EXPLAIN not possible on query: UPDATE mcyuk_content SET `hits` = (`hits` + 1) WHERE `id` = '18'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 for update 0.07 ms Updating 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 3.82 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 # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 1.26 ms After last query: 3.88 ms Query memory: 0.023 MB Memory before query: 4.965 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM mcyuk_content AS a
INNER JOIN mcyuk_categories AS c
on c.id = a.catid
LEFT JOIN mcyuk_users AS u
on u.id = a.created_by
LEFT JOIN mcyuk_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mcyuk_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 18
AND c.published > 0
AND a.language in ('en-GB','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 14:06:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 14:06:10')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.30 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.13 ms Optimizing 0.09 ms Statistics 0.26 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 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 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 # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 1.16 ms After last query: 6.54 ms Query memory: 0.028 MB Memory before query: 4.998 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mcyuk_categories` AS `s`
INNER JOIN `mcyuk_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 11
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 10 Using where; Using filesort Status Duration Starting 0.21 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.10 ms Optimizing 0.07 ms Statistics 0.21 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 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.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.74 ms After last query: 1.08 ms Query memory: 0.022 MB Memory before query: 5.022 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mcyuk_contentitem_tag_map` AS m
INNER JOIN `mcyuk_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 18
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 10 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 marvik_shop.m.tag_id 1 Using where Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.05 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 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 # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 2.87 ms After last query: 19.02 ms Query memory: 0.025 MB Memory before query: 5.182 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 mcyuk_fields AS a
LEFT JOIN `mcyuk_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mcyuk_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mcyuk_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mcyuk_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mcyuk_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mcyuk_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (11,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 marvik_shop.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 marvik_shop.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 marvik_shop.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 marvik_shop.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 marvik_shop.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.33 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.02 ms init 0.15 ms Optimizing 0.12 ms Statistics 0.30 ms Preparing 0.12 ms Creating tmp table 0.16 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.92 ms Creating sort index 0.06 ms Removing tmp table 0.20 ms Creating sort index 0.02 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.04 ms Reset for next command 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.94 ms After last query: 3.58 ms Query memory: 0.066 MB Memory before query: 5.323 MB Rows returned: 1
SELECT *
FROM mcyuk_spiderfaq_theme
WHERE id=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_spiderfaq_theme const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.12 ms Optimizing 0.05 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.18 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.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:114 16 plgContentLoadspiderfaq->_load() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:90 15 plgContentLoadspiderfaq->_process() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:58 14 plgContentLoadspiderfaq->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.45 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 5.343 MB Rows returned: 1
SELECT *
FROM mcyuk_spiderfaq_category
WHERE published='1'
AND id=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_spiderfaq_category const PRIMARY PRIMARY 4 const 1 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.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 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.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:130 16 plgContentLoadspiderfaq->_load() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:90 15 plgContentLoadspiderfaq->_process() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:58 14 plgContentLoadspiderfaq->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.28 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 5.352 MB Rows returned: 1
SELECT *
FROM mcyuk_spiderfaq_category
WHERE published='1'
AND id=2id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_spiderfaq_category const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 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.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 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.00 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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:130 16 plgContentLoadspiderfaq->_load() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:90 15 plgContentLoadspiderfaq->_process() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:58 14 plgContentLoadspiderfaq->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.68 ms After last query: 0.11 ms Query memory: 0.041 MB Memory before query: 5.361 MB Rows returned: 7
SELECT *
FROM mcyuk_spiderfaq
WHERE published='1'
AND category=1
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_spiderfaq ALL NULL NO INDEX KEY COULD BE USED NULL NULL 75 Using where; Using filesort 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.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.40 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.00 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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:150 16 plgContentLoadspiderfaq->_load() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:90 15 plgContentLoadspiderfaq->_process() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:58 14 plgContentLoadspiderfaq->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.43 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 5.393 MB Rows returned: 3
SELECT *
FROM mcyuk_spiderfaq
WHERE published='1'
AND category=2
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_spiderfaq ALL NULL NO INDEX KEY COULD BE USED NULL NULL 75 Using where; Using filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 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.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.13 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.00 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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:150 16 plgContentLoadspiderfaq->_load() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:90 15 plgContentLoadspiderfaq->_process() JROOT/plugins/content/loadspiderfaq/loadspiderfaq.php:58 14 plgContentLoadspiderfaq->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:53 - Query Time: 0.86 ms After last query: 43.51 ms Query memory: 0.021 MB Memory before query: 5.508 MB Rows returned: 4
SELECT language,id
FROM `mcyuk_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 182 Using where Status Duration Starting 0.08 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.03 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.27 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 # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->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:53 - Query Time: 0.91 ms After last query: 2.40 ms Query memory: 0.021 MB Memory before query: 5.529 MB Rows returned: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `mcyuk_content` AS `c`
INNER JOIN `mcyuk_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `mcyuk_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mcyuk_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `mcyuk_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 18
AND c2.access IN (1,1)
AND c2.language != 'en-GB'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-03-28 14:06:10')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-03-28 14:06:10')
AND c2.state = 1id 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 Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.09 ms Optimizing 0.11 ms Statistics 0.16 ms Preparing 0.01 ms Executing 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.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 7 PlgSystemLanguageFilter->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:53 - Query Time: 2.22 ms After last query: 5.83 ms Query memory: 0.048 MB Memory before query: 5.560 MB Rows returned: 28
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mcyuk_modules AS m
LEFT JOIN mcyuk_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mcyuk_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-03-28 14:06:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 14:06:10')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 993 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 102 Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 marvik_shop.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 marvik_shop.m.module,const 1 Using index condition; Using where Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.07 ms Statistics 0.15 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.46 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 # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 25 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 24 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 23 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 22 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 21 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/Modules.php:138 20 YOOtheme\Theme\Modules->countModules() Same as call in the line below. 19 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74 18 YOOtheme\View->__call() JROOT/templates/yootheme/templates/header-mobile.php:43 17 require JROOT/templates/yootheme/templates/header-mobile.php JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:249 16 YOOtheme\View->evaluate() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50 15 YOOtheme\Module->{closure}() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 14 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:114 13 YOOtheme\Theme->replace() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 12 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217 11 YOOtheme\View->render() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 9 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 8 Joomla\CMS\HTML\HTMLHelper::_() JROOT/templates/yootheme/index.php:40 7 require JROOT/templates/yootheme/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 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:53 - Query Time: 1.19 ms After last query: 27.34 ms Query memory: 0.041 MB Memory before query: 5.774 MB Rows returned: 371
SELECT guest, client_id
FROM mcyuk_session
WHERE client_id IS NULLid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_session ref client_id_guest client_id_guest 2 const 317 Using where; Using index 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.03 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.54 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.04 ms Reset for next command 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:45 11 ModWhosonlineHelper::getOnlineCount() JROOT/modules/mod_whosonline/mod_whosonline.php:19 10 include JROOT/modules/mod_whosonline/mod_whosonline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.85 ms After last query: 0.58 ms Query memory: 0.022 MB Memory before query: 5.805 MB Rows returned: 0
SELECT `a`.`username`,`a`.`userid`,`a`.`client_id`
FROM mcyuk_session AS a
WHERE `a`.`userid` != 0
AND `a`.`client_id` IS NULL
GROUP BY `a`.`username`,`a`.`userid`,`a`.`client_id`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range userid,client_id_guest userid 5 NULL 2 Using index condition; Using where; Using temporary; Using filesort 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.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.04 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.13 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 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.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:118 11 ModWhosonlineHelper::getOnlineUserNames() JROOT/modules/mod_whosonline/mod_whosonline.php:24 10 include JROOT/modules/mod_whosonline/mod_whosonline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.74 ms After last query: 3.26 ms Query memory: 0.022 MB Memory before query: 5.824 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.07 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.03 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.18 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_order_history/mod_marvikshop_order_history.php:22 10 include JROOT/modules/mod_marvikshop_order_history/mod_marvikshop_order_history.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.55 ms After last query: 3.27 ms Query memory: 0.022 MB Memory before query: 5.834 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.05 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.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_reviews/mod_marvikshop_reviews.php:23 10 include JROOT/modules/mod_marvikshop_reviews/mod_marvikshop_reviews.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.53 ms After last query: 3.00 ms Query memory: 0.022 MB Memory before query: 5.844 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.05 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.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_search/mod_marvikshop_search.php:23 10 include JROOT/modules/mod_marvikshop_search/mod_marvikshop_search.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.54 ms After last query: 2.77 ms Query memory: 0.022 MB Memory before query: 5.855 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.05 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.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_tell/mod_marvikshop_tell.php:23 10 include JROOT/modules/mod_marvikshop_tell/mod_marvikshop_tell.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.53 ms After last query: 2.54 ms Query memory: 0.022 MB Memory before query: 5.869 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.05 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.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_testimonials/mod_marvikshop_testimonials.php:23 10 include JROOT/modules/mod_marvikshop_testimonials/mod_marvikshop_testimonials.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.56 ms After last query: 3.15 ms Query memory: 0.022 MB Memory before query: 5.879 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.06 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 Executing 0.01 ms Sending data 0.13 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.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_manufacturers/mod_marvikshop_manufacturers.php:23 10 include JROOT/modules/mod_marvikshop_manufacturers/mod_marvikshop_manufacturers.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.53 ms After last query: 2.73 ms Query memory: 0.022 MB Memory before query: 5.890 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.05 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.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_manu_info/mod_marvikshop_manu_info.php:23 10 include JROOT/modules/mod_marvikshop_manu_info/mod_marvikshop_manu_info.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.57 ms After last query: 2.13 ms Query memory: 0.022 MB Memory before query: 5.899 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where 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 init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_bestseller/mod_marvikshop_bestseller.php:22 10 include JROOT/modules/mod_marvikshop_bestseller/mod_marvikshop_bestseller.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.54 ms After last query: 8.42 ms Query memory: 0.022 MB Memory before query: 5.924 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.06 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 Executing 0.01 ms Sending data 0.13 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_cart/mod_marvikshop_cart.php:22 10 include JROOT/modules/mod_marvikshop_cart/mod_marvikshop_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 0.52 ms After last query: 2.56 ms Query memory: 0.022 MB Memory before query: 5.939 MB Rows returned: 1
SELECT id
FROM mcyuk_menu
WHERE link LIKE 'index.php?option=com_oscommerce&view=shop%'
AND language='en-GB'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mcyuk_menu ref idx_language idx_language 28 const 22 Using index condition; Using where Status Duration Starting 0.05 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.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_oscommerce/includes/jlanguage.php:127 11 require JROOT/components/com_oscommerce/includes/jlanguage.php JROOT/modules/mod_marvikshop_featured/mod_marvikshop_featured.php:22 10 include JROOT/modules/mod_marvikshop_featured/mod_marvikshop_featured.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:53 - Query Time: 1.62 ms After last query: 66.65 ms Query memory: 0.025 MB Memory before query: 6.213 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mcyuk_categories` AS `s`
INNER JOIN `mcyuk_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 10 Using where; Using filesort Status Duration Starting 0.32 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.15 ms Optimizing 0.10 ms Statistics 0.31 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.07 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.19 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.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:173 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->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:53
39 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
10 × SELECT id
FROM mcyuk_menu2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `mcyuk_assets`2 × SELECT *
FROM mcyuk_spiderfaq2 × SELECT *
FROM mcyuk_spiderfaq_category2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mcyuk_categories` AS `s`
INNER JOIN `mcyuk_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)2 × SELECT `ip`,`reason`
FROM mcyuk_rsfirewall_lists1 × SELECT `path`
FROM mcyuk_rsfirewall_ignored1 × SELECT `value`
FROM `mcyuk_admintools_storage`1 × SELECT `a`.`username`,`a`.`userid`,`a`.`client_id`
FROM mcyuk_session AS a1 × SELECT guest, client_id
FROM mcyuk_session1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mcyuk_modules AS m
LEFT JOIN mcyuk_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mcyuk_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `mcyuk_content` AS `c`
INNER JOIN `mcyuk_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `mcyuk_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mcyuk_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `mcyuk_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT language,id
FROM `mcyuk_menu`1 × SELECT id, rules
FROM `mcyuk_viewlevels1 × SELECT b.id
FROM mcyuk_usergroups AS a
LEFT JOIN mcyuk_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM mcyuk_spiderfaq_theme1 × 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 mcyuk_fields AS a
LEFT JOIN `mcyuk_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mcyuk_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mcyuk_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mcyuk_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mcyuk_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mcyuk_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `m`.`tag_id`,`t`.*
FROM `mcyuk_contentitem_tag_map` AS m
INNER JOIN `mcyuk_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM mcyuk_content AS a
INNER JOIN mcyuk_categories AS c
on c.id = a.catid
LEFT JOIN mcyuk_users AS u
on u.id = a.created_by
LEFT JOIN mcyuk_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mcyuk_content_rating AS v
ON a.id = v.content_id1 × SELECT `file`
FROM mcyuk_rsfirewall_hashes1 × SELECT `query`
FROM `mcyuk_admintools_wafexceptions`1 × SELECT *
FROM mcyuk_rsfirewall_exceptions1 × SELECT `session_id`
FROM `mcyuk_session`1 × SELECT *
FROM mcyuk_rsfirewall_snapshots1 × SELECT *
FROM mcyuk_rsfirewall_hashes1 × SELECT *
FROM `mcyuk_admintools_wafblacklists`1 × SELECT `source`,`keepurlparams`
FROM `mcyuk_admintools_redirects`1 × SELECT *
FROM `mcyuk_admintools_storage`1 × SELECT *
FROM `mcyuk_admintools_ipautoban`1 × SELECT *
FROM mcyuk_acymailing_confi1 × SELECT *
FROM mcyuk_rsfirewall_configuratio1 × SELECT `data`
FROM `mcyuk_session`
OTHER Tables:
1 × INSERT INTO `mcyuk_session` (`session_id`,`guest`,`time`,`userid`,`username`)
VALUES (X'7465396c7337726e36736337746b726966386139737536637663', 1, 1711634770, 0, ''1 × UPDATE `mcyuk_extensions`
SET `params` = '{\"mediaversion\":\"21ed9c2f7ec73bbd13cb5a47c875d8ee\"}'1 × SHOW FULL COLUMNS
FROM `mcyuk_rsfirewall_logs1 × SHOW TABLE
1 × SHOW VARIABLES LIKE "collation_database
1 × SHOW FULL COLUMNS
FROM `mcyuk_content1 × UPDATE mcyuk_content
SET `hits` = (`hits` + 1)