Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1761420084,
                "last": 1761420084,
                "now": 1761420084
            }
        },
        "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
        },
        "fabrik": {
            "js": {
                "scripts": null,
                "head": {
                    "scripts": null,
                    "cache": {
                        "6666cd76f96956469e7be39d750cc7d9": "{\"\\\/media\\\/jui\\\/js\\\/jquery.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-noconflict.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-migrate.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/zoo\\\/assets\\\/js\\\/responsive.js?ver=20180425\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_zoo\\\/assets\\\/js\\\/default.js?ver=20180425\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"https:\\\/\\\/test.qprinstitute.com\\\/plugins\\\/content\\\/joomlalms_coursenav\\\/joomlalms_coursenav\\\/includes\\\/update_certificate_ajax.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/bootstrap\\\/js\\\/bootstrap.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/jquery.tap.min.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/script.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/menu.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/jquery.inview.min.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/jquery.parallax-1.1.3.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/jquery.placeholder.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/script.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/nav-collapse.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"https:\\\/\\\/test.qprinstitute.com\\\/media\\\/editors\\\/arkeditor\\\/js\\\/jquery.easing.min.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"framework\":false,\"relative\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"https:\\\/\\\/test.qprinstitute.com\\\/media\\\/editors\\\/arkeditor\\\/js\\\/squeezebox.min.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"framework\":false,\"relative\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/jquery-ui.min.js?vmver=1.9.2\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/jquery.ui.autocomplete.html.js\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/jquery.noconflict.js\":{\"mime\":\"text\\\/javascript\",\"async\":true,\"options\":[]},\"\\\/modules\\\/mod_virtuemart_cart\\\/assets\\\/js\\\/update_cart.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/chosen.jquery.min.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/vmprices.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"defer\":true,\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/vmsite.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"options\":[]}}"
                    }
                },
                "config": null,
                "shim": null,
                "jlayouts": null
            }
        }
    },
    "__vm": {
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false}"
    }
}

Profile Information

Time

Memory

Time: 21.20 ms / 21.20 ms Memory: 0.784 MB / 1.00 MB Application: afterLoad

Time: 106.88 ms / 128.08 ms Memory: 2.424 MB / 3.43 MB Application: afterInitialise

Time: 43.01 ms / 171.09 ms Memory: 1.348 MB / 4.78 MB Application: afterRoute

Time: 1.29 ms / 172.38 ms Memory: 0.208 MB / 4.98 MB Application: beforeRenderComponent com_zoo

Time: 12.73 ms / 185.12 ms Memory: 0.439 MB / 5.42 MB Application: Before Access::preloadComponents (all components)

Time: 0.65 ms / 185.77 ms Memory: 0.100 MB / 5.52 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 185.80 ms Memory: 0.000 MB / 5.52 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.75 ms / 186.55 ms Memory: 0.021 MB / 5.54 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 183.00 ms / 369.55 ms Memory: 3.995 MB / 9.53 MB Application: afterRenderComponent com_zoo

Time: 1.97 ms / 371.52 ms Memory: 0.026 MB / 9.56 MB Application: afterDispatch

Time: 9.04 ms / 380.56 ms Memory: 0.193 MB / 9.75 MB Application: beforeRenderModule mod_virtuemart_cart (VM - Shopping cart)

Time: 15.79 ms / 396.35 ms Memory: 0.273 MB / 10.02 MB Application: Before Access::getAssetRules (id:161 name:com_virtuemart)

Time: 0.03 ms / 396.38 ms Memory: 0.003 MB / 10.03 MB Application: After Access::getAssetRules (id:161 name:com_virtuemart)

Time: 51.97 ms / 448.36 ms Memory: 2.636 MB / 12.66 MB Application: afterRenderModule mod_virtuemart_cart (VM - Shopping cart)

Time: 0.03 ms / 448.39 ms Memory: 0.000 MB / 12.66 MB Application: beforeRenderModule mod_virtuemart_search (VM - Search in Shop)

Time: 1.03 ms / 449.41 ms Memory: 0.017 MB / 12.68 MB Application: afterRenderModule mod_virtuemart_search (VM - Search in Shop)

Time: 0.02 ms / 449.44 ms Memory: 0.000 MB / 12.67 MB Application: beforeRenderModule mod_virtuemart_product (VM - Featured products)

Time: 4.13 ms / 453.56 ms Memory: 0.104 MB / 12.78 MB Application: afterRenderModule mod_virtuemart_product (VM - Featured products)

Time: 0.02 ms / 453.58 ms Memory: 0.000 MB / 12.77 MB Application: beforeRenderModule mod_virtuemart_category (VM - Category)

Time: 2.97 ms / 456.55 ms Memory: 0.105 MB / 12.88 MB Application: afterRenderModule mod_virtuemart_category (VM - Category)

Time: 0.02 ms / 456.57 ms Memory: 0.000 MB / 12.87 MB Application: beforeRenderModule mod_virtuemart_currencies (VM - Currencies Selector)

Time: 1.62 ms / 458.19 ms Memory: 0.034 MB / 12.91 MB Application: afterRenderModule mod_virtuemart_currencies (VM - Currencies Selector)

Time: 0.02 ms / 458.21 ms Memory: 0.000 MB / 12.90 MB Application: beforeRenderModule mod_virtuemart_manufacturer (VM - Manufacturer)

Time: 3.82 ms / 462.03 ms Memory: 0.183 MB / 13.09 MB Application: afterRenderModule mod_virtuemart_manufacturer (VM - Manufacturer)

Time: 0.11 ms / 462.14 ms Memory: 0.000 MB / 13.08 MB Application: beforeRenderModule mod_custom (Continuing Education Credit)

Time: 0.71 ms / 462.85 ms Memory: 0.013 MB / 13.10 MB Application: afterRenderModule mod_custom (Continuing Education Credit)

Time: 0.09 ms / 462.94 ms Memory: 0.000 MB / 13.09 MB Application: beforeRenderModule mod_jlms_menu (MOD_JLMS_MENU)

Time: 0.97 ms / 463.90 ms Memory: 0.018 MB / 13.11 MB Application: afterRenderModule mod_jlms_menu (MOD_JLMS_MENU)

Time: 0.08 ms / 463.98 ms Memory: 0.000 MB / 13.11 MB Application: beforeRenderModule mod_custom (Top Bar)

Time: 0.17 ms / 464.15 ms Memory: 0.008 MB / 13.11 MB Application: afterRenderModule mod_custom (Top Bar)

Time: 18.75 ms / 482.90 ms Memory: 0.570 MB / 13.68 MB Application: afterRender

Database queries total: 19.19 ms

Memory Usage

Database Queries

68 Queries Logged 19.19 ms

8 duplicate found!

2 duplicates: #2 #23

2 duplicates: #59 #60

2 duplicates: #63 #65

2 duplicates: #66 #68

Query Time: 0.25 ms Query memory: 0.021 MB Memory before query: 1.550 MB Rows returned: 0

SELECT `data`

  FROM `jgpqv_session`

  WHERE `session_id` = 'b7d25311c00ec65aacd33aa00a7f476d'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_session	const	PRIMARY	PRIMARY	766	const	1

Profile

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.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:764
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:144
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:352
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.13 ms After last query: 1.62 ms Query memory: 0.013 MB Memory before query: 1.604 MB Rows returned: 0

Duplicate queries: #23

SELECT `session_id`

  FROM `jgpqv_session`

  WHERE `session_id` = 'b7d25311c00ec65aacd33aa00a7f476d' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:161
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:766
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:144
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:352
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.43 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 1.621 MB

INSERT INTO `jgpqv_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('b7d25311c00ec65aacd33aa00a7f476d', 1, '1761420084', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jgpqv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b7d25311c00ec65aacd33aa00a7f476d', 1, '1761420084', 0, '', 0)

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.27 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:161
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:766
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:144
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:352
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.32 ms After last query: 4.03 ms Query memory: 0.030 MB Memory before query: 1.700 MB Rows returned: 45

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

  FROM `jgpqv_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 3.50 ms Query memory: 0.015 MB Memory before query: 1.823 MB Rows returned: 7

SELECT id, rules

  FROM `jgpqv_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:310
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:606
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.13 ms Query memory: 0.015 MB Memory before query: 1.848 MB Rows returned: 2

SELECT b.id

  FROM jgpqv_usergroups AS a

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

  WHERE a.id = 14

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:310
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:606
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 1.01 ms Query memory: 0.022 MB Memory before query: 1.887 MB Rows returned: 174

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

  FROM jgpqv_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.41 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
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:606
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 31.95 ms Query memory: 0.015 MB Memory before query: 2.855 MB Rows returned: 1

SELECT count(1)

  FROM `jgpqv_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

Explain

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

Profile

Status	Duration
Starting	0.05 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.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
9	plgSystemARKtypography->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 40.76 ms Query memory: 0.041 MB Memory before query: 3.508 MB Rows returned: 82

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jgpqv_menu AS m

  LEFT JOIN jgpqv_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	98	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	qprtest_qpr_courses.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.40 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:383
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:497
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1079
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 29.40 ms Query memory: 0.026 MB Memory before query: 4.423 MB Rows returned: 1

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

  FROM `jgpqv_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
9	plgSystemARKtypography->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1089
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.21 ms Query memory: 0.018 MB Memory before query: 4.431 MB

UPDATE `jgpqv_extensions`

  SET `params` = '{\"mediaversion\":\"fe275440b9a32049fbe424fe7f6ce42a\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.17 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
9	plgSystemARKtypography->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1089
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 2.62 ms Query memory: 0.015 MB Memory before query: 4.510 MB Rows returned: 1

SELECT params

  FROM `jgpqv_extensions`

  WHERE `element` = 'com_arkeditor' 
  AND `type` = 'component'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
9	plgSystemARKtypography->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1089
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 1.94 ms Query memory: 0.018 MB Memory before query: 4.574 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM jgpqv_template_styles as s

  LEFT JOIN jgpqv_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
9	plgSystemT3->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1089
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 3.85 ms Query memory: 0.014 MB Memory before query: 4.781 MB Rows returned: 1

SELECT *

  FROM jgpqv_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 6.98 ms Query memory: 0.020 MB Memory before query: 5.198 MB Rows returned: 1

SELECT * 
  FROM jgpqv_zoo_application 
  WHERE id = 2

Explain

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

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
9	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 6.68 ms Query memory: 0.030 MB Memory before query: 5.431 MB Rows returned: 39

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

  FROM `jgpqv_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_arkeditor','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dashboard','com_fabrik','com_finder','com_installer','com_jaextmanager','com_jce','com_jlms_certificates','com_jlmsvm_integration','com_joomla_lms','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsappt_pro3','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_wrapper','com_zoo')

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
14	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
13	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:217
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 2.17 ms Query memory: 0.021 MB Memory before query: 5.574 MB


  SET SESSION group_concat_max_len = 1048576

Explain

EXPLAIN not possible on query: SET SESSION group_concat_max_len = 1048576

Profile

Status	Duration
Starting	0.02 ms
Opening tables	0.00 ms
After opening tables	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:183
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.61 ms Query memory: 0.029 MB Memory before query: 5.609 MB Rows returned: 0

SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM jgpqv_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN jgpqv_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN jgpqv_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1,5) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-25 19:21:24') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-25 19:21:24') 
  WHERE c.application_id = 2 
  AND c.published = 1 
  GROUP BY c.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	APPLICATIONID_ID_INDEX	APPLICATIONID_ID_INDEX	5	const,const	1	Using where
1	SIMPLE	ci	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	qprtest_qpr_courses.c.id	1	Using index
1	SIMPLE	i	ref	MULTI_INDEX2	MULTI_INDEX2	4	qprtest_qpr_courses.ci.item_id	1	Using where; Using index

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
18	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
17	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
16	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:209
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.38 ms After last query: 2.99 ms Query memory: 0.052 MB Memory before query: 5.704 MB Rows returned: 20

SELECT a.* 
  FROM jgpqv_zoo_item AS a 
  LEFT JOIN jgpqv_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-10-25 19:21:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-10-25 19:21:24') 
  AND b.category_id  = 0 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.name 
  LIMIT 0,20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	MULTI_INDEX	14	NULL	15	Using index condition; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,qprtest_qpr_courses.a.id	1	Using index

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.62 ms
Creating sort index	0.29 ms
Removing tmp table	0.16 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
14	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
13	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:238
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 4.02 ms Query memory: 0.021 MB Memory before query: 6.488 MB Rows returned: 21

SELECT a.id 
  FROM jgpqv_zoo_item AS a 
  LEFT JOIN jgpqv_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 0 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-10-25 19:21:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-10-25 19:21:24') 
  GROUP BY a.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	MULTI_INDEX	14	NULL	15	Using index condition; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,qprtest_qpr_courses.a.id	1	Using index

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.16 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
13	ItemTable->getItemCountFromCategory()	JROOT/components/com_zoo/controllers/default.php:239
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 47.92 ms Query memory: 0.047 MB Memory before query: 7.609 MB Rows returned: 153

SELECT * 
  FROM jgpqv_lms_config

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 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.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
32	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomla_lms/includes/classes/lms.config.php:55
31	JLMS_Config->initConfig()	JROOT/components/com_joomla_lms/includes/classes/lms.config.php:10
30	JLMS_Config->__construct()	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:75
29	JLMSFactory::_createConfig()	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17
28	JLMSFactory::getConfig()	JROOT/components/com_joomla_lms/joomla_lms.main.php:27
27	require_once JROOT/components/com_joomla_lms/joomla_lms.main.php	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:82
26	plgContentJoomlaLMS_CourseProgress->onPrepareContent()	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:46
25	plgContentJoomlaLMS_CourseProgress->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
17	ZooHelper->triggerContentPlugins()	JROOT/administrator/components/com_zoo/classes/application.php:793
16	Application->getText()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:80
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 1.27 ms Query memory: 0.042 MB Memory before query: 7.698 MB Rows returned: 0

SELECT cb_assoc AS profile_var, CONCAT('lms_cb_assoc', id) AS var_name, field_name AS lang_var 
  FROM jgpqv_lms_cb_assoc 
  ORDER BY id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_lms_cb_assoc	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
32	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomla_lms/legacy/includes/config_inc_base.php:95
31	LMS\Legacy\Includes\Config_Inc_Base::init()	JROOT/components/com_joomla_lms/includes/config.inc.php:9
30	require JROOT/components/com_joomla_lms/includes/config.inc.php	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:76
29	JLMSFactory::_createConfig()	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17
28	JLMSFactory::getConfig()	JROOT/components/com_joomla_lms/joomla_lms.main.php:27
27	require_once JROOT/components/com_joomla_lms/joomla_lms.main.php	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:82
26	plgContentJoomlaLMS_CourseProgress->onPrepareContent()	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:46
25	plgContentJoomlaLMS_CourseProgress->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
17	ZooHelper->triggerContentPlugins()	JROOT/administrator/components/com_zoo/classes/application.php:793
16	Application->getText()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:80
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.49 ms Query memory: 0.050 MB Memory before query: 7.761 MB Rows returned: 1

Duplicate queries: #2

SELECT `session_id`

  FROM `jgpqv_session`

  WHERE `session_id` = 'b7d25311c00ec65aacd33aa00a7f476d' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
39	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
38	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:161
37	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:766
36	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:144
35	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
34	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_joomla_lms/includes/classes/lms.config.php:86
33	JLMS_Config->getItemid()	JROOT/components/com_joomla_lms/includes/classes/lms.config.php:142
32	JLMS_Config->get()	JROOT/components/com_joomla_lms/legacy/includes/config_inc_base.php:174
31	LMS\Legacy\Includes\Config_Inc_Base::init()	JROOT/components/com_joomla_lms/includes/config.inc.php:9
30	require JROOT/components/com_joomla_lms/includes/config.inc.php	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:76
29	JLMSFactory::_createConfig()	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17
28	JLMSFactory::getConfig()	JROOT/components/com_joomla_lms/joomla_lms.main.php:27
27	require_once JROOT/components/com_joomla_lms/joomla_lms.main.php	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:82
26	plgContentJoomlaLMS_CourseProgress->onPrepareContent()	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:46
25	plgContentJoomlaLMS_CourseProgress->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
17	ZooHelper->triggerContentPlugins()	JROOT/administrator/components/com_zoo/classes/application.php:793
16	Application->getText()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:80
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.17 ms Query memory: 0.044 MB Memory before query: 7.808 MB Rows returned: 1

SELECT id 
  FROM jgpqv_menu 
  WHERE link LIKE '%index.php?option=com_joomla_lms%' 
  AND type = 'component' 
  AND published = 1 
  AND client_id = 0 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	99	Using where

Profile

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

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
34	JDatabaseDriver->loadResult()	JROOT/components/com_joomla_lms/includes/classes/lms.config.php:122
33	JLMS_Config->getItemid()	JROOT/components/com_joomla_lms/includes/classes/lms.config.php:142
32	JLMS_Config->get()	JROOT/components/com_joomla_lms/legacy/includes/config_inc_base.php:174
31	LMS\Legacy\Includes\Config_Inc_Base::init()	JROOT/components/com_joomla_lms/includes/config.inc.php:9
30	require JROOT/components/com_joomla_lms/includes/config.inc.php	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:76
29	JLMSFactory::_createConfig()	JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17
28	JLMSFactory::getConfig()	JROOT/components/com_joomla_lms/joomla_lms.main.php:27
27	require_once JROOT/components/com_joomla_lms/joomla_lms.main.php	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:82
26	plgContentJoomlaLMS_CourseProgress->onPrepareContent()	JROOT/plugins/content/joomlalms_courseprogress/joomlalms_courseprogress.php:46
25	plgContentJoomlaLMS_CourseProgress->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
17	ZooHelper->triggerContentPlugins()	JROOT/administrator/components/com_zoo/classes/application.php:793
16	Application->getText()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:80
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 11.45 ms Query memory: 0.045 MB Memory before query: 8.299 MB Rows returned: 1

SELECT * 
  FROM jgpqv_zoo_category 
  WHERE id = 5

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
32	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
31	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
30	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
29	AppTable->get()	JROOT/administrator/components/com_zoo/classes/item.php:577
28	Item->getPrimaryCategory()	JROOT/administrator/components/com_zoo/helpers/route.php:310
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 1.14 ms Query memory: 0.042 MB Memory before query: 8.371 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=5 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=5 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 10.95 ms Query memory: 0.042 MB Memory before query: 8.604 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=20 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=20 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 5.03 ms Query memory: 0.042 MB Memory before query: 8.655 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=13 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=13 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 4.81 ms Query memory: 0.042 MB Memory before query: 8.706 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=9 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=9 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 4.86 ms Query memory: 0.042 MB Memory before query: 8.758 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=18 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=18 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 4.79 ms Query memory: 0.042 MB Memory before query: 8.809 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=65 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=65 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 9.40 ms Query memory: 0.042 MB Memory before query: 8.883 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=71 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=71 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 5.05 ms Query memory: 0.042 MB Memory before query: 8.934 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=63 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=63 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 4.84 ms Query memory: 0.042 MB Memory before query: 8.985 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=7 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=7 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 4.86 ms Query memory: 0.042 MB Memory before query: 9.036 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=8 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=8 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 8.96 ms Query memory: 0.042 MB Memory before query: 9.110 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=69 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=69 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 5.17 ms Query memory: 0.042 MB Memory before query: 9.161 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=10 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=10 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 5.15 ms Query memory: 0.042 MB Memory before query: 9.275 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=19 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=19 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 5.09 ms Query memory: 0.042 MB Memory before query: 9.326 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=12 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=12 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 5.05 ms Query memory: 0.042 MB Memory before query: 9.375 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=70 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=70 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:21
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 4.72 ms Query memory: 0.042 MB Memory before query: 9.425 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=14 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=14 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 5.21 ms Query memory: 0.042 MB Memory before query: 9.492 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=64 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=64 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 4.98 ms Query memory: 0.042 MB Memory before query: 9.541 MB Rows returned: 1

SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=66 
  AND b.published = 1 UNION SELECT 0 
  FROM jgpqv_zoo_category_item AS a 
  WHERE a.item_id=66 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2
1	PRIMARY	b	eq_ref\|filter	PRIMARY,PUBLISHED_INDEX	PRIMARY\|PUBLISHED_INDEX	4\|1	qprtest_qpr_courses.a.category_id	1 (60%)	Using where; Using rowid filter
2	UNION	a	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	Using index
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/cookbook/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/cookbook/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/cookbook/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/_items.php:33
17	include JROOT/media/zoo/applications/cookbook/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php:136
15	include JROOT/media/zoo/applications/cookbook/templates/default/frontpage.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 11.27 ms Query memory: 0.027 MB Memory before query: 9.679 MB Rows returned: 18

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jgpqv_modules AS m

  LEFT JOIN jgpqv_modules_menu AS mm 
  ON mm.moduleid = m.id

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-10-25 19:21:24') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-25 19:21:24') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	37	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	qprtest_qpr_courses.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	qprtest_qpr_courses.m.id	2	Using where; Using index

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:645
10	T3Template->countModules()	JROOT/templates/uber/tpls/default-bookstore.php:18
9	include JROOT/templates/uber/tpls/default-bookstore.php	JROOT/plugins/system/t3/includes/core/template.php:221
8	T3Template->loadLayout()	JROOT/templates/uber/index.php:34
7	require JROOT/templates/uber/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1036
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 18.51 ms Query memory: 0.022 MB Memory before query: 9.946 MB Rows returned: 1

SHOW TABLES LIKE "jgpqv_virtuemart_configs"

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE "jgpqv_virtuemart_configs"

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
checking permissions	0.58 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:717
13	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:573
12	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:940
11	VmConfig::loadConfig()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:14
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.09 ms Query memory: 0.018 MB Memory before query: 9.967 MB Rows returned: 1

SELECT `config` 
  FROM `jgpqv_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_virtuemart_configs	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 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.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:988
11	VmConfig::loadConfig()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:14
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 10.57 ms Query memory: 0.028 MB Memory before query: 10.433 MB Rows returned: 1

SELECT * 
  FROM `jgpqv_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:133
11	VirtueMartCart::getCart()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.20 ms Query memory: 0.031 MB Memory before query: 10.504 MB Rows returned: 1

SELECT `jgpqv_virtuemart_shoppergroups`.*  
  FROM `jgpqv_virtuemart_shoppergroups`  
  WHERE `jgpqv_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1036
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:133
11	VirtueMartCart::getCart()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 17.82 ms Query memory: 0.035 MB Memory before query: 10.870 MB Rows returned: 0

SELECT *  
  FROM `jgpqv_virtuemart_currencies` AS c
			
  LEFT JOIN `jgpqv_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
18	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
17	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1561
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 4.36 ms Query memory: 0.039 MB Memory before query: 11.070 MB Rows returned: 31

SHOW FULL COLUMNS  
  FROM `jgpqv_virtuemart_userfields`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.24 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.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.07 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:678
25	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
24	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:221
23	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434
22	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396
21	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602
20	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:52
19	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554
18	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:256
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1561
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.24 ms Query memory: 0.042 MB Memory before query: 11.170 MB Rows returned: 21

SELECT * 
  FROM `jgpqv_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`="1" 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type') = 0  
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_virtuemart_userfields	ALL	published,account	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.10 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:619
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:504
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:267
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1561
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.43 ms Query memory: 0.028 MB Memory before query: 11.349 MB Rows returned: 2

SELECT `fieldtitle`, `fieldvalue` 
  FROM `jgpqv_virtuemart_userfield_values` 
  WHERE `virtuemart_userfield_id` = 23 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_virtuemart_userfield_values	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	Using where; Using filesort

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1044
18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:272
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1561
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 2.23 ms Query memory: 0.060 MB Memory before query: 11.473 MB Rows returned: 246

SELECT * 
  FROM `jgpqv_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY country_name ASC

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.26 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859
21	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
20	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
19	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:857
18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:272
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1561
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 4.19 ms Query memory: 0.041 MB Memory before query: 12.254 MB Rows returned: 14

SELECT * 
  FROM `jgpqv_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `shipment`="1" 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jgpqv_virtuemart_userfields	ALL	published,shipment	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:619
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:510
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:267
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1561
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 2.94 ms Query memory: 0.030 MB Memory before query: 12.485 MB Rows returned: 0

SELECT c.* 
  FROM jgpqv_virtuemart_calcs as c  
  LEFT JOIN jgpqv_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id  
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-25 19:21:24" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-25 19:21:24" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172
16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1561
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.09 ms Query memory: 0.030 MB Memory before query: 12.517 MB Rows returned: 0

SELECT * 
  FROM jgpqv_virtuemart_calcs  
  LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-25 19:21:24" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-25 19:21:24" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:740
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1565
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 12.540 MB Rows returned: 0

SELECT * 
  FROM jgpqv_virtuemart_calcs  
  LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-25 19:21:24" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-25 19:21:24" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:741
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1565
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 12.563 MB Rows returned: 0

SELECT * 
  FROM jgpqv_virtuemart_calcs  
  LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-25 19:21:24" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-25 19:21:24" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:742
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1565
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1664
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1792
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 10.23 ms Query memory: 0.026 MB Memory before query: 12.773 MB Rows returned: 0

Duplicate queries: #60

SELECT  p.`virtuemart_product_id` 
		
  FROM `jgpqv_virtuemart_products` as p  
 
  LEFT JOIN `jgpqv_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 
  LEFT JOIN `jgpqv_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
 
  LEFT JOIN `jgpqv_virtuemart_product_prices` as pp 
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
 
  WHERE ( ((p.`product_parent_id` > "0" 
  AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND p.`product_special`="1"  
  AND  p.`published`="1" ) 

  group by p.`virtuemart_product_id` 

  ORDER BY RAND() 
  LIMIT 0, 2

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
17	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:772
16	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
15	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:33
14	mod_virtuemart_product_helper::getProductsListing()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:89
10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 12.778 MB Rows returned: 0

Duplicate queries: #59

SELECT  p.`virtuemart_product_id` 
		
  FROM `jgpqv_virtuemart_products` as p  
 
  LEFT JOIN `jgpqv_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 
  LEFT JOIN `jgpqv_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
 
  LEFT JOIN `jgpqv_virtuemart_product_prices` as pp 
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
 
  WHERE ( ((p.`product_parent_id` > "0" 
  AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND p.`product_special`="1"  
  AND  p.`published`="1" ) 

  group by p.`virtuemart_product_id` 

  ORDER BY RAND() 
  LIMIT 0, 2

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:772
12	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
11	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:101
10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 4.08 ms Query memory: 0.019 MB Memory before query: 12.898 MB Rows returned: 0

SELECT `vendor_accepted_currencies`, `vendor_currency` 
  FROM `jgpqv_virtuemart_vendors` 
  WHERE `virtuemart_vendor_id`=1

Explain

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

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/models/currency.php:110
11	VirtueMartModelCurrency->getVendorAcceptedCurrrenciesList()	JROOT/modules/mod_virtuemart_currencies/mod_virtuemart_currencies.php:45
10	include JROOT/modules/mod_virtuemart_currencies/mod_virtuemart_currencies.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 2.41 ms Query memory: 0.024 MB Memory before query: 13.009 MB Rows returned: 0

SELECT  `m`.*, l.mf_name, l.mf_email, l.mf_desc, l.mf_url, l.slug,  mc.`mf_category_name`,mmex.virtuemart_media_id  
  FROM `jgpqv_virtuemart_manufacturers` as m 
  LEFT JOIN `jgpqv_virtuemart_manufacturers_en_gb` as l 
  ON l.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id` 
  LEFT JOIN `jgpqv_virtuemart_manufacturercategories_en_gb` AS mc 
  on  mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id` 
  LEFT JOIN `jgpqv_virtuemart_manufacturer_medias` as mmex 
  ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id` 
 
  WHERE  `m`.`published` = 1 
 
  GROUP BY `m`.`virtuemart_manufacturer_id` 
 
  ORDER BY mf_name ASC

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859
12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:185
11	VirtueMartModelManufacturer->getManufacturers()	JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php:30
10	include JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 13.25 ms Query memory: 0.024 MB Memory before query: 13.580 MB Rows returned: 1

Duplicate queries: #65

SELECT `alias`

  FROM `jgpqv_content`

  WHERE id = '384'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	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:1056
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 1.12 ms Query memory: 0.032 MB Memory before query: 13.622 MB Rows returned: 0

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 `jgpqv_categories` AS `s`

  INNER JOIN `jgpqv_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 384

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	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:1056
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 13.646 MB Rows returned: 1

Duplicate queries: #63

SELECT `alias`

  FROM `jgpqv_content`

  WHERE id = '384'

Explain

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

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
19	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
18	ContentRouter->getArticleSegment()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
16	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
15	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
14	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:480
13	Joomla\CMS\Router\SiteRouter->buildRawRoute()	JROOT/libraries/src/Router/Router.php:512
12	Joomla\CMS\Router\Router->_buildRawRoute()	JROOT/libraries/src/Router/Router.php:275
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	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:1056
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.27 ms Query memory: 0.024 MB Memory before query: 13.671 MB Rows returned: 1

Duplicate queries: #68

SELECT `alias`

  FROM `jgpqv_content`

  WHERE id = '386'

Explain

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

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	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:1056
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 13.698 MB Rows returned: 0

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 `jgpqv_categories` AS `s`

  INNER JOIN `jgpqv_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 386

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	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:1056
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 13.720 MB Rows returned: 1

Duplicate queries: #66

SELECT `alias`

  FROM `jgpqv_content`

  WHERE id = '386'

Explain

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

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
19	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
18	ContentRouter->getArticleSegment()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
16	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
15	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
14	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:480
13	Joomla\CMS\Router\SiteRouter->buildRawRoute()	JROOT/libraries/src/Router/Router.php:512
12	Joomla\CMS\Router\Router->_buildRawRoute()	JROOT/libraries/src/Router/Router.php:275
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	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:1056
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

18 × SELECT b.id 
  FROM jgpqv_zoo_category_item AS a JOIN jgpqv_zoo_category AS b 
  ON a.category_id = b.id

4 × SELECT `alias` 
  FROM `jgpqv_content`

3 × SELECT * 
  FROM jgpqv_virtuemart_calcs  
  LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

2 × SELECT  p.`virtuemart_product_id`    
  FROM `jgpqv_virtuemart_products` as p    
  LEFT JOIN `jgpqv_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`    
  LEFT JOIN `jgpqv_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`    
  LEFT JOIN `jgpqv_virtuemart_product_prices` as pp 
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`

2 × SELECT * 
  FROM `jgpqv_virtuemart_userfields`

2 × SELECT `session_id` 
  FROM `jgpqv_session`

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 `jgpqv_categories` AS `s` 
  INNER JOIN `jgpqv_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

1 × SELECT `jgpqv_virtuemart_shoppergroups`.*  
  FROM `jgpqv_virtuemart_shoppergroups`

1 × SELECT * 
  FROM `jgpqv_virtuemart_shoppergroups`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jgpqv_modules AS m 
  LEFT JOIN jgpqv_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jgpqv_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT *  
  FROM `jgpqv_virtuemart_currencies` AS c    
  LEFT JOIN `jgpqv_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 × SELECT `config` 
  FROM `jgpqv_virtuemart_configs`

1 × SELECT c.* 
  FROM jgpqv_virtuemart_calcs as c  
  LEFT JOIN jgpqv_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT  `m`.*, l.mf_name, l.mf_email, l.mf_desc, l.mf_url, l.slug,  mc.`mf_category_name`,mmex.virtuemart_media_id  
  FROM `jgpqv_virtuemart_manufacturers` as m 
  LEFT JOIN `jgpqv_virtuemart_manufacturers_en_gb` as l 
  ON l.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id` 
  LEFT JOIN `jgpqv_virtuemart_manufacturercategories_en_gb` AS mc 
  on  mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id` 
  LEFT JOIN `jgpqv_virtuemart_manufacturer_medias` as mmex 
  ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id`

1 × SELECT `vendor_accepted_currencies`, `vendor_currency` 
  FROM `jgpqv_virtuemart_vendors`

1 × SELECT * 
  FROM jgpqv_zoo_category

1 × SELECT * 
  FROM `jgpqv_virtuemart_countries`

1 × SELECT `fieldtitle`, `fieldvalue` 
  FROM `jgpqv_virtuemart_userfield_values`

1 × SELECT cb_assoc AS profile_var, CONCAT('lms_cb_assoc', id) AS var_name, field_name AS lang_var 
  FROM jgpqv_lms_cb_assoc

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jgpqv_menu AS m 
  LEFT JOIN jgpqv_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT params 
  FROM `jgpqv_extensions`

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

1 × SELECT count(1) 
  FROM `jgpqv_session`

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

1 × SELECT id, rules 
  FROM `jgpqv_viewlevels

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

```
1 × SELECT * 
  FROM jgpqv_languages
```

1 × SELECT * 
  FROM jgpqv_zoo_application

```
1 × SELECT * 
  FROM jgpqv_lms_confi
```

1 × SELECT `data` 
  FROM `jgpqv_session`

1 × SELECT a.id 
  FROM jgpqv_zoo_item AS a 
  LEFT JOIN jgpqv_zoo_category_item AS b 
  ON a.id = b.item_id

1 × SELECT a.* 
  FROM jgpqv_zoo_item AS a 
  LEFT JOIN jgpqv_zoo_category_item AS b 
  ON a.id = b.item_id

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

1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM jgpqv_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN jgpqv_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN jgpqv_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1,5) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-25 19:21:24') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-25 19:21:24')

```
1 × SELECT id 
  FROM jgpqv_menu
```

OTHER Tables:

1 × SHOW FULL COLUMNS  
  FROM `jgpqv_virtuemart_userfields

1 × SHOW TABLES LIKE "jgpqv_virtuemart_configs

1 × 
  SET SESSION group_concat_max_len = 104857

1 × UPDATE `jgpqv_extensions` 
  SET `params` = '{\"mediaversion\":\"fe275440b9a32049fbe424fe7f6ce42a\"}'

1 × INSERT INTO `jgpqv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('b7d25311c00ec65aacd33aa00a7f476d', 1, '1761420084', 0, '', 0

Warning

Online Suicide Prevention Courses

Level 3 QPRT Suicide Risk Assessment and Management Training Pro

QPR for Occupational Therapists, Physical Therapists, and Health Care Providers

QPR for Nurses

Level 2 QPR Suicide Triage Training

QPR for School Health Professionals

QPR for Veteran Care Providers

QPR for EMS/Firefighter

QPR for Sports

Counseling Suicidal People: a Therapy of Hope

Ethics and Suicide

How to Help Someone Considering Suicide and Unmake the Forever Decision

Online Counseling and Suicide Intervention Specialist (OCSIS)

QPR for Clergy

QPR for Corrections

QPR for Crisis Volunteers and Students

QPR for Law Enforcement

QPR for Pharmacists

QPR for Physicians, Physician Assistants, Nurse Practitioners, and others

QPR for Psychosis

QPR Screening Course

Continuing Education Credit

VM - Shopping cart

VM - Search in Shop

VM - Currencies Selector

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

68 Queries Logged 19.19 ms

8 duplicate found!

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: