Query Time: 0.30 ms Query memory: 0.023 MB Memory before query: 1.029 MB Rows returned: 0
SELECT `data`
FROM `zov5y_session`
WHERE `session_id` = X'326774683473687361313438373632386933616d6a7271673463'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zov5y_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | 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.23 ms After last query: 0.34 ms Query memory: 0.020 MB Memory before query: 1.043 MB Rows returned: 0
SELECT `session_id`
FROM `zov5y_session`
WHERE `session_id` = X'326774683473687361313438373632386933616d6a7271673463'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zov5y_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | 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: 0.76 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.048 MB
INSERT INTO `zov5y_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'326774683473687361313438373632386933616d6a7271673463', 1, 1726816626, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `zov5y_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'326774683473687361313438373632386933616d6a7271673463', 1, 1726816626, 0, '', 0)
No SHOW PROFILE (maybe because there are more than 100 queries)
# | 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: 0.26 ms After last query: 1.33 ms Query memory: 0.021 MB Memory before query: 1.122 MB Rows returned: 4
SELECT id, rules
FROM `zov5y_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zov5y_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.134 MB Rows returned: 1
SELECT b.id
FROM zov5y_usergroups AS a
LEFT JOIN zov5y_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 2.02 ms Query memory: 0.021 MB Memory before query: 1.514 MB Rows returned: 1
SELECT `custom_data`
FROM `zov5y_extensions`
WHERE `type` = 'component'
AND `element` = 'com_sef'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zov5y_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_sef/classes/config.php:752 |
10 | SEFConfig->__construct() | JROOT/administrator/components/com_sef/classes/config.php:954 |
9 | SEFConfig::getConfig() | JROOT/plugins/system/joomsef/joomsef.php:247 |
8 | plgSystemJoomsef->_isEnabled() | JROOT/plugins/system/joomsef/joomsef.php:31 |
7 | plgSystemJoomsef->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 17.89 ms Query memory: 0.005 MB Memory before query: 2.482 MB
UPDATE `zov5y_extensions`
SET `params` = '{\"mediaversion\":\"b68e61ec398d40768a7c84e453edecd3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `zov5y_extensions`
SET `params` = '{\"mediaversion\":\"b68e61ec398d40768a7c84e453edecd3\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 1.66 ms Query memory: 0.021 MB Memory before query: 2.594 MB Rows returned: 4
SELECT a.id, a.title
FROM zov5y_viewlevels AS a
GROUP BY a.id, a.title, a.ordering
ORDER BY `title` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_instantpaypal/framework/settings.php:182 |
9 | InstantpaypalSettings->__construct() | JROOT/administrator/components/com_instantpaypal/framework/settings.php:270 |
8 | InstantpaypalhelperSettings::_load() | JROOT/components/com_instantpaypal/controller.php:17 |
7 | InstantpaypalController->__construct() | JROOT/components/com_instantpaypal/instantpaypal.php:35 |
6 | require_once JROOT/components/com_instantpaypal/instantpaypal.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.39 ms After last query: 0.07 ms Query memory: 0.032 MB Memory before query: 2.602 MB Rows returned: 143
SELECT c.name, c.code
FROM zov5y_instantpaypal_currencies AS c
ORDER BY `c`.`code` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 143 | Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_instantpaypal/framework/settings.php:194 |
9 | InstantpaypalSettings->__construct() | JROOT/administrator/components/com_instantpaypal/framework/settings.php:270 |
8 | InstantpaypalhelperSettings::_load() | JROOT/components/com_instantpaypal/controller.php:17 |
7 | InstantpaypalController->__construct() | JROOT/components/com_instantpaypal/instantpaypal.php:35 |
6 | require_once JROOT/components/com_instantpaypal/instantpaypal.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 2.636 MB Rows returned: 1
SELECT `id`,`name`,`email`,`language_id`,`template_id`,`ty_title`,`ty_content`,`login_attempts`,`login_delay`,`updates`,`updates_checked`,`address`,`address2`,`city`,`country`,`postcode`,`taxid`,`params`,`timer`,`wiretransfer_details`
FROM `zov5y_instantpaypal_settings`
WHERE `id`='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zov5y_instantpaypal_settings | const | PRIMARY | PRIMARY | 1 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_instantpaypal/framework/db.php:136 |
11 | InstantpaypalDb->getData() | JROOT/administrator/components/com_instantpaypal/framework/db.php:366 |
10 | InstantpaypalDb->getObj() | JROOT/administrator/components/com_instantpaypal/framework/settings.php:207 |
9 | InstantpaypalSettings->getSettings() | JROOT/administrator/components/com_instantpaypal/framework/settings.php:271 |
8 | InstantpaypalhelperSettings::_load() | JROOT/components/com_instantpaypal/controller.php:17 |
7 | InstantpaypalController->__construct() | JROOT/components/com_instantpaypal/instantpaypal.php:35 |
6 | require_once JROOT/components/com_instantpaypal/instantpaypal.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.74 ms After last query: 1.18 ms Query memory: 0.022 MB Memory before query: 2.635 MB Rows returned: 1
SELECT `id`
FROM `zov5y_instantpaypal_templates`
WHERE `default`='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zov5y_instantpaypal_templates | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_instantpaypal/framework/db.php:354 |
10 | InstantpaypalDb->getResult() | JROOT/administrator/components/com_instantpaypal/framework/templates.php:100 |
9 | InstantpaypalTemplates->getDefault() | JROOT/components/com_instantpaypal/controller.php:63 |
8 | InstantpaypalController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_instantpaypal/instantpaypal.php:36 |
6 | require_once JROOT/components/com_instantpaypal/instantpaypal.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.642 MB Rows returned: 1
SELECT `id`,`name`,`alias`,`default`,`params`
FROM `zov5y_instantpaypal_templates`
WHERE `id`='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | zov5y_instantpaypal_templates | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_instantpaypal/framework/db.php:136 |
12 | InstantpaypalDb->getData() | JROOT/administrator/components/com_instantpaypal/framework/db.php:366 |
11 | InstantpaypalDb->getObj() | JROOT/administrator/components/com_instantpaypal/framework/templates.php:37 |
10 | InstantpaypalTemplates->getTemplate() | JROOT/administrator/components/com_instantpaypal/framework/templates.php:105 |
9 | InstantpaypalTemplates->getDefault() | JROOT/components/com_instantpaypal/controller.php:63 |
8 | InstantpaypalController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_instantpaypal/instantpaypal.php:36 |
6 | require_once JROOT/components/com_instantpaypal/instantpaypal.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.38 ms After last query: 5.91 ms Query memory: 0.022 MB Memory before query: 2.671 MB Rows returned: 4
SELECT a.id, a.title
FROM zov5y_viewlevels AS a
GROUP BY a.id, a.title, a.ordering
ORDER BY `title` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433 |
11 | InstantpaypalFoundation->loadAccessLevels() | JROOT/administrator/components/com_instantpaypal/framework/categories.php:61 |
10 | InstantpaypalCategories->__construct() | JROOT/components/com_instantpaypal/views/home/view.html.php:24 |
9 | InstantpaypalViewHome->display() | JROOT/components/com_instantpaypal/controller.php:72 |
8 | InstantpaypalController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_instantpaypal/instantpaypal.php:36 |
6 | require_once JROOT/components/com_instantpaypal/instantpaypal.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.67 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 2.677 MB Rows returned: 4
SELECT DISTINCT `z`.`id`
FROM `zov5y_instantpaypal_categories` AS `z`
WHERE `status`='1'
AND `featured`!='2'
ORDER BY `z`.`sort` ASC
LIMIT 0,999999
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | z | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
12 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_instantpaypal/framework/db.php:234 |
11 | InstantpaypalDb->getSearch() | JROOT/administrator/components/com_instantpaypal/framework/categories.php:93 |
10 | InstantpaypalCategories->getCategories() | JROOT/components/com_instantpaypal/views/home/view.html.php:25 |
9 | InstantpaypalViewHome->display() | JROOT/components/com_instantpaypal/controller.php:72 |
8 | InstantpaypalController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_instantpaypal/instantpaypal.php:36 |
6 | require_once JROOT/components/com_instantpaypal/instantpaypal.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.37 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 2.687 MB Rows returned: 1